Previous Topic: Save the Baseline (Microsoft Project)Next Topic: Rework Plans (Microsoft Project)


Actuals (Microsoft Project)

The resources assignments on your project likely use timesheets in CA Clarity PPM to enter the weekly work they accomplish on their assigned project tasks. These timesheets automatically include tasks you have scheduled for that week.

Resources must submit their timesheet and the project manager must approve the timesheet before it is posted to the project plan. Pending actuals are displayed in Microsoft Project before posting actuals. The Pending Actuals field in CA Clarity PPM is mapped to the Number2 field in Microsoft Project.

When a timesheet is posted, the estimates (ETC) on assignments for which a resource enters actuals on their timesheet is adjusted. In most cases, the ETC reduces the amount of the actuals so that the total work on the assignment remains the same.

In Microsoft Project, assignments with a work contour assigned Contoured (Fixed in CA Clarity PPM) are processed differently. In this case, the ETC that are scheduled on or before the week are replaced with the actuals. Also, the ETC scheduled after the week are kept intact. The result, depending on when the estimates are scheduled in Microsoft Project, can be an increase or a decrease of total work.

Note: In Microsoft Project, work contour assignments are reset to Contoured if you edit the work distribution. If you modify the total actual or remaining work distributions, the work contour is not modified.

Most of the time, posting a timesheet does not immediately change the finish dates of the tasks that were on that timesheet. For example, when work on a task takes longer than planned (more actuals are entered than planned), the result is a new, reduced ETC.

Less work is completed on a task than was planned for the week is scheduled at a higher rate within the task schedule. In this case, when you open the project from CA Clarity PPM in Microsoft Project, the task is rescheduled and the finish date is delayed.

A posted timesheet is assumed to be a complete accounting of the project work that a resource did that week. A scheduled task that does not appear on the timesheet implies that the resource did not complete any work on that task. The project manager must reschedule the task for the following week or beyond.

Note: When you open a project from CA Clarity PPM in Microsoft Project it is scheduled, even if you use Manual Calculation in Microsoft Project. As a result, task finish dates and resource work distribution in Microsoft Project can be different than in CA Clarity PPM.

More information:

Timesheets