A Spreadsheet
Macro to construct decision trees and indicate the optimal decision strategy. 

A
spreadsheet macro to demonstrate how well the Central Limit Theorem applies,
depending on the skewness of the underlying distribution and the sample size.
Excel
2003 & 2007 Compatibility: 29 Oct 2007. 

CellSim.XLS 
Factory simulation of machines with multiple processes and many other features. Also includes sample factories illustrating the new features. Excel 2003 & 2007 Compatibility: 25 Oct 2007. 
CellSim.XLS 
OLD VERSION: factory simulator in a Microsoft Excel spreadsheet. (One process per machine.) 
Like CellSim, but for serial lines only, one process per machine. Excel 2003 & 2007 Compatibility: 25 Oct 2007. 

Teaching Queuing and a little Simulation to Management Students. The new version contains three analytical queuing models, plus a worksheet linked to a Visual Basic macro that runs a simulation of a singlestage, multiserver, finitecapacity queue. Service times and interarrival times are very flexible, modeled by the Gamma distribution, which includes Exponential as a special case. Excel 2003 & 2007 Compatibility: 25 Oct 2007. 

Provides a Simulation of a singlestage,
finitecapacity, multiserver queue.
The focus is on a time period between two points specified by the user.
Averages over replications are estimate of the system’s performance
characteristics over that time period. Hence, the results are transient, rather than steadystate. Service
times and interarrival times are very flexible, modeled by the Gamma
distribution, which includes Exponential as a special case. Excel 2003 &
2007 Compatibility: 25 Oct 2007. 

A spreadsheet/macro to do Critical Path calculations and diagram on a spreadsheet. The results are compatible with @RISK so the project may be simulated with uncertain activity times. Excel 2003 & 2007 Compatibility: 27 Oct 2007. 

Explains many of Excel's statistical tools and shows how to use them. 

Explains Excel's methods for CrossTabulation and Chisquared tests. Versions for Excel 2003 and 2007. 

Regression with Prediction Intervals. The macro in this spreadsheet expands the capabilities of Excel's statistical tool pack to include calculation of confidence and prediction intervals for the fitted value of a regression equation. The latest feature is a Normal Probability Plot, in addition to residual plots, outliers and influential observations. Excel 2003 & 2007 Compatibility. Version December 7, 2007. 

A tool for learning how to recognize departures from the Normal Probability Distribution using two visual tools – a Histogram and a Normal Probability Plot. The former should be “bellshaped” and the latter should be a “straight line” but how much departure from these ideals should we expect? Random sampling from different distributions and sample sizes gives you some practice. 

A stepbystep introduction to @Risk by example. Designed to get students up and running with @Risk with a minimum of effort. 

An Inventory Control
System simulator on a Microsoft Excel spreadsheet. Innovation: it allows
orders to arrive independently of one another, so “order crossing” can
happen. Updated 18Mar2010. 

Add Data Labels of
your choice, quickly and easily, to an existing Excel Chart: Excel 2003 only. 

Add Data Labels of
your choice, quickly and easily, to an existing Excel Chart: Excel 2007 only. 

Quickly create an
XY scatter chart, with data labels of your choice: Excel 2003 only. 

Quickly create an
XY scatter chart, with data labels of your choice: Excel 2007 only. 
Errors: What
to do if One of these Excel Files Doesn't Work as
Advertised
Some users find that the macros in these files are simply not there. For
example, they find that the buttons in CellSim.xls do not work. If this
happens, Excel has automatically disabled the macros that make it run. To fix
this, follow the instructions on the sheet “Warning” contained in the Excel
Workbook you downloaded.
Back to: [ John McClain's Page ]