Prot Warrior Ability Comparison Spreadsheet

[Faustz]

I've made a spreadsheet which breaks down each ability to show it's overall threat with a variety of different setups, as well as threat per rage (TPR, efficiency), threat per execute time (TPET) and threat per second (TPS). It also includes a graph which plots TPS vs. TPR for each ability. Generally abilities that fall higher on the line-of best fit for this plot are both efficient and powerful (i.e revenge). Let me know if you have questions and any feedback is appreciated.


https://docs.google.com/spreadsheets/d/ ... sp=sharing


Some notes:
-TPS for heroic strike and cleave is assumed with a 1.3 speed weapon but can be edited in the column (also assumes you have enough rage to use at every possible occurrence.)
-Demo Shout and Battle Shout are calculated based on each target debuffed/buffed respectively.
-The rage cost for heroic strike doesn't include the rage lost from the auto attack, but I didn't include the threat from the damage/threat auto attack either which should roughly balance out.
-The rage cost for revenge doesn't include the cost of shield shield block, which you could arguably add since it is a necessary requirement to use the ability, but given that it is also necessary in your rotation regardless it seems fair. I think it's clear to everyone that revenge is cheap and deals a lot of threat, but is balanced by a 5 sec CD and a conditional.
-I didn't factor the 10% reduced damage from Dstance into the base damage of abilities. The value is simply what is on the toolitp.

[zmandude24]

Did you account for armor?

[vido]

The spreadsheet is pretty neat, but heroic strike quite obviously can't be more efficient than sunder. You seem to have overlooked the fact that the auto attack is indeed automatic and does not depend on the usage of heroic strike.

The only thing that should come into play and which was overlooked is yellow hit vs. white hit. If you take the difference between the white and yellow hit modifier using the spreadsheet that's stickied in this section you can find the real tps of heroic strike by adding this threat boost on top of the bonus threat that it adds.

[Faustz]

The spreadsheet is pretty neat, but heroic strike quite obviously can't be more efficient than sunder. You seem to have overlooked the fact that the auto attack is indeed automatic and does not depend on the usage of heroic strike.

The only thing that should come into play and which was overlooked is yellow hit vs. white hit. If you take the difference between the white and yellow hit modifier using the spreadsheet that's stickied in this section you can find the real tps of heroic strike by adding this threat boost on top of the bonus threat that it adds.

The value for the base damage of heroic strike in the sheet doesn't include any component from white damage. The value is just the additional damage per hit gained from the ability which you can see in the tooltip. The final TPS result for HS(8) is also corroborated by Armilius in his Prot warrior guide where he breaks down the calculation.

[vido]

That one bullet point in your notes regarding heroic strike really confused me xD thanks for explaining it though. I looked at that bit in Armilius' guide and it still omits the the threat boost by making your auto hit a yellow, would be cool to see where it ends up if you add that correction.

[Undertanker]

Malke this easier. Shield Slam > revenge > sunder.

On a lvl 63 or boss keep shield block up always.

If your OTs are not already assigned to do so (they should), stance dance to arms -mocking blow to get a jump in threat >thunderclap >swap back to def. Thunderclap and demo are better than any epic you could put on.

Heroic strike when you have enough rage to use one of your global cds mentioned at the top and a heroic strike. I have 2/3 imp HS 3/3 imp sunder (impale spec). So assuming you already used shield block:

<5 rage -auto attack
5+ - revenge.
12+ (revenge on CD) sunder armor
18+ Revenge & Heroic Strike
20+ shield slam
25+ Sunder armor & heroic strike.
33+ Shield slam & heroic strike.

[Armilus]

That one bullet point in your notes regarding heroic strike really confused me xD thanks for explaining it though. I looked at that bit in Armilius' guide and it still omits the the threat boost by making your auto hit a yellow, would be cool to see where it ends up if you add that correction.

By converting the white hit to a yellow hit it's the same as adding 3% hit and it removes the possibility of a glancing blow.

Your TPS from auto attack is the DPS shown in the character sheet multiplied by armor reduction, hit chance, dodge chance, parry chance, block chance, crit and glancing blow chance times glancing blow damage reduction.

Where C = glancing chance (0.4); R = glancing reduction (0.7 with 300 weapon skill); TM is threat modifier:

We need to make a couple formulas first. Subtract the chance to get a miss, dodge, parry or glancing blow, this leaves us with the chance to get a hit or crit.

1 - miss - dodge - parry - block - C = chance to get a hit or crit

Now we can multiply this by our DPS and TM to get the threat from hits and crits,

DPS * TM * (1 - miss - dodge - parry - block - C) = Threat from hits and crits

Now let's get the threat from glancing blows,

DPS * TM * (C * R) = threat from glancing blows

^ is simple enough, chance to get a glancing blow, times the damage reduction

Same for block,

DPS * TM * (BlockChance * (BlockValue/AverageDamage)) = threat from blocked attacks

So the formula for threat from white attacks is:

TM * DPS * (1 - miss - dodge - parry - C) + TM * DPS * (C * R)

For the yellow attacks it's a bit simpler as there are no glancing blows,

TM * DPS * (1 - (miss + 0.03) - dodge - parry)

Remember that we have a 5% chance to miss on yellow attacks instead of 8%, that is why we add 0.03 to the miss chance.

Now we want a factor for the difference between the two, let's call that X,

X * [TM * DPS * (1 - miss - dodge - parry - C) + TM * DPS * C * R] = TM * DPS * (1 - (miss - 0.03) - dodge - parry)

X * TM * DPS * [((1 - miss - dodge - parry) - C) + C * R] = TM * DPS * ((1 - miss - dodge - parry) + 0.03)

We can drop the (TM * DPS) because it's a common factor on both sides,

X * [((1 - miss - dodge - parry) - C) + C * R] = (1 - miss - dodge - parry) + 0.03

To make things a bit simpler, let's say that (1 - miss - dodge - parry) = A,

X * (A - C + C*R) = A + 0.03

X = (A + 0.03) / (A - C + C*R)

Now let's put the formula for A back in,

X = (1 - miss - dodge - parry + 0.03) / (1 - miss - dodge - parry - C + C*R)

I forgot to include block but that is easy, it's just part of that 'A' formula so really A should be,

A = (1 - miss - dodge - parry - (block chance * (boss block value / (average white damage * armor reduction)))

I'm not sure what the correct values are for all those variables, Oto says dodge, parry and block chance are 0.065.

I also didn't add crit chance and crit damage increase into the formula but it shouldn't change anything unless you are at the soft crit cap while tanking... with a one-hander...

Ultimately you are looking at ~22% threat increase just from converting it from a white attack to a yellow. Results are much lower if you have weapon skill.

tl;dr:

Here's your formulas, go spreadsheet:

A = (1 - miss - dodge - parry - (block chance * (boss block value / (average white damage * armor reduction)))

X = (A + 0.03) / (A - glancing blow chance + glancing blow chance * glancing blow damage modifier)