In our ninth article looking at the 14 point check we described how we at checked Invalid Dates, in this post we are going to take a look at Resources.
The DCMA criteria states that all incomplete tasks should have resource (hours/values) assigned.
To check this is Primavera P6 we used the following steps:
Step 1. Open Primavera P6 and the project you wish to analyse.
Step 2. Create a new report using the Report Wizard, select Activities as it is activity data we require in the report. Add Resources as we are looking to find out how many remaining activities have a duration Resources assigned.
Step 3. Type in the report name and click run report. As we want the report in Excel select ASCII and ensure that the Text Qualifier is set to “.
Step 4. The report will open in Microsoft Excel, set a filter on the resource column to investigate if all activities have been resourced.
Step 5. Highlight the Resourced Activity ID’s and make a note of the count, compare this to the total number of activities.
If there are incomplete activities without resources assigned then the schedule may need to be reviewed.
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.