GUIDE TO IPM Output FILES

EPA Initial Run v.6

The following information is meant to provide users with a general explanation of the
different IPM output files that are made web ready and posted to EPA's website. It refers to
the EPA Initial Run v.6 that was designed and developed for use in analyzing policy scenarios
starting in 2021. It is meant to help users identify and interpret the data available in the
model input and output files. The Documentation for EPA's Power Sector Modeling Platform
v.6 using IPM (available at https://www.epa.gov/airmarkets/clean-air-markets-power-sector-
modeling) provides more comprehensive details regarding the assumptions and methodology
used in the model.

Below is a brief overview of the non-unit level IPM inputs and outputs that are made
publicly available through EPA's website. Because the System Summary Report is one of the
more frequently referenced documents that summarizes many IPM key outputs, it is
described in further detail in the remainder of this guide.

Once EPA Initial Run v.6 files are downloaded and decompressed from EPA's website, the
unzipped files will contain two folders: "Input and Output Files" & "Parsed Files".
Additionally, it will have an Excel spreadsheet that includes "System Summary Report" in the
title. The "Input and Output Files" folder will have six files within it: A DAT Replacement file,
RPE Replacement file, RPT Replacement files, EIA Style Gas Report, State Emission File, and
an Overview file.

Input and Output Files

DAT file1 (Model Inputs): This file will have "DAT File" in the file name, e.g., "Initial Run dat
file.xlsx." It contains the key input set-up data used to define the model run, including the
definitions and specifications for run years, model regions, model plants, financial
parameters, available fuels, and power system transmission and operating parameters. The
"Index" worksheet provides a list of all other worksheets and data available in the file, and
the "RunUniverse" worksheets includes a table of region names and IDs.

RPE file2 (Model Plant Outputs): This file will have "RPE File" in the file name, e.g., "Initial
Run rpe file.xlsx." For each model plant, this file shows the projections of fuel consumption,
emissions, capacity, costs (capital, fixed operations and maintenance, and variable
operations and maintenance), and generation.

In contrast to past RPE files, which only contained data on model plants that had generation
(i.e. model plants that were idled, but not retired), the RPE file for EPA Initial Run v.6

1 This file replaces ".dat" file that was output by earlier versions of IPM and is easier to navigate.
2This file replaces ".rpe" file that was output by earlier versions of IPM and is easier to navigate.

1


-------
contains data for model plants that were either idled or retired.

RPT files3 (Detailed Model Operational Outputs): This is a zip file with "rpt files" in the file
name, e.g., "Initial Run rpt files.zip." These files contain a variety of model outputs,
including: regional summaries; costs, fuel supply, transportation, and use; electricity
transmission and constraints; new and retrofit capacity; environmental constraints; and
energy price.

State Emissions file: This file will have "State Emissions" in the file name, e.g., "Initial Run
State Emissions.xlsx." This file shows EGU emissions at the state level for each run year.

There are two tabs, one showing emissions from all EGUs, the other showing emissions from
all EGUs, the other showing emissions only from fossil units greater than 25 MW.

Additionally, this file now contains data describing total state-level generation and heat
input, both annual and ozone season.

Overview file (Regional Summary of Model Operational Outputs): This file will have
"Overview" in the file name, e.g., "Initial Run Overview File.xlsx." It contains model
operational outputs by run year at the regional level, including capacity, generation, costs,
retrofits, and retirements. It is typically easier for users to refer to either the System
Summary Report or the Regional Summary File.

System Summary Report

System Summary Report: The System Summary Report is available as a spreadsheet, e.g.,
"Initial Run SSR.xIsx." It contains system-wide power sector results for the lower continental
U.S. for each run year. It reports forecasted generation, capacity, capacity additions, capacity
factors, production costs, emissions, fuel consumption & cost, and allowance prices by model
run year. Disaggregation of system-wide data to plant type data is provided for generation
and capacity fields. The plant types are categorized based on fuel used (e.g., coal, oil/gas,
nuclear, hydro), combustion technology (e.g., turbine, combined cycle gas), control
technology (e.g., scrubber, post-combustion NOx control), and retrofit structure (e.g., coal
plant with existing SNCR retrofit with ACI). In addition to providing the above outputs
forecasted for each model run year, it also gives information on the various regulatory and
legal requirements that were inputted into the model as constraints. Below is a more
detailed explanation of each worksheet in the System Summary Report.

The regional level equivalent of the System Summary Report Tables 1-16 is available in the
"Regional Summary.xlsx" file that is included in the RPT replacement files.

3 This file replaces ".rpt" file that was output by earlier versions of IPM and is easier to navigate.

2


-------
Description of Worksheets and Data within the System Summary Report

File

System Summary Report: When the Excel File is opened, it will contain six worksheets

1.	"Summary" worksheet

2.	"All Constraints" worksheet

3.	"Fuel Report" worksheet

4.	"Tables 1-16_US" worksheet

5.	"Coal Pivot Tables" worksheet

6.	"Final Wholesale Price" worksheet

Summary Worksheet: The summary worksheet in the system summary file highlights some of the key data points from the
IPM output, and is intended to be an ideal starting point for assessing fundamental environmental and operational
projections for the power sector in any given IPM run. For first time users, it is one of the more user-friendly documents
from which to view output data. It includes national level data for emissions, total system cost, fuel prices, total capacity,
new capacity, retired capacity, generation, and fuel supply and consumption

All Constraints: The "All Constraints" worksheet in the System Summary Report lists the various legal and policy
requirements in the model.4 Each constraint typically involves a "standard" that is imposed in the form of an emission
limit, emission rate limit, or generation limit. The constraint can be applied at the unit, plant, system, state, regional or
national level. The constraints also include a time dimension and may vary between model run years. The worksheet
displays the shadow price of each constraint (i.e. the marginal cost of meeting the standard for a particular season or
year, which is equal to the additional cost the model would have chosen to incur to allow for the constraint to be
loosened by one unit of measure. For example, for a constraint on total NOx emissions, the amount the model would be
willing to pay to allow for one more ton of NOx emissions). Constraints with shadow prices of zero are "non-binding",
that is the model would have produced the same solution if the constraint did not exist. There are over 1000 constraints
in the EPA Initial Run v.6 Initial Run Appendix table 1-1 provides a comprehensive list of legal and policy requirements
that are reflected in the model through the various constraints.

4 These constraints are detailed in the IPM v6 Documentation and the Environmental Measures workbook that is part of the RPT Replacement Files.

3


-------
Fuel Report: The "Fuel Report" worksheet provides consumption and cost data for major power sector fuel sources for
each model run year. These fuels include coal, nuclear, natural gas, biomass, pet.coke (petroleum coke), natural gas,
biomass, waste coal, and oil. For each fuel type the total consumption is given in TBtus (trillion Btus). Cost is provided in
both MMUS$ (million US dollar units) and US$/MMBtu (U.S. dollar per million Btus).

Tables 1-16: The "Tables 1-16" worksheet in the System Summary Report provides information on controls, generation,
capacity, and cost. The information in these tables is often the disaggregated value of the totals reported in the "Summary"
worksheet. A user interested in better understanding the details behind the totals given in the "Summary" worksheet may
wish to consult "Tables 1-16". For example, the "Summary" worksheet provides the total amount of generation from coal in
each model run year. However, the "Tables 1-16" worksheet goes one step further and provides data on the portion of that
generation total coming from coal plants with no pollution control and the portion coming from plants with specific
pollution control configurations. In particular, tables 10 throughl4 provide generation and capacity data at the model plant
type level. Tables 1-9 provide generation supply and demand data at the U.S. region wide level. The table below describes
the data output reported in each table, and Appendix 2-1 and 2-2 provides more information on the acronyms and
nomenclature used in the data fields.

Description Tables in "Tables 1-16" Worksheet

Table#

Title

Description

1

Reserve Margin Capacity Winter
(MW)

Shows total electric generating capacity available to the U.S. region
during winter period. Available supply of electricity in megawatts (MW).

2

Peak Load Winter (MW)

Shows total electricity demand during winter period by the U.S. region.
Capacity reported in megawatts (MW).

3

Reserve Margin Winter (%)

Shows excess winter capacity supply as percentage of demand using total
values reported from Tables 1 & 2. (supply - demand)/demand.

1

Reserve Margin Capacity summer
(MW)

Shows total electric generating capacity available to U.S. region during
summer period. Available supply of electricity in megawatts (MW).

2

Peak Load summer (MW)

Shows total electricity demand during summer period by the U.S. region.
Capacity reported in megawatts (MW).

4


-------
3

Reserve Margin summer (%)

Shows excess summer capacity as percentage of demand using total values
reported from Tables 1 & 2.

1

Reserve Margin Capacity annual
(MW)

Shows total electric generating capacity available to U.S. region
annually. Available supply of electricity in megawatts (MW).

2

Peak Load annual (MW)

Shows total electricity demand annually by the U.S. region. Capacity
reported in megawatts (MW).

3

Reserve Margin annual (%)

Shows excess annual capacity as percentage of demand using total values
reported from Tables 1 & 2.

4

Generation (GWh)

Gigawatt hours (GWh) of annual electricity that is produced domestically,
imported, exported, and lost during pumping and storage.

5

Total Supply for Demand (GWh)

Gigawatt hours (GWh) of annual electricity generation supplied to the U.S.
region. Summation of values in Table 4.

6

Projected Demand (GWh)

Gigawatt hours (GWh) of annual projected demand and projected net
demand.

7

Dumped Energy

Typically not referenced.

8

Total Generation

Gigawatt hours (GWh) of annual electricity that is produced domestically,
imported, exported, and lost during pumping and storage.

9

Total Sales (GWh)

Gigawatt hours (GWh) of annual electricity supply determined by
subtracting projected transmission & demand losses from total supply.

10

Capacity by Capacity Reporting
Type

Cumulative capacity (MW) of model plant types for each model run year.
The model run plants are categorized by the unit's fuel, configuration, and
online status (e.g., new, existing, retiring). Each control configuration
combination is modeled as a separate plant type. The total capacity, retrofit
capacity, new unit capacity, and retiring unit capacity values given in the
summary table are disaggregated into model plant types in this table. Key
difference between table 10 & 11 is that 10 is cumulative and 11 is
incremental. Therefore, table 10 will show model plant capacity by a given
year, and table 11 will show model plant capacity added during that run
year.

5


-------
11

Capacity Additions and Changes

Incremental capacity (MW) of model plant types for each model run year.
The model run plants are categorized by the unit's fuel, configuration, and
online status (e.g., new, existing, retiring). Each control configuration
combination is modeled as a separate plant type. The total capacity, retrofit
capacity, new unit capacity, and retiring unit capacity values given in the
summary table are disaggregated into model plant types in this table.

12

Generation by Capacity Reporting
Type (GWh)

Cumulative generation (GWh) of model plant types for each model run year.
The model run plants are categorized by the unit's fuel, configuration, and
online status (e.g., new, existing, retiring). Each control configuration
combination is modeled as a separate plant type. The total generation by
each plant type given in the summary table is disaggregated into model
plant type generation in this table.

12a

Generation by Capacity Reporting
Type (GWh)

Total gigawatt hours (GWh) of generation in each model run year by fuel
type. Aggregation of the model plants pertaining to each fuel in table 12.

13

Generation by Capacity Reporting
Type(Tbtu)

Cumulative generation measured in Trillion btus (Tbtu) of model plant types
for each model run year. The data corresponds to generation values given in
Table 12, but is expressed in TBtus to provide the heat content of the power
generated. Conversion factor of approximately 3,412 Btu/KWh is used.

14

Capacity factor by Capacity
Reporting Type (%)

Capacity factor for each model plant type. Capacity factor is the actual
generation expressed as a percentage of maximum generation possible if
the plant was operated every hour of the year. Therefore, it is the
generation / (capacity*8760). Generally, the model does not allow for 100%
capacity factors because of maintenance, planned outage, and forced
outage times. Intermittent generation sources (i.e., wind) also have their
capacity factor limited by the availability of their fuel source.

15

Total Annual Production Cost

Provides total production cost in million U.S. dollar units (MMUS$) for each
model run year. The production costs are disaggregated into variable
operating and maintenance (variable O&M), fixed O&M, fuel, capital, and
CO2 transportation and storage cost.

6


-------
Provides total annual U.S. emissions for each model run year for several
hazardous, criteria, and greenhouse gas pollutants. Emission totals are
expressed in 1000 tons (Mtons); 1,000,000 tons (MMtons), or regular tons.
All tons are short tons (2000 lbs/ton) unless otherwise noted.

7


-------
Coal Pivot Tables: The "Coal Pivot Tables" worksheet in the System Summary Report provides information on coal prices
and total coal consumption for each run year by coal region. Data is reported in both MMBtu and tons.

Final Wholesale Price: The "Final Wholesale Electricity Price" worksheet in the System Summary Report provides the
wholesale electricity price for each region and model run year.

8


-------
APPENDICES

Appendix 1-1: Summary of legal and regulatory requirements considered in the IPM v.6 Initial Run.

See Section 3.9 and Tables 3-18, 3-19, 3-20, 3-21 of the EPA Initial Run v.6 Documentation for more details on settlements
and state rules.

NSR Settlements

State Settlements

Citizen Suits

State Rules

Regional/National Programs

International

Alabama Power

AES

SWEPCO

Alabama

Title IV Acid Rain Program

Canada









Regional Green House Gas



Minnkota Power

Niagra Mohawk Power

Allegheny Energy

Arizona

Initiative (RGGI)

Alberta





Wisconsin Public







SIGECO

Public Service Co of New Mexico

Service Corp.

California

Pacific Northwest

Manitoba

PSEG Fossil & PSEG Fossil Amended Nov



University of







2006

Public Service Co of Colorado

Wisconsin

Colorado

NOx SIP Call

Ontario









Western Regional Air



TECO

TVA

Tucson Electric Power

Connecticut

Partnership (WRAP)

Quebec





Kansas City Board of



Clean Air Interstate Rule



WEPCO

Rochester Gas & Electric

Public Utilities

Delaware

(CAIR)

New Brunswick









Mercury and Air Toxics



VEPCO

Mirant-New York

Dominion Energy

Georgia

Standard (MATS)

Nova Scotia









Best Available Retrofit



Santee Cooper

RC Cape May Holdings, LLC

Duke Energy

Illinois

Technology (BART)

PEI





MidAmerican Energy





Labrador &

Ohio Edison

First Energy

Company

Kansas



Newfoundland

Mirant



KCPL

Louisiana



Saskatchewan

Illinois Power





Maine





Kentucky Utilities Company





Maryland





Salt River Project





Massachusetts





American Electric Power (AEP)





Michigan





Eastern Kentucky Power Cooperative





Minnesota





Nevada Power





Missouri





Dayton Power and Light





Montana





Westar Energy





New Hampshire





Duke Energy





New Jersey





American Municipal Power





New York





Hoosier Energy Rural Electric Cooperative





North Carolina





Northern Indiana Public Service Co.





Oregon





Tennessee Valley Authority





Pennsylvania





Wisconsin Public Service





Texas





Dairyland Power Cooperative





Utah





Louisiana Generating LLC





Washington





Dominion Energy, Inc.





West Virginia





Wisconsin Power and Light





Wisconsin





Minnesota Power











Consumer Energy











9


-------
Interstate Power and Light











Arizona Public Service Commission























Appendix 2-1: Explanation of Model Plant Nomenclature

The field headers given in each row of Tables 10-14 represent model plant types. The model plant types are differentiated
by fuel used (e.g., coal, oil/gas, nuclear, hydro), combustion technology (e.g., turbine, combined cycle gas), control
technology (e.g., scrubber, post-combustion NOx control), online status (e.g., new, existing, or retiring) and retrofit structure
(e.g., coal plant with existing SNCR retrofit with ACI). It clarifies the nomenclature of model plants to recognize the
significance of the "ret.", "exist" and usage in the title. "Ret." suggests that the model plant is receiving a retrofit in or
by the given run year. If there is no "exist" label that immediately follows the "ret." designation, then every control listed is
a retrofit on a unit without any previously existing emission controls. The indicated are endogenous to the model.

If there is an "exist" that follows "ret." then each control listed after the "exist" and before the first ampersand (&) is an
existing control and everything after the is a retrofit that is added to that model plant by the model run year given. To
illustrate the difference, let's look at plant types with the same controls shown but with the word "Exist" absent and when
the word "Exist" is present, there will be variants in the placement of the first ampersand (&):

Sample Plant Types and Descriptions

Plant Type

Description

ExistSCR WFGD ACI

Existing Coal Steam with SCR, ACI and Wet FGD

Ret.ACI & SCR & WetFGD

Retrofit ACI, SCR, and Wet FGD on Existing Coal Steam

Ret.ExistACI & SCR & WetFGD

Retrofit SCR, and Wet FGD on Existing Coal Steam with ACI

Ret.ExistSCR ACI & WetFGD

Retrofit Wet FGD on Existing Coal Steam with SCR and ACI

Ret.ExistWetFGD & ACI & SCR

Retrofit ACI, and SCR on Existing Coal Steam with Wet FGD

Ret.ExistWetFGD ACI & SCR

Retrofit SCR on Existing Coal Steam with ACI and Wet FGD

Ret.ExistWetFGD_SCR & ACI

Retrofit ACI on Existing Coal Steam with SCR and Wet FGD

10


-------
Appendix 3-2: Abbreviations Appearing in Model Plant Naming

Abbreviation

Definition

IGCC

Integrated Gasification Combined Cycle

PV

Photovoltaic

ACI

Activated Carbon Injection

FGD

Flue gas desulfurization

SCR

Selective Catalytic Reduction

SNCR

Selective Non- Catalytic Reduction

CC

Combined Cycle

CT

Combustion Turbine

CCS

Carbon Capture & Storage

C2G

Coal-to-Gas

HRI

Heat Rate Improvement

Ret

Retrofit

Exist

Existing

11


-------