Spreadsheet: ecfa9399-d7ea-4da9-a1c9-6f7595fe0557
Sheet: Sheet1

Weekly Water Report | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Week of June 3, 2012
City Well Field | MG | Weekly Total AF | Ac. Ft. Used in 2012 | Ac. Ft. Allocated
[NAME] (823 gpm) | 4.383 | 13.44924085279786 | 22.42
Santa Fe         Design (183 gpm) | 2.219 | 6.809004209983675 | 146.71 | Combined
Torreon         Design (413 gpm) | 2.737 | 8.398487842598161 | 68.49 | 4865
Ferguson        Design (200 gpm) | 0.825 | 2.531513507542376 | 6.06 | [NAME]
Alto               Design (195 gpm) | 0.813 | 2.494691492887214 | 6.13
Northwest      Design (957gpm) | 0 | 0 | 0
Osage             Design (201gpm) | 0 | 0 | 0 | 25.7
City Well Production Weekly Average MGD | 1.568142857142857 | 4.811848272258469 | 249.81 | 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 | 1.07
# 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 | 1.53
# 7               Design (715 gpm) | 0 | 0 | 0
# 8               Design (525 gpm) | 0 | 0 | 1.01
# 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 | 3.69 | 10000
Combined Well Production For Buckman & City Wells | Million Gal per Day
 | 1.568142857142857
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 | 58.39 | 179.1697863095749 | 2266.36 | Total Combined
Weekly Average MGD | 8.34142857142857 | 25.59568375851071 | 2266.36 | 5230
Location | Weekly Total MG | Weekly Total AF | Ac. Ft. Used in 2012 | Ac. Ft. Allocated
St. Mikes     Design (378 gpm) | 1.763 | 5.409767653087525 | 50.04
Canyon Water Treatment Plant | 18.698 | 57.37483583518466 | 1123.33 | Total Combined
Weekly Average MGD | 2.923 | 8.96922906975317 | 1173.37 | 5040
Weekly Average Production of Complete System Wells plus Treatment Plants
Date | MGD | [NAME]
2012-06-03 00:00:00 | 12.83257142857143 | 39.37676110052234
 | Weekly Averages
 | Total Consumption/Demand |  | Las Campanas
Date | MGD | [NAME] | MGD | [NAME]
2012-05-27 00:00:00 | 11.969 | 36.72689111730266 | 0.344 | 1.055564420114639
2012-06-03 00:00:00 | 12.96 | 39.76777582757478 | 0.36 | 1.104660439654855
Reservoir Information | Total Capacity | Useable Capacity | Useable MG | Useable AF
2012-05-27 00:00:00 | 0.636 | 0.436 | 559.824 | 1717.82062769261
2012-06-03 00:00:00 | 0.623 | 0.423 | 543.132 | 1666.60120530728
Reservoir Inflow Wkly Avg | (Estimate) MGD | [NAME]
2012-05-27 00:00:00 | 6.98 | 21.41813852441913
2012-06-03 00:00:00 | 5.42 | 16.63127661924809
Summary of Weekly Data Comparisons vs Previous Years
City Well Field | Million Gal per Day | [NAME]
2010 | 1.33 | 4.081106624280436
2011 | 2.51 | 7.701938065371349
2012 | 1.568142857142857 | 4.811848272258469
Buckman Well Field | Million Gal per Day | [NAME]
2010 | 3.74 | 11.47619456752544
2011 | 0.97 | 2.976446184625581
2012 | 0 | 0
[NAME] | Million Gal per Day | [NAME]
2011 | 6.77 | 20.7737532679538
2012 | 8.34142857142857 | 25.5956837585107
Canyon Water Plant | Million Gal per Day | [NAME]
2010 | 7.23 | 22.185263829735
2011 | 2.26 | 6.934812760055477
2012 | 2.923 | 8.969229069753169
Total Consumption/Demand | Million Gal per Day | [NAME]
2010 | 12.9 | 39.58366575429897
2011 | 12.58 | 38.60174536349465
2012 | 12.96 | 39.76777582757478
Las Campanas Consumption | Million Gal per Day | [NAME] | Golf Course in Million Gallons per week | Domestic in Million Gallons per week
2010 | 0.87 | 2.669596062499233
2011 | 0.71 | 2.178635867097075
2012 | 0.36 | 1.104660439654855 | 0 | 2.533
Reservoir Information | Total % of Capacity
2010 | 0.96
2011 | 0.45
2012 | 0.623
Reservoir Inflow Wkly Avg | (Estimate) MGD
2010 | 17.57
2011 | 3.74
2012 | 5.42
Data Peak Day | Million Gal per Day | [NAME]
2010(June 6) | 16.65 | 51.09054533403704
2011(May 13) | 19.48 | 59.77440379021271
2012(June 1) | 14.675 | 45.03025542204166
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