An activity sheet captures scheduling data from the mapped P6 projects and role and resource rates from the company-level Master Rate Sheet (default) or shell-level rate sheets, and calculates the Earned Values metrics and derivatives. It is the primary source of data for the Earned Value Analysis.
The Activity Sheet node contains a list of activity sheets listed in the Activity Sheets log window. You can have have multiple activity sheets.
After P6-Unifier integration has been run and P6 projects mapped in the Integration tab of shell details, a single activity sheet can be created in the Activity Sheets log of the shell. (Shell > User mode > Activity Manager > Activity Sheet > Activity Sheets log)
Each P6 project is associated with a baseline project sheet and a current schedule project sheet. The activity sheet allows you to switch between baseline and current project types and view the specific scheduling information – activities, assignments, dates, etc.
Notes:
- Once produced, the baseline project sheet cannot be altered; however, you can update the current project sheet, per Data Date.
- If you update the project baseline in p6, then the project baseline will get updated in Unifier (when running the sync by selecting the Baseline option for the respective project).
P6 projects in the activity sheet are classified as:
Duration Based projects
Duration Based projects bring activity duration data only. They do not include resource assignment or cost related information, and are, therefore, not available for Earned Value analysis.
Resource Loaded projects
Resource Loaded projects load duration and resource assignment information, but no cost related information from P6. In Unifier, you can assign rate sheet and costing to calculate resource costs in the projects. After costing is completed, they are available for Earned Value analysis.
Cost Loaded projects
Cost Loaded projects bring duration, resource assignment as well as cost information from P6. No further cost calculation is necessary. You can directly use the Earned Value module for cost comparisons and analyses in these projects.
After integration, data brought in to the Activity Sheet are constrained by project categories and the constrains govern the behavior of the Activity Sheet.
In Unifier, we use the Schedule type for defining the projects, and it is displayed as:
Resource | The Activity Sheet receives the entire duration based information from P6 The Activity Sheet receives the entire resource assignment related information (Not always) The Activity Sheet receives the entire cost related information The Activity Sheet is available as a source for Cash Flow and Cost Sheet The Activity Sheet has all cost related feature (Assign rate sheet and Recost) The Activity Sheet is available for Earned Value Analysis |
---|---|
Cost | The Activity Sheet receives the entire duration based information from P6 The Activity Sheet receives the entire resource assignment related information The Activity Sheet receives the entire cost related information The Activity Sheet is available as a source for Cash Flow and Cost Sheet The Activity Sheet does not have any cost related feature (Assign rate sheet and Recost) The Activity Sheet is available for Earned Value Analysis |
Duration (without 'Based') | The Activity Sheet receives duration based information from P6 (Not always) The Activity Sheet receives resource assignment related information (Not always) The Activity Sheet receives cost related information The Activity Sheet is not available as a source for Cash Flow and Cost Sheet The Activity Sheet does not have any cost related feature (Assign rate sheet and Recost) The Activity Sheet is not available for Earned Value Analysis |
When you click on the Activity Sheet node the Activity Sheets log opens. The following explains the Activity Sheets log.