Risk analysis based on % complete in MS Project Pro

Contents:

1. Planning tasks slack in MS Project Pro
2. Create the graphical indicator tasks risks in MS Project Pro
3. Chat

Risk analysis based on % complete in MS Project Pro

Analyzing the ratio of the columns of the percentage of completion of tasks by duration to the percentage of completion by volume, one can draw conclusions about the level of riskiness of the task. We distinguish three levels of risk:

• If the amount of time spent is less than the closed amount, then the level of risk is minimal (green)
• If the amount of time spent is more 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)

Steps to create the formula for the graphical indicator in MS Project Pro:

1. Click the “Project” item in the top menu.
2. Click the “Custom Field” button in the “Properties” block.
3. Set the “Task” in the block field.
4. Select the “Number” in the “Type:” field.
5. Select the empty row of the list of the field.
6. Rename the field:
   1. Click the “Rename …” button.
   2. Entered the “GI Ratio % Complete” in the field.
   3. Click “Ok” button.
7. Add the formula:
   1. Click the “Formula …” button.
   2. Click the “Field” button in the “Formula for “Gr. Slack” window.
   3. Enter the formula: “(Abs((IIf([Physical % Complete]=0,1,([% Complete]/[Physical % Complete])))-1))*100”.
   4. Click the “Ok” button.
8. Set the calculation for task and summary group by click the “Use formula” box.
9. Click the “Ok” button.
10. Add your custom field and check.

Create the graphical indicator tasks risks in MS Project Pro

Steps to create the formula for the graphical indicator tasks risks in MS Project Pro:

1. Click the “Project” item in the top menu.
2. Click the “Custom Field” button in the “Properties” block.
3. Set the “Task” in the block field.
4. Select the “Duraction” in the “Type:” field.
5. Click the "Graphical indecators ..." button.
6. Select the "is less than or equal to" in the "Test for "GI Ratio % Complete" field.
7. Set the "30" in the "Value(s)" field.
8. Set the green image in the "Image" field.
9. Add a new row.
10. Select the "is greater than" in the "Test for "Gr. Slack" field.
11. Set the "30" in the "Value(s)" field.
12. Set the red image in the "Image" field.
13. Click the "Show data values in ToolTips" box.
14. Set rules for the summary rows:
    1. Click the "Summary rows" box.
    2. Click the "Summary rows inherit criteria from nonsummary rows" box.
15. Set rules for the project summary rows:
    1. Click the "Project summary" box.
    2. Click the "Project summary rows inherit criteria from summary rows" box.
    3. Click the “Ok” button in the "Graphical Indicators for "GI Variance" window.
16. Click the “Ok” button