Comparing Actual Percent Complete to Planned Percent Complete (79941)

MORE INFORMATION

While there is no defined field for the planned percent complete for a task, Project does calculate this value when determining the BCWS (budgeted cost of work scheduled) value for the task.

The BCWS value is defined as where the planned percent complete is based on the task's planned start and finish dates, and the current date. For example, if a task has planned start and finish dates of 11/4/91 8:00am and 11/8/91 5:00pm, and the current date is 11/6/91 1:00pm, the planned percent complete would be 50% (assuming the default Standard project calendar is used).

Project also calculates a BCWP (budgeted cost of work performed) value for a task as where the percent complete represents the actual progress on the task.

Because of the similarity of these two formula, a comparison of actual percent complete to planned percent complete is equivalent to a comparison of BCWS to BCWP. This comparison can be convenient for filtering on certain tasks.

For example, to display only tasks that are running behind schedule (that is any tasks with a percent complete value less than their planned percent complete), you can create the following filter:

Field Name	Test	Value
BCWP	Less	BCWS

Note that these types of comparisons are only valid for tasks that have a planned cost associated with them.