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

[NAME] |  |  |  | [NAME] |  |  |  | Pump 1 by barn |  |  |  | Pump 2 by highway |  |  |  | Pump 3 Goble |  |  |  | Pump 4 Goble |  |  |  | Pump 5 end of Sage |  |  |  | Pump 6 Gobel NE corner |  |  |  | Domingo #1 |  |  |  | Domingo #2
Meter # |  |  |  | Meter # |  |  |  | Meter # |  |  |  | Meter # |  |  |  | Meter # |  | Sangamo |  | Meter # |  |  |  | Meter # |  |  |  | Meter # |  |  |  | Meter # |  |  |  | Meter # |  |  |  | Meter # |  |  |  | Meter # |  |  |  | Meter # |  |  |  | Meter #
GPS | N |  |  | GPS | N |  |  | GPS | N |  |  | GPS | N |  |  | GPS | N |  |  | GPS | N |  |  | GPS | N |  |  | GPS | N |  |  | GPS | N |  |  | GPS | N |  |  | GPS | N |  |  | GPS | N |  |  | GPS | N |  |  | GPS | N
 | W |  |  |  | W |  |  |  | W |  |  |  | W |  |  |  | W |  |  |  | W |  |  |  | W |  |  |  | W |  |  |  | W |  |  |  | W |  |  |  | W |  |  |  | W |  |  |  | W |  |  |  | W
Pump type | Sub |  |  | Pump type | Sub |  |  | Pump type | VT |  |  | Pump type | VT |  |  | Pump type | VT |  |  | Pump type | VT |  |  | Pump type | VT |  |  | Pump type | sub |  |  | Pump type | VT |  |  | Pump type | VT |  |  | Pump type | VT |  |  | Pump type | VT |  |  | Pump type | VT |  |  | Pump type | VT
Pump size | 40 | hp |  | Pump size | 40 | hp |  | Pump size | 60 | hp |  | Pump size | 40 | hp |  | Pump size | 40 | hp |  | Pump size | 40 | hp |  | Pump size | 40 | hp |  | Pump size | 40 | hp |  | Pump size | 50 | hp |  | Pump size | 50 | hp |  | Pump size |  | hp |  | Pump size |  | hp |  | Pump size |  | hp |  | Pump size |  | hp
Pumping Water Level | 22 | ft |  | Pumping Water Level | 24 | ft |  | Pumping Water Level | 39 | ft |  | Pumping Water Level | 41.5 | ft |  | Pumping Water Level | 31 | ft |  | Pumping Water Level | 31 | ft |  | Pumping Water Level | 31 | ft |  | Pumping Water Level | 31 | ft |  | Pumping Water Level | 14 | ft |  | Pumping Water Level | 26 | ft |  | Pumping Water Level |  | ft |  | Pumping Water Level |  | ft |  | Pumping Water Level |  | ft |  | Pumping Water Level |  | ft
Standing Water Level | 22 | ft |  | Standing Water Level | 22 | ft |  | Standing Water Level | 22 | ft |  | Standing Water Level | 22 | ft |  | Standing Water Level | 22 | ft |  | Standing Water Level | 22 | ft |  | Standing Water Level | 22 | ft |  | Standing Water Level | 14 | ft |  | Standing Water Level | 9 | ft |  | Standing Water Level | 5 | ft |  | Standing Water Level |  | ft |  | Standing Water Level |  | ft |  | Standing Water Level |  | ft |  | Standing Water Level |  | ft
[NAME] | 0 | ft |  | [NAME] | 2 | ft |  | [NAME] | 17 | ft |  | [NAME] | 19.5 | ft |  | [NAME] | 9 | ft |  | [NAME] | 9 | ft |  | [NAME] | 9 | ft |  | [NAME] | 17 | ft |  | [NAME] | 5 | ft |  | [NAME] | 21 | ft |  | [NAME] | 0 | ft |  | [NAME] | 0 | ft |  | [NAME] | 0 | ft |  | [NAME] | 0 | ft
Recovered Water Level | 22 | ft |  | Recovered Water Level | 22 | ft |  | Recovered Water Level | 22 | ft |  | Recovered Water Level | 24 | ft |  | Recovered Water Level | 24 | ft |  | Recovered Water Level | 24 | ft |  | Recovered Water Level | 24 | ft |  | Recovered Water Level |  | ft |  | Recovered Water Level | 24 | ft |  | Recovered Water Level | 5 | ft |  | Recovered Water Level |  | ft |  | Recovered Water Level |  | ft |  | Recovered Water Level |  | ft |  | Recovered Water Level |  | ft
Deck to gauge | 1 | ft |  | Deck to gauge | 1 | ft |  | Deck to gauge | 2 | ft |  | Deck to gauge | 0 | ft |  | Deck to gauge | 0 | ft |  | Deck to gauge | 0 | ft |  | Deck to gauge | 0 | ft |  | Deck to gauge |  | ft |  | Deck to gauge | 0 | ft |  | Deck to gauge | 0 | ft |  | Deck to gauge |  | ft |  | Deck to gauge |  | ft |  | Deck to gauge |  | ft |  | Deck to gauge |  | ft
Discharge Pressure at Gauge | 110 | [NAME] |  | Discharge Pressure at Gauge | 17 | [NAME] |  | Discharge Pressure at Gauge | 40 | [NAME] |  | Discharge Pressure at Gauge | 90 | [NAME] |  | Discharge Pressure at Gauge | 77 | [NAME] |  | Discharge Pressure at Gauge | 101 | [NAME] |  | Discharge Pressure at Gauge | 87 | [NAME] |  | Discharge Pressure at Gauge | 51 | [NAME] |  | Discharge Pressure at Gauge | 74 | [NAME] |  | Discharge Pressure at Gauge | 90 | [NAME] |  | Discharge Pressure at Gauge |  | [NAME] |  | Discharge Pressure at Gauge |  | [NAME] |  | Discharge Pressure at Gauge |  | [NAME] |  | Discharge Pressure at Gauge |  | [NAME]
Head velocity (Hv) | 14.66013410331656 | ft |  | Head velocity (Hv) | 7.655489808676953 | ft |  | Head velocity (Hv) | 13.42503123014336 | ft |  | Head velocity (Hv) | 3.78048869759978 | ft |  | Head velocity (Hv) | 7.473267384779805 | ft |  | Head velocity (Hv) | 5.44161265861811 | ft |  | Head velocity (Hv) | 5.316312367136772 | ft |  | Head velocity (Hv) | 12.29838155043721 | ft |  | Head velocity (Hv) | 9.683922527343412 | ft |  | Head velocity (Hv) | 11.50972677464291 | ft |  | Head velocity (Hv) | #N/A | ft |  | Head velocity (Hv) | #N/A | ft |  | Head velocity (Hv) | #N/A | ft |  | Head velocity (Hv) | #N/A | ft
Total Lift | 291.7601341033166 | ft |  | Total Lift | 71.92548980867696 | ft |  | Total Lift | 146.8250312301434 | ft |  | Total Lift | 253.1804886975998 | ft |  | Total Lift | 216.3432673847798 | ft |  | Total Lift | 269.7516126586181 | ft |  | Total Lift | 237.2863123671368 | ft |  | Total Lift | 161.1083815504372 | ft |  | Total Lift | 194.6239225273434 | ft |  | Total Lift | 245.4097267746429 | ft |  | Total Lift | #N/A | ft |  | Total Lift | #N/A | ft |  | Total Lift | #N/A | ft |  | Total Lift | #N/A | ft
Diameter | 5 | in |  | Diameter | 5 | in |  | Diameter | 6 | in |  | Diameter | 7.844366926962348 | in |  | Diameter | 6 | in |  | Diameter | 6 | in |  | Diameter | 6 | in |  | Diameter | 6 | in |  | Diameter | 6 | in |  | Diameter | 6 | in |  | Diameter |  | in |  | Diameter |  | in |  | Diameter |  | in |  | Diameter |  | in
Radius | 2.5 | in |  | Radius | 2.5 | in |  | Radius | 3 | in |  | Radius | 3.922183463481174 | in |  | Radius | 3 | in |  | Radius | 3 | in |  | Radius | 3 | in |  | Radius | 3 | in |  | Radius | 3 | in |  | Radius | 3 | in |  | Radius | 0 | in |  | Radius | 0 | in |  | Radius | 0 | in |  | Radius | 0 | in
Cross sectional area | 19.63495408493621 | sq in |  | Cross sectional area | 19.63495408493621 | sq in |  | Cross sectional area | 28.27433388230814 | sq in |  | Cross sectional area | 48.3287632239069 | sq in |  | Cross sectional area | 28.27433388230814 | sq in |  | Cross sectional area | 28.27433388230814 | sq in |  | Cross sectional area | 28.27433388230814 | sq in |  | Cross sectional area | 28.27433388230814 | sq in |  | Cross sectional area | 28.27433388230814 | sq in |  | Cross sectional area | 28.27433388230814 | sq in |  | Cross sectional area | 0 | sq in |  | Cross sectional area | 0 | sq in |  | Cross sectional area | 0 | sq in |  | Cross sectional area | 0 | sq in
Flow Velocity readings (ft/s) | 5.85 | 5.85 |  | Flow Velocity readings (ft/s) | 3.1 | 3.2 |  | Flow Velocity readings (ft/s) | 7.7 | 7.3 |  | Flow Velocity readings (ft/s) | 3.4 | 3.5 |  | Flow Velocity readings (ft/s) | 4.2 | 3.8 |  | Flow Velocity readings (ft/s) | 3 | 2.9 |  | Flow Velocity readings (ft/s) | 3.1 | 3.2 |  | Flow Velocity readings (ft/s) | 6.1 |  |  | Flow Velocity readings (ft/s) | 5.2 | 5.7 |  | Flow Velocity readings (ft/s) | 6.4 | 6.2 |  | Flow Velocity readings (ft/s) |  |  |  | Flow Velocity readings (ft/s) |  |  |  | Flow Velocity readings (ft/s) |  |  |  | Flow Velocity readings (ft/s)
 | 5.8 | 5.7 |  |  | 3.2 | 3 |  |  | 7.6 | 7.5 |  |  | 3.5 | 3.5 |  |  | 4.15 | 4.3 |  |  | 3.1 | 3 |  |  | 3.2 | 3 |  |  | 5.5 | 6.1 |  |  | 5.2 | 5.6 |  |  | 6.4 | 6.3
 | 5.6 | 5.7 |  |  | 2.7 | 2.7 |  |  | 7.5 | 7.5 |  |  | 3.6 | 3.5 |  |  | 4.1 | 4.7 |  |  | 3.2 | 3.1 |  |  | 2.7 | 2.7 |  |  | 6.3 | 6.3 |  |  | 5.3 | 5.5 |  |  | 6.5 | 6.4
 | 5.5 | 5.5 |  |  | 3 | 2.7 |  |  | 7.4 | 7.5 |  |  | 3.8 | 3.7 |  |  | 4 | 4.6 |  |  | 3.1 | 3.1 |  |  | 3 | 2.7 |  |  | 7.2 | 6.6 |  |  | 5.5 | 5.3 |  |  | 6.5 | 6.5
 |  |  |  |  | 3 | 3.1 |  |  | 7.3 | 7.7 |  |  | 3.9 | 3.7 |  |  | 3.9 | 4 |  |  | 2.9 | 3 |  |  | 3 | 3.1 |  |  | 7.6 | 7.4 |  |  | 5.5 | 5.3 |  |  | 6.6 | 6.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.3 | 7.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.3 | 7.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.2 | 7.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.6 | 6.7
average Flow Velocity | 5.6875 | ft/s |  | average Flow Velocity | 2.97 | ft/s |  | average Flow Velocity | 7.5 | ft/s |  | average Flow Velocity | 3.61 | ft/s |  | average Flow Velocity | 4.174999999999999 | ft/s |  | average Flow Velocity | 3.04 | ft/s |  | average Flow Velocity | 2.97 | ft/s |  | average Flow Velocity | 6.870588235294117 | ft/s |  | average Flow Velocity | 5.409999999999999 | ft/s |  | average Flow Velocity | 6.430000000000001 | ft/s |  | average Flow Velocity | #N/A | ft/s |  | average Flow Velocity | #N/A | ft/s |  | average Flow Velocity | #N/A | ft/s |  | average Flow Velocity | #N/A | ft/s
Pipe flow | 348.1103533605819 | gpm |  | Pipe flow | 181.7824614471962 | gpm |  | Pipe flow | 661.0271325352588 | gpm |  | Pipe flow | 543.849237027132 | gpm |  | Pipe flow | 367.9717704446274 | gpm |  | Pipe flow | 267.9363310542916 | gpm |  | Pipe flow | 261.7667444839625 | gpm |  | Pipe flow | 605.552698667594 | gpm |  | Pipe flow | 476.8209049354334 | gpm |  | Pipe flow | 566.7205949602287 | gpm |  | Pipe flow | #N/A | gpm |  | Pipe flow | #N/A | gpm |  | Pipe flow | #N/A | gpm |  | Pipe flow | #N/A | gpm
Pump power | 38.6 | kW |  | Pump power | 34.5 | kW |  | Pump power | 50.3 | kW |  | Pump power | 39.53 | kW |  | Pump power | 31.04 | kW |  | Pump power | 30.9 | kW |  | Pump power | 25.04 | kW |  | Pump power | 38.98 | kW |  | Pump power | 42 | kW |  | Pump power | 46.5 | kW |  | Pump power |  | kW |  | Pump power |  | kW |  | Pump power |  | kW |  | Pump power |  | kW
OPE | 0.4954781900867254 |  |  | OPE | 0.07136490137297659 |  |  | OPE | 0.3633459802674797 |  |  | OPE | 0.6559200405212232 |  |  | OPE | 0.4829532927330995 |  |  | OPE | 0.4404596542856721 |  |  | OPE | 0.4671128251622356 |  |  | OPE | 0.4712997410865042 |  |  | OPE | 0.4160745725124695 |  |  | OPE | 0.5632183184842379 |  |  | OPE | #N/A |  |  | OPE | #N/A |  |  | OPE | #N/A |  |  | OPE | #N/A
Hours | 3960 |  |  | Hours | 3960 |  |  | Hours | 3960 |  |  | Hours | 3960 |  |  | Hours | 3960 |  |  | Hours | 3960 |  |  | Hours | 3960 |  |  | Hours | 3960 |  |  | Hours | 3960 |  |  | Hours | 3960 |  |  | Hours |  |  |  | Hours |  |  |  | Hours |  |  |  | Hours
kWh/yr | 152856 |  |  | kWh/yr | 136620 |  |  | kWh/yr | 199188 |  |  | kWh/yr | 156538.8 |  |  | kWh/yr | 122918.4 |  |  | kWh/yr | 122364 |  |  | kWh/yr | 99158.4 |  |  | kWh/yr | 154360.8 |  |  | kWh/yr | 166320 |  |  | kWh/yr | 184140 |  |  | kWh/yr | 0 |  |  | kWh/yr | 0 |  |  | kWh/yr | 0 |  |  | kWh/yr | 0
Potential OPE delta | 0.1545218099132746 |  |  | Potential OPE delta | 0.5786350986270234 |  |  | Potential OPE delta | 0.2866540197325204 |  |  | Potential OPE delta | NA |  |  | Potential OPE delta | 0.1670467072669005 |  |  | Potential OPE delta | 0.2095403457143279 |  |  | Potential OPE delta | 0.1828871748377645 |  |  | Potential OPE delta | 0.1787002589134958 |  |  | Potential OPE delta | 0.2339254274875305 |  |  | Potential OPE delta | 0.08678168151576215 |  |  | Potential OPE delta | #N/A |  |  | Potential OPE delta | #N/A |  |  | Potential OPE delta | #N/A |  |  | Potential OPE delta | #N/A
Potential kWh savings | 23619.5857761035 |  |  | Potential kWh savings | 79053.12717442395 |  |  | Potential kWh savings | 57098.04088248126 |  |  | Potential kWh savings | NA |  |  | Potential kWh savings | 20533.11398251578 |  |  | Potential kWh savings | 25640.19486298802 |  |  | Potential kWh savings | 18134.79963743298 |  |  | Potential kWh savings | 27584.31492609434 |  |  | Potential kWh savings | 38906.47709972608 |  |  | Potential kWh savings | 15979.97883431244 |  |  | Potential kWh savings | #N/A |  |  | Potential kWh savings | #N/A |  |  | Potential kWh savings | #N/A |  |  | Potential kWh savings | #N/A