{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ورقة1","شهادة تربص","شهادة تكوين","كشف النقاط"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":14,"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":"ورقة1","index":0,"n_rows":1004,"n_cols":16,"rows_kept":1004,"cut":false,"hidden":false,"merged":[]}
["الرقم التسجيل","الاســـــــــــــــم","اللقب","تاريخ الميلاد","مكان الميلاد","الاختصاص","نمط التكوين","مستوى التكوين","مدة التكوين","بداية التكوين","نهاية التكوين","تاريخ الفصل","السداسي الاول","السداسي الثاني","السداسي الثالث","السداسي الرابع"]
["A/12/02/251","سناء امين","سلام","2018-02-12","عامل","اعدادية","اقامي",2,12,"2018-02-12",{"$f":"EDATE(J2,I2)-1","v":"2019-02-11"},"2018-01-01",12.5,12.54,12.5,12.4]
["R/12/02/252","احمد محمد","علم","1924-08-21","عامل","اعدادية","تمهين",2,12,"2018-02-13",{"$f":"EDATE(J3,I3)-1","v":"2019-02-12"},"2018-01-02",13.5,12.35,13.5,11.2]
["A/12/01/253","كمال احمد","ورد","1924-08-22","عامل","اعدادية","دروس مسائية",3,18,"2018-02-14","2019-08-13","2018-01-03",12.4,10.65,12.4,10.15]
["CS/12/02/254","رضا سليمان","بندر","1924-08-23","عامل","اعدادية","اقامي",4,24,"2018-02-15","2020-02-14","2018-01-04",11.2,11.25,11.2,11.32]
["A/12/02/255","فاطمة احمد","إسكندر","1924-08-24","عامل","اعدادية","تمهين",2,12,"2018-02-16","2019-02-15","2018-01-05",10.15,12.5,10.15,15.36]
["Q/12/02/256","عباس كمال","سليم","2036-11-21","عامل","اعدادية","دروس مسائية",2,12,"2018-02-17","2019-02-16","2018-01-06",11.32,13.5,11.32,14.32]
["A/12/02/257","عباس سمير ","رابح","1960-02-11","مهندس","محاسبة","تأهيلي","Q",6,"18/02/2018","17/08/2018","2018-07-01","12,45",10.220000000000001,12.45,13.25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"EDATE(J1004,I1004)-1","v":-1}]

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

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

{"sheet":"كشف النقاط","index":3,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,0,1,12],[6,0,6,4],[7,0,8,12],[9,1,9,3],[10,1,10,3],[10,5,10,8],[11,0,11,1],[11,2,11,5],[11,8,11,11],[12,1,12,3],[12,5,12,7],[12,9,12,12],[13,2,13,3],[13,4,13,6],[13,7,13,9],[13,12,13,14],[14,0,14,1],[14,2,14,4],[14,12,14,14],[16,1,16,7],[16,8,16,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],[25,6,25,8],[27,5,27,8],[22,1,22,7],[22,8,22,12],[24,0,24,3],[24,4,24,6],[24,7,24,8],[24,9,24,12]]}
[]
["الجمهوريـة الجزائريـة الديمقراطيـة الشعبيـة"]
[]
[" وزارة التكوين والتعليم المهنيين"]
[" مديرية التكوين المهني والتعليم المهنيين لولاية الاغواط                        "]
[" مركز التكوين المهني والتمهين حمدي بشير"]
["تاجموت"]
[]
[]
["اللقب: ","شتوح"]
["الاسم :",null,null,null,"اللقب:"]
["تاريخ ومكان الميلاد:",null,null,null,null,null,"رقم التسجيل:"]
["الاختصاص:",null,null,null,"من: ",null,null,null,"إلى: "]
["مدة التكويـــــن:",null,null,null,"مستـوى التأهيل: "]
["السنة التكوينيـة:",null,{"$f":"[1]الرئيسية!#REF!","v":{"$error":"#REF!"}}]
[]
[null,"السداسي",null,null,null,null,null,null,"المعدل"]
[null,"السداسي الأول",null,null,null,null,null,null,{"$f":"VLOOKUP([1]الرئيسية!$K$20,'[1]قاعدة بيانات'!$A$2:$P$10,13,0)","v":14.23}]
[null,{"$f":"IF(H14>=2,\"السداسي الثاني\",\"المجموع العام\")","v":"المجموع العام"},null,null,null,null,null,null,{"$f":"IF(H14>=2,VLOOKUP([1]الرئيسية!$K$20,'[1]قاعدة بيانات'!$A$2:$P$10,14,0),I18)","v":14.23}]
[null,{"$f":"IF(H14=1,\"المعدل العام\",IF(H14=2,\"المجموع العام\",\"السداسي الثالث\"))","v":"السداسي الثالث"},null,null,null,null,null,null,{"$f":"IF(H14=1,I19/1,IF(H14=2,I18+I19,VLOOKUP([1]الرئيسية!$K$20,'[1]قاعدة بيانات'!$A$2:$P$10,15,0)))","v":14.33}]
[null,{"$f":"IF(H14=1,\"\",IF(H14=2,\"المعدل العام\",IF(H14=3,\"المجموع العام\",\"السداسي الرابع\")))","v":"السداسي الرابع"},null,null,null,null,null,null,{"$f":"IF(H14=1,\"\",IF(H14=2,I20/2,IF(H14=3,I18+I19+I20,VLOOKUP([1]الرئيسية!$K$20,'[1]قاعدة بيانات'!$A$2:$P$10,16,0))))","v":12.33}]
[null,{"$f":"IF(H14=1,\"\",IF(H14=2,\"\",IF(H14=3,\"المعدل العام\",\"المجموع العام\")))","v":"المجموع العام"},null,null,null,null,null,null,{"$f":"IF(H14=1,\"\",IF(H14=2,\"\",IF(H14=3,I21/3,I18+I19+I20+I21)))","v":55.12}]
[null,{"$f":"IF(H14=1,\"\",IF(H14=2,\"\",IF(H14=3,\"\",\"المعدل العام\")))","v":"المعدل العام"},null,null,null,null,null,null,{"$f":"IF(H14=1,\"\",IF(H14=2,\"\",IF(H14=3,\"\",I22/4)))","v":13.78}]
[]
["ملاحظات النهائية للجنة المداولات :",null,null,null,{"$f":"IF(I23>=10,\"ناجح\",\"راسب\")","v":"ناجح"},null,null,"بتقديــــــــــــــــر:",null,{"$f":"IF(I23>=16,\"جيد جدا\",IF(I23>=14,\"جيد\",IF(I23>=12,\"حسن\",IF(I23<12,\"//\"))))","v":"حسن"}]
[null,null,null,null,null,null,"حرر ب,,,,,,,,,,,,,, في : "]
[]
[null,null,null,null,null,"إمضاء وختم مدير المؤسسة"]
[]
[]
["ملاحظة : لا تسلم إلا نسخة واحدة من هذا الكشف"]