{"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":32,"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,164162,{"$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,2219941,{"$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,258750,{"$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,1850603,{"$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,"2022-10-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"]
[1,164214,{"$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":52000},{"$f":"IF(OR(B8=\"HOL\",B8=\"SUN\",B8=\"SAT\",B8=\"No Read\",B8=\"\"),\"\",ROUND(C8/E5,1))","v":52000},{"$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":38000},2221425,{"$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":148400},{"$f":"IF(OR(G8=\"HOL\",G8=\"SUN\",G8=\"SAT\",G8=\"No Read\",G8=\"\"),\"\",ROUND(H8/J5,1))","v":148400},{"$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":173000},258812,{"$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":62000},{"$f":"IF(OR(L8=\"HOL\",L8=\"SUN\",L8=\"SAT\",L8=\"No Read\",L8=\"\"),\"\",ROUND(M8/O5,1))","v":62000},{"$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":42000},1850837,{"$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":234000},{"$f":"IF(OR(Q8=\"HOL\",Q8=\"SUN\",Q8=\"SAT\",Q8=\"No Read\",Q8=\"\"),\"\",ROUND(R8/T5,1))","v":234000},{"$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":279000}]
[2,164252,{"$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":38000},{"$f":"IF(OR(B9=\"HOL\",B9=\"SUN\",B9=\"SAT\",B9=\"No Read\",B9=\"\"),\"\",ROUND(C9/E8,1))","v":38000},{"$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":112000},2223155,{"$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":173000},{"$f":"IF(OR(G9=\"HOL\",G9=\"SUN\",G9=\"SAT\",G9=\"No Read\",G9=\"\"),\"\",ROUND(H9/J8,1))","v":173000},{"$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":164700},258854,{"$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":42000},{"$f":"IF(OR(L9=\"HOL\",L9=\"SUN\",L9=\"SAT\",L9=\"No Read\",L9=\"\"),\"\",ROUND(M9/O8,1))","v":42000},{"$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":129000},1851116,{"$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":279000},{"$f":"IF(OR(Q9=\"HOL\",Q9=\"SUN\",Q9=\"SAT\",Q9=\"No Read\",Q9=\"\"),\"\",ROUND(R9/T8,1))","v":279000},{"$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":273000}]
[3,164364,{"$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":112000},{"$f":"IF(OR(B10=\"HOL\",B10=\"SUN\",B10=\"SAT\",B10=\"No Read\",B10=\"\"),\"\",ROUND(C10/E9,1))","v":112000},{"$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":74000},2224802,{"$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":164700},{"$f":"IF(OR(G10=\"HOL\",G10=\"SUN\",G10=\"SAT\",G10=\"No Read\",G10=\"\"),\"\",ROUND(H10/J9,1))","v":164700},{"$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":151800},258983,{"$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":129000},{"$f":"IF(OR(L10=\"HOL\",L10=\"SUN\",L10=\"SAT\",L10=\"No Read\",L10=\"\"),\"\",ROUND(M10/O9,1))","v":129000},{"$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":91000},1851389,{"$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":273000},{"$f":"IF(OR(Q10=\"HOL\",Q10=\"SUN\",Q10=\"SAT\",Q10=\"No Read\",Q10=\"\"),\"\",ROUND(R10/T9,1))","v":273000},{"$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":239000}]
[4,164438,{"$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":74000},74000,{"$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":110000},2226320,{"$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":151800},151800,{"$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":200800},259074,{"$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":91000},91000,{"$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":136000},1851628,{"$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":239000},239000,{"$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":303000}]
[5,164548,{"$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":110000},110000,{"$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":42000},2228328,{"$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":200800},200800,{"$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":138700},259210,{"$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":136000},136000,{"$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":36000},1851931,{"$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":303000},303000,{"$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":219000}]
[6,164590,{"$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":42000},42000,{"$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":43000},2229715,{"$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":138700},138700,{"$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":157500},259246,{"$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":36000},36000,{"$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":43000},1852150,{"$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":219000},219000,{"$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":246000}]
[7,164633,{"$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":43000},43000,1,{"$f":"IF(B14=\"\",\"\",ROUND(OFFSET(D14,MATCH(TRUE,INDEX(D15:D$44<>\"\",0),0),0),0))","v":107000},2231290,{"$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":157500},157500,1,{"$f":"IF(G14=\"\",\"\",ROUND(OFFSET(I14,MATCH(TRUE,INDEX(I15:I$44<>\"\",0),0),0),0))","v":154000},259289,{"$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":43000},43000,1,{"$f":"IF(L14=\"\",\"\",ROUND(OFFSET(N14,MATCH(TRUE,INDEX(N15:N$44<>\"\",0),0),0),0))","v":122000},1852396,{"$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":246000},246000,1,{"$f":"IF(Q14=\"\",\"\",ROUND(OFFSET(S14,MATCH(TRUE,INDEX(S15:S$44<>\"\",0),0),0),0))","v":240000}]
[8,164740,{"$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":107000},107000,1,{"$f":"IF(B15=\"\",\"\",ROUND(OFFSET(D15,MATCH(TRUE,INDEX(D16:D$44<>\"\",0),0),0),0))","v":51000},2232830,{"$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":154000},154000,1,{"$f":"IF(G15=\"\",\"\",ROUND(OFFSET(I15,MATCH(TRUE,INDEX(I16:I$44<>\"\",0),0),0),0))","v":170500},259411,{"$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":122000},122000,1,{"$f":"IF(L15=\"\",\"\",ROUND(OFFSET(N15,MATCH(TRUE,INDEX(N16:N$44<>\"\",0),0),0),0))","v":57000},1852636,{"$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":240000},240000,1,{"$f":"IF(Q15=\"\",\"\",ROUND(OFFSET(S15,MATCH(TRUE,INDEX(S16:S$44<>\"\",0),0),0),0))","v":268000}]
[9,164791,{"$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":51000},51000,1,{"$f":"IF(B16=\"\",\"\",ROUND(OFFSET(D16,MATCH(TRUE,INDEX(D17:D$44<>\"\",0),0),0),0))","v":37000},2234535,{"$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":170500},170500,1,{"$f":"IF(G16=\"\",\"\",ROUND(OFFSET(I16,MATCH(TRUE,INDEX(I17:I$44<>\"\",0),0),0),0))","v":148500},259468,{"$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":57000},57000,1,{"$f":"IF(L16=\"\",\"\",ROUND(OFFSET(N16,MATCH(TRUE,INDEX(N17:N$44<>\"\",0),0),0),0))","v":44000},1852904,{"$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":268000},268000,1,{"$f":"IF(Q16=\"\",\"\",ROUND(OFFSET(S16,MATCH(TRUE,INDEX(S17:S$44<>\"\",0),0),0),0))","v":245000}]
[10,164828,{"$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":37000},37000,1,{"$f":"IF(B17=\"\",\"\",ROUND(OFFSET(D17,MATCH(TRUE,INDEX(D18:D$44<>\"\",0),0),0),0))","v":108000},2236020,{"$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":148500},148500,1,{"$f":"IF(G17=\"\",\"\",ROUND(OFFSET(I17,MATCH(TRUE,INDEX(I18:I$44<>\"\",0),0),0),0))","v":162500},259512,{"$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":44000},44000,1,{"$f":"IF(L17=\"\",\"\",ROUND(OFFSET(N17,MATCH(TRUE,INDEX(N18:N$44<>\"\",0),0),0),0))","v":124000},1853149,{"$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":245000},245000,1,{"$f":"IF(Q17=\"\",\"\",ROUND(OFFSET(S17,MATCH(TRUE,INDEX(S18:S$44<>\"\",0),0),0),0))","v":265000}]
[11,164936,{"$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":108000},{"$f":"IF(OR(B18=\"HOL\",B18=\"SUN\",B18=\"SAT\",B18=\"No Read\",B18=\"\"),\"\",ROUND(C18/E17,1))","v":108000},1,{"$f":"IF(B18=\"\",\"\",ROUND(OFFSET(D18,MATCH(TRUE,INDEX(D19:D$44<>\"\",0),0),0),0))","v":57000},2237645,{"$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":162500},{"$f":"IF(OR(G18=\"HOL\",G18=\"SUN\",G18=\"SAT\",G18=\"No Read\",G18=\"\"),\"\",ROUND(H18/J17,1))","v":162500},1,{"$f":"IF(G18=\"\",\"\",ROUND(OFFSET(I18,MATCH(TRUE,INDEX(I19:I$44<>\"\",0),0),0),0))","v":165300},259636,{"$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":124000},{"$f":"IF(OR(L18=\"HOL\",L18=\"SUN\",L18=\"SAT\",L18=\"No Read\",L18=\"\"),\"\",ROUND(M18/O17,1))","v":124000},1,{"$f":"IF(L18=\"\",\"\",ROUND(OFFSET(N18,MATCH(TRUE,INDEX(N19:N$44<>\"\",0),0),0),0))","v":80000},1853414,{"$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":265000},{"$f":"IF(OR(Q18=\"HOL\",Q18=\"SUN\",Q18=\"SAT\",Q18=\"No Read\",Q18=\"\"),\"\",ROUND(R18/T17,1))","v":265000},1,{"$f":"IF(Q18=\"\",\"\",ROUND(OFFSET(S18,MATCH(TRUE,INDEX(S19:S$44<>\"\",0),0),0),0))","v":249000},null,null,"These four values can be entered instead of numbers"]
[12,164993,{"$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":57000},{"$f":"IF(OR(B19=\"HOL\",B19=\"SUN\",B19=\"SAT\",B19=\"No Read\",B19=\"\"),\"\",ROUND(C19/E18,1))","v":57000},1,{"$f":"IF(B19=\"\",\"\",ROUND(OFFSET(D19,MATCH(TRUE,INDEX(D20:D$44<>\"\",0),0),0),0))","v":28000},2239298,{"$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":165300},{"$f":"IF(OR(G19=\"HOL\",G19=\"SUN\",G19=\"SAT\",G19=\"No Read\",G19=\"\"),\"\",ROUND(H19/J18,1))","v":165300},1,{"$f":"IF(G19=\"\",\"\",ROUND(OFFSET(I19,MATCH(TRUE,INDEX(I20:I$44<>\"\",0),0),0),0))","v":179000},259716,{"$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":80000},{"$f":"IF(OR(L19=\"HOL\",L19=\"SUN\",L19=\"SAT\",L19=\"No Read\",L19=\"\"),\"\",ROUND(M19/O18,1))","v":80000},1,{"$f":"IF(L19=\"\",\"\",ROUND(OFFSET(N19,MATCH(TRUE,INDEX(N20:N$44<>\"\",0),0),0),0))","v":18000},1853663,{"$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":249000},{"$f":"IF(OR(Q19=\"HOL\",Q19=\"SUN\",Q19=\"SAT\",Q19=\"No Read\",Q19=\"\"),\"\",ROUND(R19/T18,1))","v":249000},1,{"$f":"IF(Q19=\"\",\"\",ROUND(OFFSET(S19,MATCH(TRUE,INDEX(S20:S$44<>\"\",0),0),0),0))","v":273000},null,null,"SAT - Saturday"]
[13,165021,{"$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":28000},28000,1,{"$f":"IF(B20=\"\",\"\",ROUND(OFFSET(D20,MATCH(TRUE,INDEX(D21:D$44<>\"\",0),0),0),0))","v":102000},2241088,{"$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":179000},179000,1,{"$f":"IF(G20=\"\",\"\",ROUND(OFFSET(I20,MATCH(TRUE,INDEX(I21:I$44<>\"\",0),0),0),0))","v":150200},259734,{"$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":18000},18000,1,{"$f":"IF(L20=\"\",\"\",ROUND(OFFSET(N20,MATCH(TRUE,INDEX(N21:N$44<>\"\",0),0),0),0))","v":118000},1853936,{"$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":273000},273000,1,{"$f":"IF(Q20=\"\",\"\",ROUND(OFFSET(S20,MATCH(TRUE,INDEX(S21:S$44<>\"\",0),0),0),0))","v":222000},null,null,"SUN - Sunday"]
[14,165123,{"$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":102000},102000,1,{"$f":"IF(B21=\"\",\"\",ROUND(OFFSET(D21,MATCH(TRUE,INDEX(D22:D$44<>\"\",0),0),0),0))","v":49000},2242590,{"$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":150200},150200,1,{"$f":"IF(G21=\"\",\"\",ROUND(OFFSET(I21,MATCH(TRUE,INDEX(I22:I$44<>\"\",0),0),0),0))","v":146400},259852,{"$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":118000},118000,1,{"$f":"IF(L21=\"\",\"\",ROUND(OFFSET(N21,MATCH(TRUE,INDEX(N22:N$44<>\"\",0),0),0),0))","v":54000},1854158,{"$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":222000},222000,1,{"$f":"IF(Q21=\"\",\"\",ROUND(OFFSET(S21,MATCH(TRUE,INDEX(S22:S$44<>\"\",0),0),0),0))","v":223000},null,null,"HOL - Holiday"]
[15,165172,{"$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":49000},49000,1,{"$f":"IF(B22=\"\",\"\",ROUND(OFFSET(D22,MATCH(TRUE,INDEX(D23:D$44<>\"\",0),0),0),0))","v":36000},2244054,{"$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":146400},146400,1,{"$f":"IF(G22=\"\",\"\",ROUND(OFFSET(I22,MATCH(TRUE,INDEX(I23:I$44<>\"\",0),0),0),0))","v":182000},259906,{"$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":54000},54000,1,{"$f":"IF(L22=\"\",\"\",ROUND(OFFSET(N22,MATCH(TRUE,INDEX(N23:N$44<>\"\",0),0),0),0))","v":43000},1854381,{"$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":223000},223000,1,{"$f":"IF(Q22=\"\",\"\",ROUND(OFFSET(S22,MATCH(TRUE,INDEX(S23:S$44<>\"\",0),0),0),0))","v":249000},null,null,"NO READ - A day when a reading was not taken"]
[16,165208,{"$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":36000},{"$f":"IF(OR(B23=\"HOL\",B23=\"SUN\",B23=\"SAT\",B23=\"No Read\",B23=\"\"),\"\",ROUND(C23/E22,1))","v":36000},1,{"$f":"IF(B23=\"\",\"\",ROUND(OFFSET(D23,MATCH(TRUE,INDEX(D24:D$44<>\"\",0),0),0),0))","v":86000},2245874,{"$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":182000},{"$f":"IF(OR(G23=\"HOL\",G23=\"SUN\",G23=\"SAT\",G23=\"No Read\",G23=\"\"),\"\",ROUND(H23/J22,1))","v":182000},1,{"$f":"IF(G23=\"\",\"\",ROUND(OFFSET(I23,MATCH(TRUE,INDEX(I24:I$44<>\"\",0),0),0),0))","v":148900},259949,{"$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":43000},{"$f":"IF(OR(L23=\"HOL\",L23=\"SUN\",L23=\"SAT\",L23=\"No Read\",L23=\"\"),\"\",ROUND(M23/O22,1))","v":43000},1,{"$f":"IF(L23=\"\",\"\",ROUND(OFFSET(N23,MATCH(TRUE,INDEX(N24:N$44<>\"\",0),0),0),0))","v":99000},1854630,{"$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":249000},{"$f":"IF(OR(Q23=\"HOL\",Q23=\"SUN\",Q23=\"SAT\",Q23=\"No Read\",Q23=\"\"),\"\",ROUND(R23/T22,1))","v":249000},1,{"$f":"IF(Q23=\"\",\"\",ROUND(OFFSET(S23,MATCH(TRUE,INDEX(S24:S$44<>\"\",0),0),0),0))","v":208000}]
[17,165294,{"$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":86000},{"$f":"IF(OR(B24=\"HOL\",B24=\"SUN\",B24=\"SAT\",B24=\"No Read\",B24=\"\"),\"\",ROUND(C24/E23,1))","v":86000},1,{"$f":"IF(B24=\"\",\"\",ROUND(OFFSET(D24,MATCH(TRUE,INDEX(D25:D$44<>\"\",0),0),0),0))","v":0},2247363,{"$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":148900},{"$f":"IF(OR(G24=\"HOL\",G24=\"SUN\",G24=\"SAT\",G24=\"No Read\",G24=\"\"),\"\",ROUND(H24/J23,1))","v":148900},1,{"$f":"IF(G24=\"\",\"\",ROUND(OFFSET(I24,MATCH(TRUE,INDEX(I25:I$44<>\"\",0),0),0),0))","v":156000},260048,{"$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":99000},{"$f":"IF(OR(L24=\"HOL\",L24=\"SUN\",L24=\"SAT\",L24=\"No Read\",L24=\"\"),\"\",ROUND(M24/O23,1))","v":99000},1,{"$f":"IF(L24=\"\",\"\",ROUND(OFFSET(N24,MATCH(TRUE,INDEX(N25:N$44<>\"\",0),0),0),0))","v":0},1854838,{"$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":208000},{"$f":"IF(OR(Q24=\"HOL\",Q24=\"SUN\",Q24=\"SAT\",Q24=\"No Read\",Q24=\"\"),\"\",ROUND(R24/T23,1))","v":208000},1,{"$f":"IF(Q24=\"\",\"\",ROUND(OFFSET(S24,MATCH(TRUE,INDEX(S25:S$44<>\"\",0),0),0),0))","v":221000}]
[18,165294,{"$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":0},0,1,{"$f":"IF(B25=\"\",\"\",ROUND(OFFSET(D25,MATCH(TRUE,INDEX(D26:D$44<>\"\",0),0),0),0))","v":95000},2248923,{"$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":156000},156000,1,{"$f":"IF(G25=\"\",\"\",ROUND(OFFSET(I25,MATCH(TRUE,INDEX(I26:I$44<>\"\",0),0),0),0))","v":156900},260048,{"$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":0},0,1,{"$f":"IF(L25=\"\",\"\",ROUND(OFFSET(N25,MATCH(TRUE,INDEX(N26:N$44<>\"\",0),0),0),0))","v":108000},1855059,{"$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":221000},221000,1,{"$f":"IF(Q25=\"\",\"\",ROUND(OFFSET(S25,MATCH(TRUE,INDEX(S26:S$44<>\"\",0),0),0),0))","v":213000},null,null,"Cl2 used"]
[19,165389,{"$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":95000},95000,1,{"$f":"IF(B26=\"\",\"\",ROUND(OFFSET(D26,MATCH(TRUE,INDEX(D27:D$44<>\"\",0),0),0),0))","v":0},2250492,{"$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":156900},156900,1,{"$f":"IF(G26=\"\",\"\",ROUND(OFFSET(I26,MATCH(TRUE,INDEX(I27:I$44<>\"\",0),0),0),0))","v":131800},260156,{"$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":108000},108000,1,{"$f":"IF(L26=\"\",\"\",ROUND(OFFSET(N26,MATCH(TRUE,INDEX(N27:N$44<>\"\",0),0),0),0))","v":0},1855272,{"$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":213000},213000,1,{"$f":"IF(Q26=\"\",\"\",ROUND(OFFSET(S26,MATCH(TRUE,INDEX(S27:S$44<>\"\",0),0),0),0))","v":186000},null,null,"Beginning",null,"Ending"]
[20,165389,{"$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":0},0,1,{"$f":"IF(B27=\"\",\"\",ROUND(OFFSET(D27,MATCH(TRUE,INDEX(D28:D$44<>\"\",0),0),0),0))","v":89000},2251810,{"$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":131800},131800,1,{"$f":"IF(G27=\"\",\"\",ROUND(OFFSET(I27,MATCH(TRUE,INDEX(I28:I$44<>\"\",0),0),0),0))","v":175900},260156,{"$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":0},0,1,{"$f":"IF(L27=\"\",\"\",ROUND(OFFSET(N27,MATCH(TRUE,INDEX(N28:N$44<>\"\",0),0),0),0))","v":102000},1855458,{"$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":186000},186000,1,{"$f":"IF(Q27=\"\",\"\",ROUND(OFFSET(S27,MATCH(TRUE,INDEX(S28:S$44<>\"\",0),0),0),0))","v":251000},null,null,150,null,125]
[21,165478,{"$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":89000},89000,1,{"$f":"IF(B28=\"\",\"\",ROUND(OFFSET(D28,MATCH(TRUE,INDEX(D29:D$44<>\"\",0),0),0),0))","v":92000},2253569,{"$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":175900},175900,1,{"$f":"IF(G28=\"\",\"\",ROUND(OFFSET(I28,MATCH(TRUE,INDEX(I29:I$44<>\"\",0),0),0),0))","v":135600},260258,{"$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":102000},102000,1,{"$f":"IF(L28=\"\",\"\",ROUND(OFFSET(N28,MATCH(TRUE,INDEX(N29:N$44<>\"\",0),0),0),0))","v":107000},1855709,{"$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":251000},251000,1,{"$f":"IF(Q28=\"\",\"\",ROUND(OFFSET(S28,MATCH(TRUE,INDEX(S29:S$44<>\"\",0),0),0),0))","v":208000},null,null,425,null,265]
[22,165570,{"$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":92000},92000,1,{"$f":"IF(B29=\"\",\"\",ROUND(OFFSET(D29,MATCH(TRUE,INDEX(D30:D$44<>\"\",0),0),0),0))","v":0},2254925,{"$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":135600},135600,1,{"$f":"IF(G29=\"\",\"\",ROUND(OFFSET(I29,MATCH(TRUE,INDEX(I30:I$44<>\"\",0),0),0),0))","v":148400},260365,{"$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":107000},107000,1,{"$f":"IF(L29=\"\",\"\",ROUND(OFFSET(N29,MATCH(TRUE,INDEX(N30:N$44<>\"\",0),0),0),0))","v":0},1855917,{"$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":208000},208000,1,{"$f":"IF(Q29=\"\",\"\",ROUND(OFFSET(S29,MATCH(TRUE,INDEX(S30:S$44<>\"\",0),0),0),0))","v":210000},null,null,"Month Total:",{"$f":"X27-Z27+X28-Z28","v":185},null,"Gallons"]
[23,165570,{"$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":0},0,1,{"$f":"IF(B30=\"\",\"\",ROUND(OFFSET(D30,MATCH(TRUE,INDEX(D31:D$44<>\"\",0),0),0),0))","v":105000},2256409,{"$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":148400},148400,1,{"$f":"IF(G30=\"\",\"\",ROUND(OFFSET(I30,MATCH(TRUE,INDEX(I31:I$44<>\"\",0),0),0),0))","v":171200},260365,{"$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":0},0,1,{"$f":"IF(L30=\"\",\"\",ROUND(OFFSET(N30,MATCH(TRUE,INDEX(N31:N$44<>\"\",0),0),0),0))","v":122000},1856127,{"$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":210000},210000,1,{"$f":"IF(Q30=\"\",\"\",ROUND(OFFSET(S30,MATCH(TRUE,INDEX(S31:S$44<>\"\",0),0),0),0))","v":273000}]
[24,165675,{"$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":105000},105000,1,{"$f":"IF(B31=\"\",\"\",ROUND(OFFSET(D31,MATCH(TRUE,INDEX(D32:D$44<>\"\",0),0),0),0))","v":25000},2258121,{"$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":171200},171200,1,{"$f":"IF(G31=\"\",\"\",ROUND(OFFSET(I31,MATCH(TRUE,INDEX(I32:I$44<>\"\",0),0),0),0))","v":164000},260487,{"$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":122000},122000,1,{"$f":"IF(L31=\"\",\"\",ROUND(OFFSET(N31,MATCH(TRUE,INDEX(N32:N$44<>\"\",0),0),0),0))","v":34000},1856400,{"$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":273000},273000,1,{"$f":"IF(Q31=\"\",\"\",ROUND(OFFSET(S31,MATCH(TRUE,INDEX(S32:S$44<>\"\",0),0),0),0))","v":250000}]
[25,165700,{"$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":25000},25000,1,{"$f":"IF(B32=\"\",\"\",ROUND(OFFSET(D32,MATCH(TRUE,INDEX(D33:D$44<>\"\",0),0),0),0))","v":64000},2259761,{"$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":164000},164000,1,{"$f":"IF(G32=\"\",\"\",ROUND(OFFSET(I32,MATCH(TRUE,INDEX(I33:I$44<>\"\",0),0),0),0))","v":179700},260521,{"$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":34000},34000,1,{"$f":"IF(L32=\"\",\"\",ROUND(OFFSET(N32,MATCH(TRUE,INDEX(N33:N$44<>\"\",0),0),0),0))","v":66000},1856650,{"$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":250000},250000,1,{"$f":"IF(Q32=\"\",\"\",ROUND(OFFSET(S32,MATCH(TRUE,INDEX(S33:S$44<>\"\",0),0),0),0))","v":262000}]
[26,165764,{"$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":64000},64000,1,{"$f":"IF(B33=\"\",\"\",ROUND(OFFSET(D33,MATCH(TRUE,INDEX(D34:D$44<>\"\",0),0),0),0))","v":102000},2261558,{"$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":179700},179700,1,{"$f":"IF(G33=\"\",\"\",ROUND(OFFSET(I33,MATCH(TRUE,INDEX(I34:I$44<>\"\",0),0),0),0))","v":133600},260587,{"$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":66000},66000,1,{"$f":"IF(L33=\"\",\"\",ROUND(OFFSET(N33,MATCH(TRUE,INDEX(N34:N$44<>\"\",0),0),0),0))","v":118000},1856912,{"$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":262000},262000,1,{"$f":"IF(Q33=\"\",\"\",ROUND(OFFSET(S33,MATCH(TRUE,INDEX(S34:S$44<>\"\",0),0),0),0))","v":190000},null,null,"Sum of Wells 1-4",null,null,null,null,"Sum of Boosters 1-4"]
[27,165866,{"$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":102000},102000,1,{"$f":"IF(B34=\"\",\"\",ROUND(OFFSET(D34,MATCH(TRUE,INDEX(D35:D$44<>\"\",0),0),0),0))","v":0},2262894,{"$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":133600},133600,1,{"$f":"IF(G34=\"\",\"\",ROUND(OFFSET(I34,MATCH(TRUE,INDEX(I35:I$44<>\"\",0),0),0),0))","v":156600},260705,{"$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":118000},118000,1,{"$f":"IF(L34=\"\",\"\",ROUND(OFFSET(N34,MATCH(TRUE,INDEX(N35:N$44<>\"\",0),0),0),0))","v":0},1857102,{"$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":190000},190000,1,{"$f":"IF(Q34=\"\",\"\",ROUND(OFFSET(S34,MATCH(TRUE,INDEX(S35:S$44<>\"\",0),0),0),0))","v":231000}]
[28,165866,{"$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":0},0,1,{"$f":"IF(B35=\"\",\"\",ROUND(OFFSET(D35,MATCH(TRUE,INDEX(D36:D$44<>\"\",0),0),0),0))","v":100000},2264460,{"$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":156600},156600,1,{"$f":"IF(G35=\"\",\"\",ROUND(OFFSET(I35,MATCH(TRUE,INDEX(I36:I$44<>\"\",0),0),0),0))","v":145300},260705,{"$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":0},0,1,{"$f":"IF(L35=\"\",\"\",ROUND(OFFSET(N35,MATCH(TRUE,INDEX(N36:N$44<>\"\",0),0),0),0))","v":115000},1857333,{"$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":231000},231000,1,{"$f":"IF(Q35=\"\",\"\",ROUND(OFFSET(S35,MATCH(TRUE,INDEX(S36:S$44<>\"\",0),0),0),0))","v":221000},null,null,{"$f":"SUM('3 & 4'!F39,'3 & 4'!P39,F39,P39)","v":17646724},null,null,"Gallons",null,{"$f":"SUM('3 & 4'!K39,'3 & 4'!U39,'1 & 2'!K39,'1 & 2'!U39)","v":17766200},null,null,"Gallons"]
[29,165966,{"$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":100000},100000,{"$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":40000},2265913,{"$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":145300},145300,{"$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":163300},260820,{"$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":47000},1857554,{"$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":221000},221000,{"$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":248000}]
[30,166006,{"$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":40000},40000,{"$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":53000},2267546,{"$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":163300},163300,{"$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":165900},260867,{"$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":47000},47000,{"$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":60000},1857802,{"$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":248000},248000,{"$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":258000},null,null,{"$f":"SUM('3 & 4'!F40,'3 & 4'!P40,'1 & 2'!F40,'1 & 2'!P40)","v":54.155475014807294},null,null,"Acre-Ft.",null,{"$f":"SUM('3 & 4'!K40,'3 & 4'!U40,'1 & 2'!K40,'1 & 2'!U40)","v":54.522131145025519},null,null,"Acre-Ft."]
[31,166059,{"$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":53000},53000,{"$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":99000},2269205,{"$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":165900},165900,{"$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":156200},260927,{"$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":60000},60000,{"$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":114000},1858060,{"$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":258000},258000,{"$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":234000}]
["TOTAL:",null,null,null,null,{"$f":"IF(COUNTBLANK(F$8:F$38)=31,\"\",SUM(F$8:F$38))","v":1944000},null,null,null,null,{"$f":"IF(COUNTBLANK(K$8:K$38)=31,\"\",SUM(K$8:K$38))","v":4934200},null,null,null,null,{"$f":"IF(COUNTBLANK(P$8:P$38)=31,\"\",SUM(P$8:P$38))","v":2229000},null,null,null,null,{"$f":"IF(COUNTBLANK(U$8:U$38)=31,\"\",SUM(U$8:U$38))","v":7457000},"Gallons"]
[null,null,null,null,null,{"$f":"IF(F$39=\"\",\"\",F$39/325853)","v":5.9658803202671145},null,null,null,null,{"$f":"IF(K$39=\"\",\"\",K$39/325853)","v":15.142410841698558},null,null,null,null,{"$f":"IF(P$39=\"\",\"\",P$39/325853)","v":6.8405078363556573},null,null,null,null,{"$f":"IF(U$39=\"\",\"\",U$39/325853)","v":22.884552236744788},"Acre-Ft."]
[null,166158,{"$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":99000},{"$f":"IF(OR(B41=\"HOL\",B41=\"SUN\",B41=\"SAT\",B41=\"No Read\",B41=\"\"),\"\",ROUND(C41/E38,1))","v":99000},{"$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":""},2270767,{"$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":156200},{"$f":"IF(OR(G41=\"HOL\",G41=\"SUN\",G41=\"SAT\",G41=\"No Read\",G41=\"\"),\"\",ROUND(H41/J38,1))","v":156200},{"$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":""},261041,{"$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":114000},{"$f":"IF(OR(L41=\"HOL\",L41=\"SUN\",L41=\"SAT\",L41=\"No Read\",L41=\"\"),\"\",ROUND(M41/O38,1))","v":114000},{"$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":""},1858294,{"$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":234000},{"$f":"IF(OR(Q41=\"HOL\",Q41=\"SUN\",Q41=\"SAT\",Q41=\"No Read\",Q41=\"\"),\"\",ROUND(R41/T38,1))","v":234000},{"$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":24,"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,517370,{"$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,1348050,{"$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,1867449,{"$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,199257,{"$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,"2022-10-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"]
[1,517508,{"$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":103224},{"$f":"IF(OR(B8=\"HOL\",B8=\"SUN\",B8=\"SAT\",B8=\"No Read\",B8=\"\"),\"\",ROUND(C8/E5,1))","v":103224},{"$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":61336},1348280,{"$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":230000},{"$f":"IF(OR(G8=\"HOL\",G8=\"SUN\",G8=\"SAT\",G8=\"No Read\",G8=\"\"),\"\",ROUND(H8/J5,1))","v":230000},{"$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":175000},1867954,{"$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":377740},{"$f":"IF(OR(L8=\"HOL\",L8=\"SUN\",L8=\"SAT\",L8=\"No Read\",L8=\"\"),\"\",ROUND(M8/O5,1))","v":377740},{"$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":187000},199264,{"$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":7000},{"$f":"IF(OR(Q8=\"HOL\",Q8=\"SUN\",Q8=\"SAT\",Q8=\"No Read\",Q8=\"\"),\"\",ROUND(R8/T5,1))","v":7000},{"$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}]
[2,517590,{"$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":61336},{"$f":"IF(OR(B9=\"HOL\",B9=\"SUN\",B9=\"SAT\",B9=\"No Read\",B9=\"\"),\"\",ROUND(C9/E8,1))","v":61336},{"$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":198968},1348455,{"$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":175000},{"$f":"IF(OR(G9=\"HOL\",G9=\"SUN\",G9=\"SAT\",G9=\"No Read\",G9=\"\"),\"\",ROUND(H9/J8,1))","v":175000},{"$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":318000},1868204,{"$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":187000},{"$f":"IF(OR(L9=\"HOL\",L9=\"SUN\",L9=\"SAT\",L9=\"No Read\",L9=\"\"),\"\",ROUND(M9/O8,1))","v":187000},{"$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":613360},199264,{"$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":0}]
[3,517856,{"$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":198968},{"$f":"IF(OR(B10=\"HOL\",B10=\"SUN\",B10=\"SAT\",B10=\"No Read\",B10=\"\"),\"\",ROUND(C10/E9,1))","v":198968},{"$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":174284},1348773,{"$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":318000},{"$f":"IF(OR(G10=\"HOL\",G10=\"SUN\",G10=\"SAT\",G10=\"No Read\",G10=\"\"),\"\",ROUND(H10/J9,1))","v":318000},{"$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":241000},1869024,{"$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":613360},{"$f":"IF(OR(L10=\"HOL\",L10=\"SUN\",L10=\"SAT\",L10=\"No Read\",L10=\"\"),\"\",ROUND(M10/O9,1))","v":613360},{"$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":385968},199264,{"$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":0},{"$f":"IF(OR(Q10=\"HOL\",Q10=\"SUN\",Q10=\"SAT\",Q10=\"No Read\",Q10=\"\"),\"\",ROUND(R10/T9,1))","v":0},{"$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":0}]
[4,518089,{"$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":174284},174284,{"$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":143616},1349014,{"$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":241000},241000,{"$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":219000},1869540,{"$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":385968},385968,{"$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":237116},199264,{"$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":0},0,{"$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}]
[5,518281,{"$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":143616},143616,{"$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":108460},1349233,{"$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":219000},219000,{"$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":229000},1869857,{"$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":237116},237116,{"$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":326876},199264,{"$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}]
[6,518426,{"$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":108460},108460,{"$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":55352},1349462,{"$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":229000},229000,{"$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":252000},1870294,{"$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":326876},326876,{"$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":172788},199264,{"$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":8000}]
[7,518500,{"$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":55352},55352,1,{"$f":"IF(B14=\"\",\"\",ROUND(OFFSET(D14,MATCH(TRUE,INDEX(D15:D$44<>\"\",0),0),0),0))","v":192984},1349714,{"$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":252000},252000,1,{"$f":"IF(G14=\"\",\"\",ROUND(OFFSET(I14,MATCH(TRUE,INDEX(I15:I$44<>\"\",0),0),0),0))","v":215000},1870525,{"$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":172788},172788,1,{"$f":"IF(L14=\"\",\"\",ROUND(OFFSET(N14,MATCH(TRUE,INDEX(N15:N$44<>\"\",0),0),0),0))","v":582692},199272,{"$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":8000},8000,1,{"$f":"IF(Q14=\"\",\"\",ROUND(OFFSET(S14,MATCH(TRUE,INDEX(S15:S$44<>\"\",0),0),0),0))","v":0}]
[8,518758,{"$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":192984},192984,1,{"$f":"IF(B15=\"\",\"\",ROUND(OFFSET(D15,MATCH(TRUE,INDEX(D16:D$44<>\"\",0),0),0),0))","v":95744},1349929,{"$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":215000},215000,1,{"$f":"IF(G15=\"\",\"\",ROUND(OFFSET(I15,MATCH(TRUE,INDEX(I16:I$44<>\"\",0),0),0),0))","v":153000},1871304,{"$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":582692},582692,1,{"$f":"IF(L15=\"\",\"\",ROUND(OFFSET(N15,MATCH(TRUE,INDEX(N16:N$44<>\"\",0),0),0),0))","v":278256},199272,{"$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":0},0,1,{"$f":"IF(Q15=\"\",\"\",ROUND(OFFSET(S15,MATCH(TRUE,INDEX(S16:S$44<>\"\",0),0),0),0))","v":0}]
[9,518886,{"$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":95744},95744,1,{"$f":"IF(B16=\"\",\"\",ROUND(OFFSET(D16,MATCH(TRUE,INDEX(D17:D$44<>\"\",0),0),0),0))","v":65076},1350082,{"$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":153000},153000,1,{"$f":"IF(G16=\"\",\"\",ROUND(OFFSET(I16,MATCH(TRUE,INDEX(I17:I$44<>\"\",0),0),0),0))","v":229000},1871676,{"$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":278256},278256,1,{"$f":"IF(L16=\"\",\"\",ROUND(OFFSET(N16,MATCH(TRUE,INDEX(N17:N$44<>\"\",0),0),0),0))","v":203456},199272,{"$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":0}]
[10,518973,{"$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":65076},65076,1,{"$f":"IF(B17=\"\",\"\",ROUND(OFFSET(D17,MATCH(TRUE,INDEX(D18:D$44<>\"\",0),0),0),0))","v":198968},1350311,{"$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":229000},229000,1,{"$f":"IF(G17=\"\",\"\",ROUND(OFFSET(I17,MATCH(TRUE,INDEX(I18:I$44<>\"\",0),0),0),0))","v":245000},1871948,{"$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":203456},203456,1,{"$f":"IF(L17=\"\",\"\",ROUND(OFFSET(N17,MATCH(TRUE,INDEX(N18:N$44<>\"\",0),0),0),0))","v":587928},199272,{"$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":0},0,1,{"$f":"IF(Q17=\"\",\"\",ROUND(OFFSET(S17,MATCH(TRUE,INDEX(S18:S$44<>\"\",0),0),0),0))","v":0}]
[11,519239,{"$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":198968},{"$f":"IF(OR(B18=\"HOL\",B18=\"SUN\",B18=\"SAT\",B18=\"No Read\",B18=\"\"),\"\",ROUND(C18/E17,1))","v":198968},1,{"$f":"IF(B18=\"\",\"\",ROUND(OFFSET(D18,MATCH(TRUE,INDEX(D19:D$44<>\"\",0),0),0),0))","v":115940},1350556,{"$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":166000},1872734,{"$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":587928},{"$f":"IF(OR(L18=\"HOL\",L18=\"SUN\",L18=\"SAT\",L18=\"No Read\",L18=\"\"),\"\",ROUND(M18/O17,1))","v":587928},1,{"$f":"IF(L18=\"\",\"\",ROUND(OFFSET(N18,MATCH(TRUE,INDEX(N19:N$44<>\"\",0),0),0),0))","v":229636},199272,{"$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":0},{"$f":"IF(OR(Q18=\"HOL\",Q18=\"SUN\",Q18=\"SAT\",Q18=\"No Read\",Q18=\"\"),\"\",ROUND(R18/T17,1))","v":0},1,{"$f":"IF(Q18=\"\",\"\",ROUND(OFFSET(S18,MATCH(TRUE,INDEX(S19:S$44<>\"\",0),0),0),0))","v":0},null,null,"These four values can be entered instead of numbers"]
[12,519394,{"$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":115940},{"$f":"IF(OR(B19=\"HOL\",B19=\"SUN\",B19=\"SAT\",B19=\"No Read\",B19=\"\"),\"\",ROUND(C19/E18,1))","v":115940},1,{"$f":"IF(B19=\"\",\"\",ROUND(OFFSET(D19,MATCH(TRUE,INDEX(D20:D$44<>\"\",0),0),0),0))","v":41140},1350722,{"$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":166000},{"$f":"IF(OR(G19=\"HOL\",G19=\"SUN\",G19=\"SAT\",G19=\"No Read\",G19=\"\"),\"\",ROUND(H19/J18,1))","v":166000},1,{"$f":"IF(G19=\"\",\"\",ROUND(OFFSET(I19,MATCH(TRUE,INDEX(I20:I$44<>\"\",0),0),0),0))","v":196000},1873041,{"$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":229636},{"$f":"IF(OR(L19=\"HOL\",L19=\"SUN\",L19=\"SAT\",L19=\"No Read\",L19=\"\"),\"\",ROUND(M19/O18,1))","v":229636},1,{"$f":"IF(L19=\"\",\"\",ROUND(OFFSET(N19,MATCH(TRUE,INDEX(N20:N$44<>\"\",0),0),0),0))","v":234124},199272,{"$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":0},{"$f":"IF(OR(Q19=\"HOL\",Q19=\"SUN\",Q19=\"SAT\",Q19=\"No Read\",Q19=\"\"),\"\",ROUND(R19/T18,1))","v":0},1,{"$f":"IF(Q19=\"\",\"\",ROUND(OFFSET(S19,MATCH(TRUE,INDEX(S20:S$44<>\"\",0),0),0),0))","v":0},null,null,"SAT - Saturday"]
[13,519449,{"$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":41140},41140,1,{"$f":"IF(B20=\"\",\"\",ROUND(OFFSET(D20,MATCH(TRUE,INDEX(D21:D$44<>\"\",0),0),0),0))","v":189244},1350918,{"$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":196000},196000,1,{"$f":"IF(G20=\"\",\"\",ROUND(OFFSET(I20,MATCH(TRUE,INDEX(I21:I$44<>\"\",0),0),0),0))","v":196000},1873354,{"$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":234124},234124,1,{"$f":"IF(L20=\"\",\"\",ROUND(OFFSET(N20,MATCH(TRUE,INDEX(N21:N$44<>\"\",0),0),0),0))","v":560252},199272,{"$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":0},0,1,{"$f":"IF(Q20=\"\",\"\",ROUND(OFFSET(S20,MATCH(TRUE,INDEX(S21:S$44<>\"\",0),0),0),0))","v":0},null,null,"SUN - Sunday"]
[14,519702,{"$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":189244},189244,1,{"$f":"IF(B21=\"\",\"\",ROUND(OFFSET(D21,MATCH(TRUE,INDEX(D22:D$44<>\"\",0),0),0),0))","v":106216},1351114,{"$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":196000},196000,1,{"$f":"IF(G21=\"\",\"\",ROUND(OFFSET(I21,MATCH(TRUE,INDEX(I22:I$44<>\"\",0),0),0),0))","v":180000},1874103,{"$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":560252},560252,1,{"$f":"IF(L21=\"\",\"\",ROUND(OFFSET(N21,MATCH(TRUE,INDEX(N22:N$44<>\"\",0),0),0),0))","v":306680},199272,{"$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":40000},null,null,"HOL - Holiday"]
[15,519844,{"$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":106216},106216,1,{"$f":"IF(B22=\"\",\"\",ROUND(OFFSET(D22,MATCH(TRUE,INDEX(D23:D$44<>\"\",0),0),0),0))","v":44132},1351294,{"$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":180000},180000,1,{"$f":"IF(G22=\"\",\"\",ROUND(OFFSET(I22,MATCH(TRUE,INDEX(I23:I$44<>\"\",0),0),0),0))","v":51000},1874513,{"$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":306680},306680,1,{"$f":"IF(L22=\"\",\"\",ROUND(OFFSET(N22,MATCH(TRUE,INDEX(N23:N$44<>\"\",0),0),0),0))","v":154088},199312,{"$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":40000},40000,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"]
[16,519903,{"$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":44132},{"$f":"IF(OR(B23=\"HOL\",B23=\"SUN\",B23=\"SAT\",B23=\"No Read\",B23=\"\"),\"\",ROUND(C23/E22,1))","v":44132},1,{"$f":"IF(B23=\"\",\"\",ROUND(OFFSET(D23,MATCH(TRUE,INDEX(D24:D$44<>\"\",0),0),0),0))","v":140624},1351345,{"$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":51000},{"$f":"IF(OR(G23=\"HOL\",G23=\"SUN\",G23=\"SAT\",G23=\"No Read\",G23=\"\"),\"\",ROUND(H23/J22,1))","v":51000},1,{"$f":"IF(G23=\"\",\"\",ROUND(OFFSET(I23,MATCH(TRUE,INDEX(I24:I$44<>\"\",0),0),0),0))","v":92000},1874719,{"$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":154088},{"$f":"IF(OR(L23=\"HOL\",L23=\"SUN\",L23=\"SAT\",L23=\"No Read\",L23=\"\"),\"\",ROUND(M23/O22,1))","v":154088},1,{"$f":"IF(L23=\"\",\"\",ROUND(OFFSET(N23,MATCH(TRUE,INDEX(N24:N$44<>\"\",0),0),0),0))","v":471988},199312,{"$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}]
[17,520091,{"$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":140624},{"$f":"IF(OR(B24=\"HOL\",B24=\"SUN\",B24=\"SAT\",B24=\"No Read\",B24=\"\"),\"\",ROUND(C24/E23,1))","v":140624},1,{"$f":"IF(B24=\"\",\"\",ROUND(OFFSET(D24,MATCH(TRUE,INDEX(D25:D$44<>\"\",0),0),0),0))","v":0},1351437,{"$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":92000},{"$f":"IF(OR(G24=\"HOL\",G24=\"SUN\",G24=\"SAT\",G24=\"No Read\",G24=\"\"),\"\",ROUND(H24/J23,1))","v":92000},1,{"$f":"IF(G24=\"\",\"\",ROUND(OFFSET(I24,MATCH(TRUE,INDEX(I25:I$44<>\"\",0),0),0),0))","v":97000},1875350,{"$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":471988},{"$f":"IF(OR(L24=\"HOL\",L24=\"SUN\",L24=\"SAT\",L24=\"No Read\",L24=\"\"),\"\",ROUND(M24/O23,1))","v":471988},1,{"$f":"IF(L24=\"\",\"\",ROUND(OFFSET(N24,MATCH(TRUE,INDEX(N25:N$44<>\"\",0),0),0),0))","v":0},199312,{"$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":0}]
[18,520091,{"$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":0},0,1,{"$f":"IF(B25=\"\",\"\",ROUND(OFFSET(D25,MATCH(TRUE,INDEX(D26:D$44<>\"\",0),0),0),0))","v":145112},1351534,{"$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":97000},97000,1,{"$f":"IF(G25=\"\",\"\",ROUND(OFFSET(I25,MATCH(TRUE,INDEX(I26:I$44<>\"\",0),0),0),0))","v":108000},1875350,{"$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":0},0,1,{"$f":"IF(L25=\"\",\"\",ROUND(OFFSET(N25,MATCH(TRUE,INDEX(N26:N$44<>\"\",0),0),0),0))","v":513876},199312,{"$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":0},0,1,{"$f":"IF(Q25=\"\",\"\",ROUND(OFFSET(S25,MATCH(TRUE,INDEX(S26:S$44<>\"\",0),0),0),0))","v":0}]
[19,520285,{"$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":145112},145112,1,{"$f":"IF(B26=\"\",\"\",ROUND(OFFSET(D26,MATCH(TRUE,INDEX(D27:D$44<>\"\",0),0),0),0))","v":0},1351642,{"$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":108000},108000,1,{"$f":"IF(G26=\"\",\"\",ROUND(OFFSET(I26,MATCH(TRUE,INDEX(I27:I$44<>\"\",0),0),0),0))","v":144000},1876037,{"$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":513876},513876,1,{"$f":"IF(L26=\"\",\"\",ROUND(OFFSET(N26,MATCH(TRUE,INDEX(N27:N$44<>\"\",0),0),0),0))","v":0},199312,{"$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":0},0,1,{"$f":"IF(Q26=\"\",\"\",ROUND(OFFSET(S26,MATCH(TRUE,INDEX(S27:S$44<>\"\",0),0),0),0))","v":0}]
[20,520285,{"$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":0},0,1,{"$f":"IF(B27=\"\",\"\",ROUND(OFFSET(D27,MATCH(TRUE,INDEX(D28:D$44<>\"\",0),0),0),0))","v":133892},1351786,{"$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":144000},144000,1,{"$f":"IF(G27=\"\",\"\",ROUND(OFFSET(I27,MATCH(TRUE,INDEX(I28:I$44<>\"\",0),0),0),0))","v":108000},1876037,{"$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":0},0,1,{"$f":"IF(L27=\"\",\"\",ROUND(OFFSET(N27,MATCH(TRUE,INDEX(N28:N$44<>\"\",0),0),0),0))","v":483956},199312,{"$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}]
[21,520464,{"$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":133892},133892,1,{"$f":"IF(B28=\"\",\"\",ROUND(OFFSET(D28,MATCH(TRUE,INDEX(D29:D$44<>\"\",0),0),0),0))","v":137632},1351894,{"$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":108000},108000,1,{"$f":"IF(G28=\"\",\"\",ROUND(OFFSET(I28,MATCH(TRUE,INDEX(I29:I$44<>\"\",0),0),0),0))","v":136000},1876684,{"$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":483956},483956,1,{"$f":"IF(L28=\"\",\"\",ROUND(OFFSET(N28,MATCH(TRUE,INDEX(N29:N$44<>\"\",0),0),0),0))","v":504900},199312,{"$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":51000}]
[22,520648,{"$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":137632},137632,1,{"$f":"IF(B29=\"\",\"\",ROUND(OFFSET(D29,MATCH(TRUE,INDEX(D30:D$44<>\"\",0),0),0),0))","v":0},1352030,{"$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":136000},136000,1,{"$f":"IF(G29=\"\",\"\",ROUND(OFFSET(I29,MATCH(TRUE,INDEX(I30:I$44<>\"\",0),0),0),0))","v":58000},1877359,{"$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":504900},504900,1,{"$f":"IF(L29=\"\",\"\",ROUND(OFFSET(N29,MATCH(TRUE,INDEX(N30:N$44<>\"\",0),0),0),0))","v":0},199363,{"$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":51000},51000,1,{"$f":"IF(Q29=\"\",\"\",ROUND(OFFSET(S29,MATCH(TRUE,INDEX(S30:S$44<>\"\",0),0),0),0))","v":0}]
[23,520648,{"$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":0},0,1,{"$f":"IF(B30=\"\",\"\",ROUND(OFFSET(D30,MATCH(TRUE,INDEX(D31:D$44<>\"\",0),0),0),0))","v":158576},1352088,{"$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":58000},58000,1,{"$f":"IF(G30=\"\",\"\",ROUND(OFFSET(I30,MATCH(TRUE,INDEX(I31:I$44<>\"\",0),0),0),0))","v":203000},1877359,{"$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":0},0,1,{"$f":"IF(L30=\"\",\"\",ROUND(OFFSET(N30,MATCH(TRUE,INDEX(N31:N$44<>\"\",0),0),0),0))","v":578952},199363,{"$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":0},0,1,{"$f":"IF(Q30=\"\",\"\",ROUND(OFFSET(S30,MATCH(TRUE,INDEX(S31:S$44<>\"\",0),0),0),0))","v":0}]
[24,520860,{"$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":158576},158576,1,{"$f":"IF(B31=\"\",\"\",ROUND(OFFSET(D31,MATCH(TRUE,INDEX(D32:D$44<>\"\",0),0),0),0))","v":52360},1352291,{"$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":203000},203000,1,{"$f":"IF(G31=\"\",\"\",ROUND(OFFSET(I31,MATCH(TRUE,INDEX(I32:I$44<>\"\",0),0),0),0))","v":192000},1878133,{"$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":578952},578952,1,{"$f":"IF(L31=\"\",\"\",ROUND(OFFSET(N31,MATCH(TRUE,INDEX(N32:N$44<>\"\",0),0),0),0))","v":177276},199363,{"$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":0}]
[25,520930,{"$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":52360},52360,1,{"$f":"IF(B32=\"\",\"\",ROUND(OFFSET(D32,MATCH(TRUE,INDEX(D33:D$44<>\"\",0),0),0),0))","v":78540},1352483,{"$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":192000},192000,1,{"$f":"IF(G32=\"\",\"\",ROUND(OFFSET(I32,MATCH(TRUE,INDEX(I33:I$44<>\"\",0),0),0),0))","v":139000},1878370,{"$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":177276},177276,1,{"$f":"IF(L32=\"\",\"\",ROUND(OFFSET(N32,MATCH(TRUE,INDEX(N33:N$44<>\"\",0),0),0),0))","v":298452},199363,{"$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":0},0,1,{"$f":"IF(Q32=\"\",\"\",ROUND(OFFSET(S32,MATCH(TRUE,INDEX(S33:S$44<>\"\",0),0),0),0))","v":0}]
[26,521035,{"$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":78540},78540,1,{"$f":"IF(B33=\"\",\"\",ROUND(OFFSET(D33,MATCH(TRUE,INDEX(D34:D$44<>\"\",0),0),0),0))","v":154088},1352622,{"$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":139000},139000,1,{"$f":"IF(G33=\"\",\"\",ROUND(OFFSET(I33,MATCH(TRUE,INDEX(I34:I$44<>\"\",0),0),0),0))","v":162000},1878769,{"$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":298452},298452,1,{"$f":"IF(L33=\"\",\"\",ROUND(OFFSET(N33,MATCH(TRUE,INDEX(N34:N$44<>\"\",0),0),0),0))","v":558008},199363,{"$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":0},0,1,{"$f":"IF(Q33=\"\",\"\",ROUND(OFFSET(S33,MATCH(TRUE,INDEX(S34:S$44<>\"\",0),0),0),0))","v":0}]
[27,521241,{"$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":154088},154088,1,{"$f":"IF(B34=\"\",\"\",ROUND(OFFSET(D34,MATCH(TRUE,INDEX(D35:D$44<>\"\",0),0),0),0))","v":0},1352784,{"$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":162000},162000,1,{"$f":"IF(G34=\"\",\"\",ROUND(OFFSET(I34,MATCH(TRUE,INDEX(I35:I$44<>\"\",0),0),0),0))","v":181000},1879515,{"$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":558008},558008,1,{"$f":"IF(L34=\"\",\"\",ROUND(OFFSET(N34,MATCH(TRUE,INDEX(N35:N$44<>\"\",0),0),0),0))","v":0},199363,{"$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}]
[28,521241,{"$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":0},0,1,{"$f":"IF(B35=\"\",\"\",ROUND(OFFSET(D35,MATCH(TRUE,INDEX(D36:D$44<>\"\",0),0),0),0))","v":151844},1352965,{"$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":181000},181000,1,{"$f":"IF(G35=\"\",\"\",ROUND(OFFSET(I35,MATCH(TRUE,INDEX(I36:I$44<>\"\",0),0),0),0))","v":160000},1879515,{"$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":0},0,1,{"$f":"IF(L35=\"\",\"\",ROUND(OFFSET(N35,MATCH(TRUE,INDEX(N36:N$44<>\"\",0),0),0),0))","v":546788},199363,{"$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":38000}]
[29,521444,{"$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":151844},151844,{"$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":66572},1353125,{"$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":160000},160000,{"$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":92000},1880246,{"$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":546788},546788,{"$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":236368},199401,{"$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":38000},38000,{"$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":0}]
[30,521533,{"$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":66572},66572,{"$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":74052},1353217,{"$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":92000},92000,{"$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":181000},1880562,{"$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":236368},236368,{"$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":269280},199401,{"$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":0},0,{"$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}]
[31,521632,{"$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":74052},74052,{"$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":150348},1353398,{"$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":181000},181000,{"$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":120000},1880922,{"$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":269280},269280,{"$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":538560},199401,{"$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":0}]
["TOTAL:",null,null,null,null,{"$f":"IF(COUNTBLANK(F$8:F$38)=31,\"\",SUM(F$8:F$38))","v":3235100},null,null,null,null,{"$f":"IF(COUNTBLANK(K$8:K$38)=31,\"\",SUM(K$8:K$38))","v":5238000},null,null,null,null,{"$f":"IF(COUNTBLANK(P$8:P$38)=31,\"\",SUM(P$8:P$38))","v":10238624},null,null,null,null,{"$f":"IF(COUNTBLANK(U$8:U$38)=31,\"\",SUM(U$8:U$38))","v":137000},"Gallons"]
[null,null,null,null,null,{"$f":"IF(F$39=\"\",\"\",F$39/325853)","v":9.9280964115720884},null,null,null,null,{"$f":"IF(K$39=\"\",\"\",K$39/325853)","v":16.074733085164169},null,null,null,null,{"$f":"IF(P$39=\"\",\"\",P$39/325853)","v":31.420990446612429},null,null,null,null,{"$f":"IF(U$39=\"\",\"\",U$39/325853)","v":0.42043498141800134},"Acre-Ft."]
[null,521833,{"$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":150348},{"$f":"IF(OR(B41=\"HOL\",B41=\"SUN\",B41=\"SAT\",B41=\"No Read\",B41=\"\"),\"\",ROUND(C41/E38,1))","v":150348},{"$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":""},1353518,{"$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":120000},{"$f":"IF(OR(G41=\"HOL\",G41=\"SUN\",G41=\"SAT\",G41=\"No Read\",G41=\"\"),\"\",ROUND(H41/J38,1))","v":120000},{"$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":""},1881642,{"$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":538560},{"$f":"IF(OR(L41=\"HOL\",L41=\"SUN\",L41=\"SAT\",L41=\"No Read\",L41=\"\"),\"\",ROUND(M41/O38,1))","v":538560},{"$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":""},199401,{"$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":0},{"$f":"IF(OR(Q41=\"HOL\",Q41=\"SUN\",Q41=\"SAT\",Q41=\"No Read\",Q41=\"\"),\"\",ROUND(R41/T38,1))","v":0},{"$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":""}]