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

{"sheet":"Read Me","index":0,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[18,1,18,13],[19,1,19,13],[15,1,15,13],[16,1,16,13],[17,1,17,13],[0,0,0,14],[1,0,1,14],[2,0,2,14],[3,0,3,14],[4,0,4,14],[5,0,5,14],[6,0,6,14],[8,1,8,13],[10,1,10,13],[12,1,12,13]]}
["Air Pollution Control Cost Estimation Spreadsheet"]
["For Refrigerated Surface Condensers"]
["U.S. Environmental Protection Agency "]
["Air Economics Group"]
["Health and Environmental Impacts Division"]
["Office of Air Quality Planning and Standards"]
["(November 2017)"]
[]
[null,"This spreadsheet allows users to estimate the capital and annualized costs for installing and operating refrigerated surface condensers used to control emissions of volatile organic compounds (VOCs) and hazardous air pollutants (HAP) from industrial waste gas streams. Refrigerated condensers lower the temperature of the waste stream to the temperature at which the volatile components of a vapor mixture change from the gas to liquid phase. The basic equipment required for a refrigerated condenser system includes a condenser, a single or multi-stage refrigeration unit, and auxiliary equipment, such as pre-coolers, storage tanks for recovered condensate, blowers and piping. Pre-coolers are used where the waste stream contains a water vapor or a VOC that has a high freezing point. Refrigerated condensers are typically used to control waste streams with VOC concentrations above 5,000 ppmv. The condensate can be collected for reuse or sale. "]
[]
[null,"The calculation methodologies used in this spreadsheet are those presented in the U.S. EPA's Air Pollution Control Cost Manual.  This spreadsheet is intended to be used in combination with the Control Cost Manual. For a detailed description of the technology and cost methodology, see Section 3.1 (VOC Recapture Controls), Chapter 2 (Refrigerated Condensers) of the Air Pollution Control Cost Manual (as updated in 2017). Additional control technologies may be necessary for some industrial waste gas streams.  Costs for additional control technologies can be estimated using the methods provided in other chapters of the cost manual.  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,"The spreadsheet can be used to estimate capital and annualized costs for refrigerated surface condensers only. The methodology assumes a two-component mixture of VOC and air, where the emission stream is free of moisture. The methodology is designed to provide study-level cost estimates.  Actual costs, particularly those for installation, can deviate significantly from the costs generated using this spreadsheet due to site conditions. Units of measures in this spreadsheet are English.  "]
[]
[]
[null,"Instructions "]
[null,"Step 1: Please select the Data Inputs tab and click on the Reset Form button. This will reset the values on the Data Inputs tab.  "]
[null,"Step 2:  Use the drop down menu on the Data Inputs tab to select the condenser type from the drop-down list: packaged condenser, custom condenser, or gasoline vapor recovery system. "]
[null,"Step 3:  Complete all of the yellow data entry cells on the Data Inputs tab. Many of the fields are pre-populated with default values.  Where possible, replace default values provided with site-specific values in accordance with the recommendations provided in the Control Cost Manual. Use of actual values other than the default values in this spreadsheet is recommended; however, sources for all values used should be appropriately documented. The molecular weight, heat capacity, enthalpy of condensation, boiling point and Antonine constants for many commonly used VOCs are provided in Appendix A of Section 3.1 (VOC Recapture Controls), Chapter 2 (Refrigerated Condensers) of the Air Pollution Control Cost Manual (as updated in 2017)."]
[null,"Step 4: Once all of the data fields are complete, select the Design Parameters tab to see the calculated design parameters for your condenser. Select the Cost Estimate tab to view the estimated installation and operation costs for the condenser. "]

{"sheet":"Data Inputs","index":1,"n_rows":54,"n_cols":13,"rows_kept":54,"cut":false,"hidden":false,"merged":[[19,4,21,6],[52,2,52,3],[53,2,53,3],[50,4,50,8],[51,4,51,8],[52,4,52,8],[53,4,53,8],[49,4,49,8],[49,2,49,3],[44,0,45,5],[50,2,50,3],[51,2,51,3]]}
[null,null,"Data Inputs",null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,"Packaged Condenser System"]
["Is the condenser a packaged, custom or gasoline vapor recovery system?",null,null,null,null,null,null,null,null,null,null,null,"Custom Condenser System"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Gasoline Vapor Recovery System"]
["Enter the design data for the proposed condenser:"]
[]
["Number of operating hours per year and per day (Ɵs)",2080,"hours/year",8,"hours/day"]
["Volumetric flow rate of the waste stream (Qin)",100,{"$f":"\"scfm (at 77 °F; 1 atm)\"&(IF(B8=100,\"*\",\"\"))","v":"scfm (at 77 °F; 1 atm)*"},{"$f":"IF(B8=100,\"* 100 scfm is a default volumetric flow rate. User should enter actual value, if known.\",\" \")","v":"* 100 scfm is a default volumetric flow rate. User should enter actual value, if known."}]
["Inlet stream temperature (Tin)",86,{"$f":"\"°F\"&(IF(B9=86,\"*\",\"\"))","v":"°F*"},{"$f":"IF(B9=86,\"* 86 °F is a default inlet stream temperature. User should enter actual value, if known.\",\" \")","v":"* 86 °F is a default inlet stream temperature. User should enter actual value, if known."}]
["Required VOC removal efficiency (η)",90,{"$f":"\"%\"&(IF(B10=90, \"*\",\"\"))","v":"%*"},{"$f":"IF(B10=90,\"* 90% is a default control efficiency. User should enter actual value, if known.\",\" \")","v":"* 90% is a default control efficiency. User should enter actual value, if known."},null,null,null,null,null,null,null,null,{"$f":"B10/100","v":0.9}]
["Specific heat of the coolant (Cp,cool)",0.65,{"$f":"\"Btu/lb-mole-°F\"&IF(B11=0.65,\"*\",\"\")","v":"Btu/lb-mole-°F*"},{"$f":"IF(B11=0.65,\"* 0.65 Btu/lb-mole-°F is a default value. User should enter actual value, if known.\",\" \")","v":"* 0.65 Btu/lb-mole-°F is a default value. User should enter actual value, if known."}]
["Estimated equipment life (n)",15,{"$f":"\"Years\"&IF(B12=15,\"*\",\"\")","v":"Years*"},{"$f":"IF(B12=15,\"* 15 years is a default equipment life. User should enter actual value, if known.\",\" \")","v":"* 15 years is a default equipment life. User should enter actual value, if known."}]
["Overall heat transfer coefficient (U)",20,{"$f":"\"Btu/hour-ft²-°F\"&IF(B13=20,\"*\",\"\")","v":"Btu/hour-ft²-°F*"},{"$f":"IF(B13=20,\"* 20 Btu/hour-ft²-°F is a default heat transfer coefficient. User should enter actual value, if known.\",\" \")","v":"* 20 Btu/hour-ft²-°F is a default heat transfer coefficient. User should enter actual value, if known."}]
["Mechanical efficiency of compressor (ηcomp) ",85,{"$f":"\"%\"&IF(B14=85,\"*\",\"\")","v":"%*"},{"$f":"IF(B14=85,\"* 85% is a default value. User should enter actual value, if known.\",\" \")","v":"* 85% is a default value. User should enter actual value, if known."}]
[]
["Enter the Characteristics of the VOC/HAP:"]
[]
["Name of VOC/HAP","Benzene"]
[{"$f":"\"Molecular Weight of \"&B18 &\" (MW)\"","v":"Molecular Weight of Benzene (MW)"},78.11,"lb./mole",null,"Note:"]
[{"$f":"\"Density of \"&B18","v":"Density of Benzene"},7.31,"lb./gallon",null,"Values for several common compounds are included on the Table A (Physical Properties) and Table B (Antoine Constants) tabs. "]
[{"$f":"\"Heat Capacity of \"&B18&\" (Cp,voc)\"","v":"Heat Capacity of Benzene (Cp,voc)"},32.51,"Btu/lb.-mole-°F"]
[{"$f":"\"Heat of Condensation of \"&B18&\" (ΔHref)\"","v":"Heat of Condensation of Benzene (ΔHref)"},13210,"Btu/lb.-mole"]
[{"$f":"\"Boiling Point of \"&B18","v":"Boiling Point of Benzene"},176,"°F"]
[{"$f":"\"Antoine Equation Constants for \"&B18","v":"Antoine Equation Constants for Benzene"},"A","B","C"]
[null,6.9056499999999996,1211.0329999999999,220.79]
[{"$f":"\"Critical Temperature for \"&B18","v":"Critical Temperature for Benzene"},1012,"°R"]
[{"$f":"\"Volume Fraction of \"&B18&\" in waste stream entering the condenser (Yvoc,in)\"","v":"Volume Fraction of Benzene in waste stream entering the condenser (Yvoc,in)"},0.25]
[]
["Enter the cost data for the condenser:"]
[]
["Electricity (Costelect)",6.4100000000000004E-2,{"$f":"\"per kWh\"&IF(B31=0.0641, \"*\",\"\")","v":"per kWh*"},{"$f":"IF(B31=0.0641,\"* $0.0641/kWh is a default value. User should enter actual value, if known.\",\"\")","v":"* $0.0641/kWh is a default value. User should enter actual value, if known."}]
["Operator Labor Rate",26.61,{"$f":"\"per hour\"&IF(B32=26.61,\"*\",\"\")","v":"per hour*"},{"$f":"IF(B32=26.61,\"* $26.61/hour is a default value. User should enter actual value, if known.\",\"\")","v":"* $26.61/hour is a default value. User should enter actual value, if known."}]
["Maintenance Labor Rate",27.4,{"$f":"\"per hour\"&IF(B33=27.4,\"*\",\"\")","v":"per hour*"},{"$f":"IF(B33=27.4,\"* $27.40/hour is a default value. User should enter actual value, if known.\",\"\")","v":"* $27.40/hour is a default value. User should enter actual value, if known."}]
["Re-Sale Value of Recovered VOC (Credit)",0.28000000000000003,"per lb"]
["Contingency Factor (CF)",10,{"$f":"\"percent\"&IF(B35=10,\"*\",\"\")","v":"percent*"},{"$f":"IF(B35=10,\"* 10 percent is a default value. The contingency factor should be between 5 and 15 percent.\",\"\")","v":"* 10 percent is a default value. The contingency factor should be between 5 and 15 percent."}]
["If known, enter any additional costs for site preparation and building construction/modification:"]
["Site Preparation (SP) =",0,{"$f":"IF(B37=0, \"* Default value. User should enter actual value, if known.\",\" \")","v":"* Default value. User should enter actual value, if known."}]
["Buildings (Bldg) =",0,{"$f":"IF(B38=0, \"* Default value. User should enter actual value, if known.\",\" \")","v":"* Default value. User should enter actual value, if known."}]
["Equipment Costs for auxiliary equipment for custom condenser systems (ECaux) =",0,"* Default value. User should enter actual value, if known."]
[]
["Desired dollar-year ",2016]
[{"$f":"\"CEPCI* for \" & B41","v":"CEPCI* for 2016"},536.4,{"$f":"IF(B41=2014,\" \",\"Enter the CEPCI value for \"&B41)","v":"Enter the CEPCI value for 2016"},null,576.1,"2014 CEPCI"]
["Annual Interest Rate (i)",4.25,{"$f":"(IF(B43=4.25,\"% (Current back prime rate)\",\"% (Default value is 4.25%)\"))","v":"% (Current back prime rate)"}]
[]
["* CEPCI is the Chemical Engineering Plant Cost Index. The use of CEPCI in this spreadsheet is not an endorsement of the index for purpose of cost escalation or de-escalation, but is there merely to allow for availability of a well-known cost index to spreadsheet users. Use of other well-known cost indexes (e.g., M&S) is acceptable."]
[]
[]
["Data Sources for Default Values Used in Calculations: "]
[]
["Data Element","Default Value","Sources for Default Value",null,"If you used your own site-specific values, please reference  the source from which the site-specific value was derived. ",null,null,null,null,"Recommended data sources for site-specific information"]
["Electricity Cost ($/kWh)",6.4100000000000004E-2,"Average annual electricity cost for industrial plants is based on 2016 price data compiled by the U.S. Energy Information Administration from data reported on Form EIA-861 and 861S, (http://www.eia.gov/electricity/data.cfm#sales).  ",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. "]
["Operator Labor Rate ($/hour)",26.61,"Bureau of Labor Statistics, May 2016 National Occupational Employment and Wage Estimates – United States, May 2016 (https://www.bls.gov/oes/current/oes_nat.htm). Hourly rates for operators based on data for plant and System Operators – other (51-8099).",null," ",null,null,null,null,"Use payroll data, if available, or check current edition of the  Bureau of Labor Statistic's labor costs reports available from "]
["Maintenance Labor Rate ($/hour)",27.4,"Bureau of Labor Statistics, May 2015 National Occupational Employment and Wage Estimates – United States, May 2016 (https://www.bls.gov/oes/current/oes_nat.htm). Hourly rates for maintenance workers based on electrical and electronics commercial and industrial equipment repairers (49-2094).",null," ",null,null,null,null,"Check with fuel supplier or use  U.S. Energy Information Administration (EIA) data for most recent year.\" Available at http://www.eia.gov/electricity/data/eia923/."]
["Value of Recovered VOC ($/lb.)",null,null,null," ",null,null,null,null,"Check with reagent vendors for current prices. "]

{"sheet":"Design Parameters","index":2,"n_rows":55,"n_cols":6,"rows_kept":55,"cut":false,"hidden":false,"merged":[[41,0,42,0],[41,2,42,2],[41,3,42,3],[0,0,0,5],[2,0,2,5],[4,0,5,0],[4,1,5,1]]}
["Design Parameters"]
[]
["The following design parameters for the condenser were calculated based on the values entered on the Data Inputs tab. These values were used to prepare the costs shown on the Cost Estimate tab."]
[]
["VOC","VOC volume Fraction of waste stream entering the condenser (Yvoc,in) ","Heat Capacity (Cp,voc)","Heat of Condensation (ΔHref) "]
[null,null,"(Btu/lb.-mole-°F)","(Btu/lb.-mole)"]
[{"$f":"IF('Data Inputs'!B18=\"\", \"Not Applicable \", 'Data Inputs'!B18)","v":"Benzene"},{"$f":"'Data Inputs'!B27","v":0.25},{"$f":"'Data Inputs'!B21","v":32.51},{"$f":"'Data Inputs'!B22","v":13210}]
[]
["Parameter","Equation",null,"Calculated Value","Units"]
[{"$f":"\"Partial Pressure of \"&A7&\" VOC in Exit Stream (Pvoc) = \"","v":"Partial Pressure of Benzene VOC in Exit Stream (Pvoc) = "},"760 × (Mvoc,out / (Min - Mvoc, recovered)) =","760 × [Yvoc,in × (1 - η)] / [1 - (η × Yvoc,in)] =",{"$f":"760*((B7*(1-'Data Inputs'!$M$10))/(1-(B7*'Data Inputs'!$M$10)))","v":24.516129032258057},"mmHg"]
[{"$f":"\"Estimated Condensation Temperature for \"&A7&\" (Tcon) =  \"","v":"Estimated Condensation Temperature for Benzene (Tcon) =  "},"((B / (A - log (Pvoc))) - C) × 1.8 + 32 =",null,{"$f":"IF(B7>0, ((('Data Inputs'!C25)/('Data Inputs'!B25-LOG10($D10))-'Data Inputs'!D25)*1.8+32), 0)","v":29.752241364918383},"°F"]
[]
["Parameter","Equation","Calculated Value","Units","Calculated Value","Units"]
["Quantities of VOC in Inlet and Outlet streams:"]
["Moles of VOC in the inlet stream (Mvoc,in) = ","(Qin / 392) × (Yvoc,in) × 60 =",{"$f":"('Data Inputs'!B8/392)*(B7*60)","v":3.8265306122448979},"lb.-moles/hour"]
["Moles of VOC in the outlet stream (Mvoc,out) = ","Mvoc,in × (1 - η) =",{"$f":"C15*(1-'Data Inputs'!M10)","v":0.38265306122448972},"lb.-moles/hour"]
[]
["Quantity of VOC Recovered:"]
["Moles of VOC Recovered (Mvoc, recovered) =","Mvoc,in × η =",{"$f":"C15*'Data Inputs'!M10","v":3.443877551020408},"lb.-moles/hour"]
["Quantity of VOC Recovered (Wvoc) =","Mvoc, recovered × MWvoc =",{"$f":"C19*'Data Inputs'!B19","v":269.0012755102041},"lb./operating hour",{"$f":"(C20*'Data Inputs'!B7)/2000","v":279.76132653061222},"Tons/year"]
[]
["Estimated Storage Tank Capacity for Custom Condenser Systems:"]
["Storage Tank Volume (Vtank) =","(Wvoc / ρvoc) × Operating Hours Per Day =",{"$f":"(C20/'Data Inputs'!B20)*'Data Inputs'!D7","v":294.39264077724118},"gallons"]
[]
["Calculation of Enthalpy of Condensation: "]
["Critical Temperature for VOC (Tc) =",null,{"$f":"'Data Inputs'!B26","v":1012},"°R"]
["Reference Temperature for Heat of Condensation (T1) = ",null,{"$f":"'Data Inputs'!B23+459.67","v":635.67000000000007},"°R"]
["Condensation Temperature (T2) =","Tcon + 459.67 =",{"$f":"D11+459.67","v":489.42224136491842},"°R"]
[{"$f":"\"Enthalpy of condensation of VOC (ΔHvoc) at \"&ROUND(D11,1)&\" °F =\"","v":"Enthalpy of condensation of VOC (ΔHvoc) at 29.8 °F ="},"ΔHref × [(1 - T2 / Tc) / (1 - T1 / Tc)]0.38 =",{"$f":"D7*((1-C28/C26)/(1-C27/C26))^0.38","v":14965.251111181435},"Btu/lb.-mole"]
[]
["Calculation of Condenser Heat Load: "]
["Heat capacity of air (Cp, air) =",null,6.95,"Btu/lb.-mole-°F @ 77 °F and 1 atm."]
["Mean Temperature (Tmean) = ","(Tin + Tcon) / 2 =",{"$f":"('Data Inputs'!B9+'Design Parameters'!D11)/2","v":57.876120682459188},"°F"]
["Enthalpy change associated with the condensed VOC (ΔHcon) =","Mvoc,recovered × [ΔHvoc + Cp,voc (Tin - Tcon)]= ",{"$f":"C19*(C29+(C7*('Data Inputs'!B9-D11)))","v":57836.017232017126},"Btu/hour"]
["Enthalpy change associated with the uncondensed VOC (ΔHuncon) =","Mvoc,out × Cp,voc × (Tin - Tcon) =",{"$f":"C16*C7*('Data Inputs'!B9-D11)","v":699.72498720401904},"Btu/hour"]
["Enthalpy change associated with the non-condensable air (ΔHnoncon) =","[((Qin / 392) × 60) - Mvoc,in] × Cp,air × (Tin - Tcon) =",{"$f":"(('Data Inputs'!B8*60/392)-C15)*C32*('Data Inputs'!B9-D11)","v":4487.6241104902483},"Btu/hour"]
["Condenser Heat Load (Hload) = ","ΔHcon + ΔHuncon + ΔHnoncon =",{"$f":"C34+C35+C36","v":63023.366329711396},"Btu/hour"]
[]
["Calculation of Surface Area: "]
["Temperature of coolant entering the condenser (Tcool,in) =","Tcon - 15 °F =",{"$f":"D11-15","v":14.752241364918383},"°F"]
["Temperature of coolant exiting the condenser (Tcool,out) =","Tcool,in + 25 °F =",{"$f":"C40+25","v":39.752241364918383},"°F"]
["Logarithmic mean temperature difference (ΔTlm ) =","[(Tin - Tcool,out) - (Tcon -Tcool,in)]      ",{"$f":"(('Data Inputs'!B9-'Design Parameters'!C41)-(D11-C40))/(LN(('Data Inputs'!B9-C41)/(D11-'Design Parameters'!C40)))","v":27.752034651908826},"°F"]
[null,"[ln{(Tin - Tcool, out)/(Tcon - Tcool,in)}]"]
["Condenser Surface Area (Acon) = ","Hload / (U × ΔTlm) = ",{"$f":"C37/('Data Inputs'!B13*C42)","v":113.54728963156681},"ft²"]
[]
["Calculation of Coolant Flow Rate and Refrigeration Capacity: "]
["Coolant Flow Rate (Wcool) =","Hload / (Cp,cool × (Tcool,out - Tcool,in)) = ",{"$f":"C37/('Data Inputs'!B11*('Design Parameters'!C41-'Design Parameters'!C40))","v":3878.3610049053168},"lb./hour"]
["Refrigeration Capacity (R) =","Hload / 12,000 Btu/ton =",{"$f":"C37/12000","v":5.2519471941426161},"Tons/hour"]
[]
["Calculation of Electricity Consumption:"]
["Estimated Electricity Consumption (E) = ","2.7411 × exp(-0.015 × Tcon) = ",{"$f":"2.7411*EXP(-0.015*D11)","v":1.7543101087684561},"kW/ton"]
[]
["Capital Recovery Factor:"]
["Capital Recovery Factor (CRF) = ","[i × (1 + i)n] / [(1 + i)n - 1] =",{"$f":"(('Data Inputs'!B43/100)*(1+('Data Inputs'!B43/100))^'Data Inputs'!B12)/(((1+('Data Inputs'!B43/100))^'Data Inputs'!B12)-1)","v":9.1520425322923302E-2}]
[null,"Where n = Equipment Life and i = Interest Rate"]

{"sheet":"Cost Estimate","index":3,"n_rows":100,"n_cols":26,"rows_kept":100,"cut":false,"hidden":false,"merged":[[12,5,14,5],[3,2,8,3],[15,5,16,5],[65,0,65,1],[93,0,93,1],[59,0,59,1],[36,0,36,1]]}
[null,"Cost Estimate",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tcon =",{"$f":"'Design Parameters'!D11","v":29.752241364918383},"R =",{"$f":"'Design Parameters'!C48","v":5.2519471941426161}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single ",null,null,null,null,null,"Multi"]
[null,"Capital Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,"Temperature ",null,"R Min","R Max",null,null,"Temperature ",null,"R Min","R Max"]
[null,null,{"$f":"IF('Data Inputs'!L1=1,\"Warning!  You failed to select a condenser type. Please return to the Data Inputs tab and select a condenser type (packaged, custom or gasoline vapor recovery).\",\" \")","v":" "}]
[{"$f":"\"Estimated purchase costs for a \"&(IF('Data Inputs'!L1=2,\"packaged condenser\",IF('Data Inputs'!L1=3,\"custom condenser\",\"gasoline vapor recovery system\")&\"  with the following design specifications:\"))","v":"Estimated purchase costs for a gasoline vapor recovery system  with the following design specifications:"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,45,85,174,{"$f":"IF(AND($Q$1>P5,$Q$1<Q5,$S$1>R5,$S$1<S5),1,0)","v":0},null,-15,-5,3.5,81,{"$f":"IF(AND($Q$1>V5,$Q$1<W5,$S$1>X5,$S$1<Y5),1,0)","v":0}]
["VOC Controlled/Recovered =",{"$f":"'Data Inputs'!B18","v":"Benzene"},null,null,null,null,null,null,null,null,null,null,null,null,null,25,35,0.63,170,1,null,-25,-15,2.92,68,0]
["Refrigeration Capacity (R) =",{"$f":"ROUND('Design Parameters'!C48,2)&\" tons/hour\"","v":"5.25 tons/hour"},null,null,null,null,null,null,null,null,null,null,null,null,null,15,25,0.71,880,0,null,-35,-25,2.42,85,0]
["Condensation Temperature for Waste Stream  (Tcon) =",{"$f":"ROUND('Design Parameters'!D11,0)&\" °F\"","v":"30 °F"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,15,0.44,200,0,null,-45,-35,1.92,68,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-5,0,0.32,133,0,null,-55,-45,1.58,55,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-15,-5,0.21,6.6,0,null,-65,-55,1.25,100,0]
[{"$f":"\"Total Capital Investment (TCI) (in \"&'Data Inputs'!B41&\" dollars)\"","v":"Total Capital Investment (TCI) (in 2016 dollars)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,-25,-15,0.13,200,0,null,-75,-65,1.33,42,0]
["Parameter","Equation","Single Stage ","Multi-Stage","Gasoline Vapor Recovery System",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-85,-75,1.08,150,0]
["Equipment Costs for Single Stage Refrigeration Unit:",null,null,null,null,{"$f":"IF('Data Inputs'!L1=1,\" \",(IF(Q1<-25,\"* A single stage condenser is not appropriate where the Tcon is below -25 °F.\",IF(T13=0,\"*Estimated equipment cost for the single stage condenser (Ecr) may not be accurate. Values of R and Tcon are outside the applicability range for the ECr cost equation.\",\" \"))))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,"IF value is 1, then ECR equation is applicable",{"$f":"SUM(T5:T11)","v":1},null,-95,-85,0.83,28,0]
[{"$f":"\"ECr\"&(IF(OR(Q1>45, (AND('Cost Estimate'!T13=0,Q1>-25, Q1<45))),\"*\",\" \"))&\" =\"","v":"ECr  ="},{"$f":"IF('Design Parameters'!C48<10,\"1.611 × exp[9.83 - 0.014 × Tcon + 0.34 × ln(R)] × [\"&'Data Inputs'!B41&\" CEPCI / 2014 CEPCI] =\", \"1.611 × exp[9.26 - 0.007 × Tcon + 0.627 × ln(R)] × [\"&'Data Inputs'!B41&\" CEPCI / 2014 CEPCI] =\")","v":"1.611 × exp[9.83 - 0.014 × Tcon + 0.34 × ln(R)] × [2016 CEPCI / 2014 CEPCI] ="},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11>-30,(IF('Design Parameters'!C48<10,(1.611*EXP(9.83-(0.014*'Design Parameters'!D11)+0.34*LN('Design Parameters'!C48)))*('Data Inputs'!B42/'Data Inputs'!E42),(1.611*EXP(9.26-(0.007*'Design Parameters'!D11)+0.627*LN('Design Parameters'!C48)))*('Data Inputs'!B42/'Data Inputs'!E42))),\"Not applicable*\")))","v":"Not applicable"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-105,-95,0.67,22,0]
[]
["Equipment Costs for Multistage Refrigeration Unit:",null,null,null,null,{"$f":"IF(AND('Data Inputs'!L1=1,'Data Inputs'!L1=4),\" \",(IF(Q1>-5,\"* A multi-stage condenser is not necessary where Tcon is above -5 °F.\",(IF(Z17=0,\"*Estimated equipment cost for the multi-stage condenser, ECr, may not be accurate. Values of R and Tcon are outside the applicability range for the ECr cost equation.\",\" \")))))","v":"* A multi-stage condenser is not necessary where Tcon is above -5 °F."}]
[{"$f":"\"ECr\"&IF(OR(Q1<-105, (AND('Cost Estimate'!Z17=0,Q1<-5, Q1>-105))),\"*\",\" \")&\" =\"","v":"ECr  ="},{"$f":"\"1.611 × exp[9.73 - 0.012 × Tcon + 0.58 × ln(R)] × [\"&'Data Inputs'!B41&\" CEPCI / 2014 CEPCI] =\"","v":"1.611 × exp[9.73 - 0.012 × Tcon + 0.58 × ln(R)] × [2016 CEPCI / 2014 CEPCI] ="},null,{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\", (IF('Design Parameters'!D11<-10,(1.611*EXP(9.73-(0.012*'Design Parameters'!D11)+(0.58*LN('Design Parameters'!C48))))*('Data Inputs'!B42/'Data Inputs'!E42),\"Not applicable*\")))","v":"Not applicable"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IF value is 1, then ECR equation is applicable",{"$f":"SUM(Z5:Z14)","v":0}]
["Other Equipment Costs for a Packaged Solvent Recovery System:"]
["ECp =","0.25 × ECr =",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF(AND('Design Parameters'!D11>-30,'Data Inputs'!L1=2),(0.25*C14),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\", (IF('Design Parameters'!D11<-10,(0.25*D17),\"Not applicable\")))","v":"Not applicable"}]
["Purchase Costs for a Packaged Gasoline Solvent Recovery System:"]
["ECp =",{"$f":"\"1.611 × (4,910 × R + 341,000) × (\"&'Data Inputs'!B41&\" CEPCI / 2014 CEPCI) =\"","v":"1.611 × (4,910 × R + 341,000) × (2016 CEPCI / 2014 CEPCI) ="},null,null,{"$f":"IF('Data Inputs'!L1=4,(1.611*((4910*'Design Parameters'!C48)+341000))*('Data Inputs'!B42/'Data Inputs'!E42), \"Not applicable\")","v":550174.47902830259}]
[]
["Purchase Costs for a Custom Condenser (ECcon) =",{"$f":"\"1.611 × (34 × Acon + 3,775) x [\"&'Data Inputs'!B41&\" CEPCI / 2014 CEPCI] =\"","v":"1.611 × (34 × Acon + 3,775) x [2016 CEPCI / 2014 CEPCI] ="},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2, 'Data Inputs'!L1=4),\"Not applicable\", IF('Design Parameters'!D11>-30,(1.611*((34*'Design Parameters'!C44)+3775))*('Data Inputs'!B42/'Data Inputs'!E42),\"Not applicable\"))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2, 'Data Inputs'!L1=4),\"Not applicable\",IF('Design Parameters'!D11<-10,(1.611*((34*'Design Parameters'!C44)+3775))*('Data Inputs'!B42/'Data Inputs'!E42),\"Not applicable\"))","v":"Not applicable"}]
[]
[]
["Purchase Costs for Storage Tanks for a Custom Condenser (ECtank) =",{"$f":"\"1.611 × (2.72 × Vtank + 1,960) × [\"&'Data Inputs'!B41&\" CEPCI / 2014 CEPCI] =\"","v":"1.611 × (2.72 × Vtank + 1,960) × [2016 CEPCI / 2014 CEPCI] ="},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2, 'Data Inputs'!L1=4),\"Not applicable\",IF('Design Parameters'!D11>-30,(1.611*((2.72*'Design Parameters'!C23)+1960))*('Data Inputs'!B42/'Data Inputs'!E42),\"Not applicable\"))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\", IF('Design Parameters'!D11<-10,(1.611*((2.72*'Design Parameters'!C23)+1960))*('Data Inputs'!B42/'Data Inputs'!E42),\"Not applicable\"))","v":"Not applicable"}]
["Purchase Costs for Pre-Cooler for Custom Condenser (ECpre) =",{"$f":"IF('Design Parameters'!C48<10,\"1.611 × exp[9.83 - 0.014 × Tcon + 0.34 × ln(R)] × [\"&'Data Inputs'!B41&\" CEPCI / 2014 CEPCI] =\", \"1.611 × exp[9.26 - 0.007 × Tcon + 0.627 × ln(R)] × [\"&'Data Inputs'!B41&\" CEPCI / 2014 CEPCI] =\")","v":"1.611 × exp[9.83 - 0.014 × Tcon + 0.34 × ln(R)] × [2016 CEPCI / 2014 CEPCI] ="},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\",IF('Design Parameters'!D11>-30,(IF('Design Parameters'!C48<10,(1.611*EXP(9.83-(0.014*'Design Parameters'!D11)+0.34*LN('Design Parameters'!C48)))*('Data Inputs'!B42/'Data Inputs'!E42),(1.611*EXP(9.26-(0.007*'Design Parameters'!D11)+0.627*LN('Design Parameters'!C48)))*('Data Inputs'!B42/'Data Inputs'!E42))),\"Not applicable\"))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2, 'Data Inputs'!L1=4),\"Not applicable\", IF('Design Parameters'!D11<-10,(IF('Design Parameters'!C48<10,(1.611*EXP(9.83-(0.014*'Design Parameters'!D11)+0.34*LN('Design Parameters'!C48)))*('Data Inputs'!B42/'Data Inputs'!E42),(1.611*EXP(9.26-(0.007*'Design Parameters'!D11)+0.627*LN('Design Parameters'!C48)))*('Data Inputs'!B42/'Data Inputs'!E42))),\"Not applicable\"))","v":"Not applicable"}]
["Total Costs for Custom Condenser (A) =","ECr + ECcon + ECtank +ECpre + ECaux =",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\", IF('Design Parameters'!D11>-30,(C14+C23+C26+C27+'Data Inputs'!B39),\"Not applicable\"))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\",IF('Design Parameters'!D11<-10,(D17+D23+D26+D27+'Data Inputs'!B39),\"Not applicable\"))","v":"Not applicable"}]
[]
[]
["Costs for Refrigerated Condenser (A) =",{"$f":"IF('Data Inputs'!L1=2,\"ECp + ECr =\", (IF('Data Inputs'!L1=4, \"ECp =\", \" \")))","v":"ECp ="},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11>-30, (IF('Data Inputs'!L1=2,(C14+C19), C28)),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",IF('Design Parameters'!D11<-10,(IF('Data Inputs'!L1=2, (D17+D19), D28)),\"Not applicable\"))","v":"Not applicable"},{"$f":"IF('Data Inputs'!L1=4,'Cost Estimate'!E21, \"Not applicable\")","v":550174.47902830259}]
[]
["Instrumentation =","0.10 × A =",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",IF(AND('Design Parameters'!D11>-30,'Data Inputs'!L1=3),(0.1*C31),\"Included in A\"))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",IF(AND('Design Parameters'!D11<-10,'Data Inputs'!L1=3),(0.1*D31),\"Included in A\"))","v":"Not applicable"},{"$f":"IF('Data Inputs'!L1=4, \"Included in A\",\"Not applicable\")","v":"Included in A"}]
["Sales taxes =","0.03 × A =",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\", (IF('Design Parameters'!D11>-30,(0.03*C31),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",IF('Design Parameters'!D11<-10,(0.03*D31),\"Not applicable\"))","v":"Not applicable"},{"$f":"IF('Data Inputs'!L1=4, 0.03*E31,\"Not applicable\")","v":16505.234370849077}]
["Freight =","0.05 × A =",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\", (IF('Design Parameters'!D11>-30,(0.05*C31),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",IF('Design Parameters'!D11<-10,(0.05*D31),\"Not applicable\"))","v":"Not applicable"},{"$f":"IF('Data Inputs'!L1=4,0.05*E31,\"Not applicable\")","v":27508.72395141513}]
[]
["Total Purchased Equipment Costs (B) = ",null,{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11>-30,(IF('Data Inputs'!L1=3,SUM(C31:C35),(C31+C34+C35))),\"Not applicable \")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11<-10,(IF('Data Inputs'!L1=3,SUM(D31:D35),(D31+D34+D35))),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF('Data Inputs'!L1=4, E31+E34+E35, \"Not applicable\")","v":594188.43735056685}]
[]
[{"$f":"\"Direct Installation Costs (in \"&'Data Inputs'!B41&\" dollars)\"","v":"Direct Installation Costs (in 2016 dollars)"}]
["Parameter","Equation","Single Stage ","Multi-Stage","Gasoline Vapor Recovery System"]
["Foundations and Supports =","0.14 × B =",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11>-30,(0.14*C$37),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\",IF('Design Parameters'!D11<-10,(0.14*D$37),\"Not applicable\"))","v":"Not applicable"},"Not applicable"]
["Handling and Erection =","0.08 × B =",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\", (IF('Design Parameters'!D11>-30,(0.08*C$37),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11<-10,(0.08*D$37),\"Not applicable\")))","v":"Not applicable"},"Not applicable"]
["Electrical =","0.08 × B =",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\", (IF('Design Parameters'!D11>-30,(0.08*C$37),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\",IF('Design Parameters'!D11<-10,(0.08*D$37),\"Not applicable\"))","v":"Not applicable"},"Not applicable"]
["Piping =","0.02 × B =",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4), \"Not applicable\",(IF('Design Parameters'!D11>-30,(0.02*C$37),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\",IF('Design Parameters'!D11<-10,(0.02*D$37),\"Not applicable\"))","v":"Not applicable"},"Not applicable"]
["Insulation =","0.10 × B =",{"$f":"IF(OR('Data Inputs'!L1=1, 'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11>-30,(0.1*C$37),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1, 'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\",IF('Design Parameters'!D11<-10,(0.1*D$37),\"Not applicable\"))","v":"Not applicable"},"Not applicable"]
["Painting =","0.01 × B =",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\", (IF('Design Parameters'!D11>-30,(0.01*C$37),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\",IF('Design Parameters'!D11<-10,(0.01*D$37), \"Not applicable\"))","v":"Not applicable"},"Not applicable"]
["Site Preparation (SP) =",null,{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\", (IF('Design Parameters'!D11>-30,('Data Inputs'!B37),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",IF('Design Parameters'!D11<-10,('Data Inputs'!B37),\"Not applicable\"))","v":"Not applicable"},{"$f":"IF('Data Inputs'!L1=4,('Data Inputs'!D37),\"Not applicable\")","v":0}]
["Buildings (Bldg) =",null,{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\", (IF('Design Parameters'!D11>-30,('Data Inputs'!B38),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",IF('Design Parameters'!D11<-10,('Data Inputs'!B38),\"Not applicable\"))","v":"Not applicable"},{"$f":"IF('Data Inputs'!L1=4,('Data Inputs'!D38),\"Not applicable\")","v":0}]
[]
[null,"Total Direct Costs (DC) =  B + (0.43 × B) + SP + Bldg = ",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\", (IF('Design Parameters'!D11>-30,(SUM(C41:C48)+C37),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\",IF('Design Parameters'!D11<-10,(SUM(D41:D48)+D37),\"Not applicable\"))","v":"Not applicable"},"Not applicable"]
[]
[{"$f":"\"Total Indirect Installation Costs (in \"&'Data Inputs'!B41&\" dollars)\"","v":"Total Indirect Installation Costs (in 2016 dollars)"}]
["Parameter","Equation","Single Stage ","Multi-Stage","Gasoline Vapor Recovery System"]
["Engineering = ","0.10 × B =",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\", (IF('Design Parameters'!D11>-30,(0.1*C$37),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\",IF('Design Parameters'!D11<-10,(0.1*D$37),\"Not applicable\"))","v":"Not applicable"},"Not applicable"]
["Construction and field expenses = ","0.05 × B =",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\", (IF('Design Parameters'!D11>-30,(0.05*C$37),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\",IF('Design Parameters'!D11<-10,(0.05*D$37),\"Not applicable\"))","v":"Not applicable"},"Not applicable"]
["Contractor fees =","0.10 × B =",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\", (IF('Design Parameters'!D11>-30,(0.1*C$37),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\",IF('Design Parameters'!D11<-10,(0.1*D$37),\"Not applicable\"))","v":"Not applicable"},"Not applicable"]
["Start-up =","0.02 × B =",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\", (IF('Design Parameters'!D11>-30,(0.02*C$37),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\",IF('Design Parameters'!D11<-10,(0.02*D$37),\"Not applicable\"))","v":"Not applicable"},"Not applicable"]
["Performance test =","0.01 × B =",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\", (IF('Design Parameters'!D11>-30,(0.01*C$37),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\",IF('Design Parameters'!D11<-10, (0.01*D$37),\"Not applicable\"))","v":"Not applicable"},"Not applicable"]
[]
["Total Indirect Costs (IC) =",null,{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\", (IF('Design Parameters'!D11>-30,(SUM(C54:C58)),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\",IF('Design Parameters'!D11<-10,(SUM(D54:D58)),\"Not applicable\"))","v":"Not applicable"},"Not applicable"]
["Continency Cost (C ) =","CF(IC+DC)=",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\", (IF('Design Parameters'!D11>-30,((C50+C60)*('Data Inputs'!B35/100)),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=2,'Data Inputs'!L1=4),\"Not applicable\",IF('Design Parameters'!D12<-10,((D60+D50)*('Data Inputs'!B35/100)),\"Not applicable\"))","v":"Not applicable"},"Not applicable"]
["Total Capital Investment For Custom System =","DC + IC + C = (1.74 × B) + SP + Bldg. + C =",{"$f":"IF('Design Parameters'!D11>-30,(IF('Data Inputs'!L1=3,C50+C60+C61, 0)),\"Not applicable\")","v":0},{"$f":"IF('Design Parameters'!D11<-10,(IF('Data Inputs'!L1=3,D50+D60+D61, 0)),\"Not applicable\")","v":"Not applicable"},"Not applicable",{"$f":"\"in \"&'Data Inputs'!$B$41&\" dollars\"","v":"in 2016 dollars"}]
[]
["Total Capital Investment For Packaged System=","Direct Ccsts + Indirect Costs + Contingency = (1.15 × B)  =",{"$f":"IF('Data Inputs'!L1=4,\"Not applicable\", (IF('Design Parameters'!D11>-30,(IF('Data Inputs'!L1=2, (1.15*C37), 0)),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11<-10,(IF('Data Inputs'!L1=2, (1.15*D37), 0)),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF('Data Inputs'!L1=4,(1.15*E37),\"Not Applicable\")","v":683316.70295315178},{"$f":"\"in \"&'Data Inputs'!$B$41&\" dollars\"","v":"in 2016 dollars"}]
[]
["Annual Costs"]
[]
["Direct Annual Costs"]
["Parameter","Equation","Single Stage ","Multi-Stage","Gasoline Vapor Recovery System"]
["Annual Electricity Cost =","(R / ηComp) × E × Ɵs  × pe =",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\", (IF('Design Parameters'!D11>-30,(('Design Parameters'!$C$48/('Data Inputs'!$B$14/100))*'Design Parameters'!$C$51*'Data Inputs'!$B$7*'Data Inputs'!$B$31),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11<-10,(('Design Parameters'!$C$48/('Data Inputs'!$B$14/100))*'Design Parameters'!$C$51*'Data Inputs'!$B$7*'Data Inputs'!$B$31),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF('Data Inputs'!L1=4,('Design Parameters'!$C$48/('Data Inputs'!$B$14/100))*'Design Parameters'!$C$51*'Data Inputs'!$B$7*'Data Inputs'!$B$31,\"Not applicable\")","v":1445.2040018259427}]
["Operating Labor =","Operator = 0.5 hours/shift × Labor Rate × (Operating hours/8 hours/shift)",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11>-30,(0.5*'Data Inputs'!B32*'Data Inputs'!B7/8),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11<-10,(0.5*'Data Inputs'!B32*'Data Inputs'!B7/8),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF('Data Inputs'!L1=4,(0.5*'Data Inputs'!B32*'Data Inputs'!B7/8),\"Not applicable\")","v":3459.2999999999997}]
[null,"Supervisor = 15% of Operator",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11>-30,(0.15*C71),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11<-10,(0.15*D71),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF('Data Inputs'!L1=4,(0.15*E71),\"Not applicable\")","v":518.89499999999998}]
["Maintenance Costs =","Labor = 0.5 hours/shift × Labor Rate × (Operating Hours/8 hours/shift)",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11>-30,(0.5*'Data Inputs'!B33*'Data Inputs'!B7/8),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11<-10,(0.5*'Data Inputs'!B33*'Data Inputs'!B7/8),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF('Data Inputs'!L1=4,(0.5*'Data Inputs'!B33*'Data Inputs'!B7/8),\"Not applicable\")","v":3562}]
[null,"Materials = 100% of maintenance labor",{"$f":"C73","v":"Not applicable"},{"$f":"D73","v":"Not applicable"},{"$f":"E73","v":3562}]
[]
["Direct Annual Costs (DAC) =",null,{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\", (IF('Design Parameters'!D11>-30,(SUM(C70:C74)),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11<-10,(SUM(D70:D74)),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF('Data Inputs'!L1=4,SUM(E70:E74),\"Not applicable\")","v":12547.399001825943},{"$f":"\"in \"&'Data Inputs'!$B$41&\" dollars\"","v":"in 2016 dollars"}]
[]
["Indirect Annual Costs"]
["Parameter","Equation","Single Stage ","Multi-Stage","Gasoline Vapor Recovery System"]
["Overhead","= 60% of sum of operator, supervisor, maintenance labor Plus maintenance materials",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11>-30,(0.6*(C71+C72+C73+C74)),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11<-10,(0.6*(D71+D72+D73+D74)),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF('Data Inputs'!L1=4,(0.6*(E71+E72+E73+E74)),\"Not applicable\")","v":6661.317}]
["Administrative Charges","= 2% of TCI",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\", (IF('Design Parameters'!D11>-30,(0.02*(C62+C64)),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\", (IF('Design Parameters'!D11<-10, (0.02*(D62+D64)),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF('Data Inputs'!L1=4,(0.02*E64),\"Not applicable\")","v":13666.334059063036}]
["Property Taxes","= 1% of TCI",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11>-30,(0.01*(C62+C64)),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11<-10,(0.01*(D62+D64)),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF('Data Inputs'!L1=4,(0.01*E64),\"Not applicable\")","v":6833.167029531518}]
["Insurance","= 1% of TCI",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11>-30,(0.01*(C62+C64)),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11<-10,(0.01*(D62+D64)),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF('Data Inputs'!L1=4,(0.01*E64),\"Not applicable\")","v":6833.167029531518}]
["Capital Recovery","= CRF × TCI",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\", (IF('Design Parameters'!D11>-30,('Design Parameters'!$C$54*(C62+C64)),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11<-10,('Design Parameters'!$C$54*(D62+D64)),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF('Data Inputs'!L1=4,('Design Parameters'!$C$54*E64),\"Not applicable\")","v":62537.435284530089}]
[]
["Indirect Annual Costs (IAC) =",null,{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11>-30,(SUM(C80:C84)),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",IF('Design Parameters'!D11<-10,(SUM(D80:D84)),\"Not applicable\"))","v":"Not applicable"},{"$f":"IF('Data Inputs'!L1=4,SUM(E80:E84),\"Not applicable\")","v":96531.420402656164},{"$f":"\"in \"&'Data Inputs'!$B$41&\" dollars\"","v":"in 2016 dollars"}]
[]
[" VOC Recovery Credit"]
["Parameter","Equation","Single Stage ","Multi-Stage","Gasoline Vapor Recovery System"]
["Annual Recovery Credit for Condensate (RC)","= Wvoc × Credit × Ɵs =",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11>-30,('Design Parameters'!C20*'Data Inputs'!B34*'Data Inputs'!B7),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11<-10,('Design Parameters'!C20*'Data Inputs'!B34*'Data Inputs'!B7),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF('Data Inputs'!L1=4,('Design Parameters'!C20*'Data Inputs'!B34*'Data Inputs'!B7),\"Not applicable\")","v":156666.34285714288}]
[]
["Total Annual Cost  (TAC) =","DAC + IAC - RC =",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\", (IF('Design Parameters'!D11>-30,(C86+C76-C90),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\", IF('Design Parameters'!D11<-10,(D86+D76-D90),\"Not applicable\"))","v":"Not applicable"},{"$f":"IF('Data Inputs'!L1=4,(E86+E76-E90),\"Not applicable\")","v":-47587.523452660767},{"$f":"\"in \"&'Data Inputs'!$B$41&\" dollars\"","v":"in 2016 dollars"}]
[]
["Cost Effectiveness"]
[]
["Cost Effectiveness "]
["Parameter","Equation","Single Stage ","Multi-Stage","Gasoline Vapor Recovery System"]
["Total Annual Cost =","TAC =",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",C92)","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",D92)","v":"Not applicable"},{"$f":"IF('Data Inputs'!L1=4,E92, \"Not applicable\")","v":-47587.523452660767},{"$f":"\"per year in \"&'Data Inputs'!B41& \" dollars\"","v":"per year in 2016 dollars"}]
["Annual Quantity of VOC Removed/Recovered =","Wvoc =",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11>-30,('Design Parameters'!E20),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",IF('Design Parameters'!D11<-10,('Design Parameters'!E20),\"Not applicable\"))","v":"Not applicable"},{"$f":"IF('Data Inputs'!L1=4,('Design Parameters'!E20),\"Not applicable\")","v":279.76132653061222},"tons/year"]
["Cost Effectiveness = ","Total Annual Cost/Annual Quantity of VOC Removed/Recovered =",{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\",(IF('Design Parameters'!D11>-30,(C98/C99),\"Not applicable\")))","v":"Not applicable"},{"$f":"IF(OR('Data Inputs'!L1=1,'Data Inputs'!L1=4),\"Not applicable\", IF('Design Parameters'!D11<-10,(D98/D99),\"Not applicable\"))","v":"Not applicable"},{"$f":"IF('Data Inputs'!L1=4,(E98/E99),\"Not applicable\")","v":-170.10043540615544},{"$f":"\"per ton of pollutants removed/recovered in \"&'Data Inputs'!B41& \" dollars\"","v":"per ton of pollutants removed/recovered in 2016 dollars"}]

{"sheet":"Table A","index":4,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,6],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,4,4,4],[3,6,4,6]]}
["Table A: Physical Properties for Selected Compounds"]
[]
[]
["Compound","Critical Temp.a (°R)","Boiling Point (°F)","Molecular Weight","Heat of Condensationb (Btu/lb-mole)","Heat Capacityc","State"]
[null,null,null,"(lb/lb-mole)",null,"(Btu/lb-mole-°F)"]
["Acetone",915,134,58.08,12520,30.19,"Liquid"]
[null,null,null,null,null,17.809999999999999,"Gas"]
["Acetylene",555,-119,26.02,7310,10.54,"Gas"]
["Acrylonitrile",965,171,53.06,14030,15.25,"Gas"]
["Aniline",1258,364,93.13,18240,45.87,"Liquid"]
[null,null,null,null,null,25.79,"Gas"]
["Benzene",1012,176,78.11,13210,32.51,"Liquid"]
["Benzonitrile",1259,"375 d",103.12,19750,26.08,"Gas"]
["Butane",765,31,58.12,9640,23.31,"Gas"]
["Chloroethane",829,54,64.52,10630,14.96,"Gas"]
["Chloroform",966,143,119.39,12560,15.71,"Gas"]
["Chloromethane",749,-12,50.49,9210,9.75,"Gas"]
["Cyclobutane",828,55,56.1,10410,17.260000000000002,"Gas"]
["Cyclohexane",996,177,84.16,12910,37.03,"Liquid"]
[null,null,null,null,null,25.41,"Gas"]
["Cyclopentane",921,121,70.13,11750,30.81,"Liquid"]
[null,null,null,null,null,19.84,"Gas"]
["Cyclopropane",716,-27,42.08,8650,13.29,"Gas"]
["Diethyl ether",840,94,74.12,11400,41.26,"Liquid"]
[null,null,null,null,null,28.57,"Gas"]
["Dimethylamine",787,44,45.09,11360,16.899999999999999,"Gas"]
["Ethylbenzene",1111,277,106.17,15320,"30.69 d","Gas"]
["Ethylene oxide",844,51,44.05,10970,11.45,"Gas"]
["Heptane",972,209,100.12,13680,53.76,"Liquid"]
[null,null,null,null,null,39.68,"Gas"]
["Hexane",914,156,86.18,12440,46.76,"Liquid"]
[null,null,null,null,null,34.21,"Gas"]
["Methanol",923,148,32.04,15150,19.41,"Liquid"]
[null,null,null,null,null,10.54,"Gas"]
["Octane",1024,258,114.23,14800,45.16,"Gas"]
["Pentane","845 d",97,72.150000000000006,11100,28.73,"Gas"]
["Toluene",1065,231,92.14,14290,37.53,"Liquid"]
[null,null,null,null,null,24.76,"Gas"]
["o - Xylene",1135,292,106.17,15880,44.49,"Liquid"]
[null,null,null,null,null,31.86,"Gas"]
["m - Xylene",1111,282,106.17,15360,43.82,"Liquid"]
[null,null,null,null,null,30.5,"Gas"]
["p - Xylene",1109,281,106.17,15.36,30.33,"Gas"]
[]
[" a Reprinted with permission from the 16th edition of Lange's Handbook of Chemistry, Table 2.55 (Speight, 2005)."]
["b Reprinted with permission from the 16th edition of Lange's Handbook of Chemistry, Table 2.54 (Speight, 2005). (Measured at boiling point)."]
["c Reprinted with permission from the 16th edition of Lange's Handbook of Chemistry, Table 2.53 (Speight, 2005). (Measured at 77 °F)."]
["d These values are taken from the 14th edition of Lange's Handbook of Chemistry (Dean, 1992)."]

{"sheet":"Table B","index":5,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,1,2,3],[2,4,3,4],[0,0,0,4]]}
["Table B: Antoine Equation Constants for Selected Compoundsa"]
[]
["Compound","Antoine Equation Constants",null,null,"Valid Temperature Range (°F)"]
[null,"A","B","C"]
["Acetone",7.11714,1210.595,229.66399999999999,"Liquid"]
["Acetylene",9.1402000000000001,1232.5999999999999,280.89999999999998,"-202 to -117"]
[null,7.0998999999999999,711,253.4,"-116 to -98"]
["Acrylonitrile",7.0385499999999999,1232.53,222.47,"-4 to 284"]
["Aniline",7.3201000000000001,1731.5150000000001,206.04900000000001,"216 to 365"]
["Benzene",9.1064000000000007,1885.9,244.2,"10 to 37"]
[null,6.9056499999999996,1211.0329999999999,220.79,"46 to 217"]
["Benzonitrile",6.7463100000000003,1436.72,181,"Liquid"]
["n-Butane",6.80898,935.86,238.73,"-107 to 66"]
["Chloroethane",6.9864699999999997,1030.01,238.61,"-69 to 54"]
["Chloroethylene",6.8911699999999998,905.01,239.48,"-85 to 9"]
["Chloroform",6.4934000000000003,929.44,196.03,"-31 to 142"]
["Chloromethane",7.0934900000000001,948.58,249.34,"-103 to 23"]
["Cyanic acid",7.5685900000000004,1251.8599999999999,243.79,"-105 to 21"]
["Cyclobutane",6.9163100000000002,1054.54,241.37,"-76 to 54"]
["Cyclohexane",6.8413000000000004,1201.53,222.65,"68 to 178"]
["Cyclopentane",6.8867599999999998,1124.162,231.36,"-40 to 162"]
["Cyclopropane",6.88788,856.01,246.5,"-130 to -26"]
["Diethyl ether",6.9203200000000002,1064.07,228.8,"-78 to 68"]
["Diethylamine",5.8015999999999996,583.29999999999995,144.1,"88 to 142"]
["Dimethylamine",7.0821199999999997,960.24199999999996,221.67,"-98 to 44"]
["1,4-Dioxane",7.4315800000000003,1554.68,240.34,"68 to 221"]
["Ethylbenzene",6.9571899999999998,1424.2550000000001,213.21,"79 to 327"]
["Ethylene oxide",7.1284299999999998,1054.54,237.76,"-56 to 54"]
["Heptane",6.8967700000000001,1264.9000000000001,216.54,"28 to 255"]
["Hexane",6.87601,1171.17,224.41,"-13 to 198"]
["Methanol",7.8975,1474.08,229.13,"7 to 149"]
[null,7.9732799999999999,1515.14,232.85,"147 to 230"]
["Octane",6.9186800000000002,1351.99,209.15,"66 to 306"]
["Pentane",6.8529600000000004,1064.8399999999999,233.01,"-58 to 136"]
["Toluene",6.9546400000000004,1344.8,219.48,"43 to 279"]
["Vinyl acetate",7.2100999999999997,1296.1300000000001,226.66,"72 to 162"]
["o-Xylene",6.9989100000000004,1474.6790000000001,213.69,"90 to 342"]
["m-Xylene",7.00908,1462.2660000000001,215.11,"82 to 331"]
["p-Xylene",6.9905200000000001,1453.43,215.31,"81 to 331"]
["a Reprinted with permission from the 16th edition of Lange's Handbook of Chemistry, Table 2.36 (Speight, 2005)."]
["                     "]