{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["BASE","شهادة تربص","شهادة تكوين","كشف النقاط","Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":7,"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":"BASE","index":0,"n_rows":31,"n_cols":16,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["رقم التسجيل","الاســـــم","اللقب","تاريخ الميلاد","مكان الميلاد","الاختصاص","نمط التكوين","مستوى التكوين","مدة التكوين","بداية التكوين","نهاية التكوين","تاريخ الفصل","السداسي الاول","السداسي الثاني","السداسي الثالث","السداسي الرابع"]
[1,"رياض","علي ","1913-09-08","مدير","ماجستير","تمهين",2,"12شهرا","2018-03-10","1900-04-09","1900-01-01",14.5,14.5,"//","//"]
[2,"محمود "," سالم","1916-06-04","معاون","بكالوريوس","حضوري",3,"18شهرا","2018-03-11","1900-04-09","1900-01-02",11.3,11.3,11.3,"//"]
[3,"سميرة  ","مؤيد","1916-06-04","موظف","معهد","تاهيلي",4,"24شهرا","2018-03-12","1900-02-19","1900-01-03",11.4,11.4,11.4,11.4]
[4,"سالم ","مجيد  ","1916-06-04","كاتب","معهد","تمهين",1,"12شهرا","2018-03-13","1900-05-29","1900-01-04",12.6,12.6,"//","//"]
[5,"رضا","قويدري","1916-06-04","عامل","اعدادية","تمهين",2,"12شهرا","2018-03-14","1900-05-29","1900-01-01",12.7,10.7,"//","//"]
[6,"خليل ","عويسي","1916-06-04","موظف","معهد","حضوري",3,"18شهرا","2018-03-15","1900-05-29","1900-01-02",11.4,10.7,10.3,"//"]
[7,"سارة ","نقاز","1916-06-04","كاتب","معهد","دروس مسائية",4,"24شهرا","2018-03-16","1900-05-29","1900-01-03",11.3,10.3,12.5,10.3]
[8," ناصر","رنان","1924-08-21","عامل","اعدادية","حضوري",2,"12شهرا","2019-02-02","1900-04-09","1900-01-04",10.3,11.5,"//","//"]
[9,"أحمد","الدين","1921-11-25","موظف","معهد","حضوري",3,"18شهرا","2019-02-03","1900-04-09","1900-01-01",10.5,13.4,10.3,"//"]
[10,"أحمد ","بوزيدي","1913-09-08","كاتب","معهد","دروس مسائية",4,"24شهرا","2019-02-04","1900-02-19","1900-01-02",12.5,12.5,11.3,11.3]
[11,"رضا ","يحياوي","1910-12-13","عامل","اعدادية","تمهين",1,"12شهرا","2019-02-05","1900-05-29","1900-01-03",11.3,11.3,"//","//"]
[12,"محمد","ستالة ","1916-06-04","موظف","معهد","حضوري",2,"12شهرا","2019-02-06","1900-05-29","1900-01-04",10.3,10.3,"//","//"]
[13,"عباس","دوة","1924-08-21","كاتب","معهد","دروس مسائية",3,"18شهرا","2019-02-07","1900-05-29","1900-01-01",10.5,10.5,10.5,"//"]
[14,"جلول","حمية","1921-11-25","عامل","اعدادية","دروس مسائية",4,"24شهرا","2019-02-08","1900-05-29","1900-01-02",12.5,12.5,12.5,11.3]
[15,"الطاهر","نقاز","1913-09-08","موظف","معهد","حضوري",2,"12شهرا","2019-02-09","1900-04-09","1900-01-03",11.3,11.3,"//","//"]
[16,"قويدر","رنان","1910-12-13","كاتب","معهد","تمهين",3,"18شهرا","2019-02-10","1900-04-09","1900-01-04",10.3,10.3,10.3,"//"]
[17,"حميد","الدين","1916-06-04","عامل","اعدادية","دروس مسائية",4,"24شهرا","2015-07-13","1900-02-19","1900-01-01",10.7,10.7,10.3,10.7]
[18,"ضاوية","بوزيدي","1924-08-21","موظف","معهد","تمهين",1,"12شهرا","2019-02-07","1900-05-29","1900-01-02",10.5,14.5,"//","//"]
[19,"حورية","عويسي","1921-11-25","كاتب","معهد","حضوري",2,"12شهرا","2019-02-08","1900-05-29","1900-01-03",12.5,11.3,"//","//"]
[20,"نصيرة","نقاز","1913-09-08","عامل","اعدادية","دروس مسائية",3,"18شهرا","2019-02-09","1900-05-29","1900-01-04",11.3,11.4,11.3,"//"]
[21,"عيسى","رنان","1910-12-13","موظف","معهد","دروس مسائية",4,"24شهرا","2019-02-10","1900-05-29","1900-01-01",10.3,12.6,10.3,12.5]
[22,"معمر","الدين","1916-06-04","كاتب","معهد","تاهيلي",2,"12شهرا","2015-07-13","1900-04-09","1900-01-02",11.5,12.7,"//","//"]
[23,"رضا","بوزيدي","1924-08-21","عامل","اعدادية","دروس مسائية",3,"18شهرا","1901-03-15","1900-04-09","1900-01-03",13.4,11.4,13.4,"//"]
[24,"اسلام","يحياوي","1921-11-25","موظف","معهد","دروس مسائية",4,"24شهرا","1901-03-16","1900-02-19","1900-01-04",14.5,11.3,12.5,12.5]
[25,"كمال","لخذاري","1913-09-08","كاتب","معهد","تمهين",1,7729894,"1901-03-17","1900-05-29","1900-01-01",11.3,10.3,"//","//"]
[26,"أمين ","دهينة","1910-12-13","عامل","اعدادية","تمهين",2,"12شهرا","1901-03-18","1900-05-29","1900-01-02",11.4,10.5,"//","//"]
[27,"إبراهيم ","عويسي","1916-06-04","موظف","معهد","اعزب",3,"18شهرا","1901-03-19","1900-05-29","1900-01-03",12.6,12.5,11.5,"//"]
[28,"إبراهيم ","طيفوري","1924-08-21","كاتب","معهد","دروس مسائية",4,"24شهرا","1901-03-20","1900-05-29","1900-01-04",12.7,11.3,13.4,11.3]
[29," خالد","حمية","1924-08-22","عامل","اعدادية","حضوري",2,"12شهرا","1901-03-21","1900-04-09","1900-01-01",11.4,10.3]
[33,"حورية","سالمي","25/11/1921","استاذة","معهد","حضوري",2,"12شهرا","2019-08-02","29/05/1900","31/01/1900","12,5","11,3","//","//"]

{"sheet":"شهادة تربص","index":1,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[18,6,18,8],[18,10,18,11],[26,0,27,4],[10,0,10,11],[16,3,16,8],[18,2,18,4],[17,2,17,3],[26,9,27,10],[6,0,6,5],[2,0,2,11],[1,0,1,11],[15,0,15,2],[14,1,14,3],[15,3,15,6],[15,7,15,9],[5,0,5,5],[7,0,7,5],[8,2,8,4],[14,7,14,9],[13,7,13,9]]}
[]
["الجمهورية الجزائرية الديمقراطية الشعبية"]
[" وزارة التكوين والتعليم المهنيين"]
[]
[" مديرية التكوين المهني والتعليم المهنيين                      ",null,null,null,null,null," ولاية الأغواط"]
["مركز التكوين المهني والتمهين"]
["تاجموت"]
["          "]
["الرقــــم : ","/",2021]
[]
["شهـــادة تــربص"]
[]
["إن مـــــديـــــــر المــــؤسســــة"]
[" يشهد بأن المتربص (ة) المسجل تحت رقم :  "]
[" الإســم :",null,null,null,"اللقـــــب:"]
["تاريخ ومكان الميــــلاد : "]
[" تابع تكوينا في اختصاص:"]
["مستوى التأهيـــــل : "]
["السنة التكوينية:",null,"2020/2021",null,null,"من: ","2020-12-20",null,null,"الى : ","2020-12-20"]
["   "]
[]
["المساعد التقني البيداغوجي",null,null,null,null,null,null,"المديـــر"]
[]
[]
[]
[]
["المساعد التقني البيداغوجي",null,null,null,null,null,null,null,null,"المدير"]

{"sheet":"شهادة تكوين","index":2,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[[17,2,17,6],[18,4,18,5],[19,1,19,3],[19,6,19,7],[16,4,16,5],[1,0,1,8],[2,0,2,8],[11,0,11,8],[14,1,14,3],[15,1,15,3],[7,0,7,5],[14,5,14,7],[5,0,5,2],[8,3,8,4],[6,0,6,1]]}
[]
["الجمهورية الجزائرية الديمقراطية الشعبية"]
[" وزارة التكوين والتعليم المهنيين"]
[]
[{"$f":"'شهادة تربص'!A5:I5","v":" مديرية التكوين المهني والتعليم المهنيين                      "}]
[{"$f":"'شهادة تربص'!A6:F6","v":"مركز التكوين المهني والتمهين"}]
[{"$f":"'شهادة تربص'!A7:F7","v":"تاجموت"}]
[]
["الرقم:                  /"]
[]
[]
["شهـــادة تـكوين"]
[]
[" نحن مـديـــر مركز التكوين المهني والتمهين بتاجموت"]
[" نشهد أن السيد (ة) :  ",null,null,null,"اللقـــــب:"]
[" المسجل تحت رقم: "]
["تاريخ ومكان الميلاد : "]
[" تابع تكوينا في اختصاص :"]
["مستوى التأهيــــل : ",null,"نمط التكوين:"]
[" تاريخ بداية التكوين:",null,null,null,"تاريخ الفصل:"]
["المساعد التقني البيداغوجي",null,null,null,null,null,null,"المديـــر"]

{"sheet":"كشف النقاط","index":3,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[26,6,26,8],[28,8,28,13],[23,1,23,7],[23,8,23,12],[25,0,25,3],[25,4,25,6],[25,7,25,8],[25,9,25,12],[22,1,22,7],[22,8,22,12],[17,1,17,7],[17,8,17,12],[18,1,18,7],[18,8,18,12],[19,1,19,7],[19,8,19,12],[20,1,20,7],[20,8,20,12],[21,1,21,7],[21,8,21,12],[14,2,14,3],[14,4,14,6],[14,7,14,9],[14,12,14,14],[15,0,15,1],[15,2,15,4],[15,12,15,14],[13,9,13,12],[12,6,12,7],[12,3,12,5],[12,11,12,13],[13,1,13,4],[13,6,13,7],[1,0,1,16],[2,0,2,16],[6,0,6,4],[10,1,10,3],[11,1,11,3],[11,5,11,8],[5,0,5,6],[4,0,4,6],[7,2,7,3],[8,0,9,16]]}
[]
["الجمهوريـة الجزائريـة الديمقراطيـة الشعبيـة"]
[" وزارة التكوين والتعليم المهنيين"]
[]
[]
[{"$f":"'شهادة تربص'!A6:F6","v":"مركز التكوين المهني والتمهين"}]
[{"$f":"'شهادة تربص'!A7:F7","v":"تاجموت"}]
["الرقــــــم:","      /",{"$f":"'شهادة تربص'!C9:E9","v":2021}]
["كشف النقاط مسار التكوين"]
[]
["اللقب: ","شتوح"]
["الاسم :",null,null,null,"اللقب:"]
[" تاريخ ومكان الميلاد:",null,null,null,null,null,null,null,"رقم التسجيل:"]
["الاختصاص:",null,null,null,null,"من: ",null,null,"إلــــى: "]
["مدة التكويـــــن:",null,null,null,"مستـوى التأهيل: "]
["السنة التكوينيـة:",null,{"$f":"'شهادة تربص'!C19:E19","v":"2020/2021"}]
[]
[null,"السداسي",null,null,null,null,null,null,"المعدل"]
[null,"السداسي الأول",null,null,null,null,null,null,{"$f":"VLOOKUP($I$13,BASE!A1:$P$1000,13,0)","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(H15>=2,\"السداسي الثاني\",\"المجموع العام\")","v":"المجموع العام"},null,null,null,null,null,null,{"$f":"IF(H15>=2,VLOOKUP($I$13,BASE!A1:$P$10000,14,0),I19)","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(H15=1,\"المعدل العام\",IF(H15=2,\"المجموع العام\",\"السداسي الثالث\"))","v":"السداسي الثالث"},null,null,null,null,null,null,{"$f":"IF(H15=1,I20/1,IF(H15=2,I19+I20,VLOOKUP($I$13,BASE!A1:$P$10000,15,0)))","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(H15=1,\"\",IF(H15=2,\"المعدل العام\",IF(H15=3,\"المجموع العام\",\"السداسي الرابع\")))","v":"السداسي الرابع"},null,null,null,null,null,null,{"$f":"IF(H15=1,\"\",IF(H15=2,I21/2,IF(H15=3,I19+I20+I21,VLOOKUP($I$13,BASE!A1:$P$10000,16,0))))","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(H15=1,\"\",IF(H15=2,\"\",IF(H15=3,\"المعدل العام\",\"المجموع العام\")))","v":"المجموع العام"},null,null,null,null,null,null,{"$f":"IF(H15=1,\"\",IF(H15=2,\"\",IF(H15=3,I22/3,I19+I20+I21+I22)))","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(H15=1,\"\",IF(H15=2,\"\",IF(H15=3,\"\",\"المعدل العام\")))","v":"المعدل العام"},null,null,null,null,null,null,{"$f":"IF(H15=1,\"\",IF(H15=2,\"\",IF(H15=3,\"\",I23/4)))","v":{"$error":"#N/A"}}]
[]
["  ملاحظات النهائية للجنة المداولات :",null,null,null,{"$f":"IF(I24>=10,\"ناجح\",\"راسب\")","v":{"$error":"#N/A"}},null,null,"بتقديــــــــــــــــر:",null,{"$f":"IF(I24>=16,\"جيد جدا\",IF(I24>=14,\"جيد\",IF(I24>=12,\"حسن\",IF(I24<12,\"//\"))))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"حرر بتاجموت  : "]
[]
[null,null,null,null,null,null,null,null,"إمضاء وختم مدير المؤسسة"]
[]
[]
["ملاحظة : لا تسلم إلا نسخة واحدة من هذا الكشف"]

{"sheet":"Feuil1","index":4,"n_rows":51,"n_cols":4,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null," ولاية أدرار"]
[null,null,null," ولاية الشلف"]
[null,null,null," ولاية الأغواط"]
[null,null,null," ولاية أم البواقي"]
[null,null,null," ولاية باتنة"]
[null,null,null," ولاية بجاية"]
[null,null,null," ولاية بسكرة"]
[null,null,null," ولاية بشار"]
[null,null,null," ولاية البليدة"]
[null,null,null," ولاية البويرة"]
[null,null,null," ولاية تمنراست"]
[null,null,null," ولاية تبسة"]
[null,null,null," ولاية تلمسان"]
[null,null,null," ولاية تيارت"]
[null,null,null," ولاية تيزي وزو"]
[null,null,null," ولاية الجزائر"]
[null,null,null," ولاية الجلفة"]
[null,null,null," ولاية جيجل"]
[null,null,null," ولاية سطيف"]
[null,null,null," ولاية سعيدة"]
[null,null,null," ولاية سكيكدة"]
[null,null,null," ولاية سيدي بلعباس"]
[null,null,null," ولاية عنابة"]
[null,null,null,"ولاية قالمة"]
[null,null,null," ولاية قسنطينة"]
[null,null,null," ولاية المدية"]
[null,null,null," ولاية مستغانم"]
[null,null,null," ولاية المسيلة"]
[null,null,null," ولاية معسكر"]
[null,null,null," ولاية ورقلة"]
[null,null,null," ولاية وهران"]
[null,null,null," ولاية البيض"]
[null,null,null," ولاية إليزي"]
[null,null,null," ولاية برج بوعريريج"]
[null,null,null," ولاية بومرداس"]
[null,null,null," ولاية الطارف"]
[null,null,null," ولاية تندوف"]
[null,null,null," ولاية تيسمسيلت"]
[null,null,null," ولاية الوادي"]
[null,null,null,"ولاية خنشلة"]
[null,null,null," ولاية سوق أهراس"]
[null,null,null," ولاية تيبازة"]
[null,null,null," ولاية ميلة"]
[null,null,null," ولاية عين الدفلى"]
[null,null,null," ولاية النعامة"]
[null,null,null,"ولاية عين تموشنت"]
[null,null,null," ولاية غرداية"]
[null,null,null," ولاية غليزان"]