Spreadsheet: 7e2cd27a-7873-4e3c-95ee-331238e012af
Sheet: Sheet1

Weekly Water Report | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Week of February 5, 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.089 | 6.410099051219422 | 31.66 | 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.2984285714285714 | 0.9157284358884888 | 36.94 | 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.2984285714285714
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 | 20.8 | 63.82482540228051 | 437.88 | Total Combined
Weekly Average MGD | 2.971428571428572 | 9.117832200325788 | 437.88 | 5230
Location | Weekly Total MG | Weekly Total AF | Ac. Ft. Used in 2012 | Ac. Ft. Allocated
St. Mikes     Design (378 gpm) | 1.083 | 3.323186822628355 | 10.94
Canyon Water Treatment Plant | 14.471 | 44.40428117290391 | 174.28 | Total Combined
Weekly Average MGD | 2.222 | 6.818209713647467 | 185.22 | 5040
Weekly Average Production of Complete System Wells plus Treatment Plants
Date | MGD | [NAME]
2012-02-05 00:00:00 | 5.491857142857143 | 16.85177034986174
 | Weekly Averages
 | Total Consumption/Demand |  | Las Campanas
Date | MGD | [NAME] | MGD | [NAME]
2012-01-29 00:00:00 | 5.85 | 17.95073214439139 | 0.052 | 0.1595620635057013
2012-02-05 00:00:00 | 5.75 | 17.64388202226504 | 0.054 | 0.1656990659482282
Reservoir Information | Total Capacity | Useable Capacity | Useable MG | Useable AF
2012-01-29 00:00:00 | 0.385 | 0.185 | 237.54 | 728.8917800989284
2012-02-05 00:00:00 | 0.382 | 0.182 | 233.688 | 717.0719133946214
Reservoir Inflow Wkly Avg | (Estimate) MGD | [NAME]
2012-01-29 00:00:00 | 1.53 | 4.694806868533133
2012-02-05 00:00:00 | 1.67 | 5.124397039510021
Summary of Weekly Data Comparisons vs Previous Years
City Well Field | Million Gal per Day | [NAME]
2010 | 1.7 | 5.216452076147926
2011 | 1.58 | 4.848231929596308
2012 | 0.2984285714285714 | 0.9157284358884888
Buckman Well Field | Million Gal per Day | [NAME]
2010 | 3.57 | 10.95454935991064
2011 | 0 | 0
2012 | 0 | 0
[NAME] | Million Gal per Day | [NAME]
2011 | 3.51 | 10.77043928663483
2012 | 2.971428571428572 | 9.117832200325788
Canyon Water Plant | Million Gal per Day | [NAME]
2010 | 1.18 | 3.620831441090913
2011 | 1.78 | 5.461932173849005
2012 | 2.222 | 6.818209713647466
Total Consumption/Demand | Million Gal per Day | [NAME]
2010 | 6.17 | 18.93265253519571
2011 | 7.43 | 22.7989640739877
2012 | 5.75 | 17.64388202226504
Las Campanas Consumption | Million Gal per Day | [NAME] | Golf Course in Million Gallons per week | Domestic in Million Gallons per week
2010 | 0.06 | 0.1841100732758091
2011 | 0.11 | 0.3375351343389835
2012 | 0.054 | 0.1656990659482282 | 0 | 0.383
Reservoir Information | Total % of Capacity
2010 | 0.51
2011 | 0.46
2012 | 0.382
Reservoir Inflow Wkly Avg | (Estimate) MGD
2010 | 0.59
2011 | 0.96
2012 | 1.67
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