Partially Full Pipe Flow Calculations Using Excel Spreadsheets

Title: Partially Full Pipe Flow Calculations Using Excel Spreadsheets

Contributor: Harlan Bengtson Ph.D., P.E. , Former Dean of Engineering, Southern Illinois University Edwardsville

Published Date: 2014

Content Type: Tutorial

Description:

The Manning equation is used for a wide variety of uniform open channel flow calculations, including gravity flow in pipes, the topic of this tutorial. Gravity flow occurs in pipes for partially full flow, up to and including full pipe flow, as long as the pipe isn't pressurized.

Equations for calculating area, wetted perimeter and hydraulic radius for partially full pipe flow are included in this book along with a brief review of the Manning equation and discussion of its use to calculate a) the flow rate in a given pipe (diameter, slope, & Manning roughness) at a specified depth of flow, b) the required diameter for a specified flow rate at a target percent full in a given pipe, and c) the normal depth (depth of flow) for a specified flow rate in a given pipe. This includes presentation and discussion of the equations for the calculations, example calculations, and spreadsheets to facilitate the calculations.