### 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 ConversionPresents state-level intake flow data used to calculate reductions in A1E losses and percent fish saved for each stated preference survey region.

Survey Region EstimatesPresents 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 9316b regionSP survey region state Actual Intake Flow (AIF) by state and 316b region% of regional AIF calif Pacific CA 11161.01 1.00 greatlakesInland MI 6753.45 0.35 greatlakesNortheast NY 3718.19 0.20 greatlakesInland WI 3087.88 0.16 greatlakesInland OH 2275.16 0.12 greatlakesInland IN 2214.87 0.12 greatlakesInland IL 716.90 0.04 greatlakesInland MN 242.60 0.01 greatlakesNortheast PA 37.60 0.00 gulfmexicoSoutheast FL 7054.29 0.53 gulfmexicoSoutheast TX 4904.06 0.37 gulfmexicoSoutheast LA 984.97 0.07 gulfmexicoSoutheast 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 midatlanticNortheast NY 8993.72 0.32 midatlanticNortheast MD 6766.15 0.24 midatlanticNortheast NJ 6251.67 0.22 midatlanticSoutheast VA 4674.51 0.17 midatlanticNortheast DE 1430.63 0.05 midatlanticNortheast PA 48.41 0.00 northatlanticNortheast MA 3504.76 0.50



### Region Conversion 3 of 9316b regionSP survey region state calif Pacific CA greatlakesInland MI greatlakesNortheast NY greatlakesInland WI greatlakesInland OH greatlakesInland IN greatlakesInland IL greatlakesInland MN greatlakesNortheast PA gulfmexicoSoutheast FL gulfmexicoSoutheast TX gulfmexicoSoutheast LA gulfmexicoSoutheast 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 midatlanticNortheast NY midatlanticNortheast MD midatlanticNortheast NJ midatlanticSoutheast VA midatlanticNortheast DE midatlanticNortheast PA northatlanticNortheast MAbaseline 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.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.22 805.86 822.46 476.31 879.49488.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 9316b regionSP survey region state calif Pacific CA greatlakesInland MI greatlakesNortheast NY greatlakesInland WI greatlakesInland OH greatlakesInland IN greatlakesInland IL greatlakesInland MN greatlakesNortheast PA gulfmexicoSoutheast FL gulfmexicoSoutheast TX gulfmexicoSoutheast LA gulfmexicoSoutheast 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 midatlanticNortheast NY midatlanticNortheast MD midatlanticNortheast NJ midatlanticSoutheast VA midatlanticNortheast DE midatlanticNortheast PA northatlanticNortheast MAbaseline 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 9316b regionSP survey region state Actual Intake Flow (AIF) by state and 316b region% of regional AIF northatlanticNortheast CT 2099.03 0.30 northatlanticNortheast NH 909.39 0.13 northatlanticNortheast RI 275.36 0.04 northatlanticNortheast ME 248.87 0.04 southatlanticSoutheast FL 5243.84 0.70 southatlanticSoutheast NC 1426.89 0.19 southatlanticSoutheast SC 592.85 0.08 southatlanticSoutheast GA 198.47 0.03



### Region Conversion 6 of 9316b regionSP survey region state northatlanticNortheast CT northatlanticNortheast NH northatlanticNortheast RI northatlanticNortheast ME southatlanticSoutheast FL southatlanticSoutheast NC southatlanticSoutheast SC southatlanticSoutheast GAbaseline 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 9316b regionSP survey region state northatlanticNortheast CT northatlanticNortheast NH northatlanticNortheast RI northatlanticNortheast ME southatlanticSoutheast FL southatlanticSoutheast NC southatlanticSoutheast SC southatlanticSoutheast GAbaseline 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

### OptionA1E 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