Spreadsheet: 2b01d679-d42c-42a0-aac6-e222b4cb316b
Sheet: Sheet1

Weekly Water Report | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Week of February 26, 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.083 | 6.391688043891842 | 50.94 | 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.2975714285714286 | 0.9130982919845488 | 56.22 | 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.2975714285714286
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 | 18.7 | 57.38097283762718 | 573.18 | Total Combined
Weekly Average MGD | 2.671428571428571 | 8.197281833946741 | 573.18 | 5230
Location | Weekly Total MG | Weekly Total AF | Ac. Ft. Used in 2012 | Ac. Ft. Allocated
St. Mikes     Design (378 gpm) | 0 | 0 | 11.1
Canyon Water Treatment Plant | 18.354 | 56.31927141507002 | 348.6 | Total Combined
Weekly Average MGD | 2.622 | 8.04561020215286 | 359.7 | 5040
Weekly Average Production of Complete System Wells plus Treatment Plants
Date | MGD | [NAME]
2012-02-26 00:00:00 | 5.590999999999999 | 17.15599032808415
 | Weekly Averages
 | Total Consumption/Demand |  | Las Campanas
Date | MGD | [NAME] | MGD | [NAME]
2012-02-19 00:00:00 | 5.86 | 17.98141715660403 | 0.028 | 0.08591803419537761
2012-02-26 00:00:00 | 5.91 | 18.1348422176672 | 0.087 | 0.2669596062499233
Reservoir Information | Total Capacity | Useable Capacity | Useable MG | Useable AF
2012-02-19 00:00:00 | 0.369 | 0.169 | 216.996 | 665.8524910092914
2012-02-26 00:00:00 | 0.369 | 0.169 | 216.996 | 665.8524910092914
Reservoir Inflow Wkly Avg | (Estimate) MGD | [NAME]
2012-02-19 00:00:00 | 1.28 | 3.927681563217262
2012-02-26 00:00:00 | 1.39 | 4.265216697556245
Summary of Weekly Data Comparisons vs Previous Years
City Well Field | Million Gal per Day | [NAME]
2010 | 1.18 | 3.620831441090913
2011 | 0.091 | 0.2792336111349772
2012 | 0.2975714285714286 | 0.9130982919845488
Buckman Well Field | Million Gal per Day | [NAME]
2010 | 3.71 | 11.38413953088753
2011 | 0.13 | 0.3989051587642532
2012 | 0 | 0
[NAME] | Million Gal per Day | [NAME]
2011 | 2.81 | 8.622488431750396
2012 | 2.671428571428571 | 8.197281833946741
Canyon Water Plant | Million Gal per Day | [NAME]
2010 | 1.14 | 3.498091392240374
2011 | 2.53 | 7.763308089796618
2012 | 2.622 | 8.04561020215286
Total Consumption/Demand | Million Gal per Day | [NAME]
2010 | 6.12 | 18.77922747413253
2011 | 6.64 | 20.37484810918955
2012 | 5.91 | 18.1348422176672
Las Campanas Consumption | Million Gal per Day | [NAME] | Golf Course in Million Gallons per week | Domestic in Million Gallons per week
2010 | 0.07 | 0.214795085488444
2011 | 0.07 | 0.214795085488444
2012 | 0.087 | 0.2669596062499233 | 0 | 0.612
Reservoir Information | Total % of Capacity
2010 | 0.52
2011 | 0.45
2012 | 0.369
Reservoir Inflow Wkly Avg | (Estimate) MGD
2010 | 1.18
2011 | 1.19
2012 | 1.39
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