{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Background","Inputs","CashFlows","CoalDry","SuppVAM","StandaloneVAM","MineBoiler","RecipEngines","EnclosedFlare","OpenFlare","Pipeline","CNG","LNG","Report","Report2","reportWork","DevNotes"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":595,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Background","index":0,"n_rows":57,"n_cols":30,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"z"]

{"sheet":"Inputs","index":1,"n_rows":110,"n_cols":17,"rows_kept":110,"cut":false,"hidden":true,"merged":[]}
["Form/Tab","Input Description","Entered Value","Default","Unit","Tag / Named Range","Recommendation","LowVal","HighVal","Column1","Column2","Evaluated by ARI","LowVal_old","HighVal_old","Comments ARI (Nov 2013)","Do not delete","ControlTipComments"]
[null,"Flag indicating whether the scenario was saved (Y or null)"]
["Start","Scenario ID:",4,null,null,"inputScenID",null,null,null,null,null,"NA"]
["Start","Scenario Description:","On-site Electricity Generation - Engine","engine","RecipEngines","inputScenario",null,null,null,null,null,"NA"]
["User","Scenario Name:","new_US",null,null,"inputScenName",null,null,null,null,null,"NA",null,null,null,null,"This will be the title on the ouput reports. Label it with the scenario being used."]
["Start","Percent methane in drainage gas",90,50,"%","inputPctMethane",null,null,null,null,null,"NA"]
["Start","Drainage System?","N",null,null,"inputDrainageSystem",null,null,null,null,null,"NA"]
["Start","Drainage Source","GW",null,null,"inputDrainageSource",null,null,null,null,null,"NA"]
["Start","Include Flares","NF",null,null,"inputScenFlare",null,null,null,null,null,"NA"]
["Drainage","What is the cost of well-head blowers?",null,1000,"$/HP","drainage1","[500-1,500]",null,null,null,null,"ok",null,null,null,null,"Examples http://www.epa.gov/cmop/docs/stu002.pdf"]
["Drainage","What is the cost of satellite compressors?",1000,1000,"$/HP","drainage2","[500-1,500]",null,null,null,null,"ok",null,null,null,null,"Examples http://www.epa.gov/cmop/docs/stu002.pdf"]
["Drainage","What is the distance from the drainage area to the onsite project?",21000,21000,"ft","drainage3","[5,000-25,000]",null,null,null,null,"ok",null,null,"Remove recommendation",null,"Used to calculate the capital cost of installing header pipe from the drainage area."]
["Drainage","What is the cost of installing header pipe from the drainage area?",40,40,"$/ft","drainage4","[20-120]",null,null,null,null,"ok",null,null,null,null,"Examples http://www.epa.gov/cmop/docs/stu002.pdf"]
["Drainage","What are the compressor and blower efficiencies?",3.5000000000000003E-2,3.5000000000000003E-2,"HP/mcfd","drainage5","[0.02-0.07]",0.02,7.0000000000000007E-2,null,null,"ok",0.02,7.0000000000000007E-2]
["Drainage","What is the spacing between gob drainage wells?",1000,1000,"ft","drainage6","[300-3,000]",null,null,null,null,"ok",null,null,"Added \"gob\" to question; range added according to Primer referenced in control tip",null,"Will vary with mining rate and gas content - See \"CMM Recovery - A Primer\" p.35  www.epa.gov/cmop/docs/cmm_primer.pdf"]
["Drainage","What is the mining rate?",12000,12000,"ft/yr","drainage7","[7,000-15,000]",null,null,null,null,"ok",null,null,null,null,"Typical US rates are 150 to 300 feet per week depending on seam thickness and mining conditions. See manual for formula to convert tons/yr mining rate to ft/yr."]
["Drainage","What is the mine depth?",null,1000,"ft","drainage8","[120-2,500]",null,null,null,null,"ok",null,null,"range added based on Gassy Mine Profiles depths",null,"U.S. Coal Mine Depths  www.ilcoalassn.com/underground-mining.html"]
["Drainage","What is the drilling cost?",null,140,"$/ft","drainage9","[120-200]",null,null,null,null,"OK",null,null,"Checked - reasonable; range added based on examples in Primer",null,"Include completion cost.  See \"CMM Recovery - A Primer\" p.17  for examples.  www.epa.gov/cmop/docs/cmm_primer.pdf"]
["Drainage","What is the fraction of this project's drainage system cost that will be included in the analysis?",null,100,"%","drainage10","[0-100]",0,100,null,null,"ok",0,100,null,null,"See note below."]
["Drainage","How many drainage wells are being utilized?",null,null,null,"drainage7alt"," ",null,null,null,null,"ok",null,null,null,null,"AMM scenario"]
["GasAvail","What do you expect the CMM drained per day to be?",1250,null,"mcf/d","gas1zz","[See footnote.]",null,null,null,null,"ok",null,null,"100 Mcfd * # of wells (conservative)",null,"See note at foot of page."]
["GasAvail","How much coal is dried per hour?",null,null,"t/h","gas2zz","[500-1,000]",null,null,null,null,"added rec",null,null,"Added rec figure. Modern US plants = 800-1000 t/hr",null,"Modern US plants = 800-1000 t/hr"]
["GasAvail","What is the dryer efficiency?",null,50,"%","gas3zz","[40-65]",40,65,null,null,"ok",40,65]
["GasAvail","What is the heat required per ton of coal?",null,0.3,"mmBtu/t","gas4zz","[0.15-0.4]",0.1,0.6,null,null,"change vals",0.15,0.4,"Increase range of low/high vlaue"]
["GasAvail","What is the boiler capacity?",null,null,"mmBtu/h","gas5zz","[1-250]",null,null,null,null,"ok",null,null,"1BHP = 33,479 Btu/hr  http://www.engineeringtoolbox.com/boiler-capacity-d_1115.html",null,"www.engineeringtoolbox.com/boiler-capacity-d_1115.html"]
["GasAvail","What is the fraction of CMM available after losses?",95,95,"%","gas6zz","[80-99]",80,99,null,null,"ok",80,99,"BHP = boiler horse power = 13.15 normal Hp = 9.8095 KW"]
["GasAvail","What is the average boiler load?",null,null,"mmBtu/h","gas7zz",null,null,null,null,null,"ok",null,null,"Will be a percentage of boiler capacity.   U.S. Boiler Characteristics - www1.eere.energy.gov/industry/distributedenergy/pdfs/characterization_industrial_commerical_boiler_population.pdf",null,"Will be a percentage of boiler capacity.   U.S. Boiler Characteristics - www1.eere.energy.gov/industry/distributedenergy/pdfs/characterization_industrial_commerical_boiler_population.pdf"]
["GasAvail","What percent methane is the drained gas?",90,null,"%","gas8zz","[40-90]",null,null,null,null,"ok",null,null,"www1.eere.energy.gov/industry/distributedenergy/pdfs/characterization_industrial_commerical_boiler_population.pdf",null,"Alert will show if methane % is too low for scenario."]
["GasAvail","What percent methane is in the ventilation air?  ",null,null,"%","gas9zz","[0.25-1.25]",null,null,null,null,"ok",null,null,"For StandaloneVAM",null,"Typical VAM contains < 1.5 % methane."]
["GasAvail","What do you expect the recoverable ventilation air flow to be?",null,null,"mcf/m","gas10zz","[200-550]",null,null,null,null,"ok",null,null,"For StandaloneVAM (rec values added)",null,"In the U.S., typical underground mines release 200-550 mcf/min (~100-250 cm/s) of ventilation exhaust air.  www.epa.gov/cmop/docs/VAM-exhaust-characterization-July2010.pdf"]
["GasAvail","What percent methane is in the ventilation air?  ",null,null,"%","gas11zz","[<0.25]",null,null,null,null,"ok",null,null,"For Supplemented VAM",null,"Should be less than 0.3% methane.  If greater, investigate Standalone VAM scenario."]
["GasAvail","What do you expect the recoverable ventilation air flow to be?",null,null,"mcf/m","gas12zz","[200-550]",null,null,null,null,"ok",null,null,"For Supplemented VAM (rec values added)",null,"In the U.S., typical underground mines release 200-550 mcf/min (~100-250 cm/s) of ventilation exhaust air.  www.epa.gov/cmop/docs/VAM-exhaust-characterization-July2010.pdf"]
["GasAvail","What is the target methane in the ventilation air after supplementation?",null,null,"%","gas13zz","[0.3-1.25]",null,null,null,null,"ok"]
["GasAvail","What do you expect the supplemental CMM drained per day to be?",null,null,"mcf/d","gas1alt","[See footnote.]",null,null,null,null,"ok",null,null,null,null,"See note at bottom of screen."]
["GasAvail","What is the fraction of supplemental CMM available after losses?",null,95,"%","gas6alt","[80-99]",0,99,null,null,"ok",80,99,null,null,"Should be above 80% and ideally above 90%"]
["GasAvail","What percent methane is the supplemental drained gas?",null,null,"%","gas8alt","[40-90]",40,null,null,null,"ok",null,null,null,null,"The minimum figure required will vary depending on end use."]
["User","For what price can CMM-based electricity be sold?",7.0000000000000007E-2,7.0000000000000007E-2,"$/kWh","user1","[0.03-0.10]",0,null,null,null,"changed low val",0.04,0.1,"Average wholesale prices from EIA July 2013",null,"Average wholesale prices from EIA July 2013"]
["User","What is the cost of electric power used by the project?",null,70,"$/MWh","user2","[50-90]",0,null,null,null,"ok",50,90,null,null,"Determine from local power costs."]
["User","Capital cost of treatment, engine-gen set, & electrical equipment?",1.1499999999999999,1.1499999999999999,"$000/kW","user3","[0.400-1.500]",0,1.5,null,null,"ok",1.1000000000000001,1.5,"Range modified to account for low cost of Chineese engines"]
["User","What is the O&M cost of the reciprocating engine?",0.02,0.02,"$/kWh","user4","[0.015-0.03]",1.4999999999999999E-2,0.03,null,null,"ok",1.4999999999999999E-2,0.03,null,null,"Expressed as a $rate per KWh"]
["User","What interest rate is charged for the loan? ",0,0,"%","user5","[Prime plus 1-3%]",0,100,null,null,"ok",1,100,"If developer equity=0% then no loan needed",null,"Enter \"0\" if developer's equity share is 100%"]
["User","What is the overall efficiency of the engine-generator set?",35,35,"% (LHV)","user6","[30-44]",30,44,null,null,"ok",30,44]
["User","What is the capital cost to convert the coal dryer?",null,7.5,"$000/mmBtu/h","user7","[5-13]",5,13,null,null,"ok",5,13,null,null,"In $1,000s per million Btus per hour"]
["User","What is the carbon credit unit sale price? ",2,2,"$/tonne CO2E","user8","[0-13]",0,50,null,null,"low&high val",2,8,"remove price constraints; range added - upper end based on carbon prices in the California cap-and-trade scheme (Price on April 1, 2015.  Source: World Bank. 2015. Carbon Pricing Watch 2015. Washington, DC: World Bank._",null,"Zero can be used if carbon credit pricing does not factor into the economics. Revenues from the sale of certified emission reductions assume a one year lag between credit generation and monitization."]
["User","What is the price of the methane sold to the pipeline? ",null,4,"$/mmBtu(HHV)","user9","[2.00-12.00]",null,null,null,null,"changed l&h vals",5,12,"changed rec values and remove low-high values",null,"Check current EIA US prices at:  http://www.eia.gov/naturalgas/weekly/"]
["User","What is the cost per ton of coal replaced by gas?",null,null,"$/ton","user10","[25-50]",10,150,null,null,"changed l&h vals",25,50,"EIA 2011 US figures",null,"Check current EIA US figures www.eia.gov/coal/news_markets/index.cfm"]
["User","What is the capital cost to convert the coal boiler to gas?",null,7.5,"$000/mmBtu/h","user11","[5-13]",5,13,null,null,"ok",5,13]
["User","What is the developer's equity share in the project? ",100,100,"%","user12","[0-100]",0,100,null,null,"ok",0,100,null,null,"Often 100%"]
["User","What is the distance to the natural gas pipeline?",null,null,"ft","user13",null,null,null,null,null,"ok",null,null,null,null,"Distance from project to sale outlet"]
["User","What is the installed cost of the high pressure line from the project site to the natural gas pipeline? ",null,55,"$/ft","user14","[40-70]",null,null,null,null,"ok",null,null,null,null,"Used in the calculation of capital costs"]
["User","What is the loan term?",5,5,"years","user15","[5 - project lifetime]",null,null,null,null,"ok",null,null,"y",null,"Leave as \"5\" if developer's equity share is 100%"]
["User","What is the planned project operational lifetime?",10,10,"years","user16","[10-20]",null,null,null,null,"ok",null,null,"y"]
["User","--",null,null,null,"user17",null,null,null,null,null,null,null,null,null,null,"--"]
["User","What percent of CMM is consumed by prime-mover use?",7,7,"%","user18","[5-10]",0,100,null,null,"ok",0,100,"range added; recommended value lowered from 10% to 7% based on RRR peer review comments",null,"Machine that transforms energy from thermal, electrical, or pressure into mechanical form to perform work (e.g., engines and turbines)"]
["User","What is the capital cost of the enclosed flare?",null,0.28000000000000003,"$000/mcfd","user19","[0.12-0.45]",0.12,0.45,null,null,"ok",0.12,0.45]
["User","What is the O&M cost of the enclosed flare?",null,15,"$000/year","user20","[10-20]",0,100,null,null,"ok",10,20,"remove price constraints",null,"In $1,000s per year"]
["User","What is the capital cost of the open flare?",null,0.08,"$000/mcfd","user21","[0.03-0.13]",0.03,0.13,null,null,"ok",0.03,0.13]
["User","What is the O&M cost of the open flare?",null,10,"$000/year","user22","[5-15]",5,15,null,null,"ok",5,15]
["User","What is the installed capital cost of the VAM oxidation system?",null,null,"$/cfm","user23","[20-25]",null,null,null,null,"check with Clark"]
["User","What is the annual operating and maintenance of the VAM system?",null,null,"$/cfm-yr","user24","[1.00-1.60]",null,null,null,null,"check with Clark"]
["User","What is the frequency VAM system will be relocated?",null,null,"years","user25","[1-10]",null,null,null,null,"change",null,null,"min year changed from 3 to 1.",null,"Number of years for system move between ventilation shafts"]
["User","What is VAM system relocation cost (incl. new site prep)?",null,null,"$/cfm","user26","[3-5]",null,null,null,null,"ok",null,null,null,null,"In dollars per cubic feet per minute"]
["User","What is the electrical load of the oxidizer blowers?",null,null,"kWh/mcf","user27","[0.05-0.10]",null,null,null,null,"ok"]
["User","What is the price of sold CNG?",null,2,"$/GGE","user28","[0.80-2.50]",null,null,null,null,"ok",null,null,"Included May 2015; range and default added based on AFDC data",null,"See USDOE Alternative Fuels Data Center (website) - Fuel Prices (www.afdc.energy.gov/fuels/prices.html)"]
["User","What is the price of sold LNG?",null,null,"$/mmBtu(HHV)","user29","[2-20]",0,null,null,null,"ok",null,null,"Included June 2015",null,"www.eia.gov/dnav/ng/ng_pri_sum_dcu_nus_m.htm"]
["User","What is the size of the CNG distribution system?",null,800,"GGE/day","user30","[20-2,000]",0,null,null,null,"ok",null,null,"Added May 2015",null,"See manual for reference to a 2014 USDOE paper on CNG costs, giving descriptions of typical CNG station sizes."]
["User","What is the installed capital cost of the CNG system?",null,1000,"$/GGE","user31","[500-1,500]",0,null,null,null,"ok",null,null,"Added May 2015",null,"See manual for reference to a 2014 USDOE paper on CNG costs, giving descriptions of typical CNG station sizes and capital costs."]
["User","What is the installed capital cost of the LNG system?",null,3000,"$,000","user32","[2,000-4,000]",0,null,null,null,"ok",null,null,"Added June 2015. Value from Clark's LNG example.",null,"Includes liquefaction system, onsite storage tanks and distribution equipment"]
["User","What is the O&M cost of the LNG system?",null,1.5,"$/mcfd","user33","[1-4]",0,null,null,null,"ok",null,null,"Added June 2015. Value from Clark's LNG example."]
["User","What are the LNG miscellaneous capital costs?",null,null,"$/mcfd","user34",null,0,null,null,null,"ok",null,null,"Not used",null,"Includes onsite storage tanks, a truck scale and electrical generator set"]
["User","What is the distance to the LNG sales point?",null,null,"miles","user35",null,0,null,null,null,"ok",null,null,"Not used"]
["User","What is the cost to transport LNG?",null,null,"$/ton/mile","user36",null,0,null,null,null,"ok",null,null,"Not used",null,"Cost per mile is a function of how many tons of LNG are being transported"]
["User","What is the cost of the oxygen removal system?",null,1250,"$,000","user37","[1,000-2,000]"]
["User","What is the O&M cost of the CNG system?",null,0.35,"$/GGE/day","user38","[0.28-0.42]",null,null,null,null,null,null,null,"Default value from http://www.marcellus.psu.edu/s_files/pdf/3-Harkelrod.pdf."]
["User"]
["User"]
["User"]
["Default","How many hours per year will the coal dryer operate?",null,8000,"hrs/year","default1","[4,500-8,300]",4300,8760,null,null,"changed l&h vals",7500,8300,"changed low&high vals to give more input flexibility",null,"8,000 hrs = 91% operational"]
["Default","How many hours per year will the flare operate?",null,8000,"hrs/year","default2","[4,500-8,300]",4300,8760,null,null,"changed l&h vals",7500,8300,"changed low&high vals to give more input flexibility",null,"8,000 hrs = 91% operational"]
["Default","How many hours per year will the mine boiler operate?",null,8000,"hrs/year","default3","[4,500-8,300]",4300,8760,null,null,"changed l&h vals",7500,8300,"changed low&high vals to give more input flexibility",null,"8,000 hrs = 91% operational"]
["Default","How many hours per year will the engine operate?",8000,8000,"hrs/year","default4","[4,500-8,300]",4300,8760,null,null,"changed l&h vals",7500,8300,"changed low&high vals to give more input flexibility",null,"8,000 hrs = 91% operational"]
["Default","How many hours per year will the project operate?",null,8000,"hrs/year","default5","[4,500-8,300]",4300,8760,null,null,"changed l&h vals",7500,8300,"changed low&high vals to give more input flexibility",null,"8,000 hrs = 91% operational"]
["Default","--",null,null,null,"default6",null,null,null,null,null,null,null,null,null,null,"--"]
["Default","What is the contingency factor?",5,5,"%","default7","[5-10]",0,100,null,null,"ok",0,100]
["Default","What is the annual escalation rate for carbon credits? ",2,2,"%","default8","[0-3]",0,100,null,null,"ok",0,100]
["Default","Electric Grid Emission Factor (Tonnes CO2/MWh)",null,0.59,"Tonnes CO2/MWh","default9","[0.40-1.20]"]
["Default","--",null,null,null,"default10",null,null,null,null,null,null,null,null,null,null,"--"]
["Default","What are the royalty and severance taxes?",0,null,"%","default11","[0-20]",0,100,null,null,"ok",0,100,"Changed to an annual operating cost. Negotiation fees removed and added to soft costs (capital expenditure). Default taken out",null,"See explanation in manual. Treated in the model as an operating cost.  Vary widely by US State.  See http://www.ncsl.org/research/energy/oil-and-gas-severance-taxes.aspx."]
["Default","--",null,null,null,"default12"]
["Default",null,null,null,null,"default13"]
["Default","What are the \"soft\" costs for the project?",5,5,"%","default14","[5-25]",null,null,null,null,null,null,null,"Added for version 3",null,"Express as % of capital costs.  Can include permits and authorization costs; negotiation fees; local taxes; land fees; staffing and other corporate overhead during development."]
["Default","What is the validation, verification and transaction cost to monetize carbon credits?",0.5,0.5,"$/tCO2e","default15","[0.20-1.00]",null,null,null,null,null,null,null,"Added for version 3",null,"Total carbon credit monetization costs are usually between US$0.30-1.00 per tCO2e."]
["Default","--",null,null,null,"default16"]
["Default","--",null,null,null,"default17"]
["Default","--",null,null,null,"default18"]
["Default","--",null,null,null,"default19"]
["Default","Which GWP value is used?",25,25,null,"default20","[21-25]",21,50,null,null,"ok",null,null,"Added April 2015 to give user options - upper level value set at 50 to allow for changes in future IPCC reports",null,"The UN IPCC 5th Assessment Report (2014) uses a Global Warming Potential (GWP) value of 25 - this is used as the default in the model. The user has the option of changing this to a value used in another Report if desired."]
["Default","What is the inflation rate?",2.5,2.5,"%","default21","[1.0-4.0]",0,100,null,null,"ok",0,100]
["Default","--",null,null,null,"default22"]
["Default",null,null,null,null,"default23"]
["Default","--",null,null,null,"default24"]
["Default","--",null,null,null,"default25"]
["Default","What is the real discount rate?",12,12,"%","default26","[7-15]",0,100,null,null,"ok",0,100]
["Default","--",null,null,null,"default27"]
["Default","--",null,null,null,"default28"]
["Default","--",null,null,null,"default29"]
["Default","--",null,null,null,"default30"]
["Default","What is the avoided coal handling cost? ",null,0.75,"$/ton","default31","[0.50-1.00]",0.5,1,null,null,"ok",0.5,1]
["Default","What is the replaced coal's fuel value?",null,24,"mmBtu/ton","default32","[23-26]",23,26,null,null,"ok",23,26]
["Default","How many hours per year will the VAM system operate?",null,8000,"hrs/year","default33","[4,500-8,300]",4300,8760,null,null,"changed l&h vals",7500,8300,"y"]

{"sheet":"CashFlows","index":2,"n_rows":7,"n_cols":22,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,1,0,21]]}
[null,"Coalbed Methane Scenario: new_US"]
[null,"Construction Year","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15","Year 16","Year 17","Year 18","Year 19","Year 20"]
["Savings or Product Revenues",null,2395.9066041422429,2455.8042692457989,2517.1993759769434,2580.129360376367,2644.632594385776,2710.7484092454201,2778.5171194765553,2847.980047463469,2919.1795486500555,2992.1590373663066,0,0,0,0,0,0,0,0,0,0]
["Carbon Credit Revenues",null,null,337.91290322580642,344.67116129032257,351.564584516129,358.59587620645158,365.76779373058059,373.0831496051922,380.54481259729607,388.15570884924199,395.91882302622685,403.83719948675139,0,0,0,0,0,0,0,0,0]
["Operating Costs",null,-1247.1214418335101,-1278.2994778793477,-1310.2569648263313,-1343.0133889469896,-1376.5887236706642,-1411.0034417624306,-1446.2785278064912,-1482.4354910016534,-1519.4963782766947,-1557.483787733612,0,0,0,0,0,0,0,0,0,0]
["Debt Service",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Net Cash Flow",-6397.6259009209898,1148.7851623087329,1515.4176945922577,1551.6135724409348,1588.6805559455063,1626.6397469215633,1665.5127612135702,1705.3217412752565,1746.0893690591117,1787.8388792226026,1830.5940726589217,403.83719948675139,0,0,0,0,0,0,0,0,0]

{"sheet":"CoalDry","index":3,"n_rows":104,"n_cols":23,"rows_kept":104,"cut":false,"hidden":true,"merged":[]}
["1 - INPUT PARAMETERS ","Values","units","Comment","Name","Default","Range"]
[{"$f":"lblDrain1","v":"What is the cost of well-head blowers?"},{"$f":"drainage1","v":0},"$/HP"]
[{"$f":"lblDrain2","v":"What is the cost of satellite compressors?"},{"$f":"drainage2","v":1000},"$/HP"]
[{"$f":"lblDrain3","v":"What is the distance from the drainage area to the onsite project?"},{"$f":"drainage3","v":21000},"ft"]
[{"$f":"lblDrain4","v":"What is the cost of installing header pipe from the drainage area?"},{"$f":"drainage4","v":40},"$/ft"]
[{"$f":"lblDrain5","v":"What are the compressor and blower efficiencies?"},{"$f":"drainage5","v":3.5000000000000003E-2},"HP/mcfd"]
[{"$f":"lblDrain6","v":"What is the spacing between gob drainage wells?"},{"$f":"drainage6","v":1000},"ft"]
[{"$f":"lblDrain7","v":"What is the mining rate?"},{"$f":"drainage7","v":12000},"ft/yr"]
[{"$f":"lblDrain7alt","v":"How many drainage wells are being utilized?"},{"$f":"drainage7alt","v":0},"wells"]
["What is the drainage gas source?",{"$f":"inputDrainageSource","v":"GW"}]
[{"$f":"lblDrain8","v":"What is the mine depth?"},{"$f":"drainage8","v":0},"ft/well"]
[{"$f":"lblDrain9","v":"What is the drilling cost?"},{"$f":"drainage9","v":0},"$/ft"]
[{"$f":"lblUser18","v":"What percent of CMM is consumed by prime-mover use?"},{"$f":"user18/100","v":7.0000000000000007E-2}]
[{"$f":"lblGas1","v":"What do you expect the CMM drained per day to be?"},{"$f":"gas1zz","v":1250},"mcf/d",null,"coalCmmDrained"]
["CMM drained per hour",{"$f":"B14/24","v":52.083333333333336},"mcf/h"]
[{"$f":"lblPctMethane","v":"Percent methane in drainage gas"},{"$f":"inputPctMethane/100","v":0.9},null,"Use 40% for Coal Dry Feasibility Test"]
["Actual gas flow",{"$f":"IF(B16<>0,B14/B16,0)","v":1388.8888888888889},"mcf/d"]
[{"$f":"lblUser16","v":"What is the planned project operational lifetime?"},{"$f":"user16","v":10},"years",null,"coalProjectLifetime"]
[{"$f":"lblGas6","v":"What is the fraction of CMM available after losses?"},{"$f":"gas6zz/100","v":0.95}]
["Average fuel available",{"$f":"B15*(B19-B13)","v":45.833333333333329},"mcf/h"]
["Fuel value",{"$f":"B20*B33/1000","v":41.708333333333329},"mmBtu/h"]
[{"$f":"lblGas2","v":"How much coal is dried per hour?"},{"$f":"gas2zz","v":0},"t/h"]
[{"$f":"lblDefault1","v":"How many hours per year will the coal dryer operate?"},{"$f":"default1","v":0},"h/y"]
[{"$f":"lblGas4","v":"What is the heat required per ton of coal?"},{"$f":"gas4zz","v":0},"mmBtu/ton"]
[{"$f":"lblGas3","v":"What is the dryer efficiency?"},{"$f":"gas3zz/100","v":0}]
[{"$f":"lblUser7","v":"What is the capital cost to convert the coal dryer?"},{"$f":"user7","v":0},"$000/(mmBtu/h)"]
[{"$f":"lblUser10","v":"What is the cost per ton of coal replaced by gas?"},{"$f":"user10","v":0},"$/ton"]
[{"$f":"lblDefault31","v":"What is the avoided coal handling cost? "},{"$f":"default31","v":0},"$/ton"]
[{"$f":"lblDefault32","v":"What is the replaced coal's fuel value?"},{"$f":"default32","v":0},"mmBtu/ton"]
[{"$f":"lblDrain10","v":"What is the fraction of this project's drainage system cost that will be included in the analysis?"},{"$f":"drainage10/100","v":0},null,"added by JC 6/25"]
["Drainage and Transport sys unit cap cost",{"$f":"IF((B14*B19)<>0,(B3*B6)+(B4*B5*B16/(B14*B19))+(IF(B10=\"AM\",B7*B5*B9*B16/(B14*B19),0))+\n(B30*IF(inputDrainageSystem=\"Y\",(B2*B6)+IF(B10=\"AM\",B11*B12*B9*B16/(B14*B19),0),0)),0)","v":671.63157894736844},"$/mcfd","\"X\", tweaked by JC 6/25",null,"Why is B16 - % methane used in this calculation"]
["Drainage and Transport O&M cost",{"$f":"IF(AND(inputDrainageSource=\"GW\",(B14*B19)<>0,B23<>0),((B8*B5)+IF(AND(inputDrainageSystem=\"Y\",B7<>0),B8*B11*B12*B30/B7,0))*B16*24/(B14*B19)/B23,0)","v":0},"$/mcf","\"Y\", tweaked by JC 6/25",null,"RJL May 2015 - Check.  Annual costs for AMM methane are very low.  Does not include the drilling of new wells."]
["CMM fuel value LHV",910,"Btu/cf","constant"]
["Weight of methane, tonnes",1.9259999999999999E-2,"tonnes/mcf","constant"]
[{"$f":"lblUser8","v":"What is the carbon credit unit sale price? "},{"$f":"user8","v":2},"$/tonne CO2E",null,"coalCER_UnitValue"]
["GWP ratio: methane to CO2",{"$f":"default20","v":25},"ratio","constant"]
[{"$f":"lblDefault21","v":"What is the inflation rate?"},{"$f":"default21/100","v":2.5000000000000001E-2},null,null,"coalInflationRate"]
[{"$f":"lblDefault26","v":"What is the real discount rate?"},{"$f":"default26/100","v":0.12},null,null,"coalRealDiscountRate"]
[{"$f":"lblUser12","v":"What is the developer's equity share in the project? "},{"$f":"user12/100","v":1},null,null,"EquityPercent"]
[{"$f":"lblUser15","v":"What is the loan term?"},{"$f":"user15","v":5},"yr",null,"loanTerm"]
[{"$f":"lblUser5","v":"What interest rate is charged for the loan? "},{"$f":"user5/100","v":0},null,null,"InterestRate"]
["Cap Cost Factors"]
[{"$f":"lblDefault7","v":"What is the contingency factor?"},{"$f":"default7/100","v":0.05}]
[{"$f":"lblDefault14","v":"What are the \"soft\" costs for the project?"},{"$f":"default14/100","v":0.05}]
["Annual Cost Factors"]
[{"$f":"lblDefault11","v":"What are the royalty and severance taxes?"},{"$f":"default11/100","v":0}]
[{"$f":"lblDefault15","v":"What is the validation, verification and transaction cost to monetize carbon credits?"},{"$f":"default15","v":0.5},"$/tCO2e"]
[]
["2 - Feasibility Test"]
["CMM heat value available/hour",{"$f":"B21","v":41.708333333333329},"mmBtu/h","this is downstream availability","heatAvailable"]
["Coal Dryer heat needed/hour",{"$f":"IF(B25<>0,B22*B24/B25,0)","v":0},"mmBtu/h",null,"heatNeeded"]
["CMM volume needed/hour",{"$f":"IF(OR(B50<B51,inputScenFlare=\"OF\",inputScenFlare=\"EF\"),B50*1000/B33/(1-B13),B51*1000/B33/(1-B13))","v":0},"mcf/h","incl prime mover, exclud fugitive"]
["CMM available for other uses",{"$f":"IF(OR(B51>B50, inputScenFlare=\"OF\",inputScenFlare=\"EF\",B19=0),0, B14-(B52*24/B19))","v":1250},"mcfd","available at drainage wells","coalCmmAvailable"]
[]
["3 - Calculate Annual Benefits"]
["Tons of coal replaced per hour",{"$f":"IF(B29<>0,IF(B50<B51,B50/B29,B51/B29),0)","v":0},"ton/h"]
["Cost savings per hour - coal ",{"$f":"B56*(B27+B28)","v":0},"$/h"]
["Cost savings per year - coal ",{"$f":"B57*B23/1000","v":0},"$000/y"]
["CMM volume needed/hour",{"$f":"B52","v":0},"mcf/h"]
["Tonnes CH4 needed/hour",{"$f":"B59*B34","v":0},"t/h"]
["Carbon credits earned per hour",{"$f":"B60*(B36+2)","v":0},"t/h"]
["Carbon credits earned per year",{"$f":"B61*B23","v":0},"t/y",null,"CERsEarnedPerYear"]
["Carbon credit revenue per year",{"$f":"B62*B35/1000","v":0},"$000/y"]
[]
["4 - Calculate New Annual Costs"]
["CMM needed per hour",{"$f":"B52","v":0},"mcf/h"]
["Drain & transport O&M cost/h",{"$f":"IF(B16<>0,(B66*B32)/B16,0)","v":0},"$/h"]
["Drain & transport O&M cost/yr",{"$f":"B67*B23/1000","v":0},"$000/y"]
["Back-up Flare O&M cost/yr",{"$f":"IF(inputScenFlare=\"OF\",user22,IF(inputScenFlare=\"EF\",user20,0))","v":0}]
["Royalty and Severance Taxes",{"$f":"coalCmmDrained*365*B46*3/1000","v":0},null,"3=Nat gas price $/mcf"]
["Carbon credit monetization cost/yr",{"$f":"B47*coalCERsEarnedPerYear/1000","v":0}]
["Total annual cost",{"$f":"SUM(B68,B69,B71,B70)","v":0},"$000/y",null,"TotalAnnualCost"]
[]
["5 - Calculate Project Capital Costs"]
["CMM needed per hour",{"$f":"B52","v":0},"mcf/h"]
["CMM transport system",{"$f":"IF(B16<>0,B31*B75*24/B16/1000,0)","v":0},"$000"]
["Dryer conversion",{"$f":"IF(B50<B51, B50*B26,B51*B26)","v":0},"$000"]
["Back-up Flare capital cost",{"$f":"IF(inputScenFlare=\"OF\",B20*24*user21,IF(inputScenFlare=\"EF\",B20*24*user19,0))","v":0}]
["  Subtotal",{"$f":"SUM(B76:B78)","v":0},"$000"]
["Total cap cost with factors",{"$f":"(B79*(1+B44))*(1+B43)","v":0},"$000",null,"TotalCapCost"]
[]
["6 - Calculate Loan and Equity"]
["Loan amount",{"$f":"B80*(1-B39)","v":0},"$000",null,"LoanAmount"]
["Equity amount",{"$f":"B80*B39","v":0},"$000",null,"EquityAmount"]
[]
["7 - Discounted Cash Flow Analysis","($000)"]
["Years >>>",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["A - Benefits"]
["Coal savings",null,{"$f":"IF(C$87<=$B$18,B58,0)","v":0},{"$f":"IF(D$87<=$B$18,C89*(1+$B$37),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Carbon Credit Revenues",null,null,{"$f":"IF(C$87<=$B$18,$B63,0)","v":0},{"$f":"IF(D$87<=$B$18,D90*(1+default8/100),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Benefits",null,{"$f":"SUM(C89:C90)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["B - Costs"]
["CMM transport cost + drain share",null,{"$f":"IF(C$87<=$B$18,-B72,0)","v":0},{"$f":"IF(D$87<=$B$18,C93*(1+$B$37),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["C - Cash Flow from Operations",null,{"$f":"SUM(C91:C93)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["D - Debt Service",null,{"$f":"IF(OR(C$87>$B$40,C$87>$B$18),0, PMT($B$41, $B$40, $B$83))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["E - Net Cash Flow",{"$f":"-B84","v":0},{"$f":"SUM(C94:C96)","v":0},{"$f":"SUM(D94:D96)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["8 - Financial Measurements: IRR, NPV, Payback"]
["Internal Rate of Return - IRR",null,{"$f":"IF(ISERR(IRR($B97:V97)),0,IRR($B97:V97))","v":0}]
["Net Present Value",null,{"$f":"NPV(B38,C97:V97)+coalMinusEquityAmount","v":0}]
["Payback Period",null,{"$f":"SUM(C104:V104)","v":0}]
[null,{"$f":"IF(B$87<=$B$18,SUM($B97:B97),0)","v":0},{"$f":"IF(C$87<=$B$18,SUM($B97:C97),0)","v":0},{"$f":"IF(D$87<=$B$18,SUM($B97:D97),0)","v":0},{"$f":"IF(E$87<=$B$18,SUM($B97:E97),0)","v":0},{"$f":"IF(F$87<=$B$18,SUM($B97:F97),0)","v":0},{"$f":"IF(G$87<=$B$18,SUM($B97:G97),0)","v":0},{"$f":"IF(H$87<=$B$18,SUM($B97:H97),0)","v":0},{"$f":"IF(I$87<=$B$18,SUM($B97:I97),0)","v":0},{"$f":"IF(J$87<=$B$18,SUM($B97:J97),0)","v":0},{"$f":"IF(K$87<=$B$18,SUM($B97:K97),0)","v":0},{"$f":"IF(L$87<=$B$18,SUM($B97:L97),0)","v":0},{"$f":"IF(M$87<=$B$18,SUM($B97:M97),0)","v":0},{"$f":"IF(N$87<=$B$18,SUM($B97:N97),0)","v":0},{"$f":"IF(O$87<=$B$18,SUM($B97:O97),0)","v":0},{"$f":"IF(P$87<=$B$18,SUM($B97:P97),0)","v":0},{"$f":"IF(Q$87<=$B$18,SUM($B97:Q97),0)","v":0},{"$f":"IF(R$87<=$B$18,SUM($B97:R97),0)","v":0},{"$f":"IF(S$87<=$B$18,SUM($B97:S97),0)","v":0},{"$f":"IF(T$87<=$B$18,SUM($B97:T97),0)","v":0},{"$f":"IF(U$87<=$B$18,SUM($B97:U97),0)","v":0},{"$f":"IF(V$87<=$B$18,SUM($B97:V97),0)","v":0}]
[null,null,{"$f":"IF(AND(C103>0,B103<0),C87+(1-C103/C97),0)","v":0},{"$f":"IF(AND(D103>0,C103<0),D87+(1-D103/D97),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"SuppVAM","index":4,"n_rows":101,"n_cols":23,"rows_kept":101,"cut":false,"hidden":true,"merged":[[28,4,28,6]]}
["1 - INPUT PARAMETERS ","Values","units","Comment","Name","Default","Range"]
[{"$f":"lblDrain1","v":"What is the cost of well-head blowers?"},{"$f":"drainage1","v":0},"$/HP"]
[{"$f":"lblDrain2","v":"What is the cost of satellite compressors?"},{"$f":"drainage2","v":1000},"$/HP"]
[{"$f":"lblDrain3","v":"What is the distance from the drainage area to the onsite project?"},{"$f":"drainage3","v":21000},"ft"]
[{"$f":"lblDrain4","v":"What is the cost of installing header pipe from the drainage area?"},{"$f":"drainage4","v":40},"$/ft"]
[{"$f":"lblDrain5","v":"What are the compressor and blower efficiencies?"},{"$f":"drainage5","v":3.5000000000000003E-2},"HP/mcfd"]
[{"$f":"lblDrain6","v":"What is the spacing between gob drainage wells?"},{"$f":"drainage6","v":1000},"ft"]
[{"$f":"lblDrain7","v":"What is the mining rate?"},{"$f":"drainage7","v":12000},"ft/yr"]
[{"$f":"lblDrain7alt","v":"How many drainage wells are being utilized?"},{"$f":"drainage7alt","v":0},"wells"]
["What is the drainage gas source?",{"$f":"inputDrainageSource","v":"GW"}]
[{"$f":"lblDrain8","v":"What is the mine depth?"},{"$f":"drainage8","v":0},"ft/well"]
[{"$f":"lblDrain9","v":"What is the drilling cost?"},{"$f":"drainage9","v":0},"$/ft"]
[{"$f":"lblUser18","v":"What percent of CMM is consumed by prime-mover use?"},{"$f":"user18/100","v":7.0000000000000007E-2}]
["What do you expect the supplemental CMM drained per day to be?",{"$f":"gas1alt","v":0},"mcf/d",null,"CmmDrained"]
["CMM drained per hour",{"$f":"B14/24","v":0},"mcf/h"]
[{"$f":"lblPctMethane","v":"Percent methane in drainage gas"},{"$f":"gas8alt/100","v":0}]
["Actual gas flow",{"$f":"IF(B16<>0,B14/B16,0)","v":0},"mcf/d"]
[{"$f":"lblUser16","v":"What is the planned project operational lifetime?"},{"$f":"user16","v":10},"years",null,"ProjectLifetime"]
[{"$f":"lblGas6","v":"What is the fraction of CMM available after losses?"},{"$f":"gas6alt/100","v":0}]
["Average fuel available",{"$f":"B15*(B19-B13)","v":0},"mcf/h"]
["Fuel value",{"$f":"B20*B33/1000","v":0},"mmBtu/h"]
["What percent methane is in the ventilation air?",{"$f":"gas11zz/100","v":0}]
["What do you expect the recoverable ventilation air flow to be?",{"$f":"gas12zz","v":0},"mcf/m"]
["How many hours per year will the VAM system operate?",{"$f":"default33","v":0},"hours/yr"]
["What is the installed capital cost of VAM oxidizer system?",{"$f":"user23","v":0},"$/scfm"]
["What is the annual O&M cost of the VAM oxidizer system?",{"$f":"user24","v":0},"$/scfm-yr"]
["What is the frequency VAM system will be relocated?",{"$f":"user25","v":0},"years"]
["What is the VAM oxidation system relocation cost?",{"$f":"user26","v":0},"$/cfm"]
["What is the electrical load of the oxidizer blowers?",{"$f":"user27","v":0},"kWh/mcf",null,"<< A new variable I just added."]
[{"$f":"lblDrain10","v":"What is the fraction of this project's drainage system cost that will be included in the analysis?"},{"$f":"drainage10/100","v":0},null,"added by JC 6/25"]
["Drainage and Transport sys unit cap cost",{"$f":"IF((B14*B19)<>0,(B3*B6)+(B4*B5*B16/(B14*B19))+(IF(B10=\"AM\",B7*B5*B9*B16/(B14*B19),0))+\n(B30*IF(inputDrainageSystem=\"Y\",(B2*B6)+IF(B10=\"AM\",B11*B12*B9*B16/(B14*B19),0),0)),0)","v":0},"$/mcfd","\"X\", tweaked by JC 6/25"]
["Drainage and Transport O&M cost",{"$f":"IF(AND(inputDrainageSource=\"GW\",(B14*B19)<>0,B24<>0),((B8*B5)+IF(AND(inputDrainageSystem=\"Y\",B7<>0),B8*B11*B12*B30/B7,0))*B16*24/(B14*B19)/B24,0)","v":0},"$/mcf","\"Y\", tweaked by JC 6/25"]
["CMM fuel value LHV",910,"Btu/cf","constant"]
["Weight of methane, tonnes",1.9259999999999999E-2,"tonnes/mcf","constant"]
[{"$f":"lblUser8","v":"What is the carbon credit unit sale price? "},{"$f":"user8","v":2},"$/tonne CO2E",null,"CER_UnitValue"]
["GWP ratio: methane to CO2",{"$f":"default20","v":25},"ratio","constant"]
[{"$f":"lblDefault21","v":"What is the inflation rate?"},{"$f":"default21/100","v":2.5000000000000001E-2},null,null,"InflationRate"]
[{"$f":"lblDefault26","v":"What is the real discount rate?"},{"$f":"default26/100","v":0.12},null,null,"RealDiscountRate"]
[{"$f":"lblUser12","v":"What is the developer's equity share in the project? "},{"$f":"user12/100","v":1},null,null,"EquityPercent"]
[{"$f":"lblUser15","v":"What is the loan term?"},{"$f":"user15","v":5},"yr",null,"loanTerm"]
[{"$f":"lblUser5","v":"What interest rate is charged for the loan? "},{"$f":"user5/100","v":0},null,null,"InterestRate"]
["Cap Cost Factors"]
[{"$f":"lblDefault7","v":"What is the contingency factor?"},{"$f":"default7/100","v":0.05}]
["What is the cost of electric power used by the project?",{"$f":"user2","v":0},"$/MWh"]
[{"$f":"lblDefault14","v":"What are the \"soft\" costs for the project?"},{"$f":"default14/100","v":0.05}]
["Annual Cost Factors"]
[{"$f":"lblDefault11","v":"What are the royalty and severance taxes?"},{"$f":"default11/100","v":0}]
[{"$f":"lblDefault15","v":"What is the validation, verification and transaction cost to monetize carbon credits?"},{"$f":"default15","v":0.5},"$/tCO2e"]
["2 - Feasibility Test"]
["heat available",{"$f":"B21","v":0},"mmBtu/h","this is downstream availability","heatAvailable"]
["heat needed",{"$f":"B23*B16*(gas13zz/100-B22)*B33/(16.6667*B16-(gas13zz*16.6666/100))","v":{"$error":"#DIV/0!"}},"mmBtu/h",null,"CMM needed by oxidizer",null,null,"16.6667 = ratio of 1000 cf/mcf divided by 60 min/hr for units conversion"]
["Supplemental methane volume consumed/hour",{"$f":"IF(OR(B50<B51,inputScenFlare=\"OF\",inputScenFlare=\"EF\"),B50*1000/B33/(1-B13),B51*1000/B33/(1-B13))","v":{"$error":"#DIV/0!"}},"mcf/h","incl prime mover, exclud fugitive"]
["CMM available for other uses",{"$f":"IF(OR(B51>B50, inputScenFlare=\"OF\",inputScenFlare=\"EF\",B19=0),0, B14-(B52*24/B19))","v":{"$error":"#DIV/0!"}},"mcfd","available at drainage wells","CmmAvailable"]
[]
["3 - Calculate Annual Benefits"]
["Carbon credits earned from VAM destruction per year",{"$f":"+B23*B24*B22*B34*(B36-2.75)*0.95*60","v":0},"tonnes/y"]
["Carbon credits from supplemental gas destruction per year",{"$f":"B52*B34*(B36-2.75)*B24","v":{"$error":"#DIV/0!"}},"tonnes/y"]
["Carbon credit revenue per year",{"$f":"(B56+B57-((B23+(B17*B19/24/60))*B24*B29*60*default9/1000))*B35/1000","v":{"$error":"#DIV/0!"}},"$000/y"]
["Total credits earned per year",{"$f":"supVAMcers1+supVAMcers2","v":{"$error":"#DIV/0!"}},"tonnes/y",null,"CERsEarnedPerYear"]
[]
[]
["4 - Calculate New Annual Costs"]
["Drain & transport O&M cost/yr",{"$f":"(IF(B16<>0,(B52*B32)/B16,0))*B24/1000","v":0},"$000/y"]
["Back-up Flare O&M cost/yr",{"$f":"IF(inputScenFlare=\"OF\",user22,IF(inputScenFlare=\"EF\",user20,0))","v":0},"$000/y"]
["VAM Oxidizer O&M",{"$f":"+(B23+(B17*B19/24/60))*B26*1000/1000","v":0},"$000/y"]
["VAM Oxidizer Electricity cost",{"$f":"(B23+(B17*B19/24/60))*B24*B29*B44*60/1000/1000","v":0},"$000/y"]
["Oxidizer Relocation cost",{"$f":"B28*(B23+(B17*B19/24/60))*1000/B27/1000","v":{"$error":"#DIV/0!"}},"$000/y"]
["Royalty and severance taxes cost/yr",{"$f":"((supvamCmmDrained*365*B47*3)+(B23*B22*60*B24*B47*3))/1000","v":0}]
["Carbon credit monetization cost/yr",{"$f":"B48*supvamCERsEarnedPerYear/1000","v":{"$error":"#DIV/0!"}},"$000/y"]
["Total annual cost",{"$f":"SUM(B63:B69)","v":{"$error":"#DIV/0!"}},"$000/y",null,"TotalAnnualCost"]
["5 - Calculate Project Capital Costs"]
["CMM needed per hour",{"$f":"B52","v":{"$error":"#DIV/0!"}},"mcf/h"]
["CMM transport system",{"$f":"IF(B16<>0,B31*B72*24/B16/1000,0)","v":0},"$000"]
["Installed Oxidizer Capital Cost",{"$f":"(B23+(B17*B19/24/60))*B25*1000/1000","v":0},"$000"]
["Back-up Flare capital cost",{"$f":"IF(inputScenFlare=\"OF\",B20*24*user21,IF(inputScenFlare=\"EF\",B20*24*user19,0))","v":0},"$000"]
["  Subtotal",{"$f":"SUM(B73:B75)","v":0},"$000"]
["Total cap cost with factors",{"$f":"(B76*(1+B45))*(1+B43)","v":0},"$000",null,"TotalCapCost"]
[]
["6 - Calculate Loan and Equity"]
["Loan amount",{"$f":"B77*(1-B39)","v":0},"$000",null,"LoanAmount"]
["Equity amount",{"$f":"B77*B39","v":0},"$000",null,"EquityAmount"]
[]
["7 - Discounted Cash Flow Analysis","($000)"]
["Years >>>",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["A - Benefits"]
[]
["Carbon Credit Revenues",null,null,{"$f":"IF(C$84<=$B$18,$B58,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(D$84<=$B$18,D87*(1+default8/100),0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0,0,0,0,0,0,0]
["Total Benefits",null,{"$f":"SUM(C86:C87)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0,0,0,0,0,0]
["B - Costs"]
["Oxidizer and supplemental CMM Annual Costs",null,{"$f":"IF(C$84<=$B$18,-B70,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(D$84<=$B$18,C90*(1+$B$37),0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0,0,0,0,0,0,0]
["C - Cash Flow from Operations",null,{"$f":"SUM(C88:C90)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0,0,0,0,0,0]
[]
["D - Debt Service",null,{"$f":"IF(OR(C$84>$B$40,C$84>$B$18),0, PMT($B$41, $B$40, $B$80))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["E - Net Cash Flow",{"$f":"-B81","v":0},{"$f":"SUM(C91:C93)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D91:D93)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0,0,0,0,0,0]
[]
["8 - Financial Measurements: IRR, NPV, Payback"]
["Internal Rate of Return - IRR",null,{"$f":"IF(ISERR(IRR($B94:V94)),0,IRR($B94:V94))","v":0}]
["Net Present Value",null,{"$f":"NPV(B38,C94:V94)+supvamMinusEquityAmount","v":{"$error":"#DIV/0!"}}]
["Payback Period",null,{"$f":"SUM(C101:V101)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF(B$84<=$B$18,SUM($B94:B94),0)","v":0},{"$f":"IF(C$84<=$B$18,SUM($B94:C94),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(D$84<=$B$18,SUM($B94:D94),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(E$84<=$B$18,SUM($B94:E94),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(F$84<=$B$18,SUM($B94:F94),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(G$84<=$B$18,SUM($B94:G94),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(H$84<=$B$18,SUM($B94:H94),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I$84<=$B$18,SUM($B94:I94),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(J$84<=$B$18,SUM($B94:J94),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(K$84<=$B$18,SUM($B94:K94),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(L$84<=$B$18,SUM($B94:L94),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(M$84<=$B$18,SUM($B94:M94),0)","v":0},{"$f":"IF(N$84<=$B$18,SUM($B94:N94),0)","v":0},{"$f":"IF(O$84<=$B$18,SUM($B94:O94),0)","v":0},{"$f":"IF(P$84<=$B$18,SUM($B94:P94),0)","v":0},{"$f":"IF(Q$84<=$B$18,SUM($B94:Q94),0)","v":0},{"$f":"IF(R$84<=$B$18,SUM($B94:R94),0)","v":0},{"$f":"IF(S$84<=$B$18,SUM($B94:S94),0)","v":0},{"$f":"IF(T$84<=$B$18,SUM($B94:T94),0)","v":0},{"$f":"IF(U$84<=$B$18,SUM($B94:U94),0)","v":0},{"$f":"IF(V$84<=$B$18,SUM($B94:V94),0)","v":0}]
[null,null,{"$f":"IF(AND(C100>0,B100<0),C84+(1-C100/C94),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D100>0,C100<0),D84+(1-D100/D94),0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0,0,0,0,0,0]

{"sheet":"StandaloneVAM","index":5,"n_rows":96,"n_cols":23,"rows_kept":96,"cut":false,"hidden":true,"merged":[[28,4,28,6]]}
["1 - INPUT PARAMETERS ","Values","units","Comment","Name","Default","Range"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"lblUser16","v":"What is the planned project operational lifetime?"},{"$f":"user16","v":10},"years",null,"projectlifetime"]
[]
[]
[]
["What percent methane is in the ventilation air?",{"$f":"gas9zz/100","v":0}]
["What do you expect the recoverable ventilation air flow to be?",{"$f":"gas10zz","v":0},"mcf/m"]
["How many hours per year will the VAM system operate?",{"$f":"default33","v":0},"hours/yr"]
["What is the installed capital cost of VAM oxidizer system?",{"$f":"user23","v":0},"$/cfm"]
["What is the annual O&M cost of the VAM oxidizer system?",{"$f":"user24","v":0},"$/cfm-yr"]
["What is the frequency VAM system will be relocated?",{"$f":"user25","v":0},"years"]
["What is the VAM oxidation system relocation cost?",{"$f":"user26","v":0},"$/cfm"]
["What is the electrical load of the oxidizer blowers?",{"$f":"user27","v":0},"kWh/mcf"]
[]
[]
[]
["CMM fuel value LHV",910,"Btu/cf","constant"]
["Weight of methane, tonnes",1.9259999999999999E-2,"tonnes/mcf","constant"]
[{"$f":"lblUser8","v":"What is the carbon credit unit sale price? "},{"$f":"user8","v":2},"$/tonne CO2E",null,"CER_UnitValue"]
["GWP ratio: methane to CO2",{"$f":"default20","v":25},"ratio","constant"]
[{"$f":"lblDefault21","v":"What is the inflation rate?"},{"$f":"default21/100","v":2.5000000000000001E-2},null,null,"InflationRate"]
[{"$f":"lblDefault26","v":"What is the real discount rate?"},{"$f":"default26/100","v":0.12},null,null,"RealDiscountRate"]
[{"$f":"lblUser12","v":"What is the developer's equity share in the project? "},{"$f":"user12/100","v":1},null,null,"EquityPercent"]
[{"$f":"lblUser15","v":"What is the loan term?"},{"$f":"user15","v":5},"yr",null,"loanTerm"]
[{"$f":"lblUser5","v":"What interest rate is charged for the loan? "},{"$f":"user5/100","v":0},null,null,"InterestRate"]
["Cap Cost Factors"]
[{"$f":"lblDefault7","v":"What is the contingency factor?"},{"$f":"default7/100","v":0.05}]
["What is the cost of electric power used by the project?",{"$f":"user2","v":0},"$/MWh"]
[{"$f":"lblDefault14","v":"What are the \"soft\" costs for the project?"},{"$f":"default14/100","v":0.05}]
["Annual Cost Factors"]
[{"$f":"lblDefault11","v":"What are the royalty and severance taxes?"},{"$f":"default11/100","v":0}]
[{"$f":"lblDefault15","v":"What is the validation, verification and transaction cost to monetize carbon credits?"},{"$f":"default15","v":0.5},"$/tCO2e"]
["2 - Feasibility Test"]
[]
["CMM Available (always 0 for Standalone VAM)",0]
[]
["3 - Calculate Annual Benefits:"]
["Carbon credits earned per year",{"$f":"+B23*60*B24*B22*B34*(B36-2.75)*0.95-(B23*B24*B29*60*default9/1000)","v":0},"tonnes CO2e/y",null,"CERsEarnedPerYear"]
["Carbon credit revenue per year",{"$f":"B54*B35/1000","v":0},"$000/y"]
[]
["4 - Calculate New Annual Costs:"]
["O&M cost",{"$f":"+B23*B26*1000/1000","v":0},"$000/y"]
["Electricity cost",{"$f":"B23*60*B24*B29*B44/1000/1000","v":0},"$000/y"]
["Relocation cost",{"$f":"B28*B23*1000/B27/1000","v":{"$error":"#DIV/0!"}},"$000/y"]
["Royalty and severance taxes",{"$f":"B23*60*B24*B22*3*B47/1000","v":0},null,"3 = $/mcf change to user input"]
["Carbon credit monetization cost/yr",{"$f":"B48*savamCERsEarnedPerYear/1000","v":0},"$000/y"]
["Total annual cost",{"$f":"SUM(B58:B62)","v":{"$error":"#DIV/0!"}},"$000/y",null,"TotalAnnualCost"]
[]
[]
["5 - Calculate Project Capital Costs"]
["Installed Capital Cost",{"$f":"B23*B25*1000/1000","v":0},"$000"]
["  Subtotal",{"$f":"B67","v":0},"$000"]
["Total cap cost with factors",{"$f":"(B68*(1+B43))*(1+B45)","v":0},"$000",null,"TotalCapCost"]
[]
[]
[]
[]
["6 - Calculate Loan and Equity"]
["Loan amount",{"$f":"B69*(1-B39)","v":0},"$000",null,"LoanAmount"]
["Equity amount",{"$f":"B69*B39","v":0},"$000",null,"EquityAmount"]
[]
["7 - Discounted Cash Flow Analysis","($000)"]
["Years >>>",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["A - Benefits"]
[]
["Carbon Credit Revenues",null,null,{"$f":"IF(C$79<=$B$18,$B55,0)","v":0},{"$f":"IF(D$79<=$B$18,D82*(1+default8/100),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Benefits",null,{"$f":"SUM(C81:C82)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["B - Costs"]
["Annual Costs",null,{"$f":"IF(C$79<=$B$18,-B63,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(D$79<=$B$18,C85*(1+$B$37),0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0,0,0,0,0,0,0]
["C - Cash Flow from Operations",null,{"$f":"SUM(C83:C85)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0,0,0,0,0,0,0]
[]
["D - Debt Service",null,{"$f":"IF(OR(C$79>$B$40,C$79>$B$18),0, PMT($B$41, $B$40, $B$75))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["E - Net Cash Flow",{"$f":"-B76","v":0},{"$f":"SUM(C86:C88)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D86:D88)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0,0,0,0,0,0,0]
[]
["8 - Financial Measurements: IRR, NPV, Payback"]
["Internal Rate of Return - IRR",null,{"$f":"IF(ISERR(IRR($B89:V89)),0,IRR($B89:V89))","v":0}]
["Net Present Value",null,{"$f":"NPV(B38,C89:V89)+savamMinusEquityAmount","v":{"$error":"#DIV/0!"}}]
["Payback Period",null,{"$f":"SUM(C96:V96)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF(B$79<=$B$18,SUM($B89:B89),0)","v":0},{"$f":"IF(C$79<=$B$18,SUM($B89:C89),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(D$79<=$B$18,SUM($B89:D89),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(E$79<=$B$18,SUM($B89:E89),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(F$79<=$B$18,SUM($B89:F89),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(G$79<=$B$18,SUM($B89:G89),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(H$79<=$B$18,SUM($B89:H89),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I$79<=$B$18,SUM($B89:I89),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(J$79<=$B$18,SUM($B89:J89),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(K$79<=$B$18,SUM($B89:K89),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(L$79<=$B$18,SUM($B89:L89),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(M$79<=$B$18,SUM($B89:M89),0)","v":0},{"$f":"IF(N$79<=$B$18,SUM($B89:N89),0)","v":0},{"$f":"IF(O$79<=$B$18,SUM($B89:O89),0)","v":0},{"$f":"IF(P$79<=$B$18,SUM($B89:P89),0)","v":0},{"$f":"IF(Q$79<=$B$18,SUM($B89:Q89),0)","v":0},{"$f":"IF(R$79<=$B$18,SUM($B89:R89),0)","v":0},{"$f":"IF(S$79<=$B$18,SUM($B89:S89),0)","v":0},{"$f":"IF(T$79<=$B$18,SUM($B89:T89),0)","v":0},{"$f":"IF(U$79<=$B$18,SUM($B89:U89),0)","v":0},{"$f":"IF(V$79<=$B$18,SUM($B89:V89),0)","v":0}]
[null,null,{"$f":"IF(AND(C95>0,B95<0),C79+(1-C95/C89),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D95>0,C95<0),D79+(1-D95/D89),0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0,0,0,0,0,0]

{"sheet":"MineBoiler","index":6,"n_rows":104,"n_cols":23,"rows_kept":104,"cut":false,"hidden":true,"merged":[]}
["1 - INPUT PARAMETERS ","Values","units","Comment","Name","Default","Range"]
[{"$f":"lblDrain1","v":"What is the cost of well-head blowers?"},{"$f":"drainage1","v":0},"$/HP"]
[{"$f":"lblDrain2","v":"What is the cost of satellite compressors?"},{"$f":"drainage2","v":1000},"$/HP"]
[{"$f":"lblDrain3","v":"What is the distance from the drainage area to the onsite project?"},{"$f":"drainage3","v":21000},"ft"]
[{"$f":"lblDrain4","v":"What is the cost of installing header pipe from the drainage area?"},{"$f":"drainage4","v":40},"$/ft"]
[{"$f":"lblDrain5","v":"What are the compressor and blower efficiencies?"},{"$f":"drainage5","v":3.5000000000000003E-2},"HP/mcfd"]
[{"$f":"lblDrain6","v":"What is the spacing between gob drainage wells?"},{"$f":"drainage6","v":1000},"ft"]
[{"$f":"lblDrain7","v":"What is the mining rate?"},{"$f":"drainage7","v":12000},"ft/yr"]
[{"$f":"lblDrain7alt","v":"How many drainage wells are being utilized?"},{"$f":"drainage7alt","v":0},"wells"]
["What is the drainage gas source?",{"$f":"inputDrainageSource","v":"GW"}]
[{"$f":"lblDrain8","v":"What is the mine depth?"},{"$f":"drainage8","v":0},"ft/well"]
[{"$f":"lblDrain9","v":"What is the drilling cost?"},{"$f":"drainage9","v":0},"$/ft"]
[{"$f":"lblUser18","v":"What percent of CMM is consumed by prime-mover use?"},{"$f":"user18/100","v":7.0000000000000007E-2}]
[{"$f":"lblGas1","v":"What do you expect the CMM drained per day to be?"},{"$f":"gas1zz","v":1250},"mcf/d",null,"boilerCmmDrained"]
["CMM drained per hour",{"$f":"B14/24","v":52.083333333333336},"mcf/h"]
[{"$f":"lblPctMethane","v":"Percent methane in drainage gas"},{"$f":"inputPctMethane/100","v":0.9},null,"Use 40% for Boiler Feasibility Test"]
["Actual gas flow",{"$f":"IF(B16<>0,B14/B16,0)","v":1388.8888888888889},"mcf/d"]
[{"$f":"lblUser16","v":"What is the planned project operational lifetime?"},{"$f":"user16","v":10},"years",null,"boilerProjectLifetime"]
[{"$f":"lblGas6","v":"What is the fraction of CMM available after losses?"},{"$f":"gas6zz/100","v":0.95}]
["Average fuel available",{"$f":"B15*(B19-B13)","v":45.833333333333329},"mcf/h"]
["Fuel value",{"$f":"B20*B33/1000","v":41.708333333333329},"mmBtu/h"]
[{"$f":"lblGas5","v":"What is the boiler capacity?"},{"$f":"gas5zz","v":0},"mmBtu/h","Input via Gas Availability Page"]
[{"$f":"lblDefault3","v":"How many hours per year will the mine boiler operate?"},{"$f":"default3","v":0},"hours/yr",null,null,8000,"7500-8300"]
[{"$f":"lblGas7","v":"What is the average boiler load?"},{"$f":"gas7zz","v":0},"mmBtu/h","Input via Gas Availability Page"]
[{"$f":"lblUser11","v":"What is the capital cost to convert the coal boiler to gas?"},{"$f":"user11","v":0},"$000/(mmBtu/h)","User Defined Input Page",null,7.5,"[5-13]"]
[]
[{"$f":"lblUser10","v":"What is the cost per ton of coal replaced by gas?"},{"$f":"user10","v":0},"$/ton","User Defined Input Page"]
[{"$f":"lblDefault31","v":"What is the avoided coal handling cost? "},{"$f":"default31","v":0},"$/ton","Default Parameter"]
[{"$f":"lblDefault32","v":"What is the replaced coal's fuel value?"},{"$f":"default32","v":0},"mmBtu/ton","Default Parameter"]
[{"$f":"lblDrain10","v":"What is the fraction of this project's drainage system cost that will be included in the analysis?"},{"$f":"drainage10/100","v":0},null,"added by JC 6/25"]
["Drainage and Transport sys unit cap cost",{"$f":"IF((B14*B19)<>0,(B3*B6)+(B4*B5*B16/(B14*B19))+(IF(B10=\"AM\",B7*B5*B9*B16/(B14*B19),0))+\n(B30*IF(inputDrainageSystem=\"Y\",(B2*B6)+IF(B10=\"AM\",B11*B12*B9*B16/(B14*B19),0),0)),0)","v":671.63157894736844},"$/mcfd","\"X\", tweaked by JC 6/25"]
["Drainage and Transport O&M cost",{"$f":"IF(AND(inputDrainageSource=\"GW\",(B14*B19)<>0,B23<>0),((B8*B5)+IF(AND(inputDrainageSystem=\"Y\",B7<>0),B8*B11*B12*B30/B7,0))*B16*24/(B14*B19)/B23,0)","v":0},"$/mcf","\"Y\", tweaked by JC 6/25"]
["CMM fuel value LHV",910,"Btu/cf","constant"]
["Weight of methane, tonnes",1.9259999999999999E-2,"tonnes/mcf","constant"]
[{"$f":"lblUser8","v":"What is the carbon credit unit sale price? "},{"$f":"user8","v":2},"$/tonne CO2E",null,"CER_UnitValue"]
["GWP ratio: methane to CO2",{"$f":"default20","v":25},"ratio","constant"]
[{"$f":"lblDefault21","v":"What is the inflation rate?"},{"$f":"default21/100","v":2.5000000000000001E-2},null,null,"InflationRate"]
[{"$f":"lblDefault26","v":"What is the real discount rate?"},{"$f":"default26/100","v":0.12},null,null,"RealDiscountRate"]
[{"$f":"lblUser12","v":"What is the developer's equity share in the project? "},{"$f":"user12/100","v":1},null,null,"EquityPercent"]
[{"$f":"lblUser15","v":"What is the loan term?"},{"$f":"user15","v":5},"yr",null,"loanTerm"]
[{"$f":"lblUser5","v":"What interest rate is charged for the loan? "},{"$f":"user5/100","v":0},null,null,"InterestRate"]
["Cap Cost Factors"]
[{"$f":"lblDefault7","v":"What is the contingency factor?"},{"$f":"default7/100","v":0.05}]
[{"$f":"lblDefault14","v":"What are the \"soft\" costs for the project?"},{"$f":"default14/100","v":0.05}]
["Annual Cost Factors"]
[{"$f":"lblDefault11","v":"What are the royalty and severance taxes?"},{"$f":"default11/100","v":0}]
[{"$f":"lblDefault15","v":"What is the validation, verification and transaction cost to monetize carbon credits?"},{"$f":"default15","v":0.5},"$/tCO2e"]
[]
["2 - Feasibility Test"]
["CMM heat value available/hour",{"$f":"B21","v":41.708333333333329},"mmBtu/h","this is downstream availability","heatAvailable"]
["Average Mine Boiler Heat Load",{"$f":"B24","v":0},"mmBtu/h",null,"heatNeeded"]
["CMM volume needed/hour",{"$f":"IF(OR(B50<B51,inputScenFlare=\"OF\",inputScenFlare=\"EF\"),B50*1000/B33/(1-B13),B51*1000/B33/(1-B13))","v":0},"mcf/h","incl prime mover, exclud fugitive"]
["CMM available for other uses",{"$f":"IF(OR(B51>B50, inputScenFlare=\"OF\",inputScenFlare=\"EF\",B19=0),0, B14-(B52*24/B19))","v":1250},"mcfd","available at drainage wells","boilerCmmAvailable"]
[]
["3 - Calculate Annual Benefits"]
["Tons of coal replaced per hour",{"$f":"IF(B29<>0,IF(B50<B51,B50/B29,B51/B29),0)","v":0},"ton/h"]
["Cost savings per hour - coal ",{"$f":"B56*(B27+B28)","v":0},"$/h"]
["Cost savings per year - coal ",{"$f":"B57*B23/1000","v":0},"$000/y"]
["CMM volume needed/hour",{"$f":"B52","v":0},"mcf/h"]
["Tonnes CH4 needed/hour",{"$f":"B59*B34","v":0},"t/h"]
["Carbon credits earned per hour",{"$f":"B60*(B36+2)","v":0},"t/h"]
["Carbon credits earned per year",{"$f":"B61*B23","v":0},"t/y",null,"CERsEarnedPerYear"]
["Carbon credit revenue per year",{"$f":"B62*B35/1000","v":0},"$000/y"]
[]
["4 - Calculate New Annual Costs"]
["CMM needed per hour",{"$f":"B52","v":0},"mcf/h"]
["Drain & transport O&M cost/h",{"$f":"IF(B16<>0,(B66*B32)/B16,0)","v":0},"$/h"]
["Drain & transport O&M cost/yr",{"$f":"B67*B23/1000","v":0},"$000/y"]
["Back-up Flare O&M cost/yr",{"$f":"IF(inputScenFlare=\"OF\",user22,IF(inputScenFlare=\"EF\",user20,0))","v":0}]
["Royalty and severance taxes cost/yr",{"$f":"boilerCmmDrained*365*B46*3/1000","v":0},null,"3 = $/mcf change to user input"]
["Carbon credit monetization cost/yr",{"$f":"B47*boilerCERsEarnedPerYear/1000","v":0}]
["Total annual cost",{"$f":"SUM(B68:B71)","v":0},"$000/y",null,"TotalAnnualCost"]
[]
["5 - Calculate Project Capital Costs"]
["CMM needed per hour",{"$f":"B52","v":0},"mcf/h"]
["CMM transport system",{"$f":"IF(B16<>0,B31*B75*24/B16/1000,0)","v":0},"$000"]
["Cost to Convert Convert Boiler to Burn CMM",{"$f":"IF(B50<B51, B50*B25,B22*B25)","v":0},"$000"]
["Back-up Flare capital cost",{"$f":"IF(inputScenFlare=\"OF\",B20*24*user21,IF(inputScenFlare=\"EF\",B20*24*user19,0))","v":0}]
["  Subtotal",{"$f":"SUM(B76:B78)","v":0},"$000"]
["Total cap cost with factors",{"$f":"(B79*(1+B44))*(1+B43)","v":0},"$000",null,"TotalCapCost"]
[]
["6 - Calculate Loan and Equity"]
["Loan amount",{"$f":"B80*(1-B39)","v":0},"$000",null,"LoanAmount"]
["Equity amount",{"$f":"B80*B39","v":0},"$000",null,"EquityAmount"]
[]
["7 - Discounted Cash Flow Analysis","($000)"]
["Years >>>",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["A - Benefits"]
["Coal savings",null,{"$f":"IF(C$87<=$B$18,B58,0)","v":0},{"$f":"IF(D$87<=$B$18,C89*(1+$B$37),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Carbon Credit Revenues",null,null,{"$f":"IF(C$87<=$B$18,$B63,0)","v":0},{"$f":"IF(D$87<=$B$18,D90*(1+default8/100),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Benefits",null,{"$f":"SUM(C89:C90)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["B - Costs"]
["CMM transport cost + drain share",null,{"$f":"IF(C$87<=$B$18,-B72,0)","v":0},{"$f":"IF(D$87<=$B$18,C93*(1+$B$37),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["C - Cash Flow from Operations",null,{"$f":"SUM(C91:C93)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["D - Debt Service",null,{"$f":"IF(OR(C$87>$B$40,C$87>$B$18),0, PMT($B$41, $B$40, $B$83))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["E - Net Cash Flow",{"$f":"-B84","v":0},{"$f":"SUM(C94:C96)","v":0},{"$f":"SUM(D94:D96)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["8 - Financial Measurements: IRR, NPV, Payback"]
["Internal Rate of Return - IRR",null,{"$f":"IF(ISERR(IRR($B97:V97)),0,IRR($B97:V97))","v":0}]
["Net Present Value",null,{"$f":"NPV(B38,C97:V97)+boilerMinusEquityAmount","v":0}]
["Payback Period",null,{"$f":"SUM(C104:V104)","v":0}]
[null,{"$f":"IF(B$87<=$B$18,SUM($B97:B97),0)","v":0},{"$f":"IF(C$87<=$B$18,SUM($B97:C97),0)","v":0},{"$f":"IF(D$87<=$B$18,SUM($B97:D97),0)","v":0},{"$f":"IF(E$87<=$B$18,SUM($B97:E97),0)","v":0},{"$f":"IF(F$87<=$B$18,SUM($B97:F97),0)","v":0},{"$f":"IF(G$87<=$B$18,SUM($B97:G97),0)","v":0},{"$f":"IF(H$87<=$B$18,SUM($B97:H97),0)","v":0},{"$f":"IF(I$87<=$B$18,SUM($B97:I97),0)","v":0},{"$f":"IF(J$87<=$B$18,SUM($B97:J97),0)","v":0},{"$f":"IF(K$87<=$B$18,SUM($B97:K97),0)","v":0},{"$f":"IF(L$87<=$B$18,SUM($B97:L97),0)","v":0},{"$f":"IF(M$87<=$B$18,SUM($B97:M97),0)","v":0},{"$f":"IF(N$87<=$B$18,SUM($B97:N97),0)","v":0},{"$f":"IF(O$87<=$B$18,SUM($B97:O97),0)","v":0},{"$f":"IF(P$87<=$B$18,SUM($B97:P97),0)","v":0},{"$f":"IF(Q$87<=$B$18,SUM($B97:Q97),0)","v":0},{"$f":"IF(R$87<=$B$18,SUM($B97:R97),0)","v":0},{"$f":"IF(S$87<=$B$18,SUM($B97:S97),0)","v":0},{"$f":"IF(T$87<=$B$18,SUM($B97:T97),0)","v":0},{"$f":"IF(U$87<=$B$18,SUM($B97:U97),0)","v":0},{"$f":"IF(V$87<=$B$18,SUM($B97:V97),0)","v":0}]
[null,null,{"$f":"IF(AND(C103>0,B103<0),C87+(1-C103/C97),0)","v":0},{"$f":"IF(AND(D103>0,C103<0),D87+(1-D103/D97),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"RecipEngines","index":7,"n_rows":103,"n_cols":23,"rows_kept":103,"cut":false,"hidden":true,"merged":[]}
["1 - INPUT PARAMETERS ","Values","units","Comment","Name","Default","Range"]
[{"$f":"lblDrain1","v":"What is the cost of well-head blowers?"},{"$f":"drainage1","v":0},"$/HP"]
[{"$f":"lblDrain2","v":"What is the cost of satellite compressors?"},{"$f":"drainage2","v":1000},"$/HP"]
[{"$f":"lblDrain3","v":"What is the distance from the drainage area to the onsite project?"},{"$f":"drainage3","v":21000},"ft"]
[{"$f":"lblDrain4","v":"What is the cost of installing header pipe from the drainage area?"},{"$f":"drainage4","v":40},"$/ft"]
[{"$f":"lblDrain5","v":"What are the compressor and blower efficiencies?"},{"$f":"drainage5","v":3.5000000000000003E-2},"HP/mcfd"]
[{"$f":"lblDrain6","v":"What is the spacing between gob drainage wells?"},{"$f":"drainage6","v":1000},"ft"]
[{"$f":"lblDrain7","v":"What is the mining rate?"},{"$f":"drainage7","v":12000},"ft/yr"]
[{"$f":"lblDrain7alt","v":"How many drainage wells are being utilized?"},{"$f":"drainage7alt","v":0},"wells"]
["What is the drainage gas source?",{"$f":"inputDrainageSource","v":"GW"}]
[{"$f":"lblDrain8","v":"What is the mine depth?"},{"$f":"drainage8","v":0},"ft/well"]
[{"$f":"lblDrain9","v":"What is the drilling cost?"},{"$f":"drainage9","v":0},"$/ft"]
[{"$f":"lblUser18","v":"What percent of CMM is consumed by prime-mover use?"},{"$f":"user18/100","v":7.0000000000000007E-2},null,"What is this exactly?"]
[{"$f":"lblGas1","v":"What do you expect the CMM drained per day to be?"},{"$f":"gas1zz","v":1250},"mcf/d"]
["CMM drained per hour",{"$f":"B14/24","v":52.083333333333336},"mcf/h"]
[{"$f":"lblPctMethane","v":"Percent methane in drainage gas"},{"$f":"inputPctMethane/100","v":0.9},null,"Use 25% for Engine Feasibility Test"]
["Actual gas flow",{"$f":"IF(B16<>0,B14/B16,0)","v":1388.8888888888889},"mcf/d"]
[{"$f":"lblUser16","v":"What is the planned project operational lifetime?"},{"$f":"user16","v":10},"years",null,"engineProjectLifetime"]
[{"$f":"lblGas6","v":"What is the fraction of CMM available after losses?"},{"$f":"gas6zz/100","v":0.95}]
["Average fuel available",{"$f":"B15*(B19-B13)","v":45.833333333333329},"mcf/h"]
["Fuel value",{"$f":"B20*B33/1000","v":41.708333333333329},"mmBtu/h"]
[{"$f":"lblUser6","v":"What is the overall efficiency of the engine-generator set?"},{"$f":"user6/100","v":0.35},"Based on LHV","User Defined Input Page",null,null,"30% - 44%"]
[{"$f":"lblDefault4","v":"How many hours per year will the engine operate?"},{"$f":"default4","v":8000},"hours/yr","Default Parameter",null,8000,"7500-8300"]
[]
[{"$f":"lblUser3","v":"Capital cost of treatment, engine-gen set, & electrical equipment?"},{"$f":"user3","v":1.1499999999999999},"$000/kW","User Defined Input Page",null,1.3,"1.100-1.500"]
[{"$f":"lblUser4","v":"What is the O&M cost of the reciprocating engine?"},{"$f":"user4","v":0.02},"$/kWh","User Defined Input Page",null,0.02,"0.015 - 0.03"]
[{"$f":"lblUser1","v":"For what price can CMM-based electricity be sold?"},{"$f":"user1","v":7.0000000000000007E-2},"$/kWh","User Defined Input Page",null,7.0000000000000007E-2,"0.04 - 0.1"]
[]
[]
[{"$f":"lblDrain10","v":"What is the fraction of this project's drainage system cost that will be included in the analysis?"},{"$f":"drainage10/100","v":0},null,"added by JC 6/25"]
["Drainage and Transport sys unit cap cost",{"$f":"IF((B14*B19)<>0,(B3*B6)+(B4*B5*B16/(B14*B19))+(IF(B10=\"AM\",B7*B5*B9*B16/(B14*B19),0))+\n(B30*IF(inputDrainageSystem=\"Y\",(B2*B6)+IF(B10=\"AM\",B11*B12*B9*B16/(B14*B19),0),0)),0)","v":671.63157894736844},"$/mcfd","\"X\", tweaked by JC 6/25"]
["Drainage and Transport O&M cost",{"$f":"IF(AND(inputDrainageSource=\"GW\",(B14*B19)<>0,B23<>0),((B8*B5)+IF(AND(inputDrainageSystem=\"Y\",B7<>0),B8*B11*B12*B30/B7,0))*B16*24/(B14*B19)/B23,0)","v":1.0913684210526318},"$/mcf","\"Y\", tweaked by JC 6/25"]
["CMM fuel value LHV",910,"Btu/cf","constant"]
["Weight of methane, tonnes",1.9259999999999999E-2,"tonnes/mcf","constant"]
[{"$f":"lblUser8","v":"What is the carbon credit unit sale price? "},{"$f":"user8","v":2},"$/tonne CO2E",null,"CER_UnitValue"]
["GWP ratio: methane to CO2",{"$f":"default20","v":25},"ratio","constant"]
[{"$f":"lblDefault21","v":"What is the inflation rate?"},{"$f":"default21/100","v":2.5000000000000001E-2},null,null,"InflationRate"]
[{"$f":"lblDefault26","v":"What is the real discount rate?"},{"$f":"default26/100","v":0.12},null,null,"RealDiscountRate"]
[{"$f":"lblUser12","v":"What is the developer's equity share in the project? "},{"$f":"user12/100","v":1},null,null,"EquityPercent"]
[{"$f":"lblUser15","v":"What is the loan term?"},{"$f":"user15","v":5},"yr",null,"loanTerm"]
[{"$f":"lblUser5","v":"What interest rate is charged for the loan? "},{"$f":"user5/100","v":0},null,null,"InterestRate"]
["Cap Cost Factors"]
[{"$f":"lblDefault7","v":"What is the contingency factor?"},{"$f":"default7/100","v":0.05}]
[{"$f":"lblDefault14","v":"What are the \"soft\" costs for the project?"},{"$f":"default14/100","v":0.05}]
["Annual Cost Factors"]
[{"$f":"lblDefault11","v":"What are the royalty and severance taxes?"},{"$f":"default11/100","v":0}]
[{"$f":"lblDefault15","v":"What is the validation, verification and transaction cost to monetize carbon credits?"},{"$f":"default15","v":0.5},"$/tCO2e"]
[]
["2 - Feasibility Test"]
["CMM heat value available/hour",{"$f":"B21","v":41.708333333333329},"mmBtu/h","this is downstream availability"]
[]
["CMM volume needed/hour",{"$f":"B50*1000/B33/(1-B13)","v":49.283154121863795},"mcf/h","incl prime mover, exclud fugitive"]
["CMM available for other uses",0,"mcfd","available at drainage wells","cmmAvailable"]
[]
["3 - Calculate Annual Benefits"]
["Engine Capacity",{"$f":"B50*B22/3.412","v":4.2784046502540054},"MW","New Item for two Output vehicles"]
["Annual Electricity Production",{"$f":"B56*B23","v":34227.23720203204},"MWh"]
["Annual Revenue from Sale of Electricity",{"$f":"B27*B57","v":2395.9066041422429},"$000","New Item for two Output vehicles"]
["CMM volume needed/hour",{"$f":"B52","v":49.283154121863795},"mcf/h"]
["Tonnes CH4 needed/hour",{"$f":"B59*B34","v":0.94919354838709669},"t/h"]
["Carbon credits earned per hour",{"$f":"B60*(B36-2.75)","v":21.119556451612901},"t/h"]
["Carbon credits earned per year",{"$f":"B61*B23","v":168956.45161290321},"t/y",null,"coalCERsEarnedPerYear"]
["Carbon credit revenue per year",{"$f":"B62*B35/1000","v":337.91290322580642},"$000/y"]
[]
["4 - Calculate New Annual Costs"]
["Engine O&M cost",{"$f":"B57*B26","v":684.54474404064081},"$000/y"]
["Drain & transport O&M cost/h",{"$f":"IF(B16<>0,(B52*B32)/B16,0)","v":59.76230899830221},"$/h"]
["Drain & transport O&M cost/y",{"$f":"B67*B23/1000","v":478.09847198641768},"$000/y"]
["Carbon credit monetization cost/yr",{"$f":"B47*engineCERsEarnedPerYear/1000","v":84.478225806451604},"$000/y"]
["Royalty and severance taxes",{"$f":"B46*B14*365*3/1000","v":0},"$000/y","3 in equation = $3/mcf.  Hardwired gas cost. Change to user input?"]
["Total annual cost",{"$f":"B68+B66+B69+B70","v":1247.1214418335101},"$000/y",null,"coalTotalAnnualCost"]
[]
["5 - Calculate Project Capital Costs"]
["CMM needed per hour",{"$f":"B52","v":49.283154121863795},"mcf/h"]
["CMM transport system",{"$f":"IF(B16<>0,B31*B74*24/B16/1000,0)","v":882.66993648997038},"$000"]
["Installed Cost of Engine-Generator Sets",{"$f":"B56*B25*1000","v":4920.1653477921063},"$000"]
["--"]
["  Subtotal",{"$f":"SUM(B75:B76)","v":5802.8352842820768},"$000"]
["Total cap cost with factors",{"$f":"(B78*(1+B44))*(1+B43)","v":6397.6259009209898},"$000",null,"coalTotalCapCost"]
[]
["6 - Calculate Loan and Equity"]
["Loan amount",{"$f":"B79*(1-B39)","v":0},"$000",null,"LoanAmount"]
["Equity amount",{"$f":"B79*B39","v":6397.6259009209898},"$000",null,"coalEquityAmount"]
[]
["7 - Discounted Cash Flow Analysis","($000)"]
["Years >>>",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["A - Benefits"]
["Electricity Revenues",null,{"$f":"IF(C$86<=$B$18,B58,0)","v":2395.9066041422429},{"$f":"IF(D$86<=$B$18,C88*(1+$B$37),0)","v":2455.8042692457989},2517.1993759769434,2580.129360376367,2644.632594385776,2710.7484092454201,2778.5171194765553,2847.980047463469,2919.1795486500555,2992.1590373663066,0,0,0,0,0,0,0,0,0,0]
["Carbon Credit Revenues",null,null,{"$f":"IF(C$86<=$B$18,$B63,0)","v":337.91290322580642},{"$f":"IF(D$86<=$B$18,D89*(1+default8/100),0)","v":344.67116129032257},351.564584516129,358.59587620645158,365.76779373058059,373.0831496051922,380.54481259729607,388.15570884924199,395.91882302622685,403.83719948675139,0,0,0,0,0,0,0,0,0,0]
["Total Benefits",null,{"$f":"SUM(C88:C89)","v":2395.9066041422429},{"$f":"SUM(D88:D89)","v":2793.7171724716054},2861.8705372672662,2931.6939448924959,3003.2284705922275,3076.5162029760008,3151.6002690817477,3228.5248600607651,3307.3352574992973,3388.0778603925337,403.83719948675139,0,0,0,0,0,0,0,0,0]
["B - Costs"]
["Annual Drainage and Engine O&M Cost",null,{"$f":"IF(C$86<=$B$18,-B71,0)","v":-1247.1214418335101},{"$f":"IF(D$86<=$B$18,C92*(1+$B$37),0)","v":-1278.2994778793477},-1310.2569648263313,-1343.0133889469896,-1376.5887236706642,-1411.0034417624306,-1446.2785278064912,-1482.4354910016534,-1519.4963782766947,-1557.483787733612,0,0,0,0,0,0,0,0,0,0]
["C - Cash Flow from Operations",null,{"$f":"SUM(C90:C92)","v":1148.7851623087329},1515.4176945922577,1551.6135724409348,1588.6805559455063,1626.6397469215633,1665.5127612135702,1705.3217412752565,1746.0893690591117,1787.8388792226026,1830.5940726589217,403.83719948675139,0,0,0,0,0,0,0,0,0]
[]
["D - Debt Service",null,{"$f":"IF(OR(C$86>$B$40,C$86>$B$18),0, PMT($B$41, $B$40, $B$82))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["E - Net Cash Flow",{"$f":"-B83","v":-6397.6259009209898},{"$f":"SUM(C93:C95)","v":1148.7851623087329},{"$f":"SUM(D93:D95)","v":1515.4176945922577},1551.6135724409348,1588.6805559455063,1626.6397469215633,1665.5127612135702,1705.3217412752565,1746.0893690591117,1787.8388792226026,1830.5940726589217,403.83719948675139,0,0,0,0,0,0,0,0,0]
[]
["8 - Financial Measurements: IRR, NPV, Payback"]
["Internal Rate of Return - IRR",null,{"$f":"IF(ISERR(IRR($B96:V96)),0,IRR($B96:V96))","v":0.20278912135890348}]
["Net Present Value",null,{"$f":"NPV(B38,C96:V96)+engineMinusEquityAmount","v":2543.8252550984635}]
["Payback Period",null,{"$f":"SUM(C103:V103)","v":5.3646344660863372}]
[null,{"$f":"IF(B$86<=$B$18,SUM($B96:B96),0)","v":-6397.6259009209898},{"$f":"IF(C$86<=$B$18,SUM($B96:C96),0)","v":-5248.8407386122572},{"$f":"IF(D$86<=$B$18,SUM($B96:D96),0)","v":-3733.4230440199995},{"$f":"IF(E$86<=$B$18,SUM($B96:E96),0)","v":-2181.8094715790648},{"$f":"IF(F$86<=$B$18,SUM($B96:F96),0)","v":-593.12891563355856},{"$f":"IF(G$86<=$B$18,SUM($B96:G96),0)","v":1033.5108312880047},{"$f":"IF(H$86<=$B$18,SUM($B96:H96),0)","v":2699.023592501575},{"$f":"IF(I$86<=$B$18,SUM($B96:I96),0)","v":4404.3453337768315},{"$f":"IF(J$86<=$B$18,SUM($B96:J96),0)","v":6150.4347028359434},{"$f":"IF(K$86<=$B$18,SUM($B96:K96),0)","v":7938.2735820585458},{"$f":"IF(L$86<=$B$18,SUM($B96:L96),0)","v":9768.8676547174673},{"$f":"IF(M$86<=$B$18,SUM($B96:M96),0)","v":0},{"$f":"IF(N$86<=$B$18,SUM($B96:N96),0)","v":0},{"$f":"IF(O$86<=$B$18,SUM($B96:O96),0)","v":0},{"$f":"IF(P$86<=$B$18,SUM($B96:P96),0)","v":0},{"$f":"IF(Q$86<=$B$18,SUM($B96:Q96),0)","v":0},{"$f":"IF(R$86<=$B$18,SUM($B96:R96),0)","v":0},{"$f":"IF(S$86<=$B$18,SUM($B96:S96),0)","v":0},{"$f":"IF(T$86<=$B$18,SUM($B96:T96),0)","v":0},{"$f":"IF(U$86<=$B$18,SUM($B96:U96),0)","v":0},{"$f":"IF(V$86<=$B$18,SUM($B96:V96),0)","v":0}]
[null,null,{"$f":"IF(AND(C102>0,B102<0),C86+(1-C102/C96),0)","v":0},{"$f":"IF(AND(D102>0,C102<0),D86+(1-D102/D96),0)","v":0},0,0,5.3646344660863372,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"EnclosedFlare","index":8,"n_rows":103,"n_cols":23,"rows_kept":103,"cut":false,"hidden":true,"merged":[]}
["1 - INPUT PARAMETERS ","Values","units","Comment","Name","Default","Range"]
[{"$f":"lblDrain1","v":"What is the cost of well-head blowers?"},{"$f":"drainage1","v":0},"$/HP"]
[{"$f":"lblDrain2","v":"What is the cost of satellite compressors?"},{"$f":"drainage2","v":1000},"$/HP"]
[{"$f":"lblDrain3","v":"What is the distance from the drainage area to the onsite project?"},{"$f":"drainage3","v":21000},"ft"]
[{"$f":"lblDrain4","v":"What is the cost of installing header pipe from the drainage area?"},{"$f":"drainage4","v":40},"$/ft"]
[{"$f":"lblDrain5","v":"What are the compressor and blower efficiencies?"},{"$f":"drainage5","v":3.5000000000000003E-2},"HP/mcfd"]
[{"$f":"lblDrain6","v":"What is the spacing between gob drainage wells?"},{"$f":"drainage6","v":1000},"ft"]
[{"$f":"lblDrain7","v":"What is the mining rate?"},{"$f":"drainage7","v":12000},"ft/yr"]
[{"$f":"lblDrain7alt","v":"How many drainage wells are being utilized?"},{"$f":"drainage7alt","v":0},"wells"]
["What is the drainage gas source?",{"$f":"inputDrainageSource","v":"GW"}]
[{"$f":"lblDrain8","v":"What is the mine depth?"},{"$f":"drainage8","v":0},"ft/well"]
[{"$f":"lblDrain9","v":"What is the drilling cost?"},{"$f":"drainage9","v":0},"$/ft"]
[{"$f":"lblUser18","v":"What percent of CMM is consumed by prime-mover use?"},{"$f":"user18/100","v":7.0000000000000007E-2}]
[{"$f":"lblGas1","v":"What do you expect the CMM drained per day to be?"},{"$f":"gas1zz","v":1250},"mcf/d"]
["CMM drained per hour",{"$f":"B14/24","v":52.083333333333336},"mcf/h"]
[{"$f":"lblPctMethane","v":"Percent methane in drainage gas"},{"$f":"inputPctMethane/100","v":0.9},null,"Use 30% for Flare Feasibility Test"]
["Actual gas flow",{"$f":"IF(B16<>0,B14/B16,0)","v":1388.8888888888889},"mcf/d"]
[{"$f":"lblUser16","v":"What is the planned project operational lifetime?"},{"$f":"user16","v":10},"years",null,"cflareProjectLifetime"]
[{"$f":"lblGas6","v":"What is the fraction of CMM available after losses?"},{"$f":"gas6zz/100","v":0.95}]
["Average fuel available",{"$f":"B15*(B19-B13)","v":45.833333333333329},"mcf/h"]
["Fuel value",{"$f":"B20*B33/1000","v":41.708333333333329},"mmBtu/h"]
[]
[{"$f":"lblDefault2","v":"How many hours per year will the flare operate?"},{"$f":"default2","v":0},"hours/yr",null,null,8000,"7500-8300"]
[]
[{"$f":"lblUser19","v":"What is the capital cost of the enclosed flare?"},{"$f":"user19","v":0},"$000/mcfd","User Defined Input Page",null,0.28000000000000003,"0.12-0.45"]
[{"$f":"lblUser20","v":"What is the O&M cost of the enclosed flare?"},{"$f":"user20","v":0},"$000/yr","User Defined Input Page",null,15,"10-20"]
[]
[]
[]
[{"$f":"lblDrain10","v":"What is the fraction of this project's drainage system cost that will be included in the analysis?"},{"$f":"drainage10/100","v":0},null,"added by JC 6/25"]
["Drainage and Transport sys unit cap cost",{"$f":"IF((B14*B19)<>0,(B3*B6)+(B4*B5*B16/(B14*B19))+(IF(B10=\"AM\",B7*B5*B9*B16/(B14*B19),0))+\n(B30*IF(inputDrainageSystem=\"Y\",(B2*B6)+IF(B10=\"AM\",B11*B12*B9*B16/(B14*B19),0),0)),0)","v":671.63157894736844},"$/mcfd","\"X\", tweaked by JC 6/25"]
["Drainage and Transport O&M cost",{"$f":"IF(AND(inputDrainageSource=\"GW\",(B14*B19)<>0,B23<>0),((B8*B5)+IF(AND(inputDrainageSystem=\"Y\",B7<>0),B8*B11*B12*B30/B7,0))*B16*24/(B14*B19)/B23,0)","v":0},"$/mcf","\"Y\", tweaked by JC 6/25"]
["CMM fuel value LHV",910,"Btu/cf","constant"]
["Weight of methane, tonnes",1.9259999999999999E-2,"tonnes/mcf","constant"]
[{"$f":"lblUser8","v":"What is the carbon credit unit sale price? "},{"$f":"user8","v":2},"$/tonne CO2E",null,"CER_UnitValue"]
["GWP ratio: methane to CO2",{"$f":"default20","v":25},"ratio","constant"]
[{"$f":"lblDefault21","v":"What is the inflation rate?"},{"$f":"default21/100","v":2.5000000000000001E-2},null,null,"InflationRate"]
[{"$f":"lblDefault26","v":"What is the real discount rate?"},{"$f":"default26/100","v":0.12},null,null,"RealDiscountRate"]
[{"$f":"lblUser12","v":"What is the developer's equity share in the project? "},{"$f":"user12/100","v":1},null,null,"EquityPercent"]
[{"$f":"lblUser15","v":"What is the loan term?"},{"$f":"user15","v":5},"yr",null,"loanTerm"]
[{"$f":"lblUser5","v":"What interest rate is charged for the loan? "},{"$f":"user5/100","v":0},null,null,"InterestRate"]
["Cap Cost Factors"]
[{"$f":"lblDefault7","v":"What is the contingency factor?"},{"$f":"default7/100","v":0.05}]
[{"$f":"lblDefault14","v":"What are the \"soft\" costs for the project?"},{"$f":"default14/100","v":0.05}]
["Annual Cost Factors"]
[{"$f":"lblDefault11","v":"What are the royalty and severance taxes?"},{"$f":"default11/100","v":0}]
[{"$f":"lblDefault15","v":"What is the validation, verification and transaction cost to monetize carbon credits?"},{"$f":"default15","v":0.5},"$/tCO2e"]
[]
["2 - Feasibility Test"]
["CMM heat value available/hour",{"$f":"B21","v":41.708333333333329},"mmBtu/h","this is downstream availability"]
[]
["CMM volume needed/hour",{"$f":"B50*1000/B33/(1-B13)","v":49.283154121863795},"mcf/h","incl prime mover, exclud fugitive"]
["CMM available for other uses",0,"mcfd","available at drainage wells","cmmAvailable"]
[]
["3 - Calculate Annual Benefits"]
[]
[]
[]
["CMM volume needed/hour",{"$f":"B52","v":49.283154121863795},"mcf/h"]
["Tonnes CH4 needed/hour",{"$f":"B59*B34","v":0.94919354838709669},"t/h"]
["Carbon credits earned per hour",{"$f":"B60*(B36-2.75)","v":21.119556451612901},"t/h"]
["Carbon credits earned per year",{"$f":"B61*B23","v":0},"t/y",null,"coalCERsEarnedPerYear"]
["Carbon credit revenue per year",{"$f":"B62*B35/1000","v":0},"$000/y"]
[]
["4 - Calculate New Annual Costs"]
["Flare O&M cost",{"$f":"B26","v":0},"$000/y"]
["Drain & transport O&M cost/h",{"$f":"IF(B16<>0,(B52*B32)/B16,0)","v":0},"$/h"]
["Drain & transport O&M cost/y",{"$f":"B67*B23/1000","v":0},"$000/y"]
["Carbon credit monetization cost/yr",{"$f":"B47*cflareCERsEarnedPerYear/1000","v":0},"$000/y"]
["Royalty and Severance Taxes",{"$f":"B14*365*B46*3/1000","v":0},"$000/y","3=Nat gas price $/mcf"]
["Total annual cost",{"$f":"B68+B66+B69+B70","v":0},"$000/y",null,"coalTotalAnnualCost"]
[]
["5 - Calculate Project Capital Costs"]
["CMM needed per hour",{"$f":"B52","v":49.283154121863795},"mcf/h"]
["CMM transport system",{"$f":"IF(B16<>0,B31*B74*24/B16/1000,0)","v":882.66993648997038},"$000"]
["Installed Cost Flare",{"$f":"B20*B25*24","v":0},"$000"]
["--"]
["  Subtotal",{"$f":"SUM(B75:B76)","v":882.66993648997038},"$000"]
["Total cap cost with factors",{"$f":"(B78*(1+B44))*(1+B43)","v":973.14360498019244},"$000",null,"coalTotalCapCost"]
[]
["6 - Calculate Loan and Equity"]
["Loan amount",{"$f":"B79*(1-B39)","v":0},"$000",null,"LoanAmount"]
["Equity amount",{"$f":"B79*B39","v":973.14360498019244},"$000",null,"coalEquityAmount"]
[]
["7 - Discounted Cash Flow Analysis","($000)"]
["Years >>>",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["A - Benefits"]
[null,null,{"$f":"IF(C$86<=$B$18,B58,0)","v":0},{"$f":"IF(D$86<=$B$18,C88*(1+$B$37),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Carbon Credit Revenues",null,null,{"$f":"IF(C$86<=$B$18,$B63,0)","v":0},{"$f":"IF(D$86<=$B$18,D89*(1+default8/100),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Benefits",null,{"$f":"SUM(C88:C89)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["B - Costs"]
["Annual Drainage and Flare O&M Cost",null,{"$f":"IF(C$86<=$B$18,-B71,0)","v":0},{"$f":"IF(D$86<=$B$18,C92*(1+$B$37),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["C - Cash Flow from Operations",null,{"$f":"SUM(C90:C92)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["D - Debt Service",null,{"$f":"IF(OR(C$86>$B$40,C$86>$B$18),0, PMT($B$41, $B$40, $B$82))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["E - Net Cash Flow",{"$f":"-B83","v":-973.14360498019244},{"$f":"SUM(C93:C95)","v":0},{"$f":"SUM(D93:D95)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["8 - Financial Measurements: IRR, NPV, Payback"]
["Internal Rate of Return - IRR",null,{"$f":"IF(ISERR(IRR($B96:V96)),0,IRR($B96:V96))","v":0}]
["Net Present Value",null,{"$f":"NPV(B38,C96:V96)+cflareMinusEquityAmount","v":-973.14360498019244}]
["Payback Period",null,{"$f":"SUM(C103:V103)","v":0}]
[null,{"$f":"IF(B$86<=$B$18,SUM($B96:B96),0)","v":-973.14360498019244},{"$f":"IF(C$86<=$B$18,SUM($B96:C96),0)","v":-973.14360498019244},{"$f":"IF(D$86<=$B$18,SUM($B96:D96),0)","v":-973.14360498019244},{"$f":"IF(E$86<=$B$18,SUM($B96:E96),0)","v":-973.14360498019244},{"$f":"IF(F$86<=$B$18,SUM($B96:F96),0)","v":-973.14360498019244},{"$f":"IF(G$86<=$B$18,SUM($B96:G96),0)","v":-973.14360498019244},{"$f":"IF(H$86<=$B$18,SUM($B96:H96),0)","v":-973.14360498019244},{"$f":"IF(I$86<=$B$18,SUM($B96:I96),0)","v":-973.14360498019244},{"$f":"IF(J$86<=$B$18,SUM($B96:J96),0)","v":-973.14360498019244},{"$f":"IF(K$86<=$B$18,SUM($B96:K96),0)","v":-973.14360498019244},{"$f":"IF(L$86<=$B$18,SUM($B96:L96),0)","v":-973.14360498019244},{"$f":"IF(M$86<=$B$18,SUM($B96:M96),0)","v":0},{"$f":"IF(N$86<=$B$18,SUM($B96:N96),0)","v":0},{"$f":"IF(O$86<=$B$18,SUM($B96:O96),0)","v":0},{"$f":"IF(P$86<=$B$18,SUM($B96:P96),0)","v":0},{"$f":"IF(Q$86<=$B$18,SUM($B96:Q96),0)","v":0},{"$f":"IF(R$86<=$B$18,SUM($B96:R96),0)","v":0},{"$f":"IF(S$86<=$B$18,SUM($B96:S96),0)","v":0},{"$f":"IF(T$86<=$B$18,SUM($B96:T96),0)","v":0},{"$f":"IF(U$86<=$B$18,SUM($B96:U96),0)","v":0},{"$f":"IF(V$86<=$B$18,SUM($B96:V96),0)","v":0}]
[null,null,{"$f":"IF(AND(C102>0,B102<0),C86+(1-C102/C96),0)","v":0},{"$f":"IF(AND(D102>0,C102<0),D86+(1-D102/D96),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"OpenFlare","index":9,"n_rows":104,"n_cols":23,"rows_kept":104,"cut":false,"hidden":true,"merged":[]}
["1 - INPUT PARAMETERS ","Values","units","Comment","Name","Default","Range"]
[{"$f":"lblDrain1","v":"What is the cost of well-head blowers?"},{"$f":"drainage1","v":0},"$/HP"]
[{"$f":"lblDrain2","v":"What is the cost of satellite compressors?"},{"$f":"drainage2","v":1000},"$/HP"]
[{"$f":"lblDrain3","v":"What is the distance from the drainage area to the onsite project?"},{"$f":"drainage3","v":21000},"ft"]
[{"$f":"lblDrain4","v":"What is the cost of installing header pipe from the drainage area?"},{"$f":"drainage4","v":40},"$/ft"]
[{"$f":"lblDrain5","v":"What are the compressor and blower efficiencies?"},{"$f":"drainage5","v":3.5000000000000003E-2},"HP/mcfd"]
[{"$f":"lblDrain6","v":"What is the spacing between gob drainage wells?"},{"$f":"drainage6","v":1000},"ft"]
[{"$f":"lblDrain7","v":"What is the mining rate?"},{"$f":"drainage7","v":12000},"ft/yr"]
[{"$f":"lblDrain7alt","v":"How many drainage wells are being utilized?"},{"$f":"drainage7alt","v":0},"wells"]
["What is the drainage gas source?",{"$f":"inputDrainageSource","v":"GW"}]
[{"$f":"lblDrain8","v":"What is the mine depth?"},{"$f":"drainage8","v":0},"ft/well"]
[{"$f":"lblDrain9","v":"What is the drilling cost?"},{"$f":"drainage9","v":0},"$/ft"]
[{"$f":"lblUser18","v":"What percent of CMM is consumed by prime-mover use?"},{"$f":"user18/100","v":7.0000000000000007E-2}]
[{"$f":"lblGas1","v":"What do you expect the CMM drained per day to be?"},{"$f":"gas1zz","v":1250},"mcf/d"]
["CMM drained per hour",{"$f":"B14/24","v":52.083333333333336},"mcf/h"]
[{"$f":"lblPctMethane","v":"Percent methane in drainage gas"},{"$f":"inputPctMethane/100","v":0.9},null,"Use 30% for Flare Feasibility Test"]
["Actual gas flow",{"$f":"IF(B16<>0,B14/B16,0)","v":1388.8888888888889},"mcf/d"]
[{"$f":"lblUser16","v":"What is the planned project operational lifetime?"},{"$f":"user16","v":10},"years",null,"oflareProjectLifetime"]
[{"$f":"lblGas6","v":"What is the fraction of CMM available after losses?"},{"$f":"gas6zz/100","v":0.95}]
["Average fuel available",{"$f":"B15*(B19-B13)","v":45.833333333333329},"mcf/h"]
["Fuel value",{"$f":"B20*B33/1000","v":41.708333333333329},"mmBtu/h"]
[]
[{"$f":"lblDefault2","v":"How many hours per year will the flare operate?"},{"$f":"default2","v":0},"hours/yr",null,null,8000,"7500-8300"]
[]
[{"$f":"lblUser21","v":"What is the capital cost of the open flare?"},{"$f":"user21","v":0},"$000/mcfd","User Defined Input Page",null,0.08,"0.03-0.13"]
[{"$f":"lblUser22","v":"What is the O&M cost of the open flare?"},{"$f":"user22","v":0},"$000/yr","User Defined Input Page",null,10,"5 - 15"]
[]
[]
[]
[{"$f":"lblDrain10","v":"What is the fraction of this project's drainage system cost that will be included in the analysis?"},{"$f":"drainage10/100","v":0},null,"added by JC 6/25"]
["Drainage and Transport sys unit cap cost",{"$f":"IF((B14*B19)<>0,(B3*B6)+(B4*B5*B16/(B14*B19))+(IF(B10=\"AM\",B7*B5*B9*B16/(B14*B19),0))+\n(B30*IF(inputDrainageSystem=\"Y\",(B2*B6)+IF(B10=\"AM\",B11*B12*B9*B16/(B14*B19),0),0)),0)","v":671.63157894736844},"$/mcfd","\"X\", tweaked by JC 6/25"]
["Drainage and Transport O&M cost",{"$f":"IF(AND(inputDrainageSource=\"GW\",(B14*B19)<>0,B23<>0),((B8*B5)+IF(AND(inputDrainageSystem=\"Y\",B7<>0),B8*B11*B12*B30/B7,0))*B16*24/(B14*B19)/B23,0)","v":0},"$/mcf","\"Y\", tweaked by JC 6/25"]
["CMM fuel value LHV",910,"Btu/cf","constant"]
["Weight of methane, tonnes",1.9259999999999999E-2,"tonnes/mcf","constant"]
[{"$f":"lblUser8","v":"What is the carbon credit unit sale price? "},{"$f":"user8","v":2},"$/tonne CO2E",null,"CER_UnitValue"]
["GWP ratio: methane to CO2",{"$f":"default20","v":25},"ratio","constant"]
[{"$f":"lblDefault21","v":"What is the inflation rate?"},{"$f":"default21/100","v":2.5000000000000001E-2},null,null,"InflationRate"]
[{"$f":"lblDefault26","v":"What is the real discount rate?"},{"$f":"default26/100","v":0.12},null,null,"RealDiscountRate"]
[{"$f":"lblUser12","v":"What is the developer's equity share in the project? "},{"$f":"user12/100","v":1},null,null,"EquityPercent"]
[{"$f":"lblUser15","v":"What is the loan term?"},{"$f":"user15","v":5},"yr",null,"loanTerm"]
[{"$f":"lblUser5","v":"What interest rate is charged for the loan? "},{"$f":"user5/100","v":0},null,null,"InterestRate"]
["Cap Cost Factors"]
[{"$f":"lblDefault7","v":"What is the contingency factor?"},{"$f":"default7/100","v":0.05}]
[{"$f":"lblDefault14","v":"What are the \"soft\" costs for the project?"},{"$f":"default14/100","v":0.05}]
["Annual Cost Factors"]
[{"$f":"lblDefault11","v":"What are the royalty and severance taxes?"},{"$f":"default11/100","v":0}]
[{"$f":"lblDefault15","v":"What is the validation, verification and transaction cost to monetize carbon credits?"},{"$f":"default15","v":0.5},"$/tCO2e"]
[]
["2 - Feasibility Test"]
["CMM heat value available/hour",{"$f":"B21","v":41.708333333333329},"mmBtu/h","this is downstream availability"]
[]
["CMM volume needed/hour",{"$f":"B50*1000/B33/(1-B13)","v":49.283154121863795},"mcf/h","incl prime mover, exclud fugitive"]
["CMM available for other uses",0,"mcfd","available at drainage wells","cmmAvailable"]
[]
["3 - Calculate Annual Benefits"]
[]
[]
[]
["CMM volume needed/hour",{"$f":"B52","v":49.283154121863795},"mcf/h"]
["Tonnes CH4 needed/hour",{"$f":"B59*B34","v":0.94919354838709669},"t/h"]
["Carbon credits earned per hour",{"$f":"B60*(B36-2.75)","v":21.119556451612901},"t/h"]
["Carbon credits earned per year",{"$f":"B61*B23","v":0},"t/y",null,"coalCERsEarnedPerYear"]
["Carbon credit revenue per year",{"$f":"B62*B35/1000","v":0},"$000/y"]
[]
["4 - Calculate New Annual Costs"]
["Flare O&M cost",{"$f":"B26","v":0},"$000/y"]
["Drain & transport O&M cost/h",{"$f":"IF(B16<>0,(B52*B32)/B16,0)","v":0},"$/h"]
["Drain & transport O&M cost/y",{"$f":"B67*B23/1000","v":0},"$000/y"]
["Royalty and severance taxes cost/yr",{"$f":"B14*365*3*B46/1000","v":0}]
["Carbon credit monetization cost/yr",{"$f":"B47*oflareCERsEarnedPerYear/1000","v":0},"$000/y"]
["--"]
["Total annual cost",{"$f":"B68+B66+B70+B69","v":0},"$000/y",null,"coalTotalAnnualCost"]
[]
["5 - Calculate Project Capital Costs"]
["CMM needed per hour",{"$f":"B52","v":49.283154121863795},"mcf/h"]
["CMM transport system",{"$f":"IF(B16<>0,B31*B75*24/B16/1000,0)","v":882.66993648997038},"$000"]
["Installed Cost Flare",{"$f":"B20*B25*24","v":0},"$000"]
["--"]
["  Subtotal",{"$f":"SUM(B76:B77)","v":882.66993648997038},"$000"]
["Total cap cost with factors",{"$f":"(B79*(1+B44))*(1+B43)","v":973.14360498019244},"$000",null,"coalTotalCapCost"]
[]
["6 - Calculate Loan and Equity"]
["Loan amount",{"$f":"B80*(1-B39)","v":0},"$000",null,"LoanAmount"]
["Equity amount",{"$f":"B80*B39","v":973.14360498019244},"$000",null,"coalEquityAmount"]
[]
["7 - Discounted Cash Flow Analysis","($000)"]
["Years >>>",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["A - Benefits"]
[null,null,{"$f":"IF(C$87<=$B$18,B58,0)","v":0},{"$f":"IF(D$87<=$B$18,C89*(1+$B$37),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Carbon Credit Revenues",null,null,{"$f":"IF(C$87<=$B$18,$B63,0)","v":0},{"$f":"IF(D$87<=$B$18,D90*(1+default8/100),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Benefits",null,{"$f":"SUM(C89:C90)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["B - Costs"]
["Annual Drainage and Flare O&M Cost",null,{"$f":"IF(C$87<=$B$18,-B72,0)","v":0},{"$f":"IF(D$87<=$B$18,C93*(1+$B$37),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["C - Cash Flow from Operations",null,{"$f":"SUM(C91:C93)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["D - Debt Service",null,{"$f":"IF(OR(C$87>$B$40,C$87>$B$18),0, PMT($B$41, $B$40, $B$83))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["E - Net Cash Flow",{"$f":"-B84","v":-973.14360498019244},{"$f":"SUM(C94:C96)","v":0},{"$f":"SUM(D94:D96)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["8 - Financial Measurements: IRR, NPV, Payback"]
["Internal Rate of Return - IRR",null,{"$f":"IF(ISERR(IRR($B97:V97)),0,IRR($B97:V97))","v":0}]
["Net Present Value",null,{"$f":"NPV(B38,C97:V97)+oflareMinusEquityAmount","v":-973.14360498019244}]
["Payback Period",null,{"$f":"SUM(C104:V104)","v":0}]
[null,{"$f":"IF(B$87<=$B$18,SUM($B97:B97),0)","v":-973.14360498019244},{"$f":"IF(C$87<=$B$18,SUM($B97:C97),0)","v":-973.14360498019244},{"$f":"IF(D$87<=$B$18,SUM($B97:D97),0)","v":-973.14360498019244},{"$f":"IF(E$87<=$B$18,SUM($B97:E97),0)","v":-973.14360498019244},{"$f":"IF(F$87<=$B$18,SUM($B97:F97),0)","v":-973.14360498019244},{"$f":"IF(G$87<=$B$18,SUM($B97:G97),0)","v":-973.14360498019244},{"$f":"IF(H$87<=$B$18,SUM($B97:H97),0)","v":-973.14360498019244},{"$f":"IF(I$87<=$B$18,SUM($B97:I97),0)","v":-973.14360498019244},{"$f":"IF(J$87<=$B$18,SUM($B97:J97),0)","v":-973.14360498019244},{"$f":"IF(K$87<=$B$18,SUM($B97:K97),0)","v":-973.14360498019244},{"$f":"IF(L$87<=$B$18,SUM($B97:L97),0)","v":-973.14360498019244},{"$f":"IF(M$87<=$B$18,SUM($B97:M97),0)","v":0},{"$f":"IF(N$87<=$B$18,SUM($B97:N97),0)","v":0},{"$f":"IF(O$87<=$B$18,SUM($B97:O97),0)","v":0},{"$f":"IF(P$87<=$B$18,SUM($B97:P97),0)","v":0},{"$f":"IF(Q$87<=$B$18,SUM($B97:Q97),0)","v":0},{"$f":"IF(R$87<=$B$18,SUM($B97:R97),0)","v":0},{"$f":"IF(S$87<=$B$18,SUM($B97:S97),0)","v":0},{"$f":"IF(T$87<=$B$18,SUM($B97:T97),0)","v":0},{"$f":"IF(U$87<=$B$18,SUM($B97:U97),0)","v":0},{"$f":"IF(V$87<=$B$18,SUM($B97:V97),0)","v":0}]
[null,null,{"$f":"IF(AND(C103>0,B103<0),C87+(1-C103/C97),0)","v":0},{"$f":"IF(AND(D103>0,C103<0),D87+(1-D103/D97),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Pipeline","index":10,"n_rows":102,"n_cols":23,"rows_kept":102,"cut":false,"hidden":true,"merged":[]}
["1 - INPUT PARAMETERS ","Values","units","Comment","Name","Default","Range"]
[{"$f":"lblDrain1","v":"What is the cost of well-head blowers?"},{"$f":"drainage1","v":0},"$/HP"]
[{"$f":"lblDrain2","v":"What is the cost of satellite compressors?"},{"$f":"drainage2","v":1000},"$/HP"]
[{"$f":"lblDrain3","v":"What is the distance from the drainage area to the onsite project?"},{"$f":"drainage3","v":21000},"ft"]
[{"$f":"lblDrain4","v":"What is the cost of installing header pipe from the drainage area?"},{"$f":"drainage4","v":40},"$/ft"]
[{"$f":"lblDrain5","v":"What are the compressor and blower efficiencies?"},{"$f":"drainage5","v":3.5000000000000003E-2},"HP/mcfd"]
[{"$f":"lblDrain6","v":"What is the spacing between gob drainage wells?"},{"$f":"drainage6","v":1000},"ft"]
[{"$f":"lblDrain7","v":"What is the mining rate?"},{"$f":"drainage7","v":12000},"ft/yr"]
[{"$f":"lblDrain7alt","v":"How many drainage wells are being utilized?"},{"$f":"drainage7alt","v":0},"wells","If source = AMM"]
["What is the drainage gas source?",{"$f":"inputDrainageSource","v":"GW"}]
[{"$f":"lblDrain8","v":"What is the mine depth?"},{"$f":"drainage8","v":0},"ft/well"]
[{"$f":"lblDrain9","v":"What is the drilling cost?"},{"$f":"drainage9","v":0},"$/ft"]
[{"$f":"lblUser18","v":"What percent of CMM is consumed by prime-mover use?"},{"$f":"user18/100","v":7.0000000000000007E-2}]
[{"$f":"lblGas1","v":"What do you expect the CMM drained per day to be?"},{"$f":"gas1zz","v":1250},"mcf/d"]
["CMM drained per hour",{"$f":"B14/24","v":52.083333333333336},"mcf/h"]
[{"$f":"lblPctMethane","v":"Percent methane in drainage gas"},{"$f":"inputPctMethane/100","v":0.9},null,"Use 40% for Pipeline Inj. Feasibility Test"]
["Actual gas flow",{"$f":"IF(B16<>0,B14/B16,0)","v":1388.8888888888889},"mcf/d"]
[{"$f":"lblUser16","v":"What is the planned project operational lifetime?"},{"$f":"user16","v":10},"years",null,"pipelineProjectLifetime"]
[{"$f":"lblGas6","v":"What is the fraction of CMM available after losses?"},{"$f":"gas6zz/100","v":0.95}]
["Average fuel available",{"$f":"B15*(B19-B13)","v":45.833333333333329},"mcf/h","excludes fugitive and primemover use"]
["Fuel value",{"$f":"B20*B31/1000","v":41.708333333333329},"mmBtu/h"]
[{"$f":"lblUser13","v":"What is the distance to the natural gas pipeline?"},{"$f":"user13","v":0},"ft","User Defined Input Page"]
[{"$f":"lblDefault5","v":"How many hours per year will the project operate?"},{"$f":"default5","v":0},"hours/yr","Defaults Parameter page",null,8000,"7500-8300"]
[{"$f":"lblUser14","v":"What is the installed cost of the high pressure line from the project site to the natural gas pipeline? "},{"$f":"user14","v":0},"$/ft","User Defined Input Page",null,55]
[{"$f":"lblUser2","v":"What is the cost of electric power used by the project?"},{"$f":"user2","v":0},"$/MW","User Defined Input Page",null,70,"50-90"]
[{"$f":"lblUser9","v":"What is the price of the methane sold to the pipeline? "},{"$f":"user9","v":0},"$/mmBtu(HHV)","User Defined Input Page",null,8,"5 - 12"]
[{"$f":"lblUser37","v":"What is the cost of the oxygen removal system?"},{"$f":"user37","v":0},"$,000","User Defined Input Page - added May 2015",null,1250]
[{"$f":"lblDrain10","v":"What is the fraction of this project's drainage system cost that will be included in the analysis?"},{"$f":"drainage10/100","v":0},null,"added by JC 6/25"]
["Drainage and Transport sys unit cap cost",{"$f":"IF((B14*B19)<>0,(B3*B6)+(B4*B5*B16/(B14*B19))+(IF(B10=\"AM\",B7*B5*B9*B16/(B14*B19),0))+\n(B28*IF(inputDrainageSystem=\"Y\",(B2*B6)+IF(B10=\"AM\",B11*B12*B9*B16/(B14*B19),0),0)),0)","v":671.63157894736844},"$/mcfd","\"X\", tweaked by JC 6/25"]
["Drainage and Transport O&M cost",{"$f":"IF(AND(inputDrainageSource=\"GW\",(B14*B19)<>0,B23<>0),((B8*B5)+IF(AND(inputDrainageSystem=\"Y\",B7<>0),B8*B11*B12*B28/B7,0))*B16*24/(B14*B19)/B23,0)","v":0},"$/mcf","\"Y\", tweaked by JC 6/25"]
["CMM fuel value LHV",910,"Btu/cf","constant"]
["Weight of methane, tonnes",1.9259999999999999E-2,"tonnes/mcf","constant"]
[{"$f":"lblUser8","v":"What is the carbon credit unit sale price? "},{"$f":"user8","v":2},"$/tonne CO2E",null,"CER_UnitValue"]
["GWP ratio: methane to CO2",{"$f":"default20","v":25},"ratio","constant"]
[{"$f":"lblDefault21","v":"What is the inflation rate?"},{"$f":"default21/100","v":2.5000000000000001E-2},null,null,"InflationRate"]
[{"$f":"lblDefault26","v":"What is the real discount rate?"},{"$f":"default26/100","v":0.12},null,null,"RealDiscountRate"]
[{"$f":"lblUser12","v":"What is the developer's equity share in the project? "},{"$f":"user12/100","v":1},null,null,"EquityPercent"]
[{"$f":"lblUser15","v":"What is the loan term?"},{"$f":"user15","v":5},"yr",null,"loanTerm"]
[{"$f":"lblUser5","v":"What interest rate is charged for the loan? "},{"$f":"user5/100","v":0},null,null,"InterestRate"]
["Cap Cost Factors"]
[{"$f":"lblDefault7","v":"What is the contingency factor?"},{"$f":"default7/100","v":0.05}]
[{"$f":"lblDefault14","v":"What are the \"soft\" costs for the project?"},{"$f":"default14/100","v":0.05}]
["Annual Cost Factors"]
[{"$f":"lblDefault15","v":"What is the validation, verification and transaction cost to monetize carbon credits?"},{"$f":"default15","v":0.5},"$/tCO2e"]
[{"$f":"lblDefault11","v":"What are the royalty and severance taxes?"},{"$f":"default11/100","v":0}]
[]
["CMM fuel value HHV",1010,"Btu/cf","constant"]
["2 - Feasibility Test"]
["CMM combusted in gathering sys. prime movers",{"$f":"B13*B15","v":3.6458333333333339},"mcf/h"]
["CMM entering project",{"$f":"B20","v":45.833333333333329},"mcf/h"]
["CMM volume sold to pipeline",{"$f":"B50*(0.959-0.2644*(1-B16))","v":42.742333333333328},"mcf/h","0.959 and 0.2644 come from the regression equation of the graph in fig 2 on page 36 of the original manual"]
["CMM available for other uses",0,"mcf/d"]
[]
["3 - Calculate Annual Benefits"]
[]
["CMM volume sold to pipeline",{"$f":"B51","v":42.742333333333328},"mcf/h"]
["Revenue from gas sales",{"$f":"B56*B23*B47*B26/1000/1000","v":0},"$000/yr"]
["CMM available for carbon credits",{"$f":"B51+B49","v":46.388166666666663},"mcf/h"]
["Tonnes CH4 available for carbon credits",{"$f":"B58*B32","v":0.89343608999999991},"t/h"]
["Carbon credits earned per hour",{"$f":"B59*B34-(IF(B16=0,0,(B50*0.43*24*0.7457*default9/B16/1000)))","v":22.104677251111109},"t/h"]
["Carbon credits earned per year",{"$f":"B60*B23","v":0},"t/y",null,"coalCERsEarnedPerYear"]
["Carbon credit revenue per year",{"$f":"B61*B33/1000","v":0},"$000/y"]
[]
["4 - Calculate New Annual Costs"]
["Project O&M cost",{"$f":"IF(B16<>0,(300)+(0.75*B23*B50/B16/1000)+(B50*B23*B25*0.43*24*0.7457/B16/1000/1000),0)","v":300},"$000/yr","=IF(B16<>0,(300)+(0.75*B23*B49/B16/1000)+(B49*B23*B25*0.43*24*0.7457/B16/1000/1000),0)",null,null,null,null,null,null,null,"Fixed O&M of $300K + variable O&M of $0.75/mcf + cost of electricity used"]
["Drain & transport O&M cost/h",{"$f":"IF(B16<>0,(B50*B30)/B16,0)","v":0},"$/h",null,null,null,null,null,null,null,null,"0.43 = compression demands in mmscf/d per hp"]
["Drain & transport O&M cost/y",{"$f":"B66*B23/1000","v":0},"$000/y",null,null,null,null,null,null,null,null,"0.7457 = kw/hp"]
["Carbon credit monetization cost/yr",{"$f":"B44*pipelineCERsEarnedPerYear/1000","v":0},"$000/y",null,null,null,null,null,null,null,null,"24 = hr/d"]
["Royalty and severance taxes",{"$f":"B57*B45","v":0},"$000/y"]
["Total annual cost",{"$f":"B67+B65+B68+B69","v":300},"$000/y",null,"coalTotalAnnualCost"]
[]
["5 - Calculate Project Capital Costs"]
["CMM needed per hour",{"$f":"B50","v":45.833333333333329},"mcf/h"]
["CMM transport system",{"$f":"IF(B16<>0,B29*B73*24/B16/1000,0)","v":820.8830409356724},"$000"]
["Installed Cost of Processing Plant",{"$f":"IF(B16<>0,(B27)+(B22*B24/1000)+(936)+(B50*24*(1.5765*(1-B16)+0.6196)/B16),0)","v":1885.9722222222222},"$000",null,null,null,null,null,null,null,null,"5/15  Cost of catox now included as user input - (1250 = was fixed cap cost of oxidizer)"]
["--",null,null,null,null,null,null,null,null,null,null,"936, 1.5765, 0.6196 = come from regression equation on the curve in the Swing absorber graph (p.36 of original manual)"]
["  Subtotal",{"$f":"SUM(B74:B75)","v":2706.8552631578946},"$000"]
["Total cap cost with factors",{"$f":"(B77*(1+B42))*(1+B41)","v":2984.3079276315789},"$000",null,"coalTotalCapCost"]
[]
["6 - Calculate Loan and Equity"]
["Loan amount",{"$f":"B78*(1-B37)","v":0},"$000",null,"LoanAmount"]
["Equity amount",{"$f":"B78*B37","v":2984.3079276315789},"$000",null,"coalEquityAmount"]
[]
["7 - Discounted Cash Flow Analysis","($000)"]
["Years >>>",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["A - Benefits"]
["Gas Sales Revenues",null,{"$f":"IF(C$85<=$B$18,B57,0)","v":0},{"$f":"IF(D$85<=$B$18,C87*(1+$B$35),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Carbon Credit Revenues",null,null,{"$f":"IF(C$85<=$B$18,$B62,0)","v":0},{"$f":"IF(D$85<=$B$18,D88*(1+default8/100),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Benefits",null,{"$f":"SUM(C87:C88)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["B - Costs"]
["Annual Drainage and Project O&M Cost",null,{"$f":"IF(C$85<=$B$18,-B70,0)","v":-300},{"$f":"IF(D$85<=$B$18,C91*(1+$B$35),0)","v":-307.5},-315.1875,-323.06718749999999,-331.14386718749995,-339.42246386718745,-347.90802546386709,-356.60572610046376,-365.52086925297533,-374.65889098429966,0,0,0,0,0,0,0,0,0,0]
["C - Cash Flow from Operations",null,{"$f":"SUM(C89:C91)","v":-300},-307.5,-315.1875,-323.06718749999999,-331.14386718749995,-339.42246386718745,-347.90802546386709,-356.60572610046376,-365.52086925297533,-374.65889098429966,0,0,0,0,0,0,0,0,0,0]
[]
["D - Debt Service",null,{"$f":"IF(OR(C$85>$B$38,C$85>$B$18),0, PMT($B$39, $B$38, $B$81))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["E - Net Cash Flow",{"$f":"-B82","v":-2984.3079276315789},{"$f":"SUM(C92:C94)","v":-300},{"$f":"SUM(D92:D94)","v":-307.5},-315.1875,-323.06718749999999,-331.14386718749995,-339.42246386718745,-347.90802546386709,-356.60572610046376,-365.52086925297533,-374.65889098429966,0,0,0,0,0,0,0,0,0,0]
[]
["8 - Financial Measurements: IRR, NPV, Payback"]
["Internal Rate of Return - IRR",null,{"$f":"IF(ISERR(IRR($B95:V95)),0,IRR($B95:V95))","v":0},"IRR needs at least one positive cash flow value.  ISERR catches error and returns \"0\""]
["Net Present Value",null,{"$f":"NPV(B36,C95:V95)+pipelineMinusEquityAmount","v":-4840.6669893011749}]
["Payback Period",null,{"$f":"SUM(C102:V102)","v":0}]
[null,{"$f":"IF(B$85<=$B$18,SUM($B95:B95),0)","v":-2984.3079276315789},{"$f":"IF(C$85<=$B$18,SUM($B95:C95),0)","v":-3284.3079276315789},{"$f":"IF(D$85<=$B$18,SUM($B95:D95),0)","v":-3591.8079276315789},{"$f":"IF(E$85<=$B$18,SUM($B95:E95),0)","v":-3906.9954276315789},{"$f":"IF(F$85<=$B$18,SUM($B95:F95),0)","v":-4230.0626151315792},{"$f":"IF(G$85<=$B$18,SUM($B95:G95),0)","v":-4561.2064823190794},{"$f":"IF(H$85<=$B$18,SUM($B95:H95),0)","v":-4900.6289461862671},{"$f":"IF(I$85<=$B$18,SUM($B95:I95),0)","v":-5248.5369716501345},{"$f":"IF(J$85<=$B$18,SUM($B95:J95),0)","v":-5605.142697750598},{"$f":"IF(K$85<=$B$18,SUM($B95:K95),0)","v":-5970.663567003573},{"$f":"IF(L$85<=$B$18,SUM($B95:L95),0)","v":-6345.3224579878724},{"$f":"IF(M$85<=$B$18,SUM($B95:M95),0)","v":0},{"$f":"IF(N$85<=$B$18,SUM($B95:N95),0)","v":0},{"$f":"IF(O$85<=$B$18,SUM($B95:O95),0)","v":0},{"$f":"IF(P$85<=$B$18,SUM($B95:P95),0)","v":0},{"$f":"IF(Q$85<=$B$18,SUM($B95:Q95),0)","v":0},{"$f":"IF(R$85<=$B$18,SUM($B95:R95),0)","v":0},{"$f":"IF(S$85<=$B$18,SUM($B95:S95),0)","v":0},{"$f":"IF(T$85<=$B$18,SUM($B95:T95),0)","v":0},{"$f":"IF(U$85<=$B$18,SUM($B95:U95),0)","v":0},{"$f":"IF(V$85<=$B$18,SUM($B95:V95),0)","v":0}]
[null,null,{"$f":"IF(AND(C101>0,B101<0),C85+(1-C101/C95),0)","v":0},{"$f":"IF(AND(D101>0,C101<0),D85+(1-D101/D95),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"CNG","index":11,"n_rows":104,"n_cols":23,"rows_kept":104,"cut":false,"hidden":true,"merged":[]}
["1 - INPUT PARAMETERS ","Values","units","Comment","Name","Default","Range"]
[{"$f":"lblDrain1","v":"What is the cost of well-head blowers?"},{"$f":"drainage1","v":0},"$/HP"]
[{"$f":"lblDrain2","v":"What is the cost of satellite compressors?"},{"$f":"drainage2","v":1000},"$/HP"]
[{"$f":"lblDrain3","v":"What is the distance from the drainage area to the onsite project?"},{"$f":"drainage3","v":21000},"ft"]
[{"$f":"lblDrain4","v":"What is the cost of installing header pipe from the drainage area?"},{"$f":"drainage4","v":40},"$/ft"]
[{"$f":"lblDrain5","v":"What are the compressor and blower efficiencies?"},{"$f":"drainage5","v":3.5000000000000003E-2},"HP/mcfd"]
[{"$f":"lblDrain6","v":"What is the spacing between gob drainage wells?"},{"$f":"drainage6","v":1000},"ft"]
[{"$f":"lblDrain7","v":"What is the mining rate?"},{"$f":"drainage7","v":12000},"ft/yr"]
[{"$f":"lblDrain7alt","v":"How many drainage wells are being utilized?"},{"$f":"drainage7alt","v":0},"wells","If source = AMM"]
["What is the drainage gas source?",{"$f":"inputDrainageSource","v":"GW"}]
[{"$f":"lblDrain8","v":"What is the mine depth?"},{"$f":"drainage8","v":0},"ft/well"]
[{"$f":"lblDrain9","v":"What is the drilling cost?"},{"$f":"drainage9","v":0},"$/ft"]
[{"$f":"lblUser18","v":"What percent of CMM is consumed by prime-mover use?"},{"$f":"user18/100","v":7.0000000000000007E-2}]
[{"$f":"lblGas1","v":"What do you expect the CMM drained per day to be?"},{"$f":"gas1zz","v":1250},"mcf/d"]
["CMM drained per hour",{"$f":"B14/24","v":52.083333333333336},"mcf/h"]
[{"$f":"lblPctMethane","v":"Percent methane in drainage gas"},{"$f":"inputPctMethane/100","v":0.9},null,"Use 40% for CNG Feasibility Test"]
["Actual gas flow",{"$f":"IF(B16<>0,B14/B16,0)","v":1388.8888888888889},"mcf/d"]
[{"$f":"lblUser16","v":"What is the planned project operational lifetime?"},{"$f":"user16","v":10},"years",null,"cngProjectLifetime"]
[{"$f":"lblGas6","v":"What is the fraction of CMM available after losses?"},{"$f":"gas6zz/100","v":0.95}]
["Average fuel available",{"$f":"B15*(B19-B13)","v":45.833333333333329},"mcf/h","excludes fugitive and primemover use"]
["Fuel value",{"$f":"B20*B31/1000","v":41.708333333333329},"mmBtu/h"]
[{"$f":"lblUser30","v":"What is the size of the CNG distribution system?"},{"$f":"User30","v":0},"GGE/day","User Defined Input Page",null,{"$f":"OFFSET(User30,0,1)","v":800},{"$f":"OFFSET(User30,0,4)","v":"[20-2,000]"}]
[{"$f":"lblDefault5","v":"How many hours per year will the project operate?"},{"$f":"default5","v":0},"hours/yr","Defaults Parameter page",null,8000,"7500-8300"]
[{"$f":"lblUser31","v":"What is the installed capital cost of the CNG system?"},{"$f":"User31","v":0},"$/GGE/day","User Defined Input Page",null,{"$f":"OFFSET(User31,0,1)","v":1000},{"$f":"OFFSET(User31,0,4)","v":"[500-1,500]"}]
[{"$f":"lblUser2","v":"What is the cost of electric power used by the project?"},{"$f":"user2","v":0},"$/MW","User Defined Input Page",null,70,"50-90"]
[{"$f":"lblUser28","v":"What is the price of sold CNG?"},{"$f":"user28","v":0},"$/GGE","User Defined Input Page",null,{"$f":"OFFSET(user28,0,1)","v":2},{"$f":"OFFSET(user28,0,4)","v":"[0.80-2.50]"}]
[{"$f":"lblUser37","v":"What is the cost of the oxygen removal system?"},{"$f":"user37","v":0},"$,000","User Defined Input Page - added May 2015",null,1250]
[{"$f":"lblDrain10","v":"What is the fraction of this project's drainage system cost that will be included in the analysis?"},{"$f":"drainage10/100","v":0},null,"added by JC 6/25"]
["Drainage and Transport sys unit cap cost",{"$f":"IF((B14*B19)<>0,(B3*B6)+(B4*B5*B16/(B14*B19))+(IF(B10=\"AM\",B7*B5*B9*B16/(B14*B19),0))+\n(B28*IF(inputDrainageSystem=\"Y\",(B2*B6)+IF(B10=\"AM\",B11*B12*B9*B16/(B14*B19),0),0)),0)","v":671.63157894736844},"$/mcfd","\"X\", tweaked by JC 6/25"]
["Drainage and Transport O&M cost",{"$f":"IF(AND(inputDrainageSource=\"GW\",(B14*B19)<>0,B23<>0),((B8*B5)+IF(AND(inputDrainageSystem=\"Y\",B7<>0),B8*B11*B12*B28/B7,0))*B16*24/(B14*B19)/B23,0)","v":0},"$/mcf","\"Y\", tweaked by JC 6/25"]
["CMM fuel value LHV",910,"Btu/cf","constant"]
["Weight of methane, tonnes",1.9259999999999999E-2,"tonnes/mcf","constant"]
[{"$f":"lblUser8","v":"What is the carbon credit unit sale price? "},{"$f":"user8","v":2},"$/tonne CO2E",null,"CER_UnitValue"]
["GWP ratio: methane to CO2",{"$f":"default20","v":25},"ratio","constant"]
[{"$f":"lblDefault21","v":"What is the inflation rate?"},{"$f":"default21/100","v":2.5000000000000001E-2},null,null,"InflationRate"]
[{"$f":"lblDefault26","v":"What is the real discount rate?"},{"$f":"default26/100","v":0.12},null,null,"RealDiscountRate"]
[{"$f":"lblUser12","v":"What is the developer's equity share in the project? "},{"$f":"user12/100","v":1},null,null,"EquityPercent"]
[{"$f":"lblUser15","v":"What is the loan term?"},{"$f":"user15","v":5},"yr",null,"loanTerm"]
[{"$f":"lblUser5","v":"What interest rate is charged for the loan? "},{"$f":"user5/100","v":0},null,null,"InterestRate"]
["Cap Cost Factors"]
[{"$f":"lblDefault7","v":"What is the contingency factor?"},{"$f":"default7/100","v":0.05}]
[{"$f":"lblDefault14","v":"What are the \"soft\" costs for the project?"},{"$f":"default14/100","v":0.05}]
["Annual Cost Factors"]
[{"$f":"lblDefault15","v":"What is the validation, verification and transaction cost to monetize carbon credits?"},{"$f":"default15","v":0.5},"$/tCO2e"]
[{"$f":"lblUser38","v":"What is the O&M cost of the CNG system?"},{"$f":"user38","v":0},"$/GGE/day"]
[{"$f":"lblDefault11","v":"What are the royalty and severance taxes?"},{"$f":"default11/100","v":0}]
[]
["CMM fuel value HHV",1010,"Btu/cf","constant"]
["2 - Feasibility Test"]
["CMM combusted in gathering sys. prime movers",{"$f":"B13*B15","v":3.6458333333333339},"mcf/h",{"$f":"_xlfn.FORMULATEXT(B50)","v":"=B13*B15"}]
["CMM needed for project",{"$f":"(B22*0.126/24)/(0.959-0.2644*(1-B16))","v":0},"mcf/h",{"$f":"_xlfn.FORMULATEXT(B51)","v":"=(B22*0.126/24)/(0.959-0.2644*(1-B16))"},null,null,null,null,null,"126 scf per GGE"]
["CMM volume after processing",{"$f":"B51*(0.959-0.2644*(1-B16))","v":0},"mcf/h",{"$f":"_xlfn.FORMULATEXT(B52)","v":"=B51*(0.959-0.2644*(1-B16))"},null,null,null,null,null,"0.959 and 0.2644 come from the regression equation of the graph in fig 2 on page 36 of the original manual"]
["CMM available for other uses",{"$f":"IF(OR(B51>B20,inputScenFlare=\"OF\",inputScenFlare=\"EF\",B19=0),0,(B20-B51)*24)","v":1100},"mcf/d",{"$f":"_xlfn.FORMULATEXT(B53)","v":"=IF(OR(B51>B20,inputScenFlare=\"OF\",inputScenFlare=\"EF\",B19=0),0,(B20-B51)*24)"}]
[]
["3 - Calculate Annual Benefits"]
[]
["CNG volume sold",{"$f":"B52","v":0},"mcf/h"]
["Revenue from gas sales",{"$f":"(B22/24)*B23*B26/1000","v":0},"$000/yr"]
["CMM available for carbon credits",{"$f":"B52+B50","v":3.6458333333333339},"mcf/h"]
["Tonnes CH4 available for carbon credits",{"$f":"B59*B32","v":7.021875000000001E-2},"t/h"]
["Carbon credits earned per hour",{"$f":"B60*B34-(IF(B16=0,0,(B51*0.43*24*0.7457*default9/B16/1000)))","v":1.7554687500000004},"t/h",{"$f":"_xlfn.FORMULATEXT(B61)","v":"=B60*B34-(IF(B16=0,0,(B51*0.43*24*0.7457*default9/B16/1000)))"},null,null,null,null,null,"0.43 = compression demands in mmscf/d per hp; 0.7457 = kw/hp  default9=electric grid emission factor (tonnes CO2/MWh)"]
["Carbon credits earned per year",{"$f":"B61*B23","v":0},"t/y",null,"cngCERsEarnedPerYear"]
["Carbon credit revenue per year",{"$f":"B62*B33/1000","v":0},"$000/y"]
[]
["4 - Calculate New Annual Costs"]
["CNG distribution system O&M cost",{"$f":"(B22*B45/24)*B23/1000","v":0},"$000/yr",{"$f":"_xlfn.FORMULATEXT(B66)","v":"=(B22*B45/24)*B23/1000"}]
["Processing system O&M cost",{"$f":"IF(B16<>0,(300)+(0.75*B23*B51/B16/1000)+(B51*B23*B25*0.43*24*0.7457/B16/1000/1000),0)","v":300},"$000/yr","=IF(B16<>0,(300)+(0.75*B23*B51/B16/1000)+(B51*B23*B25*0.43*24*0.7457/B16/1000/1000),0)",null,null,null,null,null,null,null,"Fixed O&M of $300K + variable O&M of $0.75/mcf + cost of electricity used"]
["Drain & transport O&M cost/h",{"$f":"IF(B16<>0,(B51*B30)/B16,0)","v":0},"$/h","=IF(B16<>0,(B51*B30)/B16,0)",null,null,null,null,null,null,null,"0.43 = compression demands in mmscf/d per hp"]
["Drain & transport O&M cost/y",{"$f":"B68*B23/1000","v":0},"$000/y","=B68*B23/1000",null,null,null,null,null,null,null,"0.7457 = kw/hp"]
["Carbon credit monetization cost/yr",{"$f":"B44*cngCERsEarnedPerYear/1000","v":0},"$000/y","=B44*cngCERsEarnedPerYear/1000",null,null,null,null,null,null,null,"24 = hr/d"]
["Royalty and severance taxes",{"$f":"B58*B46","v":0},"$000/y","=B58*B46"]
["Total annual cost",{"$f":"SUM(B66:B71)-B68","v":300},"$000/y",null,"cngTotalAnnualCost"]
[]
["5 - Calculate Project Capital Costs"]
["CMM needed per hour",{"$f":"B51","v":0},"mcf/h"]
["CMM transport system",{"$f":"IF(B16<>0,B29*B75*24/B16/1000,0)","v":0},"$,000",{"$f":"_xlfn.FORMULATEXT(B76)","v":"=IF(B16<>0,B29*B75*24/B16/1000,0)"}]
["Installed Cost of Processing Plant",{"$f":"IF(B16<>0,(B27)+(936)+(B51*24*(1.5765*(1-B16)+0.6196)/B16),0)","v":936},"$,000",{"$f":"_xlfn.FORMULATEXT(B77)","v":"=IF(B16<>0,(B27)+(936)+(B51*24*(1.5765*(1-B16)+0.6196)/B16),0)"},null,"Plant cleans gas and compresses to 900 psi",null,null,null,null,null,"5/15  Cost of catox now included as user input - (1250 = was fixed cap cost of oxidizer)"]
["Installed Cost of CNG Distribution System",{"$f":"B22*B24/1000","v":0},"$,000",{"$f":"_xlfn.FORMULATEXT(B78)","v":"=B22*B24/1000"},null,null,null,null,null,null,null,"936, 1.5765, 0.6196 = come from regression equation on the curve in the Swing absorber graph (p.36 of original manual)"]
["  Subtotal",{"$f":"SUM(B76:B78)","v":936},"$,000",{"$f":"_xlfn.FORMULATEXT(B79)","v":"=SUM(B76:B78)"}]
["Total cap cost with factors",{"$f":"(B79*(1+B42))*(1+B41)","v":1031.94},"$,000",{"$f":"_xlfn.FORMULATEXT(B80)","v":"=(B79*(1+B42))*(1+B41)"},"cngTotalCapCost"]
[]
["6 - Calculate Loan and Equity"]
["Loan amount",{"$f":"B80*(1-B37)","v":0},"$000",null,"cngLoanAmount"]
["Equity amount",{"$f":"B80*B37","v":1031.94},"$000",null,"cngEquityAmount"]
[]
["7 - Discounted Cash Flow Analysis","($000)"]
["Years >>>",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["A - Benefits"]
["Gas Sales Revenues",null,{"$f":"IF(C$87<=$B$18,B58,0)","v":0},{"$f":"IF(D$87<=$B$18,C89*(1+$B$35),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Carbon Credit Revenues",null,null,{"$f":"IF(C$87<=$B$18,$B63,0)","v":0},{"$f":"IF(D$87<=$B$18,D90*(1+default8/100),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Benefits",null,{"$f":"SUM(C89:C90)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["B - Costs"]
["Annual Drainage and Project O&M Cost",null,{"$f":"IF(C$87<=$B$18,-B72,0)","v":-300},{"$f":"IF(D$87<=$B$18,C93*(1+$B$35),0)","v":-307.5},-315.1875,-323.06718749999999,-331.14386718749995,-339.42246386718745,-347.90802546386709,-356.60572610046376,-365.52086925297533,-374.65889098429966,0,0,0,0,0,0,0,0,0,0]
["C - Cash Flow from Operations",null,{"$f":"SUM(C91:C93)","v":-300},-307.5,-315.1875,-323.06718749999999,-331.14386718749995,-339.42246386718745,-347.90802546386709,-356.60572610046376,-365.52086925297533,-374.65889098429966,0,0,0,0,0,0,0,0,0,0]
[]
["D - Debt Service",null,{"$f":"IF(OR(C$87>$B$38,C$87>$B$18),0, PMT($B$39, $B$38, $B$83))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["E - Net Cash Flow",{"$f":"-B84","v":-1031.94},{"$f":"SUM(C94:C96)","v":-300},{"$f":"SUM(D94:D96)","v":-307.5},-315.1875,-323.06718749999999,-331.14386718749995,-339.42246386718745,-347.90802546386709,-356.60572610046376,-365.52086925297533,-374.65889098429966,0,0,0,0,0,0,0,0,0,0]
[]
["8 - Financial Measurements: IRR, NPV, Payback"]
["Internal Rate of Return - IRR",null,{"$f":"IF(ISERR(IRR($B97:V97)),0,IRR($B97:V97))","v":0},"IRR needs at least one positive cash flow value.  ISERR catches error and returns \"0\""]
["Net Present Value",null,{"$f":"NPV(B36,C97:V97)+cngMinusEquityAmount","v":-2888.2990616695965}]
["Payback Period",null,{"$f":"SUM(C104:V104)","v":0}]
[null,{"$f":"IF(B$87<=$B$18,SUM($B97:B97),0)","v":-1031.94},{"$f":"IF(C$87<=$B$18,SUM($B97:C97),0)","v":-1331.94},{"$f":"IF(D$87<=$B$18,SUM($B97:D97),0)","v":-1639.44},{"$f":"IF(E$87<=$B$18,SUM($B97:E97),0)","v":-1954.6275000000001},{"$f":"IF(F$87<=$B$18,SUM($B97:F97),0)","v":-2277.6946874999999},{"$f":"IF(G$87<=$B$18,SUM($B97:G97),0)","v":-2608.8385546874997},{"$f":"IF(H$87<=$B$18,SUM($B97:H97),0)","v":-2948.2610185546873},{"$f":"IF(I$87<=$B$18,SUM($B97:I97),0)","v":-3296.1690440185544},{"$f":"IF(J$87<=$B$18,SUM($B97:J97),0)","v":-3652.7747701190183},{"$f":"IF(K$87<=$B$18,SUM($B97:K97),0)","v":-4018.2956393719937},{"$f":"IF(L$87<=$B$18,SUM($B97:L97),0)","v":-4392.9545303562936},{"$f":"IF(M$87<=$B$18,SUM($B97:M97),0)","v":0},{"$f":"IF(N$87<=$B$18,SUM($B97:N97),0)","v":0},{"$f":"IF(O$87<=$B$18,SUM($B97:O97),0)","v":0},{"$f":"IF(P$87<=$B$18,SUM($B97:P97),0)","v":0},{"$f":"IF(Q$87<=$B$18,SUM($B97:Q97),0)","v":0},{"$f":"IF(R$87<=$B$18,SUM($B97:R97),0)","v":0},{"$f":"IF(S$87<=$B$18,SUM($B97:S97),0)","v":0},{"$f":"IF(T$87<=$B$18,SUM($B97:T97),0)","v":0},{"$f":"IF(U$87<=$B$18,SUM($B97:U97),0)","v":0},{"$f":"IF(V$87<=$B$18,SUM($B97:V97),0)","v":0}]
[null,null,{"$f":"IF(AND(C103>0,B103<0),C87+(1-C103/C97),0)","v":0},{"$f":"IF(AND(D103>0,C103<0),D87+(1-D103/D97),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"LNG","index":12,"n_rows":104,"n_cols":23,"rows_kept":104,"cut":false,"hidden":true,"merged":[]}
["1 - INPUT PARAMETERS ","Values","units","Comment","Name","Default","Range"]
[{"$f":"lblDrain1","v":"What is the cost of well-head blowers?"},{"$f":"drainage1","v":0},"$/HP"]
[{"$f":"lblDrain2","v":"What is the cost of satellite compressors?"},{"$f":"drainage2","v":1000},"$/HP"]
[{"$f":"lblDrain3","v":"What is the distance from the drainage area to the onsite project?"},{"$f":"drainage3","v":21000},"ft"]
[{"$f":"lblDrain4","v":"What is the cost of installing header pipe from the drainage area?"},{"$f":"drainage4","v":40},"$/ft"]
[{"$f":"lblDrain5","v":"What are the compressor and blower efficiencies?"},{"$f":"drainage5","v":3.5000000000000003E-2},"HP/mcfd"]
[{"$f":"lblDrain6","v":"What is the spacing between gob drainage wells?"},{"$f":"drainage6","v":1000},"ft"]
[{"$f":"lblDrain7","v":"What is the mining rate?"},{"$f":"drainage7","v":12000},"ft/yr"]
[{"$f":"lblDrain7alt","v":"How many drainage wells are being utilized?"},{"$f":"drainage7alt","v":0},"wells","If source = AMM"]
["What is the drainage gas source?",{"$f":"inputDrainageSource","v":"GW"}]
[{"$f":"lblDrain8","v":"What is the mine depth?"},{"$f":"drainage8","v":0},"ft/well"]
[{"$f":"lblDrain9","v":"What is the drilling cost?"},{"$f":"drainage9","v":0},"$/ft"]
[{"$f":"lblUser18","v":"What percent of CMM is consumed by prime-mover use?"},{"$f":"user18/100","v":7.0000000000000007E-2}]
[{"$f":"lblGas1","v":"What do you expect the CMM drained per day to be?"},{"$f":"gas1zz","v":1250},"mcf/d"]
["CMM drained per hour",{"$f":"B14/24","v":52.083333333333336},"mcf/h"]
[{"$f":"lblPctMethane","v":"Percent methane in drainage gas"},{"$f":"inputPctMethane/100","v":0.9},null,"Use 40% for CNG Feasibility Test"]
["Actual gas flow",{"$f":"IF(B16<>0,B14/B16,0)","v":1388.8888888888889},"mcf/d"]
[{"$f":"lblUser16","v":"What is the planned project operational lifetime?"},{"$f":"user16","v":10},"years",null,"lngProjectLifetime"]
[{"$f":"lblGas6","v":"What is the fraction of CMM available after losses?"},{"$f":"gas6zz/100","v":0.95}]
["Average fuel available",{"$f":"B15*(B19-B13)","v":45.833333333333329},"mcf/h","excludes fugitive and primemover use"]
["Fuel value",{"$f":"B20*B31/1000","v":41.708333333333329},"mmBtu/h"]
[]
[{"$f":"lblDefault5","v":"How many hours per year will the project operate?"},{"$f":"default5","v":0},"hours/yr","Defaults Parameter page",null,8000,"7500-8300"]
[{"$f":"lblUser32","v":"What is the installed capital cost of the LNG system?"},{"$f":"User32","v":0},"$,000","User Defined Input Page",null,{"$f":"OFFSET(User32,0,1)","v":3000},{"$f":"OFFSET(User32,0,4)","v":"[2,000-4,000]"}]
[{"$f":"lblUser2","v":"What is the cost of electric power used by the project?"},{"$f":"user2","v":0},"$/MW","User Defined Input Page",null,70,"50-90"]
[{"$f":"lblUser29","v":"What is the price of sold LNG?"},{"$f":"user29","v":0},"$/MMBtu","User Defined Input Page",null,{"$f":"OFFSET(user29,0,1)","v":0},{"$f":"OFFSET(user29,0,4)","v":"[2-20]"},null,"$/MMBtu"]
[{"$f":"lblUser37","v":"What is the cost of the oxygen removal system?"},{"$f":"user37","v":0},"$,000","User Defined Input Page - added May 2015",null,1250]
[{"$f":"lblDrain10","v":"What is the fraction of this project's drainage system cost that will be included in the analysis?"},{"$f":"drainage10/100","v":0},null,"added by JC 6/25"]
["Drainage and Transport sys unit cap cost",{"$f":"IF((B14*B19)<>0,(B3*B6)+(B4*B5*B16/(B14*B19))+(IF(B10=\"AM\",B7*B5*B9*B16/(B14*B19),0))+\n(B28*IF(inputDrainageSystem=\"Y\",(B2*B6)+IF(B10=\"AM\",B11*B12*B9*B16/(B14*B19),0),0)),0)","v":671.63157894736844},"$/mcfd","\"X\", tweaked by JC 6/25"]
["Drainage and Transport O&M cost",{"$f":"IF(AND(inputDrainageSource=\"GW\",(B14*B19)<>0,B23<>0),((B8*B5)+IF(AND(inputDrainageSystem=\"Y\",B7<>0),B8*B11*B12*B28/B7,0))*B16*24/(B14*B19)/B23,0)","v":0},"$/mcf","\"Y\", tweaked by JC 6/25"]
["CMM fuel value LHV",910,"Btu/cf","constant"]
["Weight of methane, tonnes",1.9259999999999999E-2,"tonnes/mcf","constant"]
[{"$f":"lblUser8","v":"What is the carbon credit unit sale price? "},{"$f":"user8","v":2},"$/tonne CO2E",null,"CER_UnitValue"]
["GWP ratio: methane to CO2",{"$f":"default20","v":25},"ratio","constant"]
[{"$f":"lblDefault21","v":"What is the inflation rate?"},{"$f":"default21/100","v":2.5000000000000001E-2},null,null,"InflationRate"]
[{"$f":"lblDefault26","v":"What is the real discount rate?"},{"$f":"default26/100","v":0.12},null,null,"RealDiscountRate"]
[{"$f":"lblUser12","v":"What is the developer's equity share in the project? "},{"$f":"user12/100","v":1},null,null,"EquityPercent"]
[{"$f":"lblUser15","v":"What is the loan term?"},{"$f":"user15","v":5},"yr",null,"loanTerm"]
[{"$f":"lblUser5","v":"What interest rate is charged for the loan? "},{"$f":"user5/100","v":0},null,null,"InterestRate"]
["Cap Cost Factors"]
[{"$f":"lblDefault7","v":"What is the contingency factor?"},{"$f":"default7/100","v":0.05}]
[{"$f":"lblDefault14","v":"What are the \"soft\" costs for the project?"},{"$f":"default14/100","v":0.05}]
["Annual Cost Factors"]
[{"$f":"lblDefault15","v":"What is the validation, verification and transaction cost to monetize carbon credits?"},{"$f":"default15","v":0.5},"$/tCO2e"]
[{"$f":"lblUser33","v":"What is the O&M cost of the LNG system?"},{"$f":"User33","v":0},"$/mcf"]
[{"$f":"lblDefault11","v":"What are the royalty and severance taxes?"},{"$f":"default11/100","v":0}]
[]
["CMM fuel value HHV",1010,"Btu/cf","constant"]
["2 - Feasibility Test"]
["CMM combusted in gathering sys. prime movers",{"$f":"B13*B15","v":3.6458333333333339},"mcf/h",{"$f":"_xlfn.FORMULATEXT(B50)","v":"=B13*B15"}]
["CMM entering processing system",{"$f":"heatAvailable","v":45.833333333333329},"mcf/h",{"$f":"_xlfn.FORMULATEXT(B51)","v":"=heatAvailable"}]
["CMM volume after processing (before liquefaction)",{"$f":"B20*(0.959-0.2644*(1-B16))","v":42.742333333333328},"mcf/h",{"$f":"_xlfn.FORMULATEXT(B52)","v":"=B20*(0.959-0.2644*(1-B16))"},null,null,null,null,null,"0.959 and 0.2644 come from the regression equation of the graph in fig 2 on page 36 of the original manual"]
["CMM available for other uses",0,"mcf/d",{"$f":"_xlfn.FORMULATEXT(B53)","v":{"$error":"#N/A"}}]
[]
["3 - Calculate Annual Benefits"]
[]
["LNG volume produced",{"$f":"B52*B31*1000*0.9/1000000","v":35.005971000000002},"MMBtu/h",{"$f":"_xlfn.FORMULATEXT(B57)","v":"=B52*B31*1000*0.9/1000000"},null,null,null,null,null,"0.9 = 10% of energy lost in liquefaction process"]
["Revenue from LNG sales",{"$f":"B57*B23*B26/1000","v":0},"$000/yr"]
["CMM available for carbon credits",{"$f":"B52+B50","v":46.388166666666663},"mcf/h"]
["Tonnes CH4 available for carbon credits",{"$f":"B59*B32","v":0.89343608999999991},"t/h"]
["Carbon credits earned per hour",{"$f":"B60*B34-(IF(B16=0,0,(B51*0.43*24*0.7457*default9/B16/1000)))","v":22.104677251111109},"t/h",{"$f":"_xlfn.FORMULATEXT(B61)","v":"=B60*B34-(IF(B16=0,0,(B51*0.43*24*0.7457*default9/B16/1000)))"},null,null,null,null,null,"0.43 = compression demands in mmscf/d per hp; 0.7457 = kw/hp  default9=electric grid emission factor (tonnes CO2/MWh)"]
["Carbon credits earned per year",{"$f":"B61*B23","v":0},"t/y",null,"lngCERsEarnedPerYear"]
["Carbon credit revenue per year",{"$f":"B62*B33/1000","v":0},"$000/y"]
[]
["4 - Calculate New Annual Costs"]
["LNG liquefaction system O&M cost",{"$f":"(B20*B45)*B23/1000","v":0},"$000/yr",{"$f":"_xlfn.FORMULATEXT(B66)","v":"=(B20*B45)*B23/1000"}]
["Processing system O&M cost",{"$f":"IF(B16<>0,(300)+(0.75*B23*B51/B16/1000)+(B51*B23*B25*0.43*24*0.7457/B16/1000/1000),0)","v":300},"$000/yr","=IF(B16<>0,(300)+(0.75*B23*B51/B16/1000)+(B51*B23*B25*0.43*24*0.7457/B16/1000/1000),0)",null,null,null,null,null,null,null,"Fixed O&M of $300K + variable O&M of $0.75/mcf + cost of electricity used"]
["Drain & transport O&M cost/h",{"$f":"IF(B16<>0,(B51*B30)/B16,0)","v":0},"$/h","=IF(B16<>0,(B51*B30)/B16,0)",null,null,null,null,null,null,null,"0.43 = compression demands in mmscf/d per hp"]
["Drain & transport O&M cost/y",{"$f":"B68*B23/1000","v":0},"$000/y","=B68*B23/1000",null,null,null,null,null,null,null,"0.7457 = kw/hp"]
["Carbon credit monetization cost/yr",{"$f":"B44*lngCERsEarnedPerYear/1000","v":0},"$000/y","=B44*lngCERsEarnedPerYear/1000",null,null,null,null,null,null,null,"24 = hr/d"]
["Royalty and severance taxes",{"$f":"B58*B46","v":0},"$000/y","=B58*B46"]
["Total annual cost",{"$f":"SUM(B66:B71)-B68","v":300},"$000/y",null,"lngTotalAnnualCost"]
[]
["5 - Calculate Project Capital Costs"]
["CMM needed per hour",{"$f":"B51","v":45.833333333333329},"mcf/h"]
["CMM transport system",{"$f":"IF(B16<>0,B29*B75*24/B16/1000,0)","v":820.8830409356724},"$,000",{"$f":"_xlfn.FORMULATEXT(B76)","v":"=IF(B16<>0,B29*B75*24/B16/1000,0)"}]
["Installed Cost of Processing Plant",{"$f":"IF(B16<>0,(B27)+(936)+(B51*24*(1.5765*(1-B16)+0.6196)/B16),0)","v":1885.9722222222222},"$,000",{"$f":"_xlfn.FORMULATEXT(B77)","v":"=IF(B16<>0,(B27)+(936)+(B51*24*(1.5765*(1-B16)+0.6196)/B16),0)"},null,"Plant cleans gas and compresses to 900 psi",null,null,null,null,null,"5/15  Cost of catox now included as user input - (1250 = was fixed cap cost of oxidizer)"]
["Installed Cost of LNG Liquefaction System",{"$f":"B24","v":0},"$,000",{"$f":"_xlfn.FORMULATEXT(B78)","v":"=B24"},null,null,null,null,null,null,null,"936, 1.5765, 0.6196 = come from regression equation on the curve in the Swing absorber graph (p.36 of original manual)"]
["  Subtotal",{"$f":"SUM(B76:B78)","v":2706.8552631578946},"$,000",{"$f":"_xlfn.FORMULATEXT(B79)","v":"=SUM(B76:B78)"}]
["Total cap cost with factors",{"$f":"(B79*(1+B42))*(1+B41)","v":2984.3079276315789},"$,000",{"$f":"_xlfn.FORMULATEXT(B80)","v":"=(B79*(1+B42))*(1+B41)"},"lngTotalCapCost"]
[]
["6 - Calculate Loan and Equity"]
["Loan amount",{"$f":"B80*(1-B37)","v":0},"$000",null,"lngLoanAmount"]
["Equity amount",{"$f":"B80*B37","v":2984.3079276315789},"$000",null,"lngEquityAmount"]
[]
["7 - Discounted Cash Flow Analysis","($000)"]
["Years >>>",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["A - Benefits"]
["Gas Sales Revenues",null,{"$f":"IF(C$87<=$B$18,B58,0)","v":0},{"$f":"IF(D$87<=$B$18,C89*(1+$B$35),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Carbon Credit Revenues",null,null,{"$f":"IF(C$87<=$B$18,$B63,0)","v":0},{"$f":"IF(D$87<=$B$18,D90*(1+default8/100),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Benefits",null,{"$f":"SUM(C89:C90)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["B - Costs"]
["Annual Drainage and Project O&M Cost",null,{"$f":"IF(C$87<=$B$18,-B72,0)","v":-300},{"$f":"IF(D$87<=$B$18,C93*(1+$B$35),0)","v":-307.5},-315.1875,-323.06718749999999,-331.14386718749995,-339.42246386718745,-347.90802546386709,-356.60572610046376,-365.52086925297533,-374.65889098429966,0,0,0,0,0,0,0,0,0,0]
["C - Cash Flow from Operations",null,{"$f":"SUM(C91:C93)","v":-300},-307.5,-315.1875,-323.06718749999999,-331.14386718749995,-339.42246386718745,-347.90802546386709,-356.60572610046376,-365.52086925297533,-374.65889098429966,0,0,0,0,0,0,0,0,0,0]
[]
["D - Debt Service",null,{"$f":"IF(OR(C$87>$B$38,C$87>$B$18),0, PMT($B$39, $B$38, $B$83))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["E - Net Cash Flow",{"$f":"-B84","v":-2984.3079276315789},{"$f":"SUM(C94:C96)","v":-300},{"$f":"SUM(D94:D96)","v":-307.5},-315.1875,-323.06718749999999,-331.14386718749995,-339.42246386718745,-347.90802546386709,-356.60572610046376,-365.52086925297533,-374.65889098429966,0,0,0,0,0,0,0,0,0,0]
[]
["8 - Financial Measurements: IRR, NPV, Payback"]
["Internal Rate of Return - IRR",null,{"$f":"IF(ISERR(IRR($B97:V97)),0,IRR($B97:V97))","v":0},"IRR needs at least one positive cash flow value.  ISERR catches error and returns \"0\""]
["Net Present Value",null,{"$f":"NPV(B36,C97:V97)+lngMinusEquityAmount","v":-4840.6669893011749}]
["Payback Period",null,{"$f":"SUM(C104:V104)","v":0}]
[null,{"$f":"IF(B$87<=$B$18,SUM($B97:B97),0)","v":-2984.3079276315789},{"$f":"IF(C$87<=$B$18,SUM($B97:C97),0)","v":-3284.3079276315789},{"$f":"IF(D$87<=$B$18,SUM($B97:D97),0)","v":-3591.8079276315789},{"$f":"IF(E$87<=$B$18,SUM($B97:E97),0)","v":-3906.9954276315789},{"$f":"IF(F$87<=$B$18,SUM($B97:F97),0)","v":-4230.0626151315792},{"$f":"IF(G$87<=$B$18,SUM($B97:G97),0)","v":-4561.2064823190794},{"$f":"IF(H$87<=$B$18,SUM($B97:H97),0)","v":-4900.6289461862671},{"$f":"IF(I$87<=$B$18,SUM($B97:I97),0)","v":-5248.5369716501345},{"$f":"IF(J$87<=$B$18,SUM($B97:J97),0)","v":-5605.142697750598},{"$f":"IF(K$87<=$B$18,SUM($B97:K97),0)","v":-5970.663567003573},{"$f":"IF(L$87<=$B$18,SUM($B97:L97),0)","v":-6345.3224579878724},{"$f":"IF(M$87<=$B$18,SUM($B97:M97),0)","v":0},{"$f":"IF(N$87<=$B$18,SUM($B97:N97),0)","v":0},{"$f":"IF(O$87<=$B$18,SUM($B97:O97),0)","v":0},{"$f":"IF(P$87<=$B$18,SUM($B97:P97),0)","v":0},{"$f":"IF(Q$87<=$B$18,SUM($B97:Q97),0)","v":0},{"$f":"IF(R$87<=$B$18,SUM($B97:R97),0)","v":0},{"$f":"IF(S$87<=$B$18,SUM($B97:S97),0)","v":0},{"$f":"IF(T$87<=$B$18,SUM($B97:T97),0)","v":0},{"$f":"IF(U$87<=$B$18,SUM($B97:U97),0)","v":0},{"$f":"IF(V$87<=$B$18,SUM($B97:V97),0)","v":0}]
[null,null,{"$f":"IF(AND(C103>0,B103<0),C87+(1-C103/C97),0)","v":0},{"$f":"IF(AND(D103>0,C103<0),D87+(1-D103/D97),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Report","index":13,"n_rows":114,"n_cols":4,"rows_kept":114,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Coalmine Methane Scenario: new_US"]
[null," "]
["Estimated Outputs:"]
[null,"Available CMM for other projects","0","mcf/d"]
[null,"Total capital cost",6398000,"$"]
[null,"Total annual cost",1247000,"$/year"]
[null,"Equity amount",6398000,"$"]
[" ","Loan amount","0,000","$"]
[null,"Carbon credits earned per year",168956,"tonne/year"]
[null,"Internal rate of return  (IRR)",20.28,"%"]
[null,"Net present value",2544000,"$"]
[null,"Payback period",5.4,"years"]
[null,"Installed electrical capacity","4.28","MW"]
[null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,""]
[null,""]
[]
[]
["Gathering & Delivery System"]
[null,"What is the cost of satellite compressors?",1000,"$/HP"]
[null,"What is the distance from the drainage area to the onsite project?",21000,"ft"]
[null,"What is the cost of installing header pipe from the drainage area?",40,"$/ft"]
[null,"What are the compressor and blower efficiencies?",3.5000000000000003E-2,"HP/mcfd"]
[null,"What is the mining rate?",12000,"ft/yr"]
[null,"What is the spacing between gob drainage wells?",1000,"ft"]
[]
["Drainage Well & Blower Development Costs:",null,"Not Applicable"]
[null,"What is the cost of well-head blowers?",null,"$/HP"]
[null,"What is the mine depth?",null,"ft"]
[null,"What is the drilling cost?",null,"$/ft"]
[null,"What is the fraction of this project's drainage system cost that will be included in the analysis?",null,"%"]
[]
["Gas Availability:"]
[null,"What is the source of the coal mine methane?","surface gob gas drainage"]
[null,"Percent methane in drainage gas",90,"%"]
[null,"What do you expect the CMM drained per day to be?",1250,"mcf/d"]
[null,"What is the fraction of CMM available after losses?",95,"%"]
[null,""]
[null,""]
[null,""]
[]
["User-Defined Inputs:"]
[null,"What is the planned project operational lifetime?",10,"years"]
[null,"What is the loan term?",5,"years"]
[null,"What interest rate is charged for the loan? ",0,"%"]
[null,"What is the developer's equity share in the project? ",100,"%"]
[null,"What is the carbon credit unit sale price? ",2,"$/tonne CO2E"]
[null,"What percent of CMM is consumed by prime-mover use?",7,"%"]
[null,"For what price can CMM-based electricity be sold?",7.0000000000000007E-2,"$/kWh"]
[null,"Capital cost of treatment, engine-gen set, & electrical equipment?",1.1499999999999999,"$000/kW"]
[null,"What is the O&M cost of the reciprocating engine?",0.02,"$/kWh"]
[null,"What is the overall efficiency of the engine-generator set?",35,"% (LHV)"]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[]
["Default Parameters:"]
[null,"What is the inflation rate?",2.5,"%"]
[null,"What is the real discount rate?",12,"%"]
[null,"What are the royalty and severance taxes?",0,"%"]
[null,"What is the contingency factor?",5,"%"]
[null,"What is the annual escalation rate for carbon credits? ",2,"%"]
[null,"What are the \"soft\" costs for the project?",5,"%"]
[null,"What is the validation, verification and transaction cost to monetize carbon credits?",0.5,"$/tCO2e"]
[null,"Which GWP value is used?",25]
[null,"How many hours per year will the engine operate?",8000,"hrs/year"]
[null,""]
[null,""]
[null,""]
[]
[]
[null,""]
[null,""]
[null,""]

{"sheet":"Report2","index":14,"n_rows":72,"n_cols":7,"rows_kept":72,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
["Coalmine Methane Scenario: yy"]
[null," "]
["Estimated Outputs:"]
[null,"Total capital cost",12128000,"$"]
[null,"Total annual cost","2,775,000","$/year"]
[null,"Equity amount",12128000,"$"]
[null,"Loan amount","0,000","$",null,null,""]
[null,"Carbon credits earned per year",474370,"tonne/year"]
[null,"Internal rate of return  (IRR)",0,"%"]
[null,"Net present value","-24,156,000","$"]
[null,"Payback Period","n/a","years"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Gas Availability"]
[null,"What percent methane is in the ventilation air?  ",0.5,"%"]
[null,"What do you expect the recoverable ventilation air flow to be?",500,"mcf/m"]
[]
[]
["User-Defined Inputs"]
[null,"What is the planned project operational lifetime?",10,"years"]
[null,"What is the loan term?",5,"years"]
[null,"What interest rate is charged for the loan? ",0,"%"]
[null,"What is the developer's equity share in the project? ",100,"%"]
[null,"What is the carbon credit unit sale price?",2,"$/tonne CO2E"]
[null,"What is the installed capital cost of the VAM oxidation system?",22,"$/cfm"]
[null,"What is the annual operating and maintenance of the VAM system?",1,"$/cfm-yr"]
[null,"What is the frequency VAM system will be relocated?",7,"years"]
[null,"What is VAM system relocation cost (incl. new site prep)?",3,"$/cfm"]
[null,"What is the electrical load of the oxidizer blowers?",0.1,"kWh/mcf"]
[null,"What is the cost of electric power used by the project?",70,"$/MWh"]
[]
[]
["Default Parameters:"]
[null,"What is the inflation rate?",2.5,"%"]
[null,"What is the real discount rate?",12,"%"]
[null,"What are the royalty and severance taxes?",4,"%"]
[null,"What is the contingency factor?",5,"%"]
[null,"How many hours per year will the VAM system operate?",8000,"hrs/year"]
[null,"What are the \"soft\" costs for the project?",5,"%"]
[null,"What is the validation, verification and transaction cost to monetize carbon credits?",0.5,"$/tCO2e"]

{"sheet":"reportWork","index":15,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[1,2,3,4,5,6,7,8,9,10]
[0,0,0,0,0,0,0,0,0,0]

{"sheet":"DevNotes","index":16,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["Reporting:","Most scenario worksheets need the following named ranges defined on that sheet, where Xxx is the scenario prefix. The six scenario prefixes are currently coal, boiler, engine, cflare, oflare, and pipeline."]
[null,"___: xxxCmmDrained"]
[null,"B16: XxxProjectLifetime"]
[null,"B33: XxxCER_UnitValue"]
[null,"B35: XxxInflationRate"]
[null,"B36: XxxRealDiscountRate"]
[null,"B37: XxxEquityPercent"]
[null,"B38: XxxLoanTerm"]
[null,"B39: XxxInterestRate"]
[null,"___: heatAvailable"]
[null,"___: heatNeeded"]
[null,"B48: XxxCmmAvailable"]
[null,"B57: XxxCersEarnedPerYear"]
[null,"B64: XxxTotalAnnualCost"]
[null,"B71: XxxTotalCapCost"]
[null,"B74: XxxLoanAmount"]
[null,"B75: XxxEquityAmount"]
[null,"C80: XxxSavingsYear1"]
[null,"C81: XxxCerRevYear1"]
[null,"C84: XxxCmmCostsYear1"]
[null,"B88: XxxMinusEquityAmount"]
[null,"B__: xxxSavingsPerYear1"]
[null,"C__: xxxSavings"]
[null,"C__: xxxCerRevYear1"]
[null,"C__: xxxCmmCostsYear1"]
[null,"C__: xxxIRR"]
[null,"CashFlowAnalysis"]
[]
["Goal Seek:","GoalSeek updates one of three inputs that the user had specified in order to achieve a certain IRR. These updates are done with direct cell references since the goal seek function didn't work when named ranges were used. The three input fields updated directly are Interest Rate, Equity Percent, and CER Unit Price."]