{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["البيانات"],"not_rendered":{"charts":0,"images":0,"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":77,"n_cols":54,"rows_kept":77,"cut":false,"hidden":false,"merged":[[11,39,12,39],[11,45,12,45],[4,38,4,43],[4,44,4,49],[5,38,6,38],[7,39,8,39],[7,45,8,45],[9,39,10,39],[9,45,10,45],[5,39,6,39],[5,40,5,41],[5,45,6,45],[5,44,6,44],[5,25,5,26],[5,27,5,28],[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],[5,29,5,30],[5,31,5,32],[3,19,4,20],[5,19,5,20],[3,38,3,49],[5,49,6,49],[5,46,5,47],[5,48,6,48],[5,42,6,42],[5,43,6,43],[4,23,4,28],[4,29,4,34],[3,23,3,34],[3,22,6,22],[5,33,5,34],[5,23,5,24]]}
["م","الاسم","الاستثناءات","الصف الرابع",null,null,null,null,null,"الصف الخامس"]
[null,null,null,{"$f":"$X$6","v":"2019-07-27"},null,{"$f":"$Z$6","v":"2019-07-30"},null,{"$f":"$AB$6","v":"2019-08-01"},null,{"$f":"$AD$6","v":"2019-07-27"},null,{"$f":"$AF$6","v":"2019-07-30"},null,{"$f":"$AH$6","v":"2019-08-01"},null,null,"السلام عليكم ورحمة الله وبركاته بعد اذن استاذتى الكرام ارجو تنسيق شرطي لهذا الشيت"]
[null,null,null,"الفترة الاولى","الفترة الثانية","الفترة الاولى","الفترة الثانية","الفترة الاولى","الفترة الثانية","الفترة الاولى","الفترة الثانية","الفترة الاولى","الفترة الثانية","الفترة الاولى","الفترة الثانية",null,"يوجد عندى جدولين جدول للصف الرابع وجدول للصف الخامس أيام الامتحانات للصف الرابع هي نفس أيام امتحانات الصف"]
[null,null,null,{"$f":"AR8","v":"لغة عربية "},{"$f":"AR9","v":"لغة انجليزية"},{"$f":"AR10","v":"دراسات الاجتماعية"},{"$f":"AR11","v":"علوم"},{"$f":"AR12","v":"الرياضيات"},{"$f":"AR13","v":"دين"},{"$f":"AX8","v":"لغة عربية "},{"$f":"AX9","v":"دين"},{"$f":"AX10","v":"علوم"},{"$f":"AX11","v":"لغة انجليزية"},{"$f":"AX12","v":"دراسات الاجتماعية"},{"$f":"AX13","v":"الرياضيات"},null,"الخامس عند توزيع الأرقام ارجو تنبيهى عند وضع رقم لجنة في نفس اليوم من الصف الرابع مع الصف الخامس ",null,null,"توزيع اللجان ",null,null,"رقم اللجنة","دليل توزيع اللجان",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"جدول الامتحانات للصفين الرابع والخامس الابتدائى للعام 2018 / 2019"]
[1,"محمد خالد","لغة عربية ",7,null,null,8,6,null,null,4,3,null,2,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":"خطأ"},"كما هو موجود في مثال محمد خالد تم وضع لجنة له في الفترة الأولى من الصف الرابع في يوم 1/8/2019",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,3,4,null,null,null,5,null,2,null,1,5,{"$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":"خطأ"},"وتكرر أيضا وضع  لجنة له في الفترة الأولى من الصف الخامس في يوم  1/8/2019 وهذا يعتبر خطأ ان يتم وضع لجنتان في توقيت ",null,null,"بيانات اللجان",null,null,null,{"$f":"$AM$8","v":"2019-07-27"},null,{"$f":"$AM$10","v":"2019-07-30"},null,{"$f":"$AM$12","v":"2019-08-01"},null,{"$f":"$AS$8","v":"2019-07-27"},null,{"$f":"$AS$10","v":"2019-07-30"},null,{"$f":"$AS$12","v":"2019-08-01"},null,null,null,null,"التاريخ","اليوم","وقت الإجابة",null,"زمن الإجابة","المادة","التاريخ","اليوم","وقت الإجابة",null,"زمن الإجابة","المادة",null,null,null,"لغة عربية "]
[3,"خالد عبد الوهاب","الفترة الاولى",5,null,4,1,null,6,7,3,null,null,null,null,"خطأ","واحد في يوم واحداريد تنبهى عند هذا بتسيق شرطي",null,null,"البيانات","عدد",null,null,"الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية",null,null,null,null,null,"من","الى",null,null,null,null,"من","الى",null,null,null,null,null,"دين"]
[4,"عصام محمود",null,2,6,null,7,4,null,null,null,5,8,null,null,"خطأ","وقد وضعت مثالين اخرين لمحمود عبدالسلام وفرحات منير وجزاكم الله خير",null,null,"عدد الملاحظين",32,null,1,{"$f":"COUNTIF(D$5:D$68,1)","v":1},2,1,2,1,1,2,1,2,2,2,1,null,null,null,"2019-07-27","الخميس","08:30:00","11:00:00","ساعتان ونصف","لغة عربية ","2019-07-27","الخميس","08:30:00","11:00:00","ساعتان ونصف","لغة عربية ",null,null,null,"علوم"]
[5,"رضا هاشم",null,3,null,null,null,4,null,5,null,8,null,null,2,"خطأ",null,null,null,"عدد اللجان",8,null,2,{"$f":"COUNTIF(D$5:D$68,2)","v":2},2,2,1,1,1,2,0,3,1,2,2,null,null,null,"2019-07-27",null,"11:30:00","01:00:00","ساعة ونصف","لغة انجليزية","2019-07-27",null,"11:30:00","01:00:00","ساعة ونصف","دين",null,null,null,"لغة انجليزية"]
[6,"عماد محمد",null,null,3,2,4,7,6,null,null,1,null,null,null,"خطأ",null,null,null,"عدد أيام المراقبة",6,null,3,{"$f":"COUNTIF(D$5:D$68,3)","v":2},2,2,1,2,2,1,2,3,2,2,0,null,null,null,"2019-07-30","الاحد","08:30:00","10:00:00","ساعة ونصف","دراسات الاجتماعية","2019-07-30","الاحد","08:30:00","10:00:00","ساعة ونصف","علوم",null,null,null,"دراسات الاجتماعية"]
[7,"فرحات منير",null,4,8,null,7,null,null,3,null,null,null,2,null,"خطأ",null,null,null,"عدد الملاحظين في كل لجنة",2,null,4,{"$f":"COUNTIF(D$5:D$68,4)","v":1},1,2,2,2,2,1,3,1,2,0,2,null,null,null,"2019-07-30",null,"10:30:00","12:00:00","ساعة ونصف","علوم","2019-07-30",null,"10:30:00","12:00:00","ساعة ونصف","لغة انجليزية",null,null,null,"الرياضيات"]
[8,"اشرف فتحى",null,8,7,null,null,5,3,null,null,2,6,null,null,"",null,null,null,"عدد مواد الامتحان ",12,null,5,{"$f":"COUNTIF(D$5:D$68,5)","v":2},2,1,0,2,1,3,1,3,0,2,2,null,null,null,"2019-08-01","الثلاثاء","08:30:00","10:00:00","ساعة ونصف","الرياضيات","2019-08-01","الثلاثاء","08:30:00","10:00:00","ساعة ونصف","دراسات الاجتماعية",null,null,null,"الفترة الاولى"]
[9,"اشرف ناجى",null,8,null,null,3,null,null,null,5,null,7,1,2,"خطأ",null,null,null,null,null,null,6,{"$f":"COUNTIF(D$5:D$68,6)","v":1},2,2,2,1,2,0,2,2,1,2,1,null,null,null,"2019-08-01",null,"10:30:00","12:00:00","ساعة ونصف","دين","2019-08-01",null,"10:30:00","12:00:00","ساعة ونصف","الرياضيات",null,null,null,"الفترة الثانية"]
[10,"ممدوح الوالى",null,null,null,7,null,null,null,null,6,2,null,null,1,"خطأ",null,null,null,null,null,null,7,{"$f":"COUNTIF(D$5:D$68,7)","v":3},2,2,2,2,2,2,1,0,2,0,2]
[11,"حاتم سعد",null,null,6,null,1,3,5,null,8,null,7,null,null,"خطأ",null,null,null,null,null,null,8,{"$f":"COUNTIF(D$5:D$68,8)","v":2},2,0,3,1,1,0,1,1,1,2,2]
[12,"وليد جبر",null,6,null,5,4,null,null,null,null,null,1,3,8,"خطأ"]
[13,"مالك وجيه",null,2,7,null,null,3,8,null,null,6,null,null,null,""]
[14,"هاشم عبدالرحمن",null,null,null,null,2,null,null,null,null,1,3,8,5,"خطأ"]
[15,"صياد عبدالله",null,null,null,2,null,null,null,null,7,5,null,8,null,"خطأ"]
[16,"سعيد سويلم",null,null,null,null,8,null,7,1,6,null,null,3,null,""]
[17,"حسن عبدربه",null,null,null,null,null,null,7,2,1,null,null,null,null,""]
[18,"ربيع محمد",null,1,8,null,null,null,3,null,null,null,4,5,null,""]
[19,"ناجى عبدالحى",null,5,null,null,6,8,2,null,null,4,1,null,null,"خطأ"]
[20,"طه احمد",null,7,null,3,null,null,null,null,null,5,null,null,4,"خطأ"]
[21,"مراد محمد",null,null,4,6,null,null,null,1,null,null,null,null,null,""]
[22,"اسلام عبدالباسط",null,7,null,null,null,null,4,2,null,3,null,6,8,"خطأ"]
[23,"هشام خويلد",null,null,null,null,8,null,null,null,null,6,3,null,null,"خطأ"]
[24,"شريف نور",null,null,1,6,null,null,null,null,null,null,4,5,null,""]
[25,"جوده عوده",null,null,2,null,null,7,null,5,4,null,null,null,6,"خطأ"]
[26,"احمد محمد",null,3,1,7,null,2,null,null,null,null,null,null,null,""]
[27,"منتصر عبدالسلام",null,null,null,null,null,null,null,4,null,3,2,null,7,""]
[28,"احمد مظهر",null,null,2,3,null,1,null,null,4,null,null,null,null,"خطأ"]
[29,"ممدوح رضوان",null,null,null,null,6,5,1,7,null,null,null,null,null,""]
[30,"اسماعيل يسن",null,null,null,null,null,null,4,null,3,null,null,null,7,"خطأ"]
[31,"محمد الوكيل",null,null,5,1,null,null,null,null,null,null,null,6,4,""]
[32,"ناصر الزيات",null,null,5,null,null,null,null,null,null,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,""]
[]
[null,null,1]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
[null,null,8]