{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["CT Data"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":39,"rows_kept":55,"cut":false,"hidden":false,"merged":[[53,3,53,9],[54,8,54,9],[54,3,54,6],[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 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,"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,{"$f":"DATE(AL16,AM16,AM15)","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,"Viruses",null,null,null,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","Pipeline \nEffective \nVolume, gal","Effective \nContact Time, \nminutes","Ct10\nmg/L∙min","Log \nInactivation"]
[null,{"$f":"AL18&\"-\"&AM18","v":"Thu-1"},3000,null,20,1,{"$f":"IF(C18<=0,\"-\",$H$10*D18*$H$11+$H$12*$H$13)","v":45000},{"$f":"IF(C18=0,\"-\",G18/(C18))","v":15},{"$f":"IF(OR($C18=0,$F18<=0),\"-\",H18*F18)","v":15},{"$f":"IF(AF18=\"-\",\"-\", IF(AF18>8, \"> 8.0\",AF18))","v":"> 8.0"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(E18<=5,4*I18/(-0.9*E18+12.5),IF(E18<=15,4*I18/(-0.4*E18+10),4*I18/(-0.2*E18+7))),\"-\")","v":20},null,null,null,null,null,{"$f":"IF(ISBLANK($AL$15),\"\",TEXT(AL15,\"ddd\"))","v":"Thu"},1]
[null,"Fri-2",null,null,null,null,{"$f":"IF(C19<=0,\"-\",$H$10*D19*$H$11+$H$12*$H$13)","v":"-"},{"$f":"IF(C19=0,\"-\",G19/(C19))","v":"-"},{"$f":"IF(OR($C19=0,$F19<=0),\"-\",H19*F19)","v":"-"},"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(E19<=5,4*I19/(-0.9*E19+12.5),IF(E19<=15,4*I19/(-0.4*E19+10),4*I19/(-0.2*E19+7))),\"-\")","v":"-"},null,null,null,null,null,{"$f":"IF(ISBLANK($AL$15),\"\",TEXT($AL$15+AM18,\"ddd\"))","v":"Fri"},2]
[null,"Sat-3",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,null,null,null,null,{"$f":"IFERROR(IF(E20<=5,4*I20/(-0.9*E20+12.5),IF(E20<=15,4*I20/(-0.4*E20+10),4*I20/(-0.2*E20+7))),\"-\")","v":"-"},null,null,null,null,null,{"$f":"IF(ISBLANK($AL$15),\"\",TEXT($AL$15+AM19,\"ddd\"))","v":"Sat"},{"$f":"AM19+1","v":3}]
[null,"Sun-4",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,null,null,null,null,"-",null,null,null,null,null,"Sun",{"$f":"AM20+1","v":4}]
[null,"Mon-5",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,null,null,"Mon",5]
[null,"Tue-6",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,null,null,"Tue",6]
[null,"Wed-7",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,null,null,"Wed",7]
[null,"Thu-8",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,null,null,"Thu",8]
[null,"Fri-9",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,null,null,"Fri",9]
[null,"Sat-10",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,null,null,"Sat",10]
[null,"Sun-11",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,null,null,"Sun",11]
[null,"Mon-12",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,null,null,"Mon",12]
[null,"Tue-13",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,null,null,"Tue",13]
[null,"Wed-14",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,null,null,"Wed",14]
[null,"Thu-15",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,null,null,"Thu",15]
[null,"Fri-16",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,null,null,"Fri",16]
[null,"Sat-17",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,null,null,"Sat",17]
[null,"Sun-18",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,null,null,"Sun",18]
[null,"Mon-19",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,null,null,"Mon",19]
[null,"Tue-20",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,null,null,"Tue",20]
[null,"Wed-21",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,null,null,"Wed",21]
[null,"Thu-22",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,null,null,"Thu",22]
[null,"Fri-23",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,null,null,"Fri",23]
[null,"Sat-24",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,null,null,"Sat",24]
[null,"Sun-25",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,null,null,"Sun",25]
[null,"Mon-26",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,null,null,"Mon",26]
[null,"Tue-27",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,null,null,"Tue",27]
[null,"Wed-28",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,null,null,"Wed",28]
[null,"Thu-29",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,null,null,"Thu",29]
[null,"Fri-30",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,null,null,"Fri",30]
[null,"Sat-31",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,null,null,"Sat",31]
[null,"Min",{"$f":"MIN(C18:C48)","v":3000},0,{"$f":"MIN(E18:E48)","v":20},{"$f":"MIN(F18:F48)","v":1},{"$f":"MIN(G18:G48)","v":45000},{"$f":"MIN(H18:H48)","v":15},15,{"$f":"IF(MIN(AF18:AF48)> 8, \">8.0\",MIN(AF18:AF48))","v":">8.0"}]
[null,"Median",{"$f":"IF(SUM(C18:C48)<=0,0,MEDIAN(C18:C48))","v":3000},{"$f":"IF(SUM(D18:D48)<=0,0,MEDIAN(D18:D48))","v":0},{"$f":"IF(SUM(E18:E48)<=0,0,MEDIAN(E18:E48))","v":20},{"$f":"IF(SUM(F18:F48)<=0,0,MEDIAN(F18:F48))","v":1},{"$f":"IF(SUM(G18:G48)<=0,0,MEDIAN(G18:G48))","v":45000},{"$f":"IF(SUM(H18:H48)<=0,0,MEDIAN(H18:H48))","v":15},15,{"$f":"IF(MEDIAN(AF18:AF48)> 8, \">8.0\",MEDIAN(AF18:AF48))","v":">8.0"}]
[null,"Max",{"$f":"MAX(C18:C48)","v":3000},{"$f":"MAX(D18:D48)","v":0},{"$f":"MAX(E18:E48)","v":20},{"$f":"MAX(F18:F48)","v":1},{"$f":"MAX(G18:G48)","v":45000},{"$f":"MAX(H18:H48)","v":15},15,{"$f":"IF(MAX(AF18:AF48)> 8, \">8.0\",MAX(AF18:AF48))","v":">8.0"}]
[]
[]
[null,"Print Name:"]
[null,"Signature:",null,null,null,null,null,"Date:"]