Water Flow in Pipe Spreadsheet
Results for 16 different pipe sizes are displayed in one view.
You can examine the spreadsheet to see how the calculating is done. Darcy-Weisbach equation and friction factor are calculated.
There are no macros, no VBA.
You can copy and modify this spreadsheet for your own purposes.
086_Flow_of_water_pressure_drops_pipe_size.xls
5/30/2016
Using the above, I added on pressure drops through expansion fittings, contraction fittings, gate valves, butterfly valves, ball valves, Y-strainers. I added 90 degree elbows using the 3K method.
086_Flow_of_water-Valves-Expansions-Contractions-pressure_drops.xls
7/31/2017, 8/13/17, 8/20/17