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



### Date May 06 , 201 3

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 fo r 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 a nd 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 rat es
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, a nd 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 En dangered 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 ResourcesMay 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 ana lysis 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.sensit vity.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 optio n 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

Ov erlaps.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

Ov erlaps.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 scenari os 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.ta ble.plant. csv", "species.group.plant.csv", "group.summary.waterbody.csv", "species.summary.waterbody.csv", "waterbody.summary.csv",

"bi g.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 Enda ngered species overlapped with facility locations, grouped by species' vulnerability to changes in water qualityMay 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 affecte d 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 wate rs 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 grou p, 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 ove rlap 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 affec ted 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 f or 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 y ears 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 benefits

per

- 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 benefi ts 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 t he 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 optionMay 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 f rom 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 exposur e. 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.xl sx 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 effe cts 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 f rom 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 t he 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 Calculate s 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.

Recei ving_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 Calculate s 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_SummaryAnnualBene fits
_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_substitut es.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 arou nd 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 po verty 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 povert y 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 c oncentrations 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 fro m 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 speciesMay 06, 2013 Abt Associates | List of Rulemaking Benefit Files | Page 6

File Name Description /Purpose

S team 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 meta

analysis 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