{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["base","data","حركة التلاميذ"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":67,"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":88,"n_cols":21,"rows_kept":88,"cut":false,"hidden":false,"merged":[[4,19,5,19],[4,20,5,20],[2,15,3,20],[0,1,0,10],[87,12,87,13],[4,15,5,15],[4,16,5,16],[4,17,5,17],[4,18,5,18]]}
[null,"المعلــــــــــــــــــــــومات الأساسية"]
[null,"مديرية التربية لولاية : تلمسان",null,null,"المؤسسة : ","ثانوية الخوارزمي  مغنية ",null,"البلدية : ","مغنية في :","السنة الدراسية :2021/2020"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"الحجم الساعي اليــــــومي"]
[null,"من القائمة المنسدلة قم باختيار الأقسام الموجودة بالمؤسسة"]
[null,{"$f":"IF($C5=\"\",\"\",ROW($A1))","v":1},"3ت ر/هك",null,null,null,null,null,null,null,null,null,null,null,null,"الأيـــــــام ","سنة أولى ","سنة ثانية ","سنة ثالثة","عدد الحصص المبرمجة","عدد الأساتذة العاملين"]
[null,{"$f":"IF($C6=\"\",\"\",ROW($A2))","v":2},"3ت ر/هم",null,"الجنس","الصفة ","ملاحظات",null,"تبرير غيابات الأساتذة","الأقسام ","الأيـــــــام ",null,"اسم و لقب الأستاذ","المــادة"]
[null,3,"3ت إ01",null,"ذكر","D1","نصف داخلي ذكر",null,"ندوة خارجية","3ت ر/هم","الأحد",null,"أ.جبور  ","إقتصاد",null,"الأحد",81,65,69,212,43]
[null,4,"3ع ت01",null,"أنثى ","D2","نصف داخلي أنثى",null,"إضراب","3ت ر/هك","الإثنين",null,"أ.زيان قلعي  ","إقتصاد",null,"الإثنين",88,62,57,212,44]
[null,5,"3ع ت02",null,null,"E1","خارجي ذكر",null,"وفاة أحد الأقارب","3ت ر/همك","الثلاثاء",null,"أ.أجد  ","اجتماعيات",null,"الثلاثاء",80,60,60,200,43]
[null,6,"3أ ف01",null,null,"E2","خارجي أنثى ",null,"اجتماع ","3ت ر/هط","الأربعاء",null,"أ.بودربالة   ","اجتماعيات",null,"الأربعاء",80,60,59,203,44]
[null,7,"3أ ف02",null,null,null,null,null,"شهادة طبية ","3رياضي01","الخميس",null,"أ.قان ","اجتماعيات",null,"الخميس",78,53,65,196,38]
[null,8,"3لغات01",null,null,null,null,null,"طلب غياب","3رياضي02",null,null,"أ.موس ","اجتماعيات"]
[null,9,"2ت ر/هك",null,null,null,"المواد",null,"بترخيص","3رياضي03",null,null,"أ.دلافي ","تكنولوجيا "]
[null,10,"2ت ر/هم",null,null,null,"الرياضيات",null,"مسابقة ترقية","3ع ت01",null,null,"أ.زار  ","تكنولوجيا "]
[null,11,"2ت إ01",null,null,null,"الفيزياء",null,"مرض الابن","3ع ت02",null,null,"أ.عشي  ","تكنولوجيا ",null,null,"تقني رياضي هندسة مدنية ",null,null,null,"الأولى "]
[null,12,"2ع ت01",null,1,null,"الرياضيات",null,"لجنة تثبيت","3ع ت03",null,null,"أ.بوعريشة ","الرياضيات",null,null,"تقني رياضي هندسة كهربائية ",null,null,null,"الثانية "]
[null,13,"2ع ت02",null,2,null,"ع طبيعية",null,"مرض ","3ع ت04",null,null,"أ.بونخالة  ","الرياضيات",null,null,"تقني رياضي هندسة ميكانيكية ",null,null,null,"الثالثة"]
[null,14,"2أ ف01",null,3,null,"أدب عربي",null,"عطلة مرضية","3ع ت05",null,null,"أ.ديب  ","الرياضيات",null,null,"تقني رياضي هندسة الطرائق"]
[null,15,"2أ ف02",null,4,null,"اجتماعيات",null,"عطلة أمومة","3ع ت06",null,null,"أ.فارس  ","الرياضيات",null,null,"علـــــوم تجريبيــة "]
[null,16,"2لغات01",null,5,null,"ع إسلامية ",null,null,"3ع ت07",null,null,"أ.مدوخ  ","الرياضيات",null,null,"تسييـــر و إقتصــــــاد"]
[null,17,"ج م ع تك01",null,6,null,"انجليزية ",null,null,"3ت إ01",null,null,"أ.بوحاجب ","ع إسلامية ",null,null,"أداب و فلســــفة "]
[null,18,"ج م ع تك02",null,7,null,"فلسفة ",null,null,"3ت إ02",null,null,"منصب شاغر","ع إسلامية ",null,null,"لغـــات أجنبيــــة ألمانية"]
[null,19,"ج م ع تك03",null,8,null,"فرنسية ",null,null,"3ت إ03",null,null,"أ.براهمي  ","ع طبيعية",null,null,"لغات أجنبية إيطالية "]
[null,20,"ج م ع تك04",null,9,null,"معلوماتية ",null,null,"3ت إ04",null,null,"أ.درني  ","ع طبيعية",null,null,"لغـــات أجنبيـة إسبانيــة "]
[null,21,"ج م ع تك05",null,10,null,"تكنولوجيا ",null,null,"3أ ف01",null,null,"أ.لعشب  ","ع طبيعية",null,null,"جدع مشترك علوم و تكنولوجيا "]
[null,22,"ج م أ01",null,11,null,"اسبانية ",null,null,"3أ ف02",null,null,"أ.هرواط  ","ع طبيعية",null,null,"جـــدع مشتـــرك أداب"]
[null,23,"ج م أ02",null,12,null,"إقتصاد",null,null,"3أ ف03",null,null,"أ.زيرار  ","الفيزياء"]
[null,24,"ج م أ03",null,13,null,"ت بدنية",null,null,"3أ ف04",null,null,"أ.عشماوي  ","الفيزياء"]
[null,"",null,null,14,null,null,null,null,"3أ ف05",null,null,"أ.الوزان","الفيزياء"]
[null,"",null,null,null,null,null,null,null,"3لغات01",null,null,"أ.قوراري  ","الفيزياء"]
[null,"",null,null,null,null,null,null,null,"3لغات02",null,null,"أ.ناضور  ","الفيزياء"]
[null,"",null,null,null,null,null,null,null,"3لغات03",null,null,"أ.الشيخ  ","فلسفة "]
[null,"",null,null,null,null,null,null,null,"3لغات04",null,null,"أ.فقير ","فلسفة "]
[null,"",null,null,null,null,null,null,null,"2ت ر/هم",null,null,"أ.العرباوي  ","انجليزية "]
[null,"",null,null,null,null,null,null,null,"2ت ر/هك",null,null,"أ.شنتوف  ","انجليزية "]
[null,"",null,null,null,null,null,null,null,"2ت ر/همك",null,null,"أ.مزاري  ","انجليزية "]
[null,"",null,null,null,null,null,null,null,"2ت ر/هط",null,null,"أ.معزوز  ","انجليزية "]
[null,"",null,null,null,null,null,null,null,"2رياضي01",null,null,"أ.سيفاني  ","اسبانية "]
[null,"",null,null,null,null,null,null,null,"2رياضي02",null,null,"أ.أوزين ","أدب عربي"]
[null,"",null,null,null,null,null,null,null,"2رياضي03",null,null,"أ.صبيان  ","أدب عربي"]
[null,"",null,null,null,null,"سبتمبر 2020",null,null,"2رياضي04",null,null,"أ.عيساوي","أدب عربي"]
[null,"",null,null,null,null,"أكتوبر 2020",null,null,"2ع ت01",null,null,"أ.قادري  ","أدب عربي"]
[null,"",null,null,null,null,"نوفمبر 2020",null,null,"2ع ت02",null,null,"أ.معروف ","أدب عربي"]
[null,"",null,null,null,null,"ديسمبر 2020",null,null,"2ع ت03",null,null,"أ.بومانة  ","فرنسية "]
[null,null,null,null,null,null,"جانفي 2021",null,null,"2ع ت04",null,null,"أ.رابحي","فرنسية "]
[null,null,null,null,null,null,"فبراير 2021",null,null,"2ع ت05",null,null,"أ.عباد  ","فرنسية "]
[null,null,null,null,null,null,"مارس 2021",null,null,"2ع ت06",null,null,"أ.كوليلي ","فرنسية "]
[null,null,null,null,null,null,"أبريل 2021",null,null,"2ع ت07",null,null,"أ.لقبوري م","ت بدنية"]
[null,null,null,null,null,null,"ماي 2021",null,null,"2ت إ01",null,null,"أ.تربش م","ت بدنية"]
[null,null,null,null,null,null,"جوان 2021",null,null,"2ت إ02",null,null,"أبرور ع م","ت بدنية"]
[null,null,null,null,null,null,null,null,null,"2ت إ03"]
[null,null,null,null,null,null,null,null,null,"2ت إ04"]
[null,null,null,null,null,null,null,null,null,"2أ ف01"]
[null,null,null,null,null,null,null,null,null,"2أ ف02"]
[null,null,null,null,null,null,null,null,null,"2أ ف03"]
[null,null,null,null,null,null,null,null,null,"2أ ف04"]
[null,null,null,null,null,null,null,null,null,"2أ ف05"]
[null,null,null,null,null,null,null,null,null,"2أ ف06"]
[null,null,null,null,null,null,null,null,null,"2أ ف07"]
[null,null,null,null,null,null,null,null,null,"2لغات01"]
[null,null,null,null,null,null,null,null,null,"2لغات02"]
[null,null,null,null,null,null,null,null,null,"2لغات03"]
[null,null,null,null,null,null,null,null,null,"2لغات04"]
[null,null,null,null,null,null,null,null,null,"ج م ع تك01"]
[null,null,null,null,null,null,null,null,null,"ج م ع تك02"]
[null,null,null,null,null,null,null,null,null,"ج م ع تك03"]
[null,null,null,null,null,null,null,null,null,"ج م ع تك04"]
[null,null,null,null,null,null,null,null,null,"ج م ع تك05"]
[null,null,null,null,null,null,null,null,null,"ج م ع تك06"]
[null,null,null,null,null,null,null,null,null,"ج م ع تك07"]
[null,null,null,null,null,null,null,null,null,"ج م ع تك08"]
[null,null,null,null,null,null,null,null,null,"ج م ع تك09"]
[null,null,null,null,null,null,null,null,null,"ج م ع تك10"]
[null,null,null,null,null,null,null,null,null,"ج م ع تك11"]
[null,null,null,null,null,null,null,null,null,"ج م أ01"]
[null,null,null,null,null,null,null,null,null,"ج م أ02"]
[null,null,null,null,null,null,null,null,null,"ج م أ03"]
[null,null,null,null,null,null,null,null,null,"ج م أ04"]
[null,null,null,null,null,null,null,null,null,"ج م أ05"]
[null,null,null,null,null,null,null,null,null,"ج م أ06"]
[null,null,null,null,null,null,null,null,null,"ج م أ07"]
[null,null,null,null,null,null,null,null,null,"ج م أ08"]
[null,null,null,null,null,null,null,null,null,"ج م أ09"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"الحجم الساعياليومي/الححص المبرمجة /الأساتذة العاملين"]

{"sheet":"data","index":1,"n_rows":26,"n_cols":28,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21]
["الرقم","الاسم و اللقب كاملا","رقم التعريف المدرسي","اللقب","الاسم","الجنس","تاريخ الازدياد","مكان الازدياد","القسم المختصر","السنة ","الشعبة","رقم القسم","رقم القيد","الصفة","اسم الولي","العنوان ","الاسم و اللقب بالكتابة اللاتينية","تاريخ الدخول","تاريخ الخروج","دخول ","خروخ"]
[1,{"$f":"D7& \" \"  &  E7","v":"العابد نور الدين"},1000313270060200,"العابد","نور الدين","ذكر","2003-03-20","مغنية","3ت ر/هم","ثالثة","تقني رياضي هندسة مدنية",1,1,"D1","العابد أحمد ","قرية البطيم مغنية ",null,null,null,null,null,null,null,null,null,null,null,"اسم الولي"]
[2,"بن سالم عبد الله",1099945020157700,"بن سالم","عبد الله","ذكر","1999-11-13","مشرية","3ت ر/هم","ثالثة","تقني رياضي هندسة مدنية",1,2,"D1","بن سالم ميلود ","قرية العقيد لطفي مغنية ",null,null,null,null,null,null,null,null,null,null,null,"ميلود "]
[3,"بن عابد عبد الوهاب",1000313270186600,"بن عابد","عبد الوهاب","ذكر","2003-08-15","مغنية","3ت ر/هم","ثالثة","تقني رياضي هندسة مدنية",1,3,"D1","بن عابد سعيد ","أولاد الشارف مغنية ",null,null,null,null,null,null,null,null,null,null,null,"منصور "]
[4,"سلمان فاطنة",1100213270199500,"سلمان","فاطنة","أنثى","2002-09-11","مغنية","3ع ت02","ثالثة","تقني رياضي هندسة مدنية",1,4,"D2","بوعجاجة التركي ","قرية المرازقة المصامدة ",null,null,"نوفمبر 2020",null,"D2",null,null,null,null,null,null,"محمد "]
[5,"أمين إسماعيل",1000013270283300,"أمين","إسماعيل","ذكر","2000-12-29","مغنية","3ع ت02","ثالثة","تقني رياضي هندسة مدنية",1,5,"D1","عريشي مكي ","قرية العقيد عباس مغنية تلمسان ",null,null,null,null,null,null,null,null,null,null,null,"يوسف "]
[6,"قوريري سيد احمد",1000313270298700,"قوريري","سيد احمد","ذكر","2003-12-26","مغنية","3أ ف02","ثالثة","تقني رياضي هندسة مدنية",1,6,"D1","قوريري محمد ","قرية العقيد لطفي مغنية ",null,null,null,null,null,null,null,null,null,null,null,"ميلود "]
[7,"سيد أحمد حمزة",1000313270212500,"سيد أحمد","حمزة","ذكر","2003-09-13","مغنية","3ت إ01","ثالثة","تقني رياضي هندسة مدنية",1,7,"D1","منور عبد القادر ","قرية العقيد لطفي مغنية  ",null,null,null,null,null,null,null,null,null,null,null,"مصطفى "]
[8,"العاقل احلام",1100313270001400,"العاقل","احلام","أنثى","2003-01-01","مغنية","3لغات01","ثالثة","تقني رياضي هندسة مدنية",1,8,"D2","موساوي ميلود ","قرية العقيد عباس مغنية ",null,null,null,null,null,null,null,null,null,null,null,"أحمد  "]
[9,"هواري عبد المغيث",1000413270063600,"هواري","عبد المغيث","ذكر","2004-03-16","مغنية","3ت ر/هم","ثالثة","تقني رياضي هندسة مدنية",1,9,"D1","هواري عبد القادر ","قرية المصامدة مغنية ",null,null,null,null,null,null,null,null,null,null,null,"احمد "]
[10,"بوسلهام عبير",1100313270275300,"بوسلهام","عبير","أنثى","2003-11-27","مغنية","3ت ر/هم","ثالثة","تقني رياضي هندسة مدنية",1,10,"E2","بوزي فوزي ","عمارة 01 رقم 05 اقامة النور مغنية ",null,null,null,null,null,null,null,null,null,null,null,"عبد الرزاق "]
[11,"ألدازي خديجة صفاء",1100313273622700,"ألدازي","خديجة صفاء","أنثى","2003-02-16","مغنية","3أ ف02","ثالثة","تقني رياضي هندسة مدنية",1,11,"E2","دلهم معاشو ","شارع 10 منزل 19 حي المقراني ",null,"نوفمبر 2020","نوفمبر 2020","CE2","CD2",null,null,null,null,null,null,"سعيد "]
[12,"سالم شمس الدين",1000102080143700,"سالم","شمس الدين","ذكر","2001-10-05","الصبحة","3ت ر/هم","ثالثة","تقني رياضي هندسة مدنية",1,12,"E1","سالم عدة ","حي العربي تبسي مغنية ",null,null,null,null,null,null,null,null,null,null,null,"أحمد "]
[13,"طالب أنيس شرف الدين",1000213270087000,"طالب","أنيس شرف الدين","ذكر","2002-05-08","مغنية","3ت ر/هم","ثالثة","تقني رياضي هندسة مدنية",1,13,"E1","طالب سعيد ","حي الشهداء مغنية ",null,null,null,null,null,null,null,null,null,null,null,"ميلود "]
[14,"عبد ربه سلاف",1100313270224100,"عبد ربه","سلاف","أنثى","2003-04-23","مغنية","3أ ف01","ثالثة","تقني رياضي هندسة مدنية",1,14,"E2","غرفاتي العيد ","حي الشهداء مغنية ",null,null,null,null,null,null,null,null,null,null,null,"سعيد "]
[15,"الحامدي محمد أمين",1000213270267800,"الحامدي","محمد أمين","ذكر","2002-11-26","مغنية","3ت ر/هك","ثالثة","تقني رياضي هندسة كهربائية",1,15,"D1","الحامدي ميلود ","دوار شرقاوي العيد64شارع ابن رشد مغنية ",null,null,null,null,null,null,null,null,null,null,null,"التركي "]
[16,"بلعجل محمد",1000213271479100,"بلعجل","محمد","ذكر","2002-03-09","مغنية","3ت إ01","ثالثة","تقني رياضي هندسة كهربائية",1,16,"D1","بلعجل منصور ","اولاد قدور الكبار مغنية ",null,null,null,null,null,null,null,null,null,null,null,"محمد "]
[17,"بن سعيدة مغنية امينة",1100313270107600,"بن سعيدة","مغنية امينة","أنثى","2003-05-27","مغنية","3ت ر/هك","ثالثة","تقني رياضي هندسة كهربائية",1,17,"D2","بن يوبي محمد ","قرية اولاد الشارف مغنية ",null,null,null,null,null,null,null,null,null,null,null,"عبد القادر "]
[18,"أبو هاشم يسرى",1100313270064600,"أبو هاشم","يسرى","أنثى","2003-03-30","مغنية","3ت ر/هم","ثالثة","تقني رياضي هندسة كهربائية",1,18,"D2","بوبكر يوسف ","مزرعة شعبان حمدون مغنية ",null,null,null,null,null,null,null,null,null,null,null,"ميلود "]
[19,"طرطاق مريم",1100313270033800,"طرطاق","مريم","أنثى","2003-02-11","مغنية","3ت ر/هك","ثالثة","تقني رياضي هندسة كهربائية",1,19,"D2","بوزيان ميلود ","قرية البخاتة مغنية ",null,null,null,null,null,null,null,null,null,null,null,"عبد القادر "]
[20,"دردار ندير",1000413270030500,"دردار","ندير","ذكر","2004-02-06","مغنية","3ت ر/هك","ثالثة","تقني رياضي هندسة كهربائية",1,20,"D1","دردار مصطفى ","قرية البطيم مغنية ",null,"نوفمبر 2020",null,"D1",null,null,null,null,null,null,null,"فوزي "]

{"sheet":"حركة التلاميذ","index":2,"n_rows":76,"n_cols":11,"rows_kept":76,"cut":false,"hidden":false,"merged":[[58,0,58,6],[60,0,60,6],[5,6,5,8],[62,4,62,5],[70,0,70,1],[71,0,71,1],[73,5,73,6],[64,0,64,1],[65,0,66,0],[67,0,67,1],[68,0,69,0]]}
[]
[]
[]
[]
[]
[null,null,null,"حركة التلاميذ خلال شهر : ",null,null,"نوفمبر 2020"]
[]
[]
[]
["الرقم","الاسم و اللقب كاملا","رقم التعريف المدرسي","الجنس","تاريخ الازدياد","مكان الازدياد","القسم المختصر","الصفة","دخول ","خروخ","ملاحظات"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"داخلي",null,"خارجي",null,"المجموع"]
[null,null,"ذ","إ","ذ","إ","ذ"]
["الحاضرون في نهاية الشهر السابق",null,0,308,73,82,{"$f":"SUM(C65+#REF!+E65)","v":{"$error":"#REF!"}}]
["الدخول خلال الشهر ","تحويل الصف",0,{"$f":"COUNTIF(Ent,\"CD2\")","v":0},{"$f":"COUNTIF(Ent,\"CE1\")","v":0},{"$f":"COUNTIF(Ent,\"CE2\")","v":1},{"$f":"C66+#REF!+E66","v":{"$error":"#REF!"}}]
[null,"دخول",0,{"$f":"COUNTIF(Ent,\"D2\")","v":0},{"$f":"COUNTIF(Ent,\"E1\")","v":0},{"$f":"COUNTIF(Ent,\"E2\")","v":0},{"$f":"C67+#REF!+E67","v":{"$error":"#REF!"}}]
["المجموع",null,{"$f":"SUM(C66:C67)","v":0},0,0,1,{"$f":"C68+#REF!+E68","v":{"$error":"#REF!"}}]
["الخروج خلال الشهر ","تحويل الصف",{"$f":"SUM(C67:C68)","v":0},{"$f":"COUNTIF(Sor,\"CD2\")","v":1},{"$f":"COUNTIF(Sor,\"Ce1\")","v":0},{"$f":"COUNTIF(Sor,\"CE2\")","v":0},{"$f":"C69+#REF!+E69","v":{"$error":"#REF!"}}]
[null,"خروج",{"$f":"SUM(C68:C69)","v":0},{"$f":"COUNTIF(Sor,\"D2\")","v":1},{"$f":"COUNTIF(Sor,\"E1\")","v":0},{"$f":"COUNTIF(Sor,\"E2\")","v":0},{"$f":"C70+#REF!+E70","v":{"$error":"#REF!"}}]
["المجموع",null,{"$f":"SUM(C69:C70)","v":0},{"$f":"SUM(D69:D70)","v":2},0,0,{"$error":"#REF!"}]
["التلاميذ الحاضرون في نهاية شهر",null,{"$f":"SUM(C65+C68-C71)","v":0},{"$f":"SUM(D65+D68-D71)","v":306},73,83,{"$error":"#REF!"}]
[]
["انجز من طرف مستشار التربية ",null,null,null,"يوم :","2019-11-28"]
[]
[null,null,null,null,null,"المقتصد "]