Electronic Reporting Tool (ERT)
On This Page:
- Introduction
- Installation, Program Files and User's Guide
- ERT Field and Header Data Import Spreadsheets and XML Schema
- ERT User's Guide, Updated May, 2024
- Submitting ERT Files to CDX/CEDRI
- WebFIRE Import Spreadsheets
Introduction
Version 7.0, released March 12, 2024 Updated 5/28/24
The ERT is used to electronically create stationary source sampling test plans and reports. The ERT will calculate the test results from data imported or hand-entered and includes supporting documentation to create a complete electronic report for submittal to the regulatory agency.
Affected industrial facilities are required to submit emissions test results electronically. This can be accomplished by using the Electronic Reporting Tool (ERT) or, depending on the regulation, an electronic file consistent with the ERT full xml schema. Facilities should review the applicable regulations to determine the exact requirements for their source. The facilities will submit these files to CDX using CEDRI. The submission files are stored in the CDX CROMERR archive and become available to submitters and authorized reviewers immediately upon submission. After 60 days, the files will be available to the public in WebFIRE.
The ERT provides a format that:
- Highlights the need to document the key information and procedures required by the existing EPA Federal Test Methods;
- Facilitates coordination among the source, the test contractor, and the regulatory agency in planning and preparing for the emissions test;
- Provides for consistent criteria to quantitatively characterize the quality of the data collected during the emissions test;
- Standardizes the reports; and
- Provides for future capabilities to electronically exchange information in the reports with facility, State or Federal data systems.
ERT Version 7 has a new feature for source sampling reports:
- Miscellaneous method data can be added to the Miscellaneous method table.
- Miscellaneous method import spreadsheet
ERT Version 7 also includes a Wood Heater Application and Certification Module. The wood heater module within the ERT is an optional platform that, if manufacturers choose, may replace the time-intensive preparation of test reports and application packages to the Agency. When manufacturers enter performance data, the ERT will create a wood heater certification application for obtaining an EPA certificate of compliance. The ERT will calculate results using the information and data entered by the manufacturer and create the test results as an electronic submission package or report for the EPA. The submission data package created using the ERT can be electronically submitted to the EPA via W[email protected].
Announcements about the ERT will be made available on the CHIEF Listserv. Notices are sent directly to a member's email address.
Installation, Program Files and User's Guide
ERT version 7.0 Released March 12, 2024 Updated 5/28/24
ERT Version 7 Program Files - May 28, 2024 (14 MB). NOTE: ERT Application and data file must be located on a local computer and not the network or thumb drive to work consistently. ERTv6 has been updated to ERTv7. Because there are issues with executable file download, a zip file is located by the link. This version of the program requires either MS Access 2010, MS Access 2013, MS Access 2016 , MSAccess 2019, MSAccess 365 or MS Access Runtime. Download the zip file to your hard drive, open and unzip the file will give access to the manual and the database to a folder that you select. If you do not have MS Access 2010, 2013 or 2016, 2019 or 365 download and install the version of MS Access Runtime for the version of Office that you have installed on your computer. MS Access 365 Runtime will work with Office 365 and Office 2019. Running the ERT application (ERT6.accdb) will open the program with MS Access.
Example ERT Project Data Sets (PDS) and field data import files
Two example Project Data Sets are available for use as examples of comprehensive data entry and documentation. The file Method 29-30B Example Data 2014 (zip) contains a populated Project Data Set example of single and paired train manual test methods. A second Project Data Set which is unpopulated is provided for users to test the importing of field data. Included in the ZIP file are two spreadsheet files and two XML files for use in demonstrating importing the point and header field data. The file RATA DATA Demo 08-27-2012 (zip) contains a populated Project Data Set example of instrumental test methods and the performance specifications for those test methods. Updated October 2014.
ERT Field and Header Data Import Spreadsheets and XML Schema
Who should use this spreadsheet or XML schema?
Companies that perform stationary source emissions tests using test methods that are supported by ERT such as US EPA Methods 1 through 5 or EPA Method 30B should consider using the following spreadsheets/schema. These tests require the measurement and documentation of different parameters at multiple points across each emission measurement location. Some companies document this information in spreadsheets that they have programmed to assist them in calculating proper equipment operation(s) and preparation of that information for a test report. Other companies have sampling equipment with electronic sensors, controls, and software programs to perform much of the data collection and documentation. The equipment used by the latter individuals export the collected information in a variety of formats for calculations and report preparation.
There are 5 Import spreadsheets:
- 1. Isokinetic Methods Import Sheet (xltm)
- 2. File Instrumental Methods Import Spreadsheet v4 (xltm)
- 3. Method 30B import template (xltm) ,
- 4. Miscellaneous Methods Import sheet (xltm)
- 5. Wood heater method ASTM 2515 import sheetv2 (xltm)
The ERT has the ability to import stack test data for manual test methods from either a specially formatted spreadsheet or from an XML file complying with an established Schema (available through a link in the next paragraph). We have prepared four properly formatted spreadsheet templates which companies may use to import data into the ERT. These are intended to reduce the effort associated with field data entry into the ERT and improve the reliability of data transcription. The document, Requirements for modifying a spreadsheet for ERT import (3 pp, 25 K, About PDF), describes how to merge the ERT point and header data spreadsheet template with a proprietary corporate field data spreadsheet so you can use the import function into the ERT.
The Isokinetic and manual methods import sheet (3. above) includes instructions for importing the common point and header data when a single sample train is used for each test run. The Method 30B import template (2. above) is a spreadsheet that includes instructions for importing similar data when dual sample trains are used for each test run. We also have two XML Schema for ERT field data which are alternatives to the spreadsheet templates. Equipment vendors would be the most likely users of the Schema to program their equipment to generate XML files that the ERT can import. The Schema
ERT Single Sampler Manual Method XML Schema (XSD) (xsd)
is used to describe the format of an export file for single sample train equipment.
The Wood heater method ASTM 2515 import sheet (4. above) is for test data entry for Particulate Matter from residential wood heaters.
The Schema Method 30 data dictionary (xsd) is used to describe the format of an export file for dual sample train equipment. Either the spreadsheet or the XML file may be used to import the test data to ERT thus significantly reducing time, and effort. The spreadsheet has the capability to import the header and point data for up to nine test runs for a single test method and location. Files complying with the XML Schema can import an unlimited number of test runs. Updated October, 2014.
ERT User's Guide, May 2024
The
ERT User Manual V7 May 2024 (pdf)
(236 pp, 8.0 M, About PDF) has been expanded and updated to support the increased capabilities of ERT version 7. To assist the user to quickly locate the specific area of interest, the Table of Contents and the Table of Figures include "Hot Links" to the applicable page for that topic and the training videos. We have also prepared a comprehensive set of videos addressing individual ERT use areas. The videos are available on the ERT Training and Webinars webpage.
Please read the
ERT version 7 Update history 5 28 2024 (pdf)
(47 pp, 258 K, About PDF) to keep track of changes and corrections in the program. The document includes technical information about changes from versions 3 to 4, 4.1, 5.0, 6.0 and the new changes in version 7.0.
Submitting ERT Files to CDX/CEDRI
The Compliance and Emissions Data Reporting Interface (CEDRI) instructions for registering and accessing CEDRI are in the CEDRI Job Aides. CDX (Central Data Exchange) support is available Monday through Friday (except on holidays) from 8:00am to 6:00pm (ET). The phone number is 888-890-1995.
EPA now requires by regulation a number of industries to perform emissions performance tests and to electronically submit such emissions test data to EPA. Please see the list of Promulgated Regulations with Electronic Data Reporting Requirements(2 pp, 147 K, About PDF).
The Central Data Exchange (https://cdx.epa.gov/epa_home.asp) is the point of entry of emissions performance data reports to EPA. It provides capabilities for submitters to submit and access their data electronically and enables OAR to effectively manage the incoming data.
WebFIRE Import Spreadsheets
Spreadsheet template for importing test data to WebFIRE and test quality rating tool for Regulatory Agencies
Who should use this spreadsheet?
EPA's emissions factors development procedures begin with source emissions data that has been quality assured using a set of objective review questions that assess the quality of the process, control device and measurement data collected during an emissions test and reported in the ERT file. Emissions data collected after January 1, 2012 using test methods already adapted to the ERT format include the requisite data to enter EPAs emissions factor development process. However, not all source emissions data can be documented in the ERT.
In order to allow non-ERT documented data to enter the emissions factor development process, we have developed a spreadsheet tool for companies, associations, and agencies to provide EPA with emissions data collected prior to January 1, 2012 or that is infeasible to document in the ERT. This spreadsheet has a structured format which organizes the basic source emission information used for emissions factor development including supplementary information for more detailed characterization of the source and the measurements.
The spreadsheet also includes a two part check sheet that is identical to the one in the ERT for assessing the information in the supplied emissions test report. The first part of the check sheet is for use by the provider of the test data and is used to document the presence of supporting documentation needed to assess the representativeness, accuracy and precision of the information in the test report. A numeric quality rating is determined for each test report based upon the answers to these questions. As with the ERT completeness and quality assessment, this quality rating by the report supplier can be adjusted based on responses from an independent regulatory agency using the second part of the check sheet. The second part of the check sheet provides for a more thorough and detailed assessment of information in the test report. Companies, associations and agencies should use the following spreadsheet template to submit their input to WebFIRE.
WebFIRE Template and Test Quality Rating Tool (including instructions) (xlsx) (XLS 64 K). Updated April 2015.
The spreadsheet allows source test data to be added to WebFIRE electronically. In addition to the completed WebFIRE spreadsheet template file, an electronic copy (PDF) copy of the entire report documenting the source test must be provided. The source test must include documentation supporting affirmative responses in the WebFIRE spreadsheet fields (columns).
Send the files to EPA on CD or DVD to the following address:
US EPA
Group Leader
Measurement Policy Group, OAQPS
Mail Code D243-05
RTP, NC 27711
Email your comments to Theresa Lowe at [email protected]. We will update this software and the User's Guide periodically as reviewers identify easily to accommodate expansion, enhancement or corrections in the application.