September 30, 2015 Abt Associates | List of Rulemaking Benefit Files | Page 1 

Date September 30, 2015 

To Record 

From Isabelle Morin, Elena Besedin, and Emmy Giovanni

Subject List of Rulemaking Benefit Analysis Files: Effluent Limitations Guidelines and Standards 

for the Steam Electric Power Generating Point Source Category 

This memorandum describes analytic files used for the analyses described in the Benefit and Costs 

Analysis (BCA) report to support development of the final ELG rule. 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 Files Developed for the Benefit and Costs Analysis (BCA) 

File Name Description/Purpose 

Water Quality Modeling [\WQ and Fish Tissue Modeling] 

\March 2015\Releases.csv RSEI raw model inputs for scenario without CPP (with CCR) 

\March 2015\Results.csv RSEI raw model outputs for scenario without CPP (with CCR) 

\April 2015\Releases.csv RSEI raw model inputs for scenario with CPP (with CCR) 

\April 2015\Results.csv RSEI raw model outputs for scenario with CPP (with CCR) 

SE_RSEI_QA_Mar15.accdb Compilation of RSEI outputs for scenario without CPP (with CCR) 

SE_RSEI_QA_April15.accdb Compilation of RSEI outputs for scenario with CPP (with CCR) 

\SPARROW2\Results\Round3\T

N\[option]\predict.sas7bdat 

Provides SPARROW output from the TN model for the scenario with CPP 

where [option] is the baseline or one of the five regulatory options analyzed 

\SPARROW2\Results\Round3\TP

\[option]\predict.sas7bdat 

Provides SPARROW output from the TP model for the scenario with CPP 

where [option] is the baseline or one of the five regulatory options analyzed 

control_CTN_44a_noadj_predict

_2002_BaseScenario.sas 

SAS code for national SPARROW TN model 

control_CTP_22_noadj_predict_2

002_BaseScenario.sas 

SAS code for national SPARROW TP model 

\Data\Scenario_update.sas SAS code used to update the SPARROW model inputs to reflect loading 

changes 

\Data\SparrowInputs_Rnd2-3.xlsx Input file providing E2RF1 loading changes for use in SPARROW 

\Data\CBI_Nutrient 

Loadings_2014-04-08.xlsx 

Input file calculating plant-level loading changes for use in SPARROW 

\Master\* SPARROW model files 

\GIS\* SPARROW model files 

\SPARROW 

Sediment\Results\Round3\[option

]\predict.sas7bdat 

Provides SPARROW output from the sediment model for the scenario with 

CPP where [option] is the baseline or one of the five regulatory options 

analyzed 

sparrow_header3_simulate_fin

al_update.sas.sas 

SAS code for national SPARROW sediment model 

\Data\data1_scenario_update.sas SAS code used to update the SPARROW model inputs to reflect loading 

changes 

\Data\load_scenarios_Round2-

3.xlsx 

Input file providing E2RF1 loading changes for use in SPARROW 

Memorandum 

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

File Name Description/Purpose 

\Data\

data_sediment_revised_new.sas7

bdat 

SPARROW input file 

\Master\* SPARROW model files 

\GIS\* SPARROW model files 

Drinking Water Screening Analysis [\Drinking Water Screening] 

CBI_Results_RSEI_FinalRule_R

un3_2015-09-29.accdb 

Screening-level review of drinking water intakes affected by discharges 

from steam electric plants 

Fish Tissue Calculations [\WQ and Fish Tissue Modeling] 

WA05-

T9_FishTissueImputation_2014-

05-13.xlsx 

File used to derive relationship between ambient water concentrations and 

fish tissue concentrations. The relationships are used to impute fish tissue 

concentrations based on RSEI results. 

FishTissueImputationRSEI_2015-

03-10.accdb 

Imputation of fish tissue data from RSEI concentrations for scenario without 

CPP 

ishTissueImputationRSEI_2015-

04-15.accdb 

Imputation of fish tissue data from RSEI concentrations for scenario with 

CPP 

DownstreamFishTissueValCalModel_2015-03-10.accdb Correction to imputed fish tissue data to reflect monitoring values for 

scenario without CPP 

DownstreamFishTissueValCalModel_2015-04-15.accdb Correction to imputed fish tissue data to reflect monitoring values for 

scenario with CPP 

Health Benefits [\Health] 

bg_pnts_ALL.csv XY Coordinates for all 2010 Census block groups in the conterminous US. 

Used in GIS distance calculations. 

CENSUS_ALL.csv Contains all the Census Summary File 1 and American Community Survey 

data used in the analysis by block group. Used in the GIS analysis. 

NHD_pnts_ALL_wdata.dbf Contains the centroid coordinates for all NHD reaches, along with some 

additional spatial information. Used in the GIS distance calculations. 

NHD_UNIV_FISH.csv The list of NHD reaches that are considered “fishable” under the analysis. 

Used to subset the full NHD reach universe in the GIS analysis. 

RSEI_R2_051315.csv The fish tissue concentrations by NHD reach under Round 2. Used to 

calculate the length-weighted average for all reaches within a distance of a 

block group in the GIS analysis. 

RSEI_R3_051315.csv The fish tissue concentrations by NHD reach under Round 3. Used to 

calculate the length-weighted average for all reaches within a distance of a 

block group in the GIS analysis. 

age_groups.xls Input file that provides the weight, exposure duration, age, and lead 

exposure assumptions for each cohort in the health analyses 

CB_data_50_R3.csv For the 50-mile buffer zone “with CPP” scenario, input file that provides the 

population (broken out by age and racial/ethnic group) and weighted 

average fish tissue arsenic, lead, and mercury concentrations (under the 

baseline and each regulatory scenario) for each affected Census Block 

Group. Also provides, for each Census Block Group, persons per household, 

poverty rate, and weighted average fish consumption advisory adjustment. 

CB_data_50_R2.csv For the 50-mile buffer zone “without CPP” scenario, input file that provides 

the population (broken out by age and racial/ethnic group) and weighted 

average fish tissue arsenic, lead, and mercury concentrations (under the 

baseline and each regulatory scenario) for each affected Census Block 

Group. Also provides, for each Census Block Group, persons per household, 

poverty rate, and weighted average fish consumption advisory adjustment. 

CB_data_100_R3.csv For the 100-mile buffer zone “with CPP” scenario, input file that provides 

the population (broken out by age and racial/ethnic group) and weighted 

average fish tissue arsenic, lead, and mercury concentrations (under the 

baseline and each regulatory scenario) for each affected Census Block 

Group. Also provides, for each Census Block Group, persons per household, 

poverty rate, and weighted average fish consumption advisory adjustment. 
September 30, 2015 Abt Associates | List of Rulemaking Benefit Files | Page 3 

File Name Description/Purpose 

CB_data_100_R2.csv For the 100-mile buffer zone “without CPP” scenario, input file that 

provides the population (broken out by age and racial/ethnic group) and 

weighted average fish tissue arsenic, lead, and mercury concentrations 

(under the baseline and each regulatory scenario) for each affected Census 

Block Group. Also provides, for each Census Block Group, persons per 

household, poverty rate, and weighted average fish consumption advisory 

adjustment. 

ethn_groups.xls Input file that provides, for each ethnic group and fishing mode cohort, the 

fish consumption rate and fertility rate. 

growth.xls Input file that provides projected population growth over the analysis period. 

Pb_run_50_R3.xls For the 50-mile buffer zone “with CPP” scenario, input file that shows the 

blood lead concentrations based on lead intake assumptions (shows the 

concentration for each unique intake observation) – generated by IEUBK 

model. 

Pb_run_50_R2.xls for the 50-mile buffer zone “without CPP” scenario, input file that shows the 

blood lead concentrations based on lead intake assumptions (shows the 

concentration for each unique intake observation) – generated by IEUBK 

model. 

Pb_run_100_R3.xls for the 100-mile buffer zone “with CPP” scenario, input file that shows the 

blood lead concentrations based on lead intake assumptions (shows the 

concentration for each unique intake observation) – generated by IEUBK 

model. 

Pb_run_100_R2.xls for the 100-mile buffer zone “without CPP” scenario, input file that shows 

the blood lead concentrations based on lead intake assumptions (shows the 

concentration for each unique intake observation) – generated by IEUBK 

model. 

perc_fish.xls input file that provides, for each state, the share of the population that fishes. 

adult_lead_ADD_50.sas SAS code that uses census block group data on weighted average fish tissue 

concentrations, population, persons per household, socioeconomic 

characteristics, and fishing habits to calculate average daily lead intake for 

exposed adults (using a 50-mile buffer zone). 

arsenic_50.sas SAS code that uses census block group data on weighted average fish tissue 

concentrations, population, persons per household, socioeconomic 

characteristics, and fishing habits to calculate benefits of reduced arsenic 

exposures (using a 50-mile buffer zone). 

lead_50.sas SAS code that uses census block group data on IEUBK outputs (child blood 

lead concentrations), population, persons per household, socioeconomic 

characteristics, and fishing habits to calculate benefits of reduced lead 

exposures (using a 50-mile buffer zone). 

lead_IEUBK_50.sas SAS code that uses census block group data on weighted average fish tissue 

concentrations, population, persons per household, socioeconomic 

characteristics, and fishing habits to generate child-specific inputs for the 

IEUBK model (using a 50-mile buffer zone). 

mercury_50.sas SAS code that uses census block group data on weighted average fish tissue 

concentrations, population, persons per household, socioeconomic 

characteristics, and fishing habits to calculate benefits of reduced mercury 

exposures (using a 50-mile buffer zone). 

population_50.sas SAS code that uses census block group data on population, persons per 

household, socioeconomic characteristics, and fishing habits to calculate 

exposed populations in health analyses (using a 50-mile buffer zone). 

adult_lead_ADD_100.sas SAS code that uses census block group data on weighted average fish tissue 

concentrations, population, persons per household, socioeconomic 

characteristics, and fishing habits to calculate average daily lead intake for 

exposed adults (using a 100-mile buffer zone). 
September 30, 2015 Abt Associates | List of Rulemaking Benefit Files | Page 4 

File Name Description/Purpose 

arsenic_100.sas SAS code that uses census block group data on weighted average fish tissue 

concentrations, population, persons per household, socioeconomic 

characteristics, and fishing habits to calculate benefits of reduced arsenic 

exposures (using a 100-mile buffer zone). 

lead_100.sas SAS code that uses census block group data on IEUBK outputs (child blood 

lead concentrations), population, persons per household, socioeconomic 

characteristics, and fishing habits to calculate benefits of reduced lead 

exposures (using a 100-mile buffer zone). 

lead_IEUBK_100.sas SAS code that uses census block group data on weighted average fish tissue 

concentrations, population, persons per household, socioeconomic 

characteristics, and fishing habits to generate child-specific inputs for the 

IEUBK model (using a 100-mile buffer zone). 

mercury_100.sas SAS code that uses census block group data on weighted average fish tissue 

concentrations, population, persons per household, socioeconomic 

characteristics, and fishing habits to calculate benefits of reduced mercury 

exposures (using a 100-mile buffer zone). 

population_100.sas SAS code that uses census block group data on population, persons per 

household, socioeconomic characteristics, and fishing habits to calculate 

exposed populations in health analyses (using a 100-mile buffer zone). 

arsenic.xls1 SAS output file summarizing the exposed population, annual benefits, and 

total benefits from the arsenic analysis. 

lead_IQ.xls1 SAS output file summarizing the exposed population, annual benefits, and 

total benefits from the lead IQ analysis. 

lead_IQ_log.xls1 SAS output file summarizing the exposed population, annual benefits, and 

total benefits from the lead IQ sensitivity analysis. 

lead_spec.xls1 SAS output file summarizing the exposed population, annual benefits, and 

total benefits from the avoided compensatory education cost analysis. 

mercury.xls1 SAS output file summarizing the exposed population, annual benefits, and 

total benefits from the mercury IQ analysis. 

Steam Electric Input Sheet – 50 

mi no CPP.xlsx 

Input file for adult lead analysis for the scenario with a 50-mile buffer zone 

“without CPP” scenario, input file that provides starting and ending year of 

analyses, exposures by COMID, cohort and compliance year, population 

distributions and body mass by decade and sex, populations by analytical 

scenario, life tables from the census bureau, Value of Statistical Life and 

inflation, and probabilities of survival through age. 

Steam Electric Input Sheet – 50 

mi with CPP.xlsx 

Input file for adult lead analysis for the scenario with a 50-mile buffer zone 

“with CPP” scenario, input file that provides starting and ending year of 

analyses, exposures by COMID, cohort and compliance year, population 

distributions and body mass by decade and sex, populations by analytical 

scenario, life tables from the census bureau, Value of Statistical Life and 

inflation, and probabilities of survival through age. 

Steam Electric Input Sheet –CPP 

appendix.xlsx 

Input file for adult lead analysis for the scenario with a 100-mile buffer zone 

“without CPP” scenario, input file that provides starting and ending year of 

analyses, exposures by COMID, cohort and compliance year, population 

distributions and body mass by decade and sex, populations by analytical 

scenario, life tables from the census bureau, Value of Statistical Life and 

inflation, and probabilities of survival through age. 

Steam Electric Input Sheet – no 

CPP appendix.xlsx 

Input file for adult lead analysis for the scenario with a 100-mile buffer zone 

“with CPP” scenario, input file that provides starting and ending year of 

analyses, exposures by COMID, cohort and compliance year, population 

distributions and body mass by decade and sex, populations by analytical 

scenario, life tables from the census bureau, Value of Statistical Life and 

inflation, and probabilities of survival through age. 
September 30, 2015 Abt Associates | List of Rulemaking Benefit Files | Page 5 

File Name Description/Purpose 

Steam_Electric_Blood_Lead_Cal

culations-final.R 

R script implementing the Leggett + model, modified to account for changes 

in ingested lead from fish tissue consumption, suitable to the Steam Electric 

ELG analysis. The script requires R, and access to a MySQL database. 

Steam_Electric_Blood_Lead_Fun

ctions-final.R 

R script containing functions necessary to run the Leggett+ model. 

Steam_Electric_Adverse_Effects

_Monetization-final.R 

R script monetizing the benefits associated with adult lead reduction due to 

the Steam Electric ELG. 

Steam_Electric_Adverse_Effects

_Monetization functions-final.R 

R script containing functions necessary to monetize benefits of adult lead 

reductions due to the Steam Electric ELG. 

Nonmarket Water Quality Improvement Benefits Analysis [\Surface Water Quality] 

bg_pnts_ALL.csv XY Coordinates for all 2010 Census block groups in the conterminous US. 

Used in GIS distance calculations. 

CENSUS_ALL.csv Contains all the Census Summary File 1 and American Community Survey 

data used in the analysis by block group. Used in the GIS analysis. 

NHD_pnts_ALL_wdata.dbf Contains the centroid coordinates for all NHD reaches, along with some 

additional spatial information. Used in the GIS distance calculations. 

wqout_30JAN15_SEfac_Liou.csv Contains water quality values by NHD reach. Used to determine average 

change in water quality for reaches within a distance of a Census block 

group. 

wqout_30JAN15_SEfac_McClell

and.csv 

Contains water quality values by NHD reach. Used to determine average 

change in water quality for reaches within a distance of a Census block 

group. 

wqout_#####.csv Other files that contain water quality values by NHD reach under different 

scenarios. Not all are currently used. Used to determine average change in 

water quality for reaches within a distance of a Census block group. 

WQ_010915_100mi.v2_cty_inc.c

sv 

Data file providing county-level income data 

WQ_WTP_stdata_012215.csv Data file providing state-level data 

MRM2_Wtd_coef.txt Text file containing coefficient values for the MRM2 weighted model 

MRM2S_log_coef.txt Text file containing coefficient values for the MRM2-S log model 

SE_WTP_Inputs_2015_07-23.xls File containing intermediate data and calculations including metals criteria 

SE_WQWTP_26AUG15_Round

3.csv 

Data file that summarizes changes in water quality index for each option and 

census block group, as well as census block group specific information such 

as population and region, for the “with CPP” scenario 

SE_WQWTP_26AUG15_Round

2.csv 

Data file that summarizes changes in water quality index for each option and 

census block group, as well as census block group specific information such 

as population and region, for the “without CPP” scenario 

SE Analysis_compile 

WQI_2015.08.26.sas 

SAS code that calculates the baseline and post-compliance water quality 

index for each affected reach; run once for “without CPP” scenario (Round 

2) and once for “with CPP” scenario. 

SE Analysis_estimate 

benefits_state_and_buffer_2015.0

8.27.sas 

SAS code that calculates household and total WTP for surface water quality 

improvements based on changes in water quality index and various 

geographic and household characteristics 

wq_comid_summary_ROUND2_

28AUG15.xlsx 

SAS output file (with subsequent calculations) that summarizes changes in 

the water quality index under each regulatory scenario, for the “without 

CPP” scenario 

wq_comid_summary_ROUND3_

28AUG15.xlsx 

SAS output file (with subsequent calculations for exhibits) that summarizes 

changes in the water quality index under each regulatory scenario, for the 

“with CPP” scenario 

WQ_Meta_out_withCPP_28AUG

15.xls 

SAS output file (with subsequent calculations for exhibits) that shows the 

household and total WTP for surface water improvements under MRM2 and 

MRM2-S models, for the “with CPP” scenario 

WQ_Meta_out_withoutCPP_31A

UG15.xls 

SAS output file (with subsequent calculations for exhibits) that shows the 

household and total WTP for surface water improvements under MRM2 and 

MRM2-S models, for the “without CPP” scenario 
September 30, 2015 Abt Associates | List of Rulemaking Benefit Files | Page 6 

File Name Description/Purpose 

Threatened and Endangered Species Impact Benefits Analysis [\Threatened and Endangered Species] 

TE_Layers.gdb ESRI ArcGIS File Geodatabase containing species location data. 

Monetization_Layers.gdb ESRI ArcGIS File Geodatabase containing species location data for specific 

species used in the monetization analysis. 

Reaches_011215.shp ESRI ArcGIS Shapefile containing the NHD reaches that receive discharge 

under the rule. Used to determine if any T&E species overlap with the 

reaches. 

T&E.overlaps-final.R This R script compares the location of T&E species habitat with the 

locations (waterbodies) of in-scope facility discharge locations. 

comid_species.csv Input file containing the set of COMIDs containing habitat for T&E species 

water_hq.csv Input file identifying COMIDs that do not meet wq criteria at baseline and 

under various scenarios 

waterbodies.csv Input file containing proper names for COMIDs identified in files. 

t&e_spp_list.csv Species list including vulnerabilities likely to be affected by the Steam 

Electric ELG 

T&E spp with benefits – final.R Script that monetizes estimated benefits accruing to T&E species due to the 

ELG 

species.csv Input list of T&E species with potential benefits. 

comid.state.csv Input list of COMIDs and associated states 

comid_state_species.csv Input file containing list of comids, state, overlaps with T&E species, and 

length in miles of comids. 

ben_lengths.csv comids with lengths and associated states with benefits. 

All.overlaps.csv Input file listing all overlaps between T&E species and facilities in-scope of 

the ELG, and water quality exceedances under baseline and scenario 

conditions. 

Environmental Justice [\EJ] 

As_Results_50miles_2015-04-

01.xlsx 

Apportions arsenic related results across various environmental justice 

categories (e.g., poverty group, ethnicity, and combinations) with tables for 

distribution of improved health effects, benefits, and baseline incidence 

Hg_Results_50miles_2015-04-

01.xlsx 

Apportions mercury related results across various environmental justice 

categories (e.g., poverty group, ethnicity, and combinations) with tables for 

distribution of improved health effects, benefits, and baseline incidence 

Pb_Results_50miles_2015-04-

01.xlsx 

Apportions lead related results across various environmental justice 

categories (e.g., poverty group, ethnicity, and combinations) with tables for 

distribution of improved health effects, benefits, and baseline incidence 

Steam_Electric_EJ_stats.r Calculates statistics found in As_Results_50miles_2015-04-01.xlsx, 

Hg_Results_50miles_2015-04-01.xlsx, and Pb_Results_50miles_2015-04-

01.xlsx files 

Avoided Impoundment Release Benefits Analysis [\Impoundment Releases] 

impoundment analysis data.xlsx Compiles data and assumptions used in the impoundment analysis 

impoundment analysis 

wCPPavg.xlsx 

calculates the average impoundment benefits using the “with CPP, high” 

and “with CPP, low” analyses 

impoundment analysis 

wCPPhigh.xlsx 

Calculates the high end of the impoundment benefits using data from the 

“impoundment analysis data” file and baseline and post-compliance 

impoundment capacities 

impoundment analysis 

wCPPlow.xlsx 

Calculates the low end of the impoundment benefits using data from the 

“impoundment analysis data” file and baseline and post-compliance 

impoundment capacities 

impoundment analysis 

woCPP.xlsx 

Calculates the low end of the impoundment benefits for scenario without 

CPP, using data from the “impoundment analysis data” file and baseline and 

post-compliance impoundment capacities 

impoundmentdimensions.xlsx Compiles information about impoundments in the analysis universe and 

assigns them as big or small based on available data 
September 30, 2015 Abt Associates | List of Rulemaking Benefit Files | Page 7 

File Name Description/Purpose 

Air-Related Benefits Analysis [\Air] 

\Round3 – with CPP\WA5-

17_T6_AirRelatedBenefitswCPP

_2015-06-15.xlsx 

Calculates air-related benefits for scenario with CPP based on year-explicit 

changes in air emissions from electricity generation, auxiliary power use and 

transportation. 

\Round3 – with CPP\CBI WA5-

17_T9_AuxPower&Trans_2015-

04-17.xlsx 

Calculates year-explicit changes in transportation and auxiliary energy 

requirements for scenario with CPP based on plant-specific inputs received 

from ERG. 

\Round3 – with CPP\SA BPT 3% 

and 7%_newfromCharles.xlsx 

Contains the benefits per ton (BPT) values for NOX and SO2 as received 

from the Air Office. 

\Round 2 - without CPP\WA5-

17_T6_AirRelatedBenefits_2015-

06-15.xlsx 

Calculates air-related benefits for scenario without CPP based on yearexplicit changes in air emissions from electricity generation, auxiliary power 

use and transportation. 

\Round 2 - without CPP\CBI 

WA5-

17_T9_AuxPower&Trans_2015-

04-17.xlsx 

Calculates year-explicit changes in transportation and auxiliary energy 

requirements for scenario without CPP based on plant-specific inputs 

received from ERG. 

\Round2 – without CPP\SA BPT 

3% and 7%_newfromCharles.xlsx 

Contains the benefits per ton (BPT) values for NOX and SO2 as received 

from the Air Office (same as file in \Round 3 – with CPP). 

\Round2 – without CPP\WA5-

17_T6_AirRelatedBenefits_2015-

05-01_RegionalTest.xlsx 

Calculates sensitivity results on air-related benefits for scenario without CPP 

using regional BPT values instead of national BPT values. 

\Round4 – Opt F\CBI WA5-

17_T9_AuxPower&Trans_2015-

06-26.xlsx 

Calculates year-explicit changes in transportation and auxiliary energy 

requirements for Option F based on plant-specific inputs received from 

ERG. 

\Round4 – Opt F\WA5-

17_T6_AirRelatedBenefits_2015-

06-26.xlsx 

Calculates air-related benefits for Option F based on year-explicit changes in 

air emissions from electricity generation, auxiliary power use and 

transportation 

\Round4 – with CPP\SA BPT 3% 

and 7%_newfromCharles.xlsx 

Contains the benefits per ton (BPT) values for NOX and SO2 as received 

from the Air Office (same as file in \Round 3 – with CPP). 

Non-Water Quality Impacts – Bottom Ash Efficiency [\NWQI Bottom Ash Efficiency] 

CBI_AltBATech_IPMBasedAnal

ysis_2015-06-29.xlsx 

Calculates the air-related benefits resulting from efficiency improvements 

for alternative bottom ash technology based on IPM-derived emission 

factors. 

Reduced Groundwater Withdrawal Benefits Analysis [\Groundwater Quantity] 

CBI_Intake Analysis GW 1-12-

2015.xlsx 

Spreadsheet that calculates the quantity of reduced groundwater withdrawals 

and the benefits associated with the reductions 

Avoided Dredging Costs of Navigational Channels Benefits Analysis 

Nav Dredging_2015.04.27.xlsx USACE Dredging Data 

Nav Dredging_2015.06.02.xlsx Compiled navigational dredging data 

SE_Dredging_E2RF1_wStates_2

015.05.14.v2.xlsx 

List of HUC ID affected by discharges from steam electric facilities that had 

at least one dredging job 

NavDredgingData_1998-

2012_27APR15.xlsx 

Provides locational information and lat /longs for dredging jobs on reaches 

affected by steam electric discharges 

CCI.xlsx Input file- Construction cost index data 

predict.txt TSS concentration data from the SPARROW run 

e2rf1_dredge_xwalk.xlsx Crosswalk – dredging jobs and E2RF1 reaches 

EPAregion.xlsx EPA regions 

e2rf1s_w_sed_ch_ROUND1_04.

02.15.xlsx 

Input file - Provides data on sediment concentration/deposition for the 

reaches included in the analysis of dredging benefits. 

dreding_e2rf.xlsx Input file -Consolidated data on dredging jobs located on reaches affected 

by steam electric dischargers (including E2RF1 ID, lat/longs, and other 

relevant dredging job parameters) 

1_SE_NavDredging_DataCompil

e_1998-2012_2015.06.11.SAS 

SAS code to assemble input data 
September 30, 2015 Abt Associates | List of Rulemaking Benefit Files | Page 8 

File Name Description/Purpose 

2_NavDredging_AvoidedCostCal

cs_2015.06.22.sas 

SAS code to calculate avoided costs of navigational waterway dredging. 

NavDredging_Output_23JUN15_

ROUND2_woCPP.xlsx 

Output file - summary of the avoided costs from reduced dredging of 

navigational channels (without CPP rule). 

NavDredging_Output_23JUN15_

ROUND3_wCPP.xlsx 

Output file - summary of the avoided costs from reduced dredging of 

navigational channels (with CPP rule). 

Avoided Dredging Costs of Reservoirs Benefits Analysis

RR_EPAREG_xwalk_04.07.15.xl

sx 

Input file - crosswalk between states and EPA regions 

Regyr_table_2015.06.03.xlsx Input file – table listing options and years in the analysis period 

costcy_for_res_23JUN15.xlsx Input file – average costs per cubic meter of sediment dredged by region 

predict.txt Input file – sediment concentration from the SPARROW run 

SE_ResDreg_ResDecay_by_EPA

reg_04.07.15.xlsx 

Input file – reservoir decay rates by EPA region 

SE_ResDredging_AvoidedCosts_

2015.06.22.SAS 

SAS code for estimating avoided cost of reservoir dredging. 

ResDredging_Output_23JUN15_

wCPP.xlsx 

Output file – summary of estimated avoided costs from reducing reservoir 

dredging (with CPP rule) 

ResDredging_Output_23JUN15_

woCPP.xlsx 

Output file – summary of estimated avoided costs from reducing reservoir 

dredging (without CPP rule) 

Meta-analysis of Stated Preference Water Quality Studies [\Meta-analysis]

WQM0_FilesAndDirectories.do This program documents the names of all files and directories used in the 

meta-analysis. 

WQM1a_DefineVariableValues.x

lsx 

This program sets variable values for use in benefit transfer based on the 

revised versions of the meta-analysis model. 

WQM1b_RegressionModel.do This program runs regressions that model willingness-to-pay for water 

quality changes. 

WQM1c_OutputRegResults.do This program outputs regression results from the meta-model in tabular 

format. 

WQM2a_WTPvsWQ.do This program conducts additional analyses to explore the 

relationship/functional form between WTP and WQ. 

WQM2b_MemoMRM2Sensitivit

y.do 

This program conducts additional analyses to explore the 

relationship/functional form between WTP and WQ, with a focus on 

MRM2. 

WQM3_Example WTP 

Calculations by Model.xlsx 

This program calculates WTP for different potential meta-models. 

WQM1b_CleanMetadata.dta This Stata file contains a clean copy of the meta-dataset. 

WQM1b_Coef_20150422_MRM

1.ster 

This Stata .ster file documents the regression results for the unweighted 

MRM1 model. 

WQM1b_Coef_20150422_MRM

2.ster 

This Stata .ster file documents the regression results for the unweighted 

MRM2 model. 

WQM1b_Coef_20150422_MRM

2weights.ster 

This Stata .ster file documents the regression results for the weighted 

MRM2 model. 

WQM1b_Coef_20150817_MRM

2lnwqc.ster 

This Stata .ster file documents the regression results for the unweighted 

MRM2-S (ln delta WQ) model 

WQM1b_Coef_20150817_MRM

2lnwqcWt.ster 

This Stata .ster file documents the regression results for the weighted 

MRM2-S (ln delta WQ) model 

WQM1b_Coef_20150817_MRM

2wqc.ster 

This Stata .ster file documents the regression results for the unweighted 

MRM2-S (delta WQ) model 

WQM1b_Coef_20150817_MRM

2wqcWt.ster 

This Stata .ster file documents the regression results for the weighted 

MRM2-S (delta WQ) model 

WA1-

09_T5_RevisedMetadata_111214

.dta 

This is the original (raw) meta-dataset, in Stata format. 
September 30, 2015 Abt Associates | List of Rulemaking Benefit Files | Page 9 

File Name Description/Purpose 

Enhanced CCR Marketability Benefits Analysis [\Ash Marketing] 

AM1_PrepareStateDemandData.s

as 

Compiles and formats USGS “Minerals Yearbook” statistics by state, for 

cement and sand and gravel. These statistics serve as upper-bound proxies 

for the state-level demand for CCR as a replacement for sand and gravel and 

for cement. 

AM1a_StateCommodityPriceCalc

ulations.xlsx 

Estimates the multi-year average state-level price for cement and sand and 

gravel. 

AM2_CCR Reuse 

Analysis_2015-06-09.xlsx 

Estimates plant-level quantity of CCR used beneficially (based on unmet 

state-level demand) and estimates monetary value of beneficial re-use and 

also estimates plant-level quantity and economic value of avoided resource 

and environmental impacts of virgin materials gained by using CCRs in 

beneficial reuse applications. 

Total Benefits Analysis [\Total Benefits] 

WA05_T9_SummaryAllBenefits.

xlsx 

Summarizes benefits results from all benefit categories, calculates total 

benefits, benefits over time, net benefits, and associated ratios 

1. there are three copies of each of these health results files: one for the 50-mile buffer zone “with CPP” scenario, 

one for the 50-mile buffer zone “without CPP” scenario, and one for the 100-mile buffer zone “with CPP” 

scenario. There is a separate folder for each scenario.