Base mana is the mana you would have before any gear or buffs. There is no way you have 14K base mana.

As a level 80 Dwarf I have 6101 base mana and yet Rank 10 Mend Pet only costs 454 mana (9% of 6101 is 549, so no idea where the extra mana went to, as I have 0/2 IMP).

That means that each point in IMP will save me 45.4 mana. 2 points for 90mana/cast which is a ridiculous waste of 2 points.

So basically your point is right (not really that useful) but your math was wrong, making it even LESS useful than you stated.

Just keeping you honest

I wanted to check how would a Wolf fare in a raid without BoM and BShout... but it hasn't been implemented apparently.

I tried leaving wolf with just Furious Howl to see how much my and his dps would increase.

His DPS lowered (since less bite were used) and mine was unchanged. Shouldn't mine increase a bit at least?

I have been able to reproduce this, but using a Wolf and clearing all buffs properly makes dps increase when I use Furious Howl. One bug I did find though was that it doesn't purely check whether BoM or BShout are present. The toggle is any +AP buff (which includes food).

This is obviously not how it works in-game (it should stack with food and such). Will be fixed next release.

Would it be possible to sort the gems list by rank, like the gear lists are sorted in the drop downs? It doesn't sound like this would be too hard since they're just items with stats like the gear.

Socket color of course wouldn't need to be taken into account by the sorting, just the highest standalone gems would be on top, and we could try the various ones in each socket manually to see what works out best.

Would make finding the gem you're looking for a lot easier too, since you'd generally be looking at only the top 5-6 choices on the list, instead scrolling through an alphabetical list of dozens of gems you don't care about just to look at the highest available rank of delicate, shifting, glinting, rigid, smooth, vivid or jagged.

Apologies if this is already possible and I've just been missing it.

Microsoft Works is not the same as Excel - no macro support, no real VB capabilites. You're going to have to upgrade if you want to use the spreadsheet.

ah ok, thanks. what a pain in the butt, since i saw what it looked like and how helpful it looked, im definitely going to have to do this now.

It always has been

Going back to your discussion, filling out all DPS and required talents on the lower part of the BM tree you will get to this specc: Talent Calculator - World of Warcraft

You now need to put 3 more points to get to the next tier. From all talents available, 2/2 BD is still the best available, because no matter how the Spreadsheet tells you that 1/2 BD and 1/2 GftT is enough to keep your pet full Focus, as Faerdael pointed out the GftT focus regeneration is averaged.
On real fights, you will have crit streaks (wasting focus) and critless streaks (starving pet) but on average it seems like your pet have full focus. Also when you need to move, you stop shooting, breaking your crit "sequence".
On both situations above, BD regeneration will be ticking anyway helping filling up the gaps.

On conclusion, the debate if it's a DPS increase to take 0 or 1 point in BD instead of 2 is a moot one, because there is really nowhere to put them when you want to get to Tier 6 of the BM tree, so it's not really a choice.
The debate if you should go 1/2 or 2/2 is a valid one, since you can use that point to put on a DPS increase talent, unlike BD points.

Shandara,

Small mistake on the Pawn String for Dwarfs and Trolls. The semicolon before IsGun or IsBow should be a comma.

I find your reply to this highly misleading. Now that I actually have the card, I can confirm the proc does scale with kings and if it scales with kings I don't see a reason why it wouldn't scale with LR and CE, although I haven't tested those two so I'm not going to make unfounded claims.

Confirmed, at least in 3.0.9 DC:G agility proc does scale with lightning reflex (i.e. +345 instead of +300 unbuffed).

While trying to find the highest (single target) DPS Tenacity pet, I came across an oversight with the Boar's pet ability, Gore.

The tooltip describes the ability as doing double damage if used within 6 seconds of a Charge, however speccing in or out of Charge on the doesn't affect the damage calculated on the spreadsheet. Neither is there any way to add Charge to the pet's priority list.

So is the bonus damage from Charge automatically calculated with Gore, or is it ignored?