{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Clear Feature","Keyboard Shortcut","Unhide Rows","Filter Tool","Excel VBA","Dataset"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":10,"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":"Clear Feature","index":0,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,2,14,4],[1,1,1,7],[7,2,7,4],[7,5,7,7],[10,2,10,4],[10,5,10,7],[3,2,3,4],[3,5,3,7],[4,2,4,4],[4,5,4,7]]}
[]
[null,"Applying Clear Feature"]
[]
[null,"Filter","2022-12-26",null,null,{"$f":"C4+1","v":"2022-12-27"}]
[null,"Shift","Day Shift",null,null,"Afternoon Shift"]
[null,"Category","Start","End","Hours","Start","End","Hours"]
[null,"Scheduled",{"$f":"VLOOKUP(C5,[1]Dataset!$B$13:$E$16,2,0)","v":"09:00:00"},{"$f":"VLOOKUP(C5,[1]Dataset!$B$13:$E$16,3,0)","v":"16:30:00"},{"$f":"VLOOKUP(C5,[1]Dataset!$B$13:$E$16,4,0)","v":7.5},{"$f":"VLOOKUP(F5,[1]Dataset!$B$13:$E$16,2,0)","v":"17:00:00"},{"$f":"VLOOKUP(F5,[1]Dataset!$B$13:$E$16,3,0)","v":"23:30:00"},{"$f":"VLOOKUP(F5,[1]Dataset!$B$13:$E$16,4,0)","v":6.5}]
[null,"Shift","Afternoon Shift",null,null,"Night Shift"]
[null,"Category","Start","End","Hours","Start","End","Hours"]
[null,"Scheduled",{"$f":"VLOOKUP(C8,[1]Dataset!$B$13:$E$16,2,0)","v":"17:00:00"},{"$f":"VLOOKUP(C8,[1]Dataset!$B$13:$E$16,3,0)","v":"23:30:00"},{"$f":"VLOOKUP(C8,[1]Dataset!$B$13:$E$16,4,0)","v":6.5},{"$f":"VLOOKUP(F8,[1]Dataset!$B$13:$E$16,2,0)","v":"00:00:00"},{"$f":"VLOOKUP(F8,[1]Dataset!$B$13:$E$16,3,0)","v":"05:30:00"},{"$f":"VLOOKUP(F8,[1]Dataset!$B$13:$E$16,4,0)","v":5.5}]
[null,"Shift","Night Shift",null,null,"Day Shift"]
[null,"Category","Start","End","Hours","Start","End","Hours"]
[null,"Scheduled",{"$f":"VLOOKUP(C11,[1]Dataset!$B$13:$E$16,2,0)","v":"00:00:00"},{"$f":"VLOOKUP(C11,[1]Dataset!$B$13:$E$16,3,0)","v":"05:30:00"},{"$f":"VLOOKUP(C11,[1]Dataset!$B$13:$E$16,4,0)","v":5.5},{"$f":"VLOOKUP(F11,[1]Dataset!$B$13:$E$16,2,0)","v":"09:00:00"},{"$f":"VLOOKUP(F11,[1]Dataset!$B$13:$E$16,3,0)","v":"16:30:00"},{"$f":"VLOOKUP(F11,[1]Dataset!$B$13:$E$16,4,0)","v":7.5}]
[]
[null,"Shift","Night Shift"]

{"sheet":"Keyboard Shortcut","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,2,14,4],[1,1,1,7],[3,2,3,4],[3,5,3,7],[4,2,4,4],[10,5,10,7],[4,5,4,7],[7,2,7,4],[7,5,7,7],[10,2,10,4]]}
[]
[null,"Using Keyboard Shortcut"]
[]
[null,"Filter","2022-12-26",null,null,{"$f":"C4+1","v":"2022-12-27"}]
[null,"Shift","Day Shift",null,null,"Afternoon Shift"]
[null,"Category","Start","End","Hours","Start","End","Hours"]
[null,"Scheduled",{"$f":"VLOOKUP(C5,[1]Dataset!$B$13:$E$16,2,0)","v":"09:00:00"},{"$f":"VLOOKUP(C5,[1]Dataset!$B$13:$E$16,3,0)","v":"16:30:00"},{"$f":"VLOOKUP(C5,[1]Dataset!$B$13:$E$16,4,0)","v":7.5},{"$f":"VLOOKUP(F5,[1]Dataset!$B$13:$E$16,2,0)","v":"17:00:00"},{"$f":"VLOOKUP(F5,[1]Dataset!$B$13:$E$16,3,0)","v":"23:30:00"},{"$f":"VLOOKUP(F5,[1]Dataset!$B$13:$E$16,4,0)","v":6.5}]
[null,"Shift","Afternoon Shift",null,null,"Night Shift"]
[null,"Category","Start","End","Hours","Start","End","Hours"]
[null,"Scheduled",{"$f":"VLOOKUP(C8,[1]Dataset!$B$13:$E$16,2,0)","v":"17:00:00"},{"$f":"VLOOKUP(C8,[1]Dataset!$B$13:$E$16,3,0)","v":"23:30:00"},{"$f":"VLOOKUP(C8,[1]Dataset!$B$13:$E$16,4,0)","v":6.5},{"$f":"VLOOKUP(F8,[1]Dataset!$B$13:$E$16,2,0)","v":"00:00:00"},{"$f":"VLOOKUP(F8,[1]Dataset!$B$13:$E$16,3,0)","v":"05:30:00"},{"$f":"VLOOKUP(F8,[1]Dataset!$B$13:$E$16,4,0)","v":5.5}]
[null,"Shift","Night Shift",null,null,"Day Shift"]
[null,"Category","Start","End","Hours","Start","End","Hours"]
[null,"Scheduled",{"$f":"VLOOKUP(C11,[1]Dataset!$B$13:$E$16,2,0)","v":"00:00:00"},{"$f":"VLOOKUP(C11,[1]Dataset!$B$13:$E$16,3,0)","v":"05:30:00"},{"$f":"VLOOKUP(C11,[1]Dataset!$B$13:$E$16,4,0)","v":5.5},{"$f":"VLOOKUP(F11,[1]Dataset!$B$13:$E$16,2,0)","v":"09:00:00"},{"$f":"VLOOKUP(F11,[1]Dataset!$B$13:$E$16,3,0)","v":"16:30:00"},{"$f":"VLOOKUP(F11,[1]Dataset!$B$13:$E$16,4,0)","v":7.5}]
[]
[null,"Shift","Night Shift"]

{"sheet":"Unhide Rows","index":2,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,2,3,4],[3,5,3,7],[4,2,4,4],[4,5,4,7],[14,2,14,4],[7,2,7,4],[7,5,7,7],[10,2,10,4],[10,5,10,7]]}
[]
[null,"Use of Unhide Feature"]
[]
[null,"Filter","2022-12-26",null,null,{"$f":"C4+1","v":"2022-12-27"}]
[null,"Shift","Day Shift",null,null,"Afternoon Shift"]
[null,"Category","Start","End","Hours","Start","End","Hours"]
[null,"Scheduled",{"$f":"VLOOKUP(C5,[1]Dataset!$B$13:$E$16,2,0)","v":"09:00:00"},{"$f":"VLOOKUP(C5,[1]Dataset!$B$13:$E$16,3,0)","v":"16:30:00"},{"$f":"VLOOKUP(C5,[1]Dataset!$B$13:$E$16,4,0)","v":7.5},{"$f":"VLOOKUP(F5,[1]Dataset!$B$13:$E$16,2,0)","v":"17:00:00"},{"$f":"VLOOKUP(F5,[1]Dataset!$B$13:$E$16,3,0)","v":"23:30:00"},{"$f":"VLOOKUP(F5,[1]Dataset!$B$13:$E$16,4,0)","v":6.5}]
[null,"Shift","Afternoon Shift",null,null,"Night Shift"]
[null,"Category","Start","End","Hours","Start","End","Hours"]
[null,"Scheduled",{"$f":"VLOOKUP(C8,[1]Dataset!$B$13:$E$16,2,0)","v":"17:00:00"},{"$f":"VLOOKUP(C8,[1]Dataset!$B$13:$E$16,3,0)","v":"23:30:00"},{"$f":"VLOOKUP(C8,[1]Dataset!$B$13:$E$16,4,0)","v":6.5},{"$f":"VLOOKUP(F8,[1]Dataset!$B$13:$E$16,2,0)","v":"00:00:00"},{"$f":"VLOOKUP(F8,[1]Dataset!$B$13:$E$16,3,0)","v":"05:30:00"},{"$f":"VLOOKUP(F8,[1]Dataset!$B$13:$E$16,4,0)","v":5.5}]
[null,"Shift","Night Shift",null,null,"Day Shift"]
[null,"Category","Start","End","Hours","Start","End","Hours"]
[null,"Scheduled",{"$f":"VLOOKUP(C11,[1]Dataset!$B$13:$E$16,2,0)","v":"00:00:00"},{"$f":"VLOOKUP(C11,[1]Dataset!$B$13:$E$16,3,0)","v":"05:30:00"},{"$f":"VLOOKUP(C11,[1]Dataset!$B$13:$E$16,4,0)","v":5.5},{"$f":"VLOOKUP(F11,[1]Dataset!$B$13:$E$16,2,0)","v":"09:00:00"},{"$f":"VLOOKUP(F11,[1]Dataset!$B$13:$E$16,3,0)","v":"16:30:00"},{"$f":"VLOOKUP(F11,[1]Dataset!$B$13:$E$16,4,0)","v":7.5}]
[]
[null,"Shift","Night Shift"]

{"sheet":"Filter Tool","index":3,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,2,3,4],[3,5,3,7],[4,2,4,4],[4,5,4,7],[14,2,14,4],[7,2,7,4],[7,5,7,7],[10,2,10,4],[10,5,10,7]]}
[]
[null,"Using Filter Tool"]
[]
[null,"Filter","2022-12-26",null,null,{"$f":"C4+1","v":"2022-12-27"}]
[null,"Shift","Day Shift",null,null,"Afternoon Shift"]
[null,"Category","Start","End","Hours","Start","End","Hours"]
[null,"Scheduled",{"$f":"VLOOKUP(C5,[1]Dataset!$B$13:$E$16,2,0)","v":"09:00:00"},{"$f":"VLOOKUP(C5,[1]Dataset!$B$13:$E$16,3,0)","v":"16:30:00"},{"$f":"VLOOKUP(C5,[1]Dataset!$B$13:$E$16,4,0)","v":7.5},{"$f":"VLOOKUP(F5,[1]Dataset!$B$13:$E$16,2,0)","v":"17:00:00"},{"$f":"VLOOKUP(F5,[1]Dataset!$B$13:$E$16,3,0)","v":"23:30:00"},{"$f":"VLOOKUP(F5,[1]Dataset!$B$13:$E$16,4,0)","v":6.5}]
[null,"Shift","Afternoon Shift",null,null,"Night Shift"]
[null,"Category","Start","End","Hours","Start","End","Hours"]
[null,"Scheduled",{"$f":"VLOOKUP(C8,[1]Dataset!$B$13:$E$16,2,0)","v":"17:00:00"},{"$f":"VLOOKUP(C8,[1]Dataset!$B$13:$E$16,3,0)","v":"23:30:00"},{"$f":"VLOOKUP(C8,[1]Dataset!$B$13:$E$16,4,0)","v":6.5},{"$f":"VLOOKUP(F8,[1]Dataset!$B$13:$E$16,2,0)","v":"00:00:00"},{"$f":"VLOOKUP(F8,[1]Dataset!$B$13:$E$16,3,0)","v":"05:30:00"},{"$f":"VLOOKUP(F8,[1]Dataset!$B$13:$E$16,4,0)","v":5.5}]
[null,"Shift","Night Shift",null,null,"Day Shift"]
[null,"Category","Start","End","Hours","Start","End","Hours"]
[null,"Scheduled",{"$f":"VLOOKUP(C11,[1]Dataset!$B$13:$E$16,2,0)","v":"00:00:00"},{"$f":"VLOOKUP(C11,[1]Dataset!$B$13:$E$16,3,0)","v":"05:30:00"},{"$f":"VLOOKUP(C11,[1]Dataset!$B$13:$E$16,4,0)","v":5.5},{"$f":"VLOOKUP(F11,[1]Dataset!$B$13:$E$16,2,0)","v":"09:00:00"},{"$f":"VLOOKUP(F11,[1]Dataset!$B$13:$E$16,3,0)","v":"16:30:00"},{"$f":"VLOOKUP(F11,[1]Dataset!$B$13:$E$16,4,0)","v":7.5}]
[]
[null,"Shift","Night Shift"]

{"sheet":"Excel VBA","index":4,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,2,3,4],[3,5,3,7],[4,2,4,4],[4,5,4,7],[14,2,14,4],[7,2,7,4],[7,5,7,7],[10,2,10,4],[10,5,10,7]]}
[]
[null,"Running VBA Code"]
[]
[null,"Filter","2022-12-26",null,null,{"$f":"C4+1","v":"2022-12-27"}]
[null,"Shift","Day Shift",null,null,"Afternoon Shift"]
[null,"Category","Start","End","Hours","Start","End","Hours"]
[null,"Scheduled",{"$f":"VLOOKUP(C5,[1]Dataset!$B$13:$E$16,2,0)","v":"09:00:00"},{"$f":"VLOOKUP(C5,[1]Dataset!$B$13:$E$16,3,0)","v":"16:30:00"},{"$f":"VLOOKUP(C5,[1]Dataset!$B$13:$E$16,4,0)","v":7.5},{"$f":"VLOOKUP(F5,[1]Dataset!$B$13:$E$16,2,0)","v":"17:00:00"},{"$f":"VLOOKUP(F5,[1]Dataset!$B$13:$E$16,3,0)","v":"23:30:00"},{"$f":"VLOOKUP(F5,[1]Dataset!$B$13:$E$16,4,0)","v":6.5}]
[null,"Shift","Afternoon Shift",null,null,"Night Shift"]
[null,"Category","Start","End","Hours","Start","End","Hours"]
[null,"Scheduled",{"$f":"VLOOKUP(C8,[1]Dataset!$B$13:$E$16,2,0)","v":"17:00:00"},{"$f":"VLOOKUP(C8,[1]Dataset!$B$13:$E$16,3,0)","v":"23:30:00"},{"$f":"VLOOKUP(C8,[1]Dataset!$B$13:$E$16,4,0)","v":6.5},{"$f":"VLOOKUP(F8,[1]Dataset!$B$13:$E$16,2,0)","v":"00:00:00"},{"$f":"VLOOKUP(F8,[1]Dataset!$B$13:$E$16,3,0)","v":"05:30:00"},{"$f":"VLOOKUP(F8,[1]Dataset!$B$13:$E$16,4,0)","v":5.5}]
[null,"Shift","Night Shift",null,null,"Day Shift"]
[null,"Category","Start","End","Hours","Start","End","Hours"]
[null,"Scheduled",{"$f":"VLOOKUP(C11,[1]Dataset!$B$13:$E$16,2,0)","v":"00:00:00"},{"$f":"VLOOKUP(C11,[1]Dataset!$B$13:$E$16,3,0)","v":"05:30:00"},{"$f":"VLOOKUP(C11,[1]Dataset!$B$13:$E$16,4,0)","v":5.5},{"$f":"VLOOKUP(F11,[1]Dataset!$B$13:$E$16,2,0)","v":"09:00:00"},{"$f":"VLOOKUP(F11,[1]Dataset!$B$13:$E$16,3,0)","v":"16:30:00"},{"$f":"VLOOKUP(F11,[1]Dataset!$B$13:$E$16,4,0)","v":7.5}]
[]
[null,"Shift","Night Shift"]

{"sheet":"Dataset","index":5,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[10,2,10,4],[10,5,10,7],[1,1,1,7],[3,2,3,4],[3,5,3,7],[4,2,4,4],[4,5,4,7],[7,2,7,4],[7,5,7,7]]}
[]
[null,"Overview of Dataset"]
[]
[null,"Filter","2022-12-26",null,null,{"$f":"C4+1","v":"2022-12-27"}]
[null,"Shift","Day Shift",null,null,"Afternoon Shift"]
[null,"Category","Start","End","Hours","Start","End","Hours"]
[null,"Scheduled",{"$f":"VLOOKUP(C5,[1]Dataset!$B$13:$E$16,2,0)","v":"09:00:00"},{"$f":"VLOOKUP(C5,[1]Dataset!$B$13:$E$16,3,0)","v":"16:30:00"},{"$f":"VLOOKUP(C5,[1]Dataset!$B$13:$E$16,4,0)","v":7.5},{"$f":"VLOOKUP(F5,[1]Dataset!$B$13:$E$16,2,0)","v":"17:00:00"},{"$f":"VLOOKUP(F5,[1]Dataset!$B$13:$E$16,3,0)","v":"23:30:00"},{"$f":"VLOOKUP(F5,[1]Dataset!$B$13:$E$16,4,0)","v":6.5}]
[null,"Shift","Afternoon Shift",null,null,"Night Shift"]
[null,"Category","Start","End","Hours","Start","End","Hours"]
[null,"Scheduled",{"$f":"VLOOKUP(C8,[1]Dataset!$B$13:$E$16,2,0)","v":"17:00:00"},{"$f":"VLOOKUP(C8,[1]Dataset!$B$13:$E$16,3,0)","v":"23:30:00"},{"$f":"VLOOKUP(C8,[1]Dataset!$B$13:$E$16,4,0)","v":6.5},{"$f":"VLOOKUP(F8,[1]Dataset!$B$13:$E$16,2,0)","v":"00:00:00"},{"$f":"VLOOKUP(F8,[1]Dataset!$B$13:$E$16,3,0)","v":"05:30:00"},{"$f":"VLOOKUP(F8,[1]Dataset!$B$13:$E$16,4,0)","v":5.5}]
[null,"Shift","Night Shift",null,null,"Day Shift"]
[null,"Category","Start","End","Hours","Start","End","Hours"]
[null,"Scheduled",{"$f":"VLOOKUP(C11,[1]Dataset!$B$13:$E$16,2,0)","v":"00:00:00"},{"$f":"VLOOKUP(C11,[1]Dataset!$B$13:$E$16,3,0)","v":"05:30:00"},{"$f":"VLOOKUP(C11,[1]Dataset!$B$13:$E$16,4,0)","v":5.5},{"$f":"VLOOKUP(F11,[1]Dataset!$B$13:$E$16,2,0)","v":"09:00:00"},{"$f":"VLOOKUP(F11,[1]Dataset!$B$13:$E$16,3,0)","v":"16:30:00"},{"$f":"VLOOKUP(F11,[1]Dataset!$B$13:$E$16,4,0)","v":7.5}]