Article 1 of 14
This is the first article of a series of 14 planned to be run, each will be published on a Monday evening. On completion of the series a set of documents and video tutorials will also be published on myxacom.com.
Has anybody applied the DCMA (Defence Contract Management Agency) 14 point check to their schedules and if so what software did you use?
We were recently supporting a client who had a requirement to assess their contractor schedules for some level of accuracy. The DCMA 14 point check was chosen, yet we didn’t have any specific software to run the analysis.
We opted for developing reports to be run from Primavera P6 and saved them as .csv files, from here we could sort and filter to assess the schedule data against elements of the 14 point check.
Below is an example of just one of the reports that we developed and how we utilised the data to assess against the 14 point check criteria.
The example we will use here is the Logic check.
This check looks at the links between activities. The criteria states that the number of activities in the schedule missing a predecessor, sucessor or both should not exceed 5% of the total activities in the schedule.
To check this is Primavera P6 we used the following steps:
Step 1. Check the Project activity totals, which can be found in the Project View in the ‘Total Activities’ column. Make a note of this number.
Step 2. Create a report in Primavera P6 that filters out activities that have predecessors and/or sucessors.
Step 3. Run the report making sure to save as an ASCII Text File, the report should open in Microsoft Excel.
Step 4. Sort on Column A and then delete any row with an Activity ID as a description or any Activity ID’s with a description.
Step 5. Highlight the remaining Activity ID’s which will give you a count (number of activities left).
Step 6. Divide the remaining count of activities by the total number of activities (the number from Step 1) and this will give you a %.
If the percentage is 5% or lower then the logic is within tolerance, if not then a review of the schedule logic may need to take place.
There are a futher 13 checks prescribed by the DCMA which along with the Logic Check will be detailed out in further supporting documentation and video tutorials at http://www.myxacom.com where knowledge is no weight to carry.