{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["CT Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":1,"pivot_tables":0},"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":"CT Data","index":0,"n_rows":55,"n_cols":43,"rows_kept":55,"cut":false,"hidden":false,"merged":[[53,3,53,11],[54,10,54,11],[54,3,54,8],[8,7,8,8]]}
[null,"Version 1.2;  Author:  Guy Schott, guy.schott@waterboards.ca.gov, 707-576-2732"]
[null,"CT Compliance for "]
[null,"Viruses and Giardia Lamblia Cysts by Free Chlorine"]
[]
[null,"Input Parameters:"]
[null,"Water System Name:",null,null,null,null,null,"Enter Name"]
[null,"Number of Service Connections:",null,null,null,null,null,"Enter Number"]
[null,"System Number:",null,null,null,null,null,"Enter Number"]
[null,"Month and Year:",null,null,null,null,null,"2018-02-01"]
[null,"Clearwell(s) - Volume per Foot:",null,null,null,null,null,0,"Gallons/Ft"]
[null,"Short-Circuiting Factor for Clearwell(s):",null,null,null,null,null,0.1,"t10/T"]
[null,"Transmission Pipe - Volume",null,null,null,null,null,50000,"Gallons"]
[null,"Short-Circuiting Factor for Transmission Pipe:",null,null,null,null,null,0.9,"t10/T"]
[]
[null,null,"Data inputs should be based on when plant is on-line",null,null,null,null,null,null,null,"Inactivation Results",null,null,null,null,null,null,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(AP16,AQ16,AQ15)","v":"2018-02-01"},1]
[null,null,"Transmission Data for Peak Hourly Flow (for pH = 6.0-9.0)",null,null,null,null,null,null,null,"Viruses","Giardia",null,null,null,null,null,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(H9)","v":2018},{"$f":"MONTH($H$9)","v":2}]
[null,"Date","Flow Rate, \ngpm","Clearwell\nLowest \nLevel, ft","Temp, \noC","Chlorine\nResidual, \nmg/L","pH\n(Giardia)","Pipeline\nEffective \nVolume, gal","Effective \nContact Time, \nminutes","Ct10\nmg/L∙min","Log \nInactivation","Log \nInactivation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Virus",null,null,null,null,null,null,null,"Required \nCT"]
[null,{"$f":"AP18&\"-\"&AQ18","v":"Thu-1"},3000,null,10,1,8,{"$f":"IF(C18<=0,\"-\",$H$10*D18*$H$11+$H$12*$H$13)","v":45000},{"$f":"IF(C18<=0,\"-\",H18/(C18))","v":15},{"$f":"IF(OR($C18=0,$F18<=0),\"-\",I18*F18)","v":15},{"$f":"IF(OR(C18<=0,E18<=0,F18<=0),\"-\",IF(AD18>=8,\">8.0\",AD18))","v":">8.0"},{"$f":"IF(OR(AL18=\"-\",J18=\"-\"),\"-\",IF(J18/AL18*1>4,\">4.0\",J18/AL18*1))","v":0.27777777777777779},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(E18<=5,4*J18/(-0.9*E18+12.5),IF(E18<=15,4*J18/(-0.4*E18+10),4*J18/(-0.2*E18+7))),\"-\")","v":10},null,null,null,null,null,null,null,{"$f":"IF(OR(C18=0,C18=\"-\",J18<=0,G18<5),\"-\",ROUNDUP(ct(E18,G18,F18)*1,0))","v":54},{"$f":"IF(OR(AL18=\"-\",J18=\"-\"),\"-\",J18/AL18*1)","v":0.27777777777777779},null,null,{"$f":"IF(ISBLANK($AP$15),\"\",TEXT(AP15,\"ddd\"))","v":"Thu"},1]
[null,"Fri-2",2000,null,15,0.2,6,{"$f":"IF(C19<=0,\"-\",$H$10*D19*$H$11+$H$12*$H$13)","v":45000},{"$f":"IF(C19<=0,\"-\",H19/(C19))","v":22.5},{"$f":"IF(OR($C19=0,$F19<=0),\"-\",I19*F19)","v":4.5},{"$f":"IF(OR(C19<=0,E19<=0,F19<=0),\"-\",IF(AD19>=8,\">8.0\",AD19))","v":4.5},{"$f":"IF(OR(AL19=\"-\",J19=\"-\"),\"-\",IF(J19/AL19*1>4,\">4.0\",J19/AL19*1))","v":0.28125},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(E19<=5,4*J19/(-0.9*E19+12.5),IF(E19<=15,4*J19/(-0.4*E19+10),4*J19/(-0.2*E19+7))),\"-\")","v":4.5},null,null,null,null,null,null,null,{"$f":"IF(OR(C19=0,C19=\"-\",J19<=0,G19<5),\"-\",ROUNDUP(ct(E19,G19,F19)*1,0))","v":16},{"$f":"IF(OR(AL19=\"-\",J19=\"-\"),\"-\",J19/AL19*1)","v":0.28125},null,null,{"$f":"IF(ISBLANK($AP$15),\"\",TEXT($AP$15+AQ18,\"ddd\"))","v":"Fri"},2]
[null,"Sat-3",null,null,null,null,null,{"$f":"IF(C20<=0,\"-\",$H$10*D20*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(E20<=5,4*J20/(-0.9*E20+12.5),IF(E20<=15,4*J20/(-0.4*E20+10),4*J20/(-0.2*E20+7))),\"-\")","v":"-"},null,null,null,null,null,null,null,{"$f":"IF(OR(C20=0,C20=\"-\",J20<=0,G20<5),\"-\",ROUNDUP(ct(E20,G20,F20)*1,0))","v":"-"},{"$f":"IF(OR(AL20=\"-\",J20=\"-\"),\"-\",J20/AL20*1)","v":"-"},null,null,{"$f":"IF(ISBLANK($AP$15),\"\",TEXT($AP$15+AQ19,\"ddd\"))","v":"Sat"},{"$f":"AQ19+1","v":3}]
[null,"Sun-4",null,null,null,null,null,{"$f":"IF(C21<=0,\"-\",$H$10*D21*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(E21<=5,4*J21/(-0.9*E21+12.5),IF(E21<=15,4*J21/(-0.4*E21+10),4*J21/(-0.2*E21+7))),\"-\")","v":"-"},null,null,null,null,null,null,null,{"$f":"IF(OR(C21=0,C21=\"-\",J21<=0,G21<5),\"-\",ROUNDUP(ct(E21,G21,F21)*1,0))","v":"-"},"-",null,null,"Sun",{"$f":"AQ20+1","v":4}]
[null,"Mon-5",null,null,null,null,null,{"$f":"IF(C22<=0,\"-\",$H$10*D22*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C22=0,C22=\"-\",J22<=0,G22<5),\"-\",ROUNDUP(ct(E22,G22,F22)*1,0))","v":"-"},"-",null,null,"Mon",5]
[null,"Tue-6",null,null,null,null,null,{"$f":"IF(C23<=0,\"-\",$H$10*D23*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C23=0,C23=\"-\",J23<=0,G23<5),\"-\",ROUNDUP(ct(E23,G23,F23)*1,0))","v":"-"},"-",null,null,"Tue",6]
[null,"Wed-7",null,null,null,null,null,{"$f":"IF(C24<=0,\"-\",$H$10*D24*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C24=0,C24=\"-\",J24<=0,G24<5),\"-\",ROUNDUP(ct(E24,G24,F24)*1,0))","v":"-"},"-",null,null,"Wed",7]
[null,"Thu-8",null,null,null,null,null,{"$f":"IF(C25<=0,\"-\",$H$10*D25*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C25=0,C25=\"-\",J25<=0,G25<5),\"-\",ROUNDUP(ct(E25,G25,F25)*1,0))","v":"-"},"-",null,null,"Thu",8]
[null,"Fri-9",null,null,null,null,null,{"$f":"IF(C26<=0,\"-\",$H$10*D26*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C26=0,C26=\"-\",J26<=0,G26<5),\"-\",ROUNDUP(ct(E26,G26,F26)*1,0))","v":"-"},"-",null,null,"Fri",9]
[null,"Sat-10",null,null,null,null,null,{"$f":"IF(C27<=0,\"-\",$H$10*D27*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C27=0,C27=\"-\",J27<=0,G27<5),\"-\",ROUNDUP(ct(E27,G27,F27)*1,0))","v":"-"},"-",null,null,"Sat",10]
[null,"Sun-11",null,null,null,null,null,{"$f":"IF(C28<=0,\"-\",$H$10*D28*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C28=0,C28=\"-\",J28<=0,G28<5),\"-\",ROUNDUP(ct(E28,G28,F28)*1,0))","v":"-"},"-",null,null,"Sun",11]
[null,"Mon-12",null,null,null,null,null,{"$f":"IF(C29<=0,\"-\",$H$10*D29*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C29=0,C29=\"-\",J29<=0,G29<5),\"-\",ROUNDUP(ct(E29,G29,F29)*1,0))","v":"-"},"-",null,null,"Mon",12]
[null,"Tue-13",null,null,null,null,null,{"$f":"IF(C30<=0,\"-\",$H$10*D30*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C30=0,C30=\"-\",J30<=0,G30<5),\"-\",ROUNDUP(ct(E30,G30,F30)*1,0))","v":"-"},"-",null,null,"Tue",13]
[null,"Wed-14",null,null,null,null,null,{"$f":"IF(C31<=0,\"-\",$H$10*D31*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C31=0,C31=\"-\",J31<=0,G31<5),\"-\",ROUNDUP(ct(E31,G31,F31)*1,0))","v":"-"},"-",null,null,"Wed",14]
[null,"Thu-15",null,null,null,null,null,{"$f":"IF(C32<=0,\"-\",$H$10*D32*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C32=0,C32=\"-\",J32<=0,G32<5),\"-\",ROUNDUP(ct(E32,G32,F32)*1,0))","v":"-"},"-",null,null,"Thu",15]
[null,"Fri-16",null,null,null,null,null,{"$f":"IF(C33<=0,\"-\",$H$10*D33*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C33=0,C33=\"-\",J33<=0,G33<5),\"-\",ROUNDUP(ct(E33,G33,F33)*1,0))","v":"-"},"-",null,null,"Fri",16]
[null,"Sat-17",null,null,null,null,null,{"$f":"IF(C34<=0,\"-\",$H$10*D34*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C34=0,C34=\"-\",J34<=0,G34<5),\"-\",ROUNDUP(ct(E34,G34,F34)*1,0))","v":"-"},"-",null,null,"Sat",17]
[null,"Sun-18",null,null,null,null,null,{"$f":"IF(C35<=0,\"-\",$H$10*D35*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C35=0,C35=\"-\",J35<=0,G35<5),\"-\",ROUNDUP(ct(E35,G35,F35)*1,0))","v":"-"},"-",null,null,"Sun",18]
[null,"Mon-19",null,null,null,null,null,{"$f":"IF(C36<=0,\"-\",$H$10*D36*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C36=0,C36=\"-\",J36<=0,G36<5),\"-\",ROUNDUP(ct(E36,G36,F36)*1,0))","v":"-"},"-",null,null,"Mon",19]
[null,"Tue-20",null,null,null,null,null,{"$f":"IF(C37<=0,\"-\",$H$10*D37*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C37=0,C37=\"-\",J37<=0,G37<5),\"-\",ROUNDUP(ct(E37,G37,F37)*1,0))","v":"-"},"-",null,null,"Tue",20]
[null,"Wed-21",null,null,null,null,null,{"$f":"IF(C38<=0,\"-\",$H$10*D38*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C38=0,C38=\"-\",J38<=0,G38<5),\"-\",ROUNDUP(ct(E38,G38,F38)*1,0))","v":"-"},"-",null,null,"Wed",21]
[null,"Thu-22",null,null,null,null,null,{"$f":"IF(C39<=0,\"-\",$H$10*D39*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C39=0,C39=\"-\",J39<=0,G39<5),\"-\",ROUNDUP(ct(E39,G39,F39)*1,0))","v":"-"},"-",null,null,"Thu",22]
[null,"Fri-23",null,null,null,null,null,{"$f":"IF(C40<=0,\"-\",$H$10*D40*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C40=0,C40=\"-\",J40<=0,G40<5),\"-\",ROUNDUP(ct(E40,G40,F40)*1,0))","v":"-"},"-",null,null,"Fri",23]
[null,"Sat-24",null,null,null,null,null,{"$f":"IF(C41<=0,\"-\",$H$10*D41*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C41=0,C41=\"-\",J41<=0,G41<5),\"-\",ROUNDUP(ct(E41,G41,F41)*1,0))","v":"-"},"-",null,null,"Sat",24]
[null,"Sun-25",null,null,null,null,null,{"$f":"IF(C42<=0,\"-\",$H$10*D42*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C42=0,C42=\"-\",J42<=0,G42<5),\"-\",ROUNDUP(ct(E42,G42,F42)*1,0))","v":"-"},"-",null,null,"Sun",25]
[null,"Mon-26",null,null,null,null,null,{"$f":"IF(C43<=0,\"-\",$H$10*D43*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C43=0,C43=\"-\",J43<=0,G43<5),\"-\",ROUNDUP(ct(E43,G43,F43)*1,0))","v":"-"},"-",null,null,"Mon",26]
[null,"Tue-27",null,null,null,null,null,{"$f":"IF(C44<=0,\"-\",$H$10*D44*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C44=0,C44=\"-\",J44<=0,G44<5),\"-\",ROUNDUP(ct(E44,G44,F44)*1,0))","v":"-"},"-",null,null,"Tue",27]
[null,"Wed-28",null,null,null,null,null,{"$f":"IF(C45<=0,\"-\",$H$10*D45*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C45=0,C45=\"-\",J45<=0,G45<5),\"-\",ROUNDUP(ct(E45,G45,F45)*1,0))","v":"-"},"-",null,null,"Wed",28]
[null,"Thu-29",null,null,null,null,null,{"$f":"IF(C46<=0,\"-\",$H$10*D46*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C46=0,C46=\"-\",J46<=0,G46<5),\"-\",ROUNDUP(ct(E46,G46,F46)*1,0))","v":"-"},"-",null,null,"Thu",29]
[null,"Fri-30",null,null,null,null,null,{"$f":"IF(C47<=0,\"-\",$H$10*D47*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C47=0,C47=\"-\",J47<=0,G47<5),\"-\",ROUNDUP(ct(E47,G47,F47)*1,0))","v":"-"},"-",null,null,"Fri",30]
[null,"Sat-31",null,null,null,null,null,{"$f":"IF(C48<=0,\"-\",$H$10*D48*$H$11+$H$12*$H$13)","v":"-"},"-","-","-","-",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(C48=0,C48=\"-\",J48<=0,G48<5),\"-\",ROUNDUP(ct(E48,G48,F48)*1,0))","v":"-"},"-",null,null,"Sat",31]
[null,"Min",{"$f":"MIN(C18:C48)","v":2000},0,{"$f":"MIN(E18:E48)","v":10},{"$f":"MIN(F18:F48)","v":0.2},{"$f":"MIN(G18:G48)","v":6},{"$f":"MIN(H18:H48)","v":45000},15,4.5,{"$f":"IF(MIN(AD18:AD48)> 8, \">8.0\",MIN(AD18:AD48))","v":4.5},{"$f":"IF(MIN(AM18:AM48)>4,\">4.0\",MIN(AM18:AM48))","v":0.27777777777777779}]
[null,"Median",{"$f":"IF(SUM(C18:C48)<=0,0,MEDIAN(C18:C48))","v":2500},{"$f":"IF(SUM(D18:D48)<=0,0,MEDIAN(D18:D48))","v":0},{"$f":"IF(SUM(E18:E48)<=0,0,MEDIAN(E18:E48))","v":12.5},{"$f":"IF(SUM(F18:F48)<=0,0,MEDIAN(F18:F48))","v":0.60000000000000009},{"$f":"IF(SUM(G18:G48)<=0,0,MEDIAN(G18:G48))","v":7},{"$f":"IF(SUM(H18:H48)<=0,0,MEDIAN(H18:H48))","v":45000},{"$f":"IF(SUM(I18:I48)<=0,0,MEDIAN(I18:I48))","v":18.75},9.75,{"$f":"IF(MEDIAN(AD18:AD48)> 8, \">8.0\",MEDIAN(AD18:AD48))","v":7.25},{"$f":"IF(SUM(AM18:AM48)<=0,0,IF(MEDIAN(AM18:AM48)>4,\">4.0\",MEDIAN(AM18:AM48)))","v":0.2795138888888889}]
[null,"Max",{"$f":"MAX(C18:C48)","v":3000},{"$f":"MAX(D18:D48)","v":0},{"$f":"MAX(E18:E48)","v":15},{"$f":"MAX(F18:F48)","v":1},{"$f":"MAX(G18:G48)","v":8},{"$f":"MAX(H18:H48)","v":45000},{"$f":"MAX(I18:I48)","v":22.5},15,{"$f":"IF(MAX(AD18:AD48)> 8, \">8.0\",MAX(AD18:AD48))","v":">8.0"},{"$f":"IF(MAX(AM18:AM48)>4,\">4.0\",MAX(AM18:AM48))","v":0.28125}]
[]
[]
[null,"Print Name:"]
[null,"Signature:",null,null,null,null,null,null,null,"Date:"]