I've noticed a huge drop in Kill Shot damage in the latest sheet and I've tracked it down to a formula for Kill Shot base damage changing. I'm not sure exactly when this happened but I do know it was sometime between 89b and 89e.

Normalized Auto Shot (KilLShotBase) 89b:
=(EffectiveRAP*0.2 + AmmoDamage + RangedWeaponDamage)*2
My Displayed Result: 5158

Normalized Auto Shot (KilLShotBase) 89e:
=RangedWeaponDamage*2
My Displayed Result: 1023

Was this an intended change? I didn't see it anywhere in your revision notes.

The new spreadsheet will not calculate damage for chimera shot, silencing shot, or multi-shot for me.

Be sure to run the rotation test if you started from the default profile that's loaded. That or disable the rotation test on the settings tab.

Not sure if anyone else has this problem, or if I missed the answer in the 112 pages of replies, but when I try to change cells on certain tabs, it says it is protected, and password required to make the changes. Example, when I tried to change the shot rotation priority numbers, every cell said the tab was protected.

Any password or way to fix this? The password was required under the Tools, Protection section of Excel. Using Excel 2003, macro security set to medium, and not saved as "read-only."

Thanks.

Magnetized Projectile Emitter still has the wrong damage range.

Is it possible to add buff profiles, talent speccs and gathering skill to the export function?

Could it be, that HM is not working as intended on live server? Several tests showed, that only the hunter with the talent, the glyph or both get the improved ap and if another hunter, without any improvement, sets the mark, the hunter with the improvement benefits from the mark. (My english is bad^^)

Example 1:
Hunter 1: gylph + talent
Hunter 2: no glyph + no talent

Hunter 1 sets the mark
Hunter 1 gets 750 AP
Hunter 2 gets 500 AP

Hunter 2 sets the mark
Hunter 1 gets 750 AP
Hunter 2 gets 500 AP

Example 2:
Hunter 1: glyph + no talent
Hunter 2: no glyph + talent

A hunter sets the mark
Hunter 1 gets 600 AP
Hutner 2 gets 650 AP

I think this could be the reason, why the mark can be overbuffed by a not improved one.

Those settings, the individual variables, are the ones the spreadsheet won't let me change. It keeps saying the cells/sheet are protected, and to make the changes under tools. When I try to unprotect those cells it asks for the authors password.

I found an another bug.
If I turn off Hunter's mark (not mine) on the target's Debuff section, and I have 1 point in Imp. Hunters Mark, I have 7297dps.
If I turn on Hunter's mark (not mine, not talented, not glyphed) on the target's Debuff section, I got 7269dps, so I lost 30dps.
It seems the other hunter's unglyphed/untalented HM overwrites my talented HM.
I think this would be good if the greater HM would be in effect.

Edit: It would be great if we can choose not just Imp. HM and glyphed in other hunter's mark place, but IHM1, IHM2 too. (It would be really accurate.)

Did tested with another hunter on dummy. Tested 0/3, 3/3, 3/3 + glyph and it worked for other hunter in party.

Bug report: It appears as if ArP rating from food/elixir buffs isn't being counted in the DPS calc. When i switch from "None" to one of the mentioned buffs, I see no DPS change. The Gear tab isn't displaying any value in the "Additive Buff" row, so this might be where the issue lies.

Adding Silencing Shot to my rotation still does not change my DPS or affect my mana usage. I'd also like to concur with a previous poster that it would be really nice if glyphs saved with our talent specs.