Warrior DPS Calculation Spreadsheet - Page 78

nomopofomo · 06/12/09, 3:04 PM

The proc is actually higher than what's shown and haste is better for fury than it is for arms and while the proc isn't really amazing it should be slightly better than DMC:G.

Napkin math confirms, assuming it's on a 45sec ICD.

Origence · 06/12/09, 3:28 PM

I dislike the concept behind Dark Matter. Critical Strike, Hit chance or Expertise are not the stats I want to have on a proc. These are stats that show their benefits on the long run. When Dark Matter procs there are chances that it will increase your damage by 0 since it's far from certain that it will give you an extra critical attack. Actually if the proc was something like a guaranteed crit on next attack it would be more reliable.
The stats that work on a proc basis are increased attack power and armor penetration that increase the damage of all your hits during the uptime timeframe and haste that increases your number of hits. And during Execute phase the value of Haste is higher.

I have to say Im slightly dissapointed there is not a single trinket with passive ArP and AP or Haste proc. It would be really useful for builds aiming to cap ArP passively.

Revelations · 06/12/09, 11:52 PM

Might consider Dark Matter as fury, but as arms when you got the high crit chance on overpower and ms (setbonus) it doesnt look to delicious. Spreadsheet showing me a dps-loss in the 0,3ish between darkmatter and DMC:G. (as fury)

Rallik · 06/13/09, 2:32 AM

Originally Posted by nomopofomo

The proc is actually higher than what's shown and haste is better for fury than it is for arms and while the proc isn't really amazing it should be slightly better than DMC:G.

Napkin math confirms, assuming it's on a 45sec ICD.

They're close enough that it will entirely depend on the exact SEP value for haste you use. I currently use .616 as fury.

DMC:G runs 90 + 300*.32 = 186 SEP.
Comet's trail is then 240*.37878.. + .616*726*.2(will have ~20% uptime, same GT/MR/and other 10s/15% chance on hit trinkets) = 180.35.

The break even point is .655 SEP for haste to equal DMC:G. Any higher and it wins, any lower and DMC:G wins. For Arms, there is no chance Comet's Trail will ever be comparable to DMC:G since haste is so much worse for it.

Emeraude · 06/13/09, 7:56 AM

Originally Posted by Rallik

They're close enough that it will entirely depend on the exact SEP value for haste you use. I currently use .616 as fury.

DMC:G runs 90 + 300*.32 = 186 SEP.
Comet's trail is then 240*.37878.. + .616*726*.2(will have ~20% uptime, same GT/MR/and other 10s/15% chance on hit trinkets) = 180.35.

The break even point is .655 SEP for haste to equal DMC:G. Any higher and it wins, any lower and DMC:G wins. For Arms, there is no chance Comet's Trail will ever be comparable to DMC:G since haste is so much worse for it.

I take it this is always assuming's Thorim's 10-man Runestone as the 2nd trinket? Or were you just comparing these 2.

Phatha · 06/13/09, 7:32 PM

I just picked up new bracers and dropped some expertise by doing so. I'm sitting at 21 expertise and adding one Precise Scarlet Ruby (16 exp) only puts me at 23 expertise, but the spreadsheet is showing Expertise as .4231 SEP. I'm pretty certain that the cap is 26 (technically slightly lower), but I'm wondering why the sheet isn't showing a higher SEP value for expertise since I'm not capped. Did I miss something?

Vashar · 06/13/09, 8:16 PM

Originally Posted by Phatha

I just picked up new bracers and dropped some expertise by doing so. I'm sitting at 21 expertise and adding one Precise Scarlet Ruby (16 exp) only puts me at 23 expertise, but the spreadsheet is showing Expertise as .4231 SEP. I'm pretty certain that the cap is 26 (technically slightly lower), but I'm wondering why the sheet isn't showing a higher SEP value for expertise since I'm not capped. Did I miss something?

Probably because you have a Mace/Sword in one MH/OH slot and expertise is only benefiting the non-Mace/Sword slot because the racial weapon specialization only affects the hand wielding that weapon type.

Jayde · 06/13/09, 8:20 PM

That and for Arms, at least, having a minor chance to be dodged isn't that big of a deal.

Phatha · 06/14/09, 2:09 AM

Well, I'm fury, wielding Ironsoul/Stormedge and character sheet in game is showing 23/20 expertise. So I'm definitely below the expertise cap. Spreadsheet is showing 23 expertise with 3 from racial (changing race from human to gnome reduces expertise on spreadsheet to 20). So I'm still not sure what's going on.

Shha · 06/14/09, 2:33 AM

Maybe you have weapon mastery checked? Or lower lvl mobs (or pvp) selected.

Sentia · 06/14/09, 1:58 PM

Well, I'm fury, wielding Ironsoul/Stormedge and character sheet in game is showing 23/20 expertise.

This seems correct, the racial will only effect a weapon hand with a mace (or sword) in it. Getting your main hand to 26 is preferable.

Vashar · 06/14/09, 2:42 PM

Originally Posted by Phatha

Well, I'm fury, wielding Ironsoul/Stormedge and character sheet in game is showing 23/20 expertise. So I'm definitely below the expertise cap. Spreadsheet is showing 23 expertise with 3 from racial (changing race from human to gnome reduces expertise on spreadsheet to 20). So I'm still not sure what's going on.

Just to make sure it's not a dumb mistake, are you forgetting to click the big green button next to the SEP values after modifying everything (with macros enabled)?

Phatha · 06/14/09, 9:03 PM

To Shha: Weapon mastery is showing 0 points.

To Sentia: Obviously I know that 26 expertise is preferable... That's why I'm asking the question in the first place.

To Vashar: Yes I reclicked the green button for a re-evaluation of the SEP values. If I change the 16 Exp gem in my bracers to a 16 Str gem, Expertise is showing 1.3998 SEP value. When I change it back to the 16 Exp, it drops down to .4247 SEP.

I probably have something messed up something in the spreadsheet, but wanted to check if anyone else was showing some oddities regarding Exp. I'll regem to make sure I'm capped but still seems odd since I've gone over all of my enchants, gems, gear, etc at least 3 times now in the sheet. And since the unbuffed stats match my character sheet almost exactly (missing 27 AP in game compared to spreadsheet), this whole thing seems odd.

phantomlink · 06/15/09, 12:48 AM

Originally Posted by Phatha

To Shha: Weapon mastery is showing 0 points.

To Sentia: Obviously I know that 26 expertise is preferable... That's why I'm asking the question in the first place.

To Vashar: Yes I reclicked the green button for a re-evaluation of the SEP values. If I change the 16 Exp gem in my bracers to a 16 Str gem, Expertise is showing 1.3998 SEP value. When I change it back to the 16 Exp, it drops down to .4247 SEP.

I probably have something messed up something in the spreadsheet, but wanted to check if anyone else was showing some oddities regarding Exp. I'll regem to make sure I'm capped but still seems odd since I've gone over all of my enchants, gems, gear, etc at least 3 times now in the sheet. And since the unbuffed stats match my character sheet almost exactly (missing 27 AP in game compared to spreadsheet), this whole thing seems odd.

I had the same thing happen when my expertise was sitting at 22/27, the spreadsheet told me expertise was around 0.4 or so compared to str, but I ended up getting it sitting at 26 after I got an upgrade

belth · 06/15/09, 3:45 PM

I have a problem with the excel 2007 spreadsheet that perhaps someone can help me with.

When I open the file, obviously with excel 2007, I get the message:
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))

To clarify, I have done everything said in the Intro page of the file.
Such as enabling macros etc.
But the macros still won't work.

Is there anyone who could have an idea what I need to do to get it running?
If I need any specific download from microsoft perhaps?

Thanks in advance anyway, please send a pm to me with the solution if you have one!
Really need to get those SEP values working.