Rational Method Hydrologic Calculations using Excel Spreadsheets
Credits: 2 PDH
PDH Course Description:
Calculation of peak storm water runoff rate from a drainage area is often done with the Rational Method equation (Q = CiA). Use of Excel spreadsheets for calculations with this equation and for determination of the design rainfall intensity and the time of concentration of the drainage area, are included in this course. The parameters in the equations are defined with typical units for both U.S. and S.I. units.Topics:
Following the completion 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 familiar with methods for using Excel spreadsheets to make the types of calculations discussed in this course.
To take this course:
1.) Enroll in Course: Click below to enroll:
(must be logged into your user account)
Download the Study Guide
3.) Test: Once you've thoroughly read the course materials, please click below to take the final examination.
Take the final exam
4.) Certificate: A passing grade of 70% or higher on the exam, is required to receive the certificate of completion for this PDH course.
NOTE: After the exam is completed, you will need to return to this page, in order to print (download) the certificate of completion.
Print the Certificate of Completion>
Note from Author: 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.
Intended Audience: civil engineers, hydraulic engineers, highway engineers, and environmental engineers.
Publication Source: Harlan H. Bengtson, PhD, PE
Print the Certificate of Completion>
Note from Author: 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.
Intended Audience: civil engineers, hydraulic engineers, highway engineers, and environmental engineers.
Publication Source: Harlan H. Bengtson, PhD, PE
Harlan Bengtson PhD, PE