Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics » Hunters

Closed Thread
 
LinkBack Thread Tools
Old 03/25/09, 12:16 PM   #1936
Smee
Glass Joe
 
Dwarf Death Knight
 
Dentarg (EU)
Noticed a slight problem with the spreadsheet whilst trying to work out the difference between 6/14/51 and 15/56, the mana per 5 of judgement of wisdom does not remove itself when you click no on the target debuffs, it stays within the calculations regardless, therefore skewing the worth of Aspect of the Viper and such.

If anyone could verify if its just a problem with my copy of the sheet or such, but thats how it seems to me at present. I still have 140 mana per second with the No Buffs profile loaded.

Offline
Old 03/25/09, 12:59 PM   #1937
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Originally Posted by Tunoc View Post
In V86c the formula in column 97 doesnt include RaceBonus because column 8 is not included in the formula.
(Maybe worth english, its not my mature language )
I'm not sure I understand this, what tab? What cell? Which calculation? If you can be more precise, it would help.


Offline
Old 03/25/09, 3:09 PM   #1938
Esoth
Bald Bull
 
Esoth's Avatar
 
Pandaren Hunter
 
Whisperwind
Originally Posted by Shandara View Post
I'm not sure I understand this, what tab? What cell? Which calculation? If you can be more precise, it would help.
It sounds like he might be talking about the base racial stats not being included in the row 97 cells of the Gear tab. Those formulas calculate the sum starting on row 9 instead of 8 (the racial stats) which I guess is supposed to be true since that row is called "From Gear:".

Alts: http://www.esoth.com/wow/my-characters
Ion: Along with asking why we fight, and learning that our true enemy is war itself, a major theme of the Mists of Pandaria has been killing turtles
Hunter spreadsheet: http://www.esoth.com/files/mop/at_download/file

United States Offline
Old 03/25/09, 3:23 PM   #1939
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Originally Posted by Esoth View Post
It sounds like he might be talking about the base racial stats not being included in the row 97 cells of the Gear tab. Those formulas calculate the sum starting on row 9 instead of 8 (the racial stats) which I guess is supposed to be true since that row is called "From Gear:".
Ah, they are added a few rows below that in any case. Previously they were all just added up, but I split it because it seems Blizzard does some rounding along the way and I was trying to make it match the in-game tooltips more.


Offline
Old 03/25/09, 3:30 PM   #1940
Ferlog
Glass Joe
 
Dwarf Hunter
 
Shadowsong
Mangle not effecting Piercing Shot Bleed (?)

I was just curious if there's been any raid testing with the mangle debuff and the damage resulting in the bleed effect from piercing shots? If it isn't increasing the damage, is there an intent to include it (i.e. is this a bug or working as intended). Currently in the spreadsheet, it offers no dps increase in MM.

Offline
Old 03/25/09, 3:44 PM   #1941
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Blizzard has said it is not supposed to affect Piercing Shots.


Offline
Old 03/25/09, 6:32 PM   #1942
Rucca79
Glass Joe
 
Blood Elf Hunter
 
Akama
Originally Posted by Shandara View Post
EDIT:

I untalented and found out that the tooltip is modified by Trap Mastery, but ONLY the base damage it seems. But the numbers don't quite match up still. Taking only talents that don't affect Black Arrow (i.e. no Improved Tracking, Sniper Training or Noxious Stings) I had 3861 AP.

The tooltip value should be 2765 + 386,1 = 3151 which matched the in game value.

Then I took 3/3 Trap Mastery, the tooltip displays: 3976, but you'd expect 3151 * 1,3 = 4096. On the other hand, 2765*1,3 + 386,1 = 3980,1.

With 3976 tooltip damage you'd expect 843 ticks (3976/5*106% = 843) ticks. Instead I'm getting 834 ticks (not a typo).
It would appear that Blizzard may be using a rounding factor at the tens place, so

2765 *1.3 = 3594.5 round at the tens to 3590
3590 + 386.1 = 3976

So it wouldn't actually be 30% but a set standard of 3590

If you then take into consideration TNT, which is a 6% added to the 30%

2765 *1.36 = 3760.4 round at the tens to 3760
3760 + 386.1 = 4146.1

I tried on other RAPs and it works the same.

Last edited by Rucca79 : 03/26/09 at 6:35 PM.

Offline
Old 03/26/09, 4:32 AM   #1943
Tunoc
Glass Joe
 
Orc Hunter
 
Lordaeron (EU)
Originally Posted by Shandara View Post
I'm not sure I understand this, what tab? What cell? Which calculation? If you can be more precise, it would help.
In tab "Gear" Row 97, columns "C" - "R" the formula "=sum(c9:c94)" would be "=sum(c8:c94)" because the stats of race are not included.

Ich glaub du kannst ja deutsch, hast ja immer im wow-forum gepostet
Die Formeln im Tabellenblatt "Gear" in den Spalten "C"-"R" in der Zeile 97 beinhalten nicht die Rassenstats der Zeile 8.
Ich denke die Formel müsste z.B. in Zelle "c97" so lauten: "=SUMME(c8:c91)" anstatt "=SUMME(c9:c91)".

Offline
Old 03/26/09, 4:39 AM   #1944
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Originally Posted by Tunoc View Post
In tab "Gear" Row 97, columns "C" - "R" the formula "=sum(c9:c94)" would be "=sum(c8:c94)" because the stats of race are not included.

Ich glaub du kannst ja deutsch, hast ja immer im wow-forum gepostet
Die Formeln im Tabellenblatt "Gear" in den Spalten "C"-"R" in der Zeile 97 beinhalten nicht die Rassenstats der Zeile 8.
Ich denke die Formel müsste z.B. in Zelle "c97" so lauten: "=SUMME(c8:c91)" anstatt "=SUMME(c9:c91)".
Thanks, the race stats are, however, included in the final tally in the lowest row. I split them up some time ago because Blizzard appears to apply rounding to them separately.


Offline
Old 03/27/09, 10:16 AM   #1945
thebrian
Glass Joe
 
Troll Hunter
 
Zangarmarsh
I was experimenting with a Lock and Load build that didn't have Explosive Shot (0/31/40), and noticed that when Lock and Load proc'd it did not properly trigger no cooldown on Arcane Shot in the rotation test. Not that such a build is a viable PVE dps build at the moment, but it certainly could be interesting for PVP to do something like this.

Offline
Old 03/27/09, 12:09 PM   #1946
Esoth
Bald Bull
 
Esoth's Avatar
 
Pandaren Hunter
 
Whisperwind
The Fury of the Five Flights trinket could use a bit of a tweak. I'm at 0.91 shots per second, according to the spreadsheet, which means it takes a bit over 18 seconds to get a full stack. Not bad, but not trivial in my opinion.

Since you are already setting the duration of the fight, you could use this to get a more accurate number.
16*AvgShotTime/TotalTime + 32*AvgShotTime/TotalTime + ... + 304*AvgShotTime/Time + 320*(TotalTime-AvgShotTime*20)/TotalTime
=3040*AvgShotTime/TotalTime + 320*(TotalTime-AvgShotTime*20)/TotalTime
This number approaches 320 as TotalTime approaches infinity. With my frequency this puts it at about 311 AP for a 6 minute fight, but only 294 for a 2 minute fight.

Obviously this trinket would still have its caveats, but we could use this to figure out how long a boss fight would need to be (or a phase change before we must lose stacks - Mimiron?) for this trinket to be better than say Bandit's or Mirror.

Alts: http://www.esoth.com/wow/my-characters
Ion: Along with asking why we fight, and learning that our true enemy is war itself, a major theme of the Mists of Pandaria has been killing turtles
Hunter spreadsheet: http://www.esoth.com/files/mop/at_download/file

United States Offline
Old 03/27/09, 2:56 PM   #1947
afxwinter
Glass Joe
 
afxwinter's Avatar
 
Blood Elf Hunter
 
Laughing Skull
Shandara, I can't even begin to thank you enough for your spreadsheet. It's one of the main reasons I stuck with my hunter for as long as I have. I was just curious if you had any plans to create something similar for other classes. I recently leveled a DK and am feeling a little lost without my trusty spreadsheet I've grown so attached to.

Offline
Old 03/28/09, 5:25 AM   #1948
Mikari
Banned
 
Moo
Dwarf Priest
 
Bloodhoof
Originally Posted by Esoth View Post
The Fury of the Five Flights trinket could use a bit of a tweak. I'm at 0.91 shots per second, according to the spreadsheet, which means it takes a bit over 18 seconds to get a full stack. Not bad, but not trivial in my opinion.

Since you are already setting the duration of the fight, you could use this to get a more accurate number.
16*AvgShotTime/TotalTime + 32*AvgShotTime/TotalTime + ... + 304*AvgShotTime/Time + 320*(TotalTime-AvgShotTime*20)/TotalTime
=3040*AvgShotTime/TotalTime + 320*(TotalTime-AvgShotTime*20)/TotalTime
This number approaches 320 as TotalTime approaches infinity. With my frequency this puts it at about 311 AP for a 6 minute fight, but only 294 for a 2 minute fight.

Obviously this trinket would still have its caveats, but we could use this to figure out how long a boss fight would need to be (or a phase change before we must lose stacks - Mimiron?) for this trinket to be better than say Bandit's or Mirror.
Does that take into account the fact that a single Explosive Shot will gain you 3 stacks of the AP buff?

Offline
Old 03/28/09, 12:42 PM   #1949
Esoth
Bald Bull
 
Esoth's Avatar
 
Pandaren Hunter
 
Whisperwind
Hmm, no, I guess that would be a problem.

Alts: http://www.esoth.com/wow/my-characters
Ion: Along with asking why we fight, and learning that our true enemy is war itself, a major theme of the Mists of Pandaria has been killing turtles
Hunter spreadsheet: http://www.esoth.com/files/mop/at_download/file

United States Offline
Old 03/29/09, 7:57 PM   #1950
Dch48
Von Kaiser
 
Night Elf Hunter
 
Draka
Originally Posted by Smee View Post
Noticed a slight problem with the spreadsheet whilst trying to work out the difference between 6/14/51 and 15/56, the mana per 5 of judgement of wisdom does not remove itself when you click no on the target debuffs, it stays within the calculations regardless, therefore skewing the worth of Aspect of the Viper and such.

If anyone could verify if its just a problem with my copy of the sheet or such, but thats how it seems to me at present. I still have 140 mana per second with the No Buffs profile loaded.

I am noticing the exact same thing. Judgement of Wisdom does not clear when you clear the buffs and remains in the calculations on the calculations tab. Even manually setting it to no on the buffs tab has no effect.

Offline
Closed Thread

Go Back   Elitist Jerks » Class Mechanics » Hunters

Thread Tools

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