Hi Everyone, I've created a modified version of Aldriana's Combat 1.3 Spreadsheet that has the ability to import data from the armory. It's very simple, you just type in the character's name and server and click "Import" and it will pull in all the information about that character.

The data that this imports from the armory is:

• Gear
• Gems
• Enchants
• Talents
• Glyphs
• Race

NOTE: There is a warning that appears when you import the data about an "XML Import Error", you can safely ignore this, I for the life of me cannot figure out how to hide that message.

If you find any bugs you're welcome to PM me and I'll address them. There is one known limitation, the order that the gems appear under the gear may not always be correct, this is because Aldriana's SS does not always show the gem slots in the same order as Blizzard, and there really isn't anything I can do to fix this.

Also for the time being I have no plans to add this functionality to the Mutilate Spreadsheet.

You can download it here:

Aldriana's Combat 1.4.2 SpreadSheet with Armory Data Import

The import function only works in Office 2003 Professional and Office 2007. The rest of the spreadsheet will work in all other versions, as well as Open Office, only the import feature will not work.

I hope you enjoy it, I've gotten really tired of trying to theorycraft why other rogues picked certain things in their build and having to spend an hour typing in all their gear into a spreadsheet.

Please PM me if you have a problem, don't flood this thread.

Thanks for that Darkcube that's a nice addition. I've been wanting to compare the spreadsheet outputs to other characters but didn't feel like spending 20 minutes per person doing it, and doublechecking the gems is easy enough

There were 2 small issues when I used it for me.
The first was that it didnt' import the LW leg armor emboss correctly (it added Nerubian Leg Reinforcements as Nerubian Leg Armor, rather than the equivalent Icescale Leg Armor).
The second is it's kind of quirky importing a name with special characters.

For example, I was importing a character with an á in their name, but typing it into excel wouldn't work. When I armoried the guy, though, in the url the character came out as %C3%A1. I then tried using that in the spreadsheet and it worked. It would be convenient if the sheet was clever enough to make this character conversion on it's own.

Thanks again for the addon

Darkcube, this worrks for us-servers only? I have no problem editing the macro my self, but maybe you can add the option for EU / US servers. Great work tho - really save some time.

Hello,

Here is the EU version of the spreadsheet if Darkcube doesn't mind, for the people who don't want to bother editing macros.

http://qne.free.fr/Divers/Combat_1.3...0EUversion.xls

I just PMed Darkcube a drop-down-menu solution for the EU/US Problem.

For those who cant wait:
Combat_1.3.1 Data Import_EU_US_layout.xls

I also added a save-dps-function and a new graphic layout which should make working with the sheet a little easier.

I added a server selection dropdown, as well as support for EU realms. I also fixed the bug with the leg armor importing incorrectly.

The new version is attached to my original post. Let me know if you find anything else, i'll take a look at the problem with the strange characters in player names later today.

EDIT: There's a new version again with the EU servers actually working, send me a PM if you find any of the servers don't work.

HI Darkcube,

I'm getting a Run Time error when I try to Import my character. Would this have anything to do with the fact that i'm using Excel 2007?

This is the string i'm getting when I debug the message (this was the only highlighted portion of the message):

ActiveWorkbook.XmlMaps("TalentMap").Import URL:="http://www.wowarmory.com/character-talents.xml?r=" & Range("ServerNameImport").Text & "&n=" & Ran

Thanks,

Can I have the name of your character, and the server? And this was developed using Excel 07 so that isn't a problem.

Thanks.

Milliardo is the name of my character (on Mal'ganis-US). Perhaps some security settings aren't setup to allow importing from a website perhaps? Thanks,

I'm not having any problem importing that character, make sure that you don't any extra spaces at the end of your character's name or the server name. Also make sure you spelled everything right . Both those can cause that error, if this doesn't solve it let me know.

Also, you're mutilate spec. That will load fine into this spreadsheet but there is no mutilate SS currently so it doesn't really benefit you to import yourself.

I have the same problem.

Character: Ronan
Server: Antonidas EU

I have MS Office XP and the message by Debug:

ActiveWorkbook.XmlMaps("TalentMap").Import URL:="http://eu.wowarmory.com/character-talents.xml?r=" & Range("CharacterServer").Text & "&n=" & Range("CharacterName").Text & "&group=1"

17 dps loss for me on the newest sheet, same spec, evisc only combat. I can't imagine what kind of setup would get the results you're seeing, care to elaborate?

So here's my question:

ArPen hard cap is 1400 rating.
I'm using Grim Toll, so I want to socket for 788 rating (1400-612).

Where does the 5/5 Mace Spec come into play here with my MH mace?
The sheet is telling me that I should not be socketing for 788 ArPen... is this right?
Do the 15% MH mace hits count as 1400*0.15=210 rating? If so, I should be socketing for (1400-612-210) 578 ArPen, correct?

How is the sheet factoring those MH mace hits in the equation?

100% armor penetration - 1400 armor pen rating
85% armor penetration (Mace spec) - 1190 armor pen rating

Yes, you should be socketing for 578 with Mace spec and Grim Toll

Darkcube, thanks very much for the added functionality.

I'm afraid I'm having the same problem as those above. I'm running MS Office Standard Edition 2003.

I've tried my character and a few others from my realm (without awkward characters in their names), even your own details refuse to load.

I think there's some setting or module missing from my machine?

Error message:
Run-time error '-2147024882 (8007000e)':
This method or property is available only in Microsoft Office 2003 Professional.

Debugger highlights:
ActiveWorkbook.XmlMaps("TalentMap").Import URL:="http://eu.wowarmory.com/character-talents.xml?r=" & Range("ServerNameImport").Text & "&n=" & Range("CharacterName").Text & "&group=1"
ActiveWorkbook.XmlMaps("CharacterMap").Import URL:="http://eu.wowarmory.com/character-sheet.xml?r=" & Range("ServerNameImport").Text & "&n=" & Range("CharacterName").Text

I have found out that the XMLMap object that I used to extract data from the armory is only available in Office 2003 and Office 2007. The import feature will not work on versions of office older than that. Sorry but there's just no way around that.

EDIT: I see you're running Office 2003 standard, apparently it requires professional.

Also, if anyone has any more problems with the import not working (And is using Office 03 Pro / 07), please PM me, I don't want to hijack this thread with runtime errors.

To be clear on Aldriana's perspective here: Aldriana has put a great deal of time and effort into making a sheet that runs easily in both Excel and OpenOffice, and thus has absolutely no interest in putting time into developing or maintaining macros which break that compatibility. So while you're welcome to make and share whatever changes you see fit, they will never be incorporated into official releases, and I have a mild preference for not having the thread deluged with macro-updated versions every time I release something new. So if it's just a one-time thing - sure, fine, whatever, I don't care. But if it's going to be a regular thing that is to be maintained through multiple releases of the base sheet, it probably wants to be moved either to the Combat Sheet Companion thread, or, if enough changes are being made, it's own thread entirely.

Aldriana, I understand and agree entirely. I've said from my first post if you find a problem please PM me and don't post it here, I do not want this thread hijacked with macro bugs. The only reason I did not post a seperate thread is because I have no intention of adding any more features, and outside of the compatibility issues (03 and 07 only i've learned) and the lack of EU support I had originally, it "Just works". When Combat 1.4 comes out I'll probably update it with the new gear ids you add but until then, I'm done.

This was something I mostly did for my own benefit of saving time and ability to research other rogues decisions but figured others might appreciate it as well.

Let me make this clear, do not post any errors you have with this sheet in this thread, if it does not work just send me a message and I'll see if I know why.

Did you adjust your glyphs and talent tree on the right hand side of the spreadsheet?
Set the proper spec/glyph for an evis only. See what it recommends for gem upgrades (change if needed) and copy down the estimated dps.
Then set the proper spec/glyph for rupture. See what it recommends for gem upgrades (change if needed) and copy down the estimated dps.
Compare the 2 results and decide how you want to spec/glyph and gem.

Glyph/spec is usually one of the first places of error, such as accidentally having 4 glyphs or having extra talent points when you swapped from one gear set up to another...

But on the other hand, do you have your raid buffs set up correctly? I can see that evisc only spec would be affected by the lack of armor debuffs (sunder/ff) more than a rupture cycle. Just something minor that may be missed.

My first time posting so sorry if this has been addressed. I am using the spread sheet and while everything I have read says not to break the T8 4 piece bonus, when I plug in T9.245 gloves and T9.232 legs I am showing a DPS increase.
I there something I am missing? Possibly needing to have all BiS for not breaking T8 4 piece, or this just a case of my current gear makeup?
It does show going to a low rupture instead of high rupture cycle as well.
The increase is minor at 21 DPS but it's there.
Here is my armory:
The World of Warcraft Armory

Generally you can trust your spread sheet. So if it shows a dps gain by dropping the T8 4 piece bonus, you should do it. But have you tried switching specc and glyphs to run an eviscerate only cycle? In most cases, the point where you decide to breake 4pc T8 is the one where you switch to an evis only cycle as well. A quick look at your armory shows you're quite well prepared for that step. So if you have some direct upgrades like the T9 set items you mentioned, maybe for the other T8 pieces too - pull them into your spread sheet and try an evis only cycle. Change gems if it's recommended and look at your calculated dps and see if you're comfortable with it. And even if the dps gain seems marginal or your sheet shows a small dps loss, it will most likely result in a dps gain for you - what has been discussed several times here - because, especially in ToC fights, the higher burst potential and flexibility of an evis only cycle outweigh the theoretically higher dps of a rupture-based rotation.

This is my first post as well, so if I'm mistaken in any way or messed everything up - I'm sorry. Correct me and I'll try harder next time.