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 95ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 2 of 95ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 3 of 95ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 4 of 95ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 5 of 95ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 6 of 95ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 7 of 95ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 8 of 95ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 9 of 95ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 10 of 95ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 11 of 95SURVEYIDPLNTCODEID

IDMAP 12 of 95SURVEYIDPLNTCODEID

IDMAP 13 of 95SURVEYIDPLNTCODEID

IDMAP 14 of 95SURVEYIDPLNTCODEID

IDMAP 15 of 95SURVEYIDPLNTCODEID

IDMAP 16 of 95SURVEYIDPLNTCODEID

IDMAP 17 of 95SURVEYIDPLNTCODEID

IDMAP 18 of 95SURVEYIDPLNTCODEID

IDMAP 19 of 95SURVEYIDPLNTCODEID

IDMAP 20 of 95SURVEYIDPLNTCODEID

IDMAP 21 of 95SURVEYIDPLNTCODEID

IDMAP 22 of 95SURVEYIDPLNTCODEID

IDMAP 23 of 95SURVEYIDPLNTCODEID

IDMAP 24 of 95SURVEYIDPLNTCODEID

IDMAP 25 of 95SURVEYIDPLNTCODEID

IDMAP 26 of 95SURVEYIDPLNTCODEID

IDMAP 27 of 95SURVEYIDPLNTCODEID

IDMAP 28 of 95SURVEYIDPLNTCODEID

IDMAP 29 of 95region species rest_id abv_prim_prodalg_prim_prodC_exporttc_dettc_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 95region 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_2ndtc_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 95region 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 95region species rest_id tot_WTP_HHfish_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 95state 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 95region stateAIF 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 95region stateAIF 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 95Yearoneis2009

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 95EIA Code ID Plant Name Plant State Water Body Type Benefits Region

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

flowdata 53 of 95EIA Code ID Design Capacity (GPD) AverageFlow

flowdata 54 of 95EIA Code ID Design Capacity (GPD) AverageFlow

flowdata 55 of 95EIA Code ID Design Capacity (GPD) AverageFlow

flowdata 56 of 95EIA Code ID Design Capacity (GPD) AverageFlow

flowdata 57 of 95EIA Code ID Design Capacity (GPD) AverageFlow

flowdata 58 of 95EIA Code ID Design Capacity (GPD) AverageFlow

flowdata 59 of 95EIA Code ID Design Capacity (GPD) AverageFlow

flowdata 60 of 95EIA Code ID Design Capacity (GPD) AverageFlow

flowdata 61 of 95EIA Code ID Design Capacity (GPD) AverageFlow

flowdata 62 of 95EIA Code ID Design Capacity (GPD) AverageFlow

flowdata 63 of 95EIA Code ID Design Capacity (GPD) AverageFlow

flowdata 64 of 95EIA Code ID Design Capacity (GPD) AverageFlow

flowdata 65 of 95EIA Code ID Design Capacity (GPD) AverageFlow

flowdata 66 of 95EIA Code ID Design Capacity (GPD) AverageFlow

flowdata 67 of 95EIA Code ID Design Capacity (GPD) AverageFlow

flowdata 68 of 95EIA Code ID Design Capacity (GPD) AverageFlow

flowdata 69 of 95option 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 95option

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 95option

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 95option

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 95option

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 95option

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 95option

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 95option

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 95ID PS_wgt marker

ID_AND_WEIGHT 78 of 95ID PS_wgt marker

ID_AND_WEIGHT 79 of 95ID PS_wgt marker

ID_AND_WEIGHT 80 of 95ID PS_wgt marker

ID_AND_WEIGHT 81 of 95ID PS_wgt marker

ID_AND_WEIGHT 82 of 95ID PS_wgt marker

ID_AND_WEIGHT 83 of 95ID PS_wgt marker

ID_AND_WEIGHT 84 of 95ID PS_wgt marker

ID_AND_WEIGHT 85 of 95ID PS_wgt marker

ID_AND_WEIGHT 86 of 95ID PS_wgt marker

ID_AND_WEIGHT 87 of 95ID PS_wgt marker

ID_AND_WEIGHT 88 of 95ID PS_wgt marker

ID_AND_WEIGHT 89 of 95ID PS_wgt marker

ID_AND_WEIGHT 90 of 95ID PS_wgt marker

ID_AND_WEIGHT 91 of 95ID PS_wgt marker

ID_AND_WEIGHT 92 of 95ID PS_wgt marker

ID_AND_WEIGHT 93 of 95ID PS_wgt marker

ID_AND_WEIGHT 94 of 95ID PS_wgt marker

ID_AND_WEIGHT 95 of 95