{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["CT Data","GiardiaGraph","ViruseGraph"],"not_rendered":{"charts":4,"images":1,"macros":0,"external_links":0,"defined_names":6,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"GiardiaGraph","index":1,"reason":"not_a_worksheet"},{"sheet":"ViruseGraph","index":2,"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":59,"n_cols":92,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[null,null,"Author:  Guy Schott, guy.schott@waterboards.ca.gov, 707-576-2732, updated 5/27/20"]
[null,null,"CT Compliance for "]
[null,null,"Cryptosporidium, Giardia Lamblia Cysts & Virus"]
[null,null,"by Chlorine Dioxide Disinfection"]
[]
[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-07-01"]
[null,null,"Clearwell(s) - Volume per Foot:",null,null,null,null,null,null,100000,"Gallons/Ft"]
[null,null,"Short-Circuiting Factor for Clearwell(s):",null,null,null,null,null,null,0.1,"t10/T (baffling factor, BF)"]
[null,null,"Transmission Pipe - Volume",null,null,null,null,null,null,5000,"Gallons"]
[null,null,"Short-Circuiting Factor for Transmission Pipe:",null,null,null,null,null,null,0.9,"t10/T (baffling factor, BF)"]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(AX17,AY17,AY16)","v":"2020-07-01"},1]
[null,null,null,"Reactor Data for Peak Hourly Flow1",null,null,null,"Ct10 Dose and Log Inactivation Results ","Ct10 Dose and Log Inactivation Results (pH: 6-9)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"YEAR(J10)","v":2020},{"$f":"MONTH($J$10)","v":7},null,null,null,null,null,null,null,null,"Virus Table for 4 log",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Giardia "]
[null,null,"Date","Flow \nRate\n(gpm)","Tank\nLowest \nLevel\n(ft)","Water\nTemp\n(oC)","ClO2\nResidual\n(mg/L)","ClO2-\nResidual, \nmg/L","Effective \nVolume\n(BF • Vol)\n(gallons)","Effective \nContact Time\n(minutes)","Delivered \nDose\nCt10\n(mg/L•min)","Crypto\nLog \nInactivation","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,null,"Log\nVirus","CT\nVirus",1,2,null,"1-5, Log",1,2,null,"5-20, Log",1,2,null,"20-25, Log",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,null,null,"Required Log Inactivation:",0.5,3.5,null,null,"Log \nInactivation"]
[null,null,{"$f":"AX19&\"-\"&AY19","v":"Wed-1"},1000,5,5,0.7,0.8,{"$f":"IF(D19<=0,\"-\",$J$11*E19*$J$12+$J$13*$J$14)","v":54500},{"$f":"IF(D19=0,\"-\",I19/(D19))","v":54.5},{"$f":"IF(OR($D19<=0,$G19<=0),\"-\",J19*G19)","v":38.15},{"$f":"IF(OR($D19<=0,$G19<=0),\"-\", (0.001506*(1.09116^F19)*K19))","v":8.8871334133226565E-2},{"$f":"IF(OR($D19<=0,$G19<=0),\"-\", IF(CN19>8,\">8.0\",CN19))","v":4.3749999999999991},{"$f":"IF(OR($D19<=0,$G19<=0),\"-\",IF(K19>AE19,\">4.0\",IF(F19<=5,AI19,IF(F19<=20,AM19,AQ19))))","v":">4.0"},null,null,null,12,400,{"$f":"PI()*(R19/12)^2/4*S19*7.4805","v":2350.0683845178451},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($E19=0,$D19=0,$G19<=0),\"-\", 4*K19/AE19)","v":4.568862275449102},{"$f":"IF(F19<1,\"-\",HLOOKUP(F19,$BH$18:$CF$19,2))","v":33.4},{"$f":"-0.00001929*F19^2-0.00000929*F19-0.000392","v":-9.2069999999999999E-4},{"$f":"0.00093714*F19^2+0.00328714*F19+0.068062","v":0.1079262},1.4244000000000001,{"$f":"IF(D19<=0,\"-\",AF19*$K19^2+AG19*$K19+AH19)","v":4.20177703425},{"$f":"-0.00000004*F19^4+0.00000159*F19^3-0.00004328*F19^2+0.00030334*F19-0.00156149","v":-9.5304000000000016E-4},{"$f":"-0.00002*F19^3+0.001177*F19^2-0.007005*F19+0.117161","v":0.10906100000000001},1.4248000000000001,{"$f":"IF(D19<=0,\"-\",AJ19*$K19^2+AK19*$K19+AL19)","v":4.1984012905999997},{"$f":"-0.000171*F19^2+0.006151*F19-0.061302","v":-3.4822000000000006E-2},{"$f":"0.002057*F19^2-0.065201*F19+0.770529","v":0.49594900000000003},1.426585,{"$f":"IF(D19<=0,\"-\",AN19*$K19^2+AO19*$K19+AP19)","v":-30.333682945000003},null,null,null,null,null,null,{"$f":"IF(ISBLANK($AX$16),\"\",TEXT(AX16,\"ddd\"))","v":"Wed"},1,null,0.5,0.5,null,null,{"$f":"$BE$53","v":11.43348623853211},{"$f":"$BF$53","v":"-"},null,50.1,45.9,41.8,37.6,33.4,31.7,30.1,28.4,26.8,25.1,23.4,21.7,20.100000000000001,18.399999999999999,16.7,15.9,15,14.2,13.3,12.5,11.7,10.9,10,9.1999999999999993,8.4,null,null,null,null,null,null,null,{"$f":"IF(OR($D19=0,$G19<=0),\"-\",IF(F19<=5,K19/(-3.07*F19+24.07),K19/(-0.2561*F19+10.137)))","v":4.3749999999999991}]
[null,null,"Sun-2",200,6,5,0.5,0.6,{"$f":"IF(D20<=0,\"-\",$J$11*E20*$J$12+$J$13*$J$14)","v":64500},{"$f":"IF(D20=0,\"-\",I20/(D20))","v":322.5},{"$f":"IF(OR($D20<=0,$G20<=0),\"-\",J20*G20)","v":161.25},{"$f":"IF(OR($D20<=0,$G20<=0),\"-\", (0.001506*(1.09116^F20)*K20))","v":0.37563571766665227},{"$f":"IF(OR($D20<=0,$G20<=0),\"-\", IF(CN20>8,\">8.0\",CN20))","v":">8.0"},{"$f":"IF(OR($D20<=0,$G20<=0),\"-\",IF(K20>AE20,\">4.0\",IF(F20<=5,AI20,IF(F20<=20,AM20,AQ20))))","v":">4.0"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($E20=0,$D20=0,$G20<=0),\"-\", 4*K20/AE20)","v":19.311377245508982},33.4,-9.2069999999999999E-4,0.1079262,1.4244000000000001,-5.1121388437500013,-9.5304000000000016E-4,0.10906100000000001,1.4248000000000001,-5.7696428750000033,-3.4822000000000006E-2,0.49594900000000003,1.426585,-824.02804812500005,null,null,null,null,null,null,{"$f":"IF(ISBLANK($AX$16),\"\",TEXT($AVN$16+AY19,\"ddd\"))","v":"Sun"},2,null,1,1,null,null,11.43348623853211,"-",null,null,null,null,null,null,null,null,null,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(OR($D20=0,$G20<=0),\"-\",IF(F20<=5,K20/(-3.07*F20+24.07),K20/(-0.2561*F20+10.137)))","v":18.49197247706422}]
[null,null,"Mon-3",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,{"$f":"IF(ISBLANK($AX$16),\"\",TEXT($AVN$16+AY20,\"ddd\"))","v":"Mon"},{"$f":"AY20+1","v":3},null,1.5,1.5,null,null,11.43348623853211,"-",null,"Temp",2,3,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Tue-4",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Tue",{"$f":"AY21+1","v":4},null,2,2,null,null,11.43348623853211,"-",null,1,8.4,25.6,50.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Wed-5",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Wed",5,null,2.5,2.5,null,null,11.43348623853211,"-",null,2,7.7,23.5,45.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Thu-6",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Thu",6,null,3,3,null,null,11.43348623853211,"-",null,3,7,21.4,41.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Fri-7",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Fri",7,null,null,3.5,null,null,11.43348623853211,"-",null,4,6.3,19.2,37.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Sat-8",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Sat",8,null,null,4,null,null,11.43348623853211,"-",null,5,5.6,17.100000000000001,33.4,null,null,null,null,null,null,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":"AX27&\"-\"&AY27","v":"Sun-9"},null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Sun",{"$f":"AY26+1","v":9},null,null,null,null,null,11.43348623853211,"-",null,6,5.3,16.2,31.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Mon-10",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Mon",10,null,null,null,null,null,11.43348623853211,"-",null,7,5,15.4,30.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Tue-11",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Tue",11,null,null,null,null,null,11.43348623853211,"-",null,8,4.8,14.5,28.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Wed-12",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Wed",12,null,null,null,null,null,11.43348623853211,"-",null,9,4.5,13.7,26.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Thu-13",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Thu",13,null,null,null,null,null,11.43348623853211,"-",null,10,4.2,12.8,25.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Fri-14",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Fri",14,null,null,null,null,null,11.43348623853211,"-",null,11,3.9,12,23.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Sat-15",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Sat",15,null,null,null,null,null,11.43348623853211,"-",null,12,3.6,11.1,21.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Sun-16",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Sun",16,null,null,null,null,null,11.43348623853211,"-",null,13,3.4,10.3,20.100000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Mon-17",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Mon",17,null,null,null,null,null,11.43348623853211,"-",null,14,3.1,9.4,18.399999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Tue-18",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Tue",18,null,null,null,null,null,11.43348623853211,"-",null,15,2.8,8.6,16.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Wed-19",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Wed",19,null,null,null,null,null,11.43348623853211,"-",null,16,2.7,8.1999999999999993,15.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Thu-20",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Thu",20,null,null,null,null,null,11.43348623853211,"-",null,17,2.5,7.7,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,"Fri-21",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Fri",21,null,null,null,null,null,11.43348623853211,"-",null,18,2.4,7.3,14.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Sat-22",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Sat",22,null,null,null,null,null,11.43348623853211,"-",null,19,2.2000000000000002,6.8,13.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Sun-23",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Sun",23,null,null,null,null,null,11.43348623853211,"-",null,20,2.1,6.4,12.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,"Mon-24",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Mon",24,null,null,null,null,null,11.43348623853211,"-",null,21,2,6,11.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Tue-25",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Tue",25,null,null,null,null,null,11.43348623853211,"-",null,22,1.8,5.6,10.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Wed-26",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Wed",26,null,null,null,null,null,11.43348623853211,"-",null,23,1.7,5.0999999999999996,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,"Thu-27",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Thu",27,null,null,null,null,null,11.43348623853211,"-",null,24,1.5,4.7,9.1999999999999993,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Fri-28",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Fri",28,null,null,null,null,null,11.43348623853211,"-",null,25,1.4,4.3,8.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Sat-29",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Sat",29,null,null,null,null,null,11.43348623853211,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Sun-30",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Sun",30,null,null,null,null,null,11.43348623853211,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Mon-31",null,null,null,null,null,"-","-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",-3.9199999999999999E-4,6.8061999999999998E-2,1.4244000000000001,"-",-1.56149E-3,0.117161,1.4248000000000001,"-",-6.1302000000000002E-2,0.77052900000000002,1.426585,"-",null,null,null,null,null,null,"Mon",31,null,null,null,null,null,11.43348623853211,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,"Min",{"$f":"MIN(D19:D49)","v":200},5,5,0.5,0.6,54500,54.5,{"$f":"MIN(K19:K49)","v":38.15},{"$f":"MIN(L19:L49)","v":8.8871334133226565E-2},{"$f":"MIN(M19:M49)","v":4.3749999999999991},{"$f":"IF(AND(MIN(N19:N49) = 0,N51=\">4.0\"),\">4.0\",MIN(N19:N49))","v":">4.0"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"MIN(CN19:CN49)","v":4.3749999999999991}]
[null,null,"Median",{"$f":"IF(SUM(D19:D49)<=0,0,MEDIAN(D19:D49))","v":600},{"$f":"IF(SUM(E19:E49)<=0,0,MEDIAN(E19:E49))","v":5.5},{"$f":"IF(SUM(F19:F49)<=0,0,MEDIAN(F19:F49))","v":5},{"$f":"IF(SUM(G19:G49)<=0,0,MEDIAN(G19:G49))","v":0.6},{"$f":"IF(SUM(H19:H49)<=0,0,MEDIAN(H19:H49))","v":0.7},{"$f":"IF(SUM(I19:I49)<=0,0,MEDIAN(I19:I49))","v":59500},{"$f":"IF(SUM(J19:J49)<=0,0,MEDIAN(J19:J49))","v":188.5},99.699999999999989,{"$f":"IF(SUM(L19:L49)<=0,\"-\",MEDIAN(L19:L49))","v":0.23225352589993942},{"$f":"IF(SUM(M19:M49)<=0,\"-\",MEDIAN(M19:M49))","v":4.3749999999999991},{"$f":"IF(SUM(AD19:AD49)<=0,\"-\",IF(MEDIAN(AD19:AD49)>4,\">4.0\",MEDIAN(AD19:AD49)))","v":">4.0"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(CN19:CN49)<=0,0,MEDIAN(CN19:CN49))","v":11.433486238532108}]
[null,null,"Max",{"$f":"MAX(D19:D49)","v":1000},{"$f":"MAX(E19:E49)","v":6},{"$f":"MAX(F19:F49)","v":5},{"$f":"MAX(G19:G49)","v":0.7},{"$f":"MAX(H19:H49)","v":0.8},{"$f":"MAX(I19:I49)","v":64500},{"$f":"MAX(J19:J49)","v":322.5},161.25,{"$f":"MAX(L19:L49)","v":0.37563571766665227},{"$f":"IF(MAX(CN19:CN49)>8,\">8.0\",MAX(CN18:CN49))","v":">8.0"},{"$f":"IF(MAX(AD19:AD49)>4,\">4.0\",MAX(AD19:AD49))","v":">4.0"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(CN19:CN49)","v":18.49197247706422}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average:",{"$f":"IF(SUM(CN19:CN49)=0,\"-\",AVERAGE(CN19:CN49))","v":11.43348623853211},{"$f":"IF(SUM(N19:N49)=0,\"-\",AVERAGE(N19:N49))","v":"-"}]
[]
[null,null,"Print Name:",null,null,null,null,null,null,null,null,null,"Certification Grade:",5]
[null,null,"Signature:",null,null,null,null,null,null,null,"Date:","2020-06-06"]
[]
[null,null,"1 Note:  If flow is approximately constant over a 24 hour period,"]
[null,null," then use maximum pH value and lowest chlorine residual and temperature values."]