For the purpose of this article, we are going to use the Date() function. Rarely a software project management tool comes with such a large number of in-built fields and functions. MS Project becomes a very powerful tool when you use its custom fields, functions, and build your own formulas. With these fundamentals in mind, let’s proceed to checking a few functions and fields in MS Project. For the best experience, you may want to go full-screen in HD mode and plug-in your earphones. To explain how to spot this comparison, I’ve created the below video. The whole idea of having a baseline is to have a comparison and measure progress.

Fundamentals–Baseline and Status DateĪs a management professional, you need to understand that comparison always happens against the latest baseline after one sets the status date. In the end, I’ll be creating a histogram report which compares the Planned and Actual Percent Complete.

I will also show the scenario by insertion of the milestone/task and recalculation. We will explore the concept of Planned Percent Complete and how to track it using the custom fields available in MS Project. Inspired by his project, I decided to write this article on the topic of Planned and Actual Percent Complete data within MS Project. Obviously, this stemmed from the way the formulas were put in! This had to be created.Īnother problem the engineering lead faced was getting negative values while having the planning percent complete with the created custom fields formula for the milestones. The (Actual) % Complete should have been visible in the tabular view of the Gantt Chart and in the generated histogram reports for L2 or 元 tasks of the work breakdown structure, but MS Project doesn’t have a Planned % Complete field. The client’s requirement was to show both Actual Percent Complete and Planned Percent Complete in the MS Project Plan. The lead was managing a bridge construction project in the Middle East. While interacting with MS Project users across a couple of industry verticals recently, I encountered a question from a senior mechanical engineering lead regarding Planned and Actual Percent Complete fields.

Project Portfolio Management (PPM) Training.

Project Management Office (PMO) Training.

Enterprise Project Management (EPM) Training.

Project Management Certification Training.

Project 2016 full crack