
The spreadsheet is simple. The equation was based on pump efficiency curves of the Natural gas. Use the appropriate flair for non-questionsSolution The Excel spreadsheet program from the companion website (Example 5-18.xls). Post titles must be specific to your problemSystem Curve (see manufacturer's efficiency curves) Pump Model Pump Manufacturer Equivalent Length of Pipe Fittings Discharge Pipe Inside Diameter Static Head Discharge Pipe Length DISCHARGE PIPE Total Discharge Pipe Length Steel, CMP (net energy transferred to the fluid) (power delivered by the motor to the pump) Flow GPM Pump Head, ft System This spreadsheet allows the user to find the pump power requirement Watts or Brake Horse Power for various feeder pipe diameters in and given a known flow rate LPS pipe length m and head m and then select a suitable pump based upon available pump characteristic data Microsoft Excel 192KB.Sections: Pump Spreadsheets & Calculations, Pumped Water Systems Keywords: mechanised pumps, spreadsheet, water pumps. Pump Calculator Spreadsheet ITACA itacanet org.
...

You can also run into issues where one pump starves and cavitates, or even the pump running at the higher speed creates more pressure than the second pump running at the slow speed can cope with, closing the back flow preventer of that pump, causing the slower running pump to dead head. This is why systems like this utilize flow sensors. Without knowing the system curve of the piping you are pumping through you can't calculate this flow.
