New Post at MPUG: Add a Calculated Status Indicator to MS Project

My latest article for MPUG was published today: Add a calculated status indicator to detail tasks in MS Project.

This is an update to one of the most popular articles I’ve ever written. It shows how to add Red / Amber / Green stoplights to the detail-level tasks in an MS Project plan, based on the task Start and Finish dates and the % Done fields. This is an abbreviated version of a chapter in the second edition of my book, Microsoft Project Hacks, due out later this year. I’ll announce here when it’s available.

As always, thanks for taking the time to read my stuff.

Because You Purchased …

A couple of months ago, I purchased a copy of Roy Underhill’s “The Woodwright’s Eclectic Workshop” at a bricks-and-mortar store and gave them my Email address. I just got an Email from them with recommendations based on that purchase. The list included six more books on traditional woodcraft by Roy, one on woodworking in colonial America by Keith Wilbur, and “Gun Digest Guide to Concealed Carry Handguns” by Dick Jones.


Still worried about Artificial Intelligence taking your job?


New Post at MPUG: Add a Cutover Weekend to MS Project

My latest article for MPUG  was published today: Add a Cutover Weekend Calendar to MS Project.

Part of the challenge in scheduling weekend work in Microsoft Project is isolating that “exception” weekend to just the tasks of interest. In this article, I show how to create a special-purpose calendar that inherits the holidays already defined in the main calendar, but identifies selected days that aren’t normally working days as exceptions. This calendar can then be applied to whatever tasks are in scope for that working weekend. I also show how to apply exceptions to specific resources, so weekend tasks can be assigned to them.

As always, thanks for taking the time to read my stuff.