Pump Curve Viscosity Correction Help Needed

[JaredTurpen]

Hello,

I am trying to correct a Finn T-30 Hydroseeder and pump's pump curves for a non-water viscosity.

I have used a graphics program to record discrete values for the pump curve and they are all organized into excel, but I am having trouble with the conversion factors. I cannot use this calculator:

http://www.engineeringpage.com/calculators/pumps/viscosity_correction.html

because I need to do a couple hundred discrete values.

I have also tried to use polynomial coefficients given by page 3 and 4 of this document:

http://www.warrenpumps.com/brochures/Fluid Viscosity Effects.PDF

Can anyone help me find a way to iterate the online calculator? I have tried using macros but to no avail.

Any help would be greatly appreciated.

Thanks in advance,

Jared

 

[BigInch]

What's your fluid, temperature and viscosities?

Learn from the mistakes of others. You don't have time to make them all yourself.

 

[JaredTurpen]

The fluid is a gel made from a polymer powder and water. 1000 cSt. I'm not sure what you are using the temperature for so it would be hard to say. The ambient temperature could be anywhere from 5-100 F.

 

[BigInch]

Viscosity should always be discussed with their associated temperatures. Note that in the 3rd paragraph of your attached article it also tells you that "viscosity is strongly associated with temperature".

Next question is the gell viscosity also dependent on shear rate? You'll see that discussion on page 2.

What is it exactly that are you trying to "convert"?


Learn from the mistakes of others. You don't have time to make them all yourself.

 

[JaredTurpen]

I would like to recreate (correct) the pump curve for our gel from the pump curve provided by Finn which shows the performance of water. For my purpose we can assume 1000 cSt and ignore the shear rate. I attempted to use the polynomial coefficients and the psuedocapacity from the linked document to determine the corrected values but I am sure that I made a mistake because the values it gave were impossible.

I would love if there was a more simple way than using this nomograph, as I need to calculate the corrected values for a large amount of values. It would be great to be able to use the linked website calculator, but I can't do it one value at a time. Maybe I need a computer scientist to get the underlying calculations from the website calculator.

 

[BigInch]

I was trying to establish if we could use the method before we got to calculating the coefficients, but you seem intent on using the website calculator, so just write a script to call the web page, fill in the data, send and read the returns.

Learn from the mistakes of others. You don't have time to make them all yourself.

 

[Artisi]

There is a wealth of data in pump books on viscosity de - ratings however this is usually for known and established products, doesn't the polymer supplier have any data you can use.


It is a capital mistake to theorise before one has data. Insensibly one begins to twist facts to suit theories, instead of theories to suit facts. (Sherlock Holmes - A Scandal in Bohemia.)

 

[GPRnD]

Maybe I'm missing something but why don't you get a copy of the HI standard 9.6.7 (2010) and put those formulae into an Excel sheet ? You can get it at

http://www.pumps.org

It should be pretty easy to iterate that way...

The other thing I'd be concerned about is that the Warren Pumps article appears to reference an obsolete version of the HI standard. The online calculator doesn't say which version of HI it is using, so it is probably suspect too.