SimQuick works on all versions of Excel for PCs from the 2007 version to the latest 2016 version. It also works on all versions of Excel for Macs from the 2011 version to the latest 2016 version. (For a number of years before 2011, Macs couldn’t run any VBA code at all, hence SimQuick will not work on versions of Excel from those dark days.)
SimQuick also works on versions of Excel on a PC from before Excel 2007. A “.xls” version is provided.
Unfortunately, the latest Excel 2016 for Macs is not completely backwards compatible for VBA. An alternate version of SimQuick is provided for users of this version of Excel. It works as usual, except the pull-down lists for entering “Names” of elements in the models is disabled. So you just have to type them out; not a big deal. (Come on Microsoft, show a little respect here for the Mac world!)
New Feature:
The latest versions of SimQuick (dated 4-2-16 and later) have a new feature that allows you to display sample standard deviations. (Look under “Other Features.”) This was added after the book was first published (Jan. 2016), but should be self-explanatory. It is referenced in the (slightly) updated version of the book that became available on June 15, 2016. Standard deviations are useful for computing confidence intervals for population means and for performing hypothesis tests when considering model variations.
1-5-18 Update:
Two little bugs were fixed. One error occurred if a Buffer had 10 outputs. The other error occurred if the “Calculate standard deviation” option was selected and only one simulation was being run. (The sample standard deviation isn’t defined for samples of size 1.)
4-6-18 Update:
When running a model, an error message is displayed when “Show results details” (under “Other Features”) is selected and either the Number of Simulations is >200 or there is more than one scenario. The message now asks the user to select “Hide results details” before rerunning the model.