Manually Entering Task Progress in Microsoft Project

Overview

If you are a project manager who manages desktop-only projects with Microsoft Project, you need to know how to manually enter task progress in your project schedules. And if you are a project manager in an organization that uses Project Online or Project Server, but your organization does not use the Timesheet page or Tasks page in Project Web App, you also need to know how to manually enter task progress in your project schedules.

Although there are a number of methods for manually entering task progress in a Microsoft Project schedule, I recommend only two approaches to keep the process as simple as possible. These approaches are:

–  Enter progress at the task level.

–  Enter progress at the resource assignment level.

In this blog post article, I discuss each of these approaches individually.

 

Entering Progress at the Task Level

The simplest method for entering progress is at the task level using the % Complete value for each task. Using this method, you must ask your team members to estimate their cumulative percentage of work completed to date for each task that occurred during the previous reporting period. Keep in mind, however, that there are two primary limitations for using this method of tracking:

  • This tracking method is not date sensitive. When you initially enter a % Complete value for a task, the software assumes that the task started as currently scheduled, even if it started late in reality. If you mark a task as 100% complete, the software assumes the task finished as currently scheduled, even if it finished late in reality.
  • This tracking method does not allow team members to provide their Estimate To Complete (ETC) for any task. Without the ETC information, the software has no knowledge of whether the task will take longer than its original planned Duration

To work around these two limitations, you should gather the following progress information for each task by asking your project team the following questions:

  • Actual Start date – “If you started work on a new task this week, what day did you actually start?”
  • Percent Complete – “As a percentage, how much work have you completed on the task to date?”
  • Remaining Duration – “How many days of work do you think you have left on the task?”
  • Actual Finish date – “If you completed work on a task this week, what day did you actually finish?”

Based on the answers provided by your team members for the preceding questions you can manually enter actual progress by completing the following steps in your Microsoft Project schedule:

  1. Apply the Gantt Chart
  2. Click the View tab to display the View
  3. In the Data section of the View ribbon, click the Tables pick list button and select the Tracking
  4. Widen the Task Name column, as needed.
  5. Drag the split bar to the right of the % Complete
  6. “Drag and drop” the % Complete column to the right of the Actual Start
  7. “Drag and drop” the Remaining Duration column to the right of the % Complete
  8. Drag the split bar to the right edge of the Actual Finish
  9. Enter the actual start date of each task in the Actual Start
  10. Enter the estimated percentage of completion for each task in the % Complete
  11. Enter the number of days left for the task (the Estimate To Complete) for each task in the Remaining Duration
  12. When the team members complete work on task, enter the actual completion date for the task in the Actual Finish

Using the preceding steps, you never need to enter 100% in the % Complete column for any task. Instead, when you enter a date in the Actual Finish column, Microsoft Project automatically calculates a 100% complete value in the % Complete column. Also keep in mind that after you enter the % Complete value, if you then increase the Remaining Duration value, Microsoft Project automatically reduces the % Complete value. If you decrease the Remaining Duration value, Microsoft Project automatically increases the % Complete value. This is because the % Complete field is a Duration-driven field in which the values represent the percentage of the Duration completed to date.

Figure 1 shows the Tracking table set up to track progress at the task level, and with progress entered for the first two tasks. Notice that the Design task is 100% complete with both an Actual Start date and an Actual Finish date entered for the task. Notice that the Build task is only 50% complete, with an Actual Start date and a % Complete value entered, with no adjustment to the Remaining Duration value, and with no Actual Finish date entered yet.

Figure 1: Progress entered at the task level

 

Entering Progress at the Resource Assignment Level

The preceding process works well when you enter progress on tasks with only a single resource assigned. If you want to enter progress on tasks with multiple resources assigned, and want to enter the progress for each assigned resource individually, you can use a variation of the preceding set of steps. To enter progress at the resource assignment level, complete the following steps in your Microsoft Project schedule:

  1. Apply the Task Usage
  2. Click the View tab to display the View
  3. In the Data section of the View ribbon, click the Tables pick list button and select the Tracking
  4. Widen the Task Name column, as needed.
  5. Drag the split bar to the right of the Physical % Complete
  6. Right-click on the Actual Finish column header and select the Insert Column item on the shortcut menu.
  7. In the list of available task columns, select the % Work Complete
  8. Right-click on the Actual Finish column header and select the Insert Column item on the shortcut menu again.
  9. In the list of available task columns, select Remaining Work
  10. Drag the split bar to the right of the Actual Finish
  11. Enter the actual start date in the Actual Start column for each assigned resource on a task.
  12. Enter the estimated percentage of completion in the % Work Complete column for each assigned resource on a task.
  13. Enter the number of hours of work left in the Remaining Work column for each assigned resource on a task.
  14. When the team members complete work on task, enter the actual completion date in the Actual Finish column for each assigned resource on a task. If all assigned resources finished the task on the same day, you could enter the Actual Finish date for the task instead of entering it for each assigned resource, by the way.

Using the preceding steps, you never need to enter 100% in the % Work Complete column for any task. Instead, when you enter a date in the Actual Finish column, Microsoft Project automatically calculates a 100% complete value in the % Work Complete column. Also keep in mind that after you enter the % Work Complete value, if you then increase the Remaining Work value, Microsoft Project automatically reduces the % Work Complete value. If you decrease the Remaining Work value, Microsoft Project automatically increases the % Work Complete value.

Figure 2 shows the Tracking table set up to track progress at the resource assignment level, and with progress entered for the first two tasks. Notice that the Design task is 100% complete with both an Actual Start date and an Actual Finish date entered for each resource assigned to the task. Notice that the Build task is only 38% complete, with an Actual Start date and a % Work Complete value entered for each resource, with no adjustment to the Remaining Work values, and no Actual Finish dates entered yet. Notice that Microsoft Project calculated the % Work Complete value of 38% for the Build task as the average of the values entered for Randy Parker (50%) and Ron Appel (25%).

Figure 2: Progress entered at the resource assignment level

 

NOTE: In the customized Tracking table shown in Figure 2, I right justified the data in the % Work Complete and the Remaining Work columns. To right justify the data in any column, right-click in its column header and select the Field Settings item on the shortcut menu. In the Field Settings dialog, click the Align data pick list and select the Right item. Optionally change the value in the Width field to widen the column, and then click the OK button.

 

Next Webinar

Why Impartial Testing is a Non-Negotiable

Written by Dale Howard
Dale Howard is currently a Senior PPM Consultant with Arch Systems, Inc. His hair and beard have turned white because of using Microsoft's project management tools for more than 20 years. Dale started his career using Microsoft Project 4.0 for Windows 95 and began using Microsoft's PPM tools when they introduced Project Central in 2000. Dale is the co-author of 23 books in Microsoft Project, Project Server, and Project Online. He is currently one 0f 26 Microsoft Project MVPs in the entire world and one of only 4 Project MVPs in the United states.
Share This Post
Have your say!
00
3 Comments
  1. Very nice – I typically advise to use the detail window, Actual radio button and enter from their – I like the ETC idea – good visual too.

  2. Dale, Dale, I consider giving participants access to the mpp schedule is a high risk practice. The number of tasks that should be underway or complete for a weekly status update in my experience is normally quite manageable to update in a status meeting. For example a 1000 task 1 year project will average 20 tasks/week for update. Capturing % complete, remaining work, or remaining time adds significant complexity to the task of projecting task finish date. If you want to know projected finish date why not ask the task owner? I do that and stretch or shorten duration to fit their projection. That way no one can complain that MSP overrode their projection. Then Mark on Track calculates % complete for your status date. Finally I think using MS Project to calculate work done on a project misses the myriad of activities a participant does that’s not in any schedule, i.e. meetings, phone calls, conversations, travel, personnel, breaks. I recommend my clients use a separate labor claiming application to capture participant work on each of their projects. For earned value calculations you get a more accurate value of both actual work and project % complete.

  3. Great thoughts as always – we all know that there are several ways to update tasks – in fact you have written articles on them. I totally agree with the comment by eDale (?) and I pound it in the heads of my PMs that the finish date field is a calculated field and to never enter a date in there. I have tried to use the status date and progressing the Schedule but the concept seems to slip by them. Anyway, again, great job and keep them coming!!

    Bob

Leave a Reply