Spreadsheet: 0b25fcf0-ee49-4198-89e4-6ae333e5b5d2
Sheet: Sheet1

Weekly Water Report | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Week of January 8, 2012
City Well Field | MG | Weekly Total AF | Ac. Ft. Used in 2012 | Ac. Ft. Allocated
[NAME] (823 gpm) | 0 | 0 | 0
Santa Fe         Design (183 gpm) | 1.869 | 5.735028782541455 | 6.55 | Combined
Torreon         Design (413 gpm) | 0.948 | 2.908939157757784 | 4.62 | 4865
Ferguson        Design (200 gpm) | 0.105 | 0.322192628232666 | 0.32 | [NAME]
Alto               Design (195 gpm) | 0.11 | 0.3375351343389835 | 0.34
Northwest      Design (957gpm) | 0 | 0 | 0
Osage             Design (201gpm) | 0 | 0 | 0 | 25.7
City Well Production Weekly Average MGD | 0.4331428571428572 | 1.329099386124412 | 11.83 | 4890.7
Buckman Well Field | Weekly Total MG | Weekly Total AF | Ac. Ft. Used in 2012 | Ac. Ft. Permitted
# 1               Design (542 gpm) | 0 | 0 | 0
# 2               Design (852 gpm) | 0 | 0 | 0
# 3               Design (319 gpm) | 0 | 0 | 0
# 4               Design (357 gpm) | 0.001 | 0.003068501221263486 | 0
# 5               Design (256 gpm) | 0 | 0 | 0
# 6               Design (744 gpm) | 0.012 | 0.03682201465516183 | 0.04
# 7               Design (715 gpm) | 0 | 0 | 0
# 8               Design (525 gpm) | 0 | 0 | 0
# 9               Design (400 gpm) | 0 | 0 | 0
#10              Design (800 gpm) | 0 | 0 | 0 | Combined
# 11              Design (770 gpm) | 0 | 0 | 0 | (900 acre-ft. [NAME])
# 12              Design (800 gpm) | 0.026 | 0.07978103175285063 | 0.08
# 13              Design (800 gpm) | 0 | 0 | 0
Current Buckman Production Weekly Average MGD | 0.005571428571428572 | 0.01709593537561085 | 0.12 | 10000
Combined Well Production For Buckman & City Wells | Million Gal per Day
 | 0.4387142857142857
Weekly Average Production from Buckman Regional Water Treatment Plant
Location | Weekly Total MG | Weekly Total AF | Ac. Ft. Used in 2012 | Ac. Ft. Allocated
Buckman Regional Water Treatment Plant | 31.9 | 97.88518895830519 | 111.09 | Total Combined
Weekly Average MGD | 4.557142857142857 | 13.98359842261503 | 111.09 | 5230
Location | Weekly Total MG | Weekly Total AF | Ac. Ft. Used in 2012 | Ac. Ft. Allocated
St. Mikes     Design (378 gpm) | 1.868 | 5.731960281320192 | 7.07
Canyon Water Treatment Plant | 7.951 | 24.39765321026598 | 27.91 | Total Combined
Weekly Average MGD | 1.402714285714286 | 4.304230498798024 | 34.98 | 5040
Weekly Average Production of Complete System Wells plus Treatment Plants
Date | MGD | [NAME]
2012-01-08 00:00:00 | 6.398571428571429 | 19.63402424291307
 | Weekly Averages
 | Total Consumption/Demand |  | Las Campanas
Date | MGD | [NAME] | MGD | [NAME]
2012-01-01 00:00:00 | 6.47 | 19.85320290157475 | 0.08 | 0.2454800977010789
2012-01-08 00:00:00 | 6.09 | 18.68717243749463 | 0.076 | 0.2332060928160249
Reservoir Information | Total Capacity | Useable Capacity | Useable MG | Useable AF
2012-01-01 00:00:00 | 0.386 | 0.186 | 238.824 | 732.8317356670308
2012-01-08 00:00:00 | 0.386 | 0.186 | 238.824 | 732.8317356670308
Reservoir Inflow Wkly Avg | (Estimate) MGD | [NAME]
2012-01-01 00:00:00 | 1.44 | 4.41864175861942
2012-01-08 00:00:00 | 1.19 | 3.651516453303548
Summary of Weekly Data Comparisons vs Previous Years
City Well Field | Million Gal per Day | [NAME]
2010 | 1.92 | 5.891522344825892
2011 | 2.14 | 6.56659261350386
2012 | 0.4331428571428572 | 1.329099386124413
Buckman Well Field | Million Gal per Day | [NAME]
2010 | 3.43 | 10.52495918893376
2011 | 0 | 0
2012 | 0.005571428571428572 | 0.01709593537561085
[NAME] | Million Gal per Day | [NAME]
2011 | 0.407 | 1.248879997054239
2012 | 4.557142857142857 | 13.98359842261503
Canyon Water Plant | Million Gal per Day | [NAME]
2010 | 1.31 | 4.019736599855166
2011 | 4.35 | 13.34798031249616
2012 | 1.402714285714286 | 4.304230498798024
Total Consumption/Demand | Million Gal per Day | [NAME]
2010 | 6.57 | 20.1600530237011
2011 | 6.38 | 19.57703779166104
2012 | 6.09 | 18.68717243749463
Las Campanas Consumption | Million Gal per Day | [NAME] | Golf Course in Million Gallons per week | Domestic in Million Gallons per week
2010 | 0.16 | 0.4909601954021577
2011 | 0.09 | 0.2761651099137137
2012 | 0.076 | 0.2332060928160249 | 0 | 0.535
Reservoir Information | Total % of Capacity
2010 | 0.49
2011 | 0.48
2012 | 0.386
Reservoir Inflow Wkly Avg | (Estimate) MGD
2010 | 0.73
2011 | 1.14
2012 | 1.19
Data Peak Day | Million Gal per Day | [NAME]
2009(May 14) | 15.034 | 46.13184736047525
2010(June 6) | 16.65 | 51.09054533403704
2011(May 13) | 19.48 | 59.77440379021271
2012(January 6) | 6.303 | 19.34076319762375
Total Production of Water System | Acre Feet/Year
2004 | 10379
2005 | 10035
2006 | 10108
2007 | 10043
2008 | 10191.78
2009 | 9978.39
2010 | 10043
2011 | 10406