I'm unable to find how to apply the Mixology buff from Alchemy. Has this been implemented?

I just want to start off by saying THANK YOU! for this most excellent hunter tool.

I would like to make a suggestion. Please add a second profession box in the "Overview" tab. I have both mining and skinning maxed, but I can only enter the buff for one or the other at the moment. The way I am spec'd, each of the buffs gives me between 5 and 10 DPS, so it would be nice to see both of them included in the final calculation

Also, after going through the "Gear" and "Talents" tabs many times to verify the information was the same (or close as possible) as my armory read out, I have found that ~5% crit is missing from my character's "Overview". I used the "Import from Armory" option in both cases. For now I have added the "Leader of the Pack" raid buff to compensate, but it would be nice to know if this is an internal error in the spreadsheet, or just me doing something wrong! This much crit missing does affect the calculations of the "Gear Planner" by a fair margin, where gear may be misleadingly ranked higher than current equips, when it should actually be lower!

And finally, is it possible to include the "True Shot Aura" buff like we include the AotDH buff in the "Shot Rotation" tab? Or is there some other way to turn TSA on that I have not found yet? I am currently using BoM to compensate for the AP difference.

I am sorry if some of these have already been answered and I did not see them. Over 50 pages is a lot to parse through!

To add some more to what Fierra said, not only will haste directly increase dps through more auto shots (even after steady shot haste is capped), but it will indirectly increase dps depending on talents. The more shots you fire, the more benefit you gain from chance-per-shot mechanics like improved Aspect of the Hawk (greater uptime) and Go For the Throat (more regen). Haste is not like hit rating -- the benefit doesn't stop once you hit the cap (which is why we refer to it as a "soft" cap sometimes).

You can use the "hand adjust" row at the bottom of the gear tab to add the skinning or mining bonus, if you like. The missing crit is likely because of the new-in-wrath 4.8% crit depression all physical dps classes are seeing against boss-level mobs. If you have talented Trueshot Aura you automatically benefit from it. If you have someone else in your raid providing it to you, you can use the line on the buffs tab that says "Trueshot Aura (not yours)."

No it hasn't. If you want to see the effect of it, you can add the stats by hand in hand adjust row in the gear tab. It's at the bottom of the page, in blue color. You'd have to figure out how much benefit mixology is giving to the elixirs you are using. For [Flask of Endless Rage], it's 64 ap increase if I remember correctly. This can be used to add blacksmithing bonuses as well since you can have 32 agi instead of 64 ap.

Are Leggings of Failed Escape ranked higher than Valorous Cryptstalker Leggings because they are bugged? I notice they have a significantly lower delta.

The 15 sec CD of Serpentsting is not changing in ShotRotation if Glyph of Serpent Sting is used.

Explosive Shot is a major part of Survival damage so the accuracy of its frequency is quite important for the accuracy of the calculated dps.
Currently without Lock and Load the spreadsheet assumes a rotation of Explosive Shot with 3 gcds in between which means a shot frequency of 6s + 4 times latency, 6.4s with standard settings.
But that is only correct if you are at the soft haste cap which many survival hunters are not. If you are below the soft haste cap then Explosive Shot is delayed by any Steady Shot with more than 1.5s cast time that you fire. That can change the Explosive Shot frequency by up to 10% in extreme cases and it undervalues haste a bit.

Thank you for the input. I will use the workaround for the 2nd profession buff, but I still think it would be a little more intuitive for users if a second field was worked in on the Overview tab.

Is the 4.8% crit reduction a bug? Or is this Blizzards way of trying to make the game a bit more challenging?

The TSA buff in my case was not being applied. I have double checked this against my in game numbers. Before TSA and AotDH I am sitting @ roughly 3970 AP. Add AotDH in the Shot Rotation tab, and AP goes up to ~4200 and stops there. In game with TSA active I am seeing ~ 4700-4800 AP. I tried using the "Trueshot Aura (not yours)" buff, and it did not adjust anything. I have also turned TSA off all together in the Talents tab, with no effect on the numbers.

Also, is LnL supposed to affect DPS on the spread sheet? I have LnL talented, and I wanted to see how points in LnL adjusted DPS compared to Killer Instinct or Expose Weakness. Putting points into LnL does not seem to have an effect on the DPS at this point (using spreadsheet version 82 downloaded yesterday).


Thanks guys!

Servers are down so it can't be checked ATM, but during my raid last night it seemed as though Rapid Fire, Bestial Wrath, and Kill Shot are all off the GCD.

Did you make sure Abominations Might/Unl Rage isn't on? They don't stack, so adding TSA to that would provide no benefit. I just went into the spreadsheet and turned off Abominations Might/Unl Rage and turned on TSA and it provided me with the correct amount of AP.

Yes, I do all of my work in the spreadsheet with the buffs empty. I turned on BoM to simulate what my numbers should be if TSA was on. Where exactly did u "turn on" TSA? If you are referring to turning it on in the talents tab, it does it automatically when I import from Armory, and I always double check to make sure it is on.

Anyone have an idea as to this and some of my original questions in my post a few back?

I don't think that's a bug. I think buffs are handled separately to profiles and you have to save them with the save buffs button. My guess reasoning is that profiles can cover many specs and to be honest, most specs are pretty much going to have the same buffs, since the rest of your raid is the same, and most of the time you'd use the same Elixirs / Flask.

It looks like this is just a display bug; everything seems fine on the RotationTest tab and damage definitely varies between using this glyph and not using it.

Why is Shifting Twilight Opal --> Tenuous Twilight Opal on the spreadsheet? It seems that MP5 would be a minor addition to DPS while stamina would offer zero yet the spreadsheet displays more DPS upon the selection of the shifting gem.

Do you have points in Hunter vs. Wild? That would grant AP from the stamina on the shifting gem.

Edit: Nvm to slow

It depends on gear and spec. Stam converts to AP for specs that include Hunter Vs. Wild, is multiplied by Survivalist and of course Blessing of Kings.

Specs not including those talents (or gear severely short on Intellect) may well see a higher DPS boost from the agi/mp5 gem.

edit: You guys are fast. Delete if this is deemed a redundant waste of space.

Thanks very much everyone. I still don't intimately know every talent in the SV tree and hadn't even considered that.

I'm still BM & according to the spreadsheet, with my gear, the best DPS I can get is with the following talents:
WorldofWarcraft.com -> Info -> Classes -> Hunter -> Talent Calculator. MM & SV show up as better DPS in the spreadsheet when unbuffed, but in 10/25 man raids BM is better. According to the spec others are using SV is the best so what am I doing wrong that the spreadsheet doesn't show it?

Just wanted to say thank you Shandara for putting the time and work into the spreadsheet. It's just great that you've added Taiwan into the server selection. It makes my life much easier just using the armory import. Thanks again!

What you are seeing may be correct. The issue with pets is that as they double dip in raid buffs they start out very high. Truly they have been nerfed but if you are low on the gear scaling, the pet scaling from raid buffs may become the dominant factor.

What particular numbers are you seeing for personal and pet dps numbers for each spec? That should lend a fair amount of insight without making anyone plug your gear and talents into the spreadsheet themselves.