{"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":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,5,1,15],[10,5,10,15]]}
[]
[null,null,null,null,null,"المعادله هنا تعطينى هذه النتيجه ( يتم فصل الارقام مع ازاله الاحرف او الكلمات ووضعها فى خانات مختلفه )"]
[]
[null,null,null,null,null,"Description",1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,null,"AXIS NO. (2/2A/33B)",{"$f":"Salim_Single_Match($F5,\"\\d+\",COLUMNS($D$1:D1))","v":"2"},{"$f":"IF(COUNTIF($G5:G5,Salim_Single_Match($F5,\"\\d+\",H$4))=1,\"\",Salim_Single_Match($F5,\"\\d+\",H$4))","v":""},{"$f":"IF(COUNTIF($G5:H5,Salim_Single_Match($F5,\"\\d+\",I$4))=1,\"\",Salim_Single_Match($F5,\"\\d+\",I$4))","v":"33"},{"$f":"IF(COUNTIF($G5:I5,Salim_Single_Match($F5,\"\\d+\",J$4))=1,\"\",Salim_Single_Match($F5,\"\\d+\",J$4))","v":""},{"$f":"IF(COUNTIF($G5:J5,Salim_Single_Match($F5,\"\\d+\",K$4))=1,\"\",Salim_Single_Match($F5,\"\\d+\",K$4))","v":""},{"$f":"IF(COUNTIF($G5:K5,Salim_Single_Match($F5,\"\\d+\",L$4))=1,\"\",Salim_Single_Match($F5,\"\\d+\",L$4))","v":""},{"$f":"IF(COUNTIF($G5:L5,Salim_Single_Match($F5,\"\\d+\",M$4))=1,\"\",Salim_Single_Match($F5,\"\\d+\",M$4))","v":""},{"$f":"IF(COUNTIF($G5:M5,Salim_Single_Match($F5,\"\\d+\",N$4))=1,\"\",Salim_Single_Match($F5,\"\\d+\",N$4))","v":""},{"$f":"IF(COUNTIF($G5:N5,Salim_Single_Match($F5,\"\\d+\",O$4))=1,\"\",Salim_Single_Match($F5,\"\\d+\",O$4))","v":""},{"$f":"IF(COUNTIF($G5:O5,Salim_Single_Match($F5,\"\\d+\",P$4))=1,\"\",Salim_Single_Match($F5,\"\\d+\",P$4))","v":""}]
[null,null,null,null,null,"AXIS NO. (15/90/44C-pt1/2B)",{"$f":"Salim_Single_Match($F6,\"\\d+\",COLUMNS($D$1:D4))","v":"15"},{"$f":"IF(COUNTIF($G6:G6,Salim_Single_Match($F6,\"\\d+\",H$4))=1,\"\",Salim_Single_Match($F6,\"\\d+\",H$4))","v":"90"},{"$f":"IF(COUNTIF($G6:H6,Salim_Single_Match($F6,\"\\d+\",I$4))=1,\"\",Salim_Single_Match($F6,\"\\d+\",I$4))","v":"44"},{"$f":"IF(COUNTIF($G6:I6,Salim_Single_Match($F6,\"\\d+\",J$4))=1,\"\",Salim_Single_Match($F6,\"\\d+\",J$4))","v":"1"},{"$f":"IF(COUNTIF($G6:J6,Salim_Single_Match($F6,\"\\d+\",K$4))=1,\"\",Salim_Single_Match($F6,\"\\d+\",K$4))","v":"2"},{"$f":"IF(COUNTIF($G6:K6,Salim_Single_Match($F6,\"\\d+\",L$4))=1,\"\",Salim_Single_Match($F6,\"\\d+\",L$4))","v":""},{"$f":"IF(COUNTIF($G6:L6,Salim_Single_Match($F6,\"\\d+\",M$4))=1,\"\",Salim_Single_Match($F6,\"\\d+\",M$4))","v":""},{"$f":"IF(COUNTIF($G6:M6,Salim_Single_Match($F6,\"\\d+\",N$4))=1,\"\",Salim_Single_Match($F6,\"\\d+\",N$4))","v":""},{"$f":"IF(COUNTIF($G6:N6,Salim_Single_Match($F6,\"\\d+\",O$4))=1,\"\",Salim_Single_Match($F6,\"\\d+\",O$4))","v":""},{"$f":"IF(COUNTIF($G6:O6,Salim_Single_Match($F6,\"\\d+\",P$4))=1,\"\",Salim_Single_Match($F6,\"\\d+\",P$4))","v":""}]
[null,null,null,null,null,"AXIS NO. (806/43A/2B-pt2/2B-pt3/50/60/70)",{"$f":"Salim_Single_Match($F7,\"\\d+\",COLUMNS($D$1:D5))","v":"806"},{"$f":"IF(COUNTIF($G7:G7,Salim_Single_Match($F7,\"\\d+\",H$4))=1,\"\",Salim_Single_Match($F7,\"\\d+\",H$4))","v":"43"},{"$f":"IF(COUNTIF($G7:H7,Salim_Single_Match($F7,\"\\d+\",I$4))=1,\"\",Salim_Single_Match($F7,\"\\d+\",I$4))","v":"2"},{"$f":"IF(COUNTIF($G7:I7,Salim_Single_Match($F7,\"\\d+\",J$4))=1,\"\",Salim_Single_Match($F7,\"\\d+\",J$4))","v":""},{"$f":"IF(COUNTIF($G7:J7,Salim_Single_Match($F7,\"\\d+\",K$4))=1,\"\",Salim_Single_Match($F7,\"\\d+\",K$4))","v":""},{"$f":"IF(COUNTIF($G7:K7,Salim_Single_Match($F7,\"\\d+\",L$4))=1,\"\",Salim_Single_Match($F7,\"\\d+\",L$4))","v":"3"},{"$f":"IF(COUNTIF($G7:L7,Salim_Single_Match($F7,\"\\d+\",M$4))=1,\"\",Salim_Single_Match($F7,\"\\d+\",M$4))","v":"50"},{"$f":"IF(COUNTIF($G7:M7,Salim_Single_Match($F7,\"\\d+\",N$4))=1,\"\",Salim_Single_Match($F7,\"\\d+\",N$4))","v":"60"},{"$f":"IF(COUNTIF($G7:N7,Salim_Single_Match($F7,\"\\d+\",O$4))=1,\"\",Salim_Single_Match($F7,\"\\d+\",O$4))","v":"70"},{"$f":"IF(COUNTIF($G7:O7,Salim_Single_Match($F7,\"\\d+\",P$4))=1,\"\",Salim_Single_Match($F7,\"\\d+\",P$4))","v":""}]
[null,null,null,null,null,"AXIS NO. (7a/7b/73a-pt2/2B)",{"$f":"Salim_Single_Match($F8,\"\\d+\",COLUMNS($D$1:D6))","v":"7"},{"$f":"IF(COUNTIF($G8:G8,Salim_Single_Match($F8,\"\\d+\",H$4))=1,\"\",Salim_Single_Match($F8,\"\\d+\",H$4))","v":""},{"$f":"IF(COUNTIF($G8:H8,Salim_Single_Match($F8,\"\\d+\",I$4))=1,\"\",Salim_Single_Match($F8,\"\\d+\",I$4))","v":"73"},{"$f":"IF(COUNTIF($G8:I8,Salim_Single_Match($F8,\"\\d+\",J$4))=1,\"\",Salim_Single_Match($F8,\"\\d+\",J$4))","v":"2"},{"$f":"IF(COUNTIF($G8:J8,Salim_Single_Match($F8,\"\\d+\",K$4))=1,\"\",Salim_Single_Match($F8,\"\\d+\",K$4))","v":""},{"$f":"IF(COUNTIF($G8:K8,Salim_Single_Match($F8,\"\\d+\",L$4))=1,\"\",Salim_Single_Match($F8,\"\\d+\",L$4))","v":""},{"$f":"IF(COUNTIF($G8:L8,Salim_Single_Match($F8,\"\\d+\",M$4))=1,\"\",Salim_Single_Match($F8,\"\\d+\",M$4))","v":""},{"$f":"IF(COUNTIF($G8:M8,Salim_Single_Match($F8,\"\\d+\",N$4))=1,\"\",Salim_Single_Match($F8,\"\\d+\",N$4))","v":""},{"$f":"IF(COUNTIF($G8:N8,Salim_Single_Match($F8,\"\\d+\",O$4))=1,\"\",Salim_Single_Match($F8,\"\\d+\",O$4))","v":""},{"$f":"IF(COUNTIF($G8:O8,Salim_Single_Match($F8,\"\\d+\",P$4))=1,\"\",Salim_Single_Match($F8,\"\\d+\",P$4))","v":""}]
[]
[]
[null,null,null,null,null,"المطلوب التعديل على المعادله بحيث تعطينى النتيجه الموضحه فى الجدول الذى بالاسفل"]
[]
[null,null,null,null,null,"Description",1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,null,"AXIS NO. (2/2A/33B)",2,"2A","33B"]
[null,null,null,null,null,"AXIS NO. (15/90/44C-pt1/2B)",15,90,"44C-pt1","2B"]
[null,null,null,null,null,"AXIS NO. (806/43A/2B-pt2/2B-pt3/50/60/70)",806,"43A","2B-pt2","2B-pt3",50,60,70]
[null,null,null,null,null,"AXIS NO. (7a/7b/73a-pt2/2B)","7a","7b","73a-pt2","2B"]