Would it be possible in a future version of the spreadsheet to add an option for triggering Kill Command together with Bestial Wrath as the glyphed + talented BW CD is only 12 seconds more than KC - My gut tells me it produces more dps if these are blown together rather than having KC go off everytime its off CD. Napkin math says we need a 5 minute fight to gain 1 extra KC from hitting it on every CD instead of waiting the extra 12 seconds and getting 50% more damage while KC is active.
Is this already being done, or are they averaged out / triggered asap when they come off CD?

The nature of the sheet doesn't allow for such 'conscious' decisions. Everything is averaged out.

Only a real simulation would be able to show how much (if any) dps is gained by triggering abilities together for added effect.

On the PTR right now, all ferocity pets are close on dps. The difference between #1 (Devilsaur) and #12 (Hyena) is 5%. I believe this is the goal Blizzard was shooting for. A cat is within 2.3% of a devilsaur and a wolf is only .5% behind the top spot. This is the total dps for hunter and pet. Cats,corehounds,and the spirit beast are essentially equal. A raptor is slightly behind a wolf. It goes like this according to numbers from the spreadsheet with 25 man raid buffs applied.

1.Devilsaur
2.Wolf
3.Raptor
4.Core Hound
5.Spirit Beast
6.Cat
7.Moth
8.Wasp
9.Silithid
10.Tallstrider
11.Carrion Bird
12.Hyena

Some of the funky item evaluations are coming from the fact that in it's current form when you first download the spreadsheet AP is extremely overvalued (hence Fury of the Five Flights becomes far and away the best). I have been unable to find a spec/build/glyph combo that maintains an AP valuation of 1.84 per item budget after hitting the calcattributes button. I believe this is also why marks was appearing so strong for some people. As a fan of marks, I wish AP was that valuable, but I'm guessing not.

Update:
I haven't been able to log on the EU PTR yet (servers) down, so I haven't been able to check if the other (possibble) ranks of Black Arrow are now available, but for those interested I've added the datamined rank 6 to sheet (it's currently set as rank 1 because of a sorting limitation in the sheet, and conversely the in-game rank 1 is called rank 6 in the sheet at the moment. Confusing I know).

I've added a pop-pup box for the Rotation Test if you've saved a profile with those settings and are trying to load it (so you can disable it if you don't want to automatically re-run the test).

I also feel that the rotation test gives more accurate results for GCD hungry specs like MM and SV, rather than pure frequencies.

Black Arrow isn't working properly with the latest spreadsheet. Damage calculations are done in the calculations page and damage displays under shot rotation but it doesn't seem to actually cast the spell no matter where you put it in the rotation.

If you have put Immolation Trap above Black Arrow, that takes priority and so it will use the Trap/BA cooldown for Trap.

Wild Hunt is now 40% Stamina, 20% Attack Power on PTR. =(

No new ranks of Black Arrow, yet.

Ahahahaha, I might be retarded. I completely missed the fact that the 85g spreadsheet was setup to automatically use rotation test results instead of averaged results.

Don't I feel the fool now :l

From a blue post on the forums today: "Armor Penetration Rating: All classes now receive 25% more benefit from Armor Penetration Rating."

This one is potentially big for making gear choices, any chance of a ninja-quick update to reflect the rebalancing of ArP?

Either way, much thanks for all your hard work keeping new versions of the SS coming as PTR changes flow in.

As pointed out, I'd uploaded the sheet with the Rotation Test Result setting enabled so if you make changes to the shot rotation, re-run the test or disable this option on the Settings tab.

EDIT:
I did manage to find a small bug involving Rapid Recuperation. I've uploaded a small fix with should fix the #DIV/0 errors.

Naturally they will be added, just waiting till they have a sizeable amount so I can add em all in one go.

Hmmm a have some problem with Aimed Shot and Chmiera Shot in the last PTR spread sheet version.

It justs fires off once and then never again (giving me a whoping 60 dps increase chen using chimera shot)
It just writes 0.00 in the frquency column.

And I have a DIV / 0 matter when I select the orc racial in the shot rotation.

downloaded spreadsheet again and started over. seem to fix whatever my problem was. =D

Small update:
Apparently the ArP change is bugged on the PTR now, so I've taken the most likely 'fix' for now (value of each point of ArP increased by 25%).

I have a quick question regarding the rotation test in the spreadsheet.
Does it calculate explosive shots as 3 tick or one big shot?
I think this actually makes a pretty big difference in how black arrow affects damage as well as the resourcefulness talent.

Explosive Shot damage is calculated as 1 big shot. For the purposes of the Black Arrow damage debuff this should not make a difference and I'm not sure what you mean by resourcefulness.

Interesting results with the latest spreadsheet. If i went BM instead of SV i'd loose 300dps on my hunter, but gain 1000dps on my pet. Does that sound right?

Have you made sure your shot rotations on the BM profile are correct?

I gain about 2000 pet DPS and lose about the same (ish) on my hunter when I have the correctly set shot rotations.

e.g. MM hunter - 5000 dps , pet 1000 dps
BM hunter - 3000 dps , pet 3000 dps

For 10 man content I'm seeing very competitive numbers for BM and SV with MM lagging somewhat. My figures from the sheet with my current gear, 10 man buffs and the appropriate gems, 'chants, and shot rotations for each spec are as follows:

BM-5079.83
SV-5086.38
MM-4833.58

There is a bug in the 10 man buffs for Sunders. It shows no effect from them when the buffs are loaded. You have to change the first box to yes. It shows something like rank 7 by default ,which isn't one of the choices in the drop down menu.

With my Boss fight gear and 25 man buffs, the picture changes.

BM-5180.78
SV-5669.92
MM-5313.03

I'm not sure what exactly is making things that much different.

10 man buffs basically has all the things BM double dips in. Might, 10% AP, Str/Agi totem. Pets gain those buffs and 22% of AP gained by the hunter with these buffs. Also, these are mostly AP oriented buffs. BM benefits the most from AP and SV benefits greatly from Agi. So adding Kings would make SV gain tons of dps while BM doesn't benefit as much, since you don't really double dip due to low pet stats. Also, other buffs, like 3% haste, doesn't help BM much while it's pretty decent for MM and SV. Basically, 10 man buffs are AP heavy and pets double dip on buffs that add static values to AP and stats, while % based, especially Kings, benefit the other two spec more (at least that's my take).

Bug 1:

The constant holding the average haste of the proc on "Signet of Edward The Odd", called SignetOfEdwardHasteBonus is added to the DPS1 (column AH) and DPS2 (column AJ) calculations for all the rings in the sheet. Note that the custom rings get about 8 dps from this even if they are empty.

Bug 2:

The SignetOfEdwardHasteBonus constant doesn't seem to affect the total DPS if "Signet of Edward The Odd" is chosen in the gear tab. Try creating a custom ring with the same basic stats (49 agi, 54 sta, +58 AP, 29 Haste) and switch between the two in the gear sheet. I find the total DPS doesn't change when doing so. The conclusion must be that the extra 32 haste rating from SignetOfEdwardHasteBonus isn't used when calculating DPS.

Sollution:

I change the haste stat value of "Signet of Edward The Odd" from 29 to 61 and delete the SignetOfEdwardHasteBonus constant from all calculations in columns AH and AJ. This means that the ring shows the wrong stats in the gear tab, but calculations for Total DPS in the gear sheet and Delta DPS in the Gear planner sheet look right to me.

Sidenote:

I have tried this in both v84 and v85, and I am puzzled why all rings except "Signet of Edward The Odd" in v85 have increased DPS1 and DPS2 values compared to v84. For example using my toon Agnot of Balnazzar EU, "Titanium Impact Band" calculates a 14+ DPS delta over "Signet of Edward The Odd" in v85 (using your standard v85 without my bugfixes to the Rings sheet). This furter widens the gap rather that reducing it, as should be the case.

In my "bug fixed" sheet the delta between the two rings should be that "Signet of Edward the Odd" has +1.82 DPS over "Titanium Impact Band".