# 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.

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

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:

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

## 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/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.

## The 1, 2, 3 of Primavera P6 Baselines

Primavera P6 Professional allows you to assign up to three user baselines and one project baseline per project. The following article explains these capabilities and how they can be helpful in tracking the overall status of a project and near-term interim variance reports.

Take a look at the following diagram (taken from the Ten Six Primavera P6 training course) that outlines the concept of project and users baselines.

## Merry Christmas from Primavera P6

From Primavera P6 with love :-)

primaverap6christmascard.png

You can download the Project and the Layout from here : https://doduykhuong.com/2017/11/25/merry-christmas-from-primavera-p6/

## Calculations of Summary Original Durations in Primavera P6

By Yaser A. Al-Bustanji CPCM, ACIArb, PMP, PMI-SP, PMI-RMP, November, 2017

Introduction

This article is a simple guide to understand the data stored in the P6 Original Duration fields that appear in all summary bands such as Project, WBS, Resources and Activity Codes.

## How to define Resource Productivity in Primavera P6 and create schedule

When create a schedule, we can based on Resource Productivity to estimate duration.

For example:

• We have a team which can cast 10 m3 of concrete per day (This is Productivity)
• We have an Foundation which take 100 m3 concrete.
• Duration of Foundation activity will be  100 / 10 = 10 days

Now we will do it in Primavera.

Supposed that we have a schedule like below picture:

## How to quickly identify Behind Schedule and Over Budget activity by Indicator UDF in Primavera P6

In Primavera P6, we can quickly identify behind schedule and over budget activity by using graphical indicator in User Defined Field.

I will show you how to do it.

Supposed that we have a project which has baseline. After update progress, we can show these column the see whether an activity is behind schedule:

## 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.
See how the TIME - LOCATION - VIEW brings clearness to your work programmes
For 25+ years, APMX has been providing competency based project management training to Fortune 500 companies around the world, applying the principles of project based learning, designed to produce measurable results, generating a favorable “return on training investment”.