Hunter Spreadsheets -- In development - Page 23

Pesmerga · 06/25/07, 10:44 AM

Originally Posted by Elithuzad

Void Reaver Greaves, isnt showing the correct vaules in the spreadsheet. Other then that this is as have been said before, a very helpful addition to the Hunter Community.

Item in question: Void Reaver Greaves

Keep it up

I just checked the spreadsheet (Version 20) and it has the correct values listed for the Void Reaver Greaves:

787 Armor, 37 Agility, 33 Stamina, 24 Intellect, 88 AP, R, Y, B Sockets, and a +4 Agility socket bonus.

Grondarg · 06/25/07, 7:18 PM

I was recently trying to develop my own spreadsheet on mana usage with a shot rotation with my current spec. While talking with a fellow guildie hunter he mentioned your site and I came here. After seeing this thread I downloaded Cheeky's spreadsheet to check it out. I like it a lot.

I do have a question and a bug report.

First the bug report. When I apply abacus of violent odds in my shot rotation it breaks the damage totals from that point on in the rotation.

If i set up a normal priority rotation with just Multi and Steady it lists my total dps as 1609.93dps. If i set up the same rotation but use Multi and Arcane it lists my total dps as 1558.94. Obviously the difference in mitigation types (arcane resist/armor) would change these numbers. Will you be adding the ability to factor in the differences in damage mitigation any time soon?

Cheeky · 06/25/07, 8:40 PM

Originally Posted by Grondarg

I was recently trying to develop my own spreadsheet on mana usage with a shot rotation with my current spec. While talking with a fellow guildie hunter he mentioned your site and I came here. After seeing this thread I downloaded Cheeky's spreadsheet to check it out. I like it a lot.

I do have a question and a bug report.

First the bug report. When I apply abacus of violent odds in my shot rotation it breaks the damage totals from that point on in the rotation.

If i set up a normal priority rotation with just Multi and Steady it lists my total dps as 1609.93dps. If i set up the same rotation but use Multi and Arcane it lists my total dps as 1558.94. Obviously the difference in mitigation types (arcane resist/armor) would change these numbers. Will you be adding the ability to factor in the differences in damage mitigation any time soon?

Thanks for the bug report. I tracked it to a column problem in the Trinket database. Next version will have this fixed.

Arcane resist is a mechanic I don't have enough information to model. Right now I assume no resists at all. For armor, you can set the target's armor value on the gear page. All physical damage takes the armor into account.

Glaurong · 06/26/07, 2:10 AM

For boss mobs all of your partial resists will average out to a 5% damage reduction that cannot be mitigated by any means. This is completely independent of a resistance score which 99.99% of the time will be negated by CoS.

Spell hit is irrelevant since arcane shot uses our shot hit mechanics.

Elithuzad · 06/26/07, 4:57 AM

Originally Posted by Pesmerga

I just checked the spreadsheet (Version 20) and it has the correct values listed for the Void Reaver Greaves:

787 Armor, 37 Agility, 33 Stamina, 24 Intellect, 88 AP, R, Y, B Sockets, and a +4 Agility socket bonus.

I get them as 291 Armor, 27 Agi, 11 AP.
Downloaded version 20 again, just to make sure, and its still showing incorrect vaules.

Hunterlin · 06/26/07, 6:00 AM

I have same spreadsheet.
I do get correct stats for Void reaver greaves, but item listed with stats that you wrote is Windrunner Legguards.
May be try to reselect your legs

Elithuzad · 06/26/07, 6:32 AM

Originally Posted by Hunterlin

I have same spreadsheet.
I do get correct stats for Void reaver greaves, but item listed with stats that you wrote is Windrunner Legguards.
May be try to reselect your legs

Ive tried that as well, and even downloaded it a third time, and selected, reselected it.
Still the windrunner stats, ive added them as custom (very neat function), so no biggie.
And since i seem to be the only one with this porblem, ill leave it at that.
Cheers for the replys though, appreciated.

Pesmerga · 06/26/07, 10:01 AM

I've also noticed a bug when using Custom Gear. If I put resilience on custom gear, and use it on the gear sheet, three different things happen, based on slot:

Main Hand, Off Hand, Chest, Legs, and Ranged display the resilience correctly.
The Hand slot does not display resilience at all.
All other slots display the resilience in the Haste Column.

#2 isn't that big of an issue, since Resilience doesn't come up in DPS calculations. However, #3 really threw me for a loop, making some of the Merciless Gladiator gear (before it was in the Spreadsheet) look much nicer than it actually is.

Hunterlin · 06/26/07, 10:43 AM

I did found small bug in gear in spreadsheet.
Neklace of the Deep socket bonus is +3 hit, not +3 agi.

Nightshroud · 06/27/07, 11:35 AM

I have created another Hunter spreadsheet with a smaller scope. It calculates average noncrit and crit damage for ranged attacks, then provides a 'shot average.' Shot average being the result of weighting crit, hit, and miss rate.

The effects of Haste and shot rotation in general are purposefully left out. My goal was to provide a lightweight alternative, accurate within its limits. I also find the act of creating a class spreadsheet personally educational.

Bliz Forum Thread
Google Spreadsheets - Official Copy
Filefront - Excel Format

Plan to look more closely through Lactose and Cheeky's spreadsheets now that I have a better idea what choices and relationships are involved. I'm sure there's more to learn.

Khanate · 06/28/07, 2:03 PM

From a set of data im compiling im wondering if anyone else noticed that the chance to hit doesnt get affected if the enemy is lower level than you?

I am compiling a set of data vs dr. boom, lvl 70 vs lvl 68 with 0 hit rating and +5 bow (troll with a gray bow) and as of 10 minutes ago i was at 118 misses for 3118 shots fired which would give a roughly 3.8% chance to miss counting only the weapon skill rating and not the level difference.

Im gonna assume Cheeky verified his theory for higher level mobs but with my results it seems consistent with his 5% base miss rate and 0.24% +hit per weapon skill except the difference noted earlier.

So im going to continue compiling this.

Cheeky · 06/28/07, 4:10 PM

Originally Posted by Khanate

From a set of data im compiling im wondering if anyone else noticed that the chance to hit doesnt get affected if the enemy is lower level than you?

I am compiling a set of data vs dr. boom, lvl 70 vs lvl 68 with 0 hit rating and +5 bow (troll with a gray bow) and as of 10 minutes ago i was at 118 misses for 3118 shots fired which would give a roughly 3.8% chance to miss counting only the weapon skill rating and not the level difference.

Im gonna assume Cheeky verified his theory for higher level mobs but with my results it seems consistent with his 5% base miss rate and 0.24% +hit per weapon skill except the difference noted earlier.

So im going to continue compiling this.

Try the Blasted Lands mob and see if you miss at all. If you are still seeing a 3.65% miss rate then there is definitely something screwy going on with hit%. (Even the miss rate you are seeing seems too high.)

I would assume a Troll would have a 1.4% miss rate (at 0.24% skill vs. defense), or a 2.4% miss rate (1% per level difference, 0.04% per skill vs. defense) using a bow against Dr. Boom.

My numbers have not been verified by me personally. I plan to do so tomorrow, doing the same sort of tests you are. Using both a bow and a gun I'm hoping so see either a 1.2% or 0.2% difference. I figure 4K shots a piece should be enough of a sample size.

Khanate · 06/28/07, 4:39 PM

I did about 1500 shots more and confirmed my previous results for a lvl 68 mob

I dont really have time to try it out on lower level mobs today though. I will do so tomorrow if no one else has

Groggan · 06/28/07, 7:53 PM

Just an update, I've added the option to see the results of a change in hit rating on the various shots in the Variable Results section.

Link still here.

Serpica · 06/29/07, 9:46 AM

Cheeky, I have a couple of comments on your spreadsheet.

First of all, thanks! I love this spreadsheet.

I noticed that you don't have sockets included for the TwinBlade of the Phoenix. It should have 1 red, 1 yellow, and 1 blue.

Concerning sockets - would it be possible to include a gem tally on the gear tab that shows how many of each color you currently have? This would be very useful in seeing where we are in meeting our metagem requirements, especially when you factor in multi-color gems.