Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Public Discussion » Class Mechanics

 
 
LinkBack Thread Tools
Old 06/25/07, 10:44 AM   #331
Pesmerga
Glass Joe
 
Ghazkrul
Orc Shaman
 
No WoW Account
Originally Posted by Elithuzad View Post
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.

Offline
Old 06/25/07, 7:18 PM   #332
Grondarg
Von Kaiser
 
Orc Death Knight
 
Lightning's Blade
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?

Offline
Old 06/25/07, 8:40 PM   #333
Cheeky
Great Tiger
 
Cheeky
Troll Hunter
 
No WoW Account
Originally Posted by Grondarg View Post
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.


Offline
Old 06/26/07, 2:10 AM   #334
Glaurong
King Hippo
 
Glaurong's Avatar
 
Goblin Hunter
 
Hyjal
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.

Log Parser for BM Hunters (Right click, save as) - Updated 10/11/2007

Offline
Old 06/26/07, 4:57 AM   #335
Elithuzad
Glass Joe
 
Night Elf Hunter
 
Aszune (EU)
Originally Posted by Pesmerga View Post
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.

Last edited by Elithuzad : 06/26/07 at 4:58 AM. Reason: Spelling

Offline
Old 06/26/07, 6:00 AM   #336
Hunterlin
Von Kaiser
 
Dwarf Hunter
 
Draenor (EU)
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

Offline
Old 06/26/07, 6:32 AM   #337
Elithuzad
Glass Joe
 
Night Elf Hunter
 
Aszune (EU)
Originally Posted by Hunterlin View Post
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.

Offline
Old 06/26/07, 10:01 AM   #338
Pesmerga
Glass Joe
 
Ghazkrul
Orc Shaman
 
No WoW Account
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:

  1. Main Hand, Off Hand, Chest, Legs, and Ranged display the resilience correctly.
  2. The Hand slot does not display resilience at all.
  3. 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.

Offline
Old 06/26/07, 10:43 AM   #339
Hunterlin
Von Kaiser
 
Dwarf Hunter
 
Draenor (EU)
Neklace of the Deep: +3 hit socketed

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

Offline
Old 06/27/07, 11:35 AM   #340
Nightshroud
Glass Joe
 
Nightshroud's Avatar
 
Night Elf Priest
 
Alleria
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.


Offline
Old 06/28/07, 2:03 PM   #341
Khanate
Glass Joe
 
Troll Hunter
 
Spirestone
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.

Last edited by Khanate : 06/28/07 at 2:09 PM.

Offline
Old 06/28/07, 4:10 PM   #342
Cheeky
Great Tiger
 
Cheeky
Troll Hunter
 
No WoW Account
Originally Posted by Khanate View Post
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.


Offline
Old 06/28/07, 4:39 PM   #343
Khanate
Glass Joe
 
Troll Hunter
 
Spirestone
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

Offline
Old 06/28/07, 7:53 PM   #344
Groggan
Piston Honda
 
Blood Elf Death Knight
 
Feathermoon
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.

Offline
Old 06/29/07, 9:46 AM   #345
Serpica
Von Kaiser
 
Night Elf Hunter
 
Dunemaul
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.

Offline
 

Go Back   Elitist Jerks » Public Discussion » Class Mechanics

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
Item database project (for all these spreadsheets) Disquette Class Mechanics 89 05/24/08 4:32 PM
DPS and Healing Cloth Spreadsheets Aadar Class Mechanics 11 06/12/07 7:16 AM
[Hunter] Resky's BM and MM excel spreadsheets resky Class Mechanics 2 06/05/07 12:58 AM
In Development - Guild Banks and Voice Chat Trouble Public Discussion 103 05/18/07 1:32 PM