Viewing Assignment Unit and Cost Spreads

Use the spreadsheet to view live unit and cost spreads for an activity assignment for a resource or role.

To view the assignments usage spreadsheet:

1. On the Navigation Menu, expand Resources and click Assignments.
2. On the Assignments page:
   1. Click Spreadsheet View.

      Note:

      To customize the list of resources displayed in the table, click Customize View and either use an existing filter or add a new filter.

   2. Click Customize View and then click Spreadsheet.
   3. On the Spreadsheet tab of the Customize View dialog box:
      • Choose the columns to display in the view.
      • Choose the Start Date and Finish Date to define a range for the spreadsheet.
      • Select Calculate average for units and costs if you are dividing the unit and cost fields by a value, and then type a value in the Divide values by field.
      • Select a Timescale for the view.
   4. Click Apply.

Tip:

• P6 includes only data in spreads. To see up to date spread data, select Actions, Run, Store Period Performance and then ensure that the project has been republished.
• An application level setting determines whether cost spreads account for changes in resource and role rates over time.
• You can export the data on this page to a Microsoft Excel file by clicking Export.