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

Headwaters Pilot Pump Test Program Summary
 | Customer | Pump name | Location | Type | Meter # | Pumping water level | HP (motor) | Motor eff | Flow (GPM) | Head (ft) | pump eff | BHP | Load Factor | Hours/yr | kW | kWh/yr | Cost $/yr at $0.15/kWh | kWh/MM Gal | MM Gal/yr | Acre-feet/yr | $/Acre-ft | OPE | Water Poweractual (kW) | kW for Water Power
Baseline |  |  |  | submersible |  | 22 | 40 |  | 348 | 291.8 |  | #N/A | 1.228187919463087 | 3960 | 36.6 | 144936 | 21740.4 | 1752.873563218391 | 82.6848 | 253.7500222494057 | 85.67644568965517 | 0.5224592266931611 | 19.1220076969697 | 36.6
 |  |  |  | submersible |  | 22 | 40 |  | 182 | 71.9 |  | #N/A | 1.157718120805369 | 3960 | 34.5 | 136620 | 20493 | 3159.340659340659 | 43.2432 | 132.7083449695168 | 154.4213365384616 | 0.07142498214024302 | 2.464161883838384 | 34.5
 |  |  |  | vertical turbine |  | 39 | 60 |  | 661 | 146.8 |  | #N/A | 1.12751677852349 | 2400 | 50.4 | 120960 | 18144 | 1270.801815431165 | 95.184 | 292.1086114713639 | 62.113882602118 | 0.3625483523729358 | 18.27243695959596 | 50.4
 |  |  |  | vertical turbine |  | 41 | 40 |  | 544 | 253.2 |  | #N/A | 1.325503355704698 | 2400 | 39.5 | 94800 | 14220 | 1210.171568627451 | 78.336 | 240.4040614832405 | 59.15041498161765 | 0.6566507771384733 | 25.9377056969697 | 39.5
 |  |  |  | vertical turbine |  | 31 | 40 |  | 368 | 216.3 |  | #N/A | 1.040268456375839 | 2400 | 31 | 74400 | 11160 | 1403.985507246377 | 52.992 | 162.6262768857215 | 68.62359646739131 | 0.4835168367546433 | 14.98902193939394 | 31
 |  |  |  | vertical turbine |  | 31 | 40 |  | 268 | 269.8 |  | #N/A | 1.036912751677852 | 2400 | 30.9 | 74160 | 11124 | 1921.641791044776 | 38.592 | 118.4343538189494 | 93.92545018656718 | 0.4406433467359682 | 13.61587941414142 | 30.9
 |  |  |  | vertical turbine |  | 31 | 30 |  | 262 | 237.3 |  | #N/A | 1.120357941834452 | 2400 | 25.04 | 60096 | 9014.4 | 1592.875318066158 | 37.728 | 115.782838434943 | 77.85609786259542 | 0.4675560297463454 | 11.70760298484849 | 25.04
 |  |  |  | submersible |  | 31 | 40 |  | 606 | 161.1 |  | #N/A | 1.308053691275168 | 2400 | 38.98 | 93551.99999999999 | 14032.8 | 1072.057205720572 | 87.264 | 267.8030537846392 | 52.39970120462046 | 0.4716233371425906 | 18.38387768181818 | 38.98
 |  |  |  | vertical turbine |  | 14 | 50 |  | 477 | 194.6 |  | #N/A | 1.12751677852349 | 3240 | 42 | 136080 | 20412 | 1467.505241090147 | 92.7288 | 284.5738885884793 | 71.72829559748428 | 0.4161796893939394 | 17.47954695454546 | 42
 |  |  |  | vertical turbine |  | 26 | 50 |  | 567 | 234.7 |  | #N/A | 1.248322147651007 | 3240 | 46.5 | 150660 | 22599 | 1366.8430335097 | 110.2248 | 338.2670751146075 | 66.8081574074074 | 0.5389049252199413 | 25.05907902272727 | 46.50000000000001
Proposed | 0 | 0 | 0 | submersible | 0 |  | 40 | 0.89 | 348 | 291.8 | 0.74 | 34.65274365274365 | 0.8663185913185913 | 3960 | 29.03432690095611 | 114975.9345277862 | 17246.39017916793 | 0.00139053289755537 | 82.6848 | 253.7500222494057 | 67.96606371217105 | 0.6586000000000001 | 19.1220076969697 | 29.03432690095612
 | 0 | 0 | 0 | submersible | 0 |  | 40 | 0.89 | 182 | 71.9 | 0.74 | 4.465533715533716 | 0.1116383428883429 | 3960 | 3.741515159183698 | 14816.40003036745 | 2222.460004555117 | 0.0003426295933318405 | 43.2432 | 132.7083449695168 | 16.74694990029164 | 0.6586000000000001 | 2.464161883838384 | 3.741515159183698
 | 0 | 0 | 0 | vertical turbine | 0 |  | 60 | 0.95 | 661 | 146.8 | 0.82 | 29.88260655333826 | 0.4980434425556377 | 2400 | 23.45627337560457 | 56295.05610145097 | 8444.258415217646 | 0.0005914340235906347 | 95.184 | 292.1086114713639 | 28.9079406891962 | 0.779 | 18.27243695959596 | 23.45627337560457
 | 0 | 0 | 0 | vertical turbine | 0 |  | 40 | 0.941 | 544 | 253.2 | 0.81 | 42.94201271979049 | 1.073550317994762 | 2400 | 34.02960561652261 | 81671.05347965426 | 12250.65802194814 | 0.001042573701486599 | 78.336 | 240.4040614832405 | 50.95861503488858 | 0.7622099999999999 | 25.9377056969697 | 34.02960561652261
 | 0 | 0 | 0 | vertical turbine | 0 |  | 40 | 0.941 | 368 | 216.3 | 0.81 | 24.81556303778526 | 0.6203890759446316 | 2400 | 19.66521291952866 | 47196.51100686879 | 7079.476651030319 | 0.0008906346430945953 | 52.992 | 162.6262768857215 | 43.53218180113113 | 0.7622099999999999 | 14.98902193939394 | 19.66521291952866
 | 0 | 0 | 0 | vertical turbine | 0 |  | 40 | 0.941 | 268 | 269.8 | 0.81 | 22.54221224591595 | 0.5635553061478987 | 2400 | 17.86368509222054 | 42872.84422132929 | 6430.926633199393 | 0.00111092568981471 | 38.592 | 118.4343538189494 | 54.29950369831335 | 0.76221 | 13.61587941414142 | 17.86368509222054
 | 0 | 0 | 0 | vertical turbine | 0 |  | 30 | 0.936 | 262 | 237.3 | 0.79 | 19.87360951285002 | 0.662453650428334 | 2400 | 15.8330668950131 | 37999.36054803144 | 5699.904082204715 | 0.001007192550573352 | 37.728 | 115.782838434943 | 49.22926540108465 | 0.7394400000000001 | 11.70760298484849 | 15.8330668950131
 | 0 | 0 | 0 | submersible | 0 |  | 40 | 0.941 | 606 | 161.1 | 0.81 | 30.43602693602693 | 0.7609006734006732 | 2400 | 24.11917671221603 | 57886.02410931847 | 8682.90361639777 | 0.0006633436939553364 | 87.264 | 267.8030537846392 | 32.42272070347769 | 0.7622099999999999 | 18.38387768181818 | 24.11917671221603
 | 0 | 0 | 0 | vertical turbine | 0 |  | 50 | 0.945 | 477 | 194.6 | 0.82 | 28.58592017738359 | 0.5717184035476719 | 3240 | 22.55716473679889 | 73085.2137472284 | 10962.78206208426 | 0.0007881608922711002 | 92.7288 | 284.5738885884793 | 38.52349952576807 | 0.7748999999999998 | 17.47954695454546 | 22.55716473679889
 | 0 | 0 | 0 | vertical turbine | 0 |  | 50 | 0.945 | 567 | 234.7 | 0.82 | 40.98143015521065 | 0.8196286031042129 | 3240 | 32.3384682187731 | 104776.6370288248 | 15716.49555432373 | 0.0009505722580474162 | 110.2248 | 338.2670751146075 | 46.46179516288678 | 0.7748999999999998 | 25.05907902272727 | 32.3384682187731
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Proposed | (estimated from curves)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | kW | kWh/yr | kWh/ MM Gal
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Savings* | 7.565673099043885 | 29960.06547221378 | 1752.872172685493 |  | 2396.805237777103
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30.7584848408163 | 121803.5999696326 | 3159.340316711066 |  | 9744.287997570606
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26.94372662439543 | 26504.94389854903 | 1270.801223997141 |  | 2120.395511883923
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.470394383477391 | 1128.946520345738 | 1210.17052605375 |  | 90.31572162765906
Variable | [NAME] from: |  |  |  |  |  |  |  |  |  |  |  |  |  | 11.33478708047134 | 35603.48899313121 | 1403.984616611734 |  | 2848.279119450497
HP | nameplate (proposed and existing) |  |  |  |  |  |  |  |  |  |  |  |  |  | 13.03631490777946 | 39927.15577867071 | 1921.640680119086 |  | 3194.172462293657
Motor eff | spec sheet (proposed) |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.2069331049869 | 44800.63945196856 | 1592.874310873607 |  | 3584.051156157485
Flow | measure with flow meter (existing); design pump curve (proposed) |  |  |  |  |  |  |  |  |  |  |  |  |  | 14.86082328778397 | 24913.97589068153 | 1072.056542376878 |  | 1993.118071254522
Head | measure in pump test (existing); design pump curve (proposed) |  |  |  |  |  |  |  |  |  |  |  |  |  | 19.44283526320111 | 38694.7862527716 | 1467.504452929255 |  | 3095.582900221728
pump eff | pump curve at operating conditions (proposed); |  |  |  |  |  |  |  |  |  |  |  |  |  | 14.16153178122691 | 7003.362971175151 | 1366.842082937442 |  | 560.2690376940121
BHP | [NAME] (GPM) * Head (ft) * Spec Grav / (pump eff * 3960 (gal-ft/min-HP)) (proposed)
load factor | [NAME] (proposed); |  |  |  |  |  |  |  |  |  |  |  |  | Total | 152.7815043731827 | 370340.96519914
hours | Annual hours of operation
kW | measured using 3-phase meter under normal load conditions (existing); calculated kW=HP*LF*0.746/motor eff (proposed)
OPE | Overall pumping  plant efficiency = [flow (GPM) * Head (ft. H2O) / 3960 (GPM-ft/HP) * 0.7457 kW/HP] / Electric Power (kW) |  |  |  |  |  |  |  |  |  |  |  |  | *pumps operating off-peak have 0 kW savings
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Potential Incentive @ $0.08/kWh saved |  |  |  |  | 29627.2772159312