{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Development","Data Entry","Chlorine Summary Table","Chlorine Chart","Cl2 Delta Table","pH Summary Table","pH Chart","Temp Summary Table","Temp Chart","TTHM Summary Table","TTHM Chart","TTHM Goals","HAA5 Summary Table","HAA5 Chart","HAA5 Goals","OEL Calc","Site Info"],"not_rendered":{"charts":7,"images":0,"macros":1,"external_links":1,"defined_names":50,"comments":4,"pivot_tables":6},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Development","index":0,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Column1","Column2","Version"]
["Developer Comments"]
[]
["2011-04-14","Modified GW spreadsheet to use for DS PBT. Added DBP pivot tables and charts. Added DBP goals"]
[null,"tables for TTHM and HAA5."]
["2011-04-29","Pivot tables set to automatically Refresh each time file is opened. Identifed method to display"]
[null,"system wide chlorine concentration by month by dragging Sample Site Field out of box."]
[null,"Added DBP long-term charts to goals worksheets."]
["2011-09-01","William McClimans added macro to auto update all pivot tables."]
["2012-01-04","Added macro to auto update DBP Goals table based on DBP pivot table quarterly summary table."]
[null,"DBP LRAA calculations limited to 5 years of data (20 quarters)."]
["2012-01-17","Changed DBP number format from ppb to Mg/L."]
[null,"Modified DBP update macro to allow unlimited number of quarters."]
[null,"Added worksheet protection."]
[null,"Added table formatting."]
["2012-01-18","Increased number of DBP LRAA sites to 18 in goals tables and OEL table per Williams suggestion.","Beta 6"]
[null,"Also cosolidated macros to one Update macro and included utility name on sheets."]
[null,"Set up page print ranges."]
["2012-01-27","Modified macro to not overwrite DBP goals table when # of sites exceeds table limit.","Beta 7"]
[null,"Added date formatting to chlorine and DBP pivot tables (year/month & year/quarter)."]
["2012-09-17","Made change to not retain old sample sites in the data source.","Beta 9"]

{"sheet":"Data Entry","index":1,"n_rows":110,"n_cols":45,"rows_kept":110,"cut":false,"hidden":false,"merged":[[0,10,1,13],[2,0,3,2],[2,5,2,6]]}
["Enter new sample data by inserting rows in table or entering data in the row immediately below the table.",null,null,null,null,null,null,null,null,null,"Water System Name"]
["Note: Avoid blank rows in the data entry table. Pivot tables and charts do not like blank rows!"]
["Operational Goals (Individual Samples)",null,null,null,null,"(min)  pH  (Max)"]
[null,null,null,0.2,null,6.8,7.8,7.0000000000000007E-2,0.05]
["Sample Site","Date","Time","Free Cl2, Mg/L","Total Cl2, Mg/L","Temp","pH","TTHM, Mg/L","HAA5, Mg/L","Other 3","Other 4","Other 5","Latitude","Longitude","Comments","CL2 Rounded"]
["11405 LARRY LAKE ROAD","2014-04-07",null,null,null,null,null,9.3699999999999999E-3,1.18E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["13191 DEASON CAMP ROAD","2014-04-07",null,null,null,null,null,4.3799999999999999E-2,2.7300000000000001E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chlorine","Result"]
["13920 GRAND POINTE ROAD","2014-04-07",null,null,null,null,null,2.8400000000000002E-2,2.4899999999999999E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["3950 3RD STREET SOUTH","2014-04-07",null,null,null,null,null,4.5100000000000001E-2,2.9899999999999999E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.01,0]
["6802 MCFARLAND BLVD","2014-04-07",null,null,null,null,null,4.4600000000000001E-2,0.03,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.04,0]
["11405 LARRY LAKE ROAD","2014-07-08",null,null,null,null,null,1.78E-2,1.2699999999999999E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.05,0.1]
["13191 DEASON CAMP ROAD","2014-07-08",null,null,null,null,null,8.4500000000000006E-2,6.2799999999999995E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000001E-2,0.1]
["13920 GRAND POINTE ROAD","2014-07-08",null,null,null,null,null,5.4600000000000003E-2,4.7E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,0.1]
["3950 3RD STREET SOUTH","2014-07-08",null,null,null,null,null,8.5800000000000001E-2,6.0900000000000003E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.11,0.2]
["6802 MCFARLAND BLVD","2014-07-08",null,null,null,null,null,5.7599999999999998E-2,5.1700000000000003E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.12,0.2]
["11405 LARRY LAKE ROAD","2014-10-08",null,null,null,null,null,1.35E-2,1.12E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.2]
["13191 DEASON CAMP ROAD","2014-10-08",null,null,null,null,null,4.24E-2,3.6400000000000002E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.21,0.5]
["13920 GRAND POINTE ROAD","2014-10-08",null,null,null,null,null,3.6799999999999999E-2,2.41E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,0.5]
["3950 3RD STREET SOUTH","2014-10-08",null,null,null,null,null,6.1400000000000003E-2,3.9800000000000002E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.51,1]
["6802 MCFARLAND BLVD","2014-10-08",null,null,null,null,null,5.21E-2,3.8600000000000002E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
["11405 LARRY LAKE ROAD","2015-01-06",null,null,null,null,null,8.8199999999999997E-3,1.66E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.01,1.5]
["13191 DEASON CAMP ROAD","2015-01-06",null,null,null,null,null,3.5799999999999998E-2,3.56E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,1.5]
["13920 GRAND POINTE ROAD","2015-01-06",null,null,null,null,null,2.58E-2,3.1600000000000003E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.51,2]
["3950 3RD STREET SOUTH","2015-01-06",null,null,null,null,null,3.6799999999999999E-2,3.4500000000000003E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2]
["6802 MCFARLAND BLVD","2015-01-06",null,null,null,null,null,3.5200000000000002E-2,3.2899999999999999E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.0099999999999998,2.5]
["11405 LARRY LAKE ROAD","2015-04-07",null,null,null,null,null,1.0500000000000001E-2,0.01,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5,2.5]
["13191 DEASON CAMP ROAD","2015-04-07",null,null,null,null,null,3.6900000000000002E-2,2.9600000000000001E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5099999999999998,3]
["13920 GRAND POINTE ROAD","2015-04-07",null,null,null,null,null,2.5999999999999999E-2,1.9E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,3]
["3950 3RD STREET SOUTH","2015-04-07",null,null,null,null,null,3.5400000000000001E-2,2.7199999999999998E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.01,3.5]
["6802 MCFARLAND BLVD","2015-04-07",null,null,null,null,null,3.6999999999999998E-2,2.98E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5,3.5]
["11405 LARRY LAKE ROAD","2015-07-06",null,null,null,null,null,1.67E-2,1.6799999999999999E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.51,4]
["13191 DEASON CAMP ROAD","2015-07-06",null,null,null,null,null,7.6899999999999996E-2,4.9500000000000002E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,4]
["13920 GRAND POINTE ROAD","2015-07-06",null,null,null,null,null,4.19E-2,3.4200000000000001E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,4]
["3950 3RD STREET SOUTH","2015-07-06",null,null,null,null,null,7.0699999999999999E-2,4.9599999999999998E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,4]
["6802 MCFARLAND BLVD","2015-07-06",null,null,null,null,null,7.6200000000000004E-2,4.82E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["11405 LARRY LAKE ROAD","2015-10-06",null,null,null,null,null,1.4200000000000001E-2,1.2800000000000001E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["13191 DEASON CAMP ROAD","2015-10-06",null,null,null,null,null,5.1900000000000002E-2,3.3599999999999998E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["13920 GRAND POINTE ROAD","2015-10-06",null,null,null,null,null,4.8000000000000001E-2,2.9100000000000001E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["3950 3RD STREET SOUTH","2015-10-06",null,null,null,null,null,5.8999999999999997E-2,3.85E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["6802 MCFARLAND BLVD","2015-10-06",null,null,null,null,null,4.4900000000000002E-2,3.4099999999999998E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["11405 LARRY LAKE ROAD","2016-01-12",null,null,null,null,null,1.2500000000000001E-2,2.0199999999999999E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["13191 DEASON CAMP ROAD","2016-01-12",null,null,null,null,null,4.36E-2,5.04E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["13920 GRAND POINTE ROAD","2016-01-12",null,null,null,null,null,3.1099999999999999E-2,4.9500000000000002E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["3950 3RD STREET SOUTH","2016-01-12",null,null,null,null,null,4.3700000000000003E-2,4.99E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["6802 MCFARLAND BLVD","2016-01-12",null,null,null,null,null,4.3900000000000002E-2,4.99E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["11405 LARRY LAKE ROAD","2016-04-11",null,null,null,null,null,1.0999999999999999E-2,1.4E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["13191 DEASON CAMP ROAD","2016-04-11",null,null,null,null,null,3.2000000000000001E-2,3.2000000000000001E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["13920 GRAND POINTE ROAD","2016-04-11",null,null,null,null,null,2.7E-2,2.9000000000000001E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["3950 3RD STREET SOUTH","2016-04-11",null,null,null,null,null,3.5999999999999997E-2,3.5999999999999997E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["6802 MCFARLAND BLVD","2016-04-11",null,null,null,null,null,3.7999999999999999E-2,3.4000000000000002E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["11405 LARRY LAKE ROAD","2016-07-12",null,null,null,null,null,1.41E-2,1.72E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["13191 DEASON CAMP ROAD","2016-07-12",null,null,null,null,null,6.4799999999999996E-2,4.6100000000000002E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["13920 GRAND POINTE ROAD","2016-07-12",null,null,null,null,null,6.3100000000000003E-2,4.7800000000000002E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["3950 3RD STREET SOUTH","2016-07-12",null,null,null,null,null,7.1099999999999997E-2,4.6399999999999997E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["6802 MCFARLAND BLVD","2016-07-12",null,null,null,null,null,6.0600000000000001E-2,4.2900000000000001E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["11405 LARRY LAKE ROAD","2016-10-10",null,null,null,null,null,8.6099999999999996E-3,9.6900000000000007E-3,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["13191 DEASON CAMP ROAD","2016-10-10",null,null,null,null,null,4.2500000000000003E-2,3.7600000000000001E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["13920 GRAND POINTE ROAD","2016-10-10",null,null,null,null,null,2.9499999999999998E-2,2.7400000000000001E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["3950 3RD STREET SOUTH","2016-10-10",null,null,null,null,null,8.6099999999999996E-3,9.6900000000000007E-3,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["6802 MCFARLAND BLVD","2016-10-10",null,null,null,null,null,4.3999999999999997E-2,3.6600000000000001E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["11405 LARRY LAKE ROAD","2017-01-10",null,null,null,null,null,6.2199999999999998E-3,7.4200000000000004E-3,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["13191 DEASON CAMP ROAD","2017-01-10",null,null,null,null,null,2.3E-2,2.0199999999999999E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["13920 GRAND POINTE ROAD","2017-01-10",null,null,null,null,null,1.8499999999999999E-2,1.7999999999999999E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["3950 3RD STREET SOUTH","2017-01-10",null,null,null,null,null,2.46E-2,1.84E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["6802 MCFARLAND BLVD","2017-01-10",null,null,null,null,null,2.2200000000000001E-2,2.1899999999999999E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["11405 LARRY LAKE ROAD","2017-04-11",null,null,null,null,null,1.77E-2,1.9300000000000001E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["13191 DEASON CAMP ROAD","2017-04-11",null,null,null,null,null,4.6699999999999998E-2,3.78E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["13920 GRAND POINTE ROAD","2017-04-11",null,null,null,null,null,3.8699999999999998E-2,3.5000000000000003E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["3950 3RD STREET SOUTH","2017-04-11",null,null,null,null,null,4.9599999999999998E-2,4.3499999999999997E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["6802 MCFARLAND BLVD","2017-04-11",null,null,null,null,null,3.8600000000000002E-2,4.1200000000000001E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["11405 LARRY LAKE ROAD","2017-07-11",null,null,null,null,null,2.6599999999999999E-2,3.2800000000000003E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["13191 DEASON CAMP ROAD","2017-07-11",null,null,null,null,null,7.9299999999999995E-2,6.13E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["13920 GRAND POINTE ROAD","2017-07-11",null,null,null,null,null,5.1400000000000001E-2,4.7699999999999999E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["3950 3RD STREET SOUTH","2017-07-11",null,null,null,null,null,8.2799999999999999E-2,6.1699999999999998E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["6802 MCFARLAND BLVD","2017-07-11",null,null,null,null,null,7.6200000000000004E-2,6.08E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["11405 LARRY LAKE ROAD","2017-10-09",null,null,null,null,null,1.6E-2,1.38E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["13191 DEASON CAMP ROAD","2017-10-09",null,null,null,null,null,7.0599999999999996E-2,4.4299999999999999E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["13920 GRAND POINTE ROAD","2017-10-09",null,null,null,null,null,5.0500000000000003E-2,3.8399999999999997E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["3950 3RD STREET SOUTH","2017-10-09",null,null,null,null,null,6.4199999999999993E-2,4.4400000000000002E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["6802 MCFARLAND BLVD","2017-10-09",null,null,null,null,null,5.3999999999999999E-2,4.7899999999999998E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["11405 LARRY LAKE ROAD","2018-01-09",null,null,null,null,null,8.6899999999999998E-3,9.0699999999999999E-3,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["13191 DEASON CAMP ROAD","2018-01-09",null,null,null,null,null,2.6599999999999999E-2,2.01E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["13920 GRAND POINTE ROAD","2018-01-09",null,null,null,null,null,1.7399999999999999E-2,1.52E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["3950 3RD STREET SOUTH","2018-01-09",null,null,null,null,null,2.86E-2,1.9099999999999999E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["6802 MCFARLAND BLVD","2018-01-09",null,null,null,null,null,2.4500000000000001E-2,1.8200000000000001E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["#1 BOOTH ESTATES","2018-04-09",null,null,null,null,null,4.2599999999999999E-2,3.4500000000000003E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["11405 LARRY LAKE ROAD","2018-04-09",null,null,null,null,null,1.4E-2,1.6199999999999999E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["17689 PINE LAKE RD","2018-04-09",null,null,null,null,null,5.3199999999999997E-2,5.8400000000000001E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["2920 39TH ST","2018-04-09",null,null,null,null,null,6.0299999999999999E-2,5.7299999999999997E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["6425 5TH ST","2018-04-09",null,null,null,null,null,4.9299999999999997E-2,4.0899999999999999E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["#1 BOOTH ESTATES","2018-07-10",null,null,null,null,null,8.3099999999999993E-2,6.5600000000000006E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["11405 LARRY LAKE ROAD","2018-07-10",null,null,null,null,null,1.18E-2,1.47E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["17689 PINE LAKE RD","2018-07-10",null,null,null,null,null,7.9200000000000007E-2,6.1499999999999999E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["2920 39TH ST","2018-07-10",null,null,null,null,null,2.9899999999999999E-2,7.2800000000000004E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["6425 5TH ST","2018-07-10",null,null,null,null,null,9.74E-2,6.4899999999999999E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["#1 BOOTH ESTATES","2018-10-08",null,null,null,null,null,6.0999999999999999E-2,4.5900000000000003E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["11405 LARRY LAKE ROAD","2018-10-08",null,null,null,null,null,2.5399999999999999E-2,2.2499999999999999E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["17689 PINE LAKE RD","2018-10-08",null,null,null,null,null,6.2799999999999995E-2,4.6100000000000002E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["2920 39TH ST","2018-10-08",null,null,null,null,null,0.1062,6.8900000000000003E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["6425 5TH ST","2018-10-08",null,null,null,null,null,6.9900000000000004E-2,4.8099999999999997E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["#1 BOOTH ESTATES","2019-01-17",null,null,null,null,null,3.9300000000000002E-2,4.7300000000000002E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["11405 LARRY LAKE ROAD","2019-01-17",null,null,null,null,null,1.47E-2,2.2200000000000001E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["17689 PINE LAKE RD","2019-01-17",null,null,null,null,null,3.5200000000000002E-2,5.11E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["2920 39TH ST","2019-01-17",null,null,null,null,null,3.1600000000000003E-2,3.7999999999999999E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["6425 5TH ST","2019-01-17",null,null,null,null,null,3.5099999999999999E-2,4.6899999999999997E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["#1 BOOTH ESTATES","2019-04-08",null,null,null,null,null,2.98E-2,3.5000000000000003E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["11405 LARRY LAKE ROAD","2019-04-08",null,null,null,null,null,1.7299999999999999E-2,2.1999999999999999E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["17689 PINE LAKE RD","2019-04-08",null,null,null,null,null,3.1600000000000003E-2,3.5999999999999997E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["2920 39TH ST","2019-04-08",null,null,null,null,null,2.9600000000000001E-2,3.2300000000000002E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]
["6425 5TH ST","2019-04-08",null,null,null,null,null,3.1800000000000002E-2,3.4000000000000002E-2,null,null,null,null,null,null,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]

{"sheet":"Chlorine Summary Table","index":2,"n_rows":16,"n_cols":23,"rows_kept":16,"cut":false,"hidden":true,"merged":[[1,0,2,11]]}
[{"$f":"'Data Entry'!K1:K2","v":"Water System Name"}]
["Note:  If table is not updated go to the \"Data Entry\" tab and click the \"Update Tables\" button.  If table does not update, make sure that macros are enabled. Go to Trust Center & Macro Settings to enable macros."]
[]
["Average of Free Cl2, Mg/L","Years","Date"]
[null,"2014",null,null,"2015",null,null,null,"2016",null,null,null,"2017",null,null,null,"2018",null,null,null,"2019",null,"Average"]
["Sample Site","Apr","Jul","Oct","Jan","Apr","Jul","Oct","Jan","Apr","Jul","Oct","Jan","Apr","Jul","Oct","Jan","Apr","Jul","Oct","Jan","Apr"]
["#1 BOOTH ESTATES"]
["11405 LARRY LAKE ROAD"]
["13191 DEASON CAMP ROAD"]
["13920 GRAND POINTE ROAD"]
["17689 PINE LAKE RD"]
["2920 39TH ST"]
["3950 3RD STREET SOUTH"]
["6425 5TH ST"]
["6802 MCFARLAND BLVD"]
["Average"]

{"sheet":"Chlorine Chart","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Cl2 Delta Table","index":4,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Sample Site","11405 LARRY LAKE ROAD",null,null,null,"Note: Update this table each time new data is entered in the Data Entry Table."]
[null,null,null,null,null,"To update, 'right clicking' on any cell in the table and select Refresh."]
["Delta Cl2",null,null,null,null,"Legend"]
["Date","Total",null,null,null,"Green Light: Delta less than or equal to 0.19"]
["2019-04-08",{"$error":"#NAME?"},null,null,null,"Yellow Light: Delta less than 0.25 and greater than 0.19"]
["2019-01-17",{"$error":"#NAME?"},null,null,null,"Red Light: Delta greater than or equal to 0.25 "]
["2018-10-08",{"$error":"#NAME?"}]
["2018-07-10",{"$error":"#NAME?"}]
["2018-04-09",{"$error":"#NAME?"}]
["2018-01-09",{"$error":"#NAME?"}]
["2017-10-09",{"$error":"#NAME?"}]
["2017-07-11",{"$error":"#NAME?"}]
["2017-04-11",{"$error":"#NAME?"}]
["2017-01-10",{"$error":"#NAME?"}]
["2016-10-10",{"$error":"#NAME?"}]
["2016-07-12",{"$error":"#NAME?"}]
["2016-04-11",{"$error":"#NAME?"}]
["2016-01-12",{"$error":"#NAME?"}]
["2015-10-06",{"$error":"#NAME?"}]
["2015-07-06",{"$error":"#NAME?"}]
["2015-04-07",{"$error":"#NAME?"}]
["2015-01-06",{"$error":"#NAME?"}]
["2014-10-08",{"$error":"#NAME?"}]
["2014-07-08",{"$error":"#NAME?"}]
["2014-04-07",{"$error":"#NAME?"}]

{"sheet":"pH Summary Table","index":5,"n_rows":16,"n_cols":23,"rows_kept":16,"cut":false,"hidden":true,"merged":[[1,0,2,11]]}
[{"$f":"'Data Entry'!K1:K2","v":"Water System Name"}]
["Note:  If table is not updated go to the \"Data Entry\" tab and click the \"Update Tables\" button.  If table does not update, make sure that macros are enabled. Go to Trust Center & Macro Settings to enable macros."]
[]
["Average of pH","Years","Date"]
[null,"2014",null,null,"2015",null,null,null,"2016",null,null,null,"2017",null,null,null,"2018",null,null,null,"2019",null,"Average"]
["Sample Site","Apr","Jul","Oct","Jan","Apr","Jul","Oct","Jan","Apr","Jul","Oct","Jan","Apr","Jul","Oct","Jan","Apr","Jul","Oct","Jan","Apr"]
["#1 BOOTH ESTATES"]
["11405 LARRY LAKE ROAD"]
["13191 DEASON CAMP ROAD"]
["13920 GRAND POINTE ROAD"]
["17689 PINE LAKE RD"]
["2920 39TH ST"]
["3950 3RD STREET SOUTH"]
["6425 5TH ST"]
["6802 MCFARLAND BLVD"]
["Average"]

{"sheet":"pH Chart","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Temp Summary Table","index":7,"n_rows":16,"n_cols":23,"rows_kept":16,"cut":false,"hidden":true,"merged":[[1,0,2,11]]}
[{"$f":"'Data Entry'!K1:K2","v":"Water System Name"}]
["Note:  If table is not updated go to the \"Data Entry\" tab and click the \"Update Tables\" button.  If table does not update, make sure that macros are enabled. Go to Trust Center & Macro Settings to enable macros."]
[]
["Average of Temp","Years","Date"]
[null,"2014",null,null,"2015",null,null,null,"2016",null,null,null,"2017",null,null,null,"2018",null,null,null,"2019",null,"Average"]
["Sample Site","Apr","Jul","Oct","Jan","Apr","Jul","Oct","Jan","Apr","Jul","Oct","Jan","Apr","Jul","Oct","Jan","Apr","Jul","Oct","Jan","Apr"]
["#1 BOOTH ESTATES"]
["11405 LARRY LAKE ROAD"]
["13191 DEASON CAMP ROAD"]
["13920 GRAND POINTE ROAD"]
["17689 PINE LAKE RD"]
["2920 39TH ST"]
["3950 3RD STREET SOUTH"]
["6425 5TH ST"]
["6802 MCFARLAND BLVD"]
["Average"]

{"sheet":"Temp Chart","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"TTHM Summary Table","index":9,"n_rows":56,"n_cols":34,"rows_kept":56,"cut":false,"hidden":true,"merged":[[0,1,1,12]]}
[null,"Note:  If table is not updated go to the \"Data Entry\" tab and click the \"Update Tables\" button.  If table does not update, make sure that macros are enabled. Go to Trust Center & Macro Settings to enable macros.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Entry'!K1:K2","v":"Water System Name"}]
[]
[null,"Average of TTHM, Mg/L","Years","Date"]
[null,null,"2014",null,null,"2015",null,null,null,"2016",null,null,null,"2017",null,null,null,"2018",null,null,null,"2019",null,"Average"]
[null,"Sample Site","Qtr2","Qtr3","Qtr4","Qtr1","Qtr2","Qtr3","Qtr4","Qtr1","Qtr2","Qtr3","Qtr4","Qtr1","Qtr2","Qtr3","Qtr4","Qtr1","Qtr2","Qtr3","Qtr4","Qtr1","Qtr2"]
[null,"11405 LARRY LAKE ROAD",9.3699999999999999E-3,1.78E-2,1.35E-2,8.8199999999999997E-3,1.0500000000000001E-2,1.67E-2,1.4200000000000001E-2,1.2500000000000001E-2,1.0999999999999999E-2,1.41E-2,8.6099999999999996E-3,6.2199999999999998E-3,1.77E-2,2.6599999999999999E-2,1.6E-2,8.6899999999999998E-3,1.4E-2,1.18E-2,2.5399999999999999E-2,1.47E-2,1.7299999999999999E-2,1.4071904761904761E-2]
[null,"13191 DEASON CAMP ROAD",4.3799999999999999E-2,8.4500000000000006E-2,4.24E-2,3.5799999999999998E-2,3.6900000000000002E-2,7.6899999999999996E-2,5.1900000000000002E-2,4.36E-2,3.2000000000000001E-2,6.4799999999999996E-2,4.2500000000000003E-2,2.3E-2,4.6699999999999998E-2,7.9299999999999995E-2,7.0599999999999996E-2,2.6599999999999999E-2,"na","na","na","na","na",5.0081250000000001E-2]
[null,"13920 GRAND POINTE ROAD",2.8400000000000002E-2,5.4600000000000003E-2,3.6799999999999999E-2,2.58E-2,2.5999999999999999E-2,4.19E-2,4.8000000000000001E-2,3.1099999999999999E-2,2.7E-2,6.3100000000000003E-2,2.9499999999999998E-2,1.8499999999999999E-2,3.8699999999999998E-2,5.1400000000000001E-2,5.0500000000000003E-2,1.7399999999999999E-2,"na","na","na","na","na",3.679375E-2]
[null,"3950 3RD STREET SOUTH",4.5100000000000001E-2,8.5800000000000001E-2,6.1400000000000003E-2,3.6799999999999999E-2,3.5400000000000001E-2,7.0699999999999999E-2,5.8999999999999997E-2,4.3700000000000003E-2,3.5999999999999997E-2,7.1099999999999997E-2,8.6099999999999996E-3,2.46E-2,4.9599999999999998E-2,8.2799999999999999E-2,6.4199999999999993E-2,2.86E-2,"na","na","na","na","na",5.021312499999999E-2]
[null,"6802 MCFARLAND BLVD",4.4600000000000001E-2,5.7599999999999998E-2,5.21E-2,3.5200000000000002E-2,3.6999999999999998E-2,7.6200000000000004E-2,4.4900000000000002E-2,4.3900000000000002E-2,3.7999999999999999E-2,6.0600000000000001E-2,4.3999999999999997E-2,2.2200000000000001E-2,3.8600000000000002E-2,7.6200000000000004E-2,5.3999999999999999E-2,2.4500000000000001E-2,"na","na","na","na","na",4.6850000000000003E-2]
[null,"#1 BOOTH ESTATES","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na",4.2599999999999999E-2,8.3099999999999993E-2,6.0999999999999999E-2,3.9300000000000002E-2,2.98E-2,5.1159999999999997E-2]
[null,"17689 PINE LAKE RD","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na",5.3199999999999997E-2,7.9200000000000007E-2,6.2799999999999995E-2,3.5200000000000002E-2,3.1600000000000003E-2,5.2400000000000002E-2]
[null,"2920 39TH ST","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na",6.0299999999999999E-2,2.9899999999999999E-2,0.1062,3.1600000000000003E-2,2.9600000000000001E-2,5.152000000000001E-2]
[null,"6425 5TH ST","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na",4.9299999999999997E-2,9.74E-2,6.9900000000000004E-2,3.5099999999999999E-2,3.1800000000000002E-2,5.6700000000000007E-2]
[null,"Average",3.4254E-2,6.0060000000000002E-2,4.1240000000000006E-2,2.8483999999999999E-2,2.9160000000000002E-2,5.6479999999999995E-2,4.36E-2,3.4960000000000005E-2,2.8799999999999999E-2,5.4739999999999997E-2,2.6644000000000001E-2,1.8903999999999997E-2,3.8260000000000002E-2,6.3259999999999997E-2,5.1059999999999994E-2,2.1158E-2,4.3879999999999995E-2,6.028E-2,6.5060000000000007E-2,3.1180000000000003E-2,2.802E-2,4.0927809523809519E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"RIGHT(LEFT(B42,4),1)&B39","v":"Column1"}]
[null,{"$f":"IF(B41>1,B41,A39)","v":"Column1"}]
[]
[null,"Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10","Column11","Column12","Column13","Column14","Column15","Column16","Column17","Column18","Column19","Column20","Column21","Column22","Column23","Column24","Column25","Column26","Column27","Column28","Column29","Column30","Column31","Column32","Column33"]
[null,null,{"$f":"RIGHT(LEFT(C46,4),1)&C43","v":"22014"},"32014","42014","12015","22015","32015","42015","12016","22016","32016","42016","12017","22017","32017","42017","12018","22018","32018","42018","12019","22019","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average"]
[null,null,{"$f":"IF(C45>1,C45,B43)","v":"2014"},"2014","2014","2015","2015","2015","2015","2016","2016","2016","2016","2017","2017","2017","2017","2018","2018","2018","2018","2019","2019","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average"]
[null,"Average of TTHM, Mg/L","Years","Date"]
[null,null,"2014",null,null,"2015",null,null,null,"2016",null,null,null,"2017",null,null,null,"2018",null,null,null,"2019",null,"Average"]
[null,"Sample Site","Qtr2","Qtr3","Qtr4","Qtr1","Qtr2","Qtr3","Qtr4","Qtr1","Qtr2","Qtr3","Qtr4","Qtr1","Qtr2","Qtr3","Qtr4","Qtr1","Qtr2","Qtr3","Qtr4","Qtr1","Qtr2"]
[null,"11405 LARRY LAKE ROAD",9.3699999999999999E-3,1.78E-2,1.35E-2,8.8199999999999997E-3,1.0500000000000001E-2,1.67E-2,1.4200000000000001E-2,1.2500000000000001E-2,1.0999999999999999E-2,1.41E-2,8.6099999999999996E-3,6.2199999999999998E-3,1.77E-2,2.6599999999999999E-2,1.6E-2,8.6899999999999998E-3,1.4E-2,1.18E-2,2.5399999999999999E-2,1.47E-2,1.7299999999999999E-2,1.4071904761904761E-2]
[null,"13191 DEASON CAMP ROAD",4.3799999999999999E-2,8.4500000000000006E-2,4.24E-2,3.5799999999999998E-2,3.6900000000000002E-2,7.6899999999999996E-2,5.1900000000000002E-2,4.36E-2,3.2000000000000001E-2,6.4799999999999996E-2,4.2500000000000003E-2,2.3E-2,4.6699999999999998E-2,7.9299999999999995E-2,7.0599999999999996E-2,2.6599999999999999E-2,"na","na","na","na","na",5.0081250000000001E-2]
[null,"13920 GRAND POINTE ROAD",2.8400000000000002E-2,5.4600000000000003E-2,3.6799999999999999E-2,2.58E-2,2.5999999999999999E-2,4.19E-2,4.8000000000000001E-2,3.1099999999999999E-2,2.7E-2,6.3100000000000003E-2,2.9499999999999998E-2,1.8499999999999999E-2,3.8699999999999998E-2,5.1400000000000001E-2,5.0500000000000003E-2,1.7399999999999999E-2,"na","na","na","na","na",3.679375E-2]
[null,"3950 3RD STREET SOUTH",4.5100000000000001E-2,8.5800000000000001E-2,6.1400000000000003E-2,3.6799999999999999E-2,3.5400000000000001E-2,7.0699999999999999E-2,5.8999999999999997E-2,4.3700000000000003E-2,3.5999999999999997E-2,7.1099999999999997E-2,8.6099999999999996E-3,2.46E-2,4.9599999999999998E-2,8.2799999999999999E-2,6.4199999999999993E-2,2.86E-2,"na","na","na","na","na",5.021312499999999E-2]
[null,"6802 MCFARLAND BLVD",4.4600000000000001E-2,5.7599999999999998E-2,5.21E-2,3.5200000000000002E-2,3.6999999999999998E-2,7.6200000000000004E-2,4.4900000000000002E-2,4.3900000000000002E-2,3.7999999999999999E-2,6.0600000000000001E-2,4.3999999999999997E-2,2.2200000000000001E-2,3.8600000000000002E-2,7.6200000000000004E-2,5.3999999999999999E-2,2.4500000000000001E-2,"na","na","na","na","na",4.6850000000000003E-2]
[null,"#1 BOOTH ESTATES","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na",4.2599999999999999E-2,8.3099999999999993E-2,6.0999999999999999E-2,3.9300000000000002E-2,2.98E-2,5.1159999999999997E-2]
[null,"17689 PINE LAKE RD","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na",5.3199999999999997E-2,7.9200000000000007E-2,6.2799999999999995E-2,3.5200000000000002E-2,3.1600000000000003E-2,5.2400000000000002E-2]
[null,"2920 39TH ST","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na",6.0299999999999999E-2,2.9899999999999999E-2,0.1062,3.1600000000000003E-2,2.9600000000000001E-2,5.152000000000001E-2]
[null,"6425 5TH ST","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na",4.9299999999999997E-2,9.74E-2,6.9900000000000004E-2,3.5099999999999999E-2,3.1800000000000002E-2,5.6700000000000007E-2]
[null,"Average",3.4254E-2,6.0060000000000002E-2,4.1240000000000006E-2,2.8483999999999999E-2,2.9160000000000002E-2,5.6479999999999995E-2,4.36E-2,3.4960000000000005E-2,2.8799999999999999E-2,5.4739999999999997E-2,2.6644000000000001E-2,1.8903999999999997E-2,3.8260000000000002E-2,6.3259999999999997E-2,5.1059999999999994E-2,2.1158E-2,4.3879999999999995E-2,6.028E-2,6.5060000000000007E-2,3.1180000000000003E-2,2.802E-2,4.0927809523809519E-2]

{"sheet":"TTHM Chart","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"TTHM Goals","index":11,"n_rows":64,"n_cols":15,"rows_kept":64,"cut":false,"hidden":false,"merged":[[13,12,13,15]]}
["TTHM Goals Calculation"]
["If desired, the goals can be modified on a system-specific basis.  Default values are shown in the comment boxes below."]
["Individual Site Goal:",7.0000000000000007E-2]
["Long-Term System Goal:",0.06]
["Water System Name:",{"$f":"'Data Entry'!K1","v":"Water System Name"}]
["Yellow","highlighted LRAA exceeds TTHM Individual Site Goal (i.e., default goal is LRAA < 0.07 Mg/L) for that quarter"]
["Blue","highlighted LRAA is the max LRAA for that quarter; unless the LRAA exceeds the Individual Site Goal (see above)"]
["Green","highlighted data exceeds the TTHM Long-Term System Goal (i.e., default goal is ave Max LRAAs < 0.06 Mg/L)"]
[]
[null,{"$f":"B11&B12","v":"42016"},{"$f":"C11&C12","v":"12017"},"22017","32017","42017","12018","22018","32018","42018","12019","22019"]
[null,{"$f":"IF(C11=4,3,IF(C11=3,2,IF(C11=2,1,IF(C11=1,4))))","v":4},1,2,3,4,1,2,3,4,{"$f":"IF(L11=4,3,IF(L11=3,2,IF(L11=2,1,IF(L11=1,4))))","v":1},{"$f":"RIGHT(LEFT(L10,1),1)*1","v":2}]
[null,{"$f":"IF(C11=4,C12,IF(C11=3,C12,IF(C11=2,C12,IF(C11=1,C12-1))))","v":2016},2017,2017,2017,2017,2018,2018,2018,2018,{"$f":"IF(L11=4,L12,IF(L11=3,L12,IF(L11=2,L12,IF(L11=1,L12-1))))","v":2019},{"$f":"RIGHT(LEFT(L10,5),4)*1","v":2019}]
["Sample Site",{"$f":"\"Q\"&B11&\" \"&B12","v":"Q4 2016"},{"$f":"\"Q\"&C11&\" \"&C12","v":"Q1 2017"},"Q2 2017","Q3 2017","Q4 2017","Q1 2018","Q2 2018","Q3 2018","Q4 2018","Q1 2019",{"$f":"\"Q\"&L11&\" \"&L12","v":"Q2 2019"}]
["11405 LARRY LAKE ROAD",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A14,TTHMTable[Column1],0),FALSE)","v":8.6099999999999996E-3},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A14,TTHMTable[Column1],0),FALSE)","v":6.2199999999999998E-3},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A14,TTHMTable[Column1],0),FALSE)","v":1.77E-2},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A14,TTHMTable[Column1],0),FALSE)","v":2.6599999999999999E-2},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A14,TTHMTable[Column1],0),FALSE)","v":1.6E-2},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A14,TTHMTable[Column1],0),FALSE)","v":8.6899999999999998E-3},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A14,TTHMTable[Column1],0),FALSE)","v":1.4E-2},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A14,TTHMTable[Column1],0),FALSE)","v":1.18E-2},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A14,TTHMTable[Column1],0),FALSE)","v":2.5399999999999999E-2},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A14,TTHMTable[Column1],0),FALSE)","v":1.47E-2},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A14,TTHMTable[Column1],0),FALSE)","v":1.7299999999999999E-2}]
["13191 DEASON CAMP ROAD",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A15,TTHMTable[Column1],0),FALSE)","v":4.2500000000000003E-2},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A15,TTHMTable[Column1],0),FALSE)","v":2.3E-2},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A15,TTHMTable[Column1],0),FALSE)","v":4.6699999999999998E-2},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A15,TTHMTable[Column1],0),FALSE)","v":7.9299999999999995E-2},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A15,TTHMTable[Column1],0),FALSE)","v":7.0599999999999996E-2},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A15,TTHMTable[Column1],0),FALSE)","v":2.6599999999999999E-2},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A15,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A15,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A15,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A15,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A15,TTHMTable[Column1],0),FALSE)","v":"na"}]
["13920 GRAND POINTE ROAD",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A16,TTHMTable[Column1],0),FALSE)","v":2.9499999999999998E-2},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A16,TTHMTable[Column1],0),FALSE)","v":1.8499999999999999E-2},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A16,TTHMTable[Column1],0),FALSE)","v":3.8699999999999998E-2},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A16,TTHMTable[Column1],0),FALSE)","v":5.1400000000000001E-2},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A16,TTHMTable[Column1],0),FALSE)","v":5.0500000000000003E-2},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A16,TTHMTable[Column1],0),FALSE)","v":1.7399999999999999E-2},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A16,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A16,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A16,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A16,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A16,TTHMTable[Column1],0),FALSE)","v":"na"}]
["3950 3RD STREET SOUTH",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A17,TTHMTable[Column1],0),FALSE)","v":8.6099999999999996E-3},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A17,TTHMTable[Column1],0),FALSE)","v":2.46E-2},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A17,TTHMTable[Column1],0),FALSE)","v":4.9599999999999998E-2},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A17,TTHMTable[Column1],0),FALSE)","v":8.2799999999999999E-2},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A17,TTHMTable[Column1],0),FALSE)","v":6.4199999999999993E-2},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A17,TTHMTable[Column1],0),FALSE)","v":2.86E-2},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A17,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A17,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A17,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A17,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A17,TTHMTable[Column1],0),FALSE)","v":"na"}]
["6802 MCFARLAND BLVD",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A18,TTHMTable[Column1],0),FALSE)","v":4.3999999999999997E-2},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A18,TTHMTable[Column1],0),FALSE)","v":2.2200000000000001E-2},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A18,TTHMTable[Column1],0),FALSE)","v":3.8600000000000002E-2},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A18,TTHMTable[Column1],0),FALSE)","v":7.6200000000000004E-2},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A18,TTHMTable[Column1],0),FALSE)","v":5.3999999999999999E-2},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A18,TTHMTable[Column1],0),FALSE)","v":2.4500000000000001E-2},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A18,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A18,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A18,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A18,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A18,TTHMTable[Column1],0),FALSE)","v":"na"}]
["#1 BOOTH ESTATES",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A19,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A19,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A19,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A19,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A19,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A19,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A19,TTHMTable[Column1],0),FALSE)","v":4.2599999999999999E-2},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A19,TTHMTable[Column1],0),FALSE)","v":8.3099999999999993E-2},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A19,TTHMTable[Column1],0),FALSE)","v":6.0999999999999999E-2},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A19,TTHMTable[Column1],0),FALSE)","v":3.9300000000000002E-2},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A19,TTHMTable[Column1],0),FALSE)","v":2.98E-2}]
["17689 PINE LAKE RD",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A20,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A20,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A20,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A20,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A20,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A20,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A20,TTHMTable[Column1],0),FALSE)","v":5.3199999999999997E-2},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A20,TTHMTable[Column1],0),FALSE)","v":7.9200000000000007E-2},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A20,TTHMTable[Column1],0),FALSE)","v":6.2799999999999995E-2},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A20,TTHMTable[Column1],0),FALSE)","v":3.5200000000000002E-2},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A20,TTHMTable[Column1],0),FALSE)","v":3.1600000000000003E-2}]
["2920 39TH ST",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A21,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A21,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A21,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A21,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A21,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A21,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A21,TTHMTable[Column1],0),FALSE)","v":6.0299999999999999E-2},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A21,TTHMTable[Column1],0),FALSE)","v":2.9899999999999999E-2},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A21,TTHMTable[Column1],0),FALSE)","v":0.1062},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A21,TTHMTable[Column1],0),FALSE)","v":3.1600000000000003E-2},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A21,TTHMTable[Column1],0),FALSE)","v":2.9600000000000001E-2}]
["6425 5TH ST",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A22,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A22,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A22,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A22,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A22,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A22,TTHMTable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A22,TTHMTable[Column1],0),FALSE)","v":4.9299999999999997E-2},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A22,TTHMTable[Column1],0),FALSE)","v":9.74E-2},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A22,TTHMTable[Column1],0),FALSE)","v":6.9900000000000004E-2},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A22,TTHMTable[Column1],0),FALSE)","v":3.5099999999999999E-2},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A22,TTHMTable[Column1],0),FALSE)","v":3.1800000000000002E-2}]
[null,{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A23,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A23,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A23,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A23,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A23,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A23,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A23,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A23,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A23,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A23,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A23,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A24,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A24,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A24,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A24,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A24,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A24,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A24,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A24,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A24,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A24,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A24,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A25,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A25,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A25,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A25,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A25,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A25,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A25,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A25,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A25,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A25,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A25,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A26,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A26,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A26,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A26,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A26,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A26,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A26,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A26,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A26,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A26,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A26,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A27,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A27,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A27,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A27,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A27,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A27,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A27,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A27,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A27,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A27,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A27,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A28,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A28,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A28,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A28,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A28,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A28,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A28,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A28,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A28,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A28,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A28,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},null,"Formulas for labeling max. LRAA sites on LT charts"]
[null,{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A29,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A29,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A29,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A29,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A29,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A29,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A29,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A29,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A29,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A29,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A29,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A30,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A30,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A30,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A30,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A30,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A30,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A30,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A30,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A30,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A30,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A30,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A31,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A31,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A31,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A31,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A31,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A31,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A31,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A31,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A31,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A31,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A31,TTHMTable[Column1],0),FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"IF(ISBLANK(A14),\"\",A14)","v":"11405 LARRY LAKE ROAD"},{"$f":"IF(ISBLANK(A14),\"\",\"LRAA\")","v":"LRAA"},null,null,{"$f":"IF(COUNT(B14:E14)<4,\"NA\",AVERAGE(B14:E14))","v":1.4782500000000001E-2},1.6629999999999999E-2,1.7247499999999999E-2,1.63225E-2,1.26225E-2,1.49725E-2,1.6475E-2,1.7299999999999999E-2,null,{"$f":"A32","v":"11405 LARRY LAKE ROAD"},{"$f":"IF($E$57=A32,A32,IF($F$57=A32,A32,IF($G$57=A32,A32,IF($H$57=A32,A32,IF($I$57=A32,A32,IF($J$57=A32,A32,IF($K$57=A32,A32,IF($L$57=A32,A32,\"\"))))))))","v":"11405 LARRY LAKE ROAD"}]
[{"$f":"IF(ISBLANK(A15),\"\",A15)","v":"13191 DEASON CAMP ROAD"},{"$f":"IF(ISBLANK(A15),\"\",\"LRAA\")","v":"LRAA"},null,null,4.7875000000000001E-2,5.4899999999999997E-2,5.5800000000000002E-2,"NA","NA","NA","NA","NA",null,"13191 DEASON CAMP ROAD",{"$f":"IF($E$57=A33,A33,IF($F$57=A33,A33,IF($G$57=A33,A33,IF($H$57=A33,A33,IF($I$57=A33,A33,IF($J$57=A33,A33,IF($K$57=A33,A33,IF($L$57=A33,A33,\"\"))))))))","v":"13191 DEASON CAMP ROAD"}]
[{"$f":"IF(ISBLANK(A16),\"\",A16)","v":"13920 GRAND POINTE ROAD"},{"$f":"IF(ISBLANK(A16),\"\",\"LRAA\")","v":"LRAA"},null,null,3.4525E-2,3.9775000000000005E-2,3.95E-2,"NA","NA","NA","NA","NA",null,"13920 GRAND POINTE ROAD",{"$f":"IF($E$57=A34,A34,IF($F$57=A34,A34,IF($G$57=A34,A34,IF($H$57=A34,A34,IF($I$57=A34,A34,IF($J$57=A34,A34,IF($K$57=A34,A34,IF($L$57=A34,A34,\"\"))))))))","v":""}]
[{"$f":"IF(ISBLANK(A17),\"\",A17)","v":"3950 3RD STREET SOUTH"},{"$f":"IF(ISBLANK(A17),\"\",\"LRAA\")","v":"LRAA"},null,null,4.1402499999999995E-2,5.5300000000000002E-2,5.6300000000000003E-2,"NA","NA","NA","NA","NA",null,"3950 3RD STREET SOUTH",{"$f":"IF($E$57=A35,A35,IF($F$57=A35,A35,IF($G$57=A35,A35,IF($H$57=A35,A35,IF($I$57=A35,A35,IF($J$57=A35,A35,IF($K$57=A35,A35,IF($L$57=A35,A35,\"\"))))))))","v":"3950 3RD STREET SOUTH"}]
[{"$f":"IF(ISBLANK(A18),\"\",A18)","v":"6802 MCFARLAND BLVD"},{"$f":"IF(ISBLANK(A18),\"\",\"LRAA\")","v":"LRAA"},null,null,{"$f":"IF(COUNT(B18:E18)<4,\"NA\",AVERAGE(B18:E18))","v":4.5249999999999999E-2},4.7750000000000001E-2,4.8325E-2,"NA","NA","NA","NA","NA"]
["#1 BOOTH ESTATES","LRAA",null,null,{"$f":"IF(COUNT(B19:E19)<4,\"NA\",AVERAGE(B19:E19))","v":"NA"},"NA","NA","NA","NA","NA",5.6499999999999995E-2,5.33E-2]
["17689 PINE LAKE RD","LRAA",null,null,{"$f":"IF(COUNT(B20:E20)<4,\"NA\",AVERAGE(B20:E20))","v":"NA"},"NA","NA","NA","NA","NA",5.7600000000000005E-2,5.220000000000001E-2]
[{"$f":"IF(ISBLANK(A21),\"\",A21)","v":"2920 39TH ST"},{"$f":"IF(ISBLANK(A21),\"\",\"LRAA\")","v":"LRAA"},null,null,{"$f":"IF(COUNT(B21:E21)<4,\"NA\",AVERAGE(B21:E21))","v":"NA"},"NA","NA","NA","NA","NA",5.7000000000000009E-2,4.9325000000000008E-2,null,"2920 39TH ST",{"$f":"IF($E$57=A39,A39,IF($F$57=A39,A39,IF($G$57=A39,A39,IF($H$57=A39,A39,IF($I$57=A39,A39,IF($J$57=A39,A39,IF($K$57=A39,A39,IF($L$57=A39,A39,\"\"))))))))","v":""}]
["6425 5TH ST","LRAA",null,null,{"$f":"IF(COUNT(B22:E22)<4,\"NA\",AVERAGE(B22:E22))","v":"NA"},"NA","NA","NA","NA","NA",6.2925000000000009E-2,5.8549999999999998E-2,null,"6425 5TH ST","6425 5TH ST"]
["","",null,null,{"$f":"IF(COUNT(B23:E23)<4,\"NA\",AVERAGE(B23:E23))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"",""]
["","",null,null,{"$f":"IF(COUNT(B24:E24)<4,\"NA\",AVERAGE(B24:E24))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"",""]
["","",null,null,{"$f":"IF(COUNT(B25:E25)<4,\"NA\",AVERAGE(B25:E25))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"",""]
["","",null,null,{"$f":"IF(COUNT(B26:E26)<4,\"NA\",AVERAGE(B26:E26))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"",""]
["","",null,null,{"$f":"IF(COUNT(B27:E27)<4,\"NA\",AVERAGE(B27:E27))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"",""]
["","",null,null,{"$f":"IF(COUNT(B28:E28)<4,\"NA\",AVERAGE(B28:E28))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"",""]
["","",null,null,{"$f":"IF(COUNT(B29:E29)<4,\"NA\",AVERAGE(B29:E29))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"",""]
["","",null,null,{"$f":"IF(COUNT(B30:E30)<4,\"NA\",AVERAGE(B30:E30))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"",""]
["","",null,null,{"$f":"IF(COUNT(B31:E31)<4,\"NA\",AVERAGE(B31:E31))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"",""]
["Max LRAA",null,null,null,{"$f":"IF(COUNT(E32:E49)=0,\"NA\",MAX(E32:E49))","v":4.7875000000000001E-2},{"$f":"IF(COUNT(F32:F49)=0,\"NA\",MAX(F32:F49))","v":5.5300000000000002E-2},5.6300000000000003E-2,1.63225E-2,1.26225E-2,1.49725E-2,6.2925000000000009E-2,{"$f":"IF(COUNT(L32:L49)=0,\"NA\",MAX(L32:L49))","v":5.8549999999999998E-2},null,null,{"$f":"CONCATENATE(O32,\"  \",O33,\"  \",O34,\"  \",O35,\"  \",O39,\"  \",O40,\"  \",O41,\"  \",O42,\"  \",O43,\"  \",O44,\"  \",O45,\"  \",O46)","v":"11405 LARRY LAKE ROAD  13191 DEASON CAMP ROAD    3950 3RD STREET SOUTH    6425 5TH ST            "}]
["Avg of Max LRAAs",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(E50:L50)<8,\"NA\",AVERAGE(E50:L50))","v":4.0608437499999997E-2}]
[]
["Data for plotting"]
["Avg of Max LRAAs",null,null,null,{"$f":"$L$51","v":4.0608437499999997E-2},{"$f":"$L$51","v":4.0608437499999997E-2},4.0608437499999997E-2,4.0608437499999997E-2,4.0608437499999997E-2,4.0608437499999997E-2,4.0608437499999997E-2,{"$f":"L51","v":4.0608437499999997E-2}]
["Individual Site Goal",null,null,null,{"$f":"+$B$3","v":7.0000000000000007E-2},7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2]
["Long-Term System Goal",null,null,null,{"$f":"+$B$4","v":0.06},0.06,0.06,0.06,0.06,0.06,0.06,0.06]
[null,null,null,null,{"$f":"IF(SUM(E32:E46)=0,\"\",(VLOOKUP(MAX(E32:E46),$E$32:$N$46,10,FALSE)))","v":"13191 DEASON CAMP ROAD"},{"$f":"IF(SUM(F32:F46)=0,\"\",(VLOOKUP(MAX(F32:F46),$F$32:$N$46,9,FALSE)))","v":"3950 3RD STREET SOUTH"},{"$f":"IF(SUM(G32:G46)=0,\"\",(VLOOKUP(MAX(G32:G46),$G$32:$N$46,8,FALSE)))","v":"3950 3RD STREET SOUTH"},{"$f":"IF(SUM(H32:H46)=0,\"\",(VLOOKUP(MAX(H32:H46),$H$32:$N$46,7,FALSE)))","v":"11405 LARRY LAKE ROAD"},{"$f":"IF(SUM(I32:I46)=0,\"\",(VLOOKUP(MAX(I32:I46),$I$32:$N$46,6,FALSE)))","v":"11405 LARRY LAKE ROAD"},{"$f":"IF(SUM(J32:J46)=0,\"\",(VLOOKUP(MAX(J32:J46),$J$32:$N$46,5,FALSE)))","v":"11405 LARRY LAKE ROAD"},{"$f":"IF(SUM(K32:K46)=0,\"\",(VLOOKUP(MAX(K32:K46),$K$32:$N$46,4,FALSE)))","v":"6425 5TH ST"},{"$f":"IF(SUM(L32:L46)=0,\"\",(VLOOKUP(MAX(L32:L46),$L$32:$N$46,3,FALSE)))","v":"6425 5TH ST"}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Sites Contributing to Maximum LRAA:"]
[null,null,null,null,null,null,null,null,{"$f":"O50","v":"11405 LARRY LAKE ROAD  13191 DEASON CAMP ROAD    3950 3RD STREET SOUTH    6425 5TH ST            "}]

{"sheet":"HAA5 Summary Table","index":12,"n_rows":55,"n_cols":33,"rows_kept":55,"cut":false,"hidden":true,"merged":[[0,0,1,11]]}
["Note:  If table is not updated go to the \"Data Entry\" tab and click the \"Update Tables\" button.  If table does not update, make sure that macros are enabled. Go to Trust Center & Macro Settings to enable macros.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Entry'!K1:K2","v":"Water System Name"}]
[]
["Average of HAA5, Mg/L","Years","Date"]
[null,"2014",null,null,"2015",null,null,null,"2016",null,null,null,"2017",null,null,null,"2018",null,null,null,"2019",null,"Average"]
["Sample Site","Qtr2","Qtr3","Qtr4","Qtr1","Qtr2","Qtr3","Qtr4","Qtr1","Qtr2","Qtr3","Qtr4","Qtr1","Qtr2","Qtr3","Qtr4","Qtr1","Qtr2","Qtr3","Qtr4","Qtr1","Qtr2"]
["11405 LARRY LAKE ROAD",1.18E-2,1.2699999999999999E-2,1.12E-2,1.66E-2,0.01,1.6799999999999999E-2,1.2800000000000001E-2,2.0199999999999999E-2,1.4E-2,1.72E-2,9.6900000000000007E-3,7.4200000000000004E-3,1.9300000000000001E-2,3.2800000000000003E-2,1.38E-2,9.0699999999999999E-3,1.6199999999999999E-2,1.47E-2,2.2499999999999999E-2,2.2200000000000001E-2,2.1999999999999999E-2,1.5856190476190479E-2]
["13191 DEASON CAMP ROAD",2.7300000000000001E-2,6.2799999999999995E-2,3.6400000000000002E-2,3.56E-2,2.9600000000000001E-2,4.9500000000000002E-2,3.3599999999999998E-2,5.04E-2,3.2000000000000001E-2,4.6100000000000002E-2,3.7600000000000001E-2,2.0199999999999999E-2,3.78E-2,6.13E-2,4.4299999999999999E-2,2.01E-2,"na","na","na","na","na",3.9037500000000003E-2]
["13920 GRAND POINTE ROAD",2.4899999999999999E-2,4.7E-2,2.41E-2,3.1600000000000003E-2,1.9E-2,3.4200000000000001E-2,2.9100000000000001E-2,4.9500000000000002E-2,2.9000000000000001E-2,4.7800000000000002E-2,2.7400000000000001E-2,1.7999999999999999E-2,3.5000000000000003E-2,4.7699999999999999E-2,3.8399999999999997E-2,1.52E-2,"na","na","na","na","na",3.2368750000000002E-2]
["3950 3RD STREET SOUTH",2.9899999999999999E-2,6.0900000000000003E-2,3.9800000000000002E-2,3.4500000000000003E-2,2.7199999999999998E-2,4.9599999999999998E-2,3.85E-2,4.99E-2,3.5999999999999997E-2,4.6399999999999997E-2,9.6900000000000007E-3,1.84E-2,4.3499999999999997E-2,6.1699999999999998E-2,4.4400000000000002E-2,1.9099999999999999E-2,"na","na","na","na","na",3.8093124999999992E-2]
["6802 MCFARLAND BLVD",0.03,5.1700000000000003E-2,3.8600000000000002E-2,3.2899999999999999E-2,2.98E-2,4.82E-2,3.4099999999999998E-2,4.99E-2,3.4000000000000002E-2,4.2900000000000001E-2,3.6600000000000001E-2,2.1899999999999999E-2,4.1200000000000001E-2,6.08E-2,4.7899999999999998E-2,1.8200000000000001E-2,"na","na","na","na","na",3.8668750000000002E-2]
["#1 BOOTH ESTATES","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na",3.4500000000000003E-2,6.5600000000000006E-2,4.5900000000000003E-2,4.7300000000000002E-2,3.5000000000000003E-2,4.5660000000000006E-2]
["17689 PINE LAKE RD","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na",5.8400000000000001E-2,6.1499999999999999E-2,4.6100000000000002E-2,5.11E-2,3.5999999999999997E-2,5.0619999999999998E-2]
["2920 39TH ST","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na",5.7299999999999997E-2,7.2800000000000004E-2,6.8900000000000003E-2,3.7999999999999999E-2,3.2300000000000002E-2,5.3860000000000005E-2]
["6425 5TH ST","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na",4.0899999999999999E-2,6.4899999999999999E-2,4.8099999999999997E-2,4.6899999999999997E-2,3.4000000000000002E-2,4.6960000000000002E-2]
["Average",2.478E-2,4.7019999999999999E-2,3.0020000000000002E-2,3.024E-2,2.3120000000000002E-2,3.9660000000000001E-2,2.9619999999999997E-2,4.3979999999999998E-2,2.8999999999999998E-2,4.0079999999999998E-2,2.4196000000000002E-2,1.7183999999999998E-2,3.5360000000000003E-2,5.2860000000000004E-2,3.7760000000000002E-2,1.6333999999999998E-2,4.1459999999999997E-2,5.5900000000000005E-2,4.6300000000000001E-2,4.1100000000000005E-2,3.1859999999999999E-2,3.5134952380952378E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10","Column11","Column12","Column13","Column14","Column15","Column16","Column17","Column18","Column19","Column20","Column21","Column22","Column23","Column24","Column25","Column26","Column27","Column28","Column29","Column30","Column31","Column32","Column33"]
[null,{"$f":"RIGHT(LEFT(B45,4),1)&B42","v":"22014"},{"$f":"RIGHT(LEFT(C45,4),1)&C42","v":"32014"},{"$f":"RIGHT(LEFT(D45,4),1)&D42","v":"42014"},{"$f":"RIGHT(LEFT(E45,4),1)&E42","v":"12015"},{"$f":"RIGHT(LEFT(F45,4),1)&F42","v":"22015"},{"$f":"RIGHT(LEFT(G45,4),1)&G42","v":"32015"},{"$f":"RIGHT(LEFT(H45,4),1)&H42","v":"42015"},{"$f":"RIGHT(LEFT(I45,4),1)&I42","v":"12016"},{"$f":"RIGHT(LEFT(J45,4),1)&J42","v":"22016"},{"$f":"RIGHT(LEFT(K45,4),1)&K42","v":"32016"},{"$f":"RIGHT(LEFT(L45,4),1)&L42","v":"42016"},{"$f":"RIGHT(LEFT(M45,4),1)&M42","v":"12017"},{"$f":"RIGHT(LEFT(N45,4),1)&N42","v":"22017"},{"$f":"RIGHT(LEFT(O45,4),1)&O42","v":"32017"},{"$f":"RIGHT(LEFT(P45,4),1)&P42","v":"42017"},{"$f":"RIGHT(LEFT(Q45,4),1)&Q42","v":"12018"},{"$f":"RIGHT(LEFT(R45,4),1)&R42","v":"22018"},{"$f":"RIGHT(LEFT(S45,4),1)&S42","v":"32018"},{"$f":"RIGHT(LEFT(T45,4),1)&T42","v":"42018"},{"$f":"RIGHT(LEFT(U45,4),1)&U42","v":"12019"},{"$f":"RIGHT(LEFT(V45,4),1)&V42","v":"22019"},{"$f":"RIGHT(LEFT(W45,4),1)&W42","v":"Average"},{"$f":"RIGHT(LEFT(X45,4),1)&X42","v":"Average"},{"$f":"RIGHT(LEFT(Y45,4),1)&Y42","v":"Average"},{"$f":"RIGHT(LEFT(Z45,4),1)&Z42","v":"Average"},{"$f":"RIGHT(LEFT(AA45,4),1)&AA42","v":"Average"},{"$f":"RIGHT(LEFT(AB45,4),1)&AB42","v":"Average"},{"$f":"RIGHT(LEFT(AC45,4),1)&AC42","v":"Average"},{"$f":"RIGHT(LEFT(AD45,4),1)&AD42","v":"Average"},{"$f":"RIGHT(LEFT(AE45,4),1)&AE42","v":"Average"},{"$f":"RIGHT(LEFT(AF45,4),1)&AF42","v":"Average"},{"$f":"RIGHT(LEFT(AG45,4),1)&AG42","v":"Average"}]
[null,{"$f":"IF(B44>1,B44,A42)","v":"2014"},{"$f":"IF(C44>1,C44,B42)","v":"2014"},{"$f":"IF(D44>1,D44,C42)","v":"2014"},{"$f":"IF(E44>1,E44,D42)","v":"2015"},{"$f":"IF(F44>1,F44,E42)","v":"2015"},{"$f":"IF(G44>1,G44,F42)","v":"2015"},{"$f":"IF(H44>1,H44,G42)","v":"2015"},{"$f":"IF(I44>1,I44,H42)","v":"2016"},{"$f":"IF(J44>1,J44,I42)","v":"2016"},{"$f":"IF(K44>1,K44,J42)","v":"2016"},{"$f":"IF(L44>1,L44,K42)","v":"2016"},{"$f":"IF(M44>1,M44,L42)","v":"2017"},{"$f":"IF(N44>1,N44,M42)","v":"2017"},{"$f":"IF(O44>1,O44,N42)","v":"2017"},{"$f":"IF(P44>1,P44,O42)","v":"2017"},{"$f":"IF(Q44>1,Q44,P42)","v":"2018"},{"$f":"IF(R44>1,R44,Q42)","v":"2018"},{"$f":"IF(S44>1,S44,R42)","v":"2018"},{"$f":"IF(T44>1,T44,S42)","v":"2018"},{"$f":"IF(U44>1,U44,T42)","v":"2019"},{"$f":"IF(V44>1,V44,U42)","v":"2019"},{"$f":"IF(W44>1,W44,V42)","v":"Average"},{"$f":"IF(X44>1,X44,W42)","v":"Average"},{"$f":"IF(Y44>1,Y44,X42)","v":"Average"},{"$f":"IF(Z44>1,Z44,Y42)","v":"Average"},{"$f":"IF(AA44>1,AA44,Z42)","v":"Average"},{"$f":"IF(AB44>1,AB44,AA42)","v":"Average"},{"$f":"IF(AC44>1,AC44,AB42)","v":"Average"},{"$f":"IF(AD44>1,AD44,AC42)","v":"Average"},{"$f":"IF(AE44>1,AE44,AD42)","v":"Average"},{"$f":"IF(AF44>1,AF44,AE42)","v":"Average"},{"$f":"IF(AG44>1,AG44,AF42)","v":"Average"}]
["Average of HAA5, Mg/L","Years","Date"]
[null,"2014",null,null,"2015",null,null,null,"2016",null,null,null,"2017",null,null,null,"2018",null,null,null,"2019",null,"Average"]
["Sample Site","Qtr2","Qtr3","Qtr4","Qtr1","Qtr2","Qtr3","Qtr4","Qtr1","Qtr2","Qtr3","Qtr4","Qtr1","Qtr2","Qtr3","Qtr4","Qtr1","Qtr2","Qtr3","Qtr4","Qtr1","Qtr2"]
["11405 LARRY LAKE ROAD",1.18E-2,1.2699999999999999E-2,1.12E-2,1.66E-2,0.01,1.6799999999999999E-2,1.2800000000000001E-2,2.0199999999999999E-2,1.4E-2,1.72E-2,9.6900000000000007E-3,7.4200000000000004E-3,1.9300000000000001E-2,3.2800000000000003E-2,1.38E-2,9.0699999999999999E-3,1.6199999999999999E-2,1.47E-2,2.2499999999999999E-2,2.2200000000000001E-2,2.1999999999999999E-2,1.5856190476190479E-2]
["13191 DEASON CAMP ROAD",2.7300000000000001E-2,6.2799999999999995E-2,3.6400000000000002E-2,3.56E-2,2.9600000000000001E-2,4.9500000000000002E-2,3.3599999999999998E-2,5.04E-2,3.2000000000000001E-2,4.6100000000000002E-2,3.7600000000000001E-2,2.0199999999999999E-2,3.78E-2,6.13E-2,4.4299999999999999E-2,2.01E-2,"na","na","na","na","na",3.9037500000000003E-2]
["13920 GRAND POINTE ROAD",2.4899999999999999E-2,4.7E-2,2.41E-2,3.1600000000000003E-2,1.9E-2,3.4200000000000001E-2,2.9100000000000001E-2,4.9500000000000002E-2,2.9000000000000001E-2,4.7800000000000002E-2,2.7400000000000001E-2,1.7999999999999999E-2,3.5000000000000003E-2,4.7699999999999999E-2,3.8399999999999997E-2,1.52E-2,"na","na","na","na","na",3.2368750000000002E-2]
["3950 3RD STREET SOUTH",2.9899999999999999E-2,6.0900000000000003E-2,3.9800000000000002E-2,3.4500000000000003E-2,2.7199999999999998E-2,4.9599999999999998E-2,3.85E-2,4.99E-2,3.5999999999999997E-2,4.6399999999999997E-2,9.6900000000000007E-3,1.84E-2,4.3499999999999997E-2,6.1699999999999998E-2,4.4400000000000002E-2,1.9099999999999999E-2,"na","na","na","na","na",3.8093124999999992E-2]
["6802 MCFARLAND BLVD",0.03,5.1700000000000003E-2,3.8600000000000002E-2,3.2899999999999999E-2,2.98E-2,4.82E-2,3.4099999999999998E-2,4.99E-2,3.4000000000000002E-2,4.2900000000000001E-2,3.6600000000000001E-2,2.1899999999999999E-2,4.1200000000000001E-2,6.08E-2,4.7899999999999998E-2,1.8200000000000001E-2,"na","na","na","na","na",3.8668750000000002E-2]
["#1 BOOTH ESTATES","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na",3.4500000000000003E-2,6.5600000000000006E-2,4.5900000000000003E-2,4.7300000000000002E-2,3.5000000000000003E-2,4.5660000000000006E-2]
["17689 PINE LAKE RD","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na",5.8400000000000001E-2,6.1499999999999999E-2,4.6100000000000002E-2,5.11E-2,3.5999999999999997E-2,5.0619999999999998E-2]
["2920 39TH ST","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na",5.7299999999999997E-2,7.2800000000000004E-2,6.8900000000000003E-2,3.7999999999999999E-2,3.2300000000000002E-2,5.3860000000000005E-2]
["6425 5TH ST","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na","na",4.0899999999999999E-2,6.4899999999999999E-2,4.8099999999999997E-2,4.6899999999999997E-2,3.4000000000000002E-2,4.6960000000000002E-2]
["Average",2.478E-2,4.7019999999999999E-2,3.0020000000000002E-2,3.024E-2,2.3120000000000002E-2,3.9660000000000001E-2,2.9619999999999997E-2,4.3979999999999998E-2,2.8999999999999998E-2,4.0079999999999998E-2,2.4196000000000002E-2,1.7183999999999998E-2,3.5360000000000003E-2,5.2860000000000004E-2,3.7760000000000002E-2,1.6333999999999998E-2,4.1459999999999997E-2,5.5900000000000005E-2,4.6300000000000001E-2,4.1100000000000005E-2,3.1859999999999999E-2,3.5134952380952378E-2]

{"sheet":"HAA5 Chart","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"HAA5 Goals","index":14,"n_rows":64,"n_cols":15,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["HAA5 Goals Calculation"]
["If desired, the goals can be modified on a system-specific basis.  Default values are shown in the comment boxes below."]
["Individual Site Goal:",0.05]
["Long-Term System Goal:",0.04]
["Water System Name:",{"$f":"'TTHM Goals'!B5","v":"Water System Name"}]
["Yellow","highlighted LRAA exceeds TTHM Individual Site Goal (i.e., default goal is LRAA < 0.050 Mg/L) for that quarter"]
["Blue","highlighted LRAA is the max LRAA for that quarter; unless the LRAA exceeds the Individual Site Goal (see above)"]
["Green","highlighted data exceeds the TTHM Long-Term System Goal (i.e., default goal is ave Max LRAAs < 0.04 Mg/L)"]
[]
[null,{"$f":"B11&B12","v":"42016"},{"$f":"C11&C12","v":"12017"},"22017","32017","42017","12018","22018","32018","42018","12019","22019"]
[null,{"$f":"IF(C11=4,3,IF(C11=3,2,IF(C11=2,1,IF(C11=1,4))))","v":4},1,2,3,4,1,2,3,4,{"$f":"IF(L11=4,3,IF(L11=3,2,IF(L11=2,1,IF(L11=1,4))))","v":1},{"$f":"RIGHT(LEFT(L10,1),1)*1","v":2}]
[null,{"$f":"IF(C11=4,C12,IF(C11=3,C12,IF(C11=2,C12,IF(C11=1,C12-1))))","v":2016},2017,2017,2017,2017,2018,2018,2018,2018,{"$f":"IF(L11=4,L12,IF(L11=3,L12,IF(L11=2,L12,IF(L11=1,L12-1))))","v":2019},{"$f":"RIGHT(LEFT(L10,5),4)*1","v":2019}]
["Sample Site",{"$f":"\"Q\"&B11&\" \"&B12","v":"Q4 2016"},{"$f":"\"Q\"&C11&\" \"&C12","v":"Q1 2017"},"Q2 2017","Q3 2017","Q4 2017","Q1 2018","Q2 2018","Q3 2018","Q4 2018","Q1 2019",{"$f":"\"Q\"&L11&\" \"&L12","v":"Q2 2019"}]
["11405 LARRY LAKE ROAD",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A14,HAATable[Column1],0),FALSE)","v":9.6900000000000007E-3},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A14,HAATable[Column1],0),FALSE)","v":7.4200000000000004E-3},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A14,HAATable[Column1],0),FALSE)","v":1.9300000000000001E-2},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A14,HAATable[Column1],0),FALSE)","v":3.2800000000000003E-2},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A14,HAATable[Column1],0),FALSE)","v":1.38E-2},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A14,HAATable[Column1],0),FALSE)","v":9.0699999999999999E-3},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A14,HAATable[Column1],0),FALSE)","v":1.6199999999999999E-2},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A14,HAATable[Column1],0),FALSE)","v":1.47E-2},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A14,HAATable[Column1],0),FALSE)","v":2.2499999999999999E-2},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A14,HAATable[Column1],0),FALSE)","v":2.2200000000000001E-2},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A14,HAATable[Column1],0),FALSE)","v":2.1999999999999999E-2}]
["13191 DEASON CAMP ROAD",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A15,HAATable[Column1],0),FALSE)","v":3.7600000000000001E-2},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A15,HAATable[Column1],0),FALSE)","v":2.0199999999999999E-2},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A15,HAATable[Column1],0),FALSE)","v":3.78E-2},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A15,HAATable[Column1],0),FALSE)","v":6.13E-2},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A15,HAATable[Column1],0),FALSE)","v":4.4299999999999999E-2},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A15,HAATable[Column1],0),FALSE)","v":2.01E-2},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A15,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A15,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A15,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A15,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A15,HAATable[Column1],0),FALSE)","v":"na"}]
["13920 GRAND POINTE ROAD",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A16,HAATable[Column1],0),FALSE)","v":2.7400000000000001E-2},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A16,HAATable[Column1],0),FALSE)","v":1.7999999999999999E-2},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A16,HAATable[Column1],0),FALSE)","v":3.5000000000000003E-2},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A16,HAATable[Column1],0),FALSE)","v":4.7699999999999999E-2},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A16,HAATable[Column1],0),FALSE)","v":3.8399999999999997E-2},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A16,HAATable[Column1],0),FALSE)","v":1.52E-2},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A16,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A16,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A16,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A16,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A16,HAATable[Column1],0),FALSE)","v":"na"}]
["3950 3RD STREET SOUTH",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A17,HAATable[Column1],0),FALSE)","v":9.6900000000000007E-3},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A17,HAATable[Column1],0),FALSE)","v":1.84E-2},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A17,HAATable[Column1],0),FALSE)","v":4.3499999999999997E-2},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A17,HAATable[Column1],0),FALSE)","v":6.1699999999999998E-2},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A17,HAATable[Column1],0),FALSE)","v":4.4400000000000002E-2},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A17,HAATable[Column1],0),FALSE)","v":1.9099999999999999E-2},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A17,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A17,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A17,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A17,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A17,HAATable[Column1],0),FALSE)","v":"na"}]
["6802 MCFARLAND BLVD",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A18,HAATable[Column1],0),FALSE)","v":3.6600000000000001E-2},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A18,HAATable[Column1],0),FALSE)","v":2.1899999999999999E-2},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A18,HAATable[Column1],0),FALSE)","v":4.1200000000000001E-2},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A18,HAATable[Column1],0),FALSE)","v":6.08E-2},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A18,HAATable[Column1],0),FALSE)","v":4.7899999999999998E-2},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A18,HAATable[Column1],0),FALSE)","v":1.8200000000000001E-2},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A18,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A18,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A18,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A18,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A18,HAATable[Column1],0),FALSE)","v":"na"}]
["#1 BOOTH ESTATES",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A19,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A19,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A19,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A19,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A19,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A19,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A19,HAATable[Column1],0),FALSE)","v":3.4500000000000003E-2},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A19,HAATable[Column1],0),FALSE)","v":6.5600000000000006E-2},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A19,HAATable[Column1],0),FALSE)","v":4.5900000000000003E-2},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A19,HAATable[Column1],0),FALSE)","v":4.7300000000000002E-2},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A19,HAATable[Column1],0),FALSE)","v":3.5000000000000003E-2}]
["17689 PINE LAKE RD",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A20,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A20,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A20,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A20,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A20,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A20,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A20,HAATable[Column1],0),FALSE)","v":5.8400000000000001E-2},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A20,HAATable[Column1],0),FALSE)","v":6.1499999999999999E-2},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A20,HAATable[Column1],0),FALSE)","v":4.6100000000000002E-2},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A20,HAATable[Column1],0),FALSE)","v":5.11E-2},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A20,HAATable[Column1],0),FALSE)","v":3.5999999999999997E-2}]
["2920 39TH ST",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A21,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A21,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A21,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A21,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A21,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A21,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A21,HAATable[Column1],0),FALSE)","v":5.7299999999999997E-2},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A21,HAATable[Column1],0),FALSE)","v":7.2800000000000004E-2},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A21,HAATable[Column1],0),FALSE)","v":6.8900000000000003E-2},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A21,HAATable[Column1],0),FALSE)","v":3.7999999999999999E-2},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A21,HAATable[Column1],0),FALSE)","v":3.2300000000000002E-2}]
["6425 5TH ST",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A22,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A22,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A22,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A22,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A22,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A22,HAATable[Column1],0),FALSE)","v":"na"},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A22,HAATable[Column1],0),FALSE)","v":4.0899999999999999E-2},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A22,HAATable[Column1],0),FALSE)","v":6.4899999999999999E-2},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A22,HAATable[Column1],0),FALSE)","v":4.8099999999999997E-2},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A22,HAATable[Column1],0),FALSE)","v":4.6899999999999997E-2},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A22,HAATable[Column1],0),FALSE)","v":3.4000000000000002E-2}]
[null,{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A23,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A23,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A23,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A23,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A23,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A23,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A23,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A23,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A23,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A23,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A23,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A24,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A24,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A24,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A24,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A24,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A24,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A24,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A24,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A24,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A24,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A24,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A25,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A25,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A25,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A25,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A25,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A25,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A25,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A25,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A25,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A25,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A25,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A26,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A26,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A26,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A26,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A26,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A26,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A26,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A26,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A26,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A26,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A26,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A27,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A27,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A27,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A27,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A27,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A27,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A27,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A27,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A27,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A27,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A27,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A28,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A28,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A28,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A28,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A28,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A28,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A28,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A28,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A28,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A28,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A28,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},null,"Formulas for labeling max. LRAA sites on LT charts"]
[null,{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A29,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A29,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A29,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A29,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A29,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A29,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A29,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A29,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A29,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A29,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A29,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A30,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A30,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A30,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A30,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A30,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A30,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A30,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A30,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A30,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A30,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A30,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A31,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A31,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A31,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A31,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A31,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A31,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A31,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A31,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A31,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A31,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A31,HAATable[Column1],0),FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"IF(ISBLANK(A14),\"\",A14)","v":"11405 LARRY LAKE ROAD"},{"$f":"IF(ISBLANK(A14),\"\",\"LRAA\")","v":"LRAA"},null,null,{"$f":"IF(COUNT(B14:E14)<4,\"NA\",AVERAGE(B14:E14))","v":1.7302499999999998E-2},1.8329999999999999E-2,1.8742500000000002E-2,1.7967500000000001E-2,1.34425E-2,1.5617499999999999E-2,1.89E-2,2.035E-2,null,{"$f":"A32","v":"11405 LARRY LAKE ROAD"},{"$f":"IF($E$57=A32,A32,IF($F$57=A32,A32,IF($G$57=A32,A32,IF($H$57=A32,A32,IF($I$57=A32,A32,IF($J$57=A32,A32,IF($K$57=A32,A32,IF($L$57=A32,A32,\"\"))))))))","v":"11405 LARRY LAKE ROAD"}]
["13191 DEASON CAMP ROAD",{"$f":"IF(ISBLANK(A15),\"\",\"LRAA\")","v":"LRAA"},null,null,3.9225000000000003E-2,4.0899999999999999E-2,4.0875000000000002E-2,"NA","NA","NA","NA","NA",null,"13191 DEASON CAMP ROAD",""]
["13920 GRAND POINTE ROAD",{"$f":"IF(ISBLANK(A16),\"\",\"LRAA\")","v":"LRAA"},null,null,3.2024999999999998E-2,3.4775E-2,3.4074999999999994E-2,"NA","NA","NA","NA","NA",null,"13920 GRAND POINTE ROAD",""]
["3950 3RD STREET SOUTH","LRAA",null,null,3.3322499999999998E-2,4.1999999999999996E-2,4.2174999999999997E-2,"NA","NA","NA","NA","NA",null,"3950 3RD STREET SOUTH","3950 3RD STREET SOUTH"]
["6802 MCFARLAND BLVD","LRAA",null,null,4.0125000000000001E-2,4.2950000000000002E-2,4.2025E-2,"NA","NA","NA","NA","NA",null,"6802 MCFARLAND BLVD","6802 MCFARLAND BLVD"]
["#1 BOOTH ESTATES","LRAA",null,null,{"$f":"IF(COUNT(B19:E19)<4,\"NA\",AVERAGE(B19:E19))","v":"NA"},"NA","NA","NA","NA","NA",4.8325000000000007E-2,{"$f":"IF(COUNT(I19:L19)<4,\"NA\",AVERAGE(I19:L19))","v":4.8450000000000007E-2},null,"#1 BOOTH ESTATES",""]
["17689 PINE LAKE RD","LRAA",null,null,{"$f":"IF(COUNT(B20:E20)<4,\"NA\",AVERAGE(B20:E20))","v":"NA"},"NA","NA","NA","NA","NA",5.4275000000000004E-2,4.8675000000000003E-2,null,"17689 PINE LAKE RD",""]
["2920 39TH ST","LRAA",null,null,{"$f":"IF(COUNT(B21:E21)<4,\"NA\",AVERAGE(B21:E21))","v":"NA"},"NA","NA","NA","NA","NA",5.9250000000000004E-2,5.2999999999999999E-2,null,"2920 39TH ST","2920 39TH ST"]
["6425 5TH ST","LRAA",null,null,{"$f":"IF(COUNT(B22:E22)<4,\"NA\",AVERAGE(B22:E22))","v":"NA"},"NA","NA","NA","NA","NA",5.0200000000000002E-2,4.8474999999999997E-2]
["","",null,null,{"$f":"IF(COUNT(B23:E23)<4,\"NA\",AVERAGE(B23:E23))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA"]
["","",null,null,{"$f":"IF(COUNT(B24:E24)<4,\"NA\",AVERAGE(B24:E24))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA"]
["","",null,null,{"$f":"IF(COUNT(B25:E25)<4,\"NA\",AVERAGE(B25:E25))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"",{"$f":"IF($E$57=A43,A43,IF($F$57=A43,A43,IF($G$57=A43,A43,IF($H$57=A43,A43,IF($I$57=A43,A43,IF($J$57=A43,A43,IF($K$57=A43,A43,IF($L$57=A43,A43,\"\"))))))))","v":""}]
["","",null,null,{"$f":"IF(COUNT(B26:E26)<4,\"NA\",AVERAGE(B26:E26))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"",{"$f":"IF($E$57=A44,A44,IF($F$57=A44,A44,IF($G$57=A44,A44,IF($H$57=A44,A44,IF($I$57=A44,A44,IF($J$57=A44,A44,IF($K$57=A44,A44,IF($L$57=A44,A44,\"\"))))))))","v":""}]
["","",null,null,{"$f":"IF(COUNT(B27:E27)<4,\"NA\",AVERAGE(B27:E27))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"",{"$f":"IF($E$57=A45,A45,IF($F$57=A45,A45,IF($G$57=A45,A45,IF($H$57=A45,A45,IF($I$57=A45,A45,IF($J$57=A45,A45,IF($K$57=A45,A45,IF($L$57=A45,A45,\"\"))))))))","v":""}]
["","",null,null,{"$f":"IF(COUNT(B28:E28)<4,\"NA\",AVERAGE(B28:E28))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"",{"$f":"IF($E$57=A46,A46,IF($F$57=A46,A46,IF($G$57=A46,A46,IF($H$57=A46,A46,IF($I$57=A46,A46,IF($J$57=A46,A46,IF($K$57=A46,A46,IF($L$57=A46,A46,\"\"))))))))","v":""}]
["","",null,null,{"$f":"IF(COUNT(B29:E29)<4,\"NA\",AVERAGE(B29:E29))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA"]
[{"$f":"IF(ISBLANK(A30),\"\",A30)","v":""},"",null,null,{"$f":"IF(COUNT(B30:E30)<4,\"NA\",AVERAGE(B30:E30))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA"]
["",{"$f":"IF(ISBLANK(A31),\"\",\"LRAA\")","v":""},null,null,{"$f":"IF(COUNT(B31:E31)<4,\"NA\",AVERAGE(B31:E31))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA"]
["Max LRAA",null,null,null,{"$f":"IF(COUNT(E32:E49)=0,\"NA\",MAX(E32:E49))","v":4.0125000000000001E-2},{"$f":"IF(COUNT(F32:F49)=0,\"NA\",MAX(F32:F49))","v":4.2950000000000002E-2},4.2174999999999997E-2,1.7967500000000001E-2,1.34425E-2,{"$f":"IF(COUNT(J32:J49)=0,\"NA\",MAX(J32:J49))","v":1.5617499999999999E-2},5.9250000000000004E-2,5.2999999999999999E-2,null,null,{"$f":"CONCATENATE(O32,\"  \",O33,\"  \",O34,\"  \",O35,\"  \",O36,\"  \",O37,\"  \",O38,\"  \",O39,\"  \",O43,\"  \",O44,\"  \",O45,\"  \",O46)","v":"11405 LARRY LAKE ROAD      3950 3RD STREET SOUTH  6802 MCFARLAND BLVD      2920 39TH ST        "}]
["Avg of Max LRAAs",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(E50:L50)<8,\"NA\",AVERAGE(E50:L50))","v":3.5565937499999999E-2}]
[]
["Data for plotting"]
["Avg of Max LRAAs",null,null,null,{"$f":"$L$51","v":3.5565937499999999E-2},{"$f":"$L$51","v":3.5565937499999999E-2},3.5565937499999999E-2,3.5565937499999999E-2,3.5565937499999999E-2,3.5565937499999999E-2,3.5565937499999999E-2,{"$f":"L51","v":3.5565937499999999E-2}]
["Individual Site Goal",null,null,null,{"$f":"+$B$3","v":0.05},0.05,0.05,0.05,0.05,0.05,0.05,0.05]
["Long-Term System Goal",null,null,null,{"$f":"+$B$4","v":0.04},0.04,0.04,0.04,0.04,0.04,0.04,0.04]
[null,null,null,null,{"$f":"IF(SUM(E32:E46)=0,\"\",(VLOOKUP(MAX(E32:E46),$E$32:$N$46,10,FALSE)))","v":"6802 MCFARLAND BLVD"},{"$f":"IF(SUM(F32:F46)=0,\"\",(VLOOKUP(MAX(F32:F46),$F$32:$N$46,9,FALSE)))","v":"6802 MCFARLAND BLVD"},{"$f":"IF(SUM(G32:G46)=0,\"\",(VLOOKUP(MAX(G32:G46),$G$32:$N$46,8,FALSE)))","v":"3950 3RD STREET SOUTH"},{"$f":"IF(SUM(H32:H46)=0,\"\",(VLOOKUP(MAX(H32:H46),$H$32:$N$46,7,FALSE)))","v":"11405 LARRY LAKE ROAD"},{"$f":"IF(SUM(I32:I46)=0,\"\",(VLOOKUP(MAX(I32:I46),$I$32:$N$46,6,FALSE)))","v":"11405 LARRY LAKE ROAD"},{"$f":"IF(SUM(J32:J46)=0,\"\",(VLOOKUP(MAX(J32:J46),$J$32:$N$46,5,FALSE)))","v":"11405 LARRY LAKE ROAD"},{"$f":"IF(SUM(K32:K46)=0,\"\",(VLOOKUP(MAX(K32:K46),$K$32:$N$46,4,FALSE)))","v":"2920 39TH ST"},{"$f":"IF(SUM(L32:L46)=0,\"\",(VLOOKUP(MAX(L32:L46),$L$32:$N$46,3,FALSE)))","v":"2920 39TH ST"}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Sites Contributing to Maximum LRAA:"]
[null,null,null,null,null,null,null,null,{"$f":"O50","v":"11405 LARRY LAKE ROAD      3950 3RD STREET SOUTH  6802 MCFARLAND BLVD      2920 39TH ST        "}]

{"sheet":"OEL Calc","index":15,"n_rows":45,"n_cols":13,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Data Entry'!K1:K2","v":"Water System Name"}]
[]
[null,"TTHM OEL Table"]
[null,"Operational Evaluation Level (OEL)",8.0399999999999999E-2,"Colored cell indicates OEL was exceeded"]
[null,null,{"$f":"'TTHM Goals'!B13","v":"Q4 2016"},{"$f":"'TTHM Goals'!C13","v":"Q1 2017"},{"$f":"'TTHM Goals'!D13","v":"Q2 2017"},{"$f":"'TTHM Goals'!E13","v":"Q3 2017"},{"$f":"'TTHM Goals'!F13","v":"Q4 2017"},{"$f":"'TTHM Goals'!G13","v":"Q1 2018"},{"$f":"'TTHM Goals'!H13","v":"Q2 2018"},{"$f":"'TTHM Goals'!I13","v":"Q3 2018"},{"$f":"'TTHM Goals'!J13","v":"Q4 2018"},{"$f":"'TTHM Goals'!K13","v":"Q1 2019"},{"$f":"'TTHM Goals'!L13","v":"Q2 2019"}]
[null,{"$f":"IF(ISBLANK('TTHM Goals'!A14),\"\",'TTHM Goals'!A14)","v":"11405 LARRY LAKE ROAD"},null,null,{"$f":"IF(ISERROR(('TTHM Goals'!D14*2+SUM('TTHM Goals'!B14:C14))/4),\"\",(('TTHM Goals'!D14*2+SUM('TTHM Goals'!B14:C14))/4))","v":1.2557499999999999E-2},{"$f":"IF(ISERROR(('TTHM Goals'!E14*2+SUM('TTHM Goals'!C14:D14))/4),\"\",(('TTHM Goals'!E14*2+SUM('TTHM Goals'!C14:D14))/4))","v":1.9279999999999999E-2},{"$f":"IF(ISERROR(('TTHM Goals'!F14*2+SUM('TTHM Goals'!D14:E14))/4),\"\",(('TTHM Goals'!F14*2+SUM('TTHM Goals'!D14:E14))/4))","v":1.9075000000000002E-2},{"$f":"IF(ISERROR(('TTHM Goals'!G14*2+SUM('TTHM Goals'!E14:F14))/4),\"\",(('TTHM Goals'!G14*2+SUM('TTHM Goals'!E14:F14))/4))","v":1.4995E-2},{"$f":"IF(ISERROR(('TTHM Goals'!H14*2+SUM('TTHM Goals'!F14:G14))/4),\"\",(('TTHM Goals'!H14*2+SUM('TTHM Goals'!F14:G14))/4))","v":1.31725E-2},{"$f":"IF(ISERROR(('TTHM Goals'!I14*2+SUM('TTHM Goals'!G14:H14))/4),\"\",(('TTHM Goals'!I14*2+SUM('TTHM Goals'!G14:H14))/4))","v":1.1572499999999999E-2},{"$f":"IF(ISERROR(('TTHM Goals'!J14*2+SUM('TTHM Goals'!H14:I14))/4),\"\",(('TTHM Goals'!J14*2+SUM('TTHM Goals'!H14:I14))/4))","v":1.915E-2},{"$f":"IF(ISERROR(('TTHM Goals'!K14*2+SUM('TTHM Goals'!I14:J14))/4),\"\",(('TTHM Goals'!K14*2+SUM('TTHM Goals'!I14:J14))/4))","v":1.6649999999999998E-2},{"$f":"IF(ISERROR(('TTHM Goals'!L14*2+SUM('TTHM Goals'!J14:K14))/4),\"\",(('TTHM Goals'!L14*2+SUM('TTHM Goals'!J14:K14))/4))","v":1.8674999999999997E-2}]
[null,{"$f":"IF(ISBLANK('TTHM Goals'!A15),\"\",'TTHM Goals'!A15)","v":"13191 DEASON CAMP ROAD"},null,null,{"$f":"IF(ISERROR(('TTHM Goals'!D15*2+SUM('TTHM Goals'!B15:C15))/4),\"\",(('TTHM Goals'!D15*2+SUM('TTHM Goals'!B15:C15))/4))","v":3.9724999999999996E-2},{"$f":"IF(ISERROR(('TTHM Goals'!E15*2+SUM('TTHM Goals'!C15:D15))/4),\"\",(('TTHM Goals'!E15*2+SUM('TTHM Goals'!C15:D15))/4))","v":5.7075000000000001E-2},{"$f":"IF(ISERROR(('TTHM Goals'!F15*2+SUM('TTHM Goals'!D15:E15))/4),\"\",(('TTHM Goals'!F15*2+SUM('TTHM Goals'!D15:E15))/4))","v":6.6799999999999998E-2},{"$f":"IF(ISERROR(('TTHM Goals'!G15*2+SUM('TTHM Goals'!E15:F15))/4),\"\",(('TTHM Goals'!G15*2+SUM('TTHM Goals'!E15:F15))/4))","v":5.0774999999999994E-2},{"$f":"IF(ISERROR(('TTHM Goals'!H15*2+SUM('TTHM Goals'!F15:G15))/4),\"\",(('TTHM Goals'!H15*2+SUM('TTHM Goals'!F15:G15))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!I15*2+SUM('TTHM Goals'!G15:H15))/4),\"\",(('TTHM Goals'!I15*2+SUM('TTHM Goals'!G15:H15))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!J15*2+SUM('TTHM Goals'!H15:I15))/4),\"\",(('TTHM Goals'!J15*2+SUM('TTHM Goals'!H15:I15))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!K15*2+SUM('TTHM Goals'!I15:J15))/4),\"\",(('TTHM Goals'!K15*2+SUM('TTHM Goals'!I15:J15))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!L15*2+SUM('TTHM Goals'!J15:K15))/4),\"\",(('TTHM Goals'!L15*2+SUM('TTHM Goals'!J15:K15))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('TTHM Goals'!A16),\"\",'TTHM Goals'!A16)","v":"13920 GRAND POINTE ROAD"},null,null,{"$f":"IF(ISERROR(('TTHM Goals'!D16*2+SUM('TTHM Goals'!B16:C16))/4),\"\",(('TTHM Goals'!D16*2+SUM('TTHM Goals'!B16:C16))/4))","v":3.1350000000000003E-2},{"$f":"IF(ISERROR(('TTHM Goals'!E16*2+SUM('TTHM Goals'!C16:D16))/4),\"\",(('TTHM Goals'!E16*2+SUM('TTHM Goals'!C16:D16))/4))","v":0.04},{"$f":"IF(ISERROR(('TTHM Goals'!F16*2+SUM('TTHM Goals'!D16:E16))/4),\"\",(('TTHM Goals'!F16*2+SUM('TTHM Goals'!D16:E16))/4))","v":4.7774999999999998E-2},{"$f":"IF(ISERROR(('TTHM Goals'!G16*2+SUM('TTHM Goals'!E16:F16))/4),\"\",(('TTHM Goals'!G16*2+SUM('TTHM Goals'!E16:F16))/4))","v":3.4174999999999997E-2},{"$f":"IF(ISERROR(('TTHM Goals'!H16*2+SUM('TTHM Goals'!F16:G16))/4),\"\",(('TTHM Goals'!H16*2+SUM('TTHM Goals'!F16:G16))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!I16*2+SUM('TTHM Goals'!G16:H16))/4),\"\",(('TTHM Goals'!I16*2+SUM('TTHM Goals'!G16:H16))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!J16*2+SUM('TTHM Goals'!H16:I16))/4),\"\",(('TTHM Goals'!J16*2+SUM('TTHM Goals'!H16:I16))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!K16*2+SUM('TTHM Goals'!I16:J16))/4),\"\",(('TTHM Goals'!K16*2+SUM('TTHM Goals'!I16:J16))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!L16*2+SUM('TTHM Goals'!J16:K16))/4),\"\",(('TTHM Goals'!L16*2+SUM('TTHM Goals'!J16:K16))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('TTHM Goals'!A17),\"\",'TTHM Goals'!A17)","v":"3950 3RD STREET SOUTH"},null,null,{"$f":"IF(ISERROR(('TTHM Goals'!D17*2+SUM('TTHM Goals'!B17:C17))/4),\"\",(('TTHM Goals'!D17*2+SUM('TTHM Goals'!B17:C17))/4))","v":3.31025E-2},{"$f":"IF(ISERROR(('TTHM Goals'!E17*2+SUM('TTHM Goals'!C17:D17))/4),\"\",(('TTHM Goals'!E17*2+SUM('TTHM Goals'!C17:D17))/4))","v":5.9950000000000003E-2},{"$f":"IF(ISERROR(('TTHM Goals'!F17*2+SUM('TTHM Goals'!D17:E17))/4),\"\",(('TTHM Goals'!F17*2+SUM('TTHM Goals'!D17:E17))/4))","v":6.5199999999999994E-2},{"$f":"IF(ISERROR(('TTHM Goals'!G17*2+SUM('TTHM Goals'!E17:F17))/4),\"\",(('TTHM Goals'!G17*2+SUM('TTHM Goals'!E17:F17))/4))","v":5.1049999999999998E-2},{"$f":"IF(ISERROR(('TTHM Goals'!H17*2+SUM('TTHM Goals'!F17:G17))/4),\"\",(('TTHM Goals'!H17*2+SUM('TTHM Goals'!F17:G17))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!I17*2+SUM('TTHM Goals'!G17:H17))/4),\"\",(('TTHM Goals'!I17*2+SUM('TTHM Goals'!G17:H17))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!J17*2+SUM('TTHM Goals'!H17:I17))/4),\"\",(('TTHM Goals'!J17*2+SUM('TTHM Goals'!H17:I17))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!K17*2+SUM('TTHM Goals'!I17:J17))/4),\"\",(('TTHM Goals'!K17*2+SUM('TTHM Goals'!I17:J17))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!L17*2+SUM('TTHM Goals'!J17:K17))/4),\"\",(('TTHM Goals'!L17*2+SUM('TTHM Goals'!J17:K17))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('TTHM Goals'!A18),\"\",'TTHM Goals'!A18)","v":"6802 MCFARLAND BLVD"},null,null,{"$f":"IF(ISERROR(('TTHM Goals'!D18*2+SUM('TTHM Goals'!B18:C18))/4),\"\",(('TTHM Goals'!D18*2+SUM('TTHM Goals'!B18:C18))/4))","v":3.585E-2},{"$f":"IF(ISERROR(('TTHM Goals'!E18*2+SUM('TTHM Goals'!C18:D18))/4),\"\",(('TTHM Goals'!E18*2+SUM('TTHM Goals'!C18:D18))/4))","v":5.33E-2},{"$f":"IF(ISERROR(('TTHM Goals'!F18*2+SUM('TTHM Goals'!D18:E18))/4),\"\",(('TTHM Goals'!F18*2+SUM('TTHM Goals'!D18:E18))/4))","v":5.57E-2},{"$f":"IF(ISERROR(('TTHM Goals'!G18*2+SUM('TTHM Goals'!E18:F18))/4),\"\",(('TTHM Goals'!G18*2+SUM('TTHM Goals'!E18:F18))/4))","v":4.4800000000000006E-2},{"$f":"IF(ISERROR(('TTHM Goals'!H18*2+SUM('TTHM Goals'!F18:G18))/4),\"\",(('TTHM Goals'!H18*2+SUM('TTHM Goals'!F18:G18))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!I18*2+SUM('TTHM Goals'!G18:H18))/4),\"\",(('TTHM Goals'!I18*2+SUM('TTHM Goals'!G18:H18))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!J18*2+SUM('TTHM Goals'!H18:I18))/4),\"\",(('TTHM Goals'!J18*2+SUM('TTHM Goals'!H18:I18))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!K18*2+SUM('TTHM Goals'!I18:J18))/4),\"\",(('TTHM Goals'!K18*2+SUM('TTHM Goals'!I18:J18))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!L18*2+SUM('TTHM Goals'!J18:K18))/4),\"\",(('TTHM Goals'!L18*2+SUM('TTHM Goals'!J18:K18))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('TTHM Goals'!A19),\"\",'TTHM Goals'!A19)","v":"#1 BOOTH ESTATES"},null,null,{"$f":"IF(ISERROR(('TTHM Goals'!D19*2+SUM('TTHM Goals'!B19:C19))/4),\"\",(('TTHM Goals'!D19*2+SUM('TTHM Goals'!B19:C19))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!E19*2+SUM('TTHM Goals'!C19:D19))/4),\"\",(('TTHM Goals'!E19*2+SUM('TTHM Goals'!C19:D19))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!F19*2+SUM('TTHM Goals'!D19:E19))/4),\"\",(('TTHM Goals'!F19*2+SUM('TTHM Goals'!D19:E19))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!G19*2+SUM('TTHM Goals'!E19:F19))/4),\"\",(('TTHM Goals'!G19*2+SUM('TTHM Goals'!E19:F19))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!H19*2+SUM('TTHM Goals'!F19:G19))/4),\"\",(('TTHM Goals'!H19*2+SUM('TTHM Goals'!F19:G19))/4))","v":2.1299999999999999E-2},{"$f":"IF(ISERROR(('TTHM Goals'!I19*2+SUM('TTHM Goals'!G19:H19))/4),\"\",(('TTHM Goals'!I19*2+SUM('TTHM Goals'!G19:H19))/4))","v":5.2199999999999996E-2},{"$f":"IF(ISERROR(('TTHM Goals'!J19*2+SUM('TTHM Goals'!H19:I19))/4),\"\",(('TTHM Goals'!J19*2+SUM('TTHM Goals'!H19:I19))/4))","v":6.1924999999999994E-2},{"$f":"IF(ISERROR(('TTHM Goals'!K19*2+SUM('TTHM Goals'!I19:J19))/4),\"\",(('TTHM Goals'!K19*2+SUM('TTHM Goals'!I19:J19))/4))","v":5.5675000000000002E-2},{"$f":"IF(ISERROR(('TTHM Goals'!L19*2+SUM('TTHM Goals'!J19:K19))/4),\"\",(('TTHM Goals'!L19*2+SUM('TTHM Goals'!J19:K19))/4))","v":3.9974999999999997E-2}]
[null,{"$f":"IF(ISBLANK('TTHM Goals'!A20),\"\",'TTHM Goals'!A20)","v":"17689 PINE LAKE RD"},null,null,{"$f":"IF(ISERROR(('TTHM Goals'!D20*2+SUM('TTHM Goals'!B20:C20))/4),\"\",(('TTHM Goals'!D20*2+SUM('TTHM Goals'!B20:C20))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!E20*2+SUM('TTHM Goals'!C20:D20))/4),\"\",(('TTHM Goals'!E20*2+SUM('TTHM Goals'!C20:D20))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!F20*2+SUM('TTHM Goals'!D20:E20))/4),\"\",(('TTHM Goals'!F20*2+SUM('TTHM Goals'!D20:E20))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!G20*2+SUM('TTHM Goals'!E20:F20))/4),\"\",(('TTHM Goals'!G20*2+SUM('TTHM Goals'!E20:F20))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!H20*2+SUM('TTHM Goals'!F20:G20))/4),\"\",(('TTHM Goals'!H20*2+SUM('TTHM Goals'!F20:G20))/4))","v":2.6599999999999999E-2},{"$f":"IF(ISERROR(('TTHM Goals'!I20*2+SUM('TTHM Goals'!G20:H20))/4),\"\",(('TTHM Goals'!I20*2+SUM('TTHM Goals'!G20:H20))/4))","v":5.2900000000000003E-2},{"$f":"IF(ISERROR(('TTHM Goals'!J20*2+SUM('TTHM Goals'!H20:I20))/4),\"\",(('TTHM Goals'!J20*2+SUM('TTHM Goals'!H20:I20))/4))","v":6.4500000000000002E-2},{"$f":"IF(ISERROR(('TTHM Goals'!K20*2+SUM('TTHM Goals'!I20:J20))/4),\"\",(('TTHM Goals'!K20*2+SUM('TTHM Goals'!I20:J20))/4))","v":5.3100000000000008E-2},{"$f":"IF(ISERROR(('TTHM Goals'!L20*2+SUM('TTHM Goals'!J20:K20))/4),\"\",(('TTHM Goals'!L20*2+SUM('TTHM Goals'!J20:K20))/4))","v":4.0300000000000002E-2}]
[null,{"$f":"IF(ISBLANK('TTHM Goals'!A21),\"\",'TTHM Goals'!A21)","v":"2920 39TH ST"},null,null,{"$f":"IF(ISERROR(('TTHM Goals'!D21*2+SUM('TTHM Goals'!B21:C21))/4),\"\",(('TTHM Goals'!D21*2+SUM('TTHM Goals'!B21:C21))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!E21*2+SUM('TTHM Goals'!C21:D21))/4),\"\",(('TTHM Goals'!E21*2+SUM('TTHM Goals'!C21:D21))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!F21*2+SUM('TTHM Goals'!D21:E21))/4),\"\",(('TTHM Goals'!F21*2+SUM('TTHM Goals'!D21:E21))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!G21*2+SUM('TTHM Goals'!E21:F21))/4),\"\",(('TTHM Goals'!G21*2+SUM('TTHM Goals'!E21:F21))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!H21*2+SUM('TTHM Goals'!F21:G21))/4),\"\",(('TTHM Goals'!H21*2+SUM('TTHM Goals'!F21:G21))/4))","v":3.015E-2},{"$f":"IF(ISERROR(('TTHM Goals'!I21*2+SUM('TTHM Goals'!G21:H21))/4),\"\",(('TTHM Goals'!I21*2+SUM('TTHM Goals'!G21:H21))/4))","v":3.0025E-2},{"$f":"IF(ISERROR(('TTHM Goals'!J21*2+SUM('TTHM Goals'!H21:I21))/4),\"\",(('TTHM Goals'!J21*2+SUM('TTHM Goals'!H21:I21))/4))","v":7.5649999999999995E-2},{"$f":"IF(ISERROR(('TTHM Goals'!K21*2+SUM('TTHM Goals'!I21:J21))/4),\"\",(('TTHM Goals'!K21*2+SUM('TTHM Goals'!I21:J21))/4))","v":4.9825000000000001E-2},{"$f":"IF(ISERROR(('TTHM Goals'!L21*2+SUM('TTHM Goals'!J21:K21))/4),\"\",(('TTHM Goals'!L21*2+SUM('TTHM Goals'!J21:K21))/4))","v":4.9250000000000002E-2}]
[null,{"$f":"IF(ISBLANK('TTHM Goals'!A22),\"\",'TTHM Goals'!A22)","v":"6425 5TH ST"},null,null,{"$f":"IF(ISERROR(('TTHM Goals'!D22*2+SUM('TTHM Goals'!B22:C22))/4),\"\",(('TTHM Goals'!D22*2+SUM('TTHM Goals'!B22:C22))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!E22*2+SUM('TTHM Goals'!C22:D22))/4),\"\",(('TTHM Goals'!E22*2+SUM('TTHM Goals'!C22:D22))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!F22*2+SUM('TTHM Goals'!D22:E22))/4),\"\",(('TTHM Goals'!F22*2+SUM('TTHM Goals'!D22:E22))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!G22*2+SUM('TTHM Goals'!E22:F22))/4),\"\",(('TTHM Goals'!G22*2+SUM('TTHM Goals'!E22:F22))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!H22*2+SUM('TTHM Goals'!F22:G22))/4),\"\",(('TTHM Goals'!H22*2+SUM('TTHM Goals'!F22:G22))/4))","v":2.4649999999999998E-2},{"$f":"IF(ISERROR(('TTHM Goals'!I22*2+SUM('TTHM Goals'!G22:H22))/4),\"\",(('TTHM Goals'!I22*2+SUM('TTHM Goals'!G22:H22))/4))","v":6.1024999999999996E-2},{"$f":"IF(ISERROR(('TTHM Goals'!J22*2+SUM('TTHM Goals'!H22:I22))/4),\"\",(('TTHM Goals'!J22*2+SUM('TTHM Goals'!H22:I22))/4))","v":7.1624999999999994E-2},{"$f":"IF(ISERROR(('TTHM Goals'!K22*2+SUM('TTHM Goals'!I22:J22))/4),\"\",(('TTHM Goals'!K22*2+SUM('TTHM Goals'!I22:J22))/4))","v":5.9374999999999997E-2},{"$f":"IF(ISERROR(('TTHM Goals'!L22*2+SUM('TTHM Goals'!J22:K22))/4),\"\",(('TTHM Goals'!L22*2+SUM('TTHM Goals'!J22:K22))/4))","v":4.2150000000000007E-2}]
[null,{"$f":"IF(ISBLANK('TTHM Goals'!A23),\"\",'TTHM Goals'!A23)","v":""},null,null,{"$f":"IF(ISERROR(('TTHM Goals'!D23*2+SUM('TTHM Goals'!B23:C23))/4),\"\",(('TTHM Goals'!D23*2+SUM('TTHM Goals'!B23:C23))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!E23*2+SUM('TTHM Goals'!C23:D23))/4),\"\",(('TTHM Goals'!E23*2+SUM('TTHM Goals'!C23:D23))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!F23*2+SUM('TTHM Goals'!D23:E23))/4),\"\",(('TTHM Goals'!F23*2+SUM('TTHM Goals'!D23:E23))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!G23*2+SUM('TTHM Goals'!E23:F23))/4),\"\",(('TTHM Goals'!G23*2+SUM('TTHM Goals'!E23:F23))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!H23*2+SUM('TTHM Goals'!F23:G23))/4),\"\",(('TTHM Goals'!H23*2+SUM('TTHM Goals'!F23:G23))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!I23*2+SUM('TTHM Goals'!G23:H23))/4),\"\",(('TTHM Goals'!I23*2+SUM('TTHM Goals'!G23:H23))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!J23*2+SUM('TTHM Goals'!H23:I23))/4),\"\",(('TTHM Goals'!J23*2+SUM('TTHM Goals'!H23:I23))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!K23*2+SUM('TTHM Goals'!I23:J23))/4),\"\",(('TTHM Goals'!K23*2+SUM('TTHM Goals'!I23:J23))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!L23*2+SUM('TTHM Goals'!J23:K23))/4),\"\",(('TTHM Goals'!L23*2+SUM('TTHM Goals'!J23:K23))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('TTHM Goals'!A24),\"\",'TTHM Goals'!A24)","v":""},null,null,{"$f":"IF(ISERROR(('TTHM Goals'!D24*2+SUM('TTHM Goals'!B24:C24))/4),\"\",(('TTHM Goals'!D24*2+SUM('TTHM Goals'!B24:C24))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!E24*2+SUM('TTHM Goals'!C24:D24))/4),\"\",(('TTHM Goals'!E24*2+SUM('TTHM Goals'!C24:D24))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!F24*2+SUM('TTHM Goals'!D24:E24))/4),\"\",(('TTHM Goals'!F24*2+SUM('TTHM Goals'!D24:E24))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!G24*2+SUM('TTHM Goals'!E24:F24))/4),\"\",(('TTHM Goals'!G24*2+SUM('TTHM Goals'!E24:F24))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!H24*2+SUM('TTHM Goals'!F24:G24))/4),\"\",(('TTHM Goals'!H24*2+SUM('TTHM Goals'!F24:G24))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!I24*2+SUM('TTHM Goals'!G24:H24))/4),\"\",(('TTHM Goals'!I24*2+SUM('TTHM Goals'!G24:H24))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!J24*2+SUM('TTHM Goals'!H24:I24))/4),\"\",(('TTHM Goals'!J24*2+SUM('TTHM Goals'!H24:I24))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!K24*2+SUM('TTHM Goals'!I24:J24))/4),\"\",(('TTHM Goals'!K24*2+SUM('TTHM Goals'!I24:J24))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!L24*2+SUM('TTHM Goals'!J24:K24))/4),\"\",(('TTHM Goals'!L24*2+SUM('TTHM Goals'!J24:K24))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('TTHM Goals'!A25),\"\",'TTHM Goals'!A25)","v":""},null,null,{"$f":"IF(ISERROR(('TTHM Goals'!D25*2+SUM('TTHM Goals'!B25:C25))/4),\"\",(('TTHM Goals'!D25*2+SUM('TTHM Goals'!B25:C25))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!E25*2+SUM('TTHM Goals'!C25:D25))/4),\"\",(('TTHM Goals'!E25*2+SUM('TTHM Goals'!C25:D25))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!F25*2+SUM('TTHM Goals'!D25:E25))/4),\"\",(('TTHM Goals'!F25*2+SUM('TTHM Goals'!D25:E25))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!G25*2+SUM('TTHM Goals'!E25:F25))/4),\"\",(('TTHM Goals'!G25*2+SUM('TTHM Goals'!E25:F25))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!H25*2+SUM('TTHM Goals'!F25:G25))/4),\"\",(('TTHM Goals'!H25*2+SUM('TTHM Goals'!F25:G25))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!I25*2+SUM('TTHM Goals'!G25:H25))/4),\"\",(('TTHM Goals'!I25*2+SUM('TTHM Goals'!G25:H25))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!J25*2+SUM('TTHM Goals'!H25:I25))/4),\"\",(('TTHM Goals'!J25*2+SUM('TTHM Goals'!H25:I25))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!K25*2+SUM('TTHM Goals'!I25:J25))/4),\"\",(('TTHM Goals'!K25*2+SUM('TTHM Goals'!I25:J25))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!L25*2+SUM('TTHM Goals'!J25:K25))/4),\"\",(('TTHM Goals'!L25*2+SUM('TTHM Goals'!J25:K25))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('TTHM Goals'!A26),\"\",'TTHM Goals'!A26)","v":""},null,null,{"$f":"IF(ISERROR(('TTHM Goals'!D26*2+SUM('TTHM Goals'!B26:C26))/4),\"\",(('TTHM Goals'!D26*2+SUM('TTHM Goals'!B26:C26))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!E26*2+SUM('TTHM Goals'!C26:D26))/4),\"\",(('TTHM Goals'!E26*2+SUM('TTHM Goals'!C26:D26))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!F26*2+SUM('TTHM Goals'!D26:E26))/4),\"\",(('TTHM Goals'!F26*2+SUM('TTHM Goals'!D26:E26))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!G26*2+SUM('TTHM Goals'!E26:F26))/4),\"\",(('TTHM Goals'!G26*2+SUM('TTHM Goals'!E26:F26))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!H26*2+SUM('TTHM Goals'!F26:G26))/4),\"\",(('TTHM Goals'!H26*2+SUM('TTHM Goals'!F26:G26))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!I26*2+SUM('TTHM Goals'!G26:H26))/4),\"\",(('TTHM Goals'!I26*2+SUM('TTHM Goals'!G26:H26))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!J26*2+SUM('TTHM Goals'!H26:I26))/4),\"\",(('TTHM Goals'!J26*2+SUM('TTHM Goals'!H26:I26))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!K26*2+SUM('TTHM Goals'!I26:J26))/4),\"\",(('TTHM Goals'!K26*2+SUM('TTHM Goals'!I26:J26))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!L26*2+SUM('TTHM Goals'!J26:K26))/4),\"\",(('TTHM Goals'!L26*2+SUM('TTHM Goals'!J26:K26))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('TTHM Goals'!A27),\"\",'TTHM Goals'!A27)","v":""},null,null,{"$f":"IF(ISERROR(('TTHM Goals'!D27*2+SUM('TTHM Goals'!B27:C27))/4),\"\",(('TTHM Goals'!D27*2+SUM('TTHM Goals'!B27:C27))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!E27*2+SUM('TTHM Goals'!C27:D27))/4),\"\",(('TTHM Goals'!E27*2+SUM('TTHM Goals'!C27:D27))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!F27*2+SUM('TTHM Goals'!D27:E27))/4),\"\",(('TTHM Goals'!F27*2+SUM('TTHM Goals'!D27:E27))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!G27*2+SUM('TTHM Goals'!E27:F27))/4),\"\",(('TTHM Goals'!G27*2+SUM('TTHM Goals'!E27:F27))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!H27*2+SUM('TTHM Goals'!F27:G27))/4),\"\",(('TTHM Goals'!H27*2+SUM('TTHM Goals'!F27:G27))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!I27*2+SUM('TTHM Goals'!G27:H27))/4),\"\",(('TTHM Goals'!I27*2+SUM('TTHM Goals'!G27:H27))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!J27*2+SUM('TTHM Goals'!H27:I27))/4),\"\",(('TTHM Goals'!J27*2+SUM('TTHM Goals'!H27:I27))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!K27*2+SUM('TTHM Goals'!I27:J27))/4),\"\",(('TTHM Goals'!K27*2+SUM('TTHM Goals'!I27:J27))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!L27*2+SUM('TTHM Goals'!J27:K27))/4),\"\",(('TTHM Goals'!L27*2+SUM('TTHM Goals'!J27:K27))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('TTHM Goals'!A28),\"\",'TTHM Goals'!A28)","v":""},null,null,{"$f":"IF(ISERROR(('TTHM Goals'!D28*2+SUM('TTHM Goals'!B28:C28))/4),\"\",(('TTHM Goals'!D28*2+SUM('TTHM Goals'!B28:C28))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!E28*2+SUM('TTHM Goals'!C28:D28))/4),\"\",(('TTHM Goals'!E28*2+SUM('TTHM Goals'!C28:D28))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!F28*2+SUM('TTHM Goals'!D28:E28))/4),\"\",(('TTHM Goals'!F28*2+SUM('TTHM Goals'!D28:E28))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!G28*2+SUM('TTHM Goals'!E28:F28))/4),\"\",(('TTHM Goals'!G28*2+SUM('TTHM Goals'!E28:F28))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!H28*2+SUM('TTHM Goals'!F28:G28))/4),\"\",(('TTHM Goals'!H28*2+SUM('TTHM Goals'!F28:G28))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!I28*2+SUM('TTHM Goals'!G28:H28))/4),\"\",(('TTHM Goals'!I28*2+SUM('TTHM Goals'!G28:H28))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!J28*2+SUM('TTHM Goals'!H28:I28))/4),\"\",(('TTHM Goals'!J28*2+SUM('TTHM Goals'!H28:I28))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!K28*2+SUM('TTHM Goals'!I28:J28))/4),\"\",(('TTHM Goals'!K28*2+SUM('TTHM Goals'!I28:J28))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!L28*2+SUM('TTHM Goals'!J28:K28))/4),\"\",(('TTHM Goals'!L28*2+SUM('TTHM Goals'!J28:K28))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('TTHM Goals'!A29),\"\",'TTHM Goals'!A29)","v":""},null,null,{"$f":"IF(ISERROR(('TTHM Goals'!D29*2+SUM('TTHM Goals'!B29:C29))/4),\"\",(('TTHM Goals'!D29*2+SUM('TTHM Goals'!B29:C29))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!E29*2+SUM('TTHM Goals'!C29:D29))/4),\"\",(('TTHM Goals'!E29*2+SUM('TTHM Goals'!C29:D29))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!F29*2+SUM('TTHM Goals'!D29:E29))/4),\"\",(('TTHM Goals'!F29*2+SUM('TTHM Goals'!D29:E29))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!G29*2+SUM('TTHM Goals'!E29:F29))/4),\"\",(('TTHM Goals'!G29*2+SUM('TTHM Goals'!E29:F29))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!H29*2+SUM('TTHM Goals'!F29:G29))/4),\"\",(('TTHM Goals'!H29*2+SUM('TTHM Goals'!F29:G29))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!I29*2+SUM('TTHM Goals'!G29:H29))/4),\"\",(('TTHM Goals'!I29*2+SUM('TTHM Goals'!G29:H29))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!J29*2+SUM('TTHM Goals'!H29:I29))/4),\"\",(('TTHM Goals'!J29*2+SUM('TTHM Goals'!H29:I29))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!K29*2+SUM('TTHM Goals'!I29:J29))/4),\"\",(('TTHM Goals'!K29*2+SUM('TTHM Goals'!I29:J29))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!L29*2+SUM('TTHM Goals'!J29:K29))/4),\"\",(('TTHM Goals'!L29*2+SUM('TTHM Goals'!J29:K29))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('TTHM Goals'!A30),\"\",'TTHM Goals'!A30)","v":""},null,null,{"$f":"IF(ISERROR(('TTHM Goals'!D30*2+SUM('TTHM Goals'!B30:C30))/4),\"\",(('TTHM Goals'!D30*2+SUM('TTHM Goals'!B30:C30))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!E30*2+SUM('TTHM Goals'!C30:D30))/4),\"\",(('TTHM Goals'!E30*2+SUM('TTHM Goals'!C30:D30))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!F30*2+SUM('TTHM Goals'!D30:E30))/4),\"\",(('TTHM Goals'!F30*2+SUM('TTHM Goals'!D30:E30))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!G30*2+SUM('TTHM Goals'!E30:F30))/4),\"\",(('TTHM Goals'!G30*2+SUM('TTHM Goals'!E30:F30))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!H30*2+SUM('TTHM Goals'!F30:G30))/4),\"\",(('TTHM Goals'!H30*2+SUM('TTHM Goals'!F30:G30))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!I30*2+SUM('TTHM Goals'!G30:H30))/4),\"\",(('TTHM Goals'!I30*2+SUM('TTHM Goals'!G30:H30))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!J30*2+SUM('TTHM Goals'!H30:I30))/4),\"\",(('TTHM Goals'!J30*2+SUM('TTHM Goals'!H30:I30))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!K30*2+SUM('TTHM Goals'!I30:J30))/4),\"\",(('TTHM Goals'!K30*2+SUM('TTHM Goals'!I30:J30))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!L30*2+SUM('TTHM Goals'!J30:K30))/4),\"\",(('TTHM Goals'!L30*2+SUM('TTHM Goals'!J30:K30))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('TTHM Goals'!A31),\"\",'TTHM Goals'!A31)","v":""},null,null,{"$f":"IF(ISERROR(('TTHM Goals'!D31*2+SUM('TTHM Goals'!B31:C31))/4),\"\",(('TTHM Goals'!D31*2+SUM('TTHM Goals'!B31:C31))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!E31*2+SUM('TTHM Goals'!C31:D31))/4),\"\",(('TTHM Goals'!E31*2+SUM('TTHM Goals'!C31:D31))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!F31*2+SUM('TTHM Goals'!D31:E31))/4),\"\",(('TTHM Goals'!F31*2+SUM('TTHM Goals'!D31:E31))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!G31*2+SUM('TTHM Goals'!E31:F31))/4),\"\",(('TTHM Goals'!G31*2+SUM('TTHM Goals'!E31:F31))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!H31*2+SUM('TTHM Goals'!F31:G31))/4),\"\",(('TTHM Goals'!H31*2+SUM('TTHM Goals'!F31:G31))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!I31*2+SUM('TTHM Goals'!G31:H31))/4),\"\",(('TTHM Goals'!I31*2+SUM('TTHM Goals'!G31:H31))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!J31*2+SUM('TTHM Goals'!H31:I31))/4),\"\",(('TTHM Goals'!J31*2+SUM('TTHM Goals'!H31:I31))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!K31*2+SUM('TTHM Goals'!I31:J31))/4),\"\",(('TTHM Goals'!K31*2+SUM('TTHM Goals'!I31:J31))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!L31*2+SUM('TTHM Goals'!J31:K31))/4),\"\",(('TTHM Goals'!L31*2+SUM('TTHM Goals'!J31:K31))/4))","v":""}]
[]
[null,"HAA5 OEL Table"]
[null,"Operational Evaluation Level (OEL)",6.0400000000000002E-2,"Colored cell indicates OEL was exceeded"]
[null,null,{"$f":"'HAA5 Goals'!B13","v":"Q4 2016"},{"$f":"'HAA5 Goals'!C13","v":"Q1 2017"},{"$f":"'HAA5 Goals'!D13","v":"Q2 2017"},{"$f":"'HAA5 Goals'!E13","v":"Q3 2017"},{"$f":"'HAA5 Goals'!F13","v":"Q4 2017"},{"$f":"'HAA5 Goals'!G13","v":"Q1 2018"},{"$f":"'HAA5 Goals'!H13","v":"Q2 2018"},{"$f":"'HAA5 Goals'!I13","v":"Q3 2018"},{"$f":"'HAA5 Goals'!J13","v":"Q4 2018"},{"$f":"'HAA5 Goals'!K13","v":"Q1 2019"},{"$f":"'HAA5 Goals'!L13","v":"Q2 2019"}]
[null,{"$f":"IF(ISBLANK('HAA5 Goals'!A14),\"\",'HAA5 Goals'!A14)","v":"11405 LARRY LAKE ROAD"},null,null,{"$f":"IF(ISERROR(('HAA5 Goals'!D14*2+SUM('HAA5 Goals'!B14:C14))/4),\"\",(('HAA5 Goals'!D14*2+SUM('HAA5 Goals'!B14:C14))/4))","v":1.3927500000000001E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!E14*2+SUM('HAA5 Goals'!C14:D14))/4),\"\",(('HAA5 Goals'!E14*2+SUM('HAA5 Goals'!C14:D14))/4))","v":2.3080000000000003E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!F14*2+SUM('HAA5 Goals'!D14:E14))/4),\"\",(('HAA5 Goals'!F14*2+SUM('HAA5 Goals'!D14:E14))/4))","v":1.9925000000000002E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!G14*2+SUM('HAA5 Goals'!E14:F14))/4),\"\",(('HAA5 Goals'!G14*2+SUM('HAA5 Goals'!E14:F14))/4))","v":1.6185000000000001E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!H14*2+SUM('HAA5 Goals'!F14:G14))/4),\"\",(('HAA5 Goals'!H14*2+SUM('HAA5 Goals'!F14:G14))/4))","v":1.38175E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!I14*2+SUM('HAA5 Goals'!G14:H14))/4),\"\",(('HAA5 Goals'!I14*2+SUM('HAA5 Goals'!G14:H14))/4))","v":1.3667499999999999E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!J14*2+SUM('HAA5 Goals'!H14:I14))/4),\"\",(('HAA5 Goals'!J14*2+SUM('HAA5 Goals'!H14:I14))/4))","v":1.8974999999999999E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!K14*2+SUM('HAA5 Goals'!I14:J14))/4),\"\",(('HAA5 Goals'!K14*2+SUM('HAA5 Goals'!I14:J14))/4))","v":2.0400000000000001E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!L14*2+SUM('HAA5 Goals'!J14:K14))/4),\"\",(('HAA5 Goals'!L14*2+SUM('HAA5 Goals'!J14:K14))/4))","v":2.2175E-2}]
[null,{"$f":"IF(ISBLANK('HAA5 Goals'!A15),\"\",'HAA5 Goals'!A15)","v":"13191 DEASON CAMP ROAD"},null,null,{"$f":"IF(ISERROR(('HAA5 Goals'!D15*2+SUM('HAA5 Goals'!B15:C15))/4),\"\",(('HAA5 Goals'!D15*2+SUM('HAA5 Goals'!B15:C15))/4))","v":3.3350000000000005E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!E15*2+SUM('HAA5 Goals'!C15:D15))/4),\"\",(('HAA5 Goals'!E15*2+SUM('HAA5 Goals'!C15:D15))/4))","v":4.5149999999999996E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!F15*2+SUM('HAA5 Goals'!D15:E15))/4),\"\",(('HAA5 Goals'!F15*2+SUM('HAA5 Goals'!D15:E15))/4))","v":4.6924999999999994E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!G15*2+SUM('HAA5 Goals'!E15:F15))/4),\"\",(('HAA5 Goals'!G15*2+SUM('HAA5 Goals'!E15:F15))/4))","v":3.6449999999999996E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!H15*2+SUM('HAA5 Goals'!F15:G15))/4),\"\",(('HAA5 Goals'!H15*2+SUM('HAA5 Goals'!F15:G15))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!I15*2+SUM('HAA5 Goals'!G15:H15))/4),\"\",(('HAA5 Goals'!I15*2+SUM('HAA5 Goals'!G15:H15))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!J15*2+SUM('HAA5 Goals'!H15:I15))/4),\"\",(('HAA5 Goals'!J15*2+SUM('HAA5 Goals'!H15:I15))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!K15*2+SUM('HAA5 Goals'!I15:J15))/4),\"\",(('HAA5 Goals'!K15*2+SUM('HAA5 Goals'!I15:J15))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!L15*2+SUM('HAA5 Goals'!J15:K15))/4),\"\",(('HAA5 Goals'!L15*2+SUM('HAA5 Goals'!J15:K15))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('HAA5 Goals'!A16),\"\",'HAA5 Goals'!A16)","v":"13920 GRAND POINTE ROAD"},null,null,{"$f":"IF(ISERROR(('HAA5 Goals'!D16*2+SUM('HAA5 Goals'!B16:C16))/4),\"\",(('HAA5 Goals'!D16*2+SUM('HAA5 Goals'!B16:C16))/4))","v":2.8850000000000001E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!E16*2+SUM('HAA5 Goals'!C16:D16))/4),\"\",(('HAA5 Goals'!E16*2+SUM('HAA5 Goals'!C16:D16))/4))","v":3.7100000000000001E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!F16*2+SUM('HAA5 Goals'!D16:E16))/4),\"\",(('HAA5 Goals'!F16*2+SUM('HAA5 Goals'!D16:E16))/4))","v":3.9874999999999994E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!G16*2+SUM('HAA5 Goals'!E16:F16))/4),\"\",(('HAA5 Goals'!G16*2+SUM('HAA5 Goals'!E16:F16))/4))","v":2.9124999999999998E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!H16*2+SUM('HAA5 Goals'!F16:G16))/4),\"\",(('HAA5 Goals'!H16*2+SUM('HAA5 Goals'!F16:G16))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!I16*2+SUM('HAA5 Goals'!G16:H16))/4),\"\",(('HAA5 Goals'!I16*2+SUM('HAA5 Goals'!G16:H16))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!J16*2+SUM('HAA5 Goals'!H16:I16))/4),\"\",(('HAA5 Goals'!J16*2+SUM('HAA5 Goals'!H16:I16))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!K16*2+SUM('HAA5 Goals'!I16:J16))/4),\"\",(('HAA5 Goals'!K16*2+SUM('HAA5 Goals'!I16:J16))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!L16*2+SUM('HAA5 Goals'!J16:K16))/4),\"\",(('HAA5 Goals'!L16*2+SUM('HAA5 Goals'!J16:K16))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('HAA5 Goals'!A17),\"\",'HAA5 Goals'!A17)","v":"3950 3RD STREET SOUTH"},null,null,{"$f":"IF(ISERROR(('HAA5 Goals'!D17*2+SUM('HAA5 Goals'!B17:C17))/4),\"\",(('HAA5 Goals'!D17*2+SUM('HAA5 Goals'!B17:C17))/4))","v":2.8772499999999999E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!E17*2+SUM('HAA5 Goals'!C17:D17))/4),\"\",(('HAA5 Goals'!E17*2+SUM('HAA5 Goals'!C17:D17))/4))","v":4.6324999999999998E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!F17*2+SUM('HAA5 Goals'!D17:E17))/4),\"\",(('HAA5 Goals'!F17*2+SUM('HAA5 Goals'!D17:E17))/4))","v":4.8500000000000001E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!G17*2+SUM('HAA5 Goals'!E17:F17))/4),\"\",(('HAA5 Goals'!G17*2+SUM('HAA5 Goals'!E17:F17))/4))","v":3.6074999999999996E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!H17*2+SUM('HAA5 Goals'!F17:G17))/4),\"\",(('HAA5 Goals'!H17*2+SUM('HAA5 Goals'!F17:G17))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!I17*2+SUM('HAA5 Goals'!G17:H17))/4),\"\",(('HAA5 Goals'!I17*2+SUM('HAA5 Goals'!G17:H17))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!J17*2+SUM('HAA5 Goals'!H17:I17))/4),\"\",(('HAA5 Goals'!J17*2+SUM('HAA5 Goals'!H17:I17))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!K17*2+SUM('HAA5 Goals'!I17:J17))/4),\"\",(('HAA5 Goals'!K17*2+SUM('HAA5 Goals'!I17:J17))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!L17*2+SUM('HAA5 Goals'!J17:K17))/4),\"\",(('HAA5 Goals'!L17*2+SUM('HAA5 Goals'!J17:K17))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('HAA5 Goals'!A18),\"\",'HAA5 Goals'!A18)","v":"6802 MCFARLAND BLVD"},null,null,{"$f":"IF(ISERROR(('HAA5 Goals'!D18*2+SUM('HAA5 Goals'!B18:C18))/4),\"\",(('HAA5 Goals'!D18*2+SUM('HAA5 Goals'!B18:C18))/4))","v":3.5224999999999999E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!E18*2+SUM('HAA5 Goals'!C18:D18))/4),\"\",(('HAA5 Goals'!E18*2+SUM('HAA5 Goals'!C18:D18))/4))","v":4.6175000000000001E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!F18*2+SUM('HAA5 Goals'!D18:E18))/4),\"\",(('HAA5 Goals'!F18*2+SUM('HAA5 Goals'!D18:E18))/4))","v":4.9450000000000001E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!G18*2+SUM('HAA5 Goals'!E18:F18))/4),\"\",(('HAA5 Goals'!G18*2+SUM('HAA5 Goals'!E18:F18))/4))","v":3.6275000000000002E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!H18*2+SUM('HAA5 Goals'!F18:G18))/4),\"\",(('HAA5 Goals'!H18*2+SUM('HAA5 Goals'!F18:G18))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!I18*2+SUM('HAA5 Goals'!G18:H18))/4),\"\",(('HAA5 Goals'!I18*2+SUM('HAA5 Goals'!G18:H18))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!J18*2+SUM('HAA5 Goals'!H18:I18))/4),\"\",(('HAA5 Goals'!J18*2+SUM('HAA5 Goals'!H18:I18))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!K18*2+SUM('HAA5 Goals'!I18:J18))/4),\"\",(('HAA5 Goals'!K18*2+SUM('HAA5 Goals'!I18:J18))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!L18*2+SUM('HAA5 Goals'!J18:K18))/4),\"\",(('HAA5 Goals'!L18*2+SUM('HAA5 Goals'!J18:K18))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('HAA5 Goals'!A19),\"\",'HAA5 Goals'!A19)","v":"#1 BOOTH ESTATES"},null,null,{"$f":"IF(ISERROR(('HAA5 Goals'!D19*2+SUM('HAA5 Goals'!B19:C19))/4),\"\",(('HAA5 Goals'!D19*2+SUM('HAA5 Goals'!B19:C19))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!E19*2+SUM('HAA5 Goals'!C19:D19))/4),\"\",(('HAA5 Goals'!E19*2+SUM('HAA5 Goals'!C19:D19))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!F19*2+SUM('HAA5 Goals'!D19:E19))/4),\"\",(('HAA5 Goals'!F19*2+SUM('HAA5 Goals'!D19:E19))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!G19*2+SUM('HAA5 Goals'!E19:F19))/4),\"\",(('HAA5 Goals'!G19*2+SUM('HAA5 Goals'!E19:F19))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!H19*2+SUM('HAA5 Goals'!F19:G19))/4),\"\",(('HAA5 Goals'!H19*2+SUM('HAA5 Goals'!F19:G19))/4))","v":1.7250000000000001E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!I19*2+SUM('HAA5 Goals'!G19:H19))/4),\"\",(('HAA5 Goals'!I19*2+SUM('HAA5 Goals'!G19:H19))/4))","v":4.1425000000000003E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!J19*2+SUM('HAA5 Goals'!H19:I19))/4),\"\",(('HAA5 Goals'!J19*2+SUM('HAA5 Goals'!H19:I19))/4))","v":4.7975000000000004E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!K19*2+SUM('HAA5 Goals'!I19:J19))/4),\"\",(('HAA5 Goals'!K19*2+SUM('HAA5 Goals'!I19:J19))/4))","v":5.1525000000000001E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!L19*2+SUM('HAA5 Goals'!J19:K19))/4),\"\",(('HAA5 Goals'!L19*2+SUM('HAA5 Goals'!J19:K19))/4))","v":4.0800000000000003E-2}]
[null,{"$f":"IF(ISBLANK('HAA5 Goals'!A20),\"\",'HAA5 Goals'!A20)","v":"17689 PINE LAKE RD"},null,null,{"$f":"IF(ISERROR(('HAA5 Goals'!D20*2+SUM('HAA5 Goals'!B20:C20))/4),\"\",(('HAA5 Goals'!D20*2+SUM('HAA5 Goals'!B20:C20))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!E20*2+SUM('HAA5 Goals'!C20:D20))/4),\"\",(('HAA5 Goals'!E20*2+SUM('HAA5 Goals'!C20:D20))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!F20*2+SUM('HAA5 Goals'!D20:E20))/4),\"\",(('HAA5 Goals'!F20*2+SUM('HAA5 Goals'!D20:E20))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!G20*2+SUM('HAA5 Goals'!E20:F20))/4),\"\",(('HAA5 Goals'!G20*2+SUM('HAA5 Goals'!E20:F20))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!H20*2+SUM('HAA5 Goals'!F20:G20))/4),\"\",(('HAA5 Goals'!H20*2+SUM('HAA5 Goals'!F20:G20))/4))","v":2.92E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!I20*2+SUM('HAA5 Goals'!G20:H20))/4),\"\",(('HAA5 Goals'!I20*2+SUM('HAA5 Goals'!G20:H20))/4))","v":4.5350000000000001E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!J20*2+SUM('HAA5 Goals'!H20:I20))/4),\"\",(('HAA5 Goals'!J20*2+SUM('HAA5 Goals'!H20:I20))/4))","v":5.3025000000000003E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!K20*2+SUM('HAA5 Goals'!I20:J20))/4),\"\",(('HAA5 Goals'!K20*2+SUM('HAA5 Goals'!I20:J20))/4))","v":5.2449999999999997E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!L20*2+SUM('HAA5 Goals'!J20:K20))/4),\"\",(('HAA5 Goals'!L20*2+SUM('HAA5 Goals'!J20:K20))/4))","v":4.2300000000000004E-2}]
[null,{"$f":"IF(ISBLANK('HAA5 Goals'!A21),\"\",'HAA5 Goals'!A21)","v":"2920 39TH ST"},null,null,{"$f":"IF(ISERROR(('HAA5 Goals'!D21*2+SUM('HAA5 Goals'!B21:C21))/4),\"\",(('HAA5 Goals'!D21*2+SUM('HAA5 Goals'!B21:C21))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!E21*2+SUM('HAA5 Goals'!C21:D21))/4),\"\",(('HAA5 Goals'!E21*2+SUM('HAA5 Goals'!C21:D21))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!F21*2+SUM('HAA5 Goals'!D21:E21))/4),\"\",(('HAA5 Goals'!F21*2+SUM('HAA5 Goals'!D21:E21))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!G21*2+SUM('HAA5 Goals'!E21:F21))/4),\"\",(('HAA5 Goals'!G21*2+SUM('HAA5 Goals'!E21:F21))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!H21*2+SUM('HAA5 Goals'!F21:G21))/4),\"\",(('HAA5 Goals'!H21*2+SUM('HAA5 Goals'!F21:G21))/4))","v":2.8649999999999998E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!I21*2+SUM('HAA5 Goals'!G21:H21))/4),\"\",(('HAA5 Goals'!I21*2+SUM('HAA5 Goals'!G21:H21))/4))","v":5.0724999999999999E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!J21*2+SUM('HAA5 Goals'!H21:I21))/4),\"\",(('HAA5 Goals'!J21*2+SUM('HAA5 Goals'!H21:I21))/4))","v":6.6975000000000007E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!K21*2+SUM('HAA5 Goals'!I21:J21))/4),\"\",(('HAA5 Goals'!K21*2+SUM('HAA5 Goals'!I21:J21))/4))","v":5.4425000000000001E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!L21*2+SUM('HAA5 Goals'!J21:K21))/4),\"\",(('HAA5 Goals'!L21*2+SUM('HAA5 Goals'!J21:K21))/4))","v":4.2874999999999996E-2}]
[null,{"$f":"IF(ISBLANK('HAA5 Goals'!A22),\"\",'HAA5 Goals'!A22)","v":"6425 5TH ST"},null,null,{"$f":"IF(ISERROR(('HAA5 Goals'!D22*2+SUM('HAA5 Goals'!B22:C22))/4),\"\",(('HAA5 Goals'!D22*2+SUM('HAA5 Goals'!B22:C22))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!E22*2+SUM('HAA5 Goals'!C22:D22))/4),\"\",(('HAA5 Goals'!E22*2+SUM('HAA5 Goals'!C22:D22))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!F22*2+SUM('HAA5 Goals'!D22:E22))/4),\"\",(('HAA5 Goals'!F22*2+SUM('HAA5 Goals'!D22:E22))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!G22*2+SUM('HAA5 Goals'!E22:F22))/4),\"\",(('HAA5 Goals'!G22*2+SUM('HAA5 Goals'!E22:F22))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!H22*2+SUM('HAA5 Goals'!F22:G22))/4),\"\",(('HAA5 Goals'!H22*2+SUM('HAA5 Goals'!F22:G22))/4))","v":2.0449999999999999E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!I22*2+SUM('HAA5 Goals'!G22:H22))/4),\"\",(('HAA5 Goals'!I22*2+SUM('HAA5 Goals'!G22:H22))/4))","v":4.2674999999999998E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!J22*2+SUM('HAA5 Goals'!H22:I22))/4),\"\",(('HAA5 Goals'!J22*2+SUM('HAA5 Goals'!H22:I22))/4))","v":5.0500000000000003E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!K22*2+SUM('HAA5 Goals'!I22:J22))/4),\"\",(('HAA5 Goals'!K22*2+SUM('HAA5 Goals'!I22:J22))/4))","v":5.1699999999999996E-2},{"$f":"IF(ISERROR(('HAA5 Goals'!L22*2+SUM('HAA5 Goals'!J22:K22))/4),\"\",(('HAA5 Goals'!L22*2+SUM('HAA5 Goals'!J22:K22))/4))","v":4.0750000000000001E-2}]
[null,{"$f":"IF(ISBLANK('HAA5 Goals'!A23),\"\",'HAA5 Goals'!A23)","v":""},null,null,{"$f":"IF(ISERROR(('HAA5 Goals'!D23*2+SUM('HAA5 Goals'!B23:C23))/4),\"\",(('HAA5 Goals'!D23*2+SUM('HAA5 Goals'!B23:C23))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!E23*2+SUM('HAA5 Goals'!C23:D23))/4),\"\",(('HAA5 Goals'!E23*2+SUM('HAA5 Goals'!C23:D23))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!F23*2+SUM('HAA5 Goals'!D23:E23))/4),\"\",(('HAA5 Goals'!F23*2+SUM('HAA5 Goals'!D23:E23))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!G23*2+SUM('HAA5 Goals'!E23:F23))/4),\"\",(('HAA5 Goals'!G23*2+SUM('HAA5 Goals'!E23:F23))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!H23*2+SUM('HAA5 Goals'!F23:G23))/4),\"\",(('HAA5 Goals'!H23*2+SUM('HAA5 Goals'!F23:G23))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!I23*2+SUM('HAA5 Goals'!G23:H23))/4),\"\",(('HAA5 Goals'!I23*2+SUM('HAA5 Goals'!G23:H23))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!J23*2+SUM('HAA5 Goals'!H23:I23))/4),\"\",(('HAA5 Goals'!J23*2+SUM('HAA5 Goals'!H23:I23))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!K23*2+SUM('HAA5 Goals'!I23:J23))/4),\"\",(('HAA5 Goals'!K23*2+SUM('HAA5 Goals'!I23:J23))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!L23*2+SUM('HAA5 Goals'!J23:K23))/4),\"\",(('HAA5 Goals'!L23*2+SUM('HAA5 Goals'!J23:K23))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('HAA5 Goals'!A24),\"\",'HAA5 Goals'!A24)","v":""},null,null,{"$f":"IF(ISERROR(('HAA5 Goals'!D24*2+SUM('HAA5 Goals'!B24:C24))/4),\"\",(('HAA5 Goals'!D24*2+SUM('HAA5 Goals'!B24:C24))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!E24*2+SUM('HAA5 Goals'!C24:D24))/4),\"\",(('HAA5 Goals'!E24*2+SUM('HAA5 Goals'!C24:D24))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!F24*2+SUM('HAA5 Goals'!D24:E24))/4),\"\",(('HAA5 Goals'!F24*2+SUM('HAA5 Goals'!D24:E24))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!G24*2+SUM('HAA5 Goals'!E24:F24))/4),\"\",(('HAA5 Goals'!G24*2+SUM('HAA5 Goals'!E24:F24))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!H24*2+SUM('HAA5 Goals'!F24:G24))/4),\"\",(('HAA5 Goals'!H24*2+SUM('HAA5 Goals'!F24:G24))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!I24*2+SUM('HAA5 Goals'!G24:H24))/4),\"\",(('HAA5 Goals'!I24*2+SUM('HAA5 Goals'!G24:H24))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!J24*2+SUM('HAA5 Goals'!H24:I24))/4),\"\",(('HAA5 Goals'!J24*2+SUM('HAA5 Goals'!H24:I24))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!K24*2+SUM('HAA5 Goals'!I24:J24))/4),\"\",(('HAA5 Goals'!K24*2+SUM('HAA5 Goals'!I24:J24))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!L24*2+SUM('HAA5 Goals'!J24:K24))/4),\"\",(('HAA5 Goals'!L24*2+SUM('HAA5 Goals'!J24:K24))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('HAA5 Goals'!A25),\"\",'HAA5 Goals'!A25)","v":""},null,null,{"$f":"IF(ISERROR(('HAA5 Goals'!D25*2+SUM('HAA5 Goals'!B25:C25))/4),\"\",(('HAA5 Goals'!D25*2+SUM('HAA5 Goals'!B25:C25))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!E25*2+SUM('HAA5 Goals'!C25:D25))/4),\"\",(('HAA5 Goals'!E25*2+SUM('HAA5 Goals'!C25:D25))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!F25*2+SUM('HAA5 Goals'!D25:E25))/4),\"\",(('HAA5 Goals'!F25*2+SUM('HAA5 Goals'!D25:E25))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!G25*2+SUM('HAA5 Goals'!E25:F25))/4),\"\",(('HAA5 Goals'!G25*2+SUM('HAA5 Goals'!E25:F25))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!H25*2+SUM('HAA5 Goals'!F25:G25))/4),\"\",(('HAA5 Goals'!H25*2+SUM('HAA5 Goals'!F25:G25))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!I25*2+SUM('HAA5 Goals'!G25:H25))/4),\"\",(('HAA5 Goals'!I25*2+SUM('HAA5 Goals'!G25:H25))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!J25*2+SUM('HAA5 Goals'!H25:I25))/4),\"\",(('HAA5 Goals'!J25*2+SUM('HAA5 Goals'!H25:I25))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!K25*2+SUM('HAA5 Goals'!I25:J25))/4),\"\",(('HAA5 Goals'!K25*2+SUM('HAA5 Goals'!I25:J25))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!L25*2+SUM('HAA5 Goals'!J25:K25))/4),\"\",(('HAA5 Goals'!L25*2+SUM('HAA5 Goals'!J25:K25))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('HAA5 Goals'!A26),\"\",'HAA5 Goals'!A26)","v":""},null,null,{"$f":"IF(ISERROR(('HAA5 Goals'!D26*2+SUM('HAA5 Goals'!B26:C26))/4),\"\",(('HAA5 Goals'!D26*2+SUM('HAA5 Goals'!B26:C26))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!E26*2+SUM('HAA5 Goals'!C26:D26))/4),\"\",(('HAA5 Goals'!E26*2+SUM('HAA5 Goals'!C26:D26))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!F26*2+SUM('HAA5 Goals'!D26:E26))/4),\"\",(('HAA5 Goals'!F26*2+SUM('HAA5 Goals'!D26:E26))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!G26*2+SUM('HAA5 Goals'!E26:F26))/4),\"\",(('HAA5 Goals'!G26*2+SUM('HAA5 Goals'!E26:F26))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!H26*2+SUM('HAA5 Goals'!F26:G26))/4),\"\",(('HAA5 Goals'!H26*2+SUM('HAA5 Goals'!F26:G26))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!I26*2+SUM('HAA5 Goals'!G26:H26))/4),\"\",(('HAA5 Goals'!I26*2+SUM('HAA5 Goals'!G26:H26))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!J26*2+SUM('HAA5 Goals'!H26:I26))/4),\"\",(('HAA5 Goals'!J26*2+SUM('HAA5 Goals'!H26:I26))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!K26*2+SUM('HAA5 Goals'!I26:J26))/4),\"\",(('HAA5 Goals'!K26*2+SUM('HAA5 Goals'!I26:J26))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!L26*2+SUM('HAA5 Goals'!J26:K26))/4),\"\",(('HAA5 Goals'!L26*2+SUM('HAA5 Goals'!J26:K26))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('HAA5 Goals'!A27),\"\",'HAA5 Goals'!A27)","v":""},null,null,{"$f":"IF(ISERROR(('HAA5 Goals'!D27*2+SUM('HAA5 Goals'!B27:C27))/4),\"\",(('HAA5 Goals'!D27*2+SUM('HAA5 Goals'!B27:C27))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!E27*2+SUM('HAA5 Goals'!C27:D27))/4),\"\",(('HAA5 Goals'!E27*2+SUM('HAA5 Goals'!C27:D27))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!F27*2+SUM('HAA5 Goals'!D27:E27))/4),\"\",(('HAA5 Goals'!F27*2+SUM('HAA5 Goals'!D27:E27))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!G27*2+SUM('HAA5 Goals'!E27:F27))/4),\"\",(('HAA5 Goals'!G27*2+SUM('HAA5 Goals'!E27:F27))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!H27*2+SUM('HAA5 Goals'!F27:G27))/4),\"\",(('HAA5 Goals'!H27*2+SUM('HAA5 Goals'!F27:G27))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!I27*2+SUM('HAA5 Goals'!G27:H27))/4),\"\",(('HAA5 Goals'!I27*2+SUM('HAA5 Goals'!G27:H27))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!J27*2+SUM('HAA5 Goals'!H27:I27))/4),\"\",(('HAA5 Goals'!J27*2+SUM('HAA5 Goals'!H27:I27))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!K27*2+SUM('HAA5 Goals'!I27:J27))/4),\"\",(('HAA5 Goals'!K27*2+SUM('HAA5 Goals'!I27:J27))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!L27*2+SUM('HAA5 Goals'!J27:K27))/4),\"\",(('HAA5 Goals'!L27*2+SUM('HAA5 Goals'!J27:K27))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('HAA5 Goals'!A28),\"\",'HAA5 Goals'!A28)","v":""},null,null,{"$f":"IF(ISERROR(('HAA5 Goals'!D28*2+SUM('HAA5 Goals'!B28:C28))/4),\"\",(('HAA5 Goals'!D28*2+SUM('HAA5 Goals'!B28:C28))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!E28*2+SUM('HAA5 Goals'!C28:D28))/4),\"\",(('HAA5 Goals'!E28*2+SUM('HAA5 Goals'!C28:D28))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!F28*2+SUM('HAA5 Goals'!D28:E28))/4),\"\",(('HAA5 Goals'!F28*2+SUM('HAA5 Goals'!D28:E28))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!G28*2+SUM('HAA5 Goals'!E28:F28))/4),\"\",(('HAA5 Goals'!G28*2+SUM('HAA5 Goals'!E28:F28))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!H28*2+SUM('HAA5 Goals'!F28:G28))/4),\"\",(('HAA5 Goals'!H28*2+SUM('HAA5 Goals'!F28:G28))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!I28*2+SUM('HAA5 Goals'!G28:H28))/4),\"\",(('HAA5 Goals'!I28*2+SUM('HAA5 Goals'!G28:H28))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!J28*2+SUM('HAA5 Goals'!H28:I28))/4),\"\",(('HAA5 Goals'!J28*2+SUM('HAA5 Goals'!H28:I28))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!K28*2+SUM('HAA5 Goals'!I28:J28))/4),\"\",(('HAA5 Goals'!K28*2+SUM('HAA5 Goals'!I28:J28))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!L28*2+SUM('HAA5 Goals'!J28:K28))/4),\"\",(('HAA5 Goals'!L28*2+SUM('HAA5 Goals'!J28:K28))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('HAA5 Goals'!A29),\"\",'HAA5 Goals'!A29)","v":""},null,null,{"$f":"IF(ISERROR(('HAA5 Goals'!D29*2+SUM('HAA5 Goals'!B29:C29))/4),\"\",(('HAA5 Goals'!D29*2+SUM('HAA5 Goals'!B29:C29))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!E29*2+SUM('HAA5 Goals'!C29:D29))/4),\"\",(('HAA5 Goals'!E29*2+SUM('HAA5 Goals'!C29:D29))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!F29*2+SUM('HAA5 Goals'!D29:E29))/4),\"\",(('HAA5 Goals'!F29*2+SUM('HAA5 Goals'!D29:E29))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!G29*2+SUM('HAA5 Goals'!E29:F29))/4),\"\",(('HAA5 Goals'!G29*2+SUM('HAA5 Goals'!E29:F29))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!H29*2+SUM('HAA5 Goals'!F29:G29))/4),\"\",(('HAA5 Goals'!H29*2+SUM('HAA5 Goals'!F29:G29))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!I29*2+SUM('HAA5 Goals'!G29:H29))/4),\"\",(('HAA5 Goals'!I29*2+SUM('HAA5 Goals'!G29:H29))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!J29*2+SUM('HAA5 Goals'!H29:I29))/4),\"\",(('HAA5 Goals'!J29*2+SUM('HAA5 Goals'!H29:I29))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!K29*2+SUM('HAA5 Goals'!I29:J29))/4),\"\",(('HAA5 Goals'!K29*2+SUM('HAA5 Goals'!I29:J29))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!L29*2+SUM('HAA5 Goals'!J29:K29))/4),\"\",(('HAA5 Goals'!L29*2+SUM('HAA5 Goals'!J29:K29))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('HAA5 Goals'!A30),\"\",'HAA5 Goals'!A30)","v":""},null,null,{"$f":"IF(ISERROR(('HAA5 Goals'!D30*2+SUM('HAA5 Goals'!B30:C30))/4),\"\",(('HAA5 Goals'!D30*2+SUM('HAA5 Goals'!B30:C30))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!E30*2+SUM('HAA5 Goals'!C30:D30))/4),\"\",(('HAA5 Goals'!E30*2+SUM('HAA5 Goals'!C30:D30))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!F30*2+SUM('HAA5 Goals'!D30:E30))/4),\"\",(('HAA5 Goals'!F30*2+SUM('HAA5 Goals'!D30:E30))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!G30*2+SUM('HAA5 Goals'!E30:F30))/4),\"\",(('HAA5 Goals'!G30*2+SUM('HAA5 Goals'!E30:F30))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!H30*2+SUM('HAA5 Goals'!F30:G30))/4),\"\",(('HAA5 Goals'!H30*2+SUM('HAA5 Goals'!F30:G30))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!I30*2+SUM('HAA5 Goals'!G30:H30))/4),\"\",(('HAA5 Goals'!I30*2+SUM('HAA5 Goals'!G30:H30))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!J30*2+SUM('HAA5 Goals'!H30:I30))/4),\"\",(('HAA5 Goals'!J30*2+SUM('HAA5 Goals'!H30:I30))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!K30*2+SUM('HAA5 Goals'!I30:J30))/4),\"\",(('HAA5 Goals'!K30*2+SUM('HAA5 Goals'!I30:J30))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!L30*2+SUM('HAA5 Goals'!J30:K30))/4),\"\",(('HAA5 Goals'!L30*2+SUM('HAA5 Goals'!J30:K30))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('HAA5 Goals'!A31),\"\",'HAA5 Goals'!A31)","v":""},null,null,{"$f":"IF(ISERROR(('HAA5 Goals'!D31*2+SUM('HAA5 Goals'!B31:C31))/4),\"\",(('HAA5 Goals'!D31*2+SUM('HAA5 Goals'!B31:C31))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!E31*2+SUM('HAA5 Goals'!C31:D31))/4),\"\",(('HAA5 Goals'!E31*2+SUM('HAA5 Goals'!C31:D31))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!F31*2+SUM('HAA5 Goals'!D31:E31))/4),\"\",(('HAA5 Goals'!F31*2+SUM('HAA5 Goals'!D31:E31))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!G31*2+SUM('HAA5 Goals'!E31:F31))/4),\"\",(('HAA5 Goals'!G31*2+SUM('HAA5 Goals'!E31:F31))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!H31*2+SUM('HAA5 Goals'!F31:G31))/4),\"\",(('HAA5 Goals'!H31*2+SUM('HAA5 Goals'!F31:G31))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!I31*2+SUM('HAA5 Goals'!G31:H31))/4),\"\",(('HAA5 Goals'!I31*2+SUM('HAA5 Goals'!G31:H31))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!J31*2+SUM('HAA5 Goals'!H31:I31))/4),\"\",(('HAA5 Goals'!J31*2+SUM('HAA5 Goals'!H31:I31))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!K31*2+SUM('HAA5 Goals'!I31:J31))/4),\"\",(('HAA5 Goals'!K31*2+SUM('HAA5 Goals'!I31:J31))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!L31*2+SUM('HAA5 Goals'!J31:K31))/4),\"\",(('HAA5 Goals'!L31*2+SUM('HAA5 Goals'!J31:K31))/4))","v":""}]

{"sheet":"Site Info","index":16,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[null,"Note:  Change W longitude to negative value"]
[null,"Enter water qaulity data (e.g., chlorine residual) to plot in GE Graph from a summary table worksheet."]
[null,"Name","Latitude","Longitude","Value"]
[null,"EP",35.493000000000002,-94.221999999999994,1.25]
[null,"S5",35.499600000000001,-94.258799999999994,0.68]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Select sample site data in blue shaded area above and copy to transfer to GE Graph software"]