MonteGrid | Tutorials | Set up run settings

Set up run settings

Review the run settings and run the model with 10,000 trials. The next tutorial reads this run.

  1. 1Open the Run page

    Continue with the workbook from Correlate assumptions, or download it below. On the MonteGrid tab, click Run Settings. The Run page opens.

    capital-budgeting.xlsx

    capital-budgeting
    HomeInsertDrawPage LayoutFormulasDataReviewViewAutomateMonteGrid
    DefineAssumption DefineForecast ClearDefinition DefineCorrelation ImportDefinitions
    Run Stop RunSettings
    CreateReport ExtractData OpenMonteGrid
    A1 Input
    ABCDEF
    1 InputValueUnit
    2 Capital cost120.0$M
    3 Year 1 volume200.0thousand units
    4 Volume growth per year3.0%%
    5 Unit price, year 1450.0$
    6 Price change per year-1.0%%
    7 Variable cost per unit250.0$
    8 Fixed cost per year18.0$M
    9 Tax rate25.0%%
    10 Discount rate9.0%%
    11 Plant life10years
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    AboutInputsCash FlowSummary
    ReadyAccessibility: Good to go
    MonteGrid
    The Run page.
    The Run page.
    The Run page.
    The Run page. Open full size
  2. 2Run settings

    SettingDefaultDescription
    Trials5,000Number of trials.
    Random seed20260802The same model, settings and seed give the same results.
    Sampling methodMonte CarloMonte Carlo, Latin Hypercube (random), Latin Hypercube (median) or Quasi-Monte Carlo (Sobol).
    Run modeFast (MonteGrid's engine)MonteGrid's engine calculates the workbook. The alternative, Excel (Excel recalculates each trial), runs each trial in Excel.
    Default group correlation0.6Coefficient of a correlation group that has none of its own. 0 turns it off.
    Precision controlOffStops the run when a statistic of every forecast is known within a tolerance.

    Note: If MonteGrid's engine cannot calculate a formula, the run falls back to Excel. About this run on the Results page names the cell.

    Note: MonteGrid stores the run settings. They are not saved with the workbook.

  3. 3Run 10,000 trials

    1. Enter 10000 in Trials.
    2. Click Run.

    When the run ends, the Results page opens.

    NPV ($M)5,000 trials10,000 trials
    P10-42.76-43.70
    P505.115.26
    P9059.3058.32
    SD40.4740.39
    The NPV forecast after 10,000 trials.
    The NPV forecast after 10,000 trials. Open full size
  4. 4Precision control

    Precision control stops the run when the chosen statistic of every forecast is known within the tolerance at 95% confidence, or at the maximum number of trials. It requires Monte Carlo sampling.

    To use precision control:

    1. Select Precision control. Trials becomes Trials (at most).
    2. In Statistic, select Mean or Percentile. For Percentile, enter the percentile.
    3. Enter the tolerance in Tolerance (%).
    4. Click Run.

    Last run shows the number of trials run, of the maximum, followed by (precision reached).

All tutorials