{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","Circular Reference","IF & TODAY","VBA","Custom 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":"Dataset","index":0,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset Overview"]
[]
[null,"Name","Entry Date"]

{"sheet":"Circular Reference","index":1,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Use of Circular Reference Trick",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Name","Entry Date",null,null,null,null,"Name","Entry Time"]
[null,"John",{"$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-06-14T11:41:13.650"}]
[null,"Chris",{"$f":"IF(B6<>\"\",IF(AND(C6<>\"\",CELL(\"address\")=\nADDRESS(ROW(B6),COLUMN(B6))),NOW(),\nIF(CELL(\"address\")<>ADDRESS(ROW(B6),\nCOLUMN(B6)),C6,NOW())),\"\")","v":"2022-06-14T11:41:21.760"}]
[null,"Lisa",{"$f":"IF(B7<>\"\",IF(AND(C7<>\"\",CELL(\"address\")=\nADDRESS(ROW(B7),COLUMN(B7))),NOW(),\nIF(CELL(\"address\")<>ADDRESS(ROW(B7),\nCOLUMN(B7)),C7,NOW())),\"\")","v":"2022-06-14T11:59:21.670"}]
[null,"Tony",{"$f":"IF(B8<>\"\",IF(AND(C8<>\"\",CELL(\"address\")=\nADDRESS(ROW(B8),COLUMN(B8))),NOW(),\nIF(CELL(\"address\")<>ADDRESS(ROW(B8),\nCOLUMN(B8)),C8,NOW())),\"\")","v":"2022-06-14T11:59:23.530"}]

{"sheet":"IF & TODAY","index":2,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Combination of IF & TODAY Functions",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Name","Entry Date",null,null,null,null,"Name","Entry Time"]
[null,"John",{"$f":"IF(B5=\"\",\"\",TODAY())","v":"2022-06-14"}]
[null,"Chris",{"$f":"IF(B6=\"\",\"\",TODAY())","v":"2022-06-14"}]
[null,"Lisa","2022-06-14"]
[null,"Tony","2022-06-14"]

{"sheet":"VBA","index":3,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Use of VBA Code",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Name","Entry Date",null,null,null,null,"Name","Entry Time"]
[null,"John","2022-06-14T11:49:13"]
[null,"Chris","2022-06-14T11:49:15"]
[null,"Lisa","2022-06-14T12:00:00"]
[null,"Tony","2022-06-14T12:00:00"]

{"sheet":"Custom Function","index":4,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Use of Custom Function",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Name","Entry Date",null,null,null,null,"Name","Entry Time"]
[null,"John",{"$f":"TIMESTAMP(B5)","v":"14-06-2022"}]
[null,"Chris",{"$f":"TIMESTAMP(B6)","v":"14-06-2022"}]
[null,"Lisa",{"$f":"TIMESTAMP(B7)","v":"14-06-2022"}]
[null,"Tony",{"$f":"TIMESTAMP(B8)","v":"14-06-2022"}]