Roll Up Activity Sheet to Cost Sheet

The Column Properties window enables you to select your cost sheets.

The Type field enables you to select the following:

Worksheet
Activity Sheet

The Name/ID field displays the name of the worksheet that you have selected; otherwise, this field displays the Activity Sheet, using the following naming conventions:

Activity Sheet 01 (Activity) - for Activity Sheet with ID 01
Activity Sheet 01 (Resource)

If there is no data or sheet for that ID, then Unifier displays an error message when you click OK, after making the selection, and the value will be zero in the Cost Sheet for that column.

The Column field enables you to select the currency and decimal fields from the Activity Sheet that are available to be rolled up into the Cost Sheet as a column.

Assignments

uuu_P6PlannedCost (Planned Cost - cost)
uuu_P6ActualCost (Actual Cost - cost)
uuu_P6AtCompletionCost (At Completion Cost - cost)
uuu_P6RemainingCost (Remaining Cost - cost)
uuu_P6PlannedUnits (Planned Units- Units)
uuu_P6ActualUnits (Actual Units- Units)
uuu_P6AtCompletionUnit (At Completion Units- Units)
uuu_P6RemainingUnits (Remaining Units- Units)

Activity

uuu_P6PlannedTotalCost (Planned Total Cost - cost)
uuu_P6ActualTotalCost (Actual Total Cost - cost)
uuu_P6AtCompletionTotalCost (At Completion Total Cost - cost)
uuu_P6RemainingTotalCost (Remaining Total Cost - cost)
uuu_P6PlannedTotalUnits (Planned Units - units)
uuu_P6ActualTotalUnits (Actual Units - units)
uuu_P6AtCompletionTotalUnits (At Completion Units - units)
uuu_P6RemainingTotalUnits (Remaining Units - units)
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 Activity Sheet.

Note: You can have from 1 to 100 predefined cost DEs created in the Cost Sheet.

See Also