NERC | Northeast Recycling Council
Environmental Benefits Calculator© Northeast Recycling Council, Inc. (NERC), Updated April 2009 Download the Calculator in Microsoft Excel format About the Environmental Benefits Fact Sheet What Information Does the Calculator Produce? Instructions for Using the Calculator
NERC's Environmental Benefits Calculator is the most up-to-date, accurate, and comprehensive tool of its kind in the United States. It is usable by any state, region, county, town, institution, school and business in the United States. Among the Calculator’s unique features are the environmental benefits of computer recycling and reuse calculator, an energy savings comparison chart, and an emissions savings comparison chart. A great deal of effort went into ensuring that the Calculator, an Excel spreadsheet, is user-friendly. After entering an entity’s specific source reduction, reuse and recycling information, as well as the state-specific data from the web (the web links are provided in the Calculator itself), the Calculator produces detailed graphs and tables analyzing the environmental benefits of the recycling program. In addition, an Environmental Benefits Fact Sheet summarizing the Calculator results is provided.
NERC’s Environmental Benefits Calculator (in Microsoft Excel 2003; part of Office Professional Edition 2003) generates estimates of the environmental benefits of a study area, based on the tonnages of materials that are source reduced, reused, recycled, landfilled, or incinerated (includes waste-to-energy). The Calculator is based on per ton figures of the estimated energy use and emissions from several lifecycle analysis studies. The estimates are average figures based on "typical" facilities and operating characteristics existing in the United States. Factors that are not included in this Calculator are landfill gas recovery and generation of electricity by waste-to-energy. The Calculator incorporates U.S. EPA's most recent WARM Calculator, as well as, facts and figures for the U.S. Department of Energy, Steel Recycling Institute, Glass Packaging Institute, and U.S. Climate Technology Cooperation Gateway, to name a few. More facts and figures can be found cited throughout the Calculator. The Output Tables provided by the Calculator and the accompanying Fact Sheet are intended to be used as references by waste prevention officials and advocates in preparing outreach materials such as press releases, presentation slides, educational curricula, and articles. Completed Fact Sheets on the ten Northeast states can be found by following the links at the top of this page. By documenting some of the more important benefits of source reduction, reuse and recycling, the Calculator can be used to educate the public, legislators and others about these benefits, assist state and municipal employees to better understand the impacts of their waste management programs, support market development efforts, and to increase the public’s understanding of source reduction, reuse and recycling as a sustainable environmental strategy. The Calculator is usable by any state, region, county, town, institution, college, or business in the United States. It is limited to use in the U.S. because many of the data inputs and conversion factors are based on U.S.-specific data and technologies. In addition, the environmental savings presented in the Calculator are compared to state-specific data. This is important for local governments to keep in mind. U.S.-based businesses are encouraged to use the calculator to determine the environmental benefits of recycling their office wastes and by-products. However, since recycling is only a portion of a business’ activity, there is another model to assist in calculating the benefits of manufacturing and purchasing recycled content materials — the Recycled Content (ReCon) Tool, created by the U.S.Environmental Protection Agency and available at http://yosemite.epa.gov/oar/globalwarming.nsf/content/ActionsWasteToolsRecon.html. What Information Does the Calculator Produce? The Calculator yields the following detailed tables with accompanying descriptive charts:
Instructions for Using the Calculator Step 1 Go to “Worksheet 1. Data Inputs” to enter materials management data. Worksheet 1. Data Inputs is the place to input your area's data. This includes tonnages for source reduction, reuse, recycling, landfilling, and incineration/waste-to-energy. See notes to the right of the blue cells in the “Worksheet 1. Data Inputs” for additional tips on entering the materials management data. (If seeking state-specific materials management data and outside of the Northeast region, contact your state recycling agency for this information. The ten Northeast states’ data is run through the Calculator on a yearly basis, and the Fact Sheets summarizing the results can be found by following the links at the top of this page.) Step 2 Also in “Worksheet 1. Data Inputs,” enter state-specific data obtained through the Internet. This state-specific data includes statistics such as energy consumption and greenhouse gas emissions that puts your area's environmental benefits into context. Sources for this data and instructions for navigating through the sites to find your state’s data are provided in each Input Section of the worksheet. Please note: This state-specific data is already maintained by NERC for the ten Northeast states. If your study area is within one of these states, contact Athena Lee Bradley for a partially-completed version of the Calculator that includes this data. Step 3 Click on "Worksheet 2. Environmental Impacts,” using the tabs at the bottom of the spreadsheet. This sheet provides 15 automatically-generated tables from your inputted data. Each table is presented on a separate page with descriptive charts. Step 4 Produce a Fact Sheet Using a Mail Merge Word File. The accompanying Fact Sheet summarizes your area's environmental benefits from the Calculator into narrative form. The Fact Sheet is intended to be used as a marketing tool for educating the public about the environmental benefits of recycling.
To create your area's data-specific Fact Sheet, follow these instructions — but first read the special instructions in the box to the right. Download and save the Calculator in Microsoft Excel format and the Fact Sheet in Microsoft Word. The Fact Sheet is automated through Microsoft Word’s Mail Merge Feature. Complete the Calculator (Excel document) and save it on your computer. Then open the blank Fact Sheet in Word. In Word, display your Mail Merge toolbar. Depending on which version of Word you are using, there are different ways for this to happen: Depending on whether you used “A” or “B” follow the instructions below. For A
a. Select the Calculator Excel file. b. Select "Wksh 5. Fact Sheet Outputs" worksheet and unclick the box that says the data is in the first row (box should be empty) For B
For more information about or questions on NERC's Environmental Benefits Calculator, contact Athena Lee Bradley. |
|||||||||||||||||
