Manpower Resource Loading including S-curve in Primavera P6

Introduction

This tutorial will guide you through the process of calculating manpower and resource loading in Primavera P6, including how to create an S-curve. By the end, you will be equipped with the skills to manage resources effectively within your projects.

Chapter 1: How to Calculate Manpower in Primavera P6

To calculate manpower, you need three key columns:

• Quantities
• Standard man-hours
• Total man-hours required

Steps:

1. Formula for Total Man-Hours:
   • Total man-hours = Quantities × Standard productivity per hour.
2. Use Global Change to calculate these values.

Chapter 2: How to Define a Column in User Defined Field

You can add custom columns to your project for better tracking.

Steps:

1. Go to Enterprise > User Defined Fields.
2. Add a new column:
   • Set the type as Text.
   • Title it Unit of Measurement (UOM).
3. To display this column:
   • Go to Columns and select User Defined Field from the list.
   • Add UOM.

Tips:

• Assign relevant units of measurement for different materials (e.g., kilograms for rebar, square meters for formwork).

Chapter 3: How to Filter Activities

Filtering helps you manage activities more efficiently.

Steps:

1. Use the Filter command to select activities by name.
2. Filter for activities containing Rebar in their description.
3. Select all filtered activities and use Fill Down to assign the same UOM.
4. Repeat for Formwork and Concrete activities.
5. Remove the filter to see all activities with updated UOM.

Chapter 4: How to Apply Global Change in Primavera P6

Global changes allow for bulk updates across your project.

Steps:

1. From the Tools dropdown, select Global Change.
2. Create a new global change named Man Hour.
3. Add a parameter:
   • Set it to Total man-hours = Quantity × Standard man-hours.
4. Click Change to update values.
5. Commit Changes and apply.

Chapter 5: How to Define Resources in Primavera P6

Defining resources is essential for accurate project management.

Steps:

1. Go to Enterprise > Resources.
2. Click Add to create a new resource:
   • Set Resource ID and Name (e.g., Quantity).
   • Choose Non-Labor type.
3. Repeat to add another resource for Man Hours.
4. Adjust the calendar settings if necessary.

Chapter 6: Assign Resources to Activities in Primavera P6

After defining resources, you need to assign them to activities.

Steps:

1. Go to Activities and select all relevant activities.
2. Right-click and choose Assign.
3. Double-click on Quantity and Man Hours to assign resources.

Chapter 7: Modify Resources Budget Value in Primavera P6

Adjusting budget values can be streamlined using Excel.

Steps:

1. Export the project:
   • Go to File > Export > choose options for activities, resources, etc.
2. Save the exported file in a designated folder.
3. Open the Excel file and identify the columns that need updating.

Chapter 8: Use SUMIF Function in Excel

Using Excel formulas can help manage large datasets effectively.

Steps:

1. Use the SUMIF function to link quantities to activities:
   • Formula: =SUMIF(range, criteria, sum_range)
2. Drag the formula down to apply it to all activities.
3. Repeat for man-hours to ensure all values are accurate.

Chapter 9: Import Resources from Excel in Primavera P6

Once your Excel file is updated, import it back into Primavera.

Steps:

1. Import the updated file:
   • Choose Update Existing Program and finish.
2. Wait for the import process to complete.

Chapter 10: Present Histograms and S-Curve in Primavera P6

Visualizing your data can enhance understanding and planning.

Steps:

1. Select resource usage profile options to view histograms and S-curves.
2. Calculate manpower based on the man-hours graph:
   • Right-click and select options to calculate average manpower.
3. Change settings to display quantities as needed.

Conclusion

By following these steps, you can effectively manage manpower and resources in Primavera P6. The tutorial covered calculating total man-hours, defining and assigning resources, and visualizing data with histograms and S-curves. For further learning, consider exploring advanced features of Primavera P6 or connecting with communities for ongoing support.