{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Start","Anaerobic lagoon (BAU)","Aerated Lagoon + AS (Baseline)","Anaerobic","Aerated Lagoon + AS","Swimbed","UASB","UASBSWIMBED","Comparsion","Co-benefits","COD comparison (using MOE formt","GHG emission comparison","Swimbed Scenario","UASB + AS","UASB + SWIMBED","Reduction in COD from 5 scen","REFERENCE"],"not_rendered":{"charts":4,"images":0,"macros":1,"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":"Start","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Anaerobic lagoon (BAU)","index":1,"n_rows":23,"n_cols":19,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,12,2,20],[3,18,3,20],[0,0,0,20],[2,6,2,8],[10,1,10,4],[2,1,2,4],[4,12,9,12],[4,18,9,20],[10,12,11,12],[10,18,16,20],[12,12,13,12],[15,12,16,12],[17,12,21,12],[20,1,22,1],[4,1,6,1],[12,1,16,1],[17,1,19,1]]}
["Anaerobic Lagoon (single step process)"]
[]
[null,"Input ",null,null,null,null,"Default Value",null,null,null,null,null,"Output"]
[null,"Category","Item","Unit","Value",null,"Item","Unit","Value","Source","Reference",null,"Category","Item","Unit","Value","Unit","Value"]
[null,"Waste water treatment","Amount of waste water","m3/day",{"$f":"Anaerobic!$G$6","v":35965},null,"Oxygen Demand (OD) removal efficiency at first step","%",{"$f":"Anaerobic!$G$9","v":50},"MOJ",null,null,"Waste water treatment","COD after","g/m3",{"$f":"E16","v":753.5},"kg/day",{"$f":"P5*$E$5/1000","v":27099.627499999999},"this calculation based on EPA equation"]
[null,null,"COD concentration of raw water","mg/L",{"$f":"Anaerobic!$G$7","v":1507},null,"COD/BOD",null,1.9,"calculation (supporting details on report)",null,null,null,"COD removed","g/m3",{"$f":"E15","v":753.5},"kg/day",{"$f":"P6*$E$5/1000","v":27099.627499999999}]
[null,null,"Total Nitrogen (TN)","mg/L",{"$f":"Anaerobic!$G$8","v":120.56},null,"Amount gas generated/kg COD removal (anaerobic process)","m3/kg COD removal",0.15,"MOJ",null,null,null,"COD removal","%",{"$f":"P6/E6*100","v":50},"%",{"$f":"P6/E6*100","v":50}]
[null,"COD removal from sludge","Generated amount of sludge","kgDS/day",{"$f":"Anaerobic!$G$14","v":5306},null,"Conversion factor","kg CH4/m3",0.71399999999999997,"MOJ",null,null,null,"CO2 emission","ton/h",{"$f":"((10^(-6)*E13*E6*(I5/100)*I17*((1-I19*I21)*(1-I20))))","v":0.67071578062500004},"kg/day",{"$f":"P8*1000*24","v":16097.178735}]
[null,"Electricity use","Electricity consumption ","kWh/day",{"$f":"Anaerobic!$G$15","v":42561},null,"CH4 Global Warming Potential","kg CO2 e/kg CH4",21,"IPCC",null,null,null,"CH4 emission","ton/h",{"$f":"((10^(-6)*E13*E6*(I5/100)*I18*((I19*I21)*(1-I20))))","v":0.26422136812500002},"kg/day",{"$f":"P9*1000*24","v":6341.3128350000006}]
[null,null,null,null,null,null,"N2O ","kg CO2 e/kg N2O",298,"IPCC",null,null,null,"N2O emission","ton/h",{"$f":"E13*E7*I22*(44/28)*(10^(-6))","v":1.4195042976190477E-3},"kg/day",{"$f":"P10*1000*24","v":34.068103142857147}]
[null,"Calculation ",null,null,null,null,"COD degradation rate at up to discharge point","%",{"$f":"Anaerobic!$G$10","v":50},"MOJ",null,null,"At up to discharge point","COD after","g/m3",{"$f":"E19","v":376.75},"kg/day",{"$f":"P11*$E$5/1000","v":13549.813749999999},"this calculation based on IGES DATA "]
[null,"Category","Item","Unit","Value",null,"COD degradation rate at discharge point","%",{"$f":"Anaerobic!$G$11","v":10},"MOJ",null,null,null,"GHG Emission","kg/day",{"$f":"E18*E5*I13*I14*I9/1000","v":56169.397919249997},"kg/day",{"$f":"P12","v":56169.397919249997}]
[null,"Wastewater treatment (Anaerobic lagoon - one step)","Waste water influent flow rate (Qww)","m3/h",{"$f":"E5/24","v":1498.5416666666667},null,"Maximum methane formation potential","kgCH4/kgCOD",{"$f":"Anaerobic!$G$12","v":0.21},"MOJ",null,null,"At dischagre point","COD after","g/m3",{"$f":"E22","v":339.07499999999999},"kg/day",{"$f":"P13*$E$5/1000","v":12194.832375}]
[null,null,"BOD5 influent","g/m3",{"$f":"E6/I6","v":793.1578947368422},null,"Model correction coeficient",null,0.94,"MOJ",null,null,null,"GHG Emission","kg/day",{"$f":"E21*E5*I13*I14*I9/1000","v":5616.9397919249986},"kg/day",{"$f":"P14","v":5616.9397919249986}]
[null,null,"COD removed","g/m3",{"$f":"E6*I5/100","v":753.5},null,"Methane emission/kg generated sludge ","kgCH4/kgDS",{"$f":"Anaerobic!$G$13","v":0.15},"MOJ",null,null,"From Sludge","GHG Emission","kg CO2e/day",{"$f":"E8*I15*I9","v":16713.899999999998},"kg/day",{"$f":"P15","v":16713.899999999998}]
[null,null,"COD Effluent","g/m3",{"$f":"E6-E15","v":753.5},null,"Electricity emission factor","kgCO2/kWh",0.754,"ADB, 2017 (also used by MOJ)",null,null,"By Electricity Used","CO2 emission","kg CO2e/day",{"$f":"E9*I16","v":32090.993999999999},"kg/day",{"$f":"P16","v":32090.993999999999}]
[null,null,"BOD5 effluent","g/m3",{"$f":"E16/I6","v":396.5789473684211},null,"CF CO2","g CO2/g Oxygen demand",1.375,"EPA",null,null,null,"GHG Emission","kg CO2e/day",{"$f":"P16","v":32090.993999999999},"kg/day",{"$f":"P17","v":32090.993999999999}]
[null,"At up to discharge point","COD removed","g/m3",{"$f":"E16*(I11/100)","v":376.75},null,"CH CH4","g CH4/g Oxygen demand",0.5,"EPA",null,null,"GHG emission","From total CO2 emisson","kg CO2e/day",{"$f":"R8+R16","v":48188.172735}]
[null,null,"COD Effluent","g/m3",{"$f":"E16-E18","v":376.75},null,"MCF ww for anaerobic lagoon",null,0.8,"IPCC",null,null,null,"From total CH4 emisson","kg CO2e/day",{"$f":"(R9*21)+R12+R14+R15","v":211667.80724617501}]
[null,null,"BOD5 effluent","g/m3",{"$f":"E19/I6","v":198.28947368421055},null,"λ  for anaerobic lagoon",null,0.1,"Ammary (2004); Low and Chase (1999)",null,null,null,"From total N2O emisson","kg CO2e/day",{"$f":"R10*I10","v":10152.29473657143}]
[null,"At discharge point","COD removed","g/m3",{"$f":"E19*I12/100","v":37.674999999999997},null,"BG CH4",null,0.65,"EPA",null,null,null,"Total from CO2 and CH4 total emission","kg CO2e/day",{"$f":"P18+P19","v":259855.97998117501}]
[null,null,"COD Effluent","g/m3",{"$f":"E19-E21","v":339.07499999999999},null,"NO2 Emission factor","g N2O/g TN",5.0000000000000001E-3,"Chandran 2010 and IPCC",null,null,null,"Total from CO2  CH4 and N2O total emission","kg CO2e/day",{"$f":"P18+P19+P20","v":270008.27471774642}]
[null,null,"BOD5 effluent","g/m3",{"$f":"E22/I6","v":178.46052631578948}]

{"sheet":"Aerated Lagoon + AS (Baseline)","index":2,"n_rows":69,"n_cols":19,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,1,20],[31,1,32,4],[63,1,65,1],[5,18,12,20],[13,12,14,12],[13,18,19,20],[15,12,16,12],[18,12,19,12],[20,12,28,12],[66,1,68,1],[3,12,3,20],[4,18,4,20],[34,7,34,9],[35,2,35,4],[59,1,62,1],[33,1,33,4],[3,1,3,4],[5,1,11,1],[49,1,58,1],[3,6,3,8],[5,12,12,12],[36,1,48,1]]}
["Aeration lagoon/ Activated sludge"]
[]
[]
[null,"Input ",null,null,null,null,"Default Value",null,null,null,null,null,"Output"]
[null,"Category","Item","Unit","Value",null,"Item","Unit","Value","Source","Reference",null,"Category","Item","Unit","Value","Unit","Value"]
[null,"Waste water treatment","Temperature","°C",{"$f":"'Aerated Lagoon + AS'!$G$6","v":20},null,"Oxygen Demand (OD) removal efficiency at first step","%",{"$f":"E39/E11*100","v":89.518968855506955},"calculation by this model ",null,null,"Waste water treatment","COD after","g/m3",{"$f":"E52","v":126.35931147800822},"kg/day",{"$f":"P6*$E$10/1000","v":4544.512637306565},"this calculation based on EPA equation"]
[null,null,"Total hydraulic residence time in pond system (d)","days",{"$f":"'Aerated Lagoon + AS'!$G$7","v":20},null,"COD/BOD",null,1.9,null,null,null,null,"COD removed","g/m3",{"$f":"E60","v":1380.6406885219917},"kg/day",{"$f":"P7*$E$10/1000","v":49654.742362693432}]
[null,null,"Number of cells ","cells",{"$f":"'Aerated Lagoon + AS'!$G$8","v":1},null,"Amount gas generated/kg COD removal (anaerobic process)","m3/kg COD removal",0.15,"MOJ",null,null,null,"COD removal","%",{"$f":"P7/E11*100","v":91.61517508440555},"%",{"$f":"P7/E11*100","v":91.61517508440555}]
[null,null,"BOD rate constant@T/day (KT)","/d ",{"$f":"I28*(I29)^(E6-20)","v":0.23},null,"Conversion factor","kg CH4/m3",0.71399999999999997,"MOJ",null,null,null,"CO2 emission (well managed system)","ton/h",{"$f":"E45+E55","v":0.99568103175192546},"kg/day",{"$f":"P9*1000*24","v":23896.34476204621}]
[null,null,"Amount of waste water","m3/day",{"$f":"'Aerated Lagoon + AS'!$G$9","v":35965},null,"CH4 Global Warming Potential","kg CO2 e/kg CH4",21,"IPCC",null,null,null,"CO2 emission (overloaded system)","ton/h",{"$f":"E46+E56","v":1.2595365051661858},"kg/day",{"$f":"P10*1000*24","v":30228.876123988462}]
[null,null,"COD concentration of raw water","mg/L",{"$f":"'Aerated Lagoon + AS'!$G$10","v":1507},null,"N2O ","kg CO2 e/kg N2O",298,"IPCC",null,null,null,"CH4 emission (well managed system)","ton/h",{"$f":"E47+E57","v":0},"kg/day",{"$f":"P11*1000*24","v":0}]
[null,null,"Total Nitrogen (TN)","mg/L",{"$f":"'Aerated Lagoon + AS'!$G$11","v":120.56},null,"COD degradation rate at up to discharge point","%",{"$f":"'Aerated Lagoon + AS'!$G$12","v":50},"MOJ",null,null,null,"CH4 emission (overloaded system)","ton/h",{"$f":"E48+E58","v":0.11094731496664316},"kg/day",{"$f":"P12*1000*24","v":2662.735559199436}]
[null,"COD removal from sludge","Generated amount of sludge","kgDS/day",{"$f":"'Aerated Lagoon + AS'!$G$17","v":15294},null,"COD degradation rate at discharge point","%",{"$f":"'Aerated Lagoon + AS'!$G$13","v":10},"MOJ",null,null,null,"N2O emission","ton/h",{"$f":"E49+E59","v":2.1292564464285716E-3},"kg/day",{"$f":"P13*1000*24","v":51.102154714285717}]
[null,"Electricity use","Total Electricity consumption ","kWh/day",{"$f":"'Aerated Lagoon + AS'!$G$18","v":155917},null,"Maximum methane formation potential","kgCH4/kgCOD",{"$f":"'Aerated Lagoon + AS'!$G$14","v":0.21},"MOJ",null,null,"At up to discharge point","COD after","g/m3",{"$f":"E65","v":63.179655739004112},"kg/day",{"$f":"P14*$E$10/1000","v":2272.2563186532825},"this calculation based on IGES DATA "]
[null,null,null,null,null,null,"Model correction coeficient",null,0.94,"MOJ",null,null,null,"GHG Emission","kg/day",{"$f":"E64*E10*I14*I15*I10/1000","v":9419.4113433453167},"kg/day",{"$f":"P15","v":9419.4113433453167}]
[null,null,null,null,null,null,"Methane emission/kg generated sludge ","kgCH4/kgDS",{"$f":"'Aerated Lagoon + AS'!$G$15","v":0.15},"MOJ",null,null,"At dischagre point","COD after","g/m3",{"$f":"E68","v":56.861690165103703},"kg/day",{"$f":"P16*$E$10/1000","v":2045.0306867879547}]
[null,null,null,null,null,null,"Electricity emission factor","kgCO2/kWh",0.754,"ADB, 2017 (also used by MOJ)",null,null,null,"GHG Emission","kg/day",{"$f":"E67*E10/1000*I14*I15*I10","v":941.94113433453174},"kg/day",{"$f":"P17","v":941.94113433453174}]
[null,null,null,null,null,null,"CF CO2","g CO2/g Oxygen demand",1.375,"EPA",null,null,"From Sludge","GHG Emission","kg CO2e/day",{"$f":"E13*I16*I10","v":48176.1},"kg/day",{"$f":"P18","v":48176.1}]
[null,null,null,null,null,null,"CF CH4","g CH4/g Oxygen demand",0.5,"EPA",null,null,"By Electricity Used","CO2 emission","kg CO2e/day",{"$f":"E14*I17","v":117561.41800000001},"kg/day",{"$f":"P19","v":117561.41800000001}]
[null,null,null,null,null,null,"MCF ww for aerobic lagoon well managed",null,0,"IPCC",null,null,null,"GHG Emission","kg CO2e/day",{"$f":"P19","v":117561.41800000001},"kg/day",{"$f":"P20","v":117561.41800000001}]
[null,null,null,null,null,null,"MCF ww for aerobic lagoon overloaded/anoxic",null,0.3,"EPA",null,null,"GHG emission","From total CO2 emisson (well manage system)","kg CO2e/day",{"$f":"R9+R19","v":141457.76276204622}]
[null,null,null,null,null,null,"λ  for aerobic lagoon well managed",null,0.65,"Choubert et al (2009), Muller et al (2003), Munz (2008)",null,null,null,"From total CO2 emisson (overloaded system)","kg CO2e/day",{"$f":"R10+R19","v":147790.29412398848}]
[null,null,null,null,null,null,"λ  for aerobic lagoon overloaded",null,0.45,"EPA",null,null,null,"From total CH4 emisson (well managed system)","kg CO2e/day",{"$f":"(R11*21)+R15+R17+R18","v":58537.45247767985}]
[null,null,null,null,null,null,"BG CH4",null,0.65,"EPA",null,null,null,"From total CH4 emisson (overloaded system)","kg CO2e/day",{"$f":"(R12*21)+R15+R17+R18","v":114454.89922086801}]
[null,null,null,null,null,null,"NO2 Emission factor","g N2O/g TKN",5.0000000000000001E-3,"Chandran 2010 and IPCC",null,null,null,"From total N2O emisson","kg CO2e/day",{"$f":"R13*I11","v":15228.442104857144}]
[null,null,null,null,null,null,"Oxygen Demand (OD) removal efficiency at clariffier settle",null,0.2,"EPA",null,null,null,"well managed system from CO2 and CH4 total emission","kg CO2e/day",{"$f":"P21+P23","v":199995.21523972607}]
[null,null,null,null,null,null,"k (first order reaction rate constant (assumed to be constant in all cells)"," day-1 at 20° C ",0.27600000000000002,"EPA",null,null,null,"overloaded system from CO2 and CH4 total emission","kg CO2e/day",{"$f":"P22+P24","v":262245.1933448565}]
[null,null,null,null,null,null,"K20 (BOD rate constant@20°C)","/day",0.23,"EPA",null,null,null,"well managed system from CO2  CH4 and NO2 total emission","kg CO2e/day",{"$f":"P26+P25","v":215223.65734458322}]
[null,null,null,null,null,null,"θ (Temperature Coefissient )",null,1.056,"EPA",null,null,null,"over loaded system from CO2  CH4 and NO2 total emission","kg CO2e/day",{"$f":"P27+P25","v":277473.63544971362}]
[null,null,null,null,null,null,"TN removal  eff in  Aeration tank",null,{"$f":"'Aerated Lagoon + AS'!$G$16/100","v":0.5}]
[]
[null,"Calculation "]
[]
[null,"Proposed Calculation"]
[null,"Category","Item","Unit","Value"]
[null,"Waste water treatment"]
[null,"1st step : Aerobic lagoon","Waste water influent flow rate (Qww)","m3/h",{"$f":"E10/24","v":1498.5416666666667}]
[null,null,"BOD5 influent","g/m3",{"$f":"E11/I7","v":793.1578947368422}]
[null,null,"COD removed","g/m3",{"$f":"E11-E40","v":1349.0508606524897}]
[null,null,"COD Effluent","g/m3",{"$f":"E41*I7","v":157.94913934751028}]
[null,null,"BOD5 effluent","g/m3",{"$f":"(E38)*(1-EXP(-E9*5))*(1/(1+(I27*E7)/E8)^E8)","v":83.131125972373837}]
[null,null,"BOD removed","g/m3",{"$f":"E38-E41","v":710.02676876446833}]
[null,null,"COD removal efficiency",null,{"$f":"E39/E11","v":0.89518968855506953}]
[null,null,"TN after","g/m3",{"$f":"E12-(E12*I30)","v":60.28}]
[null,null,"CO2 emission (if system is well managed)","ton/h",{"$f":"(10^(-6))*E37*E11*E43*$I$18*((1-I20*$I$24)*(1-I22))","v":0.97289929522376106}]
[null,null,"CO2 emission (if system is overloaded)","ton/h",{"$f":"(10^(-6))*E37*E11*E43*$I$18*((1-I21*$I$24)*(1-I23))","v":1.2307176084580578}]
[null,null,"CH4 emission (if system is well managed)","ton/h",{"$f":"(10^-6)*E37*E11*E43*I19*(I20*I24)*(1-I22)","v":0}]
[null,null,"CH4 emission (if system is overloaded)","ton/h",{"$f":"(10^-6)*E37*E11*E43*I19*(I21*I24)*(1-I23)","v":0.1084087786106477}]
[null,null,"N2O emission","ton/h",{"$f":"E37*E12*I25*44/28*10^-6","v":1.4195042976190477E-3}]
[null,"2nd step : Clariffier Settler","Waste water influent flow rate (Qww)","m3/h",{"$f":"E37","v":1498.5416666666667}]
[null,null,"COD removed","g/m3",{"$f":"E40*I26","v":31.589827869502059}]
[null,null,"COD Effluent","g/m3",{"$f":"E40-E51","v":126.35931147800822}]
[null,null,"BOD5 removed","g/m3",{"$f":"E41*I26","v":16.626225194474767}]
[null,null,"BOD5 effluent","g/m3",{"$f":"E41-E53","v":66.504900777899067}]
[null,null,"CO2 emission (if system is well managed)","ton/h",{"$f":"(10^-6)*E50*E40*I26*I18*((1-I20*I24)*(1-I22))","v":2.2781736528164429E-2}]
[null,null,"CO2 emission (if system is overloaded)","ton/h",{"$f":"(10^-6)*E50*E40*I26*I18*((1-I21*I24)*(1-I23))","v":2.8818896708128001E-2}]
[null,null,"CH4 emission (if system is well managed)","ton/h",{"$f":"(10^-6)*E50*E40*I26*I19*(I20*I24)*(1-I22)","v":0}]
[null,null,"CH4 emission (if system is overloaded)","ton/h",{"$f":"(10^-6)*E50*E40*I26*I19*(I21*I24)*(1-I23)","v":2.538536355995465E-3}]
[null,null,"N2O emission","ton/h",{"$f":"E50*E44*I25*44/28*10^-6","v":7.0975214880952386E-4}]
[null,null,"Total COD removal","g/m3",{"$f":"E39+E51","v":1380.6406885219917}]
[null,null,"Total BOD removal","g/m4",{"$f":"E42+E53","v":726.65299395894306}]
[null,null,"COD removal efficiency in baseline scenario",null,{"$f":"E60/E11","v":0.91615175084405553}]
[null,null,"BOD removal efficiency in baseline scenario",null,{"$f":"E61/E38","v":0.91615175084405553}]
[null,"At up to discharge point","COD removed","g/m3",{"$f":"E52*(I12/100)","v":63.179655739004112}]
[null,null,"COD Effluent","g/m3",{"$f":"E52-E64","v":63.179655739004112}]
[null,null,"BOD5 effluent","g/m3",{"$f":"E65/I7","v":33.252450388949534}]
[null,"At discharge point","COD removed","g/m3",{"$f":"E65*I13/100","v":6.3179655739004117}]
[null,null,"COD Effluent","g/m3",{"$f":"E65-E67","v":56.861690165103703}]
[null,null,"BOD5 effluent","g/m3",{"$f":"E68/I7","v":29.927205350054582}]

{"sheet":"Anaerobic","index":3,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,"Anaerobic lagoon"]
[]
[null,null,null,null,"Input","Unit","Value"]
[null,null,null,null,"Amount of the Wastewater ","m3/d",35965]
[null,null,null,null,"COD Concentration in Wastewater","g/m3",1507]
[null,null,null,null,"Total Nitrogen in Wastewater","g/m3",120.56]
[null,null,null,null,"COD removal efficiency at first step","%",50]
[null,null,null,null,"COD degradation rate at up to discharge point","%",50]
[null,null,null,null,"COD degradation rate at discharge point","%",10]
[null,null,null,null,"Maximum methane formation potential","kgCH4/kgCOD",0.21]
[null,null,null,null,"Methane emission/kg generated sludge ","kgCH4/kg Sludge",0.15]
[null,null,null,null,"Amount  of generated sludge","kg/d",5306]
[null,null,null,null,"Electricity Use","kWh/d",42561]
[]
[]
[]
[]
[]
[null,null,null,null,"Output","Unit","Value"]
[null,null,null,null,"COD Concentration at the different stages"]
[null,null,null,null,"After the wastewater treatment","g/m3",{"$f":"'Anaerobic lagoon (BAU)'!$P$5","v":753.5}]
[null,null,null,null,"At up to discharge point","g/m3",{"$f":"'Anaerobic lagoon (BAU)'!$P$11","v":376.75}]
[null,null,null,null,"At discharge point","g/m3",{"$f":"'Anaerobic lagoon (BAU)'!$P$13","v":339.07499999999999}]
[null,null,null,null,"GHG Emissions at the different stages"]
[null,null,null,null,"Wastewater treatment","kg CO2e/d",{"$f":"'GHG emission comparison'!$F$7+('GHG emission comparison'!$F$8*21)+('GHG emission comparison'!$F$9*298)","v":159417.04300657145}]
[null,null,null,null,"At up to discharge point","kg CO2e/d",{"$f":"'GHG emission comparison'!F10","v":56169.397919249997}]
[null,null,null,null,"At discharge point","kg CO2e/d",{"$f":"'GHG emission comparison'!F11","v":5616.9397919249986}]
[null,null,null,null,"From sludge","kg CO2e/d",{"$f":"'GHG emission comparison'!F12","v":16713.899999999998}]
[null,null,null,null,"From electricity used","kg CO2e/d",{"$f":"'GHG emission comparison'!F13","v":32090.993999999999}]
[null,null,null,null,"Total GHG emission, including N2O","kg CO2e/d",{"$f":"'GHG emission comparison'!$F$15","v":270008.27471774642}]

{"sheet":"Aerated Lagoon + AS","index":4,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,"Aerated+Activated Sludge"]
[]
[null,null,null,null,"Input","Unit","Value"]
[null,null,null,null,"Ambient Temperature","C",20]
[null,null,null,null,"Total hydraulic residence time in pond system","Day",20]
[null,null,null,null,"Number of cells ",null,1]
[null,null,null,null,"Amount of the Wastewater ","m3/d",35965]
[null,null,null,null,"COD Concentration in Wastewater","g/m3",1507]
[null,null,null,null,"Total Nitrogen in Wastewater","g/m3",120.56]
[null,null,null,null,"COD degradation rate at up to discharge point","%",50]
[null,null,null,null,"COD degradation rate at discharge point","%",10]
[null,null,null,null,"Maximum methane formation potential","kgCH4/kgCOD",0.21]
[null,null,null,null,"Methane emission/kg generated sludge ","kgCH4/kg Sludge",0.15]
[null,null,null,null,"TN removal efficiency ","%",50]
[null,null,null,null,"Amount  of generated sludge","kg/d",15294]
[null,null,null,null,"Electricity Use","kWh/d",155917]
[]
[]
[]
[]
[]
[null,null,null,null,"Output","Unit","Value"]
[null,null,null,null,"COD Concentration at the different stages"]
[null,null,null,null,"After the wastewater treatment","g/m3",{"$f":"'Aerated Lagoon + AS (Baseline)'!$P$6","v":126.35931147800822}]
[null,null,null,null,"At up to discharge point","g/m3",{"$f":"'Aerated Lagoon + AS (Baseline)'!$P$14","v":63.179655739004112}]
[null,null,null,null,"At discharge point","g/m3",{"$f":"'Aerated Lagoon + AS (Baseline)'!$P$16","v":56.861690165103703}]
[null,null,null,null,"GHG Emissions at the different stages"]
[null,null,null,null,"Wastewater treatment","kg CO2e/d",{"$f":"'GHG emission comparison'!$H$7+('GHG emission comparison'!$H$8*21)+('GHG emission comparison'!$H$9*298)","v":101374.76497203375}]
[null,null,null,null,"At up to discharge point","kg CO2e/d",{"$f":"'GHG emission comparison'!H10","v":9419.4113433453167}]
[null,null,null,null,"At discharge point","kg CO2e/d",{"$f":"'GHG emission comparison'!H11","v":941.94113433453174}]
[null,null,null,null,"From sludge","kg CO2e/d",{"$f":"'GHG emission comparison'!H12","v":48176.1}]
[null,null,null,null,"From electricity used","kg CO2e/d",{"$f":"'GHG emission comparison'!H13","v":117561.41800000001}]
[null,null,null,null,"Total GHG emission, including N2O","kg CO2e/d",{"$f":"'GHG emission comparison'!$H$15","v":277473.63544971356}]

{"sheet":"Swimbed","index":5,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,"Swimbed"]
[]
[null,null,null,null,"Input","Unit","Value"]
[null,null,null,null,"Ambient Temperature","C",20]
[null,null,null,null,"Total hydraulic residence time in pond system","Day",20]
[null,null,null,null,"Number of cells ",null,2]
[null,null,null,null,"Amount of the Wastewater ","m3/d",35965]
[null,null,null,null,"COD Concentration in Wastewater","g/m3",1507]
[null,null,null,null,"Total Nitrogen in Wastewater","g/m3",120.56]
[null,null,null,null,"COD degradation rate at up to discharge point","%",50]
[null,null,null,null,"COD degradation rate at discharge point","%",10]
[null,null,null,null,"Maximum methane formation potential","kgCH4/kgCOD",0.21]
[null,null,null,null,"Methane emission/kg generated sludge ","kgCH4/kg Sludge",0.15]
[null,null,null,null,"TN removal efficiency ","%",50]
[null,null,null,null,"Amount  of generated sludge","kg/d",5306]
[null,null,null,null,"Electricity Use","kWh/d",64111]
[]
[]
[]
[]
[]
[null,null,null,null,"Output","Unit","Value"]
[null,null,null,null,"COD Concentration at the different stages"]
[null,null,null,null,"After the wastewater treatment","g/m3",{"$f":"'Swimbed Scenario'!$P$6","v":58.274580610330858}]
[null,null,null,null,"At up to discharge point","g/m3",{"$f":"'Swimbed Scenario'!$P$12","v":29.137290305165429}]
[null,null,null,null,"At discharge point","g/m3",{"$f":"'Swimbed Scenario'!$P$14","v":26.223561274648887}]
[null,null,null,null,"GHG Emissions at the different stages"]
[null,null,null,null,"Wastewater treatment","kg CO2e/d",{"$f":"'GHG emission comparison'!$I$7+('GHG emission comparison'!$I$8*21)+('GHG emission comparison'!$I$9*298)","v":40303.208027000321}]
[null,null,null,null,"At up to discharge point","kg CO2e/d",{"$f":"'GHG emission comparison'!I10","v":4344.0585360040932}]
[null,null,null,null,"At discharge point","kg CO2e/d",{"$f":"'GHG emission comparison'!I11","v":434.40585360040933}]
[null,null,null,null,"From sludge","kg CO2e/d",{"$f":"'GHG emission comparison'!I12","v":16713.899999999998}]
[null,null,null,null,"From electricity used","kg CO2e/d",{"$f":"'GHG emission comparison'!I13","v":48339.694000000003}]
[null,null,null,null,"Total GHG emission, including N2O","kg CO2e/d",{"$f":"'GHG emission comparison'!$I$15","v":110135.26641660482}]

{"sheet":"UASB","index":6,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,"UASB"]
[]
[null,null,null,null,"Input","Unit","Value"]
[null,null,null,null,"Ambient Temperature","C",{"$f":"'Aerated Lagoon + AS'!G6","v":20}]
[null,null,null,null,"Total hydraulic residence time in pond system","Day",{"$f":"'Aerated Lagoon + AS'!G7","v":20}]
[null,null,null,null,"Number of cells ",null,{"$f":"'Aerated Lagoon + AS'!G8","v":1}]
[null,null,null,null,"Amount of the Wastewater ","m3/d",35965]
[null,null,null,null,"COD Concentration in Wastewater","g/m3",1507]
[null,null,null,null,"Total Nitrogen in Wastewater","g/m3",120.56]
[null,null,null,null,"COD removal efficiency at first step","%",80]
[null,null,null,null,"COD degradation rate at up to discharge point","%",50]
[null,null,null,null,"COD degradation rate at discharge point","%",10]
[null,null,null,null,"Maximum methane formation potential","kgCH4/kgCOD",0.21]
[null,null,null,null,"Methane emission/kg generated sludge ","kgCH4/kg Sludge",0.15]
[null,null,null,null,"TN removal efficiency ","%",50]
[null,null,null,null,"Amount  of generated sludge","kg/d",4120]
[null,null,null,null,"Electricity Use","kWh/d",48612]
[]
[]
[]
[]
[]
[null,null,null,null,"Output","Unit","Value"]
[null,null,null,null,"COD Concentration at the different stages"]
[null,null,null,null,"After the wastewater treatment","g/m3",{"$f":"'UASB + AS'!$O$6","v":25.271862295601693}]
[null,null,null,null,"At up to discharge point","g/m3",{"$f":"'UASB + AS'!$O$14","v":12.635931147800845}]
[null,null,null,null,"At discharge point","g/m3",{"$f":"'UASB + AS'!$O$16","v":11.37233803302076}]
[null,null,null,null,"GHG Emissions at the different stages"]
[null,null,null,null,"Wastewater treatment","kg CO2e/d",{"$f":"'GHG emission comparison'!$K$7+('GHG emission comparison'!$K$8*21)+('GHG emission comparison'!$K$9*298)","v":58993.661926292487}]
[null,null,null,null,"At up to discharge point","kg CO2e/d",{"$f":"'GHG emission comparison'!K10","v":1883.8822686690673}]
[null,null,null,null,"At discharge point","kg CO2e/d",{"$f":"'GHG emission comparison'!K11","v":188.38822686690671}]
[null,null,null,null,"From sludge","kg CO2e/d",{"$f":"'GHG emission comparison'!K12","v":12978}]
[null,null,null,null,"From electricity used","kg CO2e/d",{"$f":"'GHG emission comparison'!K13","v":36653.447999999997}]
[null,null,null,null,"Reduction from the biogas utilization","kg CO2e/d",{"$f":"-'GHG emission comparison'!K16","v":-13124}]
[null,null,null,null,"Total GHG emission, including N2O","kg CO2e/d",{"$f":"'GHG emission comparison'!$K$18","v":97573.380421828449}]

{"sheet":"UASBSWIMBED","index":7,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,"UASB+Swimbed"]
[]
[null,null,null,null,"Input","Unit","Value"]
[null,null,null,null,"Ambient Temperature","C",{"$f":"'Aerated Lagoon + AS'!G6","v":20}]
[null,null,null,null,"Total hydraulic residence time in pond system","Day",{"$f":"'Aerated Lagoon + AS'!G7","v":20}]
[null,null,null,null,"Number of cells ",null,2]
[null,null,null,null,"Amount of the Wastewater ","m3/d",35965]
[null,null,null,null,"COD Concentration in Wastewater","g/m3",1507]
[null,null,null,null,"Total Nitrogen in Wastewater","g/m3",120.56]
[null,null,null,null,"COD removal efficiency at first step","%",80]
[null,null,null,null,"COD degradation rate at up to discharge point","%",50]
[null,null,null,null,"COD degradation rate at discharge point","%",10]
[null,null,null,null,"Maximum methane formation potential","kgCH4/kgCOD",0.21]
[null,null,null,null,"Methane emission/kg generated sludge ","kgCH4/kg Sludge",0.15]
[null,null,null,null,"TN removal efficiency ","%",50]
[null,null,null,null,"Amount  of generated sludge","kg/d",2168]
[null,null,null,null,"Electricity Use","kWh/d",33651]
[]
[]
[]
[]
[]
[null,null,null,null,"Output","Unit","Value"]
[null,null,null,null,"COD Concentration at the different stages"]
[null,null,null,null,"After the wastewater treatment","g/m3",{"$f":"'UASB + SWIMBED'!$O$6","v":14.568645152582716}]
[null,null,null,null,"At up to discharge point","g/m3",{"$f":"'UASB + SWIMBED'!$O$12","v":7.2843225762913582}]
[null,null,null,null,"At discharge point","g/m3",{"$f":"'UASB + SWIMBED'!$O$14","v":6.5558903186622226}]
[null,null,null,null,"GHG Emissions at the different stages"]
[null,null,null,null,"Wastewater treatment","kg CO2e/d",{"$f":"'GHG emission comparison'!$L$7+('GHG emission comparison'!$L$8*21)+('GHG emission comparison'!$L$9*298)","v":46728.919259955452}]
[null,null,null,null,"At up to discharge point","kg CO2e/d",{"$f":"'GHG emission comparison'!L10","v":1086.0146340010233}]
[null,null,null,null,"At discharge point","kg CO2e/d",{"$f":"'GHG emission comparison'!L11","v":108.60146340010233}]
[null,null,null,null,"From sludge","kg CO2e/d",{"$f":"'GHG emission comparison'!L12","v":6829.2}]
[null,null,null,null,"From electricity used","kg CO2e/d",{"$f":"'GHG emission comparison'!L13","v":25372.853999999999}]
[null,null,null,null,"Reduction from the biogas utilization","kg CO2e/d",{"$f":"-'GHG emission comparison'!L16","v":-13124}]
[null,null,null,null,"Total GHG emission, including N2O","kg CO2e/d",{"$f":"'GHG emission comparison'!$L$18","v":67001.58935735657}]

{"sheet":"Comparsion","index":8,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[10,4,10,9],[5,4,5,9]]}
[]
[]
[]
[]
[null,null,null,null,"Interventions","Anaerobic","Aerated Lagoon + AS","Swimbed","UASB","UASB+Swimbed"]
[null,null,null,null,"COD Concentration at the different stages"]
[null,null,null,null,"After the wastewater treatment (g/m3)",{"$f":"Anaerobic!G23","v":753.5},{"$f":"'Aerated Lagoon + AS'!G26","v":126.35931147800822},{"$f":"Swimbed!G26","v":58.274580610330858},{"$f":"UASB!G27","v":25.271862295601693},{"$f":"UASBSWIMBED!G27","v":14.568645152582716}]
[null,null,null,null,"At up to discharge point  (g/m3)",{"$f":"Anaerobic!G24","v":376.75},{"$f":"'Aerated Lagoon + AS'!G27","v":63.179655739004112},{"$f":"Swimbed!G27","v":29.137290305165429},{"$f":"UASB!G28","v":12.635931147800845},{"$f":"UASBSWIMBED!G28","v":7.2843225762913582}]
[null,null,null,null,"At discharge point  (g/m3)",{"$f":"Anaerobic!G25","v":339.07499999999999},{"$f":"'Aerated Lagoon + AS'!G28","v":56.861690165103703},{"$f":"Swimbed!G28","v":26.223561274648887},{"$f":"UASB!G29","v":11.37233803302076},{"$f":"UASBSWIMBED!G29","v":6.5558903186622226}]
[null,null,null,null,"COD removed for the System  (g/m3)",{"$f":"(Anaerobic!$G$7-F9)","v":1167.925},{"$f":"'Aerated Lagoon + AS'!$G$10-G9","v":1450.1383098348963},{"$f":"Swimbed!$G$10-H9","v":1480.776438725351},{"$f":"UASB!$G$10-I9","v":1495.6276619669793},{"$f":"UASBSWIMBED!$G$10-J9","v":1500.4441096813377}]
[null,null,null,null,"GHG Emissions at the different stages"]
[null,null,null,null,"Wastewater treatment (kg CO2 e/day)",{"$f":"'GHG emission comparison'!$F$7+('GHG emission comparison'!$F$8*21)+('GHG emission comparison'!$F$9*298)","v":159417.04300657145},{"$f":"'GHG emission comparison'!$H$7+('GHG emission comparison'!$H$8*21)+('GHG emission comparison'!$H$9*298)","v":101374.76497203375},{"$f":"'GHG emission comparison'!$I$7+('GHG emission comparison'!$I$8*21)+('GHG emission comparison'!$I$9*298)","v":40303.208027000321},{"$f":"'GHG emission comparison'!$K$7+('GHG emission comparison'!$K$8*21)+('GHG emission comparison'!$K$9*298)","v":58993.661926292487},{"$f":"'GHG emission comparison'!$L$7+('GHG emission comparison'!$L$8*21)+('GHG emission comparison'!$L$9*298)","v":46728.919259955452}]
[null,null,null,null,"At up to discharge point  (kg CO2 e/day)",{"$f":"'GHG emission comparison'!F10","v":56169.397919249997},{"$f":"'GHG emission comparison'!H10","v":9419.4113433453167},{"$f":"'GHG emission comparison'!I10","v":4344.0585360040932},{"$f":"'GHG emission comparison'!K10","v":1883.8822686690673},{"$f":"'GHG emission comparison'!L10","v":1086.0146340010233}]
[null,null,null,null,"At discharge point  (kg CO2 e/day)",{"$f":"'GHG emission comparison'!F11","v":5616.9397919249986},{"$f":"'GHG emission comparison'!H11","v":941.94113433453174},{"$f":"'GHG emission comparison'!I11","v":434.40585360040933},{"$f":"'GHG emission comparison'!K11","v":188.38822686690671},{"$f":"'GHG emission comparison'!L11","v":108.60146340010233}]
[null,null,null,null,"From sludge  (kg CO2 e/day)",{"$f":"'GHG emission comparison'!F12","v":16713.899999999998},{"$f":"'GHG emission comparison'!H12","v":48176.1},{"$f":"'GHG emission comparison'!I12","v":16713.899999999998},{"$f":"'GHG emission comparison'!K12","v":12978},{"$f":"'GHG emission comparison'!L12","v":6829.2}]
[null,null,null,null,"From electricity used  (kg CO2 e/day)",{"$f":"'GHG emission comparison'!F13","v":32090.993999999999},{"$f":"'GHG emission comparison'!H13","v":117561.41800000001},{"$f":"'GHG emission comparison'!I13","v":48339.694000000003},{"$f":"'GHG emission comparison'!K13","v":36653.447999999997},{"$f":"'GHG emission comparison'!L13","v":25372.853999999999}]
[null,null,null,null,"Reduction from the biogas utilization  (kg CO2 e/day)",{"$f":"'GHG emission comparison'!$F$16","v":0},{"$f":"'GHG emission comparison'!$H$16","v":0},{"$f":"'GHG emission comparison'!$H$16","v":0},{"$f":"'GHG emission comparison'!$K$16","v":13124},{"$f":"'GHG emission comparison'!$K$16","v":13124}]
[null,null,null,null,"Total GHG emission, excluding N2O  (kg CO2 e/day)",{"$f":"'GHG emission comparison'!F17","v":259855.97998117498},{"$f":"'GHG emission comparison'!H17","v":262245.1933448565},{"$f":"'GHG emission comparison'!I17","v":94906.824311747681},{"$f":"'GHG emission comparison'!K17","v":82344.938316971311},{"$f":"'GHG emission comparison'!L17","v":51773.147252499431}]
[null,null,null,null,"Total GHG emission, including N2O  (kg CO2 e/day)",{"$f":"'GHG emission comparison'!F18","v":270008.27471774642},{"$f":"'GHG emission comparison'!H18","v":277473.63544971356},{"$f":"'GHG emission comparison'!I18","v":110135.26641660482},{"$f":"'GHG emission comparison'!K18","v":97573.380421828449},{"$f":"'GHG emission comparison'!L18","v":67001.58935735657}]

{"sheet":"Co-benefits","index":9,"n_rows":10,"n_cols":21,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,5,2,10]]}
[]
[]
[null,null,null,null,null,"GHG emissions reduction and Co-benefits"]
[]
[null,null,null,null,null,"Baseline","Swimbed","UASB ","UASB + Swimed"]
[null,null,null,null,"GHG Emissions Reduction (%)*",{"$f":"'GHG emission comparison'!$H$20","v":-2.7648636841856309},59.2,63.9,75.2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P6:T6)","v":0}]
[null,null,null,null,"COD Removal (%)",{"$f":"'COD comparison (using MOE formt'!F13*100","v":83.230350168811114},{"$f":"'COD comparison (using MOE formt'!G13*100","v":92.266147231542035},{"$f":"'COD comparison (using MOE formt'!H13*100","v":96.646070033762214},{"$f":"'COD comparison (using MOE formt'!I13*100","v":98.066536807885498},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P7:T7)","v":0}]
[null,null,null,null,"GHG Emissions Reduction (kt/y)*",{"$f":"-'GHG emission comparison'!M29","v":-2724.8566671679982},{"$f":"-'GHG emission comparison'!N29","v":58353.648029916687},{"$f":"-'GHG emission comparison'!O29","v":62938.736418010056},{"$f":"-'GHG emission comparison'!P29","v":74097.440156542289},null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"COD Removal (t/y)",{"$f":"-'COD comparison (using MOE formt'!F12","v":3704.6776161973967},{"$f":"-'COD comparison (using MOE formt'!G12","v":4106.8712277213981},{"$f":"-'COD comparison (using MOE formt'!H12","v":4301.8265767394796},{"$f":"-'COD comparison (using MOE formt'!I12","v":4365.0531695865993},null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"* Including N2O",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P10:T10)","v":0}]

{"sheet":"COD comparison (using MOE formt","index":10,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,2,0],[0,1,0,4],[0,6,0,8],[1,1,2,1],[1,2,2,2]]}
["Sources ","BAU ",null,null,null,"Baseline","Co-benefits"]
[null,"Item","Unit","Without any treatment","Anaerobic","Aerated + Activated Sludge","Swimbed","UASB + AS","UASB+Swimbed"]
[null,null,null,"Value","Value","Value","Value","Value","Value"]
["Wastewater treatment ","COD after","(mg/l)",{"$f":"Anaerobic!$G$7","v":1507},{"$f":"Comparsion!F9","v":339.07499999999999},{"$f":"Comparsion!G9","v":56.861690165103703},{"$f":"Comparsion!H9","v":26.223561274648887},{"$f":"Comparsion!I9","v":11.37233803302076},{"$f":"Comparsion!J9","v":6.5558903186622226}]
[]
[]
[null,null,"m3/d",{"$f":"Anaerobic!$G$6","v":35965},{"$f":"Anaerobic!$G$6","v":35965},{"$f":"'Aerated Lagoon + AS'!$G$9","v":35965},{"$f":"Swimbed!$G$9","v":35965},{"$f":"UASB!$G$9","v":35965},{"$f":"UASBSWIMBED!$G$9","v":35965}]
[]
[null,null,"t/d",{"$f":"D4*D7/1000000","v":54.199255000000001},{"$f":"E4*E7/1000000","v":12.194832375000001},2.0450306867879546,0.94313038124274717,0.40900613735759167,0.23578259531068682]
[null,null,"t/y",{"$f":"D9*365","v":19782.728074999999},{"$f":"E9*365","v":4451.1138168750003},746.43620067760344,344.24258915360269,149.28724013552096,86.060647288400688]
[]
[null,null,null,null,null,{"$f":"F10-E10","v":-3704.6776161973967},{"$f":"G10-E10","v":-4106.8712277213981},{"$f":"H10-E10","v":-4301.8265767394796},{"$f":"I10-E10","v":-4365.0531695865993}]
[null,null,null,null,null,{"$f":"(E10-F10)/E10","v":0.83230350168811118},{"$f":"(E10-G10)/E10","v":0.92266147231542039},{"$f":"(E10-H10)/E10","v":0.96646070033762221},{"$f":"(E10-I10)/E10","v":0.98066536807885496}]
[]
[]
[null,null,null,null,{"$f":"D4-E4","v":1167.925},{"$f":"D4-F4","v":1450.1383098348963},{"$f":"D4-G4","v":1480.776438725351},{"$f":"D4-H4","v":1495.6276619669793},{"$f":"D4-I4","v":1500.4441096813377}]

{"sheet":"GHG emission comparison","index":11,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,2,0,11],[2,2,5,2],[2,3,2,5],[2,8,2,11],[2,6,2,7],[3,6,3,7],[3,8,4,8],[3,9,3,10],[3,11,4,11],[6,2,8,2],[13,2,13,3],[3,3,5,3],[3,4,5,4],[3,5,4,5],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,19,2]]}
[null,null,"Reduction in GHG from 5 Scenario"]
[]
[null,null,"Scenarios / Steps","BAU ",null,null,"Baseline",null,"Co-benefits"]
[null,null,null,"Item","Unit","Anaerobic","Aerated + Activated Sludge",null,"Swimbed","UASB + AS",null,"UASB+Swimbed"]
[null,null,null,null,null,null,"Well managed system","Anoxic system",null,"Well managed system","Anoxic system"]
[null,null,null,null,null,"Value","Value","Value","Value","Value","Value","Value"]
[null,null,"Waste water treatment","CO2","kg/day",{"$f":"'Anaerobic lagoon (BAU)'!R8","v":16097.178735},{"$f":"'Aerated Lagoon + AS (Baseline)'!R9","v":23896.34476204621},{"$f":"'Aerated Lagoon + AS (Baseline)'!R10","v":30228.876123988462},{"$f":"'Swimbed Scenario'!R9","v":25074.765922143175},{"$f":"'UASB + AS'!Q9","v":7640.9896164092443},{"$f":"'UASB + AS'!Q10","v":8907.4958887976936},{"$f":"'UASB + SWIMBED'!Q9","v":7826.2425710982961}]
[null,null,null,"CH4","kg/day",{"$f":"'Anaerobic lagoon (BAU)'!R9","v":6341.3128350000006},{"$f":"'Aerated Lagoon + AS (Baseline)'!R11","v":0},{"$f":"'Aerated Lagoon + AS (Baseline)'!R12","v":2662.735559199436},{"$f":"'Swimbed Scenario'!R10","v":0},{"$f":"'UASB + AS'!Q11","v":1127.3445040000004},{"$f":"'UASB + AS'!Q12","v":1659.8916158398877},{"$f":"'UASB + SWIMBED'!Q10","v":1127.3445040000004}]
[null,null,null,"NO2","kg/day",{"$f":"'Anaerobic lagoon (BAU)'!R10","v":34.068103142857147},{"$f":"'Aerated Lagoon + AS (Baseline)'!R13","v":51.102154714285717},{"$f":"'Aerated Lagoon + AS (Baseline)'!R13","v":51.102154714285717},{"$f":"'Swimbed Scenario'!R11","v":51.102154714285717},{"$f":"'UASB + AS'!Q13","v":51.102154714285717},{"$f":"'UASB + AS'!Q13","v":51.102154714285717},{"$f":"'UASB + SWIMBED'!Q11","v":51.102154714285717}]
[null,null,"At up to disharge point","GHG emission","kg CO2 e/day",{"$f":"'Anaerobic lagoon (BAU)'!R12","v":56169.397919249997},{"$f":"'Aerated Lagoon + AS (Baseline)'!R15","v":9419.4113433453167},{"$f":"'Aerated Lagoon + AS (Baseline)'!R15","v":9419.4113433453167},{"$f":"'Swimbed Scenario'!R13","v":4344.0585360040932},{"$f":"'UASB + AS'!Q15","v":1883.8822686690673},{"$f":"'UASB + AS'!Q15","v":1883.8822686690673},{"$f":"'UASB + SWIMBED'!Q13","v":1086.0146340010233}]
[null,null,"At discharge point","GHG emission","kg CO2 e/day",{"$f":"'Anaerobic lagoon (BAU)'!R14","v":5616.9397919249986},{"$f":"'Aerated Lagoon + AS (Baseline)'!R17","v":941.94113433453174},{"$f":"'Aerated Lagoon + AS (Baseline)'!R17","v":941.94113433453174},{"$f":"'Swimbed Scenario'!R15","v":434.40585360040933},{"$f":"'UASB + AS'!Q17","v":188.38822686690671},{"$f":"'UASB + AS'!Q17","v":188.38822686690671},{"$f":"'UASB + SWIMBED'!Q15","v":108.60146340010233}]
[null,null,"From sludge","GHG emission","kg CO2 e/day",{"$f":"'Anaerobic lagoon (BAU)'!R15","v":16713.899999999998},{"$f":"'Aerated Lagoon + AS (Baseline)'!R18","v":48176.1},{"$f":"'Aerated Lagoon + AS (Baseline)'!R18","v":48176.1},{"$f":"'Swimbed Scenario'!R16","v":16713.899999999998},{"$f":"'UASB + AS'!Q18","v":12978},{"$f":"'UASB + AS'!Q18","v":12978},{"$f":"'UASB + SWIMBED'!Q16","v":6829.2}]
[null,null,"From electricity used","GHG emission","kg CO2 e/day",{"$f":"'Anaerobic lagoon (BAU)'!R17","v":32090.993999999999},{"$f":"'Aerated Lagoon + AS (Baseline)'!R20","v":117561.41800000001},{"$f":"'Aerated Lagoon + AS (Baseline)'!R20","v":117561.41800000001},{"$f":"'Swimbed Scenario'!R18","v":48339.694000000003},{"$f":"'UASB + AS'!Q20","v":36653.447999999997},{"$f":"'UASB + AS'!Q20","v":36653.447999999997},{"$f":"'UASB + SWIMBED'!Q18","v":25372.853999999999}]
[null,null,"Total GHG (CO2 and CH4)",null,"kg CO2 e/day",{"$f":"F7+(F8*21)+F10+F11+F12+F13","v":259855.97998117498},{"$f":"G7+(G8*21)+G10+G11+G12+G13","v":199995.21523972607},262245.1933448565,94906.824311747681,{"$f":"J7+(J8*21)+J10+J11+J12+J13","v":83018.942695945225},{"$f":"K7+(K8*21)+K10+K11+K12+K13","v":95468.938316971311},{"$f":"L7+(L8*21)+L10+L11+L12+L13","v":64897.147252499431}]
[null,null,"Total GHG (CO2 , CH4 and NO2)",null,"kg CO2 e/day",{"$f":"F7+(F8*21)+(F9*298)+F10+F11+F12+F13","v":270008.27471774642},{"$f":"G7+(G8*21)+(G9*298)+G10+G11+G12+G13","v":215223.65734458322},277473.63544971356,{"$f":"I7+(I8*21)+(I9*298)+I10+I11+I12+I13","v":110135.26641660482},98247.384800802363,110697.38042182845,{"$f":"L7+(L8*21)+(L9*298)+L10+L11+L12+L13","v":80125.58935735657}]
[null,null,"Methane reduction from biogas utilization",null,"kg CO2 e/day",0,0,0,0,13124,13124,13124]
[null,null,"Total GHG emission after methane reduction (CO2 and CH4)",null,"kg CO2 e/day",{"$f":"F14-F16","v":259855.97998117498},{"$f":"G14-G16","v":199995.21523972607},262245.1933448565,94906.824311747681,69894.942695945225,82344.938316971311,51773.147252499431]
[null,null,"Total GHG emission after methane reduction (CO2 , CH4 and NO2)",null,"kg CO2 e/day",{"$f":"F15-F16","v":270008.27471774642},{"$f":"G15-G16","v":215223.65734458322},277473.63544971356,110135.26641660482,85123.384800802363,97573.380421828449,67001.58935735657]
[null,null,"Percentage reduction of GHG","CO2 and CH4","%",0,{"$f":"($F$17-G17)/$F$17*100","v":23.03613130080188},{"$f":"($F$17-H17)/$F$17*100","v":-0.91943751452423628},63.477144409521337,73.102430545947541,68.311316782882315,80.076214810892537]
[null,null,null,"CO2 , CH4 and NO2","%",0,{"$f":"($F$18-G18)/$F$18*100","v":20.289977198081203},{"$f":"($F$18-H18)/$F$18*100","v":-2.7648636841856309},59.2104106691786,68.47378663124816,63.862818454794791,75.185357031225507]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"$F$18","v":270008.27471774642},{"$f":"$H$18","v":277473.63544971356},{"$f":"$I$18","v":110135.26641660482},{"$f":"$K$18","v":97573.380421828449},{"$f":"$L$18","v":67001.58935735657}]
[null,null,null,null,null,null,null,"Scenario","Percentage reduction of GHG",null,null,{"$f":"L25*365/1000000","v":98.553020271977445},{"$f":"M25*365/1000000","v":101.27787693914544},40.199372242060761,35.614283853967386,24.455580115435151]
[null,null,null,null,null,null,null,null,"CO2 and CH4","CO2 , CH4 and NO2"]
[null,null,null,null,null,null,null,"BAU",0,0,null,null,{"$f":"M26-L26","v":2.7248566671679981},{"$f":"N26-L26","v":-58.353648029916684},{"$f":"O26-L26","v":-62.938736418010059},{"$f":"P26-L26","v":-74.097440156542291}]
[null,null,null,null,null,null,null,"Baseline (well treated)",{"$f":"G19","v":23.03613130080188},{"$f":"G20","v":20.289977198081203},null,null,{"$f":"M28*1000","v":2724.8566671679982},{"$f":"N28*1000","v":-58353.648029916687},-62938.736418010056,-74097.440156542289]
[null,null,null,null,null,null,null,"Baseline (Overloaded)",{"$f":"H19","v":-0.91943751452423628},{"$f":"H20","v":-2.7648636841856309}]
[null,null,null,null,null,null,null,"Cobenefit 1",{"$f":"I19","v":63.477144409521337},{"$f":"I20","v":59.2104106691786}]
[null,null,null,null,null,null,null,"Cobenefit 2 (well managed)",{"$f":"J19","v":73.102430545947541},{"$f":"J20","v":68.47378663124816}]
[null,null,null,null,null,null,null,"Cobenefit 2 (overloaded)",{"$f":"K19","v":68.311316782882315},{"$f":"K20","v":63.862818454794791}]
[null,null,null,null,null,null,null,"Cobenefit 3",{"$f":"L19","v":80.076214810892537},{"$f":"L20","v":75.185357031225507}]

{"sheet":"Swimbed Scenario","index":12,"n_rows":63,"n_cols":19,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,1,1,21],[3,1,3,4],[5,1,11,1],[3,6,3,8],[3,12,3,20],[4,18,4,20],[5,12,10,12],[5,18,10,20],[13,12,14,12],[11,18,17,20],[16,12,17,12],[18,12,22,12],[60,1,62,1],[29,1,30,4],[31,1,31,4],[33,2,33,4],[57,1,59,1],[34,1,43,1],[45,1,51,1],[53,1,56,1]]}
[null,"Swim-Bed"]
[]
[]
[null,"Input ",null,null,null,null,"Default Value",null,null,null,null,null,"Output"]
[null,"Category","Item","Unit","Value",null,"Item","Unit","Value","Source","Reference",null,"Category","Item","Unit","Value","Unit","Value"]
[null,"Waste water treatment","Amount of waste water","(m3/day)",{"$f":"Swimbed!$G$9","v":35965},null,"Oxygen Demand (OD) removal efficiency at first step","%",{"$f":"E41*100","v":95.166342019713767},"calculation by this model ",null,null,"Waste water treatment","COD after","g/m3",{"$f":"E48","v":58.274580610330858},"kg/day",{"$f":"P6*$E$6/1000","v":2095.8452916505494},"this calculation based on EPA equation"]
[null,null,"COD concentration of raw water","g/m3",{"$f":"Swimbed!$G$10","v":1507},null,"COD/BOD",null,1.9,null,null,null,null,"COD removed","g/m3",{"$f":"E54","v":1448.7254193896692},"kg/day",{"$f":"P7*$E$6/1000","v":52103.409708349449}]
[null,null,"Total Nitrogen (TN)","mg/L or g/m3",{"$f":"Swimbed!$G$11","v":120.56},null,"Amount gas generated/kg COD removal (anaerobic process)","m3/kg COD removal",0.15,"MOJ",null,null,null,"COD removal","%",{"$f":"P7/E7*100","v":96.133073615771011},"%",{"$f":"P7/E7*100","v":96.133073615771011}]
[null,null,"Temperature","°C",{"$f":"Swimbed!$G$6","v":20},null,"Conversion factor","kg CH4/m3",0.71399999999999997,"MOJ",null,null,null,"CO2 emission","ton/h",{"$f":"E43+E51","v":1.0447819134226322},"kg/day",{"$f":"P9*1000*24","v":25074.765922143175}]
[null,null,"Total hydraulic residence time in pond system (d)","days",{"$f":"Swimbed!$G$7","v":20},null,"CH4 Global Warming Potential","kg CO2 e/kg CH4",21,"IPCC",null,null,null,"CH4 emission","ton/h",{"$f":"E44+E52","v":0},"kg/day",{"$f":"P10*1000*24","v":0}]
[null,null,"Number of cells ","cells",{"$f":"Swimbed!$G$8","v":2},null,"N2O ","kg CO2 e/kg N2O",298,"IPCC",null,null,null,"N2O emission","ton/h",{"$f":"E45+E53","v":2.1292564464285716E-3},"kg/day",{"$f":"P11*1000*24","v":51.102154714285717}]
[null,null,"BOD rate constant@T/day (KT)","/d ",{"$f":"I28*(I29)^(E9-20)","v":0.23},null,"COD degradation rate at up to discharge point","%",{"$f":"Swimbed!$G$12","v":50},"MOJ",null,null,"At up to discharge point","COD after","g/m3",{"$f":"E59","v":29.137290305165429},"kg/day",{"$f":"P12*$E$6/1000","v":1047.9226458252747},"this calculation based on IGES DATA "]
[null,"COD removal from sludge","Generated amount of sludge ","kgDS/day",{"$f":"Swimbed!$G$17","v":5306},null,"COD degradation rate at discharge point","%",{"$f":"Swimbed!$G$13","v":10},"MOJ",null,null,null,"GHG Emission","kg/day",{"$f":"E58*E6/1000*I14*I15*I10","v":4344.0585360040932},"kg/day",{"$f":"P13","v":4344.0585360040932}]
[null,"Electricity use","Total Electricity consumption ","kWh/day",{"$f":"Swimbed!$G$18","v":64111},null,"Maximum methane formation potential","kgCH4/kgCOD",{"$f":"Swimbed!$G$14","v":0.21},"MOJ",null,null,"At dischagre point","COD after","g/m3",{"$f":"E62","v":26.223561274648887},"kg/day",{"$f":"P14*$E$6/1000","v":943.13038124274715}]
[null,null,null,null,null,null,"Model correction coeficient",null,0.94,"MOJ",null,null,null,"GHG Emission","kg/day",{"$f":"E61*E6/1000*I14*I15*I10","v":434.40585360040933},"kg/day",{"$f":"P15","v":434.40585360040933}]
[null,null,null,null,null,null,"Methane emission/kg generated sludge ","kgCH4/kgDS",{"$f":"Swimbed!$G$15","v":0.15},"MOJ",null,null,"From Sludge","GHG Emission","kg CO2e/day",{"$f":"E13*I16*I10","v":16713.899999999998},"kg/day",{"$f":"P16","v":16713.899999999998}]
[null,null,null,null,null,null,"Electricity emission factor","kgCO2/kWh",0.754,"ADB, 2017 (also used by MOJ)",null,null,"By Electricity Used","CO2 emission","kg CO2e/day",{"$f":"E14*I17","v":48339.694000000003},"kg/day",{"$f":"P17","v":48339.694000000003}]
[null,null,null,null,null,null,"CF CO2","g CO2/g Oxygen demand",1.375,"EPA",null,null,null,"GHG Emission","kg CO2e/day",{"$f":"P17","v":48339.694000000003},"kg/day",{"$f":"P18","v":48339.694000000003}]
[null,null,null,null,null,null,"CF CH4","g CH4/g Oxygen demand",0.5,"EPA",null,null,"GHG emission","From total CO2 emisson ","kg CO2e/day",{"$f":"R9+R17","v":73414.459922143171}]
[null,null,null,null,null,null,"MCF ww for aerobic lagoon well managed",null,0,"IPCC",null,null,null,"From total CH4 emisson ","kg CO2e/day",{"$f":"(R10*21)+R13+R15+R16","v":21492.3643896045}]
[null,null,null,null,null,null,"MCF ww for aerobic lagoon overloaded/anoxic",null,0.3,"IPCC",null,null,null,"From total N2O emisson","kg CO2e/day",{"$f":"R11*I11","v":15228.442104857144}]
[null,null,null,null,null,null,"λ  for aerobic lagoon well managed",null,0.65,"Choubert et al (2009), Muller et al (2003), Munz (2008)",null,null,null," from CO2 and CH4 total emission","kg CO2e/day",{"$f":"P19+P20","v":94906.824311747667}]
[null,null,null,null,null,null,"λ  for aerobic lagoon overloaded",null,0.45,"Choubert et al (2009), Muller et al (2003), Munz (2008), Ammary (2004)",null,null,null,"from CO2  CH4 and NO2 total emission","kg CO2e/day",{"$f":"P19+P20+P21","v":110135.26641660481}]
[null,null,null,null,null,null,"BG CH4",null,0.65,"EPA"]
[null,null,null,null,null,null,"NO2 Emission factor","g N2O/g TKN",5.0000000000000001E-3,"Chandran 2010 and IPCC"]
[null,null,null,null,null,null,"Oxygen Demand (OD) removal efficiency at clariffier settle",null,0.2]
[null,null,null,null,null,null,"k (first order reaction rate constant (assumed to be constant in all cells)"," day-1 at 20° C ",0.27600000000000002,"EPA"]
[null,null,null,null,null,null,"K20 (BOD rate constant@20°C)","/day",0.23,"EPA"]
[null,null,null,null,null,null,"θ (Temperature Coefissient )",null,1.056,"EPA"]
[null,"Calculation ",null,null,null,null,"TN removal  eff in  Aeration tank",null,{"$f":"Swimbed!$G$16/100","v":0.5}]
[]
[null,"Proposed Calculation"]
[null,"Category","Item","Unit","Value"]
[null,"Waste water treatment"]
[null,"1st step : Swimbed Reactor","Waste water influent flow rate (Qww)","m3/h",{"$f":"E6/24","v":1498.5416666666667}]
[null,null,"BOD5 influent","g/m3",{"$f":"E7/I7","v":793.1578947368422}]
[null,null,"COD removed","g/m3",{"$f":"E7-E38","v":1434.1567742370864}]
[null,null,"COD Effluent","g/m3",{"$f":"E39*I7","v":72.843225762913576}]
[null,null,"BOD5 effluent","g/m3",{"$f":"(E36)*(1-EXP(-E12*5))*(1/(1+(I27*E10)/E11)^E11)","v":38.33853987521767}]
[null,null,"BOD removed","g/m3",{"$f":"E36-E39","v":754.81935486162456}]
[null,null,"COD removal efficiency",null,{"$f":"E37/E7","v":0.95166342019713768}]
[null,null,"TN after","g/m3",{"$f":"E8-(E8*I30)","v":60.28}]
[null,null,"CO2 emission","ton/h",{"$f":"(10^(-6))*E35*E7*E41*$I$18*((1-I20*$I$24)*(1-I22))","v":1.0342753973121444}]
[null,null,"CH4 emission","ton/h",{"$f":"(10^-6)*E35*E7*E41*I19*(I20*I24)*(1-I22)","v":0}]
[null,null,"N2O emission","ton/h",{"$f":"E35*E8*I25*44/28*10^-6","v":1.4195042976190477E-3}]
[null,"2nd step : Clariffier Settler","Waste water influent flow rate (Qww)","m3/h",{"$f":"E35","v":1498.5416666666667}]
[null,null,"COD removed","g/m3",{"$f":"E38*I26","v":14.568645152582716}]
[null,null,"COD Effluent","g/m3",{"$f":"E38-E47","v":58.274580610330858}]
[null,null,"BOD5 removed","g/m3",{"$f":"E39*I26","v":7.667707975043534}]
[null,null,"BOD5 effluent","g/m3",{"$f":"E39-E49","v":30.670831900174136}]
[null,null,"CO2 emission","ton/h",{"$f":"(10^-6)*E46*E38*I26*I18*((1-I20*I24)*(1-I22))","v":1.0506516110487781E-2}]
[null,null,"CH4 emission","ton/h",{"$f":"(10^-6)*E46*E38*I26*I19*(I20*I24)*(1-I22)","v":0}]
[null,null,"N2O emission","ton/h",{"$f":"E46*E42*I25*44/28*10^-6","v":7.0975214880952386E-4}]
[null,null,"Total COD removal","g/m3",{"$f":"E37+E47","v":1448.7254193896692}]
[null,null,"Total BOD removal","g/m4",{"$f":"E40+E49","v":762.48706283666809}]
[null,null,"COD removal efficiency in baseline scenario",null,{"$f":"E54/E7","v":0.96133073615771014}]
[null,null,"BOD removal efficiency in baseline scenario",null,{"$f":"E55/E36","v":0.96133073615771014}]
[null,"At up to discharge point","COD removed","g/m3",{"$f":"E48*(I12/100)","v":29.137290305165429}]
[null,null,"COD Effluent","g/m3",{"$f":"E48-E58","v":29.137290305165429}]
[null,null,"BOD5 effluent","g/m3",{"$f":"E59/I7","v":15.335415950087068}]
[null,"At discharge point","COD removed","g/m3",{"$f":"E59*I13/100","v":2.9137290305165431}]
[null,null,"COD Effluent","g/m3",{"$f":"E59-E61","v":26.223561274648887}]
[null,null,"BOD5 effluent","g/m3",{"$f":"E62/I7","v":13.801874355078363}]

{"sheet":"UASB + AS","index":13,"n_rows":65,"n_cols":21,"rows_kept":65,"cut":false,"hidden":false,"merged":[[13,17,19,19],[13,11,14,11],[18,11,19,11],[20,11,28,11],[0,1,1,20],[9,20,10,20],[5,1,11,1],[5,11,12,11],[5,17,12,19]]}
[null,"Upflow Anaerobic Sludge Blanket (UASB) + Activated Sludge (AS)"]
[]
[]
[null,"Input ",null,null,null,null,"Default Value",null,null,null,null,"Output"]
[null,"Category","Item","Unit","Value",null,"Item","Unit","Value","Source",null,"Category","Item","Unit","Value","Unit","Value"]
[null,"Waste water treatment","Amount of waste water","(m3/day)",{"$f":"UASB!$G$9","v":35965},null,"Oxygen Demand (OD) removal efficiency at first step (UASB)","%",{"$f":"UASB!$G$12","v":80},"MOJ",null,"Waste water treatment","COD after","g/m3",{"$f":"E48","v":25.271862295601693},"kg/day",{"$f":"O6*E6/1000","v":908.90252746131489},"this calculation based on EPA equation"]
[null,null,"COD concentration of raw water","g/m3",{"$f":"UASB!$G$10","v":1507},null,"Oxygen Demand (OD) removal efficiency at second step (AS)","%",{"$f":"'Aerated Lagoon + AS (Baseline)'!E62*100","v":91.61517508440555},"MOJ",null,null,"COD removed","g/m3",{"$f":"E56","v":1481.7281377043983},"kg/day",{"$f":"O7*E6/1000","v":53290.352472538681}]
[null,null,"Total Nitrogen (TN)","mg/L or g/m3",{"$f":"UASB!$G$11","v":120.56},null,"COD/BOD",null,1.9,"(calcualtion on supporting detail)",null,null,"COD removal","%",{"$f":"O7/E7*100","v":98.323035016881093},"%",{"$f":"O7/E7*100","v":98.323035016881093}]
[null,null,"Temperature (for Activated Sludge)","°C",20,null,"Amount gas generated/kg COD removal (anaerobic process)","m3/kg COD removal",0.15,"MOJ",null,null,"CO2 emission (well managed system)","ton/h",{"$f":"E43+E51","v":0.31837456735038516},"kg/day",{"$f":"O9*24*1000","v":7640.9896164092443}]
[null,null,"Total hydraulic residence time in pond system (d) (for Activated Sludge)","days",20,null,"Conversion factor","kg CH4/m3",0.71399999999999997,"MOJ",null,null,"CO2 emission (overloaded system)","ton/h",{"$f":"E43+E52","v":0.37114566203323729},"kg/day",{"$f":"O10*1000*24","v":8907.4958887976936},null,null,null,"Methane gas from water treatment will be reused for energy"]
[null,null,"Number of cells (for Activated Sludge)","cells",1,null,"CH4 Global Warming Potential","kg CO2 e/kg CH4",21,"IPCC",null,null,"CH4 emission (well managed system)","ton/h",{"$f":"E44+E53","v":4.6972687666666679E-2},"kg/day",{"$f":"O11*1000*24","v":1127.3445040000004}]
[null,null,"BOD rate constant@T/day (KT)","/d ",{"$f":"I30*(I31^(E9-20))","v":0.23},null,"N2O ","kg CO2 e/kg N2O",298,"IPCC",null,null,"CH4 emission (overloaded system)","ton/h",{"$f":"E44+E54","v":6.9162150659995314E-2},"kg/day",{"$f":"O12*1000*24","v":1659.8916158398877}]
[null,"COD removal from sludge","Generated amount of sludge ","kgDS/day",{"$f":"UASB!$G$18","v":4120},null,"COD degradation rate at up to discharge point","%",{"$f":"UASB!$G$13","v":50},"MOJ",null,null,"N2O emission","ton/h",{"$f":"E45+E55","v":2.1292564464285716E-3},"kg/day",{"$f":"O13*1000*24","v":51.102154714285717}]
[null,"Electricity use","Total Electricity consumption ","kWh/day",{"$f":"UASB!$G$19","v":48612},null,"COD degradation rate at discharge point","%",{"$f":"UASB!$G$14","v":10},"MOJ",null,"At up to discharge point","COD after","g/m3",{"$f":"E61","v":12.635931147800845},"kg/day",{"$f":"O14*E6/1000","v":454.45126373065739},"this calculation based on IGES DATA "]
[null,null,null,null,null,null,"Maximum methane formation potential","kgCH4/kgCOD",{"$f":"UASB!$G$15","v":0.21},"MOJ",null,null,"GHG Emission","kg/day",{"$f":"E60*E6/1000*I15*I16*I11","v":1883.8822686690673},"kg/day",{"$f":"O15","v":1883.8822686690673}]
[null,null,null,null,null,null,"Model correction coeficient",null,0.94,"MOJ",null,"At dischagre point","COD after","g/m3",{"$f":"E64","v":11.37233803302076},"kg/day",{"$f":"O16*E6/1000","v":409.00613735759163}]
[null,null,null,null,null,null,"Methane emission/kg generated sludge ","kgCH4/kgDS",{"$f":"UASB!$G$16","v":0.15},"MOJ",null,null,"GHG Emission","kg/day",{"$f":"E63*E6/1000*I15*I16*I11","v":188.38822686690671},"kg/day",{"$f":"O17","v":188.38822686690671}]
[null,null,null,null,null,null,"Electricity emission factor","kgCO2/kWh",0.754,"ADB, 2017 (also used by MOJ)",null,"From Sludge","GHG Emission","kg CO2e/day",{"$f":"E13*I17*I11","v":12978},"kg/day",{"$f":"O18","v":12978}]
[null,null,null,null,null,null,"CF CO2","g CO2/g Oxygen demand",1.375,"EPA",null,"By Electricity Used","CO2 emission","kg CO2e/day",{"$f":"E14*I18","v":36653.447999999997},"kg/day",{"$f":"O19","v":36653.447999999997}]
[null,null,null,null,null,null,"CF CH4","g CH4/g Oxygen demand",0.5,"EPA",null,null,"GHG Emission","kg CO2e/day",{"$f":"O19","v":36653.447999999997},"kg/day",{"$f":"O20","v":36653.447999999997}]
[null,null,null,null,null,null,"MCF ww for aerobic lagoon well managed",null,0,"IPCC",null,"GHG emission","From total CO2 emisson (well manage system)","kg CO2e/day",{"$f":"Q9+Q19","v":44294.437616409239}]
[null,null,null,null,null,null,"MCF ww for aerobic lagoon overloaded/anoxic",null,0.3,"IPCC",null,null,"From total CO2 emisson (overloaded system)","kg CO2e/day",{"$f":"Q10+Q19","v":45560.943888797687}]
[null,null,null,null,null,null,"MCF ww for anaerobic sludge digester",null,0.8,"IPCC",null,null,"From total CH4 emisson (well managed system)","kg CO2e/day",{"$f":"(Q11*21)+Q15+Q17+Q18","v":38724.505079535986}]
[null,null,null,null,null,null,"λ  for aerobic lagoon well managed",null,0.65,"Choubert et al (2009), Muller et al (2003), Munz (2008)",null,null,"From total CH4 emisson (overloaded system)","kg CO2e/day",{"$f":"(Q12*21)+Q15+Q17+Q18","v":49907.994428173617}]
[null,null,null,null,null,null,"λ  for aerobic lagoon overloaded",null,0.45,"Choubert et al (2009), Muller et al (2003), Munz (2008), Ammary (2004)",null,null,"From total N2O emisson","kg CO2e/day",{"$f":"Q13*I12","v":15228.442104857144}]
[null,null,null,null,null,null,"λ  for anaerobic process",null,0.1,"Ammary (2004); Low and Chase (1999)",null,null,"well managed system from CO2 and CH4 total emission","kg CO2e/day",{"$f":"O21+O23","v":83018.942695945225}]
[null,null,null,null,null,null,"BG CH4",null,0.65,"EPA",null,null,"overloaded system from CO2 and CH4 total emission","kg CO2e/day",{"$f":"O22+O24","v":95468.938316971296}]
[null,null,null,null,null,null,"NO2 Emission factor","g N2O/g TKN",5.0000000000000001E-3,"Chandran 2010 and IPCC",null,null,"well managed system from CO2  CH4 and NO2 total emission","kg CO2e/day",{"$f":"O26+O25","v":98247.384800802363}]
[null,null,null,null,null,null,"k (first order reaction rate constant (assumed to be constant in all cells)"," day-1 at 20° C ",0.27600000000000002,"EPA",null,null,"over loaded system from CO2  CH4 and NO2 total emission","kg CO2e/day",{"$f":"O27+O25","v":110697.38042182843}]
[null,"Calculation ",null,null,null,null,"K20 (BOD rate constant@20°C)","/day",0.23,"EPA"]
[null,null,null,null,null,null,"θ (Temperature Coefissient )",null,1.056,"EPA"]
[null,"Proposed Calculation",null,null,null,null,"TN removal  eff in  UASB",null,{"$f":"UASB!$G$17/100","v":0.5}]
[null,"Category","Item","Unit","Value"]
[null,"Waste water treatment"]
[null,"1st step : UASB","Waste water influent flow rate (Qww)","m3/h",{"$f":"E6/24","v":1498.5416666666667}]
[null,null,"BOD5 influent","g/m3",{"$f":"E7/I8","v":793.1578947368422}]
[null,null,"COD removed","g/m3",{"$f":"E7*I6/100","v":1205.5999999999999}]
[null,null,"COD Effluent","g/m3",{"$f":"E7-E37","v":301.40000000000009}]
[null,null,"BOD5 effluent","g/m3",{"$f":"E38/I8","v":158.63157894736847}]
[null,null,"BOD5 removed","g/m3",{"$f":"E36-E39","v":634.52631578947376}]
[null,null,"COD removal efficiency",null,{"$f":"E37/E7","v":0.79999999999999993}]
[null,null,"TN after","g/m3",{"$f":"E8-(E8*I32)","v":60.28}]
[null,null,"CO2 emission ","ton/h",{"$f":"(10^(-6))*E35*E7*I6/100*$I$19*((1-I23*$I$27)*I26)","v":0.11923836100000001}]
[null,null,"CH4 emission ","ton/h",{"$f":"(10^-6)*E35*E7*(I6/100)*I20*(I23*I27)*(I26)","v":4.6972687666666679E-2}]
[null,null,"NO2 emission ","ton/h",{"$f":"E35*E8*I28*44/28*(10^-6)","v":1.4195042976190477E-3}]
[null,"2nd step : Activated Sludge","Waste water influent flow rate (Qww)","m3/h",{"$f":"E35","v":1498.5416666666667}]
[null,null,"COD removed","g/m3",{"$f":"E38*I7/100","v":276.1281377043984}]
[null,null,"COD Effluent","g/m3",{"$f":"E38-E47","v":25.271862295601693}]
[null,null,"BOD5 removed","g/m3",{"$f":"E39*I7/100","v":145.33059879178865}]
[null,null,"BOD5 effluent","g/m3",{"$f":"E39-E49","v":13.300980155579822}]
[null,null,"CO2 emission (well managed system)","ton/h",{"$f":"(10^(-6))*E46*E38*I7/100*I19*(1-I21*I27)*(1-I24)","v":0.19913620635038515}]
[null,null,"CO2 emission (anoxic system)","ton/h",{"$f":"(10^(-6))*E46*E38*I7/100*I19*(1-I22*I27)*(1-I25)","v":0.25190730103323727}]
[null,null,"CH4 emission (well managed system)","ton/h",{"$f":"(10^-6)*E46*E38*I7/100*I20*(I21*I27)*(1-I24)","v":0}]
[null,null,"CH4 emission (anoxic system)","ton/h",{"$f":"(10^-6)*E46*E38*I7/100*I20*(I22*I27)*(1-I25)","v":2.2189462993328635E-2}]
[null,null," NO2 emission ","ton/h",{"$f":"E46*E42*I28*44/28*(10^-6)","v":7.0975214880952386E-4}]
[null,null,"Total COD removal","g/m3",{"$f":"E37+E47","v":1481.7281377043983}]
[null,null,"Total BOD removal","g/m3",{"$f":"E40+E49","v":779.85691458126234}]
[null,null,"Total COD removal efficiency","%",{"$f":"E56/E7*100","v":98.323035016881093}]
[null,null,"Total BOD removal efficiency","%",{"$f":"E57/E36*100","v":98.323035016881107}]
[null,"At up to discharge point","COD removed","g/m3",{"$f":"E48*I13/100","v":12.635931147800848}]
[null,null,"COD Effluent","g/m3",{"$f":"E48-E60","v":12.635931147800845}]
[null,null,"BOD5 effluent","g/m3",{"$f":"E61/I8","v":6.650490077789919}]
[null,"At discharge point","COD removed","g/m3",{"$f":"E61*I14/100","v":1.2635931147800845}]
[null,null,"COD Effluent","g/m3",{"$f":"E61-E63","v":11.37233803302076}]
[null,null,"BOD5 effluent","g/m3",{"$f":"E64/I8","v":5.9854410700109266}]

{"sheet":"UASB + SWIMBED","index":14,"n_rows":64,"n_cols":18,"rows_kept":64,"cut":false,"hidden":false,"merged":[[0,1,1,20],[5,1,11,1],[54,1,57,1],[58,1,60,1],[61,1,63,1],[3,11,3,19],[4,17,4,19],[11,17,17,19],[11,11,12,11],[13,11,14,11],[16,11,17,11],[18,11,22,11],[5,11,10,11],[5,17,10,19]]}
[null,"Upflow Anaerobic Sludge Blanket (UASB) + Swimbed"]
[]
[]
[null,"Input ",null,null,null,null,"Default Value",null,null,null,null,"Output"]
[null,"Category","Item","Unit","Value",null,"Item","Unit","Value","Source",null,"Category","Item","Unit","Value","Unit","Value"]
[null,"Waste water treatment","Amount of waste water","(m3/day)",{"$f":"UASBSWIMBED!G9","v":35965},null,"Oxygen Demand (OD) removal efficiency at first step (UASB)","%",{"$f":"UASBSWIMBED!$G$12","v":80},"MOJ",null,"Waste water treatment","COD after","g/m3",{"$f":"E48","v":14.568645152582716},"kg/day",{"$f":"O6*E6/1000","v":523.96132291263734},"this calculation based on EPA equation"]
[null,null,"COD concentration of raw water","g/m3",{"$f":"UASBSWIMBED!G10","v":1507},null,"Oxygen Demand (OD) removal efficiency at second step (SWIMBED)","%",95,"EES Lab calculation",null,null,"COD removed","g/m3",{"$f":"E55","v":1492.4313548474174},"kg/day",{"$f":"O7*E6/1000","v":53675.293677087364}]
[null,null,"Total Nitrogen (TN)","mg/L or g/m3",{"$f":"UASBSWIMBED!G11","v":120.56},null,"COD/BOD",null,1.9,null,null,null,"COD removal","%",{"$f":"$O$7/$E$7*100","v":99.03326840394277},"%",{"$f":"$O$7/$E$7*100","v":99.03326840394277}]
[null,null,"Temperature","°C",{"$f":"UASBSWIMBED!$G$6","v":20},null,"Amount gas generated/kg COD removal (anaerobic process)","m3/kg COD removal",0.15,"MOJ",null,null,"CO2 emission ","ton/h",{"$f":"E43+E52","v":0.326093440462429},"kg/day",{"$f":"O9*24*1000","v":7826.2425710982961}]
[null,null,"Total hydraulic residence time in pond system (d)","days",{"$f":"UASBSWIMBED!$G$7","v":20},null,"Conversion factor","kg CH4/m3",0.71399999999999997,"MOJ",null,null,"CH4 emission","ton/h",{"$f":"E44+E53","v":4.6972687666666679E-2},"kg/day",{"$f":"O10*1000*24","v":1127.3445040000004}]
[null,null,"Number of cells ","cells",{"$f":"UASBSWIMBED!$G$8","v":2},null,"CH4 Global Warming Potential","kg CO2 e/kg CH4",21,"IPCC",null,null,"N2O emission","ton/h",{"$f":"E45+E54","v":2.1292564464285716E-3},"kg/day",{"$f":"O11*1000*24","v":51.102154714285717}]
[null,null,"BOD rate constant@T/day (KT)","/d ",{"$f":"I30*((I31^(E9-20)))","v":0.23},null,"N2O ","kg CO2 e/kg N2O",298,"IPCC",null,"At up to discharge point","COD after","g/m3",{"$f":"E60","v":7.2843225762913582},"kg/day",{"$f":"O12*E6/1000","v":261.98066145631867},"this calculation based on IGES DATA "]
[null,"COD removal from sludge","Generated amount of sludge ","kgDS/day",{"$f":"UASBSWIMBED!G18","v":2168},null,"COD degradation rate at up to discharge point","%",{"$f":"UASBSWIMBED!$G$13","v":50},"MOJ",null,null,"GHG Emission","kg/day",{"$f":"E59*E6/1000*I15*I16*I11","v":1086.0146340010233},"kg/day",{"$f":"O13","v":1086.0146340010233}]
[null,"Electricity use","Total Electricity consumption ","kWh/day",{"$f":"UASBSWIMBED!G19","v":33651},null,"COD degradation rate at discharge point","%",{"$f":"UASBSWIMBED!$G$14","v":10},"MOJ",null,"At dischagre point","COD after","g/m3",{"$f":"E63","v":6.5558903186622226},"kg/day",{"$f":"O14*E6/1000","v":235.78259531068682}]
[null,null,null,null,null,null,"Maximum methane formation potential","kgCH4/kgCOD",{"$f":"UASBSWIMBED!$G$15","v":0.21},"MOJ",null,null,"GHG Emission","kg/day",{"$f":"E62*E6/1000*I15*I16*I11","v":108.60146340010233},"kg/day",{"$f":"O15","v":108.60146340010233}]
[null,null,null,null,null,null,"Model correction coeficient",null,0.94,"MOJ",null,"From Sludge","GHG Emission","kg CO2e/day",{"$f":"E13*I17*I11","v":6829.2},"kg/day",{"$f":"O16","v":6829.2}]
[null,null,null,null,null,null,"Methane emission/kg generated sludge ","kgCH4/kgDS",{"$f":"UASBSWIMBED!$G$16","v":0.15},"MOJ",null,"By Electricity Used","CO2 emission","kg CO2e/day",{"$f":"E14*I18","v":25372.853999999999},"kg/day",{"$f":"O17","v":25372.853999999999}]
[null,null,null,null,null,null,"Electricity emission factor","kgCO2/kWh",0.754,"ADB, 2017 (also used by MOJ)",null,null,"GHG Emission","kg CO2e/day",{"$f":"O17","v":25372.853999999999},"kg/day",{"$f":"O18","v":25372.853999999999}]
[null,null,null,null,null,null,"CF CO2","g CO2/g Oxygen demand",1.375,"EPA",null,"GHG emission","From total CO2 emisson ","kg CO2e/day",{"$f":"Q9+Q17","v":33199.096571098293}]
[null,null,null,null,null,null,"CF CH4","g CH4/g Oxygen demand",0.5,"EPA",null,null,"From total CH4 emisson ","kg CO2e/day",{"$f":"(Q10*21)+Q13+Q15+Q16","v":31698.050681401135}]
[null,null,null,null,null,null,"MCF ww for aerobic lagoon well managed",null,0,"IPCC",null,null,"From total N2O emisson","kg CO2e/day",{"$f":"Q11*I12","v":15228.442104857144}]
[null,null,null,null,null,null,"MCF ww for aerobic lagoon overloaded/anoxic",null,0.3,"IPCC",null,null," from CO2 and CH4 total emission","kg CO2e/day",{"$f":"O19+O20","v":64897.147252499431}]
[null,null,null,null,null,null,"MCF ww for anaerobic sludge digester",null,0.8,"IPCC",null,null,"from CO2  CH4 and NO2 total emission","kg CO2e/day",{"$f":"O19+O20+O21","v":80125.58935735657}]
[null,null,null,null,null,null,"λ  for aerobic lagoon well managed",null,0.65,"Choubert et al (2009), Muller et al (2003), Munz (2008)"]
[null,null,null,null,null,null,"λ  for aerobic lagoon overloaded",null,0.45,"Choubert et al (2009), Muller et al (2003), Munz (2008), Ammary (2004)"]
[null,null,null,null,null,null,"λ  for anaerobic process",null,0.1,"Ammary (2004); Low and Chase (1999)"]
[null,null,null,null,null,null,"BG CH4",null,0.65,"EPA"]
[null,null,null,null,null,null,"NO2 Emission factor","g N2O/g TKN",5.0000000000000001E-3,"Chandran 2010 and IPCC"]
[null,null,null,null,null,null,"k (first order reaction rate constant (assumed to be constant in all cells)"," day-1 at 20° C ",0.27600000000000002,"EPA"]
[null,"Calculation ",null,null,null,null,"K20 (BOD rate constant@20°C)","/day",0.23,"EPA"]
[null,null,null,null,null,null,"θ (Temperature Coefissient )",null,1.056,"EPA"]
[null,"Proposed Calculation",null,null,null,null,"TN removal  eff in  UASB",null,0.5]
[null,"Category","Item","Unit","Value",null,"TN removal  eff in  aeration tank",null,{"$f":"UASBSWIMBED!$G$17/100","v":0.5}]
[null,"Waste water treatment"]
[null,"1st step : UASB","Waste water influent flow rate (Qww)","m3/h",{"$f":"E6/24","v":1498.5416666666667}]
[null,null,"BOD5 influent","g/m3",{"$f":"E7/I8","v":793.1578947368422}]
[null,null,"COD removed","g/m3",{"$f":"E7*I6/100","v":1205.5999999999999}]
[null,null,"COD Effluent","g/m3",{"$f":"E7-E37","v":301.40000000000009}]
[null,null,"BOD5 effluent","g/m3",{"$f":"E38/I8","v":158.63157894736847}]
[null,null,"BOD5 removed","g/m3",{"$f":"E36-E39","v":634.52631578947376}]
[null,null,"COD removal efficiency",null,{"$f":"E37/E7","v":0.79999999999999993}]
[null,null,"TN after","g/m3",{"$f":"E8-(E8*I32)","v":60.28}]
[null,null,"CO2 emission ","ton/h",{"$f":"(10^(-6))*E35*E7*I6/100*$I$19*(I26*(1-I23*$I$27))","v":0.11923836100000001}]
[null,null,"CH4 emission ","ton/h",{"$f":"(10^-6)*E35*E7*(I6/100)*I20*(I23*I27)*(I26)","v":4.6972687666666679E-2}]
[null,null,"NO2 emission ","ton/h",{"$f":"E35*E8*I28*44/28*(10^-6)","v":1.4195042976190477E-3}]
[null,"2nd step : Swimbed","Waste water influent flow rate (Qww)","m3/h",{"$f":"E35","v":1498.5416666666667}]
[null,null,"COD removed","g/m3",{"$f":"E38-E48","v":286.8313548474174}]
[null,null,"COD Effluent","g/m3",{"$f":"E50*I8","v":14.568645152582716}]
[null,null,"BOD5 removed","g/m3",{"$f":"E39-E50","v":150.96387097232494}]
[null,null,"BOD5 effluent","g/m3",{"$f":"E39*(1-EXP(-E12*5))*(1/(1+((I29*E10)/E11))^E11)","v":7.6677079750435349}]
[null,null,"COD removal efficiency",null,{"$f":"E47/E38","v":0.95166342019713779}]
[null,null,"CO2 emission","ton/h",{"$f":"(10^(-6))*E46*E38*E51*I19*(1-I21*I27)*(1-I24)","v":0.20685507946242898}]
[null,null,"CH4 emission","ton/h",{"$f":"(10^-6)*E46*E38*E51*I20*(I21*I27)*(1-I24)","v":0}]
[null,null," NO2 emission ","ton/h",{"$f":"E46*E42*I28*44/28*(10^-6)","v":7.0975214880952386E-4}]
[null,null,"Total COD removal","g/m3",{"$f":"E37+E47","v":1492.4313548474174}]
[null,null,"Total BOD removal","g/m3",{"$f":"E40+E49","v":785.49018676179867}]
[null,null,"Total COD removal efficiency","%",{"$f":"E55/E7*100","v":99.03326840394277}]
[null,null,"Total BOD removal efficiency","%",{"$f":"E56/E36*100","v":99.033268403942756}]
[null,"At up to discharge point","COD removed","g/m3",{"$f":"E48*I13/100","v":7.2843225762913582}]
[null,null,"COD Effluent","g/m3",{"$f":"E48-E59","v":7.2843225762913582}]
[null,null,"BOD5 effluent","g/m3",{"$f":"E60/I8","v":3.8338539875217674}]
[null,"At discharge point","COD removed","g/m3",{"$f":"E60*I14/100","v":0.72843225762913577}]
[null,null,"COD Effluent","g/m3",{"$f":"E60-E62","v":6.5558903186622226}]
[null,null,"BOD5 effluent","g/m3",{"$f":"E63/I8","v":3.4504685887695912}]

{"sheet":"Reduction in COD from 5 scen","index":15,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,1,13,2],[14,1,14,2],[0,1,0,9],[5,1,9,1],[2,2,2,5],[2,7,2,9],[3,2,4,2],[3,3,4,3],[2,1,4,1]]}
[null,"Reduction in COD from 5 Scenario"]
[]
[null,"Sources ","BAU ",null,null,null,"Baseline","Co-benefits"]
[null,null,"Item","Unit","Without any treatment","Anaerobic","Aerated + Activated Sludge","Swimbed","UASB + AS","UASB+Swimbed"]
[null,null,null,null,"Value","Value","Value","Value","Value","Value"]
[null,"Waste water treatment","Amount of waste water  ","(m3/day)",{"$f":"'Anaerobic lagoon (BAU)'!$E$5","v":35965},{"$f":"'Anaerobic lagoon (BAU)'!$E$5","v":35965},{"$f":"'Aerated Lagoon + AS (Baseline)'!E10","v":35965},{"$f":"'Swimbed Scenario'!E6","v":35965},{"$f":"'UASB + AS'!E6","v":35965},{"$f":"'UASB + SWIMBED'!E6","v":35965}]
[null,null,"COD influent ","g/m3",{"$f":"'Anaerobic lagoon (BAU)'!E6","v":1507},{"$f":"'Anaerobic lagoon (BAU)'!E6","v":1507},{"$f":"'Aerated Lagoon + AS (Baseline)'!E11","v":1507},{"$f":"'Swimbed Scenario'!E7","v":1507},{"$f":"'UASB + AS'!E7","v":1507},{"$f":"'UASB + SWIMBED'!E7","v":1507}]
[null,null,"COD effluent","kg/day",{"$f":"E6*E7/1000","v":54199.254999999997},{"$f":"'Anaerobic lagoon (BAU)'!R5","v":27099.627499999999},{"$f":"'Aerated Lagoon + AS (Baseline)'!R6","v":4544.512637306565},{"$f":"'Swimbed Scenario'!R6","v":2095.8452916505494},908.90252746131489,{"$f":"'UASB + SWIMBED'!Q6","v":523.96132291263734}]
[null,null,"COD removed per day","kg/day",{"$f":"(E6*E7)/1000-E8","v":0},{"$f":"((F6*F7)/1000)-F8","v":27099.627499999999},49654.742362693432,52103.409708349449,53290.352472538681,53675.293677087357]
[null,null,"Reduction in COD","%",0,{"$f":"F9/((F7*F6)/1000)*100","v":50},{"$f":"G9/((G7*G6)/1000)*100","v":91.615175084405564},96.133073615771011,98.323035016881107,99.033268403942742]
[null,"At Up to point of charge","COD effluent","kg/day",0,{"$f":"'Anaerobic lagoon (BAU)'!R11","v":13549.813749999999},{"$f":"'Aerated Lagoon + AS (Baseline)'!R14","v":2272.2563186532825},{"$f":"'Swimbed Scenario'!R12","v":1047.9226458252747},{"$f":"'UASB + AS'!Q14","v":454.45126373065739},{"$f":"'UASB + SWIMBED'!Q12","v":261.98066145631867}]
[null,"At point of charge","COD effluent","kg/day",0,{"$f":"'Anaerobic lagoon (BAU)'!R13","v":12194.832375},{"$f":"'Aerated Lagoon + AS (Baseline)'!R16","v":2045.0306867879547},{"$f":"'Swimbed Scenario'!R14","v":943.13038124274715},{"$f":"'UASB + AS'!Q16","v":409.00613735759163},{"$f":"'UASB + SWIMBED'!Q14","v":235.78259531068682}]
[null,"Total COD removed",null,"kg/day",0,{"$f":"(F6*F7)/1000-(F12)","v":42004.422624999999},{"$f":"(G6*G7)/1000-(G12)","v":52154.224313212042},53256.124618757247,53790.248862642409,53963.47240468931]
[null,null,null,"g/m3",0,{"$f":"(F13*1000)/F6","v":1167.925},{"$f":"(G13*1000)/G6","v":1450.1383098348963},{"$f":"(H13*1000)/H6","v":1480.776438725351},{"$f":"(I13*1000)/I6","v":1495.6276619669793},{"$f":"(J13*1000)/J6","v":1500.4441096813377}]
[null,"COD Final",null,"g/m4",{"$f":"E7-E14","v":1507},339.07500000000005,56.86169016510371,26.223561274649001,11.372338033020696,6.5558903186622501]

{"sheet":"REFERENCE","index":16,"n_rows":61,"n_cols":7,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,0,24,0],[1,6,3,6]]}
["Scenarios","Parameter","Unit","Value","Source","Reference"]
["Anaerobic Lagoon","Amount of waste water","m3/day",35965,"MOJ",null,"input data"]
[null,"COD before","mg/L",1507,"MOJ"]
[null,"TKN","mg/L",12.56]
[null,"Generate amount of slude","kg DS/day",5306,"MOJ"]
[null,"Elctricity consumption","kWh/day",42561,"MOJ"]
[null,"Oxygen Demand (OD) removal efficiency at first step","%",50,"MOJ"]
[null,"COD/BOD",null,1.9,"calculation (supporting details on report)"]
[null,"Amount gas generated/kg COD removal (anaerobic process)","m3/kg COD removal",0.15,"MOJ"]
[null,"Conversion factor","kg CH4/m3",0.71399999999999997,"MOJ"]
[null,"CH4 Global Warming Potential","kg CO2 e/kg CH4",21,"MOJ"]
[null,"N2O ","kg CO2 e/kg N2O",298,"MOJ"]
[null,"COD degradation rate at up to discharge point","%",50,"MOJ"]
[null,"COD degradation rate at discharge point","%",10,"MOJ"]
[null,"Maximum methane formation potential","kgCH4/kgCOD",0.21,"MOJ"]
[null,"Model correction coeficient",null,0.94,"MOJ"]
[null,"Methane emission/kg generated sludge ","kgCH4/kgDS",0.15,"MOJ"]
[null,"Electricity emission factor","kgCO2/kWh",0.754,"MOJ"]
[null,"CF CO2","g CO2/g Oxygen demand",1.375,"EPA"]
[null,"CH CH4","g CH4/g Oxygen demand",0.5,"EPA"]
[null,"MCF ww for anaerobic lagoon",null,0.8,"EPA"]
[null,"λ  for anaerobic lagoon",null,0.1,"EPA"]
[null,"BG CH4",null,0.65,"EPA"]
[null,"NO2 Emission factor","g N2O/g TKN",5.0000000000000001E-3,"EPA"]
[null,"TKN removal efficiency of Anaerobic lagoon",null,0.24]
["Aerobic lagoon + AS","Temperature","°C",20,"Assumption"]
[null,"Total hydraulic residence time in pond system (d)","days",20,"Assumption"]
[null,"Number of cells ","cells",1,"Assumption"]
[null,"BOD rate constant@T/day (KT)","/d ",0.23,"EPA"]
[null,"Amount of waste water","m3/day",35965,"MOJ"]
[null,"COD concentration of raw water","mg/L",1507,"MOJ"]
[null,"Total Kjehdahl Nitrogen (TKN)","mg/L",120.56]
[null,"Generated amount of sludge","kgDS/day",15294,"MOJ"]
[null,"Total Electricity consumption ","kWh/day",155917,"MOJ"]
[null,"Oxygen Demand (OD) removal efficiency at first step","%",89.518968855506955]
[null,"COD/BOD",null,1.9]
[null,"Amount gas generated/kg COD removal (anaerobic process)","m3/kg COD removal",0.15,"MOJ"]
[null,"Conversion factor","kg CH4/m3",0.71399999999999997,"MOJ"]
[null,"CH4 Global Warming Potential","kg CO2 e/kg CH4",21,"MOJ"]
[null,"N2O ","kg CO2 e/kg N2O",298,"MOJ"]
[null,"COD degradation rate at up to discharge point","%",50,"MOJ"]
[null,"COD degradation rate at discharge point","%",10,"MOJ"]
[null,"Maximum methane formation potential","kgCH4/kgCOD",0.21,"MOJ"]
[null,"Model correction coeficient",null,0.94,"MOJ"]
[null,"Methane emission/kg generated sludge ","kgCH4/kgDS",0.15,"MOJ"]
[null,"Electricity emission factor","kgCO2/kWh",0.754]
[null,"CF CO2","g CO2/g Oxygen demand",1.375,"EPA"]
[null,"CF CH4","g CH4/g Oxygen demand",0.5,"EPA"]
[null,"MCF ww for aerobic lagoon well managed",null,0,"EPA"]
[null,"MCF ww for aerobic lagoon overloaded/anoxic",null,0.3,"EPA"]
[null,"λ  for aerobic lagoon well managed",null,0.65,"EPA"]
[null,"λ  for aerobic lagoon overloaded",null,0.45,"EPA"]
[null,"BG CH4",null,0.65,"EPA"]
[null,"NO2 Emission factor","g N2O/g TKN",5.0000000000000001E-3,"EPA"]
[null,"Oxygen Demand (OD) removal efficiency at clariffier settle",null,0.2]
[null,"k (first order reaction rate constant (assumed to be constant in all cells)"," day-1 at 20° C ",0.27600000000000002,"EPA"]
[null,"K20 (BOD rate constant@20°C)","/day",0.23]
[null,"θ (Temperature Coefissient )",null,1.056]
[null,"TKN removal  eff in  Aeration tank",null,0.5]
[null,"TKN removal  eff in  clarrifier settler ",null,0.2]
["SWIMBED"]