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 the spreadsheets don’t work for you..
- Do you have Open Office installed? If not, install it.
- Are you using Open Office to read the spreadsheet? Sometimes another spreadsheet program will try to open it instead of Open Office.
- Have you tried saving the spreadsheet file to your desktop, starting up Open Office, then opening the spreadsheet with Open Office?
- If the spreadsheet says it is “Read Only” you probably are using a non-compatible plug in. Install & use Open Office.
- 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…
- If you have an older version of Open Office you may need to upgrade it.
- 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
SPREADSHEET CALCULATOR FOR POLYETHYLENE TUBE
SPREADSHEET CALCULATOR FOR PEX TUBE
SPREADSHEET CALCULATORS FOR COPPER TUBE
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)