{"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":35,"n_cols":19,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,18],[1,7,1,18],[1,0,1,1],[12,0,12,1],[13,0,13,1],[14,0,19,1]]}
["توزيع الطلاب على اللجان"]
["بيانات الصفوف",null,"عدد اللجان",26,null,null,null,"نتائج التوزيع  "]
["الصف","عدد الطلاب",null,"رقم اللجنة","السعة",null,null,"لجنة","السعة","الرابع","الخامس","السادس","السابع","الثامن","التاسع","العاشر","الحادي عشر","المجموع","شاغر"]
["الرابع",10,null,1,14,null,null,1,14,1,1,1,1,2,3,2,3,{"$f":"SUM(J4:Q4)","v":14},{"$f":"I4-R4","v":0}]
["الخامس",20,null,2,14,null,null,2,14,1,1,1,1,2,3,2,3,{"$f":"SUM(J5:Q5)","v":14},{"$f":"I5-R5","v":0}]
["السادس",30,null,3,14,null,null,3,14,1,1,1,1,2,2,3,3,{"$f":"SUM(J6:Q6)","v":14},{"$f":"I6-R6","v":0}]
["السابع",40,null,4,14,null,null,4,14,1,1,1,1,2,2,3,3,{"$f":"SUM(J7:Q7)","v":14},{"$f":"I7-R7","v":0}]
["الثامن",50,null,5,14,null,null,5,14,1,0,2,1,2,2,3,3,{"$f":"SUM(J8:Q8)","v":14},{"$f":"I8-R8","v":0}]
["التاسع",60,null,6,14,null,null,6,14,1,0,2,1,2,2,3,3,{"$f":"SUM(J9:Q9)","v":14},{"$f":"I9-R9","v":0}]
["العاشر",70,null,7,14,null,null,7,14,1,0,2,1,2,2,3,3,{"$f":"SUM(J10:Q10)","v":14},{"$f":"I10-R10","v":0}]
["الحادي عشر",80,null,8,14,null,null,8,14,1,0,2,1,2,2,3,3,{"$f":"SUM(J11:Q11)","v":14},{"$f":"I11-R11","v":0}]
["الإجمالي",{"$f":"SUM(B4:B11)","v":360},{"$f":"B12/14","v":25.714285714285715},9,14,null,null,9,14,1,0,1,2,2,2,3,3,{"$f":"SUM(J12:Q12)","v":14},{"$f":"I12-R12","v":0}]
[null,null,{"$f":"14*25","v":350},10,14,null,null,10,14,1,0,1,2,2,2,3,3,{"$f":"SUM(J13:Q13)","v":14},{"$f":"I13-R13","v":0}]
[null,null,null,11,14,null,null,11,14,0,1,1,2,2,2,3,3,{"$f":"SUM(J14:Q14)","v":14},{"$f":"I14-R14","v":0}]
["المفروض ان تكون عدد اللجان 25 من 14 طالب واللجنة 26 يكون فيها  10 طلاب ",null,null,12,14,null,null,12,14,0,1,1,2,2,2,3,3,{"$f":"SUM(J15:Q15)","v":14},{"$f":"I15-R15","v":0}]
[null,null,null,13,14,null,null,13,14,0,1,1,2,2,2,3,3,{"$f":"SUM(J16:Q16)","v":14},{"$f":"I16-R16","v":0}]
[null,null,null,14,14,null,null,14,14,0,1,1,2,2,2,3,3,{"$f":"SUM(J17:Q17)","v":14},{"$f":"I17-R17","v":0}]
[null,null,null,15,14,null,null,15,14,0,1,1,2,2,2,3,3,{"$f":"SUM(J18:Q18)","v":14},{"$f":"I18-R18","v":0}]
[null,null,null,16,14,null,null,16,14,0,1,1,2,2,2,3,3,{"$f":"SUM(J19:Q19)","v":14},{"$f":"I19-R19","v":0}]
[null,null,null,17,14,null,null,17,14,0,1,1,2,2,2,3,3,{"$f":"SUM(J20:Q20)","v":14},{"$f":"I20-R20","v":0}]
[null,null,null,18,14,null,null,18,14,0,1,1,2,2,2,3,3,{"$f":"SUM(J21:Q21)","v":14},{"$f":"I21-R21","v":0}]
[null,null,null,19,14,null,null,19,14,0,1,1,2,2,2,3,3,{"$f":"SUM(J22:Q22)","v":14},{"$f":"I22-R22","v":0}]
[null,null,null,20,14,null,null,20,14,0,1,1,2,2,2,3,3,{"$f":"SUM(J23:Q23)","v":14},{"$f":"I23-R23","v":0}]
[null,null,null,21,14,null,null,21,14,0,1,1,2,1,3,2,4,{"$f":"SUM(J24:Q24)","v":14},{"$f":"I24-R24","v":0}]
[null,null,null,22,14,null,null,22,14,0,1,1,2,1,3,2,4,{"$f":"SUM(J25:Q25)","v":14},{"$f":"I25-R25","v":0}]
[null,null,null,23,14,null,null,23,14,0,1,1,1,2,3,2,3,{"$f":"SUM(J26:Q26)","v":13},{"$f":"I26-R26","v":1}]
[null,null,null,24,14,null,null,24,14,0,1,1,1,2,3,2,3,{"$f":"SUM(J27:Q27)","v":13},{"$f":"I27-R27","v":1}]
[null,null,null,25,14,null,null,25,14,0,1,1,1,2,3,2,3,{"$f":"SUM(J28:Q28)","v":13},{"$f":"I28-R28","v":1}]
[null,null,null,26,14,null,null,26,14,0,1,1,1,2,3,2,3,{"$f":"SUM(J29:Q29)","v":13},{"$f":"I29-R29","v":1}]
[null,null,null,null,null,null,null,null,"الإجمالي",{"$f":"SUM(J$4:J29)","v":10},{"$f":"SUM(K$4:K29)","v":20},{"$f":"SUM(L$4:L29)","v":30},{"$f":"SUM(M$4:M29)","v":40},{"$f":"SUM(N$4:N29)","v":50},{"$f":"SUM(O$4:O29)","v":60},{"$f":"SUM(P$4:P29)","v":70},{"$f":"SUM(Q$4:Q29)","v":80},{"$f":"SUM(R$4:R29)","v":360},{"$f":"SUM(S$4:S29)","v":4}]
[]
[]
[]
[]
[null,null,null,"مجموع اللجان",{"$f":"SUM(E4:E34)","v":364}]