COSTPERUNITTIME

Description: Returns the cost per unit time of performing a preventive maintenance action (planned replacement) at a given time interval. Not available for stress-dependent models.

Syntax: COSTPERUNITTIME(Data_Src, Time, Planned, Unplanned)

Data_Src is the source data sheet for which the cost per unit time is calculated.
Time is the time interval at which the preventive maintenance action will be performed.
Planned is the cost of performing a planned replacement of the component.
Unplanned is the cost of performing an unplanned replacement of the component.

Remarks:

The Data_Src can be one of the following values:

If using a default data source, it must be either 1, 2, 3 or 4, as selected from the Data Source Index drop-down list.
It can take a data sheet name (e.g., "Folio1!Data 1").
It can take a variable name defined in via the Defined Names window (e.g., datasource).

The Time, Planned and Unplanned values must be greater than 0.

Example:

COSTPERUNITTIME("Folio1!Data 1", 5, 5, 3) = 0.999992796

Note that this value will vary depending on the source data set.