{"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":58,"n_cols":39,"rows_kept":58,"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,"Giardia Lamblia Cysts & Virus by Chloramines"]
[]
[null,null,"Input Parameters:"]
[null,null,"Water System Name:",null,null,null,null,null,"Enter Name"]
[null,null,"Number of Service Connections:",null,null,null,null,null,"Enter number"]
[null,null,"System Number:",null,null,null,null,null,"Enter number"]
[null,null,"Month and Year:",null,null,null,null,null,"2020-07-01"]
[null,null,"Clearwell(s) - Volume per Foot:",null,null,null,null,null,50000,"Gallons/Ft"]
[null,null,"Short-Circuiting Factor for Clearwell(s):",null,null,null,null,null,1,"t10/T (baffling factor, BF)"]
[null,null,"Transmission Pipe - Volume:",null,null,null,null,null,2000,"Gallons"]
[null,null,"Short-Circuiting Factor for Transmission Pipe:",null,null,null,null,null,0.9,"t10/T (baffling factor, BF)"]
[]
[null,null,null,null,null,null,null,null,null,"Required Log Inactivation:",0.5,2]
[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,{"$f":"DATE(AE17,AF17,AF16)","v":"2020-07-01"},1]
[null,null,null,"Reactor Data for Peak Hourly Flow1",null,null,null,"Ct10 Dose and 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(I9)","v":2020},{"$f":"MONTH($I$9)","v":7}]
[null,null,"Date","Flow \nRate\n(gpm)","Tank\nLowest \nLevel\n(ft)","Water\nTemp\n(oC)","Chloramine\nResidual\n(mg/L)","Effective \nVolume\n(BF • Vol)\n(gallons)","Effective \nContact Time\n(minutes)","Delivered \nDose\nCt10\n(mg/L•min)","Giardia\nLog \nInactivation","Virus\nLog \nInactivation",null,null,null,"Pipe \nDiameter\ninch","Pipe\nLength\nft","Pipe\nVolume\nCalc. gal"]
[null,null,{"$f":"AE19&\"-\"&AF19","v":"Wed-1"},49,2,15,0.2,{"$f":"IF(D19<=0,\"-\",$I$10*E19*$I$11+$I$12*$I$13)","v":101800},{"$f":"IF(D19<=0,\"-\",H19/(D19))","v":2077.5510204081634},{"$f":"IF(OR($D19<=0,$G19<=0),\"-\",I19*G19)","v":415.51020408163271},{"$f":"IF(OR($D19<=0,$G19<=0),\"-\",IF($F19<=5,$J19/((-400*$F19+4200)/3),$J19/((0.00507*$F19^4-0.2752*$F19^3+4.88559*$F19^2-104.44259*$F19+2632.3837)/3)))","v":0.83498863598989825},{"$f":"IF(OR($D19<=0,$G19<=0),\"-\",IF(F19<=10,(-2.11111*10^-6*F19^2+1.49667*10^-4*F19+1.07244*10^-3)*J19+(-2*10^-5*F19^2+0.0001*F19+0.484),IF(F19<=12,(1.815*10^-4*F19+5.43*10^-4)*J19+(0.0002*F19+0.4814),(2.18115*10^-6*F19^3-1.07089*10^-4*F19^2+1.96496*10^-3*F19-9.20665*10^-3)*J19+(-3*10^-6*F19^3+7*10^-5*F19^2+0.0004*F19+0.4736))))","v":1.953682209183673},null,null,null,12,400,{"$f":"PI()*(P19/12)^2/4*Q19*7.4805","v":2350.0683845178451},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($AE$16),\"\",TEXT($AE$16,\"ddd\"))","v":"Wed"},1,null,0.5,0.5,null,null,{"$f":"$AL$53","v":0.83498863598989825},{"$f":"$AM$53","v":1.953682209183673}]
[null,null,{"$f":"AE20&\"-\"&AF20","v":"Thu-2"},null,null,null,null,{"$f":"IF(D20<=0,\"-\",$I$10*E20*$I$11+$I$12*$I$13)","v":"-"},{"$f":"IF(D20<=0,\"-\",H20/(D20))","v":"-"},{"$f":"IF(OR($D20<=0,$G20<=0),\"-\",I20*G20)","v":"-"},{"$f":"IF(OR($D20<=0,$G20<=0),\"-\",IF($F20<=5,$J20/((-400*$F20+4200)/3),$J20/((0.00507*$F20^4-0.2752*$F20^3+4.88559*$F20^2-104.44259*$F20+2632.3837)/3)))","v":"-"},{"$f":"IF(OR($D20<=0,$G20<=0),\"-\",IF(F20<=10,(-2.11111*10^-6*F20^2+1.49667*10^-4*F20+1.07244*10^-3)*J20+(-2*10^-5*F20^2+0.0001*F20+0.484),IF(F20<=12,(1.815*10^-4*F20+5.43*10^-4)*J20+(0.0002*F20+0.4814),(2.18115*10^-6*F20^3-1.07089*10^-4*F20^2+1.96496*10^-3*F20-9.20665*10^-3)*J20+(-3*10^-6*F20^3+7*10^-5*F20^2+0.0004*F20+0.4736))))","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($AE$16),\"\",TEXT($AE$16+AF19,\"ddd\"))","v":"Thu"},2,null,1,1,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Fri-3",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($AE$16),\"\",TEXT($AE$16+AF20,\"ddd\"))","v":"Fri"},{"$f":"AF20+1","v":3},null,1.5,1.5,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Sat-4",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sat",{"$f":"AF21+1","v":4},null,2,2,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Sun-5",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sun",5,null,2.5,2.5,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Mon-6",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mon",6,null,3,3,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Tue-7",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tue",7,null,null,3.5,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Wed-8",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wed",8,null,null,4,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Thu-9",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu",9,null,null,null,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Fri-10",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fri",10,null,null,null,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Sat-11",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sat",11,null,null,null,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Sun-12",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sun",12,null,null,null,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Mon-13",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mon",13,null,null,null,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Tue-14",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tue",14,null,null,null,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Wed-15",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wed",15,null,null,null,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Thu-16",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu",16,null,null,null,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Fri-17",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fri",17,null,null,null,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Sat-18",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sat",18,null,null,null,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Sun-19",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sun",19,null,null,null,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Mon-20",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mon",20,null,null,null,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Tue-21",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tue",21,null,null,null,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Wed-22",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wed",22,null,null,null,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Thu-23",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu",23,null,null,null,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Fri-24",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fri",24,null,null,null,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Sat-25",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sat",25,null,null,null,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Sun-26",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sun",26,null,null,null,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Mon-27",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mon",27,null,null,null,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Tue-28",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tue",28,null,null,null,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Wed-29",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wed",29,null,null,null,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Thu-30",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu",30,null,null,null,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Fri-31",null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fri",31,null,null,null,null,null,0.83498863598989825,1.953682209183673]
[null,null,"Min",{"$f":"MIN(D19:D49)","v":49},2,15,0.2,101800,2077.5510204081634,{"$f":"MIN(J19:J49)","v":415.51020408163271},0.83498863598989825,1.953682209183673]
[null,null,"Median",{"$f":"IF(SUM(D19:D49)<=0,0,MEDIAN(D19:D49))","v":49},{"$f":"IF(SUM(E19:E49)<=0,0,MEDIAN(E19:E49))","v":2},{"$f":"IF(SUM(F19:F49)<=0,0,MEDIAN(F19:F49))","v":15},{"$f":"IF(SUM(G19:G49)<=0,0,MEDIAN(G19:G49))","v":0.2},{"$f":"IF(SUM(H19:H49)<=0,0,MEDIAN(H19:H49))","v":101800},{"$f":"IF(SUM(I19:I49)<=0,0,MEDIAN(I19:I49))","v":2077.5510204081634},415.51020408163271,0.83498863598989825,1.953682209183673]
[null,null,"Max",{"$f":"MAX(D19:D49)","v":49},{"$f":"MAX(E19:E49)","v":2},{"$f":"MAX(F19:F49)","v":15},{"$f":"MAX(G19:G49)","v":0.2},{"$f":"MAX(H19:H49)","v":101800},{"$f":"MAX(I19:I49)","v":2077.5510204081634},415.51020408163271,0.83498863598989825,1.953682209183673]
[null,null,null,null,null,null,null,null,null,null,null,null,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(K19:K49)=0,\"-\",AVERAGE(K19:K49))","v":0.83498863598989825},{"$f":"IF(SUM(L19:L49)=0,\"-\",AVERAGE(L19:L49))","v":1.953682209183673}]
[null,null,"Print Name:",null,null,null,null,null,null,null,"Certification Grade:",5]
[null,null,"Signature:",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."]