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