MonteGrid | Tutorials | Share a model
Share a model
Send the model to colleagues with or without MonteGrid.
-
1What the workbook contains
The 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.
To start here, download the finished model:
HomeInsertDrawPage LayoutFormulasDataReviewViewAutomateMonteGridB5 =MC_TRIANG(420,450,470,MC_STATIC(450,"Unit Price",""))A B C D E F G H I J K L M 1 Input Value Unit 2 Capital cost 120.0 $M 3 Year 1 volume 200.0 thousand units 4 Volume growth per year 3.0% % 5 Unit price, year 1 450.0 $ 6 Price change per year -1.0% % 7 Variable cost per unit 250.0 $ 8 Fixed cost per year 18.0 $M 9 Tax rate 25.0% % 10 Discount rate 9.0% % 11 Plant life 10 years 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 AboutInputsCash FlowSummaryReadyAccessibility: Good to goThe unit price formula. HomeInsertDrawPage LayoutFormulasDataReviewViewAutomateMonteGridB5 =MC_TRIANG(420,450,470,MC_STATIC(450,"Unit Price",""))A B C D E F 1 Input Value Unit 2 Capital cost 120.0 $M 3 Year 1 volume 200.0 thousand units 4 Volume growth per year 3.0% % 5 Unit price, year 1 450.0 $ 6 Price change per year -1.0% % 7 Variable cost per unit 250.0 $ 8 Fixed cost per year 18.0 $M 9 Tax rate 25.0% % 10 Discount rate 9.0% % 11 Plant life 10 years 12 13 14 15 16 17 18 AboutInputsCash FlowSummaryReadyAccessibility: Good to go -
2Colleagues with MonteGrid
Send the workbook and the run settings. With the same model, settings and seed, MonteGrid gives the same results. For this model: 10,000 trials, seed 20260802, Monte Carlo sampling.
-
3Colleagues without MonteGrid
The MC_ functions are defined in the MonteGrid add-in. Without it, Excel shows #NAME? in the defined cells and errors in the cells that depend on them. Send the MC Report workbook instead. It contains no MC_ functions.
Note: Workbooks downloaded from asunder.co also define the MC_ functions as LAMBDA names, so Microsoft 365 shows their base case without MonteGrid. MonteGrid removes these names when it first runs the workbook.
HomeInsertDrawPage LayoutFormulasDataReviewViewAutomateMonteGridB5 =MC_TRIANG(420,450,470,MC_STATIC(450,"Unit Price",""))A B C D E F G H I J K L M 1 Input Value Unit 2 Capital cost #NAME? $M 3 Year 1 volume #NAME? thousand units 4 Volume growth per year #NAME? % 5 Unit price, year 1 #NAME? $ 6 Price change per year -1.0% % 7 Variable cost per unit #NAME? $ 8 Fixed cost per year #NAME? $M 9 Tax rate 25.0% % 10 Discount rate 9.0% % 11 Plant life 10 years 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 AboutInputsCash FlowSummaryReadyAccessibility: Good to goThe workbook without MonteGrid. HomeInsertDrawPage LayoutFormulasDataReviewViewAutomateMonteGridB5 =MC_TRIANG(420,450,470,MC_STATIC(450,"Unit Price",""))A B C D E F 1 Input Value Unit 2 Capital cost #NAME? $M 3 Year 1 volume #NAME? thousand units 4 Volume growth per year #NAME? % 5 Unit price, year 1 #NAME? $ 6 Price change per year -1.0% % 7 Variable cost per unit #NAME? $ 8 Fixed cost per year #NAME? $M 9 Tax rate 25.0% % 10 Discount rate 9.0% % 11 Plant life 10 years 12 13 14 15 16 17 18 AboutInputsCash FlowSummaryReadyAccessibility: Good to go