Hello,

I am fairly new to the topic Theory Crafting and I was wondering how much DPS boost skilling Catastrophe (5/5) and one out of Improved Immolate will give me. Sure less Mana used on Bolts = more Mana and means in the end less Life Taps, but I am using manapots on CD when we are on a static boss, and if I have to run, i can Tap anyways, without decreasing my DPS.

Another Question I got is, did anyone a calculation from which point on (spelldmg wise) casting Immolate will decrease your DPS vs casting a Shadowbolt? Is it as soon you have 4xT6 Bonus?

Thank you a lot in advance for your assistance.

Necoro

The spreadsheet can answer all your questions.

I am kind of confused as to where people get the assumptions that with max gear haste > spell damage.

Link to my armoryPaddlok <The Dark Embrace> Neptulon

Now, From my gear Fully raid buffed and assuming I get Heroism+2x Drums my stats are
1652 shadow damage
32% crit
240 haste

So with all the posts about haste generally being better than + damage (I am talking about Spinals v Pyrestone v Lionseye)
I decided to input all my stuff on the spreadsheet and it shows me that I get 13.62 dps increase from a spinal, 13.47 from a Pyrestone and 13.32 from the lionseye.
Now granted there is only a very small margin between the dps values of the 3 gems, but I am wondering where, if any there is a point that stacking haste above spell damage becomes a drop in dps.

You may be confusing "haste rating is better than spell damage" for "haste gems are better than spell damage gems". In your above example, haste is worth more point for point than spell damage, just not 1.2x more.

As I know, "The Next Stat" table shows us only personal damage changes. So, it would be nice to show raid dps changes in "The Next Stat" table, raid dps in 'Gear buffs' and 'DPS' tabs.

It does if you turn the "Raid TNS" option to "1".

I'm sorry if I missed it (I'm new to this thread and the art of TheoryCrafting), but is there a Getting Started guide, or documentation set (other than the FAQ) for this spreadsheet? I'm not an Excel wiz, and it's kinda daunting, and I didn't see anything like that when I looked through this thread.

THANKS!

Some neck pieces with sockets are crashing the dps calculation, when selected.

Another thing, Leggings of channeled elements has +59 dmg not 64

Make sure you select a gem for the socket before you select the necklace.

Probably because you have all the other spells turned off. Set the zeros next to the spells to 1 if you use them.

So this is a pretty nubby question, but can someone explain to me what exactly "dot gap" represents as an in game quantity?

The average time it takes you to get each DoT/Debuff back up on a target. If you set this to 2, then you will show as recasting immolate every 17 seconds.

I love the spreadsheet, it will keep me busy for days. I just have a tiny tiny question. On the pet tab, it looks like you're calculating the bonus to pet damage as the max between additional shadow and additional fire damage? However, the felguard gets bonus damage only from +fire and the succubus gets it from +shadow. Shouldn't these be separate tables?

EDIT: Nope, I was flat out wrong on this one. Ignore me.

The pet tab may be a little buggy, not many people use Felguard in raids.

The highest value of either Fire or Shadow damage will add to the pets attack power; last time I checked that was correctly shown in the sheet.

There appears to be a circular reference error on the DPS tab which is preventing cells from updating. The error is regarding the mps for each spell. For example, with only shadow bolt and lifetap selected the circle is J27 > F27 > F30 > D30 > J27. Oddly, this error seems to manifest itself rarely and usually the spreadsheet works fine.

On another note, you think you could add the T6 2-piece healing bonus to the hps column?

If you are using excel, I think you can set the number of iterations of such a circular reference in "Tools\Options > Calculation > Iteration/Maximum Iterations.

I would like to point out that if on the Gems sheet I try to click the 'Sort by dps value' button I get a run time error '1004': Application-defined or object-defined error. Debug refers me to the following macro code:

Sub Sort_gems_dps()
Sheets("Gems").Range("gems").Sort Key1:=Sheets("Gems").Columns("M"), Order1:=xlDescending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
End Sub

And since I m on the topic of the Gem-sheet... I find it weird that the DPS values I get listed do not take into account the fact that Hit is already maxed. As if it's not referring to the proper places perhaps. Which makes the entire sorting a bit silly anyway since you need to ignore the lines with gems that have Hit.

Well, with the new KJ loot out I went ahead and added the items to my copy of Leulier's spreadsheet and figured other people might want to be able to play around with them so I uploaded it here: http://www.aeriepeakexiled.net/image...ps_KJAdded.xls

Please note this is just a quick fix until the next actual release, all credit for the excellent spreadsheet and everything in it goes to Leulier.

Things to note, I just modified a few kara drops into the new items so thats why some kara items are now missing. Also, the spreadsheet couldn't handle the new back because there are no other socketed backs so I just assumed a 12 damage gem and changed the base damage of the cloak to 56 to account for the gem and socket bonus. This is my personal version of the spreadsheet so the Item Sets and raid setup are configured for my raid, keep that in mind as well.

Why is the cast ratio for Immolate calculated using it's base cast time + lag whereas the cast ratio for every other spell uses its effective cast time (which factors in haste)?

Just wanted to post it here, but Icon of the Silver Crescent shows up with a Spell Damage value of 69, when it should be showing up as 43...Or does this factor in popping it for the extra 155+ Spell Damage, every two minutes?