{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["LEAVE CALCULATION SHEET","END OF SERVICE"," Leave  Details"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":4,"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":"LEAVE CALCULATION SHEET","index":0,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[29,0,30,6],[40,0,40,1],[40,5,40,7],[41,0,41,1],[41,5,41,7],[27,1,27,3],[27,6,27,7],[10,1,10,6],[11,1,11,6],[12,1,12,6],[13,1,13,6],[14,1,14,6],[15,0,17,6],[20,1,20,6],[21,1,21,6],[22,1,22,6],[24,0,24,4],[25,2,25,4],[8,0,9,6],[0,0,0,6],[1,0,1,6],[4,0,4,6],[6,5,6,6],[5,2,5,4],[5,5,5,6],[6,2,6,4]]}
["شركة المجموعة المشتركة للمقاولات (ش.م.ك.م )"]
["Combined Group Contracting Co. (K.S.C.C)"]
[]
[]
["LEAVE CALCULATION SHEET"]
["NAME:  ","MUHAMMAD ASIF MUHAMMAD ASHRAF","Employee No.:",null,null,91977]
["DESIGNATION:          ","LABOUR","Joining Date:",null,null,"2017-02-05"]
[null,null,null,null,null,"    "]
["Salary Details "]
[]
["Basic ",700]
["Accomodation",0]
["Bonus ",0]
["Food",0]
["Total Salary ",{"$f":"SUM(B11:G14)","v":700}]
["Working Days "]
[]
[]
["From",{"$f":"F7","v":"2017-02-05"},null,null,"2019-08-30"]
[]
["Days",{"$f":"+E19-B19+1","v":937},null,null,null,null,null,null,null,null,null,30,{"$f":"B23*(30/365)-B26","v":77.013698630136986}]
["Leave Without Pay",0,null,null,null,null,null,null,null,null,null,12,{"$f":"B23*(12/180)-B26","v":62.466666666666669}]
["Net working days",{"$f":"B21-B22","v":937},null,null,null,null,null,null,null,null,null,"less","He Don't Deserve Leave Salary"]
[null,null,null,null,null,null,null,null,null,null,null,"desirve",{"$f":"IF(B23<365,M22,M21)","v":77.013698630136986}]
["Leave Balance Calculation "]
["Previouse Paid Leave (days)",0,"Days"]
[]
["Desirve Leaves ( Days)",{"$f":"IF(B23<=182,M23,M24)","v":77.013698630136986},null,null,"Days",null,"New Leave Balance ",null,{"$f":"B28-B35","v":3.6986301369807961E-3},"Days"]
[]
["Payment"]
[]
[]
["Required Days From employees",90]
[]
["Paid Days",77.010000000000005]
["Unpaid days",{"$f":"B33-B35","v":12.989999999999995}]
[]
["Calculation ",{"$f":"B15*B35/30","v":1796.9},"DHS"]
[]
[]
["Mohamed Sobhi",null,null,null,null,"Mohammed Al Hariri "]
["Admin Supervisor",null,null,null,null,"HR / Admin manager "]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,36.78]
[null,null,null,null,3.85]
[null,null,null,null,55]

{"sheet":"END OF SERVICE","index":1,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[34,0,34,1],[35,0,35,1],[35,5,35,7],[34,5,34,7],[12,1,12,6],[13,1,13,6],[15,0,17,6],[20,1,20,6],[21,1,21,6],[23,1,23,6],[14,1,14,6],[26,0,26,2],[25,0,25,6],[26,4,26,6],[22,1,22,6],[0,0,0,6],[1,0,1,6],[4,0,4,6],[10,1,10,6],[11,1,11,6],[8,0,9,6],[6,5,6,6],[5,1,5,3],[5,5,5,6],[6,1,6,3]]}
["شركة المجموعة المشتركة للمقاولات (ش.م.ك.م )"]
["Combined Group Contracting Co. (K.S.C.C)"]
[]
[]
["End of Service Benefits"]
["Name",{"$f":"'LEAVE CALCULATION SHEET'!B6","v":"MUHAMMAD ASIF MUHAMMAD ASHRAF"},null,null,"Emp #",{"$f":"'LEAVE CALCULATION SHEET'!F6:G6","v":91977}]
["DESIGNATION                                           JOINING DATE: ",{"$f":"'LEAVE CALCULATION SHEET'!B7","v":"LABOUR"},null,null,"Joining Date",{"$f":"'LEAVE CALCULATION SHEET'!F7:G7","v":"2017-02-05"}]
[]
["Salary Details "]
[]
["Basic ",{"$f":"'LEAVE CALCULATION SHEET'!B11:G11","v":700}]
["Accomodation",0]
["Bonus "]
["Food",0]
["Total Salary ",{"$f":"SUM(B11:C14)","v":700}]
["Working Days "]
[]
[]
["From",{"$f":"F7","v":"2017-02-05"},null,null,{"$f":"'LEAVE CALCULATION SHEET'!E19","v":"2019-08-30"}]
[]
["Days",{"$f":"+E19-B19+1","v":937}]
["Leave Without Pay",{"$f":"'LEAVE CALCULATION SHEET'!B22:G22","v":0}]
["Paid Leave (days)",{"$f":"'LEAVE CALCULATION SHEET'!B28:D28","v":77.013698630136986}]
["Net working days",{"$f":"B21-B22+B23","v":1014.013698630137}]
[]
["End of service calculation "]
["In Case of Resignation more than 5 years",null,null,null,"In Case of Resignation"]
[]
["Net Working Days ",{"$f":"B24-F29","v":0},"Days",null,"Net Working Days",{"$f":"B24","v":1014.013698630137},"Days"]
["Benefits Per Year",30,"Days",null,"Benefits Per Year",7,"Days"]
["Deserve Days",{"$f":"B29*B30/365","v":0},"Days",null,"Deserve Days",{"$f":"F29*F30/365","v":19.446838055920438},"Days"]
["Net Payment",{"$f":"B31*B11/30","v":0},"Dhs",null,"Net Payment",{"$f":"F31*B11/30","v":453.75955463814353},"Dhs"]
[]
[null,null,null,null,"TOTAL",{"$f":"F32+B32","v":453.75955463814353}]
["Nedal Momani",null,null,null,null,"Mohammed Al Hariri "]
["Administrator",null,null,null,null,"HR / Admin manager "]

{"sheet":" Leave  Details","index":2,"n_rows":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,1,2,4],[3,1,3,4],[41,2,41,4],[42,2,42,4],[5,4,5,5],[6,4,6,5],[41,0,41,1],[42,0,42,1]]}
[]
[null,"COMBINED GROUP CONTRACTING CO. (K.S.C.) (ABU DHABI)"]
[]
[null," Leave balance Details\n"]
[]
["Employee No.:","Name","Disignation","Joining Date:","Date"]
[{"$f":"VLOOKUP(A6,'LEAVE CALCULATION SHEET'!$C$6:$G$6,4,0)","v":91977},{"$f":"'LEAVE CALCULATION SHEET'!B6","v":"MUHAMMAD ASIF MUHAMMAD ASHRAF"},{"$f":"'LEAVE CALCULATION SHEET'!B7","v":"LABOUR"},{"$f":"VLOOKUP(D6,'LEAVE CALCULATION SHEET'!$C$7:$G$7,4,0)","v":"2017-02-05"},{"$f":"TODAY()","v":"2019-08-03"}]
["#","First Day On Leave","Duty Resumption","PAID","UNPAID","The Actual Vacation"]
[1,null,null,null,{"$f":"F9-D9","v":0},{"$f":"C9-B9","v":0}]
[2,null,null,null,0,{"$f":"C10-B10","v":0}]
[3,null,null,null,0,0]
[4,null,null,null,0,0]
[5,null,null,null,0,0]
[6,null,null,null,0,0]
[7,null,null,null,0,0]
[8,null,null,null,0,0]
[9,null,null,null,0,0]
[10,null,null,null,0,0]
[11,null,null,null,0,0]
[12,null,null,null,0,0]
[13,null,null,null,0,0]
[14,null,null,null,0,0]
[15,null,null,null,0,0]
[16,null,null,null,0,0]
[17,null,null,null,0,0]
[18,null,null,null,0,0]
[19,null,null,null,0,0]
[20,null,null,null,0,0]
[21,null,null,null,0,0]
[22,null,null,null,0,0]
[23,null,null,null,0,0]
[24,null,null,null,0,0]
[25,null,null,null,0,0]
[26,null,null,null,0,0]
[27,null,null,null,0,0]
[28,null,null,null,0,0]
[29,null,null,null,0,0]
[30,null,null,null,0,0]
[null,null,"TOTAL",{"$f":"SUM(D9:D38)","v":0},{"$f":"SUM(E9:E38)","v":0}]
[]
[]
["Mohamed Sobhi",null,"Mohammed Al Hariri "]
["Admin Supervisor",null,"HR / Admin manager "]