WotLK DPS spreadsheet - Page 42

Kisai · 11/23/08, 3:09 PM

ehm, when I load my gear from the armory, the spreadsheet tells me that there are some things that are yet to be added, these are:

Kel'Thuzad's Reach (the main fist weapon from naxx-10)
Incewalker enchant on boots
Hyperspeed Accelerators for gloves (the eng enchant that's like a trinket)
+40 crit rating scope on ranged weapon.

thanks for all the hard work shandara, i love how cheeky's work is being upgraded and improved by You

Shandara · 11/23/08, 3:11 PM

Originally Posted by flimflam

Getting an error with the latest version 78 when trying to load gear from the armory.

Then highlights this line:

sName = Node.Attributes.getNamedItem("name").Text

sUrl variable is: The World of Warcraft Armory

The Armory is borked again. If you try that URL it's blank so the script fails to find anything.

EDIT:
Kel'Thuzads Reach is in there, just missing a capital T in the name so it fails the name matching. Select it manually. I'll fix it in the next version.

flimflam · 11/23/08, 3:14 PM

Originally Posted by Shandara

The Armory is borked again. If you try that URL it's blank so the script fails to find anything.

It causes the rest of the script to fail which stops loading the rest of my gear. i went and added a On Error Goto X and now it will load the rest which is way better than having to load everything by hand

Thelastdeadmouse · 11/23/08, 7:34 PM

Found a few bugs.

The following items should be added to the speadsheet:
Belt of Tasseled Lanterns
Giantmaim Bracers
Giantmaim Leggings
Signet of Bridenbrad
Ring of Foul Mojo
Plunder's Helmet
Mirror of Truth
Edit: Grips of Chronological Events

Drake-Mounted Crossbow will not load from Armory (listed as Drake Mounted Crossbow)
Terrorshaft Arrow will not load from Armory (listed as Terrorshaft Arrows in spreadsheet)

When giving a ring in the custom gear page a socket, the only gem that comes up on the drop down menu in the gear page is Destructive Skyflare Diamond.

Keep up the great work.

Edit: Also on the custom gear page there is no slot for haste rating as a socket bonus, which the Signet of Bridenbrad has.

Thelastdeadmouse · 11/24/08, 3:09 AM

Also add Twin-Headed Boots and The Prospector's Prize.

Shandara · 11/24/08, 5:27 AM

Originally Posted by Kisai

ehm, when I load my gear from the armory, the spreadsheet tells me that there are some things that are yet to be added, these are:

Kel'Thuzad's Reach (the main fist weapon from naxx-10)
Incewalker enchant on boots
Hyperspeed Accelerators for gloves (the eng enchant that's like a trinket)
+40 crit rating scope on ranged weapon.

thanks for all the hard work shandara, i love how cheeky's work is being upgraded and improved by You

Both Icewalker and the Heartseeker scope are in the sheet, but most likely the tooltip it uses to scrape it from the Armory has been changed. Armory is still not working for me, so can you tell me the text on the item tooltip for the enchant?

And the new engineering enchant tooltip texts for completions' sake.

Creosote · 11/24/08, 10:46 AM

First off, thanks for all the hard work on this spreadsheet. It's great stuff.

I stumbled on maxdps.com recently.

They seem to have very different, and I think incorrect, ratings for certain stats. They seem to value haste fairly high based on where some of the gear lands in my list. I know for BM, haste is still a dps increase, but we already are "capped" with just quiver and SS on steady shot so it doesn't scale well for us. Anyone else check out that maxdps site?

THe main reason I'm bringing up that site is the list of gear there seems to be a lot more comprehensive. While I certainly trust the spreadsheet more for calculations and rankings, there is quite a bit of gear missing from the spreadsheet. Thought you might find maxdps a good reference site for hunter gear to add to the spreadsheet moving forward.

Just as an example. In the spreadsheet, my blue Headguard of the Westrift shows only the engineering goggles as an upgrade in gear planner.

On maxdps, all of the following are showing as upgrades, most of which I don't see in the spreadsheet at all:

Eviscerator's Facemask - LW crafted
Crusader's Coif - quest Icecrown
Headguard of Vast Destruction - quest Pinnacle
Helment of the Shrine - heroic Gun
Shroud of Darkness - Heroic VH
Hood of the Furtive Asassin - HoL (here is that haste gear I mentioned)
Helm of Cheated fate - Heroic Gun (more haste)
Plunderer's Helmet - Heroic UK

Har · 11/24/08, 10:52 AM

Here's a low priority bug for you: I found after entering all my quest greens into the gear sheet and loading everything I could from the armory, my agility is being incorrectly reported in the spreadsheet.

I have a level 74 Draenei with 131 agility from gear (please don't mock me- I dinged 70 the week before the expansion shipped), and according to the armory, 160 base agility when the spreadsheet is recording 148. I can't see the table that is being used to calculate the Draenei racial agility, so unfortunately that's as detailed as this report's going to get...

Thanks for all your hard work! This spreadsheet is awesome. Easy to use, and well thought out.

Shandara · 11/24/08, 11:23 AM

Originally Posted by Har

Here's a low priority bug for you: I found after entering all my quest greens into the gear sheet and loading everything I could from the armory, my agility is being incorrectly reported in the spreadsheet.

I have a level 74 Draenei with 131 agility from gear (please don't mock me- I dinged 70 the week before the expansion shipped), and according to the armory, 160 base agility when the spreadsheet is recording 148. I can't see the table that is being used to calculate the Draenei racial agility, so unfortunately that's as detailed as this report's going to get...

Thanks for all your hard work! This spreadsheet is awesome. Easy to use, and well thought out.

This is probably because I don't have all the stats for all races. I only have a nightelf hunter myself so only those stats are correct.

Ebonleaf · 11/24/08, 11:30 AM

Giant Ring Belt

Broken Stalactite

Also Valorous Cryptstalkers Handguard's doesn't even place on the gear planner, even though they are far above the others.

Thanks again Shand, great work.

dandy · 11/24/08, 11:37 AM

I have found an issue: ther'isnt enchant on ring Enchant Ring - Assault

Fantastic work!! I love u Shand!

Dch48 · 11/24/08, 12:08 PM

The only way I could get it to work was by editing Shandara's profile to my gear set and saving it under my name. Creating a new profile did not work no matter what I did. Importing from armory imported the gear but would not give me any damage stats at all. Just putting my gear into a new profile manually did the same thing--no stats.

Question, are the figures for dps from scorpid poison correct? They seem ridiculously high.

Shandara · 11/24/08, 12:15 PM

Originally Posted by Dch48

The only way I could get it to work was by editing Shandara's profile to my gear set and saving it under my name. Creating a new profile did not work no matter what I did. Importing from armory imported the gear but would not give me any damage stats at all. Just putting my gear into a new profile manually did the same thing--no stats.

Question, are the figures for dps from scorpid poison correct? They seem ridiculously high.

I'm not sure what's going wrong for you. Are macroes enabled? Is the security level right? Can you upload your version of the sheet somewhere for me to look at?

Dch48 · 11/24/08, 12:33 PM

Well it's working now with what I did. I'll let you know if I have a problem creating another profile. I'm using Excel from the Office XP pack with SP3. It's the 2002 version it says. Version number 10.6847.6845

My question about the scorpid poison though. I was looking at all the pets to see which were best for dps. My cat still was the best until I got to the scorpid. When I plugged their poison ability in, it said it did 395 dps at lvl 80 which made the total dps for the scorpid 120 more than for a cat. That just doesn't seem right.

Ebonleaf · 11/24/08, 12:44 PM

Shand:

On the gear planner item and gear item Tree Shaper's hauberk: It's actually called Hauberk of the Arcane Wraith

Thanks