IS Excel Spreadsheet For Pressure Loss In Pipe 1

[kzigghvac]

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.

 

[BravoCompany]

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.

 

[kzigghvac]

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.

 

[dbill74]

Have you checked out software from other sources?
Pipe-Flo from

http://www.eng-software.com

or Taco's Hydronic Solution Software at

http://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

 

[Cooky]

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

 

[quark]

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.

 

[hollandhvac]

It works, but left click it first and than download