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 111
SURVEYID PLNTCODE ID

IDMAP 12 of 111
SURVEYID PLNTCODE ID

IDMAP 13 of 111
SURVEYID PLNTCODE ID

IDMAP 14 of 111
SURVEYID PLNTCODE ID

IDMAP 15 of 111
SURVEYID PLNTCODE ID

IDMAP 16 of 111
SURVEYID PLNTCODE ID

IDMAP 17 of 111
SURVEYID PLNTCODE ID

IDMAP 18 of 111
SURVEYID PLNTCODE ID

IDMAP 19 of 111
SURVEYID PLNTCODE ID

IDMAP 20 of 111
SURVEYID PLNTCODE ID

IDMAP 21 of 111
SURVEYID PLNTCODE ID

IDMAP 22 of 111
SURVEYID PLNTCODE ID

IDMAP 23 of 111
SURVEYID PLNTCODE ID

IDMAP 24 of 111
SURVEYID PLNTCODE ID

IDMAP 25 of 111
SURVEYID PLNTCODE ID

IDMAP 26 of 111
SURVEYID PLNTCODE ID

IDMAP 27 of 111
SURVEYID PLNTCODE ID

IDMAP 28 of 111
species_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 111
SurveyID State Region DIF AIF

facility_data 30 of 111
SurveyID State Region DIF AIF

facility_data 31 of 111
SurveyID State Region DIF AIF

facility_data 32 of 111
SurveyID State Region DIF AIF

facility_data 33 of 111
SurveyID State Region DIF AIF

facility_data 34 of 111
SurveyID State Region DIF AIF

facility_data 35 of 111
SurveyID State Region DIF AIF

facility_data 36 of 111
SurveyID State Region DIF AIF

facility_data 37 of 111
SurveyID State Region DIF AIF

facility_data 38 of 111
SurveyID State Region DIF AIF

facility_data 39 of 111
SurveyID State Region DIF AIF

facility_data 40 of 111
SurveyID State Region DIF AIF

facility_data 41 of 111
SurveyID State Region DIF AIF

facility_data 42 of 111
SurveyID State Region DIF AIF

facility_data 43 of 111
SurveyID State Region DIF AIF

facility_data 44 of 111
SurveyID State Region DIF AIF

facility_data 45 of 111
SurveyID State Region DIF AIF

facility_data 46 of 111
reg numHH

midatlantic 20,974,820

northatlantic 5,398,807

northeast 26,373,627

HH_data_reg 47 of 111
state numHH

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 111
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

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 111
region 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 111
EIA Code ID Plant Name Plant State Water Body Type

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

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

flowdata 53 of 111
EIA Code ID Plant Name Plant State Water Body Type

flowdata 54 of 111
EIA Code ID Plant Name Plant State Water Body Type

flowdata 55 of 111
EIA Code ID Plant Name Plant State Water Body Type

flowdata 56 of 111
EIA Code ID Plant Name Plant State Water Body Type

flowdata 57 of 111
EIA Code ID Plant Name Plant State Water Body Type

flowdata 58 of 111
EIA Code ID Plant Name Plant State Water Body Type

flowdata 59 of 111
EIA Code ID Plant Name Plant State Water Body Type

flowdata 60 of 111
EIA Code ID Plant Name Plant State Water Body Type

flowdata 61 of 111
EIA Code ID Plant Name Plant State Water Body Type

flowdata 62 of 111
EIA Code ID Plant Name Plant State Water Body Type

flowdata 63 of 111
EIA Code ID Plant Name Plant State Water Body Type

flowdata 64 of 111
EIA Code ID Plant Name Plant State Water Body Type

flowdata 65 of 111
EIA Code ID Plant Name Plant State Water Body Type

flowdata 66 of 111
EIA Code ID Plant Name Plant State Water Body Type

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

flowdata 84 of 111
option 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 111
option

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

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

baseline

tmn1

tmn2

tmn3

tmn4

baseline_0

tmn1_0

tmn2_0

tmn3_0

tmn4_0

rpschd_19 rpschd_20 rpschd_21 rpschd_22 rpschd_23 rpschd_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 111
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

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

baseline

tmn1

tmn2

tmn3

tmn4

baseline_0

tmn1_0

tmn2_0

tmn3_0

tmn4_0

rpschd_31 rpschd_32 rpschd_33 rpschd_34 rpschd_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 111
option

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

baseline

tmn1

tmn2

tmn3

tmn4

baseline_0

tmn1_0

tmn2_0

tmn3_0

tmn4_0

rpschd_43 rpschd_44 rpschd_45 rpschd_46 rpschd_47 rpschd_48 rpschd_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 111
option

baseline

tmn1

tmn2

tmn3

tmn4

baseline_0

tmn1_0

tmn2_0

tmn3_0

tmn4_0

rpschd_50 rpschd_51 rpschd_52 rpschd_53 rpschd_54 rpschd_55 rpschd_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 111
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 94 of 111
ID PS_wgt marker

ID_AND_WEIGHT 95 of 111
ID PS_wgt marker

ID_AND_WEIGHT 96 of 111
ID PS_wgt marker

ID_AND_WEIGHT 97 of 111
ID PS_wgt marker

ID_AND_WEIGHT 98 of 111
ID PS_wgt marker

ID_AND_WEIGHT 99 of 111
ID PS_wgt marker

ID_AND_WEIGHT 100 of 111
ID PS_wgt marker

ID_AND_WEIGHT 101 of 111
ID PS_wgt marker

ID_AND_WEIGHT 102 of 111
ID PS_wgt marker

ID_AND_WEIGHT 103 of 111
ID PS_wgt marker

ID_AND_WEIGHT 104 of 111
ID PS_wgt marker

ID_AND_WEIGHT 105 of 111
ID PS_wgt marker

ID_AND_WEIGHT 106 of 111
ID PS_wgt marker

ID_AND_WEIGHT 107 of 111
ID PS_wgt marker

ID_AND_WEIGHT 108 of 111
ID PS_wgt marker

ID_AND_WEIGHT 109 of 111
ID PS_wgt marker

ID_AND_WEIGHT 110 of 111
ID PS_wgt marker

ID_AND_WEIGHT 111 of 111