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

AVGEF

Description: Returns the average effectiveness factor for the selected mode type, based on the Crow Extended or Crow Extended - Continuous Evaluation models.

Syntax: AVGEF(Data_Src, Mode_Type)

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

Mode_Type allows you to select the mode classification. It is shown in the function as a numerical value that indicates the selected mode: BC Modes = 1; BD Modes = 2.

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:

AVGEF(“Folio1!Data 1”,1) = 0.6635290562

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