×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

IS Excel Spreadsheet For Pressure Loss In Pipe

IS Excel Spreadsheet For Pressure Loss In Pipe

IS Excel Spreadsheet For Pressure Loss In Pipe

(OP)
I was wondering if anyone knows where I could find a good excel spreadsheet for calculating the pressure loss in a piping system.  I've been looking through the forums, but can't seem to find anything that matches what I'm looking for.  I do a lot of Geothermal systems, and the biggest problem is finding the proper characteristics for the varying temperatures and concentrations of glycol solutions.

I have an existing spreadsheet that calculates everything, but getting the proper velocity, friction loss, and reynolds number takes too much time, as I have to calculate these values individually.

Another problem is finding proper diameters and roughness for varying materals of pipe (PVC, HDPE, etc. . . ).

If anyone has an idea where I could find a spreadsheet for pipe loss, or a good place to find the proper formula and information to calculate my own spreadsheet, I would greatly appreciate any help.

RE: IS Excel Spreadsheet For Pressure Loss In Pipe

There is a fee version of B&G's Systme Syzer on there website:

http://www.bellgossett.com/BG-SystemSyzer-for-Windows-download.asp

If you want to provide me your email address I can shoot you an xcel spreadsheet that may or may not be what your looking for; it's pretty good.

It is semi-automated.

Let me know.

RE: IS Excel Spreadsheet For Pressure Loss In Pipe

(OP)
Thanks for the advice on the B&G System Syzer, but I already have that.  What I'm looking for now (since I've decided to go the route of creating the excel spreadsheet) is an equation that would let me calculate the viscosity and density of propylene glycol solution with the concentration percentage and the temperature as input variables.

If someone could help point me in the direction to figure that out, that would be great.

RE: IS Excel Spreadsheet For Pressure Loss In Pipe

Have you checked out software from other sources?
Pipe-Flo from www.eng-software.com or Taco's Hydronic Solution Software at www.taco-hvac.com
Both of these will let you use a glycol mix.
Both have a graphic interface that will let you create schematic diagrams, both will size pumps (GPM and head) for you.  I have looked at and fiddled with both and they aren't without their drawbacks.

If you look around I am sure you can find something (not necessarily what I mention here), and if you do a lot of hydraunic systems, having this kind of software will be worth the money, especially for larger systems.
Bill

RE: IS Excel Spreadsheet For Pressure Loss In Pipe

I have written an Excel spreadsheet that calculates these values, and corrects the thermophyical values for differing glycol concentrations and temperatures.

Let me know if it helps.

Cooky

ps. the e-mail address in the program description has changed

RE: IS Excel Spreadsheet For Pressure Loss In Pipe

Cooky,

I was to suggest about your calculator in this thread but the link you had given earlier seems to be no more working. Already dropped you an email for the new link but it bounced back.

RE: IS Excel Spreadsheet For Pressure Loss In Pipe

It works, but left click it first and than download

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources