Creating discipline wise manpower histogram using Primavera P6 export data

Procedure for creating discipline/trade wise manpower histogram using P6 export data is similar to the post How to generate S curve/histogram from Primavera, P6 - Part 1 to 3. You should have resource loaded plan to export manpower data from P6 to prepare resource loaded histogram chart. The following steps are a guide to produce manpower histogram;

1. Open the selected project that you need to export data.

2. Select the Assignments tag on the Directory or go to Project on the menu bar , and go to Resource Assignments. You will see then Activity resource columns such as Activity ID, Activity Name, Resource ID Name, Start and Finish by default. There is Remaining Units column in Resource Usage spreadsheet field column by default.

3. As resource name (discipline wise) needs to be shown in Activity resource columns, you need to customize default view. To do so, go to View on the menu bar>>Columns>>Customize.

4. Look for Resource Name in General tag in Available Options box. Select Resource Name into Selected Options box.

5. Select Budgeted Units and Actual Units in the spreadsheet field columns if you want to see budget and actual data. You will get remaining early and late manpower data if select Remaining Earl Units and Late Unit. In this tutorial for instance, I just selected the budgeted units. 

6.To see budgeted units, go to Resource Usage Spreadsheet area and right click>>select Spreadsheet fields>> Select Budgeted Units.

7. To set resource usage hour per period, go to Resource Usage Spreadsheet area and right click>>select Timescale>>select month/week (to show weekly data) from date interval drop down list.

 
8. Go to View>> Group and sort by>> Customize and Select Show Grand Totals  and Show Summaries only tip boxes to see summary data.

9. Go to View>> filters and add the Resource ID names that you want to export data.



10. Make sure the data is organized as you like to display in excel sheet in order to reduce rework after exporting to excel. To do that, stay at the Resource Assignment view, go to View on the menu bar > Group & Sort by > mark on Show Grand Totals and Show Summaries Only boxes just to display overall level and discipline level summary resource data overtime.

11. Finally you will get resource loading data ready to export to excel as shown in figure below. Manpower field names such as Coded welder, Hot Work Sentry, Trade Assistant, Pipe fitter/Boilermaker and Rigger are displayed in the Resource Name column. Man hour distribution data is shown in the resource usage spreadsheet field.

12. To export, go to activity resource assignment area >> select all>>copy and paste to excel. The man hour distribution will vary according to time scale. Suppose if the time scale is set up by (month/week), the data is weekly man hour data. If you want to convert the weekly man-hour to weekly manpower , that feature is available in P6. The periodic average manpower can be calculated using the spreadsheet option box by selecting "Calculate Average" and entering working hours per week.

13. Finally you can create Histogram Chart using that excel data.

If you faced a problem of doing this, then leave the comments.

Get the excel template data to learn more.