Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips now!
  • 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!

Join Eng-Tips
*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.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

tsli001 (Civil/Environmental) (OP)
21 Jul 09 20:27
Hi guys:

I am looking for a good pump design spreadsheet that can do head cal., efficiency etc, for pump selection. Can anyone can help me for that?

tsli  
Helpful Member!  vpl (Nuclear)
23 Jul 09 8:53
http://lmgtfy.com/?q=free+pump+design+spreadsheet  

Patricia Lougheed

Please see FAQ731-376: Eng-Tips.com Forum Policies: Eng-Tips.com Forum Policies for tips on how to make the best use of the Eng-Tips Forums.

GPRnD (Mechanical)
24 Jul 09 9:11
If you are looking for pump selections, why not just use the online selection tools offered by many of the pump manufacturers ?

Those should give you a good feel for what is available.

 
sheiko (Chemical)
2 Aug 09 18:35
good one patricia winky smile

"We don't believe things because they are true, things are true because we believe them."

tkall (Civil/Environmental)
3 Aug 09 10:39
take a look at Squirtonsite.com
sheiko (Chemical)
25 Oct 09 14:54
Check out the attached article!

"We don't believe things because they are true, things are true because we believe them."

vpl (Nuclear)
26 Oct 09 12:54
sheiko

Is this a spreadsheet you did up?  It comes up as an excel spreadsheet when I open it, with no identifying information.

Patricia Lougheed

******

Please see FAQ731-376: Eng-Tips.com Forum Policies: Eng-Tips.com Forum Policies for tips on how to make the best use of the Eng-Tips Forums.

JLSeagull (Electrical)
26 Oct 09 13:02
VPL
Too cute.
SNORGY (Mechanical)
26 Oct 09 14:09
tsli001:

There is a lot of science that a person could throw at this, but at the end of the day it comes down to comparing pump curves received against the operating range you want to cover.

If asked to be predictive up front, if someone permits me to be scientifically creative, I would start with the assumption that, for centrifugal pumps for example, the characteristic head-capacity curve is a concave downwards parabola of the form:

H = C1 + C2*Q + C3*Q^2

(sometimes I add a fourth term "... + C4*e^Q..." because I have found that equation form is a better fit for most of the curves I have worked with, and it reduces the drop-off and improves continuous rise to shut-off - perhaps coincidentally - near the dead-head range)

I then would arbitrarily pick a "% rise to shut off from BEP", considering how flat a characteristic I want.  With that, I can usually get a pretty accurate indication of what C1, C2 and C3 are.

I then would pick an arbitrary pump maximum efficiency at BEP and, again, assume a concave-down parabola with vertex at BEP and Y-intercept at (Q=0, H=0).

Then, when I got the pump curves, I could plot the actual data points from each against the theoretical baseline thus derived and make an assessment as to which comes closest.

Where pump RPM and impeller sizes need to be considered, the affinity laws can easily be applied.

I often take the backwards approach as well: fit equations to actual pump curves and then vary the operating conditions to predict performance.  There is some limited curve fitting capability in EXCEL, but I find that there are a few reaaly good - and basically free - Shareware and Freeware utilities that do a much better job.  Two that come to mind are the old DOS-platform XYMATH and the somewhat newer CURVE-EXPERT.

The nice thing about the above approach is that once you have built the template the first time you can fiddle with the constants C1, C2, C3, C4 to "shape" the curve you want and then go looking for the closest fit from the vendors, so it's not a "one-time" tool.


  

Regards,

SNORGY.

sheiko (Chemical)
26 Oct 09 14:29
vpl,

See the last sheet for the info. you are asking...

"We don't believe things because they are true, things are true because we believe them."

vpl (Nuclear)
26 Oct 09 15:34
sheiko

My apologies.  I didn't make the spread sheet full size when I first opened it and so all the different pages didn't show up.

 

Patricia Lougheed

******

Please see FAQ731-376: Eng-Tips.com Forum Policies: Eng-Tips.com Forum Policies for tips on how to make the best use of the Eng-Tips Forums.

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!

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close