Skip to content

Blog · Filed under

Primavera P6

39 articles
Primavera P6

How to remove suffixes from dates and display both dates for milestones in Primavera P6

If you came into Primavera P6 from a Microsoft Project background, you would have noticed that actual dates have the suffix “A” appended to them, and constrained dates also have an asterisk appended. And milestones have a blank date field depending on the type of milestone.In this YouTube video, I w

24 Apr 2022 · Jerome Odeh · 1 min read

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 usi

11 Dec 2021 · Jerome Odeh · 1 min read

Primavera P6

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.

24 Feb 2021 · Jerome Odeh · 7 min read

Primavera P6

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.To demonstrate this problem, assuming we have the dummy schedule shown below, a simple schedule with all activities sequentially linked with FS logic.If we add…

25 Jan 2021 · Jerome Odeh · 2 min read

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.When project complexity is high,…

12 Jun 2019 · Vivien Goldstrong · 4 min read

Primavera P6

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.Step 1:Follow this article to insert the "WBS Level" column :…

19 Nov 2018 · Khuong Do · 1 min read

Primavera 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)/2Apply to the rest so we can see WBS level for each activity:

16 Aug 2018 · Khuong Do · 1 min read

Primavera P6

How to use Activity Duration Type in Primavera P6

(If the image is too big, you can read the original article at this link : https://doduykhuong.com/2018/03/25/how-to-use-activity-duration-type-in-primavera-p6/ )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/d

31 Mar 2018 · Khuong Do · 1 min read