{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Formula"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Formula","index":0,"n_rows":15,"n_cols":22,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Description",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,{"$f":"Salim_Single_Match($B3,\"\\d+\",COLUMNS($C$1:C1))","v":"No Match"},{"$f":"IF(COUNTIF($C3:C3,Salim_Single_Match($B3,\"\\d+\",D$2))=1,\"\",Salim_Single_Match($B3,\"\\d+\",D$2))","v":""},{"$f":"IF(COUNTIF($C3:D3,Salim_Single_Match($B3,\"\\d+\",E$2))=1,\"\",Salim_Single_Match($B3,\"\\d+\",E$2))","v":""},{"$f":"IF(COUNTIF($C3:E3,Salim_Single_Match($B3,\"\\d+\",F$2))=1,\"\",Salim_Single_Match($B3,\"\\d+\",F$2))","v":""},{"$f":"IF(COUNTIF($C3:F3,Salim_Single_Match($B3,\"\\d+\",G$2))=1,\"\",Salim_Single_Match($B3,\"\\d+\",G$2))","v":""},{"$f":"IF(COUNTIF($C3:G3,Salim_Single_Match($B3,\"\\d+\",H$2))=1,\"\",Salim_Single_Match($B3,\"\\d+\",H$2))","v":""},{"$f":"IF(COUNTIF($C3:H3,Salim_Single_Match($B3,\"\\d+\",I$2))=1,\"\",Salim_Single_Match($B3,\"\\d+\",I$2))","v":""},{"$f":"IF(COUNTIF($C3:I3,Salim_Single_Match($B3,\"\\d+\",J$2))=1,\"\",Salim_Single_Match($B3,\"\\d+\",J$2))","v":""},{"$f":"IF(COUNTIF($C3:J3,Salim_Single_Match($B3,\"\\d+\",K$2))=1,\"\",Salim_Single_Match($B3,\"\\d+\",K$2))","v":""},{"$f":"IF(COUNTIF($C3:K3,Salim_Single_Match($B3,\"\\d+\",L$2))=1,\"\",Salim_Single_Match($B3,\"\\d+\",L$2))","v":""},{"$f":"IF(COUNTIF($C3:L3,Salim_Single_Match($B3,\"\\d+\",M$2))=1,\"\",Salim_Single_Match($B3,\"\\d+\",M$2))","v":""},{"$f":"IF(COUNTIF($C3:M3,Salim_Single_Match($B3,\"\\d+\",N$2))=1,\"\",Salim_Single_Match($B3,\"\\d+\",N$2))","v":""},{"$f":"IF(COUNTIF($C3:N3,Salim_Single_Match($B3,\"\\d+\",O$2))=1,\"\",Salim_Single_Match($B3,\"\\d+\",O$2))","v":""},{"$f":"IF(COUNTIF($C3:O3,Salim_Single_Match($B3,\"\\d+\",P$2))=1,\"\",Salim_Single_Match($B3,\"\\d+\",P$2))","v":""},{"$f":"IF(COUNTIF($C3:P3,Salim_Single_Match($B3,\"\\d+\",Q$2))=1,\"\",Salim_Single_Match($B3,\"\\d+\",Q$2))","v":""},{"$f":"IF(COUNTIF($C3:Q3,Salim_Single_Match($B3,\"\\d+\",R$2))=1,\"\",Salim_Single_Match($B3,\"\\d+\",R$2))","v":""},{"$f":"IF(COUNTIF($C3:R3,Salim_Single_Match($B3,\"\\d+\",S$2))=1,\"\",Salim_Single_Match($B3,\"\\d+\",S$2))","v":""},{"$f":"IF(COUNTIF($C3:S3,Salim_Single_Match($B3,\"\\d+\",T$2))=1,\"\",Salim_Single_Match($B3,\"\\d+\",T$2))","v":""},{"$f":"IF(COUNTIF($C3:T3,Salim_Single_Match($B3,\"\\d+\",U$2))=1,\"\",Salim_Single_Match($B3,\"\\d+\",U$2))","v":""},{"$f":"IF(COUNTIF($C3:U3,Salim_Single_Match($B3,\"\\d+\",V$2))=1,\"\",Salim_Single_Match($B3,\"\\d+\",V$2))","v":""}]
[null,"(E.4274.799  N.5562.035) to (E.4301.11  N.5562.035) to (E.4301.11  N.5560.53)",{"$f":"Salim_Single_Match($B4,\"\\d+\",COLUMNS($C$1:C2))","v":4274},{"$f":"IF(COUNTIF($C4:C4,Salim_Single_Match($B4,\"\\d+\",D$2))=1,\"\",Salim_Single_Match($B4,\"\\d+\",D$2))","v":799},{"$f":"IF(COUNTIF($C4:D4,Salim_Single_Match($B4,\"\\d+\",E$2))=1,\"\",Salim_Single_Match($B4,\"\\d+\",E$2))","v":5562},{"$f":"IF(COUNTIF($C4:E4,Salim_Single_Match($B4,\"\\d+\",F$2))=1,\"\",Salim_Single_Match($B4,\"\\d+\",F$2))","v":35},{"$f":"IF(COUNTIF($C4:F4,Salim_Single_Match($B4,\"\\d+\",G$2))=1,\"\",Salim_Single_Match($B4,\"\\d+\",G$2))","v":4301},{"$f":"IF(COUNTIF($C4:G4,Salim_Single_Match($B4,\"\\d+\",H$2))=1,\"\",Salim_Single_Match($B4,\"\\d+\",H$2))","v":11},{"$f":"IF(COUNTIF($C4:H4,Salim_Single_Match($B4,\"\\d+\",I$2))=1,\"\",Salim_Single_Match($B4,\"\\d+\",I$2))","v":""},{"$f":"IF(COUNTIF($C4:I4,Salim_Single_Match($B4,\"\\d+\",J$2))=1,\"\",Salim_Single_Match($B4,\"\\d+\",J$2))","v":""},{"$f":"IF(COUNTIF($C4:J4,Salim_Single_Match($B4,\"\\d+\",K$2))=1,\"\",Salim_Single_Match($B4,\"\\d+\",K$2))","v":""},{"$f":"IF(COUNTIF($C4:K4,Salim_Single_Match($B4,\"\\d+\",L$2))=1,\"\",Salim_Single_Match($B4,\"\\d+\",L$2))","v":""},{"$f":"IF(COUNTIF($C4:L4,Salim_Single_Match($B4,\"\\d+\",M$2))=1,\"\",Salim_Single_Match($B4,\"\\d+\",M$2))","v":5560},{"$f":"IF(COUNTIF($C4:M4,Salim_Single_Match($B4,\"\\d+\",N$2))=1,\"\",Salim_Single_Match($B4,\"\\d+\",N$2))","v":53},{"$f":"IF(COUNTIF($C4:N4,Salim_Single_Match($B4,\"\\d+\",O$2))=1,\"\",Salim_Single_Match($B4,\"\\d+\",O$2))","v":""},{"$f":"IF(COUNTIF($C4:O4,Salim_Single_Match($B4,\"\\d+\",P$2))=1,\"\",Salim_Single_Match($B4,\"\\d+\",P$2))","v":""},{"$f":"IF(COUNTIF($C4:P4,Salim_Single_Match($B4,\"\\d+\",Q$2))=1,\"\",Salim_Single_Match($B4,\"\\d+\",Q$2))","v":""},{"$f":"IF(COUNTIF($C4:Q4,Salim_Single_Match($B4,\"\\d+\",R$2))=1,\"\",Salim_Single_Match($B4,\"\\d+\",R$2))","v":""},{"$f":"IF(COUNTIF($C4:R4,Salim_Single_Match($B4,\"\\d+\",S$2))=1,\"\",Salim_Single_Match($B4,\"\\d+\",S$2))","v":""},{"$f":"IF(COUNTIF($C4:S4,Salim_Single_Match($B4,\"\\d+\",T$2))=1,\"\",Salim_Single_Match($B4,\"\\d+\",T$2))","v":""},{"$f":"IF(COUNTIF($C4:T4,Salim_Single_Match($B4,\"\\d+\",U$2))=1,\"\",Salim_Single_Match($B4,\"\\d+\",U$2))","v":""},{"$f":"IF(COUNTIF($C4:U4,Salim_Single_Match($B4,\"\\d+\",V$2))=1,\"\",Salim_Single_Match($B4,\"\\d+\",V$2))","v":""}]
[null,null,{"$f":"Salim_Single_Match($B5,\"\\d+\",COLUMNS($C$1:C3))","v":"No Match"},{"$f":"IF(COUNTIF($C5:C5,Salim_Single_Match($B5,\"\\d+\",D$2))=1,\"\",Salim_Single_Match($B5,\"\\d+\",D$2))","v":""},{"$f":"IF(COUNTIF($C5:D5,Salim_Single_Match($B5,\"\\d+\",E$2))=1,\"\",Salim_Single_Match($B5,\"\\d+\",E$2))","v":""},{"$f":"IF(COUNTIF($C5:E5,Salim_Single_Match($B5,\"\\d+\",F$2))=1,\"\",Salim_Single_Match($B5,\"\\d+\",F$2))","v":""},{"$f":"IF(COUNTIF($C5:F5,Salim_Single_Match($B5,\"\\d+\",G$2))=1,\"\",Salim_Single_Match($B5,\"\\d+\",G$2))","v":""},{"$f":"IF(COUNTIF($C5:G5,Salim_Single_Match($B5,\"\\d+\",H$2))=1,\"\",Salim_Single_Match($B5,\"\\d+\",H$2))","v":""},{"$f":"IF(COUNTIF($C5:H5,Salim_Single_Match($B5,\"\\d+\",I$2))=1,\"\",Salim_Single_Match($B5,\"\\d+\",I$2))","v":""},{"$f":"IF(COUNTIF($C5:I5,Salim_Single_Match($B5,\"\\d+\",J$2))=1,\"\",Salim_Single_Match($B5,\"\\d+\",J$2))","v":""},{"$f":"IF(COUNTIF($C5:J5,Salim_Single_Match($B5,\"\\d+\",K$2))=1,\"\",Salim_Single_Match($B5,\"\\d+\",K$2))","v":""},{"$f":"IF(COUNTIF($C5:K5,Salim_Single_Match($B5,\"\\d+\",L$2))=1,\"\",Salim_Single_Match($B5,\"\\d+\",L$2))","v":""},{"$f":"IF(COUNTIF($C5:L5,Salim_Single_Match($B5,\"\\d+\",M$2))=1,\"\",Salim_Single_Match($B5,\"\\d+\",M$2))","v":""},{"$f":"IF(COUNTIF($C5:M5,Salim_Single_Match($B5,\"\\d+\",N$2))=1,\"\",Salim_Single_Match($B5,\"\\d+\",N$2))","v":""},{"$f":"IF(COUNTIF($C5:N5,Salim_Single_Match($B5,\"\\d+\",O$2))=1,\"\",Salim_Single_Match($B5,\"\\d+\",O$2))","v":""},{"$f":"IF(COUNTIF($C5:O5,Salim_Single_Match($B5,\"\\d+\",P$2))=1,\"\",Salim_Single_Match($B5,\"\\d+\",P$2))","v":""},{"$f":"IF(COUNTIF($C5:P5,Salim_Single_Match($B5,\"\\d+\",Q$2))=1,\"\",Salim_Single_Match($B5,\"\\d+\",Q$2))","v":""},{"$f":"IF(COUNTIF($C5:Q5,Salim_Single_Match($B5,\"\\d+\",R$2))=1,\"\",Salim_Single_Match($B5,\"\\d+\",R$2))","v":""},{"$f":"IF(COUNTIF($C5:R5,Salim_Single_Match($B5,\"\\d+\",S$2))=1,\"\",Salim_Single_Match($B5,\"\\d+\",S$2))","v":""},{"$f":"IF(COUNTIF($C5:S5,Salim_Single_Match($B5,\"\\d+\",T$2))=1,\"\",Salim_Single_Match($B5,\"\\d+\",T$2))","v":""},{"$f":"IF(COUNTIF($C5:T5,Salim_Single_Match($B5,\"\\d+\",U$2))=1,\"\",Salim_Single_Match($B5,\"\\d+\",U$2))","v":""},{"$f":"IF(COUNTIF($C5:U5,Salim_Single_Match($B5,\"\\d+\",V$2))=1,\"\",Salim_Single_Match($B5,\"\\d+\",V$2))","v":""}]
[null,null,{"$f":"Salim_Single_Match($B6,\"\\d+\",COLUMNS($C$1:C4))","v":"No Match"},{"$f":"IF(COUNTIF($C6:C6,Salim_Single_Match($B6,\"\\d+\",D$2))=1,\"\",Salim_Single_Match($B6,\"\\d+\",D$2))","v":""},{"$f":"IF(COUNTIF($C6:D6,Salim_Single_Match($B6,\"\\d+\",E$2))=1,\"\",Salim_Single_Match($B6,\"\\d+\",E$2))","v":""},{"$f":"IF(COUNTIF($C6:E6,Salim_Single_Match($B6,\"\\d+\",F$2))=1,\"\",Salim_Single_Match($B6,\"\\d+\",F$2))","v":""},{"$f":"IF(COUNTIF($C6:F6,Salim_Single_Match($B6,\"\\d+\",G$2))=1,\"\",Salim_Single_Match($B6,\"\\d+\",G$2))","v":""},{"$f":"IF(COUNTIF($C6:G6,Salim_Single_Match($B6,\"\\d+\",H$2))=1,\"\",Salim_Single_Match($B6,\"\\d+\",H$2))","v":""},{"$f":"IF(COUNTIF($C6:H6,Salim_Single_Match($B6,\"\\d+\",I$2))=1,\"\",Salim_Single_Match($B6,\"\\d+\",I$2))","v":""},{"$f":"IF(COUNTIF($C6:I6,Salim_Single_Match($B6,\"\\d+\",J$2))=1,\"\",Salim_Single_Match($B6,\"\\d+\",J$2))","v":""},{"$f":"IF(COUNTIF($C6:J6,Salim_Single_Match($B6,\"\\d+\",K$2))=1,\"\",Salim_Single_Match($B6,\"\\d+\",K$2))","v":""},{"$f":"IF(COUNTIF($C6:K6,Salim_Single_Match($B6,\"\\d+\",L$2))=1,\"\",Salim_Single_Match($B6,\"\\d+\",L$2))","v":""},{"$f":"IF(COUNTIF($C6:L6,Salim_Single_Match($B6,\"\\d+\",M$2))=1,\"\",Salim_Single_Match($B6,\"\\d+\",M$2))","v":""},{"$f":"IF(COUNTIF($C6:M6,Salim_Single_Match($B6,\"\\d+\",N$2))=1,\"\",Salim_Single_Match($B6,\"\\d+\",N$2))","v":""},{"$f":"IF(COUNTIF($C6:N6,Salim_Single_Match($B6,\"\\d+\",O$2))=1,\"\",Salim_Single_Match($B6,\"\\d+\",O$2))","v":""},{"$f":"IF(COUNTIF($C6:O6,Salim_Single_Match($B6,\"\\d+\",P$2))=1,\"\",Salim_Single_Match($B6,\"\\d+\",P$2))","v":""},{"$f":"IF(COUNTIF($C6:P6,Salim_Single_Match($B6,\"\\d+\",Q$2))=1,\"\",Salim_Single_Match($B6,\"\\d+\",Q$2))","v":""},{"$f":"IF(COUNTIF($C6:Q6,Salim_Single_Match($B6,\"\\d+\",R$2))=1,\"\",Salim_Single_Match($B6,\"\\d+\",R$2))","v":""},{"$f":"IF(COUNTIF($C6:R6,Salim_Single_Match($B6,\"\\d+\",S$2))=1,\"\",Salim_Single_Match($B6,\"\\d+\",S$2))","v":""},{"$f":"IF(COUNTIF($C6:S6,Salim_Single_Match($B6,\"\\d+\",T$2))=1,\"\",Salim_Single_Match($B6,\"\\d+\",T$2))","v":""},{"$f":"IF(COUNTIF($C6:T6,Salim_Single_Match($B6,\"\\d+\",U$2))=1,\"\",Salim_Single_Match($B6,\"\\d+\",U$2))","v":""},{"$f":"IF(COUNTIF($C6:U6,Salim_Single_Match($B6,\"\\d+\",V$2))=1,\"\",Salim_Single_Match($B6,\"\\d+\",V$2))","v":""}]
[]
[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,null,null,"ثانيا المعادله تفصل الارقام العشريه وتضعها فى خلايا منفصله ولكن المطلوب هو وضع الرقم كامل بالارقام العشريه فى خليه منفصله كما هو موجود فى الاسفل كتوضيح","*"]
[]
[null,null,null,null,"الجدول فى الاعلى يقرا الاكواد",-1]
[null,null,null,null," الجدول فى الاسفل للتوضيح فقط  يوجد بها النتيجه المطلوبه عملها  عن طريق الاكواد",-2]
[]
[null,"(E.4274.799  N.5562.035) to (E.4301.11  N.5562.035) to (E.4301.11  N.5560.53)",4274.799,5562.0349999999999,4301.1099999999997,5562.0349999999999,4301.1099999999997,5560.53,null,null,null,null,null,null,null,null,null,null,"","","",""]