{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["المخالفات","Sheet1"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":11,"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":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
["م","اسم الطالب","الصف","تاريخ المخالفة","درجة المخالفة","نوع المخالفة","الشهر","تكرار المخالفة","ملاحظات","الصفوف","تكرار","تنبيه","تعهد","إنذار"]
[{"$f":"IF(Table3[[#This Row],[اسم الطالب]]=\"\",\"\",ROW()-2)","v":1},"محمد1","10\\4","2021-09-06","الدرجة الأولى","مقاطعة المعلم","سبتمبر",{"$f":"IFERROR(IF(COUNTIFS($B$2:$B$230,B3,$E$2:$E$230,E3)>0,COUNTIFS($B$2:$B$230,B3,$E$2:$E$230,E3),\"\"),\"\")","v":2},"Header",{"$f":"IF(OR( Table3[[#This Row],[الصف]]=\"10\\1\", Table3[[#This Row],[الصف]]=\"10\\2\", Table3[[#This Row],[الصف]]=\"10\\3\", Table3[[#This Row],[الصف]]=\"10\\4\", Table3[[#This Row],[الصف]]=\"10\\5\", Table3[[#This Row],[الصف]]=\"10\\6\", Table3[[#This Row],[الصف]]=\"10\\7\"),\"العاشر\",IF(OR( Table3[[#This Row],[الصف]]=\"11\\1\", Table3[[#This Row],[الصف]]=\"11\\2\", Table3[[#This Row],[الصف]]=\"11\\3\", Table3[[#This Row],[الصف]]=\"11\\4\", Table3[[#This Row],[الصف]]=\"11\\5\", Table3[[#This Row],[الصف]]=\"11\\6\", Table3[[#This Row],[الصف]]=\"11\\7\",Table3[[#This Row],[الصف]]=\"11\\8\"),\"الحادي عشر\",IF(OR( Table3[[#This Row],[الصف]]=\"12\\1\", Table3[[#This Row],[الصف]]=\"12\\2\", Table3[[#This Row],[الصف]]=\"12\\3\", Table3[[#This Row],[الصف]]=\"12\\4\", Table3[[#This Row],[الصف]]=\"12\\5\", Table3[[#This Row],[الصف]]=\"12\\6\", Table3[[#This Row],[الصف]]=\"12\\7\",Table3[[#This Row],[الصف]]=\"12\\8\"),\"الثاني عشر\",\"\")))","v":"العاشر"},{"$f":"IF(D3=\"\",\"\",IF((TODAY()-D3)>1800,0,1))","v":1},null,"تعهد"]
[{"$f":"IF(Table3[[#This Row],[اسم الطالب]]=\"\",\"\",ROW()-2)","v":2},"محمد1","10\\3","2021-09-07T10:30:41.080","الدرجة الأولى","التأخير عن الحضور في الوقت المحدد لبدء الحصه الدراسية","سبتمبر",2,null,{"$f":"IF(OR( Table3[[#This Row],[الصف]]=\"10\\1\", Table3[[#This Row],[الصف]]=\"10\\2\", Table3[[#This Row],[الصف]]=\"10\\3\", Table3[[#This Row],[الصف]]=\"10\\4\", Table3[[#This Row],[الصف]]=\"10\\5\", Table3[[#This Row],[الصف]]=\"10\\6\", Table3[[#This Row],[الصف]]=\"10\\7\"),\"العاشر\",IF(OR( Table3[[#This Row],[الصف]]=\"11\\1\", Table3[[#This Row],[الصف]]=\"11\\2\", Table3[[#This Row],[الصف]]=\"11\\3\", Table3[[#This Row],[الصف]]=\"11\\4\", Table3[[#This Row],[الصف]]=\"11\\5\", Table3[[#This Row],[الصف]]=\"11\\6\", Table3[[#This Row],[الصف]]=\"11\\7\",Table3[[#This Row],[الصف]]=\"11\\8\"),\"الحادي عشر\",IF(OR( Table3[[#This Row],[الصف]]=\"12\\1\", Table3[[#This Row],[الصف]]=\"12\\2\", Table3[[#This Row],[الصف]]=\"12\\3\", Table3[[#This Row],[الصف]]=\"12\\4\", Table3[[#This Row],[الصف]]=\"12\\5\", Table3[[#This Row],[الصف]]=\"12\\6\", Table3[[#This Row],[الصف]]=\"12\\7\",Table3[[#This Row],[الصف]]=\"12\\8\"),\"الثاني عشر\",\"\")))","v":"العاشر"},1,null,"تعهد"]
[{"$f":"IF(Table3[[#This Row],[اسم الطالب]]=\"\",\"\",ROW()-2)","v":3},"محمد3","10\\3","2021-09-13T09:30:05.030","الدرجة الثانية","عدم اداء الواجبات المدرسية","سبتمبر",2,null,{"$f":"IF(OR( Table3[[#This Row],[الصف]]=\"10\\1\", Table3[[#This Row],[الصف]]=\"10\\2\", Table3[[#This Row],[الصف]]=\"10\\3\", Table3[[#This Row],[الصف]]=\"10\\4\", Table3[[#This Row],[الصف]]=\"10\\5\", Table3[[#This Row],[الصف]]=\"10\\6\", Table3[[#This Row],[الصف]]=\"10\\7\"),\"العاشر\",IF(OR( Table3[[#This Row],[الصف]]=\"11\\1\", Table3[[#This Row],[الصف]]=\"11\\2\", Table3[[#This Row],[الصف]]=\"11\\3\", Table3[[#This Row],[الصف]]=\"11\\4\", Table3[[#This Row],[الصف]]=\"11\\5\", Table3[[#This Row],[الصف]]=\"11\\6\", Table3[[#This Row],[الصف]]=\"11\\7\",Table3[[#This Row],[الصف]]=\"11\\8\"),\"الحادي عشر\",IF(OR( Table3[[#This Row],[الصف]]=\"12\\1\", Table3[[#This Row],[الصف]]=\"12\\2\", Table3[[#This Row],[الصف]]=\"12\\3\", Table3[[#This Row],[الصف]]=\"12\\4\", Table3[[#This Row],[الصف]]=\"12\\5\", Table3[[#This Row],[الصف]]=\"12\\6\", Table3[[#This Row],[الصف]]=\"12\\7\",Table3[[#This Row],[الصف]]=\"12\\8\"),\"الثاني عشر\",\"\")))","v":"العاشر"},1,null,"تعهد"]
[null,"محمد3","10\\3","2021-09-13T09:30:05.030","الدرجة الثانية","عدم اداء الواجبات المدرسية","سبتمبر",2,null,null,null,null,"تعهد"]
[null,"محمد4","10\\3","2021-09-13T09:30:05.030","الدرجة الثانية","عدم اداء الواجبات المدرسية","سبتمبر",1,null,null,null,"تنبيه"]
[null,"محمد5","10\\3","2021-09-13T09:30:05.030","الدرجة الثانية","عدم اداء الواجبات المدرسية","سبتمبر",2,null,null,null,"تنبيه","تعهد"]
[null,"محمد6","10\\3","2021-09-13T09:30:05.030","الدرجة الثانية","عدم اداء الواجبات المدرسية",null,2,null,null,null,"تنبيه","تعهد"]
[null,"محمد5","10\\3","2021-09-13T09:30:05.030","الدرجة الثانية","عدم اداء الواجبات المدرسية",null,2,null,null,null,null,"تعهد"]
[null,"محمد6","10\\3","2021-09-13T09:30:05.030","الدرجة الثانية","عدم اداء الواجبات المدرسية",null,2,null,null,null,null,"تعهد"]
[null,null,null,null,null,null,null,""]
[{"$f":"IF(Table3[[#This Row],[اسم الطالب]]=\"\",\"\",ROW()-2)","v":""},null,null,null,null,null,null,{"$f":"IFERROR(IF(COUNTIFS($B$2:$B$230,B13,$E$2:$E$230,E13)>0,COUNTIFS($B$2:$B$230,B13,$E$2:$E$230,E13),\"\"),\"\")","v":""},null,{"$f":"IF(OR( Table3[[#This Row],[الصف]]=\"10\\1\", Table3[[#This Row],[الصف]]=\"10\\2\", Table3[[#This Row],[الصف]]=\"10\\3\", Table3[[#This Row],[الصف]]=\"10\\4\", Table3[[#This Row],[الصف]]=\"10\\5\", Table3[[#This Row],[الصف]]=\"10\\6\", Table3[[#This Row],[الصف]]=\"10\\7\"),\"العاشر\",IF(OR( Table3[[#This Row],[الصف]]=\"11\\1\", Table3[[#This Row],[الصف]]=\"11\\2\", Table3[[#This Row],[الصف]]=\"11\\3\", Table3[[#This Row],[الصف]]=\"11\\4\", Table3[[#This Row],[الصف]]=\"11\\5\", Table3[[#This Row],[الصف]]=\"11\\6\", Table3[[#This Row],[الصف]]=\"11\\7\",Table3[[#This Row],[الصف]]=\"11\\8\"),\"الحادي عشر\",IF(OR( Table3[[#This Row],[الصف]]=\"12\\1\", Table3[[#This Row],[الصف]]=\"12\\2\", Table3[[#This Row],[الصف]]=\"12\\3\", Table3[[#This Row],[الصف]]=\"12\\4\", Table3[[#This Row],[الصف]]=\"12\\5\", Table3[[#This Row],[الصف]]=\"12\\6\", Table3[[#This Row],[الصف]]=\"12\\7\",Table3[[#This Row],[الصف]]=\"12\\8\"),\"الثاني عشر\",\"\")))","v":""},{"$f":"IF(D13=\"\",\"\",IF((TODAY()-D13)>1800,0,1))","v":""}]
[{"$f":"IF(Table3[[#This Row],[اسم الطالب]]=\"\",\"\",ROW()-2)","v":""},null,null,null,null,null,null,"",null,{"$f":"IF(OR( Table3[[#This Row],[الصف]]=\"10\\1\", Table3[[#This Row],[الصف]]=\"10\\2\", Table3[[#This Row],[الصف]]=\"10\\3\", Table3[[#This Row],[الصف]]=\"10\\4\", Table3[[#This Row],[الصف]]=\"10\\5\", Table3[[#This Row],[الصف]]=\"10\\6\", Table3[[#This Row],[الصف]]=\"10\\7\"),\"العاشر\",IF(OR( Table3[[#This Row],[الصف]]=\"11\\1\", Table3[[#This Row],[الصف]]=\"11\\2\", Table3[[#This Row],[الصف]]=\"11\\3\", Table3[[#This Row],[الصف]]=\"11\\4\", Table3[[#This Row],[الصف]]=\"11\\5\", Table3[[#This Row],[الصف]]=\"11\\6\", Table3[[#This Row],[الصف]]=\"11\\7\",Table3[[#This Row],[الصف]]=\"11\\8\"),\"الحادي عشر\",IF(OR( Table3[[#This Row],[الصف]]=\"12\\1\", Table3[[#This Row],[الصف]]=\"12\\2\", Table3[[#This Row],[الصف]]=\"12\\3\", Table3[[#This Row],[الصف]]=\"12\\4\", Table3[[#This Row],[الصف]]=\"12\\5\", Table3[[#This Row],[الصف]]=\"12\\6\", Table3[[#This Row],[الصف]]=\"12\\7\",Table3[[#This Row],[الصف]]=\"12\\8\"),\"الثاني عشر\",\"\")))","v":""},""]
[{"$f":"IF(Table3[[#This Row],[اسم الطالب]]=\"\",\"\",ROW()-2)","v":""},null,null,null,null,null,null,"",null,{"$f":"IF(OR( Table3[[#This Row],[الصف]]=\"10\\1\", Table3[[#This Row],[الصف]]=\"10\\2\", Table3[[#This Row],[الصف]]=\"10\\3\", Table3[[#This Row],[الصف]]=\"10\\4\", Table3[[#This Row],[الصف]]=\"10\\5\", Table3[[#This Row],[الصف]]=\"10\\6\", Table3[[#This Row],[الصف]]=\"10\\7\"),\"العاشر\",IF(OR( Table3[[#This Row],[الصف]]=\"11\\1\", Table3[[#This Row],[الصف]]=\"11\\2\", Table3[[#This Row],[الصف]]=\"11\\3\", Table3[[#This Row],[الصف]]=\"11\\4\", Table3[[#This Row],[الصف]]=\"11\\5\", Table3[[#This Row],[الصف]]=\"11\\6\", Table3[[#This Row],[الصف]]=\"11\\7\",Table3[[#This Row],[الصف]]=\"11\\8\"),\"الحادي عشر\",IF(OR( Table3[[#This Row],[الصف]]=\"12\\1\", Table3[[#This Row],[الصف]]=\"12\\2\", Table3[[#This Row],[الصف]]=\"12\\3\", Table3[[#This Row],[الصف]]=\"12\\4\", Table3[[#This Row],[الصف]]=\"12\\5\", Table3[[#This Row],[الصف]]=\"12\\6\", Table3[[#This Row],[الصف]]=\"12\\7\",Table3[[#This Row],[الصف]]=\"12\\8\"),\"الثاني عشر\",\"\")))","v":""},""]
[{"$f":"IF(Table3[[#This Row],[اسم الطالب]]=\"\",\"\",ROW()-2)","v":""},null,null,null,null,null,null,"",null,{"$f":"IF(OR( Table3[[#This Row],[الصف]]=\"10\\1\", Table3[[#This Row],[الصف]]=\"10\\2\", Table3[[#This Row],[الصف]]=\"10\\3\", Table3[[#This Row],[الصف]]=\"10\\4\", Table3[[#This Row],[الصف]]=\"10\\5\", Table3[[#This Row],[الصف]]=\"10\\6\", Table3[[#This Row],[الصف]]=\"10\\7\"),\"العاشر\",IF(OR( Table3[[#This Row],[الصف]]=\"11\\1\", Table3[[#This Row],[الصف]]=\"11\\2\", Table3[[#This Row],[الصف]]=\"11\\3\", Table3[[#This Row],[الصف]]=\"11\\4\", Table3[[#This Row],[الصف]]=\"11\\5\", Table3[[#This Row],[الصف]]=\"11\\6\", Table3[[#This Row],[الصف]]=\"11\\7\",Table3[[#This Row],[الصف]]=\"11\\8\"),\"الحادي عشر\",IF(OR( Table3[[#This Row],[الصف]]=\"12\\1\", Table3[[#This Row],[الصف]]=\"12\\2\", Table3[[#This Row],[الصف]]=\"12\\3\", Table3[[#This Row],[الصف]]=\"12\\4\", Table3[[#This Row],[الصف]]=\"12\\5\", Table3[[#This Row],[الصف]]=\"12\\6\", Table3[[#This Row],[الصف]]=\"12\\7\",Table3[[#This Row],[الصف]]=\"12\\8\"),\"الثاني عشر\",\"\")))","v":""},""]
[{"$f":"IF(Table3[[#This Row],[اسم الطالب]]=\"\",\"\",ROW()-2)","v":""},null,null,null,null,null,null,"",null,{"$f":"IF(OR( Table3[[#This Row],[الصف]]=\"10\\1\", Table3[[#This Row],[الصف]]=\"10\\2\", Table3[[#This Row],[الصف]]=\"10\\3\", Table3[[#This Row],[الصف]]=\"10\\4\", Table3[[#This Row],[الصف]]=\"10\\5\", Table3[[#This Row],[الصف]]=\"10\\6\", Table3[[#This Row],[الصف]]=\"10\\7\"),\"العاشر\",IF(OR( Table3[[#This Row],[الصف]]=\"11\\1\", Table3[[#This Row],[الصف]]=\"11\\2\", Table3[[#This Row],[الصف]]=\"11\\3\", Table3[[#This Row],[الصف]]=\"11\\4\", Table3[[#This Row],[الصف]]=\"11\\5\", Table3[[#This Row],[الصف]]=\"11\\6\", Table3[[#This Row],[الصف]]=\"11\\7\",Table3[[#This Row],[الصف]]=\"11\\8\"),\"الحادي عشر\",IF(OR( Table3[[#This Row],[الصف]]=\"12\\1\", Table3[[#This Row],[الصف]]=\"12\\2\", Table3[[#This Row],[الصف]]=\"12\\3\", Table3[[#This Row],[الصف]]=\"12\\4\", Table3[[#This Row],[الصف]]=\"12\\5\", Table3[[#This Row],[الصف]]=\"12\\6\", Table3[[#This Row],[الصف]]=\"12\\7\",Table3[[#This Row],[الصف]]=\"12\\8\"),\"الثاني عشر\",\"\")))","v":""},""]
[{"$f":"IF(Table3[[#This Row],[اسم الطالب]]=\"\",\"\",ROW()-2)","v":""},null,null,null,null,null,null,"",null,{"$f":"IF(OR( Table3[[#This Row],[الصف]]=\"10\\1\", Table3[[#This Row],[الصف]]=\"10\\2\", Table3[[#This Row],[الصف]]=\"10\\3\", Table3[[#This Row],[الصف]]=\"10\\4\", Table3[[#This Row],[الصف]]=\"10\\5\", Table3[[#This Row],[الصف]]=\"10\\6\", Table3[[#This Row],[الصف]]=\"10\\7\"),\"العاشر\",IF(OR( Table3[[#This Row],[الصف]]=\"11\\1\", Table3[[#This Row],[الصف]]=\"11\\2\", Table3[[#This Row],[الصف]]=\"11\\3\", Table3[[#This Row],[الصف]]=\"11\\4\", Table3[[#This Row],[الصف]]=\"11\\5\", Table3[[#This Row],[الصف]]=\"11\\6\", Table3[[#This Row],[الصف]]=\"11\\7\",Table3[[#This Row],[الصف]]=\"11\\8\"),\"الحادي عشر\",IF(OR( Table3[[#This Row],[الصف]]=\"12\\1\", Table3[[#This Row],[الصف]]=\"12\\2\", Table3[[#This Row],[الصف]]=\"12\\3\", Table3[[#This Row],[الصف]]=\"12\\4\", Table3[[#This Row],[الصف]]=\"12\\5\", Table3[[#This Row],[الصف]]=\"12\\6\", Table3[[#This Row],[الصف]]=\"12\\7\",Table3[[#This Row],[الصف]]=\"12\\8\"),\"الثاني عشر\",\"\")))","v":""},""]

{"sheet":"Sheet1","index":1,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[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,"عدم الإلتزام بنظم الحافلات",null,"حيازة واستخدام الأسلحة"]
[null,null,null,null,"عدم الاهتمام بالمظهر العام"]