Last i had checked, ArP was worked in on a Per-Shot basis. Meaning in the Aimed Shot calc, there would be an ArP effect factored in, but for Explosive Shot, the whole thing would be ignored. I figured the ratio would work similarly, you wouldn't apply it to the end result, but rather to each of the shots that are affected.

Edit: taking a look at the calc's again, it appears as if there isn't a variable for ArP factored into each of the shots, but rather the effective armor is taken into account when figuring the damage. Regardless, the ratio i propose could just be added into each of the shots that qualify as an adjustment.

Something weird is going on with trinkets.. I have the Greatness card equipped as my first trinket and the spreadsheet is putting it 68 dps below Mirror of Truth and below a bunch of other trinkets including the one from normal ToC, but for my second trinket (Mirror of Truth) it lists the Greatness card as a 70 DPS upgrade.

This will be fixed next version as I finally managed to track down the bug this morning.

I noticed that too, I had around 66% uptime in 91b and now 33.5% uptime in 91e. Was wondering where I lost that 100 dps in the import process.

I have no idea what a correct value ought to be, but my log reports suggest that 33% is about right. I don't know if there was a stealth fix or if I simply missed something in the change notes.

This caused me to go check my glyphs and figure out if Hawk was still the best choice with the lower uptime. Sure enough, Glyph of Trueshot Aura turned out to beat Hawk by a wide margin in 91e.

Chicken linked the post to me #3357 at 08/18/2009, but that post was regarding either v91c or v91d where the problem didn't occur. Also the estimated value (with basical maths) would be shotnumber*proccchance = proccs and with 360s/2.05shots per second and 10% procc it would be 17,56proccs. Cause Hawk improves itself and if we suggest a permanent improve by 15%haste (no glyph) we get something around 20,66proccs.

If we now take a binomial distribution and calculate the standard deviation for the "minimum" estimated value we get sigma= 1,2 ( 3sigma = 3,6), saying that 11proccs (uptime = 36%) is something out of our 99,9% range.

Logs are another thing, most time you don't face the boss 100% of the fight or you have to fight adds etc etc, reducing your hawk uptime. But in a spreadsheet, assuming a "perfect" fight 11proccs (and 36% uptime) are just too low.

I checked the shot rotation, it was the same (time and shot), I losed a bit (~200 "special" DPS) but over 300DPS through auto-shot damage (which was around 2800 and now 2500).

Update:

Using version 91f (the issue existed in the previous version, also), the base racials shown on the the Gear tab seem slightly off: for a dwarf Agility should show 184 (instead of 177) and Intellect should show 92 (instead of 89). This is comparing the spreadsheet to the armory and also in-game.

Strangely, this is 4% - the Combat Experience Marksmanship talent. I suspect this would be the same for all races? That is, it does not appear to apply the Combat Experience talent increase to the base racial statistics.

I'm possibly missing a setting, but just looking at the Gear tab, all the gear appears correct.

In older versions of the spreadsheet was an option "asssume 100% hit", where i can find it now ?

This function has been obviated by the advent of the regemmer, which can automagically determine how much of the hit on an item is actually useful.

You can get a similar result by going massively over the hit cap, for example by temporarily enabling 3/3 Focused Aim in the Talents tab, or adding a large amount of hit in the Hand Adjust row of the Gear tab. You'll have to Recalculate DPS after doing this, and ignore the Current Item with Regem lines (since the planner will try to remove any +hit gems or +hit socket bonuses) or disable regemming temporarily.

The gear planner does not work very well for items with a large amount of hit, which is why this feature is still quite useful in my opinion.
For example: with [Hoperender] equipped, [Lotrafen, Spear of the Damned] is not shown as an upgrade when one is just above the hit cap, because the lost hit points can't be compensated by simply regemming. By adding 2 points in FA it suddenly becomes a 94 dps upgrade, which is closer to reality (the actual improvement is likely less than that, since the +hit has to come from somewhere, be it other gear with more +hit, different enchants or by swapping talents to more FA).

When loading gear from the armory [Steel Bladebreaker] gives an error.