Contraction Scour

This is a Microsoft Excel spreadsheet that uses the procedure described in Hydraulic Engineering Circular 18 to calculate contraction scour at a bridge during live bed conditions.

Culvert Bed Material Design    

Please contact the HQ Hydraulics office for more information.

Culvert Corrosion

This program calculates the design life of a metal culvert using CalTrans methodology based on corrosion from the surrounding soil and the flow of the culvert. Typically, WSDOT does not use this approach, but the underlying theory is valid.

HY-8 *

HY8 link is a DOS based software primary for designing and analyzing culverts (hydraulics only, nothing regarding structural). It can also be used to design an energy dissipater. Most culvert shapes are supported by this program, including arches and pipe arches, and there is an option for inputting irregular shapes. The program link is DOS format and very simple to use, even without documentation. If you are within the DOT, we would recommend using the latest window version of HY8-version, it is more stable. If you would like to have the new Window Version, please contact your IT/MIS support staff so they can install it on your system.
* Window HY-8 version example (pdf 1.75 mb) link

Hydrology

This Microsoft Excel spreadsheet calculates peak flows for small drainage areas that can be either natural or developed. It uses the rational method as described in the WSDOT Hydraulics Manual.

Local Pier Scour

This is a Microsoft Excel spreadsheet that uses the procedure described in Hydraulic Engineering Circular 18 to calculate local pier scour at a bridge.

Pipe Angle Calculation Worksheet

Before finalizing the storm drain layout, designers should verify the layout is constructible with respect to the angle between pipes entering or exiting a junction. That is, in order to maintain the structure integrity of a junction there are minimum clearance requirements that must be met depending on the pipe diameter. Designers can verify the minimum pipe angle with the Pipe Angle Calculation Worksheet at the following link.

Storm Drain Design
Metric
English

This Microsoft Excel spreadsheet accomplishes a storm sewer design using the rational method, as described in the WSDOT Hydraulics Manual.

USGS Regression Spreadsheet

This is a Microsoft Excel spreadsheet that calculates runoff using the 2001 version of the USGS regression equations for Washington State. The user should have a 2004 copy of the WSDOT Hydraulics Manual or USGS Fact Sheet 016-01 to determine the input parameters. We are currently working with MIS to deploy the National Flood-Frequency (NFF) program statewide. Until then, the spreadsheets can be used.

Western Washington Highways Hydrology Analysis Model (WHAM)*

The public domain version of MGSFlood, now known as WHAM (Western Washington Highways Hydrology Analysis Model), was developed for the Washington State Department of Transportation by MGS Engineering Consultants. WHAM includes all features of the proprietary version of MGSFlood except the following:

• Pond optimization
• Ability to define pond geometry
• Hydraulic structures input
• Sand filter structure input

* This program was developed for Windows 2000. It is also compatible with Windows XP.

WHAM Training Manual
(MS Word)
This manual is for the routing table design, not the optimization.

If using the routing table, use this link for the Pond Hydraulics Excel spreadsheet.

WHAM is a general, continuous, rainfall-runoff computer model developed specifically for stormwater facility design in the lowlands of Western Washington. The program uses the Hydrological Simulation Program-Fortran (HSPF) routine for computing runoff from rainfall. The program includes a routing routine that uses a stage-storage-discharge rating table to define stormwater retention/detention facility or reservoir, routines for computing streamflow magnitude-frequency and duration statistics, and graphics routines for plotting hydrographs, streamflow frequency, and duration characteristics. The program meets the requirements for the 2001 Washington State Department of Ecology Stormwater Management Manual for Western Washington.

An optimization routine is available, but it is not included in WHAM, the public domain version of the program. The optimization routine is available through MGS Software.

WHAM Stormwater Model for Stormwater Facility Design, Training Workshop Slides
(pdf 1.5 mb)

Water Quality Wet Pond Calculator

WHAM Users Manual
(pdf 990kb)

Inlet Analysis Spreadsheets

Inlet Spacing with Side Flow 
    (English)
   

This Microsoft Excel spreadsheet combines the procedures described in the WSDOT Hydraulics Manual to calculate roadway runoff and inlet interception for a roadway. For roadways on a longitudinal slope greater than 2% and with velocities between 3-5 ft/s the spreadsheet uses the methods described in the Hydraulics Manual section 5-5.1 Capacity of Inlets on a Continuous Grade. For velocities less than 3ft/s and have longitundal slopes less than 2%, this spreadsheet will also consider the side flow interception as described in the Hydraulics Manual section 5-5.2 Side Flow Interception.

Sag Worksheet

This is a Microsoft Excel spreadsheet that uses the procedure described in the WSDOT Hydraulics Manual to locate inlets in a sag condition.

Short Duration Rainfall Depth Converter

This spreadsheet converts the 2 year, 2 hour storm to the 3 hour storm for any of the four Eastern Washington Climatic Regions. For further explanation of how to calculate the 3 hour storm, see Appendix 4D of the Highway Runoff Manual.