@EMMARC
Maintenance and repair contracts - Weighted average curve values for equipment units using step function logic.
This function is used to step determine weighted average values from a set of points in a curve where the independent variable is equipment age, defined in the curve table for an entire fleet of equipment. The result is the weighted average of the individual curve values assuming the fleet will vary in age. The weight average is based on the number of hours within any step cost bracket when more than one cost bracket may apply within a period to an individual equipment unit.
This function must be located in the BaseData cell of period-based spreadsheets only.
Syntax
@EMMARC(n1, t2, t3, t4, n5, t6, t7, r8, r9, r10, r11, r12, r13, r14, r15, n16)
| Argument | Description |
|---|---|
| n1 |
Flag to indicate whether the curve data is in columns or rows. 0: In columns. 1: In rows. |
| t2 | Spreadsheet name and path of the sheet containing the MARC data ("" is current sheet). |
| t3 | Top left of data table (Row.Column). |
| t4 | Bottom right of data table (Row.Column). |
| n5 |
Flag to indicate which average, age or years to calculate for equipment. 0: Age in years. 1: Age in hours. |
| t6 | The name of an equipment resource which may be located in the asset table. |
| t7 |
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. |
| r8 | Total operating hours for equipment units. |
| r9 | Maximum operating hours per equipment unit. |
| r10 | The required number of installed equipment units. Typically these values are calculated using the @EINSU function. |
| r11 | The number of existing equipment units. Typically this value is calculated using the @EEXTU function. |
| r12 | The number of new (additional) equipment units. Typically these values are calculated using the @ENEWU function. |
| r13 | The number of replacement equipment units. Typically these values are calculated using the @EREPU function. |
| r14 |
Optional. The number of traded-in equipment units. Default is that units are not traded-in. Typically these values are calculated using the @ETRDU function. |
| r15 |
Optional. The number of sold equipment units. Default is that units are not sold before the end of the project. Typically these values are calculated using the @ESLDU function. |
| n16 | Age that a piece of equipment is removed from the MARC. |
Logic
This function provides for a transition of an equipment fleet from MARC contracts to owner-maintained equipment based on the age of an equipment unit.
The premise is that when equipment is new or young, it will be maintained by the supplier on a MARC (Maintenance and repair contract). This is usually an hourly rate stepped by the equipment age. In some cases, the contract will terminate before the equipment is replaced, then the owners will be responsible for the equipment.
The termination life is in the same units as the aging units (typically operating hours but could be tonnes, tons, bcm, bcy or years).
As each unit hits this age, it is removed from the weighting units (not the installed units). In this way the weighting of units is changed.
The curve data required is gathered from a range of cells in a free format spreadsheet. The full spreadsheet path is required for argument t2, for example, R!MarcData
Examples
@EMMARC(0,"R!{EqpR}", "r1.OpHrs", "r10.{rowcode}",1, "{EqpR}","", "FltOpHr", "WrkHrs", "InsUnt", "ExtUnt", "NewUnt", "RepUnt", "TrdUnt", "SldUnt", R!{EqpR}!RLOpHrs.PCons)
@EMMARC(0,"R!RH200", "r1.OpHrs", "r10.LFCons",1, "RH200","", "FltOpHr", "WrkHrs", "InsUnt", "ExtUnt", "NewUnt", "RepUnt", "TrdUnt", "SldUnt", R!RH200!RLOpHrs.PCons)