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 factor
1

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 Technologies 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 Technologies 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 0 gpm Downtime Flow Regime #N/A

Design Flow for Other Technology 0 gpm Canal Length 0 ft

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/A m

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 Modu

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 handling
TSNF_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

12

1 500 500 2 125 125 3 500 500 4 125 125 5 125 125

Interim Calculation #N/Am

Relocation Distance #N/Am
Screen Well Depth

Default screen 

well depth 

Regime

#N/A #N/A

een (1.75 mm mesh)

of Offshore Submerged

Module 2a & 5; 10.2 Comb Module 3 & 5; 10.3 Comb Module 1 & 5; 10.4 comb Module 1 & 8

tuary & Ocean only)

Submerged (For Estuary & Ocean only)

ssive 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.49

Compliance 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.48

Compliance 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 handlin
#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.38

Compliance 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 handlin

Capital -- add traveling screens w/ fine mesh only

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

456

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

ns w/ Fish Handling & Return (Module 2)

Capital -- add traveling screens w/ fine mesh only

Relocating Intake Offshore with New Passive Screens (M

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

Variable Speed Pumps (M

pital -- 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)

pital -- add fine mesh traveling screens w/ fish handling

Very Fine Mesh -- Relocating Intake Offshore with New Passive Scre

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

Offshore with New Passive Screens (Module 4 & 7)

w/ zebra mussels

Upgrading Existing Offshore Passive 

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

Intake Offshore with New Passive Screens (Modules 12 & 14)

w/o zebra mussels

Very Fine Mesh -- Upgrading Existing Offshore 
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

t 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

or 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 Costs
TSB_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 System

Unique 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 

State







De 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 unit







Baseline 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 Capital







Compliance 

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 Ratio
Reflects 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