{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Лист2","Лист1"],"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":"Лист2","index":0,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["SKU","(Все)"]
[null,"Продажи общие"]
["  бут"]
["Регион","Территория","Клиент","Итог"]
["Волга","Казань","Масима",265,1]
[null,null,"Триумф",117.5,1]
[null,"Казань Итог",null,382.5,2]
[null,"ПФО Север","ИП Иванов",87.5,1]
[null,null,"ИП Петров",82.5,1]
[null,"ПФО Север Итог",null,170,2]
[null,"ПФО Юг","Адель М",195,1]
[null,null,"Солнышко",67.5,1]
[null,null,"Уги",55,1]
[null,null,"Ювенко",120,1]
[null,"ПФО Юг Итог",null,437.5,4]
["Волга Итог",null,null,990,8]
["Общий итог",null,null,990]

{"sheet":"Лист1","index":1,"n_rows":25,"n_cols":7,"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}]
["Волга","ПФО Север","ИП Иванов","Пиво",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}]
["Волга","ПФО Север","ИП Иванов","Пиво",15,0.17142857142857143,0.27272727272727271]
["Волга","ПФО Север","ИП Иванов","Пиво",20,0.22857142857142856,0.36363636363636365]
["Волга","ПФО Север","ИП Иванов","Вода",22.5,0.25714285714285712,0.69230769230769229]
["Волга","ПФО Север","ИП Петров","Вода",25,0.30303030303030304,0.30303030303030304]
["Волга","ПФО Север","ИП Петров","Вода",27.5,0.33333333333333331,0.33333333333333331]
["Волга","ПФО Север","ИП Петров","Вода",30,0.36363636363636365,0.36363636363636365]
["Волга","ПФО Юг","Солнышко","Пиво",32.5,0.48148148148148145,0.48148148148148145]
["Волга","ПФО Юг","Солнышко","Пиво",35,0.51851851851851849,0.51851851851851849]
["Волга","ПФО Юг","Ювенко","Пиво",37.5,0.3125,0.3125]
["Волга","ПФО Юг","Ювенко","Пиво",40,0.33333333333333331,0.33333333333333331]
["Волга","ПФО Юг","Ювенко","Пиво",42.5,0.35416666666666669,0.35416666666666669]
["Волга","ПФО Юг","Адель М","Пиво",45,0.23076923076923078,0.31578947368421051]
["Волга","ПФО Юг","Адель М","Пиво",47.5,0.24358974358974358,0.33333333333333331]
["Волга","ПФО Юг","Адель М","Пиво",50,0.25641025641025639,0.35087719298245612]
["Волга","ПФО Юг","Адель М","Вода",52.5,0.26923076923076922,1]
["Волга","ПФО Юг","Уги","Вода",55,1,1]
["Волга","Казань","Триумф","Вода",57.5,0.48936170212765956,1]
["Волга","Казань","Триумф","Пиво",60,0.51063829787234039,1]
["Волга","Казань","Масима","Пиво",62.5,0.23584905660377359,0.23584905660377359]
["Волга","Казань","Масима","Пиво",65,0.24528301886792453,0.24528301886792453]
["Волга","Казань","Масима","Пиво",67.5,0.25471698113207547,0.25471698113207547]
["Волга","Казань","Масима","Пиво",70,0.26415094339622641,0.26415094339622641]