State and Local Climate and Energy Program
AVERT Download Instructions
You will need Adobe Reader to view some of the files on this page. See EPA's PDF page to learn more.
AVERT is divided into three components:
- Main Module: An Excel-based platform for user-specified analysis of displaced emissions. The Regional Data Files are associated with this module.
- Statistical Module: A MATLAB®-based statistical analysis program.
- Future Year Scenario Template: A second Excel-based spreadsheet for creating user-specified future year scenarios. Used in tandem with the statistical file.
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 historic 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’s Main Module requires Excel 2007 or newer to run. Download the following files to the same folder on a local computer or drive:
- AVERT’s Main Module workbook: AVERT Main Module.xlsx (Excel, 6.0MB).
The Regional Data File for 2013 (the most recent year available). Find your region:
- California (Excel, 1.5MB)
- Great Lakes - Mid-Atlantic (Excel, 4.5MB)
- Lower Midwest (Excel, 1.5MB)
- Northeast (Excel, 2.0MB)
- Northwest (Excel, 863K)
- Rocky Mountains (Excel, 748K)
- Southeast (Excel, 6.2MB)
- Southwest (Excel, 1.3MB)
- Texas (Excel, 1.7MB)
- Upper Midwest (Excel, 2.0MB)
To use AVERT’s Main Module, open the AVERT Main Module.xlsx file. Ensure that macros are enabled by navigating to the “Trust Center” in the “Options” menu, then selecting Trust Center Settings > Macro Settings > Enable all macros. You can now 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 (PDF) (87 pp, 4.75MB) and Quick Start Guide (PDF) (13 pp, 1.44MB) 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 (2013). 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.
- 2007 (zipped excel files, 21.9 MB)
- 2008 (zipped excel files, 21.9 MB)
- 2009 (zipped excel files, 22.0 MB)
- 2010 (zipped excel files, 22.1 MB)
- 2011 (zipped excel files, 21.6 MB)
- 2012 (zipped excel files, 21.8 MB)
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 (PDF) (87 pp, 4.75MB) 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, or Windows 8. Click here to determine your windows environment.
Step 2: Download AVERT’s Statistical Module and MATLAB Compiler Runtime (MCR)
If your system operates in a 32-bit environment download the following two files and save them to your computer:
- AVERT’s Statistical Module executable package: AVERT StatMod 2012 v1 32bit_package (zip file containing executable, 80.3MB)
- MATLAB Compiler Runtime (MCR): Download the Windows 32-bit version of the MCR for R2012b from the Mathworks website .
If your system operates in a 64-bit environment download the following two files and save them to your computer:
- The AVERT executable package: AVERT StatMod 2012 v1 64bit_package (zip file containing executable, 80.4MB)
- MATLAB Compiler Runtime (MCR): Download the Windows 64-bit version of the MCR for R2012b from the Mathworks website .
Once the AVERT package is downloaded, create a folder on your computer entitled “AVERT Statistical Module.” Place the package (i.e., the “AVERT_Statistical_Module_...pkg.exe” file contain within the zip file) in the folder and run this file. The package will decompress to three files and three subfolders. These folders must stay in the same folder as the Statistical Module for the program to operate successfully.
Step 3: Install MATLAB Compiler Runtime (MCR)
To use AVERT’s Statistical Module, 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.
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 (PDF) (87 pp, 4.75MB) 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 historic baseline year has a unique future year scenario template. Users should use the future year scenario template associated with the historic 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.”
- 2007 (zipped file, 83.1 MB)
- 2008 (zipped file, 80.3 MB)
- 2009 (zipped file, 75.8 MB)
- 2010 (zipped file, 79.6 MB)
- 2011 (zipped file, 76.2 MB)
- 2012 (zipped file, 73.6 MB)