{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Model","SCENARIOS","Lists"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Model","index":0,"n_rows":47,"n_cols":54,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54]
[]
[null,null,null,null,null,null,null,"показатель",null,null,null,null,"ед.изм.",null,null,"значение",null,null,null,null,"итого",null,null,"2021-12-01","2022-01-01","2022-02-01","2022-03-01","2022-04-01","2022-05-01","2022-06-01","2022-07-01","2022-08-01","2022-09-01","2022-10-01","2022-11-01","2022-12-01","2023-01-01","2023-02-01","2023-03-01","2023-04-01","2023-05-01","2023-06-01","2023-07-01","2023-08-01","2023-09-01","2023-10-01","2023-11-01","","","","","","",""]
[]
[null,6,null,null,"РУС",null,null,"минимальный период расчетов","минимальный период расчетов",null,null,null,"тип периода",null,"*","месяц","^",null,null,null,"2021-12-01",null,null,"2021-12-01","2022-01-01","2022-02-01","2022-03-01","2022-04-01","2022-05-01","2022-06-01","2022-07-01","2022-08-01","2022-09-01","2022-10-01","2022-11-01","2022-12-01","2023-01-01","2023-02-01","2023-03-01","2023-04-01","2023-05-01","2023-06-01","2023-07-01","2023-08-01","2023-09-01","2023-10-01","2023-11-01","","","","","","",""]
[null,7,null,null,null,null,null,"старт моделирования","старт моделирования",null,null,null,"месяц",null,"*","2021-12-01","^",null,null,null,"2023-11-30",null,null,"2021-12-31","2022-01-31","2022-02-28","2022-03-31","2022-04-30","2022-05-31","2022-06-30","2022-07-31","2022-08-31","2022-09-30","2022-10-31","2022-11-30","2022-12-31","2023-01-31","2023-02-28","2023-03-31","2023-04-30","2023-05-31","2023-06-30","2023-07-31","2023-08-31","2023-09-30","2023-10-31","2023-11-30","","","","","","",""]
[null,8,null,null,null,null,null,"горизонт моделирования","горизонт моделирования",null,null,null,"кол-во пер.",null,"*",24,null,null,null,null,24,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,"","","","","","",""]
[null,9]
[null,10,null,null,null,null,null,null,null,null,null,null,null,null,"название сохраняемого сценария:"]
[null,11,null,null,null,null,null,"доход",null,null,null,null,"руб.",null,null,null,null,null,null,null,16200000,null,null,100000,150000,200000,250000,300000,350000,400000,450000,500000,550000,600000,650000,700000,750000,800000,850000,900000,950000,1000000,1050000,1100000,1150000,1200000,1250000,0,0,0,0,0,0,0]
[null,12,null,null,null,null,null,"доход","размер дохода в начальный период",null,null,null,"руб.",null,"*",100000]
[null,13,null,null,null,null,null,"доход","прирост дохода период-к-периоду",null,null,null,"руб.",null,"*",50000]
[null,14]
[null,15,null,null,null,null,null,"себестоимость",null,null,null,null,null,null,null,null,null,null,null,null,10530000,null,null,65000,97500,130000,162500,195000,227500,260000,292500,325000,357500,390000,422500,455000,487500,520000,552500,585000,617500,650000,682500,715000,747500,780000,812500,0,0,0,0,0,0,0]
[null,16,null,null,null,null,null,"себестоимость","рентабельность продаж",null,null,null,"%",null,"*",0.35]
[null,17]
[null,18,null,null,null,null,null,"чистый доход",null,null,null,null,"руб.",null,null,null,null,null,null,null,5670000,null,null,35000,52500,70000,87500,105000,122500,140000,157500,175000,192500,210000,227500,245000,262500,280000,297500,315000,332500,350000,367500,385000,402500,420000,437500,0,0,0,0,0,0,0]
[null,19]
[null,20,null,null,null,null,null,"переменные расходы",null,null,null,null,null,null,null,null,null,null,null,null,1620000,null,null,10000,15000,20000,25000,30000,35000,40000,45000,50000,55000,60000,65000,70000,75000,80000,85000,90000,95000,100000,105000,110000,115000,120000,125000,0,0,0,0,0,0,0]
[null,21,null,null,null,null,null,"переменные расходы","% от дохода",null,null,null,"%",null,"*",0.1]
[null,22]
[null,23,null,null,null,null,null,"маржинальная прибыль",null,null,null,null,"руб.",null,null,null,null,null,null,null,4050000,null,null,25000,37500,50000,62500,75000,87500,100000,112500,125000,137500,150000,162500,175000,187500,200000,212500,225000,237500,250000,262500,275000,287500,300000,312500,0,0,0,0,0,0,0]
[null,24]
[null,25,null,null,null,null,null,"постоянные расходы",null,null,null,null,"руб.",null,null,null,null,null,null,null,2400000,null,null,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,0,0,0,0,0,0,0]
[null,26,null,null,null,null,null,"постоянные расходы","размер расхода в месяц",null,null,null,"руб.",null,"*",100000]
[null,27]
[null,28,null,null,null,null,null,"EBITDA",null,null,null,null,"руб.",null,null,null,null,null,null,null,1650000,null,null,-75000,-62500,-50000,-37500,-25000,-12500,0,12500,25000,37500,50000,62500,75000,87500,100000,112500,125000,137500,150000,162500,175000,187500,200000,212500,0,0,0,0,0,0,0]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]

{"sheet":"SCENARIOS","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"№","параметр (вводные данные)",null,"сценарии:","текущий сценарий"]
[null,1,"размер дохода в начальный период",null,null,100000]
[null,2,"прирост дохода период-к-периоду",null,null,50000]
[null,3,"рентабельность продаж",null,null,0.35]
[null,4,"% от дохода",null,null,0.1]
[null,5,"размер расхода в месяц",null,null,100000]
[]
[null,null,"результаты"]
[null,null,"доход",null,null,16200000]
[null,null,"EBITDA",null,null,1650000]

{"sheet":"Lists","index":2,"n_rows":47,"n_cols":29,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,9,null,null,null,null,14,null,null,null,null,19,null,null,null,23,null,null,null,27]
[null,null,null,null,null,null,null,null,"I",null,null,null,null,"N",null,null,null,null,"S",null,null,null,"W",null,null,null,"AA"]
[]
[null,null,null,null,null,null,null,null,"минимальный период расчетов",null,null,null,null,"старт моделирования",null,null,null,null,"названия",null,null,null,"названия на русском",null,null,null,"названия на английском"]
[5,null,null,null,null,null,null,null,"Lists!I6:I9",null,null,null,null,"Lists!N6:N29",null,null,null,null,"Lists!S6:S27",null,null,null,"Lists!W6:W27",null,null,null,"Lists!AA6:AA27"]
[6,null,null,null,null,null,null,"*","месяц",1,0,null,"*","2022-03-01",1,0,null,null,"показатель",1,0,"*","показатель",1,0,"*","indicator",1,0]
[7,null,null,null,null,null,null,"*","квартал",2,0,null,null,"2022-04-01",2,0,null,null,"ед.изм.",2,0,"*","ед.изм.",2,0,"*","unit change",2,0]
[8,null,null,null,null,null,null,"*","год текущий",3,0,null,null,"2022-05-01",3,0,null,null,"значение",3,0,"*","значение",3,0,"*","value",3,0]
[9,null,null,null,null,null,null,"*","год календарный",4,0,null,null,"2022-06-01",4,0,null,null,"итого",4,0,"*","итого",4,0,"*","total",4,0]
[10,null,null,null,null,null,null,null,null,null,null,null,null,"2022-07-01",5,0,null,null,"доход",5,0,"*","доход",5,0,"*","income",5,0]
[11,null,null,null,null,null,null,null,null,null,null,null,null,"2022-08-01",6,0,null,null,"размер дохода в начальный период",6,0,"*","размер дохода в начальный период",6,0,"*","amount of income in the initial period income",6,0]
[12,null,null,null,null,null,null,null,null,null,null,null,null,"2022-09-01",7,0,null,null,"прирост дохода период-к-периоду",7,0,"*","прирост дохода период-к-периоду",7,0,"*","growth period-to-period",7,0]
[13,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-01",8,0,null,null,"себестоимость",8,0,"*","себестоимость",8,0,"*","cost of sales",8,0]
[14,null,null,null,null,null,null,null,null,null,null,null,null,"2022-11-01",9,0,null,null,"рентабельность продаж",9,0,"*","рентабельность продаж",9,0,"*","return on sales",9,0]
[15,null,null,null,null,null,null,null,null,null,null,null,null,"2022-12-01",10,0,null,null,"чистый доход",10,0,"*","чистый доход",10,0,"*","net income",10,0]
[16,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-01",11,0,null,null,"% от дохода",11,0,"*","% от дохода",11,0,"*","% of income",11,0]
[17,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-01",12,0,null,null,"переменные расходы",12,0,"*","переменные расходы",12,0,"*","variable expenses",12,0]
[18,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-01",13,0,null,null,"размер расхода в месяц",13,0,"*","размер расхода в месяц",13,0,"*","monthly expense amount",13,0]
[19,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-01",14,0,null,null,"маржинальная прибыль",14,0,"*","маржинальная прибыль",14,0,"*","marginal profit",14,0]
[20,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-01",15,0,null,null,"тип периода",15,0,"*","тип периода",15,0,"*"," period type",15,0]
[21,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-01",16,0,null,null,"постоянные расходы",16,0,"*","постоянные расходы",16,0,"*","fixed expenses",16,0]
[22,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-01",17,0,null,null,"месяц",17,0,"*","месяц",17,0,"*","month",17,0]
[23,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-01",18,0,null,null,"EBITDA",18,0,"*","EBITDA",18,0,"*","EBITDA",18,0]
[24,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-01",19,0,null,null,"кол-во пер.",19,0,"*","кол-во пер.",19,0,"*","number of gears.",19,0]
[25,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-01",20,0,null,null,"руб.",20,0,"*","руб.",20,0,"*","RUR",20,0]
[26,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-01",21,0,null,null,"минимальный период расчетов",21,0,"*","минимальный период расчетов",21,0,"*","minimum calculation period",21,0]
[27,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-01",22,0,null,null,"старт моделирования",22,0,"*","старт моделирования",22,0,"*","start of simulation",22,0]
[28,null,null,null,null,null,null,null,null,null,null,null,null,"2024-01-01",23,0]
[29,null,null,null,null,null,null,null,null,null,null,null,null,"2024-02-01",24,0]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]