{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ورقة1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":29,"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":20,"n_cols":37,"rows_kept":20,"cut":false,"hidden":false,"merged":[[17,18,22,32],[0,25,0,29],[2,24,11,24],[2,31,11,31],[0,32,0,36],[0,18,0,22],[14,18,15,22],[2,2,11,2],[0,3,0,7],[0,10,0,14],[2,9,11,9],[16,5,16,7],[16,2,16,3],[17,2,17,3],[18,2,18,3],[2,17,11,17]]}
["المندوب",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,null,"مناطق المندوب عبدالله"]
["احمد",null,"المندوب","احمد","مصر ","عمان","ليبيا","الامارات",null,"المندوب","محمد","السعوديه","اليمن","السودان","سوريا",null,null,"المندوب","علي","لبنان","قطر","الكويت","البحرين",null,"المندوب","توفيق","الأردن","تركيا","العراق","تونس",null,"المندوب","عبدالله","الجزائر","المغرب","سوريا ","الامارات"]
["محمد",null,"فروع المندوب احمد","الفرع 1","القاهره","صلالة","ليبيا 1","أبو ظبي",null,"فروع المندوب محمد","الفرع 1","جده","صنعاء","الخرطوم","دمشق",null,null,"فروع المندوب علي","الفرع 1","لبنان 1","قطر 1","الكوت 1","البحرين",null,"فروع المندوب توفيق","الفرع 1","الأردن 1","تركيا 1","العراق 1","تونس 1",null,"فروع المندوب توفيق","الفرع 1","الجزائر 1","المغرب 1","سوريا 1","الامارات 1"]
["علي",null,null,"الفرع 2","الجيزة","المنفذ","ليبيا 2","عجمان",null,null,"الفرع 2","الرياض","عدن",null,"حمص",null,null,null,"الفرع 2","لبنان 2","قطر 2","الكوت 2","البحرين",null,null,"الفرع 2","الأردن 2","تركيا 2","العراق 2","تونس 2",null,null,"الفرع 2","الجزائر 2","المغرب 2","سوريا 2","الامارات 2"]
["توفيق",null,null,"الفرع 3","الدقي",null,"ليبيا 3","دبي",null,null,"الفرع 3","ابها","الحديده",null,null,null,null,null,"الفرع 3","لبنان 3","قطر 3","الكوت 3","البحرين",null,null,"الفرع 3","الأردن 3","تركيا 3","العراق 3","تونس 3",null,null,"الفرع 3","الجزائر 3","المغرب 3","سوريا 3","الامارات 3"]
["عبدالله",null,null,"الفرع 4","الاسكندريه",null,"ليبيا 4","الشارقة",null,null,"الفرع 4","جيزان","تعز",null,null,null,null,null,"الفرع 4","لبنان 4","قطر 4","الكوت 4","البحرين",null,null,"الفرع 4","الأردن 4","تركيا 4","العراق 4","تونس 4",null,null,"الفرع 4","الجزائر 4","المغرب 4","سوريا 4","الامارات 4"]
[null,null,null,"الفرع 5",null,null,"ليبيا 5",null,null,null,"الفرع 5","الخميس",null,null,null,null,null,null,"الفرع 5","لبنان 5","قطر 5","الكوت 5","البحرين",null,null,"الفرع 5","الأردن 5","تركيا 5","العراق 5","تونس 5",null,null,"الفرع 5","الجزائر 5","المغرب 5","سوريا 5","الامارات 5"]
[null,null,null,"الفرع 6",null,null,null,null,null,null,"الفرع 6",null,null,null,null,null,null,null,"الفرع 6","لبنان 6","قطر 6","الكوت 6","البحرين",null,null,"الفرع 6",null,"تركيا 6","العراق 6","تونس 6",null,null,"الفرع 6","الجزائر 6","المغرب 6","سوريا 6"]
[null,null,null,"الفرع 7",null,null,null,null,null,null,"الفرع 7",null,null,null,null,null,null,null,"الفرع 7","لبنان 7",null,"الكوت 7","البحرين",null,null,"الفرع 7",null,"تركيا 7",null,"تونس 7",null,null,"الفرع 7","الجزائر 7",null,"سوريا 7"]
[null,null,null,"الفرع 8",null,null,null,null,null,null,"الفرع 8",null,null,null,null,null,null,null,"الفرع 8","لبنان 8",null,null,null,null,null,"الفرع 8",null,"تركيا 8",null,null,null,null,"الفرع 8","الجزائر 8"]
[null,null,null,"الفرع 9",null,null,null,null,null,null,"الفرع 9",null,null,null,null,null,null,null,"الفرع 9","لبنان 9",null,null,null,null,null,"الفرع 9",null,null,null,null,null,null,"الفرع 9","الجزائر 9"]
[null,null,null,"الفرع 10",null,null,null,null,null,null,"الفرع 10",null,null,null,null,null,null,null,"الفرع 10","لبنان 10",null,null,null,null,null,"الفرع 10",null,null,null,null,null,null,"الفرع 10"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"هذا كمثال فقط ولنفترض ان التكملة تنطبق لجميع او لبقية المناديب ال6"]
[]
[null,null,"المطلوب",null,null,"القوائم المنسدله"]
[null,null,"القائمة1 تمثل المناديب",null,null,"محمد","القائمة 2","القائمة 3",null,null,null,null,null,null,null,null,null,null,"طلبي نفس هذه الجداول لكل المناديب بحيث كل مندوب له دول وفروع خاصه به  . المطلوب الثاني هو في حال تغيير أي اسم للدول او المناطق ان لا تتوقف القوائم المنسدله عن العمل أي تكون ديناميكيه وشكرا"]
[null,null,"القائمة 2 تمثل الدول"]
[null,null,"القائمة 3 تمثل العواصم"]