AVERT Main Module Quick Start Guide
AVoided Emissions and geneRation Tool (AVERT) is a free tool with a simple user interface designed to meet
the needs of state air quality planners and other interested stakeholders. Non-experts can use AVERT to
evaluate county-level emissions displaced at electric power plants by energy efficiency (EE) and renewable
energy (RE) policies and programs.
Download Instructions
AVERT's Main Module requires Excel 2007 or newer to run. To download AVERT's Main Module, go to
www.epa.gov/avert and save the following files to the same folder on a local computer or drive:
1. AVERT's Main Module workbook: "AVERT Main Module.xlsx",
2. The Regional Data File for the region under analysis.
Installation of AVERT's Statistical Module and AVERT's Future Year Scenario Template is not necessary to
use AVERT's Main Module to estimate displaced emissions for EE/RE programs modeled in a historic base
year. However, modeling displaced emissions with reference to user-created future years requires all three
AVERT modules. Refer to the AVERT User Manual for additional installation instructions.
Step-by-Step Instructions
To begin using AVERT's Main Module, open the AVERT Main Module.xlsx file.
Enable Macros
Before making any selections or beginning calculations, macros must be enabled on your computer.
To enable macros in Excel 2007:
/Da
Click the Microsoft Office Button , and then click "Excel Options."
Click "Trust Center," click "Trust Center Settings," and then click "Macro Settings."
Click on "Enable all Macros."
To enable macros in Excel 2010 or Excel 2013:
Click the "File" menu (Office Backstage), and then click "Options" in the left sidebar.
Click "Trust Center" in the left sidebar, and then click the "Trust Center Settings" button in the main
window.
Click "Macro Settings" in the left sidebar.
Choose the "Enable All Macros" option and hit OK.
a
Slate Climate and Ensrgy Prograrr
1
SERA
epa.gov/statelocalclimate
-------
AVoided Emissions and geneRatior* Tool
www.epa.gov/avert
Begin Using AVERT
When launched in Excel, AVERT's Main Module opens to its "Welcome" page.
1. Personalize the welcome page with details about the user, the date of use, and the EE/RE program
for which displacements are to be estimated.
2. Click on the button labeled "Click here to begin" to move on to AVERT's first step.
AVERT
Welcome to AVERT's Main Module
AVERT is an EPA tool that quantifies the emission impacts of energy efficiency and
renewable energy policies and programs within the continental United States. Please refer to
the AVERT user manual for details on step-by-step instructions, appropriate uses and
assumptions built into the tool.
NOTE
Please ensure macros are enabled on your computer.
AVERT requires Excel 2007 or newer to run.
AVERT v. 1.0
Developed by Synapse Energy Economics, Inc., January 2014
' Use the blue entry to describe each scenario and keep track of multiple versions of AVERT.
Editor:
Date edited:
Edition name:
Edition description:
-------
AVoided Emissions and geneRatior* Tool
www.epa.gov/avert
Step 1: Import Regional Data File
AVERT regions represent relatively autonomous electricity production zones, and are based on electricity
market module regions. For more detailed information on the specific boundaries of each region, consult the
AVERT User Manual.
1. Select a region for analysis by either using the dropdown menu or by clicking the map. Selecting a
region loads region-specific data for wind and solar capacity factors.
2. If you have not already, click the link under the map to download the corresponding Regional Data
File from EPA's website.
3. Once you have downloaded your Regional Data File, in the box labeled "Enter filepath," double-click
the blue area to navigate to its location.
4. Click the button under "Load data" that reads, "Click here to load the Regional Data File." Clicking this
button loads hourly fossil load, unit information, and typical unit performance for generation and
emissions.
Step I: Import Regional Data File
AVERT
Select region
Select a region for analysis by using the dropdown
or by clicking the map.
If you haven't yet saved a Regional Data File on your
1 computer, click here.
Enter filepath
Double-click below to enter the location of
the Regional Data File.
Load data
Click here to load the
Regional Data File
I. Regional Data
File
Next ->
<- Back
a
Slate Climate and Ensrgy Prograrr
3
SERA
epa.gov/statelocalclimate
-------
AVoided Emissions and geneRatior* Tool
www.epa.gov/avert
Step 2: Set Energy Efficiency (EE) and Renewable Energy (RE) Impacts
This page leads you through the process of creating a load impact profile depicting the load reductions
expected from an EE/RE program. It also allows you to estimate a load reduction from basic characteristics:
Reduce fossil-fuel generation by a percent in some or all hours
Reduce fossil-fuel generation by total GWh (flat)
Reduce each hour by a constant MW each hour
Renewable energy proxy
Combination of EE/RE programs including combining pre-set options with manual entry
Each option is described in more detail in the AVERT User Manual. If more than one option (including
manual entry) is chosen, the selected options will be combined into a portfolio of programs.
For hourly load reductions expected from a particular EE/RE policy, program, or measure, values can be input
manually. Click the "Enter hourly data manually" button, which will allow you to enter a manual stream of
load reduction values for every hour of the year.
mim
Slate Climate and Ensrgy Prograrr
4
SERA
epa.gov/statelocalclimate
-------
AVoided Emissions and geneRatior* Tool
www.epa.gov/avert
Step 3: Run Displacement
This step calculates hourly displaced generation and emissions (S02, N0X, C02) for each fossil unit within the
selected region.
Run displacement by selecting the button entitled "Click here to calculate displaced generation and
emissions." Note that this is a processor-intensive step. When using an older computer, or when analyzing
regions with many fossil units, this step may take up to ten minutes.
A pop-up box that reads "Calculation complete" will appear once the calculations are complete.
Upper Midwest, 2012
AVERT
Step 3: Run Displacement
Click below to calculate displaced generation and emissions.
NOTE
Please be patient.
This calculation may take up to ten minutes to run on older machines.
During this time your screen may go blank or a "not responding" error may
occur - please disregard and allow the calculation to continue.
Click here to calculate displaced generation and emissions
Next
<- Back
BaseEPA
@9
Slate Climate and Ensrgy Prograrr
5
SERA
epa.gov/statelocalclimate
-------
AVoided Emissions and geneRatior* Tool
www.epa.gov/avert
Step 4: Display Outputs
The data generated in Step 3 are aggregated in two major groups of charts and tables in this step: "Summary
tables" and "Charts and figures". There are eight total display output options. Each output is described in
more detail in the AVERT User Manual.
Upper Midwest, 2012
AVERT
Step 4: Display Outputs
Summary tables
Annual regional
displacement data
Displacement data for
top ten peak days
Annual displacement
data by county
Monthly displacement
data by county
Charts and figures
Displaced generation
Hourly displacements
and emiiiioni map
by week
Monthly displacement! by
Signal-to-noise
selected geography
diagnostic
SMOKE text file generation
Enter a filepath, then click
the button to save
SMOKE text files.
NOTE
Please be patient.
This calculation may take
up to twenty minutes to
run on older machines.
Generate SMOKE
text files
4. Display
Outputs
4- Back
BaseEPA
mim
Slate Climate and Ensrgy Prograrr
6
SERA
epa.gov/statelocalclimate
-------
Annual regional displacements
This table displays the total annual generation and emissions as reported for the region in the base year
("Original") and as calculated by AVERT's Main Module after the EE/RE reduction ("Post-EERE").
Upper Midwest, 2012 AVERT
Output: Annual Regional Displacements
Original
Post-EERE
Impacts
Generation (MWh)
245,694,500
235,514,500
- 10,180,000
Total Emissions
S02 (lbs)
956,871,300
921,132,200
- 35,739,100
NO (lbs)
416,259,200
400,349,300
- 15,909,900
CO2 (tons)
246,098,700
236,856,400
- 9,242,300
Emission Rates
S02 (Ibs/MWh)
3,895
3.91 1
NO, (Ibs/MWh)
1,694
1.700
C02 (tons/MWh)
1.002
1.006
Annual displacement data by county
This table presents a summary of the displaced generation and emissions for each of the counties from each
of the states contained within the region, A line for each county containing an electric generating unit (EGU)
is displayed.
Upper Midwest, 2012
Output: Annual Displacement Data by County
c
^licMTer^^jeturr^^Ste^^isgla^Outgut^
:
State
H
County £
Peak Gross
Generation, Post-
T[ EERE (MW) 0
Annual Gross
Generation, Post-
EERE (MWh) [Vj
Annual Displaced
Generation (MWljV]
Annual Displac
S02 (lbs)
IA
Allamakee
250
1,152,800
-91,800
-639,700
IA
Appanoose
17
2,700
-600
-5,300
IA
Audubon
125
39,100
-8,800
-
IA
Black Hawk
109
42,300
-8,900
-30,700
IA
Cerro Gordo
522
772,800
-154,400
-600
IA
Clay
30
1 1,000
-2,300
-21,000
IA
Clinton
143
583,900
-30,500
-195,700
IA
Des Moines
210
1,195,400
-58,200
-438,500
IA
Dubuque
42
91,300
-1,600
-500
IA
Louisa
770
5,304,300
-197,800
-642,500
IA
Marshall
57
32,500
-1,700
-200
IA
Muscatine
262
960,200
-79,200
-353,300
IA
Polk
481
343,100
-59,900
-2,100
For each county, annual output
statistics are given for:
Peak Gross Generation Post-
EE/RE
Annual Gross Generation
Post-EE/RE
Capacity Factor
Annual Change in Generation
Annual Change in Heat Input,
SO,, NOx, C02
Ozone Season Change in S02,
NOx
Ozone Season, 10 Peak Days
Change in S02, NOx
SERA
epa.gov/statelocalclimate
Climate and Energy Prograrr
-------
AVoided Emissions and geneRation Tool
www.epa.gov/avert
Monthly displacement data by county
This table shows a summary of the displaced generation and emissions for each of the counties from each of
the states contained within the region, broken out by month and with an annual total.
Upper Midwest, 2012 AVERT
Output: Monthly Displacement Data by County
Click here to return to Step 4: Display Outputs I Negative numbers indicate displaced generation and emissions. All results are rounded to the nearest hundred.
A dash ("") indicates a resu/r greater than zero, but lower than the level of reportable significance.
State
R
County
"R
Month
Displaced
Generation
' (MWh) H
Displaced NOx
(lbs) !F1I
Displaced S02
(lbs) PI
Displaced C02
(Tons) [T
IA
Allamakee
1
-9,800
-67,900
-500
-10,100
IA
Allamakee
2
-8,200
-56,500
200
-8,400
IA
Allamakee
3
-7,700
-53,500
-3,100
-8,000
IA
Allamakee
4
-7,000
-48,800
-5,500
-7,400
IA
Allamakee
5
-7,600
-53,300
-7,800
-8,200
IA
Allamakee
6
-5,900
-42,000
-4,700
-6,300
IA
Allamakee
7
-4,400
-32,200
-2,500
-4,700
IA
Allamakee
8
-5,700
-40,500
-4,000
-6,000
IA
Allamakee
9
-7,300
-51,000
-6,600
-7,800
IA
Allamakee
10
-8,900
-61,800
-2,300
-9,200
IA
Allamakee
1 1
-8,800
-60,300
-800
-9,000
IA
Allamakee
12
-10,400
-72,000
200
-10,700
IA
Allamakee
Annual
-91,800
-639,700
-37,300
-95,900
IA
Appanoose
1
-
-
-400
-
Displacement data for top ten peak days
This table displays a summary of the ten days in the region featuring the highest level of fossil fuel load.
Upper Midwest, 2012
Output: Displacement Data for Top Ten Peak Days
|^_ClickjTer^ojjeturn^o^Ste^4jJDis£la^^
Day Rank
Date
Total Fossil Generation
(MWh)
Expected Displaced
Generation (MWh)
Displaced Generation
(MWh)
Displaced NOx
(lbs)
Displaced S02
(lbs)
Displaced C02
(Tons)
1
Jul 26
990,200
-32,800
-32,000
-56,500
-58,900
-23,300
2
Jul 27
966,700
-26,300
-26,300
-57,000
-42,500
-19,800
3
Jul 25
963,900
-35,800
-35,900
-69,600
-62,700
-27,100
4
Jul 14
963,400
-21,800
-21,800
-42,400
-36,800
-16,500
5
Aug 01
954,200
-16,500
-16,400
-35,900
-27,700
-12,800
6
Jul 06
953,600
-16,000
-16,000
-37,400
-26,700
-12,600
7
Jul 13
950,100
-17,000
-16,400
-37,800
-29,900
-13,100
8
Jul 07
928,900
-19,000
-19,100
-41,100
-29,600
-14,600
9
Jul 10
927,500
-18,400
-18,500
-42,700
-31,400
-14,400
10
Aug 12
923,200
-15,500
-15,500
-34,200
-21,500
-12,000
mim
Slate Climate and Ensrgy Prograrr
8
SERA
epa.gov/statelocalclimate
-------
AVoided Emissions and geneRatior* Tool
www.epa.gov/avert
Displaced generation and emissions map
This dynamic map allows the user to view where emissions have been displaced within the selected region.
Users can view changes in generation, heat input, S02, N0X, and C02.
Upper Midwest, 2012 AVERT
Output: Displaced Generation and Emissions Map
Select variable to display: [Annual Change in CQ2 (tons) P |^^^^^^^^RefreshjTTa^
Note: The diameter of each circle indicates the
magnitude of a unit's change in generation / emissions.
Circles are semi-transparent; darker areas occur in
regions with overlapping units. Negative changes are
indicated with blue circles; positive changes are indicated
with black-bordered white circles.
Annual Change in C02 (tons)
20" ! 4 I 1 ! 1
-130° -120" -110° -100° -90° -80° -70° -60°
290,000 tons
mim
Slate Climate and Ensrgy Prograrr
9
SERA
epa.gov/statelocalclimate
-------
AVoided Emissions and geneRation Tool
www.epa.gov/avert
Displacement data by month
Monthly output can be viewed over the entire region, or a specific state or county within the region. First
select region, state, or county in the top dropdown menu.
If selecting a state, choose the state in the next dropdown menu.
If selecting a county, choose both the state and the county in the next two dropdown menus.
Upper Midwest, 2012
Output: Monthly Displacements by Selected Geography
|^^^^^ClicMieret^«tun^^Ste^^isgla^Outgut^^^^^J
Select level of aggregation:
Select state:
IA
Monthly Emission Changes, Upper Midwest (IA)
_o -200,000
O
O
z
-400,000
-600,000
-800,000
-1,000,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
tttttwtfg
Jul Aug Sep Oct Nov Dec
o
u
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
0 I i I i I i I i I i I i I
-50,000
-100,000
-150,000
-200,000
mim
Slate Climate and Ensrgy Prograrr
10
SERA
epa.gov/statelocalclimate
-------
AVoided Emissions and geneRatior* Tool
www.epa.gov/avert
Total Change in
Generation (MW)
Total fossil-fuel toad,
pre-EERE
High capacity factor units
Low capacity factor units
Hourly displacements by week
This option includes two figures. The first displays a dynamic representation of hourly displacement from
each EGU in a region. Individual plants are stacked as gradated bar plots.
Change in Generation (MW) in Week of 8/1
Negative numbers indicate displaced
generation and emissions.
-2,000
0
£
Z
.2 -500
I
c
a
c -1,000
§0
c
.c
U
-1,500
45,432
!"Se
o *-
" 20,287
The second figure shows the same week-long load impact profile, but presents the displaced load in
reference to the total fossil-fuel ioad to illustrate the degree of change represented by the EE/RE program
relative to the baseline.
Fossil-fuel load, pre- and post-EERE, in Week of 8/1
50,000
45,000
£
/
/\ r\ ^
z
/
\
/ \ / \ n /
o
30,000
25,000
20,000
15,000
10,000
5,000
/
V
f \t \ /=^\ /
\ /
!_
D
X
<
<
o> g> O) TO
< < < <
CD T in CO
<
i
-js c e
Ll_ /S. 3 O
CO 05 g
1
Total fossil-fuel toad,
pre-EERE
Total fossil-fuel load,
post-EERE
Load displaced
@9
Slate Climate and Ensrgy Prograrr
11
SERA
epa.gov/statelocalclimate
-------
Signal-to-noise diagnostic
This chart is a scatterplot of every hour of the year, showing calculated total generation reduction in each
hour (y-axis) against the user-input EE/RE load reduction in each hour (x-axis).
Ideally, AVERT perfectly matches unit generation reductions to the amount of EE/RE load reduction
requested by the user. The signal-to-noise diagnostic chart shows where that assumption holds, where it
does not hold, and to what extent.
Upper Midwest, 2012 AVERT
Output: Signal-to-noise diagnostic
| Click here to return to Step 4: Display Outputs
Reduction in Total Unit Generation Relative to EERE Load Reduction
(MW) for All Hours, RJ=0.99
Expected EERE Load Reduction (MW)
12
SERA
epa.gov/statelocalclimate
Climate and Energy Prograrr
------- |