Warrior DPS Calculation Spreadsheet - Page 153

landsoul · 12/28/09, 9:31 PM

The reason is I removed truncation. The game groups certain stats together based on their source, whether it's from your character, buffs, or gear, and then scales them seperately with buffs (kings, trueshot, etc.) and removes the decimal at the end. I removed this from the spreadsheet because it was interfering with SEP calculation. In short, at certain points it would say STR = 1.000 and 2 AP = 1.000 which throws everything off.

Harpo · 12/28/09, 10:26 PM

Hm, I imported myself in the correct gear, and I am at 28/23 on my in-game tooltip. I put in a +20 expertise gem in a random non-gem slot (such as on my chest, there is no third gem slot, but I put a +20 exp gem inside) and I did not recieve any dps increase. I am using Excel 03, and I will try again, either way it is not a big deal since I am going to be at 26/26 in a few minutes.

Also, I am kind of worried about the Deathbringer's Will. I am currently at about 83% armor penetration without a food buff. I am messing around with Executioner/Berserking in my offhand. Whenever I input Berserking on my offhand, I see the SEP console adjust the cap based around the Executioner proc. Yet, if Deathbringer's Will procs, I am going to be way, way over the armor penetration cap. I was originally gemming in a less-strict Runestone type of gemming which would allow the 33% chance of getting the ArP proc to push me to cap. Basically, I am very nervous about being at 85% armor penetration while using Deathbringer's Will and still seeing ArP as my most valuable stat.

galvin · 12/29/09, 2:23 AM

Page: FURY
Error Type: CALCULATION
Version: WarriorDPS2.600cExcel07. Using excel 2007.

I think I found the cause of the division by zero errors for the fury sheet. If you download the arms into fury by mistake it
breaks the sheet. After this happened I download fury and all the values were filled in, but the division by zero errors didn't
go away. Maybe make the dowloader check to see if you're downloading the right spec for the correct sheet.

Pier · 12/29/09, 5:42 AM

Page: FURY
Error Type: REFERENCE
[Malevolent Girdle] is displayed as having one blue socket and one yellow socket in the spreadsheet when in fact it has one blue socket and one red socket. Doesn't appear to be a purely visual error as socketing the second gem slot with +20 strength does not result in an active socket bonus.

Galthra · 12/29/09, 7:02 AM

Page: LOOKUP
Error Type: TYPO

Horde: Non-Heroic Dual-Blade Butcher has 155 Stamina, not 137.

Jambo354 · 12/29/09, 7:18 AM

Page: Lookup
Error type: Typo
[Darkmaw Crossbow] should have 35 Agility, not 43

Berenonehand · 12/29/09, 9:48 AM

Page: ARMS
Error Type: REFERENCE

For some reason, importing char from the Armory never recognizes talent points spent on Incite.

Krazen · 12/29/09, 10:09 AM

Page: LOOKUP
Error Type: TYPO

Polar Bear Arm Guards are Plate, not Mail.

I am interested as to how people are dealing with this new crit conversion, though.

Basically any warrior wearing a lot of leather/agil items looks to be over the crit cap.

As it seems, the value of +hit has skyrocketed from about .4 SEP to .76 SEP while crit has declined from .98 SEP to .65 SEP. This makes sense if any excess +hit is 'unlocking' your extra crit.

The conclusion seems to be to shift to strength based items.

Ragnernon · 12/29/09, 10:40 AM

PAGE: Fury and Arms

Error typ: Concept and Formula (?)

Expose Armor stacks with Sunder, ingame it doesnt. Dk if already mentioned!

But thx for the great work landsoul... the new sheet is amazing.

rljohn · 12/29/09, 11:34 AM

Page: LOOKUP
Error Type: TYPO

[Ramaladni's Blade of Culling] shows up as main hand, but not as offhand.

Roshi · 12/29/09, 1:02 PM

Page: Lookup
Error type: Typo
Bryntroll still has wrong stats in Main and Offhand (correct ones are 169 STR, 161 STA)

Page: Lookup
Error type: Typo
Ring of Violent Temperment(heroic) still has wrong stats in 1st and 2nd ringslot (correct one is 97 STA)

everything else seems to be correct now (even gnome stats - yeehaw ^^)

Originally Posted by landsoul

The reason is I removed truncation. The game groups certain stats together based on their source, whether it's from your character, buffs, or gear, and then scales them seperately with buffs (kings, trueshot, etc.) and removes the decimal at the end. I removed this from the spreadsheet because it was interfering with SEP calculation. In short, at certain points it would say STR = 1.000 and 2 AP = 1.000 which throws everything off.

i havent looked over the sheets code, but isnt it strange that this truncation delta always seem to result in +2AP (with different gearsetups and even without gear)?

brandorf · 12/29/09, 1:08 PM

Just to clarify, does the item comparison macro on the lookup page not take set bonuses in to consideration? I'm trying to figure out how to best break my T9 4 piece, and if I run the comparison against my shoulders, the lookup shows a ~20 dps increase should I switch to the T10 shoulders, but the main fury page shows a loss of ~40 should I actually switch them.

Jakoemanou · 12/29/09, 1:43 PM

Page: ARMS
Error Type: Talents

In Arms you cant set DW 5/5 to 0/0

dunno is its calculated or not

Appel · 12/29/09, 2:00 PM

Originally Posted by brandorf

Just to clarify, does the item comparison macro on the lookup page not take set bonuses in to consideration? I'm trying to figure out how to best break my T9 4 piece, and if I run the comparison against my shoulders, the lookup shows a ~20 dps increase should I switch to the T10 shoulders, but the main fury page shows a loss of ~40 should I actually switch them.

The item comparison macro does not take set bonuses into account. But this information is given by Landsoul on the info page of the sheet.

Relcan · 12/29/09, 3:15 PM

Page: LOOKUP
Error Type: TYPO

"Handgrips of the Frost and Sleet" (Mail, Gloves) give a +6 Hit Rating Bonus, not +6 Agility

Noticed I was short 6 Hit Rating and got concerned....I scrubbed each piece and eventually found it. Thanks for getting the sheet out it, I'm not a fan of using RAWR.