{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","NOW function","Keyboard","VBA-Automatically","Defined Function","Button","Combined Functions","Converting Time","Converting Date- output"],"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":"Dataset","index":0,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,7,1],[8,1,11,1],[12,1,15,1]]}
[]
[null,"Inserting Timestamp"]
[]
[null,"Region","Item","Units","Order Date"]
[null,"Central","Pencil",83]
[null,null,"Pencil Case","-"]
[null,null,"Compass","-"]
[null,null,"Notebook","-"]
[null,"East","Pencil","-"]
[null,null,"Pencil Case","-"]
[null,null,"Compass",45]
[null,null,"Notebook","-"]
[null,"West","Pencil","-"]
[null,null,"Pencil Case",100]
[null,null,"Compass","-"]
[null,null,"Notebook","-"]

{"sheet":"NOW function","index":1,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,7,1],[8,1,11,1],[12,1,15,1]]}
[]
[null,"Using NOW Function to Insert Timestamp"]
[]
[null,"Region","Item","Units","Order Date"]
[null,"Central","Pencil",83,{"$f":"NOW()","v":"2023-08-01T23:39:31.810"}]
[null,null,"Pencil Case","-"]
[null,null,"Compass","-"]
[null,null,"Notebook","-"]
[null,"East","Pencil","-"]
[null,null,"Pencil Case","-"]
[null,null,"Compass",45]
[null,null,"Notebook","-"]
[null,"West","Pencil","-"]
[null,null,"Pencil Case",100]
[null,null,"Compass","-"]
[null,null,"Notebook","-"]

{"sheet":"Keyboard","index":2,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,7,1],[8,1,11,1],[12,1,15,1]]}
[]
[null,"Applying Keyboard Shortcut for Including Timestamp"]
[]
[null,"Region","Item","Units","Order Date"]
[null,"Central","Pencil",83,"2023-08-01T11:41:00"]
[null,null,"Pencil Case","-","2023-08-01T12:05:00"]
[null,null,"Compass","-"]
[null,null,"Notebook","-"]
[null,"East","Pencil","-"]
[null,null,"Pencil Case","-"]
[null,null,"Compass",45]
[null,null,"Notebook","-"]
[null,"West","Pencil","-"]
[null,null,"Pencil Case",100]
[null,null,"Compass","-"]
[null,null,"Notebook","-"]

{"sheet":"VBA-Automatically","index":3,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,7,1],[8,1,11,1],[12,1,15,1]]}
[]
[null,"Applying VBA to Insert Timestamp"]
[]
[null,"Region","Item","Units","Order Date"]
[null,"Central","Pencil",83,"2023-08-01T11:41:00"]
[null,null,"Pencil Case","-","2023-01-08T12:05:31"]
[null,null,"Compass","-","2023-01-08T12:08:28"]
[null,null,"Notebook","-"]
[null,"East","Pencil","-"]
[null,null,"Pencil Case","-"]
[null,null,"Compass",45]
[null,null,"Notebook","-"]
[null,"West","Pencil","-"]
[null,null,"Pencil Case",100]
[null,null,"Compass","-"]
[null,null,"Notebook","-"]

{"sheet":"Defined Function","index":4,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,7,1],[8,1,11,1],[12,1,15,1]]}
[]
[null,"Using a Defined Function to Place Timestamp"]
[]
[null,"Region","Item","Units","Order Date"]
[null,"Central","Pencil",83,{"$f":"insert_Time_Stamp(D5)","v":"01-08-23213 23:39:29"}]
[null,null,"Pencil Case"]
[null,null,"Compass"]
[null,null,"Notebook"]
[null,"East","Pencil"]
[null,null,"Pencil Case"]
[null,null,"Compass"]
[null,null,"Notebook"]
[null,"West","Pencil"]
[null,null,"Pencil Case"]
[null,null,"Compass"]
[null,null,"Notebook"]

{"sheet":"Button","index":5,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,7,1],[8,1,11,1],[12,1,15,1]]}
[]
[null,"Applying VBA with Button to Put Timestamp in Excel"]
[]
[null,"Region","Item","Units","Order Date"]
[null,"Central","Pencil",83,"2023-08-01T14:39:06"]
[null,null,"Pencil Case","-","2023-08-01T14:39:31"]
[null,null,"Compass","-"]
[null,null,"Notebook","-"]
[null,"East","Pencil","-"]
[null,null,"Pencil Case","-"]
[null,null,"Compass",45]
[null,null,"Notebook","-"]
[null,"West","Pencil","-"]
[null,null,"Pencil Case",100]
[null,null,"Compass","-"]
[null,null,"Notebook","-"]

{"sheet":"Combined Functions","index":6,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,7,1],[8,1,11,1],[12,1,15,1]]}
[]
[null,"Combining IF & NOW Functions"]
[]
[null,"Region","Item","Units","Order Date"]
[null,"Central","Pencil",83,{"$f":"IF(D5<>\"\",IF(E5<>\"\",E5,NOW()),\"\")","v":"2023-08-01T15:09:53.470"}]
[null,null,"Pencil Case","-"]
[null,null,"Compass","-"]
[null,null,"Notebook","-"]
[null,"East","Pencil","-"]
[null,null,"Pencil Case","-"]
[null,null,"Compass",45]
[null,null,"Notebook","-"]
[null,"West","Pencil","-"]
[null,null,"Pencil Case",100]
[null,null,"Compass","-"]
[null,null,"Notebook","-"]

{"sheet":"Converting Time","index":7,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[4,1,7,1],[8,1,11,1],[12,1,15,1]]}
[]
[null,"Getting Current Time"]
[]
[null,"Region","Item","Units","Order Date","Time"]
[null,"Central","Pencil",83,"2023-08-01","15:19:00"]
[null,null,"Pencil Case","-"]
[null,null,"Compass","-"]
[null,null,"Notebook","-"]
[null,"East","Pencil","-"]
[null,null,"Pencil Case","-"]
[null,null,"Compass",45]
[null,null,"Notebook","-"]
[null,"West","Pencil","-"]
[null,null,"Pencil Case",100]
[null,null,"Compass","-"]
[null,null,"Notebook","-"]

{"sheet":"Converting Date- output","index":8,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,7,1],[8,1,11,1],[12,1,15,1]]}
[]
[null,"Converting Timestamp to Date"]
[]
[null,"Region","Item","Units","Order Date"]
[null,"Central","Pencil",83,"2023-08-01T11:41:00"]
[null,null,"Pencil Case","-","2023-08-01T12:05:00"]
[null,null,"Compass","-"]
[null,null,"Notebook","-"]
[null,"East","Pencil","-"]
[null,null,"Pencil Case","-"]
[null,null,"Compass",45]
[null,null,"Notebook","-"]
[null,"West","Pencil","-"]
[null,null,"Pencil Case",100]
[null,null,"Compass","-"]
[null,null,"Notebook","-"]