LF logo
by learnformula
search
Log in
search
Courses/Engineering/Hydraulic and Water Resources Engineering

Rational Method Hydrologic Calculations with Excel

Intended Audience: civil engineers, hydraulic engineers, highway engineers, and environmental engineers.

Created byHarlan Bengtson, PhD, PE
4.6
(42 reviews)
BeginnerUpdated May 3, 2022
Rational Method Hydrologic Calculations with Excel

What You'll Learn

check_circleUnderstand the parameters of the Rational Method equation and their units in both U.S. and S.I. systems.
check_circleLearn to calculate peak storm water runoff rates using the Rational Method equation, including determining runoff coefficients and rainfall intensity.
check_circleGain the ability to compute travel times for overland sheet flow, shallow concentrated flow, and open channel flow using appropriate methods.
check_circleFamiliarize with Excel spreadsheet techniques to efficiently perform storm water runoff calculations, including time of concentration and design rainfall intensity.

About This Course

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.

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

Your Instructor

Harlan Bengtson, PhD, PE
Harlan Bengtson, PhD, PE
menu_book73 courses
star2,706 reviews

Dr. Harlan Bengtson is an online PDH course provider of continuing education courses for professional engineers. Dr. Bengtson is a graduate of Iowa State University with B.S. and M.S. degrees and of the University of Colorado with a PhD. He is a licensed Professional Engineer in Missouri. Dr. Bengtson has spent 30 years in engineering education in teaching and administrative positions, including six years as Dean of Engineering at Southern Illinois University Edwardsville. Dr. Harlan H. Bengtson, PE 33 Grainey Drive Glen Carbon, IL 62034 Phone: (618) 406-6892 E-mail: hnkbengtson@yahoo.com PROFESSIONAL PROFILE Dr. Bengtson is a graduate of Iowa State University with B.S. and M.S. degrees and of the University of Colorado with a PhD. He is a licensed Professional Engineer in Missouri. He has spent 30 years in engineering education in teaching and administrative positions, including six years as Dean of Engineering at Southern Illinois University Edwardsville. His areas of expertise are environmental engineering, hydrology and hydraulics, engineering science and renewable energy systems. He has done regular consulting work while holding the academic positions. Prior to entering academia, Dr. Bengtson worked for Minnesota Mining & Manufacturing as a Product Development Engineer and for E. I. duPont deNemours as a Process Development Engineer. Dr. Bengtson has authored numerous publications, presentations and technical reports. He is currently active as a freelance technical writer, author of continuing education courses for Professional Engineers, and is the founder of www.engineeringexceltemplates.com and www.EngineeringExcelSpreadsheets.com, sites with the objective of providing inexpensive, easy to use Excel spreadsheets for a variety of engineering calculations.

Credit Information

Do these courses count toward my professional development requirements?

This portal is provided as a training and development resource for City of Markham employees. Every course is delivered by a qualified subject matter expert or learning organization, is quantifiable in hours, and is verifiable — you receive a documented certificate of completion for every course you finish, stored on LearnFormula indefinitely.

If you hold a professional designation (for example in engineering, accounting, human resources, or law), courses may be counted as professionally relevant, verifiable learning activities toward your continuing professional development. Individual practitioners are responsible for confirming that an activity meets the requirements of their professional body. For questions about the City of Markham's training and development policies, please speak with your people leader or Human Resources.

What Students Are Saying

4.6
Student's Choice
42 reviews

Frequently Asked Questions

We are a registered provider with 327+ associations and regulatory bodies worldwide. We operate across 29 global markets including Canada, the US, Australia, and the UK. Every course page clearly displays its specific accreditations. Upon completion, you receive a professional certificate that can be validated online. Our certificates include all necessary accreditation details, credit hours, and completion dates, and are formatted specifically to meet the submission requirements of most global regulatory bodies.