{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"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":"Sheet1","index":0,"n_rows":21,"n_cols":28,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["الرقم الوظيفي","الاسم","الهوية","الجنسية","الشركة","المهنة ","الراتب  الأساسي","بدل السكن","بدل النقل ","بدلات أخرى","الإجمالي ","مدة العقد","تاريخ بداية العقد","تاريخ انتهاء العقد","الاجازة السنوية ","إجازة مستحقة","30 يوم تنبية","الأيام المستخدمة","رصيد الاجازة","بدل الاجازة","نهاية الخدمة","التأمينات الاجتماعية ","التأمين الطبي ","رخصة العمل ","الجوازات ","تذاكر السفر ","الخروج والعودة ","الإجمالي"]
[null,null,null,"سعودي",null,null,null,null,null,null,null,1,"2023-12-20",{"$f":"DATE(YEAR(M2)+L2,MONTH(M2),DAY(M2)-1)","v":"2024-12-19"},{"$f":"IF(L2=1,21,30)","v":21},{"$f":"EarnedVac(M2,N2,O2)","v":12.567460139231979},{"$f":"DaysDiff(M2,N2)","v":""},null,null,null,null,"السعودي 9.75 من اجمالي الراتب ","zaqzzzzzzzzzAS"]
[null,null,null,"باقي الجنسيات",null,null,null,null,null,null,null,2,"2024-01-08",{"$f":"DATE(YEAR(M3)+L3,MONTH(M3),DAY(M3)-1)","v":"2026-01-07"},{"$f":"IF(L3=1,21,30)","v":30},{"$f":"EarnedVac(M3,N3,O3)","v":16.393442622950822},{"$f":"DaysDiff(M3,N3)","v":""},null,null,null,null,"الأجنبي 2% من اجمالي الراتب "]
[null,null,null,null,null,null,null,null,null,null,null,2,"2024-03-05",{"$f":"DATE(YEAR(M4)+L4,MONTH(M4),DAY(M4)-1)","v":"2026-03-04"},{"$f":"IF(L4=1,21,30)","v":30},11.721311475409836,""]
[null,null,null,null,null,null,null,null,null,null,null,2,"2024-04-14",{"$f":"DATE(YEAR(M5)+L5,MONTH(M5),DAY(M5)-1)","v":"2026-04-13"},{"$f":"IF(L5=1,21,30)","v":30},8.442622950819672,""]
[null,null,null,null,null,null,null,null,null,null,null,1,"2023-10-07",{"$f":"DATE(YEAR(M6)+L6,MONTH(M6),DAY(M6)-1)","v":"2024-10-06"},{"$f":"IF(L6=1,21,30)","v":21},16.824994385807322,""]
[null,null,null,null,null,null,null,null,null,null,null,1,"2022-01-24",{"$f":"DATE(YEAR(M7)+L7,MONTH(M7),DAY(M7)-1)","v":"2023-01-23"},{"$f":"IF(L7=1,21,30)","v":21},21,""]
[null,null,null,null,null,null,null,null,null,null,null,2,"2024-04-06",{"$f":"DATE(YEAR(M8)+L8,MONTH(M8),DAY(M8)-1)","v":"2026-04-05"},{"$f":"IF(L8=1,21,30)","v":30},9.0983606557377055,""]
[null,null,null,null,null,null,null,null,null,null,null,2,"2024-03-15",{"$f":"DATE(YEAR(M9)+L9,MONTH(M9),DAY(M9)-1)","v":"2026-03-14"},{"$f":"IF(L9=1,21,30)","v":30},10.901639344262296,"",null,null,null,null,"الإجازة المستحقة لتاريخ اليوم للعقد النشط"]
[null,null,null,null,null,null,null,null,null,null,null,2,"2024-09-21",{"$f":"DATE(YEAR(M10)+L10,MONTH(M10),DAY(M10)-1)","v":"2026-09-20"},{"$f":"IF(L10=1,21,30)","v":30},"عقد جديد","",null,null,null,null,"ولتاريخ انتهاء العقد للعقود المنتهية"]
[null,null,null,null,null,null,null,null,null,null,null,1,"2023-11-08",{"$f":"DATE(YEAR(M11)+L11,MONTH(M11),DAY(M11)-1)","v":"2024-11-07"},{"$f":"IF(L11=1,21,30)","v":21},14.983898495396362,""]
[null,null,null,null,null,null,null,null,null,null,null,1,"2023-08-07",{"$f":"DATE(YEAR(M12)+L12,MONTH(M12),DAY(M12)-1)","v":"2024-08-06"},{"$f":"IF(L12=1,21,30)","v":21},20.334583426903212,12]
[null,null,null,null,null,null,null,null,null,null,null,2,"2023-10-20",{"$f":"DATE(YEAR(M13)+L13,MONTH(M13),DAY(M13)-1)","v":"2025-10-19"},{"$f":"IF(L13=1,21,30)","v":30},22.967213114754099,""]
[null,null,null,null,null,null,null,null,null,null,null,2,"2024-03-26",{"$f":"DATE(YEAR(M14)+L14,MONTH(M14),DAY(M14)-1)","v":"2026-03-25"},{"$f":"IF(L14=1,21,30)","v":30},10,""]
[null,null,null,null,null,null,null,null,null,null,null,2,"2022-06-30",{"$f":"DATE(YEAR(M15)+L15,MONTH(M15),DAY(M15)-1)","v":"2024-06-29"},{"$f":"IF(L15=1,21,30)","v":30},60.041545025825286,-26]
[null,null,null,null,null,null,null,null,null,null,null,2,"2024-02-20",{"$f":"DATE(YEAR(M16)+L16,MONTH(M16),DAY(M16)-1)","v":"2026-02-19"},{"$f":"IF(L16=1,21,30)","v":30},12.868852459016393,""]
[null,null,null,null,null,null,null,null,null,null,null,2,"2023-10-04","2023-10-03",{"$f":"IF(L17=1,21,30)","v":30},"تواريخ خاطئة",""]
[null,null,null,null,null,null,null,null,null,null,null,2,"2024-03-12",{"$f":"DATE(YEAR(M18)+L18,MONTH(M18),DAY(M18)-1)","v":"2026-03-11"},{"$f":"IF(L18=1,21,30)","v":30},11.147540983606557,""]
[null,null,null,null,null,null,null,null,null,null,null,2,"2024-03-17",{"$f":"DATE(YEAR(M19)+L19,MONTH(M19),DAY(M19)-1)","v":"2026-03-16"},{"$f":"IF(L19=1,21,30)","v":30},10.737704918032787,""]
[null,null,null,null,null,null,null,null,null,null,null,2,"2023-12-18",{"$f":"DATE(YEAR(M20)+L20,MONTH(M20),DAY(M20)-1)","v":"2025-12-17"},{"$f":"IF(L20=1,21,30)","v":30},18.117898046260947,""]
[null,null,null,null,null,null,null,null,null,null,null,2,"2024-02-16",{"$f":"DATE(YEAR(M21)+L21,MONTH(M21),DAY(M21)-1)","v":"2026-02-15"},{"$f":"IF(L21=1,21,30)","v":30},13.196721311475409,""]