You added an option to save the shot rotation for different specs.
Could you please also add an option to save glyphs for different specs? Would help comparing things faster.

Thank you

Actually no, most of the spreadsheet will work fine in Mac Office. But pretty much none of the fancy buttons and import features will work- you'll need to put in your gear and spec manually. I tend to use the previous Office version more often because it seems to work better with the sheet (and isn't nearly as sluggish), but I think Office 2008 will mostly work as well. Recent versions of the spreadsheet do have a problem with the pet skills menu, I haven't figured out why, but the defaults are setup to work with a wolf, which is what most hunters are using these days so as long as you don't touch the pet skills they should be fine.

It is possible to use a Windows emulator to run the Windows version of Office if you have a copy of it, but I don't so I just make do with the current functionality.

I have been working on a web based version of the spreadsheet which should support most of the basic stuff (for now I'm leaving out the shot rotation test and just using the shot priority table, and I'm not sure if I'll get around to working on the gear recommendation features). It's not ready for public consumption yet but I'm hoping it will be sometime soon (currently working on pet support and I still need to track down some discrepancies between the spreadsheet totals and my totals but the damage output is pretty close to the spreadsheet right now). So hopefully soon there will be a good option for folks who don't have a version of Office that works well with the sheet.

The spreadsheet doesn't seem to have the +6 agi socket bonus registered for Gloves of the Steady Hand.

Recent versions auto-fill the pet rotation and filter it a bit. You can disable this behaviour on the Settings tab.

Hey Shandara,

Think I could convince you to add the new PvP trinkets? They are very easy to obtain and quite good until you get your lucky drops from raiding.
One of my hunters use Titan-forged Rune of Determination and Battlemaster's Accuracy depending on whether he's fighting trash or bosses. I can find neither in the spreadsheet, and the "try to import this from armory" usually ends up putting stats from one of my rings instead of actually importing the trinket.

Keep up the good work <3

Shandara, do you know what effect latency has on using shots that are on cooldown? I noticed that now you have the option of waiting for CS, which means CS is going off at exactly 10 seconds - is that possible? Can you pre-cast an ability on cooldown? I don't think the UI will let you? If it is the case, it'd mean you'd probably have to push back the shot by an amount equal to your latency?

Also, didn't notice the waiting option in the change log - when was it put in?

The trinket Meteorite Whetstone does not work I get some error about a circular reference. It bugs out my entire dps number.

Re-uploaded v89b with a quick fix for this (and Signet of Edward the Odd at the same time).

The pawn string doesn't seem to take weapon dps into account - is this by design or a bug?

Shandara, on the Calculations tab, under "Base Critical Hit Chance" the Base is a negative value (-1.53%). I tried to follow the Cell alias, but could not find the source. Where is this value derived?

I ask because I'm doing my own calculation and the Crit from Agility I calculate does not match my paper doll, the difference is exactly 1.53%. I'm curious to know where this comes from.

This is a relic from Cheeky's sheet. It was tested then (and I briefly re-checked during WotLK beta), but the amount of critical chance gained from agility is exactly 1,53% lower than expected. Its most likely cause is that we have a negative base crit chance of -1,53% as stated in the sheet.

Gear planner only shows top10 waepons. It's possible that the waepon falls below that category.

Try changing gear filters on top.

Make sure you have hard mode loot selected. It should be around number 3 or 4 in the list.

Ah yes, my bad >_>

That's weird that it's worse than the KT gun. When I got it I was so excited since it was the first Ulduar ranged weapon we'd had after clearing it for what, nearly 2 months X_X

Worse? Hm. My fellow hunter has it and it shows just below the Ulduar 25 weapons. It has hit, though, so if you are capped, that hurts. Also, did you hit the calc ranged button to make sure? I often forget to do that when changing gear.

Yeah. It's like 2 DPS below to the KT gun with assume 100% on no. I mean, I am hit capped obviously but yeah. I don't really have anything with hit on it to drop for the gun regardless, aside from surge for the emblem one. Still, either way it seems like such a minor dps upgrade or downgrade according to the spreadsheet it doesn't seem worth it.

*deleted*

This is a fairly insignificant difference, but I've calculated Lvl 80 Troll base health to be 7324 rather than the 7410 used on the spreadsheet (currently using v89a, but didn't see any change notes regarding this on the latest versions). The difference amounts to about 86 hp.

I tested it on armory profiles of myself and two random 80 troll hunters from my server and it works out exactly in all three cases.

Is it just me or is the gear planner...quirky? Does anyone have tips on how to use it better?

Some examples from v89a.

Wearing the [Heroes' Cryptstalker Tunic], it showed the [Tunic of Masked Suffering] as a 20 DPS upgrade. Playing with the spreadsheet, I swapped it in and re-gemmed to keep my hit capped. It turned into a 20 DPS downgrade. Huh? Note that I didn't lose the set bonus with this.

I had a similar issue swapping out the [Titanium Impact Band] for a [Sealing Ring of Grobbulus].

On the other hand, [Rifle of the Platinum Guard] shows as a downgrade when I have [Nerubian Conquerer] equipped, but an upgrade when I equip it and swap the hit rating for agility (and then the Conquerer shows as a downgrade).

These mainly seem to be a result of undervaluing hit rating on an item when I'm near the cap (which is going to turn into Agility when I re-gem). However, playing with the hit cap settings doesn't seem to help. Anyone have any hints on how to get better numbers out of this thing?

I feel bad that I've grabbed some drops that, after some analysis, turn out to be downgrades. I wanted to use the gear planner to allow me to only grab upgrades, but it's not really doing that job. My current thinking is to grab only big, obvious upgrades, and pass on all the minor ones, until I trust the gear planner.

I played around with some talent specs, since I was thinking with the next patch we will get a fairly large discount on AiS and CS mana costs it might be possible to drop RK/RC and put the talents elsewhere. To try and get as accurate a read as possible, I used shot rotations instead of frequencies. What I noticed was that at almost each re-run of the rotation, the resulting DPS would be different. The difference was as high as 70 DPS. Very odd! Can anyone else replicate this?

I believe the behavior you're seeing essentially boils down to this: It's generally better if you can avoid gemming hit. Any gear choice that reduces your hit gems (with other things being mostly equal) will be an upgrade, but the spreadsheet may not see it that way until you actually do it. And vice versa. This has happened to me many times, and I've also grabbed gear that turned out to be downgrades (and felt bad later). It comes down to a certain amount of intuition. Hit rating is a tricky beast, and although the spreadsheet tries to do a great job with it, it can be very hard to come up with a one-size-fits-all methodology for dealing with it in a gear planner.

Some of the gear you've inadvertently taken may turn out to be useful in future outfits, so all may not be lost.

You may also need to check to see what the assumed gems are in the settings tab. If you don't use the gems specified, then it may not be an upgrade. Also, if you switch out a piece of gear, say from one with gems to one without, the assumed gems of the old piece may now make it an upgrade for you.