Noticed a slight problem with the spreadsheet whilst trying to work out the difference between 6/14/51 and 15/56, the mana per 5 of judgement of wisdom does not remove itself when you click no on the target debuffs, it stays within the calculations regardless, therefore skewing the worth of Aspect of the Viper and such.

If anyone could verify if its just a problem with my copy of the sheet or such, but thats how it seems to me at present. I still have 140 mana per second with the No Buffs profile loaded.

It sounds like he might be talking about the base racial stats not being included in the row 97 cells of the Gear tab. Those formulas calculate the sum starting on row 9 instead of 8 (the racial stats) which I guess is supposed to be true since that row is called "From Gear:".

Ah, they are added a few rows below that in any case. Previously they were all just added up, but I split it because it seems Blizzard does some rounding along the way and I was trying to make it match the in-game tooltips more.

I was just curious if there's been any raid testing with the mangle debuff and the damage resulting in the bleed effect from piercing shots? If it isn't increasing the damage, is there an intent to include it (i.e. is this a bug or working as intended). Currently in the spreadsheet, it offers no dps increase in MM.

It would appear that Blizzard may be using a rounding factor at the tens place, so

2765 *1.3 = 3594.5 round at the tens to 3590
3590 + 386.1 = 3976

So it wouldn't actually be 30% but a set standard of 3590

If you then take into consideration TNT, which is a 6% added to the 30%

2765 *1.36 = 3760.4 round at the tens to 3760
3760 + 386.1 = 4146.1

I tried on other RAPs and it works the same.

In tab "Gear" Row 97, columns "C" - "R" the formula "=sum(c9:c94)" would be "=sum(c8:c94)" because the stats of race are not included.

Ich glaub du kannst ja deutsch, hast ja immer im wow-forum gepostet
Die Formeln im Tabellenblatt "Gear" in den Spalten "C"-"R" in der Zeile 97 beinhalten nicht die Rassenstats der Zeile 8.
Ich denke die Formel müsste z.B. in Zelle "c97" so lauten: "=SUMME(c8:c91)" anstatt "=SUMME(c9:c91)".

Thanks, the race stats are, however, included in the final tally in the lowest row. I split them up some time ago because Blizzard appears to apply rounding to them separately.

The Fury of the Five Flights trinket could use a bit of a tweak. I'm at 0.91 shots per second, according to the spreadsheet, which means it takes a bit over 18 seconds to get a full stack. Not bad, but not trivial in my opinion.

Since you are already setting the duration of the fight, you could use this to get a more accurate number.
This number approaches 320 as TotalTime approaches infinity. With my frequency this puts it at about 311 AP for a 6 minute fight, but only 294 for a 2 minute fight.

Obviously this trinket would still have its caveats, but we could use this to figure out how long a boss fight would need to be (or a phase change before we must lose stacks - Mimiron?) for this trinket to be better than say Bandit's or Mirror.

Shandara, I can't even begin to thank you enough for your spreadsheet. It's one of the main reasons I stuck with my hunter for as long as I have. I was just curious if you had any plans to create something similar for other classes. I recently leveled a DK and am feeling a little lost without my trusty spreadsheet I've grown so attached to.

Does that take into account the fact that a single Explosive Shot will gain you 3 stacks of the AP buff?

I am noticing the exact same thing. Judgement of Wisdom does not clear when you clear the buffs and remains in the calculations on the calculations tab. Even manually setting it to no on the buffs tab has no effect.