@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}")