{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["SUMMARY","shyam kumar 231","Guddu Rai 713F OMAN (2)","ARIF OMAN","gopalakrishna 79","RAJASEKAHAR 213"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"SUMMARY","index":0,"n_rows":200,"n_cols":17,"rows_kept":200,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,{"$f":"+'shyam kumar 231'!B11","v":"WORKING PERIOD"},null,null,{"$f":"+'shyam kumar 231'!D5","v":"LEAVE AVAILED"}]
["B6","B5","B7","B3","B8","B9","B12","B13","A17","D6","D7","D8","D9","D10","D11","D12"]
[{"$f":"+'shyam kumar 231'!A6","v":"ROLL NO"},{"$f":"+'shyam kumar 231'!A5","v":"NAME"},{"$f":"+'shyam kumar 231'!A7","v":"DESIGNATION"},"Loacation",{"$f":"+'shyam kumar 231'!A8","v":"DATE OF JOIN"},{"$f":"+'shyam kumar 231'!A9","v":"VISA STAMP"},{"$f":"+'shyam kumar 231'!A12","v":"FROM :"},{"$f":"+'shyam kumar 231'!A13","v":"TO:"},"LEAVE & BENEFIT PAID",1,2,3,4,5,6,7]
[{"$f":"IFERROR(INDIRECT(\"'\"&$Q4&\"'!\"&A$2),\"\")","v":231},{"$f":"IFERROR(INDIRECT(\"'\"&$Q4&\"'!\"&B$2),\"\")","v":"SHYAMKUMAR YADAV"},"AC TECH","OMAN","23.09.02","14.10.02","14.10.02","31.12.15","730*5","15.05.05 TO 15.07.05 W/B","28.04.07 TO 30.06.07 W/B","15.01.09 TO 14.06.09 OWN EXP","BENEFIT COLLECTED AUG 2009","10.06.10 TO 14.08.10 OWN EXP","26.02.12 TO 04.05.12 W/B(DUE ON 30.09.11)","20.01.14 TO 04.04.14 W/B9DUE ON 08.12.13)","shyam kumar 231"]
[713,"GUDDU RAI","DUCTMAN","OMAN",0,"11.11.11","11.11.11","31.10.15","730*1",0,"10.04.14 TO 10.05.14 W/B",0,0,0,0,0,"Guddu Rai 713F OMAN (2)"]
[888,"ARIF OMAN","MECH-ENGINEER","OMAN",0,"01.09.12","01.09.12","31.03.15","365*2","19.10.13 TO 22.11.13 W/B","07.10.14 TO 31.10.14 OWN EXP","BENEFIT DEC-14",0,0,0,0,"ARIF OMAN"]
[79,"GOPALKRISHNAALLAKATTU","ELECT","OMAN",0,"27.09.11","27.09.11","31.08.15",0,0,"26.01.14 TO 01.05.14  W/B",0,0,0,0,0,"gopalakrishna 79"]
[213,"RAJASEKAHARAN NAIR","AC PIPING","OMAN",0,"17.10.11","17.10.11","31.07.15",0,0,"16.10.12 TO 24.11.12 OWN EXP","01.06.14 TO 28.07.14 WITH BENEFIT",0,0,0,0,"RAJASEKAHAR 213"]
[{"$f":"IFERROR(INDIRECT(\"'\"&$Q9&\"'!\"&A$2),\"\")","v":""},"","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
[{"$f":"IFERROR(INDIRECT(\"'\"&$Q35&\"'!\"&A$2),\"\")","v":""},"","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",{"$f":"IFERROR(INDIRECT(\"'\"&$Q50&\"'!\"&P$2),\"\")","v":""}]
[{"$f":"IFERROR(INDIRECT(\"'\"&$Q51&\"'!\"&A$2),\"\")","v":""},"","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",{"$f":"IFERROR(INDIRECT(\"'\"&$Q67&\"'!\"&P$2),\"\")","v":""}]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",{"$f":"IFERROR(INDIRECT(\"'\"&$Q84&\"'!\"&P$2),\"\")","v":""}]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",{"$f":"IFERROR(INDIRECT(\"'\"&$Q101&\"'!\"&P$2),\"\")","v":""}]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
[{"$f":"IFERROR(INDIRECT(\"'\"&$Q115&\"'!\"&A$2),\"\")","v":""},"","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",{"$f":"IFERROR(INDIRECT(\"'\"&$Q118&\"'!\"&P$2),\"\")","v":""}]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",{"$f":"IFERROR(INDIRECT(\"'\"&$Q135&\"'!\"&P$2),\"\")","v":""}]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",{"$f":"IFERROR(INDIRECT(\"'\"&$Q152&\"'!\"&P$2),\"\")","v":""}]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",{"$f":"IFERROR(INDIRECT(\"'\"&$Q169&\"'!\"&P$2),\"\")","v":""}]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
[{"$f":"IFERROR(INDIRECT(\"'\"&$Q179&\"'!\"&A$2),\"\")","v":""},"","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",{"$f":"IFERROR(INDIRECT(\"'\"&$Q186&\"'!\"&P$2),\"\")","v":""}]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]
["","","","","","","","","","","","","","","",""]

{"sheet":"shyam kumar 231","index":1,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"OMAN"]
[]
["NAME","SHYAMKUMAR YADAV",null,"LEAVE AVAILED"]
["ROLL NO",231,null,"15.05.05 TO 15.07.05 W/B"]
["DESIGNATION","AC TECH",null,"28.04.07 TO 30.06.07 W/B"]
["DATE OF JOIN","23.09.02",null,"15.01.09 TO 14.06.09 OWN EXP"]
["VISA STAMP","14.10.02","NEW CONT","BENEFIT COLLECTED AUG 2009"]
[null,null,null,"10.06.10 TO 14.08.10 OWN EXP"]
[null,"WORKING PERIOD","W/DAYS","26.02.12 TO 04.05.12 W/B(DUE ON 30.09.11)"]
["FROM :",{"$f":"B9","v":"14.10.02"},null,"20.01.14 TO 04.04.14 W/B9DUE ON 08.12.13)"]
["TO:","31.12.15",4328,"DAYS"]
[]
[]
["           LESS: LEAVE & BENEFIT PAID",null,3650]
["730*5"]
[null,"BALANCE",{"$f":"C13-C16","v":678}]
["       ADD NO OF DAYS REQUIRED",null,52]
["01.01.16 TO 22.02.16"]
[null,null,{"$f":"C18+C19","v":730}]
[]
[]
[null,"NEXT LEAVE &BENEFIT DUE ON 22.02.16"]
[]
["LEAVE FROM  07.02.16"]

{"sheet":"Guddu Rai 713F OMAN (2)","index":2,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"OMAN"]
[]
["NAME","GUDDU RAI",null,"LEAVE AVAILED"]
["ROLL NO",713]
["DESIGNATION","DUCTMAN",null,"10.04.14 TO 10.05.14 W/B"]
["DATE OF JOIN"]
["VISA STAMP","11.11.11","NEW CONT"]
[]
[null,"WORKING PERIOD","W/DAYS"]
["FROM :",{"$f":"B9","v":"11.11.11"}]
["TO:","31.10.15",1338,"DAYS"]
[]
[]
["           LESS: LEAVE & BENEFIT PAID",null,730]
["730*1"]
[null,"BALANCE",{"$f":"C13-C16","v":608}]
["       ADD NO OF DAYS REQUIRED",null,122]
["01.11.15 TO 02.03.16"]
[null,null,{"$f":"C18+C19","v":730}]
[]
[]
[null,"NEXT LEAVE &BENEFIT DUE ON 02.03.16"]
[]
["LEAVE FROM  15.01.16"]

{"sheet":"ARIF OMAN","index":3,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"OMAN"]
[]
["NAME","ARIF OMAN",null,"LEAVE AVAILED"]
["ROLL NO",888,null,"19.10.13 TO 22.11.13 W/B"]
["DESIGNATION","MECH-ENGINEER",null,"07.10.14 TO 31.10.14 OWN EXP"]
["DATE OF JOIN",null,null,"BENEFIT DEC-14"]
["VISA STAMP","01.09.12","NEW CONT"]
[]
[null,"WORKING PERIOD","W/DAYS"]
["FROM :",{"$f":"B9","v":"01.09.12"}]
["TO:","31.03.15",854,"DAYS"]
[]
[]
["           LESS: LEAVE & BENEFIT PAID",null,730]
["365*2"]
[null,"BALANCE",{"$f":"C13-C16","v":124}]
["       ADD NO OF DAYS REQUIRED",null,241]
["01.04.15 TO 27.11.15"]
[null,null,{"$f":"C18+C19","v":365}]
[]
[]
[null,"NEXT LEAVE &BENEFIT DUE ON 28.11.15"]
[]
["LEAVE FROM19.04.15 TO 01.05.15"]

{"sheet":"gopalakrishna 79","index":4,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"OMAN"]
[]
["NAME","GOPALKRISHNAALLAKATTU",null,"LEAVE AVAILED"]
["ROLL NO",79]
["DESIGNATION","ELECT",null,"26.01.14 TO 01.05.14  W/B"]
["DATE OF JOIN"]
["VISA STAMP","27.09.11"]
[]
[null,"WORKING PERIOD","W/DAYS"]
["FROM :",{"$f":"B9","v":"27.09.11"}]
["TO:","31.08.15",1313.5,"DAYS"]
[]
[]
["           LESS: LEAVE & BENEFIT PAID",null,730]
[]
[null,"BALANCE",{"$f":"C13-C16","v":583.5}]
["       ADD NO OF DAYS REQUIRED",null,146.5]
["01.09.15 TO 25.01.16"]
[null,null,{"$f":"C18+C19","v":730}]
[]
[]
[null,"NEXT LEAVE& BENEFIT DUE ON 25.01.16"]
[]
[]
["LEAVE FROM 22.10.15 TO 22.12.15"]

{"sheet":"RAJASEKAHAR 213","index":5,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"OMAN"]
[]
["NAME","RAJASEKAHARAN NAIR",null,"LEAVE AVAILED"]
["ROLL NO",213]
["DESIGNATION","AC PIPING",null,"16.10.12 TO 24.11.12 OWN EXP"]
["DATE OF JOIN",null,null,"01.06.14 TO 28.07.14 WITH BENEFIT"]
["VISA STAMP","17.10.11"]
[]
[null,"WORKING PERIOD","W/DAYS"]
["FROM :",{"$f":"B9","v":"17.10.11"}]
["TO:","31.07.15",1208.5,"DAYS"]
[]
[]
["           LESS: LEAVE & BENEFIT PAID",null,730]
[]
[null,"BALANCE",{"$f":"C13-C16","v":478.5}]
["       ADD NO OF DAYS REQUIRED",null,251.5]
["01.08.15 TO 9.04.16"]
[null,null,{"$f":"C18+C19","v":730}]
[]
[]
[null,"NEXT LEAVE& BENEFIT DUE ON 09.04.16"]
[]
[]
["LEAVE FROM 03.09.15 TO 18.09.15"]