No clue how I could have missed that. Thank you so much!

You must be mistaking CD and Cast Time. Steady Shot has a 2sec base cast time with no cooldown.

I'm assuming your reading this from the shot rotation tab. The cooldown column in the table isn't strictly referring to the in game cooldown, it's just the time between when you would like to use that shot (the final result may not be this ideal time), i.e. Serpent Sting has no cooldown in game, but for the purpose of shot rotation it has a 15 second cooldown, because you won't use it before the previous one expires. I guess it could be worded better but I don't think its really necessary.

Shandara - are the new ArP calculations confirmed?

Judging by what you've done, the ArP from buffs has no cap, and then the cap is calculated using the remaining armor, the gear ArP then picks the minimum of the remaining armor and the cap.

This is opposed to calculating the cap based on the units base armor, and then both buffs and gear ArP picking the minimum.

Also I posted a while back in this thread a description of the LnL # of shots replaced is exactly 1.5. I guess you may not have agreed however it would be good to get it added as an option if anything.

EDIT: On the Pet Calc tab, it is still counting Blood Frenzy as 2%.

Sorry I did mean cast time instead of cooldown and looking at the rotation test page I see the cast time on Steady Shot is 2.3s which I assume is taking my latency into account then as well.

I changed a piece of armor now and see the default gem selected on all colors is Delicate Scarlet Ruby (16 Agi) where in the past it would try and use the best gem per color. I know we can change it manually just mentioning in case it is in error.

Ok thanks, those posts are a bit over my head, but I'll take your word for it.

Also another thing I noticed was that the base agility from your race is not affected by kings/talents in the spreadsheet, however it is in game. Intellect is in the sheet and is in game. Stamina isn't in the sheet and is in game. Probably similar inconsistencies for the other stats.

EDIT: Hunters mark is affected by CotW and TSA, don't believe its this way in the spreadsheet. Pretty sure its the same for Expose Weakness, although I don't have a spare hunter around to help me test it atm.

EDIT: The tooltip RAP includes the average from the Agi proc from Greatness I believe, so won't match.

EDIT: MFD should affect Arcane Shot crit damage also.

EDIT: Your piercing shots calculations we're a lot different to what I was seeing in game, I've had a look at them and I believe for Steady Shot you've found the DPS and then multiplied it by 30% again, the other 2 appear correct.

EDIT: Furious shotgun and furious rifle have their stats mixed up. The shotgun is supposed to be the better version.

EDIT: Can't see a lot of whats happening because of the protection but I think your CrittingShotsPerSecond may be set up so that it thinks auto shot has 100% crit rate.

EDIT: MFD is increasing pet specials damage by 10% in the sheet, only supposed to be 5%.

Just a typo check:
- on the Talents panel, when I use the "Read from Armory" button, the DualSpec warning pop-up window reads "You have Dual Specialiation".

Although I did some research I couldn't find anything helpful on the topic so I'll just ask here:
The spreadsheet seems to assume a 100% global CD usage, but for me that is suboptimal because that will delay my explosive shots (which contribute a lot more to my DPS than SS) which I want to keep on CD as much as possible. I'll try to illustrate this. "ES (1.5), SS (1.5), SS (1.5), SS (1.5), ES" would in theory make perfect use of ES as it isn't delayed at all. However I'm not at the softcap for haste and even if I were there is still button delay and latency. Testings on a dummy showed me that my dps was consistently higher when I actually used ES, SS, SS, ES so I'm not using all my GCD but instead wait a bit. In the sandbox scenario that is the spreadsheet and the dummy it would thus constitute no difference in DPS if my SS cast time was 2 seconds instead of ~1.6 seconds as I'd still have to wait the same amount of time for my ES which would mean that the DPS contribution of Haste below the softcap would (in the spreadsheet scenario of me dpsing a boss without taking damage or moving) not be higher than the DPS contribution from haste over the softcap unless I reach a breaking point where it is actually worth delaying my explosive shots (and I'm not even sure if there really is one, which is probably depending on your individual latency).
So my question is: Has any research been done on this? If the problem I described actually exists would it be possible for the spreadsheet to account for it? Or am I doing something wrong here because this problem seems so obvious to me that I can hardly imagine it to be an oversight. Actually I just noticed this seems to be fixed with the new version of the spreadsheet as Haste below the softcap is valued a lot lower for me now (almost the same as over the haste cap).

Firstly, the spreadsheet does allow the modelling of a single SS interleaved between ES during LnL in the settings tab, even though it is optimal to wait 0.5seconds past the GCD of each ES. There's really no reason to shoot a 2nd SS because ES damage > SS damage AND there are no ticking ES dots that will be overwritten which is the main reason someone would weave SS in the first place.

What it comes down to is that you're basically prioritizing a lower damage shot (SS) based on anecdotal "consistently higher dps".

Just to clarify, here's the timings of your rotation:
0 - ES
(1) - ES dot ticks
1.5 - SS
(2) - last ES dot ticks
3 - SS
4.5 - ES

It's been calculated previously that the optimal LnL usage is:
0 - ES
(1) - ES dot ticks
(2) - last ES dot ticks
2 - ES
(3) - ES dot ticks
(4) - last ES dot ticks
4 - ES

Hey rez. Hes not talking about interleaving though, or LnL at all for that matter. He means changing:

0.00 ES
1.50 Filler (1.5s Steady Shot)
3.00 Filler (1.5s Steady Shot)
4.50 Filler (1.5s Steady Shot)
6.00 ES

to:

0.00 ES
2.00 Filler (1.6s Steady Shot)
3.60 Filler (1.6s Steady Shot)
5.20 Nothing
6.00 ES

For modelling.

Ah, outside of LnL it comes down to your preferrence since at haste cap, ES would be available at arguably the same time. I think there was a calculation floating around of longest time to wait in order to not delay ES.
Here's a post discussing how to calculate how long you should delay in favor for ES:

Do you run the 'calculate attributes' after changing things? The standard build in the sheet is SV and that has the talent to get AP from stamina.