Elitist Jerks
Register
Blogs
Urban Rivals
Forums
New Posts


Go Back   Elitist Jerks > Public Discussion > Class Mechanics > Hunters
Elitist Jerks Login

gamerDNA Login

Welcome to Elitist Jerks
We're testing some new features on the site regarding OpenID registration and coordination with gamerDNA. If you experience any issues with registering an account, please take the time to fill out a report and send it to this e-mail address. We would appreciate any assistance you could provide in making sure everything is functioning as intended. Thanks!

If this is your first visit, please be sure to check out the FAQ and the forum rules. Users must register to post and new registrations are subject to a one day "mute" period to get acquainted with the community.

Reply
LinkBack (1914) Thread Tools
Old 10/14/08, 1:46 PM   4 links from elsewhere to this Post. Click to view. #326
Devastor
Banned
 
Orc Hunter
 
Blade's Edge (EU)
No doubt this will break stuff (although I didn't get many errors myself and I fixed those), so let me know.

i'm confused again, using 74b.

Longevity:

1/3: Me +1DPS | Pet +15dps
2/3: Me +4DPS | Pet -13DPS !!!
3/3: Me +2DPS | Pet +50DPS

this seems strange to me.
I understand, that with different CDs, Buffs "collide" in a better/worse way (Like +AP trinket and BW/TBW...)
But the "jumps" are really strange.

From 1/3 to 2/3 points actually decreases Pet-DPS by 13DPS, or in other words: 2/3 is +2 Pet-dps vs 0/3
And then the abnormal jump from 2/3 to 3/3...
 
User is offline.
Reply With Quote
Old 10/14/08, 1:52 PM   #327
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Originally Posted by Devastor View Post
i'm confused again, using 74b.

Longevity:

1/3: Me +1DPS | Pet +15dps
2/3: Me +4DPS | Pet -13DPS !!!
3/3: Me +2DPS | Pet +50DPS

this seems strange to me.
I understand, that with different CDs, Buffs "collide" in a better/worse way (Like +AP trinket and BW/TBW...)
But the "jumps" are really strange.

From 1/3 to 2/3 points actually decreases Pet-DPS by 13DPS, or in other words: 2/3 is +2 Pet-dps vs 0/3
And then the abnormal jump from 2/3 to 3/3...
It has to do with Rake. With Longevity at 2/3 or 3/3 you miss the last tick because it's refreshed before it ticks for the 3rd time.

I could offer a big explanation, but after looking at the code it's not quite what I want it do. I'll re-do it for the next release.

 
User is offline.
Reply With Quote
Old 10/14/08, 2:09 PM   #328
Devastor
Banned
 
Orc Hunter
 
Blade's Edge (EU)
Thanks a lot
 
User is offline.
Reply With Quote
Old 10/14/08, 2:47 PM   #329
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Originally Posted by Devastor View Post
Thanks a lot
The calculation in the sheet as it is now is correct, it's just a bit kludgy. The results won't change.

It comes from the fact that Rake ticks 3 times. Every 3 seconds for 9 seconds. Now if you have 2/3 or 3/3 Longevity (i.e. 8 or 7 sec cooldown) you'll cut off the last part of the Rake DoT.

In case of the 2/3 and coupled with pet GCD you waste nearly a whole tick (at a 1.25 sec pet GCD Rake will fire in ideal situations every 8.75 seconds). You'd have gotten the 3rd tick at 9 seconds so you waste 2.75 seconds of time. This is what leads to the dps LOSS.

In case of 3/3 Longevity it's the same, but with a 7 sec cooldown you waste less time. But, at the same time you get an added benefit from the reduced CD on Bestial Wrath/Rapid Fire, because of how the cooldowns line up. This leads to the substantial DPS boost.

This is all in theory and in the sheet of course. Testing will have to determine whether or not it's close enough to the truth.

 
User is offline.
Reply With Quote
Old 10/14/08, 4:24 PM   #330
Littlehelper
Glass Joe
 
Littlehelper's Avatar
 
Night Elf Hunter
 
Azshara (EU)
I was looking through some of the Formula, because Hit did increase my dps as Surv despite being above the hitcap.

So I found some questionable calculations.. the Explosion Shot's average dmg is decreased as if it would have a 17% extra Misschance.(Calculations.K103) Does ES really have a 17% base-miss-chance?
Also there is a 5,14% reduction due to partial resists and I always assumed partials resist only happen due to magic resistance, which should be decreased by curse of elements. So shouldn't that be 0%?


And I found similiar weird behavior in the pet calculations.C69, where the partial resist is decreased by Animal Handler and Pet/Hunter Hitrating.

And as long as I am not misinterunderstanding shouldn't Wolverine Bite's Total Damage(Pet Calculations.C140) be C132*C138*(1-C139)?
 
User is offline.
Reply With Quote
Old 10/14/08, 4:39 PM   #331
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Originally Posted by Littlehelper View Post
I was looking through some of the Formula, because Hit did increase my dps as Surv despite being above the hitcap.

So I found some questionable calculations.. the Explosion Shot's average dmg is decreased as if it would have a 17% extra Misschance.(Calculations.K103) Does ES really have a 17% base-miss-chance?
Also there is a 5,14% reduction due to partial resists and I always assumed partials resist only happen due to magic resistance, which should be decreased by curse of elements. So shouldn't that be 0%?


And I found similiar weird behavior in the pet calculations.C69, where the partial resist is decreased by Animal Handler and Pet/Hunter Hitrating.

And as long as I am not misinterunderstanding shouldn't Wolverine Bite's Total Damage(Pet Calculations.C140) be C132*C138*(1-C139)?
Thanks, the Wolverine Bite is a typo indeed!

As for the magical spells/abilities. This is a relic of the old sheet. I haven't really done any testing whether Animal Handle/Pet Hit still affect it's resist chance on magical attacks (but I assume so since all hitratings have been merged).

As for Explosive Shot, I saw partial/full resists against training dummies (which I assume do not have artifically high magic resistances). This is an area where I have not done any exhaustive testing.

 
User is offline.
Reply With Quote
Old 10/14/08, 8:24 PM   #332
Chul
Piston Honda
 
Chul's Avatar
 
Orc Hunter
 
Proudmoore
One minor thing that annoys me is that even if you sort items alphabetically via the Gear Planner tab, the weapons selection list in the Gear tab is still in random order. It works for all the other item selection lists, just not for weapons.

Originally Posted by Skillstep
Why is it that other classes feel whole and simple and fluid yet hunter feels like directing a symphony as a paraplegic midget with tourettes?
 
User is offline.
Reply With Quote
Old 10/14/08, 9:42 PM   #333
KraxisSingular
Banned
 
Blood Elf Hunter
 
Runetotem (EU)
Originally Posted by Shandara View Post
The calculation in the sheet as it is now is correct, it's just a bit kludgy. The results won't change.

It comes from the fact that Rake ticks 3 times. Every 3 seconds for 9 seconds. Now if you have 2/3 or 3/3 Longevity (i.e. 8 or 7 sec cooldown) you'll cut off the last part of the Rake DoT.

In case of the 2/3 and coupled with pet GCD you waste nearly a whole tick (at a 1.25 sec pet GCD Rake will fire in ideal situations every 8.75 seconds). You'd have gotten the 3rd tick at 9 seconds so you waste 2.75 seconds of time. This is what leads to the dps LOSS.

In case of 3/3 Longevity it's the same, but with a 7 sec cooldown you waste less time. But, at the same time you get an added benefit from the reduced CD on Bestial Wrath/Rapid Fire, because of how the cooldowns line up. This leads to the substantial DPS boost.

This is all in theory and in the sheet of course. Testing will have to determine whether or not it's close enough to the truth.
Are we certain that pets have a 1.25 GCD, and that is intended. I remember the talks that mentined specials going off at such a speed or similar. But I have yet to see any backup claims that it is certainly like that and that it is supposed to be so.
Not that I midn it, it will only require a little restructuring.

Btw, quite crappy that Cats scale so horribly with Longevity. Spirit Beasts scale well because their attack stacks?
 
User is offline.
Reply With Quote
Old 10/15/08, 3:45 AM   #334
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Originally Posted by KraxisSingular View Post
Are we certain that pets have a 1.25 GCD, and that is intended. I remember the talks that mentined specials going off at such a speed or similar. But I have yet to see any backup claims that it is certainly like that and that it is supposed to be so.
Not that I midn it, it will only require a little restructuring.

Btw, quite crappy that Cats scale so horribly with Longevity. Spirit Beasts scale well because their attack stacks?
A little earlier in this thread me and Chul did separate tests on the matter. If we can believe the combat log than on _average_ specials happen every 1,25s.

 
User is offline.
Reply With Quote
Old 10/15/08, 5:36 AM   #335
Miya Mirage
Von Kaiser
 
Miya Mirage's Avatar
 
Orc Hunter
 
Zirkel des Cenarius (EU)
Edit: I see what you did there, found the customs column on the settings tab.

A bug I found though:

When turning on True Shot Aura for the Hunter and Pet Buffs on the Hunter Tab it bugs out all calculations for the AP Modifier Column. I think its referencing wrong.

Also the cell for the Fight Length sub 20% only accepts integers, at least one decimal would be good I think since its a bit more exact then.

Edit2: I meant the Buff Tab for the TSA Bug

Last edited by Miya Mirage : 10/15/08 at 7:24 AM.
 
User is offline.
Reply With Quote
Old 10/15/08, 7:15 AM   #336
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Originally Posted by Miya Mirage View Post
Edit: I see what you did there, found the customs column on the settings tab.

A bug I found though:

When turning on True Shot Aura for the Hunter and Pet Buffs on the Hunter Tab it bugs out all calculations for the AP Modifier Column. I think its referencing wrong.

Also the cell for the Fight Length sub 20% only accepts integers, at least one decimal would be good I think since its a bit more exact then.
Thanks, the sub-20% boss hp feature doesn't work at the moment since I'll be re-doing the Kill Shot calculations to see if I can do it without VBscript.

 
User is offline.
Reply With Quote
Old 10/15/08, 9:35 AM   #337
ElginRoko
Von Kaiser
 
Blood Elf Paladin
 
Sporeggar (EU)
Originally Posted by Littlehelper View Post
So I found some questionable calculations.. the Explosion Shot's average dmg is decreased as if it would have a 17% extra Misschance.(Calculations.K103) Does ES really have a 17% base-miss-chance?
Also there is a 5,14% reduction due to partial resists and I always assumed partials resist only happen due to magic resistance, which should be decreased by curse of elements. So shouldn't that be 0%?
From Formulas:Magical resistance - WoWWiki - Your guide to the World of Warcraft :
Note: Level-based resistance (not to be confused with level-based miss) can play a factor in total resists. For every level that a mob has over the player, there is 8 resist (believed; the exact number may be higher) added. For boss fights, this means there is 15-24 resistance added. This extra resistance means there will be partial resists on non-binary spells from the added resistance. However, this resistance has been shown to not apply to binary spells at all.
This level based resistance cannot be reduced by any means, not even Spell Penetration.
Which is where the 5.14% comes from, that's why you see partial resists on arcane and explosive.

From what I've seen though, magic damage ranged shots only roll for ranged hits, I haven't seen anything to support an additional spell hit roll, though I haven't done rigorous testing. Shouldn't be too hard to test by spamming arcane against a +3 levels target with 9% hit though.
 
User is offline.
Reply With Quote
Old 10/15/08, 9:39 AM   #338
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Originally Posted by ElginRoko View Post
From what I've seen though, magic damage ranged shots only roll for ranged hits, I haven't seen anything to support an additional spell hit roll, though I haven't done rigorous testing. Shouldn't be too hard to test by spamming arcane against a +3 levels target with 9% hit though.
I tried to test it last night, but full resists show up as misses currently and recount isn't tracking partial resists properly (yet) so I couldn't get anything accurate.

 
User is offline.
Reply With Quote
Old 10/15/08, 12:13 PM   #339
Celfydd
Von Kaiser
 
Celfydd's Avatar
 
Night Elf Hunter
 
The Sha'tar (EU)
Is there any plan to publish an OpenOffice-compatible version of the WotLK spreadsheet, for those that don't have Windows?

I have Excel on my Mac but it doesn't handle any of the macros correctly - OpenOffice works the same on Windows and Mac.
 
User is offline.
Reply With Quote
Old 10/15/08, 7:41 PM   #340
Kamaa
Free Arrows For Life
 
Kamaa's Avatar
 
Tauren Death Knight
 
Mal'Ganis
Originally Posted by Celfydd View Post
Is there any plan to publish an OpenOffice-compatible version of the WotLK spreadsheet, for those that don't have Windows?

I have Excel on my Mac but it doesn't handle any of the macros correctly - OpenOffice works the same on Windows and Mac.
Open Office can't really handle the spreadsheet. It's been done by people other than the authors in the past, but rarely to any amount of acceptable utility. Basically, Excel > Open Office. The general response to this question is, feel free to volunteer if you want to do it, but don't hold your breath waiting for somebody else to do it.

On a side note. [Quick Lionseye] is missing from the gem list. Also, is there a toggle somewhere that I am missing to quickly adjust all of the settings for level 70? If not, would this be a feasible option?

Omegatron has arrived.
 
User is offline.
Reply With Quote
Old 10/16/08, 6:50 AM   #341
Nandei
Von Kaiser
 
Nandei's Avatar
 
Blood Elf Hunter
 
Moonglade (EU)
There are some protected fields in the spreadsheet, which I think would be better left unprotected.

In the settings:

-Gem options, can't set your own preferred default gems at the moment.
-Boss fight, I don't know if this has to be 15 mins for some calculations to work, if not, would be nice to have it be changeable.
-Target options, its not possible to set your own custom target at the moment.

If I am just failing at something with Excel again, ignore this, if not would be nice to get these unprotected in the next version.
 
User is offline.
Reply With Quote
Old 10/16/08, 6:59 AM   #342
Vegelus
Von Kaiser
 
Vegelus's Avatar
 
Dwarf Hunter
 
Shadowsong (EU)
Originally Posted by Nandei View Post
There are some protected fields in the spreadsheet, which I think would be better left unprotected.

In the settings:

-Gem options, can't set your own preferred default gems at the moment.
-Boss fight, I don't know if this has to be 15 mins for some calculations to work, if not, would be nice to have it be changeable.
-Target options, its not possible to set your own custom target at the moment.

If I am just failing at something with Excel again, ignore this, if not would be nice to get these unprotected in the next version.
Those are editable. Use fields right to the ones you tried to use.
 
User is offline.
Reply With Quote
Old 10/16/08, 7:04 AM   #343
Nandei
Von Kaiser
 
Nandei's Avatar
 
Blood Elf Hunter
 
Moonglade (EU)
Originally Posted by Vegelus View Post
Those are editable. Use fields right to the ones you tried to use.
Thanks! Didn't even cross my mind you could do it that way x(

Feel really stupid now, should read all the things in there. Obviosly "Custom Value" is the one I should change, not the default one.
 
User is offline.
Reply With Quote
Old 10/16/08, 7:55 AM   #344
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Originally Posted by Chul View Post
One minor thing that annoys me is that even if you sort items alphabetically via the Gear Planner tab, the weapons selection list in the Gear tab is still in random order. It works for all the other item selection lists, just not for weapons.
This is a legacy of the old sheet, I've been meaning to do something about it, but the problem is that it merges 2 lists (one for 1-handed weapons and one for 2-handed weapons), which makes sorting on the fly impossible. They are both pregenerated.

I could merge them both and sort them alphabetically, if you think that's better. But you'd have a very long list to search through. I could also try to sort both lists alphabetically before merging them and add some sort of divider halfway between 1-handers and 2-handers.

 
User is offline.
Reply With Quote
Old 10/16/08, 2:52 PM   #345
Ravenfire
Piston Honda
 
Dwarf Hunter
 
Stormrage
One bug, and a request for the community to look into some buffs/debuffs that might affect pet spells

Bug: the Draenei Racial +1% to hit is not being applied to pet's Spell hit chance (works for melee hit chance).

Missing/request for data: The +spell hit debuffs (Imp. FF from Moonkins and Misery from Shadow Priests) are not currently in the sheet and would add an additional 3% to hit for pet spells (if they work on pet spells). Similarly, while moonkin aura grants the same 5% crit as LotP and are as such a wipe for the current version of the sheet, the spell crit debuff is signficantly larger then the physical crit debuff (10% spell crit vs. 3% physical crit) but is not an option in the buff/debuff list. Finally, does anyone know if any of the +spell damage buffs (Imp Spirit, Flametongue Totem, Totem of Wrath, or Demonic Pact) affect pets?

P.S. Any chance you could do a rudimentary calculation on Thunderstomp (gorilla)? I believe that it is currently getting full spell damage (no deduction for being insta cast). As a BM (with all the % multipliers), and selfbuffed with roughly 2750 RAP, i was seeing Thunderstomp hit for 590-680 non crits.
 
User is offline.
Reply With Quote
Old 10/16/08, 9:52 PM   #346
samfisher
Von Kaiser
 
samfisher's Avatar
 
Dwarf Hunter
 
Nagrand
I found that when you put TSA up in the buff section, everything goes #NA# and some other symbols until I turn it off. Just to let you know =)
 
User is offline.
Reply With Quote
Old 10/17/08, 2:52 AM   #347
alienangel
Bald Bull
 
alienangel's Avatar
 
Draenei Hunter
 
Eredar
Originally Posted by Shandara View Post
This is a legacy of the old sheet, I've been meaning to do something about it, but the problem is that it merges 2 lists (one for 1-handed weapons and one for 2-handed weapons), which makes sorting on the fly impossible. They are both pregenerated.

I could merge them both and sort them alphabetically, if you think that's better. But you'd have a very long list to search through. I could also try to sort both lists alphabetically before merging them and add some sort of divider halfway between 1-handers and 2-handers.
Have one gear slot for "2 Handler", and two for "1 Hander", feed the two types different dropdowns, and when one type is set, blank out the other?

Also, since we're asking for stuff, filtering out all the random gems we don't care about, or sorting gems like other gear in the dropdowns would be great
 
User is offline.
Reply With Quote
Old 10/17/08, 6:38 AM   #348
Khallas
Glass Joe
 
Tauren Hunter
 
Cenarius
Originally Posted by Kamaa View Post
On a side note. [Quick Lionseye] is missing from the gem list.
Just to reiterate, [Quick Lionseye] & [Forceful Seaspray Emerald] are not able to be selected in the gem list.
 
User is offline.
Reply With Quote
Old 10/17/08, 8:12 AM   #349
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Update:
- Added a setting to use 1 mana potion during the fight
- Wolverine Bite now is properly mitigated by armor
- Time sub-20% on the setting stab can now have decimals
- TSA buff on hunter/pet works again
- Implemented Upcoming AotV change
- Added Kill Shot low HP calculations. Kill Shot will replace only Steady Shots at the moment
- added Quick Lionseye/Forceful Seaspray Emerald
- Orc Blood Fury racial now has to be put in the shot rotation to have effect
- Sorted weapons list alphabetically
- Draenei Racial and Animal Handler also affect pet spellhit now
- Scrolls don't stack anymore.

 
User is offline.
Reply With Quote
Old 10/17/08, 9:01 AM   #350
Thelegend
Glass Joe
 
Night Elf Hunter
 
Outland (EU)
Heya Shandara

Not entirely sure what has happened, but I ported the old versions stats into the new version and my DPS appears to have gone up by roughly 155,000. After my initial moment of pleasure at what could be my new DPS figures, I realised that there may in fact be a problem.

I havn't been able to fix it via settings as of yet, however, there does appear to be a problem with the pre-loading of buff profiles (Warp Burger gets thrown into the 2nd weapon buff spot for example). Did you add additional hidden lines in there somewhere?

Either way - great work on the spreadsheet, I'm very happy to see it working so well.

Side note: Have you considered getting together with the RAWR guys to add all of this invaluable information to their files for accuracy? The modelling and what not within RAWR doesn't quite compare to that of the spreadsheet, however, for a general gear upgrade tool it is really quite something, which may benefit greatly from your input.

EDIT: Seem to be having a problem getting Serpent Sting working in the rotation tests too.

EDIT 2: Helm DPS contribution seems to be far higher than expected.

Last edited by Thelegend : 10/17/08 at 9:09 AM.
 
User is offline.
Reply With Quote
Reply

Go Back   Elitist Jerks > Public Discussion > Class Mechanics > Hunters

Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Moonkin DPS Spreadsheet Efejel Druids 1925 11/04/08 3:34 PM
Hunter lvl 70 DPS spreadsheet Solaris Public Discussion 12 12/03/06 7:09 AM