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

AVGACTEF

Description: Returns the average of the actual effectiveness factors (EF) for the BD modes, taking into account when the corrective action will be implemented. The calculation is based on the Crow Extended - Continuous Evaluation model.

Syntax: AVGACTEF(Data_Src)

Data_Src is the source data sheet from which the value is 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 the Defined Names window (e.g., datasource).

Example:

AVGACTEF(“Folio1!Data 1”) = 0.5547

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