GREENER CLEANUPS ESTIMATING ENVIRONMENTAL FOOTPRINTS USING SEFA SPREADSHEETS

GREENER CLEANUPS ESTIMATING ENVIRONMENTAL FOOTPRINTS USING SEFA SPREADSHEETS FOR ENVIRONMENTAL FOOTPRINT ANALYSIS Carlos Pachon, US EPA HQ (Superfund) October 28, 2014 Karen Scheuermann, US EPA Region 9

Purpose of SEFA Webinar Provide a basic understanding of SEFA Demonstrate general organization and specific functions of the SEFA worksheets SEFA Spreadsheets for Environmental Footprint Analysis Open forum for discussion of footprint analyses and advanced features in SEFA Notes: This webinar will be very technical, getting into the details of the SEFA worksheets Participants should already have a solid understanding of greener cleanups Participants should already be familiar with EPA’s Footprint Methodology Additional experience likely needed to run a footprint analysis on SEFA 2

SEFA Agenda 1) Overview 10 min Spreadsheets for Environmental Footprint Analysis Carlos Pachon 2) Basics of SEFA 30 min Karen Scheuermann 3) Q/A on Basics 10 min Carlos Pachon 4) Demonstrate Key Features in SEFA 30 min Karen Scheuermann 1) 2)5) Q/A on Key Features 3) Carlos Pachon 2) 3)6) Open Forum / Advanced Features min 4) Karen Scheuermann / Carlos Pachon 5) 6)7) Wrap-up 7) Carlos Pachon 10 min 15 10 min 3

Overview of Greener Cleanups Green Remediation: The practice of considering all environmental effects of remedy implementation and incorporating options to minimize the environmental footprints of cleanup actions Goal of Footprint Analysis: Identify the most significant contributors to a project’s environmental footprint and better focus efforts to reduce them EPA published Footprint Methodology February 2012 SEFA Spreadsheets for Environmental Footprint Analysis EPA’s May 2013 Webinar discussed the Methodology in greater detail SEFA is a companion tool to EPA’s Footprint Methodology SEFA was originally posted on Clu-in April 2012 and updated August 2014 Find the Footprint Methodology and SEFA at http: //clu-in. org/greenremediation/methodology/index. cfm 4

The Role of Footprint Analysis in Greener Cleanups Green Remediation Goals in Cleanup Project (Client request, Contractual Requirement, Regulatory requirement, etc) Small cleanup project, or standard cleanup approach Large complex projects Quantify footprint, prioritize reduction targets SEFA Select and apply specific best management practices ASTM Standard Guide for Greener Cleanups (E 2893): • Codifies best practices and defines a process for reducing environmental footprint • Includes over 160 BMPs and outlines process for straight BMP application or use of quantification • Useful protocol for contracting purposes • Results in a transparent documented process that is reported publicly 5

Cluin. org/greenremediation SEFA Spreadsheets for Environmental Footprint Analysis 6

Agenda 1) Overview 10 min Carlos Pachon 2) Basics of SEFA P 30 min Karen Scheuermann 3) Q/A on Basics SEFA Spreadsheets for Environmental Footprint Analysis 10 min Carlos Pachon 4) Demonstrate Key Features in SEFA 30 min Karen Scheuermann 1) 2)5) Q/A on Key Features 3) Carlos Pachon 2) 3)6) Open Forum / Advanced Features min 4) Karen Scheuermann / Carlos Pachon 5) 6)7) Wrap-up 7) Carlos Pachon 10 min 15 10 min 7

Basics of SEFA is… a set of Excel workbooks developed by EPA Spreadsheets for Environmental Footprint Analysis designed for conducting environmental footprint analyses at clean-up sites compatible with EPA’s Footprint Methodology set up in “blank slate” template format structured for inputting data, running calculations, and organizing outputs originally designed for internal EPA use placed on EPA web page for public access updated in August 2014

SEFA has been updated for ease of use and flexibility of application P P P Simplified and consolidated data entry Increased flexibility for user-specific inputs Graphical outputs in chart format Notes and instructions for all key features Acknowledgements to the following Tetra. Tech staff (past and present) who developed the original SEFA worksheets and made the current updates: Doug Sutton Mike Pavarini Rob Greenwald Calculator for groundwater well construction In this webinar we will focus on the features of the updated SEFA worksheets

SEFA in the context of Greener Cleanups Basics of SEFA Before SEFA After Run Footprint Analysis Identify Areas for Reduction Apply BMPs Achieve Footprint Reductions original clean-up ––––––––––> greener clean-up

These are the 7 steps recommended in EPA’s Footprint Methodology. S E F A Basics of SEFA in the context of EPA’s Footprint Methodology 1 Set Goals and Scope of Analysis 2 Gather Remedy Information 3 Quantify Onsite Materials & Waste Metrics 4 Quantify Onsite Water Metrics 5 Quantify Energy & Air Metrics 6 Qualitatively Describe Affected Ecosystem Services 7 Present Results SEFA helps to quantify the metrics.

Basics of SEFA Three Excel Workbooks Main Workbook Input Workbook User enters basic site and remedy information User sets up analytic structure Calculations Workbook No data entry by user in this workbook User enters data for remedy activities Workbook provides summary of results Workbook compiles the intermediate results Workbook makes the footprint calculations The user sets up the analytic structure The user enters information about the remedy The workbooks exchange data and process the results 12

MAIN WORKBOOK User sets up the basic structure of the footprint analysis Site Name and Remedy Name User may identify up to six Remedy Components … … to reflect stages of the remedy 13

MAIN WORKBOOK User sets up the basic structure of the footprint analysis The Remedy Components can be set up to differentiate among various aspects of the remedy. different stages of the remedy alternative remedy designs specific remedy activities separate years in the remedy Hazardous Waste Transport Bioremediation Year 1 Pump and Treat Municipal Solid Waste Transport Pump and Treat w/ UV Bioremediation Year 2 Pump and Treat w/ Solar Power Remediation Materials Bioremediation Year 3 Pump and Treat w/ Re-injected GW Grid Electricity Bioremediation Year 4 Off-Site Services Close-out Year 5 Personnel Transportation 14

INPUT WORKBOOK User sets up the structure for data entry 15

INPUT WORKBOOK User sets up a data entry tab for each activity in the footprint analysis User sets up the structure for data entry Make a copy of the Input Template tab Name the new tab to reflect the activity Up to 14 data entry tabs can be included in each footprint analysis. 16

Basics of SEFA Conceptual Approach to Setting up SEFA Worksheets

INPUT WORKBOOK Taking a closer look at the Input Template Color coding of the cells helps in data entry pink drop-down menus blue from look-up tables or calculated values yellow data entry by user The pink and yellow cells provide user flexibility in data entry 18

User enters specific information about the remedy INPUT WORKBOOK Te Inp mp ut lat pa e T ge ab 1 Link to Remedy Component Personnel Transportation Looks like lots of blank cells to fill in, but… use only the cells that are relevant to the site On-site Equipment Use and Transport enter as much (or as little) detail as needed User should note any assumptions and items that are screened out On-Site Electricity Usage Natural Gas and Landfill Gas 19

User enters specific information about the remedy INPUT WORKBOOK Inp mp ut lat pa e T ge ab 2 Te Materials Use and Transport Where do we get inputs for the footprint analysis? Waste Disposal and Transport Water Use Feasibility Study Cost Estimate Engineering Designs Literature Search Professional Judgment User should provide references and supporting calculations 20

User enters specific information about the remedy INPUT WORKBOOK Inp mp ut Off-Site lat pa e T ge ab Laboratory 3 Analysis Te Other Energy Use and Air Emissions Other Voluntary Renewable Energy Use Space for Notes, References, and Supporting Calculations The data entry tabs make certain calculations such as fuel usage. Results of the data entry tabs are compiled in the Input Summary tab. 21

INPUT WORKBOOK Link to the Input Summary tab This tab compiles the inputs and results from the data entry tabs User enters the names of the data entry tabs Subtotals are compiled for each data entry tab and (not shown) for each Remedy Component On-site diesel use Diesel & gasoline for transport Input Summary tab Three pages of compiled results The results are sent to the Calculations Workbook 22

CALCULATIONS WORKBOOK Make footprint calculations Energy GHG NOx SOx The Calculations Workbook receives results from the Input Workbook … Materials, Energy, Water, Waste, and Off-site Support Activities Units Seven pages of and footprint Usage PM HAPs … and applies footprint conversion factors. calculations No data entry by the user in this Workbook … … but the user may access the intermediate results from the worksheets. Results are sent to Main Workbook 23

MAIN WORKBOOK Summarize and present results This table compiles the results as recommended in EPA’s Footprint Methodology. 24

MAIN WORKBOOK Summarize and present results This chart is generated automatically in SEFA generates basic charts for Energy, GHG, NOx, SOx, PM, and HAPs. 25

id gr el e On ctr Ge s ic ne On ite ity ra sit die use tio e b s Tr n o iod el u Tr ans f gr ies se an po id el sp rt e us Tr ort atio lect e an at n r sp ion die icity or s ta bio el u tio di s n ese e ga so l us lin e e us e HD PE Li Cl me ea n D f Di r es ain ill Bi od el p roc ie ro k Ga sel duc so pro ed lin Of e duc fsi pr ed te Of so Pu odu fsi lid b c te w lic ed Of ha ast wa fsi z. e t te wa dis er p la bo ste osa ra dis l to po ry s an al al ys is e sit On Tons CO 2 e MAIN WORKBOOK 600 500 400 300 Summarize and present results Greenhouse gas emissions The user has access to intermediate results in SEFA understand contributors to the remedy footprint target areas for footprint reduction 200 100 0 The user can make charts like this from results in the Calculations Workbook. 26

Basics of SEFA What if…. … I use reclaimed water instead of public water for dust control? Testing Alternative Scenarios ? … I use biodiesel instead of conventional diesel? ? ? … I conduct more extensive site investigation, leading to reduction of the amount of contaminated soil sent to the landfill?

Basics of SEFA is… a set of Excel workbooks developed by EPA Spreadsheets for Environmental Footprint Analysis designed for conducting environmental footprint analyses at clean-up sites compatible with EPA’s Footprint Methodology set up in “blank slate” template format structured for inputting data, running calculations, and organizing outputs Can be set up to reflect any remedy design Automatically applies footprint conversion factors Compiles results consistent with EPA Methodology

Agenda 1) Overview 10 min Carlos Pachon 2) Basics of SEFA 30 min Karen Scheuermann 3) Q/A on Basics P P SEFA Spreadsheets for Environmental Footprint Analysis 10 min Carlos Pachon 4) Demonstrate Key Features in SEFA 30 min Karen Scheuermann 1) 2)5) Q/A on Key Features 3) Carlos Pachon 2) 3)6) Open Forum / Advanced Features min 4) Karen Scheuermann / Carlos Pachon 5) 6)7) Wrap-up 7) Carlos Pachon 10 min 15 10 min 29

Agenda 1) Overview 10 min Carlos Pachon 2) Basics of SEFA 30 min Karen Scheuermann 3) Q/A on Basics 10 min Carlos Pachon 4) Demonstrate Key Features in SEFA P P P SEFA Spreadsheets for Environmental Footprint Analysis 30 min Karen Scheuermann 1) 2)5) Q/A on Key Features 3) Carlos Pachon 2) 3)6) Open Forum / Advanced Features min 4) Karen Scheuermann / Carlos Pachon 5) 6)7) Wrap-up 7) Carlos Pachon 10 min 15 10 min 30

Demonstrate Key Features in SEFA (A) Brief walk-through of the workbooks Highlight some features that don’t show up on screenshots Will visit only a few tabs in the workbooks (B) Demonstrate three key features in SEFA Add a new activity to the remedy Provide the fuel mix for grid electricity Add new remedy material with unique footprint conversion factors Instructions in SEFA provide information on these three features 31

Demonstrate Key Features in SEFA Our Hypothetical Site Simple Dig & Haul Remedy Remediation at “Green Hills” Site 1 2 3 conduct site investigation excavate contaminated soil transport soil to off-site landfill backfill excavated areas 4 pump and treat system 5 conduct groundwater monitoring 6 In this demonstration a new activity (regrading) will be added to the remedy. 32

Demonstrate Key Features in SEFA Instructor opens SEFA Workbooks and demonstrates key features in the worksheets All three workbooks must be open at the same time 33

Demonstrate Key Features in SEFA Recap this has been a very simple site and remedy for a real site, can enter as much or as little detail as may be appropriate SEFA provides: format for data entry application of footprint conversion factors compilation of results The user: sets up structure of analysis to reflect site provides remedy inputs and documentation enters data directly into the spreadsheets Your footprint analysis can be tailored to specific questions at your site EPA is using SEFA at some of our cleanup sites and we welcome the use of SEFA by site owners and PRPs 34

Demonstrate Key Features in SEFA has additional features such as: Modeling renewable energy sources Instructions in SEFA provide full information on these features Tutorial illustrating all features of SEFA will be available on Clu-in Modeling carbon storage (e. g. from planting trees) Overriding fuel usage rates Representing alternative modes of transport and fuels These and other features in SEFA allow flexibility for accurately modeling specific site and remedy conditions. 35

Agenda 1) Overview 10 min Carlos Pachon 2) Basics of SEFA 30 min Karen Scheuermann 3) Q/A on Basics 10 min Carlos Pachon 4) Demonstrate Key Features in SEFA 30 min Karen Scheuermann 1) 2)5) Q/A on Key Features 3) Carlos Pachon 2) 3)6) Open Forum / Advanced Features min 4) Karen Scheuermann / Carlos Pachon 5) 6)7) Wrap-up 7) Carlos Pachon P P SEFA Spreadsheets for Environmental Footprint Analysis 10 min 15 10 min 36

Agenda 1) Overview 10 min Carlos Pachon 2) Basics of SEFA 30 min Karen Scheuermann 3) Q/A on Basics 10 min Carlos Pachon 4) Demonstrate Key Features in SEFA 30 min Karen Scheuermann 1) 2)5) Q/A on Key Features 3) Carlos Pachon 2) 3)6) Open Forum / Advanced Features min 4) Karen Scheuermann / Carlos Pachon 5) 6)7) Wrap-up 7) Carlos Pachon 10 min P P P SEFA Spreadsheets for Environmental Footprint Analysis 15 10 min 37

Agenda 1) Overview 10 min Carlos Pachon 2) Basics of SEFA 30 min Karen Scheuermann 3) Q/A on Basics 10 min Carlos Pachon 4) Demonstrate Key Features in SEFA 30 min Karen Scheuermann 1) 2)5) Q/A on Key Features 3) Carlos Pachon 2) 3)6) Open Forum / Advanced Features min 4) Karen Scheuermann / Carlos Pachon 5) 6)7) Wrap-up 7) Carlos Pachon 10 min P P P SEFA Spreadsheets for Environmental Footprint Analysis 15 10 min 38

SEFA Wrap-up Spreadsheets for Environmental Footprint Analysis SEFA is one part of EPA’s Greener Cleanups approach The SEFA worksheets are available on EPA’s Clu-in website EPA is continuing to use SEFA for our footprint analyses We welcome the use of SEFA by site owners and PRPs We’d love to hear of your experiences. If you have interesting application of SEFA let’s get the word out. 39

Estimating Environmental Footprints Using SEFA Resources Contacts Footprint Methodology (full document) Carlos Pachon, EPA OSRTI pachon. carlos@epa. gov Footprint Methodology (2 -page fact sheet) Karen Scheuermann, EPA Region 9 scheuermann. karen@epa. gov www. clu-in. org/greenremediation/subtab_b 3. cfm www. clu-in. org/greenremediation/methodology/docs/ GR_Overview_of_Footprint_Methodology_FS_3 -29 -12. pdf SEFA Worksheets www. clu-in. org/greenremediation/subtab_b 3. cfm Other Related Topics BMP Fact Sheets www. clu-in. org/greenremediation/ Profiles of Green Remediation www. clu-in. org/greenremediation/tab_d. cfm Archived Webinars www. clu-in. org/greenremediation/subtab_b 6. cfm Thank you for your interest in Greener Cleanups! 40

Reserved Applying Footprint Conversion Factors -- HDPE used onsite -- 20, 000 lbs HDPE Footprint Conversion Factor for CO 2 e emissions for PM emissions 20, 000 lbs HDPE 1. 9 lbs CO 2 e emitted per lb HDPE manufactured 38, 000 lbs CO 2 e same type of calculation for energy, NOx, SOx, and HAPs 0. 00064 lbs PM emitted per lb HDPE manufactured same set of calculations for all materials and services related to the remedy 13 lbs PM very simple calculations … … but there will be a lot of them!41