{"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":"2020-04-01"},{"$f":"EOMONTH(TODAY(),-25)","v":"2020-04-30"}]
["Текущий месяц позапрошлого года",{"$f":"EOMONTH(TODAY(),-25)+1","v":"2020-05-01"},{"$f":"EOMONTH(TODAY(),-24)","v":"2020-05-31"}]
["Следующий месяц позапрошлого года",{"$f":"EOMONTH(TODAY(),-24)+1","v":"2020-06-01"},{"$f":"EOMONTH(TODAY(),-23)","v":"2020-06-30"}]
["Прошлый месяц прошлого года",{"$f":"EOMONTH(TODAY(),-14)+1","v":"2021-04-01"},{"$f":"EOMONTH(TODAY(),-13)","v":"2021-04-30"}]
["Текущий месяц прошлого года",{"$f":"EOMONTH(TODAY(),-13)+1","v":"2021-05-01"},{"$f":"EOMONTH(TODAY(),-12)","v":"2021-05-31"}]
["Следующий месяц прошлого года",{"$f":"EOMONTH(TODAY(),-12)+1","v":"2021-06-01"},{"$f":"EOMONTH(TODAY(),-11)","v":"2021-06-30"}]
["Прошлый месяц",{"$f":"EOMONTH(TODAY(),-2)+1","v":"2022-04-01"},{"$f":"EOMONTH(TODAY(),-1)","v":"2022-04-30"}]
["Текущий месяц",{"$f":"EOMONTH(TODAY(),-1)+1","v":"2022-05-01"},{"$f":"EOMONTH(TODAY(),0)","v":"2022-05-31"}]
["Следующий месяц",{"$f":"EOMONTH(TODAY(),0)+1","v":"2022-06-01"},{"$f":"EOMONTH(TODAY(),1)","v":"2022-06-30"}]

{"sheet":"Summary","index":2,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["KPI.calc_type","SUM"]
["outlets.status","enabled"]
["outlets.PartnerTopManagerRole","All"]
["outlets.PartnerDivisionManagerRole","All"]
["outlets.PartnerHeadRole","All"]
["outlets.PartnerZoneManagerRole","All"]
["outlets.PartnerManagerRole","All"]
[]
[null,null,"Год","Месяц","Дата","Значения"]
[null,null,2022]
[null,null,"Январь"]
[null,null,"2022-01-26"]
["store.name","KPI.name","Факт","План","Факт/План","Прогноз","Факт/Прогноз"]
["sample store","Тест",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":2,"n_cols":11,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["store.extId","storeId","store.name","store.address","PartnerTopManagerRole","PartnerDivisionManagerRole","PartnerHeadRole","PartnerZoneManagerRole","PartnerManagerRole","last_snapshot_ts","status"]
["sample_ext_id","1364168","sample store","sample address","sample top manager","sample division manager","sample head manager","sample zone manager","sample manager","2022-01-26T18:24:20.113","enabled"]

{"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","2022-01-26","257587486648",158,150,160,1,"Январь",2022,"24.01.22 - 30.01.22"]

{"sheet":"periods","index":6,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Начало","Окончание"]
["2019-12-01","2019-12-31"]
["2020-01-01","2020-01-31"]
["2020-02-01","2020-02-29"]
["2020-12-01","2020-12-31"]
["2021-01-01","2021-01-31"]
["2021-02-01","2021-02-28"]
["2021-12-01","2021-12-31"]
["2022-01-01","2022-01-31"]
["2022-02-01","2022-02-28"]