{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Nested IF","IFS Function","IF with AND function","VBA","VLOOKUP Function","XLOOKUP Function"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Nested IF","index":0,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Using Nested IF Functions"]
[]
[null,"Task","Submission Time","Remarks",null,"Start","End","Status"]
[null,1,"10:00:00",{"$f":"IF(C5>$F$5,IF(C5<$G$5,$H$5),$H$6)","v":"On time"},null,"06:00:00","17:59:00","On time"]
[null,2,"02:00:00",{"$f":"IF(C6>$F$5,IF(C6<$G$5,$H$5),$H$6)","v":"Late"},null,"18:00:00","05:59:00","Late"]
[null,3,"00:30:00","Late"]
[null,4,"13:00:00","On time"]
[null,5,"01:10:00","Late"]
[null,6,"15:00:00","On time"]
[null,7,"16:00:00","On time"]
[null,8,"17:00:00","On time"]

{"sheet":"IFS Function","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Combination of IFS and IFERROR Functions"]
[]
[null,"Task","Submission Time","Remarks",null,"Start","End","Status"]
[null,1,"10:00:00",{"$f":"IFERROR(_xlfn.IFS(C5>=$F$5,IF(C5<=$G$5,$H$5),C5>=$F$6,IF(C5<=$G$6,$H$6)),$H$6)","v":"On time"},null,"06:00:00","17:59:00","On time"]
[null,2,"02:00:00",{"$f":"IFERROR(_xlfn.IFS(C6>=$F$5,IF(C6<=$G$5,$H$5),C6>=$F$6,IF(C6<=$G$6,$H$6)),$H$6)","v":"Late"},null,"18:00:00","05:59:00","Late"]
[null,3,"00:30:00",{"$f":"IFERROR(_xlfn.IFS(C7>=$F$5,IF(C7<=$G$5,$H$5),C7>=$F$6,IF(C7<=$G$6,$H$6)),$H$6)","v":"Late"}]
[null,4,"13:00:00",{"$f":"IFERROR(_xlfn.IFS(C8>=$F$5,IF(C8<=$G$5,$H$5),C8>=$F$6,IF(C8<=$G$6,$H$6)),$H$6)","v":"On time"}]
[null,5,"01:10:00",{"$f":"IFERROR(_xlfn.IFS(C9>=$F$5,IF(C9<=$G$5,$H$5),C9>=$F$6,IF(C9<=$G$6,$H$6)),$H$6)","v":"Late"}]
[null,6,"15:00:00",{"$f":"IFERROR(_xlfn.IFS(C10>=$F$5,IF(C10<=$G$5,$H$5),C10>=$F$6,IF(C10<=$G$6,$H$6)),$H$6)","v":"On time"}]
[null,7,"16:00:00",{"$f":"IFERROR(_xlfn.IFS(C11>=$F$5,IF(C11<=$G$5,$H$5),C11>=$F$6,IF(C11<=$G$6,$H$6)),$H$6)","v":"On time"}]
[null,8,"17:00:00",{"$f":"IFERROR(_xlfn.IFS(C12>=$F$5,IF(C12<=$G$5,$H$5),C12>=$F$6,IF(C12<=$G$6,$H$6)),$H$6)","v":"On time"}]

{"sheet":"IF with AND function","index":2,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Combining IF with AND Function"]
[]
[null,"Entry Time","Arrival",null,"Late","00:00:00"]
[null,"08:59:25",{"$f":"IF(AND(B5>=$F$4,B5<=$F$5),$E$5,$E$4)","v":"On time"},null,"On time","09:00:00"]
[null,"09:08:02",{"$f":"IF(AND(B6>=$F$4,B6<=$F$5),$E$5,$E$4)","v":"Late"}]
[null,"08:58:07","On time"]
[null,"09:05:36","Late"]
[null,"08:59:51","On time"]
[null,"09:29:02","Late"]
[null,"08:48:39","On time"]
[null,"09:05:02","Late"]
[null,"08:45:36","On time"]
[null,"09:25:04","Late"]
[null,"09:29:39","Late"]
[null,"08:57:42","On time"]
[null,"09:25:19","Late"]

{"sheet":"VBA","index":3,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Embedding VBA Code"]
[]
[null,"Task","Submission Time","Remarks",null,"Start","End","Status"]
[null,1,"10:00:00","On time",null,"06:00:00","17:59:00","On time"]
[null,2,"02:00:00","Late",null,"18:00:00","05:59:00","Late"]
[null,3,"00:30:00","Late"]
[null,4,"13:00:00","On time"]
[null,5,"01:10:00","Late"]
[null,6,"15:00:00","On time"]
[null,7,"16:00:00","On time"]
[null,8,"17:00:00","On time"]

{"sheet":"VLOOKUP Function","index":4,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Utilizing VLOOKUP Function"]
[]
[null,"Entry Time","Arrival",null,"00:00:00","On time"]
[null,"08:59:25",{"$f":"VLOOKUP(B5,$E$4:$F$6,2,TRUE)","v":"On time"},null,"09:00:00","Acceptably late"]
[null,"09:08:02",{"$f":"VLOOKUP(B6,$E$4:$F$6,2,TRUE)","v":"Acceptably late"},null,"17:00:00","Late"]
[null,"08:58:07","On time"]
[null,"19:05:36","Late"]
[null,"08:59:51","On time"]
[null,"21:29:02","Late"]
[null,"08:48:39","On time"]
[null,"09:05:02","Acceptably late"]
[null,"08:45:36","On time"]
[null,"18:25:04","Late"]
[null,"12:29:39","Acceptably late"]
[null,"08:57:42","On time"]
[null,"09:25:19","Acceptably late"]

{"sheet":"XLOOKUP Function","index":5,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using XLOOKUP Function"]
[]
[null,"Entry Time","Arrival",null,"00:00:00","On time"]
[null,"08:59:25",{"$f":"_xlfn.XLOOKUP(B5,$E$4:$E$6,$F$4:$F$6,,-1)","v":"On time"},null,"09:00:00","Acceptably late"]
[null,"09:08:02",{"$f":"_xlfn.XLOOKUP(B6,$E$4:$E$6,$F$4:$F$6,,-1)","v":"Acceptably late"},null,"17:00:00","Late"]
[null,"08:58:07","On time"]
[null,"19:05:36","Late"]
[null,"08:59:51","On time"]
[null,"21:29:02","Late"]
[null,"08:48:39","On time"]
[null,"09:05:02","Acceptably late"]
[null,"08:45:36","On time"]
[null,"18:25:04","Late"]
[null,"12:29:39","Acceptably late"]
[null,"08:57:42","On time"]
[null,"09:25:19","Acceptably late"]