Hunter Spreadsheets -- In development - Page 38

Cranch · 10/23/07, 1:13 PM

The armory load is very cool. It loaded my gems and enchants correctly. Now I'm much more likely to use the latest spreadsheet version.

The Attribute/DPS on the Settings and Results page is also very useful, as now I can drop them directly into my item spreadsheet. I just have to remember to hit the CalcAttributes button!

(removed incorrect bug report)

Cheeky · 10/23/07, 1:40 PM

Originally Posted by Cranch

The armory load is very cool. It loaded my gems and enchants correctly. Now I'm much more likely to use the latest spreadsheet version.

The Attribute/DPS on the Settings and Results page is also very useful, as now I can drop them directly into my item spreadsheet. I just have to remember to hit the CalcAttributes button!

(removed incorrect bug report)

It doesn't load enchants yet. Maybe yours just match mine (which are the default.)

If you switch gear it should automatically recalculate the attribute weights. Only for talents, shots, and loading profiles do you need to manually click it (unless I broke that recently.)

Cranch · 10/23/07, 3:25 PM

Originally Posted by Cheeky

Only for talents, shots, and loading profiles do you need to manually click it (unless I broke that recently.)

You also need to click it when you change buffs or latency.

Tsook · 10/23/07, 3:26 PM

Off the top of my head, other target debuffs that affect hunter dps

Blood Frenzy: +2/4% physical damage (from MS warriors; pretty much 100% uptime)
Improved Faerie Fire: +1/2/3% hit (from balance druids; most significant for pets since the hunter is likely hit capped without it)
Improved Judgment of the Crusader: +1/2/3% crit (from ret paladins)
Judgment of Wisdom: 50% chance on hit of +74 mana (any paladin)
Judgment of Light: 50% chance on melee to heal 90 (since you don't model anything about pet health currently, probably can drop that one)
Misery: +1/2/3/4/5% magic damage (from spriests; pretty much 100% uptime; affects arcane shot, serpent sting, lightning breath, serpent and scorpid poison)
Stormstrike: +20% nature damage (from enh shaman; fairly low uptime; affects serpent sting, lightning breath, serpent and scorpid poison [dots don't consume the effect but do benefit from it if it's up during a tick])

As far as buffs, there's also

Improved Sanctity Aura: +1/2% damage (from ret paladin)
Unleashed Rage: +2/4/6/8/10% melee ap (from Enh shaman; uptime is good but not 100% so I don't know how you'd model that without it being ridiculous)
Improved Divine Spirit: +5/10% of spirit as +dam (from disc priests; used to like this for Scorpid Poison hax, but otherwise is just a minor buff to wind serpent damage)
Totem of Wrath: +3% spell hit and crit (from ele shaman; also a buff to wind serpent damage and FI uptime)
Wrath of Air Totem: +101 spell damage (any shaman; for wind serpents)
Moonkin Aura: +5% spell crit (from balance druids; wind serpent damage and FI uptime)

Heckle · 10/23/07, 3:49 PM

When I chose these I get a #N/A. wondering if this is me or if anyone else is getting it. Boy I love this spreadsheet! Thanks Guys!

orinaccio · 10/23/07, 5: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, 7: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, 7: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, 8: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, 8: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, 8:19 PM

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

Belaq · 10/23/07, 11: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, 2: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, 5: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, 1: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, 1: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, 2:02 PM

incorrect info deleted.

Cheeky · 10/25/07, 3: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, 6: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, 9: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?

Trohck · 10/25/07, 10:19 PM

While the listed damage for shots doesn't indicate what the effect of armor mitigation is, the armor mitigation is definitely applied to the shots when considering total DPS.

Cheeky · 10/26/07, 9:59 AM

Originally Posted by Glaurong

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

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

      <enchant>+6 All Stats</enchant>

The problem is that this only gets me the text description of the enchant, not it's name (which in this case would be "Exceptional Stats". I was able to get this far, it's just doing the work of mapping the description to the name that is stymieing me right now. I can already data-mine the gems easily enough (that part should be working currently).

Osse · 10/26/07, 10:17 AM

I was checking the lightning breath calculations and my eye caught the lack of Misery - Spells - World of Warcraft in the calculations. Is this calculated without notification or have you just forgot to add it? Stormstrike - Spells - World of Warcraft uptime is probably hard to calculate as it depents on raid setup so much. Suppose I can just think that it gives a tiny boost of dps in fight. :-)

Cheeky · 10/26/07, 11:40 AM

Change Log:
- Fixed lookups for Leg stats
- Actually allow the user to select a different target.
- Bestial Wrath is only counted if you actually have the talent.
- More spelling corrections to match Armory names. Keep the feedback on this coming.
- Added new gear ([Shadowmaster's Boots], [Adamantite Stinger], [Infused Shadow Draenite], [Balanced Shadow Draenite], [Wicked Flame Spessarite])
- Added Curse of Recklessness to Target Debuffs.
- Fixed some errors in Ammo drop-down values mapping properly.
- Correct some items ([Vengeful Gladiator's Waraxe], [Serpent Spine Longbow], [Foreman's Reinforced Helmet])
- Reapplied checks for Meta gems.
- Meta Gems for Gladiator Gear and Engineering Helms will now appear in the correct socket locations. You may need to correct this if you load an old saved file with them. (The check to do this honestly wasn't worth the effort.)
- Fixed Resilience socket bonuses for Wrist items.
- Fixed the mix-up in hit/Crit socket bonuses for Helms.
- Added in Resilience socket bonuses for Shoulder items.
- All gear is cleared out before loading from the Armory.
- Fixed gems in Moriquendi's Helm.
- On the 'Talents' tab is a button allowing you to read your talent spec in from the Armory. Character name and Realm are settable on the 'Settings and Results' tab.
- Added support for European Servers. Select server set from the 'Settings and Results' tab.
- Validate the character and realm combination exists for the server set, a warning message is issued if you provide an invalid character.

Bugs fixed from bug-tracking post:

Sep 27: Calculations!D32 has a typo - Ranged WeaponWeapon DPS
Sep 30: Dragonstalker armor (set) - not being counted correctly.
Oct 09: [Serpent Spine Longbow] - listed with 16/7 stamina, not counted in stamina/HP totals.
Oct 18: [Gronnstalker's Helmet] - currently listed with +4 Hit Rating, should be +4 Crit Rating
Oct 18: Armor penetration on custom items not working correctly.
Oct 18: [Merciless Gladiator's Chain Helm] - set bonus not listed correctly.
Oct 18: [Foreman's Reinforced Helmet] - missing 30 Agility, 6 AP
Oct 18: [Infused Shadow Draenite] - missing.
Oct 18: [Balanced Shadow Draenite] - missing.
Oct 18: [Wicked Flame Spessarite] - missing.
Oct 19: [Beast Lord Helm] - incorrect socket bonus.
Oct 21: [Forest Prowler's Helm] - incorrect socket bonus.
Oct 22: [Merciless Gladiator's Chain Spaulders] - incorrect socket bonus.
Oct 22: [Veteran's Chain Bracers] - incorrect socket bonus.
Oct 23: Curse of Recklessness - missing.
Oct 23: [Gronnstalker's Leggings] - not counting towards set bonus.
Oct 23: [Shadowmaster's Boots] - missing.
Oct 23: Armory import sometimes inverts imported gems.
Oct 23: [Warden's Arrow] - display as #N/A in DPS field.
Oct 23: [Vengeful Gladiator's Waraxe] - stats incorrect.
Oct 23: [Sky-Hunter Swift Boots] - currently spelled incorrectly ("Sky Hunter Swift Boots").
Oct 23: [Rift Stalker Leggings] - not counting towards set bonus.
Oct 23: [Adamantite Stinger] - missing.
Oct 25: [Beast-tamer's Shoulders] - currently spelled incorrectly ("Beast tamer's Shoulders").

Osse · 10/26/07, 11:53 AM

Armory import makes things so much faster, gj.

Only thing worth mentioning is that the import doesnt copy ring enchants, otherwise no 'bugs' so far.