Hunter Spreadsheets -- In development - Page 40

Indora · 10/31/07, 8:33 PM

will kill command be integrated into shot rotations ?

I just wanted to say the same thing. ^^

1. KC delays the autoshot.
2. KC isn't used as often as calculated, because you can't use it while you cast steady and you shouldn't use it while your autoshot is casting.

I think the best methode to calculate the time-to-use-kc is to add it to the shot rotation with the former calculated time as cooldown.

Berkut · 11/02/07, 12:05 PM

This is probably a stupid question but...

I cannot get any of the buttons to work.

Faile · 11/02/07, 1:16 PM

In version 36 the critical hit damage from 'Relentless Earthstorm Diamond' isn't applied correctly. It seems like the formula in 'Calculations!E46' isn't correct. I think you should refer to 'Gear!B22' and 'Gear!AJ22' instead of 'Gear!B23' and 'Gear!AJ23'.

Cranch · 11/02/07, 2:10 PM

In version 35, the Abacus of Violent Odds isn't getting any benefit from its on-use ability. For now, you can just add a custom 22 haste to compensate for it.

Fendryl · 11/02/07, 3:25 PM

[Talon of Al'ar] is listed as "Talon of Alar" in the spreadsheet & doesn't armory import correctly.

Similiar to above, and I believe on the known issues list ("Meta gems not always being counted correctly (engineering and gladiator gear).") - My Relentless Earthstorm doesn't update the Critical Hit Damage calculation correctly, as it's checking to the wrong cell (I have a merciless Gladiator Helm)

Cranch · 11/02/07, 3:32 PM

Shallow-grave Trousers are missing the 30 haste rating.

Load Profile doesn't load the Hand Adjust fields (not haste for sure.)

Edarran · 11/02/07, 5:39 PM

Having some verification Issues with this version.. whenever I attempt to input data an error message comes up saying that it is protected. When I attempted to remove this it prompted for a password

Heathun · 11/02/07, 11:37 PM

This spreadsheet is a huge help. To all those that had a hand in creating it, thank you. Really good job fellas, and then to share it here for anyone to use is very much appreciated, it makes the whole process of choosing and comparing so much more tolerable for me at least. The load from armory feature is just an added luxory.
I was wandering which ones [Shifting Camouflage Pants] or [Shallow-grave Trousers] would be more of a benefit to a BM hunter with my gear and attack speed, and I can plainly see the latter is the best. If it wasn't for this spreadsheet that could have been a much more difficult task. Keep up the good work, and keep on a checking that math!

P.S. One quick silly question, how do I link an item so I can just scroll over it here and see the stats ect.? Thanks in advance.

Edit: Fixed the links.

• Keltan · 11/03/07, 12:25 AM

Originally Posted by Heathun

P.S. One quick silly question, how do I link an item so I can just scroll over it here and see the stats ect.? Thanks in advance.

[ item ]Sunfury Bow of the Phoenix[ /item ] tags
[Sunfury Bow of the Phoenix] (minus the spaces)

Cheeky · 11/04/07, 3:18 PM

Ok, I'm able to easily get race from Armory now, but enchants are still a pain in the ass.

I can get the flavor text for each one, and I can translate that back into the enchant name, but I need help tracking them all down. Please PM me with any you have on your gear. Here are some examples:

Slot-Enchant-Text:
Head-Glyph of Ferocity-+34 Attack Power and +16 Hit Rating
Shoulder-Greater Inscription of Vengeance-+30 Attack Power and +10 Critical Strike Rating

Once I get enough of these I can add the mapping in and scrape them too.

Orphis · 11/05/07, 11:38 AM

There's a bug involving locales while fetching data from the armory. Since my computer (or maybe Excel's fault) is french, it tries to load french values from the armory, and then, nothing can really be loaded. There's a simple fix for that :

Function getsingledata(url, searchterm)
    Set objXMLHTTP = CreateObject("MSXML2.ServerXMLHTTP.3.0")
    url = url & "&locale=en_us"

Cheeky · 11/05/07, 12:58 PM

Originally Posted by Orphis

There's a bug involving locales while fetching data from the armory. Since my computer (or maybe Excel's fault) is french, it tries to load french values from the armory, and then, nothing can really be loaded. There's a simple fix for that :

Function getsingledata(url, searchterm)
    Set objXMLHTTP = CreateObject("MSXML2.ServerXMLHTTP.3.0")
    url = url & "&locale=en_us"

Thank you for this. I'll have it in the next version!

Amiyuy · 11/05/07, 5:43 PM

In version 36 on the Gear page all of the intellect enchants to weapons are displaying under the Stamina column instead of Intellect.

Jemsky · 11/06/07, 9:29 AM

For some reason, there is no option for choosing resilience gems like the Mystic Dawnstone and Steady Talasite however there is an option for Mystic Lionseye

Is this intended?

Enova · 11/06/07, 9:36 AM

I would suppose resilience effects are not taken into account for dps calculations (as the spreadsheet assumes you're kept healthy and do not move/take damage/overaggro etc). Hence there's no point in adding resilience gems in the first place.

Orphis · 11/06/07, 12:10 PM

Wrong! It is important to have all the gems because of the import from armory feature and of metagems so you don't have to fill the holes after importing with non useful gems (so you don't alter the dps calculations, let's say you would add spell damage)

Rifeus · 11/06/07, 12:37 PM

Hallo.

Firstly, awesome spreadsheet. Thanks alot!

[BUG]

However, as far as i'm aware there is no implented hit cap?

If i put all my yellow gem slots to none, and then add a +hit gem one by one, they all increase my total dps. However my hit rating hits 158, which is over the cap.. right?

Cheeky · 11/06/07, 12:37 PM

Originally Posted by Orphis

Wrong! It is important to have all the gems because of the import from armory feature and of metagems so you don't have to fill the holes after importing with non useful gems (so you don't alter the dps calculations, let's say you would add spell damage)

Relax, I can add the 2 you requested, it was merely an oversight. I am human you know.

Just send me a pm with all gems you'd like, and please include itemtags (like [Steady Talasite]) to save me some time.

Cheeky · 11/06/07, 12:39 PM

Originally Posted by Rifeus

Hallo.

Firstly, awesome spreadsheet. Thanks alot!

[BUG]

However, as far as i'm aware there is no implented hit cap?

If i put all my yellow gem slots to none, and then add a +hit gem one by one, they all increase my total dps. However my hit rating hits 158, which is over the cap.. right?

That's odd. Does you hit% ever go over 100%? I know at one point I had logic to prevent that. Is there a chance that the last one satisifed a meta-gem requirement?

Rifeus · 11/06/07, 12:49 PM

Originally Posted by Cheeky

That's odd. Does you hit% ever go over 100%? I know at one point I had logic to prevent that. Is there a chance that the last one satisifed a meta-gem requirement?

Gee. Obviously.

The problem was somewhat what you said. I didnt gain the item socket bonus when changing the gem from +8 hit to none. Sorry about the wrong bug report. ^^

Evanwill · 11/06/07, 5:21 PM

Crit is off by .6%

I'm not sure why. I've looked over everything from talents to gems to gear. I even compared the crit rating and all of the stats of my armory profile and the spreadsheet. They all match up. Same agi, sta, etc 108 crit rating on both.

Spreadsheet says 19.56%.
Armory says 20.16%.

Here's my armory profile - The World of Warcraft Armory

Thanks for this awesome tool. I have recently switched over to playing a hunter from playing a shadow priest and I will say that min/maxing on a hunter is so much more complex, which really makes it a lot more fun for me. Your spreadsheet has really shown me some things to think about when gearing my hunter. Thanks for all you're work on this.

Cheeky · 11/06/07, 5:26 PM

Originally Posted by Evanwill

Crit is off by .6%

I'm not sure why. I've looked over everything from talents to gems to gear. I even compared the crit rating and all of the stats of my armory profile and the spreadsheet. They all match up. Same agi, sta, etc 108 crit rating on both.

Spreadsheet says 19.56%.
Armory says 20.16%.

Here's my armory profile - The World of Warcraft Armory

Thanks for this awesome tool. I have recently switched over to playing a hunter from playing a shadow priest and I will say that min/maxing on a hunter is so much more complex, which really makes it a lot more fun for me. Your spreadsheet has really shown me some things to think about when gearing my hunter. Thanks for all you're work on this.

Try adjusting target level (on the 'Settings and Results' tab) to level 70. There is a 0.6% decrease to crit for a target 15 defense higher than your weapon skill.

(By the way, does anyone know if that is still accurate? My testing is showing it may be closer to 0.1% per point of difference, but sample size is small.)

Evanwill · 11/06/07, 5:42 PM

That was it. Thanks!

Korikin · 11/06/07, 6:18 PM

Few bugs.

Minor Aesthetic thingy. Setting and results tab, haste break down 1:1.27272727272727 returned to the shot rotation column when a 1:1.3 is being used.

Also, can verify that the + int enchants show in the stam column. And Major Int shows only a value of 9. Guessing it's the same problem though.

Great work by the way. And the armory scanning function made this a TON more flexible for helping to compare yourself to other guild hunters without the trouble of transcribing form armory. Appreciate the hard work!

Mystafet · 11/07/07, 10:38 AM

Hey Cheeky,
I'm trying to get my profile to update from the Armory, yet everytime I thi the Load Gear from Armory button, I'm getting an error that says:
Run-time Error: '-2147012899 (80072ee7)':
The server name or address could not be resolved.

The World of Warcraft Armory
is my armory profile.

Please let me know what I'm doing wrong
Thanks,
-Mystafet