SYNTAX:

OELZ(VarNum,QtrOffset/Date) 

VarNum:  The variable number to get the average for.

QtrOffset/Date: Sets the quarter to start the calculation.   If a number is the Offset in quarters from the start date of the report.  1 being the quarter the start date is in, 0 being the quarter prior to the start date.  See examples below. If this field is a date string (i.e. "07/16/2004") or refers to a cell with a date in it, it sets the quarter to start the calculation.

Decimal Places: Sets the number of decimal places to be displayed. For variables with decimal places set to "Not Fixed" click here for additional formatting options.

MDL Rule: Sets when to display the MDL symbol (<,>, ND) with the calculated statistic.  Valid settings are:

1 Display MDL symbol if one of the values contains the MDL symbol
2 Display MDL symbol if all of the values contains the MDL symbol.
3 Display MDL symbol if over half the values contains the MDL symbol.
4 Cascade all symbols

No Value Print: Sets a string to be displayed if there are no values in the date range.

NOTES:

The Locational Running Annual Averages (LRAA) and Operational Evaluation Level (OEL) are required as part of the Stage 2 Disinfection Byproducts rule (DBPR) for Total Trihalomethanes (TTHMs) and Haloacetic Acids (HAA5s).

Function will calculate if one (1) value is found in any quarter.

SEE ALSO:

LRAA,  LRAAZ, OEL

EXAMPLES:

Report dates are set to 12/1/2024 thru 12/31/2024

OELZ(50001,1,3,1) - Calculates the average for Q4 2024 (Oct 1 thru Dec 31 2024, QtrOffset of 1), Q3 2024 (July 1 thru Sep 30 2024, QtrOffset of 0), Q2 2024 (April 1 thru June 30 2024, QtrOffset of -1) and Q1 2024 (Jan 1 thru March 31 2024, QtrOffset of -2) and averages those 4 averages. 

OELZ(50001,"7/25/2023",3,1,"No Values Found") -  Sums the Quarterly average for Q3 2023 *2, Q2 2023 and Q1 2023 and divides by 4.