Blogs

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:

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

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.

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

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 Microsoft Project schedule to display BEI.