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.

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:

ItemSupported
WindowsWindows 8, Windows 10 or Windows 11.
ExcelAn installed copy of Excel for Windows: Excel 2013, 2016 or 2019, or Office 365 for Windows.
On a MacWindows 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.

OptionRequirementsNotes
Parallels DesktopWindows 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 PCA Windows 365 subscription, Excel for Windows and an @RISK license.Microsoft streams Windows 11 to the Mac. @RISK runs on the Cloud PC.
Boot CampA 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.
MonteGridExcel 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 cellAfter the conversion
One of 29 distribution functions, with numbers or cell references as parametersAn MC_ assumption in the same cell.
RiskOutput("name")+formulaA forecast: the formula in MC_OUTPUT, with the name.
RiskMakeInput(formula)The formula, without RiskMakeInput.
A member of a RiskCorrmat matrixA 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 RiskPercentileLeft as it is. MonteGrid writes its statistics to its report.
Any other @RISK cellNot 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 propertyAfter the conversion
RiskNameThe assumption's name.
RiskStaticThe value the cell shows outside a simulation, in MC_STATIC.
RiskTruncate, RiskTruncatePMC_TRUNC, MC_TRUNCP.
RiskCollect, RiskCategory, RiskUnits, RiskIsDiscrete, RiskIsDate, RiskConvergenceRemoved.
RiskSeed, RiskLockRemoved. The plan lists them.
RiskCopula, RiskIndepC, RiskDepCNot converted. MonteGrid correlates assumptions with rank correlation matrices.
RiskCorrmat with an instance argumentNot converted.
RiskShift and other propertiesNot 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 functionMonteGrid functionArguments
RiskBernoulliMC_BERNOULLISame order.
RiskBetaMC_BETASame order, then minimum 0 and maximum 1.
RiskBetaGeneralMC_BETASame order.
RiskBinomialMC_BINOMIALSame order.
RiskChiSqMC_CHISQSame order.
RiskCumulMC_CUMULThe minimum and maximum join the value list, with cumulative probabilities 0 and 1. The lists must be typed into the formula.
RiskDiscreteMC_DISCRETEThe value and probability lists must be typed into the formula.
RiskErlangMC_ERLANGSame order.
RiskExponMC_EXPON@RISK takes the mean. MonteGrid writes the rate, 1/mean. The mean must be a number.
RiskExtValueMC_GUMBELMAXSame order.
RiskExtValueMinMC_GUMBELMINSame order.
RiskGammaMC_GAMMASame order.
RiskGeometMC_GEOMETRICSame order.
RiskHypergeoMC_HYPGEOMReverse order.
RiskIntUniformMC_DUNIFORMSame order.
RiskInvgaussMC_INVGAUSSSame order.
RiskLaplaceMC_LAPLACESame order.
RiskLogisticMC_LOGISTICSame order.
RiskLognormMC_LOGNORMALSame order.
RiskNegbinMC_NEGBINOMSame order.
RiskNormalMC_NORMALSame order.
RiskParetoMC_PARETOReverse order.
RiskPertMC_PERTSame order.
RiskPoissonMC_POISSONSame order.
RiskRayleighMC_RAYLEIGHSame order.
RiskStudentMC_STUDENTTMidpoint 0 and scale 1, then the degrees of freedom.
RiskTriangMC_TRIANGSame order.
RiskUniformMC_UNIFORMSame order.
RiskWeibullMC_WEIBULLSame 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:

  1. Open the model in Excel on the Mac. On the MonteGrid tab, click Open MonteGrid.
  2. On the Model page, under Built with @RISK, click Convert….
  3. Review the plan, then click Convert.
  4. 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.

Sources

  1. Lumivero: @RISK product page
  2. Lumivero: @RISK License Installation Guide (8.10)
  3. Microsoft: Options for using Windows 11 with Mac computers with Apple M1, M2, and M3 chips
  4. Apple: Install Windows 10 on your Mac with Boot Camp Assistant

All articles