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

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()