Irrigation Tutorials

Questions about Sprinkler and Drip Irrigation? Free tutorials, articles, FAQs, and reviews. You've found the web's mother lode of irrigation information!

Calculators for Friction Loss in Pipes and Tubes

 

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 for using the spreadsheets are included on the spreadsheets.

 

Please read this paragraph before you try to use the spreadsheets.

These spreadsheets use Apache Open Office.   That means you need to have the Open Office program installed on your computer for them to work.  I use Open Office because it is a free, safe program that is available for just about every desktop and laptop computer make and model.  That means just about everyone can use it, and nobody has to make a major software investment just to use the spreadsheets.  If you don’t already have Open Office you will need to install it on your computer before you can use the spreadsheets. You can uninstall it when you are done using it if you want.  Download it free from http://www.openoffice.org .  It does take a while to download Open  Office.  It is a full office productivity suite.  (Check it out, there are some cool apps in it!)

Your browser may try to “open” the spreadsheets if you left click on the links, even if you don’t have Open Office installed.  This is because most computers have some type of minimal spreadsheet reader installed on them, so the reader will try to open these spreadsheets.  If they were just simple spreadsheets they would probably work with the readers.  But they aren’t.   In most cases you will get a corrupted version of the spreadsheet that does not work.  This is because these friction loss calculators use very complex formulas that the “stripped down” spreadsheet readers can’t handle.  You need to install Open Office.   I may have already mentioned this. :-)

Remember, you can un-install Open Office when you are done if you don’t like it.

If you try to open the spreadsheets directly using your Internet browser they will probably open as Read Only and the spreadsheet won’t work.  This is because the browser will not open an executable file directly.  (It is trying to protect you from possible viruses.) 
Solution:  Right click on the link and “Save” the file to your hard drive.  The actual wording varies, so depending on your browser you may select “Save link as..”, “Save Target as…”, etc.   This should save the spreadsheet file to your hard drive.  Then open it directly from your computer without using the browser plug-in.  Tablet and phone users:  you may need to get to a real computer to use the spreadsheets.

If the spreadsheets don’t work for you..

  1. Do you have Open Office installed?  If not, install it.
  2. Are you using Open Office to read the spreadsheet?  Sometimes another spreadsheet program will try to open it instead of Open Office.
  3. Have you tried saving the spreadsheet file to your desktop, starting up Open Office, then opening the spreadsheet with Open Office?
  4. If the spreadsheet says it is “Read Only” you probably are using a non-compatible plug in.  Install & use Open Office.
  5. Just dragging the spreadsheet link to your desktop may not actually save the file.  You need to right click on the link and select Save as…
  6. If you have an older version of Open Office you may need to upgrade it.
  7. Try rebooting.  I’ve experienced a problem where if I try to open one of these spreadsheets in a browser the computer gets messed up and won’t start Open Office.  Rebooting fixed the issue.

SPREADSHEET CALCULATORS FOR PVC PIPE

Do not try to open these spreadsheets by left clicking on the links.  Save the spreadsheets to your hard-drive first.  See the explanation above.

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

Do not try to open these spreadsheets by left clicking on the links.  Save the spreadsheets to your hard-drive first.  See the explanation above.

Polyethylene Tube Calculator Spreadsheet for Velocity, Friction Loss or Pressure Loss.

 

SPREADSHEET CALCULATOR FOR PEX TUBE

Do not try to open these spreadsheets by left clicking on the links.  Save the spreadsheets to your hard-drive first.  See the explanation above.

PEX Tube Calculator Spreadsheet for Velocity, Friction Loss or Pressure Loss.

 

SPREADSHEET CALCULATORS FOR COPPER TUBE

Do not try to open these spreadsheets by left clicking on the links.  Save the spreadsheets to your hard-drive first.  See the explanation above.

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

Do not try to open these spreadsheets by left clicking on the links.  Save the spreadsheets to your hard-drive first.  See the explanation above.

SCH 40 Steel Pipe Calculator Spreadsheet for Velocity, Friction Loss or Pressure Loss.  (also use for galvanized steel)

 

 

 



IrrigationTutorials.com

IrrigationTutorials.com

Custom Search



Ads (not endorsements):