{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ФА EBITDA Группы","8814304","Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":655},{"$f":"SUM(L2:N2)","v":191},{"$f":"RANDBETWEEN(10,100)","v":96},{"$f":"RANDBETWEEN(10,100)","v":10},85,{"$f":"SUM(P2:S2)","v":233},{"$f":"RANDBETWEEN(10,100)","v":86},40,51,56,16,51,89,22,{"$f":"SUM(Y2:Z2)","v":53},{"$f":"RANDBETWEEN(10,100)","v":43},10]
["1 квартал 2020 факт","1 квартал 2021 факт",null,null,null,"2020ф/2021ф",null,null,null,807,268,{"$f":"RANDBETWEEN(10,100)","v":82},86,100,257,92,19,49,97,34,21,62,80,85,17,68]
["1 полугодие 2021 прогноз","1 полугодие 2021 факт","Предприятие 1.xlsm","Предприятие 1","1 полугодие","2021пл/ф",null,null,null,937,206,96,19,91,282,22,96,77,87,58,57,79,91,164,100,64]
["1 полугодие 2020 факт","1 полугодие 2021 факт",null,null,null,"2020ф/2021ф",null,null,null,673,144,14,41,89,215,29,31,58,97,56,32,77,52,97,42,55]
["9 месяцев 2021 прогноз","9 месяцев 2021 факт","Предприятие 1.xlsm","Предприятие 1","9 месяцев","2021пл/ф",null,null,null,702,154,35,95,24,252,12,92,69,79,44,37,56,54,105,16,89]
["9 месяцев 2020 факт","9 месяцев 2021 факт",null,null,null,"2020ф/2021ф",null,null,null,949,258,83,79,96,329,96,59,100,74,87,100,28,42,105,62,43]
["2021 прогноз","2021 факт","Предприятие 1.xlsm","Предприятие 1","2021 год","2021пл/ф",null,null,null,610,103,19,68,16,318,86,79,90,63,10,22,11,70,76,42,34]
["2020 факт","2021 факт",null,null,null,"2020ф/2021ф",null,null,null,552,119,33,35,51,183,73,10,38,62,35,34,37,84,60,33,27]
["1 квартал 2021 факт","1 квартал 2022 прогноз","Предприятие 1.xlsm","Предприятие 1","1 квартал","2021ф/2022пл",null,null,null,666,192,10,93,89,157,54,75,12,16,48,14,76,50,129,89,40]
["1 полугодие 2021 факт","1 полугодие 2022 прогноз",null,null,"1 полугодие","2021ф/2022пл",null,null,null,779,184,28,58,98,225,87,38,85,15,46,93,65,90,76,64,12]
["9 месяцев 2021 факт","9 месяцев 2022 прогноз","Предприятие 1.xlsm","Предприятие 1","9 месяцев","2021ф/2022пл",null,null,null,653,153,64,10,79,255,65,64,34,92,100,46,34,19,46,25,21]
["2021 факт","2022 прогноз",null,null,"2022 год","2021ф/2022пл",null,null,null,697,85,12,52,21,274,73,41,62,98,45,93,27,51,122,76,46]
["1 квартал 2022 прогноз","1 квартал 2022 факт","Предприятие 1.xlsm","Предприятие 1","1 квартал","2022пл/ф",null,null,null,731,{"$f":"SUM(L14:N14)","v":131},60,12,59,{"$f":"SUM(P14:S14)","v":314},91,91,44,88,46,35,65,11,{"$f":"SUM(Y14:Z14)","v":129},97,32]
["1 квартал 2021 факт","1 квартал 2022 факт",null,null,null,"2021ф/2022ф",null,null,null,885,258,99,98,61,211,42,51,39,79,60,56,53,94,153,66,87]
["1 полугодие 2022 прогноз","1 полугодие 2022 факт","Предприятие 1.xlsm","Предприятие 1","1 полугодие","2022пл/ф",null,null,null,778,209,56,61,92,212,32,94,42,44,57,97,89,18,96,31,65]
["1 полугодие 2021 факт","1 полугодие 2022 факт",null,null,null,"2021ф/2022ф",null,null,null,760,228,43,99,86,206,16,65,78,47,82,48,49,10,137,50,87]
["9 месяцев 2022 прогноз","9 месяцев 2022 факт","Предприятие 1.xlsm","Предприятие 1","9 месяцев","2022пл/ф",null,null,null,695,120,20,55,45,171,{"$f":"RANDBETWEEN(10,100)","v":49},14,40,68,98,79,78,89,60,48,12]
["9 месяцев 2021 факт","9 месяцев 2022 факт",null,null,null,"2021ф/2022ф",null,null,null,772,167,36,65,66,266,57,75,77,57,87,44,66,62,80,69,11]
["2022 прогноз","2022 факт","Предприятие 1.xlsm","Предприятие 1","2022 год","2022пл/ф",null,null,null,559,213,81,53,79,191,44,56,68,23,46,17,16,20,56,22,34]
["2021 факт","2022 факт",null,null,null,"2021ф/2022ф",null,null,null,821,126,42,36,48,312,76,86,61,89,16,40,90,72,165,77,88]
["1 квартал 2021 прогноз","1 квартал 2021 факт","Предприятие 2.xlsm","Предприятие 2","1 квартал","2021пл/ф",null,null,null,{"$f":"SUM(K22,O22,T22:X22)","v":740},201,{"$f":"RANDBETWEEN(10,100)","v":61},86,54,190,80,25,72,13,70,90,44,92,53,12,41]
["1 квартал 2020 факт","1 квартал 2021 факт",null,null,null,"2020ф/2021ф",null,null,null,632,193,21,88,84,216,59,28,45,84,37,55,14,32,85,{"$f":"RANDBETWEEN(10,100)","v":13},72]
["1 полугодие 2021 прогноз","1 полугодие 2021 факт","Предприятие 2.xlsm","Предприятие 2","1 полугодие","2021пл/ф",null,null,null,893,247,{"$f":"RANDBETWEEN(10,100)","v":79},73,95,258,68,62,59,69,44,51,75,86,132,62,70]
["1 полугодие 2020 факт","1 полугодие 2021 факт",null,null,null,"2020ф/2021ф",null,null,null,507,138,71,12,55,128,12,73,28,15,49,23,26,49,94,41,53]
["9 месяцев 2021 прогноз","9 месяцев 2021 факт","Предприятие 2.xlsm","Предприятие 2","9 месяцев","2021пл/ф",null,null,null,630,137,72,21,44,267,85,57,69,56,30,37,14,62,83,35,48]
["9 месяцев 2020 факт","9 месяцев 2021 факт",null,null,null,"2020ф/2021ф",null,null,null,681,151,16,53,82,322,90,97,48,87,24,37,32,31,84,30,54]
["2021 прогноз","2021 факт","Предприятие 2.xlsm","Предприятие 2","2021 год","2021пл/ф",null,null,null,623,81,26,11,44,213,41,23,51,98,95,61,56,43,74,10,64]
["2020 факт","2021 факт",null,null,null,"2020ф/2021ф",null,null,null,743,140,26,41,73,311,80,92,90,49,32,54,63,24,119,35,84]
["1 квартал 2021 факт","1 квартал 2022 прогноз","Предприятие 2.xlsm","Предприятие 2","1 квартал","2021ф/2022пл",null,null,null,575,128,19,85,24,205,14,50,70,71,33,25,60,86,38,17,21]
["1 полугодие 2021 факт","1 полугодие 2022 прогноз",null,null,"1 полугодие","2021ф/2022пл",null,null,null,651,163,82,69,12,250,87,15,51,97,20,31,43,56,88,43,45]
["9 месяцев 2021 факт","9 месяцев 2022 прогноз","Предприятие 2.xlsm","Предприятие 2","9 месяцев","2021ф/2022пл",null,null,null,753,238,98,95,45,111,19,18,47,27,22,96,98,45,143,88,55]
["2021 факт","2022 прогноз",null,null,"2022 год","2021ф/2022пл",null,null,null,801,233,88,94,51,276,54,63,87,72,63,15,19,30,165,75,90]
["1 квартал 2022 прогноз","1 квартал 2022 факт","Предприятие 2.xlsm","Предприятие 2","1 квартал","2022пл/ф",null,null,null,729,{"$f":"SUM(L34:N34)","v":157},45,41,71,{"$f":"SUM(P34:S34)","v":268},{"$f":"RANDBETWEEN(10,100)","v":66},11,100,91,93,12,16,92,{"$f":"SUM(Y34:Z34)","v":91},30,61]
["1 квартал 2021 факт","1 квартал 2022 факт",null,null,null,"2021ф/2022ф",null,null,null,539,107,27,56,24,150,27,89,11,23,13,60,27,88,94,45,49]
["1 полугодие 2022 прогноз","1 полугодие 2022 факт","Предприятие 2.xlsm","Предприятие 2","1 полугодие","2022пл/ф",null,null,null,657,169,17,68,84,263,94,79,36,54,30,59,25,68,43,29,14]
["1 полугодие 2021 факт","1 полугодие 2022 факт",null,null,null,"2021ф/2022ф",null,null,null,921,212,71,77,64,265,12,87,96,70,67,31,95,75,176,81,95]
["9 месяцев 2022 прогноз","9 месяцев 2022 факт","Предприятие 2.xlsm","Предприятие 2","9 месяцев","2022пл/ф",null,null,null,680,190,48,77,65,190,52,49,26,63,69,83,49,11,88,78,10]
["9 месяцев 2021 факт","9 месяцев 2022 факт",null,null,null,"2021ф/2022ф",null,null,null,827,201,58,88,55,260,95,64,16,85,63,45,85,27,146,51,95]
["2022 прогноз","2022 факт","Предприятие 2.xlsm","Предприятие 2","2022 год","2022пл/ф",null,null,null,773,154,23,68,63,281,81,53,73,74,28,40,43,66,161,62,99]
["2021 факт","2022 факт",null,null,null,"2021ф/2022ф",null,null,null,818,222,38,97,87,242,69,84,19,70,68,28,61,69,128,69,59]

{"sheet":"8814304","index":1,"n_rows":41,"n_cols":23,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Предприятие","Период","План/\nФакт","Проверка","Вычитаемое","Уменьшаемое","ВСЕГО","Ценовой фактор","Изменение цен реализации","Изменение цен на сырье","Изменение стоимости переменных затрат \n(кроме сырья)","Объемный фактор","Изменение объемов производства/ реализации","Изменение объемов потребления сырья","Изменение объема переменных затрат \n(кроме сырья)","Изменение структуры реализации","Влияние налогового законодательства","Оптимизац.\nмеры бизнесов","Измение условно-постоянных затрат","Изменение суммы создания резервов","Прочие доходы и расходы","Прочие доходы","Прочие расходы"]
["Предприятие 1","1 квартал","2021пл/ф",null,null,null,692,132,58,31,43,318,86,73,95,64,36,37,52,20,97,58,39]
["Предприятие 1",null,"2020ф/2021ф",null,null,null,737,192,70,97,25,137,89,11,26,11,58,97,76,19,158,99,59]
["Предприятие 1","1 полугодие","2021пл/ф",null,null,null,771,142,69,52,21,263,15,91,97,60,77,35,75,77,102,29,73]
["Предприятие 1",null,"2020ф/2021ф",null,null,null,787,153,39,82,32,186,46,37,39,64,77,76,95,94,106,75,31]
["Предприятие 1","9 месяцев","2021пл/ф",null,null,null,703,131,39,36,56,222,81,44,46,51,69,48,71,84,78,64,14]
["Предприятие 1",null,"2020ф/2021ф",null,null,null,644,137,87,12,38,96,15,58,13,10,39,89,38,77,168,96,72]
["Предприятие 1","2021 год","2021пл/ф",null,null,null,538,88,42,32,14,191,65,78,31,17,15,27,64,80,73,18,55]
["Предприятие 1",null,"2020ф/2021ф",null,null,null,762,126,12,86,28,220,44,75,44,57,80,24,98,31,183,87,96]
["Предприятие 1","1 квартал","2021ф/2022пл",null,null,null,542,125,24,48,53,215,84,74,16,41,19,13,76,20,74,36,38]
["Предприятие 1","1 полугодие","2021ф/2022пл",null,null,null,674,175,41,34,100,253,93,68,57,35,100,39,18,26,63,26,37]
["Предприятие 1","9 месяцев","2021ф/2022пл",null,null,null,772,134,50,38,46,269,78,96,29,66,38,30,74,96,131,39,92]
["Предприятие 1","2022 год","2021ф/2022пл",null,null,null,687,151,33,54,64,183,53,66,34,30,95,84,53,39,82,11,71]
["Предприятие 1","1 квартал","2022пл/ф",null,null,null,783,203,92,31,80,243,83,57,71,32,77,31,85,45,99,11,88]
["Предприятие 1",null,"2021ф/2022ф",null,null,null,666,74,41,18,15,219,55,75,33,56,79,42,92,29,131,97,34]
["Предприятие 1","1 полугодие","2022пл/ф",null,null,null,806,177,45,42,90,260,94,97,47,22,38,29,95,99,108,91,17]
["Предприятие 1",null,"2021ф/2022ф",null,null,null,727,167,47,72,48,264,93,77,12,82,69,29,20,74,104,31,73]
["Предприятие 1","9 месяцев","2022пл/ф",null,null,null,572,164,72,31,61,105,51,26,18,10,77,64,18,98,46,27,19]
["Предприятие 1",null,"2021ф/2022ф",null,null,null,775,103,14,27,62,248,13,53,86,96,57,53,99,71,144,80,64]
["Предприятие 1","2022 год","2022пл/ф",null,null,null,688,154,35,94,25,259,26,56,98,79,30,59,55,51,80,58,22]
["Предприятие 1",null,"2021ф/2022ф",null,null,null,946,178,78,75,25,269,44,70,72,83,95,73,84,72,175,94,81]
["Предприятие 2","1 квартал","2021пл/ф",null,null,null,630,141,80,12,49,170,35,89,11,35,96,21,92,16,94,43,51]
["Предприятие 2",null,"2020ф/2021ф",null,null,null,593,45,10,16,19,186,52,72,46,16,35,82,56,91,98,58,40]
["Предприятие 2","1 полугодие","2021пл/ф",null,null,null,898,214,86,57,71,272,81,93,12,86,35,93,49,50,185,85,100]
["Предприятие 2",null,"2020ф/2021ф",null,null,null,798,141,20,35,86,276,100,66,36,74,74,64,48,35,160,78,82]
["Предприятие 2","9 месяцев","2021пл/ф",null,null,null,811,173,36,65,72,239,88,67,18,66,42,56,55,97,149,56,93]
["Предприятие 2",null,"2020ф/2021ф",null,null,null,695,217,53,82,82,170,42,74,19,35,56,77,20,61,94,75,19]
["Предприятие 2","2021 год","2021пл/ф",null,null,null,866,242,81,62,99,229,34,99,69,27,87,56,76,94,82,42,40]
["Предприятие 2",null,"2020ф/2021ф",null,null,null,786,157,65,48,44,323,48,92,90,93,69,11,11,86,129,49,80]
["Предприятие 2","1 квартал","2021ф/2022пл",null,null,null,638,179,84,79,16,147,13,16,66,52,51,88,74,18,81,57,24]
["Предприятие 2","1 полугодие","2021ф/2022пл",null,null,null,744,179,87,39,53,228,53,20,63,92,57,65,52,90,73,47,26]
["Предприятие 2","9 месяцев","2021ф/2022пл",null,null,null,551,172,44,90,38,122,40,43,22,17,55,12,56,68,66,55,11]
["Предприятие 2","2022 год","2021ф/2022пл",null,null,null,825,213,80,99,34,317,90,68,78,81,41,37,91,44,82,64,18]
["Предприятие 2","1 квартал","2022пл/ф",null,null,null,736,138,99,24,15,244,61,69,65,49,98,74,25,76,81,52,29]
["Предприятие 2",null,"2021ф/2022ф",null,null,null,698,204,92,27,85,149,19,78,40,12,36,94,59,51,105,35,70]
["Предприятие 2","1 полугодие","2022пл/ф",null,null,null,836,141,26,26,89,276,90,48,69,69,12,98,100,82,127,60,67]
["Предприятие 2",null,"2021ф/2022ф",null,null,null,625,156,41,18,97,116,21,53,23,19,59,77,31,60,126,51,75]
["Предприятие 2","9 месяцев","2022пл/ф",null,null,null,766,163,48,69,46,189,48,43,75,23,65,81,50,65,153,70,83]
["Предприятие 2",null,"2021ф/2022ф",null,null,null,684,178,48,76,54,261,52,77,62,70,10,19,66,90,60,19,41]
["Предприятие 2","2022 год","2022пл/ф",null,null,null,669,130,40,45,45,241,57,60,44,80,28,91,64,23,92,57,35]
["Предприятие 2",null,"2021ф/2022ф",null,null,null,677,238,61,84,93,135,32,14,76,13,68,59,32,74,71,14,57]

{"sheet":"Лист1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}