Plan % complete in MS Project Pro

Contents:

1. Creating the custom column "Plan % complete in MS Project Pro
2. Compare the "Plan % complete" column with the "% complete" column
3. Adding graphical indicator for custom column "Remaining % complete"
4. Chat

Creating the custom column "Plan % complete" in MS Project Pro

The project manager can update the project after the end of the implementation period. But in the during project implementation project, manager want to know, what percent complete must be for each tasks. We can calculate it using the current date.

Steps to create the custom column "Plan % complete" in MS Project Pro:

1. Click the "Custom Fields" button in the "Properties" block in the "Project" item of the top menu.
2. Select field type "Task" in the "Field" block. 
3. Select type "Number" in the "Type:" field.
4. Select the empty field in the table and click the "Rename ...." button.
5. Add the "Plan % complete" name of field.
6. Click the button "Formula..." in the "Custom attributes" block.
7. Add the formula "IIf(NOW()<[Start];0;IIf(NOW()>[Finish];100;CLng(((NOW()-[Start])/([Finish]-[Start]))*100)))".
8. Click the "Ok" button in the "Formula for Plan % complete" window.
9. Click the "Ok" button in the "Custom Fields" window.

Compare the "Plan % complete" column with the "% complete" column

You can analyze the execution, compare the "Plan % Complete" column with the "% Complete" column.

Steps to create the custom column "Plan % complete" in MS Project Pro:

1. Click the "Custom Fields" button in the "Properties" block in the "Project" item of the top menu.
2. Select field type "Task" in the "Field" block. 
3. Select type "Number" in the "Type:" field.
4. Select the empty field in the table and click the "Rename ...." button.
5. Add the "Remaining % complete" name of field.
6. Click the button "Formula..." in the "Custom attributes" block.
7. Add the formula "[% Complete]-[Plan % complete]".
8. Click the "Ok" button in the "Formula for Remaining % complete" window.
9. Click the "Ok" button in the "Custom Fields" window.

Adding graphical indicator for custom column "Remaining % complete"

You can add graphical indicator to show the result of comparing the "Plan % complete" column with the "% complete" column

Steps to create the custom column with graphical indicator in MS Project Pro:

1. Click the "Custom Fields" button in the "Properties" block in the "Project" item of the top menu.
2. Select field type "Task" in the "Field" block. 
3. Select type "Number" in the "Type:" field.
4. Select the empty field in the table and click the "Rename ...." button.
5. Add the "Remaining % complete graph" name of field.
6. Click the button "Formula..." in the "Custom attributes" block.
7. Add the formula "Remaining % complete".
8. Click the "Ok" button in the "Formula for Remaining % complete graph" window.
9. Click the "Graphical indicator ..." button.
10. Choose the rules to test field in the "Test for Remaining % complete graph" column. 
11. Enter a value for the rules in the "Values" column. 
12. Choose a image in the "Images" column.
13. Set rules for summary rows and the project summary.
14. Click the "Ok" button in the "Graphical indicator for Remaining % complete graph" window.
15. Click the "Ok" button in the "Custom Fields" window.