Product quality management in custom columns in MS Project Server

Contents:

1. Creating custom column "% Product Complete" in MS Project Server
2. Using custom column "% Product Complete" in MS Project Server
3. Chat

Creating custom column "% Product Complete" in MS Project Server

MS Project Server has a column "Phsical % complete" for set the percentage of physical readiness of the product. Project manager with responsible for the task  estimate what percentage of the task product is ready. But this assessment is always subjective.

For an objective assessment, you can add custom columns for the calculation "% Product Complete". The data for the calculation is taken from custom columns with plan and actual values.

You can add two custom columns to control physical volumes. The first custom column shows the deviation ("Remaining product" field) of the planned from actual values.

Steps to create custom columns: "Plan product", "Actual product" and "% Product Complete" in MS Project Server:

1. Open MS Project Server
2. Click the "Server Settings" item in the left menu.
3. Click the "Enterprise Custom Fields and Lookup Tables" item in the "Enterprise Data" block.
4. To create the custom fields, click the "New Field" button.

Steps to create custom columns: "Plan product", "Actual product" and "% Product Complete" in MS Project Server:

1. Enter the field name in the "Name" field. 
2. Enter the field description in the "Description" field. 
3. Select the "Task" in the "Entity" field.
4. Select the "Number" in the "Type" field.
5. For custom columns: "Plan product", "Actual product" select the "None" in the "Custom Attributes" block.
6. For the custom column "% Product Complete":
   1. Select the Formula in the "Custom Attributes" block.
   2. Enter the formula: "IIf([Plan product] = 0, 0, [Actual product] * 100 / [Plan product])".
7. To save click the "Save" button.

Using custom columns "Plan product", "Actual product" and "% Product Complete" in MS Project Server

Steps to add custom columns: "Plan product", "Actual product" and "% Product Complete" in MS Project Server:

1. Click the "Server Settings" item in the left menu.
2. Click the "Manage Views" item in the "Look and Feel" block.
3. Click the "Tasks Schedule" view.
4. Add the "Plan product", "Actual product" and "% Product Complete" in the "Fields" block.
5. To save click the "Save" button.

Steps to use custom columns: "Plan product", "Actual product" and "% Product Complete" in MS Project Server:

1. Click the "Projects" item in the left menu.
2. Select the project and click the project name.
3. Click the "TASK" item in the top menu. 
4. Select the "Tasks Schedule" view in the "View" field in the "Data" block.
5. Click the "Edit" button in the "Project" block and select the "In Browse" item.
6. Enter data in the "Plan product" and "Actual product" fields.
7. To save click the "Save" button.