	Related Topics:
	Spreadsheet Data Source Functions Data Entry Tips for Functions

OPTOVERHAUL

Description: Returns the optimum overhaul time for a repairable system, given a specified repair cost and overhaul cost. This function applies only to repairable systems with beta > 1.

Syntax: OPTOVERHAUL(Data_Src, Repair_Cost, Overhaul_Cost)

Data_Src is the source data sheet from which the value is calculated.

Repair_Cost is the cost associated with performing a repair.
Overhaul_Cost is the cost associated with performing an overhaul.

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 the Defined Names window (e.g., datasource).

The Repair Cost and Overhaul Cost values must be greater than zero.

Example:

OPTOVERHAUL(“Folio1!Data 1”,100,200) = 1632.326725

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