{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Статистика","Продукция","Формулы"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Статистика","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Статистика"]
[]
["Колличество:",{"$f":"B4+B5","v":8},"ММ"]
["Соответствуют",{"$f":"COUNTIF(Продукция!G2:G10, \"да\")","v":4},"шт."]
["Несоответствуют",{"$f":"COUNTIF(Продукция!G2:G10, \"нет\")","v":4},"шт."]
[]
["Всего:"]
["Соответствуют",{"$f":"(B4*100)/B3","v":50},"%"]
["Не соответствуют",{"$f":"(B5*100)/B3","v":50},"%"]

{"sheet":"Продукция","index":1,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Продукт","Населенный пункт","Адрес","Номер дома","Сорт","код","Соответствие стандарту","Дата:","проблемы транспортировки","Замечания по листу согласования"]
["Клубника","Новочеркасск","Баклановский ",165,"Максимум",2342312,"нет","2012-08-12","1. Мягкий 2. требуется холод","1. Черные точки 2. Короткий усик  4. острый запах"]
["Малина","Краснодар","Селезнева ",45,"Элеватор",536566,"да","2012-11-20",null,"1. Черные точки 2. Короткий усик "]
["Клубника","Краснодар","Котлярова",34,"Магнум",513467,"да","2013-02-28",null," 2. Короткий усик 3. желтый листик 4. острый запах"]
["Груша","Химки","Ленина",134,"Атлант",356735737,"да","2013-06-08",null,"1. Черные точки 2. Короткий усик "]
["Яблоко","Армавир","Фрунзе",654,"Эскалибур",67467634,"нет","2013-09-16","1. Мягкий 2. требуется холод","1. Черные точки 2. Короткий усик 3. желтый листик 4. острый запах"]
["Груша","Краснодар","Уральская",54,"Вавилон",6735779,"нет","2013-12-25","1. Мягкий 2. требуется холод 3. специальный ящик","1. Черные точки 2. Короткий усик "]
["Клубника","Армавир","Кирпичная",87,"Трость",7474645,"да","2014-04-04"]
["Малина","Тула","Большая",45,"Центр",74678353,"нет","2014-07-13","1. Мягкий 2. требуется холод 3. специальный ящик","1. Черные точки 2. Короткий усик "]

{"sheet":"Формулы","index":2,"n_rows":99,"n_cols":11,"rows_kept":99,"cut":false,"hidden":false,"merged":[]}
["Продукт:",null,"Колличество:",null,null,"С отклонениями:",null,null,null,"Несоответствия:"]
["Клубника",null,{"$f":"COUNTIF(Продукция!A2:A100,A2)","v":3},null,null,{"$f":"COUNTIFS(Продукция!A2:A100,A2,Продукция!J2:J100,\"<>\"&\"\")","v":2},null,null,null,"Желтый лист",{"$f":"SUMPRODUCT(--(Продукция!$A$2:$A$100=$A$2),--ISNUMBER(SEARCH(J2,Продукция!$J$2:$J$100)))","v":1}]
[null,null,null,null,null,null,null,null,null,"Черные точки",{"$f":"SUMPRODUCT(--(Продукция!$A$2:$A$100=$A$2),--ISNUMBER(SEARCH(J3,Продукция!$J$2:$J$100)))","v":1}]
[null,null,null,null,null,null,null,null,null,"Острый запах",{"$f":"SUMPRODUCT(--(Продукция!$A$2:$A$100=$A$2),--ISNUMBER(SEARCH(J4,Продукция!$J$2:$J$100)))","v":2}]
[null,null,null,null,null,null,null,null,null,"Короткий усик",{"$f":"SUMPRODUCT(--(Продукция!$A$2:$A$100=$A$2),--ISNUMBER(SEARCH(J5,Продукция!$J$2:$J$100)))","v":2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Список:"]
[{"$f":"Продукция!A2","v":"Клубника"}]
[{"$f":"Продукция!A3","v":"Малина"}]
[{"$f":"Продукция!A4","v":"Клубника"}]
[{"$f":"Продукция!A5","v":"Груша"}]
[{"$f":"Продукция!A6","v":"Яблоко"}]
[{"$f":"Продукция!A7","v":"Груша"}]
[{"$f":"Продукция!A8","v":"Клубника"}]
[{"$f":"Продукция!A9","v":"Малина"}]
[{"$f":"Продукция!A10","v":0}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Продукция!#REF!","v":{"$error":"#REF!"}}]