Its because the enchant is not really a dps enchant, which would be pointless to put into a dps spreadsheet. Lots of people (including myself) have it for some fights in ulduar so I'm sure a lot of people get this error, just hit ok and continue =)

This correct, it has been renamed with 3.1, which is why the sheet doesn't recognise it.

Does the spreadsheet version chimera shot assume that serpent sting is always up? Because when I do "test rotation" it never has a "serpent sting" line in it regardless of whether serpent comes before or after chimera shot in priority list. But when I switch the two the DPS changes.

Another question, I did not look into the implementation (I have no clue where macros in excel are), does the spreadsheet use a quick heuristic function to evaluate DPS every time I change an item or attribute, or does it actually test the rotation?

Update:
I took VRoscioli's suggestion, with a tweak. I think personally that the planner should compare the listed items against what you have equipped on the Gear tab, which is what this change should effect for dual-wield vs 2-hander.

It's very hard to make the Gear Planner values match exactly with the dps increase you see in the sheet elsewhere because the averages that are calculated aren't quite constant. I still have some digging to do with the Gear Planner where it concerns +hit which is likely the biggest culprit.

I've been attempting to use this spreadsheet as much as possible, however, I have a Vista system (which runs MS Office 2007). None of the embedded spreadsheet tools seem to function when I run this file in compatibility mode. I've been digging through the forums to see if anyone else is having difficulties in order to find the fix, but as of yet, have not been able to.

Anyone have a working MS Excel 2007 version of this spreadsheet? Thanks.

Feature request:
An ability to filter gems on the Gear tab to only show gems that match the socket color, as well as a setting to hide JC only gems, and also a setting to hide gems that are not yet in-game.

Pretty please?

Related question: When gems are sorted by DPS, does this take into account socket bonuses for the items?

You can already sort on color and there's an option to show only matching colors on the Settings tab.

When gems are sorted by DPS it means the pure stats on the gems only. Socket bonuses aren't considered (since the gem doesn't know what item it gets put into in any case).

A couple of quick feature requests.

1. Is it possible to associate toon level with the gear profile in some way or at least have pulling gear from the armory update the toon level the way it updates the race? I imported a 78a file into 78c - which breaks btw - and after re-pulling my gear from the armory had a screen full on #n/a until I realised I hadn't set the level in the overview tab.

2. Is it possible to associate glyphs with either talents or gear. As the spreadsheet will now load both primary and secondary specs and toon glyphs are now tied to those specs, it would make managing different specs easier as well. This may have been mentioned a few pages back but I don't recall you commenting on it, Shandara.

And while I'm being demanding, now that the pet skill selectors are smart enough to automatically select pet special & focus dump, would it be possible for the pet tree logic to include some additional validation. For example, while in theory Avoidance does not add DPS, its a required talent if you're going spec Rabid or Wolverine Bite so having just marked in red is misleading. Thinking about this further, Avoidance may be the only non-DPS talent for which this is true so maybe logic for that is all that's required. On a related note, why don't Great Stamina & Natural Armor have red backgrounds as well. Neither of them contributes to DPS except through enhanced pet survivability and by that logic, Bloodthirsty, Avoidance & Hart of the Phoenix also qualify (plus some others I'm sure).

Finally, as I haven't done this in a while: THANKS! This spreadsheet is invaluable for me in making gear & talent choices and building gear wish lists, and I for one deeply appreciate all your work on it, Shandara.

Are you using v87c? It was working properly when I uploaded it and I just checked my local copy to make sure.

So why does the spreadsheet show that if I switch the proirity of black arrow and explosive shot, the same exact DPS is attained? Is it taking into effect the 6% extra damage on all attacks from black arrow? Because if you fired a black arrow before an explosive shot in a situation where you had to decide between the two, you could end up getting part, if not all, of a 3rd explosive shot being effected by the 6% extra damage from the black arrow. Where if you fired explosive first you could only 2 1/3rd (assuming the last 1/3 of the one fired before) shots effected by the 6% increase.

What do you think of adding weapon DPS (maybe this should be changing min and max instead) and perhaps even weapon speed +/- as hand adjusted settings, along with stats? Presumably this would enable the CalcAttributes macro to obtain values here as well. I realize this would run the risk of having a lot of columns in the Gear tab, but surely this is more important information than strength and spirit.

I've noticed other class spreadsheets normally include this value and would love to see it for hunters - especially because I suspect that unlike other classes, our weapon damage is much closer in value to our stats.


Edit: I actually played around with custom gear to see if I could calculate the value of adding 10 weapon DPS. Min=343, Max=613, Speed=2.9, DPS=(343+613)/2/2.9=164.8. That's roughly 10 more DPS than the Envoy I otherwise had in there. This yielded about 32.5 DPS, or 3.25 per weapon "DPS". This is better than my agility value of 1.359 by a fair amount, but not the massive rift that some physical classes see where 1 weapon DPS is worth about 9 str. Not sure if this is interesting to anyone else in the slightest, but there you go!