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:

  • BL Project Finish : Activity finish date from Project Baseline
  • Variance – BL Project Finish : Duration between BL Project Finish date and current Finish date. Calculated as BL Project Finish – Finish

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

Now we will create Indicator.

Go to menu Enterprise -> User Defined Fields.

Click Add to create new.

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

Enter Title and Select Data Type : Indicator

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

Close dialog.

Go to menu Tools -> Global Change. Click New.

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

Enter data as in below picture:

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

Click on Change button. Then Commit Change button

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

Click OK and Close.

We will show the Indicator column.

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

Now we can quickly see what activity is behind schedule:

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

We can do in similar way for the Cost.

We can show these column the see whether an activity is over budget:

  • Budget At Completion : Cost from Project Baseline
  • At Completion Total Cost = Actual Total Cost + Remaining Total Cost
  • Variance – BL Project Total Cost : is calculated as Budget At Completion – At Completion Total Cost

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

Create User Defined Field : On Budget Status:

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

Create new Global Change with below information:

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

Click on Change button. Then Commit Change.

We will show the Indicator column.

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

Now we can quickly see what activity is over budget:

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

 

Advertisements

Author: doduykhuong

Chief Planning Engineer. Scheduler. Oracle Primavera P6 Certified Specialist. Provide Primavera P6, Microsoft Project Tips & Tricks

10 thoughts on “How to quickly identify Behind Schedule and Over Budget activity by Indicator UDF in Primavera P6”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s