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!

*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.


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.

Pump design spreadsheet

Pump design spreadsheet

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?


RE: Pump design spreadsheet

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.


RE: Pump design spreadsheet

good one patricia winky smile

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

RE: Pump design spreadsheet

take a look at

RE: Pump design spreadsheet


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: Forum Policies: Forum Policies for tips on how to make the best use of the Eng-Tips Forums.

RE: Pump design spreadsheet

Too cute.

RE: Pump design spreadsheet


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.




RE: Pump design spreadsheet


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."

RE: Pump design spreadsheet


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: Forum Policies: Forum Policies for tips on how to make the best use of the Eng-Tips Forums.

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!


White Paper: Agile Product Engineering and Improved Product Outcomes
Today’s product development cycle is fraught with difficulties. Increased demands for complex functionality and reduced product development windows cause engineering teams to borrow practices from the IT industry, swapping outdated serial workflows for a more flexible and collaborative design method known as Agile Product Engineering. Download Now

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