September 30, 2015 Abt Associates | List of Rulemaking Cost and Economic Impact Files | Page 1 

Date September 30, 2015 

To Steam Electric ELG Rule Record 

From Isabelle Morin

Subject List of Rulemaking Cost and Economic Impact Files: Effluent Limitations Guidelines 

and Standards for the Steam Electric Power Generating Point Source Category

This memorandum describes analytic files used for the Regulatory Impact Analysis (RIA) of the proposed 

rulemaking of the Steam Electric Power Generating Effluent Guidelines. The analytic files contain data 

classified by Industry as Confidential Business Information. The list in Table 1 describes the content of 

the files to allow review by the public without potentially releasing proprietary information. 

Table 1: List of Cost Files Developed for the Regulatory Impact Analysis (RIA) 

File Name Description/Purpose

Economic Impact Model – Main Files [\Costs and Econ Impacts\Econ Impacts]

ComplYrs.xlsx Determines the first year when each analyzed plant would install a

compliance technology based on its NPDES permit expiration year.

CostControl.xlsx Contains the following: plant‐level cost estimates for all cost options,

facility sample weights, compliance‐year sets, and plant‐universe sets. This

file specifies the option, sample weights, plant universe, and compliance‐

year set to be analyzed.

ElPricesDisp.xlsx Contains calculations of electricity prices and percent of total generated

electricity sold based on EIA data. These estimates are used to calculate

revenue.

ElRateImp.xlsx Estimates electricity price increases by consumer group due to regulatory

requirements.

Facil_CTR.xlsx Contains calculations of facility‐level cost‐to‐revenue ratios for analyzed

plants.

Firm_CTR_RFA ‐ Fin.xlsx Contains parent‐level CTR and RFA analyses.

HHImp.xlsx Estimates an average impact of regulatory requirements on households.

NERCRgns.xlsx Determines NERC regions for various analyses.

PlantData.xlsx Contains plant‐level information is used in the cost and economic impact

analysis model.

PlantGen.xlsx Calculates total and steam electricity generation for each in‐scope plant

using EIA data.

PlantOwn.xlsx Determines parent entities of Steam Electric plants and the size of these

entities.

PlantRev.xlsx Calculates facility‐level revenue.

PlantTypeCap.xlsx Determines facility type, total and steam capacity for in‐scope facilities

based on IPM and EIA data.

PrivateCosts.xlsx Calculates private discounted and annualized compliance cost estimates

used in various economic analyses. Original costs are discounted to either

promulgation year (2014), facility‐specific compliance year, or analysis year

(2014), annualized over appropriate number of years, and adjusted for

taxes.

Memorandum 

Environment and Resources 
September 30, 2015 Abt Associates | List of Rulemaking Cost and Economic Impact Files | Page 2 

File Name Description/Purpose

SocialCosts.xlsx Contains analysis of social costs. Calculates costs to use in the UMRA

analysis.

Tables.xlsm Includes a macro that compiles the results of a model run in a standard set

of tables

UMRA_Majority.xlsx Contains UMRA analysis based on majority owners of each plant.

Cost and Economic Impact Model – Support Files [\Costs and Econ Impacts\Econ Impacts\Support Data]

2013Pop.xlsx Contains 2013 "Incorporated Places and Minor Civil Divisions Datasets:

Subcounty Resident Population Estimates: April 1, 2010 to July 1, 2013."

This information is used for entity size determination of municipalities and

political subdivisions. Used in the RFA analysis.

AEO_2013.xlsx Contains adjustment factors based on Annual Energy Outlook 2013

(AEO2013).

AEO2013_sup_elec.xlsx Electricity demand and prices by consumer type group are used for the

electricity rate analysis and household impact analysis. Supplemental

Tables to the Annual Energy Outlook 2013 (Reference Case; Tables 73

through 95)

CCI.xlsx Contains adjustment factors based on Construction Cost Index (CCI). CCI‐

based adjustment factors are used to bring compliance costs to a given

year.

ECI.xlsx Contains adjustment factors based on Employment Cost Index (ECI).

GDP_Deflator.xlsx Contains adjustment factors based on GDP Deflator (downloaded

11/11/2013).

TaxRts.xlsx Contains total tax rate (total tax = state tax + federal tax ‐ state tax *

federal tax). Used for estimation of after‐tax compliance costs.

Size_Standards_Table_2014‐07‐

14

SBA Size Standards as of July 14 2014

Cost and Economic Impact Model – Cost Inputs

Costs_08.04.15_50MW.xlsx Assembles plant‐, wastestream‐ and technology‐specific costs for use in the

cost and economic impact model based on  50 MW threshold

Costs_08.04.15_AllUnits.xlsx Assembles plant‐, wastestream‐ and technology‐specific costs for use in the

cost and economic impact model based on  no threshold

CPP Scenario

CBI_SE04286_CP_Costs_Leachate

_Abt_with CPP_03172015.xls

With CPP (with CCR scenario): Raw cost file for Leachate

CBI_SE05783_BA_Costs_wCPP_0

3192015_Abt.xls

With CPP (with CCR scenario): Raw cost file for Bottom Ash

CBI_SE05785_FA_Costs_wCPP_0

3192015_Abt.xlsx

With CPP (with CCR scenario): Raw cost file for Fly Ash

CBI_SE05828_FGD

Costs_Abt_with CCR and

CPP_03182015.xlsx

With CPP (with CCR scenario): Raw cost file for FGD Chemical Precipitation

CBI_SE05853_FGD Evap Costs_50

MW with CCR and

CPP_07312015.xlsx

With CPP (with CCR scenario): Raw cost file for FGD Evaporation

CBI_VCE_Costs_03_26_15.xlsx With CPP (with CCR scenario): Raw cost file for VCE

Without CPP (with CCR) Scenario

CBI_SE04251_IGCC Plant Level

Cost_10312014

Without CPP (with CCR scenario): Raw cost file for IGCC

CBI_SE04271_CP_Costs_FGD_Abt

_with CCR_02102015

Without CPP (with CCR scenario): Raw cost file for FGD Chemical

Precipitation

CBI_SE04273_CP_Costs_Leachate

_Abt_02102015

Without CPP (with CCR scenario): Raw cost file for Leachate
September 30, 2015 Abt Associates | List of Rulemaking Cost and Economic Impact Files | Page 3 

File Name Description/Purpose

CBI_SE04275_Bio_Costs_FGD_Ab

t_with CCR_02102015

Without CPP (with CCR scenario): Raw cost file for FGD Biological

Treatment

CBI_SE05311_FA_Costs_Abt_wCC

R_11032014

Without CPP (with CCR scenario): Raw cost file for Fly Ash

CBI_SE05326_BA_Costs_Abt_wC

CR_02132015

Without CPP (with CCR scenario): Raw cost file for Bottom Ash

Without CCR Scenario

CBI_SE04185_FA_Costs_Abt_woC

CR_10312014

Without CCR scenario: Raw cost file for Fly Ash

CBI_SE04251_IGCC Plant Level

Cost_10312014

Without CCR scenario: Raw cost file for IGCC

CBI_SE04273_CP_Costs_Leachate

_Abt_02102015

Without CCR scenario: Raw cost file for Leachate

CBI_SE04277_CP_Costs_FGD_Abt

_without CCR_02102015

Without CCR scenario: Raw cost file for FGD Chemical Precipitation

CBI_SE04279_Bio_Costs_FGD_Ab

t_without CCR_02102015

Without CCR scenario: Raw cost file for FGD Biological Treatment

CBI_SE05327_BA_Costs_Abt_wo

CCR_02132015

Without CCR scenario: Raw cost file for Bottom Ash

Cost and Economic Impact Model – Outputs [\Costs and Econ Impacts\Econ

Impacts\Analyses12EIA\RunResults]

With CPP Scenario

A_CPP

NoBAsh_fashCPP_fgd_cCPP_NoL

each

(Final_Adj_9.20.12)_04.02.15.xlsx

With CPP (with CCR scenario): Option A results. In addition to the summary

results reported in the RIA document, the results file include plant‐ and

entity‐level results for the cost‐to‐revenue analyses, as well as total costs

by wastestream.

B_CPP

NoBAsh_fashCPP_fgd_bCPP_NoL

each

(Final_Adj_9.20.12)_04.02.15.xlsx

With CPP (with CCR scenario): Option B results

C_CPP

bash_adjCPP_fashCPP_fgd_bCPP

_NoLeach

(Final_Adj_9.20.12)_04.02.15.xlsx

With CPP (with CCR scenario): Option C results

D_CPP

bashCPP_fashCPP_fgd_bCPP_NoL

each

(Final_Adj_9.20.12)_04.02.15.xlsx

With CPP (with CCR scenario): Option D results

E_CPP

bashCPP_fashCPP_fgd_bCPP_lea

ch_cCPP

(Final_Adj_9.20.12)_04.02.15.xlsx

With CPP (with CCR scenario): Option E results

Devap_CPP

bashCPP_fashCPP_fgd_eCPP_NoL

each

(Final_Adj_9.20.12)_08.11.15.xlsx

With CPP (with CCR scenario): Option D results with alternative evaporation

technology

UMRA_2015‐04‐07.xlsx With CPP (with CCR scenario): UMRA results for all owners, all five

regulatory options

UMRA_MAJORITY_2015‐04‐

06.xlsx

With CPP (with CCR scenario): UMRA results for majority owners
September 30, 2015 Abt Associates | List of Rulemaking Cost and Economic Impact Files | Page 4 

File Name Description/Purpose

Without CPP (with CCR) Scenario – 50 MW Threshold

_02.23.15/GT50MW/A_CCR

NoBAsh_fashCCR_fgd_cCCR_NoL

each

(Final_Adj_9.20.12)_02.23.15.xlsx

Without CPP (with CCR scenario): Option A results

_02.23.15/GT50MW/B_CCR

NoBAsh_fashCCR_fgd_bCCR_NoL

each

(Final_Adj_9.20.12)_02.23.15.xlsx

Without CPP (with CCR scenario): Option B results

_02.23.15/GT50MW/C_CCR

bash_adjCCR_fashCCR_fgd_bCCR

_NoLeach

(Final_Adj_9.20.12)_02.23.15.xlsx

Without CPP (with CCR scenario): Option C results

_02.23.15/GT50MW/D_CCR

bashCCR_fashCCR_fgd_bCCR_No

Leach

(Final_Adj_9.20.12)_02.23.15.xlsx

Without CPP (with CCR scenario): Option D results

_02.23.15/GT50MW/E_CCR

bashCCR_fashCCR_fgd_bCCR_lea

ch_cCCR

(Final_Adj_9.20.12)_02.23.15.xlsx

Without CPP (with CCR scenario): Option E results

_04.02.15 CPP and CCR_VCE\GT

50MW\D_CCR_VCE

bashCCR_fashCCR_fgd_vceCCR_

NoLeach

(Final_Adj_9.20.12)_04.02.15

Without CPP (with CCR scenario): Option D results, with VCE

UMRA Summary.xlsx UMRA analysis results for five regulatory options without CPP (with CCR

scenario)

Sensitivity Analyses Without CCR Scenario

_02.18.15/GT50MW/A

NoBAsh_fash_fgd_c_NoLeach

(Final_Adj_9.20.12)_02.20.15.xlsx

Without CCR: Option A results

_02.18.15/GT50MWB

NoBAsh_fash_fgd_b_NoLeach

(Final_Adj_9.20.12)_02.20.15.xlsx

Without CCR: Option B results

_02.18.15/GT50MW/C

bash_adj_fash_fgd_b_NoLeach

(Final_Adj_9.20.12)_02.20.15.xlsx

Without CCR: Option C results

_02.18.15/GT50MW/D

bash_fash_fgd_b_NoLeach

(Final_Adj_9.20.12)_02.20.15.xlsx

Without CCR: Option D results

_02.18.15/GT50MW/E

bash_fash_fgd_b_leach_c

(Final_Adj_9.20.12)_02.20.15.xlsx

Without CCR: Option E results

Sensitivity Analyses Without MW Threshold

_02.18.15/AllUnits/A_CCR

NoBAsh_fashCCR_fgd_cCCR_NoL

each

(Final_Adj_9.20.12)_02.20.15.xlsx

Without CPP (with CCR scenario): Option A results
September 30, 2015 Abt Associates | List of Rulemaking Cost and Economic Impact Files | Page 5 

File Name Description/Purpose

_02.18.15/AllUnits/B_CCR

NoBAsh_fashCCR_fgd_bCCR_NoL

each

(Final_Adj_9.20.12)_02.20.15.xlsx

Without CPP (with CCR scenario): Option B results

_02.18.15/AllUnits/C_CCR

bash_adjCCR_fashCCR_fgd_bCCR

_NoLeach

(Final_Adj_9.20.12)_02.20.15.xlsx

Without CPP (with CCR scenario): Option C results

_02.18.15/AllUnits/D_CCR

bashCCR_fashCCR_fgd_bCCR_No

Leach

(Final_Adj_9.20.12)_02.20.15.xlsx

Without CPP (with CCR scenario): Option D results

_02.18.15/AllUnits/E_CCR

bashCCR_fashCCR_fgd_bCCR_lea

ch_cCCR

(Final_Adj_9.20.12)_02.20.15.xlsx

Without CPP (with CCR scenario): Option E results

_02.18.15/AllUnits/A

NoBAsh_fash_fgd_c_NoLeach

(Final_Adj_9.20.12)_02.20.15.xlsx

Without CCR: Option A results

_02.18.15/AllUnits/B

NoBAsh_fash_fgd_b_NoLeach

(Final_Adj_9.20.12)_02.20.15.xlsx

Without CCR: Option B results

_02.18.15/AllUnits/C

bash_adj_fash_fgd_b_NoLeach

(Final_Adj_9.20.12)_02.20.15.xlsx

Without CCR: Option C results

_02.18.15/AllUnits/D

bash_fash_fgd_b_NoLeach

(Final_Adj_9.20.12)_02.20.15.xlsx

Without CCR: Option D results

_02.18.15/AllUnits/E

bash_fash_fgd_b_leach_c

(Final_Adj_9.20.12)_02.20.15.xlsx

Without CCR: Option E results

Sensitivity Analyses With Alternative Compliance Years

_05.06.15_AdjComplYrs\D_CCR

bashCCR_fashCCR_fgd_bCCR_No

Leach

(Final_Adj_9.20.12)_05.06.15.xlsx

Without CPP (with CCR scenario): Option D results using different

compliance years

Sensitivity Analyses With Adjustments for Final CPP Rule

_08.17.15

DwithFinalCPPAdj\D_CPPFinal

bashCPP_fashCPP_fgd_bCPP_NoL

each

(Final_Adj_9.20.12)_08.17.15.xlsx

Option D results with adjustment to reflect unit/plant baseline retirements

based on the final CPP rule analysis  

IPM Setup Files [\Costs and Econ Impacts\IPM\Inputs]

NEEDS_v513_Adj.xlsx Contains NEEDS database underlying IPMv5.13. Indicates what units belong

to in‐scope plants.

CBI_IPM_Costs_Option BwCCR &

DwCCR & DnoCCR_GT 50

MW_02.24.15.xlsx

IPM Cost Inputs: Generator‐level cost inputs for Options B and D with CCR

and Option D without CCR, as delivered to ICF International

IPM Results [\Costs and Econ Impacts\IPM\Results]

MarketImpact.xlsx IPM analysis of market‐wide impacts; Options B and D with CCR and Option

D without CCR
September 30, 2015 Abt Associates | List of Rulemaking Cost and Economic Impact Files | Page 6 

File Name Description/Purpose

InScopeFacilityImpact.xlsx IPM analysis of impacts to steam electric plants; Options B and D with CCR

and Option D without CCR

Parsed Files BC with 316(b).

Proposed 111(d) & CCR 2020

2025 2030 to Abt 12‐31‐14.xlsx

Contains parsed (generator/boiler‐level) base case (pre‐policy) IPM

projections for the 2020, 2025 and 2030 run years.  

CBI ParsedFile_v513 ‐ 

B_CCR_greater than

50MW_2020_(02‐02‐15 To

Abt).xlsx

IPM raw results: Parsed file for Option B with CCR, Run Year 2020

CBI ParsedFile_v513 ‐ 

B_CCR_greater than

50MW_2025_(02‐02‐15 To

Abt).xlsx

IPM raw results: Parsed file for Option B with CCR, Run Year 2025

CBI ParsedFile_v513 ‐ 

B_CCR_greater than

50MW_2030_(02‐02‐15 To

Abt).xlsx

IPM raw results: Parsed file for Option B, with CCR, Run Year 2030

CBI ParsedFile_v513 ‐ 

D_CCR_greater than

50MW_2020_(To Abt).xlsx

IPM raw results: Parsed file for Option D with CCR, Run Year 2020

CBI ParsedFile_v513 ‐ 

D_CCR_greater than

50MW_2025_(To Abt).xlsx

IPM raw results: Parsed file for Option D with CCR, Run Year 2025

CBI ParsedFile_v513 ‐ 

D_CCR_greater than

50MW_2030_(To Abt).xlsx

IPM raw results: Parsed file for Option D with CCR, Run Year 2030

CBI ParsedFile_D_noCCR_greater

than 50MW_2020_(To ABT).xlsx

IPM raw results: Parsed file for Option D without CCR, Run Year 2020

CBI ParsedFile_D_noCCR_greater

than 50MW_2025_(To ABT).xlsx

IPM raw results: Parsed file for Option D without CCR, Run Year 2025

CBI ParsedFile_D_noCCR_greater

than 50MW_2020_(To ABT).xlsx

IPM raw results: Parsed file for Option D, without CCR, Run Year 2030

CBI v513 ‐ B_CCR_greater than

50MW Results ToAbt 02‐02‐

15.zip

IPM raw results: summary files for Option B with CCR

CBI v513 ‐ D_CCR_greater than

50MW Results ToAbt.zip

IPM raw results: summary files for Option D with CCR

Cost and Economic Impact Model – New Sources [\Costs and Econ Impacts\New Sources]

NSPSCosts_SummaryAllOptions_

2015‐01‐15.xlsx

Calculates incremental costs for new sources relative to new plant

construction costs

CBI_SE04254_NSPS_11192014.xls

x

Raw cost file for NSPS options and scenarios as received from ERG

Employment [\Costs and Econ Impacts\Employment]

WA05_T5_SEEmployment_20150

623.xlsx

This file contains calculations of employment impacts for the final ELGs.

Calculations follow approach from final CCR Rule analysis but with ELG‐

specific inputs where appropriate.

EmplAnalysis_LaborByTechnolog

y_DCCR50MW.xlsx

This file contains plant‐level annual operation and maintenance (O&M)

labor estimates, in hours, for regulatory option D_CCR, >50MW Universe

(as of 5/19/15). For employment impact analysis, this file also pulls facility

sample weights and compliance‐years from CostControl.xlsx.
September 30, 2015 Abt Associates | List of Rulemaking Cost and Economic Impact Files | Page 7 

File Name Description/Purpose

IPMInputsForEmployment_WA0‐

05_T6_IPM Summary_OptD_CCR

OptB_CCR OptD_noCCR

The file provides summary level outputs from IPM runs for use in

determining employment effects related to projected changes in coal

mining, natural gas extraction, etc.

Distributional Analysis [\Costs and Econ Impacts\Distributional Impacts]

WA05_T4_DistribEffects_2015‐

05‐11 v1.xlsx

This file analyzes the impacts of compliance costs on households,

considering the distribution across households by income.

Cost‐Effectiveness [\Costs and Econ Impacts\Cost‐Effectiveness]

WA2‐

05_T5_CESummary_ByOption_20

15‐09‐18.xlsx

This file contains calculations of the cost‐effectiveness of regulatory options

for direct and indirect dischargers and all five regulatory options.

WA2‐

05_T5_CESummary_ByWasteTec

h_Abt_2015‐09‐23.xlsx

This file contains calculations of the cost‐effectiveness of wastestream

control technologies.

SE05944_Load and TWPE

Industry Totals By Discharge

Type_wCCR_09162015.xlsx

Loading reductions for primary scenario without CPP. Obtained from ERG

SE6307_Load and TWPE Industry

Totals by Discharge

Type_09032015.xlsx

Loading reductions for primary scenario with CPP. Obtained from ERG

SE05945_Load and TWPE

Industry Totals By Discharge

Type_wCPP_09162015 ‐ OP

SA.xlsx

Loading reductions for sensitivity scenario with CPP. Obtained from ERG

SE06309_Pollutant Level

Loadings_CCR&CPP_Preferred

Revision_09032015.xlsx

Pollutant‐level loadings and pollutant removals with and without CPP

(final). Obtained from ERG

SE06308_Pollutant Level

Loadings_CCR&CPP_OMB

Original_09032015.xlsx

Pollutant‐level loadings and pollutant removals with and without CPP (pre‐

OMB review). Obtained from ERG

Industry Profile [\Costs and Econ Impacts\Industry Profile]

IndProf.xlsx Charts and tables developed for the electric power industry profile.

Other Support Files [\Costs and Econ Impacts\Other Support Files]

Steam Elec_Permit

Status_3.25.15.xlsx

This file contains a pull of NPDES permits for steam electric plants.

WA1‐

05_T4_RetirementsandConversio

ns_ComplianceYr_2015‐03‐

06.xlsx

This file compiles information about the effects of announced retirements

and conversions relative to assumed NPDES permit renewal years.