Warrior DPS Calculation Spreadsheet - Page 107

o0Tyrus0o · 09/03/09, 11:52 PM

Originally Posted by Shundroth

Page: Fury, Arms
Type: Format
The "Fetch Armory" text is showing up in the 3rd belt socket area, and clicking it causes an Armory lookup.

Its the text associated with the the green box above. Right click the box and format shape, click text properties and zero the margins.

Bigboss_hr · 09/04/09, 3:12 AM

Originally Posted by samot

I found a quick and dirty solution for the #VALUE problem by runnig SEP.

- Open the VBA macro editor by pressing Alt-F11
- go into Module7 (it contains the Sub SEP() as first function)
- search for the comment 'MHSpd and comment out all its lines by adding a ' before it
- search for the comment 'OHSpd and comment out all its lines by adding a ' before it
- Save and run SEP
.
.
.

This helped with SEP. Working just fine now.
But the problem remains on lookup tab. When I press "click to run item comparison" DPS diff column goes berserk and turns into ##### & all calculations on arms/fury tab do the same.

I also noticed that T7.5 gloves have lower dps value than even some BC items.
Weapons have mixed up dps values too.

Btw..how can I change talent points in sheet? I'm kinda lost there.

Merxz · 09/04/09, 4:13 AM

Originally Posted by phantomlink

What changes? Theres nothing on the PTR patchnotes for 3.2.2 regarding ArP changes

Whitetooth has confirmed that the effectiveness of ArP has been reduced on the PTR (be it intended or not), as per this post: http://elitistjerks.com/f31/t29453-c...1/#post1371053.

Mordenthal · 09/04/09, 6:19 AM

Edit: Deleted.

DK10 · 09/04/09, 9:17 AM

Page: Fury
Type: Missing Gear
Aesir's Edge is not available in the offhand lookup, only in the mainhand.

Valdur · 09/04/09, 9:30 AM

Page: Lookup
Error Type: Typo
Trinket [Banner of Victory] has "Use" under Type but it should be "Proc" instead.

-Edit-

Page: Fury, Arms
Error Type: Typo
Gem potion for +20 Strength is listed two times in the drop down list.

Seems like I'm wrong there like pointed out below. Though there is no point in having both of those in there since 3.2, or is there?

-Edit3- Figured it out I guess. For armory import!

RoBoZeO · 09/04/09, 11:09 AM

Originally Posted by Valdur

Page: Lookup
Page: Fury, Arms
Error Type: Typo
Gem potion for +20 Strength is listed two times in the drop down list.

No that is correct. one is the Bold Cardinal Ruby the other is the Bold Stormjewel from fishing.

Rdza · 09/04/09, 12:55 PM

Problems with SEP macro is caused by regional differences. In US dot "." is used to separate numbers, and in Poland or Germany - comma ",". Cells C102 and C104 are formatted like "Text" and dot there is not automatically converted into comma. Therefore if you have problems with masive errors after running SEP macro all you have to do is to change "0.1" into "0,1" in cells mentioned above.

Boozie · 09/04/09, 1:57 PM

Originally Posted by Rdza

Problems with SEP macro is caused by regional differences. In US dot "." is used to separate numbers, and in Poland or Germany - comma ",". Cells C102 and C104 are formatted like "Text" and dot there is not automatically converted into comma. Therefore if you have problems with masive errors after running SEP macro all you have to do is to change "0.1" into "0,1" in cells mentioned above.

Brilliant ! This solved the SEP / #VALUE problem for my dutch Excel. Everything seems to be working now, thanks a lot !

Orehor · 09/04/09, 2:16 PM

Page: Lookup
Error Type: typo

Legplates of the Redeemed Blood Knight are suposed to be Legplates of Redeemed Blood

thanks again for the update Landsoul!

Sunseth · 09/04/09, 4:51 PM

Hey, first time posting here.

When I use the spreadsheet, go to arms-page, type in my charactername (Agena) and server (Aggramar) it comes back with an error:

Could not find
http://eu.wowarmory.com/character-talents.xml?r=Aggramar&n=Agena&lang=en_us

Now, when I go to armory myself, and look my character up, the adress is:

http://eu.wowarmory.com/character-sheet.xml?r=Aggramar&n=Agena

Am I doing something wrong ?

Edit: I can see the adress that the spreadsheet isn't able to find, is actually very usable. However, my problem remains unsolved. Could it be a time-out ?

bchorn · 09/04/09, 6:29 PM

Page: Arms
Error Type: Calculation

When I upgrade my T8.5 Helm to the Triumph badges Helm, the dps calculation jumps by 382! This doesn't seem right since I'm losing my 4pcT8 bonus and only gaining 39 AP, 0.30% crit and 1.14% ArP.

Steps to reproduce error: Download a fresh spreadsheet and import my gear into the Arms tab. Note that dps should be at 6327. Then upgrade helm to "Helm of Thunderous Rampage". DPS is now at 6709.

I think the problem has to do with the 4pT8 bonus calc. When I switch back to the T8.5 helm, and then just manually change U37 (4pT8 bonus toggle) to 0, my dps jumps up 308 dps.

Amazing job Landsoul. The new spreadsheet was definitely worth the wait.

Irafas · 09/04/09, 6:55 PM

First, thanks for the update, your sheet is a great tool for any DPS warrior.

Page: Fury
Error type: Concept

I'm not sure if this is an error, but expertise seems somewhat undervalued for fury (and possibly for arms as well). Getting a SEP value of ~1.1 with the new sheet, while in the old sheet it's ~1.8. The latter is about on par with what I get from my own sloppy napkin math as well. This particular example is with 19 expertise, and I'm getting similar numbers with various other gear setups.

If this is not an error, and Exp was over-valued before, it would mean that fury warriors are (at least theoretically) better off gemming pure ArP at >70% ArP, even without Exp dodge cap.

Mordenthal · 09/04/09, 7:10 PM

I fixed the formatting errors in cells C102 and C104 in the Fury sheet and I tried with MHspd / OHspd commented out and not commented out in the SEP macro. And I'm still getting a #DIV/0 error on most stuff.

The Arms sheet works fine.
I'm importing gear from eu.wowarmory if that makes a difference.

Archex · 09/04/09, 10:06 PM

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?