Warrior DPS Calculation Spreadsheet - Page 22

nomopofomo · 04/15/09, 12:38 AM

Originally Posted by gab

just put it in manually, i just read that landsoul wrote that the ArP Rating is still bugged on the live servers, so what does thix exactly mean? should i expect an increase for the total dps gain per ArP Rating?

ArP is NOT as good as it is supposed to be but still better than pre-3.1.

Vosk · 04/15/09, 12:48 AM

Originally Posted by Grive

Attempted to do the armoy update and got a few errors. It's saying it cant find the armory page. Anyone else getting these problems?

Have you tried going to your armory page? Perhaps that is where your problem lies.

landsoul · 04/15/09, 12:53 AM

Armory is undergoing maintenance.

Bonezzsaw · 04/15/09, 1:00 AM

So do we have a BIS list yet if so can you please post

gab · 04/15/09, 1:10 AM

Originally Posted by nomopofomo

ArP is NOT as good as it is supposed to be but still better than pre-3.1.

Yeah i got that but honestly i thought i had to regem for ArP as fury too but the latest version of landsouls sheet tells something different so i think i have to wait till they fix it

Even stacking ArP doesn't change the dps per ArP value significantly >.<

Symphonia · 04/15/09, 2:27 AM

Delete please. Didn't mean to post.

Gurlock · 04/15/09, 4:22 AM

Landsoul, found an error, forgive me if you already know:

Cell H4 on the Arms sheet incorrectly references the Imp Whirlwind talent in cell AL16 and leaves out both Str of Arms (AO19) and Weapon Mastery (AO18).

Oliria · 04/15/09, 4:26 AM

Does the new version of the spreadsheet show correct values of ArP or the current bugged value?

Thank you for updating it

Langie · 04/15/09, 4:27 AM

I think I found another error:

Equipping a Polearm as an Orc gives me the MH Racial Expertise Bonus in both (Fury and Arms) sheets.

Goatsey · 04/15/09, 5:27 AM

Delete please my bad

landsoul · 04/15/09, 5:28 AM

Read the first page much?

Dragaan · 04/15/09, 5:42 AM

I noticed that the strength/expertise gained from the Strength of Arms talent is not showing up (arms tab of sheet). I did not read anything about it on the first page so I figured I'd post here. If it was posted and I just missed it, sorry.

Edit: I guess it is still there as far as the dps total and dodge/parry chance. It's just not changing the unbuffed stats.

rejdakon · 04/15/09, 7:17 AM

I get two errors when opening the sheet, using the Excel 2003 Version (German language Excel):

- I get an error from a circular reference which I can't find.
- I get an error from an external link data source that cannot be updated/refreshed. When I let excel show me the invalid external source, it shows "ArmsDPS1.000Excel07.xlsm".

Fury Sheet is working fine as far as I can judge. Arms sheet does not give me any changes to DpS if I change anything. Also, armory import works for the Fury sheet but not for the Arms one.

TidelWave · 04/15/09, 10:37 AM

Landsoul,

First, thanks for what you do. It is by far the biggest tool I have to make decisions in game. Dontation on the way.

When I did an armory transfer today, I had two errors. 1) It didn't recognize Girdle of Razuvious, yet still put it in slot. However, it put a +16 exp gem in vs a +16 Str. 2) It left my Melancholy Sabatons without an enchant saying it didn't recognize the enchant. I believe your spreadsheet is looking for "+12 Crit + 12 Hit" and on armory it is reversed as "+12 Hit rating and +12 Critical Strike Rating". Still much easier than having to input it all ourselves :o). Thanks again for your work.

callion · 04/15/09, 10:47 AM

Arms talentpoints are missing at some talents, the fury tree shows 5/5 Cruelty, 3/3 AttT and then 2/2 Imp Exec? Arms tier1 show only 2/2 Imp Rend. The total points are like 50-60 something instead of 71.

Erfinda · 04/15/09, 10:51 AM

Originally Posted by callion

Arms talentpoints are missing at some talents, the fury tree shows 5/5 Cruelty, 3/3 AttT and then 2/2 Imp Exec? Arms tier1 show only 2/2 Imp Rend. The total points are like 50-60 something instead of 71.

He, obviously, didn't include the filler, non-DPS talents.

Stink · 04/15/09, 10:58 AM

Any time I recalculate SEP in the 2003 spreadsheet (including a fresh download with the default gear), Haste gets a 0.0000 value. Anyone else seeing this?

<edit> Thanks to Landsoul for pointing out that I did not follow directions and had not set my maximum change value properly.

gab · 04/15/09, 11:17 AM

Well i am getting strange values for my unbuffed stats especially AP is kind of bugged, anyone else notices something like that?! Sheet says 3929 in Zerk Stance but ingame i have about 4230

Latham · 04/15/09, 1:46 PM

Anyone else having no real difference in dps between the two specs? Are you guys getting the same numbers?

5314 dps for Fury
5304 dps for Arms

catch22atplay · 04/15/09, 3:19 PM

I show a 226dps gain with Arms. 301 dps gain if i switch gear. To help find the AP problem i'll list my fury AP stats.

4419 AP Live
4158 AP spreadsheet

catch22atplay · 04/15/09, 5:14 PM

Seems to not be adding up strength correctly for Imp zerk. Examples as follows.

Darkmoon card greatness 90 str

90*1.20=108
108*2=216 AP

In game i get the following
Not equipped = 4171 AP
equipped = 4387 AP
difference = 216 AP

Spreadsheet shows the following

Not equipped = 3946 AP
equipped = 4126 AP
difference = 180 AP

So it only showed a 180AP gain instead of 216. I also noticed changing imp zerker to 0 points has zero effect on AP. But talented i'd think it should show the correct value. It does change DPS though. Interesting. I'm terrible with spreadsheets. Sure Landsoul will figure it out.

Edited as i forgot i re enchanted 1 item. Both in game and spreadhseet now using same exact gear and chants etc.

Machinator · 04/15/09, 6:18 PM

Perhaps I do not understand how ArP is bugged, the sheet still uses ArP/1.25 which would be the fully buffed version would it not?

Geneticc · 04/15/09, 6:57 PM

Originally Posted by Machinator

Perhaps I do not understand how ArP is bugged, the sheet still uses ArP/1.25 which would be the fully buffed version would it not?

i think he meant he put the ARP buff in the new sheet but its not working correctly on the live servers just yet. could be wrong though.

So do we have a BIS list yet if so can you please post

i second that, wouldnt mind seeing it myself. and yea i know theres a few items no one has seen yet, so it could/probably will change

Machinator · 04/15/09, 8:11 PM

Originally Posted by landsoul

-Changed Armor Reduction instances to correctly reflect the changes in sunder armor, ff, and the ArP buff and its bug.

ArP isn't coming out as best stat anymore so I would assume the bug in the sheet somehow, but I have no idea what/how its in the sheet.

Grayson Carlyle · 04/15/09, 9:17 PM

J4 (Armor) on the Arms sheet is improperly adding extra armor from Endless Rage talent.

Old:

=D135*2+(VLOOKUP(C6,Lookup!D2:O245,12,FALSE)+VLOOKUP(C10,Lookup!AI2:AT241,12,FALSE)+VLOOKUP(C12,Lookup!AZ2:BK231,12,FALSE)+VLOOKUP(C14,Lookup!BO2:BZ237,12,FALSE)+VLOOKUP(C16,Lookup!CG2:CR232,12,FALSE)+VLOOKUP(T6,Lookup!CW2:DH240,12,FALSE)+VLOOKUP(T8,Lookup!DN2:DY245,12,FALSE)+VLOOKUP(T10,Lookup!EE2:EP237,12,FALSE)+VLOOKUP(T12,Lookup!EW2:FH240,12,FALSE))*(1+0.02*AR8)

Fixed:

=D135*2+(VLOOKUP(C6,Lookup!D2:O245,12,FALSE)+VLOOKUP(C10,Lookup!AI2:AT241,12,FALSE)+VLOOKUP(C12,Lookup!AZ2:BK231,12,FALSE)+VLOOKUP(C14,Lookup!BO2:BZ237,12,FALSE)+VLOOKUP(C16,Lookup!CG2:CR232,12,FALSE)+VLOOKUP(T6,Lookup!CW2:DH240,12,FALSE)+VLOOKUP(T8,Lookup!DN2:DY245,12,FALSE)+VLOOKUP(T10,Lookup!EE2:EP237,12,FALSE)+VLOOKUP(T12,Lookup!EW2:FH240,12,FALSE))

B3 (AP) on both sheets are adding up the effect of AttT twice, and doing all kinds of wrong things. Should be:

=ROUNDDOWN(B135*(1+0.02*AO19),0)*2+C135+J4/180*AL7

E4 (ArP) has the hacked in armor penetration bonus, should be:

=Q136/AL61/100+(10+0.3*AO16*1)/100

J3 is also too high by a few thousand, though I don't even want to think of tackling that one.