Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Primavera P6

How to show Primavera P6 dates in month-year (mmm-yy) format

The date formats available in Primavera P6 are very limited and to best of my knowledge, you cannot get the mmm-yy (month-year) format straight out of the box. You might want to display dates in mmm-yy if you don't want to show exact dates in issued schedules.

This P6 video outlines a workaround using UDF that can be used to achieve mmm-yy date format.

2 Ways to Show Ordinal Dates instead of Calendar Dates in Primavera P6 Schedule

In this tutorial, I will show you 2 methods of displaying ordinal dates in a Primavera P6 schedule, the first method uses Microsoft Excel and the second uses Global Change facility in P6. Ordinal dates schedules are usually required when a project does not have a defined calendar start date.

How to remove gaps after data date for activities in progress in Primavera P6

Today I’m going to show you how to get rid of gaps that appear after the data date for activities that are in progress in Primavera P6.

Confidentiality of Project Data When Shared in XER File Format

Clearly defined tasks and responsibilities must be given to all project participants, in order to ensure the successful completion of the project.

Even more so when a project counts a large number of participants, which makes it more demanding and difficult to manage.

Primavera P6 export to Excel. How to color WBS level automatically

After export activity table from Primavera P6 to Excel, it’s very hard to distinguish WBS level.



I will show you how to color WBS level automatically so we can have report like in P6.

Primavera P6 export to Excel. How to identify WBS level for activity

After export activity table from Primavera P6 to Excel, it's very hard to tell this activity belong to what WBS.



We can add 1 column to show the WBS level for each activity.

The formula for the column is : =((FIND(TRIM(B2),B2))-1)/2


Apply to the rest so we can see WBS level for each activity:



How to use Activity Duration Type in Primavera P6

(If the image is too big, you can read the original article at this link : )

In Primavera P6, when we assign resource to activity there is a equation:

Original Duration x Units/Time = Total Units

(          10 days        x 8 hours/day = 80 hours         )

What is the difference between Activity type: Task Dependent and Resource Dependent in Primavera P6

In Primavera P6, there are 2 popular activity type: Task Dependent and Resource Dependent.

So what is the difference?

By choosing Task Dependent or Resource Dependent, P6 will choose what calendar it will use for the activity:

  • Choose Task Dependent: P6 use Activity calendar for the activity
  • Choose Resource Dependent: P6 use Resource calendar for the activity

Then it will affect the Original Duration and Finish Date of the activity.

We have Activity A with attribute as below:

How does Primavera P6 calculate Planned Value Cost for Activities without linear distribution (using Resource Curves or Manual plan) in Earned Value Management

When we use Earned Value Management technique, we focus on:

  • Planned Value Cost (PV) = Budget At Completion * Schedule % Complete
  • Earned Value Cost (EV) = Budget At Completion * Performance % Complete (usually equal to Activity % Complete)
  • Schedule Variance (SV) = EV - PV
  • SV > 0 : project is good, ahead of schedule

So Planned Value Cost play a very important role here.

By default when we assign resource to activity, the unit is distributed equally (linear). Then calculation of Planned Value is as above.

Oracle Primavera P6 Professional – Get Filter Savvy

How to Mix the ‘And’ and the ‘Or’ Options in One Filter

Building a filter where all the conditions are either ‘And’ or ‘Or’ between each row is pretty straight forward. However, if you want to mix them up a little it’s not so obvious how you should do that in Oracle Primavera P6 Professional. This article will show you how.

Example: I want to find all the milestones in the project that have a date variance that is not equal to zero. In other words, I want to see any milestone that is now sitting on a date other than its baseline date.

Market Place

Primavera P6 and Microsoft Project books, on-line video training courses and training material available from an internationally recognised publisher and PMI accredited REP. Teach yourself using on-line or book based learning or run your own in-house or public PMI accredited courses.
Syndicate content