{"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":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
["Наименование","Показатель","доп. Столбец"]
["ИП Кукла В.А",2,{"$f":"SUBSTITUTE(SUBSTITUTE(IF(ISNA(CHOOSE(MATCH(TRUE,ISNUMBER(SEARCH(Лист2!A$1:A$2,A3)),0),\"ИП \",\"ТОО \")),PROPER(SUBSTITUTE(LEFT(TRIM(A3)&\" \",SEARCH(\" \",TRIM(A3)&\" \")+1)&\"\"&MID(TRIM(A3)&\"   \",SEARCH(\"!\",SUBSTITUTE(TRIM(A3)&\"  \",\" \",\"!\",2))+1,1)&\"\",\" \",)),SUBSTITUTE(A3,INDEX(Лист2!A$1:A$2,MATCH(TRUE,ISNUMBER(SEARCH(Лист2!A$1:A$2,A3)),0)),\"\")),\" \",\"\"),\".\",\"\")","v":"КуклаВА"},{"$f":"COUNTIF(C:C,C3)&\" \"&IF(COUNTIF(C:C,C3)=COUNTIFS(C$3:C$12,C3,B$3:B$12,B3),\"\",\"имеются не соответсвия\")","v":"2 имеются не соответсвия"}]
["ИП Петров В.И",2,{"$f":"SUBSTITUTE(SUBSTITUTE(IF(ISNA(CHOOSE(MATCH(TRUE,ISNUMBER(SEARCH(Лист2!A$1:A$2,A4)),0),\"ИП \",\"ТОО \")),PROPER(SUBSTITUTE(LEFT(TRIM(A4)&\" \",SEARCH(\" \",TRIM(A4)&\" \")+1)&\"\"&MID(TRIM(A4)&\"   \",SEARCH(\"!\",SUBSTITUTE(TRIM(A4)&\"  \",\" \",\"!\",2))+1,1)&\"\",\" \",)),SUBSTITUTE(A4,INDEX(Лист2!A$1:A$2,MATCH(TRUE,ISNUMBER(SEARCH(Лист2!A$1:A$2,A4)),0)),\"\")),\" \",\"\"),\".\",\"\")","v":"ПетровВИ"},{"$f":"COUNTIF(C:C,C4)&\" \"&IF(COUNTIF(C:C,C4)=COUNTIFS(C$3:C$12,C4,B$3:B$12,B4),\"\",\"имеются не соответсвия\")","v":"1 "}]
["ТОО Чумаков А.П",1,{"$f":"SUBSTITUTE(SUBSTITUTE(IF(ISNA(CHOOSE(MATCH(TRUE,ISNUMBER(SEARCH(Лист2!A$1:A$2,A5)),0),\"ИП \",\"ТОО \")),PROPER(SUBSTITUTE(LEFT(TRIM(A5)&\" \",SEARCH(\" \",TRIM(A5)&\" \")+1)&\"\"&MID(TRIM(A5)&\"   \",SEARCH(\"!\",SUBSTITUTE(TRIM(A5)&\"  \",\" \",\"!\",2))+1,1)&\"\",\" \",)),SUBSTITUTE(A5,INDEX(Лист2!A$1:A$2,MATCH(TRUE,ISNUMBER(SEARCH(Лист2!A$1:A$2,A5)),0)),\"\")),\" \",\"\"),\".\",\"\")","v":"ЧумаковАП"},"2 "]
["Кукла Валя Анатольевна",1,{"$f":"SUBSTITUTE(SUBSTITUTE(IF(ISNA(CHOOSE(MATCH(TRUE,ISNUMBER(SEARCH(Лист2!A$1:A$2,A6)),0),\"ИП \",\"ТОО \")),PROPER(SUBSTITUTE(LEFT(TRIM(A6)&\" \",SEARCH(\" \",TRIM(A6)&\" \")+1)&\"\"&MID(TRIM(A6)&\"   \",SEARCH(\"!\",SUBSTITUTE(TRIM(A6)&\"  \",\" \",\"!\",2))+1,1)&\"\",\" \",)),SUBSTITUTE(A6,INDEX(Лист2!A$1:A$2,MATCH(TRUE,ISNUMBER(SEARCH(Лист2!A$1:A$2,A6)),0)),\"\")),\" \",\"\"),\".\",\"\")","v":"Куклава"},"2 имеются не соответсвия"]
["Петров Вова Александрович",3,{"$f":"SUBSTITUTE(SUBSTITUTE(IF(ISNA(CHOOSE(MATCH(TRUE,ISNUMBER(SEARCH(Лист2!A$1:A$2,A7)),0),\"ИП \",\"ТОО \")),PROPER(SUBSTITUTE(LEFT(TRIM(A7)&\" \",SEARCH(\" \",TRIM(A7)&\" \")+1)&\"\"&MID(TRIM(A7)&\"   \",SEARCH(\"!\",SUBSTITUTE(TRIM(A7)&\"  \",\" \",\"!\",2))+1,1)&\"\",\" \",)),SUBSTITUTE(A7,INDEX(Лист2!A$1:A$2,MATCH(TRUE,ISNUMBER(SEARCH(Лист2!A$1:A$2,A7)),0)),\"\")),\" \",\"\"),\".\",\"\")","v":"Петровва"},"1 "]
["ИП Иванов .И.В",1,{"$f":"SUBSTITUTE(SUBSTITUTE(IF(ISNA(CHOOSE(MATCH(TRUE,ISNUMBER(SEARCH(Лист2!A$1:A$2,A8)),0),\"ИП \",\"ТОО \")),PROPER(SUBSTITUTE(LEFT(TRIM(A8)&\" \",SEARCH(\" \",TRIM(A8)&\" \")+1)&\"\"&MID(TRIM(A8)&\"   \",SEARCH(\"!\",SUBSTITUTE(TRIM(A8)&\"  \",\" \",\"!\",2))+1,1)&\"\",\" \",)),SUBSTITUTE(A8,INDEX(Лист2!A$1:A$2,MATCH(TRUE,ISNUMBER(SEARCH(Лист2!A$1:A$2,A8)),0)),\"\")),\" \",\"\"),\".\",\"\")","v":"ИвановИВ"},"1 "]
["ИП Чупачупс",2,{"$f":"SUBSTITUTE(SUBSTITUTE(IF(ISNA(CHOOSE(MATCH(TRUE,ISNUMBER(SEARCH(Лист2!A$1:A$2,A9)),0),\"ИП \",\"ТОО \")),PROPER(SUBSTITUTE(LEFT(TRIM(A9)&\" \",SEARCH(\" \",TRIM(A9)&\" \")+1)&\"\"&MID(TRIM(A9)&\"   \",SEARCH(\"!\",SUBSTITUTE(TRIM(A9)&\"  \",\" \",\"!\",2))+1,1)&\"\",\" \",)),SUBSTITUTE(A9,INDEX(Лист2!A$1:A$2,MATCH(TRUE,ISNUMBER(SEARCH(Лист2!A$1:A$2,A9)),0)),\"\")),\" \",\"\"),\".\",\"\")","v":"Чупачупс"},"1 "]
["ТОО Чугун",1,{"$f":"SUBSTITUTE(SUBSTITUTE(IF(ISNA(CHOOSE(MATCH(TRUE,ISNUMBER(SEARCH(Лист2!A$1:A$2,A10)),0),\"ИП \",\"ТОО \")),PROPER(SUBSTITUTE(LEFT(TRIM(A10)&\" \",SEARCH(\" \",TRIM(A10)&\" \")+1)&\"\"&MID(TRIM(A10)&\"   \",SEARCH(\"!\",SUBSTITUTE(TRIM(A10)&\"  \",\" \",\"!\",2))+1,1)&\"\",\" \",)),SUBSTITUTE(A10,INDEX(Лист2!A$1:A$2,MATCH(TRUE,ISNUMBER(SEARCH(Лист2!A$1:A$2,A10)),0)),\"\")),\" \",\"\"),\".\",\"\")","v":"Чугун"},"2 имеются не соответсвия"]
["ТОО Чугун",2,{"$f":"SUBSTITUTE(SUBSTITUTE(IF(ISNA(CHOOSE(MATCH(TRUE,ISNUMBER(SEARCH(Лист2!A$1:A$2,A11)),0),\"ИП \",\"ТОО \")),PROPER(SUBSTITUTE(LEFT(TRIM(A11)&\" \",SEARCH(\" \",TRIM(A11)&\" \")+1)&\"\"&MID(TRIM(A11)&\"   \",SEARCH(\"!\",SUBSTITUTE(TRIM(A11)&\"  \",\" \",\"!\",2))+1,1)&\"\",\" \",)),SUBSTITUTE(A11,INDEX(Лист2!A$1:A$2,MATCH(TRUE,ISNUMBER(SEARCH(Лист2!A$1:A$2,A11)),0)),\"\")),\" \",\"\"),\".\",\"\")","v":"Чугун"},"2 имеются не соответсвия"]
["ТОО Чумаков А.П",1,{"$f":"SUBSTITUTE(SUBSTITUTE(IF(ISNA(CHOOSE(MATCH(TRUE,ISNUMBER(SEARCH(Лист2!A$1:A$2,A12)),0),\"ИП \",\"ТОО \")),PROPER(SUBSTITUTE(LEFT(TRIM(A12)&\" \",SEARCH(\" \",TRIM(A12)&\" \")+1)&\"\"&MID(TRIM(A12)&\"   \",SEARCH(\"!\",SUBSTITUTE(TRIM(A12)&\"  \",\" \",\"!\",2))+1,1)&\"\",\" \",)),SUBSTITUTE(A12,INDEX(Лист2!A$1:A$2,MATCH(TRUE,ISNUMBER(SEARCH(Лист2!A$1:A$2,A12)),0)),\"\")),\" \",\"\"),\".\",\"\")","v":"ЧумаковАП"},"2 "]

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

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