Tuesday, January 29, 2019

Pump Energy Efficiency Calculation Tool Excel Spreadsheet




What Is Pump Efficiency?
When we speak of the efficiency of any machine, we are simply referring to how well it can convert one form of energy to another. If one unit of energy is supplied to a machine and its output, in the same units of measure, is one-half unit, its efficiency is 50 percent. 

As simple as this may seem, it can still get a bit complex because the units used by our English system of measurement can be quite different for each form of energy. Fortunately, the use of constants brings equivalency to these otherwise diverse quantities.

A common example of such a machine is the heat engine, which uses energy in the form of heat to produce mechanical energy. This family includes many members, but the internal combustion engine is one with which we are all familiar. Although this machine is an integral part of our everyday lives, its effectiveness in converting energy is far less than we might expect. 

The efficiency of the typical automobile engine is around 20 percent. To put it another way, 80 percent of the heat energy in a gallon of gasoline does no useful work. Although gas mileage has increased somewhat over the years, that increase has as much to do with increased mechanical efficiency as increased engine efficiency itself. 

Diesel engines do a better job but still max out around 40 percent. This increase is due, primarily, to its higher compression ratio and the fact that the fuel, under high pressure, is injected directly into the cylinder.


Ef = PW / PS
Where:
Ef= efficiency
Pw= the water power
Ps= the shaft power
In the U.S., Ps is the power provided to the pump shaft in brake horsepower (BHP) and Pw is:
Pw = (Q x H) / 3960

Where:
Q= Flow (gallons per minute—GPM) 
H= Head (feet)
The constant (3,960) converts the product of flow and head (GPM-feet) into BHP. These equations predict that a pump that produces 100 GPM at 30 feet of head and requires 1 BHP will have an overall efficiency is 75.7 percent at that flow point. An extension of the second equation also allows the computation of the BHP required at any point on a pump’s performance curve if we know its hydraulic efficiency. I will show some examples of this later in this series.



Download Pump  Energy Efficiency Calculation Tool Excel Spreadsheet

File Size: 548 Kb


Introduction:
This Tool Calculates the energy Efficiency and energy Performance Of Water (& Waste-Water) Pumping Facilities.

Main Inputs:
- Electrical energy consumption (measured or nameplate)
- Run Hours
- Discharges pressure (from pressure gauge)
- Flow rate (from flow meter or estimate)
- Average unit price (electricity)

Main Outputs:
- Motor, Pumping (Hydraulic) & System energy efficiencies
-Motor, Pumping & Energy cost
-CO2 Emissions
- Energy performance indicators
- Comparison of  Actual performance v/s Best Practice Performance Certificate

1. Pump Efficiency Calculation Tool- Introduction
2. Pump Efficiency Calculation Tool- Help
3. Pump Efficiency Calculation Tool- Inputs
4. Pump Efficiency Calculation Tool- Performance Summary
5. Pump Efficiency Calculation Tool- Performance Certificate
6. Pump Efficiency Calculation Tool Version History





Download Drive-1







You May Also Like These E-Books:-

No comments:

Post a Comment