General
Rational Method Hydrologic Calculations with Excel
Credits: 2 PDHCourse Description
The Calculation of peak storm water runoff rate from a drainage area is often done with the Rational Method equation (Q = CiA). A spreadsheet for making Rational Method calculations, including determination of design rainfall intensity and time of concentration, is included with this course. The course includes example calculations and discussion of example solutions with the course spreadsheet. The parameters in the equations are defined with typical units for both U.S. and S.I. units.
Topics
At the conclusion of this course, the student will
- Know the parameters and their U.S. and S.I. units to be used in the Rational Method equation
- Be able to calculate peak storm water runoff rate with the Rational Method equation, using either U.S. or S.I. units
- Be able to place a given soil into one of the four SCS soil groups based on its measured minimum infiltration rate
- Be able to place a given soil into one of the four SCS soil groups based on its description
- Be able to determine a value of the Rational Method runoff coefficient based on land use, soil group, and slope of the watershed
- Be able to calculate the overland sheet flow travel time for a watershed using the Manning Kinematic equation
- Be able to calculate the shallow concentrated flow travel time for a watershed using the NRCS method
- Be able to calculate the open channel flow travel time for a watershed using the Manning equation
- Know the form of the equation used for rainfall intensity as a function of storm duration for a specified return period.
- Be able to use the course spreadsheet to make the types of calculations discussed in this course.
This course is intended for hydrologists, civil engineers, hydraulic engineers, highway engineers, environmental engineers and mechanical engineers.
After completing this course you will be able to calculate peak storm water runoff rate using the Rational Method equation in either U.S. or S.I. units, including determination of runoff coefficient, calculation of time of concentration, and determination of design rainfall intensity. You will also be prepared to use Excel spreadsheets to efficiently make the calculations.
Instructor: Harlan Bengston, PhD, PE