MonteGrid | Articles | Share MonteGrid results with colleagues on Windows
Share MonteGrid results with colleagues on Windows
MonteGrid runs on a Mac. Colleagues on Windows read its results in the report and trial data workbooks, which contain no MonteGrid functions.
Updated
What the workbook contains
A MonteGrid workbook contains the definitions: assumptions as MC_ distribution functions, forecasts as MC_OUTPUT, correlation groups in MC_STATIC, and correlation matrices as blocks of cells. MonteGrid stores the run settings and the results. They are not saved with the workbook.
The MC_ functions are defined by MonteGrid. In Excel without MonteGrid, each defined cell shows #NAME?, and the cells that depend on it show errors.
What to send
| Colleague | Send | Contents |
|---|---|---|
| MonteGrid on a Mac | The workbook and the run settings. | The same model, settings and seed give the same results. |
| Excel on Windows | The MC Report workbook. | Run preferences and statistics; for each forecast, a chart, statistics and percentiles; the tornado and sensitivity tables and charts; the parameters of each assumption. No MC_ functions. |
| Excel on Windows, for further analysis | The MC Data workbook. | One row per trial: the trial number, the sampled value of each assumption and the value of each forecast. No MC_ functions. |
The MC Report workbook uses the layout of a Crystal Ball report, so Crystal Ball users on Windows read it as they read their own reports.
To create the workbooks, click Create Report or Extract Data on the Results page. The procedure is in Review the results and Share a model.
Note: MonteGrid writes both workbooks to Excel's own folder. When it writes a new one, it deletes its earlier ones that are more than seven days old. Save a copy elsewhere before you send it.
Colleagues who move to a Mac
A colleague with a Crystal Ball or @RISK model can bring it into MonteGrid: MonteGrid imports Crystal Ball definitions from a full report and converts @RISK functions in place. See Oracle Crystal Ball on a Mac and Lumivero @RISK on a Mac.