{"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":53,"n_cols":16,"rows_kept":53,"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,"Enter Water System"]
["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,"##",null,"##","##","##","##"]
["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"]
[null,null,null,null,null,null,null,null,null,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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$f":"VLOOKUP(Table6[[#This Row],[Free Cl2, Mg/L]],CL_RND_TBL[#All],2)","v":0}]

{"sheet":"Chlorine Summary Table","index":2,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,0,2,11]]}
[{"$f":"'Data Entry'!K1:K2","v":"Enter Water System"}]
["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","Date"]
["Sample Site","(blank)","Average"]
["(blank)"]
["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":28,"n_cols":18,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["Sample Site","(Multiple Items)",null,null,null,"Note: Update this table each time new data is entered in the Data Entry Table.",null,null,null,null,null,null,null,null,null,null,"Chlorine","Result"]
[null,null,null,null,null,"To update, 'right clicking' on any cell in the table and select Refresh.",null,null,null,null,null,null,null,null,null,null,0,0]
["Delta Cl2",null,null,null,null,"Legend",null,null,null,null,null,null,null,null,null,null,0.01,0]
["Date","Total",null,null,null,"Green Light: Delta less than or equal to 0.19",null,null,null,null,null,null,null,null,null,null,0.04,0]
[null,null,null,null,null,"Yellow Light: Delta less than 0.25 and greater than 0.19",null,null,null,null,null,null,null,null,null,null,0.05,0.1]
[null,null,null,null,null,"Red Light: Delta greater than or equal to 0.25 ",null,null,null,null,null,null,null,null,null,null,9.5000000000000001E-2,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.11,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.12,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.21,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.51,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.01,1.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,1.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.51,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.0099999999999998,2.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5,2.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5099999999999998,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.01,3.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5,3.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.51,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,4]

{"sheet":"pH Summary Table","index":5,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,0,2,11]]}
[{"$f":"'Data Entry'!K1:K2","v":"Enter Water System"}]
["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","Date"]
["Sample Site","(blank)","Average"]
["(blank)"]
["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":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,0,2,11]]}
[{"$f":"'Data Entry'!K1:K2","v":"Enter Water System"}]
["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","Date"]
["Sample Site","(blank)","Average"]
["(blank)"]
["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":47,"n_cols":34,"rows_kept":47,"cut":false,"hidden":false,"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":"Enter Water System"}]
[]
[null,"Average of TTHM, Mg/L","Date",null,null,null,null,null,null,null,null,null,null,null,null,null,"Start","End"]
[null,"Sample Site","(blank)","Average",null,null,null,null,null,null,null,null,null,null,null,null,"4/1/111","2012-07-30"]
[null,"(blank)","na","na"]
[null,"Average","na","na"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":"a(blank)"},"aAverage","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average"]
[null,null,{"$f":"IF(C45>1,C45,B43)","v":"(blank)"},"Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average"]
[null,"Average of TTHM, Mg/L","Date"]
[null,"Sample Site","(blank)","Average"]
[null,"(blank)","na","na"]
[null,"Average","na","na"]

{"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":"Enter Water System"}]
["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":{"$error":"#VALUE!"}},{"$f":"C11&C12","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"aAverage"]
[null,{"$f":"IF(C11=4,3,IF(C11=3,2,IF(C11=2,1,IF(C11=1,4))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(L11=4,3,IF(L11=3,2,IF(L11=2,1,IF(L11=1,4))))","v":{"$error":"#VALUE!"}},{"$f":"RIGHT(LEFT(L10,1),1)*1","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(C11=4,C12,IF(C11=3,C12,IF(C11=2,C12,IF(C11=1,C12-1))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(L11=4,L12,IF(L11=3,L12,IF(L11=2,L12,IF(L11=1,L12-1))))","v":{"$error":"#VALUE!"}},{"$f":"RIGHT(LEFT(L10,5),4)*1","v":{"$error":"#VALUE!"}}]
["(blank)",{"$f":"\"Q\"&B11&\" \"&B12","v":{"$error":"#VALUE!"}},{"$f":"\"Q\"&C11&\" \"&C12","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"\"Q\"&L11&\" \"&L12","v":{"$error":"#VALUE!"}}]
["(blank)",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A14,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A14,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A14,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A14,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A14,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A14,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A14,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A14,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A14,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A14,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A14,TTHMTable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A15,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A15,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A15,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A15,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A15,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A15,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A15,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A15,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A15,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A15,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A15,TTHMTable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A16,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A16,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A16,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A16,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A16,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A16,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A16,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A16,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A16,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A16,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A16,TTHMTable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A17,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A17,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A17,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A17,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A17,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A17,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A17,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A17,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A17,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A17,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A17,TTHMTable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A18,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A18,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A18,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A18,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A18,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A18,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A18,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A18,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A18,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A18,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A18,TTHMTable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A19,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A19,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A19,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A19,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A19,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A19,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A19,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A19,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A19,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A19,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A19,TTHMTable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A20,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A20,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A20,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A20,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A20,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A20,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A20,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A20,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A20,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A20,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A20,TTHMTable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A21,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A21,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A21,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A21,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A21,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A21,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A21,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A21,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A21,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A21,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A21,TTHMTable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A22,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A22,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A22,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A22,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A22,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A22,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A22,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A22,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A22,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A22,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A22,TTHMTable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A23,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A23,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A23,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A23,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A23,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A23,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A23,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A23,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A23,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A23,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A23,TTHMTable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A24,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A24,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A24,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A24,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A24,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A24,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A24,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A24,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A24,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A24,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A24,TTHMTable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A25,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A25,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A25,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A25,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A25,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A25,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A25,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A25,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A25,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A25,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A25,TTHMTable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A26,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A26,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A26,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A26,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A26,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A26,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A26,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A26,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A26,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A26,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A26,TTHMTable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A27,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A27,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A27,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A27,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A27,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A27,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A27,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A27,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A27,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A27,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A27,TTHMTable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A28,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A28,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A28,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A28,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A28,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A28,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A28,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A28,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A28,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A28,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A28,TTHMTable[Column1],0),FALSE)","v":"na"},null,"Formulas for labeling max. LRAA sites on LT charts"]
["(blank)",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A29,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A29,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A29,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A29,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A29,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A29,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A29,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A29,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A29,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A29,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A29,TTHMTable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A30,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A30,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A30,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A30,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A30,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A30,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A30,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A30,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A30,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A30,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A30,TTHMTable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,TTHMTable[],MATCH($A31,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,TTHMTable[],MATCH($A31,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,TTHMTable[],MATCH($A31,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,TTHMTable[],MATCH($A31,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,TTHMTable[],MATCH($A31,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,TTHMTable[],MATCH($A31,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,TTHMTable[],MATCH($A31,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,TTHMTable[],MATCH($A31,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,TTHMTable[],MATCH($A31,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,TTHMTable[],MATCH($A31,TTHMTable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,TTHMTable[],MATCH($A31,TTHMTable[Column1],0),FALSE)","v":"na"}]
[{"$f":"IF(ISBLANK(A14),\"\",A14)","v":"(blank)"},{"$f":"IF(ISBLANK(A14),\"\",\"LRAA\")","v":"LRAA"},null,null,{"$f":"IF(COUNT(B14:E14)<4,\"NA\",AVERAGE(B14:E14))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,{"$f":"A32","v":"(blank)"},{"$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":""}]
[{"$f":"IF(ISBLANK(A15),\"\",A15)","v":"(blank)"},{"$f":"IF(ISBLANK(A15),\"\",\"LRAA\")","v":"LRAA"},null,null,"NA","NA","NA","NA","NA","NA","NA","NA",null,"(blank)",{"$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":""}]
[{"$f":"IF(ISBLANK(A16),\"\",A16)","v":"(blank)"},{"$f":"IF(ISBLANK(A16),\"\",\"LRAA\")","v":"LRAA"},null,null,"NA","NA","NA","NA","NA","NA","NA","NA",null,"(blank)",{"$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":"(blank)"},{"$f":"IF(ISBLANK(A17),\"\",\"LRAA\")","v":"LRAA"},null,null,"NA","NA","NA","NA","NA","NA","NA","NA",null,"(blank)",{"$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":""}]
[{"$f":"IF(ISBLANK(A18),\"\",A18)","v":"(blank)"},{"$f":"IF(ISBLANK(A18),\"\",\"LRAA\")","v":"LRAA"},null,null,{"$f":"IF(COUNT(B18:E18)<4,\"NA\",AVERAGE(B18:E18))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA"]
["(blank)","LRAA",null,null,{"$f":"IF(COUNT(B19:E19)<4,\"NA\",AVERAGE(B19:E19))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA"]
["(blank)","LRAA",null,null,{"$f":"IF(COUNT(B20:E20)<4,\"NA\",AVERAGE(B20:E20))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA"]
[{"$f":"IF(ISBLANK(A21),\"\",A21)","v":"(blank)"},{"$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","NA","NA",null,"(blank)",{"$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":""}]
["(blank)","LRAA",null,null,{"$f":"IF(COUNT(B22:E22)<4,\"NA\",AVERAGE(B22:E22))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"(blank)",""]
["(blank)","LRAA",null,null,{"$f":"IF(COUNT(B23:E23)<4,\"NA\",AVERAGE(B23:E23))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"(blank)",""]
["(blank)","LRAA",null,null,{"$f":"IF(COUNT(B24:E24)<4,\"NA\",AVERAGE(B24:E24))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"(blank)",""]
["(blank)","LRAA",null,null,{"$f":"IF(COUNT(B25:E25)<4,\"NA\",AVERAGE(B25:E25))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"(blank)",""]
["(blank)","LRAA",null,null,{"$f":"IF(COUNT(B26:E26)<4,\"NA\",AVERAGE(B26:E26))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"(blank)",""]
["(blank)","LRAA",null,null,{"$f":"IF(COUNT(B27:E27)<4,\"NA\",AVERAGE(B27:E27))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"(blank)",""]
["(blank)","LRAA",null,null,{"$f":"IF(COUNT(B28:E28)<4,\"NA\",AVERAGE(B28:E28))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"(blank)",""]
["(blank)","LRAA",null,null,{"$f":"IF(COUNT(B29:E29)<4,\"NA\",AVERAGE(B29:E29))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"(blank)",""]
["(blank)","LRAA",null,null,{"$f":"IF(COUNT(B30:E30)<4,\"NA\",AVERAGE(B30:E30))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"(blank)",""]
["(blank)","LRAA",null,null,{"$f":"IF(COUNT(B31:E31)<4,\"NA\",AVERAGE(B31:E31))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"(blank)",""]
["Max LRAA",null,null,null,{"$f":"IF(COUNT(E32:E49)=0,\"NA\",MAX(E32:E49))","v":"NA"},{"$f":"IF(COUNT(F32:F49)=0,\"NA\",MAX(F32:F49))","v":"NA"},"NA","NA","NA","NA","NA",{"$f":"IF(COUNT(L32:L49)=0,\"NA\",MAX(L32:L49))","v":"NA"},null,null,{"$f":"CONCATENATE(O32,\"  \",O33,\"  \",O34,\"  \",O35,\"  \",O39,\"  \",O40,\"  \",O41,\"  \",O42,\"  \",O43,\"  \",O44,\"  \",O45,\"  \",O46)","v":"                      "}]
["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":"NA"}]
[]
["Data for plotting"]
["Avg of Max LRAAs",null,null,null,{"$f":"$L$51","v":"NA"},{"$f":"$L$51","v":"NA"},"NA","NA","NA","NA","NA",{"$f":"L51","v":"NA"}]
["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":""},{"$f":"IF(SUM(F32:F46)=0,\"\",(VLOOKUP(MAX(F32:F46),$F$32:$N$46,9,FALSE)))","v":""},{"$f":"IF(SUM(G32:G46)=0,\"\",(VLOOKUP(MAX(G32:G46),$G$32:$N$46,8,FALSE)))","v":""},{"$f":"IF(SUM(H32:H46)=0,\"\",(VLOOKUP(MAX(H32:H46),$H$32:$N$46,7,FALSE)))","v":""},{"$f":"IF(SUM(I32:I46)=0,\"\",(VLOOKUP(MAX(I32:I46),$I$32:$N$46,6,FALSE)))","v":""},{"$f":"IF(SUM(J32:J46)=0,\"\",(VLOOKUP(MAX(J32:J46),$J$32:$N$46,5,FALSE)))","v":""},{"$f":"IF(SUM(K32:K46)=0,\"\",(VLOOKUP(MAX(K32:K46),$K$32:$N$46,4,FALSE)))","v":""},{"$f":"IF(SUM(L32:L46)=0,\"\",(VLOOKUP(MAX(L32:L46),$L$32:$N$46,3,FALSE)))","v":""}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Sites Contributing to Maximum LRAA:"]
[null,null,null,null,null,null,null,null,{"$f":"O50","v":"                      "}]

{"sheet":"HAA5 Summary Table","index":12,"n_rows":46,"n_cols":33,"rows_kept":46,"cut":false,"hidden":false,"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":"Enter Water System"}]
[]
["Average of HAA5, Mg/L","Date"]
["Sample Site","(blank)","Average"]
["(blank)","na","na"]
["Average","na","na"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":"a(blank)"},"aAverage","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average"]
[null,{"$f":"IF(B44>1,B44,A42)","v":"(blank)"},"Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average","Average"]
["Average of HAA5, Mg/L","Date"]
["Sample Site","(blank)","Average"]
["(blank)","na","na"]
["Average","na","na"]

{"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":"Enter Water System"}]
["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":{"$error":"#VALUE!"}},{"$f":"C11&C12","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"aAverage"]
[null,{"$f":"IF(C11=4,3,IF(C11=3,2,IF(C11=2,1,IF(C11=1,4))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(L11=4,3,IF(L11=3,2,IF(L11=2,1,IF(L11=1,4))))","v":{"$error":"#VALUE!"}},{"$f":"RIGHT(LEFT(L10,1),1)*1","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(C11=4,C12,IF(C11=3,C12,IF(C11=2,C12,IF(C11=1,C12-1))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(L11=4,L12,IF(L11=3,L12,IF(L11=2,L12,IF(L11=1,L12-1))))","v":{"$error":"#VALUE!"}},{"$f":"RIGHT(LEFT(L10,5),4)*1","v":{"$error":"#VALUE!"}}]
["(blank)",{"$f":"\"Q\"&B11&\" \"&B12","v":{"$error":"#VALUE!"}},{"$f":"\"Q\"&C11&\" \"&C12","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"\"Q\"&L11&\" \"&L12","v":{"$error":"#VALUE!"}}]
["(blank)",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A14,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A14,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A14,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A14,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A14,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A14,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A14,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A14,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A14,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A14,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A14,HAATable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A15,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A15,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A15,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A15,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A15,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A15,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A15,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A15,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A15,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A15,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A15,HAATable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A16,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A16,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A16,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A16,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A16,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A16,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A16,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A16,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A16,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A16,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A16,HAATable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A17,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A17,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A17,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A17,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A17,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A17,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A17,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A17,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A17,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A17,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A17,HAATable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A18,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A18,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A18,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A18,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A18,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A18,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A18,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A18,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A18,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A18,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A18,HAATable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A19,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A19,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A19,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A19,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A19,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A19,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A19,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A19,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A19,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A19,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A19,HAATable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A20,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A20,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A20,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A20,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A20,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A20,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A20,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A20,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A20,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A20,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A20,HAATable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A21,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A21,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A21,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A21,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A21,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A21,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A21,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A21,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A21,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A21,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A21,HAATable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A22,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A22,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A22,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A22,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A22,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A22,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A22,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A22,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A22,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A22,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A22,HAATable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A23,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A23,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A23,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A23,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A23,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A23,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A23,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A23,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A23,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A23,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A23,HAATable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A24,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A24,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A24,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A24,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A24,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A24,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A24,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A24,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A24,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A24,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A24,HAATable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A25,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A25,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A25,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A25,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A25,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A25,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A25,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A25,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A25,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A25,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A25,HAATable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A26,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A26,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A26,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A26,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A26,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A26,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A26,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A26,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A26,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A26,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A26,HAATable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A27,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A27,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A27,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A27,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A27,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A27,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A27,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A27,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A27,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A27,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A27,HAATable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A28,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A28,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A28,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A28,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A28,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A28,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A28,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A28,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A28,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A28,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A28,HAATable[Column1],0),FALSE)","v":"na"},null,"Formulas for labeling max. LRAA sites on LT charts"]
["(blank)",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A29,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A29,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A29,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A29,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A29,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A29,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A29,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A29,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A29,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A29,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A29,HAATable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A30,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A30,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A30,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A30,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A30,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A30,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A30,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A30,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A30,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A30,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A30,HAATable[Column1],0),FALSE)","v":"na"}]
["(blank)",{"$f":"HLOOKUP($B$10,HAATable[],MATCH($A31,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($C$10,HAATable[],MATCH($A31,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($D$10,HAATable[],MATCH($A31,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($E$10,HAATable[],MATCH($A31,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($F$10,HAATable[],MATCH($A31,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($G$10,HAATable[],MATCH($A31,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($H$10,HAATable[],MATCH($A31,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($I$10,HAATable[],MATCH($A31,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($J$10,HAATable[],MATCH($A31,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($K$10,HAATable[],MATCH($A31,HAATable[Column1],0),FALSE)","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP($L$10,HAATable[],MATCH($A31,HAATable[Column1],0),FALSE)","v":"na"}]
[{"$f":"IF(ISBLANK(A14),\"\",A14)","v":"(blank)"},{"$f":"IF(ISBLANK(A14),\"\",\"LRAA\")","v":"LRAA"},null,null,{"$f":"IF(COUNT(B14:E14)<4,\"NA\",AVERAGE(B14:E14))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,{"$f":"A32","v":"(blank)"},{"$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":""}]
["(blank)","LRAA",null,null,"NA","NA","NA","NA","NA","NA","NA","NA",null,"(blank)",""]
["(blank)","LRAA",null,null,"NA","NA","NA","NA","NA","NA","NA","NA",null,"(blank)",""]
["(blank)","LRAA",null,null,"NA","NA","NA","NA","NA","NA","NA","NA",null,"(blank)",""]
["(blank)","LRAA",null,null,"NA","NA","NA","NA","NA","NA","NA","NA",null,"(blank)",""]
["(blank)","LRAA",null,null,{"$f":"IF(COUNT(B19:E19)<4,\"NA\",AVERAGE(B19:E19))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"(blank)",""]
["(blank)","LRAA",null,null,{"$f":"IF(COUNT(B20:E20)<4,\"NA\",AVERAGE(B20:E20))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"(blank)",""]
[{"$f":"IF(ISBLANK(A24),\"\",A24)","v":"(blank)"},{"$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","NA","NA",null,"(blank)",""]
["(blank)","LRAA",null,null,{"$f":"IF(COUNT(B22:E22)<4,\"NA\",AVERAGE(B22:E22))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA"]
["(blank)","LRAA",null,null,{"$f":"IF(COUNT(B23:E23)<4,\"NA\",AVERAGE(B23:E23))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA"]
["(blank)","LRAA",null,null,{"$f":"IF(COUNT(B24:E24)<4,\"NA\",AVERAGE(B24:E24))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA"]
[{"$f":"IF(ISBLANK(A25),\"\",A25)","v":"(blank)"},"LRAA",null,null,{"$f":"IF(COUNT(B25:E25)<4,\"NA\",AVERAGE(B25:E25))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"(blank)",{"$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":""}]
["(blank)","LRAA",null,null,{"$f":"IF(COUNT(B26:E26)<4,\"NA\",AVERAGE(B26:E26))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"(blank)",{"$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":""}]
["(blank)",{"$f":"IF(ISBLANK(A27),\"\",\"LRAA\")","v":"LRAA"},null,null,{"$f":"IF(COUNT(B27:E27)<4,\"NA\",AVERAGE(B27:E27))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"(blank)",{"$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":""}]
["(blank)",{"$f":"IF(ISBLANK(A28),\"\",\"LRAA\")","v":"LRAA"},null,null,{"$f":"IF(COUNT(B28:E28)<4,\"NA\",AVERAGE(B28:E28))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA",null,"(blank)",{"$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":""}]
["(blank)",{"$f":"IF(ISBLANK(A29),\"\",\"LRAA\")","v":"LRAA"},null,null,{"$f":"IF(COUNT(B29:E29)<4,\"NA\",AVERAGE(B29:E29))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA"]
["(blank)",{"$f":"IF(ISBLANK(A30),\"\",\"LRAA\")","v":"LRAA"},null,null,{"$f":"IF(COUNT(B30:E30)<4,\"NA\",AVERAGE(B30:E30))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA"]
["(blank)",{"$f":"IF(ISBLANK(A31),\"\",\"LRAA\")","v":"LRAA"},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":"NA"},{"$f":"IF(COUNT(F32:F49)=0,\"NA\",MAX(F32:F49))","v":"NA"},"NA","NA","NA",{"$f":"IF(COUNT(J32:J49)=0,\"NA\",MAX(J32:J49))","v":"NA"},"NA","NA",null,null,{"$f":"CONCATENATE(O32,\"  \",O33,\"  \",O34,\"  \",O35,\"  \",O36,\"  \",O37,\"  \",O38,\"  \",O39,\"  \",O43,\"  \",O44,\"  \",O45,\"  \",O46)","v":"                      "}]
["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":"NA"}]
[]
["Data for plotting"]
["Avg of Max LRAAs",null,null,null,{"$f":"$L$51","v":"NA"},{"$f":"$L$51","v":"NA"},"NA","NA","NA","NA","NA",{"$f":"L51","v":"NA"}]
["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":""},{"$f":"IF(SUM(F32:F46)=0,\"\",(VLOOKUP(MAX(F32:F46),$F$32:$N$46,9,FALSE)))","v":""},{"$f":"IF(SUM(G32:G46)=0,\"\",(VLOOKUP(MAX(G32:G46),$G$32:$N$46,8,FALSE)))","v":""},{"$f":"IF(SUM(H32:H46)=0,\"\",(VLOOKUP(MAX(H32:H46),$H$32:$N$46,7,FALSE)))","v":""},{"$f":"IF(SUM(I32:I46)=0,\"\",(VLOOKUP(MAX(I32:I46),$I$32:$N$46,6,FALSE)))","v":""},{"$f":"IF(SUM(J32:J46)=0,\"\",(VLOOKUP(MAX(J32:J46),$J$32:$N$46,5,FALSE)))","v":""},{"$f":"IF(SUM(K32:K46)=0,\"\",(VLOOKUP(MAX(K32:K46),$K$32:$N$46,4,FALSE)))","v":""},{"$f":"IF(SUM(L32:L46)=0,\"\",(VLOOKUP(MAX(L32:L46),$L$32:$N$46,3,FALSE)))","v":""}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Sites Contributing to Maximum LRAA:"]
[null,null,null,null,null,null,null,null,{"$f":"O50","v":"                      "}]

{"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":"Enter Water System"}]
[]
[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":{"$error":"#VALUE!"}},{"$f":"'TTHM Goals'!C13","v":{"$error":"#VALUE!"}},{"$f":"'TTHM Goals'!D13","v":{"$error":"#VALUE!"}},{"$f":"'TTHM Goals'!E13","v":{"$error":"#VALUE!"}},{"$f":"'TTHM Goals'!F13","v":{"$error":"#VALUE!"}},{"$f":"'TTHM Goals'!G13","v":{"$error":"#VALUE!"}},{"$f":"'TTHM Goals'!H13","v":{"$error":"#VALUE!"}},{"$f":"'TTHM Goals'!I13","v":{"$error":"#VALUE!"}},{"$f":"'TTHM Goals'!J13","v":{"$error":"#VALUE!"}},{"$f":"'TTHM Goals'!K13","v":{"$error":"#VALUE!"}},{"$f":"'TTHM Goals'!L13","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(ISBLANK('TTHM Goals'!A14),\"\",'TTHM Goals'!A14)","v":"(blank)"},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":""},{"$f":"IF(ISERROR(('TTHM Goals'!E14*2+SUM('TTHM Goals'!C14:D14))/4),\"\",(('TTHM Goals'!E14*2+SUM('TTHM Goals'!C14:D14))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!F14*2+SUM('TTHM Goals'!D14:E14))/4),\"\",(('TTHM Goals'!F14*2+SUM('TTHM Goals'!D14:E14))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!G14*2+SUM('TTHM Goals'!E14:F14))/4),\"\",(('TTHM Goals'!G14*2+SUM('TTHM Goals'!E14:F14))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!H14*2+SUM('TTHM Goals'!F14:G14))/4),\"\",(('TTHM Goals'!H14*2+SUM('TTHM Goals'!F14:G14))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!I14*2+SUM('TTHM Goals'!G14:H14))/4),\"\",(('TTHM Goals'!I14*2+SUM('TTHM Goals'!G14:H14))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!J14*2+SUM('TTHM Goals'!H14:I14))/4),\"\",(('TTHM Goals'!J14*2+SUM('TTHM Goals'!H14:I14))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!K14*2+SUM('TTHM Goals'!I14:J14))/4),\"\",(('TTHM Goals'!K14*2+SUM('TTHM Goals'!I14:J14))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!L14*2+SUM('TTHM Goals'!J14:K14))/4),\"\",(('TTHM Goals'!L14*2+SUM('TTHM Goals'!J14:K14))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('TTHM Goals'!A15),\"\",'TTHM Goals'!A15)","v":"(blank)"},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":""},{"$f":"IF(ISERROR(('TTHM Goals'!E15*2+SUM('TTHM Goals'!C15:D15))/4),\"\",(('TTHM Goals'!E15*2+SUM('TTHM Goals'!C15:D15))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!F15*2+SUM('TTHM Goals'!D15:E15))/4),\"\",(('TTHM Goals'!F15*2+SUM('TTHM Goals'!D15:E15))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!G15*2+SUM('TTHM Goals'!E15:F15))/4),\"\",(('TTHM Goals'!G15*2+SUM('TTHM Goals'!E15:F15))/4))","v":""},{"$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":"(blank)"},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":""},{"$f":"IF(ISERROR(('TTHM Goals'!E16*2+SUM('TTHM Goals'!C16:D16))/4),\"\",(('TTHM Goals'!E16*2+SUM('TTHM Goals'!C16:D16))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!F16*2+SUM('TTHM Goals'!D16:E16))/4),\"\",(('TTHM Goals'!F16*2+SUM('TTHM Goals'!D16:E16))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!G16*2+SUM('TTHM Goals'!E16:F16))/4),\"\",(('TTHM Goals'!G16*2+SUM('TTHM Goals'!E16:F16))/4))","v":""},{"$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":"(blank)"},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":""},{"$f":"IF(ISERROR(('TTHM Goals'!E17*2+SUM('TTHM Goals'!C17:D17))/4),\"\",(('TTHM Goals'!E17*2+SUM('TTHM Goals'!C17:D17))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!F17*2+SUM('TTHM Goals'!D17:E17))/4),\"\",(('TTHM Goals'!F17*2+SUM('TTHM Goals'!D17:E17))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!G17*2+SUM('TTHM Goals'!E17:F17))/4),\"\",(('TTHM Goals'!G17*2+SUM('TTHM Goals'!E17:F17))/4))","v":""},{"$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":"(blank)"},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":""},{"$f":"IF(ISERROR(('TTHM Goals'!E18*2+SUM('TTHM Goals'!C18:D18))/4),\"\",(('TTHM Goals'!E18*2+SUM('TTHM Goals'!C18:D18))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!F18*2+SUM('TTHM Goals'!D18:E18))/4),\"\",(('TTHM Goals'!F18*2+SUM('TTHM Goals'!D18:E18))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!G18*2+SUM('TTHM Goals'!E18:F18))/4),\"\",(('TTHM Goals'!G18*2+SUM('TTHM Goals'!E18:F18))/4))","v":""},{"$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":"(blank)"},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":""},{"$f":"IF(ISERROR(('TTHM Goals'!I19*2+SUM('TTHM Goals'!G19:H19))/4),\"\",(('TTHM Goals'!I19*2+SUM('TTHM Goals'!G19:H19))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!J19*2+SUM('TTHM Goals'!H19:I19))/4),\"\",(('TTHM Goals'!J19*2+SUM('TTHM Goals'!H19:I19))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!K19*2+SUM('TTHM Goals'!I19:J19))/4),\"\",(('TTHM Goals'!K19*2+SUM('TTHM Goals'!I19:J19))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!L19*2+SUM('TTHM Goals'!J19:K19))/4),\"\",(('TTHM Goals'!L19*2+SUM('TTHM Goals'!J19:K19))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('TTHM Goals'!A20),\"\",'TTHM Goals'!A20)","v":"(blank)"},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":""},{"$f":"IF(ISERROR(('TTHM Goals'!I20*2+SUM('TTHM Goals'!G20:H20))/4),\"\",(('TTHM Goals'!I20*2+SUM('TTHM Goals'!G20:H20))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!J20*2+SUM('TTHM Goals'!H20:I20))/4),\"\",(('TTHM Goals'!J20*2+SUM('TTHM Goals'!H20:I20))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!K20*2+SUM('TTHM Goals'!I20:J20))/4),\"\",(('TTHM Goals'!K20*2+SUM('TTHM Goals'!I20:J20))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!L20*2+SUM('TTHM Goals'!J20:K20))/4),\"\",(('TTHM Goals'!L20*2+SUM('TTHM Goals'!J20:K20))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('TTHM Goals'!A21),\"\",'TTHM Goals'!A21)","v":"(blank)"},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":""},{"$f":"IF(ISERROR(('TTHM Goals'!I21*2+SUM('TTHM Goals'!G21:H21))/4),\"\",(('TTHM Goals'!I21*2+SUM('TTHM Goals'!G21:H21))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!J21*2+SUM('TTHM Goals'!H21:I21))/4),\"\",(('TTHM Goals'!J21*2+SUM('TTHM Goals'!H21:I21))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!K21*2+SUM('TTHM Goals'!I21:J21))/4),\"\",(('TTHM Goals'!K21*2+SUM('TTHM Goals'!I21:J21))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!L21*2+SUM('TTHM Goals'!J21:K21))/4),\"\",(('TTHM Goals'!L21*2+SUM('TTHM Goals'!J21:K21))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('TTHM Goals'!A22),\"\",'TTHM Goals'!A22)","v":"(blank)"},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":""},{"$f":"IF(ISERROR(('TTHM Goals'!I22*2+SUM('TTHM Goals'!G22:H22))/4),\"\",(('TTHM Goals'!I22*2+SUM('TTHM Goals'!G22:H22))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!J22*2+SUM('TTHM Goals'!H22:I22))/4),\"\",(('TTHM Goals'!J22*2+SUM('TTHM Goals'!H22:I22))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!K22*2+SUM('TTHM Goals'!I22:J22))/4),\"\",(('TTHM Goals'!K22*2+SUM('TTHM Goals'!I22:J22))/4))","v":""},{"$f":"IF(ISERROR(('TTHM Goals'!L22*2+SUM('TTHM Goals'!J22:K22))/4),\"\",(('TTHM Goals'!L22*2+SUM('TTHM Goals'!J22:K22))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('TTHM Goals'!A23),\"\",'TTHM Goals'!A23)","v":"(blank)"},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":"(blank)"},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":"(blank)"},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":"(blank)"},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":"(blank)"},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":"(blank)"},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":"(blank)"},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":"(blank)"},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":"(blank)"},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":{"$error":"#VALUE!"}},{"$f":"'HAA5 Goals'!C13","v":{"$error":"#VALUE!"}},{"$f":"'HAA5 Goals'!D13","v":{"$error":"#VALUE!"}},{"$f":"'HAA5 Goals'!E13","v":{"$error":"#VALUE!"}},{"$f":"'HAA5 Goals'!F13","v":{"$error":"#VALUE!"}},{"$f":"'HAA5 Goals'!G13","v":{"$error":"#VALUE!"}},{"$f":"'HAA5 Goals'!H13","v":{"$error":"#VALUE!"}},{"$f":"'HAA5 Goals'!I13","v":{"$error":"#VALUE!"}},{"$f":"'HAA5 Goals'!J13","v":{"$error":"#VALUE!"}},{"$f":"'HAA5 Goals'!K13","v":{"$error":"#VALUE!"}},{"$f":"'HAA5 Goals'!L13","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(ISBLANK('HAA5 Goals'!A14),\"\",'HAA5 Goals'!A14)","v":"(blank)"},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":""},{"$f":"IF(ISERROR(('HAA5 Goals'!E14*2+SUM('HAA5 Goals'!C14:D14))/4),\"\",(('HAA5 Goals'!E14*2+SUM('HAA5 Goals'!C14:D14))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!F14*2+SUM('HAA5 Goals'!D14:E14))/4),\"\",(('HAA5 Goals'!F14*2+SUM('HAA5 Goals'!D14:E14))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!G14*2+SUM('HAA5 Goals'!E14:F14))/4),\"\",(('HAA5 Goals'!G14*2+SUM('HAA5 Goals'!E14:F14))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!H14*2+SUM('HAA5 Goals'!F14:G14))/4),\"\",(('HAA5 Goals'!H14*2+SUM('HAA5 Goals'!F14:G14))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!I14*2+SUM('HAA5 Goals'!G14:H14))/4),\"\",(('HAA5 Goals'!I14*2+SUM('HAA5 Goals'!G14:H14))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!J14*2+SUM('HAA5 Goals'!H14:I14))/4),\"\",(('HAA5 Goals'!J14*2+SUM('HAA5 Goals'!H14:I14))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!K14*2+SUM('HAA5 Goals'!I14:J14))/4),\"\",(('HAA5 Goals'!K14*2+SUM('HAA5 Goals'!I14:J14))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!L14*2+SUM('HAA5 Goals'!J14:K14))/4),\"\",(('HAA5 Goals'!L14*2+SUM('HAA5 Goals'!J14:K14))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('HAA5 Goals'!A15),\"\",'HAA5 Goals'!A15)","v":"(blank)"},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":""},{"$f":"IF(ISERROR(('HAA5 Goals'!E15*2+SUM('HAA5 Goals'!C15:D15))/4),\"\",(('HAA5 Goals'!E15*2+SUM('HAA5 Goals'!C15:D15))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!F15*2+SUM('HAA5 Goals'!D15:E15))/4),\"\",(('HAA5 Goals'!F15*2+SUM('HAA5 Goals'!D15:E15))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!G15*2+SUM('HAA5 Goals'!E15:F15))/4),\"\",(('HAA5 Goals'!G15*2+SUM('HAA5 Goals'!E15:F15))/4))","v":""},{"$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":"(blank)"},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":""},{"$f":"IF(ISERROR(('HAA5 Goals'!E16*2+SUM('HAA5 Goals'!C16:D16))/4),\"\",(('HAA5 Goals'!E16*2+SUM('HAA5 Goals'!C16:D16))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!F16*2+SUM('HAA5 Goals'!D16:E16))/4),\"\",(('HAA5 Goals'!F16*2+SUM('HAA5 Goals'!D16:E16))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!G16*2+SUM('HAA5 Goals'!E16:F16))/4),\"\",(('HAA5 Goals'!G16*2+SUM('HAA5 Goals'!E16:F16))/4))","v":""},{"$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":"(blank)"},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":""},{"$f":"IF(ISERROR(('HAA5 Goals'!E17*2+SUM('HAA5 Goals'!C17:D17))/4),\"\",(('HAA5 Goals'!E17*2+SUM('HAA5 Goals'!C17:D17))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!F17*2+SUM('HAA5 Goals'!D17:E17))/4),\"\",(('HAA5 Goals'!F17*2+SUM('HAA5 Goals'!D17:E17))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!G17*2+SUM('HAA5 Goals'!E17:F17))/4),\"\",(('HAA5 Goals'!G17*2+SUM('HAA5 Goals'!E17:F17))/4))","v":""},{"$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":"(blank)"},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":""},{"$f":"IF(ISERROR(('HAA5 Goals'!E18*2+SUM('HAA5 Goals'!C18:D18))/4),\"\",(('HAA5 Goals'!E18*2+SUM('HAA5 Goals'!C18:D18))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!F18*2+SUM('HAA5 Goals'!D18:E18))/4),\"\",(('HAA5 Goals'!F18*2+SUM('HAA5 Goals'!D18:E18))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!G18*2+SUM('HAA5 Goals'!E18:F18))/4),\"\",(('HAA5 Goals'!G18*2+SUM('HAA5 Goals'!E18:F18))/4))","v":""},{"$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":"(blank)"},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":""},{"$f":"IF(ISERROR(('HAA5 Goals'!I19*2+SUM('HAA5 Goals'!G19:H19))/4),\"\",(('HAA5 Goals'!I19*2+SUM('HAA5 Goals'!G19:H19))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!J19*2+SUM('HAA5 Goals'!H19:I19))/4),\"\",(('HAA5 Goals'!J19*2+SUM('HAA5 Goals'!H19:I19))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!K19*2+SUM('HAA5 Goals'!I19:J19))/4),\"\",(('HAA5 Goals'!K19*2+SUM('HAA5 Goals'!I19:J19))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!L19*2+SUM('HAA5 Goals'!J19:K19))/4),\"\",(('HAA5 Goals'!L19*2+SUM('HAA5 Goals'!J19:K19))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('HAA5 Goals'!A20),\"\",'HAA5 Goals'!A20)","v":"(blank)"},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":""},{"$f":"IF(ISERROR(('HAA5 Goals'!I20*2+SUM('HAA5 Goals'!G20:H20))/4),\"\",(('HAA5 Goals'!I20*2+SUM('HAA5 Goals'!G20:H20))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!J20*2+SUM('HAA5 Goals'!H20:I20))/4),\"\",(('HAA5 Goals'!J20*2+SUM('HAA5 Goals'!H20:I20))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!K20*2+SUM('HAA5 Goals'!I20:J20))/4),\"\",(('HAA5 Goals'!K20*2+SUM('HAA5 Goals'!I20:J20))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!L20*2+SUM('HAA5 Goals'!J20:K20))/4),\"\",(('HAA5 Goals'!L20*2+SUM('HAA5 Goals'!J20:K20))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('HAA5 Goals'!A21),\"\",'HAA5 Goals'!A21)","v":"(blank)"},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":""},{"$f":"IF(ISERROR(('HAA5 Goals'!I21*2+SUM('HAA5 Goals'!G21:H21))/4),\"\",(('HAA5 Goals'!I21*2+SUM('HAA5 Goals'!G21:H21))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!J21*2+SUM('HAA5 Goals'!H21:I21))/4),\"\",(('HAA5 Goals'!J21*2+SUM('HAA5 Goals'!H21:I21))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!K21*2+SUM('HAA5 Goals'!I21:J21))/4),\"\",(('HAA5 Goals'!K21*2+SUM('HAA5 Goals'!I21:J21))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!L21*2+SUM('HAA5 Goals'!J21:K21))/4),\"\",(('HAA5 Goals'!L21*2+SUM('HAA5 Goals'!J21:K21))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('HAA5 Goals'!A22),\"\",'HAA5 Goals'!A22)","v":"(blank)"},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":""},{"$f":"IF(ISERROR(('HAA5 Goals'!I22*2+SUM('HAA5 Goals'!G22:H22))/4),\"\",(('HAA5 Goals'!I22*2+SUM('HAA5 Goals'!G22:H22))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!J22*2+SUM('HAA5 Goals'!H22:I22))/4),\"\",(('HAA5 Goals'!J22*2+SUM('HAA5 Goals'!H22:I22))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!K22*2+SUM('HAA5 Goals'!I22:J22))/4),\"\",(('HAA5 Goals'!K22*2+SUM('HAA5 Goals'!I22:J22))/4))","v":""},{"$f":"IF(ISERROR(('HAA5 Goals'!L22*2+SUM('HAA5 Goals'!J22:K22))/4),\"\",(('HAA5 Goals'!L22*2+SUM('HAA5 Goals'!J22:K22))/4))","v":""}]
[null,{"$f":"IF(ISBLANK('HAA5 Goals'!A23),\"\",'HAA5 Goals'!A23)","v":"(blank)"},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":"(blank)"},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":"(blank)"},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":"(blank)"},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":"(blank)"},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":"(blank)"},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":"(blank)"},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":"(blank)"},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":"(blank)"},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"]