{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil1","Feuil4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"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":"Feuil1","index":0,"n_rows":78,"n_cols":36,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
["رقم التأجير","الاسم بالعربية","الاسم بالفرنسية","النوع","تاريخ الازدياد","رقم ب ت و","تاريخ التوظيف","الاطار","نوع الاطار","الدرجة","تاريخها","الرتبة","تاريخها","المهمة","مؤسسة التعيين","تاريخ التعيين بالمؤسسة","تاريخ التعين بالمديرية","المستوى المسند","مادة التكوين","مادة التدريس","نقط الاستحقاق","العنوان","رقم الهاتف","التوقيع",null,null,null,null,null,null,null,null,null,null,null,"رت"]
["CODE1","NOM1","NOM FR 1","M","1972-06-12","B12345","16/09/1994","CAT1","CAD1",1,"18/07/2012",10,"18/07/2012",1,"ET1","2019-09-04","2019-09-04",1,"A ","A ",{"$f":"IF(OR(G2=\"\",P2=\"\",Q2=\"\"),\"\", (YEAR(TODAY()) - YEAR(G2)) + ((YEAR(TODAY()) - YEAR(P2)) * 2) + (YEAR(TODAY()) - YEAR(Q2)))","v":41},null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["CODE2","NOM2","NOM FR 2","M","1972-06-12","B12346","16/09/1994","CAT1","CAD1",1,"18/07/2012",12,"18/07/2012",1,"ET2","2019-09-05","2019-09-05",2,"F","F",{"$f":"IF(OR(G3=\"\",P3=\"\",Q3=\"\"),\"\", (YEAR(TODAY()) - YEAR(G3)) + ((YEAR(TODAY()) - YEAR(P3)) * 2) + (YEAR(TODAY()) - YEAR(Q3)))","v":41},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A3=\"\",\"\",AJ2+1)","v":2}]
["CODE3","NOM3","NOM FR 3","M","1972-06-12","B12347","16/09/1994","CAT1","CAD1",1,"18/07/2012",12,"18/07/2012",1,"ET3","2019-09-06","2019-09-06",4,"F","F",41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
["CODE4","NOM4","NOM FR 4","F","1972-06-12","B12348","16/09/1994","CAT1","CAD1",1,"18/07/2012",9,"18/07/2012",1,"ET4","2019-09-07","2019-09-07",5.3333333333333304,"A ","A ",41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
["CODE5","NOM5","NOM FR 5","F","1972-06-12","B12349","16/09/1994","CAT1","CAD1",1,"18/07/2012",8,"18/07/2012",1,"ET5","2019-09-08","2019-09-08",6.8333333333333304,"F","F",41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["CODE6","NOM6","NOM FR 6","M","1972-06-12","B12350","16/09/1994","CAT1","CAD1",1,"18/07/2012",8,"18/07/2012",1,"ET6","2019-09-09","2019-09-09",8.3333333333333304,"F","F",41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
["CODE7","NOM7","NOM FR 7","M","1972-06-12","B12351","16/09/1994","CAT1","CAD1",1,"18/07/2012",9,"18/07/2012",1,"ET7","2019-09-10","2019-09-10",9.8333333333333304,"A ","A ",41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
["CODE8","NOM8","NOM FR 8","M","1972-06-12","B12352","16/09/1994","CAT2","CAD1",1,"18/07/2012",8,"18/07/2012",1,"ET8","2019-09-11","2019-09-11",11.3333333333333,"F","F",41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
["CODE9","NOM9","NOM FR 9","M","1972-06-12","B12353","16/09/1994","CAT2","CAD1",1,"18/07/2012",7,"18/07/2012",1,"ET9","2019-09-12","2019-09-12",12.8333333333333,"F","F",41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
["CODE10","NOM10","NOM FR 10","M","1972-06-12","B12354","16/09/1994","CAT2","CAD1",1,"18/07/2012",7,"18/07/2012",1,"ET10","2019-09-13","2019-09-13",14.3333333333333,"A ","A ",41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["CODE11","NOM11","NOM FR 11","F","1972-06-12","B12355","16/09/1994","CAT2","CAD1",1,"18/07/2012",8,"18/07/2012",1,"ET11","2019-09-14","2019-09-14",15.8333333333333,"F","F",41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
["CODE12","NOM12","NOM FR 12","F","1972-06-12","B12356","16/09/1994","CAT2","CAD1",1,"18/07/2012",6,"18/07/2012",1,"ET12","2019-09-15","2019-09-15",17.3333333333333,"F","F",41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
["CODE13","NOM13","NOM FR 13","M","1972-06-12","B12357","16/09/1994","CAT2","CAD1",1,"18/07/2012",5,"18/07/2012",1,"ET13","2019-09-16","2019-09-16",18.8333333333333,"A ","A ",41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
["CODE14","NOM14","NOM FR 14","F","1972-06-12","B12358","16/09/1994","CAT2","CAD1",2,"18/07/2012",4,"18/07/2012",1,"ET14","2019-09-17","2019-09-17",20.3333333333333,"F","F",41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
["CODE15","NOM15","NOM FR 15","F","1972-06-12","B12359","16/09/1994","CAT2","CAD2",2,"18/07/2012",1,"18/07/2012",1,"ET15","2019-09-18","2019-09-18",21.8333333333333,"F","F",41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
["CODE16","NOM16","NOM FR 16","F","1972-06-12","B12360","16/09/1994","CAT2","CAD2",2,"18/07/2012",1,"2017-06-09",1,"ET16","2019-09-19","2019-09-19",23.3333333333333,"A ","A ",41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
["CODE17","NOM17","NOM FR 17","F","1972-06-12","B12361","16/09/1994","CAT2","CAD2",2,"18/07/2012",1,"2017-06-09",1,"ET17","2019-09-20","2019-09-20",24.8333333333333,"F","F",41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
["CODE18","NOM18","NOM FR 18","F","1972-06-12","B12362","16/09/1994","CAT2","CAD2",2,"18/07/2012",1,"2018-04-09",1,"ET18","2019-09-21","2019-09-21",26.3333333333333,"F","F",41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
["CODE19","NOM19","NOM FR 19","F","1972-06-12","B12363","16/09/1994","CAT2","CAD2",2,"2018-04-09",1,"2018-04-09",1,"ET19","2019-09-22","2019-09-22",27.8333333333333,"A ","A ",41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
["CODE20","NOM20","NOM FR 20","F","1972-06-12","B12364","16/09/1994","CAT2","CAD2",2,"2018-04-09",1,"2018-04-09",1,"ET20","2019-09-23","2019-09-23",29.3333333333333,"F","F",41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
["CODE21","NOM21","NOM FR 21","F","1972-06-12","B12365","16/09/1994","CAT2","CAD2",2,"2018-04-09",1,"2018-04-09",1,"ET21","2019-09-24","2019-09-24",30.8333333333333,"F","F",41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
["CODE22","NOM22","NOM FR 22","F","1972-06-12","B12366","16/09/1994","CAT2","CAD2",2,"2019-04-09",1,"2019-04-09",1,"ET22","2019-09-25","2019-09-25",32.3333333333333,"A ","A ",41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
["CODE23","NOM23","NOM FR 23","F","1972-06-12","B12367","16/09/1994","CAT2","CAD2",2,"2022-02-09",1,"2022-02-09",1,"ET23","2019-09-26","2019-09-26",33.8333333333333,"F","F",41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G25=\"\",P25=\"\",Q25=\"\"),\"\", (YEAR(TODAY()) - YEAR(G25)) + ((YEAR(TODAY()) - YEAR(P25)) * 2) + (YEAR(TODAY()) - YEAR(Q25)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G26=\"\",P26=\"\",Q26=\"\"),\"\", (YEAR(TODAY()) - YEAR(G26)) + ((YEAR(TODAY()) - YEAR(P26)) * 2) + (YEAR(TODAY()) - YEAR(Q26)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A35=\"\",\"\",AJ34+1)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A67=\"\",\"\",AJ66+1)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Feuil4","index":1,"n_rows":49,"n_cols":12,"rows_kept":49,"cut":false,"hidden":false,"merged":[[2,2,2,6]]}
[]
[null,null,null,null,null,null,null,null,null,null,"رت",4]
[null,null,"بطاقة المعلومات"]
[]
[null,null,"رقم التأجير",{"$f":"_xlfn.XLOOKUP($L$2,Feuil1!AJ:AJ,Feuil1!A:A)","v":"CODE4"},null,null,null,null,null,null,"Max",{"$f":"MAX(Feuil1!AJ:AJ)","v":23}]
[]
[null,null,"رقم  ب ت و",{"$f":"_xlfn.XLOOKUP($L$2,Feuil1!AJ:AJ,Feuil1!F:F)","v":"B12348"}]
[]
[null,null,"الاسم والنسب",{"$f":"_xlfn.XLOOKUP($L$2,Feuil1!AJ:AJ,Feuil1!B:B)","v":"NOM4"}]
[]
[null,null,"الاسم بالفرنسية",{"$f":"_xlfn.XLOOKUP($L$2,Feuil1!AJ:AJ,Feuil1!C:C)","v":"NOM FR 4"}]
[]
[null,null,"النوع",{"$f":"_xlfn.XLOOKUP($L$2,Feuil1!AJ:AJ,Feuil1!D:D)","v":"F"}]
[]
[null,null,"تاريخ الازدياد",{"$f":"_xlfn.XLOOKUP($L$2,Feuil1!AJ:AJ,Feuil1!E:E)","v":"1972-06-12"},null,"تاريخ التوظيف",{"$f":"_xlfn.XLOOKUP($L$2,Feuil1!AJ:AJ,Feuil1!G:G)","v":"16/09/1994"}]
[]
[null,null,"الاطار",{"$f":"_xlfn.XLOOKUP($L$2,Feuil1!AJ:AJ,Feuil1!H:H)","v":"CAT1"},null,"نوع الاطار",{"$f":"_xlfn.XLOOKUP($L$2,Feuil1!AJ:AJ,Feuil1!I:I)","v":"CAD1"}]
[]
[null,null,"الدرجة",{"$f":"_xlfn.XLOOKUP($L$2,Feuil1!AJ:AJ,Feuil1!J:J)","v":1},null,"تاريخها",{"$f":"_xlfn.XLOOKUP($L$2,Feuil1!AJ:AJ,Feuil1!K:K)","v":"18/07/2012"}]
[]
[null,null,"الرتبة",{"$f":"_xlfn.XLOOKUP($L$2,Feuil1!AJ:AJ,Feuil1!L:L)","v":9},null,"تاريخها",{"$f":"_xlfn.XLOOKUP($L$2,Feuil1!AJ:AJ,Feuil1!M:M)","v":"18/07/2012"}]
[]
[null,null,"المهمة",{"$f":"_xlfn.XLOOKUP($L$2,Feuil1!AJ:AJ,Feuil1!N:N)","v":1},null,"مؤسسة التعيين",{"$f":"_xlfn.XLOOKUP($L$2,Feuil1!AJ:AJ,Feuil1!O:O)","v":"ET4"}]
[]
[null,null,"تا.التعيين بالمؤسسة",{"$f":"_xlfn.XLOOKUP($L$2,Feuil1!AJ:AJ,Feuil1!P:P)","v":"2019-09-07"},null,"تا.التعيين بالمديرية",{"$f":"_xlfn.XLOOKUP($L$2,Feuil1!AJ:AJ,Feuil1!Q:Q)","v":"2019-09-07"}]
[]
[null,null,"مج.نقط الاستحقاق",{"$f":"_xlfn.XLOOKUP($L$2,Feuil1!AJ:AJ,Feuil1!U:U)","v":41},null,"المستوى المدرس",{"$f":"_xlfn.XLOOKUP($L$2,Feuil1!AJ:AJ,Feuil1!R:R)","v":5.3333333333333304}]
[]
[null,null,"لغة التكوين",{"$f":"_xlfn.XLOOKUP($L$2,Feuil1!AJ:AJ,Feuil1!S:S)","v":"A "},null,"لغة التدريس",{"$f":"_xlfn.XLOOKUP($L$2,Feuil1!AJ:AJ,Feuil1!T:T)","v":"A "}]
[]
[null,null,"آخر شهادة",null,null,"تاريخها"]
[]
[null,null,"آخر دبلوم",null,null,"تاريخه"]
[]
[null,null,"نقطة التفتيش",null,null,"تاريخها"]
[]
[null,null,"العنوان",{"$f":"_xlfn.XLOOKUP($L$2,Feuil1!AJ:AJ,Feuil1!V:V)","v":0},null,"الهاتف",{"$f":"_xlfn.XLOOKUP($L$2,Feuil1!AJ:AJ,Feuil1!W:W)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["A"]