{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ФА EBITDA Группы"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"ФА EBITDA Группы","index":0,"n_rows":41,"n_cols":26,"rows_kept":41,"cut":false,"hidden":false,"merged":[[19,4,20,4],[19,8,20,8],[13,4,14,4],[13,8,14,8],[15,4,16,4],[15,8,16,8],[17,4,18,4],[17,8,18,8],[7,4,8,4],[1,4,2,4],[3,4,4,4],[5,4,6,4],[7,8,8,8],[5,8,6,8],[3,8,4,8],[1,8,2,8],[1,2,2,2],[1,3,2,3],[3,2,4,2],[3,3,4,3],[5,2,6,2],[5,3,6,3],[7,2,8,2],[7,3,8,3],[13,2,14,2],[13,3,14,3],[15,2,16,2],[15,3,16,3],[17,2,18,2],[17,3,18,3],[19,2,20,2],[19,3,20,3],[9,2,10,2],[11,2,12,2],[9,3,10,3],[11,3,12,3],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,8,22,8],[23,2,24,2],[23,3,24,3],[23,4,24,4],[23,8,24,8],[25,2,26,2],[25,3,26,3],[25,4,26,4],[25,8,26,8],[27,2,28,2],[27,3,28,3],[27,4,28,4],[27,8,28,8],[29,2,30,2],[29,3,30,3],[31,2,32,2],[31,3,32,3],[33,2,34,2],[33,3,34,3],[33,4,34,4],[33,8,34,8],[35,2,36,2],[35,3,36,3],[35,4,36,4],[35,8,36,8],[37,2,38,2],[37,3,38,3],[37,4,38,4],[37,8,38,8],[39,2,40,2],[39,3,40,3],[39,4,40,4],[39,8,40,8]]}
[null,null,"Файл","Предприятие","Период","План/\nФакт","Проверка","Вычитаемое","Уменьшаемое","ВСЕГО","Ценовой фактор","Изменение цен реализации","Изменение цен на сырье","Изменение стоимости переменных затрат \n(кроме сырья)","Объемный фактор","Изменение объемов производства/ реализации","Изменение объемов потребления сырья","Изменение объема переменных затрат \n(кроме сырья)","Изменение структуры реализации","Влияние налогового законодательства","Оптимизац.\nмеры бизнесов","Измение условно-постоянных затрат","Изменение суммы создания резервов","Прочие доходы и расходы","Прочие доходы","Прочие расходы"]
["1 квартал 2021 прогноз","1 квартал 2021 факт","Предприятие 1.xlsm","Предприятие 1","1 квартал","2021пл/ф",null,null,null,{"$f":"SUM(K2,O2,T2:X2)","v":674},{"$f":"SUM(L2:N2)","v":105},{"$f":"RANDBETWEEN(10,100)","v":21},{"$f":"RANDBETWEEN(10,100)","v":38},46,{"$f":"SUM(P2:S2)","v":166},{"$f":"RANDBETWEEN(10,100)","v":62},52,13,39,98,42,69,93,{"$f":"SUM(Y2:Z2)","v":101},{"$f":"RANDBETWEEN(10,100)","v":71},30]
["1 квартал 2020 факт","1 квартал 2021 факт",null,null,null,"2020ф/2021ф",null,null,null,868,212,{"$f":"RANDBETWEEN(10,100)","v":62},94,56,207,11,77,71,48,98,79,90,73,109,46,63]
["1 полугодие 2021 прогноз","1 полугодие 2021 факт","Предприятие 1.xlsm","Предприятие 1","1 полугодие","2021пл/ф",null,null,null,709,87,12,38,37,263,65,75,50,73,95,72,82,37,73,22,51]
["1 полугодие 2020 факт","1 полугодие 2021 факт",null,null,null,"2020ф/2021ф",null,null,null,770,256,92,66,98,162,48,64,35,15,20,93,78,79,82,67,15]
["9 месяцев 2021 прогноз","9 месяцев 2021 факт","Предприятие 1.xlsm","Предприятие 1","9 месяцев","2021пл/ф",null,null,null,904,234,73,65,96,230,71,80,48,31,91,89,49,40,171,96,75]
["9 месяцев 2020 факт","9 месяцев 2021 факт",null,null,null,"2020ф/2021ф",null,null,null,856,243,86,91,66,257,98,83,10,66,35,13,86,70,152,73,79]
["2021 прогноз","2021 факт","Предприятие 1.xlsm","Предприятие 1","2021 год","2021пл/ф",null,null,null,711,151,40,64,47,195,95,59,23,18,33,70,82,45,135,82,53]
["2020 факт","2021 факт",null,null,null,"2020ф/2021ф",null,null,null,705,174,12,76,86,286,85,81,27,93,69,10,13,71,82,57,25]
["1 квартал 2021 факт","1 квартал 2022 прогноз","Предприятие 1.xlsm","Предприятие 1","1 квартал","2021ф/2022пл",null,null,null,554,190,38,98,54,101,36,13,16,36,15,16,17,92,123,93,30]
["1 полугодие 2021 факт","1 полугодие 2022 прогноз",null,null,"1 полугодие","2021ф/2022пл",null,null,null,863,167,76,13,78,316,81,75,79,81,96,69,90,64,61,43,18]
["9 месяцев 2021 факт","9 месяцев 2022 прогноз","Предприятие 1.xlsm","Предприятие 1","9 месяцев","2021ф/2022пл",null,null,null,724,164,35,76,53,237,35,16,92,94,42,68,60,36,117,53,64]
["2021 факт","2022 прогноз",null,null,"2022 год","2021ф/2022пл",null,null,null,926,239,75,98,66,182,27,76,53,26,93,81,99,80,152,73,79]
["1 квартал 2022 прогноз","1 квартал 2022 факт","Предприятие 1.xlsm","Предприятие 1","1 квартал","2022пл/ф",null,null,null,864,{"$f":"SUM(L14:N14)","v":152},46,84,22,{"$f":"SUM(P14:S14)","v":294},97,75,77,45,95,76,100,54,{"$f":"SUM(Y14:Z14)","v":93},30,63]
["1 квартал 2021 факт","1 квартал 2022 факт",null,null,null,"2021ф/2022ф",null,null,null,779,188,81,66,41,199,14,24,83,78,60,46,53,94,139,47,92]
["1 полугодие 2022 прогноз","1 полугодие 2022 факт","Предприятие 1.xlsm","Предприятие 1","1 полугодие","2022пл/ф",null,null,null,811,196,64,71,61,210,74,43,57,36,83,90,83,23,126,57,69]
["1 полугодие 2021 факт","1 полугодие 2022 факт",null,null,null,"2021ф/2022ф",null,null,null,813,159,30,86,43,304,82,88,81,53,78,25,89,33,125,85,40]
["9 месяцев 2022 прогноз","9 месяцев 2022 факт","Предприятие 1.xlsm","Предприятие 1","9 месяцев","2022пл/ф",null,null,null,830,136,91,14,31,218,{"$f":"RANDBETWEEN(10,100)","v":88},34,10,86,90,72,97,99,118,31,87]
["9 месяцев 2021 факт","9 месяцев 2022 факт",null,null,null,"2021ф/2022ф",null,null,null,640,99,22,15,62,213,88,74,30,21,52,29,10,69,168,90,78]
["2022 прогноз","2022 факт","Предприятие 1.xlsm","Предприятие 1","2022 год","2022пл/ф",null,null,null,774,126,22,42,62,274,97,83,50,44,74,67,44,61,128,63,65]
["2021 факт","2022 факт",null,null,null,"2021ф/2022ф",null,null,null,717,200,79,90,31,218,25,63,96,34,14,82,35,90,78,11,67]
["1 квартал 2021 прогноз","1 квартал 2021 факт","Предприятие 2.xlsm","Предприятие 2","1 квартал","2021пл/ф",null,null,null,{"$f":"SUM(K22,O22,T22:X22)","v":814},136,{"$f":"RANDBETWEEN(10,100)","v":74},38,24,295,86,60,51,98,71,95,68,70,79,53,26]
["1 квартал 2020 факт","1 квартал 2021 факт",null,null,null,"2020ф/2021ф",null,null,null,788,194,44,71,79,242,58,90,31,63,44,90,66,11,141,{"$f":"RANDBETWEEN(10,100)","v":63},78]
["1 полугодие 2021 прогноз","1 полугодие 2021 факт","Предприятие 2.xlsm","Предприятие 2","1 полугодие","2021пл/ф",null,null,null,696,147,{"$f":"RANDBETWEEN(10,100)","v":37},52,58,244,86,71,26,61,52,24,29,84,116,57,59]
["1 полугодие 2020 факт","1 полугодие 2021 факт",null,null,null,"2020ф/2021ф",null,null,null,631,62,27,10,25,230,80,64,65,21,50,32,56,51,150,99,51]
["9 месяцев 2021 прогноз","9 месяцев 2021 факт","Предприятие 2.xlsm","Предприятие 2","9 месяцев","2021пл/ф",null,null,null,773,213,68,70,75,244,76,87,65,16,71,11,98,44,92,55,37]
["9 месяцев 2020 факт","9 месяцев 2021 факт",null,null,null,"2020ф/2021ф",null,null,null,675,113,69,22,22,234,33,77,63,61,92,49,29,15,143,75,68]
["2021 прогноз","2021 факт","Предприятие 2.xlsm","Предприятие 2","2021 год","2021пл/ф",null,null,null,767,182,47,89,46,229,49,68,32,80,35,11,79,95,136,51,85]
["2020 факт","2021 факт",null,null,null,"2020ф/2021ф",null,null,null,728,184,90,81,13,269,100,44,55,70,90,43,18,43,81,50,31]
["1 квартал 2021 факт","1 квартал 2022 прогноз","Предприятие 2.xlsm","Предприятие 2","1 квартал","2021ф/2022пл",null,null,null,855,210,22,97,91,180,77,40,22,41,86,84,90,56,149,76,73]
["1 полугодие 2021 факт","1 полугодие 2022 прогноз",null,null,"1 полугодие","2021ф/2022пл",null,null,null,680,168,91,21,56,118,21,56,31,10,55,78,72,56,133,37,96]
["9 месяцев 2021 факт","9 месяцев 2022 прогноз","Предприятие 2.xlsm","Предприятие 2","9 месяцев","2021ф/2022пл",null,null,null,551,164,38,77,49,191,13,86,59,33,12,18,41,37,88,15,73]
["2021 факт","2022 прогноз",null,null,"2022 год","2021ф/2022пл",null,null,null,622,126,69,13,44,195,53,84,27,31,51,27,30,97,96,23,73]
["1 квартал 2022 прогноз","1 квартал 2022 факт","Предприятие 2.xlsm","Предприятие 2","1 квартал","2022пл/ф",null,null,null,776,{"$f":"SUM(L34:N34)","v":217},62,56,99,{"$f":"SUM(P34:S34)","v":141},{"$f":"RANDBETWEEN(10,100)","v":11},25,84,21,45,94,56,95,{"$f":"SUM(Y34:Z34)","v":128},89,39]
["1 квартал 2021 факт","1 квартал 2022 факт",null,null,null,"2021ф/2022ф",null,null,null,741,158,60,16,82,234,46,71,26,91,31,57,52,69,140,81,59]
["1 полугодие 2022 прогноз","1 полугодие 2022 факт","Предприятие 2.xlsm","Предприятие 2","1 полугодие","2022пл/ф",null,null,null,552,152,33,91,28,166,26,32,20,88,24,12,45,94,59,15,44]
["1 полугодие 2021 факт","1 полугодие 2022 факт",null,null,null,"2021ф/2022ф",null,null,null,965,157,25,90,42,317,74,91,54,98,98,87,65,71,170,84,86]
["9 месяцев 2022 прогноз","9 месяцев 2022 факт","Предприятие 2.xlsm","Предприятие 2","9 месяцев","2022пл/ф",null,null,null,646,132,54,15,63,235,74,72,40,49,48,55,49,10,117,85,32]
["9 месяцев 2021 факт","9 месяцев 2022 факт",null,null,null,"2021ф/2022ф",null,null,null,761,122,29,43,50,246,80,84,38,44,68,42,64,98,121,64,57]
["2022 прогноз","2022 факт","Предприятие 2.xlsm","Предприятие 2","2022 год","2022пл/ф",null,null,null,847,158,31,73,54,278,98,30,90,60,47,36,100,53,175,83,92]
["2021 факт","2022 факт",null,null,null,"2021ф/2022ф",null,null,null,833,206,84,39,83,208,29,77,68,34,85,36,39,89,170,70,100]