{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Read Me","Data Inputs","Design Parameters","Cost Estimate","Tables A & B"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Read Me","index":0,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[19,1,19,3],[18,4,18,13],[19,4,19,13],[13,1,13,13],[24,1,24,13],[14,1,14,3],[14,4,14,13],[15,4,15,13],[16,4,16,13],[17,4,17,13],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[26,1,26,13],[21,1,21,13],[22,1,22,13],[23,1,23,13],[25,1,25,13],[0,0,0,14],[1,0,1,14],[2,0,2,14],[3,0,3,14],[4,0,4,14],[5,0,5,14],[6,0,6,14],[8,1,8,13],[10,1,10,13],[12,1,12,13]]}
["Air Pollution Control Cost Estimation Spreadsheet"]
["For Elevated Flares"]
["U.S. Environmental Protection Agency "]
["Air Economics Group"]
["Health and Environmental Impacts Division"]
["Office of Air Quality Planning and Standards"]
["(September 2022)"]
[]
[null,"This spreadsheet allows users to estimate the capital and annualized costs for installing and operating flares to control emissions of volatile organic compounds (VOCs) from industrial waste gas streams. Flaring is a high-temperature oxidation process where combustible components of waste gases from industrial operations react with atmospheric oxygen to form carbon dioxide and water. They can be used to control almost any VOC steam and can handle fluctuations in VOC concentration, flow rate, heating value and inert content. Flares are used for waste streams with continuous, batch and variable flows and are often used for controlling emissions during emergency events, such as process upsets at chemical plants and refineries. The basic equipment required for a flare varies depending by the flare type (ground or elevated) and method of enhancing mixing at the flare tip (i.e., steam-assisted, air-assisted, pressure-assisted or non-assisted). The typical flare system consists of (1) a gas collection header and transport piping for collecting and conveying gases from process units to the flare, (2) a knockout drum (disentrainment drum) to remove and store condensables and entrained liquids, (3) a seal or purge gas supply to prevent flash-back, (4) a single- or multiple-burner unit and stack, (5) gas pilots and an ignitor to ignite the mixture of waste gas and air, and (6) steam injection or forced air for smokeless flaring. Natural gas, fuel gas, inert gas, or nitrogen can be used as purge gas.   "]
[]
[null,"The calculation methodologies used in this spreadsheet are those presented in the U.S. EPA's Air Pollution Control Cost Manual.  This spreadsheet is intended to be used in combination with the Control Cost Manual. For a detailed description of the technology and cost methodology, see Section 3.2 (VOC Destruction Controls), Chapter 1 (Flares) of the Air Pollution Control Cost Manual (as updated in 2019). A copy of the Control Cost Manual is available on the U.S. EPA's \"Technology Transfer Network\" website at: https://www.epa.gov/economic-and-cost-analysis-air-pollution-regulations/cost-reports-and-guidance-air-pollution.  "]
[]
[null,"This spreadsheet can be used to develop design parameters and estimate capital and annualized costs for elevated, steam-assisted flares. These are the most commonly used flares for industrial facilities. The methodology is designed to provide study-level cost estimates. Flares used at remote facilities, like upstream oil and gas facilities or landfills, are often non-assisted or air-assisted. The design and cost information provided in this spreadsheet are based on the information provided in Section 3.2 (VOC Destruction Controls), Chapter 1 (Flares) and do not apply to other flare types. Additionally, the methods provided in this chapter do not consider the design complexity and costs associated with a utility safety flare that service hundreds of sources. Actual costs, particularly those for installation, can deviate significantly from the costs generated using this spreadsheet due to site conditions. Units of measures in this spreadsheet are English units.  "]
[null,"Overview of Workbook"]
[null,"Tab",null,null,"Description of Tab Contents"]
[null,"Read Me",null,null,"Introduction and intructions"]
[null,"Data Inputs",null,null,"This tab is used for entering data needed to design and cost the flare. Enter the flare support type in row 3.  All other input cells are highlighted yellow. "]
[null,"Design Parameters",null,null,"This tab contains the calculations used to determine flare diameter, stack height, and other paramters needed to estimate costs of the flare system."]
[null,"Cost Estimates",null,null,"This tab contains the final cost outputs for the designed flare system."]
[null,"Table A & B",null,null,"This tab contains table of default flare monitoring costs (Table A) and a table for the fraction of heat radiated for common gases (Table B)."]
[]
[null,"Instructions "]
[null,"Step 1: Please select the Data Inputs tab to enter data needed to design and calt the flare system. You may click on the Reset Form button to reset the values on the Data Inputs tab.  "]
[null,"Step 2:  Use the drop down menu on Row 3 of the Data Inputs tab to select the type of flare support (preliminary selection).    "]
[null,"Step 3:  Complete all of the yellow data entry cells on the Data Inputs tab. Many of the fields are pre-populated with default values.  Where possible, replace the default values with site-specific values in accordance with the recommendations provided in the Control Cost Manual. Use of actual values rather than the default values in this spreadsheet is recommended. Sources for all values used should be appropriately documented. "]
[null,"Step 4:  Once all of the data fields are complete, select the Design Parameters tab to see the calculated design parameters for your flare. Review the calculated Height of Flare Stack in Row 7. If there is a warning message, the type of flare support selected in Step 2 is not applicable to the calculated flare stack height. In this case, go back to the Data Inputs tab and select an appropriate type of flare support. Generally,  self-supported flares may be selected if the flare stack height is 100 ft or less, guy-supported flares may be selected if the flare stack height is between 50 and 450 ft, and derrick-supported flares may be selected if the flare stack height is 200 ft or more. "]
[null,"Step 5: Select the Cost Estimate tab to view the estimated capital and total annual costs for the flare. If more than one type of flare support is applicable for the calculated flare stack height, you may wish to compare the costs calculated for each type of applicable flare support (by changing the selection in the drop down menu in the Data Inputs tab) and select the lowest cost flare support type for your specific application."]

{"sheet":"Data Inputs","index":1,"n_rows":96,"n_cols":16,"rows_kept":96,"cut":false,"hidden":false,"merged":[[94,2,94,3],[94,4,94,8],[95,2,95,3],[95,4,95,8],[47,3,47,9],[71,5,71,6],[46,3,46,9],[93,2,93,3],[93,4,93,8],[92,2,92,3],[91,4,91,8],[92,4,92,8],[91,2,91,3],[90,2,90,3],[90,4,90,8],[89,4,89,8],[89,2,89,3],[59,3,59,8],[61,0,62,5],[48,3,48,8]]}
[null,null,"Data Inputs",null,null,null,null,null,null,null,null,3,"Select",null,0,1]
[null,null,null,null,null,null,null,null,null,null,null,null,"Self-Supported",null,"yes",2]
["Select the type of elevated flare support:",null,{"$f":"IF(L1=1,\"Enter flare support type\",\"\")","v":""},null,null,null,null,null,null,null,null,null,"Guy-Supported ",null,"no",3]
[null,null,null,null,null,null,null,null,null,null,null,null,"Derrick-supported",null,"Water Seal",4]
["Enter the design data for the proposed Flare:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Flame Arrestor",5]
["Characteristics of the Flare Gas:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["Enter flare gas composition information for up to five different operating conditions. Enter the corresponding number of operating hours for each operating  in cells B30 through B35. "]
["Waste Gas Flow Rate at Condition 1 (Q1)",3000,"scfm (at 68oF and 1 atm)"]
["Waste Gas Flow Rate at Condition 2 (Q2)",300,"scfm (at 68oF and 1 atm)"]
["Waste Gas Flow Rate at Condition 3 (Q3)",100,"scfm (at 68oF and 1 atm)"]
["Waste Gas Flow Rate at Condition 4 (Q4)",500,"scfm (at 68oF and 1 atm)"]
["Waste Gas Flow Rate at Condition 5 (Q5)",200,"scfm (at 68oF and 1 atm)"]
["Waste Gas Net Heat Content at Condition 1 (Bv,1)",1500,"Btu/scf"]
["Waste Gas Net Heat Content at Condition 2 (Bv,2)",150,"Btu/scf"]
["Waste Gas Net Heat Content at Condition 3 (Bv,3)",150,"Btu/scf"]
["Waste Gas Net Heat Content at Condition 4 (Bv,4)",150,"Btu/scf"]
["Waste Gas Net Heat Content at Condition 5 (Bv,5)",600,"Btu/scf"]
["Average Molecular Weight of the waste gas stream (MW)",40,"lbs/lb-mol"]
["Average VOC Emission Rate at Condition 1 (Mvoc-1) ",1500,"lb/hour"]
["Average VOC Emission Rate at Condition 2 (Mvoc-2) ",100,"lb/hour"]
["Average VOC Emission Rate at Condition 3 (Mvoc-3) ",100,"lb/hour"]
["Average VOC Emission Rate at Condition 4 (Mvoc-4) ",100,"lb/hour"]
["Average VOC Emission Rate at Condition 5 (Mvoc-5) ",100,"lb/hour"]
["Pressure at Waste Gas Collection Point (P)",10,"psig",{"$f":"IF(B24=0.65,\"* 0.65 Btu/lb-mole-°F is a default value. User should enter actual value, if known.\",\" \")","v":" "}]
["Liquid Density (ρl) ",49.6,"lb/cubic feet"]
["Vapor Density (ρv) ",8.4500000000000006E-2,"lb/cubic feet"]
["Temperature (T)",68,"oF"]
[]
["Operating Characteristics for the Flare:"]
["Number of Operating Hours at Condition 1 (t1)",100,"hours/year","Total Annual Hours = ",{"$f":"SUM(B30:B34)","v":500}]
["Number of Operating Hours at Condition 2 (t2)",100,"hours/year","Total Waste Gas Flow Hours = ",{"$f":"SUMIF(B8:B12,\">0\",B30:B34)","v":500}]
["Number of Operating Hours at Condition 3 (t3)",100,"hours/year"]
["Number of Operating Hours at Condition 4 (t4)",100,"hours/year"]
["Number of Operating Hours at Condition 5 (t5)",100,"hours/year"]
["Required VOC removal/destruction efficiency of flare (DE)",98,{"$f":"\"%\"&(IF(B35=98, \"*\",\"\"))","v":"%*"},{"$f":"IF(B35=98,\"* 98% is a default control efficiency. User should enter actual value, if known.\",\" \")","v":"* 98% is a default control efficiency. User should enter actual value, if known."}]
["Fraction of Heat Radiated (f)",0.3,null,"See Table B for default values for common gases. Use 0.3 if the fraction of heat radiated is unknown."]
["Pressure at Knockout Drum (Pk)",5,"psig",{"$f":"IF(B37=5,\"* 5 psig is a default value. User should enter actual value, if known.\",\" \")","v":"* 5 psig is a default value. User should enter actual value, if known."}]
["Pressure at the Flare Tip (Pt)",1,"psig",{"$f":"IF(B38=1,\"* 1 psig is a default value. User should enter actual value, if known.\",\" \")","v":"* 1 psig is a default value. User should enter actual value, if known."}]
["Estimated equipment life (n)",15,{"$f":"\"Years\"&IF(B39=15,\"*\",\"\")","v":"Years*"},{"$f":"IF(B39=15,\"* 15 years is a default equipment life. User should enter actual value, if known.\",\" \")","v":"* 15 years is a default equipment life. User should enter actual value, if known."}]
["Length of Vent Stream Piping Required (L)",100,{"$f":"\"Feet\"&IF(B40<=100,\"*\",\"\")","v":"Feet*"},{"$f":"IF(B40<100,\"* The MINUMUM  value for pipe length is 100 ft. Please enter a value of atleast 100.\",IF(B40 =100,\"* 100 feet is a default value representing the minimum piping length. User should enter actual value, if known.\",\" \"))","v":"* 100 feet is a default value representing the minimum piping length. User should enter actual value, if known."}]
["Is a flame arrestor needed?","no",null,{"$f":"IF(AND(B41=\"yes\",B42=\"yes\"),\"* Generally, you do not need a flame arrestor when you have a FGRS\",\" \")","v":" "}]
["Do you intend to use a flare gas recovery system (FGRS)?","no"]
["Which flow condition should be used to size the FGRS?",1,{"$f":"IF(B$42=\"no\",\"Not applicable\", \" \")","v":"Not applicable"}]
["Number of compressors in FGRS",2,"Not applicable"]
["Design flow factor per compressor",1.2,{"$f":"IF(B$42=\"no\",\"Not applicable\", \" \")","v":"Not applicable"},"Suggested factors: 1.3 for 1 compressor; 1.2 for 2 compressors; 0.6 for 3 compressors; 0.4 for 4 compressors"]
["Fraction of time the FGRS is operational during the year",0.98,"fraction ",{"$f":"IF(AND(B42=\"yes\",B44=1,B46>0.95),\"* With only one compressor, compresssor downtime will typically limit average efficiency to 95% or less.\",\" \")","v":" "}]
["Combustion Zone Factor (K1)",1,null,"Enter 1 if the net heating value target is assessed in the combustion zone (as required for compliance with 40 CFR 63.670). \nEnter 0 if the new heating value target is assessed based on the flare gas (as required for compliance with 40 CFR 60.18 and 40 CFR 63.11). "]
["Net Heating Value Operational Target (NHVtarget)",300,"Btu/scf","Enter a value from 300 to 330  Btu/scf for flares complying with 40 CFR 60.18 and 40 CFR 63.11. \nFor flares complying with 40 CFR 63.670, enter a value from 270 to 297  Btu/scf."]
["Do you intend to meet NHVtarget when waste gas flow is zero?","no",null,"Flares complying with 40 CFR 63.670 are only required to meet the NHVtarget when regulated material is sent to the flare. \nIf the sweep or purge gas may contain regulated material, you should select \"yes\". Otherwise, you may select \"no\""]
["Heat Content of the Auxiliary Fuel (Bf) ",920,{"$f":"\"Btu/scf\"&(IF(B50=920,\"*\",\" \"))","v":"Btu/scf*"},{"$f":"IF(B50=920,\"* 920 Btu/scf is a default value. User should enter actual value, if known.\",\" \")","v":"* 920 Btu/scf is a default value. User should enter actual value, if known."}]
[]
["Operating and Maintenance Labor for the Flare System:"]
["Expected Number of Operator Labor Hours Annually",630,{"$f":"\"hours/year\"&IF(B53=630,\"*\",\"\")","v":"hours/year*"},{"$f":"IF(B53=630,\"* 630 hours/year is a default value for flares operated continuously. User should enter actual value, if known.\",\" \")","v":"* 630 hours/year is a default value for flares operated continuously. User should enter actual value, if known."}]
["Expected Number of Maintenance Labor Hours per Shift",0.5,{"$f":"\"hours/shift\"&IF(B54=0.5,\"*\",\"\")","v":"hours/shift*"},{"$f":"IF(B54=0.5,\"* 0.5 hours/year is a default value for flares operated continuously. User should enter actual value, if known.\",\" \")","v":"* 0.5 hours/year is a default value for flares operated continuously. User should enter actual value, if known."}]
[]
["Enter cost data for the flare:"]
[]
["Desired dollar-year ",2021]
[{"$f":"\"CEPCI* for \" & B58","v":"CEPCI* for 2021"},708,{"$f":"\"CEPCI value for \"&B58","v":"CEPCI value for 2021"},null,567.5,"2017 CEPCI"]
["Annual Interest Rate (i)",5.5,{"$f":"(IF(B60<>5,\"% (Current bank prime rate)\",\"%*\"))","v":"% (Current bank prime rate)"},{"$f":"IF(B60=5,\"* 5% is a default value. User should enter current prime bank rate, available at http://www.federalreserve.gov/releases/h15/.\", \"\")","v":""}]
[]
["* CEPCI is the Chemical Engineering Plant Cost Index. The use of CEPCI in this spreadsheet is not an endorsement of the index for purpose of cost escalation or de-escalation, but is there merely to allow for availability of a well-known cost index to spreadsheet users. Use of other well-known cost indexes (e.g., M&S) is acceptable."]
[]
[]
["Steam (Costs)",7.7,{"$f":"\"per 1,000 lbs\"&IF(B65=5, \"*\",\"\")","v":"per 1,000 lbs"},{"$f":"IF(B65=7.7,\"* $7.70/1,000 lbs is a default value for 2017. User should enter actual value for desired year, if known.\",\"\")","v":"* $7.70/1,000 lbs is a default value for 2017. User should enter actual value for desired year, if known."}]
["Natural Gas (Costfuel)",4.1399999999999997,{"$f":"\"per Mscf\"&IF(B66=4.14, \"*\",\"\")","v":"per Mscf*"},{"$f":"IF(B66=4.14,\"* $4.14/Mscf is a default value for 2017. User should enter actual value for desired year, if known.\",\"\")","v":"* $4.14/Mscf is a default value for 2017. User should enter actual value for desired year, if known."}]
["Electricity (CostElec)",6.88E-2,"per Kw-hr",{"$f":"IF(B67=0.0688,\"* $0.0688/kW-hr is a default value for 2017. User should enter actual value for desired year, if known.\",\"\")","v":"* $0.0688/kW-hr is a default value for 2017. User should enter actual value for desired year, if known."}]
["Operator Labor Rate",29.63,{"$f":"\"per hour\"&IF(B68=27.48,\"*\",\"\")","v":"per hour"},{"$f":"IF(B68=29.63,\"* $29.63/hour is a default value for 2017. User should enter actual value for desired year, if known.\",\"\")","v":"* $29.63/hour is a default value for 2017. User should enter actual value for desired year, if known."}]
["Maintenance Labor Rate",25.12,{"$f":"\"per hour\"&IF(B69=30.23,\"*\",\"\")","v":"per hour"},{"$f":"IF(B69=25.12,\"* $25.12/hour is a default value for 2017. User should enter actual value for desired year, if known. If the rate is not known, use 1.10 x operator labor rate.\",\"\")","v":"* $25.12/hour is a default value for 2017. User should enter actual value for desired year, if known. If the rate is not known, use 1.10 x operator labor rate."}]
[]
["Monitoring Equipment Cost (CM): "]
[null,"Indicate which monitoring equipment is needed:",{"$f":"\"If available, enter site-specific monitoring costs in \"&B58&\" dollars. Otherwise, leave blank and default values will be used.\"","v":"If available, enter site-specific monitoring costs in 2021 dollars. Otherwise, leave blank and default values will be used."},null,null,{"$f":"\"Values Used For Monitoring Equipment Costs (Cm) in \"&B58&\" Dollars\"","v":"Values Used For Monitoring Equipment Costs (Cm) in 2021 Dollars"}]
["Pilot Flame Monitor ","yes",null,null,null,{"$f":"IF(B73=\"yes\",IF(OR(C73=\"\",C73=0),'Tables A & B'!B4,C73),0)","v":5115.0660792951539},{"$f":"IF(B73=\"yes\",(IF(F73='Tables A & B'!B4,\"(Based on default cost)\",\"(Based on actual cost)\")),\" \")","v":"(Based on default cost)"},null,null,null,null,null,{"$f":"IF(OR(G73=\" \",G73=\"(Based on default cost)\"),0,1)","v":0}]
["Gas Chromatograph (GC)","no",null,null,null,{"$f":"IF(B74=\"yes\",IF(OR(C74=\"\",C74=0),'Tables A & B'!B5,C74),0)","v":0},{"$f":"IF(B74=\"yes\",(IF(F74='Tables A & B'!B5,\"(Based on default cost)\",\"(Based on actual cost)\")),\" \")","v":" "},null,null,null,null,null,0]
["Hydrogen Analyzer","yes",null,null,null,{"$f":"IF(B75=\"yes\",IF(OR(C75=\"\",C75=0),'Tables A & B'!B6,C75),0)","v":46035.594713656392},{"$f":"IF(B75=\"yes\",(IF(F75='Tables A & B'!B6,\"(Based on default cost)\",\"(Based on actual cost)\")),\" \")","v":"(Based on default cost)"},null,null,null,null,null,0]
["Calorimeter","no",null,null,null,{"$f":"IF(B76=\"yes\",IF(OR(C76=\"\",C76=0),'Tables A & B'!B7,C76),0)","v":0},{"$f":"IF(B76=\"yes\",(IF(F76='Tables A & B'!B7,\"(Based on default cost)\",\"(Based on actual cost)\")),\" \")","v":" "},null,null,null,null,null,0]
["Flare Gas Flow Monitor","no",null,null,null,{"$f":"IF(B77=\"yes\",IF(OR(C77=\"\",C77=0),'Tables A & B'!B8,C77),0)","v":0},{"$f":"IF(B77=\"yes\",(IF(F77='Tables A & B'!B8,\"(Based on default cost)\",\"(Based on actual cost)\")),\" \")","v":" "},null,null,null,null,null,0]
["Steam Fine Controls/Metering","no",null,null,null,{"$f":"IF(B78=\"yes\",IF(OR(C78=\"\",C78=0),'Tables A & B'!B9,C78),0)","v":0},{"$f":"IF(B78=\"yes\",(IF(F78='Tables A & B'!B9,\"(Based on default cost)\",\"(Based on actual cost)\")),\" \")","v":" "},null,null,null,null,null,0]
["Air Fine Controls/Metering","no",null,null,null,{"$f":"IF(B79=\"yes\",IF(OR(C79=\"\",C79=0),'Tables A & B'!B10,C79),0)","v":0},{"$f":"IF(B79=\"yes\",(IF(F79='Tables A & B'!B10,\"(Based on default cost)\",\"(Based on actual cost)\")),\" \")","v":" "},null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(B73:B79,\"yes\")","v":2}]
["If known, enter any additional capital costs for utilities and installation costs for site preparation and building construction/modification:"]
["Capital Equipment Costs for Utilities (CU) =",0,{"$f":"IF(B82=0, \"* Default value. User should enter actual value for desired year, if known.\",\" \")","v":"* Default value. User should enter actual value for desired year, if known."}]
["Site Preparation (SP) =",0,{"$f":"IF(B83=0, \"* Default value. User should enter actual value, if known.\",\" \")","v":"* Default value. User should enter actual value, if known."}]
["Buildings (Bldg) =",0,{"$f":"IF(B84=0, \"* Default value. User should enter actual value, if known.\",\" \")","v":"* Default value. User should enter actual value, if known."}]
["Contingency Factor (CF) =",10,{"$f":"\"percent\"&IF(B85>=10,\"*\",\"\")","v":"percent*"},{"$f":"IF(B85=10,\"* 10 percent is a default value. The contingency factor should be between 5 and 15 percent.\",(IF(B85>15, \"* The value you entered is higher than expected. Contingency factors are typically between 5 and 15%\", \" \")))","v":"* 10 percent is a default value. The contingency factor should be between 5 and 15 percent."}]
[]
[]
["Data Sources for Default Values Used in Calculations: "]
[]
["Data Element","Default Value","Sources for Default Value",null,"If you used your own site-specific values, please reference  the source from which the site-specific value was derived. ",null,null,null,null,"Recommended data sources for site-specific information"]
["Natural Gas Price ($/Mscf)",4.1399999999999997,"Average annual natural gas price for industrial facilities in 2017 based on data from Department of Energy, Energy Information Administration (Available at https://www.eia.gov/dnav/ng/ng_pri_sum_dcu_nus_a.htm).",null," ",null,null,null,null,"Plant's utility bill or use Department of Energy, Energy Information Administration (EIA) data for most recent year. Available at http://www.eia.gov/electricity/data.cfm#sales. "]
["Operator Labor Rate ($/hour)",29.63,"Bureau of Labor Statistics - May 2017 median labor costs for occupational code (51-8091).",null," ",null,null,null,null,"Use payroll data, if available, or check current edition of the Bureau of Labor Statistics, National Occupational Employment and Wage Estimates – United States (https://data.bls.gov/oes/#/occGeo/One%20occupation%20for%20multiple%20geographical%20areas)."]
["Maintenance Labor Rate ($/hour)",25.12,"Bureau of Labor Statistics - May 2017 median labor costs for occupational code (49-9040).",null," ",null,null,null,null,"Use payroll data, if available, or check current edition of the Bureau of Labor Statistics, National Occupational Employment and Wage Estimates – United States (https://data.bls.gov/oes/#/occGeo/One%20occupation%20for%20multiple%20geographical%20areas).  "]
["Steam ($/1,000 lb.)",{"$f":"ROUND(1.3*(1128*1000/920*(B91/1000)/0.857),2)","v":7.7},"Price of steam was estimated using the industrial gas price, 85.7% overall boiler efficiency for delivered steam, a NHV value for natural gas of 920 Btu/scf, steam pressure of 150 psig and inlet water temperature of 100 deg. F (energy need of 1,128 Btu/lb steam; see U.S. DOE, 2012. Available at https://www.energy.gov/sites/prod/files/2014/05/f16/steam15_benchmark.pdf) then multiplying fuel cost by 1.3 (U.S. DOE , 2003) to estimate total cost of steam.",null," ",null,null,null,null,"Use actual values if known, or estimate steam cost as 1.3 x Fuel Cost for oil and gas-fired facilities. See also Department of Energy, Energy Efficiency and Renewable Energy, \" How to Calculate the True Cost of Steam.\" DOE/GO-102003-1736, September 2003 (available at https://www.energy.gov/sites/prod/files/2014/05/f15/tech_brief_true_cost.pdf) and \"Benchmark the Fuel Cost of Steam Generation.\" DOE/GO-102012-3391, January 2012 (Available at https://www.energy.gov/sites/prod/files/2014/05/f16/steam15_benchmark.pdf)"]
["Electricity ($/Kw-hr)",6.88E-2,"U.S. annual average industrial price  electricity for 2017 (EIA). https://www.eia.gov/electricity/annual/html/epa_02_04.html ",null," "]
[null,null,null,null," "]

{"sheet":"Design Parameters","index":2,"n_rows":82,"n_cols":16,"rows_kept":82,"cut":false,"hidden":false,"merged":[[7,15,8,15],[0,0,0,5],[2,0,2,5],[80,0,81,0],[63,0,64,0],[7,13,8,13],[7,11,7,12],[7,14,8,14],[33,1,37,1]]}
["Design Parameters"]
[]
["The following design parameters for the flare are calculated based on the values entered on the Data Inputs tab. These values are used to prepare the costs shown on the Cost Estimate tab."]
[]
["Key Design Parameters","Warnings (if applicable)","Calculated Value","Units"]
["Flare Tip Diameter (D)",null,{"$f":"C27","v":8},{"$f":"D27","v":"inches"}]
["Height of Flare Stack (H)",{"$f":"IF('Data Inputs'!L1=1,\"Enter flare support type in Row 3 of Data Inputs tab\",IF(AND('Data Inputs'!L1=2,C7>100),\"Flare height exceeds height for self-supported flare. Select different flare type.\",IF(AND('Data Inputs'!L1=3,C7>450),\"Flare height exceeds height for guy-supported flare. Select derrick-supported flare type.\",IF(AND('Data Inputs'!L1=3,C7<50),\"Flare height is less than that used for guy-supported flares. Select self-supported flare type.\", IF(AND('Data Inputs'!L1=4,C7<200),\"Flare height is less that that used for derrick-supported flare. Select a different flare type.\",\"\")))))","v":""},{"$f":"C28","v":121},{"$f":"D28","v":"ft."}]
[null,null,null,null,null,null,null,null,null,null,null,"Identify Max Flow and Min Velocity Condition",null,"Allowed Velocity (ft/s)","Heat Release (MMBtu/hr)","Diameter (in)"]
["Parameter","Equation","Calculated Value","Units",null,null,null,null,null,null,null,"Q + Fmin","NHV vent gas"]
["Total Annual Hours (top) ="," t1 + t2 + t3 + t4 + t5 =",{"$f":"'Data Inputs'!E30","v":500},"hours/year",null,null,null,null,null,null,1,{"$f":"'Data Inputs'!B8+IF('Data Inputs'!B13<'Data Inputs'!$B$48,IF('Data Inputs'!B8=0,1,'Data Inputs'!B8)*('Data Inputs'!$B$48-'Data Inputs'!B13)/('Data Inputs'!$B$50-'Data Inputs'!$B$48),0)","v":3000},{"$f":"IF(L10=0,1000,('Data Inputs'!B13*'Data Inputs'!B8+'Data Inputs'!$B$50*(L10-'Data Inputs'!B8))/(L10))","v":1500},{"$f":"IF(M10<300,60,IF(M10>=1000,400,(10)^((M10+1212)/850)))","v":400},{"$f":"L10*M10*60/1000000","v":270},{"$f":"1.95*SQRT((L10*((460+'Data Inputs'!$B$27)/(460+68))*(14.7/(14.7+'Data Inputs'!$B$38)))/N10)","v":5.1674238367178917}]
["Total Waste Gas Flow Hours (twaste gas) =","Σt if waste gas flow>0",{"$f":"'Data Inputs'!E31","v":500},"hours/year",null,null,null,null,null,null,2,{"$f":"'Data Inputs'!B9+IF('Data Inputs'!B14<'Data Inputs'!$B$48,IF('Data Inputs'!B9=0,1,'Data Inputs'!B9)*('Data Inputs'!$B$48-'Data Inputs'!B14)/('Data Inputs'!$B$50-'Data Inputs'!$B$48),0)","v":372.58064516129031},{"$f":"IF(L11=0,1000,('Data Inputs'!B14*'Data Inputs'!B9+'Data Inputs'!$B$50*(L11-'Data Inputs'!B9))/(L11))","v":299.99999999999994},{"$f":"IF(M11<300,60,IF(M11>=1000,400,(10)^((M11+1212)/850)))","v":60.092950704448363},{"$f":"L11*M11*60/1000000","v":6.7064516129032246},{"$f":"1.95*SQRT((L11*((460+'Data Inputs'!$B$27)/(460+68))*(14.7/(14.7+'Data Inputs'!$B$38)))/N11)","v":4.6983117782751807}]
["Maximum Total Volumetric Flow at Flare Tip (Qtot) =","(Qmax + Fmin) x (Tactual/Ts) x (Ps/Pt) = ",{"$f":"MAX(L10:L14)*((460+'Data Inputs'!B27)/(460+68))*(14.7/(14.7+'Data Inputs'!B38))","v":2808.9171974522292},"acfm",null,null,null,null,null,null,3,{"$f":"'Data Inputs'!B10+IF('Data Inputs'!B15<'Data Inputs'!$B$48,IF('Data Inputs'!B10=0,1,'Data Inputs'!B10)*('Data Inputs'!$B$48-'Data Inputs'!B15)/('Data Inputs'!$B$50-'Data Inputs'!$B$48),0)","v":124.19354838709677},{"$f":"IF(L12=0,1000,('Data Inputs'!B15*'Data Inputs'!B10+'Data Inputs'!$B$50*(L12-'Data Inputs'!B10))/(L12))","v":300},60.092950704448363,2.2354838709677423,{"$f":"1.95*SQRT((L12*((460+'Data Inputs'!$B$27)/(460+68))*(14.7/(14.7+'Data Inputs'!$B$38)))/N12)","v":2.712571569923965}]
["Vent Stream Flow at Actual Conditions in the Knockout Drum (Qactual) = ","Qmax x (Tactual/Ts) x (Ps/Pk) = ",{"$f":"MAX(L10:L14)*((460+'Data Inputs'!B27)/(460+68))*(14.7/(14.7+'Data Inputs'!B37))","v":2238.5786802030457},"acfm",null,null,null,null,null,null,4,{"$f":"'Data Inputs'!B11+IF('Data Inputs'!B16<'Data Inputs'!$B$48,IF('Data Inputs'!B11=0,1,'Data Inputs'!B11)*('Data Inputs'!$B$48-'Data Inputs'!B16)/('Data Inputs'!$B$50-'Data Inputs'!$B$48),0)","v":620.9677419354839},{"$f":"IF(L13=0,1000,('Data Inputs'!B16*'Data Inputs'!B11+'Data Inputs'!$B$50*(L13-'Data Inputs'!B11))/(L13))","v":300},60.092950704448363,11.17741935483871,{"$f":"1.95*SQRT((L13*((460+'Data Inputs'!$B$27)/(460+68))*(14.7/(14.7+'Data Inputs'!$B$38)))/N13)","v":6.06549442418331}]
["Net Heat Release (R ) =","[(Qmax x Bv,max) + (Fa,max x Bf] x 60 =",{"$f":"MAX(O10:O14)*1000000","v":270000000},"Btu/hour",null,null,null,null,null,null,5,{"$f":"'Data Inputs'!B12+IF('Data Inputs'!B17<'Data Inputs'!$B$48,IF('Data Inputs'!B12=0,1,'Data Inputs'!B12)*('Data Inputs'!$B$48-'Data Inputs'!B17)/('Data Inputs'!$B$50-'Data Inputs'!$B$48),0)","v":200},{"$f":"IF(L14=0,1000,('Data Inputs'!B17*'Data Inputs'!B12+'Data Inputs'!$B$50*(L14-'Data Inputs'!B12))/(L14))","v":600},135.44553902831271,7.2,{"$f":"1.95*SQRT((L14*((460+'Data Inputs'!$B$27)/(460+68))*(14.7/(14.7+'Data Inputs'!$B$38)))/N14)","v":2.2928523949886723}]
[]
["Amount of VOC Removed:",null,null,null,null,null,null,null,null,null,null,"Stack Diameter","Adjusted Stack Diameter"]
["VOC Removed (Wvoc) =","Wvoc = ∑ (Mvoc-i x ti x DE)/2000 =",{"$f":"((('Data Inputs'!B30*'Data Inputs'!B19)+('Data Inputs'!B31*'Data Inputs'!B20)+('Data Inputs'!B32*'Data Inputs'!B21)+('Data Inputs'!B33*'Data Inputs'!B22)+('Data Inputs'!B34*'Data Inputs'!B23))*('Data Inputs'!B35/100))/2000","v":93.1},"tons/year",null,null,null,null,null,null,null,{"$f":"MAX(P10:P14)","v":6.06549442418331},{"$f":"IF(L17<=24,M18,M19)","v":8},"Ajusted for available stack diameters:  2 inch increments for diameters less than or equal to diamters calcualted to be 24 inches. 6 inch increments for diameters calculated to be >24 inches."]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.CEILING.MATH(L17,2)","v":8}]
["Estimated Knock-out Drum Specifications: ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.CEILING.MATH(L17,6)","v":12}]
["Maximum Design Vapor Velocity (U) =","0.2 x [(ρl - ρv)/ρv]0.5  = ",{"$f":"0.2*SQRT(('Data Inputs'!B25-'Data Inputs'!B26)/'Data Inputs'!B26)","v":4.8414140435236899},"ft./sec.",null,null,null,null,null,null,null,"Knock-out Drum Diameter:","Calculated Value"]
["Minimum Vessel Cross-Sectional Area (A) = ","Qactual/(60 x U) =",{"$f":"(C13/(60*C20))","v":7.7063527999551056},"sq. ft.",null,null,null,null,null,null,null,{"$f":"_xlfn.CEILING.MATH(M21,6)","v":42},{"$f":"(13.5*SQRT(C21))","v":37.476429896560553}]
["Drum Diameter (d) (rounded to the next largest drum size in 6-inch increments) =","13.5 x √A = ",{"$f":"L21","v":42},"inches",{"$f":"IF(M21=L21*6,\" \", \"* Drum diameter rounded to next largest size.\")","v":"* Drum diameter rounded to next largest size."},null,null,null,null,null,null,"Stack Height"]
["Drum Height (h) =","3 x d =",{"$f":"(3*C22)/12","v":10.5},"ft.",null,null,null,null,null,null,null,{"$f":"INT(7+SQRT((1*'Data Inputs'!B36*'Design Parameters'!C14)/(4*PI()*500))+1)","v":121}]
["Drum Thickness (t) = ",{"$f":"\"(based on vessel diameter of \"&C22&\" inches- See Table 1.4 in Cost Manual Chapter)\"","v":"(based on vessel diameter of 42 inches- See Table 1.4 in Cost Manual Chapter)"},{"$f":"N31","v":0.37},"inches",null,null,null,null,null,null,null,"Vessel Thickness based on diameter"]
[null,null,null,null,null,null,null,null,null,null,null,"Diameter","Thickness, t"]
["Estimated Flare Dimensions: ",null,null,null,null,null,null,null,null,null,null,"less 36",0.25,{"$f":"IF(C$22<36, M26, 0)","v":0}]
["Flare Tip Diameter (D) =","1.95 x (Qtot/Vmax)0.5 = ",{"$f":"M17","v":8},"inches",{"$f":"IF(L17=M17, \" \",\"* Diameter rounded to next largest available size.\")","v":"* Diameter rounded to next largest available size."},null,null,null,null,null,null,"between 36 and 72",0.37,{"$f":"IF(AND(C$22>=36,C$22<72), M27, 0)","v":0.37}]
["Height of Flare Stack (H) =","7 feet + [(τ x f x R)/(4π x 500 Btu/hr-sq.ft)]0.5 =",{"$f":"IF(L23<30, 30, L23)","v":121},"ft.",{"$f":"IF(L23<30, \"Stack height must be at least 30 feet\", \" \")","v":" "},null,null,null,null,null,null,"between 72 and 108",0.55000000000000004,{"$f":"IF(AND(C$22>=72,C$22<108), M28, 0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"between 108 and 144",0.75,{"$f":"IF(AND(C$22>=108,C$22<144), M29, 0)","v":0}]
["Steam Consumption:",null,null,null,null,null,null,null,null,null,null,"greater than 144",1,{"$f":"IF(C$22>=144, M30, 0)","v":0}]
["Minimum Required Steam Flow Rate (Mmin) =","[(46 lbs steam/hour)/1 inch of flare diameter] x D =",{"$f":"46*C27","v":368},"lbs./hour",null,null,null,null,null,null,null,null,"thickness, t =",{"$f":"SUM(N26:N30)","v":0.37}]
["Minimum Required Steam Flow Rate ="," (Mmin/60 mins/hour) x (385.3 scf/lb-mol/18 lb/lb-mol) = ",{"$f":"(C31/60)*(385.3/18)","v":131.28740740740741},"scfm"]
[]
["Initial estimate of mass steam flow rate at Condition 1 (M1)= ","0.4 x (Qi - Qcap) x 60 x (MWt/385.3) =\nWhere Qi is the flow rate at condition i. \nIf Qcap > Qi, then intial estimate of mass steam flow rate for condition i is zero. ",{"$f":"0.4*IF('Data Inputs'!B8>$C$70,'Data Inputs'!B8-$C$70,0)*60*('Data Inputs'!B$18/385.3)","v":7474.6950428237742},"lbs./hour"]
["Initial estimate of mass steam flow rate at Condition 2 (M2)= ",null,{"$f":"0.4*IF('Data Inputs'!B9>$C$70,'Data Inputs'!B9-$C$70,0)*60*('Data Inputs'!B$18/385.3)","v":747.46950428237744},"lbs./hour"]
["Initial estimate of mass steam flow rate at Condition 3 (M3)= ",null,{"$f":"0.4*IF('Data Inputs'!B10>$C$70,'Data Inputs'!B10-$C$70,0)*60*('Data Inputs'!B$18/385.3)","v":249.15650142745912},"lbs./hour"]
["Initial estimate of mass steam flow rate at Condition 4 (M4)= ",null,{"$f":"0.4*IF('Data Inputs'!B11>$C$70,'Data Inputs'!B11-$C$70,0)*60*('Data Inputs'!B$18/385.3)","v":1245.7825071372956},"lbs./hour"]
["Initial estimate of mass steam flow rate at Condition 5 (M5)= ",null,{"$f":"0.4*IF('Data Inputs'!B12>$C$70,'Data Inputs'!B12-$C$70,0)*60*('Data Inputs'!B$18/385.3)","v":498.31300285491824},"lbs./hour"]
["Volumetric Steam Flow Rate at Condition 1 (S1)= ",{"$f":"IF(C34<C$31, \"Steam set to minimum flow (Mmin) (See row 29)\",IF('Data Inputs'!B$47=1,IF('Data Inputs'!B13*('Data Inputs'!B8/('Data Inputs'!B8+C$32))<'Data Inputs'!B$48,\"Steam set to minimum flow (Mmin) (See row 29)\",IF('Data Inputs'!B13*('Data Inputs'!B8/('Data Inputs'!B8+(C34/60)*(385.3/18)))<'Data Inputs'!B$48, \"Steam rate reduced to meet NHVtarget\",\"Initial steam rate used, converted to scfm\"))))","v":"Initial steam rate used, converted to scfm"},{"$f":"IF(C34<C$31, C$32, IF('Data Inputs'!B$47=1,IF('Data Inputs'!B13*('Data Inputs'!B8/('Data Inputs'!B8+C$32))<'Data Inputs'!B$48, C$32,IF('Data Inputs'!B13*('Data Inputs'!B8/('Data Inputs'!B8+(C34/60)*(385.3/18)))<'Data Inputs'!B$48, 'Data Inputs'!B8*('Data Inputs'!B13/'Data Inputs'!$B$48-1), C34/60*(385.3/18)))))","v":2666.666666666667},"scfm"]
["Volumetric Steam Flow Rate at Condition 2 (S2)= ",{"$f":"IF(C35<C$31, \"Steam set to minimum flow (Mmin) (See row 29)\",IF('Data Inputs'!B$47=1,IF('Data Inputs'!B14*('Data Inputs'!B9/('Data Inputs'!B9+C$32))<'Data Inputs'!B$48,\"Steam set to minimum flow (Mmin) (See row 29)\",IF('Data Inputs'!B14*('Data Inputs'!B9/('Data Inputs'!B9+(C35/60)*(385.3/18)))<'Data Inputs'!B$48, \"Steam rate reduced to meet NHVtarget\",\"Initial steam rate used, converted to scfm\"))))","v":"Steam set to minimum flow (Mmin) (See row 29)"},{"$f":"IF(C35<C$31, C$32, IF('Data Inputs'!B$47=1,IF('Data Inputs'!B14*('Data Inputs'!B9/('Data Inputs'!B9+C$32))<'Data Inputs'!B$48, C$32,IF('Data Inputs'!B14*('Data Inputs'!B9/('Data Inputs'!B9+(C35/60)*(385.3/18)))<'Data Inputs'!B$48, 'Data Inputs'!B9*('Data Inputs'!B14/'Data Inputs'!$B$48-1), C35/60*(385.3/18)))))","v":131.28740740740741},"scfm"]
["Volumetric Steam Flow Rate at Condition 3 (S3)= ",{"$f":"IF(C36<C$31, \"Steam set to minimum flow (Mmin) (See row 29)\",IF('Data Inputs'!B$47=1,IF('Data Inputs'!B15*('Data Inputs'!B10/('Data Inputs'!B10+C$32))<'Data Inputs'!B$48,\"Steam set to minimum flow (Mmin) (See row 29)\",IF('Data Inputs'!B15*('Data Inputs'!B10/('Data Inputs'!B10+(C36/60)*(385.3/18)))<'Data Inputs'!B$48, \"Steam rate reduced to meet NHVtarget\",\"Initial steam rate used, converted to scfm\"))))","v":"Steam set to minimum flow (Mmin) (See row 29)"},{"$f":"IF(C36<C$31, C$32, IF('Data Inputs'!B$47=1,IF('Data Inputs'!B15*('Data Inputs'!B10/('Data Inputs'!B10+C$32))<'Data Inputs'!B$48, C$32,IF('Data Inputs'!B15*('Data Inputs'!B10/('Data Inputs'!B10+(C36/60)*(385.3/18)))<'Data Inputs'!B$48, 'Data Inputs'!B10*('Data Inputs'!B15/'Data Inputs'!$B$48-1), C36/60*(385.3/18)))))","v":131.28740740740741},"scfm"]
["Volumetric Steam Flow Rate at Condition 4 (S4)= ",{"$f":"IF(C37<C$31, \"Steam set to minimum flow (Mmin) (See row 29)\",IF('Data Inputs'!B$47=1,IF('Data Inputs'!B16*('Data Inputs'!B11/('Data Inputs'!B11+C$32))<'Data Inputs'!B$48,\"Steam set to minimum flow (Mmin) (See row 29)\",IF('Data Inputs'!B16*('Data Inputs'!B11/('Data Inputs'!B11+(C37/60)*(385.3/18)))<'Data Inputs'!B$48, \"Steam rate reduced to meet NHVtarget\",\"Initial steam rate used, converted to scfm\"))))","v":"Steam set to minimum flow (Mmin) (See row 29)"},{"$f":"IF(C37<C$31, C$32, IF('Data Inputs'!B$47=1,IF('Data Inputs'!B16*('Data Inputs'!B11/('Data Inputs'!B11+C$32))<'Data Inputs'!B$48, C$32,IF('Data Inputs'!B16*('Data Inputs'!B11/('Data Inputs'!B11+(C37/60)*(385.3/18)))<'Data Inputs'!B$48, 'Data Inputs'!B11*('Data Inputs'!B16/'Data Inputs'!$B$48-1), C37/60*(385.3/18)))))","v":131.28740740740741},"scfm"]
["Volumetric Steam Flow Rate at Condition 5 (S5)= ",{"$f":"IF(C38<C$31, \"Steam set to minimum flow (Mmin) (See row 29)\",IF('Data Inputs'!B$47=1,IF('Data Inputs'!B17*('Data Inputs'!B12/('Data Inputs'!B12+C$32))<'Data Inputs'!B$48,\"Steam set to minimum flow (Mmin) (See row 29)\",IF('Data Inputs'!B17*('Data Inputs'!B12/('Data Inputs'!B12+(C38/60)*(385.3/18)))<'Data Inputs'!B$48, \"Steam rate reduced to meet NHVtarget\",\"Initial steam rate used, converted to scfm\"))))","v":"Initial steam rate used, converted to scfm"},{"$f":"IF(C38<C$31, C$32, IF('Data Inputs'!B$47=1,IF('Data Inputs'!B17*('Data Inputs'!B12/('Data Inputs'!B12+C$32))<'Data Inputs'!B$48, C$32,IF('Data Inputs'!B17*('Data Inputs'!B12/('Data Inputs'!B12+(C38/60)*(385.3/18)))<'Data Inputs'!B$48, 'Data Inputs'!B12*('Data Inputs'!B17/'Data Inputs'!$B$48-1), C38/60*(385.3/18)))))","v":177.77777777777777},"scfm"]
["Mass Steam Flow Rate at Condition 1 (M1)= "," (S1)(60)(18/385.3) =",{"$f":"C39*60*18/385.3","v":7474.6950428237751},"lbs./hour"]
["Mass Steam Flow Rate at Condition 2 (M2)= "," (S2)(60)(18/385.3) =",{"$f":"C40*60*18/385.3","v":368},"lbs./hour"]
["Mass Steam Flow Rate at Condition 3 (M3)= "," (S3)(60)(18/385.3) =",368,"lbs./hour"]
["Mass Steam Flow Rate at Condition 4 (M4)= "," (S4)(60)(18/385.3) =",368,"lbs./hour"]
["Mass Steam Flow Rate at Condition 5 (M5)= "," (S5)(60)(18/385.3) =",498.31300285491824,"lbs./hour"]
["Total Steam Required (Msteam) = ","(M1 x t1) + (M2 x t2) + (M3 x t3) + (M4 x t4) + (M5 × t5) = ",{"$f":"(C44*'Data Inputs'!B$30)+(C45*'Data Inputs'!B$31)+(C46*'Data Inputs'!B$32)+(C47*'Data Inputs'!B$33)+(C48*'Data Inputs'!B$34)","v":907700.8045678694},"lbs./year"]
[]
["Net Heating Value with No Auxiliary Fuel Added:"]
["Net Heating Value at Condition 1 (NHV1) =","(Bv,1 x Q1)/(Q1 + K1S1) =",{"$f":"IFERROR(('Data Inputs'!B13*'Data Inputs'!B8)/('Data Inputs'!B8+'Data Inputs'!$B$47*'Design Parameters'!C39),'Data Inputs'!B13)","v":794.11764705882354},"Btu/scf."]
["Net Heating Value at Condition 2 (NHV2) =","(Bv,2 x Q2)/(Q2 + K1S2) =",{"$f":"IFERROR(('Data Inputs'!B14*'Data Inputs'!B9)/('Data Inputs'!B9+'Data Inputs'!$B$47*'Design Parameters'!C40),'Data Inputs'!B14)","v":104.33877555226557},"Btu/scf."]
["Net Heating Value at Condition 3 (NHV3) =","(Bv,3 x Q3)/(Q3 + K1S3) =",{"$f":"IFERROR(('Data Inputs'!B15*'Data Inputs'!B10)/('Data Inputs'!B10+'Data Inputs'!$B$47*'Design Parameters'!C41),'Data Inputs'!B15)","v":64.854373907083698},"Btu/scf."]
["Net Heating Value at Condition 4 (NHV4) =","(Bv,4 x Q4)/(Q4 + K1S4) =",{"$f":"IFERROR(('Data Inputs'!B16*'Data Inputs'!B11)/('Data Inputs'!B11+'Data Inputs'!$B$47*'Design Parameters'!C42),'Data Inputs'!B16)","v":118.8048409012506},"Btu/scf."]
["Net Heating Value at Condition 5 (NHV5) =","(Bv,5 x Q5)/(Q5 + K1S5) =",{"$f":"IFERROR(('Data Inputs'!B17*'Data Inputs'!B12)/('Data Inputs'!B12+'Data Inputs'!$B$47*'Design Parameters'!C43),'Data Inputs'!B17)","v":317.64705882352939},"Btu/scf."]
[]
["Natural Gas Consumption"]
["Auxiliary Fuel Consumption at Maximum Flow Conditions (Fmin 1) =",{"$f":"IF(OR(C$70>'Data Inputs'!B8,AND('Data Inputs'!$B$49=\"no\",'Data Inputs'!B8=0)),\"No auxiliary fuel needed if no waste gas flow\",IF(C52>='Data Inputs'!$B$48,\"No auxiliary fuel required because NHVmax > NHVtarget\",\"[Q1 × (NHVtarget - Bv,1) + NHVtarget × K1 × S1]/(Bf - NHVtarget) = \"))","v":"No auxiliary fuel required because NHVmax > NHVtarget"},{"$f":"IF(OR(C52>='Data Inputs'!B$48,AND('Data Inputs'!$B$49=\"no\",'Data Inputs'!B8=0),C$70>'Data Inputs'!B8),0,('Data Inputs'!B8*('Data Inputs'!B$48-'Data Inputs'!B13)+('Data Inputs'!B$48*'Data Inputs'!B$47*'Design Parameters'!C39))/('Data Inputs'!B$50-'Data Inputs'!B$48))","v":0},"scfm"]
["Auxiliary Fuel Consumption at Typical Flow Conditions (Fmin 2) =",{"$f":"IF(OR(C$70>'Data Inputs'!B9,AND('Data Inputs'!$B$49=\"no\",'Data Inputs'!B9=0)),\"No auxiliary fuel needed if no waste gas flow\",IF(C53>='Data Inputs'!$B$48,\"No auxiliary fuel required because NHVmax > NHVtarget\",\"[Q1 × (NHVtarget - Bv,1) + NHVtarget × K1 × S1]/(Bf - NHVtarget) = \"))","v":"[Q1 × (NHVtarget - Bv,1) + NHVtarget × K1 × S1]/(Bf - NHVtarget) = "},{"$f":"IF(OR(C53>='Data Inputs'!B$48,AND('Data Inputs'!$B$49=\"no\",'Data Inputs'!B9=0),C$70>'Data Inputs'!B9),0,('Data Inputs'!B9*('Data Inputs'!B$48-'Data Inputs'!B14)+('Data Inputs'!B$48*'Data Inputs'!B$47*'Design Parameters'!C40))/('Data Inputs'!B$50-'Data Inputs'!B$48))","v":136.1068100358423},"scfm",null,null,null,null,null,null,null,"Number of Burners (N)","N=","Select"]
["Auxiliary Fuel Consumption at Low Flow Conditions (Fmin 3) =",{"$f":"IF(OR(C$70>'Data Inputs'!B10,AND('Data Inputs'!$B$49=\"no\",'Data Inputs'!B10=0)),\"No auxiliary fuel needed if no waste gas flow\",IF(C54>='Data Inputs'!$B$48,\"No auxiliary fuel required because NHVmax > NHVtarget\",\"[Q1 × (NHVtarget - Bv,1) + NHVtarget × K1 × S1]/(Bf - NHVtarget) = \"))","v":"[Q1 × (NHVtarget - Bv,1) + NHVtarget × K1 × S1]/(Bf - NHVtarget) = "},{"$f":"IF(OR(C54>='Data Inputs'!B$48,AND('Data Inputs'!$B$49=\"no\",'Data Inputs'!B10=0),C$70>'Data Inputs'!B10),0,('Data Inputs'!B10*('Data Inputs'!B$48-'Data Inputs'!B15)+('Data Inputs'!B$48*'Data Inputs'!B$47*'Design Parameters'!C41))/('Data Inputs'!B$50-'Data Inputs'!B$48))","v":87.719713261648749},"scfm",null,null,null,null,null,null,null,"Less than 10 inches",1,{"$f":"IF(C27<=10,1,0)","v":1}]
["Auxiliary Fuel Consumption at No Waste Gas Flow Conditions (Fmin 4) =",{"$f":"IF(OR(C$70>'Data Inputs'!B11,AND('Data Inputs'!$B$49=\"no\",'Data Inputs'!B11=0)),\"No auxiliary fuel needed if no waste gas flow\",IF(C55>='Data Inputs'!$B$48,\"No auxiliary fuel required because NHVmax > NHVtarget\",\"[Q1 × (NHVtarget - Bv,1) + NHVtarget × K1 × S1]/(Bf - NHVtarget) = \"))","v":"[Q1 × (NHVtarget - Bv,1) + NHVtarget × K1 × S1]/(Bf - NHVtarget) = "},{"$f":"IF(OR(C55>='Data Inputs'!B$48,AND('Data Inputs'!$B$49=\"no\",'Data Inputs'!B11=0),C$70>'Data Inputs'!B11),0,('Data Inputs'!B11*('Data Inputs'!B$48-'Data Inputs'!B16)+('Data Inputs'!B$48*'Data Inputs'!B$47*'Design Parameters'!C42))/('Data Inputs'!B$50-'Data Inputs'!B$48))","v":184.49390681003584},"scfm",null,null,null,null,null,null,null,"Between than 10 and 24inches",2,{"$f":"IF(AND(C27>10,C27<=24),2,0)","v":0}]
["Auxiliary Fuel Consumption at No Waste Gas Flow Conditions (Fmin 5) =",{"$f":"IF(OR(C$70>'Data Inputs'!B12,AND('Data Inputs'!$B$49=\"no\",'Data Inputs'!B12=0)),\"No auxiliary fuel needed if no waste gas flow\",IF(C56>='Data Inputs'!$B$48,\"No auxiliary fuel required because NHVmax > NHVtarget\",\"[Q1 × (NHVtarget - Bv,1) + NHVtarget × K1 × S1]/(Bf - NHVtarget) = \"))","v":"No auxiliary fuel required because NHVmax > NHVtarget"},{"$f":"IF(OR(C56>='Data Inputs'!B$48,AND('Data Inputs'!$B$49=\"no\",'Data Inputs'!B12=0),C$70>'Data Inputs'!B12),0,('Data Inputs'!B12*('Data Inputs'!B$48-'Data Inputs'!B17)+('Data Inputs'!B$48*'Data Inputs'!B$47*'Design Parameters'!C43))/('Data Inputs'!B$50-'Data Inputs'!B$48))","v":0},"scfm",null,null,null,null,null,null,null,"Between 24 and 60 inches",3,{"$f":"IF(AND(C27>24,C27<=60),3,0)","v":0}]
["Total Auxiliary Fuel Consumption (Fa) = ","[(Fmin1 × t1) + (Fmin2 × t2)+ (Fmin3 × t3)+ (Fmin4 × t4) +(Fmin5 + t5)] × 60 min/hr =",{"$f":"60*((C59*'Data Inputs'!B30)+(C60*'Data Inputs'!B31)+(C61*'Data Inputs'!B$32)+(C62*'Data Inputs'!B$33)+(C63*'Data Inputs'!B34))","v":2449922.5806451617},"scf/year",null,null,null,null,null,null,null,"Greater than 60 inches",4,{"$f":"IF(C27>60, 4, 0)","v":0}]
[null,"Fa /[1000 scf/Mscf] =",{"$f":"C64/1000","v":2449.9225806451618},"Mscf/year",null,null,null,null,null,null,null,null,"N=",{"$f":"SUM(N60:N64)","v":1}]
["Purge Gas Consumption (Fpurge) = ","(7.85 x 10-4) x top x D2 = ",{"$f":"(0.000785)*'Design Parameters'!C10*('Design Parameters'!C27)^2","v":25.12},"Mscf/year"]
["Pilot Gas Consumption (Fpilot) = ","(70) x N x top x 10-3 = ",{"$f":"70*N65*'Design Parameters'!C10*0.001","v":35},"Mscf/year"]
[]
["Flare Gas Recovery System"]
["Design Flow Capacity of FGR System (Qcap) =",{"$f":"IF('Data Inputs'!B42=\"yes\", _xlfn.CONCAT(\"Flow for Condition \",'Data Inputs'!B43,\" × No.Compressor × CapFactor/Compr\"),\"No FGR system\")","v":"No FGR system"},{"$f":"IF('Data Inputs'!B42=\"yes\",IF('Data Inputs'!B43=1,'Data Inputs'!B8,IF('Data Inputs'!B43=2,'Data Inputs'!B9,IF('Data Inputs'!B43=3,'Data Inputs'!B10,IF('Data Inputs'!B43=4,'Data Inputs'!B11,'Data Inputs'!B12))))*'Data Inputs'!B44*'Data Inputs'!B45,0)","v":0},"scfm"]
["Natural gas offset (Foffset) =",null,{"$f":"IF('Data Inputs'!B42=\"yes\",0.001*'Data Inputs'!B46*60/'Data Inputs'!B50,0)*(IF(C70>'Data Inputs'!B8,'Data Inputs'!B8,C70)*'Data Inputs'!B13*'Data Inputs'!B30+IF(C70>'Data Inputs'!B9,'Data Inputs'!B9,C70)*'Data Inputs'!B14*'Data Inputs'!B31+IF(C70>'Data Inputs'!B10,'Data Inputs'!B10,C70)*'Data Inputs'!B15*'Data Inputs'!B32+IF(C70>'Data Inputs'!B11,'Data Inputs'!B11,C70)*'Data Inputs'!B16*'Data Inputs'!B33+IF(C70>'Data Inputs'!B12,'Data Inputs'!B12,C70)*'Data Inputs'!B17*'Data Inputs'!B34)","v":0},"Mscf/yr",null,null,null,null,null,null,null,"Number of compressors needed for full recovery","Nop × Qcap/Ntotal"]
["Electricity Consumption at Condition 1 (t1 × EFGR,1) =","t1 × 0.806 × Nop,1 × Qcap/Ntotal)",{"$f":"0.0806*IF(L72=0,0,IF(L72<1,$C$70/'Data Inputs'!$B$44,IF(L72>'Data Inputs'!$B$44-1,$C$70,IF(L72<2,$C$70*2/'Data Inputs'!$B$44,IF(L72<3,$C$70*3/'Data Inputs'!$B$44,IF(L72<4,$C$70*4/'Data Inputs'!$B$44,\"Error\"))))))*'Data Inputs'!B30","v":0},"kW-hr/yr",null,null,null,null,null,null,null,{"$f":"IF($C$70=0,0,'Data Inputs'!B8/($C$70/'Data Inputs'!$B$44))","v":0},{"$f":"IF(L72=0,0,IF(L72<1,$C$70/'Data Inputs'!$B$44,IF(L72>'Data Inputs'!$B$44-1,$C$70,IF(L72<2,$C$70*2/'Data Inputs'!$B$44,IF(L72<3,$C$70*3/'Data Inputs'!$B$44,IF(L72<4,$C$70*4/'Data Inputs'!$B$44,\"Error\"))))))","v":0}]
["Electricity Consumption at Condition 2 (t2 × EFGR,2) =","t2 × 0.806 × Nop,2 × Qcap/Ntotal)",{"$f":"0.0806*IF(L73=0,0,IF(L73<1,$C$70/'Data Inputs'!$B$44,IF(L73>'Data Inputs'!$B$44-1,$C$70,IF(L73<2,$C$70*2/'Data Inputs'!$B$44,IF(L73<3,$C$70*3/'Data Inputs'!$B$44,IF(L73<4,$C$70*4/'Data Inputs'!$B$44,\"Error\"))))))*'Data Inputs'!B31","v":0},"kW-hr/yr",null,null,null,null,null,null,null,{"$f":"IF($C$70=0,0,'Data Inputs'!B9/($C$70/'Data Inputs'!$B$44))","v":0},{"$f":"IF(L73=0,0,IF(L73<1,$C$70/'Data Inputs'!$B$44,IF(L73>'Data Inputs'!$B$44-1,$C$70,IF(L73<2,$C$70*2/'Data Inputs'!$B$44,IF(L73<3,$C$70*3/'Data Inputs'!$B$44,IF(L73<4,$C$70*4/'Data Inputs'!$B$44,\"Error\"))))))","v":0}]
["Electricity Consumption at Condition 3 (t3 × EFGR,3) =","t3 × 0.806 × Nop,3 × Qcap/Ntotal)",{"$f":"0.0806*IF(L74=0,0,IF(L74<1,$C$70/'Data Inputs'!$B$44,IF(L74>'Data Inputs'!$B$44-1,$C$70,IF(L74<2,$C$70*2/'Data Inputs'!$B$44,IF(L74<3,$C$70*3/'Data Inputs'!$B$44,IF(L74<4,$C$70*4/'Data Inputs'!$B$44,\"Error\"))))))*'Data Inputs'!B32","v":0},"kW-hr/yr",null,null,null,null,null,null,null,{"$f":"IF($C$70=0,0,'Data Inputs'!B10/($C$70/'Data Inputs'!$B$44))","v":0},{"$f":"IF(L74=0,0,IF(L74<1,$C$70/'Data Inputs'!$B$44,IF(L74>'Data Inputs'!$B$44-1,$C$70,IF(L74<2,$C$70*2/'Data Inputs'!$B$44,IF(L74<3,$C$70*3/'Data Inputs'!$B$44,IF(L74<4,$C$70*4/'Data Inputs'!$B$44,\"Error\"))))))","v":0}]
["Electricity Consumption at Condition 4 (t4 × EFGR,4) =","t4 × 0.806 × Nop,4 × Qcap/Ntotal)",{"$f":"0.0806*IF(L75=0,0,IF(L75<1,$C$70/'Data Inputs'!$B$44,IF(L75>'Data Inputs'!$B$44-1,$C$70,IF(L75<2,$C$70*2/'Data Inputs'!$B$44,IF(L75<3,$C$70*3/'Data Inputs'!$B$44,IF(L75<4,$C$70*4/'Data Inputs'!$B$44,\"Error\"))))))*'Data Inputs'!B33","v":0},"kW-hr/yr",null,null,null,null,null,null,null,{"$f":"IF($C$70=0,0,'Data Inputs'!B11/($C$70/'Data Inputs'!$B$44))","v":0},{"$f":"IF(L75=0,0,IF(L75<1,$C$70/'Data Inputs'!$B$44,IF(L75>'Data Inputs'!$B$44-1,$C$70,IF(L75<2,$C$70*2/'Data Inputs'!$B$44,IF(L75<3,$C$70*3/'Data Inputs'!$B$44,IF(L75<4,$C$70*4/'Data Inputs'!$B$44,\"Error\"))))))","v":0}]
["Electricity Consumption at Condition 5 (t5 × EFGR,5) =","t5 × 0.806 × Nop,5 × Qcap/Ntotal)",{"$f":"0.0806*IF(L76=0,0,IF(L76<1,$C$70/'Data Inputs'!$B$44,IF(L76>'Data Inputs'!$B$44-1,$C$70,IF(L76<2,$C$70*2/'Data Inputs'!$B$44,IF(L76<3,$C$70*3/'Data Inputs'!$B$44,IF(L76<4,$C$70*4/'Data Inputs'!$B$44,\"Error\"))))))*'Data Inputs'!B34","v":0},"kW-hr/yr",null,null,null,null,null,null,null,{"$f":"IF($C$70=0,0,'Data Inputs'!B12/($C$70/'Data Inputs'!$B$44))","v":0},{"$f":"IF(L76=0,0,IF(L76<1,$C$70/'Data Inputs'!$B$44,IF(L76>'Data Inputs'!$B$44-1,$C$70,IF(L76<2,$C$70*2/'Data Inputs'!$B$44,IF(L76<3,$C$70*3/'Data Inputs'!$B$44,IF(L76<4,$C$70*4/'Data Inputs'!$B$44,\"Error\"))))))","v":0}]
["Electricity Consumption Total (ΣtnEFGR,n)",null,{"$f":"SUM(C72:C76)","v":0},"kW-hr/yr"]
[]
[]
["Capital Recovery Factor:"]
["Capital Recovery Factor (CRF) = ","[i × (1 + i)n] / [(1 + i)n - 1] =",{"$f":"ROUND((('Data Inputs'!B60/100)*(1+('Data Inputs'!B60/100))^'Data Inputs'!B39)/(((1+('Data Inputs'!B60/100))^'Data Inputs'!B39)-1),4)","v":9.9599999999999994E-2}]
[null,"Where n = Equipment Life and i = Interest Rate"]

{"sheet":"Cost Estimate","index":3,"n_rows":87,"n_cols":11,"rows_kept":87,"cut":false,"hidden":false,"merged":[[80,0,80,3],[51,0,51,3],[4,6,4,8],[0,0,0,3],[45,0,45,1],[21,0,21,1],[2,0,2,3],[31,0,31,1]]}
["Cost Estimate"]
[]
["Capital Costs"]
[]
[null,null,null,null,null,null,"Flare Cost",null,null,null,"Vent Stream Piping Cost"]
[{"$f":"\"Total Capital Investment (TCI) (in \"&'Data Inputs'!B58&\" dollars)\"","v":"Total Capital Investment (TCI) (in 2021 dollars)"},null,null,null,null,null,"Type","Cost Equation","Capital Cost",null,{"$f":"IF(AND('Design Parameters'!C27>1,'Design Parameters'!C27<24),\"183 x (L/100) x D^1.21\", (IF(AND('Design Parameters'!C27>30,'Design Parameters'!C27<60),\" 200 x (L/100) x D^1.07\")))","v":"183 x (L/100) x D^1.21"}]
["Parameter","Equation",null,null,null,null,1,{"$f":"IF('Data Inputs'!L1=1, \"Select Flare Type on the Data Inputs tab\", \"\")","v":""},0,null,{"$f":"IF(AND('Design Parameters'!C27>1,'Design Parameters'!C27<24),(183*('Data Inputs'!B40/100)*('Design Parameters'!C27)^1.21), (IF(AND('Design Parameters'!C27>30,'Design Parameters'!C27<60),(200* ('Data Inputs'!B40/100)*('Design Parameters'!C27)^1.07))))*('Data Inputs'!B59/'Data Inputs'!E59)","v":2826.5545138090033}]
["Flare (CF) =",{"$f":"H15","v":"(124 + 10.42D + 0.564H)^2"},{"$f":"I15","v":94762.91786736215},{"$f":"IF(C8=0, \"Additional information needed to complete calculations. Please return to the Data Inputs tab.\", \" \")","v":" "},null,null,2,{"$f":"IF('Data Inputs'!L1=2, \"(93.6 + 10.97D + 0.899H)^2\", \"\")","v":""},{"$f":"IF('Data Inputs'!L1=2, ((93.6+(10.97*'Design Parameters'!C27)+(0.899*'Design Parameters'!C28))^2), 0)","v":0}]
["Knock-out Drum (CK) =","20.5 x [d x t x (h + 0.812 x d)]0.737 ",{"$f":"(20.5)*(('Design Parameters'!C22*'Design Parameters'!C24*(('Design Parameters'!C23*12)+(0.812*'Design Parameters'!C22)))^0.737)*('Data Inputs'!B59/'Data Inputs'!E59)","v":8138.887752401839},null,null,null,3,{"$f":"IF('Data Inputs'!L1=3, \"(124 + 10.42D + 0.564H)^2\", \"\")","v":"(124 + 10.42D + 0.564H)^2"},{"$f":"IF('Data Inputs'!L1=3, ((124+(10.42*'Design Parameters'!C27)+(0.564*'Design Parameters'!C28))^2), 0)","v":75957.564816000027}]
["Vent Stream Transport Piping (Cp) = ",{"$f":"K6","v":"183 x (L/100) x D^1.21"},{"$f":"K7","v":2826.5545138090033},null,null,null,4,{"$f":"IF('Data Inputs'!L1=4, \"(91.7 + 3.26D + 1.968H)^2\", \"\")","v":""},{"$f":"IF('Data Inputs'!L1=4, ((91.7+(3.26*'Design Parameters'!C27)+(1.968*'Design Parameters'!C28))^2), 0)","v":0}]
["Flare Seal or Flame Arrestor (CS) =",{"$f":"IF('Data Inputs'!B41=\"no\",\"\",IF('Design Parameters'!C27<=24, \"39.15 x D^2 + 3592\", \"0.1 x C_F\"))","v":""},{"$f":"IF('Data Inputs'!B41=\"no\",0,IF('Design Parameters'!C27<=24, 39.15*'Design Parameters'!C27^2+3592,0.1*'Cost Estimate'!C8)*('Data Inputs'!B59/'Data Inputs'!E59))","v":0}]
["Flare gas recovery (CFGR)",{"$f":"IF('Data Inputs'!B42=\"no\",\"\",\"731.3 * Qcap\")","v":""},{"$f":"IF('Data Inputs'!B42=\"yes\",731.3*'Design Parameters'!C70,0)*('Data Inputs'!B59/'Data Inputs'!E59)","v":0}]
["Monitoring Equipment (CM) =",{"$f":"IF('Data Inputs'!M80=0,\"No monitoring equipment selected\",(IF(SUM('Data Inputs'!M73:M79)='Data Inputs'!M80,\"(Based on actual costs for selected monitoring equipment)\",(IF(SUM('Data Inputs'!M73:M79)=0,\"(Based on default costs for selected monitoring equipment)\",\"(Based on default and actual costs for selected monitoring equipment)\")))))","v":"(Based on default costs for selected monitoring equipment)"},{"$f":"SUM('Data Inputs'!F73:F79)","v":51150.660792951545}]
["Utility costs (CU)","As entered in Data Inputs tab",{"$f":"'Data Inputs'!B82","v":0}]
[null,null,null,null,null,null,null,{"$f":"H7&H8&H9&H10","v":"(124 + 10.42D + 0.564H)^2"},{"$f":"SUM(I7:I10)*('Data Inputs'!B59/'Data Inputs'!E59)","v":94762.91786736215}]
["Equipment Costs (A) =","CF + CM + CP + CK + CS + CFGR + CU =",{"$f":"SUM(C8:C15)","v":156879.02092652454}]
[]
["Instrumentation =","0.10 × A =",{"$f":"0.1*C16","v":15687.902092652454}]
["Sales taxes =","0.03 × A =",{"$f":"0.03*C16","v":4706.3706277957363}]
["Freight =","0.05 × A =",{"$f":"0.05*C16","v":7843.9510463262268}]
[]
["Total Purchased Equipment Costs (B) = ",null,{"$f":"C16++C18+C19+C20","v":185117.24469329894}]
[]
[{"$f":"\"Direct Installation Costs (in \"&'Data Inputs'!B58&\" dollars)\"","v":"Direct Installation Costs (in 2021 dollars)"}]
["Parameter","Equation","Cost"]
["Foundations and Supports =","0.12 × B =",{"$f":"0.12*C22","v":22214.069363195871}]
["Handling and Erection =","0.40 × B =",{"$f":"0.4*C22","v":74046.897877319585}]
["Electrical =","0.01 × B =",{"$f":"0.01*C22","v":1851.1724469329895}]
["Piping =","0.02 × B =",{"$f":"0.02*C22","v":3702.344893865979}]
["Insulation =","0.01 × B =",{"$f":"0.01*C22","v":1851.1724469329895}]
["Painting =","0.01 × B =",{"$f":"0.01*C22","v":1851.1724469329895}]
["Direct Installation Costs =",null,{"$f":"SUM(C26:C31)","v":105516.82947518042}]
[]
["Site Preparation (SP) =","As entered in Data Inputs tab",{"$f":"'Data Inputs'!B83","v":0}]
["Buildings (Bldg) =","As entered in Data Inputs tab",{"$f":"'Data Inputs'!B84","v":0}]
[]
[null,"Total Direct Costs (DC) =  B + (0.57 × B) + SP + Bldg = ",{"$f":"SUM(C32:C35)+C22","v":290634.07416847936}]
[]
[{"$f":"\"Total Indirect Installation Costs (in \"&'Data Inputs'!B58&\" dollars)\"","v":"Total Indirect Installation Costs (in 2021 dollars)"}]
["Parameter","Equation","Cost"]
["Engineering = ","0.10 × B =",{"$f":"(0.1*C$22)","v":18511.724469329896}]
["Construction and field expenses = ","0.10 × B =",{"$f":"(0.1*C$22)","v":18511.724469329896}]
["Contractor fees =","0.10 × B =",{"$f":"(0.1*C$22)","v":18511.724469329896}]
["Start-up =","0.01 × B =",{"$f":"(0.01*C$22)","v":1851.1724469329895}]
["Performance test =","0.01 × B =",{"$f":"(0.01*C$22)","v":1851.1724469329895}]
["Total Indirect Costs (IC) =",null,{"$f":"SUM(C41:C45)","v":59237.518301855671}]
[]
["Contingency Cost (C ) =","CF × (DC + IC) =",{"$f":"('Data Inputs'!B85/100)*(C37+C46)","v":34987.159247033502}]
[]
["Total Capital Investment (TCI) =","DC + IC + C = 1.89B + SP + Bldg. + C =",{"$f":"C37+C46+C48","v":384858.75171736849},{"$f":"\"in \"&'Data Inputs'!$B$58&\" dollars\"","v":"in 2021 dollars"}]
[]
["Annual Costs"]
[]
["Direct Annual Costs"]
["Parameter","Equation","Cost"]
["Operating Labor Costs: ","Operator = Operator Hours/Year × Labor Rate =",{"$f":"'Data Inputs'!B53*'Data Inputs'!B68","v":18666.899999999998}]
[null,"Supervisor = 15% of Operator =",{"$f":"(0.15*C56)","v":2800.0349999999994}]
["Maintenance Costs:",{"$f":"_xlfn.CONCAT(\"Labor = \",'Data Inputs'!B54,\" hours/shift × Labor Rate × (Operating Hours/8 hours/shift) =\")","v":"Labor = 0.5 hours/shift × Labor Rate × (Operating Hours/8 hours/shift) ="},{"$f":"('Data Inputs'!B54*'Data Inputs'!B69*'Design Parameters'!C10/8)","v":785}]
[null,"Materials = 100% of maintenance labor =",{"$f":"C58","v":785}]
["Annual Electricity Cost (Ce) =","EFGR x Coste =",{"$f":"('Design Parameters'!C77)*'Data Inputs'!B67","v":0}]
["Annual Purge Gas Cost (Cpurge) =","Fpurge x Costfuel =",{"$f":"'Data Inputs'!B66*'Design Parameters'!C66","v":103.99679999999999},"Aggregate Natural Gas Cost (or Credit)"]
["Annual Pilot Gas Cost (Cpilot) =","Fpilot x Costfuel =",{"$f":"'Data Inputs'!B66*'Design Parameters'!C67","v":144.89999999999998},"Cpurge + Cpilot + Ca - Crec ="]
["Annual Auxiliary Fuel Cost (Ca) =","Fa x Costfuel =",{"$f":"'Data Inputs'!B66*'Design Parameters'!C65","v":10142.679483870968},{"$f":"SUM(C61:C64)","v":10391.576283870969}]
["Annual NG Offset from recovered flare gas (-Crec) =","Foffset x Costfuel =",{"$f":"-'Data Inputs'!B66*'Design Parameters'!C71","v":0}]
["Annual Steam Cost (Cs) =","Msteam x Coststeam =",{"$f":"('Design Parameters'!C49/1000)*'Data Inputs'!B65","v":6989.2961951725947}]
[]
["Direct Annual Costs (DAC) =",null,{"$f":"SUM(C56:C65)","v":40417.807479043564},{"$f":"\"in \"&'Data Inputs'!$B$58&\" dollars\"","v":"in 2021 dollars"}]
[]
["Indirect Annual Costs"]
["Parameter","Equation","Cost"]
["Overhead","= 60% of sum of operator, supervisor, maintenance labor Plus maintenance materials",{"$f":"(0.6*(C56+C57+C58+C59))","v":13822.160999999998}]
["Administrative Charges","= 2% of TCI",{"$f":"(0.02*C50)","v":7697.1750343473695}]
["Property Taxes","= 1% of TCI",{"$f":"0.01*C50","v":3848.5875171736848}]
["Insurance","= 1% of TCI",{"$f":"0.01*C50","v":3848.5875171736848}]
["Capital Recovery","= CRF × TCI ",{"$f":"'Design Parameters'!$C$81*C50","v":38331.931671049897}]
[]
["Indirect Annual Costs (IAC) =",null,{"$f":"SUM(C71:C75)","v":67548.442739744642},{"$f":"\"in \"&'Data Inputs'!$B$58&\" dollars\"","v":"in 2021 dollars"}]
[]
["Total Annual Cost  (TAC) =","DAC + IAC =",{"$f":"C77+C67","v":107966.25021878821},{"$f":"\"in \"&'Data Inputs'!$B$58&\" dollars\"","v":"in 2021 dollars"}]
[]
["Cost Effectiveness"]
[]
["Cost Effectiveness "]
["Parameter","Equation","Cost"]
["Total Annual Cost =","TAC =",{"$f":"C79","v":107966.25021878821},{"$f":"\"per year in \"&'Data Inputs'!B58& \" dollars\"","v":"per year in 2021 dollars"}]
["Annual Quantity of VOC Destroyed =","Wvoc = Mvoc x tWG x DE =",{"$f":"'Design Parameters'!C17","v":93.1},"tons/year"]
["Cost Effectiveness = ","Total Annual Cost (TAC) / Annual Quantity of VOC Destroyed =",{"$f":"C85/C86","v":1159.6804534778541},{"$f":"\"per ton of pollutants removed/recovered in \"&'Data Inputs'!B58& \" dollars\"","v":"per ton of pollutants removed/recovered in 2021 dollars"}]

{"sheet":"Tables A & B","index":4,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[11,0,11,3]]}
["Table A: Typical Capital Costs for Common Monitoring Equipment"]
[]
["Monitor Type",{"$f":"\"Capital Costs In \"&'Data Inputs'!B58&\" Dollars\"","v":"Capital Costs In 2021 Dollars"},null,null,null,null,null,"In 2017 Dollars"]
["Pilot Flame Monitor ",{"$f":"'Tables A & B'!H4*('Data Inputs'!B59/'Data Inputs'!E59)","v":5115.0660792951539},null,null,null,null,null,4100]
["Gas Chromatograph (GC)",{"$f":"'Tables A & B'!H5*('Data Inputs'!B59/'Data Inputs'!E59)","v":163432.59911894274},null,null,null,null,null,131000]
["Hydrogen Analyzer",{"$f":"'Tables A & B'!H6*('Data Inputs'!B59/'Data Inputs'!E59)","v":46035.594713656392},null,null,null,null,null,36900]
["Calorimeter",{"$f":"'Tables A & B'!H7*('Data Inputs'!B59/'Data Inputs'!E59)","v":96437.709251101318},null,null,null,null,null,77300]
["Flare Gas Flow Monitor",{"$f":"'Tables A & B'!H8*('Data Inputs'!B59/'Data Inputs'!E59)","v":72359.471365638761},null,null,null,null,null,58000]
["Steam Fine Controls/Metering",{"$f":"'Tables A & B'!H9*('Data Inputs'!B59/'Data Inputs'!E59)","v":73232.775330396471},null,null,null,null,null,58700]
["Air Fine Controls/Metering",{"$f":"'Tables A & B'!H10*('Data Inputs'!B59/'Data Inputs'!E59)","v":61879.823788546259},null,null,null,null,null,49600]
[]
["Table B: Fraction of Heat Radiation for Common Gases"]
[]
["Gas","Flare Tip Diameter (inches)","Fraction of Heat Radiation (f)"]
["Hydrogen","<1.0",0.1]
[null,1.6,0.11]
[null,3.3,0.16]
[null,8,0.15]
[null,16,0.17]
["Butane","<1.0",0.28999999999999998]
[null,1.6,0.28999999999999998]
[null,3.3,0.28999999999999998]
[null,8,0.28000000000000003]
[null,16,0.3]
["Methane","<1.0",0.16]
[null,1.6,0.16]
[null,3.3,0.15]
["Natural Gas",8,0.19]
[null,16,0.23]