Online Courses

Discount Packages

Engineering Ethics

Live Webinars

Video Presentations

Interactive Courses

Courses by Provider

Rational Method Hydrologic Calculations with Excel

COURSE NO: C02-039
PDH CREDIT: 2
Rational Method Hydrologic Calculations with Excel
Course Highlights

This online engineering PDH course will enable you 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.  It will also prepare you for the use of Excel spreadsheets to efficiently make the calculations.

 

Calculation of peak storm water runoff rate from a drainage area is often done with the Rational Method equation (Q = CiA). Calculations with the Rational Method equation often involve determination of the design rainfall intensity and the time of concentration of the watershed as well. An Excel spreadsheet for making these types of calculations is included with this course.  Example calculations and examples using the course spreadsheet for Rational Method equation calculations and for determination of the design rainfall intensity and the time of concentration of the drainage area, are presented and discussed in this course.  The parameters in the equations are defined with typical units for both U.S. and S.I. units.

 

This 2 PDH online course is applicable primarily to civil engineers, hydraulic engineers, highway engineers, and environmental engineers, design professionals, technical and construction personnel who are interested in gaining a better understanding of the rational method hydrologic calculations using Excel.

Learning Objectives

This P.Eng. continuing education course is intended to provide you with the following specific knowledge and skills:

  • Knowing the parameters and their U.S. and S.I. units to be used in the Rational Method equation
  • Ability to calculate peak storm water runoff rate with the Rational Method equation, using either U.S. or S.I. units
  • Ability to place a given soil into one of the four SCS soil groups based on its measured minimum infiltration rate
  • Ability to place a given soil into one of the four SCS soil groups based on its description
  • Ability to determine a value of the Rational Method runoff coefficient based on land use, soil group, and slope of the watershed
  • Ability to calculate the overland sheet flow travel time for a watershed using the Manning Kinematic equation
  • Ability to calculate the shallow concentrated flow travel time for a watershed using the NRCS method
  • Ability to calculate the open channel flow travel time for a watershed using the Manning equation
  • Knowing the form of the equation used for rainfall intensity as a function of storm duration for a specified return period
  • Ability to use the course spreadsheet to make the types of calculations discussed in this course
Course Document

In this professional engineering CEU course, you need to review the course document tilted, "Rational Method Hydrologic Calculations with Excel".

To view, print and study the course document, please click on the following link(s):
Rational Method Hydrologic Calculations with Excel (1.7 MB)
Storm Water Runoff Package Spreadsheet - U.S. Units (330 KB)
Course Quiz
Once you complete your course review, you need to take a multiple-choice quiz consisting of ten (10) questions to earn 2 PDH credits. The quiz will be based on the entire document.

 

The minimum passing score is 70%. There is no time limit on the quiz, and you can take it multiple times until you pass at no additional cost.
Certificate of Completion

Upon successful completion of the quiz, print your Certificate of Completion instantly. (Note: if you are paying by check or money order, you will be able to print it after we receive your payment.) For your convenience, we will also email it to you. Please note that you can log in to your account at any time to access and print your Certificate of Completion.

To buy the course and take the quiz, please click on: