Displaying Resource Assignments in Spreadsheet Views
Open Plan allows you to display and, in some cases, update resource assignment information in a spreadsheet view.
Single-Table Spreadsheet Based on the Resource Assignment Table
In a single-table spreadsheet view based on the Resource Assignment table, the resource assignment information appears in a tabular format, with each assignment displayed in a single row.
In this type of view, you can add assignments in one of two ways. If the activity already has at least one assignment, you can edit the Resources tab of the Activity Details dialog box. You can also insert a new row in the spreadsheet and specify both the activity and the assigned resource. Activity/resource spreadsheets display multiple assignments for each activity using an outlining format.
Activity/Resource Spreadsheet
In an activity/resource spreadsheet view, Open Plan displays a plus (+) sign or a minus (-) sign on the outlining button to the left of the row to control the display of assignment information. If the outlining button displays a plus sign, you can expand the activity to see all of its assignments. If the outlining button displays a minus sign, the activity is already expanded, and clicking the outlining button will collapse the display of assignments. If the outlining button on an activity row is blank, the activity does not have any resource assignments.
In this type of view, you can display the Activity Details dialog box for an activity and edit the Resources tab.
Resource/Activity Spreadsheet
Resource/activity spreadsheets allow you to see multiple assignments for each resource. This type of view is used mainly for reporting purposes, but you can edit the Resources tab of the Activity Details dialog box for an activity.