Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Quick Tip: How to trace out of sequence activities in Primavera P6

2 years 9 weeks ago

If your Primavera P6 schedule is set to use the Retained Logic for out of sequence activities and you notice that despite all the predecessors of an activity being 100% complete, the activity’s Start Date is not on the Data Date as one would expect or the Finish Date is much later than the

Read more...
 

How to show Primavera P6 dates in month-year (mmm-yy) format

2 years 20 weeks ago

The date formats available in Primavera P6 are very limited and to best of my knowledge, you cannot get the mmm-yy (month-year) format straight out of the box. You might want to display dates in mmm-yy if you don't want to show exact dates in issued schedules.

This P6 video outlines a workaround using UDF that can be used to achieve mmm-yy date format.

Read more...
 

Microsoft Project Quick Tip: Assign Actual Start & Finish Dates to Tasks

2 years 27 weeks ago

While one can update Actual Start and/or Actual Finish dates in Microsoft Project by displaying these columns, my preferred method is using the Task Details Form which is very similar to the Activity Details Form in Primavera P6.

In this short video, I show how to enable and use the Task Details Form to update actual dates for project tasks.

Read more...
 

How to use Lumpsum cost in Primavera P6 to generate S-curves data

2 years 38 weeks ago
When it comes to generating Primavera P6 data for use in Excel to plot progress s-curves, the recommended practice is to use Resources as basis for progress measurement in P6, but there are times when it is not possible to use Resources either because of corporate policy, non-availability of resource loading or personal choice. A common alternative method is to use lumpsum cost as weightings
Read more...
 

How to show a column of week numbers in a Microsoft Project schedule

2 years 45 weeks ago

There are times when stakeholders use week numbers to discuss the dates in a project schedule and they would like to see columns of week numbers in the schedule. The tutorial outlines steps to follow in order to display week numbers such as "2021 Week 35" in a Microsoft Project schedule.

The tutorial uses 2 custom fields with formulas to show "Start Week No." and "Finish Week No."

Read more...
 

Show summary % complete in Microsoft Project when all subtasks are milestones and some of these milestones are completed

2 years 45 weeks ago

In Microsoft Project, when all subtasks are milestones, the summary percent complete is 0% even when some of the milestones are completed. The summary percent complete only changes to 100% when all the milestones are 100% complete.

This behaviour is as expected as Microsoft Project calculates percent complete using actual duration but since

Read more...
 

How to show Baseline Execution Index (BEI) in Microsoft Project

2 years 51 weeks ago

The Defense Contract Management Agency (DCMA) 14-Point Assessment is a set of metrics used to evaluate the quality of a project schedule to ensure that the schedule is fit for purpose. And one of the 14 metrics is the Baseline Execution Index (BEI) which is an indication of how a schedule is performing against a set baseline and the video below explains how to set-up a

Read more...
 

Add Decimal Places to Microsoft Project % Complete

3 years 2 weeks ago

By default, Microsoft Project does not display task % complete numbers with decimal places. In this tutorial, you will learn how to add decimal places to % complete using custom fields.

 

Read more...
 

How to Use Traffic Light to Show Microsoft Project Progress Status

3 years 4 weeks ago
Sometimes in a Microsoft Project schedule, you might want a quick visual indicator of when a task is behind schedule or in progress and a good way to achieve this is through the use of a traffic light system. This tutorial will show you how to configure your Microsoft Project schedule using a custom field with graphical indicator to highlight progress of tasks as at current or status date.
Read more...
 

Microsoft Project Baseline Percent (%) with Weighted Summary Roll-up

3 years 5 weeks ago

By default, Microsoft Project does not have a baseline percent (%) complete field or column like you would find in other scheduling software like Primavera P6.

This video outlines steps to follow if you want to display a baseline percent (%) complete column in a Microsoft Project schedule. It also shows how to roll-up percent (%) complete to summary tasks based on weighted percent (%)

Read more...