Roll Up Earned Value Analysis to Cost Sheet

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

  • Direct entry into cell
  • Line item content

Sheet

  • Type (See below for details)
  • Name (See below for details)
  • Column (See below for details)

Formula
Data Format

The options are:

  • Currency
  • Percentage
  • Decimal
Display Mode

The options are:

  • Show
  • Hide
Total

The options are:

  • Blank
  • Sum of All Rows
  • Use Formula Definition
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, the value will be zero in the Cost Sheet for that column. After 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.