Click or drag to resize

xllmonte

This add-in performs Monte Carlo simulation in Excel.

Action

Key

Run a simulation

Ctrl-Shift-R

Stop a simulation

Esc

Single-Step a simulation

Ctrl-Shift-S

ReseT a simulation

Ctrl-Shift-T

Over the course of a simulation you can collect statistics such as max, min, mean and standard deviation. Monte does not store any simulation results so it is possible to run as many iterations as you wish.

Note that the Excel message bar on the bottom left displays number of iterations, the elapsed time, and the iterations per second.

Monte adds the time dimension to your spreadsheet. If you enter, say, =MONTE.AVERAGE(RAND()) then start a simulation, every time RAND() is recalculated the cell will be updated with the running average of the calls to RAND()