Skip Top Navigation

Program Downloads: Hydraulic and Hydrologic

Items marked with an asterisk (*) are compressed and require WinZip for browsing. An evaluation version of WinZip can be downloaded for free.

Viewing PDF files
Items in pdf format can be viewed using Adobe Acrobat Reader, which can be downloaded free of charge.

Program Downloads
Hydrology (xls, 23kb)
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. 

Pipe Angle Calculation Worksheet (xls, 217kb)
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 (xls, 114kb)     English (xls 245kb)
This Microsoft Excel spreadsheet accomplishes a storm sewer design using the rational method, as described in the WSDOT Hydraulics Manual.

USGS Regression Spreadsheet (xls, 235kb)
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.

If using the routing table, use this link for the Pond Hydraulics Excel spreadsheet. (xls, 49kb)

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.

Water Quality Wet Pond Calculator (xls, 19kb)

Inlet Spacing Analysis Spreadsheets
Inlet Spacing Spreadsheet (xls, 167kb)
This Microsoft Excel spreadsheet combines the procedures described in the WSDOT Hydraulics Manual to calculate roadway runoff and inlet interception of a continuous curb and gutter run for a roadway.

Sag Worksheet (xls, 60kb)
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 (xls, 38kb)
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.