Spreadsheet: 8a5ee601-531c-4274-810a-9a097e893d6b
Sheet: Sheet1

Weekly Water Report | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Week of January 29, 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) | 2.084 | 6.394756545113105 | 25.25 | Combined
Torreon         Design (413 gpm) | 0 | 0 | 4.62 | 4865
Ferguson        Design (200 gpm) | 0 | 0 | 0 | [NAME]
Alto               Design (195 gpm) | 0 | 0 | 0.32
Northwest      Design (957gpm) | 0 | 0 | 0.34
Osage             Design (201gpm) | 0 | 0 | 0 | 25.7
City Well Production Weekly Average MGD | 0.2977142857142857 | 0.9135366493018722 | 30.53 | 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 | 0 | 0
# 5               Design (256 gpm) | 0 | 0 | 0
# 6               Design (744 gpm) | 0 | 0 | 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 | 0 | 0.08
# 13              Design (800 gpm) | 0 | 0 | 0
Current Buckman Production Weekly Average MGD | 0 | 0 | 0.12 | 10000
Combined Well Production For Buckman & City Wells | Million Gal per Day
 | 0.2977142857142857
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 | 26.1 | 80.08788187497699 | 374.06 | Total Combined
Weekly Average MGD | 3.728571428571429 | 11.44112598213957 | 374.06 | 5230
Location | Weekly Total MG | Weekly Total AF | Ac. Ft. Used in 2012 | Ac. Ft. Allocated
St. Mikes     Design (378 gpm) | 0 | 0 | 7.62
Canyon Water Treatment Plant | 15.639 | 47.98829059933966 | 129.87 | Total Combined
Weekly Average MGD | 2.234142857142857 | 6.855470085619951 | 137.49 | 5040
Weekly Average Production of Complete System Wells plus Treatment Plants
Date | MGD | [NAME]
2012-01-29 00:00:00 | 6.260428571428571 | 19.21013271706139
 | Weekly Averages
 | Total Consumption/Demand |  | Las Campanas
Date | MGD | [NAME] | MGD | [NAME]
2012-01-22 00:00:00 | 5.9 | 18.10415720545457 | 0.059 | 0.1810415720545457
2012-01-29 00:00:00 | 5.85 | 17.95073214439139 | 0.052 | 0.1595620635057013
Reservoir Information | Total Capacity | Useable Capacity | Useable MG | Useable AF
2012-01-22 00:00:00 | 0.387 | 0.187 | 240.108 | 736.7716912351331
2012-01-29 00:00:00 | 0.385 | 0.185 | 237.54 | 728.8917800989284
Reservoir Inflow Wkly Avg | (Estimate) MGD | [NAME]
2012-01-22 00:00:00 | 1.3 | 3.989051587642532
2012-01-29 00:00:00 | 1.53 | 4.694806868533133
Summary of Weekly Data Comparisons vs Previous Years
City Well Field | Million Gal per Day | [NAME]
2010 | 2.03 | 6.229057479164876
2011 | 1.1 | 3.375351343389835
2012 | 0.2977142857142857 | 0.9135366493018721
Buckman Well Field | Million Gal per Day | [NAME]
2010 | 3.07 | 9.420298749278901
2011 | 0 | 0
2012 | 0 | 0
[NAME] | Million Gal per Day | [NAME]
2011 | 3.5 | 10.7397542744222
2012 | 3.728571428571429 | 11.44112598213957
Canyon Water Plant | Million Gal per Day | [NAME]
2010 | 1.18 | 3.620831441090913
2011 | 1.72 | 5.277822100573196
2012 | 2.234142857142857 | 6.855470085619951
Total Consumption/Demand | Million Gal per Day | [NAME]
2010 | 6.26 | 19.20881764510942
2011 | 6.13 | 18.80991248634517
2012 | 5.85 | 17.95073214439139
Las Campanas Consumption | Million Gal per Day | [NAME] | Golf Course in Million Gallons per week | Domestic in Million Gallons per week
2010 | 0.1 | 0.3068501221263486
2011 | 0.07 | 0.214795085488444
2012 | 0.052 | 0.1595620635057013 | 0 | 0.369
Reservoir Information | Total % of Capacity
2010 | 0.51
2011 | 0.46
2012 | 0.385
Reservoir Inflow Wkly Avg | (Estimate) MGD
2010 | 0.72
2011 | 0.95
2012 | 1.53
Data Peak Day | Million Gal per Day | [NAME]
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