Here are some spreadsheets I have created to help you calculate the capacity and water pressure loss through pipes and tubes of various types and sizes. These should be useful for both figuring pressure loss in mainlines and laterals. Each spreadsheet allows for multiple sections of pipe of various sizes and flows. All you do is select the proper spreadsheet for the type of pipe you are going to use, select the pipe size from a drop down list, enter the flow through the pipe in GPM, then enter the length of the pipe in feet. The spreadsheet calculator will then do the math to give you the water velocity in the pipe along with the pressure loss in PSI for that section of pipe. If there are multiple sections of pipe the spreadsheet will also total all of them for the total pressure loss.
Full instructions are included on the spreadsheets. The spreadsheets use the Open Office format. I used Open Office because it is a free program that is available for just about every desktop and laptop computer make and model. If you don’t have Open Office you will need to install it on your computer before you can use the spreadsheets. Download it free from http://www.openoffice.org
Although many spreadsheet programs claim they can open and use the Open Office spreadsheet files, I have not found any that actually open it AND preserve all the features that make the spreadsheets work easily and well. I suggest you use Open Office. You can un-install it when you are done if you don’t like it.
SPREADSHEET CALCULATORS FOR PVC PIPE
Cl 125 PVC pipe Calculator Spreadsheet for Velocity, Friction Loss or Pressure Loss.
Cl 160 PVC pipe Calculator Spreadsheet for Velocity, Friction Loss or Pressure Loss.
Cl 200 PVC pipe Calculator Spreadsheet for Velocity, Friction Loss or Pressure Loss.
Cl 315 PVC pipe Calculator Spreadsheet for Velocity, Friction Loss or Pressure Loss.
SCH 40 PVC pipe Calculator Spreadsheet for Velocity, Friction Loss or Pressure Loss.
SCH 80 PVC pipe Calculator Spreadsheet for Velocity, Friction Loss or Pressure Loss.
SPREADSHEET CALCULATOR FOR POLYETHYLENE TUBE
Polyethylene Tube Calculator Spreadsheet for Velocity, Friction Loss or Pressure Loss.
SPREADSHEET CALCULATOR FOR PEX TUBE
PEX Tube Calculator Spreadsheet for Velocity, Friction Loss or Pressure Loss.
SPREADSHEET CALCULATORS FOR COPPER TUBE
Type K Copper Tube Calculator Spreadsheet for Velocity, Friction Loss or Pressure Loss.
Type L Copper Tube Calculator Spreadsheet for Velocity, Friction Loss or Pressure Loss.
Type M Copper Tube Calculator Spreadsheet for Velocity, Friction Loss or Pressure Loss.
SPREADSHEET CALCULATOR FOR SCH 40 STEEL PIPE
SCH 40 Steel Pipe Calculator Spreadsheet for Velocity, Friction Loss or Pressure Loss. (also use for galvanized steel)
I don't have a huge corporate advertising budget to promote this website. You can help level the playing field by promoting quality, independent, free online content. Please consider taking just a moment to help by sharing this website with your networks of friends and colleagues!
Tags: drip tube, GPM, hydraulics, irrigation design, mainline, pipe, PSI, pvc pipe, Spreadsheets
Text and Images by Jess Stryker unless noted. Copyright © Jess Stryker, 1997-2012. All rights reserved.
