{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["dataset","Barcode Scan","Barcode Scan (2)","using formula","diy"],"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":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Barcode Scanner Entry with Timestamp"]
[]
[null,"Barcode","Start Time"]
[null,1234,"2022-03-07T13:54:49"]
[null,444231341,"2022-03-07T13:55:09"]
[null,554221324,"2022-03-07T13:55:11"]
[null,555321,"2022-03-07T13:55:13"]
[null,5432,"2022-03-07T13:55:15"]
[null,555,"2022-03-07T13:55:16"]
[null,61212,"2022-03-07T13:55:18"]

{"sheet":"Barcode Scan","index":1,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Barcode Scanning with both Start and Out Time"]
[]
[null,"Barcode"]
[null,"Product ID","Start Time","End Time","New Start Time","New End Time"]
[null,21312342,"2022-03-07T15:27:57","2022-03-07T15:28:59","2022-03-07T15:29:35","2022-03-07T15:29:44"]
[null,432314,"2022-03-07T15:30:08","2022-03-07T15:30:27","2022-03-07T15:30:31","2022-03-07T15:30:34"]
[null,12345,"2022-03-07T15:30:13","2022-03-07T15:30:37","2022-03-07T15:30:40","2022-03-07T15:30:43"]
[null,64313452,"2022-03-07T15:30:16","2022-03-07T15:30:58","2022-03-07T15:31:03","2022-03-07T15:31:07"]
[null,14543433,"2022-03-07T15:30:20","2022-03-07T15:31:10","2022-03-07T15:31:14","2022-03-07T15:31:17"]
[null,12443562,"2022-03-07T15:30:23","2022-03-07T15:31:20","2022-03-07T15:31:23","2022-03-07T15:31:27"]

{"sheet":"Barcode Scan (2)","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Barcode Scanner Entry with Start Time"]
[]
[null,"Barcode","Start Time"]
[null,1345312,"2022-03-07T16:22:20"]
[null,334253,"2022-03-07T16:22:41"]
[null,32143421,"2022-03-07T16:22:43"]
[null,554231,"2022-03-07T16:22:45"]
[null,3234341,"2022-03-07T16:22:47"]
[null,13455332,"2022-03-07T16:22:49"]
[null,3143453,"2022-03-07T16:22:51"]

{"sheet":"using formula","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Formula "]
[]
[null,"Barcode","Time"]
[null,34342134,{"$f":"IF(B5<>\"\",NOW(),\"\")","v":"2022-07-03T22:00:19.570"}]
[null,4435131,{"$f":"IF(B6<>\"\",NOW(),\"\")","v":"2022-07-03T22:00:19.570"}]
[null,3434145,{"$f":"IF(B7<>\"\",NOW(),\"\")","v":"2022-07-03T22:00:19.570"}]
[null,65676435,{"$f":"IF(B8<>\"\",NOW(),\"\")","v":"2022-07-03T22:00:19.570"}]
[null,6353756736,{"$f":"IF(B9<>\"\",NOW(),\"\")","v":"2022-07-03T22:00:19.570"}]
[null,4434233,{"$f":"IF(B10<>\"\",NOW(),\"\")","v":"2022-07-03T22:00:19.570"}]
[null,4534657,{"$f":"IF(B11<>\"\",NOW(),\"\")","v":"2022-07-03T22:00:19.570"}]

{"sheet":"diy","index":4,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Do It Yourself"]
[]
[null,"Barcode","Start Time"]
[null,1234]
[null,444231341]
[null,554221324]
[null,555321]
[null,5432]
[null,555]
[null,61212]