Warrior DPS Calculation Spreadsheet - Page 48

Paradosi · 05/01/09, 7:16 PM

Originally Posted by Shha

Well mace spec isnt worth it still until around 1700 ArP from gear. Axe spec is THAT good :P.

Yeah, I read the same thing right when GC introduced the math behind ArP shortly after 3.1 came out, but since then people discovered that boss armor can go into the negative. So is it still 1700 ArP from gear that Mace Spec compares? I would think it would be a lot closer the way Arp scales shown by those negative armor graphs people have been posting. But math is not my strong suit; I just try and follow spreadsheets and the math from others!

Grayson Carlyle · 05/01/09, 10:03 PM

Originally Posted by Linklinus

Is Expertise really that weak? I'm at 21 Expertise but the SEP value is only 1,0147 for me. (ArP is at 1,1162)
I can't belive the other Stats really compensate the dps-loss of a dodge. So should i go on gearing for Str/ArP and ignoring the expertise cap?

Arms can make up for a dodge with an extra overpower, assuming you don't already have it lit up from TfB.

• Fogbug · 05/02/09, 2:53 AM

This negative armor business really shakes up the equipment list. Assuming that Grim Toll + Mjolnir Runestone is the way to go forever, [Bitter Cold Armguards] becomes a lot better than [Decimator's Armguards] since you're going to want to shed hit in a lot of places

Graul · 05/02/09, 4:00 AM

Depending on how low you feel comfortable going with hit (as Fury obviously), Bitter Cold were already "better" according to the sheet, even without factoring in any new revelations with ArP.

fiskeboss · 05/02/09, 9:30 AM

Hey, great spreadsheet.

I am having some problems with the macros though, and would appreciate some help.
-I have office enterprise 2007
-I have enabled macros
-When I open the spreadsheet I get the message "Excel found unreadable content in "WarriorDPS2.402c.Excel07.xlsm"

Also, sword and mace spec doesn't work when I change to a sword or mace.

Kandryn · 05/02/09, 10:09 AM

Originally Posted by fiskeboss

Also, sword and mace spec doesn't work when I change to a sword or mace.

Add 5 points in cell AO16 for mace spec and AO17 for sword spec.

pudgi · 05/02/09, 8:23 PM

The chest Winter's Icy Embrace stats are a little off, it has 57 Expertise and not as it says in the spreadsheet 57 Hit

catch22atplay · 05/02/09, 8:57 PM

Originally Posted by Linklinus

Is Expertise really that weak? I'm at 21 Expertise but the SEP value is only 1,0147 for me. (ArP is at 1,1162)
I can't belive the other Stats really compensate the dps-loss of a dodge. So should i go on gearing for Str/ArP and ignoring the expertise cap?

Expertise is bugged at 5.75% or 23 expertise. At 23 expertise i tried adding a 27 expertise gem vs no gem and got no dps change at all. That was with fury. I didn't test arms. Maybe the dodge rate for a L83 boss is set to 5.75% instead of 6.50%. This does need to be fixed as it really messes things up.

Also the proc value of Mjolnir Runestone is incorrect. It should be 612 ArP. Think this was pointed out earlier. So apologies if it was. For Fury, when using 1 ArP trinket ArP for gear maxes at 619.62. With the corrected change to Mjolnir that is. Call it 620. I'd say if you use both ArP trinkets i'd not exceed 620 ArP until it's proven we can go negative. Even with 1 ArP trinket it still may not be best to exceed 620 ArP. At least not according to this spreadsheet currently. Just pointing this out so people aren't regemming all gear for like 900 ArP and an ArP trinket. I think we need more data or further testing. Unless i'm reading this wrong. Please correct me if i am.

• Fogbug · 05/03/09, 1:19 AM

Originally Posted by catch22atplay

Also the proc value of Mjolnir Runestone is incorrect. It should be 612 ArP. Think this was pointed out earlier. So apologies if it was

it looks as if the effect being applied is different from what's listed on the item: Mjolnir Runestone - Spell - World of Warcraft

• Fogbug · 05/03/09, 2:46 AM

also, I would say that ArP definitely gives a benefit past 100% right now. With a 50.5% ArP set + 10% bonus from battle + 50% from grim toll proccing there is a significant boost to damage in battle stance. Against the level 70 dummies in orgrimmar A heroic throw in zerker stance is doing 1760 noncrit and 4235 crit, whereas in battle heroic throw does 1850 normal 4431 crit

Heroic throw does very consistent damage; if I'm in battle stance with no other buffs besides grim toll a throw against a clean 70 dummy always hits for 1850 and crits for 4431

landsoul · 05/03/09, 2:30 PM

Updated.

• Fogbug · 05/03/09, 4:36 PM

Thanks landsoul, this is a huge help

Anik · 05/03/09, 7:04 PM

Awesome, thank you Landsoul.

[Tunic of the Limber Stalker] is still showing 63 ARP on the sheet.

Ryo Saeba · 05/03/09, 10:20 PM

I'm sorry if it's been asked one billion times, but I looked tru the topic and I couldn't find the answer to this problem... I can't import my armory profile :/
I'm using the eu.wowarmory.com adress in the server box since I'm an EU player, but when I click on the green button nothing happen, it didn't even pop up an error window... since I'm totally a newbie with Excel maybe I need to activate some option to make this work?
Sorry for the OT question and thanks again for your hard work Landsoul.

Vampyrr · 05/04/09, 12:11 AM

Wouldnt Bladebreaker Gauntlets be way better than the t8.5 gloves? To me those gloves look really really blah. (for arms BiS list)