Partially Full Pipe Flow Calculations

Title: Partially Full Pipe Flow Calculations

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

Published Date: July/2014

Content Type: Spreadsheet


This Excel workbook streamlines calculations required for flow through pipes that are only partially full, such as storm sewers and drainage pipes. It automates the necessary iterative calculations and simplifies the use of trigonometric formulas to calculate cross-sectional area of flow and wetted perimeter as functions of the pipe diameter and depth of flow. The workbook calculates the flow rate and velocity, the normal depth, the required pipe diameter, the required pipe slope, or the Manning roughness coefficient.

Equations used: Manning Equation for open channel flow calculations.