@ECAPX

Assign the capital expense of equipment as they are purchased. Optionally, the capital can be spread back up to three additional years.

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

Syntax

@ECAPX(r1,r2, [n3], [n4], [n5], [n6])

Argument	Description
r1	The number of new (additional) or replacement equipment units. Typically these values are calculated using the @ENEWU function or @EREPU function.
r2	The capital cost of a new (or replacement) equipment unit. This is typically located in an equipment resource sheet
n3	Optional. The proportion of unit capital cost which is expensed in the base year, that is, the year before the equipment is to be used. The equipment is assumed to be commissioned at the end of the period preceding the period in which it is first used. If omitted it is assumed to be one (1.0 = 100%)
n4	Optional. The proportion of the unit capital which is expensed one year before the equipment is commissioned
n5	Optional. The proportion of the unit capital which is expensed two years before the equipment is commissioned
n6	Optional. The proportion of the unit capital which is expensed three years before the equipment is commissioned

Logic

If the number of units for new (or replacement) equipment is greater than zero, it is multiplied by the unit capital cost to get the total capital expense for the period.

The capital expense can be spread back for up to three previous years if any of the options are used (for example, 50%, 30%, 20%). This will allow construction costs of large items of equipment to be assigned over a significant period of time.

The spread back will be proportioned by period length for periods of less than one year, except where all expenses are placed in the base year. In this case, the total expense will be placed in the period before usage, regardless of the length of the period.

Example

@ECAPX("NewUnt", R!{EqpR}!UntCapx, R!{EqpR}!ByCapx, R!{EqpR}!Y1Capx, R!{EqpR}!Y2Capx, R!{EqpR}!Y3Capx)