HEA_Inputs_03.21.11.xls

Author: Abt Associates Inc.

Created: 03/21/11

Updated: 03/22/11

Worksheet Description

ComplianceYear Compliance year data by facility

IDMAP Map of facility ID codes

prim_prod Primary production and trophic transfer inputs

rest_costs Restoration cost inputs

WTP Household WTP inputs

HH_data State household data

flow_data Regional distribution of flow

CPI.2002.2009 CPI data

flowdata Facility data

NBRATIO Net benefits ratio inputs

rpschd Draft schedule inputs for repowering facilities

ID_AND_WEIGHT Facility weights

Note: The original version of this file contains, or is linked to a file that contains,

confidential business information (CBI), or information that could be used to reveal

CBI. As a result, the values for any variables determined by EPA to be CBI, or that

could be used to reveal CBI, have been concealed.

File Info 1 of 95
ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 2 of 95
ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 3 of 95
ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 4 of 95
ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 5 of 95
ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 6 of 95
ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 7 of 95
ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 8 of 95
ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 9 of 95
ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 10 of 95
ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 11 of 95
SURVEYID PLNTCODE ID

IDMAP 12 of 95
SURVEYID PLNTCODE ID

IDMAP 13 of 95
SURVEYID PLNTCODE ID

IDMAP 14 of 95
SURVEYID PLNTCODE ID

IDMAP 15 of 95
SURVEYID PLNTCODE ID

IDMAP 16 of 95
SURVEYID PLNTCODE ID

IDMAP 17 of 95
SURVEYID PLNTCODE ID

IDMAP 18 of 95
SURVEYID PLNTCODE ID

IDMAP 19 of 95
SURVEYID PLNTCODE ID

IDMAP 20 of 95
SURVEYID PLNTCODE ID

IDMAP 21 of 95
SURVEYID PLNTCODE ID

IDMAP 22 of 95
SURVEYID PLNTCODE ID

IDMAP 23 of 95
SURVEYID PLNTCODE ID

IDMAP 24 of 95
SURVEYID PLNTCODE ID

IDMAP 25 of 95
SURVEYID PLNTCODE ID

IDMAP 26 of 95
SURVEYID PLNTCODE ID

IDMAP 27 of 95
SURVEYID PLNTCODE ID

IDMAP 28 of 95
SURVEYID PLNTCODE ID

IDMAP 29 of 95
region species rest_id abv_prim_prod alg_prim_prod C_export tc_det tc_1st

calif kelp ca_kelp 7,300 730 0.25 0.4 0.2

calif typha ca_typha 6,200 620 0.25 0.4 0.2

northatlantic spartina na_spartina 3,350 533 0.25 0.4 0.2

northatlantic eelgrass na_eelgrass 3,750 375 0.25 0.4 0.2

midatlantic spartina ma_spartina 3,350 533 0.25 0.4 0.2

midatlantic eelgrass ma_eelgrass 3,750 375 0.25 0.4 0.2

gulfmexico spartina gom_spartina 6,350 533 0.25 0.4 0.2

gulfmexico turtlegrass gom_turtlegrass 2,400 240 0.25 0.4 0.2

southatlantic spartina sa_spartina 6,350 533 0.25 0.4 0.2

southatlantic eelgrass sa_eelgrass 3,750 375 0.25 0.4 0.2

greatlakes typha gl_typha 6,200 620 0.25 0.4 0.2

inland typha in_typha 6,200 620 0.25 0.4 0.2

prim_prod 30 of 95
region species rest_id

calif kelp ca_kelp

calif typha ca_typha

northatlantic spartina na_spartina

northatlantic eelgrass na_eelgrass

midatlantic spartina ma_spartina

midatlantic eelgrass ma_eelgrass

gulfmexico spartina gom_spartina

gulfmexico turtlegrass gom_turtlegrass

southatlantic spartina sa_spartina

southatlantic eelgrass sa_eelgrass

greatlakes typha gl_typha

inland typha in_typha

tc_2nd tc_3rd

0.2 0.2

0.2 0.2

0.2 0.2

0.2 0.2

0.2 0.2

0.2 0.2

0.2 0.2

0.2 0.2

0.2 0.2

0.2 0.2

0.2 0.2

0.2 0.2

prim_prod 31 of 95
region species rest_id cost_acre

calif kelp ca_kelp 505332

calif typha ca_typha ?

northatlantic spartina na_spartina ?

northatlantic eelgrass na_eelgrass 616862

midatlantic spartina ma_spartina 104386

midatlantic eelgrass ma_eelgrass ?

gulfmexico spartina gom_spartina 36779

gulfmexico turtlegrass gom_turtlegrass ?

southatlantic spartina sa_spartina 60180

southatlantic eelgrass sa_eelgrass ?

greatlakes typha gl_typha 89215

inland typha in_typha 67180

rest_costs 32 of 95
region species rest_id tot_WTP_HH fish_prod WTP_HH

calif kelp ca_kelp 0.000000 100% 0.000000

calif typha ca_typha 0.007800 10.00% 0.000780

northatlantic spartina na_spartina 0.043100 25.60% 0.011034

northatlantic eelgrass na_eelgrass 0.076080 100.00% 0.076080

midatlantic spartina ma_spartina 0.067200 25.60% 0.017203

midatlantic eelgrass ma_eelgrass 0.076080 100.00% 0.076080

gulfmexico spartina gom_spartina 0.043100 25.60% 0.011034

gulfmexico turtlegrass gom_turtlegrass 0.076080 100.00% 0.076080

southatlantic spartina sa_spartina 0.043100 25.60% 0.011034

southatlantic eelgrass sa_eelgrass 0.076080 100.00% 0.076080

greatlakes typha gl_typha 0.013100 20.00% 0.002620

inland typha in_typha 0.011800 10.00% 0.001180

WTP 33 of 95
state numHH

AL 1,836,096

AR 1,132,706

AZ 2,266,797

CA 12,371,970

CO 1,891,368

CT 1,365,529

DC 268,559

DE 329,246

FL 7,252,011

GA 3,472,892

IA 1,248,977

ID 560,873

IL 4,821,525

IN 2,501,050

KS 1,120,251

KY 1,695,340

LA 1,595,221

MA 2,533,224

MD 2,138,174

ME 561,927

MI 3,977,292

MN 2,095,360

MO 2,373,024

MS 1,106,531

MT 383,318

NC 3,562,025

ND 285,857

NE 719,904

NH 518,506

NJ 3,186,057

NM 735,720

NV 947,691

NY 7,303,783

OH 4,622,384

OK 1,431,014

OR 1,476,434

PA 5,021,383

RI 419,621

SC 1,718,297

SD 327,165

TN 2,449,562

TX 8,271,247

UT 837,511

VA 2,996,176

VT 260,831

WA 2,519,727

WI 2,302,752

WV 756,778

WY 211,883

HH_data 34 of 95
region state AIF frac_AIF

calif CA 11161.01 1.00

calif total 1.00

greatlakes IL 716.9 0.04

greatlakes IN 2214.865 0.12

greatlakes MI 6753.446 0.35

greatlakes MN 242.6 0.01

greatlakes NY 3718.191 0.20

greatlakes OH 2275.163 0.12

greatlakes PA 37.6 0.00

greatlakes WI 3087.876 0.16

greatlakes total 1.00

inland AL 8204.449 0.06

inland AR 2132.447 0.02

inland AZ 290.53 0.00

inland CA 1.2 0.00

inland CO 300.6403 0.00

inland CT 194.0467 0.00

inland DC 1.347148 0.00

inland DE 33 0.00

inland FL 755.5034 0.01

inland GA 3289.231 0.02

inland IA 2408.706 0.02

inland IL 10156 0.07

inland IN 6377.277 0.05

inland KS 2169.67 0.02

inland KY 3520.087 0.03

inland LA 6988.356 0.05

inland MA 157.7859 0.00

inland MD 471.7657 0.00

inland ME 110.5412 0.00

inland MI 2247.565 0.02

inland MN 2166.648 0.02

inland MO 6272.162 0.05

inland MS 913.0014 0.01

inland MT 176.7987 0.00

inland NC 8688.919 0.06

inland ND 903.5987 0.01

inland NE 3015.303 0.02

inland NH 233.0278 0.00

inland NJ 114.9921 0.00

inland NM 46.56333 0.00

inland NV 69.12 0.00

inland NY 2578.704 0.02

inland OH 6840.283 0.05

inland OK 1890.128 0.01

inland OR 60.99963 0.00

inland PA 6631.607 0.05

inland SC 6067.301 0.04

inland SD 8.845041 0.00

inland TN 9480.705 0.07

inland TX 24892.29 0.18

flow_data 35 of 95
region state AIF frac_AIF

inland UT 41.48801 0.00

inland VA 1840.587 0.01

inland VT 323.4667 0.00

inland WA 246.2448 0.00

inland WI 1712.151 0.01

inland WV 3894.248 0.03

inland WY 223.1107 0.00

inland total 1.00

midatlantic DE 1430.625 0.05

midatlantic MD 6766.152 0.24

midatlantic NJ 6251.668 0.22

midatlantic NY 8993.723 0.32

midatlantic PA 48.412 0.00

midatlantic VA 4674.506 0.17

midatlantic total 1.00

gulfmexico FL 7054.289 0.53

gulfmexico LA 984.9659 0.07

gulfmexico MS 302.57 0.02

gulfmexico TX 4904.056 0.37

gulfmexico total 1.00

southatlantic FL 5243.84 0.70

southatlantic GA 198.4691 0.03

southatlantic NC 1426.89 0.19

southatlantic SC 592.8525 0.08

southatlantic total 1.00

northatlantic CT 2099.031 0.30

northatlantic MA 3504.762 0.50

northatlantic ME 248.8683 0.04

northatlantic NH 909.3883 0.13

northatlantic RI 275.3553 0.04

northatlantic total 1.00

flow_data 36 of 95
Year oneis2009

1997 1.34

1998 1.32

1999 1.29

2000 1.25

2001 1.21

2002 1.19

2003 1.17

2004 1.14

2005 1.10

2006 1.06

2007 1.03

2008 1.00

2009 1.00

CPI.2002.2009 37 of 95
EIA Code ID Plant Name Plant State Water Body Type

Benefits

Region

flowdata 38 of 95
EIA Code ID Plant Name Plant State Water Body Type

Benefits

Region

flowdata 39 of 95
EIA Code ID Plant Name Plant State Water Body Type

Benefits

Region

flowdata 40 of 95
EIA Code ID Plant Name Plant State Water Body Type

Benefits

Region

flowdata 41 of 95
EIA Code ID Plant Name Plant State Water Body Type

Benefits

Region

flowdata 42 of 95
EIA Code ID Plant Name Plant State Water Body Type

Benefits

Region

flowdata 43 of 95
EIA Code ID Plant Name Plant State Water Body Type

Benefits

Region

flowdata 44 of 95
EIA Code ID Plant Name Plant State Water Body Type

Benefits

Region

flowdata 45 of 95
EIA Code ID Plant Name Plant State Water Body Type

Benefits

Region

flowdata 46 of 95
EIA Code ID Plant Name Plant State Water Body Type

Benefits

Region

flowdata 47 of 95
EIA Code ID Plant Name Plant State Water Body Type

Benefits

Region

flowdata 48 of 95
EIA Code ID Plant Name Plant State Water Body Type

Benefits

Region

flowdata 49 of 95
EIA Code ID Plant Name Plant State Water Body Type

Benefits

Region

flowdata 50 of 95
EIA Code ID Plant Name Plant State Water Body Type

Benefits

Region

flowdata 51 of 95
EIA Code ID Plant Name Plant State Water Body Type

Benefits

Region

flowdata 52 of 95
EIA Code ID Plant Name Plant State Water Body Type

Benefits

Region

flowdata 53 of 95
EIA Code ID

Design Capacity

(GPD) AverageFlow

flowdata 54 of 95
EIA Code ID

Design Capacity

(GPD) AverageFlow

flowdata 55 of 95
EIA Code ID

Design Capacity

(GPD) AverageFlow

flowdata 56 of 95
EIA Code ID

Design Capacity

(GPD) AverageFlow

flowdata 57 of 95
EIA Code ID

Design Capacity

(GPD) AverageFlow

flowdata 58 of 95
EIA Code ID

Design Capacity

(GPD) AverageFlow

flowdata 59 of 95
EIA Code ID

Design Capacity

(GPD) AverageFlow

flowdata 60 of 95
EIA Code ID

Design Capacity

(GPD) AverageFlow

flowdata 61 of 95
EIA Code ID

Design Capacity

(GPD) AverageFlow

flowdata 62 of 95
EIA Code ID

Design Capacity

(GPD) AverageFlow

flowdata 63 of 95
EIA Code ID

Design Capacity

(GPD) AverageFlow

flowdata 64 of 95
EIA Code ID

Design Capacity

(GPD) AverageFlow

flowdata 65 of 95
EIA Code ID

Design Capacity

(GPD) AverageFlow

flowdata 66 of 95
EIA Code ID

Design Capacity

(GPD) AverageFlow

flowdata 67 of 95
EIA Code ID

Design Capacity

(GPD) AverageFlow

flowdata 68 of 95
EIA Code ID

Design Capacity

(GPD) AverageFlow

flowdata 69 of 95
option rpschd_1 rpschd_2 rpschd_3 rpschd_4 rpschd_5 rpschd_6 rpschd_7 rpschd_8

baseline 0 0 0 0 0 0 0 0

tmn1 0 0.02272727 0.04545455 0.06818182 0.09090909 0.11363636 0.13636364 0.15909091

tmn2 0 0.02272727 0.04545455 0.06818182 0.09090909 0.11363636 0.13636364 0.15909091

tmn3 0 0 0 0 0 0 0 0

tmn4 0 0 0 0 0 0 0 0

baseline_0 0 0 0 0 0 0 0 0

tmn1_0 0 0.02272727 0.04545455 0.06818182 0.09090909 0.11363636 0.13636364 0.15909091

tmn2_0 0 0.02272727 0.04545455 0.06818182 0.09090909 0.11363636 0.13636364 0.15909091

tmn3_0 0 0 0 0 0 0 0 0

tmn4_0 0 0 0 0 0 0 0 0

rpschd 70 of 95
option

baseline

tmn1

tmn2

tmn3

tmn4

baseline_0

tmn1_0

tmn2_0

tmn3_0

tmn4_0

rpschd_9 rpschd_10 rpschd_11 rpschd_12 rpschd_13 rpschd_14 rpschd_15 rpschd_16

0 0 0 0 0 0 0 0

0.18181818 0.20454545 0.22727273 0.25 0.27272727 0.29545455 0.31818182 0.34090909

0.18181818 0.20454545 0.22727273 0.25 0.27272727 0.29545455 0.31818182 0.34090909

0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0

0.18181818 0.20454545 0.22727273 0.25 0.27272727 0.29545455 0.31818182 0.34090909

0.18181818 0.20454545 0.22727273 0.25 0.27272727 0.29545455 0.31818182 0.34090909

0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0

rpschd 71 of 95
option

baseline

tmn1

tmn2

tmn3

tmn4

baseline_0

tmn1_0

tmn2_0

tmn3_0

tmn4_0

rpschd_17 rpschd_18 rpschd_19 rpschd_20 rpschd_21 rpschd_22 rpschd_23 rpschd_24

0 0 0 0 0 0 0 0

0.36363636 0.38636364 0.40909091 0.43181818 0.45454545 0.47727273 0.5 0.52272727

0.36363636 0.38636364 0.40909091 0.43181818 0.45454545 0.47727273 0.5 0.52272727

0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0

0.36363636 0.38636364 0.40909091 0.43181818 0.45454545 0.47727273 0.5 0.52272727

0.36363636 0.38636364 0.40909091 0.43181818 0.45454545 0.47727273 0.5 0.52272727

0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0

rpschd 72 of 95
option

baseline

tmn1

tmn2

tmn3

tmn4

baseline_0

tmn1_0

tmn2_0

tmn3_0

tmn4_0

rpschd_25 rpschd_26 rpschd_27 rpschd_28 rpschd_29 rpschd_30 rpschd_31 rpschd_32

0 0 0 0 0 0 0 0

0.54545455 0.56818182 0.59090909 0.61363636 0.63636364 0.65909091 0.68181818 0.70454545

0.54545455 0.56818182 0.59090909 0.61363636 0.63636364 0.65909091 0.68181818 0.70454545

0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0

0.54545455 0.56818182 0.59090909 0.61363636 0.63636364 0.65909091 0.68181818 0.70454545

0.54545455 0.56818182 0.59090909 0.61363636 0.63636364 0.65909091 0.68181818 0.70454545

0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0

rpschd 73 of 95
option

baseline

tmn1

tmn2

tmn3

tmn4

baseline_0

tmn1_0

tmn2_0

tmn3_0

tmn4_0

rpschd_33 rpschd_34 rpschd_35 rpschd_36 rpschd_37 rpschd_38 rpschd_39 rpschd_40

0 0 0 0 0 0 0 0

0.72727273 0.75 0.77272727 0.79545455 0.81818182 0.84090909 0.86363636 0.88636364

0.72727273 0.75 0.77272727 0.79545455 0.81818182 0.84090909 0.86363636 0.88636364

0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0

0.72727273 0.75 0.77272727 0.79545455 0.81818182 0.84090909 0.86363636 0.88636364

0.72727273 0.75 0.77272727 0.79545455 0.81818182 0.84090909 0.86363636 0.88636364

0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0

rpschd 74 of 95
option

baseline

tmn1

tmn2

tmn3

tmn4

baseline_0

tmn1_0

tmn2_0

tmn3_0

tmn4_0

rpschd_41 rpschd_42 rpschd_43 rpschd_44 rpschd_45 rpschd_46 rpschd_47 rpschd_48

0 0 0 0 0 0 0 0

0.90909091 0.93181818 0.95454545 0.97727273 1 0.83 0.67 0.5

0.90909091 0.93181818 0.95454545 0.97727273 1 0.83 0.67 0.5

0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0

0.90909091 0.93181818 0.95454545 0.97727273 1 0.83 0.67 0.5

0.90909091 0.93181818 0.95454545 0.97727273 1 0.83 0.67 0.5

0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0

rpschd 75 of 95
option

baseline

tmn1

tmn2

tmn3

tmn4

baseline_0

tmn1_0

tmn2_0

tmn3_0

tmn4_0

rpschd_49 rpschd_50 rpschd_51 rpschd_52 rpschd_53 rpschd_54 rpschd_55 rpschd_56

0 0 0 0 0 0 0 0

0.33 0.17 0 0 0 0 0 0

0.33 0.17 0 0 0 0 0 0

0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0

0.33 0.17 0 0 0 0 0 0

0.33 0.17 0 0 0 0 0 0

0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0

rpschd 76 of 95
option

baseline

tmn1

tmn2

tmn3

tmn4

baseline_0

tmn1_0

tmn2_0

tmn3_0

tmn4_0

rpschd_57 rpschd_58 rpschd_59 rpschd_60

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

rpschd 77 of 95
ID PS_wgt marker

ID_AND_WEIGHT 78 of 95
ID PS_wgt marker

ID_AND_WEIGHT 79 of 95
ID PS_wgt marker

ID_AND_WEIGHT 80 of 95
ID PS_wgt marker

ID_AND_WEIGHT 81 of 95
ID PS_wgt marker

ID_AND_WEIGHT 82 of 95
ID PS_wgt marker

ID_AND_WEIGHT 83 of 95
ID PS_wgt marker

ID_AND_WEIGHT 84 of 95
ID PS_wgt marker

ID_AND_WEIGHT 85 of 95
ID PS_wgt marker

ID_AND_WEIGHT 86 of 95
ID PS_wgt marker

ID_AND_WEIGHT 87 of 95
ID PS_wgt marker

ID_AND_WEIGHT 88 of 95
ID PS_wgt marker

ID_AND_WEIGHT 89 of 95
ID PS_wgt marker

ID_AND_WEIGHT 90 of 95
ID PS_wgt marker

ID_AND_WEIGHT 91 of 95
ID PS_wgt marker

ID_AND_WEIGHT 92 of 95
ID PS_wgt marker

ID_AND_WEIGHT 93 of 95
ID PS_wgt marker

ID_AND_WEIGHT 94 of 95
ID PS_wgt marker

ID_AND_WEIGHT 95 of 95