EFAILURES

Description: Returns the expected number of failures for the specified period of time for one unit. If the data source contains failure times for non-repairable systems, the result is accurate when the start time is close to 0 and the end time is less than the MTTF value. If the data source contains the times to the first failure of a repairable system, the result is valid for any start and end time values.

Syntax: EFAILURES(Data_Src, Start Time, End Time)

Data_Src is the source data sheet for which the expected number of failures is calculated.
Start Time and End Time are the start age and additional operating time duration, respectively, of the period for which the number of failures are calculated.

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 Start Time and End Time values must be greater than 0.

Example:

EFAILURES("Folio1!Data 1", 5, 10) = 0.0005748748162

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