Warlock DPS Spreadsheet

And thus my support for this sheet will dwindle.  The account on which my lock resides is no longer active as of today so my ability to test the reliability of equations is no more.  Any who wish to take over the project please feel free to contact me and I will give you admin access to the site to continue supporting it.

Nothing major happening in this version.  A few fixes to some enchants that weren’t importing from armory, some fixes to certain equation.

As usual please report bugs to www.bakkadps.com/bugs

Excel 2007 Spreadsheet: warlock_dps_v312b

Lots has gone into this version. 

First off I changed TNS slightly.  Instead of a straight +1 to the formulas I did +10.  The TNS-spirit was giving an over inflated value due to rounding and changing it to +10 evened it out.  So I went ahead and did it for the rest of the stats to help eliminate any potential rounding errors that may be occurring with those stats as well.

Made all the 3.1.2 warlock changes.

Changed the conflag model to work for glyph of conflagrate.

Added the procs for a few more trinkets.

Fixed bugs that were reported on the bug site : www.bakkadps.com/bugs

And finally here we are : warlock_dps_v312a

So I’ve been sitting here in front of a target dummy, naked as a jaybird trying to figure out the math behind conflagrate.  And I’m stumped at least when it comes to using conflag against immolate.  So I’m a naked orc with no fel armor up.  I show 0 for my spell damage.  I cast immolate: 667 dd, 5 x 237 (dot).  Cast conflagrate at any point during that time and 982.  Now this clearly doesn’t add up.  237 x 4 = 948.  There’s something I’m missing which contributes to conflagrate dmg in regards to immolate.  If you perform this same experiment only with shadowflame you find that the total dot dmg from SF is the amt of dmg conflag deals.  So it leads me to believe that the initial DD portion of both spells is not included into the conflagrate dmg; only the dot portion.  And for SF this holds true for as I added on more pieces of gear.  All the way until I put on 2pc T8 at which point conflagrate does more dmg than the dot portion of SF.  I’m guessing this is some sort of bug related to how 2T8 affect immolate dmg.  And it’s not an exact 110% increase to the conflag/SF dot ratio.  So yeah…

So anyhow if anyone has run across any enlightening data in how conflag is working these days, esp. in regards to immolate, please post it up.

More bug fixes that were reported.

Also added a new hyperlink to wowhead which uses your TNS values to come up with weighted item listing.  This can be found on the DPS sheet next to the TNS values.

And as always please report bugs on the bug site www.bakkadps.com/bugs

warlock_dps_v31e

New version fixes issues reported against 3.1c.

I made changes to crit calcs in 3.1c.  I had errors in a few formulas which I have corrected in this version.  Some people reported incorrect formulas which were not incorrect; those formulas were not corrected.  Please make sure when reporting problems in formulas you understand the formulas.

warlock_dps_v31d

As always please report bugs and enhancement requests to the bug site: www.bakkadps.com/bugs

More bug fixes as reported on the bugs page www.bakkadps.com/bugs

warlock_dps_v31c

Sorry no rights!

New and improved. Fixed most of the issues that were reported with 3.1a as found on the bug site www.bakkadps.com/bugs

warlock_dps_v31b

Not a lot to say other than here you go. Too many things have changed and been added to remember what I’ve done. Any issues you find or enhancements you would like to see, please comment here and/or post on the bug submissions page www.bakkadps.com/bugs

warlock_dps_v31a