{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["January","February","March","April","May","June","July","August","September","October","November","December","Totals"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"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":"January","index":0,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["WATER USAGE REPORT"]
["Record source water withdrawals and purchases in the table below in \"Gallons\"."]
[]
["Enter Source Name >>"]
["Date",{"$f":"IF(B4=\"\",\"Groundwater\",B4)","v":"Groundwater"},{"$f":"IF(C4=\"\",\"Groundwater\",C4)","v":"Groundwater"},"Groundwater","Groundwater","Groundwater","Groundwater","Groundwater",{"$f":"IF(I4=\"\",\"Surface Water\",I4)","v":"Surface Water"},{"$f":"IF(J4=\"\",\"Surface Water\",J4)","v":"Surface Water"},{"$f":"IF(K4=\"\",\"Purchase Water\",K4)","v":"Purchase Water"},{"$f":"IF(L4=\"\",\"Purchase Water\",L4)","v":"Purchase Water"},{"$f":"IF(M4=\"\",\"Purchase Water\",M4)","v":"Purchase Water"}]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
["Total (gal)",{"$f":"SUM(B6:B36)","v":0},{"$f":"SUM(C6:C36)","v":0},0,0,0,0,0,{"$f":"SUM(I6:I36)","v":0},0,0,0,{"$f":"SUM(M6:M36)","v":0}]
["Avg.",{"$f":"IF(B37>0,B37/1000000/DAY(DATE(Totals!$B$3,1+1,1)-1),0)","v":0},{"$f":"IF(C37>0,C37/1000000/DAY(DATE(Totals!$B$3,2+1,1)-1),0)","v":0},{"$f":"IF(D37>0,D37/1000000/DAY(DATE(Totals!$B$3,3+1,1)-1),0)","v":0},{"$f":"IF(E37>0,E37/1000000/DAY(DATE(Totals!$B$3,4+1,1)-1),0)","v":0},{"$f":"IF(F37>0,F37/1000000/DAY(DATE(Totals!$B$3,5+1,1)-1),0)","v":0},{"$f":"IF(G37>0,G37/1000000/DAY(DATE(Totals!$B$3,6+1,1)-1),0)","v":0},{"$f":"IF(H37>0,H37/1000000/DAY(DATE(Totals!$B$3,7+1,1)-1),0)","v":0},{"$f":"IF(I37>0,I37/1000000/DAY(DATE(Totals!$B$3,8+1,1)-1),0)","v":0},{"$f":"IF(J37>0,J37/1000000/DAY(DATE(Totals!$B$3,9+1,1)-1),0)","v":0},{"$f":"IF(K37>0,K37/1000000/DAY(DATE(Totals!$B$3,10+1,1)-1),0)","v":0},{"$f":"IF(L37>0,L37/1000000/DAY(DATE(Totals!$B$3,11+1,1)-1),0)","v":0},{"$f":"IF(M37>0,M37/1000000/DAY(DATE(Totals!$B$3,12+1,1)-1),0)","v":0}]
["Max.",{"$f":"MAX(B6:B36)/1000000","v":0},{"$f":"MAX(C6:C36)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]
["Min.",{"$f":"MIN(B6:B36)/1000000","v":0},{"$f":"MIN(C6:C36)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"February","index":1,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["WATER USAGE REPORT"]
["Record source water withdrawals and purchases in the table below in \"Gallons\"."]
[]
[]
["Date",{"$f":"January!B5","v":"Groundwater"},{"$f":"January!C5","v":"Groundwater"},{"$f":"January!D5","v":"Groundwater"},{"$f":"January!E5","v":"Groundwater"},{"$f":"January!F5","v":"Groundwater"},{"$f":"January!G5","v":"Groundwater"},{"$f":"January!H5","v":"Groundwater"},{"$f":"January!I5","v":"Surface Water"},{"$f":"January!J5","v":"Surface Water"},{"$f":"January!K5","v":"Purchase Water"},{"$f":"January!L5","v":"Purchase Water"},{"$f":"January!M5","v":"Purchase Water"}]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
["Total (gal)",{"$f":"SUM(B6:B36)","v":0},{"$f":"SUM(C6:C36)","v":0},0,0,0,0,0,{"$f":"SUM(I6:I36)","v":0},0,0,0,{"$f":"SUM(M6:M36)","v":0}]
["Avg.",{"$f":"IF(B37>0,B37/1000000/DAY(DATE(Totals!$B$3,1+1,1)-1),0)","v":0},{"$f":"IF(C37>0,C37/1000000/DAY(DATE(Totals!$B$3,2+1,1)-1),0)","v":0},{"$f":"IF(D37>0,D37/1000000/DAY(DATE(Totals!$B$3,3+1,1)-1),0)","v":0},{"$f":"IF(E37>0,E37/1000000/DAY(DATE(Totals!$B$3,4+1,1)-1),0)","v":0},{"$f":"IF(F37>0,F37/1000000/DAY(DATE(Totals!$B$3,5+1,1)-1),0)","v":0},{"$f":"IF(G37>0,G37/1000000/DAY(DATE(Totals!$B$3,6+1,1)-1),0)","v":0},{"$f":"IF(H37>0,H37/1000000/DAY(DATE(Totals!$B$3,7+1,1)-1),0)","v":0},{"$f":"IF(I37>0,I37/1000000/DAY(DATE(Totals!$B$3,8+1,1)-1),0)","v":0},{"$f":"IF(J37>0,J37/1000000/DAY(DATE(Totals!$B$3,9+1,1)-1),0)","v":0},{"$f":"IF(K37>0,K37/1000000/DAY(DATE(Totals!$B$3,10+1,1)-1),0)","v":0},{"$f":"IF(L37>0,L37/1000000/DAY(DATE(Totals!$B$3,11+1,1)-1),0)","v":0},{"$f":"IF(M37>0,M37/1000000/DAY(DATE(Totals!$B$3,12+1,1)-1),0)","v":0}]
["Max.",{"$f":"MAX(B6:B36)/1000000","v":0},{"$f":"MAX(C6:C36)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]
["Min.",{"$f":"MIN(B6:B36)/1000000","v":0},{"$f":"MIN(C6:C36)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"March","index":2,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["WATER USAGE REPORT"]
["Record source water withdrawals and purchases in the table below in \"Gallons\"."]
[]
[]
["Date",{"$f":"January!B5","v":"Groundwater"},{"$f":"January!C5","v":"Groundwater"},{"$f":"January!D5","v":"Groundwater"},{"$f":"January!E5","v":"Groundwater"},{"$f":"January!F5","v":"Groundwater"},{"$f":"January!G5","v":"Groundwater"},{"$f":"January!H5","v":"Groundwater"},{"$f":"January!I5","v":"Surface Water"},{"$f":"January!J5","v":"Surface Water"},{"$f":"January!K5","v":"Purchase Water"},{"$f":"January!L5","v":"Purchase Water"},{"$f":"January!M5","v":"Purchase Water"}]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
["Total (gal)",{"$f":"SUM(B6:B36)","v":0},{"$f":"SUM(C6:C36)","v":0},0,0,0,0,0,{"$f":"SUM(I6:I36)","v":0},0,0,0,{"$f":"SUM(M6:M36)","v":0}]
["Avg.",{"$f":"IF(B37>0,B37/1000000/DAY(DATE(Totals!$B$3,1+1,1)-1),0)","v":0},{"$f":"IF(C37>0,C37/1000000/DAY(DATE(Totals!$B$3,2+1,1)-1),0)","v":0},{"$f":"IF(D37>0,D37/1000000/DAY(DATE(Totals!$B$3,3+1,1)-1),0)","v":0},{"$f":"IF(E37>0,E37/1000000/DAY(DATE(Totals!$B$3,4+1,1)-1),0)","v":0},{"$f":"IF(F37>0,F37/1000000/DAY(DATE(Totals!$B$3,5+1,1)-1),0)","v":0},{"$f":"IF(G37>0,G37/1000000/DAY(DATE(Totals!$B$3,6+1,1)-1),0)","v":0},{"$f":"IF(H37>0,H37/1000000/DAY(DATE(Totals!$B$3,7+1,1)-1),0)","v":0},{"$f":"IF(I37>0,I37/1000000/DAY(DATE(Totals!$B$3,8+1,1)-1),0)","v":0},{"$f":"IF(J37>0,J37/1000000/DAY(DATE(Totals!$B$3,9+1,1)-1),0)","v":0},{"$f":"IF(K37>0,K37/1000000/DAY(DATE(Totals!$B$3,10+1,1)-1),0)","v":0},{"$f":"IF(L37>0,L37/1000000/DAY(DATE(Totals!$B$3,11+1,1)-1),0)","v":0},{"$f":"IF(M37>0,M37/1000000/DAY(DATE(Totals!$B$3,12+1,1)-1),0)","v":0}]
["Max.",{"$f":"MAX(B6:B36)/1000000","v":0},{"$f":"MAX(C6:C36)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]
["Min.",{"$f":"MIN(B6:B36)/1000000","v":0},{"$f":"MIN(C6:C36)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"April","index":3,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["WATER USAGE REPORT"]
["Record source water withdrawals and purchases in the table below in \"Gallons\"."]
[]
[]
["Date",{"$f":"January!B5","v":"Groundwater"},{"$f":"January!C5","v":"Groundwater"},{"$f":"January!D5","v":"Groundwater"},{"$f":"January!E5","v":"Groundwater"},{"$f":"January!F5","v":"Groundwater"},{"$f":"January!G5","v":"Groundwater"},{"$f":"January!H5","v":"Groundwater"},{"$f":"January!I5","v":"Surface Water"},{"$f":"January!J5","v":"Surface Water"},{"$f":"January!K5","v":"Purchase Water"},{"$f":"January!L5","v":"Purchase Water"},{"$f":"January!M5","v":"Purchase Water"}]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
["Total (gal)",{"$f":"SUM(B6:B36)","v":0},{"$f":"SUM(C6:C36)","v":0},0,0,0,0,0,{"$f":"SUM(I6:I36)","v":0},0,0,0,{"$f":"SUM(M6:M36)","v":0}]
["Avg.",{"$f":"IF(B37>0,B37/1000000/DAY(DATE(Totals!$B$3,1+1,1)-1),0)","v":0},{"$f":"IF(C37>0,C37/1000000/DAY(DATE(Totals!$B$3,2+1,1)-1),0)","v":0},{"$f":"IF(D37>0,D37/1000000/DAY(DATE(Totals!$B$3,3+1,1)-1),0)","v":0},{"$f":"IF(E37>0,E37/1000000/DAY(DATE(Totals!$B$3,4+1,1)-1),0)","v":0},{"$f":"IF(F37>0,F37/1000000/DAY(DATE(Totals!$B$3,5+1,1)-1),0)","v":0},{"$f":"IF(G37>0,G37/1000000/DAY(DATE(Totals!$B$3,6+1,1)-1),0)","v":0},{"$f":"IF(H37>0,H37/1000000/DAY(DATE(Totals!$B$3,7+1,1)-1),0)","v":0},{"$f":"IF(I37>0,I37/1000000/DAY(DATE(Totals!$B$3,8+1,1)-1),0)","v":0},{"$f":"IF(J37>0,J37/1000000/DAY(DATE(Totals!$B$3,9+1,1)-1),0)","v":0},{"$f":"IF(K37>0,K37/1000000/DAY(DATE(Totals!$B$3,10+1,1)-1),0)","v":0},{"$f":"IF(L37>0,L37/1000000/DAY(DATE(Totals!$B$3,11+1,1)-1),0)","v":0},{"$f":"IF(M37>0,M37/1000000/DAY(DATE(Totals!$B$3,12+1,1)-1),0)","v":0}]
["Max.",{"$f":"MAX(B6:B36)/1000000","v":0},{"$f":"MAX(C6:C36)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]
["Min.",{"$f":"MIN(B6:B36)/1000000","v":0},{"$f":"MIN(C6:C36)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"May","index":4,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["WATER USAGE REPORT"]
["Record source water withdrawals and purchases in the table below in \"Gallons\"."]
[]
[]
["Date",{"$f":"January!B5","v":"Groundwater"},{"$f":"January!C5","v":"Groundwater"},{"$f":"January!D5","v":"Groundwater"},{"$f":"January!E5","v":"Groundwater"},{"$f":"January!F5","v":"Groundwater"},{"$f":"January!G5","v":"Groundwater"},{"$f":"January!H5","v":"Groundwater"},{"$f":"January!I5","v":"Surface Water"},{"$f":"January!J5","v":"Surface Water"},{"$f":"January!K5","v":"Purchase Water"},{"$f":"January!L5","v":"Purchase Water"},{"$f":"January!M5","v":"Purchase Water"}]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
["Total (gal)",{"$f":"SUM(B6:B36)","v":0},{"$f":"SUM(C6:C36)","v":0},0,0,0,0,0,{"$f":"SUM(I6:I36)","v":0},0,0,0,{"$f":"SUM(M6:M36)","v":0}]
["Avg.",{"$f":"IF(B37>0,B37/1000000/DAY(DATE(Totals!$B$3,1+1,1)-1),0)","v":0},{"$f":"IF(C37>0,C37/1000000/DAY(DATE(Totals!$B$3,2+1,1)-1),0)","v":0},{"$f":"IF(D37>0,D37/1000000/DAY(DATE(Totals!$B$3,3+1,1)-1),0)","v":0},{"$f":"IF(E37>0,E37/1000000/DAY(DATE(Totals!$B$3,4+1,1)-1),0)","v":0},{"$f":"IF(F37>0,F37/1000000/DAY(DATE(Totals!$B$3,5+1,1)-1),0)","v":0},{"$f":"IF(G37>0,G37/1000000/DAY(DATE(Totals!$B$3,6+1,1)-1),0)","v":0},{"$f":"IF(H37>0,H37/1000000/DAY(DATE(Totals!$B$3,7+1,1)-1),0)","v":0},{"$f":"IF(I37>0,I37/1000000/DAY(DATE(Totals!$B$3,8+1,1)-1),0)","v":0},{"$f":"IF(J37>0,J37/1000000/DAY(DATE(Totals!$B$3,9+1,1)-1),0)","v":0},{"$f":"IF(K37>0,K37/1000000/DAY(DATE(Totals!$B$3,10+1,1)-1),0)","v":0},{"$f":"IF(L37>0,L37/1000000/DAY(DATE(Totals!$B$3,11+1,1)-1),0)","v":0},{"$f":"IF(M37>0,M37/1000000/DAY(DATE(Totals!$B$3,12+1,1)-1),0)","v":0}]
["Max.",{"$f":"MAX(B6:B36)/1000000","v":0},{"$f":"MAX(C6:C36)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]
["Min.",{"$f":"MIN(B6:B36)/1000000","v":0},{"$f":"MIN(C6:C36)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"June","index":5,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["WATER USAGE REPORT"]
["Record source water withdrawals and purchases in the table below in \"Gallons\"."]
[]
[]
["Date",{"$f":"January!B5","v":"Groundwater"},{"$f":"January!C5","v":"Groundwater"},{"$f":"January!D5","v":"Groundwater"},{"$f":"January!E5","v":"Groundwater"},{"$f":"January!F5","v":"Groundwater"},{"$f":"January!G5","v":"Groundwater"},{"$f":"January!H5","v":"Groundwater"},{"$f":"January!I5","v":"Surface Water"},{"$f":"January!J5","v":"Surface Water"},{"$f":"January!K5","v":"Purchase Water"},{"$f":"January!L5","v":"Purchase Water"},{"$f":"January!M5","v":"Purchase Water"}]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
["Total (gal)",{"$f":"SUM(B6:B36)","v":0},{"$f":"SUM(C6:C36)","v":0},0,0,0,0,0,{"$f":"SUM(I6:I36)","v":0},0,0,0,{"$f":"SUM(M6:M36)","v":0}]
["Avg.",{"$f":"IF(B37>0,B37/1000000/DAY(DATE(Totals!$B$3,1+1,1)-1),0)","v":0},{"$f":"IF(C37>0,C37/1000000/DAY(DATE(Totals!$B$3,2+1,1)-1),0)","v":0},{"$f":"IF(D37>0,D37/1000000/DAY(DATE(Totals!$B$3,3+1,1)-1),0)","v":0},{"$f":"IF(E37>0,E37/1000000/DAY(DATE(Totals!$B$3,4+1,1)-1),0)","v":0},{"$f":"IF(F37>0,F37/1000000/DAY(DATE(Totals!$B$3,5+1,1)-1),0)","v":0},{"$f":"IF(G37>0,G37/1000000/DAY(DATE(Totals!$B$3,6+1,1)-1),0)","v":0},{"$f":"IF(H37>0,H37/1000000/DAY(DATE(Totals!$B$3,7+1,1)-1),0)","v":0},{"$f":"IF(I37>0,I37/1000000/DAY(DATE(Totals!$B$3,8+1,1)-1),0)","v":0},{"$f":"IF(J37>0,J37/1000000/DAY(DATE(Totals!$B$3,9+1,1)-1),0)","v":0},{"$f":"IF(K37>0,K37/1000000/DAY(DATE(Totals!$B$3,10+1,1)-1),0)","v":0},{"$f":"IF(L37>0,L37/1000000/DAY(DATE(Totals!$B$3,11+1,1)-1),0)","v":0},{"$f":"IF(M37>0,M37/1000000/DAY(DATE(Totals!$B$3,12+1,1)-1),0)","v":0}]
["Max.",{"$f":"MAX(B6:B36)/1000000","v":0},{"$f":"MAX(C6:C36)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]
["Min.",{"$f":"MIN(B6:B36)/1000000","v":0},{"$f":"MIN(C6:C36)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"July","index":6,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["WATER USAGE REPORT"]
["Record source water withdrawals and purchases in the table below in \"Gallons\"."]
[]
[]
["Date",{"$f":"January!B5","v":"Groundwater"},{"$f":"January!C5","v":"Groundwater"},{"$f":"January!D5","v":"Groundwater"},{"$f":"January!E5","v":"Groundwater"},{"$f":"January!F5","v":"Groundwater"},{"$f":"January!G5","v":"Groundwater"},{"$f":"January!H5","v":"Groundwater"},{"$f":"January!I5","v":"Surface Water"},{"$f":"January!J5","v":"Surface Water"},{"$f":"January!K5","v":"Purchase Water"},{"$f":"January!L5","v":"Purchase Water"},{"$f":"January!M5","v":"Purchase Water"}]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
["Total (gal)",{"$f":"SUM(B6:B36)","v":0},{"$f":"SUM(C6:C36)","v":0},0,0,0,0,0,{"$f":"SUM(I6:I36)","v":0},0,0,0,{"$f":"SUM(M6:M36)","v":0}]
["Avg.",{"$f":"IF(B37>0,B37/1000000/DAY(DATE(Totals!$B$3,1+1,1)-1),0)","v":0},{"$f":"IF(C37>0,C37/1000000/DAY(DATE(Totals!$B$3,2+1,1)-1),0)","v":0},{"$f":"IF(D37>0,D37/1000000/DAY(DATE(Totals!$B$3,3+1,1)-1),0)","v":0},{"$f":"IF(E37>0,E37/1000000/DAY(DATE(Totals!$B$3,4+1,1)-1),0)","v":0},{"$f":"IF(F37>0,F37/1000000/DAY(DATE(Totals!$B$3,5+1,1)-1),0)","v":0},{"$f":"IF(G37>0,G37/1000000/DAY(DATE(Totals!$B$3,6+1,1)-1),0)","v":0},{"$f":"IF(H37>0,H37/1000000/DAY(DATE(Totals!$B$3,7+1,1)-1),0)","v":0},{"$f":"IF(I37>0,I37/1000000/DAY(DATE(Totals!$B$3,8+1,1)-1),0)","v":0},{"$f":"IF(J37>0,J37/1000000/DAY(DATE(Totals!$B$3,9+1,1)-1),0)","v":0},{"$f":"IF(K37>0,K37/1000000/DAY(DATE(Totals!$B$3,10+1,1)-1),0)","v":0},{"$f":"IF(L37>0,L37/1000000/DAY(DATE(Totals!$B$3,11+1,1)-1),0)","v":0},{"$f":"IF(M37>0,M37/1000000/DAY(DATE(Totals!$B$3,12+1,1)-1),0)","v":0}]
["Max.",{"$f":"MAX(B6:B36)/1000000","v":0},{"$f":"MAX(C6:C36)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]
["Min.",{"$f":"MIN(B6:B36)/1000000","v":0},{"$f":"MIN(C6:C36)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"August","index":7,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["WATER USAGE REPORT"]
["Record source water withdrawals and purchases in the table below in \"Gallons\"."]
[]
[]
["Date",{"$f":"January!B5","v":"Groundwater"},{"$f":"January!C5","v":"Groundwater"},{"$f":"January!D5","v":"Groundwater"},{"$f":"January!E5","v":"Groundwater"},{"$f":"January!F5","v":"Groundwater"},{"$f":"January!G5","v":"Groundwater"},{"$f":"January!H5","v":"Groundwater"},{"$f":"January!I5","v":"Surface Water"},{"$f":"January!J5","v":"Surface Water"},{"$f":"January!K5","v":"Purchase Water"},{"$f":"January!L5","v":"Purchase Water"},{"$f":"January!M5","v":"Purchase Water"}]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
["Total (gal)",{"$f":"SUM(B6:B36)","v":0},{"$f":"SUM(C6:C36)","v":0},0,0,0,0,0,{"$f":"SUM(I6:I36)","v":0},0,0,0,{"$f":"SUM(M6:M36)","v":0}]
["Avg.",{"$f":"IF(B37>0,B37/1000000/DAY(DATE(Totals!$B$3,1+1,1)-1),0)","v":0},{"$f":"IF(C37>0,C37/1000000/DAY(DATE(Totals!$B$3,2+1,1)-1),0)","v":0},{"$f":"IF(D37>0,D37/1000000/DAY(DATE(Totals!$B$3,3+1,1)-1),0)","v":0},{"$f":"IF(E37>0,E37/1000000/DAY(DATE(Totals!$B$3,4+1,1)-1),0)","v":0},{"$f":"IF(F37>0,F37/1000000/DAY(DATE(Totals!$B$3,5+1,1)-1),0)","v":0},{"$f":"IF(G37>0,G37/1000000/DAY(DATE(Totals!$B$3,6+1,1)-1),0)","v":0},{"$f":"IF(H37>0,H37/1000000/DAY(DATE(Totals!$B$3,7+1,1)-1),0)","v":0},{"$f":"IF(I37>0,I37/1000000/DAY(DATE(Totals!$B$3,8+1,1)-1),0)","v":0},{"$f":"IF(J37>0,J37/1000000/DAY(DATE(Totals!$B$3,9+1,1)-1),0)","v":0},{"$f":"IF(K37>0,K37/1000000/DAY(DATE(Totals!$B$3,10+1,1)-1),0)","v":0},{"$f":"IF(L37>0,L37/1000000/DAY(DATE(Totals!$B$3,11+1,1)-1),0)","v":0},{"$f":"IF(M37>0,M37/1000000/DAY(DATE(Totals!$B$3,12+1,1)-1),0)","v":0}]
["Max.",{"$f":"MAX(B6:B36)/1000000","v":0},{"$f":"MAX(C6:C36)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]
["Min.",{"$f":"MIN(B6:B36)/1000000","v":0},{"$f":"MIN(C6:C36)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"September","index":8,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["WATER USAGE REPORT"]
["Record source water withdrawals and purchases in the table below in \"Gallons\"."]
[]
[]
["Date",{"$f":"January!B5","v":"Groundwater"},{"$f":"January!C5","v":"Groundwater"},{"$f":"January!D5","v":"Groundwater"},{"$f":"January!E5","v":"Groundwater"},{"$f":"January!F5","v":"Groundwater"},{"$f":"January!G5","v":"Groundwater"},{"$f":"January!H5","v":"Groundwater"},{"$f":"January!I5","v":"Surface Water"},{"$f":"January!J5","v":"Surface Water"},{"$f":"January!K5","v":"Purchase Water"},{"$f":"January!L5","v":"Purchase Water"},{"$f":"January!M5","v":"Purchase Water"}]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
["Total (gal)",{"$f":"SUM(B6:B36)","v":0},{"$f":"SUM(C6:C36)","v":0},0,0,0,0,0,{"$f":"SUM(I6:I36)","v":0},0,0,0,{"$f":"SUM(M6:M36)","v":0}]
["Avg.",{"$f":"IF(B37>0,B37/1000000/DAY(DATE(Totals!$B$3,1+1,1)-1),0)","v":0},{"$f":"IF(C37>0,C37/1000000/DAY(DATE(Totals!$B$3,2+1,1)-1),0)","v":0},{"$f":"IF(D37>0,D37/1000000/DAY(DATE(Totals!$B$3,3+1,1)-1),0)","v":0},{"$f":"IF(E37>0,E37/1000000/DAY(DATE(Totals!$B$3,4+1,1)-1),0)","v":0},{"$f":"IF(F37>0,F37/1000000/DAY(DATE(Totals!$B$3,5+1,1)-1),0)","v":0},{"$f":"IF(G37>0,G37/1000000/DAY(DATE(Totals!$B$3,6+1,1)-1),0)","v":0},{"$f":"IF(H37>0,H37/1000000/DAY(DATE(Totals!$B$3,7+1,1)-1),0)","v":0},{"$f":"IF(I37>0,I37/1000000/DAY(DATE(Totals!$B$3,8+1,1)-1),0)","v":0},{"$f":"IF(J37>0,J37/1000000/DAY(DATE(Totals!$B$3,9+1,1)-1),0)","v":0},{"$f":"IF(K37>0,K37/1000000/DAY(DATE(Totals!$B$3,10+1,1)-1),0)","v":0},{"$f":"IF(L37>0,L37/1000000/DAY(DATE(Totals!$B$3,11+1,1)-1),0)","v":0},{"$f":"IF(M37>0,M37/1000000/DAY(DATE(Totals!$B$3,12+1,1)-1),0)","v":0}]
["Max.",{"$f":"MAX(B6:B36)/1000000","v":0},{"$f":"MAX(C6:C36)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]
["Min.",{"$f":"MIN(B6:B36)/1000000","v":0},{"$f":"MIN(C6:C36)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"October","index":9,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["WATER USAGE REPORT"]
["Record source water withdrawals and purchases in the table below in \"Gallons\"."]
[]
[]
["Date",{"$f":"January!B5","v":"Groundwater"},{"$f":"January!C5","v":"Groundwater"},{"$f":"January!D5","v":"Groundwater"},{"$f":"January!E5","v":"Groundwater"},{"$f":"January!F5","v":"Groundwater"},{"$f":"January!G5","v":"Groundwater"},{"$f":"January!H5","v":"Groundwater"},{"$f":"January!I5","v":"Surface Water"},{"$f":"January!J5","v":"Surface Water"},{"$f":"January!K5","v":"Purchase Water"},{"$f":"January!L5","v":"Purchase Water"},{"$f":"January!M5","v":"Purchase Water"}]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
["Total (gal)",{"$f":"SUM(B6:B36)","v":0},{"$f":"SUM(C6:C36)","v":0},0,0,0,0,0,{"$f":"SUM(I6:I36)","v":0},0,0,0,{"$f":"SUM(M6:M36)","v":0}]
["Avg.",{"$f":"IF(B37>0,B37/1000000/DAY(DATE(Totals!$B$3,1+1,1)-1),0)","v":0},{"$f":"IF(C37>0,C37/1000000/DAY(DATE(Totals!$B$3,2+1,1)-1),0)","v":0},{"$f":"IF(D37>0,D37/1000000/DAY(DATE(Totals!$B$3,3+1,1)-1),0)","v":0},{"$f":"IF(E37>0,E37/1000000/DAY(DATE(Totals!$B$3,4+1,1)-1),0)","v":0},{"$f":"IF(F37>0,F37/1000000/DAY(DATE(Totals!$B$3,5+1,1)-1),0)","v":0},{"$f":"IF(G37>0,G37/1000000/DAY(DATE(Totals!$B$3,6+1,1)-1),0)","v":0},{"$f":"IF(H37>0,H37/1000000/DAY(DATE(Totals!$B$3,7+1,1)-1),0)","v":0},{"$f":"IF(I37>0,I37/1000000/DAY(DATE(Totals!$B$3,8+1,1)-1),0)","v":0},{"$f":"IF(J37>0,J37/1000000/DAY(DATE(Totals!$B$3,9+1,1)-1),0)","v":0},{"$f":"IF(K37>0,K37/1000000/DAY(DATE(Totals!$B$3,10+1,1)-1),0)","v":0},{"$f":"IF(L37>0,L37/1000000/DAY(DATE(Totals!$B$3,11+1,1)-1),0)","v":0},{"$f":"IF(M37>0,M37/1000000/DAY(DATE(Totals!$B$3,12+1,1)-1),0)","v":0}]
["Max.",{"$f":"MAX(B6:B36)/1000000","v":0},{"$f":"MAX(C6:C36)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]
["Min.",{"$f":"MIN(B6:B36)/1000000","v":0},{"$f":"MIN(C6:C36)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"November","index":10,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["WATER USAGE REPORT"]
["Record source water withdrawals and purchases in the table below in \"Gallons\"."]
[]
[]
["Date",{"$f":"January!B5","v":"Groundwater"},{"$f":"January!C5","v":"Groundwater"},{"$f":"January!D5","v":"Groundwater"},{"$f":"January!E5","v":"Groundwater"},{"$f":"January!F5","v":"Groundwater"},{"$f":"January!G5","v":"Groundwater"},{"$f":"January!H5","v":"Groundwater"},{"$f":"January!I5","v":"Surface Water"},{"$f":"January!J5","v":"Surface Water"},{"$f":"January!K5","v":"Purchase Water"},{"$f":"January!L5","v":"Purchase Water"},{"$f":"January!M5","v":"Purchase Water"}]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
["Total (gal)",{"$f":"SUM(B6:B36)","v":0},{"$f":"SUM(C6:C36)","v":0},0,0,0,0,0,{"$f":"SUM(I6:I36)","v":0},0,0,0,{"$f":"SUM(M6:M36)","v":0}]
["Avg.",{"$f":"IF(B37>0,B37/1000000/DAY(DATE(Totals!$B$3,1+1,1)-1),0)","v":0},{"$f":"IF(C37>0,C37/1000000/DAY(DATE(Totals!$B$3,2+1,1)-1),0)","v":0},{"$f":"IF(D37>0,D37/1000000/DAY(DATE(Totals!$B$3,3+1,1)-1),0)","v":0},{"$f":"IF(E37>0,E37/1000000/DAY(DATE(Totals!$B$3,4+1,1)-1),0)","v":0},{"$f":"IF(F37>0,F37/1000000/DAY(DATE(Totals!$B$3,5+1,1)-1),0)","v":0},{"$f":"IF(G37>0,G37/1000000/DAY(DATE(Totals!$B$3,6+1,1)-1),0)","v":0},{"$f":"IF(H37>0,H37/1000000/DAY(DATE(Totals!$B$3,7+1,1)-1),0)","v":0},{"$f":"IF(I37>0,I37/1000000/DAY(DATE(Totals!$B$3,8+1,1)-1),0)","v":0},{"$f":"IF(J37>0,J37/1000000/DAY(DATE(Totals!$B$3,9+1,1)-1),0)","v":0},{"$f":"IF(K37>0,K37/1000000/DAY(DATE(Totals!$B$3,10+1,1)-1),0)","v":0},{"$f":"IF(L37>0,L37/1000000/DAY(DATE(Totals!$B$3,11+1,1)-1),0)","v":0},{"$f":"IF(M37>0,M37/1000000/DAY(DATE(Totals!$B$3,12+1,1)-1),0)","v":0}]
["Max.",{"$f":"MAX(B6:B36)/1000000","v":0},{"$f":"MAX(C6:C36)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]
["Min.",{"$f":"MIN(B6:B36)/1000000","v":0},{"$f":"MIN(C6:C36)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"December","index":11,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["WATER USAGE REPORT"]
["Record source water withdrawals and purchases in the table below in \"Gallons\"."]
[]
[]
["Date",{"$f":"January!B5","v":"Groundwater"},{"$f":"January!C5","v":"Groundwater"},{"$f":"January!D5","v":"Groundwater"},{"$f":"January!E5","v":"Groundwater"},{"$f":"January!F5","v":"Groundwater"},{"$f":"January!G5","v":"Groundwater"},{"$f":"January!H5","v":"Groundwater"},{"$f":"January!I5","v":"Surface Water"},{"$f":"January!J5","v":"Surface Water"},{"$f":"January!K5","v":"Purchase Water"},{"$f":"January!L5","v":"Purchase Water"},{"$f":"January!M5","v":"Purchase Water"}]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
["Total (gal)",{"$f":"SUM(B6:B36)","v":0},{"$f":"SUM(C6:C36)","v":0},0,0,0,0,0,{"$f":"SUM(I6:I36)","v":0},0,0,0,{"$f":"SUM(M6:M36)","v":0}]
["Avg.",{"$f":"IF(B37>0,B37/1000000/DAY(DATE(Totals!$B$3,1+1,1)-1),0)","v":0},{"$f":"IF(C37>0,C37/1000000/DAY(DATE(Totals!$B$3,2+1,1)-1),0)","v":0},{"$f":"IF(D37>0,D37/1000000/DAY(DATE(Totals!$B$3,3+1,1)-1),0)","v":0},{"$f":"IF(E37>0,E37/1000000/DAY(DATE(Totals!$B$3,4+1,1)-1),0)","v":0},{"$f":"IF(F37>0,F37/1000000/DAY(DATE(Totals!$B$3,5+1,1)-1),0)","v":0},{"$f":"IF(G37>0,G37/1000000/DAY(DATE(Totals!$B$3,6+1,1)-1),0)","v":0},{"$f":"IF(H37>0,H37/1000000/DAY(DATE(Totals!$B$3,7+1,1)-1),0)","v":0},{"$f":"IF(I37>0,I37/1000000/DAY(DATE(Totals!$B$3,8+1,1)-1),0)","v":0},{"$f":"IF(J37>0,J37/1000000/DAY(DATE(Totals!$B$3,9+1,1)-1),0)","v":0},{"$f":"IF(K37>0,K37/1000000/DAY(DATE(Totals!$B$3,10+1,1)-1),0)","v":0},{"$f":"IF(L37>0,L37/1000000/DAY(DATE(Totals!$B$3,11+1,1)-1),0)","v":0},{"$f":"IF(M37>0,M37/1000000/DAY(DATE(Totals!$B$3,12+1,1)-1),0)","v":0}]
["Max.",{"$f":"MAX(B6:B36)/1000000","v":0},{"$f":"MAX(C6:C36)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]
["Min.",{"$f":"MIN(B6:B36)/1000000","v":0},{"$f":"MIN(C6:C36)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"Totals","index":12,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["WATER USAGE REPORT"]
[]
["Reporting Year",2023]
[]
[]
["All Sources","January","February","March","April","May","June","July","August","September","October","November","December","Total (Gal)"]
[{"$f":"January!B5","v":"Groundwater"},{"$f":"January!$B$37","v":0},{"$f":"February!$B$37","v":0},{"$f":"March!$B$37","v":0},{"$f":"April!$B$37","v":0},{"$f":"May!$B$37","v":0},{"$f":"June!$B$37","v":0},{"$f":"July!$B$37","v":0},{"$f":"August!$B$37","v":0},{"$f":"September!$B$37","v":0},{"$f":"October!$B$37","v":0},{"$f":"November!$B$37","v":0},{"$f":"December!$B$37","v":0},{"$f":"SUM(B7:M7)","v":0}]
[{"$f":"January!C5","v":"Groundwater"},{"$f":"January!$C$37","v":0},{"$f":"February!$C$37","v":0},{"$f":"March!$C$37","v":0},{"$f":"April!$C$37","v":0},{"$f":"May!$C$37","v":0},{"$f":"June!$C$37","v":0},{"$f":"July!$C$37","v":0},{"$f":"August!$C$37","v":0},{"$f":"September!$C$37","v":0},{"$f":"October!$C$37","v":0},{"$f":"November!$C$37","v":0},{"$f":"December!$C$37","v":0},{"$f":"SUM(B8:M8)","v":0}]
[{"$f":"January!D5","v":"Groundwater"},{"$f":"January!$D$37","v":0},{"$f":"February!$D$37","v":0},{"$f":"March!$D$37","v":0},{"$f":"April!$D$37","v":0},{"$f":"May!$D$37","v":0},{"$f":"June!$D$37","v":0},{"$f":"July!$D$37","v":0},{"$f":"August!$D$37","v":0},{"$f":"September!$D$37","v":0},{"$f":"October!$D$37","v":0},{"$f":"November!$D$37","v":0},{"$f":"December!$D$37","v":0},0]
[{"$f":"January!E5","v":"Groundwater"},{"$f":"January!$E$37","v":0},{"$f":"February!$E$37","v":0},{"$f":"March!$E$37","v":0},{"$f":"April!$E$37","v":0},{"$f":"May!$E$37","v":0},{"$f":"June!$E$37","v":0},{"$f":"July!$E$37","v":0},{"$f":"August!$E$37","v":0},{"$f":"September!$E$37","v":0},{"$f":"October!$E$37","v":0},{"$f":"November!$E$37","v":0},{"$f":"December!$E$37","v":0},0]
[{"$f":"January!F5","v":"Groundwater"},{"$f":"January!$F$37","v":0},{"$f":"February!$F$37","v":0},{"$f":"March!$F$37","v":0},{"$f":"April!$F$37","v":0},{"$f":"May!$F$37","v":0},{"$f":"June!$F$37","v":0},{"$f":"July!$F$37","v":0},{"$f":"August!$F$37","v":0},{"$f":"September!$F$37","v":0},{"$f":"October!$F$37","v":0},{"$f":"November!$F$37","v":0},{"$f":"December!$F$37","v":0},0]
[{"$f":"January!G5","v":"Groundwater"},{"$f":"January!$G$37","v":0},{"$f":"February!$G$37","v":0},{"$f":"March!$G$37","v":0},{"$f":"April!$G$37","v":0},{"$f":"May!$G$37","v":0},{"$f":"June!$G$37","v":0},{"$f":"July!$G$37","v":0},{"$f":"August!$G$37","v":0},{"$f":"September!$G$37","v":0},{"$f":"October!$G$37","v":0},{"$f":"November!$G$37","v":0},{"$f":"December!$G$37","v":0},0]
[{"$f":"January!H5","v":"Groundwater"},{"$f":"January!$H$37","v":0},{"$f":"February!$H$37","v":0},{"$f":"March!$H$37","v":0},{"$f":"April!$H$37","v":0},{"$f":"May!$H$37","v":0},{"$f":"June!$H$37","v":0},{"$f":"July!$H$37","v":0},{"$f":"August!$H$37","v":0},{"$f":"September!$H$37","v":0},{"$f":"October!$H$37","v":0},{"$f":"November!$H$37","v":0},{"$f":"December!$H$37","v":0},0]
[{"$f":"January!I5","v":"Surface Water"},{"$f":"January!$I$37","v":0},{"$f":"February!$I$37","v":0},{"$f":"March!$I$37","v":0},{"$f":"April!$I$37","v":0},{"$f":"May!$I$37","v":0},{"$f":"June!$I$37","v":0},{"$f":"July!$I$37","v":0},{"$f":"August!$I$37","v":0},{"$f":"September!$I$37","v":0},{"$f":"October!$I$37","v":0},{"$f":"November!$I$37","v":0},{"$f":"December!$I$37","v":0},0]
[{"$f":"January!J5","v":"Surface Water"},{"$f":"January!$J$37","v":0},{"$f":"February!$J$37","v":0},{"$f":"March!$J$37","v":0},{"$f":"April!$J$37","v":0},{"$f":"May!$J$37","v":0},{"$f":"June!$J$37","v":0},{"$f":"July!$J$37","v":0},{"$f":"August!$J$37","v":0},{"$f":"September!$J$37","v":0},{"$f":"October!$J$37","v":0},{"$f":"November!$J$37","v":0},{"$f":"December!$J$37","v":0},0]
[{"$f":"January!K5","v":"Purchase Water"},{"$f":"January!$K$37","v":0},{"$f":"February!$K$37","v":0},{"$f":"March!$K$37","v":0},{"$f":"April!$K$37","v":0},{"$f":"May!$K$37","v":0},{"$f":"June!$K$37","v":0},{"$f":"July!$K$37","v":0},{"$f":"August!$K$37","v":0},{"$f":"September!$K$37","v":0},{"$f":"October!$K$37","v":0},{"$f":"November!$K$37","v":0},{"$f":"December!$K$37","v":0},0]
[{"$f":"January!L5","v":"Purchase Water"},{"$f":"January!$L$37","v":0},{"$f":"February!$L$37","v":0},{"$f":"March!$L$37","v":0},{"$f":"April!$L$37","v":0},{"$f":"May!$L$37","v":0},{"$f":"June!$L$37","v":0},{"$f":"July!$L$37","v":0},{"$f":"August!$L$37","v":0},{"$f":"September!$L$37","v":0},{"$f":"October!$L$37","v":0},{"$f":"November!$L$37","v":0},{"$f":"December!$L$37","v":0},0]
[{"$f":"January!M5","v":"Purchase Water"},{"$f":"January!$M$37","v":0},{"$f":"February!$M$37","v":0},{"$f":"March!$M$37","v":0},{"$f":"April!$M$37","v":0},{"$f":"May!$M$37","v":0},{"$f":"June!$M$37","v":0},{"$f":"July!$M$37","v":0},{"$f":"August!$M$37","v":0},{"$f":"September!$M$37","v":0},{"$f":"October!$M$37","v":0},{"$f":"November!$M$37","v":0},{"$f":"December!$M$37","v":0},0]
["Total (Gal)",{"$f":"SUM(B7:B18)","v":0},{"$f":"SUM(C7:C18)","v":0},{"$f":"SUM(D7:D18)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(N7:N18)","v":0}]
["Average (MGD)",{"$f":"IF(B19>0,B19/1000000/DAY(DATE(Totals!$B$3,1+1,1)-1),0)","v":0},{"$f":"IF(C19>0,C19/1000000/DAY(DATE(Totals!$B$3,2+1,1)-1),0)","v":0},{"$f":"IF(D19>0,D19/1000000/DAY(DATE(Totals!$B$3,3+1,1)-1),0)","v":0},{"$f":"IF(E19>0,E19/1000000/DAY(DATE(Totals!$B$3,4+1,1)-1),0)","v":0},{"$f":"IF(F19>0,F19/1000000/DAY(DATE(Totals!$B$3,5+1,1)-1),0)","v":0},{"$f":"IF(G19>0,G19/1000000/DAY(DATE(Totals!$B$3,6+1,1)-1),0)","v":0},{"$f":"IF(H19>0,H19/1000000/DAY(DATE(Totals!$B$3,7+1,1)-1),0)","v":0},{"$f":"IF(I19>0,I19/1000000/DAY(DATE(Totals!$B$3,8+1,1)-1),0)","v":0},{"$f":"IF(J19>0,J19/1000000/DAY(DATE(Totals!$B$3,9+1,1)-1),0)","v":0},{"$f":"IF(K19>0,K19/1000000/DAY(DATE(Totals!$B$3,10+1,1)-1),0)","v":0},{"$f":"IF(L19>0,L19/1000000/DAY(DATE(Totals!$B$3,11+1,1)-1),0)","v":0},{"$f":"IF(M19>0,M19/1000000/DAY(DATE(Totals!$B$3,12+1,1)-1),0)","v":0}]
["Max (MGD)",{"$f":"MAX(B7:B18)/1000000","v":0},{"$f":"MAX(C7:C18)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]
["Min (MGD)",{"$f":"MIN(B7:B18)/1000000","v":0},{"$f":"MIN(C7:C18)/1000000","v":0},0,0,0,0,0,0,0,0,0,0]