Risk analysis based on % completion in MS Project Server

Contents:

1. Risk analysis based on % completion in MS Project Server
2. Configuring the “Percentage Complete Analysis” columns in MS Project Server
3. Configuring the Task Tracking view in MS Project Server
4. Chat

Risk analysis based on % completion in MS Project Server

By analyzing the ratio of the percentage of task completion by duration to the percentage of completion by volume, we can draw conclusions about the level of risk of the task. Let's highlight three levels of risk:

• If the amount of time spent is less than the closed volume, then the level of risk is minimal (green).
• If the amount of time spent is greater than the closed volume, but not more than half, then the risk level is medium (yellow).
• If the amount of time spent is more than twice the closed volume, then the risk level is high (red).

Configuring the “Percentage Complete Analysis” columns in MS Project Server

To setting up earned value columns:

1. Select the “Server Settings” menu item.
2. Go to “Enterprise Custom Fields and Lookup Tables”
3. In the “Enterprise Custom Fields” table, click the “New Field” button.
4. In the window that opens, enter a unique name for the custom field in the “Name” field.
5. Under “Entity and Type select:
   1. Entity - Tasks. 
   2. Type - Number.
6. In “Custom Attributes,” click the “Formula” button and insert the required field. For example, "IIf(([Physical % Complete] = 0), 0, ([% Complete] / [Physical % Complete]))".
7. In “Values to Display” configure the graphical indicator. For example, indicator conditions:
   1. is greater than 1.1 - red yellow,
   2. is less than 0.9 - blue,
   3. is any value - green.
8. Check the box next to “Show data values in tooltips.” In “Display values,” set the conditions for the graphical indicators for: “Total rows” and “Total project tasks.”

Configuring the Task Tracking view in MS Project Server

To customize the “Task Tracking” view:

• Select the “Server Settings” menu item.
• Go to “Manage View”
• Find the “Task Tracking” view in the “Manage View” table.
• In the “Edit View: Task Tracking” window, in the “Table and Fields” section, add the custom fields created above from the “Available fields:” list to the “Displayed fields” list.
• Save the created view.