{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","Project Details","Unit Operation and Processes","Summary of Capital Costs","Summary of O&M Costs","Present & Annul Value"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Introduction","index":0,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,3,16],[4,0,13,16],[14,0,31,16]]}
["This Template is Result of MS Thesis by Jwala Raj Sharma."]
[]
[]
[]
["Un-Authorized Use of This Template is Prohibited"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["© Jwala Raj Sharma 2010"]

{"sheet":"Project Details","index":1,"n_rows":32,"n_cols":20,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,1,3,5],[4,1,4,5]]}
["Project Details"]
[]
["Date:"]
["Name of the Project:"]
["Project Location:"]
["Design Capacity: ",null,"Mgd",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C6=\"Mgd\",B6,(IF(C6=\"gal/d\",B6/1000000,IF(C6=\"m3/d\",264.172052358*B6/1000000,0))))","v":0},"plant capacity in mgd",null,null,null,null,"Mgd"]
["Average Plant Flow",null,"of Design Capacity"]
["Project Design Life:",null,"years",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B23=\"ENR CCI\", 8585.71, 4764.44)","v":8585.7099999999991},{"$f":"B24/N8","v":0},"Single Factor",null,null,null,"gal/d"]
["Interest Rate:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m3/d"]
["Expected Inflation Rate:"]
["Current Labor Price (including fringes and benefits):",null," /hr",null,null,null,null,null,null,{"$f":"B11/45.82","v":0},"OF4",null,null,null,null,null,null,null,null,"ENR CCI"]
["Current Electricity Price:",null," /kW.hr",null,null,null,null,null,null,{"$f":"B12/0.0981","v":0},"OF1",null,null,10,null,null,null,null,null,"ENR BCI"]
["Current Diesel Price:",null," /gal",null,null,null,null,null,null,{"$f":"B13/2.626","v":0},"OF5",null,null,0.03]
["Current Natural Gas Price:",null," /scf",null,null,null,null,null,null,{"$f":"B14/0.00898","v":0},"OF2",null,null,0.45]
["Special Costs:",null,"of Construction Cost",null,null,null,null,null,null,{"$f":"IF(B22=\"Single\",B24/8585.71,B32/173.4)","v":0},"OF3",null,null,1.2999999999999999E-3]
["    General Contractor's Overhead:",null,"of Construction Cost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single"]
["    Engineering:",null,"of Construction Cost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Multiple"]
["    Land",null,"of Construction Cost"]
["    Legal",null,"of Construction Cost"]
["    Fiscal",null,"of Construction Cost"]
["    Administrative",null,"of Construction Cost"]
["Indexes to Use:","Single",{"$f":"IF(B22=\"Multiple\", \"You must enter all applicable indexes listed below\", \"\")","v":""}]
[{"$f":"IF(B22=\"Single\", \"Single Index to Use:\",\"\")","v":"Single Index to Use:"},"ENR CCI"]
[{"$f":"IF(B$22=\"Single\",\"Enter Single Index Value:\", \"\")","v":"Enter Single Index Value:"}]
[{"$f":"IF(B$22=\"Single\",\"\",\"Enter ENR Skilled Labor Wage Index Value:\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,8251.14,{"$f":"B25/N25","v":0},"F1&5"]
[{"$f":"IF(B$22=\"Single\",\"\",\"Enter BLS General Purpose Machinery Index Value:\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,199.1,{"$f":"B26/N26","v":0},"F2"]
[{"$f":"IF(B$22=\"Single\",\"\",\"Enter BLS Concrete Ingredients Index Value:\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,235.2,0,"F3"]
[{"$f":"IF(B$22=\"Single\",\"\",\"Enter BLS Steel Mill Products Index Value:\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,169.2,0,"F4"]
[{"$f":"IF(B$22=\"Single\",\"\",\"Enter BLS Valves and Fittings Index Value:\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,227.4,0,"F6"]
[{"$f":"IF(B$22=\"Single\",\"\",\"Enter BLS Electrical Machinery and Equipments Index Value:\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,113.7,0,"F7"]
[{"$f":"IF(B$22=\"Single\",\"\",\"Enter ENR Building Cost Index Value:\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,4764.4399999999996,0,"F8"]
[{"$f":"IF(B$22=\"Single\",\"\",\"BLS Producer Price Index:\")","v":""}]

{"sheet":"Unit Operation and Processes","index":2,"n_rows":336,"n_cols":34,"rows_kept":336,"cut":false,"hidden":false,"merged":[[277,3,277,4]]}
["Raw Water Pumping Facility"]
[]
["Select Pumping Head:",null,"Not Required",null,null,null,null,null,30,null,{"$f":"'Project Details'!O25","v":0},{"$f":"'Project Details'!O26","v":0},{"$f":"'Project Details'!O27","v":0},{"$f":"'Project Details'!O28","v":0},{"$f":"'Project Details'!O25","v":0},{"$f":"'Project Details'!O29","v":0},{"$f":"'Project Details'!O30","v":0},{"$f":"'Project Details'!O31","v":0},null,null,null,null,{"$f":"'Project Details'!J12","v":0},{"$f":"'Project Details'!J14","v":0},{"$f":"'Project Details'!J15","v":0},{"$f":"'Project Details'!J11","v":0},{"$f":"'Project Details'!J13","v":0}]
["Construction Cost:",{"$f":"IF(C3=30,9355.4*'Project Details'!N6+60290,IF(C3=100,12627*'Project Details'!N6+68364,0))*I7","v":0},null,null,null,null,null,null,100,null,null,0.44,null,null,0.13,0.28000000000000003,0.15,null,{"$f":"K4*K$3+L4*L$3+M4*M$3+N4*N$3+O4*O$3+P4*P$3+Q4*Q$3+R4*R$3","v":0},"Raw water pumping, 30",null,null,0.73,null,0.05,0.22,null,{"$f":"W4*$W$3+X4*X$3+Y4*Y$3+Z4*Z$3+AA4*AA$3","v":0}]
["O&M Cost:",{"$f":"IF(C3=I5,0,IF(C3=I3,(5768.2*'Project Details'!N6+23723)*'Unit Operation and Processes'!AB4,(8709.5*'Project Details'!N6+23723)*'Unit Operation and Processes'!AB5))","v":0},null,null,null,null,null,null,"Not Required",null,null,0.6,null,null,0.1,0.17,0.13,null,{"$f":"K5*K$3+L5*L$3+M5*M$3+N5*N$3+O5*O$3+P5*P$3+Q5*Q$3+R5*R$3","v":0},"Raw water pumping, 100",null,null,0.81,null,0.04,0.15,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0.4,null,null,0.06,0.04,0.03,0.47,{"$f":"K6*K$3+L6*L$3+M6*M$3+N6*N$3+O6*O$3+P6*P$3+Q6*Q$3+R6*R$3","v":0},"Cylinder Storage",null,null,0.18,null,0.08,0.74,null,0]
["Pre-Treatment",null,null,null,null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,IF(C3=30,S4,S5))","v":0},"Factor",null,0.8,null,0.02,0.1,0.04,0.03,0.01,0,"On-Site",null,null,0.02,null,0.23,0.75,null,0]
["Chlorine Storage Feed System:",null,"Not Required",null,null,null,null,null,null,null,null,0.82,null,null,0.08,0.05,0.03,0.02,0,"Direct Feed",null,null,0.03,null,0.28999999999999998,0.68,null,0]
["Chlorine Dose:",null,"mg/L",null,null,null,null,null,null,null,null,0.28999999999999998,null,null,0.36,0.03,0.02,0.3,0,"Chlorine Dioxide",null,null,0.06,null,0.09,0.85,null,0]
["Chlorine Price:",null,"$/lb",null,null,null,{"$f":"G11*'Project Details'!$B$7*365","v":0}]
["Construction Cost:",{"$f":"IF(C8=I11,0.000003*G11^3-0.0423*G11^2+267.97*G11+29368,IF(C8=I12,0.000001*G11^3-0.0158*G11^2+98.896*G11+10708,IF(C8=I13,0.0019*G11^2+13.734*G11+47956,0)))*G12","v":0},null,null,null,null,{"$f":"B9*'Project Details'!N$6*8.34","v":0},null,"Cylinder Storage",null,null,0.83,null,null,0.15,null,null,0.02,0,"Ozone Generation System",null,null,0.76,null,0.08,0.16,null,0]
["O&M Cost:",{"$f":"IF(C8=I14,0, IF(C8=I11,(0.0000005*G11^3-0.0085*G11^2+65.019*G11+20205)*AB6,IF(C8=I12,(-0.003*G11^2+5.8195*G11+43965)*AB7,(-0.00006*G11^2+2.1722*G11+42499)*AB8)))","v":0},null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,IF(C8=I11,S6,IF(C8=I12,S7,S8)))","v":0},null,"On-site storage tank with rail delivery",null,null,0.06,0.21,0.24,0.49,null,null,null,0,"Ozone Contact Chamber"]
["Chemical Cost:",{"$f":"B10*G10","v":0},null,null,null,null,null,null,"Direct feed from rail car",null,null,0.66,null,null,0.25,0.03,0.06,null,0,"On-Side Hypochlorite",null,null,0.7,null,0.1,0.2,null,0]
[null,null,null,null,null,null,null,null,"Not Required",null,0.01,0.56000000000000005,0.04,0.05,0.08,0.14000000000000001,0.1,0.02,0,"PAC Feed",null,null,0.27,null,0.17,0.56000000000000005,null,0]
["Chlorine Dioxide Generating and Feed System:",null,"Not Required",null,null,null,{"$f":"G16*'Project Details'!$B$7*365*0.53","v":0},null,null,null,null,0.49,null,null,0.42,null,0.08,0.01,0,"PAC RE-FBP",null,"Required",0.41,0.44,0.02,0.13,null,0]
["Chlorine Dioxide Dose:",null,"mg/L",null,null,null,{"$f":"B15*'Project Details'!N$6*8.34","v":0},null,"lb/day",null,null,0.85,null,null,null,null,7.0000000000000007E-2,0.08,0,"PAC RE-ASP",null,"Not Required",7.0000000000000007E-2,0.75,0.02,0.16,null,0]
["Chlorine Price:",null,"$/lb",null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S9)","v":0},null,"kg/day",null,0.01,0.63,0.02,0.02,0.21,null,0.09,0.02,0,"DAB",null,null,0.74,null,0.01,0.25,null,0]
["Construction Cost:",{"$f":"IF(C15=V16,0,-0.0783*G16^2+663.68*G16+82909)*G17","v":0},null,null,null,null,null,null,null,null,null,0.64,7.0000000000000007E-2,7.0000000000000007E-2,0.2,null,0.02,null,0,"AT",null,null,0.63,null,0.15,0.22,null,0]
["O&M Cost:",{"$f":"IF(C15=I14,0,(-0.0106*G16^2+105.82*G16+32441)*AB9)","v":0},null,null,null,null,null,null,null,null,null,0.64,null,null,0.14000000000000001,0.02,0.04,0.16,0,"Liq AF",null,null,0.52,null,0.03,0.45,null,0]
["Chemical Cost:",{"$f":"B17*G15","v":0},null,null,null,null,null,null,null,null,null,0.41,null,null,0.04,0.05,0.03,0.47,0,"D AF, Ferrous & Ferric, 3 processes",null,null,0.13,null,0.01,0.86,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0.7,null,null,0.04,0.02,0.04,0.2,0,"Polymer Feed System",null,null,0.2,null,0.06,0.74,null,0]
["Ozone Generation System:",null,"Not Required",null,null,null,{"$f":"IF(C23=\"lb/day\",B23,B23*2.2)","v":0},null,null,null,null,0.33,null,null,7.0000000000000007E-2,0.03,0.06,0.51,0,"Sulfuric Acid Feed System",null,null,0.04,null,0.02,0.94,null,0]
["Ozone Generation Capacity:",null,"lb/day",null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S11)","v":0},null,null,null,null,0.59,null,null,0.2,0.08,0.06,7.0000000000000007E-2,0,"Sodium Hydroxide Feed System",null,null,0.28000000000000003,null,0.04,0.68,null,0]
["Construction Cost:",{"$f":"IF(C22=V16,0,0.0002*G22^3-1.3451*G22^2+4147.8*G22+212878)*G23","v":0},null,null,null,null,null,null,null,null,0.04,0.38,0.1,0.1,0.23,null,0.15,null,0,"G=300",null,null,0.44,null,0.01,0.55000000000000004,null,0]
["O&M Cost:",{"$f":"IF(C22=I14,0,(-0.0093*G22^2+354.32*G22+33867)*AB11)","v":0},null,null,null,null,{"$f":"IF(C26=I25,B26,B26*35.3147)","v":0},null,"Cu ft",null,0.03,0.47,0.08,0.08,0.21,null,0.13,null,0,"G=600",null,null,0.62,null,0,0.38,null,0]
["Ozone Contact Chamber Volume:",null,"Cu ft",null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S12)","v":0},null,"Cu m",null,0.02,0.68,0.05,0.05,0.16,null,0.04,null,0,"G=900",null,null,0.84,null,0,0.16,null,0]
["Ozone Contact Chamber CC:",{"$f":"IF(C22=V16,0,0.000006*G25^2+5.181*G25+41901)*G26","v":0},null,null,null,null,null,null,null,null,0.06,0.17,0.18,0.18,0.3,null,0.11,null,0,"G = 20",null,null,0.12,null,0.46,0.42,null,0]
[null,null,null,null,null,null,null,null,null,null,0.05,0.25,0.15,0.15,0.3,null,0.1,null,0,"G = 50",null,null,0.55000000000000004,null,0.14000000000000001,0.31,null,0]
["On-Site Hypochlorite Generation System:",null,"Not Required",null,null,null,{"$f":"B30*'Project Details'!N$6*8.34","v":0},null,null,null,0.04,0.35,0.11,0.12,0.3,null,0.08,null,0,"G = 80",null,null,0.65,null,0.15,0.2,null,0]
["Hypochlorite Dose:",null,"mg/L",null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S13)","v":0},null,null,null,0.05,0.49,0.09,0.08,0.28000000000000003,null,0.01,null,0,"Upflow Clarifier",null,null,0.25,null,0.08,0.67,null,0]
["Construction Cost:",{"$f":"IF(C29=V16,0,0.000008*G29^3-0.1413*G29^2+884.72*G29+87471)*G30","v":0},null,null,null,null,null,null,null,null,0.03,0.31,0.09,0.33,0.16,0.06,0.02,null,0,"Circular Clariier",null,null,0.05,null,0.72,0.23,null,0,0.03,null,0.73,0.24,null,{"$f":"AC31*$W$3+AD31*X$3+AE31*Y$3+AF31*Z$3+AG31*AA$3","v":0}]
["O&M Cost:",{"$f":"IF(C29=V16,0,(-0.0034*G29^2+147.44*G29+25004)*AB13)","v":0},null,null,null,null,null,null,null,null,0.04,0.26,0.11,0.22,0.24,0.12,0.01,null,0,"Rectangular Clarifier",null,null,0.03,null,0.09,0.88,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0.51,null,0.25,0.24,null,null,null,0,"Tube Settling Modules"]
["Powdered Activated Carbon Feed System:",null,"Not Required",null,null,null,{"$f":"B35*'Project Details'!N$6*8.34/24","v":0},null,"lb/hr",null,0.08,null,0.22,0.26,0.44,null,null,null,0,"Contact Basin"]
["PAC Dose:",null,"mg/L",null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S14)","v":0},null,"kg/hr",null,0.01,0.18,7.0000000000000007E-2,0.03,0.24,0.26,0.03,0.18,0,"Gravity Filtration Structure",null,null,0.31,null,7.0000000000000007E-2,0.62,null,{"$f":"W35*$W$3+X35*X$3+Y35*Y$3+Z35*Z$3+AA35*AA$3","v":0}]
["PAC Price:",null,"$/lb",null,null,null,{"$f":"G34*'Project Details'!B7*24*365","v":0},null,null,null,null,1,null,null,null,null,null,null,0,"Filtration Media"]
["Construction Cost:",{"$f":"IF(C34=V16,0,-0.0577*G34^2+778.86*G34+175653)*G35","v":0},null,null,null,null,null,null,"Fluidized Bed Process",null,null,0.4,null,null,0.6,null,null,null,0,"Anthracite"]
["O&M Cost:",{"$f":"IF(C34=V16,0,(-0.0204*G34^2+262.07*G34+54114)*AB14)","v":0},null,null,null,null,{"$f":"IF(C41=\"lb/day\",B41,B41*2.2)","v":0},null,"Atomized Suspension Process",null,null,null,null,null,0.38,0.56000000000000005,0.06,null,0,"modification of sand filter"]
["Chemical Cost:",{"$f":"B36*G36","v":0},null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,IF(C40=I37,S15,S16))","v":0},null,"Not Required",null,null,0.49,null,null,0.08,0.3,0.13,null,0,"Backwash Pumping Facilities",null,null,0.51,null,0.17,0.32,null,{"$f":"W39*$W$3+X39*X$3+Y39*Y$3+Z39*Z$3+AA39*AA$3","v":0}]
["Powdered Carbon Regeneration:",null,"Not Required",null,null,null,null,null,null,null,null,0.62,null,null,0.13,0.13,0.12,null,0,"Hydraulic Surface Backwash",null,null,0.44,null,0.03,0.53,null,0]
["Regeneration Capacity:",null,"lb/day",null,null,null,null,null,null,null,null,0.31,null,null,0.11,0.53,0.05,null,0,"Air-Water Backwash",null,null,0.51,null,0.32,0.17,null,0]
["Construction Cost:",{"$f":"IF(C$40=I$39,0,IF(C40=I$37,0.0000007*G38^3-0.0361*G38^2+832.64*G38+2000000,511.53*G38+342140))*G39","v":0},null,null,null,null,null,null,null,null,0.01,null,0.33,0.13,0.47,0.05,0.01,null,0,"Wash Water Surge Basin"]
["O&M Cost:",{"$f":"IF(C$40=I$39,0,IF(C40=I$37,(0.0000002*G38^3-0.031*G38^2+300.16*G38+599423)*AB15,(9.0722*G38+12328)*AB16))","v":0},null,null,null,null,null,null,"Diffused Aeration Basin",null,0.02,null,0.01,0.35,0.62,null,null,null,0,"Wash Water Storage Tank"]
[null,null,null,null,null,null,{"$f":"IF(C47=I25,B47/1000,(B47*35.3147)/1000)","v":0},null,"Aeration Towers",null,null,0.48,0.09,0.02,0.14000000000000001,0.01,0.02,0.24,0,"Continuous Automatic Backwash Filter",null,null,0.63,null,0.04,0.33,null,{"$f":"W44*$W$3+X44*X$3+Y44*Y$3+Z44*Z$3+AA44*AA$3","v":0}]
["Aeration",null,null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,IF(C46=I43,S17,S18))","v":0},null,"Not Required",null,null,0.47,null,null,0.09,0.28999999999999998,7.0000000000000007E-2,0.08,0,"Pressure Filtration Plants",null,null,0.41,null,0.1,0.49,null,0]
["Aerator Type:",null,"Not Required",null,null,null,null,null,null,null,null,0.37,null,null,0.08,0.13,0.2,0.22,0,"Potassium Permanganate Feed",null,null,0.04,null,0.01,0.95,null,0]
[{"$f":"IF(C46=I43,\"Aeration Basin Volume:\",IF(C46=I44,\"Aeration Tower Volume:\",\"\"))","v":""},null,"Cu ft",null,null,null,null,null,null,null,null,0.55000000000000004,null,null,0.18,0.12,7.0000000000000007E-2,0.08,0,"Anhydrous Ammonia",null,null,0.06,null,0.26,0.68,null,0]
["Construction Cost:",{"$f":"IF(C$46=I$45,0,IF(C$46=I$43,0.2287*G44^3-133.51*G44^2+64933*G44+287711,-19.857*G44^2+25002*G44+175725))*G45","v":0},null,null,null,null,null,null,null,null,null,0.76,null,null,7.0000000000000007E-2,0.06,0.11,null,0,"Aqua Ammonia",null,null,0.01,null,0.1,0.89,null,0]
["O&M Cost:",{"$f":"IF(C$46=I$45,0,IF(C$46=I$43,(19557*G44+76673)*AB17,(1525.2*G44+4343)*AB18))","v":0},null,null,null,null,null,null,"Liquid",null,null,0.81,null,null,0.06,null,0.06,7.0000000000000007E-2,0,"Reverse Osmosis",null,null,0.56999999999999995,null,0.42,0.01,null,0]
[null,null,null,null,null,null,{"$f":"B53*'Project Details'!N$6*8.34/24","v":0},null,"Dry",null,null,0.52,0.01,null,0.12,0.17,0.1,0.08,0,"Pressure Ion Exchange",null,null,0.14000000000000001,null,0.5,0.36,null,0]
["Coagulation and Flocculation",null,null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,IF(C52=I49,S19,S20))","v":0},null,"Not Required",null,0.01,0.67,0.03,0.02,0.1,0.08,0.02,7.0000000000000007E-2,0,"Gravity Ion Exchange",null,null,0.09,null,0.55000000000000004,0.36,null,0]
["Alum Feed System:",null,"Not Required",null,null,null,{"$f":"G50*'Project Details'!B$7*24*365","v":0},null,null,null,null,0.72,0.01,0.01,0.08,0.09,0.04,0.05,0,"Pressure IE N Removal",null,null,0.04,null,0.69,0.27,null,0]
["Alum Dose:",null,"mg/L",null,null,null,null,null,null,null,null,0.51,null,null,0.17,0.2,0.02,0.1,0,"Fluoride Removal",null,null,0.12,null,0.36,0.52,null,0]
["Alum Price:",null,"$/lb",null,null,null,null,null,"Required",null,null,0.63,null,null,0.02,0.05,0.05,0.25,0,"Lime<1000"]
["Construction Cost:",{"$f":"IF(C$52=I$51,0,IF(C$52=I$49,-0.0249*G50^2+280.21*G50+54288,240.78*G50+71071))*G51","v":0},null,null,null,null,{"$f":"B60*'Project Details'!N$6*8.34/24","v":0},null,"Not Required",null,null,0.67,null,null,0.03,0.06,0.06,0.18,0,"Lime>1000",null,null,0.04,null,0.03,0.93,null,0]
["O&M Cost:",{"$f":"IF(C$52=I$51,0,IF(C$52=I$49,(2118*G50^0.293)*AB19,(0.0004*G50^2+44.575*G50+14170)*AB20))","v":0},null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S20)","v":0},null,null,null,0.08,null,0.22,0.24,0.43,0.03,null,null,0,"Recarbonation basin"]
["Chemical Cost:",{"$f":"B54*G52","v":0},null,null,null,null,{"$f":"G55*'Project Details'!B$7*24*365","v":0},null,null,null,null,0.55000000000000004,null,null,0.25,0.13,null,7.0000000000000007E-2,0,"Liquid CO2",null,null,0.32,null,0.45,0.23,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0.55000000000000004,null,null,0.24,0.17,null,0.04,0,"Submerged burner",null,null,0.12,0.82,0.03,0.03,null,0]
["Ferrous Sulfate Feed System:",null,"Not Required",null,null,null,null,null,null,null,null,0.46,null,null,0.31,0.15,0.08,null,0,"Stack Gas",null,null,0.55000000000000004,null,0.18,0.27,null,0]
["Ferrous Sulfate Dose:",null,"mg/L",null,null,null,{"$f":"B67*'Project Details'!N$6*8.34","v":0},null,null,null,null,0.6,null,null,0.31,0.01,null,0.08,0,"Multiple Hearth Recalcination",null,null,0.06,0.63,0.03,0.28000000000000003,null,0]
["Ferrous Sulfate Price:",null,"$/lb",null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S20)","v":0},null,null,null,0.01,0.18,0.06,0.03,0.2,0.33,0.03,0.16,0,"Concrete Carbon Contactor, 7.5, 5",null,null,0.31,null,7.0000000000000007E-2,0.62,null,0]
["Construction Cost:",{"$f":"IF(C$59=I$55,0,-0.002*G55^2+222.15*G55+63563)*G56","v":0},null,null,null,null,{"$f":"G60*'Project Details'!B$7*365","v":0},null,null,null,0.01,0.17,7.0000000000000007E-2,0.03,0.24,0.3,0.03,0.15,0,"Concrete Carbon Contactor, 12.5, 8.3"]
["O&M Cost:",{"$f":"IF(C$59=I$55,0,0.0004*G55^2+44.575*G55+14147)*AB20","v":0},null,null,null,null,null,null,null,null,null,0.43,0.01,null,0.1,0.22,0.03,0.21,0,"Steel Carbon Contactor, 20 d",null,null,0.47,null,7.0000000000000007E-2,0.46,null,0]
["Chemical Cost:",{"$f":"B61*G57","v":0},null,null,null,null,null,null,null,null,null,0.44,0.01,null,0.1,0.22,0.03,0.2,0,"Steel Carbon Contactor, 30 d",null,null,0.43,null,0.05,0.52,null,0]
[null,null,null,null,null,null,{"$f":"B74*'Project Details'!N$6*8.34","v":0},null,null,null,null,0.5,0.01,null,0.09,0.2,0.06,0.14000000000000001,0,"Pressure Carbon Contactor - 7.5 min"]
["Ferric Sulfate Feed System:",null,"Not Required",null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S21)","v":0},null,null,null,null,0.49,0.01,null,0.08,0.19,0.06,0.17,0,"Pressure Carbon Contactor - 15 min"]
["Ferric Sulfate Dose:",null,"mg/L",null,null,null,{"$f":"G65*'Project Details'!B$7*365","v":0},null,null,null,null,0.51,null,null,0.06,0.19,0.04,0.2,0,"Pressure Carbon Contactor - 30 min",null,null,0.28000000000000003,null,0.12,0.6,null,{"$f":"W67*$W$3+X67*X$3+Y67*Y$3+Z67*Z$3+AA67*AA$3","v":0}]
["Ferric Sulfate Price:",null,"$/lb",null,null,null,null,null,null,null,null,0.1,null,null,0.26,0.63,0.01,null,0,"Conversion of Sand Filter to Carbon Contactor (Carbon Bed Depth = 30”)"]
["Construction Cost:",{"$f":"IF(C$66=I$55,0,-0.001*G60^2+177.92*G60+63605)*G61","v":0},null,null,null,null,null,null,null,null,null,0.15,0.03,0.3,0.47,0.05,null,null,0,"Off-Site Regional Carbon Regeneration – Handling and Transportation:"]
["O&M Cost:",{"$f":"IF(C$66=I$55,0,0.0003*G60^2+33.425*G60+14152)*AB20","v":0},null,null,null,null,{"$f":"IF(C81=I70,B81,B81*0.264172052)","v":0},null,"gal/day",null,null,0.5,null,null,0.33,0.02,0.01,0.14000000000000001,0,"Multiple Hearth Granular Carbon Regeneration:",null,null,7.0000000000000007E-2,0.61,0.02,0.3,null,{"$f":"W70*$W$3+X70*X$3+Y70*Y$3+Z70*Z$3+AA70*AA$3","v":0}]
["Chemical Cost:",{"$f":"B68*G62","v":0},null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S22)","v":0},null,"liter/day",null,null,0.64,null,null,0.21,0.01,0.05,0.09,0,"Infrared Carbon Regeneration Furnace:",null,null,0.66,null,0.05,0.28999999999999998,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0.66,null,null,0.25,null,0.01,0.08,0,"Granular Carbon Regeneration – Fluid Bed Process:",null,null,0.09,0.42,0.13,0.36,null,0]
["Polymer Feed System:",null,"Not Required",null,null,null,null,null,null,null,0.03,null,0.43,0.19,0.34,null,0.01,null,0,"Underground clearwell"]
["Polymer Dose:",null,"mg/L",null,null,null,null,null,null,null,null,0.76,0.1,0.05,0.02,0.06,0.01,null,0,"Ground-level Clearwell",null,null,0.75,null,0.05,0.2,null,0,"In 30"]
["Polymer Price:",null,"$/lb",null,null,null,{"$f":"B88*'Project Details'!N$6*8.34","v":0},null,null,null,null,0.17,0.02,0.02,0.39,0.28000000000000003,0.06,0.06,0,"In-Plant Pumping",null,null,0.86,null,0.03,0.11,null,0,75]
["Construction Cost:",{"$f":"IF(C$73=I$55,0,-0.0055*G65^3+1.8481*G65^2-19.72*G65+54155)*G66","v":0},null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S23)","v":0},null,null,null,null,0.44,null,null,0.13,0.28000000000000003,0.15,null,0,"Finished Water Pumping, 30",null,null,0.75,null,0.05,0.2,null,0]
["O&M Cost:",{"$f":"IF(C$73=I$55,0,0.0001*G65^3-0.0168*G65^2+10.645*G65+12194)*AB21","v":0},null,null,null,null,{"$f":"G75*365*'Project Details'!B7","v":0},null,null,null,null,0.6,null,null,0.1,0.17,0.13,null,{"$f":"K77*K$3+L77*L$3+M77*M$3+N77*N$3+O77*O$3+P77*P$3+Q77*Q$3+R77*R$3","v":0},"Finished Water Pumping, 100",null,null,0.9,null,0.02,0.08,null,0]
["Chemical Cost:",{"$f":"B75*G67","v":0},null,null,null,null,null,null,null,null,null,0.61,null,null,0.18,0.06,0.09,0.06,0,"Pressure Diatomite Filter",null,null,0.52,null,0.04,0.44,null,0]
[null,null,null,null,null,null,null,null,"G = 300",null,null,0.32,null,null,0.26,0.25,0.03,0.14000000000000001,0,"Vacuum Diatomite Filter",null,null,0.48,null,0.04,0.48,null,0]
["Sulfuric Acid Feed System:",null,"Not Required",null,null,null,{"$f":"IF(C95=I25,B95,(B95*35.3147))","v":0},null,"G = 600",null,0.02,0.15,0.06,0.04,0.31,0.3,0.05,7.0000000000000007E-2,0,"Sludge Pumping-UT",null,null,0.26,null,0.47,0.27,null,0]
["Feed Capacity",null,"gal/day",null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,IF(C94=I79,S24,IF(C94=I80,S25,S26)))","v":0},null,"G = 900",null,null,0.68,null,null,0.16,0.04,0.03,0.09,0,"Sludge Pumping-T",null,null,0.43,null,0.26,0.31,null,0]
["Sulfuric Acid Price",null,"$/gal",null,null,null,null,null,"Not Required",null,0.04,0.39,0.13,0.12,0.31,null,0.01,null,0,"Gravity Sludge Thickener",null,null,0.09,null,0.18,0.73,null,0]
["Construction Cost:",{"$f":"IF(C$80=I$55,0,-0.0029*G70^2+48.434*G70+22648)*G71","v":0},null,null,null,null,null,null,null,null,null,0.5,null,null,0.26,0.02,0.01,0.21,0,"Vacuum Filter",null,null,0.26,null,0.21,0.53,null,0]
["O&M Cost:",{"$f":"IF(C$80=I$55,0,4.6736*G70+5513)*AB22","v":0},null,null,null,null,null,null,"G = 20",null,0.54,null,0.04,null,0.26,0.16,null,null,0,"Sludge Lagoon",null,null,null,null,0.01,0.92,7.0000000000000007E-2,0]
["Chemical Cost:",{"$f":"B82*G70*365*'Project Details'!B7","v":0},null,null,null,null,{"$f":"IF(C101=\"Cu ft\",B101,(B101*35.3147))","v":0},null,"G = 50",null,null,0.61,null,null,0.21,0.01,0.01,0.16,0,"Filter Press",null,null,0.1,null,0.02,0.88,null,0]
[null,null,null,null,null,null,{"$f":"IF(A100=L100,IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,IF(C100=I84,S27,IF(C100=I85,S28,S29))),IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,IF(C100=I84,S91,IF(C100=I85,S92,S93))))","v":0},null,"G = 80",null,null,0.5,null,null,0.19,7.0000000000000007E-2,0.01,0.23,0,"Decanter Centrifuge",null,null,0.27,null,0.12,0.61,null,0]
["Sodium Hydroxide Feed System:",null,"Not Required",null,null,null,null,null,"Not Required",null,null,0.52,null,null,0.2,0.05,0.01,0.22,0,"Basket Centrifuge",null,null,0.57999999999999996,null,0.08,0.34,null,0]
["Sodium Hydroxide Dose:",null,"mg/L",null,null,null,null,null,null,null,null,0.65,null,null,0.24,0.03,null,0.08,0,"Belt Filter Press",null,null,0.3,null,0.08,0.62,null,0]
["Sodium Hydroxide Price:",null,"$/lb",null,null,null,null,null,null,null,0.05,null,0.1,0.02,0.57999999999999996,0.25,null,null,0,"Sand Drying Bed",null,null,0,null,0.04,0.89,7.0000000000000007E-2,0]
["Construction Cost:",{"$f":"IF(C$87=I$55,0,20.35*G75+36294)*G76","v":0},null,null,null,null,null,null,"Upflow Solids Contact Clarifiers",null,null,null,null,null,null,null,null,1,0,"Building",null,null,0.1,null,0.05,0.85,null,0]
["O&M Cost:",{"$f":"IF(C$87=I$55,0,0.0002*G75^2-0.8361*G75+6649)*AB23","v":0},null,null,null,null,{"$f":"B110","v":0},null,"Circular Clarifiers",null,0.03,0.22,0.11,0.13,0.35,null,0.16,null,0,"G = 20"]
["Chemical Cost:",{"$f":"B89*G77","v":0},null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,IF(C107=I90,S30,IF(C107=I91,S31,S32)))","v":0},null,"Rectangular Clarifiers",null,0.03,0.22,0.11,0.13,0.35,null,0.16,null,0,"G = 50"]
[null,null,null,null,null,null,{"$f":"IF(D112=\"\",\"\",IF(D112=T94,(7*10^-10*G91^3-0.00005*G91^2+1.5908*G91+6872)*AB31,(7*10^-10*G91^3-0.00005*G91^2+1.5792*G91+6734)*AH31))","v":""},null,"Not Required",null,0.03,0.24,0.11,0.12,0.35,null,0.15,null,0,"G = 80"]
["Rapid Mix:",null,"Not Required",null,null,null,null,null,"sq. ft",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C107=I91,\"Lime\",\"\")","v":""}]
["Total Basin Volume:",null,"Cu ft",null,null,null,null,null,"sq. m",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C107=I91,\"Ferric and Alum\",\"\")","v":""}]
["Construction Cost:",{"$f":"IF(C$94=I$82,0,IF(C$94=I$79,0.0002*G80^2+22.776*G80+28584,IF(C$94=I$80,0.0002*G80^2+29.209*G80+30388,0.0002*G80^2+55.443*G80+29756)))*G81","v":0},null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S33)","v":0},null,"Required"]
["O&M Cost:",{"$f":"IF(C$94=I$82,0,IF(C$94=I$79,(-0.00000003*G80^3+0.0008*G80^2+2.8375*G80+22588)*AB24,IF(C$94=I$80,(-0.00000003*G80^3+0.0008*G80^2+7.8308*G80+22588)*AB25,(36.096*G80+18928)*AB26)))","v":0},null,null,null,null,null,null,"Not Required"]
[]
["Flocculation",null,null,null,null,null,null,null,{"$f":"IF(C107=I90,B108/14544,IF(C107=I92,B108/4800,B108/31416))","v":0}]
["Horizontal Paddle System",null,"Not Required",null,null,null,{"$f":"IF(C119=\"Cu ft\",B119,(B119*35.3147))","v":0},null,null,null,null,"Horizontal Paddle System"]
["Total Basin Volume:",null,"Cu ft",null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S34)","v":0},null,null,null,null,"Vertical Turbine Flocculators"]
["Construction Cost:",{"$f":"IF(A100=L100,IF(C$100=I$87,0,IF(C$100=I$84,5*10^(-12)*G85^3-0.0000006*G85^2+6.8748*G85+162853,IF(C$100=I$85,5*10^(-12)*G85^3-0.0000006*G85^2+7.7415*G85+158139,-0.000004*G85^2+9.3239*G85+160468)))*G86,IF(C$100=I$87,0,IF(C$100=I$84,-0.0005*G85^2+26.863*G85+34588,IF(C$100=I$85,-0.0005*G85^2+28.042*G85+32609,-0.0005*G85^2+27.306*G85+33732)))*G86)","v":0}]
["O&M Cost:",{"$f":"IF(C$100=I$87,0,IF(C$100=I$84,(3*10^-13*G85^3-0.0000005*G85^2+0.2757*G85+6594)*AB27,IF(C$100=I$85,(3*10^-13*G85^3-0.0000004*G85^2+0.318*G85+6040)*AB28,(-0.0000003*G85^2+0.5692*G85+6748)*AB29)))","v":0},null,null,null,null,null,null,"gpd/ft2",{"$f":"IF(C106=I103,B106,B106*25)","v":0}]
[null,null,null,null,null,null,null,null,"m3/d/m2"]
["Sedimentation",null,null,null,null,null,{"$f":"'Project Details'!N6","v":0}]
["Surface Loading Rate:",null,"gpd/ft2",null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S35)","v":0}]
["Select Type of Clarifier:",null,"Not Required"]
["Total Surface Area of Clarifier:",{"$f":"IF(B106=0,0,ROUND('Project Details'!N6*1000000/'Unit Operation and Processes'!J103,0))","v":0},"sq. ft"]
["No. of Clarifiers:",{"$f":"IF(B108=0,0,IF(I99<1,1,IF(I99<2,2,IF(I99<4,4,IF(I99<6,6,IF(I99<8,8,IF(I99<10,10,IF(I99<12,12,IF(I99<14,14,IF(I99<16,16,\"choose another type of clarifier\"))))))))))","v":0},null,null,null,null,null,null,"Rapid Sand"]
[{"$f":"IF(C107=I90,\"Net Effective Settling Area:\",\"Surface Area:\")","v":"Surface Area:"},{"$f":"IF(B109=0,0,ROUND((((ROUND((B108+50)/100,0)*100)/B109)+50)/100,0)*100)","v":0},"sq. ft",null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S36)","v":0},null,"Dual Media"]
["Construction Cost:",{"$f":"B109*(IF(C$107=I$93,0,IF(C$107=I$90,3*10^(-7)*G91^3-0.0095*G91^2+167.45*G91+181434,IF(C$107=I$91,-0.0005*G91^2+86.89*G91+182801,-0.0031*G91^2+155.61*G91+78329)))*G92)","v":0},null,null,null,null,null,null,"Mixed Media"]
["O&M Cost:",{"$f":"B109*(IF(C$107=I$93,0,IF(C$107=I$90,(-0.00007*G91^2+3.7157*G91+24019)*AB30,IF(C107=I92,(-0.00003*G91^2+4.2485*G91+7748)*AB32,G93))))","v":0},{"$f":"IF(C107=I91,\"Select Type of Sludge:\",\"\")","v":""},"",null,null,null,null,"Not Required"]
[]
["Tube Settling Module:",null,"Not Required",null,null,null,{"$f":"IF(C136=I94,B136,(B136*10.7639104))","v":0}]
["Construction Cost:",{"$f":"IF(C114=I97,0,-5.6888*'Project Details'!N6^2+17121*'Project Details'!N6+21973)*G96","v":0},null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S37)","v":0}]
[]
[]
["Contact Basin:",null,"Not Required",null,null,null,{"$f":"IF(C140=I94,B140,(B140*10.7639104))","v":0},null,"gpm/ft2"]
["Basin Volume:",null,"Cu ft",null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S38)","v":0},null,"m3/h/m2"]
["No. of Basins:"]
["Construction Cost:",{"$f":"B120*(IF(C118=I97,0,611.54*G100^0.5804)*G101)","v":0},null,null,null,null,null,null,null,{"$f":"IF(C126=I118,B126,B126*0.41)*60*24","v":7200}]
[null,null,null,null,null,null,{"$f":"IF(C144=I$122,B144,(B144*15.8503230745))","v":0},null,"gpm"]
[null,null,null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S39)","v":0},null,"lps"]
["Filtration"]
["Gravity Filtration Structures:",null,"Not Required"]
["Surface Loading Rate:",5,"gpm/ft2",null,null,null,null,null,"Hydraulic Surface Wash Systems"]
["Total Surface Area of Filter:",{"$f":"ROUND(IF(B126=0,0,'Project Details'!N6*1000000/'Unit Operation and Processes'!J121+5)/10,0)*10","v":10},"sq. ft",null,null,null,{"$f":"IF(C149=I$94,B149,(B149*10.7639104))","v":0},null,"Air-Water Backwash Facilities"]
["Construction Cost:",{"$f":"IF(C$125=I$97,0,0.000001*B127^3-0.042*B127^2+990.75*B127+453613)*G106","v":0},null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,IF(C148=I126,S40,S41))","v":0},null,"Not Required"]
["O&M Cost:",{"$f":"IF(C$125=I$97,0,0.00000007*B127^3-0.0025*B127^2+58.876*B127+47252)*AB35","v":0}]
[]
["Select Filtration Media:",null,"Not Required"]
["Construction Cost:",{"$f":"IF(C131=I112,0,IF(C131=I109,7558.4*'Project Details'!N6+13488,IF('Unit Operation and Processes'!C131='Unit Operation and Processes'!I110,5779.9*'Project Details'!N6+20510,9434.4*'Project Details'!N6+25491)))*G110","v":0},null,null,null,null,{"$f":"IF(C155=I$132,B155,IF(C155=I$133,B155*7.48051948,B155*264.172052))","v":0},null,"gal"]
[null,null,null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S42)","v":0},null,"Cu ft"]
[null,null,null,null,null,null,null,null,"Cu m"]
["Capping Sand Filters with Anthracite:",null,"Not Required"]
["Filter Area:",null,"sq. ft"]
["Construction Cost:",{"$f":"IF(C135=I97,0,9.3924*G114+1779)*G115","v":0},null,null,null,null,{"$f":"IF(C161=I132,B161/1000,IF(C161=I133,(B161*7.48051948)/1000,(B161*264.172052)/1000))","v":0}]
[null,null,null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S43)","v":0}]
["Modification of Rapid Sand Filters to High Rate Filters:",null,"Not Required"]
["Filter Area:",null,"sq. ft"]
["Construction Cost:",{"$f":"IF(C139=I97,0,0.00000004*G118^3-0.0019*G118^2+81.092*G118+71429)*G119","v":0},null,null,null,null,{"$f":"'Project Details'!N6","v":0}]
[null,null,null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S44)","v":0}]
["Backwash Pumping Facilities:",null,"Not Required"]
["Pumping Capacity:",null,"gpm"]
["Construction Cost:",{"$f":"IF(C$143=I$97,0,11.94*G122^3-624.73*G122^2+23021*G122+67631)*G123","v":0},null,null,null,null,{"$f":"'Project Details'!N6","v":0}]
["O&M Cost:",{"$f":"IF(C$143=I$97,0,3*10^-9*G122^3-0.0001*G122^2+4.8751*G122+10915)*AB39","v":0},null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S45)","v":0}]
[]
["Select Type of Backwash System:",null,"Not Required"]
["Filter Area:",null,"sq. ft"]
["No. of Filters:"]
["Construction Cost:",{"$f":"B150*(IF(C$148=I$128,0,IF(C$148=I$126,0.0006*G127^2+49.09*G127+78749,-0.0003*G127^2+69.004*G127+250729))*G128)","v":0},null,null,null,null,{"$f":"B176*'Project Details'!N$6*8.34","v":0}]
["O&M Cost:",{"$f":"B150*(IF(C$148=I$128,0,IF(C$148=I$126,(4*10^-9*G127^3-0.0002*G127^2+3.8176*G127+4446)*AB40,(3*10^-9*G127^3-0.0001*G127^2+4.905*G127+10915)*AB41)))","v":0},null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S46)","v":0}]
[null,null,null,null,null,null,{"$f":"G151*365*'Project Details'!B$7","v":0}]
["Wash Water Surge Basins:",null,"Not Required"]
["Basin Capacity:",null,"gal"]
["No. of Basins:",null,null,null,null,null,null,null,"Anhydrous"]
["Construction Cost:",{"$f":"B156*(IF(C$154=I$97,0,802.91*G132^0.586)*G133)","v":0},null,null,null,null,{"$f":"B184*'Project Details'!N$6*8.34","v":0},null,"Aqua"]
[null,null,null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,IF(C183=I156,S47,S48))","v":0},null,"Not Required"]
[null,null,null,null,null,null,{"$f":"G157*365*'Project Details'!B$7","v":0}]
["Wash Water Storage Tanks:",null,"Not Required",null,null,null,{"$f":"'Project Details'!N$6","v":0}]
["Basin Capacity:",null,"gal",null,null,null,{"$f":"'Project Details'!N$6*10","v":0}]
["No. of Basins:",null,null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S49)","v":0}]
["Construction Cost:",{"$f":"B162*(IF(C160=I$97,0,0.0011*G137^3-1.471*G137^2+1265*G137+2867)*G138)","v":0}]
[]
[]
["Continuous Automatic Backwash Filter:",null,"Not Required",null,null,null,{"$f":"'Project Details'!N6","v":0},null,"Pressure"]
["Construction Cost:",{"$f":"IF(C$166=I$97,0,-22.558*'Project Details'!N6^2+217239*'Project Details'!N6+263133)*G142","v":0},null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,IF(C195=I166,S50,S51))","v":0},null,"Gravity"]
["O&M Cost:",{"$f":"IF(C$166=I$97,0,-0.3285*G141^3+95.238*G141^2+7077.8*G141+39086)*AB44","v":0},null,null,null,null,null,null,"Not Required"]
[]
["Pressure Filtration Plant:",null,"Not Required",null,null,null,{"$f":"'Project Details'!N$6","v":0}]
["Construction Cost:",{"$f":"IF(C$170=I$97,0,157157*'Project Details'!N6+269123)*G146","v":0},null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S52)","v":0}]
["O&M Cost:",{"$f":"IF(C$170=I$97,0,0.2532*G145^3-81.527*G145^2+16236*G145+66980)*AB45","v":0}]
[]
["Taste and Odor Control"]
["Potassium Permanganate Feed Systems:",null,"Not Required",null,null,null,{"$f":"'Project Details'!N$6","v":0}]
["Potassium Permanganate Dose:",null,"mg/L",null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S53)","v":0}]
["Potassium Permanganate Price:",null,"$/lb"]
["Construction Cost:",{"$f":"IF(C$175=I$97,0,-0.0554*G151^2+57.522*G151+23138)*G152","v":0}]
["O&M Cost:",{"$f":"IF(C$175=I$97,0,2840.2*LN(G151)+8594)*AB46","v":0}]
["Chemical Cost:",{"$f":"B177*G153","v":0}]
[null,null,null,null,null,null,{"$f":"B210*'Project Details'!N$6*8.34/24","v":0}]
["Disinfection",null,null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,IF(G181<1000,S54,S55))","v":0}]
["Select Type of Ammonia Feed Facility:",null,"Not Required",null,null,null,{"$f":"G181*365*'Project Details'!B$7*24","v":0}]
["Ammonia Dose:",null,"mg/L"]
["Ammonia Price:",null,"$/lb"]
["Construction Cost:",{"$f":"IF(C$183=I$158,0,IF(C$183=I$156,0.000009*G157^3-0.0759*G157^2+204.51*G157+37137,0.000001*G157^3-0.0091*G157^2+39.264*G157+25081))*G158","v":0},null,null,null,null,{"$f":"IF(C217=\"Cu ft\",B217,(B217*35.3147))","v":0}]
["O&M Cost:",{"$f":"IF(C$183=I$158,0,IF(C$183=I$156,(0.0000007*G157^3-0.0057*G157^2+20.58*G157+26763)*AB47,(0.00000002*G157^3-0.0002*G157^2+0.7276*G157+7107)*AB48))","v":0},null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S56)","v":0}]
["Chemical Cost:",{"$f":"B185*G159","v":0}]
[]
["Reverse Osmosis:",null,"Not Required",null,null,null,null,null,"Liquid"]
["Construction Cost:",{"$f":"IF(C$190=I$97,0,0.0106*(G161^3)-39.118*G161^2+142629*G161+660469)*G162","v":0},null,null,null,null,{"$f":"IF(C223=\"lb/day\",B223,B223*2.2)","v":0},null,"Submerged Burners"]
["O&M Cost:",{"$f":"IF(C$190=I$97,0,391189*G160+207533)*AB49","v":0},null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,IF(C222=I191,S57,IF(C222=I192,S58,S59)))","v":0},null,"Stack Gas"]
[null,null,null,null,null,null,null,null,"Not Required"]
["Ion Exchange"]
["Select Ion Exhange Softening Process:",null,"Not Required"]
["Construction Cost:",{"$f":"IF(C$195=I$168,0,IF(C$195=I$166,-170.44*G166^2+283732*G166+174939,-123.73*G166^2+165412*G166+447664))*G167","v":0},null,null,null,null,{"$f":"IF(C228=I$94,B228,(B228*10.7639104))","v":0}]
["O&M Cost:",{"$f":"IF(C$195=I$168,0,IF(C$195=I$166,(-12.039*G166^2+18861*G166+102201)*AB50,(15935*G166+108481)*AB51))","v":0},null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S60)","v":0}]
[]
["Pressure Ion Exchange Nitrate Removal:",null,"Not Required"]
["Construction Cost:",{"$f":"IF(C$199=I$97,0,272.04*G170^2+439556*G170+174939)*G171","v":0},null,null,null,null,null,null,"7.5 min Empty Bed Contact Time and 5 ft Bed Depth"]
["O&M Cost:",{"$f":"IF(C$199=I$97,0,-226.04*G170^3+3754.5*G170^2+49769*G170+109914)*AB52","v":0},null,null,null,null,{"$f":"IF(C233=I$94,B233,(B233*10.7639104))","v":0},null,"12.5 min Empty Bed Contact Time and 8.3 ft Bed Depth"]
[null,null,null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,IF(C232=I200,S61,S62))","v":0},null,"Not Required"]
["Fluoride Removal"]
["Activated Alumina:",null,"Not Required"]
["Construction Cost:",{"$f":"IF(C$204=I$97,0,58.438*G175^2+185206*G175+103524)*G176","v":0},null,null,null,null,null,null,"20 ft Diameter, 20 ft deep Tanks"]
["O&M Cost:",{"$f":"IF(C$204=I$97,0,6.102*G175^2+11322*G175+106281)*AB53","v":0},null,null,null,null,{"$f":"B239","v":0},null,"30 ft Diameter, 20 ft deep Tanks"]
[null,null,null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,IF(C238=I205,S63,S64))","v":0},null,"Not Required"]
["Stability"]
["Lime Feed System:",null,"Not Required"]
["Lime Dose:",null,"mg/L",null,null,null,null,null,"7.5 min Empty Bed Contact Time and 5 ft Bed Depth"]
["Lime Price:",null,"$/lb",null,null,null,{"$f":"IF(C244=I$94,B244,(B244*10.7639104))","v":0},null,"15 min Empty Bed Contact Time and 10 ft Bed Depth"]
["Construction Cost:",{"$f":"IF(C$209=I$97,0,IF(G181<1000,53829*LN(G181)-59146,20.065*G181+193268))*G182","v":0},null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,IF(C243=I210,S65,IF(C243=I211,S66,S67)))","v":0},null,"30 min Empty Bed Contact Time and 20 ft Bed Depth"]
["O&M Cost:",{"$f":"IF(C$209=I$97,0,4616.7*G181^0.4589)*AB55","v":0},null,null,null,null,null,null,"Not Required"]
["Chemical Cost:",{"$f":"B211*G183","v":0}]
[]
["Re-carbonation Basin:",null,"Not Required",null,null,null,{"$f":"IF(C250=\"Cu ft\",B250,(B250*35.3147))","v":0}]
["Single Basin Volume:",null,"Cu ft",null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S68)","v":0}]
["No. of Basins:"]
["Construction Cost:",{"$f":"B218*(IF(C216=I$97,0,0.000000004*G186^3-0.0002*G186^2+10.027*G186+19287)*G187)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"IF(C256=\"Cu ft\",B256,(B256*35.3147))","v":0}]
["Select Re-Carbonation CO2 Source:",null,"Not Required",null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S69)","v":0}]
["Installed Capacity:",null,"lb/day",{"$f":"IF(C222=I192,\"per CO2\",\"\")","v":""}]
["Construction Cost:",{"$f":"IF(C$222=I$193,0,IF(C$222=I$190,0.00000009*G191^3-0.001*G191^2+42.578*G191+130812,IF(C$222=I$191,-7*10^-11*G191^4+0.000002*G191^3-0.0107*G191^2+46.074*G191+128953,1490.2*G191^0.5399)))*G192","v":0}]
["O&M Cost:",{"$f":"IF(C$222=I$193,0,IF(C$222=I$190,(0.00000001*G191^3-0.0004*G191^2+6.19*G191+10265)*AB57,IF(C$222=I$191,(4*10^-8*G191^3-0.0008*G191^2+35.551*G191+9322)*AB58,(5*10^-10*G191^3-0.00004*G191^2+3.7312*G191+4608)*AB59)))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(C261=I$94,B261,(B261*10.7639104))","v":0}]
["Multiple Hearth Recalcination:",null,"Not Required",null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S70)","v":0}]
["Effective Hearth Area:",null,"sq. ft"]
["Construction Cost:",{"$f":"IF(C$227=I$97,0,0.0005*G196^3-2.9835*G196^2+7188.6*G196+1000000)*G197","v":0}]
["O&M Cost:",{"$f":"IF(C$227=I$97,0,0.00008*G196^3-0.2149*G196^2+1333.5*G196+180001)*AB60","v":0}]
[null,null,null,null,null,null,{"$f":"IF(C266=\"lb/day\",B266,B266*2.2)","v":0}]
["Concrete Gravity Carbon Contactor:",null,"Not Required",null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S71)","v":0}]
["Total Contactor Area:",null,"sq. ft"]
["No. of Contactors:"]
["Construction Cost:",{"$f":"B234*(IF(C$232=I$202,0,IF(C232=I200,0.000001*G201^3-0.0452*G201^2+1094.8*G201+502902,0.000001*G201^3-0.0492*G201^2+1171.5*G201+561247))*G202)","v":0}]
["O&M Cost:",{"$f":"B234*(IF(C$232=I$202,0,45.505*G201+53026)*AB61)","v":0},null,null,null,null,{"$f":"IF(C271=\"lb/day\",B271,B271*2.2)","v":0}]
[null,null,null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S72)","v":0}]
["Steel Gravity Carbon Contactor:",null,"Not Required"]
["No of Contactors:"]
["Construction Cost:",{"$f":"IF(C$238=I$207,0,IF(C$238=I$205,-429.69*G206^2+491322*G206+8537,897917*G206+822066))*G207","v":0}]
["O&M Cost:",{"$f":"IF(C$238=I$207,0,IF(C$238=I$205,(-2.0894*G206^2+26464*G206+74238)*AB63,(-140.03*G206^2+62173*G206+9742)*AB64))","v":0},null,null,null,null,null,null,"Below-Ground"]
[null,null,null,null,null,null,{"$f":"IF(C277=I$132,B277/1000,IF(C277=I$133,(B277*7.48051948)/1000,(B277*264.172052)/1000))","v":0},null,"Ground-Level"]
["Pressure Carbon Contactor:",null,"Not Required",null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,IF(C276=I241,S73,S74))","v":0},null,"Other"]
["Total Contactor Area:",null,"sq. ft"]
["No. of Contactor:"]
["Construction Cost:",{"$f":"B245*(IF(C$243=I$213,0,IF(C243=I210,1778.5*G211+136180,IF(C243=I211,2000.7*G211+154612,3185.1*G211+205007)))*G212)","v":0}]
["O&M Cost:",{"$f":"B245*(IF(C$243=I$213,0,-0.0029*G211^2+100.71*G211+97478)*AB67)","v":0},null,null,null,null,{"$f":"'Project Details'!N$6","v":0},null,"TDH = 30 ft"]
[null,null,null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S75)","v":0},null,"TDH = 75 ft"]
["Conversion of Sand Filter to Carbon Contactor (Carbon Bed Depth = 30”):",null,"Not Required"]
["Contactor Volume:",null,"Cu ft",null,null,null,null,null,"TDH = 30 ft"]
["Construction Cost:",{"$f":"IF(C249=I$97,0,-0.00004*G216^2+60.712*G216+69940)*G217","v":0},null,null,null,null,{"$f":"'Project Details'!N$6","v":0},null,"TDH = 100 ft"]
[null,null,null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,IF(C285=I250,S76,S77))","v":0},null,"Not Required"]
[]
["Off-Site Regional Carbon Regeneration – Handling and Transportation:",null,"Not Required"]
["No. of units:",null,null,null,null,null,null,null,"Pressure"]
["Storage Capacity:",null,"Cu ft",null,null,null,{"$f":"'Project Details'!N$6","v":0},null,"Vacuum"]
["Construction Cost:",{"$f":"B255*(IF(C254=I$97,0,0.00004*G221^2+41.116*G221+40083)*G222)","v":0},null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,IF(C290=I255,S78,S79))","v":0},null,"Not Required"]
[]
[null,null,null,null,null,null,null,null,"Unthickened Sludge"]
["Multiple Hearth Granular Carbon Regeneration:",null,"Not Required",null,null,null,{"$f":"IF(C295=I$122,B295,(B295*15.8503230745))","v":0},null,"Thickened Sludge"]
["Furnace Hearth Area:",null,"sq. ft",null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,IF(C294=I259,S80,S81))","v":0},null,"Not Required"]
["Construction Cost:",{"$f":"IF(C$260=I$97,0,406413*G226^0.4067)*G227","v":0}]
["O&M Cost:",{"$f":"IF(C$260=I$97,0,-0.2581*G226^2+2202.3*G226+81957)*AB70","v":0}]
[null,null,null,null,null,null,null,null,"ft"]
["Infrared Carbon Regeneration Furnace:",null,"Not Required",null,null,null,{"$f":"IF(C300=I264,B300,B300*2.28)","v":0},null,"m"]
["Regeneration Capacity:",null,"lb/day",null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S82)","v":0}]
["Construction Cost:",{"$f":"IF(C$265=I$97,0,0.00000001*G231^3-0.0011*G231^2+87.308*G231+601190)*G232","v":0}]
["O&M Cost:",{"$f":"IF(C$265=I$97,0,-0.00002*G231^2+37.192*G231+109145)*AB71","v":0}]
[]
["Granular Carbon Regeneration – Fluid Bed Process:",null,"Not Required",null,null,null,{"$f":"IF(C305=I$94,B305,(B305*10.7639104))","v":0}]
["Regeneration Capacity:",null,"lb/day",null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S83)","v":0}]
["Construction Cost:",{"$f":"IF(C$270=I$97,0,0.00000002*G236^3-0.0018*G236^2+93.965*G236+2000000)*G237","v":0}]
["O&M Cost:",{"$f":"IF(C$270=I$97,0,15.503*G236+128481)*AB72","v":0}]
[]
["Clear Water Storage and Distribution",null,null,null,null,null,{"$f":"IF(C310=I$132,B310/1000000,IF(C310=I$133,(B310*7.48051948)/1000000,(B310*264.172052)/1000000))","v":0}]
["Select Clearwell Storage Type:",null,"Other",null,null,{"$f":"IF(D312=I277,D312/1000,IF(E312=I278,D312*35.3147/1000,D312*0.133680556/1000))","v":0},{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S84)","v":0},null,"gal"]
["Clearwell Capacity:",null,"gal",null,null,null,null,null,"cu ft"]
["Construction Cost:",{"$f":"IF(C276=I243,0,IF(C276=I241,-0.0697*G242^2+1161.9*G242+115431,0.000004*G242^3-0.0636*G242^2+585.7*G242+86980))*G243","v":0},null,{"$f":"IF(C276=I243,\"Enter Construction Cost in Summary Page\",\"\")","v":"Enter Construction Cost in Summary Page"},null,null,null,null,"cu m"]
[]
[null,null,null,null,null,null,{"$f":"IF(C315=\"Cu ft\",B315,(B315*35.3147))","v":0}]
["In-Plant Pumping:",null,"Not Required",null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S85)","v":0}]
["Construction Cost:",{"$f":"IF(C$281=I$97,0,11.758*G247^2+12402*G247+84932)*G248","v":0}]
["O&M Cost:",{"$f":"IF(C$281=I$97,0,IF(D283=\"\",0,IF(D283=I247,(6506*G247+23506)*AB74,(12388*G247+23506)*AB75)))","v":0},{"$f":"IF(C281=I252,\"\",\"Select Pumping Head\")","v":""}]
[null,null,null,null,null,null,null,null,"Decanter"]
["Finished Water Pumping Facilities:",null,"Not Required",null,null,null,{"$f":"IF(C320=I$288,B320,(IF(C320=I$289,B320*15.8503230745,B320/(24*60))))","v":0},null,"Basket"]
["Construction Cost:",{"$f":"IF(C$285=I$252,0,IF(C$285=I$250,-4.889*G251^2+13015*G251+44288,0.1909*G251^3-85.9*G251^2+28173*G251+53608))*G252","v":0},null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,IF(C319=I284,S86,S87))","v":0},null,"Not Required"]
["O&M Cost:",{"$f":"IF(C$285=I$252,0,IF(C$285=I$250,(6296*G251+22339)*AB76,(16097*G251+22339)*AB77))","v":0},null,null,null,null,{"$f":"(G285*60*24)/1000","v":0}]
[null,null,null,null,null,null,null,null,"gpm"]
["Residue Management",null,null,null,null,null,null,null,"lps"]
["Diatomite Filters:",null,"Not Required",null,null,null,{"$f":"IF(C325=I$288,B325,(IF(C325=I$289,B325*15.8503230745,B325/(24*60))))","v":0},null,"gpd"]
["Construction Cost:",{"$f":"IF(C$290=I$257,0,IF(C$290=I$255,-76.954*G256^2+218790*G256+498789,62.099*G256^2+280763*G256+207572))*G257","v":0}]
["O&M Cost:",{"$f":"IF(C$290=I$257,0,IF(C$290=I$255,(1.1709*G256^3-370.39*G256^2+48425*G256+119921)*AB78,(1.0651*G256^3-345.18*G256^2+45849*G256+106841)*AB79))","v":0},null,null,null,null,{"$f":"D327*G290/100","v":0}]
[]
["Chemical Sludge Pumping:",null,"Not Required"]
["Pumping Capacity",null,"gpm",null,null,null,{"$f":"IF(C330=I$94,B330/1000,(B330*10.7639104)/1000)","v":0}]
["Construction Cost:",{"$f":"IF(C$294=I$261,0,IF(C$294=I$259,0.000001*G260^3-0.0246*G260^2+174.33*G260+89824,0.0004*G260^3-0.7412*G260^2+494.82*G260+22130))*G261","v":0},null,null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S89)","v":0}]
["O&M Cost:",{"$f":"IF(C$294=I$261,0,IF(C$294=I$259,(3*10^-7*G260^3-0.0055*G260^2+40.98*G260+10803)*AB80,(-0.0443*G260^2+117.88*G260+6447)*AB81))","v":0}]
[]
["Gravity Sludge Thickener:",null,"Not Required",null,null,null,{"$f":"'Project Details'!N6","v":0}]
["Diameter:",null,"ft",null,null,null,{"$f":"IF('Project Details'!$B$22=\"Single\",'Project Details'!$O$8,S90)","v":0}]
["Construction Cost:",{"$f":"IF(C$299=I$97,0,0.0039*G265^4-1.0079*G265^3+82.537*G265^2+2833.3*G265+68377)*G266","v":0}]
["O&M Cost:",{"$f":"IF(C$299=I$97,0,0.4225*G265^2+84.568*G265+4454)*AB82","v":0}]
[]
["Vacuum Filter:",null,"Not Required"]
["Total Filter Area:",null,"sq. ft"]
["Construction Cost:",{"$f":"IF(C$304=I$97,0,-0.1664*G270^2+1863*G270+465811)*G271","v":0}]
["O&M Cost:",{"$f":"IF(C$304=I$97,0,0.0007*G270^3-1.4542*G270^2+1441*G270+48536)*AB83","v":0}]
[]
["Sludge Dewatering Lagoon:",null,"Not Required"]
["Effective Storage Volume:",null,"gal"]
["Construction Cost:",{"$f":"IF(C$309=I$97,0,16.041*G275^3-1483.3*G275^2+60825*G275+14155)*G276","v":0}]
["O&M Cost:",{"$f":"IF(C$309=I$97,0,-0.0111*F276^2+352.87*F276+4914)*AB84","v":0},{"$f":"IF(C309=\"Not Required\",\"\",\"Volume of Sludge Removed per Year:\")","v":""},null,"cu ft"]
[]
["Filter Press:",null,"Not Required"]
["Total Filter Press Volume:",null,"Cu ft"]
["Construction Cost:",{"$f":"IF(C$314=I$97,0,0.0093*G280^3-12.453*G280^2+9607.7*G280+734176)*G281","v":0}]
["O&M Cost:",{"$f":"IF(C$314=I$97,0,-0.0021*G280^3+3.288*G280^2+340.87*G280+353816)*AB85","v":0}]
[]
["Centrifuge:",null,"Not Required"]
["Machine Capacity:",null,"gpm"]
["Construction Cost:",{"$f":"IF(C$319=I$286,0,IF(C$319=I$284,0.0133*G285^3-12.685*G285^2+5635.3*G285+411407,0.0001*G287^4-0.1326*G287^3+53.09*G287^2-710.06*G287+522542))*G286","v":0}]
["O&M Cost:",{"$f":"IF(C$319=I$286,0,IF(C$319=I$284,(19829*G285^0.4168)*AB86,(1056.4*G287+26656)*AB87))","v":0}]
[]
["Belt Filter Press:",null,"Not Required"]
["Total Installed Machine Capacity:",null,"gpm"]
["Construction Cost:",{"$f":"IF(C$324=I$97,0,-0.0727*G290^3+47.326*G290^2+13071*G290+389081)*G291","v":0}]
["O&M Cost:",{"$f":"IF(C$324=I$97,0,0.5981*G292^2+1598.4*G292+45127)*AB88","v":0},{"$f":"IF(C324=\"Required\",\"Feed Sludge Flow Rate:\",\"\")","v":""},100,"percent of installed capacity"]
[]
["Sand Drying Bed:",null,"Not Required"]
["Total Bed Area Capacity:",null,"sq. ft"]
["Construction Cost:",{"$f":"IF(C$329=I$97,0,-9.9857*G295^2+10798*G295+14836)*G296","v":0}]
["O&M Cost:",{"$f":"IF(C$329=I$97,0,0.6868*G295^2+1730*G295+24236)*AB89","v":0}]
[]
["Administrative, Laboratory and Maintenance Building",null,"Not Required"]
["Construction Cost:",{"$f":"IF(C$334=I$97,0,69195*G299^0.5523)*G300","v":0}]
["O&M Cost:",{"$f":"IF(C$334=I$97,0,88589*G299^0.4529)*AB90","v":0}]

{"sheet":"Summary of Capital Costs","index":3,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["SUMMARY OF CAPITAL COSTS"]
["Raw Water Pumping Facility",{"$f":"'Unit Operation and Processes'!B4","v":0}]
["Pre-Treatment",{"$f":"'Unit Operation and Processes'!B11+'Unit Operation and Processes'!B18+'Unit Operation and Processes'!B24+'Unit Operation and Processes'!B27+'Unit Operation and Processes'!B31+'Unit Operation and Processes'!B37+'Unit Operation and Processes'!B42","v":0}]
["Aeration",{"$f":"'Unit Operation and Processes'!B48","v":0}]
["Coagulation and Flocculation",{"$f":"'Unit Operation and Processes'!B55+'Unit Operation and Processes'!B62+'Unit Operation and Processes'!B69+'Unit Operation and Processes'!B76+'Unit Operation and Processes'!B83+'Unit Operation and Processes'!B90+'Unit Operation and Processes'!B96+'Unit Operation and Processes'!B102","v":0}]
["Sedimentation",{"$f":"'Unit Operation and Processes'!B111+'Unit Operation and Processes'!B115+'Unit Operation and Processes'!B121","v":0}]
["Filtration",{"$f":"'Unit Operation and Processes'!B128+'Unit Operation and Processes'!B132+'Unit Operation and Processes'!B137+'Unit Operation and Processes'!B141+'Unit Operation and Processes'!B145+'Unit Operation and Processes'!B151+'Unit Operation and Processes'!B157+'Unit Operation and Processes'!B163+'Unit Operation and Processes'!B167+'Unit Operation and Processes'!B171","v":0}]
["Taste and Odor Control",{"$f":"'Unit Operation and Processes'!B178","v":0}]
["Disinfection",{"$f":"'Unit Operation and Processes'!B186+'Unit Operation and Processes'!B191","v":0}]
["Ion Exchange",{"$f":"'Unit Operation and Processes'!B196+'Unit Operation and Processes'!B200","v":0}]
["Fluoride Removal",{"$f":"'Unit Operation and Processes'!B205","v":0}]
["Stability",{"$f":"'Unit Operation and Processes'!B212+'Unit Operation and Processes'!B219+'Unit Operation and Processes'!B224+'Unit Operation and Processes'!B229+'Unit Operation and Processes'!B235+'Unit Operation and Processes'!B240+'Unit Operation and Processes'!B246+'Unit Operation and Processes'!B251+'Unit Operation and Processes'!B257+'Unit Operation and Processes'!B262+'Unit Operation and Processes'!B267+'Unit Operation and Processes'!B272","v":0}]
["Clear Water Storage and Distribution",{"$f":"'Unit Operation and Processes'!B278+'Unit Operation and Processes'!B282+'Unit Operation and Processes'!B286","v":0}]
["Residue Management",{"$f":"'Unit Operation and Processes'!B291+'Unit Operation and Processes'!B296+'Unit Operation and Processes'!B301+'Unit Operation and Processes'!B306+'Unit Operation and Processes'!B311+'Unit Operation and Processes'!B316+'Unit Operation and Processes'!B321+'Unit Operation and Processes'!B326+'Unit Operation and Processes'!B331","v":0}]
["Administrative, Laboratory and Maintenance Building",{"$f":"'Unit Operation and Processes'!B335","v":0}]
["Other Uncovered Cost"]
["Subtotal",{"$f":"SUM(B2:B16)","v":0}]
["Special Costs:"]
["    General Contractor's Overhead:",{"$f":"'Project Details'!B16*'Summary of Capital Costs'!B$17","v":0}]
["    Engineering:",{"$f":"'Project Details'!B17*'Summary of Capital Costs'!B$17","v":0}]
["    Land",{"$f":"'Project Details'!B18*'Summary of Capital Costs'!B$17","v":0}]
["    Legal",{"$f":"'Project Details'!B19*'Summary of Capital Costs'!B$17","v":0}]
["    Fiscal",{"$f":"'Project Details'!B20*'Summary of Capital Costs'!B$17","v":0}]
["    Administrative",{"$f":"'Project Details'!B21*'Summary of Capital Costs'!B$17","v":0}]
["Other Costs"]
["Total Capital Cost",{"$f":"SUM(B17:B25)","v":0}]

{"sheet":"Summary of O&M Costs","index":4,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["SUMMARY OF O&M COSTS"]
["Raw Water Pumping Facility",{"$f":"'Unit Operation and Processes'!B5","v":0}]
["Pre-Treatment",{"$f":"'Unit Operation and Processes'!B12+'Unit Operation and Processes'!B19+'Unit Operation and Processes'!B25+'Unit Operation and Processes'!B32+'Unit Operation and Processes'!B38+'Unit Operation and Processes'!B43","v":0}]
["Aeration",{"$f":"'Unit Operation and Processes'!B49","v":0}]
["Coagulation and Flocculation",{"$f":"'Unit Operation and Processes'!B56+'Unit Operation and Processes'!B63+'Unit Operation and Processes'!B70+'Unit Operation and Processes'!B77+'Unit Operation and Processes'!B84+'Unit Operation and Processes'!B91+'Unit Operation and Processes'!B97+'Unit Operation and Processes'!B103","v":0}]
["Sedimentation",{"$f":"'Unit Operation and Processes'!B112","v":0}]
["Filtration",{"$f":"'Unit Operation and Processes'!B129+'Unit Operation and Processes'!B146+'Unit Operation and Processes'!B152+'Unit Operation and Processes'!B168+'Unit Operation and Processes'!B172","v":0}]
["Taste and Odor Control",{"$f":"'Unit Operation and Processes'!B179","v":0}]
["Disinfection",{"$f":"'Unit Operation and Processes'!B187+'Unit Operation and Processes'!B192","v":0}]
["Ion Exchange",{"$f":"'Unit Operation and Processes'!B197+'Unit Operation and Processes'!B201","v":0}]
["Fluoride Removal",{"$f":"'Unit Operation and Processes'!B206","v":0}]
["Stability",{"$f":"'Unit Operation and Processes'!B213+'Unit Operation and Processes'!B225+'Unit Operation and Processes'!B230+'Unit Operation and Processes'!B236+'Unit Operation and Processes'!B241+'Unit Operation and Processes'!B247+'Unit Operation and Processes'!B263+'Unit Operation and Processes'!B268+'Unit Operation and Processes'!B273","v":0}]
["Clear Water Storage and Distribution",{"$f":"'Unit Operation and Processes'!B283+'Unit Operation and Processes'!B287","v":0}]
["Residue Management",{"$f":"'Unit Operation and Processes'!B292+'Unit Operation and Processes'!B297+'Unit Operation and Processes'!B302+'Unit Operation and Processes'!B307+'Unit Operation and Processes'!B312+'Unit Operation and Processes'!B317+'Unit Operation and Processes'!B322+'Unit Operation and Processes'!B327+'Unit Operation and Processes'!B332","v":0}]
["Administrative, Laboratory and Maintenance Building",{"$f":"'Unit Operation and Processes'!B336","v":0}]
["Chemical Costs",{"$f":"'Unit Operation and Processes'!B13+'Unit Operation and Processes'!B20+'Unit Operation and Processes'!B39+'Unit Operation and Processes'!B57+'Unit Operation and Processes'!B64+'Unit Operation and Processes'!B71+'Unit Operation and Processes'!B78+'Unit Operation and Processes'!B85+'Unit Operation and Processes'!B92+'Unit Operation and Processes'!B180+'Unit Operation and Processes'!B188+'Unit Operation and Processes'!B214","v":0}]
["Other Chemical Costs"]
["Other O&M Costs"]
["Total O&M COST",{"$f":"SUM(B2:B18)","v":0}]

{"sheet":"Present & Annul Value","index":5,"n_rows":43,"n_cols":51,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Design Life:",{"$f":"'Project Details'!B8","v":0}]
["Interest Rate:",{"$f":"'Project Details'!B9","v":0}]
["Inflation Rate:",{"$f":"'Project Details'!B10","v":0}]
[null,{"$f":"IF(1>'Project Details'!$B$8,\"\",\"Year 1\")","v":""},{"$f":"IF(2>'Project Details'!$B$8,\"\",\"Year 2\")","v":""},{"$f":"IF(3>'Project Details'!$B$8,\"\",\"Year 3\")","v":""},{"$f":"IF(4>'Project Details'!$B$8,\"\",\"Year 4\")","v":""},{"$f":"IF(5>'Project Details'!$B$8,\"\",\"Year 5\")","v":""},{"$f":"IF(6>'Project Details'!$B$8,\"\",\"Year 6\")","v":""},{"$f":"IF(7>'Project Details'!$B$8,\"\",\"Year 7\")","v":""},{"$f":"IF(8>'Project Details'!$B$8,\"\",\"Year 8\")","v":""},{"$f":"IF(9>'Project Details'!$B$8,\"\",\"Year 9\")","v":""},{"$f":"IF(10>'Project Details'!$B$8,\"\",\"Year 10\")","v":""},{"$f":"IF(11>'Project Details'!$B$8,\"\",\"Year 11\")","v":""},{"$f":"IF(12>'Project Details'!$B$8,\"\",\"Year 12\")","v":""},{"$f":"IF(13>'Project Details'!$B$8,\"\",\"Year 13\")","v":""},{"$f":"IF(14>'Project Details'!$B$8,\"\",\"Year 14\")","v":""},{"$f":"IF(15>'Project Details'!$B$8,\"\",\"Year 15\")","v":""},{"$f":"IF(16>'Project Details'!$B$8,\"\",\"Year 16\")","v":""},{"$f":"IF(17>'Project Details'!$B$8,\"\",\"Year 17\")","v":""},{"$f":"IF(18>'Project Details'!$B$8,\"\",\"Year 18\")","v":""},{"$f":"IF(19>'Project Details'!$B$8,\"\",\"Year 19\")","v":""},{"$f":"IF(20>'Project Details'!$B$8,\"\",\"Year 20\")","v":""},{"$f":"IF(21>'Project Details'!$B$8,\"\",\"Year 21\")","v":""},{"$f":"IF(22>'Project Details'!$B$8,\"\",\"Year 22\")","v":""},{"$f":"IF(23>'Project Details'!$B$8,\"\",\"Year 23\")","v":""},{"$f":"IF(24>'Project Details'!$B$8,\"\",\"Year 24\")","v":""},{"$f":"IF(25>'Project Details'!$B$8,\"\",\"Year 25\")","v":""},{"$f":"IF(26>'Project Details'!$B$8,\"\",\"Year 26\")","v":""},{"$f":"IF(27>'Project Details'!$B$8,\"\",\"Year 27\")","v":""},{"$f":"IF(28>'Project Details'!$B$8,\"\",\"Year 28\")","v":""},{"$f":"IF(29>'Project Details'!$B$8,\"\",\"Year 29\")","v":""},{"$f":"IF(30>'Project Details'!$B$8,\"\",\"Year 30\")","v":""},{"$f":"IF(31>'Project Details'!$B$8,\"\",\"Year 31\")","v":""},{"$f":"IF(32>'Project Details'!$B$8,\"\",\"Year 32\")","v":""},{"$f":"IF(33>'Project Details'!$B$8,\"\",\"Year 33\")","v":""},{"$f":"IF(34>'Project Details'!$B$8,\"\",\"Year 34\")","v":""},{"$f":"IF(35>'Project Details'!$B$8,\"\",\"Year 35\")","v":""},{"$f":"IF(36>'Project Details'!$B$8,\"\",\"Year 36\")","v":""},{"$f":"IF(37>'Project Details'!$B$8,\"\",\"Year 37\")","v":""},{"$f":"IF(38>'Project Details'!$B$8,\"\",\"Year 38\")","v":""},{"$f":"IF(39>'Project Details'!$B$8,\"\",\"Year 39\")","v":""},{"$f":"IF(40>'Project Details'!$B$8,\"\",\"Year 40\")","v":""},{"$f":"IF(41>'Project Details'!$B$8,\"\",\"Year 41\")","v":""},{"$f":"IF(42>'Project Details'!$B$8,\"\",\"Year 42\")","v":""},{"$f":"IF(43>'Project Details'!$B$8,\"\",\"Year 43\")","v":""},{"$f":"IF(44>'Project Details'!$B$8,\"\",\"Year 44\")","v":""},{"$f":"IF(45>'Project Details'!$B$8,\"\",\"Year 45\")","v":""},{"$f":"IF(46>'Project Details'!$B$8,\"\",\"Year 46\")","v":""},{"$f":"IF(47>'Project Details'!$B$8,\"\",\"Year 47\")","v":""},{"$f":"IF(48>'Project Details'!$B$8,\"\",\"Year 48\")","v":""},{"$f":"IF(49>'Project Details'!$B$8,\"\",\"Year 49\")","v":""},{"$f":"IF(50>'Project Details'!$B$8,\"\",\"Year 50\")","v":""}]
["Annuatized Capital Cost",{"$f":"IF(B4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(C4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(D4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(E4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(F4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(G4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(H4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(I4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(J4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(K4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(L4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(M4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(N4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(O4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(P4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(Q4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(R4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(S4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(T4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(U4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(V4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(W4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(X4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(Y4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(Z4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AA4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AB4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AC4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AD4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AE4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AF4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AG4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AH4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AI4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AJ4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AK4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AL4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AM4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AN4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AO4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AP4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AQ4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AR4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AS4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AT4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AU4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AV4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AW4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AX4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""},{"$f":"IF(AY4=\"\",\"\",(($B$2*(1+$B$2)^$B$1)/((1+$B$2)^$B$1-1))*'Summary of Capital Costs'!$B$26)","v":""}]
["Inflated O&M Cost",{"$f":"IF(B4=\"\",\"\",'Summary of O&M Costs'!B19)","v":""},{"$f":"IF(C4=\"\",\"\",B6*(1+$B$3))","v":""},{"$f":"IF(D4=\"\",\"\",C6*(1+$B$3))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Annual Cost",{"$f":"IF(B4=\"\",\"\",B5+B6)","v":""},{"$f":"IF(C4=\"\",\"\",C5+C6)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Present Value of Project Capital and O& M Cost",{"$f":"SUM(B42:AY42)","v":0}]
["Equivalent Annual Cost",{"$f":"IF(B1=0,\"\",B8*((B2*(1+B2)^B1)/((1+B2)^B1-1)))","v":""}]
["Cost per gal of water Treated",{"$f":"IF(B9=\"\",\"\",B9/('Project Details'!N6*'Project Details'!B7*1000000*365))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(B4=\"\",\"\",((1+$B$2)^-B43)*B7)","v":""},{"$f":"IF(C4=\"\",\"\",((1+$B$2)^-C43)*C7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,1,{"$f":"B43+1","v":2},{"$f":"C43+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]