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 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.
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.