ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Hunter DPS Spreadsheet
2
Many thanks go to the following people: Cheeky, Lactose, Ravenfire, Chul, Indora, Wertez, EJ board posters and TKASomething board posters!
3
4
By Shandara (EU-Azjol-Nerub) - Formerly by Cheeky of Havoc
5
6
VersionDateChanges
7
115/1/2007 - Original version from post-patch 2.0.1 - Never released.
8
226/1/2007 - Added support for socketed equipment
9
 - Added in common Hunter-use gems from Thottbot
10
 - First pass at Hunter-use items from The Burning Crusade
11
 - Modeled Steady Shot
12
 - Character stats and health for levels 61-64 for Troll - from in-game testing
13
 - Added custom-modeled shot rotations
14
 - Added in Hunter-useful enchants post-Expansion from Thottbot
15
 - Added in dynamic weapon skills
16
 - Added in Ammo filtering on ranged weapon class
17
 - Finally added instructions, and generally got this in shape to be released to the public
18
37/2/2007 - Added in additional items from Thottbot and Kaliban's Class Loot Lists
19
 - Changed Improved Aspect of the Hawk to be modeled as a average speed increase to Auto shot and Steady Shot cast times. (No effect on Global Cool down.) Still not sure if this is a good way to model this, but I can't think of anything better….
20
 - Learned enough Visual Basic to add in a Reset button for the shot rotation to ease testing various combinations.
21
 - Re-worked Shot Rotation to include proc Trinkets and Berserk. (need more information to incorporate other racial abilities.)
22
 - Troll stats for levels 65-67 have been added. Crit/Agility and Crit/hit rates updated for levels 65-67..
23
 - Expanded Shot rotation to 50 entries
24
 - Added in mana totals, regeneration, and cycle length times.
25
 - Added in code to clear gems when gear changes (only works on Excel 2003+)
26
 - Added in calculations for Master Tactician and Expose Weakness (self only). Expose Weakness is in the Calculations page so you can see what average benefit it provides to the raid.
27
 - Added in Thrill of the Hunt as an average mana savings to Arcane, Aimed, Scatter, Silent, Steady and Multi shots.
28
 - Added in Haste ratings for haste proc trinkets, converted all other speed modifiers to haste ratings. Since I only have the ratio for level 70, everything is treated that way.
29
49/2/2007 - Use the Improved Aspect of the Hawk uptime equation provided by Glau of the Hyjal forums. I then compute average speed increase to auto shot cool down and steady shot casting time based on this computed value.
30
 - Fixed a bug where haste & +AP effects from trinket/racials wasn't being applied.
31
 - Fixed a bug where 0 ranks in Improved Aspect of the Hawk counted Quick Shots as providing a +100% haste increase.
32
 - Added The Beast Within as a proc'able ability in the Shot Rotation
33
 - Validated Marksman abilities (True Shot Aura, Silencing Shot, Scatter Shot) against talent point allocation.
34
 - Now turning off Aspect of the Hawk turns off bonuses from Improved Aspect of the Hawk.
35
 - Added in drops from Karazhan.
36
 - Modeled Auto Shot to have a 0.5 second cast time. This behavior has been seen by many Hunters in game due to interference with Steady Shot casting. I take 0.5 seconds off of the cool down for Auto Shot as the start time, and use a cast time of 0.5 seconds. In pure auto shot cycles this has no effect on time or damage calculations.
37
52/3/2007 - Allow any type of gem in any slot, while still checking for set bonuses correctly.
38
 - Add in faction-based shoulder/head enchants.
39
 - Changed calculation for Steady Shot Damage to be (150 + RAP*0.2 + (Weapon DPS * 2.8)) this is different from the tool tip, but in accordance to latest Hunter math from Lactose of www.ElitistJerks.com
40
 - Added in breakdown of damage by shot type.
41
 - Added in racial abilities for non-Trolls as if they progress at they same rate as Trolls.
42
 - Added in stats for level 68-70.
43
 - Added in loot from Gruul's Lair
44
 - Added in ability to select mob level and indicate Boss mob
45
 - Added in calculations to the chance to hit factoring in higher level boss mobs.
46
 - Added in Fel Skin crafted set pieces.
47
66/3/2007 - Added in Scryer/Aldor/CE rep enchants to shoulder and head slots.
48
 - Factor in weapon skill rating properly.
49
 - Only support level 70 for DPS calculations.
50
 - Added in Hunter desirable items from Heroic instances.
51
 - Add in all known scopes.
52
76/3/2007 - Added in math for Don Santos Famous Hunting Rifle, factored average +AP seen based on a 5% proc rate and the specified shot rotation
53
820/3/2007 - Added in math for Mark of Conquest with a 8.4% proc rate on all shots.
54
 - Corrected some item stats that were incorrect. (Wrathfire Hand Cannon being worst one.)
55
923/3/2007 - Added in Orc racial Blood Fury
56
 - Added in Draenei race
57
 - Added in Blood Elf race
58
 - Updated some racial base ability scores.
59
 - Added in Assassination Armor (Rogue D3 set) based on request.
60
 - Added in some other leather/mail gear.
61
 - Added in ability to specify the target's armor value to properly account for mitigation. I have no idea what values make sense here. I limit it to 0 - 50,000. All it does is show the point where Arcane becomes better than Steady Shot based on armor of target. Applies to Auto Shot, Steady Shot, Multi Shot, Silencing Shot, Scatter Shot, and Aimed Shot
62
 - Added in gem slot for Back items.
63
103/4/2007 - Fixed set bonus for Netherscale Armor.
64
 - Added in more leather items that work out nicely for Hunters.
65
 - Fixed socket bonus for all chest items.
66
 - Added in Pet DPS. This is still a work in progress. Bite, Claw, Growl, Gore, Furious Howl, and Lightning Breath are modeled. Credit for this effort goes to Aelfric, Aesa, Arcazua, Dhirken, and Rodondwa of www.TKASomething.com as well.
67
 - Added in Ferocious Inspiration as part of damage adjustments.
68
1111/4/2007 - Fixed a bug in computing base ranged attack speed.
69
 - Changed Frenzy calculations for pets. New calculation has been confirmed to be within 1% accuracy on uptime of Frenzy by Aesa of www.TKASomething.com.
70
 - Added in button to fill the shot rotation with Auto/Steady alternating.
71
 - Added in button to allow the user to provide parameters for a priority rotation.
72
 - Corrected logic in armor calculations from talents. Talents do not increase armor bonus from Agility.
73
 - Added in Tauran racial bonus to health.
74
 - Fixed several item errors.
75
 - Updated base Health/Mana totals to be more accurate.
76
122/5/2007 - Corrected bug in Expose Weakness math.
77
 - Updated Expose Weakness to 2.1 talent.
78
 - Added pet ability Cobra Reflexes.
79
 - Added in Kill Command on use for every Hunter Crit. (No global cool down) as per 2.1. The equations to determine the frequency Kill Command can be used were developed by Aesa of Haomarush via the TKASomething.com forums.
80
 - Added modeling for new Hunter's Mark mechanics. Since the point of this spreadsheet is sustained, average DPS I just use the maximum value of +440 RAP for Hunter's Mark.
81
 - Added armor mitigation to pet physical attacks.
82
 - Added in Gronnstalker Armor
83
 - Added Raid Buffs (with Talent adjustments) as a new page that allows a Hunter to see the benefits of differing elixirs/flaks/buffs to DPS/Health/Mana. Enforces the rule of 1 Battle and 1 Guardian Elixir or a single Flask. All stats are for 2.1+.
84
 - Added in Health/Mana Chest enchants.
85
 - Added Mob Dodge and Glancing Blow mechanics to pet damage.
86
 - Added in Survival Instincts increasing RAP
87
 - All pet data, level, and race sheets have now been hidden to reduce clutter as much as possible.
88
 - Calculations for Romulo's Poison Vial have been added.
89
 - Added in the ability to specify a lag or latency value for the shot rotation. This value is added into the cast start time of every non-auto shot.
90
 - Allow for no Aspects to be active.
91
 - Draenei get +1% hit bonus as racial ability.
92
 - Added a reset button to the talent page.
93
133/5/2007 - Added in Serpentshrine Cavern, Doom Lord Kazzak, & Magtheridon Leather/Mail drops.
94
 - Added in new gems from 2.1
95
 - Factored in mana use for Kill Command
96
 - Allow Kill Command to be turned off in Spell Values sheet
97
1411/5/2007 - Add in finishing shot choice to Shot Rotation. This is used for timing only, to make the shot rotation cycle back on itself. This minimizes the iterations of the Hunter's cycle in the Shot Rotation that need to be entered to achieve accurate DPS totals. This was Aesa of Haomarush's idea. The first shot is used, so that the cycle timing is as exact as possible.
98
 - Changed the way Improved Aspect of the Hawk has been modeled. Now the user can input separate rotations for both normal speed and Quick Shot speed. The spreadsheet then calculates Quick Shot up time and ratios the DPS, MPS and Shots per second between the twp based on the uptime. The normal shot rotation will not include any haste from Quick Shots, and the Quick Shots rotation will include haste effects as specified by talent points spent. The calculations for IAotH uptime are the work of Norwest at www.ElitistJerks.com
99
 - Added in weapon buffs
100
 - Added in Avoidance pet skill.