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

MISSIONTIME

Description: Returns the mission time at which the data set will reach a specified reliability value, given a specified time/age. This function applies to fielded data types only.

Syntax: MISSIONTIME (Data_Src, Reliability, Time, [Conf_Level])

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

Reliability is the reliability value (entered as a decimal) at which the value is calculated.

Time is the time at which the value is calculated.

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).

The Reliability value must be greater than 0 and less than 1.

The Time value must be greater than 0.

Example:

MISSIONTIME (“Folio1!Data 1”,0.9,100) = 1305.313694

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