Bakka

WoW Warlock DPS Spreadsheet

Now at version 3.0.3e.

 

Nicarras

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

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

<3 :: thank you for your hard work.

 

heemo

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

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

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

It would be nice to add belt socket

 

kaib

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

Just readjust the spells to Incin instead, nothing major.

 

fip

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

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

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

 

Trickykid

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

 

PSGarak

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.

http://sig.gamerdna.com/quizzes/INFL...erks/Garak.png

 

Aedius

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.

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:

 

Daidai

Sure, i did that, i post it only as an information. I hope it is a bug and it will fixed (like SE).
Another point is DS, in the actual spreadhseet it is not working with the number of affliction debuffs.

 

Rozzenwyn

Is Illustration of the Dragon Soul implemented? It is showing up on the gear page but showing no DPS in the DPS column.

It seems like some of the lookup columns on the gear_buffs tab aren't working.

A few examples:

40 Haste & 40 Hit foods - the stamina gets filled in but the haste & hit do not. there are no formulas in those 2 columns. I tried adding in the formulas myself counting columns and such to try to get the right one because the info is on the consumables page but just isn't getting looked up. However that didn't work and instead broke the spreadsheet and then I was getting NA for dps.

Leg Enchants - None of the ones with a spirit component work right. Spirit is not getting looked up. Again it is in the consumables tab but there is no lookup formula in the gear_buffs tab. That's kinda a big deal considering how much better spirit is for us these days.

Can you add Fire Seed (I think that's the caster version) as another consumable.

 

Bakka

New Version 3.0.3f at WoW Warlock DPS Spreadsheet

Tricky, Wha?

 

Bessa

Just me or theres no Spell Dmg listed on any item?

 

Trickykid

On TNS-Spirit tab, cell B2 and B3 add +.3. They should add +.3+.03*daegis.

I just checked the Gear_Buffs tab and looks like the same thing. Cell G76 reads:
IF(B76,180*(1+daegis*0.1)+M4*0.3,0)

While it should read:
IF(B76,180*(1+daegis*0.1)+M4*(0.3+.03*daegis),0)

EDIT: Other comments:
-Brilliant Spell Thread (leg enchant) should have +20 spirit, not +20 mp5
-Belt needs buckle
-Need the new glove enchant +28 spell power
-Bracer enchants needs the Leatherworking +67
-Potion of speed doesn't load any stats
-No t7 bonuses included yet (all the proc items have the necessary stats calculated on Advanced infos tab)

 

turturin

None of the haste/hit/crit/spellpower seems to be listed on any item atm.

 

Ossifrage

Arcanum of Dominance - Shoulder Enchant from Stone Keeper's Shards. 29 Sp 20 Resil

 

Rozzenwyn

Agree this does seem to be broken at the moment.

 

Bakka

dmg,hit,crit,haste have been fixed

I'll add the demonic aegis and master summoner stuff in the next version.

I'm not touching belt buckles until the armory does.

 

Rozzenwyn

<3 Thanks for getting so many fixes in so quick!