{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["البيانات"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":68,"n_cols":52,"rows_kept":68,"cut":false,"hidden":false,"merged":[[5,47,6,47],[5,44,5,45],[5,46,6,46],[5,40,6,40],[5,41,6,41],[5,27,5,28],[4,23,4,28],[5,29,5,30],[5,31,5,32],[5,33,5,34],[5,43,6,43],[5,42,6,42],[0,0,3,0],[0,2,3,2],[0,3,0,8],[0,9,0,14],[1,3,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,12],[1,13,1,14],[0,1,3,1],[3,18,4,19],[5,18,5,19],[3,36,3,47],[0,15,3,15],[3,23,3,34],[3,22,6,22],[11,37,12,37],[11,43,12,43],[4,36,4,41],[4,42,4,47],[5,23,5,24],[5,36,6,36],[5,25,5,26],[7,37,8,37],[7,43,8,43],[9,37,10,37],[9,43,10,43],[5,37,6,37],[5,38,5,39]]}
["م","الاسم","الاستثناءات","الصف الرابع",null,null,null,null,null,"الصف الخامس",null,null,null,null,null,"بيان التوزيع"]
[null,null,null,{"$f":"X6","v":"2017-07-27"},null,{"$f":"Z6","v":"2017-07-30"},null,{"$f":"AB6","v":"2017-08-01"},null,{"$f":"AD6","v":"2017-07-27"},null,{"$f":"AF6","v":"2017-07-30"},null,{"$f":"AH6","v":"2017-08-01"}]
[null,null,null,"الفترة الاولى","الفترة الثانية","الفترة الاولى","الفترة الثانية","الفترة الاولى","الفترة الثانية","الفترة الاولى","الفترة الثانية","الفترة الاولى","الفترة الثانية","الفترة الاولى","الفترة الثانية"]
[null,null,null,{"$f":"AP8","v":"لغة عربية "},{"$f":"AP9","v":"لغة انجليزية"},{"$f":"AP10","v":"دراسات الاجتماعية"},{"$f":"AP11","v":"علوم"},{"$f":"AP12","v":"الرياضيات"},{"$f":"AP13","v":"دين"},{"$f":"AV8","v":"لغة عربية "},{"$f":"AV9","v":"دين"},{"$f":"AV10","v":"علوم"},{"$f":"AV11","v":"لغة انجليزية"},{"$f":"AV12","v":"دراسات الاجتماعية"},{"$f":"AV13","v":"الرياضيات"},null,null,null,"توزيع اللجان ",null,null,null,"ارقام اللجان","دليل توزيع اللجان",null,null,null,null,null,null,null,null,null,null,null,null,"جدول الامتحانات للصفين الرابع والخامس الابتدائى للعام 2018 / 2019"]
[1,"محمد خالد","لغة عربية ",null,null,null,5,null,3,null,null,null,null,2,null,{"$f":"IF(COUNT(D5:O5)=$T$10,\"توزيع صحيح\",\"توزيع خاطئ\")","v":"توزيع خاطئ"},null,null,null,null,null,null,null,"الصف الرابع",null,null,null,null,null,"الصف الخامس","الصف الخامس","الصف الخامس","الصف الخامس","الصف الخامس","الصف الخامس",null,"جدول امتحانات الصف الرابع الابتدائى",null,null,null,null,null,"جدول امتحانات الصف الخامس الابتدائى"]
[2,"محمود عبدالسلام","دين",7,2,3,null,null,null,null,null,5,8,6,null,{"$f":"IF(COUNT(D6:O6)=$T$10,\"توزيع صحيح\",\"توزيع خاطئ\")","v":"توزيع صحيح"},null,null,"بيانات اللجان",null,null,null,null,{"$f":"$AK$8","v":"2017-07-27"},null,{"$f":"$AK$10","v":"2017-07-30"},null,{"$f":"$AK$12","v":"2017-08-01"},null,{"$f":"$AQ$8","v":"2017-07-27"},null,{"$f":"$AQ$10","v":"2017-07-30"},null,{"$f":"$AQ$12","v":"2017-08-01"},null,null,"التاريخ","اليوم","وقت الإجابة",null,"زمن الإجابة","المادة","التاريخ","اليوم","وقت الإجابة",null,"زمن الإجابة","المادة",null,null,null,"لغة عربية "]
[3,"خالد عبد الوهاب","الفترة الاولى",null,null,null,null,null,null,null,2,null,5,null,4,{"$f":"IF(COUNT(D7:O7)=$T$10,\"توزيع صحيح\",\"توزيع خاطئ\")","v":"توزيع خاطئ"},null,null,"البيانات","عدد",null,null,null,"الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية",null,null,null,"من","الى",null,null,null,null,"من","الى",null,null,null,null,null,"دين"]
[4,"عصام محمود","دراسات الاجتماعية",4,null,null,null,1,null,2,null,5,null,null,null,"توزيع خاطئ",null,null,"عدد الملاحظين",32,null,null,1,{"$f":"COUNTIF(D$5:D$68,$W8)","v":1},{"$f":"COUNTIF(E$5:E$68,$W8)","v":2},2,1,1,1,2,2,1,1,2,2,null,"2017-07-27","الخميس","08:30:00","11:00:00","ساعتان ونصف","لغة عربية ","2017-07-27","الخميس","08:30:00","11:00:00","ساعتان ونصف","لغة عربية ",null,null,null,"علوم"]
[5,"رضا هاشم",null,null,2,8,5,null,null,null,null,3,null,null,null,"توزيع خاطئ",null,null,"عدد اللجان",8,null,null,2,{"$f":"COUNTIF(D$5:D$68,$W9)","v":2},2,2,2,2,2,2,2,2,1,2,2,null,"2017-07-27",null,"11:30:00","01:00:00","ساعة ونصف","لغة انجليزية","2017-07-27",null,"11:30:00","01:00:00","ساعة ونصف","دين",null,null,null,"لغة انجليزية"]
[6,"عماد محمد",null,null,6,1,null,null,2,null,null,null,3,5,7,"توزيع صحيح",null,null,"عدد أيام المراقبة",6,null,null,3,1,2,2,2,1,2,2,0,2,1,2,2,null,"2017-07-30","الاحد","08:30:00","10:00:00","ساعة ونصف","دراسات الاجتماعية","2017-07-30","الاحد","08:30:00","10:00:00","ساعة ونصف","علوم",null,null,null,"دراسات الاجتماعية"]
[7,"فرحات منير",null,null,7,2,3,null,null,null,4,null,5,null,8,"توزيع صحيح",null,null,"عدد الملاحظين في كل لجنة",2,null,null,4,1,2,2,2,1,0,2,2,0,2,1,2,null,"2017-07-30",null,"10:30:00","12:00:00","ساعة ونصف","علوم","2017-07-30",null,"10:30:00","12:00:00","ساعة ونصف","لغة انجليزية",null,null,null,"الرياضيات"]
[8,"اشرف فتحى",null,1,null,4,null,null,3,null,5,2,null,null,8,"توزيع صحيح",null,null,"عدد مواد الامتحان ",12,null,null,5,2,1,2,2,1,2,0,2,2,2,2,1,null,"2017-08-01","الثلاثاء","08:30:00","10:00:00","ساعة ونصف","الرياضيات","2017-08-01","الثلاثاء","08:30:00","10:00:00","ساعة ونصف","دراسات الاجتماعية",null,null,null,"الفترة الاولى"]
[9,"اشرف ناجى",null,null,7,4,null,null,null,3,null,8,6,1,null,"توزيع صحيح",null,null,null,null,null,null,6,1,2,0,0,2,2,2,1,1,2,2,2,null,"2017-08-01",null,"10:30:00","12:00:00","ساعة ونصف","دين","2017-08-01",null,"10:30:00","12:00:00","ساعة ونصف","الرياضيات",null,null,null,"الفترة الثانية"]
[10,"ممدوح الوالى",null,8,null,5,null,null,null,4,1,null,7,null,6,"توزيع صحيح","استاذى الكريم السلام عليكم ورحمة الله وبركاته ارجو من سيادتكم ضبط ",null,null,null,null,null,7,1,2,1,1,2,2,2,0,2,2,2,2]
[11,"حاتم سعد",null,null,1,null,null,null,8,null,null,null,6,null,null,"توزيع خاطئ","هذا الكود هو يعمل معى ولكن يوجد به بعض المشاكل ",null,null,null,null,null,8,2,2,2,1,2,1,0,1,2,1,0,2]
[12,"وليد جبر",null,2,null,null,null,8,null,6,null,null,null,null,null,"توزيع خاطئ","عند توزيع ارقام اللجان  في جدول الصف الرابع وجدول الصف الخامس لابد ان يتكرر رقم اللجنة مرتيين"]
[13,"مالك وجيه",null,null,null,null,2,null,5,3,null,null,4,1,6,"توزيع صحيح","بمعنى رقم 1 لابد ان يتكرر مرتين رقم 2 لا بد ان يتكرر مرتين وهكذا في باقى اللجان"]
[14,"هاشم عبدالرحمن",null,null,5,8,1,4,null,null,null,null,null,3,2,"توزيع صحيح","ولكن الكود يقوم بتكرار بعض الأرقام مرتيين وبعضها مرة واحدة ويتخطى بعضها الاخر وهذا جدول يببن توزيع الأرقام عند توزيعها في الجدول "]
[15,"صياد عبدالله",null,null,null,5,null,2,null,1,null,6,null,7,3,"توزيع صحيح","وجزاكم الله خير"]
[16,"سعيد سويلم",null,6,null,1,null,null,null,2,null,null,null,null,5,"توزيع خاطئ"]
[17,"حسن عبدربه",null,null,3,null,null,7,6,null,null,2,1,null,4,"توزيع صحيح"]
[18,"ربيع محمد",null,null,6,null,null,2,null,null,null,null,null,7,null,"توزيع خاطئ"]
[19,"ناجى عبدالحى",null,null,null,2,3,null,7,4,null,null,null,null,null,"توزيع خاطئ"]
[20,"طه احمد",null,null,3,null,null,5,null,1,6,null,4,null,7,"توزيع صحيح"]
[21,"مراد محمد",null,2,1,null,4,6,null,null,8,7,null,null,null,"توزيع صحيح"]
[22,"اسلام عبدالباسط",null,8,null,null,4,null,1,null,2,7,null,null,null,"توزيع خاطئ"]
[23,"هشام خويلد",null,null,4,null,null,null,5,7,null,3,null,6,1,"توزيع صحيح"]
[24,"شريف نور",null,null,null,null,8,null,7,null,null,null,null,3,null,"توزيع خاطئ"]
[25,"جوده عوده",null,3,null,null,7,8,null,null,5,1,2,null,null,"توزيع صحيح"]
[26,"احمد محمد",null,null,4,7,null,null,null,null,null,8,null,5,2,"توزيع خاطئ"]
[27,"منتصر عبدالسلام",null,null,8,null,null,3,2,6,4,null,null,null,1,"توزيع صحيح"]
[28,"احمد مظهر",null,5,null,null,null,null,null,7,null,null,null,2,null,"توزيع خاطئ"]
[29,"ممدوح رضوان",null,5,8,3,2,7,6,null,null,null,null,null,null,"توزيع صحيح"]
[30,"اسماعيل يسن",null,null,null,null,null,null,null,null,null,null,null,null,3,"توزيع خاطئ"]
[31,"محمد الوكيل",null,null,null,null,null,null,null,null,null,null,7,4,null,"توزيع خاطئ"]
[32,"ناصر الزيات",null,null,null,null,null,6,null,null,1,null,null,null,null,"توزيع خاطئ"]
[33,"رشدى اباظة",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[34,"فريد شوقى",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[35,"شوقى الخولى",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[36,"منصور طه",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[37,"عبدالمرضى الشيخ",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[38,"نادر عبدالرحمن",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[39,"صلاح على",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[40,"احمد شاكر",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[41,"عبدالفتاح عبدالله",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[42,"محمد وليد",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[43,"طه بيومى",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[44,"كمال عامر",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[45,"رمضان خليل",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[46,"محسن جاد",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[47,"الهادى سعد",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[48,"عرفة حماد",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[49,"وائل ",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[50,"احمد جلال",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[51,"عامر احمد",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[52,"كريم محمد",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[53,"السيد رمضان",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[54,"بشير عبدالفتاح",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[55,"محمد مجدى",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[56,"صبحى",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[57,"حمدى",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[58,"احمد الصياد",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[59,"امام",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[60,"عدنان",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[61,"يوسف فهمى",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[62,"إسماعيل مصطفى",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[63,"يونس فرج",null,null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]
[64,"بلال حسن","الفترة الأولى",null,null,null,null,null,null,null,null,null,null,null,null,"توزيع خاطئ"]