@EEXTU

Return the number of existing units in an equipment fleet (or individual units) by accessing the asset table. This function must be located in the BaseData cell of period-based spreadsheets only.

Syntax

@EEXTU(t1, t2)

Argument Description
t1 The name of an asset that may be located in the asset table. Typically this will be the name of an equipment resource spreadsheet that will match a resource ID in the asset table.
t2 Asset ID of a specific unit of equipment that may be located in the asset table. Typically blank (""), which indicates entire fleet not a specific unit.

Logic

The asset table will be searched for a resource ID that matches t1. On each match, the number of units will be accumulated. This value is placed in the first period of the model.

Examples

@EEXTU( "BIG_TRUCKS", "" )

@EEXTU("{EqpR}", "")

@EEXTU("{EqpR}", "{EqpID}")