{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["ApiKey","Date","Summary","kpi_list","outlets","sales_plans","periods"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"ApiKey","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Ключ доступа к API с типом \"Административный терминал\""]

{"sheet":"Date","index":1,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Период","Начало","Окончание"]
["Прошлый месяц позапрошлого года",{"$f":"EOMONTH(TODAY(),-26)+1","v":"2023-01-01"},{"$f":"EOMONTH(TODAY(),-25)","v":"2023-01-31"}]
["Текущий месяц позапрошлого года",{"$f":"EOMONTH(TODAY(),-25)+1","v":"2023-02-01"},{"$f":"EOMONTH(TODAY(),-24)","v":"2023-02-28"}]
["Следующий месяц позапрошлого года",{"$f":"EOMONTH(TODAY(),-24)+1","v":"2023-03-01"},{"$f":"EOMONTH(TODAY(),-23)","v":"2023-03-31"}]
["Прошлый месяц прошлого года",{"$f":"EOMONTH(TODAY(),-14)+1","v":"2024-01-01"},{"$f":"EOMONTH(TODAY(),-13)","v":"2024-01-31"}]
["Текущий месяц прошлого года",{"$f":"EOMONTH(TODAY(),-13)+1","v":"2024-02-01"},{"$f":"EOMONTH(TODAY(),-12)","v":"2024-02-29"}]
["Следующий месяц прошлого года",{"$f":"EOMONTH(TODAY(),-12)+1","v":"2024-03-01"},{"$f":"EOMONTH(TODAY(),-11)","v":"2024-03-31"}]
["Прошлый месяц",{"$f":"EOMONTH(TODAY(),-2)+1","v":"2025-01-01"},{"$f":"EOMONTH(TODAY(),-1)","v":"2025-01-31"}]
["Текущий месяц",{"$f":"EOMONTH(TODAY(),-1)+1","v":"2025-02-01"},{"$f":"EOMONTH(TODAY(),0)","v":"2025-02-28"}]
["Следующий месяц",{"$f":"EOMONTH(TODAY(),0)+1","v":"2025-03-01"},{"$f":"EOMONTH(TODAY(),1)","v":"2025-03-31"}]

{"sheet":"Summary","index":2,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["KPI.calc_type","SUM"]
["outlets.status","All"]
["outlets.PartnerTopManagerRole","All"]
["outlets.PartnerDivisionManagerRole","All"]
["outlets.PartnerHeadRole","All"]
["outlets.PartnerZoneManagerRole","All"]
["outlets.PartnerManagerRole","All"]
[]
[null,null,"Год","Месяц","Дата","Значения"]
[null,null,2024]
[null,null,"Ноябрь"]
[null,null,"2024-11-20"]
["store.name","KPI.name","Факт","План","Факт/План","Прогноз","Факт/Прогноз"]
["(пусто)","Тест",158,150,1.0533333333333332,160,0.98750000000000004]
["Общий итог",null,158,150,1.0533333333333332,160,0.98750000000000004]

{"sheet":"kpi_list","index":3,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["calc_type","kpi_id","name"]
["SUM","257587486648","Тест"]

{"sheet":"outlets","index":4,"n_rows":1,"n_cols":11,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["store.extId","storeId","store.name","store.address","PartnerTopManagerRole","PartnerDivisionManagerRole","PartnerHeadRole","PartnerZoneManagerRole","PartnerManagerRole","last_snapshot_ts","status"]

{"sheet":"sales_plans","index":5,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["storeId","Date","kpi_id","fact","plan","forecast","Индекс месяца","Месяц","Год","Неделя"]
["1364168","2024-11-20","257587486648",158,150,160,11,"Ноябрь",2024,"18.11.24 - 24.11.24"]

{"sheet":"periods","index":6,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Начало","Окончание"]
["2022-10-01","2022-10-31"]
["2022-11-01","2022-11-30"]
["2022-12-01","2022-12-31"]
["2023-10-01","2023-10-31"]
["2023-11-01","2023-11-30"]
["2023-12-01","2023-12-31"]
["2024-10-01","2024-10-31"]
["2024-11-01","2024-11-30"]
["2024-12-01","2024-12-31"]