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.

This is a bug. I was cleaning up formulas (removing spurious recalculations and such) and changed this the wrong way. It will be fixed soon (have some other fixes lined up for today). It should read =AutoShotBaseDamage*2

EDIT:
Re-Uploaded V89e fixing the Kill Shot issue.

EDIT#2:
This also included some code in the shot rotation that tries to decide whether to use/wait for a shot actually gains you dps.

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.

No there's no password to use. The settings your allowed to change are on the settings tab.

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.

Are you trying to change the locked 'default' values or the yellow, empty 'custom value' fields right next to them?

(This question pops up quite a lot, how can I make it clearer?)

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.

Good catch. Also looks like Mp5 buffs are broken.

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.

Did you "Test Rotation" after inputting the new shot priority? In my experience, we need to hit that button after most changes, but mostly in regards to new rotations and added haste effects/reduced CDs

Yes I did The shot also shows up in the rotation test tab as being used.

Something I noticed is that if you put "None" in the middle of your rotation, it will botch up the rotation test. I used to be able to do this i prior versions if i wanted to remove a shot (like silencing shot) from the rotation to test the change in dps.

Is it possible that Silencing SHot is being preceded by a "None"?

<post removed> Found answer through search.

Fixed the problem. It was an IBCAK error on my end.

Do anyone actually reach their theoretical dps taken from the spreadsheet in a real raid situation?

The spreadsheet tells me I should be doing around 7000 dps as survival but in a real raid situation for example in VOA Im not reaching higher then 5300 dps.

However unbuffed the spreadsheet tells me I should be doing around 3600 dps and when Im dpsing the bossdummy Im doing 3300 unbuffed so this value seems more correct.

Probably because in the dummie it only depends on how you manage your player, while in raid situation maybe someone isn't debuffing the boss properly, and other situational factors.

The spreadsheet models "Ideal" situations in a perfect world with perfect execution. It's highly unlikely that any human would be capable of achieving these conditions naturally, so it's expected to be below the theoretical amount. Also, as good as the spreadsheet is, it's far from being perfect which will also result in different results.

There have been a few times where I wanted to compare using a mana pot/taking more mana talents and using a speed pot instead. I tried to figure it out manually but completely failed. I would appreciate it if you could add speed potions or if someone could give me an insight of how to do it manually. No biggie if it is too much of a pain, just always on the back of my mind. I appreciate all your work on the spreadsheet, thank you.