{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Исходный текст",null,"Вариант Boroda"," Вариант InExSu(НЕ ВСЕ ДАННЫЕ ПЕРЕНОСЯТСЯ ВЕРНО)","Kuzmich"]
["Болт М10х60 8.8 цб пр 431sp-st , шт",{"$f":"LastComma(A2)","v":"шт"},{"$f":"TRIM(LEFT(A2,LEN(A2)-LEN(B2)-2))","v":"Болт М10х60 8.8 цб пр 431sp-st"},{"$f":"IFERROR(LEFT(A2,FIND(\",\",A2,FIND(\",\",A2)+1)-2),LEFT(A2,FIND(\",\",A2)-1))","v":"Болт М10х60 8.8 цб пр 431sp-st "},{"$f":"TextComma(A2)","v":"Болт М10х60 8.8 цб пр 431sp-st "}]
["Ось 12х48 261sp-eco , шт",{"$f":"LastComma(A3)","v":"шт"},{"$f":"TRIM(LEFT(A3,LEN(A3)-LEN(B3)-2))","v":"Ось 12х48 261sp-eco"},{"$f":"IFERROR(LEFT(A3,FIND(\",\",A3,FIND(\",\",A3)+1)-2),LEFT(A3,FIND(\",\",A3)-1))","v":"Ось 12х48 261sp-eco "},{"$f":"TextComma(A3)","v":"Ось 12х48 261sp-eco "}]
["Комплект для ворот  , компл","компл",{"$f":"TRIM(LEFT(A4,LEN(A4)-LEN(B4)-2))","v":"Комплект для ворот"},{"$f":"IFERROR(LEFT(A4,FIND(\",\",A4,FIND(\",\",A4)+1)-2),LEFT(A4,FIND(\",\",A4)-1))","v":"Комплект для ворот  "},"Комплект для ворот  "]
["Корпус улавлювача с основой optima,чр 50114, шт","шт",{"$f":"TRIM(LEFT(A5,LEN(A5)-LEN(B5)-2))","v":"Корпус улавлювача с основой optima,чр 50114"},{"$f":"IFERROR(LEFT(A5,FIND(\",\",A5,FIND(\",\",A5)+1)-2),LEFT(A5,FIND(\",\",A5)-1))","v":"Корпус улавлювача с основой optima,чр 5011"},"Корпус улавлювача с основой optima,чр 50114"]
["Наконечник 17х0,060 (круг), шт","шт",{"$f":"TRIM(LEFT(A6,LEN(A6)-LEN(B6)-2))","v":"Наконечник 17х0,060 (круг)"},{"$f":"IFERROR(LEFT(A6,FIND(\",\",A6,FIND(\",\",A6)+1)-2),LEFT(A6,FIND(\",\",A6)-1))","v":"Наконечник 17х0,060 (круг"},"Наконечник 17х0,060 (круг)"]
["Пластина прижимная  50х30х3,0 723sp-st, шт","шт",{"$f":"TRIM(LEFT(A7,LEN(A7)-LEN(B7)-2))","v":"Пластина прижимная 50х30х3,0 723sp-st"},{"$f":"IFERROR(LEFT(A7,FIND(\",\",A7,FIND(\",\",A7)+1)-2),LEFT(A7,FIND(\",\",A7)-1))","v":"Пластина прижимная  50х30х3,0 723sp-s"},"Пластина прижимная  50х30х3,0 723sp-st"]
["Сваи п/ф 108х3,0х2500, шт","шт",{"$f":"TRIM(LEFT(A8,LEN(A8)-LEN(B8)-2))","v":"Сваи п/ф 108х3,0х2500"},{"$f":"IFERROR(LEFT(A8,FIND(\",\",A8,FIND(\",\",A8)+1)-2),LEFT(A8,FIND(\",\",A8)-1))","v":"Сваи п/ф 108х3,0х250"},"Сваи п/ф 108х3,0х2500"]
["Полоса 15х3,0, м",{"$f":"LastComma(A9)","v":"м"},{"$f":"TRIM(LEFT(A9,LEN(A9)-LEN(B9)-2))","v":"Полоса 15х3,0"},{"$f":"IFERROR(LEFT(A9,FIND(\",\",A9,FIND(\",\",A9)+1)-2),LEFT(A9,FIND(\",\",A9)-1))","v":"Полоса 15х3,"},"Полоса 15х3,0"]
["Труба 45х8,0х3000, м",{"$f":"LastComma(A10)","v":"м"},{"$f":"TRIM(LEFT(A10,LEN(A10)-LEN(B10)-2))","v":"Труба 45х8,0х3000"},{"$f":"IFERROR(LEFT(A10,FIND(\",\",A10,FIND(\",\",A10)+1)-2),LEFT(A10,FIND(\",\",A10)-1))","v":"Труба 45х8,0х300"},"Труба 45х8,0х3000"]
["Круг 11,8 ст20 калибр., м","м",{"$f":"TRIM(LEFT(A11,LEN(A11)-LEN(B11)-2))","v":"Круг 11,8 ст20 калибр."},{"$f":"IFERROR(LEFT(A11,FIND(\",\",A11,FIND(\",\",A11)+1)-2),LEFT(A11,FIND(\",\",A11)-1))","v":"Круг 11,8 ст20 калибр"},"Круг 11,8 ст20 калибр."]
["Заклепка 5,0х8 AL/St пл /3-4,5 DIN 542sp-st, шт","шт",{"$f":"TRIM(LEFT(A12,LEN(A12)-LEN(B12)-2))","v":"Заклепка 5,0х8 AL/St пл /3-4,5 DIN 542sp-st"},{"$f":"IFERROR(LEFT(A12,FIND(\",\",A12,FIND(\",\",A12)+1)-2),LEFT(A12,FIND(\",\",A12)-1))","v":"Заклепка 5,0х8 AL/St пл /3-"},"Заклепка 5,0х8 AL/St пл /3-4,5 DIN 542sp-st"]
[]
[null,null,"ВСЕ ВЕРНО","не верный результат","ВСЕ ВЕРНО"]

{"sheet":"Лист2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}