WoW Warlock DPS Spreadsheet

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.

This will probably be the last release for a few weeks.  Wrath is here in 3 days and I have 2 70s which will be requiring my attention

And as you can see from the todo list, there’s a ton to do.  So, I won’t be releasing the next version until I’ve taken care of most of the L80 additions and fixed anything you guys find wrong with this version.

Fixed:

• Fixed more TNS issues where TNS was referring to the Models page instead of the models on their own page.
• Added Flametongue to buffs.  It’s with Totem of Wrath.
• Removed talent templates which were no longer accurate.  If anyone has suggestions for talent templates, please post a link to a talent calc and I’ll consider including it.
• Added Master Conjuror to talents.
• Removed dot_gap from haunt duration.
• Updated spell damage values for those of L80
• Updated hit / crit / haste ratings required at 80 for 1%
• Updated some Buffs @ 80.  Still have more to do once I get more data on these.
• Removed Oils from Buffs
• Readded SB -> Drain Soul

Known To Do List:

• Fix other classes L80 buffs
• Add L80 consumables
• Add L80 items
• Fine tune the SB -> Drain Soul model
• Update L80 race stats
• Add L80 enchants and gems
• Update pet stats @ 80.  Half done already; I did skills.

Here: warlock_dps_v303d

• Fixed TNS not using the correct spells.
• Added lifetap data to tns-spirit.
• Added gcd data to all tns sheets.
• Removed SB -> Drain Soul until Wrath goes live.  Rank 5 Drain soul does not have 4x.

Version 3.0.3c : warlock_dps_v303c

• Changed Corruption spell coefficient to 1.2. I already had immolate in 3.0.3a.
• Added GCD to all TNS.
• Changed Inspiring Presence to Heroic Presence
• Added Focus Magic buff
• Added SB -> Drain Soul as a filler spell for that 25% 4x increase to Drain Soul. Thanks to someone in IRC for reminding me SE and Haunt don’t affect SB. It’s kind of sloppy seeing as how there’s no good way to determine it’s cast time and mana consumption so I simply use those of SB. I figure they’re a worst case scenario for Drain Soul cast time and mana consumption.

Here: warlock_dps_v303b

Updated for 3.0.3 talent changes to SM, DT, and Ember.

Fixed UA to be a 15 second spell with 100% damage coefficient.

Added loading talents from armory.  This is done by going to the Talents sheet, loading, and then selecting Load from Talents on the DPS templates.

Fixed a few more DIV0 errors I found when using a succubus.

Fixed the molten core model for coa on tns.

Redid all TNS models so they’re more c/p friendly for me to keep updated

CSD was set to 1.09.  Changed it to 0.03 and made it additive with Ruin as opposed to multiplicative.

Fixed errors in equations involving T6 4pc bonus.

Fixed errors around immolate, incinerate, conflag, and chaosbolt spells.

Fixed issue with TNS for gear with procs.

Warlock Spreadsheet v3.0.3a : warlock_dps_v303a

Fixes TNS and Items.

Corrected the damage equations on a few spells.  SM, Improved Agony/Corruption, and Contagion are additive dmg increases; not multiplicative.

Warlock DPS Spreadsheet v3.0.2b