@EREPU

Calculates the number of replacement equipment units to be purchased to meet current installed units given the existing units, new (additional) units purchased, usage on a period basis and replacement criteria. Usage is typically in operating hours, however, other units such as tonnes or tons can be used.

This function must be located in the BaseData cell of period-based spreadsheets only.

Syntax

@EREPU(t1, t2, r3, r4, r5, r6, r7, r8, r9 ,n10)

Argument	Description
t1	The name of an equipment resource which may be located in the asset table.
t2	The 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.
r3	Total operating hours for equipment units.
r4	Maximum operating hours per equipment unit.
r5	The required number of installed equipment units. Typically these values are calculated using the @EINSU function.
r6	The number of existing equipment units. Typically this value is calculated using the @EEXTU function.
r7	The number of new (additional) equipment units. Typically these values are calculated using the @ENEWU function.
r8	The age of equipment in years when replacement should occur.
r9	The age of equipment in operating hours when replacement should occur.
n10	The number of periods back from the last period in the model to indicate the last period for which replacement can occur.

Logic

Replacement will occur when an equipment item reaches its replacement age in years or if the maximum operating hours is reached first.

The existing units are processed first and the starting age in years and hours is taken into account when determining when replacement will occur.

New units are then processed. The number of operating hours assigned to each equipment unit is determined by the total number of fleet operating hours spread evenly over the installed number of units.

Replacement will not occur if there is no requirement for the equipment unit. Replacement will also not occur if the last period for replacement is reached.

The equipment capital calculation option will determine if the replacement unit is purchased in the period before commissioning or the period of commissioning.

Example

@EREPU("{EqpR}", "", "FltOpHr", "UntOpHr", "InsUnt", "ExtUnt", "NewUnt", R!{EqpR}!RPYear, R!{EqpR}!RPHours, 3)