Hunter Spreadsheets -- In development - Page 63

orinaccio · 10/23/07, 4:01 PM

Cheeky - Thanks for your hard work. As hunter class officer of my guild, Ive been putting your spreadsheet to good use, which has been instrumental in maximizing our hunter crew's DPS capabilities. The improvement that I've seen since using your spreadsheet is nothing short of remarkable.

I'd like to know if anyone has been successful with using this spreadsheet on the Mac OS X version of MS Office. I find that the spreadsheets work in every respect except for the buttons which appear to be inoperable.

I can certainly continue to manually input gear, and shots in the shot rotation table, but being able to use the buttons to automate some of this would definitely be nice.

Lactose · 10/23/07, 6:48 PM

Bug report updated with all items / bugs I saw since the last update.
Remember to check this post before submitting bugs (either via this thread or PMed to me), so we avoid duplicate reports.

Thanks =)

Genaa · 10/23/07, 6:52 PM

Hi Folks,

I am a first time poster but a fairly long time reader of the Elitist Jerks forums. This and other threads have been highly instrumental in helping me improve my gear and shot selection immensely, so first of all can I just say a big thank-you to the community for being so great!

Now for a quick question. Can anyone tell me how to get the armory load feature of the latest version (35) of Cheeky's spreadsheet working?

I see the tab for load armory profile but cannot see how I input my particular realm and toon info. I have tried changing the name and realm information on the settings page but to no avail.

Personally I am happy enough using manual inserts of gear, particularly as drops are often few and far between, but would nonetheless be keen to try it out in the hope it might make persuading other guild hunters to use the spreadsheets more that bit easier.

Many thanks

_dodger_ · 10/23/07, 7:00 PM

@Genaa: If I understood Cheeky correct you can only import characters from US realms as of now and you seem to be an an EU server so I think you'll have to wait for a new version.

Cheeky: Thank you for your hard work on this spreadsheet - helped me immensely in becoming a better hunter.

Cheeky · 10/23/07, 7:16 PM

Originally Posted by _dodger_

@Genaa: If I understood Cheeky correct you can only import characters from US realms as of now and you seem to be an an EU server so I think you'll have to wait for a new version.

_dodger_ is correct. I have yet to verify the EU Armory URLs. I'm hoping to do this soon. I'll just randomly test people I see who have posted to this thread.

Genaa · 10/23/07, 7:19 PM

Thanks for the speedy reply folks - and for also helping me realise I was not being completely thick!

Belaq · 10/23/07, 10:59 PM

Originally Posted by orinaccio

I'd like to know if anyone has been successful with using this spreadsheet on the Mac OS X version of MS Office. I find that the spreadsheets work in every respect except for the buttons which appear to be inoperable.

Unfortunately I have not been able to get it to work - and I have had quite a few Mac- and MS Office-savvy people working on the issue. No one can seem to tell me what's wrong.

Alurym · 10/24/07, 1:35 AM

Same here. When I open the .xls Excel informs me of an error occurring thus I can't make use of it. ;[

Navras · 10/24/07, 4:57 PM

Originally Posted by Belaq

Unfortunately I have not been able to get it to work - and I have had quite a few Mac- and MS Office-savvy people working on the issue. No one can seem to tell me what's wrong.

I believe it is an issue with the way Macros are created or run in Mac Excel vs Windows Excel? I seem to recall some discussion related to that.

Trohck · 10/25/07, 12:21 PM

The Armory functionality worked well for me and saved a lot of time, what a great feature! Not only that but it can be used to compare to other hunters. Very nice. Enchants will be a nice addition if you can do that.

The only gear bug I ran into was [Beast-tamer's Shoulders]. In the spreadsheet it's spelled "Beast Tamer's Shoulders", in armory it is "Beast-tamer's Shoulders". So the spreadsheet is using a space and not the dash, and throws an error when trying to load these.

Shandara · 10/25/07, 12:36 PM

Originally Posted by Cheeky

_dodger_ is correct. I have yet to verify the EU Armory URLs. I'm hoping to do this soon. I'll just randomly test people I see who have posted to this thread.

And here I was wondering why the button did nothing

Cranch · 10/25/07, 1:02 PM

incorrect info deleted.

Cheeky · 10/25/07, 2:37 PM

Originally Posted by Trohck

The Armory functionality worked well for me and saved a lot of time, what a great feature! Not only that but it can be used to compare to other hunters. Very nice. Enchants will be a nice addition if you can do that.

The only gear bug I ran into was [Beast-tamer's Shoulders]. In the spreadsheet it's spelled "Beast Tamer's Shoulders", in armory it is "Beast-tamer's Shoulders". So the spreadsheet is using a space and not the dash, and throws an error when trying to load these.

I'll have more spelling mistakes fixed shortly.

I'm at a dead-end in regards to scraping enchants. I can get an ID for an enchant, and I can get the text discription of the effect, but I cannot get the enchant name. I really, really don't want to translate the effect description back into the name, that would be a real pain in the ass. (I'm also running into similar problem with reputation-based rings.)

My current thinking is that I'm just going to set all enchants to "None" on a Armory scrape and let the user punch them in. Not ideal, but I'm out of good ideas. If anyone can figure out a way to take the ID back into a enchant name I'd be grateful.

Talents are easy, I should have that ready shortly. As well as verifying the EU URLs. (I imagine I only need to worry about the base character sheet. The item descriptions should work fine from the US servers. Slower performance for EU users, but much easier for me.)

Glaurong · 10/25/07, 5:32 PM

After a bit of reverse engineering all you need is the following:

http://www.wowarmory.com/item-tooltip.xml?i=<item id>&r=<realm>&n=<character name>

That will return you the information the armory uses for the tooltip.

This query: http://www.wowarmory.com/item-toolti...r=Hyjal&n=Glau

Returns the following:

<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="/layout/item-tooltip.xsl"?>

<page globalSearch="1" lang="en_us" requestUrl="/item-tooltip.xml">
  <itemTooltips>
    <itemTooltip>
      <id>30892</id>
      <name>Beast-tamer's Shoulders</name>
      <icon>inv_shoulder_59</icon>

      <overallQualityId>4</overallQualityId>
      <bonding>1</bonding>
      <classId>4</classId>
      <equipData>
        <inventoryType>3</inventoryType>
        <subclassName>Mail</subclassName>

      </equipData>
      <damageData/>
      <bonusAgility>39</bonusAgility>
      <bonusStamina>38</bonusStamina>
      <armor armorBonus="0">741</armor>
      <enchant>+26 Attack Power</enchant>
      <durability current="85" max="85"/>

      <requiredLevel>70</requiredLevel>
      <spellData>
        <spell>
          <trigger>1</trigger>
          <desc>Increases attack power by 78.</desc>
        </spell>
        <spell>

          <trigger>1</trigger>
          <desc>Increases damage dealt by your pet by 3%.</desc>
        </spell>
        <spell>
          <trigger>1</trigger>
          <desc>Increases your pet's critical strike chance by 2%.</desc>
        </spell>

      </spellData>
      <itemSource areaId="3606" areaName="Hyjal Summit" creatureId="17888" creatureName="Kaz'rogal" difficulty="n" dropRate="3" value="sourceType.creatureDrop"/>
    </itemTooltip>
  </itemTooltips>
</page>

Enjoy =)

Edit: Sorry, I should have included an example with socket data too:

http://www.wowarmory.com/item-toolti...r=Hyjal&n=Glau

Returns:

<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="/layout/item-tooltip.xsl"?>

<page globalSearch="1" lang="en_us" requestUrl="/item-tooltip.xml">
  <itemTooltips>
    <itemTooltip>
      <id>29515</id>
      <name>Ebon Netherscale Breastplate</name>
      <icon>inv_chest_plate08</icon>

      <overallQualityId>4</overallQualityId>
      <bonding>1</bonding>
      <classId>4</classId>
      <equipData>
        <inventoryType>5</inventoryType>
        <subclassName>Mail</subclassName>

      </equipData>
      <damageData/>
      <bonusStamina>25</bonusStamina>
      <bonusIntellect>23</bonusIntellect>
      <armor armorBonus="0">846</armor>
      <enchant>+6 All Stats</enchant>
      <socketData>

        <socket color="Blue" enchant="+4 Agility and +6 Stamina" icon="inv_jewelcrafting_nightseye_03" match="1"/>
        <socket color="Yellow" enchant="+8 Critical Strike Rating" icon="inv_jewelcrafting_dawnstone_03" match="1"/>
        <socket color="Blue" enchant="+4 Agility and +6 Stamina" icon="inv_jewelcrafting_nightseye_03" match="1"/>
        <socketMatchEnchant>+4 Agility</socketMatchEnchant>
      </socketData>
      <durability current="140" max="140"/>
      <requiredLevel>70</requiredLevel>
      <requiredAbility>Dragonscale Leatherworking</requiredAbility>

      <bonusCritRating>31</bonusCritRating>
      <spellData>
        <spell>
          <trigger>1</trigger>
          <desc>Increases attack power by 80.</desc>
        </spell>
        <spell>

          <trigger>1</trigger>
          <desc>Restores 8 mana per 5 sec.</desc>
        </spell>
      </spellData>
      <setData>
        <name>Netherscale Armor</name>
        <item equipped="1" name="Ebon Netherscale Belt"/>

        <item name="Ebon Netherscale Bracers"/>
        <item equipped="1" name="Ebon Netherscale Breastplate"/>
        <setBonus desc="Increases your hit rating by 20." threshold="3"/>
      </setData>
      <itemSource value="sourceType.createdBySpell"/>
    </itemTooltip>
  </itemTooltips>
</page>

liquidf · 10/25/07, 8:59 PM

question on the calculated DPS values. I notice that changing the bosses affects the damage done by Kill Command but not the damage done by any of the hunter's shots.

I've been wondering for a while about the actual calculated numbers - eg average steady shot damage for me is calculated as 721, while I think it hits in practice for more like 400 than 700. I figure the spreadsheet calculates paper doll dps, but if it now includes mob armor can it then determine the actual dps on the mob selected rather than a theoretical?