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

PARAMETER_M

Description: Returns a specified parameter value.

Syntax: PARAMETER_M(Data_Src, Param_Index, [System_Index], [Conf_Level])

Data_Src is the source data sheet from which the information is taken.

Param_Index is a numerical value that allows you to specify which parameter value to display. Depending on the data type and model you are working with, it returns the following information:

- For the Crow Extended and Crow Extended - Continuous Evaluation models, the index value specifies which parameter value to display for which mode. Use the following table to look up the index value for each combination. For example, to return the value of Beta for the BC modes, use index number 20.

* Not available for Multiple Systems - Concurrent Operating Times, Multiple Systems with Dates and fielded data types.
** Available for the Crow Extended - Continuous Evaluation model only.

- For all other models, the index value specifies which parameter value to display for the model used in the data source. The following table shows the index value for each combination. For example, index number 1 with the Crow-AMSAA model returns the value of Beta.

System_Index is an optional value that applies to multiple systems analysis. It allows you to return test results for individual systems, if enough data exists for the system. For example, to obtain the results for System 1, enter 1. If you do not enter a system ID, the function will return results for the representative system (i.e., the equivalent system, superposition system or cumulative timeline).

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

Example:

PARAMETER_M (“Folio1!Data 1”,1,1,0.9) = 1.000603782

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