In our tenth article looking at the 14 point check we described how we at checked Resources, in this post we are going to take a look at Missed Activities.
The DCMA criteria states that the number of activities that have slipped from their baseline should not exceed 5% of the total number of activities in the project.
Missed Activities Check
To check this is Primavera P6 we used the following steps:
Step 1. Open the project you wish to analyse in Primavera P6.
Step 2. Now add the Total Activities column and make a note of the Total Activities in the schedule.
Step 3. Create a new report using the Report Wizard, selecting Activities as it is activity data we require in the report.
Step 4. Add the BL Project Finish, BL Project Start, Finish and Start columns as we are looking to see if these differ on any activities. Click through until you are required to type in the report name.
Step 5. As we want the report in Excel select ASCII and ensure that the Text Qualifier is set to “.
Step 6. Now the report has opened in Excel insert columns between both the BL Project Finish and Start column. Subtract the Start date from the BL Project Start Date in the column added and format the cells to a number. Repeat for the BL Project Finish and Finish column.
Step 7. Add auto filter onto the column descriptions and filter on the difference between the two start dates, note down the result. Apply the same logic on the difference between the two finish dates and make a note of the total number.
Step 8. Divide the total number of differences between the start dates and the finish dates by the total number of activities.
If the percentage is 5% or below then the criteria has been met, if higher than 5% then the schedule may need a review.
There are a further 13 checks prescribed by the DCMA which along with the Invalid Dates Check will be detailed out in further supporting documentation and video tutorials at http://www.myxacom.com where knowledge is no weight to carry.