{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["1","2","Sheet2"],"not_rendered":{"charts":0,"images":0,"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,{"$f":"VLOOKUP(A2&E2,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":"تمت"},null,"{=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,{"$f":"VLOOKUP(A3&E3,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["الحي العاشر م.نصر","2021-03-14","Axa- Egypt",84.46,278859,{"$f":"VLOOKUP(A4&E4,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":"تمت"}]
["الحي العاشر م.نصر","2021-03-15","GLOBEMED",153.78,279486,{"$f":"VLOOKUP(A5&E5,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["الحي العاشر م.نصر","2021-03-15","MED NET",396.85,279359,{"$f":"VLOOKUP(A6&E6,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["زيزينيا-الاسكندرية","2021-03-16","GLOBEMED",136.58000000000001,279770,{"$f":"VLOOKUP(A7&E7,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":"تمت"}]
["السيده زينب","2021-03-17",null,1,5,{"$f":"VLOOKUP(A8&E8,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":"تمت"}]
["الشارع الجديد شبرا الخيمه","2021-03-18","اليكو",1684.85,13477,{"$f":"VLOOKUP(A9&E9,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":"تمت"}]
["الشارع الجديد شبرا الخيمه","2021-01-03","Axa- Egypt",107.45,6771,{"$f":"VLOOKUP(A10&E10,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}},null,"اريد كتابة هذه الدالة vba وتطبيقها على كامل النطق الملون بالاصفر"]
["الشارع الجديد شبرا الخيمه","2021-01-03","DMS PLUS",167.25,6867,{"$f":"VLOOKUP(A11&E11,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["الشارع الجديد شبرا الخيمه","2021-01-03","GLOBEMED",407.28,6872,{"$f":"VLOOKUP(A12&E12,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["الشارع الجديد شبرا الخيمه","2021-01-03","ميد رايت",446.95,6815,{"$f":"VLOOKUP(A13&E13,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["الشارع الجديد شبرا الخيمه","2021-03-23","Axa- Egypt",43.75,9575,{"$f":"VLOOKUP(A14&E14,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["القصر العيني","2021-03-07","ايجيكير",105.15,13511,{"$f":"VLOOKUP(A15&E15,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":"تمت"}]
["القصر العيني","2021-10-03","MED NET",122.85,14633,{"$f":"VLOOKUP(A16&E16,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["القصر العيني","3/15/2021","ميد رايت",112,16194,{"$f":"VLOOKUP(A17&E17,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["القصر العيني","3/23/2021","ميدي كير",65.319999999999993,19017,{"$f":"VLOOKUP(A18&E18,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["الكوم الاخضر","2021-03-03","الاهلي للمشروعات",2978.56,27116,{"$f":"VLOOKUP(A19&E19,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":"تمت"}]
["الكوم الاخضر","2021-03-04","اليكو",54.85,27431,{"$f":"VLOOKUP(A20&E20,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["الكوم الاخضر","2021-03-16","الاهلي للمشروعات",394.28,29752,{"$f":"VLOOKUP(A21&E21,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["الكوم الاخضر","2021-09-03","Axa- Egypt",193.29,28349,{"$f":"VLOOKUP(A22&E22,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["المشايه-المنصورة","2021-03-02","الاهلي للمشروعات",211.2,95367,{"$f":"VLOOKUP(A23&E23,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":"تمت"}]
["زيزينيا-الاسكندرية","2021-03-14","Axa- Egypt",120,153215,{"$f":"VLOOKUP(A24&E24,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["زيزينيا-الاسكندرية","2021-03-18","الحمرا اويل",501.63,153992,{"$f":"VLOOKUP(A25&E25,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":"تمت"}]
["ش-مصدق","2021-01-03","ميد رايت",3121.9,108121,{"$f":"VLOOKUP(A26&E26,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":"تمت"}]
["ش-مصدق","2021-01-03","نكست كير",516.57000000000005,108074,{"$f":"VLOOKUP(A27&E27,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["ش-مصدق","2021-02-03","Axa- Egypt",189,109011,{"$f":"VLOOKUP(A28&E28,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["ش-مصدق","2021-02-03","شركة الاستشاريون للرعاية الطبيه",371.95,109156,{"$f":"VLOOKUP(A29&E29,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["ش-مصدق","2021-03-02","GLOBEMED",669.75,108994,{"$f":"VLOOKUP(A30&E30,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["ش-مصدق","2021-03-09","اليكو",326.88,113205,{"$f":"VLOOKUP(A31&E31,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["ش-مصدق","2021-03-09","اليكو",326.88,113205,{"$f":"VLOOKUP(A32&E32,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["ش-مصدق","2021-03-10","DMS PLUS",562.5,113626,{"$f":"VLOOKUP(A33&E33,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["ش-مصدق","2021-04-03","اليكو",1884.55,110531,{"$f":"VLOOKUP(A34&E34,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["ش-مصدق","2021-07-03","نكست كير",113.71,111831,{"$f":"VLOOKUP(A35&E35,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["ش-مصدق","2021-11-03","ايجيكير",64.52,114633,{"$f":"VLOOKUP(A36&E36,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["شبرا الخيمة","2021-03-05","الاهلي للمشروعات",217.84,267864,{"$f":"VLOOKUP(A37&E37,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":"تمت"}]
["شبرا الخيمة","2021-05-03","GLOBEMED",266,268046,{"$f":"VLOOKUP(A38&E38,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["شبرا الخيمة","2021-07-03","Axa- Egypt",73.959999999999994,268627,{"$f":"VLOOKUP(A39&E39,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["شبرا الخيمة","2/21/2021","DMS PLUS",21.22,264063,{"$f":"VLOOKUP(A40&E40,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["شبين 2 المنوفيه","2021-03-11","GLOBEMED",99.53,74468,{"$f":"VLOOKUP(A41&E41,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":"منتظر"}]
["عرابي - المهندسين","2021-05-03","DMS PLUS",735.15,222488,{"$f":"VLOOKUP(A42&E42,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":"منتظر"}]
["عرابي - المهندسين","3/17/2021","ايجيكير",395.67,226311,{"$f":"VLOOKUP(A43&E43,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["فيصل – الطالبيه","2021-01-03","اليكو",815.36,17687,{"$f":"VLOOKUP(A44&E44,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["فيصل – الطالبيه","2021-01-03","ميد رايت",3372.57,18188,{"$f":"VLOOKUP(A45&E45,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["فيصل – الطالبيه","2021-02-03","الاهلي للمشروعات",254.74,18570,{"$f":"VLOOKUP(A46&E46,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["فيصل – الطالبيه","2021-03-02","GLOBEMED",268.14999999999998,18666,{"$f":"VLOOKUP(A47&E47,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["فيصل – الطالبيه","2021-03-06","نكست كير",71.900000000000006,20211,{"$f":"VLOOKUP(A48&E48,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["فيصل – الطالبيه","2021-03-06","نكست كير",71.900000000000006,20211,{"$f":"VLOOKUP(A49&E49,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["فيصل – الطالبيه","2021-03-09","GLOBEMED",13539.89,21934,{"$f":"VLOOKUP(A50&E50,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["فيصل – الطالبيه","2021-03-15","Axa- Egypt",335.65,24489,{"$f":"VLOOKUP(A51&E51,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":"منتظر"}]
["فيصل – الطالبيه","3/18/2021","Axa- Egypt",56.7,25998,{"$f":"VLOOKUP(A52&E52,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":"منتظر"}]
["فيوتشرمول","2021-02-03","الاهلي للمشروعات",232.27,27976,{"$f":"VLOOKUP(A53&E53,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":"منتظر"}]
["قناةالسويس-المنصورة","2021-01-03","GLOBEMED",258.5,56955,{"$f":"VLOOKUP(A54&E54,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":"منتظر"}]
["قناةالسويس-المنصورة","2021-03-03","الاهلي للمشروعات",404.7,57470,{"$f":"VLOOKUP(A55&E55,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":"منتظر"}]
["قناةالسويس-المنصورة","3/16/2021","GLOBEMED",72.180000000000007,60638,{"$f":"VLOOKUP(A56&E56,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":"منتظر"}]
["كريستال مول","2021-01-03","GLOBEMED",600.66,149529,{"$f":"VLOOKUP(A57&E57,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":"منتظر"}]
["كريستال مول","2021-01-03","لايف هيلثي كير",254.47,149694,{"$f":"VLOOKUP(A58&E58,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["كريستال مول","2021-03-03","اليكو",971.42,150160,{"$f":"VLOOKUP(A59&E59,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["كريستال مول","2021-03-09","اليكو",206.28,151574,{"$f":"VLOOKUP(A60&E60,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["كريستال مول","2021-03-14","Axa- Egypt",40.159999999999997,152482,{"$f":"VLOOKUP(A61&E61,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["كريستال مول","2021-09-03","اليكو",190.43,151571,{"$f":"VLOOKUP(A62&E62,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["كريستال مول","2021-09-03","اليكو",206.28,151574,{"$f":"VLOOKUP(A63&E63,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["كفر الشيخ","2021-03-03","ميد رايت",539.1,8163,{"$f":"VLOOKUP(A64&E64,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":"منتظر"}]
["محطة سيدي جابر","2021-03-01","Med Shield",454.8,14302,{"$f":"VLOOKUP(A65&E65,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["محطة سيدي جابر","2021-07-03","Axa- Egypt",1004.1,16711,{"$f":"VLOOKUP(A66&E66,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["محطة سيدي جابر","2021-07-03","اليكو",47.59,16808,{"$f":"VLOOKUP(A67&E67,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["مسطرد","3/13/2021","نكست كير",40.700000000000003,13298,{"$f":"VLOOKUP(A68&E68,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":"منتظر"}]
["مسطرد","3/22/2021","نكست كير",340.46,14981,{"$f":"VLOOKUP(A69&E69,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$error":"#N/A"}}]
["مسطرد","3/22/2021","نكست كير",879,14994,{"$f":"VLOOKUP(A70&E70,CHOOSE({1,2},'2'!$A$1:$A$22&'2'!$E$1:$E$22,'2'!$F$1:$F$22),2,0)","v":{"$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]