Warrior DPS Calculation Spreadsheet - Page 59

ZeTodu · 08/18/09, 2:59 AM

What about this two:
The World of Warcraft Armory
The World of Warcraft Armory

Flukeworld · 08/18/09, 3:03 AM

I manage my own item loot xls table for fast reference of loots i need, and i was thinking for a fast way to create wowhead links without searching for IDs, so i came up with this:

--In a separate column next to the item name colum:
=IF((ISNUMBER(SEARCH("",D37))),HYPERLINK(CONCATENATE("http://www.wowhead.com/?search=",D37),">>>"),"")

This way i deal with the problem is it heroic item, as it just will show both items in search result and you can mouseover check them.

Hope it helps (would be great to have something like that integrated in Lookup worksheet)

aggressions · 08/18/09, 4:30 AM

Is there any guide how to use this? I have Excel 2007 but getting errors from when trying to catch my armory...errors from some items aswell (it downloads my armory but not complete, but giving errors). And I have no clue how to add items on my own. :/ Which I guess I need to do?

Bickins · 08/18/09, 5:18 AM

Originally Posted by aggressions

Is there any guide how to use this? I have Excel 2007 but getting errors from when trying to catch my armory...errors from some items aswell (it downloads my armory but not complete, but giving errors). And I have no clue how to add items on my own. :/ Which I guess I need to do?

The error is due to the Module that pulls data from your armory's XML file, as they changed the xPath location.

change:

talentGroups/talentGroup[@active=""1""]

to

//talents/talentGroup[@active=""1""]

I checked with landsoul, he's aware and on top of all this for the next version.

landsoul · 08/18/09, 12:13 PM

Another thing, when pulling items from armory, how to differentiate between a normal and heroic item form armory?

aggressions · 08/18/09, 12:22 PM

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?

aggressions · 08/18/09, 12:26 PM

Originally Posted by Bickins

The error is due to the Module that pulls data from your armory's XML file, as they changed the xPath location.

change:

talentGroups/talentGroup[@active=""1""]

to

//talents/talentGroup[@active=""1""]

I checked with landsoul, he's aware and on top of all this for the next version.

Thanx, that fixed the armory checkup.

pmMike · 08/18/09, 12:31 PM

Originally Posted by landsoul

Another thing, when pulling items from armory, how to differentiate between a normal and heroic item form armory?

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?

BWarner · 08/18/09, 12:32 PM

Originally Posted by landsoul

Another thing, when pulling items from armory, how to differentiate between a normal and heroic item form armory?

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.

Ashnod · 08/18/09, 1:15 PM

Originally Posted by pmMike

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?

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

aggressions · 08/18/09, 1:39 PM

When adding new items, anything I need to think about? I tried to add Edge of Ruin, and when I choosed it in fury-sheet the dps in upper left corner displays #N/A.
What I did was to copy/paste in Lookup...and I'm guessing that's why it's wrong, not all sure thou. :/

NobleHelium · 08/18/09, 2:28 PM

Originally Posted by pmMike

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?

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.

catch22atplay · 08/18/09, 2:29 PM

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.

nogame · 08/18/09, 4:18 PM

Another thing, when pulling items from armory, how to differentiate between a normal and heroic item form armory?

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:

http://www.wowhead.com/?item=47078&xml

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.

BWarner · 08/18/09, 4:34 PM

Originally Posted by nogame

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:

http://www.wowhead.com/?item=47078&xml

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

However, you could do your own check based on a combination of checking for the Heroic attribute, and then comparing that against what item level it is.

This could end up getting very confusing, very quickly.

nogame · 08/18/09, 4:43 PM

However, you could do your own check based on a combination of checking for the Heroic attribute, and then comparing that against what item level it is.

This could end up getting very confusing, very quickly.

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):

<item id="47078">
<name>Justicebringer</name>
<level>258</level>
<quality id="4">Epic</quality>
<class id="2">Weapons</class>
<subclass id="1">Two-Handed Axes</subclass>
<icon displayId="60650">INV_Axe_103</icon>
<inventorySlot id="17">Two-Hand</inventorySlot>
<link>http://www.wowhead.com/?item=47078</link>
</item>

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.

NobleHelium · 08/18/09, 5:39 PM

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.

nogame · 08/18/09, 6:50 PM

Originally Posted by NobleHelium

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 =)

Eliminate2 · 08/18/09, 8:33 PM

Originally Posted by aggressions

Thanx, that fixed the armory checkup.

Where do you edit this option? I can't seem to edit the code for the green box.

landsoul · 08/18/09, 9:26 PM

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

BWarner · 08/18/09, 10:17 PM

Maybe you could create a new sheet, that would hook into the existing Lookup one?

Otherwise, I mean... '97 is now 12 years old. Warcraft is no longer actively supporting Windows2k, and Microsoft itself only provides barebones maintenance for Windows2k/ME and earlier. Maybe it's time to unsupport '97 Excel in favor of '03 and later?

proga · 08/18/09, 11:07 PM

Excel 2003 doesn't support more than 255 (IV) columns also. Only 2007+

landsoul · 08/19/09, 12:41 AM

Half of the downloads are excel '97 because that is what a lot of people have, and is easier to get/torrent etc. If I discontinued '97 support then id lose half the downloads, and if I did that I might as well charge for a key to use the program.

Fedelis · 08/19/09, 2:09 AM

Originally Posted by landsoul

Half of the downloads are excel '97 because that is what a lot of people have, and is easier to get/torrent etc. If I discontinued '97 support then id lose half the downloads, and if I did that I might as well charge for a key to use the program.

IMO people would just go download the new XL if you discontinued the old one. I sure would.

turbare · 08/19/09, 3:09 AM

Well, Excel 2003 is very accessible as well TBH, maybe give it a go, it'll do them good, they should upgrade from 97 anyway