Warrior DPS Calculation Spreadsheet - Page 117

BWarner · 09/19/09, 1:20 AM

Originally Posted by Cortic

Quick query re: ArP Nerf in 3.2.2

I read a few pages back that to get the ArP value changed in anticipation of the ArP nerf we had to manually change the ArP coefficient in cell E86 from 1.25 to 1.1

Is this still true?

Uh... look in the cell on whatever sheet you have, and see if it has /1.1 or /1.25?

Cortic · 09/19/09, 2:40 AM

Originally Posted by BWarner

Uh... look in the cell on whatever sheet you have, and see if it has /1.1 or /1.25?

Yeah it has 1.25 as default I just wanted to know if by changing it to 1.1 it was still the correct way to get 3.2.2 ArP changes?

losreyes · 09/19/09, 11:34 AM

Originally Posted by taureion

First: I use german excel.
Well, i put comma instead of dots into the fury sheet and formatted cells C102 and C104 manually, but i still get all the #div/0 in the sheet...
Is there anything i do wrong? How can i fix the fury sheet?

As a spanish user im still having the same issue aswell, in arms and fury sheets. Is there any way to help you to know whats causing the error? i guess you cant fix it if your spreadsheet works.

Goatsey · 09/19/09, 1:24 PM

Originally Posted by Cortic

Yeah it has 1.25 as default I just wanted to know if by changing it to 1.1 it was still the correct way to get 3.2.2 ArP changes?

Yes, it remains the same to see the armor pen changes in 3.2.2, basically the "/1.25" was to reflect the changes in patch 3.1 to make armor pen 25% more efficient. Now, with the nerf, they said they were effectively buffing it from the original value by 10%, so the "/1.25" becomes "/1.1" to make it 10% more efficient than the original figure.

thiouke · 09/19/09, 6:54 PM

I recently have a chance to buy the Relentless Gladiator's GreatSword for my fury MH. But when I played around in the spreadsheet it said that the Edge of Agony (drops of 10 man twins) is better. Is this right? I thought the dps on the relentless would trump the lack of stats vs the Edge of Agony

Kalroth · 09/19/09, 10:04 PM

To the people with localization issues: make sure it's a fresh copy you're modifying. Once the spreadsheet gets a #DIV error, it breaks in a lot of different places. So download it again (and this time save the original copy) and go enter 0,1 in the fields C102 and C104 before you enter or change anything else. It works fine for me in both versions.

Originally Posted by thiouke

I recently have a chance to buy the Relentless Gladiator's GreatSword for my fury MH. But when I played around in the spreadsheet it said that the Edge of Agony (drops of 10 man twins) is better. Is this right? I thought the dps on the relentless would trump the lack of stats vs the Edge of Agony

[Edge of Agony] got 183 attack power, 112 agility (~2.40% unbuffed crit), 86 arpen rating (6.98%), 62 haste rating (1.89%) and 1 socket, while [Relentless Gladiator's Greatsword] got 271 attack power, 90 crit rating (1.96% crit) and 23 more DPS. Put a strength gem in the socket (44 attack power) and it sums up to 0.44% crit, 6.98% ArPen and 1.89% haste versus 44 attack power and 23 more DPS.

Ran Newman · 09/21/09, 6:11 AM

Is it possible to have Rend vs MS table? I found out that planty of times MS finish cooldown while rend have <0.5 duration left - at which point i don't know if i should MS, or wait and refresh rend. normaly i just use MS, but the lower the time left on rend the harder the choice is, and i am preaty sure its possible to nail the breakdown point using the spreadsheet.

taureion · 09/21/09, 12:06 PM

Originally Posted by Kalroth

To the people with localization issues: make sure it's a fresh copy you're modifying. Once the spreadsheet gets a #DIV error, it breaks in a lot of different places. So download it again (and this time save the original copy) and go enter 0,1 in the fields C102 and C104 before you enter or change anything else. It works fine for me in both versions.

I tried it three times and it didn't work. Sad =(

So i'm looking forward to the next version or maybe the excel '03 version works for me.

Thorhammar · 09/22/09, 8:35 AM

I'm still having issues with the spreadsheet when trying to calculate SEP values, wow armory import works, the formulas are modified according to the intro sheet of the spreadsheet, excel was fresh installed, etc, all the criteria needed for the spreadsheet to work was fulfilled but still I'm getting the #VALOR! error when calculating SEP.

Everything else works just fine, only that is failing, any ideas about how to solve it?
Also I'm from Argentina (South America), but I don't think it would be a localization issue since I'm not getting the /DIV! error just the #VALOR! :S

Any help would be really appreciated!

Thanks a lot to all!

Gregor · 09/22/09, 2:27 PM

Hey all,

Sorry but I need some help troubleshooting the new spreadsheet. I've been a huge fan of this tool for months now, but I just installed Excel 07 and the new program won't run very well for me.

Error message - When I try to get my profile from Armory, I get the following message: Microsoft Visual Basic Run-time Error 91. Object Variable or With Block Variable not set.

DPS Metric- is stuck to Landsoul's numbers, even after manually inputting all my gear/gems.

I think this program is invaluable, and I'd like to keep using it so any help at all would really be appreciated.

thanks very much!

Dragonspear · 09/22/09, 4:42 PM

I was trying today to find some place in the arms spreadsheet to update the Swordspec proc chance to compensate for the new change and I could not manage to find it. If someone would be kind enough to point me in the right direction so I can double check some things, it would be much appreciated.

Fedelis · 09/22/09, 5:29 PM

Originally Posted by Dragonspear

I was trying today to find some place in the arms spreadsheet to update the Swordspec proc chance to compensate for the new change and I could not manage to find it. If someone would be kind enough to point me in the right direction so I can double check some things, it would be much appreciated.

There's a few cells that need modifying. Hit CTRL+F and search for

"Sword",0.01*AO15

every time you find it change the 0.01 to 0.02

Also search for

AO15/100

and change it to AO15/50

brewskay · 09/22/09, 6:43 PM

Was wondering if there was a way to change the armor penetration rating on the spreadsheet to make it possible to check with the new ArP nerf.

Rauch · 09/22/09, 6:56 PM

Adjusting for the new ARP conversion rate was addressed a few weeks ago here in this thread:

Warrior DPS Calculation Spreadsheet

hungrymoo · 09/22/09, 7:59 PM

Ok I checked the link u posted but there isn't a real answer, so let's solve this problem once for all:

ArP Nerf is live, on the first page of this Thread we have a BiS List provided by Landsoul (ty m8 u are gr8

,
The question is:

We have better result using ArP gems or STR gems with the items provided in that list?

Plz give a separete answer for fury and for arms spec (to avoid any possbile trubble).

Tnx to all