It does this so it can use Rapid Fire twice in a row the second time too. It should be doing this at the start as well.

Use Rapid Fire, Readiness to reset CD, use Rapid Fire again once the first runs out.

Repeat ~180 seconds after.

I think I found 2 bugs in the spreadsheet:

1st: The values of the serpent sting effect on the Shot Rotation tab are too low. The problem is in the Calculations tab cell H163. It doesn’t take into account any talents. That’s only a display bug however the calculations for the damage done with chimera shot are fine.

2nd: The calculations for the pet talent rabid are most definitely wrong. The spreadsheet says that the pet should have 5 stacks of rabid 87% of the time. I looked through the logs of our last week raiding and a lot of times it doesn’t even reach 5 stacks before it runs out. And it’s not only my pet. It’s the same for all the hunters I looked up on WoL

EDIT
-----

So, I did a quick rabid test today. Here is the combat log: World of Logs - Real Time Raid Analysis

I went to the hero dummy with my pet, disabled all attacks but rabid, and let it attack for some time. Here are the numbers:

Pet attack speed: 1.54
# of rabid cast: 45
# of rabid procs: 166

So, my napkin math is that my pet was 900 sec under the rabid buff. In 900 sec it cast 585 melee attacks. And 166 procs out off 585 casts is a chance of 28.38%. I knew that’s to low because WoL don’t count procs that only refresh a 5 stacks buff but out of 45 rabid cast my pet only gets to 5 stacks 16 times.

EDIT 2
-------

I did another very short test and this time with bite active: World of Logs - Real Time Raid Analysis

I used the lvl 60 dummy so my pet gets enough focus from GftT. The results are very similar to the test above. Even so my pet attacked more than 2 times as fast as before it only get to 5 stacks of rabid 5 out of 12 times. So it seems like bite does not affect the proc chance of rabid.

Pet attack speed: 1.54
# of rabid cast: 12
# of rabid procs: 43

Napkin math tells me that the rabid buff last 240 sec. That’s time for 156 melee attacks. 43 procs out of 156 melee attacks is 27.56%.

If I had to guess I would say rabid only procs from melee attacks with a proc chance of 30%

If I start out with a "blank" Nightelf level 80. I.e. No gear, no talents, no buffs.

I end up with a negative Base Critical Hit Chance (-3,86% in cell Calculations!B42).

Shouldn't the lowest crit chance I can have be 0%. Negative chance for something to happen seems a bit odd.

...as a followup.

If I equip only the BRK-1000 gun... and chose MM talents so that I reach the Piercing shot talent (Talents!H column from 2 and downwards with spaces to mark tiers: 032 230 2300 32, 113, 23, 100 00 000 0 0)

I get -0.57 "added" dps due to having the Piercing Talents at Calculations!N147

Which I think is due to the negative Base Crit chance

It's because of the crit depression applied.

Note that hunters _do_ have a negative base critical strike chance, which is made slightly positive by the contribution from our base agility.

No, the targets level is 83. But the attacking "higher level mob" effect should only be a modifier that can get my overall crit % down to zero. Never below.

I may need x% before it's even possible for me to get a crit on a level 83 mob... but I can never have less than 0 crits.

Let's say that a very simple calculation of the damage made would be

TotalDamage = NormalDamage * (1 + CritPercent)

If I had a negative Crit % it would "steal" damage from my NormalDamage. Which would be odd.

The calculation in the cell should be something along with:

=IF( (SUM(B25;B28;B33:B40)+Overview!I27)<0; 0;SUM(B25;B28;B33:B40)+Overview!I27);

Forcing 0% to be the lowest possible value.

At the same time I don't think that this ever becomes a problem in any normal use of the spreadsheet since very few ever calculate anything with a char having such low crit values.

I was formulating my response while you answered.

And yes, I have no problem with Hunters having a negative base crit level... since everything you list and calculate before the bottom line is "modifers" and a modifier might have a negative as well as a positive effect.

But the bottom line crit chance cant be negative it can only go down to zero.

The effects otherwize becomes a bit weird as in the Piercing Shot case with negative dps effect.

Currently both the Sample SV and Sample MM spec are the MM profile, btw. I was confused why armor piercing and hearty rhino were being used as survival til I checked the talents, heh.

When looking at the code for the rotation test. Even though "The Beast Within" is not selectable as a "shot" in the shot rotation table, there is code on a couple of places that checks the table if the shot type is "The Beast Within".
e.g.
... If ShotTable(selectedShot, 1) = "The Beast Within" Or ShotTable(selectedShot, 1) = "Bestial Wrath" Then ...

Being "or" statements it has no effect on the execution but it looked a bit odd.

In the calculation sheet cell K21 There is the following to handle the Marked for Death/Glyph of SS bug.

... should it be >= 1 or >0 instead of the current >1?

Feature request:

On the Overview tab, would it be possible to allow "Haste to Cap" to show negative numbers
like "Needed to cap hit"? (I'd like to see how much over the haste cap someone is)


Edit: spelling