When you run a prediction, you can paste predicted results into a Microsoft Excel worksheet in two ways:
As forecast values — base prediction values.
As “random walk” formulas that can be used to simulate future values within the prediction interval in a Crystal Ball simulation. (When not running a simulation, the formulas will be set to show the base prediction values.)
Note:
This feature is available in Crystal Ball 11.1.2.4.400 and later. For information on these new features and on updating to 11.1.2.4.400 or later, see the Crystal Ball Readme for the target release and My Oracle Support.
To paste prediction data into a worksheet:
In the Predictor Results window, set Periods to forecast to the number of time periods to paste into the worksheet.
Select from among these settings in the Paste Forecasts to Spreadsheet dialog:
Location
At end of historical data—Pastes predicted data after the historical data
Starting at cell—Pastes data in the specified cell and following cells; select a range to paste multiple data series
Note:
Data is pasted below or to the right of the specified cell, depending on the Orientation selection.
Paste as
Forecast values—The base prediction values
Random walk formulas—Formulas that refer to assumption cells on a separate support sheet for use in simulations
Options
Include date series—Pastes date labels next to predicted values
AutoFormat—Formats data to match the numeric formatting of the data series and highlights forecasts in bold.
The results are pasted at the specified location. Predictor uses the results from the currently selected BEST method shown in the Results window (unless you overrode the BEST method with a different method.).
Note: | Of the eight classic time-series forecasting methods, two result in flat lines: single moving average and single exponential smoothing. The predicted values for these are all the same. This result is not an error. It is the best possible forecast for volatile or patternless data. |