An official website of the United States government.

We've made some changes to EPA.gov. If the information you are looking for is not here, you may be able to find it on the EPA Web Archive or the January 19, 2017 Web Snapshot.

Energy Resources for State and Local Governments

Download AVERT

AVERT is divided into three components:

Which modules should I download?

Most users will only need to download AVERT’s Main Module and Regional Data Files. The Main Module estimates displaced emissions for energy efficiency (EE) and renewable energy (RE) programs in reference to a historical base year without the Statistical Module and Future Year Scenario Template. However, users who want to model displaced emissions with reference to user-created future years will need to download all three AVERT modules.

 

AVERT’s Main Module

AVERT Main Module Version History

Version # Release date Key changes
1 February 18, 2014
  • Original public version of AVERT.
1.2 November 21, 2014
  • Updates:
    • Modified default wind capacity factor data to more closely represent measured wind speeds.
  • Bugfixes:
    • Corrected transposition of NOx and SO2 columns in the Monthly Displacement Data by County table in Step 4.
1.3 April 28, 2015
  • Updates:
    • New pop-up box depicts percent generation in each state within an AVERT region. Instructions added for states that reside in multiple AVERT regions.
  • Bugfixes:
    • Corrected SMOKE output function bug.
1.4 April 25, 2016
  • Updates:
    • Added compatibility with Excel for Mac 2011.
1.5 March 6, 2017
  • Updates:
    • Added adjustment factor to account for avoided line losses associated with EE and distributed RE profiles.
    • Added daily avoided NOx by county output.
    • Improved data display on map figure.
    • Modified rounding of outputs to tens rather than hundreds place.
    • Added caution message for larger-than-recommended EE/RE profiles.
    • Updated compatibility to Excel for Mac 2016.
  • Bugfixes:
    • Corrected unit labeling of NOx and SO2  data blocks in RDFs.
    • Corrected peak-day-finding formula in post-processing sheets.
1.6 July 31, 2017
  • Updates:
    • Added PM2.5.
    • Adjusted the Statistical Module and Regional Data Files to account for avoided generation associated with parasitic loads at the point of generation.
    • Improved the way data are extrapolated for peak hours.
  • Bugfixes:
    • Corrected summation of annual NOX values.
    • Removed mismatches in AMPD-to-AVERT data import pipeline.
2.0 May 31, 2018
  • Updates:
    • Added output files compatible with EPA’s CO-Benefits Risk Assessment (COBRA) Health Impact Screening Tool.
  • Bugfixes:
    • Corrected code in the Statistical Module to ensure that AVERT will work with the newest version of MATLAB.

AVERT’s Main Module requires Excel 2007 or newer to run in Windows. The Main Module can also be used in Excel 2011 or newer for Mac. Download the following files to the same folder on a local computer or drive:

Regional Data Files for 2017, the most recent year available (find your region):  

To use AVERT’s Main Module, open the AVERT Main Module.xlsx file. Ensure that macros are enabled:

  • Windows: Navigate to the “Trust Center” in the “Options” menu, then select Trust Center Settings > Macro Settings > Enable all macros.
  • Mac OS: Select “Enable macros” in the dialog box that appears when opening the file.

You can choose your region of analysis on the main screen and upload the relevant regional data file to the tool. Refer to the AVERT User Manual and Quick Start Guide for step-by-step instructions on using the Main Module.

Do you want other baseline years for the Main Module?

The regional data files above are for the most recent data year of data (2016). For most purposes, users will want the most recent data year. If another year is desired, packages of all ten regional data files for additional years can be downloaded at the links below. Download the file and save it in a folder with or near the Main Module.

Top of Page

Back to main AVERT page

AVERT’s Statistical Module

It is recommended that computers operating AVERT’s Statistical Module have at least 2 GB of memory available. Processing time for individual regions depends on the number of units in the analysis and the number of processors available. Refer to the AVERT User Manual for step-by-step instructions on using the Statistical Module.

Step 1: Determine Windows operating environment

Determine if your Windows system operates in a 32-bit or 64-bit environment. Generally, this information is displayed in the “properties” of “My Computer” in Windows XP; or “Computer” in Windows Vista, Windows 7, Windows 8; or "My PC" in Windows 10. Click hereExit to determine your Windows environment.

Step 2: Download AVERT’s Statistical Module and MATLAB Compiler Runtime (MCR)

Step 3: Install MATLAB Compiler Runtime (MCR)

To use AVERT’s Statistical Module, the correct version of the free MATLAB Compiler Runtime (MCR) software needs to be installed. Run the “MCR _R2012b_…installer.exe” file that was downloaded in Step 2. Installing this software may require administrator rights. If you do not have rights as an administrator or have any questions, contact your IT specialist for assistance.

Top of Page

Back to main AVERT page

AVERT’s Future Year Scenario Template

The “AVERT Future Year Scenario Template v.1.0” spreadsheet is downloaded as part of the Statistical Module package. This Excel file is stored in one of the subfolders of the Statistical Module package called “AVERT Future Year Scenarios.” To access and use the Future Year Scenario Template, download the Statistical Module package, following the instructions above. Refer to the AVERT User Manual for instructions on using the Future Year Scenario Template.
For each user-defined scenario, the user is strongly recommended to save this file (in the same subfolder) using the following naming convention:

“AVERT Future Year Scenario Template v.1.0 <Scenario X>” where “Scenario X” is a user-defined name.

Please note that each historical baseline year has a unique future year scenario template. Users should use the future year scenario template associated with the historical baseline year of interest.

Do you want other baseline years for the Statistical Module?

The AVERT Statistical Module package contains, by default, the most recent data year of data and the associated Future Year Scenario Template. For most purposes, users will want the most recent data year. If another year is desired, additional AVERT-compatible databases from EPA Clean Air Markets Division’s (CAMD’s) Air Market Program Data (AMPD) are available, as are Future Year Scenario Templates. For each desired year, download the compressed file. Each compressed file contains a large database and a Future Year Scenario Template. Please move the database (named “AVERT_CAMDArray_<Year>”) and save it in the subfolder “CAMD Input Files,” which is one of the subfolders included in the AVERT Statistical Module package. Please move the Excel sheet called “AVERT Future Year Scenario Template <Year>  v1.10” to the subfolder “AVERT Future Year Scenarios.”

Top of Page

Back to main AVERT page