I’ve had this done for a while but was hoping to get a bit of testing done on it - thats not gone so well, but I want to get it out there. This then is “Beta” which in this case means don’t even think about blaming me for anything! Having said that I don’t believe it should cause an major issues - I’ve only found one issue that i have not addressed yet as it occurs in very odd situations.
The download .zip has a install .exe in it. Run that and it will give you a standard installation experience.
Apart form the UI the bulk of the code is from Charles Williams of DecisionModels.com. Also look at his fab article here
Once installed I’ve stuck a button on the Menu bar (sorry, you can change the code if you like, the pw for the VBA project is “methodsinexcel”)
The main screen is where all the action takes place. I hope it’s fairly straight forward, if not post any questions in the comments:
Clicking the About link explains what each part actually does, it also shows the uninstall button.
So heres the download, enjoy.
M.I.E Cal Tool1.zip
Hello mate, am trying out your calc tool as I’m having problems with slow calculations in excel at the mo. Would you recommend pushing for excel 2007 to sort this out?
Hope the job is going well x
Hey, great site. I too love excel and the many things it can do. Great job with this tool. It should come in handy for me :)
-Joanna
Hi Al,
The only time 2007 will improve speed is if it can split the cals across a dual core processor, upto 2003 all excel cals where a single process affair so 2007 might help if you have a dual core - but i suspect it’s actually unlikely. You might like to try downloading the trail and seeing if it helps - be careful though 2007 has a habit for taking control of you system!