WoW Warlock DPS Spreadsheet

• 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

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 issues as reported by the 3.0.2d comments that I said I fixed.

Fixes the load/save item set that I broke with armory importation

Fixes alot of DIV0 errors where I wasnt doing error checking.

Added Demonic Empathy model.  It’s not pretty though.

Added CoE/CoR to damage calcs so vlookup will find them.

And a few other fixes which I don’t remember atm.

Version 3.0.2e warlock_dps_v302e

New version has a much desired import from armory feature for the Gear_Buffs page.  Input your character information on the ArmoryInfo sheet and then press the button on the Gear_Buffs page and voila (crosses fingers)!  You may notice popups about items not being supported, enchants not being found, etc.  Copy that info and post it as a comment and I may or may not fix it depending on what it is(new items won’t be added).

And in order to give credit where credit is due, thanks to Cheeky and his hunter spreadsheet for without me being able to copy, paste, and modify none of this armory importing thing would be possible.

Other than that… the bug fix I mentioned in the 3.0.2c comments got in.

Voila : warlock_dps_v302d

Fixes various issues reported on EJ and in comments for 3.0.2b.

- Felhunter MPS for shadowbite

- Dark Pact cycle

- TNS-spirit

Not fixing requests to fix item stats or add new items.  Wrath will be here in less than a month at which point all these items will be pointless.  I’m more concerned with making sure the calculations on the sheet are correct than making sure every possible piece of gear is accurate and included.

A note on items and how much dps they contribute.  Currently how items are valued is by using the TNS values.  The spreadsheet calculates your current stats on the DPS sheet and then uses those stats+1 on the respective TNS and then performs a diff on the respective dps.  This tells us how much an additional point of a given stat would contribute to dps.  We then use those stats to determine an items dps value.  This is not a great way to determine how much value a helm will add as chances are you’re already wearing a helm in the spreadsheet and thus the values arent going to be entirely accurate.  I’m hoping I can think of a better way to calculate TNS over the next few weeks, but who knows.  So what all this really boils down to… if you’re hit capped, the values for better items may be difficult to determine as TNS will ignore the value of hit once you’re hit capped.  Something to remember is that no item provides a static dps value.  How much an item improves your dps is variable on all your other stats.  Our stats are a big balancing act, so good luck trying with it

Here ya go: warlock_dps_v302c

Hello all.  As some of you may know from reading the EJ post, I(Bakka of Kalecgos) have taken over the spreadsheet while Leulier has given the addiction we all know as WoW. :)   So without any further delay here’s version 3.0 of the spreadsheet.  There are still a number of issues which I plan on fixing between now and wrath.  So as to avoid any unnecessary posts, here’s what I’m aware doesn’t work/has changed.

• Removed lag from calculations
• The Next Stat(TNS) equations are out of whack.
• Healing gear isn’t included in the items list.  Unfortunately I have no intention of adding healing gear to the list of items at this point.  You can add a custom gear and set the stats yourself if you’re using one.

Warlock DPS Spreadsheet v3.0.2a

So please feel free to comment here or in the EJ post with any problems or suggestions you have.

Thanks,

Bakka

New Feature :

• Added a “hit option” in the Items tab, with the following options :
  • ignore hit
  • hit as crit
  • hit as haste
  • ignore after cap

  This allows you to change the way the “Hit*” column is computed regarding hit rating of the items

• Added a “none” option to all the enchant slots
• Added legs enchant options
• Changed Heroism / Bloodlust to take into account other haste effects
• Added Blood Fury (Orc racial)

Items :

• Added Power of the Scourge shoulder enchant (Sapphiron drop)
• Added Blade of Wizardry proc
• Chaged the Shattered Sun Pendant of Acumen proc to trigger on dot

Added new elixir combinaisons :

• Adept’s Elixir+Mageblood
• Adept’s Elixir+Draenic Wisdom
• Adept’s Elixir
• Elixir of Major Firepower
• Major Shadow Power+Mageblood
• Major Shadow Power+Draenic Wisdom

Fixed items stats (thanks to Zathrus) :

• Dark Conjuror’s Collar (stamina and intellect revesed and red socket instead of blue)
• Voidheart Crown (stamina and intellect revesed)
• Mana-Binders Cowl (stamina and intellect revesed)
• Handguards of Defiled Worlds (stamina and intellect revesed)
• Mantle of the Malefic - has 46 spell damage (was 50)
• Leggings of Devastation - has 60 spell damage (was 65)
• Trousers of the Astromancer - has 54 spell damage (was 54+27)
• Malefic Girdle - has 36 spell damage (was 34)
• Ruby Slippers - has 35 spell damage (was 0)
• Merciless Gladiator’s Dreadweave Mantle - has 13 spell hit (was listed as 13 spell haste)
• Gladiator’s Felweave Amice - has 12 spell crit (was listed as 12 spell hit)
• Vengeful Gladiator’s Dreadweave Mantle - has 16 spell hit (was 13)
• Vengeful Gladiator’s Felweave Raiment - has 33 spell cit (was 23)
• Hatefury Mantle - has 24 spell crit (was 27)
• Brutal Gladiator’s Dreadweave Robe - has 0 spell cit (was 30)
• Radiant Deep Peridot is now green

warlock_dps_v27

• Added missing bonus for cloak socket
• Fixed a bug with Ember Skyfire Diamond intellect bonus not beeing taken into account.
• Fixed Vindicator’s Silk Cuffs crit rating (was 17 instead of 15)
• Fixed Merciless Gladiator’s Felweave Amice sockets
• Added Season 4 items

warlock_dps_v26

• Correction : Leggings of Channeled Elements has 59 dmg, not 64
• Corrected a bug in OpenOffice when selecting “none” as a gem.
• Change Heroïsm/Bloodlust/Drums of Battle from checkbox from to 0-4 list
• Added a “should I switch to fire ?” info box in the Raid ISB tab wich contains information to help you to chose between destro-fire and destro shadow.
• Added items :
  • Tattered Cape of Antonidas
  • Ring of Omnipotence
  • Handguards of the Defiled Worlds
  • Sunflare
  • Fel Conquerer Raiments
  • Shifting Naaru Sliver
  • Shattered Sun Pendant of Acumen proc (Aldor / Scryer / none)

warlock dps spreadsheet version 2.5

Small release, mostly improvements and bug fixes.

• Timbal’s Focusing Crystal proc dps added to the dps total and on the Items tab. Assumptions : 10% proc, 15s CD
• Added Improved Seal of the Crusader on the “Debuff” Section on the DPS tab.
• Vengeful Gladiator’s Battle Staff stats fixed
• Changed the Bloodlust/Heroism formula when the life tab mod is “oom_time”.
• Fixed a error in the DPS diff (no hit) for weapons

warlock_dps_v2.4