how to reference microsoft project professional 2016 help

Figure 2: Entering the Auto RAG formula in an MS-Project® custom text field formula box Put this in the “formula box” (see figure 2). Be aware that MS-Project will strip out the spaces and returns, so the formula will look a lot less readable if you ever have to come back to edit it. I have formatted this to make it more readable. For example, to test whether an item should have finished by now, test for ), 'A', You need to formulate the tests as a mathematical expression that when evaluated will return a TRUE or FALSE result. Green = Item forecast to finish on baseline finish date or earlier.Amber = Item forecast to finish later than baseline finish date.Red = Item that should be complete by now but isn’t.

Some simple date-based may look something like this (this assumes the plan has been baselined): Your central PMO may have some criteria, or you may devise your own. To calculate RAG status in MS-Project ®, first devise a set of criteria that you will use to determine RAG status, based on the rules or criteria in place for your project or programme. This approach can’t account for subjective things like project risks (that takes professional judgement), but it can give a useful “starter for ten” RAG status assessment onto which the PM can layer factors such as risk, or to act as the starting point of a discussion. The more objective approach presented here introduces schedule automation to calculate RAG status in MS-Project ®, assigning a RAG rating to individual project tasks based on calculation. But too much subjectivity in status reporting can lead to watermelon or green-side-up reporting, in which project status is reported more favourably than it probably should be. RAG status is often allocated to project tasks based on the intuition or “gut feel” of the project manager. So why would you want to use this approach, how do you do it, and what’s in it for you as a result? The Why This post describes how to calculate RAG status in MS-Project ® by customising a text field to performing some simple tests and calculations with dates.

You will probably review the programme schedule regularly – focussing on on items with Red or Amber RAG status – but how do you use MS-Project® to ensure that you don’t skip items that probably should have been marked amber or red? So you’ve created a useful programme schedule, and you are now working on keeping it on the right track, reviewing the plan regularly with the Programme Manager and Project Managers. Part of a series on customising Microsoft® Project® to make working with project schedules more useful.

How to reference microsoft project professional 2016 help