{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Лист1","КОНЕЧНАЯ РАЗБИВКА"],"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":"Лист1","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"КОНЕЧНАЯ РАЗБИВКА","index":1,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Начальный текст",null,null,null,null,"1 разбивка (1 способ)","2 разбивка (1 способ)","1 разбивка (2 способ)","2 разбивка (2 способ)","Проверка 1","Проверка 2",null,"[A-Za-zА-Яа-яЁё\\s]*[\\d\\,\\-]+"]
["Более 29 не более 35",{"$f":"CONCATENATE(SUBSTITUTE(A2,MID(A2,MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\")),MAX(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))-MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))+1),\"\"),IF(ISBLANK(MID(A2,MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\")),MAX(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))-MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A2,MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\")),MAX(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))-MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A2,MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\")),MAX(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))-MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A2,MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\")),MAX(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))-MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A2,MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\")),MAX(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))-MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A2,MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\")),MAX(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))-MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A2,MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\")),MAX(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))-MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))","v":"Более 29"},{"$f":"TRIM(SUBSTITUTE(A2,CONCATENATE(SUBSTITUTE(A2,MID(A2,MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\")),MAX(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))-MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))+1),\"\"),IF(ISBLANK(MID(A2,MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\")),MAX(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))-MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A2,MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\")),MAX(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))-MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A2,MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\")),MAX(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))-MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A2,MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\")),MAX(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))-MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A2,MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\")),MAX(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))-MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A2,MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\")),MAX(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))-MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A2,MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\")),MAX(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))-MIN(IF((CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))>47)*(CODE(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A2))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))),\"\"))","v":"не более 35"},{"$f":"TRIM(LEFT(A2,MIN(IF(ISNUMBER(-MID(A2,ROW($2:$16),1)),ROW($2:$16)))+LEN(IF(ISBLANK(A2),\"\",IF(ISERROR(IF(A2<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A2),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A2&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A2&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))))","v":"Более 29"},{"$f":"IFERROR(TRIM(RIGHT(A2,LOOKUP(2,1/ISNUMBER(-MID(A2,ROW($2:$16),1)),ROW($2:$16))-MIN(IF(ISNUMBER(-MID(A2,ROW($2:$16),1)),ROW($2:$16)))-LEN(IF(ISBLANK(A2),\"\",IF(ISERROR(IF(A2<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A2),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A2&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A2&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))))),\"\")","v":""},{"$f":"TRIM(SUBSTITUTE(D2,CHAR(10),\"\"))","v":"Более 29"},{"$f":"TRIM(SUBSTITUTE(E2,CHAR(10),\"\"))","v":""},{"$f":"TRIM(SUBSTITUTE(B2,CHAR(10),\"\"))","v":"Более 29"},{"$f":"TRIM(SUBSTITUTE(C2,CHAR(10),\"\"))","v":"не более 35"},{"$f":"F2=H2","v":true},{"$f":"G2=I2","v":false},"НОРМ",{"$f":"RegExcecute(A2,$M$1,1)","v":"Более 29"},{"$f":"RegExcecute(A2,$M$1,2)","v":" не более 35"}]
["123,0;5,0",{"$f":"CONCATENATE(SUBSTITUTE(A3,MID(A3,MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\")),MAX(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))-MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))+1),\"\"),IF(ISBLANK(MID(A3,MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\")),MAX(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))-MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A3,MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\")),MAX(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))-MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A3,MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\")),MAX(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))-MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A3,MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\")),MAX(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))-MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A3,MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\")),MAX(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))-MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A3,MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\")),MAX(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))-MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A3,MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\")),MAX(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))-MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))","v":"123"},{"$f":"TRIM(SUBSTITUTE(A3,CONCATENATE(SUBSTITUTE(A3,MID(A3,MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\")),MAX(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))-MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))+1),\"\"),IF(ISBLANK(MID(A3,MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\")),MAX(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))-MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A3,MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\")),MAX(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))-MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A3,MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\")),MAX(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))-MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A3,MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\")),MAX(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))-MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A3,MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\")),MAX(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))-MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A3,MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\")),MAX(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))-MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A3,MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\")),MAX(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))-MIN(IF((CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))>47)*(CODE(MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A3))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))),\"\"))","v":",0;5,0"},{"$f":"TRIM(LEFT(A3,MIN(IF(ISNUMBER(-MID(A3,ROW($2:$16),1)),ROW($2:$16)))+LEN(IF(ISBLANK(A3),\"\",IF(ISERROR(IF(A3<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A3),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A3&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A3&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A3&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A3&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))))","v":"123,0"},{"$f":"IFERROR(TRIM(RIGHT(A3,LOOKUP(2,1/ISNUMBER(-MID(A3,ROW($2:$16),1)),ROW($2:$16))-MIN(IF(ISNUMBER(-MID(A3,ROW($2:$16),1)),ROW($2:$16)))-LEN(IF(ISBLANK(A3),\"\",IF(ISERROR(IF(A3<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A3),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A3&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A3&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A3&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A3&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))))),\"\")","v":";5,0"},{"$f":"TRIM(SUBSTITUTE(D3,CHAR(10),\"\"))","v":"123,0"},{"$f":"TRIM(SUBSTITUTE(E3,CHAR(10),\"\"))","v":";5,0"},{"$f":"TRIM(SUBSTITUTE(B3,CHAR(10),\"\"))","v":"123"},",0;5,0",{"$f":"F3=H3","v":false},false,"такого быть не должно, так как при дальнейшей обработке у меня из ячейки I выцепится число \"0\", а должно выцепиться \"5,0\"",{"$f":"RegExcecute(A3,$M$1,1)","v":"123,0"},{"$f":"RegExcecute(A3,$M$1,2)","v":"5,0"}]
["2000;5",{"$f":"CONCATENATE(SUBSTITUTE(A4,MID(A4,MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\")),MAX(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))-MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))+1),\"\"),IF(ISBLANK(MID(A4,MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\")),MAX(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))-MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A4,MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\")),MAX(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))-MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A4,MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\")),MAX(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))-MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A4,MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\")),MAX(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))-MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A4,MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\")),MAX(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))-MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A4,MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\")),MAX(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))-MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A4,MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\")),MAX(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))-MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))","v":"2000"},{"$f":"TRIM(SUBSTITUTE(A4,CONCATENATE(SUBSTITUTE(A4,MID(A4,MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\")),MAX(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))-MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))+1),\"\"),IF(ISBLANK(MID(A4,MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\")),MAX(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))-MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A4,MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\")),MAX(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))-MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A4,MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\")),MAX(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))-MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A4,MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\")),MAX(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))-MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A4,MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\")),MAX(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))-MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A4,MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\")),MAX(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))-MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A4,MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\")),MAX(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))-MIN(IF((CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))>47)*(CODE(MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A4))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))),\"\"))","v":";5"},{"$f":"TRIM(LEFT(A4,MIN(IF(ISNUMBER(-MID(A4,ROW($2:$16),1)),ROW($2:$16)))+LEN(IF(ISBLANK(A4),\"\",IF(ISERROR(IF(A4<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A4),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A4&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A4&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A4&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A4&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))))","v":"2000;5"},{"$f":"IFERROR(TRIM(RIGHT(A4,LOOKUP(2,1/ISNUMBER(-MID(A4,ROW($2:$16),1)),ROW($2:$16))-MIN(IF(ISNUMBER(-MID(A4,ROW($2:$16),1)),ROW($2:$16)))-LEN(IF(ISBLANK(A4),\"\",IF(ISERROR(IF(A4<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A4),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A4&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A4&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A4&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A4&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))))),\"\")","v":""},"2000;5",{"$f":"TRIM(SUBSTITUTE(E4,CHAR(10),\"\"))","v":""},"2000",";5",false,false,null,"2000","5"]
["должен быть менее 3",{"$f":"CONCATENATE(SUBSTITUTE(A5,MID(A5,MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\")),MAX(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))-MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))+1),\"\"),IF(ISBLANK(MID(A5,MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\")),MAX(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))-MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A5,MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\")),MAX(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))-MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A5,MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\")),MAX(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))-MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A5,MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\")),MAX(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))-MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A5,MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\")),MAX(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))-MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A5,MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\")),MAX(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))-MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A5,MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\")),MAX(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))-MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))","v":"должен быть менее 3"},{"$f":"TRIM(SUBSTITUTE(A5,CONCATENATE(SUBSTITUTE(A5,MID(A5,MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\")),MAX(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))-MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))+1),\"\"),IF(ISBLANK(MID(A5,MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\")),MAX(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))-MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A5,MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\")),MAX(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))-MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A5,MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\")),MAX(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))-MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A5,MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\")),MAX(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))-MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A5,MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\")),MAX(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))-MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A5,MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\")),MAX(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))-MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A5,MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\")),MAX(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))-MIN(IF((CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))>47)*(CODE(MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A5))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))),\"\"))","v":""},{"$f":"TRIM(LEFT(A5,MIN(IF(ISNUMBER(-MID(A5,ROW($2:$16),1)),ROW($2:$16)))+LEN(IF(ISBLANK(A5),\"\",IF(ISERROR(IF(A5<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A5),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A5&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A5&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A5&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A5&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))))","v":"д"},{"$f":"IFERROR(TRIM(RIGHT(A5,LOOKUP(2,1/ISNUMBER(-MID(A5,ROW($2:$16),1)),ROW($2:$16))-MIN(IF(ISNUMBER(-MID(A5,ROW($2:$16),1)),ROW($2:$16)))-LEN(IF(ISBLANK(A5),\"\",IF(ISERROR(IF(A5<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A5),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A5&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A5&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A5&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A5&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))))),\"\")","v":""},"д",{"$f":"TRIM(SUBSTITUTE(E5,CHAR(10),\"\"))","v":""},"должен быть менее 3","",false,true,"НОРМ","должен быть менее 3","-"]
["должен быть менее 3 не должен быть выше 5",{"$f":"CONCATENATE(SUBSTITUTE(A6,MID(A6,MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\")),MAX(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))-MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))+1),\"\"),IF(ISBLANK(MID(A6,MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\")),MAX(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))-MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A6,MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\")),MAX(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))-MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A6,MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\")),MAX(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))-MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A6,MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\")),MAX(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))-MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A6,MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\")),MAX(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))-MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A6,MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\")),MAX(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))-MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A6,MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\")),MAX(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))-MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))","v":"должен быть менее 3"},{"$f":"TRIM(SUBSTITUTE(A6,CONCATENATE(SUBSTITUTE(A6,MID(A6,MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\")),MAX(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))-MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))+1),\"\"),IF(ISBLANK(MID(A6,MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\")),MAX(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))-MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A6,MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\")),MAX(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))-MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A6,MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\")),MAX(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))-MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A6,MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\")),MAX(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))-MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A6,MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\")),MAX(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))-MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A6,MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\")),MAX(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))-MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A6,MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\")),MAX(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))-MIN(IF((CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))>47)*(CODE(MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A6))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))),\"\"))","v":"не должен быть выше 5"},{"$f":"TRIM(LEFT(A6,MIN(IF(ISNUMBER(-MID(A6,ROW($2:$16),1)),ROW($2:$16)))+LEN(IF(ISBLANK(A6),\"\",IF(ISERROR(IF(A6<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A6),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A6&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A6&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A6&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A6&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))))","v":"д"},{"$f":"IFERROR(TRIM(RIGHT(A6,LOOKUP(2,1/ISNUMBER(-MID(A6,ROW($2:$16),1)),ROW($2:$16))-MIN(IF(ISNUMBER(-MID(A6,ROW($2:$16),1)),ROW($2:$16)))-LEN(IF(ISBLANK(A6),\"\",IF(ISERROR(IF(A6<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A6),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A6&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A6&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A6&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A6&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))))),\"\")","v":""},"д",{"$f":"TRIM(SUBSTITUTE(E6,CHAR(10),\"\"))","v":""},"должен быть менее 3","не должен быть выше 5",false,false,"НОРМ","должен быть менее 3"," не должен быть выше 5"]
["выше 4",{"$f":"CONCATENATE(SUBSTITUTE(A7,MID(A7,MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\")),MAX(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))-MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))+1),\"\"),IF(ISBLANK(MID(A7,MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\")),MAX(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))-MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A7,MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\")),MAX(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))-MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A7,MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\")),MAX(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))-MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A7,MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\")),MAX(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))-MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A7,MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\")),MAX(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))-MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A7,MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\")),MAX(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))-MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A7,MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\")),MAX(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))-MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))","v":"выше 4"},{"$f":"TRIM(SUBSTITUTE(A7,CONCATENATE(SUBSTITUTE(A7,MID(A7,MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\")),MAX(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))-MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))+1),\"\"),IF(ISBLANK(MID(A7,MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\")),MAX(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))-MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A7,MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\")),MAX(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))-MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A7,MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\")),MAX(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))-MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A7,MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\")),MAX(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))-MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A7,MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\")),MAX(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))-MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A7,MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\")),MAX(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))-MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A7,MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\")),MAX(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))-MIN(IF((CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))>47)*(CODE(MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A7))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))),\"\"))","v":""},{"$f":"TRIM(LEFT(A7,MIN(IF(ISNUMBER(-MID(A7,ROW($2:$16),1)),ROW($2:$16)))+LEN(IF(ISBLANK(A7),\"\",IF(ISERROR(IF(A7<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A7),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A7&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A7&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A7&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A7&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))))","v":"выше 4"},{"$f":"IFERROR(TRIM(RIGHT(A7,LOOKUP(2,1/ISNUMBER(-MID(A7,ROW($2:$16),1)),ROW($2:$16))-MIN(IF(ISNUMBER(-MID(A7,ROW($2:$16),1)),ROW($2:$16)))-LEN(IF(ISBLANK(A7),\"\",IF(ISERROR(IF(A7<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A7),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A7&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A7&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A7&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A7&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))))),\"\")","v":""},"выше 4",{"$f":"TRIM(SUBSTITUTE(E7,CHAR(10),\"\"))","v":""},"выше 4","",true,true,"НОРМ","выше 4","-"]
["0,001 и менее 3",{"$f":"CONCATENATE(SUBSTITUTE(A8,MID(A8,MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\")),MAX(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))-MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))+1),\"\"),IF(ISBLANK(MID(A8,MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\")),MAX(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))-MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A8,MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\")),MAX(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))-MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A8,MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\")),MAX(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))-MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A8,MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\")),MAX(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))-MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A8,MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\")),MAX(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))-MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A8,MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\")),MAX(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))-MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A8,MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\")),MAX(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))-MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))","v":"0,001"},{"$f":"TRIM(SUBSTITUTE(A8,CONCATENATE(SUBSTITUTE(A8,MID(A8,MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\")),MAX(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))-MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))+1),\"\"),IF(ISBLANK(MID(A8,MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\")),MAX(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))-MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A8,MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\")),MAX(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))-MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A8,MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\")),MAX(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))-MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A8,MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\")),MAX(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))-MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A8,MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\")),MAX(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))-MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A8,MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\")),MAX(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))-MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A8,MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\")),MAX(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))-MIN(IF((CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))>47)*(CODE(MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A8))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))),\"\"))","v":"и менее 3"},{"$f":"TRIM(LEFT(A8,MIN(IF(ISNUMBER(-MID(A8,ROW($2:$16),1)),ROW($2:$16)))+LEN(IF(ISBLANK(A8),\"\",IF(ISERROR(IF(A8<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A8),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A8&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A8&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A8&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A8&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))))","v":"0,001 и"},{"$f":"IFERROR(TRIM(RIGHT(A8,LOOKUP(2,1/ISNUMBER(-MID(A8,ROW($2:$16),1)),ROW($2:$16))-MIN(IF(ISNUMBER(-MID(A8,ROW($2:$16),1)),ROW($2:$16)))-LEN(IF(ISBLANK(A8),\"\",IF(ISERROR(IF(A8<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A8),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A8&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A8&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A8&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A8&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))))),\"\")","v":"менее 3"},"0,001 и",{"$f":"TRIM(SUBSTITUTE(E8,CHAR(10),\"\"))","v":"менее 3"},"0,001","и менее 3",false,false,"в принципе если во второй ячейке будет \"и\" это не принципиально, так как при дальнейшей обработке \"и\"откидывается","0,001"," и менее 3"]
["123,00000000000001;5,0",{"$f":"CONCATENATE(SUBSTITUTE(A9,MID(A9,MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\")),MAX(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))-MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))+1),\"\"),IF(ISBLANK(MID(A9,MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\")),MAX(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))-MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A9,MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\")),MAX(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))-MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A9,MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\")),MAX(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))-MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A9,MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\")),MAX(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))-MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A9,MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\")),MAX(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))-MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A9,MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\")),MAX(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))-MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A9,MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\")),MAX(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))-MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))","v":"123"},{"$f":"TRIM(SUBSTITUTE(A9,CONCATENATE(SUBSTITUTE(A9,MID(A9,MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\")),MAX(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))-MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))+1),\"\"),IF(ISBLANK(MID(A9,MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\")),MAX(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))-MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A9,MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\")),MAX(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))-MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A9,MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\")),MAX(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))-MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A9,MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\")),MAX(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))-MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A9,MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\")),MAX(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))-MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A9,MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\")),MAX(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))-MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A9,MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\")),MAX(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))-MIN(IF((CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))>47)*(CODE(MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A9))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))),\"\"))","v":",00000000000001;5,0"},{"$f":"TRIM(LEFT(A9,MIN(IF(ISNUMBER(-MID(A9,ROW($2:$16),1)),ROW($2:$16)))+LEN(IF(ISBLANK(A9),\"\",IF(ISERROR(IF(A9<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A9),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A9&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A9&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A9&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A9&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))))","v":"123,0"},{"$f":"IFERROR(TRIM(RIGHT(A9,LOOKUP(2,1/ISNUMBER(-MID(A9,ROW($2:$16),1)),ROW($2:$16))-MIN(IF(ISNUMBER(-MID(A9,ROW($2:$16),1)),ROW($2:$16)))-LEN(IF(ISBLANK(A9),\"\",IF(ISERROR(IF(A9<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A9),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A9&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A9&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A9&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A9&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))))),\"\")","v":"0000001;5,0"},"123,0",{"$f":"TRIM(SUBSTITUTE(E9,CHAR(10),\"\"))","v":"0000001;5,0"},"123",",00000000000001;5,0",false,false,"тоже не подходит","123,00000000000001","5,0"]
["менее \"- 5\"\nболее 3,0001",{"$f":"CONCATENATE(SUBSTITUTE(A10,MID(A10,MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\")),MAX(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))-MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))+1),\"\"),IF(ISBLANK(MID(A10,MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\")),MAX(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))-MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A10,MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\")),MAX(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))-MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A10,MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\")),MAX(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))-MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A10,MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\")),MAX(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))-MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A10,MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\")),MAX(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))-MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A10,MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\")),MAX(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))-MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A10,MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\")),MAX(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))-MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))","v":"менее \"- 5"},{"$f":"TRIM(SUBSTITUTE(A10,CONCATENATE(SUBSTITUTE(A10,MID(A10,MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\")),MAX(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))-MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))+1),\"\"),IF(ISBLANK(MID(A10,MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\")),MAX(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))-MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A10,MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\")),MAX(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))-MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A10,MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\")),MAX(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))-MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A10,MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\")),MAX(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))-MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A10,MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\")),MAX(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))-MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A10,MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\")),MAX(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))-MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A10,MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\")),MAX(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))-MIN(IF((CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))>47)*(CODE(MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A10))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))),\"\"))","v":"\"\nболее 3,0001"},{"$f":"TRIM(LEFT(A10,MIN(IF(ISNUMBER(-MID(A10,ROW($2:$16),1)),ROW($2:$16)))+LEN(IF(ISBLANK(A10),\"\",IF(ISERROR(IF(A10<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A10),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A10&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A10&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A10&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A10&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))))","v":"менее \"- 5\"\n"},{"$f":"IFERROR(TRIM(RIGHT(A10,LOOKUP(2,1/ISNUMBER(-MID(A10,ROW($2:$16),1)),ROW($2:$16))-MIN(IF(ISNUMBER(-MID(A10,ROW($2:$16),1)),ROW($2:$16)))-LEN(IF(ISBLANK(A10),\"\",IF(ISERROR(IF(A10<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A10),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A10&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A10&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A10&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A10&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))))),\"\")","v":""},"менее \"- 5\"",{"$f":"TRIM(SUBSTITUTE(E10,CHAR(10),\"\"))","v":""},"менее \"- 5","\"более 3,0001",false,false,"такое норм","-"," 5"]
[".-1…2",{"$f":"CONCATENATE(SUBSTITUTE(A11,MID(A11,MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\")),MAX(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))-MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))+1),\"\"),IF(ISBLANK(MID(A11,MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\")),MAX(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))-MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A11,MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\")),MAX(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))-MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A11,MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\")),MAX(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))-MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A11,MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\")),MAX(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))-MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A11,MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\")),MAX(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))-MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A11,MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\")),MAX(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))-MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A11,MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\")),MAX(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))-MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))","v":".-1"},{"$f":"TRIM(SUBSTITUTE(A11,CONCATENATE(SUBSTITUTE(A11,MID(A11,MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\")),MAX(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))-MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))+1),\"\"),IF(ISBLANK(MID(A11,MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\")),MAX(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))-MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A11,MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\")),MAX(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))-MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A11,MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\")),MAX(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))-MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A11,MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\")),MAX(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))-MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A11,MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\")),MAX(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))-MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A11,MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\")),MAX(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))-MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A11,MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\")),MAX(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))-MIN(IF((CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))>47)*(CODE(MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A11))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))),\"\"))","v":"…2"},{"$f":"TRIM(LEFT(A11,MIN(IF(ISNUMBER(-MID(A11,ROW($2:$16),1)),ROW($2:$16)))+LEN(IF(ISBLANK(A11),\"\",IF(ISERROR(IF(A11<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A11),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A11&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A11&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A11&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A11&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))))","v":".-1…2"},{"$f":"IFERROR(TRIM(RIGHT(A11,LOOKUP(2,1/ISNUMBER(-MID(A11,ROW($2:$16),1)),ROW($2:$16))-MIN(IF(ISNUMBER(-MID(A11,ROW($2:$16),1)),ROW($2:$16)))-LEN(IF(ISBLANK(A11),\"\",IF(ISERROR(IF(A11<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A11),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A11&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A11&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A11&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A11&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))))),\"\")","v":""},".-1…2",{"$f":"TRIM(SUBSTITUTE(E11,CHAR(10),\"\"))","v":""},".-1","…2",false,false,"такое норм","-1","2"]
[".-1…-2",{"$f":"CONCATENATE(SUBSTITUTE(A12,MID(A12,MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\")),MAX(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))-MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))+1),\"\"),IF(ISBLANK(MID(A12,MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\")),MAX(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))-MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A12,MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\")),MAX(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))-MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A12,MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\")),MAX(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))-MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A12,MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\")),MAX(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))-MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A12,MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\")),MAX(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))-MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A12,MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\")),MAX(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))-MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A12,MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\")),MAX(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))-MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))","v":".--1"},{"$f":"TRIM(SUBSTITUTE(A12,CONCATENATE(SUBSTITUTE(A12,MID(A12,MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\")),MAX(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))-MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))+1),\"\"),IF(ISBLANK(MID(A12,MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\")),MAX(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))-MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A12,MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\")),MAX(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))-MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A12,MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\")),MAX(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))-MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A12,MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\")),MAX(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))-MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A12,MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\")),MAX(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))-MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A12,MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\")),MAX(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))-MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A12,MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\")),MAX(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))-MIN(IF((CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))>47)*(CODE(MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A12))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))),\"\"))","v":".-1…-2"},{"$f":"TRIM(LEFT(A12,MIN(IF(ISNUMBER(-MID(A12,ROW($2:$16),1)),ROW($2:$16)))+LEN(IF(ISBLANK(A12),\"\",IF(ISERROR(IF(A12<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A12),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A12&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A12&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A12&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A12&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))))","v":".-1…-"},{"$f":"IFERROR(TRIM(RIGHT(A12,LOOKUP(2,1/ISNUMBER(-MID(A12,ROW($2:$16),1)),ROW($2:$16))-MIN(IF(ISNUMBER(-MID(A12,ROW($2:$16),1)),ROW($2:$16)))-LEN(IF(ISBLANK(A12),\"\",IF(ISERROR(IF(A12<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A12),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A12&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A12&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A12&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A12&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))))),\"\")","v":"2"},".-1…-",{"$f":"TRIM(SUBSTITUTE(E12,CHAR(10),\"\"))","v":"2"},".--1",".-1…-2",false,false,"так уже не подходит","-1","-2"]
["менее -3,0",{"$f":"CONCATENATE(SUBSTITUTE(A13,MID(A13,MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\")),MAX(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))-MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))+1),\"\"),IF(ISBLANK(MID(A13,MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\")),MAX(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))-MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A13,MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\")),MAX(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))-MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A13,MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\")),MAX(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))-MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A13,MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\")),MAX(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))-MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A13,MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\")),MAX(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))-MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A13,MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\")),MAX(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))-MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A13,MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\")),MAX(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))-MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))","v":"менее -3"},{"$f":"TRIM(SUBSTITUTE(A13,CONCATENATE(SUBSTITUTE(A13,MID(A13,MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\")),MAX(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))-MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))+1),\"\"),IF(ISBLANK(MID(A13,MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\")),MAX(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))-MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A13,MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\")),MAX(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))-MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A13,MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\")),MAX(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))-MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A13,MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\")),MAX(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))-MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A13,MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\")),MAX(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))-MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A13,MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\")),MAX(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))-MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A13,MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\")),MAX(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))-MIN(IF((CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))>47)*(CODE(MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A13))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))),\"\"))","v":",0"},{"$f":"TRIM(LEFT(A13,MIN(IF(ISNUMBER(-MID(A13,ROW($2:$16),1)),ROW($2:$16)))+LEN(IF(ISBLANK(A13),\"\",IF(ISERROR(IF(A13<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A13),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A13&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A13&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A13&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A13&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))))","v":"менее -3,0"},{"$f":"IFERROR(TRIM(RIGHT(A13,LOOKUP(2,1/ISNUMBER(-MID(A13,ROW($2:$16),1)),ROW($2:$16))-MIN(IF(ISNUMBER(-MID(A13,ROW($2:$16),1)),ROW($2:$16)))-LEN(IF(ISBLANK(A13),\"\",IF(ISERROR(IF(A13<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A13),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A13&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A13&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A13&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A13&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))))),\"\")","v":""},"менее -3,0",{"$f":"TRIM(SUBSTITUTE(E13,CHAR(10),\"\"))","v":""},"менее -3",",0",false,false,"тоже не подходит","менее -3,0","-"]
["менее -3,0 более 1",{"$f":"CONCATENATE(SUBSTITUTE(A14,MID(A14,MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\")),MAX(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))-MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))+1),\"\"),IF(ISBLANK(MID(A14,MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\")),MAX(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))-MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A14,MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\")),MAX(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))-MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A14,MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\")),MAX(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))-MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A14,MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\")),MAX(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))-MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A14,MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\")),MAX(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))-MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A14,MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\")),MAX(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))-MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A14,MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\")),MAX(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))-MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))","v":"менее -3"},{"$f":"TRIM(SUBSTITUTE(A14,CONCATENATE(SUBSTITUTE(A14,MID(A14,MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\")),MAX(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))-MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))+1),\"\"),IF(ISBLANK(MID(A14,MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\")),MAX(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))-MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A14,MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\")),MAX(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))-MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A14,MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\")),MAX(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))-MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A14,MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\")),MAX(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))-MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A14,MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\")),MAX(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))-MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A14,MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\")),MAX(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))-MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A14,MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\")),MAX(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))-MIN(IF((CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))>47)*(CODE(MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A14))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))),\"\"))","v":",0 более 1"},{"$f":"TRIM(LEFT(A14,MIN(IF(ISNUMBER(-MID(A14,ROW($2:$16),1)),ROW($2:$16)))+LEN(IF(ISBLANK(A14),\"\",IF(ISERROR(IF(A14<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A14),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A14&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A14&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A14&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A14&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))))","v":"менее -3,0"},{"$f":"IFERROR(TRIM(RIGHT(A14,LOOKUP(2,1/ISNUMBER(-MID(A14,ROW($2:$16),1)),ROW($2:$16))-MIN(IF(ISNUMBER(-MID(A14,ROW($2:$16),1)),ROW($2:$16)))-LEN(IF(ISBLANK(A14),\"\",IF(ISERROR(IF(A14<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A14),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A14&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A14&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A14&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A14&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))))),\"\")","v":""},"менее -3,0",{"$f":"TRIM(SUBSTITUTE(E14,CHAR(10),\"\"))","v":""},"менее -3",",0 более 1",false,false,"тоже не подходит","менее -3,0"," более 1"]
["Не менее «-10» не более «+50»",{"$f":"CONCATENATE(SUBSTITUTE(A15,MID(A15,MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\")),MAX(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))-MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))+1),\"\"),IF(ISBLANK(MID(A15,MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\")),MAX(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))-MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A15,MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\")),MAX(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))-MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A15,MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\")),MAX(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))-MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A15,MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\")),MAX(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))-MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A15,MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\")),MAX(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))-MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A15,MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\")),MAX(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))-MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A15,MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\")),MAX(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))-MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))","v":"Не менее «-»10"},{"$f":"TRIM(SUBSTITUTE(A15,CONCATENATE(SUBSTITUTE(A15,MID(A15,MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\")),MAX(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))-MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))+1),\"\"),IF(ISBLANK(MID(A15,MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\")),MAX(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))-MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A15,MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\")),MAX(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))-MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A15,MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\")),MAX(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))-MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A15,MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\")),MAX(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))-MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A15,MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\")),MAX(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))-MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A15,MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\")),MAX(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))-MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A15,MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\")),MAX(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))-MIN(IF((CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))>47)*(CODE(MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A15))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))),\"\"))","v":"Не менее «-10» не более «+50»"},{"$f":"TRIM(LEFT(A15,MIN(IF(ISNUMBER(-MID(A15,ROW($2:$16),1)),ROW($2:$16)))+LEN(IF(ISBLANK(A15),\"\",IF(ISERROR(IF(A15<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A15),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A15&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A15&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A15&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A15&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))))","v":"Не менее «-10»"},{"$f":"IFERROR(TRIM(RIGHT(A15,LOOKUP(2,1/ISNUMBER(-MID(A15,ROW($2:$16),1)),ROW($2:$16))-MIN(IF(ISNUMBER(-MID(A15,ROW($2:$16),1)),ROW($2:$16)))-LEN(IF(ISBLANK(A15),\"\",IF(ISERROR(IF(A15<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A15),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A15&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A15&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A15&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A15&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))))),\"\")","v":""},"Не менее «-10»",{"$f":"TRIM(SUBSTITUTE(E15,CHAR(10),\"\"))","v":""},"Не менее «-»10","Не менее «-10» не более «+50»",false,false,"тоже не подходит","-10","50"]
["от 70 до 80",{"$f":"CONCATENATE(SUBSTITUTE(A16,MID(A16,MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\")),MAX(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))-MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))+1),\"\"),IF(ISBLANK(MID(A16,MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\")),MAX(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))-MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A16,MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\")),MAX(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))-MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A16,MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\")),MAX(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))-MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A16,MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\")),MAX(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))-MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A16,MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\")),MAX(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))-MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A16,MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\")),MAX(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))-MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A16,MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\")),MAX(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))-MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))","v":"от 70"},{"$f":"TRIM(SUBSTITUTE(A16,CONCATENATE(SUBSTITUTE(A16,MID(A16,MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\")),MAX(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))-MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))+1),\"\"),IF(ISBLANK(MID(A16,MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\")),MAX(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))-MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A16,MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\")),MAX(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))-MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A16,MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\")),MAX(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))-MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A16,MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\")),MAX(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))-MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A16,MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\")),MAX(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))-MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A16,MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\")),MAX(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))-MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A16,MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\")),MAX(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))-MIN(IF((CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))>47)*(CODE(MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A16))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))),\"\"))","v":"до 80"},{"$f":"TRIM(LEFT(A16,MIN(IF(ISNUMBER(-MID(A16,ROW($2:$16),1)),ROW($2:$16)))+LEN(IF(ISBLANK(A16),\"\",IF(ISERROR(IF(A16<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A16),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A16&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A16&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A16&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A16&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))))","v":"от 70"},{"$f":"IFERROR(TRIM(RIGHT(A16,LOOKUP(2,1/ISNUMBER(-MID(A16,ROW($2:$16),1)),ROW($2:$16))-MIN(IF(ISNUMBER(-MID(A16,ROW($2:$16),1)),ROW($2:$16)))-LEN(IF(ISBLANK(A16),\"\",IF(ISERROR(IF(A16<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A16),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A16&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A16&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A16&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A16&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))))),\"\")","v":"до 80"},"от 70",{"$f":"TRIM(SUBSTITUTE(E16,CHAR(10),\"\"))","v":"до 80"},"от 70","до 80",true,true,"НОРМ","от 70"," до 80"]
["Не менее W3",{"$f":"CONCATENATE(SUBSTITUTE(A17,MID(A17,MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\")),MAX(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))-MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))+1),\"\"),IF(ISBLANK(MID(A17,MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\")),MAX(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))-MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A17,MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\")),MAX(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))-MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A17,MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\")),MAX(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))-MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A17,MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\")),MAX(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))-MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A17,MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\")),MAX(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))-MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A17,MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\")),MAX(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))-MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A17,MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\")),MAX(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))-MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))","v":"Не менее W3"},{"$f":"TRIM(SUBSTITUTE(A17,CONCATENATE(SUBSTITUTE(A17,MID(A17,MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\")),MAX(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))-MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))+1),\"\"),IF(ISBLANK(MID(A17,MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\")),MAX(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))-MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A17,MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\")),MAX(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))-MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A17,MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\")),MAX(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))-MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A17,MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\")),MAX(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))-MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A17,MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\")),MAX(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))-MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A17,MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\")),MAX(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))-MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A17,MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\")),MAX(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))-MIN(IF((CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))>47)*(CODE(MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A17))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))),\"\"))","v":""},{"$f":"TRIM(LEFT(A17,MIN(IF(ISNUMBER(-MID(A17,ROW($2:$16),1)),ROW($2:$16)))+LEN(IF(ISBLANK(A17),\"\",IF(ISERROR(IF(A17<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A17),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A17&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A17&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A17&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A17&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))))","v":"Не менее W3"},{"$f":"IFERROR(TRIM(RIGHT(A17,LOOKUP(2,1/ISNUMBER(-MID(A17,ROW($2:$16),1)),ROW($2:$16))-MIN(IF(ISNUMBER(-MID(A17,ROW($2:$16),1)),ROW($2:$16)))-LEN(IF(ISBLANK(A17),\"\",IF(ISERROR(IF(A17<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A17),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A17&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A17&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A17&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A17&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))))),\"\")","v":""},"Не менее W3",{"$f":"TRIM(SUBSTITUTE(E17,CHAR(10),\"\"))","v":""},"Не менее W3","",true,true,null,"Не менее W3","-"]
["Не менее W3 и менее W6",{"$f":"CONCATENATE(SUBSTITUTE(A18,MID(A18,MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\")),MAX(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))-MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))+1),\"\"),IF(ISBLANK(MID(A18,MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\")),MAX(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))-MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A18,MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\")),MAX(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))-MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A18,MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\")),MAX(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))-MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A18,MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\")),MAX(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))-MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A18,MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\")),MAX(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))-MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A18,MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\")),MAX(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))-MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A18,MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\")),MAX(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))-MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))","v":"Не менее W3"},{"$f":"TRIM(SUBSTITUTE(A18,CONCATENATE(SUBSTITUTE(A18,MID(A18,MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\")),MAX(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))-MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))+1),\"\"),IF(ISBLANK(MID(A18,MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\")),MAX(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))-MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))+1)),\"\",IF(ISERROR(IF(MID(A18,MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\")),MAX(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))-MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))+1)<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},MID(A18,MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\")),MAX(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))-MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))+1)),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(MID(A18,MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\")),MAX(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))-MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A18,MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\")),MAX(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))-MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(MID(A18,MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\")),MAX(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))-MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))+1)&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A18,MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\")),MAX(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))-MIN(IF((CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))>47)*(CODE(MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))<58)=1,ROW(INDIRECT(\"1:\"&LEN(A18))),\"\"))+1)&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))),\"\"))","v":"и менее W6"},{"$f":"TRIM(LEFT(A18,MIN(IF(ISNUMBER(-MID(A18,ROW($2:$16),1)),ROW($2:$16)))+LEN(IF(ISBLANK(A18),\"\",IF(ISERROR(IF(A18<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A18),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A18&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A18&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A18&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A18&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1))))))","v":"Не менее W3"},{"$f":"IFERROR(TRIM(RIGHT(A18,LOOKUP(2,1/ISNUMBER(-MID(A18,ROW($2:$16),1)),ROW($2:$16))-MIN(IF(ISNUMBER(-MID(A18,ROW($2:$16),1)),ROW($2:$16)))-LEN(IF(ISBLANK(A18),\"\",IF(ISERROR(IF(A18<0,\"минус\",LOOKUP(2,1/SEARCH({\"-\";\"минус\"},A18),{\"минус\";\"минус\"}))),LOOKUP(99^99,--LEFT(MID(A18&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A18&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})),LOOKUP(99^99,--LEFT(MID(A18&\"_0\",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A18&\"_0123456789\")),15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))*(-1)))))),\"\")","v":""},"Не менее W3",{"$f":"TRIM(SUBSTITUTE(E18,CHAR(10),\"\"))","v":""},"Не менее W3","и менее W6",true,false,null,"Не менее W3"," и менее W6"]
[]
[null,{"$f":"FIND({\"а\",\"не\"},#REF!,0)","v":{"$error":"#REF!"}}]