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?

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?

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.

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?

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.

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 >.<

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.

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

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

Are we talking about the arms sheet or the fury sheet? I tried the fury sheet last night and it looked to be about right.

I think it was less than 4 when I looked. When I tried to fetch your gear just now it was popping up prot gear so I can't double check. Mainly in the SeP chart get the "from ArP" number as close to 0 as possible, the same goes for expertise after that the usual stregth stacking applies. If either of those numbers goes negative by more than 10 you can probably gain more DpS by switching to a Strength Gem or if its a yellow socket even a crit gem if it'll get you a noteworthy bonus(ArP,Str,Crit). The main thing is play with the sheet before changing your gems to see what goes up and doesn't.

In the talent trees. Should one be able to change the talent points there or are they static and set for the best build? If one for example would like to switch from poleaxe to sword specc. Right now i can't seem to interact with them.

As it is now, you'll have to move the pictures to select the talents. Had some headache with that aswell.

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.

Good job on the sheet. I especially like seeing all the calculations and rotation clean and expanded and that the rotation doesn't have static times for swings.

Minor issues:
-Rating Cap for Exp showed I was 0 from cap with 213 rating, but the hit table was showing .004% dodge still.
-You might want to specify the ArP cap changes with trinkets.
-Nitro Boosts do not work from armory import and are 24 crit, sheet has 16.
-The arp trinkets have low value on the lookup sheet, probably just due to how arp is calculated.

Questions:
-It looks like execute is on the sheet but not completed/working yet, correct?
-Could you explain the rage slip calculations please?

Got the same problem, updated windows but still can't get it to work :<
I found this on google though, maybe it can help landsoul fix this issue (I don't know anything about excel)

I like the changes to the Spreadsheet overall, there were a few text alignment issues and font size issues that were easily corrected. No other issues found that haven't already been mentioned.

Is there anyone who would care to explain to me how the weapon DPS -> SEP conversion is handled? I just can't deduce the formula from that mess of excel.

Page: Lookup
Type: Typo
Legguards/leggings of Lurking Threat (non-heroic): Has a red gem-slot instead of yellow.


(thanks for all your work!)

Arms. The only reason I can see would only apply to Arms anyways, as I believe the sheet now allows OP procs off of dodges, which only applies to Arms spec. That's the only reason I can see that EXP would not be worth any significant value (outside of something just plain wrong, that is.)

I'm also experiencing some issues here, when i try to open spreadsheet i got this message for unreadable content and ask me if i want to recover. I say yes and everything seems to be fine, all Landsoul's gear and values look correct. I also import fine from EU armory, but the minute my gear is loaded into the sheet, i got those #VALUE errors about everywhere. Any tips?

If you're just looking for a quick fix for that, you can right click on the text, select Assign Macro, enter

into the box (or if you've changed the name of the file, you specify the new filename)

Then right click the text to select it, and you can left click and drag it into the correct place on top of it's button.

:EDIT: Sorry for the double post, the forums timed out and I didn't realize the first one went through.