Sorry for the like 2 day response time >.> been very swamped lately

Ok so I feel kinda dumb here since I couldnt figure out where exactly to make this change, but only because in the validity options window for a cell, the only section you could type in was like INDIRECT(Gear.$AC$10) - and for some reason this didnt click (working on stuff late at night bad)

So for anyone else who might be brain malfunctioning like myself, just erase that and =Gems in the box.

Thank you =]

If I remember correctly, sharpening stones will no longer work for ranged Crit next patch.

You do realize the weapon buffs are already modeled, don't you? They are hidden in the "Buffs" tab. I list the weapon names, and there are drop downs for the possible buffs, including stones and oils.

Spellsurge seems like a really, really bad idea for a Hunter. Do our shots or Kill Command even count as spells for the purposes of triggering it? (I know shot casts are possible through silence, but KC isn't.)

(Sharpening Stones will have to be removed with the changes in 2.2)

Quick note for Open Office users - the ammo cell has the same problems gems do, changing the Validity to =Ammo fixes it

I'm using version 27 straight out of first page.
Violet signet vs. correct data

A few things of note for v27:

The Load button on the gear doesn't seem to work fully, it won't load back previously saved trinkets.
Haste Rating in this version is 10.51:1, not PTR's 15.7:1, correct?
How are scorpids handled on the pet tab? It'd appear the current form isn't represented as the pet dps is fairly 'normal' levels, but interestingly enough scorpids still appear to dps cats, ravagers, and wind serpents.

And if it hasn't been said multiple times already, thank you for such a fantastic tool =)

I've run into a problem where the definition of a range is exceeded by the number of items, enchants, and gear cells. So I left trinkets out, since they are the easiest thing to reselect. I'm going to see if I can work around this though, it's annoying to me too.

Haste is still based on live stats, like everything else is. The Beta version has been updated. I'm going to release when PTR goes live (which doesn't look like this week.)

I do a complex set of calculations on Scorpid Poison. It's all based on the average RAP of the Hunter, and I also average out the effects of Beastial Wrath on it. Even just taken at non Trinketed and BWed values Scorpid Poison is an incredible DPS ability, far out of line with all other pet specials. I was going to provide the Poison totals as well for max trinket usage and BW, but it seems moot now.

You are welcome.

Recently I read the discussion on TKAsomething forum about the proc rate test of Don Santo. The autoshot only test by Cheeky over 5000 shots shows 7.6% proc rate. Another auto+steady shot test by donsantos with 20000 shots shows 3.95% proc rate. There is a huge difference between two test results. The major uncertainty coming from no UI is able to record proc while the santos buff is up. So I decided to start a test with the proc rate monitored by myself.

Here is my test setup. Each time I have only 150 ironbite shell on my character. Then I use 1:1 auto steady rotation shooting on lv 70 Void Conduit in Netherstorm. I am using a shot rotation macro so I can concentrate on monitoring my buff icons. After I run out of ironbite shell I will feign death and record how many times the buff is up (including refresh). I also record other information recorded by RECAP. This includes how many times the buff is up (not including refresh), buff average duration, combat time. Then I reset Recap and head to vendor for buying another 150 ironbite shell. I finished 36 set of 150 ironbite shell tests, total 5400 shots. My talnet build is 41/20/0. With 15% quiver my autoshot speed is 1.96. During the test I keep viper aspect. This test is performed on Taiwan WOW Onyxia server with patch version 2.1.3. My ping is around 100~150ms.

Here are my test results:

(1) Proc rate

Santos' Blessing manual record proc times every 150 shots:5,5,11,8,7,7,5,3,12,7,4,8,7,4,11,8,6,8,8,8,2,11,8,5,4,9,7,10,4,5,6,5,11,2,14,8

Santos' Blessing manual record proc 253 times in 5400 shots

Proc rate = 4.69%

(2) Estimated Up time

Santos' Blessing RECAP record Duration Counts every 150 shots:
5,4,6,6,5,5,5,2,6,4,4,3,4,3,5,5,5,5,5,5,2,8,6,5,1,5,6,4,2,4,4,3,7,2,6,4

Santos' Blessing RECAP record Duration Counts 161 in 5400 shots

Estimated 'Buff up' time every 150 shots = Duration Counts(By RECAP) * Estimated Average Duration(By RECAP)

Estimted total 'Buff up' time = 2090.8 Sec

Total combat time = 5376 Sec

Estimated percentage of 'Buff up' = 38.89%

(3) Theoritical Up Time

Assuming 4.69% Proc rate

Total time for shooting 5400 shots = 5376 Sec

Shots per second = 1.004

Shots in 10 seconds = 10.04

Theoritical percentage of 'Buff up' = 38.26%

(4) Auto shot only test

I also run two 1600 Shots auto shot only test. No manual record for times of proc.

Santos' Blessing RECAP record Duration Counts every 1600 shots:
59,70

Santos' Blessing RECAP record Duration Counts 129 in 3200 shots

Estimted total 'Buff up' time = 1507.1 Sec

Total combat time = 6283 Sec

Estimated percentage of 'Buff up' = 23.99%

Shots per second = 0.509

Shots in 10 seconds = 5.09

Theoritical percentage of 'Buff up' = 21.69%

(5) Discussion
(a) Assuming 4.69% proc rate, the theoritical percentage of 'Buff up' is quite close to percentage of 'Buff up' estimated from RECAP for both tests.

(b) Manual recorded auto+steady shot 4.69% proc rate seems reasonable compare to 3.95% from donsantos' test. But RECAP recorded auto shot 4.03% proc rate is far below 7.6% from Cheeky's test.

(c) For the auto+steady shot test, 2082 autoshot hit, 620 autoshot crit, 2083 steadyshot hit, 615 steadyshot crit. There are 2 more autoshot than steadyshot due to lag spike during test. None of the 5400 shots miss.

(d) My original test target is Dr. Boom. This spot is close to Area 52 so I take less time to travel back for buying 150 bullets. But I notice he occasionally turns towards me, causing some shots being partially blocked. Without knowledge whether block or miss affect santos proc or not, I decided to test on Void Conduit which won't block.

(e) Assuming 4.69% proc rate and knownledge of shots per second, I am curious is there anyway to estimate 'how many proc while buff is up' and 'how many proc while no buff is up' theoritically? From the results of 5400 shots test, There are 92 procs while buff is up and 161 procs while no buff is up. 36.36% proc is not able to be recorded by RECAP.

We use JoW, JoC (talented), and JoL in most fights. Having a retribution paladin makes it pretty feasible.


Nice work peter.

Hey Cheeky, I noticed a few things are incorrect in the pet calc tab.

Glancing blows are still wrong, glancing rate should be ~25% and damage should be reduced to 76%.

I also don't see you doing any resist calculations for LB. 17% of all LBs should be completely resisted and all mobs have an innate 24 resist to all schools that cannot be overcome in any way. It amounts to ~5% partial resists.

LB can also crit, it seems to pull it from the 10% crit talent. Spells crit for 150% damage.

See Loading... for an example.

Excel: http://www.havoc-guild.us/Cheeky/Hunter_DPS_Calc.xls
Open Office: http://www.havoc-guild.us/Cheeky/Hunter_DPS_Calc_OO.xls (Validation fixes for gems and ammo)

Change Log:
- New gear ([Mantle of Perenolde], [Shard-bound Bracers], [Madness of the Betrayer])
- Gear corrections ([Boneweave Girdle], [Belt of Deep Shadow], [Clefthoof Hide Quiver], [Worg Hide Quiver], [Blackened Leather Spaulders], [Chestguard of the Conniver], [Bladed Shoulderpads of the Merciless])
- Updated Glancing Blow mechanics for Pets. Only L73 mobs can be glanced, and it is at a 25% chance for 76% damage. (6% effective reduction of melee DPS)
- Fixed a bug where Kill Command was not counting pet Hit/Crit rates (Thanks Aesa!)
- Added checks for Metagem requirements. Currently this only applies to the 2nd socket of the Helm gear item.
- Added a simple model for Madness of the Betrayer, based on a 1.5 ppm for the effect. This model is not as accurate as the 4 piece Beast Lord set, since I average the result, which is slightly inaccurate since armor is not a linear effect.
- Now properly handle Resilience socket bonuses on head items.
- Added a model (developed by Sayeth of Gorgonnash at TKA Something - A World of Warcraft Hunter's Resource) This model determines the averaged gain of the trinket based on the benefit per stack, and your time spent at that level of stacking.
- Added benefit of averaged out Bestial Wrath to Kill Command Damage if specified in the Settings and Results tab.
- Reformatted sheet to better display information users are interested in.
- Changed hit mechanics to work off of 0.1% chance to hit penalty for the first 10 points of difference in weapon skill vs. defense, and 0.6% for more than that. This results in a base miss chance on level 73 targets of 9.0%. These number have been confirmed by extensive testing by members of Elitist Jerks, most notably Olgas for Hunters.
- Added in Crit % and Resist (both full and partial) for Lightning Breath ability. This is still a work in progress.

As always comments, criticism, ideas and insults are always welcome.