Rabid and Call of the Wild should show as 0dps on the rotation panel because they don't in and of themselves, do damage. Those abilities increase the damage of the OTHER abilities. If you remove either CotW or Rabid from the rotation, the DPS of the other abilities correctly goes down. The reason you have them in the rotation is that on live, they initiate the GCD meaning that reduces the frequency of the other abilities which we have to model.

But that reminds me: Call of the Wild, as per patch notes, no longer is on the GCD on the PTR, so you could just average the AP in. I've posted a bug that Rabid is still on the GCD because as per patch notes, its cooldown is greater than 30s so it should be off the GCD too.

Thank you so much, I was working on the spreadsheet so fast that I didn't realize it then. So as long as the upper left hand box is not filled with zeros it should be ok. To clarify the box that has base dps, claw dps, family skill dps, and kc dps.

No, as there is no one wanting to do that job (porting all macros/scripts/etc).
@Shandara - maybe you should consider putting larger info about OO version in first post?

Two things I was wondering if there were plans to implement in the future:

1) On the settings tab for type of potion, any chance to get a modeling for Potion of Speed (haste)?

2) The staffs that are currently known as "Druid Staffs" are having their stats changed. Any plans to implement the changed staffs into the 2H weapons? After putting the changed Journey's End in as a Custom Weapon, JE comes out as the best 2 hander in the game.

I also have 2 random questions.

First, about the combination of the Bestial Discipline and GftT talents as modeled by the spreadsheet. As of now, if you have 2/2 GftT to get imp stings, changing BD to 1/2 or even 0/2 makes zero change in dps. Would this be true in a real in-game situation? I am honestly not sure why this would be this way.

Second, what is the required hit for a Lvl 83 raid boss for hunters? It used to be 9%, has it since dropped to 8%? I saw on the settings tab the option to select either 8 or 9 % but being as confused on this topic as I am, I have no idea what to select here.

Its 8% now, is it bug or not - i dont know, but it so right now.

2/2 GftT generates 50 focus per crit, and you pet can't spend that much in a single GCD. If your crit rate is high enough, and you are firing shots fast enough, it's possible to crit often enough so that you generate more focus than your pet can spend, particularly when combined with its natural focus regen. In that case, increasing passive focus regen won't add anything.

Hey, I found 2 little errors in the spreadsheet:

1) Cower lists as having a focus cost of 25 instead of 0.

2) The statistics for Deadly Gladiator's Chain Leggings do not match those ingame. The spreadsheet says it has 100 stamina and 50 intellect, while it has 115 stamina and 34 intellect ingame. There's also something off with the agility bonus on them. The spreadsheet assumes a 12 agi bonus when socketed with the right gems (after testing, since it does not display this?), but this is displayed ingame as a 6 agi bonus. When removing the leggings and putting them on again, while looking at my agility, I discovered that the bonus seems to be +18 agi. Either that or I'm getting 12 agi "for free" by equipping the leggings.

This sounds like your meta gem becoming active when you have the leggings on.

Yes, the spreadsheet models it. If you mess around with gear levels and talents, you'll see that for some gearsets, you will gain from having both (you have low crit) and with others you don't need to max both, and with others you only need to max one. It's even possible to only need one point in GftT and that's it. If you had 100% crit (impossible, currently) then you would generate 25 focus every GCD *plus* every auto shot (weapon speed) *plus* natural focus regen. Your pet would be swimming in focus. But this varies a lot based on your own gear, buffs, and even the encounter.

The last part about the encounters is important. This is one of those points where everyone will have to step back from the spreadsheets just for a second. GffT doesn't generate any focus if you aren't shooting. If you are doing a fight where you are moving around, misdirecting, laying frost traps, etc., then BD's natural regen boost is helping you even though the spreadsheet might not show it. If you hop over to do battleground PvP or Wintergrasp, and your pet is off chasing things that you aren't shooting (or aren't critting because of resilience) then BD will help. When dual spec comes this may be less of an issue, as you can switch to a PvP spec, but for now some people may benefit from both even if the modeling predicts a bit of overkill.

EDIT: a very rough rule of thumb, however, is that assuming you have opportunity to shoot frequently and have respectable crit, GftT is a better return than BD. I hesitate to say that though, because it is just a rough rule.

I notice that the Glyph of Serpent Sting in the spreadsheet is giving a flat 10% increase to steady shot, but in practice can we really guarantee that every one of our steady shots is going to land while the sting is still up? Glyphed, it lasts for 18 seconds, so subtracting the GCD from the sting time a BM hunter can fit in exactly 11 steady shots. Is that last one actually going to hit with the sting still counting? I don't know how much lag and travel time fit into this, but I'd guess that more often than not we will only have 10/11 steady shots landing while the sting is up (since it is never, from my understand, beneficial to refresh the sting before it falls off) for BM and 9/10 or 10/11 for Marks/Surv, depending on haste.

I realize this is probably unrealistic to model, but perhaps a 9% increase to steady shot will be more accurate in more situations...

Would it be possible to include the updated hunter-friendly stats from the feral staffs that are being changed in the upcoming patch?

This is an area where people have to use their own judgment on how to interpret the spreadsheet. Someone out there might claim that they always do keep serpent up for every steady, so 9% would discount them too much. For others, 9% is still too generous.

There is so much that the spreadsheet can't account for that trying to incorporate skill checks into it would make it far too unwieldy. It's good that you brought it up as something for people to consider, though.

I understand this, and I see the calculations (on the Pet Calculation tab) for Focus regen, but I'm having some difficulty modeling Focus drain via attacks, and the optimal order DPS-wise for the attacks (plus Growl, for soloing) given their Focus costs and cooldowns.

This seems to be confirmed by the following calculations from the spreadsheet:

At 29.3% Crit and 1.02 shots/sec I get back 29.86 Focus/4 sec (of SHOOTING time as you point out) from 2/2 GftT, and 24 Focus/4 sec (all the time) from 2/2 BD.

Since BD works passively as well, and I will likely shoot fewer shots/sec than optimal, it seems like it is about a push for now in terms of which is the more efficient Focus regenerator - until I get my Crit up where it should be. But knowing my expected optimal Focus drain/4 sec (which with auto-attacking likely would be almost calculation-perfect) would help me to know when both talents are necessary and when I will have too much of a good thing and can start pulling points out of them (likely out of BD first, as you say).

You probably don't have to try to model it specifically. Just set the "priority" for the pet attacks, which usually should be family special followed by focus dump, under the "pet" tab. If you use Call of the Wild or Rabid, you set those as higher priorities. The spreadsheet will do the rest. If you have a family special that doesn't do damage, or isn't always used, remove it from your pet's "rotation."

Once you have your pets abilities and rotations set, and your own rotation, gear, buffs and the like, then you can directly see how much dps you gain or lose at various points by adjusting talents and tinkering with builds, like you did before. I just do a "sanity check" when I've changed a lot of gear or got a different raid setup to see whether I need to spec out of one or the other. Sometimes it's moot, as I don't have an acceptable place to move the points anyway.

While checking out survival in the spreadsheet I noticed that the item budget cost of Stamina is wrong (in the dps increase per item budget on the overview tab). Stamina is cheaper than 1 rating or other stat since TBC.

I'm wondering, is there any way to work out what the 4-set Tier 7 bonus is worth in DPS terms?

It seems to me that wearing all the best in slot items turns out better than the set bonus, but it would be nice to see what the bonus is worth by itself.

That's the 2-set, Onouris is thinking of the Haste in Viper bonus. Which is obviously a little harder to determine.

What is the "Ranged Weapon" button for in the gear planner?
Maybe you could add the answer to the faq.

The Ranged Weapon button calculates the DPS and orders ranged weapons on the gear planner. From what I understand, they are calculated separately because the calculation is much more complex and timely than armor pieces so it is done manually instead of automatically, which keeps the spreadsheet moving quickly.

Any chance we could get a new version with the following PTR changes?

Differenced between v80 and PTR:

• Aspect of the Beast doesn't double dip
• Unleashed Fury is 3% per rank (15% at 5/5 rather than 20% at 5/5)
• Glyph of Serpent Sting is now 6s
• Scorpid Poison uses the normal magic damage scaling (~4.3%)
• Rake initial hit uses 6% of pets AP (DoT component still uses 7%)
• Explosive Shot uses 18% of hunter AP (not sure about the fixed part)
• Call of the Wild and Bestial Wrath are off the GCD
• Arcane Shot costs the same mana as Steady Shot
• Improved Tracking now affects DoT damage (if you are tracking the target)
• Aspects are on the GCD (feels like 1s)

Also, since Surv hunters are looking at dropping traps to trigger LnL, you may want to model adding a trap in to the shot rotation somehow.

Update:

I seem to have a problem with the new version of the sheet. In all cases it shows the 10 man t7 as being better for me than the 25 man t7. This makes no sense at all, and it is not a small difference, it's around 60 dps on each piece.