Primavera P6 – myxacom

This is an extension to our previous article regarding the DCMA 14 Point Check. The following method was used for Primavera P6 version 6.1, there was no other schedule analytical tool available so we developed a work around approach.

Open the required project for analysis in Primavera P6.

Make a note of the Total Float – in this example it’s 0.

Select Group & Sort.

Select None in the grouping.

Now select Filter.

Filter in Critical activities only.

Go back into Grouping & Sort and select show grand totals.

The Duration for the Critical Path is shown, document this down.

Now we have the data we can apply the formula, so in the example used in this document this would look like:

Critical Path Length Index = (1293 – 0)/1293 = 1.

There are a further 13 checks prescribed by the DCMA which along with the CPLI Check that will be detailed out in further supporting documentation and video tutorials at http://www.myxacom.com where knowledge is no weight to carry.

Open up the required project for analysis in Primavera P6.

First we need to create a new report through the Report Wizard.

Select Activities in the subject area as this is the data we wish to see in the output report.

Click past the additional subject area screen as we do not require any additional subjects for this report.

Click on Columns.

Add BL Project Finish and Actual Finish.

Click Next.

Add the report title.

Click Run Report.

As we want the report in Excel select ASCII and ensure that the Text Qualifier is set to “.

The Report will open in Microsoft Excel.

Filter on all the completed activities and make a note of the count.

Filter on Not Started and In Progress.

Now filter on the current month for progress update in the BL Project Finish Column.

Now we have the necessary data we can carry out the BEI calculations:

683 (Completed) + 16 (Should have completed) = 699.

BEI = 683/699 = 0.98. The DCMA criteria states that this should be 0.95 or above. In this example the project meets the criteria.

There are a further 13 checks prescribed by the DCMA which along with the BEI Check that will be detailed out in further supporting documentation and video tutorials at http://www.myxacom.com where knowledge is no weight to carry.

Category: Primavera P6

DCMA 14 Point Check – Critical Path Length Index

DCMA 14 Point Check – Baseline Execution Index Check

Follow Us