This add-in performs Monte Carlo simulation in Excel.
Run a simulation
Stop a simulation
Single-Step a simulation
ReseT a simulation
Use Ctrl-Shift-Insert to automatically load xllMonte when you start Excel. Use Ctrl-Shift-Delete to undo this.
xllMonte calculates statistics such as mean, standard deviation, max, and min over the course of a simulation. They are computed on the fly so there is no limit to the number of iterations.
The Excel message bar displays the number of iterations, elapsed time, and iterations per second.
xllMonte adds the time dimension to your spreadsheet. If you enter =MONTE.MEAN(RAND()) then start a simulation, every time RAND() is recalculated the cell will be updated with the running average of the calls to RAND()