{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["1","2","Sheet2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":70,"n_cols":8,"rows_kept":70,"cut":false,"hidden":false,"merged":[[1,7,8,9],[9,7,10,9]]}
["الشارع الجديد شبرا الخيمه"]
["الاسكندر الاكبر 2","1900-01-01","اليكو",78.3,74430,"تمت","تمت","{=VLOOKUP(A2&E2;CHOOSE({1,2};'2'!$A$1:$A$22&'2'!$E$1:$E$22;'2'!$F$1:$F$22);2;0)}"]
["الاسكندر الاكبر 2","2021-03-15","اليكو",118.4,74431,{"$error":"#N/A"}]
["الحي العاشر م.نصر","2021-03-14","Axa- Egypt",84.46,278859,"تمت","تمت"]
["الحي العاشر م.نصر","2021-03-15","GLOBEMED",153.78,279486,{"$error":"#N/A"},{"$error":"#N/A"}]
["الحي العاشر م.نصر","2021-03-15","MED NET",396.85,279359,{"$error":"#N/A"},{"$error":"#N/A"}]
["زيزينيا-الاسكندرية","2021-03-16","GLOBEMED",136.58000000000001,279770,"تمت",{"$error":"#N/A"}]
["السيده زينب","2021-03-17",null,1,5,"تمت","تمت"]
["الشارع الجديد شبرا الخيمه","2021-03-18","اليكو",1684.85,13477,"تمت","تمت"]
["الشارع الجديد شبرا الخيمه","2021-01-03","Axa- Egypt",107.45,6771,{"$error":"#N/A"},{"$error":"#N/A"},"اريد كتابة هذه الدالة vba وتطبيقها على كامل النطق الملون بالاصفر"]
["الشارع الجديد شبرا الخيمه","2021-01-03","DMS PLUS",167.25,6867,{"$error":"#N/A"},{"$error":"#N/A"}]
["الشارع الجديد شبرا الخيمه","2021-01-03","GLOBEMED",407.28,6872,{"$error":"#N/A"},{"$error":"#N/A"}]
["الشارع الجديد شبرا الخيمه","2021-01-03","ميد رايت",446.95,6815,{"$error":"#N/A"},{"$error":"#N/A"}]
["الشارع الجديد شبرا الخيمه","2021-03-23","Axa- Egypt",43.75,9575,{"$error":"#N/A"},{"$error":"#N/A"}]
["القصر العيني","2021-03-07","ايجيكير",105.15,13511,"تمت","تمت"]
["القصر العيني","2021-10-03","MED NET",122.85,14633,{"$error":"#N/A"},{"$error":"#N/A"}]
["القصر العيني","3/15/2021","ميد رايت",112,16194,{"$error":"#N/A"},{"$error":"#N/A"}]
["القصر العيني","3/23/2021","ميدي كير",65.319999999999993,19017,{"$error":"#N/A"},{"$error":"#N/A"}]
["الكوم الاخضر","2021-03-03","الاهلي للمشروعات",2978.56,27116,"تمت","تمت"]
["الكوم الاخضر","2021-03-04","اليكو",54.85,27431,{"$error":"#N/A"},{"$error":"#N/A"}]
["الكوم الاخضر","2021-03-16","الاهلي للمشروعات",394.28,29752,{"$error":"#N/A"},{"$error":"#N/A"}]
["الكوم الاخضر","2021-09-03","Axa- Egypt",193.29,28349,{"$error":"#N/A"},{"$error":"#N/A"}]
["المشايه-المنصورة","2021-03-02","الاهلي للمشروعات",211.2,95367,"تمت","تمت"]
["زيزينيا-الاسكندرية","2021-03-14","Axa- Egypt",120,153215,{"$error":"#N/A"},{"$error":"#N/A"}]
["زيزينيا-الاسكندرية","2021-03-18","الحمرا اويل",501.63,153992,"تمت","تمت"]
["ش-مصدق","2021-01-03","ميد رايت",3121.9,108121,"تمت","تمت"]
["ش-مصدق","2021-01-03","نكست كير",516.57000000000005,108074,{"$error":"#N/A"},{"$error":"#N/A"}]
["ش-مصدق","2021-02-03","Axa- Egypt",189,109011,{"$error":"#N/A"},{"$error":"#N/A"}]
["ش-مصدق","2021-02-03","شركة الاستشاريون للرعاية الطبيه",371.95,109156,{"$error":"#N/A"},{"$error":"#N/A"}]
["ش-مصدق","2021-03-02","GLOBEMED",669.75,108994,{"$error":"#N/A"},{"$error":"#N/A"}]
["ش-مصدق","2021-03-09","اليكو",326.88,113205,{"$error":"#N/A"},{"$error":"#N/A"}]
["ش-مصدق","2021-03-09","اليكو",326.88,113205,{"$error":"#N/A"},{"$error":"#N/A"}]
["ش-مصدق","2021-03-10","DMS PLUS",562.5,113626,{"$error":"#N/A"},{"$error":"#N/A"}]
["ش-مصدق","2021-04-03","اليكو",1884.55,110531,{"$error":"#N/A"},{"$error":"#N/A"}]
["ش-مصدق","2021-07-03","نكست كير",113.71,111831,{"$error":"#N/A"},{"$error":"#N/A"}]
["ش-مصدق","2021-11-03","ايجيكير",64.52,114633,{"$error":"#N/A"},{"$error":"#N/A"}]
["شبرا الخيمة","2021-03-05","الاهلي للمشروعات",217.84,267864,"تمت","تمت"]
["شبرا الخيمة","2021-05-03","GLOBEMED",266,268046,{"$error":"#N/A"},{"$error":"#N/A"}]
["شبرا الخيمة","2021-07-03","Axa- Egypt",73.959999999999994,268627,{"$error":"#N/A"},{"$error":"#N/A"}]
["شبرا الخيمة","2/21/2021","DMS PLUS",21.22,264063,{"$error":"#N/A"},{"$error":"#N/A"}]
["شبين 2 المنوفيه","2021-03-11","GLOBEMED",99.53,74468,"منتظر","منتظر"]
["عرابي - المهندسين","2021-05-03","DMS PLUS",735.15,222488,"منتظر","منتظر"]
["عرابي - المهندسين","3/17/2021","ايجيكير",395.67,226311,{"$error":"#N/A"},{"$error":"#N/A"}]
["فيصل – الطالبيه","2021-01-03","اليكو",815.36,17687,{"$error":"#N/A"},{"$error":"#N/A"}]
["فيصل – الطالبيه","2021-01-03","ميد رايت",3372.57,18188,{"$error":"#N/A"},{"$error":"#N/A"}]
["فيصل – الطالبيه","2021-02-03","الاهلي للمشروعات",254.74,18570,{"$error":"#N/A"},{"$error":"#N/A"}]
["فيصل – الطالبيه","2021-03-02","GLOBEMED",268.14999999999998,18666,{"$error":"#N/A"},{"$error":"#N/A"}]
["فيصل – الطالبيه","2021-03-06","نكست كير",71.900000000000006,20211,{"$error":"#N/A"},{"$error":"#N/A"}]
["فيصل – الطالبيه","2021-03-06","نكست كير",71.900000000000006,20211,{"$error":"#N/A"},{"$error":"#N/A"}]
["فيصل – الطالبيه","2021-03-09","GLOBEMED",13539.89,21934,{"$error":"#N/A"},{"$error":"#N/A"}]
["فيصل – الطالبيه","2021-03-15","Axa- Egypt",335.65,24489,"منتظر","منتظر"]
["فيصل – الطالبيه","3/18/2021","Axa- Egypt",56.7,25998,"منتظر","منتظر"]
["فيوتشرمول","2021-02-03","الاهلي للمشروعات",232.27,27976,"منتظر","منتظر"]
["قناةالسويس-المنصورة","2021-01-03","GLOBEMED",258.5,56955,"منتظر","منتظر"]
["قناةالسويس-المنصورة","2021-03-03","الاهلي للمشروعات",404.7,57470,"منتظر","منتظر"]
["قناةالسويس-المنصورة","3/16/2021","GLOBEMED",72.180000000000007,60638,"منتظر","منتظر"]
["كريستال مول","2021-01-03","GLOBEMED",600.66,149529,"منتظر","منتظر"]
["كريستال مول","2021-01-03","لايف هيلثي كير",254.47,149694,{"$error":"#N/A"},{"$error":"#N/A"}]
["كريستال مول","2021-03-03","اليكو",971.42,150160,{"$error":"#N/A"},{"$error":"#N/A"}]
["كريستال مول","2021-03-09","اليكو",206.28,151574,{"$error":"#N/A"},{"$error":"#N/A"}]
["كريستال مول","2021-03-14","Axa- Egypt",40.159999999999997,152482,{"$error":"#N/A"},{"$error":"#N/A"}]
["كريستال مول","2021-09-03","اليكو",190.43,151571,{"$error":"#N/A"},{"$error":"#N/A"}]
["كريستال مول","2021-09-03","اليكو",206.28,151574,{"$error":"#N/A"},{"$error":"#N/A"}]
["كفر الشيخ","2021-03-03","ميد رايت",539.1,8163,"منتظر","منتظر"]
["محطة سيدي جابر","2021-03-01","Med Shield",454.8,14302,{"$error":"#N/A"},{"$error":"#N/A"}]
["محطة سيدي جابر","2021-07-03","Axa- Egypt",1004.1,16711,{"$error":"#N/A"},{"$error":"#N/A"}]
["محطة سيدي جابر","2021-07-03","اليكو",47.59,16808,{"$error":"#N/A"},{"$error":"#N/A"}]
["مسطرد","3/13/2021","نكست كير",40.700000000000003,13298,"منتظر","منتظر"]
["مسطرد","3/22/2021","نكست كير",340.46,14981,{"$error":"#N/A"},{"$error":"#N/A"}]
["مسطرد","3/22/2021","نكست كير",879,14994,{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"2","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["الاسكندر الاكبر 2","1900-01-01","اليكو",78.3,74430,"تمت"]
["الحي العاشر م.نصر","2021-03-14","Axa- Egypt",84.46,278859,"تمت"]
["زيزينيا-الاسكندرية","2021-03-16","GLOBEMED",136.58000000000001,279770,"تمت"]
["السيده زينب","2021-03-17","DMS PLUS",1,5,"تمت"]
["الشارع الجديد شبرا الخيمه","2021-03-18","اليكو",1684.85,13477,"تمت"]
["القصر العيني","2021-03-07","ايجيكير",105.15,13511,"تمت"]
["الكوم الاخضر","2021-03-03","الاهلي للمشروعات",2978.56,27116,"تمت"]
["المشايه-المنصورة","2021-03-02","الاهلي للمشروعات",211.2,95367,"تمت"]
["زيزينيا-الاسكندرية","2021-03-18","الحمرا اويل",501.63,153992,"تمت"]
["ش-مصدق","2021-01-03","ميد رايت",3121.9,108121,"تمت"]
["شبرا الخيمة","2021-03-05","الاهلي للمشروعات",217.84,267864,"تمت"]
["شبين 2 المنوفيه","2021-03-11","GLOBEMED",99.53,74468,"منتظر"]
["عرابي - المهندسين","2021-05-03","DMS PLUS",735.15,222488,"منتظر"]
["فيصل – الطالبيه","2021-03-15","Axa- Egypt",335.65,24489,"منتظر"]
["فيصل – الطالبيه","3/18/2021","Axa- Egypt",56.7,25998,"منتظر"]
["فيوتشرمول","2021-02-03","الاهلي للمشروعات",232.27,27976,"منتظر"]
["قناةالسويس-المنصورة","2021-01-03","GLOBEMED",258.5,56955,"منتظر"]
["قناةالسويس-المنصورة","2021-03-03","الاهلي للمشروعات",404.7,57470,"منتظر"]
["قناةالسويس-المنصورة","3/16/2021","GLOBEMED",72.180000000000007,60638,"منتظر"]
["كريستال مول","2021-01-03","GLOBEMED",600.66,149529,"منتظر"]
["كفر الشيخ","2021-03-03","ميد رايت",539.1,8163,"منتظر"]
["مسطرد","3/13/2021","نكست كير",40.700000000000003,13298,"منتظر"]

{"sheet":"Sheet2","index":2,"n_rows":77,"n_cols":13,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,12,40,19]]}
["الشارع الجديد شبرا الخيمه",null,null,null,null,null,null,null,null,null,null,null,"Sub ahmd()\nDim lastrow As Long\nDim rng As Range\nDim mrng As Range\nDim vm As Long\nDim countm As Long\nDim mm As Range\nDim ll As Range\nDim x As Long\nlastrow = Cells(Rows.Count, 1).End(xlUp).Row\nSet mrng = Range(\"a2:a\" & lastrow)\nvm = Application.WorksheetFunction.match(Range(\"a1\"), mrng, 0) + 1\ncountm = Application.WorksheetFunction.CountIf(mrng, Range(\"a1\")) + vm - 1\nSet mm = Range(\"a\" & [e200].End(xlUp).Row + 2)\nSet ll = Range(\"b\" & [e200].End(xlUp).Row + 100)\nSet rng = Range(mm, ll)\nFor x = vm To countm\nOn Error Resume Next\nRange(\"g\" & x).Value = Application.WorksheetFunction.VLookup( _\nRange(\"e\" & x).Value, rng, 2, False)\nNext x\nEnd Sub"]
["الاسكندر الاكبر 2","1900-01-01","اليكو",78.3,74430]
["الاسكندر الاكبر 2","2021-03-15","اليكو",118.4,74431]
["الحي العاشر م.نصر","2021-03-14","Axa- Egypt",84.46,278859]
["الحي العاشر م.نصر","2021-03-15","GLOBEMED",153.78,279486]
["الحي العاشر م.نصر","2021-03-15","MED NET",396.85,279359]
["زيزينيا-الاسكندرية","2021-03-16","GLOBEMED",136.58000000000001,279770]
["السيده زينب","2021-03-17",null,1,5]
["الشارع الجديد شبرا الخيمه","2021-03-18","اليكو",1684.85,13477]
["الشارع الجديد شبرا الخيمه","2021-01-03","Axa- Egypt",107.45,6771,null,null,null,null,{"$f":"MATCH(A1,A2:A200,0)+1","v":9}]
["الشارع الجديد شبرا الخيمه","2021-01-03","DMS PLUS",167.25,6867]
["الشارع الجديد شبرا الخيمه","2021-01-03","GLOBEMED",407.28,6872]
["الشارع الجديد شبرا الخيمه","2021-01-03","ميد رايت",446.95,6815]
["الشارع الجديد شبرا الخيمه","2021-03-23","Axa- Egypt",43.75,9575]
["القصر العيني","2021-03-07","ايجيكير",105.15,13511]
["القصر العيني","2021-10-03","MED NET",122.85,14633]
["القصر العيني","3/15/2021","ميد رايت",112,16194]
["القصر العيني","3/23/2021","ميدي كير",65.319999999999993,19017]
["الكوم الاخضر","2021-03-03","الاهلي للمشروعات",2978.56,27116]
["الكوم الاخضر","2021-03-04","اليكو",54.85,27431]
["الكوم الاخضر","2021-03-16","الاهلي للمشروعات",394.28,29752]
["الكوم الاخضر","2021-09-03","Axa- Egypt",193.29,28349]
["المشايه-المنصورة","2021-03-02","الاهلي للمشروعات",211.2,95367]
["زيزينيا-الاسكندرية","2021-03-14","Axa- Egypt",120,153215]
["زيزينيا-الاسكندرية","2021-03-18","الحمرا اويل",501.63,153992]
["ش-مصدق","2021-01-03","ميد رايت",3121.9,108121]
["ش-مصدق","2021-01-03","نكست كير",516.57000000000005,108074]
["ش-مصدق","2021-02-03","Axa- Egypt",189,109011]
["ش-مصدق","2021-02-03","شركة الاستشاريون للرعاية الطبيه",371.95,109156]
["ش-مصدق","2021-03-02","GLOBEMED",669.75,108994]
["ش-مصدق","2021-03-09","اليكو",326.88,113205]
["ش-مصدق","2021-03-09","اليكو",326.88,113205]
["ش-مصدق","2021-03-10","DMS PLUS",562.5,113626]
["ش-مصدق","2021-04-03","اليكو",1884.55,110531]
["ش-مصدق","2021-07-03","نكست كير",113.71,111831]
["ش-مصدق","2021-11-03","ايجيكير",64.52,114633]
["شبرا الخيمة","2021-03-05","الاهلي للمشروعات",217.84,267864]
["شبرا الخيمة","2021-05-03","GLOBEMED",266,268046]
["شبرا الخيمة","2021-07-03","Axa- Egypt",73.959999999999994,268627]
["شبرا الخيمة","2/21/2021","DMS PLUS",21.22,264063]
["شبين 2 المنوفيه","2021-03-11","GLOBEMED",99.53,74468]
["عرابي - المهندسين","2021-05-03","DMS PLUS",735.15,222488]
["عرابي - المهندسين","3/17/2021","ايجيكير",395.67,226311]
["فيصل – الطالبيه","2021-01-03","اليكو",815.36,17687]
["فيصل – الطالبيه","2021-01-03","ميد رايت",3372.57,18188]
["فيصل – الطالبيه","2021-02-03","الاهلي للمشروعات",254.74,18570]
["فيصل – الطالبيه","2021-03-02","GLOBEMED",268.14999999999998,18666]
["فيصل – الطالبيه","2021-03-06","نكست كير",71.900000000000006,20211]
["فيصل – الطالبيه","2021-03-06","نكست كير",71.900000000000006,20211]
["فيصل – الطالبيه","2021-03-09","GLOBEMED",13539.89,21934]
["فيصل – الطالبيه","2021-03-15","Axa- Egypt",335.65,24489]
["فيصل – الطالبيه","3/18/2021","Axa- Egypt",56.7,25998]
["فيوتشرمول","2021-02-03","الاهلي للمشروعات",232.27,27976]
["قناةالسويس-المنصورة","2021-01-03","GLOBEMED",258.5,56955]
["قناةالسويس-المنصورة","2021-03-03","الاهلي للمشروعات",404.7,57470]
["قناةالسويس-المنصورة","3/16/2021","GLOBEMED",72.180000000000007,60638]
["كريستال مول","2021-01-03","GLOBEMED",600.66,149529]
["كريستال مول","2021-01-03","لايف هيلثي كير",254.47,149694]
["كريستال مول","2021-03-03","اليكو",971.42,150160]
["كريستال مول","2021-03-09","اليكو",206.28,151574]
["كريستال مول","2021-03-14","Axa- Egypt",40.159999999999997,152482]
["كريستال مول","2021-09-03","اليكو",190.43,151571]
["كريستال مول","2021-09-03","اليكو",206.28,151574]
["كفر الشيخ","2021-03-03","ميد رايت",539.1,8163]
["محطة سيدي جابر","2021-03-01","Med Shield",454.8,14302]
["محطة سيدي جابر","2021-07-03","Axa- Egypt",1004.1,16711]
["محطة سيدي جابر","2021-07-03","اليكو",47.59,16808]
["مسطرد","3/13/2021","نكست كير",40.700000000000003,13298]
["مسطرد","3/22/2021","نكست كير",340.46,14981]
["مسطرد","3/22/2021","نكست كير",879,14994]
[]
[13477,null,null,null,null,null,null,null,null,13477]
[6771,null,null,null,null,null,null,null,null,6771]
[6867,null,null,null,null,null,null,null,null,6867]
[6872,null,null,null,null,null,null,null,null,6872]
[6815,null,null,null,null,null,null,null,null,6815]
[9575,null,null,null,null,null,null,null,null,9575]