@EINSU

Calculate the number of installed equipment units to meet current requirements and existing equipment. Installed units will be decreased as requirement decreases unless there is a future increase in requirements.

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

Syntax

@EINSU(r1, r2, [n3], [n4]

Argument	Description
r	The required equipment usage. Typically these values are calculated using the @EREQU function.
r2	The number of existing equipment units. Typically this value is calculated using the @EEXTU function.
n3	Optional. Tolerance for installing or selling the next unit. Decimal value, default is 0.05. For example, 1.04 becomes 1.00 or 105 becomes 2.
n4	Optional. Number of years to look ahead. The default is End of Project.

Logic

Initially, the maximum of required equipment usage and existing units is calculated. The result for each period is then checked against future values to ensure that installed equipment units are not reduced (sold off) if they will be required at a future time.

Example

@EINSU("ReqUnt", "ExtUnt")