{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["الرئيسية","القائمة","الشهادة "],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"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":"الرئيسية","index":0,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,3,2,5],[8,9,8,16],[1,9,2,16],[12,1,19,7]]}
[]
[null,null,null,null,null,null,null,null,null,"البحث عن أي تتلميذ تم أدخلـــه باللقب "]
[null,null,null,"هنا توضع بيانات التلاميــــــــــــــذ "]
[null,null,"الرقم الشهادة ",""]
[null,null,"اللقــــــــــب",null,null,"القســـــــــــــــــم ",null,null,null,null,null,"اللقب","الاسم","تاريخ الميلاد","مكان الميلاد"]
[null,null,"الاســــــــم ",null,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":"القائمة","index":1,"n_rows":390,"n_cols":10,"rows_kept":390,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
["الرقم ","اللقــــــــــب","الاســــــــم ","تاريخ الميلاد ","مكـــــان الميلاد","السنة الدراسيـة ","القســـــــــــــــــم ","رقم التسجيل ","تاريخ الخروج ","منجزة من طرف "]
[1,"مضميط","مصطفي","1991-07-12","أفــلو","2008/2009","الرابعة متوسط رقم 01",31,"جوان 2009","طيفوري محمد"]
[2,"سعداوي","المخطار","21-04-1996","تاجرونة","2014/2015","3م1",165,"جوان 2015","دهكل أحمد"]
[3,"بعيط","هجيرة","27/11/1991","تاجرونة الاغواط","2006/2007","4م2",30,"جوان2007","دربالي"]
[4,"سماعيني","نصر الدين","17/03/1993","تاجرونة","2014/2015","3م2",190,"جوان2015","يسب"]
[5,"شنافي ","نور الدين","2000-02-02","تاجرونة ","2015/2016","السنة الثانية متوسط رقم 01",117,"جوان 2016"]
[6,"ماحي","صفية","1980-10-04","الغيشة","1995-1996","التاسعة أساسي رقم02",50,"1996-06-06"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(B359=\"\",\"\",$A$9+1)","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"الشهادة ","index":2,"n_rows":36,"n_cols":16,"rows_kept":36,"cut":false,"hidden":false,"merged":[[17,0,17,2],[17,4,17,8],[3,3,3,8],[3,13,3,14],[4,3,4,8],[4,13,4,15],[6,8,8,9],[7,4,7,6],[8,4,8,6],[5,9,5,10],[29,0,29,2],[29,4,29,8],[31,0,31,3],[31,4,31,5],[31,7,31,8],[7,0,7,3],[8,0,8,3],[25,1,25,7],[27,1,27,3],[27,4,27,8],[19,0,19,2],[19,4,19,8],[21,0,21,2],[21,4,21,8],[23,0,23,2],[23,4,23,8],[10,0,10,2],[10,4,10,6],[11,4,11,8],[13,1,13,7],[14,1,14,7],[31,9,31,11],[33,4,33,7],[33,8,33,10],[35,6,35,9],[43,7,43,9]]}
[]
[]
[]
[null,null,null,"الجمهورية الجزائرية الديمقراطية الشعبية ",null,null,null,null,null,null,null,null,null,"ضع رقم التلميذ هنا",null,2]
[null,null,null,"وزارة التربية الوطنيـــــــــة ",null,null,null,null,null,null,null,null,null,"لا تكتب شيئا في هذه الورقة"]
[]
[]
["مديرية التربيـــة  لولاية",null,null,null,"الاغــواط"]
["متوسطـــــــــــة ",null,null,null,"سماعيني معمر تاجرونة "]
[]
["رقم الشهادة :",null,null,null,{"$f":"VLOOKUP($P$4,القائمة!A8:J371,1,0)","v":2}]
[null,null,null,null,"شهادة مدرسيــــــــــة "]
[]
[null,"يشهد مدير (ة) مدير متوسطة ان التلميذ : "]
[]
[]
[]
["اللقـــــــــــب ",null,null,null,{"$f":"VLOOKUP($P$4,القائمة!A8:J387,2,0)","v":"سعداوي"}]
[]
["الاســـــــم ",null,null,null,{"$f":"VLOOKUP($P$4,القائمة!A8:J389,3,0)","v":"المخطار"}]
[]
["تاريخ الميلاد",null,null,null,{"$f":"VLOOKUP($P$4,القائمة!A8:J387,4,0)","v":"21-04-1996"}]
[]
["مكـــان الميلاد",null,null,null,{"$f":"VLOOKUP($P$4,القائمة!A8:J722,5,0)","v":"تاجرونة"}]
[]
[null,"تابــــــع (ة) دروس (ها) بالمؤسســـــــــــــــــــــــة "]
[]
[null,"سنة المزاولـــــة ",null,null,{"$f":"VLOOKUP($P$4,القائمة!A8:J931,6,0)","v":"2014/2015"}]
[]
["القســـم",null,null,null,{"$f":"VLOOKUP($P$4,القائمة!A8:J1425,7,0)","v":"3م1"}]
[]
["رقم التسجيـــــــــــل ",null,null,null,{"$f":"VLOOKUP($P$4,القائمة!A8:J858,8,0)","v":165},null,null,"تاريخ الخروج",null,{"$f":"VLOOKUP($P$4,القائمة!A8:J917,9,0)","v":"جوان 2015"}]
[]
[null,null,null,null,"حرر بــــــ تاجرونة ",null,null,null,{"$f":"TODAY()","v":"2020-07-08"}]
[]
[null,null,null,null,null,null,"مدير المؤسسة "]