1 / 41

GREENER CLEANUPS ESTIMATING ENVIRONMENTAL FOOTPRINTS USING SEFA

GREENER CLEANUPS ESTIMATING ENVIRONMENTAL FOOTPRINTS USING SEFA. S preadsheets for E nvironmental F ootprint A nalysis. Carlos Pachon, US EPA HQ (Superfund) Karen Scheuermann, US EPA Region 9. October 28, 2014. SEFA. Purpose of SEFA Webinar. Provide a basic understanding of SEFA

mstrickland
Download Presentation

GREENER CLEANUPS ESTIMATING ENVIRONMENTAL FOOTPRINTS USING SEFA

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. GREENER CLEANUPSESTIMATING ENVIRONMENTAL FOOTPRINTS USING SEFA SpreadsheetsforEnvironmentalFootprintAnalysis Carlos Pachon, US EPA HQ (Superfund) Karen Scheuermann, US EPA Region 9 October 28, 2014

  2. SEFA Purpose of SEFA Webinar • Provide a basic understanding of SEFA • Demonstrate general organization and specific functions of the SEFA worksheets • Open forum for discussion of footprint analyses and advanced features in SEFA SpreadsheetsforEnvironmentalFootprintAnalysis • 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

  3. Agenda SEFA • Overview 10 min • Carlos Pachon • 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 • 5) Q/A on Key Features 10 min • Carlos Pachon • 6) Open Forum / Advanced Features 15 min • Karen Scheuermann / Carlos Pachon • 7) Wrap-up 10 min • Carlos Pachon SpreadsheetsforEnvironmentalFootprintAnalysis

  4. SEFA 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 is a companion tool to EPA’s Footprint Methodology • SEFA was originally posted on Clu-in April 2012 and updated August 2014 SpreadsheetsforEnvironmentalFootprintAnalysis EPA’s May 2013 Webinar discussed the Methodology in greater detail Find the Footprint Methodology and SEFA at http://clu-in.org/greenremediation/methodology/index.cfm

  5. SEFA The Role of Footprint Analysis in Greener Cleanups Small cleanup project, or standard cleanup approach Green Remediation Goals in Cleanup Project (Client request, Contractual Requirement, Regulatory requirement, etc) Select and apply specific best management practices Large complex projects Quantify footprint, prioritize reduction targets • ASTM Standard Guide for Greener Cleanups (E2893): • 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

  6. SEFA Cluin.org/greenremediation SpreadsheetsforEnvironmentalFootprintAnalysis

  7. Agenda SEFA P • Overview 10 min • Carlos Pachon • 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 • 5) Q/A on Key Features 10 min • Carlos Pachon • 6) Open Forum / Advanced Features 15 min • Karen Scheuermann / Carlos Pachon • 7) Wrap-up 10 min • Carlos Pachon SpreadsheetsforEnvironmentalFootprintAnalysis

  8. Basics of SEFA SpreadsheetsforEnvironmentalFootprintAnalysis • SEFA is… • a set of Excel workbooks developed by EPA • 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

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

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

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

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

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

  14. 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 Bioremediation Year 1 Pump and Treat Hazardous Waste Transport Bioremediation Year 2 Pump and Treat w/ UV Municipal Solid Waste Transport Bioremediation Year 3 Pump and Treat w/ Solar Power Remediation Materials Bioremediation Year 4 Pump and Treat w/ Re-injected GW Grid Electricity Close-out Year 5 Off-Site Services Personnel Transportation

  15. INPUT WORKBOOK User sets up the structure for data entry

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

  17. Basics of SEFA Conceptual Approach to Setting up SEFA Worksheets

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

  19. INPUT WORKBOOK User enters specific information about the remedy Link to Remedy Component Input Template Tab page 1 Personnel Transportation • Looks like lots of blank cells to fill in, but… • use only the cells that are relevant to the site • enter as much (or as little) detail as needed On-site Equipment Use and Transport User should note any assumptions and items that are screened out • Natural Gas • and • Landfill Gas On-Site Electricity Usage

  20. INPUT WORKBOOK User enters specific information about the remedy Input Template Tab page 2 Materials Use and Transport • Where do we get inputs for the footprint analysis? • Feasibility Study • Cost Estimate • Engineering Designs • Literature Search • Professional Judgment Waste Disposal and Transport Water Use User should provide references and supporting calculations

  21. INPUT WORKBOOK User enters specific information about the remedy Input Template Tab page 3 Off-Site Laboratory Analysis Other Voluntary Renewable Energy Use The data entry tabs make certain calculations such as fuel usage. Other Energy Use and Air Emissions Space for Notes, References, and Supporting Calculations Results of the data entry tabs are compiled in the Input Summary tab.

  22. 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 The results are sent to the Calculations Workbook Three pages of compiled results Input Summary tab

  23. CALCULATIONS WORKBOOK Make footprint calculations Energy GHG NOx SOx PM HAPs Materials, Energy, Water, Waste, and Off-site Support Activities Units and Usage The Calculations Workbook receives results from the Input Workbook … … and applies footprint conversion factors. Seven pages of footprint 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

  24. MAIN WORKBOOK Summarize and present results Materials Waste This table compiles the results as recommended in EPA’s Footprint Methodology. Water Energy Air Emissions

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

  26. MAIN WORKBOOK Summarize and present results • The user has access to intermediate results • in SEFA • understand contributors to the remedy footprint • target areas for footprint reduction The user can make charts like this from results in the Calculations Workbook.

  27. Basics of SEFA Testing Alternative Scenarios SEFA can be used to compare footprints for alternative scenarios What if…. ? … I use reclaimed water instead of public water for dust control? ? … 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?

  28. Basics of SEFA SpreadsheetsforEnvironmentalFootprintAnalysis • SEFA is… • a set of Excel workbooks developed by EPA • 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

  29. Agenda SEFA P • Overview 10 min • Carlos Pachon • 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 • 5) Q/A on Key Features 10 min • Carlos Pachon • 6) Open Forum / Advanced Features 15 min • Karen Scheuermann / Carlos Pachon • 7) Wrap-up 10 min • Carlos Pachon P SpreadsheetsforEnvironmentalFootprintAnalysis

  30. Agenda SEFA P • Overview 10 min • Carlos Pachon • 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 • 5) Q/A on Key Features 10 min • Carlos Pachon • 6) Open Forum / Advanced Features 15 min • Karen Scheuermann / Carlos Pachon • 7) Wrap-up 10 min • Carlos Pachon P P SpreadsheetsforEnvironmentalFootprintAnalysis

  31. 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

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

  33. 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

  34. 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 Your footprint analysis can be tailored to specific questions at your site • The user: • sets up structure of analysis to reflect site • provides remedy inputs and documentation  • enters data directly into the spreadsheets EPA is using SEFA at some of our cleanup sites and we welcome the use of SEFA by site owners and PRPs

  35. Demonstrate Key Features in SEFA Instructions in SEFA provide full information on these features SEFA has additional features such as: Tutorial illustrating all features of SEFA will be available on Clu-in Modeling renewable energy sources 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.

  36. Agenda SEFA P • Overview 10 min • Carlos Pachon • 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 • 5) Q/A on Key Features 10 min • Carlos Pachon • 6) Open Forum / Advanced Features 15 min • Karen Scheuermann / Carlos Pachon • 7) Wrap-up 10 min • Carlos Pachon P P SpreadsheetsforEnvironmentalFootprintAnalysis P

  37. Agenda SEFA P • Overview 10 min • Carlos Pachon • 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 • 5) Q/A on Key Features 10 min • Carlos Pachon • 6) Open Forum / Advanced Features 15 min • Karen Scheuermann / Carlos Pachon • 7) Wrap-up 10 min • Carlos Pachon P P SpreadsheetsforEnvironmentalFootprintAnalysis P P

  38. Agenda SEFA P • Overview 10 min • Carlos Pachon • 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 • 5) Q/A on Key Features 10 min • Carlos Pachon • 6) Open Forum / Advanced Features 15 min • Karen Scheuermann / Carlos Pachon • 7) Wrap-up 10 min • Carlos Pachon P P SpreadsheetsforEnvironmentalFootprintAnalysis P P P

  39. SEFA Wrap-up SpreadsheetsforEnvironmentalFootprintAnalysis • 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.

  40. Estimating Environmental Footprints Using SEFA Resources Contacts Footprint Methodology (full document) www.clu-in.org/greenremediation/subtab_b3.cfm Carlos Pachon, EPA OSRTI pachon.carlos@epa.gov Karen Scheuermann, EPA Region 9 scheuermann.karen@epa.gov Footprint Methodology (2-page fact sheet) 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_b3.cfm 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_b6.cfm Other Related Topics Thank you for your interest in Greener Cleanups!

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

More Related