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.
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.
7/31/2017, 8/13/17, 8/20/17