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.

Related Topics

Resource Assignments

About Resource Assignments

About Assignments Views

Working with Resource Assignments in the Gantt Chart

Assigning a Resource to an Activity Assignment

Assigning Resource Curves to Resource or Role Assignments from the Resources Assignments Page

About Future Period Planning

About Store Period Performance


Last Published Wednesday, April 1, 2026