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.

Requirements

ItemRequirement
ExcelExcel 2024 or Microsoft 365 for Mac.
MacA Mac with Apple silicon and macOS 15 or later.
LicenseMonteGrid 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:

  1. 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","")).
  2. Repeat for each uncertain input.
  3. 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.
  4. To correlate inputs, put them in a correlation group, or define a correlation matrix with Define Correlation.
  5. On the MonteGrid tab, click Run. The default run has 5,000 trials. When the run ends, the Results page opens.
  6. 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

ItemMonteGrid
Distributions42, in eight groups. See the distribution reference.
ModelsAssumptions are MC_ functions in the cells, and forecasts are MC_OUTPUT. Correlation groups and matrices are in the cells too.
CalculationMonteGrid's engine calculates the workbook outside Excel. The Excel run mode recalculates each trial in Excel.
SamplingMonte Carlo, Latin Hypercube (random or median) and Sobol quasi-Monte Carlo.
TrialsUp to 1,000,000,000. The same model, settings and seed give the same results.
CorrelationRank correlation by the Iman–Conover method. The rank correlation in the trials is the one requested.
ResultsStatistics, 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 modelsImports 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.

Sources

  1. Oracle: Updated Compatible Versions of Microsoft Products (Crystal Ball 11.1.3)
  2. Lumivero: @RISK product page

All articles