SP_Survey_Benefits_Inputs_05.13.13.xls

Author: Abt Associates Inc.

Created: 05/15/13

Worksheet Description

State_AIF_Frac Presents the distribution of regional AIF across states.

State_List Presents a crosswalk matching states to SP survey regions.

HH_Survey_Reg Presents the total number of households in each SP survey region.

HH_State Presents state-level household data from Census 2010 used for 

calculations.

Rule_Changes Input sheet for percentage changes in commercial fish, fish 

population, and aquatic ecosystem condition attributes. All are set to 

zero because EPA did not estimate WTP for changes in these 

attributes under the final rule and options considered.

Implicit_Prices Input sheet for implicit prices for fish saved. Includes placeholders for 

implicit prices for unweighted linear and weighted quadratic models. 

These are set to zero because EPA's analysis of WTP for the final rule 

and options considered was limited to the weighted linear model.

Purpose: This in an input file for the 316(b) Stated Preference (SP) Survey Benefits Model. 

Key inputs include implicit prices for the fish saved attribute and household counts.
State Region AIF Frac_AIF

CA CAL 525,277,722.8 0.3157

HI CAL 1,138,658,433.3 0.6843

IL GL 800,620,000.0 0.0598

IN GL 1,814,834,157.0 0.1356

MI GL 6,505,069,500.0 0.4859

MN GL 126,333,333.3 0.0094

NY GL 121,076,701.4 0.0090

OH GL 876,404,222.2 0.0655

PA GL 0.0 0.0000

WI GL 3,142,759,666.7 0.2348

AK INL 35,470,000.0 0.0003

AL INL 8,046,724,328.0 0.0650

AR INL 2,132,446,543.0 0.0172

AZ INL 290,530,000.0 0.0023

CA INL 1,200,000.0 0.0000

CO INL 114,286,378.1 0.0009

CT INL 194,046,666.7 0.0016

DC INL 0.0 0.0000

DE INL 33,000,000.0 0.0003

FL INL 582,703,435.9 0.0047

GA INL 3,124,198,700.0 0.0252

IA INL 2,347,340,493.0 0.0190

IL INL 9,106,363,354.0 0.0735

IN INL 6,324,500,144.3 0.0511

KS INL 2,159,048,453.3 0.0174

KY INL 3,008,140,763.3 0.0243

LA INL 6,855,345,487.5 0.0553

MA INL 138,598,600.0 0.0011

MD INL 388,412,382.0 0.0031

ME INL 110,541,238.1 0.0009

MI INL 2,215,641,836.0 0.0179

MN INL 2,151,422,847.0 0.0174

MO INL 6,255,161,834.7 0.0505

MS INL 818,581,352.7 0.0066

MT INL 176,798,666.7 0.0014

NC INL 7,961,451,559.3 0.0643

ND INL 903,598,676.0 0.0073

NE INL 3,015,303,333.3 0.0243

NH INL 227,504,830.3 0.0018

NJ INL 44,654,000.3 0.0004

NM INL 46,563,325.0 0.0004

NV INL 0.0 0.0000

NY INL 670,926,137.2 0.0054

OH INL 4,846,862,307.9 0.0391

OK INL 1,890,128,195.8 0.0153

OR INL 48,999,629.8 0.0004

PA INL 4,847,021,658.6 0.0391

SC INL 6,014,451,297.3 0.0486

SD INL 2,960,354.7 0.0000

TN INL 7,613,628,215.0 0.0615

TX INL 22,563,560,408.5 0.1822

UT INL 39,359,227.3 0.0003

VA INL 1,607,753,829.8 0.0130

VT INL 323,466,666.7 0.0026
WA INL 166,811,500.9 0.0013

WI INL 1,554,439,206.3 0.0125

WV INL 2,646,499,162.1 0.0214

WY INL 223,110,731.4 0.0018

DE MA 1,430,625,000.0 0.0834

MD MA 6,766,151,948.9 0.3942

NJ MA 4,719,584,409.0 0.2750

NY MA 416,149,190.4 0.0242

PA MA 48,412,000.0 0.0028

VA MA 3,782,235,917.7 0.2204

FL Mex 5,976,100,253.3 0.5636

LA Mex 902,465,887.8 0.0851

MS Mex 302,570,000.0 0.0285

TX Mex 3,422,522,478.7 0.3228

VI Mex 0.0 0.0000

CT NA 1,957,331,020.0 0.3302

MA NA 2,578,369,333.3 0.4349

ME NA 207,868,333.3 0.0351

NH NA 909,388,333.0 0.1534

RI NA 275,355,333.3 0.0464

WA PNW 0.0 0.0000

FL SA 3,896,006,559.3 0.6541

GA SA 40,849,116.7 0.0069

NC SA 1,426,889,633.0 0.2395

SC SA 592,852,500.0 0.0995
State SP_Survey_Region

AK Inland

AL Southeast

AR Inland

AZ Inland

CA Pacific

CO Inland

CT Northeast

DC Northeast

DE Northeast

FL Southeast

GA Southeast

HI Pacific

IA Inland

IL Inland

IN Inland

KS Inland

KY Inland

LA Southeast

MA Northeast

MD Northeast

ME Northeast

MI Inland

MN Inland

MO Inland

MS Southeast

MT Inland

NC Southeast

ND Inland

NE Inland

NH Northeast

NJ Northeast

NM Inland

NV Inland

NY Northeast

OH Inland

OK Inland

OR Pacific

PA Northeast

RI Northeast

SC Southeast

SD Inland

TN Inland

TX Southeast

UT Inland

VA Southeast

VI Inland

VT Northeast

WA Pacific

WI Inland

WV Inland

WY Inland
SP_survey_region Num_Households

Northeast 23,980,830

Southeast 33,259,632

Inland 42,045,922

Pacific 16,716,512

National 116,002,896
2

State Total Households SP Region Data Source:

Alabama 1883791 Southeast U.S. Census Bureau, 2010 Census.

Alaska - - Summary File 1, Tables P17, P18, P28, 

Arizona 2380990 Inland

Arkansas 1147084 Inland Accessed on:

California 12577498 Pacific 8/8/2012

Colorado 1972868 Inland

Connecticut 1371087 Northeast

Delaware 342297 Northeast

District of Columbia 266707 Northeast

Florida 7420802 Southeast

Georgia 3585584 Southeast

Hawaii - -

Idaho 579408 Inland

Illinois 4836972 Inland

Indiana 2502154 Inland

Iowa 1221576 Inland

Kansas 1112096 Inland

Kentucky 1719965 Inland

Louisiana 1728360 Southeast

Maine 557219 Northeast

Maryland 2156411 Northeast

Massachusetts 2547075 Northeast

Michigan 3872508 Inland

Minnesota 2087227 Inland

Mississippi 1115768 Southeast

Missouri 2375611 Inland

Montana 409607 Inland

Nebraska 721130 Inland

Nevada 1006250 Inland

New Hampshire 518973 Northeast

New Jersey 3214360 Northeast

New Mexico 791395 Inland

New York 7317755 Northeast

North Carolina 3745155 Southeast

North Dakota 281192 Inland

Ohio 4603435 Inland

Oklahoma 1460450 Inland

Oregon 1518938 Pacific

Pennsylvania 5018904 Northeast

Rhode Island 413600 Northeast

South Carolina 1801181 Southeast

South Dakota 322282 Inland

Tennessee 2493552 Inland

Texas 8922933 Southeast

Utah 877692 Inland

Vermont 256442 Northeast

Virginia 3056058 Southeast

Washington 2620076 Pacific

West Virginia 763831 Inland

Wisconsin 2279768 Inland

Wyoming 226879 Inland

Puerto Rico - -
Bureau, 2010 Census.

1, Tables P17, P18, P28, P29, P37, P38, and P39.
SP_survey_region option_name per_com_fish per_fish_pop per_aquatic

Northeast option.tmn1 0 0 0

Southeast option.tmn1 0 0 0

Inland option.tmn1 0 0 0

Pacific option.tmn1 0 0 0

National option.tmn1 0 0 0

Northeast option.tmn2 0 0 0

Southeast option.tmn2 0 0 0

Inland option.tmn2 0 0 0

Pacific option.tmn2 0 0 0

National option.tmn2 0 0 0

Northeast option.tmn3 0 0 0

Southeast option.tmn3 0 0 0

Inland option.tmn3 0 0 0

Pacific option.tmn3 0 0 0

National option.tmn3 0 0 0

Northeast baseline 0 0 0

Southeast baseline 0 0 0

Inland baseline 0 0 0

Pacific baseline 0 0 0

National baseline 0 0 0
SP_survey_region Value Model IP_fish_sav IP_fish_sav_sq fish_sav_sig

Northeast mean linear 0.000 0.000 yes

Southeast mean linear 0.000 0.000 yes

Inland mean linear 0.000 0.000 yes

Pacific mean linear 0.000 0.000 yes

National mean linear 0.000 0.000 yes

Northeast low linear 0.000 0.000 yes

Southeast low linear 0.000 0.000 yes

Inland low linear 0.000 0.000 yes

Pacific low linear 0.000 0.000 yes

National low linear 0.000 0.000 yes

Northeast high linear 0.000 0.000 yes

Southeast high linear 0.000 0.000 yes

Inland high linear 0.000 0.000 yes

Pacific high linear 0.000 0.000 yes

National high linear 0.000 0.000 yes

Northeast mean weighted_linear 1.437 0.000 yes

Southeast mean weighted_linear 0.625 0.000 yes

Inland mean weighted_linear 0.495 0.000 yes

Pacific mean weighted_linear 1.771 0.000 yes

National mean weighted_linear 0.664 0.000 yes

Northeast low weighted_linear 0.947 0.000 yes

Southeast low weighted_linear 0.417 0.000 yes

Inland low weighted_linear 0.280 0.000 yes

Pacific low weighted_linear 1.067 0.000 yes

National low weighted_linear 0.279 0.000 yes

Northeast high weighted_linear 2.072 0.000 yes

Southeast high weighted_linear 0.834 0.000 yes

Inland high weighted_linear 0.701 0.000 yes

Pacific high weighted_linear 2.616 0.000 yes

National high weighted_linear 1.070 0.000 yes

Northeast mean weighted_quadratic 0.000 0.000 yes

Southeast mean weighted_quadratic 0.000 0.000 yes

Inland mean weighted_quadratic 0.000 0.000 yes

Pacific mean weighted_quadratic 0.000 0.000 yes

National mean weighted_quadratic 0.000 0.000 yes

Northeast low weighted_quadratic 0.000 0.000 yes

Southeast low weighted_quadratic 0.000 0.000 yes

Inland low weighted_quadratic 0.000 0.000 yes

Pacific low weighted_quadratic 0.000 0.000 yes

National low weighted_quadratic 0.000 0.000 yes

Northeast high weighted_quadratic 0.000 0.000 yes

Southeast high weighted_quadratic 0.000 0.000 yes

Inland high weighted_quadratic 0.000 0.000 yes

Pacific high weighted_quadratic 0.000 0.000 yes

National high weighted_quadratic 0.000 0.000 yes
fish_sav_sq_sig fish_sav_WTP_threshold

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

yes 100

yes 100

yes 100

yes 100

yes 100

yes 100

yes 100

yes 100

yes 100

yes 100

yes 100

yes 100

yes 100

yes 100

yes 100