It seems that with 5 minute fight duration glyph of AotH is performing way better than glyph of serpent sting.

I've always wondered if AotB during BW's is higher dps than full time AotD. Only problem is that there's no way to tell as spreadsheet doesn't have such function so I'm wondering how hard would it be to make an option which would use AotB during BW's and AotD when not? Aspects are off GCD now so that won't cause any extra complexity.

This is with 50/21 and scorpid btw.

And also Shandara, if you just happen to find the time to do so, would you mind unlocking the cells for Hand Adjust of pet dmg, pet crit% and pet AP?
I've always kept my T0,5 gloves, 3-piece AQ20 set, and Leggings of the Beast Mastery (for stupid experiments and sentimentality, mainly), and I don't think your items database still got them in.
Thanks.

I'm not sure if this has been mentioned yet (i read back about 5 pages and did not see it), but [Grotesque Handgrips] do not have a socket or socket bonus in the spread sheet.

Misc. comments on the 78e version:

- the +200 health chest enchant is missing (I know, some are wondering why a Hunter would have this...I only have it because a friend who is leveling up enchanting put it on me).

- not all the new food types are there (e.g. the +30/+40 critical strike food made from worm meat).

- shouldn't there be an Expertise in the Attribute part of the Overview tab, so we can see how much we gain from it, DPS-wise?

- it would be nice to toggle 25-man raid gear on/off in the Gear Planner section

- when using the Gear Planner, it isn't taking into account the gems when recommending upgrades. For example, in one of my profiles it says the Drake-Mounted Crossbow does about 9 more dps than the Nesingwary 4000. But when I remove the Nesingwary 4000 (which has a crit/agi gem in it) and replace it with the Drake-Mounted Crossbow, the DPS is the same (because, apparently, the gem that was in the Nesingwary 4000 is now gone becasue the Drake-Mounted Crossbow does not have any gems slots).

Suggestion:

With all the time Ive spent in the spreadsheet theres really only 1 thing I feel it's missing - a comparison between dual wielding and equipping a 2-hander.

If there is some way to show all 2 handed upgrades when youre dual wielding and all dual wield upgrades when you have a 2 hander equipped that would be infinitely helpful.

As is when we have 2 1-handers equipped 2-hand dps is shown as 0, so basically it just shows you the top 10 2 handed weapons in game with no regards to the 2 weapons you have equipped, and vice versa.

not sure if this is possible but if it is, please add it if you can.

Thanks!

Expertise does not do amything for hunters unfortunately.

As for the Gear Planner, it does account for gems but it uses the default gems set on the Settings Tab. These may not be the ideal gems for an item though. You can customise them with the custom values fields next to them.

A 10/25-man toggle is in the works for the next version.

There are some tests done that show that expertise doesn't transfer to the pet.
While they are not conclusive (none of them were at expertise cap and showed pet still being dodged/parried), they have large enough sample to be pretty convincing.
You can find some of those tests in hit rating post, where they discuss whether FA talent transfers to the pet.

As for the gems and gear planner, I'm under the impression that it doesn't account for the gem slot.
My gear planner shows that Pack-Ice Striders is about 40dps higher than Boots of the Great Construct.
However, when I swap in Boots of the Great Construct, I gain about 36dps.
(With Pack-Ice Striders, I'm at 6160.73, with Boots of the Great Construct, socketed by default gem, I'm at 6196.85, and with Boots of the Great Construct not socketed, I'm at 6102.04.)

Do you have a meta that's on or off based on that socket?

Alright, I know this has been asked before (probably by me a year ago) but here goes...

My absolutely mediocre gear shows up as approximately 2500 dps in the spreadsheet yet I have been getting consistent dps in the 1500-1600 (10 man raid buffed) range. Is this due to the mobs armor or my ineptitude? I generally do steady spam and pop rapid/bestial wrath when they are up. I will admit that my cat only got level 80 today and I haevn't raided with it yet but that isn't going to make up the 1k difference...


(And yes, I am aware that my gear needs enchants)

Well, the difference between a non-buffed hunter and a fully buffed (and debuffed target) hunter is ~2000-2500dps, so since you said 10-man raiding, I'd check that you, your pet and the boss are getting all the buffs/debuffs the spreadsheet thinks you're getting.

Valorous Cryptstalker Legguards adds no socket bonus even if the colors match.

The Sons Exalted Greater Inscription of the Axe isn't supported in the spreadsheet.

Also are you planning on adjusting the hit rating to 8%? If you are leery about it, maybe an option in settings? It's really hard to use the spreadsheet as is.

Titanium Weapon Chains

These were added as a supported enchant, however, the +28 hit was not added. Spreadsheet is calculating my +hit to be 179 when it should in fact be 235.

*edit* One more question: I picked up my 2nd piece of T7 gear last night to get the 5% damage bonus, loaded this into the sheet and checked the results. I then changed my gloves and my shoulders to get the 4 piece bonus and checked the results. I am confused by what i saw. A 20ish dps decrease?

I know that my current shoulders are amazing, Beast-tamer's Shoulders, but I figured that the amount of time I would save myself from Viper would make up the difference. Can you point me to the calculation for time spent in viper? Is the spreadsheet considering aspect changes? Better yet... does the gear planner think ahead and take set bonuses into consideration when ranking upgrades/downgrades?

When I try to load my gear from armor, I get "Run Time error 91 - Object variable or With block variable not set"

Try again... usually that error is caused by the armory, not the spreadsheet.

I've gotten the error about 10 times now across several days of trying :-P

It only has problems being imported from the armory. After the error pops up, just hit ok and then click the drop down menu on your shoulder enchant. It will be there, and it works. This is still a bug though.

Working with the buff tab seriously for the first time - i usually evaluate everything unbuffed - I discovered a rather serious error with version 78e: the pally buff items on this tab are all still TBC based.

Imp might is now 2 levels: 12% & 25%.
G BoK is no longer a flat 10%. It's 2% base with four levels of Imp BoK that give you 4%, 6%, 8%, 10%.
There is no provision for Swift retribution, which gives 1% haste increase.

Also, is Judgement of Wisdom in the target debuffs supposed to be the same as the Judgement of the Wise ret pally talent?

EDIT: I also forgot to mention that there's no provision for Fel Intelligence, the felhunter buff.

I'm sure you've been keeping on eye on the thread on this in these forums, but just in case I'll mention that it appears that now the hit cap for hunters and their pets is only 8% instead of the traditional 9%. There are a few people who have gone full raids with 8% hit and no points in Focused Aim without a miss, and earlier today I tested on a raid boss targeting dummy for 2565 Auto Shots, 294 Steady Shots, 1689 pet melee attacks and 1558 pet special attacks with zero misses on a boss dummy with 8.05% hit and no points in focused aim.

Going to test that 8% hit comment that was just made to confirm... that's very interesting and messes up my gear choice....

The way you calculate the AP from Careful Aim is wrong. The formula you use is 33% of int per talent point which means you're using 99% of int with 3/3 CA, but it should be 100% with 3/3.

I tested the aspect switch extensively a few nights ago. Unfortunately I didnt save my recounts. When I just let my pet or scorpid attack with no influence from me, and I popped BW and switched aspects, both pets did upwards of 200-300 more dps with AotB on over AotD. Ill do the test again tonight and post the results.