Activity sheets exist in the Schedule Manager at the Program level. An activity sheet allows you to view, edit, and update activity dates across project and shells. The activity data is from the Master Schedule Sheets only.
For example, uParks Company has 1000 projects that fall within four categories. Four programs are created to manage the Schedule Sheet activities. Each program has its own Program Manager, controlling 250 projects. uParks has a finite number of resources and needs to stagger the work so resources can be used evenly over time. The Program Managers want to adjust their project forecast dates so that 20 projects will complete each month for the next 12 months (with 30 completing in month 12, so that all 250 are completed in a year). Using activity sheets, you can manage your project and shell data in this way.
Activity sheet terminology
- Activity Sheets: Used to view and update the Master Schedule Sheet data from projects and shells within Programs.
- Activity Code: A value in a Program activity sheet used to map to an activity in one or more projects or shells.
- Sub-columns:
- Columns grouped under an Activity Code
- Displays data from projects/shells
- Updates data in a project/shell
The activity sheet allows you to:
- Display and edit Master Schedule Sheets activity data across projects and shells as columns and sub-columns
- Modify editable elements
- Affects down stream dates of linked activities
- Start, Finish, Duration
- Estimated Start, Finish, Duration
- Critical path dates
Project or shell names form the rows of the activity sheet; the activity codes and activity data elements form the columns and sub-columns in the sheet. The activity sheet also allows you to update multiple activities after modifying and saving the activity sheet. This update automatically updates the downstream dates of linked activities, such as Start Date, Finish Date, Duration, Estimated Start Date, Estimated Finish Date, or other dates.
Note: In Cash Flow, Cost Sheet, and Earned Value, you can replace the Summary Sheet with the Activity Sheet as a source.