{"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":[[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],[33,4,34,4],[33,8,34,8],[35,2,36,2],[35,3,36,3],[35,4,36,4],[35,8,36,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],[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],[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],[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],[7,2,8,2],[7,3,8,3],[13,2,14,2],[13,3,14,3],[15,2,16,2],[15,3,16,3],[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,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],[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]]}
[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":570},{"$f":"SUM(L2:N2)","v":89},{"$f":"RANDBETWEEN(10,100)","v":39},{"$f":"RANDBETWEEN(10,100)","v":38},12,{"$f":"SUM(P2:S2)","v":229},{"$f":"RANDBETWEEN(10,100)","v":89},55,33,52,15,32,34,54,{"$f":"SUM(Y2:Z2)","v":117},{"$f":"RANDBETWEEN(10,100)","v":94},23]
["1 квартал 2020 факт","1 квартал 2021 факт",null,null,null,"2020ф/2021ф",null,null,null,771,210,{"$f":"RANDBETWEEN(10,100)","v":35},95,80,202,56,43,47,56,69,70,78,17,125,26,99]
["1 полугодие 2021 прогноз","1 полугодие 2021 факт","Предприятие 1.xlsm","Предприятие 1","1 полугодие","2021пл/ф",null,null,null,724,114,33,13,68,252,89,19,68,76,96,91,97,18,56,36,20]
["1 полугодие 2020 факт","1 полугодие 2021 факт",null,null,null,"2020ф/2021ф",null,null,null,670,161,87,64,10,202,66,28,84,24,43,61,38,56,109,49,60]
["9 месяцев 2021 прогноз","9 месяцев 2021 факт","Предприятие 1.xlsm","Предприятие 1","9 месяцев","2021пл/ф",null,null,null,848,234,96,67,71,274,96,59,59,60,72,67,12,95,94,17,77]
["9 месяцев 2020 факт","9 месяцев 2021 факт",null,null,null,"2020ф/2021ф",null,null,null,745,104,18,26,60,243,30,90,37,86,90,28,27,97,156,62,94]
["2021 прогноз","2021 факт","Предприятие 1.xlsm","Предприятие 1","2021 год","2021пл/ф",null,null,null,527,113,14,46,53,225,93,28,58,46,14,15,25,21,114,31,83]
["2020 факт","2021 факт",null,null,null,"2020ф/2021ф",null,null,null,652,149,13,82,54,155,47,23,10,75,84,59,44,59,102,48,54]
["1 квартал 2021 факт","1 квартал 2022 прогноз","Предприятие 1.xlsm","Предприятие 1","1 квартал","2021ф/2022пл",null,null,null,795,133,43,24,66,228,66,82,13,67,79,42,86,79,148,68,80]
["1 полугодие 2021 факт","1 полугодие 2022 прогноз",null,null,"1 полугодие","2021ф/2022пл",null,null,null,810,166,52,83,31,266,45,61,88,72,39,47,84,20,188,92,96]
["9 месяцев 2021 факт","9 месяцев 2022 прогноз","Предприятие 1.xlsm","Предприятие 1","9 месяцев","2021ф/2022пл",null,null,null,766,88,13,27,48,214,42,87,40,45,70,76,86,61,171,89,82]
["2021 факт","2022 прогноз",null,null,"2022 год","2021ф/2022пл",null,null,null,760,143,58,66,19,288,70,68,52,98,17,98,15,34,165,76,89]
["1 квартал 2022 прогноз","1 квартал 2022 факт","Предприятие 1.xlsm","Предприятие 1","1 квартал","2022пл/ф",null,null,null,815,{"$f":"SUM(L14:N14)","v":172},21,65,86,{"$f":"SUM(P14:S14)","v":242},51,85,92,14,91,91,83,18,{"$f":"SUM(Y14:Z14)","v":118},29,89]
["1 квартал 2021 факт","1 квартал 2022 факт",null,null,null,"2021ф/2022ф",null,null,null,716,184,81,91,12,158,16,20,30,92,59,72,70,57,116,58,58]
["1 полугодие 2022 прогноз","1 полугодие 2022 факт","Предприятие 1.xlsm","Предприятие 1","1 полугодие","2022пл/ф",null,null,null,644,150,36,52,62,270,76,56,61,77,13,64,77,30,40,15,25]
["1 полугодие 2021 факт","1 полугодие 2022 факт",null,null,null,"2021ф/2022ф",null,null,null,885,179,86,16,77,293,96,89,36,72,25,89,70,63,166,94,72]
["9 месяцев 2022 прогноз","9 месяцев 2022 факт","Предприятие 1.xlsm","Предприятие 1","9 месяцев","2022пл/ф",null,null,null,743,194,33,84,77,210,{"$f":"RANDBETWEEN(10,100)","v":96},25,52,37,44,75,82,46,92,19,73]
["9 месяцев 2021 факт","9 месяцев 2022 факт",null,null,null,"2021ф/2022ф",null,null,null,774,203,58,91,54,262,100,92,34,36,81,27,49,70,82,10,72]
["2022 прогноз","2022 факт","Предприятие 1.xlsm","Предприятие 1","2022 год","2022пл/ф",null,null,null,627,143,22,72,49,177,58,56,33,30,32,28,86,52,109,76,33]
["2021 факт","2022 факт",null,null,null,"2021ф/2022ф",null,null,null,850,223,65,64,94,325,66,93,72,94,41,15,61,57,128,53,75]
["1 квартал 2021 прогноз","1 квартал 2021 факт","Предприятие 2.xlsm","Предприятие 2","1 квартал","2021пл/ф",null,null,null,{"$f":"SUM(K22,O22,T22:X22)","v":763},230,{"$f":"RANDBETWEEN(10,100)","v":73},79,78,277,72,99,19,87,10,37,96,45,68,26,42]
["1 квартал 2020 факт","1 квартал 2021 факт",null,null,null,"2020ф/2021ф",null,null,null,584,151,54,54,43,166,28,24,75,39,63,70,40,33,61,{"$f":"RANDBETWEEN(10,100)","v":23},38]
["1 полугодие 2021 прогноз","1 полугодие 2021 факт","Предприятие 2.xlsm","Предприятие 2","1 полугодие","2021пл/ф",null,null,null,817,127,{"$f":"RANDBETWEEN(10,100)","v":50},53,24,270,54,62,79,75,85,44,71,93,127,29,98]
["1 полугодие 2020 факт","1 полугодие 2021 факт",null,null,null,"2020ф/2021ф",null,null,null,593,182,76,48,58,151,47,68,25,11,21,37,28,54,120,89,31]
["9 месяцев 2021 прогноз","9 месяцев 2021 факт","Предприятие 2.xlsm","Предприятие 2","9 месяцев","2021пл/ф",null,null,null,648,166,51,48,67,200,65,41,63,31,53,29,98,15,87,10,77]
["9 месяцев 2020 факт","9 месяцев 2021 факт",null,null,null,"2020ф/2021ф",null,null,null,722,231,40,99,92,179,86,19,62,12,85,58,41,78,50,11,39]
["2021 прогноз","2021 факт","Предприятие 2.xlsm","Предприятие 2","2021 год","2021пл/ф",null,null,null,584,92,51,13,28,181,12,50,70,49,45,65,27,42,132,56,76]
["2020 факт","2021 факт",null,null,null,"2020ф/2021ф",null,null,null,603,162,96,44,22,72,12,13,24,23,66,62,100,18,123,39,84]
["1 квартал 2021 факт","1 квартал 2022 прогноз","Предприятие 2.xlsm","Предприятие 2","1 квартал","2021ф/2022пл",null,null,null,650,151,56,68,27,145,44,38,49,14,37,91,83,74,69,32,37]
["1 полугодие 2021 факт","1 полугодие 2022 прогноз",null,null,"1 полугодие","2021ф/2022пл",null,null,null,803,184,52,66,66,206,80,48,27,51,75,27,86,90,135,58,77]
["9 месяцев 2021 факт","9 месяцев 2022 прогноз","Предприятие 2.xlsm","Предприятие 2","9 месяцев","2021ф/2022пл",null,null,null,797,198,88,95,15,271,76,30,70,95,19,64,78,54,113,78,35]
["2021 факт","2022 прогноз",null,null,"2022 год","2021ф/2022пл",null,null,null,822,241,83,64,94,132,12,26,21,73,89,41,78,98,143,99,44]
["1 квартал 2022 прогноз","1 квартал 2022 факт","Предприятие 2.xlsm","Предприятие 2","1 квартал","2022пл/ф",null,null,null,772,{"$f":"SUM(L34:N34)","v":186},85,70,31,{"$f":"SUM(P34:S34)","v":244},{"$f":"RANDBETWEEN(10,100)","v":79},61,77,27,71,65,51,36,{"$f":"SUM(Y34:Z34)","v":119},42,77]
["1 квартал 2021 факт","1 квартал 2022 факт",null,null,null,"2021ф/2022ф",null,null,null,579,193,43,50,100,139,28,42,32,37,56,60,18,22,91,66,25]
["1 полугодие 2022 прогноз","1 полугодие 2022 факт","Предприятие 2.xlsm","Предприятие 2","1 полугодие","2022пл/ф",null,null,null,621,164,51,74,39,202,15,73,85,29,12,46,27,39,131,72,59]
["1 полугодие 2021 факт","1 полугодие 2022 факт",null,null,null,"2021ф/2022ф",null,null,null,631,145,21,60,64,132,66,45,11,10,91,47,56,32,128,91,37]
["9 месяцев 2022 прогноз","9 месяцев 2022 факт","Предприятие 2.xlsm","Предприятие 2","9 месяцев","2022пл/ф",null,null,null,640,142,26,82,34,219,44,47,50,78,10,49,20,52,148,68,80]
["9 месяцев 2021 факт","9 месяцев 2022 факт",null,null,null,"2021ф/2022ф",null,null,null,805,207,19,99,89,282,69,89,76,48,51,21,51,65,128,72,56]
["2022 прогноз","2022 факт","Предприятие 2.xlsm","Предприятие 2","2022 год","2022пл/ф",null,null,null,613,199,77,43,79,130,53,13,18,46,39,26,53,30,136,53,83]
["2021 факт","2022 факт",null,null,null,"2021ф/2022ф",null,null,null,799,232,83,89,60,305,53,93,69,90,34,54,48,57,69,44,25]

{"sheet":"8814304","index":1,"n_rows":41,"n_cols":23,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Период","План/\nФакт","Проверка","Вычитаемое","Уменьшаемое","ВСЕГО","Ценовой фактор","Изменение цен реализации","Изменение цен на сырье","Изменение стоимости переменных затрат \n(кроме сырья)","Объемный фактор","Изменение объемов производства/ реализации","Изменение объемов потребления сырья","Изменение объема переменных затрат \n(кроме сырья)","Изменение структуры реализации","Влияние налогового законодательства","Оптимизац.\nмеры бизнесов","Измение условно-постоянных затрат","Изменение суммы создания резервов","Прочие доходы и расходы","Прочие доходы","Прочие расходы","Предприятие"]
["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,"Предприятие 1"]
["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,"Предприятие 2"]

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