{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["LEAVE CALCULATION","91977","92107"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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","index":0,"n_rows":43,"n_cols":28,"rows_kept":43,"cut":false,"hidden":false,"merged":[[9,10,9,15],[9,0,10,0],[6,0,6,15],[2,0,2,15],[3,0,3,15],[7,7,7,11],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,5,9,9]]}
[]
[]
["شركة المجموعة المشتركة للمقاولات (ش.م.ك.م )"]
["Combined Group Contracting Co. (K.S.C.C)"]
[]
[]
["Leave Balance Calculation Sheet"]
[null,"Date:",{"$f":"TODAY()","v":"2019-08-05"}]
[]
["S/L","File No","Employee Name","Designation","Joining Date:","Gross Salary",null,null,null,null,"Leave Balance Calculation"]
[null,null,null,null,null,"Basic ","Accomodation","Bonus ","Food","Total Salary ","Days","Net working days","Leave Without Pay","Previouse Paid Leave (days)","Desirve Leaves ( Days)","Leave Balance "]
[1,92107,null,null,{"$f":"IFERROR(VLOOKUP($E$10,'92107'!$C$7:$G$7,4,0),\"-\")","v":"2018-05-23"},{"$f":"IFERROR(VLOOKUP($F$11,'92107'!$A$11:$G$11,2,0),\"-\")","v":1500},{"$f":"IFERROR(VLOOKUP($G$11,'92107'!$A$12:$G$12,2,0),\"-\")","v":0},{"$f":"IFERROR(VLOOKUP($H$11,'92107'!$A$13:$G$13,2,0),\"-\")","v":0},{"$f":"IFERROR(VLOOKUP($I$11,'92107'!$A$14:$G$14,2,0),\"-\")","v":0},{"$f":"SUM(F12:I12)","v":1500},{"$f":"$C$8-E12+1","v":440},{"$f":"K12-M12","v":440},{"$f":"IFERROR(VLOOKUP($M$11,'92107'!$A$22:$G$22,2,0),\"-\")","v":0},{"$f":"IFERROR(VLOOKUP($N$11,'92107'!$A$26:$G$26,2,0),\"-\")","v":0},{"$f":"IF(L12<=365,Y12,AB12)","v":36.164383561643831},{"$f":"O12-N12","v":36.164383561643831},null,null,null,30,{"$f":"L12*(30/365)-N12","v":36.164383561643831},12,{"$f":"L12*(12/180)-N12","v":29.333333333333332},"less","He Don't Deserve Leave Salary",null,"desirve",{"$f":"IF(L12<365,W12,U12)","v":36.164383561643831}]
[2,91977,null,null,{"$f":"IFERROR(VLOOKUP($E$10,'91977'!$C$7:$G$7,4,0),\"-\")","v":"2017-02-05"},{"$f":"IFERROR(VLOOKUP($F$11,'91977'!$A$11:$G$11,2,0),\"-\")","v":700},{"$f":"IFERROR(VLOOKUP($G$11,'91977'!$A$12:$G$12,2,0),\"-\")","v":0},{"$f":"IFERROR(VLOOKUP($H$11,'91977'!$A$13:$G$13,2,0),\"-\")","v":0},{"$f":"IFERROR(VLOOKUP($I$11,'91977'!$A$14:$G$14,2,0),\"-\")","v":0},{"$f":"SUM(F13:I13)","v":700},{"$f":"$C$8-E13+1","v":912},{"$f":"K13-M13","v":912},{"$f":"IFERROR(VLOOKUP($M$11,'91977'!$A$22:$G$22,2,0),\"-\")","v":0},{"$f":"IFERROR(VLOOKUP($N$11,'91977'!$A$26:$G$26,2,0),\"-\")","v":0},{"$f":"IF(L13<=365,Y13,AB13)","v":74.958904109589042},{"$f":"O13-N13","v":74.958904109589042},null,null,null,30,{"$f":"L13*(30/365)-N13","v":74.958904109589042},12,{"$f":"L13*(12/180)-N13","v":60.8},"less","He Don't Deserve Leave Salary",null,"desirve",{"$f":"IF(L13<365,W13,U13)","v":74.958904109589042}]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,{"$f":"L14*(30/365)-N14","v":0},12,{"$f":"L14*(12/180)-N14","v":0},"less","He Don't Deserve Leave Salary",null,"desirve",{"$f":"IF(L14<365,W14,U14)","v":0}]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]

{"sheet":"91977","index":1,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[27,1,27,3],[27,6,27,7],[29,0,30,6],[40,0,40,1],[40,5,40,7],[41,0,41,1],[41,5,41,7],[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],[10,1,10,6],[11,1,11,6],[12,1,12,6],[13,1,13,6],[14,1,14,6],[0,0,0,6],[1,0,1,6],[4,0,4,6],[5,2,5,4],[5,5,5,6],[6,2,6,4],[6,5,6,6]]}
["شركة المجموعة المشتركة للمقاولات (ش.م.ك.م )"]
["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<=365,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":"92107","index":2,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[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],[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],[29,0,30,6],[40,0,40,1],[40,5,40,7],[41,0,41,1],[41,5,41,7]]}
["شركة المجموعة المشتركة للمقاولات (ش.م.ك.م )"]
["Combined Group Contracting Co. (K.S.C.C)"]
[]
[]
["LEAVE CALCULATION SHEET"]
["NAME:  ","MUHAMMAD SHABIR MUHAMMAD KHAN","Employee No.:",null,null,92107]
["DESIGNATION:          ","LABOUR","Joining Date:",null,null,"2018-05-23"]
[null,null,null,null,null,"    "]
["Salary Details "]
[]
["Basic ",1500]
["Accomodation",0]
["Bonus ",0]
["Food",0]
["Total Salary ",{"$f":"SUM(B11:G14)","v":1500}]
["Working Days "]
[]
[]
["From",{"$f":"F7","v":"2018-05-23"},null,null,"2019-08-13"]
[]
["Days",{"$f":"+E19-B19+1","v":448},null,null,null,null,null,null,null,null,null,30,{"$f":"B23*(30/365)-B26","v":36.821917808219176}]
["Leave Without Pay",0,null,null,null,null,null,null,null,null,null,12,{"$f":"B23*(12/180)-B26","v":29.866666666666667}]
["Net working days",{"$f":"B21-B22","v":448},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":36.821917808219176}]
["Leave Balance Calculation "]
["Previouse Paid Leave (days)",0,"Days"]
[]
["Desirve Leaves ( Days)",{"$f":"IF(B23<=182,M23,M24)","v":36.821917808219176},null,null,"Days",null,"New Leave Balance ",null,{"$f":"B28-B35","v":1.9178082191757539E-3},"Days"]
[]
["Payment"]
[]
[]
["Required Days From employees",66]
[]
["Paid Days",36.82]
["Unpaid days",{"$f":"B33-B35","v":29.18}]
[]
["Calculation ",{"$f":"B15*B35/30","v":1841},"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]