Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics » Hunters

Closed Thread
 
LinkBack Thread Tools
Old 11/05/09, 2:11 PM   #3736
Balrouge
Glass Joe
 
Dwarf Hunter
 
Windrunner
DPS Spreadsheet accuracy

Just wanted to post to vouch for the accuracy of the spreadsheet in its intended use, as I often times hear the statement, "The SS says I do X dps, but I'm only doing Y". After testing PTR patchwerk (Raid DPS Test), the following log was recorded:

World of Logs - Real Time Raid Analysis

The spreadsheet accurately reported me at 10k. A couple things to note, Culling the Herd was implemented on the PTR, with an uptime at ~ 83%. Also, a couple of our dps were premades, or died to hatefuls (lol); considering both of those factors/variables, I'm thinking it's pretty much on point for the intended use.

Offline
Old 11/05/09, 3:28 PM   #3737
Whitefyst
Great Tiger
 
Orc Hunter
 
Draenor
Originally Posted by mistla View Post
I am looking at 92.b of the spreadsheet. One the Calculations worksheet in the Armor Penetration block. The calculation for the armor Constant looks correct when compared to wowwiki, but the Level_Selected parameter appears to be set to 80 when the boss level is set to 83. The result is a Constant of 15232.5 for a level 83 boss.

I am wondering if wowwiki has it wrong, I have my spreadsheet setup wrong, or there is a possible bug with the calculation. Can anyone else confirm or deny?
My understanding, and how I believe the spreadsheet is coded, is the following:

The level armor constant of 16635 for level 83 targets effects how much armor they have. This is already factored into the target's armor amount. Different levels of targets and their armor constants factor into the armor amount for target's of various levels.

The reason that the level 80 armor constant of 15232.5 is used in the calculation of the ArP cap is because it is believed that the attacker's level affects the maximum amount of armor that can be penetrated. Hence, the armor constant for our level is used to determine the ArP cap.

Thus, both our level and the target's level factor into how much of the armor can be penetratable.

Here is another way to look at it. Say if there are two targets with the same amount of armor, but one is level 80 and one is level 83. One would think that we would be able to penetrate an equal or lesser amount of that armor on the level 83 target than the level 80 target since it should be harder to kill. If the armor constant for the target was used in the ArP calculation, then we would actually be able to ignore more of the armor on the 83 target than the 80 target as shown, making it easier to kill instead of harder.

If target's level was used in ArP cap calculation:
- Level 80 target with 10K armor results in 8411 ArP cap
- Level 83 target with 10K armor results in 8878 ArP cap

With using the attackers level to determine the armor cap, we ignore the same amount of armor on a level 80 and level 83 target with the same base armor; however, since level 83 targets will tend on average to have higher amounts of armor than level 80 targets due to the higher armor constant, more of the armor on average level 83 targets will be unpenetratable.

Last edited by Whitefyst : 11/05/09 at 3:44 PM.

United States Offline
Old 11/06/09, 1:24 PM   #3738
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Update:
- Critical strike chance capped at 0% lower bound and 100% upper bound now
- Changed default custom boss armor value on settings page to 10643.
- Glyph of Steady shot now active if you have at least 1 talent point in Marked for Death, rather than >1
- Using a Dragon's Eye for the full-hit gem will now correctly limit use to 3 dragon's eyes total, rather than 4.
- Item stats/drop location corrections
- Shot rotation test rounding issue hacked
- When using frequency based rotations, having 0/3 Lock&Load will no longer lead to a massive dps increase.
- Rabid proc adjusted to 30% as per EJ testing, also only procs of melee attacks


Offline
Old 11/06/09, 2:59 PM   #3739
Crydak
Von Kaiser
 
Orc Hunter
 
Mannoroth (EU)
Link shows still 92B as latest version (typo I guess)

Offline
Old 11/08/09, 11:13 PM   #3740
wasnt
Glass Joe
 
Night Elf Hunter
 
Madoran
I recently got Treads of Dismal Fortune (linked below). They are leather and have expertise on them. When I try to load from Armory I get a debug error (Invalid Procedure Call or Argument). I figure it's due to the expertise, not sure.

[Treads of Dismal Fortune]

Just wanted to let you know.

Offline
Old 11/09/09, 11:44 AM   #3741
Whitefyst
Great Tiger
 
Orc Hunter
 
Draenor
Please ignore. Sorry.

United States Offline
Old 11/09/09, 1:03 PM   #3742
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Just to stave off more PMs, my ISP is moving their servers and you won't be able to download the sheet until wednesday.


Offline
Old 11/10/09, 7:50 PM   #3743
Bechamel
Glass Joe
 
Dwarf Hunter
 
Kargath (EU)
I tried for two weeks, but I cant load the gear for a raid-hunter, only his talents: Takata / Kargath / EU / 80.

>> runtime error '91' "Objektvariable oder With-Blockvariable nicht festgelegt" <<

any ideas?

Offline
Old 11/12/09, 4:05 PM   #3744
Whitefyst
Great Tiger
 
Orc Hunter
 
Draenor
If you have the time and inclination, I would like to propose calculations in the spreadsheet for Volley damage. Like for our other standard shots, it would be nice to see the average non-crit and crit damage as well as the average damage per hit. Furthermore, it would be nice to have an option to select the number of targets in Volley and see how much DPS results (or maybe a table instead with 1-10, 15, 20 targets). This would be useful for making decisions for progression fights that require us to do a lot of AoE instead of single target attacks. Volley still would not need to be part of the shot rotation choices. This information would be separate from the shot priority information, although it could be displayed in the reference table.

United States Offline
Old 11/12/09, 4:37 PM   #3745
alienangel
Bald Bull
 
alienangel's Avatar
 
Draenei Hunter
 
Eredar
Volley DPS values in the same spreadsheet are slightly misleading though, since a lot of the averaging of procs and talents we have in the sheet don't apply when we volley - trinkets other than greatness/death'sverdict don't proc while volleying, master tactician doesn't proc while volleying, replenishment (and I think thrill of the hunt too) don't proc while volleying. Gftt at least does proc though, so your pet's DPS isn't hurt.

Getting volley to show on the Calculations or shot rotation tab would be nice, but it would probably need to be based on not averaging AP/crit effects from most trinkets and procs (I've tried periodically interruping volleys when master tactician drops for instance and firing shots till MT procs again, it's unreliable enough to not be easily modelled in the sheet IMO). With that caveat though, a row showing your volley dps per target (DPS, not damage per tick, since haste affects volley dps without affecting tick value) or per N targets would be great for gearing decisions in situations you know you'll have to volley. I would go so far as to say the DPS number should be shown on the Gear tab itself, so you can easily see it change as you swap gear.

This brings up the issue though that I have no idea how exactly Volley damage and tick-interval is calculated. Has anyone worked out a formula for it?

Canada Offline
Old 11/12/09, 6:28 PM   #3746
Dellimore
Glass Joe
 
Night Elf Druid
 
Arathor
wondering, is it beneficial to stack 2 8.5 vs 4p t9, i didnt like the set bonus for T9 nearly as much as i like 2 piece t8

Offline
Old 11/13/09, 9:39 AM   #3747
Argg0
Von Kaiser
 
Troll Hunter
 
Warsong
About Volley, I think it's similar to other chanellings. At 0 haste, it would deal 1 hit / s (6s cast duration, 6 hits) and reduce the interval as haste increased. Like:

Tick interval: 1 / (1 + haste%)
So, at 20% passive haste it'd be 1 tick every 0.833s, with a total duration of 5s, which matches with me using Berserking.

Ah, and, sadly, Ranged Haste doesn't apparently affect Volley. At least Rapid Fire and IAotH proc doesn't, while berserking does.

Last edited by Argg0 : 11/18/09 at 12:02 PM.

Offline
Old 11/13/09, 5:09 PM   #3748
Namarus
Don Flamenco
 
Orc Hunter
 
Demon Soul
Originally Posted by Argg0 View Post
The spreadsheet exists exactly to solve this kind of doubts... but, anyway, I'd say neither, go for better solo pieces.

About Volley... I think it's similar to other chanellings... At 0 haste, it would deal 1 hit / s (6s cast duration, 6 hits) and reduce the interval as haste increased. Like...

Tick interval: 1 / (1 + haste%)
So, at 20% passive haste it'd be 1 tick every 0.833s, with a total duration of 5s... which matches with me using Berserking.

Ah, and, sadly, Ranged Haste doesn't apparently affect Volley. At least Rapid Fire and IAotH proc doesn't, while berserking does.
Got a shaman to put down Wrath Of Air, and it lowered my volley channeling time. So Volley is affected by spell haste.

Offline
Old 11/13/09, 7:14 PM   #3749
sefren
Glass Joe
 
Night Elf Hunter
 
Uldaman
The other day I decided to recheck my dps and fiddle around with the spreadsheet to see how certain talents would work for me. To my amazement it is now saying that dropping Arcane Shot from my rotation nets dps. The reason i say this is that I don't use an arp trinket, I don't gem arp and I have even specced into Arcane Shot. All this being said it still is telling me that Arcane Shot in the rotation is a dps loss. I looked over parses from some raid fights and its showing that Arcane hits for about 300-500 more on average than Steady Shot. Also the spec I'm checking out doesn't pick up IMP SS so I have no idea what is going on. Is there anything I'm overlooking or did Steady somehow miraculously beat out arcane shot at some gear level?

Offline
Old 11/13/09, 9:58 PM   #3750
Cinderglow
Von Kaiser
 
Cinderglow's Avatar
 
Orc Hunter
 
Frostwolf
Originally Posted by sefren View Post
The other day I decided to recheck my dps and fiddle around with the spreadsheet to see how certain talents would work for me. To my amazement it is now saying that dropping Arcane Shot from my rotation nets dps. The reason i say this is that I don't use an arp trinket, I don't gem arp and I have even specced into Arcane Shot. All this being said it still is telling me that Arcane Shot in the rotation is a dps loss. I looked over parses from some raid fights and its showing that Arcane hits for about 300-500 more on average than Steady Shot. Also the spec I'm checking out doesn't pick up IMP SS so I have no idea what is going on. Is there anything I'm overlooking or did Steady somehow miraculously beat out arcane shot at some gear level?
It's the value the bleed that the steady shot yields if it crits, that makes it better than Arcane Shot.

Evoke the fire within.

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