WoW Warlock DPS Spreadsheet

Due to the bullshit from the user below I’m ceasing my involvement on this project for a while.  Or rather I’ll still be working on it, I simply won’t be publishing my changes because I’m a lazy fuck.

If I had full admin of this site, I’d of simply banned him instead of resorting to stopping publishing of the sheet.  But, I don’t; so in order for this douche bag to not get updates, everyone else has to suffer and for that I am sorry.

Peetown
mdolejsi@gmail.com | 209.165.132.3
God damn you’re such a lazy fuck. I’ve fixed it already sure… but its not that hard for you to just to just apply the same fix to the 2007 version and upload a fixed version that will work for both 2007 and 2003. I really do appreciate all that you have done for this spreadsheet, but it doesn’t seem you really care enough. You say you’ve added minor changes that will be in the next version, but yet that version wont come out for 1-3 months? Whats the point? Why not just release a new version with the few changes there are?

From Spreadsheet Version 3.0.8b, 2009/03/02 at 6:24 PM

Fixes

• Prevented cyclical refs from erroring out through use of IFERRORs
• Updated Chaosbolt base damage to 1410
• Fixed Majestic Dragon Figurine proc to be spirit instead of mp5
• Added Purified Twilight Opal
• Replaced Soulstone with Spellstone in Immolate dot calcs
• Updated Potion of Wild Magic to be 200/200 dmg/crit
• Added Tuskarr’s Vitality enchant
• Added Extract of Necromantic Power’s proc
• Added lots of FG changes based on Nenad’s post here: http://elitistjerks.com/1073078-post206.html
• Changed Backdraft calcs in TNS sheets to point to the correct dmg (B57 not Models!B14)
• Changed Immolate Duration/Frequency to include glyph of conflag.

warlock_dps_v308b

Fixes

• Removed duplicate gem entries
• Added Intricate gems
• Fixed mana calc when using glyph_corr
• Added 0s to fields in Items which do not have stats.  This should hopefully fix non excel 2007 version users getting bad numbers for the values when attempting to determine max/min calcs where a value was null.  excel 2007 assumes null is zero.
• Updated Glyph of CoA calcs
• Generic item refresh
• Added Greater Fort and Spell Piercing enchants
• Updated Illustration of the Dragon Soul proc bonus
• Changed Glyph of Conflag to not remove last tick of immolate.  Still only assuming 1 conflag per immolate (will probably change this in the future).
• Removed bonus from glyph of fel hunter to crit for bite.

warlock_dps_v308a

This is not a post for a new version, but for collecting changes in 3.0.8 that need to be done.

Currently I’m not listing anything here because though I know of some of the changes which are going into 3.0.8, I don’t know all the details.  So when you see any changes and know the details around those changes please post here.  eg. I know glyph of conflag and agony are changing, but are the original effects being removed as well?

Also I spent 30 seconds googling how to run VBA macros in open office and found that if you download the novell version of open office (instead of the sun compiled version), they work just fine.  So for all you open office people, I suggest installing novells version which has vba support.

FYI, this is probably the last version I’ll publish until 3.0.8

Fixes

• Fixed bonus lookup for rings
• Added Spirit/Hit gems
• Added Fel Intelligence to Gear_Buffs
• General update of items
• Fixed the Ignore after hit calc for Items so it uses base_miss and includes misery
• Fixed NF cast Ratio (was ignoring glyph)
• Added T7 2 pc bonus.
• Fixed bloodlust calculations
• Added Firestone to SB and Immolate calcs
• Added Soulstone to Immolate calcs.
• Added Pendulum of Telluric Currents proc
• Added a fire spec template 0/20/51

warlock_dps_v303k

Fixes

• Added BoK support for TNS-spirit
• Added separate gems and enchants for rings and trinkets and their subsequent bonuses.
• Fixed metagem import
• Fixed weapon sorting.
• Added BoK to TNS-int
• Added Human racial to TNS-Spirit
• Readded the 1.701 base crit chance
• Added the haste, crit, and hit yellow gems
• Removed the spell dmg bonus from Master Conjuror talent.
• Changed Blood Fury racial to L80 version

warlock_dps_v303j

Fixes

• Updated base dmg for immolate to L80 version
• Fixed a few pet DPS equations to make it a touch more accurate.  Still a long way to go.
• Added belt socket and hopefully fixed the gear import so everything imports properly. (Thanks Whitetooth)
• Changed human racial bonus for spirit from 10% to 3%
• General item update.
• Added more gems and metagems
• Fixed weapon dps sorting.
• Fixed dps diff for hit column.
• Removed spell dmg addition from improved moonkin aura.
• Fixed Load from Talents for Master Conjuror.
• Fixed L80 base stats for all races.

Additions

• Have begun preliminary work for on use and procs for trinkets.

To Do / Known Issues

• Add more trinket procs
• Add other procs (from enchants or gear)
• Figure out how to properly model T7 bonuses
• If there are gems which arent in the list of gems that you use, please make a comment saying what you’re using and I can try and add it for future versions.

warlock_dps_v303i

Fixes

• Talent import of Fel Synergy and Imp DT fixed
• Gear Import for LW bracer enchant should now work
• Affliction debuffs increased to 15 for soul siphon
• Fixed formula for int to crit
• Haunt template fixed to be more 80s compliant.
• Imp Incin template fixed to be more 80s compliant. Relabeled to 0/31/40

Notes:

• Pet DPS is inaccurate.  I’m aware but without help there’s not much I will do.  Start by posting the L80 raw stats of the pets.
• Items which have an on use or proc effect STILL don’t have their use or proc effect included in dps; please quit asking about it.  I’m more interested in having an accurate spreadsheet than I am at making sure every proc and use effect in game adds to an incorrect dps value.
• No, I’m not adding T6 gear back into the spreadsheet.  There are clearly better items out there and I’m not adding them to the spreadsheet just because you dont have them yet.
• ‘My spreadsheet doesnt work’ comments.  Sorry, but I provide the spreadsheet as is.  If you’re running Open Office, Excel on Mac, don’t have certain modules installed that this spreadsheet uses, etc. and you can’t get this sheet to work, sorry but you’re on your own.  I’m only one person and I don’t get paid for tech support.  I encourage asking the community if they know how to fix your issue, but don’t expect a response from me.
• Someone suggested a usage guide for new people.  I encourage anyone who wishes to write one to go ahead, but I do not have the time to do one myself.

warlock_dps_v303h

Fixes

• Additional affect of Demonic Aegis on spirit bonus from fel armor added
• Master Conjuror affect to %dmg on stones added.
• Exceptional Spellpower to gloves fixed.
• Added potion bonuses for hit and haste to gear_buffs.
• Fur Lining - Spell Power added to enchants; if someone knows the actual text on an item which is enhanced with this, please send it to me so armory import will work for this enhancement
• Fixed hit value column under items sheet just being a number and not a formula.
• Fixed ISB model for when filler was set to SB -> Drain Soul
• Fixed Demonic Tactics for pets from 1% to 2%
• Fixed Everlasting Affliction for UA
• Fixed Armory Import for Soul Siphon and Improved Corruption

warlock_dps_v303g

warlock_dps_v303f

Fixes:

• Added Rare LK Items to the list of gear.
• Fixed Drain Soul not being affected by Soul Siphon.
• Added some more consumables.  Continue to let me know if there’s something not on there.
• Added Shoulder Inscription of the Storm
• Removed ToW and Scorch from the Pandemic calcs.
• FIxed certain enchant stats not showing up on gear_buffs even through present under enchants_consumables.
• Broke the link to my items update spreadsheet.

Notes:

• Anything with a proc or use effect has yet to be implemented.
• LK set pieces have yet to be implemented.
• Eff Rawr.  I have no intention of ever working with something that takes longer to load than it does to use.  It was great when it was just for druids.  But now that the default dl includes every class and spec known to man, it takes forever to load.
• As I posted a month ago in the 3.0.3d notes, if you have a spec you want included then post a link and if it looks good I’ll include it.  I don’t have a lot of time these days to look play around with specs, so I honestly have little clue on what decent specs are these days.