{"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":68,"n_cols":65,"rows_kept":68,"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,"Giardia Lamblia Cysts by Free Chlorine"]
[]
[null,null,"Input Parameters:"]
[null,null,"Water System Name:",null,null,null,null,null,null,null,"Enter Name"]
[null,null,"Number of Service Connections:",null,null,null,null,null,null,null,"Enter Number"]
[null,null,"System Number:",null,null,null,null,null,null,null,"Enter Number"]
[null,null,"Month and Year:",null,null,null,null,null,null,null,"2020-06-01"]
[null,null,"Clearwell(s) - Volume per Foot:",null,null,null,null,null,null,null,8500,"Gallons/Ft"]
[null,null,"Short-Circuiting Factor for Clearwell(s):",null,null,null,null,null,null,null,0.2,"t10/T (baffling factor, BF)"]
[null,null,"Transmission Pipe - Volume:",null,null,null,null,null,null,null,2000,"Gallons"]
[null,null,"Short-Circuiting Factor for Pipe:",null,null,null,null,null,null,null,1,"t10/T (baffling factor, BF)"]
[null,null,"Required Log Inactivation of Giardia Cyst:",null,null,null,null,null,null,null,0.5,"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,{"$f":"DATE(AF17,AG17,AG16)","v":"2020-06-01"},1]
[null,null,null,"Reactor Data for Peak Hourly Flow1",null,null,null,null,"Ct10 Dose and Giardia cyst Log Inactivation Results ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(K9)","v":2020},{"$f":"MONTH($K$9)","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(gpm)","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",null,null,null,"Pipe \nDiameter\ninch","Pipe\nLength\nft","Pipe\nVolume\nCalc. gal",null,null,null,null,null,null,null,null,null,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":"AF19&\"-\"&AG19","v":"Mon-1"},300,10,10,8,0.6,{"$f":"IF(E19=0,\"-\",$K$10*E19*$K$11+$K$12*$K$13)","v":19000},{"$f":"IF(OR(E19=0,D19=0,D19=\"-\"),\"-\",I19/(D19))","v":63.333333333333336},{"$f":"IF(OR(D19=0,D19=\"-\",E19=0,H19<=0,G19<5),\"-\",ROUNDUP(ct(F19,G19,H19)*$K$14,0))","v":26},{"$f":"IF(OR($E19=0,$D19=0,D19=\"-\",$H19<=0),\"-\",J19*H19)","v":38},{"$f":"IF(OR($E19=0,$D19=0,$G19<=0,D19=\"-\",$H19<=0),\"-\",L19/K19)","v":1.4615384615384615},{"$f":"IF(OR($E19=0,$D19=0,D19=\"-\",$H19<=0,G19<5),\"-\",$L19/$K19*$K$14)","v":0.73076923076923073},null,null,null,6,1200,{"$f":"PI()*(R19/12)^2/4*S19*7.4805","v":1762.5512883883835},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($AF$16),\"\",TEXT($AF$16,\"ddd\"))","v":"Mon"},1,null,1,{"$f":"$AF$50","v":3.2984984424372055},{"$f":"MAX(N19:N49)","v":12.606534090909092},null,{"$f":"IF(F19<12.5,(0.353)*(12.006+EXP(2.46-0.073*F19+0.125*H19+0.389*G19)),(0.361)*(-2.261+EXP(2.69-0.065*F19+0.111*H19+0.361*G19)))","v":52.455172098644589},null,null,null,{"$f":"IF(OR($E19=0,$D19=0,D19=\"-\",$H19<=0,G19<5),\"-\",N19/3)","v":0.24358974358974358},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":"AF20&\"-\"&AG20","v":"Tue-2"},482,10,13.9,7.68,1.49,{"$f":"IF(E20=0,\"-\",$K$10*E20*$K$11+$K$12*$K$13)","v":19000},{"$f":"IF(OR(E20=0,D20=0,D20=\"-\"),\"-\",I20/(D20))","v":39.419087136929463},{"$f":"IF(OR(D20=0,D20=\"-\",E20=0,H20<=0,G20<5),\"-\",ROUNDUP(ct(F20,G20,H20)*$K$14,0))","v":19},58.734439834024897,3.091286307053942,1.545643153526971,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($AF$16),\"\",TEXT($AF$16+AG19,\"ddd\"))","v":"Tue"},2,null,{"$f":"AI19+1","v":2},{"$f":"$AF$50","v":3.2984984424372055},null,null,39.853858690161665,null,null,null,0.51521438450899038]
[null,null,"Wed-3",200,6.5,12,7.3,0.74,13050,65.25,{"$f":"IF(OR(D21=0,D21=\"-\",E21=0,H21<=0,G21<5),\"-\",ROUNDUP(ct(F21,G21,H21)*$K$14,0))","v":18},48.284999999999997,2.6824999999999997,1.3412499999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($AF$16),\"\",TEXT($AF$16+AG20,\"ddd\"))","v":"Wed"},{"$f":"AG20+1","v":3},null,{"$f":"AI20+1","v":3},3.2984984424372055,null,null,36.533129576684928,null,null,null,0.44708333333333328,null,null,null,null,null,null,null,null,null,null,"USEPA equations (percent error):"]
[null,null,"Thu-4",101,3,12,7.3,0.75,7100,70.297029702970292,{"$f":"IF(OR(D22=0,D22=\"-\",E22=0,H22<=0,G22<5),\"-\",ROUNDUP(ct(F22,G22,H22)*$K$14,0))","v":18},52.722772277227719,2.9290429042904287,1.4645214521452143,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu",{"$f":"AG21+1","v":4},null,4,3.2984984424372055,null,null,36.573523582149555,null,null,null,0.4881738173817381,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",6.4,3,12,8,0.5,7100,1109.375,{"$f":"IF(OR(D23=0,D23=\"-\",E23=0,H23<=0,G23<5),\"-\",ROUNDUP(ct(F23,G23,H23)*$K$14,0))","v":22},554.6875,25.213068181818183,12.606534090909092,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fri",5,null,5,3.2984984424372055,null,null,45.387659214133066,null,null,null,4.2021780303030303]
[null,null,"Sat-6",null,null,null,null,null,"-","-",{"$f":"IF(OR(D24=0,D24=\"-\",E24=0,H24<=0,G24<5),\"-\",ROUNDUP(ct(F24,G24,H24)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sat",6,null,6,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Sun-7",null,null,null,null,null,"-","-",{"$f":"IF(OR(D25=0,D25=\"-\",E25=0,H25<=0,G25<5),\"-\",ROUNDUP(ct(F25,G25,H25)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sun",7,null,7,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Mon-8",8,1,5,8,0.3,3700,462.5,{"$f":"IF(OR(D26=0,D26=\"-\",E26=0,H26<=0,G26<5),\"-\",ROUNDUP(ct(F26,G26,H26)*$K$14,0))","v":33},138.75,4.2045454545454541,2.1022727272727271,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mon",8,null,8,3.2984984424372055,null,null,71.139041950036017,null,null,null,0.70075757575757569]
[null,null,"Tue-9",null,null,null,null,null,"-","-",{"$f":"IF(OR(D27=0,D27=\"-\",E27=0,H27<=0,G27<5),\"-\",ROUNDUP(ct(F27,G27,H27)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tue",9,null,9,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Wed-10",null,null,null,null,null,"-","-",{"$f":"IF(OR(D28=0,D28=\"-\",E28=0,H28<=0,G28<5),\"-\",ROUNDUP(ct(F28,G28,H28)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wed",10,null,10,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Thu-11",null,null,null,null,null,"-","-",{"$f":"IF(OR(D29=0,D29=\"-\",E29=0,H29<=0,G29<5),\"-\",ROUNDUP(ct(F29,G29,H29)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu",11,null,11,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Fri-12",null,null,null,null,null,"-","-",{"$f":"IF(OR(D30=0,D30=\"-\",E30=0,H30<=0,G30<5),\"-\",ROUNDUP(ct(F30,G30,H30)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fri",12,null,12,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Sat-13",null,null,null,null,null,"-","-",{"$f":"IF(OR(D31=0,D31=\"-\",E31=0,H31<=0,G31<5),\"-\",ROUNDUP(ct(F31,G31,H31)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sat",13,null,13,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Sun-14",null,null,null,null,null,"-","-",{"$f":"IF(OR(D32=0,D32=\"-\",E32=0,H32<=0,G32<5),\"-\",ROUNDUP(ct(F32,G32,H32)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sun",14,null,14,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Mon-15",null,null,null,null,null,"-","-",{"$f":"IF(OR(D33=0,D33=\"-\",E33=0,H33<=0,G33<5),\"-\",ROUNDUP(ct(F33,G33,H33)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mon",15,null,15,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Tue-16",null,null,null,null,null,"-","-",{"$f":"IF(OR(D34=0,D34=\"-\",E34=0,H34<=0,G34<5),\"-\",ROUNDUP(ct(F34,G34,H34)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tue",16,null,16,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Wed-17",null,null,null,null,null,"-","-",{"$f":"IF(OR(D35=0,D35=\"-\",E35=0,H35<=0,G35<5),\"-\",ROUNDUP(ct(F35,G35,H35)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wed",17,null,17,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Thu-18",null,null,null,null,null,"-","-",{"$f":"IF(OR(D36=0,D36=\"-\",E36=0,H36<=0,G36<5),\"-\",ROUNDUP(ct(F36,G36,H36)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu",18,null,18,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Fri-19",null,null,null,null,null,"-","-",{"$f":"IF(OR(D37=0,D37=\"-\",E37=0,H37<=0,G37<5),\"-\",ROUNDUP(ct(F37,G37,H37)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fri",19,null,19,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Sat-20",null,null,null,null,null,"-","-",{"$f":"IF(OR(D38=0,D38=\"-\",E38=0,H38<=0,G38<5),\"-\",ROUNDUP(ct(F38,G38,H38)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sat",20,null,20,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Sun-21",null,null,null,null,null,"-","-",{"$f":"IF(OR(D39=0,D39=\"-\",E39=0,H39<=0,G39<5),\"-\",ROUNDUP(ct(F39,G39,H39)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sun",21,null,21,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Mon-22",null,null,null,null,null,"-","-",{"$f":"IF(OR(D40=0,D40=\"-\",E40=0,H40<=0,G40<5),\"-\",ROUNDUP(ct(F40,G40,H40)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mon",22,null,22,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Tue-23",null,null,null,null,null,"-","-",{"$f":"IF(OR(D41=0,D41=\"-\",E41=0,H41<=0,G41<5),\"-\",ROUNDUP(ct(F41,G41,H41)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tue",23,null,23,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Wed-24",null,null,null,null,null,"-","-",{"$f":"IF(OR(D42=0,D42=\"-\",E42=0,H42<=0,G42<5),\"-\",ROUNDUP(ct(F42,G42,H42)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wed",24,null,24,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Thu-25",null,null,null,null,null,"-","-",{"$f":"IF(OR(D43=0,D43=\"-\",E43=0,H43<=0,G43<5),\"-\",ROUNDUP(ct(F43,G43,H43)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu",25,null,25,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Fri-26",null,null,null,null,null,"-","-",{"$f":"IF(OR(D44=0,D44=\"-\",E44=0,H44<=0,G44<5),\"-\",ROUNDUP(ct(F44,G44,H44)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fri",26,null,26,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Sat-27",null,null,null,null,null,"-","-",{"$f":"IF(OR(D45=0,D45=\"-\",E45=0,H45<=0,G45<5),\"-\",ROUNDUP(ct(F45,G45,H45)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sat",27,null,27,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Sun-28",null,null,null,null,null,"-","-",{"$f":"IF(OR(D46=0,D46=\"-\",E46=0,H46<=0,G46<5),\"-\",ROUNDUP(ct(F46,G46,H46)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sun",28,null,28,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Mon-29",null,null,null,null,null,"-","-",{"$f":"IF(OR(D47=0,D47=\"-\",E47=0,H47<=0,G47<5),\"-\",ROUNDUP(ct(F47,G47,H47)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mon",29,null,29,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Tue-30",null,null,null,null,null,"-","-",{"$f":"IF(OR(D48=0,D48=\"-\",E48=0,H48<=0,G48<5),\"-\",ROUNDUP(ct(F48,G48,H48)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tue",30,null,30,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Wed-31",null,null,null,null,null,"-","-",{"$f":"IF(OR(D49=0,D49=\"-\",E49=0,H49<=0,G49<5),\"-\",ROUNDUP(ct(F49,G49,H49)*$K$14,0))","v":"-"},"-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wed",31,null,31,3.2984984424372055,null,null,8.369916473613241,null,null,null,"-"]
[null,null,"Min",{"$f":"MIN(D19:D49)","v":6.4},1,5,7.3,0.3,3700,39.419087136929463,{"$f":"MIN(K19:K49)","v":18},{"$f":"MIN(L19:L49)","v":38},{"$f":"MIN(M19:M49)","v":1.4615384615384615},{"$f":"MIN(N19:N49)","v":0.73076923076923073},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average Giardia:",{"$f":"AVERAGE(N19:N49)","v":3.2984984424372055},null,null,null,3.2984984424372055,null,null,null,null,null,null,{"$f":"MIN(AQ19:AQ49)","v":0.24358974358974358}]
[null,null,"Median",{"$f":"IF(SUM(D19:D49)<=0,0,MEDIAN(D19:D49))","v":150.5},{"$f":"IF(SUM(E19:E49)<=0,0,MEDIAN(E19:E49))","v":4.75},{"$f":"IF(SUM(F19:F49)<=0,0,MEDIAN(F19:F49))","v":12},{"$f":"IF(SUM(G19:G49)<=0,0,MEDIAN(G19:G49))","v":7.84},{"$f":"IF(SUM(H19:H49)<=0,0,MEDIAN(H19:H49))","v":0.66999999999999993},{"$f":"IF(SUM(I19:I49)<=0,0,MEDIAN(I19:I49))","v":10075},{"$f":"IF(SUM(J19:J49)<=0,0,MEDIAN(J19:J49))","v":67.773514851485146},20.5,55.728606055626308,{"$f":"IF(SUM(M19:M49)<=0,0,MEDIAN(M19:M49))","v":3.0101646056721854},1.5050823028360927,null,null,null,null,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(AQ19:AQ49)<=0,0,MEDIAN(AQ19:AQ49))","v":0.50169410094536426}]
[null,null,"Max",{"$f":"MAX(D19:D49)","v":482},{"$f":"MAX(E19:E49)","v":10},{"$f":"MAX(F19:F49)","v":13.9},{"$f":"MAX(G19:G49)","v":8},{"$f":"MAX(H19:H49)","v":1.49},{"$f":"MAX(I19:I49)","v":19000},{"$f":"MAX(J19:J49)","v":1109.375},33,554.6875,{"$f":"MAX(M19:M49)","v":25.213068181818183},12.606534090909092,null,null,null,null,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(AQ19:AQ49)","v":4.2021780303030303}]
[]
[null,null,"Print Name:",null,null,null,null,null,null,null,null,null,"Certification Grade:"]
[null,null,"Signature:",null,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 maximum pH value and 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,"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,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,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,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,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,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,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,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,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,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,10,"pH = 7.5 - 9, Temp. =20 - 25"]