Warrior DPS Calculation Spreadsheet - Page 89

Claertes · 07/25/09, 9:08 PM

@starfox

Hi mate,

with
- 13,3..% bloodlustuptime
- Race=tauren
- reactiontime=50ms
- lag=0
- no shattering throw/no hysteria/no tricks of the trade/no hastepot/no armorpot/no execute
- your posted gear-setup
the sheet says 7415dps (changing some gems would push it a little bit).

The sheet doesn't calculate possible "uptime-synergies" between 1st trinket, 2nd trinket and deathwish. I guess in the simulation there is always deathwish and both trinkets up at the start, and with little luck, in the middle of the fight again
...and as already said, there is no execute-model in the sheet.
So ~8k could be a valid number.

Using execute lowers flurryuptime, but i dont know if it's so much... (96%sheet->89%sim).

Machinator · 07/26/09, 11:54 AM

Originally Posted by bo5r5osh

Data can be hidden from users, unlike MS Excel. This gives some kind of a control to the author, to hide the data he feels are not necessary to the end-user (which sometimes confuses them) and show the data that is convenient to the end-users. Hiding data was never a drawback.

landsoul covered the gist of this. It would also take away from people being able to edit the sheet for a variety of reasons. Adding gear is the big one or changing a couple cells for an upcoming patch, both save landsoul a good amount of time I would think. And then there are crazy people like me who put death wish on its own sheet and use different rotation formulas.

Holybeetle · 07/27/09, 7:05 PM

Hello All,

I am having the same problem as uglygreenguy. I have tried downloading both the Office 07 and the 97 versions and both give me an error saying the page can not be opened and that the operation is aborting. Any info or an alternate download site would be appreciated. Thanks in advance for the help!

ebs2002 · 07/28/09, 9:03 AM

It looks like Arms isn't calculating OP procs from dodges. While I wouldn't recommend ignoring expertise all around (a dodge+overpower is less DPS than not having your white attack/slam/MS dodged at all), the strike strength of Overpower is considerably higher than it is for Slam, and so if you are not expertise capped, have 2/2 Unrelenting Assault, and you happen to get dodged, you should consume that overpower sooner rather than later.

This does have the potential to lower the SEP on expertise below-cap, and potentially create a different BIS list for arms.

landsoul · 07/28/09, 1:11 PM

I will be revisiting a lot of the arms calculations at a later time. I am allocating my time resources to more important things, since I believe the arms stuff is mostly functional at the moment. The question really comess down to then should you ignore expertise or not? Is the chance that TFB is not up and the DPS difference between Slam and overpower greater than having a percentage of all attacks miss?

sunjinsel · 07/28/09, 8:34 PM

In theory raiding with less expertise than required might increade your dps, but i tried it myself (8 expertise). I often need sunder due to not having a prot warrior all the time. It is very annoying dropping 5 stacks of sunder due to a a lack of a prot warrior and missing a white hit after a heroic strike, which denies a lot of damge.

ebs2002 · 07/29/09, 12:09 AM

I did the math a while back, and there's really no way for the loss of expertise to increase your DPS. Granted, Overpower does more damage on average than MS or Sudden Death, but the loss of the GCD of whatever was dodged doesn't make up for it. Assume that Slam does 4k, MS does 5k and OP does 7k (all including deep wounds from potential procs).
If you get a dodge on Slam and follow it up with an OP, you do 7k. If you didn't get a dodge, you would have slammed twice for 8k total, for a loss of 1k. MS/Slam would be a loss of 2k damage. Execute/Slam would be an even greater loss.

The only way you can make up that damage is with a white dodge (which doesn't cost a GCD), which will give you a large chunk of that damage back. But it probably won't be more, and will affect your rage, so it's not a good idea.

Regardless, though, there are times when you'd want to replace a slam with a dodge-activated OP if you find yourself sitting below the cap for one reason or another, and it would probably be good to determine exactly how often this happens.

Starfox · 07/29/09, 12:31 AM

Nate put out a new release.
We were discussing on the mailings lists if the 4.8% crit suppression vs bosses does only apply to white hits or also specials. Found sources that say white+specials, some only white hits suffer from it. Nevertheless, with it enabled for specials the dps is more in line with the spreadsheet, so I suppose your spreadsheet does apply it to white hits and specials

SimulationCraft for World of Warcraft build 3.1.3 ( iterations=4999, max_time=300, optimal_raid=1, smooth_rng=0 )

DPS Ranking:
   7858 100.0%  Raid
   7864  100.0%  Warrior_T8_19_52_00

Player=Warrior_T8_19_52_00 (fury)  DPS=7864.0 (Error=+/-7.5 Range=+/-844)  DPR=503.1  RS=15.6/15.7  (rage)
  Origin: http://profiler.wowhead.com/?profile=13001761
  Core Stats:  strength=1523(1344)  agility=561(453)  stamina=1551(1390)  intellect=41(10)  spirit=71(10)  health=19909  mana=20
  Spell Stats:  power=0(0)  hit=7.43%(195)  crit=18.47%(848)  penetration=0(0)  haste=1.46%(48)  mp5=0
  Attack Stats  power=4312(873)  hit=5.95%(195)  crit=30.63%(848)  expertise=6.43%(211)  penetration=47.48%(585)  haste=1.46%(48)
  Defense Stats:  armor=11490(10368)
  Glyphs: whirlwind/heroic_strike/execution/charge/bloodrage/battle
  Actions:
    bloodthirst           Count= 62.4| 4.7sec  DPE=  7727|20%  DPET=  4683  DPR= 386.4  pDPS=1610  Miss=0.0%  Hit=4457  Crit=10150|15579|57.5%  Dodge=0.1%
    deep_wounds           Count=  0.0| 0.0sec  DPE=     1|13%  DPET=     1  DPR=   0.0  pDPS=1036  Miss=0.0%  TickCount=207  Tick=1498
    execute               Count= 14.5| 3.2sec  DPE= 10115| 6%  DPET=  6129  DPR= 140.5  pDPS= 489  Miss=0.0%  Hit=6166  Crit=14112|21606|49.8%  Dodge=0.1%
    heroic_strike         Count= 98.7| 2.9sec  DPE=  5468|23%  DPET=     1  DPR= 455.7  pDPS=1800  Miss=0.0%  Hit=3428  Crit= 7787|11454|46.9%  Dodge=0.1%
    melee_main_hand       Count= 33.1| 9.2sec  DPE=  3784| 5%  DPET=  1736  DPR=   0.0  pDPS= 417  Miss=18.2%  Hit=3022  Crit= 6230| 9027|46.6%  Glance=2268|24.0%  Dodge=0.1%
    melee_off_hand        Count=130.4| 2.3sec  DPE=  2327|13%  DPET=  1016  DPR=   0.0  pDPS=1012  Miss=18.0%  Hit=1855  Crit= 3822| 5644|46.7%  Glance=1392|24.1%  Dodge=0.1%
    slam                  Count= 20.8|12.8sec  DPE=  5584| 5%  DPET=  3384  DPR= 372.3  pDPS= 388  Miss=0.0%  Hit=3501  Crit= 7958|11782|46.8%  Dodge=0.1%
    whirlwind             Count= 69.4| 8.7sec  DPE=  4803|14%  DPET=  5822  DPR= 384.2  pDPS=1112  Miss=0.0%  Hit=2945  Crit= 6702|12154|49.5%  Dodge=0.1%

Gains:

    Warrior_T8_19_52_00:
        anger_management=93.9  (overflow=5.9%)
        avoided_attacks=1.3
        bloodrage=149.3  (overflow=2.8%)
        glyph_of_heroic_strike=462.3
        mh_attack=1241.1  (overflow=4.7%)
        oh_attack=2765.9  (overflow=9.0%)

Procs:

    Warrior_T8_19_52_00:
        bloodsurge=26.4|11.51sec
        darkmoon_greatness=7.0|46.25sec
        mjolnir_runestone=6.4|49.69sec

Up-Times:

    Global:
        100.0% : blood_frenzy                  
        100.0% : master_poisoner               
        100.0% : savage_combat                 
        100.0% : totem_of_wrath                

    Warrior_T8_19_52_00:
         61.0% : berserking_mh                 
         32.8% : berserking_oh                 
         87.1% : flurry                        
         74.9% : heroic_strike                 
          5.9% : rage_cap                      

Waiting:
    19.5% : Warrior_T8_19_52_00

Baseline Performance:
  TotalEvents   = 12065079
  MaxEventQueue = 19
  TargetHealth  = 2355108
  SimSeconds    = 1499176
  CpuSeconds    = 8.188
  SpeedUp       = 183094

RNG global Actual/Expected Roll=1.001908 Range=1.000000 Gauss=1.000026

Allazar · 07/29/09, 2:17 AM

Ok, and now i see myself with 132 (4%) hit rating on Arms Build, and...
on my spreadsheet Hit is 0.89 against 1 STR yet... is this really true? even being 3% before the cap?

should i stick with 4% (+1% from draenei) and get more str/crit or should i go for the cap (+3%) and spreadsheet is not so accurate about hit sep values?

thanks for the help...

Shha · 07/29/09, 4:22 AM

Originally Posted by ebs2002

I did the math a while back, and there's really no way for the loss of expertise to increase your DPS. Granted, Overpower does more damage on average than MS or Sudden Death, but the loss of the GCD of whatever was dodged doesn't make up for it. Assume that Slam does 4k, MS does 5k and OP does 7k (all including deep wounds from potential procs).
If you get a dodge on Slam and follow it up with an OP, you do 7k. If you didn't get a dodge, you would have slammed twice for 8k total, for a loss of 1k. MS/Slam would be a loss of 2k damage. Execute/Slam would be an even greater loss.

The only way you can make up that damage is with a white dodge (which doesn't cost a GCD), which will give you a large chunk of that damage back. But it probably won't be more, and will affect your rage, so it's not a good idea.

Regardless, though, there are times when you'd want to replace a slam with a dodge-activated OP if you find yourself sitting below the cap for one reason or another, and it would probably be good to determine exactly how often this happens.

Noone said that losing expertise would ever increase dps on its own - its just that replacing it with STR/ArP can. The fact that you convert dodges to OP is actually not even calculated i think. Arms expertise is lower, because a large chunk of damage (if you count DW contribution around 25-28%) is from overpower (normal TfB procs) - an attack that cannot be dodged in first place (and thus expertise doesnt improve it at all).

Faithireon · 07/29/09, 10:55 AM

Originally Posted by landsoul

Hit rating problem:

That's odd, I'll take a look at it. It should not be doing this..

Edit: Found the problem, for yellow crit reduction through miss rate, it was referring to the wrong cell. Fixing it properly puts hit rating above 1.000 SEP.

To fix, make sure cell AH36 reads the following.

=X111*((1-AH39-AH31)*(IF(AL23=80,3.192,0)+(3)*C35+IF(C23="Player",0,IF(C23="Boss",-4.8,0.2*(AL23-C23)))+AL6+MAX(5*P27,5*P25)+MAX(U37*V37/100,U39*V39/100,3*V41)+AG24*AO15+D139/AL57+(N136+C48+Z111+IF(A30="Food: Crit",C30,0)+C36*32)/AL58)/100-A41)+(1-X111)*((1-AH39-AH31)*(IF(AL23=80,3.192,0)+3*C35+IF(C23="Player",0,IF(C23="Boss",-4.8,0.2*(AL23-C23)))+AL6+MAX(5*P27,5*P25)+MAX(U37*V37/100,U39*V39/100,3*V41)+AG24*AO15+D139/AL57+(N136+C48+IF(A30="Food: Crit",C30,0)+C36*32)/AL58)/100-A41)

I bolded the correction. Should say AH31, not AH32. Please not this is only in the arms sheet. Do not touch the fury sheet.

^^

Allazar,

This fixes the hit rating issue on the Arms tab.

dachopper · 07/29/09, 10:49 PM

Spreadsheet Question:
I have 47.42% Arp in cell E4, however base pen is 50.66% in cell A60, showing me over the soft-cap. How can this be?

The reason I care is so that I can start gemming for str at the soft-cap since I have GT.

callion · 07/29/09, 11:11 PM

Originally Posted by dachopper

Spreadsheet Question:
I have 47.42% Arp in cell E4, however base pen is 50.66% in cell A60, showing me over the soft-cap. How can this be?

The reason I care is so that I can start gemming for str at the soft-cap since I have GT.

Did you count in the ArP from the food buff?

taureen · 07/30/09, 6:52 AM

Hi folks
Quick question about the sheet itself.
I am trying to change the armory address from the us armory to the eu armory to import my character but when i cut and paste in the link into the excel sheet, in the formula bar , it just crashes the program?
This may have been covered before but i have not spotted the link.
Thanks

sunjinsel · 07/30/09, 8:27 AM

Your just need to type eu.wowarmory.com in the "Site" field.