{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["data","list garde","tab garde","tabprof","gradeeta"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":6,"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":"data","index":0,"n_rows":98,"n_cols":10,"rows_kept":98,"cut":false,"hidden":false,"merged":[[36,9,43,9],[0,5,0,6],[4,9,11,9],[12,9,19,9],[20,9,27,9],[28,9,35,9]]}
[null,"فى حالة  مادتين فى نفس الفترة اكتب المادتين معا  مثلا فيزياء+عربية",null,null,null,"ادخل تاريخ بداية الامتحان",null,"2021-11-28","العنوان","جدول حراسة اختبارات الفصل الأول"]
[null,null,null,null,null,null,null,null,"السنة الدراسية","2022/2021"]
[null,"مواد الامتحان",null,null,null,null,null,"مواد الامتحان"]
[null,"المادة","الفترة","التاريخ",null,null,null,"المادة","الفترة","التاريخ"]
[1,"عربية","الصباحية1",{"$f":"$H$1","v":"2021-11-28"},null,null,1,"عربية","10-08",{"$f":"$H$1","v":"2021-11-28"}]
[2,null,"الصباحية2",{"$f":"$H$1","v":"2021-11-28"},null,null,2,"عربية","11-08"]
[3,"انجليزية","المسائية","2021-11-28",null,null,3,"عربية","12-10"]
[4,"رياضيات","الصباحية1",{"$f":"$H$1+1","v":"2021-11-29"},null,null,4,"عربية","12-08"]
[5,null,"الصباحية2",{"$f":"$H$1+1","v":"2021-11-29"},null,null,5,"ع اسلامية","16-14"]
[6,"تاريخ","المسائية","2021-11-29",null,null,6,"تاريخ","17-14"]
[7,"علوم","الصباحية1",{"$f":"$H$1+2","v":"2021-11-30"},null,null,7,"علوم","17-15"]
[8,null,"الصباحية2",{"$f":"$H$1+2","v":"2021-11-30"},null,null,8,null,"17-13"]
[9,"فرنسية","المسائية","2021-11-30",null,null,9,"فرنسية","10-08",{"$f":"$H$1+1","v":"2021-11-29"}]
[10,"ع اسلامية","الصباحية1",{"$f":"$H$1+3","v":"2021-12-01"},null,null,10,"ع اسلامية","11-08"]
[11,"قانون","الصباحية2",{"$f":"$H$1+3","v":"2021-12-01"},null,null,11,"قانون","12-10"]
[12,null,"المسائية","2021-12-01",null,null,12,null,"12-08"]
[13,"فيزياء","الصباحية1",{"$f":"$H$1+4","v":"2021-12-02"},null,null,13,"فيزياء","16-14"]
[14,null,"الصباحية2",{"$f":"$H$1+4","v":"2021-12-02"},null,null,14,null,"17-14"]
[15,"فلسفة","المسائية","2021-12-02",null,null,15,"فلسفة","17-15"]
[{"$f":"IF(B20=\"\",\"\",A19+1)","v":""},null,null,null,null,null,16,null,"17-13"]
["المادة",null,"الرقم","لقب و اسم الاستاذ","الاطار","المادة",17,"فلسفة","10-08",{"$f":"$H$1+2","v":"2021-11-30"}]
["رياضيات",null,1,"استاذ1","ا.ت.ث","لغة عربية",18,null,"11-08"]
["فيزياء",null,2,"استاذ2","ا.ت.ث","لغة عربية",19,"فلسفة","12-10"]
["ع. طبيعية",null,3,"استاذ3","ا.ت.ث","لغة عربية",20,null,"12-08"]
["لغة عربية",null,4,"استاذ4","ا.ت.ث","لغة عربية",21,"فلسفة","16-14"]
["ع.اسلامية",null,5,"استاذ5","ا.ت.ث","لغة عربية",22,null,"17-14"]
["فلسفة",null,6,"استاذ6","ا.ت.ث","لغة عربية",23,"فلسفة","17-15"]
["فرنسية",null,7,"استاذ7","ا.ت.ث","لغة عربية",24,null,"17-13"]
["انجليزية",null,8,"استاذ8","ا.ت.ث","رياضيات",25,"فلسفة","10-08",{"$f":"$H$1+3","v":"2021-12-01"}]
["تاريخ",null,9,"استاذ9","ا.ت.ث","رياضيات",26,null,"11-08"]
["ت.بدنية",null,10,"استاذ10","ا.ت.ث","رياضيات",27,"فلسفة","12-10"]
["اسبانية",null,11,"استاذ11","ا.ت.ث","رياضيات",28,null,"12-08"]
["كهرباء",null,12,"استاذ12","ا.ت.ث","رياضيات",29,"فلسفة","16-14"]
["هـ.مدنية",null,13,"استاذ13","ا.ت.ث","رياضيات",30,null,"17-14"]
["هـ.ميكانيكية",null,14,"استاذ14","ا.ت.ث","انجليزية",31,"فلسفة","17-15"]
["هـ.طرائق",null,15,"استاذ15","ا.ت.ث","انجليزية",32,null,"17-13"]
["ا.الى",null,16,"استاذ16","ا.ت.ث","انجليزية",33,"فلسفة","10-08",{"$f":"$H$1+4","v":"2021-12-02"}]
["اقتصاد",null,17,"استاذ17","ا.ت.ث","انجليزية",34,null,"11-08"]
[null,null,18,"استاذ18","ا.ت.ث","انجليزية",35,"فلسفة","12-10"]
[null,null,19,"استاذ19","ا.ت.ث","ع.اسلامية",36,null,"12-08"]
[null,null,20,"استاذ20","ا.ت.ث","ع.اسلامية",37,"فلسفة","16-14"]
[null,null,21,"استاذ21","ا.ت.ث","ع.اسلامية",38,null,"17-14"]
[null,null,22,"استاذ22","ا.ت.ث","ع. طبيعية",39,"فلسفة","17-15"]
[null,null,23,"استاذ23","ا.ت.ث","ع. طبيعية",40,null,"17-13"]
[null,null,24,"استاذ24","ا.ت.ث","ع. طبيعية"]
[null,null,25,"استاذ25","ا.ت.ث","ع. طبيعية"]
[null,null,26,"استاذ26","ا.ت.ث","ع. طبيعية"]
[null,null,27,"استاذ27","ا.ت.ث","فرنسية"]
[null,null,28,"استاذ28","ا.ت.ث","فرنسية"]
[null,null,29,"استاذ29","ا.ت.ث","فرنسية"]
[null,null,30,"استاذ30","ا.ت.ث","فرنسية"]
[null,null,31,"استاذ31","ا.ت.ث","فرنسية"]
[null,null,32,"استاذ32","ا.ت.ث","تكنولوجيا"]
[null,null,33,"استاذ33","ا.ت.ث","اقتصاد"]
[null,null,34,"استاذ34","ا.ت.ث","اقتصاد"]
[null,null,35,"استاذ35","ا.ت.ث","فلسفة"]
[null,null,36,"استاذ36","ا.ت.ث","فلسفة"]
[null,null,37,"استاذ37","ا.ت.ث","فلسفة"]
[null,null,38,"استاذ38","ا.ت.ث","هـ.مدنية"]
[null,null,39,"استاذ39","ا.ت.ث","هـ.ميكانيكية"]
[null,null,40,"استاذ40","ا.ت.ث","هـ.طرائق"]
[null,null,41,"استاذ41","ا.ت.ث","كهرباء"]
[null,null,42,"استاذ42","ا.ت.ث","تاريخ"]
[null,null,43,"استاذ43","ا.ت.ث","تاريخ"]
[null,null,44,"استاذ44","ا.ت.ث","تاريخ"]
[null,null,45,"استاذ45","ا.ت.ث","تاريخ"]
[null,null,46,"استاذ46","ا.ت.ث","فيزياء"]
[null,null,47,"استاذ47","ا.ت.ث","فيزياء"]
[null,null,48,"استاذ48","ا.ت.ث","فيزياء"]
[null,null,49,"استاذ49","ا.ت.ث","فيزياء"]
[null,null,50,"استاذ50","ا.ت.ث","فيزياء"]
[null,null,51,"استاذ51","ا.ت.ث","فيزياء"]
[null,null,52,"استاذ52","ا.ت.ث","ا.الى"]
[null,null,53,"استاذ53","ا.ت.ث","ت.بدنية"]
[null,null,54,"استاذ54","ا.ت.ث","ت.بدنية"]
[null,null,55,"استاذ55","ا.ت.ث","ت.بدنية"]
[null,null,56,"استاذ56","ا.ت.ث","اسبانية"]
[null,null,57,"فارغ"]
[null,null,58,"فارغ"]
[null,null,59,"فارغ"]
[null,null,60,"فارغ"]
[null,null,61,"فارغ"]
[null,null,62,"فارغ"]
[null,null,63,"فارغ"]
[null,null,64,"فارغ"]
[null,null,65,"فارغ"]
[null,null,66,"فارغ"]
[null,null,67,"فارغ"]
[null,null,68,"فارغ"]
[null,null,69,"فارغ"]
[null,null,70,"فارغ"]
[null,null,71,"فارغ"]
[null,null,72,"فارغ"]
[null,null,73,"فارغ"]
[null,null,74,"فارغ"]
[null,null,75,"فارغ"]
[null,null,76,"فارغ"]
[null,null,77,"فارغ"]

{"sheet":"list garde","index":1,"n_rows":63,"n_cols":26,"rows_kept":63,"cut":false,"hidden":false,"merged":[[4,12,4,14],[4,15,4,17],[4,18,4,20],[4,6,4,8],[4,9,4,11]]}
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"data!D5","v":"2021-11-28"},null,null,{"$f":"$G$5+1","v":"2021-11-29"},null,null,{"$f":"$J$5+1","v":"2021-11-30"},null,null,{"$f":"$M$5+1","v":"2021-12-01"},null,null,{"$f":"$P$5+1","v":"2021-12-02"}]
[null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
["الرقم","اللقب و الاسم","الاطار","المادة","عدد القاعات","مجموع ساعات","10-08","12-10","16-14","10-08","12-10","16-14","10-08","12-10","16-14","10-08","12-10","16-14","10-08","12-10","16-14"]
[1,{"$f":"IF(data!D22=\"فارغ\",\"\",data!D22)","v":"استاذ1"},{"$f":"IF(B8=\"\",\"\",data!E22)","v":"ا.ت.ث"},{"$f":"IF(B8=\"\",\"\",data!F22)","v":"لغة عربية"},{"$f":"COUNT(G8:U8)","v":7},{"$f":"SUMIFS($G$62:$U$62,G8:U8,\">0\")","v":14},29,14,null,null,null,1,null,null,null,24,12,null,2,29,null,null,{"$f":"COUNTIF(S:S,S8)","v":2}]
[2,{"$f":"IF(data!D23=\"فارغ\",\"\",data!D23)","v":"استاذ2"},{"$f":"IF(B9=\"\",\"\",data!E23)","v":"ا.ت.ث"},{"$f":"IF(B9=\"\",\"\",data!F23)","v":"لغة عربية"},7,14,29,15,null,null,null,2,null,null,null,23,11,null,3,18,null,null,1]
[3,{"$f":"IF(data!D24=\"فارغ\",\"\",data!D24)","v":"استاذ3"},{"$f":"IF(B10=\"\",\"\",data!E24)","v":"ا.ت.ث"},{"$f":"IF(B10=\"\",\"\",data!F24)","v":"لغة عربية"},7,14,29,16,null,null,null,3,null,null,null,22,10,null,4,17,null,null,1]
[4,{"$f":"IF(data!D25=\"فارغ\",\"\",data!D25)","v":"استاذ4"},{"$f":"IF(B11=\"\",\"\",data!E25)","v":"ا.ت.ث"},{"$f":"IF(B11=\"\",\"\",data!F25)","v":"لغة عربية"},7,14,29,17,null,null,null,4,null,null,null,21,9,null,13,16,null,null,2]
[5,{"$f":"IF(data!D26=\"فارغ\",\"\",data!D26)","v":"استاذ5"},{"$f":"IF(B12=\"\",\"\",data!E26)","v":"ا.ت.ث"},{"$f":"IF(B12=\"\",\"\",data!F26)","v":"لغة عربية"},7,14,29,18,null,null,null,5,null,null,1,20,8,null,null,null,13,null,0]
[6,{"$f":"IF(data!D27=\"فارغ\",\"\",data!D27)","v":"استاذ6"},{"$f":"IF(B13=\"\",\"\",data!E27)","v":"ا.ت.ث"},{"$f":"IF(B13=\"\",\"\",data!F27)","v":"لغة عربية"},7,14,1,29,null,null,null,6,null,null,2,19,7,null,null,null,14,null,0]
[7,{"$f":"IF(data!D28=\"فارغ\",\"\",data!D28)","v":"استاذ7"},{"$f":"IF(B14=\"\",\"\",data!E28)","v":"ا.ت.ث"},{"$f":"IF(B14=\"\",\"\",data!F28)","v":"لغة عربية"},6,12,2,29,null,null,null,7,null,null,null,18,6,null,28,null,null,null,1]
[8,{"$f":"IF(data!D29=\"فارغ\",\"\",data!D29)","v":"استاذ8"},{"$f":"IF(B15=\"\",\"\",data!E29)","v":"ا.ت.ث"},{"$f":"IF(B15=\"\",\"\",data!F29)","v":"رياضيات"},7,14,3,29,null,null,null,8,null,null,null,17,5,null,6,9,null,null,1]
[9,{"$f":"IF(data!D30=\"فارغ\",\"\",data!D30)","v":"استاذ9"},{"$f":"IF(B16=\"\",\"\",data!E30)","v":"ا.ت.ث"},{"$f":"IF(B16=\"\",\"\",data!F30)","v":"رياضيات"},7,14,4,29,null,null,null,9,null,null,null,16,4,null,7,15,null,null,1]
[10,{"$f":"IF(data!D31=\"فارغ\",\"\",data!D31)","v":"استاذ10"},{"$f":"IF(B17=\"\",\"\",data!E31)","v":"ا.ت.ث"},{"$f":"IF(B17=\"\",\"\",data!F31)","v":"رياضيات"},6,12,5,29,null,null,null,10,null,null,null,15,2,null,null,null,21,null,0]
[11,{"$f":"IF(data!D32=\"فارغ\",\"\",data!D32)","v":"استاذ11"},{"$f":"IF(B18=\"\",\"\",data!E32)","v":"ا.ت.ث"},{"$f":"IF(B18=\"\",\"\",data!F32)","v":"رياضيات"},6,12,6,19,null,null,null,11,null,null,null,14,29,null,27,null,null,null,1]
[12,{"$f":"IF(data!D33=\"فارغ\",\"\",data!D33)","v":"استاذ12"},{"$f":"IF(B19=\"\",\"\",data!E33)","v":"ا.ت.ث"},{"$f":"IF(B19=\"\",\"\",data!F33)","v":"رياضيات"},6,12,7,20,null,null,null,29,null,17,null,13,1,null,null,null,null,null,0]
[13,{"$f":"IF(data!D34=\"فارغ\",\"\",data!D34)","v":"استاذ13"},{"$f":"IF(B20=\"\",\"\",data!E34)","v":"ا.ت.ث"},{"$f":"IF(B20=\"\",\"\",data!F34)","v":"رياضيات"},6,12,8,21,null,null,null,29,null,16,null,12,null,null,null,12,null,null,0]
[14,{"$f":"IF(data!D35=\"فارغ\",\"\",data!D35)","v":"استاذ14"},{"$f":"IF(B21=\"\",\"\",data!E35)","v":"ا.ت.ث"},{"$f":"IF(B21=\"\",\"\",data!F35)","v":"انجليزية"},7,14,9,22,null,null,null,29,null,15,null,6,3,null,null,null,29,null,0]
[15,{"$f":"IF(data!D36=\"فارغ\",\"\",data!D36)","v":"استاذ15"},{"$f":"IF(B22=\"\",\"\",data!E36)","v":"ا.ت.ث"},{"$f":"IF(B22=\"\",\"\",data!F36)","v":"انجليزية"},7,14,10,23,null,null,null,29,null,14,null,7,13,null,null,null,29,null,0]
[16,{"$f":"IF(data!D37=\"فارغ\",\"\",data!D37)","v":"استاذ16"},{"$f":"IF(B23=\"\",\"\",data!E37)","v":"ا.ت.ث"},{"$f":"IF(B23=\"\",\"\",data!F37)","v":"انجليزية"},7,14,11,24,null,null,null,29,null,13,null,8,null,null,29,11,null,null,5]
[17,{"$f":"IF(data!D38=\"فارغ\",\"\",data!D38)","v":"استاذ17"},{"$f":"IF(B24=\"\",\"\",data!E38)","v":"ا.ت.ث"},{"$f":"IF(B24=\"\",\"\",data!F38)","v":"انجليزية"},7,14,12,1,null,null,null,null,29,12,null,9,null,null,29,10,null,null,5]
[18,{"$f":"IF(data!D39=\"فارغ\",\"\",data!D39)","v":"استاذ18"},{"$f":"IF(B25=\"\",\"\",data!E39)","v":"ا.ت.ث"},{"$f":"IF(B25=\"\",\"\",data!F39)","v":"انجليزية"},6,12,13,2,null,null,null,null,29,11,null,1,null,7,null,null,null,null,0]
[19,{"$f":"IF(data!D40=\"فارغ\",\"\",data!D40)","v":"استاذ19"},{"$f":"IF(B26=\"\",\"\",data!E40)","v":"ا.ت.ث"},{"$f":"IF(B26=\"\",\"\",data!F40)","v":"ع.اسلامية"},6,12,14,3,null,null,null,null,29,10,null,null,null,1,null,null,20,null,0]
[20,{"$f":"IF(data!D41=\"فارغ\",\"\",data!D41)","v":"استاذ20"},{"$f":"IF(B27=\"\",\"\",data!E41)","v":"ا.ت.ث"},{"$f":"IF(B27=\"\",\"\",data!F41)","v":"ع.اسلامية"},6,12,15,4,null,null,null,null,29,9,null,null,null,5,null,null,19,null,0]
[21,{"$f":"IF(data!D42=\"فارغ\",\"\",data!D42)","v":"استاذ21"},{"$f":"IF(B28=\"\",\"\",data!E42)","v":"ا.ت.ث"},{"$f":"IF(B28=\"\",\"\",data!F42)","v":"ع.اسلامية"},6,12,16,5,null,null,null,null,29,8,null,null,null,6,null,null,18,null,0]
[22,{"$f":"IF(data!D43=\"فارغ\",\"\",data!D43)","v":"استاذ22"},{"$f":"IF(B29=\"\",\"\",data!E43)","v":"ا.ت.ث"},{"$f":"IF(B29=\"\",\"\",data!F43)","v":"ع. طبيعية"},7,14,17,6,null,29,1,null,13,7,null,null,null,null,null,null,23,null,0]
[23,{"$f":"IF(data!D44=\"فارغ\",\"\",data!D44)","v":"استاذ23"},{"$f":"IF(B30=\"\",\"\",data!E44)","v":"ا.ت.ث"},{"$f":"IF(B30=\"\",\"\",data!F44)","v":"ع. طبيعية"},7,14,18,7,null,29,2,null,8,1,null,null,null,null,null,null,24,null,0]
[24,{"$f":"IF(data!D45=\"فارغ\",\"\",data!D45)","v":"استاذ24"},{"$f":"IF(B31=\"\",\"\",data!E45)","v":"ا.ت.ث"},{"$f":"IF(B31=\"\",\"\",data!F45)","v":"ع. طبيعية"},7,14,19,8,null,29,3,null,7,5,null,null,null,null,null,null,17,null,0]
[25,{"$f":"IF(data!D46=\"فارغ\",\"\",data!D46)","v":"استاذ25"},{"$f":"IF(B32=\"\",\"\",data!E46)","v":"ا.ت.ث"},{"$f":"IF(B32=\"\",\"\",data!F46)","v":"ع. طبيعية"},7,14,20,9,null,29,4,null,6,4,null,null,null,null,null,null,15,null,0]
[26,{"$f":"IF(data!D47=\"فارغ\",\"\",data!D47)","v":"استاذ26"},{"$f":"IF(B33=\"\",\"\",data!E47)","v":"ا.ت.ث"},{"$f":"IF(B33=\"\",\"\",data!F47)","v":"ع. طبيعية"},7,14,21,10,null,29,5,null,5,3,null,null,null,null,null,null,16,null,0]
[27,{"$f":"IF(data!D48=\"فارغ\",\"\",data!D48)","v":"استاذ27"},{"$f":"IF(B34=\"\",\"\",data!E48)","v":"ا.ت.ث"},{"$f":"IF(B34=\"\",\"\",data!F48)","v":"فرنسية"},7,14,22,11,null,14,6,null,4,2,null,null,null,null,29,null,null,null,5]
[28,{"$f":"IF(data!D49=\"فارغ\",\"\",data!D49)","v":"استاذ28"},{"$f":"IF(B35=\"\",\"\",data!E49)","v":"ا.ت.ث"},{"$f":"IF(B35=\"\",\"\",data!F49)","v":"فرنسية"},7,14,23,12,null,15,7,null,3,24,null,null,null,null,29,null,null,null,5]
[29,{"$f":"IF(data!D50=\"فارغ\",\"\",data!D50)","v":"استاذ29"},{"$f":"IF(B36=\"\",\"\",data!E50)","v":"ا.ت.ث"},{"$f":"IF(B36=\"\",\"\",data!F50)","v":"فرنسية"},7,14,24,13,null,16,8,null,2,23,null,null,null,null,29,null,null,null,5]
[30,{"$f":"IF(data!D51=\"فارغ\",\"\",data!D51)","v":"استاذ30"},{"$f":"IF(B37=\"\",\"\",data!E51)","v":"ا.ت.ث"},{"$f":"IF(B37=\"\",\"\",data!F51)","v":"فرنسية"},7,14,null,null,29,17,9,null,1,22,null,null,null,null,1,8,null,null,1]
[31,{"$f":"IF(data!D52=\"فارغ\",\"\",data!D52)","v":"استاذ31"},{"$f":"IF(B38=\"\",\"\",data!E52)","v":"ا.ت.ث"},{"$f":"IF(B38=\"\",\"\",data!F52)","v":"فرنسية"},7,14,null,null,29,18,10,null,9,21,null,null,null,null,5,7,null,null,1]
[32,{"$f":"IF(data!D53=\"فارغ\",\"\",data!D53)","v":"استاذ32"},{"$f":"IF(B39=\"\",\"\",data!E53)","v":"ا.ت.ث"},{"$f":"IF(B39=\"\",\"\",data!F53)","v":"تكنولوجيا"},7,14,null,null,29,19,11,null,12,20,null,null,null,8,null,29,null,null,0]
[33,{"$f":"IF(data!D54=\"فارغ\",\"\",data!D54)","v":"استاذ33"},{"$f":"IF(B40=\"\",\"\",data!E54)","v":"ا.ت.ث"},{"$f":"IF(B40=\"\",\"\",data!F54)","v":"اقتصاد"},{"$f":"COUNT(G40:U40)","v":7},{"$f":"SUMIFS($G$62:$U$62,G40:U40,\">0\")","v":14},null,null,29,20,12,null,11,19,null,null,null,9,null,29,null,null,{"$f":"COUNTIF(S:S,S40)","v":0}]
[34,{"$f":"IF(data!D55=\"فارغ\",\"\",data!D55)","v":"استاذ34"},{"$f":"IF(B41=\"\",\"\",data!E55)","v":"ا.ت.ث"},{"$f":"IF(B41=\"\",\"\",data!F55)","v":"اقتصاد"},7,14,null,null,29,21,13,null,10,18,null,null,null,10,null,2,null,null,0]
[35,{"$f":"IF(data!D56=\"فارغ\",\"\",data!D56)","v":"استاذ35"},{"$f":"IF(B42=\"\",\"\",data!E56)","v":"ا.ت.ث"},{"$f":"IF(B42=\"\",\"\",data!F56)","v":"فلسفة"},7,14,null,null,1,22,29,null,20,6,null,null,null,2,null,3,null,null,0]
[36,{"$f":"IF(data!D57=\"فارغ\",\"\",data!D57)","v":"استاذ36"},{"$f":"IF(B43=\"\",\"\",data!E57)","v":"ا.ت.ث"},{"$f":"IF(B43=\"\",\"\",data!F57)","v":"فلسفة"},7,14,null,null,2,23,29,null,18,null,null,null,null,11,8,4,null,null,1]
[37,{"$f":"IF(data!D58=\"فارغ\",\"\",data!D58)","v":"استاذ37"},{"$f":"IF(B44=\"\",\"\",data!E58)","v":"ا.ت.ث"},{"$f":"IF(B44=\"\",\"\",data!F58)","v":"فلسفة"},7,14,null,null,3,24,29,null,17,null,null,null,null,4,9,6,null,null,1]
[38,{"$f":"IF(data!D59=\"فارغ\",\"\",data!D59)","v":"استاذ38"},{"$f":"IF(B45=\"\",\"\",data!E59)","v":"ا.ت.ث"},{"$f":"IF(B45=\"\",\"\",data!F59)","v":"هـ.مدنية"},7,14,null,null,4,1,29,null,16,null,null,null,22,null,10,5,null,null,1]
[39,{"$f":"IF(data!D60=\"فارغ\",\"\",data!D60)","v":"استاذ39"},{"$f":"IF(B46=\"\",\"\",data!E60)","v":"ا.ت.ث"},{"$f":"IF(B46=\"\",\"\",data!F60)","v":"هـ.ميكانيكية"},7,14,null,null,5,2,29,null,15,null,null,null,18,null,11,1,null,null,1]
[40,{"$f":"IF(data!D61=\"فارغ\",\"\",data!D61)","v":"استاذ40"},{"$f":"IF(B47=\"\",\"\",data!E61)","v":"ا.ت.ث"},{"$f":"IF(B47=\"\",\"\",data!F61)","v":"هـ.طرائق"},7,14,null,null,6,3,24,null,14,29,null,null,19,null,12,null,null,null,1]
[41,{"$f":"IF(data!D62=\"فارغ\",\"\",data!D62)","v":"استاذ41"},{"$f":"IF(B48=\"\",\"\",data!E62)","v":"ا.ت.ث"},{"$f":"IF(B48=\"\",\"\",data!F62)","v":"كهرباء"},7,14,null,null,7,4,23,null,24,29,null,null,null,3,null,null,22,null,0,null,29,"يعني احتياط"]
[42,{"$f":"IF(data!D63=\"فارغ\",\"\",data!D63)","v":"استاذ42"},{"$f":"IF(B49=\"\",\"\",data!E63)","v":"ا.ت.ث"},{"$f":"IF(B49=\"\",\"\",data!F63)","v":"تاريخ"},6,12,null,null,8,null,14,null,23,29,null,null,null,null,14,22,null,null,1]
[43,{"$f":"IF(data!D64=\"فارغ\",\"\",data!D64)","v":"استاذ43"},{"$f":"IF(B50=\"\",\"\",data!E64)","v":"ا.ت.ث"},{"$f":"IF(B50=\"\",\"\",data!F64)","v":"تاريخ"},6,12,null,null,9,null,15,null,22,29,null,null,null,null,15,21,null,null,1]
[44,{"$f":"IF(data!D65=\"فارغ\",\"\",data!D65)","v":"استاذ44"},{"$f":"IF(B51=\"\",\"\",data!E65)","v":"ا.ت.ث"},{"$f":"IF(B51=\"\",\"\",data!F65)","v":"تاريخ"},6,12,null,null,10,null,16,null,21,29,null,null,null,null,16,20,null,null,1]
[45,{"$f":"IF(data!D66=\"فارغ\",\"\",data!D66)","v":"استاذ45"},{"$f":"IF(B52=\"\",\"\",data!E66)","v":"ا.ت.ث"},{"$f":"IF(B52=\"\",\"\",data!F66)","v":"تاريخ"},6,12,null,null,11,null,17,null,19,null,null,29,null,null,17,19,null,null,1]
[46,{"$f":"IF(data!D67=\"فارغ\",\"\",data!D67)","v":"استاذ46"},{"$f":"IF(B53=\"\",\"\",data!E67)","v":"ا.ت.ث"},{"$f":"IF(B53=\"\",\"\",data!F67)","v":"فيزياء"},7,14,null,null,null,9,18,null,null,null,3,10,29,null,21,13,null,null,1]
[47,{"$f":"IF(data!D68=\"فارغ\",\"\",data!D68)","v":"استاذ47"},{"$f":"IF(B54=\"\",\"\",data!E68)","v":"ا.ت.ث"},{"$f":"IF(B54=\"\",\"\",data!F68)","v":"فيزياء"},7,14,null,null,null,10,19,null,null,null,4,11,29,null,22,null,29,null,1]
[48,{"$f":"IF(data!D69=\"فارغ\",\"\",data!D69)","v":"استاذ48"},{"$f":"IF(B55=\"\",\"\",data!E69)","v":"ا.ت.ث"},{"$f":"IF(B55=\"\",\"\",data!F69)","v":"فيزياء"},7,14,null,null,null,11,20,null,null,null,5,29,16,null,23,null,29,null,1]
[49,{"$f":"IF(data!D70=\"فارغ\",\"\",data!D70)","v":"استاذ49"},{"$f":"IF(B56=\"\",\"\",data!E70)","v":"ا.ت.ث"},{"$f":"IF(B56=\"\",\"\",data!F70)","v":"فيزياء"},7,14,null,null,null,5,21,null,null,null,6,29,17,null,24,null,29,null,1]
[50,{"$f":"IF(data!D71=\"فارغ\",\"\",data!D71)","v":"استاذ50"},{"$f":"IF(B57=\"\",\"\",data!E71)","v":"ا.ت.ث"},{"$f":"IF(B57=\"\",\"\",data!F71)","v":"فيزياء"},7,14,null,null,null,6,22,null,null,null,7,4,29,null,25,null,29,null,1]
[51,{"$f":"IF(data!D72=\"فارغ\",\"\",data!D72)","v":"استاذ51"},{"$f":"IF(B58=\"\",\"\",data!E72)","v":"ا.ت.ث"},{"$f":"IF(B58=\"\",\"\",data!F72)","v":"فيزياء"},6,12,null,null,null,7,null,null,null,null,8,29,23,null,26,14,null,null,1]
[52,{"$f":"IF(data!D73=\"فارغ\",\"\",data!D73)","v":"استاذ52"},{"$f":"IF(B59=\"\",\"\",data!E73)","v":"ا.ت.ث"},{"$f":"IF(B59=\"\",\"\",data!F73)","v":"ا.الى"},6,12,null,null,null,8,null,null,null,null,9,2,20,null,18,29,null,null,1]
[53,{"$f":"IF(data!D74=\"فارغ\",\"\",data!D74)","v":"استاذ53"},{"$f":"IF(B60=\"\",\"\",data!E74)","v":"ا.ت.ث"},{"$f":"IF(B60=\"\",\"\",data!F74)","v":"ت.بدنية"},6,12,null,null,null,12,null,null,null,null,10,3,14,null,19,29,null,null,1]
[54,{"$f":"IF(data!D75=\"فارغ\",\"\",data!D75)","v":"استاذ54"},{"$f":"IF(B61=\"\",\"\",data!E75)","v":"ا.ت.ث"},{"$f":"IF(B61=\"\",\"\",data!F75)","v":"ت.بدنية"},6,12,null,null,null,13,null,null,null,null,11,5,15,null,20,29,null,null,1]
[null,null,null,null,15,{"$f":"SUM(F8:F61)","v":722},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]
[null,null,null,null,null,null,{"$f":"COUNT(G8:G61)","v":29},29,16,29,29,16,29,29,11,28,26,11,33,28,18]

{"sheet":"tab garde","index":2,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,6,0,10],[13,2,13,3],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[12,2,12,3]]}
[null,null,null,null,null,null,"عدد الساعات"]
[null,null,null,null,"الشعبة","عدد القاعات",{"$f":"gradeeta!#REF!","v":{"$error":"#REF!"}},{"$f":"G2+1","v":{"$error":"#REF!"}},{"$f":"H2+1","v":{"$error":"#REF!"}},{"$f":"I2+1","v":{"$error":"#REF!"}},{"$f":"J2+1","v":{"$error":"#REF!"}}]
[null,"السنة الأولى",11,null,"جذع مشترك اداب",3,2,4,2,4,4]
[null,"الثانية",11,null,"جذع مشترك علوم",8,2,4,2,4,6]
[null,"الثالثة",13,null,"الثانية علوم تجريبية",4,4,2,4,2,4]
[null,null,35,null,"الثانية رياضيات",1,4,2,4,2,4]
[null,null,null,null,"الثانية تقنى رياضي",1,4,2,4,2,4]
[null,"عدد الحراس الاجمالى",null,54,"الثانية لغات",1,4,2,4,2,2]
[null,"عدد قاعات الاختبار",null,{"$f":"F18","v":35},"الثانية اداب وفلسفة",2,4,2,4,2,4]
[null,"مجموع ساعات الامتحان فى كل القاعات",null,{"$f":"$G$18+$H$18+$I$18+$J$18+$K$18","v":600},"الثانية تسيير و اقتصاد",2,4,2,4,2,6]
[null,"عدد ساعات العمل للحراس",null,{"$f":"D10/D8","v":11.111111111111111},"الثالثة علوم تجريبية",4,4,4,4,4,2]
[null,null,null,null,"الثالثة رياضيات",1,4,4,4,4,2]
[null,null,{"$f":"\"يعمل \"& D8- MOD(D10,D8) &\" استـــاذ  \"& INT(D10/D8) &\"  ساعات\"","v":"يعمل 48 استـــاذ  11  ساعات"},null,"الثالثة تقنى رياضي",2,4,4,4,4,2]
[null,null,{"$f":"\"يعمل \"& MOD(D10,D8) &\" استـــاذ  \"& INT(D10/D8)+1 &\"  ساعات\"","v":"يعمل 6 استـــاذ  12  ساعات"},null,"الثالثة لغات",1,4,4,4,4]
[null,null,null,null,"الثالثة اداب وفلسفة",2,4,4,4,2]
[null,null,null,null,"الثالثة تسيير و اقتصاد",3,4,4,4,4,4]
[]
[null,null,null,null,"المجموع",{"$f":"SUM(F3:F17)","v":35},{"$f":"G3*$F$3+G4*$F$4+G5*$F$5+G6*$F$6+G7*$F$7+G8*$F$8+G9*$F$9+G10*$F$10+G11*$F$11+G12*$F$12+G13*$F$13+G14*$F$14+G15*$F$15+G16*$F$16","v":118},{"$f":"H3*$F$3+H4*$F$4+H5*$F$5+H6*$F$6+H7*$F$7+H8*$F$8+H9*$F$9+H10*$F$10+H11*$F$11+H12*$F$12+H13*$F$13+H14*$F$14+H15*$F$15+H16*$F$16","v":118},{"$f":"I3*$F$3+I4*$F$4+I5*$F$5+I6*$F$6+I7*$F$7+I8*$F$8+I9*$F$9+I10*$F$10+I11*$F$11+I12*$F$12+I13*$F$13+I14*$F$14+I15*$F$15+I16*$F$16","v":118},114,132]

{"sheet":"tabprof","index":3,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[[56,2,56,3],[56,6,56,7],[57,2,57,3],[57,6,57,7],[51,2,51,4],[51,6,51,7],[52,2,52,4],[52,6,52,7],[5,2,5,7],[23,2,23,7],[24,2,24,7],[55,2,55,4],[55,6,55,7],[54,3,54,4],[15,7,15,8],[37,7,37,8],[1,10,2,10],[1,11,2,11],[28,2,28,3],[28,6,28,7],[29,2,29,3],[29,6,29,7],[27,2,27,7],[1,2,1,7],[2,2,2,7],[6,2,6,3],[6,6,6,7],[7,2,7,3],[7,6,7,7]]}
[]
[null,null,null,null,null,null,null,null,null,null,1,{"$f":"$K$2+1","v":2}]
[]
[null,null,null,null,null,null,null,{"$f":"data!J2","v":"2022/2021"}]
[null,null,"ثانوية "]
[null,null,{"$f":"data!J1","v":"جدول حراسة اختبارات الفصل الأول"}]
[null,null,{"$f":"\"الاستاذ: \"&VLOOKUP($K$2,servproftot,2,FALSE)","v":"الاستاذ: استاذ1"}]
[null,null,{"$f":"\"المادة: \"&VLOOKUP($K$2,servproftot,4,FALSE)","v":"المادة: لغة عربية"}]
[null,null,"                   التوقيت  التاريخ","10-08","12-10","14-12","16-14","17-16"]
[null,null,{"$f":"data!$D$5","v":"2021-11-28"},{"$f":"IF(VLOOKUP($K$2,servproftot,7,FALSE), \"القاعة\"& VLOOKUP($K$2,servproftot,7,FALSE),\"\")","v":"القاعة29"},{"$f":"IF(VLOOKUP($K$2,servproftot,8,FALSE), \"القاعة\"&VLOOKUP($K$2,servproftot,8,FALSE),\"\")","v":"القاعة14"},null,{"$f":"IF(VLOOKUP($K$2,servproftot,9,FALSE), \"القاعة\"&VLOOKUP($K$2,servproftot,9,FALSE),\"\")","v":""}]
[null,null,{"$f":"data!$D$5+1","v":"2021-11-29"},{"$f":"IF(VLOOKUP($K$2,servproftot,10,FALSE), \"القاعة\"&VLOOKUP($K$2,servproftot,10,FALSE),\"\")","v":""},{"$f":"IF(VLOOKUP($K$2,servproftot,11,FALSE), \"القاعة\"&VLOOKUP($K$2,servproftot,11,FALSE),\"\")","v":""},null,{"$f":"IF(VLOOKUP($K$2,servproftot,12,FALSE), \"القاعة\"&VLOOKUP($K$2,servproftot,12,FALSE),\"\")","v":"القاعة1"}]
[null,null,{"$f":"data!$D$5+2","v":"2021-11-30"},{"$f":"IF(VLOOKUP($K$2,servproftot,13,FALSE), \"القاعة\"&VLOOKUP($K$2,servproftot,13,FALSE),\"\")","v":""},{"$f":"IF(VLOOKUP($K$2,servproftot,14,FALSE), \"القاعة\"&VLOOKUP($K$2,servproftot,14,FALSE),\"\")","v":""},null,{"$f":"IF(VLOOKUP($K$2,servproftot,15,FALSE), \"القاعة\"&VLOOKUP($K$2,servproftot,15,FALSE),\"\")","v":""}]
[null,null,{"$f":"data!$D$5+3","v":"2021-12-01"},{"$f":"IF(VLOOKUP($K$2,servproftot,16,FALSE), \"القاعة\"&VLOOKUP($K$2,servproftot,16,FALSE),\"\")","v":"القاعة24"},{"$f":"IF(VLOOKUP($K$2,servproftot,17,FALSE), \"القاعة\"&VLOOKUP($K$2,servproftot,17,FALSE),\"\")","v":"القاعة12"},null,{"$f":"IF(VLOOKUP($K$2,servproftot,18,FALSE), \"القاعة\"&VLOOKUP($K$2,servproftot,18,FALSE),\"\")","v":""}]
[null,null,{"$f":"data!$D$5+4","v":"2021-12-02"},{"$f":"IF(VLOOKUP($K$2,servproftot,19,FALSE), \"القاعة\"&VLOOKUP($K$2,servproftot,19,FALSE),\"\")","v":"القاعة2"},{"$f":"IF(VLOOKUP($K$2,servproftot,20,FALSE), \"القاعة\"&VLOOKUP($K$2,servproftot,20,FALSE),\"\")","v":"القاعة29"},null,{"$f":"IF(VLOOKUP($K$2,servproftot,21,FALSE), \"القاعة\"&VLOOKUP($K$2,servproftot,21,FALSE),\"\")","v":""}]
[]
[null,null,null,null,null,null,"........... فى ",{"$f":"TODAY()","v":"2021-11-08"}]
[]
[null,null,null,null,null,null,null,"الناظــر"]
[]
[]
[]
[]
[]
[null,null,"الجمهورية الجزائرية الديمقراطية الشعبية"]
[null,null,"وزارة التربية الوطنية"]
[null,null,"مديرية التربية بادرار",null,null,null,"السنة الدراسية:",{"$f":"H4","v":"2022/2021"}]
[null,null,"ثانوية "]
[null,null,{"$f":"C6","v":"جدول حراسة اختبارات الفصل الأول"}]
[null,null,{"$f":"\"الاستاذ: \"&VLOOKUP($L$2,servproftot,2,FALSE)","v":"الاستاذ: استاذ2"}]
[null,null,{"$f":"\"المادة: \"&VLOOKUP($L$2,servproftot,4,FALSE)","v":"المادة: لغة عربية"}]
[null,null,"                  التوقيت التاريخ","10-08","12-10","12-08","16-14","17-14"]
[null,null,{"$f":"data!$D$5","v":"2021-11-28"},{"$f":"IF(VLOOKUP($L$2,servproftot,7,FALSE), \"ق\"& VLOOKUP($L$2,servproftot,7,FALSE),\"\")","v":"ق29"},{"$f":"IF(VLOOKUP($L$2,servproftot,8,FALSE), \"القاعة\"&VLOOKUP($L$2,servproftot,8,FALSE),\"\")","v":"القاعة15"},{"$f":"IF(VLOOKUP($L$2,servproftot,10,FALSE), \"القاعة\"&VLOOKUP($L$2,servproftot,10,FALSE),\"\")","v":""},{"$f":"IF(VLOOKUP($L$2,servproftot,11,FALSE), \"القاعة\"& VLOOKUP($L$2,servproftot,11,FALSE),\"\")","v":""}]
[null,null,{"$f":"data!$D$5+1","v":"2021-11-29"},{"$f":"IF(VLOOKUP($L$2,servproftot,10,FALSE), \"القاعة\"&VLOOKUP($L$2,servproftot,10,FALSE),\"\")","v":""},{"$f":"IF(VLOOKUP($L$2,servproftot,11,FALSE), \"القاعة\"&VLOOKUP($L$2,servproftot,11,FALSE),\"\")","v":""},null,{"$f":"IF(VLOOKUP($L$2,servproftot,12,FALSE), \"القاعة\"&VLOOKUP($L$2,servproftot,12,FALSE),\"\")","v":"القاعة2"},{"$f":"IF(VLOOKUP($L$2,servproftot,18,FALSE), \"القاعة\"&VLOOKUP($L$2,servproftot,18,FALSE),\"\")","v":""}]
[null,null,{"$f":"data!$D$5+2","v":"2021-11-30"},{"$f":"IF(VLOOKUP($K$2,servproftot,13,FALSE), \"القاعة\"&VLOOKUP($K$2,servproftot,13,FALSE),\"\")","v":""},{"$f":"IF(VLOOKUP($K$2,servproftot,14,FALSE), \"القاعة\"&VLOOKUP($K$2,servproftot,14,FALSE),\"\")","v":""},null,{"$f":"IF(VLOOKUP($K$2,servproftot,15,FALSE), \"القاعة\"&VLOOKUP($K$2,servproftot,15,FALSE),\"\")","v":""}]
[null,null,{"$f":"data!$D$5+3","v":"2021-12-01"},{"$f":"IF(VLOOKUP($K$2,servproftot,16,FALSE), \"القاعة\"&VLOOKUP($K$2,servproftot,16,FALSE),\"\")","v":"القاعة24"},{"$f":"IF(VLOOKUP($K$2,servproftot,17,FALSE), \"القاعة\"&VLOOKUP($K$2,servproftot,17,FALSE),\"\")","v":"القاعة12"},null,{"$f":"IF(VLOOKUP($K$2,servproftot,18,FALSE), \"القاعة\"&VLOOKUP($K$2,servproftot,18,FALSE),\"\")","v":""}]
[null,null,{"$f":"data!$D$5+4","v":"2021-12-02"},{"$f":"IF(VLOOKUP($K$2,servproftot,19,FALSE), \"القاعة\"&VLOOKUP($K$2,servproftot,19,FALSE),\"\")","v":"القاعة2"},{"$f":"IF(VLOOKUP($K$2,servproftot,20,FALSE), \"القاعة\"&VLOOKUP($K$2,servproftot,20,FALSE),\"\")","v":"القاعة29"},null,{"$f":"IF(VLOOKUP($K$2,servproftot,21,FALSE), \"القاعة\"&VLOOKUP($K$2,servproftot,21,FALSE),\"\")","v":""}]
[]
[null,null,null,null,null,null,"................... فى ",{"$f":"TODAY()","v":"2021-11-08"}]
[]
[null,null,null,null,null,null,null,"النـــاظر"]

{"sheet":"gradeeta","index":4,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[[5,13,5,15],[2,14,2,15],[5,1,5,3],[5,4,5,6],[5,7,5,9],[5,10,5,12],[4,0,4,9],[0,11,0,16],[1,11,1,16],[0,0,0,9],[1,0,1,9]]}
[]
[]
[null,null,null,"ÇáÑÌÇÁ ÇáÇäÊÙÇÑ...",null,null,"السنة الدراسية",{"$f":"data!$J$2","v":"2022/2021"},null,null,null,null,"السنة الدراسية",null,{"$f":"data!$J$2","v":"2022/2021"}]
[]
[{"$f":"data!J1","v":"جدول حراسة اختبارات الفصل الأول"}]
[null,"2021-11-28",null,null,"2021-11-29",null,null,"2021-11-30",null,null,"2021-12-01",null,null,"2021-12-02"]
["1","10-08","12-10","16-14","10-08","12-10","16-14","10-08","12-10","16-14","10-08","12-10","16-14","10-08","12-10","16-14"]
["2"]
["3"]
["4"]
["5"]
["6"]
["7"]
["8"]
["9"]
["10"]
["11"]
["12"]
["13"]
["14"]
["15"]
["16"]
["17"]
["18"]
["19"]
["20"]
["21"]
["22"]
["23"]
["24"]
["25"]
["26"]
["27"]
["28"]
["29"]