LRAA returns the Locational Running Annual Averages (LRAA) for a variable. LRAA calculates the average of four quarterly averages, starting with the quarter defined by QtyOffset/Date and the three (3) previous quarters.
SYNTAX:
LRAA(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:
LRAAZ, OELZ, OEL
EXAMPLES:
Report dates are set to 12/1/2024 thru 12/31/2024
LRAA(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.
LRAA(50001,"7/25/2023") - Calculates the Quarterly average for Q3 2023, Q2 2023. Q1 2023, and Q4 2022 and averages those 4 averages.