{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["برنامج الحراسة","البرنامج الفردي"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":65,"n_cols":13,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,9,2,11],[63,8,63,11],[5,10,5,11],[4,0,5,1],[4,2,4,3],[4,4,4,5],[4,6,4,7],[4,8,4,9],[4,10,4,11],[5,2,5,3],[5,4,5,5],[5,6,5,7],[5,8,5,9],[63,0,63,1],[62,0,62,1]]}
[null,null,null,null,"الجمهورية الجزائرية الديمقراطية الشعبية"]
[null,null,null,null,null,"وزارة التربية الوطنية"]
["مديرية التربية لولاية باتنة",null,null,null,"برنامج الحراسة خلال الفصل:الأول",null,null,null,null,"السنة الدراسية:2017/2016"]
["متوسطة "]
[null,null,"الأحد",null,"الإثنين",null,"الثلاثاء",null,"الأربعاء",null,"الخميس"]
[null,null,"2016-12-04",null,"2016-12-05",null,"2016-12-06",null,"2016-12-07",null,"2016-12-08"]
["الرقم","الأستاذ","ص","م","ص","م","ص","م","ص","م","ص","م"]
[1,"بشير1",1,2,3,1,2,6,"/","/",2,6,{"$f":"COUNTIFS(C8:L8,\"/\")","v":2}]
[2,"بشير2",8,7,"/","/",6,5,16,8,1,20,{"$f":"COUNTIFS(C9:L9,\"/\")","v":2}]
[3,"بشير3",2,3,4,6,"/","/",17,2,3,2,2]
[4,"بشير4",9,8,2,20,11,12,"/","/",2,19,2]
[5,"بشير5",10,9,1,19,"/","/",18,12,3,18,2]
[6,"بشير6",11,10,"/","/",16,11,19,16,4,17,2]
[7,"بشير7",3,5,"/","/",1,4,1,3,4,4,2]
[8,"بشير8",12,2,20,18,7,18,"/","/",5,16,2]
[9,"بشير9",4,"/",1,5,3,1,5,1,6,"/",2]
[10,"بشير10",13,"/","/",18,15,13,11,2,7,"/",3]
[11,"بشير11",5,"/",2,4,4,2,6,4,5,"/",2]
[12,"بشير12","/",20,19,16,17,17,15,3,8,"/",2]
[13,"بشير13",14,"/",7,8,15,14,20,17,9,"/",2]
[14,"بشير14","/",3,8,7,12,15,12,13,19,"/",2]
[15,"بشير15",13,4,18,17,14,13,"/","/",20,15,2]
[16,"بشير16",15,6,"/","/",4,16,11,4,10,14,2]
[17,"بشير17",16,6,5,2,"/","/",4,5,6,1,2]
[18,"بشير18","/","/",17,16,7,17,"/",18,15,13,3]
[19,"بشير19",17,9,"/","/",8,10,13,9,16,12,2]
[20,"بشير20",18,10,16,15,"/","/",3,14,17,11,2]
[21,"بشير21","/",19,15,13,18,2,14,18,18,"/",2]
[22,"بشير22",6,18,"/","/",5,3,3,6,7,3,2]
[23,"بشير23","/",17,14,"/",20,20,4,19,11,1,2]
[24,"بشير24","/",16,13,14,13,19,7,10,12,"/",2]
[25,"بشير25","/",15,12,11,9,1,8,15,13,"/",2]
[26,"بشير26",4,14,"/","/",19,7,9,20,14,10,2]
[27,"بشير27",7,4,6,3,"/","/",2,7,1,5,2]
[28,"بشير28",5,13,11,12,"/","/",10,11,10,9,2]
[29,"بشير29",19,12,10,9,20,9,"/","/",9,8,2]
[30,"بشير30",20,11,9,10,10,8,"/","/",8,7,2]
[31,"بشير31",null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(C38:L38,\"/\")","v":0}]
[32,"بشير32",null,null,null,null,null,null,null,null,null,null,0]
[33,"بشير33",null,null,null,null,null,null,null,null,null,null,0]
[34,"بشير34",null,null,null,null,null,null,null,null,null,null,0]
[35,"بشير35",null,null,null,null,null,null,null,null,null,null,0]
[36,"بشير36",null,null,null,null,null,null,null,null,null,null,0]
[37,"بشير37",null,null,null,null,null,null,null,null,null,null,0]
[38,"بشير38",null,null,null,null,null,null,null,null,null,null,0]
[39,"بشير39",null,null,null,null,null,null,null,null,null,null,0]
[40,"بشير40",null,null,null,null,null,null,null,null,null,null,0]
[41,"بشير41",null,null,null,null,null,null,null,null,null,null,0]
[42,"بشير42",null,null,null,null,null,null,null,null,null,null,0]
[43,"بشير43",null,null,null,null,null,null,null,null,null,null,0]
[44,"بشير44",null,null,null,null,null,null,null,null,null,null,0]
[45,"بشير45",null,null,null,null,null,null,null,null,null,null,0]
[46,"بشير46",null,null,null,null,null,null,null,null,null,null,0]
[47,"بشير47",null,null,null,null,null,null,null,null,null,null,0]
[48,"بشير48",null,null,null,null,null,null,null,null,null,null,0]
[49,"بشير49",null,null,null,null,null,null,null,null,null,null,0]
[50,"بشير50",null,null,null,null,null,null,null,null,null,null,0]
[51,"بشير51",null,null,null,null,null,null,null,null,null,null,0]
[52,"بشير52",null,null,null,null,null,null,null,null,null,null,0]
[53,"بشير53",null,null,null,null,null,null,null,null,null,null,0]
[54,"بشير54",null,null,null,null,null,null,null,null,null,null,0]
[55,"بشير55",null,null,null,null,null,null,null,null,null,null,0]
[]
["مستشار التربية",null,null,null,null,null,null,null,"     في:2016/11/22   "]
[null,null,null,null,null,null,null,null,null,null,"  المديــــر"]

{"sheet":"البرنامج الفردي","index":1,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":false,"merged":[[7,2,7,3],[5,2,5,3],[19,6,19,7],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[8,4,8,5],[9,4,9,5],[8,6,8,7],[9,6,9,7],[10,6,10,7],[11,6,11,7],[12,6,12,7],[1,4,1,5],[16,1,16,4],[17,1,17,4],[18,1,18,5],[14,6,14,7],[15,6,15,7],[16,6,16,7],[6,4,6,5],[7,4,7,5],[7,6,7,7],[6,6,6,7],[14,1,14,4],[18,6,18,7],[10,4,10,5],[11,4,11,5],[12,4,12,5],[30,2,30,3],[31,4,31,5],[31,6,31,7],[32,2,32,3],[32,4,32,5],[32,6,32,7],[36,2,36,3],[36,4,36,5],[36,6,36,7],[33,2,33,3],[33,4,33,5],[33,6,33,7],[34,2,34,3],[34,4,34,5],[34,6,34,7],[44,6,44,7],[26,4,26,5],[40,6,40,7],[41,1,41,4],[41,6,41,7],[42,1,42,4],[43,1,43,5],[43,6,43,7],[37,2,37,3],[37,4,37,5],[37,6,37,7],[39,1,39,4],[39,6,39,7],[35,2,35,3],[35,4,35,5],[35,6,35,7]]}
[null,null,null,null,"الجمهورية الجزائرية الديمقراطية الشعبية"]
[null,null,null,null,"وزارة التربية الوطنية"]
[null,"مديرية التربية لولاية باتنة",null,null,null,null,"     السنة الدراسية:","2017/2016"]
[null,"متوسطة "]
[null,null,null,null,"         برنامج الحراسة خلال الفصل:الأول"]
[null,"الأستاذ(ة):",{"$f":"VLOOKUP($J$6,'برنامج الحراسة'!$A$8:$L$62,2,FALSE)","v":"بشير5"},null,null,null,null,null,null,5]
[null,null,null,null,"صبـــاحا",null,"مســــاءا"]
[null,"الأيـــام","التــــاريـخ",null,"الحجــرة",null,"الحجــرة"]
[null,"الأحد","2016-12-04",null,{"$f":"VLOOKUP($J$6,'برنامج الحراسة'!$A$8:$L$62,3,FALSE)","v":10},null,{"$f":"VLOOKUP($J$6,'برنامج الحراسة'!$A$8:$L$62,4,FALSE)","v":9}]
[null,"الإثنين","2016-12-05",null,{"$f":"VLOOKUP($J$6,'برنامج الحراسة'!$A$8:$L$62,5,FALSE)","v":1},null,{"$f":"VLOOKUP($J$6,'برنامج الحراسة'!$A$8:$L$62,6,FALSE)","v":19}]
[null,"الثلاثاء","2016-12-06",null,{"$f":"VLOOKUP($J$6,'برنامج الحراسة'!$A$8:$L$62,7,FALSE)","v":"/"},null,{"$f":"VLOOKUP($J$6,'برنامج الحراسة'!$A$8:$L$62,8,FALSE)","v":"/"}]
[null,"الأربعاء","2016-12-07",null,{"$f":"VLOOKUP($J$6,'برنامج الحراسة'!$A$8:$L$62,9,FALSE)","v":18},null,{"$f":"VLOOKUP($J$6,'برنامج الحراسة'!$A$8:$L$62,10,FALSE)","v":12}]
[null,"الخميس","2016-12-08",null,{"$f":"VLOOKUP($J$6,'برنامج الحراسة'!$A$8:$L$62,11,FALSE)","v":3},null,{"$f":"VLOOKUP($J$6,'برنامج الحراسة'!$A$8:$L$62,12,FALSE)","v":18}]
[null,"ملاحظة:"]
[null,"   عدم قراءة الاسئلة للتلاميذ في الاقسام.",null,null,null,null," جلوس التلاميذ يكون حسب القوائم."]
[null,"  لا يسمح للتلميذ بمغادرة الإختبار إلا بعد مرور نصف الوقت المقرر ",null,null,null,null," تعاد الاوراق للتلاميذبعد التصحيح."]
[null,"  حضور الأستاذ15دقيقة قبل الإختبار.",null,null,null,null,"تسلم الاوراق للإدارة عند الإنتهاء منها."]
[null,"   إجراء المناداة وإحصاء الاوراق في النهاية."]
[null,"   نزع المحافظ والدفاتر من التلاميذ.",null,null,null,null,"               الجزار في:2016/11/20"]
[null,null,null,null,null,null,"                  المديــــر"]
[]
[]
[]
[]
[]
[null,null,null,null,"الجمهورية الجزائرية الديمقراطية الشعبية"]
[null,null,null,null,"وزارة التربية الوطنية"]
[null,"مديرية التربية لولاية باتنة",null,null,null,null,"السنة الدراسية:","2017/2016"]
[null,"متوسطة الجزار-مركز"]
[null,null,null,null,"         برنامج الحراسة خلال الفصل:الاول"]
[null,"الأستاذ(ة):",{"$f":"VLOOKUP($J$31,'برنامج الحراسة'!$A$9:$L$62,2,FALSE)","v":"بشير6"},null,null,null,null,null,null,{"$f":"J6+1","v":6}]
[null,null,null,null,"صبـــاحا",null,"مســــاءا"]
[null,"الأيـــام","التــــاريـخ",null,"الحجــرة",null,"الحجــرة"]
[null,"الأحد","2016-12-04",null,{"$f":"VLOOKUP($J$31,'برنامج الحراسة'!$A$8:$L$62,3,FALSE)","v":11},null,{"$f":"VLOOKUP($J$31,'برنامج الحراسة'!$A$8:$L$62,4,FALSE)","v":10}]
[null,"الإثنين","2016-12-05",null,{"$f":"VLOOKUP($J$31,'برنامج الحراسة'!$A$8:$L$62,5,FALSE)","v":"/"},null,{"$f":"VLOOKUP($J$31,'برنامج الحراسة'!$A$8:$L$62,6,FALSE)","v":"/"}]
[null,"الثلاثاء","2016-12-06",null,{"$f":"VLOOKUP($J$31,'برنامج الحراسة'!$A$8:$L$62,7,FALSE)","v":16},null,{"$f":"VLOOKUP($J$31,'برنامج الحراسة'!$A$8:$L$62,8,FALSE)","v":11}]
[null,"الأربعاء","2016-12-07",null,{"$f":"VLOOKUP($J$31,'برنامج الحراسة'!$A$8:$L$62,9,FALSE)","v":19},null,{"$f":"VLOOKUP($J$31,'برنامج الحراسة'!$A$8:$L$62,10,FALSE)","v":16}]
[null,"الخميس","2016-12-08",null,{"$f":"VLOOKUP($J$31,'برنامج الحراسة'!$A$8:$L$62,11,FALSE)","v":4},null,{"$f":"VLOOKUP($J$31,'برنامج الحراسة'!$A$8:$L$62,12,FALSE)","v":17}]
[null,"ملاحظة:"]
[null,"   عدم قراءة الاسئلة للتلاميذ في الاقسام.",null,null,null,null," جلوس التلاميذ يكون حسب القوائم."]
[null,"  لا يسمح للتلميذ بمغادرة الإختبار إلا بعد مرور نصف الوقت المقرر ",null,null,null,null," تعاد الاوراق للتلاميذبعد التصحيح."]
[null,"  حضور الأستاذ15دقيقة قبل الإختبار.",null,null,null,null,"تسلم الاوراق للإدارة عند الإنتهاء منها."]
[null,"   إجراء المناداة وإحصاء الاوراق في النهاية."]
[null,"   نزع المحافظ والدفاتر من التلاميذ.",null,null,null,null,"               الجزار في:2016/11/20"]
[null,null,null,null,null,null,"                  المديــــر"]