{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["Welcome","Aggregate","Electricity Use","Fuel Use","Water Use","Water Pollution","Haz Inputs & Wastes","Air Emissions","Non-Haz Inputs","Glossary","Conversion Factors","References & Justification","State Air Emission","St.AirEm.Variables&Assumptions","Water Charges","Average HW Cost","Incineration","Landfill","State Elec. Prices & Premiums","Implicit GDP Price Deflators","Drop down lists"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":58,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Welcome","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[[6,1,6,2],[0,1,0,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]]}
[null,"EPA Cost Savings Calculator for Pollution Prevention Projects "]
[]
[null,"Purpose.  The purpose of this Calculator is threefold: (1) to help EPA P2 Program grantees make a calculation of annual net cost savings for an individual P2 action; (2) to provide thorough coverage of categories of P2 actions and their multimedia impacts for cost-saving calculations; and, (3) to track and aggregate entries for reading in the Aggregate Tab. The annual net-cost savings being calculated here are on an implementation-forward basis only and do not consider the cost of implementation. Grantees can, if desired, use this calculator to estimate prospective annual cost savings and, if helpful, cross-check dollar savings entered in grant reporting templates. The scope of data-entry categories is displayed in the colored tabs below. The general public is welcome to use this calculator."]
[null,"Functionality. The calculator uses available, documented unit costs in its formulas. Documented unit costs at the state or national-average level are used in the formulas for fuel, energy, and water purchases and for the fees associated with wastewater pre-treatment/treatment, hazardous waste shipping/treatment, and permitted air releases. Cost savings appear as a positive dollar value in the \"Cost Savings\" column. When a substitute costs more than the original, as green electricity typically does, the higher cost appears as a negative dollar value in the \"Cost Savings\" column. This negative cost savings is an increase in costs. The Conversion Factor and Reference Tabs may be of interest to some users.\n\nBasic calculations. For quick cost-saving calculations, a user can select a tab for an action type -- electricity use, fuel use, water use, water pollution, hazardous inputs and wastes, air emissions, or non-hazardous inputs -- and choose an activity metric in a row to see the savings calculated in the Cost Savings column. In most cases, users can enter more up-to-date unit costs in place of the default value. For a recordkeeping approach, a user can start on the Aggregate Tab and replace \"Row 1,\" \"Row 2,\" and so on with short descriptions (such as P2 actions) to populate those row descriptions in the other action tabs. "]
[null,"Aggregation. The Aggregate Tab displays total net cost savings per action-category tab and per row (captioned or not). "]
[null,"Using the Calculator in support of EPA Grant Reporting. Grantees are encouraged to use this Calculator to report P2 implementation cost savings to EPA. This Calculator plays a supportive role for grant reporting. If you are reporting to EPA and using this calculator, you would use a three-step process: (1) enter descriptions of P2 activities implemented in EPA's reporting templates or something equivalent; (2) use this calculator as needed for calculating annual net cost savings per activity implemented; and, (3) record the annual net cost savings in your EPA reporting template or equivalent format.This Calculator does not provide fields for entering the facility data, recommendations, or implemented actions that are required for P2 Program grant reporting. The examples provided on action tabs include a P2 activity description to portray a real scenario, but there is nowhere to enter a P2 activity description in this Calculator."]
[]
[]
[null,"Throughout this calculator, the following color key is used."]
[null,"Color Key"]
[null,"Enter value"]
[null,"Use drop-down menu"]
[null,"Do not change - calculation"]

{"sheet":"Aggregate","index":1,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,1,3,6],[0,1,0,9],[1,1,1,6],[2,1,2,6],[2,7,2,9]]}
[null,"Aggregated P2 Cost Savings by Category and Row"]
[null,"This tab acts as a parent tab for this calculator by aggregating the cost savings from each tab, by category and by row."]
[]
["How to use this tab","Use this tab as a read-only tab for aggregate cost-saving values and as an entry tab for labeling rows. To label a row, enter a caption of your choice in the first column. This step will populate the caption for that row in all action tabs. Continue labeling rows as desired. To get more rows, click the \"Click to add row\" button here or on any tab and a row will be added to all tabs"]
[null,"Electricity Use","Fuel Use","Water Use","Water Pollution","Hazardous Inputs","Hazardous Waste","Air Emissions","Non-Hazardous Inputs","Total by Row"]
[null,"cost savings ($)","cost savings ($)","cost savings ($)","cost savings ($)","cost savings ($)","cost savings ($)","cost savings ($)","cost savings ($)","cost savings ($)"]
["Aggregate (all rows)",{"$f":"SUM(B9:B19)","v":0},{"$f":"SUM(C9:C19)","v":0},{"$f":"SUM(H9:H19)","v":0},{"$f":"SUM(D19:D19)","v":0},{"$f":"SUM(E19:E19)","v":0},{"$f":"SUM(F9:F19)","v":0},{"$f":"SUM(G9:G19)","v":0},{"$f":"SUM(I19:I19)","v":0},{"$f":"SUM(J9:J19)","v":0}]
[]
["Row 1",{"$f":"IF(ISERROR('Electricity Use'!E14+'Electricity Use'!H14), 0, 'Electricity Use'!E14+'Electricity Use'!H14)","v":0},{"$f":"'Fuel Use'!F14+'Fuel Use'!I14+'Fuel Use'!L14+'Fuel Use'!O14+'Fuel Use'!R14+'Fuel Use'!U14+'Fuel Use'!X14+'Fuel Use'!AA14+'Fuel Use'!AD14","v":0},{"$f":"'Water Use'!D12","v":0},{"$f":"SUM('Water Pollution'!AI12)","v":0},{"$f":"'Haz Inputs & Wastes'!E14","v":0},{"$f":"'Haz Inputs & Wastes'!I14+'Haz Inputs & Wastes'!M14+'Haz Inputs & Wastes'!Q14","v":0},{"$f":"SUM('Air Emissions'!F13,'Air Emissions'!D13,'Air Emissions'!G13 )","v":0},{"$f":"'Non-Haz Inputs'!E12","v":0},{"$f":"SUM(B9:I9)","v":0}]
["Row 2",{"$f":"IF(ISERROR('Electricity Use'!E15+'Electricity Use'!H15), 0, 'Electricity Use'!E15+'Electricity Use'!H15)","v":0},{"$f":"'Fuel Use'!F15+'Fuel Use'!I15+'Fuel Use'!L15+'Fuel Use'!O15+'Fuel Use'!R15+'Fuel Use'!U15+'Fuel Use'!X15+'Fuel Use'!AA15+'Fuel Use'!AD15","v":0},{"$f":"'Water Use'!D13","v":0},{"$f":"SUM('Water Pollution'!AI13)","v":0},{"$f":"'Haz Inputs & Wastes'!E15","v":0},{"$f":"'Haz Inputs & Wastes'!I15+'Haz Inputs & Wastes'!M15+'Haz Inputs & Wastes'!Q15","v":0},{"$f":"SUM('Air Emissions'!F14,'Air Emissions'!D14,'Air Emissions'!G14 )","v":0},{"$f":"'Non-Haz Inputs'!E13","v":0},0]
["Row 3",{"$f":"IF(ISERROR('Electricity Use'!E16+'Electricity Use'!H16), 0, 'Electricity Use'!E16+'Electricity Use'!H16)","v":0},{"$f":"'Fuel Use'!F16+'Fuel Use'!I16+'Fuel Use'!L16+'Fuel Use'!O16+'Fuel Use'!R16+'Fuel Use'!U16+'Fuel Use'!X16+'Fuel Use'!AA16+'Fuel Use'!AD16","v":0},{"$f":"'Water Use'!D14","v":0},{"$f":"SUM('Water Pollution'!AI14)","v":0},{"$f":"'Haz Inputs & Wastes'!E16","v":0},{"$f":"'Haz Inputs & Wastes'!I16+'Haz Inputs & Wastes'!M16+'Haz Inputs & Wastes'!Q16","v":0},{"$f":"SUM('Air Emissions'!F15,'Air Emissions'!D15,'Air Emissions'!G15 )","v":0},{"$f":"'Non-Haz Inputs'!E14","v":0},0]
["Row 4",{"$f":"IF(ISERROR('Electricity Use'!E17+'Electricity Use'!H17), 0, 'Electricity Use'!E17+'Electricity Use'!H17)","v":0},{"$f":"'Fuel Use'!F17+'Fuel Use'!I17+'Fuel Use'!L17+'Fuel Use'!O17+'Fuel Use'!R17+'Fuel Use'!U17+'Fuel Use'!X17+'Fuel Use'!AA17+'Fuel Use'!AD17","v":0},{"$f":"'Water Use'!D15","v":0},{"$f":"SUM('Water Pollution'!AI15)","v":0},{"$f":"'Haz Inputs & Wastes'!E17","v":0},{"$f":"'Haz Inputs & Wastes'!I17+'Haz Inputs & Wastes'!M17+'Haz Inputs & Wastes'!Q17","v":0},{"$f":"SUM('Air Emissions'!F16,'Air Emissions'!D16,'Air Emissions'!G16 )","v":0},{"$f":"'Non-Haz Inputs'!E15","v":0},0]
["Row 5",{"$f":"IF(ISERROR('Electricity Use'!E18+'Electricity Use'!H18), 0, 'Electricity Use'!E18+'Electricity Use'!H18)","v":0},{"$f":"'Fuel Use'!F18+'Fuel Use'!I18+'Fuel Use'!L18+'Fuel Use'!O18+'Fuel Use'!R18+'Fuel Use'!U18+'Fuel Use'!X18+'Fuel Use'!AA18+'Fuel Use'!AD18","v":0},{"$f":"'Water Use'!D16","v":0},{"$f":"SUM('Water Pollution'!AI16)","v":0},{"$f":"'Haz Inputs & Wastes'!E18","v":0},{"$f":"'Haz Inputs & Wastes'!I18+'Haz Inputs & Wastes'!M18+'Haz Inputs & Wastes'!Q18","v":0},{"$f":"SUM('Air Emissions'!F17,'Air Emissions'!D17,'Air Emissions'!G17 )","v":0},{"$f":"'Non-Haz Inputs'!E16","v":0},0]
["Row 6",{"$f":"IF(ISERROR('Electricity Use'!E19+'Electricity Use'!H19), 0, 'Electricity Use'!E19+'Electricity Use'!H19)","v":0},{"$f":"'Fuel Use'!F19+'Fuel Use'!I19+'Fuel Use'!L19+'Fuel Use'!O19+'Fuel Use'!R19+'Fuel Use'!U19+'Fuel Use'!X19+'Fuel Use'!AA19+'Fuel Use'!AD19","v":0},{"$f":"'Water Use'!D17","v":0},{"$f":"SUM('Water Pollution'!AI17)","v":0},{"$f":"'Haz Inputs & Wastes'!E19","v":0},{"$f":"'Haz Inputs & Wastes'!I19+'Haz Inputs & Wastes'!M19+'Haz Inputs & Wastes'!Q19","v":0},{"$f":"SUM('Air Emissions'!F18,'Air Emissions'!D18,'Air Emissions'!G18 )","v":0},{"$f":"'Non-Haz Inputs'!E17","v":0},0]
["Row 7",{"$f":"IF(ISERROR('Electricity Use'!E20+'Electricity Use'!H20), 0, 'Electricity Use'!E20+'Electricity Use'!H20)","v":0},{"$f":"'Fuel Use'!F20+'Fuel Use'!I20+'Fuel Use'!L20+'Fuel Use'!O20+'Fuel Use'!R20+'Fuel Use'!U20+'Fuel Use'!X20+'Fuel Use'!AA20+'Fuel Use'!AD20","v":0},{"$f":"'Water Use'!D18","v":0},{"$f":"SUM('Water Pollution'!AI18)","v":0},{"$f":"'Haz Inputs & Wastes'!E20","v":0},{"$f":"'Haz Inputs & Wastes'!I20+'Haz Inputs & Wastes'!M20+'Haz Inputs & Wastes'!Q20","v":0},{"$f":"SUM('Air Emissions'!F19,'Air Emissions'!D19,'Air Emissions'!G19 )","v":0},{"$f":"'Non-Haz Inputs'!E18","v":0},0]
["Row 8",{"$f":"IF(ISERROR('Electricity Use'!E21+'Electricity Use'!H21), 0, 'Electricity Use'!E21+'Electricity Use'!H21)","v":0},{"$f":"'Fuel Use'!F21+'Fuel Use'!I21+'Fuel Use'!L21+'Fuel Use'!O21+'Fuel Use'!R21+'Fuel Use'!U21+'Fuel Use'!X21+'Fuel Use'!AA21+'Fuel Use'!AD21","v":0},{"$f":"'Water Use'!D19","v":0},{"$f":"SUM('Water Pollution'!AI19)","v":0},{"$f":"'Haz Inputs & Wastes'!E21","v":0},{"$f":"'Haz Inputs & Wastes'!I21+'Haz Inputs & Wastes'!M21+'Haz Inputs & Wastes'!Q21","v":0},{"$f":"SUM('Air Emissions'!F20,'Air Emissions'!D20,'Air Emissions'!G20 )","v":0},{"$f":"'Non-Haz Inputs'!E19","v":0},0]
["Row 9",{"$f":"IF(ISERROR('Electricity Use'!E22+'Electricity Use'!H22), 0, 'Electricity Use'!E22+'Electricity Use'!H22)","v":0},{"$f":"'Fuel Use'!F22+'Fuel Use'!I22+'Fuel Use'!L22+'Fuel Use'!O22+'Fuel Use'!R22+'Fuel Use'!U22+'Fuel Use'!X22+'Fuel Use'!AA22+'Fuel Use'!AD22","v":0},{"$f":"'Water Use'!D20","v":0},{"$f":"SUM('Water Pollution'!AI20)","v":0},{"$f":"'Haz Inputs & Wastes'!E22","v":0},{"$f":"'Haz Inputs & Wastes'!I22+'Haz Inputs & Wastes'!M22+'Haz Inputs & Wastes'!Q22","v":0},{"$f":"SUM('Air Emissions'!F21,'Air Emissions'!D21,'Air Emissions'!G21 )","v":0},{"$f":"'Non-Haz Inputs'!E20","v":0},0]
["Row 10",{"$f":"IF(ISERROR('Electricity Use'!E23+'Electricity Use'!H23), 0, 'Electricity Use'!E23+'Electricity Use'!H23)","v":0},{"$f":"'Fuel Use'!F23+'Fuel Use'!I23+'Fuel Use'!L23+'Fuel Use'!O23+'Fuel Use'!R23+'Fuel Use'!U23+'Fuel Use'!X23+'Fuel Use'!AA23+'Fuel Use'!AD23","v":0},{"$f":"'Water Use'!D21","v":0},{"$f":"SUM('Water Pollution'!AI21)","v":0},{"$f":"'Haz Inputs & Wastes'!E23","v":0},{"$f":"'Haz Inputs & Wastes'!I23+'Haz Inputs & Wastes'!M23+'Haz Inputs & Wastes'!Q23","v":0},{"$f":"SUM('Air Emissions'!F22,'Air Emissions'!D22,'Air Emissions'!G22 )","v":0},{"$f":"'Non-Haz Inputs'!E21","v":0},0]
["Row 11",{"$f":"IF(ISERROR('Electricity Use'!E24+'Electricity Use'!H24), 0, 'Electricity Use'!E24+'Electricity Use'!H24)","v":0},{"$f":"'Fuel Use'!F24+'Fuel Use'!I24+'Fuel Use'!L24+'Fuel Use'!O24+'Fuel Use'!R24+'Fuel Use'!U24+'Fuel Use'!X24+'Fuel Use'!AA24+'Fuel Use'!AD24","v":0},{"$f":"'Water Use'!D22","v":0},{"$f":"SUM('Water Pollution'!AI22)","v":0},{"$f":"'Haz Inputs & Wastes'!E24","v":0},{"$f":"'Haz Inputs & Wastes'!I24+'Haz Inputs & Wastes'!M24+'Haz Inputs & Wastes'!Q24","v":0},{"$f":"SUM('Air Emissions'!F23,'Air Emissions'!D23,'Air Emissions'!G23 )","v":0},{"$f":"'Non-Haz Inputs'!E22","v":0},0]

{"sheet":"Electricity Use","index":2,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[9,5,9,7],[1,1,1,6],[3,5,3,7],[4,5,4,7],[5,5,5,7],[3,2,3,4],[4,2,4,4],[5,2,5,4],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[0,0,2,0],[31,1,31,3],[32,1,32,3],[9,0,10,0],[9,2,9,4],[12,2,12,3]]}
[null,"Electricity Use"]
[null,"This tab computes the cost savings from conserving conventional electricity. It also computes the net dollars spent buying green electricity, which are shown as negative cost savings. Thus, ($100) is an extra $100 spent to switch from conventional to green electricity. The Aggregate tab will show the net cost savings (positive or negative) calculated on this tab."]
[]
["Type of Activity",null,"Conserving Conventional Electricity",null,null,"Purchasing Green Electricity "]
["\n\nHow to use this tab",null,"Enter the kWh of electricity conserved. Enter the unit cost or leave blank and select your state or \"U.S. National\" to use an average default value. ",null,null,"This computes the cost trade-offs between green electricity and conventional electricity. Enter the kWh of green electricity purchased. For unit cost, enter the unit cost difference between the default unit cost offered by your utility (or your previous electricity unit cost) and the unit cost of your green electricity. Note, if the unit cost of green electricity is higher than the default unit cost, then the difference will be a negative value. If your green electricity was supplied by unbundled renewable energy certificates (RECs),  then the negative value of the unit cost ($/kWh) you paid should be entered as the unit cost difference. If you don't know the unit cost difference, leave the \"Unit Cost Difference\" field blank and a default value will be used."]
["Calculation Description",null,"Quantity of electricity reduced (kWh) * unit cost (user-specified or default) = Dollar savings.",null,null,"Quantity of electricity purchased (kWh) * unit cost differential (user-specified or default) = Dollars savings."]
["Default Unit Cost",null,0.1017,null,null,-1.8599999999999998E-2]
[]
[null,"State or U.S. (select)","Electricity Conserved Quantity (kWh)","Unit Cost ($/kWh)","Dollar Savings","Green Electricity Quantity (kWh)","Unit Cost Difference ($/kWh)","Dollar Savings"]
["Example",null,"Installed energy-efficient lighting and reduced lighting and air conditioning usage at two commercial buildings. ",null,null,"A facility switched their electricity supply from their utility's default product to a green power product sourced from 100% wind. Their electricity rate increased by $0.0186 per kWh. They use approximately 500,000 kWh of electricity per year."]
[null,"NC",200000,null,{"$f":"IFERROR(IF(C11=\"\",\"-\",IF(D11=\"\",C11*VLOOKUP(B11,'State Elec. Prices & Premiums'!$B$4:$D$55,3,FALSE),C11*D11)),\"-\")","v":17380},500000,-1.8599999999999998E-2,{"$f":"IF(F11=\"\",\"-\",IF(G11=\"\",F11*-0.0186,F11*G11))","v":-9300}]
["Totals - All Rows",null,null,null,{"$f":"SUM(E14:E24)","v":0},null,null,{"$f":"SUM(H14:H24)","v":0}]
[]
[{"$f":"Aggregate!A9","v":"Row 1"},"(select)",null,null,{"$f":"IFERROR(IF(C14=\"\",0,IF(D14=\"\",C14*VLOOKUP(B14,'State Elec. Prices & Premiums'!$B$4:$D$55,3,FALSE),C14*D14)),0)","v":0},null,null,{"$f":"IF(F14=\"\",\"-\",IF(G14=\"\",F14*-0.0186,F14*G14))","v":"-"}]
[{"$f":"Aggregate!A10","v":"Row 2"},"(select)",null,null,{"$f":"IFERROR(IF(C15=\"\",0,IF(D15=\"\",C15*VLOOKUP(B15,'State Elec. Prices & Premiums'!$B$4:$D$55,3,FALSE),C15*D15)),0)","v":0},null,null,{"$f":"IF(F15=\"\",\"-\",IF(G15=\"\",F15*-0.0186,F15*G15))","v":"-"}]
[{"$f":"Aggregate!A11","v":"Row 3"},"(select)",null,null,{"$f":"IFERROR(IF(C16=\"\",0,IF(D16=\"\",C16*VLOOKUP(B16,'State Elec. Prices & Premiums'!$B$4:$D$55,3,FALSE),C16*D16)),0)","v":0},null,null,"-"]
[{"$f":"Aggregate!A12","v":"Row 4"},"(select)",null,null,{"$f":"IFERROR(IF(C17=\"\",0,IF(D17=\"\",C17*VLOOKUP(B17,'State Elec. Prices & Premiums'!$B$4:$D$55,3,FALSE),C17*D17)),0)","v":0},null,null,"-"]
[{"$f":"Aggregate!A13","v":"Row 5"},"(select)",null,null,{"$f":"IFERROR(IF(C18=\"\",0,IF(D18=\"\",C18*VLOOKUP(B18,'State Elec. Prices & Premiums'!$B$4:$D$55,3,FALSE),C18*D18)),0)","v":0},null,null,"-"]
[{"$f":"Aggregate!A14","v":"Row 6"},"(select)",null,null,{"$f":"IFERROR(IF(C19=\"\",0,IF(D19=\"\",C19*VLOOKUP(B19,'State Elec. Prices & Premiums'!$B$4:$D$55,3,FALSE),C19*D19)),0)","v":0},null,null,"-"]
[{"$f":"Aggregate!A15","v":"Row 7"},"(select)",null,null,{"$f":"IFERROR(IF(C20=\"\",0,IF(D20=\"\",C20*VLOOKUP(B20,'State Elec. Prices & Premiums'!$B$4:$D$55,3,FALSE),C20*D20)),0)","v":0},null,null,"-"]
[{"$f":"Aggregate!A16","v":"Row 8"},"(select)",null,null,{"$f":"IFERROR(IF(C21=\"\",0,IF(D21=\"\",C21*VLOOKUP(B21,'State Elec. Prices & Premiums'!$B$4:$D$55,3,FALSE),C21*D21)),0)","v":0},null,null,"-"]
[{"$f":"Aggregate!A17","v":"Row 9"},"(select)",null,null,{"$f":"IFERROR(IF(C22=\"\",0,IF(D22=\"\",C22*VLOOKUP(B22,'State Elec. Prices & Premiums'!$B$4:$D$55,3,FALSE),C22*D22)),0)","v":0},null,null,"-"]
[{"$f":"Aggregate!A18","v":"Row 10"},"(select)",null,null,{"$f":"IFERROR(IF(C23=\"\",0,IF(D23=\"\",C23*VLOOKUP(B23,'State Elec. Prices & Premiums'!$B$4:$D$55,3,FALSE),C23*D23)),0)","v":0},null,null,"-"]
[{"$f":"Aggregate!A19","v":"Row 11"},"(select)",null,null,{"$f":"IFERROR(IF(C24=\"\",0,IF(D24=\"\",C24*VLOOKUP(B24,'State Elec. Prices & Premiums'!$B$4:$D$55,3,FALSE),C24*D24)),0)","v":0},null,null,"-"]
[]
["Color Key"]
["Enter value"]
["Use drop-down menu"]
["Do not change - calculation"]
[]
[" Sources"]
["ELECTRICITY CONSERVATION","Energy Information Administration (EIA), 2020"]
["PURCHASED GREEN ELECTRICITY","National Renewable Energy Laboratory (NREL), 2020. https://www.nrel.gov/analysis/assets/docs/utility-green-pricing-program-list.xlsx . Using NREL's data, the average utility price of a green power product is $0.0186/kWh."]
["Additional Information"]
["EPA's Green Power Pricing","https://www.epa.gov/greenpower/green-power-pricing"]
["EPA's Supply Options","https://www.epa.gov/greenpower/green-power-supply-options"]
["EPA's Locate Green Power Suppliers","https://www.epa.gov/greenpower/locate-green-power-suppliers"]
["EPA's Supply Options Screen Tool","https://www.epa.gov/greenpower/procurement-tools-resources"]

{"sheet":"Fuel Use","index":3,"n_rows":39,"n_cols":30,"rows_kept":39,"cut":false,"hidden":false,"merged":[[9,27,9,29],[4,15,4,17],[5,15,5,17],[9,15,9,17],[5,24,5,26],[4,21,4,23],[5,21,5,23],[4,27,4,29],[5,27,5,29],[4,18,4,20],[5,18,5,20],[4,24,4,26],[9,18,9,20],[9,24,9,26],[9,21,9,23],[41,8,42,8],[36,1,36,5],[31,8,32,8],[34,8,35,8],[34,1,34,5],[33,1,33,5],[32,1,32,5],[38,8,39,8],[38,1,38,5],[37,1,37,5],[35,1,35,5],[9,12,9,14],[9,0,10,0],[9,1,9,5],[31,1,31,5],[6,4,6,5],[9,6,9,8],[11,1,11,3],[9,9,9,11],[5,9,5,11],[3,27,3,29],[3,9,3,11],[3,21,3,23],[3,18,3,20],[3,24,3,26],[3,15,3,17],[3,12,3,14],[4,12,4,14],[5,12,5,14],[4,9,4,11],[1,1,1,8],[4,6,4,8],[5,6,5,8],[4,1,4,5],[5,1,5,5],[3,1,3,5],[3,6,3,8]]}
[null,"Fuel Use"]
[null,"This tab computes cost savings from buying less fossil fuel and using less for travel. For a travel activity, please use whichever is easier for you -- vehicles miles or motor gasoline reduced (just not both). "]
[]
["PLACE CURSOR OVER CELL FOR MORE INFORMATION →","Natural Gas",null,null,null,null,"Vehicle Miles Reduced ",null,null,"Motor Gasoline",null,null,"Diesel",null,null,"Biodiesel",null,null,"Heating Oil",null,null,"Jet Fuel",null,null,"Air Travel",null,null,"Coal"]
["\nHow to use this tab","Enter the quantity and unit of natural gas reduced. Enter the unit cost or leave blank to use a default value. Savings are on the right. ",null,null,null,null,"Enter the number of vehicle miles reduced.  Enter the unit cost or leave blank to use a default value.  Savings are on the right. Only add values here if not adding them in the Motor Gasoline column.\n\n",null,null,"Enter the gallons of motor gasoline reduced. Enter the unit cost or leave blank to use a default value. Savings are on the right. Only add values here if not adding them in the Vehicle Miles Reduced column.",null,null,"Enter the gallons of diesel reduced.  Enter the unit cost or leave blank to use a default value. Savings are on the right. ",null,null,"Enter the gallons of biodiesel reduced. Enter the unit cost or leave blank to use a default value. Savings are on the right.",null,null,"Enter the gallons of heating oil reduced.  Enter the unit cost or leave blank to use a default value. Savings are on the right. ",null,null,"Enter the gallons of jet fuel reduced.  Enter the unit cost or leave blank to use a default value. Savings are on the right. ",null,null,"Enter the number of flights avoided and enter the average unit cost of all flights combined. Savings are on the right.",null,null,"Enter the tons of coal reduced.  Enter the unit cost or leave blank to use a default value. Savings are on the right. "]
["Calculation Description","Unit quantity of natural gas reduced  * unit cost (user-specified or default value) = Dollars saved.  The calculator formula converts all units to therms.",null,null,null,null,"Miles reduced  * unit cost (user-specified or default) = Dollars saved.",null,null,"Gallons reduced  * unit cost (user-specified or default) = Dollars saved.",null,null,"Diesel gallons reduced  * unit cost (user-specified or default) = Dollars saved.",null,null,"Biodiesel gallons reduced * unit cost (user-specified or default) = Dollars saved",null,null,"Heating oil gallons reduced  * unit cost (user-specified or default) = Dollars saved.",null,null,"Jet fuel gallons reduced  * unit cost (user-specified or default) = Dollars saved.",null,null,"Number of flights avoided  * average unit cost of flight (user-specified ) = Dollars saved.",null,null,"Tons of coal reduced * unit cost (user-specified or default) = Dollars saved."]
["Default Unit Cost",0.70199999999999996,"/therms",null,null,null,0.57499999999999996,"/mile",null,2.6909999999999998,"/gal",null,3.056,"/gal",null,2.94,"/gal",null,2.4209999999999998,"/gal",null,1.08,"/gal",null,null,null,null,61.37,"/ton"]
[]
[null,"Amount of Natural Gas Reduced","Unit (select)","Unit Cost ($/unit selected)","Therms Reduced","Dollar Savings","Miles Reduced","Unit Cost ($/mile) ","Dollar Savings","Reduced Gallons of Gas","Unit Cost ($/gal) ","Dollar Savings","Reduced Gallons of Diesel","Unit Cost ($/gal) ","Dollar Savings","Reduced Gallons of Biodiesel","Unit Cost ($/gal) ","Dollar Savings","Reduced Gallons of Heating Oil","Unit Cost ($/gal) ","Dollar Savings","Reduced Gallons of Jet Fuel","Unit Cost ($/gal) ","Dollar Savings","Flights Avoided (#)","Average Unit Cost ($/flight)","Dollar Savings","Reduced Tons of Coal","Unit Cost ($/ton) ","Dollar Savings"]
["Example","Green building initiatives reduced heat usage at two commercial buildings. "]
[null,150000,"therms",null,{"$f":"IF(C11=\"therms\",B11,IF(C11=\"cubic feet\",B11*'Conversion Factors'!$D$33/'Conversion Factors'!$D$31,IF(C11=\"BTU\",B11/'Conversion Factors'!$D$31,0)))","v":150000},{"$f":"E11*$B$7","v":105300}]
["Totals - All Rows",null,null,null,{"$f":"SUM(E14:E24)","v":0},{"$f":"SUM(F14:F24)","v":0},{"$f":"SUM(G14:G24)","v":0},null,{"$f":"SUM(I14:I24)","v":0},{"$f":"SUM(J14:J24)","v":0},null,{"$f":"SUM(L14:L24)","v":0},{"$f":"SUM(M14:M24)","v":0},null,{"$f":"SUM(O14:O24)","v":0},{"$f":"SUM(P14:P24)","v":0},null,{"$f":"SUM(R14:R24)","v":0},{"$f":"SUM(S14:S24)","v":0},null,{"$f":"SUM(U14:U24)","v":0},{"$f":"SUM(V14:V24)","v":0},null,{"$f":"SUM(X14:X24)","v":0},{"$f":"SUM(Y14:Y24)","v":0},null,{"$f":"SUM(AA14:AA24)","v":0},{"$f":"SUM(AB14:AB24)","v":0},null,{"$f":"SUM(AD14:AD24)","v":0}]
[]
[{"$f":"Aggregate!A9","v":"Row 1"},null,"(Select)",null,{"$f":"IF(C14=\"therms\", B14, IF( C14=\"cubic feet\", B14*'Conversion Factors'!$D$33/'Conversion Factors'!$D$31, IF(C14=\"BTU\", B14/'Conversion Factors'!$D$31, IF(C14=\"CCF\", B14*'Conversion Factors'!$D$34/'Conversion Factors'!$D$31, 0))))","v":0},{"$f":"IF(D14=\"\",E14*$B$7,B14*D14)","v":0},null,null,{"$f":"IF(H14=\"\",G14*$G$7,G14*H14)","v":0},null,null,{"$f":"IF(K14=\"\",J14*$J$7,J14*K14)","v":0},null,null,{"$f":"IF(N14=\"\",M14*$M$7,M14*N14)","v":0},null,null,{"$f":"IF(Q14=\"\", P14*$P$7, P14*Q14)","v":0},null,null,{"$f":"IF(T14=\"\",S14*$S$7,S14*T14)","v":0},null,null,{"$f":"IF(W14=\"\",V14*$V$7,V14*W14)","v":0},null,null,{"$f":"Y14*Z14","v":0},null,null,{"$f":"IF(AC14=\"\",AB14*$AB$7,AB14*AC14)","v":0}]
[{"$f":"Aggregate!A10","v":"Row 2"},null,"(Select)",null,{"$f":"IF(C15=\"therms\", B15, IF( C15=\"cubic feet\", B15*'Conversion Factors'!$D$33/'Conversion Factors'!$D$31, IF(C15=\"BTU\", B15/'Conversion Factors'!$D$31, IF(C15=\"CCF\", B15*'Conversion Factors'!$D$34/'Conversion Factors'!$D$31, 0))))","v":0},{"$f":"IF(D15=\"\",E15*$B$7,B15*D15)","v":0},null,null,{"$f":"IF(H15=\"\",G15*$G$7,G15*H15)","v":0},null,null,{"$f":"IF(K15=\"\",J15*$J$7,J15*K15)","v":0},null,null,{"$f":"IF(N15=\"\",M15*$M$7,M15*N15)","v":0},null,null,{"$f":"IF(Q15=\"\", P15*$P$7, P15*Q15)","v":0},null,null,{"$f":"IF(T15=\"\",S15*$S$7,S15*T15)","v":0},null,null,{"$f":"IF(W15=\"\",V15*$V$7,V15*W15)","v":0},null,null,{"$f":"Y15*Z15","v":0},null,null,{"$f":"IF(AC15=\"\",AB15*$AB$7,AB15*AC15)","v":0}]
[{"$f":"Aggregate!A11","v":"Row 3"},null,"(Select)",null,{"$f":"IF(C16=\"therms\", B16, IF( C16=\"cubic feet\", B16*'Conversion Factors'!$D$33/'Conversion Factors'!$D$31, IF(C16=\"BTU\", B16/'Conversion Factors'!$D$31, IF(C16=\"CCF\", B16*'Conversion Factors'!$D$34/'Conversion Factors'!$D$31, 0))))","v":0},{"$f":"IF(D16=\"\",E16*$B$7,B16*D16)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[{"$f":"Aggregate!A12","v":"Row 4"},null,"(Select)",null,{"$f":"IF(C17=\"therms\", B17, IF( C17=\"cubic feet\", B17*'Conversion Factors'!$D$33/'Conversion Factors'!$D$31, IF(C17=\"BTU\", B17/'Conversion Factors'!$D$31, IF(C17=\"CCF\", B17*'Conversion Factors'!$D$34/'Conversion Factors'!$D$31, 0))))","v":0},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[{"$f":"Aggregate!A13","v":"Row 5"},null,"(Select)",null,{"$f":"IF(C18=\"therms\", B18, IF( C18=\"cubic feet\", B18*'Conversion Factors'!$D$33/'Conversion Factors'!$D$31, IF(C18=\"BTU\", B18/'Conversion Factors'!$D$31, IF(C18=\"CCF\", B18*'Conversion Factors'!$D$34/'Conversion Factors'!$D$31, 0))))","v":0},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[{"$f":"Aggregate!A14","v":"Row 6"},null,"(Select)",null,{"$f":"IF(C19=\"therms\", B19, IF( C19=\"cubic feet\", B19*'Conversion Factors'!$D$33/'Conversion Factors'!$D$31, IF(C19=\"BTU\", B19/'Conversion Factors'!$D$31, IF(C19=\"CCF\", B19*'Conversion Factors'!$D$34/'Conversion Factors'!$D$31, 0))))","v":0},{"$f":"IF(D19=\"\",E19*$B$7,B19*D19)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[{"$f":"Aggregate!A15","v":"Row 7"},null,"(Select)",null,{"$f":"IF(C20=\"therms\", B20, IF( C20=\"cubic feet\", B20*'Conversion Factors'!$D$33/'Conversion Factors'!$D$31, IF(C20=\"BTU\", B20/'Conversion Factors'!$D$31, IF(C20=\"CCF\", B20*'Conversion Factors'!$D$34/'Conversion Factors'!$D$31, 0))))","v":0},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[{"$f":"Aggregate!A16","v":"Row 8"},null,"(Select)",null,{"$f":"IF(C21=\"therms\", B21, IF( C21=\"cubic feet\", B21*'Conversion Factors'!$D$33/'Conversion Factors'!$D$31, IF(C21=\"BTU\", B21/'Conversion Factors'!$D$31, IF(C21=\"CCF\", B21*'Conversion Factors'!$D$34/'Conversion Factors'!$D$31, 0))))","v":0},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[{"$f":"Aggregate!A17","v":"Row 9"},null,"(Select)",null,{"$f":"IF(C22=\"therms\", B22, IF( C22=\"cubic feet\", B22*'Conversion Factors'!$D$33/'Conversion Factors'!$D$31, IF(C22=\"BTU\", B22/'Conversion Factors'!$D$31, IF(C22=\"CCF\", B22*'Conversion Factors'!$D$34/'Conversion Factors'!$D$31, 0))))","v":0},{"$f":"IF(D22=\"\",E22*$B$7,B22*D22)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[{"$f":"Aggregate!A18","v":"Row 10"},null,"(Select)",null,{"$f":"IF(C23=\"therms\", B23, IF( C23=\"cubic feet\", B23*'Conversion Factors'!$D$33/'Conversion Factors'!$D$31, IF(C23=\"BTU\", B23/'Conversion Factors'!$D$31, IF(C23=\"CCF\", B23*'Conversion Factors'!$D$34/'Conversion Factors'!$D$31, 0))))","v":0},{"$f":"IF(D23=\"\",E23*$B$7,B23*D23)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[{"$f":"Aggregate!A19","v":"Row 11"},null,"(Select)",null,{"$f":"IF(C24=\"therms\", B24, IF( C24=\"cubic feet\", B24*'Conversion Factors'!$D$33/'Conversion Factors'!$D$31, IF(C24=\"BTU\", B24/'Conversion Factors'!$D$31, IF(C24=\"CCF\", B24*'Conversion Factors'!$D$34/'Conversion Factors'!$D$31, 0))))","v":0},{"$f":"IF(D24=\"\",E24*$B$7,B24*D24)","v":0},null,null,0,null,null,{"$f":"IF(K24=\"\",J24*$J$7,J24*K24)","v":0},null,null,{"$f":"IF(N24=\"\",M24*$M$7,M24*N24)","v":0},null,null,{"$f":"IF(Q24=\"\", P24*$P$7, P24*Q24)","v":0},null,null,{"$f":"IF(T24=\"\",S24*$S$7,S24*T24)","v":0},null,null,{"$f":"IF(W24=\"\",V24*$V$7,V24*W24)","v":0},null,null,{"$f":"Y24*Z24","v":0},null,null,{"$f":"IF(AC24=\"\",AB24*$AB$7,AB24*AC24)","v":0}]
[]
["Color Key",null,"therms"]
["Enter value",null,"cubic feet"]
["Use drop-down menu",null,"BTU"]
["Do not change - calculation"]
[]
["Sources"]
["NATURAL GAS","Energy Information Administration (EIA), 2020"]
["VEHICLE MILES","Internal Revenue Service (IRS), 2019"]
["MOTOR GASOLINE","Energy Information Administration (EIA), 2020"]
["DIESEL","Energy Information Administration (EIA), 2020"]
["BIODIESEL","U.S. Department of Energy, Energy Efficiency and Renewable Energy, 2020"]
["HEATING OIL","Energy Information Administration (EIA), 2020"]
["JET FUEL","US Department of Transportation, Bureau of Transportation Statistics, 2020"]
["COAL","Energy Information Administration (EIA), 2019"]

{"sheet":"Water Use","index":4,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,2,29,3],[28,1,28,3],[7,0,8,0],[0,0,2,0],[7,1,7,3],[1,1,1,3],[5,1,5,3],[4,1,4,3],[3,1,3,3]]}
[null,"Water Use"]
[null,"This tab computes the cost savings from reducing water usage.  "]
[]
["Type of Reduction","Water Use"]
["How to use this tab","Enter water use reduced in gallons. Enter the unit cost or a national default unit cost will be used. Dollar savings are on the right. This tab is for projects that conserved water. If the project also reduced water pollutant quantities, enter the gallons of water reduced (if any) on this tab, and enter the pollutant reductions in the Water Pollution tab."]
["Calculation Description","Gallons reduced * unit cost (user supplied or default value) = Dollars saved."]
[null,"Gallons Reduced","Unit Cost ($/gal) ","Dollar Savings"]
["Example","A facility plant adopted a new water conservation technology to reduce process water use by 3 million gallons annually."]
[null,3000000,null,{"$f":"IF(C9=\"\",B9*'Water Charges'!$E$3,C9*B9)","v":15505.90909090909}]
["Totals - All Rows",{"$f":"SUM(B12:B22)","v":0},null,{"$f":"SUM(D12:D22)","v":0}]
[]
[{"$f":"Aggregate!A9","v":"Row 1"},null,null,{"$f":"IF(C12=\"\",B12*'Water Charges'!$E$3,C12*B12)","v":0}]
[{"$f":"Aggregate!A10","v":"Row 2"},null,null,{"$f":"IF(C13=\"\",B13*'Water Charges'!$E$3,C13*B13)","v":0}]
[{"$f":"Aggregate!A11","v":"Row 3"},null,null,{"$f":"IF(C14=\"\",B14*'Water Charges'!$E$3,C14*B14)","v":0}]
[{"$f":"Aggregate!A12","v":"Row 4"},null,null,{"$f":"IF(C15=\"\",B15*'Water Charges'!$E$3,C15*B15)","v":0}]
[{"$f":"Aggregate!A13","v":"Row 5"},null,null,{"$f":"IF(C16=\"\",B16*'Water Charges'!$E$3,C16*B16)","v":0}]
[{"$f":"Aggregate!A14","v":"Row 6"},null,null,{"$f":"IF(C17=\"\",B17*'Water Charges'!$E$3,C17*B17)","v":0}]
[{"$f":"Aggregate!A15","v":"Row 7"},null,null,{"$f":"IF(C18=\"\",B18*'Water Charges'!$E$3,C18*B18)","v":0}]
[{"$f":"Aggregate!A16","v":"Row 8"},null,null,{"$f":"IF(C19=\"\",B19*'Water Charges'!$E$3,C19*B19)","v":0}]
[{"$f":"Aggregate!A17","v":"Row 9"},null,null,{"$f":"IF(C20=\"\",B20*'Water Charges'!$E$3,C20*B20)","v":0}]
[{"$f":"Aggregate!A18","v":"Row 10"},null,null,{"$f":"IF(C21=\"\",B21*'Water Charges'!$E$3,C21*B21)","v":0}]
[{"$f":"Aggregate!A19","v":"Row 11"},null,null,{"$f":"IF(C22=\"\",B22*'Water Charges'!$E$3,C22*B22)","v":0}]
[]
["Color Key"]
["Enter value"]
["Use drop-down menu"]
["Do not change - calculation"]
[]
["Sources"]
["WATER USE","AWWA 2019 Rate Survey. Exhibit 2.","Unless getting water free from an underground source, facilities are charged twice for water -- once to receive it, and again to have the discharged water taken away and treated.  "]

{"sheet":"Water Pollution","index":5,"n_rows":35,"n_cols":35,"rows_kept":35,"cut":false,"hidden":false,"merged":[[5,29,5,33],[4,24,4,28],[5,24,5,28],[7,29,7,33],[7,24,7,28],[1,1,1,8],[10,24,10,28],[9,9,9,11],[30,2,30,4],[32,2,32,4],[31,2,31,4],[9,14,9,16],[4,14,4,18],[5,14,5,18],[7,14,7,18],[3,19,3,23],[4,19,4,23],[5,19,5,23],[7,19,7,23],[9,19,9,21],[10,19,10,23],[34,2,34,4],[29,2,29,4],[9,4,9,6],[10,14,10,18],[3,29,3,33],[3,24,3,28],[5,9,5,13],[4,4,4,8],[3,9,3,13],[4,9,4,13],[4,29,4,33],[3,14,3,18],[33,2,33,4],[10,29,10,33],[9,24,9,26],[9,29,9,31],[7,0,8,0],[7,4,7,8],[3,4,3,8],[5,4,5,8],[7,9,7,13],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3]]}
[null,"Water Pollution"]
[null,"This tab computes cost savings from reducing discharges of conventional, nonconventional, and toxic pollutants to water (BOD/COD, TSS, FOG, toxics, and nutrients, etc.).\nThis tab converts reductions in discharges to water that impair water quality to pounds of pollutants. Use the \"General Wastewater\" section if you don't have a wastewater permit and/or don't know the category of impairment to water quality. If you do know the category of impairment and can make some modeled estimates or use water-permit methodologies to calculate discharges, then enter your data in the appropriate impairment column. "]
[]
["Type of Reduction","General Wastewater",null,null,"BOD/COD (Biological Oxygen Demand or Chemical Oxygen Demand)",null,null,null,null,"Total Suspended Solids (TSS)",null,null,null,null,"Fats, Oils, and Grease (FOG)",null,null,null,null,"Other Conventional Pollutants",null,null,null,null,"Toxics and Nonconventional Pollutants",null,null,null,null,"Nutrients",null,null,null,null,"Total"]
["\nHow to use this tab","Enter gallons reduced. Enter the unit cost of treatment or a national default unit cost will be used. If reductions in wastewater are associated with reductions in water use, enter the reductions in water use in the Water Use tab.",null,null,"Enter the BOD/COD quantity reduced in a unit from the drop down. Enter the unit cost or a national default unit cost will be used. Savings are on the right.",null,null,null,null,"Enter the TSS quantity reduced in a unit from the drop down. Enter the unit cost or a national default unit cost will be used. Savings are on the right.",null,null,null,null,"Enter quantity of fats, oils, and grease (FOG) waste reduced, select the appropriate unit, and enter the unit cost (no default is available). To avoid double counting, do not enter these quantities in any other tab.",null,null,null,null,"Enter the quantity of other conventional water pollutants reduced, select the appropriate unit, and enter the unit cost (no default is available). To avoid double counting, do not enter these quantities in any other tab.",null,null,null,null,"Enter the quantity of toxic and/or nonconventional water pollutants reduced, select the appropriate unit, and enter the unit cost (no default is available). To avoid double counting, do not enter these quantities in any other tab.",null,null,null,null,"Enter the quantity of nutrients reduced in a unit from the drop down and enter the unit cost (no default is available)."]
["Calculation Description","Gallons reduced * unit cost (user-specified or default) = Dollars saved. ",null,null,"Quantity of BOD/COD reduced (in user-specified units) * unit cost (user-specified or default) = Dollars saved.  A formula converts all units to pounds.\n\nTo calculate mass (e.g., milligrams) of BOD reduced, multiply the reduction concentration of BOD measured (e.g., mg/L) by the flow rate (e.g., L/day) to get weight (e.g., mg) per day. Then multiply by the length of the reporting period (e.g., 365 days) to get total weight of BOD discharged.",null,null,null,null,"Quantity of BOD/COD reduced (in user-specified units) * unit cost (user-specified or default) = Dollars saved.  A formula converts all units to pounds.\n\nTo calculate mass (e.g., milligrams) of TSS reduced, multiply the reduction concentration of TSS measured (e.g., mg/L) by the flow rate (e.g., L/day) to get weight (e.g., mg) per day. Then multiply by the length of the reporting period (e.g., 365 days) to get total weight of TSS discharged.",null,null,null,null,"Quantity of FOG reduced (in user-specified units) * unit cost (user-specified) = Dollars saved.  A formula converts all units to pounds.\n\nTo calculate mass (e.g., milligrams) of FOG reduced, multiply the reduction concentration of FOG measured (e.g., mg/L) by the flow rate (e.g., L/day) to get weight (e.g., mg) per day. Then multiply by the length of the reporting period (e.g., 365 days) to get total weight of FOG discharged.",null,null,null,null,"Quantity of toxics reduced (in user-specified units) * unit cost (user-specified) = Dollars saved.  A formula converts all units to pounds.\n\nTo calculate mass (e.g., milligrams) of toxics reduced, multiply the reduction concentration of toxics measured (e.g., mg/L) by the flow rate (e.g., L/day) to get weight (e.g., mg) per day. Then multiply by the length of the reporting period (e.g., 365 days) to get total weight of toxics discharged.",null,null,null,null,"Quantity of toxics reduced (in user-specified units) * unit cost (user-specified) = Dollars saved.  A formula converts all units to pounds.\n\nTo calculate mass (e.g., milligrams) of toxics reduced, multiply the reduction concentration of toxics measured (e.g., mg/L) by the flow rate (e.g., L/day) to get weight (e.g., mg) per day. Then multiply by the length of the reporting period (e.g., 365 days) to get total weight of toxics discharged.",null,null,null,null,"Quantity of nutrients reduced (in user-specified units) * user-specified unit cost = Dollars saved.  A formula converts all units to pounds."]
[null,"Reduced Gallons of Wastewater","Unit Cost \n($/gal) ","Dollars Savings","Reduced Quantity of BOD/COD","Units \n(select)","Unit Cost ($/unit selected)","Pounds Reduced","Dollar Savings","Reduced Quantity of TSS","Units (select)","Unit Cost ($/unit selected)","Pounds Reduced","Dollar Savings","Reduced Quantity of FOG","Units (select)","Unit Cost ($/unit selected)","Pounds Reduced","Dollar Savings","Reduced Quantity of toxics","Units (select)","Unit Cost ($/unit selected)","Pounds Reduced","Dollar Savings","Reduced Quantity of toxics","Units (select)","Unit Cost ($/unit selected)","Pounds Reduced","Dollar Savings","Reduced Quantity of Nutrients","Units (select)","Unit Cost ($/unit selected)","Pounds Reduced","Dollar Savings","Total Savings"]
["Example\n(Enter quantities in this worksheet. Enter action descriptions in EPA reporting templates.)","A metal finishing facility adopted electrocoagulation technology, reducing process water use/discharge by 1 million gallons/yr.",null,null,"Through the adoption of a new filtration system in one of its plants, GMC reduced the quantity of BOD/COD discharged by 500 kilograms."]
[null,1000000,null,{"$f":"IF(C9=\"\",B9*'Water Charges'!$B$3,C9*B9)","v":5830.6951871657757},500,"kg",null,1102.5,{"$f":"IF(G9=\"\",H9*'Water Charges'!$D$3,H9*G9)","v":415.09125}]
["Totals - All Rows",{"$f":"SUM(B12:B22)","v":0},null,{"$f":"SUM(D12:D22)","v":0},null,null,null,{"$f":"SUM(H12:H22)","v":0},{"$f":"SUM(I12:I22)","v":0},null,null,null,{"$f":"SUM(M12:M22)","v":0},{"$f":"SUM(N12:N22)","v":0},null,null,null,{"$f":"SUM(R12:R22)","v":0},{"$f":"SUM(S12:S22)","v":0},null,null,null,{"$f":"SUM(W12:W22)","v":0},{"$f":"SUM(X12:X22)","v":0},null,null,null,{"$f":"SUM(AB12:AB22)","v":0},{"$f":"SUM(AC12:AC22)","v":0},null,null,null,{"$f":"SUM(AG12:AG22)","v":0},{"$f":"SUM(AH12:AH22)","v":0},{"$f":"SUM(AI12:AI22)","v":0}]
[]
[{"$f":"Aggregate!A9","v":"Row 1"},null,null,{"$f":"IF(C12=\"\",B12*'Water Charges'!$B$3,C12*B12)","v":0},null,"(Select)",null,{"$f":"IF(F12=\"lbs\",E12,IF(F12=\"kg\",E12*'Conversion Factors'!$D$21,IF(F12=\"tons\",E12*'Conversion Factors'!$D$23,IF(F12=\"metric tons\",E12*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"IF(G12=\"\",H12*'Water Charges'!$D$3,H12*G12)","v":0},null,"(Select)",null,{"$f":"IF(K12=\"lbs\",J12,IF(K12=\"kg\",J12*'Conversion Factors'!$D$21,IF(K12=\"tons\",J12*'Conversion Factors'!$D$23,IF(K12=\"metric tons\",J12*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"IF(L12=\"\",M12*'Water Charges'!$C$3,M12*L12)","v":0},null,"(Select)",null,{"$f":"IF(P12=\"lbs\",O12,IF(P12=\"kg\",O12*'Conversion Factors'!$D$21,IF(P12=\"tons\",O12*'Conversion Factors'!$D$23,IF(P12=\"metric tons\",O12*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"O12*Q12","v":0},null,"(Select)",null,{"$f":"IF(U12=\"lbs\",T12,IF(U12=\"kg\",T12*'Conversion Factors'!$D$21,IF(U12=\"tons\",T12*'Conversion Factors'!$D$23,IF(U12=\"metric tons\",T12*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"T12*V12","v":0},null,"(Select)",null,{"$f":"IF(Z12=\"lbs\",Y12,IF(Z12=\"kg\",Y12*'Conversion Factors'!$D$21,IF(Z12=\"tons\",Y12*'Conversion Factors'!$D$23,IF(Z12=\"metric tons\",Y12*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"Y12*AA12","v":0},null,"(Select)",null,{"$f":"IF(AE12=\"lbs\",AD12,IF(AE12=\"kg\",AD12*'Conversion Factors'!$D$21,IF(AE12=\"tons\",AD12*'Conversion Factors'!$D$23,IF(AE12=\"metric tons\",AD12*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"AD12*AF12","v":0},{"$f":"SUM(D12,AH12,N12,S12,AC12,I12,X12)","v":0}]
[{"$f":"Aggregate!A10","v":"Row 2"},null,null,{"$f":"IF(C13=\"\",B13*'Water Charges'!$B$3,C13*B13)","v":0},null,"(Select)",null,{"$f":"IF(F13=\"lbs\",E13,IF(F13=\"kg\",E13*'Conversion Factors'!$D$21,IF(F13=\"tons\",E13*'Conversion Factors'!$D$23,IF(F13=\"metric tons\",E13*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"IF(G13=\"\",H13*'Water Charges'!$D$3,H13*G13)","v":0},null,"(Select)",null,{"$f":"IF(K13=\"lbs\",J13,IF(K13=\"kg\",J13*'Conversion Factors'!$D$21,IF(K13=\"tons\",J13*'Conversion Factors'!$D$23,IF(K13=\"metric tons\",J13*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"IF(L13=\"\",M13*'Water Charges'!$C$3,M13*L13)","v":0},null,"(Select)",null,{"$f":"IF(P13=\"lbs\",O13,IF(P13=\"kg\",O13*'Conversion Factors'!$D$21,IF(P13=\"tons\",O13*'Conversion Factors'!$D$23,IF(P13=\"metric tons\",O13*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"O13*Q13","v":0},null,"(Select)",null,{"$f":"IF(U13=\"lbs\",T13,IF(U13=\"kg\",T13*'Conversion Factors'!$D$21,IF(U13=\"tons\",T13*'Conversion Factors'!$D$23,IF(U13=\"metric tons\",T13*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"T13*V13","v":0},null,"(Select)",null,{"$f":"IF(Z13=\"lbs\",Y13,IF(Z13=\"kg\",Y13*'Conversion Factors'!$D$21,IF(Z13=\"tons\",Y13*'Conversion Factors'!$D$23,IF(Z13=\"metric tons\",Y13*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"Y13*AA13","v":0},null,"(Select)",null,{"$f":"IF(AE13=\"lbs\",AD13,IF(AE13=\"kg\",AD13*'Conversion Factors'!$D$21,IF(AE13=\"tons\",AD13*'Conversion Factors'!$D$23,IF(AE13=\"metric tons\",AD13*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"AD13*AF13","v":0},{"$f":"SUM(D13,AH13,N13,S13,AC13,I13,X13)","v":0}]
[{"$f":"Aggregate!A11","v":"Row 3"},null,null,{"$f":"IF(C14=\"\",B14*'Water Charges'!$B$3,C14*B14)","v":0},null,"(Select)",null,{"$f":"IF(F14=\"lbs\",E14,IF(F14=\"kg\",E14*'Conversion Factors'!$D$21,IF(F14=\"tons\",E14*'Conversion Factors'!$D$23,IF(F14=\"metric tons\",E14*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"IF(G14=\"\",H14*'Water Charges'!$D$3,H14*G14)","v":0},null,"(Select)",null,{"$f":"IF(K14=\"lbs\",J14,IF(K14=\"kg\",J14*'Conversion Factors'!$D$21,IF(K14=\"tons\",J14*'Conversion Factors'!$D$23,IF(K14=\"metric tons\",J14*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"IF(L14=\"\",M14*'Water Charges'!$C$3,M14*L14)","v":0},null,"(Select)",null,{"$f":"IF(P14=\"lbs\",O14,IF(P14=\"kg\",O14*'Conversion Factors'!$D$21,IF(P14=\"tons\",O14*'Conversion Factors'!$D$23,IF(P14=\"metric tons\",O14*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,null,"(Select)",null,{"$f":"IF(U14=\"lbs\",T14,IF(U14=\"kg\",T14*'Conversion Factors'!$D$21,IF(U14=\"tons\",T14*'Conversion Factors'!$D$23,IF(U14=\"metric tons\",T14*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,null,"(Select)",null,{"$f":"IF(Z14=\"lbs\",Y14,IF(Z14=\"kg\",Y14*'Conversion Factors'!$D$21,IF(Z14=\"tons\",Y14*'Conversion Factors'!$D$23,IF(Z14=\"metric tons\",Y14*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,null,"(Select)",null,{"$f":"IF(AE14=\"lbs\",AD14,IF(AE14=\"kg\",AD14*'Conversion Factors'!$D$21,IF(AE14=\"tons\",AD14*'Conversion Factors'!$D$23,IF(AE14=\"metric tons\",AD14*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,0]
[{"$f":"Aggregate!A12","v":"Row 4"},null,null,{"$f":"IF(C15=\"\",B15*'Water Charges'!$B$3,C15*B15)","v":0},null,"(Select)",null,{"$f":"IF(F15=\"lbs\",E15,IF(F15=\"kg\",E15*'Conversion Factors'!$D$21,IF(F15=\"tons\",E15*'Conversion Factors'!$D$23,IF(F15=\"metric tons\",E15*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"IF(G15=\"\",H15*'Water Charges'!$D$3,H15*G15)","v":0},null,"(Select)",null,{"$f":"IF(K15=\"lbs\",J15,IF(K15=\"kg\",J15*'Conversion Factors'!$D$21,IF(K15=\"tons\",J15*'Conversion Factors'!$D$23,IF(K15=\"metric tons\",J15*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"IF(L15=\"\",M15*'Water Charges'!$C$3,M15*L15)","v":0},null,"(Select)",null,{"$f":"IF(P15=\"lbs\",O15,IF(P15=\"kg\",O15*'Conversion Factors'!$D$21,IF(P15=\"tons\",O15*'Conversion Factors'!$D$23,IF(P15=\"metric tons\",O15*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,null,"(Select)",null,{"$f":"IF(U15=\"lbs\",T15,IF(U15=\"kg\",T15*'Conversion Factors'!$D$21,IF(U15=\"tons\",T15*'Conversion Factors'!$D$23,IF(U15=\"metric tons\",T15*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,null,"(Select)",null,{"$f":"IF(Z15=\"lbs\",Y15,IF(Z15=\"kg\",Y15*'Conversion Factors'!$D$21,IF(Z15=\"tons\",Y15*'Conversion Factors'!$D$23,IF(Z15=\"metric tons\",Y15*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,null,"(Select)",null,{"$f":"IF(AE15=\"lbs\",AD15,IF(AE15=\"kg\",AD15*'Conversion Factors'!$D$21,IF(AE15=\"tons\",AD15*'Conversion Factors'!$D$23,IF(AE15=\"metric tons\",AD15*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,0]
[{"$f":"Aggregate!A13","v":"Row 5"},null,null,{"$f":"IF(C16=\"\",B16*'Water Charges'!$B$3,C16*B16)","v":0},null,"(Select)",null,{"$f":"IF(F16=\"lbs\",E16,IF(F16=\"kg\",E16*'Conversion Factors'!$D$21,IF(F16=\"tons\",E16*'Conversion Factors'!$D$23,IF(F16=\"metric tons\",E16*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"IF(G16=\"\",H16*'Water Charges'!$D$3,H16*G16)","v":0},null,"(Select)",null,{"$f":"IF(K16=\"lbs\",J16,IF(K16=\"kg\",J16*'Conversion Factors'!$D$21,IF(K16=\"tons\",J16*'Conversion Factors'!$D$23,IF(K16=\"metric tons\",J16*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"IF(L16=\"\",M16*'Water Charges'!$C$3,M16*L16)","v":0},null,"(Select)",null,{"$f":"IF(P16=\"lbs\",O16,IF(P16=\"kg\",O16*'Conversion Factors'!$D$21,IF(P16=\"tons\",O16*'Conversion Factors'!$D$23,IF(P16=\"metric tons\",O16*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,null,"(Select)",null,{"$f":"IF(U16=\"lbs\",T16,IF(U16=\"kg\",T16*'Conversion Factors'!$D$21,IF(U16=\"tons\",T16*'Conversion Factors'!$D$23,IF(U16=\"metric tons\",T16*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,null,"(Select)",null,{"$f":"IF(Z16=\"lbs\",Y16,IF(Z16=\"kg\",Y16*'Conversion Factors'!$D$21,IF(Z16=\"tons\",Y16*'Conversion Factors'!$D$23,IF(Z16=\"metric tons\",Y16*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,null,"(Select)",null,{"$f":"IF(AE16=\"lbs\",AD16,IF(AE16=\"kg\",AD16*'Conversion Factors'!$D$21,IF(AE16=\"tons\",AD16*'Conversion Factors'!$D$23,IF(AE16=\"metric tons\",AD16*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,0]
[{"$f":"Aggregate!A14","v":"Row 6"},null,null,{"$f":"IF(C17=\"\",B17*'Water Charges'!$B$3,C17*B17)","v":0},null,"(Select)",null,{"$f":"IF(F17=\"lbs\",E17,IF(F17=\"kg\",E17*'Conversion Factors'!$D$21,IF(F17=\"tons\",E17*'Conversion Factors'!$D$23,IF(F17=\"metric tons\",E17*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"IF(G17=\"\",H17*'Water Charges'!$D$3,H17*G17)","v":0},null,"(Select)",null,{"$f":"IF(K17=\"lbs\",J17,IF(K17=\"kg\",J17*'Conversion Factors'!$D$21,IF(K17=\"tons\",J17*'Conversion Factors'!$D$23,IF(K17=\"metric tons\",J17*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"IF(L17=\"\",M17*'Water Charges'!$C$3,M17*L17)","v":0},null,"(Select)",null,{"$f":"IF(P17=\"lbs\",O17,IF(P17=\"kg\",O17*'Conversion Factors'!$D$21,IF(P17=\"tons\",O17*'Conversion Factors'!$D$23,IF(P17=\"metric tons\",O17*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,null,"(Select)",null,{"$f":"IF(U17=\"lbs\",T17,IF(U17=\"kg\",T17*'Conversion Factors'!$D$21,IF(U17=\"tons\",T17*'Conversion Factors'!$D$23,IF(U17=\"metric tons\",T17*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,null,"(Select)",null,{"$f":"IF(Z17=\"lbs\",Y17,IF(Z17=\"kg\",Y17*'Conversion Factors'!$D$21,IF(Z17=\"tons\",Y17*'Conversion Factors'!$D$23,IF(Z17=\"metric tons\",Y17*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,null,"(Select)",null,{"$f":"IF(AE17=\"lbs\",AD17,IF(AE17=\"kg\",AD17*'Conversion Factors'!$D$21,IF(AE17=\"tons\",AD17*'Conversion Factors'!$D$23,IF(AE17=\"metric tons\",AD17*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,0]
[{"$f":"Aggregate!A15","v":"Row 7"},null,null,{"$f":"IF(C18=\"\",B18*'Water Charges'!$B$3,C18*B18)","v":0},null,"(Select)",null,{"$f":"IF(F18=\"lbs\",E18,IF(F18=\"kg\",E18*'Conversion Factors'!$D$21,IF(F18=\"tons\",E18*'Conversion Factors'!$D$23,IF(F18=\"metric tons\",E18*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"IF(G18=\"\",H18*'Water Charges'!$D$3,H18*G18)","v":0},null,"(Select)",null,{"$f":"IF(K18=\"lbs\",J18,IF(K18=\"kg\",J18*'Conversion Factors'!$D$21,IF(K18=\"tons\",J18*'Conversion Factors'!$D$23,IF(K18=\"metric tons\",J18*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"IF(L18=\"\",M18*'Water Charges'!$C$3,M18*L18)","v":0},null,"(Select)",null,{"$f":"IF(P18=\"lbs\",O18,IF(P18=\"kg\",O18*'Conversion Factors'!$D$21,IF(P18=\"tons\",O18*'Conversion Factors'!$D$23,IF(P18=\"metric tons\",O18*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,null,"(Select)",null,{"$f":"IF(U18=\"lbs\",T18,IF(U18=\"kg\",T18*'Conversion Factors'!$D$21,IF(U18=\"tons\",T18*'Conversion Factors'!$D$23,IF(U18=\"metric tons\",T18*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,null,"(Select)",null,{"$f":"IF(Z18=\"lbs\",Y18,IF(Z18=\"kg\",Y18*'Conversion Factors'!$D$21,IF(Z18=\"tons\",Y18*'Conversion Factors'!$D$23,IF(Z18=\"metric tons\",Y18*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,null,"(Select)",null,{"$f":"IF(AE18=\"lbs\",AD18,IF(AE18=\"kg\",AD18*'Conversion Factors'!$D$21,IF(AE18=\"tons\",AD18*'Conversion Factors'!$D$23,IF(AE18=\"metric tons\",AD18*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,0]
[{"$f":"Aggregate!A16","v":"Row 8"},null,null,{"$f":"IF(C19=\"\",B19*'Water Charges'!$B$3,C19*B19)","v":0},null,"(Select)",null,{"$f":"IF(F19=\"lbs\",E19,IF(F19=\"kg\",E19*'Conversion Factors'!$D$21,IF(F19=\"tons\",E19*'Conversion Factors'!$D$23,IF(F19=\"metric tons\",E19*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"IF(G19=\"\",H19*'Water Charges'!$D$3,H19*G19)","v":0},null,"(Select)",null,{"$f":"IF(K19=\"lbs\",J19,IF(K19=\"kg\",J19*'Conversion Factors'!$D$21,IF(K19=\"tons\",J19*'Conversion Factors'!$D$23,IF(K19=\"metric tons\",J19*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"IF(L19=\"\",M19*'Water Charges'!$C$3,M19*L19)","v":0},null,"(Select)",null,{"$f":"IF(P19=\"lbs\",O19,IF(P19=\"kg\",O19*'Conversion Factors'!$D$21,IF(P19=\"tons\",O19*'Conversion Factors'!$D$23,IF(P19=\"metric tons\",O19*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,null,"(Select)",null,{"$f":"IF(U19=\"lbs\",T19,IF(U19=\"kg\",T19*'Conversion Factors'!$D$21,IF(U19=\"tons\",T19*'Conversion Factors'!$D$23,IF(U19=\"metric tons\",T19*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,null,"(Select)",null,{"$f":"IF(Z19=\"lbs\",Y19,IF(Z19=\"kg\",Y19*'Conversion Factors'!$D$21,IF(Z19=\"tons\",Y19*'Conversion Factors'!$D$23,IF(Z19=\"metric tons\",Y19*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,null,"(Select)",null,{"$f":"IF(AE19=\"lbs\",AD19,IF(AE19=\"kg\",AD19*'Conversion Factors'!$D$21,IF(AE19=\"tons\",AD19*'Conversion Factors'!$D$23,IF(AE19=\"metric tons\",AD19*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,0]
[{"$f":"Aggregate!A17","v":"Row 9"},null,null,{"$f":"IF(C20=\"\",B20*'Water Charges'!$B$3,C20*B20)","v":0},null,"(Select)",null,{"$f":"IF(F20=\"lbs\",E20,IF(F20=\"kg\",E20*'Conversion Factors'!$D$21,IF(F20=\"tons\",E20*'Conversion Factors'!$D$23,IF(F20=\"metric tons\",E20*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"IF(G20=\"\",H20*'Water Charges'!$D$3,H20*G20)","v":0},null,"(Select)",null,{"$f":"IF(K20=\"lbs\",J20,IF(K20=\"kg\",J20*'Conversion Factors'!$D$21,IF(K20=\"tons\",J20*'Conversion Factors'!$D$23,IF(K20=\"metric tons\",J20*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"IF(L20=\"\",M20*'Water Charges'!$C$3,M20*L20)","v":0},null,"(Select)",null,{"$f":"IF(P20=\"lbs\",O20,IF(P20=\"kg\",O20*'Conversion Factors'!$D$21,IF(P20=\"tons\",O20*'Conversion Factors'!$D$23,IF(P20=\"metric tons\",O20*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,null,"(Select)",null,{"$f":"IF(U20=\"lbs\",T20,IF(U20=\"kg\",T20*'Conversion Factors'!$D$21,IF(U20=\"tons\",T20*'Conversion Factors'!$D$23,IF(U20=\"metric tons\",T20*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,null,"(Select)",null,{"$f":"IF(Z20=\"lbs\",Y20,IF(Z20=\"kg\",Y20*'Conversion Factors'!$D$21,IF(Z20=\"tons\",Y20*'Conversion Factors'!$D$23,IF(Z20=\"metric tons\",Y20*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,null,"(Select)",null,{"$f":"IF(AE20=\"lbs\",AD20,IF(AE20=\"kg\",AD20*'Conversion Factors'!$D$21,IF(AE20=\"tons\",AD20*'Conversion Factors'!$D$23,IF(AE20=\"metric tons\",AD20*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,0]
[{"$f":"Aggregate!A18","v":"Row 10"},null,null,{"$f":"IF(C21=\"\",B21*'Water Charges'!$B$3,C21*B21)","v":0},null,"(Select)",null,{"$f":"IF(F21=\"lbs\",E21,IF(F21=\"kg\",E21*'Conversion Factors'!$D$21,IF(F21=\"tons\",E21*'Conversion Factors'!$D$23,IF(F21=\"metric tons\",E21*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"IF(G21=\"\",H21*'Water Charges'!$D$3,H21*G21)","v":0},null,"(Select)",null,{"$f":"IF(K21=\"lbs\",J21,IF(K21=\"kg\",J21*'Conversion Factors'!$D$21,IF(K21=\"tons\",J21*'Conversion Factors'!$D$23,IF(K21=\"metric tons\",J21*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"IF(L21=\"\",M21*'Water Charges'!$C$3,M21*L21)","v":0},null,"(Select)",null,{"$f":"IF(P21=\"lbs\",O21,IF(P21=\"kg\",O21*'Conversion Factors'!$D$21,IF(P21=\"tons\",O21*'Conversion Factors'!$D$23,IF(P21=\"metric tons\",O21*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,null,"(Select)",null,{"$f":"IF(U21=\"lbs\",T21,IF(U21=\"kg\",T21*'Conversion Factors'!$D$21,IF(U21=\"tons\",T21*'Conversion Factors'!$D$23,IF(U21=\"metric tons\",T21*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,null,"(Select)",null,{"$f":"IF(Z21=\"lbs\",Y21,IF(Z21=\"kg\",Y21*'Conversion Factors'!$D$21,IF(Z21=\"tons\",Y21*'Conversion Factors'!$D$23,IF(Z21=\"metric tons\",Y21*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,null,"(Select)",null,{"$f":"IF(AE21=\"lbs\",AD21,IF(AE21=\"kg\",AD21*'Conversion Factors'!$D$21,IF(AE21=\"tons\",AD21*'Conversion Factors'!$D$23,IF(AE21=\"metric tons\",AD21*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},0,0]
[{"$f":"Aggregate!A19","v":"Row 11"},null,null,{"$f":"IF(C22=\"\",B22*'Water Charges'!$B$3,C22*B22)","v":0},null,"(Select)",null,{"$f":"IF(F22=\"lbs\",E22,IF(F22=\"kg\",E22*'Conversion Factors'!$D$21,IF(F22=\"tons\",E22*'Conversion Factors'!$D$23,IF(F22=\"metric tons\",E22*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"IF(G22=\"\",H22*'Water Charges'!$D$3,H22*G22)","v":0},null,"(Select)",null,{"$f":"IF(K22=\"lbs\",J22,IF(K22=\"kg\",J22*'Conversion Factors'!$D$21,IF(K22=\"tons\",J22*'Conversion Factors'!$D$23,IF(K22=\"metric tons\",J22*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"IF(L22=\"\",M22*'Water Charges'!$C$3,M22*L22)","v":0},null,"(Select)",null,{"$f":"IF(P22=\"lbs\",O22,IF(P22=\"kg\",O22*'Conversion Factors'!$D$21,IF(P22=\"tons\",O22*'Conversion Factors'!$D$23,IF(P22=\"metric tons\",O22*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"O22*Q22","v":0},null,"(Select)",null,{"$f":"IF(U22=\"lbs\",T22,IF(U22=\"kg\",T22*'Conversion Factors'!$D$21,IF(U22=\"tons\",T22*'Conversion Factors'!$D$23,IF(U22=\"metric tons\",T22*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"T22*V22","v":0},null,"(Select)",null,{"$f":"IF(Z22=\"lbs\",Y22,IF(Z22=\"kg\",Y22*'Conversion Factors'!$D$21,IF(Z22=\"tons\",Y22*'Conversion Factors'!$D$23,IF(Z22=\"metric tons\",Y22*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"Y22*AA22","v":0},null,"(Select)",null,{"$f":"IF(AE22=\"lbs\",AD22,IF(AE22=\"kg\",AD22*'Conversion Factors'!$D$21,IF(AE22=\"tons\",AD22*'Conversion Factors'!$D$23,IF(AE22=\"metric tons\",AD22*'Conversion Factors'!$D$22/'Conversion Factors'!$D$20,0))))","v":0},{"$f":"AD22*AF22","v":0},0]
[]
["Color Key",null,null,null,null,null,null,null,"lbs",null,null,null,null,"lbs"]
["Enter value",null,null,null,null,null,null,null,"kg",null,null,null,null,"kg"]
["Use drop-down menu",null,null,null,null,null,null,null,"tons",null,null,null,null,"tons"]
["Do not change - calculation",null,null,null,null,null,null,null,"metric tons"]
[]
["Sources"]
["BOD/COD","AWWA 2019 Rate Survey. Exhibit 6.","National Average is used."]
["TOTAL SUSPENDED SOLIDS (TSS)","AWWA 2019 Rate Survey. Exhibit 6.","National Average is used."]
["FATS, OILS, AND GREASE (FOG)","NA\n","Cost values not currently available."]
["TOXICS","NA\n","Cost values not currently available."]
["NUTRIENTS","NA\n","Cost values not currently available."]
["WASTEWATER DISCHARGE","AWWA 2019 Rate Survey, Exhibits 5.","Data presented for Commercial Light Industrial Category with 2-inch meter pipe. National Average is used."]

{"sheet":"Haz Inputs & Wastes","index":6,"n_rows":36,"n_cols":17,"rows_kept":36,"cut":false,"hidden":false,"merged":[[9,0,10,0],[9,5,9,8],[9,1,9,4],[9,9,9,12],[0,1,0,16],[4,13,4,16],[6,0,7,0],[4,5,4,8],[5,1,5,4],[5,5,5,8],[9,13,9,16],[1,1,1,8],[3,13,3,16],[3,9,3,12],[3,5,3,8],[4,1,4,4],[5,13,5,16],[31,1,31,5],[11,14,11,15],[11,10,11,11],[11,6,11,7],[11,2,11,3],[4,9,4,12],[2,4,2,8],[3,1,3,4],[5,9,5,12],[35,1,35,5],[33,1,33,5],[32,1,32,5],[34,1,34,5]]}
[null,"Hazardous Inputs & Wastes"]
[null,"This tab computes dollar savings from reducing hazardous inputs and hazardous waste.  "]
[]
["Type of Reduction","Hazardous Input Reduction",null,null,null,"Hazardous Waste Reduction - \nAverage across management methods",null,null,null,"Hazardous Waste Reduction - Landfill",null,null,null,"Hazardous Waste Reduction - Incineration"]
["\nHow to use this tab","Enter the quantity and unit of hazardous input reduced, and a unit cost. Savings appear on the right.  ",null,null,null,"Work here if you don't know where the hazardous waste would have been managed (i.e., landfilled or incinerated). Enter the quantity reduced and a unit. Enter the unit cost, if known. The \"Dollar Savings\" column shows savings based on the unit cost entered, or on an average of the default unit cost of landfill and incineration.     ",null,null,null,"Enter the quantity and unit of hazardous waste that would have been landfilled. Enter the unit cost, if known. The \"Dollar Savings\" column shows savings based on your unit cost or the national default unit cost.  ",null,null,null,"Enter the quantity and unit of hazardous waste that would have been incinerated. Enter the unit cost, if known. The \"Dollar Savings\" column shows savings based on your unit cost or the national default unit cost."]
["Calculation Description","Quantity of hazardous input reduced (in user-specified units) * user-specified unit cost = Dollars saved",null,null,null,"Quantity of hazardous waste no longer disposed (in user-specified unit) * default unit cost = Dollars saved",null,null,null,"Quantity of hazardous waste no longer landfilled (in user-specified units) * unit cost (user-specified or default) = Dollars saved.  \n",null,null,null,"Quantity of hazardous waste no longer incinerated (in user-specified units) * unit cost (user-specified or default) = Dollars saved."]
["Default Unit Cost ($)",null,null,null,null,2.09,"/lbs",null,null,1.57,"/lbs",null,null,2.57,"/lbs"]
[null,null,null,null,null,17.350000000000001,"/gal",null,null,13.03,"/gal",null,null,21.33,"/gal"]
[null,"Reduced Quantity of Haz. Inputs","Unit \n(select)","Unit Cost ($/unit selected)","Dollar Savings ","Reduced Quantity of Waste","Unit \n(select)","Unit Cost ($/unit selected)","Dollar Savings ","Reduced Quantity of Waste","Unit \n(select)","Unit Cost ($/unit selected)","Dollar Savings","Reduced Quantity of Waste","Unit \n(select)","Unit Cost ($/unit selected)","Dollar Savings"]
["Example","A cutlery manufacturer replaced trichloroethylene (TCE) for cleaning with aqueous wash boxes and an alcohol-based vapor degreaser.",null,null,null,"New process reduces 55-gallon waste drums annually from 100 to 20."]
[null,110000,"lbs",2.25,247500,4400,"gal",null,{"$f":"IF(G11=\"lbs\",F11*$F$7,IF(G11=\"gal\",F11*$F$8,0))","v":76340}]
["Totals - All Rows",{"$f":"SUMIF(C$14:C$24,\"gal\",B$14:B$24)&\" gal\"&\"; \"&SUMIF(C$14:C$24,\"lbs\",B$14:B$24)&\" lbs\"","v":"0 gal; 0 lbs"},null,null,{"$f":"SUM(E14:E24)","v":0},{"$f":"SUMIF(G$14:G$24,\"gal\",F$14:F$24)&\" gal\"&\"; \"&SUMIF(G$14:G$24,\"lbs\",F$14:F$24)&\" lbs\"","v":"0 gal; 0 lbs"},null,null,{"$f":"SUM(I14:I24)","v":0},{"$f":"SUMIF(K$14:K$24,\"gal\",J$14:J$24)&\" gal\"&\"; \"&SUMIF(K$14:K$24,\"lbs\",J$14:J$24)&\" lbs\"","v":"0 gal; 0 lbs"},null,null,{"$f":"SUM(M14:M24)","v":0},{"$f":"SUMIF(O$14:O$24,\"gal\",N$14:N$24)&\" gal\"&\"; \"&SUMIF(O$14:O$24,\"lbs\",N$14:N$24)&\" lbs\"","v":"0 gal; 0 lbs"},null,null,{"$f":"SUM(Q14:Q24)","v":0}]
[]
[{"$f":"Aggregate!A9","v":"Row 1"},null,"(Select)",null,{"$f":"B14*D14","v":0},null,"(Select)",null,{"$f":"IF(AND(H14=\"\",G14=\"lbs\"),F14*$F$7,IF(AND(H14=\"\",G14=\"gal\"),F14*$F$8,F14*H14))","v":0},null,"(Select)",null,{"$f":"IF(AND(L14=\"\",K14=\"lbs\"),J14*$J$7,IF(AND(L14=\"\",K14=\"gal\"),J14*$J$8,J14*L14))","v":0},null,"(Select)",null,{"$f":"IF(AND(P14=\"\",O14=\"lbs\"),N14*$N$7,IF(AND(P14=\"\",O14=\"gal\"),N14*$N$8,N14*P14))","v":0}]
[{"$f":"Aggregate!A10","v":"Row 2"},null,"(Select)",null,{"$f":"B15*D15","v":0},null,"(Select)",null,{"$f":"IF(AND(H15=\"\",G15=\"lbs\"),F15*$F$7,IF(AND(H15=\"\",G15=\"gal\"),F15*$F$8,F15*H15))","v":0},null,"(Select)",null,{"$f":"IF(AND(L15=\"\",K15=\"lbs\"),J15*$J$7,IF(AND(L15=\"\",K15=\"gal\"),J15*$J$8,J15*L15))","v":0},null,"(Select)",null,{"$f":"IF(AND(P15=\"\",O15=\"lbs\"),N15*$N$7,IF(AND(P15=\"\",O15=\"gal\"),N15*$N$8,N15*P15))","v":0}]
[{"$f":"Aggregate!A11","v":"Row 3"},null,"(Select)",null,0,null,"(Select)",null,0,null,"(Select)",null,0,null,"(Select)",null,0]
[{"$f":"Aggregate!A12","v":"Row 4"},null,"(Select)",null,0,null,"(Select)",null,0,null,"(Select)",null,0,null,"(Select)",null,0]
[{"$f":"Aggregate!A13","v":"Row 5"},null,"(Select)",null,0,null,"(Select)",null,0,null,"(Select)",null,0,null,"(Select)",null,0]
[{"$f":"Aggregate!A14","v":"Row 6"},null,"(Select)",null,0,null,"(Select)",null,0,null,"(Select)",null,0,null,"(Select)",null,0]
[{"$f":"Aggregate!A15","v":"Row 7"},null,"(Select)",null,0,null,"(Select)",null,0,null,"(Select)",null,0,null,"(Select)",null,0]
[{"$f":"Aggregate!A16","v":"Row 8"},null,"(Select)",null,0,null,"(Select)",null,0,null,"(Select)",null,0,null,"(Select)",null,0]
[{"$f":"Aggregate!A17","v":"Row 9"},null,"(Select)",null,0,null,"(Select)",null,0,null,"(Select)",null,0,null,"(Select)",null,0]
[{"$f":"Aggregate!A18","v":"Row 10"},null,"(Select)",null,0,null,"(Select)",null,0,null,"(Select)",null,0,null,"(Select)",null,0]
[{"$f":"Aggregate!A19","v":"Row 11"},null,"(Select)",null,{"$f":"B24*D24","v":0},null,"(Select)",null,{"$f":"IF(AND(H24=\"\",G24=\"lbs\"),F24*$F$7,IF(AND(H24=\"\",G24=\"gal\"),F24*$F$8,F24*H24))","v":0},null,"(Select)",null,{"$f":"IF(AND(L24=\"\",K24=\"lbs\"),J24*$J$7,IF(AND(L24=\"\",K24=\"gal\"),J24*$J$8,J24*L24))","v":0},null,"(Select)",null,{"$f":"IF(AND(P24=\"\",O24=\"lbs\"),N24*$N$7,IF(AND(P24=\"\",O24=\"gal\"),N24*$N$8,N24*P24))","v":0}]
[]
["Color Key"]
["Enter value"]
["Use drop-down menu"]
["Do not change - calculation"]
[]
[" Sources"]
["HAZARDOUS INPUT REDUCTION","Will vary - user provides source."]
["HAZARDOUS INPUT SUBSTITUTION","Will vary - user provides source."]
["HAZARDOUS WASTE REDUCTION- AVERAGE","1) EPA, Unit Cost Compendium (UCC), 2011.\n2) 2017 RCRA Biennial Report\n3) Regulatory Impact Analysis (RIA) for USEPA’s 2008 Final Rule Amendments to the Industrial Recycling Exclusions of the RCRA Definition of Solid Waste (Sep 25, 2008)\n4) Dept. of Defense Environmental Cost Analysis Methodology (ECAM) Handbook (Mar 29, 1999).\n\nSee the \"References & Justification\" tab for more information."]
["HAZARDOUS WASTE REDUCTION-LANDFILL","1) EPA, Unit Cost Compendium (UCC), 2011. \n2) 2017 RCRA Biennial Report\n3) Regulatory Impact Analysis (RIA) for USEPA’s 2008 Final Rule Amendments to the Industrial Recycling Exclusions of the RCRA Definition of Solid Waste (Sep 25, 2008)\n4) Dept. of Defense Environmental Cost Analysis Methodology (ECAM) Handbook (Mar 29, 1999). \n\nSee the \"References & Justification\" tab for more information."]
["HAZARDOUS WASTE REDUCTION- INCINERATION","1) EPA, Unit Cost Compendium (UCC), 2011. \n2) 2017 RCRA Biennial Report\n3) Regulatory Impact Analysis (RIA) for USEPA’s 2008 Final Rule Amendments to the Industrial Recycling Exclusions of the RCRA Definition of Solid Waste (Sep 25, 2008)\n4) Dept. of Defense Environmental Cost Analysis Methodology (ECAM) Handbook (Mar 29, 1999). \n\nSee the \"References & Justification\" tab for more information."]

{"sheet":"Air Emissions","index":7,"n_rows":136,"n_cols":15,"rows_kept":136,"cut":false,"hidden":false,"merged":[[1,1,1,5],[5,7,5,10],[5,11,5,14],[4,7,4,14],[5,4,5,5],[5,2,5,3],[3,2,3,3],[30,2,30,3],[7,0,8,0],[3,4,3,5],[4,4,4,5],[4,2,4,3],[7,4,7,5],[7,2,7,3]]}
[null,"Air Emissions"]
[null,"This tab computes cost savings for permitted facilities that reduce onsite air emissions. \nThe columns for Criteria Pollutants and HAPs use state emission-tonnage fees to show cost savings from reducing emissions. \nThe Other Permitting Fees column has fields to enter avoided permit maintenance or renewal fees when a facility so lowers its emissions that it can get a cheaper permit or skip permitting entirely. "]
[]
["Type of Reduction",null,"Hazardous Air Pollutants (HAPs)",null,"Clean Air Act Title V Criteria Air Pollutants \n(including Nitrogen Oxides (NOX), Sulfur Oxides (SOX), \nParticulate Matter of 10 micrometers or less (PM10), Volatile Organic Compounds (VOCs)) ",null,"Other Permitting Fees"]
["\nHow to use this tab",null,"Select a State or US National default for where emissions were abated.  Enter the quantity and unit of HAPs reduced. Savings will be on the right.",null,"Select a state or national default for where emissions were abated. Enter the quantity and unit of air pollutants reduced. Savings will be on the right. ",null,"If air emissions reductions have eliminated or reduced the costs for permit renewal or maintenance, enter the value for fees saved.   ","VLOOKUP Category"]
["Calculation Description",null,"Quantity of reduced HAPs (tons) * state or national unit cost ($/tons) = Dollars saved.",null,"Quantity of reduced Criteria Air Pollutants (tons) * state or national unit cost ($/tons) = Dollars saved.",null,null,"CAPs",null,null,null,"HAPs"]
[null,"State or U.S. \n(select)","Quantity HAPs\n Reduced (tons)","Dollar Savings","Reduced Quantity of Criteria Pollutants Reduced (tons)","Dollar Savings","Dollar Savings"]
["Example",null,"A cutlery manufacturer replaced trichloroethylene (TCE) for cleaning with aqueous wash boxes and an alcohol-based vapor degreaser. Over three years, TCE air emissions fell from 110,000 pounds (55 tons) to zero.",null,"A furniture manufacturer in New Hampshire switched to lower VOC paints."]
[null,"NH",55,{"$f":"IF($O9=\"\",0,VLOOKUP($O9,sthaps,4,FALSE)*$C9)","v":8985.9},1,{"$f":"IF($K9=\"\",0,VLOOKUP($K9,stcaps,4,FALSE)*$E9)","v":163.38},null,{"$f":"IF(VLOOKUP($B9,stairemiss,3,FALSE)<>3,\"\",IF(VLOOKUP($B9,blockstates,2,FALSE)<>1,\"\",IF($E9<VLOOKUP($B9,blockstates,3,FALSE),$B9&\"_<\"&VLOOKUP($B9,blockstates,3,FALSE),$B9&\"_>=\"&VLOOKUP($B9,blockstates,3,FALSE))))","v":""},{"$f":"IF(VLOOKUP($B9,stairemiss,3,FALSE)<>3,\"\",IF(VLOOKUP($B9,blockstates,2,FALSE)<>2,\"\",IF($E9<VLOOKUP($B9,blockstates,3,FALSE),$B9&\"_<\"&VLOOKUP($B9,blockstates,3,FALSE),IF($E9<VLOOKUP($B9,blockstates,4,FALSE),$B9&\"_\"&VLOOKUP($B9,blockstates,3,FALSE)&\"-\"&VLOOKUP($B9,blockstates,4,FALSE),$B9&\"_>=\"&VLOOKUP($B9,blockstates,4,FALSE)))))","v":""},{"$f":"IF(VLOOKUP($B9,stairemiss,3,FALSE)<>3,\"\",IF(VLOOKUP($B9,blockstates,2,FALSE)<>3,\"\",IF($E9<VLOOKUP($B9,blockstates,3,FALSE),$B9&\"_<\"&VLOOKUP($B9,blockstates,3,FALSE),IF($E9<VLOOKUP($B9,blockstates,4,FALSE),$B9&\"_\"&VLOOKUP($B9,blockstates,3,FALSE)&\"-\"&VLOOKUP($B9,blockstates,4,FALSE),IF($E9<VLOOKUP($B9,blockstates,5,FALSE),$B9&\"_\"&VLOOKUP($B9,blockstates,4,FALSE)&\"-\"&VLOOKUP($B9,blockstates,5,FALSE),$B9&\"_>=\"&VLOOKUP($B9,blockstates,5,FALSE))))))","v":""},{"$f":"IF(B9=\"(Select)\",\"\",IF(VLOOKUP($B9,stairemiss,3,FALSE)=1,$B9,IF(VLOOKUP($B9,stairemiss,3,FALSE)=2,\"National\",IF($H9<>\"\",$H9,IF($I9<>\"\",$I9,$J9)))))","v":"NH"},{"$f":"IF(VLOOKUP($B9,stairemiss,8,FALSE)<>3,\"\",IF(VLOOKUP($B9,blockstates_haps,2,FALSE)<>1,\"\",IF($C9<VLOOKUP($B9,blockstates_haps,3,FALSE),$B9&\"_<\"&VLOOKUP($B9,blockstates_haps,3,FALSE),$B9&\"_>=\"&VLOOKUP($B9,blockstates_haps,3,FALSE))))","v":""},{"$f":"IF(VLOOKUP($B9,stairemiss,8,FALSE)<>3,\"\",IF(VLOOKUP($B9,blockstates_haps,2,FALSE)<>2,\"\",IF($C9<VLOOKUP($B9,blockstates_haps,3,FALSE),$B9&\"_<\"&VLOOKUP($B9,blockstates_haps,3,FALSE),IF($C9<VLOOKUP($B9,blockstates_haps,4,FALSE),$B9&\"_\"&VLOOKUP($B9,blockstates_haps,3,FALSE)&\"-\"&VLOOKUP($B9,blockstates_haps,4,FALSE),$B9&\"_>=\"&VLOOKUP($B9,blockstates_haps,4,FALSE)))))","v":""},{"$f":"IF(VLOOKUP($B9,stairemiss,8,FALSE)<>3,\"\",IF(VLOOKUP($B9,blockstates_haps,2,FALSE)<>3,\"\",IF($C9<VLOOKUP($B9,blockstates_haps,3,FALSE),$B9&\"_<\"&VLOOKUP($B9,blockstates_haps,3,FALSE),IF($C9<VLOOKUP($B9,blockstates_haps,4,FALSE),$B9&\"_\"&VLOOKUP($B9,blockstates_haps,3,FALSE)&\"-\"&VLOOKUP($B9,blockstates_haps,4,FALSE),IF($C9<VLOOKUP($B9,blockstates_haps,5,FALSE),$B9&\"_\"&VLOOKUP($B9,blockstates_haps,4,FALSE)&\"-\"&VLOOKUP($B9,blockstates_haps,5,FALSE),$B9&\"_>=\"&VLOOKUP($B9,blockstates_haps,5,FALSE))))))","v":""},{"$f":"IF(B9=\"(Select)\",\"\",IF(VLOOKUP($B9,stairemiss,3,FALSE)=1,$B9,IF(VLOOKUP($B9,stairemiss,3,FALSE)=2,\"National\",IF($L9<>\"\",$L9,IF($M9<>\"\",$M9,$N9)))))","v":"NH"}]
[]
["Totals - All Rows",null,null,{"$f":"SUM(D13:D23)","v":0},null,{"$f":"SUM(F13:F23)","v":0}]
[]
[{"$f":"Aggregate!A9","v":"Row 1"},"(Select)",null,{"$f":"IF($O13=\"\",0,VLOOKUP($O13,sthaps,4,FALSE)*$C13)","v":0},null,{"$f":"IF($K13=\"\",0,VLOOKUP($K13,stcaps,4,FALSE)*$E13)","v":0},null,{"$f":"IF(VLOOKUP($B13,stairemiss,3,FALSE)<>3,\"\",IF(VLOOKUP($B13,blockstates,2,FALSE)<>1,\"\",IF($E13<VLOOKUP($B13,blockstates,3,FALSE),$B13&\"_<\"&VLOOKUP($B13,blockstates,3,FALSE),$B13&\"_>=\"&VLOOKUP($B13,blockstates,3,FALSE))))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B13,stairemiss,3,FALSE)<>3,\"\",IF(VLOOKUP($B13,blockstates,2,FALSE)<>2,\"\",IF($E13<VLOOKUP($B13,blockstates,3,FALSE),$B13&\"_<\"&VLOOKUP($B13,blockstates,3,FALSE),IF($E13<VLOOKUP($B13,blockstates,4,FALSE),$B13&\"_\"&VLOOKUP($B13,blockstates,3,FALSE)&\"-\"&VLOOKUP($B13,blockstates,4,FALSE),$B13&\"_>=\"&VLOOKUP($B13,blockstates,4,FALSE)))))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B13,stairemiss,3,FALSE)<>3,\"\",IF(VLOOKUP($B13,blockstates,2,FALSE)<>3,\"\",IF($E13<VLOOKUP($B13,blockstates,3,FALSE),$B13&\"_<\"&VLOOKUP($B13,blockstates,3,FALSE),IF($E13<VLOOKUP($B13,blockstates,4,FALSE),$B13&\"_\"&VLOOKUP($B13,blockstates,3,FALSE)&\"-\"&VLOOKUP($B13,blockstates,4,FALSE),IF($E13<VLOOKUP($B13,blockstates,5,FALSE),$B13&\"_\"&VLOOKUP($B13,blockstates,4,FALSE)&\"-\"&VLOOKUP($B13,blockstates,5,FALSE),$B13&\"_>=\"&VLOOKUP($B13,blockstates,5,FALSE))))))","v":{"$error":"#N/A"}},{"$f":"IF(B13=\"(Select)\",\"\",IF(VLOOKUP($B13,stairemiss,3,FALSE)=1,$B13,IF(VLOOKUP($B13,stairemiss,3,FALSE)=2,\"National\",IF($H13<>\"\",$H13,IF($I13<>\"\",$I13,$J13)))))","v":""},{"$f":"IF(VLOOKUP($B13,stairemiss,8,FALSE)<>3,\"\",IF(VLOOKUP($B13,blockstates_haps,2,FALSE)<>1,\"\",IF($C13<VLOOKUP($B13,blockstates_haps,3,FALSE),$B13&\"_<\"&VLOOKUP($B13,blockstates_haps,3,FALSE),$B13&\"_>=\"&VLOOKUP($B13,blockstates_haps,3,FALSE))))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B13,stairemiss,8,FALSE)<>3,\"\",IF(VLOOKUP($B13,blockstates_haps,2,FALSE)<>2,\"\",IF($C13<VLOOKUP($B13,blockstates_haps,3,FALSE),$B13&\"_<\"&VLOOKUP($B13,blockstates_haps,3,FALSE),IF($C13<VLOOKUP($B13,blockstates_haps,4,FALSE),$B13&\"_\"&VLOOKUP($B13,blockstates_haps,3,FALSE)&\"-\"&VLOOKUP($B13,blockstates_haps,4,FALSE),$B13&\"_>=\"&VLOOKUP($B13,blockstates_haps,4,FALSE)))))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B13,stairemiss,8,FALSE)<>3,\"\",IF(VLOOKUP($B13,blockstates_haps,2,FALSE)<>3,\"\",IF($C13<VLOOKUP($B13,blockstates_haps,3,FALSE),$B13&\"_<\"&VLOOKUP($B13,blockstates_haps,3,FALSE),IF($C13<VLOOKUP($B13,blockstates_haps,4,FALSE),$B13&\"_\"&VLOOKUP($B13,blockstates_haps,3,FALSE)&\"-\"&VLOOKUP($B13,blockstates_haps,4,FALSE),IF($C13<VLOOKUP($B13,blockstates_haps,5,FALSE),$B13&\"_\"&VLOOKUP($B13,blockstates_haps,4,FALSE)&\"-\"&VLOOKUP($B13,blockstates_haps,5,FALSE),$B13&\"_>=\"&VLOOKUP($B13,blockstates_haps,5,FALSE))))))","v":{"$error":"#N/A"}},{"$f":"IF(B13=\"(Select)\",\"\",IF(VLOOKUP($B13,stairemiss,3,FALSE)=1,$B13,IF(VLOOKUP($B13,stairemiss,3,FALSE)=2,\"National\",IF($L13<>\"\",$L13,IF($M13<>\"\",$M13,$N13)))))","v":""}]
[{"$f":"Aggregate!A10","v":"Row 2"},"(Select)",null,0,null,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(B14=\"(Select)\",\"\",IF(VLOOKUP($B14,stairemiss,3,FALSE)=1,$B14,IF(VLOOKUP($B14,stairemiss,3,FALSE)=2,\"National\",IF($H14<>\"\",$H14,IF($I14<>\"\",$I14,$J14)))))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(B14=\"(Select)\",\"\",IF(VLOOKUP($B14,stairemiss,3,FALSE)=1,$B14,IF(VLOOKUP($B14,stairemiss,3,FALSE)=2,\"National\",IF($L14<>\"\",$L14,IF($M14<>\"\",$M14,$N14)))))","v":""}]
[{"$f":"Aggregate!A11","v":"Row 3"},"(Select)",null,0,null,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},""]
[{"$f":"Aggregate!A12","v":"Row 4"},"(Select)",null,0,null,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},""]
[{"$f":"Aggregate!A13","v":"Row 5"},"(Select)",null,0,null,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},""]
[{"$f":"Aggregate!A14","v":"Row 6"},"(Select)",null,0,null,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},""]
[{"$f":"Aggregate!A15","v":"Row 7"},"(Select)",null,0,null,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},""]
[{"$f":"Aggregate!A16","v":"Row 8"},"(Select)",null,0,null,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},""]
[{"$f":"Aggregate!A17","v":"Row 9"},"(Select)",null,0,null,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},""]
[{"$f":"Aggregate!A18","v":"Row 10"},"(Select)",null,0,null,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},""]
[{"$f":"Aggregate!A19","v":"Row 11"},"(Select)",null,0,null,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(B23=\"(Select)\",\"\",IF(VLOOKUP($B23,stairemiss,3,FALSE)=1,$B23,IF(VLOOKUP($B23,stairemiss,3,FALSE)=2,\"National\",IF($H23<>\"\",$H23,IF($I23<>\"\",$I23,$J23)))))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(B23=\"(Select)\",\"\",IF(VLOOKUP($B23,stairemiss,3,FALSE)=1,$B23,IF(VLOOKUP($B23,stairemiss,3,FALSE)=2,\"National\",IF($L23<>\"\",$L23,IF($M23<>\"\",$M23,$N23)))))","v":""}]
[]
["Color Key"]
["Enter value"]
["Use drop-down menu"]
["Do not change - calculation"]
[]
["Sources"]
["AIR EMISSIONS","2008-2010 State Data","Data for the following 5 states was not available for this survey: Louisiana, Massachusetts, Rhode Island, South Dakota, Utah. Delaware reportedly determines rates on a case-by-case basis. Where state data was not available, the national average was used.  It should also be noted that the majority of Nevada's fee revenue comes from \"maintenance fees\" as opposed to \"emissions fees,\" unlike most states; for example, a Major Source with a Title V permit pays the $16.00/ton plus a $20,000 base fee."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"U.S. National"]
[null,"AK"]
[null,"AL"]
[null,"AR"]
[null,"AZ"]
[null,"CA"]
[null,"CO"]
[null,"CT"]
[null,"DC"]
[null,"DE"]
[null,"FL"]
[null,"GA"]
[null,"HI"]
[null,"IA"]
[null,"ID"]
[null,"IL"]
[null,"IN"]
[null,"KS"]
[null,"KY"]
[null,"LA"]
[null,"MA"]
[null,"MD"]
[null,"ME"]
[null,"MI"]
[null,"MN"]
[null,"MO"]
[null,"MS"]
[null,"MT"]
[null,"NC"]
[null,"ND"]
[null,"NE"]
[null,"NH"]
[null,"NJ"]
[null,"NM"]
[null,"NV"]
[null,"NY"]
[null,"OH"]
[null,"OK"]
[null,"OR"]
[null,"PA"]
[null,"RI"]
[null,"SC"]
[null,"SD"]
[null,"TN"]
[null,"TX"]
[null,"UT"]
[null,"VA"]
[null,"VT"]
[null,"WA"]
[null,"WI"]
[null,"WV"]
[null,"WY"]

{"sheet":"Non-Haz Inputs","index":8,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,1,30,4],[9,2,9,3],[0,0,2,0],[3,1,3,4],[6,0,7,0],[5,1,5,4],[6,1,7,4],[4,1,4,4],[1,1,1,3],[29,1,29,4]]}
[null,"Non-Hazardous Inputs"]
[null,"This tab computes cost savings from reducing non-hazardous inputs."]
[]
["Type of Reduction","Reducing Non-Hazardous Inputs"]
["How to use this tab","Enter the quantity and unit of input reduced, and enter the unit cost. Savings appear on the right. "]
["Calculation Description","Quantity of input reduced * Unit Cost (user specified value) = Dollars saved."]
["Default Unit Cost"]
[]
[null,"Reduced Inputs Quantity ","Unit (select)","Unit Cost ($/unit selected)","Dollar Savings"]
["Totals - All Rows",{"$f":"SUMIF(C12:C22,\"lbs\",B12:B22)&\" lbs\"&\"; \"&SUMIF(C12:C22,\"gal\",B12:B22)&\" gal\"&\"; \"&SUMIF(C12:C22,\"tons\",B12:B22)&\" tons\"&\"; \"&SUMIF(C12:C22,\"kg\",B12:B22)&\" kg\"","v":"0 lbs; 0 gal; 0 tons; 0 kg"},null,null,{"$f":"SUM(E12:E22)","v":0}]
[]
[{"$f":"Aggregate!A9","v":"Row 1"},null,"(Select)",null,{"$f":"B12*D12","v":0}]
[{"$f":"Aggregate!A10","v":"Row 2"},null,"(Select)",null,{"$f":"B13*D13","v":0}]
[{"$f":"Aggregate!A11","v":"Row 3"},null,"(Select)",null,0]
[{"$f":"Aggregate!A12","v":"Row 4"},null,"(Select)",null,0]
[{"$f":"Aggregate!A13","v":"Row 5"},null,"(Select)",null,0]
[{"$f":"Aggregate!A14","v":"Row 6"},null,"(Select)",null,0]
[{"$f":"Aggregate!A15","v":"Row 7"},null,"(Select)",null,0]
[{"$f":"Aggregate!A16","v":"Row 8"},null,"(Select)",null,0]
[{"$f":"Aggregate!A17","v":"Row 9"},null,"(Select)",null,0]
[{"$f":"Aggregate!A18","v":"Row 10"},null,"(Select)",null,0]
[{"$f":"Aggregate!A19","v":"Row 11"},null,"(Select)",null,{"$f":"B22*D22","v":0}]
[]
["Color Key"]
["Enter value"]
["Use drop-down menu"]
["Do not change - calculation"]
[]
[" Sources"]
["NON-HAZARDOUS INPUT REDUCTION","Will vary - user provides"]
["SOLID WASTE","Waste Business Journal, 2019."]

{"sheet":"Glossary","index":9,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":false,"merged":[[14,0,14,1],[6,0,6,1],[4,0,4,1],[2,0,2,1],[13,0,13,1],[8,0,8,1],[9,0,9,1],[11,0,11,1]]}
["Glossary"]
["Fuel"]
["Any material that is combusted for energy, such as: natural gas, gasoline or diesel, other fuels (heating oil, jet fuel etc.). Electricity has its own tab to account for offsetting the higher prices often associated with purchasing electricity from a green source."]
["Water Use"]
["Reductions of incoming water from outside sources through the implementation of a P2 activity. Reductions can occur through operations, facility use and grounds maintenance."]
["Water Pollution"]
["Wastewater Discharges refers to wastewater sent off site to a wastewater treatment plant, sometimes called publicly owned treatment plants. The first cost formula is for the basic fee charged by a treatment plant for treating waste water on a per gallon basis. Currently, the cost for toxics and nutrients in water discharges is not known, therefore costs can only be calculated when the user enters a cost value."]
["Hazardous Inputs and Wastes"]
["Hazardous inputs are hazardous materials used as process inputs (chemical ingredients, paints, and solvents) and hazardous products applied to land (such as pesticides and nutrients applied, etc.). "]
["Hazardous wastes are those listed at the state and/or federal level as hazardous or toxic or meeting the criteria for ignitability, toxicity, corrosiveness or reactivity) Excluded: Non-hazardous waste (solid waste, construction debris, packaging, paper, glass and aluminum cans) "]
["Air Emissions"]
["Air Emissions are defined to include the release of any of the following: \nNitrogen Oxides (NOX), Sulfur Oxides (SOX), Particulate Matter of 10 micrometers or less (PM10), Volatile Organic Compounds (VOCs), and hazardous air pollutants (HAP). Please note that this covers pollutants to air, including SOx and NOx from boilers but excludes SOx or NOx from utilities (due to cap and trade limitations). The cost for CO2 emissions are not yet assessed or available."]
["Non-Hazardous Inputs"]
["Process input supplies and feedstocks that are not toxic or hazardous. Examples include packaging, building materials, aqueous cleaners, etc. Non-hazardous material input reductions will be unique to each project. Therefore, the user must input the reduction quantity as well as the total cost associated with the reduction. This information will also be included in the Aggregate Tab."]

{"sheet":"Conversion Factors","index":10,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,2],[4,4,4,6],[2,4,2,6],[3,4,3,6],[5,4,5,6],[17,0,17,7],[11,0,11,2],[11,3,11,7],[1,4,1,7]]}
["Conversion Factors"]
["Abbreviation",null,null,null,"Meaning"]
[null,"kwh",null,null,"Kilowatt hour"]
[null,"BTU",null,null,"British thermal unit"]
[null,"MBTU",null,null,"Thousand BTU"]
[null,"MMBTU",null,null,"Million BTU"]
[null,"tons",null,null,"U.S. short tons"]
[null,"kg",null,null,"Kilogram"]
[null,"lbs",null,null,"Pounds"]
[null,"gal",null,null,"Gallon(s)"]
[]
["Prefixes",null,null,"                Factor"]
[null,"Kilo","=",1000]
[null,"Mega","=",1000000]
[null,"Giga","=",1000000000]
[null,"Tera","=",1000000000000]
[]
["Useful Conversions"]
[1,"mile","=",1.609,"kilometers"]
[1,"lbs","=",0.45400000000000001,"kg","=",{"$f":"1/D23","v":5.0000000000000001E-4},"ton"]
[1,"kg","=",2.2050000000000001,"lbs.","=",{"$f":"D21/D23","v":1.1025E-3},"ton"]
[1,"metric ton","=",1000,"kg","=",{"$f":"G21*D22","v":1.1025},"ton"]
[1,"U.S. short ton","=",2000,"lbs.","=",1,"ton"]
[]
[1,"liter","=",0.26419999999999999,"gallons"]
[1,"gallon","=",3.7854000000000001,"liters"]
[1,"barrel petroleum","=",42,"gallons"]
[]
[1,"kWh","=",3412,"BTU","=",1,"kwh"]
[1,"Gj","=",{"$f":"10^9/1055","v":947867.298578199},"BTU","=",{"$f":"D30/3412","v":277.8040148236222},"kwh"]
[1,"therms","=",{"$f":"10^5","v":100000},"BTU","=",{"$f":"D31/3412","v":29.308323563892145},"kwh"]
[1,"BTU","=",1,"BTU","=",{"$f":"1/3412","v":2.9308323563892143E-4},"kwh"]
[1,"cubic feet","=",1027,"BTU"]
[1,"CCF","=",{"$f":"1027*100","v":102700},"BTU"]

{"sheet":"References & Justification","index":11,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[6,0,7,0],[0,0,4,0],[1,1,4,4],[8,0,16,0]]}
[null,"References & Justification"]
[null,"EPA’s P2 Program has worked closely across EPA offices and collected data from inside and outside the Agency in substantiating conversion factors/values and securing primary and supporting documentation to justify selected methodologies. In many situations, clear standardized conversions did not exist, so the Program chose from various options and underlying assumptions.  Column E entitled, “Justification” provides the user with background on the data source and the reason it was selected.  Complete citations as well as links to the most current websites are provided. "]
[]
[]
[]
["Tab","Reference","Website","Last Updated / Next Update","Justification"]
["Electricity","Electricity Conservation\nEnergy Information Administration, 2020. Electric Power Monthly, \"Table 5.6.B. Average Retail Price of Electricity to Ultimate Customers by End-Use Sector, by State, Year-to-Date through May 2020 and 2019.\" ","http://www.eia.gov/electricity/monthly/","May 2020 / monthly","Electricity Conservation- Used commercial end-user rates by state and national average. The national average is $0.1017 per kilowatt hour."]
[null,"Purchased Green Electricity\nNational Renewable Energy Laboratory (NREL), 2020.","https://www.nrel.gov/analysis/assets/docs/utility-green-pricing-program-list.xlsx","2020 / unknown","Purchasing Green Electricity-  The national average price premium is 1.86 cents per kilowatt-hour."]
["Fuel Use*","Natural Gas\nEnergy Information Administration (EIA), 2020. Monthly Energy Review - 2020. \"Table 3: Selected national average natural gas prices, 2015-2020.\"","http://www.eia.gov/naturalgas/monthly/pdf/table_03.pdf","July 2020 / monthly","Natural Gas - The 2020 YTD average price per therm value is the price per thousand cubic feet ($7.28) divided by 10.37 therms/thousand cubic feet to get the cost per therm of $0.702."]
[null,"VMT\nInternal Revenue Service, 2019. IR-2019-215. ","https://www.irs.gov/newsroom/irs-issues-standard-mileage-rates-for-2020","2019 / annually","VMT - The business mileage rate for 2020 is $0.575 per mile."]
[null,"Motor Gasoline\nEnergy Information Administration (EIA), 2020. Gasoline and Diesel Fuel Update. Updated October, 2020.","https://www.eia.gov/dnav/pet/pet_pri_gnd_dcus_nus_a.htm","October 2020 / weekly","Motor Gasoline- In 2019, the average national price of gasoline was $2.691 per gallon."]
[null,"Diesel\nEnergy Information Administration (EIA), 2020. Gasoline and Diesel Fuel Update. Updated October, 2020.","https://www.eia.gov/dnav/pet/pet_pri_gnd_dcus_nus_a.htm","October 2020 / weekly","Diesel- In 2019, the average national price of diesel was $3.056 per gallon."]
[null,"Biodiesel\nU.S. Department of Energy, Energy Efficiency and Renewable Energy (EERE), 2020. Clean Cities Alternative Fuel Price Report, Table 2: \"National Average Retail Fuel Prices.\" April 2020.","https://afdc.energy.gov/files/u/publication/alternative_fuel_price_report_april_2020.pdf","April 2020 / quarterly","Biodiesel- The April 2020 national average biodiesel price was $2.36 per gallon for B20 biodiesel and $3.51 per gallon for B99-B100 biodiesel. The overall national average biodiesel price is $2.94 per gallon."]
[null,"Heating Oil\nEnergy Information Administration (EIA), 2020. Weekly Heating Oil and Propane Prices (October - March). 2020.","http://www.eia.gov/dnav/pet/pet_pri_wfr_dcus_nus_w.htm","April 2020 / weekly October - March","Heating Oil- In the week of March 30th, 2020, the average national price of residential heating oil was reported as $2.421 per gallon."]
[null,"Jet Fuel\nUS Department of Transportation, Bureau of Transportation Statistics, 2020. \"Airline Fuel Cost and Consumption (U.S. Carriers - Scheduled).\" Updated June, 2020.","http://www.transtats.bts.gov/fuel.asp","June 2020 / monthly","Jet Fuel - The June 2020 figure is $1.08 per gallon."]
[null,"Coal\nEnergy Information Administration (EIA), 2020. \"Annual Coal Report\"","http://www.eia.gov/coal/annual/","2020 / annually","Coal - The 2019 domestic price for coal used in \"Other Industrial Plants\" is $61.37 per ton."]
[null,"EIA. Glossary. 2020.","http://www.eia.gov/tools/glossary/","2020 / NA","Fuel definitions from the EIA glossary are used in the 'Fuel Use' tab."]
["Water Use","AWWA 2019 Water & Wastewater Rate Survey, Exhibit 2","https://www.awwa.org/Store/2019-Water-and-Wastewater-Rate-Survey---Book/ProductDetail/75323192","2019 / biannually","AWWA 2019 Rate Survey, Exhibit 2. Data presented for Commercial Light Industrial Category with 2-inch meter pipe. \n"]
["Water Pollution","AWWA 2019 Water & Wastewater Rate Survey, Exhibits 5 and 6.","https://www.awwa.org/Store/2019-Water-and-Wastewater-Rate-Survey---Book/ProductDetail/75323192","2019 / biannually","Water Pollution, AWWA 2019 Rate Survey, Exhibit 5. Data presented for Commercial Light Industrial Category with 2-inch meter pipe. National Average is used.\nBOD/COD - AWWA 2019 Rate Survey, Exhibit 6. National Average is used.\nToxics - N/A\nNutrients - N/A\nTSS - AWWA 2019 Rate Survey, Exhibit 6.  \n"]
["Hazardous Inputs","User-entered data","N/A","N/A","Hazardous material input reductions will be unique to each project.  Therefore, the user must input the reduction quantity as well as the total cost associated with the reduction.  This information will be included in the Aggregate."]
["Hazardous Waste","1) EPA, Unit Cost Compendium (UCC), 2011. \n2) 2017 RCRA Biennial Report\n3) Regulatory Impact Analysis (RIA) for USEPA’s 2008 Final Rule Amendments to the Industrial Recycling Exclusions of the RCRA Definition of Solid Waste (Sep 25, 2008)\n4) Dept. of Defense Environmental Cost Analysis Methodology (ECAM) Handbook (Mar 29, 1999). \n","2017 RCRA Biennial Report at:\nhttps://rcrapublic.epa.gov/rcrainfoweb/action/modules/br/summary/view\n\nRegulatory Impact Analysis (RIA) for USEPA’s 2008 Final Rule Amendments to the Industrial Recycling Exclusions of the RCRA Definition of Solid Waste; Transportation Costs on page 188: https://www.regulations.gov/document?D=EPA-HQ-RCRA-2002-0031-0602","Varies / Varies","For average costs, not specifying management method (Average HW Cost tab):  \nAn average cost for unspecified management methods was estimated using a weighted average of inflated UCC incineration and landfill costs, weighted by how prevalent each treatment method is in the waste stream based on the Biennial Report. Transportation costs from the RIA document are also included. The estimated average cost including transportation is $0.77 per pound. Adding $1.32 ($1.00 inflated to 2019$) for typical overhead costs from the ECAM document yields a total cost of $2.09 per pound, or $17.35 per gallon (based on 8.3 lbs. per gallon).\nFor Incineration alone (Incineration tab): Using an average of UCC incineration costs (inflated to 2019$) ($1.08), adding inflated transportation costs ($.07), and $1.32 ($1.00 inflated to 2019$) for overhead yields a cost for incineration of $1.08+$.07+$1.32=$2.57/lb, or $21.33/gal (based on 8.3 lbs per gallon).\nFor Landfill alone (Landfill tab): Using a weighted average (by waste form) of ETC/UCC landfill costs (inflated to 2019$) ($.18), adding inflated transportation costs ($.07), and $1.32 ($1.00 inflated to 2016$) for overhead costs yields a cost of landfilling of $.18+$.07+$1.32=$1.57/lb, or $13.03/gal (based on 8.3 lbs per gallon)."]
["Air Emissions","Internal EPA survey.","N/A","2008-2010 / unknown","This rate is an average of state rates (adjusted upward by 20% to account for increasing costs since survey date) from a compilation of sources provided by EPA. Sources include direct phone conversations between EPA and state Environmental Protection offices, and individual states' department website documents.  Data was not available for six states, thus the national average presented is compiled from 44 states and the District of Columbia only. If this data is not reflective of current conditions, please contact EPA P2 program on alternative data and sources. For more information, see the State Air Emission tab."]
["Non-Hazardous Inputs","User-entered data","N/A","N/A","Non-hazardous material input reductions will be unique to each project.  Therefore, the user must input the reduction quantity as well as the total cost associated with the reduction.  This information will be included in the Aggregate."]
["Implicit GDP Price Deflators","U.S. Bureau of Economic Analysis, “Table 1.1.9. Implicit Price Deflators for Gross Domestic Product,” (accessed August 21st, 2020).","https://apps.bea.gov/iTable/iTable.cfm?reqid=19&step=2#reqid=19&step=2&isuri=1&1921=survey","July 2020 / monthly","BEA's Implicit GDP Price Deflator index was used to inflate costs to 2019$. The GDP index was selected as it is widely understood and broadly applicable. "]
["* All fuel data is based on national averages"]

{"sheet":"State Air Emission","index":12,"n_rows":64,"n_cols":14,"rows_kept":64,"cut":false,"hidden":true,"merged":[[2,0,2,13]]}
[null,1,{"$f":"B1+1","v":2},{"$f":"C1+1","v":3},null,{"$f":"D1+1","v":4},null,1,{"$f":"H1+1","v":2},{"$f":"I1+1","v":3},null,{"$f":"J1+1","v":4}]
[{"$f":"COLUMN()","v":1},{"$f":"COLUMN()","v":2},{"$f":"COLUMN()","v":3},{"$f":"COLUMN()","v":4},null,{"$f":"COLUMN()","v":6},null,{"$f":"COLUMN()","v":8},{"$f":"COLUMN()","v":9},{"$f":"COLUMN()","v":10},null,{"$f":"COLUMN()","v":12},{"$f":"COLUMN()","v":13}]
["Note: data based on a U.S. EPA survey conducted from 2008-2010. All costs have been inflated by 20%, per guidance from U.S. EPA/OAQPS, Air Quality Policy Division, Operating Permits Group (November 2020)."]
["States","Blocks","Group","NOx, SOx, PM10, VOCs","NOx, SOx, PM10, VOCs (2019$/ton)","Category","Notes","Blocks","Group","HAPs","HAPs (2019$/ton)","Category","Notes","Sources and Notes"]
["U.S. National","U.S. National",1,45.14,{"$f":"IFERROR(D5*(1.2), D5)","v":54.167999999999999},"National",null,"U.S. National",1,45.8,{"$f":"IFERROR(J5*1.2, J5)","v":54.959999999999994}]
["AK",{"$f":"IF(OR(F6=\"\",F6=\"National\"),A6,A6&\"_\"&F6)","v":"AK"},1,28.57,{"$f":"IFERROR(D6*(1.2), D6)","v":34.283999999999999},null,null,{"$f":"IF(OR($L6=\"\",$L6=\"National\"),$A6,$A6&\"_\"&$L6)","v":"AK"},1,28.57,{"$f":"IFERROR(J6*1.2, J6)","v":34.283999999999999},null,null,"\"Air Permits Program Fee Rate Evaluation Report (February 25th, 2010),\"  Department of Environmental Conservation, Division of Air Quality (http://www.dec.state.ak.us/air/ap/fees.htm)                                                                    "]
["AL","AL",1,32.5,{"$f":"IFERROR(D7*(1.2), D7)","v":39},null,null,"AL",1,32.5,39,null,null,"Information received by Sarah Helinek via e-mail in January 2010 from Tim Owen, Chief, Energy Branch, Air Division, AL Department of Environmental Management (Airmail@adem.state.al.us)                                      "]
["AR","AR",1,22.07,26.483999999999998,null,null,"AR",1,22.07,26.483999999999998,null,null,"Information received by Sarah Helinek via e-mail in March 2010 from Thomas Rheaume, Permit Branch Manager, Arkansas Department of Environmental Quality, Air Division (RHEAUME@adeq.state.ar.us)                                         "]
["AZ","AZ",1,36.96,44.351999999999997,null,null,"AZ",1,36.96,44.351999999999997,null,null,"Information received by Sarah Helinek via e-mail in March 2010 from Trevor Baggiore, Air Quality Permits Section, Arizona Department of Environmental Quality (Baggiore.Trevor@azdeq.gov)              "]
["CA","CA",1,46.64,55.967999999999996,null,null,"CA",1,47.23,56.675999999999995,null,null,"\"District Rules Database,\" Air Resources Board, CA Environmental Protection Agency website  (http://www.arb.ca.gov/drdb/drdb.htm)                                                               (*NOTE: CA has 35 different air districts, each with unique air pollution laws and fee. Many districts did not provide Title V fee information, and of those that did, many were not up to date. Only four had sufficient/up-to-date data to report)                                                                                                                   "]
["CO","CO",1,22.9,27.479999999999997,null,null,"CO",1,152.9,183.48,null,null,"\"Air Pollution Billing and Fees Stationary Sources Program,\" Colorado Department of Public Health and Environment,  Air Pollution Control Division (http://www.cdphe.state.co.us/ap/billing.html)                                                              "]
["CT","CT",1,229.47,275.36399999999998,null,null,"CT",1,229.47,275.36399999999998,null,null,"Information received by Sarah Helinek via e-mail in January 2010 from Dennise Goulbourne, Fiscal Administrative Officer, Bureau of Financial & Support Services (Dennise.Goulbourne@ct.gov)                                        "]
["DC","DC",1,43.72,52.463999999999999,null,null,"DC",1,0,0,null,null,"Information received by Sarah Helinek via e-mail in January 2010 from Jessica Daniels, Environmental Protection Specialist, Government of the District of Columbia, District Department of the Environment (jessica.daniels@dc.gov)                            "]
["DE","DE",2,"U.S. National","U.S. National","National","Determined on a case-by-case basis","DE",2,"U.S. National","U.S. National","National","Determined on a case-by-case basis","DE determines its air emissions fees on a complicated, case-by-case basis, and is therefore not included in the average (Based on e-mail from Amy Mann, DE Department of Natural Resources and Environmental Control, Amy.Mann@state.de.us)"]
["FL","FL",1,30,36,null,null,"FL",1,30,36,null,null,"\"Title V Annual Emissions Fee On-line Information Center,\" Maryland Department of Environmental Protection website (http://www.dep.state.fl.us/AIR/emission/tvfee.htm)                                           "]
["GA","GA",1,34,40.799999999999997,null,null,"GA",1,34,40.799999999999997,null,null,"\"Procedures for Calculating Air Permit Fees,\" Georgia Department of Natural Resources website (http://www.gaepd.org/air/airpermit/html/aqrules/fee.htm)                       "]
["HI","HI",1,61.52,73.823999999999998,null,null,"HI",1,0,0,null,null,"Information received by Sarah Helinek via e-mail in March 2010 from Scott Takamoto, Clean Air Branch, Hawaii Department of Health (scott.takamoto@doh.hawaii.gov)                                                                   "]
["IA","IA",1,56,67.2,null,null,"IA",1,56,67.2,null,null,"Information received by Sarah Helinek via e-mail in March 2010 from Doug Campbell, Supervisor, Operating Permits Section, Air Quality Bureau Iowa Department of Natural Resources (Doug.Campbell@dnr.iowa.gov)                                "]
["ID","ID",1,39.479999999999997,47.375999999999998,null,null,"ID",1,0,0,null,null,"Information received by Sarah Helinek via e-mail in March 2010 from Stephen Coe, Regional Airshed Manager, Idaho Department Of Environmental Quality (Stephen.Coe@deq.idaho.gov)                                                                               "]
["IL","IL_<100",3,0,0,"<100",null,"IL_<100",3,0,0,"<100","<100","\"Clean Air Title V Fees,\" Illinois Environmental Protection Agency (http://www.epa.state.il.us/fees/clean-air-title-v.html)                                   "]
["IL","IL_>=100",3,18,21.599999999999998,">=100",null,"IL_>=100",3,18,21.599999999999998,">=100",">=100","\"Clean Air Title V Fees,\" Illinois Environmental Protection Agency (http://www.epa.state.il.us/fees/clean-air-title-v.html)                                     "]
["IN","IN",1,41.25,49.5,null,null,"IN",1,0,0,null,null,"Information received by Sarah Helinek in March 2010 via e-mail from Kristin Wiley, Correspondence Coordinator, Governor's Liaison for Indiana Department of Environmental Management (INFO@idem.in.gov)                                                        "]
["KS","KS_<100",3,0,0,"<100",null,"KS_<10",3,0,0,"<10","<10","Information received by Sarah Helinek via e-mail in March 2010 from Marian Massoth, P.E. Air Permitting Section, KDHE - Bureau of Air (MMassoth@kdheks.gov)                                                                                                    "]
["KS","KS_>=100",3,25,30,">=100",null,"KS_>=10",3,25,30,">=10",">=10","Information received by Sarah Helinek via e-mail in March 2010 from Marian Massoth, P.E. Air Permitting Section, KDHE - Bureau of Air (MMassoth@kdheks.gov)                                                                                                    "]
["KY","KY",1,48.12,57.743999999999993,null,null,"KY",1,48.12,57.743999999999993,null,null,"\"Permit Fees for Fiscal Year 2010,\" Kentucky Air Pollution Control District website (http://www.louisvilleky.gov/APCD/EE/Permits.htm#aCost)     "]
["LA","LA",2,"U.S. National","U.S. National","National","No data received","LA",2,"U.S. National","U.S. National","National","No data received","N/A"]
["MA","MA",2,"U.S. National","U.S. National","National","No data received","MA",2,"U.S. National","U.S. National","National","No data received","Information N/A"]
["MD","MD",1,52.23,62.675999999999995,null,null,"MD",1,52.23,62.675999999999995,null,null,"\"Title V Fee Sheet,\" Maryland Department of the Environment website (http://www.mde.state.md.us/Permits/AirManagementPermits/Title5/title5feesheet.asp)                                                                                                        "]
["ME","ME_<1000",3,7.28,8.7360000000000007,"<1000",null,"ME_<1000",3,7.28,8.7360000000000007,"<1000","<1000","\"Major Source Information - Air Emissions License Revised Fee Schedule,\" Bureau of Air Quality, Maine Department of Environment  (http://www.state.me.us/dep/air/licensing/major.htm)                                            "]
["ME","ME_1000-4000",3,14.59,17.507999999999999,"1000-4000",null,"ME_1000-4000",3,14.59,17.507999999999999,"1000-4000","1000-4,000","\"Major Source Information - Air Emissions License Revised Fee Schedule,\" Bureau of Air Quality, Maine Department of Environment  (http://www.state.me.us/dep/air/licensing/major.htm)                                              "]
["ME","ME_>=4000",3,21.86,26.231999999999999,">=4000",null,"ME_>=4000",3,21.86,26.231999999999999,">=4000",">=4000","\"Major Source Information - Air Emissions License Revised Fee Schedule,\" Bureau of Air Quality, Maine Department of Environment  (http://www.state.me.us/dep/air/licensing/major.htm)                                             "]
["MI","MI",1,45.25,54.3,null,null,"MI",1,45.25,54.3,null,null,"\"Michigan Air Quality Fees for 2010,\" MI Department of Natural Resources and Environment (http://www.michigan.gov/deq/0,1607,7-135-3310_4103_5784---,00.html)     State Fee: $45.25/ton                                                                        "]
["MN","MN",1,43.33,51.995999999999995,null,null,"MN",1,43.33,51.995999999999995,null,null,"Information received by Sarah Helinek in March 2010 via e-mail from Michael Smith, Minnesota Pollution Control Agency Environmental Analysis and Outcomes, Air Emission Inventory Coordinator (Michael.Smith@state.mn.us)                                      "]
["MO","MO",1,40,48,null,null,"MO",1,40,48,null,null,"\"The State of Missouri's Environment, 2009,\" Missouri Department of Natural Resources (http://www.dnr.mo.gov/env/apcp/index.html)                                                                  "]
["MS","MS",1,36,43.199999999999996,null,null,"MS",1,36,43.199999999999996,null,null,"\"Mississippi Department on  Environmental Quality Office of Pollution Control Public Notice,\" under Title V Fees section of Mississippi Department of Environmental Quality website (http://www.deq.state.ms.us/mdeq.nsf/page/Air_TitleVFees?OpenDocument) "]
["MT","MT",1,38.24,45.887999999999998,null,null,"MT",1,0,0,null,null,"Information received by Sarah Helinek via e-mail in March 2010 from Charles Homer, MT Department of Environmental Quality (chomer@mt.gov)                                                                                                        "]
["NC","NC",1,27.5,33,null,null,"NC",1,27.5,33,null,null,"\"Calendar Year 2010 Air Quality Fees,\" NC Department of Environment and Natural Resources, Division of Air Quality website; under \"Permits\" then under \"Fees\" (http://daq.state.nc.us/)                                           "]
["ND","ND",1,13.4,16.079999999999998,null,null,"ND",1,27.9,33.479999999999997,null,null,"Information received by Sarah Helinek via e-mail in March 2010 from Lewis Dendy, Lew Dendy, Environmental Scientist, ND Division of Air Quality (ldendy@nd.gov)                                                                                                "]
["NE","NE",1,62,74.399999999999991,null,null,"NE",1,62,74.399999999999991,null,null,"\"2008 Emission Inventory Fee Assessment,\" Nebraska Department of Environmental Quality (http://www.deq.state.ne.us/AirDivis.nsf/Pages/2006EIFA)                                                                                                                "]
["NH","NH",1,136.15,163.38,null,null,"NH",1,136.15,163.38,null,null,"\"What Fees Are Required for an Air Permit?\" New Hampshire Department of Environmental Services (http://des.nh.gov/organization/divisions/air/pehb/apps/fees.htm)                                                                 "]
["NJ","NJ",1,105.12,126.14400000000001,null,null,"NJ",1,105.12,126.14400000000001,null,null,"\"Consumer Price Index Percentage Adjustments to Air Contaminant Emission Fees, and Base Fee Tables and Supplemental Fee Schedules,\" NJDEP Air Quality Permitting Program (http://www.nj.gov/dep/aqpp/archived/11162009NJRpage.html)                     "]
["NM","NM",1,23.07,27.684000000000001,null,null,"NM",1,173.86,208.63200000000001,null,null,"\"Air Quality Bureau,\" New Mexico Department of Environment (http://www.nmenv.state.nm.us/aqb/permit/permit_fees.htm)                                                                                                                                           "]
["NV","NV",1,16,19.2,null,"**It should be noted that the majority of NV's fee revenue comes from \"maintenance fees\" as opposed to \"emissions fees,\" unlike most states; for example, a Major Source with a Title V permit pays the $16.00/ton plus a $20,000 base fee","NV",1,16,19.2,null,"**It should be noted that the majority of NV's fee revenue comes from \"maintenance fees\" as opposed to \"emissions fees,\" unlike most states; for example, a Major Source with a Title V permit pays the $16.00/ton plus a $20,000 base fee","Information received by Sarah Helinek via e-mail in March 2010 from Patrick Anderson, Bureau of Air Pollution Control, Nevada Division of Environmental Protection (patricka@ndep.nv.gov)                                                                      "]
["NY","NY_<1000",3,45,54,"<1000",null,"NY_<1000",3,45,54,"<1000","<1000","\"Adopted Subpart 482-2, Operating Program Fees - Effective June 24, 2009,\"New York State Department of Environmental Conservation (http://www.dec.ny.gov/regulations/55931.html)                               "]
["NY","NY_1000-2000",3,50,60,"1000-2000",null,"NY_1000-2000",3,50,60,"1000-2000","1000-2000","\"Adopted Subpart 482-2, Operating Program Fees - Effective June 24, 2009,\"New York State Department of Environmental Conservation (http://www.dec.ny.gov/regulations/55931.html)                                       "]
["NY","NY_2000-5000",3,55,66,"2000-5000",null,"NY_2000-5000",3,55,66,"2000-5000","2000-5000","\"Adopted Subpart 482-2, Operating Program Fees - Effective June 24, 2009,\"New York State Department of Environmental Conservation (http://www.dec.ny.gov/regulations/55931.html)                                                       "]
["NY","NY_>=5000",3,65,78,">=5000",null,"NY_>=5000",3,65,78,">=5000",">=5000","\"Adopted Subpart 482-2, Operating Program Fees - Effective June 24, 2009,\"New York State Department of Environmental Conservation (http://www.dec.ny.gov/regulations/55931.html)                                                       "]
["OH","OH",1,43.75,52.5,null,null,"OH",1,43.75,52.5,null,null,"\"Title V General Information - Title V Emissions Fee Report Requirements,\" Ohio Environmental Protection Agency, Division of Air Pollution Control (http://web.epa.ohio.gov/dapc/title_v/titlev.html)                                "]
["OK","OK",1,34.04,40.847999999999999,null,null,"OK",1,34.04,40.847999999999999,null,null,"Information received by Sarah Helinek via e-mail in March 2010 from Morris Moffit, Morris Moffett, Air Quality Division, OK Department of Environmental Quality (Morris.Moffett@deq.ok.gov)                                                                    "]
["OR","OR",1,54.21,65.051999999999992,null,null,"OR",1,54.21,65.051999999999992,null,null,"Information received by Sarah Helinek via e-mail in March 2010 from Andrea Curtis,  Air Quality Division, Oregon Department of Environmental Equality (CURTIS.Andrea@deq.state.or.us)                                                                          "]
["PA","PA",1,54,64.8,null,null,"PA",1,54,64.8,null,null,"Information received by Sarah Helinek via e-mail in January 2010 from Douglas Malchenson, Air Quality Engineer. PA Department of Environmental Protection (dmalchenso@state.pa.us)                                                                        "]
["RI","RI",2,"U.S. National","U.S. National","National","No data received","RI",2,"U.S. National","U.S. National","National","No data received","Information N/A"]
["SC","SC",1,41.96,50.351999999999997,null,null,"SC",1,41.96,50.351999999999997,null,null,"\"Environmental Protection Fees - Fee Schedule,\" SC Department of Health and Environmental Control, Air Quality Division (http://www.scdhec.gov/environment/baq/fees.aspx)             "]
["SD","SD",2,"U.S. National","U.S. National","National","No data received","SD",2,"U.S. National","U.S. National","National","No data received","N/A"]
["TN","TN",1,43.75,52.5,null,null,"TN",1,43.75,52.5,null,null,"\"Title V Implementation Plan,\" TN Division of Air Pollution Control (http://www.tnchamber.org/environment/Draft%202008-2009%20Workload%20Analysis.pdf)                                                         "]
["TX","TX",1,44.17,53.003999999999998,null,null,"TX",1,44.17,53.003999999999998,null,null,"\"Point Source Air Emissions and Air Inspection Fees,\" Texas Commission on Environmental Quality (http://www.tceq.state.tx.us/implementation/air/industei/psei/air-fees.html#time)                                                                              "]
["UT","UT",2,"U.S. National","U.S. National","National","No data received","UT",2,"U.S. National","U.S. National","National","No data received","N/A"]
["VA","VA",1,44.17,53.003999999999998,null,null,"VA",1,44.17,53.003999999999998,null,null,"Information received by Sarah Helinek via e-mail in January 2010 from Gary Graham, Regulatory Analyst, Office of Regulatory Affairs, Commonwealth of Virginia Department of Environmental Quality (Gary.Graham@deq.virginia.gov)  "]
["VT","VT",1,42,50.4,null,null,"VT",1,0,0,null,null,"Information received by Sarah Helinek via e-mail in January 2010 from Doug Elliot, Air Pollution Control Division, Vermont Department of Environmental Conservation (Doug.Elliott@state.vt.us) "]
["WA","WA",1,22.37,26.844000000000001,null,null,"WA",1,22.37,26.844000000000001,null,null,"Information received by Sarah Helinek via e-mail in March 2010 from Crystal Alford, AOP Coordinator, Washington State Department of Ecology (Crystal.Alford@ecy.wa.gov)                                                                                        "]
["WI","WI",1,35.71,42.851999999999997,null,null,"WI",1,35.71,42.851999999999997,null,null,"Information received by Sarah Helinek in March 2010 via e-mail from Ralph Patterson, Emission Inventory Team Leader, Emissions Inventory and Small Source Section, Bureau of Air Management, \nWisconsin Department of Natural Resources (Ralph.Patterson@wiscon"]
["WV","WV",1,23.87,28.644000000000002,null,null,"WV",1,23.87,28.644000000000002,null,null,"\"West Virginia Air Quality Fees,\"  West Virginia Department of Environmental Protection (http://www.dep.wv.gov/daq/planning/Pages/AirQualityFees.aspx)      "]
["WY","WY",1,28.16,33.792000000000002,null,null,"WY",1,28.16,33.792000000000002,null,null,"\"Wyoming's Title V Operating Permit Program,\" Wyoming Department of Environmental Quality (http://deq.state.wy.us/aqd/TitleVOperatingPermitProgram.asp)                                                                                                        "]
["*All costs are in $/ton","*All costs are in $/ton",null,null,null,null,null,"*All costs are in $/ton"]

{"sheet":"St.AirEm.Variables&Assumptions","index":13,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":true,"merged":[[3,1,3,4],[8,1,8,4]]}
[]
[{"$f":"COLUMN()","v":1},{"$f":"COLUMN()","v":2},{"$f":"COLUMN()","v":3},{"$f":"COLUMN()","v":4},{"$f":"COLUMN()","v":5}]
["Block State",null,"Threshold (Tons)"]
[null,"CAPs"]
["IL",{"$f":"COUNT(C5:E5)","v":1},100]
["KS",{"$f":"COUNT(C6:E6)","v":1},100]
["ME",{"$f":"COUNT(C7:E7)","v":2},1000,4000]
["NY",{"$f":"COUNT(C8:E8)","v":3},1000,2000,5000]
[null,"HAPs"]
["IL",{"$f":"COUNT(C10:E10)","v":1},100]
["KS",{"$f":"COUNT(C11:E11)","v":1},10]
["ME",{"$f":"COUNT(C12:E12)","v":2},1000,4000]
["NY",{"$f":"COUNT(C13:E13)","v":3},1000,2000,5000]

{"sheet":"Water Charges","index":14,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Wastewater (2019$/gallons)*","TSS(2019$/lbs)*","BOD/COD (2019$/lbs)*","Water (2019$/gallons)*"]
["U.S. National",5.8306951871657754E-3,0.35770000000000002,0.3765,5.1686363636363631E-3]
[null,"*Values are calculated as the average rate charged by utilities."]

{"sheet":"Average HW Cost","index":15,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Computation of average cost for RCRA industrial hazardous waste disposal:"]
[]
[null,null,null,null,null,null,"Average cost","2017 BR tons*"]
[null,null,"A. ",null,null,"Incineration price (per ton) =",{"$f":"(Incineration!I9)","v":2367.2777179478721},1174764]
[null,null,"B.",null,null,"Landfill price (per ton) =",{"$f":"(Landfill!H13)","v":363.04068376911897},1138596]
[null,null,null,null,null,"Tonnage weighted average price =",{"$f":"ROUND(SUMPRODUCT(G5:G6,H5:H6)/SUM(H5:H6), 0)","v":1381}]
[null,null,null,null,null,null,{"$f":"\"$\"&G7&\"/ton - weighted by incin/landfill proportion\"","v":"$1381/ton - weighted by incin/landfill proportion"}]
[null,null,null,null,null,null,{"$f":"G7/2000","v":0.6905},"per pound"]
[null,null,null,null,null,null,{"$f":"G9+(0.06*'Implicit GDP Price Deflators'!$AF$8/'Implicit GDP Price Deflators'!$R$8)","v":0.76755128058475652},"including transportation"]
[null,null,"Notes:"]
[null,null,"A. Incineration price calculated on the Incineration tab"]
[null,null,"B. Landfill price calculated on the Landfill tab"]
[null,null,"* Source: 2017 RCRA National Biennial Report"]
[null,null,"See Reference tab for more information"]

{"sheet":"Incineration","index":16,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Incineration Cost"]
[null,null,null,null,null,"2011 UCC","2019$",null,"Equivalent"]
[null,null,null,null,"ETC Incineration Price Categories*","avg price","avg price","Cost basis","Per-ton price"]
[null,null,null,1,"Drummed Halogen Liquid Organics",515,{"$f":"F5*'Implicit GDP Price Deflators'!$AF$8/'Implicit GDP Price Deflators'!$X$8","v":589.25452006767364},"per drum",{"$f":"(G5)*2000/(55*8.3)","v":2581.6189269120418},"Assume 55 gallons per drum @8.3 lbs per gallon"]
[null,null,null,2,"Bulk Pumpable Sludges",11,{"$f":"F6*'Implicit GDP Price Deflators'!$AF$8/'Implicit GDP Price Deflators'!$X$8","v":12.586018875231863},"per gallon",{"$f":"G6/8.3*2000","v":3032.7756325859905},"Assume 8.3 lbs per gallon"]
[null,null,null,3,"Bulk Contaminated Soils",1300,{"$f":"F7*'Implicit GDP Price Deflators'!$AF$8/'Implicit GDP Price Deflators'!$X$8","v":1487.4385943455839},"per ton",{"$f":"(G7)","v":1487.4385943455839}]
[]
[null,null,null,null,null,null,null,"average unit cost (per ton) =",{"$f":"AVERAGE(I5:I7)","v":2367.2777179478721},"per ton"]
[null,null,null,null,"* Source: 2011 EPA Unit Cost Compendium",null,null,null,{"$f":"I9/2000","v":1.1836388589739362},"per pound"]
[null,null,null,null,null,null,null,null,{"$f":"I9/2000*8.3","v":9.8242025294836708},"per gallon"]
[null,null,null,null,"Note: for 2019 costs, UCC was inflated from 2011$ to 2019$"]

{"sheet":"Landfill","index":17,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Landfill Cost"]
[]
[null,null,null,"2011 UCC",null,null,"Equivalent"]
[null,null,"ETC Landfill Price Categories*","avg price","2019$","Cost basis","Per-ton price"]
[null,1,"Debris",{"$f":"(25+138)/2","v":81.5},{"$f":"D6*'Implicit GDP Price Deflators'!$AF$8/'Implicit GDP Price Deflators'!$X$8","v":93.250958030126995},"per ton",{"$f":"(E6)","v":93.250958030126995},"UCC 2011 cost: $25-$138 per ton. Midpoint used."]
[null,2,"Bulk without Treatment",129,{"$f":"D7*'Implicit GDP Price Deflators'!$AF$8/'Implicit GDP Price Deflators'!$X$8","v":147.59967590044641},"per ton",{"$f":"(E7)","v":147.59967590044641}]
[null,3,"Drummed with Treatment",196,{"$f":"D8*'Implicit GDP Price Deflators'!$AF$8/'Implicit GDP Price Deflators'!$X$8","v":224.25997268594958},"per drum",{"$f":"(E8)*2000/(55*8.3)","v":982.51904791215577},"Assume 55 gallons per drum @8.3 lbs per gallon"]
[null,4,"Drummed without Treatment",109,{"$f":"D9*'Implicit GDP Price Deflators'!$AF$8/'Implicit GDP Price Deflators'!$X$8","v":124.71600521820666},"per drum",{"$f":"(E9)*2000/(55*8.3)","v":546.40089909400501},"Assume 55 gallons per drum @8.3 lbs per gallon"]
[null,5,"Soil Treated and Landfilled",228,{"$f":"D10*'Implicit GDP Price Deflators'!$AF$8/'Implicit GDP Price Deflators'!$X$8","v":260.87384577753323},"per ton",{"$f":"(E10)","v":260.87384577753323}]
[null,6,"Soil Direct to Landfill",129,{"$f":"D11*'Implicit GDP Price Deflators'!$AF$8/'Implicit GDP Price Deflators'!$X$8","v":147.59967590044641},"per ton",{"$f":"(E11)","v":147.59967590044641}]
[]
[null,null,null,null,null,null,"average unit cost (per ton) =",{"$f":"AVERAGE(G6:G11)","v":363.04068376911897},"per ton"]
[null,null,"* Source: 2011 EPA Unit Cost Compendium",null,null,null,null,{"$f":"H13/2000","v":0.18152034188455948},"per pound"]
[null,null,null,null,null,null,null,{"$f":"H13/2000*8.3","v":1.5066188376418439},"per gallon"]
[null,null,"Note: for 2019 costs, UCC was inflated from 2011$ to 2019$"]

{"sheet":"State Elec. Prices & Premiums","index":18,"n_rows":58,"n_cols":4,"rows_kept":58,"cut":false,"hidden":true,"merged":[[1,1,1,3]]}
[]
[null,"Electricity Prices"]
[null,"State","Electricity Prices (Commercial End-Use Sector) (c/Kwh)","Electricity Prices (Commercial End-Use Sector) ($/Kwh)"]
[null,"U.S. National",12.42,{"$f":"C4/100","v":0.1242}]
[null,"AK",19.68,{"$f":"C5/100","v":0.1968}]
[null,"AL",11.53,{"$f":"C6/100","v":0.1153}]
[null,"AR",8.48,8.48E-2]
[null,"AZ",9.91,9.9100000000000008E-2]
[null,"CA",15.7,0.157]
[null,"CO",9.8000000000000007,9.8000000000000004E-2]
[null,"CT",17.29,0.1729]
[null,"DC",12.06,0.1206]
[null,"DE",9.66,9.6600000000000005E-2]
[null,"FL",8.99,8.9900000000000008E-2]
[null,"GA",9.75,9.7500000000000003E-2]
[null,"HI",30.64,0.30640000000000001]
[null,"ID",7.47,7.4700000000000003E-2]
[null,"IL",8.9600000000000009,8.9600000000000013E-2]
[null,"IN",10.82,0.1082]
[null,"IO",10.1,0.10099999999999999]
[null,"KS",10.220000000000001,0.10220000000000001]
[null,"KY",10.31,0.10310000000000001]
[null,"LA",8.67,8.6699999999999999E-2]
[null,"MA",16.11,0.16109999999999999]
[null,"MD",10.01,0.10009999999999999]
[null,"ME",12.66,0.12659999999999999]
[null,"MI",11.52,0.1152]
[null,"MN",10.119999999999999,0.1012]
[null,"MO",8.2799999999999994,8.2799999999999999E-2]
[null,"MS",10.69,0.1069]
[null,"MT",10.45,0.1045]
[null,"NC",8.69,8.6899999999999991E-2]
[null,"ND",8.7100000000000009,8.7100000000000011E-2]
[null,"NE",8.83,8.8300000000000003E-2]
[null,"NH",15.52,0.1552]
[null,"NJ",12.06,0.1206]
[null,"NM",9.67,9.6699999999999994E-2]
[null,"NV",7.55,7.5499999999999998E-2]
[null,"NY",13.34,0.13339999999999999]
[null,"OH",9.3000000000000007,9.3000000000000013E-2]
[null,"OK",7.24,7.2400000000000006E-2]
[null,"OR",9.02,9.0200000000000002E-2]
[null,"PA",8.65,8.6500000000000007E-2]
[null,"RI",16.399999999999999,0.16399999999999998]
[null,"SC",10.220000000000001,0.10220000000000001]
[null,"SD",9.27,9.2699999999999991E-2]
[null,"TN",10.61,0.1061]
[null,"TX",7.77,7.7699999999999991E-2]
[null,"UT",8.2100000000000009,8.2100000000000006E-2]
[null,"VA",8.01,8.0100000000000005E-2]
[null,"VT",16.39,0.16390000000000002]
[null,"WA",8.89,8.8900000000000007E-2]
[null,"WI",10.85,0.1085]
[null,"WV",9.35,9.35E-2]
[null,"WY",9.5299999999999994,9.5299999999999996E-2]
[]
[null,"Source: http://www.eia.gov/electricity/monthly, Table 5.6B"]
[null,"Average price of electricity to commercial sector, by state"]

{"sheet":"Implicit GDP Price Deflators","index":19,"n_rows":42,"n_cols":45,"rows_kept":42,"cut":false,"hidden":true,"merged":[[1,0,1,12],[2,0,2,12],[3,0,3,12]]}
["Table 1.1.9. Implicit Price Deflators for Gross Domestic Product"]
["[Index numbers, 2012=100]"]
["Bureau of Economic Analysis"]
["Last Revised on: July 30, 2020 - Next Release Date August 27, 2020"]
["Table 1.1.9 from Interactive Data explorer at https://apps.bea.gov/iTable/iTable.cfm?reqid=19&step=2#reqid=19&step=2&isuri=1&1921=survey"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF8/W8","v":1.1680764948861213}]
["Line","","1990","1991","1992","1993","1994","1995","1996","1997","1998","1999","2000","2001","2002","2003","2004","2005","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015","2016","2017","2018","2019","2020 (Q1)","2020(Q2)","2020 (YTD)"]
["1","        Gross domestic product",63.670999999999999,65.825000000000003,67.325000000000003,68.92,70.391999999999996,71.867999999999995,73.183000000000007,74.444999999999993,75.283000000000001,76.37,78.078000000000003,79.790000000000006,81.052000000000007,82.557000000000002,84.78,87.421000000000006,90.066000000000003,92.486000000000004,94.284999999999997,95.004000000000005,96.111000000000004,98.117999999999995,100,101.755,103.63800000000001,104.624,105.72199999999999,107.71,110.29600000000001,112.265,113.41500000000001,112.803,{"$f":"(AG8+AH8)/2","v":113.10900000000001}]
["2","Personal consumption expenditures",63.354999999999997,65.472999999999999,67.218000000000004,68.891999999999996,70.33,71.811000000000007,73.346000000000004,74.623000000000005,75.215999999999994,76.337999999999994,78.234999999999999,79.738,80.789000000000001,82.358000000000004,84.411000000000001,86.811999999999998,89.174000000000007,91.438000000000002,94.18,94.093999999999994,95.704999999999998,98.131,100,101.346,102.83,103.04300000000001,104.121,105.98399999999999,108.239,109.851]
["3","    Goods",81.927000000000007,83.93,84.942999999999998,85.680999999999997,86.552000000000007,87.361000000000004,88.320999999999998,88.218999999999994,86.893000000000001,87.349000000000004,89.081999999999994,89.015000000000001,88.165999999999997,88.054000000000002,89.292000000000002,91.084000000000003,92.305999999999997,93.331000000000003,96.122,93.811999999999998,95.183000000000007,98.772999999999996,100,99.406999999999996,98.92,95.896000000000001,94.325000000000003,94.596999999999994,95.244,94.784999999999997]
["4","        Durable goods",131.935,133.86799999999999,134.79300000000001,136.12,138.78399999999999,139.797,138.386,135.364,131.53800000000001,127.994,125.717,123.254,120.143,115.752,113.488,112.309,110.38800000000001,108.038,106.012,104.02,102.107,101.28,100,97.968000000000004,95.429000000000002,93.358000000000004,91.117000000000004,89.025000000000006,87.528999999999996,86.462999999999994]
["5","        Nondurable goods",63.112000000000002,64.954999999999998,65.897999999999996,66.433999999999997,66.787999999999997,67.486000000000004,69.013999999999996,69.734999999999999,69.222999999999999,70.942999999999998,73.989999999999995,74.775999999999996,74.781000000000006,76.326999999999998,78.97,81.998000000000005,84.552999999999997,87.040999999999997,91.903999999999996,89.466999999999999,92.182000000000002,97.652000000000001,100,100.08199999999999,100.599,97.091999999999999,95.878,97.444999999999993,99.313000000000002,99.212000000000003]
["6","    Services",54.845999999999997,56.991999999999997,59.018000000000001,61.058999999999997,62.719000000000001,64.471000000000004,66.239999999999995,68.106999999999999,69.549000000000007,70.97,72.938000000000002,75.171000000000006,77.123000000000005,79.506,81.965000000000003,84.673000000000002,87.616,90.516000000000005,93.234999999999999,94.230999999999995,95.956999999999994,97.813999999999993,100,102.316,104.804,106.694,109.16,111.86799999999999,114.991,117.744]
["7","Gross private domestic investment",81.227999999999994,82.683999999999997,82.671999999999997,83.641000000000005,84.908000000000001,86.263000000000005,86.227000000000004,86.239000000000004,85.706000000000003,85.825999999999993,86.861999999999995,87.367000000000004,87.927000000000007,88.503,91.156999999999996,94.912999999999997,98.13,99.584999999999994,100.59699999999999,99.366,97.698999999999998,98.748000000000005,100,100.876,102.872,103.697,103.694,105.26900000000001,107.327,108.96599999999999]
["8","    Fixed investment",80.278000000000006,81.683000000000007,81.727999999999994,82.710999999999999,83.983000000000004,85.378,85.45,85.599000000000004,85.132999999999996,85.277000000000001,86.486000000000004,87.241,87.5,88.265000000000001,90.843000000000004,94.596999999999994,97.957999999999998,99.456000000000003,100.29600000000001,99.075999999999993,97.567999999999998,98.641000000000005,100,101.09099999999999,103.172,104.075,104.214,105.95399999999999,107.998,109.79900000000001]
["9","        Nonresidential",92.516000000000005,94.266999999999996,93.96,94.161000000000001,94.903999999999996,95.849000000000004,95.266999999999996,94.734999999999999,93.248000000000005,92.313999999999993,92.718000000000004,92.346000000000004,91.863,91.156000000000006,92.055000000000007,94.442999999999998,96.745000000000005,98.31,99.831999999999994,99.183999999999997,97.415999999999997,98.558999999999997,100,100.251,101.46899999999999,101.90900000000001,101.131,101.994,102.88200000000001,104.256]
["10","            Structures",40.948,41.689,41.698999999999998,42.921999999999997,44.436999999999998,46.362000000000002,47.54,49.354999999999997,51.612000000000002,53.198,55.283000000000001,58.177999999999997,60.603000000000002,62.768999999999998,67.415999999999997,75.733000000000004,84.748999999999995,89.748000000000005,94.334999999999994,92.613,92.006,95.361999999999995,100,101.455,107.19799999999999,109.40300000000001,109.76300000000001,112.66800000000001,114.563,118.709]
["11","            Equipment",135.042,137.33000000000001,137.12100000000001,135.518,135.27699999999999,133.79599999999999,130.762,127.15600000000001,121.45099999999999,116.76300000000001,114.224,110.858,108.53100000000001,105.72499999999999,104.84099999999999,104.598,103.56,103.191,102.542,103.16800000000001,99.471000000000004,99.447000000000003,100,99.787000000000006,99.168999999999997,98.671000000000006,97.620999999999995,97.564999999999998,97.685000000000002,97.888000000000005]
["12","            Intellectual property products",88.147000000000006,90.271000000000001,89.373000000000005,89.998000000000005,90.468000000000004,93.134,93.543999999999997,94.052000000000007,93.594999999999999,95.105000000000004,97.813999999999993,97.683999999999997,96.376000000000005,95.647000000000006,95.334999999999994,95.951999999999998,97.087999999999994,98.284000000000006,99.834000000000003,98.588999999999999,98.305999999999997,99.516999999999996,100,100.081,100.791,101.374,100.232,101.065,102.372,103.68300000000001]
["13","        Residential",56.287999999999997,57.021000000000001,57.722999999999999,60.073999999999998,62.247,64.472999999999999,65.855999999999995,67.444000000000003,69.222999999999999,71.816000000000003,75.004000000000005,78.563999999999993,80.510000000000005,84.325000000000003,90.242999999999995,96.706000000000003,102.355,103.708,102.249,98.671000000000006,98.316999999999993,99.049000000000007,100,105.054,111.11799999999999,114.114,118.134,123.497,130.47,134.18199999999999]
["14","    Change in private inventories","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
["15","Net exports of goods and services","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
["16","    Exports",79.656999999999996,80.545000000000002,80.153000000000006,80.277000000000001,81.209999999999994,83.025000000000006,81.923000000000002,80.478999999999999,78.573999999999998,77.971000000000004,79.466999999999999,78.834999999999994,78.200999999999993,79.400000000000006,82.284000000000006,85.131,87.841999999999999,91.138999999999996,95.41,89.694000000000003,93.347999999999999,99.242000000000004,100,100.16800000000001,100.27200000000001,95.394999999999996,93.49,95.921000000000006,99.183000000000007,98.751000000000005]
["17","        Goods",85.712999999999994,85.674000000000007,84.337999999999994,83.914000000000001,84.873000000000005,86.887,84.683999999999997,82.335999999999999,79.739999999999995,78.661000000000001,80.024000000000001,79.557000000000002,78.728999999999999,79.506,82.314999999999998,84.933999999999997,87.585999999999999,91.001999999999995,95.712999999999994,88.921000000000006,92.966999999999999,99.793000000000006,100,99.311999999999998,98.308000000000007,91.305999999999997,87.741,90.028000000000006,93.251000000000005,91.820999999999998]
["18","        Services",65.748000000000005,68.555000000000007,70.165000000000006,71.456000000000003,72.322999999999993,73.683000000000007,75.137,75.897999999999996,75.739999999999995,76.325000000000003,78.159000000000006,77.106999999999999,76.951999999999998,79.171999999999997,82.236000000000004,85.634,88.49,91.504000000000005,94.745999999999995,91.385999999999996,94.197000000000003,97.998999999999995,100,102.099,104.708,104.60599999999999,106.4,109.155,112.495,114.38500000000001]
["19","    Imports",79.233000000000004,78.572999999999993,78.635999999999996,78.033000000000001,78.766000000000005,80.924000000000007,79.513999999999996,76.75,72.617999999999995,73.019000000000005,76.221000000000004,74.222999999999999,73.242000000000004,75.453999999999994,79.06,83.703000000000003,86.909000000000006,89.921000000000006,98.96,87.986999999999995,92.783000000000001,99.825999999999993,100,98.635999999999996,97.853999999999999,90.23,87.087999999999994,88.997,91.566000000000003,90.215000000000003]
["20","        Goods",83.055999999999997,81.486000000000004,81.040000000000006,80.134,80.718000000000004,82.87,80.77,77.433999999999997,72.757000000000005,72.8,76.641000000000005,74.463999999999999,73.096999999999994,74.686999999999998,78.231999999999999,83.183000000000007,86.528000000000006,89.429000000000002,99.233999999999995,86.628,92.052000000000007,99.912999999999997,100,98.054000000000002,96.738,87.596999999999994,83.888000000000005,85.742000000000004,88.183000000000007,86.393000000000001]
["21","        Services",63.655000000000001,65.983000000000004,67.835999999999999,68.411000000000001,69.753,71.930999999999997,73.725999999999999,73.724000000000004,72.281999999999996,74.537000000000006,74.259,73.213999999999999,74.271000000000001,79.866,83.817999999999998,86.721000000000004,89.134,92.77,97.798000000000002,94.510999999999996,96.415999999999997,99.391999999999996,100,101.575,103.55800000000001,103.994,103.892,106.089,109.34,110.401]
["22","Government consumption expenditures and gross investment",52.113,54.005000000000003,55.642000000000003,56.953000000000003,58.463000000000001,60.122999999999998,61.354999999999997,62.56,63.624000000000002,65.778000000000006,68.600999999999999,70.566999999999993,72.393000000000001,75.028000000000006,78.153000000000006,82.11,85.661000000000001,89.492000000000004,93.316999999999993,92.930999999999997,95.385999999999996,98.284999999999997,100,102.33199999999999,104.435,104.598,104.926,107.398,111.312,113.43899999999999]
["23","    Federal",57.25,59.308999999999997,60.823999999999998,62.151000000000003,63.860999999999997,65.837999999999994,66.936999999999998,67.971999999999994,68.840999999999994,70.519000000000005,72.885999999999996,74.236000000000004,76.631,80.007999999999996,82.76,86.203999999999994,88.948999999999998,91.59,94.403999999999996,94.213999999999999,96.421000000000006,99.07,100,100.931,102.63200000000001,103.128,103.711,105.843,109.089,111.11]
["24","        National defense",57.161999999999999,58.963999999999999,60.677999999999997,61.615000000000002,63.228999999999999,65.027000000000001,66.114000000000004,67.034999999999997,67.870999999999995,69.558999999999997,71.908000000000001,73.27,75.713999999999999,79.504999999999995,82.263000000000005,86.010999999999996,89.022000000000006,91.75,94.801000000000002,94.126000000000005,96.128,98.945999999999998,100,100.60899999999999,102.056,102.334,102.696,104.449,107.477,109.256]
["25","        Nondefense",57.093000000000004,59.786999999999999,60.825000000000003,62.994,64.897999999999996,67.222999999999999,68.343999999999994,69.590999999999994,70.518000000000001,72.177999999999997,74.578000000000003,75.906000000000006,78.221999999999994,80.894999999999996,83.637,86.531000000000006,88.799000000000007,91.281999999999996,93.664000000000001,94.364000000000004,96.941999999999993,99.289000000000001,100,101.476,103.593,104.428,105.342,108.04,111.619,114.014]
["26","    State and local",49.152999999999999,50.953000000000003,52.69,54.002000000000002,55.393999999999998,56.871000000000002,58.177,59.470999999999997,60.63,63.008000000000003,66.031999999999996,68.281000000000006,69.814999999999998,72.05,75.369,79.608999999999995,83.617000000000004,88.132999999999996,92.558000000000007,92.048000000000002,94.668999999999997,97.739000000000004,100,103.279,105.645,105.598,105.77,108.45,112.77500000000001,114.96899999999999]
["","Addendum:","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["27","    Gross national product",63.637,65.801000000000002,67.299000000000007,68.891000000000005,70.36,71.843000000000004,73.161000000000001,74.423000000000002,75.263000000000005,76.347999999999999,78.052999999999997,79.763999999999996,81.025999999999996,82.533000000000001,84.754000000000005,87.394999999999996,90.040999999999997,92.46,94.268000000000001,94.997,96.102000000000004,98.117999999999995,100,101.754,103.626,104.596,105.69,107.67700000000001,110.261,112.227]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1*AF8/$Q8","v":1.3241920264213258}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,101.642]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,104.081]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(AS40:AS41)","v":102.86150000000001}]

{"sheet":"Drop down lists","index":20,"n_rows":36,"n_cols":1,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
["Haz Inputs and Wastes"]
["(Select)"]
["lbs"]
["gal"]
[]
["Air Emissions"]
["(Select)"]
["lbs"]
["kg"]
["tons"]
["metric tons"]
[]
["Energy"]
["(Select)"]
["therms"]
["BTU"]
["cubic feet"]
[]
["Electricity"]
["(Select)"]
["kWh"]
["Gj"]
["therms"]
["BTU"]
[]
["Waste"]
["(Select)"]
["tons"]
["kg"]
["lbs"]
["gal"]