The Cataclystic Protection Warrior Spreadsheet

[gom]

In order to rectify this change cell H19 on the abilites tab to;

=2*(H9+H4*H5)*$Stats.$B19


which rather makes CB all kinds of awesome. all kinds.

indeed... wow. thank you. (btw I think It is cell H10)

Gom, unfortunatly due to several quirks of the prot warrior design our max tps rotation is not quite as simple as pressing the highest threat button thats not presently on CD. Our optimal max TPS rotation is based around a 4GCD cycle of using SS on CD and weaving CB, SW, HT into the fourth GCD after SS.

I agree at least it should be like that but for me this is only true if my vengeance is higher then 51 % until that point Devestate gives me more tps/dps. (at least the spreadsheet tells me that..)

and when you reach that 51% vengeance stack in most of the encounters threat becomes irrelevant even with a suboptimal

SS(HR) > CB > SW > Dev.

priorization DPS wouldn't pull aggro.

[Tengenstein]

On most fights you don't out gear you should be nearing max vengenace. I didn't state we needed max TPS, merely how we would go about it. Of course if you removed HT and CB from it you would actually also have our Max DPS rotation, which is something we should be striving for once Survivability and Threat are non-issues.

With my raid buffs, which sadly like a feral druid, arms warrior, subtlety rogue it will on average only take me 8 seconds to stack vengeance to the point that Dev spamming is sub optimal. I generally cover the first 10 seconds of the fight with shield block, which makes the weaving rotation optimal again due to HR.

[Loganisis]

Many Dwarfs died to bring us this information.

Well there's your problem. If you'd used gnomes, they'd all still be alive. It's a proven fact that gnomes are too cute for 85% of all monsters to actually kill! (Just not the specific monsters that have killed your gnomes, they appear to have an immunity) XD

[Icebreaker]

[kopcap]

Teng, I am still not sold that SnB rotation is best for the opening cycle under recklessness and str potion, mostly because of how much more SW and CB benefit from those two factors compared to Dev. Using SS-Dev-CB-SW myself right now.

[Tengenstein]

First off, Recklessness? all our abilites scale similarily with it until they get crit capped, and Dev despite is extra crit from talents won't be crit capped until you can find 15% from your gear, and thats alot of crit rating.

The Optimal starting rotation depends entirely on how long your starting rotation is and how quickly you build vengeance. For me it takes ~7 seconds on average to aquire 30% and for SW to catch up to Dev in threat so including it prior to then is going to be a threat loss, mainly due to Dev's innately higher crit. In the worst case scenario my Openener looks likes:

SS>dev>dev>CB

which the same threat over those 4 gcds as yours if we assume SW=Dev threat at low vengence (in my case Dev>SW), however i can get lucky and have an opener that looks like these:

SS>dev>dev>SS

SS>Dev>SS>Dev

which being that I will general have SB up on the pull is about a 10% threat gain for me. Though this is highle dependant on the rate at which you gain vengenace. as having a parry/dodge/miss streak is going to be catastrophic for threat even if it is the boss doing the missing.

[Icebreaker]

I tried to change cell H19 to =2*(H9+H4*H5)*$Stats.$B19, but Excel just keeps saying smth like "Error in formulae"

[Tengenstein]

I meant to type H10. turn H10 to =2*(H9+H4*H5)*$Stats.$B1

EDIT: edited the orignal post. spreading disinformation is a sin and i must be punished.

[Loganisis]

I meant to type H10. turn H10 to =2*(H9+H4*H5)*$Stats.$B1

EDIT: edited the orignal post. spreading disinformation is a sin and i must be punished.

You cannot use SS in your next raid (hope you're DPSing!)

[Icebreaker]

Thanks for the fast answer Tengenstein.

[kopcap]

Nah Teng, you can see it from the spreadsheet. Recklessness gives ~70% boost to CB, only 50% for Dev. Either way, their bases are different and we probably want a higher base at the start, cos Dev's only value is in having it proc SnB which reduces consistency. Similar with SW, while it reduces the ceiling and avg, it raises the floor. And a low floor is where the threat problems usually come from. This all quickly gets subjective and overly complicated

[Tengenstein]

Recklessness give 50% crit. How are you managing to make it give 70% to CB?

[kopcap]

I was not entirely accurate in my terms but here is a pic to illustrate:



ps This is for 0 vengeance, obv CB looks only better with some of it.

[Tengenstein]

And shield slam?

EDIT:

my numbers without and with Reck up
ss(HR) 51k 83k
dev 23k 29k
CB 39k 66k

SS>CB>Dev>dev 207K
SS>dev>dev>CB 207K
SS>dev>dev>SS 214K
SS>dev>ss>Dev>214k

[kopcap]

And shield slam?

.... and then you have to account for SnB proc, which GCD this is, armor reduction caused by Dev, rage intake, vengeance stack changing by the second etc. If you want to do this accurately, this stuff gets so complicated so quickly I lost the thread around this point.

[Tengenstein]

i'll do some numbers laters whn i'm done pwning scrubs in BGs.

[kopcap]

This is not a fair way of looking at it, recklessness only lasts for 5 GCDs.

You should be comparing something like

(SS - Dev - CB - SW - SS) - Dev - Dev - Dev

vs

(SS - Dev - Dev - CB - SS) - Dev - Dev - SW

expanding both lines for SnB procs, etc.

[Tengenstein]

Okay, S0 according to the sheets dummy boss values i will on average take 17.2k a swing from the boss every 2 seconds Since we don't put TC up in the opener and i have SB up, now asumming i don't have vigilance on someone else this means ill gain 860 AP every two seconds or about 6.4% vengenave per second

PreGCD
I shout pop Recklessness, Shield Block, Heroic Throw and charge the boss, who being not particulairly chummy about an a small angry goblin throwing spikey hammers at him swings at me as giving me an extra 860 AP as sson as i get in melee range meaining he gets his hit inbefore i get mine

First GCD 0.0
SS(HR) - 60.8k

Second GCD 1.5
SS(HR)>Dev - 60.8 + 29.6k : 89.4k
SS(HR)> CB - 60.8 + 44.9K : 105.7

1.99999 Boss has swung a second time giving us on average another 860 AP

Third GCD 3.0

SS(HR)> CB >Dev 60.8 + 44.9K + 30.6K 136.3k
SS(HR)>Dev>SS(HR) 60.8 + 29.6k + 65.8k 156.2k
SS(HR)>Dev>Dev 60.8 + 29.6k + 31k 121.4k

3.9999 Boss has swung a third time giving us on average another 860 AP

Fourth GCD

SS(HR) >CB >Dev >Dev 60.8 + 44.9K + 30.6K + 32k 166.3k
SS(HR) >CB >Dev >SS(HR) 60.8 + 44.9K + 30.6K +70.1k 206.4k
SS(HR) >Dev >SS(HR) >Dev 60.8 + 29.6k + 65.8k +32k 188.2k
SS(HR) >Dev >Dev >CB 60.8 + 29.6k + 31k + 54.3k 175.7k
SS(HR) >Dev >Dev >SS(HR) 60.8 + 29.6k + 31k + 70.9k 192.3k


thems my numbers.


EDIT; Okidoki 5th GCD coming Up....

5.999999 Boss has swung a fourth time giving us on average another 860 AP
Fifth GCD6.0

SS(HR) >CB >Dev >Dev >SS(HR) 60.8 + 44.9K + 30.6K + 32k +75.3k 241.6k
SS(HR) >CB >Dev >SS(HR) >Dev 60.8 + 44.9K + 30.6K +70.1k +33.5 239.9k
SS(HR) >Dev >SS(HR) >Dev >SS(HR) 60.8 + 29.6k + 65.8k +32k +75.3k 263.5k
SS(HR) >Dev >SS(HR) >Dev >CB 60.8 + 29.6k + 65.8k +32k + 58.6k 246.8k
SS(HR) >Dev >SS(HR) >Dev >Dev 60.8 + 29.6k + 65.8k +32k +34.5k 222.7k
SS(HR) >Dev >Dev >CB >SS(HR) 60.8 + 29.6k + 31k + 54.3k +75.3 251k
SS(HR) >Dev >Dev >SS(HR) >Dev 60.8 + 29.6k + 31k + 70.9k +34.5 226.8k

EDIT: Bugger that, spend the first 4GCDs fishing for Procs, and if on the fifth GCD SS is on cd use CB.

EDIT2: though if the pattern continues it will probably be a threat loss over the first 10 seconds to use CB at that point over fishing for more SS(HR)s, and if we were to map out all the variables (and i'm using someone elses head for that) the answer would likely be, spend the first x GCDs fishing for SnB procs and then use either SS or failing that CB in the last GCD of the time period.

[klausi]

Regarding that 5th GCD, is my spreadsheet just off (just downloaded the newest one for excel to double check it)? It shows CB way below Dev (yielding a 372 weapon with 521.7 dps) for your assumed 5th global at 48% vengeance (5*1.5 seconds * 6.4% vengeance), on par with revenge.

In general: Devastates assumption for total threat looks very high for those low/zero vengeance situations even while removing the increased crititcal strike rate from talent/glyphs. Outside of a high rage situation it just looks advisable to only spam Rev/Dev while fishing for SnB proccs (20 rage saved every time) and using excessive rage on HS.

[kopcap]

Its missing 2x threat multiplier.