{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["1 & 2","3 & 4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":2,"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":"1 & 2","index":0,"n_rows":44,"n_cols":40,"rows_kept":44,"cut":false,"hidden":false,"merged":[[38,0,39,0],[20,23,20,27],[21,23,21,27],[17,23,17,27],[18,23,18,27],[19,23,19,27],[28,24,28,25],[24,23,24,26],[25,23,25,24],[25,25,25,26],[26,23,26,24],[26,25,26,26],[32,23,33,25],[27,23,27,24],[27,25,27,26],[32,31,33,31],[34,31,35,31],[36,31,37,31],[34,23,35,25],[36,23,37,25],[32,28,33,30],[34,28,35,30],[36,28,37,30],[32,26,33,26],[34,26,35,26],[36,26,37,26]]}
[]
[null,null,null,{"$f":"IF(OR(B2=\"HOL\",B2=\"SUN\",B2=\"SAT\",B2=\"No Read\",B2=\"\"),\"\",ROUND(C2/E1,1))","v":""},{"$f":"IF(C2=\"\",IF(E1>0,E1+1,1),1)","v":1},null,null,null,{"$f":"IF(OR(G2=\"HOL\",G2=\"SUN\",G2=\"SAT\",G2=\"No Read\",G2=\"\"),\"\",ROUND(H2/J1,1))","v":""},{"$f":"IF(H2=\"\",IF(J1>0,J1+1,1),1)","v":1},null,null,null,{"$f":"IF(OR(L2=\"HOL\",L2=\"SUN\",L2=\"SAT\",L2=\"No Read\",L2=\"\"),\"\",ROUND(M2/O1,1))","v":""},{"$f":"IF(M2=\"\",IF(O1>0,O1+1,1),1)","v":1},null,null,null,{"$f":"IF(OR(Q2=\"HOL\",Q2=\"SUN\",Q2=\"SAT\",Q2=\"No Read\",Q2=\"\"),\"\",ROUND(R2/T1,1))","v":""},{"$f":"IF(R2=\"\",IF(T1>0,T1+1,1),1)","v":1}]
[null,null,{"$f":"IF(OR(B3=\"HOL\",B3=\"SUN\",B3=\"SAT\",B3=\"No Read\",B3=\"\"),\"\",(INDEX(B3:$B$44,MATCH(TRUE,ISNUMBER(B3:$B$44),0))-LOOKUP(99^99,$B$2:B3))*1000)","v":""},{"$f":"IF(OR(B3=\"HOL\",B3=\"SUN\",B3=\"SAT\",B3=\"No Read\",B3=\"\"),\"\",ROUND(C3/E2,1))","v":""},{"$f":"IF(C3=\"\",IF(E2>0,E2+1,1),1)","v":2},null,null,{"$f":"IF(OR(G3=\"HOL\",G3=\"SUN\",G3=\"SAT\",G3=\"No Read\",G3=\"\"),\"\",(INDEX(G3:$G$44,MATCH(TRUE,ISNUMBER(G3:$G$44),0))-LOOKUP(99^99,$G$2:G3))*100)","v":""},{"$f":"IF(OR(G3=\"HOL\",G3=\"SUN\",G3=\"SAT\",G3=\"No Read\",G3=\"\"),\"\",ROUND(H3/J2,1))","v":""},{"$f":"IF(H3=\"\",IF(J2>0,J2+1,1),1)","v":2},null,null,{"$f":"IF(OR(L3=\"HOL\",L3=\"SUN\",L3=\"SAT\",L3=\"No Read\",L3=\"\"),\"\",(INDEX(L3:$L$44,MATCH(TRUE,ISNUMBER(L3:$L$44),0))-LOOKUP(99^99,$L$2:L3))*1000)","v":""},{"$f":"IF(OR(L3=\"HOL\",L3=\"SUN\",L3=\"SAT\",L3=\"No Read\",L3=\"\"),\"\",ROUND(M3/O2,1))","v":""},{"$f":"IF(M3=\"\",IF(O2>0,O2+1,1),1)","v":2},null,null,{"$f":"IF(OR(Q3=\"HOL\",Q3=\"SUN\",Q3=\"SAT\",Q3=\"No Read\",Q3=\"\"),\"\",(INDEX(Q3:$Q$44,MATCH(TRUE,ISNUMBER(Q3:$Q$44),0))-LOOKUP(99^99,$Q$2:Q3))*1000)","v":""},{"$f":"IF(OR(Q3=\"HOL\",Q3=\"SUN\",Q3=\"SAT\",Q3=\"No Read\",Q3=\"\"),\"\",ROUND(R3/T2,1))","v":""},{"$f":"IF(R3=\"\",IF(T2>0,T2+1,1),1)","v":2}]
[null,null,{"$f":"IF(OR(B4=\"HOL\",B4=\"SUN\",B4=\"SAT\",B4=\"No Read\",B4=\"\"),\"\",(INDEX(B4:$B$44,MATCH(TRUE,ISNUMBER(B4:$B$44),0))-LOOKUP(99^99,$B$2:B4))*1000)","v":""},{"$f":"IF(OR(B4=\"HOL\",B4=\"SUN\",B4=\"SAT\",B4=\"No Read\",B4=\"\"),\"\",ROUND(C4/E3,1))","v":""},{"$f":"IF(C4=\"\",IF(E3>0,E3+1,1),1)","v":3},null,null,{"$f":"IF(OR(G4=\"HOL\",G4=\"SUN\",G4=\"SAT\",G4=\"No Read\",G4=\"\"),\"\",(INDEX(G4:$G$44,MATCH(TRUE,ISNUMBER(G4:$G$44),0))-LOOKUP(99^99,$G$2:G4))*100)","v":""},{"$f":"IF(OR(G4=\"HOL\",G4=\"SUN\",G4=\"SAT\",G4=\"No Read\",G4=\"\"),\"\",ROUND(H4/J3,1))","v":""},{"$f":"IF(H4=\"\",IF(J3>0,J3+1,1),1)","v":3},null,null,{"$f":"IF(OR(L4=\"HOL\",L4=\"SUN\",L4=\"SAT\",L4=\"No Read\",L4=\"\"),\"\",(INDEX(L4:$L$44,MATCH(TRUE,ISNUMBER(L4:$L$44),0))-LOOKUP(99^99,$L$2:L4))*1000)","v":""},{"$f":"IF(OR(L4=\"HOL\",L4=\"SUN\",L4=\"SAT\",L4=\"No Read\",L4=\"\"),\"\",ROUND(M4/O3,1))","v":""},{"$f":"IF(M4=\"\",IF(O3>0,O3+1,1),1)","v":3},null,null,{"$f":"IF(OR(Q4=\"HOL\",Q4=\"SUN\",Q4=\"SAT\",Q4=\"No Read\",Q4=\"\"),\"\",(INDEX(Q4:$Q$44,MATCH(TRUE,ISNUMBER(Q4:$Q$44),0))-LOOKUP(99^99,$Q$2:Q4))*1000)","v":""},{"$f":"IF(OR(Q4=\"HOL\",Q4=\"SUN\",Q4=\"SAT\",Q4=\"No Read\",Q4=\"\"),\"\",ROUND(R4/T3,1))","v":""},{"$f":"IF(R4=\"\",IF(T3>0,T3+1,1),1)","v":3}]
[null,184017,{"$f":"IF(OR(B5=\"HOL\",B5=\"SUN\",B5=\"SAT\",B5=\"No Read\",B5=\"\"),\"\",(INDEX(B5:$B$44,MATCH(TRUE,ISNUMBER(B5:$B$44),0))-LOOKUP(99^99,$B$2:B5))*1000)","v":0},{"$f":"IF(OR(B5=\"HOL\",B5=\"SUN\",B5=\"SAT\",B5=\"No Read\",B5=\"\"),\"\",ROUND(C5/E4,1))","v":0},{"$f":"IF(C5=\"\",IF(E4>0,E4+1,1),1)","v":1},null,2642246,{"$f":"IF(OR(G5=\"HOL\",G5=\"SUN\",G5=\"SAT\",G5=\"No Read\",G5=\"\"),\"\",(INDEX(G5:$G$44,MATCH(TRUE,ISNUMBER(G5:$G$44),0))-LOOKUP(99^99,$G$2:G5))*100)","v":0},{"$f":"IF(OR(G5=\"HOL\",G5=\"SUN\",G5=\"SAT\",G5=\"No Read\",G5=\"\"),\"\",ROUND(H5/J4,1))","v":0},{"$f":"IF(H5=\"\",IF(J4>0,J4+1,1),1)","v":1},null,281186,{"$f":"IF(OR(L5=\"HOL\",L5=\"SUN\",L5=\"SAT\",L5=\"No Read\",L5=\"\"),\"\",(INDEX(L5:$L$44,MATCH(TRUE,ISNUMBER(L5:$L$44),0))-LOOKUP(99^99,$L$2:L5))*1000)","v":0},{"$f":"IF(OR(L5=\"HOL\",L5=\"SUN\",L5=\"SAT\",L5=\"No Read\",L5=\"\"),\"\",ROUND(M5/O4,1))","v":0},{"$f":"IF(M5=\"\",IF(O4>0,O4+1,1),1)","v":1},null,1919605,{"$f":"IF(OR(Q5=\"HOL\",Q5=\"SUN\",Q5=\"SAT\",Q5=\"No Read\",Q5=\"\"),\"\",(INDEX(Q5:$Q$44,MATCH(TRUE,ISNUMBER(Q5:$Q$44),0))-LOOKUP(99^99,$Q$2:Q5))*1000)","v":0},{"$f":"IF(OR(Q5=\"HOL\",Q5=\"SUN\",Q5=\"SAT\",Q5=\"No Read\",Q5=\"\"),\"\",ROUND(R5/T4,1))","v":0},{"$f":"IF(R5=\"\",IF(T4>0,T4+1,1),1)","v":1}]
[null,null,null,null,null,null,null,null,null,null,"2023-08-18"]
["DATE","Well #1",null,null,null,"GAL USED","Booster #1",null,null,null,"GAL USED","Well #2",null,null,null,"GAL USED","Booster #2",null,null,null,"GAL USED",null,null,null,null,null,null,null,null,null,null,null,null,null,"DATE","BOOSTERS 1 & 2",null,"BOOSTERS 3 & 4",null,"ALL BOOSTERS"]
[1,184095,{"$f":"IF(OR(B8=\"HOL\",B8=\"SUN\",B8=\"SAT\",B8=\"No Read\",B8=\"\"),\"\",IF(INDEX(B8:$B$44,MATCH(TRUE,ISNUMBER(B8:$B$44),0))<LOOKUP(99^99,B$2:B7),(INDEX(B8:$B$44,MATCH(TRUE,ISNUMBER(B8:$B$44),0))*1000),(INDEX(B8:$B$44,MATCH(TRUE,ISNUMBER(B8:$B$44),0))-LOOKUP(99^99,B$2:B7))*1000))","v":78000},{"$f":"IF(OR(B8=\"HOL\",B8=\"SUN\",B8=\"SAT\",B8=\"No Read\",B8=\"\"),\"\",ROUND(C8/E5,1))","v":78000},{"$f":"IF(B8=\"\",E5,IF(C8=\"\",IF(E5>0,E5+1,1),1))","v":1},{"$f":"IF(B8=\"\",\"\",ROUND(OFFSET(D8,MATCH(TRUE,INDEX(D9:D$44<>\"\",0),0),0),0))","v":78000},2643848,{"$f":"IF(OR(G8=\"HOL\",G8=\"SUN\",G8=\"SAT\",G8=\"No Read\",G8=\"\"),\"\",IF(INDEX(G8:$G$44,MATCH(TRUE,ISNUMBER(G8:$G$44),0))<LOOKUP(99^99,G$2:G7),(INDEX(G8:$G$44,MATCH(TRUE,ISNUMBER(G8:$G$44),0))*100),(INDEX(G8:$G$44,MATCH(TRUE,ISNUMBER(G8:$G$44),0))-LOOKUP(99^99,G$2:G7))*100))","v":160200},{"$f":"IF(OR(G8=\"HOL\",G8=\"SUN\",G8=\"SAT\",G8=\"No Read\",G8=\"\"),\"\",ROUND(H8/J5,1))","v":160200},{"$f":"IF(G8=\"\",J5,IF(H8=\"\",IF(J5>0,J5+1,1),1))","v":1},{"$f":"IF(G8=\"\",\"\",ROUND(OFFSET(I8,MATCH(TRUE,INDEX(I9:I$44<>\"\",0),0),0),0))","v":161900},281290,{"$f":"IF(OR(L8=\"HOL\",L8=\"SUN\",L8=\"SAT\",L8=\"No Read\",L8=\"\"),\"\",IF(INDEX(L8:$L$44,MATCH(TRUE,ISNUMBER(L8:$L$44),0))<LOOKUP(99^99,L$2:L7),(INDEX(L8:$L$44,MATCH(TRUE,ISNUMBER(L8:$L$44),0))*1000),(INDEX(L8:$L$44,MATCH(TRUE,ISNUMBER(L8:$L$44),0))-LOOKUP(99^99,L$2:L7))*1000))","v":104000},{"$f":"IF(OR(L8=\"HOL\",L8=\"SUN\",L8=\"SAT\",L8=\"No Read\",L8=\"\"),\"\",ROUND(M8/O5,1))","v":104000},{"$f":"IF(L8=\"\",O5,IF(M8=\"\",IF(O5>0,O5+1,1),1))","v":1},{"$f":"IF(L8=\"\",\"\",ROUND(OFFSET(N8,MATCH(TRUE,INDEX(N9:N$44<>\"\",0),0),0),0))","v":101000},1919868,{"$f":"IF(OR(Q8=\"HOL\",Q8=\"SUN\",Q8=\"SAT\",Q8=\"No Read\",Q8=\"\"),\"\",IF(INDEX(Q8:$Q$44,MATCH(TRUE,ISNUMBER(Q8:$Q$44),0))<LOOKUP(99^99,Q$2:Q7),(INDEX(Q8:$Q$44,MATCH(TRUE,ISNUMBER(Q8:$Q$44),0))*1000),(INDEX(Q8:$Q$44,MATCH(TRUE,ISNUMBER(Q8:$Q$44),0))-LOOKUP(99^99,Q$2:Q7))*1000))","v":263000},{"$f":"IF(OR(Q8=\"HOL\",Q8=\"SUN\",Q8=\"SAT\",Q8=\"No Read\",Q8=\"\"),\"\",ROUND(R8/T5,1))","v":263000},{"$f":"IF(Q8=\"\",T5,IF(R8=\"\",IF(T5>0,T5+1,1),1))","v":1},{"$f":"IF(Q8=\"\",\"\",ROUND(OFFSET(S8,MATCH(TRUE,INDEX(S9:S$44<>\"\",0),0),0),0))","v":264000},null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"SUM(K8,U8)","v":425900},null,310000,null,{"$f":"SUM(AJ8,AL8)","v":735900}]
[2,184173,{"$f":"IF(OR(B9=\"HOL\",B9=\"SUN\",B9=\"SAT\",B9=\"No Read\",B9=\"\"),\"\",IF(INDEX(B9:$B$44,MATCH(TRUE,ISNUMBER(B9:$B$44),0))<LOOKUP(99^99,B$2:B8),(INDEX(B9:$B$44,MATCH(TRUE,ISNUMBER(B9:$B$44),0))*1000),(INDEX(B9:$B$44,MATCH(TRUE,ISNUMBER(B9:$B$44),0))-LOOKUP(99^99,B$2:B8))*1000))","v":78000},{"$f":"IF(OR(B9=\"HOL\",B9=\"SUN\",B9=\"SAT\",B9=\"No Read\",B9=\"\"),\"\",ROUND(C9/E8,1))","v":78000},{"$f":"IF(B9=\"\",E8,IF(C9=\"\",IF(E8>0,E8+1,1),1))","v":1},{"$f":"IF(B9=\"\",\"\",ROUND(OFFSET(D9,MATCH(TRUE,INDEX(D10:D$44<>\"\",0),0),0),0))","v":86000},2645467,{"$f":"IF(OR(G9=\"HOL\",G9=\"SUN\",G9=\"SAT\",G9=\"No Read\",G9=\"\"),\"\",IF(INDEX(G9:$G$44,MATCH(TRUE,ISNUMBER(G9:$G$44),0))<LOOKUP(99^99,G$2:G8),(INDEX(G9:$G$44,MATCH(TRUE,ISNUMBER(G9:$G$44),0))*100),(INDEX(G9:$G$44,MATCH(TRUE,ISNUMBER(G9:$G$44),0))-LOOKUP(99^99,G$2:G8))*100))","v":161900},{"$f":"IF(OR(G9=\"HOL\",G9=\"SUN\",G9=\"SAT\",G9=\"No Read\",G9=\"\"),\"\",ROUND(H9/J8,1))","v":161900},{"$f":"IF(G9=\"\",J8,IF(H9=\"\",IF(J8>0,J8+1,1),1))","v":1},{"$f":"IF(G9=\"\",\"\",ROUND(OFFSET(I9,MATCH(TRUE,INDEX(I10:I$44<>\"\",0),0),0),0))","v":175000},281391,{"$f":"IF(OR(L9=\"HOL\",L9=\"SUN\",L9=\"SAT\",L9=\"No Read\",L9=\"\"),\"\",IF(INDEX(L9:$L$44,MATCH(TRUE,ISNUMBER(L9:$L$44),0))<LOOKUP(99^99,L$2:L8),(INDEX(L9:$L$44,MATCH(TRUE,ISNUMBER(L9:$L$44),0))*1000),(INDEX(L9:$L$44,MATCH(TRUE,ISNUMBER(L9:$L$44),0))-LOOKUP(99^99,L$2:L8))*1000))","v":101000},{"$f":"IF(OR(L9=\"HOL\",L9=\"SUN\",L9=\"SAT\",L9=\"No Read\",L9=\"\"),\"\",ROUND(M9/O8,1))","v":101000},{"$f":"IF(L9=\"\",O8,IF(M9=\"\",IF(O8>0,O8+1,1),1))","v":1},{"$f":"IF(L9=\"\",\"\",ROUND(OFFSET(N9,MATCH(TRUE,INDEX(N10:N$44<>\"\",0),0),0),0))","v":116000},1920132,{"$f":"IF(OR(Q9=\"HOL\",Q9=\"SUN\",Q9=\"SAT\",Q9=\"No Read\",Q9=\"\"),\"\",IF(INDEX(Q9:$Q$44,MATCH(TRUE,ISNUMBER(Q9:$Q$44),0))<LOOKUP(99^99,Q$2:Q8),(INDEX(Q9:$Q$44,MATCH(TRUE,ISNUMBER(Q9:$Q$44),0))*1000),(INDEX(Q9:$Q$44,MATCH(TRUE,ISNUMBER(Q9:$Q$44),0))-LOOKUP(99^99,Q$2:Q8))*1000))","v":264000},{"$f":"IF(OR(Q9=\"HOL\",Q9=\"SUN\",Q9=\"SAT\",Q9=\"No Read\",Q9=\"\"),\"\",ROUND(R9/T8,1))","v":264000},{"$f":"IF(Q9=\"\",T8,IF(R9=\"\",IF(T8>0,T8+1,1),1))","v":1},{"$f":"IF(Q9=\"\",\"\",ROUND(OFFSET(S9,MATCH(TRUE,INDEX(S10:S$44<>\"\",0),0),0),0))","v":284000},null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"SUM(K9,U9)","v":459000},null,276000,null,{"$f":"SUM(AJ9,AL9)","v":735000}]
[3,184259,{"$f":"IF(OR(B10=\"HOL\",B10=\"SUN\",B10=\"SAT\",B10=\"No Read\",B10=\"\"),\"\",IF(INDEX(B10:$B$44,MATCH(TRUE,ISNUMBER(B10:$B$44),0))<LOOKUP(99^99,B$2:B9),(INDEX(B10:$B$44,MATCH(TRUE,ISNUMBER(B10:$B$44),0))*1000),(INDEX(B10:$B$44,MATCH(TRUE,ISNUMBER(B10:$B$44),0))-LOOKUP(99^99,B$2:B9))*1000))","v":86000},{"$f":"IF(OR(B10=\"HOL\",B10=\"SUN\",B10=\"SAT\",B10=\"No Read\",B10=\"\"),\"\",ROUND(C10/E9,1))","v":86000},{"$f":"IF(B10=\"\",E9,IF(C10=\"\",IF(E9>0,E9+1,1),1))","v":1},{"$f":"IF(B10=\"\",\"\",ROUND(OFFSET(D10,MATCH(TRUE,INDEX(D11:D$44<>\"\",0),0),0),0))","v":88000},2647217,{"$f":"IF(OR(G10=\"HOL\",G10=\"SUN\",G10=\"SAT\",G10=\"No Read\",G10=\"\"),\"\",IF(INDEX(G10:$G$44,MATCH(TRUE,ISNUMBER(G10:$G$44),0))<LOOKUP(99^99,G$2:G9),(INDEX(G10:$G$44,MATCH(TRUE,ISNUMBER(G10:$G$44),0))*100),(INDEX(G10:$G$44,MATCH(TRUE,ISNUMBER(G10:$G$44),0))-LOOKUP(99^99,G$2:G9))*100))","v":175000},{"$f":"IF(OR(G10=\"HOL\",G10=\"SUN\",G10=\"SAT\",G10=\"No Read\",G10=\"\"),\"\",ROUND(H10/J9,1))","v":175000},{"$f":"IF(G10=\"\",J9,IF(H10=\"\",IF(J9>0,J9+1,1),1))","v":1},{"$f":"IF(G10=\"\",\"\",ROUND(OFFSET(I10,MATCH(TRUE,INDEX(I11:I$44<>\"\",0),0),0),0))","v":146100},281507,{"$f":"IF(OR(L10=\"HOL\",L10=\"SUN\",L10=\"SAT\",L10=\"No Read\",L10=\"\"),\"\",IF(INDEX(L10:$L$44,MATCH(TRUE,ISNUMBER(L10:$L$44),0))<LOOKUP(99^99,L$2:L9),(INDEX(L10:$L$44,MATCH(TRUE,ISNUMBER(L10:$L$44),0))*1000),(INDEX(L10:$L$44,MATCH(TRUE,ISNUMBER(L10:$L$44),0))-LOOKUP(99^99,L$2:L9))*1000))","v":116000},{"$f":"IF(OR(L10=\"HOL\",L10=\"SUN\",L10=\"SAT\",L10=\"No Read\",L10=\"\"),\"\",ROUND(M10/O9,1))","v":116000},{"$f":"IF(L10=\"\",O9,IF(M10=\"\",IF(O9>0,O9+1,1),1))","v":1},{"$f":"IF(L10=\"\",\"\",ROUND(OFFSET(N10,MATCH(TRUE,INDEX(N11:N$44<>\"\",0),0),0),0))","v":118000},1920416,{"$f":"IF(OR(Q10=\"HOL\",Q10=\"SUN\",Q10=\"SAT\",Q10=\"No Read\",Q10=\"\"),\"\",IF(INDEX(Q10:$Q$44,MATCH(TRUE,ISNUMBER(Q10:$Q$44),0))<LOOKUP(99^99,Q$2:Q9),(INDEX(Q10:$Q$44,MATCH(TRUE,ISNUMBER(Q10:$Q$44),0))*1000),(INDEX(Q10:$Q$44,MATCH(TRUE,ISNUMBER(Q10:$Q$44),0))-LOOKUP(99^99,Q$2:Q9))*1000))","v":284000},{"$f":"IF(OR(Q10=\"HOL\",Q10=\"SUN\",Q10=\"SAT\",Q10=\"No Read\",Q10=\"\"),\"\",ROUND(R10/T9,1))","v":284000},{"$f":"IF(Q10=\"\",T9,IF(R10=\"\",IF(T9>0,T9+1,1),1))","v":1},{"$f":"IF(Q10=\"\",\"\",ROUND(OFFSET(S10,MATCH(TRUE,INDEX(S11:S$44<>\"\",0),0),0),0))","v":240000},null,null,null,null,null,null,null,null,null,null,null,null,null,3,386100,null,413000,null,799100]
[4,184347,{"$f":"IF(OR(B11=\"HOL\",B11=\"SUN\",B11=\"SAT\",B11=\"No Read\",B11=\"\"),\"\",IF(INDEX(B11:$B$44,MATCH(TRUE,ISNUMBER(B11:$B$44),0))<LOOKUP(99^99,B$2:B10),(INDEX(B11:$B$44,MATCH(TRUE,ISNUMBER(B11:$B$44),0))*1000),(INDEX(B11:$B$44,MATCH(TRUE,ISNUMBER(B11:$B$44),0))-LOOKUP(99^99,B$2:B10))*1000))","v":88000},88000,{"$f":"IF(B11=\"\",E10,IF(C11=\"\",IF(E10>0,E10+1,1),1))","v":1},{"$f":"IF(B11=\"\",\"\",ROUND(OFFSET(D11,MATCH(TRUE,INDEX(D12:D$44<>\"\",0),0),0),0))","v":76000},2648678,{"$f":"IF(OR(G11=\"HOL\",G11=\"SUN\",G11=\"SAT\",G11=\"No Read\",G11=\"\"),\"\",IF(INDEX(G11:$G$44,MATCH(TRUE,ISNUMBER(G11:$G$44),0))<LOOKUP(99^99,G$2:G10),(INDEX(G11:$G$44,MATCH(TRUE,ISNUMBER(G11:$G$44),0))*100),(INDEX(G11:$G$44,MATCH(TRUE,ISNUMBER(G11:$G$44),0))-LOOKUP(99^99,G$2:G10))*100))","v":146100},146100,{"$f":"IF(G11=\"\",J10,IF(H11=\"\",IF(J10>0,J10+1,1),1))","v":1},{"$f":"IF(G11=\"\",\"\",ROUND(OFFSET(I11,MATCH(TRUE,INDEX(I12:I$44<>\"\",0),0),0),0))","v":150200},281625,{"$f":"IF(OR(L11=\"HOL\",L11=\"SUN\",L11=\"SAT\",L11=\"No Read\",L11=\"\"),\"\",IF(INDEX(L11:$L$44,MATCH(TRUE,ISNUMBER(L11:$L$44),0))<LOOKUP(99^99,L$2:L10),(INDEX(L11:$L$44,MATCH(TRUE,ISNUMBER(L11:$L$44),0))*1000),(INDEX(L11:$L$44,MATCH(TRUE,ISNUMBER(L11:$L$44),0))-LOOKUP(99^99,L$2:L10))*1000))","v":118000},118000,{"$f":"IF(L11=\"\",O10,IF(M11=\"\",IF(O10>0,O10+1,1),1))","v":1},{"$f":"IF(L11=\"\",\"\",ROUND(OFFSET(N11,MATCH(TRUE,INDEX(N12:N$44<>\"\",0),0),0),0))","v":101000},1920656,{"$f":"IF(OR(Q11=\"HOL\",Q11=\"SUN\",Q11=\"SAT\",Q11=\"No Read\",Q11=\"\"),\"\",IF(INDEX(Q11:$Q$44,MATCH(TRUE,ISNUMBER(Q11:$Q$44),0))<LOOKUP(99^99,Q$2:Q10),(INDEX(Q11:$Q$44,MATCH(TRUE,ISNUMBER(Q11:$Q$44),0))*1000),(INDEX(Q11:$Q$44,MATCH(TRUE,ISNUMBER(Q11:$Q$44),0))-LOOKUP(99^99,Q$2:Q10))*1000))","v":240000},240000,{"$f":"IF(Q11=\"\",T10,IF(R11=\"\",IF(T10>0,T10+1,1),1))","v":1},{"$f":"IF(Q11=\"\",\"\",ROUND(OFFSET(S11,MATCH(TRUE,INDEX(S12:S$44<>\"\",0),0),0),0))","v":247000},null,null,null,null,null,null,null,null,null,null,null,null,null,4,397200,null,362000,null,759200]
[5,184423,{"$f":"IF(OR(B12=\"HOL\",B12=\"SUN\",B12=\"SAT\",B12=\"No Read\",B12=\"\"),\"\",IF(INDEX(B12:$B$44,MATCH(TRUE,ISNUMBER(B12:$B$44),0))<LOOKUP(99^99,B$2:B11),(INDEX(B12:$B$44,MATCH(TRUE,ISNUMBER(B12:$B$44),0))*1000),(INDEX(B12:$B$44,MATCH(TRUE,ISNUMBER(B12:$B$44),0))-LOOKUP(99^99,B$2:B11))*1000))","v":76000},76000,{"$f":"IF(B12=\"\",E11,IF(C12=\"\",IF(E11>0,E11+1,1),1))","v":1},{"$f":"IF(B12=\"\",\"\",ROUND(OFFSET(D12,MATCH(TRUE,INDEX(D13:D$44<>\"\",0),0),0),0))","v":111000},2650180,{"$f":"IF(OR(G12=\"HOL\",G12=\"SUN\",G12=\"SAT\",G12=\"No Read\",G12=\"\"),\"\",IF(INDEX(G12:$G$44,MATCH(TRUE,ISNUMBER(G12:$G$44),0))<LOOKUP(99^99,G$2:G11),(INDEX(G12:$G$44,MATCH(TRUE,ISNUMBER(G12:$G$44),0))*100),(INDEX(G12:$G$44,MATCH(TRUE,ISNUMBER(G12:$G$44),0))-LOOKUP(99^99,G$2:G11))*100))","v":150200},150200,{"$f":"IF(G12=\"\",J11,IF(H12=\"\",IF(J11>0,J11+1,1),1))","v":1},{"$f":"IF(G12=\"\",\"\",ROUND(OFFSET(I12,MATCH(TRUE,INDEX(I13:I$44<>\"\",0),0),0),0))","v":188800},281726,{"$f":"IF(OR(L12=\"HOL\",L12=\"SUN\",L12=\"SAT\",L12=\"No Read\",L12=\"\"),\"\",IF(INDEX(L12:$L$44,MATCH(TRUE,ISNUMBER(L12:$L$44),0))<LOOKUP(99^99,L$2:L11),(INDEX(L12:$L$44,MATCH(TRUE,ISNUMBER(L12:$L$44),0))*1000),(INDEX(L12:$L$44,MATCH(TRUE,ISNUMBER(L12:$L$44),0))-LOOKUP(99^99,L$2:L11))*1000))","v":101000},101000,{"$f":"IF(L12=\"\",O11,IF(M12=\"\",IF(O11>0,O11+1,1),1))","v":1},{"$f":"IF(L12=\"\",\"\",ROUND(OFFSET(N12,MATCH(TRUE,INDEX(N13:N$44<>\"\",0),0),0),0))","v":149000},1920903,{"$f":"IF(OR(Q12=\"HOL\",Q12=\"SUN\",Q12=\"SAT\",Q12=\"No Read\",Q12=\"\"),\"\",IF(INDEX(Q12:$Q$44,MATCH(TRUE,ISNUMBER(Q12:$Q$44),0))<LOOKUP(99^99,Q$2:Q11),(INDEX(Q12:$Q$44,MATCH(TRUE,ISNUMBER(Q12:$Q$44),0))*1000),(INDEX(Q12:$Q$44,MATCH(TRUE,ISNUMBER(Q12:$Q$44),0))-LOOKUP(99^99,Q$2:Q11))*1000))","v":247000},247000,{"$f":"IF(Q12=\"\",T11,IF(R12=\"\",IF(T11>0,T11+1,1),1))","v":1},{"$f":"IF(Q12=\"\",\"\",ROUND(OFFSET(S12,MATCH(TRUE,INDEX(S13:S$44<>\"\",0),0),0),0))","v":315000},null,null,null,null,null,null,null,null,null,null,null,null,null,5,503800,null,331000,null,834800]
[6,184534,{"$f":"IF(OR(B13=\"HOL\",B13=\"SUN\",B13=\"SAT\",B13=\"No Read\",B13=\"\"),\"\",IF(INDEX(B13:$B$44,MATCH(TRUE,ISNUMBER(B13:$B$44),0))<LOOKUP(99^99,B$2:B12),(INDEX(B13:$B$44,MATCH(TRUE,ISNUMBER(B13:$B$44),0))*1000),(INDEX(B13:$B$44,MATCH(TRUE,ISNUMBER(B13:$B$44),0))-LOOKUP(99^99,B$2:B12))*1000))","v":111000},111000,{"$f":"IF(B13=\"\",E12,IF(C13=\"\",IF(E12>0,E12+1,1),1))","v":1},{"$f":"IF(B13=\"\",\"\",ROUND(OFFSET(D13,MATCH(TRUE,INDEX(D14:D$44<>\"\",0),0),0),0))","v":56000},2652068,{"$f":"IF(OR(G13=\"HOL\",G13=\"SUN\",G13=\"SAT\",G13=\"No Read\",G13=\"\"),\"\",IF(INDEX(G13:$G$44,MATCH(TRUE,ISNUMBER(G13:$G$44),0))<LOOKUP(99^99,G$2:G12),(INDEX(G13:$G$44,MATCH(TRUE,ISNUMBER(G13:$G$44),0))*100),(INDEX(G13:$G$44,MATCH(TRUE,ISNUMBER(G13:$G$44),0))-LOOKUP(99^99,G$2:G12))*100))","v":188800},188800,{"$f":"IF(G13=\"\",J12,IF(H13=\"\",IF(J12>0,J12+1,1),1))","v":1},{"$f":"IF(G13=\"\",\"\",ROUND(OFFSET(I13,MATCH(TRUE,INDEX(I14:I$44<>\"\",0),0),0),0))","v":136000},281875,{"$f":"IF(OR(L13=\"HOL\",L13=\"SUN\",L13=\"SAT\",L13=\"No Read\",L13=\"\"),\"\",IF(INDEX(L13:$L$44,MATCH(TRUE,ISNUMBER(L13:$L$44),0))<LOOKUP(99^99,L$2:L12),(INDEX(L13:$L$44,MATCH(TRUE,ISNUMBER(L13:$L$44),0))*1000),(INDEX(L13:$L$44,MATCH(TRUE,ISNUMBER(L13:$L$44),0))-LOOKUP(99^99,L$2:L12))*1000))","v":149000},149000,{"$f":"IF(L13=\"\",O12,IF(M13=\"\",IF(O12>0,O12+1,1),1))","v":1},{"$f":"IF(L13=\"\",\"\",ROUND(OFFSET(N13,MATCH(TRUE,INDEX(N14:N$44<>\"\",0),0),0),0))","v":77000},1921218,{"$f":"IF(OR(Q13=\"HOL\",Q13=\"SUN\",Q13=\"SAT\",Q13=\"No Read\",Q13=\"\"),\"\",IF(INDEX(Q13:$Q$44,MATCH(TRUE,ISNUMBER(Q13:$Q$44),0))<LOOKUP(99^99,Q$2:Q12),(INDEX(Q13:$Q$44,MATCH(TRUE,ISNUMBER(Q13:$Q$44),0))*1000),(INDEX(Q13:$Q$44,MATCH(TRUE,ISNUMBER(Q13:$Q$44),0))-LOOKUP(99^99,Q$2:Q12))*1000))","v":315000},315000,{"$f":"IF(Q13=\"\",T12,IF(R13=\"\",IF(T12>0,T12+1,1),1))","v":1},{"$f":"IF(Q13=\"\",\"\",ROUND(OFFSET(S13,MATCH(TRUE,INDEX(S14:S$44<>\"\",0),0),0),0))","v":227000},null,null,null,null,null,null,null,null,null,null,null,null,null,6,363000,null,359000,null,722000]
[7,184590,{"$f":"IF(OR(B14=\"HOL\",B14=\"SUN\",B14=\"SAT\",B14=\"No Read\",B14=\"\"),\"\",IF(INDEX(B14:$B$44,MATCH(TRUE,ISNUMBER(B14:$B$44),0))<LOOKUP(99^99,B$2:B13),(INDEX(B14:$B$44,MATCH(TRUE,ISNUMBER(B14:$B$44),0))*1000),(INDEX(B14:$B$44,MATCH(TRUE,ISNUMBER(B14:$B$44),0))-LOOKUP(99^99,B$2:B13))*1000))","v":56000},56000,1,{"$f":"IF(B14=\"\",\"\",ROUND(OFFSET(D14,MATCH(TRUE,INDEX(D15:D$44<>\"\",0),0),0),0))","v":84000},2653428,{"$f":"IF(OR(G14=\"HOL\",G14=\"SUN\",G14=\"SAT\",G14=\"No Read\",G14=\"\"),\"\",IF(INDEX(G14:$G$44,MATCH(TRUE,ISNUMBER(G14:$G$44),0))<LOOKUP(99^99,G$2:G13),(INDEX(G14:$G$44,MATCH(TRUE,ISNUMBER(G14:$G$44),0))*100),(INDEX(G14:$G$44,MATCH(TRUE,ISNUMBER(G14:$G$44),0))-LOOKUP(99^99,G$2:G13))*100))","v":136000},136000,1,{"$f":"IF(G14=\"\",\"\",ROUND(OFFSET(I14,MATCH(TRUE,INDEX(I15:I$44<>\"\",0),0),0),0))","v":160800},281952,{"$f":"IF(OR(L14=\"HOL\",L14=\"SUN\",L14=\"SAT\",L14=\"No Read\",L14=\"\"),\"\",IF(INDEX(L14:$L$44,MATCH(TRUE,ISNUMBER(L14:$L$44),0))<LOOKUP(99^99,L$2:L13),(INDEX(L14:$L$44,MATCH(TRUE,ISNUMBER(L14:$L$44),0))*1000),(INDEX(L14:$L$44,MATCH(TRUE,ISNUMBER(L14:$L$44),0))-LOOKUP(99^99,L$2:L13))*1000))","v":77000},77000,1,{"$f":"IF(L14=\"\",\"\",ROUND(OFFSET(N14,MATCH(TRUE,INDEX(N15:N$44<>\"\",0),0),0),0))","v":117000},1921445,{"$f":"IF(OR(Q14=\"HOL\",Q14=\"SUN\",Q14=\"SAT\",Q14=\"No Read\",Q14=\"\"),\"\",IF(INDEX(Q14:$Q$44,MATCH(TRUE,ISNUMBER(Q14:$Q$44),0))<LOOKUP(99^99,Q$2:Q13),(INDEX(Q14:$Q$44,MATCH(TRUE,ISNUMBER(Q14:$Q$44),0))*1000),(INDEX(Q14:$Q$44,MATCH(TRUE,ISNUMBER(Q14:$Q$44),0))-LOOKUP(99^99,Q$2:Q13))*1000))","v":227000},227000,1,{"$f":"IF(Q14=\"\",\"\",ROUND(OFFSET(S14,MATCH(TRUE,INDEX(S15:S$44<>\"\",0),0),0),0))","v":264000},null,null,null,null,null,null,null,null,null,null,null,null,null,7,424800,null,380000,null,804800]
[8,184674,{"$f":"IF(OR(B15=\"HOL\",B15=\"SUN\",B15=\"SAT\",B15=\"No Read\",B15=\"\"),\"\",IF(INDEX(B15:$B$44,MATCH(TRUE,ISNUMBER(B15:$B$44),0))<LOOKUP(99^99,B$2:B14),(INDEX(B15:$B$44,MATCH(TRUE,ISNUMBER(B15:$B$44),0))*1000),(INDEX(B15:$B$44,MATCH(TRUE,ISNUMBER(B15:$B$44),0))-LOOKUP(99^99,B$2:B14))*1000))","v":84000},84000,1,{"$f":"IF(B15=\"\",\"\",ROUND(OFFSET(D15,MATCH(TRUE,INDEX(D16:D$44<>\"\",0),0),0),0))","v":70000},2655036,{"$f":"IF(OR(G15=\"HOL\",G15=\"SUN\",G15=\"SAT\",G15=\"No Read\",G15=\"\"),\"\",IF(INDEX(G15:$G$44,MATCH(TRUE,ISNUMBER(G15:$G$44),0))<LOOKUP(99^99,G$2:G14),(INDEX(G15:$G$44,MATCH(TRUE,ISNUMBER(G15:$G$44),0))*100),(INDEX(G15:$G$44,MATCH(TRUE,ISNUMBER(G15:$G$44),0))-LOOKUP(99^99,G$2:G14))*100))","v":160800},160800,1,{"$f":"IF(G15=\"\",\"\",ROUND(OFFSET(I15,MATCH(TRUE,INDEX(I16:I$44<>\"\",0),0),0),0))","v":161600},282069,{"$f":"IF(OR(L15=\"HOL\",L15=\"SUN\",L15=\"SAT\",L15=\"No Read\",L15=\"\"),\"\",IF(INDEX(L15:$L$44,MATCH(TRUE,ISNUMBER(L15:$L$44),0))<LOOKUP(99^99,L$2:L14),(INDEX(L15:$L$44,MATCH(TRUE,ISNUMBER(L15:$L$44),0))*1000),(INDEX(L15:$L$44,MATCH(TRUE,ISNUMBER(L15:$L$44),0))-LOOKUP(99^99,L$2:L14))*1000))","v":117000},117000,1,{"$f":"IF(L15=\"\",\"\",ROUND(OFFSET(N15,MATCH(TRUE,INDEX(N16:N$44<>\"\",0),0),0),0))","v":89000},1921709,{"$f":"IF(OR(Q15=\"HOL\",Q15=\"SUN\",Q15=\"SAT\",Q15=\"No Read\",Q15=\"\"),\"\",IF(INDEX(Q15:$Q$44,MATCH(TRUE,ISNUMBER(Q15:$Q$44),0))<LOOKUP(99^99,Q$2:Q14),(INDEX(Q15:$Q$44,MATCH(TRUE,ISNUMBER(Q15:$Q$44),0))*1000),(INDEX(Q15:$Q$44,MATCH(TRUE,ISNUMBER(Q15:$Q$44),0))-LOOKUP(99^99,Q$2:Q14))*1000))","v":264000},264000,1,{"$f":"IF(Q15=\"\",\"\",ROUND(OFFSET(S15,MATCH(TRUE,INDEX(S16:S$44<>\"\",0),0),0),0))","v":264000},null,null,null,null,null,null,null,null,null,null,null,null,null,8,425600,null,329000,null,754600]
[9,184744,{"$f":"IF(OR(B16=\"HOL\",B16=\"SUN\",B16=\"SAT\",B16=\"No Read\",B16=\"\"),\"\",IF(INDEX(B16:$B$44,MATCH(TRUE,ISNUMBER(B16:$B$44),0))<LOOKUP(99^99,B$2:B15),(INDEX(B16:$B$44,MATCH(TRUE,ISNUMBER(B16:$B$44),0))*1000),(INDEX(B16:$B$44,MATCH(TRUE,ISNUMBER(B16:$B$44),0))-LOOKUP(99^99,B$2:B15))*1000))","v":70000},70000,1,{"$f":"IF(B16=\"\",\"\",ROUND(OFFSET(D16,MATCH(TRUE,INDEX(D17:D$44<>\"\",0),0),0),0))","v":48000},2656652,{"$f":"IF(OR(G16=\"HOL\",G16=\"SUN\",G16=\"SAT\",G16=\"No Read\",G16=\"\"),\"\",IF(INDEX(G16:$G$44,MATCH(TRUE,ISNUMBER(G16:$G$44),0))<LOOKUP(99^99,G$2:G15),(INDEX(G16:$G$44,MATCH(TRUE,ISNUMBER(G16:$G$44),0))*100),(INDEX(G16:$G$44,MATCH(TRUE,ISNUMBER(G16:$G$44),0))-LOOKUP(99^99,G$2:G15))*100))","v":161600},161600,1,{"$f":"IF(G16=\"\",\"\",ROUND(OFFSET(I16,MATCH(TRUE,INDEX(I17:I$44<>\"\",0),0),0),0))","v":160000},282158,{"$f":"IF(OR(L16=\"HOL\",L16=\"SUN\",L16=\"SAT\",L16=\"No Read\",L16=\"\"),\"\",IF(INDEX(L16:$L$44,MATCH(TRUE,ISNUMBER(L16:$L$44),0))<LOOKUP(99^99,L$2:L15),(INDEX(L16:$L$44,MATCH(TRUE,ISNUMBER(L16:$L$44),0))*1000),(INDEX(L16:$L$44,MATCH(TRUE,ISNUMBER(L16:$L$44),0))-LOOKUP(99^99,L$2:L15))*1000))","v":89000},89000,1,{"$f":"IF(L16=\"\",\"\",ROUND(OFFSET(N16,MATCH(TRUE,INDEX(N17:N$44<>\"\",0),0),0),0))","v":66000},1921973,{"$f":"IF(OR(Q16=\"HOL\",Q16=\"SUN\",Q16=\"SAT\",Q16=\"No Read\",Q16=\"\"),\"\",IF(INDEX(Q16:$Q$44,MATCH(TRUE,ISNUMBER(Q16:$Q$44),0))<LOOKUP(99^99,Q$2:Q15),(INDEX(Q16:$Q$44,MATCH(TRUE,ISNUMBER(Q16:$Q$44),0))*1000),(INDEX(Q16:$Q$44,MATCH(TRUE,ISNUMBER(Q16:$Q$44),0))-LOOKUP(99^99,Q$2:Q15))*1000))","v":264000},264000,1,{"$f":"IF(Q16=\"\",\"\",ROUND(OFFSET(S16,MATCH(TRUE,INDEX(S17:S$44<>\"\",0),0),0),0))","v":247000},null,null,null,null,null,null,null,null,null,null,null,null,null,9,407000,null,197000,null,604000]
[10,184792,{"$f":"IF(OR(B17=\"HOL\",B17=\"SUN\",B17=\"SAT\",B17=\"No Read\",B17=\"\"),\"\",IF(INDEX(B17:$B$44,MATCH(TRUE,ISNUMBER(B17:$B$44),0))<LOOKUP(99^99,B$2:B16),(INDEX(B17:$B$44,MATCH(TRUE,ISNUMBER(B17:$B$44),0))*1000),(INDEX(B17:$B$44,MATCH(TRUE,ISNUMBER(B17:$B$44),0))-LOOKUP(99^99,B$2:B16))*1000))","v":48000},48000,1,{"$f":"IF(B17=\"\",\"\",ROUND(OFFSET(D17,MATCH(TRUE,INDEX(D18:D$44<>\"\",0),0),0),0))","v":78000},2658252,{"$f":"IF(OR(G17=\"HOL\",G17=\"SUN\",G17=\"SAT\",G17=\"No Read\",G17=\"\"),\"\",IF(INDEX(G17:$G$44,MATCH(TRUE,ISNUMBER(G17:$G$44),0))<LOOKUP(99^99,G$2:G16),(INDEX(G17:$G$44,MATCH(TRUE,ISNUMBER(G17:$G$44),0))*100),(INDEX(G17:$G$44,MATCH(TRUE,ISNUMBER(G17:$G$44),0))-LOOKUP(99^99,G$2:G16))*100))","v":160000},160000,1,{"$f":"IF(G17=\"\",\"\",ROUND(OFFSET(I17,MATCH(TRUE,INDEX(I18:I$44<>\"\",0),0),0),0))","v":160000},282224,{"$f":"IF(OR(L17=\"HOL\",L17=\"SUN\",L17=\"SAT\",L17=\"No Read\",L17=\"\"),\"\",IF(INDEX(L17:$L$44,MATCH(TRUE,ISNUMBER(L17:$L$44),0))<LOOKUP(99^99,L$2:L16),(INDEX(L17:$L$44,MATCH(TRUE,ISNUMBER(L17:$L$44),0))*1000),(INDEX(L17:$L$44,MATCH(TRUE,ISNUMBER(L17:$L$44),0))-LOOKUP(99^99,L$2:L16))*1000))","v":66000},66000,1,{"$f":"IF(L17=\"\",\"\",ROUND(OFFSET(N17,MATCH(TRUE,INDEX(N18:N$44<>\"\",0),0),0),0))","v":102000},1922220,{"$f":"IF(OR(Q17=\"HOL\",Q17=\"SUN\",Q17=\"SAT\",Q17=\"No Read\",Q17=\"\"),\"\",IF(INDEX(Q17:$Q$44,MATCH(TRUE,ISNUMBER(Q17:$Q$44),0))<LOOKUP(99^99,Q$2:Q16),(INDEX(Q17:$Q$44,MATCH(TRUE,ISNUMBER(Q17:$Q$44),0))*1000),(INDEX(Q17:$Q$44,MATCH(TRUE,ISNUMBER(Q17:$Q$44),0))-LOOKUP(99^99,Q$2:Q16))*1000))","v":247000},247000,1,{"$f":"IF(Q17=\"\",\"\",ROUND(OFFSET(S17,MATCH(TRUE,INDEX(S18:S$44<>\"\",0),0),0),0))","v":242000},null,null,null,null,null,null,null,null,null,null,null,null,null,10,402000,null,257000,null,659000]
[11,184870,{"$f":"IF(OR(B18=\"HOL\",B18=\"SUN\",B18=\"SAT\",B18=\"No Read\",B18=\"\"),\"\",IF(INDEX(B18:$B$44,MATCH(TRUE,ISNUMBER(B18:$B$44),0))<LOOKUP(99^99,B$2:B17),(INDEX(B18:$B$44,MATCH(TRUE,ISNUMBER(B18:$B$44),0))*1000),(INDEX(B18:$B$44,MATCH(TRUE,ISNUMBER(B18:$B$44),0))-LOOKUP(99^99,B$2:B17))*1000))","v":78000},{"$f":"IF(OR(B18=\"HOL\",B18=\"SUN\",B18=\"SAT\",B18=\"No Read\",B18=\"\"),\"\",ROUND(C18/E17,1))","v":78000},1,{"$f":"IF(B18=\"\",\"\",ROUND(OFFSET(D18,MATCH(TRUE,INDEX(D19:D$44<>\"\",0),0),0),0))","v":59000},2659852,{"$f":"IF(OR(G18=\"HOL\",G18=\"SUN\",G18=\"SAT\",G18=\"No Read\",G18=\"\"),\"\",IF(INDEX(G18:$G$44,MATCH(TRUE,ISNUMBER(G18:$G$44),0))<LOOKUP(99^99,G$2:G17),(INDEX(G18:$G$44,MATCH(TRUE,ISNUMBER(G18:$G$44),0))*100),(INDEX(G18:$G$44,MATCH(TRUE,ISNUMBER(G18:$G$44),0))-LOOKUP(99^99,G$2:G17))*100))","v":160000},{"$f":"IF(OR(G18=\"HOL\",G18=\"SUN\",G18=\"SAT\",G18=\"No Read\",G18=\"\"),\"\",ROUND(H18/J17,1))","v":160000},1,{"$f":"IF(G18=\"\",\"\",ROUND(OFFSET(I18,MATCH(TRUE,INDEX(I19:I$44<>\"\",0),0),0),0))","v":154400},282326,{"$f":"IF(OR(L18=\"HOL\",L18=\"SUN\",L18=\"SAT\",L18=\"No Read\",L18=\"\"),\"\",IF(INDEX(L18:$L$44,MATCH(TRUE,ISNUMBER(L18:$L$44),0))<LOOKUP(99^99,L$2:L17),(INDEX(L18:$L$44,MATCH(TRUE,ISNUMBER(L18:$L$44),0))*1000),(INDEX(L18:$L$44,MATCH(TRUE,ISNUMBER(L18:$L$44),0))-LOOKUP(99^99,L$2:L17))*1000))","v":102000},{"$f":"IF(OR(L18=\"HOL\",L18=\"SUN\",L18=\"SAT\",L18=\"No Read\",L18=\"\"),\"\",ROUND(M18/O17,1))","v":102000},1,{"$f":"IF(L18=\"\",\"\",ROUND(OFFSET(N18,MATCH(TRUE,INDEX(N19:N$44<>\"\",0),0),0),0))","v":81000},1922462,{"$f":"IF(OR(Q18=\"HOL\",Q18=\"SUN\",Q18=\"SAT\",Q18=\"No Read\",Q18=\"\"),\"\",IF(INDEX(Q18:$Q$44,MATCH(TRUE,ISNUMBER(Q18:$Q$44),0))<LOOKUP(99^99,Q$2:Q17),(INDEX(Q18:$Q$44,MATCH(TRUE,ISNUMBER(Q18:$Q$44),0))*1000),(INDEX(Q18:$Q$44,MATCH(TRUE,ISNUMBER(Q18:$Q$44),0))-LOOKUP(99^99,Q$2:Q17))*1000))","v":242000},{"$f":"IF(OR(Q18=\"HOL\",Q18=\"SUN\",Q18=\"SAT\",Q18=\"No Read\",Q18=\"\"),\"\",ROUND(R18/T17,1))","v":242000},1,{"$f":"IF(Q18=\"\",\"\",ROUND(OFFSET(S18,MATCH(TRUE,INDEX(S19:S$44<>\"\",0),0),0),0))","v":241000},null,null,"These four values can be entered instead of numbers",null,null,null,null,null,null,null,null,null,null,11,395400,null,224000,null,619400]
[12,184929,{"$f":"IF(OR(B19=\"HOL\",B19=\"SUN\",B19=\"SAT\",B19=\"No Read\",B19=\"\"),\"\",IF(INDEX(B19:$B$44,MATCH(TRUE,ISNUMBER(B19:$B$44),0))<LOOKUP(99^99,B$2:B18),(INDEX(B19:$B$44,MATCH(TRUE,ISNUMBER(B19:$B$44),0))*1000),(INDEX(B19:$B$44,MATCH(TRUE,ISNUMBER(B19:$B$44),0))-LOOKUP(99^99,B$2:B18))*1000))","v":59000},{"$f":"IF(OR(B19=\"HOL\",B19=\"SUN\",B19=\"SAT\",B19=\"No Read\",B19=\"\"),\"\",ROUND(C19/E18,1))","v":59000},1,{"$f":"IF(B19=\"\",\"\",ROUND(OFFSET(D19,MATCH(TRUE,INDEX(D20:D$44<>\"\",0),0),0),0))","v":74000},2661396,{"$f":"IF(OR(G19=\"HOL\",G19=\"SUN\",G19=\"SAT\",G19=\"No Read\",G19=\"\"),\"\",IF(INDEX(G19:$G$44,MATCH(TRUE,ISNUMBER(G19:$G$44),0))<LOOKUP(99^99,G$2:G18),(INDEX(G19:$G$44,MATCH(TRUE,ISNUMBER(G19:$G$44),0))*100),(INDEX(G19:$G$44,MATCH(TRUE,ISNUMBER(G19:$G$44),0))-LOOKUP(99^99,G$2:G18))*100))","v":154400},{"$f":"IF(OR(G19=\"HOL\",G19=\"SUN\",G19=\"SAT\",G19=\"No Read\",G19=\"\"),\"\",ROUND(H19/J18,1))","v":154400},1,{"$f":"IF(G19=\"\",\"\",ROUND(OFFSET(I19,MATCH(TRUE,INDEX(I20:I$44<>\"\",0),0),0),0))","v":160200},282407,{"$f":"IF(OR(L19=\"HOL\",L19=\"SUN\",L19=\"SAT\",L19=\"No Read\",L19=\"\"),\"\",IF(INDEX(L19:$L$44,MATCH(TRUE,ISNUMBER(L19:$L$44),0))<LOOKUP(99^99,L$2:L18),(INDEX(L19:$L$44,MATCH(TRUE,ISNUMBER(L19:$L$44),0))*1000),(INDEX(L19:$L$44,MATCH(TRUE,ISNUMBER(L19:$L$44),0))-LOOKUP(99^99,L$2:L18))*1000))","v":81000},{"$f":"IF(OR(L19=\"HOL\",L19=\"SUN\",L19=\"SAT\",L19=\"No Read\",L19=\"\"),\"\",ROUND(M19/O18,1))","v":81000},1,{"$f":"IF(L19=\"\",\"\",ROUND(OFFSET(N19,MATCH(TRUE,INDEX(N20:N$44<>\"\",0),0),0),0))","v":99000},1922703,{"$f":"IF(OR(Q19=\"HOL\",Q19=\"SUN\",Q19=\"SAT\",Q19=\"No Read\",Q19=\"\"),\"\",IF(INDEX(Q19:$Q$44,MATCH(TRUE,ISNUMBER(Q19:$Q$44),0))<LOOKUP(99^99,Q$2:Q18),(INDEX(Q19:$Q$44,MATCH(TRUE,ISNUMBER(Q19:$Q$44),0))*1000),(INDEX(Q19:$Q$44,MATCH(TRUE,ISNUMBER(Q19:$Q$44),0))-LOOKUP(99^99,Q$2:Q18))*1000))","v":241000},{"$f":"IF(OR(Q19=\"HOL\",Q19=\"SUN\",Q19=\"SAT\",Q19=\"No Read\",Q19=\"\"),\"\",ROUND(R19/T18,1))","v":241000},1,{"$f":"IF(Q19=\"\",\"\",ROUND(OFFSET(S19,MATCH(TRUE,INDEX(S20:S$44<>\"\",0),0),0),0))","v":271000},null,null,"SAT - Saturday",null,null,null,null,null,null,null,null,null,null,12,431200,null,249000,null,680200]
[13,185003,{"$f":"IF(OR(B20=\"HOL\",B20=\"SUN\",B20=\"SAT\",B20=\"No Read\",B20=\"\"),\"\",IF(INDEX(B20:$B$44,MATCH(TRUE,ISNUMBER(B20:$B$44),0))<LOOKUP(99^99,B$2:B19),(INDEX(B20:$B$44,MATCH(TRUE,ISNUMBER(B20:$B$44),0))*1000),(INDEX(B20:$B$44,MATCH(TRUE,ISNUMBER(B20:$B$44),0))-LOOKUP(99^99,B$2:B19))*1000))","v":74000},74000,1,{"$f":"IF(B20=\"\",\"\",ROUND(OFFSET(D20,MATCH(TRUE,INDEX(D21:D$44<>\"\",0),0),0),0))","v":74000},"NO READ",{"$f":"IF(OR(G20=\"HOL\",G20=\"SUN\",G20=\"SAT\",G20=\"No Read\",G20=\"\"),\"\",IF(INDEX(G20:$G$44,MATCH(TRUE,ISNUMBER(G20:$G$44),0))<LOOKUP(99^99,G$2:G19),(INDEX(G20:$G$44,MATCH(TRUE,ISNUMBER(G20:$G$44),0))*100),(INDEX(G20:$G$44,MATCH(TRUE,ISNUMBER(G20:$G$44),0))-LOOKUP(99^99,G$2:G19))*100))","v":""},"",2,{"$f":"IF(G20=\"\",\"\",ROUND(OFFSET(I20,MATCH(TRUE,INDEX(I21:I$44<>\"\",0),0),0),0))","v":160200},282506,{"$f":"IF(OR(L20=\"HOL\",L20=\"SUN\",L20=\"SAT\",L20=\"No Read\",L20=\"\"),\"\",IF(INDEX(L20:$L$44,MATCH(TRUE,ISNUMBER(L20:$L$44),0))<LOOKUP(99^99,L$2:L19),(INDEX(L20:$L$44,MATCH(TRUE,ISNUMBER(L20:$L$44),0))*1000),(INDEX(L20:$L$44,MATCH(TRUE,ISNUMBER(L20:$L$44),0))-LOOKUP(99^99,L$2:L19))*1000))","v":99000},99000,1,{"$f":"IF(L20=\"\",\"\",ROUND(OFFSET(N20,MATCH(TRUE,INDEX(N21:N$44<>\"\",0),0),0),0))","v":99000},1922974,{"$f":"IF(OR(Q20=\"HOL\",Q20=\"SUN\",Q20=\"SAT\",Q20=\"No Read\",Q20=\"\"),\"\",IF(INDEX(Q20:$Q$44,MATCH(TRUE,ISNUMBER(Q20:$Q$44),0))<LOOKUP(99^99,Q$2:Q19),(INDEX(Q20:$Q$44,MATCH(TRUE,ISNUMBER(Q20:$Q$44),0))*1000),(INDEX(Q20:$Q$44,MATCH(TRUE,ISNUMBER(Q20:$Q$44),0))-LOOKUP(99^99,Q$2:Q19))*1000))","v":271000},271000,1,{"$f":"IF(Q20=\"\",\"\",ROUND(OFFSET(S20,MATCH(TRUE,INDEX(S21:S$44<>\"\",0),0),0),0))","v":245000},null,null,"SUN - Sunday",null,null,null,null,null,null,null,null,null,null,13,405200,null,274000,null,679200]
[14,185077,{"$f":"IF(OR(B21=\"HOL\",B21=\"SUN\",B21=\"SAT\",B21=\"No Read\",B21=\"\"),\"\",IF(INDEX(B21:$B$44,MATCH(TRUE,ISNUMBER(B21:$B$44),0))<LOOKUP(99^99,B$2:B20),(INDEX(B21:$B$44,MATCH(TRUE,ISNUMBER(B21:$B$44),0))*1000),(INDEX(B21:$B$44,MATCH(TRUE,ISNUMBER(B21:$B$44),0))-LOOKUP(99^99,B$2:B20))*1000))","v":74000},74000,1,{"$f":"IF(B21=\"\",\"\",ROUND(OFFSET(D21,MATCH(TRUE,INDEX(D22:D$44<>\"\",0),0),0),0))","v":68000},2664600,{"$f":"IF(OR(G21=\"HOL\",G21=\"SUN\",G21=\"SAT\",G21=\"No Read\",G21=\"\"),\"\",IF(INDEX(G21:$G$44,MATCH(TRUE,ISNUMBER(G21:$G$44),0))<LOOKUP(99^99,G$2:G20),(INDEX(G21:$G$44,MATCH(TRUE,ISNUMBER(G21:$G$44),0))*100),(INDEX(G21:$G$44,MATCH(TRUE,ISNUMBER(G21:$G$44),0))-LOOKUP(99^99,G$2:G20))*100))","v":320400},160200,1,{"$f":"IF(G21=\"\",\"\",ROUND(OFFSET(I21,MATCH(TRUE,INDEX(I22:I$44<>\"\",0),0),0),0))","v":153100},282605,{"$f":"IF(OR(L21=\"HOL\",L21=\"SUN\",L21=\"SAT\",L21=\"No Read\",L21=\"\"),\"\",IF(INDEX(L21:$L$44,MATCH(TRUE,ISNUMBER(L21:$L$44),0))<LOOKUP(99^99,L$2:L20),(INDEX(L21:$L$44,MATCH(TRUE,ISNUMBER(L21:$L$44),0))*1000),(INDEX(L21:$L$44,MATCH(TRUE,ISNUMBER(L21:$L$44),0))-LOOKUP(99^99,L$2:L20))*1000))","v":99000},99000,1,{"$f":"IF(L21=\"\",\"\",ROUND(OFFSET(N21,MATCH(TRUE,INDEX(N22:N$44<>\"\",0),0),0),0))","v":92000},1923219,{"$f":"IF(OR(Q21=\"HOL\",Q21=\"SUN\",Q21=\"SAT\",Q21=\"No Read\",Q21=\"\"),\"\",IF(INDEX(Q21:$Q$44,MATCH(TRUE,ISNUMBER(Q21:$Q$44),0))<LOOKUP(99^99,Q$2:Q20),(INDEX(Q21:$Q$44,MATCH(TRUE,ISNUMBER(Q21:$Q$44),0))*1000),(INDEX(Q21:$Q$44,MATCH(TRUE,ISNUMBER(Q21:$Q$44),0))-LOOKUP(99^99,Q$2:Q20))*1000))","v":245000},245000,1,{"$f":"IF(Q21=\"\",\"\",ROUND(OFFSET(S21,MATCH(TRUE,INDEX(S22:S$44<>\"\",0),0),0),0))","v":237000},null,null,"HOL - Holiday",null,null,null,null,null,null,null,null,null,null,14,390100,null,232000,null,622100]
[15,185145,{"$f":"IF(OR(B22=\"HOL\",B22=\"SUN\",B22=\"SAT\",B22=\"No Read\",B22=\"\"),\"\",IF(INDEX(B22:$B$44,MATCH(TRUE,ISNUMBER(B22:$B$44),0))<LOOKUP(99^99,B$2:B21),(INDEX(B22:$B$44,MATCH(TRUE,ISNUMBER(B22:$B$44),0))*1000),(INDEX(B22:$B$44,MATCH(TRUE,ISNUMBER(B22:$B$44),0))-LOOKUP(99^99,B$2:B21))*1000))","v":68000},68000,1,{"$f":"IF(B22=\"\",\"\",ROUND(OFFSET(D22,MATCH(TRUE,INDEX(D23:D$44<>\"\",0),0),0),0))","v":82000},2666131,{"$f":"IF(OR(G22=\"HOL\",G22=\"SUN\",G22=\"SAT\",G22=\"No Read\",G22=\"\"),\"\",IF(INDEX(G22:$G$44,MATCH(TRUE,ISNUMBER(G22:$G$44),0))<LOOKUP(99^99,G$2:G21),(INDEX(G22:$G$44,MATCH(TRUE,ISNUMBER(G22:$G$44),0))*100),(INDEX(G22:$G$44,MATCH(TRUE,ISNUMBER(G22:$G$44),0))-LOOKUP(99^99,G$2:G21))*100))","v":153100},153100,1,{"$f":"IF(G22=\"\",\"\",ROUND(OFFSET(I22,MATCH(TRUE,INDEX(I23:I$44<>\"\",0),0),0),0))","v":161700},282697,{"$f":"IF(OR(L22=\"HOL\",L22=\"SUN\",L22=\"SAT\",L22=\"No Read\",L22=\"\"),\"\",IF(INDEX(L22:$L$44,MATCH(TRUE,ISNUMBER(L22:$L$44),0))<LOOKUP(99^99,L$2:L21),(INDEX(L22:$L$44,MATCH(TRUE,ISNUMBER(L22:$L$44),0))*1000),(INDEX(L22:$L$44,MATCH(TRUE,ISNUMBER(L22:$L$44),0))-LOOKUP(99^99,L$2:L21))*1000))","v":92000},92000,1,{"$f":"IF(L22=\"\",\"\",ROUND(OFFSET(N22,MATCH(TRUE,INDEX(N23:N$44<>\"\",0),0),0),0))","v":112000},1923456,{"$f":"IF(OR(Q22=\"HOL\",Q22=\"SUN\",Q22=\"SAT\",Q22=\"No Read\",Q22=\"\"),\"\",IF(INDEX(Q22:$Q$44,MATCH(TRUE,ISNUMBER(Q22:$Q$44),0))<LOOKUP(99^99,Q$2:Q21),(INDEX(Q22:$Q$44,MATCH(TRUE,ISNUMBER(Q22:$Q$44),0))*1000),(INDEX(Q22:$Q$44,MATCH(TRUE,ISNUMBER(Q22:$Q$44),0))-LOOKUP(99^99,Q$2:Q21))*1000))","v":237000},237000,1,{"$f":"IF(Q22=\"\",\"\",ROUND(OFFSET(S22,MATCH(TRUE,INDEX(S23:S$44<>\"\",0),0),0),0))","v":259000},null,null,"NO READ - A day when a reading was not taken",null,null,null,null,null,null,null,null,null,null,15,420700,null,279000,null,699700]
[16,185227,{"$f":"IF(OR(B23=\"HOL\",B23=\"SUN\",B23=\"SAT\",B23=\"No Read\",B23=\"\"),\"\",IF(INDEX(B23:$B$44,MATCH(TRUE,ISNUMBER(B23:$B$44),0))<LOOKUP(99^99,B$2:B22),(INDEX(B23:$B$44,MATCH(TRUE,ISNUMBER(B23:$B$44),0))*1000),(INDEX(B23:$B$44,MATCH(TRUE,ISNUMBER(B23:$B$44),0))-LOOKUP(99^99,B$2:B22))*1000))","v":82000},{"$f":"IF(OR(B23=\"HOL\",B23=\"SUN\",B23=\"SAT\",B23=\"No Read\",B23=\"\"),\"\",ROUND(C23/E22,1))","v":82000},1,{"$f":"IF(B23=\"\",\"\",ROUND(OFFSET(D23,MATCH(TRUE,INDEX(D24:D$44<>\"\",0),0),0),0))","v":63000},2667748,{"$f":"IF(OR(G23=\"HOL\",G23=\"SUN\",G23=\"SAT\",G23=\"No Read\",G23=\"\"),\"\",IF(INDEX(G23:$G$44,MATCH(TRUE,ISNUMBER(G23:$G$44),0))<LOOKUP(99^99,G$2:G22),(INDEX(G23:$G$44,MATCH(TRUE,ISNUMBER(G23:$G$44),0))*100),(INDEX(G23:$G$44,MATCH(TRUE,ISNUMBER(G23:$G$44),0))-LOOKUP(99^99,G$2:G22))*100))","v":161700},{"$f":"IF(OR(G23=\"HOL\",G23=\"SUN\",G23=\"SAT\",G23=\"No Read\",G23=\"\"),\"\",ROUND(H23/J22,1))","v":161700},1,{"$f":"IF(G23=\"\",\"\",ROUND(OFFSET(I23,MATCH(TRUE,INDEX(I24:I$44<>\"\",0),0),0),0))","v":158700},282809,{"$f":"IF(OR(L23=\"HOL\",L23=\"SUN\",L23=\"SAT\",L23=\"No Read\",L23=\"\"),\"\",IF(INDEX(L23:$L$44,MATCH(TRUE,ISNUMBER(L23:$L$44),0))<LOOKUP(99^99,L$2:L22),(INDEX(L23:$L$44,MATCH(TRUE,ISNUMBER(L23:$L$44),0))*1000),(INDEX(L23:$L$44,MATCH(TRUE,ISNUMBER(L23:$L$44),0))-LOOKUP(99^99,L$2:L22))*1000))","v":112000},{"$f":"IF(OR(L23=\"HOL\",L23=\"SUN\",L23=\"SAT\",L23=\"No Read\",L23=\"\"),\"\",ROUND(M23/O22,1))","v":112000},1,{"$f":"IF(L23=\"\",\"\",ROUND(OFFSET(N23,MATCH(TRUE,INDEX(N24:N$44<>\"\",0),0),0),0))","v":84000},1923715,{"$f":"IF(OR(Q23=\"HOL\",Q23=\"SUN\",Q23=\"SAT\",Q23=\"No Read\",Q23=\"\"),\"\",IF(INDEX(Q23:$Q$44,MATCH(TRUE,ISNUMBER(Q23:$Q$44),0))<LOOKUP(99^99,Q$2:Q22),(INDEX(Q23:$Q$44,MATCH(TRUE,ISNUMBER(Q23:$Q$44),0))*1000),(INDEX(Q23:$Q$44,MATCH(TRUE,ISNUMBER(Q23:$Q$44),0))-LOOKUP(99^99,Q$2:Q22))*1000))","v":259000},{"$f":"IF(OR(Q23=\"HOL\",Q23=\"SUN\",Q23=\"SAT\",Q23=\"No Read\",Q23=\"\"),\"\",ROUND(R23/T22,1))","v":259000},1,{"$f":"IF(Q23=\"\",\"\",ROUND(OFFSET(S23,MATCH(TRUE,INDEX(S24:S$44<>\"\",0),0),0),0))","v":254000},null,null,null,null,null,null,null,null,null,null,null,null,null,16,412700,null,279000,null,691700]
[17,185290,{"$f":"IF(OR(B24=\"HOL\",B24=\"SUN\",B24=\"SAT\",B24=\"No Read\",B24=\"\"),\"\",IF(INDEX(B24:$B$44,MATCH(TRUE,ISNUMBER(B24:$B$44),0))<LOOKUP(99^99,B$2:B23),(INDEX(B24:$B$44,MATCH(TRUE,ISNUMBER(B24:$B$44),0))*1000),(INDEX(B24:$B$44,MATCH(TRUE,ISNUMBER(B24:$B$44),0))-LOOKUP(99^99,B$2:B23))*1000))","v":63000},{"$f":"IF(OR(B24=\"HOL\",B24=\"SUN\",B24=\"SAT\",B24=\"No Read\",B24=\"\"),\"\",ROUND(C24/E23,1))","v":63000},1,{"$f":"IF(B24=\"\",\"\",ROUND(OFFSET(D24,MATCH(TRUE,INDEX(D25:D$44<>\"\",0),0),0),0))","v":102000},2669335,{"$f":"IF(OR(G24=\"HOL\",G24=\"SUN\",G24=\"SAT\",G24=\"No Read\",G24=\"\"),\"\",IF(INDEX(G24:$G$44,MATCH(TRUE,ISNUMBER(G24:$G$44),0))<LOOKUP(99^99,G$2:G23),(INDEX(G24:$G$44,MATCH(TRUE,ISNUMBER(G24:$G$44),0))*100),(INDEX(G24:$G$44,MATCH(TRUE,ISNUMBER(G24:$G$44),0))-LOOKUP(99^99,G$2:G23))*100))","v":158700},{"$f":"IF(OR(G24=\"HOL\",G24=\"SUN\",G24=\"SAT\",G24=\"No Read\",G24=\"\"),\"\",ROUND(H24/J23,1))","v":158700},1,{"$f":"IF(G24=\"\",\"\",ROUND(OFFSET(I24,MATCH(TRUE,INDEX(I25:I$44<>\"\",0),0),0),0))","v":165300},282893,{"$f":"IF(OR(L24=\"HOL\",L24=\"SUN\",L24=\"SAT\",L24=\"No Read\",L24=\"\"),\"\",IF(INDEX(L24:$L$44,MATCH(TRUE,ISNUMBER(L24:$L$44),0))<LOOKUP(99^99,L$2:L23),(INDEX(L24:$L$44,MATCH(TRUE,ISNUMBER(L24:$L$44),0))*1000),(INDEX(L24:$L$44,MATCH(TRUE,ISNUMBER(L24:$L$44),0))-LOOKUP(99^99,L$2:L23))*1000))","v":84000},{"$f":"IF(OR(L24=\"HOL\",L24=\"SUN\",L24=\"SAT\",L24=\"No Read\",L24=\"\"),\"\",ROUND(M24/O23,1))","v":84000},1,{"$f":"IF(L24=\"\",\"\",ROUND(OFFSET(N24,MATCH(TRUE,INDEX(N25:N$44<>\"\",0),0),0),0))","v":133000},1923969,{"$f":"IF(OR(Q24=\"HOL\",Q24=\"SUN\",Q24=\"SAT\",Q24=\"No Read\",Q24=\"\"),\"\",IF(INDEX(Q24:$Q$44,MATCH(TRUE,ISNUMBER(Q24:$Q$44),0))<LOOKUP(99^99,Q$2:Q23),(INDEX(Q24:$Q$44,MATCH(TRUE,ISNUMBER(Q24:$Q$44),0))*1000),(INDEX(Q24:$Q$44,MATCH(TRUE,ISNUMBER(Q24:$Q$44),0))-LOOKUP(99^99,Q$2:Q23))*1000))","v":254000},{"$f":"IF(OR(Q24=\"HOL\",Q24=\"SUN\",Q24=\"SAT\",Q24=\"No Read\",Q24=\"\"),\"\",ROUND(R24/T23,1))","v":254000},1,{"$f":"IF(Q24=\"\",\"\",ROUND(OFFSET(S24,MATCH(TRUE,INDEX(S25:S$44<>\"\",0),0),0),0))","v":260000},null,null,null,null,null,null,null,null,null,null,null,null,null,17,425300,null,378000,null,803300]
[18,185392,{"$f":"IF(OR(B25=\"HOL\",B25=\"SUN\",B25=\"SAT\",B25=\"No Read\",B25=\"\"),\"\",IF(INDEX(B25:$B$44,MATCH(TRUE,ISNUMBER(B25:$B$44),0))<LOOKUP(99^99,B$2:B24),(INDEX(B25:$B$44,MATCH(TRUE,ISNUMBER(B25:$B$44),0))*1000),(INDEX(B25:$B$44,MATCH(TRUE,ISNUMBER(B25:$B$44),0))-LOOKUP(99^99,B$2:B24))*1000))","v":102000},102000,1,{"$f":"IF(B25=\"\",\"\",ROUND(OFFSET(D25,MATCH(TRUE,INDEX(D26:D$44<>\"\",0),0),0),0))","v":60000},2670988,{"$f":"IF(OR(G25=\"HOL\",G25=\"SUN\",G25=\"SAT\",G25=\"No Read\",G25=\"\"),\"\",IF(INDEX(G25:$G$44,MATCH(TRUE,ISNUMBER(G25:$G$44),0))<LOOKUP(99^99,G$2:G24),(INDEX(G25:$G$44,MATCH(TRUE,ISNUMBER(G25:$G$44),0))*100),(INDEX(G25:$G$44,MATCH(TRUE,ISNUMBER(G25:$G$44),0))-LOOKUP(99^99,G$2:G24))*100))","v":165300},165300,1,{"$f":"IF(G25=\"\",\"\",ROUND(OFFSET(I25,MATCH(TRUE,INDEX(I26:I$44<>\"\",0),0),0),0))","v":167400},283026,{"$f":"IF(OR(L25=\"HOL\",L25=\"SUN\",L25=\"SAT\",L25=\"No Read\",L25=\"\"),\"\",IF(INDEX(L25:$L$44,MATCH(TRUE,ISNUMBER(L25:$L$44),0))<LOOKUP(99^99,L$2:L24),(INDEX(L25:$L$44,MATCH(TRUE,ISNUMBER(L25:$L$44),0))*1000),(INDEX(L25:$L$44,MATCH(TRUE,ISNUMBER(L25:$L$44),0))-LOOKUP(99^99,L$2:L24))*1000))","v":133000},133000,1,{"$f":"IF(L25=\"\",\"\",ROUND(OFFSET(N25,MATCH(TRUE,INDEX(N26:N$44<>\"\",0),0),0),0))","v":83000},1924229,{"$f":"IF(OR(Q25=\"HOL\",Q25=\"SUN\",Q25=\"SAT\",Q25=\"No Read\",Q25=\"\"),\"\",IF(INDEX(Q25:$Q$44,MATCH(TRUE,ISNUMBER(Q25:$Q$44),0))<LOOKUP(99^99,Q$2:Q24),(INDEX(Q25:$Q$44,MATCH(TRUE,ISNUMBER(Q25:$Q$44),0))*1000),(INDEX(Q25:$Q$44,MATCH(TRUE,ISNUMBER(Q25:$Q$44),0))-LOOKUP(99^99,Q$2:Q24))*1000))","v":260000},260000,1,{"$f":"IF(Q25=\"\",\"\",ROUND(OFFSET(S25,MATCH(TRUE,INDEX(S26:S$44<>\"\",0),0),0),0))","v":261000},null,null,"Cl2 used",null,null,null,null,null,null,null,null,null,null,18,428400,null,209000,null,637400]
[19,185452,{"$f":"IF(OR(B26=\"HOL\",B26=\"SUN\",B26=\"SAT\",B26=\"No Read\",B26=\"\"),\"\",IF(INDEX(B26:$B$44,MATCH(TRUE,ISNUMBER(B26:$B$44),0))<LOOKUP(99^99,B$2:B25),(INDEX(B26:$B$44,MATCH(TRUE,ISNUMBER(B26:$B$44),0))*1000),(INDEX(B26:$B$44,MATCH(TRUE,ISNUMBER(B26:$B$44),0))-LOOKUP(99^99,B$2:B25))*1000))","v":60000},60000,1,{"$f":"IF(B26=\"\",\"\",ROUND(OFFSET(D26,MATCH(TRUE,INDEX(D27:D$44<>\"\",0),0),0),0))","v":61000},2672662,{"$f":"IF(OR(G26=\"HOL\",G26=\"SUN\",G26=\"SAT\",G26=\"No Read\",G26=\"\"),\"\",IF(INDEX(G26:$G$44,MATCH(TRUE,ISNUMBER(G26:$G$44),0))<LOOKUP(99^99,G$2:G25),(INDEX(G26:$G$44,MATCH(TRUE,ISNUMBER(G26:$G$44),0))*100),(INDEX(G26:$G$44,MATCH(TRUE,ISNUMBER(G26:$G$44),0))-LOOKUP(99^99,G$2:G25))*100))","v":167400},167400,1,{"$f":"IF(G26=\"\",\"\",ROUND(OFFSET(I26,MATCH(TRUE,INDEX(I27:I$44<>\"\",0),0),0),0))","v":160800},283109,{"$f":"IF(OR(L26=\"HOL\",L26=\"SUN\",L26=\"SAT\",L26=\"No Read\",L26=\"\"),\"\",IF(INDEX(L26:$L$44,MATCH(TRUE,ISNUMBER(L26:$L$44),0))<LOOKUP(99^99,L$2:L25),(INDEX(L26:$L$44,MATCH(TRUE,ISNUMBER(L26:$L$44),0))*1000),(INDEX(L26:$L$44,MATCH(TRUE,ISNUMBER(L26:$L$44),0))-LOOKUP(99^99,L$2:L25))*1000))","v":83000},83000,1,{"$f":"IF(L26=\"\",\"\",ROUND(OFFSET(N26,MATCH(TRUE,INDEX(N27:N$44<>\"\",0),0),0),0))","v":81000},1924490,{"$f":"IF(OR(Q26=\"HOL\",Q26=\"SUN\",Q26=\"SAT\",Q26=\"No Read\",Q26=\"\"),\"\",IF(INDEX(Q26:$Q$44,MATCH(TRUE,ISNUMBER(Q26:$Q$44),0))<LOOKUP(99^99,Q$2:Q25),(INDEX(Q26:$Q$44,MATCH(TRUE,ISNUMBER(Q26:$Q$44),0))*1000),(INDEX(Q26:$Q$44,MATCH(TRUE,ISNUMBER(Q26:$Q$44),0))-LOOKUP(99^99,Q$2:Q25))*1000))","v":261000},261000,1,{"$f":"IF(Q26=\"\",\"\",ROUND(OFFSET(S26,MATCH(TRUE,INDEX(S27:S$44<>\"\",0),0),0),0))","v":253000},null,null,"Beginning",null,"Ending",null,null,null,null,null,null,null,null,19,413800,null,91000,null,504800]
[20,185513,{"$f":"IF(OR(B27=\"HOL\",B27=\"SUN\",B27=\"SAT\",B27=\"No Read\",B27=\"\"),\"\",IF(INDEX(B27:$B$44,MATCH(TRUE,ISNUMBER(B27:$B$44),0))<LOOKUP(99^99,B$2:B26),(INDEX(B27:$B$44,MATCH(TRUE,ISNUMBER(B27:$B$44),0))*1000),(INDEX(B27:$B$44,MATCH(TRUE,ISNUMBER(B27:$B$44),0))-LOOKUP(99^99,B$2:B26))*1000))","v":61000},61000,1,{"$f":"IF(B27=\"\",\"\",ROUND(OFFSET(D27,MATCH(TRUE,INDEX(D28:D$44<>\"\",0),0),0),0))","v":143000},2674270,{"$f":"IF(OR(G27=\"HOL\",G27=\"SUN\",G27=\"SAT\",G27=\"No Read\",G27=\"\"),\"\",IF(INDEX(G27:$G$44,MATCH(TRUE,ISNUMBER(G27:$G$44),0))<LOOKUP(99^99,G$2:G26),(INDEX(G27:$G$44,MATCH(TRUE,ISNUMBER(G27:$G$44),0))*100),(INDEX(G27:$G$44,MATCH(TRUE,ISNUMBER(G27:$G$44),0))-LOOKUP(99^99,G$2:G26))*100))","v":160800},160800,1,{"$f":"IF(G27=\"\",\"\",ROUND(OFFSET(I27,MATCH(TRUE,INDEX(I28:I$44<>\"\",0),0),0),0))","v":151600},283190,{"$f":"IF(OR(L27=\"HOL\",L27=\"SUN\",L27=\"SAT\",L27=\"No Read\",L27=\"\"),\"\",IF(INDEX(L27:$L$44,MATCH(TRUE,ISNUMBER(L27:$L$44),0))<LOOKUP(99^99,L$2:L26),(INDEX(L27:$L$44,MATCH(TRUE,ISNUMBER(L27:$L$44),0))*1000),(INDEX(L27:$L$44,MATCH(TRUE,ISNUMBER(L27:$L$44),0))-LOOKUP(99^99,L$2:L26))*1000))","v":81000},81000,1,{"$f":"IF(L27=\"\",\"\",ROUND(OFFSET(N27,MATCH(TRUE,INDEX(N28:N$44<>\"\",0),0),0),0))","v":202000},1924743,{"$f":"IF(OR(Q27=\"HOL\",Q27=\"SUN\",Q27=\"SAT\",Q27=\"No Read\",Q27=\"\"),\"\",IF(INDEX(Q27:$Q$44,MATCH(TRUE,ISNUMBER(Q27:$Q$44),0))<LOOKUP(99^99,Q$2:Q26),(INDEX(Q27:$Q$44,MATCH(TRUE,ISNUMBER(Q27:$Q$44),0))*1000),(INDEX(Q27:$Q$44,MATCH(TRUE,ISNUMBER(Q27:$Q$44),0))-LOOKUP(99^99,Q$2:Q26))*1000))","v":253000},253000,1,{"$f":"IF(Q27=\"\",\"\",ROUND(OFFSET(S27,MATCH(TRUE,INDEX(S28:S$44<>\"\",0),0),0),0))","v":219000},null,null,450,null,220,null,null,null,null,null,null,null,null,20,370600,null,65000,null,435600]
[21,185656,{"$f":"IF(OR(B28=\"HOL\",B28=\"SUN\",B28=\"SAT\",B28=\"No Read\",B28=\"\"),\"\",IF(INDEX(B28:$B$44,MATCH(TRUE,ISNUMBER(B28:$B$44),0))<LOOKUP(99^99,B$2:B27),(INDEX(B28:$B$44,MATCH(TRUE,ISNUMBER(B28:$B$44),0))*1000),(INDEX(B28:$B$44,MATCH(TRUE,ISNUMBER(B28:$B$44),0))-LOOKUP(99^99,B$2:B27))*1000))","v":143000},143000,1,{"$f":"IF(B28=\"\",\"\",ROUND(OFFSET(D28,MATCH(TRUE,INDEX(D29:D$44<>\"\",0),0),0),0))","v":26000},2675786,{"$f":"IF(OR(G28=\"HOL\",G28=\"SUN\",G28=\"SAT\",G28=\"No Read\",G28=\"\"),\"\",IF(INDEX(G28:$G$44,MATCH(TRUE,ISNUMBER(G28:$G$44),0))<LOOKUP(99^99,G$2:G27),(INDEX(G28:$G$44,MATCH(TRUE,ISNUMBER(G28:$G$44),0))*100),(INDEX(G28:$G$44,MATCH(TRUE,ISNUMBER(G28:$G$44),0))-LOOKUP(99^99,G$2:G27))*100))","v":151600},151600,1,{"$f":"IF(G28=\"\",\"\",ROUND(OFFSET(I28,MATCH(TRUE,INDEX(I29:I$44<>\"\",0),0),0),0))","v":157400},283392,{"$f":"IF(OR(L28=\"HOL\",L28=\"SUN\",L28=\"SAT\",L28=\"No Read\",L28=\"\"),\"\",IF(INDEX(L28:$L$44,MATCH(TRUE,ISNUMBER(L28:$L$44),0))<LOOKUP(99^99,L$2:L27),(INDEX(L28:$L$44,MATCH(TRUE,ISNUMBER(L28:$L$44),0))*1000),(INDEX(L28:$L$44,MATCH(TRUE,ISNUMBER(L28:$L$44),0))-LOOKUP(99^99,L$2:L27))*1000))","v":202000},202000,1,{"$f":"IF(L28=\"\",\"\",ROUND(OFFSET(N28,MATCH(TRUE,INDEX(N29:N$44<>\"\",0),0),0),0))","v":28000},1924962,{"$f":"IF(OR(Q28=\"HOL\",Q28=\"SUN\",Q28=\"SAT\",Q28=\"No Read\",Q28=\"\"),\"\",IF(INDEX(Q28:$Q$44,MATCH(TRUE,ISNUMBER(Q28:$Q$44),0))<LOOKUP(99^99,Q$2:Q27),(INDEX(Q28:$Q$44,MATCH(TRUE,ISNUMBER(Q28:$Q$44),0))*1000),(INDEX(Q28:$Q$44,MATCH(TRUE,ISNUMBER(Q28:$Q$44),0))-LOOKUP(99^99,Q$2:Q27))*1000))","v":219000},219000,1,{"$f":"IF(Q28=\"\",\"\",ROUND(OFFSET(S28,MATCH(TRUE,INDEX(S29:S$44<>\"\",0),0),0),0))","v":202000},null,null,null,null,null,null,null,null,null,null,null,null,null,21,359400,null,56000,null,415400]
[22,185682,{"$f":"IF(OR(B29=\"HOL\",B29=\"SUN\",B29=\"SAT\",B29=\"No Read\",B29=\"\"),\"\",IF(INDEX(B29:$B$44,MATCH(TRUE,ISNUMBER(B29:$B$44),0))<LOOKUP(99^99,B$2:B28),(INDEX(B29:$B$44,MATCH(TRUE,ISNUMBER(B29:$B$44),0))*1000),(INDEX(B29:$B$44,MATCH(TRUE,ISNUMBER(B29:$B$44),0))-LOOKUP(99^99,B$2:B28))*1000))","v":26000},26000,1,{"$f":"IF(B29=\"\",\"\",ROUND(OFFSET(D29,MATCH(TRUE,INDEX(D30:D$44<>\"\",0),0),0),0))","v":72000},2677360,{"$f":"IF(OR(G29=\"HOL\",G29=\"SUN\",G29=\"SAT\",G29=\"No Read\",G29=\"\"),\"\",IF(INDEX(G29:$G$44,MATCH(TRUE,ISNUMBER(G29:$G$44),0))<LOOKUP(99^99,G$2:G28),(INDEX(G29:$G$44,MATCH(TRUE,ISNUMBER(G29:$G$44),0))*100),(INDEX(G29:$G$44,MATCH(TRUE,ISNUMBER(G29:$G$44),0))-LOOKUP(99^99,G$2:G28))*100))","v":157400},157400,1,{"$f":"IF(G29=\"\",\"\",ROUND(OFFSET(I29,MATCH(TRUE,INDEX(I30:I$44<>\"\",0),0),0),0))","v":160400},283420,{"$f":"IF(OR(L29=\"HOL\",L29=\"SUN\",L29=\"SAT\",L29=\"No Read\",L29=\"\"),\"\",IF(INDEX(L29:$L$44,MATCH(TRUE,ISNUMBER(L29:$L$44),0))<LOOKUP(99^99,L$2:L28),(INDEX(L29:$L$44,MATCH(TRUE,ISNUMBER(L29:$L$44),0))*1000),(INDEX(L29:$L$44,MATCH(TRUE,ISNUMBER(L29:$L$44),0))-LOOKUP(99^99,L$2:L28))*1000))","v":28000},28000,1,{"$f":"IF(L29=\"\",\"\",ROUND(OFFSET(N29,MATCH(TRUE,INDEX(N30:N$44<>\"\",0),0),0),0))","v":98000},1925164,{"$f":"IF(OR(Q29=\"HOL\",Q29=\"SUN\",Q29=\"SAT\",Q29=\"No Read\",Q29=\"\"),\"\",IF(INDEX(Q29:$Q$44,MATCH(TRUE,ISNUMBER(Q29:$Q$44),0))<LOOKUP(99^99,Q$2:Q28),(INDEX(Q29:$Q$44,MATCH(TRUE,ISNUMBER(Q29:$Q$44),0))*1000),(INDEX(Q29:$Q$44,MATCH(TRUE,ISNUMBER(Q29:$Q$44),0))-LOOKUP(99^99,Q$2:Q28))*1000))","v":202000},202000,1,{"$f":"IF(Q29=\"\",\"\",ROUND(OFFSET(S29,MATCH(TRUE,INDEX(S30:S$44<>\"\",0),0),0),0))","v":202000},null,null,"Month Total:",{"$f":"X27-Z27+X28-Z28","v":230},null,"Gallons",null,null,null,null,null,null,null,22,362400,null,64000,null,426400]
[23,185754,{"$f":"IF(OR(B30=\"HOL\",B30=\"SUN\",B30=\"SAT\",B30=\"No Read\",B30=\"\"),\"\",IF(INDEX(B30:$B$44,MATCH(TRUE,ISNUMBER(B30:$B$44),0))<LOOKUP(99^99,B$2:B29),(INDEX(B30:$B$44,MATCH(TRUE,ISNUMBER(B30:$B$44),0))*1000),(INDEX(B30:$B$44,MATCH(TRUE,ISNUMBER(B30:$B$44),0))-LOOKUP(99^99,B$2:B29))*1000))","v":72000},72000,1,{"$f":"IF(B30=\"\",\"\",ROUND(OFFSET(D30,MATCH(TRUE,INDEX(D31:D$44<>\"\",0),0),0),0))","v":53000},2678964,{"$f":"IF(OR(G30=\"HOL\",G30=\"SUN\",G30=\"SAT\",G30=\"No Read\",G30=\"\"),\"\",IF(INDEX(G30:$G$44,MATCH(TRUE,ISNUMBER(G30:$G$44),0))<LOOKUP(99^99,G$2:G29),(INDEX(G30:$G$44,MATCH(TRUE,ISNUMBER(G30:$G$44),0))*100),(INDEX(G30:$G$44,MATCH(TRUE,ISNUMBER(G30:$G$44),0))-LOOKUP(99^99,G$2:G29))*100))","v":160400},160400,1,{"$f":"IF(G30=\"\",\"\",ROUND(OFFSET(I30,MATCH(TRUE,INDEX(I31:I$44<>\"\",0),0),0),0))","v":164000},283518,{"$f":"IF(OR(L30=\"HOL\",L30=\"SUN\",L30=\"SAT\",L30=\"No Read\",L30=\"\"),\"\",IF(INDEX(L30:$L$44,MATCH(TRUE,ISNUMBER(L30:$L$44),0))<LOOKUP(99^99,L$2:L29),(INDEX(L30:$L$44,MATCH(TRUE,ISNUMBER(L30:$L$44),0))*1000),(INDEX(L30:$L$44,MATCH(TRUE,ISNUMBER(L30:$L$44),0))-LOOKUP(99^99,L$2:L29))*1000))","v":98000},98000,1,{"$f":"IF(L30=\"\",\"\",ROUND(OFFSET(N30,MATCH(TRUE,INDEX(N31:N$44<>\"\",0),0),0),0))","v":73000},1925366,{"$f":"IF(OR(Q30=\"HOL\",Q30=\"SUN\",Q30=\"SAT\",Q30=\"No Read\",Q30=\"\"),\"\",IF(INDEX(Q30:$Q$44,MATCH(TRUE,ISNUMBER(Q30:$Q$44),0))<LOOKUP(99^99,Q$2:Q29),(INDEX(Q30:$Q$44,MATCH(TRUE,ISNUMBER(Q30:$Q$44),0))*1000),(INDEX(Q30:$Q$44,MATCH(TRUE,ISNUMBER(Q30:$Q$44),0))-LOOKUP(99^99,Q$2:Q29))*1000))","v":202000},202000,1,{"$f":"IF(Q30=\"\",\"\",ROUND(OFFSET(S30,MATCH(TRUE,INDEX(S31:S$44<>\"\",0),0),0),0))","v":226000},null,null,null,null,null,null,null,null,null,null,null,null,null,23,390000,null,130000,null,520000]
[24,185807,{"$f":"IF(OR(B31=\"HOL\",B31=\"SUN\",B31=\"SAT\",B31=\"No Read\",B31=\"\"),\"\",IF(INDEX(B31:$B$44,MATCH(TRUE,ISNUMBER(B31:$B$44),0))<LOOKUP(99^99,B$2:B30),(INDEX(B31:$B$44,MATCH(TRUE,ISNUMBER(B31:$B$44),0))*1000),(INDEX(B31:$B$44,MATCH(TRUE,ISNUMBER(B31:$B$44),0))-LOOKUP(99^99,B$2:B30))*1000))","v":53000},53000,1,{"$f":"IF(B31=\"\",\"\",ROUND(OFFSET(D31,MATCH(TRUE,INDEX(D32:D$44<>\"\",0),0),0),0))","v":32000},2680604,{"$f":"IF(OR(G31=\"HOL\",G31=\"SUN\",G31=\"SAT\",G31=\"No Read\",G31=\"\"),\"\",IF(INDEX(G31:$G$44,MATCH(TRUE,ISNUMBER(G31:$G$44),0))<LOOKUP(99^99,G$2:G30),(INDEX(G31:$G$44,MATCH(TRUE,ISNUMBER(G31:$G$44),0))*100),(INDEX(G31:$G$44,MATCH(TRUE,ISNUMBER(G31:$G$44),0))-LOOKUP(99^99,G$2:G30))*100))","v":164000},164000,1,{"$f":"IF(G31=\"\",\"\",ROUND(OFFSET(I31,MATCH(TRUE,INDEX(I32:I$44<>\"\",0),0),0),0))","v":155700},283591,{"$f":"IF(OR(L31=\"HOL\",L31=\"SUN\",L31=\"SAT\",L31=\"No Read\",L31=\"\"),\"\",IF(INDEX(L31:$L$44,MATCH(TRUE,ISNUMBER(L31:$L$44),0))<LOOKUP(99^99,L$2:L30),(INDEX(L31:$L$44,MATCH(TRUE,ISNUMBER(L31:$L$44),0))*1000),(INDEX(L31:$L$44,MATCH(TRUE,ISNUMBER(L31:$L$44),0))-LOOKUP(99^99,L$2:L30))*1000))","v":73000},73000,1,{"$f":"IF(L31=\"\",\"\",ROUND(OFFSET(N31,MATCH(TRUE,INDEX(N32:N$44<>\"\",0),0),0),0))","v":42000},1925592,{"$f":"IF(OR(Q31=\"HOL\",Q31=\"SUN\",Q31=\"SAT\",Q31=\"No Read\",Q31=\"\"),\"\",IF(INDEX(Q31:$Q$44,MATCH(TRUE,ISNUMBER(Q31:$Q$44),0))<LOOKUP(99^99,Q$2:Q30),(INDEX(Q31:$Q$44,MATCH(TRUE,ISNUMBER(Q31:$Q$44),0))*1000),(INDEX(Q31:$Q$44,MATCH(TRUE,ISNUMBER(Q31:$Q$44),0))-LOOKUP(99^99,Q$2:Q30))*1000))","v":226000},226000,1,{"$f":"IF(Q31=\"\",\"\",ROUND(OFFSET(S31,MATCH(TRUE,INDEX(S32:S$44<>\"\",0),0),0),0))","v":223000},null,null,null,null,null,null,null,null,null,null,null,null,null,24,378700,null,204000,null,582700]
[25,185839,{"$f":"IF(OR(B32=\"HOL\",B32=\"SUN\",B32=\"SAT\",B32=\"No Read\",B32=\"\"),\"\",IF(INDEX(B32:$B$44,MATCH(TRUE,ISNUMBER(B32:$B$44),0))<LOOKUP(99^99,B$2:B31),(INDEX(B32:$B$44,MATCH(TRUE,ISNUMBER(B32:$B$44),0))*1000),(INDEX(B32:$B$44,MATCH(TRUE,ISNUMBER(B32:$B$44),0))-LOOKUP(99^99,B$2:B31))*1000))","v":32000},32000,1,{"$f":"IF(B32=\"\",\"\",ROUND(OFFSET(D32,MATCH(TRUE,INDEX(D33:D$44<>\"\",0),0),0),0))","v":65000},2682161,{"$f":"IF(OR(G32=\"HOL\",G32=\"SUN\",G32=\"SAT\",G32=\"No Read\",G32=\"\"),\"\",IF(INDEX(G32:$G$44,MATCH(TRUE,ISNUMBER(G32:$G$44),0))<LOOKUP(99^99,G$2:G31),(INDEX(G32:$G$44,MATCH(TRUE,ISNUMBER(G32:$G$44),0))*100),(INDEX(G32:$G$44,MATCH(TRUE,ISNUMBER(G32:$G$44),0))-LOOKUP(99^99,G$2:G31))*100))","v":155700},155700,1,{"$f":"IF(G32=\"\",\"\",ROUND(OFFSET(I32,MATCH(TRUE,INDEX(I33:I$44<>\"\",0),0),0),0))","v":147700},283633,{"$f":"IF(OR(L32=\"HOL\",L32=\"SUN\",L32=\"SAT\",L32=\"No Read\",L32=\"\"),\"\",IF(INDEX(L32:$L$44,MATCH(TRUE,ISNUMBER(L32:$L$44),0))<LOOKUP(99^99,L$2:L31),(INDEX(L32:$L$44,MATCH(TRUE,ISNUMBER(L32:$L$44),0))*1000),(INDEX(L32:$L$44,MATCH(TRUE,ISNUMBER(L32:$L$44),0))-LOOKUP(99^99,L$2:L31))*1000))","v":42000},42000,1,{"$f":"IF(L32=\"\",\"\",ROUND(OFFSET(N32,MATCH(TRUE,INDEX(N33:N$44<>\"\",0),0),0),0))","v":87000},1925815,{"$f":"IF(OR(Q32=\"HOL\",Q32=\"SUN\",Q32=\"SAT\",Q32=\"No Read\",Q32=\"\"),\"\",IF(INDEX(Q32:$Q$44,MATCH(TRUE,ISNUMBER(Q32:$Q$44),0))<LOOKUP(99^99,Q$2:Q31),(INDEX(Q32:$Q$44,MATCH(TRUE,ISNUMBER(Q32:$Q$44),0))*1000),(INDEX(Q32:$Q$44,MATCH(TRUE,ISNUMBER(Q32:$Q$44),0))-LOOKUP(99^99,Q$2:Q31))*1000))","v":223000},223000,1,{"$f":"IF(Q32=\"\",\"\",ROUND(OFFSET(S32,MATCH(TRUE,INDEX(S33:S$44<>\"\",0),0),0),0))","v":240000},null,null,null,null,null,null,null,null,null,null,null,null,null,25,387700,null,255000,null,642700]
[26,185904,{"$f":"IF(OR(B33=\"HOL\",B33=\"SUN\",B33=\"SAT\",B33=\"No Read\",B33=\"\"),\"\",IF(INDEX(B33:$B$44,MATCH(TRUE,ISNUMBER(B33:$B$44),0))<LOOKUP(99^99,B$2:B32),(INDEX(B33:$B$44,MATCH(TRUE,ISNUMBER(B33:$B$44),0))*1000),(INDEX(B33:$B$44,MATCH(TRUE,ISNUMBER(B33:$B$44),0))-LOOKUP(99^99,B$2:B32))*1000))","v":65000},65000,1,{"$f":"IF(B33=\"\",\"\",ROUND(OFFSET(D33,MATCH(TRUE,INDEX(D34:D$44<>\"\",0),0),0),0))","v":67000},2683638,{"$f":"IF(OR(G33=\"HOL\",G33=\"SUN\",G33=\"SAT\",G33=\"No Read\",G33=\"\"),\"\",IF(INDEX(G33:$G$44,MATCH(TRUE,ISNUMBER(G33:$G$44),0))<LOOKUP(99^99,G$2:G32),(INDEX(G33:$G$44,MATCH(TRUE,ISNUMBER(G33:$G$44),0))*100),(INDEX(G33:$G$44,MATCH(TRUE,ISNUMBER(G33:$G$44),0))-LOOKUP(99^99,G$2:G32))*100))","v":147700},147700,1,{"$f":"IF(G33=\"\",\"\",ROUND(OFFSET(I33,MATCH(TRUE,INDEX(I34:I$44<>\"\",0),0),0),0))","v":173800},283720,{"$f":"IF(OR(L33=\"HOL\",L33=\"SUN\",L33=\"SAT\",L33=\"No Read\",L33=\"\"),\"\",IF(INDEX(L33:$L$44,MATCH(TRUE,ISNUMBER(L33:$L$44),0))<LOOKUP(99^99,L$2:L32),(INDEX(L33:$L$44,MATCH(TRUE,ISNUMBER(L33:$L$44),0))*1000),(INDEX(L33:$L$44,MATCH(TRUE,ISNUMBER(L33:$L$44),0))-LOOKUP(99^99,L$2:L32))*1000))","v":87000},87000,1,{"$f":"IF(L33=\"\",\"\",ROUND(OFFSET(N33,MATCH(TRUE,INDEX(N34:N$44<>\"\",0),0),0),0))","v":90000},1926055,{"$f":"IF(OR(Q33=\"HOL\",Q33=\"SUN\",Q33=\"SAT\",Q33=\"No Read\",Q33=\"\"),\"\",IF(INDEX(Q33:$Q$44,MATCH(TRUE,ISNUMBER(Q33:$Q$44),0))<LOOKUP(99^99,Q$2:Q32),(INDEX(Q33:$Q$44,MATCH(TRUE,ISNUMBER(Q33:$Q$44),0))*1000),(INDEX(Q33:$Q$44,MATCH(TRUE,ISNUMBER(Q33:$Q$44),0))-LOOKUP(99^99,Q$2:Q32))*1000))","v":240000},240000,1,{"$f":"IF(Q33=\"\",\"\",ROUND(OFFSET(S33,MATCH(TRUE,INDEX(S34:S$44<>\"\",0),0),0),0))","v":271000},null,null,"Sum of Wells 1-4",null,null,null,null,"Sum of Boosters 1-4",null,null,null,null,null,26,444800,null,186000,null,630800]
[27,185971,{"$f":"IF(OR(B34=\"HOL\",B34=\"SUN\",B34=\"SAT\",B34=\"No Read\",B34=\"\"),\"\",IF(INDEX(B34:$B$44,MATCH(TRUE,ISNUMBER(B34:$B$44),0))<LOOKUP(99^99,B$2:B33),(INDEX(B34:$B$44,MATCH(TRUE,ISNUMBER(B34:$B$44),0))*1000),(INDEX(B34:$B$44,MATCH(TRUE,ISNUMBER(B34:$B$44),0))-LOOKUP(99^99,B$2:B33))*1000))","v":67000},67000,1,{"$f":"IF(B34=\"\",\"\",ROUND(OFFSET(D34,MATCH(TRUE,INDEX(D35:D$44<>\"\",0),0),0),0))","v":75000},2685376,{"$f":"IF(OR(G34=\"HOL\",G34=\"SUN\",G34=\"SAT\",G34=\"No Read\",G34=\"\"),\"\",IF(INDEX(G34:$G$44,MATCH(TRUE,ISNUMBER(G34:$G$44),0))<LOOKUP(99^99,G$2:G33),(INDEX(G34:$G$44,MATCH(TRUE,ISNUMBER(G34:$G$44),0))*100),(INDEX(G34:$G$44,MATCH(TRUE,ISNUMBER(G34:$G$44),0))-LOOKUP(99^99,G$2:G33))*100))","v":173800},173800,1,{"$f":"IF(G34=\"\",\"\",ROUND(OFFSET(I34,MATCH(TRUE,INDEX(I35:I$44<>\"\",0),0),0),0))","v":147600},283810,{"$f":"IF(OR(L34=\"HOL\",L34=\"SUN\",L34=\"SAT\",L34=\"No Read\",L34=\"\"),\"\",IF(INDEX(L34:$L$44,MATCH(TRUE,ISNUMBER(L34:$L$44),0))<LOOKUP(99^99,L$2:L33),(INDEX(L34:$L$44,MATCH(TRUE,ISNUMBER(L34:$L$44),0))*1000),(INDEX(L34:$L$44,MATCH(TRUE,ISNUMBER(L34:$L$44),0))-LOOKUP(99^99,L$2:L33))*1000))","v":90000},90000,1,{"$f":"IF(L34=\"\",\"\",ROUND(OFFSET(N34,MATCH(TRUE,INDEX(N35:N$44<>\"\",0),0),0),0))","v":100000},1926326,{"$f":"IF(OR(Q34=\"HOL\",Q34=\"SUN\",Q34=\"SAT\",Q34=\"No Read\",Q34=\"\"),\"\",IF(INDEX(Q34:$Q$44,MATCH(TRUE,ISNUMBER(Q34:$Q$44),0))<LOOKUP(99^99,Q$2:Q33),(INDEX(Q34:$Q$44,MATCH(TRUE,ISNUMBER(Q34:$Q$44),0))*1000),(INDEX(Q34:$Q$44,MATCH(TRUE,ISNUMBER(Q34:$Q$44),0))-LOOKUP(99^99,Q$2:Q33))*1000))","v":271000},271000,1,{"$f":"IF(Q34=\"\",\"\",ROUND(OFFSET(S34,MATCH(TRUE,INDEX(S35:S$44<>\"\",0),0),0),0))","v":243000},null,null,null,null,null,null,null,null,null,null,null,null,null,27,390600,null,263000,null,653600]
[28,186046,{"$f":"IF(OR(B35=\"HOL\",B35=\"SUN\",B35=\"SAT\",B35=\"No Read\",B35=\"\"),\"\",IF(INDEX(B35:$B$44,MATCH(TRUE,ISNUMBER(B35:$B$44),0))<LOOKUP(99^99,B$2:B34),(INDEX(B35:$B$44,MATCH(TRUE,ISNUMBER(B35:$B$44),0))*1000),(INDEX(B35:$B$44,MATCH(TRUE,ISNUMBER(B35:$B$44),0))-LOOKUP(99^99,B$2:B34))*1000))","v":75000},75000,1,{"$f":"IF(B35=\"\",\"\",ROUND(OFFSET(D35,MATCH(TRUE,INDEX(D36:D$44<>\"\",0),0),0),0))","v":85000},2686852,{"$f":"IF(OR(G35=\"HOL\",G35=\"SUN\",G35=\"SAT\",G35=\"No Read\",G35=\"\"),\"\",IF(INDEX(G35:$G$44,MATCH(TRUE,ISNUMBER(G35:$G$44),0))<LOOKUP(99^99,G$2:G34),(INDEX(G35:$G$44,MATCH(TRUE,ISNUMBER(G35:$G$44),0))*100),(INDEX(G35:$G$44,MATCH(TRUE,ISNUMBER(G35:$G$44),0))-LOOKUP(99^99,G$2:G34))*100))","v":147600},147600,1,{"$f":"IF(G35=\"\",\"\",ROUND(OFFSET(I35,MATCH(TRUE,INDEX(I36:I$44<>\"\",0),0),0),0))","v":160800},283910,{"$f":"IF(OR(L35=\"HOL\",L35=\"SUN\",L35=\"SAT\",L35=\"No Read\",L35=\"\"),\"\",IF(INDEX(L35:$L$44,MATCH(TRUE,ISNUMBER(L35:$L$44),0))<LOOKUP(99^99,L$2:L34),(INDEX(L35:$L$44,MATCH(TRUE,ISNUMBER(L35:$L$44),0))*1000),(INDEX(L35:$L$44,MATCH(TRUE,ISNUMBER(L35:$L$44),0))-LOOKUP(99^99,L$2:L34))*1000))","v":100000},100000,1,{"$f":"IF(L35=\"\",\"\",ROUND(OFFSET(N35,MATCH(TRUE,INDEX(N36:N$44<>\"\",0),0),0),0))","v":115000},1926569,{"$f":"IF(OR(Q35=\"HOL\",Q35=\"SUN\",Q35=\"SAT\",Q35=\"No Read\",Q35=\"\"),\"\",IF(INDEX(Q35:$Q$44,MATCH(TRUE,ISNUMBER(Q35:$Q$44),0))<LOOKUP(99^99,Q$2:Q34),(INDEX(Q35:$Q$44,MATCH(TRUE,ISNUMBER(Q35:$Q$44),0))*1000),(INDEX(Q35:$Q$44,MATCH(TRUE,ISNUMBER(Q35:$Q$44),0))-LOOKUP(99^99,Q$2:Q34))*1000))","v":243000},243000,1,{"$f":"IF(Q35=\"\",\"\",ROUND(OFFSET(S35,MATCH(TRUE,INDEX(S36:S$44<>\"\",0),0),0),0))","v":259000},null,null,{"$f":"SUM('3 & 4'!F39,'3 & 4'!P39,F39,P39)","v":20638292},null,null,"Gallons",null,{"$f":"SUM('3 & 4'!K39,'3 & 4'!U39,'1 & 2'!K39,'1 & 2'!U39)","v":20327700},null,null,"Gallons",null,null,28,419800,null,233000,null,652800]
[29,186131,{"$f":"IF(OR(B36=\"HOL\",B36=\"SUN\",B36=\"SAT\",B36=\"No Read\",B36=\"\"),\"\",IF(INDEX(B36:$B$44,MATCH(TRUE,ISNUMBER(B36:$B$44),0))<LOOKUP(99^99,B$2:B35),(INDEX(B36:$B$44,MATCH(TRUE,ISNUMBER(B36:$B$44),0))*1000),(INDEX(B36:$B$44,MATCH(TRUE,ISNUMBER(B36:$B$44),0))-LOOKUP(99^99,B$2:B35))*1000))","v":85000},85000,{"$f":"IF(B36=\"\",E35,IF(C36=\"\",IF(E35>0,E35+1,1),1))","v":1},{"$f":"IF(B36=\"\",\"\",ROUND(OFFSET(D36,MATCH(TRUE,INDEX(D37:D$44<>\"\",0),0),0),0))","v":81000},2688460,{"$f":"IF(OR(G36=\"HOL\",G36=\"SUN\",G36=\"SAT\",G36=\"No Read\",G36=\"\"),\"\",IF(INDEX(G36:$G$44,MATCH(TRUE,ISNUMBER(G36:$G$44),0))<LOOKUP(99^99,G$2:G35),(INDEX(G36:$G$44,MATCH(TRUE,ISNUMBER(G36:$G$44),0))*100),(INDEX(G36:$G$44,MATCH(TRUE,ISNUMBER(G36:$G$44),0))-LOOKUP(99^99,G$2:G35))*100))","v":160800},160800,{"$f":"IF(G36=\"\",J35,IF(H36=\"\",IF(J35>0,J35+1,1),1))","v":1},{"$f":"IF(G36=\"\",\"\",ROUND(OFFSET(I36,MATCH(TRUE,INDEX(I37:I$44<>\"\",0),0),0),0))","v":160100},284025,{"$f":"IF(OR(L36=\"HOL\",L36=\"SUN\",L36=\"SAT\",L36=\"No Read\",L36=\"\"),\"\",IF(INDEX(L36:$L$44,MATCH(TRUE,ISNUMBER(L36:$L$44),0))<LOOKUP(99^99,L$2:L35),(INDEX(L36:$L$44,MATCH(TRUE,ISNUMBER(L36:$L$44),0))*1000),(INDEX(L36:$L$44,MATCH(TRUE,ISNUMBER(L36:$L$44),0))-LOOKUP(99^99,L$2:L35))*1000))","v":115000},115000,{"$f":"IF(L36=\"\",O35,IF(M36=\"\",IF(O35>0,O35+1,1),1))","v":1},{"$f":"IF(L36=\"\",\"\",ROUND(OFFSET(N36,MATCH(TRUE,INDEX(N37:N$44<>\"\",0),0),0),0))","v":113000},1926828,{"$f":"IF(OR(Q36=\"HOL\",Q36=\"SUN\",Q36=\"SAT\",Q36=\"No Read\",Q36=\"\"),\"\",IF(INDEX(Q36:$Q$44,MATCH(TRUE,ISNUMBER(Q36:$Q$44),0))<LOOKUP(99^99,Q$2:Q35),(INDEX(Q36:$Q$44,MATCH(TRUE,ISNUMBER(Q36:$Q$44),0))*1000),(INDEX(Q36:$Q$44,MATCH(TRUE,ISNUMBER(Q36:$Q$44),0))-LOOKUP(99^99,Q$2:Q35))*1000))","v":259000},259000,{"$f":"IF(Q36=\"\",T35,IF(R36=\"\",IF(T35>0,T35+1,1),1))","v":1},{"$f":"IF(Q36=\"\",\"\",ROUND(OFFSET(S36,MATCH(TRUE,INDEX(S37:S$44<>\"\",0),0),0),0))","v":242000},null,null,null,null,null,null,null,null,null,null,null,null,null,29,402100,null,209000,null,611100]
[30,186212,{"$f":"IF(OR(B37=\"HOL\",B37=\"SUN\",B37=\"SAT\",B37=\"No Read\",B37=\"\"),\"\",IF(INDEX(B37:$B$44,MATCH(TRUE,ISNUMBER(B37:$B$44),0))<LOOKUP(99^99,B$2:B36),(INDEX(B37:$B$44,MATCH(TRUE,ISNUMBER(B37:$B$44),0))*1000),(INDEX(B37:$B$44,MATCH(TRUE,ISNUMBER(B37:$B$44),0))-LOOKUP(99^99,B$2:B36))*1000))","v":81000},81000,{"$f":"IF(B37=\"\",E36,IF(C37=\"\",IF(E36>0,E36+1,1),1))","v":1},{"$f":"IF(B37=\"\",\"\",ROUND(OFFSET(D37,MATCH(TRUE,INDEX(D38:D$44<>\"\",0),0),0),0))","v":82000},2690061,{"$f":"IF(OR(G37=\"HOL\",G37=\"SUN\",G37=\"SAT\",G37=\"No Read\",G37=\"\"),\"\",IF(INDEX(G37:$G$44,MATCH(TRUE,ISNUMBER(G37:$G$44),0))<LOOKUP(99^99,G$2:G36),(INDEX(G37:$G$44,MATCH(TRUE,ISNUMBER(G37:$G$44),0))*100),(INDEX(G37:$G$44,MATCH(TRUE,ISNUMBER(G37:$G$44),0))-LOOKUP(99^99,G$2:G36))*100))","v":160100},160100,{"$f":"IF(G37=\"\",J36,IF(H37=\"\",IF(J36>0,J36+1,1),1))","v":1},{"$f":"IF(G37=\"\",\"\",ROUND(OFFSET(I37,MATCH(TRUE,INDEX(I38:I$44<>\"\",0),0),0),0))","v":160200},284138,{"$f":"IF(OR(L37=\"HOL\",L37=\"SUN\",L37=\"SAT\",L37=\"No Read\",L37=\"\"),\"\",IF(INDEX(L37:$L$44,MATCH(TRUE,ISNUMBER(L37:$L$44),0))<LOOKUP(99^99,L$2:L36),(INDEX(L37:$L$44,MATCH(TRUE,ISNUMBER(L37:$L$44),0))*1000),(INDEX(L37:$L$44,MATCH(TRUE,ISNUMBER(L37:$L$44),0))-LOOKUP(99^99,L$2:L36))*1000))","v":113000},113000,{"$f":"IF(L37=\"\",O36,IF(M37=\"\",IF(O36>0,O36+1,1),1))","v":1},{"$f":"IF(L37=\"\",\"\",ROUND(OFFSET(N37,MATCH(TRUE,INDEX(N38:N$44<>\"\",0),0),0),0))","v":111000},1927070,{"$f":"IF(OR(Q37=\"HOL\",Q37=\"SUN\",Q37=\"SAT\",Q37=\"No Read\",Q37=\"\"),\"\",IF(INDEX(Q37:$Q$44,MATCH(TRUE,ISNUMBER(Q37:$Q$44),0))<LOOKUP(99^99,Q$2:Q36),(INDEX(Q37:$Q$44,MATCH(TRUE,ISNUMBER(Q37:$Q$44),0))*1000),(INDEX(Q37:$Q$44,MATCH(TRUE,ISNUMBER(Q37:$Q$44),0))-LOOKUP(99^99,Q$2:Q36))*1000))","v":242000},242000,{"$f":"IF(Q37=\"\",T36,IF(R37=\"\",IF(T36>0,T36+1,1),1))","v":1},{"$f":"IF(Q37=\"\",\"\",ROUND(OFFSET(S37,MATCH(TRUE,INDEX(S38:S$44<>\"\",0),0),0),0))","v":244000},null,null,{"$f":"SUM('3 & 4'!F40,'3 & 4'!P40,'1 & 2'!F40,'1 & 2'!P40)","v":63.336203748315967},null,null,"Acre-Ft.",null,{"$f":"SUM('3 & 4'!K40,'3 & 4'!U40,'1 & 2'!K40,'1 & 2'!U40)","v":62.383037750151146},null,null,"Acre-Ft.",null,null,30,404200,null,248000,null,652200]
[31,186294,{"$f":"IF(OR(B38=\"HOL\",B38=\"SUN\",B38=\"SAT\",B38=\"No Read\",B38=\"\"),\"\",IF(INDEX(B38:$B$44,MATCH(TRUE,ISNUMBER(B38:$B$44),0))<LOOKUP(99^99,B$2:B37),(INDEX(B38:$B$44,MATCH(TRUE,ISNUMBER(B38:$B$44),0))*1000),(INDEX(B38:$B$44,MATCH(TRUE,ISNUMBER(B38:$B$44),0))-LOOKUP(99^99,B$2:B37))*1000))","v":82000},82000,{"$f":"IF(B38=\"\",E37,IF(C38=\"\",IF(E37>0,E37+1,1),1))","v":1},{"$f":"IF(B38=\"\",\"\",ROUND(OFFSET(D38,MATCH(TRUE,INDEX(D39:D$44<>\"\",0),0),0),0))","v":72000},2691663,{"$f":"IF(OR(G38=\"HOL\",G38=\"SUN\",G38=\"SAT\",G38=\"No Read\",G38=\"\"),\"\",IF(INDEX(G38:$G$44,MATCH(TRUE,ISNUMBER(G38:$G$44),0))<LOOKUP(99^99,G$2:G37),(INDEX(G38:$G$44,MATCH(TRUE,ISNUMBER(G38:$G$44),0))*100),(INDEX(G38:$G$44,MATCH(TRUE,ISNUMBER(G38:$G$44),0))-LOOKUP(99^99,G$2:G37))*100))","v":160200},160200,{"$f":"IF(G38=\"\",J37,IF(H38=\"\",IF(J37>0,J37+1,1),1))","v":1},{"$f":"IF(G38=\"\",\"\",ROUND(OFFSET(I38,MATCH(TRUE,INDEX(I39:I$44<>\"\",0),0),0),0))","v":160200},284249,{"$f":"IF(OR(L38=\"HOL\",L38=\"SUN\",L38=\"SAT\",L38=\"No Read\",L38=\"\"),\"\",IF(INDEX(L38:$L$44,MATCH(TRUE,ISNUMBER(L38:$L$44),0))<LOOKUP(99^99,L$2:L37),(INDEX(L38:$L$44,MATCH(TRUE,ISNUMBER(L38:$L$44),0))*1000),(INDEX(L38:$L$44,MATCH(TRUE,ISNUMBER(L38:$L$44),0))-LOOKUP(99^99,L$2:L37))*1000))","v":111000},111000,{"$f":"IF(L38=\"\",O37,IF(M38=\"\",IF(O37>0,O37+1,1),1))","v":1},{"$f":"IF(L38=\"\",\"\",ROUND(OFFSET(N38,MATCH(TRUE,INDEX(N39:N$44<>\"\",0),0),0),0))","v":90000},1927314,{"$f":"IF(OR(Q38=\"HOL\",Q38=\"SUN\",Q38=\"SAT\",Q38=\"No Read\",Q38=\"\"),\"\",IF(INDEX(Q38:$Q$44,MATCH(TRUE,ISNUMBER(Q38:$Q$44),0))<LOOKUP(99^99,Q$2:Q37),(INDEX(Q38:$Q$44,MATCH(TRUE,ISNUMBER(Q38:$Q$44),0))*1000),(INDEX(Q38:$Q$44,MATCH(TRUE,ISNUMBER(Q38:$Q$44),0))-LOOKUP(99^99,Q$2:Q37))*1000))","v":244000},244000,{"$f":"IF(Q38=\"\",T37,IF(R38=\"\",IF(T37>0,T37+1,1),1))","v":1},{"$f":"IF(Q38=\"\",\"\",ROUND(OFFSET(S38,MATCH(TRUE,INDEX(S39:S$44<>\"\",0),0),0),0))","v":261000},null,null,null,null,null,null,null,null,null,null,null,null,null,31,421200,null,337000,null,758200]
["TOTAL:",null,null,null,null,{"$f":"IF(COUNTBLANK(F$8:F$38)=31,\"\",SUM(F$8:F$38))","v":2271000},null,null,null,null,{"$f":"IF(COUNTBLANK(K$8:K$38)=31,\"\",SUM(K$8:K$38))","v":4941700},null,null,null,null,{"$f":"IF(COUNTBLANK(P$8:P$38)=31,\"\",SUM(P$8:P$38))","v":3049000},null,null,null,null,{"$f":"IF(COUNTBLANK(U$8:U$38)=31,\"\",SUM(U$8:U$38))","v":7707000},"Gallons"]
[null,null,null,null,null,{"$f":"IF(F$39=\"\",\"\",F$39/325853)","v":6.9694003124108113},null,null,null,null,{"$f":"IF(K$39=\"\",\"\",K$39/325853)","v":15.165427355279835},null,null,null,null,{"$f":"IF(P$39=\"\",\"\",P$39/325853)","v":9.3569799879086588},null,null,null,null,{"$f":"IF(U$39=\"\",\"\",U$39/325853)","v":23.651769356120706},"Acre-Ft."]
[null,186366,{"$f":"IF(OR(B41=\"HOL\",B41=\"SUN\",B41=\"SAT\",B41=\"No Read\",B41=\"\"),\"\",IF(INDEX(B41:$B$44,MATCH(TRUE,ISNUMBER(B41:$B$44),0))<LOOKUP(99^99,B$2:B40),(INDEX(B41:$B$44,MATCH(TRUE,ISNUMBER(B41:$B$44),0))*1000),(INDEX(B41:$B$44,MATCH(TRUE,ISNUMBER(B41:$B$44),0))-LOOKUP(99^99,B$2:B40))*1000))","v":72000},{"$f":"IF(OR(B41=\"HOL\",B41=\"SUN\",B41=\"SAT\",B41=\"No Read\",B41=\"\"),\"\",ROUND(C41/E38,1))","v":72000},{"$f":"IF(B41=\"\",E38,IF(C41=\"\",IF(E38>0,E38+1,1),1))","v":1},{"$f":"IF(B42=\"\",\"\",OFFSET(D41,MATCH(TRUE,INDEX(D42:D$44<>\"\",0),0),0))","v":""},2693265,{"$f":"IF(OR(G41=\"HOL\",G41=\"SUN\",G41=\"SAT\",G41=\"No Read\",G41=\"\"),\"\",IF(INDEX(G41:$G$44,MATCH(TRUE,ISNUMBER(G41:$G$44),0))<LOOKUP(99^99,G$2:G40),(INDEX(G41:$G$44,MATCH(TRUE,ISNUMBER(G41:$G$44),0))*100),(INDEX(G41:$G$44,MATCH(TRUE,ISNUMBER(G41:$G$44),0))-LOOKUP(99^99,G$2:G40))*100))","v":160200},{"$f":"IF(OR(G41=\"HOL\",G41=\"SUN\",G41=\"SAT\",G41=\"No Read\",G41=\"\"),\"\",ROUND(H41/J38,1))","v":160200},{"$f":"IF(G41=\"\",J38,IF(H41=\"\",IF(J38>0,J38+1,1),1))","v":1},{"$f":"IF(G42=\"\",\"\",OFFSET(I41,MATCH(TRUE,INDEX(I42:I$44<>\"\",0),0),0))","v":""},284339,{"$f":"IF(OR(L41=\"HOL\",L41=\"SUN\",L41=\"SAT\",L41=\"No Read\",L41=\"\"),\"\",IF(INDEX(L41:$L$44,MATCH(TRUE,ISNUMBER(L41:$L$44),0))<LOOKUP(99^99,L$2:L40),(INDEX(L41:$L$44,MATCH(TRUE,ISNUMBER(L41:$L$44),0))*1000),(INDEX(L41:$L$44,MATCH(TRUE,ISNUMBER(L41:$L$44),0))-LOOKUP(99^99,L$2:L40))*1000))","v":90000},{"$f":"IF(OR(L41=\"HOL\",L41=\"SUN\",L41=\"SAT\",L41=\"No Read\",L41=\"\"),\"\",ROUND(M41/O38,1))","v":90000},{"$f":"IF(L41=\"\",O38,IF(M41=\"\",IF(O38>0,O38+1,1),1))","v":1},{"$f":"IF(L42=\"\",\"\",OFFSET(N41,MATCH(TRUE,INDEX(N42:N$44<>\"\",0),0),0))","v":""},1927575,{"$f":"IF(OR(Q41=\"HOL\",Q41=\"SUN\",Q41=\"SAT\",Q41=\"No Read\",Q41=\"\"),\"\",IF(INDEX(Q41:$Q$44,MATCH(TRUE,ISNUMBER(Q41:$Q$44),0))<LOOKUP(99^99,Q$2:Q40),(INDEX(Q41:$Q$44,MATCH(TRUE,ISNUMBER(Q41:$Q$44),0))*1000),(INDEX(Q41:$Q$44,MATCH(TRUE,ISNUMBER(Q41:$Q$44),0))-LOOKUP(99^99,Q$2:Q40))*1000))","v":261000},{"$f":"IF(OR(Q41=\"HOL\",Q41=\"SUN\",Q41=\"SAT\",Q41=\"No Read\",Q41=\"\"),\"\",ROUND(R41/T38,1))","v":261000},{"$f":"IF(Q41=\"\",T38,IF(R41=\"\",IF(T38>0,T38+1,1),1))","v":1},{"$f":"IF(Q42=\"\",\"\",OFFSET(S41,MATCH(TRUE,INDEX(S42:S$44<>\"\",0),0),0))","v":""}]
[null,null,{"$f":"IF(OR(B42=\"HOL\",B42=\"SUN\",B42=\"SAT\",B42=\"No Read\",B42=\"\"),\"\",IF(INDEX(B42:$B$44,MATCH(TRUE,ISNUMBER(B42:$B$44),0))<LOOKUP(99^99,B$2:B41),(INDEX(B42:$B$44,MATCH(TRUE,ISNUMBER(B42:$B$44),0))*1000),(INDEX(B42:$B$44,MATCH(TRUE,ISNUMBER(B42:$B$44),0))-LOOKUP(99^99,B$2:B41))*1000))","v":""},{"$f":"IF(OR(B42=\"HOL\",B42=\"SUN\",B42=\"SAT\",B42=\"No Read\",B42=\"\"),\"\",ROUND(C42/E41,1))","v":""},{"$f":"IF(B42=\"\",E41,IF(C42=\"\",IF(E41>0,E41+1,1),1))","v":1},{"$f":"IF(B43=\"\",\"\",OFFSET(D42,MATCH(TRUE,INDEX(D43:D$44<>\"\",0),0),0))","v":""},null,{"$f":"IF(OR(G42=\"HOL\",G42=\"SUN\",G42=\"SAT\",G42=\"No Read\",G42=\"\"),\"\",IF(INDEX(G42:$G$44,MATCH(TRUE,ISNUMBER(G42:$G$44),0))<LOOKUP(99^99,G$2:G41),(INDEX(G42:$G$44,MATCH(TRUE,ISNUMBER(G42:$G$44),0))*100),(INDEX(G42:$G$44,MATCH(TRUE,ISNUMBER(G42:$G$44),0))-LOOKUP(99^99,G$2:G41))*100))","v":""},{"$f":"IF(OR(G42=\"HOL\",G42=\"SUN\",G42=\"SAT\",G42=\"No Read\",G42=\"\"),\"\",ROUND(H42/J41,1))","v":""},{"$f":"IF(G42=\"\",J41,IF(H42=\"\",IF(J41>0,J41+1,1),1))","v":1},{"$f":"IF(G43=\"\",\"\",OFFSET(I42,MATCH(TRUE,INDEX(I43:I$44<>\"\",0),0),0))","v":""},null,{"$f":"IF(OR(L42=\"HOL\",L42=\"SUN\",L42=\"SAT\",L42=\"No Read\",L42=\"\"),\"\",IF(INDEX(L42:$L$44,MATCH(TRUE,ISNUMBER(L42:$L$44),0))<LOOKUP(99^99,L$2:L41),(INDEX(L42:$L$44,MATCH(TRUE,ISNUMBER(L42:$L$44),0))*1000),(INDEX(L42:$L$44,MATCH(TRUE,ISNUMBER(L42:$L$44),0))-LOOKUP(99^99,L$2:L41))*1000))","v":""},{"$f":"IF(OR(L42=\"HOL\",L42=\"SUN\",L42=\"SAT\",L42=\"No Read\",L42=\"\"),\"\",ROUND(M42/O41,1))","v":""},{"$f":"IF(L42=\"\",O41,IF(M42=\"\",IF(O41>0,O41+1,1),1))","v":1},{"$f":"IF(L43=\"\",\"\",OFFSET(N42,MATCH(TRUE,INDEX(N43:N$44<>\"\",0),0),0))","v":""},null,{"$f":"IF(OR(Q42=\"HOL\",Q42=\"SUN\",Q42=\"SAT\",Q42=\"No Read\",Q42=\"\"),\"\",IF(INDEX(Q42:$Q$44,MATCH(TRUE,ISNUMBER(Q42:$Q$44),0))<LOOKUP(99^99,Q$2:Q41),(INDEX(Q42:$Q$44,MATCH(TRUE,ISNUMBER(Q42:$Q$44),0))*1000),(INDEX(Q42:$Q$44,MATCH(TRUE,ISNUMBER(Q42:$Q$44),0))-LOOKUP(99^99,Q$2:Q41))*1000))","v":""},{"$f":"IF(OR(Q42=\"HOL\",Q42=\"SUN\",Q42=\"SAT\",Q42=\"No Read\",Q42=\"\"),\"\",ROUND(R42/T41,1))","v":""},{"$f":"IF(Q42=\"\",T41,IF(R42=\"\",IF(T41>0,T41+1,1),1))","v":1},{"$f":"IF(Q43=\"\",\"\",OFFSET(S42,MATCH(TRUE,INDEX(S43:S$44<>\"\",0),0),0))","v":""}]
[null,null,{"$f":"IF(OR(B43=\"HOL\",B43=\"SUN\",B43=\"SAT\",B43=\"No Read\",B43=\"\"),\"\",IF(INDEX(B43:$B$44,MATCH(TRUE,ISNUMBER(B43:$B$44),0))<LOOKUP(99^99,B$2:B42),(INDEX(B43:$B$44,MATCH(TRUE,ISNUMBER(B43:$B$44),0))*1000),(INDEX(B43:$B$44,MATCH(TRUE,ISNUMBER(B43:$B$44),0))-LOOKUP(99^99,B$2:B42))*1000))","v":""},"",{"$f":"IF(B43=\"\",E42,IF(C43=\"\",IF(E42>0,E42+1,1),1))","v":1},{"$f":"IF(B44=\"\",\"\",OFFSET(D43,MATCH(TRUE,INDEX(D44:D$44<>\"\",0),0),0))","v":""},null,{"$f":"IF(OR(G43=\"HOL\",G43=\"SUN\",G43=\"SAT\",G43=\"No Read\",G43=\"\"),\"\",IF(INDEX(G43:$G$44,MATCH(TRUE,ISNUMBER(G43:$G$44),0))<LOOKUP(99^99,G$2:G42),(INDEX(G43:$G$44,MATCH(TRUE,ISNUMBER(G43:$G$44),0))*100),(INDEX(G43:$G$44,MATCH(TRUE,ISNUMBER(G43:$G$44),0))-LOOKUP(99^99,G$2:G42))*100))","v":""},"",{"$f":"IF(G43=\"\",J42,IF(H43=\"\",IF(J42>0,J42+1,1),1))","v":1},{"$f":"IF(G44=\"\",\"\",OFFSET(I43,MATCH(TRUE,INDEX(I44:I$44<>\"\",0),0),0))","v":""},null,{"$f":"IF(OR(L43=\"HOL\",L43=\"SUN\",L43=\"SAT\",L43=\"No Read\",L43=\"\"),\"\",IF(INDEX(L43:$L$44,MATCH(TRUE,ISNUMBER(L43:$L$44),0))<LOOKUP(99^99,L$2:L42),(INDEX(L43:$L$44,MATCH(TRUE,ISNUMBER(L43:$L$44),0))*1000),(INDEX(L43:$L$44,MATCH(TRUE,ISNUMBER(L43:$L$44),0))-LOOKUP(99^99,L$2:L42))*1000))","v":""},"",{"$f":"IF(L43=\"\",O42,IF(M43=\"\",IF(O42>0,O42+1,1),1))","v":1},{"$f":"IF(L44=\"\",\"\",OFFSET(N43,MATCH(TRUE,INDEX(N44:N$44<>\"\",0),0),0))","v":""},null,{"$f":"IF(OR(Q43=\"HOL\",Q43=\"SUN\",Q43=\"SAT\",Q43=\"No Read\",Q43=\"\"),\"\",IF(INDEX(Q43:$Q$44,MATCH(TRUE,ISNUMBER(Q43:$Q$44),0))<LOOKUP(99^99,Q$2:Q42),(INDEX(Q43:$Q$44,MATCH(TRUE,ISNUMBER(Q43:$Q$44),0))*1000),(INDEX(Q43:$Q$44,MATCH(TRUE,ISNUMBER(Q43:$Q$44),0))-LOOKUP(99^99,Q$2:Q42))*1000))","v":""},"",{"$f":"IF(Q43=\"\",T42,IF(R43=\"\",IF(T42>0,T42+1,1),1))","v":1},{"$f":"IF(Q44=\"\",\"\",OFFSET(S43,MATCH(TRUE,INDEX(S44:S$44<>\"\",0),0),0))","v":""}]
[null,null,{"$f":"IF(OR(B44=\"HOL\",B44=\"SUN\",B44=\"SAT\",B44=\"No Read\",B44=\"\"),\"\",IF(INDEX(B44:$B$44,MATCH(TRUE,ISNUMBER(B44:$B$44),0))<LOOKUP(99^99,B$2:B43),(INDEX(B44:$B$44,MATCH(TRUE,ISNUMBER(B44:$B$44),0))*1000),(INDEX(B44:$B$44,MATCH(TRUE,ISNUMBER(B44:$B$44),0))-LOOKUP(99^99,B$2:B43))*1000))","v":""},"",{"$f":"IF(B44=\"\",E43,IF(C44=\"\",IF(E43>0,E43+1,1),1))","v":1},{"$f":"IF(B45=\"\",\"\",OFFSET(D44,MATCH(TRUE,INDEX(D$44:D45<>\"\",0),0),0))","v":""},null,{"$f":"IF(OR(G44=\"HOL\",G44=\"SUN\",G44=\"SAT\",G44=\"No Read\",G44=\"\"),\"\",IF(INDEX(G44:$G$44,MATCH(TRUE,ISNUMBER(G44:$G$44),0))<LOOKUP(99^99,G$2:G43),(INDEX(G44:$G$44,MATCH(TRUE,ISNUMBER(G44:$G$44),0))*100),(INDEX(G44:$G$44,MATCH(TRUE,ISNUMBER(G44:$G$44),0))-LOOKUP(99^99,G$2:G43))*100))","v":""},"",{"$f":"IF(G44=\"\",J43,IF(H44=\"\",IF(J43>0,J43+1,1),1))","v":1},{"$f":"IF(G45=\"\",\"\",OFFSET(I44,MATCH(TRUE,INDEX(I$44:I45<>\"\",0),0),0))","v":""},null,{"$f":"IF(OR(L44=\"HOL\",L44=\"SUN\",L44=\"SAT\",L44=\"No Read\",L44=\"\"),\"\",IF(INDEX(L44:$L$44,MATCH(TRUE,ISNUMBER(L44:$L$44),0))<LOOKUP(99^99,L$2:L43),(INDEX(L44:$L$44,MATCH(TRUE,ISNUMBER(L44:$L$44),0))*1000),(INDEX(L44:$L$44,MATCH(TRUE,ISNUMBER(L44:$L$44),0))-LOOKUP(99^99,L$2:L43))*1000))","v":""},"",{"$f":"IF(L44=\"\",O43,IF(M44=\"\",IF(O43>0,O43+1,1),1))","v":1},{"$f":"IF(L45=\"\",\"\",OFFSET(N44,MATCH(TRUE,INDEX(N$44:N45<>\"\",0),0),0))","v":""},null,{"$f":"IF(OR(Q44=\"HOL\",Q44=\"SUN\",Q44=\"SAT\",Q44=\"No Read\",Q44=\"\"),\"\",IF(INDEX(Q44:$Q$44,MATCH(TRUE,ISNUMBER(Q44:$Q$44),0))<LOOKUP(99^99,Q$2:Q43),(INDEX(Q44:$Q$44,MATCH(TRUE,ISNUMBER(Q44:$Q$44),0))*1000),(INDEX(Q44:$Q$44,MATCH(TRUE,ISNUMBER(Q44:$Q$44),0))-LOOKUP(99^99,Q$2:Q43))*1000))","v":""},"",{"$f":"IF(Q44=\"\",T43,IF(R44=\"\",IF(T43>0,T43+1,1),1))","v":1},{"$f":"IF(Q45=\"\",\"\",OFFSET(S44,MATCH(TRUE,INDEX(S$44:S45<>\"\",0),0),0))","v":""}]

{"sheet":"3 & 4","index":1,"n_rows":44,"n_cols":32,"rows_kept":44,"cut":false,"hidden":false,"merged":[[17,23,17,27],[18,23,18,27],[19,23,19,27],[20,23,20,27],[21,23,21,27]]}
[]
[null,null,null,{"$f":"IF(OR(B2=\"HOL\",B2=\"SUN\",B2=\"SAT\",B2=\"No Read\",B2=\"\"),\"\",ROUND(C2/E1,1))","v":""},{"$f":"IF(C2=\"\",IF(E1>0,E1+1,1),1)","v":1},null,null,null,{"$f":"IF(OR(G2=\"HOL\",G2=\"SUN\",G2=\"SAT\",G2=\"No Read\",G2=\"\"),\"\",ROUND(H2/J1,1))","v":""},{"$f":"IF(H2=\"\",IF(J1>0,J1+1,1),1)","v":1},null,null,null,{"$f":"IF(OR(L2=\"HOL\",L2=\"SUN\",L2=\"SAT\",L2=\"No Read\",L2=\"\"),\"\",ROUND(M2/O1,1))","v":""},{"$f":"IF(M2=\"\",IF(O1>0,O1+1,1),1)","v":1},null,null,null,{"$f":"IF(OR(Q2=\"HOL\",Q2=\"SUN\",Q2=\"SAT\",Q2=\"No Read\",Q2=\"\"),\"\",ROUND(R2/T1,1))","v":""},{"$f":"IF(R2=\"\",IF(T1>0,T1+1,1),1)","v":1}]
[null,null,{"$f":"IF(OR(B3=\"HOL\",B3=\"SUN\",B3=\"SAT\",B3=\"No Read\",B3=\"\"),\"\",(INDEX(B3:$B$44,MATCH(TRUE,ISNUMBER(B3:$B$44),0))-LOOKUP(99^99,$B$2:B3))*748)","v":""},{"$f":"IF(OR(B3=\"HOL\",B3=\"SUN\",B3=\"SAT\",B3=\"No Read\",B3=\"\"),\"\",ROUND(C3/E2,1))","v":""},{"$f":"IF(C3=\"\",IF(E2>0,E2+1,1),1)","v":2},null,null,{"$f":"IF(OR(G3=\"HOL\",G3=\"SUN\",G3=\"SAT\",G3=\"No Read\",G3=\"\"),\"\",(INDEX(G3:$G$44,MATCH(TRUE,ISNUMBER(G3:$G$44),0))-LOOKUP(99^99,$G$2:G3))*1000)","v":""},{"$f":"IF(OR(G3=\"HOL\",G3=\"SUN\",G3=\"SAT\",G3=\"No Read\",G3=\"\"),\"\",ROUND(H3/J2,1))","v":""},{"$f":"IF(H3=\"\",IF(J2>0,J2+1,1),1)","v":2},null,null,{"$f":"IF(OR(L3=\"HOL\",L3=\"SUN\",L3=\"SAT\",L3=\"No Read\",L3=\"\"),\"\",(INDEX(L3:$L$44,MATCH(TRUE,ISNUMBER(L3:$L$44),0))-LOOKUP(99^99,$L$2:L3))*748)","v":""},{"$f":"IF(OR(L3=\"HOL\",L3=\"SUN\",L3=\"SAT\",L3=\"No Read\",L3=\"\"),\"\",ROUND(M3/O2,1))","v":""},{"$f":"IF(M3=\"\",IF(O2>0,O2+1,1),1)","v":2},null,null,{"$f":"IF(OR(Q3=\"HOL\",Q3=\"SUN\",Q3=\"SAT\",Q3=\"No Read\",Q3=\"\"),\"\",(INDEX(Q3:$Q$44,MATCH(TRUE,ISNUMBER(Q3:$Q$44),0))-LOOKUP(99^99,$Q$2:Q3))*1000)","v":""},{"$f":"IF(OR(Q3=\"HOL\",Q3=\"SUN\",Q3=\"SAT\",Q3=\"No Read\",Q3=\"\"),\"\",ROUND(R3/T2,1))","v":""},{"$f":"IF(R3=\"\",IF(T2>0,T2+1,1),1)","v":2}]
[null,null,{"$f":"IF(OR(B4=\"HOL\",B4=\"SUN\",B4=\"SAT\",B4=\"No Read\",B4=\"\"),\"\",(INDEX(B4:$B$44,MATCH(TRUE,ISNUMBER(B4:$B$44),0))-LOOKUP(99^99,$B$2:B4))*748)","v":""},{"$f":"IF(OR(B4=\"HOL\",B4=\"SUN\",B4=\"SAT\",B4=\"No Read\",B4=\"\"),\"\",ROUND(C4/E3,1))","v":""},{"$f":"IF(C4=\"\",IF(E3>0,E3+1,1),1)","v":3},null,null,{"$f":"IF(OR(G4=\"HOL\",G4=\"SUN\",G4=\"SAT\",G4=\"No Read\",G4=\"\"),\"\",(INDEX(G4:$G$44,MATCH(TRUE,ISNUMBER(G4:$G$44),0))-LOOKUP(99^99,$G$2:G4))*1000)","v":""},{"$f":"IF(OR(G4=\"HOL\",G4=\"SUN\",G4=\"SAT\",G4=\"No Read\",G4=\"\"),\"\",ROUND(H4/J3,1))","v":""},{"$f":"IF(H4=\"\",IF(J3>0,J3+1,1),1)","v":3},null,null,{"$f":"IF(OR(L4=\"HOL\",L4=\"SUN\",L4=\"SAT\",L4=\"No Read\",L4=\"\"),\"\",(INDEX(L4:$L$44,MATCH(TRUE,ISNUMBER(L4:$L$44),0))-LOOKUP(99^99,$L$2:L4))*748)","v":""},{"$f":"IF(OR(L4=\"HOL\",L4=\"SUN\",L4=\"SAT\",L4=\"No Read\",L4=\"\"),\"\",ROUND(M4/O3,1))","v":""},{"$f":"IF(M4=\"\",IF(O3>0,O3+1,1),1)","v":3},null,null,{"$f":"IF(OR(Q4=\"HOL\",Q4=\"SUN\",Q4=\"SAT\",Q4=\"No Read\",Q4=\"\"),\"\",(INDEX(Q4:$Q$44,MATCH(TRUE,ISNUMBER(Q4:$Q$44),0))-LOOKUP(99^99,$Q$2:Q4))*1000)","v":""},{"$f":"IF(OR(Q4=\"HOL\",Q4=\"SUN\",Q4=\"SAT\",Q4=\"No Read\",Q4=\"\"),\"\",ROUND(R4/T3,1))","v":""},{"$f":"IF(R4=\"\",IF(T3>0,T3+1,1),1)","v":3}]
[null,559596,{"$f":"IF(OR(B5=\"HOL\",B5=\"SUN\",B5=\"SAT\",B5=\"No Read\",B5=\"\"),\"\",(INDEX(B5:$B$44,MATCH(TRUE,ISNUMBER(B5:$B$44),0))-LOOKUP(99^99,$B$2:B5))*748)","v":0},{"$f":"IF(OR(B5=\"HOL\",B5=\"SUN\",B5=\"SAT\",B5=\"No Read\",B5=\"\"),\"\",ROUND(C5/E4,1))","v":0},{"$f":"IF(C5=\"\",IF(E4>0,E4+1,1),1)","v":1},null,1387252,{"$f":"IF(OR(G5=\"HOL\",G5=\"SUN\",G5=\"SAT\",G5=\"No Read\",G5=\"\"),\"\",(INDEX(G5:$G$44,MATCH(TRUE,ISNUMBER(G5:$G$44),0))-LOOKUP(99^99,$G$2:G5))*1000)","v":0},{"$f":"IF(OR(G5=\"HOL\",G5=\"SUN\",G5=\"SAT\",G5=\"No Read\",G5=\"\"),\"\",ROUND(H5/J4,1))","v":0},{"$f":"IF(H5=\"\",IF(J4>0,J4+1,1),1)","v":1},null,1969155,{"$f":"IF(OR(L5=\"HOL\",L5=\"SUN\",L5=\"SAT\",L5=\"No Read\",L5=\"\"),\"\",(INDEX(L5:$L$44,MATCH(TRUE,ISNUMBER(L5:$L$44),0))-LOOKUP(99^99,$L$2:L5))*748)","v":0},{"$f":"IF(OR(L5=\"HOL\",L5=\"SUN\",L5=\"SAT\",L5=\"No Read\",L5=\"\"),\"\",ROUND(M5/O4,1))","v":0},{"$f":"IF(M5=\"\",IF(O4>0,O4+1,1),1)","v":1},null,200114,{"$f":"IF(OR(Q5=\"HOL\",Q5=\"SUN\",Q5=\"SAT\",Q5=\"No Read\",Q5=\"\"),\"\",(INDEX(Q5:$Q$44,MATCH(TRUE,ISNUMBER(Q5:$Q$44),0))-LOOKUP(99^99,$Q$2:Q5))*1000)","v":0},{"$f":"IF(OR(Q5=\"HOL\",Q5=\"SUN\",Q5=\"SAT\",Q5=\"No Read\",Q5=\"\"),\"\",ROUND(R5/T4,1))","v":0},{"$f":"IF(R5=\"\",IF(T4>0,T4+1,1),1)","v":1}]
[null,null,null,null,null,null,null,null,null,null,"2023-08-18"]
["DATE","Well #3",null,null,null,"GAL USED","Booster #3",null,null,null,"GAL USED","Well #4",null,null,null,"GAL USED","Booster #4",null,null,null,"GAL USED",null,null,null,null,null,null,null,null,null,"DATE","BOOSTERS 3 & 4"]
[1,559767,{"$f":"IF(OR(B8=\"HOL\",B8=\"SUN\",B8=\"SAT\",B8=\"No Read\",B8=\"\"),\"\",IF(INDEX(B8:$B$44,MATCH(TRUE,ISNUMBER(B8:$B$44),0))<LOOKUP(99^99,B$2:B7),(INDEX(B8:$B$44,MATCH(TRUE,ISNUMBER(B8:$B$44),0))*748),(INDEX(B8:$B$44,MATCH(TRUE,ISNUMBER(B8:$B$44),0))-LOOKUP(99^99,B$2:B7))*748))","v":127908},{"$f":"IF(OR(B8=\"HOL\",B8=\"SUN\",B8=\"SAT\",B8=\"No Read\",B8=\"\"),\"\",ROUND(C8/E5,1))","v":127908},{"$f":"IF(B8=\"\",E5,IF(C8=\"\",IF(E5>0,E5+1,1),1))","v":1},{"$f":"IF(B8=\"\",\"\",ROUND(OFFSET(D8,MATCH(TRUE,INDEX(D9:D$44<>\"\",0),0),0),0))","v":120428},1387595,{"$f":"IF(OR(G8=\"HOL\",G8=\"SUN\",G8=\"SAT\",G8=\"No Read\",G8=\"\"),\"\",IF(INDEX(G8:$G$44,MATCH(TRUE,ISNUMBER(G8:$G$44),0))<LOOKUP(99^99,G$2:G7),(INDEX(G8:$G$44,MATCH(TRUE,ISNUMBER(G8:$G$44),0))*1000),(INDEX(G8:$G$44,MATCH(TRUE,ISNUMBER(G8:$G$44),0))-LOOKUP(99^99,G$2:G7))*1000))","v":343000},{"$f":"IF(OR(G8=\"HOL\",G8=\"SUN\",G8=\"SAT\",G8=\"No Read\",G8=\"\"),\"\",ROUND(H8/J5,1))","v":343000},{"$f":"IF(G8=\"\",J5,IF(H8=\"\",IF(J5>0,J5+1,1),1))","v":1},{"$f":"IF(G8=\"\",\"\",ROUND(OFFSET(I8,MATCH(TRUE,INDEX(I9:I$44<>\"\",0),0),0),0))","v":310000},1969740,{"$f":"IF(OR(L8=\"HOL\",L8=\"SUN\",L8=\"SAT\",L8=\"No Read\",L8=\"\"),\"\",IF(INDEX(L8:$L$44,MATCH(TRUE,ISNUMBER(L8:$L$44),0))<LOOKUP(99^99,L$2:L7),(INDEX(L8:$L$44,MATCH(TRUE,ISNUMBER(L8:$L$44),0))*748),(INDEX(L8:$L$44,MATCH(TRUE,ISNUMBER(L8:$L$44),0))-LOOKUP(99^99,L$2:L7))*748))","v":437580},{"$f":"IF(OR(L8=\"HOL\",L8=\"SUN\",L8=\"SAT\",L8=\"No Read\",L8=\"\"),\"\",ROUND(M8/O5,1))","v":437580},{"$f":"IF(L8=\"\",O5,IF(M8=\"\",IF(O5>0,O5+1,1),1))","v":1},{"$f":"IF(L8=\"\",\"\",ROUND(OFFSET(N8,MATCH(TRUE,INDEX(N9:N$44<>\"\",0),0),0),0))","v":407660},200115,{"$f":"IF(OR(Q8=\"HOL\",Q8=\"SUN\",Q8=\"SAT\",Q8=\"No Read\",Q8=\"\"),\"\",IF(INDEX(Q8:$Q$44,MATCH(TRUE,ISNUMBER(Q8:$Q$44),0))<LOOKUP(99^99,Q$2:Q7),(INDEX(Q8:$Q$44,MATCH(TRUE,ISNUMBER(Q8:$Q$44),0))*1000),(INDEX(Q8:$Q$44,MATCH(TRUE,ISNUMBER(Q8:$Q$44),0))-LOOKUP(99^99,Q$2:Q7))*1000))","v":1000},{"$f":"IF(OR(Q8=\"HOL\",Q8=\"SUN\",Q8=\"SAT\",Q8=\"No Read\",Q8=\"\"),\"\",ROUND(R8/T5,1))","v":1000},{"$f":"IF(Q8=\"\",T5,IF(R8=\"\",IF(T5>0,T5+1,1),1))","v":1},{"$f":"IF(Q8=\"\",\"\",ROUND(OFFSET(S8,MATCH(TRUE,INDEX(S9:S$44<>\"\",0),0),0),0))","v":0},null,null,null,null,null,null,null,null,null,1,{"$f":"SUM(K8,U8)","v":310000}]
[2,559928,{"$f":"IF(OR(B9=\"HOL\",B9=\"SUN\",B9=\"SAT\",B9=\"No Read\",B9=\"\"),\"\",IF(INDEX(B9:$B$44,MATCH(TRUE,ISNUMBER(B9:$B$44),0))<LOOKUP(99^99,B$2:B8),(INDEX(B9:$B$44,MATCH(TRUE,ISNUMBER(B9:$B$44),0))*748),(INDEX(B9:$B$44,MATCH(TRUE,ISNUMBER(B9:$B$44),0))-LOOKUP(99^99,B$2:B8))*748))","v":120428},{"$f":"IF(OR(B9=\"HOL\",B9=\"SUN\",B9=\"SAT\",B9=\"No Read\",B9=\"\"),\"\",ROUND(C9/E8,1))","v":120428},{"$f":"IF(B9=\"\",E8,IF(C9=\"\",IF(E8>0,E8+1,1),1))","v":1},{"$f":"IF(B9=\"\",\"\",ROUND(OFFSET(D9,MATCH(TRUE,INDEX(D10:D$44<>\"\",0),0),0),0))","v":136884},1387905,{"$f":"IF(OR(G9=\"HOL\",G9=\"SUN\",G9=\"SAT\",G9=\"No Read\",G9=\"\"),\"\",IF(INDEX(G9:$G$44,MATCH(TRUE,ISNUMBER(G9:$G$44),0))<LOOKUP(99^99,G$2:G8),(INDEX(G9:$G$44,MATCH(TRUE,ISNUMBER(G9:$G$44),0))*1000),(INDEX(G9:$G$44,MATCH(TRUE,ISNUMBER(G9:$G$44),0))-LOOKUP(99^99,G$2:G8))*1000))","v":310000},{"$f":"IF(OR(G9=\"HOL\",G9=\"SUN\",G9=\"SAT\",G9=\"No Read\",G9=\"\"),\"\",ROUND(H9/J8,1))","v":310000},{"$f":"IF(G9=\"\",J8,IF(H9=\"\",IF(J8>0,J8+1,1),1))","v":1},{"$f":"IF(G9=\"\",\"\",ROUND(OFFSET(I9,MATCH(TRUE,INDEX(I10:I$44<>\"\",0),0),0),0))","v":275000},1970285,{"$f":"IF(OR(L9=\"HOL\",L9=\"SUN\",L9=\"SAT\",L9=\"No Read\",L9=\"\"),\"\",IF(INDEX(L9:$L$44,MATCH(TRUE,ISNUMBER(L9:$L$44),0))<LOOKUP(99^99,L$2:L8),(INDEX(L9:$L$44,MATCH(TRUE,ISNUMBER(L9:$L$44),0))*748),(INDEX(L9:$L$44,MATCH(TRUE,ISNUMBER(L9:$L$44),0))-LOOKUP(99^99,L$2:L8))*748))","v":407660},{"$f":"IF(OR(L9=\"HOL\",L9=\"SUN\",L9=\"SAT\",L9=\"No Read\",L9=\"\"),\"\",ROUND(M9/O8,1))","v":407660},{"$f":"IF(L9=\"\",O8,IF(M9=\"\",IF(O8>0,O8+1,1),1))","v":1},{"$f":"IF(L9=\"\",\"\",ROUND(OFFSET(N9,MATCH(TRUE,INDEX(N10:N$44<>\"\",0),0),0),0))","v":476476},200115,{"$f":"IF(OR(Q9=\"HOL\",Q9=\"SUN\",Q9=\"SAT\",Q9=\"No Read\",Q9=\"\"),\"\",IF(INDEX(Q9:$Q$44,MATCH(TRUE,ISNUMBER(Q9:$Q$44),0))<LOOKUP(99^99,Q$2:Q8),(INDEX(Q9:$Q$44,MATCH(TRUE,ISNUMBER(Q9:$Q$44),0))*1000),(INDEX(Q9:$Q$44,MATCH(TRUE,ISNUMBER(Q9:$Q$44),0))-LOOKUP(99^99,Q$2:Q8))*1000))","v":0},{"$f":"IF(OR(Q9=\"HOL\",Q9=\"SUN\",Q9=\"SAT\",Q9=\"No Read\",Q9=\"\"),\"\",ROUND(R9/T8,1))","v":0},{"$f":"IF(Q9=\"\",T8,IF(R9=\"\",IF(T8>0,T8+1,1),1))","v":1},{"$f":"IF(Q9=\"\",\"\",ROUND(OFFSET(S9,MATCH(TRUE,INDEX(S10:S$44<>\"\",0),0),0),0))","v":1000},null,null,null,null,null,null,null,null,null,2,{"$f":"SUM(K9,U9)","v":276000}]
[3,560111,{"$f":"IF(OR(B10=\"HOL\",B10=\"SUN\",B10=\"SAT\",B10=\"No Read\",B10=\"\"),\"\",IF(INDEX(B10:$B$44,MATCH(TRUE,ISNUMBER(B10:$B$44),0))<LOOKUP(99^99,B$2:B9),(INDEX(B10:$B$44,MATCH(TRUE,ISNUMBER(B10:$B$44),0))*748),(INDEX(B10:$B$44,MATCH(TRUE,ISNUMBER(B10:$B$44),0))-LOOKUP(99^99,B$2:B9))*748))","v":136884},{"$f":"IF(OR(B10=\"HOL\",B10=\"SUN\",B10=\"SAT\",B10=\"No Read\",B10=\"\"),\"\",ROUND(C10/E9,1))","v":136884},{"$f":"IF(B10=\"\",E9,IF(C10=\"\",IF(E9>0,E9+1,1),1))","v":1},{"$f":"IF(B10=\"\",\"\",ROUND(OFFSET(D10,MATCH(TRUE,INDEX(D11:D$44<>\"\",0),0),0),0))","v":136884},1388180,{"$f":"IF(OR(G10=\"HOL\",G10=\"SUN\",G10=\"SAT\",G10=\"No Read\",G10=\"\"),\"\",IF(INDEX(G10:$G$44,MATCH(TRUE,ISNUMBER(G10:$G$44),0))<LOOKUP(99^99,G$2:G9),(INDEX(G10:$G$44,MATCH(TRUE,ISNUMBER(G10:$G$44),0))*1000),(INDEX(G10:$G$44,MATCH(TRUE,ISNUMBER(G10:$G$44),0))-LOOKUP(99^99,G$2:G9))*1000))","v":275000},{"$f":"IF(OR(G10=\"HOL\",G10=\"SUN\",G10=\"SAT\",G10=\"No Read\",G10=\"\"),\"\",ROUND(H10/J9,1))","v":275000},{"$f":"IF(G10=\"\",J9,IF(H10=\"\",IF(J9>0,J9+1,1),1))","v":1},{"$f":"IF(G10=\"\",\"\",ROUND(OFFSET(I10,MATCH(TRUE,INDEX(I11:I$44<>\"\",0),0),0),0))","v":386000},1970922,{"$f":"IF(OR(L10=\"HOL\",L10=\"SUN\",L10=\"SAT\",L10=\"No Read\",L10=\"\"),\"\",IF(INDEX(L10:$L$44,MATCH(TRUE,ISNUMBER(L10:$L$44),0))<LOOKUP(99^99,L$2:L9),(INDEX(L10:$L$44,MATCH(TRUE,ISNUMBER(L10:$L$44),0))*748),(INDEX(L10:$L$44,MATCH(TRUE,ISNUMBER(L10:$L$44),0))-LOOKUP(99^99,L$2:L9))*748))","v":476476},{"$f":"IF(OR(L10=\"HOL\",L10=\"SUN\",L10=\"SAT\",L10=\"No Read\",L10=\"\"),\"\",ROUND(M10/O9,1))","v":476476},{"$f":"IF(L10=\"\",O9,IF(M10=\"\",IF(O9>0,O9+1,1),1))","v":1},{"$f":"IF(L10=\"\",\"\",ROUND(OFFSET(N10,MATCH(TRUE,INDEX(N11:N$44<>\"\",0),0),0),0))","v":471240},200116,{"$f":"IF(OR(Q10=\"HOL\",Q10=\"SUN\",Q10=\"SAT\",Q10=\"No Read\",Q10=\"\"),\"\",IF(INDEX(Q10:$Q$44,MATCH(TRUE,ISNUMBER(Q10:$Q$44),0))<LOOKUP(99^99,Q$2:Q9),(INDEX(Q10:$Q$44,MATCH(TRUE,ISNUMBER(Q10:$Q$44),0))*1000),(INDEX(Q10:$Q$44,MATCH(TRUE,ISNUMBER(Q10:$Q$44),0))-LOOKUP(99^99,Q$2:Q9))*1000))","v":1000},{"$f":"IF(OR(Q10=\"HOL\",Q10=\"SUN\",Q10=\"SAT\",Q10=\"No Read\",Q10=\"\"),\"\",ROUND(R10/T9,1))","v":1000},{"$f":"IF(Q10=\"\",T9,IF(R10=\"\",IF(T9>0,T9+1,1),1))","v":1},{"$f":"IF(Q10=\"\",\"\",ROUND(OFFSET(S10,MATCH(TRUE,INDEX(S11:S$44<>\"\",0),0),0),0))","v":27000},null,null,null,null,null,null,null,null,null,3,413000]
[4,560294,{"$f":"IF(OR(B11=\"HOL\",B11=\"SUN\",B11=\"SAT\",B11=\"No Read\",B11=\"\"),\"\",IF(INDEX(B11:$B$44,MATCH(TRUE,ISNUMBER(B11:$B$44),0))<LOOKUP(99^99,B$2:B10),(INDEX(B11:$B$44,MATCH(TRUE,ISNUMBER(B11:$B$44),0))*748),(INDEX(B11:$B$44,MATCH(TRUE,ISNUMBER(B11:$B$44),0))-LOOKUP(99^99,B$2:B10))*748))","v":136884},136884,{"$f":"IF(B11=\"\",E10,IF(C11=\"\",IF(E10>0,E10+1,1),1))","v":1},{"$f":"IF(B11=\"\",\"\",ROUND(OFFSET(D11,MATCH(TRUE,INDEX(D12:D$44<>\"\",0),0),0),0))","v":142120},1388566,{"$f":"IF(OR(G11=\"HOL\",G11=\"SUN\",G11=\"SAT\",G11=\"No Read\",G11=\"\"),\"\",IF(INDEX(G11:$G$44,MATCH(TRUE,ISNUMBER(G11:$G$44),0))<LOOKUP(99^99,G$2:G10),(INDEX(G11:$G$44,MATCH(TRUE,ISNUMBER(G11:$G$44),0))*1000),(INDEX(G11:$G$44,MATCH(TRUE,ISNUMBER(G11:$G$44),0))-LOOKUP(99^99,G$2:G10))*1000))","v":386000},386000,{"$f":"IF(G11=\"\",J10,IF(H11=\"\",IF(J10>0,J10+1,1),1))","v":1},{"$f":"IF(G11=\"\",\"\",ROUND(OFFSET(I11,MATCH(TRUE,INDEX(I12:I$44<>\"\",0),0),0),0))","v":362000},1971552,{"$f":"IF(OR(L11=\"HOL\",L11=\"SUN\",L11=\"SAT\",L11=\"No Read\",L11=\"\"),\"\",IF(INDEX(L11:$L$44,MATCH(TRUE,ISNUMBER(L11:$L$44),0))<LOOKUP(99^99,L$2:L10),(INDEX(L11:$L$44,MATCH(TRUE,ISNUMBER(L11:$L$44),0))*748),(INDEX(L11:$L$44,MATCH(TRUE,ISNUMBER(L11:$L$44),0))-LOOKUP(99^99,L$2:L10))*748))","v":471240},471240,{"$f":"IF(L11=\"\",O10,IF(M11=\"\",IF(O10>0,O10+1,1),1))","v":1},{"$f":"IF(L11=\"\",\"\",ROUND(OFFSET(N11,MATCH(TRUE,INDEX(N12:N$44<>\"\",0),0),0),0))","v":502656},200143,{"$f":"IF(OR(Q11=\"HOL\",Q11=\"SUN\",Q11=\"SAT\",Q11=\"No Read\",Q11=\"\"),\"\",IF(INDEX(Q11:$Q$44,MATCH(TRUE,ISNUMBER(Q11:$Q$44),0))<LOOKUP(99^99,Q$2:Q10),(INDEX(Q11:$Q$44,MATCH(TRUE,ISNUMBER(Q11:$Q$44),0))*1000),(INDEX(Q11:$Q$44,MATCH(TRUE,ISNUMBER(Q11:$Q$44),0))-LOOKUP(99^99,Q$2:Q10))*1000))","v":27000},27000,{"$f":"IF(Q11=\"\",T10,IF(R11=\"\",IF(T10>0,T10+1,1),1))","v":1},{"$f":"IF(Q11=\"\",\"\",ROUND(OFFSET(S11,MATCH(TRUE,INDEX(S12:S$44<>\"\",0),0),0),0))","v":0},null,null,null,null,null,null,null,null,null,4,362000]
[5,560484,{"$f":"IF(OR(B12=\"HOL\",B12=\"SUN\",B12=\"SAT\",B12=\"No Read\",B12=\"\"),\"\",IF(INDEX(B12:$B$44,MATCH(TRUE,ISNUMBER(B12:$B$44),0))<LOOKUP(99^99,B$2:B11),(INDEX(B12:$B$44,MATCH(TRUE,ISNUMBER(B12:$B$44),0))*748),(INDEX(B12:$B$44,MATCH(TRUE,ISNUMBER(B12:$B$44),0))-LOOKUP(99^99,B$2:B11))*748))","v":142120},142120,{"$f":"IF(B12=\"\",E11,IF(C12=\"\",IF(E11>0,E11+1,1),1))","v":1},{"$f":"IF(B12=\"\",\"\",ROUND(OFFSET(D12,MATCH(TRUE,INDEX(D13:D$44<>\"\",0),0),0),0))","v":154088},1388928,{"$f":"IF(OR(G12=\"HOL\",G12=\"SUN\",G12=\"SAT\",G12=\"No Read\",G12=\"\"),\"\",IF(INDEX(G12:$G$44,MATCH(TRUE,ISNUMBER(G12:$G$44),0))<LOOKUP(99^99,G$2:G11),(INDEX(G12:$G$44,MATCH(TRUE,ISNUMBER(G12:$G$44),0))*1000),(INDEX(G12:$G$44,MATCH(TRUE,ISNUMBER(G12:$G$44),0))-LOOKUP(99^99,G$2:G11))*1000))","v":362000},362000,{"$f":"IF(G12=\"\",J11,IF(H12=\"\",IF(J11>0,J11+1,1),1))","v":1},{"$f":"IF(G12=\"\",\"\",ROUND(OFFSET(I12,MATCH(TRUE,INDEX(I13:I$44<>\"\",0),0),0),0))","v":331000},1972224,{"$f":"IF(OR(L12=\"HOL\",L12=\"SUN\",L12=\"SAT\",L12=\"No Read\",L12=\"\"),\"\",IF(INDEX(L12:$L$44,MATCH(TRUE,ISNUMBER(L12:$L$44),0))<LOOKUP(99^99,L$2:L11),(INDEX(L12:$L$44,MATCH(TRUE,ISNUMBER(L12:$L$44),0))*748),(INDEX(L12:$L$44,MATCH(TRUE,ISNUMBER(L12:$L$44),0))-LOOKUP(99^99,L$2:L11))*748))","v":502656},502656,{"$f":"IF(L12=\"\",O11,IF(M12=\"\",IF(O11>0,O11+1,1),1))","v":1},{"$f":"IF(L12=\"\",\"\",ROUND(OFFSET(N12,MATCH(TRUE,INDEX(N13:N$44<>\"\",0),0),0),0))","v":530332},200143,{"$f":"IF(OR(Q12=\"HOL\",Q12=\"SUN\",Q12=\"SAT\",Q12=\"No Read\",Q12=\"\"),\"\",IF(INDEX(Q12:$Q$44,MATCH(TRUE,ISNUMBER(Q12:$Q$44),0))<LOOKUP(99^99,Q$2:Q11),(INDEX(Q12:$Q$44,MATCH(TRUE,ISNUMBER(Q12:$Q$44),0))*1000),(INDEX(Q12:$Q$44,MATCH(TRUE,ISNUMBER(Q12:$Q$44),0))-LOOKUP(99^99,Q$2:Q11))*1000))","v":0},0,{"$f":"IF(Q12=\"\",T11,IF(R12=\"\",IF(T11>0,T11+1,1),1))","v":1},{"$f":"IF(Q12=\"\",\"\",ROUND(OFFSET(S12,MATCH(TRUE,INDEX(S13:S$44<>\"\",0),0),0),0))","v":0},null,null,null,null,null,null,null,null,null,5,331000]
[6,560690,{"$f":"IF(OR(B13=\"HOL\",B13=\"SUN\",B13=\"SAT\",B13=\"No Read\",B13=\"\"),\"\",IF(INDEX(B13:$B$44,MATCH(TRUE,ISNUMBER(B13:$B$44),0))<LOOKUP(99^99,B$2:B12),(INDEX(B13:$B$44,MATCH(TRUE,ISNUMBER(B13:$B$44),0))*748),(INDEX(B13:$B$44,MATCH(TRUE,ISNUMBER(B13:$B$44),0))-LOOKUP(99^99,B$2:B12))*748))","v":154088},154088,{"$f":"IF(B13=\"\",E12,IF(C13=\"\",IF(E12>0,E12+1,1),1))","v":1},{"$f":"IF(B13=\"\",\"\",ROUND(OFFSET(D13,MATCH(TRUE,INDEX(D14:D$44<>\"\",0),0),0),0))","v":106964},1389259,{"$f":"IF(OR(G13=\"HOL\",G13=\"SUN\",G13=\"SAT\",G13=\"No Read\",G13=\"\"),\"\",IF(INDEX(G13:$G$44,MATCH(TRUE,ISNUMBER(G13:$G$44),0))<LOOKUP(99^99,G$2:G12),(INDEX(G13:$G$44,MATCH(TRUE,ISNUMBER(G13:$G$44),0))*1000),(INDEX(G13:$G$44,MATCH(TRUE,ISNUMBER(G13:$G$44),0))-LOOKUP(99^99,G$2:G12))*1000))","v":331000},331000,{"$f":"IF(G13=\"\",J12,IF(H13=\"\",IF(J12>0,J12+1,1),1))","v":1},{"$f":"IF(G13=\"\",\"\",ROUND(OFFSET(I13,MATCH(TRUE,INDEX(I14:I$44<>\"\",0),0),0),0))","v":359000},1972933,{"$f":"IF(OR(L13=\"HOL\",L13=\"SUN\",L13=\"SAT\",L13=\"No Read\",L13=\"\"),\"\",IF(INDEX(L13:$L$44,MATCH(TRUE,ISNUMBER(L13:$L$44),0))<LOOKUP(99^99,L$2:L12),(INDEX(L13:$L$44,MATCH(TRUE,ISNUMBER(L13:$L$44),0))*748),(INDEX(L13:$L$44,MATCH(TRUE,ISNUMBER(L13:$L$44),0))-LOOKUP(99^99,L$2:L12))*748))","v":530332},530332,{"$f":"IF(L13=\"\",O12,IF(M13=\"\",IF(O12>0,O12+1,1),1))","v":1},{"$f":"IF(L13=\"\",\"\",ROUND(OFFSET(N13,MATCH(TRUE,INDEX(N14:N$44<>\"\",0),0),0),0))","v":353804},200143,{"$f":"IF(OR(Q13=\"HOL\",Q13=\"SUN\",Q13=\"SAT\",Q13=\"No Read\",Q13=\"\"),\"\",IF(INDEX(Q13:$Q$44,MATCH(TRUE,ISNUMBER(Q13:$Q$44),0))<LOOKUP(99^99,Q$2:Q12),(INDEX(Q13:$Q$44,MATCH(TRUE,ISNUMBER(Q13:$Q$44),0))*1000),(INDEX(Q13:$Q$44,MATCH(TRUE,ISNUMBER(Q13:$Q$44),0))-LOOKUP(99^99,Q$2:Q12))*1000))","v":0},0,{"$f":"IF(Q13=\"\",T12,IF(R13=\"\",IF(T12>0,T12+1,1),1))","v":1},{"$f":"IF(Q13=\"\",\"\",ROUND(OFFSET(S13,MATCH(TRUE,INDEX(S14:S$44<>\"\",0),0),0),0))","v":0},null,null,null,null,null,null,null,null,null,6,359000]
[7,560833,{"$f":"IF(OR(B14=\"HOL\",B14=\"SUN\",B14=\"SAT\",B14=\"No Read\",B14=\"\"),\"\",IF(INDEX(B14:$B$44,MATCH(TRUE,ISNUMBER(B14:$B$44),0))<LOOKUP(99^99,B$2:B13),(INDEX(B14:$B$44,MATCH(TRUE,ISNUMBER(B14:$B$44),0))*748),(INDEX(B14:$B$44,MATCH(TRUE,ISNUMBER(B14:$B$44),0))-LOOKUP(99^99,B$2:B13))*748))","v":106964},106964,1,{"$f":"IF(B14=\"\",\"\",ROUND(OFFSET(D14,MATCH(TRUE,INDEX(D15:D$44<>\"\",0),0),0),0))","v":125664},1389618,{"$f":"IF(OR(G14=\"HOL\",G14=\"SUN\",G14=\"SAT\",G14=\"No Read\",G14=\"\"),\"\",IF(INDEX(G14:$G$44,MATCH(TRUE,ISNUMBER(G14:$G$44),0))<LOOKUP(99^99,G$2:G13),(INDEX(G14:$G$44,MATCH(TRUE,ISNUMBER(G14:$G$44),0))*1000),(INDEX(G14:$G$44,MATCH(TRUE,ISNUMBER(G14:$G$44),0))-LOOKUP(99^99,G$2:G13))*1000))","v":359000},359000,1,{"$f":"IF(G14=\"\",\"\",ROUND(OFFSET(I14,MATCH(TRUE,INDEX(I15:I$44<>\"\",0),0),0),0))","v":379000},1973406,{"$f":"IF(OR(L14=\"HOL\",L14=\"SUN\",L14=\"SAT\",L14=\"No Read\",L14=\"\"),\"\",IF(INDEX(L14:$L$44,MATCH(TRUE,ISNUMBER(L14:$L$44),0))<LOOKUP(99^99,L$2:L13),(INDEX(L14:$L$44,MATCH(TRUE,ISNUMBER(L14:$L$44),0))*748),(INDEX(L14:$L$44,MATCH(TRUE,ISNUMBER(L14:$L$44),0))-LOOKUP(99^99,L$2:L13))*748))","v":353804},353804,1,{"$f":"IF(L14=\"\",\"\",ROUND(OFFSET(N14,MATCH(TRUE,INDEX(N15:N$44<>\"\",0),0),0),0))","v":430100},200143,{"$f":"IF(OR(Q14=\"HOL\",Q14=\"SUN\",Q14=\"SAT\",Q14=\"No Read\",Q14=\"\"),\"\",IF(INDEX(Q14:$Q$44,MATCH(TRUE,ISNUMBER(Q14:$Q$44),0))<LOOKUP(99^99,Q$2:Q13),(INDEX(Q14:$Q$44,MATCH(TRUE,ISNUMBER(Q14:$Q$44),0))*1000),(INDEX(Q14:$Q$44,MATCH(TRUE,ISNUMBER(Q14:$Q$44),0))-LOOKUP(99^99,Q$2:Q13))*1000))","v":0},0,1,{"$f":"IF(Q14=\"\",\"\",ROUND(OFFSET(S14,MATCH(TRUE,INDEX(S15:S$44<>\"\",0),0),0),0))","v":1000},null,null,null,null,null,null,null,null,null,7,380000]
[8,561001,{"$f":"IF(OR(B15=\"HOL\",B15=\"SUN\",B15=\"SAT\",B15=\"No Read\",B15=\"\"),\"\",IF(INDEX(B15:$B$44,MATCH(TRUE,ISNUMBER(B15:$B$44),0))<LOOKUP(99^99,B$2:B14),(INDEX(B15:$B$44,MATCH(TRUE,ISNUMBER(B15:$B$44),0))*748),(INDEX(B15:$B$44,MATCH(TRUE,ISNUMBER(B15:$B$44),0))-LOOKUP(99^99,B$2:B14))*748))","v":125664},125664,1,{"$f":"IF(B15=\"\",\"\",ROUND(OFFSET(D15,MATCH(TRUE,INDEX(D16:D$44<>\"\",0),0),0),0))","v":106964},1389997,{"$f":"IF(OR(G15=\"HOL\",G15=\"SUN\",G15=\"SAT\",G15=\"No Read\",G15=\"\"),\"\",IF(INDEX(G15:$G$44,MATCH(TRUE,ISNUMBER(G15:$G$44),0))<LOOKUP(99^99,G$2:G14),(INDEX(G15:$G$44,MATCH(TRUE,ISNUMBER(G15:$G$44),0))*1000),(INDEX(G15:$G$44,MATCH(TRUE,ISNUMBER(G15:$G$44),0))-LOOKUP(99^99,G$2:G14))*1000))","v":379000},379000,1,{"$f":"IF(G15=\"\",\"\",ROUND(OFFSET(I15,MATCH(TRUE,INDEX(I16:I$44<>\"\",0),0),0),0))","v":329000},1973981,{"$f":"IF(OR(L15=\"HOL\",L15=\"SUN\",L15=\"SAT\",L15=\"No Read\",L15=\"\"),\"\",IF(INDEX(L15:$L$44,MATCH(TRUE,ISNUMBER(L15:$L$44),0))<LOOKUP(99^99,L$2:L14),(INDEX(L15:$L$44,MATCH(TRUE,ISNUMBER(L15:$L$44),0))*748),(INDEX(L15:$L$44,MATCH(TRUE,ISNUMBER(L15:$L$44),0))-LOOKUP(99^99,L$2:L14))*748))","v":430100},430100,1,{"$f":"IF(L15=\"\",\"\",ROUND(OFFSET(N15,MATCH(TRUE,INDEX(N16:N$44<>\"\",0),0),0),0))","v":366520},200144,{"$f":"IF(OR(Q15=\"HOL\",Q15=\"SUN\",Q15=\"SAT\",Q15=\"No Read\",Q15=\"\"),\"\",IF(INDEX(Q15:$Q$44,MATCH(TRUE,ISNUMBER(Q15:$Q$44),0))<LOOKUP(99^99,Q$2:Q14),(INDEX(Q15:$Q$44,MATCH(TRUE,ISNUMBER(Q15:$Q$44),0))*1000),(INDEX(Q15:$Q$44,MATCH(TRUE,ISNUMBER(Q15:$Q$44),0))-LOOKUP(99^99,Q$2:Q14))*1000))","v":1000},1000,1,{"$f":"IF(Q15=\"\",\"\",ROUND(OFFSET(S15,MATCH(TRUE,INDEX(S16:S$44<>\"\",0),0),0),0))","v":0},null,null,null,null,null,null,null,null,null,8,329000]
[9,561144,{"$f":"IF(OR(B16=\"HOL\",B16=\"SUN\",B16=\"SAT\",B16=\"No Read\",B16=\"\"),\"\",IF(INDEX(B16:$B$44,MATCH(TRUE,ISNUMBER(B16:$B$44),0))<LOOKUP(99^99,B$2:B15),(INDEX(B16:$B$44,MATCH(TRUE,ISNUMBER(B16:$B$44),0))*748),(INDEX(B16:$B$44,MATCH(TRUE,ISNUMBER(B16:$B$44),0))-LOOKUP(99^99,B$2:B15))*748))","v":106964},106964,1,{"$f":"IF(B16=\"\",\"\",ROUND(OFFSET(D16,MATCH(TRUE,INDEX(D17:D$44<>\"\",0),0),0),0))","v":87516},1390326,{"$f":"IF(OR(G16=\"HOL\",G16=\"SUN\",G16=\"SAT\",G16=\"No Read\",G16=\"\"),\"\",IF(INDEX(G16:$G$44,MATCH(TRUE,ISNUMBER(G16:$G$44),0))<LOOKUP(99^99,G$2:G15),(INDEX(G16:$G$44,MATCH(TRUE,ISNUMBER(G16:$G$44),0))*1000),(INDEX(G16:$G$44,MATCH(TRUE,ISNUMBER(G16:$G$44),0))-LOOKUP(99^99,G$2:G15))*1000))","v":329000},329000,1,{"$f":"IF(G16=\"\",\"\",ROUND(OFFSET(I16,MATCH(TRUE,INDEX(I17:I$44<>\"\",0),0),0),0))","v":196000},1974471,{"$f":"IF(OR(L16=\"HOL\",L16=\"SUN\",L16=\"SAT\",L16=\"No Read\",L16=\"\"),\"\",IF(INDEX(L16:$L$44,MATCH(TRUE,ISNUMBER(L16:$L$44),0))<LOOKUP(99^99,L$2:L15),(INDEX(L16:$L$44,MATCH(TRUE,ISNUMBER(L16:$L$44),0))*748),(INDEX(L16:$L$44,MATCH(TRUE,ISNUMBER(L16:$L$44),0))-LOOKUP(99^99,L$2:L15))*748))","v":366520},366520,1,{"$f":"IF(L16=\"\",\"\",ROUND(OFFSET(N16,MATCH(TRUE,INDEX(N17:N$44<>\"\",0),0),0),0))","v":313412},200144,{"$f":"IF(OR(Q16=\"HOL\",Q16=\"SUN\",Q16=\"SAT\",Q16=\"No Read\",Q16=\"\"),\"\",IF(INDEX(Q16:$Q$44,MATCH(TRUE,ISNUMBER(Q16:$Q$44),0))<LOOKUP(99^99,Q$2:Q15),(INDEX(Q16:$Q$44,MATCH(TRUE,ISNUMBER(Q16:$Q$44),0))*1000),(INDEX(Q16:$Q$44,MATCH(TRUE,ISNUMBER(Q16:$Q$44),0))-LOOKUP(99^99,Q$2:Q15))*1000))","v":0},0,1,{"$f":"IF(Q16=\"\",\"\",ROUND(OFFSET(S16,MATCH(TRUE,INDEX(S17:S$44<>\"\",0),0),0),0))","v":1000},null,null,null,null,null,null,null,null,null,9,197000]
[10,561261,{"$f":"IF(OR(B17=\"HOL\",B17=\"SUN\",B17=\"SAT\",B17=\"No Read\",B17=\"\"),\"\",IF(INDEX(B17:$B$44,MATCH(TRUE,ISNUMBER(B17:$B$44),0))<LOOKUP(99^99,B$2:B16),(INDEX(B17:$B$44,MATCH(TRUE,ISNUMBER(B17:$B$44),0))*748),(INDEX(B17:$B$44,MATCH(TRUE,ISNUMBER(B17:$B$44),0))-LOOKUP(99^99,B$2:B16))*748))","v":87516},87516,1,{"$f":"IF(B17=\"\",\"\",ROUND(OFFSET(D17,MATCH(TRUE,INDEX(D18:D$44<>\"\",0),0),0),0))","v":120428},1390522,{"$f":"IF(OR(G17=\"HOL\",G17=\"SUN\",G17=\"SAT\",G17=\"No Read\",G17=\"\"),\"\",IF(INDEX(G17:$G$44,MATCH(TRUE,ISNUMBER(G17:$G$44),0))<LOOKUP(99^99,G$2:G16),(INDEX(G17:$G$44,MATCH(TRUE,ISNUMBER(G17:$G$44),0))*1000),(INDEX(G17:$G$44,MATCH(TRUE,ISNUMBER(G17:$G$44),0))-LOOKUP(99^99,G$2:G16))*1000))","v":196000},196000,1,{"$f":"IF(G17=\"\",\"\",ROUND(OFFSET(I17,MATCH(TRUE,INDEX(I18:I$44<>\"\",0),0),0),0))","v":245000},1974890,{"$f":"IF(OR(L17=\"HOL\",L17=\"SUN\",L17=\"SAT\",L17=\"No Read\",L17=\"\"),\"\",IF(INDEX(L17:$L$44,MATCH(TRUE,ISNUMBER(L17:$L$44),0))<LOOKUP(99^99,L$2:L16),(INDEX(L17:$L$44,MATCH(TRUE,ISNUMBER(L17:$L$44),0))*748),(INDEX(L17:$L$44,MATCH(TRUE,ISNUMBER(L17:$L$44),0))-LOOKUP(99^99,L$2:L16))*748))","v":313412},313412,1,{"$f":"IF(L17=\"\",\"\",ROUND(OFFSET(N17,MATCH(TRUE,INDEX(N18:N$44<>\"\",0),0),0),0))","v":404668},200145,{"$f":"IF(OR(Q17=\"HOL\",Q17=\"SUN\",Q17=\"SAT\",Q17=\"No Read\",Q17=\"\"),\"\",IF(INDEX(Q17:$Q$44,MATCH(TRUE,ISNUMBER(Q17:$Q$44),0))<LOOKUP(99^99,Q$2:Q16),(INDEX(Q17:$Q$44,MATCH(TRUE,ISNUMBER(Q17:$Q$44),0))*1000),(INDEX(Q17:$Q$44,MATCH(TRUE,ISNUMBER(Q17:$Q$44),0))-LOOKUP(99^99,Q$2:Q16))*1000))","v":1000},1000,1,{"$f":"IF(Q17=\"\",\"\",ROUND(OFFSET(S17,MATCH(TRUE,INDEX(S18:S$44<>\"\",0),0),0),0))","v":12000},null,null,null,null,null,null,null,null,null,10,257000]
[11,561422,{"$f":"IF(OR(B18=\"HOL\",B18=\"SUN\",B18=\"SAT\",B18=\"No Read\",B18=\"\"),\"\",IF(INDEX(B18:$B$44,MATCH(TRUE,ISNUMBER(B18:$B$44),0))<LOOKUP(99^99,B$2:B17),(INDEX(B18:$B$44,MATCH(TRUE,ISNUMBER(B18:$B$44),0))*748),(INDEX(B18:$B$44,MATCH(TRUE,ISNUMBER(B18:$B$44),0))-LOOKUP(99^99,B$2:B17))*748))","v":120428},{"$f":"IF(OR(B18=\"HOL\",B18=\"SUN\",B18=\"SAT\",B18=\"No Read\",B18=\"\"),\"\",ROUND(C18/E17,1))","v":120428},1,{"$f":"IF(B18=\"\",\"\",ROUND(OFFSET(D18,MATCH(TRUE,INDEX(D19:D$44<>\"\",0),0),0),0))","v":97988},1390767,{"$f":"IF(OR(G18=\"HOL\",G18=\"SUN\",G18=\"SAT\",G18=\"No Read\",G18=\"\"),\"\",IF(INDEX(G18:$G$44,MATCH(TRUE,ISNUMBER(G18:$G$44),0))<LOOKUP(99^99,G$2:G17),(INDEX(G18:$G$44,MATCH(TRUE,ISNUMBER(G18:$G$44),0))*1000),(INDEX(G18:$G$44,MATCH(TRUE,ISNUMBER(G18:$G$44),0))-LOOKUP(99^99,G$2:G17))*1000))","v":245000},{"$f":"IF(OR(G18=\"HOL\",G18=\"SUN\",G18=\"SAT\",G18=\"No Read\",G18=\"\"),\"\",ROUND(H18/J17,1))","v":245000},1,{"$f":"IF(G18=\"\",\"\",ROUND(OFFSET(I18,MATCH(TRUE,INDEX(I19:I$44<>\"\",0),0),0),0))","v":215000},1975431,{"$f":"IF(OR(L18=\"HOL\",L18=\"SUN\",L18=\"SAT\",L18=\"No Read\",L18=\"\"),\"\",IF(INDEX(L18:$L$44,MATCH(TRUE,ISNUMBER(L18:$L$44),0))<LOOKUP(99^99,L$2:L17),(INDEX(L18:$L$44,MATCH(TRUE,ISNUMBER(L18:$L$44),0))*748),(INDEX(L18:$L$44,MATCH(TRUE,ISNUMBER(L18:$L$44),0))-LOOKUP(99^99,L$2:L17))*748))","v":404668},{"$f":"IF(OR(L18=\"HOL\",L18=\"SUN\",L18=\"SAT\",L18=\"No Read\",L18=\"\"),\"\",ROUND(M18/O17,1))","v":404668},1,{"$f":"IF(L18=\"\",\"\",ROUND(OFFSET(N18,MATCH(TRUE,INDEX(N19:N$44<>\"\",0),0),0),0))","v":324632},200157,{"$f":"IF(OR(Q18=\"HOL\",Q18=\"SUN\",Q18=\"SAT\",Q18=\"No Read\",Q18=\"\"),\"\",IF(INDEX(Q18:$Q$44,MATCH(TRUE,ISNUMBER(Q18:$Q$44),0))<LOOKUP(99^99,Q$2:Q17),(INDEX(Q18:$Q$44,MATCH(TRUE,ISNUMBER(Q18:$Q$44),0))*1000),(INDEX(Q18:$Q$44,MATCH(TRUE,ISNUMBER(Q18:$Q$44),0))-LOOKUP(99^99,Q$2:Q17))*1000))","v":12000},{"$f":"IF(OR(Q18=\"HOL\",Q18=\"SUN\",Q18=\"SAT\",Q18=\"No Read\",Q18=\"\"),\"\",ROUND(R18/T17,1))","v":12000},1,{"$f":"IF(Q18=\"\",\"\",ROUND(OFFSET(S18,MATCH(TRUE,INDEX(S19:S$44<>\"\",0),0),0),0))","v":9000},null,null,"These four values can be entered instead of numbers",null,null,null,null,null,null,11,224000]
[12,561553,{"$f":"IF(OR(B19=\"HOL\",B19=\"SUN\",B19=\"SAT\",B19=\"No Read\",B19=\"\"),\"\",IF(INDEX(B19:$B$44,MATCH(TRUE,ISNUMBER(B19:$B$44),0))<LOOKUP(99^99,B$2:B18),(INDEX(B19:$B$44,MATCH(TRUE,ISNUMBER(B19:$B$44),0))*748),(INDEX(B19:$B$44,MATCH(TRUE,ISNUMBER(B19:$B$44),0))-LOOKUP(99^99,B$2:B18))*748))","v":97988},{"$f":"IF(OR(B19=\"HOL\",B19=\"SUN\",B19=\"SAT\",B19=\"No Read\",B19=\"\"),\"\",ROUND(C19/E18,1))","v":97988},1,{"$f":"IF(B19=\"\",\"\",ROUND(OFFSET(D19,MATCH(TRUE,INDEX(D20:D$44<>\"\",0),0),0),0))","v":112200},1390982,{"$f":"IF(OR(G19=\"HOL\",G19=\"SUN\",G19=\"SAT\",G19=\"No Read\",G19=\"\"),\"\",IF(INDEX(G19:$G$44,MATCH(TRUE,ISNUMBER(G19:$G$44),0))<LOOKUP(99^99,G$2:G18),(INDEX(G19:$G$44,MATCH(TRUE,ISNUMBER(G19:$G$44),0))*1000),(INDEX(G19:$G$44,MATCH(TRUE,ISNUMBER(G19:$G$44),0))-LOOKUP(99^99,G$2:G18))*1000))","v":215000},{"$f":"IF(OR(G19=\"HOL\",G19=\"SUN\",G19=\"SAT\",G19=\"No Read\",G19=\"\"),\"\",ROUND(H19/J18,1))","v":215000},1,{"$f":"IF(G19=\"\",\"\",ROUND(OFFSET(I19,MATCH(TRUE,INDEX(I20:I$44<>\"\",0),0),0),0))","v":248000},1975865,{"$f":"IF(OR(L19=\"HOL\",L19=\"SUN\",L19=\"SAT\",L19=\"No Read\",L19=\"\"),\"\",IF(INDEX(L19:$L$44,MATCH(TRUE,ISNUMBER(L19:$L$44),0))<LOOKUP(99^99,L$2:L18),(INDEX(L19:$L$44,MATCH(TRUE,ISNUMBER(L19:$L$44),0))*748),(INDEX(L19:$L$44,MATCH(TRUE,ISNUMBER(L19:$L$44),0))-LOOKUP(99^99,L$2:L18))*748))","v":324632},{"$f":"IF(OR(L19=\"HOL\",L19=\"SUN\",L19=\"SAT\",L19=\"No Read\",L19=\"\"),\"\",ROUND(M19/O18,1))","v":324632},1,{"$f":"IF(L19=\"\",\"\",ROUND(OFFSET(N19,MATCH(TRUE,INDEX(N20:N$44<>\"\",0),0),0),0))","v":385220},200166,{"$f":"IF(OR(Q19=\"HOL\",Q19=\"SUN\",Q19=\"SAT\",Q19=\"No Read\",Q19=\"\"),\"\",IF(INDEX(Q19:$Q$44,MATCH(TRUE,ISNUMBER(Q19:$Q$44),0))<LOOKUP(99^99,Q$2:Q18),(INDEX(Q19:$Q$44,MATCH(TRUE,ISNUMBER(Q19:$Q$44),0))*1000),(INDEX(Q19:$Q$44,MATCH(TRUE,ISNUMBER(Q19:$Q$44),0))-LOOKUP(99^99,Q$2:Q18))*1000))","v":9000},{"$f":"IF(OR(Q19=\"HOL\",Q19=\"SUN\",Q19=\"SAT\",Q19=\"No Read\",Q19=\"\"),\"\",ROUND(R19/T18,1))","v":9000},1,{"$f":"IF(Q19=\"\",\"\",ROUND(OFFSET(S19,MATCH(TRUE,INDEX(S20:S$44<>\"\",0),0),0),0))","v":1000},null,null,"SAT - Saturday",null,null,null,null,null,null,12,249000]
[13,561703,{"$f":"IF(OR(B20=\"HOL\",B20=\"SUN\",B20=\"SAT\",B20=\"No Read\",B20=\"\"),\"\",IF(INDEX(B20:$B$44,MATCH(TRUE,ISNUMBER(B20:$B$44),0))<LOOKUP(99^99,B$2:B19),(INDEX(B20:$B$44,MATCH(TRUE,ISNUMBER(B20:$B$44),0))*748),(INDEX(B20:$B$44,MATCH(TRUE,ISNUMBER(B20:$B$44),0))-LOOKUP(99^99,B$2:B19))*748))","v":112200},112200,1,{"$f":"IF(B20=\"\",\"\",ROUND(OFFSET(D20,MATCH(TRUE,INDEX(D21:D$44<>\"\",0),0),0),0))","v":116688},1391230,{"$f":"IF(OR(G20=\"HOL\",G20=\"SUN\",G20=\"SAT\",G20=\"No Read\",G20=\"\"),\"\",IF(INDEX(G20:$G$44,MATCH(TRUE,ISNUMBER(G20:$G$44),0))<LOOKUP(99^99,G$2:G19),(INDEX(G20:$G$44,MATCH(TRUE,ISNUMBER(G20:$G$44),0))*1000),(INDEX(G20:$G$44,MATCH(TRUE,ISNUMBER(G20:$G$44),0))-LOOKUP(99^99,G$2:G19))*1000))","v":248000},248000,1,{"$f":"IF(G20=\"\",\"\",ROUND(OFFSET(I20,MATCH(TRUE,INDEX(I21:I$44<>\"\",0),0),0),0))","v":274000},1976380,{"$f":"IF(OR(L20=\"HOL\",L20=\"SUN\",L20=\"SAT\",L20=\"No Read\",L20=\"\"),\"\",IF(INDEX(L20:$L$44,MATCH(TRUE,ISNUMBER(L20:$L$44),0))<LOOKUP(99^99,L$2:L19),(INDEX(L20:$L$44,MATCH(TRUE,ISNUMBER(L20:$L$44),0))*748),(INDEX(L20:$L$44,MATCH(TRUE,ISNUMBER(L20:$L$44),0))-LOOKUP(99^99,L$2:L19))*748))","v":385220},385220,1,{"$f":"IF(L20=\"\",\"\",ROUND(OFFSET(N20,MATCH(TRUE,INDEX(N21:N$44<>\"\",0),0),0),0))","v":403172},200167,{"$f":"IF(OR(Q20=\"HOL\",Q20=\"SUN\",Q20=\"SAT\",Q20=\"No Read\",Q20=\"\"),\"\",IF(INDEX(Q20:$Q$44,MATCH(TRUE,ISNUMBER(Q20:$Q$44),0))<LOOKUP(99^99,Q$2:Q19),(INDEX(Q20:$Q$44,MATCH(TRUE,ISNUMBER(Q20:$Q$44),0))*1000),(INDEX(Q20:$Q$44,MATCH(TRUE,ISNUMBER(Q20:$Q$44),0))-LOOKUP(99^99,Q$2:Q19))*1000))","v":1000},1000,1,{"$f":"IF(Q20=\"\",\"\",ROUND(OFFSET(S20,MATCH(TRUE,INDEX(S21:S$44<>\"\",0),0),0),0))","v":0},null,null,"SUN - Sunday",null,null,null,null,null,null,13,274000]
[14,561859,{"$f":"IF(OR(B21=\"HOL\",B21=\"SUN\",B21=\"SAT\",B21=\"No Read\",B21=\"\"),\"\",IF(INDEX(B21:$B$44,MATCH(TRUE,ISNUMBER(B21:$B$44),0))<LOOKUP(99^99,B$2:B20),(INDEX(B21:$B$44,MATCH(TRUE,ISNUMBER(B21:$B$44),0))*748),(INDEX(B21:$B$44,MATCH(TRUE,ISNUMBER(B21:$B$44),0))-LOOKUP(99^99,B$2:B20))*748))","v":116688},116688,1,{"$f":"IF(B21=\"\",\"\",ROUND(OFFSET(D21,MATCH(TRUE,INDEX(D22:D$44<>\"\",0),0),0),0))","v":103224},1391504,{"$f":"IF(OR(G21=\"HOL\",G21=\"SUN\",G21=\"SAT\",G21=\"No Read\",G21=\"\"),\"\",IF(INDEX(G21:$G$44,MATCH(TRUE,ISNUMBER(G21:$G$44),0))<LOOKUP(99^99,G$2:G20),(INDEX(G21:$G$44,MATCH(TRUE,ISNUMBER(G21:$G$44),0))*1000),(INDEX(G21:$G$44,MATCH(TRUE,ISNUMBER(G21:$G$44),0))-LOOKUP(99^99,G$2:G20))*1000))","v":274000},274000,1,{"$f":"IF(G21=\"\",\"\",ROUND(OFFSET(I21,MATCH(TRUE,INDEX(I22:I$44<>\"\",0),0),0),0))","v":232000},1976919,{"$f":"IF(OR(L21=\"HOL\",L21=\"SUN\",L21=\"SAT\",L21=\"No Read\",L21=\"\"),\"\",IF(INDEX(L21:$L$44,MATCH(TRUE,ISNUMBER(L21:$L$44),0))<LOOKUP(99^99,L$2:L20),(INDEX(L21:$L$44,MATCH(TRUE,ISNUMBER(L21:$L$44),0))*748),(INDEX(L21:$L$44,MATCH(TRUE,ISNUMBER(L21:$L$44),0))-LOOKUP(99^99,L$2:L20))*748))","v":403172},403172,1,{"$f":"IF(L21=\"\",\"\",ROUND(OFFSET(N21,MATCH(TRUE,INDEX(N22:N$44<>\"\",0),0),0),0))","v":358292},200167,{"$f":"IF(OR(Q21=\"HOL\",Q21=\"SUN\",Q21=\"SAT\",Q21=\"No Read\",Q21=\"\"),\"\",IF(INDEX(Q21:$Q$44,MATCH(TRUE,ISNUMBER(Q21:$Q$44),0))<LOOKUP(99^99,Q$2:Q20),(INDEX(Q21:$Q$44,MATCH(TRUE,ISNUMBER(Q21:$Q$44),0))*1000),(INDEX(Q21:$Q$44,MATCH(TRUE,ISNUMBER(Q21:$Q$44),0))-LOOKUP(99^99,Q$2:Q20))*1000))","v":0},0,1,{"$f":"IF(Q21=\"\",\"\",ROUND(OFFSET(S21,MATCH(TRUE,INDEX(S22:S$44<>\"\",0),0),0),0))","v":0},null,null,"HOL - Holiday",null,null,null,null,null,null,14,232000]
[15,561997,{"$f":"IF(OR(B22=\"HOL\",B22=\"SUN\",B22=\"SAT\",B22=\"No Read\",B22=\"\"),\"\",IF(INDEX(B22:$B$44,MATCH(TRUE,ISNUMBER(B22:$B$44),0))<LOOKUP(99^99,B$2:B21),(INDEX(B22:$B$44,MATCH(TRUE,ISNUMBER(B22:$B$44),0))*748),(INDEX(B22:$B$44,MATCH(TRUE,ISNUMBER(B22:$B$44),0))-LOOKUP(99^99,B$2:B21))*748))","v":103224},103224,1,{"$f":"IF(B22=\"\",\"\",ROUND(OFFSET(D22,MATCH(TRUE,INDEX(D23:D$44<>\"\",0),0),0),0))","v":147356},1391736,{"$f":"IF(OR(G22=\"HOL\",G22=\"SUN\",G22=\"SAT\",G22=\"No Read\",G22=\"\"),\"\",IF(INDEX(G22:$G$44,MATCH(TRUE,ISNUMBER(G22:$G$44),0))<LOOKUP(99^99,G$2:G21),(INDEX(G22:$G$44,MATCH(TRUE,ISNUMBER(G22:$G$44),0))*1000),(INDEX(G22:$G$44,MATCH(TRUE,ISNUMBER(G22:$G$44),0))-LOOKUP(99^99,G$2:G21))*1000))","v":232000},232000,1,{"$f":"IF(G22=\"\",\"\",ROUND(OFFSET(I22,MATCH(TRUE,INDEX(I23:I$44<>\"\",0),0),0),0))","v":279000},1977398,{"$f":"IF(OR(L22=\"HOL\",L22=\"SUN\",L22=\"SAT\",L22=\"No Read\",L22=\"\"),\"\",IF(INDEX(L22:$L$44,MATCH(TRUE,ISNUMBER(L22:$L$44),0))<LOOKUP(99^99,L$2:L21),(INDEX(L22:$L$44,MATCH(TRUE,ISNUMBER(L22:$L$44),0))*748),(INDEX(L22:$L$44,MATCH(TRUE,ISNUMBER(L22:$L$44),0))-LOOKUP(99^99,L$2:L21))*748))","v":358292},358292,1,{"$f":"IF(L22=\"\",\"\",ROUND(OFFSET(N22,MATCH(TRUE,INDEX(N23:N$44<>\"\",0),0),0),0))","v":489940},200167,{"$f":"IF(OR(Q22=\"HOL\",Q22=\"SUN\",Q22=\"SAT\",Q22=\"No Read\",Q22=\"\"),\"\",IF(INDEX(Q22:$Q$44,MATCH(TRUE,ISNUMBER(Q22:$Q$44),0))<LOOKUP(99^99,Q$2:Q21),(INDEX(Q22:$Q$44,MATCH(TRUE,ISNUMBER(Q22:$Q$44),0))*1000),(INDEX(Q22:$Q$44,MATCH(TRUE,ISNUMBER(Q22:$Q$44),0))-LOOKUP(99^99,Q$2:Q21))*1000))","v":0},0,1,{"$f":"IF(Q22=\"\",\"\",ROUND(OFFSET(S22,MATCH(TRUE,INDEX(S23:S$44<>\"\",0),0),0),0))","v":0},null,null,"NO READ - A day when a reading was not taken",null,null,null,null,null,null,15,279000]
[16,562194,{"$f":"IF(OR(B23=\"HOL\",B23=\"SUN\",B23=\"SAT\",B23=\"No Read\",B23=\"\"),\"\",IF(INDEX(B23:$B$44,MATCH(TRUE,ISNUMBER(B23:$B$44),0))<LOOKUP(99^99,B$2:B22),(INDEX(B23:$B$44,MATCH(TRUE,ISNUMBER(B23:$B$44),0))*748),(INDEX(B23:$B$44,MATCH(TRUE,ISNUMBER(B23:$B$44),0))-LOOKUP(99^99,B$2:B22))*748))","v":147356},{"$f":"IF(OR(B23=\"HOL\",B23=\"SUN\",B23=\"SAT\",B23=\"No Read\",B23=\"\"),\"\",ROUND(C23/E22,1))","v":147356},1,{"$f":"IF(B23=\"\",\"\",ROUND(OFFSET(D23,MATCH(TRUE,INDEX(D24:D$44<>\"\",0),0),0),0))","v":106964},"NO READ",{"$f":"IF(OR(G23=\"HOL\",G23=\"SUN\",G23=\"SAT\",G23=\"No Read\",G23=\"\"),\"\",IF(INDEX(G23:$G$44,MATCH(TRUE,ISNUMBER(G23:$G$44),0))<LOOKUP(99^99,G$2:G22),(INDEX(G23:$G$44,MATCH(TRUE,ISNUMBER(G23:$G$44),0))*1000),(INDEX(G23:$G$44,MATCH(TRUE,ISNUMBER(G23:$G$44),0))-LOOKUP(99^99,G$2:G22))*1000))","v":""},{"$f":"IF(OR(G23=\"HOL\",G23=\"SUN\",G23=\"SAT\",G23=\"No Read\",G23=\"\"),\"\",ROUND(H23/J22,1))","v":""},2,{"$f":"IF(G23=\"\",\"\",ROUND(OFFSET(I23,MATCH(TRUE,INDEX(I24:I$44<>\"\",0),0),0),0))","v":279000},1978053,{"$f":"IF(OR(L23=\"HOL\",L23=\"SUN\",L23=\"SAT\",L23=\"No Read\",L23=\"\"),\"\",IF(INDEX(L23:$L$44,MATCH(TRUE,ISNUMBER(L23:$L$44),0))<LOOKUP(99^99,L$2:L22),(INDEX(L23:$L$44,MATCH(TRUE,ISNUMBER(L23:$L$44),0))*748),(INDEX(L23:$L$44,MATCH(TRUE,ISNUMBER(L23:$L$44),0))-LOOKUP(99^99,L$2:L22))*748))","v":489940},{"$f":"IF(OR(L23=\"HOL\",L23=\"SUN\",L23=\"SAT\",L23=\"No Read\",L23=\"\"),\"\",ROUND(M23/O22,1))","v":489940},1,{"$f":"IF(L23=\"\",\"\",ROUND(OFFSET(N23,MATCH(TRUE,INDEX(N24:N$44<>\"\",0),0),0),0))","v":365772},200167,{"$f":"IF(OR(Q23=\"HOL\",Q23=\"SUN\",Q23=\"SAT\",Q23=\"No Read\",Q23=\"\"),\"\",IF(INDEX(Q23:$Q$44,MATCH(TRUE,ISNUMBER(Q23:$Q$44),0))<LOOKUP(99^99,Q$2:Q22),(INDEX(Q23:$Q$44,MATCH(TRUE,ISNUMBER(Q23:$Q$44),0))*1000),(INDEX(Q23:$Q$44,MATCH(TRUE,ISNUMBER(Q23:$Q$44),0))-LOOKUP(99^99,Q$2:Q22))*1000))","v":0},{"$f":"IF(OR(Q23=\"HOL\",Q23=\"SUN\",Q23=\"SAT\",Q23=\"No Read\",Q23=\"\"),\"\",ROUND(R23/T22,1))","v":0},1,{"$f":"IF(Q23=\"\",\"\",ROUND(OFFSET(S23,MATCH(TRUE,INDEX(S24:S$44<>\"\",0),0),0),0))","v":0},null,null,null,null,null,null,null,null,null,16,279000]
[17,562337,{"$f":"IF(OR(B24=\"HOL\",B24=\"SUN\",B24=\"SAT\",B24=\"No Read\",B24=\"\"),\"\",IF(INDEX(B24:$B$44,MATCH(TRUE,ISNUMBER(B24:$B$44),0))<LOOKUP(99^99,B$2:B23),(INDEX(B24:$B$44,MATCH(TRUE,ISNUMBER(B24:$B$44),0))*748),(INDEX(B24:$B$44,MATCH(TRUE,ISNUMBER(B24:$B$44),0))-LOOKUP(99^99,B$2:B23))*748))","v":106964},{"$f":"IF(OR(B24=\"HOL\",B24=\"SUN\",B24=\"SAT\",B24=\"No Read\",B24=\"\"),\"\",ROUND(C24/E23,1))","v":106964},1,{"$f":"IF(B24=\"\",\"\",ROUND(OFFSET(D24,MATCH(TRUE,INDEX(D25:D$44<>\"\",0),0),0),0))","v":155584},1392294,{"$f":"IF(OR(G24=\"HOL\",G24=\"SUN\",G24=\"SAT\",G24=\"No Read\",G24=\"\"),\"\",IF(INDEX(G24:$G$44,MATCH(TRUE,ISNUMBER(G24:$G$44),0))<LOOKUP(99^99,G$2:G23),(INDEX(G24:$G$44,MATCH(TRUE,ISNUMBER(G24:$G$44),0))*1000),(INDEX(G24:$G$44,MATCH(TRUE,ISNUMBER(G24:$G$44),0))-LOOKUP(99^99,G$2:G23))*1000))","v":558000},{"$f":"IF(OR(G24=\"HOL\",G24=\"SUN\",G24=\"SAT\",G24=\"No Read\",G24=\"\"),\"\",ROUND(H24/J23,1))","v":279000},1,{"$f":"IF(G24=\"\",\"\",ROUND(OFFSET(I24,MATCH(TRUE,INDEX(I25:I$44<>\"\",0),0),0),0))","v":366000},1978542,{"$f":"IF(OR(L24=\"HOL\",L24=\"SUN\",L24=\"SAT\",L24=\"No Read\",L24=\"\"),\"\",IF(INDEX(L24:$L$44,MATCH(TRUE,ISNUMBER(L24:$L$44),0))<LOOKUP(99^99,L$2:L23),(INDEX(L24:$L$44,MATCH(TRUE,ISNUMBER(L24:$L$44),0))*748),(INDEX(L24:$L$44,MATCH(TRUE,ISNUMBER(L24:$L$44),0))-LOOKUP(99^99,L$2:L23))*748))","v":365772},{"$f":"IF(OR(L24=\"HOL\",L24=\"SUN\",L24=\"SAT\",L24=\"No Read\",L24=\"\"),\"\",ROUND(M24/O23,1))","v":365772},1,{"$f":"IF(L24=\"\",\"\",ROUND(OFFSET(N24,MATCH(TRUE,INDEX(N25:N$44<>\"\",0),0),0),0))","v":540804},200167,{"$f":"IF(OR(Q24=\"HOL\",Q24=\"SUN\",Q24=\"SAT\",Q24=\"No Read\",Q24=\"\"),\"\",IF(INDEX(Q24:$Q$44,MATCH(TRUE,ISNUMBER(Q24:$Q$44),0))<LOOKUP(99^99,Q$2:Q23),(INDEX(Q24:$Q$44,MATCH(TRUE,ISNUMBER(Q24:$Q$44),0))*1000),(INDEX(Q24:$Q$44,MATCH(TRUE,ISNUMBER(Q24:$Q$44),0))-LOOKUP(99^99,Q$2:Q23))*1000))","v":0},{"$f":"IF(OR(Q24=\"HOL\",Q24=\"SUN\",Q24=\"SAT\",Q24=\"No Read\",Q24=\"\"),\"\",ROUND(R24/T23,1))","v":0},1,{"$f":"IF(Q24=\"\",\"\",ROUND(OFFSET(S24,MATCH(TRUE,INDEX(S25:S$44<>\"\",0),0),0),0))","v":12000},null,null,null,null,null,null,null,null,null,17,378000]
[18,562545,{"$f":"IF(OR(B25=\"HOL\",B25=\"SUN\",B25=\"SAT\",B25=\"No Read\",B25=\"\"),\"\",IF(INDEX(B25:$B$44,MATCH(TRUE,ISNUMBER(B25:$B$44),0))<LOOKUP(99^99,B$2:B24),(INDEX(B25:$B$44,MATCH(TRUE,ISNUMBER(B25:$B$44),0))*748),(INDEX(B25:$B$44,MATCH(TRUE,ISNUMBER(B25:$B$44),0))-LOOKUP(99^99,B$2:B24))*748))","v":155584},155584,1,{"$f":"IF(B25=\"\",\"\",ROUND(OFFSET(D25,MATCH(TRUE,INDEX(D26:D$44<>\"\",0),0),0),0))","v":89012},1392660,{"$f":"IF(OR(G25=\"HOL\",G25=\"SUN\",G25=\"SAT\",G25=\"No Read\",G25=\"\"),\"\",IF(INDEX(G25:$G$44,MATCH(TRUE,ISNUMBER(G25:$G$44),0))<LOOKUP(99^99,G$2:G24),(INDEX(G25:$G$44,MATCH(TRUE,ISNUMBER(G25:$G$44),0))*1000),(INDEX(G25:$G$44,MATCH(TRUE,ISNUMBER(G25:$G$44),0))-LOOKUP(99^99,G$2:G24))*1000))","v":366000},366000,1,{"$f":"IF(G25=\"\",\"\",ROUND(OFFSET(I25,MATCH(TRUE,INDEX(I26:I$44<>\"\",0),0),0),0))","v":197000},1979265,{"$f":"IF(OR(L25=\"HOL\",L25=\"SUN\",L25=\"SAT\",L25=\"No Read\",L25=\"\"),\"\",IF(INDEX(L25:$L$44,MATCH(TRUE,ISNUMBER(L25:$L$44),0))<LOOKUP(99^99,L$2:L24),(INDEX(L25:$L$44,MATCH(TRUE,ISNUMBER(L25:$L$44),0))*748),(INDEX(L25:$L$44,MATCH(TRUE,ISNUMBER(L25:$L$44),0))-LOOKUP(99^99,L$2:L24))*748))","v":540804},540804,1,{"$f":"IF(L25=\"\",\"\",ROUND(OFFSET(N25,MATCH(TRUE,INDEX(N26:N$44<>\"\",0),0),0),0))","v":299200},200179,{"$f":"IF(OR(Q25=\"HOL\",Q25=\"SUN\",Q25=\"SAT\",Q25=\"No Read\",Q25=\"\"),\"\",IF(INDEX(Q25:$Q$44,MATCH(TRUE,ISNUMBER(Q25:$Q$44),0))<LOOKUP(99^99,Q$2:Q24),(INDEX(Q25:$Q$44,MATCH(TRUE,ISNUMBER(Q25:$Q$44),0))*1000),(INDEX(Q25:$Q$44,MATCH(TRUE,ISNUMBER(Q25:$Q$44),0))-LOOKUP(99^99,Q$2:Q24))*1000))","v":12000},12000,1,{"$f":"IF(Q25=\"\",\"\",ROUND(OFFSET(S25,MATCH(TRUE,INDEX(S26:S$44<>\"\",0),0),0),0))","v":12000},null,null,null,null,null,null,null,null,null,18,209000]
[19,562664,{"$f":"IF(OR(B26=\"HOL\",B26=\"SUN\",B26=\"SAT\",B26=\"No Read\",B26=\"\"),\"\",IF(INDEX(B26:$B$44,MATCH(TRUE,ISNUMBER(B26:$B$44),0))<LOOKUP(99^99,B$2:B25),(INDEX(B26:$B$44,MATCH(TRUE,ISNUMBER(B26:$B$44),0))*748),(INDEX(B26:$B$44,MATCH(TRUE,ISNUMBER(B26:$B$44),0))-LOOKUP(99^99,B$2:B25))*748))","v":89012},89012,1,{"$f":"IF(B26=\"\",\"\",ROUND(OFFSET(D26,MATCH(TRUE,INDEX(D27:D$44<>\"\",0),0),0),0))","v":92004},1392857,{"$f":"IF(OR(G26=\"HOL\",G26=\"SUN\",G26=\"SAT\",G26=\"No Read\",G26=\"\"),\"\",IF(INDEX(G26:$G$44,MATCH(TRUE,ISNUMBER(G26:$G$44),0))<LOOKUP(99^99,G$2:G25),(INDEX(G26:$G$44,MATCH(TRUE,ISNUMBER(G26:$G$44),0))*1000),(INDEX(G26:$G$44,MATCH(TRUE,ISNUMBER(G26:$G$44),0))-LOOKUP(99^99,G$2:G25))*1000))","v":197000},197000,1,{"$f":"IF(G26=\"\",\"\",ROUND(OFFSET(I26,MATCH(TRUE,INDEX(I27:I$44<>\"\",0),0),0),0))","v":91000},1979665,{"$f":"IF(OR(L26=\"HOL\",L26=\"SUN\",L26=\"SAT\",L26=\"No Read\",L26=\"\"),\"\",IF(INDEX(L26:$L$44,MATCH(TRUE,ISNUMBER(L26:$L$44),0))<LOOKUP(99^99,L$2:L25),(INDEX(L26:$L$44,MATCH(TRUE,ISNUMBER(L26:$L$44),0))*748),(INDEX(L26:$L$44,MATCH(TRUE,ISNUMBER(L26:$L$44),0))-LOOKUP(99^99,L$2:L25))*748))","v":299200},299200,1,{"$f":"IF(L26=\"\",\"\",ROUND(OFFSET(N26,MATCH(TRUE,INDEX(N27:N$44<>\"\",0),0),0),0))","v":326128},200191,{"$f":"IF(OR(Q26=\"HOL\",Q26=\"SUN\",Q26=\"SAT\",Q26=\"No Read\",Q26=\"\"),\"\",IF(INDEX(Q26:$Q$44,MATCH(TRUE,ISNUMBER(Q26:$Q$44),0))<LOOKUP(99^99,Q$2:Q25),(INDEX(Q26:$Q$44,MATCH(TRUE,ISNUMBER(Q26:$Q$44),0))*1000),(INDEX(Q26:$Q$44,MATCH(TRUE,ISNUMBER(Q26:$Q$44),0))-LOOKUP(99^99,Q$2:Q25))*1000))","v":12000},12000,1,{"$f":"IF(Q26=\"\",\"\",ROUND(OFFSET(S26,MATCH(TRUE,INDEX(S27:S$44<>\"\",0),0),0),0))","v":0},null,null,null,null,null,null,null,null,null,19,91000]
[20,562787,{"$f":"IF(OR(B27=\"HOL\",B27=\"SUN\",B27=\"SAT\",B27=\"No Read\",B27=\"\"),\"\",IF(INDEX(B27:$B$44,MATCH(TRUE,ISNUMBER(B27:$B$44),0))<LOOKUP(99^99,B$2:B26),(INDEX(B27:$B$44,MATCH(TRUE,ISNUMBER(B27:$B$44),0))*748),(INDEX(B27:$B$44,MATCH(TRUE,ISNUMBER(B27:$B$44),0))-LOOKUP(99^99,B$2:B26))*748))","v":92004},92004,1,{"$f":"IF(B27=\"\",\"\",ROUND(OFFSET(D27,MATCH(TRUE,INDEX(D28:D$44<>\"\",0),0),0),0))","v":73304},1392948,{"$f":"IF(OR(G27=\"HOL\",G27=\"SUN\",G27=\"SAT\",G27=\"No Read\",G27=\"\"),\"\",IF(INDEX(G27:$G$44,MATCH(TRUE,ISNUMBER(G27:$G$44),0))<LOOKUP(99^99,G$2:G26),(INDEX(G27:$G$44,MATCH(TRUE,ISNUMBER(G27:$G$44),0))*1000),(INDEX(G27:$G$44,MATCH(TRUE,ISNUMBER(G27:$G$44),0))-LOOKUP(99^99,G$2:G26))*1000))","v":91000},91000,1,{"$f":"IF(G27=\"\",\"\",ROUND(OFFSET(I27,MATCH(TRUE,INDEX(I28:I$44<>\"\",0),0),0),0))","v":65000},1980101,{"$f":"IF(OR(L27=\"HOL\",L27=\"SUN\",L27=\"SAT\",L27=\"No Read\",L27=\"\"),\"\",IF(INDEX(L27:$L$44,MATCH(TRUE,ISNUMBER(L27:$L$44),0))<LOOKUP(99^99,L$2:L26),(INDEX(L27:$L$44,MATCH(TRUE,ISNUMBER(L27:$L$44),0))*748),(INDEX(L27:$L$44,MATCH(TRUE,ISNUMBER(L27:$L$44),0))-LOOKUP(99^99,L$2:L26))*748))","v":326128},326128,1,{"$f":"IF(L27=\"\",\"\",ROUND(OFFSET(N27,MATCH(TRUE,INDEX(N28:N$44<>\"\",0),0),0),0))","v":240856},200191,{"$f":"IF(OR(Q27=\"HOL\",Q27=\"SUN\",Q27=\"SAT\",Q27=\"No Read\",Q27=\"\"),\"\",IF(INDEX(Q27:$Q$44,MATCH(TRUE,ISNUMBER(Q27:$Q$44),0))<LOOKUP(99^99,Q$2:Q26),(INDEX(Q27:$Q$44,MATCH(TRUE,ISNUMBER(Q27:$Q$44),0))*1000),(INDEX(Q27:$Q$44,MATCH(TRUE,ISNUMBER(Q27:$Q$44),0))-LOOKUP(99^99,Q$2:Q26))*1000))","v":0},0,1,{"$f":"IF(Q27=\"\",\"\",ROUND(OFFSET(S27,MATCH(TRUE,INDEX(S28:S$44<>\"\",0),0),0),0))","v":0},null,null,null,null,null,null,null,null,null,20,65000]
[21,562885,{"$f":"IF(OR(B28=\"HOL\",B28=\"SUN\",B28=\"SAT\",B28=\"No Read\",B28=\"\"),\"\",IF(INDEX(B28:$B$44,MATCH(TRUE,ISNUMBER(B28:$B$44),0))<LOOKUP(99^99,B$2:B27),(INDEX(B28:$B$44,MATCH(TRUE,ISNUMBER(B28:$B$44),0))*748),(INDEX(B28:$B$44,MATCH(TRUE,ISNUMBER(B28:$B$44),0))-LOOKUP(99^99,B$2:B27))*748))","v":73304},73304,1,{"$f":"IF(B28=\"\",\"\",ROUND(OFFSET(D28,MATCH(TRUE,INDEX(D29:D$44<>\"\",0),0),0),0))","v":39644},1393013,{"$f":"IF(OR(G28=\"HOL\",G28=\"SUN\",G28=\"SAT\",G28=\"No Read\",G28=\"\"),\"\",IF(INDEX(G28:$G$44,MATCH(TRUE,ISNUMBER(G28:$G$44),0))<LOOKUP(99^99,G$2:G27),(INDEX(G28:$G$44,MATCH(TRUE,ISNUMBER(G28:$G$44),0))*1000),(INDEX(G28:$G$44,MATCH(TRUE,ISNUMBER(G28:$G$44),0))-LOOKUP(99^99,G$2:G27))*1000))","v":65000},65000,1,{"$f":"IF(G28=\"\",\"\",ROUND(OFFSET(I28,MATCH(TRUE,INDEX(I29:I$44<>\"\",0),0),0),0))","v":56000},1980423,{"$f":"IF(OR(L28=\"HOL\",L28=\"SUN\",L28=\"SAT\",L28=\"No Read\",L28=\"\"),\"\",IF(INDEX(L28:$L$44,MATCH(TRUE,ISNUMBER(L28:$L$44),0))<LOOKUP(99^99,L$2:L27),(INDEX(L28:$L$44,MATCH(TRUE,ISNUMBER(L28:$L$44),0))*748),(INDEX(L28:$L$44,MATCH(TRUE,ISNUMBER(L28:$L$44),0))-LOOKUP(99^99,L$2:L27))*748))","v":240856},240856,1,{"$f":"IF(L28=\"\",\"\",ROUND(OFFSET(N28,MATCH(TRUE,INDEX(N29:N$44<>\"\",0),0),0),0))","v":125664},200191,{"$f":"IF(OR(Q28=\"HOL\",Q28=\"SUN\",Q28=\"SAT\",Q28=\"No Read\",Q28=\"\"),\"\",IF(INDEX(Q28:$Q$44,MATCH(TRUE,ISNUMBER(Q28:$Q$44),0))<LOOKUP(99^99,Q$2:Q27),(INDEX(Q28:$Q$44,MATCH(TRUE,ISNUMBER(Q28:$Q$44),0))*1000),(INDEX(Q28:$Q$44,MATCH(TRUE,ISNUMBER(Q28:$Q$44),0))-LOOKUP(99^99,Q$2:Q27))*1000))","v":0},0,1,{"$f":"IF(Q28=\"\",\"\",ROUND(OFFSET(S28,MATCH(TRUE,INDEX(S29:S$44<>\"\",0),0),0),0))","v":0},null,null,null,null,null,null,null,null,null,21,56000]
[22,562938,{"$f":"IF(OR(B29=\"HOL\",B29=\"SUN\",B29=\"SAT\",B29=\"No Read\",B29=\"\"),\"\",IF(INDEX(B29:$B$44,MATCH(TRUE,ISNUMBER(B29:$B$44),0))<LOOKUP(99^99,B$2:B28),(INDEX(B29:$B$44,MATCH(TRUE,ISNUMBER(B29:$B$44),0))*748),(INDEX(B29:$B$44,MATCH(TRUE,ISNUMBER(B29:$B$44),0))-LOOKUP(99^99,B$2:B28))*748))","v":39644},39644,1,{"$f":"IF(B29=\"\",\"\",ROUND(OFFSET(D29,MATCH(TRUE,INDEX(D30:D$44<>\"\",0),0),0),0))","v":118184},1393069,{"$f":"IF(OR(G29=\"HOL\",G29=\"SUN\",G29=\"SAT\",G29=\"No Read\",G29=\"\"),\"\",IF(INDEX(G29:$G$44,MATCH(TRUE,ISNUMBER(G29:$G$44),0))<LOOKUP(99^99,G$2:G28),(INDEX(G29:$G$44,MATCH(TRUE,ISNUMBER(G29:$G$44),0))*1000),(INDEX(G29:$G$44,MATCH(TRUE,ISNUMBER(G29:$G$44),0))-LOOKUP(99^99,G$2:G28))*1000))","v":56000},56000,1,{"$f":"IF(G29=\"\",\"\",ROUND(OFFSET(I29,MATCH(TRUE,INDEX(I30:I$44<>\"\",0),0),0),0))","v":63000},1980591,{"$f":"IF(OR(L29=\"HOL\",L29=\"SUN\",L29=\"SAT\",L29=\"No Read\",L29=\"\"),\"\",IF(INDEX(L29:$L$44,MATCH(TRUE,ISNUMBER(L29:$L$44),0))<LOOKUP(99^99,L$2:L28),(INDEX(L29:$L$44,MATCH(TRUE,ISNUMBER(L29:$L$44),0))*748),(INDEX(L29:$L$44,MATCH(TRUE,ISNUMBER(L29:$L$44),0))-LOOKUP(99^99,L$2:L28))*748))","v":125664},125664,1,{"$f":"IF(L29=\"\",\"\",ROUND(OFFSET(N29,MATCH(TRUE,INDEX(N30:N$44<>\"\",0),0),0),0))","v":400180},200191,{"$f":"IF(OR(Q29=\"HOL\",Q29=\"SUN\",Q29=\"SAT\",Q29=\"No Read\",Q29=\"\"),\"\",IF(INDEX(Q29:$Q$44,MATCH(TRUE,ISNUMBER(Q29:$Q$44),0))<LOOKUP(99^99,Q$2:Q28),(INDEX(Q29:$Q$44,MATCH(TRUE,ISNUMBER(Q29:$Q$44),0))*1000),(INDEX(Q29:$Q$44,MATCH(TRUE,ISNUMBER(Q29:$Q$44),0))-LOOKUP(99^99,Q$2:Q28))*1000))","v":0},0,1,{"$f":"IF(Q29=\"\",\"\",ROUND(OFFSET(S29,MATCH(TRUE,INDEX(S30:S$44<>\"\",0),0),0),0))","v":1000},null,null,null,null,null,null,null,null,null,22,64000]
[23,563096,{"$f":"IF(OR(B30=\"HOL\",B30=\"SUN\",B30=\"SAT\",B30=\"No Read\",B30=\"\"),\"\",IF(INDEX(B30:$B$44,MATCH(TRUE,ISNUMBER(B30:$B$44),0))<LOOKUP(99^99,B$2:B29),(INDEX(B30:$B$44,MATCH(TRUE,ISNUMBER(B30:$B$44),0))*748),(INDEX(B30:$B$44,MATCH(TRUE,ISNUMBER(B30:$B$44),0))-LOOKUP(99^99,B$2:B29))*748))","v":118184},118184,1,{"$f":"IF(B30=\"\",\"\",ROUND(OFFSET(D30,MATCH(TRUE,INDEX(D31:D$44<>\"\",0),0),0),0))","v":93500},1393132,{"$f":"IF(OR(G30=\"HOL\",G30=\"SUN\",G30=\"SAT\",G30=\"No Read\",G30=\"\"),\"\",IF(INDEX(G30:$G$44,MATCH(TRUE,ISNUMBER(G30:$G$44),0))<LOOKUP(99^99,G$2:G29),(INDEX(G30:$G$44,MATCH(TRUE,ISNUMBER(G30:$G$44),0))*1000),(INDEX(G30:$G$44,MATCH(TRUE,ISNUMBER(G30:$G$44),0))-LOOKUP(99^99,G$2:G29))*1000))","v":63000},63000,1,{"$f":"IF(G30=\"\",\"\",ROUND(OFFSET(I30,MATCH(TRUE,INDEX(I31:I$44<>\"\",0),0),0),0))","v":130000},1981126,{"$f":"IF(OR(L30=\"HOL\",L30=\"SUN\",L30=\"SAT\",L30=\"No Read\",L30=\"\"),\"\",IF(INDEX(L30:$L$44,MATCH(TRUE,ISNUMBER(L30:$L$44),0))<LOOKUP(99^99,L$2:L29),(INDEX(L30:$L$44,MATCH(TRUE,ISNUMBER(L30:$L$44),0))*748),(INDEX(L30:$L$44,MATCH(TRUE,ISNUMBER(L30:$L$44),0))-LOOKUP(99^99,L$2:L29))*748))","v":400180},400180,1,{"$f":"IF(L30=\"\",\"\",ROUND(OFFSET(N30,MATCH(TRUE,INDEX(N31:N$44<>\"\",0),0),0),0))","v":307428},200192,{"$f":"IF(OR(Q30=\"HOL\",Q30=\"SUN\",Q30=\"SAT\",Q30=\"No Read\",Q30=\"\"),\"\",IF(INDEX(Q30:$Q$44,MATCH(TRUE,ISNUMBER(Q30:$Q$44),0))<LOOKUP(99^99,Q$2:Q29),(INDEX(Q30:$Q$44,MATCH(TRUE,ISNUMBER(Q30:$Q$44),0))*1000),(INDEX(Q30:$Q$44,MATCH(TRUE,ISNUMBER(Q30:$Q$44),0))-LOOKUP(99^99,Q$2:Q29))*1000))","v":1000},1000,1,{"$f":"IF(Q30=\"\",\"\",ROUND(OFFSET(S30,MATCH(TRUE,INDEX(S31:S$44<>\"\",0),0),0),0))","v":0},null,null,null,null,null,null,null,null,null,23,130000]
[24,563221,{"$f":"IF(OR(B31=\"HOL\",B31=\"SUN\",B31=\"SAT\",B31=\"No Read\",B31=\"\"),\"\",IF(INDEX(B31:$B$44,MATCH(TRUE,ISNUMBER(B31:$B$44),0))<LOOKUP(99^99,B$2:B30),(INDEX(B31:$B$44,MATCH(TRUE,ISNUMBER(B31:$B$44),0))*748),(INDEX(B31:$B$44,MATCH(TRUE,ISNUMBER(B31:$B$44),0))-LOOKUP(99^99,B$2:B30))*748))","v":93500},93500,1,{"$f":"IF(B31=\"\",\"\",ROUND(OFFSET(D31,MATCH(TRUE,INDEX(D32:D$44<>\"\",0),0),0),0))","v":59840},1393262,{"$f":"IF(OR(G31=\"HOL\",G31=\"SUN\",G31=\"SAT\",G31=\"No Read\",G31=\"\"),\"\",IF(INDEX(G31:$G$44,MATCH(TRUE,ISNUMBER(G31:$G$44),0))<LOOKUP(99^99,G$2:G30),(INDEX(G31:$G$44,MATCH(TRUE,ISNUMBER(G31:$G$44),0))*1000),(INDEX(G31:$G$44,MATCH(TRUE,ISNUMBER(G31:$G$44),0))-LOOKUP(99^99,G$2:G30))*1000))","v":130000},130000,1,{"$f":"IF(G31=\"\",\"\",ROUND(OFFSET(I31,MATCH(TRUE,INDEX(I32:I$44<>\"\",0),0),0),0))","v":199000},1981537,{"$f":"IF(OR(L31=\"HOL\",L31=\"SUN\",L31=\"SAT\",L31=\"No Read\",L31=\"\"),\"\",IF(INDEX(L31:$L$44,MATCH(TRUE,ISNUMBER(L31:$L$44),0))<LOOKUP(99^99,L$2:L30),(INDEX(L31:$L$44,MATCH(TRUE,ISNUMBER(L31:$L$44),0))*748),(INDEX(L31:$L$44,MATCH(TRUE,ISNUMBER(L31:$L$44),0))-LOOKUP(99^99,L$2:L30))*748))","v":307428},307428,1,{"$f":"IF(L31=\"\",\"\",ROUND(OFFSET(N31,MATCH(TRUE,INDEX(N32:N$44<>\"\",0),0),0),0))","v":196724},200192,{"$f":"IF(OR(Q31=\"HOL\",Q31=\"SUN\",Q31=\"SAT\",Q31=\"No Read\",Q31=\"\"),\"\",IF(INDEX(Q31:$Q$44,MATCH(TRUE,ISNUMBER(Q31:$Q$44),0))<LOOKUP(99^99,Q$2:Q30),(INDEX(Q31:$Q$44,MATCH(TRUE,ISNUMBER(Q31:$Q$44),0))*1000),(INDEX(Q31:$Q$44,MATCH(TRUE,ISNUMBER(Q31:$Q$44),0))-LOOKUP(99^99,Q$2:Q30))*1000))","v":0},0,1,{"$f":"IF(Q31=\"\",\"\",ROUND(OFFSET(S31,MATCH(TRUE,INDEX(S32:S$44<>\"\",0),0),0),0))","v":5000},null,null,null,null,null,null,null,null,null,24,204000]
[25,563301,{"$f":"IF(OR(B32=\"HOL\",B32=\"SUN\",B32=\"SAT\",B32=\"No Read\",B32=\"\"),\"\",IF(INDEX(B32:$B$44,MATCH(TRUE,ISNUMBER(B32:$B$44),0))<LOOKUP(99^99,B$2:B31),(INDEX(B32:$B$44,MATCH(TRUE,ISNUMBER(B32:$B$44),0))*748),(INDEX(B32:$B$44,MATCH(TRUE,ISNUMBER(B32:$B$44),0))-LOOKUP(99^99,B$2:B31))*748))","v":59840},59840,1,{"$f":"IF(B32=\"\",\"\",ROUND(OFFSET(D32,MATCH(TRUE,INDEX(D33:D$44<>\"\",0),0),0),0))","v":110704},1393461,{"$f":"IF(OR(G32=\"HOL\",G32=\"SUN\",G32=\"SAT\",G32=\"No Read\",G32=\"\"),\"\",IF(INDEX(G32:$G$44,MATCH(TRUE,ISNUMBER(G32:$G$44),0))<LOOKUP(99^99,G$2:G31),(INDEX(G32:$G$44,MATCH(TRUE,ISNUMBER(G32:$G$44),0))*1000),(INDEX(G32:$G$44,MATCH(TRUE,ISNUMBER(G32:$G$44),0))-LOOKUP(99^99,G$2:G31))*1000))","v":199000},199000,1,{"$f":"IF(G32=\"\",\"\",ROUND(OFFSET(I32,MATCH(TRUE,INDEX(I33:I$44<>\"\",0),0),0),0))","v":239000},1981800,{"$f":"IF(OR(L32=\"HOL\",L32=\"SUN\",L32=\"SAT\",L32=\"No Read\",L32=\"\"),\"\",IF(INDEX(L32:$L$44,MATCH(TRUE,ISNUMBER(L32:$L$44),0))<LOOKUP(99^99,L$2:L31),(INDEX(L32:$L$44,MATCH(TRUE,ISNUMBER(L32:$L$44),0))*748),(INDEX(L32:$L$44,MATCH(TRUE,ISNUMBER(L32:$L$44),0))-LOOKUP(99^99,L$2:L31))*748))","v":196724},196724,1,{"$f":"IF(L32=\"\",\"\",ROUND(OFFSET(N32,MATCH(TRUE,INDEX(N33:N$44<>\"\",0),0),0),0))","v":368764},200197,{"$f":"IF(OR(Q32=\"HOL\",Q32=\"SUN\",Q32=\"SAT\",Q32=\"No Read\",Q32=\"\"),\"\",IF(INDEX(Q32:$Q$44,MATCH(TRUE,ISNUMBER(Q32:$Q$44),0))<LOOKUP(99^99,Q$2:Q31),(INDEX(Q32:$Q$44,MATCH(TRUE,ISNUMBER(Q32:$Q$44),0))*1000),(INDEX(Q32:$Q$44,MATCH(TRUE,ISNUMBER(Q32:$Q$44),0))-LOOKUP(99^99,Q$2:Q31))*1000))","v":5000},5000,1,{"$f":"IF(Q32=\"\",\"\",ROUND(OFFSET(S32,MATCH(TRUE,INDEX(S33:S$44<>\"\",0),0),0),0))","v":16000},null,null,null,null,null,null,null,null,null,25,255000]
[26,563449,{"$f":"IF(OR(B33=\"HOL\",B33=\"SUN\",B33=\"SAT\",B33=\"No Read\",B33=\"\"),\"\",IF(INDEX(B33:$B$44,MATCH(TRUE,ISNUMBER(B33:$B$44),0))<LOOKUP(99^99,B$2:B32),(INDEX(B33:$B$44,MATCH(TRUE,ISNUMBER(B33:$B$44),0))*748),(INDEX(B33:$B$44,MATCH(TRUE,ISNUMBER(B33:$B$44),0))-LOOKUP(99^99,B$2:B32))*748))","v":110704},110704,1,{"$f":"IF(B33=\"\",\"\",ROUND(OFFSET(D33,MATCH(TRUE,INDEX(D34:D$44<>\"\",0),0),0),0))","v":86020},1393700,{"$f":"IF(OR(G33=\"HOL\",G33=\"SUN\",G33=\"SAT\",G33=\"No Read\",G33=\"\"),\"\",IF(INDEX(G33:$G$44,MATCH(TRUE,ISNUMBER(G33:$G$44),0))<LOOKUP(99^99,G$2:G32),(INDEX(G33:$G$44,MATCH(TRUE,ISNUMBER(G33:$G$44),0))*1000),(INDEX(G33:$G$44,MATCH(TRUE,ISNUMBER(G33:$G$44),0))-LOOKUP(99^99,G$2:G32))*1000))","v":239000},239000,1,{"$f":"IF(G33=\"\",\"\",ROUND(OFFSET(I33,MATCH(TRUE,INDEX(I34:I$44<>\"\",0),0),0),0))","v":186000},1982293,{"$f":"IF(OR(L33=\"HOL\",L33=\"SUN\",L33=\"SAT\",L33=\"No Read\",L33=\"\"),\"\",IF(INDEX(L33:$L$44,MATCH(TRUE,ISNUMBER(L33:$L$44),0))<LOOKUP(99^99,L$2:L32),(INDEX(L33:$L$44,MATCH(TRUE,ISNUMBER(L33:$L$44),0))*748),(INDEX(L33:$L$44,MATCH(TRUE,ISNUMBER(L33:$L$44),0))-LOOKUP(99^99,L$2:L32))*748))","v":368764},368764,1,{"$f":"IF(L33=\"\",\"\",ROUND(OFFSET(N33,MATCH(TRUE,INDEX(N34:N$44<>\"\",0),0),0),0))","v":314908},200213,{"$f":"IF(OR(Q33=\"HOL\",Q33=\"SUN\",Q33=\"SAT\",Q33=\"No Read\",Q33=\"\"),\"\",IF(INDEX(Q33:$Q$44,MATCH(TRUE,ISNUMBER(Q33:$Q$44),0))<LOOKUP(99^99,Q$2:Q32),(INDEX(Q33:$Q$44,MATCH(TRUE,ISNUMBER(Q33:$Q$44),0))*1000),(INDEX(Q33:$Q$44,MATCH(TRUE,ISNUMBER(Q33:$Q$44),0))-LOOKUP(99^99,Q$2:Q32))*1000))","v":16000},16000,1,{"$f":"IF(Q33=\"\",\"\",ROUND(OFFSET(S33,MATCH(TRUE,INDEX(S34:S$44<>\"\",0),0),0),0))","v":0},null,null,null,null,null,null,null,null,null,26,186000]
[27,563564,{"$f":"IF(OR(B34=\"HOL\",B34=\"SUN\",B34=\"SAT\",B34=\"No Read\",B34=\"\"),\"\",IF(INDEX(B34:$B$44,MATCH(TRUE,ISNUMBER(B34:$B$44),0))<LOOKUP(99^99,B$2:B33),(INDEX(B34:$B$44,MATCH(TRUE,ISNUMBER(B34:$B$44),0))*748),(INDEX(B34:$B$44,MATCH(TRUE,ISNUMBER(B34:$B$44),0))-LOOKUP(99^99,B$2:B33))*748))","v":86020},86020,1,{"$f":"IF(B34=\"\",\"\",ROUND(OFFSET(D34,MATCH(TRUE,INDEX(D35:D$44<>\"\",0),0),0),0))","v":122672},1393886,{"$f":"IF(OR(G34=\"HOL\",G34=\"SUN\",G34=\"SAT\",G34=\"No Read\",G34=\"\"),\"\",IF(INDEX(G34:$G$44,MATCH(TRUE,ISNUMBER(G34:$G$44),0))<LOOKUP(99^99,G$2:G33),(INDEX(G34:$G$44,MATCH(TRUE,ISNUMBER(G34:$G$44),0))*1000),(INDEX(G34:$G$44,MATCH(TRUE,ISNUMBER(G34:$G$44),0))-LOOKUP(99^99,G$2:G33))*1000))","v":186000},186000,1,{"$f":"IF(G34=\"\",\"\",ROUND(OFFSET(I34,MATCH(TRUE,INDEX(I35:I$44<>\"\",0),0),0),0))","v":263000},1982714,{"$f":"IF(OR(L34=\"HOL\",L34=\"SUN\",L34=\"SAT\",L34=\"No Read\",L34=\"\"),\"\",IF(INDEX(L34:$L$44,MATCH(TRUE,ISNUMBER(L34:$L$44),0))<LOOKUP(99^99,L$2:L33),(INDEX(L34:$L$44,MATCH(TRUE,ISNUMBER(L34:$L$44),0))*748),(INDEX(L34:$L$44,MATCH(TRUE,ISNUMBER(L34:$L$44),0))-LOOKUP(99^99,L$2:L33))*748))","v":314908},314908,1,{"$f":"IF(L34=\"\",\"\",ROUND(OFFSET(N34,MATCH(TRUE,INDEX(N35:N$44<>\"\",0),0),0),0))","v":414392},200213,{"$f":"IF(OR(Q34=\"HOL\",Q34=\"SUN\",Q34=\"SAT\",Q34=\"No Read\",Q34=\"\"),\"\",IF(INDEX(Q34:$Q$44,MATCH(TRUE,ISNUMBER(Q34:$Q$44),0))<LOOKUP(99^99,Q$2:Q33),(INDEX(Q34:$Q$44,MATCH(TRUE,ISNUMBER(Q34:$Q$44),0))*1000),(INDEX(Q34:$Q$44,MATCH(TRUE,ISNUMBER(Q34:$Q$44),0))-LOOKUP(99^99,Q$2:Q33))*1000))","v":0},0,1,{"$f":"IF(Q34=\"\",\"\",ROUND(OFFSET(S34,MATCH(TRUE,INDEX(S35:S$44<>\"\",0),0),0),0))","v":0},null,null,null,null,null,null,null,null,null,27,263000]
[28,563728,{"$f":"IF(OR(B35=\"HOL\",B35=\"SUN\",B35=\"SAT\",B35=\"No Read\",B35=\"\"),\"\",IF(INDEX(B35:$B$44,MATCH(TRUE,ISNUMBER(B35:$B$44),0))<LOOKUP(99^99,B$2:B34),(INDEX(B35:$B$44,MATCH(TRUE,ISNUMBER(B35:$B$44),0))*748),(INDEX(B35:$B$44,MATCH(TRUE,ISNUMBER(B35:$B$44),0))-LOOKUP(99^99,B$2:B34))*748))","v":122672},122672,1,{"$f":"IF(B35=\"\",\"\",ROUND(OFFSET(D35,MATCH(TRUE,INDEX(D36:D$44<>\"\",0),0),0),0))","v":134640},1394149,{"$f":"IF(OR(G35=\"HOL\",G35=\"SUN\",G35=\"SAT\",G35=\"No Read\",G35=\"\"),\"\",IF(INDEX(G35:$G$44,MATCH(TRUE,ISNUMBER(G35:$G$44),0))<LOOKUP(99^99,G$2:G34),(INDEX(G35:$G$44,MATCH(TRUE,ISNUMBER(G35:$G$44),0))*1000),(INDEX(G35:$G$44,MATCH(TRUE,ISNUMBER(G35:$G$44),0))-LOOKUP(99^99,G$2:G34))*1000))","v":263000},263000,1,{"$f":"IF(G35=\"\",\"\",ROUND(OFFSET(I35,MATCH(TRUE,INDEX(I36:I$44<>\"\",0),0),0),0))","v":233000},1983268,{"$f":"IF(OR(L35=\"HOL\",L35=\"SUN\",L35=\"SAT\",L35=\"No Read\",L35=\"\"),\"\",IF(INDEX(L35:$L$44,MATCH(TRUE,ISNUMBER(L35:$L$44),0))<LOOKUP(99^99,L$2:L34),(INDEX(L35:$L$44,MATCH(TRUE,ISNUMBER(L35:$L$44),0))*748),(INDEX(L35:$L$44,MATCH(TRUE,ISNUMBER(L35:$L$44),0))-LOOKUP(99^99,L$2:L34))*748))","v":414392},414392,1,{"$f":"IF(L35=\"\",\"\",ROUND(OFFSET(N35,MATCH(TRUE,INDEX(N36:N$44<>\"\",0),0),0),0))","v":468248},200213,{"$f":"IF(OR(Q35=\"HOL\",Q35=\"SUN\",Q35=\"SAT\",Q35=\"No Read\",Q35=\"\"),\"\",IF(INDEX(Q35:$Q$44,MATCH(TRUE,ISNUMBER(Q35:$Q$44),0))<LOOKUP(99^99,Q$2:Q34),(INDEX(Q35:$Q$44,MATCH(TRUE,ISNUMBER(Q35:$Q$44),0))*1000),(INDEX(Q35:$Q$44,MATCH(TRUE,ISNUMBER(Q35:$Q$44),0))-LOOKUP(99^99,Q$2:Q34))*1000))","v":0},0,1,{"$f":"IF(Q35=\"\",\"\",ROUND(OFFSET(S35,MATCH(TRUE,INDEX(S36:S$44<>\"\",0),0),0),0))","v":0},null,null,null,null,null,null,null,null,null,28,233000]
[29,563908,{"$f":"IF(OR(B36=\"HOL\",B36=\"SUN\",B36=\"SAT\",B36=\"No Read\",B36=\"\"),\"\",IF(INDEX(B36:$B$44,MATCH(TRUE,ISNUMBER(B36:$B$44),0))<LOOKUP(99^99,B$2:B35),(INDEX(B36:$B$44,MATCH(TRUE,ISNUMBER(B36:$B$44),0))*748),(INDEX(B36:$B$44,MATCH(TRUE,ISNUMBER(B36:$B$44),0))-LOOKUP(99^99,B$2:B35))*748))","v":134640},134640,{"$f":"IF(B36=\"\",E35,IF(C36=\"\",IF(E35>0,E35+1,1),1))","v":1},{"$f":"IF(B36=\"\",\"\",ROUND(OFFSET(D36,MATCH(TRUE,INDEX(D37:D$44<>\"\",0),0),0),0))","v":130900},1394382,{"$f":"IF(OR(G36=\"HOL\",G36=\"SUN\",G36=\"SAT\",G36=\"No Read\",G36=\"\"),\"\",IF(INDEX(G36:$G$44,MATCH(TRUE,ISNUMBER(G36:$G$44),0))<LOOKUP(99^99,G$2:G35),(INDEX(G36:$G$44,MATCH(TRUE,ISNUMBER(G36:$G$44),0))*1000),(INDEX(G36:$G$44,MATCH(TRUE,ISNUMBER(G36:$G$44),0))-LOOKUP(99^99,G$2:G35))*1000))","v":233000},233000,{"$f":"IF(G36=\"\",J35,IF(H36=\"\",IF(J35>0,J35+1,1),1))","v":1},{"$f":"IF(G36=\"\",\"\",ROUND(OFFSET(I36,MATCH(TRUE,INDEX(I37:I$44<>\"\",0),0),0),0))","v":208000},1983894,{"$f":"IF(OR(L36=\"HOL\",L36=\"SUN\",L36=\"SAT\",L36=\"No Read\",L36=\"\"),\"\",IF(INDEX(L36:$L$44,MATCH(TRUE,ISNUMBER(L36:$L$44),0))<LOOKUP(99^99,L$2:L35),(INDEX(L36:$L$44,MATCH(TRUE,ISNUMBER(L36:$L$44),0))*748),(INDEX(L36:$L$44,MATCH(TRUE,ISNUMBER(L36:$L$44),0))-LOOKUP(99^99,L$2:L35))*748))","v":468248},468248,{"$f":"IF(L36=\"\",O35,IF(M36=\"\",IF(O35>0,O35+1,1),1))","v":1},{"$f":"IF(L36=\"\",\"\",ROUND(OFFSET(N36,MATCH(TRUE,INDEX(N37:N$44<>\"\",0),0),0),0))","v":460768},200213,{"$f":"IF(OR(Q36=\"HOL\",Q36=\"SUN\",Q36=\"SAT\",Q36=\"No Read\",Q36=\"\"),\"\",IF(INDEX(Q36:$Q$44,MATCH(TRUE,ISNUMBER(Q36:$Q$44),0))<LOOKUP(99^99,Q$2:Q35),(INDEX(Q36:$Q$44,MATCH(TRUE,ISNUMBER(Q36:$Q$44),0))*1000),(INDEX(Q36:$Q$44,MATCH(TRUE,ISNUMBER(Q36:$Q$44),0))-LOOKUP(99^99,Q$2:Q35))*1000))","v":0},0,{"$f":"IF(Q36=\"\",T35,IF(R36=\"\",IF(T35>0,T35+1,1),1))","v":1},{"$f":"IF(Q36=\"\",\"\",ROUND(OFFSET(S36,MATCH(TRUE,INDEX(S37:S$44<>\"\",0),0),0),0))","v":1000},null,null,null,null,null,null,null,null,null,29,209000]
[30,564083,{"$f":"IF(OR(B37=\"HOL\",B37=\"SUN\",B37=\"SAT\",B37=\"No Read\",B37=\"\"),\"\",IF(INDEX(B37:$B$44,MATCH(TRUE,ISNUMBER(B37:$B$44),0))<LOOKUP(99^99,B$2:B36),(INDEX(B37:$B$44,MATCH(TRUE,ISNUMBER(B37:$B$44),0))*748),(INDEX(B37:$B$44,MATCH(TRUE,ISNUMBER(B37:$B$44),0))-LOOKUP(99^99,B$2:B36))*748))","v":130900},130900,{"$f":"IF(B37=\"\",E36,IF(C37=\"\",IF(E36>0,E36+1,1),1))","v":1},{"$f":"IF(B37=\"\",\"\",ROUND(OFFSET(D37,MATCH(TRUE,INDEX(D38:D$44<>\"\",0),0),0),0))","v":127908},1394590,{"$f":"IF(OR(G37=\"HOL\",G37=\"SUN\",G37=\"SAT\",G37=\"No Read\",G37=\"\"),\"\",IF(INDEX(G37:$G$44,MATCH(TRUE,ISNUMBER(G37:$G$44),0))<LOOKUP(99^99,G$2:G36),(INDEX(G37:$G$44,MATCH(TRUE,ISNUMBER(G37:$G$44),0))*1000),(INDEX(G37:$G$44,MATCH(TRUE,ISNUMBER(G37:$G$44),0))-LOOKUP(99^99,G$2:G36))*1000))","v":208000},208000,{"$f":"IF(G37=\"\",J36,IF(H37=\"\",IF(J36>0,J36+1,1),1))","v":1},{"$f":"IF(G37=\"\",\"\",ROUND(OFFSET(I37,MATCH(TRUE,INDEX(I38:I$44<>\"\",0),0),0),0))","v":248000},1984510,{"$f":"IF(OR(L37=\"HOL\",L37=\"SUN\",L37=\"SAT\",L37=\"No Read\",L37=\"\"),\"\",IF(INDEX(L37:$L$44,MATCH(TRUE,ISNUMBER(L37:$L$44),0))<LOOKUP(99^99,L$2:L36),(INDEX(L37:$L$44,MATCH(TRUE,ISNUMBER(L37:$L$44),0))*748),(INDEX(L37:$L$44,MATCH(TRUE,ISNUMBER(L37:$L$44),0))-LOOKUP(99^99,L$2:L36))*748))","v":460768},460768,{"$f":"IF(L37=\"\",O36,IF(M37=\"\",IF(O36>0,O36+1,1),1))","v":1},{"$f":"IF(L37=\"\",\"\",ROUND(OFFSET(N37,MATCH(TRUE,INDEX(N38:N$44<>\"\",0),0),0),0))","v":456280},200214,{"$f":"IF(OR(Q37=\"HOL\",Q37=\"SUN\",Q37=\"SAT\",Q37=\"No Read\",Q37=\"\"),\"\",IF(INDEX(Q37:$Q$44,MATCH(TRUE,ISNUMBER(Q37:$Q$44),0))<LOOKUP(99^99,Q$2:Q36),(INDEX(Q37:$Q$44,MATCH(TRUE,ISNUMBER(Q37:$Q$44),0))*1000),(INDEX(Q37:$Q$44,MATCH(TRUE,ISNUMBER(Q37:$Q$44),0))-LOOKUP(99^99,Q$2:Q36))*1000))","v":1000},1000,{"$f":"IF(Q37=\"\",T36,IF(R37=\"\",IF(T36>0,T36+1,1),1))","v":1},{"$f":"IF(Q37=\"\",\"\",ROUND(OFFSET(S37,MATCH(TRUE,INDEX(S38:S$44<>\"\",0),0),0),0))","v":0},null,null,null,null,null,null,null,null,null,30,248000]
[31,564254,{"$f":"IF(OR(B38=\"HOL\",B38=\"SUN\",B38=\"SAT\",B38=\"No Read\",B38=\"\"),\"\",IF(INDEX(B38:$B$44,MATCH(TRUE,ISNUMBER(B38:$B$44),0))<LOOKUP(99^99,B$2:B37),(INDEX(B38:$B$44,MATCH(TRUE,ISNUMBER(B38:$B$44),0))*748),(INDEX(B38:$B$44,MATCH(TRUE,ISNUMBER(B38:$B$44),0))-LOOKUP(99^99,B$2:B37))*748))","v":127908},127908,{"$f":"IF(B38=\"\",E37,IF(C38=\"\",IF(E37>0,E37+1,1),1))","v":1},{"$f":"IF(B38=\"\",\"\",ROUND(OFFSET(D38,MATCH(TRUE,INDEX(D39:D$44<>\"\",0),0),0),0))","v":103972},1394838,{"$f":"IF(OR(G38=\"HOL\",G38=\"SUN\",G38=\"SAT\",G38=\"No Read\",G38=\"\"),\"\",IF(INDEX(G38:$G$44,MATCH(TRUE,ISNUMBER(G38:$G$44),0))<LOOKUP(99^99,G$2:G37),(INDEX(G38:$G$44,MATCH(TRUE,ISNUMBER(G38:$G$44),0))*1000),(INDEX(G38:$G$44,MATCH(TRUE,ISNUMBER(G38:$G$44),0))-LOOKUP(99^99,G$2:G37))*1000))","v":248000},248000,{"$f":"IF(G38=\"\",J37,IF(H38=\"\",IF(J37>0,J37+1,1),1))","v":1},{"$f":"IF(G38=\"\",\"\",ROUND(OFFSET(I38,MATCH(TRUE,INDEX(I39:I$44<>\"\",0),0),0),0))","v":317000},1985120,{"$f":"IF(OR(L38=\"HOL\",L38=\"SUN\",L38=\"SAT\",L38=\"No Read\",L38=\"\"),\"\",IF(INDEX(L38:$L$44,MATCH(TRUE,ISNUMBER(L38:$L$44),0))<LOOKUP(99^99,L$2:L37),(INDEX(L38:$L$44,MATCH(TRUE,ISNUMBER(L38:$L$44),0))*748),(INDEX(L38:$L$44,MATCH(TRUE,ISNUMBER(L38:$L$44),0))-LOOKUP(99^99,L$2:L37))*748))","v":456280},456280,{"$f":"IF(L38=\"\",O37,IF(M38=\"\",IF(O37>0,O37+1,1),1))","v":1},{"$f":"IF(L38=\"\",\"\",ROUND(OFFSET(N38,MATCH(TRUE,INDEX(N39:N$44<>\"\",0),0),0),0))","v":353804},200214,{"$f":"IF(OR(Q38=\"HOL\",Q38=\"SUN\",Q38=\"SAT\",Q38=\"No Read\",Q38=\"\"),\"\",IF(INDEX(Q38:$Q$44,MATCH(TRUE,ISNUMBER(Q38:$Q$44),0))<LOOKUP(99^99,Q$2:Q37),(INDEX(Q38:$Q$44,MATCH(TRUE,ISNUMBER(Q38:$Q$44),0))*1000),(INDEX(Q38:$Q$44,MATCH(TRUE,ISNUMBER(Q38:$Q$44),0))-LOOKUP(99^99,Q$2:Q37))*1000))","v":0},0,{"$f":"IF(Q38=\"\",T37,IF(R38=\"\",IF(T37>0,T37+1,1),1))","v":1},{"$f":"IF(Q38=\"\",\"\",ROUND(OFFSET(S38,MATCH(TRUE,INDEX(S39:S$44<>\"\",0),0),0),0))","v":20000},null,null,null,null,null,null,null,null,null,31,337000]
["TOTAL:",null,null,null,null,{"$f":"IF(COUNTBLANK(F$8:F$38)=31,\"\",SUM(F$8:F$38))","v":3460248},null,null,null,null,{"$f":"IF(COUNTBLANK(K$8:K$38)=31,\"\",SUM(K$8:K$38))","v":7560000},null,null,null,null,{"$f":"IF(COUNTBLANK(P$8:P$38)=31,\"\",SUM(P$8:P$38))","v":11858044},null,null,null,null,{"$f":"IF(COUNTBLANK(U$8:U$38)=31,\"\",SUM(U$8:U$38))","v":119000},"Gallons"]
[null,null,null,null,null,{"$f":"IF(F$39=\"\",\"\",F$39/325853)","v":10.619046011545084},null,null,null,null,{"$f":"IF(K$39=\"\",\"\",K$39/325853)","v":23.200645689927669},null,null,null,null,{"$f":"IF(P$39=\"\",\"\",P$39/325853)","v":36.390777436451408},null,null,null,null,{"$f":"IF(U$39=\"\",\"\",U$39/325853)","v":0.36519534882293547},"Acre-Ft."]
[null,564393,{"$f":"IF(OR(B41=\"HOL\",B41=\"SUN\",B41=\"SAT\",B41=\"No Read\",B41=\"\"),\"\",IF(INDEX(B41:$B$44,MATCH(TRUE,ISNUMBER(B41:$B$44),0))<LOOKUP(99^99,B$2:B40),(INDEX(B41:$B$44,MATCH(TRUE,ISNUMBER(B41:$B$44),0))*748),(INDEX(B41:$B$44,MATCH(TRUE,ISNUMBER(B41:$B$44),0))-LOOKUP(99^99,B$2:B40))*748))","v":103972},{"$f":"IF(OR(B41=\"HOL\",B41=\"SUN\",B41=\"SAT\",B41=\"No Read\",B41=\"\"),\"\",ROUND(C41/E38,1))","v":103972},{"$f":"IF(B41=\"\",E38,IF(C41=\"\",IF(E38>0,E38+1,1),1))","v":1},{"$f":"IF(B42=\"\",\"\",OFFSET(D41,MATCH(TRUE,INDEX(D42:D$44<>\"\",0),0),0))","v":""},1395155,{"$f":"IF(OR(G41=\"HOL\",G41=\"SUN\",G41=\"SAT\",G41=\"No Read\",G41=\"\"),\"\",IF(INDEX(G41:$G$44,MATCH(TRUE,ISNUMBER(G41:$G$44),0))<LOOKUP(99^99,G$2:G40),(INDEX(G41:$G$44,MATCH(TRUE,ISNUMBER(G41:$G$44),0))*1000),(INDEX(G41:$G$44,MATCH(TRUE,ISNUMBER(G41:$G$44),0))-LOOKUP(99^99,G$2:G40))*1000))","v":317000},{"$f":"IF(OR(G41=\"HOL\",G41=\"SUN\",G41=\"SAT\",G41=\"No Read\",G41=\"\"),\"\",ROUND(H41/J38,1))","v":317000},{"$f":"IF(G41=\"\",J38,IF(H41=\"\",IF(J38>0,J38+1,1),1))","v":1},{"$f":"IF(G42=\"\",\"\",OFFSET(I41,MATCH(TRUE,INDEX(I42:I$44<>\"\",0),0),0))","v":""},1985593,{"$f":"IF(OR(L41=\"HOL\",L41=\"SUN\",L41=\"SAT\",L41=\"No Read\",L41=\"\"),\"\",IF(INDEX(L41:$L$44,MATCH(TRUE,ISNUMBER(L41:$L$44),0))<LOOKUP(99^99,L$2:L40),(INDEX(L41:$L$44,MATCH(TRUE,ISNUMBER(L41:$L$44),0))*748),(INDEX(L41:$L$44,MATCH(TRUE,ISNUMBER(L41:$L$44),0))-LOOKUP(99^99,L$2:L40))*748))","v":353804},{"$f":"IF(OR(L41=\"HOL\",L41=\"SUN\",L41=\"SAT\",L41=\"No Read\",L41=\"\"),\"\",ROUND(M41/O38,1))","v":353804},{"$f":"IF(L41=\"\",O38,IF(M41=\"\",IF(O38>0,O38+1,1),1))","v":1},{"$f":"IF(L42=\"\",\"\",OFFSET(N41,MATCH(TRUE,INDEX(N42:N$44<>\"\",0),0),0))","v":""},200234,{"$f":"IF(OR(Q41=\"HOL\",Q41=\"SUN\",Q41=\"SAT\",Q41=\"No Read\",Q41=\"\"),\"\",IF(INDEX(Q41:$Q$44,MATCH(TRUE,ISNUMBER(Q41:$Q$44),0))<LOOKUP(99^99,Q$2:Q40),(INDEX(Q41:$Q$44,MATCH(TRUE,ISNUMBER(Q41:$Q$44),0))*1000),(INDEX(Q41:$Q$44,MATCH(TRUE,ISNUMBER(Q41:$Q$44),0))-LOOKUP(99^99,Q$2:Q40))*1000))","v":20000},{"$f":"IF(OR(Q41=\"HOL\",Q41=\"SUN\",Q41=\"SAT\",Q41=\"No Read\",Q41=\"\"),\"\",ROUND(R41/T38,1))","v":20000},{"$f":"IF(Q41=\"\",T38,IF(R41=\"\",IF(T38>0,T38+1,1),1))","v":1},{"$f":"IF(Q42=\"\",\"\",OFFSET(S41,MATCH(TRUE,INDEX(S42:S$44<>\"\",0),0),0))","v":""}]
[null,null,{"$f":"IF(OR(B42=\"HOL\",B42=\"SUN\",B42=\"SAT\",B42=\"No Read\",B42=\"\"),\"\",IF(INDEX(B42:$B$44,MATCH(TRUE,ISNUMBER(B42:$B$44),0))<LOOKUP(99^99,B$2:B41),(INDEX(B42:$B$44,MATCH(TRUE,ISNUMBER(B42:$B$44),0))*748),(INDEX(B42:$B$44,MATCH(TRUE,ISNUMBER(B42:$B$44),0))-LOOKUP(99^99,B$2:B41))*748))","v":""},{"$f":"IF(OR(B42=\"HOL\",B42=\"SUN\",B42=\"SAT\",B42=\"No Read\",B42=\"\"),\"\",ROUND(C42/E41,1))","v":""},{"$f":"IF(B42=\"\",E41,IF(C42=\"\",IF(E41>0,E41+1,1),1))","v":1},{"$f":"IF(B43=\"\",\"\",OFFSET(D42,MATCH(TRUE,INDEX(D43:D$44<>\"\",0),0),0))","v":""},null,{"$f":"IF(OR(G42=\"HOL\",G42=\"SUN\",G42=\"SAT\",G42=\"No Read\",G42=\"\"),\"\",IF(INDEX(G42:$G$44,MATCH(TRUE,ISNUMBER(G42:$G$44),0))<LOOKUP(99^99,G$2:G41),(INDEX(G42:$G$44,MATCH(TRUE,ISNUMBER(G42:$G$44),0))*1000),(INDEX(G42:$G$44,MATCH(TRUE,ISNUMBER(G42:$G$44),0))-LOOKUP(99^99,G$2:G41))*1000))","v":""},{"$f":"IF(OR(G42=\"HOL\",G42=\"SUN\",G42=\"SAT\",G42=\"No Read\",G42=\"\"),\"\",ROUND(H42/J41,1))","v":""},{"$f":"IF(G42=\"\",J41,IF(H42=\"\",IF(J41>0,J41+1,1),1))","v":1},{"$f":"IF(G43=\"\",\"\",OFFSET(I42,MATCH(TRUE,INDEX(I43:I$44<>\"\",0),0),0))","v":""},null,{"$f":"IF(OR(L42=\"HOL\",L42=\"SUN\",L42=\"SAT\",L42=\"No Read\",L42=\"\"),\"\",IF(INDEX(L42:$L$44,MATCH(TRUE,ISNUMBER(L42:$L$44),0))<LOOKUP(99^99,L$2:L41),(INDEX(L42:$L$44,MATCH(TRUE,ISNUMBER(L42:$L$44),0))*748),(INDEX(L42:$L$44,MATCH(TRUE,ISNUMBER(L42:$L$44),0))-LOOKUP(99^99,L$2:L41))*748))","v":""},{"$f":"IF(OR(L42=\"HOL\",L42=\"SUN\",L42=\"SAT\",L42=\"No Read\",L42=\"\"),\"\",ROUND(M42/O41,1))","v":""},{"$f":"IF(L42=\"\",O41,IF(M42=\"\",IF(O41>0,O41+1,1),1))","v":1},{"$f":"IF(L43=\"\",\"\",OFFSET(N42,MATCH(TRUE,INDEX(N43:N$44<>\"\",0),0),0))","v":""},null,{"$f":"IF(OR(Q42=\"HOL\",Q42=\"SUN\",Q42=\"SAT\",Q42=\"No Read\",Q42=\"\"),\"\",IF(INDEX(Q42:$Q$44,MATCH(TRUE,ISNUMBER(Q42:$Q$44),0))<LOOKUP(99^99,Q$2:Q41),(INDEX(Q42:$Q$44,MATCH(TRUE,ISNUMBER(Q42:$Q$44),0))*1000),(INDEX(Q42:$Q$44,MATCH(TRUE,ISNUMBER(Q42:$Q$44),0))-LOOKUP(99^99,Q$2:Q41))*1000))","v":""},{"$f":"IF(OR(Q42=\"HOL\",Q42=\"SUN\",Q42=\"SAT\",Q42=\"No Read\",Q42=\"\"),\"\",ROUND(R42/T41,1))","v":""},{"$f":"IF(Q42=\"\",T41,IF(R42=\"\",IF(T41>0,T41+1,1),1))","v":1},{"$f":"IF(Q43=\"\",\"\",OFFSET(S42,MATCH(TRUE,INDEX(S43:S$44<>\"\",0),0),0))","v":""}]
[null,null,{"$f":"IF(OR(B43=\"HOL\",B43=\"SUN\",B43=\"SAT\",B43=\"No Read\",B43=\"\"),\"\",IF(INDEX(B43:$B$44,MATCH(TRUE,ISNUMBER(B43:$B$44),0))<LOOKUP(99^99,B$2:B42),(INDEX(B43:$B$44,MATCH(TRUE,ISNUMBER(B43:$B$44),0))*748),(INDEX(B43:$B$44,MATCH(TRUE,ISNUMBER(B43:$B$44),0))-LOOKUP(99^99,B$2:B42))*748))","v":""},"",{"$f":"IF(B43=\"\",E42,IF(C43=\"\",IF(E42>0,E42+1,1),1))","v":1},{"$f":"IF(B44=\"\",\"\",OFFSET(D43,MATCH(TRUE,INDEX(D44:D$44<>\"\",0),0),0))","v":""},null,{"$f":"IF(OR(G43=\"HOL\",G43=\"SUN\",G43=\"SAT\",G43=\"No Read\",G43=\"\"),\"\",IF(INDEX(G43:$G$44,MATCH(TRUE,ISNUMBER(G43:$G$44),0))<LOOKUP(99^99,G$2:G42),(INDEX(G43:$G$44,MATCH(TRUE,ISNUMBER(G43:$G$44),0))*1000),(INDEX(G43:$G$44,MATCH(TRUE,ISNUMBER(G43:$G$44),0))-LOOKUP(99^99,G$2:G42))*1000))","v":""},"",{"$f":"IF(G43=\"\",J42,IF(H43=\"\",IF(J42>0,J42+1,1),1))","v":1},{"$f":"IF(G44=\"\",\"\",OFFSET(I43,MATCH(TRUE,INDEX(I44:I$44<>\"\",0),0),0))","v":""},null,{"$f":"IF(OR(L43=\"HOL\",L43=\"SUN\",L43=\"SAT\",L43=\"No Read\",L43=\"\"),\"\",IF(INDEX(L43:$L$44,MATCH(TRUE,ISNUMBER(L43:$L$44),0))<LOOKUP(99^99,L$2:L42),(INDEX(L43:$L$44,MATCH(TRUE,ISNUMBER(L43:$L$44),0))*748),(INDEX(L43:$L$44,MATCH(TRUE,ISNUMBER(L43:$L$44),0))-LOOKUP(99^99,L$2:L42))*748))","v":""},"",{"$f":"IF(L43=\"\",O42,IF(M43=\"\",IF(O42>0,O42+1,1),1))","v":1},{"$f":"IF(L44=\"\",\"\",OFFSET(N43,MATCH(TRUE,INDEX(N44:N$44<>\"\",0),0),0))","v":""},null,{"$f":"IF(OR(Q43=\"HOL\",Q43=\"SUN\",Q43=\"SAT\",Q43=\"No Read\",Q43=\"\"),\"\",IF(INDEX(Q43:$Q$44,MATCH(TRUE,ISNUMBER(Q43:$Q$44),0))<LOOKUP(99^99,Q$2:Q42),(INDEX(Q43:$Q$44,MATCH(TRUE,ISNUMBER(Q43:$Q$44),0))*1000),(INDEX(Q43:$Q$44,MATCH(TRUE,ISNUMBER(Q43:$Q$44),0))-LOOKUP(99^99,Q$2:Q42))*1000))","v":""},"",{"$f":"IF(Q43=\"\",T42,IF(R43=\"\",IF(T42>0,T42+1,1),1))","v":1},{"$f":"IF(Q44=\"\",\"\",OFFSET(S43,MATCH(TRUE,INDEX(S44:S$44<>\"\",0),0),0))","v":""}]
[null,null,{"$f":"IF(OR(B44=\"HOL\",B44=\"SUN\",B44=\"SAT\",B44=\"No Read\",B44=\"\"),\"\",IF(INDEX(B44:$B$44,MATCH(TRUE,ISNUMBER(B44:$B$44),0))<LOOKUP(99^99,B$2:B43),(INDEX(B44:$B$44,MATCH(TRUE,ISNUMBER(B44:$B$44),0))*748),(INDEX(B44:$B$44,MATCH(TRUE,ISNUMBER(B44:$B$44),0))-LOOKUP(99^99,B$2:B43))*748))","v":""},"",{"$f":"IF(B44=\"\",E43,IF(C44=\"\",IF(E43>0,E43+1,1),1))","v":1},{"$f":"IF(B45=\"\",\"\",OFFSET(D44,MATCH(TRUE,INDEX(D$44:D45<>\"\",0),0),0))","v":""},null,{"$f":"IF(OR(G44=\"HOL\",G44=\"SUN\",G44=\"SAT\",G44=\"No Read\",G44=\"\"),\"\",IF(INDEX(G44:$G$44,MATCH(TRUE,ISNUMBER(G44:$G$44),0))<LOOKUP(99^99,G$2:G43),(INDEX(G44:$G$44,MATCH(TRUE,ISNUMBER(G44:$G$44),0))*1000),(INDEX(G44:$G$44,MATCH(TRUE,ISNUMBER(G44:$G$44),0))-LOOKUP(99^99,G$2:G43))*1000))","v":""},"",{"$f":"IF(G44=\"\",J43,IF(H44=\"\",IF(J43>0,J43+1,1),1))","v":1},{"$f":"IF(G45=\"\",\"\",OFFSET(I44,MATCH(TRUE,INDEX(I$44:I45<>\"\",0),0),0))","v":""},null,{"$f":"IF(OR(L44=\"HOL\",L44=\"SUN\",L44=\"SAT\",L44=\"No Read\",L44=\"\"),\"\",IF(INDEX(L44:$L$44,MATCH(TRUE,ISNUMBER(L44:$L$44),0))<LOOKUP(99^99,L$2:L43),(INDEX(L44:$L$44,MATCH(TRUE,ISNUMBER(L44:$L$44),0))*748),(INDEX(L44:$L$44,MATCH(TRUE,ISNUMBER(L44:$L$44),0))-LOOKUP(99^99,L$2:L43))*748))","v":""},"",{"$f":"IF(L44=\"\",O43,IF(M44=\"\",IF(O43>0,O43+1,1),1))","v":1},{"$f":"IF(L45=\"\",\"\",OFFSET(N44,MATCH(TRUE,INDEX(N$44:N45<>\"\",0),0),0))","v":""},null,{"$f":"IF(OR(Q44=\"HOL\",Q44=\"SUN\",Q44=\"SAT\",Q44=\"No Read\",Q44=\"\"),\"\",IF(INDEX(Q44:$Q$44,MATCH(TRUE,ISNUMBER(Q44:$Q$44),0))<LOOKUP(99^99,Q$2:Q43),(INDEX(Q44:$Q$44,MATCH(TRUE,ISNUMBER(Q44:$Q$44),0))*1000),(INDEX(Q44:$Q$44,MATCH(TRUE,ISNUMBER(Q44:$Q$44),0))-LOOKUP(99^99,Q$2:Q43))*1000))","v":""},"",{"$f":"IF(Q44=\"\",T43,IF(R44=\"\",IF(T43>0,T43+1,1),1))","v":1},{"$f":"IF(Q45=\"\",\"\",OFFSET(S44,MATCH(TRUE,INDEX(S$44:S45<>\"\",0),0),0))","v":""}]