Skip to Content

Tag Archives: Formula

Best Practices for Making Use of Formulas in Microsoft Project

  Project Management Institute (PMI)® Professional Development Units (PDUs): This Webinar is eligible for 1 PMI® PDUs in the Technical category of the Talent Triangle.   Event Description: Take your Microsoft Project plans to the next level by learning how to use formulas to compute key project information. Learn when a formula will work and…

MS Project Formula Tips

Microsoft Project formulae are a powerful way to introduce custom calculations into your project plan. Many people who may be familiar with writing formulas in Excel find Microsoft Project’s formula editor a little less intuitive, so this article will give you a basic introduction to formulas in MS Project. I hope you can get started…

The Magic Formula and Manual Work Assignment

We all know that the heart of MS Project is the “magic” formula: Work = Duration * Units. This formula works with automatically scheduled tasks, but does it always work? Let me illustrate my point by creating a simple project with two tasks: As you can see, Work is 0 hours, because there are no…

Smart Numbering Master Schedule Tasks

In a Consolidated Schedule, volatile IDs will show repeated numbers representing a task’s ID in a subproject.  This creates confusion and it is difficult to search a task by ID.  Therefore, when using a Consolidated Schedule (Master Schedule)[1], you need to differentiate one project from another.  One way to do this is to use a…

Webinar: Project Talk – Formulas in Project and Project Server

Project Management Institute (PMI)® Professional Development Units (PDUs): This Webinar is eligible for 1 PMI® PDU in the Technical Category of the Talent Triangle. Event Description: You have decided to put calculations into Microsoft Project or Project Server? Sounds simple! So join us on Project Talk with your ideas and questions. Learn the steps needed…

Webinar: Tips, Tricks, and Best Practices for Using Microsoft Project

Please log in above or start a free trial to view this video   Project Management Institute (PMI)® Professional Development Units (PDUs): This Webinar is eligible for 1.5 PMI® PDU in the Technical Category of the Talent Triangle. Event Description:  Looking for ways to make your projects more efficient, wow your co-workers, and learn some…

Project Date Numbering

Often a schedule is prepared without knowledge of an actual start date. For example, a proposal may be prepared and shown to a customer who wants to know what happens on each day of the project without regard to a calendar date. This article shows how to present a schedule using “Project Days” instead of…

An Update Status Indicator for Microsoft Project

A simple but effective “Update Status Indicator” can be generated using the excellent Custom Fields features available in Microsoft Project 2000 and later versions. When you need to revise a large project plan, how do you identify those tasks that need updating? By constructing the custom field I describe below, you’ll get red, blue and…

Please enter your email to continue viewing