{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Cover","GasEngines LCA and LCCA","Flares LCA and LCCA","VAM LCA and LCCA"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Cover","index":0,"n_rows":70,"n_cols":1,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
{"$rows_empty":67}
["Data Validation Text"]
["Yes"]
["No"]

{"sheet":"GasEngines LCA and LCCA","index":1,"n_rows":133,"n_cols":4,"rows_kept":133,"cut":false,"hidden":false,"merged":[]}
["LifeCycle Analysis (LCA)"]
["Input Variable","Issue","Mitigation","Notes by ARPA-E; Applicant may provide additional notes\nGreen cells indicate applicant input is required."]
["Qualitative Environmental Impacts",null,null,"Identify any environmental/permitting issues"]
["Noise"]
["Viewshed/Light"]
["HAPS"]
["Waste Disposal"]
["Other",null,null,"Please identify any additional qualitative environmental impacts, if any"]
["Regulatory/Permitting","Standard","Compliance","Identify any permitting standards you believe will be relevant and indicate your ability to meet"]
["Regulatory Standard","e.g., NSPS"]
[]
["Test program conditions","Units","Value","Provide ranges"]
["Design Flow Rate"]
["Test Flow Rate"]
["Feed Gas Composition"]
["Ambient Conditions"]
[]
["Testing procedures",null,null,"Specify analytical method and error bars"]
["Methane"]
["Carbon Monoxide (g/MJ)"]
["Nitrogen Oxides (NOx, g/MJ)"]
["Nitrous Oxide (N2O, g/MJ)"]
["PM10/PM2.5 (soot, g/MJ)"]
["VOC (g/MJ)"]
[]
["Process Input Parameters",null,"Carbon Intensity","Specify assumptions for carbon footprint of inputs"]
["Electricity","(tonnes CO2/kWh)",7.0699999999999995E-4,"E.g., per EPA, AVERT, U.S. national weighted average CO2 marginal emission rate, year 2018 data"]
["Auxiliary Fuel","(kg CO2/kg)"]
["Steam ","(kg CO2/kg)"]
["Water","(kg CO2/kW-hr)"]
["Other"]
[]
["Life Cycle CO2e Reduction Calculations"]
[]
[null,"Units","Input","Notes by ARPA-E; Applicant may provide additional notes"]
["GHG Change from Methane Abatement Improvement"]
["Engine Rated Output","(bkW)",1000]
["Rated Speed","(RPM)",1400]
["Engine On-Stream Availability","(%)",0.85,"uptime"]
["Exhaust Gas Flow Rate","(m3/min) (STP)",260]
["Exhaust Gas Temperature","(C)",530]
["Fuel Consumption","(MJ/bkW-hr)",10.3]
["Fuel Heating Value ","(MJ/m3)",38]
["Methane Concentration","(mol %)",0.87]
["Methane Number","-",80,"E.g., 70-100"]
["Methane feed to engine","(tonnes/yr, CH4)",{"$f":"C37*C42/C43*C44/22.4*C78*C39*24*365*C81","v":1254.2031203007518},"LCA based on only methane feed to engine.  Assumes baseline 100% combustion efficiency for all non-methane hydrocarbons does not change, so non-methane emissions net out to zero"]
["Methane feed to engine","(tonnes/yr, CO2 eq)",{"$f":"C46*C82","v":31355.078007518794}]
["Methane Emissions at Rated Speed and Load","(% of feed)",0.03]
["Baseline Uncombusted Methane Emissions","(tonnes/yr, CH4)",{"$f":"C48*C46","v":37.626093609022554}]
["Baseline Uncombusted Methane Emissions, CO2e","(tonnes/yr, CO2 eq)",{"$f":"C49*C82","v":940.65234022556388}]
["Baseline CO2 Emissions Product of Methane Combustion","(tonnes/yr, CO2)",{"$f":"C46*(1-C48)*C79/C78","v":3345.5868234022555}]
["Baseline Engine GHG Emissions","(tonnes/yr, CO2)",{"$f":"C51+C50","v":4286.2391636278189}]
["Proposed Technology On-stream Availability when engine is running","(%)",0.99,"Please specify on-stream availability (and note on Line 59 any emissions when control is off-stream)"]
["Proposed Overall Combustion Efficiency, Lifetime Average {must be >(100%-C48)}","(%)",0.995,"Please account for any performance deterioration that would not be rectified by normal maintenance (e.g., catalyst deactivation) in this figure"]
["Change in Engine Output or Efficiency",null,null,"Discuss any changes due to implementing methane control technology and impact on GHG emissions"]
["Proposed Control Technology Annual Methane Emissions During Operation","(tonnes/yr, CH4)",{"$f":"C46*C53*(1-C54)","v":6.208305445488727},"Methane emissions when technology is operating.  Uncontrolled methane emissions if engine runs when methane emissions unit is down on line 59"]
["Proposed Control Technology Annual Methane Emissions During Operation","(tonnes/yr, CO2 eq)",{"$f":"C56*$C$82","v":155.20763613721817}]
["Proposed Control Technology CO2 Emissions Product of Methane Combustion","(tonnes/yr, CO2)",{"$f":"(C49*C53-C56)*C79/C78","v":85.364199875469907},"Assumes no change in other hydrocarbon conversion "]
["Methane Emissions When/If Process Runs with Methane Control Off","(tonnes/yr, CO2 eq)",{"$f":"C50*(1-C53)","v":9.4065234022556474},"E.g. methane emissions (in CO2e) that would take place when emissions are out of specification or control system is not operating"]
["Annual Change in N2O emissions with Proposed Technology","(tonnes/yr, N2O)",0,"Assumes no change in NOx, N2O, etc."]
["Annual Change in N2O Emissions with Proposed Technology","(tonnes/yr, CO2 eq)",{"$f":"C60*C83","v":0}]
["Overall GHG Emissions with Proposed Control Technology","(tonnes/yr, CO2 eq)",{"$f":"C51+C57+C58+C59+C61","v":3595.565182817199}," The total GHG emissions associated with proposed technology (i.e., sum of uncombusted methane, CO2 from methane combustion for the proposed technology, and impact of any N2O change) "]
["Incremental GHG Reduction from Proposed Technology Against Baseline Emissions","(tonnes/yr, CO2 eq)",{"$f":"C52-C62","v":690.67398081061992}]
["CO2e Process Inputs & Impacts",null,null,"Note: these are incremental compared to baseline "]
["Electricity Requirement","(kW)",0,"E.g., 1/2 hp motor operating continuously"]
["GHG Emissions from Electricity Required","(tonnes/yr, CO2)",{"$f":"$C$27*24*365*C48*C65","v":0}]
["Auxiliary Fuel Requirement","(Btu/hr)",null,"Please specify fuel quality "]
["GHG Emissions from Auxiliary Fuel","(tonnes/yr, CO2)",null,"and calculate related auxiliary fuel requirement emissions or note if this is due to engine derate"]
["Steam Requirement","(lb/hr)",null,"Justify inputs and explain calculations as needed"]
["GHG Emissions from \"Other\"","(tonnes/yr, CO2)",0,"Identify any \"other\" CO2E impacts for inputs associated with proposed technology"]
["GHG Emissions from Other Inputs","(tonnes/yr, CO2 eq)",{"$f":"C70*$C$78","v":0}]
["Summary of LifeCycle CO2e Impacts"]
["Incremental GHG Reduction for Proposed Technology Against Baseline  ","(tonnes/yr, CO2 eq)",{"$f":"C63-C66-C68-C70-C71","v":690.67398081061992},"Difference between operation of proposed solution and operation of baseline engine"]
["Overall GHG Emissions for Proposed Control Technology","(tonnes/yr, CO2 eq)",{"$f":"C62+C66+C70+C71","v":3595.565182817199}]
[]
["Overall Life Cycle Analysis (LCA) CO2e Reduction",{"$f":"1-C74/C47","v":0.88532750000000004}]
["Constants & Conversion Factors"]
["Mol Weight CH4","(kg/kg-mole)",16]
["Mol Weight CO2","(kg/kg-mole)",44]
["Molar Volume Conversion Factor at Standard Conditions","(scf/kg-mole)\nat 68 °F and 14.7 psia",849.5]
["Metric Tons (tonnes) to Kilograms","(tonnes/kg)",1E-3,"metric tons (tonnes) per kilogram"]
["Global Warming Potential (GWP) of Methane","(tonnes CO2 eq /  tonnes CH4)",25,"Metric tons (tonnes) CO2 equivalent"]
["GWP of N2O","(tonnes CO2 eq / tonnes N2O)",298,"Per EPA, 100 yr GWP"]
[]
[]
["Levelized Cost of Carbon Abatement (LCCA)"]
[]
[null,"Units","Input","Notes by ARPA-E; Applicant may provide additional notes"]
["Baseline Capital Costs (CAPEX)"]
["Incremental Equipment Costs","($)",{"$f":"C120","v":75000},"Identify the baseline cost for an engine with justification.  This summary figure should include installation and any other capital expenses."]
["Proposed Solution Capital Costs (CAPEX)"," "," "," "]
["Installation Costs","($)",1500,"Include installation labor, and all other hardware retrofits required for the proposed approach"]
["Total Incremental Capital Costs (CAPEX)","($)",{"$f":"C90+C92","v":76500}]
["Annual return on CAPEX ","(%)",0.1]
["Useful Life ","(yrs)",5,"Note: Equipment life should be based on measurements consistent with actual field conditions"]
["Annual Capital Recovery Cost","($)",{"$f":"-PMT(C94,C95,C93)","v":20180.507280798025}]
["Baseline Operating Costs (OPEX)"]
["Annual Maintenance (e.g., inspection, cleaning, calibration)","(hr)",40,"Include required maintenance intervals and real conditions (impact of variable gas flow/composition, catalyst poisons, metal corrosion, etc.). Account hours for the total staff"]
["Fully Burdened Labor Rate (including allocation for trucks and tools)","($/hr)",200,"E.g., please account for remote site work"]
["Annual Maintenance Subtotal","($/yr)",{"$f":"C98*C99","v":8000}]
["Added Utility Costs (if applicable)","($/yr)",0,"Include additional fuel costs for derate or to supply power/fuel to proposed solution compared to the baseline approach"]
["Added Fuel Costs (if applicable)","($/yr)",0]
["Additional Host Site Impact Costs (if applicable)","($/yr)",1000,"Include waste disposal costs or any other factors; please include details"]
["Hours Operational Disruption","(hr)",0,"E.g. annual hours when emissions are out of specification or control system is not operating"]
["Cost Operational Disruption ","($/yr)",0,"Provided by end user to Applicant"]
["Additional Incremental OPEX (if applicable)","($/yr)",{"$f":"C126","v":0},"As determined in the worksheet below"]
["Total Annual OPEX cost ","($/yr)",{"$f":"C100+C101+C103+C105+C106","v":9000},"Difference between OPEX for operation of proposed solution and a baseline engine operation"]
[]
["Total Annual Costs ","($/yr)",{"$f":"C96+C107","v":29180.507280798025},"Annual Capital Cost + Annual Incremental OPEX"]
[]
["CO2 Equivalent Emissions Abatement by Year","(tonne/yr)",{"$f":"C63","v":690.67398081061992},"As calculated in the LCA for your proposed approach"]
["Saleable Product Revenues","($/yr)",0,"Please add any revenues from proposed technology, e.g., credits for improved efficiency, revenue from methane sales, etc."]
[]
["Levelized Cost of Carbon Abatement","($/tonne)",{"$f":"(C109-C112)/C111","v":42.249321809618316}]
[]
["Additional CAPEX Detail"]
["Materials","($)",60000]
["Fabrication Costs","($)",15000]
["Etc.","($)",0,"Insert additional lines as required"]
["Subtotal - Incremental Equipment Costs","($)",{"$f":"SUM(C117:C119)","v":75000}]
[]
["Additional OPEX Detail"]
["Back Office Support","($/yr)",0]
["Telecom","($/yr)",{"$f":"0","v":0}]
["Etc.","($/yr)",0,"Insert additional lines as required"]
["Subtotal - Additional Incremental OPEX","($/yr)",{"$f":"SUM(C123:C125)","v":0}]
[]
["Supplemental IRR Calculation"," "," "," "]
["CO2 Credit Value of abatement","($/tonne)",50,"Phase 1 value"]
["CO2 Credit Value of Abatement","($/yr)",{"$f":"C129*C111","v":34533.699040530999},"Estimated credit value multiplied by incremental tons abated through approach"]
["Saleable Product Revenues","($/yr)",{"$f":"C112","v":0},"as previously entered"]
["Incremental Annual Net Value from Methane Abatement ","($/yr)",{"$f":"C130+C131-C107","v":25533.699040530999}," "]
["Internal Rate of Return (IRR)","(%)",{"$f":"RATE(C95,C132,(-C93),0)","v":0.19917631264704097},"Rate of return based on incremental CAPEX required and annual value created where credit values exceed annual operating costs"]

{"sheet":"Flares LCA and LCCA","index":2,"n_rows":135,"n_cols":4,"rows_kept":135,"cut":false,"hidden":false,"merged":[]}
["LifeCycle Analysis (LCA)"]
["Input Variable","Issue","Mitigation","Notes by ARPA-E; Applicant may provide additional notes\nGreen cells indicate applicant input is required."]
["Qualitative Environmental Impacts",null,null,"Identify any environmental/permitting issues"]
["Noise"]
["Viewshed/Light"]
["HAPS"]
["Waste Disposal"]
["Other",null,null,"Please identify any additional qualitative environmental impacts, if any"]
["Regulatory/Permitting","Standard","Compliance","Identify any permitting standards you believe will be relevant and indicate your ability to meet"]
["Regulatory Standard","e.g., NSPS"]
[]
["Test program conditions","Units","Value","Provide ranges"]
["Design Flow Rate"]
["Test Flow Rate"]
["Feed Gas Composition"]
["Ambient Conditions"]
[]
["Testing procedures",null,null,"Specify analytical method and error bars"]
["Methane"]
["Carbon Monoxide (g/MJ)"]
["Nitrogen Oxides (NOx, g/MJ)"]
["Nitrous Oxide (N2O, g/MJ)"]
["PM10/PM2.5 (soot, g/MJ)"]
["VOC (g/MJ)"]
[]
["Process Input Parameters",null,"Carbon Intensity","Specify assumptions for carbon footprint of inputs"]
["Electricity","(tonnes CO2/kWh)",7.0699999999999995E-4,"E.g., per EPA, AVERT, U.S. national weighted average CO2 marginal emission rate, year 2018 data"]
["Auxiliary Fuel Requirement","(kg CO2/kg)"]
["Steam ","(kg CO2/kg)"]
["Water","(kg CO2/kW-hr)"]
["Other"]
[]
["Life Cycle CO2e Reduction Calculations"]
[]
[null,"Units","Input","Notes by ARPA-E; Applicant may provide additional notes"]
["CO2e Change from Flaring Efficiency Improvement"]
["Flare Design Capacity","(scf/day)",100000,"E.g., majority of flares in smallest size range"]
["Annual Average Capacity","(%)",0.5,"E.g., 30-100%"]
["Baseline Flare On-Stream Availability","(%)",1,"Baseline assumed uptime"]
["Annual Flared Gas Volume","(MMscf)",{"$f":"C37*C38*C39*365/1000000","v":18.25}]
["Methane Concentration","(mol %)",0.65]
["Annual Flare Feed Methane ","(MMscf)",{"$f":"C40*C41","v":11.862500000000001}]
["Baseline Methane Feed ","(tonnes/yr, CH4)",{"$f":"C42*1000000/C77*C75*C78","v":223.42554443790465}]
["Baseline Methane Feed CO2e","(tonnes/yr, CO2 eq)",{"$f":"C43*GWP_Methane","v":5585.6386109476161},"LCA based on only methane feed to flare.  Assumes baseline 100% combustion efficiency for all non-methane hydrocarbons does not change, so non-methane emissions net out to zero"]
["Baseline Methane Combustion Efficiency","(%)",0.98,"Assume EPA flare efficiency"]
["Baseline Uncombusted Methane Emissions","(tonnes/yr, CH4)",{"$f":"C39*(1-C45)*C43+(1-C39)*C43","v":4.4685108887580967}]
["Baseline Uncombusted Methane Emissions, CO2e","(tonnes/yr, CO2 eq)",{"$f":"C46*GWP_Methane","v":111.71277221895241}]
["Baseline CO2 Emissions Product of Methane Combustion","(tonnes/yr, CO2)",{"$f":"C39*C43*C45*C76/C75","v":602.13184226015301}]
["Baseline Flare GHG Emissions","(tonnes/yr, CO2)",{"$f":"C48+C47","v":713.84461447910542},"Sum of uncombusted methane and CO2 from methane combustion"]
["Proposed Control Technology Onstream Availability","(%)",1,"Please specify on-stream availability (and note on Line 55 any emissions when control is off-stream)"]
["Proposed Control Technology Efficiency, Lifetime Average","(%)",0.995,"Please account for any performance deterioration that would not be rectified by normal maintenance in this figure"]
["Proposed Control Technology Annual Methane Emissions During Operation","(tonnes/yr, CH4)",{"$f":"C43*C50*(1-C51)","v":1.1171277221895242},"Methane emissions when technology is operating.  Uncontrolled methane emissions if process operates while flare is down on line 55"]
["Proposed Control Technology Annual Methane Emissions During Operation","(tonnes/yr, CO2 eq)",{"$f":"C52*$C$79","v":27.928193054738102}]
["Proposed Control Technology CO2 Emissions Product of Methane Combustion","(tonnes/yr, CO2)",{"$f":"C43*C50*C51*C76/C75","v":611.34814596821661}]
["Methane Emissions When/If Process Runs with Methane Control Off","(tonnes/yr, CO2 eq)",{"$f":"C43*(1-C50)*C79","v":0},"E.g. methane emissions (in CO2e) that would take place when emissions are out of specification or control system is not operating"]
["Annual Change in N2O Emissions with Proposed Technology","(tonnes/yr, N2O)",0,"Assumes no change in Nox, N2O, etc."]
["Annual Change in N2O Emissions with Proposed Technology","(tonnes/yr, CO2 eq)",{"$f":"C56*C80","v":0}]
["Subtotal GHG Emissions for Proposed Control Technology","(tonnes/yr, CO2)",{"$f":"C53+C54+C55+C57","v":639.27633902295474},"The total GHG emissions associated with proposed technology (i.e., sum of uncombusted methane, CO2 from methane combustion for the proposed technology, and impact of any N2O change)"]
["CO2e Process Inputs & Impacts"]
["Electricity Requirement","(kW)",{"$f":"(0.5)*(0.746)*(1/0.9)","v":0.41444444444444445},"E.g., 1/2 hp motor operating continuously, assume power linear with capacity"]
["GHG Emissions from Electricity Required","(tonnes/yr, CO2)",{"$f":"$C$27*24*365*C38*C39*C60","v":1.2833935333333331}]
["Auxiliary Fuel Requirement","(Btu/hr)",null,"Please specify fuel quality"]
["GHG Emissions from Auxiliary Fuel","(tonnes, CO2)",null,"and calculate related emissions from auxiliary fuel requirement"]
["Steam Requirement","(lb/hr)",null,"E.g., steam assist"]
["GHG Emissions from Steam","(tonnes, CO2)",0,"Justify inputs and explain calculation assumptions as needed"]
["GHG Emissions from Other Inputs","(tonnes, CO2 eq)",null,"Identify any \"other\" CO2E impacts for inputs associated with proposed techology"]
["Subtotal of GHG Emissions from Process Inputs","(tonnes, CO2 eq)",{"$f":"C61+C63+C65+C66","v":1.2833935333333331}]
["Summary of LifeCycle CO2e Impacts"]
["Overall GHG Emissions for Proposed Control Technology","(tonnes/yr, CO2 eq)",{"$f":"C58+C67","v":640.55973255628805}]
["Incremental GHG Reduction for Proposed Technology Against Baseline","(tonnes/yr, CO2 eq)",{"$f":"C49-C69","v":73.284881922817362},"Difference between operation of Proposed Solution and operation of a baseline flare operation"]
[]
["Overall Life Cycle Analysis (LCA) CO2e Reduction",{"$f":"1-C69/C44","v":0.88532023333897436}]
[]
["Constants & Conversion Factors"]
["Mol Weight CH4","(kg/kg-mole)",16]
["Mol Weight CO2","(kg/kg-mole)",44]
["Molar Volume Conversion Factor at Standard Conditions","(scf/kg-mole)\nat 68 °F and 14.7 psia",849.5]
["Metric Tons (tonnes) to Kilograms","(tonnes/kg)",1E-3,"metric tons (tonnes) per kilogram"]
["Global Warming Potential (GWP) of Methane","(tonnes CO2 eq /  tonnes CH4)",25,"Metric tons (tonnes) CO2 equivalent"]
["GWP of N2O","(tonnes CO2 eq / tonnes N2O)",298,"Per EPA, 100 yr GWP"]
[]
[]
[]
["Levelized Cost of Carbon Abatement (LCCA)"]
[]
[null,"Units","Input","Notes by ARPA-E; Applicant may provide additional notes"]
["Baseline Capital Costs (CAPEX)"]
["Total Equipment Costs","($)",{"$f":"50000+1500","v":51500},"Identify the baseline cost for a flare that would address basic EPA requirements at this flowrate.  This summary figure should include installation and any other capital expenses."]
["Proposed Solution Capital Costs (CAPEX)"]
["Equipment Costs","($)",{"$f":"C122","v":55000},"Provide detail in worksheet below as required"]
["Installation Costs","($)",1500,"Include installation labor, and all other hardware retrofits required for the proposed approach"]
["Total  Capital Costs (CAPEX)","($)",{"$f":"C90+C91","v":56500}]
["Total Incremental Capital Costs (CAPEX)","($)",{"$f":"C92-C88","v":5000},"Difference between CAPEX for operation of Proposed Solution and a baseline flare operation"]
["Discount Rate ","(%)",0.1]
["Useful Life ","(yrs)",5,"Equipment life should be based on measurements consistent with actual field conditions"]
["Annual Capital Recovery Cost","($)",{"$f":"-PMT(C94,C95,C93)","v":1318.9874039737269}]
["Baseline Operating Costs (OPEX)"]
["Total Annual OPEX costs","($/yr)",6000,"Includes all maintenance, labor, consumables, utilities"]
["Proposed Solution Operating Costs (OPEX)"]
["Annual Maintenance (inspection, cleaning, calibration)","(hr)",40,"Based on required maintenance intervals and real conditions (impact of variable gas flow/composition, catalyst poisons, metal corrosion, etc.)"]
["Fully Burdened Labor Rate (including allocation for trucks and tools)","($/hr)",200,"Account for remote site work"]
["Annual Maintenance Subtotal","($/yr)",{"$f":"C100*C101","v":8000}]
["Utility Costs","($/yr)",{"$f":"0.1*24*365*C38*C39*C60","v":181.5266666666667},"Additional power cost for proposed solution, $0.10/kW-hr"]
["Fuel Costs","($/yr)",0,"Additional fuel costs for proposed solution"]
["Other Host Site Impact Costs","($/yr)",0,"Waste disposal costs or any other factors; please specify"]
["Hours Operational Disruption","(hr)",0,"By Applicant - identify any costs required to ensure proposed approach operates as specified"]
["Cost Operational Disruption ","($/yr)",0,"Provided by end user to Applicant"]
["Additional Incremental OPEX","($/yr)",{"$f":"C128","v":240},"As determined in the worksheet below"]
["Total Annual OPEX cost ","($/yr)",{"$f":"C102+C103+C105+C107+C108","v":8421.5266666666666}]
["Total Incremental Annual OPEX cost ","($/yr)",{"$f":"C109-C98","v":2421.5266666666666},"Difference between OPEX for operation of Proposed Solution and a baseline flare operation"]
[]
["Total Annual Costs ","($/yr)",{"$f":"C96+C110","v":3740.5140706403936},"Annual Capital Cost + Annual Incremental OPEX"]
[]
["CO2 Equivalent Emissions Abatement by Year","(tonnes/yr)",{"$f":"C70","v":73.284881922817362},"As calculated in the LCA for your proposed approach"]
["Saleable Product Revenues","($/yr)",0,"Please add any revenues from technology products or by-products"]
["Levelized Cost of Carbon Abatement","($/tonne)",{"$f":"(C112-C115)/C114","v":51.040732720015185}]
[]
["Additional CAPEX Detail"]
["Materials","($)",35000]
["Fabrication Costs","($)",20000]
["Etc.","($)",0,"Insert additional lines as required"]
["Subtotal - Incremental Equipment Costs","($)",{"$f":"SUM(C119:C121)","v":55000}]
[]
["Additional OPEX Detail"]
["Back Office Support","($/yr)",0]
["Telecom","($/yr)",{"$f":"12*20","v":240}]
["Etc.","($/yr)",0,"Insert additional lines as required"]
["Subtotal - Additional Incremental OPEX","($/yr)",{"$f":"SUM(C125:C127)","v":240}]
[]
["Supplemental IRR Calculation"]
["CO2 Credit Value of abatement","($/tonne)",50,"Phase 1 value"]
["CO2 Credit Value of Abatement","($/yr)",{"$f":"C131*C114","v":3664.2440961408684},"Estimated credit value multiplied by incremental tons abated through approach"]
["Saleable Product Revenues","($/yr)",{"$f":"C115","v":0},"as previously entered"]
["Incremental Annual Net Value from Methane Abatement ","($/yr)",{"$f":"C132+C133-C110","v":1242.7174294742017}]
["Internal Rate of Return (IRR)","(%)",{"$f":"RATE(C95,C134,(-C93),0)","v":7.709754938827687E-2},"Rate of return based on incremental CAPEX required and annual value created where credit values exceed annual operating costs"]

{"sheet":"VAM LCA and LCCA","index":3,"n_rows":121,"n_cols":4,"rows_kept":121,"cut":false,"hidden":false,"merged":[]}
["LifeCycle Analysis (LCA)"]
["Input Variable","Issue","Mitigation","Notes by ARPA-E; Applicant may provide additional notes\nGreen cells indicate applicant input is required."]
["Qualitative Environmental Impacts",null,null,"Identify any environmental/permitting issues"]
["Noise"]
["Viewshed/light"]
["HAPS"]
["Waste disposal"]
["Other",null,null,"Please identify any additional qualitative environmental impacts, if any"]
["Regulatory/Permitting","Standard","Compliance","Identify any permitting standards you believe will be relevant and indicate your ability to meet"]
["Regulatory Standard","e.g., NSPS"]
[]
["Test program conditions","Units","Value","Provide ranges"]
["Design flow rate"]
["Test flow rate"]
["Feed gas composition"]
["Ambient conditions"]
[]
["Testing procedures",null,null,"Specify analytical method and error bars"]
["Methane"]
["Carbon Monoxide (g/MJ)"]
["Nitrogen Oxides (NOx, g/MJ)"]
["Nitrous Oxide (N2O, g/MJ)"]
["PM10/PM2.5 (soot, g/MJ)"]
["VOC (g/MJ)"]
[]
["Process Input Parameters",null,"Carbon intensity","Specify assumptions for carbon footprint of inputs"]
["Electricity","(tonnes CO2/kWh)",7.0699999999999995E-4,"E.g., per EPA, AVERT, U.S. national weighted average CO2 marginal emission rate, year 2018 data"]
["Auxiliary fuel","(kg CO2/kg)"]
["Steam ","(kg CO2/kg)"]
["Water","(kg CO2/kW-hr)"]
["Other"]
[]
["Life Cycle CO2e Reduction Calculations"]
[]
[null,"Units","Input","Notes by ARPA-E; Applicant may provide additional notes"]
["GHG Change from Methane Abatement Improvement"]
["Design Ventilation Shaft Flow"," (scfm)",100000]
["Annual Average Capacity","(%)",0.8,"as a fraction of the design ventilation flow"]
["Annual Average Methane Concentration","(%)",6.0000000000000001E-3,"0.2-1.6%"]
["Baseline VAM Unabated Methane Emissions","(tonnes/yr, CH4)",{"$f":"C37*60*24*365*C38*C39/C69*C67*C70","v":4751.7457327839911}]
["Baseline GHG from VAM","(tonnes/yr, CO2 eq)",{"$f":"C40*C71","v":118793.64331959978}]
["Proposed Technology On-stream Availability","(%)",0.99,"uptime"]
["Destruction Efficiency, Lifetime Average","(%)",0.995,"Please account for any performance deterioration not rectified by normal maintenance (e.g., catalyst deactivation) in this figure"]
["Proposed Control Technology Annual Methane Emissions During Operation","(tonnes, CH4)",{"$f":"C40*C42*(1-C43)","v":23.521141377280777},"Methane emissions when technology is operating.  Uncontrolled methane emissions if VAM unit operates when methane emissions unit is down is on following line"]
["Proposed Control Technology Annual Methane Emissions During Operation","(tonnes, CO2 eq)",{"$f":"C44*C71","v":588.02853443201946}]
["Proposed Control Technology CO2 from Methane Oxidation","(tonnes/yr, CO2)",{"$f":"C40*C42*C43*C68/C67","v":12871.944618716894},"Assumes no other hydrocarbons in VAM gas"]
["Methane Emissions When/If Process Runs with Methane Control Off","(tonnes/yr, CO2 eq)",{"$f":"C40*(1-C42)*C71","v":1187.9364331959989},"E.g. methane emissions (in CO2e) that would take place when emissions are out of specification or control system is not operating"]
["Proposed Control Technology Annual  N2O Emissions","(tonnes, N2O)",0,"Please identify any N2O that would be produced"]
["Proposed Control Technology Annual  N2O Emissions","(tonnes, CO2 eq)",{"$f":"C48*C73","v":0}]
["Subtotal GHG Emissions for Proposed Control Technology","(tonnes/yr, CO2)",{"$f":"C47+C45+C46+C49","v":14647.909586344913},"The total GHG emissions associated with proposed technology (i.e., sum of uncombusted methane, CO2 from methane combustion for the proposed technology, and impact of any N2O change)"]
["CO2e Process Inputs"]
["Electricity Requirement","(kW)",{"$f":"(600)*(0.746)*(1/0.9)","v":497.33333333333337},"e.g., 600 hp motor operating continuously, assume power linear with capacity"]
["GHG Emissions from Electricity Required","(tonnes, CO2)",{"$f":"$C$27*24*365*C38*C42*C52","v":2439.4744281600001},"should include any transient/start-up requirements"]
["Auxiliary fuel Requirement","(Btu/hr)",null,"Please specify fuel quality"]
["GHG Emissions from Auxiliary fuel","(tonnes, CO2)",null,"and calculate related emissions from auxiliary fuel requirement"]
["Steam Requirement","(lb/hr)",null,"E.g., steam assist"]
["GHG Emissions from Steam","(tonnes, CO2)",0,"Justify inputs and explain calculation assumptions as needed"]
["GHG Emissions from Other Inputs","(tonnes, CO2 eq)",null,"Identify any \"other\" CO2E impacts for inputs associated with proposed techology"]
["Subtotal of GHG Emissions from Process Inputs","(tonnes, CO2 eq)",{"$f":"C54+C55+C56+C58","v":0}]
["Summary of LifeCycle CO2e Impacts"]
["Overall GHG Emissions with Proposed Control Technology","(tonnes/yr, CO2 eq)",{"$f":"C45+C46+C49+C59","v":13459.973153148914}]
["GHG Reduction for Proposed Technology Against Baseline","(tonnes/yr, CO2 eq)",{"$f":"C41-C61","v":105333.67016645087}]
[]
["Overall Life Cycle Analysis (LCA) CO2e reduction",{"$f":"1-C61/C41","v":0.88669449999999994}]
[]
["Constants & Conversion Factors"]
["Mol Weight CH4","(kg/kg-mole)",16]
["Mol Weight CO2","(kg/kg-mole)",44]
["Molar Volume Conversion Factor at Standard Conditions","(scf/kg-mole)\nat 68 °F and 14.7 psia",849.5]
["Metric Tons (tonnes) to Kilograms","(tonnes/kg)",1E-3,"metric tons (tonnes) per kilogram"]
["Global Warming Potential (GWP) of Methane","(tonnes CO2 eq /  tonnes CH4)",25,"Metric tons (tonnes) CO2 equivalent"]
["GWP of N2O","(tonnes CO2 eq / tonnes N2O)",298,"Per EPA, 100 yr GWP"]
[]
[]
["Levelized Cost of Carbon Abatement (LCCA)"]
[]
[null,"Units","Input","Notes by ARPA-E; Applicant may provide additional notes"]
["Capital Costs (CAPEX)"]
["Equipment Costs","($)",{"$f":"C108","v":20020000},"Provide detail in worksheet below as necessary"]
["Installation Costs","($)",5000000,"Include installation labor, and all other hardware retrofits required for the proposed approach"]
["Total  Capital Costs (CAPEX)","($)",{"$f":"C79+C80","v":25020000}]
["Annual return on CAPEX ","(%)",0.1]
["Useful life ","(yrs)",10,"Equipment life should be based on measurements consistent with actual field conditions"]
["Annual Capital Recovery Cost","($)",{"$f":"-PMT(C82,C83,C81)","v":4071889.7799604405}]
["Incremental Operating Costs (OPEX)"]
["Annual Maintenance (inspection, cleaning, calibration)","(hr)",{"$f":"0.06*C81","v":1501200},"Based on required maintenance intervals and real conditions (impact of variable gas flow/composition, catalyst poisons, metal corrosion, etc.)"]
["Fully Burdened Labor Rate (including allocation for trucks and tools)","($/hr)",100,"Account for remote site work"]
["Staff","(persons)",8]
["Annual Maintenance Labor","($/yr)",{"$f":"C88*52*40*C87","v":1664000}]
["Added Fuel/Utility Costs","($/yr)",1000,"Additional fuel costs to supply power/fuel to proposed solution "]
["Additional Host Site Impact Costs","($/yr)",1000,"Waste disposal costs or any other factors; please specify"]
["Hours Operational Disruption","(hr)",0,"By Applicant"]
["Cost Operational Disruption ","($/yr)",0,"Provided by end user to Applicant"]
["Additional Incremental OPEX","($/yr)",{"$f":"C114","v":240},"As determined in the worksheet below"]
["Total Annual OPEX cost ","($/yr)",{"$f":"C86+C89+C90+C91+C93+C94","v":3167440}]
[]
["Total Annual Costs ","($/yr)",{"$f":"C84+C95","v":7239329.7799604405}]
[]
["CO2 Equivalent Emissions Abatement by Year","(tonnes/yr)",{"$f":"C62","v":105333.67016645087},"As calculated in the LCA for your proposed approach"]
["Saleable Product Revenues","($/yr)",0,"Please add any revenues from technology products or by-products"]
[]
["Levelized Cost of Carbon Abatement","($/tonne)",{"$f":"(C97-C100)/C99","v":68.727594590795817}]
[]
["Additional CAPEX Detail"]
["Materials","($)",20000000]
["Fabrication Costs","($)",20000]
["Etc.","($)",0,"Insert additional lines as required"]
["Subtotal - Incremental Equipment Costs","($)",{"$f":"SUM(C105:C107)","v":20020000}]
[]
["Additional OPEX Detail"]
["Back Office Support","($/yr)",0]
["Telecom","($/yr)",{"$f":"12*20","v":240}]
["Etc.","($/yr)",0,"Insert additional lines as required"]
["Subtotal - Additional Incremental OPEX","($/yr)",{"$f":"SUM(C111:C113)","v":240}]
[]
["Supplemental IRR Calculation"]
["CO2 Credit Value of abatement","($/tonne)",50,"Phase 1 value"]
["CO2 Credit Value of Abatement","($/yr)",{"$f":"C117*C99","v":5266683.5083225435},"Estimated credit value multiplied by incremental tons abated through approach"]
["Saleable Product Revenues","($/yr)",{"$f":"C100","v":0},"as previously entered"]
["Incremental Annual Net Value from Methane Abatement ","($/yr)",{"$f":"C118+C119-C95","v":2099243.5083225435}]
["Internal Rate of Return (IRR)","(%)",{"$f":"RATE(C83,C120,(-C81),0)","v":-3.0701669587459027E-2},"Rate of return based on incremental CAPEX required and annual value created where credit values exceed annual operating costs"]