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
Posted in Uncategorized, spreadsheet |
Thanks so much. Good job on keeping the updates/fixes coming. Really appreciate it.
I am getting the same error in 3.03 as I did with 3.02e. I will try to give you as much detail as possible:
Spec set to Imp Destro
Filler is incinerate
Casting Immolate, CoA, Corruption, Incinerate(as filler), CB, Conflag and Backdraft. I didn’t really mess with much.
The problem occurs with a circular formula in F34 on the DPS sheet. The error suggests that there is a circular formula that cannot be calculated. If you take out cell F39 from the SUM equation in F34 and manually input the % time dedicated to life tap you can get past the error. I don’t know where the loop is but that’s a start., I can look at it more after work.
——————–
Also, it seems to me that the calculation for GoC is lacking as it adds no dps without shadowbolt as your filler. Even as a fire lock I would throw in a SB if it was instant.
I’m getting errors related to Invalid cell names. Excel then goes through and replaces the cell names that have issues with cell_names_with_underscores and in doing so breaks the macros.
Any help? Could we ensure that all the cells are named without spaces, etc etc?
RE: Ossifrage
GoC works fine. The only time it doesnt work is if you don’t have the Glyph selected and you don’t have corruption selected.
As for the rest, I have no idea. Try setting the DPS!B34 to 0 and then back to 1.
RE: Matthew
Not enough information to go on.
Just curious, does this version take into consideration the coefficient changes to Corruption and Immolate that were hotfixed last week?
RE: Mike
Immolate yes
Corruption no.
Thanks for the reply and all of your work.
Changing to 0 and back to 1 brings up the circular logic warning again. If you ignore it the DPS calculation doesn’t work, have to put the number in manually for life tap %.
Couple of other questions/items:
-Inspiring Presence (Heroic Presence?) reduces spell damage for some reason while increasing hit
-No option for focus magic buff
-Inaccurate item stats (IE Hellfire-Encased Pendant doesn’t add fire damage and Rittsyn’s lost pendant is spell damage now not shadow)
RE: Ossifrage
No clue then. Without more information you’re on your own as I never experience this problem.
Heroic presence doesn’t affect spell damage. Not sure where you’re seeing that it does. I’ve changed it to Heroic on my current working version so wording will change with the next version.
Focus Magic will be included in the next version. Thanks.
As I’ve stated multiple times, item stats won’t be fixed.
