Welcome to the Emission Inventory (EI)/Tribal Emission Inventory Software Solution (TEISS) Training Curriculum: Course 1-EI Fundamentals
Module 10-Presenting Results in an EI
SLIDE 1: This module includes a summary on what information to include in your written EI report. It also shows how to incorporate the TEISS reports in your EI. Learning objectives for this session:
· Know how to structure your written EI report
· Know how to generate, modify, and export TEISS reports for inclusion in your EI.
SLIDE 2: Goal of the EI Process
The goal of the EI process is a written report specific to your reservation. A complete written EI report gives enough information that a reviewer could duplicate results and includes a summary up front for readers who do not want the details. Your TEISS project includes much of this information, but putting the information in a written EI report allows anyone to see the results of your EI efforts. Most people that are interested in your EI like your boss, EPA project officer, etc., do not have TEISS installed on their computers so you need to present the data outside of TEISS.
SLIDE 3 and SLIDE 4: Elements of a Report
EI reports typically include:
· Base Year
· Geographic Area, including maps
· Pollutants Covered,
o Criteria pollutants only OR
o Selected criteria pollutants OR
o Criteria pollutants and selected HAPs
o If selecting only certain criteria pollutants or HAPs, include an explanation of why you selected them, for example, a concern is haze associated with PM2.5
· Source Categories
o Point
o Nonpoint
o Onroad
o Nonroad
o Events
o Biogenic
· Data, can be displayed in
o Maps, for example, a TEISS map showing the location of facility emissions
o Tables, can be exported from TEISS
o Charts, can be exported from TEISS
· Assumptions
o Examples:
§ It is assumed that the NEI data has been through quality assurance/quality control (QA/QC) procedures
§ For a gas station that did not report the amount of gasoline sold, it was assumed that the gasoline sold value was the same as that of a nearby gas station of the same size
· Calculations, include examples of any calculations you do outside of TEISS
· References
· Questionnaires or Surveys with Results, include examples of questionnaires and surveys you used with a results summary
Depending on the level of your EI, you might not have each of these elements in your EI. For example, if you are doing a Level 4 EI, you are likely not going to have calculations or a questionnaire and survey element since your EI is composed of existing data.
SLIDES 5, 6, and 7: EI Report Sections
1. Executive Summary
q Introduction Summary
o What is the purpose of your EI?
o What pollutants are covered?
o What is the base year?
o What source types are included?
o What geographic area is covered?
q Results Summary
o What did you find out, include a summary table with separate sections for sources off the reservation and on the reservation (if inventoried).
o What recommendations do you have? For example, if there is a Title V source with large emissions on or near the reservation, a recommendation might be to obtain the operating permit for the facility to get more details on the operations there.
2. Introduction
q Reservation Environment
o Description and size of reservation land
o Reservation population
o Meteorology
o Description of the air basin or airshed the reservation is located in
o Health and environmental concerns
o Attainment status
q Geographic Area
o Maps
q Emission Inventory History
o Has there been previous reservation EIs and if there has, include a brief summary of the findings.
q Use of Emission Inventory Data
o Examples:
· To support the development of plans to protect and monitor reservation air quality
· To show trends in air quality
· To support a Tribal Implementation Plan
· To participate in Regional Planning tribal efforts to protect visibility
· To assess the need for a tribal permitting program
o What is the level of your EI?
q Emission Inventories from Surrounding Area
o Brief description of external emissions data you obtained, for example NEI data at the county level, include the year and version of the data
3. Results for Each Source Type (each source type you include, for example, point, nonpoint, onroad, nonroad, etc., needs to have a section in the EI)
q Off-Reservation Sources
o For each pollutant of interest, include tables, charts, and text explaining your analysis of the emissions data
q On-Reservation Sources, if included
o For each source you estimated emissions for include
· Data Collection Methods
· Data Calculation Methods, if using TEISS calculators, specify what calculator you used and give the source the calculator is based on. Include what data you entered into the TEISS calculator and the source of the data. If not using the TEISS calculators or if you calculated the throughput, include an example calculation.
· Results, what are the estimated emissions, can be in a table format
· Quality Assurance/Quality Control (QA/QC) Procedures, more on what is included in QA/QC in the next training
4. Conclusion
q Next Steps
q Plans for Future Emission Inventories
5. References
6. Appendices, includes large volume of detailed data, survey results, etc.
Keep in mind that different EPA regions have different requirements on what to include in an EI. Make sure that you clarify what to include in your EI with your project officer. It would be best to do this before you start writing your EI.
SLIDE 8: EI Presentation
Your EI should have each of these
¡ Cover Page
¡ Table of Contents
¡ List of Tables
¡ List of Figures
¡ List of Abbreviations
This gives your EI a formal feel.
SLIDE 9: TEISS Reporting Functions
TEISS does not write your EI report. However, there are certain places in TEISS you can copy from and paste into your written report, for example if you used the IPP or QA/QC tabs. You can export maps, tables, and charts from TEISS and include them in your report. Next we are going to focus on the TEISS reporting functions.
SLIDE 10: Example Map
This slide shows an example of the map that the Confederated Tribes of the Colville Reservation exported from TEISS and used in their EI. We have already discussed exporting maps from TEISS. As a refresher, this map was generated by selecting File from the TEISS menu and then selecting Print.
SLIDE 11: Accessing the TEISS Reports Screen
The TEISS Reports screen can be accessed by clicking on the Reports icon in the TEISS toolbar. It can also be accessed by selecting Output from the TEISS menu and then selecting Reports. On the left side of the Reports screen is a list of the TEISS reports. Those with a small chart icon have a graph associated with the report. You should spend some time playing with the different reports and decide what reports would fit best into your EI. The “by Facility Top 10” is good for analyzing NEI county-level point source data. For a selected area and pollutant, it shows the 10 facilities with the highest emissions. After clicking on that report, you go through several screens where you specify the criteria for what you want to include in the report, for example, the area and pollutant.
SLIDE 12: Example “by Facility Top 10” Report
This slide shows an example of the “by Facility Top 10” report. I specified a Location of Coconino County, CO as the pollutant, a Reporting Period of Annual, and emission value units of tons. This is shown on the report.
I also specified a chart type of Vertical Bar Chart.
SLIDE 13: Example of “by Facility Top 10” Report (cont.)
This slide shows the chart that is the second page of the report. If I had selected multiple pollutants, the report would be structured so that the first two pages (a table on the first page and a chart on the second page) would be associated with the first pollutant, then the next two pages would be associated with the next pollutant, etc.
SLIDE 14: Making Changes to the TEISS Reports
If after you generate a report, there is something you want to change about it, such as the area, pollutants, etc., you can go back to the windows where you specified the report criteria. You do this by clicking on the Filter button at the top right of the Reports screen. You can also quickly change the chart type by clicking on the icons under the Filter button at the top right of the Reports screen. The other icons next to the chart type icons auto size the chart, show/hide the data labels, and show/hide the legend.
SLIDE 15: Making Changes to the TEISS Reports (cont.)
This slide shows the same data displayed in a pie chart. I clicked on the pie chart icon to quickly change the chart types. The data labels are overlapping and I am going to click on the Auto Size icon to try to fix it. Note that sometimes this button works and sometimes it causes other issues, for example, I have had data labels run off the page after clicking on it. If you do not like the results of the Auto Size icon, you can click on the icon again to undo it. Sometimes it takes some work to get the chart to display how you want it.
SLIDE 16: Making Changes to the TEISS Reports (cont.)
The Auto Size icon worked on this chart.
SLIDE 17: Example “by SCC Top 10” Report for Nonpoint Sources
The “by SCC Top 10” report is good for analyzing NEI county-level nonpoint data. This slide shows an example of the “by SCC Top 10” report for nonpoint sources. When I specified the criteria for this report, I specified SCC Level 10. This gives the emissions at the most detailed level, however, it usually causes crowding on the x axis of the chart and in the chart legend. It is usually more detail than you need. For example, you can see in the chart legend that there is an entry for Railroad Line Haul Locomotives Class I emissions and Railroad Line Haul Locomotive Class II/III emissions. You probably do not need the emissions allocated out by the Line Haul Locomotive Class levels. I suggest using the Filter button to change the SCC Level.
SLIDE 18: Example “by SCC Top 10” Report for Nonpoint Sources (cont.)
This slide shows the chart with the SCC Level changed to SCC Level 7. Usually, SCC Level 7 is the most detail you need when presenting and analyzing data.
SLIDE 19: Exporting TEISS Reports
To export TEISS reports, click on the icon that looks like an open envelope near the top of the TEISS Reports screen. Select the format you want and click the OK button to be prompted for a location to save the exported file. It is easiest to import the TEISS reports into your EI if you export them in Microsoft Word. You can also edit them in Microsoft Word, removing headings or any text you do not need, or adding text as you see fit. Then they can be easily copied and pasted into your EI.
SLIDE 20: Adding TEISS Reports to Written EI Results Section
This slide shows an example of adding TEISS reports to an EI. It includes a short write-up describing what can be seen in the table and graph. This could be the NOx sub-section for nonpoint sources included in the off-reservation results section of the EI. This is what is included on the slide.
This is a table and chart showing the top 10 nonpoint SCCs that emit NOx in the county of interest. This shows that in the county of interest, the railroads contribute the most NOx emissions for nonpoint sources at 78% of the total for nonpoint sources. The next highest source of NOx emissions for nonpoint sources is prescribed forest fires at 18% of the total for nonpoint sources. Together, these two sources contribute 96% of the nonpoint NOx emissions in the county of interest.
Demonstration of TEISS Reports: I am going to demonstrate how to generate a TEISS report. First, I click on the Reports icon in the TEISS toolbar to open the TEISS Reports screen.
I am going to demonstrate the “by SCC Cross-Tab” report for nonpoint sources. This report does not have a chart associated with it. In contrast to the “by SCC Top 10” report, it shows the pollutants together rather than on separate pages. I am going to click on the by SCC Cross-Tab report under the Nonpoint Sources folder. That brings up the screens for specifying report criteria. The first criterion to specify is the location. This time, I am going to try looking at data for two counties, Coconino County and Yavapai County. I select those two counties.