New Affliction DPS Spreadsheet!
 

Since Leulier has not yet been updated for WotLK, I decided to create a brand new DPS calculator to figure out what the best stat is after hit and spell damage. IE, the age old question: Crit, Haste, (and now) Spirit?

But most importantly, I created this because I wanted something that is user-friendly: both simple and easy-to-use. (As well, make the math extremely easy to follow for those of you interested.)

Here is the link:

Vux DPS Calculator.xls

Please check it out and see if my math is correct. And of course plug in your stats and see which is the next best stat :)

We are not worthy! We are not worthy!

That said, I'm pumped to have some form of a spreadsheet again, but I'm curious about some things:
There is a lack of benefit shown for spirit outside of the damage gain, the spirit is calculated purely at 30% the value of damage as far as DPS gain, I think this is a fallacy. Of course, I'm sure you intend on updating it as time comes along to factor more complex variables like that, and to add more inputs for hit (I see it assumes hit is at 100%, I figure that is because you'd want to be hit capped before getting other stats, but some tradeoffs may be worth it.)

But that will come with time, I'm sure. Otherwise, nice work.

To users out there, I'd use it more as a general guide of what to gear for instead of a hard fast rule of what to do for maxx DPS.

Does it factor in any raid buffs?

Nice work. I"m still checking it out more thoroughly, but it seems like you forgot to include spell haste on instant spells to reduce the GCD. With 20% spell haste, all instant casts would be reduced to a 1.2 second GCD. If spell haste still works the same that it did as of 2.4, the GCD can't get lower than 1 second, meaning CoA wouldn't be affected if you had Amplify Curse.

I realize that Spirit lowers the number of global cooldowns for Life Tap over the course of a long fight. However, at least for the initial version, I didn't want to get into calculating the mana usage per spell towards how much mana each rotation uses, especially with complex variables that may vary from Warlock to Warlock such as having access to Replenishment, Judgement of Wisdom, Improved Water Elemental, Mana Tide, Mana Spring Totem, and double-tapping with 4 piece T7. I thought it would be best to keep things simple and say 2 Life Taps per minute. KISS (: (If anyone wishes to change that, just modify the first cell to the right of "Life Tap".) (Keep things simple -- at least for the first version anyway!)

As far as the DPS gain from Spirit, the calculation there is a simple 30% of the DPS gain from the Spell Power one. However, if I add another section just for adding 10 Spirit (or 3 damage), the result would be the same. For all intents and purposes in terms of how Spirit affects the damage output of spellls, 10 spirit = 3 damage. This can be verified by changing the +10 Spell Power in Sheet 2 cell C2 to +3. The DPS gain from this 3 Spell Power will be the same as what the +10 Spirit calculation was reporting before.

In terms of Hit, yes this is assuming that the Warlock is hit capped. Most of the Warlocks who would use a spreadsheet like this are either already at the hit cap, or know the importance of getting themselves it. I can add a calculation for it though just for reference.

For raid buffs, I took the same approach of simplicity as before in that one of my goals was to make this spreadsheet user-friendly. I didn't want people to have to click click a dozen or two buffs/debuffs on or off. The beauty is that anyone can just plug in 3 numbers (Spell Power/Crit/Haste) and bam, done. Just plug in numbers at raid-buffed levels and all the math will be reflected accurately. I might look into adding this functionality in the future, but for the first version I just wanted to focus on the math and make sure the foundation is stable before adding the floors.

Thank you for the kind words (:

This is a tricky situation. I was reluctant to include haste's effect on global cooldowns for the simple fact that if you shaved 0.03 seconds off the global cooldown, most people really aren't going to cast their dots 0.03 seconds faster. But for the purposes of accuracy, I will include it in the next version.

Thanks for the feedback! I'm glad you guys are liking it. (: This is a work in progress and as always, feedback is much appreciated.

Actually, the one thing I'm most interested in getting from a spreadsheet is the relative value of hit and spellpower when below the affliction hit cap. The importance of hit-capping is, believe it or not, debatable. I know for mages it's not worth it until over 1500 spellpower or so, and I think affliction cares about it less than just about any spec (even account for haunt).

The thing I'm second-most-interested in is finding out if demonic aegis is as bad as I think it is, but changing spirit from .3 to .39 of spellpower isn't too hard to do manually.

Updated 12-11:

Added Hit Calculations
Added Haste to GCD Calculations
Added DPCT Column on right side for reference
Switched Glyph of CoA to Glyph of Immolate
Added Molten Core
Updated Talent Build
Added parenthesis in math column around Haunt/Shadow Embrace, Glyphs and MC/ISB multipliers for readability

Check out the new version; I added hit calculations! After playing around with it a bit, if my math is right it looks like Hit is better than Spell Power as long as you have over 1500 Spell Power or so? That seems to be the break even point. If anyone wants to comment on that more, or point out any errors, please feel free.

Anyway, 758 downloads on the first version! Thanks everyone! As always, comments and feedback appreciated.

We don't need 2 spreadsheets when we have one fully functioning one already being updated:
http://elitistjerks.com/f80/t38695-l...s_spreadsheet/

Thanks for your hard work on this one, but I'd recommend putting your efforts towards unifying the class under the umbrella that is Leulier. Resistance is futile!

Leulier's isnt fully working or accurate right now.

Then help get it accurate. The spreadsheet posted in this thread isn't any more accurate itself. Why are we replacing something just because it's a little off instead of telling the people who made it how to fix it? There are 500 posts saying "it's off" and I have yet to see a single one say WHY or HOW it is "off". Post some concrete data please and I'm sure the creators of the main dps spreadsheet out there will update it post haste.

It's a perfectly functioning basis for theorycrafting and we shouldn't just abandon it for no good reason. I really don't want to spend all the time helping some random new person develop their spreadsheet when we could just help the same old awesome excel wizards fix whatever may be broken in theirs.

And Leulier's is fully working right now if you know how to use Excel. It works quite well for me, so I'd love to hear where it's broken.

I posted in the thread some initial things to fix already. I'll continue to do so after each revision is posted. I'm all for good resources too, but I'm not going to tell someone to stop developing their product. If they both tell us the same thing, then that means we worked out the math right. If they are showing different things then that just shows that we have more work to do.

That's definitely a valid point, however wouldn't the resources of the individuals capable of excel work best be spent corroborating on one project rather than "competing" on several just so that we can "see what comes out of it"?

Monopolies are always better than Capitalism right? ^_^

I have been working on my spreadsheet for the past few weeks, since Leulier's had not been updated for a month. I posted mine days ago when we had no idea when the next update of Leulier's would be.

Finally, it was updated today, ironic timing, but after all the hard work I did, I'm not just going to throw it out without a second thought. Coming in here after I spent so long on this and telling me to just stop is a bit insulting.

In any case, our spreadsheets have different uses; for example, the math in mine is clear and easy to read. If I want to make corrections and updates to my spreadsheet, I will. Plus, there's nothing wrong with having options. [=

Does your Spreadsheet support OpenOffice? I know Leulier's doesn't at the moment, so this would be a real advantage...

works fine in Open Office 2.4

Unfortunately, you're math is off.

For a spec as complicated as affliction, spell hit can't be calculated with your simple (finaldps = dps x (.83 + hitchance)) calculation. That works for sac/destro shadowbolt spam, but not this spec.

For instance, if CoA misses, I dont lose CoA's dps for the next 28 seconds. I just cast it again. All I lose is 3/5ths of a shadowbolt and CoA's dps for the GCD.
Likewise, if haunt misses, I dont just lose the haunt damage, I lose 20% dot damage for the next 10 seconds.

Since the value of hit vs spell power is just about the most relevant piece of information an afflic lock is gonna get from a spread sheet, it really needs to be modeled accurately for the spreadsheet to be of any value.