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”

Advertisements

How does Primavera P6 summarize data in the Summary / Grouping Band

We may wonder How does P6 calculates and displays summary information for costs, quantities, user defined fields, dates, durations, float, progress…

I will explain it in this article.

These calculations and display summaries are based on the currently visible activities. Activities removed from the layout by filters are not included in the calculations and summaries.

Costs and quantities:

P6 totals cost and quantity data items, such as budgeted cost and budgeted quantity, by adding the values for each activity in the summary.

Dates: 

If you display early dates, P6 shows the earliest early (or actual) start and the latest early (or actual) finish dates. The same rules apply for late dates and baseline early and late dates. Continue reading “How does Primavera P6 summarize data in the Summary / Grouping Band”

Primavera P6 Professional : “Unable to connect to the database” error

When connect SQL database in Primavera P6 Professional, we usually have problem like:

  • Error Message:  Bad public user Name or password. SQL Server Error: [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.
  • Error message: Bad public user name or password. SQL Server Error: [DBNETLIB][ConnectionOpen (Invalid Instance()).] Invalid connection.;”
  • Error Message:  Bad public user name or password. Database Server Error: Login failed for user ‘pubuser’.

Below are some Reason and Solution:

CAUSE 1:
Incorrect hostname, instance or database name
Bad public user Name or password. SQL Server Error: [DBNETLIB [ConnectionOpen(Connect()).]SQL Server does not exist or access denied.;

The default configuration entries for a standalone installation are localhost\primavera for the server host name and PMDB$primavera for the database name.

FIX 1:
Click back to the Database Configuration and correct the database name or hostname or instance.

Primavera P6 Professional Unable to connect to the database error-1

Continue reading “Primavera P6 Professional : “Unable to connect to the database” error”

How to Print the Legend for Stacked Histogram in Resource Usage Profile in Primavera P6

We create a Stacked Histogram like below picture:

How to Print the Legend for Stacked Histogram in Resource Usage Profile in Primavera P6-1

We need to Print the diagram with the Legend but there is no option to show the Legend:

How to Print the Legend for Stacked Histogram in Resource Usage Profile in Primavera P6-5

 

In other diagram (not stacked diagram) we can easily see the option to show Legend: Continue reading “How to Print the Legend for Stacked Histogram in Resource Usage Profile in Primavera P6”

What is Primavera P6 Professional latest version?

Primavera P6 Version History

Version Release Date Detail Information
16.2 30-Sep-2016 What’s new in version 16.2

P6 Professional 16 R2 Documentation

16.1 31-Mar-2016 What’s new in version 16.1

P6 Professional 16 R1 Documentation

15.2 30-Sep-2015 What’s new in version 15.2

P6 Professional 15 R2 Documentation

15.1 31-Mar-2015 What’s new in version 15.1

P6 Professional 15 R1 Documentation