{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data","التصاريح"],"not_rendered":{"charts":0,"images":0,"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":"Data","index":0,"n_rows":167,"n_cols":15,"rows_kept":167,"cut":false,"hidden":false,"merged":[[0,10,1,10],[0,6,0,8],[0,1,1,1],[0,0,1,0],[0,2,1,2],[0,9,1,9],[0,3,0,5]]}
["رقم الملف","الاســــــم","المهنة","إعتيادى",null,null,"التصاريح الشخصية",null,null,"رصيد الاجازة الافتتاحى","نوع الإجازة"]
[null,null,null,"الرصيد","المنصرف","المتبقى","الرصيد","المنصرف","المتبقى",null,null,null,null,"عدد التصاريح الشخصية","الخصم"]
[101,"موظف 1","مهنة 1",21,null,{"$f":"D3-E3","v":21},null,{"$f":"SUMIFS(التصاريح!E:E,التصاريح!B:B,B3,التصاريح!D:D,\"تصريح شخصى\")","v":4},{"$f":"G3-H3","v":-4},null,"إعتيادي",null,null,1,0.25]
[102,"موظف 2","مهنة 2",21,null,21,null,{"$f":"SUMIFS(التصاريح!E:E,التصاريح!B:B,B4,التصاريح!D:D,\"تصريح شخصى\")","v":1},{"$f":"G4-H4","v":-1},null,"عارضة",null,null,2,0.5]
[103,"موظف 3","مهنة 3",21,null,21,null,{"$f":"SUMIFS(التصاريح!E:E,التصاريح!B:B,B5,التصاريح!D:D,\"تصريح شخصى\")","v":0},0,null,"بدل راحة",null,null,3,0.75]
[104,"موظف 4","مهنة 4",21,null,21,null,{"$f":"SUMIFS(التصاريح!E:E,التصاريح!B:B,B6,التصاريح!D:D,\"تصريح شخصى\")","v":0},0,null,"أجازة إستثنائية",null,null,4,1]
[105,"موظف 5","مهنة 5",21,null,21,null,{"$f":"SUMIFS(التصاريح!E:E,التصاريح!B:B,B7,التصاريح!D:D,\"تصريح شخصى\")","v":0},0,null,"مرضى",null,null,5,1.25]
[106,"موظف 6","مهنة 6",21,null,21,null,{"$f":"SUMIFS(التصاريح!E:E,التصاريح!B:B,B8,التصاريح!D:D,\"تصريح شخصى\")","v":0},0,null,"تصريح شخصى",null,null,6,1.5]
[107,"موظف 7","مهنة 7",21,null,21,null,{"$f":"SUMIFS(التصاريح!E:E,التصاريح!B:B,B9,التصاريح!D:D,\"تصريح شخصى\")","v":0},0,null,null,null,null,7,1.75]
[108,"موظف 8","مهنة 8",21,null,21,null,{"$f":"SUMIFS(التصاريح!E:E,التصاريح!B:B,B10,التصاريح!D:D,\"تصريح شخصى\")","v":0},0,null,null,null,null,8,2]
[109,"موظف 9","مهنة 9",21,null,21,null,{"$f":"SUMIFS(التصاريح!E:E,التصاريح!B:B,B11,التصاريح!D:D,\"تصريح شخصى\")","v":0},0,null,null,null,null,9,2.25]
[110,"موظف 10","مهنة 10",21,null,21,null,{"$f":"SUMIFS(التصاريح!E:E,التصاريح!B:B,B12,التصاريح!D:D,\"تصريح شخصى\")","v":0},0,null,null,null,null,10,2.5]
[111,"موظف 11","مهنة 11",21,null,21,null,{"$f":"SUMIFS(التصاريح!E:E,التصاريح!B:B,B13,التصاريح!D:D,\"تصريح شخصى\")","v":0},0,null,null,null,null,11,2.75]
[112,"موظف 12","مهنة 12",21,null,21,null,{"$f":"SUMIFS(التصاريح!E:E,التصاريح!B:B,B14,التصاريح!D:D,\"تصريح شخصى\")","v":0},0,null,null,null,null,12,3]
[113,"موظف 13","مهنة 13",21,null,21,null,{"$f":"SUMIFS(التصاريح!E:E,التصاريح!B:B,B15,التصاريح!D:D,\"تصريح شخصى\")","v":0},0,null,null,null,null,13,3.25]
[null,null,null,null,null,0,null,null,0,null,null,null,null,14,3.5]
[null,null,null,null,null,0,null,null,0,null,null,null,null,15,3.75]
[null,null,null,null,null,0,null,null,0,null,null,null,null,16,4]
[null,null,null,null,null,0,null,null,0,null,null,null,null,17,4.25]
[null,null,null,null,null,0,null,null,0,null,null,null,null,18,4.5]
[null,null,null,null,null,0,null,null,0,null,null,null,null,19,4.75]
[null,null,null,null,null,0,null,null,0,null,null,null,null,20,5]
[null,null,null,null,null,0,null,null,0,null,null,null,null,21,5.25]
[null,null,null,null,null,0,null,null,0,null,null,null,null,22,5.5]
[null,null,null,null,null,0,null,null,0,null,null,null,null,23,5.75]
[null,null,null,null,null,0,null,null,0,null,null,null,null,24,6]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,{"$f":"D35-E35","v":0},null,null,{"$f":"G35-H35","v":0}]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,{"$f":"D67-E67","v":0},null,null,{"$f":"G67-H67","v":0}]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,{"$f":"D99-E99","v":0},null,null,{"$f":"G99-H99","v":0}]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,{"$f":"D131-E131","v":0},null,null,{"$f":"G131-H131","v":0}]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,{"$f":"D163-E163","v":0},null,null,{"$f":"G163-H163","v":0}]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]

{"sheet":"التصاريح","index":1,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["م","الاســــــــــــــم","الملف","نوع التصريح","المستنفذ","تاريخ التصريح","ملاحظـــــــــات",null,"تصريح شخصى","√"]
[{"$f":"IF(ISNUMBER(C2),ROW($A1),\"\")","v":1},{"$f":"IF(OR(C2=\"\"),\"\",VLOOKUP(C2,EAF_DATA,2,0))","v":"موظف 1"},101,"تصريح شخصى",1,"2021-12-31","تصريح 1"]
[{"$f":"IF(ISNUMBER(C3),ROW($A2),\"\")","v":2},"موظف 1",101,"تصريح شخصى",1,"2021-12-29","تصريح 2"]
[{"$f":"IF(ISNUMBER(C4),ROW($A3),\"\")","v":3},"موظف 1",101,"تصريح شخصى",1,"2022-01-01","تصريح 3"]
[4,"موظف 1",101,"تصريح شخصى",1,"2022-01-04","تصريح 4"]
[5,"موظف 2",102,"تصريح شخصى",1,"2022-01-08","تصريح 1"]
["",""]
["",""]
[{"$f":"IF(ISNUMBER(C9),ROW($A8),\"\")","v":""},{"$f":"IF(OR(C9=\"\"),\"\",VLOOKUP(C9,EAF_DATA,2,0))","v":""}]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]