Got the same problem like some other users...

Error:
Could not find
htt://eu.wowarmory.com/character-talents ...

I recognized there are some different thinks from the code...
For example:
http://eu.wowarmory.com/character-ta...&gn=is+extinct

as you can see there is something like &cn and &gn which isnt integrated in the code.

Tried to change that manually but didnt work.

So is there any other way to import from a german realm?

Page: Lookup/Arms
Type: Typo

[Anguish] and [Anguish] are missing.

Vitruvian,

I've recently found a solution to this using 2 mods the first is SatrinaBuffFrame. What I've done is created a seperate frame that only displays the "Slam!" event I've set the counter to show tenths of seconds and the frame is fairly large and is just to the left of my Hud but you could put it anywhere you want .

The second Mod I've used is ScrollingCombatText I've created a custom event also based upon "Slam!" that plays a sound whenever 'Slam!' procs.

So now I have an audio event to tell me its time to Slam but I also have the buff frame to tell me how long I have to hit it. There's other addons that do similar things but since I use these 2 addons anyways I dont see the need to load yet another addon.

I am using PowerAuras.
It is a bit hard to set up. But once you know how it works then you can set it up like you want.

I have currently 5 icons+timers in my screen.
1. Show when the targetted enemy have rend and the time it has left. So I can easily refresh it.
2. Showing when Sudden Death lights up + a timer I have left to use execute
3. Showing when I can use overpower + a timer I have left to use it.

4. Showing IF the enemy has hamstring on him + a timer left.
5. Showing IF the enemy has mortal strike debuff + a timer left.

I use nr 4+5 in ToC for the faction champions where im in charge of hamstringing enemy's and keeping MS up.

bo5r5osh..I changed the line from your previous post but when I try to import from armory i get:
"Run time error -2147012889(80072ee7)

and when I hit debug it shows me the line in Module 11..red line marked as problem. Any ideas on that?

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

Getting the same error like Bigboss_hr.

At least this error makes it unpossible to import your chars data into the sheet.
And in fact its a hard bit of work to search on buffed.de for the english names of Items and Gems and talents.
Actually im working on a german translation will send the german file to Landsoul asap im done with it.

My findings were mainly so Landsoul can fix it in his newer version. Since I am no expert in VB, I can't tell what is the problem, however, here is my newest finding after trying to change that XML path (didn't try it before).

After changing "//talentGroups/.." into "//talents/..", then go to File > Save the spreadsheet. Went back to pull landsoul and Recab's (both US) talent builds and it worked fine. When I try to get any of EU warriors, I get an error says timeout.

Hope this could help land figuring it out.

You are missing the point. First of all, the armory goes up and down, as I did my tests, the armory was up.

Second, it is about "how" the spreadsheet retrieving the data.

Didnt work yesterday for me too...

By the way i got (like maybe many others) an idea to fix that whole armory issue.
But i guess its much work to do for that.
My idea is that you select your zone (EU,RU,US ...) in a ComboBox and which one you choose in another ComboBox it shows all Realms out of that zone.After that the "Fetch armory" button could decide which url it needs to get the data from the armory.So if you choose in the zone: "EU" it knows the url is starting with "eu.wowarmory.com..." and the same with other zones and maybe syntax-differences between all these zones.By the way does it matter if you put in a "SPACE" in the server name or use the "+"? For example if i load my profile on Firefox it shows up eu.wowarmory..../Das+Konsortium instead of "Das Konsortium"...Maybe another fact that should be imported in this syntax things to set up the right URL?!
But i guess its not that easy to load all realms just by clicking a button and then send a request to a server?So i guess each realm in each zone has to be implemented in the code?

When fetching armory, include a space for a server name instead of a plus sign. For example, "Alterac Mountains" works fine. I'm afraid language translations for macros might get a little hairy, unless it's something as simple as a case statement choosing which region your character exists in.

Also, I have identified the cause of why increasing mortal strike damage reduces overall DPS. I double checked with pencil paper that not slamming and waiting for MS at a certain point in the difference between the strikes and lag yields more DPS per section of rotation. I am trying to work on a solution that produces a suitable result in the spreadsheet. I don't have the sheet in front of me right now, but I believe it has to do with the "portion of free space used for slam" being reduced by too much when the check for the last GCD before MS dictates that it cannot be used for slam. If anyone knows what I am talking about and would like to help come up with a solution I'd be willing to hear it.

Also please keep the errors and bugs rolling in, I am fixing them as they are reported. Probably have a fix update uploaded before or during the weekend. I can then start working on the reduced functionality '97 sheet.

Im wondering if anyone else is questioning whether or not expertise is being calculated correctly. The SEP is extremely low compared to the previous sheet, and if this is the case a lot of the rankings are being thrown off in the lookup section, dps calculation, etc.

This is arms sheet btw i dont know about fury. To demonstrate, I have and Exp of 17, 2 pts in weapon mastery. my Exp SEP is .25xx, this is down about .60 or .70 percent from the previous sheet and I just cant see how such a drastic difference can be correct.

Further, I removed all gear I was wearing with Exp, so that I had 0 from gear, and removed the 2 pts from weapon mastery. My SEP at 0 Exp is .38xx

Does anyone else see a drastic drop in SEP value on their arms SEP calculation? Perhaps Landsoul could comment if he has a moment on his next post.

And speaking of Landsoul, I like everyone else am extremely grateful for the effort you put in on this terrific spreadsheet.