{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Лист1","Лист2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":69,"comments":0,"pivot_tables":1},"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":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Регион","Территория","Клиент","SKU","Бут","для акб ","АКБ по брендам","вход"]
["Волга","ПФО Север","ИП Иванов","Вода",10,{"$f":"E2/SUMIF(C:C,C2,E:E)","v":0.11428571428571428},{"$f":"E2/SUMIFS(E:E,C:C,C2,D:D,D2)","v":0.30769230769230771},{"$f":"1/IF(Лист2!$B$1=\"(Все)\",COUNTIFS($A$2:$A$25,A2,$B$2:$B$25,B2,$C$2:$C$25,C2),COUNTIFS($A$2:$A$25,A2,$B$2:$B$25,B2,$C$2:$C$25,C2,$D$2:$D$25,D2))","v":0.2}]
["Волга","ПФО Север","ИП Иванов","Пиво",20,{"$f":"E3/SUMIF(C:C,C3,E:E)","v":0.22857142857142856},{"$f":"E3/SUMIFS(E:E,C:C,C3,D:D,D3)","v":0.36363636363636365},{"$f":"1/IF(Лист2!$B$1=\"(Все)\",COUNTIFS($A$2:$A$25,A3,$B$2:$B$25,B3,$C$2:$C$25,C3),COUNTIFS($A$2:$A$25,A3,$B$2:$B$25,B3,$C$2:$C$25,C3,$D$2:$D$25,D3))","v":0.2}]
["Волга","ПФО Север","ИП Иванов","Пиво",15,0.17142857142857143,0.27272727272727271,{"$f":"1/IF(Лист2!$B$1=\"(Все)\",COUNTIFS($A$2:$A$25,A4,$B$2:$B$25,B4,$C$2:$C$25,C4),COUNTIFS($A$2:$A$25,A4,$B$2:$B$25,B4,$C$2:$C$25,C4,$D$2:$D$25,D4))","v":0.2}]
["Волга","ПФО Север","ИП Иванов","Пиво",20,0.22857142857142856,0.36363636363636365,{"$f":"1/IF(Лист2!$B$1=\"(Все)\",COUNTIFS($A$2:$A$25,A5,$B$2:$B$25,B5,$C$2:$C$25,C5),COUNTIFS($A$2:$A$25,A5,$B$2:$B$25,B5,$C$2:$C$25,C5,$D$2:$D$25,D5))","v":0.2}]
["Волга","ПФО Север","ИП Иванов","Вода",22.5,0.25714285714285712,0.69230769230769229,{"$f":"1/IF(Лист2!$B$1=\"(Все)\",COUNTIFS($A$2:$A$25,A6,$B$2:$B$25,B6,$C$2:$C$25,C6),COUNTIFS($A$2:$A$25,A6,$B$2:$B$25,B6,$C$2:$C$25,C6,$D$2:$D$25,D6))","v":0.2}]
["Волга","ПФО Север","ИП Петров","Вода",25,0.30303030303030304,0.30303030303030304,{"$f":"1/IF(Лист2!$B$1=\"(Все)\",COUNTIFS($A$2:$A$25,A7,$B$2:$B$25,B7,$C$2:$C$25,C7),COUNTIFS($A$2:$A$25,A7,$B$2:$B$25,B7,$C$2:$C$25,C7,$D$2:$D$25,D7))","v":0.33333333333333331}]
["Волга","ПФО Север","ИП Петров","Вода",27.5,0.33333333333333331,0.33333333333333331,{"$f":"1/IF(Лист2!$B$1=\"(Все)\",COUNTIFS($A$2:$A$25,A8,$B$2:$B$25,B8,$C$2:$C$25,C8),COUNTIFS($A$2:$A$25,A8,$B$2:$B$25,B8,$C$2:$C$25,C8,$D$2:$D$25,D8))","v":0.33333333333333331}]
["Волга","ПФО Север","ИП Петров","Вода",30,0.36363636363636365,0.36363636363636365,{"$f":"1/IF(Лист2!$B$1=\"(Все)\",COUNTIFS($A$2:$A$25,A9,$B$2:$B$25,B9,$C$2:$C$25,C9),COUNTIFS($A$2:$A$25,A9,$B$2:$B$25,B9,$C$2:$C$25,C9,$D$2:$D$25,D9))","v":0.33333333333333331}]
["Волга","ПФО Юг","Солнышко","Пиво",32.5,0.48148148148148145,0.48148148148148145,{"$f":"1/IF(Лист2!$B$1=\"(Все)\",COUNTIFS($A$2:$A$25,A10,$B$2:$B$25,B10,$C$2:$C$25,C10),COUNTIFS($A$2:$A$25,A10,$B$2:$B$25,B10,$C$2:$C$25,C10,$D$2:$D$25,D10))","v":0.5}]
["Волга","ПФО Юг","Солнышко","Пиво",35,0.51851851851851849,0.51851851851851849,{"$f":"1/IF(Лист2!$B$1=\"(Все)\",COUNTIFS($A$2:$A$25,A11,$B$2:$B$25,B11,$C$2:$C$25,C11),COUNTIFS($A$2:$A$25,A11,$B$2:$B$25,B11,$C$2:$C$25,C11,$D$2:$D$25,D11))","v":0.5}]
["Волга","ПФО Юг","Ювенко","Пиво",37.5,0.3125,0.3125,{"$f":"1/IF(Лист2!$B$1=\"(Все)\",COUNTIFS($A$2:$A$25,A12,$B$2:$B$25,B12,$C$2:$C$25,C12),COUNTIFS($A$2:$A$25,A12,$B$2:$B$25,B12,$C$2:$C$25,C12,$D$2:$D$25,D12))","v":0.33333333333333331}]
["Волга","ПФО Юг","Ювенко","Пиво",40,0.33333333333333331,0.33333333333333331,{"$f":"1/IF(Лист2!$B$1=\"(Все)\",COUNTIFS($A$2:$A$25,A13,$B$2:$B$25,B13,$C$2:$C$25,C13),COUNTIFS($A$2:$A$25,A13,$B$2:$B$25,B13,$C$2:$C$25,C13,$D$2:$D$25,D13))","v":0.33333333333333331}]
["Волга","ПФО Юг","Ювенко","Пиво",42.5,0.35416666666666669,0.35416666666666669,{"$f":"1/IF(Лист2!$B$1=\"(Все)\",COUNTIFS($A$2:$A$25,A14,$B$2:$B$25,B14,$C$2:$C$25,C14),COUNTIFS($A$2:$A$25,A14,$B$2:$B$25,B14,$C$2:$C$25,C14,$D$2:$D$25,D14))","v":0.33333333333333331}]
["Волга","ПФО Юг","Адель М","Пиво",45,0.23076923076923078,0.31578947368421051,{"$f":"1/IF(Лист2!$B$1=\"(Все)\",COUNTIFS($A$2:$A$25,A15,$B$2:$B$25,B15,$C$2:$C$25,C15),COUNTIFS($A$2:$A$25,A15,$B$2:$B$25,B15,$C$2:$C$25,C15,$D$2:$D$25,D15))","v":0.25}]
["Волга","ПФО Юг","Адель М","Пиво",47.5,0.24358974358974358,0.33333333333333331,{"$f":"1/IF(Лист2!$B$1=\"(Все)\",COUNTIFS($A$2:$A$25,A16,$B$2:$B$25,B16,$C$2:$C$25,C16),COUNTIFS($A$2:$A$25,A16,$B$2:$B$25,B16,$C$2:$C$25,C16,$D$2:$D$25,D16))","v":0.25}]
["Волга","ПФО Юг","Адель М","Пиво",50,0.25641025641025639,0.35087719298245612,{"$f":"1/IF(Лист2!$B$1=\"(Все)\",COUNTIFS($A$2:$A$25,A17,$B$2:$B$25,B17,$C$2:$C$25,C17),COUNTIFS($A$2:$A$25,A17,$B$2:$B$25,B17,$C$2:$C$25,C17,$D$2:$D$25,D17))","v":0.25}]
["Волга","ПФО Юг","Адель М","Вода",52.5,0.26923076923076922,1,{"$f":"1/IF(Лист2!$B$1=\"(Все)\",COUNTIFS($A$2:$A$25,A18,$B$2:$B$25,B18,$C$2:$C$25,C18),COUNTIFS($A$2:$A$25,A18,$B$2:$B$25,B18,$C$2:$C$25,C18,$D$2:$D$25,D18))","v":0.25}]
["Волга","ПФО Юг","Уги","Вода",55,1,1,{"$f":"1/IF(Лист2!$B$1=\"(Все)\",COUNTIFS($A$2:$A$25,A19,$B$2:$B$25,B19,$C$2:$C$25,C19),COUNTIFS($A$2:$A$25,A19,$B$2:$B$25,B19,$C$2:$C$25,C19,$D$2:$D$25,D19))","v":1}]
["Волга","Казань","Триумф","Вода",57.5,0.48936170212765956,1,{"$f":"1/IF(Лист2!$B$1=\"(Все)\",COUNTIFS($A$2:$A$25,A20,$B$2:$B$25,B20,$C$2:$C$25,C20),COUNTIFS($A$2:$A$25,A20,$B$2:$B$25,B20,$C$2:$C$25,C20,$D$2:$D$25,D20))","v":0.5}]
["Волга","Казань","Триумф","Пиво",60,0.51063829787234039,1,{"$f":"1/IF(Лист2!$B$1=\"(Все)\",COUNTIFS($A$2:$A$25,A21,$B$2:$B$25,B21,$C$2:$C$25,C21),COUNTIFS($A$2:$A$25,A21,$B$2:$B$25,B21,$C$2:$C$25,C21,$D$2:$D$25,D21))","v":0.5}]
["Волга","Казань","Масима","Пиво",62.5,0.23584905660377359,0.23584905660377359,{"$f":"1/IF(Лист2!$B$1=\"(Все)\",COUNTIFS($A$2:$A$25,A22,$B$2:$B$25,B22,$C$2:$C$25,C22),COUNTIFS($A$2:$A$25,A22,$B$2:$B$25,B22,$C$2:$C$25,C22,$D$2:$D$25,D22))","v":0.25}]
["Волга","Казань","Масима","Пиво",65,0.24528301886792453,0.24528301886792453,{"$f":"1/IF(Лист2!$B$1=\"(Все)\",COUNTIFS($A$2:$A$25,A23,$B$2:$B$25,B23,$C$2:$C$25,C23),COUNTIFS($A$2:$A$25,A23,$B$2:$B$25,B23,$C$2:$C$25,C23,$D$2:$D$25,D23))","v":0.25}]
["Волга","Казань","Масима","Пиво",67.5,0.25471698113207547,0.25471698113207547,{"$f":"1/IF(Лист2!$B$1=\"(Все)\",COUNTIFS($A$2:$A$25,A24,$B$2:$B$25,B24,$C$2:$C$25,C24),COUNTIFS($A$2:$A$25,A24,$B$2:$B$25,B24,$C$2:$C$25,C24,$D$2:$D$25,D24))","v":0.25}]
["Волга","Казань","Масима","Пиво",70,0.26415094339622641,0.26415094339622641,{"$f":"1/IF(Лист2!$B$1=\"(Все)\",COUNTIFS($A$2:$A$25,A25,$B$2:$B$25,B25,$C$2:$C$25,C25),COUNTIFS($A$2:$A$25,A25,$B$2:$B$25,B25,$C$2:$C$25,C25,$D$2:$D$25,D25))","v":0.25}]

{"sheet":"Лист2","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["SKU","(Все)",{"$f":"B1","v":"(Все)"}]
[null,"Продажи общие"]
["Сумма по полю вход"]
["Регион","Территория","Клиент","Итог"]
["Волга","Казань",null,2]
[null,"ПФО Север",null,1.9999999999999998]
[null,"ПФО Юг",null,4]
["Волга Итог",null,null,8]
["(пусто)"]
["Общий итог",null,null,8]