FREE e-learning for Microsoft Project for the web
Sign Up
Download PPT: Sensei IQ Brief
Sign Up

Insights

Creating a Critical Path Indicator with Microsoft Project

10 mins read /
10 mins read
Raphael Santos

Introduction

When using Microsoft Project to track their projects, Project Managers want to have the ability to identify any issues that may harm their schedules. One of the best ways to achieve this goal is through the utilization of graphical indicators.

By default Microsoft Project offers an out-of-the-box graphical indicator called ‘Status Indicator’, which presents the current status of a task (to know more about this field, follow this link). In addition, you can create your own custom indicator, based on a formula of your choice.

This article will illustrate how to create a new graphical indicator for the tasks, based on their finish variance and critical path.

Choosing the criteria

The challenge when creating a new schedule indicator begins in choosing the criteria; if your company is going to use the traditional stoplights, what should be the rules applied to the indicator in order to show the red, yellow and green colors?

The most common answer for this question is to use the percent of variance. In this case, if a barrier is broken, then the indicator changes its color automatically. One common example is:

The utilization of rules based on the percent of variance is a good way to see how much the task is slipping compared with what was planned. To create a custom field that calculates the percent of variance in your schedule, follow these steps:

    1. In the Ribbon, click on Project > Custom Fields.
    2. In the Custom Fields dialog, select the Number Type.
    3. Select a number field that has not been used and click Rename. In this example, I will call this field ‘% of Finish Variance’. Click OK.
    4. In the Custom attributes area, click on the Formula button. This will launch the editor dialog, where you can create the formula you want to use. In this example, copy and paste the following formula:

IIf([Baseline Finish]=ProjDateValue(“NA”) Or [Milestone],0,[Finish Variance]/[Baseline Duration]*100)

  1. In the Calculation for task and group summary rows area, choose the Use formula option. Click OK to finish the creation of the custom field

Now, let’s have a look at the picture below. It shows a project plan to implement Project Server 2013:

Once your schedule is revised and ready, you can save its Baseline. After that, you will have to insert in the Entry Table the custom field that has been created:

Now let’s say that a resource calls you to say that task number 3 – Prepare infrastructure – needs one more day to be completed. So, instead of 5 days, you will log 6 days as the duration for this task. The result will be:

After changing the duration of the task from 5 to 6 days, it is possible to see that now the field ‘% of Finish Variance’ is showing the number 20, which represents the percent of variance for this task based on what was planned (1 day of variance over 5 planned days of duration). If we were following the criteria proposed for the graphical indicators, it would show the red icon (percent of variance greater than 10%). However, even though the task has a high percent of variance, this variance is not yet causing impact on the overall project. The reason for this is that this task is not in the Critical Path (in other words, this task still has space to be delayed without delaying the project’s finish date).

Let’s look at another simulation. You received a call from your customer, saying that the task number 6 – Interviews with Project Management Key-users – will not start on August 10th as planned, because they will have a critical meeting and not all of the PMs are going to be available. So you change the start of the task to the new proposed date – Tuesday, August 11th. The result will be:

Now we can see that the change we made in this task represents 10% of variance over the planned finish date – and, considering the proposed criteria for the indicator, it should show the yellow icon (percent of variance between 1% e 10%). However, the change on this task has an impact in a considerable number of tasks in the schedule, including the project finish date – as we can see, now the project has a finish variance of 2.7%. And that is because this task is part of the critical path.

So, the point is: even if the task has a minimum percent of finish variance, we should take a closer look to see if it is part of the critical path – because this variance will affect the entire project. At this point, we could consider creating a graphical indicator based on the following criteria:

Creating the Critical Path Indicator

To create the custom graphical indicator, follow these steps:

    1. In the Ribbon, click on Project > Custom Fields.
    2. In the Custom Fields dialog, select the Text Type.
    3. Select a text field that has not been used and click Rename. In this example, I will call this field ‘Critical Path’. Click OK.
    4. In the Custom attributes area, click on the Formula button. This will launch the editor dialog, where you can create the formula you want to use. In this example, copy and paste the following formula:

IIf([Baseline Finish]=ProjDateValue(“NA”),”No Baseline”,IIf([Finish Variance]>0 And [Critical],”Critical Finish Variance”,IIf([Finish Variance]>0 And Not [Critical],”Non-critical Finish Variance”,”No Variance”)))

    1. In the Calculation for task and group summary rows area, choose the Use formula option.
    2. In the Values to Display area, click in the Graphical Indicators button. After that, you can choose the icons you want to show, as seen below:

  1. At the left upper corner of the dialog, select the options Summary rows inherit criteria from nonsummary rowsand Project summary inherits criteria from summary rows.
  2. Click OK, and then OK again to finish the creation of the graphical indicator.

After creating the graphical indicator, you will have to add it to the Entry Table:

Now you can have a better understanding of your project, by combining the percent of finish variance for the task (which is an important information) with the real impact this finish variance is causing on your schedule.

About Raphael Santos

PMP, Microsoft Project MVP

Raphael Santos, Principal Consultant at Sensei Project Solutions, is a PPM enthusiast, with expertise in providing Microsoft Project, Project Online and Project Server solutions. He has worked in several projects to implement PPM tools, including countries in Latin America (Brazil, Peru and Argentina), in the United States and in Africa. He is also a trainer, with more than 10 years of experience in teaching users on how to use Project Management tools in a more productive way. In 2016, Raphael was awarded with the MVP title by Microsoft, in recognition to his contributions in the Project Management community.

About Sensei project solutions

Sensei Project solutions is a recognized global leader in Microsoft project and portfolio management (PPM) solutions focused on improving the way your team works. Sensei’s unique turn-key PPM Platform in the Microsoft Cloud, Sensei IQ, is designed around your needs and a modern way of working. Sensei IQ helps you make informed decisions by understanding how all work fits together with meaningful insights into projects, resources and programs across your portfolios.

Share on:

Recent Sensei news

5 MIN
How-To, Planner, Program/portfolio management, Project for the web, Project management
10 MIN
Case Study
How-To, Program/portfolio management, Project management, Resource management, Work Management
5 MIN
How-To, Planner, Program/portfolio management, Project for the web, Project management
10 MIN
Case Study

let’s GET
STARTED

Interested in learning more? Fill out this form and we’ll be in touch.

address(Required)
Interested in: