MonteGrid | Articles | How to run Monte Carlo simulation in Excel on a Mac
How to run Monte Carlo simulation in Excel on a Mac
MonteGrid runs Monte Carlo simulation in Excel for Mac. It adds a MonteGrid tab to Excel for assumptions, forecasts, correlation, sensitivity charts and reports, with no Windows virtual machine.
Updated
Requirements
| Item | Requirement |
|---|---|
| Excel | Excel 2024 or Microsoft 365 for Mac. |
| Mac | A Mac with Apple silicon and macOS 15 or later. |
| License | MonteGrid is free for one hour each day. A one-time license removes the limit. |
Download MonteGrid, move it to Applications and open it one time. Excel then shows a MonteGrid tab. See Install MonteGrid on Mac.
Run a simulation
To simulate a model in Excel for Mac:
- Select an input cell. On the MonteGrid tab, click Define Assumption, choose a distribution from the 42 in Define Assumption, enter its parameters and click Save assumption. MonteGrid writes an MC_ function into the cell, such as =MC_TRIANG(420,450,470,MC_STATIC(450,"Unit Price","")).
- Repeat for each uncertain input.
- Select an output cell. On the MonteGrid tab, click Define Forecast, enter a name and click Save forecast. MonteGrid wraps the formula in MC_OUTPUT.
- To correlate inputs, put them in a correlation group, or define a correlation matrix with Define Correlation.
- On the MonteGrid tab, click Run. The default run has 5,000 trials. When the run ends, the Results page opens.
- Read the statistics, the histogram, the tornado chart and the rank correlations of each forecast. Click Create Report for a report workbook, or Extract Data for every trial.
The procedures with screens are in the tutorials, starting with Build a model and run a first simulation. Example models are on the Examples page.
What MonteGrid does
| Item | MonteGrid |
|---|---|
| Distributions | 42, in eight groups. See the distribution reference. |
| Models | Assumptions are MC_ functions in the cells, and forecasts are MC_OUTPUT. Correlation groups and matrices are in the cells too. |
| Calculation | MonteGrid's engine calculates the workbook outside Excel. The Excel run mode recalculates each trial in Excel. |
| Sampling | Monte Carlo, Latin Hypercube (random or median) and Sobol quasi-Monte Carlo. |
| Trials | Up to 1,000,000,000. The same model, settings and seed give the same results. |
| Correlation | Rank correlation by the Iman–Conover method. The rank correlation in the trials is the one requested. |
| Results | Statistics, a histogram, a tornado chart and rank correlations for each forecast. A report workbook in the layout of a Crystal Ball report. |
| Crystal Ball and @RISK models | Imports Crystal Ball definitions from a full report. Converts @RISK functions in place. |
Crystal Ball and @RISK on a Mac
Oracle's compatibility list for Crystal Ball 11.1.3 names Windows and Excel for Windows only. Lumivero's @RISK page states that @RISK "is not currently compatible with Excel for Mac". On a Mac, both run only in a Windows virtual machine or on a remote Windows computer.
MonteGrid takes over models from both: see Oracle Crystal Ball on a Mac and Lumivero @RISK on a Mac.
MonteGrid is free for one hour each day. Download MonteGrid.