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