Warrior DPS Calculation Spreadsheet - Page 53

Liar · 07/21/09, 7:08 AM

Originally Posted by Arowyn

Yes, when i enter my warrior's name and server. It comes up with an error that my toon does not exist. Is there a way around this? Also it does not recoginze the rigid stormjewel, can this be fixed.

I had the same problem as well (2007) but I just ignored it since the sheet still managed to update my gear correctly. It didn't change the spec though, but that's hardly alot of work to adjust compared to the gear.

Wymorence · 07/21/09, 7:30 AM

Originally Posted by xavier2k3

Possible Bug?:

From what i can see, the spreadsheet isn't showing the socket bonuses for Leggings of Cunning Deception & Algalon rings when you're using the gear sheets. It just says Bonus: None; however it's listed in the lookup. For other gear the socket bonuses show up fine so I can't imagine that this is intended.

I can't see that this has been mentioned in this thread for the new build, only that the rings have the wrong socket bonuses in the lookup.

Did you put the correct colors of gems into the 3 sockets for the LoCD and rings? I just tried it on my copy, and the socket bonuses show up fine once I've put in the correct gem colors into the items.

xavier2k3 · 07/21/09, 4:48 PM

Originally Posted by Wymorence

Did you put the correct colors of gems into the 3 sockets for the LoCD and rings? I just tried it on my copy, and the socket bonuses show up fine once I've put in the correct gem colors into the items.

It's fresh from the armory import feature so i haven't had to edit anything on the spreadsheet. So maybe there's some sort of error or something upon importing these pieces from the armory? I tried to put the right color gem into the ring and the bonus didn't show up through the spreadsheet and I couldn't get the legs' bonus to show up either.

Wymorence · 07/21/09, 6:12 PM

Originally Posted by xavier2k3

It's fresh from the armory import feature so i haven't had to edit anything on the spreadsheet. So maybe there's some sort of error or something upon importing these pieces from the armory? I tried to put the right color gem into the ring and the bonus didn't show up through the spreadsheet and I couldn't get the legs' bonus to show up either.

I think i see what the problem is. It looks like the red and yellow gem sockets on the spreadsheet are backwards on the LoCD. I uploaded your armory into my spreadsheet and had the same problem, but then i switched your 16str and 8 str/crit gems around and the bonus showed up. The spreadsheet has the gem order as R/Y/B, while the item in game is Y/R/B. The ring doesn't show up just because you have a red gem in a blue socket in it.

bo5r5osh · 07/21/09, 8:07 PM

Hey land,

I am using your spreadsheet even thu I am not a big fan of spreadsheets in general, you put so much effort and please know, that it is very appreciated.

Do you have plans to implement something similar as a web application? Using some basic technologies like php/mysql.

Web application has some features:

You can control the layout, the page would be much cleaner.
Data are hidden from user.
Less human error.
Save current or even multiple case senario.
Can easily change colors depends on factions (horde/alliance)
Better representation of items (image vs item name)

I'd have done it myself, however, I am not familiar with warrior's mechanism in depth yet. Lot's of forumla and equations in your sheet that are vague to me.

Well, it is just an idea after all =)

xavier2k3 · 07/21/09, 8:18 PM

Originally Posted by Wymorence

I think i see what the problem is. It looks like the red and yellow gem sockets on the spreadsheet are backwards on the LoCD. I uploaded your armory into my spreadsheet and had the same problem, but then i switched your 16str and 8 str/crit gems around and the bonus showed up. The spreadsheet has the gem order as R/Y/B, while the item in game is Y/R/B. The ring doesn't show up just because you have a red gem in a blue socket in it.

Yeh i was aware of the red gem in blue socket as i mentioned in my last post, it didn't work when I put in a blue gem or a META in it for some reason either. Seems to be working okay now though. The thing with the legs sockets in the spreadsheet makes sense though, thanks for clearing that up. Hopefully Landsoul will see the message and hopefully rectify it for the next build.

Troutinator · 07/21/09, 10:10 PM

Originally Posted by Troutinator

I've been playing with the spreadsheet and have notice some odd things. My character's name is Drakthuel on the server Vashj, and am Poleaxe spec Arms so you guys can see what I mean.
...
Now, I thought that with the gear sorted by DPS higher items would increase my total DPS. Instead it decreased it. Is the sheet working like it is supposed to and I'm misunderstanding or misusing it?

Originally Posted by nomopofomo

The sorting sheet is either not considering weapon spec or you did not choose arms as the check sheet.

Nope, I checked and re-checked. Its pulling Arms gear and I even chose Ironsoul, supposedly better, and set my spec to Mace and it still wasn't better DPS than my Betrayer.

Any clues whats going on? Makes me not really trust the sheet.

landsoul · 07/21/09, 10:25 PM

The SEP is a comparison of stats only, not talent choice difference. Ironsoul is a better weapon than Betrayer, but due to Poleaxe spec, Betrayer is better. Does that make sense? SEP helps you determine which items have better stats for you, but you have to use your brain. Trust the DPS figure on the Arms page the most.

Also again, I'm not an expert at programming in any way, and I did not write the armory fetch feature. The wowarmory site has changed a bit since the sheet functionality was there, and it has not been changed to accompany the new wowarmory changes. If I were to fix it completely, I would need some help pointing out how to do it.

Troutinator · 07/22/09, 12:05 AM

Originally Posted by landsoul

The SEP is a comparison of stats only, not talent choice difference. Ironsoul is a better weapon than Betrayer, but due to Poleaxe spec, Betrayer is better. Does that make sense? SEP helps you determine which items have better stats for you, but you have to use your brain. Trust the DPS figure on the Arms page the most.

Yeah, it makes sense. I sorted by DPS so I figured it would be on what would increase my DPS from its current value. So it still amounts to playing around with all sorts of combinations because the sorting is only a very crude guideline, if even that sometimes.

But, given the actual DPS calculation, that it shows up top and on the left, that is number worth trusting then.

landsoul · 07/22/09, 10:41 AM

For the new build I was working on for 3.2, I successfully made a macro that will remove an individual piece of gear and its gems, run the SEP code, replace said piece of gear and its gems and then sort only that slot on the lookup page based on SEP.

Basically what this means is that you could check to see if there are any slot upgrades based on stats not including the piece you currently have on, so it would be more accurate. This is kind of a huge step towards getting what we actually need and want as far as accurate item comparison. The sheet will continue to offer being able to run SEP with all items on, so that one can still properly select gems.

Starfox · 07/23/09, 2:10 AM

Landsoul:
Can you add at least the expected DPS to the BiS lists, perhaps how the damage is distributed over the attacks?
Would be nice so I could compare them to the output from SimulationCraft and see if they are on par.
On the latest revision it seems that
Profiler - Wowhead
Here is a run with every raidbuff and bloodlust:

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

DPS Ranking:
   8154 100.0%  Raid
   8160  100.0%  Warrior_T8_19_52_00

Player=Warrior_T8_19_52_00 (fury)  DPS=8159.6 (Error=+/-5.4 Range=+/-964)  DPR=518.9  RS=15.7/15.8  (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=  8002|20%  DPET=  4850  DPR= 400.1  pDPS=1667  Miss=0.0%  Hit=4459  Crit=10147|15579|62.3%  Dodge=0.1%
    deep_wounds           Count=  0.0| 0.0sec  DPE=     1|14%  DPET=     1  DPR=   0.0  pDPS=1110  Miss=0.0%  TickCount=203  Tick=1640
    execute               Count= 14.7| 3.2sec  DPE= 10429| 6%  DPET=  6321  DPR= 144.8  pDPS= 511  Miss=0.0%  Hit=6160  Crit=14094|21606|53.9%  Dodge=0.1%
    heroic_strike         Count= 99.9| 2.8sec  DPE=  5677|23%  DPET=     1  DPR= 473.1  pDPS=1891  Miss=0.0%  Hit=3427  Crit= 7788|11454|51.6%  Dodge=0.1%
    melee_main_hand       Count= 32.4| 9.4sec  DPE=  3795| 5%  DPET=  1751  DPR=   0.0  pDPS= 410  Miss=18.2%  Hit=3026  Crit= 6236| 9027|46.8%  Glance=2273|23.9%  Dodge=0.1%
    melee_off_hand        Count=131.0| 2.3sec  DPE=  2327|12%  DPET=  1021  DPR=   0.0  pDPS=1017  Miss=18.1%  Hit=1855  Crit= 3822| 5644|46.7%  Glance=1392|24.0%  Dodge=0.1%
    slam                  Count= 20.8|12.9sec  DPE=  5809| 5%  DPET=  3520  DPR= 387.2  pDPS= 402  Miss=0.0%  Hit=3499  Crit= 7963|11782|51.8%  Dodge=0.1%
    whirlwind             Count= 69.4| 8.7sec  DPE=  4970|14%  DPET=  6024  DPR= 397.6  pDPS=1151  Miss=0.0%  Hit=2946  Crit= 6702|12154|53.9%  Dodge=0.1%

Gains:

    Warrior_T8_19_52_00:
        anger_management=93.7  (overflow=6.1%)
        avoided_attacks=1.5
        bloodrage=148.9  (overflow=2.9%)
        glyph_of_heroic_strike=515.7
        mh_attack=1219.0  (overflow=4.8%)
        oh_attack=2763.2  (overflow=9.5%)

Procs:

    Warrior_T8_19_52_00:
        bloodsurge=26.3|11.55sec
        darkmoon_greatness=7.0|46.27sec
        mjolnir_runestone=6.4|49.66sec

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.9% : berserking_oh                 
         88.9% : flurry                        
         75.5% : heroic_strike                 
          6.1% : rage_cap                      

Waiting:
    19.5% : Warrior_T8_19_52_00

Baseline Performance:
  TotalEvents   = 24228140
  MaxEventQueue = 19
  TargetHealth  = 2442323
  SimSeconds    = 2998828
  CpuSeconds    = 15.188
  SpeedUp       = 197447

RNG global Actual/Expected Roll=0.999681 Range=1.000000 Gauss=1.000511

sens · 07/23/09, 1:35 PM

Can you add the Greatsword of the Sin'dorei from Argent Tournament? I'd like to see how it compares to Titansteel Destroyer. THanks.

Faithireon · 07/23/09, 2:11 PM

Originally Posted by sens

Can you add the Greatsword of the Sin'dorei from Argent Tournament? I'd like to see how it compares to Titansteel Destroyer. THanks.

You can add it yourself quite easily. Just go to the 'Lookup' tab. Go to the Main hand section and select all the cells representing ONE weapon in the list (that is column EX through FN). Now, right click your selection and click 'Insert...'. From the new window that pops up, select "Shift Cells Down" and click 'Ok'. Plug in the item's stats into their respective columns and you can now Recalc SEP and/or resort the list.

Machinator · 07/23/09, 4:42 PM

Originally Posted by bo5r5osh

Web application has some features:

Data are hidden from user.

This doesn't seem like a feature at all. Not being able to add items or fix formulas seems like a pretty big drawback.

landsoul · 07/24/09, 6:28 AM

@ Starfox

Bleh I'd have to plug in some stuff again and crank out some numbers for you. But off the top of my head: As for Fury goes, BIS gear should get you between 6500 and 7500 DPS. Looks like berserking uptimes are too high, in the sheet it's 55%, 35%. But then again the estimation I use may not be 100% accurate against a simulator. Also Flurry Uptime some percent too low. But then again the estimation I use may not be 100% accurate against a simulator. Slam % is a little low even against in-game parses. Maybe need to take a look at your rules. I don't run execute in the spreadsheet yet. Execute shouldn't increase DPS too much for 3.1.

Machinator · 07/24/09, 4:51 PM

I would guess slam comes out low because of the abstraction of making a rotation, and static HS times.

uglygreenguy · 07/25/09, 3:19 AM

REMOVED

Graul · 07/25/09, 5:44 PM

A little confused about the "DPR" in the simulator for Heroic Strike. Is it counting the total auto attack damage on top of the Heroic bonus, or is it just counting the damage that would be removed from a glance?

bo5r5osh · 07/25/09, 8:22 PM

Originally Posted by Machinator

This doesn't seem like a feature at all. Not being able to add items or fix formulas seems like a pretty big drawback.

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 · 07/25/09, 9:21 PM

Hiding data is a drawback when there are 100s of formulas and references and only 2 people making sure they are all correct. If you have formulas open to view, a large amount of users can check correctness and return errors at a much faster rate.

Claertes · 07/25/09, 10: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, 12:54 PM

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, 8: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, 10: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, 2: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?