Spreadsheet: 57026d1257200459-create-reports-from-excel-workbooks-sample-summary-pump-report-draft
Sheet: Sample Output Report

CONFIDENTIAL/PROPIETARY INFORMATION
The following Pump Cost Analysis is presented as an aid to your cost accounting.  This analysis is an estimate preparted from data acquired from the
pump test performed on the date shown and information provided by you.
Please pay careful attention to the assumptions.  The estimated savings are only valid for the assumptions made and conditions measured during the pump test.
 | Customer name |  | Test reference # | RCEA Headwaters 1
 | Contact |  | Test date | 2009-09-12 00:00:00
 | Contact phone
 | Street Address
 | City, State, zip
 | Utiilty meter#
 | Pump ID | submersible 1 | closest to highway
 | HP | 40
 | Utility rate ($/kWh) | 0.15
 | Pump location | Fernbridge
 | GPS
 | Utility | PG&E
 | Utility rebate ($/kWh first year savings) | 0.08
 | Year pump installed
 | Pump type | submersible | submersible
 | Pump make | Berkeley | Berkeley
 | Pump model | T40-450
 | Pump serial #
 | Motor make | Franklin | Franklin
 | Motor model | 2366176025
 | Motor serial #
 | Motor RPM | 3450 | 3450
 | Motor voltage | 460 | 460
 | Motor FLA | 62 | 62
 | Motor nameplate efficiency | unknown | 0.89
 |  | Existing conditions | Assumed Improved Efficiency | Delta
TEST RESULTS
1 | Standing water level (ft) | 22 | 22
2 | Pumping water level (ft) | 22 | 22
3 | Drawdown (ft) | 0 | 0
4 | Recovered water level (ft) | 22 | 22
5 | Discharge pressure at gauge (PSI) | 110 | 110
6 | Total lift (ft) | 291.8 | 291.8
7 | Flow velocity (ft/s, average) | 5.69 | 5.69
8 | Measured flow rate (gpm) | 348 | 348
9 | Customer flow rate (gpm) | 0 | 0
10 | Specific Capacity (GPM/ft drawdown) | 348 | 348
11 | Acre feet per 24 hours | 0.6952055404093307 | 0.6952055404093307
12 | Million gallons per 24 hours (MGD) | 0.226533698630137 | 0.226533698630137
13 | Cubic feet per second (CFS) | 0.7753471683786688 | 0.7753471683786688
14 | Horsepower input to motor | 49.0814052 | 38.93567112937397
15 | Percent of rated motor load (%) | 1.22703513 | 0.9733917782343491
16 | Power input to motor (kW) | 36.6 | 29.03432690095611
17 | Kilowatt hours per acre foot | 571.1763045977011 | 453.1070914144738
18 | Estimated total energy per year (kWh) | 144936 | 114975.9345277862
19 | Cost to pump an acre foot | 85.67644568965517 | 67.96606371217105
20 | Energy cost ($/hour) | 2.481780821917808 | 1.96876600218812
21 | Base cost per kWh | 0.115 | 0.115
22 | Nameplate RPM | 3450 | 3450
23 | RPM at gearhead | 3450 | 3450
24 | Overall Pumping Efficiency (OPE) | 0.5224592266931611 | 0.6586000000000001
25 | hours per year | 3960 | 3960
26 | acre feet per year | 253.7500222494057 | 253.7500222494057
27 | Estimated Total Annual Cost | 21740.4 | 17246.39017916793
28 | Estimated Annual Energy Savings (kWh) |  |  | 29960.06547221378
29 | Estimated Annual Energy Cost Savings ($) |  |  | 4494.009820832067
30 | Potential utility rebate |  |  | 2396.805237777103
31 | Total pump & motor replacement cost |  |  | 10000
32 | Simple Payback Period (years, w/o rebate) |  |  | 2.22518427833531
33 | Adjusted Payback Period (years, w/rebate |  |  | 1.691850945001977
 | It is Redwood Coast Energy Authority's mission to help Humboldt County's utility customers save energy, and we hope that your concerns with
 | maintaining optimum pump efficiency will continue.
If you have questions, please contact RCEA at the number above or [NAME] at [PHONE].
The Redwood Coast Energy Authority (RCEA) is a Joint Powers Association representing seven municipalities (the Cities of Arcata, Blue Lake, [NAME], Ferndale,
Fortuna, Trinidad and Rio Dell,) the County of Humboldt, and the Humboldt Bay Municipal Water District. RCEA's mission is to develop and implement sustainable
energy initiatives that reduce energy demand, increase energy efficiency, and advance the use of clean, efficient and renewable resources available in the region.