Product quality monitoring in custom columns in MS Project Server

Contents:

1. Creating the custom columns "Product by % complete" and "Product variance" in MS Project Server
2. Using the custom columns "Product by % complete" and "Product variance" in MS Project Server
3. Chat

Creating the custom columns "Product by % complete" and "Product variance" in MS Project Server

Using the % complete column and the planned number of products you can calculate how much of a task's product can be done. Let's create a column that will calculate this.

Steps to create custom columns: "Product by % complete" and "Product variance" 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: "Product by % complete" and "Product variance" 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 the custom column: "Product by % complete":
   1. Select the Formula in the "Custom Attributes" block.
   2. Enter the formula: "[Plan product] * [% Complete] / 100".
6. For the custom column "Product variance":
   1. Select the Formula in the "Custom Attributes" block.
   2. Enter the formula: "[Product by % complete] - [Actual product]".
7. To save click the "Save" button.

Using the custom columns "Product by % complete" and "Product variance" in MS Project Server

Steps to add custom columns: "Product by % complete" and "Product variance" 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 columns: "Plan product","Actual product", "Product by % complete" and "Product variance" in the "Fields" block.
5. To save click the "Save" button.

Steps to use custom columns: "Product by % complete" and "Product variance" 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.