WotLK DPS spreadsheet - Page 191

Norek · 06/15/09, 12:08 AM

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 :\

Lilbitters · 06/15/09, 2:03 AM

Originally Posted by Sukandi

When importing my gear, I get 'Icy Scale Boots' is not a known item for slot 'Feet', do you wish to try and load it from the Armory?

Yes, and it loads Conqueror's Scourgestalker Legguards into the slot. No, and it doesn't load anything.

I have [Boots of Living Scale] on, as you can see from my armory.

I get the calcattributes thing too, when switching from your default profile after putting my data in, but if you just hit the button again afterwards, it goes back to what it is supposed to be.

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

wurmfood · 06/15/09, 2:07 AM

Originally Posted by Norek

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'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.

Spamurai · 06/15/09, 9:00 AM

Originally Posted by Norek

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 :\

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

DoktorD · 06/15/09, 10:47 AM

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.

Dansharpshot · 06/15/09, 3:28 PM

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?

DoktorD · 06/15/09, 5:25 PM

Originally Posted by Shandara

Are you trying to change the locked 'default' values or the yellow, empty 'custom value' fields right next to them?

(This question pops up quite a lot, how can I make it clearer?)

Same situation here. I'm trying to change the default gems (all are +16 agi), but in using the drop down, any other value returns the protected cell warning. On the setting tab, the entire sheet appears to be protected instead of all the cells except column E (default values). I would think that the default values in column E of the settings tab should be accessible.

Daymaker · 06/15/09, 5:37 PM

Originally Posted by DoktorD

Same situation here. I'm trying to change the default gems (all are +16 agi), but in using the drop down, any other value returns the protected cell warning. On the setting tab, the entire sheet appears to be protected instead of all the cells except column E (default values). I would think that the default values in column E of the settings tab should be accessible.

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

Norek · 06/15/09, 7:21 PM

Originally Posted by Spamurai

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

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!

Ferlog · 06/16/09, 12:13 AM

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?

Shandara · 06/16/09, 3:27 AM

Originally Posted by Ferlog

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.

NarzulHF · 06/16/09, 7:23 AM

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).

kabes · 06/16/09, 9:05 AM

Originally Posted by NarzulHF

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).

The damage from the pyro rocket is factored in automatically. Go ahead and compare the dps difference between Crusher and the pyro rocket enchants. It is assumed you have it macro'd to all your shots so it fires every 45 sec since its off the GCD.

Whitemane · 06/16/09, 8:31 PM

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.

Erathriel · 06/16/09, 10:24 PM

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?