The spreadhseet already saves your shot rotation when you click on 'save profile' on the gear page. I use the profiles mechanism to consider different build options. Load my default gear & talent tree from the amory, save that as one profile, select a new profile from the drop-down on the gear tab, make any talent changes etc and save again. Then when I want to compare between the two just load the relevant profile and fiddle appropriately.

I will let shandara comment on the idea of a default shot rotation associated with the use of a 51pt talent.

This may have been answered once (or more) before, but over the most recent few pages it has not:

How do I get the naxx-25 ranged weapons to appear in the gear planner for ranged weapons? It's quite obvious which weapons are the best, but out of complete curiosity I was wondering how much more dps [Arrowsong] (my current equip) is than the lesser weapons, as well as the increase that KT's gun (my future weapon *cross fingers*) would give.


Thanks in advance for the help, and CONGRATS on this amazing spreadsheet, it has helped me gear up so much faster and effectively than constantly researching wowhead etc etc etc.

Also may have missed this but assuming i have 100% hit from gear (no focused aim) and then I select the option to assume 100% hit wouldnt the gear planner change? removing gear with +hit on it for better itemised equipment?

This is not happening for me. Basically when I change assume 100% hit to yes and resort i get no changes with the current version (81a)

I am Samba on Gnomeregan if you'd like to verify stats/gear

*edit* Ok I just read a post 1 page back having the same issue but that particular person had 3/3 focused aim, so more hit on gear would in fact be a DPS increase due to pet hit scaling. I however am hit capped from gear and have 0/3 focused aim, yet the results do not change.

Hello everyone. This is my first time posting, though I am an avid reader. There's something that's somewhat bothering me, however, and I can't quite dig up an answer for it. Shandara's spreadsheet is showing me that dual-wielding 2x Major Intellect (or Exceptional Intellect) is pretty much the best enchant I can get for 1-handers. It boggles me that the +26agi and Accuracy enchants are providing less DPS than +45 intellect. Has anyone else noticed this, or am I missing something? Below is a link to my armory.

The World of Warcraft Armory

You most likely don't have any buffs selected, which means your mana regen will be non-existant, hence your viper time will be quite large and so the larger mana pool from the Int makes a big difference.

Fully raid buffed, Mana won't be a problem anymore, so the value of the int buffs will be alot lower.

I have Shandara's pre-built Level 80 Raid buffs all loaded, so that's not the issue. Have you not noticed this?

Hi.

First off, I would like to thank every one that is involved with the spreadsheet, in particular Shandara.

I am a MM hunter, trying to deal with viper uptime, or better yet, trying to find ways to reduce it as much as possible. With this principle in mind, I am really looking into the cunning family of pets, and I will be doing some tests in the next few days in regards to feeding frenzy and roar of recovery.

Before i get started, I would like to confirm that with the latest version of the spreadsheet, no longer do we have the option to change the health % of bosses, and that there is no way to factor in applications of roar of recovery, since there is no change to viper uptime on the Aspect Usage box under shot rotation.

It would not be a simple "take 30% of the viper uptime, add to hawk" since that extra time spent in AofH will trigger additional ImpAofH, further influenced by possible gylphs.

If this has been talked about before, some one please point me to the right direction, I could not find it.

You can find most settings on the "Settings" tab, including boss health percentage.

EDIT:
The next release will have Roar of Recovery and Wolverine Bite scaling with pet AP (anyone has any numbers on this, it has proven difficult to test accurately).

Someone can correct me if I'm wrong but the 100% assumes 8% hit on the hunter while pets require 9% hit to be capped.

The "Sub-total for Stings" in the Hunter Damage Adjustment calculation is still not giving the benefit of Improved Tracking, which is assumed to be the behavior on the PTR. This post suggests that it is getting it already, despite what the tooltip says.

Yes, I've noticed it too, although as someone else said the +45 int enchant hasn't made it into the game yet. You would get 90 RAP from the int enchants, as opposed to 52 from the agi, and at least at current gear levels AP generally edges out agi for BM hunters because of the additional benefits to pets. You also get 1350 mana, which translates to quite a few extra shots before having to dip into Viper. In order for +agi to surpass it, it would have to make up for the several thousand points of additional damage these shots would cause each cycle. Additionally, the extra mana means you recover more from abilities that replenish based on max mana (like invigoration, which you have), which also increases the time you can spend in Hawk before running out of mana.

Keep in mind that switching to Viper is a hefty penalty for you -- you lose 390 AP, your pet loses 22% of that, you lose imp. hawk haste, and you take a 40% penalty to your damage. If you're doing 2000 dps, a mere 10 second difference in Hawk v. Viper uptime would be 8000 damage just from the Viper penalty, without even accounting for the lost AP, etc.

One last thing is that the spreadsheet assumes a longer fight time (6 mins I think) so longevity gets weighted more. If you adjust the fight time to be less than your predicted "time to oom", then you should see how things stack up against each other in situations where you don't use Viper at all.

I think you're a bit confused on how hit transfers to pets. It appears to only transfer in whole numbers, rounded down. So if you have 7.99% hit your pet gets 7% and if you have 8.01% hit your pet gets 8%. So for this reason it's better to be slightly over the cap than under, but the cap is still 8%...

Shandara,
Thank you for all of your hard work on this. I do have a question though, would it be possible to unlock the gem assumptions on the spreadsheet? I think I could get a more accurate read out of the gear planner if I could get it to assume that all sockets get 32ap gems rather than having to match color. What leads me to this is that the eaglebane bracers consistently rank very high on my list but swapping out the other bracers and adding 32ap to any sockets usually shows a dps increase. This may not be possible though as it would screw with the socket bonuses of the gear for the gear planner.

this is exactly what I thought. With that in mind my original "bug" still remains. The gear planner does not update when going from "assume 100% hit" to not assuming 100% hit, when it should change.

I don't know if anyone else agrees with me, but I find guiding through the gem menu to be very time consuming, is there a way to remove gems from the big list that I would never use, like +int, mp5? Also, I'd love to see rankings for gems and echants in the gear planner menu.

Thanks for all the hard work.

I have some numbers using a level 80 Chimera against the heroic testing dummy on the PTR. Dummy was low health, so feeding frenzy was active, and ferocious inspiration procced as the pet crit, of course. Pet AP was 1408, Spellpower was 448. The "min" numbers may be a bit off because I messed up and went into viper during the test, which would have lowered the pet's AP. Test ran approximately 5 mins.

Hello Shandara,

I've spoted a mistake on the gear list.
You've misspeled "Jagged Dagger Pendant". It should be "Jade Dagger Pendant" instead.

And a big thank for your work on Cheeky's legacy

On the Delta +/- dps column on the gear planner, are gems assumed to be filled based on default gems in the settings tab? Or is that the ungemmed delta?

Hrm, it may be just me but I find it odd that its trying to tell me that Nerubian Conquerer is better than Envoy of Mortality >_<

I noticed that its because on my spreadsheet it shows 0 stats for Envoy, same for Final Voyage.

Mega Mammoth Meal is missing 80ap 40stam

Default gems in the settings tab


Shandara, a couple things I would put on a wish list:
1. What about adding weapon damage/dps to the Calc Attributes section?
2. It would be interesting if the talent tab showed a delta between adding/removing a talent point for the DPS talents. I realize this would probably take a lot of work and a complex macro...

Also, is there any reason that the sheets are locked except to prevent user error? There are times when I wish I could tinker around behind the scenes a bit.

It doesn't look like Glyph of Rapid Fire is taken into account on the shot rotation model.

Excellent spreadsheet tool btw...but Ima sure u know that already