Updating Actual Units in Primavera P6.
Auto update actual units in P6.

Updating Actual Units in Primavera P6.

In the busy offices of a construction projects, my colleague Mohak Verma approached me with a problem: manually calculating and updating actual units from the activity percentage complete was quite time-consuming.

 As planning engineers, we often encounter such situations when updating P6 schedules, and this calculation is required for forecast histograms and S-curves while keeping 'At Completion Units' equal to the budgeted units.

After several trials and errors, these Primavera P6 global changes were finally discovered to optimize the process and enhance the productivity.

Global Change 01: Copying activity% as units % complete.
Global Change 02: Calculate actual units from units % complete.
Calculation settings applied on a project level.

Give it a try! Feedback, suggestions, and improvements are always welcome.

Notes:

  • 🚨 Make sure you always have a backup of the XER file when making global changes in Primavera P6.
  • % Complete Type = Physical.
  • Actual units (labor and non labor) will be multiplied by the activity's percentage complete.
  • Your project may have different actual units for the activities.
  • This P6 global change is only for units. For actual cost refer to this article.

Mohammed Azharuddin Sultanpuri

Assistant Manager - Planning (1.6 GW WIND Energy Project l NEOM GREEN HYDROGEN PROJECT) l Cost Control, & Risk Mitigation | 10 Years in Oil & Gas, Petrochemicals, Energy | Primavera P6, Power BI

1mo

Thanks for This Global change, But i observed one thing, when updating the in progress activities as rollup in next week activities, make sure your at compltionn units are not deviating, We can bring in progess activiy to 0% & then add further incremental progress % to in line your budget & at compltion units

Like
Reply
Joaquín Palazzesi

Ing. Civil / Responsable de Planificación y Control de Proyectos

5mo

Thank you very much!

Like
Reply
Jalal Fattal "PMP"

Project Planning Manager

7mo

Interesting

Like
Reply
Mohak Verma

Project Coordinator|Planning Projects on Primavera P6|Developing Interactive Project Dashboards on PowerBI|Delivering Successful Projects|Construction Project Manager|Architect|40+ Freelance projects delivered

7mo

Very helpful!

Like
Reply

To view or add a comment, sign in

Insights from the community

Others also viewed

Explore topics