## Author: Abt Associates Inc.

Date Created: 9/22/2010 Date Modified: 3/30/2011 Purpose: This file contains plant-level informatio used to generate DQ sample weights for 316(b) Electric Generators (2+ MGD; 125 DIF

Breakdow

n; NERC; IPM2010). This information in read into the Cost PS Data. 09.22.10_v1.sas SAS program. (CBI)

File Contents: Worksheet Contents DataForWeights Compiles facility-level data required to generate sample weights; assigns facilities to an appropriate "survey bucket". NoNERC_Wts Generates weights without taking into account NERC regions. 10+MGD_Formulas Reads in data from the DataForWeights worksheet for facilities with DIF>10MGD. 2to10MGD_FormulasReads in data from the DataForWeights worksheet for facilities with DIF of 2-10MGD. SASIN_All Compiles information to be read into SAS.

Input Files: External data used in calculations/analysis: PlantData.xls CostData_ForWeights_09.22.10.xls (not linked)

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.

FileInfo 1 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group

SASIN_All 2 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group

SASIN_All 3 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group

SASIN_All 4 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group

SASIN_All 5 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group

SASIN_All 6 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group

SASIN_All 7 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group

SASIN_All 8 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group

SASIN_All 9 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group

SASIN_All 10 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group

SASIN_All 11 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group

SASIN_All 12 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group

SASIN_All 13 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group

SASIN_All 14 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group

SASIN_All 15 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group

SASIN_All 16 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group group_dq

10+_Formulas 17 of 89

### mplid c_wtd f_wtd

10+_Formulas 18 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group group_dq

10+_Formulas 19 of 89

### mplid c_wtd f_wtd

10+_Formulas 20 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group group_dq

10+_Formulas 21 of 89

### mplid c_wtd f_wtd

10+_Formulas 22 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group group_dq

10+_Formulas 23 of 89

### mplid c_wtd f_wtd

10+_Formulas 24 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group group_dq

10+_Formulas 25 of 89

### mplid c_wtd f_wtd

10+_Formulas 26 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group group_dq

10+_Formulas 27 of 89

### mplid c_wtd f_wtd

10+_Formulas 28 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group group_dq

10+_Formulas 29 of 89

### mplid c_wtd f_wtd

10+_Formulas 30 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group group_dq

10+_Formulas 31 of 89

### mplid c_wtd f_wtd

10+_Formulas 32 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group group_dq

10+_Formulas 33 of 89

### mplid c_wtd f_wtd

10+_Formulas 34 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group group_dq

10+_Formulas 35 of 89

### mplid c_wtd f_wtd

10+_Formulas 36 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group group_dq

10+_Formulas 37 of 89

### mplid c_wtd f_wtd

10+_Formulas 38 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group group_dq

10+_Formulas 39 of 89

### mplid c_wtd f_wtd

10+_Formulas 40 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group group_dq

10+_Formulas 41 of 89

### mplid c_wtd f_wtd

10+_Formulas 42 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group group_dq

10+_Formulas 43 of 89

### mplid c_wtd f_wtd

10+_Formulas 44 of 89

### mplid nerc type cap f wgt dqf recirc difcat clospred baseclos anzd group group_dq

2to10_Formulas 45 of 89

### mplid c_wtd f_wtd ct cap_wtd f_wtd

2to10_Formulas 46 of 89

### BL Rec, High Vel - IM Only, No CT 2

1 2 3 4 Facility Count Capacity DIF Actual 16 2,643 70 Old Weighted 17 2,756 74 DQ-UnWeighted 6 1,336 29 Old Factor 1.0712 1.0428 1.0593 DQ-Factor 2.8566 2.0640 2.5539

BL Rec; High Velocity 3 1 2 3 4 Facility Count Capacity DIF Actual 52 73,306 4,829 Old Weighted 53 74,070 4,886 DQ-UnWeighted 19 29,412 2,624 Old Factor 1.0195 1.0104 1.0118 DQ-Factor 2.7902 2.5184 1.8620

No BL Rec; Low Velocity; No IM and No CT 4 1 2 3 4 Facility Count Capacity DIF Actual 19 6,933 1,184 Old Weighted 20 7,431 1,251 DQ-UnWeighted 8 1,138 424 Old Factor 1.0560 1.0719 1.0563 DQ-Factor 2.5081 6.5277 2.9521

No BL Rec; High Velocity; IM Only and No CT 5 1 2 3 4 Facility Count Capacity DIF Actual 62 18,991 4,591 Old Weighted 65 19,186 4,756 DQ-UnWeighted 37 11,915 2,646 Old Factor 1.0405 1.0103 1.0361 DQ-Factor 1.7435 1.6102 1.7978

No BL Rec, High Vel - IM Only, No CT (or IM & CT) 6 1 2 3 4 Facility Count Capacity DIF Actual 342 328,321 290,990 Old Weighted 348 333,404 295,707 DQ-UnWeighted131 140,600 104,384 Old Factor 1.0180 1.0155 1.0162 DQ-Factor 2.6577 2.3713 2.8329

No BL Rec, Low Vel - No IM, No CT (or No IM , CT Only ) 7 1 2 3 4 Facility Count Capacity DIF Actual 35 37,027 24,502 Old Weighted 35 37,428 24,762 DQ-UnWeighted 22 26,471 18,528 Old Factor 1.0128 1.0108 1.0106 DQ-Factor 1.6113 1.4139 1.3365

NoNERC_Wts 47 of 891 2 3 4 5 6 7 8 9 10 11 12 13 From ERCOT to SERC from ERCOT to MRO From SPP to FRCC from RFC to NPCC from SPP to WECC from RFC to NPCC X from SPP to NPCC from FRCC to SERC X X from ASCC to WECC from FRCC to SPP X X from SPP to SERC from NPCC to MRO X

Plant Code Facility Name PhaseSurvey ID Survey Plant Type 2007 EIA Steam Cap Survey DIF

(MGD) Old DQ-STQ

Weights DQ? NERC Rec In Baseline? Intak

e Category

DataForWeights 48 of 891

Plant Code 14 15 16 17 18 19 20 21 22 23 Group 1 2 260 STQ 16 10 198 DQ 23 6 458 565 39 16

565 2+ MGD 2-10 MGD

IM OnlyBL Rec, Low Vel -

No Tech BL Rec, High Vel -

IM Assigned

CTs for DIF>125MGdBL Rec, Low Vel - No Tech BL Rec, High Vel -

IM Assigned, no CT Predicted Closure IPM-Based Baseline

Closure (yes = 1) 125 MGD CT? (yes=1)High Intak e Vel? (yes=1) IM

Assigned? All IM

Assigned? CT

Assigned? All CT

Assigned? Analyzed? BL Rec, Low Vel - No Tech BL Rec, High Vel -

IM Assigned, no CT

DataForWeights 49 of 891

Plant Code 25 26 27 28 29 30 31 32 33

3 4 5 6 7 33 11 25 211 13 19 8 37 131 22 52 19 62 342 35

10+ MGD <=125 MGD <=125 MGD >125 MGD >125 MGD BL Rec, High Vel - IM Assigned No BL Rec, Low Vel - No IM No BL Rec, High Vel -

IM Assigned No BL Rec, High Vel - IM Assigned No BL Rec, Low Vel - No IM BL Rec, High Vel - IM Assigned, no CTNo BL Rec, Low Vel - No IM No BL Rec, High Vel -

IM Assigned No BL Rec, High Vel - CT Assigned No BL Rec, Low Vel -

CT Assigned BL Rec, High Vel - IM Assigned, no CTNo BL Rec, Low Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, Low Vel -

CT Assigned Group Facility CountBased CapacityBased DIF-Based 125 MGD Case Final Weights

DataForWeights 50 of 89Plant

Code Facility Name PhaseSurvey ID Survey Plant Type 2007 EIA Steam Cap Survey DIF

(MGD) Old DQ-STQ

Weights DQ? NERC Rec In Baseline? Intak

e Category

DataForWeights 51 of 89Plant

CodePredicted Closure IPM-Based Baseline

Closure (yes = 1) 125 MGD CT? (yes=1)High Intak e Vel? (yes=1) IM

Assigned? All IM

Assigned? CT

Assigned? All CT

Assigned? Analyzed? BL Rec, Low Vel - No Tech BL Rec, High Vel -

IM Assigned, no CT

DataForWeights 52 of 89Plant

Code BL Rec, High Vel - IM Assigned, no CTNo BL Rec, Low Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, Low Vel -

CT Assigned Group Facility CountBased CapacityBased DIF-Based

DataForWeights 53 of 89Plant

Code Facility Name PhaseSurvey ID Survey Plant Type 2007 EIA Steam Cap Survey DIF

(MGD) Old DQ-STQ

Weights DQ? NERC Rec In Baseline? Intak

e Category

DataForWeights 54 of 89Plant

CodePredicted Closure IPM-Based Baseline

Closure (yes = 1) 125 MGD CT? (yes=1)High Intak e Vel? (yes=1) IM

Assigned? All IM

Assigned? CT

Assigned? All CT

Assigned? Analyzed? BL Rec, Low Vel - No Tech BL Rec, High Vel -

IM Assigned, no CT

DataForWeights 55 of 89Plant

Code BL Rec, High Vel - IM Assigned, no CTNo BL Rec, Low Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, Low Vel -

CT Assigned Group Facility CountBased CapacityBased DIF-Based

DataForWeights 56 of 89Plant

Code Facility Name PhaseSurvey ID Survey Plant Type 2007 EIA Steam Cap Survey DIF

(MGD) Old DQ-STQ

Weights DQ? NERC Rec In Baseline? Intak

e Category

DataForWeights 57 of 89Plant

CodePredicted Closure IPM-Based Baseline

Closure (yes = 1) 125 MGD CT? (yes=1)High Intak e Vel? (yes=1) IM

Assigned? All IM

Assigned? CT

Assigned? All CT

Assigned? Analyzed? BL Rec, Low Vel - No Tech BL Rec, High Vel -

IM Assigned, no CT

DataForWeights 58 of 89Plant

Code BL Rec, High Vel - IM Assigned, no CTNo BL Rec, Low Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, Low Vel -

CT Assigned Group Facility CountBased CapacityBased DIF-Based

DataForWeights 59 of 89Plant

Code Facility Name PhaseSurvey ID Survey Plant Type 2007 EIA Steam Cap Survey DIF

(MGD) Old DQ-STQ

Weights DQ? NERC Rec In Baseline? Intak

e Category

DataForWeights 60 of 89Plant

CodePredicted Closure IPM-Based Baseline

Closure (yes = 1) 125 MGD CT? (yes=1)High Intak e Vel? (yes=1) IM

Assigned? All IM

Assigned? CT

Assigned? All CT

Assigned? Analyzed? BL Rec, Low Vel - No Tech BL Rec, High Vel -

IM Assigned, no CT

DataForWeights 61 of 89Plant

Code BL Rec, High Vel - IM Assigned, no CTNo BL Rec, Low Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, Low Vel -

CT Assigned Group Facility CountBased CapacityBased DIF-Based

DataForWeights 62 of 89Plant

Code Facility Name PhaseSurvey ID Survey Plant Type 2007 EIA Steam Cap Survey DIF

(MGD) Old DQ-STQ

Weights DQ? NERC Rec In Baseline? Intak

e Category

DataForWeights 63 of 89Plant

CodePredicted Closure IPM-Based Baseline

Closure (yes = 1) 125 MGD CT? (yes=1)High Intak e Vel? (yes=1) IM

Assigned? All IM

Assigned? CT

Assigned? All CT

Assigned? Analyzed? BL Rec, Low Vel - No Tech BL Rec, High Vel -

IM Assigned, no CT

DataForWeights 64 of 89Plant

Code BL Rec, High Vel - IM Assigned, no CTNo BL Rec, Low Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, Low Vel -

CT Assigned Group Facility CountBased CapacityBased DIF-Based

DataForWeights 65 of 89Plant

Code Facility Name PhaseSurvey ID Survey Plant Type 2007 EIA Steam Cap Survey DIF

(MGD) Old DQ-STQ

Weights DQ? NERC Rec In Baseline? Intak

e Category

DataForWeights 66 of 89Plant

CodePredicted Closure IPM-Based Baseline

Closure (yes = 1) 125 MGD CT? (yes=1)High Intak e Vel? (yes=1) IM

Assigned? All IM

Assigned? CT

Assigned? All CT

Assigned? Analyzed? BL Rec, Low Vel - No Tech BL Rec, High Vel -

IM Assigned, no CT

DataForWeights 67 of 89Plant

Code BL Rec, High Vel - IM Assigned, no CTNo BL Rec, Low Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, Low Vel -

CT Assigned Group Facility CountBased CapacityBased DIF-Based

DataForWeights 68 of 89Plant

Code Facility Name PhaseSurvey ID Survey Plant Type 2007 EIA Steam Cap Survey DIF

(MGD) Old DQ-STQ

Weights DQ? NERC Rec In Baseline? Intak

e Category

DataForWeights 69 of 89Plant

CodePredicted Closure IPM-Based Baseline

Closure (yes = 1) 125 MGD CT? (yes=1)High Intak e Vel? (yes=1) IM

Assigned? All IM

Assigned? CT

Assigned? All CT

Assigned? Analyzed? BL Rec, Low Vel - No Tech BL Rec, High Vel -

IM Assigned, no CT

DataForWeights 70 of 89Plant

Code BL Rec, High Vel - IM Assigned, no CTNo BL Rec, Low Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, Low Vel -

CT Assigned Group Facility CountBased CapacityBased DIF-Based

DataForWeights 71 of 89Plant

Code Facility Name PhaseSurvey ID Survey Plant Type 2007 EIA Steam Cap Survey DIF

(MGD) Old DQ-STQ

Weights DQ? NERC Rec In Baseline? Intak

e Category

DataForWeights 72 of 89Plant

CodePredicted Closure IPM-Based Baseline

Closure (yes = 1) 125 MGD CT? (yes=1)High Intak e Vel? (yes=1) IM

Assigned? All IM

Assigned? CT

Assigned? All CT

Assigned? Analyzed? BL Rec, Low Vel - No Tech BL Rec, High Vel -

IM Assigned, no CT

DataForWeights 73 of 89Plant

Code BL Rec, High Vel - IM Assigned, no CTNo BL Rec, Low Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, Low Vel -

CT Assigned Group Facility CountBased CapacityBased DIF-Based

DataForWeights 74 of 89Plant

Code Facility Name PhaseSurvey ID Survey Plant Type 2007 EIA Steam Cap Survey DIF

(MGD) Old DQ-STQ

Weights DQ? NERC Rec In Baseline? Intak

e Category

DataForWeights 75 of 89Plant

CodePredicted Closure IPM-Based Baseline

Closure (yes = 1) 125 MGD CT? (yes=1)High Intak e Vel? (yes=1) IM

Assigned? All IM

Assigned? CT

Assigned? All CT

Assigned? Analyzed? BL Rec, Low Vel - No Tech BL Rec, High Vel -

IM Assigned, no CT

DataForWeights 76 of 89Plant

Code BL Rec, High Vel - IM Assigned, no CTNo BL Rec, Low Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, Low Vel -

CT Assigned Group Facility CountBased CapacityBased DIF-Based

DataForWeights 77 of 89Plant

Code Facility Name PhaseSurvey ID Survey Plant Type 2007 EIA Steam Cap Survey DIF

(MGD) Old DQ-STQ

Weights DQ? NERC Rec In Baseline? Intak

e Category

DataForWeights 78 of 89Plant

CodePredicted Closure IPM-Based Baseline

Closure (yes = 1) 125 MGD CT? (yes=1)High Intak e Vel? (yes=1) IM

Assigned? All IM

Assigned? CT

Assigned? All CT

Assigned? Analyzed? BL Rec, Low Vel - No Tech BL Rec, High Vel -

IM Assigned, no CT

DataForWeights 79 of 89Plant

Code BL Rec, High Vel - IM Assigned, no CTNo BL Rec, Low Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, Low Vel -

CT Assigned Group Facility CountBased CapacityBased DIF-Based

DataForWeights 80 of 89Plant

Code Facility Name PhaseSurvey ID Survey Plant Type 2007 EIA Steam Cap Survey DIF

(MGD) Old DQ-STQ

Weights DQ? NERC Rec In Baseline? Intak

e Category

DataForWeights 81 of 89Plant

CodePredicted Closure IPM-Based Baseline

Closure (yes = 1) 125 MGD CT? (yes=1)High Intak e Vel? (yes=1) IM

Assigned? All IM

Assigned? CT

Assigned? All CT

Assigned? Analyzed? BL Rec, Low Vel - No Tech BL Rec, High Vel -

IM Assigned, no CT

DataForWeights 82 of 89Plant

Code BL Rec, High Vel - IM Assigned, no CTNo BL Rec, Low Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, Low Vel -

CT Assigned Group Facility CountBased CapacityBased DIF-Based

DataForWeights 83 of 89Plant

Code Facility Name PhaseSurvey ID Survey Plant Type 2007 EIA Steam Cap Survey DIF

(MGD) Old DQ-STQ

Weights DQ? NERC Rec In Baseline? Intak

e Category

DataForWeights 84 of 89Plant

CodePredicted Closure IPM-Based Baseline

Closure (yes = 1) 125 MGD CT? (yes=1)High Intak e Vel? (yes=1) IM

Assigned? All IM

Assigned? CT

Assigned? All CT

Assigned? Analyzed? BL Rec, Low Vel - No Tech BL Rec, High Vel -

IM Assigned, no CT

DataForWeights 85 of 89Plant

Code BL Rec, High Vel - IM Assigned, no CTNo BL Rec, Low Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, Low Vel -

CT Assigned Group Facility CountBased CapacityBased DIF-Based

DataForWeights 86 of 89Plant

Code Facility Name PhaseSurvey ID Survey Plant Type 2007 EIA Steam Cap Survey DIF

(MGD) Old DQ-STQ

Weights DQ? NERC Rec In Baseline? Intak

e Category

DataForWeights 87 of 89Plant

CodePredicted Closure IPM-Based Baseline

Closure (yes = 1) 125 MGD CT? (yes=1)High Intak e Vel? (yes=1) IM

Assigned? All IM

Assigned? CT

Assigned? All CT

Assigned? Analyzed? BL Rec, Low Vel - No Tech BL Rec, High Vel -

IM Assigned, no CT

DataForWeights 88 of 89Plant

Code BL Rec, High Vel - IM Assigned, no CTNo BL Rec, Low Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, High Vel - CT Assigned No BL Rec, Low Vel -

CT Assigned Group Facility CountBased CapacityBased DIF-Based

DataForWeights 89 of 89