Which Fields can be imported into Primavera P6 from Excel (XLS) Spreadsheet?

When we look at Excel file exported from Primavera P6, there are some columns have an asterisk (*). What does it mean?

I will explain in this article.

All the columns which have the asterisk mean they can not be imported into P6, i.e. we can not change their value and import into P6. There is a reason for this, for example the field may be a calculated field, or may be data rolled up from elsewhere.

For example, in the software some data about Resource Assignments is made visible at the activity level; Budgeted Labor Units is available to show as a column in the Activity View and can be exported to Excel at the Activity Level.  However the data in this column is actually a ‘rolled up’ total of the Budgeted Units for each of the Resource Assignments on that activity which have a Resource Type of Labor. Continue reading “Which Fields can be imported into Primavera P6 from Excel (XLS) Spreadsheet?”

Advertisements

What’s new in Primavera P6 Professional version 17.7

Well, in fact there is not any feature update on P6 Professional version 17.7. They just improve performance on Cloud version. So we don’t have to worry about it.

New Features:

What_s new in Primavera P6 Professional version 17.7-1

How to Check Out a Cloud Project to a Local Database in P6 Professional: Continue reading “What’s new in Primavera P6 Professional version 17.7”

Why is Unit of Measure not showing in Resource Usage Profile in Primavera P6

In Primavera P6 -> Resource Usage Profile, we may have a problem that Unit of measure is not showing.

There could be various causes for this issue:

1) If the resource is a Material resource, the Unit of measure is not specified.

FIX:

If the resource is a Material resource, you will need to specify the Unit of measure in Enterprise, Resources in the Details tab.

Why is Unit of Measure not showing in Resource Usage Profile in Primavera P6-2

2) If it is a Labor or Non-labor resources, the Show Unit label is not selected.

FIX:

If it is a Labor or Nonlabor resources, then make sure that in Edit, User Preferences in the Time Units tab the Show Unit label check box is checked. Continue reading “Why is Unit of Measure not showing in Resource Usage Profile in Primavera P6”

How to change currency in Primavera P6 and How is data stored when using multiple currencies

Sometimes we work in a project which use a different currency other than US dollar.

I will show you how to create new currency and using it for the new project.

Let’s say we have a new project:

How to change currency in Primavera P6 and How is data stored when using multiple currencies-1

This project will use Malaysia Ringgit (MYR). To create new currency, we go to menu Admin -> Currencies.

Click Add and enter information like below:

How to change currency in Primavera P6 and How is data stored when using multiple currencies-2

Now we will change to display currency in MYR. Continue reading “How to change currency in Primavera P6 and How is data stored when using multiple currencies”

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.

However in reality, we always adjust unit for each month/week differently.

Then How ‘Planned Value’ is calculated for Activities without linear distribution, by using Resource Curves or Manual distribution?

I will explain it in this article.

We have an simple project:

The resource assignment use Back Loaded curve: Continue reading “How does Primavera P6 calculate Planned Value Cost for Activities without linear distribution (using Resource Curves or Manual plan) in Earned Value Management”