![]() Status Date: Gives the status date of the project.Īs you can see, we have the below project with its phases, work packages, and milestones.Īs highlighted above, we will be using three number custom fields (and a text custom field).Baseline Duration: Gives the baseline duration of the task.Baseline Start: Gives the baseline start date of the task.Of the available built-in fields in MS Project, we are going to use: ![]() Nevertheless, you can use the DateDiff() function, as well. firstdayofweek and firstweekofyear (optional fields): The first one is a constraint constant that specifies the first day of the week, whereas the second one is a constraint constant that specifies the first week of the year.įor the sake of example, I’m going to use the ProjDateDiff() function.interval and dates (required fields): The interval time between date1 and date2.calendar (optional): The calendar to use when calculating the duration.Īnother widely used Date() function is the DateDiff() function, which, as per MS Project software API documentation, also returns a time interval between two dates in a long format.ĭateDiff( interval, date1, date2] ).date2 (required field): The date used as the end of the duration.date1 (required field): The date used as the beginning of the duration.Hence, when we wish to calculate in days, we have to divide by 480, because a day will have 480 minutes. ![]() For the purpose of this article, we are going to use the Date() function.Īs per MS Project software API documentation, this function returns the duration between two dates in minutes. 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. In the end, I’ll be creating a histogram report which compares the Planned and Actual Percent Complete.Īs a management professional, you need to understand that comparison always happens against the latest baseline after one sets the status date. 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.
0 Comments
Leave a Reply. |