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 

Breakdown; 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_Formulas Reads 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

1234

Facility

Count Capacity DIF

Actual 16 2,643 70

Old Weighted 17 2,756 74

DQ-UnWeighted6 1,336 29

Old Factor 1.0712 1.0428 1.0593

DQ-Factor 2.8566 2.0640 2.5539

BL Rec; High Velocity3

1234

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-UnWeighted8 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-UnWeighted 131 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 89
1 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 Phase Survey ID Survey Plant Type

2007 EIA 

Steam Cap

Survey DIF 

(MGD)

Old DQ-STQ 

Weights DQ? NERC

Rec In 

Baseline?

Intake 

Category

DataForWeights 48 of 89
1

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 Only

BL Rec, Low Vel - 

No Tech

BL Rec, High Vel - 

IM Assigned

CTs for DIF>125MGd

BL 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 Intake 

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 89
1

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 CT

No 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 CT

No 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 CountBasedCapacityBased DIF-Based

125 MGD Case

Final Weights

DataForWeights 50 of 89
Plant 

Code Facility Name Phase Survey ID Survey Plant Type

2007 EIA 

Steam Cap

Survey DIF 

(MGD)

Old DQ-STQ 

Weights DQ? NERC

Rec In 

Baseline?

Intake 

Category

DataForWeights 51 of 89
Plant 

Code

Predicted 

Closure

IPM-Based Baseline 

Closure (yes = 1) 125 MGD CT? (yes=1)

High Intake 

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 89
Plant 

Code

BL Rec, High Vel - 

IM Assigned, no CT

No 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 CountBasedCapacityBased DIF-Based

DataForWeights 53 of 89
Plant 

Code Facility Name Phase Survey ID Survey Plant Type

2007 EIA 

Steam Cap

Survey DIF 

(MGD)

Old DQ-STQ 

Weights DQ? NERC

Rec In 

Baseline?

Intake 

Category

DataForWeights 54 of 89
Plant 

Code

Predicted 

Closure

IPM-Based Baseline 

Closure (yes = 1) 125 MGD CT? (yes=1)

High Intake 

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 89
Plant 

Code

BL Rec, High Vel - 

IM Assigned, no CT

No 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 CountBasedCapacityBased DIF-Based

DataForWeights 56 of 89
Plant 

Code Facility Name Phase Survey ID Survey Plant Type

2007 EIA 

Steam Cap

Survey DIF 

(MGD)

Old DQ-STQ 

Weights DQ? NERC

Rec In 

Baseline?

Intake 

Category

DataForWeights 57 of 89
Plant 

Code

Predicted 

Closure

IPM-Based Baseline 

Closure (yes = 1) 125 MGD CT? (yes=1)

High Intake 

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 89
Plant 

Code

BL Rec, High Vel - 

IM Assigned, no CT

No 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 CountBasedCapacityBased DIF-Based

DataForWeights 59 of 89
Plant 

Code Facility Name Phase Survey ID Survey Plant Type

2007 EIA 

Steam Cap

Survey DIF 

(MGD)

Old DQ-STQ 

Weights DQ? NERC

Rec In 

Baseline?

Intake 

Category

DataForWeights 60 of 89
Plant 

Code

Predicted 

Closure

IPM-Based Baseline 

Closure (yes = 1) 125 MGD CT? (yes=1)

High Intake 

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 89
Plant 

Code

BL Rec, High Vel - 

IM Assigned, no CT

No 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 CountBasedCapacityBased DIF-Based

DataForWeights 62 of 89
Plant 

Code Facility Name Phase Survey ID Survey Plant Type

2007 EIA 

Steam Cap

Survey DIF 

(MGD)

Old DQ-STQ 

Weights DQ? NERC

Rec In 

Baseline?

Intake 

Category

DataForWeights 63 of 89
Plant 

Code

Predicted 

Closure

IPM-Based Baseline 

Closure (yes = 1) 125 MGD CT? (yes=1)

High Intake 

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 89
Plant 

Code

BL Rec, High Vel - 

IM Assigned, no CT

No 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 CountBasedCapacityBased DIF-Based

DataForWeights 65 of 89
Plant 

Code Facility Name Phase Survey ID Survey Plant Type

2007 EIA 

Steam Cap

Survey DIF 

(MGD)

Old DQ-STQ 

Weights DQ? NERC

Rec In 

Baseline?

Intake 

Category

DataForWeights 66 of 89
Plant 

Code

Predicted 

Closure

IPM-Based Baseline 

Closure (yes = 1) 125 MGD CT? (yes=1)

High Intake 

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 89
Plant 

Code

BL Rec, High Vel - 

IM Assigned, no CT

No 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 CountBasedCapacityBased DIF-Based

DataForWeights 68 of 89
Plant 

Code Facility Name Phase Survey ID Survey Plant Type

2007 EIA 

Steam Cap

Survey DIF 

(MGD)

Old DQ-STQ 

Weights DQ? NERC

Rec In 

Baseline?

Intake 

Category

DataForWeights 69 of 89
Plant 

Code

Predicted 

Closure

IPM-Based Baseline 

Closure (yes = 1) 125 MGD CT? (yes=1)

High Intake 

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 89
Plant 

Code

BL Rec, High Vel - 

IM Assigned, no CT

No 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 CountBasedCapacityBased DIF-Based

DataForWeights 71 of 89
Plant 

Code Facility Name Phase Survey ID Survey Plant Type

2007 EIA 

Steam Cap

Survey DIF 

(MGD)

Old DQ-STQ 

Weights DQ? NERC

Rec In 

Baseline?

Intake 

Category

DataForWeights 72 of 89
Plant 

Code

Predicted 

Closure

IPM-Based Baseline 

Closure (yes = 1) 125 MGD CT? (yes=1)

High Intake 

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 89
Plant 

Code

BL Rec, High Vel - 

IM Assigned, no CT

No 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 CountBasedCapacityBased DIF-Based

DataForWeights 74 of 89
Plant 

Code Facility Name Phase Survey ID Survey Plant Type

2007 EIA 

Steam Cap

Survey DIF 

(MGD)

Old DQ-STQ 

Weights DQ? NERC

Rec In 

Baseline?

Intake 

Category

DataForWeights 75 of 89
Plant 

Code

Predicted 

Closure

IPM-Based Baseline 

Closure (yes = 1) 125 MGD CT? (yes=1)

High Intake 

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 89
Plant 

Code

BL Rec, High Vel - 

IM Assigned, no CT

No 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 CountBasedCapacityBased DIF-Based

DataForWeights 77 of 89
Plant 

Code Facility Name Phase Survey ID Survey Plant Type

2007 EIA 

Steam Cap

Survey DIF 

(MGD)

Old DQ-STQ 

Weights DQ? NERC

Rec In 

Baseline?

Intake 

Category

DataForWeights 78 of 89
Plant 

Code

Predicted 

Closure

IPM-Based Baseline 

Closure (yes = 1) 125 MGD CT? (yes=1)

High Intake 

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 89
Plant 

Code

BL Rec, High Vel - 

IM Assigned, no CT

No 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 CountBasedCapacityBased DIF-Based

DataForWeights 80 of 89
Plant 

Code Facility Name Phase Survey ID Survey Plant Type

2007 EIA 

Steam Cap

Survey DIF 

(MGD)

Old DQ-STQ 

Weights DQ? NERC

Rec In 

Baseline?

Intake 

Category

DataForWeights 81 of 89
Plant 

Code

Predicted 

Closure

IPM-Based Baseline 

Closure (yes = 1) 125 MGD CT? (yes=1)

High Intake 

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 89
Plant 

Code

BL Rec, High Vel - 

IM Assigned, no CT

No 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 CountBasedCapacityBased DIF-Based

DataForWeights 83 of 89
Plant 

Code Facility Name Phase Survey ID Survey Plant Type

2007 EIA 

Steam Cap

Survey DIF 

(MGD)

Old DQ-STQ 

Weights DQ? NERC

Rec In 

Baseline?

Intake 

Category

DataForWeights 84 of 89
Plant 

Code

Predicted 

Closure

IPM-Based Baseline 

Closure (yes = 1) 125 MGD CT? (yes=1)

High Intake 

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 89
Plant 

Code

BL Rec, High Vel - 

IM Assigned, no CT

No 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 CountBasedCapacityBased DIF-Based

DataForWeights 86 of 89
Plant 

Code Facility Name Phase Survey ID Survey Plant Type

2007 EIA 

Steam Cap

Survey DIF 

(MGD)

Old DQ-STQ 

Weights DQ? NERC

Rec In 

Baseline?

Intake 

Category

DataForWeights 87 of 89
Plant 

Code

Predicted 

Closure

IPM-Based Baseline 

Closure (yes = 1) 125 MGD CT? (yes=1)

High Intake 

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 89
Plant 

Code

BL Rec, High Vel - 

IM Assigned, no CT

No 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 CountBasedCapacityBased DIF-Based

DataForWeights 89 of 89