Warrior DPS Calculation Spreadsheet - Page 184

Ragnernon · 04/13/10, 7:22 PM

I know, there are already lots a BiS Lists on the first page, but it would be great if there is one for heroic too, without Arthas HC loot.

catch22atplay · 04/13/10, 9:47 PM

So as we're getting more gear and reducing fight lengths i think we need a bit more accuracy with the spreadsheet. I had previously asked that the spreadsheet change the way Bloodlust/Heroisim works. The spreadsheet is set up for an infinite fight length. I'd rather we be able to set the length of the fight and have the spreadsheet update the DPS based on this. Since Bloodlust/Heroism can really effect dps i've concentrated on this. I changed one calculation as follows on the Fury page.

Cell N26 reads as such.

(1+(T325+AO298)/E89/100)*(1+MAX(Z24*(0.16+0.02*AA24),0.2*Z26*AA26/100))*(1+MAX(AA29/100,AA31*0.03))*(1+0.02*AG267*AH267)*(1+0.02*AG268 *AH268)*(1+AJ327*AH327*AG327)*(1+0.05*AL13*AA56)*( 1+0.3*AP36*40/600)-1

See the 600 almost at the end. This indicates 10 minutes. What i want instead is to be able to change the duration of the fight so Bloodlust is more accurate. I do this by changing 600 to G44. So it looks like this instead.

(1+(T325+AO298)/E89/100)*(1+MAX(Z24*(0.16+0.02*AA24),0.2*Z26*AA26/100))*(1+MAX(AA29/100,AA31*0.03))*(1+0.02*AG267*AH267)*(1+0.02*AG268 *AH268)*(1+AJ327*AH327*AG327)*(1+0.05*AL13*AA56)*( 1+0.3*AP36*40/G44)-1

Now i can change the duration of the fight in Cell G44. Setting duration to 600 matches the previous dps value shown. Obviously setting the duration lower increases the dps as it should. For Arms you change the calculation in N26 to G42 instead of G44.

I'd think this would be worth changing in the spreadsheet. Just have the duration in cell G44 (Fury) and G42 (Arms) set to 600 as default and add a comment to the cell. Or leave it at 360 default so you don't have to change all the ability usage amounts MS, OP, WW, BT, etc, etc.

landsoul · 04/14/10, 4:11 AM

That's a reasonable change. I'll look into a fight duration option when I release patch this weekend.

tgouned · 04/15/10, 8:21 AM

Maybe this has been remarked already, but I'm going to state it anyway in case you might want to add it in this next release ^.-

Typo: Njorndar Bone Bow, not Njordnar Bone Bow
Every time I import from the armory, I get an error message asking me to use a custom item for it.

Devlin1991 · 04/17/10, 12:45 PM

Don't think it's been mentioned yet.

[Vengeful Noose]

+4 agi bonus on spreadsheet

+6 agi bonus on live 3.3.3

Turpin · 04/17/10, 3:08 PM

Page: Fury
Error Type: Calculation
Cell D40 uses 4% per rank of Imp Berserker Stance instead of 2% for Threat Reduction. Change the part that says "(1-0.04*AL16)" to "(1-0.02*AL16)".

landsoul · 04/18/10, 12:52 AM

Thanks for the errors guys. I fixed pretty much everything that was mentioned plus what's in the error log on the first post.

Well I have a few issues with allowing for a specific fight length.

First issue is, it will affect how hysteria, tricks, and shattering throw are tabulated.
Secondly, it will increase DPS metric in general, straying away from the it's historical accuracy over the past year.
Thirdly it was mentioned to just have it modify only the percentage of the fight that Heroism/Bloodlust covers when in truth other things are affected as well. Is it kosher to make this modification only to increase the effectiveness of Heroism/Bloodlust in the spreadsheet?

Cipri · 04/18/10, 7:26 AM

Page: LOOKUP
Error Type: CONCEPT

The lookup page incorrectly lists "Glyph of Bloodthirst" as a minor Glyph

catch22atplay · 04/18/10, 7:51 PM

It's been historically accurate since the rage issue was fixed 10 months ago or so for long duration fights. It's been historically inaccurate for short length fights. Granted we're all aware of the limitations as we know it isn't set up for those short length fights. But when i can beat the spreadsheet and i often do. Example Festergut WoL report 13,151 dps vs spreadsheet's 12,022 This is when i look for ways to make it more accurate for these short duration fights.

Shattering throw you can just replace the 3 instances of 300 with G44 in cell D73. Then remove cell AP37 note that says /5min. Not sure if that's the correct way to do it.

Tricks i'd probably leave alone as you can set how many tricks per 30 seconds.

Hysteria has a bit longer of a time table with how many per 3 minutes. Changing that one would require changing cells D78,D79,F78,F79.

Then you'd also need to change Death Wish in D79 and F79 to work with a duration.

Recklessness would also need to be changed. Although i don't see it referenced anywhere. Maybe i'm blind.

It seems like a lot of work. I was looking for a baby step in the right direction with the Bloodlust/Heroism change and not a complete overhaul. Especially as we move closer to Cat and Haste becomes one of our primary stats to use.

Turpin · 04/18/10, 10:45 PM

I would think heroism and death wish would cover most of the cases for modeling since things like tricks, shattering throw, and hysteria dont happen as often for most warriors.

Nate1492 · 04/21/10, 12:16 PM

Why not just attach a modifier to bloodlust/tricks/etc.

Basically, If you assume heroism is only active once every 10 minutes, you can modify how often it is used.

So instead of doing anything different, just allow for changes to heroism and other CDs.

So for a 5 minute fight, just make heroism go "twice" or heroism /5 instead of /10.

Basically, you can simply change coeffs to match fight length. You don't have to make fight length the factor.

Example, if you put a fight at 5 minutes, you would divide all buffs by 5 if > 5. If the buffs were less than 5, simply divide buffs by a rounded up value and multiply.

Basically this logic.

X=Fight Length.
Y=Buff Cooldown
Z=Buff Count

If X< Y.SpecificBuff Then Z.SpecificBuff=1
Else X/Y.SpecificBuff = Z (Rounded up to the next whole number).

And then set all buff timers to the fight length with the count specified based on the above.

This will be an easy and accurate dps count for the specified fight length while still leaving everything else alone!

landsoul · 04/21/10, 7:49 PM

I did a smaller update. This does not include fight length changes because implementing that requires a lot more changes and moving things around than I have time to sort through at the moment. Again, the download links are via my guild webpage, which is linked from the first post.

Jambo354 · 04/22/10, 11:12 AM

PAGE: Lookup
ERROR: Typo
Ramaladni's Blade of Culling - Item - World of Warcraft should have 185 stamina instead of 164.

ProtoformX · 04/24/10, 2:08 AM

First I want to say what a great tool this is!

Here's the error I found:

Page: LOOKUP
Error Type: TYPO
Warmace of Menethil (reg) ilvl is incorrect.
IS: 264
SHOULD BE: 258
Found this was the source of the fetch armory error I kept having: it kept putting the heroic version on my paper doll because the ilvls didn't match in Function validateItemName.

tgouned · 04/25/10, 2:02 PM

I got a little problem with this 2.602b Sheet.

It tells me I'd do 6948 dps, while the "a" one tells me 9880. Why is that?