{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Hrs","Template","Data","Data 2","CF","CF2fix"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":38,"comments":4,"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":"Hrs","index":0,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,2,0,5]]}
[null,null,{"$f":"TODAY()","v":"2020-11-07"},null,null,null,null,null,null,null,{"$f":"SUM(I:I)","v":1.6666666666666665}]
[{"$f":"F2+7","v":"2020-11-12"},"Date:",{"$f":"F2-3","v":"2020-11-02"},{"$f":"F2-2","v":"2020-11-03"},{"$f":"F2-1","v":"2020-11-04"},"2020-11-05",{"$f":"F2+1","v":"2020-11-06"},{"$f":"F2+2","v":"2020-11-07"}]
[{"$f":"F2-3","v":"2020-11-02"},null,"Mon","Tue","Wed","Thu","Fri","Sat"]
[{"$f":"CHOOSE(MONTH(C2),\"Jan\",\"Feb\",\"Mar\",\"Apr\",\"May\",\"June\",\"July\",\"Aug\",\"Sept\",\"Oct\",\"Nov\",\"Dec\")","v":"Nov"},"In","07:45:00","07:45:00","07:45:00","07:45:00","07:45:00"]
[null,"Out","11:45:00","11:45:00","11:45:00","11:45:00","11:45:00"]
[null,"Sub total",{"$f":"C5-C4","v":"04:00:00"},{"$f":"D5-D4","v":"04:00:00"},"04:00:00","04:00:00","04:00:00","00:00:00"]
[null,"In ","12:15:00","12:15:00","12:15:00","12:15:00","12:15:00"]
[null,"Out","16:00:00","16:00:00","16:00:00","16:30:00","16:45:00"]
[null,"Sub total",{"$f":"C8-C7","v":"03:45:00"},"03:45:00","03:45:00","04:15:00","04:30:00"]
[null,"Daily total",{"$f":"IF(C6+C9=0,0,C6+C9)","v":"07:45:00"},{"$f":"IF(D6+D9=0,0,D6+D9)","v":"07:45:00"},"07:45:00","08:15:00","08:30:00",{"$f":"IF(H6+H9=0,0,H6)","v":"00:00:00"},{"$f":"SUM(C10:H10)","v":1.6666666666666665},{"$f":"C13+(F13/60)","v":40}]
[null,"hours",{"$f":"HOUR(C10)","v":7},7,7,8,8,0]
[null,"minutes",{"$f":"MINUTE(C10)","v":45},45,45,15,30,0]
[null,"hrs:",{"$f":"SUM(C11:H11)","v":37},null,"min:",{"$f":"SUM(C12:H12)","v":180}]

{"sheet":"Template","index":1,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[{"$f":"TODAY()","v":"2020-11-07"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M & J are unassigned in Excel"]
[{"$f":"F2+7","v":"1900-01-07"},"Date:",{"$f":"F2-3","v":-3},{"$f":"F2-2","v":-2},{"$f":"F2-1","v":-1},null,{"$f":"F2+1","v":"1900-01-01"},{"$f":"F2+2","v":"1900-01-02"},null,null,null,"Ctrl m = moves to hrs_19 sheet"]
[{"$f":"F2-3","v":-3},null,"Mon","Tue","Wed","Thu","Fri","Sat"]
[{"$f":"CHOOSE(MONTH(C2),\"Jan\",\"Feb\",\"Mar\",\"Apr\",\"May\",\"June\",\"July\",\"Aug\",\"Sept\",\"Oct\",\"Nov\",\"Dec\")","v":{"$error":"#NUM!"}},"In","07:45:00","07:45:00","07:45:00","07:45:00","07:45:00"]
[null,"Out","11:45:00","11:45:00","11:45:00","11:45:00","11:45:00"]
[null,"Sub total",{"$f":"C5-C4","v":"04:00:00"},{"$f":"D5-D4","v":"04:00:00"},"04:00:00","04:00:00","04:00:00","00:00:00"]
[null,"In ","12:15:00","12:15:00","12:15:00","12:15:00","12:15:00"]
[null,"Out","16:00:00","16:00:00","16:00:00","16:30:00","16:45:00"]
[null,"Sub total",{"$f":"C8-C7","v":"03:45:00"},"03:45:00","03:45:00","04:15:00","04:30:00"]
[null,"Daily total",{"$f":"IF(C6+C9=0,0,C6+C9)","v":"07:45:00"},{"$f":"IF(D6+D9=0,0,D6+D9)","v":"07:45:00"},"07:45:00","08:15:00","08:30:00",{"$f":"IF(H6+H9=0,0,H6)","v":"00:00:00"},{"$f":"SUM(C10:H10)","v":1.6666666666666665},{"$f":"C13+(F13/60)","v":40}]
[null,"hours",{"$f":"HOUR(C10)","v":7},7,7,8,8,0]
[null,"minutes",{"$f":"MINUTE(C10)","v":45},45,45,15,30,0]
[null,"hrs:",{"$f":"SUM(C11:H11)","v":37},null,"min:",{"$f":"SUM(C12:H12)","v":180}]

{"sheet":"Data","index":2,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Data"]
[null,null,22]
[null,null,55]
[null,null,21]
[null,"Sum",{"$f":"SUM(C2:C4)","v":98}]

{"sheet":"Data 2","index":3,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,6,2,6]]}
["Data 2",null,100,90,21,null,"SUM from Data Sheet, ",null,null,null,null,null,null,"=IF(OR(MIN(Data!C2:C4)<20,SUM('Data 2'!C4:E4)>200),IF(AVERAGE('Data 2'!C4:E4)<70,TRUE))"]
[null,null,null,null,null,null,"TRUE if greater than 100"]
["AVG:",{"$f":"AVERAGE(C1:E1)","v":70.333333333333329},null,"MIN:",{"$f":"MIN(C1:E1)","v":21}]
[null,null,null,null,null,null,{"$f":"Data!C5","v":98}]
[null,"TRUE if avg is less than 70",null,null,"TRUE if min is less than 20"]
[null,{"$f":"B3<70","v":false},null,null,{"$f":"E3<20","v":false},null,{"$f":"G4>100","v":false}]
[]
[null,null,null,null,{"$f":"OR(B6=TRUE,E6=TRUE,G6=TRUE)","v":false}]
[null,null,null,"'=OR(B6=TRUE,E6=TRUE,G6=TRUE)"]

{"sheet":"CF","index":4,"n_rows":22,"n_cols":39,"rows_kept":22,"cut":false,"hidden":false,"merged":[[4,19,6,20],[14,12,15,12],[16,12,17,12]]}
["SEARCH","`","`",null,"`",null,"`",null,null,-45,"Values less than or equal to",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"`"]
["XLOOKUP",{"$f":"_xlfn.XLOOKUP(B1,B5:B25,H5:H25)","v":{"$error":"#N/A"}},"first: ","2020-01-01",null,"&/or",null,null,{"$f":"SUM(I5:I24)","v":518},{"$f":"SUM(J5:J24)","v":712},1230,"Sum not filtered","'=VLOOKUP(B1,B5:H22,7,FALSE)"]
[null,null,"last: ","2020-01-01",null,null,null,"SUM",{"$f":"SUBTOTAL(IF($H$3=\"sum\",109,101),I5:I25)","v":518},{"$f":"SUBTOTAL(IF($H$3=\"sum\",109,101),J5:J25)","v":712},1230,"Subtotal  - filtered","=XLOOKUP(B1,B5:B25,H5:H25)"]
[null,"Code","Name","Date","Country","Zip","Address","Price","NE","CAD","Balance"]
[null,"24Q","Miller",{"$f":"TODAY()-300","v":"2020-01-12"},"Ireland",45628,"PO Box 17",2,-27,22,{"$f":"SUM(I5:J5)","v":-5},null,"=IF(SEARCH($B$1,$B5),TRUE)"]
[null,"34Q","Jacobs",{"$f":"TODAY()","v":"2020-11-07"},"USA",20185,"RR 6",55,25,9,34,50,"=AND(L6>1,L6<50)"]
[null,"7YDQ","Bernhart","1968-12-12","UK",82301,"Timber View 22",13,-45,-5,-50,null,"=AND($F5>=$D$2,$F5<=$D$3)"]
[null,"A00","Taylor",{"$f":"TODAY()-4000","v":"2009-11-25"},"USA",87654,"PO Box 33",14,55,14,69,null,"=AND($D5<TODAY()-30,$D5>TODAY()-500)"]
[null,"A7PK","Jacobs","1976-01-06","  USA",17563,"Sierra Ln",93,-33,45,12,null,"=AND($E5=\"USA\",$K5<0)"]
[null,"AR187","Thatcher",{"$f":"TODAY()-1500","v":"2016-09-29"},"UK",65432,"Timber View 32",11,280,56,336,null,"=$J5<0"]
[null,"AR8","Stewart",{"$f":"TODAY()+14","v":"2020-11-21"},"USA",21084,"RR 11",3688,45,5,50,null,"=$J$1>=$J5"]
[null,"AR9","Fermi","1945-04-03","Italy",21089,"822 Ave ",20,120,33,153,null,"=OR($F5=21084,$F5=20185)      '=OR($F5=$F$1,$F5=$F$3)"]
[null,"DQ7","Anders","2005-05-05","USA",20134,"3708 N 23rd",62,33,50,83]
[null,"JJ","Anders","1981-10-09","USA",17352," 14 Mesa Drive",55,45,2,47,null,"=OR($E5=\"USA\",$K5<0)"]
[null,"K2","Nelson",{"$f":"TODAY()+20","v":"2020-11-27"},"USA",21084,"Timber View 5",330,22,5,27,null,"=OR(AND($E5=\"USA\",$K5<0),AND($C5=\"Anders\",$J5<0))"]
[null,"PK1","Anders",{"$f":"TODAY()-570","v":"2019-04-17"},"USA",21136," 21 Mesa Drive",2,-2,-40,-42]
[null,"PK14","Temple",{"$f":"TODAY()-900","v":"2018-05-22"},"Chile",17352," 10 Mesa Drive",12,33,455,488,null,"=IF('Data 2'!$E8=TRUE,TRUE)       Red header if E8 on Data 2 is TRUE"]
[null,"PK15","Juarez","1992-04-04","USA",17352,"14th and Broadway",48,27,55,82]
[null,"PK4","Zane",{"$f":"TODAY()-4400","v":"2008-10-21"},"Fiji",15547,"Spring Ave",26,-50,23,-27]
[null,"TH 90 AR","Stewart",{"$f":"TODAY()-1900","v":"2015-08-26"},"Italy",85001,"15 S. Main",88,-66,3,-63]
[null,"TTA6","Crane","1960-01-01","Poland",21084,"123 View",3,36,-7,29]
[null,"WTT","Vire",{"$f":"TODAY()-1000","v":"2018-02-11"},"Poland",20185,"Timber Point 12",17,20,-13,7]

{"sheet":"CF2fix","index":5,"n_rows":22,"n_cols":39,"rows_kept":22,"cut":false,"hidden":false,"merged":[[4,19,6,20]]}
["SEARCH","",null,null,"usa",null,null,null,null,null,null,null,null,null,"`",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"`"]
["XLOOKUP",null,"first: ","2020-01-01",null,"&/or",null,null,{"$f":"SUM(I5:I24)","v":518},{"$f":"SUM(J5:J24)","v":698},1216,"Sum not filtered","'=SUBTOTAL(IF($H$3=\"sum\",109,101),I5:I25)"]
[null,null,"last: ","2020-01-01",null,null,null,"SUM",null,null,null,"Subtotal  - filtered","=SUBTOTAL(109,I5:I25)"]
[null,"Code","Name","Record","Country","Zip","Address","Price","NE","CAD","Balance",null,"Add Functions to red boxes and add database."]
[null,"TTA6","Crane","1960-01-01","Poland",21084,"123 View",3,36,-7,{"$f":"SUM(I5:J5)","v":29},null,"=IF(SEARCH($B$1,$B5),TRUE)"]
[null,"AR9","Fermi","1945-04-03","Italy",21089,"822 Ave ",20,120,33,153,null,"=AND(L6>1,L6<50)"]
[null,"7YDQ","Bernhart","1968-12-12","UK",82301,"Timber View 22",13,-45,-5,-50,null,"=AND($F5>=$D$2,$F5<=$D$3)"]
[null,"A7PK","Jacobs","1976-01-06","USA",17563,"Sierra Ln",93,-33,45,12,null,"=AND($D5<TODAY()-30,$D5>TODAY()-500)"]
[null,"JJ","Anders","1981-10-09","USA",17352," 14 Mesa Drive",55,45,2,47,null,"=AND($E5=\"USA\",$K5<0)"]
[null,"PK15","Juarez","1992-04-04","USA",17352,"14th and Broadway",48,27,55,82,null,"=$J$1>=$J5"]
[null,"DQ7","Anders","2005-05-05","USA",20134,"3708 N 23rd",62,33,50,83]
[null,"PK4","Zane",{"$f":"TODAY()-4400","v":"2008-10-21"},"Fiji",15547,"Spring Ave",26,-50,23,-27,null,"=OR($F5=21084,$F5=20185)      '=OR($F5=$F$1,$F5=$F$3)"]
[null,"A00","Taylor",{"$f":"TODAY()-4000","v":"2009-11-25"},"USA",87654,"PO Box 33",14,55,null,55,null,"=OR($E5=\"USA\",$K5<0)"]
[null,"TH 90 AR","Stewart",{"$f":"TODAY()-1900","v":"2015-08-26"},"Italy",85001,"15 S. Main",88,-66,3,-63,null,"=OR(AND($E5=\"USA\",$K5<0),AND($C5=\"Anders\",$J5<0))"]
[null,"AR187","Thatcher",{"$f":"TODAY()-1500","v":"2016-09-29"},"UK",65432,"Timber View 32",11,280,56,336]
[null,"WTT","Vire",{"$f":"TODAY()-1000","v":"2018-02-11"},"Poland",20185,"Timber Point 12",17,20,-13,7,null,"=IF('Data 2'!$E8=TRUE,TRUE)       Red header if E8 on Data 2 is TRUE"]
[null,"PK14","Temple",{"$f":"TODAY()-900","v":"2018-05-22"},"Chile",17352," 10 Mesa Drive",12,33,455,488]
[null,"PK1","Anders",{"$f":"TODAY()-570","v":"2019-04-17"},"USA",21136," 21 Mesa Drive",2,-2,-40,-42]
[null,"24Q","Miller",{"$f":"TODAY()-300","v":"2020-01-12"},"Ireland",45628,"PO Box 17",2,-27,22,-5]
[null,"34Q","Jacobs",{"$f":"TODAY()","v":"2020-11-07"},"USA",20185,"RR 6",55,25,9,34]
[null,"AR8","Stewart",{"$f":"TODAY()+14","v":"2020-11-21"},"USA",21084,"RR 11",3688,45,5,50]
[null,"K2","Nelson",{"$f":"TODAY()+20","v":"2020-11-27"},"USA",21084,"Timber View 5",330,22,5,27]