{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Log Inactivation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":0,"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":"Log Inactivation","index":0,"n_rows":30,"n_cols":83,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"Version 1.3;  Author: Guy Schott, P.E., 707-576-2732, guy.schott@waterboards.ca.gov; Updated 5/25/2020"]
[]
[null,"Disinfection Log Inactivation of "]
[null,"Virus, Giardia Lamblia Cysts and Cryptosporidium"]
[]
[]
[]
[null,"Model 1","Chlorine Disinfection - Virus and Giardia",null,null,null,null,null,"Model 3","Chloramine Disinfection - Virus and Giardia"]
[null,"Enter operational and water quality parameters:",null,null,null,null,null,null,"Enter operational and water quality parameters:"]
[null,"Flow Rate",800,"gpm","Results:",null,null,null,"Flow Rate",500,"gpm","Results:"]
[null,"Reactor 1 Volume",115736,"gallons","Reactor 1 Effective Vol.",{"$f":"IF($C11<=0,\"-\",C11*C12)","v":46294.400000000001},"gallons",null,"Reactor 1 Volume",100000,"gallons","Reactor 1 Effective Vol.",{"$f":"IF(J11<=0,\"-\",J11*J12)","v":10000},"gallons"]
[null,"Baffling Factor",0.4,"t10/T","Reactor 2 Effective Vol.",{"$f":"IF($C13<=0,\"-\",C13*C14)","v":"-"},"gallons",null,"Baffling Factor",0.1,"t10/T","Reactor 2 Effective Vol.",{"$f":"IF(J13<=0,\"-\",J13*J14)","v":"-"},"gallons"]
[null,"Reactor 2 Volume",0,"gallons","Total Effective Time",{"$f":"SUM(F11:F12)/C10","v":57.868000000000002},"minutes",null,"Reactor 2 Volume",0,"gallons","Total Effective Time",{"$f":"SUM(M11:M12)/J10","v":20},"minutes"]
[null,"Baffling Factor",0.9,"t10/T","CT (calculated)",{"$f":"IF(OR($C10<=0,$C17<=0, C11+C13<=0),\"-\",(C11*C12)/C10*C17+(C13*C14)/C10*C17)","v":28.934000000000001},"mg/L∙min",null,"Baffling Factor",0.9,"t10/T","CT (calculated)",{"$f":"IF(OR(J10<=0,J17<=0, J11+J13<=0),\"-\",(J11*J12)/J10*J17+(J13*J14)/J10*J17)","v":4},"mg/L∙min"]
[null,"pH (Giardia)",8,"unit","Log Inactivation Results",null,null,null,"pH","(6-9)","unit","Log Inactivation Results"]
[null,"Temperature",10,"oC","Virus",{"$f":"IF(OR(C10<=0,C16<=0,C17<=0,C11+C13<=0),\"-\",IF(IFERROR(4*(F14/(-0.00000664*C16^5+0.00046958*C16^4-0.01262061*C16^3+0.17065982*C16^2-1.56683015*C16+13.11747036)),\"-\")>=5,\">5.0\",IFERROR(IF(C16<=5,4*F14/(-0.9*C16+12.5),IF(C16<=15,4*F14/(-0.4*C16+10),4*F14/(-0.2*C16+7))),\"-\")))","v":">5.0"},"log",null,"Temperature",10,"oC","Virus",{"$f":"IF(AE16>5, \">5.0\",AE16)","v":0.49243199599999998},"log",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(J10<=0,M14=\"-\"),\"-\",IF(J16<=10,(-2.11111*10^-6*J16^2+1.49667*10^-4*J16+1.07244*10^-3)*M14+(-2*10^-5*J16^2+0.0001*J16+0.484),IF(J16<=12,(1.815*10^-4*J16+5.43*10^-4)*M14+(0.0002*J16+0.4814),(2.18115*10^-6*J16^3-1.07089*10^-4*J16^2+1.96496*10^-3*J16-9.20665*10^-3)*M14+(-3*10^-6*J16^3+7*10^-5*J16^2+0.0004*J16+0.4736))))","v":0.49243199599999998}]
[null,"Chlorine Residual",0.5,"mg/L","Giardia cysts",{"$f":"IF(OR(C10<=0,C16<=0,C17<=0,C15<=5,F14=\"-\"),\"-\",IF(F14/ROUNDUP(ct(C16,C15,C17)*1,0)*1>5,\">5.0\",F14/ROUNDUP(ct(C16,C15,C17)*1,0)*1))","v":0.56733333333333336},"log",null,"Chlorine Residual",0.2,"mg/L","Giardia cysts",{"$f":"IF(AE17>5, \">5.0\",AE17)","v":6.4794228648465827E-3},"log",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(J10<=0,M14=\"-\"),\"-\",IF(J16<=5,M14/((-400*J16+4200)/3),M14/((0.00507*J16^4-0.2752*J16^3+4.88559*J16^2-104.44259*J16+2632.3837)/3)))","v":6.4794228648465827E-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,"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,"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,null,null,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,C29<=0),\"-\", 4*F26/AD19)","v":0.63745019920318724},{"$f":"IF(C28<1,\"-\",HLOOKUP(C28,$BG$18:$CE$19,2))","v":25.1},{"$f":"-0.00001929*C28^2-0.00000929*C28-0.000392","v":-2.4139000000000001E-3},{"$f":"0.00093714*C28^2+0.00328714*C28+0.068062","v":0.19464740000000003},1.4244000000000001,{"$f":"IF(C22<=0,\"-\",AE19*F26^2+AF19*F26+AG19)","v":2.1643672},{"$f":"-0.00000004*C28^4+0.00000159*C28^3-0.00004328*C28^2+0.00030334*C28-0.00156149","v":-1.6660900000000003E-3},{"$f":"-0.00002*C28^3+0.001177*C28^2-0.007005*C28+0.117161","v":0.14481100000000002},1.4248000000000001,{"$f":"IF(C22<=0,\"-\",AI19*F26^2+AJ19*F26+AK19)","v":1.9773865600000002},{"$f":"-0.000171*C28^2+0.006151*C28-0.061302","v":-1.6891999999999997E-2},{"$f":"0.002057*C28^2-0.065201*C28+0.770529","v":0.32421900000000003},1.426585,{"$f":"IF(C22<=0,\"-\",AM19*F26^2+AN19*F26+AO19)","v":2.4531890000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Model 2","Chlorine Dioxide Disinfection - Virus, Giardia & Crypto",null,null,null,null,null,"Model 4","Ozone Disinfection - Virus, Giardia & Crypto"]
[null,"Enter operational and water quality parameters:",null,null,null,null,null,null,"Enter operational and water quality parameters:"]
[null,"Flow Rate",500,"gpm","Results:",null,null,null,"Flow Rate",500,"gpm","Results:"]
[null,"Reactor 1 Volume",100000,"gallons","Reactor 1 Effective Vol.",{"$f":"IF(C23<=0,\"-\",C23*C24)","v":10000},"gallons",null,"Reactor 1 Volume",25000,"gallons","Reactor 1 Effective Vol.",{"$f":"IF(J23<=0,\"-\",J23*J24)","v":2500},"gallons"]
[null,"Baffling Factor",0.1,"t10/T","Reactor 2 Effective Vol.",{"$f":"IF(C25<=0,\"-\",C25*C26)","v":"-"},"gallons",null,"Baffling Factor",0.1,"t10/T","Reactor 2 Effective Vol.",{"$f":"IF(J25<=0,\"-\",J25*J26)","v":"-"},"gallons"]
[null,"Reactor 2 Volume",0,"gallons","Total Effective Time",{"$f":"SUM(F23:F24)/C22","v":20},"minutes",null,"Reactor 2 Volume",0,"gallons","Total Effective Time",{"$f":"SUM(M23:M24)/J22","v":5},"minutes"]
[null,"Baffling Factor",0.9,"t10/T","CT (calculated)",{"$f":"IF(OR(C22<=0,C29<=0, C23+C25<=0),\"-\",(C23*C24)/C22*C29+(C25*C26)/C22*C29)","v":4},"mg/L∙min",null,"Baffling Factor",0.9,"t10/T","CT (calculated)",{"$f":"IF(OR(J22<=0,J29<=0, J23+J25<=0),\"-\",(J23*J24)/J22*J29+(J25*J26)/J22*J29)","v":2},"mg/L∙min"]
[null,"pH","(6-9)","unit","Log Inactivation Results",null,null,null,"pH","(6-9)","unit","Log Inactivation Results"]
[null,"Temperature",10,"oC","Virus",{"$f":"IF(OR(C22<=0,F26=\"-\"),\"-\", IF(F26>AD19,\">4.0\",IF(C28<=5,AH19,IF(C28<=20,AL19,AP19))))","v":1.9773865600000002},"log",null,"Temperature",10,"oC","Virus",{"$f":"IF(OR(J22<=0,M26=\"-\"),\"-\",IF(2*M26/(0.9284*EXP(-0.069*J28))>5,\">5.0\",2*M26/(0.9284*EXP(-0.069*J28))))","v":">5.0"},"log"]
[null,"ClO2 Residual",0.2,"mg/L","Giardia cysts",{"$f":"IF(OR(C22<=0,F26=\"-\"),\"-\",IF(AND(C28<=5,F26/(-3.07*C28+24.07)>5),\">5.0\",IF(C28<=5,F26/(-3.07*C28+24.07),IF(AND(C28>5,F26/(-0.2561*C28+10.137)>5),\">5.0\",F26/(-0.2561*C28+10.137)))))","v":0.52798310454065467},"log",null,"Ozone Residual",0.4,"mg/L","Giardia cysts",{"$f":"IF(OR(J22<=0,M26=\"-\"),\"-\",IF(AND(J28<=8,1000*M26/(6.19*J28^2-118*J28+1087)> 5),\"> 5.0\",IF(J28<=8,1000*M26/(6.19*J28^2-118*J28+1087),IF(AND(J28>8,J28<=15,1000*M26/(0.44*J28^2-41.3*J28+844)>5),\"> 5.0\",IF(AND(J28>8,J28<=15),1000*M26/(0.44*J28^2-41.3*J28+844),IF(1000*M26/(-0.076*J28^2-12.53*J28+520.7)>5,\"> 5.0\",1000*M26/(-0.076*J28^2-12.53*J28+520.7)))))))","v":4.2105263157894735},"log"]
[null,"MRDL: 0.8 mg/L Cl02",null,null,"Cryptosporidium",{"$f":"IF(OR(C22<=0,F26=\"-\"),\"-\",IF(0.001506*(1.09116^C28)*F26>4,\">4.0\",0.001506*(1.09116^C28)*F26))","v":1.4413496087184166E-2},"log",null,"Bromate monitoring required.",null,null,"Cryptosporidium",{"$f":"IF(OR(J22<=0,M26=\"-\"),\"-\",IF(0.0397*(1.09757^J28)*M26>4,\">4.0\",0.0397*(1.09757^J28)*M26))","v":0.20143864038558468},"log"]