Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Project
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Actual Work fields
 

The Actual Work fields show the amount of work that has already been done by resources assigned to tasks. The timephased (timephased: Task, resource, or assignment information that is distributed over time. You can review timephased information in any available time period in the fields on the right side of the Task Usage and Resource Usage views.) versions of these fields show values distributed over time.

There are several categories of Actual Work fields. Learn more about field categories.

Data Type   Duration (duration field: A type of field whose content is expressed as a duration of time. Examples include the Work, Duration, and Delay fields. A duration field includes the duration unit, such as hour, day, or week.)

ShowActual Work (task field)

Entry Type  Calculated or entered (calculated or entered field: A field in which the value is determined by Project based on information in other fields. Information that you enter in the field yourself overrides calculated values.)

How Calculated  When you first create a task, the Actual Work field contains "0 hrs" until you begin tracking the project by entering percent complete or actual work. As you enter percent complete, percent work complete, or actual work information, Microsoft Office Project updates actual work for the task.

If you enter a value in the Actual Work field for the task, Project divides the actual work you enter among the assigned resources.

Best Uses  Add the Actual Work field to any task view to review, filter, or edit actual work information for tasks. Use this field with the Baseline Work field during the course of a project to compare work values against your original plan.

Example  Jamie, Sean, and Chris are assigned to 30 hours of work for the "Write proposal" task. By reviewing the Actual Work field, you can see that the assigned resources have reported a total of 15 hours of actual work so far.

Remarks  By default, Project calculates actual work for assignments based on percent complete values that you enter for tasks. To turn this setting off, click Options on the Tools menu, and then click the Calculation tab. Clear the Updating task status updates resource status check box.

If actual work is zero when the task is 100 percent complete, Project copies the value from the Work field into the Actual Work field for the assigned resources.

When you enter actual work or percent complete, Project adjusts actual and remaining work around the status date by default. If you prefer, you can leave these tracking fields in the project as originally scheduled, even if completed work is shown in the future or remaining work is shown in the past. On the Tools menu, click Options. On the Calculation tab, clear the Move end of completed parts after status date back to status date and Move start of remaining parts before status date forward to status date check boxes.

ShowActual Work (resource field)

Entry Type  Calculated (calculated field: A field in which the value is determined by Project based on information in other fields. Project may recalculate the value automatically or when you specify, depending on your choice of calculation settings.)

How Calculated  The Actual Work field contains "0 hrs" until you begin tracking the progress of tasks. Project calculates actual work for each resource as the sum of all actual work reported for all assigned tasks.

Best Uses  Add the Actual Work field to a resource view to review or filter for actual work information for resources. You can use this field after the task is completed, to help you plan costs and staffing for future projects.

Example  You're tracking actual work for Jamie. By reviewing the Actual Work field, you can see that so far, Jamie has reported a total of 150 hours of work for all assigned tasks.

ShowActual Work (assignment field)

Entry Type  Calculated or entered (calculated or entered field: A field in which the value is determined by Project based on information in other fields. Information that you enter in the field yourself overrides calculated values.)

How Calculated  The Actual Work field contains "0 hrs" if you have not yet begun tracking the project. As you enter actual work information for tasks, or percent of work complete, Microsoft Office Project updates the assignment's actual work values.

Best Uses  Add the Actual Work field to the sheet portion of the Task Usage view to review, filter, or edit actual work information for assignments on specific tasks. Add this field to the sheet portion of the Resource Usage view to review, filter, or edit actual work information for assignments to specific resources. You can compare actual work with baseline work values to see whether your project is progressing according to your original plan.

Example  Jamie is assigned to 20 hours for the "Write proposal" task. By reviewing the Actual Work field, you can see that Jamie has reported 9 hours of work so far.

Remarks  By default, Project calculates actual work on an assignment based on percent complete values that you enter for a task. To turn this calculation off, click Options on the Tools menu, and then click the Calculation tab. Clear the Updating task status updates resource status check box.

When you enter actual work or percent complete, Project adjusts actual and remaining work around the status date by default. If you prefer, you can leave these tracking fields in the project as originally scheduled, even if completed work is shown in the future or remaining work is shown in the past. On the Tools menu, click Options. On the Calculation tab, clear the Move end of completed parts after status date back to status date and Move start of remaining parts before status date forward to status date check boxes.

To set the status date to a date other than today's date, click Project Information on the Project menu, and then enter the date in the Status date box.

ShowActual Work (task-timephased field)

Entry Type  Calculated or entered (calculated or entered field: A field in which the value is determined by Project based on information in other fields. Information that you enter in the field yourself overrides calculated values.)

How Calculated  When you first create a task, the Actual Work field contains "0 hrs" until you begin tracking the project by entering percent complete or actual work. As you enter percent complete, percent work complete, or actual work information, Project calculates the timephased actual work values.

If you enter a value in the Actual Work field for the task, Project divides this value among the assigned resources.

Best Uses  Add the Actual Work field to the timephased portion of the Task Usage view to review or edit actual work information for tasks. You can use this information after the task is completed to help you plan costs and staffing for future projects.

Example  Jamie, Sean, and Chris are assigned to 60 hours of work for the "Write proposal" task. By reviewing the Actual Work field in the Task Usage view, you can see that collectively they have reported a total of 27 hours of actual work so far, with 3 hours credited to each of the three resources on Monday, Tuesday, and Wednesday.

Remarks  If you enter timephased actual work for the task, the values are distributed to the assignments in the same proportion of work scheduled for each assigned resource at that point in time.

ShowActual Work (resource-timephased field)

Entry Type  Calculated (calculated field: A field in which the value is determined by Project based on information in other fields. Project may recalculate the value automatically or when you specify, depending on your choice of calculation settings.)

How Calculated  The Actual Work field contains "0 hrs" until you begin tracking the progress of tasks. Project calculates actual work for each resource as the sum of all actual work reported for all assigned tasks, as distributed over a period of time.

Best Uses  Add the Actual Work field to the timephased portion of the Resource Usage view to review or filter for actual work information for assignments to the resources. You can use this field after the task is completed to help you plan costs and staffing for future projects.

Example  You need to see how much actual work Jamie has reported over the past week. By reviewing the Actual Work timephased field, you can see that Jamie has reported 6 hours a day over the past 3 weeks for all assigned tasks.

ShowActual Work (assignment-timephased field)

Entry Type  Calculated or entered (calculated or entered field: A field in which the value is determined by Project based on information in other fields. Information that you enter in the field yourself overrides calculated values.)

How Calculated  The Actual Work field contains "0 hrs" if you have not yet begun tracking the project. As you enter actual work or percent complete information for tasks or assignments, Project calculates the timephased actual work values.

Best Uses  Add the Actual Work field to the timephased portion of the Task Usage view to review or edit information on actual work for assignments on specific tasks over a period of time. Add this field to the timephased portion of the Resource Usage view to review or edit information on actual work over a period of time for assignments to specific resources.

Example  Jamie is assigned to 20 hours for the "Write proposal" task. By reviewing the Actual Work timephased field, you can see that Jamie has reported 9 hours of work so far, with 3 hours each distributed over Monday, Tuesday, and Wednesday.

advertisement