Future Target Data Entry 
You can enter future target data using an Excel spreadsheet. Target data is defined as the period range from the current period of the PAS model date range through the end date as long as the end date is later than the current period.
Note
There is no workflow control over any data entered via this spreadsheet.
Prerequisites
The Target Data link may or may not be visible, depending on defaults settings determined by the Entry and Approval administrator.
The Entry and Approval administrator has set the date range to be completed later than the current period.
A metric set cannot have more than 500 rows. If a metric set exceeds that number of rows, the Target Data link is disabled for the metric set, even if you have permission to enter target data.
You have permission to enter future target data and you can see the Target Data link in the Entry and Approval main window. Entry and Approval administrators activate this option by selecting Input historical data (actual and target) in Set Entry and Approval Defaults. Entry and Approval administrators always have permission to enter historical data, regardless of the settings.
Features
Future target data entry has these features:
For the current period and each future period, you enter target data in the Target column. The Actual column has a gray background in the worksheet, and you cannot enter any actual data.
If you have many rows, the Sort Rows option lets you organize the rows by column to find the metrics.
The Excel spreadsheet acts as a template that holds the data temporarily until it is passed to Entry and Approval.
The worksheet heading displays information about the metric set, the start date and end date of the entire period, and the current period.