Warrior DPS Calculation Spreadsheet - Page 71

Kalroth · 06/02/09, 6:19 PM

Originally Posted by MikHaven

Either way, ignoring 100% of the armor, without sunders, would eliminate the need to sunder, ff.

This is a pretty moot point even if this was possible (which it isn't), since Sunder Armor and Faerie Fire aren't applied just for you. Both debuffs benefit the entire raid; warriors, feral druids, rogues, hunters, enhancement shamans and so on. So you're doing it wrong if you're gearing for 100% ArPen in a raid enviroment.

Now if you're doing it because you want to solo mobs more efficient then I think you'll find that there are other stats that benefit you more, simply because ArPen is less of a damage increase on NPCs with lower armor.

Free free to play around with numbers in my ArPen calculator, which to my knowledge is pretty accurate. As long as you use the capped summary, of course.

Eregond · 06/02/09, 6:22 PM

Originally Posted by MikHaven

Thats exactly my point but worse off, but still probable.

Your saying the mob has 10k armor, sunders ignore 3k, their armor is 7k. Numbers are just representative.

It's not exactly your point since the value your armor penetration is affecting is Min(armor, (armor+15232.5)/3), not armor directly. Above 7616 armor sunder will be effective regardless of your armor penetration. At any armor rating and any choice of debuffs armor penetration will be effective up to the 100% cap. How effective is the only concern, but this distinction is generally more interesting in pvp.

MikHaven · 06/02/09, 8:46 PM

First of all I wanted to thank the Warrior Community, for allowing me to hash this out, it answered a TON of questions I had about armor, and I appreciate the feedback and patience. I've been wrong a lot today, and appreciate the right direction to head now.

Originally Posted by Kalroth

Free free to play around with numbers in my ArPen calculator, which to my knowledge is pretty accurate. As long as you use the capped summary, of course.

This website REALLY helped me in the problems I was having, and shows armor to be a much more complicated stat than I made it out to be. The information and depth of the problem is nicely laid out, and while this is a page dedicated to the amazing job Landsoul is doing, this is a community effort, and hope eventually I can help.

Anyways thanks, Heres to the community and the people in this thread that are patience and helpfull.

Hornbreakerz · 06/03/09, 2:22 AM

Hi, I recently dinged with my warrior to 80 and playing arms. I've always been a big fan of Loot Rank and using it daily for my shaman. I've been trying to find an easy way to see what gear I want for arms, but I haven't been able to find it.
I've tried the spreadsheet in this thread but it involves some macros, which I cannot use on my Mac.
And I haven't been able to find any post on arms warrior itemization as of 3.1

So if anyone could give me a "default" EP or input my warriors gear in the spreadsheet (Hayak - Kilrogg EU) it would be greatly appreciated.

Thanks in advance.

Mansch · 06/03/09, 3:56 AM

Blessing of Kings in Fury and Arms is not the same I have not delved very deep into which is correct but I think Kings is not correct in Fury.

Hamburglar · 06/03/09, 4:34 AM

Anyone else having issues with selecting gears / gems themselves, pressing for SEP calculation and ending up with #DIV/0! text in the stats-window? I tend to get these errors now and then, but I`m not sure whats causing them. Could just be that the spreadsheet gets confused when I first try to import, fail (with a run-time error) and then try to update manually.

Speeder · 06/03/09, 4:42 AM

Originally Posted by Hamburglar

Anyone else having issues with selecting gears / gems themselves, pressing for SEP calculation and ending up with #DIV/0! text in the stats-window? I tend to get these errors now and then, but I`m not sure whats causing them. Could just be that the spreadsheet gets confused when I first try to import, fail (with a run-time error) and then try to update manually.

In Excel:
Tools > Options > Calculation > Check Iteration option

derfél · 06/03/09, 8:00 AM

first of all i must thank you for the insane amount of work you putted
in this spreadsheet....
but theres one thing i dont understand...
yesterday i got lucky and i dropped a rune edge, so now i have rune edge plus betrayer
why i obtain an higher dps if i put rune edge in offhand??(on the spreadsheet)
has more max damage should be my main hand...
im confused now

Eregond · 06/03/09, 8:20 AM

Originally Posted by derfél

first of all i must thank you for the insane amount of work you putted
in this spreadsheet....
but theres one thing i dont understand...
yesterday i got lucky and i dropped a rune edge, so now i have rune edge plus betrayer
why i obtain an higher dps if i put rune edge in offhand??(on the spreadsheet)
has more max damage should be my main hand...
im confused now

Armory is down for me but you are an orc, so racial expertise for your mainhand would only be active when using the betrayer there. Is it possible you're not expertise capped?

derfél · 06/03/09, 8:25 AM

im 2 points lower on off hand and 1 point overcap on axe

muramid · 06/03/09, 8:37 AM

Hey Landsoul would it be possible to put in Enchant Boots - Tuskarr's Vitality - Spell - World of Warcraft into the spreadsheet? Also, how much dps would it increase on moving fights, i read that it gives approximately 30 dps if you have to move every 4 second's in a fight that lasts 5 mins.

Lantador · 06/03/09, 9:05 AM

Originally Posted by muramid

Hey Landsoul would it be possible to put in Enchant Boots - Tuskarr's Vitality - Spell - World of Warcraft into the spreadsheet? Also, how much dps would it increase on moving fights, i read that it gives approximately 30 dps if you have to move every 4 second's in a fight that lasts 5 mins.

I think thats complete speculation and no definitive answer can be given. I still think the 12hit/12crit enchant is far superior in a raid environment, especially if you pop that extra talent point into heroic fury as a fury warrior. I more or less never ever have to move in the normal slowpoke way in more than one direction on any Ulduar encounter (like Mimiron, XT or Algalon), since intercept is always up for me. So IMO Tuskarr's Vitality is a waste. Even if you are well above the hitcap, I would still go for 12hit/12crit.

Kalroth · 06/03/09, 9:17 AM

Originally Posted by muramid

Hey Landsoul would it be possible to put in Enchant Boots - Tuskarr's Vitality - Spell - World of Warcraft into the spreadsheet? Also, how much dps would it increase on moving fights, i read that it gives approximately 30 dps if you have to move every 4 second's in a fight that lasts 5 mins.

Just select 'None' to simulate the DPS gain from 15 stamina.

There's an entire religion behind enchanting boots with minor speed, but personally it comes down to this: being able to move a little faster (depending on your guilds strategy of course) will not only increase your overall DPS, but also make you take less damage and get out of harms way quicker. The DPS of a dead warrior is usually pretty shit.

Jayde · 06/03/09, 10:17 AM

Well, the math is simple enough for run speed really.

If you do X DPS, and you run for Y seconds per minute, you will gain (X*Y*0.08)/60 DPS

So, if you do 5766 DPS (just using my Arms spreadsheet DPS for ease) and run for 4 seconds every minute, you'll gain:
(5766 * 4 * 0.08) / 60 = 30.752 DPS

If I remove Icewalker on the sheet, I lose 33 DPS (mostly because it drops me below the hit cap, so will be less if you were above the hit cap enough that you didn't need the +12 crit).

So, considering it lowers the risk of death from the plethora of void zones and Bad Stuff (tm) in many fights, it's probably a worthy trade-off to consider. (The problem with relying on Charge/Intercept is that while they are good at getting you back, they usually can't move you out of stuff!)

muramid · 06/03/09, 10:30 AM

Originally Posted by Lantador

I think thats complete speculation and no definitive answer can be given. I still think the 12hit/12crit enchant is far superior in a raid environment, especially if you pop that extra talent point into heroic fury as a fury warrior. I more or less never ever have to move in the normal slowpoke way in more than one direction on any Ulduar encounter (like Mimiron, XT or Algalon), since intercept is always up for me. So IMO Tuskarr's Vitality is a waste. Even if you are well above the hitcap, I would still go for 12hit/12crit.

I think it's a better enchant than Icewalker because you simple will move faster away from the void zones etc, and if you have a bad computer and you are lagging the Tuskar's enchant is must.