I just downloaded the spreadsheet and I'm having trouble figuring a few things out.

I want to use the spreadsheet to see if I should switch any pieces out, but I'm having trouble figuring out how hit is taken into account.

I have 13% hit on my gear and 1% hit from talents (then I use misery to get to 17%). I think misery is taken into account on the spreadsheet. Considering this should put me at the hit cap, I'm confused why my DPS goes up slightly when I use the 40 hit food. Since I'm capped at 17% shouldn't the extra 40 hit rating do absolutely nothing?

Also, the spreadsheet says that for my gear set each point of crit is worth more than haste. Is this because I have so much haste already? I was under the impression that haste was more valuable for affliction warlocks.

Thanks!

Edit: Apologies for the egregious offense of providing a link in a post. My bad.

13% hit is actually 341.02, you have 341 from gear. How much DPS increase are you seeing? If it's quite a bit, and not a fractional increase as one would expect from .02 hit rating, ensure that the Misery field is actually checked off on the DPS tab.

EDIT: changed from Gear_Buffs tab to DPS tab as pointed out below.

My DPS goes from 5124 to 5155 when I enable the 40 hit food.

I searched all throughout the Gears_Buffs tab and couldn't find any option to enable or disable Misery. Where is it located?

Assuming the latest version is similar to the one I use (don't have office 2k7), then it's on the DPS tab, under debuffs, and Imp FF/Misery should be set to 3.

I have posted a 3.1 preview version @ 3.1 Preview Version - Warlock DPS Spreadsheet

Keep up the good work!

First off, I want just want to thank Bakka for this spreadsheet.

I finally got around to hitting 80 on my warlock, found this spreadsheet, and started tinkering. I am currently using a variation of the 55/15 Felguard build, and thought the spreadsheet had my dps a lot higher than I felt it should be. This got me to start looking into the formulas and settings to see what I was inputting wrong.

Right off the bat I noticed I had some things wrong with my Felguard setup in the spreadsheet, so I started looking at those formulas, and couldn't figure out why it was showing his AP to be MUCH higher than it was. Looking at the cells that it referenced and doing the math myself, I couldn't come up with the figure that Excel was giving me.
With my current stats/setup this should have translated to =(608+947+0) or 1555. However, my Excel is telling that this formula equals 3011. If I remove the () it results in the proper answer. I'm a complete Excel nub so I don't understand why adding the () would result in a different answer.

What I would like to know is if this is simply an error/bad configuration somewhere on my part, and to draw attention to it for the benefit of others if not. I notice in this thread that Nenad brought up some dps differences with his FG, but haven't seen anyone touch on this particular miscalculation.

edit 4/8/09 - I also noticed the calculation for a Humans spirit is wrong. The current calculation for their racial spirit bonus is making the calculation based off of their total spirit, and it should be calculated only off of their spirit granted via items. The change I made to Gear_Buffs!M126 is:
I see where I nubbed up the top part now

I believe I've found a bug (two actually) in version 31a that becomes apparent when Immolate is used, especially with Backdraft. The symptom is that the Next Stat section of the DPS sheet shows large negative values (~-40 per point). The Gear sheet shows resulting poor recommendations.

I think a fix is to remove one of the two "(1+0.03*aftermath)*" parts out of both B64 and B72 in the DPS sheet. I have used Bugzilla to report the behaviour and proposed fix to Bakka.

I'm working on a tutorial for how to setup and use the spreadsheet for new users. I know Bakka is very busy, so I'll ask users this one question:

When in the Gear tab, you have two columns for the value of an item. You can change the Hit column to "ignore after cap" but there are other options there: Hit as Crit, Hit as Haste.

Can anyone tell me what those two options are for?

I think what it does is performs a thought experiment: if you replaced the hit on this item with <haste, crit>, how would this item be sorted?

This (I think) is a somewhat weird method of enabling gear selection when you're at the hit cap. For example, when you're at the hit cap, all gear with hit gets ranked badly. But if taking a piece of hit gear allows you to sub in a piece with better stats for you (e.g. haste for a destro lock), then it's still an upgrade. Hit as haste allows easy spotting of these two-stage upgrades.

Dunno if you already made something with regards to this, but if not, here is some implementation for the t7 4p bonus:
Changes are to v3.1a

Added value to 'Advanced infos'!E5: Added value to 'Advanced infos'!E6: Forgive me if there is something I have forgotten, but should accomodate for kings, glyph of LT, Daemonic Aegis and your LT freq.

Now, to ensure this is added to your stats, I've appended the following to Gear_buffs!G83:
Feel free to make these modifications yourselves if you can't wait for the next version. Hope it is of use to you.

Oh, and as an aside, personally for me (avg itemlevel of around 217, affli lock), the 4p bonus, with glyph of LT, adds up to 59.4 SP, making 4-piece a clear choice over almost any other gear combo for me personally.

Important note: Doesn't work if you set LT freq to below 10 (but neither does glyph of lifetap if you set freq to below 20). But too late to make the changes, as it's 3 am here. User beware

An addendum to my post above.

First off, a correction to field 'Advanced infos'!E5, as I realized it produces 0 if you have not set Fel Armor to on, while it should produce E6*(glyphlifetap modifier)*frequency of lifetap. The following code should be more appropiate:
And the culprit for the "do not put freq under 10 (for 4p bonus) or 20 (for LT glyph), should be this factor:
If you change to :
it will prevent the factor from going into undesired values. Same can be done for the glyph, just replace 10 with 20.

Thus, the final entry in E5 should be:

Website down right now?

Warlock DPS Spreadsheet -

Nuff said. Changed site.

EDIT: Also, I know it's a WIP for any spec but Haunt, but I noticed a bug you might not be aware of.
When working with 40/31, when Immolate and/or Incinerate -> Soul Fire (but not Incinerate also) is set to being used, there is a bug (prolly originating from the TNS- sheets) in the "The Next Stat" part of the sheet, where all the "dps bonus" fields suddenly turn negative. I do not have the expertise to find a fix, but hopefully now that you know of the bug, if you didn't already, you will be able to fix it

EDIT2: Think I see the issues. The damage calculation for immolate and the filler spells, are not the same as used in the main DPS sheet, also Incin -> SF points to UA instead of SF in all the TNS- sheets.

New version 3.1a at Warlock DPS Spreadsheet -

First, thanks to Bakka for a superb resource. Sir, you are a Gentleman and a Scholar.

I've been playing with the spread sheet and looking in particular at the dps stats for each of our pets. The prevailing wisdom in game atm seems to be that for Afflicrtion spec, Succubus is the best pet to use for DPS, followed by the Fel Hunter. However, the stats on the Pet DPS tab of the spreadsheet don't seem to reflect this.

With my current build 51/3/17 and gear the spreadsheet shows a clear advantage in raw dps for the Imp.

Imp : 445.23
Succy : 298.19
Fel Pup : 369.11

On top of this he also benefits from raid DPS buffs like totems or Moonkin Aura.

Add the fact that A ) he takes almost zero management, B) has enough HP to survive Splash / AoE / Boss Effect damage he might take while stood next to me and C) never goes OOM, and the Imp seems, on paper at elast, to be by far the best Pet for Affliction spec.

Does anyone else have any solid data on this from raiding, am I right or have I missed something fundamental?

I'm doing the same, and yes you still need to fix the IFERROR module as for the last version.

Updating from the armory is still broken as well, or at least it was for me but that could be connection issues and not the spreadsheet.

I'm also getting the error in the DPS field but wasnt getting any error when using v3.08b in Excel 2007. What is this fix we need to implement?

If you are using excel 2007, you dont need to do any fixes (or shouldnt). What you may need to do is to turn off nf/glyph proc on the DPS page and then turn it back on if you are affliction spec or have the corruption glyph selected or else leave it off. There is something funny with that area that causes issues.

For everyone using a version of excel older than '07, you should look on page 10 of this thread, it is all explained there.

I recently did some tests regarding pets time to OOM, and here are new formulas (if someone want to include them in spreadsheet):

Imp_INT= (369+0.3* Player_INT)*(1+0.05*Fel_Vitality) * Buffs
Imp_Mana= 1175+ 4.8* Imp_INT
Imp_combat_mp5= PlayerINT* 25% + 50

Other_Pets_INT= (150+0.3* Player_INT )*(1+0.05* Fel_Vitality) *Buffs
Other_Pets_Mana = 1559+ 10.8* Pets_INT
Other_Pets_combat_mp5 = PlayerINT* 20% + 45


While formulas for total _INT and _Mana exactly match test data, formulas for _combat_mp5 are approximations, but good enough for usage here.

New version 3.1b at Warlock DPS Spreadsheet -

I noticed a few things with pet mana also. I believe that if you remove mana feed, the sheet is still assuming you have it and the total mana return from mana feed does not get removed from the chart. No pet seems to have an actual positive oom time. Also it doesnt seem that the pets (atleast Felguard) are receiving raid buffs pertaining to mana. I notice in game raid buffed, my Felguard has closer to 10k mana and not the 7k-ish the sheet is listing, IIRC. It does have about 7k unbuffed though. This doesnt really effect anything *if* pets really never run out of mana, just an observation really. My pet never runs out because I have Mana Feed and Life Tap Glyph, so I am constantly feeding him mana anyway.