Author: US EPA Date: 03-Aug-04 Last Modified: 11-Mar-11 Modified By: SAIC Version: Version 6.1

General Notes: The file is divided into three main worksheets, as follows: **"User Inputs"**sheet -- permit writer would provide site-specific information here. **"Output"**sheet presents the costing calculation outputs. **"Calc. and Data"**sheet contains the data used in the algorithm and portions of the algorithm. **"Macro Input"**sheet contains data to be used as input for Auto Input Output Macro. **"Macro Output"**sheet contains output data from Auto Input Output Macro. **"version notes"**contains programming notes on the updated version. **"macro code"**contains a text version of the visual basic programming for the macro. **"Tecnology Module Codes"**contains a descriptive list of the technolgy module codes to be used as input selection or to interpret output selecxtion Technical Notes: All technology modules identified in Phase II , except 10 (which was sparingly or not used in the rule development) are included in this version.

Module 10.0, 10.1, 10.2, 10.3, & 10.4 were created to represent combinations of several modules. Permit and monitoring costs are not included. See "version notes" for more technical information on the programming.

The Macro: Included in this file should be a macro to generate auto output for all facilities. The "Macro Input" sheet should be left cleared when

sharing the tool. It needs to be filled with facility/intake-level data prior to executing the macro.

CBI Status: Code and equations are NON-CBI. This worksheet could potentially become CBI if combined with facility specific data. The macro

input page, when operated to generate facility-level costs, contains CBI. Edits by Shriner 8/03/04 Added lookup table to calcs page for fixed and variable costs coefficients

Added columns for fixed and variable costs to macro outputs Macro input page has changes reflecting 072904 P3 master database (red means deleted from cost analysis; green means facility added; orange means new input data

Edits by Pritts 6/24 Added UT and VI to zebra mussel input table (need to enter value - assigned zero for now)) in sheet "Calc. And Data" to eliminate

error in Column C of "Macro Output" sheet Deleted duplicate zebra mussel entry for Tennessee - need to enter value (assigned zero for now) Changed formula in cell C5 of "Output" sheet to account for new range of zebra mussel table (Q5:R57) Added 0.5 fps through-screen velocity as criteria for meeting impingement requirements Edits by Shriner 6/30 Added missing states to regional cost factor tables; no RMS 2001 data for VI, so leave value at 1. SAIC Edits 2005 Edit by Sunda 6-1-05 Added Baseline and Fixed O&M Fixed Factor to Output

Added AIF as Input Variable Revised Baseline and Gross module O&M output such that variable costs are reduced bt a factor of AIF/DIF Added Canal Length as Input Variable Added Calculation for Added fish sluice length to Calc & Data Edits by Sunda 6-2-05 revised calculaton of Module 3 Capital Costs to include separate equations for screen widths < 10 ft

Added default tables and output variable for screen velocity Added input variable for facility Type To be used for default selection Added output variable for screen velocity with defaults using facility type & flow Edits by Sunda 6-3-05 Set regional factor default as 1.0

Added input value for New Design Flow (old DIF is now refered to as DIF for existing technology) Added output variables for design flow for traveling screens an another for other technologies. Revised cells referenced for technology cost calculations Added input for selection of flow used as screen velocity basis. Edits by Sunda 6-09-05 Added output for screen velocity at new design flow

Added Input for distance offshore of submerged inlet and revised output for median distance offshore to select distance based on new input or waterbody if blank (as before) Revised O&M costs so that default for debris loading is "high debris" Edits by Sunda 6-015-05 Revised baseline O&M cost such that cost = 0 if cost module 5 or 8 is selected. Edits by Sunda 6-22-05 Revised baseline calculation for passive intakes based on submerged intake survey data and set fixed factor at 50%. Edits by Doley 6-24-05 Revised visual basic macro program "Auto Input Output" to run with the new Input File and the revisions to the Cost Model Edits by Doley 7-01-05 Revised User Inputs page of Cost Model to include a toggle which allows the macro to be run using the DIF, MRIF, or AIF to calculate technology capital costs. Edits by Doley 7-05-05 Revised Output and Calc.& Data pages so that the O&M costs based on weighted AIF flows are calculated with the weighting done before the cost curve is applied rather than afterward Edits by Doley 7-05-05 A review of the cost model showed that it will provide O&M costs without AIF data entered for the facility but he O&M costs will be incorrect.

As a result AIF should be considerd a required input for running the model. Edits by Moe 7-12-05 Corrected downtime for Module 7 such that downtime for flow >800000 gpm is 11 (corrected from 10).

Corrected cell references for certain capital cost calculation cells in Modules 3, 4, 5, 9, 12 and 13 to reference the correct flow or width cells. Revised downtime duration output (cell F9) to show 0 weeks downtime if module 0 selected. Edits by Moe 7-13-05 Added Calculation for Added fish sluice length for canals to Calc & Data (Modules 3 & 11)

Revised Output cell F13 so that it calculated number of units based on new intake screen width (cell F12) rather than baseline screen width (cell F10); this cell is used for Module 3 calculations only. Revised Modules 1, 2, 2a and 11 so that they calculate costs based on number of baseline units (Output cell F11) rather than new intake units (Output cell F13). Revised Module 3 so that it costs screen widths >140 ft as multiple units of <140 ft and no longer double-counts the number of units in calculating screen costs. Edits by Moe 7-25-05 Revised downtime duration algorithm to select different downtimes for electric generators and manufacturers. Edit by Sunda 8-23-05 Revised Ouput Cells F8 and F28 so that Downtime Costs (EG only) says "NA" if plant type is not power generation Edit by Sunda 11-1-07 Added Input variable for Selected Technology (Input 26) and revised Output Selected Technology to read Input 26 if not blank. Edit by Sunda 11-1-07 Revised Macro to new input data size Edit by Sunda 11-2-08 Corrected Calc & Data Capital & O&M cost to include multiplier for multiple velocity caap "Output" Cell F15. Edit by Sunda 11-2-07 Revised Calc & data for module 3 to use double entry single exit traveling screens (TSDF) instead of single entry/single exit screens Edit by Sunda 11-2-07 Revised screen open area for "output" Module 3 comp screen width from 0.68 to 0.5 Edit by Sunda 11-2-07 Revised Module 4 and 12 cost to use relocate submerged offshore 20 M instead of add passive screens to existing submerged offshore 20 M costs Edit by Sunda 11-5-07 Revised User Input to include regional cost factor. Revised Output to use input regional cost factor or state averages if blank. Edit by Sunda 11-05-07 Revised Calc & Data sheet to include default relocate submerged offshore distance for Intake code 6. Set it same as Code 1. Revised Ocean to be 500 for all per TDD Edit by Sunda 116-07 Revised output "offshore distance" to use 20% greater thresholds of 24m, 150m, 300m instead of 20m, 125m, 250m similar to ranges used for selection of screen well depth Edit by Sunda 11-6-07 Revised output "Baseline O&M" so that if assigned cost module is 0 cost is 0 Edit by Sunda 117-07 Added input value for ENR Construction Cost Index and modified Output Cost to relect inflation adjustment based on eCalc & Data equation output representing 2002 dollars CCI = 6538 Edit by Sunda 11-7-07 Revised Output to include inflation factor and applied factor to both O&M and Capital costs in output. Sunda 12/26/07 Added Cost Module 10 to calc and data sheet. Module 10 = Combined capital and O&M cost of Modules 2a and 5. Set fixed factor as weighted average of both based on capital costs. Sunda 2/15/08 Added technology service life lookup file to calc & data and added service life to output page Sunda 2/20/08 Revised service life output and lookup file to include saltwater & freshwater applications Sunda 7-2-08 Added Modules 10, 10.1, & 10.2 to calc & data cost lookup table to represent sum of costs modules 2+5, 2a+5, and 3+5. Set fixed O&M as weighted average. Sunda 7-2-08 Added 10, 10.1, 10.2 to service life and downtime lookup tables using values for 2, 2a, & 3. Sunda 7-25-08 Revised cot tool input data using new "qualified" determinations for I&E (Inputs 22 & 24) Sunda 7-28-08 Added default relocate submerged offshore distances (same as for other intake locations) for existing submerged intake locations Code 4 and 5 in Calc & data sheet Sunda 7-28-08 Added Modules 13 & 14 to freshwater pilot study lookup table in Pilot Study Factors used same values as for saltwater Sunda 7-29-08 Added module 10.3 (combined modules 1 and 5) to calc & Data, service life & downtime Sunda 9-10-08 Revised Module 2a O&M and capital cost calculation in Calc & Data to use correct unit number (F11 not F13 Sunda 9-30-08 Corrected error on output page compliance O&M used Cap nuclear factor instead of O&M nuclear factor1 2

3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 A B C D E F G H I J K L M **User Inputs -- At The Intake Level Facility Information Tables/Keys** 

**Facility Type =** ( 3 = Manufacturer, 2 =Power Generation)(Required Field)

Cooling System Type = ( 1 = Full Recirculation, 2 = Cooling Ponds, 0 = All Others) Intake Location /**Description** 1 = Shoreline Intake (flush, recessed) **State Abbreviation =** (Required Field) 2 = Intake Canal 3 = Embayment, Bay, or Cove **Waterbody Type =** (1=Ocean, 2=Estuary, 3=Great Lake, 4=Fresh River, 5=Lake/Res.) 4 = Submerged Offshore Intake 5 = Near-shore submerged intake Fuel Type = (1 = Nuclear, 0 = Non-Nuclear) 6 = Shoreline Submerged Intake **Impingement Tech**nologies In-place Capacity Utilization (1996-99) = %(No Longer in use) 0 = None of those listed 1 = Traveling Screens **Intake Location / Description** (choose from Description table at right)(Required Field) 2 = Passive Intake (Fixed Screen, Porous Dam, Leaky Dike, etc.) Distance Offshore for Submerged Inlet ft (use for submerged offshore technologies) 3 = Barrier Net 4 = Fish Diversion or Avoidance (Louvers, Acoustics, etc.) Canal Length = ft (if canal is present between mouth and screens) 5 = Wedgewire Screens 6 = Velocity Cap Navigation / Waterbody Use (1 = boat/barge navigation near intake,No longer in use) **Through Screen Velocity**Flow Basis 1 = Existing Equipment Design Intake Flow **Mean Intake Water Depth =** ft 2 = New Design Intake Flow 3 = Average Intake Flow Intake Well Depth = ft In-place Tech EPA "Qualified" for**Impingement**Reductions River Proportional Flow = (No Longer in use) 0 = none 1 = Fish Handling and Return Systems & Ristroph Traveling Screens or **Existing Equipment Design Intake Flow =** gpm(Required Field) Passive Intakes (velocity cap, t-screens, porous dams, etc.) 2 = Through screen velocity of .5 fps or less only New Design Intake Flow = gpm (Use only if new technology will use different design flow) **Entrainment Tech**nologies In-place **Average Intake Flow =** gpm(Required Field) 0 = None of those listed 1 = Traveling Screens w/ Fine Mesh Existing Through Screen Velocity = fps (defaults will be used if left blank) 2 = Far Offshore Intake 3 = Passive Screens w/ Fine Mesh Through Screen Velocity Flow Basis = ( Choose from Through Screen Velocity Flow Basis list at right In-place Tech EPA "Qualified" for**Entrainment**Reductions

Water Type = (1 = marine, 0 = fresh) Fine Mesh Screens (passive or traveling screens) Far Offshore Intake w/ Passive Intake at Inlet Debris Loading = (1 = high, 0 = normal) **Recent ENR Construction Cost Indices Impingement Tech In-Place =**  (choose from Impingement Tech list at right) **Year Index**  2002 (Default) 6538 **Qualified Impingement? =** (1 or 2 = Qualified, 0 = none; see impingement reduc. table to right) 2003 6694 2004 7115 Entrainment Tech In-Place = (choose from Entrainment Tech list at right -No Longer in use) 2005 7446 2006 7751 Qualified Entrainment? = (1 = Qualified, 0 = none;No longer in use) 2007 7966 2008 (October) 8623 Avg Annual Generation '96 - '99 = (MWh, reported data, excluding outliers, EG only) 2009 (February) 8533
**Selected Technology Module =** (Technology Module will be selected for you if left blank)
Regional Cost Factor = ( 1.0 = National Average - Leave blank for default state average)

ENR Construction Cost Index = ( Inflation Index for desired cost year - see table at right)
Compliance Screen Mesh (mm) = (Select from 9.5, 2.0, 1.0, 0.5 - default = 2.0))
Screen Velocity

for Module 3 (fps) = (default is 1.0 fps)
Maximum Acceptable Screen Velocity (fps) = (Used to dertermine if existing technology must be replaced)
Total Plant Design Intake Flow = MGD
Total Plant Average Intake Flow = MGD

### 3

4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 B C D E F G
Design Flow for Traveling Screens 0gpm 

### Downtime Flow Regime #N/A Design Flow for Other Technology 0gpm 

### Canal Length 0ft 

### Capacity Cutoff? 0 Offshore Distance #N/A m 

### Zebra Mussel? #N/A Regional Capital Cost Factor -> 1.00 Module 15 Candidate #N/A Downtime Cost (predicted mean, EG only) NA Impingement Upgrade? #N/A Downtime Duration (net, weeks) #N/A 2 Yr Monitoring Candidates (1 = Yes) #N/A Baseline Screen Width, Calculated #N/A #N/A Midwestern State 0 Number of Units/Flat Screen Baseline #N/A Compliance Screen Width for Mod. 3 #N/A ft 

### Monitoring Module #N/A No. of Units/New Intake Traveling Screen #N/A Screen Velocity at Existing DIF #N/A fps Number of T-Screens per Intake 1 Existing Velocity at New DIF 

### #N/A fps No. of Velocity Cap or AFB Units per Intake 1 Velocity Cap Compliance Technology 0 Relocation Distance Offshore #N/Am 

### Ocean or Estuary? 1 Baseline Flow per Velocity Cap or AFB Unit

- gpm 

### Navigation Traffic? 1 Baseline Flow per T-Screen Unit

- gpm 

### Module Based on Velocity & Location #N/A Baseline Intake Well Depth Regime #N/A ft 

### Fish Return Addition (1 = "Ave"; 2 ="High") 1 Nuclear Capital Cost Factor 1 Add Module 5 to Saltwater #N/A Nuclear O&M Cost Factor for Screens 1 

## Assigned Costing Module **#N/A** Inflation Factor for Selected Cost Year 1.00 

## Costing Module Service Life **#N/A Baseline O&M**  **#N/A** Modified for IM compliance technology selection 

## Gross Module O&M **#N/A** Not currently

in use 

## Baseline O&M Fixed Factor
**- $**  Velocity Cap IM Compliant ( 1=No) **1** 

## Gross Module O&M Fixed Factor **#N/A Compliance Tech Capital**  **#N/A Basis for New Intake Technology Costs $**  **1** 

## Compliance Net Annual O&M **#N/A**

(0 = DIF, 1 = New Design Flow, 2 = AIF) Downtime Cost (EG only) NA One-time Permit Costs Annual Monitoring Costs Estimated Annual Cost per MWh **EPA Cost Algorithm Output...** **Do Not Edit EPA Costing Calculation** **Output... Do Not Edit** 

## Calculations and Data -- Do Not Edit

**Waterbody**

**Code** 

## Assumed Distance from **Mean Water Surface to Screen Deck (ft)**  Ocean 1 15 

## Estuaries/Tidal Rivers 2 15 

## Great Lakes 3 15 

## Rivers and Streams 4 30 

## Lakes/Reservoirs 5 20 Default 30 Assumed Distance 30

**Contingency/Allowance Factor - Traveling Screens**

1 Add Fish Handling and Return System 2 Add Fine Mesh Travelling Screens with Fish Handling and Return 2a Add Fine Mesh Screen Overlays Only 3 Add New Larger Intake Structure with Fine Mesh, Handling and Return 4 Add Passive Fine Mesh Screens (1.75 mm mesh) at Shoreline 5 Add Fish Barrier Net 6 Gunderboom 7 Relocate Intake to Submerged Offshore with passive screen (1.75 mm mesh) 8 Add Velocity Cap at Inlet 9 Add Passive Fine Mesh Screen (1.75 mm mesh) at Inlet of Offshore Submerged 10 10.Combination of Module 2 and Module 5; 10.1 Comb Module 2a & 5; 10.2 Comb Module 3 & 5; 10.3 Comb Module 1 & 5; 10.4 comb Module 1 & 8 11 Add Double-Entry, Single-Exit with Fine Mesh, Handling and Return 12 0.75 mm Passive Fine Mesh Screen at Shoreline (For Estuary & Ocean only) 13 0.75 mm Passive Fine Mesh Screen at Inlet of Offshore Submerged (For Estuary & Ocean only) 14 Relocate Intake to Submerged Offshore with 0.75 mm passive screen (For Estuary & Ocean only) 15 Variable Speed Pumps

costing module # capital gross O&M 0 1 #N/A #N/A 2 #N/A #N/A 2a #N/A #N/A 3 #N/A #N/A 4 #N/A #N/A

**Module Costs Look-up Table**

**Costing Module Legend** 20%

### 5 6,646 $ #N/A 6 606,559

$ 219,404 $ 7 #N/A #N/A 8 38,053

$ 4,731 $ 9 #N/A #N/A 10.0 #N/A #N/A 10.1 #N/A #N/A 10.2 #N/A #N/A 10.3 #N/A #N/A 10.4 #N/A #N/A 11 #N/A #N/A 12 #N/A #N/A 13 #N/A #N/A 14 #N/A #N/A 15 150,000

$

- $

**Freshwater** Baseline Module Abbreviation well depth range (ft) Screen Width Per Costing Unit (ft)
TSNF_FW10_OM 

### 10 #N/A TSNF_FW25_OM 

### 25 #N/A TSNF_FW50_OM 

### 50 #N/A

TSNF_FW75_OM 

### 75 #N/A TSNF_FW100_OM 

### 100 #N/A

TSB_FW10_OM 

### 10 #N/A TSB_FW25_OM 

### 25 #N/A TSB_FW50_OM 

### 50 #N/A

TSB_FW75_OM 

### 75 #N/A TSB_FW100_OM 

### 100 #N/A

**Saltwater** Baseline Module Abbreviation well depth range (ft) Screen Width Per Costing Unit (ft)

TSNF_SW10_OM 

### 10 #N/A

TSNF_SW25_OM 

### 25 #N/A

TSNF_SW50_OM 

### 50 #N/A **Baseline O&M for Traveling Screens**

traveling screens w/o fish handling

traveling screens w/o fish handling traveling screens w/ fish handlingTSNF_SW75_OM 

### 75 #N/A

TSNF_SW100_OM 

### 100 #N/A

TSB_SW10_OM 

### 10 #N/A

TSB_SW25_OM 

### 25 #N/A TSB_SW50_OM 

### 50 #N/A TSB_SW75_OM 

### 75 #N/A

TSB_SW100_OM 

### 100 #N/A

**Baseline O&M Costs for Passive Intakes Existing DIF** 

Passive 0 **Inflation Factor** ENR Cost Index for Year 2002 6538 ENR Cost Index for Selectec Cost Year (default is 2002) 6538

Inflation Factor 1.00

**Screen Mesh and Open Area Data Mesh Size (mm)**  **Percent open area** 9.5 0.68 2 0.5 1 0.44

0.5 0.33

**Relocation Distance Algorithm**

traveling screens w/ fish handling

### Waterbody Code 1 2 1 500 500 2 125 125 3 500 500

4 125 125 5 125 125

Interim Calculation #N/A m Relocation Distance #N/A m

## Screen Well Depth **Default screen well depth**  **Regime**

#N/A #N/A

Relocate Intake to Submerged Offshore with passive screen (1.75 mm mesh)
Add Passive Fine Mesh Screen (1.75 mm mesh) at Inlet of Offshore Submerged 10.Combination of Module 2 and Module 5; 10.1 Comb Module 2a & 5; 10.2 Comb Module 3 & 5; 10.3 Comb Module 1 & 5; 10.4 comb Module 1 & 8
0.75 mm Passive Fine Mesh Screen at Shoreline (For Estuary & Ocean only) 0.75 mm Passive Fine Mesh Screen at Inlet of Offshore Submerged (For Estuary & Ocean only) Relocate Intake to Submerged Offshore with 0.75 mm passive screen (For Estuary & Ocean only)

Fixed Factor Lookup costing module # fixed factor Design Flow Used (gpm) 0 0.0 1 0.4 0 2 0.4 0 2a 0.4 0 3 0.40 0 4 0.24 0

### 5 1.0 0 6 1.0 0 7 0.24 0 8 1 0 9 0.24 0 10.0 #N/A 0 10.1 #N/A 0 10.2 #N/A 0 10.3 #N/A 0 10.4 #N/A 0 11 0.385 0 12 0.24 0 13 0.24 0 14 0.24 0 15 1.0 0

Baseline O&M fixed factor #N/A 

### 0.45 #N/A 

### 0.47 #N/A 

### 0.48**Freshwater**

#N/A 

### 0.49Compliance Module Abbreviation well depth range (ft) #N/A 0.49 TSA_FW10_CAP 

### 10 TSA_FW25_CAP 

### 25

#N/A 

### 0.28 TSA_FW50_CAP 

### 50 #N/A 

### 0.30 TSA_FW75_CAP 

### 75 #N/A 

### 0.32 TSA_FW100_CAP 

### 100

#N/A 

### 0.33 #N/A 

### 0.33 TSC_FW10_CAP 

### 10 TSC_FW25_CAP 

### 25

TSC_FW50_CAP 

### 50 Baseline O&M TSC_FW75_CAP 

### 75

#N/A 

### 0.45 TSC_FW100_CAP 

### 100

#N/A 

### 0.47

#N/A 

### 0.48Compliance Module Abbreviation well depth range (ft)

**Add Traveling Screens w/ Fish Handling & Return (Module 2)**

Capital -- add traveling screens w/ fine mesh only

O&M -- add fine mesh traveling screens (w/ handling) Capital -- add fine mesh traveling screens w/ fish handling#N/A 

### 0.49 TSAC_FW10_OM 

### 10

#N/A 

### 0.49 TSAC_FW25_OM 

### 25 TSAC_FW50_OM 

### 50 #N/A 

### 0.31 TSAC_FW75_OM 

### 75

#N/A 

### 0.34 TSAC_FW100_OM 

### 100 #N/A 

### 0.36 #N/A 

### 0.38**Saltwater**

#N/A 

### 0.38Compliance Module Abbreviation well depth range (ft)

TSA_SW10_CAP 

### 10
$2,977 0.5 TSA_SW25_CAP 

### 25 TSA_SW50_CAP 

### 50 TSA_SW75_CAP 

### 75

TSA_SW100_CAP 

### 100

TSC_SW10_CAP 

### 10

TSC_SW25_CAP 

### 25 TSC_SW50_CAP 

### 50 Default TSC_SW75_CAP 

### 75 TSC_SW100_CAP 

### 100

Compliance Module Abbreviation well depth range (ft)
TSAC_SW10_OM 

### 10 TSAC_SW25_OM 

### 25 TSAC_SW50_OM 

### 50

TSAC_SW75_OM 

### 75 TSAC_SW100_OM 

### 100

**Relocation Distance Algorithm** Capital -- add fine mesh traveling screens w/ fish handling Capital -- add traveling screens w/ fine mesh only

O&M -- add fine mesh traveling screens (w/ handling)

### 3 4 5 6 500 500 500 500 125 125 125 125 500 500 500 500

125 125 125 125 125 125 125 125 Intake Code

### Unit Cost( $/gpm) Design Flow (gpm) Compliance Capital Minimum Capital O&M

**Freshwater**

Screen Width Per Costing Unit (ft) Compliance Capital Compliance Module Abbreviation distance offshore (m)
#N/A #N/A PS_FW20_CAP 

### 20 #N/A #N/A PS_FW125_CAP 

### 125

#N/A #N/A PS_FW250_CAP 

### 250 #N/A #N/A PS_FW500_CAP 

### 500 #N/A #N/A

PS_ZM20_CAP 

### 20 #N/A #N/A PS_ZM125_CAP 

### 125 #N/A #N/A PS_ZM250_CAP 

### 250

#N/A #N/A PS_ZM500_CAP 

### 500 #N/A #N/A 

### O&M

#N/A #N/A 

### Compliance Module Abbreviation debris loading

PSS_LD_OM 

### Low Debris Screen Width Per Costing Unit (ft) Gross Compliance

O&M PSS_HD_OM 

### high Debris **Add Traveling Screens w/ Fish Handling & Return (Module 2)**

Capital -- add traveling screens w/ fine mesh only **Relocating Intake Offshore with New Passive Screens (Module 4 & 7)**

O&M -- add fine mesh traveling screens (w/ handling) **Variable Speed Pumps (Module 15)**

Capital -- add fine mesh traveling screens w/ fish handling#N/A #N/A 

### Saltwater capital

#N/A #N/A 

### Compliance Module Abbreviation distance offshore (m) #N/A #N/A PSS_20_CAP 

### 20 #N/A #N/A PSS_125_CAP 

### 125

#N/A #N/A PSS_250_CAP 

### 250 PSS_500_CAP 

### 500 O&M Screen Width Per Costing Unit (ft) Compliance Capital Compliance Module Abbreviation debris loading

#N/A #N/A PSS_LD_OM 

### Low Debris

#N/A #N/A PSS_HD_OM 

### high Debris #N/A #N/A 

### #N/A #N/A



### #N/A #N/A 

### Freshwater Compliance Module Abbreviation distance offshore (m)

#N/A #N/A FM_FW20_CAP 

### 20

#N/A #N/A FM_FW125_CAP 

### 125 #N/A #N/A FM_FW250_CAP 

### 250 #N/A #N/A FM_FW250_CAP 

### 500 #N/A #N/A

FM_ZM20_CAP 

### 20 Screen Width Per Costing Unit (ft) Gross Compliance

O&M FM_ZM125_CAP 

### 125
#N/A #N/A FM_ZM250_CAP 

### 250 #N/A #N/A FM_ZM500_CAP 

### 500 #N/A #N/A 

### O&M

#N/A #N/A 

### Compliance Module Abbreviation debris loading #N/A #N/A FMS_LD_OM 

### Low Debris FMS_HD_OM 

### high Debris **Saltwater** capital Compliance Module Abbreviation distance offshore (m) Capital -- add fine mesh traveling screens w/ fish handling **Very Fine Mesh -- Relocating Intake Offshore with New Passive Screens (Modules 12 & 14)** Capital -- add traveling screens w/ fine mesh only

O&M -- add fine mesh traveling screens (w/ handling)FMS_20_CAP 

### 20 FMS_125_CAP 

### 125 FMS_250_CAP 

### 250 FMS_500_CAP 

### 500 O&M Compliance Module Abbreviation debris loading FMS_LD_OM 

### Low Debris FMS_HD_OM 

### high Debris

### State Name Alaska Alabama Arkansas Arizona California Colorado Connecticut Disrtict of Columbia Delaware Florida Georgia Hawaii Iowa Idaho Illinois Indiana Kansas Kentucky Louisiana Massachusettes Maryland Maine Michigan Minnesota Missouri Mississippi Montana North Carolina North Dakota Nebraska New Hampshire New Jersey New Mexico Nevada New York Ohio Oklahoma Oregon Pennsylvania Puerto Rico Rhode Island **List of States with Freshwater Zebra Mussels as of 2001**

### South Carolina South Dakota Tennessee Texas Utah

Virginia Virgin Islands 2009 Dollars 2002 Dollars Vermont 15 11.5 Washington 0 0

150,000 150,000 0 Wisconsin West Virginia Wyoming

**Freshwater**

Flow per costing unit (gpm) Compliance Capital Compliance Module Abbreviation 0 318,420 PSOS_FW20_CAP 

### 0 413,288 PSOS_FW125_CAP



### 0 669,870 PSOS_FW250_CAP 

### 0 844,049 PSOS_FW500_CAP



### 0 316,335 PSOS_ZM20_CAP 

### 0 411,203 PSOS_ZM125_CAP 

### 0 667,785 PSOS_ZM250_CAP



### 0 841,964 PSOS_ZM500_CAP



### Flow per costing unit (gpm) Compliance O&M Compliance Module Abbreviation

0 #N/A PSOS_LD_OM



### 0 #N/A PSOS_HD_OM 

### w/o zebra mussels **Relocating Intake Offshore with New Passive Screens (Module 4 & 7)**

w/ zebra mussels **Upgrading Existing Offshore Passive Screens (Module 9) Variable Speed Pumps (Module 15)** 

### Saltwater

Flow per costing unit (gpm) Compliance Capital Compliance Module Abbreviation
0 345,205 PSOS_SW20_CAP 

### 0 450,208 PSOS_SW125_CAP



### 0 658,856 PSOS_SW250_CAP 

### 0 917,166 PSOS_SW500_CAP



### Flow per costing unit (gpm) Compliance O&M Compliance Module Abbreviation

0 #N/A PSS_LD_OM



### 0 #N/A PSS_HD_OM



### Freshwater
Flow per costing unit (gpm) Compliance Capital Compliance Module Abbreviation

0 323,860 FMOS_FW20_CAP



### 0 417,073 FMOS_FW125_CAP 

### 0 611,685 FMOS_FW250_CAP 

### 0 841,922 FMOS_FW500_CAP



### 0 322,055 FMOS_ZM20_CAP



### 0 415,268 FMOS_ZM125_CAP 

### 0 600,880 

### 0 840,117 FMOS_ZM500_CAP



### Flow per costing unit (gpm) Compliance O&M Compliance Module Abbreviation
0 #N/A FMOS_LD_OM 

### 0 #N/A FMOS_HD_OM 

### Saltwater
Flow per costing unit (gpm) Compliance Capital Compliance Module Abbreviation w/ zebra mussels **Very Fine Mesh -- Relocating Intake Offshore with New Passive Screens (Modules 12 & 14)**

w/o zebra mussels **Very Fine Mesh -- Upgrading Existing Offshore Passive Screens (Module 13)**0 347,522 FMOS_SW20_CAP 

### 0 442,288 FMOS_SW125_CAP 

### 0 638,750 FMOS_SW250_CAP 

### 0 872,687 FMOS_SW500_CAP



### Flow per costing unit (gpm) Compliance O&M Compliance Module Abbreviation
0 #N/A FMS_LD_OM 

### 0 #N/A FMS_HD_OM

### Abbreviation Zebra Mussels? state state median



### AK No AK 1.26 

### AL Zebra AL 0.82 

### AR No AR 0.81 

### AZ No AZ 0.905 CA No CA 1.11 

### CO No CO 0.93 

### CT Zebra CT 1.07 

### DC No DC 0.948 DE No DE 1.008 FL No FL 0.84 

### GA No GA 0.83 

### HI No HI 1.26 

### IA Zebra IA 0.94 

### ID No ID 0.903 IL Zebra IL 1.03 

### IN Zebra IN 0.96 

### KS No KS 0.96 

### KY Zebra KY 0.91 

### LA Zebra LA 0.83 

### MA No MA 1.11 

### MD No MD 0.93 

### ME No ME 0.95 

### MI Zebra MI 1.01 

### MN Zebra MN 1.09 

### MO Zebra MO 0.98 

### MS Zebra MS 0.78 

### MT No MT 0.93 

### NC No NC 0.77 

### ND No ND 0.86 

### NE No NE 0.85 

### NH No NH 0.94 

### NJ No NJ 1.11 

### NM No NM 0.93 

### NV No NV 1.02 

### NY Zebra NY 1.04 

### OH Zebra OH 0.99 

### OK Zebra OK 0.83 

### OR No OR 1.048 PA Zebra PA 1.01 

### PR No PR 0.876 RI No RI 1.06 **List of States with Freshwater Zebra Mussels as of 2001 Regional Cost Factor Data & State Data** 

### SC No SC 0.76



### SD No SD 0.80 

### TN Zebra TN 0.83 

### TX No TX 0.81 

### UT No UT 0.884

VA No VA 0.86 

### VI No VI 1 VT Zebra VT 0.75 

### WA No WA 1.013

WI Zebra WI 0.99 

### WV Zebra WV 0.96 

### WY No WY 0.841

distance offshore (m) Flow per costing unit (gpm) Compliance Capital

20 0 94,719 

### 125 0 108,400



### 250 0 124,687 

### 500 0 157,260



### 20 0 92,634 

### 125 0 106,315 

### 250 0 122,602



### 500 0 155,175



### debris loading Flow per costing unit (gpm) Compliance O&M

Low Debris 0 #N/A


### high Debris 0 #N/A 

### w/o zebra mussels

w/ zebra mussels **Upgrading Existing Offshore Passive Screens (Module 9)**

O&M

### distance offshore (m) Flow per costing unit (gpm) Compliance Capital 20 0 98,339 

### 125 0 122,155



### 250 0 126,572 

### 500 0 207,212



### debris loading Flow per costing unit (gpm) Compliance O&M

Low Debris 0 #N/A


### high Debris 0 #N/A



### distance offshore (m) Flow per costing unit (gpm) Compliance Capital

20 0 99,538



### 125 0 111,563 

### 250 0 125,879 

### 500 0 154,511



### 20 0 97,733



### 125 0 109,758 

### 250 0 124,074 

### 500 0 152,706



### debris loading Flow per costing unit (gpm) Compliance O&M Low Debris 0 #N/A 

### high Debris 0 #N/A



### distance offshore (m) Flow per costing unit (gpm) Compliance Capital w/o zebra mussels O&M capital

capital O&M w/ zebra mussels **Very Fine Mesh -- Upgrading Existing Offshore Passive Screens (Module 13)**

### 20 0 99,830 

### 125 0 113,409 

### 250 0 129,575 

### 500 0 161,906



### debris loading Flow per costing unit (gpm) Compliance O&M Low Debris 0 #N/A 

### high Debris 0 #N/A 

### O&M

### Module # 0

Northern? (1=0) 1 1 2 0 2a 0 3 0 4 0 5 1 6 1 7 0 8 1 9 0 10 0 10.1 0 10.2 1 10.3 1 10.4 1 11 1 12 1 13 0 14 0 15 1 0 1 1 1 0 0 1 0 1 1 1 1 0 0 1 1 0 1 1 0 1 **Regional Cost Factor Data & State Data**

### 0 1 0 0 1

0 0 1 1

1 0 1

**Freshwater**

Compliance Module Abbreviation Flow per costing unit (gpm) 0 

### Saltwater Compliance Module Abbreviation Flow per costing unit (gpm) 0


### Compliance Module Abbreviation Flow per costing unit (gpm) 0



### Freshwater Compliance Module Abbreviation well depth range (ft)

TSB_FW10_CAP 

### 10

TSB_FW25_CAP 

### 25

**Add Fish Handling & Return to Existing Traveling Screens (Module 1)**

Capital Cost -- Add fish handling & Return (Scenario B) O&M Capital Costs **Velocity Caps (Module 8)**

Capital CostsTSB_FW50_CAP 

### 50

TSB_FW75_CAP 

### 75 TSB_FW100_CAP 

### 100
Compliance Module Abbreviation well depth range (ft) TSB_FW10_OM 

### 10 TSB_FW25_OM 

### 25

TSB_FW50_OM 

### 50

TSB_FW75_OM 

### 75

TSB_FW100_OM 

### 100

**Saltwater** Compliance Module Abbreviation well depth range (ft)

TSB_SW10_CAP 

### 10

TSB_SW25_CAP 

### 25

TSB_SW50_CAP 

### 50 TSB_SW75_CAP 

### 75 TSB_SW100_CAP 

### 75
Compliance Module Abbreviation well depth range (ft)

TSB_SW10_OM 

### 10 TSB_SW25_OM 

### 25 TSB_SW50_OM 

### 50 TSB_SW75_OM 

### 75

TSB_SW100_OM 

### 100

Added Length Fish Return if Canal is Present

Adjustment for Average Cost Fish Return System 

### O&M -- Add fish handling & Return (Scenario B) O&M -- Add fish handling & Return (Scenario B)

Capital Cost -- Add fish handling & Return (Scenario B)Adjustment for High Cost Fish Return SystemUnique ID Design Flow for Traveling Screens Design Flow for

Other Technology Capacity

Cutoff? Zebra Mussel? Module 15 Candidate Impingement

Upgrade? 2 Yr Monitoring

Candidates (1 = Yes) Midwestern

StateDe minimis

Candidate (1 = Yes) Monitoring

Module Screen Velocity

at Existing DIF Existing

Velocity at New DIF Shoreline or

Nearshore (<500 ft) Intake Ocean or

Estuary? Navigation

Traffic? Module Based

on Velocity & Location Fish Return

Addition (1 = "Ave"; 2 ="High")Add Module 5

to Saltwater Assigned

Costing Module Costing Module

Service Life Downtime Flow

Regime Canal length Offshore distance Regional

Capital Cost Factor -> Downtime Cost

(predicted mean) Downtime

Duration (net, weeks)Baseline

Screen Width, Calculated number of

units/flat screen baseline Compliance screen

width for Mod. 3 Number of units

/ New Intake traveling screen number of tscreens per intake number of

velocity cap or AFB units per intake relocation

distance offshore baseline flow

per velocity cap or AFB unit baseline flow

per t-screen unitBaseline Intake

Well Depth Regime Nuclear Capital

Cost Factor Nuclear O&M

Cost Factor for Screens Inflation Factor

for Selected Cost Year Baseline O&M Gross Module O&M Baseline

O&M Fixed Factor Gross

Module O&M Fixed Factor Compliance

Tech CapitalCompliance

Net Annual O&M EG

Downtime Cost One-time

Permit Costs Annual

Monitoring Costs Estimated

Annual Cost per MWh Estimated

Annual Cost per gpm Larger Intake to

Existing Screen Width RatioReflects EPA Assumptions regarding proven effectiveness of each technology 8/03

**Water Type Technology Code**  **Description**

None Either no compliance action or no change in baseline technology operation Freshwater TSB_FW10_OM Traveling Screen or Equivalent with Fish Handling Freshwater TSB_FW25_OM Traveling Screen or Equivalent with Fish Handling Freshwater TSB_FW50_OM Traveling Screen or Equivalent with Fish Handling Freshwater TSB_FW75_OM Traveling Screen or Equivalent with Fish Handling Saltwater TSB_SW10_OM Traveling Screen or Equivalent with Fish Handling Saltwater TSB_SW25_OM Traveling Screen or Equivalent with Fish Handling Saltwater TSB_SW50_OM Traveling Screen or Equivalent with Fish Handling Freshwater TSNF_FW10_OM Traveling Screen or Equivalent without Fish Handling Freshwater TSNF_FW25_OM Traveling Screen or Equivalent without Fish Handling Freshwater TSNF_FW50_OM Traveling Screen or Equivalent without Fish Handling Freshwater TSNF_FW75_OM Traveling Screen or Equivalent without Fish Handling Saltwater TSNF_SW10_OM Traveling Screen or Equivalent without Fish Handling Saltwater TSNF_SW25_OM Traveling Screen or Equivalent without Fish Handling Saltwater TSNF_SW50_OM Traveling Screen or Equivalent without Fish Handling

Water Type Technology Code Mod ule ID# Pilot Study Factor Description

If Waterbody Code = 4 If Waterbody

Code = 3 or 5

` 0 0 0 0 None Freshwater TSB_FW10_CAP 1 0 0 Add traveling screen with fish handling and return without fine mesh screen overlay Freshwater TSB_FW25_CAP 1 0 0 Add traveling screen with fish handling and return without fine mesh screen overlay Freshwater TSB_FW50_CAP 1 0 0 Add traveling screen with fish handling and return without fine mesh screen overlay Freshwater TSB_FW75_CAP 1 0 0 Add traveling screen with fish handling and return without fine mesh screen overlay Freshwater TSC_FW10_CAP 2 0.1 0.1 Add traveling screen with fine mesh screen overlay and fish handling & return Freshwater TSC_FW25_CAP 2 0.1 0.1 Add traveling screen with fine mesh screen overlay and fish handling & return Freshwater TSC_FW50_CAP 2 0.1 0.1 Add traveling screen with fine mesh screen overlay and fish handling & return Freshwater NS_10_CAP 3 0 0 Add new larger screen well structure in front of existing intake Freshwater NS_25_CAP 3 0 0 Add new larger screen well structure in front of existing intake Freshwater NS_50_CAP 3 0 0 Add new larger screen well structure in front of existing intake Freshwater NS_75_CAP 3 0 0 Add new larger screen well structure in front of existing intake Freshwater PS_FW20_CAP 4 0 0.1 Relocate intake from shoreline to near shore with passive t-screens Freshwater PS_ZM20_CAP 4 0 0.1 Relocate intake from shoreline to near shore with passive t-screens Freshwater FBN_A_CAP 5 0 0 Add fish barrier net using anchors and bouys for support Freshwater AFB_CAP 6 0.1 0.1 Aquatic Filter Barrier (Gunderboom) Freshwater PS_FW125_CAP 7 0.1 0.1 Relocate intake 125 m offshore with passive t-screens Freshwater PS_FW250_CAP 7 0.1 0.1 Relocate intake 250 m offshore with passive t-screens Freshwater PS_ZM125_CAP 7 0.1 0.1 Relocate intake 125 m offshore with passive t-screens Freshwater PS_ZM250_CAP 7 0.1 0.1 Relocate intake 250 m offshore with passive t-screens Freshwater PS_ZM500_CAP 7 0.1 0.1 Relocate intake 500 m offshore with passive t-screens Freshwater VCOS_FW_CAP 8 0 0 Add velocity cap to existing submerged offshore intake Freshwater PSOS_FW125_CAP 9 0 0 Add passive t-screens to existing offshore submerged intake Freshwater PSOS_FW20_CAP 9 0 0 Add passive t-screens to existing near shore submerged intake Freshwater PSOS_FW500_CAP 9 0 0 Add passive t-screens to existing offshore submerged intake Freshwater PSOS_ZM125_CAP 9 0 0 Add passive t-screens to existing offshore submerged intake Freshwater PSOS_ZM20_CAP 9 0 0 Add passive t-screens to existing near shore submerged intake Freshwater PSOS_ZM500_CAP 9 0 0 Add passive t-screens to existing offshore submerged intake 10.0 0.1 10.1 0.1 10.2 0 10.3 0 10.4 0 Freshwater TSDF_FW10_CAP 11 0.1 0.1 Add double entry single exit traveling screen with fine mesh screen overlay and fish handling & return Freshwater TSDF_FW25_CAP 11 0.1 0.1 Add double entry single exit traveling screen with fine mesh screen overlay and fish handling & return Freshwater TSDF_FW50_CAP 11 0.1 0.1 Add double entry single exit traveling screen with fine mesh screen overlay and fish handling & return Freshwater TSDF_FW75_CAP 11 0.1 0.1 Add double entry single exit traveling screen with fine mesh screen overlay and fish handling & return 13 0 14 0.1 15 0 0 Variable Speed Pumps

Freshwater TSA_FW10_CAP 2a 0.1 0.1 Add fine mesh screen overlay to existing traveling screen (should already have fish return) Freshwater TSA_FW25_CAP 2a 0.1 0.1 Add fine mesh screen overlay to existing traveling screen (should already have fish return) Freshwater TSA_FW50_CAP 2a 0.1 0.1 Add fine mesh screen overlay to existing traveling screen (should already have fish return)

Freshwater TSCNS_FW10_CAP 3*** 0.1 Add traveling screen with fine mesh and fish handling & return at new intake structure Freshwater TSCNS_FW10_OM 3*** 0.1 Add traveling screen with fine mesh and fish handling & return at new intake structure Freshwater TSCNS_FW25_CAP 3*** 0.1 Add traveling screen with fine mesh and fish handling & return at new intake structure Freshwater TSCNS_FW25_OM 3*** 0.1 Add traveling screen with fine mesh and fish handling & return at new intake structure Freshwater TSCNS_FW50_CAP 3*** 0.1 Add traveling screen with fine mesh and fish handling & return at new intake structure Freshwater TSCNS_FW50_OM 3*** 0.1 Add traveling screen with fine mesh and fish handling & return at new intake structure

Saltwater 0 0 0 None Saltwater TSB_SW10_CAP 1 0 Add traveling screen with fish handling and return without fine mesh screen overlay Saltwater TSB_SW25_CAP 1 0 Add traveling screen with fish handling and return without fine mesh screen overlay Saltwater TSB_SW50_CAP 1 0 Add traveling screen with fish handling and return without fine mesh screen overlay relocate intake with passive t-screens Saltwater TSC_SW10_CAP 2 0.1 Add traveling screen with fine mesh screen overlay and fish handling & return Saltwater TSC_SW25_CAP 2 0.1 Add traveling screen with fine mesh screen overlay and fish handling & return add traveling screen with fish handling and return Saltwater TSC_SW50_CAP 2 0.1 Add traveling screen with fine mesh screen overlay and fish handling & return Saltwater NS_10_CAP 3 0 Add new larger screen well structure in front of existing intake Saltwater NS_25_CAP 3 0 Add new larger screen well structure in front of existing intake Saltwater NS_50_CAP 3 0 Add new larger screen well structure in front of existing intake Saltwater NS_75_CAP 3 0 Add new larger screen well structure in front of existing intake Saltwater PSS_20_CAP 4 0.1 Relocate intake from shoreline to near shore with passive t-screens Saltwater FBN_B10_CAP 5 0 Add fish barrier net using pilings for support Saltwater FBN_B20_CAP 5 0 Add fish barrier net using pilings for support Saltwater AFB_CAP 6 0.1 Aquatic Filter Barrier (Gunderboom) **Baseline O&M Technology**

**Compliance Technologies**Saltwater PSS_125_CAP 7 0.1 Relocate intake 125 m offshore with passive t-screens Saltwater PSS_250_CAP 7 0.1 Relocate intake 250 m offshore with passive t-screens Saltwater VCOS_SW_CAP 8 0 Add velocity cap to existing submerged offshore intake Saltwater PSOS_SW125_CAP 9 0 Add passive t-screens to existing offshore submerged intake Saltwater PSOS_SW20_CAP 9 0 Add passive t-screens to existing near shore submerged intake Saltwater PSOS_SW250_CAP 9 0 Add passive t-screens to existing offshore submerged intake Saltwater PSOS_SW500_CAP 9 0 Add passive t-screens to existing offshore submerged intake 10.0 0.1 10.1 0.1 10.2 0 0 10.3 0 0 Saltwater TSDF_SW10_CAP 11 0.1 Add double entry single exit traveling screen with fine mesh screen overlay and fish handling & return Saltwater TSDF_SW25_CAP 11 0.1 Add double entry single exit traveling screen with fine mesh screen overlay and fish handling & return Saltwater TSDF_SW50_CAP 11 0.1 Add double entry single exit traveling screen with fine mesh screen overlay and fish handling & return Saltwater TSDF_SW75_CAP 11 0.1 Add double entry single exit traveling screen with fine mesh screen overlay and fish handling & return Saltwater PSSVF_20_CAP 12 0.1 Relocate intake from shoreline to near shore with very fine mesh (0.75mm) passive t-screens Saltwater PSOSVF_SW20_CAP 13 0 Add very fine mesh (0.75mm) passive t-screens to existing near shore submerged intake Saltwater PSOSVF_SW125_CAP 13 0 Add very fine mesh (0.75mm) passive t-screens to existing offshore submerged intake Saltwater PSOSVF_SW250_CAP 13 0 Add very fine mesh (0.75mm) passive t-screens to existing offshore submerged intake Saltwater PSOSVF_SW500_CAP 13 0 Add very fine mesh (0.75mm) passive t-screens to existing offshore submerged intake Saltwater PSSVF_125_CAP 14 0.1 Relocate intake 125 m offshore with very fine mesh (0.75mm) passive t-screens Saltwater PSSVF_250_CAP 14 0.1 Relocate intake 250 m offshore with very fine mesh (0.75mm) passive t-screens Saltwater PSSVF_500_CAP 14 0.1 Relocate intake 500 m offshore with very fine mesh (0.75mm) passive t-screens 15 0 0 Variable Speed Pumps

Saltwater TSA_SW10_CAP 2a 0.1 Add fine mesh screen overlay to existing traveling screen (should already have fish return) Saltwater TSA_SW25_CAP 2a 0.1 Add fine mesh screen overlay to existing traveling screen (should already have fish return) Saltwater TSA_SW50_CAP 2a 0.1 Add fine mesh screen overlay to existing traveling screen (should already have fish return)

Saltwater TSCNS_SW10_CAP 0.1 Add traveling screen with fine mesh and fish handling & return at new intake structure Saltwater TSCNS_SW10_OM 0.1 Add traveling screen with fine mesh and fish handling & return at new intake structure Saltwater TSCNS_SW25_CAP 0.1 Add traveling screen with fine mesh and fish handling & return at new intake structure Saltwater TSCNS_SW25_OM 0.1 Add traveling screen with fine mesh and fish handling & return at new intake structure Saltwater TSCNS_SW50_CAP 0.1 Add traveling screen with fine mesh and fish handling & return at new intake structure Saltwater TSCNS_SW50_OM 0.1 Add traveling screen with fine mesh and fish handling & return at new intake structure

Selected if intake already has fish handling & return Selected if intake does not have fish handling & return Was used in conjunction with Module 3 but was replaced with TSDFNS_....)

### Sub AutoInput()

' ' Do not update screen while macro is running Application.ScreenUpdating = False

'

' Sheets("Macro Output").Select Range("A2:BH391").Select Application.CutCopyMode = False Selection.ClearContents

' ' Select Inputs and do calculations for database

' ' Copy Unique ID to Output Database

' Sheets("Macro Input").Select Range("A3:A393").Select Application.CutCopyMode = False Selection.Copy Sheets("Macro Output").Select Range("A2").Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False

' ' Loop through Input Database and Create Results Database

' Counter1 = 2 Do Until Counter1 = 393 ' Copy Input data to User Input Sheet Sheets("Macro Input").Select Range(Cells(Counter1 + 1, 2), Cells(Counter1 + 1, 56)).Select Application.CutCopyMode = False Selection.Copy Sheets("User Inputs").Select Range("C4").Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True

' ' Copy Results to Output Database Sheets("Output").Select Range("C4:C23").Select Application.CutCopyMode = False Selection.Copy Sheets("Macro Output").Select Range(Cells(Counter1, 2), Cells(Counter1, 21)).Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True Sheets("Output").Select Range("F4:F34").Select Application.CutCopyMode = False Selection.Copy Sheets("Macro Output").Select Range(Cells(Counter1, 22), Cells(Counter1, 50)).Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True

### Counter1 = Counter1 + 1

Loop
Application.ScreenUpdating = True

End Sub

### Module #

1 2 2a 3 4 5 6 7 8 9 10.0 10.1 10.2 10.3 10.4 11 12 13 14 15

### Description

Replace Traveling Screen with Ristroph Screen and Add Fish Handling and Return System Replace Traveling Screen with Fine Mesh Ristroph Screen and Add Fish Handling and Return System Add Fine Mesh Screen Overlays Only Add New Larger Intake Structure with Double Entry, Single Exit Traveling Screen with Fish Handling and Return Add Passive Fine Mesh Wedgewire Screens (1.75 mm mesh) at Shoreline Add Fish Barrier Net Add Aquatic Filter Barrier (Gunderboom) Relocate Intake to Submerged Offshore with Passive Wedgewire Screen (1.75 mm mesh) Add Velocity

Cap at Inlet Add Passive Fine Mesh Wedgewire Screen (1.75 mm mesh) at Inlet of Offshore Submerged Combination of Module 2 and Module 5 Combination of Module 2a & Module 5 Combination of Module 3 & Module 5 Combination of Module 1 & Module 5 Combination of Module 1 & Module 8 Add Double-Entry, Single-Exit Traveling Screen with Fish Handling and Return 0.75 mm Passive Fine Mesh Wedgewire Screen at Shoreline (For Estuary & Ocean only) 0.75 mm Passive Fine Mesh Wedgewire Screen at Inlet of Offshore Submerged (For Estuary & Ocean only) Relocate Intake to Submerged Offshore with 0.75 mm Passive Wedgewire Screen (For Estuary & Ocean only) Variable Speed Pumps **Costing Module Legend**