{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["CT Data","CyanoCT_Table","GiardiaGraph"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"GiardiaGraph","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":65,"n_cols":68,"rows_kept":65,"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 and Reduction for "]
[null,null,"Giardia Lamblia Cysts & Microcystin-LR by Free Chlorine"]
[]
[null,null,"Input Parameters:"]
[null,null,"Water System Name:",null,null,null,null,"Enter Name",null,null,null,null,null,null,"System Number:","Enter Number"]
[null,null,"Number of Service Connections:",null,null,null,null,"Enter Number",null,null,null,null,null,null,"Month and Year:","2020-06-01"]
[null,null,"Clearwell(s) - Volume per Foot:",null,null,null,null,null,15800,"Gallons/Ft",null,null,"Transmission Pipe - Volume:",null,null,6000,"Gallons"]
[null,null,"Short-Circuiting Factor for Clearwell(s):",null,null,null,null,null,0.1,"t10/T (baffling factor, BF)",null,null,"Short-Circuiting Factor for Pipe:",null,null,0.9,"t10/T (BF)"]
[null,null,"Required Log Inactivation of Giardia Cyst:",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,null,null,{"$f":"DATE(AH13,AI13,AI12)","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,"Reduction of Microcystin-LR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(P7)","v":2020},{"$f":"MONTH($P$7)","v":6},null,null,null,null,null,null,null,null,{"$f":"_MCf2","v":0.3},1,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","MC-LR\nLog (%)\nReduction",{"$f":"\"*MC-LR\nReduced from\nx to \" & _MCf2 & \" ug/L\"","v":"*MC-LR\nReduced from\nx to 0.3 ug/L"},{"$f":"\"**MC-LR\nReduced from\nx to \" & _MCf & \" ug/L\"","v":"**MC-LR\nReduced from\nx to 1 ug/L"},null,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,"AveLog","Max",null,"EPA Eq,           1-log",null,"Microcystins","Microcystins",null,null,"Inactivation \nRatio \n(CTcalc/CT99.9)",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":"AH15&\"-\"&AI15","v":"Mon-1"},500,5,13.6,8,1.35,{"$f":"IF(D15<=0,\"-\",$I$8*E15*$I$9+$P$8*$P$9)","v":13300},{"$f":"IF(OR(D15<=0,D15=\"-\"),\"-\",I15/(D15))","v":26.6},{"$f":"IF(OR(D15<=0,D15=\"-\",H15<=0,G15<5),\"-\",ROUNDUP(ct(F15,G15,H15)*$I$10,0))","v":22},{"$f":"IF(OR($D15<=0,D15=\"-\",$H15<=0),\"-\",J15*H15)","v":35.910000000000004},{"$f":"IF(OR($D15<=0,$G15<=0,D15=\"-\",$H15<=0),\"-\",L15/K15)","v":1.6322727272727275},{"$f":"IF(OR($D15<=0,D15=\"-\",$H15<=0,G15<5),\"-\",$L15/$K15*$I$10)","v":0.81613636363636377},{"$f":"IF(AS15=\"-\",\"-\",TEXT(LOG(AR15/_MCf2),\"0.0\")&\" (\"&TEXT((1-_MCf2/P15)*100,\"##.0\") &\"%)\")","v":"0.4 (56.7%)"},{"$f":"IF(AR15=\"-\",\"-\",AR15)","v":0.69322201926481131},{"$f":"IF(AS15=\"-\",\"-\",AS15)","v":2.3107400642160378},null,null,null,null,6,1200,{"$f":"PI()*(V15/12)^2/4*W15*7.4805","v":1762.5512883883835},null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($AH$12),\"\",TEXT($AH$12,\"ddd\"))","v":"Mon"},1,null,null,1,{"$f":"$AI$46","v":1.5428344359956394},{"$f":"MAX(N15:N45)","v":1.8780266939643291},null,{"$f":"IF(F15<12.5,(0.353)*(12.006+EXP(2.46-0.073*F15+0.125*H15+0.389*G15)),(0.361)*(-2.261+EXP(2.69-0.065*F15+0.111*H15+0.361*G15)))","v":45.015327201575268},null,{"$f":"IF(OR($D15<=0,D15=\"-\",G15<=0,$H15<=0),\"-\",EXP(((2.07*10^7)*(10^(-G15))^2+(3.152*F15+53.74)*10^-G15+(0.181*F15+3.2)*10^-7.5)/(10^-7.5+10^-G15)*(L15*60/(1000*2*35.45)))*_MCf2)","v":0.69322201926481131},{"$f":"IF(OR($D15<=0,D15=\"-\",G15<=0,$H15<=0),\"-\",EXP(((2.07*10^7)*(10^(-G15))^2+(3.152*F15+53.74)*10^-G15+(0.181*F15+3.2)*10^-7.5)/(10^-7.5+10^-G15)*(L15*60/(1000*2*35.45)))*_MCf)","v":2.3107400642160378},null,null,{"$f":"IF(OR($D15<=0,D15=\"-\",$H15<=0,G15<5),\"-\",N15/3)","v":0.27204545454545459},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":"AH16&\"-\"&AI16","v":"Tue-2"},481.7,10,13.9,7.68,1.49,{"$f":"IF(D16<=0,\"-\",$I$8*E16*$I$9+$P$8*$P$9)","v":21200},{"$f":"IF(OR(D16<=0,D16=\"-\"),\"-\",I16/(D16))","v":44.010795100685073},{"$f":"IF(OR(D16<=0,D16=\"-\",H16<=0,G16<5),\"-\",ROUNDUP(ct(F16,G16,H16)*$I$10,0))","v":19},{"$f":"IF(OR($D16<=0,D16=\"-\",$H16<=0),\"-\",J16*H16)","v":65.576084700020758},3.4513728789484608,1.7256864394742304,"1.0 (90.5%)",3.159324263872497,10.53108087957499,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($AH$12),\"\",TEXT($AH$12+AI15,\"ddd\"))","v":"Tue"},2,null,null,{"$f":"AL15+1","v":2},{"$f":"$AI$46","v":1.5428344359956394},null,null,39.853858690161665,null,3.159324263872497,10.53108087957499,null,null,{"$f":"IF(OR($D16<=0,D16=\"-\",$H16<=0,G16<5),\"-\",N16/3)","v":0.57522881315807683}]
[null,null,"Wed-3",495.8,10,14.2,7.92,1,21200,42.759177087535292,{"$f":"IF(OR(D17<=0,D17=\"-\",H17<=0,G17<5),\"-\",ROUNDUP(ct(F17,G17,H17)*$I$10,0))","v":19},42.759177087535292,2.2504830046071205,1.1252415023035602,"0.5 (67.9%)",0.93388096106849083,3.1129365368949697,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wed",{"$f":"AI16+1","v":3},null,null,{"$f":"AL16+1","v":3},1.5428344359956394,null,null,40.375722015310991,null,0.93388096106849083,3.1129365368949697,null,null,0.37508050076785343,null,null,null,null,null,null,null,null,"USEPA equations (percent error):"]
[null,null,"Thu-4",474.8,10,13.7,7.83,1.38,21200,44.650379106992418,{"$f":"IF(OR(D18<=0,D18=\"-\",H18<=0,G18<5),\"-\",ROUNDUP(ct(F18,G18,H18)*$I$10,0))","v":21},61.61752316764953,2.9341677698880728,1.4670838849440364,"0.8 (83.8%)",1.8468690479569694,6.1562301598565652,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu",{"$f":"AI17+1","v":4},null,null,4,1.5428344359956394,null,null,42.150791896628775,null,1.8468690479569694,6.1562301598565652,null,null,0.48902796164801215,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",498.1,10,12.9,7.9,1.67,21200,42.561734591447497,{"$f":"IF(OR(D19<=0,D19=\"-\",H19<=0,G19<5),\"-\",ROUNDUP(ct(F19,G19,H19)*$I$10,0))","v":23},71.078096767717312,{"$f":"IF(OR($D19<=0,$G19<=0,D19=\"-\",$H19<=0),\"-\",L19/K19)","v":3.0903520333790135},{"$f":"IF(OR($D19<=0,D19=\"-\",$H19<=0,G19<5),\"-\",$L19/$K19*$I$10)","v":1.5451760166895068},"0.8 (84.4%)",1.9260896526839952,6.4202988422799843,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fri",5,null,null,5,1.5428344359956394,null,null,47.121020148901827,null,1.9260896526839952,6.4202988422799843,null,null,0.51505867222983559]
[null,null,"Sat-6",493.5,10,12.8,7.66,1.91,21200,42.958459979736574,{"$f":"IF(OR(D20<=0,D20=\"-\",H20<=0,G20<5),\"-\",ROUNDUP(ct(F20,G20,H20)*$I$10,0))","v":22},82.050658561296856,{"$f":"IF(OR($D20<=0,$G20<=0,D20=\"-\",$H20<=0),\"-\",L20/K20)","v":3.7295753891498573},{"$f":"IF(OR($D20<=0,D20=\"-\",$H20<=0,G20<5),\"-\",$L20/$K20*$I$10)","v":1.8647876945749287},"1.3 (94.6%)",5.5112729495079513,18.370909831693172,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sat",6,null,null,6,1.5428344359956394,null,null,44.623774680375995,null,5.5112729495079513,18.370909831693172,null,null,0.62159589819164285]
[null,null,"Sun-7",472.5,10,13.6,7.88,1.83,21200,44.867724867724867,{"$f":"IF(OR(D21<=0,D21=\"-\",H21<=0,G21<5),\"-\",ROUNDUP(ct(F21,G21,H21)*$I$10,0))","v":22},82.107936507936515,3.7321789321789325,1.8660894660894662,"1.0 (89.5%)",2.8698778503648836,9.5662595012162797,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sun",7,null,null,7,1.5428344359956394,null,null,45.474090269243668,null,2.8698778503648836,9.5662595012162797,null,null,0.62202982202982204]
[null,null,"Mon-8",489.7,10,13.8,7.78,1.76,21200,43.291811313048804,{"$f":"IF(OR(D22<=0,D22=\"-\",H22<=0,G22<5),\"-\",ROUNDUP(ct(F22,G22,H22)*$I$10,0))","v":21},76.193587910965888,3.6282660909983755,1.8141330454991877,"1.0 (91.0%)",3.328598155604785,11.095327185349284,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mon",8,null,null,8,1.5428344359956394,null,null,42.915017185509079,null,3.328598155604785,11.095327185349284,null,null,0.60471101516639592]
[null,null,"Tue-9",524,10,14,7.85,1.26,21200,40.458015267175576,{"$f":"IF(OR(D23<=0,D23=\"-\",H23<=0,G23<5),\"-\",ROUNDUP(ct(F23,G23,H23)*$I$10,0))","v":20},50.977099236641223,2.5488549618320611,1.2744274809160305,"0.6 (77.2%)",1.315896534777403,4.3863217825913434,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tue",9,null,null,9,1.5428344359956394,null,null,41.064796417789502,null,1.315896534777403,4.3863217825913434,null,null,0.42480916030534349]
[null,null,"Wed-10",440.9,10,13.7,7.75,1.39,21200,48.083465638466777,{"$f":"IF(OR(D24<=0,D24=\"-\",H24<=0,G24<5),\"-\",ROUNDUP(ct(F24,G24,H24)*$I$10,0))","v":20},66.836017237468809,3.3418008618734403,1.6709004309367201,"0.9 (88.8%)",2.6706125575245641,8.9020418584152132,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wed",10,null,null,10,1.5428344359956394,null,null,40.974013145467495,null,2.6706125575245641,8.9020418584152132,null,null,0.55696681031224005]
[null,null,"Thu-11",460.6,10,12.8,7.83,1.75,21200,46.026921406860616,{"$f":"IF(OR(D25<=0,D25=\"-\",H25<=0,G25<5),\"-\",ROUNDUP(ct(F25,G25,H25)*$I$10,0))","v":23},80.547112462006083,3.5020483679133081,1.751024183956654,"1.0 (90.0%)",3.0121369989386317,10.040456663128772,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu",11,null,null,11,1.5428344359956394,null,null,46.649257545348384,null,3.0121369989386317,10.040456663128772,null,null,0.58367472798555131]
[null,null,"Fri-12",451.5,10,13.8,7.82,1.59,21200,46.954595791805097,{"$f":"IF(OR(D26<=0,D26=\"-\",H26<=0,G26<5),\"-\",ROUNDUP(ct(F26,G26,H26)*$I$10,0))","v":21},74.657807308970106,3.5551336813795289,1.7775668406897644,"1.0 (89.3%)",2.8137813131145415,9.3792710437151392,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fri",12,null,null,12,1.5428344359956394,null,null,42.72171627798329,null,2.8137813131145415,9.3792710437151392,null,null,0.59252228022992148]
[null,null,"Sat-13",461.8,10,12.9,7.74,1.8,21200,45.907319185794712,{"$f":"IF(OR(D27<=0,D27=\"-\",H27<=0,G27<5),\"-\",ROUNDUP(ct(F27,G27,H27)*$I$10,0))","v":22},82.633174534430481,3.7560533879286582,1.8780266939643291,"1.2 (93.1%)",4.3168554349700576,14.38951811656686,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sat",13,null,null,13,1.5428344359956394,null,null,45.088257327301186,null,4.3168554349700576,14.38951811656686,null,null,0.62600889798810966]
[null,null,"Sun-14",459,10,12.5,7.77,1.78,21200,46.187363834422655,{"$f":"IF(OR(D28<=0,D28=\"-\",H28<=0,G28<5),\"-\",ROUNDUP(ct(F28,G28,H28)*$I$10,0))","v":23},82.213507625272328,3.5745003315335793,1.7872501657667896,"1.1 (92.0%)",3.7283487823051344,12.427829274350449,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sun",14,null,null,14,1.5428344359956394,null,null,46.70482465566716,null,3.7283487823051344,12.427829274350449,null,null,0.59575005525559654]
[null,null,"Mon-15",437.1,10,12.1,7.86,1.65,21200,48.501487073896129,{"$f":"IF(OR(D29<=0,D29=\"-\",H29<=0,G29<5),\"-\",ROUNDUP(ct(F29,G29,H29)*$I$10,0))","v":24},80.027453671928612,3.334477236330359,1.6672386181651795,"0.9 (88.4%)",2.5775653782957617,8.5918845943192057,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mon",15,null,null,15,1.5428344359956394,null,null,48.903679924848724,null,2.5775653782957617,8.5918845943192057,null,null,0.55574620605505987]
[null,null,"Tue-16",464.5,10,12.2,7.75,1.66,21200,45.64047362755651,{"$f":"IF(OR(D30<=0,D30=\"-\",H30<=0,G30<5),\"-\",ROUNDUP(ct(F30,G30,H30)*$I$10,0))","v":23},75.763186221743808,3.2940515748584263,1.6470257874292131,"1.0 (90.5%)",3.1710844187928697,10.570281395976233,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tue",16,null,null,16,1.5428344359956394,null,null,46.774628509464186,null,3.1710844187928697,10.570281395976233,null,null,0.54900859580973771]
[null,null,"Wed-17",439.3,10,11.9,7.73,1.6,21200,48.258593216480762,{"$f":"IF(OR(D31<=0,D31=\"-\",H31<=0,G31<5),\"-\",ROUNDUP(ct(F31,G31,H31)*$I$10,0))","v":23},77.213749146369224,3.3571195281030097,1.6785597640515049,"1.1 (91.3%)",3.4394443713577592,11.46481457119253,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wed",17,null,null,17,1.5428344359956394,null,null,47.057154337735426,null,3.4394443713577592,11.46481457119253,null,null,0.55951992135050166]
[null,null,"Thu-18",474.8,10,12.6,7.74,1.65,21200,44.650379106992418,{"$f":"IF(OR(D32<=0,D32=\"-\",H32<=0,G32<5),\"-\",ROUNDUP(ct(F32,G32,H32)*$I$10,0))","v":22},73.67312552653749,3.3487784330244312,1.6743892165122156,"1.0 (90.5%)",3.1572824613694577,10.524274871231526,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu",18,null,null,18,1.5428344359956394,null,null,45.219271697330967,null,3.1572824613694577,10.524274871231526,null,null,0.55812973883740524]
[null,null,"Fri-19",459.7,10,12.6,7.76,1.43,21200,46.117032847509243,{"$f":"IF(OR(D33<=0,D33=\"-\",H33<=0,G33<5),\"-\",ROUNDUP(ct(F33,G33,H33)*$I$10,0))","v":22},65.94735697193822,2.9976071350881011,1.4988035675440505,"0.9 (87.2%)",2.3402193875354649,7.8007312917848832,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fri",19,null,null,19,1.5428344359956394,null,null,44.434231918784256,null,2.3402193875354649,7.8007312917848832,null,null,0.49960118918135016]
[null,null,"Sat-20",457.3,10,11.8,7.72,1.45,21200,46.359064071725342,{"$f":"IF(OR(D34<=0,D34=\"-\",H34<=0,G34<5),\"-\",ROUNDUP(ct(F34,G34,H34)*$I$10,0))","v":23},67.22064290400175,2.9226366480000761,1.461318324000038,"0.9 (88.3%)",2.5570689772308386,8.5235632574361286,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sat",20,null,null,20,1.5428344359956394,null,null,46.405322651478379,null,2.5570689772308386,8.5235632574361286,null,null,0.48710610800001269]
[null,null,"Sun-21",451.7,10,12.1,7.85,1.72,21200,46.933805623201238,{"$f":"IF(OR(D35<=0,D35=\"-\",H35<=0,G35<5),\"-\",ROUNDUP(ct(F35,G35,H35)*$I$10,0))","v":24},80.726145671906124,3.3635894029960887,1.6817947014980443,"1.0 (88.9%)",2.7040955812823095,9.0136519376076993,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sun",21,null,null,21,1.5428344359956394,null,null,49.121282902731927,null,2.7040955812823095,9.0136519376076993,null,null,0.56059823383268148]
[null,null,"Mon-22",447.5,10,13.1,7.83,1.45,21200,47.374301675977655,{"$f":"IF(OR(D36<=0,D36=\"-\",H36<=0,G36<5),\"-\",ROUNDUP(ct(F36,G36,H36)*$I$10,0))","v":22},68.692737430167597,3.1223971559167087,1.5611985779583544,"0.9 (86.3%)",2.1876875708854056,7.2922919029513515,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mon",22,null,null,22,1.5428344359956394,null,null,44.208094097909047,null,2.1876875708854056,7.2922919029513515,null,null,0.52039952598611816]
[null,null,"Tue-23",475.1,10,12.2,7.85,1.54,21200,44.622184803199325,{"$f":"IF(OR(D37<=0,D37=\"-\",H37<=0,G37<5),\"-\",ROUNDUP(ct(F37,G37,H37)*$I$10,0))","v":24},68.718164596926968,2.8632568582052902,1.4316284291026451,"0.8 (84.7%)",1.962252430580018,6.540841435266727,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tue",23,null,null,23,1.5428344359956394,null,null,47.80349711595106,null,1.962252430580018,6.540841435266727,null,null,0.47720947636754835]
[null,null,"Wed-24",469.5,10,12.2,7.89,1.58,21200,45.154419595314167,{"$f":"IF(OR(D38<=0,D38=\"-\",H38<=0,G38<5),\"-\",ROUNDUP(ct(F38,G38,H38)*$I$10,0))","v":24},71.343982960596392,2.9726659566915163,1.4863329783457582,"0.8 (84.2%)",1.9039262155844212,6.3464207186147377,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wed",24,null,null,24,1.5428344359956394,null,null,48.708472579781414,null,1.9039262155844212,6.3464207186147377,null,null,0.49544432611525274]
[null,null,"Thu-25",462.6,10,11.4,8,1.57,21200,45.827929096411587,{"$f":"IF(OR(D39<=0,D39=\"-\",H39<=0,G39<5),\"-\",ROUNDUP(ct(F39,G39,H39)*$I$10,0))","v":27},71.949848681366191,2.66480921042097,1.332404605210485,"0.7 (79.0%)",1.4252254581456014,4.7507515271520049,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu",25,null,null,25,1.5428344359956394,null,null,53.382511845994173,null,1.4252254581456014,4.7507515271520049,null,null,0.44413486840349498]
[null,null,"Fri-26",423.4,10,10.8,7.96,1.69,21200,50.070854983467171,{"$f":"IF(OR(D40<=0,D40=\"-\",H40<=0,G40<5),\"-\",ROUNDUP(ct(F40,G40,H40)*$I$10,0))","v":28},84.61974492205951,3.0221337472164111,1.5110668736082056,"0.8 (85.0%)",1.9992120060845879,6.6640400202819601,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fri",26,null,null,26,1.5428344359956394,null,null,55.554127419774503,null,1.9992120060845879,6.6640400202819601,null,null,0.50368895786940182]
[null,null,"Sat-27",481.6,10,10.8,7.84,1.57,21200,44.019933554817271,{"$f":"IF(OR(D41<=0,D41=\"-\",H41<=0,G41<5),\"-\",ROUNDUP(ct(F41,G41,H41)*$I$10,0))","v":26},69.111295681063112,2.6581267569639659,1.329063378481983,"0.8 (83.8%)",1.8570083517791263,6.1900278392637542,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sat",27,null,null,27,1.5428344359956394,null,null,52.484593474252016,null,1.8570083517791263,6.1900278392637542,null,null,0.44302112616066097]
[null,null,"Sun-28",460.3,10,11.2,7.9,1.6,21200,46.056919400391045,{"$f":"IF(OR(D42<=0,D42=\"-\",H42<=0,G42<5),\"-\",ROUNDUP(ct(F42,G42,H42)*$I$10,0))","v":26},73.691071040625673,2.8342719631009876,1.4171359815504938,"0.8 (83.8%)",1.8496074818693844,6.1653582728979481,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sun",28,null,null,28,1.5428344359956394,null,null,52.382900734570555,null,1.8496074818693844,6.1653582728979481,null,null,0.47237866051683125]
[null,null,"Mon-29",450.5,10,11.1,7.9,1.58,21200,47.058823529411768,{"$f":"IF(OR(D43<=0,D43=\"-\",H43<=0,G43<5),\"-\",ROUNDUP(ct(F43,G43,H43)*$I$10,0))","v":26},74.352941176470594,2.8597285067873304,1.4298642533936652,"0.8 (83.9%)",1.8679632228869765,6.2265440762899216,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mon",29,null,null,29,1.5428344359956394,null,null,52.614551208064157,null,1.8679632228869765,6.2265440762899216,null,null,0.47662141779788841]
[null,null,"Tue-30",449.2,10,10.8,7.88,1.58,21200,47.195013357079254,{"$f":"IF(OR(D44<=0,D44=\"-\",H44<=0,G44<5),\"-\",ROUNDUP(ct(F44,G44,H44)*$I$10,0))","v":27},74.568121104185224,2.7617822631179711,1.3808911315589856,"0.8 (84.5%)",1.9356975661432434,6.4523252204774781,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tue",30,null,null,30,1.5428344359956394,null,null,53.302471734437688,null,1.9356975661432434,6.4523252204774781,null,null,0.46029704385299519]
[null,null,"Wed-31",460,10,9.9,7.88,1.55,21200,46.086956521739133,{"$f":"IF(OR(D45<=0,D45=\"-\",H45<=0,G45<5),\"-\",ROUNDUP(ct(F45,G45,H45)*$I$10,0))","v":28},71.434782608695656,2.5512422360248448,1.2756211180124224,"0.8 (82.2%)",1.6899820062594737,5.6332733541982458,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wed",31,null,null,31,1.5428344359956394,null,null,56.438132775868105,null,1.6899820062594737,5.6332733541982458,null,null,0.42520703933747411]
[null,null,"Min",{"$f":"MIN(D15:D45)","v":423.4},5,9.9,7.66,1,13300,26.6,{"$f":"MIN(K15:K45)","v":19},{"$f":"MIN(L15:L45)","v":35.910000000000004},{"$f":"MIN(M15:M45)","v":1.6322727272727275},{"$f":"MIN(N15:N45)","v":0.81613636363636377},"-",{"$f":"MIN(AR15:AR45)","v":0.69322201926481131},{"$f":"MIN(AS15:AS45)","v":2.3107400642160378},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average Giardia:",{"$f":"AVERAGE(N15:N45)","v":1.5428344359956394},null,null,null,1.5428344359956394,null,null,null,null,null,null,null,null,{"$f":"MIN(AV15:AV45)","v":0.27204545454545459}]
[null,null,"Median",{"$f":"IF(SUM(D15:D45)<=0,0,MEDIAN(D15:D45))","v":461.8},10,12.6,7.84,1.58,21200,45.907319185794712,{"$f":"IF(SUM(K15:K45)<=0,0,MEDIAN(K15:K45))","v":23},{"$f":"IF(SUM(L15:L45)<=0,0,MEDIAN(L15:L45))","v":73.67312552653749},{"$f":"IF(SUM(M15:M45)<=0,0,MEDIAN(M15:M45))","v":3.0903520333790135},{"$f":"IF(SUM(N15:N45)<=0,0,MEDIAN(N15:N45))","v":1.5451760166895068},"-",{"$f":"IF(SUM(AR15:AR45)<=0,0,MEDIAN(AR15:AR45))","v":2.3402193875354649},{"$f":"IF(SUM(AS15:AS45)<=0,0,MEDIAN(AS15:AS45))","v":7.8007312917848832},null,null,null,null,null,null,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(AV15:AV45)<=0,0,MEDIAN(AV15:AV45))","v":0.51505867222983559}]
[null,null,"Max",{"$f":"MAX(D15:D45)","v":524},10,14.2,8,1.91,21200,50.070854983467171,{"$f":"MAX(K15:K45)","v":28},{"$f":"MAX(L15:L45)","v":84.61974492205951},{"$f":"MAX(M15:M45)","v":3.7560533879286582},{"$f":"MAX(N15:N45)","v":1.8780266939643291},"-",{"$f":"MAX(AR15:AR45)","v":5.5112729495079513},{"$f":"MAX(AS15:AS45)","v":18.370909831693172},null,null,null,null,null,null,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(AV15:AV45)","v":0.62600889798810966}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Input lower limit for Microcystin-LR:",0.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"**Input lower limit for Microcystin-LR:",1]
[null,null,"Print Name:",null,null,null,null,null,null,null,null,null,null,null,null,"Certification Grade:"]
[null,null,"Signature:",null,null,null,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,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,null,null,null,1,"pH = 6 - 7.5, Temp. =0.5 - 5","(((0.054593*Temp-0.724312)*pH^3+(-0.6256*Temp+12.477719)*pH^2+(1.294209*Temp-70.944966)*pH+(3.030396*Temp+132.808815))*Cl2^3+((-0.02405*Temp+3.017353)*pH^3+(-2.097902*Temp-50.312189)*pH^2+(29.962166*Temp+274.770836)*pH+(-99.402678*Temp-489.05991))*Cl2^2+((-0.223814*Temp-3.971102)*pH^3+(8.707453*Temp+67.459877)*pH^2+(-85.25943*Temp-369.50842)*pH+(245.646765*Temp+664.675784))*Cl2+((-0.089392*Temp+5.224849)*pH^3+(-1.181041*Temp-86.624265)*pH^2+(23.474895*Temp+520.229255)*pH+(-87.55289*Temp-997.046738)))/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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"pH = 7.5 - 9, Temp. =0.5 - 5","(((-0.7020938*Temp+3.5733149)*pH^3+(17.814838*Temp-90.136851)*pH^2+(-150.558342*Temp+758.462105)*pH+(423.877253*Temp-2128.735987))*Cl2^3+((3.601029*Temp-18.829319)*pH^3+(-91.39749*Temp+474.28891)*pH^2+(772.928695*Temp-3989.315672)*pH+(-2177.879769*Temp+11199.3420069999))*Cl2^2+((-5.539127*Temp+30.129018)*pH^3+(140.353008*Temp-754.05395)*pH^2+(-1186.895443*Temp+6329.73596)*pH+(3345.252009*Temp-17755.492085))*Cl2+((2.339882*Temp-13.340437)*pH^3+(-60.617604*Temp+352.904206)*pH^2+(516.724386*Temp-3005.330553)*pH+(-1468.467529*Temp+8553.405579)))/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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"pH = 6 - 7.5,\nTemp. =5 - 10","(((-0.362791*Temp+1.362608)*pH^3+(7.232963*Temp-26.815097)*pH^2+(-47.886815*Temp+174.960153)*pH+(105.288034*Temp-378.47937))*Cl2^3+((1.882284*Temp-6.514319)*pH^3+(-37.396354*Temp+126.18007)*pH^2+(246.680403*Temp-808.820349)*pH+(-540.289711*Temp+1715.375256))*Cl2^2+((-3.008632*Temp+9.952988)*pH^3+(59.483658*Temp-186.421153)*pH^2+(-390.666029*Temp+1157.524574)*pH+(851.665601*Temp-2365.4184))*Cl2+((1.207859*Temp-1.261405)*pH^3+(-24.223377*Temp+28.587413)*pH^2+(159.139195*Temp-158.092244)*pH+(-348.201599*Temp+306.196809)))/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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"pH = 7.5 - 9, Temp. =5 - 10","(((0.080557*Temp-0.339938)*pH^3+(-1.98478*Temp+8.861236)*pH^2+(16.273738*Temp-75.698298)*pH+(-44.455298*Temp+212.926772))*Cl2^3+((-0.36963*Temp+1.023976)*pH^3+(9.147103*Temp-28.434068)*pH^2+(-75.245381*Temp+251.554712)*pH+(206.110768*Temp-720.610679))*Cl2^2+((0.291816*Temp+0.974304)*pH^3+(-7.370409*Temp-15.436868)*pH^2+(60.997193*Temp+90.27278)*pH+(-167.643738*Temp-191.01335))*Cl2+((0.168631*Temp-2.484182)*pH^3+(-4.805994*Temp+73.846154)*pH^2+(41.268332*Temp-628.050282)*pH+(-117.973826*Temp+1800.937062)))/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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"pH = 6 - 7.5, \nTemp. =10 - 15","(((0.682732*Temp-9.092623)*pH^3+(-13.5918*Temp+181.432536)*pH^2+(89.85314*Temp-1202.4394)*pH+(-197.2525*Temp+2646.925967))*Cl2^3+((-3.468198*Temp+46.99051)*pH^3+(69.002248*Temp-937.805945)*pH^2+(-455.87808*Temp+6216.76449)*pH+(1000.149851*Temp-13689.020364))*Cl2^2+((5.342987*Temp-73.563201)*pH^3+(-106.489545*Temp+1473.31088)*pH^2+(704.503235*Temp-9794.16807)*pH+(-1547.815194*Temp+21629.389558))*Cl2+((-2.461281*Temp+35.429997)*pH^3+(48.79779*Temp-701.624257)*pH^2+(-323.307607*Temp+4666.375776)*pH+(710.051699*Temp-10276.336174)))/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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"pH = 7.5 - 9,\nTemp. =10 - 15","(((-0.278806*Temp+3.253691)*pH^3+(6.862745*Temp-79.614012)*pH^2+(-56.327699*Temp+650.316076)*pH+(154.184661*Temp-1773.472825))*Cl2^3+((1.449384*Temp-17.166167)*pH^3+(-35.576923*Temp+418.806195)*pH^2+(291.337206*Temp-3414.271158)*pH+(-795.99151*Temp+9300.412103))*Cl2^2+((-1.975694*Temp+23.649406)*pH^3+(48.093622*Temp-570.077177)*pH^2+(-391.627053*Temp+4616.515237)*pH+(1065.427517*Temp-12521.725896))*Cl2+((0.559973*Temp-6.397603)*pH^3+(-13.912089*Temp+164.9071)*pH^2+(112.129943*Temp-1336.666393)*pH+(-302.891125*Temp+3650.11005)))/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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"pH = 6 - 7.5,\nTemp. =15 - 20","(((-0.159971*Temp+3.547923)*pH^3+(3.090292*Temp-68.798846)*pH^2+(-19.776097*Temp+441.999159)*pH+(41.90105*Temp-940.377289))*Cl2^3+((0.614386*Temp-14.248252)*pH^3+(-11.680819*Temp+272.440059)*pH^2+(73.401598*Temp-1722.430691)*pH+(-152.30457*Temp+3597.795946))*Cl2^2+((-0.545383*Temp+14.762346)*pH^3+(9.862902*Temp-271.97582)*pH^2+(-58.484348*Temp+1650.645676)*pH+(112.96769*Temp-3282.353712))*Cl2+((0.144665*Temp-3.659196)*pH^3+(-2.75823*Temp+71.716046)*pH^2+(16.295953*Temp-427.677626)*pH+(-31.994357*Temp+854.354665)))/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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"pH = 7.5 - 9,\nTemp. =15 - 20","(((0.382216*Temp-6.661639)*pH^3+(-9.565679*Temp+166.812352)*pH^2+(79.613584*Temp-1388.803174)*pH+(-220.358132*Temp+3844.669075))*Cl2^3+((-1.834832*Temp+32.09707)*pH^3+(45.831669*Temp-802.322682)*pH^2+(-380.597738*Temp+6664.752992)*pH+(1050.876629*Temp-18402.609989))*Cl2^2+((2.565464*Temp-44.467967)*pH^3+(-63.918572*Temp+1110.105727)*pH^2+(528.84809*Temp-9190.611913)*pH+(-1454.206153*Temp+25272.779157))*Cl2+((-1.182284*Temp+19.736264)*pH^3+(28.809591*Temp-475.918094)*pH^2+(-234.929209*Temp+3869.220876)*pH+(636.311101*Temp-10437.923339)))/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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"pH = 6 - 7.5,\nTemp. =20 - 25","(((-0.179396*Temp+3.936423)*pH^3+(3.588201*Temp-78.757026)*pH^2+(-23.81236*Temp+522.724411)*pH+(52.460407*Temp-1151.564416))*Cl2^3+((0.740926*Temp-16.779054)*pH^3+(-14.735265*Temp+333.528969)*pH^2+(97.197385*Temp-2198.346431)*pH+(-212.78846*Temp+4807.473745))*Cl2^2+((-0.928222*Temp+22.419133)*pH^3+(18.214114*Temp-439.000067)*pH^2+(-118.660808*Temp+2854.174889)*pH+(256.503231*Temp-6153.064526))*Cl2+((0.18355*Temp-4.436896)*pH^3+(-3.582018*Temp+88.191805)*pH^2+(22.177488*Temp-545.308335)*pH+(-46.114283*Temp+1136.753194)))/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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"pH = 7.5 - 9, Temp. =20 - 25","(((-0.326226*Temp+7.507199)*pH^3+(8.153366*Temp-187.56856)*pH^2+(-67.79089*Temp+1559.28631)*pH+(187.452867*Temp-4311.55091))*Cl2^3+((1.759907*Temp-39.797702)*pH^3+(-43.848651*Temp+991.28372)*pH^2+(363.491093*Temp-8217.023631)*pH+(-1002.245882*Temp+22659.84024))*Cl2^2+((-2.969635*Temp+66.234011)*pH^3+(73.576463*Temp-1639.794958)*pH^2+(-606.846389*Temp+13523.277673)*pH+(1664.984026*Temp-37111.024429))*Cl2+((1.578688*Temp-35.483183)*pH^3+(-39.198801*Temp+884.249744)*pH^2+(321.887643*Temp-7267.116167)*pH+(-879.070324*Temp+19869.705156)))/3"]

{"sheet":"CyanoCT_Table","index":1,"n_rows":59,"n_cols":16,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[null,"Author:  Guy Schott, P.E., guy.schott@waterboards.ca.gov, 707-576-2732"]
[]
[null,null,"CT Table for Microcystin-LR based on Free Chlorine Residual"]
[]
[null,null,null,"Temperature: 10 oC",null,null,null,null,null,null,"Temperature: 20 oC"]
[null,null,null,"Log Reduction of Microcystin-LR",null,null,null,null,null," ","Log Reduction of Microcystin-LR"]
[null,null,"pH",0.5,1,1.5,2,2.5,3,"pH",0.5,1,1.5,2,2.5,3]
[null,null,6,13.225,26.45,39.674999999999997,52.9,66.125,79.349999999999994,6,10.195,20.39,30.585000000000001,40.78,50.975000000000001,61.17]
[null,null,6.5,16.215,32.43,48.644999999999996,64.86,81.075000000000003,97.289999999999992,6.5,12.07,24.14,36.21,48.28,60.35,72.42]
[null,null,7,20.14,40.28,60.42,80.56,100.7,120.84,7,14.8,29.6,44.400000000000006,59.2,74,88.800000000000011]
[null,null,7.5,29.925000000000001,59.85,89.775000000000006,119.7,149.625,179.55,7.5,21.9,43.8,65.699999999999989,87.6,109.5,131.39999999999998]
[null,null,8,55.895000000000003,111.79,167.685,223.58,279.47500000000002,335.37,8,40.869999999999997,81.739999999999995,122.60999999999999,163.47999999999999,204.35,245.21999999999997]
[null,null,8.5,110.505,221.01,331.51499999999999,442.02,552.52499999999998,663.03,8.5,80.87,161.74,242.61,323.48,404.35,485.22]
[null,null,9,182.10499999999999,364.21,546.31499999999994,728.42,910.52499999999998,1092.6299999999999,9,133.49,266.98,400.47,533.96,667.45,800.94]
[null,null,null,"Temperature: 15 oC",null,null,null,null,null,null,"Temperature: 25 oC"]
[null,null,null,"Log Reduction of Microcystin-LR",null,null,null,null,null," ","Log Reduction of Microcystin-LR"]
[null,null,"pH",0.5,1,1.5,2,2.5,3,"pH",0.5,1,1.5,2,2.5,3]
[null,null,6,11.515000000000001,23.03,34.545000000000002,46.06,57.575000000000003,69.09,6,9.1449999999999996,18.29,27.434999999999999,36.58,45.724999999999994,54.87]
[null,null,6.5,13.835000000000001,27.67,41.505000000000003,55.34,69.175000000000011,83.01,6.5,10.7,21.4,32.099999999999994,42.8,53.5,64.199999999999989]
[null,null,7,17.059999999999999,34.119999999999997,51.179999999999993,68.239999999999995,85.3,102.35999999999999,7,13.065,26.13,39.195,52.26,65.325000000000003,78.39]
[null,null,7.5,25.29,50.58,75.87,101.16,126.44999999999999,151.74,7.5,19.309999999999999,38.619999999999997,57.929999999999993,77.239999999999995,96.55,115.85999999999999]
[null,null,8,47.215000000000003,94.43,141.64500000000001,188.86,236.07500000000002,283.29000000000002,8,36.024999999999999,72.05,108.07499999999999,144.1,180.125,216.14999999999998]
[null,null,8.5,93.394999999999996,186.79,280.185,373.58,466.97499999999997,560.37,8.5,71.31,142.62,213.93,285.24,356.55,427.86]
[null,null,9,154.05500000000001,308.11,462.16500000000002,616.22,770.27500000000009,924.33,9,117.77,235.54,353.31,471.08,588.85,706.62]
[null,null,"CT units:","mg/L*min",null,"0.5 Log = 68.4%; 1.0 Log = 90.0%; 1.5 Log = 96.8%; 2 Log = 99.0%; 2.5 Log = 99.7%; 3 Log = 99.9%"]
[]
[null,null,"CT Table for Cylindrospermopsin (CYN) based on Free Chlorine Residual"]
[]
[null,null,null,"Temperature: 10 oC",null,null,null,null,null,null,"Temperature: 20 oC"]
[null,null," ","Log Reduction of Cylindrospermospsin",null,null,null,null,null," ","Log Reduction of Cylindrospermospsin"]
[null,null,"pH",0.5,1,1.5,2,2.5,3,"pH",0.5,1,1.5,2,2.5,3]
[null,null,6,4.9005000000000001,9.8010000000000002,14.701499999999999,19.602,24.502500000000001,29.402999999999999,6,3.0510000000000002,6.1020000000000003,9.1530000000000005,12.204000000000001,15.255000000000001,18.306000000000001]
[null,null,6.5,2.5114999999999998,5.0229999999999997,7.5344999999999995,10.045999999999999,12.557499999999999,15.068999999999999,6.5,1.5640000000000001,3.1280000000000001,4.6920000000000002,6.2560000000000002,7.82,9.3840000000000003]
[null,null,7,1.7390000000000001,3.4780000000000002,5.2170000000000005,6.9560000000000004,8.6950000000000003,10.434000000000001,7,1.083,2.1659999999999999,3.2489999999999997,4.3319999999999999,5.415,6.4979999999999993]
[null,null,7.5,1.984,3.968,5.952,7.9359999999999999,9.92,11.904,7.5,1.2355,2.4710000000000001,3.7065000000000001,4.9420000000000002,6.1775000000000002,7.4130000000000003]
[null,null,8,4.024,8.048,12.071999999999999,16.096,20.12,24.143999999999998,8,2.5049999999999999,5.01,7.5149999999999997,10.02,12.524999999999999,15.03]
[null,null,8.5,12.702500000000001,25.405000000000001,38.107500000000002,50.81,63.512500000000003,76.215000000000003,8.5,7.91,15.82,23.73,31.64,39.549999999999997,47.46]
[null,null,9,40.618499999999997,81.236999999999995,121.85549999999999,162.47399999999999,203.09249999999997,243.71099999999998,9,25.265000000000001,50.53,75.795000000000002,101.06,126.325,151.59]
[null,null,null,"Temperature: 15 oC",null,null,null,null,null,null,"Temperature: 25 oC"]
[null,null,null,"Log Reduction of Cylindrospermospsin",null,null,null,null,null," ","Log Reduction of Cylindrospermospsin"]
[null,null,"pH",0.5,1,1.5,2,2.5,3,"pH",0.5,1,1.5,2,2.5,3]
[null,null,6,3.851,7.702,11.553000000000001,15.404,19.254999999999999,23.106000000000002,6,2.4365000000000001,4.8730000000000002,7.3094999999999999,9.7460000000000004,12.182500000000001,14.619]
[null,null,6.5,1.9735,3.9470000000000001,5.9205000000000005,7.8940000000000001,9.8674999999999997,11.841000000000001,6.5,1.2490000000000001,2.4980000000000002,3.7470000000000003,4.9960000000000004,6.245000000000001,7.4940000000000007]
[null,null,7,1.3665,2.7330000000000001,4.0994999999999999,5.4660000000000002,6.8325000000000005,8.1989999999999998,7,0.86450000000000005,1.7290000000000001,2.5935000000000001,3.4580000000000002,4.3224999999999998,5.1870000000000003]
[null,null,7.5,1.5589999999999999,3.1179999999999999,4.6769999999999996,6.2359999999999998,7.7949999999999999,9.3539999999999992,7.5,0.98650000000000004,1.9730000000000001,2.9595000000000002,3.9460000000000002,4.9325000000000001,5.9190000000000005]
[null,null,8,3.1625000000000001,6.3250000000000002,9.4875000000000007,12.65,15.8125,18.975000000000001,8,2.0005000000000002,4.0010000000000003,6.0015000000000001,8.0020000000000007,10.002500000000001,12.003]
[null,null,8.5,9.9819999999999993,19.963999999999999,29.945999999999998,39.927999999999997,49.91,59.891999999999996,8.5,6.3155000000000001,12.631,18.9465,25.262,31.577500000000001,37.893000000000001]
[null,null,9,31.919,63.838000000000001,95.757000000000005,127.676,159.595,191.51400000000001,9,20.195,40.39,60.585000000000001,80.78,100.97499999999999,121.17]
[null,null,null,"Temperature: 30 oC"]
[null,null,null,"Log Reduction of Cylindrospermospsin"]
[null,null,"pH",0.5,1,1.5,2,2.5,3]
[null,null,6,1.96,3.92,5.88,7.84,9.8000000000000007,11.76]
[null,null,6.5,1.0044999999999999,2.0089999999999999,3.0134999999999996,4.0179999999999998,5.0225,6.0269999999999992]
[null,null,7,0.69550000000000001,1.391,2.0865,2.782,3.4775,4.173]
[null,null,7.5,0.79349999999999998,1.587,2.3805000000000001,3.1739999999999999,3.9674999999999998,4.7610000000000001]
[null,null,8,1.6094999999999999,3.2189999999999999,4.8285,6.4379999999999997,8.0474999999999994,9.657]
[null,null,8.5,5.0804999999999998,10.161,15.241499999999998,20.321999999999999,25.4025,30.482999999999997]
[null,null,9,16.245999999999999,32.491999999999997,48.738,64.983999999999995,81.22999999999999,97.475999999999999]
[null,null,"CT units:","mg/L*min",null,"0.5 Log = 68.4%; 1.0 Log = 90.0%; 1.5 Log = 96.8%; 2 Log = 99.0%; 2.5 Log = 99.7%; 3 Log = 99.9%"]