{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
["Наименование","Показатель","Кол дубликатов с проверкой показателя","Как должно"]
["ИП Кукла В.А",2,{"$f":"COUNTIF(A:A,A3)&IF(COUNTIF(A:A,A3)=COUNTIFS(A$3:A$12,A3,B$3:B$12,B3),\"\",\" имеются несоответствия\")","v":"1"},"2 имеются не соответсвия",{"$f":"COUNTIF(A$3:A$12,A3)&IF((COUNTIF(A$3:A$12,A3)<>SUM(N(A$3:A$12&B$3:B$12=A3&B3)))+IF(CODE(MID(A3,2,1))<224,SUM((B3<>B$3:B$12)*ISNUMBER(SEARCH(SUBSTITUTE(MID(A3,SEARCH(\" \",A3)+1,99),\".\",\" \"),MID(A$3:A$12,1,SEARCH(\" \",A$3:A$12)+1)&MID(A$3:A$12,SEARCH(\" \",A$3:A$12,SEARCH(\" \",A$3:A$12)+1),2)))),SUM((B3<>B$3:B$12)*ISNUMBER(SEARCH(MID(A3,1,SEARCH(\" \",A3)+1)&MID(A3,SEARCH(\" \",A3,SEARCH(\" \",A3)+1),2),SUBSTITUTE(MID(A$3:A$12,SEARCH(\" \",A$3:A$12)+1,99),\".\",\" \"))))),\" имеются несоответствия\",\"\")","v":"1 имеются несоответствия"}]
["ИП Петров В.И",2,{"$f":"COUNTIF(A:A,A4)&\" \"&IF(COUNTIF(A:A,A4)=COUNTIFS(A$3:A$12,A4,B$3:B$12,B4),\"\",\"имеются не соответсвия\")","v":"1 "},2,{"$f":"COUNTIF(A$3:A$12,A4)&IF((COUNTIF(A$3:A$12,A4)<>SUM(N(A$3:A$12&B$3:B$12=A4&B4)))+IF(CODE(MID(A4,2,1))<224,SUM((B4<>B$3:B$12)*ISNUMBER(SEARCH(SUBSTITUTE(MID(A4,SEARCH(\" \",A4)+1,99),\".\",\" \"),MID(A$3:A$12,1,SEARCH(\" \",A$3:A$12)+1)&MID(A$3:A$12,SEARCH(\" \",A$3:A$12,SEARCH(\" \",A$3:A$12)+1),2)))),SUM((B4<>B$3:B$12)*ISNUMBER(SEARCH(MID(A4,1,SEARCH(\" \",A4)+1)&MID(A4,SEARCH(\" \",A4,SEARCH(\" \",A4)+1),2),SUBSTITUTE(MID(A$3:A$12,SEARCH(\" \",A$3:A$12)+1,99),\".\",\" \"))))),\" имеются несоответствия\",\"\")","v":"1"}]
["ТОО Чумаков А.П",1,"2 ",2,{"$f":"COUNTIF(A$3:A$12,A5)&IF((COUNTIF(A$3:A$12,A5)<>SUM(N(A$3:A$12&B$3:B$12=A5&B5)))+IF(CODE(MID(A5,2,1))<224,SUM((B5<>B$3:B$12)*ISNUMBER(SEARCH(SUBSTITUTE(MID(A5,SEARCH(\" \",A5)+1,99),\".\",\" \"),MID(A$3:A$12,1,SEARCH(\" \",A$3:A$12)+1)&MID(A$3:A$12,SEARCH(\" \",A$3:A$12,SEARCH(\" \",A$3:A$12)+1),2)))),SUM((B5<>B$3:B$12)*ISNUMBER(SEARCH(MID(A5,1,SEARCH(\" \",A5)+1)&MID(A5,SEARCH(\" \",A5,SEARCH(\" \",A5)+1),2),SUBSTITUTE(MID(A$3:A$12,SEARCH(\" \",A$3:A$12)+1,99),\".\",\" \"))))),\" имеются несоответствия\",\"\")","v":"2"}]
["Кукла Валя Анатольевна",1,"1 ",2,{"$f":"COUNTIF(A$3:A$12,A6)&IF((COUNTIF(A$3:A$12,A6)<>SUM(N(A$3:A$12&B$3:B$12=A6&B6)))+IF(CODE(MID(A6,2,1))<224,SUM((B6<>B$3:B$12)*ISNUMBER(SEARCH(SUBSTITUTE(MID(A6,SEARCH(\" \",A6)+1,99),\".\",\" \"),MID(A$3:A$12,1,SEARCH(\" \",A$3:A$12)+1)&MID(A$3:A$12,SEARCH(\" \",A$3:A$12,SEARCH(\" \",A$3:A$12)+1),2)))),SUM((B6<>B$3:B$12)*ISNUMBER(SEARCH(MID(A6,1,SEARCH(\" \",A6)+1)&MID(A6,SEARCH(\" \",A6,SEARCH(\" \",A6)+1),2),SUBSTITUTE(MID(A$3:A$12,SEARCH(\" \",A$3:A$12)+1,99),\".\",\" \"))))),\" имеются несоответствия\",\"\")","v":"1 имеются несоответствия"}]
["Петров Вова Александрович",3,"1 ","2 имеются не соответсвия",{"$f":"COUNTIF(A$3:A$12,A7)&IF((COUNTIF(A$3:A$12,A7)<>SUM(N(A$3:A$12&B$3:B$12=A7&B7)))+IF(CODE(MID(A7,2,1))<224,SUM((B7<>B$3:B$12)*ISNUMBER(SEARCH(SUBSTITUTE(MID(A7,SEARCH(\" \",A7)+1,99),\".\",\" \"),MID(A$3:A$12,1,SEARCH(\" \",A$3:A$12)+1)&MID(A$3:A$12,SEARCH(\" \",A$3:A$12,SEARCH(\" \",A$3:A$12)+1),2)))),SUM((B7<>B$3:B$12)*ISNUMBER(SEARCH(MID(A7,1,SEARCH(\" \",A7)+1)&MID(A7,SEARCH(\" \",A7,SEARCH(\" \",A7)+1),2),SUBSTITUTE(MID(A$3:A$12,SEARCH(\" \",A$3:A$12)+1,99),\".\",\" \"))))),\" имеются несоответствия\",\"\")","v":"1"}]
["ИП Иванов .И.В",1,"1 ",1,{"$f":"COUNTIF(A$3:A$12,A8)&IF((COUNTIF(A$3:A$12,A8)<>SUM(N(A$3:A$12&B$3:B$12=A8&B8)))+IF(CODE(MID(A8,2,1))<224,SUM((B8<>B$3:B$12)*ISNUMBER(SEARCH(SUBSTITUTE(MID(A8,SEARCH(\" \",A8)+1,99),\".\",\" \"),MID(A$3:A$12,1,SEARCH(\" \",A$3:A$12)+1)&MID(A$3:A$12,SEARCH(\" \",A$3:A$12,SEARCH(\" \",A$3:A$12)+1),2)))),SUM((B8<>B$3:B$12)*ISNUMBER(SEARCH(MID(A8,1,SEARCH(\" \",A8)+1)&MID(A8,SEARCH(\" \",A8,SEARCH(\" \",A8)+1),2),SUBSTITUTE(MID(A$3:A$12,SEARCH(\" \",A$3:A$12)+1,99),\".\",\" \"))))),\" имеются несоответствия\",\"\")","v":"1"}]
["ИП Чупачупс",2,"1 ",1,{"$f":"COUNTIF(A$3:A$12,A9)&IF((COUNTIF(A$3:A$12,A9)<>SUM(N(A$3:A$12&B$3:B$12=A9&B9)))+IF(CODE(MID(A9,2,1))<224,SUM((B9<>B$3:B$12)*ISNUMBER(SEARCH(SUBSTITUTE(MID(A9,SEARCH(\" \",A9)+1,99),\".\",\" \"),MID(A$3:A$12,1,SEARCH(\" \",A$3:A$12)+1)&MID(A$3:A$12,SEARCH(\" \",A$3:A$12,SEARCH(\" \",A$3:A$12)+1),2)))),SUM((B9<>B$3:B$12)*ISNUMBER(SEARCH(MID(A9,1,SEARCH(\" \",A9)+1)&MID(A9,SEARCH(\" \",A9,SEARCH(\" \",A9)+1),2),SUBSTITUTE(MID(A$3:A$12,SEARCH(\" \",A$3:A$12)+1,99),\".\",\" \"))))),\" имеются несоответствия\",\"\")","v":"1"}]
["ТОО Чугун",1,"2 имеются не соответсвия","2 имеются не соответсвия",{"$f":"COUNTIF(A$3:A$12,A10)&IF((COUNTIF(A$3:A$12,A10)<>SUM(N(A$3:A$12&B$3:B$12=A10&B10)))+IF(CODE(MID(A10,2,1))<224,SUM((B10<>B$3:B$12)*ISNUMBER(SEARCH(SUBSTITUTE(MID(A10,SEARCH(\" \",A10)+1,99),\".\",\" \"),MID(A$3:A$12,1,SEARCH(\" \",A$3:A$12)+1)&MID(A$3:A$12,SEARCH(\" \",A$3:A$12,SEARCH(\" \",A$3:A$12)+1),2)))),SUM((B10<>B$3:B$12)*ISNUMBER(SEARCH(MID(A10,1,SEARCH(\" \",A10)+1)&MID(A10,SEARCH(\" \",A10,SEARCH(\" \",A10)+1),2),SUBSTITUTE(MID(A$3:A$12,SEARCH(\" \",A$3:A$12)+1,99),\".\",\" \"))))),\" имеются несоответствия\",\"\")","v":"2 имеются несоответствия"}]
["ТОО Чугун",2,"2 имеются не соответсвия","2 имеются не соответсвия",{"$f":"COUNTIF(A$3:A$12,A11)&IF((COUNTIF(A$3:A$12,A11)<>SUM(N(A$3:A$12&B$3:B$12=A11&B11)))+IF(CODE(MID(A11,2,1))<224,SUM((B11<>B$3:B$12)*ISNUMBER(SEARCH(SUBSTITUTE(MID(A11,SEARCH(\" \",A11)+1,99),\".\",\" \"),MID(A$3:A$12,1,SEARCH(\" \",A$3:A$12)+1)&MID(A$3:A$12,SEARCH(\" \",A$3:A$12,SEARCH(\" \",A$3:A$12)+1),2)))),SUM((B11<>B$3:B$12)*ISNUMBER(SEARCH(MID(A11,1,SEARCH(\" \",A11)+1)&MID(A11,SEARCH(\" \",A11,SEARCH(\" \",A11)+1),2),SUBSTITUTE(MID(A$3:A$12,SEARCH(\" \",A$3:A$12)+1,99),\".\",\" \"))))),\" имеются несоответствия\",\"\")","v":"2 имеются несоответствия"}]
["ТОО Чумаков А.П",1,"2 ",2,{"$f":"COUNTIF(A$3:A$12,A12)&IF((COUNTIF(A$3:A$12,A12)<>SUM(N(A$3:A$12&B$3:B$12=A12&B12)))+IF(CODE(MID(A12,2,1))<224,SUM((B12<>B$3:B$12)*ISNUMBER(SEARCH(SUBSTITUTE(MID(A12,SEARCH(\" \",A12)+1,99),\".\",\" \"),MID(A$3:A$12,1,SEARCH(\" \",A$3:A$12)+1)&MID(A$3:A$12,SEARCH(\" \",A$3:A$12,SEARCH(\" \",A$3:A$12)+1),2)))),SUM((B12<>B$3:B$12)*ISNUMBER(SEARCH(MID(A12,1,SEARCH(\" \",A12)+1)&MID(A12,SEARCH(\" \",A12,SEARCH(\" \",A12)+1),2),SUBSTITUTE(MID(A$3:A$12,SEARCH(\" \",A$3:A$12)+1,99),\".\",\" \"))))),\" имеются несоответствия\",\"\")","v":"2"}]

{"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":[]}