Calculating Earned Value Progress Automatically

You can have Open Plan update the earned value of the project by selecting the Update Physical Percent Complete option in the Progress Calculations dialog box.

When this option is selected and the Base Physical Percent Complete on EVT option is not selected, Open Plan updates the physical percent complete for activities that match the selected filter based on activity status using the following formula:

PPC = (Elapsed duration / Expected duration) x 100

where:

Elapsed duration is calculated as (Time Now – Actual Start).

Expected duration is calculated as (Finish Date – Actual Start Date).

The Finish Date is based on your selection of (early, late, or scheduled) dates.

The Base Physical Percent Complete on EVT option allows you to use the EVT assigned to the activities on the Advanced tab of the Activity Details dialog box when updating the physical percent complete.

Related Topics