{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Input","OUTPUT"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Input","index":0,"n_rows":67,"n_cols":7,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[]
["Date","Time","Event Description","Device Child","Status","ItemNo","Item Description"]
["2016-01-03","08:44:49","Access granted","IPL_ABC_F3_H20007_MAIN DOOR 3_ENTRY","ENTRY",1234,"Ved Prakash"]
["2016-01-03","08:49:32","Access granted","IPL_ABC_F3_H20007_MAIN DOOR 4_EXIT","EXIT",1234,"Ved Prakash"]
["2016-01-03","08:51:21","Access granted","IPL_ABC_F8_H30003_C5_IN_Entry","EXIT",1234,"Ved Prakash"]
["2016-01-03","09:39:47","Access granted","IPL_ABC_F8_PRODUCTION AREA MAIN FIRE DOOR 1_Exit","EXIT",1234,"Ved Prakash"]
["2016-01-03","10:16:49","Access granted","IPL_ABC_F3_H20007_MAIN DOOR 4_ENTRY","ENTRY",1234,"Ved Prakash"]
["2016-01-03","12:04:26","Access granted","IPL_ABC_F3_H20007_MAIN DOOR 4_EXIT","EXIT",1234,"Ved Prakash"]
["2016-01-03","12:12:22","Access granted","IPL_ABC_F1_H20004_MAIN ENTRANCE DR_EXIT","EXIT",1234,"Ved Prakash"]
["2016-01-03","12:22:03","Access granted","IPL_ABC_P1_FIRE EXIT DOOR_ENTRY","ENTRY",1234,"Ved Prakash"]
["2016-01-03","12:22:58","Access granted","IPL_ABC_P1_FIRE EXIT DOOR_EXIT","EXIT",1234,"Ved Prakash"]
["2016-01-03","12:30:11","Access granted","IPL_ABC_F3_H20007_MAIN DOOR 3_ENTRY","ENTRY",1234,"Ved Prakash"]
["2016-01-03","13:54:03","Access granted","IPL_ABC_F3_H20003_MAIN DOOR 1_EXIT","EXIT",1234,"Ved Prakash"]
["2016-01-03","13:54:55","Access granted","IPL_ABC_F2_H10001_LIFT LOBBY DR2_ENTRY","ENTRY",1234,"Ved Prakash"]
["2016-01-03","15:01:41","Access granted","IPL_ABC_F2_H10001_LIFT LOBBY DR2_EXIT","EXIT",1234,"Ved Prakash"]
["2016-01-03","15:03:12","Access granted","IPL_ABC_F3_H20007_MAIN DOOR 4_ENTRY","ENTRY",1234,"Ved Prakash"]
["2016-01-03","15:09:34","Access granted","IPL_ABC_F3_H20007_MAIN DOOR 4_EXIT","EXIT",1234,"Ved Prakash"]
["2016-01-03","16:13:03","Access granted","IPL_ABC_F3_H20007_MAIN DOOR 4_ENTRY","ENTRY",1234,"Ved Prakash"]
["2016-01-03","16:26:24","Access granted","IPL_ABC_F3_H20007_MAIN DOOR 4_EXIT","EXIT",1234,"Ved Prakash"]
["2016-02-03","09:31:24","Access granted","IPL_ABC_F3_H20007_MAIN DOOR 4_ENTRY","ENTRY",1234,"Ved Prakash"]
["2016-02-03","09:52:56","Access granted","IPL_ABC_F3_H20007_MAIN DOOR 4_EXIT","EXIT",1234,"Ved Prakash"]
["2016-02-03","09:54:07","Access granted","IPL_ABC_F8_H30003_C5_IN_Entry","EXIT",1234,"Ved Prakash"]
["2016-02-03","10:10:44","Access granted","IPL_ABC_F8_PRODUCTION AREA MAIN FIRE DOOR 1_Exit","EXIT",1234,"Ved Prakash"]
["2016-02-03","10:19:06","Access granted","IPL_ABC_F6_H60003_LIFT LOBBY DR1_ENTRY","ENTRY",1234,"Ved Prakash"]
["2016-02-03","10:36:10","Access granted","IPL_ABC_F6_H60003_LIFT LOBBY DR2_EXIT","EXIT",1234,"Ved Prakash"]
["2016-02-03","10:37:36","Access granted","IPL_ABC_F5_H10004_LIFT LOBBY 2_ENTRY","ENTRY",1234,"Ved Prakash"]
["2016-02-03","10:41:38","Access granted","IPL_ABC_F5_H10004_LIFT LOBBY 1_EXIT","EXIT",1234,"Ved Prakash"]
["2016-02-03","10:50:08","Access granted","IPL_ABC_F2_H10001_LIFT LOBBY DR2_ENTRY","ENTRY",1234,"Ved Prakash"]
["2016-02-03","10:57:06","Access granted","IPL_ABC_F2_H10002_LIFT LOBBY DR4_EXIT","EXIT",1234,"Ved Prakash"]
["2016-02-03","11:11:56","Access granted","IPL_ABC_P3_TURNSTILE 3 OUT Exit","EXIT",1234,"Ved Prakash"]
["2016-02-03","12:40:08","Access granted","IPL_ABC_P3_TURNSTILE 2 IN_entry","EXIT",1234,"Ved Prakash"]
["2016-02-03","12:42:31","Access granted","IPL_ABC_F6_H60003_LIFT LOBBY DR2_ENTRY","ENTRY",1234,"Ved Prakash"]
["2016-02-03","14:36:46","Access granted","IPL_ABC_F3_H20007_MAIN DOOR 4_EXIT","EXIT",1234,"Ved Prakash"]
["2016-02-03","15:40:37","Access granted","IPL_ABC_F3_H20003_MAIN DOOR 2_EXIT","EXIT",1234,"Ved Prakash"]
["2016-02-03","15:42:19","Access granted","IPL_ABC_F8_PRODUCTION AREA MAIN FIRE DOOR 2_Entry","EXIT",1234,"Ved Prakash"]
["2016-02-03","16:40:04","Access granted","IPL_ABC_F3_H20007_MAIN DOOR 4_ENTRY","ENTRY",1234,"Ved Prakash"]
["2016-02-03","16:48:02","Access granted","IPL_ABC_F3_H20007_MAIN DOOR 4_EXIT","EXIT",1234,"Ved Prakash"]
["2016-02-03","16:50:52","Access granted","IPL_ABC_F6_H60003_LIFT LOBBY DR1_ENTRY","ENTRY",1234,"Ved Prakash"]
["2016-02-03","17:10:38","Access granted","IPL_ABC_F6_H60003_LIFT LOBBY DR1_EXIT","EXIT",1234,"Ved Prakash"]
["2016-02-03","17:19:58","Access granted","IPL_ABC_F6_H60003_LIFT LOBBY DR2_ENTRY","ENTRY",1234,"Ved Prakash"]
["2016-02-03","17:46:58","Access granted","IPL_ABC_F6_H60003_LIFT LOBBY DR2_EXIT","EXIT",1234,"Ved Prakash"]
["2016-02-03","17:47:42","Access granted","IPL_ABC_F3_H20007_MAIN DOOR 3_ENTRY","ENTRY",1234,"Ved Prakash"]
["2016-02-03","17:54:41","Access granted","IPL_ABC_F3_H20007_MAIN DOOR 4_EXIT","EXIT",1234,"Ved Prakash"]
["2016-02-03","17:56:05","Access granted","IPL_ABC_P3_TURNSTILE 2 OUT_EXIT","EXIT",1234,"Ved Prakash"]
["2016-02-03","18:07:37","Access granted","IPL_ABC_P3_TURNSTILE 2 IN_entry","EXIT",1234,"Ved Prakash"]
["2016-02-03","18:10:41","Access granted","IPL_ABC_F3_H20007_MAIN DOOR 4_ENTRY","ENTRY",1234,"Ved Prakash"]
["2016-02-03","18:15:11","Access granted","IPL_ABC_F3_H20007_MAIN DOOR 4_EXIT","EXIT",1234,"Ved Prakash"]
["2016-02-03","18:16:30","Access granted","IPL_ABC_P3_TURNSTILE 1 OUT Exit","EXIT",1234,"Ved Prakash"]
["2016-03-03","09:35:20","Access granted","IPL_ABC_F3_H20007_MAIN DOOR 4_ENTRY","ENTRY",1234,"Ved Prakash"]
["2016-03-03","09:43:18","Access granted","IPL_ABC_F3_H20007_MAIN DOOR 4_EXIT","EXIT",1234,"Ved Prakash"]
["2016-03-03","09:45:37","Access granted","IPL_ABC_F8_H30003_C5_IN_Entry","EXIT",1234,"Ved Prakash"]
["2016-03-03","09:52:50","Access granted","IPL_ABC_F8_H30003_C5_OUT_Exit","EXIT",1234,"Ved Prakash"]
["2016-03-03","09:56:49","Access granted","IPL_ABC_F6_H60003_LIFT LOBBY DR2_ENTRY","ENTRY",1234,"Ved Prakash"]
["2016-03-03","10:16:22","Access granted","IPL_ABC_F6_H60003_LIFT LOBBY DR1_EXIT","EXIT",1234,"Ved Prakash"]
["2016-03-03","10:32:06","Access granted","IPL_ABC_F5_H10003-LIFT LOBBY 3_EXIT","EXIT",1234,"Ved Prakash"]
["2016-03-03","10:42:53","Access granted","IPL_ABC_F8_PRODUCTION AREA MAIN FIRE DOOR 2_Exit","EXIT",1234,"Ved Prakash"]
["2016-03-03","10:44:33","Access granted","IPL_ABC_F2_H10002_LIFT LOBBY DR4_ENTRY","ENTRY",1234,"Ved Prakash"]
["2016-03-03","10:56:52","Access granted","IPL_ABC_F2_H10002_LIFT LOBBY DR4_EXIT","EXIT",1234,"Ved Prakash"]
["2016-03-03","11:29:49","Access granted","IPL_ABC_F1_H20003_LIFT LOBBY DR1_ENTRY","ENTRY",1234,"Ved Prakash"]
["2016-03-03","11:34:56","Access granted","IPL_ABC_F1_H20004_LIFT LOBBY DR2_EXIT","EXIT",1234,"Ved Prakash"]
["2016-03-03","12:14:49","Access granted","IPL_ABC_F1_H20004_LIFT LOBBY DR2_ENTRY","ENTRY",1234,"Ved Prakash"]
["2016-03-03","12:16:43","Access granted","IPL_ABC_F1_H20004_LIFT LOBBY DR2_EXIT","EXIT",1234,"Ved Prakash"]
["2016-03-03","13:29:15","Access granted","IPL_ABC_F3_H20007_MAIN DOOR 3_ENTRY","ENTRY",1234,"Ved Prakash"]
["2016-03-03","14:03:48","Access granted","IPL_ABC_F3_H20007_MAIN DOOR 4_EXIT","EXIT",1234,"Ved Prakash"]
["2016-03-03","18:10:33","Access granted","IPL_ABC_F3_H20007_MAIN DOOR 4_ENTRY","ENTRY",1234,"Ved Prakash"]
["2016-03-03","18:15:46","Access granted","IPL_ABC_F3_H20007_MAIN DOOR 4_EXIT","EXIT",1234,"Ved Prakash"]
["2016-03-03","18:16:50","Access granted","IPL_ABC_P3_TURNSTILE 2 OUT_EXIT","EXIT",1234,"Ved Prakash"]

{"sheet":"OUTPUT","index":1,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Date","Item Description","In Time","OUT Time"]
["2016-01-03","Ved Prakash","08:44:49","16:26:24"]
["2016-02-03","Ved Prakash","09:31:24","18:16:30"]
["2016-03-03","Ved Prakash","09:35:20","18:16:50"]