Partially full pipe flow calculations
This Excel workbook from AccessEngineering 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.