Free Software by John O. McClain          Links: Errors | John McClain's Page ]     18 Mar 2010

DecisionTree.XLS

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

CentralLimThm.xls

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
multi-process machines

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
1-process machines

OLD VERSION: factory simulator in a Microsoft Excel spreadsheet. (One process per machine.)

LineSim.XLS

Like CellSim, but for serial lines only, one process per machine. Excel 2003 & 2007 Compatibility: 25 Oct 2007.

Queue.XLS

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 single-stage, multi-server, finite-capacity queue. Service times and inter-arrival times are very flexible, modeled by the Gamma distribution, which includes Exponential as a special case. Excel 2003 & 2007 Compatibility: 25 Oct 2007.

QueueTransient.XLS

Provides a Simulation of a single-stage, finite-capacity, multi-server 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 steady-state. Service times and inter-arrival times are very flexible, modeled by the Gamma distribution, which includes Exponential as a special case. Excel 2003 & 2007 Compatibility: 25 Oct 2007.

CritPath.XLS

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.

ExcelStats.XLS

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

PivotTab.XLS

Explains Excel's methods for Cross-Tabulation and Chi-squared tests. Versions for Excel 2003 and 2007.

PredInt.XLS

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.

NormalProbPlot.xls

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 “bell-shaped” 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.

@RiskStarter.XLS

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

sS.XLS

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.

DataLabels.xls

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

DataLabels07.xlsm

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

DataLabelsXY.xls

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

DataLabelsXY07.xlsm

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 ]