Entering Future Target Data

Procedure

  1. In the Entry and Approval main window, from the Database dropdown list, choose the model.
  2. In the Measure Sets table, click Target Data to display the Measure Sets dialog box.
  3. Choose the measure set for which you are adding target data and click OK.

    If you do not see the measure set listed, it means that the measure set has no target measures assigned.

  4. At the username and password prompts, specify your Web authentication username and password and click OK.
  5. At the Excel Data Entry logon, specify your Web authentication username and password and click OK. The target worksheet opens.
  6. Use the Target column to enter your data.

    If you have many rows, click Sort Rows to organize the rows by column to find the measures for which you are entering data.

  7. Do one of the following depending on whether you enter all your data during the current session:

    • If you have entered all your data, click Save Data to save your changes Then, select Start of the navigation pathFile Next navigation step ExitEnd of the navigation path to close the spreadsheet. When prompted to save the Excel spreadsheet, click No.

    • The Save Data functionality is valid only when the worksheet is opened from the Entry and Approval application. If you have not entered all your data during the current session, you still may want to click Save Data to upload your work to the server. The saved data is available the next time the worksheet opens from the application. You can create a local copy of the data entry worksheet but it is a reference version only. If you do not want to save your initial work to the server, you can copy from the local version to a new worksheet opened from the Entry and Approval application.