|
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 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. |
|
|
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. |
|
|
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 Cross-Tabulation and Chi-squared 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 “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. |
|
|
A step-by-step 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. |
|
|
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 ]