{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Read Me","Wet & Dry FGD Data Inputs","WFGD Design Parameters","WFGD Cost Estimate","SDA Design Parameters","SDA Cost Estimate","PB Scrubber Data Inputs","PB Scrubber Design Parameters","PB Scrubber Cost Estimate","Appendix"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,14],[1,0,1,14],[8,1,8,13],[10,1,10,13],[24,1,24,13],[2,0,2,14],[3,0,3,14],[4,0,4,14],[5,0,5,14],[6,0,6,14],[23,1,23,13],[18,1,18,13],[12,1,12,13],[14,2,14,12],[15,2,15,12],[16,2,16,12],[20,1,20,13],[21,1,21,13],[25,1,25,13],[26,1,26,13]]}
["Air Pollution Control Cost Estimation Spreadsheet"]
["For Wet and Dry Scrubbers for Acid Gas Control"]
["U.S. Environmental Protection Agency "]
["Air Economics Group"]
["Health and Environmental Impacts Division"]
["Office of Air Quality Planning and Standards"]
["(January 2023)"]
[]
[null,"This spreadsheet allows users to estimate the capital and annualized costs for installing and operating scrubbers for reducing sulfur dioxide and acidic gas emissions from fossil fuel-fired combustion units and other industrial sources of acid gases.  "]
[]
[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 acid gas absorber chapter and cost estimation methodology in the Control Cost Manual. For a detailed description of acid gas absorbers and the cost methodologies, see Section 5, Chapter 1 (Wet and Dry Scrubbers for Acid Gas Control) of the Air Pollution Control Cost Manual (as updated in 2021).  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 estimate capital and annualized costs for three types of acid gas scrubbers: "]
[]
[null,"(1)   ","Wet flue gas desulfurization (WFGD) systems used to control SO2 emissions from coal-fired utility boilers over 100 MW."]
[null,"(2)   ","Spray dryer absorber (SDA) used to control SO2 emissions from coal-fired utility boilers of equal to or greater than 50 MW."]
[null,"(3)   ","Wet packed-bed scrubbers used to control acid gases from industrial emission sources of any size."]
[]
[null,"WFGD and SDA Control Systems\nThe methodologies for WFGD and SDA systems are based on those from the U.S. EPA Clean Air Markets Division (CAMD)'s Integrated Planning Model (IPM version 6). The size and costs of a WFGD and SDA are based primarily on the size of the combustion unit and the sulfur content of the coal burned. The WFGD methodology include cost algorithms for capital and operating cost for wastewater treatment consisting of chemical pretreatment, low hydraulic residence time biological reduction and ultrafiltration to treat wastewater generated by the WFGD system. The IPM equations estimate the purchased equipment cost and the direct and indirect installation costs based on cost data for multiple lump-sum contracts. Turnkey contracts where the price is fixed at the time the contract is signed and the contractor undertakes responsibility for the completion of the project, are generally 10 to 15% higher than the multiple lump-sum contracts. For additional information regarding the IPM, see the EPA Clean Air Markets webpage at http://www.epa.gov/airmarkets/power-sector-modeling. \n\nUsers should complete the Wet & Dry FGD Data Inputs tab to estimate costs for WFGD and SDA systems. "]
[]
[null,"Packed-Bed Scrubbers\nThe cost methodology for wet packed-bed scrubbers can be used for estimating costs for any size of packed tower absorber used to control flue gas containing any acidic pollutants (e.g., HCl and HF). The capital and operating costs are based on the waste gas composition and properties of the pollutant and sorbent.  The waste gas is assumed to comprise a two-component waste gas mixture (pollutant/air), where the pollutant consists of a single compound present in dilute quantities. The waste gas is assumed to behave as an ideal gas and the solvent is assumed to behave as an ideal solution. Heat effects associated with absorption are considered to be minimal due to the low pollutant concentration. The procedures also assume that, in chemical absorption, the process is not reaction rate limited, i.e., the reaction of the pollutant with the solvent is considered fast compared to the rate of absorption of the pollutant into the solvent. \n\nUsers should complete the PB Scrubber Data Inputs tab to estimate costs for packed-bed scrubbers."]
[null,"The calculations provide study-level estimates (±30%) of capital and annual costs. Default values included in the spreadsheet are taken from the Control Cost Manual and other sources, such as the U.S. Energy Information Administration (EIA), and are included only as an example of how to complete the data inputs sheets. The actual costs may vary from those calculated here due to site-specific conditions. Selection of the most cost-effective control option should be based on a detailed engineering study and cost quotations from control system suppliers. "]
[]
[null,"Instructions "]
[null,"Step 1: Please select the FGD Data Inputs or PB Scrubber Data Inputs tab. Click he Reset Form button at the top of the sheet to reset all parameters to default values. "]
[null,"Step 2: Complete the cells highlighted in yellow. The highlighted cells are pre-populated with example or default values. Users should replace the pre-populated values with current values for each parameter that are specific to the facility. All data entry fields in the PB Scrubber Data Inputs tab should be completed. While most fields in the FGD Data Inputs tab apply to both WFGD and SDA systems, a few data entry fields are specific to the type of control system and may be left blank if the user does not wish to estimate costs for both systems. References documenting the source of each value should be documented in the Data Sources for Default Values Used in Calculations located on the FGD Data Inputs and PB Scrubber Data Inputs tabs."]
[null,"Step 3: Once all of the data fields are complete, select the SDA Design Parameters, WFGD Design Parameters, or PB Scrubber Design Parameters tab (as applicable) to see the calculated design parameters. Select the SDA Cost Estimate, WFGD Cost Estimate, or PB Scrubber Cost Estimate tabs to view the calculated cost data for the installation and operation of the scrubber. "]

{"sheet":"Wet & Dry FGD Data Inputs","index":1,"n_rows":80,"n_cols":19,"rows_kept":80,"cut":false,"hidden":false,"merged":[[18,1,18,9],[39,7,39,8],[30,1,30,3],[32,1,32,3],[20,1,20,4],[26,1,26,2],[21,6,21,7],[31,4,32,6],[0,0,0,14],[2,0,2,14],[6,7,6,8],[17,2,17,7],[11,0,11,1],[11,9,11,14],[14,9,16,12],[70,9,70,13],[57,4,57,6],[43,9,43,10],[38,7,38,8],[43,6,43,7],[71,9,71,13],[73,9,73,13],[78,9,78,13],[6,1,6,4],[66,1,66,7],[14,5,14,6],[77,3,77,8],[71,3,71,8],[72,3,72,8],[76,3,76,8],[70,3,70,8],[74,3,74,8],[73,3,73,8],[75,3,75,8],[78,3,78,8],[19,1,19,4],[79,3,79,8],[79,9,79,13],[76,9,76,13],[74,9,74,13],[75,9,75,13]]}
["Data Inputs for Spray Dryer Absorber and Wet FGD"]
[]
["Enter the following data for your combustion unit:"]
[]
[null,"Is the FGD for a new boiler or retrofit of an existing boiler?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retrofit Box"]
[null,"Please enter a retrofit factor. Enter 1 for projects of average difficulty. Enter values >1 for more difficult retrofits and enter <1 for less difficult retrofits.",null,null,null,null,1,{"$f":"IF(G7>1, \"* NOTE: You must document why a retrofit factor of \"&G7&\" is appropriate for the proposed project.\", \" \")","v":" "},null,null,null,null,null,null,null,null," "]
["Directions: Enter data in highlighted data fields.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Construction",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retrofit"]
[null,"What is the gross MW rating at full load capacity (A)?",500,"MW"]
[]
["Provide the following information for the coal burned:",null," "," ",null,null,null,null," "]
[null,"Select type of coal burned:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Coal Type"]
[null,null," "," ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bituminous",2]
[null,"Enter the sulfur content (%S)",1.84,"percent by weight","OR"," SO2 Emissions (SO2in)",null,null,"lb/MMBtu",{"$f":"IF(AND(C15>0,H15>0),\"*Note: If you enter values for both sulfur content and SO2 emission rate, the SO2 emission rate in lbs/MMBtu will be used to estimate costs.\",\" \")","v":" "},null,null,null,null,null,null,null,"Sub-Bituminous"]
[null,null,{"$f":"IF(OR(C15>0,H15>0),\" \",\"*You must enter a value for either percent sulfur content or SO2 emission rate!\")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lignite"]
[null,"Oulet SO2 Emissions (SO2out)",0.1,"lb/MMBtu",null,null,null,null,null,null,null,null,null,null,null,null,null,"Coal blend"]
[null,null," "]
[null,"For units burning coal blends:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Landfill?",2]
[null,"The table below is pre-populated with default values for HHV and percent sulfur. Please enter the actual values for these parameters in the table below. If the actual value for any parameter is not known, you may use the default values provided.   "]
[null,"Coal Blend Composition Table",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Onsite Landfill"]
[null,null,"Fraction in Coal Blend","Percent Sulfur","HHV (Btu/lb)",null,"Calculated sulfur content of coal blend",null,0,"percent",null,null,null,null,null,null,null,"Offsite Landfill"]
[null,"Bituminous",0,1.84,11841]
[null,"Sub-Bituminous",0,0.41,8826]
[null,"Lignite",0,0.82,6626]
[]
[null,"Please click the calculate button to calculate weighted values based on the data in the table above.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note:  If P25= Yes, then BTF = 0.75 for fluid bed boilers; Else BTF=1","No"]
[]
[null,null,{"$f":"IF(C17>0,\" \",\"*You must enter a value for the outlet SO2 emission rate!\")","v":" "}]
[null," "]
[null,"What is the higher heating value of the fuel (HHV)?",11841,"Btu/lb",{"$f":"IF(H15>0,\"*Note: You do not need to enter a value for the HHV since you entered SO2 emissions in lb/MMBtu above\",\" \")","v":" "}]
[null,{"$f":"IF(C32=M23,\"*HHV is the weighted average value calculated using the values entered in the coal blend composition table.\",(IF(OR(C32=C77,C32=1033,C32=11814,C32=6534,C32=8730,C32=141468),\"*HHV value of \"&C32&\" \"&D32&\" is a default value. See below for data source. Enter actual HHV for fuel burned, if known. \",\" \")))","v":"*HHV value of 11841 Btu/lb is a default value. See below for data source. Enter actual HHV for fuel burned, if known. "}]
[null,"What is the estimated actual annual MWh output?",4000000,"MWh"]
[]
[null,"Waste from a WFDG system disposed in an onsite or offsite landfill?"]
[]
[null,"Gross heat input rate (GHR)",9.5,"MMBtu/MWh"]
[null,null," "]
[null,null," "]
[]
["Enter the following design parameters for the proposed FGD System:"]
[]
[null,"Number of hours the scrubber operates (tABS)",8000,"Hours",null,null,"Plant Elevation",null,500,"Feet above sea level"]
[null,"Number of hours the boiler operates (tplant)",8000,"Hours"]
[null,"Number of Full Time Operators (FT): "]
[null,"                                SDA System",8]
[null,"                                WFGD system",12]
[null,"Estimated equipment life:"]
[null,"                                SDA System",30,"Years"]
[null,"                                Wet FGD System",30,"Years"]
[null,"Estimated equipment life for mercury monitor for wastewater treatment system for Wet FGD Systems",6,"Years"]
[]
["Enter the cost data for the proposed FGD System:"]
[null,null," "]
[null,"Desired dollar-year for Capital Costs",2016]
[null,{"$f":"\"CEPCI for \" & C56","v":"CEPCI for 2016"},541.70000000000005,{"$f":"IF(C56=2016,\" \",\"Enter the CEPCI value for \"&C56)","v":" "},null,541.70000000000005,"2016 CEPCI*"]
[null,"Annual Interest Rate (i)",3.25,{"$f":"IF(C58=3.25, \"Percent**\", \"Percent\")","v":"Percent**"},{"$f":"IF(C58=3.25,\"** 3.25 percent is the default bank prime rate. User should enter current bank prime rate (available at https://www.federalreserve.gov/releases/h15/.)\",\" \")","v":"** 3.25 percent is the default bank prime rate. User should enter current bank prime rate (available at https://www.federalreserve.gov/releases/h15/.)"}]
[null,"Sorbent Cost:"]
[null,"Lime (for SDA)",125,"$/ton of Lime"]
[null,"Limestone (for Wet FGD)",30,"$/ton of Limestone"]
[null,"Water (Costwater)",4.1999999999999997E-3,{"$f":"\"$/gallon\"&(IF(C62=0.00417, \"*\",\" \"))","v":"$/gallon "}]
[null,"Electricity (Costelect)",3.61E-2,{"$f":"\"$/kWh\"&(IF(OR(C63=0.0676, C63=0.0361), \"*\",\" \"))","v":"$/kWh*"}]
[null,"Waste Disposal cost (Costwaste)",30,{"$f":"\"$/ton\"&(IF(C64=48.8, \"*\",\"\"))","v":"$/ton"}]
[null,"Labor Rate",60,"$/hour"]
[null,"Purchase Equipment Cost for Mercury Monitor for wastewater treatment System (MMCost) ",100000,"$/monitor"]
[null,"*Note:  CEPCI = Chemical Engineering Plant Cost Index. The use of CEPCI in this spreadsheet is not an endorsement of the index, 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.",null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null," "]
["Data Sources for Default Values Used in Calculations: ",null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null," "]
[null,"Data Element","Default Value","Sources for Default Value",null,null,null,null,null,"If you used your own site-specific values, please enter the  value used and the reference  source . . . ",null,null,null,null,"Recommended data sources for site-specific information"]
[null,"Lime ($/ton)",125,"U.S. Environmental Protection Agency (EPA). Documentation for EPA's Power Sector Modeling Platform v6 Using the Integrated Planning Model. Office of Air and Radiation. January 2017. Available at:  https://www.epa.gov/airmarkets/documentation-epas-power-sector-modeling-platform-v6.",null,null,null,null,null," ",null,null,null,null,"Check with reagent vendors for current prices. "]
[null,"Limestone ($/ton)",30,"U.S. Environmental Protection Agency (EPA). Documentation for EPA's Power Sector Modeling Platform v6 Using the Integrated Planning Model. Office of Air and Radiation. January 2017. Available at:  https://www.epa.gov/airmarkets/documentation-epas-power-sector-modeling-platform-v6.",null,null,null,null,null," ",null,null,null,null,"Check with reagent vendors for current prices. "]
[null,"Water Cost ($/gallon)",4.1999999999999997E-3,"Average water rates for industrial facilities (compiled by Black & Veatch. See '50 Largest Cities Water/Wastewater Rate Survey - 2018-2019.'Available at www.bv.com/sites/default/files/2019-10/50_Largest_Cities_Rate_Survey_2018_2019_Report.pdf.",null,null,null,null,null," ",null,null,null,null,"Plant's utility bill or  Black & Veatch's \"50 Largest Cities Water/Wastewater Rate Survey.\" Available at http://www.saws.org/who_we_are/community/RAC/docs/2014/50-largest-cities-brochure-water-wastewater-rate-survey.pdf. ."]
[null,"Electricity Cost ($/kWh)",3.61E-2,"U.S. Energy Information Administration. Electric Power Annual 2016, Table 8.4, Published December 2017. Available at: https://www.eia.gov/electricity/annual/pdf/epa.pdf ",null,null,null,null,null," ",null,null,null,null,"Plant's utility bill or use U.S. Energy Information Administration (EIA) data for most recent year. Available at http://www.eia.gov/electricity/data.cfm#sales. "]
[null,"Waste Disposal Cost ($/ton)",30,"U.S. Environmental Protection Agency (EPA). Documentation for EPA's Power Sector Modeling Platform v6 Using the Integrated Planning Model. Office of Air and Radiation. January 2017. Available at:  https://www.epa.gov/airmarkets/documentation-epas-power-sector-modeling-platform-v6.",null,null,null,null,null," ",null,null,null,null,"Check with reagent vendors for current prices. "]
[null,"Higher Heating Value (HHV) (Btu/lb)",11841,"Average HHV based 2016 coal data compiled by the Office of Oil, Gas, and Coal Supply Statistics, U.S. Energy Information Administration (EIA) from data reported on EIA Form EIA-923, Power Plant Operations Report. Available at http://www.eia.gov/electricity/data/eia923/.",null,null,null,null,null," ",null,null,null,null,"Fuel supplier or use  U.S. Energy Information Administration (EIA) data for most recent year. Available at http://www.eia.gov/electricity/data/eia923/."]
[null,"Average Sulfur Content (%)",1.84,"Average sulfur content based on U.S. coal data for 2016 compiled by the U.S. Energy Information Administration (EIA) from data reported on EIA Form EIA-923, Power Plant Operations Report. Available at http://www.eia.gov/electricity/data/eia923/.",null,null,null,null,null," ",null,null,null,null,"Fuel supplier or use  U.S. Energy Information Administration (EIA) data for most recent year. Available at http://www.eia.gov/electricity/data/eia923/."]
[null,"Interest Rate",3.25,"Default bank prime rate March 2, 2021 (available as the rates listed under 'bank prime loan' at https://www.federalreserve.gov/releases/h15/).",null,null,null,null,null," ",null,null,null,null,"Use current bank prime rate available at https://www.federalreserve.gov/releases/h15/."]
[null,"Hourly Labor Rate ($/hour)",60,"U.S. Environmental Protection Agency (EPA). Documentation for EPA's Power Sector Modeling Platform v6 Using the Integrated Planning Model. Office of Air and Radiation. January 2017. Available at:  https://www.epa.gov/airmarkets/documentation-epas-power-sector-modeling-platform-v6.",null,null,null,null,null," ",null,null,null,null,"Plant data."]

{"sheet":"WFGD Design Parameters","index":2,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[[19,0,19,3],[24,3,25,3],[26,3,27,3],[0,0,0,7],[2,0,2,7],[14,4,14,7],[15,4,15,7],[16,4,17,7]]}
["Wet FGD Design Parameters"]
[]
["The following design parameters for the wet FGD system were calculated based on the values entered on the FGD Data Inputs tab. These values were used to prepare the costs shown on the Wet FGD Cost Estimate tab."]
[]
["Parameter","Equation","Calculated Value","Units"]
["Maximum Annual Heat Input Rate (QB) = ","A x GHR = ",{"$f":"'Wet & Dry FGD Data Inputs'!C10*'Wet & Dry FGD Data Inputs'!C38","v":4750},"MMBtu/hour"]
["Maximum Annual MWh Output  (BMW) =","A x 8760 = ",{"$f":"'Wet & Dry FGD Data Inputs'!C10*8760","v":4380000},"MWh"]
["Estimated Actual Annual MWh Output (Boutput) =","Value entered by user",{"$f":"'Wet & Dry FGD Data Inputs'!C34","v":4000000},"MWh"]
["Heat Rate Factor (HRF) =","Gross Plant Heat Rate/10 =",{"$f":"'Wet & Dry FGD Data Inputs'!C38/10","v":0.95}]
["Total System Capacity Factor (CFtotal) =","(Boutput/Bmw)*(tABS/tplant) =",{"$f":"(C8/C7)*('Wet & Dry FGD Data Inputs'!C44/'Wet & Dry FGD Data Inputs'!C45)","v":0.91324200913242004},"fraction"]
["Total effective operating time for the scrubber (top) =","CFtotal x 8760 =",{"$f":"C10*8760","v":8000},"hours"]
["SO2 Removal Efficiency (EF) =","(SO2in - SO2out)/SO2in =",{"$f":"((C16-'Wet & Dry FGD Data Inputs'!C17)/C16)*100","v":96.782336956521746},"percent"]
["SO2 removed per hour =","SO2in x EF x QB  =",{"$f":"(C12/100)*C16*'WFGD Design Parameters'!C6","v":14287.266700447597},"lb/hour"]
["Total SO2 removed per year =","(SO2in x EF x QB x top)/2000 =",{"$f":"C13*C11/2000","v":57149.066801790388},"tons/year"]
["Coal Factor (CoalF) =","1 for bituminous; 1.05 for sub-bituminous; 1.07 for lignite (weighted average is used for coal blends)",{"$f":"IF('Wet & Dry FGD Data Inputs'!S14=1,\" \",(IF('Wet & Dry FGD Data Inputs'!S14=2,1,(IF('Wet & Dry FGD Data Inputs'!S14=3,1.05,(IF('Wet & Dry FGD Data Inputs'!S14=4,1.07,L15)))))))","v":1},null,null,null,null,null,null,null,null,{"$f":"((1*'Wet & Dry FGD Data Inputs'!C23)+(1.05*'Wet & Dry FGD Data Inputs'!C24)+(1.07*'Wet & Dry FGD Data Inputs'!C25))/SUM('Wet & Dry FGD Data Inputs'!C23:C25)","v":{"$error":"#DIV/0!"}}]
["Inlet SO2 Emissions (SO2in) =",{"$f":"IF('Wet & Dry FGD Data Inputs'!H15>0,\"Value entered by user\",\"(Percent Sulfur/100) x (64/32) x 1,000,000)/Heat Input (Btu/Hour) =\")","v":"(Percent Sulfur/100) x (64/32) x 1,000,000)/Heat Input (Btu/Hour) ="},{"$f":"IF(OR('Wet & Dry FGD Data Inputs'!H15=\" \",'Wet & Dry FGD Data Inputs'!H15=0),(('Wet & Dry FGD Data Inputs'!C15/100)*(64/32)*1000000)/'Wet & Dry FGD Data Inputs'!C32,'Wet & Dry FGD Data Inputs'!H15)","v":3.1078456211468626},"lb/MMBtu"]
["Elevation Factor (ELEVF)  = ","14.7 psia/P =",{"$f":"IF('Wet & Dry FGD Data Inputs'!I44<500, \" \", (14.7/C18))","v":1.0175852346041554},null,{"$f":"IF('Wet & Dry FGD Data Inputs'!I44<500, \"Not applicable; elevation factor does not apply to plants located at elevations below 500 feet.\", \" \")","v":" "}]
[{"$f":"IF('Wet & Dry FGD Data Inputs'!I44=0,\"Atmospheric pressure at sea level (P) =\",\"Atmospheric pressure at \"&'Wet & Dry FGD Data Inputs'!I44&\" feet above sea level (P) =\")","v":"Atmospheric pressure at 500 feet above sea level (P) ="},"2116 x [(59-(0.00356xh)+459.7)/518.6]5.256 x (1/144)* =",{"$f":"(2116)*(((59-(0.00356*'Wet & Dry FGD Data Inputs'!I44)+459.7)/518.6)^5.256)*(1/144)","v":14.44596432820525},"psia"]
["Retrofit Factor (RF) =",{"$f":"IF('Wet & Dry FGD Data Inputs'!S8=2,\"New Construction\",(IF('Wet & Dry FGD Data Inputs'!S8=3,\"Retrofit to existing boiler\",\" \")))","v":"Retrofit to existing boiler"},{"$f":"IF('Wet & Dry FGD Data Inputs'!S8=2,0.77,(IF('Wet & Dry FGD Data Inputs'!S8=3,'Wet & Dry FGD Data Inputs'!G7,\" \")))","v":1}]
["* Equation is from the National Aeronautics and Space Administration (NASA), Earth Atmosphere Model. Available at https://spaceflightsystems.grc.nasa.gov/education/rocket/atmos.html. "]
[]
["Capital Recovery Factor:"]
[]
["Parameter","Equation","Calculated Value"]
["Capital Recovery Factor (CRF) = ","i (1+ i)n/((1+ i)n - 1) =",{"$f":"ROUND((('Wet & Dry FGD Data Inputs'!C58/100)*((1+'Wet & Dry FGD Data Inputs'!C58/100)^'Wet & Dry FGD Data Inputs'!C51))/(((1+'Wet & Dry FGD Data Inputs'!C58/100)^'Wet & Dry FGD Data Inputs'!C51)-1),4)","v":5.2699999999999997E-2},"Wet FGD System"]
[null,"Where n = Equipment Life and i= Interest Rate"]
[null,null,{"$f":"ROUND((('Wet & Dry FGD Data Inputs'!C58/100)*((1+'Wet & Dry FGD Data Inputs'!C58/100)^'Wet & Dry FGD Data Inputs'!C52))/(((1+'Wet & Dry FGD Data Inputs'!C58/100)^'Wet & Dry FGD Data Inputs'!C52)-1),4)","v":0.18609999999999999},"Mercury Monitor for Wastewater Treatment System"]
[]
[]
["Parameter","Equation","Calculated Value","Units"]
["Electricity Usage:"]
["Electricity Consumption (P) = ","0.0112e0.155xS x CoalF x HRF x A x 1,000 =",{"$f":"0.0112*EXP(0.155*C16)*'WFGD Design Parameters'!C15*'WFGD Design Parameters'!C9*'Wet & Dry FGD Data Inputs'!C10*1000","v":8612.2824362839128},"kW"]
[]
["Water Usage:"]
["Water consumption (qwater) =                                                                          ","[(1.674 x S + 74.68) x A x CoalF x HRF]/1,000",{"$f":"(((1.674*C16)+74.68)*'Wet & Dry FGD Data Inputs'!C10*'WFGD Design Parameters'!C15*'WFGD Design Parameters'!C9)/1000","v":37.944203445654935},"kgallons/hour"]
[]
["Limestone Usage:"]
["Limestone consumption rate (QLimestone) =","[17.52 x A x S x HRF]/2,000] x (EF/0.98) =",{"$f":"((17.52*'Wet & Dry FGD Data Inputs'!C10*C16*'WFGD Design Parameters'!C9)/2000)*('WFGD Design Parameters'!C12/98)","v":12.771066968971525},"tons/hour"]
[]
["Waste Generation:"]
["Waste generation rate (qwaste) =","[1.811 x QLimestone x (EF/0.98) = ",{"$f":"(1.811*C38*(C12/98))","v":22.841028804153989},"tons/hour"]
[]
["Wastewater Flow Rate:"]
["Wastewater flow rate (F) =","A x (0.4 gallons/min/MW) =",{"$f":"'Wet & Dry FGD Data Inputs'!C10*0.4","v":200},"gallons/minute"]

{"sheet":"WFGD Cost Estimate","index":3,"n_rows":85,"n_cols":7,"rows_kept":85,"cut":false,"hidden":false,"merged":[[81,0,81,3],[82,2,82,3],[36,0,36,2],[31,0,31,3],[32,0,32,3],[33,0,33,3],[35,2,35,3],[44,0,44,3],[58,2,58,3],[60,0,60,3],[61,0,61,3],[72,0,72,3],[73,0,73,3],[79,0,79,3],[42,2,42,3],[53,0,53,3],[54,0,54,3],[56,2,56,3],[57,2,57,3],[45,0,45,3],[46,0,46,3],[47,0,47,3],[48,0,48,3],[50,2,50,3],[40,0,40,3],[24,0,24,3],[25,0,25,3],[26,0,26,3],[28,2,28,3],[29,0,29,2],[38,0,38,3],[39,0,39,3],[21,2,21,3],[10,2,10,3],[12,2,12,3],[14,2,14,3],[17,0,17,3],[19,0,19,3],[20,0,20,3],[9,2,9,3],[0,0,0,3],[2,0,2,3],[4,0,4,3],[5,0,5,3],[7,0,7,3]]}
["Wet FGD Cost Estimate"]
[]
["Total Capital Investment (TCI)"]
[]
[]
["TCI = 1.3 x (ABScost + RPEcost + WHECost + BOPcost) + WWTCost"]
[]
[]
[]
["Capital costs for the absorber (ABScost) =",{"$f":"B22","v":49763270.947605938}]
["Reagent Preparation Equipment Costs (RPEcost) = ",{"$f":"B29","v":23925928.766953669}]
["Waste Handling Equipment (WHECost) =",{"$f":"B36","v":14768988.681092625}]
["Balance of Plant Costs (BOPcost) =",{"$f":"B43","v":91307518.414174944}]
["Wastewater Treatment Facility Costs (WWTcost) =",{"$f":"B51","v":10026942.279999999}]
["Total Capital Investment (TCI) =",{"$f":"1.3*(SUM(B10:B14))","v":246730443.81677535},{"$f":"\"in \"&'Wet & Dry FGD Data Inputs'!$C$56&\" dollars\"&(IF('Wet & Dry FGD Data Inputs'!S19=2,\" with disposal at onsite landfill\",IF('Wet & Dry FGD Data Inputs'!S19=3,\" with disposal at offsite landfill\",\" \")))","v":"in 2016 dollars with disposal at onsite landfill"}]
[]
[null,null,null,null,null,"RF",{"$f":"IF('Wet & Dry FGD Data Inputs'!S8=3,'Wet & Dry FGD Data Inputs'!G7,(IF('Wet & Dry FGD Data Inputs'!S8=2,0.77,0)))","v":1}]
["Wet FGD Capital Costs (ABScost)",null,null,null,null,"ELEVF",{"$f":"IF('Wet & Dry FGD Data Inputs'!I44<500, 1,'SDA Design Parameters'!C17)","v":1.0175852346041554}]
[null,null,null,null,null,"CEPCI",{"$f":"'Wet & Dry FGD Data Inputs'!C57/'Wet & Dry FGD Data Inputs'!F57","v":1}]
["ABScost = 584,000 x (A)0.716 x (CoalF x HRF)0.6  x (S/2)0.02 x ELEVF x RF"]
[]
["Wet FGD Capital Costs (ABScost) = ",{"$f":"584000*('Wet & Dry FGD Data Inputs'!C10^0.716)*(('WFGD Design Parameters'!C15*'WFGD Design Parameters'!C9)^0.6)*(('WFGD Design Parameters'!C16/2)^0.02)*G18*G17*G19","v":49763270.947605938},{"$f":"\"in \"&'Wet & Dry FGD Data Inputs'!$C$56 & \" dollars\"","v":"in 2016 dollars"}]
[]
[]
["Reagent Preparation Costs (RPEcost)"]
[]
[" RPEcost = 202,000 x A0.716 x (S x HRF)0.3 x RF"]
[]
["Reagent Preparation (RPEcost) = ",{"$f":"202000*('Wet & Dry FGD Data Inputs'!C10^0.716)*(('WFGD Design Parameters'!C16*'WFGD Design Parameters'!C9)^0.3)*G17*G19","v":23925928.766953669},{"$f":"\"in \"&'Wet & Dry FGD Data Inputs'!$C$56 & \" dollars\"","v":"in 2016 dollars"}]
[]
[]
["Waste Handling Equipment (WHECost)"]
[]
[" WHEcost = 106,000 x A0.716 x (S x HRF)0.45 x RF"]
[]
["Waste Recycling/Handling (WHEcost) = ",{"$f":"106000*('Wet & Dry FGD Data Inputs'!C10^0.716)*(('WFGD Design Parameters'!C16*'WFGD Design Parameters'!C9)^0.45)*G17*G19","v":14768988.681092625},{"$f":"\"in \"&'Wet & Dry FGD Data Inputs'!$C$56 & \" dollars\"","v":"in 2016 dollars"}]
[]
[]
["Balance of Plant Costs (BOPcost)"]
[]
["BOPcost = 1,070,000 x (A)0.716 x (CoalF x HRF)0.4 x ELEVF x RF"]
[]
["Balance of Plant Costs (BOPcost) =",{"$f":"1070000*('Wet & Dry FGD Data Inputs'!C10^0.716)*(('WFGD Design Parameters'!C15*'WFGD Design Parameters'!C9)^0.4)*G18*G17*G19","v":91307518.414174944},{"$f":"\"in \"&'Wet & Dry FGD Data Inputs'!$C$56 & \" dollars\"","v":"in 2016 dollars"}]
[]
["Wastewater Treatment Facility Costs (WWTcost)"]
["Wastewater Treatment Facility Costs with Onsite Landfill"]
["WWTcost = (41.36 F + 11,157,588) x RF x 0.898"]
["Wastewater Treatement Facility Costs with Offsite Landfill"]
["WWTcost = (41.16 F + 11,557,843) x RF x 0.898"]
[]
["Wastewater Treatment Facility Costs (WWTcost) =",{"$f":"IF('Wet & Dry FGD Data Inputs'!S19=2,((41.36*'WFGD Design Parameters'!C44)+11157588)*0.898*G17*G19,(IF('Wet & Dry FGD Data Inputs'!S19=3,((41.16*'WFGD Design Parameters'!C44)+11557843)*0.898*G17*G19,\" \")))","v":10026942.279999999},{"$f":"\"in \"&'Wet & Dry FGD Data Inputs'!$C$56&\" dollars\"&(IF('Wet & Dry FGD Data Inputs'!S19=2,\" with disposal at onsite landfill\",IF('Wet & Dry FGD Data Inputs'!S19=3,\" with disposal at offsite landfill\",\" \")))","v":"in 2016 dollars with disposal at onsite landfill"}]
[]
[]
["Total Annual Cost (TAC)"]
["TAC = Direct Annual Costs + Indirect Annual Costs"]
[]
["Direct Annual Costs (DAC) =",{"$f":"C71","v":17946160.602521587}]
["Indirect Annual Costs (IDAC) =",{"$f":"C77","v":13092033.869031081}]
["Total annual costs (TAC) = DAC + IDAC",{"$f":"B57+B58","v":31038194.47155267},{"$f":"\"in \"&'Wet & Dry FGD Data Inputs'!$C$56 & \" dollars\"","v":"in 2016 dollars"}]
[]
["Direct Annual Costs (DAC)"]
["DAC = Annual Maintenance Cost + Annual Operator Cost + Annual Reagent Cost + Annual Make-up Water Cost + Annual Waste Disposal Cost + Annual Auxiliary Power Cost + Annual Wastewater Treatment Cost"]
["Annual Maintenance Cost =","0.015 x TCI =",{"$f":"(0.015*B15)","v":3700956.65725163}]
["Annual Operator Cost =","FT × 2,080 × Hourly Labor Rate",{"$f":"'Wet & Dry FGD Data Inputs'!C48*2080*'Wet & Dry FGD Data Inputs'!C65","v":1497600}]
["Annual Reagent Cost =","Qlimestone x CostLimestone x top =",{"$f":"'Wet & Dry FGD Data Inputs'!C61*'WFGD Design Parameters'!C38*'WFGD Design Parameters'!C11","v":3065056.0725531657}]
["Annual Electricity Cost =","P x Costelect x top = ",{"$f":"'WFGD Design Parameters'!C32*'Wet & Dry FGD Data Inputs'!C63*'WFGD Design Parameters'!C11","v":2487227.1675987942}]
["Annual Make-up Water Cost =","qwater x Costwater x top =",{"$f":"'WFGD Design Parameters'!C35*'Wet & Dry FGD Data Inputs'!C62*'WFGD Design Parameters'!C11*1000","v":1274925.2357740058}]
["Annual Waste Disposal Cost  =","qwaste x Costfuel x top =",{"$f":"'WFGD Design Parameters'!C41*'Wet & Dry FGD Data Inputs'!C64*'WFGD Design Parameters'!C11","v":5481846.9129969571}]
["Annual Wastewater Treatment Cost =",{"$f":"IF('Wet & Dry FGD Data Inputs'!S19=2,\"(4.847F + 479,023) x 0.958 x CFtotal =\", (IF('Wet & Dry FGD Data Inputs'!S19=3,\"(6.3225F + 472,080) x 0.958 x CFtotal x ESC =\")))","v":"(4.847F + 479,023) x 0.958 x CFtotal ="},{"$f":"IF('Wet & Dry FGD Data Inputs'!S19=2,((4.847*'WFGD Design Parameters'!C44)+479023)*0.958*'WFGD Design Parameters'!C10,(IF('Wet & Dry FGD Data Inputs'!S19=3,(((6.3225*'WFGD Design Parameters'!C44)+472080)*0.958*'WFGD Design Parameters'!C10),\" \")))","v":419938.55634703196},{"$f":"IF('Wet & Dry FGD Data Inputs'!S19=1, \" \",(IF('Wet & Dry FGD Data Inputs'!S19=2,\"(with disposal at onsite landfill)\", \"(with disposal at offsite landfill)\")))","v":"(with disposal at onsite landfill)"}]
["Replacement Cost for Mercury Monitor  = ","CFmm x MMCost = ",{"$f":"'WFGD Design Parameters'!C27*'Wet & Dry FGD Data Inputs'!C66","v":18610},{"$f":"\"(replaced once every \"&'Wet & Dry FGD Data Inputs'!C52&\" years.)\"","v":"(replaced once every 6 years.)"}]
["Direct Annual Cost = ",null,{"$f":"SUM(C63:C70)","v":17946160.602521587},{"$f":"\"in \"&'Wet & Dry FGD Data Inputs'!$C$56 & \" dollars\"","v":"in 2016 dollars"}]
[]
["Indirect Annual Cost (IDAC)"]
["IDAC = Administrative Charges + Capital Recovery Costs"]
["Administrative Charges (AC) = ","0.03 x (Annual Operator Cost + 0.4(Annual Maintenance Cost)) = ",{"$f":"0.03*(C64+(0.4)*(C63))","v":89339.479887019552}]
["Capital Recovery Costs (CR)=","CRF x TCI =",{"$f":"'WFGD Design Parameters'!C25*B15","v":13002694.389144061}]
["Indirect Annual Cost (IDAC) =","AC + CR =",{"$f":"C75+C76","v":13092033.869031081},{"$f":"\"in \"&'Wet & Dry FGD Data Inputs'!$C$56 & \" dollars\"","v":"in 2016 dollars"}]
[]
[]
["Cost Effectiveness"]
[]
["Cost Effectiveness = Total Annual Cost/ SO2 Removed/year"]
["Total Annual Cost (TAC) =",{"$f":"B59","v":31038194.47155267},{"$f":"\"per year in \"&'Wet & Dry FGD Data Inputs'!$C$56 & \" dollars\"","v":"per year in 2016 dollars"}]
["SO2 Removed =",{"$f":"'SDA Design Parameters'!C14","v":57149.066801790388},"tons/year"]
["Cost Effectiveness = ",{"$f":"B83/B84","v":543.10938408149639},"per ton of SO2 removed in ",{"$f":"'Wet & Dry FGD Data Inputs'!$C$56 & \" dollars\"","v":"2016 dollars"}]

{"sheet":"SDA Design Parameters","index":4,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[[19,0,19,3],[27,0,27,1],[0,0,0,7],[2,0,2,7],[14,4,14,7],[15,4,15,7],[16,4,17,7]]}
["Dry FGD Design Parameters"]
[]
["The following design parameters for the dry FGD system were calculated based on the values entered on the FGD Data Inputs tab. These values were used to prepare the costs shown on the Cost Estimate tab."]
[]
["Parameter","Equation","Calculated Value","Units"]
["Maximum Annual Heat Input Rate (QB) = ","A x GHR = ",{"$f":"'Wet & Dry FGD Data Inputs'!C10*'Wet & Dry FGD Data Inputs'!C38","v":4750},"MMBtu/hour"]
["Maximum Annual MWh Output (BMW) =","A x 8760 = ",{"$f":"'Wet & Dry FGD Data Inputs'!C10*8760","v":4380000},"MWh"]
["Estimated Actual Annual MWh Output (Boutput) =","Value entered by user",{"$f":"'Wet & Dry FGD Data Inputs'!C34","v":4000000},"MWh"]
["Heat Rate Factor (HRF) =","Gross Plant Heat Rate/10 =",{"$f":"'Wet & Dry FGD Data Inputs'!C38/10","v":0.95}]
["Total System Capacity Factor (CFtotal) =","(B/Bmw)*(tABS/tplant) =",{"$f":"(C8/C7)*('Wet & Dry FGD Data Inputs'!C44/'Wet & Dry FGD Data Inputs'!C45)","v":0.91324200913242004},"fraction"]
["Total effective operating time for the scrubber (top) =","CFtotal x 8760 =",{"$f":"C10*8760","v":8000},"hours"]
["SO2 Removal Efficiency (EF) =","(SO2in - SO2out)/SO2in =",{"$f":"((C16-'Wet & Dry FGD Data Inputs'!C17)/C16)*100","v":96.782336956521746},"percent"]
["SO2 removed per hour =","SO2in x EF x QB  =",{"$f":"(C12/100)*C16*'SDA Design Parameters'!C6","v":14287.266700447597},"lb/hour"]
["Total SO2 removed per year =","(SO2in x EF x QB x top)/2000 =",{"$f":"C13*C11/2000","v":57149.066801790388},"tons/year"]
["Coal Factor (CoalF) =","1 for bituminous; 1.05 for sub-bituminous; 1.07 for lignite (weighted average is used for coal blends)",{"$f":"IF('Wet & Dry FGD Data Inputs'!S14=1,\" \",(IF('Wet & Dry FGD Data Inputs'!S14=2,1,(IF('Wet & Dry FGD Data Inputs'!S14=3,1.05,(IF('Wet & Dry FGD Data Inputs'!S14=4,1.07,L15)))))))","v":1},null,null,null,null,null,null,null,null,{"$f":"((1*'Wet & Dry FGD Data Inputs'!C23)+(1.05*'Wet & Dry FGD Data Inputs'!C24)+(1.07*'Wet & Dry FGD Data Inputs'!C25))/SUM('Wet & Dry FGD Data Inputs'!C23:C25)","v":{"$error":"#DIV/0!"}}]
["Inlet SO2 Emissions (SO2in) =",{"$f":"IF('Wet & Dry FGD Data Inputs'!H15>0,\"Value entered by user\",\"(Percent Sulfur/100) x (64/32) x 1,000,000)/Heat Input (Btu/Hour) =\")","v":"(Percent Sulfur/100) x (64/32) x 1,000,000)/Heat Input (Btu/Hour) ="},{"$f":"IF(OR('Wet & Dry FGD Data Inputs'!H15=\" \",'Wet & Dry FGD Data Inputs'!H15=0),(('Wet & Dry FGD Data Inputs'!C15/100)*(64/32)*1000000)/'Wet & Dry FGD Data Inputs'!C32,'Wet & Dry FGD Data Inputs'!H15)","v":3.1078456211468626},"lb/MMBtu"]
["Elevation Factor (ELEVF)  = ","14.7 psia/P =",{"$f":"IF('Wet & Dry FGD Data Inputs'!I44<500, \" \", (14.7/C18))","v":1.0175852346041554},null,{"$f":"IF('Wet & Dry FGD Data Inputs'!I44<500, \"Not applicable; elevation factor does not apply to plants located at elevations below 500 feet.\", \" \")","v":" "}]
[{"$f":"IF('Wet & Dry FGD Data Inputs'!I44=0,\"Atmospheric pressure at sea level (P) =\",\"Atmospheric pressure at \"&'Wet & Dry FGD Data Inputs'!I44&\" feet above sea level (P) =\")","v":"Atmospheric pressure at 500 feet above sea level (P) ="},"2116 x [(59-(0.00356xh)+459.7)/518.6]5.256 x (1/144)* =",{"$f":"(2116)*(((59-(0.00356*'Wet & Dry FGD Data Inputs'!I44)+459.7)/518.6)^5.256)*(1/144)","v":14.44596432820525},"psia"]
["Retrofit Factor (RF) =",{"$f":"IF('Wet & Dry FGD Data Inputs'!S8=2,\"New Construction\",(IF('Wet & Dry FGD Data Inputs'!S8=3,\"Retrofit to existing boiler\",\" \")))","v":"Retrofit to existing boiler"},{"$f":"IF('Wet & Dry FGD Data Inputs'!S8=2,0.77,(IF('Wet & Dry FGD Data Inputs'!S8=3,'Wet & Dry FGD Data Inputs'!G7,\" \")))","v":1}]
["* Equation is from the National Aeronautics and Space Administration (NASA), Earth Atmosphere Model. Available at https://spaceflightsystems.grc.nasa.gov/education/rocket/atmos.html. "]
[]
["Capital Recovery Factor:"]
[]
["Parameter","Equation","Calculated Value"]
["Capital Recovery Factor (CRF) = ","i (1+ i)n/((1+ i)n - 1) =",{"$f":"ROUND((('Wet & Dry FGD Data Inputs'!C58/100)*((1+'Wet & Dry FGD Data Inputs'!C58/100)^'Wet & Dry FGD Data Inputs'!C50))/(((1+'Wet & Dry FGD Data Inputs'!C58/100)^'Wet & Dry FGD Data Inputs'!C50)-1),4)","v":5.2699999999999997E-2}]
[null,"Where n = Equipment Life and i= Interest Rate"]
[]
["Waste Generation and Lime, Water and Power Consumption Rates:"]
[]
["Parameter","Equation","Calculated Value","Units"]
["Electricity Usage:"]
["Electricity Consumption (P) = ","[(0.000547 x S2) + (0.00649 x S) + 1.3] x CoalF x HRF x (1/100) x A x 1,000 =",{"$f":"((0.000547*(C16)^2)+(0.00649*C16)+1.3)*'SDA Design Parameters'!C15*'SDA Design Parameters'!C9*(1/100)*'Wet & Dry FGD Data Inputs'!C10*1000","v":6295.9028396058884},"kW"]
[]
["Water Usage:"]
["Water consumption (qwater) =                                                                          ","[((0.04898 x S2) + (0.5925 x S) + 55.11) x A x CoalF x HRF]/1,000",{"$f":"(((0.04898*(C16)^2)+(0.5925*C16)+55.11)*'Wet & Dry FGD Data Inputs'!C10*'SDA Design Parameters'!C15*'SDA Design Parameters'!C9)/1000","v":27.276628889333292},"kgallons/hour"]
[]
["Lime Usage:"]
["Lime consumption rate (QLime) =","[[((06702 x S2)+(13.42 x S)) x A x HRF]/2,000] x (EF/0.95) =",{"$f":"((((0.6702*(C16)^2)+(13.42*C16))*'Wet & Dry FGD Data Inputs'!C10*'SDA Design Parameters'!C9)/2000)*('SDA Design Parameters'!C12/95)","v":11.657566028603343},"tons/hour"]
[]
["Waste Generation:"]
["Waste generation rate (qwaste) =","[[((0.8016 x S2) + (31.1917 x S)) x A x HRF]/2,000] x EF/0.95 = ",{"$f":"((0.8016*(C16)^2)+(31.1917*C16))*'Wet & Dry FGD Data Inputs'!C10*C9*(1/2000)*(C12/95)","v":25.328277701772169},"lb/hour"]

{"sheet":"SDA Cost Estimate","index":5,"n_rows":76,"n_cols":7,"rows_kept":76,"cut":false,"hidden":false,"merged":[[36,0,36,3],[37,0,37,3],[11,2,11,3],[32,2,32,3],[23,2,23,3],[16,0,16,3],[12,2,12,3],[9,2,9,3],[73,2,73,3],[33,0,33,2],[44,0,44,3],[26,0,26,3],[27,0,27,3],[28,0,28,3],[29,0,29,3],[30,0,30,3],[64,0,64,3],[70,0,70,3],[72,0,72,3],[35,0,35,3],[38,0,38,3],[63,0,63,3],[46,0,46,3],[47,0,47,3],[51,2,51,3],[41,2,41,3],[49,2,49,3],[50,2,50,3],[53,0,53,3],[54,0,54,3],[39,0,39,3],[0,0,0,3],[22,0,22,3],[2,0,2,3],[4,0,4,3],[5,0,5,3],[7,0,7,3],[17,0,17,3],[18,0,18,3],[19,0,19,3],[20,0,20,3],[21,0,21,3],[15,0,15,3],[10,2,10,3]]}
["SDA Cost Estimate"]
[]
["Total Capital Investment (TCI)"]
[]
[]
["TCI = 1.3 x (ABScost + BMFcost + BOPcost)"]
[]
[]
[]
["Capital costs for the absorber (ABScost) =",{"$f":"B24","v":53667443.742948554}]
["Reagent Preparation & Waste Recycling/handling (BMFcost) = ",{"$f":"B33","v":35926576.283249557}]
["Balance of Plant Costs (BOPcost) =",{"$f":"B42","v":76715382.293778777}]
["Total Capital Investment (TCI) =",{"$f":"1.3*(SUM(B10:B12))","v":216202223.01596996},{"$f":"\"in \"&'Wet & Dry FGD Data Inputs'!$C$56 & \" dollars\"","v":"in 2016 dollars"}]
[]
[null,null,null,null,null,"RF",{"$f":"IF('Wet & Dry FGD Data Inputs'!S8=3,'Wet & Dry FGD Data Inputs'!G7,(IF('Wet & Dry FGD Data Inputs'!S8=2,0.77,0)))","v":1}]
["SDA Capital Costs (cost)",null,null,null,null,"ELEVF",{"$f":"IF('Wet & Dry FGD Data Inputs'!I44<500, 1,'SDA Design Parameters'!C17)","v":1.0175852346041554}]
["For Coal-Fired Utility Boilers >600 MW:",null,null,null,null,"CEPCI",{"$f":"'Wet & Dry FGD Data Inputs'!C57/'Wet & Dry FGD Data Inputs'!F57","v":1}]
["ABScost = A x 98,000 x ELEVF",null,null,null,null,{"$f":"'Wet & Dry FGD Data Inputs'!C10*98000*G16*G17","v":49861676.495603614},{"$f":"IF('Wet & Dry FGD Data Inputs'!C10>600,\"Large Boiler\",(IF(OR('Wet & Dry FGD Data Inputs'!C10=600,'Wet & Dry FGD Data Inputs'!C10<600),\"Small Boiler\")))","v":"Small Boiler"}]
[]
[]
["For Coal-Fired Utility Boilers 50 and 600 MW :"]
["ABScost = 637,000 x (A)0.716 x (CoalF x HRF)0.6  x (S/4)0.01 x ELEVF x RF",null,null,null,null,{"$f":"637000*('Wet & Dry FGD Data Inputs'!C10^0.716)*(('SDA Design Parameters'!C15*'SDA Design Parameters'!C9)^0.6)*(('SDA Design Parameters'!C16/4)^0.01)*G15*G16*G17","v":53667443.742948554}]
[]
["SDA Capital Costs (ABScost) = ",{"$f":"IF(G18=\"Large Boiler\",'SDA Cost Estimate'!F18,IF(G18=\"Small Boiler\",'SDA Cost Estimate'!F22))","v":53667443.742948554},{"$f":"\"in \"&'Wet & Dry FGD Data Inputs'!$C$56 & \" dollars\"","v":"in 2016 dollars"}]
[]
[]
["Reagent Preparation and Waste Recycling/Handling Costs (BMFcost)"]
["For Coal-Fired Utility Boilers >600 MW:"]
[" BMFcost = A x 52,000",null,null,null,null,{"$f":"'Wet & Dry FGD Data Inputs'!C10*52000*G17","v":26000000}]
["For Coal-Fired Utility Boilers 50 and 600 MW :"]
[" BMFcost = 338,000 x A0.716 x (S x HRF)0.2 x RF",null,null,null,null,{"$f":"338000*('Wet & Dry FGD Data Inputs'!C10^0.716)*(('SDA Design Parameters'!C16*'SDA Design Parameters'!C9)^0.2)*'SDA Cost Estimate'!G15*'SDA Cost Estimate'!G17","v":35926576.283249557}]
[]
["Reagent Preparation & Waste Recycling/Handling (BMFcost) = ",{"$f":"IF(G18=\"Large Boiler\",'SDA Cost Estimate'!F29,IF(G18=\"Small Boiler\",'SDA Cost Estimate'!F31))","v":35926576.283249557},{"$f":"\"in \"&'Wet & Dry FGD Data Inputs'!$C$56 & \" dollars\"","v":"in 2016 dollars"}]
[]
[]
["Balance of Plant Costs (BOPcost)"]
["For Coal-Fired Utility Boilers >600 MW:"]
["BOPcost = 138,000 x A x ELEVF",null,null,null,null,{"$f":"138000*'Wet & Dry FGD Data Inputs'!C10*'SDA Cost Estimate'!G16*'SDA Cost Estimate'!G17","v":70213381.187686726}]
["For Coal-Fired Utility Boilers betwee 50 and 600 MW :"]
["BOPcost = 899,000 x (A)0.716 x (CoalF x HRF)0.4 x ELEVF x RF",null,null,null,null,{"$f":"(899000)*('Wet & Dry FGD Data Inputs'!C10^0.716)*(('SDA Design Parameters'!C15*'SDA Design Parameters'!C9)^0.4*G16*G15*G17)","v":76715382.293778777}]
[]
["Balance of Plant Costs (BOPcost) =",{"$f":"IF(G18=\"Large Boiler\",'SDA Cost Estimate'!F38,IF(G18=\"Small Boiler\",'SDA Cost Estimate'!F40))","v":76715382.293778777},{"$f":"\"in \"&'Wet & Dry FGD Data Inputs'!$C$56 & \" dollars\"","v":"in 2016 dollars"}]
[]
[]
["Annual Costs"]
[]
["Total Annual Cost (TAC)"]
["TAC = Direct Annual Costs + Indirect Annual Costs"]
[]
["Direct Annual Costs (DAC) =",{"$f":"C62","v":24712537.493027993}]
["Indirect Annual Costs (IDAC) =",{"$f":"C68","v":11462725.553084491}]
["Total annual costs (TAC) = DAC + IDAC",{"$f":"B50+B51","v":36175263.046112485},{"$f":"\"in \"&'Wet & Dry FGD Data Inputs'!$C$56 & \" dollars\"","v":"in 2016 dollars"}]
[]
["Direct Annual Costs (DAC)"]
["DAC = (Annual Maintenance Cost) + (Annual Operator Cost) +(Annual Reagent Cost) + (Annual Make-up Water Cost) + (Annual Waste Disposal Cost) + (Annual Auxiliary Power Cost)"]
["Annual Maintenance Cost =","0.015 x TCI =",{"$f":"(0.015*B13)","v":3243033.3452395494}]
["Annual Operator Cost =","FT × 2,080 × Hourly Labor Rate",{"$f":"'Wet & Dry FGD Data Inputs'!C47*2080*'Wet & Dry FGD Data Inputs'!C65","v":998400}]
["Annual Reagent Cost =","Qlime x Costreag x top =",{"$f":"'Wet & Dry FGD Data Inputs'!C60*'SDA Design Parameters'!C38*'SDA Design Parameters'!C11","v":11657566.028603343}]
["Annual Electricity Cost =","P x Costelect x top = ",{"$f":"'SDA Design Parameters'!C32*'Wet & Dry FGD Data Inputs'!C63*'SDA Design Parameters'!C11","v":1818256.7400781806}]
["Annual Make-up Water Cost =","qwater x Costwater x top =",{"$f":"'SDA Design Parameters'!C35*'Wet & Dry FGD Data Inputs'!C62*'SDA Design Parameters'!C11*1000","v":916494.73068159865}]
["Annual Waste Disposal Cost  =","qwaste x Costfuel x top =",{"$f":"'SDA Design Parameters'!C41*'Wet & Dry FGD Data Inputs'!C64*'SDA Design Parameters'!C11","v":6078786.6484253211}]
["Direct Annual Cost = ",null,{"$f":"SUM(C56:C61)","v":24712537.493027993},{"$f":"\"in \"&'Wet & Dry FGD Data Inputs'!$C$56 & \" dollars\"","v":"in 2016 dollars"}]
[]
["Indirect Annual Cost (IDAC)"]
["IDAC = Administrative Charges + Capital Recovery Costs"]
["Administrative Charges (AC) = ","0.03 x (Annual Operator Cost + 0.4(Annual Maintenance Cost)) = ",{"$f":"0.03*(C57+(0.4)*(C56))","v":68868.400142874583}]
["Capital Recovery Costs (CR)=","CRF x TCI =",{"$f":"'SDA Design Parameters'!C25*B13","v":11393857.152941616}]
["Indirect Annual Cost (IDAC) =","AC + CR =",{"$f":"C66+C67","v":11462725.553084491},{"$f":"\"in \"&'Wet & Dry FGD Data Inputs'!$C$56 & \" dollars\"","v":"in 2016 dollars"}]
[]
[]
["Cost Effectiveness"]
[]
["Cost Effectiveness = Total Annual Cost/ SO2 Removed/year"]
["Total Annual Cost (TAC) =",{"$f":"B52","v":36175263.046112485},{"$f":"\"per year in \"&'Wet & Dry FGD Data Inputs'!$C$56 & \" dollars\"","v":"per year in 2016 dollars"}]
["SO2 Removed =",{"$f":"'SDA Design Parameters'!C14","v":57149.066801790388},"tons/year"]
["Cost Effectiveness = ",{"$f":"B74/B75","v":632.99831599313484},"per ton of SO2 removed in ",{"$f":"'Wet & Dry FGD Data Inputs'!$C$56 & \" dollars\"","v":"2016 dollars"}]

{"sheet":"PB Scrubber Data Inputs","index":6,"n_rows":88,"n_cols":19,"rows_kept":88,"cut":false,"hidden":false,"merged":[[18,5,19,7],[80,9,80,13],[81,3,81,8],[82,3,82,8],[82,9,82,13],[5,5,5,6],[0,0,0,14],[2,0,2,14],[9,5,9,6],[79,3,79,8],[79,9,79,13],[55,7,55,8],[57,3,58,6],[60,0,60,14],[64,1,64,7],[66,4,66,7],[23,0,23,14],[24,1,24,4],[42,2,42,3],[54,7,54,8],[33,6,33,7],[87,3,87,8],[87,9,87,13],[81,9,81,13],[44,4,47,6],[83,3,83,8],[84,3,84,8],[84,9,84,13],[83,9,83,13],[85,3,85,8],[85,9,85,13],[86,3,86,8],[86,9,86,13],[80,3,80,8]]}
["Data Inputs for Packed Bed Scrubber"]
[]
["Waste Stream Characteristics:"]
["Directions: Enter data in highlighted cells."]
[]
[null,"Pollutant name","HCl",null,null,"Name of Solvent ",null,"water"]
[null,"Concentration of pollutant in waste gas (C)",1871,"ppmv"]
[null,"Waste Gas Flow rate (Gin)",22288,"acfm"]
[null,"Temperature (T)",100,"oF"]
[null,"Density of waste gas (ρG)",7.0900000000000005E-2,"lb/ft3"]
[null,"Density of liquid (ρL) ",62.4,"lb/ft3"]
[null,"Molecular weight for pollutant (MWp)",36.5,"lb/lb-mole"]
[null,"Molecular weight of waste gas (MWG) ",29,"lb/lb-mole"]
[null,"Molecular weight of Liquid (MWL) ",18,"lb/lb-mole"]
[null,"Viscosity of waste gas (μG)",4.3999999999999997E-2,"lb/ft-hour"]
[null,"Viscosity of liquid (μL)",2.16,"lb/ft-hour"]
[null,"Minimum wetting rate (MWR)",1.3,"sq.ft/hour"]
[null,"Diffusivity of pollutant in air (DG)",0.72499999999999998,"sq.ft/hour"]
[null,"Diffusivity of pollutant in solvent (DL)",1.02E-4,"sq.ft/hour",null,"* See Appendix tab for diffusity values for some common pollutants. "]
[null,"Maximum pollutant concentration in liquid phase in equilibrium with pollutant entering column in gas phase (Xout*)",0.16,"lb-moles of pollutant/lb-mole of pollutant free solvent"]
[null,"Pollutant concentration exiting the absorber in equilibrium with concentration in liquid phase (Yout*)",1E-4,"lb-moles of pollutant/lb-moles of total gas"]
[]
[]
["Packed Bed Scrubber Specifications:"]
[]
[null,"Sorbent Name","Sodium hydroxide"]
[null,"Number of moles of sorbent needed to neutralize 1 mole of pollutant",0.5]
[null,"Name of waste species produced","sodium chloride"]
[null,{"$f":"\"Number of moles of \"&C28&\" (waste) generated per mole of \"&C6&\" removed\"","v":"Number of moles of sodium chloride (waste) generated per mole of HCl removed"},1]
[null,{"$f":"\"Percent by weight of \"&C28&\" in wastewater (WF)\"","v":"Percent by weight of sodium chloride in wastewater (WF)"},10,"percent by weight"]
[null,"Molecular weight of Sorbent (MWs) ",39.97,"lb/lb-mole"]
[null,"Molecular weight of waste produced (MWw) ",58.5,"lb/lb-mole"]
[null,"Pollutant Removal Efficiency (η)",99,"percent"]
[null,"Number of hours the scrubber operates (top)",8000,"Hours"]
[null,"Pump Efficiency (ε)",70,"percent"]
[null,"Estimated Equipment Life",30,"Years"]
[null,"L/G adjustment factor to convert (L/G)min to (L/G)actual",1.5,"* Typically between 1.2 and 1.5"]
[null,"Flooding factor (f)",0.7,"* Typically between 0.6 and 0.75"]
[null,"Pressure for the solvent pump (Ppump)",60,"feet of water"]
[null,"Impeller diameter for fan (d) =",33,"inches"]
[]
[null,"Packing Material Properties*"]
[null,"Packing type","2-inch ceramic Raschig rings"]
[null,"Packing factor (Fp)",65]
[null,"Packing constant (α)",3.82,null,"* See Appendix tab for constants for common packing materials. "]
[null,"Packing constant (β)",0.41]
[null,"Packing constant (γ)",0.45]
[null,"Packing constant (φ)",1.2500000000000001E-2]
[null,"Packing constant (b)",0.22]
[null,"Surface area to volume ratio",28,"ft2/ft3"]
[null,"Packing constant c",0.24]
[null,"Packing constant j",0.17]
[]
[null,"Select material for construction of absorber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Material",1]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fiberglass Reinforced Plastic"]
[null,"Site Preparation Cost =",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"304 Stainless Steel"]
[null,"Building Costs =",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polypropylene"]
["Enter the following design parameters for the proposed packed bed scrubber:","Contingency Factor (CF) = ",0.1,{"$f":"IF(C58=0.1,\"* Note: 0.1 is a default value. Values of between 0.05 and 0.15 may be used to account for unexpected costs associated with the fabrication and installation of the control system.\",\" \")","v":"* Note: 0.1 is a default value. Values of between 0.05 and 0.15 may be used to account for unexpected costs associated with the fabrication and installation of the control system."},null,null,null,null,null,null,null,null,null,null,null,null,null,"Polyvinylchloride"]
[]
[]
["Cost Information:"]
[null,null," "]
[null,"Desired dollar-year",2016]
[null,{"$f":"\"CEPCI for \" & C63","v":"CEPCI for 2016"},541.70000000000005,{"$f":"\"Enter the CEPCI value for \"&C63","v":"Enter the CEPCI value for 2016"},null,390.6,"1991 CEPCI*"]
[null,"*Note:  CEPCI = Chemical Engineering Plant Cost Index. The use of CEPCI in this spreadsheet is not an endorsement of the index, 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."]
[]
[null,"Annual Interest Rate (i)",3.25,{"$f":"IF(C67=3.25, \"Percent*\", \"Percent\")","v":"Percent*"},{"$f":"IF(C67=3.25,\"* 3.25 percent is the default bank prime rate. User should enter current bank prime rate (available at https://www.federalreserve.gov/releases/h15/.)\",\" \")","v":"* 3.25 percent is the default bank prime rate. User should enter current bank prime rate (available at https://www.federalreserve.gov/releases/h15/.)"}]
[]
[null,"Packing Material Cost (Costpacking)",20,"$/ft3"]
[null,"Sorbent (Costsorbent)",447,"$/ton"]
[null,"Solvent (CostSolvent)",4.1999999999999997E-3,{"$f":"\"$/gallon\"&(IF(C71=0.0042, \"*\",\" \"))","v":"$/gallon*"}]
[null,"Electricity (Costelect)",6.7599999999999993E-2,{"$f":"\"$/kWh\"&(IF(OR(C72=0.0676, C72=0.0674), \"*\",\" \"))","v":"$/kWh*"}]
[null,"Waste Disposal cost (Costwaste)",5.7000000000000002E-3,{"$f":"\"$/gallon\"&(IF(C73=0.0057, \"*\",\"\"))","v":"$/gallon*"}]
[null,"Operator Labor Rate",26.61,"$/hour"]
[null,"Maintenance Labor Rate",29.27,"$/hour"]
[null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null," "]
["Data Sources for Default Values Used in Calculations: ",null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null," "]
[null,"Data Element","Default Value","Sources for Default Value",null,null,null,null,null,"If you used your own site-specific values, please enter the  value used and the reference  source . . . ",null,null,null,null,"Recommended data sources for site-specific information"]
[null,{"$f":"C26&\" cost ($/ton)\"","v":"Sodium hydroxide cost ($/ton)"},447,"Price of caustic soda based on July 2016 data reported in Outlook '17: The Calm Before the Storm for European Caustic Soda, ICIS, January 11, 2017 (available at https://www.icis.com/explore/resources/news/2017/01/11/10064199/outlook-17-the-calm-before-the-storm-for-european-caustic-soda/). Value shown is based on $340 per ton of sodium oxide in a 76% sodium oxide/water solution. ",null,null,null,null,null," ",null,null,null,null,"Check with reagent vendors for current prices. "]
[null,"Packing material cost ($/ft3)",20,"Section 5, Chapter 1 (Wet and Dry Scrubbers for Acid Gas Control), Table 1.7.",null,null,null,null,null," ",null,null,null,null,"Check with reagent vendors for current prices. "]
[null,{"$f":"\"Solvent (\"&H6&\") cost ($/gallon)\"","v":"Solvent (water) cost ($/gallon)"},4.1999999999999997E-3,"Average water rates for industrial facilities (compiled by Black & Veatch). See '50 Largest Cities Water/Wastewater Rate Survey - 2018-2019.'Available at www.bv.com/sites/default/files/2019-10/50_Largest_Cities_Rate_Survey_2018_2019_Report.pdf.",null,null,null,null,null," ",null,null,null,null,"Plant's utility bill or  Black & Veatch's \"50 Largest Cities Water/Wastewater Rate Survey.\" Available at http://www.saws.org/who_we_are/community/RAC/docs/2014/50-largest-cities-brochure-water-wastewater-rate-survey.pdf. ."]
[null,"Electricity Cost ($/kWh)",6.7599999999999993E-2,"U.S. Energy Information Administration. Electric Power Annual 2016. Table 2.10. Published December 2017. Available at: https://www.eia.gov/electricity/annual/pdf/epa.pdf.",null,null,null,null,null," ",null,null,null,null,"Plant's utility bill or use U.S. Energy Information Administration (EIA) data for most recent year. Available at http://www.eia.gov/electricity/data.cfm#sales. "]
[null,"Waste Disposal Cost ($/gallon)",5.7000000000000002E-3,"Average water rates for industrial facilities in 2016 compiled by Black & Veatch. See '50 Largest Cities Water/Wastewater Rate Survey - 2018-2019.' Available at https://www.bv.com/sites/default/files/2019-10/50_Largest_Cities_Rate_Survey_2018_2019_Report.pdf.",null,null,null,null,null," ",null,null,null,null,"Plant's utility bill or  Black & Veatch's \"50 Largest Cities Water/Wastewater Rate Survey.\" Available at http://www.saws.org/who_we_are/community/RAC/docs/2014/50-largest-cities-brochure-water-wastewater-rate-survey.pdf. ."]
[null,"Interest Rate",3.25,"Default bank prime rate March 2, 2021 (available as the rates listed under 'bank prime loan' at https://www.federalreserve.gov/releases/h15/).",null,null,null,null,null," ",null,null,null,null,"Use current bank prime rate available at https://www.federalreserve.gov/releases/h15/."]
[null,"Operator Labor Rate",26.61,"Bureau of Labor Statistics, May 2016 National Occupational Employment and Wage Estimates - United States, May 2016 (https://www.bls.gov/oes/2016/may/oes_nat.htm). Hourly rates for operators based on data for Plant and System Operators - other (51-8099).",null,null,null,null,null," ",null,null,null,null,"Plant data."]
[null,"Maintenance Labor Rate",29.27,"Maintenance labor rate is estimated at 110% of the operator wage rate.",null,null,null,null,null," ",null,null,null,null,"Plant data."]

{"sheet":"PB Scrubber Design Parameters","index":7,"n_rows":77,"n_cols":28,"rows_kept":77,"cut":false,"hidden":false,"merged":[[56,3,57,3],[0,0,0,7],[2,0,2,7],[29,4,30,4],[49,4,49,7]]}
["Packed Bed Scrubber Design Parameters",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Abscissa (Eq 73)",null,"Ordinate (Eq74)","Ordinate (Eq75)",null,"A","(Lmol,i) ","Gsfr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA2/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":4.5305357791343363E-2},null,{"$f":"ROUND(((AB2^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.20100000000000001},{"$f":"ROUND(10^(-1.668-(1.085*LOG10(U2))-(0.297*(LOG10(U2)^2))),3)","v":0.17899999999999999},{"$f":"ABS(W2-X2)","v":2.200000000000002E-2},{"$f":"ROUNDUP('PB Scrubber Design Parameters'!C29,0)","v":56},{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z2","v":7066.4533333333329},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z2","v":0.67060485113809543}]
["The following design parameters for a packed bed scrubber were calculated based on the values entered on the PB Scrubber Data Inputs tab. These values were used to prepare the costs shown on the PB Scrubber Cost Estimate tab.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA3/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":4.5709869914480367E-2},null,{"$f":"ROUND(((AB3^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.19700000000000001},0.17899999999999999,1.8000000000000016E-2,{"$f":"Z2+0.5","v":56.5},{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z3","v":7129.5466666666671},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z3","v":0.66467029493333352}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA4/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":4.6114382037617356E-2},null,{"$f":"ROUND(((AB4^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.19400000000000001},0.17799999999999999,1.6000000000000014E-2,57,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z4","v":7192.64},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z4","v":0.65883985374970788}]
["Parameter","Equation","Calculated Value","Units",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA5/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":4.6518894160754352E-2},null,{"$f":"ROUND(((AB5^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.19},0.17799999999999999,1.2000000000000011E-2,57.5,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z5","v":7255.7333333333336},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z5","v":0.65311081154318862}]
[{"$f":"\"Concentration of \"&'PB Scrubber Data Inputs'!C6&\" entering absorber (Yin) =\"","v":"Concentration of HCl entering absorber (Yin) ="},"(C/106)/(1- C/106) = ",{"$f":"('PB Scrubber Data Inputs'!C7/1000000)/(1-('PB Scrubber Data Inputs'!C7/1000000))","v":1.8745072029767696E-3},"lb-moles pollutant/lb-mole pollutant free gas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA6/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":4.6923406283891349E-2},null,{"$f":"ROUND(((AB6^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.187},0.17799999999999999,9.000000000000008E-3,58,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z6","v":7318.8266666666668},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z6","v":0.647480545926437}]
[{"$f":"\"Concentration of \"&'PB Scrubber Data Inputs'!C6&\" exiting absorber (Yout) =\"","v":"Concentration of HCl exiting absorber (Yout) ="},"Yin (1 - η/100) =",{"$f":"C6*(1-('PB Scrubber Data Inputs'!C33/100))","v":1.8745072029767714E-5},"lb-moles pollutant/lb-mole pollutant free gas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA7/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":4.7327918407028338E-2},null,{"$f":"ROUND(((AB7^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.184},0.17699999999999999,7.0000000000000062E-3,58.5,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z7","v":7381.92},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z7","v":0.64194652416638198}]
["Waste gas flow rate entering the absorber (Gin) =","Waste gas flow rate exiting the absorber (Gout) =",{"$f":"'PB Scrubber Data Inputs'!C8","v":22288},"acfm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA8/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":4.7732430530165328E-2},null,{"$f":"ROUND(((AB8^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.18099999999999999},0.17699999999999999,4.0000000000000036E-3,59,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z8","v":7445.0133333333333},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z8","v":0.636506299385311}]
["Removal efficiency (η) = ","Specified by user",{"$f":"'PB Scrubber Data Inputs'!C33","v":99},"Percent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA9/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":4.8136942653302324E-2},null,{"$f":"ROUND(((AB9^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.17799999999999999},0.17599999999999999,2.0000000000000018E-3,59.5,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z9","v":7508.1066666666666},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z9","v":0.63115750695350159}]
[{"$f":"\"Concentration of \"&'PB Scrubber Data Inputs'!C6&\" entering the absorber in the solvent (Xin) = \"","v":"Concentration of HCl entering the absorber in the solvent (Xin) = "},"Assuming system is a once through design or spent solvent is regenerated before recycled. ",0,"lb-moles pollutant/lb-mole pollutant free solvent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA10/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":4.8541454776439327E-2},null,{"$f":"ROUND(((AB10^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.17499999999999999},0.17599999999999999,1.0000000000000009E-3,60,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z10","v":7571.2},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z10","v":0.62589786106222245}]
["Maximum pollutant concentration in liquid phase in equilibrium with pollutant entering column in gas phase (xout*) =","Provided by user (derived from an equilibrium curve)",0.16,"lb-moles pollutant/lb-mole pollutant free solvent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA11/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":4.8945966899576317E-2},null,{"$f":"ROUND(((AB11^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.17199999999999999},0.17499999999999999,3.0000000000000027E-3,60.5,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z11","v":7634.2933333333331},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z11","v":0.62072515146666685}]
["Minimum L/G ratio (Ls/Gs)min = ","(Yin - Yout)/(Xout* - Xin) = ",{"$f":"(C6-C7)/(C11-C10)","v":1.1598513318418761E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA12/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":4.9350479022713313E-2},null,{"$f":"ROUND(((AB12^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.16900000000000001},0.17499999999999999,5.9999999999999776E-3,61,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z12","v":7697.3866666666663},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z12","v":0.61563724038907131}]
["Actual L/G ratio (Ls/Gs)actual = ","(Ls/Gs)min x Adjustment Factor =",{"$f":"C12*'PB Scrubber Data Inputs'!C37","v":1.7397769977628142E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA13/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":4.9754991145850309E-2},null,{"$f":"ROUND(((AB13^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.16600000000000001},0.17399999999999999,7.9999999999999793E-3,61.5,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z13","v":7760.4800000000005},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z13","v":0.6106320595728999}]
["Molar flow rate of pollutant free gas (Gs) =","(60 x ρG x Gin)/(MWG x (1 + Yin)) =",{"$f":"(60*'PB Scrubber Data Inputs'!C10*C8)/('PB Scrubber Data Inputs'!C13*(1+'PB Scrubber Design Parameters'!C6))","v":3263.3019514692423},"lb-moles/hour",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA14/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":5.0159503268987299E-2},null,{"$f":"ROUND(((AB14^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.16400000000000001},0.17399999999999999,9.9999999999999811E-3,62,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z14","v":7823.5733333333337},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z14","v":0.60570760747957009}]
["Molar flow rate of pollutant free solvent (Ls) = ","(Ls/Gs)actual x Gs =",{"$f":"C13*C14","v":56.774176719206913},"lb-moles/hour",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA15/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":5.0564015392124302E-2},null,{"$f":"ROUND(((AB15^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.161},0.17399999999999999,1.2999999999999984E-2,62.5,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z15","v":7886.666666666667},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z15","v":0.60086194661973358}]
["Waste gas molar flow rate entering the absorber (Gmol,in) = ","Gs x (1 + Yin) =",{"$f":"C14*(1+C6)","v":3269.4190344827593},"lb-moles/hour",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA16/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":5.0968527515261292E-2},null,{"$f":"ROUND(((AB16^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.158},0.17299999999999999,1.4999999999999986E-2,63,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z16","v":7949.76},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z16","v":0.59609320101164043}]
["Liquid molar flow rate entering the absorber (Lmole,in) = ","Ls x (1 + Xin) =",{"$f":"C15*(1+C10)","v":56.774176719206913},"lb-moles/hour",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA17/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":5.1373039638398281E-2},null,{"$f":"ROUND(((AB17^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.156},0.17299999999999999,1.6999999999999987E-2,63.5,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z17","v":8012.8533333333335},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z17","v":0.59139955375958031}]
["Concentration of pollutant exiting the absorber in the solvent (xout) =","[(Yin - Yout)/(Ls/Gs)actual)] + Xin = ",{"$f":"((C6-C7)/C13)+C10","v":0.10666666666666667},{"$f":"\"lb-moles \"&'PB Scrubber Data Inputs'!C6&\"/lb-mole solvent\"","v":"lb-moles HCl/lb-mole solvent"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA18/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":5.177755176153527E-2},null,{"$f":"ROUND(((AB18^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.154},0.17199999999999999,1.7999999999999988E-2,64,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z18","v":8075.9466666666667},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z18","v":0.58677924474583354}]
["Mole fraction of pollutant exiting the absorber (xout) = ","Xout/(1 + Xout) =",{"$f":"C18/(1+C18)","v":9.6385542168674704E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA19/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":5.2182063884672281E-2},null,{"$f":"ROUND(((AB19^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.151},0.17199999999999999,2.0999999999999991E-2,64.5,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z19","v":8139.04},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z19","v":0.58223056842997434}]
["Pollutant concentration exiting the absorber in equilibrium with concentration in liquid phase (Yout*)","Provided by user (derived from an equilibrium curve)",1E-4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA20/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":5.258657600780927E-2},null,{"$f":"ROUND(((AB20^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.14899999999999999},0.17100000000000001,2.200000000000002E-2,65,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z20","v":8202.1333333333332},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z20","v":0.57775187174974374}]
["Mole fraction of pollutant exiting the absorber in equilibrium with concentration in liquid phase (yout*) = ","Yout*/(1 + Yout*) =",{"$f":"C20/(1+C20)","v":9.9990000999900015E-5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA21/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":5.2991088130946266E-2},null,{"$f":"ROUND(((AB21^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.14699999999999999},0.17100000000000001,2.4000000000000021E-2,65.5,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z21","v":8265.2266666666674},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z21","v":0.57334155211806637}]
["Slope of equilibrium line between xin and xout (m) =","(yout* - yin*)/(xout - xin) =",{"$f":"(C21-0)/(C11-C10)","v":6.249375062493751E-4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA22/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":5.3395600254083249E-2},null,{"$f":"ROUND(((AB22^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.14399999999999999},0.17100000000000001,2.7000000000000024E-2,66,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z22","v":8328.32},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z22","v":0.56899805551111127}]
["Absorption factor (AF) = ","Lmol,in/(m x Gmol,in) = ",{"$f":"(C13/C22)","v":27.839215607401446},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA23/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":5.3800112377220252E-2},null,{"$f":"ROUND(((AB23^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.14199999999999999},0.17,2.8000000000000025E-2,66.5,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z23","v":8391.4133333333339},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z23","v":0.56471987464260676}]
["Calculated Abscissa =","(Lmol,in/Gmol,in) x (MWL/MWG) x (ρG/ρL)0.5 =",{"$f":"C13*('PB Scrubber Data Inputs'!C14/'PB Scrubber Data Inputs'!C13)*('PB Scrubber Data Inputs'!C10/'PB Scrubber Data Inputs'!C11)^0.5","v":3.6399793053742556E-4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA24/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":5.4204624500357242E-2},null,{"$f":"ROUND(((AB24^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.14000000000000001},0.17,0.03,67,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z24","v":8454.5066666666662},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z24","v":0.56050554721990065}]
["Minimum Abscissa = ",null,0.01,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA25/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":5.4609136623494238E-2},null,{"$f":"ROUND(((AB25^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.13800000000000001},0.16900000000000001,3.1E-2,67.5,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z25","v":8517.6},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z25","v":0.55635365427753103}]
["Ordinate =","10[-1.668 - 1.085(log Abscissa) - 0.297(log(Abscissa)2] =",{"$f":"IF(C24>C25,10^(-1.668-(1.085*(LOG10C24)))-(0.297*(LOG10(C24))^2), 10^(-1.668-(1.085*(LOG10(C25)))-(0.297*(LOG10(C25))^2)))","v":0.20606299132700004},{"$f":"IF(C24<C25, \"*Ordinate calculated using minimum abscissa value of 0.01.\")","v":"*Ordinate calculated using minimum abscissa value of 0.01."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA26/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":5.5013648746631227E-2},null,{"$f":"ROUND(((AB26^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.13600000000000001},0.16900000000000001,3.3000000000000002E-2,68,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z26","v":8580.6933333333327},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z26","v":0.55226281858431392}]
["Ratio of the density of the scrubbing liquid to water (ψ)","ρL/ρw =",{"$f":"'PB Scrubber Data Inputs'!C11/62.4","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA27/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":5.5418160869768224E-2},null,{"$f":"ROUND(((AB27^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.13400000000000001},0.16800000000000001,3.4000000000000002E-2,68.5,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z27","v":8643.7866666666669},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z27","v":0.54823170312019487}]
["Superficial gas flow rate (Gsfr,in) =","[(ρL x ρG x gc x Ordinate)/(Fp x ψ x (μL/2.42)0.2]0.5 =",{"$f":"(('PB Scrubber Data Inputs'!C11*'PB Scrubber Data Inputs'!C10*32.2*C26)/('PB Scrubber Data Inputs'!C44*'PB Scrubber Design Parameters'!C27*(('PB Scrubber Data Inputs'!C16/2.42)^0.2)))^0.5","v":0.67970870420751894},"lb/sec-ft2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA28/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":5.5822672992905213E-2},null,{"$f":"ROUND(((AB28^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.13200000000000001},0.16800000000000001,3.6000000000000004E-2,69,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z28","v":8706.8799999999992},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z28","v":0.54425900961932383}]
["Calculated cross-sectional area (Acalc) = ","(Gmol,in x MWG)/(3,600 x Gsfr,in x f) =",{"$f":"(C16*'PB Scrubber Data Inputs'!C13)/(3600*C28*'PB Scrubber Data Inputs'!C38)","v":55.353516048515651},"ft2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA29/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":5.6227185116042223E-2},null,{"$f":"ROUND(((AB29^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.13},0.16800000000000001,3.8000000000000006E-2,69.5,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z29","v":8769.9733333333334},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z29","v":0.54034347717601938}]
["Superficial liquid flow rate (Lsfr,in) =","(Lmol,in x MWL)/Acalc =",{"$f":"(C17*'PB Scrubber Data Inputs'!C14)/'PB Scrubber Design Parameters'!C29","v":18.461974123740031},"lb/hour-ft2",{"$f":"IF(C30<C31,\"*Calculated liquid flow rate is below the minimum needed to wet the packed bed.\",\"*Liquid flow rate is above the minimum needed to wet the packed bed.\")","v":"*Calculated liquid flow rate is below the minimum needed to wet the packed bed."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA30/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":5.663169723917922E-2},null,{"$f":"ROUND(((AB30^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.128},0.16700000000000001,3.9000000000000007E-2,70,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z30","v":8833.0666666666675},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z30","v":0.53648388091047639}]
["Minimum superficial liquid flow rate needed to wet the packed bed (Lsfr,in)min =","MWR x ρL x a = ",{"$f":"'PB Scrubber Data Inputs'!C17*'PB Scrubber Data Inputs'!C11*'PB Scrubber Data Inputs'!C50","v":2271.36},"lb/hour-ft2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA31/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":5.7036209362316202E-2},null,{"$f":"ROUND(((AB31^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.127},0.16700000000000001,4.0000000000000008E-2,70.5,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z31","v":8896.16},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z31","v":0.53267903069125311}]
["Cross-sectional area based on minimum flow rate needed to wet the packed bed (A) =",null,{"$f":"Z38","v":60},"ft2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA32/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":5.7440721485453199E-2},null,{"$f":"ROUND(((AB32^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.125},0.16600000000000001,4.1000000000000009E-2,71,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z32","v":8959.253333333334},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z32","v":0.52892776991173729}]
["Adjusted liquid flow rate (Lmol, in) =",null,{"$f":"AA38","v":7571.2},"lb/sec-ft2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA33/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":5.7845233608590195E-2},null,{"$f":"ROUND(((AB33^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.123},0.16600000000000001,4.300000000000001E-2,71.5,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z33","v":9022.3466666666664},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z33","v":0.5252289743179489}]
["Adjusted superficial gas flow rate (Gsfr, in) =",null,{"$f":"AB38","v":0.62589786106222245},"lb/sec-ft2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA34/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":5.8249745731727191E-2},null,{"$f":"ROUND(((AB34^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.121},0.16600000000000001,4.5000000000000012E-2,72,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z34","v":9085.44},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z34","v":0.52158155088518532}]
["Diameter of the column (D) =","[4 x A)/π]0.5 =",{"$f":"((4*(C32))/PI())^0.5","v":8.7403874447366334},"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA35/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":5.8654257854864174E-2},null,{"$f":"ROUND(((AB35^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.12},0.16500000000000001,4.5000000000000012E-2,72.5,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z35","v":9148.5333333333328},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z35","v":0.51798443674114958}]
["Pollutant concentration exiting the absorber (Xout) = ","[(Yin - Yout)/(Ls/Gs)] + Xin =",{"$f":"((C6-C7)/C13)+C10","v":0.10666666666666667},"lb-moles pollutant/lb-moles solvent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA36/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":5.905876997800117E-2},null,{"$f":"ROUND(((AB36^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.11799999999999999},0.16500000000000001,4.7000000000000014E-2,73,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z36","v":9211.626666666667},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z36","v":0.51443659813333353}]
["Number of transfer units (Ntu) =","Ln[yin/yout] =",{"$f":"LN(C6/C7)","v":4.60517018598809},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AA37/'PB Scrubber Design Parameters'!$C$14)*('PB Scrubber Data Inputs'!$C$14/'PB Scrubber Data Inputs'!$C$13)*(('PB Scrubber Data Inputs'!$C$10/'PB Scrubber Data Inputs'!$C$11)^0.5)","v":5.9463282101138167E-2},null,{"$f":"ROUND(((AB37^2)*'PB Scrubber Data Inputs'!$C$44*'PB Scrubber Design Parameters'!$C$27*('PB Scrubber Data Inputs'!$C$16/2.42)^0.2)/('PB Scrubber Data Inputs'!$C$11*'PB Scrubber Data Inputs'!$C$10*32.2),3)","v":0.11600000000000001},0.16400000000000001,4.8000000000000001E-2,73.5,{"$f":"('PB Scrubber Design Parameters'!$C$31*(1/'PB Scrubber Data Inputs'!$C$14))*Z37","v":9274.7199999999993},{"$f":"(('PB Scrubber Design Parameters'!$C$14*'PB Scrubber Data Inputs'!$C$13)/(3600*'PB Scrubber Data Inputs'!$C$38))/Z37","v":0.51093702943854891}]
["Height of liquid transfer unit (HL) =","Φ x (Lsfr,in/μL)b x (μL/ρL x DL)0.5  =",{"$f":"'PB Scrubber Data Inputs'!C48*((C31/'PB Scrubber Data Inputs'!C16)^'PB Scrubber Data Inputs'!C49)*(('PB Scrubber Data Inputs'!C16/('PB Scrubber Data Inputs'!C11*'PB Scrubber Data Inputs'!C19))^0.5)","v":1.0642596499509598},"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min",{"$f":"MIN(Y2:Y37)","v":1.0000000000000009E-3},{"$f":"VLOOKUP(Y38,Y2:Z37,2,FALSE)","v":60},{"$f":"VLOOKUP(Y38,Y2:AB37,3,FALSE)","v":7571.2},{"$f":"VLOOKUP(Y38,Y2:AB37,4,FALSE)","v":0.62589786106222245}]
["Height of gas transfer unit (HG) = ","[α x (3,600 x f x Gsfr,in)β)/(Lsfr,in)γ] x (μG/ρG x DG)0.5",{"$f":"'PB Scrubber Data Inputs'!C45*(((3600*'PB Scrubber Data Inputs'!C38*C34)^'PB Scrubber Data Inputs'!C46)/('PB Scrubber Design Parameters'!C31^'PB Scrubber Data Inputs'!C47))*(('PB Scrubber Data Inputs'!C15/('PB Scrubber Data Inputs'!C10*'PB Scrubber Data Inputs'!C18))^0.5)","v":2.2341356345584864},"ft"]
["Height of transfer Unit (Htu) = ","HG + (1/AF) x HL ≈ HG ≈",{"$f":"C39","v":2.2341356345584864},"ft"]
["Depth of packing (Hpack) = ","Ntu x Htu = ",{"$f":"C37*C40","v":10.288574815722324},"ft"]
["Total height of absorber tower (Htower) =","(1.4 x Hpack) + (1.02 x D) + 2.81 = ",{"$f":"(1.4*C41)+(1.02*C35)+2.81","v":26.129199935642617},"ft"]
["Surface area of absorber tower (S) = ","π x D x (Htower + D/2) = ",{"$f":"PI()*C35*(C42+(C35/2))","v":837.47482868514737},"ft2"]
["Volume of packing (V) =","A x Hpack =",{"$f":"C32*C41","v":617.31448894333948},"ft3"]
["Solvent flow rate (Lin) =","(L sft,in)min x A x (1/8.34lb/gallon) x (1/60 minutes/hour) = ",{"$f":"C31*C32*(1/8.34)*(1/60)","v":272.34532374100718},"gpm"]
["Impeller diameter for fan (d) =","Provided by user",{"$f":"'PB Scrubber Data Inputs'!C40","v":33},"inches"]
["Pressure drop across packed bed (ΔP) =","[c x 10(j x Lsfr,in/3,600) x (f x Gsfr,in)2/ρG ] * Hpack = ",{"$f":"'PB Scrubber Data Inputs'!C51*10^(('PB Scrubber Data Inputs'!C52*'PB Scrubber Design Parameters'!C31)/3600)*((('PB Scrubber Data Inputs'!C38*'PB Scrubber Design Parameters'!C28)^2)/'PB Scrubber Data Inputs'!C10)*C41","v":10.093008432681787},"inches of water"]
["Pressure for the solvent pump (Ppump) =",null,{"$f":"'PB Scrubber Data Inputs'!C39","v":60},"ft of water",null,null,null,null,null,"FRP",1,{"$f":"IF('PB Scrubber Data Inputs'!S54=1,1,0)","v":1},{"$f":"K48*L48","v":1}]
["Total annual operating time for the scrubber (top) =",null,{"$f":"'PB Scrubber Data Inputs'!C34","v":8000},"hours",null,null,null,null,null,"304 Stainless Steel",1.75,{"$f":"IF('PB Scrubber Data Inputs'!S54=2,1,0)","v":0},{"$f":"K49*L49","v":0},{"$f":"SUM(M48:M51)","v":1}]
[{"$f":"'PB Scrubber Data Inputs'!C6&\" removed per year =\"","v":"HCl removed per year ="},"(Gmass,p x top )/2000 =",{"$f":"(C71*'PB Scrubber Data Inputs'!C34/2000)*'PB Scrubber Data Inputs'!C33/100","v":884.16317877378231},"tons/year",null,null,null,null,null,"Polyvinylchloride",0.9,{"$f":"IF('PB Scrubber Data Inputs'!S54=4,1,0)","v":0},{"$f":"K50*L50","v":0}]
["Scrubber material conversion factor (CF) =","CF = 1 for FRP; CF = 1.75 for 304 stainless steel; CF = 1.1 for polypropylene; and CF = 0.9 for polyvinylchloride",{"$f":"SUM(M48:M51)","v":1},null,null,null,null,null,null,"Polypropylene",1.1000000000000001,{"$f":"IF('PB Scrubber Data Inputs'!S54=3,1,0)","v":0},{"$f":"K51*L51","v":0}]
["Scaling Factor (SF) =",{"$f":"\"CEPCI for \"&'PB Scrubber Data Inputs'!C63&\"/390.6\"","v":"CEPCI for 2016/390.6"},{"$f":"'PB Scrubber Data Inputs'!C64/'PB Scrubber Data Inputs'!F64","v":1.3868407578084998},"dimensionless; 390.6 is the CEPCI for 1991"]
[]
["Capital Recovery Factor:"]
[]
["Parameter","Equation","Calculated Value"]
["Capital Recovery Factor (CRF) = ","i (1+ i)n/((1+ i)n - 1) =",{"$f":"ROUND((('PB Scrubber Data Inputs'!C67/100)*((1+'PB Scrubber Data Inputs'!C67/100)^'PB Scrubber Data Inputs'!C36))/(((1+'PB Scrubber Data Inputs'!C67/100)^'PB Scrubber Data Inputs'!C36)-1),4)","v":5.2699999999999997E-2}]
[null,"Where n = Equipment Life and i= Interest Rate"]
[]
["Parameter","Equation","Calculated Value","Units"]
["Electricity:"]
["Power to operate fan (Efan) =","[1.17x10-4 x G x ΔP]/ε =",{"$f":"(0.000117*'PB Scrubber Data Inputs'!C8*C47)/('PB Scrubber Data Inputs'!C35/100)","v":37.599282454100802},"kW"]
["Power to operate pump (Epump) = ","[(0.746) x (2.52 x 10-4) x L x P]/ε =",{"$f":"(0.746*0.000252*C45*C48)/('PB Scrubber Data Inputs'!C35/100)","v":4.3884636086330939},"kW"]
["Total Energy (Etotal) =","Efan + Epump =",{"$f":"SUM(C62:C63)","v":41.987746062733898},"kW"]
["Sorbent Usage:"]
["Molar flow rate in (Lmol,i) =","(Lsfr,in)min/MWL) x A =",{"$f":"(C31/'PB Scrubber Data Inputs'!C14)*C32","v":7571.2},"lb-moles/hour"]
["Mass flow rate of liquid (Lmass) = ","Lmol,in x MWL =",{"$f":"C66*'PB Scrubber Data Inputs'!C14","v":136281.60000000001},"lb/hour"]
["Flow rate of gas stream (Gmol,i) =","Gs x (1 + Yin) =",{"$f":"C16","v":3269.4190344827593},"lb-moles/hour"]
["Mass flow rate of gas stream (Gmass) =","Gmol,in x MWG =",{"$f":"C68*'PB Scrubber Data Inputs'!C13","v":94813.152000000016},"lb/hour"]
["Flow rate of pollutant (Gp) =","Gmol,in x C x ppmv/1x106 =",{"$f":"C68*'PB Scrubber Data Inputs'!C7/1000000","v":6.1170830135172425},{"$f":"\"lb-moles \"&'PB Scrubber Data Inputs'!C6&\"/hour\"","v":"lb-moles HCl/hour"}]
["Mass flow rate of pollutant (Gmass,p) =","Gp x MWp  = ",{"$f":"C70*'PB Scrubber Data Inputs'!C12","v":223.27352999337936},{"$f":"\"lbs \"&'PB Scrubber Data Inputs'!C6&\"/hour\"","v":"lbs HCl/hour"}]
["Sorbent consumption rate (Qsorbent) =",{"$f":"'PB Scrubber Data Inputs'!C27&\" moles of sorbent x Gmass,p x MWs x Pollutant Removal Efficiency/100 =\"","v":"0.5 moles of sorbent x Gmass,p x MWs x Pollutant Removal Efficiency/100 ="},{"$f":"'PB Scrubber Data Inputs'!C27*'PB Scrubber Design Parameters'!C70*'PB Scrubber Data Inputs'!C31*(C9/100)","v":121.02740498489067},"lbs/hour"]
["Waste Generation:"]
["Waste generation rate (qwaste) =","(Gmass,p/MWp) x MWw x (moles of waste/moles of pollutant) = ",{"$f":"(C71/'PB Scrubber Data Inputs'!C12)*'PB Scrubber Data Inputs'!C32*'PB Scrubber Data Inputs'!C29","v":357.84935629075869},{"$f":"\"lb \"&'PB Scrubber Data Inputs'!C28&\"/hour\"","v":"lb sodium chloride/hour"}]
["Wastewater flow rate (Qww) =","(qwaste/WF) x (1/8.34lb/gal) x (1hour/60 minutes) =",{"$f":"C74*(1/('PB Scrubber Data Inputs'!C30/100))*(1/8.34)*(1/60)","v":7.1512661129248345},"gpm"]
["Solvent Usage:"]
["Solvent consumption rate (Qsolvent) =                                                                          ","(qwaste/WF) x (1/8.34lb/gal) x (1hour/60 minutes) =",{"$f":"C74*(1/('PB Scrubber Data Inputs'!C30/100))*(1/8.34)*(1/60)","v":7.1512661129248345},"gpm"]

{"sheet":"PB Scrubber Cost Estimate","index":8,"n_rows":82,"n_cols":4,"rows_kept":82,"cut":false,"hidden":false,"merged":[[78,0,78,3],[79,2,79,3],[81,2,81,3],[47,0,47,3],[76,0,76,3],[73,2,73,3],[74,2,74,3],[49,0,49,3],[50,0,50,3],[61,0,61,3],[62,0,62,3],[70,0,70,3],[71,0,71,3],[72,2,72,3],[39,0,39,3],[26,0,26,2],[28,0,28,3],[18,0,18,1],[19,0,19,3],[13,0,13,3],[9,0,9,3],[12,0,12,1],[0,0,0,3],[2,0,2,3],[3,0,3,3]]}
["Packed Bed Scrubber Cost Estimate"]
[]
["Total Capital Investment (TCI)"]
["TCI = Direct Costs + Indirect Costs + Contingency Costs"]
["Total Direct Costs (DC) =","PEC + Total Direct Installation Costs =",{"$f":"C25+C38","v":371855.06335324899}]
["Total Indirect Costs (IC) = ",null,{"$f":"C46","v":64320.875823264694}]
["Contingency Costs = ","CF(DC + IC) =",{"$f":"'PB Scrubber Data Inputs'!C58*(C5+C6)","v":43617.593917651371}]
["Total Capital Investment (TCI) =",null,{"$f":"SUM(C5:C7)","v":479793.53309416509},{"$f":"\"in \"&'PB Scrubber Data Inputs'!C63& \" dollars\"","v":"in 2016 dollars"}]
[]
["Equipment Costs"]
["Tower Cost (TC) =","115 x S x CF x SF =",{"$f":"'PB Scrubber Design Parameters'!C51*115*'PB Scrubber Design Parameters'!C43*'PB Scrubber Design Parameters'!C52","v":133566.08599681413}]
["Packing Cost = ","V x Costpacking x SF = ",{"$f":"'PB Scrubber Design Parameters'!C44*'PB Scrubber Data Inputs'!C69*'PB Scrubber Design Parameters'!C52","v":17122.337873046956}]
["Where CF = material conversion factor; S = surface area of absorber; V = packing volume; and SF = Scaling factor"]
["Auxiliary Equipment Costs"]
["Pump Cost =","L x 16 x SF =",{"$f":"'PB Scrubber Design Parameters'!C45*16*'PB Scrubber Design Parameters'!C52","v":6043.1935226012738}]
["Fan Cost =","57.9(d)1.38 x SF =",{"$f":"57.9*('PB Scrubber Design Parameters'!C46^1.38)*'PB Scrubber Design Parameters'!C52","v":10005.85943245499}]
["Fan Motor Cost =","104(hpfan)0.821 x SF =",{"$f":"104*(('PB Scrubber Design Parameters'!C62/0.746)^0.821)*'PB Scrubber Design Parameters'!C52","v":3603.8256731353367}]
["Total Auxiliary Equipment Cost =",null,{"$f":"SUM(C15:C17)","v":19652.8786281916}]
["Where L = flow rate; d = diameter of impeller; hpfan = fan motor size; and SF = scaling factor"]
["Purchase Equipment Cost (PEC)"]
["Equipment Costs (EC)* =","TC + Packing Cost + Auxiliary Equipment =",{"$f":"SUM(C11:C17)","v":170341.30249805268}]
["Instrumentation Costs** = ","0.1 x EC =",{"$f":"0.1*C21","v":17034.130249805268}]
["Sales Tax = ","0.03 x EC =",{"$f":"0.03*C21","v":5110.2390749415799}]
["Freight =","0.05 x EC =",{"$f":"0.05*C21","v":8517.0651249026341}]
["Purchase Equipment Cost (B) =",null,{"$f":"SUM(C21:C24)","v":201002.73694770216},{"$f":"\"in \"&'PB Scrubber Data Inputs'!C63& \" dollars\"","v":"in 2016 dollars"}]
["* Includes the initial quantity of packing, as well as items normally not included with the unit supplied by vendors, such as ductwork, fan, piping, etc."]
["** Instrumentation costs cover pH monitor and liquid level indicator in sump."]
[]
["Total Direct Installation Costs"]
["Foundations & Supports = ","0.12 x B =",{"$f":"0.12*C25","v":24120.328433724259}]
["Handling & Erection = ","0.4 x B =",{"$f":"0.4*C25","v":80401.094779080871}]
["Electrical =","0.01 x B =",{"$f":"0.01*C25","v":2010.0273694770217}]
["Piping =","0.3 x B =",{"$f":"0.3*C25","v":60300.821084310643}]
["Insulation = ","0.01 x B =",{"$f":"0.01*C25","v":2010.0273694770217}]
["Painting =","0.01 x B =",{"$f":"0.01*C25","v":2010.0273694770217}]
["Site Preparation Cost (SP) =",null,{"$f":"'PB Scrubber Data Inputs'!C56","v":0}]
["Building Costs (Bldg) =",null,{"$f":"'PB Scrubber Data Inputs'!C57","v":0}]
["Total Direct Installation Costs =","(0.85 x B) + SP + Bldg =",{"$f":"(0.85*C25)+C36+C37","v":170852.32640554683},{"$f":"\"in \"&'PB Scrubber Data Inputs'!C63& \" dollars\"","v":"in 2016 dollars"}]
[]
["Total Indirect Capital Costs (Installation)"]
["Engineering =","0.1 x B =",{"$f":"0.1*C25","v":20100.273694770218}]
["Construction and field expenses =","0.1 x B =",{"$f":"0.1*C25","v":20100.273694770218}]
["Contractor fees =","0.1 x B =",{"$f":"0.1*C25","v":20100.273694770218}]
["Start-up =","0.01 x B =",{"$f":"0.01*C25","v":2010.0273694770217}]
["Performance test =","0.01 x B =",{"$f":"0.01*C25","v":2010.0273694770217}]
["Total Indirect Capital Costs (IC) =","0.32 x B =",{"$f":"0.32*C25","v":64320.875823264694},{"$f":"\"in \"&'PB Scrubber Data Inputs'!C63& \" dollars\"","v":"in 2016 dollars"}]
[]
["Annual Costs"]
[]
["Direct Annual Costs (DAC)"]
["DAC = Annual Operator Cost + Annual Reagent Cost + Annual Solvent Cost + Annual Waste Disposal Cost + Annual Maintenance Costs + Annual Auxiliary Power Cost"]
["Annual Operator Labor Cost =","0.5 hours per shift x Labor Rate = 0.5 hours x (top/8) x Labor Rate =",{"$f":"(0.5)*('PB Scrubber Data Inputs'!C34/8)*'PB Scrubber Data Inputs'!C74","v":13305}]
["Annual Supervisor Labor Cost =","0.15 x Annual Operator Labor Cost =",{"$f":"0.15*C52","v":1995.75}]
[{"$f":"\"Annual \"&'PB Scrubber Data Inputs'!C26&\" Cost =\"","v":"Annual Sodium hydroxide Cost ="},"Qsorbent x Costsorbent x top =",{"$f":"'PB Scrubber Design Parameters'!C72*'PB Scrubber Data Inputs'!C70*'PB Scrubber Data Inputs'!C34*(1/2000)","v":216397.0001129845}]
["Annual Solvent Cost =","qsolvent x CostSolvent x top =",{"$f":"'PB Scrubber Design Parameters'!C77*60*'PB Scrubber Data Inputs'!C34*('PB Scrubber Data Inputs'!C71)","v":14416.952483656467}]
["Annual Wastewater Disposal Cost  =","Qww x Costww x top =",{"$f":"'PB Scrubber Design Parameters'!C75*'PB Scrubber Data Inputs'!C34*60*'PB Scrubber Data Inputs'!C73","v":19565.864084962348}]
["Annual Maintenance Labor Cost = ","0.5 hours per shift x Labor Rate = 0.5 hours x (top/8) x Labor Rate =",{"$f":"(0.5)*('PB Scrubber Data Inputs'!C34/8)*'PB Scrubber Data Inputs'!C75","v":14635}]
["Annual Maintenance Materials Cost = ","100% x Annual Maintenance Labor Cost = ",{"$f":"C57","v":14635}]
["Annual Electricity Cost =","Etotal x Costelect x top = ",{"$f":"'PB Scrubber Design Parameters'!C64*'PB Scrubber Data Inputs'!C72*'PB Scrubber Design Parameters'!C49","v":22706.97307072649}]
["Direct Annual Cost = ",null,{"$f":"SUM(C52:C59)","v":317657.53975232982},{"$f":"\"in \"&'PB Scrubber Data Inputs'!C63& \" dollars\"","v":"in 2016 dollars"}]
[]
["Indirect Annual Cost (IAC)"]
["IAC = Overhead + Administrative Charges + Property Tax + Insurance + Capital Recovery Costs"]
["Overhead = ","0.6 x (Total Labor Costs + Material Cost) =",{"$f":"0.6*(C52+C53+C57+C58)","v":26742.45}]
["Administrative Charges =","0.02 x TCI = ",{"$f":"0.02*C8","v":9595.8706618833021}]
["Property Tax =","0.01 x TCI =",{"$f":"0.01*C8","v":4797.935330941651}]
["Insurance =","0.01 x TCI =",{"$f":"0.01*C8","v":4797.935330941651}]
["Capital Recovery Costs (CR)=","CRF x TCI =",{"$f":"'PB Scrubber Design Parameters'!C57*C8","v":25285.119194062499}]
["Indirect Annual Cost (IAC) =",null,{"$f":"SUM(C64:C68)","v":71219.310517829101},{"$f":"\"in \"&'PB Scrubber Data Inputs'!C63& \" dollars\"","v":"in 2016 dollars"}]
[]
["Total Annual Cost (TAC)"]
["TAC = Direct Annual Costs + Indirect Annual Costs"]
["Direct Annual Costs (DAC) =",{"$f":"C60","v":317657.53975232982}]
["Indirect Annual Costs (IAC) =",{"$f":"C69","v":71219.310517829101}]
["Total annual costs (TAC) = DAC + IAC",{"$f":"B73+B74","v":388876.8502701589},{"$f":"\"in \"&'PB Scrubber Data Inputs'!C63& \" dollars\"","v":"in 2016 dollars"}]
[]
["Cost Effectiveness"]
[]
[{"$f":"\"Cost Effectiveness = Total Annual Cost/ton of \"&'PB Scrubber Data Inputs'!C6&\" Removed/year\"","v":"Cost Effectiveness = Total Annual Cost/ton of HCl Removed/year"}]
["Total Annual Cost (TAC) =",{"$f":"B75","v":388876.8502701589},{"$f":"\"per year in \"&'PB Scrubber Data Inputs'!C63& \" dollars\"","v":"per year in 2016 dollars"}]
[{"$f":"'PB Scrubber Data Inputs'!C6&\" Removed = \"","v":"HCl Removed = "},{"$f":"'PB Scrubber Design Parameters'!C50","v":884.16317877378231},"tons/year"]
["Cost Effectiveness = ",{"$f":"B80/B81","v":439.8247513648779},{"$f":"\"per ton of \"&'PB Scrubber Data Inputs'!C6&\" removed in \"&'PB Scrubber Data Inputs'!C63&\" dollars\"","v":"per ton of HCl removed in 2016 dollars"}]

{"sheet":"Appendix","index":9,"n_rows":113,"n_cols":11,"rows_kept":113,"cut":false,"hidden":false,"merged":[[1,8,2,8],[1,9,2,9],[1,10,2,10],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,1,4],[51,5,51,6],[70,0,71,0],[70,1,71,1],[70,2,70,3],[1,7,2,7],[51,0,52,0],[51,1,52,1],[51,2,51,4]]}
["Typical Costs for Random Packing Materials (1991$)",null,null,null,null,null,null,"Physical Properties of Common Pollutants"]
["Nominal Diameter (inches)","Construction Material","Packing Type","Packing cost ($/ft3)",null,null,null,"Pollutant","Molecular Weight","Diffusivity in Air at 25°C (cm2/sec)","Diffusivity in Water at 20°C (cm2/sec x 105)"]
[null,null,null,"<100 ft3",">100 ft3"]
[1,"304 stainless steel","Pall rings, Raschig rings, Ballast rings","70-109","65-99",null,null,"Ammonia",17,0.23599999999999999,1.76]
[1,"Ceramic","Raschig rings, Berl saddles","33-44","26-36",null,null,"Methanol",32,0.159,1.28]
[1,"Polypropylene","Tri-PakÒ, Pall rings, Ballast rings, Flexisaddles ","14-37","1934-12-01",null,null,"Ethyl Alcohol",46,0.11899999999999999,1]
[2,"Ceramic","Berl saddles, Raschig rings","13-32","2021-10-30",null,null,"Propyl Alcohol",60,0.1,0.87]
[2,"Polypropylene","Tri-PacÒ, LanpacÒ, Flexiring, Flexisaddle TelleretteÒ ","2021-03-20","2021-05-19",null,null,"Butyl Alcohol",74,0.09,0.77]
[3.5,"304 stainless steel","Ballast rings",30,27,null,null,"Acetic Acid",60,0.13300000000000001,0.88]
[3.5,"Polypropylene","Tri-packÒ, LanpacÒ, Ballast rings","2021-06-14","2021-06-12",null,null,"Hydrogen Chloride",36,0.187,2.64]
[null,null,null,null,null,null,null,"Hydrogen Bromide",36,0.129,1.93]
["Typical Packing Factors for Various Packing Materials for Wet Packed Tower Absorbers",null,null,null,null,null,null,"Hydrogen Fluoride",20,0.753,3.33]
["Packing Type","Construction Level","Nominal Diameter (inches)","Fp","a"]
["Raschig rings","Ceramic",0.5,640,111]
[null,null,0.625,380,100]
[null,null,0.75,255,80]
[null,null,1,160,58]
[null,null,1.5,95,38]
[null,null,2,65,28]
[null,null,3,37]
["Raschig rings","Metal",0.5,410,118]
[null,null,0.625,290]
[null,null,0.75,230,72]
[null,null,1,137,57]
[null,null,1.5,83,41]
[null,null,2,57,31]
[null,null,3,32,21]
["Pall rings","Metal",0.625,70,131]
[null,null,1,48,66]
[null,null,1.5,28,48]
[null,null,2,20,36]
[null,null,3.5,16]
["Pall rings","Polypropylene",0.625,97,110]
[null,null,1,52,63]
[null,null,1.5,32,39]
[null,null,2,25,31]
["Berl saddles","Ceramic",0.5,240,142]
[null,null,0.75,170,82]
[null,null,1,110,76]
[null,null,1.5,65,44]
[null,null,2,45,32]
["Intalox saddles","Ceramic",0.5,200,190]
[null,null,0.75,145,102]
[null,null,1,98,78]
[null,null,1.5,52,60]
[null,null,2,40,36]
[null,null,3,22]
["Tri-Packs®","Plastic",2,16,48]
[null,null,3.5,12,38]
[]
["Packing Constants Used to Estimate HG For Wet Packed Tower Absorbers"]
["Packing Type","Size (inches)","Packing Constants",null,null,"Applicable Rangea"]
[null,null,"α","Β","γ","Gsfr","Lsfr"]
["Raschig Rings",0.625,2.3199999999999998,0.45,0.47,"200-500","500-1,500"]
[null,1,7,0.39,0.57999999999999996,"200-800","400-500"]
[null,1,6.41,0.32,0.51,"200-600","500-4,500"]
[null,1.5,1.73,0.38,0.66,"200-700","500-1,500"]
[null,1.5,2.58,0.38,0.4,"200-700","1,500-4,500"]
[null,2,3.82,0.41,0.45,"200-800","500-4,500"]
["Berl Saddles",0.5,32.4,0.3,0.74,"200-700","500-1,500"]
[null,0.5,0.81,0.3,0.24,"200-700","1,500-4,500"]
[null,1,1.97,0.36,0.4,"200-800","400-4,500"]
[null,1.5,5.05,0.32,0.45,"200-1,000","400-4,500"]
["Partition Rings",3,640,0.57999999999999996,1.06,"150-900","3,000-10,000"]
["LanPac®",2.2999999999999998,7.6,0.33,-0.48,"400-3,000","500-8,000"]
["Tri-Packs®",2,1.4,0.33,0.4,"100-900","500-10,000"]
[null,3.5,1.7,0.33,0.45,"100-2,000","500-10,000"]
["a Units of lb/hr-ft2"]
[]
["Packing Constants Used to Estimate HL For Wet Packed Tower Absorbers"]
["Packing Type","Size (inches)","Packing Constants",null,"Applicable Rangea"]
[null,null,"φ","b","Lasfr"]
["Raschig Rings",0.375,1.82E-3,0.46,"400-15,000"]
[null,1,3.5699999999999998E-3,0.35,"400-15,000"]
[null,1.5,0.01,0.22,"400-15,000"]
[null,2.5,1.11E-2,0.22,"400-15,000"]
[null,2,1.2500000000000001E-2,0.22,"400-15,000"]
["Berl Saddles",0.5,6.6600000000000001E-3,0.28000000000000003,"400-15,000"]
[null,1,5.8799999999999998E-3,0.28000000000000003,"400-15,000"]
[null,1.5,6.2500000000000003E-3,0.28000000000000003,"400-15,000"]
["Partition Rings",3,6.25E-2,0.09,"3,000-14,000"]
["LanPac®",2.2999999999999998,3.8999999999999998E-3,0.33,"500-8,000"]
[null,3.5,4.1999999999999997E-3,0.33,"500-8,000"]
["Tri-Packs®",2,3.0999999999999999E-3,0.33,"500-10,000"]
[null,3.5,4.0000000000000001E-3,0.33,"500-10,000"]
["a Units of lb/hr-ft2"]
[]
[]
["Packing Constants Used to Estimate Pressure Drop For Wet Packed Tower Absorbers"]
["Packing Type","Construction Material","Nominal Diameter (inches)","c","j"]
["Raschig rings","ceramic",0.5,3.1,0.41]
[null,null,0.75,1.34,0.26]
[null,null,1,0.97,0.25]
[null,null,1.25,0.56999999999999995,0.23]
[null,null,1.5,0.39,0.23]
[null,null,2,0.24,0.17]
["Raschig rings","metal",0.625,1.2,0.28000000000000003]
[null,null,1,0.42,0.21]
[null,null,1.5,0.28999999999999998,0.2]
[null,null,2,0.23,0.13500000000000001]
["Pall rings","metal",0.625,0.43,0.17]
[null,null,1,0.15,0.16]
[null,null,1.5,0.08,0.15]
[null,null,2,0.06,0.12]
["Berl saddles","ceramic",0.5,1.2,0.21]
[null,null,0.75,0.62,0.17]
[null,null,1,0.39,0.17]
[null,null,1.5,0.21,0.13]
["Intalox saddles","ceramic",0.5,0.82,0.2]
[null,null,0.75,0.28000000000000003,0.16]
[null,null,1,0.31,0.16]
[null,null,1.5,0.14000000000000001,0.14000000000000001]
["a Units of lb/hr-ft2"]