Should I get this error while loading the sheetmap? "Excel found unreadable content in "WarriorDPS2.406bExcel07.xlsm". Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes."

Is it because my macros are disabled by default that I get this message?

I was under the impression the armory used the same item IDs as wowhead, as they are in game. Therefore surely they will be different?

What you probably CAN do, without drop info, is compare against an item level check.

If you're talking about simply the issue of pulling the item, then it would have to be based on item IDs, most likely.

<<< Another person in the camp of "what a stupid way to do loot", in regards to the T9 setup.

Yeah, this is the case, see
The World of Warcraft Armory
vs
The World of Warcraft Armory

Right now the sheet's Armory lookup identifies the items by name only; the functions would have to be changed to retrieve by ID most likely.

For me i hit the "Click to sort" button on the lookup page. This will more often than not cause an #NA for an item i added improperly. So once you hit click to sort check the item you added and see if it's ok. If it is it should be fine for use on the fury or arms page. Also ensure you have the weapon listed in both mainhand and offhand places. If an item has a gem slot this can cause problems. I usually copy from another cell that has an equal value ie 1 red gem i copy the cell that calculates the gem SEP and paste as special. Not sure if that's the correct way to do it. But it generally works for me. For the particular weapon you entered you may have copy pasted the whole line but didn't remove the gem SEP which should be blank in this particular case as there is no gem to calculate. So check your end as it's something you did wrong.

I'm really not sure about Excel's capability of handling external data but... and you probably already arrived on this, you could do a quick call to the armory, get the item id and then do a quick call to wowhead with the item's ID to get some XML with the item level on it. An example url for such purposes can be found below:

Once you have the XML use the "level" property to find out if its heroic.

That's not yet full proof-either because you won't be able to distinguish between 10 man hard mode and normal 25 mans until Wowhead adds the "heroic" property into their XML feed (which wow armory may never do, if it's anything like their armor pen stat).

I would think it would be easier to get wowhead to implement something in it's XML feed then waiting for the wow armory to implement it.

I think that's the point though, there is no heroic attribute in either the armory or wowhead xml (unless i am misinterpreting what you meant).

This is what we have to work with from the armory:

and wowhead gives us (took out json and tooltip):

The annoying thing about it is doing the wowhead method requires a call to wowhead for each item while looking at the armory only requires a single lookup. This overhead would all be done (I'm assuming) to give the player a little more information regarding the boss that drops said item.

I don't think there's a need to wait for either Wowhead or Armory to add a heroic attribute to their XML feeds. Why not just add an extra column for every item in the spreadsheet for each item's ID? Then simply retrieve all the item IDs from Armory and compare with the spreadsheet's stored IDs.

touche =)

There's not enough columns to add an extra column to each slot. -( Otherwise I would do it. If you go beyond column IV excel 1997 ignores them