Website Upgrade Incoming - we're working on a new look (and speed!) standby while we finalise the project

Primavera P6

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

Posted Sun, 2022-04-24 10:57 by Jerome Odeh

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 will show you a trick you can use to

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

Posted Sat, 2021-12-11 18:39 by Jerome Odeh

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

Posted Wed, 2021-02-24 21:57 by Jerome Odeh

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

Posted Mon, 2021-01-25 23:19 by Jerome Odeh

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

Posted Wed, 2019-06-12 14:31 by Vivien Goldstrong

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

Posted Mon, 2018-11-19 10:07 by Khuong Do

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

 

6262
primavera-p6-export-to-excel-how-to-identify-wbs-level-for-activity-1.jpg

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

Posted Thu, 2018-08-16 03:56 by Khuong Do

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

5917
primavera-p6-export-to-excel-how-to-identify-wbs-level-for-activity-1.jpg

 

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

5918
primavera-p6-export-to-excel-how-to-identify-wbs-level-for-activity-2.jpg

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

5919
primavera-p6-export-to-excel-how-to-identify-wbs-level-for-activity-3.jpg

 

How to use Activity Duration Type in Primavera P6

Posted Sat, 2018-03-31 02:27 by Khuong Do

(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/day = 80 hours         )

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

Posted Fri, 2018-03-16 09:03 by Khuong Do

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

Posted Sat, 2018-02-17 07:05 by Khuong Do

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.

Market Place

No results found... (try selecting a different content filter)

Syndicate content