This example resets the Crystal Ball simulation, selects a target forecast in cell A1, resets assumptions to the uncertainty list, adds cells to the variability list, specifies the number of trials for the uncertainty and variability simulations, specifies that only the target forecast chart should display, sets ouput options, sets the maximum number of uncertainty simulations to display in the ouput report and overlay chart to 75, and then runs the tool.
CB.ResetND ' Select target forecast [A1].Select '<- A1 must contain a forecast CB.TwoDSimulationND cbTwoDChooseTarget ' Set all assumptions to the uncertainty list CB.TwoDSimulationND cbTwoDChooseAssum, cbTwoDAssumClearList ' Set cells D3 and F9 to the Variability list [D3].Select CB.TwoDSimulationND cbTwoDChooseAssum, cbTwoDAddAssumVar [F9].Select CB.TwoDSimulationND cbTwoDChooseAssum, cbTwoDAddAssumVar ' Set the outer (uncertainty) simulation loop to 500 trials CB.TwoDSimulationND cbTwoDOuterSimTrials, 500 ' Set the inner (variability) simulation loop to 250 trials CB.TwoDSimulationND cbTwoDInnerSimTrials, 250 ' Set the forecast display to show only charts for the target forecast CB.TwoDSimulationND cbTwoDForeOption, cbTwoDShowTargetFore ' Set the report options to include forecast statistics and custom ' percentiles CB.TwoDSimulationND cbTwoDOutputOption, cbTwoDshowForeStat, True CB.TwoDSimulationND cbTwoDOutputOption, cbTwoDshowPercentiles, True CB.TwoDSimulationND cbTwoDPercent, cbTwoDPercentCustom, "F17:H17" ' Set the max number of uncertainty simulations to display in output to 75 CB.TwoDSimulationND cbTwoDMSDOption, 75 ' Run the 2D Simulation tool CB.Two2SimulationND cbTwoDRun