{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ورقة1","عدد مرات استخدام اللجان"],"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":"ورقة1","index":0,"n_rows":77,"n_cols":53,"rows_kept":77,"cut":false,"hidden":false,"merged":[[9,44,10,44],[11,38,12,38],[11,44,12,44],[13,23,16,23],[13,24,13,35],[14,24,14,29],[14,30,14,35],[15,24,15,25],[15,26,15,27],[15,28,15,29],[15,30,15,31],[15,32,15,33],[15,34,15,35],[9,38,10,38],[5,44,6,44],[5,45,5,46],[5,47,6,47],[5,48,6,48],[7,38,8,38],[7,44,8,44],[5,43,6,43],[5,37,6,37],[5,38,6,38],[5,39,5,40],[5,41,6,41],[5,42,6,42],[5,34,5,35],[1,13,1,14],[3,18,4,19],[3,22,3,35],[3,37,3,48],[4,22,5,23],[4,24,4,29],[4,30,4,35],[4,37,4,42],[4,43,4,48],[5,18,5,19],[5,24,5,25],[5,26,5,27],[5,28,5,29],[5,30,5,31],[5,32,5,33],[0,0,3,0],[0,1,3,1],[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]]}
["م","الاسم","الاستثناءات","الصف الرابع",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,null,null,null,null,null,null,{"$f":"COLUMN()","v":25},null,null,null,null,null,{"$f":"COLUMN()","v":31}]
[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,8,null,null,null,8,4,null,6,null,null,{"$f":"COUNTA(D5:O5)","v":4},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,5,null,null,null,2,7,null,3,null,2,null,null,{"$f":"COUNTA(D6:O6)","v":5},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,"خالد عبد الوهاب",null,null,null,5,null,3,8,5,5,null,3,null,null,6,null,null,"البيانات","عدد",null,{"$f":"SUM((3*2*8*2)/32)","v":3},"من","الى","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية",null,null,null,"من","الى",null,null,null,null,"من","الى",null,null,null,null,null,"دين"]
[4,"عصام محمود",null,7,3,4,null,null,7,null,null,4,6,null,null,6,null,null,"عدد الملاحظين",32,null,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,null,5,7,null,8,null,2,null,3,7,null,3,7,null,null,"عدد اللجان",8,null,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,null,null,4,null,3,7,null,8,null,1,null,5,null,null,"عدد أيام المراقبة",6,null,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,7,null,1,8,null,null,null,6,null,null,4,7,6,null,null,"عدد الملاحظين في كل لجنة",2,null,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,null,1,4,5,null,1,6,null,null,null,8,null,6,null,null,"عدد مواد الامتحان ",12,null,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,7,null,null,1,5,7,null,6,3,null,null,6,null,null,null,null,null,"أيام الإمتحان 3 × فترتين × 8 لجان × 2 مراقب × صفين (4،5) = 192",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,2,3,8,4,2,4,null,null,null,2,7,"السلام عليكم أخي الكريم",null,null,null,null,"أيام الإمتحان 3 × فترتين × 8 لجان × 2 مراقب",null,"ارقام اللجان","دليل توزيع اللجان"]
[11,"حاتم سعد",null,5,8,2,null,null,6,null,2,null,2,4,null,7,"بعد مسح الاستثناءات ، غيرت عدد الملاحظين إلي التالي",null,null,null,null,"إجمالي 192 فترة مراقبة ÷ 34 = متوسط فترات المراقبة علي الملاحظ = 5.65",null,null,"الصف الرابع",null,null,null,null,null,"الصف الخامس","الصف الخامس","الصف الخامس","الصف الخامس","الصف الخامس","الصف الخامس"]
[12,"وليد جبر",null,2,null,5,2,null,1,null,3,null,null,8,3,7,"العدد نتيجة الكود",null,"المفروض 8 لحان يعمل على 32 ملاحظ والمفروض عند ادخال 9 لحان يعمل على 36 ملاحظ وهكذا مع زيادة اللجان او تقليلها",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,null,7,null,null,2,null,3,null,6,null,null,5,5,"37    يعمل",null,"36    يعمل","35   لا يعمل",null,null,"عدد مرات استخدام اللجان ↓↓",null,"الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية","الفترة الأولى","الفترة الثانية"]
[14,"هاشم عبدالرحمن",null,3,null,null,null,null,null,null,1,1,8,7,8,6,"34   لا  يعمل",null,"33   لا  يعمل","32   لا  يعمل",null,null,{"$f":"COUNTIF($D$5:$O$68,X18)","v":24},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,6,2,null,null,1,null,6,null,5,5,null,4,7,"38    يعمل",null,"39    يعمل","40    يعمل",null,null,{"$f":"COUNTIF($D$5:$O$68,X19)","v":24},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,8,6,null,6,2,null,null,null,4,null,null,6,"وأيضا",null,null,null,null,null,24,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,null,null,null,null,null,null,null,8,5,7,2,6,5,"بعد مسح الاستثناءات ، وتغيير اللجان الي 9 >> غيرت عدد الملاحظين إلي التالي",null,null,null,null,null,24,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,1,4,null,7,7,null,null,null,7,5,2,null,7,"العدد نتيجة الكود",null,null,null,null,null,24,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,8,3,1,6,null,5,null,null,null,null,3,4,7,"40    يعمل",null,"39    يعمل",null,null,null,24,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,2,8,null,5,null,1,5,null,4,5,null,7,"38    لا يعمل >> نفس العيب في الكود",null,null,null,null,null,24,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,2,4,6,1,null,4,null,null,null,null,1,null,6,null,null,null,null,null,null,24,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,6,null,null,null,null,8,null,7,4,1,3,null,6]
[23,"هشام خويلد",null,null,6,3,5,null,null,3,null,null,null,6,7,6]
[24,"شريف نور",null,null,null,null,2,3,null,1,8,1,null,6,5,7]
[25,"جوده عوده",null,8,6,null,8,6,null,null,null,2,null,null,2,6]
[26,"احمد محمد",null,4,null,null,6,7,null,null,1,2,null,null,8,6]
[27,"منتصر عبدالسلام",null,3,null,null,7,4,null,null,6,3,null,null,1,6]
[28,"احمد مظهر",null,null,null,null,null,null,2,4,null,null,8,5,null,4]
[29,"ممدوح رضوان",null,null,1,7,null,4,null,4,null,null,null,null,6,5]
[30,"اسماعيل يسن",null,null,null,null,3,5,null,null,7,8,null,null,1,5]
[31,"محمد الوكيل",null,4,5,3,4,null,6,8,null,null,null,null,null,6]
[32,"ناصر الزيات",null,null,null,null,1,null,3,5,2,7,1,7,null,7]
[33,"رشدى اباظة",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[34,"فريد شوقى",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[35,"شوقى الخولى",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[36,"منصور طه",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[37,"عبدالمرضى الشيخ"]
[38,"نادر عبدالرحمن"]
[39,"صلاح على"]
[40,"احمد شاكر"]
[41,"عبدالفتاح عبدالله"]
[42,"محمد وليد"]
[43,"طه بيومى"]
[44,"كمال عامر"]
[45,"رمضان خليل"]
[46,"محسن جاد"]
[47,"الهادى سعد"]
[48,"عرفة حماد"]
[49,"وائل "]
[50,"احمد جلال"]
[51,"عامر احمد"]
[52,"كريم محمد"]
[53,"السيد رمضان"]
[54,"بشير عبدالفتاح"]
[55,"محمد مجدى"]
[56,"صبحى"]
[57,"حمدى"]
[58,"احمد الصياد"]
[59,"امام"]
[60,"عدنان"]
[61,"يوسف فهمى"]
[62,"إسماعيل مصطفى"]
[63,"يونس فرج"]
[64,"بلال حسن","الفترة الأولى"]
[]
[null,null,1]
[null,null,2,{"$f":"MIN(D5:D68)","v":1},{"$f":"MIN(E5:E68)","v":1},1,1,1,1,1,1,1,1,1,1]
[null,null,3,{"$f":"MAX(D5:D68)","v":8},{"$f":"MAX(E5:E68)","v":8},8,8,8,8,8,8,8,8,8,8]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
[null,null,8]

{"sheet":"عدد مرات استخدام اللجان","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,4,5,4]]}
[]
[]
[null,null,null,null,"ارقام اللجان"]
[]
[]
[]
[null,null,null,null,1,{"$f":"COUNTIF(ورقة1!$D$5:$O$68,'عدد مرات استخدام اللجان'!E7)","v":24}]
[null,null,null,null,2,{"$f":"COUNTIF(ورقة1!$D$5:$O$68,'عدد مرات استخدام اللجان'!E8)","v":24}]
[null,null,null,null,3,{"$f":"COUNTIF(ورقة1!$D$5:$O$68,'عدد مرات استخدام اللجان'!E9)","v":24}]
[null,null,null,null,4,{"$f":"COUNTIF(ورقة1!$D$5:$O$68,'عدد مرات استخدام اللجان'!E10)","v":24}]
[null,null,null,null,5,{"$f":"COUNTIF(ورقة1!$D$5:$O$68,'عدد مرات استخدام اللجان'!E11)","v":24}]
[null,null,null,null,6,{"$f":"COUNTIF(ورقة1!$D$5:$O$68,'عدد مرات استخدام اللجان'!E12)","v":24}]
[null,null,null,null,7,{"$f":"COUNTIF(ورقة1!$D$5:$O$68,'عدد مرات استخدام اللجان'!E13)","v":24}]
[null,null,null,null,8,{"$f":"COUNTIF(ورقة1!$D$5:$O$68,'عدد مرات استخدام اللجان'!E14)","v":24}]