Related Topics: | ||
Description: Returns the time corresponding to the specified failure intensity.
Syntax: TIMEATFI(Data_Src, FI, Cumulative, [Conf_Level])
Data_Src is the source data sheet from which the value is calculated.
FI is the value of the failure intensity at which the time is calculated.
Cumulative allows you to specify either the cumulative or instantaneous failure intensity.
Conf_Level is the percentage (entered as a decimal value) for the confidence bounds. It is an optional value and, if specified, must be greater than 0 and less than 1.
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).
Cumulative is shown in the function as a numerical value that indicates the failure intensity calculation; for cumulative failure intensity = 1; for instantaneous failure intensity = 0.
Example:
TIMEATFI(“Folio1!Data 1”,0.0068,0) = 969.8275141
Note that this value will vary depending on the source data set.
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.