The Remaining Cumulative Work fields contain the remaining amount of time scheduled for all resources assigned to task, accumulated over time.
There are three categories of Remaining Cumulative Work fields.
Data Type Duration
Remaining Cumulative Work (task-timephased field).
Entry Type Calculated
How Calculated The Work field contains the total amount of time scheduled for a task. The Cumulative Work field contains the amount of time scheduled for resources assigned to tasks, accumulated over time. Project calculates remaining cumulative work as follows:
Remaining Cumulative Work = Total Work – Cumulative Work
Best Uses Add the Remaining Cumulative Work field to the timephased portion of the Task Usage view to review remaining cumulative work information for tasks. You can use this information to review how much scheduled work remains to be completed for a task on a given day.
Example The “Research” task will take 8 hours of work over three days. The scheduled work for the 3 days is 2, 5, and 1. The value in the Remaining Cumulative Work field before day 1 is 8 hours. At day 1, the remaining cumulative work is 6 hours. At day 2, it is 1 hour. At day 3, it is 0 hours..
Remaining Cumulative Work (resource-timephased field)
Entry Type Calculated
How Calculated The Work field contains the total amount of time scheduled for a task. The Cumulative Work field contains the amount of time scheduled for resources assigned to tasks, accumulated over time. Project calculates remaining cumulative work as follows:
Remaining Cumulative Work = Total Work – Cumulative Work
Best Uses Add the Remaining Cumulative Work field to the timephased portion of the Resource Usage view to review remaining cumulative work information for a resource. This allows you to see how much total scheduled work remains to be completed for a resource at a given point in time.
Example Shawn is assigned to three tasks over three days: “Research,” “Develop,” and “Test.” The total work scheduled for all tasks is 24 hours over 3 days. The scheduled work for the “Research” task over three days is 2, 5, and 1. The scheduled work for the “Develop” task over three days is 3, 5, and 2. The scheduled work for the “Test” task is 1, 1, and 4.
The Remaining Cumulative Work field for Sean before day 1 is 24 hours. The Remaining Cumulative Work field at day 1 is 18 hours. At day 2 it is 7 hours. At day 3, it is 0 hours.
Remaining Cumulative Work (assignment-timephased field)
Entry Type Calculated
How Calculated The Work field contains the total amount of time scheduled to complete a task. The Cumulative Work field contains the amount of time scheduled for resources assigned to tasks, accumulated over time. Project calculates remaining cumulative work as follows:
Remaining Cumulative Work = Total Work – Cumulative Work
Best Uses Add the Remaining Cumulative Work field to the timephased portion of the Task Usage view to review information on Remaining Cumulative 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 information on remaining work over a period of time for assignments to specific resources.
Example Jane is assigned to 8 hours of work for the "Research" task with a duration of 3 days. The scheduled work for the 3 days is 2, 5, and 1 hours. You add the Remaining Cumulative Work field to the timephased portion of the Task Usage view. The Remaining Cumulative Work field before day 1 is 8 hours. At day 1 it is 6 hours. At day 2, it is 1 hour. And at day 3 it is 0 hours.
