@ESLDU

Calculate the number of equipment units sold due to a decrease in requirement. The decrease is over the life of the project, not just a temporary reduction.

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

Syntax

@ESLDU(r1, r2, [n3])

Argument Description
r1 The number of installed equipment units. Typically these values are calculated using the @EINSU function.
r2 The number of existing equipment units by period.
n3

Optional.

A flag that represents options for handling installed equipment in the last period of the model, for example, at the end of the project.

0: The default. Sell.

1: Write off.

2: Ongoing.

Logic

A sale is assumed to occur when the number of installed units is reduced. In the last period several options can occur.

If:

  • Sell: all remaining equipment units are sold.
  • Write off: no sale values are assigned.
  • Ongoing: no sale values are assigned.

The sold unit values are placed in the last period of usage.

Example

@ESLDU("InsUnt", "ExtUnt", R!{EqpR}!EPOpt)