In addition to the system defined columns that are added to the earned value sheet automatically (BAC, BCWS, BCWP, ACWP, EAC), you can create columns for your own formulas.
You can define additional columns on a sheet the EV sheet source is Schedule Manager, and the display option is set to Show By: Cost.
To add a column to the earned value sheet
- Open the earned value sheet.
- Click the Columns button. The Column Log window opens.
- Click New. The Column Properties window opens.
- Complete the fields and click OK.
Note: You can create formulas based on any of the columns on the earned value sheet.
In this field | Do this |
|---|---|
Name | Name the column. |
Datasource | Select a data source. Available selections depend upon the level of the earned value sheet. Summary Level: Select components from the detail-level earned value sheets included in the summary sheet settings. Each selection will generate a column in the summary earned value sheet. Detail Level: Earned Value 1 to 25. Allows you to define your own formulas Custom curves, BAC, BCWS, BCWP, ACWP, EAC are default columns that cannot be edited or deleted. |
Entry Method | The sheet accepts formulas only. Your options depend upon the level of the earned value sheet. Summary Level: The entry level is unavailable. Detail Level: Requires a formula. Click Create to create a formula. |
Data Format | Choose Currency or Percentage. This defines how the value is displayed on the sheet. |
Display Mode | Choose to Show or Hide the column on the sheet. |
Total | Choose how to display the summary row, which is the last row for the column: Blank to leave the summary row blank; Sum of All Rows to add up all the rows; or Use Formula Definition to apply the columns formula to the last column (based on values in other summary rows). |
Column Position After | Choose a column. The new column will be placed after the selection. |