OEL returns the Operational Evaluation Level (OEL) for a variable. OEL calculates the sum of current quarterly average multiplied by 2, previous quarterly average, and the 2nd previous quarterly average and divides by 4. The current quarter is defined by QtyOffset/Date.
SYNTAX:
OEL(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.
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).
SEE ALSO:
LRAA, LRAAZ, OEL, OELZ
EXAMPLES:
Report dates are set to 12/1/2024 thru 12/31/2024
OEL(50001,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.
OEL(50001,"7/25/2023") - Sums the Quarterly average for Q3 2023 *2, Q2 2023 and Q1 2023 and divides by 4.