Manpower Resource Loading including S-curve in Primavera P6
Table of Contents
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:
- Formula for Total Man-Hours:
- Total man-hours = Quantities × Standard productivity per hour.
- 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:
- Go to Enterprise > User Defined Fields.
- Add a new column:
- Set the type as Text.
- Title it Unit of Measurement (UOM).
- 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:
- Use the Filter command to select activities by name.
- Filter for activities containing Rebar in their description.
- Select all filtered activities and use Fill Down to assign the same UOM.
- Repeat for Formwork and Concrete activities.
- 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:
- From the Tools dropdown, select Global Change.
- Create a new global change named Man Hour.
- Add a parameter:
- Set it to Total man-hours = Quantity × Standard man-hours.
- Click Change to update values.
- Commit Changes and apply.
Chapter 5: How to Define Resources in Primavera P6
Defining resources is essential for accurate project management.
Steps:
- Go to Enterprise > Resources.
- Click Add to create a new resource:
- Set Resource ID and Name (e.g., Quantity).
- Choose Non-Labor type.
- Repeat to add another resource for Man Hours.
- 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:
- Go to Activities and select all relevant activities.
- Right-click and choose Assign.
- 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:
- Export the project:
- Go to File > Export > choose options for activities, resources, etc.
- Save the exported file in a designated folder.
- 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:
- Use the SUMIF function to link quantities to activities:
- Formula:
=SUMIF(range, criteria, sum_range)
- Formula:
- Drag the formula down to apply it to all activities.
- 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:
- Import the updated file:
- Choose Update Existing Program and finish.
- 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:
- Select resource usage profile options to view histograms and S-curves.
- Calculate manpower based on the man-hours graph:
- Right-click and select options to calculate average manpower.
- 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.