Create Progress Measurement Sheet (PMS)-Basics-English

Name: Create Progress Measurement Sheet (PMS)-Basics-English
Rating: 4.6 (204 reviews)

Created byMohamed Hisham Aboadma

Last updated 2/2023

English

English [Auto],

What you'll learn

Create Dynamic Progress measurement Sheet (PMS) from A to Z
How to use Plannex Excel Tool to expedite Creating the PMS file
Explain the different type of progress evaluation technique
How to update the PMS manual
How to update the PMS from P6 updates
How the update the P from the PMS update

Course content

3 sections • 15 lectures • 1h 52m total length

Introduction8:13
Explore creating and updating a progress measurement sheet (PMS) with Plan X Excel, exporting from P6 to Excel, visual formatting, calculating plan percentage, durations, and syncing back to P6.

Colouring the P6 in Excel-EN7:58
Learn to color the work breakdown structure in Excel for a PMS file, using manual level calculation with trim and find and conditional formatting, plus Plan X automation.
PMS (02)- Activities Grouping4:27
Learn how to group activities under the base and substructure in a pms, using manual grouping and the plan x tool, including collapse or expand steps.
PMS(03)-get duration between dates considering the weekends and holidays-EN4:12
calculate duration between two dates using a network days formula, excluding weekends (Friday only) and holidays, with a holiday list to adjust; shows 18 days and 76 days examples.
PMS (04) - Linear vs Non-linear distribution in P6-EN12:06
Compare linear versus non-linear distribution in P6 for labor hours, showing fixed daily allocation versus curve-based front/back-loaded plans, and outline two PMS methods for linear and non-linear schedules.
PMS (05) - Get dynamic duration from data date-Ar5:30
Explore obtaining dynamic duration from a data date using the linear distribution method, including an Excel IF formula, start and finish dates, and network duration between start and data date.
PMS(06)-How to get the planned unit-method 1 -EN6:32
Learn how to derive the planned schedule unit from duration and unit using a WBS-wise method, with pro-rata caveats, data filtering, and a planning tool for submission levels.
PMS(07)-How to get the planned unit from P6 for non-linear -Xlookup -EN8:49
Explore nonlinear distribution in PMS using b6 and xlookup to derive planned units from p6, with data cleaning, two-dimensional lookups, and fallbacks to match and index when xlookup is unavailable.
PMS(08)-How to get the planned unit from P6 for non-linear -Match/index -AR5:34
Learn to retrieve the planned value from P6 in non-linear scenarios using index and match as an alternative to vlookup, with fixed array references, exact matches, and error handling.
PMS(09)-Automate creating the PMS-EN4:39
Automate PMS creation using linear distribution to compute plan units, with X lookup or index, then generate PMS file from the planning tool including activity type, start, finish, and budget.
PMS (10)-Progress types -EN9:48
Explore the PMS progress types, including manual assessments, course page percentage, deliverable-based, milestone-based, hours, quantity, and commitment methods, and learn how to combine them for construction projects.
PMS (11)-The basis to unify the progress units-EN7:46
Unify progress units by converting work to budget, labor, or cost—and, when possible, to man hours using standard productivity rates for RC footing, tiles, shop drawings, procurement, and design.
PMS (12)-Explain the PMS columns-En9:27
Explain PMS columns like plan, plan cumulative, current, variance, and budget unit, and show how to calculate cumulative actuals using summation level for status.

PMS (13)-Import Update from Primavera P6-En8:32
Explore updating a PMS from Primavera P6 via Excel, including updating from zero, using actual units and lookups, and importing with vlookup to build cumulative updates for accurate progress tracking.
PMS (14)-Update P6 from PMS Excel8:35
Learn how to update the PMS from an Excel export to P6, including exporting activity data, applying vlookup and formulas, and importing back to P6 with status mapping.

Requirements

Fundamental P6 knowledge
Fundamental Excel knowledge

Description

This course is designed for project managers and team members who want to improve their ability to track the progress of their projects. The course will cover the basics of creating a PMS in Excel, including how to outline the phases or stages of a project, list out the tasks that need to be completed in each phase, and decide on the metrics to use for measuring progress.

In addition to the Excel component, the course will also cover how to update the PMS from P6,

By the end of the course, students will have a solid understanding of how to create a PMS in Excel and link it with P6 and will be able to use these tools to improve their ability to track progress and make data-driven decisions.

The course will cover the following topics:

Convert the P6 data Inro Excel
Coloring & Grouping the WBS in Excel
Calculate the planned Units over time.
Using P6-resources assignment to get the Planned units.
Creating a Dynamic PMS in Excel
Manual update for the PMS
Link P6 update with the PMS
update the P6 from the PMS
Best practices for tracking progress and making data-driven decisions

This course is suitable for project managers, team members, and anyone who wants to improve their ability to track the progress of their projects. A basic understanding of Excel and Power BI is recommended, but not required.

Who this course is for:

Planning engineer and Project Control Managers
Cost Control
Project Manager and Construction Managers

Create Progress Measurement Sheet (PMS)-Basics-English

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 8min

create the PMS12 lectures • 1hr 27min

Update2 lectures • 17min

Requirements

Description

Who this course is for: