Blogs

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:

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.

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.

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.

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 (%) complete of the subtasks.

Sometimes during tender or bid submission for a project, the client might not provide a Project start date and bidders would be required to show ordinal dates in the Gantt chart timeline and calendar days in the start and finish dates columns, so that, for each activity, the schedule will show start and finish days, e.g. for a 10-day activity, the schedule will show day 1 in the start column and day 10 in the finish column.