File name: Date created: This workbook was prepared by Status Consulting, Inc. to provide results of IE modeling in support of 316( b) Phase 3 rulemaking Confidential, Predecisional, and Deliberative, FOIA Exempt, Do Not Cite Or Quote Contacts: Liz Strange or Dave Cacela 303.381.8000 Worksheet RecBenefitsDetail field name option lossmode species_ econ region rec_ baseline_ n_ 1e6 rec_ n_ red_ 0pct_ 1e6 rec_ n_ red_ 3pct_ 1e6 rec_ n_ red_ 7pct_ 1e6 ComBenefitsDetail field name option lossmode species_ econ region metric estimate_ extrapolated_ 1e6 reduction_ pct est_ extrap_ reduction_ 1e6 com_ frac estimate_ extrapolated_ com_ 1e6 est_ extrap_ reduction_ com_ 1e6 com_ val_ dlr_ lb_ 2003 dockside_ dlr_ 1e6 dockside_ dlr_ red_ 0pct_ 1e6 dockside_ dlr_ red_ 3pct_ 1e6 This workbook updates a similar workbook del 1/ 24/ 06 and 1/ 25/ 06. Commercial Benefits no lo region). The 1/ 25 version relied on some incorr correctly, and as a result loss estimates chang columns. The columns estimate_ extrapolated_ commercial and rec sectors combined. This v dockside_ dlr_ red_ 7pct_ 1e6 ratio_ lbs_ 3pct ratio_ lbs_ 7pct JanBriefing field name option known_ facs_ n known_ facs_ sum_ mgd weighted_ facs_ n design_ flow_ wtd_ mgd flow_ mgd_ wtd est_ extrap_ ae1_ red_ 1e6 est_ extrap_ yflb_ red_ 1e6 dockside_ dlr_ red_ 0pct_ 1e6 dockside_ dlr_ red_ 3pct_ 1e6 dockside_ dlr_ red_ 7pct_ 1e6 scripts: P:\ INTAKE\ iemodeling. revised\ scode\ m P:\ INTAKE\ iemodeling. revised\ scode\ in RecComBenefitsDetail 3 23( results). xls 1/ 30/ 2006 Description contents name of regulatory option ( reduction values provided by Tetratech 1/ 17/ 06, 1/ 20/ 06, 1/ 24/ 06, and 1/ 25/ 06). Options are 200mgd, 100 mgd( selected facilities), 50 mgd, 2mgd ( imp and ent control), 2mgd ( imp control only)

impingement or entrainment recreational species groups analysis region baseline rec losses ( millions of fish)

estimated reduction in rec losses with no time value discount ( millions of fish)

estimated reduction in rec losses with 3% time value discount ( millions of fish)

estimated reduction in rec losses with 7% time value discount ( millions of fish)

contents name of regulatory option ( reduction values provided by Tetratech 1/ 17/ 06, 1/ 20/ 06, 1/ 24/ 06, and 1/ 25/ 06). Options are 200mgd, 100 mgd( selected facilities), 50 mgd, 2mgd ( imp and ent control), 2mgd ( imp control only)

impingement or entrainment commercial species groups analysis region foregone commercial yield ( pounds)

baseline losses ( millions of foregone Rec& Com yield pounds)

option effectiveness; regional reduction in losses resulting from implementing option ( millions of foregone Rec& Com yield pounds avoided due to option)

fraction of harvest in the commercial sector baseline losses ( millions of foregone commercial yield pounds)

reduction in losses resulting from implementing option ( millions of foregone commercial yield pounds avoided due to option)

dockside commercial price dollars/ lb baseline losses ( millions of dockside dollar equivalent of baseline foregone commercial yield pounds)

reduction in millions of dockside dollars forgone from implementing option without time value discount reduction in millions of dockside dollars forgone from implementing option with time value discount at 3% delivered on 1/ 25/ 06. This version incorporates corrections to the options effectiveness rates that were delivered by Tetratech on longer include the inland region ( on 1/ 25 the commercial losses inadvertently included a line item for trophic transfer in the inland orrect values for intake flow and survey weights for 6 facilities that are " split" into A/ B intakes. This version splits these facilities nge slightly ( primarily in the Gulf of Mexico region). The 1/ 25 version included incorrect labels in the readme sheet describing two d_ 1e6 and est_ extrap_ reduction_ 1e6 were incorrectly labeled as representing the commercial sector, but in fact they represented version corrects the readme descriptions and includes new fields that report the commercial sector portions of those estimates. reduction in millions of dockside dollars forgone from implementing option with time value discount at 7%

time value at 3%

time value at 7%

contents name of regulatory option provided by Tetratech 1/ 17/ 06. Options are 200mgd, 100 mgd( selected facilities), 50 mgd, 2mgd ( all facilities), 2mgd ( all facilities, impingement control only)

number of facilities known in facility " master" database; not weighted for survey non response water withdrawal by facilities included in known_ facs_ n ( average actual flow ; millions of gallons per day)

total number of affected facilities determined with consideration of weighting for survey non response water withdrawal by facilities included in weighted_ facs_ n ( design flow; millions of gallons per day)

water withdrawal by facilities included in weighted_ facs_ n ( average actual flow; millions of gallons per day)

estimated reductions in impinged and entrained fish ( millions of age 1 equivalents)

estimated reductions in foregone commercial harvest ( millions of pounds)

estimated reductions in foregone commercial harvest value with no time value discount( millions of dockside dollars)

estimated reductions in foregone commercial harvest value with 3% time value discount( millions of dockside dollars)

estimated reductions in foregone commercial harvest value with 7% time value discount( millions of dockside dollars)