{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Using File Tab","User-Defined Function","VBA Code With Command But","Command Button","Utilizing IF Function","Use of Date Formula"],"not_rendered":{"charts":0,"images":2,"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":10,"n_cols":20,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,18,1,19]]}
[]
[null,"Dataset Overview",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Input","Timestamp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Input","Timestamp"]
[null,1,{"$f":"AutoTimestamp(B5)","v":"08:53:41 AM 08-30-2022"}]
[null,2,{"$f":"AutoTimestamp(B6)","v":"08:53:41 AM 08-30-2022"}]
[null,3,{"$f":"AutoTimestamp(B7)","v":"08:53:41 AM 08-30-2022"}]
[null,4,{"$f":"AutoTimestamp(B8)","v":"08:53:41 AM 08-30-2022"}]
[null,5,{"$f":"AutoTimestamp(B9)","v":"08:53:41 AM 08-30-2022"}]
[null,6,{"$f":"AutoTimestamp(B10)","v":"08:53:41 AM 08-30-2022"}]

{"sheet":"Using File Tab","index":1,"n_rows":10,"n_cols":20,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,18,1,19]]}
[]
[null,"Using File Tab",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Input","Timestamp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Input","Timestamp"]
[null,1,{"$f":"AutoTimestamp(B5)","v":"08:53:41 AM 08-30-2022"}]
[null,2,{"$f":"AutoTimestamp(B6)","v":"08:53:41 AM 08-30-2022"}]
[null,3,{"$f":"AutoTimestamp(B7)","v":"08:53:41 AM 08-30-2022"}]
[null,4,{"$f":"AutoTimestamp(B8)","v":"08:53:41 AM 08-30-2022"}]
[null,5,{"$f":"AutoTimestamp(B9)","v":"08:53:41 AM 08-30-2022"}]
[null,6,{"$f":"AutoTimestamp(B10)","v":"08:53:41 AM 08-30-2022"}]

{"sheet":"User-Defined Function","index":2,"n_rows":12,"n_cols":19,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,17,1,18]]}
[]
[null,"Using VBA Code With User-Defined Function",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Input","Timestamp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Input","Timestamp"]
[null,1,{"$f":"AutoTimestamp(B5)","v":"08:53:41 AM 08-30-2022"}]
[null,2,{"$f":"AutoTimestamp(B6)","v":"08:53:41 AM 08-30-2022"}]
[null,3,{"$f":"AutoTimestamp(B7)","v":"08:53:41 AM 08-30-2022"}]
[null,4,{"$f":"AutoTimestamp(B8)","v":"08:53:41 AM 08-30-2022"}]
[null,5,{"$f":"AutoTimestamp(B9)","v":"08:53:41 AM 08-30-2022"}]
[null,6,{"$f":"AutoTimestamp(B10)","v":"08:53:41 AM 08-30-2022"}]
[]
[null,"Last Updated","2022-08-30T09:27:02"]

{"sheet":"VBA Code With Command But","index":3,"n_rows":12,"n_cols":19,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,17,1,18]]}
[]
[null,"Using VBA Code With Command Button",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Input","Timestamp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Input","Timestamp"]
[null,1,{"$f":"AutoTimestamp(B5)","v":"08:53:41 AM 08-30-2022"}]
[null,2,{"$f":"AutoTimestamp(B6)","v":"08:53:41 AM 08-30-2022"}]
[null,3,{"$f":"AutoTimestamp(B7)","v":"08:53:41 AM 08-30-2022"}]
[null,4,{"$f":"AutoTimestamp(B8)","v":"08:53:41 AM 08-30-2022"}]
[null,5,{"$f":"AutoTimestamp(B9)","v":"08:53:41 AM 08-30-2022"}]
[null,6,{"$f":"AutoTimestamp(B10)","v":"08:53:41 AM 08-30-2022"}]
[]
[null,"Last Updated","2022-08-30T09:53:51"]

{"sheet":"Command Button","index":4,"n_rows":12,"n_cols":20,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,18,1,19]]}
[]
[null,"Using VBA Code With Command Button",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Input","Timestamp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Input","Timestamp"]
[]
[]
[]
[]
[]
[]
[]
[null,"Last Updated","2022-08-29T16:31:15"]

{"sheet":"Utilizing IF Function","index":5,"n_rows":9,"n_cols":20,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,18,1,19]]}
[]
[null,"Utilizing IF Function",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Input","Timestamp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Input","Timestamp"]
[null,1,{"$f":"IF(B5<>\"\",IF(AND(C5<>\"\",CELL(\"address\")=ADDRESS(ROW(B5),COLUMN(B5))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B5),COLUMN(B5)),C5,NOW())),\"\")","v":"2022-08-30T10:43:43.110"}]
[null,2,{"$f":"IF(B6<>\"\",IF(AND(C6<>\"\",CELL(\"address\")=ADDRESS(ROW(B6),COLUMN(B6))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B6),COLUMN(B6)),C6,NOW())),\"\")","v":"2022-08-30T10:44:35.350"}]
[null,3,{"$f":"IF(B7<>\"\",IF(AND(C7<>\"\",CELL(\"address\")=ADDRESS(ROW(B7),COLUMN(B7))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B7),COLUMN(B7)),C7,NOW())),\"\")","v":"2022-08-30T10:44:37.330"}]
[null,4,{"$f":"IF(B8<>\"\",IF(AND(C8<>\"\",CELL(\"address\")=ADDRESS(ROW(B8),COLUMN(B8))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B8),COLUMN(B8)),C8,NOW())),\"\")","v":"2022-08-30T10:44:38.130"}]
[null,5,{"$f":"IF(B9<>\"\",IF(AND(C9<>\"\",CELL(\"address\")=ADDRESS(ROW(B9),COLUMN(B9))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B9),COLUMN(B9)),C9,NOW())),\"\")","v":"2022-08-30T10:44:39.110"}]

{"sheet":"Use of Date Formula","index":6,"n_rows":10,"n_cols":19,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,17,1,18]]}
[]
[null,"Use of Date Formula",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Dates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Input","Timestamp"]
[null,{"$f":"DATE(1999,1,1)","v":"1999-01-01"}]
[null,{"$f":"DATE(2022,1,1)","v":"2022-01-01"}]
[null,{"$f":"DATE(2022,10,1)","v":"2022-10-01"}]
[null,{"$f":"DATE(1999,10,12)","v":"1999-10-12"}]
[null,{"$f":"DATE(2022,8,10)","v":"2022-08-10"}]
[null,{"$f":"DATE(2022,8,30)","v":"2022-08-30"}]