Create Progress Measurement Sheet (PMS)-Basics-English

What you will 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

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.


Get Instant Notification of New Courses on our Telegram channel.


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.

English
language

Content

Introduction

Introduction

create the PMS

Colouring the P6 in Excel-EN
PMS (02)- Activities Grouping
PMS(03)-get duration between dates considering the weekends and holidays-EN
PMS (04) – Linear vs Non-linear distribution in P6-EN
PMS (05) – Get dynamic duration from data date-Ar
PMS(06)-How to get the planned unit-method 1 -EN
PMS(07)-How to get the planned unit from P6 for non-linear -Xlookup -EN
PMS(08)-How to get the planned unit from P6 for non-linear -Match/index -AR
PMS(09)-Automate creating the PMS-EN
PMS (10)-Progress types -EN
PMS (11)-The basis to unify the progress units-EN
PMS (12)-Explain the PMS columns-En

Update

PMS (13)-Import Update from Primavera P6-En
PMS (14)-Update P6 from PMS Excel