Warrior DPS Calculation Spreadsheet - Page 104

Grayson Carlyle · 09/02/09, 9:32 AM

-edit- I was mistaken; I had a few wrong gems making the Planestalker ArP not as effective. Leaving the previous post behind.

---- BAD INFO ----
For Fury BiS: Should see a small upgrade by going with [Band of Callous Aggression] over Planestalker, then putting 20 hit on gloves instead of 44 AP.

Oliria · 09/02/09, 9:45 AM

Like some of the others I get #VALUE when trying to update SEP values or compare gear. One very strange thing I noticed while trying to figure out what Tier9 piece to get first was that if I switch to Tier9 gloves (and thereby loosing 4pT8 bonus, without getting 2pT9) I gained over 500 DPS. I couldn't understand this so I tried manually disabling 4pT8 without changing gear and I gained 450 DPS by doing this.

So there's definatly something wrong with 4pT8 bonus, you shouldn't gain 450 DPS by dropping 10% crit on Mortal Strike. All of this is in the arms section.

The new sheet looks really great though, and I'm looking forward to seeing it work. Thank you for you dedication Landsoul.

Aimaar · 09/02/09, 10:10 AM

i didn't get european armory working and also when trying to calculata new sep values spreadsheet is bugging Berserking enchant on weapons and greatness trinket

RoBoZeO · 09/02/09, 10:18 AM

Bug when pulling up the armory. Last night i got the heroic belt of the impaler. When i do a lookup on my guy it comes up as normal belt and i have to change it to heroic version.

Great work though. this is by far the best spreadsheet out there for any class. Thanks

Flukeworld · 09/02/09, 10:26 AM

Originally Posted by Aimaar

i didn't get european armory working and also when trying to calculata new sep values spreadsheet is bugging Berserking enchant on weapons and greatness trinket

I get EU armory just fine, check later (as it gets down occasionaly) or you are behind firewall/proxy.
As for the second, most of the people get errors there (anyone manage to get them work?)

Anduryondon · 09/02/09, 10:44 AM

It seems kinda odd to me, that with BiS ToC Gear i get 10 DPS more with Glyph of Bladestorm instead of Glyph of MS, any suggestions?

Evilsurd · 09/02/09, 11:37 AM

Having major issues retrieving character details.

2 different machines, both Win7. One with Office 2007, One with Office 2010

When I click the Fetch Armoury link, I get a Visual Basic Runtime error.

The debugger comes up at the following point.

------------------------------------------------------------------------------------------
Function GetSingleDataXLS(url, searchterm)
Set objXMLHTTP = CreateObject("MSXML2.ServerXMLHTTP.3.0")
objXMLHTTP.Open "GET", url, False
objXMLHTTP.SetRequestHeader "User-Agent", "Mozilla/5.0 (Windows; U; Windows NT 5.0; en-GB; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4"
objXMLHTTP.SetRequestHeader "Content-Type", "text/xml"
objXMLHTTP.SetRequestHeader "Accept-Language", "en"
objXMLHTTP.Send "."
Set xmlPG = objXMLHTTP.responseXML 'Get the XML in xmlPg
------------------------------------------------------------------------------------------

objXMLHTTP.Send "." is what gets highlighted.

Any ideas?

Lifthrasil · 09/02/09, 12:54 PM

Originally Posted by Aimaar

i didn't get european armory working

make sure, that you take eu.wowarmory.com not www.eu.wowarmory.com. The european version has no www at the beginning like the US one. Had some troubles with that too.

Scyne · 09/02/09, 1:34 PM

Originally Posted by Evilsurd

Having major issues retrieving character details.

2 different machines, both Win7. One with Office 2007, One with Office 2010

When I click the Fetch Armoury link, I get a Visual Basic Runtime error.

The debugger comes up at the following point.

------------------------------------------------------------------------------------------
Function GetSingleDataXLS(url, searchterm)
Set objXMLHTTP = CreateObject("MSXML2.ServerXMLHTTP.3.0")
objXMLHTTP.Open "GET", url, False
objXMLHTTP.SetRequestHeader "User-Agent", "Mozilla/5.0 (Windows; U; Windows NT 5.0; en-GB; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4"
objXMLHTTP.SetRequestHeader "Content-Type", "text/xml"
objXMLHTTP.SetRequestHeader "Accept-Language", "en"
objXMLHTTP.Send "."
Set xmlPG = objXMLHTTP.responseXML 'Get the XML in xmlPg
------------------------------------------------------------------------------------------

objXMLHTTP.Send "." is what gets highlighted.

Any ideas?

Sounds strange, i'm using Windows 7 as well with both Office 2007 and 2010 and i do not have any trouble importing Armory data. Do you have some sort of personal firewall installed on the computers?

Chumble · 09/02/09, 1:54 PM

Does the spreadsheet no longer take into account racial ExP gains?

I have mace mainhand (28 ExP), and Sword offhand (23 ExP). The SS shows only 23, and rates ExP SEP accordingly (i.e. probably too high).

Apologies if I'm just missing where to set this on the sheet.

Valisen · 09/02/09, 2:25 PM

I am getting an "Excel found unreadable content" error when trying to open the file with Excel 07. Then it asks if I want to recover the contents of this workbook. If I hit "yes" it opens the spreadsheet but no macros work. I am a complete noob at Excel any help or ideas would be great.

EDIT: Trip to windows update fixed my problem >.<

Evilsurd · 09/02/09, 2:27 PM

Originally Posted by Scyne

Sounds strange, i'm using Windows 7 as well with both Office 2007 and 2010 and i do not have any trouble importing Armory data. Do you have some sort of personal firewall installed on the computers?

Standard Windows firewall, Forefront Client security, even added Excel as an exclusion

earle117 · 09/02/09, 2:28 PM

Sorry to add into the large amount of questions here, but I have a quick question regarding SEP values. When I run my current SEP, most of the stats make sense, except that it rates EXP extremely low (lower even than Haste), while I'm still 51 points below the EXP cap. Right now, it's telling me that ArP is the best stat to gem, which makes sense, since I have quite a bit already (no GT/MR though).

Now that your spreadsheet deals with dodges and OP, does that mean that EXP really isn't worth much anymore?

And by the way, I really like your new sheet, it's much nicer to navigate and the faction themed color change is pretty cool.

Moozhe · 09/02/09, 2:48 PM

I'm noticing the same thing as earle117. I'm below the Expertise cap but the SEP is only 0.24.

rljohn · 09/02/09, 2:59 PM

Nitro boots still show up as +16 Crit instead of +24. Also when I import my toon from the wowarmory it has 2 errors, the first being that it can't recognize my +24 crit enchant, the second being it can't recognize my bracers. However, my bracers ARE in the dropdown list. Armplates of the Netherlord.

Other than that, grate work. Awesome changes =D