{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Turf Areas","AVG Water Use By Month","Monthly Water Use By Area","Jan - Mar","Apr - June","July - Sept","Oct - Dec","Est. Water Requirement","Annual Water Use","Calculations","Sheet1","Sheet8"],"not_rendered":{"charts":5,"images":5,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Turf Areas","index":0,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,2,6],[3,6,4,6]]}
[null,"Drought Emergency Plan Spreadsheet"]
[null,"Size of Turf and Landscape Areas"]
[]
[null,"Area Description","Total Area       (Select Unit)","Total Area (acres)","Total Area      (Acres)       ","Total Acreage ","Percentage of Total Area"]
[null,"Enter Names Below","Acres"]
[null,"Putting green complexes",null,{"$f":"(C6/43560)","v":0},null,{"$f":"IF(($C$5=\"Acres\"), (C6), (C6/43560))","v":0},{"$f":"F6/$F$16","v":{"$error":"#DIV/0!"}}]
[null,"Teeing grounds",null,{"$f":"(C7/43560)","v":0},null,{"$f":"IF(($C$5=\"Acres\"), (C7), (C7/43560))","v":0},{"$f":"F7/$F$16","v":{"$error":"#DIV/0!"}}]
[null,"Fairways",null,0,null,0,{"$error":"#DIV/0!"}]
[null,"Primary rough",null,0,null,0,{"$error":"#DIV/0!"}]
[null,"Secondary rough",null,0,null,0,{"$error":"#DIV/0!"}]
[null,"Practice range",null,0,null,0,{"$error":"#DIV/0!"}]
[null,"Landscape areas",null,0,null,0,{"$error":"#DIV/0!"}]
[null,"User defined area #1",null,0,null,0,{"$error":"#DIV/0!"}]
[null,"User defined area #2",null,0,null,0,{"$error":"#DIV/0!"}]
[null,"User defined area #3",null,0,null,0,{"$error":"#DIV/0!"}]
[null,"Acreage Totals",null,{"$f":"SUM(D6:D15)","v":0},{"$f":"SUM(E6:E15)","v":0},{"$f":"SUM(F6:F15)","v":0},{"$f":"SUM(G6:G15)","v":{"$error":"#DIV/0!"}}]

{"sheet":"AVG Water Use By Month","index":1,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,2,5]]}
[]
[null,"Average Historical Water Use by Month"]
[]
[null,"Month","ALWAYS GALLONS","Enter Water Use       (Acre Feet)1 ",{"$f":"IF((F21=\"Gallons\"), (\"Acre Feet\"), (IF((F21=\"HCF\"), (\"Acre Feet\"), (\"Gallons\"))))","v":"Acre Feet"},{"$f":"IF((F21=\"Gallons\"), (\"HCF\"), (IF((F21=\"Acre Feet\"), (\"HCF\"), (\"Gallons\"))))","v":"HCF"}]
[null,"Jan",{"$f":"IF(($F$21=\"Gallons\"), ((D5)), IF(($F$21=\"Acre Feet\"), ((E5)), (F5)))","v":0},null,{"$f":"IF(($F$21=\"Gallons\"), ((D5/325851)), IF(($F$21=\"Acre Feet\"), ((D5*325851)), (D5/434.026)))","v":0},{"$f":"IF(($F$21=\"Gallons\"), ((D5/748)), IF(($F$21=\"Acre Feet\"), ((D5*434.026)), (D5*748)))","v":0}]
[null,"Feb",{"$f":"IF(($F$21=\"Gallons\"), ((D6)), IF(($F$21=\"Acre Feet\"), ((E6)), (F6)))","v":0},null,{"$f":"IF(($F$21=\"Gallons\"), ((D6/325851)), IF(($F$21=\"Acre Feet\"), ((D6*325851)), (D6/434.026)))","v":0},{"$f":"IF(($F$21=\"Gallons\"), ((D6/748)), IF(($F$21=\"Acre Feet\"), ((D6*434.026)), (D6*748)))","v":0}]
[null,"March",0,null,0,0]
[null,"April",0,null,0,0]
[null,"May",0,null,0,0]
[null,"June",0,null,0,0]
[null,"July",0,null,0,0]
[null,"Aug",0,null,0,0]
[null,"Sept",0,null,0,0]
[null,"Oct",0,null,0,0]
[null,"Nov",0,null,0,0]
[null,"Dec",0,null,0,0]
[null,"TOTAL",null,{"$f":"SUM(D5:D16)","v":0},{"$f":"SUM(E5:E16)","v":0},{"$f":"SUM(F5:F16)","v":0}]
[]
[null,"1 One (1) acre foot is 325,851 gallons"]
[null,"2 One (1) HCF (100 cu. ft.) is 748 gallons"]
[null,null,null,null,null,"Gallons"]

{"sheet":"Monthly Water Use By Area","index":2,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,2,14]]}
[]
[null,"Monthly Water Use (in Gallons) by Section of the Golf Course"]
[]
[null,"Area Description","Jan","Feb","Mar","Apr","May","Jun","July","Aug","Sept","Oct","Nov","Dec ","TOTAL"]
[null,{"$f":"'Turf Areas'!B6","v":"Putting green complexes"},{"$f":"(ABS('AVG Water Use By Month'!$C$5)*'Turf Areas'!$G6)","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$6*'Turf Areas'!$G6","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$7*'Turf Areas'!$G6","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$8*'Turf Areas'!$G6","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$9*'Turf Areas'!$G6","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$10*'Turf Areas'!$G6","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$11*'Turf Areas'!$G6","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$12*'Turf Areas'!$G6","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$13*'Turf Areas'!$G6","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$14*'Turf Areas'!$G6","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$15*'Turf Areas'!$G6","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$16*'Turf Areas'!$G6","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C5:N5)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Turf Areas'!B7","v":"Teeing grounds"},{"$f":"'AVG Water Use By Month'!$C$5*'Turf Areas'!$G7","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$6*'Turf Areas'!$G7","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$7*'Turf Areas'!$G7","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$8*'Turf Areas'!$G7","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$9*'Turf Areas'!$G7","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$10*'Turf Areas'!$G7","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$11*'Turf Areas'!$G7","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$12*'Turf Areas'!$G7","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$13*'Turf Areas'!$G7","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$14*'Turf Areas'!$G7","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$15*'Turf Areas'!$G7","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$16*'Turf Areas'!$G7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B8","v":"Fairways"},{"$f":"'AVG Water Use By Month'!$C$5*'Turf Areas'!$G8","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$6*'Turf Areas'!$G8","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$7*'Turf Areas'!$G8","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$8*'Turf Areas'!$G8","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$9*'Turf Areas'!$G8","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$10*'Turf Areas'!$G8","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$11*'Turf Areas'!$G8","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$12*'Turf Areas'!$G8","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$13*'Turf Areas'!$G8","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$14*'Turf Areas'!$G8","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$15*'Turf Areas'!$G8","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$16*'Turf Areas'!$G8","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B9","v":"Primary rough"},{"$f":"'AVG Water Use By Month'!$C$5*'Turf Areas'!$G9","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$6*'Turf Areas'!$G9","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$7*'Turf Areas'!$G9","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$8*'Turf Areas'!$G9","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$9*'Turf Areas'!$G9","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$10*'Turf Areas'!$G9","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$11*'Turf Areas'!$G9","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$12*'Turf Areas'!$G9","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$13*'Turf Areas'!$G9","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$14*'Turf Areas'!$G9","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$15*'Turf Areas'!$G9","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$16*'Turf Areas'!$G9","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B10","v":"Secondary rough"},{"$f":"'AVG Water Use By Month'!$C$5*'Turf Areas'!$G10","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$6*'Turf Areas'!$G10","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$7*'Turf Areas'!$G10","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$8*'Turf Areas'!$G10","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$9*'Turf Areas'!$G10","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$10*'Turf Areas'!$G10","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$11*'Turf Areas'!$G10","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$12*'Turf Areas'!$G10","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$13*'Turf Areas'!$G10","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$14*'Turf Areas'!$G10","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$15*'Turf Areas'!$G10","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$16*'Turf Areas'!$G10","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B11","v":"Practice range"},{"$f":"'AVG Water Use By Month'!$C$5*'Turf Areas'!$G11","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$6*'Turf Areas'!$G11","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$7*'Turf Areas'!$G11","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$8*'Turf Areas'!$G11","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$9*'Turf Areas'!$G11","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$10*'Turf Areas'!$G11","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$11*'Turf Areas'!$G11","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$12*'Turf Areas'!$G11","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$13*'Turf Areas'!$G11","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$14*'Turf Areas'!$G11","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$15*'Turf Areas'!$G11","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$16*'Turf Areas'!$G11","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B12","v":"Landscape areas"},{"$f":"'AVG Water Use By Month'!$C$5*'Turf Areas'!$G12","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$6*'Turf Areas'!$G12","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$7*'Turf Areas'!$G12","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$8*'Turf Areas'!$G12","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$9*'Turf Areas'!$G12","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$10*'Turf Areas'!$G12","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$11*'Turf Areas'!$G12","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$12*'Turf Areas'!$G12","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$13*'Turf Areas'!$G12","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$14*'Turf Areas'!$G12","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$15*'Turf Areas'!$G12","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$16*'Turf Areas'!$G12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B13","v":"User defined area #1"},{"$f":"'AVG Water Use By Month'!$C$5*'Turf Areas'!$G13","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$6*'Turf Areas'!$G13","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$7*'Turf Areas'!$G13","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$8*'Turf Areas'!$G13","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$9*'Turf Areas'!$G13","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$10*'Turf Areas'!$G13","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$11*'Turf Areas'!$G13","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$12*'Turf Areas'!$G13","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$13*'Turf Areas'!$G13","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$14*'Turf Areas'!$G13","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$15*'Turf Areas'!$G13","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$16*'Turf Areas'!$G13","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C12:N12)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Turf Areas'!B14","v":"User defined area #2"},{"$f":"'AVG Water Use By Month'!$C$5*'Turf Areas'!$G14","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$6*'Turf Areas'!$G14","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$7*'Turf Areas'!$G14","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$8*'Turf Areas'!$G14","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$9*'Turf Areas'!$G14","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$10*'Turf Areas'!$G14","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$11*'Turf Areas'!$G14","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$12*'Turf Areas'!$G14","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$13*'Turf Areas'!$G14","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$14*'Turf Areas'!$G14","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$15*'Turf Areas'!$G14","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$16*'Turf Areas'!$G14","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B15","v":"User defined area #3"},{"$f":"'AVG Water Use By Month'!$C$5*'Turf Areas'!$G15","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$6*'Turf Areas'!$G15","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$7*'Turf Areas'!$G15","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$8*'Turf Areas'!$G15","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$9*'Turf Areas'!$G15","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$10*'Turf Areas'!$G15","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$11*'Turf Areas'!$G15","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$12*'Turf Areas'!$G15","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$13*'Turf Areas'!$G15","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$14*'Turf Areas'!$G15","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$15*'Turf Areas'!$G15","v":{"$error":"#DIV/0!"}},{"$f":"'AVG Water Use By Month'!$C$16*'Turf Areas'!$G15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"Total",{"$f":"SUM(C5:C14)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D5:D14)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Jan - Mar","index":3,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,1,2,6],[1,8,2,13],[22,1,23,6]]}
[]
[null,"JANUARY IRRIGATION WATER ALLOCATIONS",null,null,null,null,null,null,"FEBRUARY IRRIGATION WATER ALLOCATIONS"]
[]
[null,"Area Description","Historical Water Use (in Gallons)",null,"Percent Reduction (Enter Intended Reductions Below)","Projected Water Use (in Gallons)","Projected Gallons Per Day",null,"Area Description","Historical Water Use (in Gallons)",null,"Percent Reduction (Enter Intended Reductions Below)","Projected Water Use (in Gallons)","Projected Gallons Per Day"]
[null,{"$f":"'Turf Areas'!B6","v":"Putting green complexes"},{"$f":"'AVG Water Use By Month'!$C$5*'Turf Areas'!$G6","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(1-(E5/100))*C5","v":{"$error":"#DIV/0!"}},{"$f":"F5/31","v":{"$error":"#DIV/0!"}},null,{"$f":"B5","v":"Putting green complexes"},{"$f":"'Monthly Water Use By Area'!D5","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(1-(L5/100))*J5","v":{"$error":"#DIV/0!"}},{"$f":"M5/28","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Turf Areas'!B7","v":"Teeing grounds"},{"$f":"'AVG Water Use By Month'!$C$5*'Turf Areas'!$G7","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Teeing grounds",{"$f":"'Monthly Water Use By Area'!D6","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B8","v":"Fairways"},{"$f":"'AVG Water Use By Month'!$C$5*'Turf Areas'!$G8","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Fairways",{"$f":"'Monthly Water Use By Area'!D7","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B9","v":"Primary rough"},{"$f":"'AVG Water Use By Month'!$C$5*'Turf Areas'!$G9","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Primary rough",{"$f":"'Monthly Water Use By Area'!D8","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B10","v":"Secondary rough"},{"$f":"'AVG Water Use By Month'!$C$5*'Turf Areas'!$G10","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Secondary rough",{"$f":"'Monthly Water Use By Area'!D9","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B11","v":"Practice range"},{"$f":"'AVG Water Use By Month'!$C$5*'Turf Areas'!$G11","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Practice range",{"$f":"'Monthly Water Use By Area'!D10","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B12","v":"Landscape areas"},{"$f":"'AVG Water Use By Month'!$C$5*'Turf Areas'!$G12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Landscape areas",{"$f":"'Monthly Water Use By Area'!D11","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B13","v":"User defined area #1"},{"$f":"'AVG Water Use By Month'!$C$5*'Turf Areas'!$G13","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"User defined area #1",{"$f":"'Monthly Water Use By Area'!D12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(1-(L12/100))*J12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B14","v":"User defined area #2"},{"$f":"'AVG Water Use By Month'!$C$5*'Turf Areas'!$G14","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"User defined area #2",{"$f":"'Monthly Water Use By Area'!D13","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B15","v":"User defined area #3"},{"$f":"'AVG Water Use By Month'!$C$5*'Turf Areas'!$G15","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"User defined area #3",{"$f":"'Monthly Water Use By Area'!D14","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Historical Average Water Use",{"$f":"SUM(C5:C14)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Historical Average Water Use",{"$f":"SUM(J5:J14)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Projected Water Use",{"$f":"SUM(F5:F14)","v":{"$error":"#DIV/0!"}},null,"Enter Actual Water Use in Gallons",null,null,null,"Projected Water Use",{"$f":"SUM(M5:M14)","v":{"$error":"#DIV/0!"}},null,"Enter Actual Water Use in Gallons"]
[]
[null,"Net Water Use Reduction",{"$f":"(C16-C18)/C16","v":{"$error":"#DIV/0!"}},null,"Net Actual Reduction",null,{"$f":"IF((G18>0), ((C16-G18)/C16), 0)","v":0},null,"Net Water Use Reduction",{"$f":"(J16-J18)/J16","v":{"$error":"#DIV/0!"}},null,"Net Actual Reduction",null,{"$f":"IF((N18>0),((J16-N18)/J16),(0))","v":0}]
[]
[]
[null,"MARCH IRRIGATION WATER ALLOCATIONS "]
[]
[null,"Area Description","Historical Water Use (in Gallons)",null,"Percent Reduction (Enter Intended Reductions Below)","Projected Water Use (in Gallons)","Projected Gallons Per Day"]
[null,{"$f":"I5","v":"Putting green complexes"},{"$f":"'Monthly Water Use By Area'!E5","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(1-(E26/100))*C26","v":{"$error":"#DIV/0!"}},{"$f":"F26/31","v":{"$error":"#DIV/0!"}}]
[null,"Teeing grounds",{"$f":"'Monthly Water Use By Area'!E6","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Fairways",{"$f":"'Monthly Water Use By Area'!E7","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Primary rough",{"$f":"'Monthly Water Use By Area'!E8","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Secondary rough",{"$f":"'Monthly Water Use By Area'!E9","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Practice range",{"$f":"'Monthly Water Use By Area'!E10","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Landscape areas",{"$f":"'Monthly Water Use By Area'!E11","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"User defined area #1",{"$f":"'Monthly Water Use By Area'!E12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"User defined area #2",{"$f":"'Monthly Water Use By Area'!E13","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"User defined area #3",{"$f":"'Monthly Water Use By Area'!E14","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Historical Average Water Use",{"$f":"SUM(C26:C35)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Projected Water Use",{"$f":"SUM(F26:F35)","v":{"$error":"#DIV/0!"}},null,"Enter Actual Water Use in Gallons"]
[]
[null,"Net Water Use Reduction",{"$f":"(C37-C39)/C37","v":{"$error":"#DIV/0!"}},null,"Net Actual Reduction",null,{"$f":"IF((G39>0),((C37-G39)/C37),0)","v":0}]

{"sheet":"Apr - June","index":4,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,1,2,6],[1,8,2,13],[22,1,23,6]]}
[]
[null,"APRIL IRRIGATION WATER ALLOCATIONS ",null,null,null,null,null,null,"MAY IRRIGATION WATER ALLOCATIONS "]
[]
[null,"Area Description","Historical Water Use (in Gallons)",null,"Percent Reduction (Enter Intended Reductions Below)","Projected Water Use (in Gallons)","Projected Gallons Per Day ",null,"Area Description","Historical Water Use (in Gallons)",null,"Percent Reduction (Enter Intended Reductions Below)","Projected Water Use (in Gallons)","Projected Gallons Per Day"]
[null,{"$f":"'Turf Areas'!B6","v":"Putting green complexes"},{"$f":"'Monthly Water Use By Area'!F5","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(1-(E5/100))*C5","v":{"$error":"#DIV/0!"}},{"$f":"F5/30","v":{"$error":"#DIV/0!"}},null,{"$f":"B5","v":"Putting green complexes"},{"$f":"'Monthly Water Use By Area'!G5","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(1-(L5/100))*J5","v":{"$error":"#DIV/0!"}},{"$f":"M5/31","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Turf Areas'!B7","v":"Teeing grounds"},{"$f":"'Monthly Water Use By Area'!F6","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Teeing grounds",{"$f":"'Monthly Water Use By Area'!G6","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"M6/31","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Turf Areas'!B8","v":"Fairways"},{"$f":"'Monthly Water Use By Area'!F7","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Fairways",{"$f":"'Monthly Water Use By Area'!G7","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B9","v":"Primary rough"},{"$f":"'Monthly Water Use By Area'!F8","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Primary rough",{"$f":"'Monthly Water Use By Area'!G8","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B10","v":"Secondary rough"},{"$f":"'Monthly Water Use By Area'!F9","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Secondary rough",{"$f":"'Monthly Water Use By Area'!G9","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B11","v":"Practice range"},{"$f":"'Monthly Water Use By Area'!F10","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Practice range",{"$f":"'Monthly Water Use By Area'!G10","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B12","v":"Landscape areas"},{"$f":"'Monthly Water Use By Area'!F11","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Landscape areas",{"$f":"'Monthly Water Use By Area'!G11","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"M11/31","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Turf Areas'!B13","v":"User defined area #1"},{"$f":"'Monthly Water Use By Area'!F12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"User defined area #1",{"$f":"'Monthly Water Use By Area'!G12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"M12/31","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Turf Areas'!B14","v":"User defined area #2"},{"$f":"'Monthly Water Use By Area'!F13","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"User defined area #2",{"$f":"'Monthly Water Use By Area'!G13","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"M13/31","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Turf Areas'!B15","v":"User defined area #3"},{"$f":"'Monthly Water Use By Area'!F14","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"User defined area #3",{"$f":"'Monthly Water Use By Area'!G14","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Historical Average Water Use",{"$f":"SUM(C5:C14)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Historical Average Water Use",{"$f":"SUM(J5:J14)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Projected Water Use",{"$f":"SUM(F5:F14)","v":{"$error":"#DIV/0!"}},null,"Enter Actual Water Use in Gallons",null,null,null,"Projected Water Use",{"$f":"SUM(M5:M14)","v":{"$error":"#DIV/0!"}},null,"Enter Actual Water Use in Gallons"]
[]
[null,"Net Water Use Reduction",{"$f":"(C16-C18)/C16","v":{"$error":"#DIV/0!"}},null,"Net Actual Reduction",null,{"$f":"IF((G18>0), ((C16-G18)/C16), 0)","v":0},null,"Net Water Use Reduction",{"$f":"(J16-J18)/J16","v":{"$error":"#DIV/0!"}},null,"Net Actual Reduction",null,{"$f":"IF((N18>0), ((J16-N18)/J16), 0)","v":0}]
[]
[]
[null,"JUNE IRRIGATION WATER ALLOCATIONS "]
[]
[null,"Area Description","Historical Water Use (in Gallons)",null,"Percent Reduction (Enter Intended Reductions Below)","Projected Water Use (in Gallons)","Projected Gallons Per Day"]
[null,{"$f":"B5","v":"Putting green complexes"},{"$f":"'Monthly Water Use By Area'!H5","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(1-(E26/100))*C26","v":{"$error":"#DIV/0!"}},{"$f":"F26/30","v":{"$error":"#DIV/0!"}}]
[null,"Teeing grounds",{"$f":"'Monthly Water Use By Area'!H6","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"F27/30","v":{"$error":"#DIV/0!"}}]
[null,"Fairways",{"$f":"'Monthly Water Use By Area'!H7","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Primary rough",{"$f":"'Monthly Water Use By Area'!H8","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Secondary rough",{"$f":"'Monthly Water Use By Area'!H9","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Practice range",{"$f":"'Monthly Water Use By Area'!H10","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Landscape areas",{"$f":"'Monthly Water Use By Area'!H11","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"F32/30","v":{"$error":"#DIV/0!"}}]
[null,"User defined area #1",{"$f":"'Monthly Water Use By Area'!H12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"F33/30","v":{"$error":"#DIV/0!"}}]
[null,"User defined area #2",{"$f":"'Monthly Water Use By Area'!H13","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"F34/30","v":{"$error":"#DIV/0!"}}]
[null,"User defined area #3",{"$f":"'Monthly Water Use By Area'!H14","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Historical Average Water Use",{"$f":"SUM(C26:C35)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Projected Water Use",{"$f":"SUM(F26:F35)","v":{"$error":"#DIV/0!"}},null,"Enter Actual Water Use in Gallons"]
[]
[null,"Net Water Use Reduction",{"$f":"(C37-C39)/C37","v":{"$error":"#DIV/0!"}},null,"Net Actual Reduction",null,{"$f":"IF((G39>0), ((C37-G39)/C37), 0)","v":0},null,"See Graph Below"]

{"sheet":"July - Sept","index":5,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,1,2,6],[1,8,2,13],[22,1,23,6]]}
[]
[null,"JULY IRRIGATION WATER ALLOCATIONS ",null,null,null,null,null,null,"AUGUST IRRIGATION WATER ALLOCATIONS "]
[]
[null,"Area Description","Historical Water Use (in Gallons)",null,"Percent Reduction (Enter Intended Reductions Below)","Projected Water Use (in Gallons)","Projected Gallons Per Day",null,"Area Description","Historical Water Use (in Gallons)",null,"Percent Reduction (Enter Intended Reductions Below)","Projected Water Use (in Gallons)","Projected Gallons Per Day"]
[null,{"$f":"'Turf Areas'!B6","v":"Putting green complexes"},{"$f":"'Monthly Water Use By Area'!I5","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(1-(E5/100))*C5","v":{"$error":"#DIV/0!"}},{"$f":"F5/31","v":{"$error":"#DIV/0!"}},null,{"$f":"'Jan - Mar'!B5","v":"Putting green complexes"},{"$f":"'Monthly Water Use By Area'!J5","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(1-(L5/100))*J5","v":{"$error":"#DIV/0!"}},{"$f":"M5/31","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Turf Areas'!B7","v":"Teeing grounds"},{"$f":"'Monthly Water Use By Area'!I6","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"F6/31","v":{"$error":"#DIV/0!"}},null,{"$f":"'Jan - Mar'!B6","v":"Teeing grounds"},{"$f":"'Monthly Water Use By Area'!J6","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"M6/31","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Turf Areas'!B8","v":"Fairways"},{"$f":"'Monthly Water Use By Area'!I7","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'Jan - Mar'!B7","v":"Fairways"},{"$f":"'Monthly Water Use By Area'!J7","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B9","v":"Primary rough"},{"$f":"'Monthly Water Use By Area'!I8","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'Jan - Mar'!B8","v":"Primary rough"},{"$f":"'Monthly Water Use By Area'!J8","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B10","v":"Secondary rough"},{"$f":"'Monthly Water Use By Area'!I9","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'Jan - Mar'!B9","v":"Secondary rough"},{"$f":"'Monthly Water Use By Area'!J9","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B11","v":"Practice range"},{"$f":"'Monthly Water Use By Area'!I10","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'Jan - Mar'!B10","v":"Practice range"},{"$f":"'Monthly Water Use By Area'!J10","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B12","v":"Landscape areas"},{"$f":"'Monthly Water Use By Area'!I11","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"F11/31","v":{"$error":"#DIV/0!"}},null,{"$f":"'Jan - Mar'!B11","v":"Landscape areas"},{"$f":"'Monthly Water Use By Area'!J11","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"M11/31","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Turf Areas'!B13","v":"User defined area #1"},{"$f":"'Monthly Water Use By Area'!I12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"F12/31","v":{"$error":"#DIV/0!"}},null,{"$f":"'Jan - Mar'!B12","v":"User defined area #1"},{"$f":"'Monthly Water Use By Area'!J12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"M12/31","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Turf Areas'!B14","v":"User defined area #2"},{"$f":"'Monthly Water Use By Area'!I13","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"F13/31","v":{"$error":"#DIV/0!"}},null,{"$f":"'Jan - Mar'!B13","v":"User defined area #2"},{"$f":"'Monthly Water Use By Area'!J13","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B15","v":"User defined area #3"},{"$f":"'Monthly Water Use By Area'!I14","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'Jan - Mar'!B14","v":"User defined area #3"},{"$f":"'Monthly Water Use By Area'!J14","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Historical Average Water Use",{"$f":"SUM(C5:C14)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Historical Average Water Use",{"$f":"SUM(J5:J14)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Projected Water Use",{"$f":"SUM(F5:F14)","v":{"$error":"#DIV/0!"}},null,"Enter Actual Water Use in Gallons",null,null,null,"Projected Water Use",{"$f":"SUM(M5:M14)","v":{"$error":"#DIV/0!"}},null,"Enter Actual Water Use in Gallons"]
[]
[null,"Net Water Use Reduction",{"$f":"(C16-C18)/C16","v":{"$error":"#DIV/0!"}},null,"Net Actual Reduction",null,{"$f":"IF((G18>0), ((C16-G18)/C16), 0)","v":0},null,"Net Water Use Reduction",{"$f":"(J16-J18)/J16","v":{"$error":"#DIV/0!"}},null,"Net Actual Reduction",null,{"$f":"IF((N18>0), ((J16-N18)/J16), 0)","v":0}]
[]
[]
[null,"SEPTEMBER IRRIGATION WATER ALLOCATIONS "]
[]
[null,"Area Description","Historical Water Use (in Gallons)",null,"Percent Reduction (Enter Intended Reductions Below)","Projected Water Use (in Gallons)","Projected Gallons Per Day"]
[null,{"$f":"'Jan - Mar'!B5","v":"Putting green complexes"},{"$f":"'Monthly Water Use By Area'!K5","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(1-(E26/100))*C26","v":{"$error":"#DIV/0!"}},{"$f":"F26/30","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Jan - Mar'!B6","v":"Teeing grounds"},{"$f":"'Monthly Water Use By Area'!K6","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"F27/30","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Jan - Mar'!B7","v":"Fairways"},{"$f":"'Monthly Water Use By Area'!K7","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Jan - Mar'!B8","v":"Primary rough"},{"$f":"'Monthly Water Use By Area'!K8","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Jan - Mar'!B9","v":"Secondary rough"},{"$f":"'Monthly Water Use By Area'!K9","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Jan - Mar'!B10","v":"Practice range"},{"$f":"'Monthly Water Use By Area'!K10","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Jan - Mar'!B11","v":"Landscape areas"},{"$f":"'Monthly Water Use By Area'!K11","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"F32/30","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Jan - Mar'!B12","v":"User defined area #1"},{"$f":"'Monthly Water Use By Area'!K12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"F33/30","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Jan - Mar'!B13","v":"User defined area #2"},{"$f":"'Monthly Water Use By Area'!K13","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"F34/30","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Jan - Mar'!B14","v":"User defined area #3"},{"$f":"'Monthly Water Use By Area'!K14","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Historical Average Water Use",{"$f":"SUM(C26:C35)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Projected Water Use",{"$f":"SUM(F26:F35)","v":{"$error":"#DIV/0!"}},null,"Enter Actual Water Use in Gallons"]
[]
[null,"Net Water Use Reduction",{"$f":"(C37-C39)/C37","v":{"$error":"#DIV/0!"}},null,"Net Actual Reduction",null,{"$f":"IF((G39>0), ((C37-G39)/C37), 0)","v":0},null,"See Graph Below"]

{"sheet":"Oct - Dec","index":6,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,1,2,6],[1,8,2,13],[22,1,23,6]]}
[]
[null,"OCTOBER IRRIGATION WATER ALLOCATIONS ",null,null,null,null,null,null,"NOVEMBER IRRIGATION WATER ALLOCATIONS "]
[]
[null,"Area Description","Historical Water Use (in Gallons)",null,"Percent Reduction (Enter Intended Reductions Below)","Projected Water Use (in Gallons)","Projected Gallons Per Day",null,"Area Description","Historical Water Use (in Gallons)",null,"Percent Reduction (Enter Intended Reductions Below)","Projected Water Use (in Gallons)","Projected Gallons Per Day"]
[null,{"$f":"'Turf Areas'!B6","v":"Putting green complexes"},{"$f":"'Monthly Water Use By Area'!L5","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(1-(E5/100))*C5","v":{"$error":"#DIV/0!"}},{"$f":"F5/31","v":{"$error":"#DIV/0!"}},null,{"$f":"'Jan - Mar'!B5","v":"Putting green complexes"},{"$f":"'Monthly Water Use By Area'!M5","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(1-(L5/100))*J5","v":{"$error":"#DIV/0!"}},{"$f":"M5/30","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Turf Areas'!B7","v":"Teeing grounds"},{"$f":"'Monthly Water Use By Area'!L6","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"F6/31","v":{"$error":"#DIV/0!"}},null,{"$f":"'Jan - Mar'!B6","v":"Teeing grounds"},{"$f":"'Monthly Water Use By Area'!M6","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"M6/30","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Turf Areas'!B8","v":"Fairways"},{"$f":"'Monthly Water Use By Area'!L7","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'Jan - Mar'!B7","v":"Fairways"},{"$f":"'Monthly Water Use By Area'!M7","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B9","v":"Primary rough"},{"$f":"'Monthly Water Use By Area'!L8","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'Jan - Mar'!B8","v":"Primary rough"},{"$f":"'Monthly Water Use By Area'!M8","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B10","v":"Secondary rough"},{"$f":"'Monthly Water Use By Area'!L9","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'Jan - Mar'!B9","v":"Secondary rough"},{"$f":"'Monthly Water Use By Area'!M9","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B11","v":"Practice range"},{"$f":"'Monthly Water Use By Area'!L10","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'Jan - Mar'!B10","v":"Practice range"},{"$f":"'Monthly Water Use By Area'!M10","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Turf Areas'!B12","v":"Landscape areas"},{"$f":"'Monthly Water Use By Area'!L11","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"F11/31","v":{"$error":"#DIV/0!"}},null,{"$f":"'Jan - Mar'!B11","v":"Landscape areas"},{"$f":"'Monthly Water Use By Area'!M11","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"M11/30","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Turf Areas'!B13","v":"User defined area #1"},{"$f":"'Monthly Water Use By Area'!L12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"F12/31","v":{"$error":"#DIV/0!"}},null,{"$f":"'Jan - Mar'!B12","v":"User defined area #1"},{"$f":"'Monthly Water Use By Area'!M12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"M12/30","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Turf Areas'!B14","v":"User defined area #2"},{"$f":"'Monthly Water Use By Area'!L13","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"F13/31","v":{"$error":"#DIV/0!"}},null,{"$f":"'Jan - Mar'!B13","v":"User defined area #2"},{"$f":"'Monthly Water Use By Area'!M13","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"M13/30","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Turf Areas'!B15","v":"User defined area #3"},{"$f":"'Monthly Water Use By Area'!L14","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'Jan - Mar'!B14","v":"User defined area #3"},{"$f":"'Monthly Water Use By Area'!M14","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Historical Average Water Use",{"$f":"SUM(C5:C14)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Historical Average Water Use",{"$f":"SUM(J5:J14)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Projected Water Use",{"$f":"SUM(F5:F14)","v":{"$error":"#DIV/0!"}},null,"Enter Actual Water Use in Gallons",null,null,null,"Projected Water Use",{"$f":"SUM(M5:M14)","v":{"$error":"#DIV/0!"}},null,"Enter Actual Water Use in Gallons"]
[]
[null,"Net Water Use Reduction",{"$f":"(C16-C18)/C16","v":{"$error":"#DIV/0!"}},null,"Net Actual Reduction",null,{"$f":"IF((G18>0), ((C16-G18)/C16), 0)","v":0},null,"Net Water Use Reduction",{"$f":"(J16-J18)/J16","v":{"$error":"#DIV/0!"}},null,"Net Actual Reduction",null,{"$f":"IF((N18>0), ((J16-N18)/J16), 0)","v":0}]
[]
[]
[null,"DECEMBER IRRIGATION WATER ALLOCATIONS "]
[]
[null,"Area Description","Historical Water Use (in Gallons)",null,"Percent Reduction (Enter Intended Reductions Below)","Projected Water Use (in Gallons)","Projected Gallons Per Day"]
[null,{"$f":"'Jan - Mar'!B5","v":"Putting green complexes"},{"$f":"'Monthly Water Use By Area'!N5","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(1-(E26/100))*C26","v":{"$error":"#DIV/0!"}},{"$f":"F26/31","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Jan - Mar'!B6","v":"Teeing grounds"},{"$f":"'Monthly Water Use By Area'!N6","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"F27/31","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Jan - Mar'!B7","v":"Fairways"},{"$f":"'Monthly Water Use By Area'!N7","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Jan - Mar'!B8","v":"Primary rough"},{"$f":"'Monthly Water Use By Area'!N8","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Jan - Mar'!B9","v":"Secondary rough"},{"$f":"'Monthly Water Use By Area'!N9","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Jan - Mar'!B10","v":"Practice range"},{"$f":"'Monthly Water Use By Area'!N10","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Jan - Mar'!B11","v":"Landscape areas"},{"$f":"'Monthly Water Use By Area'!N11","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"F32/31","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Jan - Mar'!B12","v":"User defined area #1"},{"$f":"'Monthly Water Use By Area'!N12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"F33/31","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Jan - Mar'!B13","v":"User defined area #2"},{"$f":"'Monthly Water Use By Area'!N13","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"F34/31","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Jan - Mar'!B14","v":"User defined area #3"},{"$f":"'Monthly Water Use By Area'!N14","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Historical Average Water Use",{"$f":"SUM(C26:C35)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Projected Water Use",{"$f":"SUM(F26:F35)","v":{"$error":"#DIV/0!"}},null,"Enter Actual Water Use in Gallons"]
[]
[null,"Net Water Use Reduction",{"$f":"(C37-C39)/C37","v":{"$error":"#DIV/0!"}},null,"Net Actual Reduction",null,{"$f":"IF((G39>0), ((C37-G39)/C37), 0)","v":0},null,"See Graph Below"]

{"sheet":"Est. Water Requirement","index":7,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,1,2,7]]}
[]
[null,"Estimated Plant Water Requirement Based on Actual Monthly Rainfall and ET"]
[]
[null,"Assumptions"]
[null,"Effective Rainfall (Enter Here)",null,0.5]
[null,"Crop Coefficient Percentage (Enter Here)",null,0.8]
[null,"Month","Monthly ET (Inches)","Rainfall (Inches)","Req. Per Acre          (Inches)","Req. Per Acre      (Acre Feet)","Water Requirement (Gallons)","Water Requirement    (HCF)"]
[null,null,"(Enter Values)","(Enter Values)"]
[null,"Jan",null,null,{"$f":"(C9*$D$6)-(D9*$D$5)","v":0},{"$f":"E9/12","v":0},{"$f":"IF('Est. Water Requirement'!F9<0,0,(('Est. Water Requirement'!F9*'Turf Areas'!$F$16)*325853))","v":0},{"$f":"G9/748","v":0}]
[null,"Feb",null,null,0,{"$f":"E10/12","v":0},{"$f":"IF('Est. Water Requirement'!F10<0,0,(('Est. Water Requirement'!F10*'Turf Areas'!$F$16)*325853))","v":0},0]
[null,"Mar",null,null,0,0,{"$f":"IF('Est. Water Requirement'!F11<0,0,(('Est. Water Requirement'!F11*'Turf Areas'!$F$16)*325853))","v":0},0]
[null,"April",null,null,0,0,{"$f":"IF('Est. Water Requirement'!F12<0,0,(('Est. Water Requirement'!F12*'Turf Areas'!$F$16)*325853))","v":0},0]
[null,"May",null,null,0,0,{"$f":"IF('Est. Water Requirement'!F13<0,0,(('Est. Water Requirement'!F13*'Turf Areas'!$F$16)*325853))","v":0},0]
[null,"June",null,null,0,0,{"$f":"IF('Est. Water Requirement'!F14<0,0,(('Est. Water Requirement'!F14*'Turf Areas'!$F$16)*325853))","v":0},0]
[null,"July",null,null,0,0,{"$f":"IF('Est. Water Requirement'!F15<0,0,(('Est. Water Requirement'!F15*'Turf Areas'!$F$16)*325853))","v":0},0]
[null,"Aug",null,null,0,0,{"$f":"IF('Est. Water Requirement'!F16<0,0,(('Est. Water Requirement'!F16*'Turf Areas'!$F$16)*325853))","v":0},0]
[null,"Sept",null,null,0,0,{"$f":"IF('Est. Water Requirement'!F17<0,0,(('Est. Water Requirement'!F17*'Turf Areas'!$F$16)*325853))","v":0},0]
[null,"Oct",null,null,0,0,{"$f":"IF('Est. Water Requirement'!F18<0,0,(('Est. Water Requirement'!F18*'Turf Areas'!$F$16)*325853))","v":0},0]
[null,"Nov",null,null,0,0,{"$f":"IF('Est. Water Requirement'!F19<0,0,(('Est. Water Requirement'!F19*'Turf Areas'!$F$16)*325853))","v":0},0]
[null,"Dec",null,null,0,0,{"$f":"IF('Est. Water Requirement'!F20<0,0,(('Est. Water Requirement'!F20*'Turf Areas'!$F$16)*325853))","v":0},0]
[null,"Total",{"$f":"SUM(C9:C20)","v":0},0,0,0,0,0]
[]
[null,"Estimated Plant Water Requirement by Area and Month (Gallons)"]
[null,"Area Description","Jan","Feb","Mar","April","May","June","July","Aug","Sept","Oct","Nov","Dec","Total"]
[null,{"$f":"'Jan - Mar'!B5","v":"Putting green complexes"},{"$f":"'Est. Water Requirement'!$G$9*'Turf Areas'!G6","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$10*'Turf Areas'!G6","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$11*'Turf Areas'!G6","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$12*'Turf Areas'!G6","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$13*'Turf Areas'!G6","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$14*'Turf Areas'!G6","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$15*'Turf Areas'!G6","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$16*'Turf Areas'!G6","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$17*'Turf Areas'!G6","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$18*'Turf Areas'!G6","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$19*'Turf Areas'!G6","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$20*'Turf Areas'!G6","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C25:N25)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Jan - Mar'!B6","v":"Teeing grounds"},{"$f":"'Est. Water Requirement'!$G$9*'Turf Areas'!G7","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$10*'Turf Areas'!G7","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$11*'Turf Areas'!G7","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$12*'Turf Areas'!G7","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$13*'Turf Areas'!G7","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$14*'Turf Areas'!G7","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$15*'Turf Areas'!G7","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$16*'Turf Areas'!G7","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$17*'Turf Areas'!G7","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$18*'Turf Areas'!G7","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$19*'Turf Areas'!G7","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$20*'Turf Areas'!G7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"'Jan - Mar'!B7","v":"Fairways"},{"$f":"'Est. Water Requirement'!$G$9*'Turf Areas'!G8","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$10*'Turf Areas'!G8","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$11*'Turf Areas'!G8","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$12*'Turf Areas'!G8","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$13*'Turf Areas'!G8","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$14*'Turf Areas'!G8","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$15*'Turf Areas'!G8","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$16*'Turf Areas'!G8","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$17*'Turf Areas'!G8","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$18*'Turf Areas'!G8","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$19*'Turf Areas'!G8","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$20*'Turf Areas'!G8","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"'Jan - Mar'!B8","v":"Primary rough"},{"$f":"'Est. Water Requirement'!$G$9*'Turf Areas'!G9","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$10*'Turf Areas'!G9","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$11*'Turf Areas'!G9","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$12*'Turf Areas'!G9","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$13*'Turf Areas'!G9","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$14*'Turf Areas'!G9","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$15*'Turf Areas'!G9","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$16*'Turf Areas'!G9","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$17*'Turf Areas'!G9","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$18*'Turf Areas'!G9","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$19*'Turf Areas'!G9","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$20*'Turf Areas'!G9","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"'Jan - Mar'!B9","v":"Secondary rough"},{"$f":"'Est. Water Requirement'!$G$9*'Turf Areas'!G10","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$10*'Turf Areas'!G10","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$11*'Turf Areas'!G10","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$12*'Turf Areas'!G10","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$13*'Turf Areas'!G10","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$14*'Turf Areas'!G10","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$15*'Turf Areas'!G10","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$16*'Turf Areas'!G10","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$17*'Turf Areas'!G10","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$18*'Turf Areas'!G10","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$19*'Turf Areas'!G10","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$20*'Turf Areas'!G10","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"'Jan - Mar'!B10","v":"Practice range"},{"$f":"'Est. Water Requirement'!$G$9*'Turf Areas'!G11","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$10*'Turf Areas'!G11","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$11*'Turf Areas'!G11","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$12*'Turf Areas'!G11","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$13*'Turf Areas'!G11","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$14*'Turf Areas'!G11","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$15*'Turf Areas'!G11","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$16*'Turf Areas'!G11","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$17*'Turf Areas'!G11","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$18*'Turf Areas'!G11","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$19*'Turf Areas'!G11","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$20*'Turf Areas'!G11","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"'Jan - Mar'!B11","v":"Landscape areas"},{"$f":"'Est. Water Requirement'!$G$9*'Turf Areas'!G12","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$10*'Turf Areas'!G12","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$11*'Turf Areas'!G12","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$12*'Turf Areas'!G12","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$13*'Turf Areas'!G12","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$14*'Turf Areas'!G12","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$15*'Turf Areas'!G12","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$16*'Turf Areas'!G12","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$17*'Turf Areas'!G12","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$18*'Turf Areas'!G12","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$19*'Turf Areas'!G12","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$20*'Turf Areas'!G12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"'Jan - Mar'!B12","v":"User defined area #1"},{"$f":"'Est. Water Requirement'!$G$9*'Turf Areas'!G13","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$10*'Turf Areas'!G13","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$11*'Turf Areas'!G13","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$12*'Turf Areas'!G13","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$13*'Turf Areas'!G13","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$14*'Turf Areas'!G13","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$15*'Turf Areas'!G13","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$16*'Turf Areas'!G13","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$17*'Turf Areas'!G13","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$18*'Turf Areas'!G13","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$19*'Turf Areas'!G13","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$20*'Turf Areas'!G13","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"'Jan - Mar'!B13","v":"User defined area #2"},{"$f":"'Est. Water Requirement'!$G$9*'Turf Areas'!G14","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$10*'Turf Areas'!G14","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$11*'Turf Areas'!G14","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$12*'Turf Areas'!G14","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$13*'Turf Areas'!G14","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$14*'Turf Areas'!G14","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$15*'Turf Areas'!G14","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$16*'Turf Areas'!G14","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$17*'Turf Areas'!G14","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$18*'Turf Areas'!G14","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$19*'Turf Areas'!G14","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$20*'Turf Areas'!G14","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"'Jan - Mar'!B14","v":"User defined area #3"},{"$f":"'Est. Water Requirement'!$G$9*'Turf Areas'!G15","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$10*'Turf Areas'!G15","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$11*'Turf Areas'!G15","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$12*'Turf Areas'!G15","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$13*'Turf Areas'!G15","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$14*'Turf Areas'!G15","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$15*'Turf Areas'!G15","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$16*'Turf Areas'!G15","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$17*'Turf Areas'!G15","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$18*'Turf Areas'!G15","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$19*'Turf Areas'!G15","v":{"$error":"#DIV/0!"}},{"$f":"'Est. Water Requirement'!$G$20*'Turf Areas'!G15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"Total",{"$f":"SUM(C25:C34)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Annual Water Use","index":8,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,2,5],[1,7,2,12]]}
[null,null,null,null,null,null,null,"HCF"]
[null,"Annual Water Use in Gallons",null,null,null,null,null,"Economics"]
[]
[null,null,"Water Requirement","Historical","Projected","Actual Recorded Water Usage",null,"Water Use Unit (Select Below)","Cost per Unit (Enter Below)","Projected Water Savings","Actual Water Savings","Projected Savings","Actual Savings"]
[null,"Jan",{"$f":"'Est. Water Requirement'!G9","v":0},{"$f":"'Jan - Mar'!C16","v":{"$error":"#DIV/0!"}},{"$f":"'Jan - Mar'!C18","v":{"$error":"#DIV/0!"}},{"$f":"'Jan - Mar'!G18","v":0},null,"Gallons",null,{"$f":"-(E17-D17)","v":{"$error":"#DIV/0!"}},{"$f":"-(F17-D17)","v":{"$error":"#DIV/0!"}},{"$f":"IF((H5=\"Gallons\"), ((I5*J5)), IF((H5=\"Acre Feet\"), ((J5/325851)*I5), ((J5/748)*I5)))","v":{"$error":"#DIV/0!"}},{"$f":"IF((H5=\"Gallons\"), ((I5*K5)), IF((H5=\"Acre Feet\"), ((K5/325851)*I5), ((K5/748)*I5)))","v":{"$error":"#DIV/0!"}}]
[null,"Feb",{"$f":"'Est. Water Requirement'!G10","v":0},{"$f":"'Jan - Mar'!J16","v":{"$error":"#DIV/0!"}},{"$f":"'Jan - Mar'!J18","v":{"$error":"#DIV/0!"}},{"$f":"'Jan - Mar'!N18","v":0}]
[null,"March",{"$f":"'Est. Water Requirement'!G11","v":0},{"$f":"'Jan - Mar'!C37","v":{"$error":"#DIV/0!"}},{"$f":"'Jan - Mar'!C39","v":{"$error":"#DIV/0!"}},{"$f":"'Jan - Mar'!G39","v":0}]
[null,"April ",{"$f":"'Est. Water Requirement'!G12","v":0},{"$f":"'Apr - June'!C16","v":{"$error":"#DIV/0!"}},{"$f":"'Apr - June'!C18","v":{"$error":"#DIV/0!"}},{"$f":"'Apr - June'!G18","v":0}]
[null,"May",{"$f":"'Est. Water Requirement'!G13","v":0},{"$f":"'Apr - June'!J16","v":{"$error":"#DIV/0!"}},{"$f":"'Apr - June'!J18","v":{"$error":"#DIV/0!"}},{"$f":"'Apr - June'!N18","v":0}]
[null,"June",{"$f":"'Est. Water Requirement'!G14","v":0},{"$f":"'Apr - June'!C37","v":{"$error":"#DIV/0!"}},{"$f":"'Apr - June'!C39","v":{"$error":"#DIV/0!"}},{"$f":"'Apr - June'!G39","v":0}]
[null,"July",{"$f":"'Est. Water Requirement'!G15","v":0},{"$f":"'July - Sept'!C16","v":{"$error":"#DIV/0!"}},{"$f":"'July - Sept'!C18","v":{"$error":"#DIV/0!"}},{"$f":"'July - Sept'!G18","v":0}]
[null,"Aug",{"$f":"'Est. Water Requirement'!G16","v":0},{"$f":"'July - Sept'!J16","v":{"$error":"#DIV/0!"}},{"$f":"'July - Sept'!J18","v":{"$error":"#DIV/0!"}},{"$f":"'July - Sept'!N18","v":0}]
[null,"Sept",{"$f":"'Est. Water Requirement'!G17","v":0},{"$f":"'July - Sept'!C37","v":{"$error":"#DIV/0!"}},{"$f":"'July - Sept'!C39","v":{"$error":"#DIV/0!"}},{"$f":"'July - Sept'!G39","v":0}]
[null,"Oct",{"$f":"'Est. Water Requirement'!G18","v":0},{"$f":"'Oct - Dec'!C16","v":{"$error":"#DIV/0!"}},{"$f":"'Oct - Dec'!C18","v":{"$error":"#DIV/0!"}},{"$f":"'Oct - Dec'!G18","v":0}]
[null,"Nov",{"$f":"'Est. Water Requirement'!G19","v":0},{"$f":"'Oct - Dec'!J16","v":{"$error":"#DIV/0!"}},{"$f":"'Oct - Dec'!J18","v":{"$error":"#DIV/0!"}},{"$f":"'Oct - Dec'!N18","v":0}]
[null,"Dec",{"$f":"'Est. Water Requirement'!G20","v":0},{"$f":"'Oct - Dec'!C37","v":{"$error":"#DIV/0!"}},{"$f":"'Oct - Dec'!C39","v":{"$error":"#DIV/0!"}},{"$f":"'Oct - Dec'!G39","v":0}]
[null,"Totals",{"$f":"SUM('Est. Water Requirement'!G9:G20)","v":0},{"$f":"SUM(D5:D16)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E5:E16)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F5:F16)","v":0}]

{"sheet":"Calculations","index":9,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Monthly Projected","Monthly Actual","Annual Projected ","Annual Actual "]
[null,"Jan",{"$f":"'Jan - Mar'!C20","v":{"$error":"#DIV/0!"}},{"$f":"'Jan - Mar'!$G$20","v":0},{"$f":"'Jan - Mar'!C20","v":{"$error":"#DIV/0!"}},{"$f":"'Jan - Mar'!G20","v":0}]
[null,"Feb",{"$f":"'Jan - Mar'!J20","v":{"$error":"#DIV/0!"}},{"$f":"'Jan - Mar'!$N$20","v":0},{"$f":"('Jan - Mar'!C20+'Jan - Mar'!J20)/2","v":{"$error":"#DIV/0!"}},{"$f":"('Jan - Mar'!G20+'Jan - Mar'!N20)/2","v":0}]
[null,"March",{"$f":"'Jan - Mar'!C41","v":{"$error":"#DIV/0!"}},{"$f":"'Jan - Mar'!$G$41","v":0},{"$f":"('Jan - Mar'!C20+'Jan - Mar'!J20+'Jan - Mar'!C41)/3","v":{"$error":"#DIV/0!"}},{"$f":"('Jan - Mar'!G20+'Jan - Mar'!N20+'Jan - Mar'!G41)/3","v":0}]
[null,"April ",{"$f":"'Apr - June'!C20","v":{"$error":"#DIV/0!"}},{"$f":"'Apr - June'!$G$20","v":0},{"$f":"AVERAGE('Jan - Mar'!C20,'Jan - Mar'!J20,'Jan - Mar'!C41,'Apr - June'!C20)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Jan - Mar'!G20,'Jan - Mar'!N20,'Jan - Mar'!G41,'Apr - June'!G20)","v":0}]
[null,"May",{"$f":"'Apr - June'!J20","v":{"$error":"#DIV/0!"}},{"$f":"'Apr - June'!$N$20","v":0},{"$f":"AVERAGE('Jan - Mar'!C20,'Jan - Mar'!J20,'Jan - Mar'!C41,'Apr - June'!C20,'Apr - June'!J20)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Jan - Mar'!G20,'Jan - Mar'!N20,'Jan - Mar'!G41,'Apr - June'!G20,'Apr - June'!N20)","v":0}]
[null,"June",{"$f":"'Apr - June'!C41","v":{"$error":"#DIV/0!"}},{"$f":"'Apr - June'!$G$41","v":0},{"$f":"AVERAGE('Jan - Mar'!C20,'Jan - Mar'!J20,'Jan - Mar'!C41,'Apr - June'!C20,'Apr - June'!J20,'Apr - June'!C41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Jan - Mar'!G20,'Jan - Mar'!N20,'Jan - Mar'!G41,'Apr - June'!G20,'Apr - June'!N20,'Apr - June'!G41)","v":0}]
[null,"July",{"$f":"'July - Sept'!C20","v":{"$error":"#DIV/0!"}},{"$f":"'July - Sept'!$G$20","v":0},{"$f":"AVERAGE('Jan - Mar'!C20,'Jan - Mar'!J20,'Jan - Mar'!C41,'Apr - June'!C20,'Apr - June'!J20,'Apr - June'!C41,'July - Sept'!C20)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Jan - Mar'!G20,'Jan - Mar'!N20,'Jan - Mar'!G41,'Apr - June'!G20,'Apr - June'!N20,'Apr - June'!G41,'July - Sept'!G20)","v":0}]
[null,"Aug",{"$f":"'July - Sept'!J20","v":{"$error":"#DIV/0!"}},{"$f":"'July - Sept'!$N$20","v":0},{"$f":"AVERAGE('Jan - Mar'!C20,'Jan - Mar'!J20,'Jan - Mar'!C41,'Apr - June'!C20,'Apr - June'!J20,'Apr - June'!C41,'July - Sept'!C20,'July - Sept'!J20)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Jan - Mar'!G20,'Jan - Mar'!N20,'Jan - Mar'!G41,'Apr - June'!G20,'Apr - June'!N20,'Apr - June'!G41,'July - Sept'!G20,'July - Sept'!N20)","v":0}]
[null,"Sept",{"$f":"'July - Sept'!C41","v":{"$error":"#DIV/0!"}},{"$f":"'July - Sept'!$G$41","v":0},{"$f":"AVERAGE('Jan - Mar'!C20,'Jan - Mar'!J20,'Jan - Mar'!C41,'Apr - June'!C20,'Apr - June'!J20,'Apr - June'!C41,'July - Sept'!C20,'July - Sept'!J20,'July - Sept'!C41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Jan - Mar'!G20,'Jan - Mar'!N20,'Jan - Mar'!G41,'Apr - June'!G20,'Apr - June'!N20,'Apr - June'!G41,'July - Sept'!G20,'July - Sept'!N20,'July - Sept'!G41)","v":0}]
[null,"Oct",{"$f":"'Oct - Dec'!C20","v":{"$error":"#DIV/0!"}},{"$f":"'Oct - Dec'!G20","v":0},{"$f":"AVERAGE('Jan - Mar'!C20,'Jan - Mar'!J20,'Jan - Mar'!C41,'Apr - June'!C20,'Apr - June'!J20,'Apr - June'!C41,'July - Sept'!C20,'July - Sept'!J20,'July - Sept'!C41,'Oct - Dec'!C20)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Jan - Mar'!G20,'Jan - Mar'!N20,'Jan - Mar'!G41,'Apr - June'!G20,'Apr - June'!N20,'Apr - June'!G41,'July - Sept'!G20,'July - Sept'!N20,'July - Sept'!G41,'Oct - Dec'!G20)","v":0}]
[null,"Nov",{"$f":"'Oct - Dec'!J20","v":{"$error":"#DIV/0!"}},{"$f":"'Oct - Dec'!N20","v":0},{"$f":"AVERAGE('Jan - Mar'!C20,'Jan - Mar'!J20,'Jan - Mar'!C41,'Apr - June'!C20,'Apr - June'!J20,'Apr - June'!C41,'July - Sept'!C20,'July - Sept'!J20,'July - Sept'!C41,'Oct - Dec'!C20,'Oct - Dec'!J20)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Jan - Mar'!G20,'Jan - Mar'!N20,'Jan - Mar'!G41,'Apr - June'!G20,'Apr - June'!N20,'Apr - June'!G41,'July - Sept'!G20,'July - Sept'!N20,'July - Sept'!G41,'Oct - Dec'!G20,'Oct - Dec'!N20)","v":0}]
[null,"Dec",{"$f":"'Oct - Dec'!C41","v":{"$error":"#DIV/0!"}},{"$f":"'Oct - Dec'!G41","v":0},{"$f":"AVERAGE('Jan - Mar'!C20,'Jan - Mar'!J20,'Jan - Mar'!C41,'Apr - June'!C20,'Apr - June'!J20,'Apr - June'!C41,'July - Sept'!C20,'July - Sept'!J20,'July - Sept'!C41,'Oct - Dec'!C20,'Oct - Dec'!J20,'Oct - Dec'!C41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Jan - Mar'!G20,'Jan - Mar'!N20,'Jan - Mar'!G41,'Apr - June'!G20,'Apr - June'!N20,'Apr - June'!G41,'July - Sept'!G20,'July - Sept'!N20,'July - Sept'!G41,'Oct - Dec'!G20,'Oct - Dec'!N20,'Oct - Dec'!G41)","v":0}]

{"sheet":"Sheet1","index":10,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[null,"C[-1]","C","C[1]"]
[]
[null,null,325851,748]
[null,"gallons ","ac ft","hcf"]
["Jan",null,null,null,null,1]
["Feb",null,null,null,null,2]
["Mar",null,null,null,null,3]
["Apr",null,null,null,null,4]
["May",null,null,null,null,5]
["Jun",null,null,null,null,6]
["Jul",null,null,null,null,7]
["Aug",null,null,null,null,8]
["Sept",null,null,null,null,9]
["Oct",null,null,null,null,10]
["Nov",null,null,null,null,11]
["Dec",null,null,null,null,12]

{"sheet":"Sheet8","index":11,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[null,8,3472.2080000000001]
[2932659,9,3906.2339999999999]
[1303404,4,1736.104]
[17595954,54,23437.404000000002]
[1629255,5,2170.13]
[24112974,74,32117.923999999999]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[null,null,null,null,null,null,null,null,5]