Microsoft Project

Display Variance against Multiple Baselines in Microsoft Project

Do you want to carry out variance analysis against more than one baselines in Microsoft Project but cannot find a way to do so out of the box?

Custom Field is my go to feature whenever I need a workaround in Microsoft Project and again they have come to the rescue. In this YouTube video, I demonstrate how to calculate and display variances against multiple baselines (Baseline1 to Baseline10) and not just Baseline (Baseline0) field.

 

2 Ways to Create Level of Effort or Hammock Tasks in Microsoft Project

While Microsoft Project does not have a straight of the vbox Level of Effort activity type like primavera P6, you can still add Hammock or Level of Effort tasks to your Microsoft Project schedule, using one of 2 workarounds. 

The first workaround is the recommended method from Microsoft while the second method is one that is very common in the subsea construction world.

 

How to create a Lookahead Filter in Microsoft Project

How would you like to create a rolling date lookahead filter in Microsoft Project instead of using the default Date Range filter? Users of Primavera P6 are used to defining the criteria for lookahead filters using Data Date or Current Date and we can also do same in Microsoft Project using Status Date or Current Date rather than pick hard dates all the time using the Date Range filter.

Filed Under

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

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.

Filed Under

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

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." columns. The formulas for these 2 columns are: