Excel for wet-well and pump sizing

onyeuko · Nov 3, 2007

I compiled this Excel program as to help me in the design of wet-well and pumps. Can someone check if there is something that I missed out and also tell me how to animate the program so that when less than the number of the pumps shown on the diagram are required(like when 2 pumps are required instead of 4, the redundant 2 pumps on the diagram disappear; both from the diagram and in the calculation, leaving behind only the number(s) of pumps that are specified for, both in the diagram and the calculation)
Link to the file is:

http://files.engineering.com/getfil...2-e10ba4e50763&file=EXCEL_for_Pump_Design.xls

Note: I do not know anything about animation.
Teddy

tsgrue · Nov 3, 2007

.

You might check out

Lift station design
thread770-160272

http://www.eng-tips.com/viewthread.cfm?qid=160272

and

Distance from inlet to suction -wet well
thread164-153148

http://www.eng-tips.com/viewthread.cfm?qid=153148&page=5

stanier wrote: "ITT Flygt have some great publications on the design of wet wells. In addition their Secad software allows the design of wet wells and covers all you need. In addition ABS pumps have their PSD software that aids the design of wet wells. If you were in Sydney I could help further with resources."

Here's some links for you that might be helpful in comparing your spreadsheet results to other analysis packages...

ITT Flygt Engineering software

http://int.flygt.com/142575.asp

http://www.flygtus.com/118460.asp

ABS Pump Selection & Planning Software

http://impeller.net/magazine/news_en/doc2385x.asp

http://impeller.net/magazine/news_en/dx826z.asp

http://www.abspumps.com

Pump Ed 101 (Understanding Pumps, Motors, and Their Controls)

http://www.pumped101.com

Flowserve Corporation Software

http://www.flowserve.com/eim/CustomerSupport/SoftwareDownloads

Vertiflow Pump Selection Software

http://www.vertiflopump.com/bob.htm