May 06, 2013 Abt Associates | List of Rulemaking Benefit Files | Page 1

Date May 06, 2013

To Record

From Isabelle Morin and Rob Chew

Subject List of Rulemaking Benefit Files: Steam Electric Effluent Guidelines Rulemaking

This memorandum describes analytic files used for the Benefit and Costs Analysis (BCA) 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 and comment by the public without potentially releasing proprietary information.

Table 1: List of Benefit Files Developed for the Benefit and Costs Analysis (BCA)

File Name Description/Purpose

a1e.mgd.csv Input file containing estimates of age-1 equivalent species losses per million 

of gallons per day (MGD) in different geographic regions. Compares losses 

due to impingement and entrainment.

a1e.year.csv Input file with annual estimates of age-1 equivalent species losses by 

fisheries region. Compares losses due to impingement and entrainment.

aifs.csv Input file allocating cooling water flow by state into fisheries regions.

flow.reductions.csv Input file estimating reduced intake flow by regulated facilities

households.csv Input file with projected total population and household unit figures per state 

from 2010-2040

states.csv Input file with crosswalk between state names and abbreviations

survey.region.a1e.csv Input file with baseline age-1 equivalent species losses by stated preference 

survey region (Inland, Pacific, Northeast, and Southeast)

wtp.values.csv Input file containing willingness to pay estimates for reduction in age-1 

equivalent species losses with low, middle, and high percentile range

annualized.bens.oct24.csv Contains the estimated national annualized benefits reduction in age-1 

equivalent species losses under the proposed options and discount rates

WTP SE.R R code used to calculate national annualized benefits in 

"annualized.bens.oct24.csv"

fractional.population.change.scen

ario.state.csv

Estimated population changes to Threatened and Endangered species by 

state and proposed option (1, 2, 3, 4, and 5), assuming population impacts of 

0.5%, 1%, and 1.5% when water quality standards are met because of the 

rule.

fractional.population.change.scen

ario.state.opt3.csv

Estimated population changes to Threatened and Endangered species by 

state and sensitivity analysis scenarios for option 3, assuming population 

impacts of 0.5%, 1%, and 1.5% when water quality standards are met 

because of the rule.

fractional.population.change.scen

ario.state.opt4.csv

Estimated population changes to Threatened and Endangered species by 

state and sensitivity analysis scenarios for option 4, assuming population 

impacts of 0.5%, 1%, and 1.5% when water quality standards are met 

because of the rule.

Memorandum

Environment and Resources
May 06, 2013 Abt Associates | List of Rulemaking Benefit Files | Page 2

File Name Description/Purpose

Steam Electric, T&E species -

final screen.xlsx

Contains a screening analysis to determine which Threatened and 

Endangered species could be affected based on habitat regions and life 

history traits.

T&E spp with benefits.R R code used to calculate "fractional.population.change.scenario.state.csv"

T&E spp with 

benefits.sensitvity.analysis.R

R code used to calculate 

"fractional.population.change.scenario.state.opt3.csv" and 

"fractional.population.change.scenario.state.opt4.csv"

base.comids.csv Input file containing estimated pollutant concentrations by COMID and 

proposed option

bases3.csv Input file containing estimated pollutant concentrations by COMID, 

constituent and sensitivity analysis scenarios for option 3

bases4.csv Input file containing estimated concentrations of pollutions by COMID, 

constituent and sensitivity analysis scenarios for option 4

comid.state.csv Input file with crosswalk between COMID and state in which the body of 

water is located

fract.of.benefits.csv Fraction of maximum benefits by plant and sensitivity analysis scenarios for 

options 3 and 4

Overlaps.csv Contains the overlap of Threatened and Endangered species by COMID and 

Plant ID

plant.lookups.csv Provides a plant name, COMID, water body name, and water body type for 

each plant ID

species.csv Input file containing a crosswalk between Threatened and Endangered 

species and their species groups

waterbodies.csv Input file with crosswalk between COMID, water body name, and water 

body type

waterbody.species.csv Input file indicating which Threatened and Endangered species have a range 

that overlaps with a given waterbody

WQ.exceedances.csv Contains modeled wildlife pollutant hazard quotients (for sediment, trophic 

level 3 fish and trophic level 4 fish) by COMID and plant ID under various 

sensitivity analysis scenarios for options 3 & 4

Overlaps.csv Contains the overlap of Threatened and Endangered species by COMID and 

Plant ID

SE_MPAs_Overlap_AffectedRea

ches_8-13-12.xlsx

Contains the overlap between the affected reaches and MPAs

SE_Species_Overlap_AffectedRe

aches_8-14-12.xlsx

Used to find overlaps between essential fish habitats, Threatened and 

Endangered Species, and affected reaches

TE1.xlsx Contains modeled wildlife pollutant hazard quotients (for sediment, trophic 

level 3 fish and trophic level 4 fish) by COMID and plant ID under various 

sensitivity analysis scenarios for options 3 & 4

WQ.exceedances.csv Contains modeled wildlife pollutant hazard quotients (for sediment, trophic 

level 3 fish and trophic level 4 fish) by COMID and plant ID under various 

sensitivity analysis scenarios for options 3 & 4

Species Affected.xlsx Summary of Threatened and Endangered species that will see water quality 

improvements under the rule, the states in which affected species live, and 

the number of water bodies that are expected to improve

T&E.species.R R code used to calculate "group.summary.plant.csv", 

"species.summary.plant.csv", "plant.summary.csv", "big.table.plant.csv", 

"species.group.plant.csv", "group.summary.waterbody.csv", 

"species.summary.waterbody.csv", "waterbody.summary.csv", 

"big.table.waterbody.csv", and "species.group.waterbody.csv"

big.table.plant.csv Presence/absence matrix of facilities with improved water quality and 

habitat overlaps of Threatened and Endangered species

group.summary.plant.csv Count of Threatened and Endangered species overlapped with facility 

locations, grouped by species' vulnerability to changes in water quality
May 06, 2013 Abt Associates | List of Rulemaking Benefit Files | Page 3

File Name Description/Purpose

plant.summary.csv Count of Threatened and Endangered species by species vulnerability status 

and species group, overlapping facilities affected by the rule

species.group.plant.csv List of Threatened and Endangered species overlapping with one or more 

regulated facilities

species.summary.plant.csv Count of facilities affecting Threatened and Endangered species, grouped by 

species and vulnerability status

T & E within 5 mi of plants.xlsx Summarizes the number of facilities in-scope of the Steam Electric rule, 

whose i) discharges are within 5 miles of habitat used by federally listed 

threatened and endangered species; ii) receiving waters do not meet water 

quality metrics recognized to cause harm in organisms under baseline 

conditions; and iii) whose receiving waters exceed water quality metrics 

under the most stringent proposed option. Counts are summarized by 

species, by taxonomic group, and by relative vulnerability.

big.table.waterbody.csv Presence/absence matrix of waterbodies with improved water quality and 

habitat overlaps of Threatened and Endangered species

COMID Data.xlsx Information about each facility and the COMIDs they overlap with

group.summary.waterbody.csv Count of Threatened and Endangered species overlapped with waterbodies, 

grouped by species' vulnerability to changes in water quality

species.group.waterbody.csv List of Threatened and Endangered species overlapping with one or more 

waterbodies

species.summary.waterbody.csv Count of waterbodies containing Threatened and Endangered species, 

grouped by species and vulnerability status

Waterbodies with 

Improvements.xlsx

Summarizes the number of waterbodies affected by the Steam Electric rule. 

Counts are summarized by species, by taxonomic group, and by relative 

vulnerability.

waterbody.summary.csv Count of Threatened and Endangered species by species vulnerability status 

and species group, overlapping waterbodies affected by the rule

Overlaps.csv Contains the overlap of Threatened and Endangered species by COMID and 

Plant ID

plant.lookups.csv Provides a plant name, COMID, water body name, and water body type for 

each plant ID

waterbodies.csv Input file with crosswalk between COMID, water body name, and water 

body type

WQ.exceedances.csv Contains modeled wildlife pollutant hazard quotients (for sediment, trophic 

level 3 fish and trophic level 4 fish) by COMID and plant ID under various 

sensitivity analysis scenarios for options 3 & 4

BPT regressions_10.19.12.xls Regression output results used to develop air emissions benefits estimates 

from 2016-2040. Output figures measured in tons.

SA BPT 3% and 

7%_newfromCharles.xls

Uses air emissions estimates from EPA for the years 2005, 2016, 2020, 

2025, and 2030 to predict air emissions between 2016 and 2040. Used to 

develop BPT estimates.

WA5-

17_T6_AirRelatedBenefits_2013-

01-09.xlsx

Contains IPM analysis results for Options 3* and 4.

BPT extrap for SE 

analysis_10.19.12.txt

This is a SAS program which uses linear regression to calculate benefitsper-ton (BPT) of emissions reduction for each year of the analysis period 

based on existing BPT estimates

CBI_ImpoundmentFailureAnalysi

s_112112.xlsx

This file calculates the benefits of reduced surface impoundment failures 

that are associated with impoundment closures under proposed Steam 

Electric Effluent Limitation Guidelines

CBI_ImpoundmentFailureAnalysi

s_112112_regression_sens.xlsx

This file conducts a sensitivity analysis of the benefits of reduced surface 

impoundment failures that are associated with impoundment closures under 

proposed Steam Electric Effluent Limitation Guidelines

Groundwater Benefits 10-9-

12.xlsx

Calculates the benefits from groundwater quality improvements, by option
May 06, 2013 Abt Associates | List of Rulemaking Benefit Files | Page 4

File Name Description/Purpose

CBI_Intake Analysis GW 9-18-

2012.xlsx

Calculates the benefits from reduced groundwater withdrawals, by option

Arsenic LADD 10-18.xlsx Output file containing the Lifetime Average Daily Dose (LADD) values for 

arsenic by COMID and age cohort

COMID_populations.xls Contains the total and estimated affected population for pollutant exposure 

by COMID

Downstream_cancer_rec.xlsx Calculates the annual benefits to recreational anglers from reduced cancer 

cases. Includes effects to both receiving and downstream reaches.

Downstream_cancer_sub.xlsx Calculates the annual benefits to subsistence fishers from reduced cancer 

cases. Includes effects to both receiving and downstream reaches.

Downstream_cancer_total.xlsx Calculates the total annual benefits from reduced cancer cases. Includes 

effects to both receiving and downstream reaches.

Downstream_lead_rec.xlsx Calculates the annual benefits to recreational anglers from reduced lead 

exposure. Includes effects to both receiving and downstream reaches.

Downstream_lead_sub.xlsx Calculates the annual benefits to subsistence fishers from reduced lead 

exposure. Includes effects to both receiving and downstream reaches.

Downstream_lead_total.xlsx Calculates the total annual benefits from reduced lead exposure. Includes 

effects to both receiving and downstream reaches.

Downstream_merc_rec.xlsx Calculates the annual benefits to recreational anglers from reduced mercury 

exposure. Includes effects to both receiving and downstream reaches.

Downstream_merc_sub.xlsx Calculates the annual benefits to subsistence fishers from reduced mercury 

exposure. Includes effects to both receiving and downstream reaches.

Downstream_merc_total.xlsx Calculates the total annual benefits from reduced mercury exposure. 

Includes effects to both receiving and downstream reaches.

Downstream_spec_rec.xlsx Calculates the annual benefits from reduced IQ loss through lessened lead 

exposure (recreational anglers). Includes effects to both receiving and 

downstream reaches.

Downstream_spec_sub.xlsx Calculates the annual benefits from reduced IQ loss through lessened lead 

exposure (subsistence fishers). Includes effects to both receiving and 

downstream reaches.

Downstream_spec_total.xlsx Calculates the total annual benefits from reduced IQ loss through lessened 

lead exposure. Includes effects to both receiving and downstream reaches.

IEUBK output.xlsx File containing the Integrated Exposure Uptake Biokinetic (IEUBK) model 

outputs

Lead LADD 10-18.xlsx Output file containing the Lifetime Average Daily Dose (LADD) values for 

lead by COMID and age cohort

Mercury intake 10-26.xlsx Contains data on mercury intake levels by COMID and age cohort

Receiving_cancer_rec.xlsx Calculates the annual benefits to recreational anglers from reduced cancer 

cases. Only includes effects to receiving reaches.

Receiving_cancer_sub.xlsx Calculates the annual benefits to subsistence fishers from reduced cancer 

cases. Only includes effects to receiving reaches.

Receiving_cancer_total.xlsx Calculates the total annual benefits from reduced cancer cases. Only 

includes effects to receiving reaches.

Receiving_lead_rec.xlsx Calculates the annual benefits to subsistence fishers from reduced lead 

exposure. Only includes effects to receiving reaches.

Receiving_lead_sub.xlsx Calculates the total annual benefits from reduced lead exposure. Only 

includes effects to receiving reaches.

Receiving_lead_total.xlsx Calculates the annual benefits to recreational anglers from reduced lead 

exposure. Only includes effects to receiving reaches.

Receiving_merc_rec.xlsx Calculates the annual benefits to recreational anglers from reduced mercury 

exposure. Only includes effects to receiving reaches.

Receiving_merc_sub.xlsx Calculates the annual benefits to subsistence fishers from reduced mercury 

exposure. Only includes effects to receiving reaches.

Receiving_merc_total.xlsx Calculates the total annual benefits from reduced mercury exposure. Only 

includes effects to receiving reaches.
May 06, 2013 Abt Associates | List of Rulemaking Benefit Files | Page 5

File Name Description/Purpose

Receiving_spec_rec.xlsx Calculates the annual benefits from reduced IQ loss through lessened lead 

exposure (recreational anglers). Only includes effects to receiving reaches.

Receiving_spec_sub.xlsx Calculates the annual benefits from reduced IQ loss through lessened lead 

exposure (subsistence fishers). Only includes effects to receiving reaches.

Receiving_spec_total.xlsx Calculates the total annual benefits from reduced IQ loss through lessened 

lead exposure. Only includes effects to receiving reaches.

WA5-

17_T6_SummaryAnnualBenefits

_2013-04-30.xlsx

Contains (1) annualized monetized benefits estimates for all benefit 

categories analyzed and (2) annualized social costs, estimated at a 3% and 

7% discount rate. Shows benefits and costs for options 1, 2, 3, 4, and 5.

e2rf1_substitutes.sas7bdat List of substitute reaches (reaches within 100 miles of the affected reaches)

FIPS 5-2 - State Codes of the US 

and Outlying Areas.pdf

Crosswalk between state name and FIPS code

HH & EJ GIS.sas This program process GIS output for downstream reaches for the human 

health and GIS analysis. The program calculates total population, total 

minority population, total population below the poverty line and median 

household income for a 100 mile buffer around each downstream reach. The 

program also calculates the percent of RF1 miles within the 100 mile buffer 

that are comprised of each downstream reach 

HH_EJ_Pop_and_E2RF1_Sub_d

ata.xlsx

Output file that contains minority population, population below poverty line 

and total population within 100 miles of an affected reach

SAS Inputs for HH & EJ GIS 

Processing.xlsx

Input file for the SAS program “HH & EJ GIS.sas”

total_bg_pop.sas7bdat Output file that contains minority population, population below poverty line 

and total population within 100 miles of reach, regardless of state border 

designations

total_bg_state_pop.sas7bdat Output file that contains minority population, population below poverty line 

and total population within 100 miles of reach by state

hh_inc_2010_2040.sas7bdat Forecasted state-level income between 2010-2040

metadataforCandD9.10.09.csv Metadata used in the surface water WTP regression analysis

predict_base_revised.sas7bdat Predicted sediment concentrations for the base case from SPARROW

predict_TN_Base.sas7bdat Predicted total nitrogen concentrations for the base case option from 

SPARROW

predict_TN_opt1.sas7bdat Predicted total nitrogen concentrations for option 1 from SPARROW

predict_TN_opt2.sas7bdat Predicted total nitrogen concentrations for option 2 from SPARROW

predict_TN_opt3.sas7bdat Predicted total nitrogen concentrations for option 3 from SPARROW

predict_TN_opt4.sas7bdat Predicted total nitrogen concentrations for option 4 from SPARROW

predict_TN_opt5.sas7bdat Predicted total nitrogen concentrations for option 5 from SPARROW

predict_TP_Base.sas7bdat Predicted total phosphorus concentrations for the base case option from 

SPARROW

predict_TP_opt1.sas7bdat Predicted total phosphorus concentrations for option 1 from SPARROW

predict_TP_opt2.sas7bdat Predicted total phosphorus concentrations for option 2 from SPARROW

predict_TP_opt3.sas7bdat Predicted total phosphorus concentrations for option 3 from SPARROW

predict_TP_opt4.sas7bdat Predicted total phosphorus concentrations for option 4 from SPARROW

predict_TP_opt5.sas7bdat Predicted total phosphorus concentrations for option 5 from SPARROW

Raw_SteamEA_WQ_Model_Res

ults_082312.accdb

Access file received from ERG. Contains metal concentrations outputs from 

the EA.

SE WTPcoef 12-6-12.xls Contains additional water quality and demographic data for the program. 

Also contains compliance schedule for the plants and eco-region specific 

index curves.

statepop10_40.sas7bdat Forecasted state-level population between 2010-2040

totalmiles_all_reaches.sas7bdat Total "water miles" with 100 miles of a reach

SE T&E Montization.sas Monetizes the benefits for potential T&E species increases

WTP T&E 05DEC12.xls Output file that contains monetized benefits for T&E species
May 06, 2013 Abt Associates | List of Rulemaking Benefit Files | Page 6

File Name Description/Purpose

Steam Electric Benefits Analysis 

- state level.SAS

SAS code that estimates baseline and post compliance water quality, and 

then monetizes benefits for water quality improvements using a metaanalysis

WTP per Reach - state avg .xls Total benefits and HH WTP benefits generated from the above code

WQ Reg miles Improv Baseline and post compliance water quality values generated by the above 

code