You can use the Auto Extract tab of the Forecast Preferences dialog to specify which statistics to extract automatically to Microsoft Excel after the simulation stops.
The Auto Extract settings create tables of unformatted statistics primarily for use in other analyses. To extract formatted data, see Extracting Data.
You can select from the following settings:
Extract forecast statistics automatically to your spreadsheet when the simulation stops — Activates the auto-extract feature.
[listbox] — The list of statistics you can extract. Select the statistics you want, then use the up and down arrows to rearrange their order, if you want.
Note: | All statistics are calculated from trial values except Fitted Parameters. These are the distribution parameters calculated if distribution fitting is selected on the Forecast Window tab of the Forecast Preferences dialog. For details, see “Extracting Fitted Parameters” later in this topic. |
Starting Cell — The first cell on the forecast’s worksheet where the statistics will be copied. Be sure no data entries are displayed to the right of this cell and below it because data could be overwritten without warning.
Formatting — Whether to include labels on the extracted statistics and use Microsoft Excel’s AutoFormat for the cells.
Direction — Whether the extraction proceeds vertically (downward) or horizontally (to the right) on the worksheet.
Click OK to apply settings on the current tab to the active forecast. Or, you can click Apply To to apply settings on the active tab to the active worksheet, the active workbook, or all workbooks. At any time, you can click Defaults to restore the original default settings on the active tab in the dialog.
To automatically extract parameters for a distribution fitted to a forecast:
Select Fit a probability distribution to the forecast on the Forecast Window tab of the Forecast Preferences dialog.
Click the Auto Extract tab of the Forecast Preferences dialog.
In the Fitted Parameters dialog, select one or more types of information to extract:
Distribution name—The name of the distribution that was fitted to the forecast, such as normal or lognormal
Distribution identifier—The unique integer that identifies the distribution in the Crystal Ball developer kit, primarily for developer kit users (see “CB.DefineAssumND” in Chapter 3 of the Oracle Crystal Ball Developer's Guide).
Parameters—The parameters of the fitted distribution, such as mean or standard deviation