LF logo
by learnformula
search
Log in
search
Courses/Engineering/Process Piping/Oil and Gas

Using Spreadsheets for Calculating Partially Full Pipe Flow

Review of the Manning equation, presentation of equations for calculating the cross-sectional area, wetted perimeter, and hydraulic radius for flow of a specified depth.

Created byHarlan Bengtson, PhD, PE
3.9
(36 reviews)
BeginnerUpdated Dec 27, 2024
Using Spreadsheets for Calculating Partially Full Pipe Flow

What You'll Learn

check_circleUnderstand the application of the Manning equation for partially full pipe flow and the factors influencing the Manning roughness coefficient.
check_circleLearn to calculate cross-sectional area, wetted perimeter, hydraulic radius, and flow rate for various depths in a pipe of known diameter.
check_circleUse provided figures and equations to determine flow velocity, Manning roughness coefficient, and normal depth for partially full pipe flow.
check_circleGain practical experience with spreadsheet tools for performing partially full pipe flow calculations using U.S. or S.I. units.

About This Course

This course includes a review of the Manning equation, along with presentation of equations for calculating the cross-sectional area, wetted perimeter, and hydraulic radius for flow of a specified depth in a pipe of known diameter. The Manning equation can be used for uniform flow in a pipe, but the Manning roughness coefficient needs to be considered variable, dependent upon the depth of flow. Equations are also given for calculating the Manning roughness coefficient, n, for a given depth of flow in a pipe of known diameter. Numerous worked examples illustrate the use of these equations together with the Manning equation for partially full pipe flow. A sample spreadsheet for making partially full pipe flow calculations is included with this course and its use is discussed and illustrated through worked examples.

Topics: Following the completion of this course, the student will be able to: calculate the cross-sectional area of flow, wetted perimeter, and hydraulic radius for less than half full flow at a given depth in a pipe of given diameter. calculate the cross-sectional area of flow, wetted perimeter, and hydraulic radius for more than half full flow at a given depth in a pipe of given diameter. use Figure 3 in the course material to determine the flow rate at a given depth of flow in a pipe of known diameter if the full pipe flow rate is known or can be calculated. use Figure 3 the course material to determine the average water velocity at a given depth of flow in a pipe of known diameter if the full pipe average velocity is known or can be calculated. calculate the Manning roughness coefficient for a given depth of flow in a pipe of known diameter, with a known Manning roughness coefficient for full pipe flow. use the Manning equation to calculate the flow rate and average velocity for flow at a specified depth in a pipe of specified diameter, with known pipe slope and full pipe Manning roughness coefficient. calculate the normal depth for a specified flow rate of water through a pipe of known diameter, slope, and full pipe Manning roughness coefficient. carry out the calculations in the above learning objectives using either U.S. units or S.I. units. use the spreadsheet included with this course to make partially full pipe flow calculations.

Note from Author: After completing this course you will have knowledge about the equations for calculating area, wetted perimeter, and hydraulic radius for partially full pipe flow and equations for calculating the Manning roughness coefficient at a given depth to diameter ratio, with a known value of the Manning roughness coefficient for full pipe flow. Practice in the use of the Manning equation for a variety of partially full pipe flow calculations will be gained through several worked examples. 

Intended Audience: for hydrologists, civil engineers, hydraulic engineers, highway engineers, environmental engineers and mechanical 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

3.9
Student's Choice
36 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.