Pasting results enables you to manually copy prediction results into a scenario on the form, for example a scenario named Forecast.
Tip: | If you want to save prediction data for later comparisons without overwriting other scenarios, special Prediction scenarios must be added to the form by an administrator or other user who is able to modify Planning forms before you use Predictive Planning. |
To paste prediction results into a scenario on the form:
Determine that a Prediction or other special scenario exists so you will not overwrite data in other scenarios.
Select one or more members to paste.
If you are using Microsoft Excel 2007 or later, click the bottom half of the Paste Results button and select from the listed options. (If you click the top half of Paste Results, the Paste Results dialog is displayed for the current member only; see step 3, following.)
If you are using Microsoft Excel 2003, select Paste Results in the Predictive Planning menu.
Select from the following:
Current Member—Pastes results for only the member that is currently selected in Results View
All Members—Pastes results for all predicted members; if present, filtering is ignored
Filtered Members—When filtering is active, pastes results for the current set of filtered members
Selected Members—Enables you to select members to paste
Select scenarios for pasting in the Paste Results dialog:
From—Lists all series in the current view that are available for pasting; select the one whose data will be copied
To—Lists all scenario/version combinations in the form; select the one to receive the pasted data
Prediction range—Select the first setting to use the entire prediction range or select the second and specify how many periods of data to use
Note:
If the prediction range overlaps the data range on the form, only the dates shown on the form are pasted.