Just throwing this out there: Mac Office 08 cannot use VB. Period dot the end. Will never be able to, so if you intend to use Cheeky's spreadsheet to the full extent possible, use an older version. I found this out after getting it, so I thought I would pass the info on. I currently hand input everything, and it's a pain in the ass, so I recommend an older version!

I've been fiddling with the spreadsheet for a couple of hours now and i can't get the crit % right. It should say around 34.57%, but when all gear is inserted into the spreadsheet and talents correct, it still says 37.73%.

Whats up with that?

If you are Survival specced and have Master Tactician (at work so I can't see your armory) then it equates to about 3% crit. which would show in the spreadsheet but not in game.

Ah, Thanks for clearing that up for me. Yup, Survival specced and MT for sure.

Will Golden Bow of Quel'Thalas - Items - WOWDB be added to your spreadsheet soon enough? Just a question, I do my own calculations but I'm terrible and have ADD, Not to be a lazy sob, but I'd like to see what your numbers say (Plus, i'm having trouble adding it in there on my own)

I'll get it in for a release later this week.

The Custom Gear tab should have everything you need to play around with it right now.

quick question about the "Time to mana exhaustion" what is that counted in? seconds?

Shot Rotation tab shows Steady cast time as 1.3 secs -- I have 0 haste in addition to the 15% quiver haste. I didn't think quiver haste affected SS cast time...I swear Quartz lists it as 1.5secs.
Am I just wrong and that everyone's SS is 1.3 seconds with quiver?

First, thanks a million for all of the wonderful work on this awesome tool! It is by far the best class spreadsheet that I have seen.

Possible bug concerning rotations.

The 1:1.X button with both Multishot and Arcane Shot selected works fine when unhasted with either the Hand-Weaved or Castsequence Macro? options chosen.

However, when I enter the haste rating for Rapid Fire in the Hand Adjust area on the Gear tab, the updated "1:1.5" shot rotations are not working out as expected.

With Castsequence selected, I get the expected rotation that squeezes in some extra steady-autos and does a 17 shot cycle with 7 steady-autos and arcane shots after the 1st and 5th of them and multishot after the 3rd.

However, with Hand-Weaved chosen, I get an 11 shot cycle with 5 steady-autos and the arcane shot after the first steady auto with no multishots. Even if I reduce the Latency from the default 0.2 to 0.1, I still do not see any multishots. The rotation does change though to a 1:1.3 rotation with 3 steady-autos and the arcane shot after the first steady.

To see where the multishot would come back in, I tried haste ratings of 400, 300, 200, and 100. It was not until HR 100 that the multishot was brought back in.

Is this related to the GCD client-side modeling for Hand-Weaven? Is this as intended? Doesn't seem like it should work that way and that multishots should still be included in the rotation.

My Office 2007 running Vista is disabling the macros and the buttons. Is there a fix for this?

Thanks

First of all my compliments on the great job Cheeky! Keep it up!

My question: In the "Shot Rotation" tab, Macro choice you have 3 options: Hand-weaved, Castsequence & Spam. Handweaved and castsequence for the 1:1.X rotation are I guess pretty self explanatory. But, when you say spam, what exactly is the macro that you use? I am asking this because there are a couple of alternatives for this term:

1st Spam Macro 1:1.X (only arcane)
...
/cast !Auto Shot
/castrandom Steady Shot, Arcane Shot
...

2nd Spam Macro 1:1.X (only arcane)
...
/cast !Auto Shot
/cast Steady Shot
/castrandom Arcane Shot
...

3rd Spam Macro 1:1.X (only arcane)
...
/castsequence !Auto Shot, Steady Shot
/castrandom Arcane Shot
...

According to the spreadsheet this is the heaviest dps method for me by a large margin from the others (100-200dps). But I tried all three macros on Dr-Guinea-Pig-Boom and got no real differences. The one that came a bit higher than the rest and it's my best guess is the 1st one, but I would like to make sure I am correct.

Thanks in advance for the clarification.

PS: The Buffs Profile selection tab is protected in this version of the spreadsheet and you cannot change it (cell D4).