Warrior DPS Calculation Spreadsheet - Page 108

Goatsey · 09/04/09, 10:17 PM

Originally Posted by Archex

Armor Pen nerf on the PTR: World of Warcraft - English (NA) Forums -> Armor pen nerf in 3.2.2

Takes the "125% of previous effectiveness" buff and turns it into 110%...any thoughts on how to tweak the spreadsheet to judge the impact?

Go to cell E86, the armor penetration rating required for 1% cell. Simply change the 1.25 at the end for 1.1.

Basically the cell reads before:

=4.69512177*((82/52)*(131/63)^((AI1-70)/10))/1.25

and after the change:

=4.69512177*((82/52)*(131/63)^((AI1-70)/10))/1.1

doniazade · 09/05/09, 5:05 AM

Page: Fury, Arms, Lookup
Error type: Missing item

There's only one version of Edge of Agony(aka Reckoning) listed. The mainhand slot only has the normal version while the offhand only has the heroic version.

Also, thanks for your excellent work on this awesome spreadsheet.

Anduryondon · 09/05/09, 9:00 AM

Regarding BiS List:
With the ARP Nerf i get better results with Belt of Deathly Dominion instead of Bloodbath Belt.

Rushed · 09/05/09, 10:35 AM

With full BiS gear I've managed get 10074 DPS, however, with the new ArP nerf this is reduced to 9671 DPS.

After quickly swapping the ArP gems out for Str, this comes back as 9587 DPS with an ArP trinket equiped (MR). Not such a huge difference as previously mentioned. I'll have another play with the gear set-up later to see if I can tweak it a bit.

Shha · 09/05/09, 10:45 AM

BiS list i get better results swapping :

Planestalker Signet for Ring of Callous Aggression
Belt of Deathly Dominion for Bloodbath Belt
Greaves of the 7th legion for Sabatons of Ruthless Judgement. 10180 dps reduced to 9698 after nerf.

Still working on the arp nerf one.

8ina8ik · 09/05/09, 10:57 AM

Page: Lookup
Type: Reference

There is an error on names of bracers (horde side), where it says "Armbands of Nether Lord" must say "Armplates of Nether Lord", same with heroic version of those bracers. Solution is very simple if you subst the two lines for:

IF($C$7="Alliance";"Armguards of the Nether Lord (Heroic)";"Armplates of the Nether Lord (Heroic)")

IF($C$7="Alliance";"Armguards of the Nether Lord";"Armplates of the Nether Lord")

respectively (take care of number of cell when you subst, it depends on your gear, it's 7 for me but can change for you)

Great job with your sheet Landsoul

Kaywarrior · 09/05/09, 12:58 PM

Originally Posted by Archex

Armor Pen nerf on the PTR: World of Warcraft - English (NA) Forums -> Armor pen nerf in 3.2.2

Takes the "125% of previous effectiveness" buff and turns it into 110%...any thoughts on how to tweak the spreadsheet to judge the impact?

The cap for ArP will go from 1231 to 1399, which isn't that big of an increase. I believe the absolute best will still be using Death's Verdict / Comet's Trail and gem for ArP in every socket after exp/hit cap.

Swamplord · 09/05/09, 1:05 PM

Page : Arms
Type : Reference

The expertise calculation doesn't take into account racials in the arms sheet.

...+IF(AND(RaceDropdown="Human"...+IF(AND(RaceDropdown="Orc"

in cells J28, L28, N28 and P28 should be replaced with

...+IF(AND(RaceDrop="Human"...+IF(AND(RaceDrop="Orc"

meatmick · 09/05/09, 8:18 PM

I can't do the SEP calculation. When I load my armory it's ok then as soon as I try to run the SEP I get the ##value for my dps and quite a few other values.

It worked in the other version though.

dageny · 09/06/09, 12:32 AM

Upon upgrading my chest and thusly loosing my t8 2pc bonus, the spreadsheet doesn't show a dps loss....how much dps loss is the t8 2pc bonus and can that be incorporated into the spreadsheet. Thanks.

Shrakz · 09/06/09, 12:58 AM

Originally Posted by dageny

Upon upgrading my chest and thusly loosing my t8 2pc bonus, the spreadsheet doesn't show a dps loss....how much dps loss is the t8 2pc bonus and can that be incorporated into the spreadsheet. Thanks.

From my own logs, the buff from this set bonus is up between 15 and 30 % of the time. That's 150 haste rating when it's up. If you average this haste rating it would give you between 22 to 45 haste rating overall throughout the fight... which, is really not that great for either dps specs.

I really wouldn't worry about breaking the T8 2pc bonus if you have any piece that's really better to balance out your stats.

Asgermun · 09/06/09, 2:49 PM

Originally Posted by meatmick

I can't do the SEP calculation. When I load my armory it's ok then as soon as I try to run the SEP I get the ##value for my dps and quite a few other values.

It worked in the other version though.

Same, there is might be something that i don't get.

Plus i realised something, by default the racial state is Night Elfe. With my gear/enchants i'm at 7088 dps. When i switch to my actual race, orc, i get down to 4890ish dps. O.o why?

Lifthrasil · 09/06/09, 7:39 PM

Originally Posted by Asgermun

Same, there is might be something that i don't get.

Plus i realised something, by default the racial state is Night Elfe. With my gear/enchants i'm at 7088 dps. When i switch to my actual race, orc, i get down to 4890ish dps. O.o why?

The default setup contains some alliance only equipment. Those aren't giving a single SEP when switching to a horde race... Replace with horde only äquivalents and you should get back to ~7k

Meliora · 09/06/09, 10:06 PM

I am sorry if this was already posted, I may have missed it.

In the spreadsheet for equipment section the listed optional enchants for Shoulders and Bracers show the older LW benefits rather than the newer values resulting in a loss of 32 AP.

IggyMac · 09/06/09, 10:56 PM

Bug:
The gem slot orde ron Legplates of Ruination is wrong. It is currently listed as R, Y, B. It's actually Y,R,B. This creates a discrepency when loading from armory because the gems end up in the wrong slot so it doesn't recognize your gem bonus.

Solution;
Check the order on Legplates of Ruination to Y,R,B.