Warrior DPS Calculation Spreadsheet - Page 93

BWarner · 08/10/09, 3:50 PM

Factoring in Dodges for Arms would be pretty fantastic. Also, modeling Execute phase would be great. =D

Ronninn · 08/10/09, 4:30 PM

Hi Landsoul, I appreciate all the hard work you've put into this spreadsheet, and I use it all the time. I was just wondering if you had considered putting in an area that computes the PAWN Strings similar to the hunter dps spread sheet. That way it would be easy to have your spread sheet provide values that a user could copy/paste in game with addons such as PAWN to compute whether a givin item would be an upgrade, or downgrade. As the user gets new gear, he updates your spreadsheet, computes the new PAWN String, then pastes it into the addon since they will always be changing based on your stats.

Just something I'd been thinking about that I though could be cool.

Thanks again

evilkyle · 08/10/09, 4:32 PM

Well I decided to just add in a lot of the possible upgrade and came up with my own Shopping list. I know it's off total dps wise, but it still lets me know which piece per piece is better.

Anxiously awaiting the new spreadsheet Landsoul.

Thymoleon · 08/10/09, 4:39 PM

I've been trying to download the spreadsheet for three days but the filefront dlink keeps timing out. Can you reupload it or can someone up it to a mirror?

Vranx · 08/10/09, 6:35 PM

Originally Posted by Thymoleon

I've been trying to download the spreadsheet for three days but the filefront dlink keeps timing out. Can you reupload it or can someone up it to a mirror?

Same for me, the Excel 07 times out.

Gustave · 08/10/09, 7:47 PM

Here's the current WarriorDPS2.406bExcel07 I uploaded for those that can't get to it.....

IMPORTANT(maybe) - I replaced [Girdle of Embers] with [Girdle of the Impaler] as that is what I use, if you need to have [Girdle of Embers] on there you can just go to lookup and make the desired changes.

Other than that nothing else major changed on the sheet.

Cheers

landsoul · 08/10/09, 9:05 PM

Anyone else notice that the game truncates strength? I was double checking stuff as arms today and I noticed my Strength was 1 point lower in game than it should be. I checked it out and it actually runs it like this:

nightelf:
int(171*1.04)+int(1187*1.04) gives 1411

instead of
int(1.04*(171+1187)) gives 1412

not that it makes a huge difference, but this is what could be the reason why the AP etc from the spreadsheet is a few pts different than the game. I'd be interested to see how this interacts with other buffs. Maybe in a later build I can double check all of the different buffs to see how they interact with this idea.

Also, good news: I got the fury SEP calculation macro operation down to 1.5 seconds runtime (on my machine) which is very very awesome.

Tashlama · 08/11/09, 3:20 AM

Thanks Landsoul and all the guys doing the heavy duty here =p.
I play in a 10man only guild, and would like to ask if you guys, if possible of course, can make a "bis" list for the 10man versions of Ulduar and the new raid.
I have made my personal list, but i would like a more "mathematical" list, just to be sure if i made many wrong choices.

I went through the lookup tab and cleared out lots of 25 man items, leaving only 10 man, 10 man hardmode, badge rewards, craftables and 25 man gear I already have. Played around with the spreadsheet for a while and I think I have a BiS for fury. Let me know if it's similar or different.

Helm: [Conqueror's Siegebreaker Helmet]
Neck: [Favor of the Dragon Queen]
Shoulder: [Valorous Siegebreaker Shoulderplates]
Cloak: [Drape of the Faceless General]
Chest: [Conqueror's Siegebreaker Battleplate]
Bracers: [Bitter Cold Armguards]
MH: [Aesir's Edge]
OH: [Aesir's Edge]
Gloves: [Bladebreaker Gauntlets]
Waist: [Soul-Devouring Cinch]
Legs: [Valorous Siegebreaker Legplates]
Feet: [Boots of Living Scale]
Ring 1: [Bladebearer's Signet]
Ring 2: [Brann's Sealing Ring]
Trinket 1: [Mjolnir Runestone]
Trinket 2: [Dark Matter]
Ranged: [Twirling Blades]

I don't have the resources to get the Greatness card or the Melancholy Sabatons.

Grimmli · 08/11/09, 4:08 AM

Originally Posted by Dalch

Thanks Landsoul and all the guys doing the heavy duty here =p.
I play in a 10man only guild, and would like to ask if you guys, if possible of course, can make a "bis" list for the 10man versions of Ulduar and the new raid.
I have made my personal list, but i would like a more "mathematical" list, just to be sure if i made many wrong choices.

I think a 10man only BiS-List for both instances would look something like this:

Head: [Hellscream's Helmet of Triumph] (245)
Neck: Collar of Unending Torment (245)
Shoulders: [Hellscream's Shoulderplates of Triumph] (245)
Back: Cloak of Serrated Blades (258)
Chest: [Hellscream's Battleplate of Triumph] (245)
Wrist: Armplates of the Nether Lord (245)
Hands: Sunreaver Assassin's Gloves (245)
Waist: [Soul-Devouring Cinch] (226)
Legs: [Hellscream's Legplates of Triumph] (245)
Feet: Acidmaw Treads (245)
Ring1: Planestalker Band (245)
Ring2: Carnivorous Band (245)
Trinket1: [Dark Matter] (226)
Trinket2: [Darkmoon Card: Greatness] (200)

Main Hand: Edge of Agony (245)
Offhand: Edge of Agony (245)
Ranged: Frenzystrike Longbow (245)

catch22atplay · 08/11/09, 4:58 PM

Not to increase the already overwhelming changes coming soon. But i'm looking at rage again on the spreadsheet with Fury. The new changes to Bloodrage. But i'm also looking into the actual practical use of imp zerker rage. This one has always bugged me when i try to use Zerker in game. I'll try to explain and with approx values.

Old

1 point in Anger Management=0.3333 rage per second
1 point in Imp Zerker rage=0.4975 rage per second
1 point in Imp Bloodrage=0.1244 rage per second

New

1 point in Anger Management=0.3333 rage per second
1 point in Imp Zerker rage=0.4975 rage per second
1 point in Imp Bloodrage=0.1866 rage per second

My problem is with imp Zerker Rage. Zerker can only be used on an open GCD as such BT,WW,BS,BT,Zerker,BS repeat rotation. It can only be used where i just showed it being used. Our rotation is 9 seconds. This mean we can only use it every 3rd rotation ie every 27 seconds. If we get a BS proc in that particular spot we should use the BS instead. This means at least 20% of the time we won't be able to use Zerker Rage until the 4th rotation. You can use zerker rage at other times. However you'd loose dps by doing so. Such as using Zerker and having it delay BT for 0.5 seconds. An example of what not to do. BT,WW,Zerker,BT,BS,BS, repeat. Also pointing this out so fury warriors understand this if they don't already know.There's only 1 real spot you can use Zerker as i showed. By using Zerker optimally and not delaying other abilities i get as below for rage.

so 10 rage/27=0.37073 etc
0.37073 etc*4=1.481
10 rage/36=0.2778
1.481+0.2778=1.7588
1.7588/5=0.35176

So in actuality and practical use 1 point in Imp Zerker rage is really only 0.35176 rage per second and not 0.4975. So it instead looks like this.

New and with practical use ie real world

1 point in Anger Management=0.3333 rage per second
1 point in Imp Zerker rage=0.35176 rage per second
1 point in Imp Bloodrage=0.1866 rage per second

I did not however factor in getting a BS proc from including HS use which increases the chances of delaying using Zerker to the 4th rotation nor did i factor in getting another BS proc to delay Zerker to a 5th rotation. I did try to math it earlier and came up with a lower number which included HS use. However i think the above is close enough. Or maybe perhaps not. I did come up with 0.3251 or something to this effect ie < Anger Management as absolute worse case scenario. So while i don't have an exact average number. I do feel that 0.35176 rage per second is the max amount of rage 1 point in imp zerker should be giving on the spreadsheet.

AH i'm being told this may be included in the new spreadsheet. It's getting damn hard to find even the littlest of areas to improve upon. Hopefully it improves upon the numbers i got as mine are a bit incomplete as i've shown. It's an extremely minor detail. We're talking less than 10dps. In fact it's only 5dps with my current gear. But it's this attention to detail that makes this spreadsheet so great.

Hm i forgot to also include the use of Deathwish. This will also delay when Zerker can be used. The next open GCD will then be used for Recklessness which delays Zerker yet again. Also forgot Heroic Throw. Gads time to redo the math. I think this just put Anger Management above imp zerker for rage per second, point for point. It may be easier just to call them a dead tie and have them both at 0.3333 rage per second. The modeling needed to get a precise value is just to much work.

Out of curiosity i wanted to see how much rage i'm getting in an Ulduar raid. I checked 1 log and got these results. 3/3 Intensify rage fyi. And listed from highest to lowest.

Bloodrage=0.7346 rage per second (0/2 imp bloodrage, btw 0.7463 is max possible with 0/2 and means i'm only off by 0.0117)
HS glyph=0.6574 rage per second
Unbridled Wrath=0.5643 rage per second (5/5 Unbridled wrath)
Anger Management=0.3333 rage per second
Zerker Rage=0.0933 rage per second (using 1/2 imp zerker rage)<----FAIL

I either suck at Zerker rage use or i'm not getting those open GCD's. I'm leaning towards the sucking part. I do like my Bloodrage use though. Very disappointing results to say the least in regards to Zerker. I almost wish i didn't look. Does this mean 1 point in imp zerker is less than Anger management. Well for me the obvious answer is yes. The question is what's the true max potential and practical use you can get out of imp zerker without screwing up your dps in the process.

Arantis · 08/11/09, 9:33 PM

You should also take into concideration the use of executes which diminishes even more the global cds.

gab · 08/11/09, 9:39 PM

Well I like using imp Zerk Rage with 1/2 because it's a quite good way to gain some extra rage when you need it.
I mean you can decide for yourself in every situation to pop it and gain extra rage.

Axira · 08/11/09, 10:45 PM

Very weird catch22atplay,

World of Logs - Real Time Raid Analysis

I picked a 217 seconds Auriaya fight, where i had a decent 6,5k DPS (while also being the sunder armor bitch) and got the following results instead:
(This was the latest most representable bossfight I could find, as it's as close to tank&spank as it gets)

Glyph of Heroic Strike: 220 rage
Berserker Rage Effect: 140 rage (0,645 rage / second *without including the extra rage gained from damage with BR up)
Bloodrage: 100 rage (Instant rage)
Bloodrage: 43 rage (non-instant rage over 10 seconds)
Rapture: 8 rage

IBR still seems a strong choice per talent point. "1/1 Anger Management + 1/2 IBR" seems to be the best choice though as it would've given 72 rage over 217 seconds (0,333 rage/second) from anger management alone, which is a slightly better number than IBR per talentpoint. Guess I'm off to respec then.

Edit: Analyzing my log further, I don't seem to prioritize slam much over BT often (and definitally not over WW), which should be okay since BT does slightly more DPS anyway if rage is not an issue. I don't seem to prioritize BR over slam though. So my DPS rotation should be representable as well in that log. (Don't mind the other bosskills in that log though, the Thorim log was made by the tank in the gauntlet (while I was in the arena) and on Freya I had roots and trees duty.)

catch22atplay · 08/11/09, 11:36 PM

Ty Arantis i missed that one as well.

I agree with Gab in that it can be quite useful. I'm not saying it isn't. It's why i have it currently. I just fail in it's use.

Axira you're just showing how badly i fail at using Zerker rage. You also confirm that point for point Anger Management beats imp Zerker rage point for point. You're getting 0.3226 rage per second per point spent. I will assume you used it optimally and didn't cause any delays of other abilities for a dps loss.

LOL@respec. I may join you at the trainer. I got 2 choices. Use Zerk more often or grab another talent. Hell i'd be better off with the crappy 1/2 in imp bloodrage. But i can't deal with defeat. I think i'll just do better or at least try to.

Graul · 08/11/09, 11:45 PM

I had 1/2 Imp Berserker before the Bloodrage change, but I noticed it was conflicting more with globals than actually helping with rage generation. The recent Bloodrage change basically gives me the same rage as before with no conflicts and also lets me grab Heroic Fury which is pretty useful overall and more than makes up for any small DPS loss on a tank and spank only situation by being better on mobility fights and any fight where you will be rooted.