Hey guys, been trying to get this spreadsheet to work for a while now, and have kind of hit a dead end, I am running excel 2007, on windows XP, I've tried everything I saw in this thread, searched for additional info about it and couldnt find anything that would work.

I have macros fully enabled as this is the only excel item I run I figure Shandra wont make anything evil that tries to steal my chocolate chip cookies

But whenever I try to open the spreadsheet i get this thrown at me

"This workbook has lost its VBA project, ActiveX controls and any other programmability-related features."

I also have active X settings to allowed as well, and trust access to VBA is enabled in the macro options, so I'm at a loss here.

If you click ok the sheet opens up but none of the buttons work (load profile/armory, test rotation etc etc) either you click them and it does nothing or you click it and it selects the object and still does nothing.

Real sorry if this has been worked out but I've run search and tried to dig up what I could without any success :\

Checking your armory now it shows you wearing FrR boots probably from Thorim Hardmode.

I've found that Excel has problems if you tell it to simply accept the spreadsheet as being safe. Instead, set it to ask for permission to run things. You have to click the security options button that appears when you open the sheet, but it otherwise works fine.

Pop in your Office 2007 CD and install VBA extensions. Should be either under either the Excel or Office Tools trees.

Discovered this weekend that Valorous Cryptstalker Handguards do not drop in Naxx 25 as noted in the gear planner tab; they drop in 25 man Obsidian Sanctum.

Hey guys, I'm having trouble getting the macro buttons in Shandara's spreadsheet to show up. I'm using Excel 2000 and I've been using this spreadsheet for months and I've never had any problems with the buttons not showing. Recently however, whenever I open the spreadsheet, the buttons show up and then disappear half a second later. The problem seemed to originate after downloading one of the spreadsheet releases about 2-3 months ago (I don't remember which release #). I soon realized that their were no macro buttons while using the spreadsheet, and I thought it was an error with that version of the spreadsheet. However, all of the macro buttons in the older release versions stopped working as well. I don't know if the DL triggered it or if it was completely unrelated.

I've searched this thread and others (including threads that had nothing to do with this specific spreadsheet), and I can't seem to find out what the problem is. I've tried playing around with the security settings to no effect.

Has anyone else run into a similar problem, and if so how did you deal with it?

Column F (custom values) is where you make your changes.

I went and set it up to install on first use since I wasnt sure if more then just that would be missing and it installed it when I loaded the sheet up, everything seems to be working now! Thanks alot Spamurai, thought I installed everything for excel when I originally installed it a while back :\ Hopefully this is the problem my friend is having also, gona get her to double check her installation =]

Much thanks!

Hey Shandra, it appears that Improved Steady Shot is busted(?), it appears like I have to run the test rotation to get it to effect the dps of my spec. (where as other talents appear to recalculate automatically). In the past it use to adjust the value of this talent automatically, perhaps there's some setting I'm missing?

Improved Steady Shot is simulated in the rotation test, so if you want to disable this turn off the rotation test on the settings tab.

Hello.

Thank you for your hard work making this beautiful instrument.

I think that you should add the Hand-Mounted Pyro Rocket to the shot rotation (mind that it doesn't share the shots' GCD).

My shot rotation is set to RF / BF / SrS / KS / CS / Readiness / None / AiS / AS / SS and I set a 200 ms latency, when using the rotation test it skips Chimera Shot several times when it should not.

The shot where it gets skipped comes at 13.6 seconds, the exact time where CS gets off CD and would be expected to fire. However, it does not and instead fires AS that came off 0.6 seconds before that while adding a (Skipped Chimera Shot) in the margin. This happens several times later on and always when CS comes off CD the exact moment the Rotation Test needs to pick a new shot. It seems there's something faulty with the algorithm that makes the shot pick.

Can anyone replicate this? I use no CD modifying glyphs.

Why is it a dps-lose when i change giants bane (232) against the highend pvp-weapon (239) with >200 dps.
shouldnt that be an upgrade in case of DMG?

The base damage of the weapon is only one factor in what makes one better than another. The high end damage is only 19 more, [Giant's Bane] has more AP than [Furious Gladiator's Recurve] regardless of spec, and the haste & ArP on the gun are likely to be worth more for most gear sets than the crit on the bow.

Update:
The sheet now automatically reruns the rotation test on glyph/talent/rotation changes (Gear/Buffs still need a manual re-run), because judging by the amount of posts/PMs people forget to do it a lot. I've tweaked the test a bit performance wise so hopefully it shouldn't be a big performance hit.

On my computer the whole test + updating cells in the sheet takes 0.7s-0.8s which is fast enough to make changing talents snappy enough (biggest part of that time is spent by Excel updating cells in its slow and kludgy way, rather than actual computation).

This version should also fix the issue Whitemane reported.

Verson 89g

When using the macro buttons on the Talents tab (Read from Armory, Load Spec, & Import Talent URL) and Gear tab (Delete Profile), the sheet seems to go into a non stop "calculate" mode.

Hi,

I'm having some confusion on how to input my MM rotation in the Shot Rotation tab. Do you know how I'd input the following:

Serpent Sting
Rapid Fire
Readiness
Rapid Fire
Chimera
Arcane
Aimed
Steady

And also to include silencing shot whenever it's up (it's macro'd to all my shots) and the same for Killshot?

Just as you listed them, with Silencing Shot in place of the second Rapid Fire - the spreadsheet is smart enough to know that you'll use it every time it's off cooldown - and Kill Shot ahead of whichever shots you're going to prioritise it over. The rotation that gets loaded with the default MM spec in the spreadsheet may even have them all in place for you already.

It seems like the Gear Planner isn't taking into account the 1% Crit bonus from the Dwarven racial.

[Siren's Cry] comes up over [Giant's Bane], any with out the 1% crit from the racial, is better.

Here's the comparison Item Comparison Tool - World of Warcraft.

However, with the 1% crit, Giant's Bane comes up as

21 Armor Pen
5 Haste
0.1 DPS
0.45% Crit

at the expense of 3 Stamina.

Did you hit the ranged weapon button on gear planner? After it does the calculation it should show up correctly.

Using the version 89g with the same model from my char in 89f, counts me a drop of 200~ on Total Dps.
Trying to find where it came from, i'm missing the table of 'Usage of Kill Shot' in Shot Rotation, with this in Overview at Hunter DPS Breakdown my Proc/Talent DPS is with a value of 0,37 for a 0.01% against 250,26 for 4,16% in the older version.
At the same time at Shot Rotation the "Kill Shot low Hp gain" is completely different between both versions.

Maybe i'm looking at the wrong place, but still couldn't find the reason for the DPS drop.
Old version = 7196,03 DPS
New version = 6996,74 DPS

i've been testing kill shot behaviour in this version, and when i change target's armor from the standard value to 1, Killshot's damage does not change in the calculations tab, while Steady auto and aimed do. I dont know if its always been like this, but iirc KS is a physical damage shot and is affected by armor.