{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["carbonate","lime"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":0,"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":"carbonate","index":0,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["original pH",6.5,null,null,null,null,null,"Na",23,2]
["target pH",7,null,null,null,null,null,"C",12,1]
["measured hardness",20,"mg/L","as calcium carbonate",null,null,null,"O",16,3]
["hardness",{"$f":"B3/100000","v":2.0000000000000001E-4},"eq/L",null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(I1:I3,J1:J3)","v":106}]
["ANCinitial",{"$f":"ANCopen(B1)","v":1.5569350708059012E-5},{"$f":"ANCclosed(B1,B4)","v":1.2236971028485992E-4},{"$f":"C5*100000","v":12.236971028485993},"mg/L as CaCO3"]
["Ctinitial",{"$f":"10^-5/alpha0Co2(B1)","v":2.5851443811042655E-5}]
[]
["ANCtarget",{"$f":"ANCclosed(B2,B6)","v":2.1563971151288893E-5},{"$f":"ANCclosed(B2,B4)","v":1.6682991719075798E-4}]
[]
["increase in ANC",{"$f":"B8-B5","v":5.9946204432298812E-6},{"$f":"C8-C5","v":4.4460206905898059E-5},"eq/L"]
["sodium carbonate dose to raise pH",{"$f":"B10/B15","v":2.9973102216149406E-6},null,"mol/L"]
[]
["sodium carbonate price per kg",0.53]
["Kg/mole",{"$f":"K4/1000","v":0.106}]
["eq/mole",2]
["price per eq",{"$f":"B13*B14/B15","v":2.809E-2},"$/eq",null,null,null,null,"alum"]
[null,null,null,null,null,null,"cost",0.37330000000000002,"$/kg"]
["sodium carbonate price per liter",{"$f":"B10*B16","v":1.6838888825032736E-7}]
["per capita",130,"L/person/day"]
["people per house",6]
["days per month",30]
["consumption per month",{"$f":"B21*B20*B19","v":23400},"L"]
["price per month to raise the pH ",{"$f":"B22*B18","v":3.94029998505766E-3},"$/month/household"]
["price per month to compensate for alum and raise pH",{"$f":"B34*B22","v":0.12345048180323946},"$/month/household"]
[]
[]
[]
["alum dose",20,"mg/L","max dose"]
["alum molecular weight",660,"g/Mole"]
["alum dose mol/L",{"$f":"B28/1000/B29","v":3.0303030303030302E-5},"mole/L"]
["alum eq/mol",6,"eq/mol"]
["alum dose eq/L",{"$f":"B30*B31","v":1.8181818181818181E-4},"eq/L"]
["total sodium carbonate dose",{"$f":"B32/B15+B11","v":9.3906401130705846E-5},"Mole/L"]
["sodium carbonate price per liter",{"$f":"B16*B15*B33","v":5.2756616155230542E-6}]
["sodium carbonate price per day",{"$f":"B34*B44*1440","v":2.156812863775305},"$"]
[]
["alum price per liter",{"$f":"H17*B28/1000000","v":7.4660000000000002E-6}]
["alum price per day",{"$f":"B37*B44*1440","v":3.0522740112000002}]
[]
["chemical cost per year",{"$f":"(B38+B35)*365","v":1901.3167093659865}]
[]
["sodium carbonate dose",{"$f":"B33*B14","v":9.9540785198548195E-6},"kg/L"]
[null,{"$f":"B42*1000000","v":9.9540785198548196},"mg/L"]
["plant flow rate",{"$f":"75*3.7854","v":283.90500000000003},"Lpm"]
["sodium carbonate flux",{"$f":"B44*B42*1440","v":4.0694582335383114},"kg/day"]
["alum flux",{"$f":"B44*B28*1440/1000000","v":8.1764640000000011},"kg/day"]
["solubility sodium carbonate",300,"g/L at 20 C"]

{"sheet":"lime","index":1,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["original pH",6.5,null,null,null,null,null,"Ca"]
["target pH",7,null,null,null,null,null,"O"]
["measured hardness",null,20,"mg/L","as calcium carbonate"]
["hardness",0,{"$f":"C3/100000","v":2.0000000000000001E-4},"eq/L"]
["ANCinitial",{"$f":"ANCclosed(B1,B4)","v":-2.8460498941515413E-7},{"$f":"ANCclosed(B1,C4)","v":1.2236971028485992E-4},{"$f":"C5*100000","v":12.236971028485993},"mg/L as CaCO3",null,null,"H"]
["Ctinitial",0]
[]
["ANCtarget",{"$f":"ANCclosed(B2,B6)","v":1.3234889800848443E-23},{"$f":"ANCclosed(B2,C4)","v":1.6682991719075798E-4}]
[]
["increase in ANC",{"$f":"B8-B5","v":2.8460498941515413E-7},{"$f":"C8-C5","v":4.4460206905898059E-5},"eq/L"]
["lime dose to raise pH",{"$f":"B10/B15","v":1.4230249470757706E-7},null,"mol/L"]
[]
["lime price per kg",0.3]
["Kg/mole",7.4091799999999999E-2]
["eq/mole",2]
["price per eq",{"$f":"B13*B14/B15","v":1.111377E-2},"$/eq",null,null,null,null,"alum"]
[null,null,null,null,null,null,"cost",0.4,"$/kg"]
["lime price per liter",{"$f":"B10*B16","v":3.1630343932124575E-9}]
["per capita",130,"L/person/day"]
["people per house",6]
["days per month",30]
["consumption per month",{"$f":"B21*B20*B19","v":23400},"L"]
["price per month to raise the pH ",{"$f":"B22*B18","v":7.4015004801171507E-5},"$/month/household"]
["price per month to compensate for alum and raise pH",{"$f":"B34*B22","v":5.9179064550255719E-2},"$/month/household"]
[]
[]
[]
["alum dose",25,"mg/L","max dose"]
["alum molecular weight",660,"g/Mole"]
["alum dose mol/L",{"$f":"B28/1000/B29","v":3.7878787878787879E-5},"mole/L"]
["alum eq/mol",6,"eq/mol"]
["alum dose eq/L",{"$f":"B30*B31","v":2.2727272727272727E-4},"eq/L"]
["total lime dose",{"$f":"B32/B15+B11","v":1.1377866613107121E-4},"Mole/L"]
["lime price per liter",{"$f":"B16*B15*B33","v":2.5290198525750306E-6}]
["lime price per day",{"$f":"B34*B43*1440","v":1.0339219889932525},"$"]
[]
["alum price per liter",{"$f":"H17*B28/1000000","v":1.0000000000000001E-5}]
["alum price per day",{"$f":"B37*B43*1440","v":4.0882320000000005}]
[]
["chemical cost per year",{"$f":"(B38+B35)*365","v":1869.5862059825372}]
[]
["lime dose",{"$f":"B33*B14","v":8.4300661752501015E-6},"kg/L"]
["plant flow rate",{"$f":"75*3.7854","v":283.90500000000003},"Lpm"]
["lime flux",{"$f":"B43*B42*1440","v":3.4464066299775076},"kg/day"]
["alum flux",{"$f":"B43*B28*1440/1000000","v":10.220580000000002},"kg/day"]
["solubility"]
[]
[]
[null,null,"pOH"]
["lime pH",12.54,{"$f":"14-B50","v":1.4600000000000009},{"$f":"[1]!invp(C50)","v":{"$error":"#NAME?"}}]
["ANClime",{"$f":"[1]!ANCclosed(B50,0)","v":{"$error":"#NAME?"}},"eq/L"]
["lime feed ratio",{"$f":"B51/B32","v":{"$error":"#NAME?"}},"fraction of plant flow that must go through lime feeder"]
["lime flow rate",{"$f":"B43/B52","v":{"$error":"#NAME?"}},"L/min"]
[]
["lime concentration",{"$f":"B51/B15*B14*1000000","v":{"$error":"#NAME?"}},"mg/L"]