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

Highlight Tasks that are behind schedule on a MS Project Gantt Chart

20 weeks 1 day ago

Do you want to highlight tasks that are late on your Microsoft Project Lookahead schedule Gantt chart? Then follow the steps outlined in this video on how to format Bar Styles to draw focus to tasks that are late when compared to their baseline finish dates.

Read more...
 

Display Variance against Multiple Baselines in Microsoft Project

45 weeks 2 days ago

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

Read more...
 

Add a milestone on a Task bar in Microsoft Project

1 year 1 day ago

This YouTube video demonstrates one way to add a milestone on a Microsoft Project Task bar (same row), e.g., Stage Gate, Go-Live date or a Decision Point.

Note that for this solution to work, the Task Mode must be set to Auto Scheduled.

Read more...
 

Quick way to find P6 Activities with Lag

1 year 3 weeks ago

Finding relationship lags between activities in Primavera P6 is not as straightforward as one would like it to be. Out of the box, you either manually check each activity’s relationship or create a report detailing lags.

But what if you want to apply a filter to a layout? The workaround in this video shows how to create a filter for displaying only activities with lags or leads in a

Read more...
 
Lags, Primavera 6

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

1 year 6 weeks ago

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.

Read more...
 

10 LinkedIn Profiles Project Planners and Schedulers Should Follow

1 year 7 weeks ago

The LinkedIn profiles below will be the first 10 profiles I would recommend to any Project Planner or Scheduler looking for people to follow on LinkedIn, as reading these peoples’ posts, comments and likes will enrich your LinkedIn feed.

I learn from these Subject Matter Experts (SMEs) and Microsoft Most Valuable Professionals (MVPs

Read more...
 
LinkedIn

Show mmm-yy date format in a Microsoft Project schedule

1 year 9 weeks ago

Sometimes during project budget proposal requests, bidders might only want to show indicative dates in their bid schedules to the client and an easy way to do this is by showing only the month and year of a task in a Microsoft Project schedule.

Another scenario for displaying schedule dates in mmm-yy (month & year) format is when the schedule is a summary roll-up (Level 1 or 2) for

Read more...
 

Display different date formats in different Views of same Microsoft Project schedule

1 year 10 weeks ago

While Primavera P6 users are restricted to same date format for all Layouts of a schedule, Microsoft Project users have the luxury of using different date formats in different Views of the same schedule.

While in one View, you might display dates in “dd-mmm ‘yy” format, in another View of the same schedule, you can display dates in “dd month year”, so different audiences can have

Read more...
 

How to remove suffixes from dates and display both dates for milestones in Primavera P6

1 year 51 weeks ago

If you came into Primavera P6 from a Microsoft Project background, you would have noticed that actual dates have the suffix “A” appended to them, and constrained dates also have an asterisk appended. And milestones have a blank date field depending on the type of milestone.

In this YouTube video, I will show you a trick you can use to

Read more...
 

How to create a Lookahead Filter in Microsoft Project

2 years 1 week ago

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

Read more...