{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["البيانات"],"not_rendered":{"charts":0,"images":1,"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":77,"n_cols":53,"rows_kept":77,"cut":false,"hidden":false,"merged":[[11,38,12,38],[11,44,12,44],[4,37,4,42],[4,43,4,48],[5,24,5,25],[5,37,6,37],[5,26,5,27],[7,38,8,38],[7,44,8,44],[9,38,10,38],[9,44,10,44],[5,38,6,38],[5,39,5,40],[5,44,6,44],[5,43,6,43],[3,22,3,35],[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],[4,22,5,23],[3,18,4,19],[5,18,5,19],[13,24,13,35],[3,37,3,48],[5,28,5,29],[4,24,4,29],[4,30,4,35],[5,30,5,31],[5,32,5,33],[5,34,5,35],[5,48,6,48],[5,45,5,46],[5,47,6,47],[5,41,6,41],[5,42,6,42],[15,34,15,35],[14,24,14,29],[14,30,14,35],[13,23,16,23],[15,24,15,25],[15,26,15,27],[15,28,15,29],[15,30,15,31],[15,32,15,33]]}
["م","الاسم","الاستثناءات","الصف الرابع",null,null,null,null,null,"الصف الخامس",null,null,null,null,null,null,null,null,null,null,"جزاكم الله كود رائع ولكن يوجد   نقطة  المدرس الى راقب فى لجنة لا يدخلها مرة ثانية "]
[null,null,null,{"$f":"Y6","v":"2017-07-27"},null,{"$f":"AA6","v":"2017-07-30"},null,{"$f":"AC6","v":"2017-08-01"},null,{"$f":"AE6","v":"2017-07-27"},null,{"$f":"AG6","v":"2017-07-30"},null,{"$f":"AI6","v":"2017-08-01"},null,null,null,null,null,null,"بمعنى المدرس  محمد خالد راقب فى اللجنة رقم 5 فى الصف الخامس لايوزع امامه مرة ثانية لجنة رقم 5 فى الصف الخامس انظر الى اول اسم هو محمد خالد"]
[null,null,null,"الفترة الاولى","الفترة الثانية","الفترة الاولى","الفترة الثانية","الفترة الاولى","الفترة الثانية","الفترة الاولى","الفترة الثانية","الفترة الاولى","الفترة الثانية","الفترة الاولى","الفترة الثانية",null,null,null,null,null,"ثانيا أسماء مراقبين الأدوار اود توزيعهم في جدول توزيع مراقبى الدور كما هو موضح بالجدول توزيع عشوائى اذا ضغطت على الزر مرة ثانية يقوم بتوزيعهم مرة ثانية وجزاكم الله خير الجزاء"]
[null,null,null,{"$f":"AQ8","v":"لغة عربية "},{"$f":"AQ9","v":"لغة انجليزية"},{"$f":"AQ10","v":"دراسات الاجتماعية"},{"$f":"AQ11","v":"علوم"},{"$f":"AQ12","v":"الرياضيات"},{"$f":"AQ13","v":"دين"},{"$f":"AW8","v":"لغة عربية "},{"$f":"AW9","v":"دين"},{"$f":"AW10","v":"علوم"},{"$f":"AW11","v":"لغة انجليزية"},{"$f":"AW12","v":"دراسات الاجتماعية"},{"$f":"AW13","v":"الرياضيات"},null,null,null,"توزيع اللجان ",null,null,null,"توزيع مراقبى الأدوار",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"جدول الامتحانات للصفين الرابع والخامس الابتدائى للعام 2018 / 2019",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"الصف الرابع"]
[1,"محمد خالد","الفترة الثانية",null,null,null,null,null,null,5,null,null,null,5,null,{"$f":"IF(OR(AND(D5>0,J5>0),AND(E5>0,K5>0),AND(F5>0,L5>0),AND(G5>0,M5>0),AND(H5>0,N5>0),AND(I5>0,O5>0)),\"خطأ\",\"\")","v":""},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,"الصف الخامس"]
[2,"محمود عبدالسلام","لغة عربية ",null,null,8,null,1,null,null,7,null,3,null,null,{"$f":"IF(OR(AND(D6>0,J6>0),AND(E6>0,K6>0),AND(F6>0,L6>0),AND(G6>0,M6>0),AND(H6>0,N6>0),AND(I6>0,O6>0)),\"خطأ\",\"\")","v":""},null,null,"بيانات اللجان",null,null,null,null,null,{"$f":"$AL$8","v":"2017-07-27"},null,{"$f":"$AL$10","v":"2017-07-30"},null,{"$f":"$AL$12","v":"2017-08-01"},null,{"$f":"$AR$8","v":"2017-07-27"},null,{"$f":"$AR$10","v":"2017-07-30"},null,{"$f":"$AR$12","v":"2017-08-01"},null,null,"التاريخ","اليوم","وقت الإجابة",null,"زمن الإجابة","المادة","التاريخ","اليوم","وقت الإجابة",null,"زمن الإجابة","المادة",null,null,null,"لغة عربية "]
[3,"خالد عبد الوهاب","الفترة الثانية",8,null,null,null,3,null,null,null,4,null,null,null,{"$f":"IF(OR(AND(D7>0,J7>0),AND(E7>0,K7>0),AND(F7>0,L7>0),AND(G7>0,M7>0),AND(H7>0,N7>0),AND(I7>0,O7>0)),\"خطأ\",\"\")","v":""},"الصف الخامس",null,"البيانات","عدد",null,null,"من","الى","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية",null,null,null,"من","الى",null,null,null,null,"من","الى",null,null,null,null,null,"دين"]
[4,"عصام محمود",null,null,4,8,null,null,null,2,null,null,1,null,null,"",8,null,"عدد الملاحظين",37,"مراقبين الأدوار",null,1,3,"عبدالباسط","محمد","احمد","السعيد","رضا","سامى","سامى","عبدالعال","نادر","حسن","عامر","هشام",null,"2017-07-27","الخميس","08:30:00","11:00:00","ساعتان ونصف","لغة عربية ","2017-07-27","الخميس","08:30:00","11:00:00","ساعتان ونصف","لغة عربية ",null,null,null,"علوم"]
[5,"رضا هاشم",null,6,null,null,null,5,null,null,null,5,7,null,null,"","غ",null,"عدد اللجان",8,"عبدالعال",null,4,6,"مسعد","نادر","عامر","عبدالباسط","السعيد","حسن","هشام","السعيد","مسعد","رضا","عبدالباسط","عبدالعال",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,4,5,null,null,6,3,null,null,8,4,null,"",null,null,"عدد أيام المراقبة",6,"سامى",null,7,8,"احمد","حسن","سامى","عبدالعال","محمد","احمد","رضا","عامر","هشام","محمد","نادر","مسعد",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,null,null,4,null,8,2,5,null,null,8,null,"",null,null,"عدد الملاحظين في كل لجنة",2,"محمد",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,5,null,null,null,1,null,null,null,1,1,null,2,"",null,null,"عدد مواد الامتحان ",12,"عبدالباسط",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,7,7,null,3,4,5,null,null,6,null,"",null,null,null,null,"رضا",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,8,null,6,null,null,3,null,5,null,"",null,null,null,null,"حسن",null,null,"ارقام اللجان","دليل توزيع اللجان"]
[11,"حاتم سعد",null,null,5,1,null,null,null,7,null,null,5,3,7,"",null,null,null,null,"احمد",null,null,null,"الصف الرابع",null,null,null,null,null,"الصف الخامس","الصف الخامس","الصف الخامس","الصف الخامس","الصف الخامس","الصف الخامس"]
[12,"وليد جبر",null,null,null,null,3,null,null,1,2,4,null,2,3,"",null,null,null,null,"عامر",null,null,null,{"$f":"$AL$8","v":"2017-07-27"},null,{"$f":"$AL$10","v":"2017-07-30"},null,{"$f":"$AL$12","v":"2017-08-01"},null,{"$f":"$AR$8","v":"2017-07-27"},null,{"$f":"$AR$10","v":"2017-07-30"},null,{"$f":"$AR$12","v":"2017-08-01"}]
[13,"مالك وجيه",null,1,null,null,4,3,null,null,3,6,null,null,7,"",null,null,null,null,"السعيد",null,null,null,"الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية"]
[14,"هاشم عبدالرحمن",null,8,2,null,null,null,null,null,null,8,7,3,2,"",null,null,null,null,"نادر",null,null,1,{"$f":"COUNTIF(D$5:D$68,1)","v":2},{"$f":"COUNTIF(E$5:E$68,1)","v":2},2,2,2,2,2,2,2,2,2,2]
[15,"صياد عبدالله",null,2,1,6,null,7,4,null,null,null,4,null,null,"",null,null,null,null,"هشام",null,null,2,{"$f":"COUNTIF(D$5:D$68,2)","v":2},{"$f":"COUNTIF(E$5:E$68,2)","v":2},2,2,2,2,2,2,2,2,2,2]
[16,"سعيد سويلم",null,1,7,5,null,6,1,null,null,null,5,null,null,"",null,null,null,null,null,null,null,3,{"$f":"COUNTIF(D$5:D$68,3)","v":2},{"$f":"COUNTIF(E$5:E$68,3)","v":2},2,2,2,2,2,2,2,2,2,{"$f":"COUNTIF(O$5:O$68,3)","v":2}]
[17,"حسن عبدربه",null,4,null,2,null,2,7,null,6,null,6,null,null,"",null,null,null,null,null,null,null,4,{"$f":"COUNTIF(D$5:D$68,4)","v":2},{"$f":"COUNTIF(E$5:E$68,4)","v":2},2,2,2,2,2,2,2,2,2,2]
[18,"ربيع محمد",null,null,6,null,6,4,7,null,null,null,null,null,null,"",null,null,null,null,null,null,null,5,{"$f":"COUNTIF(D$5:D$68,5)","v":2},{"$f":"COUNTIF(E$5:E$68,5)","v":2},2,2,2,2,2,2,2,2,2,2]
[19,"ناجى عبدالحى",null,6,null,null,5,8,null,null,2,null,null,null,5,"",null,null,null,null,null,null,null,6,{"$f":"COUNTIF(D$5:D$68,6)","v":2},{"$f":"COUNTIF(E$5:E$68,6)","v":2},2,2,2,2,2,2,2,2,2,2]
[20,"طه احمد",null,null,null,null,6,8,null,null,8,null,null,null,5,"",null,null,null,null,null,null,null,7,{"$f":"COUNTIF(D$5:D$68,7)","v":2},{"$f":"COUNTIF(E$5:E$68,7)","v":2},2,2,2,2,2,2,2,2,2,2]
[21,"مراد محمد",null,3,null,4,null,null,2,null,8,null,null,2,null,"",null,null,null,null,null,null,null,8,{"$f":"COUNTIF(D$5:D$68,8)","v":2},{"$f":"COUNTIF(E$5:E$68,8)","v":2},2,2,2,2,2,2,2,2,2,{"$f":"COUNTIF(O$5:O$68,8)","v":2}]
[22,"اسلام عبدالباسط",null,null,null,3,null,null,1,5,1,null,4,1,null,""]
[23,"هشام خويلد",null,7,1,null,null,null,null,null,null,8,6,null,8,""]
[24,"شريف نور",null,null,null,null,5,null,null,4,4,7,null,4,8,""]
[25,"جوده عوده",null,null,7,null,null,null,3,6,null,7,2,8,null,""]
[26,"احمد محمد",null,7,null,4,2,4,5,null,1,null,null,null,null,""]
[27,"منتصر عبدالسلام",null,null,null,null,1,null,null,8,7,1,null,6,6,""]
[28,"احمد مظهر",null,null,null,1,2,null,null,8,4,null,null,7,1,""]
[29,"ممدوح رضوان",null,5,null,null,3,null,null,null,6,6,null,7,3,""]
[30,"اسماعيل يسن",null,null,8,2,null,5,4,1,null,null,null,null,null,""]
[31,"محمد الوكيل",null,2,8,7,1,null,null,null,null,null,null,null,1,""]
[32,"ناصر الزيات",null,3,5,null,null,null,null,null,null,2,2,null,6,""]
[33,"رشدى اباظة",null,null,6,6,null,7,2,3,null,null,null,null,null,""]
[34,"فريد شوقى",null,null,3,3,8,null,null,null,null,null,null,1,4,""]
[35,"شوقى الخولى",null,null,2,null,7,6,8,6,null,3,null,null,null,""]
[36,"منصور طه",null,4,null,null,null,null,null,null,3,5,3,null,4,""]
[37,"عبدالمرضى الشيخ",null,null,3,null,null,2,5,7,null,2,8,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,""]
[]
[null,null,1]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
[null,null,8]