PIMA COUNTY REGIONAL FLOOD CONTROL DISTRICT

MAXIMUM ANTICIPATED SCOUR DEPTH ( ZT ) FOR SIMPLE CURVED AND STRAIGHT REACHES OF

WITH OPTIONAL LOCAL SCOUR AT ABUTMENTS AND BRIDGE PIERS, WITHOUT LOCAL SCOUR A

Please read and understand the following important application notes rega

1. This spreadsheet is best viewed using 1152 by 864 (or finer) screen resolution, and with EXCEL's horizontal and vertical s
"MAXIMUM ANTICIPATED SCOUR DEPTH" (MASD) tab to the limits of your computer screen. You can change your screen
removed in EXCEL through the Tools menu, followed by the Options button, then the view tab. Uncheck both vertical and ho
and using arrow keys.

2. This spreadsheet will accept hydraulic characteristics for up to 5 separate conveyances. Each of these conveyances may
only a subsection of an individual hydraulic cross section. If your application is one of calculating maximum anticipated scou
(EHSB) of the main channel portion of a hydraulic cross section, then hydraulic characteristics for the main channel portion o
Similarly, the hydraulic characteristics input to the worksheet would be for the main channel if calculating local scour depth fo
the EHSB of the main channel. However, if your application is maximum anticipated scour depth calculation for a developme
then the hydraulic characteristics input into the worksheet would be for the appropriate overbank protion of the hydraulic cros
flow areas would use hydraulic characterists for a relatively flat hydraulic cross section which may or may not have a defined

3. Hydraulic characteristics for each of the 5 separate conveyances are typically derived from HEC-2 or HEC-RAS. These c
any other hydraulic program, for that matter) may be pasted into the appropriate cells of the worksheet at the "RAS OUT" tab
(MASD) tab automatically references data pasted accordingly in the RAS OUT worksheet. If you wish to manually input som
overwriting the unprotected refrencing equations in the blue-dot shaded cells of the MASD worksheet.

4. Because this spreadsheet does not perform normal depth or backwater calculations (you to execute HEC-2, HEC-RAS, F
evaluate the hydraulic characteristics, and then input them into the worksheet), it is possible to manually input combinations o
is your responsibility to verify that the hydraulic characteristics which you input into the spreadsheet actually represent the pro

5. This spreadsheet has the ability to calculate local scour components due to piers or abutments. In addition, this spreadsh
prescribed in the publication titled: Standards Manual for Drainage Design and Floodplain Management in Tucson, Arizona (7
at Bridges (5/01). The latter publication is also referred to as FHWA HEC-18. Links for both publications are presented belo
separate flow depth may be entered for the pier scour calculations but not for the abutment calculations. Abutment calculatio
separate Safety Factor (SF) may be entered for these local scour components.

Blue shaded cells are for input data and information.

Yellow shaded cells are for final calculated output.
Equations in blue-dot shaded cells may be overwritten.
Non-colored (white) shaded cells are calculated or copied.

http://www.fhwa.dot.gov/eng

Excel
Notes:

Calc
Notes:

http://tdotmaps.transview.org/mandr/Download/

Screen Resolution of 1152

To avoid "DIVIDE BY ZER
To calculate scour at more
tab and create additional

(form rev. 11/05/08)

L FLOOD CONTROL DISTRICT

AND STRAIGHT REACHES OF NON-REGIONAL SAND BED CONVEYANCES

RS, WITHOUT LOCAL SCOUR AT DROPS OR LONG TERM DEGRADATION

portant application notes regarding this program:

XCEL's horizontal and vertical scroll bars turned off. This will fit the entire worksheet at the
n. You can change your screen resolution using the Windows operating system. Scroll bars are
b. Uncheck both vertical and horizontal scroll bars; move through worksheet by clicking on a cell

Each of these conveyances may be individual complete hydraulic cross sections, or each may be
ating maximum anticipated scour depth for an encroachment within the Erosion Hazard Setback
s for the main channel portion of the hydraulic cross section would be input into the worksheet.
calculating local scour depth for piers and/or abutments located within the main channel, or within
epth calculation for a development within the floodplain but beyond the EHSB of the main channel,
ank protion of the hydraulic cross section. Maximum anticipated scour depth calculations in sheet
may or may not have a defined main channel.

m HEC-2 or HEC-RAS. These characteristics in the form of output from HEC-2 or HEC-RAS (or
worksheet at the "RAS OUT" tab. The worksheet at the "MAX ANTICIPATED SCOUR DEPTH"
you wish to manually input some of all of the hydraulic characteristics, this is accomplished by
orksheet.

to execute HEC-2, HEC-RAS, FLOWMASTER, or other normal depth or backwater program to

o manually input combinations of hydraulic characteristics which cannot be attained physically. It
dsheet actually represent the problem you are working with.

ments. In addition, this spreadsheet can calculate these components by two methods: that
anagement in Tucson, Arizona (7/98), and that prescribed in the publication titled: Evaluating Scour
publications are presented below. Note that in calculating these local scour components, a
alculations. Abutment calculations use the hydraulic depth for the conveyance. In addition, a

http://www.fhwa.dot.gov/engineering/hydraulics/library_arc.cfm?pub_number=17&id=37
Screen Resolution of 1152 x 864 w/o scroll bars will display worksheet on one screen.
To avoid "DIVIDE BY ZERO" ERROR, erase data using: RT CLK, CLEAR CONTENTS.
To calculate scour at more sections, right click MAX ANTICIPATED SCOUR DEPTH
tab and create additional copies of the worksheet.

DATE
6/2/2009

INPUT
FILE
SCOUR08

OUTPUT
FILE
SCOUR09

SUMMARY OF CHANGES:

1. Added CHRONOLOGY worksheet in order to track changes to the Maximum

2. Modified SMDDFM Abutment scour calculations to remove HIRE factor (K 2 =

In relation to this change, also modified this method to calculate abutment scou
variable identifications as those used in the SMDDFM. Finally, modified Abutme

3. Modified HEC-18 abutment scour calculations to reflect L' representing the le

flow (to be consistent with the definition of this variable in the HEC-18 book). Al

er to track changes to the Maximum Anticipated Scour Spreadsheet.

ulations to remove HIRE factor (K 2 = (U/90)0.13) to adjust for angle of embankment with respect to bank.
method to calculate abutment scour exactly as illustrated in the SMDDFM, and using the same
SMDDFM. Finally, modified Abutment Tab to clarify the meaning of Ua.

ations to reflect L' representing the length of obstructing embankment, measured normal to direction of
his variable in the HEC-18 book). Also modified associated Abutment Tab to clarify this meaning.

PIMA COUNTY REGIONAL FLOOD CONTROL DISTRICT

MAXIMUM ANTICIPATED SCOUR DEPTH ( ZT ) FOR SIMPLE CURVED AND STRAIGHT REACHES OF NON-REGIONAL SAND BED CONVEYANCES
WITH LOCAL SCOUR AT ABUTMENTS AND BRIDGE PIERS
W/O LOCAL SCOUR AT DROPS OR LONG TERM DEGRADATION

ADDRESS
NAME

Step 1. Enter Project Information.

Project Address
Data Sheet Preparer
Conveyance Subsection

N/A

N/A

N/A

N/A

425

500

575

=
ae =
a =

(deg)

Bend angle (See BENDS tab)

N
N

N
N

N
N

N
N

N
N

(ft)
(deg)

Length of abutment projected normal to flow

Slope angle of abutment face from horizontal

L' =
K1 =
=
bp =
L=
Y1 =
RF =
p =

N
N
N

N
N
N

15.83
1
22

N
N
N

N
N
N

(ft)
(dim)
(deg)

Length of abutment projected normal to flow

Coefficient for abutment shape (See ABUTMENTS tab)
Abutment angle wrt bank (See ABUTMENTS tab)

N
N
N
N
N

N
N
N
N
N

N
N
N
N
N

N
N
N
N
N

N
N
N
N
N

(ft)
(ft)
(ft)
(dim)
(deg)

Pier width, including anticipated debris blockage

Length of pier wall
Flow depth upstream of pier (blank = max depth)
Reduction factor for nose shape (See PIERS tab)
Angle of approach flow in relationship to pier wall

Step 4b. Pier scour per HEC-18 (FHWA NHI 01-001 5/01)?
Enter N if no local pier scour.
If Yes, enter a, L, K1, K3, p, Y1, D50, & D95.

a=
L=
K1 =
K3 =
p =
Y1 =
D50 =
D95 =

N
N
N
N
N
N
N
N

N
N
N
N
N
N
N
N

N
N
N
N
N
N
N
N

N
N
N
N
N
N
N
N

N
N
N
N
N
N
N
N

(ft)
(ft)
(dim)
(dim)
(deg)
(ft)
(mm)
(mm)

Pier width, including anticipated debris blockage

Length of pier wall
Correction factor for nose shape (See PIERS tab)
Correction factor for bed condition (See PIERS tab)
Flow direction with respect to pier wall
Flow depth upstream of pier (blank = max depth)
Grain size for which 50% of bed material is finer
Grain size for which 95% of bed material is finer

Step 5. Enter safety factor for local (pier, abutment) scour.

SF =

1.3

1.3

1.3

1.3

1.3

(dim)

Blank = 1.3; text = 0

Step 2. Bend Scour? Enter N if no bend scour.

If Yes, Enter .

SEC =

Step 3a. Abutment scour per SMDDFM? Enter N if no.

If Yes, Enter ae & a.
Step 3b. Abutment scour per HEC-18 (FHWA NHI 01-001 5/01)?
Enter N if no local abutment scour.
If Yes, Enter L', K1, & .
Step 4a. Pier scour per SMDDFM?
Enter N if no local pier scour.
If Yes, enter Y1, bp, L, p & RF.

N/A

(form rev. 06/01/09)

Description

Step 6. Enter hydraulic characteristics for up to 5 sections in the blue fields below. HEC-RAS output may be pasted into RAS OUT tab to facilitate data entry.
INPUT HYDRAULIC CHARACTERISTICS OF CONVEYANCE
S

WSL

ELMN

SE

E
C

(fps)

(ft2)

(ft)

(ft)

(ft)

(dim)

(cfs)
V*A

425
500
575
0
0

8.5
5.8
6.2
0.0
0.0

87.2
130.6
140.9
0.0
0.0

60.7
89.5
72.3
0.0
0.0

2556.3
2558.0
2559.0
0.0
0.0

2554.1
2555.1
2555.7
0.0
0.0

0.034
0.012
0.010
0.000
0.000

741
757
0
0
0

CALCULATED CHARACTERISTICS
YH
YMAX
Fu
(ft)

rC/T

(dim)
Eq 8.3

(dim)

A/T

(ft)
wsl-elmn

1.4
1.5
1.9
0.0
0.0

2.2
2.9
3.3
0.0
0.0

1.2
0.8
0.8
0.0
0.0

0.0
0.0
0.0
0.0
0.0

CALCULATED INDIVIDUAL SCOUR COMPENENTS (ft)

ZGS
ZBS
ZA
ZLSP
ZLSE
ZLSP
SMDDFM SMDDFM SMDDFM SMDDFM SMDDFM
Eq 6.4
Eq 6.6
Eq 6.5
Eq 6.9
6.11/6.12

0.0
0.0
0.0
0.0
0.0

0.0
0.0
0.0
0.0
0.0

1.0
0.5
0.5
0.0
0.0

0.0
0.0
0.0
0.0
0.0

0.0
0.0
0.0
0.0
0.0

ZLSE

HEC-18
Eq 6.1

HEC-18
Eq 7.1/7.2

0.00
0.00
0.00
0.00
0.00

0.0
0.0
9.8
0.0
0.0

ZLF

ZT
(ft)
Eq 6.3

1.0
1.0
1.0
0.0
0.0

2.6
1.9
14.7
0.0
0.0

PIMA COUNTY REGIONAL FLOOD CONTROL DISTRICT

MAXIMUM ANTICIPATED SCOUR DEPTH (ZT) FOR CURVED AND STRAIGHT REACHES OF NON-REGIONAL SAND BED CONVEYANCES
WITH LOCAL SCOUR AT ABUTMENTS AND AT BRIDGE PIERS
WITHOUT LOCAL SCOUR AT DROPS AND LONG TERM DEGRADATION

Area to Paste Output from HEC-RAS or Other Backwater / Hydraulic Analysis Program for Input into Scour Spr
Reach

River Sta

Profile

Velocity

Area

(ft/s)

(ft2)

OL DISTRICT

N-REGIONAL SAND BED CONVEYANCES

Thursday, October 06, 2016
(form rev. 11/05/08)

lic Analysis Program for Input into Scour Spreadsheet

Top Width

W.S. Elev

Min Elev

E.G. Slope

(ft)

(ft)

(ft)

(ft/ft)

PIMA COUNTY REGIONAL FLOOD CONTROL DISTRICT

MAXIMUM ANTICIPATED SCOUR DEPTH (ZT) FOR CURVED AND STRAIGHT REACHES OF NON-REGIONAL SAND BED CONVEYANCES
WITH LOCAL SCOUR AT ABUTMENTS AND AT BRIDGE PIERS
WITHOUT LOCAL SCOUR AT DROPS AND LONG TERM DEGRADATION
Variable

Units Definition

(deg)

A
ae

(deg)

(deg)

Projection angle of channel centerline from point of curvature to point which meets tangent to outer channe
Embankment angle to flow, Fig 7.1 Highways in the River Environment (HIRE), 12/01 (see TABLES tab).

(sq.ft)

Slope angle of abutment face, measured from the horizontal, for calculation of local abutment scour by the
Flow diredtion with respect to pier wall
Ratio of circumfrence to diameter of a circle; 3.14159
Cross sectional flow area of conveyance

(ft)

Embankment or encroachment length, measured normal to flow direction for calculation of local abutment s
Pier width measured normal to flow direction
Thalweg elevation

(rad)
(dim)

bp

(ft)

ELMIN
Fu

(ft)
(dim)

Upstream froude number

(ft/s )

K2

(dim)

Acceleration due to gravity, 32.2 ft/s2

Factor to account for effect of embankment angle to flow on local scour due to embankment; K

L
L'
Q
RF
rc

(ft)

(ft)
(cfs)
(dim)
(ft)

Length of pier wall

Embankment or encroachment length, measured normal to flow direction for calculation of local abutment s
Discharge within conveyance
Reduction factor based on pier shape (see TABLES tab)
Radius of curvature along centerline of channel at cross section

rc/T

(dim)

SEC
SE

Ratio of radius of curvature of centerline of bend in a conveyance, to top width of flow in the conveyance
Identification number or letter for cross section

(dim)

(ft)

Energy slope
Top width of flow for conveyance
Average flow velocity in conveyance
Water surface elevation within conveyance

(ft)

Hydraulic depth

YMAX

(ft)

Z
ZGS

(dim)

Maximum flow depth

Horizontal run length for one foot of rise, for an embankment face

(ft)

General scour depth (general scour is caused by a discontinuity in the sediment-transport capacity of the fl

ZA

(ft)

Anti-Dune trough depth (Anti-dune scour is caused by the formation of anti-dunes in the bed of the conveya

ZLSE

(ft)

Local scour depth due to abutment or fill pad encroachment into flow path (Local scour occurrs due to abru

ZLSP

(ft)

Local scour depth due to pier within flow path

ZBS

(ft)

Bend scour depth (bend scour is caused by transverse currents within the flow through a bend in the conve

ZLF

(ft)

Low flow thalweg depth

ZT

(ft)

Maximum anticipated scour depth (summation of all individual scour components, multiplied by a 30% safe

T
V
WSEL
YH

(ft)
(ft/s)

TRICT

BED CONVEYANCES
Thursday, October 06, 2016
(form rev. 6/01/09)

ts tangent to outer channel bank

2/01 (see TABLES tab). <90 if embankment points downstream

cal abutment scour by the method of the SMDDFM

culation of local abutment scour by the method of the SMDDFM

mbankment; K 2 = (/90)0.13 (ref. Equ 7.16, HIRE 12/01).

culation of local abutment scour by the method of HEC-18

flow in the conveyance

transport capacity of the flow), NON-REGIONAL WATERCOURSE ONLY

s in the bed of the conveyance)

scour occurrs due to abrupt changes in flow direction)

rough a bend in the conveyance)

s, multiplied by a 30% safety factor to account for non-uniform flow distribution)

TABLE 6.1:

REDUCTION FACTORS (RF) TO BE USED WHEN APPLYING SCOUR

FORMULAS FOR SQUARE-NOSED PIERS TO OTHER SHAPES
(assuming equally projected widths of piers)

Type of Pier
Square Nose
Cylinder
Round Nose
Sharp Nose
Group of Cylinders

Reduction Factor
1.0
0.9
0.9
0.8
0.9

Thursday, October 06, 2016