Closed Thread
Page 7 of 14 FirstFirst ... 5 6 7 8 9 ... LastLast
Results 121 to 140 of 263

Thread: The Cataclystic Protection Warrior Spreadsheet

  1. #121
    Join Date
    Oct 2008
    Posts
    112
    Quote Originally Posted by Tengenstein View Post
    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)

    Quote Originally Posted by Tengenstein View Post
    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.

  2. #122
    Join Date
    May 2009
    Posts
    2,873
    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.

  3. #123
    Join Date
    Feb 2010
    Location
    Portland, OR
    Posts
    2,043
    Quote Originally Posted by Tengenstein View Post
    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
    An introduction into WarTanking (no longer updated as I've retired from WoW - the concepts will still be mostly accurate but the numbers no longer will be.) - http://www.tankspot.com/showthread.p...101-The-Primer

  4. #124

  5. #125
    Join Date
    Sep 2010
    Posts
    313
    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.

  6. #126
    Join Date
    May 2009
    Posts
    2,873
    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.

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

  8. #128
    Join Date
    May 2009
    Posts
    2,873
    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.

  9. #129
    Join Date
    Feb 2010
    Location
    Portland, OR
    Posts
    2,043
    Quote Originally Posted by Tengenstein View Post
    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!)
    An introduction into WarTanking (no longer updated as I've retired from WoW - the concepts will still be mostly accurate but the numbers no longer will be.) - http://www.tankspot.com/showthread.p...101-The-Primer

  10. #130
    Thanks for the fast answer Tengenstein.

  11. #131
    Join Date
    Sep 2010
    Posts
    313
    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
    Last edited by kopcap; 05-21-2011 at 10:25 AM.

  12. #132
    Join Date
    May 2009
    Posts
    2,873
    Recklessness give 50% crit. How are you managing to make it give 70% to CB?

  13. #133
    Join Date
    Sep 2010
    Posts
    313
    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.
    Last edited by kopcap; 05-21-2011 at 11:22 AM.

  14. #134
    Join Date
    May 2009
    Posts
    2,873
    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
    Last edited by Tengenstein; 05-21-2011 at 11:29 AM.

  15. #135
    Join Date
    Sep 2010
    Posts
    313
    Quote Originally Posted by Tengenstein View Post
    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.

  16. #136
    Join Date
    May 2009
    Posts
    2,873
    i'll do some numbers laters whn i'm done pwning scrubs in BGs.

  17. #137
    Join Date
    Sep 2010
    Posts
    313
    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.
    Last edited by kopcap; 05-21-2011 at 12:28 PM.

  18. #138
    Join Date
    May 2009
    Posts
    2,873
    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.
    Last edited by Tengenstein; 05-22-2011 at 10:14 AM.

  19. #139
    Join Date
    Aug 2010
    Posts
    1,132
    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.

  20. #140
    Join Date
    Sep 2010
    Posts
    313
    Its missing 2x threat multiplier.

Closed Thread

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts