The video on the right explains how as-planned v as-built progress graphs can be produced from baselines and multiple updates.

​

For all activities:

​

The as-planned is calculated as the Planned Late Finish - the Planned Late Start. At each Data Date Update date, the date is used to calculate where the planned should be between the PLF - PLS to calculate the planned % complete equivalent. 

​

The as-built % complete is used at each update. Both planned and actual % complete at each data date update are calculated and averaged. 

​

As the coded function is a SUBTOTAL FUNCTION, the WBS can be filtered and any WBS can be identified. 

​

In the example shown, the WBS identifies the: CONSTRUCTION, PODIUM and STRUCTURAL WORK activities. The graph identifies the as-built as the orange line and the planned as the blue line.  

​

The graph for the Podium structural works identifies the structural works were ahead of programme as the as-built orange line is below the planned blue line.

​

On the L11 Blockwork graph, the Orange as-built is way above the Blue planned progress line. This indicates the L11 Blockwork was in critical delay. 

​

Look at the % complete on the bottom axis and at the % complete chosen identify the blue planned date at the % complete on the left vertical axis. Do the same for the orange as-built. Subtract the two dates. If it is negative, it is in delay. If it is positive, it is ahead of programme. 

​

​YOU CAN DO THAT ON ANY WBS FILTER.

​