{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["CT Data","GiardiaGraph"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"GiardiaGraph","index":1,"reason":"not_a_worksheet"}],"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":"CT Data","index":0,"n_rows":69,"n_cols":66,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[null,null,"Author:  Guy Schott, guy.schott@waterboards.ca.gov, 707-576-2732, updated 5/25/20"]
[null,null,"CT Compliance for "]
[null,null,"Virus by Free Chlorine"]
[null,null,"pH = 6.0 - 9.0"]
[]
[null,null,"Input Parameters:"]
[null,null,"Water System Name:",null,null,null,null,null,null,"Enter Name"]
[null,null,"Number of Service Connections:",null,null,null,null,null,null,"Enter Number"]
[null,null,"System Number:",null,null,null,null,null,null,"Enter Number"]
[null,null,"Month and Year:",null,null,null,null,null,null,"2020-06-01"]
[null,null,"Clearwell(s) - Volume per Foot:",null,null,null,null,null,null,10000,null,"Gallons/Ft"]
[null,null,"Short-Circuiting Factor for Clearwell(s):",null,null,null,null,null,null,0.1,null,"t10/T (BF)"]
[null,null,"Transmission Pipe - Volume:",null,null,null,null,null,null,2000,null,"Gallons"]
[null,null,"Short-Circuiting Factor for Pipe:",null,null,null,null,null,null,1,null,"t10/T (BF)"]
[null,null,"Required Log Inactivation of Giardia Cyst:",null,null,null,null,null,null,0.5,null,"Log"]
[]
[null,null,null,"Data inputs should be based on when plant is on-line and flow leaving clearwell",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(AG18,AH18,AH17)","v":"2020-06-01"},1]
[null,null,null,"Reactor Data for Peak Hourly Flow1",null,null,null,null,"Ct10 Dose and Virus Log Inactivation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(J10)","v":2020},{"$f":"MONTH($J$10)","v":6},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Guy Schott equations (percent error):"]
[null,null,"Date","Flow \nRate\n(MGD)","Tank\nLowest \nLevel\n(ft)","Water\nTemp\n(oC)"," pH","Chlorine \nResidual\n(mg/L)","Effective \nVolume\n(BF • Vol)\n(gallons)","Effective \nContact Time\n(minutes)","Required\nDose\nCt10\n(mg/L•min)","Delivered \nDose\nCt10\n(mg/L•min)","CT Ratio \nCTDLVD/CTreq","Giardia\nLog \nInactivation","Virus\nLog \nInactivation",null,null,null,"Pipe \nDiameter\ninch","Pipe\nLength\nft","Pipe\nVolume\nCalc. gal",null,null,null,null,null,null,null,null,"Viruses",null,null,null,null,null,null,"AveLog","Max",null,"EPA Eq,           1-log",null,null,null,"Inactivation \nRatio \n(CTcalc/CT99.9)",null,null,null,null,null,null,null,null,null,null,"Temp = 0.5, pH = 6-7.5","Temp = 0.5, pH = 7.5-9","Temp = 5, pH = 6-7.5","Temp = 5, pH = 7.5-9","Temp = 10, pH = 6-7.5","Temp = 10, pH = 7.5-9","Temp = 15, pH = 6-7.5","Temp = 15, pH = 7.5-9","Temp = 20, pH = 6-7.5","Temp = 20, pH = 7.5-9","Temp = 25, pH = 6-7.5","Temp = 25, pH = 7.5-9"]
[null,null,{"$f":"AG20&\"-\"&AH20","v":"Mon-1"},1,10,8,null,0.6,{"$f":"IF(E20=0,\"-\",$J$11*E20*$J$12+$J$13*$J$14)","v":12000},{"$f":"IF(OR(E20=0,D20=0,D20=\"-\"),\"-\",I20/(D20*1000000/1440))","v":17.28},{"$f":"IF(OR(D20=0,D20=\"-\",E20=0,H20<=0,G20<5),\"-\",ROUNDUP(ct(F20,G20,H20)*$J$15,0))","v":"-"},{"$f":"IF(OR($E20=0,$D20=0,D20=\"-\",$H20<=0),\"-\",J20*H20)","v":10.368},{"$f":"IF(OR($E20=0,$D20=0,$G20<=0,D20=\"-\",$H20<=0),\"-\",L20/K20)","v":"-"},{"$f":"IF(OR($E20=0,$D20=0,D20=\"-\",$H20<=0,G20<5),\"-\",$L20/$K20*$J$15)","v":"-"},{"$f":"IF(OR(D20<=0,F20<=0,H20<=0),\"-\",IF(AD20>=8,\">8.0\",AD20))","v":6.0988235294117654},null,null,null,12,400,{"$f":"PI()*(S20/12)^2/4*T20*7.4805","v":2350.0683845178451},null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(F20<=5,4*L20/(-0.9*F20+12.5),IF(F20<=15,4*L20/(-0.4*F20+10),4*L20/(-0.2*F20+7))),\"-\")","v":6.0988235294117654},null,null,{"$f":"IF(ISBLANK($AG$17),\"\",TEXT($AG$17,\"ddd\"))","v":"Mon"},1,null,1,{"$f":"$AG$51","v":{"$error":"#DIV/0!"}},{"$f":"MAX(N20:N50)","v":0},null,{"$f":"IF(F20<12.5,(0.353)*(12.006+EXP(2.46-0.073*F20+0.125*H20+0.389*G20)),(0.361)*(-2.261+EXP(2.69-0.065*F20+0.111*H20+0.361*G20)))","v":6.7217270836409497},null,null,null,{"$f":"IF(OR($E20=0,$D20=0,D20=\"-\",$H20<=0,G20<5),\"-\",N20/3)","v":"-"},null,null,null,null,null,null,null,null,null,null,1.8600000000000001E-3,1.31E-3,1.73E-3,8.3000000000000001E-4,2.8800000000000002E-3,1.1800000000000001E-3,2.7200000000000002E-3,1.5200000000000001E-3,3.96E-3,2.2100000000000002E-3,4.9100000000000003E-3,2.2300000000000002E-3]
[null,null,{"$f":"AG21&\"-\"&AH21","v":"Tue-2"},2,10,6,null,0.6,12000,{"$f":"IF(OR(E21=0,D21=0,D21=\"-\"),\"-\",I21/(D21*1000000/1440))","v":8.64},{"$f":"IF(OR(D21=0,D21=\"-\",E21=0,H21<=0,G21<5),\"-\",ROUNDUP(ct(F21,G21,H21)*$J$15,0))","v":"-"},5.1840000000000002,"-","-",2.7284210526315791,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.7284210526315791,null,null,{"$f":"IF(ISBLANK($AG$17),\"\",TEXT($AG$17+AH20,\"ddd\"))","v":"Tue"},2,null,{"$f":"AJ20+1","v":2},{"$f":"$AG$51","v":{"$error":"#DIV/0!"}},null,null,7.112140964197641,null,null,null,"-"]
[null,null,"Wed-3",3,10,10,null,1,12000,5.76,{"$f":"IF(OR(D22=0,D22=\"-\",E22=0,H22<=0,G22<5),\"-\",ROUNDUP(ct(F22,G22,H22)*$J$15,0))","v":"-"},5.76,"-","-",3.84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.84,null,null,{"$f":"IF(ISBLANK($AG$17),\"\",TEXT($AG$17+AH21,\"ddd\"))","v":"Wed"},{"$f":"AH21+1","v":3},null,{"$f":"AJ21+1","v":3},{"$error":"#DIV/0!"},null,null,6.4943874824691772,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,"USEPA equations (percent error):"]
[null,null,"Thu-4",null,null,null,null,null,"-","-",{"$f":"IF(OR(D23=0,D23=\"-\",E23=0,H23<=0,G23<5),\"-\",ROUNDUP(ct(F23,G23,H23)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Thu",{"$f":"AH22+1","v":4},null,4,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,4.2299999999999997E-2,4.7469999999999998E-2,9.2630000000000004E-2,8.2239999999999994E-2,4.6260000000000003E-2,2.2089999999999999E-2,9.6579999999999999E-2,9.6089999999999995E-2,4.4970000000000003E-2,5.0169999999999999E-2,0.11167000000000001,0.12612000000000001]
[null,null,"Fri-5",null,null,null,null,null,"-","-",{"$f":"IF(OR(D24=0,D24=\"-\",E24=0,H24<=0,G24<5),\"-\",ROUNDUP(ct(F24,G24,H24)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Fri",5,null,5,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Sat-6",null,null,null,null,null,"-","-",{"$f":"IF(OR(D25=0,D25=\"-\",E25=0,H25<=0,G25<5),\"-\",ROUNDUP(ct(F25,G25,H25)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Sat",6,null,6,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Sun-7",null,null,null,null,null,"-","-",{"$f":"IF(OR(D26=0,D26=\"-\",E26=0,H26<=0,G26<5),\"-\",ROUNDUP(ct(F26,G26,H26)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Sun",7,null,7,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Mon-8",null,null,null,null,null,"-","-",{"$f":"IF(OR(D27=0,D27=\"-\",E27=0,H27<=0,G27<5),\"-\",ROUNDUP(ct(F27,G27,H27)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Mon",8,null,8,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Tue-9",null,null,null,null,null,"-","-",{"$f":"IF(OR(D28=0,D28=\"-\",E28=0,H28<=0,G28<5),\"-\",ROUNDUP(ct(F28,G28,H28)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Tue",9,null,9,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Wed-10",null,null,null,null,null,"-","-",{"$f":"IF(OR(D29=0,D29=\"-\",E29=0,H29<=0,G29<5),\"-\",ROUNDUP(ct(F29,G29,H29)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Wed",10,null,10,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Thu-11",null,null,null,null,null,"-","-",{"$f":"IF(OR(D30=0,D30=\"-\",E30=0,H30<=0,G30<5),\"-\",ROUNDUP(ct(F30,G30,H30)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Thu",11,null,11,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Fri-12",null,null,null,null,null,"-","-",{"$f":"IF(OR(D31=0,D31=\"-\",E31=0,H31<=0,G31<5),\"-\",ROUNDUP(ct(F31,G31,H31)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Fri",12,null,12,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Sat-13",null,null,null,null,null,"-","-",{"$f":"IF(OR(D32=0,D32=\"-\",E32=0,H32<=0,G32<5),\"-\",ROUNDUP(ct(F32,G32,H32)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Sat",13,null,13,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Sun-14",null,null,null,null,null,"-","-",{"$f":"IF(OR(D33=0,D33=\"-\",E33=0,H33<=0,G33<5),\"-\",ROUNDUP(ct(F33,G33,H33)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Sun",14,null,14,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Mon-15",null,null,null,null,null,"-","-",{"$f":"IF(OR(D34=0,D34=\"-\",E34=0,H34<=0,G34<5),\"-\",ROUNDUP(ct(F34,G34,H34)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Mon",15,null,15,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Tue-16",null,null,null,null,null,"-","-",{"$f":"IF(OR(D35=0,D35=\"-\",E35=0,H35<=0,G35<5),\"-\",ROUNDUP(ct(F35,G35,H35)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Tue",16,null,16,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Wed-17",null,null,null,null,null,"-","-",{"$f":"IF(OR(D36=0,D36=\"-\",E36=0,H36<=0,G36<5),\"-\",ROUNDUP(ct(F36,G36,H36)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Wed",17,null,17,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Thu-18",null,null,null,null,null,"-","-",{"$f":"IF(OR(D37=0,D37=\"-\",E37=0,H37<=0,G37<5),\"-\",ROUNDUP(ct(F37,G37,H37)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Thu",18,null,18,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Fri-19",null,null,null,null,null,"-","-",{"$f":"IF(OR(D38=0,D38=\"-\",E38=0,H38<=0,G38<5),\"-\",ROUNDUP(ct(F38,G38,H38)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Fri",19,null,19,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Sat-20",null,null,null,null,null,"-","-",{"$f":"IF(OR(D39=0,D39=\"-\",E39=0,H39<=0,G39<5),\"-\",ROUNDUP(ct(F39,G39,H39)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Sat",20,null,20,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Sun-21",null,null,null,null,null,"-","-",{"$f":"IF(OR(D40=0,D40=\"-\",E40=0,H40<=0,G40<5),\"-\",ROUNDUP(ct(F40,G40,H40)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Sun",21,null,21,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Mon-22",null,null,null,null,null,"-","-",{"$f":"IF(OR(D41=0,D41=\"-\",E41=0,H41<=0,G41<5),\"-\",ROUNDUP(ct(F41,G41,H41)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Mon",22,null,22,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Tue-23",null,null,null,null,null,"-","-",{"$f":"IF(OR(D42=0,D42=\"-\",E42=0,H42<=0,G42<5),\"-\",ROUNDUP(ct(F42,G42,H42)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Tue",23,null,23,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Wed-24",null,null,null,null,null,"-","-",{"$f":"IF(OR(D43=0,D43=\"-\",E43=0,H43<=0,G43<5),\"-\",ROUNDUP(ct(F43,G43,H43)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Wed",24,null,24,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Thu-25",null,null,null,null,null,"-","-",{"$f":"IF(OR(D44=0,D44=\"-\",E44=0,H44<=0,G44<5),\"-\",ROUNDUP(ct(F44,G44,H44)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Thu",25,null,25,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Fri-26",null,null,null,null,null,"-","-",{"$f":"IF(OR(D45=0,D45=\"-\",E45=0,H45<=0,G45<5),\"-\",ROUNDUP(ct(F45,G45,H45)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Fri",26,null,26,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Sat-27",null,null,null,null,null,"-","-",{"$f":"IF(OR(D46=0,D46=\"-\",E46=0,H46<=0,G46<5),\"-\",ROUNDUP(ct(F46,G46,H46)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Sat",27,null,27,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Sun-28",null,null,null,null,null,"-","-",{"$f":"IF(OR(D47=0,D47=\"-\",E47=0,H47<=0,G47<5),\"-\",ROUNDUP(ct(F47,G47,H47)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Sun",28,null,28,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Mon-29",null,null,null,null,null,"-","-",{"$f":"IF(OR(D48=0,D48=\"-\",E48=0,H48<=0,G48<5),\"-\",ROUNDUP(ct(F48,G48,H48)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Mon",29,null,29,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Tue-30",null,null,null,null,null,"-","-",{"$f":"IF(OR(D49=0,D49=\"-\",E49=0,H49<=0,G49<5),\"-\",ROUNDUP(ct(F49,G49,H49)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Tue",30,null,30,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Wed-31",null,null,null,null,null,"-","-",{"$f":"IF(OR(D50=0,D50=\"-\",E50=0,H50<=0,G50<5),\"-\",ROUNDUP(ct(F50,G50,H50)*$J$15,0))","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,"Wed",31,null,31,{"$error":"#DIV/0!"},null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Min",{"$f":"MIN(D20:D50)","v":1},10,6,0,0.6,12000,5.76,{"$f":"MIN(K20:K50)","v":0},{"$f":"MIN(L20:L50)","v":5.1840000000000002},{"$f":"MIN(M20:M50)","v":0},{"$f":"MIN(N20:N50)","v":0},{"$f":"IF(MIN(AD20:AD50)>8,\">8.0\",MIN(AD20:AD50))","v":2.7284210526315791},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average Giardia:",{"$f":"AVERAGE(N20:N50)","v":{"$error":"#DIV/0!"}},null,null,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,{"$f":"MIN(AR20:AR50)","v":0}]
[null,null,"Median",{"$f":"IF(SUM(D20:D50)<=0,0,MEDIAN(D20:D50))","v":2},{"$f":"IF(SUM(E20:E50)<=0,0,MEDIAN(E20:E50))","v":10},{"$f":"IF(SUM(F20:F50)<=0,0,MEDIAN(F20:F50))","v":8},{"$f":"IF(SUM(G20:G50)<=0,0,MEDIAN(G20:G50))","v":0},{"$f":"IF(SUM(H20:H50)<=0,0,MEDIAN(H20:H50))","v":0.6},{"$f":"IF(SUM(I20:I50)<=0,0,MEDIAN(I20:I50))","v":12000},{"$f":"IF(SUM(J20:J50)<=0,0,MEDIAN(J20:J50))","v":8.64},0,5.76,{"$f":"IF(SUM(M20:M50)<=0,0,MEDIAN(M20:M50))","v":0},{"$f":"IF(SUM(N20:N50)<=0,0,MEDIAN(N20:N50))","v":0},{"$f":"IF(MEDIAN(AD20:AD50)>8,\">8.0\",MEDIAN(AD20:AD50))","v":3.84},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AR20:AR50)<=0,0,MEDIAN(AR20:AR50))","v":0}]
[null,null,"Max",{"$f":"MAX(D20:D50)","v":3},{"$f":"MAX(E20:E50)","v":10},{"$f":"MAX(F20:F50)","v":10},{"$f":"MAX(G20:G50)","v":0},{"$f":"MAX(H20:H50)","v":1},{"$f":"MAX(I20:I50)","v":12000},{"$f":"MAX(J20:J50)","v":17.28},0,10.368,{"$f":"MAX(M20:M50)","v":0},{"$f":"MAX(N20:N50)","v":0},{"$f":"IF(MAX(AD20:AD50)>8,\">8.0\",MAX(AD20:AD50))","v":6.0988235294117654},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(AR20:AR50)","v":0}]
[]
[null,null,"Print Name:",null,null,null,null,null,null,null,null,"Certification Grade:"]
[null,null,"Signature:",null,null,null,null,null,null,"Date:"]
[]
[null,null,"1 Note:  If flow is approximately constant over a 24 hour period,"]
[null,null," then use lowest chlorine residual and temperature values.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Equation:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"pH = 6 - 7.5, Temp. =0.5 - 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"pH = 7.5 - 9, Temp. =0.5 - 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"pH = 6 - 7.5,\nTemp. =5 - 10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"pH = 7.5 - 9, Temp. =5 - 10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"pH = 6 - 7.5, \nTemp. =10 - 15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"pH = 7.5 - 9,\nTemp. =10 - 15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"pH = 6 - 7.5,\nTemp. =15 - 20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"pH = 7.5 - 9,\nTemp. =15 - 20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"pH = 6 - 7.5,\nTemp. =20 - 25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"pH = 7.5 - 9, Temp. =20 - 25"]