BT_STAR_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 abun_change Fish abundance input data facility_data Facility flow data HH_data_reg Regional household data for North Atlantic and Mid-Atlantic regions HH_data Household data for states in North Atlantic and Mid-Atlantic regions flow_data Regional distribution of flow flowdata Facility data 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 111

### ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 2 of 111

### ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 3 of 111

### ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 4 of 111

### ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 5 of 111

### ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 6 of 111

### ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 7 of 111

### ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 8 of 111

### ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 9 of 111

### ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 10 of 111

### ID PLNTCODE TMN1 TMN2 TMN3 TMN4

ComplianceYear 11 of 111SURVEYID PLNTCODE ID

IDMAP 12 of 111SURVEYID PLNTCODE ID

IDMAP 13 of 111SURVEYID PLNTCODE ID

IDMAP 14 of 111SURVEYID PLNTCODE ID

IDMAP 15 of 111SURVEYID PLNTCODE ID

IDMAP 16 of 111SURVEYID PLNTCODE ID

IDMAP 17 of 111SURVEYID PLNTCODE ID

IDMAP 18 of 111SURVEYID PLNTCODE ID

IDMAP 19 of 111SURVEYID PLNTCODE ID

IDMAP 20 of 111SURVEYID PLNTCODE ID

IDMAP 21 of 111SURVEYID PLNTCODE ID

IDMAP 22 of 111SURVEYID PLNTCODE ID

IDMAP 23 of 111SURVEYID PLNTCODE ID

IDMAP 24 of 111SURVEYID PLNTCODE ID

IDMAP 25 of 111SURVEYID PLNTCODE ID

IDMAP 26 of 111SURVEYID PLNTCODE ID

IDMAP 27 of 111SURVEYID PLNTCODE ID

IDMAP 28 of 111species_econ reg baseline tmn1 tmn2 tmn3 tmn4 WTPper NE_baseline NE_tmn1 NE_tmn2 NE_tmn3 NE_tmn4

winter.flounder northatlantic 6.44 0.02 5.26 5.51 0.02 0.7605085 6.56 0.03 5.37 5.63 0.03 winter.flounder midatlantic 0.12 0.01 0.11 0.12 0.01 0.7605085 6.56 0.03 5.37 5.63 0.03 winter.flounder northeast 6.56 0.03 5.37 5.63 0.03 0.7605085 6.56 0.03 5.37 5.63 0.03

abun_change 29 of 111SurveyID State Region DIF AIF

facility_data 30 of 111SurveyID State Region DIF AIF

facility_data 31 of 111SurveyID State Region DIF AIF

facility_data 32 of 111SurveyID State Region DIF AIF

facility_data 33 of 111SurveyID State Region DIF AIF

facility_data 34 of 111SurveyID State Region DIF AIF

facility_data 35 of 111SurveyID State Region DIF AIF

facility_data 36 of 111SurveyID State Region DIF AIF

facility_data 37 of 111SurveyID State Region DIF AIF

facility_data 38 of 111SurveyID State Region DIF AIF

facility_data 39 of 111SurveyID State Region DIF AIF

facility_data 40 of 111SurveyID State Region DIF AIF

facility_data 41 of 111SurveyID State Region DIF AIF

facility_data 42 of 111SurveyID State Region DIF AIF

facility_data 43 of 111SurveyID State Region DIF AIF

facility_data 44 of 111SurveyID State Region DIF AIF

facility_data 45 of 111SurveyID State Region DIF AIF

facility_data 46 of 111reg numHH

midatlantic 20,974,820 northatlantic 5,398,807 northeast 26,373,627

HH_data_reg 47 of 111statenumHH

AL 0 AR 0 AZ 0 CA 0 CO 0 CT 1,365,529 DC 0 DE 329,246 FL 0 GA 0 IA 0 ID 0 IL 0 IN 0 KS 0 KY 0 LA 0 MA 2,533,224 MD 2,138,174 ME 561,927 MI 0 MN 0 MO 0 MS 0 MT 0 NC 0 ND 0 NE 0 NH 518,506 NJ 3,186,057 NM 0 NV 0 NY 7,303,783 OH 0 OK 0 OR 0 PA 5,021,383 RI 419,621 SC 0 SD 0 TN 0 TX 0 UT 0 VA 2,996,176 VT 0 WA 0 WI 0 WV 0 WY 0

HH_data 48 of 111region 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 inland UT 41.48801 0.00 inland VA 1840.587 0.01 inland VT 323.4667 0.00 inland WA 246.2448 0.00

flow_data 49 of 111region state AIF frac_AIF

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 50 of 111EIA CodeID Plant Name Plant State Water Body Type

flowdata 51 of 111EIA CodeID Plant Name Plant State Water Body Type

flowdata 52 of 111EIA CodeID Plant Name Plant State Water Body Type

flowdata 53 of 111EIA CodeID Plant Name Plant State Water Body Type

flowdata 54 of 111EIA CodeID Plant Name Plant State Water Body Type

flowdata 55 of 111EIA CodeID Plant Name Plant State Water Body Type

flowdata 56 of 111EIA CodeID Plant Name Plant State Water Body Type

flowdata 57 of 111EIA CodeID Plant Name Plant State Water Body Type

flowdata 58 of 111EIA CodeID Plant Name Plant State Water Body Type

flowdata 59 of 111EIA CodeID Plant Name Plant State Water Body Type

flowdata 60 of 111EIA CodeID Plant Name Plant State Water Body Type

flowdata 61 of 111EIA CodeID Plant Name Plant State Water Body Type

flowdata 62 of 111EIA CodeID Plant Name Plant State Water Body Type

flowdata 63 of 111EIA CodeID Plant Name Plant State Water Body Type

flowdata 64 of 111EIA CodeID Plant Name Plant State Water Body Type

flowdata 65 of 111EIA CodeID Plant Name Plant State Water Body Type

flowdata 66 of 111EIA CodeID Plant Name Plant State Water Body Type

flowdata 67 of 111EIA CodeBenefits Region Design Capacity (GPD) AverageFlow

flowdata 68 of 111EIA CodeBenefits Region Design Capacity (GPD) AverageFlow

flowdata 69 of 111EIA CodeBenefits Region Design Capacity (GPD) AverageFlow

flowdata 70 of 111EIA CodeBenefits Region Design Capacity (GPD) AverageFlow

flowdata 71 of 111EIA CodeBenefits Region Design Capacity (GPD) AverageFlow

flowdata 72 of 111EIA CodeBenefits Region Design Capacity (GPD) AverageFlow

flowdata 73 of 111EIA CodeBenefits Region Design Capacity (GPD) AverageFlow

flowdata 74 of 111EIA CodeBenefits Region Design Capacity (GPD) AverageFlow

flowdata 75 of 111EIA CodeBenefits Region Design Capacity (GPD) AverageFlow

flowdata 76 of 111EIA CodeBenefits Region Design Capacity (GPD) AverageFlow

flowdata 77 of 111EIA CodeBenefits Region Design Capacity (GPD) AverageFlow

flowdata 78 of 111EIA CodeBenefits Region Design Capacity (GPD) AverageFlow

flowdata 79 of 111EIA CodeBenefits Region Design Capacity (GPD) AverageFlow

flowdata 80 of 111EIA CodeBenefits Region Design Capacity (GPD) AverageFlow

flowdata 81 of 111EIA CodeBenefits Region Design Capacity (GPD) AverageFlow

flowdata 82 of 111EIA CodeBenefits Region Design Capacity (GPD) AverageFlow

flowdata 83 of 111EIA CodeBenefits Region Design Capacity (GPD) AverageFlow

flowdata 84 of 111option rpschd_1 rpschd_2 rpschd_3 rpschd_4 rpschd_5 rpschd_6

baseline 0 0 0 0 0 0 tmn1 0 0.022727273 0.045454545 0.068181818 0.090909091 0.113636364 tmn2 0 0.022727273 0.045454545 0.068181818 0.090909091 0.113636364 tmn3 0 0 0 0 0 0 tmn4 0 0 0 0 0 0 baseline_0 0 0 0 0 0 0 tmn1_0 0 0.022727273 0.045454545 0.068181818 0.090909091 0.113636364 tmn2_0 0 0.022727273 0.045454545 0.068181818 0.090909091 0.113636364 tmn3_0 0 0 0 0 0 0 tmn4_0 0 0 0 0 0 0

rpschd 85 of 111option

baseline tmn1 tmn2 tmn3 tmn4 baseline_0 tmn1_0 tmn2_0 tmn3_0 tmn4_0 rpschd_7 rpschd_8 rpschd_9 rpschd_10 rpschd_11 rpschd_12 0 0 0 0 0 0 0.136363636 0.159090909 0.181818182 0.204545455 0.227272727 0.25 0.136363636 0.159090909 0.181818182 0.204545455 0.227272727 0.25

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.136363636 0.159090909 0.181818182 0.204545455 0.227272727 0.25 0.136363636 0.159090909 0.181818182 0.204545455 0.227272727 0.25

0 0 0 0 0 0 0 0 0 0 0 0

rpschd 86 of 111option

baseline tmn1 tmn2 tmn3 tmn4 baseline_0 tmn1_0 tmn2_0 tmn3_0 tmn4_0 rpschd_13 rpschd_14 rpschd_15 rpschd_16 rpschd_17 rpschd_18 0 0 0 0 0 0 0.272727273 0.295454545 0.318181818 0.340909091 0.363636364 0.386363636 0.272727273 0.295454545 0.318181818 0.340909091 0.363636364 0.386363636

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.272727273 0.295454545 0.318181818 0.340909091 0.363636364 0.386363636 0.272727273 0.295454545 0.318181818 0.340909091 0.363636364 0.386363636

0 0 0 0 0 0 0 0 0 0 0 0

rpschd 87 of 111option

baseline tmn1 tmn2 tmn3 tmn4 baseline_0 tmn1_0 tmn2_0 tmn3_0 tmn4_0 rpschd_19 rpschd_20 rpschd_21 rpschd_22 rpschd_23rpschd_24 0 0 0 0 0 0 0.409090909 0.431818182 0.454545455 0.477272727 0.5 0.522727273 0.409090909 0.431818182 0.454545455 0.477272727 0.5 0.522727273

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.409090909 0.431818182 0.454545455 0.477272727 0.5 0.522727273 0.409090909 0.431818182 0.454545455 0.477272727 0.5 0.522727273

0 0 0 0 0 0 0 0 0 0 0 0

rpschd 88 of 111option

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 0 0 0 0 0 0 0.545454545 0.568181818 0.590909091 0.613636364 0.636363636 0.659090909 0.545454545 0.568181818 0.590909091 0.613636364 0.636363636 0.659090909

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.545454545 0.568181818 0.590909091 0.613636364 0.636363636 0.659090909 0.545454545 0.568181818 0.590909091 0.613636364 0.636363636 0.659090909

0 0 0 0 0 0 0 0 0 0 0 0

rpschd 89 of 111option

baseline tmn1 tmn2 tmn3 tmn4 baseline_0 tmn1_0 tmn2_0 tmn3_0 tmn4_0 rpschd_31 rpschd_32 rpschd_33 rpschd_34rpschd_35 rpschd_36 0 0 0 0 0 0 0.681818182 0.704545455 0.727272727 0.75 0.772727273 0.795454545 0.681818182 0.704545455 0.727272727 0.75 0.772727273 0.795454545

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.681818182 0.704545455 0.727272727 0.75 0.772727273 0.795454545 0.681818182 0.704545455 0.727272727 0.75 0.772727273 0.795454545

0 0 0 0 0 0 0 0 0 0 0 0

rpschd 90 of 111option

baseline tmn1 tmn2 tmn3 tmn4 baseline_0 tmn1_0 tmn2_0 tmn3_0 tmn4_0 rpschd_37 rpschd_38 rpschd_39 rpschd_40 rpschd_41 rpschd_42 0 0 0 0 0 0 0.818181818 0.840909091 0.863636364 0.886363636 0.909090909 0.931818182 0.818181818 0.840909091 0.863636364 0.886363636 0.909090909 0.931818182

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.818181818 0.840909091 0.863636364 0.886363636 0.909090909 0.931818182 0.818181818 0.840909091 0.863636364 0.886363636 0.909090909 0.931818182

0 0 0 0 0 0 0 0 0 0 0 0

rpschd 91 of 111option

baseline tmn1 tmn2 tmn3 tmn4 baseline_0 tmn1_0 tmn2_0 tmn3_0 tmn4_0 rpschd_43 rpschd_44 rpschd_45rpschd_46rpschd_47rpschd_48rpschd_49 0 0 0 0 0 0 0 0.954545455 0.977272727 1 0.83 0.67 0.5 0.33 0.954545455 0.977272727 1 0.83 0.67 0.5 0.33

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.954545455 0.977272727 1 0.83 0.67 0.5 0.33 0.954545455 0.977272727 1 0.83 0.67 0.5 0.33

0 0 0 0 0 0 0 0 0 0 0 0 0 0

rpschd 92 of 111option

baseline tmn1 tmn2 tmn3 tmn4 baseline_0 tmn1_0 tmn2_0 tmn3_0 tmn4_0 rpschd_50rpschd_51 rpschd_52rpschd_53rpschd_54rpschd_55rpschd_56 0 0 0 0 0 0 0 0.17 0 0 0 0 0 0 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.17 0 0 0 0 0 0 0.17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

rpschd 93 of 111option

baseline tmn1 tmn2 tmn3 tmn4 baseline_0 tmn1_0 tmn2_0 tmn3_0 tmn4_0 rpschd_57rpschd_58rpschd_59rpschd_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 94 of 111ID PS_wgt marker

ID_AND_WEIGHT 95 of 111ID PS_wgt marker

ID_AND_WEIGHT 96 of 111ID PS_wgt marker

ID_AND_WEIGHT 97 of 111ID PS_wgt marker

ID_AND_WEIGHT 98 of 111ID PS_wgt marker

ID_AND_WEIGHT 99 of 111ID PS_wgt marker

ID_AND_WEIGHT 100 of 111ID PS_wgt marker

ID_AND_WEIGHT 101 of 111ID PS_wgt marker

ID_AND_WEIGHT 102 of 111ID PS_wgt marker

ID_AND_WEIGHT 103 of 111ID PS_wgt marker

ID_AND_WEIGHT 104 of 111ID PS_wgt marker

ID_AND_WEIGHT 105 of 111ID PS_wgt marker

ID_AND_WEIGHT 106 of 111ID PS_wgt marker

ID_AND_WEIGHT 107 of 111ID PS_wgt marker

ID_AND_WEIGHT 108 of 111ID PS_wgt marker

ID_AND_WEIGHT 109 of 111ID PS_wgt marker

ID_AND_WEIGHT 110 of 111ID PS_wgt marker

ID_AND_WEIGHT 111 of 111