Chapter 13. Tracking Progress on Tasks and Assignments
In this chapter, you will learn how to: | |
✓ | Update a previously saved baseline plan. |
✓ | Record actual work for tasks and assignments. |
✓ | Record actual work by time period. |
✓ | Interrupt work on a task and specify the date on which the task should start again. |
Tip
Do you need only a quick refresher on the topics in this chapter? See the Quick Reference entries in Tracking Progress on Tasks and Assignments.
Building, verifying, and communicating a sound project plan might take much or even most of your time as a project manager. However, planning is only the first phase of managing your projects. After the planning is completed, the implementation of the project starts—carrying out the plan that was previously developed. Ideally, projects are implemented exactly as planned, but this is seldom the case. In general, the more complex the project plan and the longer its planned duration, the more opportunity there is for variance to appear. Variance is the difference between what you thought would happen (as recorded in the project plan) and what really happened (as recorded by your tracking efforts).
Properly tracking actual work and comparing it against the original plan enables you to identify variance early and adjust the incomplete portion of the plan when necessary. If you completed Chapter 6, you were introduced to the simpler ways of tracking actuals in a project plan. These include recording the percentage of a task that has been completed as well as its actual start and finish dates. These methods of tracking progress are fine for many projects, but Microsoft Office Project 2007 also supports more detailed ways of tracking.
In this chapter, you track task-level and assignment-level work totals and work per time period, such as work completed per week or per day. Information distributed over time is commonly known as timephased, so tracking work by time period is sometimes referred to as tracking timephased actuals. This is the most detailed level of tracking progress available in Project.
As with simpler tracking methods, tracking timephased actuals is a way to address the most basic questions of managing a project:
Are tasks starting and finishing as planned? If not, what will be the impact on the project’s finish date?
Are resources spending more or less time than planned to complete tasks?
Is it taking more or less money than planned to complete tasks?
As a project manager, you must determine what level of tracking best meets the needs of your project plan and stakeholders. As you might expect, the more detailed the tracking level, the more effort required from you and the resources assigned to tasks. This chapter exposes you to the most detailed tracking methods available in Project.
In this chapter, you work with different means of tracking work and handling incomplete work. You begin, however, by updating the project baseline.
Tip
This tip describes enterprise project management (EPM) functionality. This chapter describes entering actual values directly in Project. Project Professional, when used with Project Server, offers more sophisticated ways of collecting information (such as actual work) from resources and other stakeholders. To learn more about the enterprise collaboration tools available with Project Server, see Part 4.
Important
Before you can use the practice files provided for this chapter, you need to install them from the book’s companion CD to their default locations. See "Using the Book’s CD" for more information.
Updating a Baseline
If you completed Chapter 6, you saved a baseline plan for a project plan. Recall that a baseline is a collection of important values in a project plan such as the planned start dates, finish dates, and costs of tasks, resources, and assignments. When you save (or set) a baseline, Project takes a “snapshot” of the existing values and saves it in the Project plan for future comparison.
Keep in mind that the purpose of the baseline is to record what you expected the project plan to look like at one point in time. As time passes, however, you might need to change your expectations. After saving an initial baseline plan, you might need to fine-tune the project plan by adding or removing tasks or assignments and so on. To keep an accurate baseline for later comparison, you have several options:
Update the baseline for the entire project. This simply replaces the original baseline values with the currently scheduled values.
Update the baseline for selected tasks. This does not affect the baseline values for other tasks or resource baseline values in the project plan.
Save a second or subsequent baseline. You can save up to 11 baselines in a single plan. The first one is called Baseline, and the rest are Baseline 1 through Baseline 10.
Tip
To learn more about baselines in Project’s online Help, type
Create a baseline into the Search box in the
upper right corner of the Project window. The Search box initially
contains the text Type a question for
help.
Since you completed the initial planning for the short film project and saved an initial baseline, the project plan has undergone some additional fine-tuning. This included some adjustments to assignments and task durations and a new task in the pre-production phase of the project. Because of these changes, the initial baseline does not quite match the project plan as it is currently scheduled. In this exercise, you compare the project plan as it is currently scheduled with the baseline plan and update the baseline for the project plan.
Important
If you are running Project Professional, you may need to make a one-time adjustment to use the My Computer account and to work offline. This ensures that the practice files you work with in this chapter do not affect your Project Server data. For more information, see "Starting Project Professional,”.
Note
OPEN Short Film Project 13a from the DocumentsMicrosoft PressProject 2007 SBSChapter 13 Advanced Tracking folder. You can also access the practice files for this book by clicking Start, All Programs, Microsoft Press, Project 2007 Step by Step, and then selecting the chapter folder of the file you want to open.
On the File menu, click Save As.
The Save As dialog box appears.
In the File name box, type Short Film Project 13 Baseline, and then click Save.
Next, you will switch to a different view to see baseline and scheduled values arranged for easy comparison.
On the View menu, click Tracking Gantt.
The Tracking Gantt view appears.
In the chart portion of this view, the tasks as they are currently scheduled appear as blue bars (if they are not critical tasks) or red bars (if they are critical). Below them, the baseline values of each task appear as gray bars.
Tip
In Gantt Chart views, the colors, patterns, and shapes of the bars represent specific things. To see what any item on the Gantt chart represents, just point your mouse pointer at it and a description will appear in a ScreenTip. To see a complete legend of Gantt chart items and their formatting, on the Format menu, click Bar Styles.
In the Task Name column, click the name of task 5, Review production boards.
On the Standard toolbar, click the Scroll To Task button.
The Tracking Gantt view scrolls to display the Gantt bars for task 5, Review production boards. This task was added to the plan after the initial baseline was saved.
As you can see in the Tracking Gantt view, this task has no baseline bar, indicating that it has no baseline values.
To conclude this exercise, you will resave the baseline for the project plan. Doing so will update all baseline information for tasks, resources, and assignments prior to tracking progress.
Tip
This project plan includes a previously saved baseline that you will now overwrite. That’s fine at this stage of the short film project, where the planning is complete and you’d like to have the most up-to-date baseline before recording any actual work. However, after work has been recorded, you should be careful about overwriting any previously saved baseline values. Once you overwrite a baseline, the original values are replaced and cannot be retrieved. Saving additional baselines is usually a better strategy after work on the project has begun.
On the Tools menu, point to Tracking, and then click Set Baseline.
The Set Baseline dialog box appears.
Make sure that the Set Baseline option is selected. In the For area, make sure that the Entire project option is selected.
Tip
To update a baseline just for selected tasks, click Selected Tasks in the For area. When you do this, the options under Roll Up Baselines become available. You can control how baseline updates should affect the baseline values for summary tasks. For example, you could resave a baseline for a subtask and update its related summary task baseline values if desired. To remove a baseline, on the Tools menu, point to Tracking, and then click Clear Baseline.
Click OK to update the baseline.
Project alerts you that you are about to overwrite the previously saved baseline values.
Click the Yes button.
Project updates the baseline values for the project plan.
Task 5 now has a baseline, and all of the other tasks’ baseline values now match their scheduled values.
On the Standard toolbar, click Save.
On the File menu, click Close to close the project plan.
Tracking Actual and Remaining Values for Tasks and Assignments
If you completed Chapter 6, you entered actual start, finish, and duration values for individual tasks. For tasks that have resources assigned to them, you can enter actual and remaining work values for the task as a whole or for specific assignments to that task. To help you understand how Project handles the actual values you enter, consider the following:
If a task has a single resource assigned to it, the actual work values you enter for the task or assignment apply equally to both the task and the resource. For example, if you record that the assignment started on March 21 and has five hours of actual work, those values apply to the task as well.
If a task has multiple resources assigned to it, the actual work values you enter for the task are distributed among or rolled down to the assignments according to their assignment units. This level of detail is appropriate if you aren’t concerned about the details at the individual assignment level.
If a task has multiple resources assigned to it, the actual work values you enter for one assignment are rolled up to the task. However, the new actual work values do not affect the other assignments’ work values on the task. This level of detail is appropriate if details at the individual assignment level are important to you.
In this exercise, you record task-level and assignment-level actuals and see how the information is rolled up or down between tasks and assignments.
Note
OPEN Short Film Project 13b from the DocumentsMicrosoft PressProject 2007 SBSChapter 13 Advanced Tracking folder. You can also access the practice files for this book by clicking Start, All Programs, Microsoft Press, Project 2007 Step by Step, and then selecting the chapter folder of the file you want to open.
On the File menu, click Save As.
The Save As dialog box appears.
In the File name box, type Short Film Project 13 Actuals, and then click Save.
This version of the project plan includes the updated baseline values you previously saved, as well as the first actuals reported against the first pre-production task.
On the View menu, click Task Usage.
The Task Usage view appears. The two sides of the usage view are split by a vertical divider bar. The Task Usage view lists resources under the tasks to which they’re assigned. This information appears in the table on the left side. On the right side, you see rows organized under a timescale. The rows on the right side show you the scheduled work values for each task (for the task rows) or resource assignments (for assignment rows) on the left side. The scheduled work values for each resource are the timephased values of the assignments. The Task Usage view color-codes the rows on the right side: task rows have a yellow background, and assignment rows have a white background.
In the Task Name column, click the name of task 3, Develop script breakdown and schedule.
On the Standard toolbar, click the Scroll To Task button.
The timephased grid on the right side of the view scrolls to display the first scheduled work for the task.
Next, you’ll switch the table and details shown in the view.
On the View menu, point to Table: Usage, and then click Work.
The Work table appears.
This table includes the Actual Work and Remaining Work columns that you will work with shortly, although they might not yet be visible. The values in the Work column are the task and assignment totals for scheduled work. Note that each task’s work value is the sum of its assignment work values. For example, the work total for task 2, 40 hours, is the sum of Clair Hector’s 24 hours of work on the task and Scott Cooper’s 16 hours.
Next, you’ll change the details shown on the timephased grid on the right side of the view.
On the Format menu, point to Details, and then click Actual Work.
For each task and assignment, Project displays the Work and Actual Work rows on the timephased grid on the right side of the view.
Tip
You can change the details (that is, fields) shown under the timescale in a usage view. You can add or remove fields and change the formatting of the fields shown. For example, you can add the Baseline Work field to the fields shown in the usage view and format it with a different colored background. To see the available fields and formatting options, on the Format menu, click Detail Styles, and then click the Usage Details tab.
In the timephased grid, you see the scheduled work values per day. If you were to add up the daily work values for a specific task or assignment, the total would equal the value in the Work column for that task or assignment. In a usage view, you see work values at two different levels of detail: the total value for a task or assignment and the more detailed timephased level. These two sets of values are directly related.
Next, you’ll enter task-level and assignment-level actual work values and see how they are reflected in the timephased details.
Using the mouse, drag the vertical divider bar to the right until you can see all of the columns in the Work table.
In the Actual column for task 3, Develop script breakdown and schedule, type or click 42h, and then press
.Several important things occurred when you pressed Enter:
Project applied change highlighting to the updated values in the table.
The amount of actual work you entered was subtracted from the Remaining column.
The actual work was distributed to the three assignments on the task, resulting in 14 hours of actual work being recorded for each resource. Likewise, the updated remaining work value was recalculated for each assignment.
The updated actual and remaining work values were rolled up to the pre-production summary task.
The actual work values were also redistributed to the task and assignment timephased values.
In the timephased grid side of the view, you can observe the daily scheduled work and actual work values for the three resources on Friday and Monday, March 7 and 10. Because you entered an actual work value for the entire task, Project assumes that the work was done as scheduled (eight hours of scheduled work per resource on Friday and six hours on Monday) and records these timephased values for the resources.
To conclude this exercise, you will enter assignment work values and see the effect on the task.
In the Actual column for Clair Hector’s assignment to task 3, type or click 30h, and then press
.Clair Hector’s actual and remaining work values are updated, and those updates also roll up to the task and its summary task (Project highlights the changed values). However, the actual and remaining work values for the other two resources assigned to the task are not affected.
Drag the vertical divider bar back to the left to see the updated timephased values for the task.
Again, Project assumes that the actual work value you entered for Clair was completed as scheduled; therefore, her work and actual work timephased values match through Wednesday, March 12.
On the Standard toolbar, click Save.
On the File menu, click Close to close the project plan.
Tip
You are entering actual work values in this exercise, but you can also enter remaining work values or percentage of work complete. All of these values are related to each other—a change to one affects the others. You can update these values in the Work table or on the Tracking tab of the Assignment Information dialog box (when an assignment is selected).
Tracking a task’s actual work complete value is more detailed than entering a simple percentage complete on a task. However, neither method is as detailed as entering timephased actual work for tasks or assignments (as you will see in the next section). There’s nothing wrong with tracking actual work at the task or assignment level (or simply entering a percentage complete, for that matter) if that level of detail meets your needs. In fact, whether you see the timephased details or not, Project always distributes any percentage complete or task-level or assignment-level actual work value that you enter into corresponding timephased values, as you saw earlier. This is one reason why new Project users sometimes are surprised to encounter extremely detailed values, such as 1.67 hours of work, scheduled for a particular day. If you generally understand the math that Project is following, however, you can figure out where such numbers come from. On the other hand, you might not care about this level of scheduling detail—and that’s OK, too.
Tracking Timephased Actual Work for Tasks and Assignments
Entering timephased actuals requires more work on the project manager’s part and might require more work from resources to inform the project manager of their daily actuals. However, doing so gives you far more detail about the project’s task and resource status than the other methods used for entering actuals. Entering timephased values might be the best approach to take if you have a group of tasks or an entire project that includes the following:
High-risk tasks
Relatively short-duration tasks in which a variance of even one day could put the overall project at risk
Tasks for which you’d like to develop or validate throughput metrics, or rates at which a given quantity of a deliverable can be completed over a given time period, such as “paint two set backdrops per day”
Tasks in which sponsors or other stakeholders have an especially strong interest
Tasks that require hourly billing for labor
At this point in the short film project, the pre-production work has been completed, and the production phase has just begun. Because of the large number of resources involved, the high setup and teardown costs, and the limited availability of sites at which some scenes must be filmed, these tasks are the riskiest ones of the project. In this exercise, you enter daily actuals for production tasks in the Task Usage view.
Note
OPEN Short Film Project 13c from the DocumentsMicrosoft PressProject 2007 SBSChapter 13 Advanced Tracking folder. You can also access the practice files for this book by clicking Start, All Programs, Microsoft Press, Project 2007 Step by Step, and then selecting the chapter folder of the file you want to open.
On the File menu, click Save As.
The Save As dialog box appears.
In the File name box, type Short Film Project 13 Timephased Actuals, and then click Save.
Click the minus sign next to task 1, Pre-Production, to collapse this phase of the project plan.
In the Task Name column, click the name of task 26, Scene 7 setup, and then, on the Standard toolbar, click Scroll To Task.
Project scrolls the timephased grid to display the first scheduled work values of the Production phase.
The first timephased actual work values you will enter are at the task level and not for specific assignments.
In the timephased grid, click the cell at the intersection of the Monday, May 26 column and the task 26 actual work row. The actual work row is directly below the work row, which contains the value 20h.
Tip
If you point to the name of a day on the timescale, Project will display the full date of that day in a ScreenTip.
You can change the formatting of the timescale to control the time period in which you enter actual values in the timephased grid. For example, you can format the timescale to show weeks rather than days; when you enter an actual value at the weekly level, that value is distributed over the week. For more information about adjusting the timescale, type Change the timescale to see a different level of detail into the Search box in the upper right corner of the Project window.
Type 5h, and then press the
key.As soon as you entered the first actual value for the task, the scheduled work value changed to match it. Both work and actual work values rolled up to the task and summary task levels and were distributed among the specific assignments to the task. You can see this happen in the timephased grid on the right and the table on the left.
In the Tuesday, May 27 actual work cell, type 15h, and then press
.That step concludes the actual work for this task. Next, you’ll enter actual work values for the assignments on the next task.
For task 27, Scene 7 rehearsal, you have the actual work values for several resources for Tuesday and Wednesday, May 27 and 28.
If necessary, use the scroll bars to show that all of the assignments to task 27 are visible.
In the timephased grid, click the cell at the intersection of the Tuesday, May 27 column and Jan Miksovsky’s actual work row for her assignment to task 27.
Enter the following actual work values into the timescale grid.
Tip
When entering actual work, you do not need to include the “h” abbreviation (to denote hours). You can simply enter the number and Project will record it as hours. Hours is the default work value for data entry. If you wish, you can change this on the Schedule tab of the Options dialog box (Tools menu).
Resource Name
Tuesday’s Actual Work
Wednesday’s Actual Work
Jan Miksovsky
3h
5h
Jo Brown
3h
5h
Joseph Matthews
2h
7h
Paul Borm
3h
1h
Scott Cooper
4h
8h
Sue Jackson
2h
6h
Again, the individual resources’ actual work values were rolled up to the tasks’ actual work values. The original work values are also saved in the baseline should you ever need to refer to them later.
On the Standard toolbar, click Save.
On the File menu, click Close to close the project plan.
Tip
In this exercise, you have seen how task and assignment values are directly related; an update to one directly affects the other. However, you can break this relationship if desired. Doing so enables you to record progress for resource assignments, for example, and manually enter actual values for the tasks to which those resources are assigned. You normally should not break this relationship unless you have special reporting needs within your organization—for example, you must follow a status reporting methodology based on something other than the actual values recorded for assignments in project plans. To break this relationship, on the Tools menu, click Options. On the Calculation tab of the Options dialog box, clear the Updating Task Status Updates Resource Status check box. This setting applies to the entire project plan that you have open at the time; you cannot apply it to only some tasks within a project plan.
When you need to track actual work at the most detailed level possible, use the timephased grid in the Task Usage or Resource Usage view. In either view, you can enter actual work values for individual assignments daily, weekly, or at whatever time period you want (by adjusting the timescale). For example, if a task has three resources assigned to it and you know that two resources worked on the task for eight hours one day and the third resource worked for six hours, you can enter these as three separate values on a timephased grid.
If your organization uses a timesheet reporting system for tracking actual work, you might be able to use this timesheet data in Project as timephased actuals. You might not need to track at this level, but if resources complete timesheets for other purposes (billing other departments within the organization, for example), you can use their data and save yourself some work.
Rescheduling Incomplete Work
During the course of a project, work might occasionally be interrupted for a specific task or for the entire project. Should this happen, you can have Project reschedule the remaining work to restart after the date you specify.
When you reschedule incomplete work, you specify the date after which work can resume—the rescheduled date. Here is how Project handles tasks in relation to the rescheduled date:
If the task does not have any actual work recorded for it prior to the rescheduled date and does not have a constraint applied, the entire task is rescheduled to begin after that date.
If the task has some actual work recorded prior to but none after the rescheduled date, the task is split so that all remaining work starts after the rescheduled date. The actual work is not affected.
If the task has some actual work recorded for it prior to as well as after the rescheduled date, the task is not affected.
At this point in the short film project, work on the first two scenes has been completed, and the team has just started work on the next scheduled scene, Scene 1. In this exercise, you troubleshoot a delay in work caused by a problem at the studio.
Note
OPEN Short Film Project 13d from the DocumentsMicrosoft PressProject 2007 SBSChapter 13 Advanced Tracking folder. You can also access the practice files for this book by clicking Start, All Programs, Microsoft Press, Project 2007 Step by Step, and then selecting the chapter folder of the file you want to open.
On the File menu, click Save As.
The Save As dialog box appears.
In the File name box, type Short Film Project 13 Reschedule, and then click Save.
The project plan is currently in the Task Usage view. Next, you’ll switch to the Gantt Chart view.
On the View menu, click Gantt Chart.
In the Task Name column, click the name of task 38, Scene 1 setup.
On the Standard toolbar, click the Scroll To Task button.
The Gantt Chart view scrolls to display the Gantt bar for task 38, Scene 1 setup. Currently, this task has one day of actual work completed and two days of scheduled work remaining.
Scroll the Gantt Chart view up so that the Scene 1 summary task (task 37) appears near the top of the view.
You have learned that over the weekend of June 14, a water pipe burst in the studio where Scene 1 was to be shot. None of the project’s equipment was damaged, but the cleanup will delay work through Wednesday, June 18. This effectively stops work on the production tasks for a few days. Next, you will reschedule incomplete work so that the project can begin again on Thursday.
On the Tools menu, point to Tracking, and then click Update Project.
The Update Project dialog box appears.
Select the Reschedule uncompleted work to start after option, and in the date box, type or select 6/18/08.
Click OK to close the Update Project dialog box.
Project splits task 38 so that the incomplete portion of the task is delayed until Thursday.
As you can see, although the duration of task 38 remains at three days, its finish date and subsequent start dates for successor tasks have been pushed out. Although we have addressed a specific problem, in doing so, we have created other problems in the remainder of the project. You will address this and other problems in the project plan in later chapters.
Key Points
Saving a baseline saves a large set of task, resource, and assignment values in a project plan. Saving an interim plan, however, saves only the start and finish dates of tasks.
If you track work at the task level, work rolls down to the assignments. Conversely, if you track work at the assignment level, work rolls up to the task level.
In usage views, you can change the time increments on the lower tier of the timescale to match the time period against which you wish to track. For example, if you wish to record actual work as full weeks, you can set the timescale to display weeks on the lower tier.
Should work on a project be interrupted for some reason, you can reschedule the work to begin again on the date you specify.