Hunter Spreadsheets -- In development - Page 3

Auxilium · 02/11/07, 8:02 AM

On a side note, I found that Excel spreadsheets that contain any TRUE/FALSE like formulas will load in the user's language, which would've changed it to WAHR/FALSCH for the German user and WAAR/ONWAAR for me and any other Dutch users :)

Lozzleskotch · 02/11/07, 3:56 PM

I'm debating whether to switch from Scryers to Aldor just for the shoulder enchant (20 AP 15 crit for scryer, 30 AP 10 crit for aldor). On your spreadsheet the Scryer one is only better at very high levels of RAP and low levels of crit. I don't think I'll ever be running 5k AP and 15% crit, so the Aldor one would be a better choice.

Lactose, how accurate do you think your spreadsheet is right now? I'd hate to switch over and then find out there's an error and the Scryer one is better.

Edit: one other thing, could the extra crit coupled with GFTT tip the scales in favor of the Scryer enchant? I think I'll take this up in the main hunter thread.

Sienna · 02/11/07, 9:47 PM

The one problem with improved aspect of the hawk is that the simulator values are only true if you are not delaying your autoshots. In raiding, you can go on for a while with delaying all your autoshots due to multi/arcane/steady. My bow speed is 2.43 after quiver but I highly doubt I'm shooting 123 autoshots in a 5 minute boss fight. Probably a lot less. Not to mention the majority of that proc can go wasted due to movements in boss fights. I have 5/5 IAOTH but I'm thinking to replace it with the last 2 points in unleashed fury and 1 in ferocity. The pet is doing a handful of damage now.

Lactose · 02/12/07, 5:28 AM

Originally Posted by Lozzleskotch

Lactose, how accurate do you think your spreadsheet is right now? I'd hate to switch over and then find out there's an error and the Scryer one is better.

Disregarding a couple of minor bugs that I've corrected locally (Focused Fire not being applied, corrected average damage for Multi-Shot and Arcane Shot), and the stuff I obviously haven't added yet (lots of talents, pet stuff, etc), it should be pretty darn accurate, to be honest.
My main problem is finding a way to put numbers on shots; how many you use and how long it takes (DPS issues...). Basically, if you input stuff and you're able to reproduce that "rotation" ingame, it should be accurate.
Keep in mind I haven't documented it all yet though, so you might be missing something I'm not seeing ;)

At the moment I feel like I'm at a minor road block with those shots. No ETA on new update.

Breakerone · 02/12/07, 7:01 AM

Originally Posted by Cheeky

Version 4 of my spreadsheet is available for download.

List of changes:
- Using Glau's equation for Improved Aspect of the Hawk uptime.
- Fixed trinkets/racials in shot rotation.
- Included Karazhan gear, what I could locate stats for.
- Added in 0.5 second cast time for auto shot (removing it from auto shot cooldown.)
- Added The Beast Within.

As always comments, criticisms, and ideas are always welcome.

I think its a very nice sheet wit a lot of work in it. I have one little suggestion. You even went through the trouble to enter the colors of slots of the items with their respective socket bonus. As far as I'm concerned I find it hard to see a use in socketing the sockets with something else then red gems, maybe a yellow one here and there. But using blue ones, which appear a lot makes me loose more dps then the socket bonus can compensate, if the bonus gives dps at all.
So it would be great if you left the option to use all kinds of gems for any slot.

You also might want to add the shoulder and head enchants from the various rep rewards.

Also stats for other races besides trolls and NE's would be great ;)

Cheeky · 02/12/07, 7:10 PM

Originally Posted by Breakerone

I think its a very nice sheet wit a lot of work in it. I have one little suggestion. You even went through the trouble to enter the colors of slots of the items with their respective socket bonus. As far as I'm concerned I find it hard to see a use in socketing the sockets with something else then red gems, maybe a yellow one here and there. But using blue ones, which appear a lot makes me loose more dps then the socket bonus can compensate, if the bonus gives dps at all.
So it would be great if you left the option to use all kinds of gems for any slot.

Yeah, I really should do that. I'll try and have it in the next version. It actually makes my job easier if I don't separate out the colors.

Originally Posted by Breakerone

You also might want to add the shoulder and head enchants from the various rep rewards.

I have already started doing that. I have the Aldor/Scryer in my version. I just need to find all the other ones available. Please let me know if you know of any of the others you would like to see.

Originally Posted by Breakerone

Also stats for other races besides trolls and NE's would be great ;)

Since I only play a Troll, I can only get stats for that. Please provide your race/stats and I will gladly add them. I could bug my guildmates enough to get level 70 stats for Tauran and Orc, but I don't know any Alliance.

In general, if gear/echants/stats are missing it is because I do not know about them. Anyone can provide that information and I will update it. Also, if anyone sees any mistakes (especially in calculations) please let me know about them so I can correct them as soon as possible.

Djinn · 02/14/07, 1:31 AM

Lactose - when i change your +hit tab to anything over 6%. DPS/damage doesn't change, bug or? and when i put the +hit to 6% and add 20+hit rating to the new item tab and the current item tab +hit rating is 0 the current dps/damage is still higher, little confused, isnt our hit cap 9 and the damage should go up?

Lactose · 02/14/07, 2:45 AM

Originally Posted by Djinn

Lactose - when i change your +hit tab to anything over 6%. DPS/damage doesn't change, bug or?

Adjustments based on Mob Level / Weapon Skill aren't implemented yet.

and when i put the +hit to 6% and add 20+hit rating to the new item tab and the current item tab +hit rating is 0 the current dps/damage is still higher

Sounds strange. I'll note it down and check later.

Djinn · 02/14/07, 3:05 AM

I can send screenshot also if u dont get same result

pf · 02/14/07, 10:55 AM

Originally Posted by Cheeky

Since I only play a Troll, I can only get stats for that. Please provide your race/stats and I will gladly add them. I could bug my guildmates enough to get level 70 stats for Tauran and Orc, but I don't know any Alliance.

You can derive base lvl 70 stats for all races based on the information you have.
Each race gets exactly the same stats as they level up, so just figure out how much you gained from lvl 1 and use that number and add it to the base value which is listed on this page to determine the lvl 70 stats of other races.

http://www.worldofwarcraft.com/info/classes/hunter/

Lodi · 02/14/07, 4:32 PM

This seems like a good place to ask:

What is the cap on "chance to hit % vs lvl 70" listed on char sheet (or hit rating with 350 weapon skill, equivalently) for:

lvl 70

lvl 71

lvl 72

?

I've seen people report numbers for (non dual-wield) melee, but I recall ranged attacks being a percent or so higher.

Keltan · 02/14/07, 4:45 PM

1% Hit = 15.8 Hit Rate @ Level 70.

For a level 70 opponent you would need +5% hit to eliminate misses, or 79 Hit Rate.
For a level 71 opponent you would need +6.2% hit to eliminate misses, or 98 Hit Rate.
For a level 72 opponent you would need +7.4% hit to eliminate misses, or 117 Hit Rate.
For a level 73 opponent you would need +8.6% hit to eliminate misses, or 136 Hit Rate.

For the weapon skill stuff:
1 weapon skill = 3.9 weapon skill rate = 0.24% hit

1 weapon skill rate = 0.256 weapon skill = 0.0615% hit per point of weapon skill rate

Breakerone · 02/15/07, 7:03 AM

Originally Posted by Keltan

1% Hit = 15.8 Hit Rate @ Level 70.

For a level 70 opponent you would need +5% hit to eliminate misses, or 79 Hit Rate.
For a level 71 opponent you would need +6.2% hit to eliminate misses, or 98 Hit Rate.
For a level 72 opponent you would need +7.4% hit to eliminate misses, or 117 Hit Rate.
For a level 73 opponent you would need +8.6% hit to eliminate misses, or 136 Hit Rate.

For the weapon skill stuff:
1 weapon skill = 3.9 weapon skill rate = 0.24% hit

1 weapon skill rate = 0.256 weapon skill = 0.0615% hit per point of weapon skill rate

Actually I was always curious about that. As far as I understand there is always 1% miss rate left, no matter what you do. Having that in mind, does it make sense to try to get the last % at all?

Lactose · 02/15/07, 7:09 AM

Originally Posted by Breakerone

Actually I was always curious about that. As far as I understand there is always 1% miss rate left, no matter what you do. Having that in mind, does it make sense to try to get the last % at all?

You can have way below 1% miss rate, measured over tens of thousands of shots. If there is a constant miss rate for us that can't be prevented, it's something like 0.1% or so, not worth thinking about.

Breakerone · 02/15/07, 7:43 AM

Good to know, thanks. Dont know where I got that from...