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

{"sheet":"بحث","index":1,"n_rows":6,"n_cols":14,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ادخل اسم المندوب هنا","الفرع 10"]
[]
[]
[]
[null,null,null,"الفرع 10","السعودية 10","مصر 10","لبنان 10","الكويت 10"," البحرين 10","الامارات 10","قطر 10","اليمن 10","الأردن 10","سوريا 10"]

{"sheet":"اساسية","index":2,"n_rows":30,"n_cols":24,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,2,1,11],[14,16,16,21],[17,12,19,24],[13,16,13,21]]}
[null,null,null,null,null,null,null,null,null,null,null,null,13,null,"الدولة","الدولة","الدولة","الدولة","الدولة","الدولة","الدولة","الدولة","الدولة","الدولة"]
["م","المندوب","الدول",null,null,null,null,null,null,null,null,null,"كود المندوب","الدول","السعودية","مصر","لبنان","الكويت","البحرين","الامارات","قطر","اليمن","الأردن","سوريا"]
[1,"المندوب 1","السعودية","مصر","لبنان","الكويت","البحرين","الامارات","قطر","اليمن","الأردن","سوريا",1,"الفرع 1","السعودية 1","مصر 1","لبنان 1","الكويت 1"," البحرين 1","الامارات 1","قطر 1 ","اليمن 1","الأردن 1","سوريا 1"]
[2,555,null,"مصر","الكويت","مصر",null,null,null,null,null,null,2,"الفرع 2","السعودية 2",2,3,4,5,6,7,8,9,10]
[3,"المندوب 3",null,null,null,null,null,null,null,null,null,null,3,"الفرع 3","السعودية 3","مصر 3","لبنان 3","الكويت 3"," البحرين 3","الامارات 3","قطر 3","اليمن 3","الأردن 3","سوريا 3"]
[4,"المندوب 4",null,null,null,null,null,null,null,null,null,null,4,"الفرع 4","السعودية 4","مصر 4","لبنان 4","الكويت 4"," البحرين 4","الامارات 4","قطر 4","اليمن 4","الأردن 4","سوريا 4"]
[5,"المندوب 5",null,null,null,null,"مصر",null,null,null,null,null,5,"الفرع 5","السعودية 5","مصر 5","لبنان 5","الكويت 5"," البحرين 5","الامارات 5","قطر 5","اليمن 5","الأردن 5","سوريا 5"]
[6,555,"الكويت","لبنان",null,null,null,null,null,null,null,null,6,"الفرع 6","السعودية 6","مصر 6","لبنان 6","الكويت 6"," البحرين 6","الامارات 6","قطر 6","اليمن 6","الأردن 6","سوريا 6"]
[7,"المندوب 7",null,null,null,null,null,null,null,null,null,null,7,"الفرع 7","السعودية 7","مصر 7","لبنان 7","الكويت 7"," البحرين 7","الامارات 7","قطر 7","اليمن 7","الأردن 7","سوريا 7"]
[null,null,null,null,null,null,null,null,null,null,null,null,8,"الفرع 8","السعودية 8","مصر 8","لبنان 8","الكويت 8"," البحرين 8","الامارات 8","قطر 8","اليمن 8","الأردن 8","سوريا 8"]
[null,null,null,null,null,null,null,null,null,null,null,null,9,"الفرع 9","السعودية 9","مصر 9","لبنان 9","الكويت 9"," البحرين 9","الامارات 9","قطر 9","اليمن 9","الأردن 9","سوريا 9"]
[null,null,null,null,null,null,null,null,null,null,null,null,10,"الفرع 10","السعودية 10","مصر 10","لبنان 10","الكويت 10"," البحرين 10","الامارات 10","قطر 10","اليمن 10","الأردن 10","سوريا 10"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"أتمنى طريقه للادخال بشكل اسهل كالمثال الذي على شيت ورقة 1 حيث كل مندوب سهل معرفة دولته وفروعها"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"استاذي الفاضل اذا كان الجدول أعلاه يمثل فقط بيانات دول وفروع المندوب 1  او المندوب رقم واحد  فكيف يمكنني ادراج دول وفروع جديده للبقية المناديب "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, _لا ادري لماذا ظهر لي هذا الخطاء  \n                                                                Formula1:=\"=NameCs\" & Trim(Str(i - 1))"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,55,55,55,55]

{"sheet":"الادخال","index":3,"n_rows":101,"n_cols":6,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
["م","المندوب","الدولة","الفرع","العدد","القيمة"]
[1,"المندوب 3"]
[2,"المندوب 2"]
[3,"المندوب 4",null,"الامارات 3"]
[4,"المندوب 2",null,"السعودية 2"]
[5,"المندوب 4"]
[6,"المندوب 6"]
[7,"المندوب 7"]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[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]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]