The Column Properties window enables you to select your cost sheets.
The following table explains the fields and options in the Column Properties window:
Field | Description |
|---|---|
Name | Sheet name. |
Datasource | The name of the source. |
Element | To select the data element. |
Entry Method | The options and sub-options are: Manual Entry
Sheet
Formula |
Data Format | The options are:
|
Display Mode | The options are:
|
Total | The options are:
|
Column Position After | To indicate where the column must be positioned |
Delete | To delete the column properties. |
OK | To accept changes. |
Cancel | To cancel changes. |
The Type field enables you to select the following:
- Worksheet
- Earned Value Analysis (EVA)
- Activity Sheet
The Name field displays the name of the Earned Value Analysis (1 to 6).
If there is no data or sheet for that Name field, then the value will be zero in the Cost Sheet for that column. Once you refresh the EVA Sheet, the data will be rolled up to the Cost Sheet as a column.
The Column field enables you to select the currency and decimal fields from the Earned Value Analysis that are available to be rolled up into the Cost Sheet as a column.
Earned Value Management (EVM)
- pv (Planned Value - cost)
- ev (Earned Value - cost)
- ac (Actual Cost - cost)
- cv (Cost Variance - cost)
- sv (Schedule Variance - cost)
- bac (Budget At Completion - cost)
- eac (Estimate at Completion - cost)
- vac (Variance at Completion - cost)
- etc (Estimate to Complete - cost)
- forecast (Forecast - cost)
- remaining_cost (Remaining Cost - cost)
Note: The decimal type Data Element (DE) is available in the cost formula.
The Column Name field, in the Cell Details window, displays the DE field label in the respective Earned Value Analysis.
Note: You can have from 1 to 100 predefined cost DEs created in the Cost Sheet.