Step 2: Define Output Forecasts

A forecast is a statistical summary of the assumptions in a spreadsheet model, output graphically or numerically. To display as a range of values instead of a single value, forecast cells should relate to assumption cells in some way.

  To define forecasts in Crystal Ball EPM:

  1. In the Strategic Finance Worksheet under Output Forecasts, select a cell or a range of cells.

  2. Select Define, and then Define Forecast, or click Define Forecasts icon.

  3. In the Define Forecast dialog, enter the requested information.

    To expand the dialog, click More button (Ctrl +)to the right of Name .

  4. On the Forecast Window, Precision, Filter, and Auto Extract tabs, set forecast preferences.

  5. Click OK.

  Click here for Step 3: Run the Simulation.