Built-in Aggregation, Quoted Cost and other Formulas/Attributes

The following formulas/attributes are available for components, assemblies and rollups.

For the aggregation attributes, consider the following example: Assembly1 consists of 3 parts: 2 instances of Part A and one instance of Part B. Within Assembly1, "countInParent" of Part A is 2 and of Part B is 1.

Now suppose that there is another assembly, Assembly2, that contains 2 instances of Assembly1. For Assembly1, in the context of Assembly 2, "countInParent" is still 2. The values of "countInParent" for parts A and B are the same as well.

The following attributes are available at any level. You should use some subset of these if you set "generateStandardColumns" to false:

• gcdType

• gcdName

• processName

• nodeName

• processGroupName

• partNumber

• scenarioType

• scenarioName

• vpeName

Costs and weights work the same way as counts. So "aggregateCostInParent" for a given part is (fullyBurdenedCost + costOfChildScenarios)* countInParent.

Note that"aggregateCost..." (and by extension "aggregateFinishMass") includes the (aggregate) cost of child scenarios for rollups and assemblies. Logically, the cost of child scenarios for mere parts is 0.

Below is a list of the aggregated attributes:

• parentScenario

• parentScenarioType

• countInParent

• aggregateCost (aggregateFullyBurdenedCost)

• aggregateCostInParent

• costOfChildScenarios

• aggregateFinishMass

• aggregateFinishMassInParent

• finishMassOfChildScenarios

• aggregateFullyBurdenedCost

• aggregatePiecePartCost

• aggregateToolingCostPerPart (ammortized tooling)

• aggregateFixtureCostPerPart

• aggregateProgrammingCostPerPart

• aggregateAdditionalDirectCosts

• aggregateExtraCosts

• aggregateMaterialCost

• aggregateOverheadCost

• aggregateLogisticsCost

• aggregateLaborCost

• aggregateLaborTime

Non ammortized aggregates:

• aggregateCapitalInvestment

• aggregateHardToolingcost

• aggregateFixtureCost

• aggregateProgrammingCost