Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Hunters

Closed Thread
 
LinkBack Thread Tools
Old 06/07/09, 6:07 AM   #2776
Flexal
Glass Joe
 
Night Elf Hunter
 
Turalyon (EU)
I've noticed a huge drop in Kill Shot damage in the latest sheet and I've tracked it down to a formula for Kill Shot base damage changing. I'm not sure exactly when this happened but I do know it was sometime between 89b and 89e.

Normalized Auto Shot (KilLShotBase) 89b:
=(EffectiveRAP*0.2 + AmmoDamage + RangedWeaponDamage)*2
My Displayed Result: 5158

Normalized Auto Shot (KilLShotBase) 89e:
=RangedWeaponDamage*2
My Displayed Result: 1023

Was this an intended change? I didn't see it anywhere in your revision notes.

Offline
Old 06/07/09, 8:54 AM   #2777
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Originally Posted by Flexal View Post
I've noticed a huge drop in Kill Shot damage in the latest sheet and I've tracked it down to a formula for Kill Shot base damage changing. I'm not sure exactly when this happened but I do know it was sometime between 89b and 89e.

Normalized Auto Shot (KilLShotBase) 89b:
=(EffectiveRAP*0.2 + AmmoDamage + RangedWeaponDamage)*2
My Displayed Result: 5158

Normalized Auto Shot (KilLShotBase) 89e:
=RangedWeaponDamage*2
My Displayed Result: 1023

Was this an intended change? I didn't see it anywhere in your revision notes.
This is a bug. I was cleaning up formulas (removing spurious recalculations and such) and changed this the wrong way. It will be fixed soon (have some other fixes lined up for today). It should read =AutoShotBaseDamage*2

EDIT:
Re-Uploaded V89e fixing the Kill Shot issue.

EDIT#2:
This also included some code in the shot rotation that tries to decide whether to use/wait for a shot actually gains you dps.

Last edited by Shandara : 06/07/09 at 2:59 PM.


Offline
Old 06/07/09, 3:36 PM   #2778
kurukulla
Glass Joe
 
Troll Hunter
 
Tichondrius
The new spreadsheet will not calculate damage for chimera shot, silencing shot, or multi-shot for me.

Offline
Old 06/07/09, 3:47 PM   #2779
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Originally Posted by kurukulla View Post
The new spreadsheet will not calculate damage for chimera shot, silencing shot, or multi-shot for me.
Be sure to run the rotation test if you started from the default profile that's loaded. That or disable the rotation test on the settings tab.


Offline
Old 06/07/09, 8:39 PM   #2780
arodwrand
Glass Joe
 
Night Elf Hunter
 
Thunderhorn
Not sure if anyone else has this problem, or if I missed the answer in the 112 pages of replies, but when I try to change cells on certain tabs, it says it is protected, and password required to make the changes. Example, when I tried to change the shot rotation priority numbers, every cell said the tab was protected.

Any password or way to fix this? The password was required under the Tools, Protection section of Excel. Using Excel 2003, macro security set to medium, and not saved as "read-only."

Thanks.

Last edited by arodwrand : 06/07/09 at 8:57 PM.

Offline
Old 06/07/09, 9:21 PM   #2781
arlen
Piston Honda
 
arlen's Avatar
 
Human Paladin
 
Blackhand
No there's no password to use. The settings your allowed to change are on the settings tab.

Offline
Old 06/08/09, 12:19 AM   #2782
Spring
Glass Joe
 
Draenei Shaman
 
Bleeding Hollow
Magnetized Projectile Emitter still has the wrong damage range.

Offline
Old 06/08/09, 3:34 AM   #2783
Drako
Glass Joe
 
Tauren Hunter
 
Nathrezim (EU)
Is it possible to add buff profiles, talent speccs and gathering skill to the export function?

Could it be, that HM is not working as intended on live server? Several tests showed, that only the hunter with the talent, the glyph or both get the improved ap and if another hunter, without any improvement, sets the mark, the hunter with the improvement benefits from the mark. (My english is bad^^)

Example 1:
Hunter 1: gylph + talent
Hunter 2: no glyph + no talent

Hunter 1 sets the mark
Hunter 1 gets 750 AP
Hunter 2 gets 500 AP

Hunter 2 sets the mark
Hunter 1 gets 750 AP
Hunter 2 gets 500 AP

Example 2:
Hunter 1: glyph + no talent
Hunter 2: no glyph + talent

A hunter sets the mark
Hunter 1 gets 600 AP
Hutner 2 gets 650 AP

I think this could be the reason, why the mark can be overbuffed by a not improved one.

Last edited by Drako : 06/08/09 at 3:45 AM.

Offline
Old 06/08/09, 7:46 AM   #2784
arodwrand
Glass Joe
 
Night Elf Hunter
 
Thunderhorn
Originally Posted by arlen View Post
No there's no password to use. The settings your allowed to change are on the settings tab.
Those settings, the individual variables, are the ones the spreadsheet won't let me change. It keeps saying the cells/sheet are protected, and to make the changes under tools. When I try to unprotect those cells it asks for the authors password.

Offline
Old 06/08/09, 8:34 AM   #2785
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Originally Posted by arodwrand View Post
Those settings, the individual variables, are the ones the spreadsheet won't let me change. It keeps saying the cells/sheet are protected, and to make the changes under tools. When I try to unprotect those cells it asks for the authors password.
Are you trying to change the locked 'default' values or the yellow, empty 'custom value' fields right next to them?

(This question pops up quite a lot, how can I make it clearer?)


Offline
Old 06/08/09, 8:41 AM   #2786
KergeKacsa
Piston Honda
 
Troll Hunter
 
Ragnaros (EU)
I found an another bug.
If I turn off Hunter's mark (not mine) on the target's Debuff section, and I have 1 point in Imp. Hunters Mark, I have 7297dps.
If I turn on Hunter's mark (not mine, not talented, not glyphed) on the target's Debuff section, I got 7269dps, so I lost 30dps.
It seems the other hunter's unglyphed/untalented HM overwrites my talented HM.
I think this would be good if the greater HM would be in effect.

Edit: It would be great if we can choose not just Imp. HM and glyphed in other hunter's mark place, but IHM1, IHM2 too. (It would be really accurate.)

Last edited by KergeKacsa : 06/08/09 at 12:37 PM.

Offline
Old 06/08/09, 10:40 AM   #2787
Hunterlin
Von Kaiser
 
Dwarf Hunter
 
Draenor (EU)
Originally Posted by Drako View Post
Could it be, that HM is not working as intended on live server? Several tests showed, that only the hunter with the talent, the glyph or both get the improved ap and if another hunter, without any improvement, sets the mark, the hunter with the improvement benefits from the mark. (My english is bad^^)

Example 1:
Hunter 1: gylph + talent
Hunter 2: no glyph + no talent

Hunter 1 sets the mark
Hunter 1 gets 750 AP
Hunter 2 gets 500 AP

Hunter 2 sets the mark
Hunter 1 gets 750 AP
Hunter 2 gets 500 AP

Example 2:
Hunter 1: glyph + no talent
Hunter 2: no glyph + talent

A hunter sets the mark
Hunter 1 gets 600 AP
Hutner 2 gets 650 AP

I think this could be the reason, why the mark can be overbuffed by a not improved one.
Did tested with another hunter on dummy. Tested 0/3, 3/3, 3/3 + glyph and it worked for other hunter in party.

Offline
Old 06/08/09, 11:24 AM   #2788
Drakbak
Von Kaiser
 
Troll Hunter
 
Kargath
Bug report: It appears as if ArP rating from food/elixir buffs isn't being counted in the DPS calc. When i switch from "None" to one of the mentioned buffs, I see no DPS change. The Gear tab isn't displaying any value in the "Additive Buff" row, so this might be where the issue lies.

Offline
Old 06/08/09, 11:35 AM   #2789
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Originally Posted by Drakbak View Post
Bug report: It appears as if ArP rating from food/elixir buffs isn't being counted in the DPS calc. When i switch from "None" to one of the mentioned buffs, I see no DPS change. The Gear tab isn't displaying any value in the "Additive Buff" row, so this might be where the issue lies.
Good catch. Also looks like Mp5 buffs are broken.


Offline
Old 06/08/09, 11:55 AM   #2790
prime311
Von Kaiser
 
lol
Draenei Mage
 
Non-US/EU Server
Adding Silencing Shot to my rotation still does not change my DPS or affect my mana usage. I'd also like to concur with a previous poster that it would be really nice if glyphs saved with our talent specs.

Offline
Old 06/08/09, 12:13 PM   #2791
Drakbak
Von Kaiser
 
Troll Hunter
 
Kargath
Originally Posted by prime311 View Post
Adding Silencing Shot to my rotation still does not change my DPS or affect my mana usage. I'd also like to concur with a previous poster that it would be really nice if glyphs saved with our talent specs.
Did you "Test Rotation" after inputting the new shot priority? In my experience, we need to hit that button after most changes, but mostly in regards to new rotations and added haste effects/reduced CDs

Offline
Old 06/08/09, 1:52 PM   #2792
prime311
Von Kaiser
 
lol
Draenei Mage
 
Non-US/EU Server
Originally Posted by Drakbak View Post
Did you "Test Rotation" after inputting the new shot priority? In my experience, we need to hit that button after most changes, but mostly in regards to new rotations and added haste effects/reduced CDs

Yes I did The shot also shows up in the rotation test tab as being used.

Offline
Old 06/08/09, 2:31 PM   #2793
Drakbak
Von Kaiser
 
Troll Hunter
 
Kargath
Originally Posted by prime311 View Post
Yes I did The shot also shows up in the rotation test tab as being used.
Something I noticed is that if you put "None" in the middle of your rotation, it will botch up the rotation test. I used to be able to do this i prior versions if i wanted to remove a shot (like silencing shot) from the rotation to test the change in dps.

Is it possible that Silencing SHot is being preceded by a "None"?

Offline
Old 06/08/09, 3:00 PM   #2794
prime311
Von Kaiser
 
lol
Draenei Mage
 
Non-US/EU Server
Originally Posted by Drakbak View Post
Something I noticed is that if you put "None" in the middle of your rotation, it will botch up the rotation test. I used to be able to do this i prior versions if i wanted to remove a shot (like silencing shot) from the rotation to test the change in dps.

Is it possible that Silencing SHot is being preceded by a "None"?

Ok I tracked it down. Even though it lists silencing shot in the rotation(in the rotation test tab), it's frequency is at 0(in the shot rotation tab) if its at a lower priority then steady shot. Makes sense because nothing after SS can be cast since it is always available, but the bug is that it still shows up in the rotation test tab. I noticed the same thing if rapid fire and readiness are listed after SS.

Last edited by prime311 : 06/08/09 at 3:06 PM.

Offline
Old 06/08/09, 4:55 PM   #2795
prime311
Von Kaiser
 
lol
Draenei Mage
 
Non-US/EU Server
<post removed> Found answer through search.

Last edited by prime311 : 06/08/09 at 5:48 PM.

Offline
Old 06/08/09, 8:37 PM   #2796
arodwrand
Glass Joe
 
Night Elf Hunter
 
Thunderhorn
Originally Posted by Shandara View Post
Are you trying to change the locked 'default' values or the yellow, empty 'custom value' fields right next to them?

(This question pops up quite a lot, how can I make it clearer?)

Fixed the problem. It was an IBCAK error on my end.

Offline
Old 06/09/09, 11:02 AM   #2797
bagmol
Glass Joe
 
Night Elf Hunter
 
Neptulon (EU)
Do anyone actually reach their theoretical dps taken from the spreadsheet in a real raid situation?

The spreadsheet tells me I should be doing around 7000 dps as survival but in a real raid situation for example in VOA Im not reaching higher then 5300 dps.

However unbuffed the spreadsheet tells me I should be doing around 3600 dps and when Im dpsing the bossdummy Im doing 3300 unbuffed so this value seems more correct.

Offline
Old 06/09/09, 11:24 AM   #2798
inyu
Glass Joe
 
Night Elf Hunter
 
Tyrande (EU)
Probably because in the dummie it only depends on how you manage your player, while in raid situation maybe someone isn't debuffing the boss properly, and other situational factors.

Offline
Old 06/09/09, 11:47 AM   #2799
Drakbak
Von Kaiser
 
Troll Hunter
 
Kargath
Originally Posted by bagmol View Post
Do anyone actually reach their theoretical dps taken from the spreadsheet in a real raid situation?

The spreadsheet tells me I should be doing around 7000 dps as survival but in a real raid situation for example in VOA Im not reaching higher then 5300 dps.

However unbuffed the spreadsheet tells me I should be doing around 3600 dps and when Im dpsing the bossdummy Im doing 3300 unbuffed so this value seems more correct.
The spreadsheet models "Ideal" situations in a perfect world with perfect execution. It's highly unlikely that any human would be capable of achieving these conditions naturally, so it's expected to be below the theoretical amount. Also, as good as the spreadsheet is, it's far from being perfect which will also result in different results.

Offline
Old 06/09/09, 1:42 PM   #2800
Apathy
Glass Joe
 
Night Elf Hunter
 
Doomhammer
There have been a few times where I wanted to compare using a mana pot/taking more mana talents and using a speed pot instead. I tried to figure it out manually but completely failed. I would appreciate it if you could add speed potions or if someone could give me an insight of how to do it manually. No biggie if it is too much of a pain, just always on the back of my mind. I appreciate all your work on the spreadsheet, thank you.

Offline
Closed Thread

Go Back   Elitist Jerks » 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