Leulier's Warlock DPS Spreadsheet

Bakka · 12/10/08, 2:35 PM

WoW Warlock DPS Spreadsheet

Now at version 3.0.3e.

• Nicarras · 12/10/08, 3:39 PM

Need to add all the new Meta's, there are some missing. Mark of the War Prisoner is a blue trinket, but still viable at endgame so it should be added. Also, not related to the spreadsheet but everyone with a Belt Buckle will have to set that to custom as Armory still doesnt show Belt Buckles.

Ossifrage · 12/10/08, 4:54 PM

1-Any chance of adding an option for doom/infernal?
2-Missing Engineering Goggles

<3 :: thank you for your hard work.

heemo · 12/10/08, 5:11 PM

First of all, thanks! Here's a few things that might need to be fixed/added unless I am overlooking something:

-Spellstones/Firestones not adding the 1% damage boost to dots/direct damage spells.
-Potions - Speed, Wild Magic, Runic Mana
-Scribe Shoulder Enchant: Master's Inscription of the Storm - Spell - World of Warcraft

One blue that would be nice to have added, if you ever have the time to add them would be [Wand of the San'layn]

Phearbot · 12/11/08, 4:32 AM

It seems as if the spreadsheet is not calculating 3% + hit from suppression and cataclysm. The value of hit stays the same regardless of these talents. Can anyone confirm? Or am I just missing something?

Also the value of drain soul is not affected by the number of affliction debuffs on the target, only the value of drain life is.

fip · 12/11/08, 6:27 AM

Originally Posted by Phearbot

It seems as if the spreadsheet is not calculating 3% + hit from suppression and cataclysm. The value of hit stays the same regardless of these talents. Can anyone confirm? Or am I just missing something?

Also the value of drain soul is not affected by the number of affliction debuffs on the target, only the value of drain life is.

If you look at where hit is calculated into spells, the cast time, you will see what you are looking for. For example, on the DPS sheet, cell C61, Chaos Bolt Cast Time:
=(MAX(gcd,(2.5-bane/10)/(1+haste/100)))/(1-MAX(0,base_miss-hit-cataclysm)/100)

Basically, since Cataclysm/Suppression only work on certain spells and the spreadsheet is flexible enough to handle an Affliction build casting Destruction spells (such as Shadowbolt like everyone does) or vice versa (such as CoA which most Destruction Locks do) then it can't simply give you 3% more base hit because that would not correctly reflect your hit cap on all your spells.

Rest assured that your hit is being tracked properly.

Koshir · 12/11/08, 6:27 AM

It would be nice to add belt socket

kaib · 12/11/08, 8:50 AM

Whenever I try to put in my 31/40 demon/destro imp/incinerate spec and then on the DPS sheet click on load rom talents, the sheet switches out incinerate for SB. Any idea if I am doing something wrong or if that's a problem with the sheet?

Bessa · 12/11/08, 9:15 AM

Just readjust the spells to Incin instead, nothing major.

fip · 12/11/08, 9:37 AM

Easier solution:
Format -> Sheet -> Unhide, choose Templates
in the Load From Talents column, set all the options for your talent build of choice. Save the spreadsheet. Now you will always have your talent build of choice able to be loaded on demand and compared against the default specs it comes with.

That's definitely one thing I'd like to suggest to Bakka is to update the default builds. These appear to still be the level 70 version of builds, for example Haunt doesn't have Ruin or many points in Destro, which drastically changes the dps for the build.

Daidai · 12/11/08, 11:28 AM

I am not sure, but it seems pandemic is using the hole crit for ua and corr.
But i thought it is not affected by scorch and ToW, cause these are mob-debuffs.

heemo · 12/11/08, 6:21 PM

One more quick bug: Demonic Pact and Totem of Wrath/Flametongue Totem are stacking though they shouldn't be.

Trickykid · 12/11/08, 7:45 PM

TNS-spirit doesn't count points in Demonic Aegis.

PSGarak · 12/11/08, 9:32 PM

Originally Posted by Daidai

I am not sure, but it seems pandemic is using the hole crit for ua and corr.
But i thought it is not affected by scorch and ToW, cause these are mob-debuffs.

While what you describe is how the game works, it's argueably a bug. The assumption that it's a bug and will eventually be fixed is often justification for not including the more complicated formulas in a spreadsheet. If you want, you can hack in a subtractive term that checks if iScorch/WC is enabled from the pandemic proc chance.

Aedius · 12/12/08, 3:41 AM

I'm currently using Microsoft Office Excel 2007 with the spreadsheet. There appears to be a few issues with the Hit* Value column (Column T) and "ignore after cap" hit option. There is a reference to the file's name which does not update when the file is renamed/moved. This I believe is an issue with Excel.

IF(hit_option="ignore after cap",MIN(MAX(445.91-'C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\[wowhead.xlsm]Gear_Buffs'!$J$4,0),H23)*value_hit,0)

This is easily fixed but the next problem comes from the min function there. It does not seem to work correctly if one of the values is an empty cell. This seems to be fixed by filling up the empty cells with a value of zero, another issue with excel. Finally, the formula does not seem to take into account the base miss and misery/imp faerie fire options under the dps tab. I think that is should look something like this:

IF(hit_option="ignore after cap",MIN(MAX(base_miss*DPS!$L$4-misery*DPS!$L$4-Gear_Buffs!$J$4,0),H23)*value_hit,0)