The Activity Usage Spreadsheet

The Activity Usage Spreadsheet displays activity data in a spreadsheet format. View baseline, budgeted or planned, actual, remaining, and at completion values or review information such as earned value cost, actual labor and nonlabor units, and remaining total cost for the activities in your project.

Display the Activity Usage Spreadsheet in the top or bottom layout of the Activities window.

Use the Activity Usage Spreadsheet to

• Quickly analyze activity data
• Filter activities
• Group and sort activity data

The Activity Usage Spreadsheet is split into two panes. The left pane displays the Activity Table, including all the columns, grouping, sorting, and filtering options defined for the Activity Table. The right pane displays timescaled spreadsheet data for each activity; you can specify the data fields you want to include.

Tip

• You can display past period actual values in the Activity Usage Spreadsheet. In the right pane of the bottom layout, click the Display Options bar and choose Spreadsheet Fields, Customize. The available past period actual fields are listed in the Financial Period Value section for both Cumulative and Time Interval. If the Financial Period Value section is not available in the Columns dialog box, you must specify the range of financial periods available for display as columns on the User Preferences, Application tab. When displaying Financial Period Value fields, past period actuals stored per financial period are distributed evenly, within each financial period, from the financial period start date to the financial period end date and earned value calculations are based on these stored period quantities. For all other columns, actuals are spread evenly from the actual start to the data date or actual finish date of the activity or assignment.

Notes

• You cannot change the data in the Activity Usage Spreadsheet.
• Multiple resource rates are not reflected in the Activity Usage Spreadsheet.
• When you display a financial period timescale and display data for all projects (rather than for open projects only), activity and resource data must be summarized by financial period to accurately display data for closed projects.

When connected to a P6 Professional database: If you have administrator rights, to ensure that activity and resource data is summarized by financial period when you summarize projects, choose Admin, Admin Preferences, select the Options tab, then mark the 'By financial periods' checkbox.

When connected to a P6 EPPM database: If you have administrator rights, to ensure that activity and resource data is summarized by financial period when you summarize projects, use the Application Settings, General link in P6, then mark the 'By financial periods' checkbox.

Related Topics

Display the Activity Usage Spreadsheet

Define the range of financial periods to display in columns