{"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":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
["Наименование","Показатель","Как должно быть"]
["ИП \"Кукла В.А\"",2,"2 имеются не соответсвия",{"$f":"COUNTIF(A$3:A$6,A3)&IF((COUNTIF(A$3:A$6,A3)<>SUM(N(A$3:A$6&B$3:B$6=A3&B3)))+IF(CODE(MID(A3,2,1))<224,SUM((B3<>B$3:B$6)*ISNUMBER(SEARCH(SUBSTITUTE(MID(A3,SEARCH(\" \",A3)+1,99),\".\",\" \"),MID(A$3:A$6,1,SEARCH(\" \",A$3:A$6)+1)&MID(A$3:A$6,SEARCH(\" \",A$3:A$6,SEARCH(\" \",A$3:A$6)+1),2)))),SUM((B3<>B$3:B$6)*ISNUMBER(SEARCH(MID(A3,1,SEARCH(\" \",A3)+1)&MID(A3,SEARCH(\" \",A3,SEARCH(\" \",A3)+1),2),SUBSTITUTE(MID(A$3:A$6,SEARCH(\" \",A$3:A$6)+1,99),\".\",\" \"))))),\" имеются несоответствия\",\"\")","v":"1"}]
["Кукла Валя Анатольевна",1,"2 имеются не соответсвия",{"$f":"COUNTIF(A$3:A$6,A4)&IF((COUNTIF(A$3:A$6,A4)<>SUM(N(A$3:A$6&B$3:B$6=A4&B4)))+IF(CODE(MID(A4,2,1))<224,SUM((B4<>B$3:B$6)*ISNUMBER(SEARCH(SUBSTITUTE(MID(A4,SEARCH(\" \",A4)+1,99),\".\",\" \"),MID(A$3:A$6,1,SEARCH(\" \",A$3:A$6)+1)&MID(A$3:A$6,SEARCH(\" \",A$3:A$6,SEARCH(\" \",A$3:A$6)+1),2)))),SUM((B4<>B$3:B$6)*ISNUMBER(SEARCH(MID(A4,1,SEARCH(\" \",A4)+1)&MID(A4,SEARCH(\" \",A4,SEARCH(\" \",A4)+1),2),SUBSTITUTE(MID(A$3:A$6,SEARCH(\" \",A$3:A$6)+1,99),\".\",\" \"))))),\" имеются несоответствия\",\"\")","v":"1 имеются несоответствия"}]
["ИП Петров В.А",2,2,{"$f":"COUNTIF(A$3:A$6,A5)&IF((COUNTIF(A$3:A$6,A5)<>SUM(N(A$3:A$6&B$3:B$6=A5&B5)))+IF(CODE(MID(A5,2,1))<224,SUM((B5<>B$3:B$6)*ISNUMBER(SEARCH(SUBSTITUTE(MID(A5,SEARCH(\" \",A5)+1,99),\".\",\" \"),MID(A$3:A$6,1,SEARCH(\" \",A$3:A$6)+1)&MID(A$3:A$6,SEARCH(\" \",A$3:A$6,SEARCH(\" \",A$3:A$6)+1),2)))),SUM((B5<>B$3:B$6)*ISNUMBER(SEARCH(MID(A5,1,SEARCH(\" \",A5)+1)&MID(A5,SEARCH(\" \",A5,SEARCH(\" \",A5)+1),2),SUBSTITUTE(MID(A$3:A$6,SEARCH(\" \",A$3:A$6)+1,99),\".\",\" \"))))),\" имеются несоответствия\",\"\")","v":"1"}]
["Петров Вова Александрович",2,2,{"$f":"COUNTIF(A$3:A$6,A6)&IF((COUNTIF(A$3:A$6,A6)<>SUM(N(A$3:A$6&B$3:B$6=A6&B6)))+IF(CODE(MID(A6,2,1))<224,SUM((B6<>B$3:B$6)*ISNUMBER(SEARCH(SUBSTITUTE(MID(A6,SEARCH(\" \",A6)+1,99),\".\",\" \"),MID(A$3:A$6,1,SEARCH(\" \",A$3:A$6)+1)&MID(A$3:A$6,SEARCH(\" \",A$3:A$6,SEARCH(\" \",A$3:A$6)+1),2)))),SUM((B6<>B$3:B$6)*ISNUMBER(SEARCH(MID(A6,1,SEARCH(\" \",A6)+1)&MID(A6,SEARCH(\" \",A6,SEARCH(\" \",A6)+1),2),SUBSTITUTE(MID(A$3:A$6,SEARCH(\" \",A$3:A$6)+1,99),\".\",\" \"))))),\" имеются несоответствия\",\"\")","v":"1"}]

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