Weights for I&E model 03.21.11.xls

Author: Abt Associates Inc.

Created: 3/21/11

Worksheet Description

Weights 03.21.11 facility weights used in the benefits analysis

closures baseline closures

> 50 MGD DIF list of facilities with greater than 50 MGD DIF

Purpose: Lists facility weights used in the benefits analysis.

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 40
Survey ID Facility Type Weight

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Weights 03.21.11 2 of 40
Survey ID Facility Type Weight

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Weights 03.21.11 3 of 40
Survey ID Facility Type Weight

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Weights 03.21.11 4 of 40
Survey ID Facility Type Weight

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Weights 03.21.11 5 of 40
Survey ID Facility Type Weight

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Weights 03.21.11 6 of 40
Survey ID Facility Type Weight

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Weights 03.21.11 7 of 40
Survey ID Facility Type Weight

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Weights 03.21.11 8 of 40
Survey ID Facility Type Weight

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

1.06

2.61

1.06

4.48

0.00

4.48

0.00

0.00

0.00

2.61

1.06

4.48

1.06

0.00

4.48

4.48

2.61

4.48

1.06

4.48

3.22

2.61

3.18

0.00

3.22

1.00

1.06

2.61

2.61

0.00

2.61

2.61

0.00

4.48

2.75

0.00

Weights 03.21.11 9 of 40
Survey ID Facility Type Weight

2.61

4.48

2.61

1.06

4.48

3.22

2.61

2.61

1.06

2.61

2.61

1.06

4.48

2.61

4.48

2.61

1.06

4.48

0.00

1.00

1.69

3.22

0.00

2.61

9.19

2.61

2.61

2.61

4.48

2.61

1.06

2.61

3.18

4.48

2.61

0.00

1.00

0.00

2.61

4.48

0.00

1.06

4.48

0.00

2.61

1.06

3.18

2.61

4.48

1.00

1.06

Weights 03.21.11 10 of 40
Survey ID Facility Type Weight

1.00

0.00

4.48

0.00

0.00

1.69

2.61

4.48

3.22

1.06

12.25

2.61

2.61

4.48

4.48

3.18

2.61

0.00

4.48

1.06

3.22

3.22

3.22

1.06

1.10

3.22

0.00

1.00

2.61

1.00

2.61

2.61

4.63

4.48

1.06

4.48

4.48

0.00

1.08

4.19

4.19

1.08

4.19

1.08

1.08

1.55

1.18

0.00

0.00

1.55

0.00

Weights 03.21.11 11 of 40
Survey ID Facility Type Weight

1.08

1.55

1.00

1.08

1.55

4.19

1.55

1.08

2.07

1.08

0.00

1.46

1.37

1.08

1.00

0.00

1.08

1.08

4.19

1.08

1.55

1.55

1.55

1.55

1.89

1.55

0.00

4.19

1.55

1.55

1.08

1.37

1.00

1.55

2.92

1.55

4.19

4.19

2.92

0.00

1.08

1.25

1.55

1.55

1.08

2.92

1.55

1.55

2.92

4.19

5.27

Weights 03.21.11 12 of 40
Survey ID Facility Type Weight

1.55

0.00

1.08

1.55

1.25

1.55

1.00

1.00

1.55

1.55

4.19

1.55

1.44

1.55

1.55

2.92

1.08

1.55

0.00

0.00

4.19

4.19

1.49

1.55

1.55

1.55

0.00

1.55

1.08

1.89

1.08

1.55

1.55

1.55

1.55

1.55

1.55

1.37

2.92

1.08

5.76

1.08

2.92

1.55

2.92

0.54

0.75

1.11

0.00

2.38

3.03

Weights 03.21.11 13 of 40
Survey ID Facility Type Weight

2.19

2.29

2.38

1.89

0.00

1.14

1.11

2.19

2.38

1.11

1.11

2.38

1.89

2.19

3.03

2.38

2.85

2.38

1.89

1.89

0.00

8.73

1.89

1.89

2.19

2.38

1.14

3.11

1.14

0.00

0.00

2.38

2.85

2.29

1.34

2.38

2.29

1.89

2.38

2.29

2.29

2.97

1.11

0.00

2.29

2.29

2.29

2.38

2.29

2.29

2.29

Weights 03.21.11 14 of 40
Survey ID Facility Type Weight

2.29

3.03

2.29

0.00

0.00

2.29

2.29

1.34

2.29

2.29

2.29

2.29

2.97

2.29

2.29

2.38

0.00

2.29

2.29

0.00

2.29

2.29

2.38

2.29

2.29

0.00

2.29

2.29

2.29

2.29

2.29

0.00

2.29

2.38

1.89

2.29

2.29

2.29

0.00

2.38

0.00

0.00

2.97

2.29

2.19

2.29

2.29

2.29

2.38

2.85

0.00

Weights 03.21.11 15 of 40
Survey ID Facility Type Weight

1.89

1.89

0.00

2.29

1.89

2.29

2.29

2.29

2.29

2.29

2.29

1.89

2.38

1.89

2.97

2.38

2.29

2.38

0.00

0.00

0.00

0.00

0.00

2.29

3.03

0.00

3.58

2.29

2.29

1.11

0.00

2.29

0.00

2.29

2.38

3.05

1.89

0.00

0.00

1.34

0.00

2.97

2.38

2.38

2.38

2.38

2.02

2.02

2.38

2.29

2.97

Weights 03.21.11 16 of 40
Survey ID Facility Type Weight

2.29

0.00

2.38

1.89

0.00

2.29

0.00

2.29

2.29

2.29

2.29

3.05

0.00

2.29

2.38

1.89

2.38

2.29

2.29

1.89

1.34

2.29

2.29

2.38

1.34

2.97

0.00

2.29

1.34

2.29

2.29

2.38

3.03

1.89

1.34

1.89

2.29

1.89

3.58

2.29

2.29

2.02

1.17

2.29

3.03

2.29

2.29

2.29

2.38

2.29

2.29

Weights 03.21.11 17 of 40
Survey ID Facility Type Weight

0.00

2.29

2.38

2.97

2.29

2.02

3.58

2.85

2.29

3.03

2.29

2.29

2.29

0.00

3.03

2.29

1.89

1.89

2.29

3.03

2.38

2.97

3.58

2.38

2.29

1.34

2.38

0.00

2.29

2.29

0.00

2.29

1.89

2.38

3.58

2.29

2.29

2.29

2.29

2.29

3.58

2.97

2.38

3.03

1.89

1.89

0.00

2.29

0.00

2.29

2.85

Weights 03.21.11 18 of 40
Survey ID Facility Type Weight

2.29

0.00

1.89

2.38

2.97

3.58

2.97

1.89

2.29

2.29

3.58

2.29

1.34

0.00

2.38

3.03

0.00

2.29

2.29

2.29

2.29

0.00

1.34

1.89

2.29

Weights 03.21.11 19 of 40
FACILITY ID DIF (MGD) > 50 MGD DIF

> 50 MGD DIF 20 of 40
FACILITY ID DIF (MGD) > 50 MGD DIF

> 50 MGD DIF 21 of 40
FACILITY ID DIF (MGD) > 50 MGD DIF

> 50 MGD DIF 22 of 40
FACILITY ID DIF (MGD) > 50 MGD DIF

> 50 MGD DIF 23 of 40
FACILITY ID DIF (MGD) > 50 MGD DIF

> 50 MGD DIF 24 of 40
FACILITY ID DIF (MGD) > 50 MGD DIF

> 50 MGD DIF 25 of 40
FACILITY ID DIF (MGD) > 50 MGD DIF

> 50 MGD DIF 26 of 40
FACILITY ID DIF (MGD) > 50 MGD DIF

> 50 MGD DIF 27 of 40
FACILITY ID DIF (MGD) > 50 MGD DIF

> 50 MGD DIF 28 of 40
FACILITY ID DIF (MGD) > 50 MGD DIF

> 50 MGD DIF 29 of 40
FACILITY ID DIF (MGD) > 50 MGD DIF

> 50 MGD DIF 30 of 40
FACILITY ID DIF (MGD) > 50 MGD DIF

> 50 MGD DIF 31 of 40
FACILITY ID DIF (MGD) > 50 MGD DIF

> 50 MGD DIF 32 of 40
FACILITY ID DIF (MGD) > 50 MGD DIF

> 50 MGD DIF 33 of 40
FACILITY ID DIF (MGD) > 50 MGD DIF

> 50 MGD DIF 34 of 40
FACILITY ID DIF (MGD) > 50 MGD DIF

> 50 MGD DIF 35 of 40
FACILITY ID DIF (MGD) > 50 MGD DIF

> 50 MGD DIF 36 of 40
FACILITY ID DIF (MGD) > 50 MGD DIF

> 50 MGD DIF 37 of 40
Survey ID Facility Type Baseline Exclusion

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

closures 38 of 40
Survey ID Facility Type Baseline Exclusion

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

closures 39 of 40
Survey ID Facility Type Baseline Exclusion

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

closures 40 of 40