A1E and Fish Saved Calcs_All Survey Regions_06.01.12.xlsx

Author: Abt Associates Inc.

Updated: 6/01/12

Worksheet Description

A1E Reductions

Presents reductions in A1E losses for the seven 316(b)

regions used within the Environmental and Economic

Benefits Analysis (EEBA).

Region Conversion

Presents state-level intake flow data used to calculate

reductions in A1E losses and percent fish saved for each

stated preference survey region.

Survey Region Estimates

Presents the resulting estimates of reductions in A1E

Losses and percent fish saved for each stated

preference survey region.

Purpose: Includes state-level data used to calculate reductions in age-one-equivalent (A1E)

losses and percent fish saved within each stated preference survey region.

File Info 1 of 9
316(b) Region from EEBA Baseline Losses Option 1 Option 2 Option 3 Option 4

inland 879.4854 488.2248 805.8598 822.4643 476.3056

northatlantic 59.9996 0.4331 49.0222 51.4026 0.4331

midatlantic 990.0579 38.6862 909.7397 920.9044 38.6497

greatlakes 53.4970 38.2305 51.1340 51.3461 37.9074

gulfmexico 135.6423 34.5039 106.0228 106.2071 34.2434

southatlantic 33.4048 14.2011 28.2753 28.3013 14.2011

calif 384.0381 0.6945 31.4982 32.9214 0.6751

A1E Reductions 2 of 9
316b region

SP survey

region state

Actual Intake Flow (AIF)

by state and 316b region

% of regional

AIF

calif Pacific CA 11161.01 1.00

greatlakes Inland MI 6753.45 0.35

greatlakes Northeast NY 3718.19 0.20

greatlakes Inland WI 3087.88 0.16

greatlakes Inland OH 2275.16 0.12

greatlakes Inland IN 2214.87 0.12

greatlakes Inland IL 716.90 0.04

greatlakes Inland MN 242.60 0.01

greatlakes Northeast PA 37.60 0.00

gulfmexico Southeast FL 7054.29 0.53

gulfmexico Southeast TX 4904.06 0.37

gulfmexico Southeast LA 984.97 0.07

gulfmexico Southeast MS 302.57 0.02

inland Southeast TX 24892.29 0.18

inland Inland IL 10156.00 0.07

inland Inland TN 9480.70 0.07

inland Southeast NC 8688.92 0.06

inland Southeast AL 8204.45 0.06

inland Southeast LA 6988.36 0.05

inland Inland OH 6840.28 0.05

inland Northeast PA 6631.61 0.05

inland Inland IN 6377.28 0.05

inland Inland MO 6272.16 0.05

inland Southeast SC 6067.30 0.04

inland Inland WV 3894.25 0.03

inland Inland KY 3520.09 0.03

inland Southeast GA 3289.23 0.02

inland Inland NE 3015.30 0.02

inland Northeast NY 2578.70 0.02

inland Inland IA 2408.71 0.02

inland Inland MI 2247.57 0.02

inland Inland KS 2169.67 0.02

inland Inland MN 2166.65 0.02

inland Inland AR 2132.45 0.02

inland Inland OK 1890.13 0.01

inland Southeast VA 1840.59 0.01

inland Inland WI 1712.15 0.01

inland Southeast MS 913.00 0.01

inland Inland ND 903.60 0.01

inland Southeast FL 755.50 0.01

inland Northeast MD 471.77 0.00

inland Northeast VT 323.47 0.00

inland Inland CO 300.64 0.00

inland Inland AZ 290.53 0.00

inland Pacific WA 246.24 0.00

inland Northeast NH 233.03 0.00

inland Inland WY 223.11 0.00

inland Northeast CT 194.05 0.00

inland Inland MT 176.80 0.00

inland Northeast MA 157.79 0.00

inland Northeast NJ 114.99 0.00

inland Northeast ME 110.54 0.00

inland Inland NV 69.12 0.00

inland Pacific OR 61.00 0.00

inland Inland NM 46.56 0.00

inland Inland UT 41.49 0.00

inland Northeast DE 33.00 0.00

inland Inland SD 8.85 0.00

inland Northeast DC 1.35 0.00

inland Pacific CA 1.20 0.00

midatlantic Northeast NY 8993.72 0.32

midatlantic Northeast MD 6766.15 0.24

midatlantic Northeast NJ 6251.67 0.22

midatlantic Southeast VA 4674.51 0.17

midatlantic Northeast DE 1430.63 0.05

midatlantic Northeast PA 48.41 0.00

northatlantic Northeast MA 3504.76 0.50

Region Conversion 3 of 9
316b region

SP survey

region state

calif Pacific CA

greatlakes Inland MI

greatlakes Northeast NY

greatlakes Inland WI

greatlakes Inland OH

greatlakes Inland IN

greatlakes Inland IL

greatlakes Inland MN

greatlakes Northeast PA

gulfmexico Southeast FL

gulfmexico Southeast TX

gulfmexico Southeast LA

gulfmexico Southeast MS

inland Southeast TX

inland Inland IL

inland Inland TN

inland Southeast NC

inland Southeast AL

inland Southeast LA

inland Inland OH

inland Northeast PA

inland Inland IN

inland Inland MO

inland Southeast SC

inland Inland WV

inland Inland KY

inland Southeast GA

inland Inland NE

inland Northeast NY

inland Inland IA

inland Inland MI

inland Inland KS

inland Inland MN

inland Inland AR

inland Inland OK

inland Southeast VA

inland Inland WI

inland Southeast MS

inland Inland ND

inland Southeast FL

inland Northeast MD

inland Northeast VT

inland Inland CO

inland Inland AZ

inland Pacific WA

inland Northeast NH

inland Inland WY

inland Northeast CT

inland Inland MT

inland Northeast MA

inland Northeast NJ

inland Northeast ME

inland Inland NV

inland Pacific OR

inland Inland NM

inland Inland UT

inland Northeast DE

inland Inland SD

inland Northeast DC

inland Pacific CA

midatlantic Northeast NY

midatlantic Northeast MD

midatlantic Northeast NJ

midatlantic Southeast VA

midatlantic Northeast DE

midatlantic Northeast PA

northatlantic Northeast MA

baseline Option 1 Option 2 Option 3 Option 4

384.04 0.69 31.50 32.92 0.68

53.50 38.23 51.13 51.35 37.91

53.50 38.23 51.13 51.35 37.91

53.50 38.23 51.13 51.35 37.91

53.50 38.23 51.13 51.35 37.91

53.50 38.23 51.13 51.35 37.91

53.50 38.23 51.13 51.35 37.91

53.50 38.23 51.13 51.35 37.91

53.50 38.23 51.13 51.35 37.91

135.64 34.50 106.02 106.21 34.24

135.64 34.50 106.02 106.21 34.24

135.64 34.50 106.02 106.21 34.24

135.64 34.50 106.02 106.21 34.24

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

879.49 488.22 805.86 822.46 476.31

990.06 38.69 909.74 920.90 38.65

990.06 38.69 909.74 920.90 38.65

990.06 38.69 909.74 920.90 38.65

990.06 38.69 909.74 920.90 38.65

990.06 38.69 909.74 920.90 38.65

990.06 38.69 909.74 920.90 38.65

60.00 0.43 49.02 51.40 0.43

A1E Reductions by 316b Region

Region Conversion 4 of 9
316b region

SP survey

region state

calif Pacific CA

greatlakes Inland MI

greatlakes Northeast NY

greatlakes Inland WI

greatlakes Inland OH

greatlakes Inland IN

greatlakes Inland IL

greatlakes Inland MN

greatlakes Northeast PA

gulfmexico Southeast FL

gulfmexico Southeast TX

gulfmexico Southeast LA

gulfmexico Southeast MS

inland Southeast TX

inland Inland IL

inland Inland TN

inland Southeast NC

inland Southeast AL

inland Southeast LA

inland Inland OH

inland Northeast PA

inland Inland IN

inland Inland MO

inland Southeast SC

inland Inland WV

inland Inland KY

inland Southeast GA

inland Inland NE

inland Northeast NY

inland Inland IA

inland Inland MI

inland Inland KS

inland Inland MN

inland Inland AR

inland Inland OK

inland Southeast VA

inland Inland WI

inland Southeast MS

inland Inland ND

inland Southeast FL

inland Northeast MD

inland Northeast VT

inland Inland CO

inland Inland AZ

inland Pacific WA

inland Northeast NH

inland Inland WY

inland Northeast CT

inland Inland MT

inland Northeast MA

inland Northeast NJ

inland Northeast ME

inland Inland NV

inland Pacific OR

inland Inland NM

inland Inland UT

inland Northeast DE

inland Inland SD

inland Northeast DC

inland Pacific CA

midatlantic Northeast NY

midatlantic Northeast MD

midatlantic Northeast NJ

midatlantic Southeast VA

midatlantic Northeast DE

midatlantic Northeast PA

northatlantic Northeast MA

baseline Option 1 Option 2 Option 3 Option 4

384.04 0.69 31.50 32.92 0.68

18.97 13.56 18.13 18.21 13.44

10.44 7.46 9.98 10.02 7.40

8.67 6.20 8.29 8.32 6.15

6.39 4.57 6.11 6.13 4.53

6.22 4.45 5.95 5.97 4.41

2.01 1.44 1.92 1.93 1.43

0.68 0.49 0.65 0.65 0.48

0.11 0.08 0.10 0.10 0.07

72.24 18.38 56.46 56.56 18.24

50.22 12.77 39.25 39.32 12.68

10.09 2.57 7.88 7.90 2.55

3.10 0.79 2.42 2.43 0.78

157.34 87.34 144.17 147.14 85.21

64.19 35.64 58.82 60.03 34.77

59.93 33.27 54.91 56.04 32.45

54.92 30.49 50.32 51.36 29.74

51.86 28.79 47.52 48.50 28.09

44.17 24.52 40.47 41.31 23.92

43.24 24.00 39.62 40.43 23.42

41.92 23.27 38.41 39.20 22.70

40.31 22.38 36.93 37.70 21.83

39.64 22.01 36.33 37.07 21.47

38.35 21.29 35.14 35.86 20.77

24.61 13.66 22.55 23.02 13.33

22.25 12.35 20.39 20.81 12.05

20.79 11.54 19.05 19.44 11.26

19.06 10.58 17.46 17.82 10.32

16.30 9.05 14.93 15.24 8.83

15.22 8.45 13.95 14.24 8.25

14.21 7.89 13.02 13.29 7.69

13.71 7.61 12.57 12.82 7.43

13.69 7.60 12.55 12.81 7.42

13.48 7.48 12.35 12.60 7.30

11.95 6.63 10.95 11.17 6.47

11.63 6.46 10.66 10.88 6.30

10.82 6.01 9.92 10.12 5.86

5.77 3.20 5.29 5.40 3.13

5.71 3.17 5.23 5.34 3.09

4.78 2.65 4.38 4.47 2.59

2.98 1.66 2.73 2.79 1.61

2.04 1.13 1.87 1.91 1.11

1.90 1.05 1.74 1.78 1.03

1.84 1.02 1.68 1.72 0.99

1.56 0.86 1.43 1.46 0.84

1.47 0.82 1.35 1.38 0.80

1.41 0.78 1.29 1.32 0.76

1.23 0.68 1.12 1.15 0.66

1.12 0.62 1.02 1.05 0.61

1.00 0.55 0.91 0.93 0.54

0.73 0.40 0.67 0.68 0.39

0.70 0.39 0.64 0.65 0.38

0.44 0.24 0.40 0.41 0.24

0.39 0.21 0.35 0.36 0.21

0.29 0.16 0.27 0.28 0.16

0.26 0.15 0.24 0.25 0.14

0.21 0.12 0.19 0.20 0.11

0.06 0.03 0.05 0.05 0.03

0.01 0.00 0.01 0.01 0.00

0.01 0.00 0.01 0.01 0.00

316.15 12.35 290.50 294.06 12.34

237.84 9.29 218.55 221.23 9.28

219.76 8.59 201.93 204.41 8.58

164.32 6.42 150.99 152.84 6.41

50.29 1.97 46.21 46.78 1.96

1.70 0.07 1.56 1.58 0.07

29.88 0.22 24.41 25.60 0.22

A1E Assigned to Each State

Region Conversion 5 of 9
316b region

SP survey

region state

Actual Intake Flow (AIF)

by state and 316b region

% of regional

AIF

northatlantic Northeast CT 2099.03 0.30

northatlantic Northeast NH 909.39 0.13

northatlantic Northeast RI 275.36 0.04

northatlantic Northeast ME 248.87 0.04

southatlantic Southeast FL 5243.84 0.70

southatlantic Southeast NC 1426.89 0.19

southatlantic Southeast SC 592.85 0.08

southatlantic Southeast GA 198.47 0.03

Region Conversion 6 of 9
316b region

SP survey

region state

northatlantic Northeast CT

northatlantic Northeast NH

northatlantic Northeast RI

northatlantic Northeast ME

southatlantic Southeast FL

southatlantic Southeast NC

southatlantic Southeast SC

southatlantic Southeast GA

baseline Option 1 Option 2 Option 3 Option 4

A1E Reductions by 316b Region

60.00 0.43 49.02 51.40 0.43

60.00 0.43 49.02 51.40 0.43

60.00 0.43 49.02 51.40 0.43

60.00 0.43 49.02 51.40 0.43

33.40 14.20 28.28 28.30 14.20

33.40 14.20 28.28 28.30 14.20

33.40 14.20 28.28 28.30 14.20

33.40 14.20 28.28 28.30 14.20

Region Conversion 7 of 9
316b region

SP survey

region state

northatlantic Northeast CT

northatlantic Northeast NH

northatlantic Northeast RI

northatlantic Northeast ME

southatlantic Southeast FL

southatlantic Southeast NC

southatlantic Southeast SC

southatlantic Southeast GA

baseline Option 1 Option 2 Option 3 Option 4

A1E Assigned to Each State

17.90 0.13 14.62 15.33 0.13

7.75 0.06 6.33 6.64 0.06

2.35 0.02 1.92 2.01 0.02

2.12 0.02 1.73 1.82 0.02

23.47 9.98 19.87 19.89 9.98

6.39 2.72 5.41 5.41 2.72

2.65 1.13 2.25 2.25 1.13

0.89 0.38 0.75 0.75 0.38

Region Conversion 8 of 9
Option A1E Reductions %

A1E

Reductions %

A1E

Reductions % A1E Reductions % A1E Reductions %

Baseline 964.87 100.00% 722.97 100.00% 385.99 100.00% 462.29 100.00% 2536.13 100.00%

Option 1 78.31 8.12% 271.41 37.54% 1.78 0.46% 263.48 56.99% 614.97 24.25%

Option 2 880.70 91.28% 642.28 88.84% 33.28 8.62% 425.29 92.00% 1981.55 78.13%

Option 3 893.73 92.63% 651.70 90.14% 34.74 9.00% 433.38 93.75% 2013.55 79.39%

Option 4 77.29 8.01% 265.86 36.77% 1.73 0.45% 257.54 55.71% 602.42 23.75%

Northeast Southeast Pacific Inland National

Survey Region Estimates 9 of 9