MonteGrid | Articles | Lumivero @RISK on a Mac
Lumivero @RISK on a Mac
Lumivero @RISK requires Excel for Windows. On a Mac, an @RISK model runs in Windows, or in MonteGrid after a conversion of its functions.
Updated
Platform support
The @RISK product page states that "@RISK and the DecisionTools Suite are only compatible in a Windows environment", and that @RISK "is not currently compatible with Excel for Mac or the Excel browser version in Microsoft 365 Web".
The License Installation Guide for @RISK 8.10, last updated on February 13, 2024, lists these requirements:
| Item | Supported |
|---|---|
| Windows | Windows 8, Windows 10 or Windows 11. |
| Excel | An installed copy of Excel for Windows: Excel 2013, 2016 or 2019, or Office 365 for Windows. |
| On a Mac | Windows 8 through Windows 11 with Boot Camp. Windows 8 through Windows 10 in Parallels, VirtualBox or VMware. |
The guide states that "there is no support for running on the native Macintosh OS". It does not mention Windows on Arm.
Options on a Mac
@RISK runs on Windows. On a Mac, Windows runs in a virtual machine or on a remote computer. MonteGrid runs in Excel for Mac.
| Option | Requirements | Notes |
|---|---|---|
| Parallels Desktop | Windows 11 Pro or Enterprise, Excel for Windows and an @RISK license. | Microsoft authorizes Parallels Desktop 18, 19 and 20 to run the Arm version of Windows 11 Pro and Enterprise on Macs with M1, M2 and M3 chips. Lumivero's guide lists Windows 8 through Windows 10 for Parallels, and does not mention Windows on Arm. |
| Windows 365 Cloud PC | A Windows 365 subscription, Excel for Windows and an @RISK license. | Microsoft streams Windows 11 to the Mac. @RISK runs on the Cloud PC. |
| Boot Camp | A Mac with an Intel processor. | Lumivero's guide lists Windows 8 through Windows 11 with Boot Camp. Boot Camp requires an Intel processor. Macs with Apple silicon cannot use it. |
| MonteGrid | Excel 2024 or Microsoft 365 for Mac. A Mac with Apple silicon and macOS 15 or later. | MonteGrid runs in Excel for Mac. It converts @RISK functions to MC_ functions in place. |
What MonteGrid converts
@RISK stores its definitions in cell formulas, such as =RiskTriang(F4,G4,H4,RiskName("Area")). In Excel without @RISK, these cells show #NAME?. MonteGrid rewrites each cell in place. The Mac does not need @RISK.
| @RISK cell | After the conversion |
|---|---|
| One of 29 distribution functions, with numbers or cell references as parameters | An MC_ assumption in the same cell. |
| RiskOutput("name")+formula | A forecast: the formula in MC_OUTPUT, with the name. |
| RiskMakeInput(formula) | The formula, without RiskMakeInput. |
| A member of a RiskCorrmat matrix | A member of a MonteGrid correlation matrix. MonteGrid writes the matrix as a block of cells below the @RISK matrix. These cells must be empty. |
| A statistic function, such as RiskMean or RiskPercentile | Left as it is. MonteGrid writes its statistics to its report. |
| Any other @RISK cell | Not converted. The cell stays as @RISK wrote it. The plan gives the reason. |
MonteGrid does not convert a distribution inside another formula, a parameter that is an expression, a RiskDiscrete or RiskCumul list that is a cell range, or a RiskExpon mean that is a cell reference.
| @RISK property | After the conversion |
|---|---|
| RiskName | The assumption's name. |
| RiskStatic | The value the cell shows outside a simulation, in MC_STATIC. |
| RiskTruncate, RiskTruncateP | MC_TRUNC, MC_TRUNCP. |
| RiskCollect, RiskCategory, RiskUnits, RiskIsDiscrete, RiskIsDate, RiskConvergence | Removed. |
| RiskSeed, RiskLock | Removed. The plan lists them. |
| RiskCopula, RiskIndepC, RiskDepC | Not converted. MonteGrid correlates assumptions with rank correlation matrices. |
| RiskCorrmat with an instance argument | Not converted. |
| RiskShift and other properties | Not converted. |
Without RiskStatic, the cell shows the distribution's mean outside a simulation, or a value that the distribution can take where the mean is not one.
Distribution mapping
MonteGrid converts these 29 @RISK distribution functions. The third column gives each change to the arguments.
| @RISK function | MonteGrid function | Arguments |
|---|---|---|
| RiskBernoulli | MC_BERNOULLI | Same order. |
| RiskBeta | MC_BETA | Same order, then minimum 0 and maximum 1. |
| RiskBetaGeneral | MC_BETA | Same order. |
| RiskBinomial | MC_BINOMIAL | Same order. |
| RiskChiSq | MC_CHISQ | Same order. |
| RiskCumul | MC_CUMUL | The minimum and maximum join the value list, with cumulative probabilities 0 and 1. The lists must be typed into the formula. |
| RiskDiscrete | MC_DISCRETE | The value and probability lists must be typed into the formula. |
| RiskErlang | MC_ERLANG | Same order. |
| RiskExpon | MC_EXPON | @RISK takes the mean. MonteGrid writes the rate, 1/mean. The mean must be a number. |
| RiskExtValue | MC_GUMBELMAX | Same order. |
| RiskExtValueMin | MC_GUMBELMIN | Same order. |
| RiskGamma | MC_GAMMA | Same order. |
| RiskGeomet | MC_GEOMETRIC | Same order. |
| RiskHypergeo | MC_HYPGEOM | Reverse order. |
| RiskIntUniform | MC_DUNIFORM | Same order. |
| RiskInvgauss | MC_INVGAUSS | Same order. |
| RiskLaplace | MC_LAPLACE | Same order. |
| RiskLogistic | MC_LOGISTIC | Same order. |
| RiskLognorm | MC_LOGNORMAL | Same order. |
| RiskNegbin | MC_NEGBINOM | Same order. |
| RiskNormal | MC_NORMAL | Same order. |
| RiskPareto | MC_PARETO | Reverse order. |
| RiskPert | MC_PERT | Same order. |
| RiskPoisson | MC_POISSON | Same order. |
| RiskRayleigh | MC_RAYLEIGH | Same order. |
| RiskStudent | MC_STUDENTT | Midpoint 0 and scale 1, then the degrees of freedom. |
| RiskTriang | MC_TRIANG | Same order. |
| RiskUniform | MC_UNIFORM | Same order. |
| RiskWeibull | MC_WEIBULL | Same order. |
MonteGrid does not convert the other @RISK distribution functions, such as RiskGeneral, RiskHistogrm, RiskTrigen, RiskCompound, RiskSplice and RiskResample, or the time series and project functions. Define these assumptions by hand.
Convert a model
Work on a copy of the model.
To convert an @RISK model:
- Open the model in Excel on the Mac. On the MonteGrid tab, click Open MonteGrid.
- On the Model page, under Built with @RISK, click Convert….
- Review the plan, then click Convert.
- Save the workbook.
The procedure with screens is in Convert from Crystal Ball or @RISK.
Check the conversion
Run the model in MonteGrid with the number of trials used in @RISK. Compare the forecast statistics. They differ within sampling error, because the two tools use different random numbers.
Define by hand each cell that was not converted.