{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["االمطلوب 1","االمطلوب2"],"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":"االمطلوب 1","index":0,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[5,11,5,12],[1,7,3,10],[3,3,3,6],[5,1,5,2],[5,3,5,4],[5,5,5,6],[5,7,5,8],[5,9,5,10]]}
[null,null,null,"عدد القاعات","عدد الاساتدة","عدد مرات تكرار القاعة"]
[null,null,null,10,30,3,null,"المطلوب1 : كود توزيع ارقام عشوائية بحيث يمثل الرقم رقم القاعة . و انا اتحكم في عدد القاعات و عدد مرات تكرار القاعة حسب  عدد الأساتذة."]
[null,"القاعة رقم 1"]
[null,null,null,"جدول حراسة الامتحانات"]
[null,null,null,null,null,null,null,null,"لا يهم الترتيب"]
[null,"المعلمين",null,"اليوم 1",null,"اليوم 2",null,"اليوم 3",null,"اليوم 4",null,"اليوم 5"]
["الرقم","اللقب","الاسم ","الفترة الصباحية","الفترة المسائية","الفترة الصباحية","الفترة المسائية","الفترة الصباحية","الفترة المسائية","الفترة الصباحية","الفترة المسائية","الفترة الصباحية","الفترة المسائية"]
[1,"منتدى 1","اوفيسنا 1",1,6,6,10,3,6,7,3,10,8]
[2,"منتدى 2","اوفيسنا 2",10,4,8,3,8,9,5,4,7,9]
[3,"منتدى 3","اوفيسنا 3",9,3,1,6,7,8,10,1,5,10]
[4,"منتدى 4","اوفيسنا 4",2,7,5,8,10,2,1,9,9,5]
[5,"منتدى 5","اوفيسنا 5",8,8,9,9,1,5,4,10,1,7]
[6,"منتدى 6","اوفيسنا 6",4,9,10,7,5,7,3,7,3,6]
[7,"منتدى 7","اوفيسنا 7",6,1,7,5,4,10,9,6,2,4]
[8,"منتدى 8","اوفيسنا 8",7,10,3,4,2,3,8,2,6,3]
[9,"منتدى 9","اوفيسنا 9",5,5,2,2,9,1,6,5,4,2]
[10,"منتدى 10","اوفيسنا 10",3,2,4,1,6,4,2,8,8,1]
[11,"منتدى 11","اوفيسنا 11",8,2,3,10,4,10,5,4,3,10]
[12,"منتدى 12","اوفيسنا 12",7,5,7,5,3,5,4,6,7,9]
[13,"منتدى 13","اوفيسنا 13",9,3,1,2,6,3,8,7,8,3]
[14,"منتدى 14","اوفيسنا 14",3,7,9,9,2,2,2,9,2,7]
[15,"منتدى 15","اوفيسنا 15",10,9,6,3,9,6,7,3,4,5]
[16,"منتدى 16","اوفيسنا 16",1,6,5,6,1,1,6,10,1,8]
[17,"منتدى 17","اوفيسنا 17",5,4,4,4,7,8,9,8,5,2]
[18,"منتدى 18","اوفيسنا 18",6,8,8,7,10,7,3,1,9,1]
[19,"منتدى 19","اوفيسنا 19",2,10,2,8,5,9,10,5,10,4]
[20,"منتدى 20","اوفيسنا 20",4,1,10,1,8,4,1,2,6,6]
[21,"منتدى 21","اوفيسنا 21",8,4,5,3,9,2,4,10,8,7]
[22,"منتدى 22","اوفيسنا 22",10,1,8,5,2,8,1,9,4,9]
[23,"منتدى 23","اوفيسنا 23",9,10,1,6,3,6,3,5,1,10]
[24,"منتدى 24","اوفيسنا 24",3,8,3,10,8,5,2,8,3,2]
[25,"منتدى 25","اوفيسنا 25",7,9,4,7,5,1,7,2,10,5]
[26,"منتدى 26","اوفيسنا 26",1,2,2,4,4,10,8,7,6,4]
[27,"منتدى 27","اوفيسنا 27",6,7,9,1,7,9,10,6,9,8]
[28,"منتدى 28","اوفيسنا 28",2,3,10,2,1,3,5,4,5,3]
[29,"منتدى 29","اوفيسنا 29",4,6,6,9,10,4,9,1,2,1]
[30,"منتدى 30","اوفيسنا 30",5,5,7,8,6,7,6,3,7,6]

{"sheet":"االمطلوب2","index":1,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[[5,11,5,12],[0,7,3,10],[3,3,3,6],[5,1,5,2],[5,3,5,4],[5,5,5,6],[5,7,5,8],[5,9,5,10]]}
[null,null,null,"عدد القاعات","عدد الاساتدة","الأساتذة المتبقيين",null,"المطلوب2 : كود توزيع ارقام عشوائية من 1 الى 14. بحيث بعد توزيع العدد الموجود في الخلية D2 . يعيد  توزيع اربع قاعات عشوائية  (متغير حسب F2) عشوائية على  الأساتذة الأربعة المتبقيين "]
[null,null,null,14,18,{"$f":"E2-D2","v":4}]
[null,"القاعة رقم 1",null,"متغير","متغير","متغير"]
[null,null,null,"جدول حراسة الامتحانات"]
[]
[null,"المعلمين",null,"اليوم 1 ",null,"اليوم 2",null,"اليوم 3",null,"اليوم 4",null,"اليوم 5"]
["الرقم","اللقب","الاسم ","الفترة الصباحية","الفترة المسائية","الفترة الصباحية","الفترة المسائية","الفترة الصباحية","الفترة المسائية","الفترة الصباحية","الفترة المسائية","الفترة الصباحية","الفترة المسائية"]
[1,"منتدى 1","اوفيسنا 1",9,6,3,9,5,5,14,12,4,8]
[2,"منتدى 2","اوفيسنا 2",8,13,15,2,2,3,6,17,9,17]
[3,"منتدى 3","اوفيسنا 3",4,2,10,1,18,16,10,7,11,6]
[4,"منتدى 4","اوفيسنا 4",6,18,17,7,8,4,11,14,7,4]
[5,"منتدى 5","اوفيسنا 5",10,4,5,6,14,11,18,13,6,5]
[6,"منتدى 6","اوفيسنا 6",3,7,2,8,15,14,12,18,14,11]
[7,"منتدى 7","اوفيسنا 7",14,11,1,13,7,2,4,11,15,2]
[8,"منتدى 8","اوفيسنا 8",5,15,7,4,12,12,9,16,10,7]
[9,"منتدى 9","اوفيسنا 9",13,3,9,17,6,13,15,6,3,13]
[10,"منتدى 10","اوفيسنا 10",11,12,4,5,16,6,1,15,17,18]
[11,"منتدى 11","اوفيسنا 11",2,10,6,14,3,9,3,3,13,16]
[12,"منتدى 12","اوفيسنا 12",17,8,13,11,11,15,5,10,1,1]
[13,"منتدى 13","اوفيسنا 13",18,14,11,12,4,17,8,9,8,12]
[14,"منتدى 14","اوفيسنا 14",16,16,12,10,13,8,7,2,2,15]
[15,"منتدى 15","اوفيسنا 15","احتياط :1","احتياط :1","احتياط :8","احتياط :3","احتياط :1","احتياط :1","احتياط :2","احتياط :1","احتياط :5","احتياط :3"]
[16,"منتدى 16","اوفيسنا 16","احتياط :7","احتياط :5","احتياط :14","احتياط :15","احتياط :9","احتياط :7","احتياط :13","احتياط :4","احتياط :12","احتياط :9"]
[17,"منتدى 17","اوفيسنا 17","احتياط :12","احتياط :9","احتياط :16","احتياط :16","احتياط :10","احتياط :10","احتياط :16","احتياط :5","احتياط :16","احتياط :10"]
[18,"منتدى 18","اوفيسنا 18","احتياط :15","احتياط :17","احتياط :18","احتياط :18","احتياط :17","احتياط :18","احتياط :17","احتياط :8","احتياط :18","احتياط :14"]