MonteGrid | Articles | Oracle Crystal Ball on a Mac
Oracle Crystal Ball on a Mac
Oracle Crystal Ball requires Excel for Windows. On a Mac, a Crystal Ball model runs in Windows, or in MonteGrid after an import of its definitions.
Updated
Platform support
Oracle lists the platforms for Crystal Ball 11.1.3 in Updated Compatible Versions of Microsoft Products, last published on July 16, 2024.
| Item | Supported |
|---|---|
| Windows | Windows 10 and Windows 11. Windows Server 2016, 2019 and 2022. |
| Excel | Excel 2016, 2019 and 2021, 32-bit or 64-bit. |
| Office 365 | The desktop Excel of an Office 365 plan, installed on a supported Windows system. |
Crystal Ball is not supported for Office Web Apps. The list names no version of macOS or of Excel for Mac.
Options on a Mac
Crystal Ball 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 a Crystal Ball 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. On these Macs, Windows runs x64 and x86 apps in emulation. Oracle's list does not mention Windows on Arm. |
| Windows 365 Cloud PC | A Windows 365 subscription, Excel for Windows and a Crystal Ball license. | Microsoft streams Windows 11 to the Mac. Crystal Ball runs on the Cloud PC. |
| Boot Camp | A Mac with an Intel processor. | 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 imports Crystal Ball definitions from a full report. |
What MonteGrid imports
Crystal Ball stores its assumption definitions outside the cell formulas. MonteGrid reads them from a Crystal Ball full report and writes them into the cells as MC_ functions. The Mac does not need Crystal Ball.
| In the full report | In MonteGrid |
|---|---|
| An assumption with one of 21 distributions | An MC_ function in the same cell, with the assumption's name. The cell keeps the value it shows. |
| A forecast | The cell formula in MC_OUTPUT, with the forecast's name. |
| An assumption with a Custom distribution | Not imported. The cell keeps its value. The import lists the cell and the reason. |
| A Lognormal, Gamma or Weibull assumption with a location other than 0 | Not imported. The cell keeps its value. The import lists the cell and the reason. |
| Correlations and correlation matrices | Not imported. The import gives their number. Define them with Define Correlation. |
| Decision variables | Not imported. |
| Forecast statistics | Shown after the import: the Crystal Ball mean and standard deviation, for comparison. |
MonteGrid checks every cell that the report names before it writes. If an assumption cell holds a formula, or a forecast cell is empty or holds text, MonteGrid imports nothing and lists the cells. This occurs when the workbook changed after Crystal Ball created the report, or when the report is from another workbook.
To import a Crystal Ball model:
- On the Windows computer, open the model in Excel with Crystal Ball and run the simulation.
- On the Crystal Ball ribbon, in the Analyze group, click the upper half of Create Report.
- Click Full, then click OK. Crystal Ball creates the report as an Excel worksheet.
- Save the report as its own .xlsx workbook.
- Copy the model and the report to the Mac.
- Open the model in Excel. On the MonteGrid tab, click Import Definitions.
- Click Choose report… and select the report.
- Click Import.
- Save the workbook.
The procedure with screens is in Convert from Crystal Ball or @RISK.
Distribution mapping
Crystal Ball names and parameters are from Oracle's Distribution Parameter Summary. MonteGrid parameters are in the order of the MC_ function.
| Crystal Ball | Crystal Ball parameters | MonteGrid function |
|---|---|---|
| Beta | Alpha, beta, minimum, maximum | MC_BETA(alpha, beta, min, max) |
| BetaPERT | Minimum, likeliest, maximum | MC_PERT(min, likely, max) |
| Exponential | Rate | MC_EXPON(rate) |
| Gamma | Location, scale, shape | MC_GAMMA(shape, scale). Location 0 only. |
| Logistic | Mean, scale | MC_LOGISTIC(mean, scale) |
| Lognormal | Location, mean, standard deviation | MC_LOGNORMAL(mean, sd). Location 0 only. |
| Maximum extreme | Likeliest, scale | MC_GUMBELMAX(mode, scale) |
| Minimum extreme | Likeliest, scale | MC_GUMBELMIN(mode, scale) |
| Normal | Mean, standard deviation | MC_NORMAL(mean, sd) |
| Pareto | Location, shape | MC_PARETO(xmin, shape) |
| Student's t | Midpoint, scale, degrees of freedom | MC_STUDENTT(mid, scale, df) |
| Triangular | Minimum, likeliest, maximum | MC_TRIANG(min, likely, max) |
| Uniform | Minimum, maximum | MC_UNIFORM(min, max) |
| Weibull | Location, scale, shape | MC_WEIBULL(shape, scale). Location 0 only. |
| Binomial | Probability, trials | MC_BINOMIAL(n, p) |
| Discrete Uniform | Minimum, maximum | MC_DUNIFORM(min, max) |
| Geometric | Probability | MC_GEOMETRIC(p) |
| Hyper-geometric | Success, trials, population | MC_HYPGEOM(population, successes, draws) |
| Negative binomial | Probability, shape | MC_NEGBINOM(r, p) |
| Poisson | Rate | MC_POISSON(rate) |
| Yes-No | Probability | MC_BERNOULLI(p) |
| Custom | User-defined | Not imported. |
Note: Each MC_ function ends with MC_STATIC, which holds the value the cell shows outside a simulation and the assumption's name. For example: =MC_TRIANG(420,450,470,MC_STATIC(450,"Unit Price","")).
Check the import
Run the model in MonteGrid with the number of trials used in Crystal Ball. Compare the forecast statistics with the report. They differ within sampling error, because the two tools use different random numbers.
Define by hand each assumption that was not imported. Define the correlations with Define Correlation, as in Correlate assumptions.
Sources
- Oracle: Updated Compatible Versions of Microsoft Products (Crystal Ball 11.1.3)
- Microsoft: Options for using Windows 11 with Mac computers with Apple M1, M2, and M3 chips
- Apple: Install Windows 10 on your Mac with Boot Camp Assistant
- Oracle: Basic Steps for Creating Reports (Crystal Ball User's Guide)
- Oracle: Distribution Parameter Summary (Crystal Ball User's Guide)