{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["HIDE FILE","ATTENDANCE SHEET","OUTPUT"],"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":"HIDE FILE","index":0,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,5,1048575,16383],[23,0,1048575,4]]}
["EMP ID","EMP_NAME","DATE","IN-TIME","OUT-TIME"]
[1001,"SIPRA BHAKTA",{"$f":"NOW()","v":"2010-09-08T16:20:19.850"},{"$f":"NOW()","v":40429.680785300923},{"$f":"NOW()","v":40429.680785300923}]
[1005,"SUKLA MONDAL",{"$f":"NOW()","v":"2010-09-08T16:20:19.850"},40429.680785300923,40429.680785300923]
[1010,"LIPIKA DEBNATH","2010-09-08T16:20:19.850",40429.680785300923,40429.680785300923]
[1015,"TUMPA KANSARI","2010-09-08T16:20:19.850",40429.680785300923,40429.680785300923]
[1020,"BEAUTY ROY","2010-09-08T16:20:19.850",40429.680785300923,40429.680785300923]
[1025,"RANJEETA SWAIN","2010-09-08T16:20:19.850",40429.680785300923,40429.680785300923]
[1030,"TUMPA RAKSHIT","2010-09-08T16:20:19.850",40429.680785300923,40429.680785300923]
[1035,"C. RAJ LAXMI","2010-09-08T16:20:19.850",40429.680785300923,40429.680785300923]
[1040,"MANOJ MAJI","2010-09-08T16:20:19.850",40429.680785300923,40429.680785300923]
[1045,"SAMIR MAHATA","2010-09-08T16:20:19.850",40429.680785300923,40429.680785300923]
[1050,"SIVA RAMAKRISHNA","2010-09-08T16:20:19.850",40429.680785300923,40429.680785300923]
[1055,"MRIDUL PURKAIT","2010-09-08T16:20:19.850",40429.680785300923,40429.680785300923]
[1060,"DEBDOOT MUKHERJEE","2010-09-08T16:20:19.850",40429.680785300923,40429.680785300923]
[1065,"MD SANJOY","2010-09-08T16:20:19.850",40429.680785300923,40429.680785300923]
[1070,"RAKESH PANDEY","2010-09-08T16:20:19.850",40429.680785300923,40429.680785300923]
[1075,"MOSTAFA GOLAM","2010-09-08T16:20:19.850",40429.680785300923,40429.680785300923]
[1080,"NILKANTA SINHA","2010-09-08T16:20:19.850",40429.680785300923,40429.680785300923]
[1085,"SHUBAJIT NAGRAY","2010-09-08T16:20:19.850",40429.680785300923,40429.680785300923]
[1090,"RONIT SAHA","2010-09-08T16:20:19.850",40429.680785300923,40429.680785300923]
[1095,"SHABBIR ALI ","2010-09-08T16:20:19.850",40429.680785300923,40429.680785300923]
[1200,"RAKSHIT SARKAR","2010-09-08T16:20:19.850",40429.680785300923,40429.680785300923]
[1205,"RANJANA KUMAR","2010-09-08T16:20:19.850",40429.680785300923,40429.680785300923]

{"sheet":"ATTENDANCE SHEET","index":1,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,2,1,6],[0,8,1048575,16383],[13,2,13,4],[13,5,13,6],[15,1,1048575,6]]}
[]
["EMP ID"]
[]
[1001,null,"EMP_ID  =======>",1005,null,"EMP_ID   =======>",1001]
[1005]
[1010,null,"EMP_NAME    =======>",{"$f":"VLOOKUP(D4,'HIDE FILE'!A1:B23,2,0)","v":"SUKLA MONDAL"},null,"EMP_NAME  =======>",{"$f":"VLOOKUP(G4,'HIDE FILE'!A1:B23,2,0)","v":"SIPRA BHAKTA"}]
[1015]
[1020,null,"PRESENT  DATE   =======>",{"$f":"VLOOKUP(D4,'HIDE FILE'!A1:C23,3,0)","v":"2010-09-08T16:20:19.850"},null,"PRESENT  DATE   =======>",{"$f":"VLOOKUP(G4,'HIDE FILE'!A1:C23,3,0)","v":"2010-09-08T16:20:19.850"}]
[1025]
[1030,null,"IN_TIME   =======>",{"$f":"VLOOKUP(D4,'HIDE FILE'!A1:D23,4,0)","v":40429.680785300923},null,"IN_TIME   =======>",{"$f":"VLOOKUP(G4,'HIDE FILE'!A1:E23,5,0)","v":40429.680785300923}]
[1035]
[1040]
[1045]
[1050,null,"TOTAL   WORK   DURATION ",null,null,{"$f":"TEXT(G10-D10,\"HH:MM\")","v":"00:00"}]
[1060]
[1065]
[1070]
[1075]
[1080]
[1085]
[1090]
[1095]
[1200]
[1205]

{"sheet":"OUTPUT","index":2,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"DATE","EMP_ID","EMP_NAME","IN_TIME",null,"EMP_ID","EMP_NAME","OUT_TIME"]
[null,"2010-09-08T15:10:00",1005,"SUKLA MONDAL",40429.638817361112,null,1001,"SIPRA BHAKTA",40429.659574652775]
[null,"2010-09-08T15:59:09",1005,"SUKLA MONDAL",40429.668924421298,null,1001,"SIPRA BHAKTA",40429.662624189812]
[null,"2010-09-08T16:03:15",1005,"SUKLA MONDAL",40429.668934953705,null,1001,"SIPRA BHAKTA",40429.668953009263]
[null,"2010-09-08T16:18:58",1005,"SUKLA MONDAL",40429.680448611114,null,1001,"SIPRA BHAKTA",40429.680471643522]