{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Investment","BaU","Subsidy"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Investment","index":0,"n_rows":98,"n_cols":43,"rows_kept":98,"cut":false,"hidden":false,"merged":[[0,0,2,0],[5,1,5,7],[3,0,4,0]]}
["FINANČNÍ ANALÝZA PROJEKTU / FINANCIAL ANALYSIS OF THE PROJECT\npro projekty předkládané do programu ENERG ETS financovaného z Modernizačního fondu\nfor projects submitted to the ENERG ETS programme granted by the Modernisation Fund","Legenda/Explanatory notes:",null,"vstupní údaje: vyplní žadatel / input data: to be filled in by the applicant\t"]
[null,null,null,"žadatel zkontroluje / to be checked by the applicant"]
[null,null,null,"automatický výpočet / automatic calculation\t\t"]
["Investment scenario",null,null,"nevyplňovat - začerňuje se automaticky / not to be filled in - automatically blacked out\t\t"]
[]
["NÁZEV PROJEKTU/NAME OF THE PROJECT:"]
["OBECNÉ PŘEDPOKLADY/GENERAL ASSUMPTIONS"]
["Rok zahájení pro vyhodnocení projektu [rok]/Start year for project evaluation (year)"]
["Doba vyhodnocení projektu [rok]/Project evaluation period (year)",15]
["Rok zahájení provozu/Year of start of operation"]
["Rok ukončení hodnocení projektu  [rok]/Year of completion of project evaluation (year)",{"$f":"$B$10+$B$9-1","v":14}]
["Časová osa/Timeline",null,null,null,{"$f":"$B$8","v":0},{"$f":"E12+1","v":1},{"$f":"F12+1","v":2},{"$f":"G12+1","v":3},{"$f":"H12+1","v":4},{"$f":"I12+1","v":5},{"$f":"J12+1","v":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,32,33,34,35,36,37,38]
["Byl zahájen provoz (1=ano/0=ne)/Operation started (1=yes/0=no)",null,null,null,{"$f":"IF(E12<$B$10,0,1)","v":1},{"$f":"IF(F12<$B$10,0,1)","v":1},1,{"$f":"IF(H12<$B$10,0,1)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["Rok provozu (v průběhu hodnocení) [rok]/Year of operation (during evaluation) (year)",null,null,null,{"$f":"IF(SUM($E$13:E13)>$B$9,0,SUM($E$13:E13))","v":1},{"$f":"IF(SUM($E$13:F13)>$B$9,0,SUM($E$13:F13))","v":2},{"$f":"IF(SUM($E$13:G13)>$B$9,0,SUM($E$13:G13))","v":3},{"$f":"IF(SUM($E$13:H13)>$B$9,0,SUM($E$13:H13))","v":4},{"$f":"IF(SUM($E$13:I13)>$B$9,0,SUM($E$13:I13))","v":5},{"$f":"IF(SUM($E$13:J13)>$B$9,0,SUM($E$13:J13))","v":6},{"$f":"IF(SUM($E$13:K13)>$B$9,0,SUM($E$13:K13))","v":7},{"$f":"IF(SUM($E$13:L13)>$B$9,0,SUM($E$13:L13))","v":8},{"$f":"IF(SUM($E$13:M13)>$B$9,0,SUM($E$13:M13))","v":9},{"$f":"IF(SUM($E$13:N13)>$B$9,0,SUM($E$13:N13))","v":10},{"$f":"IF(SUM($E$13:O13)>$B$9,0,SUM($E$13:O13))","v":11},{"$f":"IF(SUM($E$13:P13)>$B$9,0,SUM($E$13:P13))","v":12},{"$f":"IF(SUM($E$13:Q13)>$B$9,0,SUM($E$13:Q13))","v":13},{"$f":"IF(SUM($E$13:R13)>$B$9,0,SUM($E$13:R13))","v":14},{"$f":"IF(SUM($E$13:S13)>$B$9,0,SUM($E$13:S13))","v":15},{"$f":"IF(SUM($E$13:T13)>$B$9,0,SUM($E$13:T13))","v":0},{"$f":"IF(SUM($E$13:U13)>$B$9,0,SUM($E$13:U13))","v":0},{"$f":"IF(SUM($E$13:V13)>$B$9,0,SUM($E$13:V13))","v":0},{"$f":"IF(SUM($E$13:W13)>$B$9,0,SUM($E$13:W13))","v":0},{"$f":"IF(SUM($E$13:X13)>$B$9,0,SUM($E$13:X13))","v":0},{"$f":"IF(SUM($E$13:Y13)>$B$9,0,SUM($E$13:Y13))","v":0},{"$f":"IF(SUM($E$13:Z13)>$B$9,0,SUM($E$13:Z13))","v":0},{"$f":"IF(SUM($E$13:AA13)>$B$9,0,SUM($E$13:AA13))","v":0},{"$f":"IF(SUM($E$13:AB13)>$B$9,0,SUM($E$13:AB13))","v":0},{"$f":"IF(SUM($E$13:AC13)>$B$9,0,SUM($E$13:AC13))","v":0},{"$f":"IF(SUM($E$13:AD13)>$B$9,0,SUM($E$13:AD13))","v":0},{"$f":"IF(SUM($E$13:AE13)>$B$9,0,SUM($E$13:AE13))","v":0},{"$f":"IF(SUM($E$13:AF13)>$B$9,0,SUM($E$13:AF13))","v":0},{"$f":"IF(SUM($E$13:AG13)>$B$9,0,SUM($E$13:AG13))","v":0},{"$f":"IF(SUM($E$13:AH13)>$B$9,0,SUM($E$13:AH13))","v":0},{"$f":"IF(SUM($E$13:AI13)>$B$9,0,SUM($E$13:AI13))","v":0},{"$f":"IF(SUM($E$13:AJ13)>$B$9,0,SUM($E$13:AJ13))","v":0},{"$f":"IF(SUM($E$13:AK13)>$B$9,0,SUM($E$13:AK13))","v":0},{"$f":"IF(SUM($E$13:AL13)>$B$9,0,SUM($E$13:AL13))","v":0},{"$f":"IF(SUM($E$13:AM13)>$B$9,0,SUM($E$13:AM13))","v":0},{"$f":"IF(SUM($E$13:AN13)>$B$9,0,SUM($E$13:AN13))","v":0},{"$f":"IF(SUM($E$13:AO13)>$B$9,0,SUM($E$13:AO13))","v":0},{"$f":"IF(SUM($E$13:AP13)>$B$9,0,SUM($E$13:AP13))","v":0},{"$f":"IF(SUM($E$13:AQ13)>$B$9,0,SUM($E$13:AQ13))","v":0}]
["Inflace v letech provozu [%]/Inflation in years of operation (%)",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Směnný kurz [CZK/€]/Exchange rate (CZK/€)",24.521000000000001,null,null,null,null,null,null,"Velký podnik/Large enterprises",null,1]
["Požadovaná návratnost žadatele, WACC [%]/Applicant's required return, WACC (%)",null,null,null,null,null,null,null,"Střední podnik/Midle enterprises"]
["Velikost podniku žadatele/Type of recipient",null,null,null,null,null,null,null,"Malý podnik/Small enterprises"]
["Relativní snížení emisí CO2 (%)/Relative CO2 reduction (%)",null,{"$f":"IF(AND(B19>=0.4,B19<0.55),0.4,IF(B19>=0.55,0.55,0))","v":0}]
["Relativní energetická úspora (%)/Relative energy savings (%)",null,{"$f":"IF(AND(B20>=0.2,B20<0.25),0.4,IF(B20>=0.25,0.55,0))","v":0}]
["Zvolte článek podpory dle DKTF / Select the TCTF aid article",null,{"$f":"IF(G21=3,0.3,0)","v":0},null,null,"Decarbonization 81 d) (i)",2]
["Provozní úspora (CZK)/OPEX savings (CZK)",{"$f":"SUM(BaU!E36:AQ36)+SUM(BaU!E40:AQ40)+SUM(BaU!E56:AQ56)-SUM(Investment!E54:AQ54)-SUM(Investment!E58:AQ58)-SUM(Investment!E74:AQ74)","v":0},null,null,null,"Energy savings 81 d (ii)"]
["Diskontovaná rovozní úspora (CZK)/Discounted OPEX savings (CZK)",{"$f":"BaU!B37+BaU!B41+BaU!B57-Investment!B55-Investment!B59-Investment!B75","v":0}]
["Dodatečné příjmy podporované investice oproti současnému stavu (CZK)/Additional sales compared to BaU (CZK)",{"$f":"SUM(E90:AQ90)+SUM(E97:AQ97)","v":0},null,null,null,null,null,null,"NE",2]
["Diskontované dodatečné příjmy podporované investice oproti současnému stavu (CZK)/Discounted additional sales compared to BaU (CZK)",{"$f":"B91+B98","v":0},null,null,null,null,null,null,"ANO"]
[null,{"$f":"IF(B23>=B25,\"odečítáme provozní úsporu / OPEX savings are deducted\",\"odečítáme dodatečné tržby / Aditional sales are deducted\")","v":"odečítáme provozní úsporu / OPEX savings are deducted"}]
[]
["INVESTIČNÍ VÝDAJE/CAPITAL EXPENDITURE"]
["Celkové výdaje projektu [CZK]/Total expenditures of the project (CZK)"]
["Způsobilé přímé realizační výdaje (CZK)/Eligible implementation expenditures (CZK)"]
["Způsobilé výdaje na povinnou publicitu (CZK)/Eligible expenditures for mandatory publicity (CZK)"]
["TDI, BOZP (CZK)/Investor's technical supervision (CZK)"]
[null,{"$f":"IF(B32<=0.03*B30,\"výdaje na TDI jsou v pořádku / sum is OK\",\"TDI nad 3% realizace\")","v":"výdaje na TDI jsou v pořádku / sum is OK"}]
["Celkové způsobilé investiční výdaje projektu [CZK]/Total eligible investment expenditures of the project (CZK)",{"$f":"B30+B31+B32","v":0}]
[]
["PROVOZNÍ NÁKLADY/OPERATING COSTS"]
["Energetické vstupy do výroby/Energy inputs to production:","Specifikujte typ palivového nákl./Specify fuel type costs:","Emisní faktor/emission factor:"]
["Náklad paliva 1 v letech [CZK] (+)/Fuel Cost 1 in years (MWh/year)"]
["Spotřeba paliva 1 v letech [MWh/rok výhřevnosti]/Fuel consumption 1 in years (MWh/year calorific value)"]
["Průměrné jednotkové náklady paliva 1 v letech [CZK/MWh]/Average unit cost of fuel 1 in years (CZK/MWh)",null,null,null,{"$f":"IFERROR(E38/E39,\"\")","v":""},{"$f":"IFERROR(F38/F39,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Náklad paliva 2 v letech [CZK] (+)/Fuel costs 2 in years (CZK) (+)"]
["Spotřeba paliva 2 v letech [MWh/rok výhřevnosti]/Fuel 2 consumption in years (MWh/year of calorific value)"]
["Průměrné jednotkové náklady paliva 2 v letech [CZK/MWh]/Average unit costs of fuel 2 in year (CZK/MWh)",null,null,null,{"$f":"IFERROR(E41/E42,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Náklad paliva 3 v letech [CZK] (+)/Fuel costs 3 in years (CZK) (+)"]
["Spotřeba paliva 3 v letech [MWh/rok výhřevnosti]/Fuel consumption 3 in years (MWh/year calorific value)"]
["Průměrné jednotkové náklady paliva 3 v letech [CZK/MWh]/Average unit cost of fuel 3 in years (CZK/MWh)",null,null,null,{"$f":"IFERROR(E44/E45,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Ostatní náklad paliva v letech [CZK] (+)/Other fuel costs in year (CZK) (+)"]
["Náklady na dodané teplo z externího zdroje [CZK]/Cost of delivered heat from external source [CZK]"]
["Roční spotřeba tepla (páry) dodávané z vnějšího zdroje [MWh]/Annual consumption of heat supplied from an external source [MWh]"]
["Průměrné jednotkové náklady na dodané teplo [CZK/MWh]/Average unit cost of delivered heat [CZK/MWh]",null,null,null,{"$f":"IFERROR(E48/E49,\"\")","v":""},{"$f":"IFERROR(F48/F49,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Náklady na dodanou elektřinu z externího zdroje [CZK]/Cost of delivered electricity from external source [CZK]"]
["Roční spotřeba elektřiny dodávané z externího zdroje [MWh]/Annual consumption of electricity supplied from an external source [MWh]"]
["Průměrné jednotkové náklady na dodanou elektřinu [CZK/MWh]/Average unit cost of delivered electricity [CZK/MWh]",null,null,null,{"$f":"IFERROR(E51/E52,\"\")","v":""},{"$f":"IFERROR(F51/F52,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Celkové náklady na paliva a energie, vč. dopravy v letech [CZK/rok]/Total fuel and energy consumption costs, incl. transport in years (CZK/year)",{"$f":"IF(SUM(E54:AQ54)=SUM(E38:AQ38,E41:AQ41,E44:AQ44,E47:AQ47,E48:AQ48,E51:AQ51),\"součet v pořádku / sum is OK\",\"součet paliva nesedí\")","v":"součet v pořádku / sum is OK"}]
["Celkové diskontované náklady na paliva a energie, vč. dopravy [CZK]/Total fuel and energy consumption discounted costs, incl. transport (CZK)",{"$f":"NPV($B$17,E54:AQ54)","v":0}]
[]
["Cena emisní povolenky v letech [CZK/tCO2]/Emission allowance price in year (CZK/tCO2)"]
["Náklady na emisní povolenky v letech [CZK/rok]/Costs of emission allowance in years (CZK/year)"]
["Diskontované náklady na emisní povolenky [CZK]/Discounted costs of emission allowance (CZK)",{"$f":"NPV($B$17,E58:AQ58)","v":0}]
[]
["Ostatní provozní náklady/Other operating costs:","Specifikujte typ nákladu/Specify cost type:"]
["Ostatní provozní náklady 1 [CZK/rok] (+)/Other operating costs 1 (CZK/year) (+)"]
["Ostatní provozní náklady 2 [CZK/rok] (+)/Other operating costs 2 (CZK/year) (+)"]
["Ostatní provozní náklady 3 [CZK/rok] (+)/Other operating costs 3 (CZK/year) (+)"]
["Ostatní provozní náklady 4 [CZK/rok] (+)/Other operating costs 4 (CZK/year) (+)"]
["Ostatní provozní náklady 5 [CZK/rok] (+)/Other operating costs 5 (CZK/year) (+)"]
["Ostatní provozní náklady 6 [CZK/rok] (+)/Other operating costs 6 (CZK/year) (+)"]
["Ostatní provozní náklady 7 [CZK/rok] (+)/Other operating costs 7 (CZK/year) (+)"]
["Ostatní provozní náklady 8 [CZK/rok] (+)/Other operating costs 8 (CZK/year) (+)"]
["Ostatní provozní náklady 9 [CZK/rok] (+)/Other operating costs 9 (CZK/year) (+)"]
["Ostatní provozní náklady 10 [CZK/rok] (+)/Other operating costs 10 (CZK/year) (+)"]
["Ostatní provozní náklady 11 [CZK/rok] (+)/Other operating costs 11 (CZK/year) (+)"]
["Ostatní provozní náklady 12 [CZK/rok] (+)/Other operating costs 12 (CZK/year) (+)"]
["Ostatní provozní náklady (vč. nákladů na opravy a údržbu) v letech [CZK/rok]/Other operating costs (incl. repair and maintenanc costs) in years (CZK/year)",{"$f":"IF(SUM(E74:AQ74)=SUM(E62:AQ73),\"součet v pořádku / sum is OK\",\"součet ostatní náklady nesedí\")","v":"součet v pořádku / sum is OK"}]
["Diskontované ostatní provozní náklady (vč. náklady na opravy a údržbu) [CZK]/Discounted other operating costs (incl. repair and maintenanc costs) (CZK)",{"$f":"NPV($B$17,E74:AQ74)","v":0}]
[null,null,null,null,null,null,null,null,"Dodávka tepla v roce 2027 (GJ/rok)",1663003,"1600 TJ"]
["Dodatečné tržby/Aditional sales:","Specifikujte typ tržby/Specify sales type:"]
["Ostatní tržby 1 [CZK/rok] (+)/Other sales 1 (CZK/year) (+)"]
["Ostatní tržby 2 [CZK/rok] (+)/Other sales 2 (CZK/year) (+)"]
["Ostatní tržby 3 [CZK/rok] (+)/Other sales 3 (CZK/year) (+)"]
["Ostatní tržby 4 [CZK/rok] (+)/Other sales 4 (CZK/year) (+)"]
["Ostatní tržby 5 [CZK/rok] (+)/Other sales 5 (CZK/year) (+)"]
["Ostatní tržby 6 [CZK/rok] (+)/Other sales 6 (CZK/year) (+)"]
["Ostatní tržby 7 [CZK/rok] (+)/Other sales 7 (CZK/year) (+)"]
["Ostatní tržby 8 [CZK/rok] (+)/Other sales 8 (CZK/year) (+)"]
["Ostatní tržby 9 [CZK/rok] (+)/Other sales 9 (CZK/year) (+)"]
["Ostatní tržby 10 [CZK/rok] (+)/Other sales 10 (CZK/year) (+)"]
["Ostatní tržby 11 [CZK/rok] (+)/Other sales 11 (CZK/year) (+)"]
["Ostatní tržby 12 [CZK/rok] (+)/Other sales 12 (CZK/year) (+)"]
["Dodatečné tržby v letech [CZK/rok]/Aditional sales in years [CZK/year]",{"$f":"IF(SUM(E90:AQ90)=SUM(E78:AQ89),\"součet v pořádku / sum is OK\",\"součet ostatní tržby nesedí\")","v":"součet v pořádku / sum is OK"}]
["Diskontované dodatečné tržby [CZK]/Discounted aditional sales [CZK]",{"$f":"NPV($B$17,E90:AQ90)","v":0}]
[]
["Mimořádné výnosy za „zelenou prémii“/Extra revenues for ‘green premium’:","Specifikujte typ bonusu/Specify green bonus type:"]
["Zelená prémie 1 [CZK]/Green bonus 1 (CZK)"]
["Zelená prémie 2 [CZK]/Green bonus 2 (CZK)"]
["Zelená prémie 3 [CZK]/Green bonus 3 (CZK)"]
["Celkové mimořádné výnosy za „zelenou prémii“ v letech [CZK/year]/Total extra revenues for ‘green premium’ in years (CZK/year):",{"$f":"IF(SUM(E97:AQ97)=SUM(E94:AQ96),\"součet v pořádku / sum is OK\",\"součet zelené bonusy nesedí\")","v":"součet v pořádku / sum is OK"}]
["Celkové diskontované mimořádné výnosy za „zelenou prémii“ [CZK]/Total discounted extra revenues for ‘green premium’ (CZK):",{"$f":"NPV($B$17,E97:AQ97)","v":0}]

{"sheet":"BaU","index":1,"n_rows":57,"n_cols":43,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,0,2,0],[3,0,4,0]]}
["FINANČNÍ ANALÝZA PROJEKTU / FINANCIAL ANALYSIS OF THE PROJECT\npro projekty předkládané do programu ENERG ETS financovaného z Modernizačního fondu\nfor projects submitted to the ENERG ETS programme granted by the Modernisation Fund","Legenda/Explanatory notes:",null,"vstupní údaje: vyplní žadatel / input data: to be filled in by the applicant\t"]
[null,null,null,"žadatel zkontroluje / to be checked by the applicant"]
[null,null,null,"automatický výpočet / automatic calculation\t\t"]
["Business as Usual",null,null,"nevyplňovat - začerňuje se automaticky / not to be filled in - automatically blacked out\t\t"]
[]
["OBECNÉ PŘEDPOKLADY/GENERAL ASSUMPTIONS"]
["Rok zahájení pro vyhodnocení projektu  [rok]/Start year for project evaluation (year)",{"$f":"Investment!B8","v":0}]
["Doba vyhodnocení projektu [rok]/Project evaluation period (year)",{"$f":"Investment!B9","v":15}]
["Rok zahájení provozu/Year of start of operation",{"$f":"Investment!B10","v":0}]
["Rok ukončení hodnocení projektu  [rok]/Year of completion of project evaluation (year)",{"$f":"$B$9+$B$8-1","v":14}]
["Časová osa/Timeline",null,null,null,{"$f":"$B$7","v":0},{"$f":"E11+1","v":1},{"$f":"F11+1","v":2},{"$f":"G11+1","v":3},{"$f":"H11+1","v":4},{"$f":"I11+1","v":5},{"$f":"J11+1","v":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,32,33,34,35,36,37,38]
["Byl zahájen provoz (1=ano/0=ne)/Operation started (1=yes/0=no)",null,null,null,{"$f":"IF(E11<$B$9,0,1)","v":1},{"$f":"IF(F11<$B$9,0,1)","v":1},1,{"$f":"IF(H11<$B$9,0,1)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["Rok provozu (v průběhu hodnocení) [rok]/Year of operation (during evaluation) (year)",null,null,null,{"$f":"IF(SUM($E$12:E12)>$B$8,0,SUM($E$12:E12))","v":1},{"$f":"IF(SUM($E$12:F12)>$B$8,0,SUM($E$12:F12))","v":2},{"$f":"IF(SUM($E$12:G12)>$B$8,0,SUM($E$12:G12))","v":3},{"$f":"IF(SUM($E$12:H12)>$B$8,0,SUM($E$12:H12))","v":4},{"$f":"IF(SUM($E$12:I12)>$B$8,0,SUM($E$12:I12))","v":5},{"$f":"IF(SUM($E$12:J12)>$B$8,0,SUM($E$12:J12))","v":6},{"$f":"IF(SUM($E$12:K12)>$B$8,0,SUM($E$12:K12))","v":7},{"$f":"IF(SUM($E$12:L12)>$B$8,0,SUM($E$12:L12))","v":8},{"$f":"IF(SUM($E$12:M12)>$B$8,0,SUM($E$12:M12))","v":9},{"$f":"IF(SUM($E$12:N12)>$B$8,0,SUM($E$12:N12))","v":10},{"$f":"IF(SUM($E$12:O12)>$B$8,0,SUM($E$12:O12))","v":11},{"$f":"IF(SUM($E$12:P12)>$B$8,0,SUM($E$12:P12))","v":12},{"$f":"IF(SUM($E$12:Q12)>$B$8,0,SUM($E$12:Q12))","v":13},{"$f":"IF(SUM($E$12:R12)>$B$8,0,SUM($E$12:R12))","v":14},{"$f":"IF(SUM($E$12:S12)>$B$8,0,SUM($E$12:S12))","v":15},{"$f":"IF(SUM($E$12:T12)>$B$8,0,SUM($E$12:T12))","v":0},{"$f":"IF(SUM($E$12:U12)>$B$8,0,SUM($E$12:U12))","v":0},{"$f":"IF(SUM($E$12:V12)>$B$8,0,SUM($E$12:V12))","v":0},{"$f":"IF(SUM($E$12:W12)>$B$8,0,SUM($E$12:W12))","v":0},{"$f":"IF(SUM($E$12:X12)>$B$8,0,SUM($E$12:X12))","v":0},{"$f":"IF(SUM($E$12:Y12)>$B$8,0,SUM($E$12:Y12))","v":0},{"$f":"IF(SUM($E$12:Z12)>$B$8,0,SUM($E$12:Z12))","v":0},{"$f":"IF(SUM($E$12:AA12)>$B$8,0,SUM($E$12:AA12))","v":0},{"$f":"IF(SUM($E$12:AB12)>$B$8,0,SUM($E$12:AB12))","v":0},{"$f":"IF(SUM($E$12:AC12)>$B$8,0,SUM($E$12:AC12))","v":0},{"$f":"IF(SUM($E$12:AD12)>$B$8,0,SUM($E$12:AD12))","v":0},{"$f":"IF(SUM($E$12:AE12)>$B$8,0,SUM($E$12:AE12))","v":0},{"$f":"IF(SUM($E$12:AF12)>$B$8,0,SUM($E$12:AF12))","v":0},{"$f":"IF(SUM($E$12:AG12)>$B$8,0,SUM($E$12:AG12))","v":0},{"$f":"IF(SUM($E$12:AH12)>$B$8,0,SUM($E$12:AH12))","v":0},{"$f":"IF(SUM($E$12:AI12)>$B$8,0,SUM($E$12:AI12))","v":0},{"$f":"IF(SUM($E$12:AJ12)>$B$8,0,SUM($E$12:AJ12))","v":0},{"$f":"IF(SUM($E$12:AK12)>$B$8,0,SUM($E$12:AK12))","v":0},{"$f":"IF(SUM($E$12:AL12)>$B$8,0,SUM($E$12:AL12))","v":0},{"$f":"IF(SUM($E$12:AM12)>$B$8,0,SUM($E$12:AM12))","v":0},{"$f":"IF(SUM($E$12:AN12)>$B$8,0,SUM($E$12:AN12))","v":0},{"$f":"IF(SUM($E$12:AO12)>$B$8,0,SUM($E$12:AO12))","v":0},{"$f":"IF(SUM($E$12:AP12)>$B$8,0,SUM($E$12:AP12))","v":0},{"$f":"IF(SUM($E$12:AQ12)>$B$8,0,SUM($E$12:AQ12))","v":0}]
["Inflace v letech provozu [%]/Inflation in years of operation (%)",null,null,null,{"$f":"Investment!E15","v":0},{"$f":"Investment!F15","v":0},{"$f":"Investment!G15","v":0},{"$f":"Investment!H15","v":0},{"$f":"Investment!I15","v":0},{"$f":"Investment!J15","v":0},{"$f":"Investment!K15","v":0},{"$f":"Investment!L15","v":0},{"$f":"Investment!M15","v":0},{"$f":"Investment!N15","v":0},{"$f":"Investment!O15","v":0},{"$f":"Investment!P15","v":0},{"$f":"Investment!Q15","v":0},{"$f":"Investment!R15","v":0},{"$f":"Investment!S15","v":0},{"$f":"Investment!T15","v":0},{"$f":"Investment!U15","v":0},{"$f":"Investment!V15","v":0},{"$f":"Investment!W15","v":0},{"$f":"Investment!X15","v":0},{"$f":"Investment!Y15","v":0},{"$f":"Investment!Z15","v":0},{"$f":"Investment!AA15","v":0},{"$f":"Investment!AB15","v":0},{"$f":"Investment!AC15","v":0},{"$f":"Investment!AD15","v":0},{"$f":"Investment!AE15","v":0},{"$f":"Investment!AF15","v":0},{"$f":"Investment!AG15","v":0},{"$f":"Investment!AH15","v":0},{"$f":"Investment!AI15","v":0},{"$f":"Investment!AJ15","v":0},{"$f":"Investment!AK15","v":0},{"$f":"Investment!AL15","v":0},{"$f":"Investment!AM15","v":0},{"$f":"Investment!AN15","v":0},{"$f":"Investment!AO15","v":0},{"$f":"Investment!AP15","v":0},{"$f":"Investment!AQ15","v":0}]
["Směnný kurz [CZK/€]/Exchange rate (CZK/€)",{"$f":"Investment!B16","v":24.521000000000001}]
[]
[]
["PROVOZNÍ NÁKLADY/OPERATING COSTS"]
["Energetické vstupy do výroby/Energy inputs to production:","Specifikujte typ palivového nákl./Specify fuel type costs:","Emisní faktor/emission factor:"]
["Náklad paliva 1 v letech [CZK] (+)/Fuel Cost 1 in years (MWh/year"]
["Spotřeba paliva 1 v letech [MWh/rok výhřevnosti]/Fuel consumption 1 in years (MWh/year calorific value)"]
["Průměrné jednotkové náklady paliva 1 v letech [CZK/MWh]/Average unit cost of fuel 1 in years (CZK/MWh)",null,null,null,{"$f":"IFERROR(E20/E21,\"\")","v":""},{"$f":"IFERROR(F20/F21,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Náklad paliva 2 v letech [CZK] (+)/Fuel costs 2 in years (CZK) (+)"]
["Spotřeba paliva 2 v letech [MWh/rok výhřevnosti]/Fuel 2 consumption in years (MWh/year of calorific value)"]
["Průměrné jednotkové náklady paliva 2 v letech [CZK/MWh]/Average unit costs of fuel 2 in year (CZK/MWh)",null,null,null,{"$f":"IFERROR(E23/E24,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Náklad paliva 3 v letech [CZK] (+)/Fuel costs 3 in years (CZK) (+)"]
["Spotřeba paliva 3 v letech [MWh/rok výhřevnosti]/Fuel consumption 3 in years (MWh/year calorific value)"]
["Průměrné jednotkové náklady paliva 3 v letech [CZK/MWh]/Average unit cost of fuel 3 in years (CZK/MWh)",null,null,null,{"$f":"IFERROR(E26/E27,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Ostatní náklad paliva v letech [CZK] (+)/Other fuel costs in year (CZK) (+)"]
["Náklady na dodané teplo z externího zdroje [CZK]/Cost of delivered heat from external source [CZK]"]
["Roční spotřeba tepla (páry) dodávané z vnějšího zdroje [MWh]/Annual consumption of heat supplied from an external source [MWh]"]
["Průměrné jednotkové náklady na dodané teplo [CZK/MWh]/Average unit cost of delivered heat [CZK/MWh]",null,null,null,{"$f":"IFERROR(E30/E31,\"\")","v":""},{"$f":"IFERROR(F30/F31,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Náklady na dodanou elektřinu z externího zdroje [CZK]/Cost of delivered electricity from external source [CZK]"]
["Roční spotřeba elektřiny dodávané z externího zdroje [MWh]/Annual consumption of electricity supplied from an external source [MWh]"]
["Průměrné jednotkové náklady na dodanou elektřinu [CZK/MWh]/Average unit cost of delivered electricity [CZK/MWh]",null,null,null,{"$f":"IFERROR(E33/E34,\"\")","v":""},{"$f":"IFERROR(F33/F34,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Celkové náklady na paliva a energie, vč. dopravy v letech [CZK/rok]/Total fuel and energy consumption costs, incl. transport in years (CZK/year)",{"$f":"IF(SUM(E36:AQ36)=SUM(E20:AQ20,E23:AQ23,E26:AQ26,E29:AQ29,E30:AQ30,E33:AQ33),\"součet v pořádku / sum is OK\",\"součet paliva nesedí\")","v":"součet v pořádku / sum is OK"}]
["Celkové diskontované náklady na paliva a energie, vč. dopravy [CZK]/Total fuel and energy consumption discounted costs, incl. transport (CZK)",{"$f":"NPV(Investment!$B$17,E36:AQ36)","v":0}]
[]
["Cena emisní povolenky v letech [CZK/tCO2]/Emission allowance price in year (CZK/tCO2)"]
["Náklady na emisní povolenky v letech [CZK/rok]/Costs of emission allowance in years (CZK/year)"]
["Diskontované náklady na emisní povolenky [CZK]/Discounted costs of emission allowance (CZK)",{"$f":"NPV(Investment!$B$17,E40:AQ40)","v":0}]
[]
["Ostatní provozní náklady a náklady na splnění legislativních požadavků /Other operating costs and legislative compliance costs:","Specifikujte typ nákladu/Specify cost type:"]
["Ostatní provozní náklady 1 [CZK/rok] (+)/Other operating costs 1 (CZK/year) (+)"]
["Ostatní provozní náklady 2 [CZK/rok] (+)/Other operating costs 2 (CZK/year) (+)"]
["Ostatní provozní náklady 3 [CZK/rok] (+)/Other operating costs 3 (CZK/year) (+)"]
["Ostatní provozní náklady 4 [CZK/rok] (+)/Other operating costs 4 (CZK/year) (+)"]
["Ostatní provozní náklady 5 [CZK/rok] (+)/Other operating costs 5 (CZK/year) (+)"]
["Ostatní provozní náklady 6 [CZK/rok] (+)/Other operating costs 6 (CZK/year) (+)"]
["Ostatní provozní náklady 7 [CZK/rok] (+)/Other operating costs 7 (CZK/year) (+)"]
["Ostatní provozní náklady 8 [CZK/rok] (+)/Other operating costs 8 (CZK/year) (+)"]
["Ostatní provozní náklady 9 [CZK/rok] (+)/Other operating costs 9 (CZK/year) (+)"]
["Ostatní provozní náklady 10 [CZK/rok] (+)/Other operating costs 10 (CZK/year) (+)"]
["Ostatní provozní náklady 11 [CZK/rok] (+)/Other operating costs 11 (CZK/year) (+)"]
["Ostatní provozní náklady 12 [CZK/rok] (+)/Other operating costs 12 (CZK/year) (+)"]
["Ostatní provozní náklady (vč. náklady na opravy a údržbu) v letech [CZK/rok]/Other operating costs (incl. repair and maintenanc costs) in years (CZK/year)",{"$f":"IF(SUM(E56:AQ56)=SUM(E44:AQ55),\"součet v pořádku / sum is OK\",\"součet ostatní náklady nesedí\")","v":"součet v pořádku / sum is OK"}]
["Diskontované ostatní provozní náklady (vč. nákladů na opravy a údržbu) [CZK]/Discounted other operating costs (incl. repair and maintenanc costs) (CZK)",{"$f":"NPV(Investment!$B$17,E56:AQ56)","v":0},null,null,null,null,null,null,"Dodávka tepla v roce 2027 (GJ/rok)",1663003,"1600 TJ"]

{"sheet":"Subsidy","index":2,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,2,0],[3,0,4,0],[13,3,13,4],[18,3,18,4],[12,3,12,4],[14,3,14,4]]}
["FINANČNÍ ANALÝZA PROJEKTU / FINANCIAL ANALYSIS OF THE PROJECT\npro projekty předkládané do programu ENERG ETS financovaného z Modernizačního fondu\nfor projects submitted to the ENERG ETS programme granted by the Modernisation Fund","Legenda/Explanatory notes:",null,"vstupní údaje: vyplní žadatel / input data: to be filled in by the applicant\t"]
[null,null,null,"žadatel zkontroluje / to be checked by the applicant"]
[null,null,null,"automatický výpočet / automatic calculation\t\t"]
["SUBSIDY CALCULATION",null,null,"nevyplňovat - začerňuje se automaticky / not to be filled in - automatically blacked out\t\t"]
[]
["OBECNÉ PŘEDPOKLADY/GENERAL ASSUMPTIONS"]
["Rok zahájení pro vyhodnocení projektu  [rok]/Start year for project evaluation (year)",{"$f":"Investment!B8","v":0}]
["Doba vyhodnocení projektu [rok]/Project evaluation period (year)",{"$f":"Investment!B9","v":15}]
["Rok zahájení provozu/Year of start of operation",{"$f":"Investment!B10","v":0}]
["Rok ukončení hodnocení projektu  [rok]/Year of completion of project evaluation (year)",{"$f":"$B$9+$B$8-1","v":14}]
[]
["INVESTIČNÍ VÝDAJE/CAPITAL EXPENDITURE"]
["Celkové výdaje projektu / Total project expenditure",{"$f":"Investment!B29","v":0},"CZK",{"$f":"B13/Investment!$B$16","v":0},null,"EUR"]
["Celkové způsobilé investiční výdaje projektu / Total eligible investment expenditure of the project",{"$f":"Investment!B34","v":0},"CZK",{"$f":"B14/Investment!$B$16","v":0},null,"EUR"]
["Způsobilé výdaje pro stanovení podpory / Eligible expenditure for determining aid",{"$f":"IF(AND(Investment!B23>0,Investment!B23>=Investment!B25),B14-Investment!B23,IF(AND(Investment!B25>0,Investment!B25>Investment!B23),B14-Investment!B25,B14))","v":0},"CZK",{"$f":"B15/Investment!$B$16","v":0},null,"EUR"]
["Bonus dle velikosti podniku / Bonus per undertakings size",{"$f":"IF(Investment!G21=3,0,IF(Investment!K16=3,0.2,IF(Investment!K16=2,0.1,0)))","v":0},"%"]
["Bonus za vyšší míru úspor emisí nebo úspor energie / Bonus per reduction of direct GHG or of energy consumption",{"$f":"IF(OR(AND(Investment!G21=1,Investment!B19>=0.55),AND(Investment!G21=2,Investment!B20>=0.25)),0.15,0)","v":0},"%"]
["Míra podpory dle DKTR / Aid intensity according to TCTF",{"$f":"IF(Investment!G21=3,0.3,IF(OR(Investment!G21=1,Investment!G21=2),0.4+B16+B17))","v":0.4},"%"]
["Investiční dotace / Investment grant",{"$f":"FLOOR(IF(Investment!G21=3,B18*B14,B15*B18),1)","v":0},"CZK",{"$f":"FLOOR(B19/Investment!$B$16,1)","v":0},null,"EUR"]
["Efektivní míra podpory / Effective aid intensity",{"$f":"B19/B14","v":{"$error":"#DIV/0!"}},"%"]