{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["0 Úvod","1 Celkové investiční náklady","2 Zůstatková hodnota","3 Provozní náklady","4 Tržby","5 Finanční analýza (FRR_C)","6 Kontrola dotací","7 Mezera ve financování","8 Finanční struktura","9 Udržitelnost","10 FRR_K"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"comments":5,"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":"0 Úvod","index":0,"n_rows":87,"n_cols":15,"rows_kept":87,"cut":false,"hidden":false,"merged":[[4,2,11,13],[16,3,16,13],[40,2,40,3],[25,1,28,1],[25,2,28,13],[30,1,33,1],[30,2,33,13],[41,2,41,3],[39,2,39,3]]}
[]
[]
[]
[null,null,"Úvod"]
[null,null,"Toto je jednoduchý finanční model, který doplňuje stávající výsledky analýz CBA obsažených ve studiích proveditelnosti a ekonomických hodnoceních českých železničních infrastrukturních projektů. Model je založen na analýze výnosů a je plně v souladu se současnou metodikou Evropské komise o CBA.\n\nPřipravil DG REGIO/F.2, SUDOP PRAHA a.s.\nAktualizoval SUDOP PRAHA a.s. 2016, verze 01-2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Základní informace"]
[]
[null,null,"Zdroj dat:","Studie proveditelnosti pro trať Praha Smíchov – Plzeň, doplnění 2016"]
[]
[null,null,"Cenová úroveň (CÚ) ",2016,null,"Začátek stavebních prací",2009,null,"Doba hodnocení",30,null,null,"Směnný kurz (CZK/EUR) ",25.66]
[]
[null,null,"Diskontní sazba",0.04,null,"Začátek provozu",2024,null,null,null,null,null,"DPH",0.21]
[]
[]
[]
[null,null,"Hodnocené scénáře"]
[null,"BEZ PROJEKTU","Odpovídá současnému technickému stavu jednotlivých úseků 3. TŽK a jeho očekávanému vývoji po dobu hodnocení projektu. Cílem této varianty je simulovat situaci, jak by se s největší pravděpodobností vyvíjel stav infrastruktury a z něj plynoucí změny v dopravě, aniž by se do infrastruktury vkládaly investiční prostředky. "]
[]
[]
[]
[]
[null,"S PROJEKTEM","Předpokládá aktualizovanou projektovou variantu č. 2 dle Podkladové studie ve zpřesnění dle Provozně ekonomické studie. Rozdíl oproti těmto uvedeným materiálům potom spočívá v harmonogramu výstavby. Nově se předpokládá uvedení celé trati Praha – Plzeň do provozu v roce 2024 (ukončení výstavby posledního úseku v roce 2023).\nVarianta projektová 2 spočívá v optimalizaci celé tratě Praha – Beroun – Plzeň ve stávající stopě vyjma úseku Ejpovice – Plzeň, který je navržen v nové stopě. V úseku Praha – Beroun spočívá optimalizace ve zvýšení traťové rychlosti na 90 až 140 km/h, úpravě všech železničních stanic a zastávek, náhradě úrovňových přejezdů mimoúrovňovým křížením, instalaci nového zabezpečovacího zařízení 3. kategorie, zajištění prostorové průchodnosti UICGC a traťové třídy zatížení D4.\nV úseku Rokycany – Ejpovice – Plzeň bude trať přeložena do nové stopy (přeložka Ejpovice). Stávající trať přes žst. Chrást u Plzně bude částečně ponechána pro místní dopravu a částečně zrušena.\n"]
[]
[]
[]
[]
[]
[]
[null,null,"Seznam tabulek"]
[]
[null,null,"List / tabulka",null,"Celk. investiční náklady","Zůstatková hodnota","Provozní náklady","Tržby","Fin. analýza (FRR_C)","Kontrola dotací","Mezera ve financování","Finanční struktura","Udržitelnost","FRR_K"]
[null,null,"V konstantních cenách*",null,"1.1.","2.1., 2.2","3.1., 3.2., 3.3","4.1., 4.2., 4.3","5.1.","6.1., 6.2., 6.3","7.1., 7.2","8.1.","9.1.","10.1."]
[null,null,"V běžných cenách**",null,"1.2.",null,null,null,null,null,"7.3.","8.2."]
[]
[null,null,"*  v případě \"stavebního souboru\" (např. tranzitní železniční koridor) - všechny tabulky se vztahují na celý projekt"]
[null,null,"** tabulky pro projektovou žádost"]
[]
[]
[]
[null,null,"Míra inflace"]
[]
[null,null,"rok",2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,"***"]
[null,null,"inflace",2.5000000000000001E-2,2.8000000000000001E-2,6.3E-2,0.01,1.4999999999999999E-2,1.9E-2,3.3000000000000002E-2,1.4E-2,4.0000000000000001E-3,3.0000000000000001E-3,0.01]
[null,null,null,1,1,1,1,1,1,1,{"$f":"J53*(1+K52)","v":1.014},{"$f":"K53*(1+L52)","v":1.0180560000000001},{"$f":"L53*(1+M52)","v":1.0211101679999999},{"$f":"M53*(1+N52)","v":1.0313212696799998}]
[null,null,"zdroj: Prováděcí pokyny pro hodnocení efektivnosti investic železničních staveb (č. 26/2013-910-IZD/3), MD 2013 - příloha A.2; ČNB (Zpráva o inflaci I/2016)"]
[]
[null,null,"Index cen stavebních prací"]
[]
[null,null,"rok",2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016]
[null,null,"inflace",2.9000000000000001E-2,4.1000000000000002E-2,4.4999999999999998E-2,1.2E-2,-2E-3,-5.0000000000000001E-3,-7.0000000000000001E-3,-1.0999999999999999E-2,5.0000000000000001E-3,0,0]
[null,null,null,1,1,1,1,1,1,1,1,{"$f":"K60*(1+L59)","v":1.0049999999999999},{"$f":"L60*(1+M59)","v":1.0049999999999999},{"$f":"M60*(1+N59)","v":1.0049999999999999}]
[null,null,"zdroj: aktuálně platné opatření SFDI (č.j. 3029/SFDI/320079/8567/2015); ČSÚ"]
[]
[null,null,"*** pro další roky platí v souladu s Prováděcími pokyny hodnota 2,00%"]
[]
[null,null,"HDP na hlavu"]
[]
[" ",null,"rok",2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015]
[null,null,"HDP na hlavu",6.2E-2,6.5000000000000002E-2,0.05,1.7000000000000001E-2,-5.3999999999999999E-2,0.02,2.1999999999999999E-2,-0.01,-5.0000000000000001E-3,1.7999999999999999E-2,4.7E-2]
[]
[null,null,"rok",2016,2017,2018,2019,2020,2030,2050]
[null,null,"HDP na hlavu",2.8000000000000001E-2,2.9000000000000001E-2,0.03,0.03,0.02,0.01,0.01]
[]
[null,null,"zdroj: Prováděcí pokyny pro hodnocení efektivnosti investic železničních staveb (č. 26/2013-910-IZD/3), MD 2013 - příloha A.2; ČSÚ; ČNB (Zpráva o inflaci I/2016)"]
[]
[]
[]
[null,null,"Růst reálných mezd"]
[]
[" ",null,"rok",2012,2013,2014,2015,2016,2017,2018,2019,2020,2030,2050]
[null,null,"růst mezd",-8.0000000000000002E-3,-1.4999999999999999E-2,1.9E-2,2.8000000000000001E-2,0.03,2.5000000000000001E-2,0.03,0.03,2.5000000000000001E-2,0.02,0.02]
[null,null,null,1,{"$f":"D81*(1+E80*'3 Provozní náklady'!$D$71)","v":0.98499999999999999},{"$f":"E81*(1+F80*'3 Provozní náklady'!$D$71)","v":1.0037149999999999},{"$f":"F81*(1+G80*'3 Provozní náklady'!$D$71)","v":1.0318190199999999},{"$f":"G81*(1+H80*'3 Provozní náklady'!$D$71)","v":1.0627735906},{"$f":"H81*(1+I80*'3 Provozní náklady'!$D$71)","v":1.089342930365},{"$f":"I81*(1+J80*'3 Provozní náklady'!$D$71)","v":1.12202321827595},{"$f":"J81*(1+K80*'3 Provozní náklady'!$D$71)","v":1.1556839148242286},{"$f":"K81*(1+L80*'3 Provozní náklady'!$D$71)","v":1.1845760126948341},{"$f":"L81*(1+M80*'3 Provozní náklady'!$D$71)^(M79-L79)","v":1.4439915495346414},{"$f":"M81*(1+N80*'3 Provozní náklady'!$D$71)^(N79-M79)","v":2.1456954828457491}]
[null,null,"zdroj: do r. 2016 vč. ČNB (Zpráva o inflaci I/2016); od r. 2017 vč. Prováděcí pokyny pro hodnocení efektivnosti investic železničních staveb (č. 26/2013-910-IZD/3), MD 2013 - příloha A.2"]
[]
[]
[]
[]
[null,null,"Vyplnit pouze žlutě podbarvené buňky!"]

{"sheet":"1 Celkové investiční náklady","index":1,"n_rows":69,"n_cols":21,"rows_kept":69,"cut":false,"hidden":false,"merged":[[65,1,66,15],[17,3,18,3],[17,4,18,4],[17,5,18,5],[33,3,34,3],[33,4,34,4],[33,5,34,5],[49,5,50,5],[2,5,3,5],[2,4,3,4],[2,3,3,3],[49,3,50,3],[49,4,50,4]]}
[]
[null,"1.1.","Celkové investiční náklady (CZK) *",null,null,null,"V roce"]
[null,"a","(konstantní ceny)",null,null,"Celk. projekt. náklady",{"$f":"'0 Úvod'!G19","v":2009},{"$f":"G3+1","v":2010},{"$f":"H3+1","v":2011},2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023]
[null,null,{"$f":"'0 Úvod'!D19","v":2016}]
[null,null,"Přípravná a projektová dokumentace",null,null,{"$f":"SUM(G5:U5,G20:U20)","v":1565531474.6766872},570945863.54622543,23589792.817540612,30897155.137669943,31621200.423507556,23553169.938959241,74835585.295999601,59028115.410790563,76031557.906075686,94579432.049674749,60314544.501566969,98721231.961457133,113293045.74221952,106047592.75000001,112262032.71250002,89811154.482500032]
[null,null,"Zábory a nákupy pozemků",null,null,{"$f":"SUM(G6:U6,G21:U21)","v":283213449.83197999},30688270.7735027,57836241.909028098,19302360.699819997,6720858.5720499996,13006784,418892,6334799,27257313.559999999,51241781.738333344,56573701.818637528,9843795.1303041689,868150.63030418742,624000.00000000012,2439500,57000.000000000007]
[null,null,"Stavby a konstrukce (stavební náklady)",null,null,23695628284.38052,1163616890.0234585,2795256572.1437416,2523812875.18363,1437534610.2463009,590190411.35674298,582670272.61249042,1235619067.1435487,1087936556.8067505,2464790415.1023078,1916961770.18295,2698170994.5696468,1955691218.0089531,1116290450,1181705607.5,945380573.50000012]
[null,null,"Stroje a zařízení",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Technická asistence, propagace",null,null,254244010.88101113,19511989.052878793,7587465.7184559004,9975260.8307579495,3757090.3048612494,9240705.908291854,10986927.560000001,16201844.094924195,22298217.378257528,46501658.152133144,49399883.890859999,11846700.992295267,14502500.687295269,11162904.5,11817056.075000003,9453805.7350000031]
[null,null,"Technický dozor",null,null,581841449.31024122,37037569.228820391,27011137.482683878,26967619.817753926,22419850.275897652,19402944.439999998,26410967.443999413,28588065.931881003,34983562.979328722,53897878.485931925,44805575.559789613,54496115.320827372,59868213.948327377,50233070.25,53176752.337499999,42542125.807500005]
[null,null,"Celkové investiční náklady bez rezervy  (konstantní ceny)",null,null,26380458669.080444,{"$f":"SUM(G5:G10)","v":1821800582.6248858},2911281210.0714498,2610955271.669632,1502053609.8226175,655394015.64399409,695322644.91248941,1345771891.5811446,1248507208.6304123,2711011165.5283809,2128055475.9538043,2873078837.9745307,2144223129.0170994,1284358017.5,1361400948.6250002,1087244659.5250001]
[null,null,"Rezerva",null,null,1752085534.9064157,null,null,null,null,null,null,null,39657011.18292246,612635960.75136781,310619909.07569367,269765223.62386537,195069767.17256615,111629045,118170560.75,94538057.350000039]
[null,null,"Celkové investiční náklady včetně rezervy (konstantní ceny)",null,null,28132544203.986858,{"$f":"SUM(G11:G12)","v":1821800582.6248858},{"$f":"SUM(H11:H12)","v":2911281210.0714498},{"$f":"SUM(I11:I12)","v":2610955271.669632},1502053609.8226175,655394015.64399409,695322644.91248941,1345771891.5811446,1288164219.8133347,3323647126.2797489,2438675385.0294981,3142844061.5983963,2339292896.1896653,1395987062.5,1479571509.3750002,{"$f":"SUM(U11:U12)","v":1181782716.8750002}]
[null,null,{"$f":"'0 Úvod'!$N$21*1000","v":210},null,null,5907834282.8372402,{"$f":"G13*$C14/1000","v":382578122.35122603},{"$f":"H13*$C14/1000","v":611369054.11500442},{"$f":"I13*$C14/1000","v":548300607.0506227},315431258.06274968,137632743.28523877,146017755.43162277,282612097.23204035,270514486.16080028,697965896.51874733,512121830.85619456,659997252.93566322,491251508.1998297,293157283.125,310710016.96875006,{"$f":"U13*$C14/1000","v":248174370.54375005}]
[null,null,"Celkové investiční náklady včetně DPH (konstantní ceny)",null,null,34040378486.8241,{"$f":"G14+G13","v":2204378704.9761119},{"$f":"H14+H13","v":3522650264.1864543},{"$f":"I14+I13","v":3159255878.7202549},1817484867.8853672,793026758.92923284,841340400.34411216,1628383988.813185,1558678705.9741349,4021613022.7984962,2950797215.8856926,3802841314.5340595,2830544404.3894949,1689144345.625,1790281526.3437502,{"$f":"U14+U13","v":1429957087.4187503}]
[]
[null,"1.1.","Celkové investiční náklady (CZK) *"]
[null,"b","(konstantní ceny)",null,null,null,{"$f":"U3+1","v":2024},{"$f":"G18+1","v":2025},{"$f":"H18+1","v":2026},2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038]
[null,null,{"$f":"'0 Úvod'!D19","v":2016}]
[null,null,{"$f":"C5","v":"Přípravná a projektová dokumentace"}]
[null,null,"Zábory a nákupy pozemků"]
[null,null,"Stavby a konstrukce (stavební náklady)"]
[null,null,"Stroje a zařízení"]
[null,null,"Technická asistence, propagace"]
[null,null,"Technický dozor"]
[null,null,"Celkové investiční náklady bez rezervy  (konstantní ceny)",null,null,null,{"$f":"SUM(G20:G25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Rezerva"]
[null,null,"Celkové investiční náklady včetně rezervy (konstantní ceny)",null,null,null,{"$f":"SUM(G26:G27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'0 Úvod'!$N$21*1000","v":210},null,null,null,{"$f":"G28*$C29/1000","v":0},{"$f":"H28*$C29/1000","v":0},{"$f":"I28*$C29/1000","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"U28*$C29/1000","v":0}]
[null,null,"Celkové investiční náklady včetně DPH (konstantní ceny)",null,null,null,{"$f":"G29+G28","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"1.2.","Celkové investiční náklady (CZK)"]
[null,"a","(běžné ceny)","Nezpůsobilé náklady","Způsobilé náklady","Celk. projekt. náklady",{"$f":"G3","v":2009},{"$f":"G34+1","v":2010},{"$f":"H34+1","v":2011},2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023]
[null,null,"Způsobilost nákladů **"]
[null,null,"Poplatky za plány/stavební projekt",{"$f":"F36-E36","v":0},null,{"$f":"SUM(G36:U36,G52:U52)","v":0}]
[null,null,"Nákup pozemků",0,null,{"$f":"SUM(G37:U37,G53:U53)","v":0}]
[null,null,"Výstavba",0,null,0]
[null,null,"Prostory a strojní zařízení nebo vybavení ",0,null,0]
[null,null,"Nepředvídané události",0,null,0]
[null,null,"Úprava ceny (v příslušném případě)",0,null,0]
[null,null,"Propagace",0,null,0]
[null,null,"Dozor v průběhu provádění výstavby",0,null,0]
[null,null,"Technická pomoc",0,null,0]
[null,null,"Celkové investiční náklady (běžné ceny)",{"$f":"SUM(D36:D44)","v":0},{"$f":"SUM(E36:E44)","v":0},0,{"$f":"SUM(G36:G44)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'0 Úvod'!$N$21*1000","v":210},{"$f":"D45*$C46/1000","v":0},{"$f":"E45*$C46/1000","v":0},0,{"$f":"G45*$C46/1000","v":0},{"$f":"H45*$C46/1000","v":0},{"$f":"I45*$C46/1000","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"U45*$C46/1000","v":0}]
[null,null,"Celkové investiční náklady vč. DPH (běžné ceny)",{"$f":"SUM(D45:D46)","v":0},{"$f":"SUM(E45:E46)","v":0},0,{"$f":"G46+G45","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"1.2.","Celkové investiční náklady (CZK)"]
[null,"b","(běžné ceny)",null,null,null,{"$f":"U34+1","v":2024},{"$f":"G50+1","v":2025},{"$f":"H50+1","v":2026},2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038]
[null,null,"Způsobilost nákladů **"]
[null,null,"Poplatky za plány/stavební projekt"]
[null,null,"Nákup pozemků"]
[null,null,"Výstavba"]
[null,null,"Prostory a strojní zařízení nebo vybavení "]
[null,null,"Nepředvídané události"]
[null,null,"Úprava ceny (v příslušném případě)"]
[null,null,"Propagace"]
[null,null,"Dozor v průběhu provádění výstavby"]
[null,null,"Technická pomoc"]
[null,null,"Celkové investiční náklady (běžné ceny)",null,null,null,{"$f":"SUM(G52:G60)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'0 Úvod'!$N$21*1000","v":210},null,null,null,{"$f":"G61*$C62/1000","v":0},{"$f":"H61*$C62/1000","v":0},{"$f":"I61*$C62/1000","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"U61*$C62/1000","v":0}]
[null,null,"Celkové investiční náklady vč. DPH (běžné ceny)",null,null,null,{"$f":"G62+G61","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Komentáře"]
[]
[null,"*  v případě \"souboru staveb\" (např. tranzitní železniční koridor) - celkové náklady se vztahují na celý projekt"]
[null,"**  jednotlivé položky odpovídají definici dle prováděcího Nařízení komise (EU) 2015/207 přílohy II, části C.1 "]

{"sheet":"2 Zůstatková hodnota","index":2,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[15,1,15,3],[18,8,18,9],[19,8,19,9]]}
[]
[null,"2.1.","Životnost investice (roky)","Náklady (CZK)","Vážení",null,"2.3.","Výpočet zůstatkové hodnoty"]
[null,null,"Zabezpečovací zařízení",2340953768.5155911,{"$f":"D3*D20","v":46819075370.311821},null,null,"Celková životnost investice",{"$f":"$E$16","v":44}]
[null,null,"Sdělovací zařízení",714866679.86075366,{"$f":"D4*D21","v":14297333597.215073},null,null,"Délka provozní fáze hodnotícího období",{"$f":"'0 Úvod'!$J$19-('0 Úvod'!$G$21-'0 Úvod'!$G$19)","v":15}]
[null,null,"Silnoproudé rozvody a zařízení",1134427175.6440644,22688543512.881287,null,null,"Životnost investice po skončení hodnotícího období",{"$f":"IF((I3-I4)<0,0,I3-I4)","v":29}]
[null,null,"Železniční svršek",5851400189.2689142,175542005678.06741,null,null,"Průměrný nákladový peněžní tok (nediskontovaný)",{"$f":"SUM('5 Finanční analýza (FRR_C)'!E13:S13,'5 Finanční analýza (FRR_C)'!E25:S25)/('0 Úvod'!J19-('0 Úvod'!$G$21-'0 Úvod'!G19))","v":425049147.61691594}]
[null,null,"Železniční spodek",3347452756.7147431,200847165402.88458,null,null,"ZŮSTATKOVÁ HODNOTA",{"$f":"IF((I6*(1/(1+'0 Úvod'!D21))*(((1/(1+'0 Úvod'!D21))^I5-1)/((1/(1+'0 Úvod'!D21))-1)))<0,0,I6*(1/(1+'0 Úvod'!D21))*(((1/(1+'0 Úvod'!D21))^I5-1)/((1/(1+'0 Úvod'!D21))-1)))","v":7218913427.9942722}]
[null,null,"Mosty, propustky, zdi",2692905927.7035322,201967944577.76492]
[null,null,"Tunely",2322301867.1920009,209007168047.28009]
[null,null,"Komunikace a zpevněné plochy",463156921.58225155,9263138431.645031]
[null,null,"Trakce",2214598062.8577642,66437941885.732925]
[null,null,"Inženýrské sítě (trubní vedení, kabelovody)",271681179.33820415,5433623586.7640829]
[null,null,"Pozemní stavby, nástupiště a přístřešky",1055513669.8071778,42220546792.287109]
[null,null,"Objekty ochrany životního prostředí",676774677.05639458,20303240311.691837]
[null,null,"CELKEM",{"$f":"SUM(D3:D14)","v":23086032875.541397},{"$f":"SUM(E3:E14)","v":1014827727194.5262}]
[null,"Celková životnost investice (roky)",null,null,{"$f":"ROUND(E15/D15,0)","v":44}]
[]
[]
[null,"2.2.","Životnost jednotlivých prvků","roky",null,null,"2.4.","Diskont. zůstatková hodnota investic pro FA",{"$f":"I7*(1/(1+'0 Úvod'!D21)^('0 Úvod'!J19-1))","v":2314754803.2280164}]
[null,null,"Zabezpečovací zařízení",{"$f":"100/5","v":20},null,null,null,"Diskontovaná zůstatková hodnota investic v EUR",{"$f":"I19/'0 Úvod'!N19","v":90208682.900546238}]
[null,null,"Sdělovací zařízení",20]
[null,null,"Silnoproudé rozvody a zařízení",20]
[null,null,"Železniční svršek",30]
[null,null,"Železniční spodek",60]
[null,null,"Mosty, propustky, zdi",75]
[null,null,"Tunely",90]
[null,null,"Komunikace a zpevněné plochy",20]
[null,null,"Trakce",30]
[null,null,"Inženýrské sítě (trubní vedení, kabelovody)",20]
[null,null,"Pozemní stavby, nástupiště a přístřešky",40]
[null,null,"Objekty ochrany životního prostředí",30]

{"sheet":"3 Provozní náklady","index":3,"n_rows":180,"n_cols":19,"rows_kept":180,"cut":false,"hidden":false,"merged":[[176,1,177,16],[85,17,86,17],[85,15,86,15],[68,17,69,17],[68,5,69,5],[157,4,158,4],[157,5,158,5],[157,6,158,6],[85,4,86,4],[85,5,86,5],[85,6,86,6],[85,7,86,7],[68,4,69,4],[68,10,69,10],[68,11,69,11],[85,8,86,8],[68,8,69,8],[85,12,86,12],[68,14,69,14],[68,15,69,15],[85,16,86,16],[121,17,122,17],[121,14,122,14],[103,11,104,11],[157,18,158,18],[139,17,140,17],[157,13,158,13],[157,14,158,14],[139,11,140,11],[157,7,158,7],[139,10,140,10],[121,9,122,9],[121,15,122,15],[139,14,140,14],[139,18,140,18],[121,18,122,18],[121,4,122,4],[121,5,122,5],[121,6,122,6],[157,15,158,15],[157,16,158,16],[157,17,158,17],[157,8,158,8],[157,9,158,9],[157,10,158,10],[157,11,158,11],[139,16,140,16],[157,12,158,12],[139,4,140,4],[139,5,140,5],[139,6,140,6],[139,7,140,7],[139,8,140,8],[139,9,140,9],[139,15,140,15],[121,7,122,7],[121,8,122,8],[85,13,86,13],[68,12,69,12],[68,13,69,13],[68,9,69,9],[85,9,86,9],[85,10,86,10],[103,12,104,12],[103,13,104,13],[139,12,140,12],[139,13,140,13],[38,6,39,6],[68,18,69,18],[23,18,24,18],[38,18,39,18],[23,4,24,4],[1,4,2,4],[1,5,2,5],[23,6,24,6],[31,4,32,4],[31,6,32,6],[8,4,9,4],[16,6,17,6],[8,5,9,5],[16,4,17,4],[23,5,24,5],[31,5,32,5],[16,5,17,5],[1,6,2,6],[8,6,9,6],[1,12,2,12],[38,11,39,11],[38,12,39,12],[23,10,24,10],[68,16,69,16],[8,12,9,12],[8,13,9,13],[23,9,24,9],[38,13,39,13],[38,9,39,9],[121,12,122,12],[121,13,122,13],[1,18,2,18],[85,18,86,18],[85,14,86,14],[103,18,104,18],[103,17,104,17],[103,14,104,14],[103,15,104,15],[103,16,104,16],[1,17,2,17],[38,16,39,16],[38,17,39,17],[1,14,2,14],[1,15,2,15],[1,16,2,16],[121,16,122,16],[8,16,9,16],[103,9,104,9],[1,8,2,8],[121,10,122,10],[121,11,122,11],[8,7,9,7],[23,8,24,8],[38,7,39,7],[31,8,32,8],[16,7,17,7],[31,7,32,7],[38,8,39,8],[8,8,9,8],[103,7,104,7],[31,10,32,10],[31,9,32,9],[8,10,9,10],[103,8,104,8],[103,10,104,10],[85,11,86,11],[68,7,69,7],[31,18,32,18],[8,17,9,17],[8,15,9,15],[8,14,9,14],[38,14,39,14],[38,15,39,15],[23,16,24,16],[16,18,17,18],[1,7,2,7],[8,11,9,11],[31,13,32,13],[31,14,32,14],[16,13,17,13],[16,14,17,14],[31,15,32,15],[23,11,24,11],[23,12,24,12],[23,13,24,13],[1,9,2,9],[1,10,2,10],[1,11,2,11],[8,9,9,9],[8,18,9,18],[1,13,2,13],[103,4,104,4],[103,5,104,5],[103,6,104,6],[51,1,53,1],[16,17,17,17],[16,12,17,12],[31,11,32,11],[16,8,17,8],[16,9,17,9],[16,10,17,10],[16,11,17,11],[31,12,32,12],[23,7,24,7],[38,4,39,4],[38,5,39,5],[16,15,17,15],[38,10,39,10],[23,17,24,17],[23,14,24,14],[23,15,24,15],[16,16,17,16],[31,16,32,16],[31,17,32,17],[68,6,69,6]]}
[]
[null,"3.1.","Celkové provozní náklady (CZK)",null,{"$f":"'1 Celkové investiční náklady'!G3","v":2009},{"$f":"E2+1","v":2010},2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023]
[null,"a","Scénář s projektem","Celkem"]
[null,null,"Náklady na údržbu a provoz infrastruktury",{"$f":"SUM(E4:S4,E11:S11)","v":4975016440.6351357},154438210.22098094,160580374.14310643,194821024.94473922,136047405.63453296,126146188.04292861,164309269.20918572,159701253.10580003,156577675.04303914,156577675.04303914,156577675.04303914,167443295.11050403,167497623.21084136,167552222.95168036,167607095.69122356,167662242.7944645]
[null,null,"Periodické provozní náklady / opravy",{"$f":"SUM(E5:S5,E12:S12)","v":0}]
[null,null,"Náklady na řízení provozu",2292207907.3129764,104197296.99429622,104394240.51490632,114276447.90391849,92856289.384952843,90865527.883156449,92310934.4196897,99301727.470499992,99743209.224488571,99743209.224488571,99743209.224488571,{"$f":"IF(O2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(O72:O84,O106:O118)+O120,0)","v":78880018.906375825},{"$f":"IF(P2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(P72:P84,P106:P118)+P120,0)","v":80852019.379035205},{"$f":"IF(Q2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(Q72:Q84,Q106:Q118)+Q120,0)","v":82873319.863511071},{"$f":"IF(R2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(R72:R84,R106:R118)+R120,0)","v":84945152.860098854},{"$f":"IF(S2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(S72:S84,S106:S118)+S120,0)","v":94104417.330575973}]
[null,null,"Celkové provozní náklady",7267224347.9481134,{"$f":"SUM(E4:E6)","v":258635507.21527717},{"$f":"SUM(F4:F6)","v":264974614.65801275},309097472.84865773,228903695.0194858,217011715.92608505,256620203.62887543,259002980.57630002,256320884.2675277,256320884.2675277,256320884.2675277,246323314.01687986,248349642.58987656,250425542.81519145,252552248.5513224,261766660.12504047]
[]
[null,"3.1.","Celkové provozní náklady (CZK)",null,{"$f":"S2+1","v":2024},{"$f":"E9+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038]
[null,"b","Scenář s projektem"]
[null,null,{"$f":"C4","v":"Náklady na údržbu a provoz infrastruktury"},null,165171195.47535428,165997051.45273104,166827036.7099947,167661171.89354461,168499477.75301233,169341975.14177737,170188685.01748624,171039628.44257367,171894826.58478653,172754300.71771044,173618072.22129893,174486162.58240542,176231024.20822948,177993334.45031178,179773267.79481491]
[null,null,{"$f":"C5","v":"Periodické provozní náklady / opravy"}]
[null,null,{"$f":"C6","v":"Náklady na řízení provozu"},null,{"$f":"IF(E9<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(E89:E101,E124:E136)+E138,0)","v":49482811.719211459},{"$f":"IF(F9<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(F89:F101,F124:F136)+F138,0)","v":50719882.012191743},{"$f":"IF(G9<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(G89:G101,G124:G136)+G138,0)","v":51987879.062496528},{"$f":"IF(H9<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(H89:H101,H124:H136)+H138,0)","v":53287576.039058939},{"$f":"IF(I9<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(I89:I101,I124:I136)+I138,0)","v":54619765.440035403},{"$f":"IF(J9<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(J89:J101,J124:J136)+J138,0)","v":55985259.576036289},{"$f":"IF(K9<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(K89:K101,K124:K136)+K138,0)","v":57104964.76755701},{"$f":"IF(L9<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(L89:L101,L124:L136)+L138,0)","v":58247064.062908158},{"$f":"IF(M9<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(M89:M101,M124:M136)+M138,0)","v":59412005.344166324},{"$f":"IF(N9<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(N89:N101,N124:N136)+N138,0)","v":60600245.451049641},{"$f":"IF(O9<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(O89:O101,O124:O136)+O138,0)","v":61812250.360070631},{"$f":"IF(P9<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(P89:P101,P124:P136)+P138,0)","v":63048495.367272049},{"$f":"IF(Q9<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(Q89:Q101,Q124:Q136)+Q138,0)","v":64309465.274617493},{"$f":"IF(R9<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(R89:R101,R124:R136)+R138,0)","v":65595654.580109842},{"$f":"IF(S9<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(S89:S101,S124:S136)+S138,0)","v":66907567.671712041}]
[null,null,{"$f":"C7","v":"Celkové provozní náklady"},null,{"$f":"SUM(E11:E13)","v":214654007.19456574},216716933.46492279,218814915.77249122,220948747.93260354,223119243.19304773,225327234.71781367,227293649.78504324,229286692.50548184,231306831.92895287,233354546.16876006,235430322.58136958,237534657.94967747,240540489.48284698,243588989.03042161,246680835.46652696]
[]
[]
[null,"3.2.","Celkové provozní náklady (CZK)",null,{"$f":"E2","v":2009},{"$f":"E17+1","v":2010},2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023]
[null,"a","Scénář bez projektu","Celkem"]
[null,null,"Náklady na údržbu a provoz infrastruktury",{"$f":"SUM(E19:S19,E26:S26)","v":7187040032.5179281},239395425.4927938,240803321.24954668,244319159.13943109,243166068.31771299,239595291.68797046,238470782.22779316,237390498.26257455,237721172.79671943,236624888.86076725,235312243.1283578,236951178.97084299,233829354.65730861,233666914.92266449,235156818.47222438,238707884.25636896]
[null,null,"Periodické provozní náklady / opravy",{"$f":"SUM(E20:S20,E27:S27)","v":5858692381.2522488},171832568.93262032,11104665.946803406,72140932.379977703,1106628635.060365,103947705.01863639,168072131.01357853,26814883.43757759,88063381.412650496,125076816.48940158,171183165.83135939,286821397.52024478,196790744.09046769,246906617.47249928,301420894.24682742,37235833.399100453]
[null,null,"Náklady na řízení provozu",4272964588.7965412,{"$f":"IF(E17<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(E72:E84,E142:E154)+E156,0)","v":100746101.75738782},{"$f":"IF(F17<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(F72:F84,F142:F154)+F156,0)","v":103191395.48936325},{"$f":"IF(G17<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(G72:G84,G142:G154)+G156,0)","v":102986039.47843914},{"$f":"IF(H17<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(H72:H84,H142:H154)+H156,0)","v":102162151.1626116},{"$f":"IF(I17<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(I72:I84,I142:I154)+I156,0)","v":100629718.89517242},{"$f":"IF(J17<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(J72:J84,J142:J154)+J156,0)","v":102541683.55418068},{"$f":"IF(K17<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(K72:K84,K142:K154)+K156,0)","v":105412850.69369775},{"$f":"IF(L17<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(L72:L84,L142:L154)+L156,0)","v":108575236.21450868},{"$f":"IF(M17<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(M72:M84,M142:M154)+M156,0)","v":111289617.11987139},{"$f":"IF(N17<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(N72:N84,N142:N154)+N156,0)","v":114628305.63346754},{"$f":"IF(O17<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(O72:O84,O142:O154)+O156,0)","v":118067154.80247158},{"$f":"IF(P17<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(P72:P84,P142:P154)+P156,0)","v":121018833.67253333},{"$f":"IF(Q17<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(Q72:Q84,Q142:Q154)+Q156,0)","v":124044304.51434667},{"$f":"IF(R17<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(R72:R84,R142:R154)+R156,0)","v":129719597.90923759},{"$f":"IF(S17<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(S72:S84,S142:S154)+S156,0)","v":115693054.57222086}]
[null,null,"Celkové provozní náklady",17318697002.566719,{"$f":"SUM(E19:E21)","v":511974096.1828019},355099382.68571335,419446130.99784797,1451956854.5406895,444172715.60177928,509084596.79555237,369618232.39384991,434359790.42387855,472991322.4700402,521123714.59318471,641839731.29355931,551638932.42030954,604617836.90951049,666297310.62828946,391636772.22769028]
[]
[null,"3.2.","Celkové provozní náklady (CZK)",null,{"$f":"S17+1","v":2024},{"$f":"E24+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038]
[null,"b","Scénář bez projektu",null,{"$f":"S18+1","v":1}]
[null,null,{"$f":"C19","v":"Náklady na údržbu a provoz infrastruktury"},null,244292306.13056678,240800779.55443412,238468570.95304525,238971458.03954217,240192335.86991239,244280563.49914676,243345016.36211324,245745050.09758094,244406415.53264549,241530792.5161899,240052987.43536586,239127746.87201381,239017437.30412844,238584535.79255608,237113034.11561126]
[null,null,{"$f":"C20","v":"Periodické provozní náklady / opravy"},null,858443544.94624436,562159416.52191424,19825221.878019344,34586116.244249791,18903857.399713956,202003760.76634166,47711429.805543624,94409994.108729824,196561991.53033701,120863956.84032309,103988372.1404373,55035324.272404373,72588270.719788864,160524567.37681141,197046184.44928065]
[null,null,{"$f":"C21","v":"Náklady na řízení provozu"},null,{"$f":"IF(E24<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(E89:E101,E160:E172)+E174,0)","v":118585380.93652636},{"$f":"IF(F24<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(F89:F101,F160:F172)+F174,0)","v":121550015.45993954},{"$f":"IF(G24<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(G89:G101,G160:G172)+G174,0)","v":124588765.84643799},{"$f":"IF(H24<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(H89:H101,H160:H172)+H174,0)","v":166126540.82858473},{"$f":"IF(I24<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(I89:I101,I160:I172)+I174,0)","v":170279704.34929934},{"$f":"IF(J24<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(J89:J101,J160:J172)+J174,0)","v":174536696.9580318},{"$f":"IF(K24<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(K89:K101,K160:K172)+K174,0)","v":178027430.89719242},{"$f":"IF(L24<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(L89:L101,L160:L172)+L174,0)","v":181587979.5151363},{"$f":"IF(M24<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(M89:M101,M160:M172)+M174,0)","v":185219739.10543904},{"$f":"IF(N24<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(N89:N101,N160:N172)+N174,0)","v":188924133.88754779},{"$f":"IF(O24<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(O89:O101,O160:O172)+O174,0)","v":192702616.56529874},{"$f":"IF(P24<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(P89:P101,P160:P172)+P174,0)","v":196556668.89660472},{"$f":"IF(Q24<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(Q89:Q101,Q160:Q172)+Q174,0)","v":200487802.27453685},{"$f":"IF(R24<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(R89:R101,R160:R172)+R174,0)","v":204497558.32002756},{"$f":"IF(S24<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(S89:S101,S160:S172)+S174,0)","v":208587509.48642811}]
[null,null,{"$f":"C22","v":"Celkové provozní náklady"},null,{"$f":"SUM(E26:E28)","v":1221321232.0133374},924510211.53628778,382882558.67750257,439684115.11237669,429375897.61892569,620821021.22352016,469083877.06484926,521743023.72144705,626188146.16842151,551318883.24406075,536743976.1411019,490719740.0410229,512093510.29845417,603606661.48939502,642746728.05132008]
[]
[]
[null,"3.3.","Přírůstkové celkové provozní náklady (CZK)",null,{"$f":"E2","v":2009},{"$f":"E32+1","v":2010},2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023]
[null,"a",null,"Celkem"]
[null,null,{"$f":"C4","v":"Náklady na údržbu a provoz infrastruktury"},{"$f":"SUM(E34:S34,E41:S41)","v":-2212023591.8827925},{"$f":"E4-E19","v":-84957215.271812856},-80222947.106440246,-49498134.194691867,-107118662.68318003,-113449103.64504185,-74161513.018607438,-77689245.156774521,-81143497.753680289,-80047213.817728102,-78734568.085318655,-69507883.860338956,-66331731.446467251,-66114691.970984131,-67549722.781000823,-71045641.461904466]
[null,null,{"$f":"C5","v":"Periodické provozní náklady / opravy"},{"$f":"SUM(E35:S35,E42:S42)","v":-5858692381.2522488},{"$f":"E5-E20","v":-171832568.93262032},-11104665.946803406,-72140932.379977703,-1106628635.060365,-103947705.01863639,-168072131.01357853,-26814883.43757759,-88063381.412650496,-125076816.48940158,-171183165.83135939,-286821397.52024478,-196790744.09046769,-246906617.47249928,-301420894.24682742,-37235833.399100453]
[null,null,{"$f":"C6","v":"Náklady na řízení provozu"},-1980756681.4835658,{"$f":"E6-E21","v":3451195.236908406},1202845.0255430639,11290408.425479352,-9305861.7776587605,-9764191.0120159686,-10230749.134490982,-6111123.2231977582,-8832026.9900201112,-11546407.895382822,-14885096.408978969,-39187135.896095753,-40166814.293498129,-41170984.650835603,-44774445.04913874,-21588637.241644889]
[null,null,"Přírůstkové celkové provozní náklady",-10051472654.618605,{"$f":"E7-E22","v":-253338588.96752474},-90124768.027700603,-110348658.14919025,-1223053159.5212038,-227160999.67569423,-252464393.16667694,-110615251.81754988,-178038906.15635085,-216670438.2025125,-264802830.32565701,-395516417.27667946,-303289289.83043301,-354192294.09431905,-413745062.07696706,-129870112.10264981]
[]
[null,"3.3.","Přírůstkové celkové provozní náklady (CZK)",null,{"$f":"S32+1","v":2024},{"$f":"E39+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038]
[null,"b",null,null,{"$f":"S33+1","v":1}]
[null,null,{"$f":"C34","v":"Náklady na údržbu a provoz infrastruktury"},null,{"$f":"E11-E26","v":-79121110.655212492},-74803728.101703078,-71641534.243050545,-71310286.145997554,-71692858.116900057,-74938588.357369393,-73156331.344626993,-74705421.655007273,-72511588.947858959,-68776491.798479468,-66434915.214066923,-64641584.289608389,-62786413.095898956,-60591201.342244297,-57339766.320796341]
[null,null,{"$f":"C35","v":"Periodické provozní náklady / opravy"},null,{"$f":"E12-E27","v":-858443544.94624436},-562159416.52191424,-19825221.878019344,-34586116.244249791,-18903857.399713956,-202003760.76634166,-47711429.805543624,-94409994.108729824,-196561991.53033701,-120863956.84032309,-103988372.1404373,-55035324.272404373,-72588270.719788864,-160524567.37681141,-197046184.44928065]
[null,null,{"$f":"C36","v":"Náklady na řízení provozu"},null,{"$f":"E13-E28","v":-69102569.217314899},-70830133.447747797,-72600886.783941463,-112838964.78952579,-115659938.90926394,-118551437.38199551,-120922466.12963541,-123340915.45222814,-125807733.76127271,-128323888.43649815,-130890366.20522811,-133508173.52933267,-136178336.99991935,-138901903.73991773,-141679941.81471607]
[null,null,"Přírůstkové celkové provozní náklady",null,{"$f":"E14-E29","v":-1006667224.8187716},-707793278.071365,-164067642.90501136,-218735367.17977315,-206256654.42587796,-395493786.50570649,-241790227.27980602,-292456331.21596521,-394881314.23946863,-317964337.07530069,-301313653.55973232,-253185082.09134543,-271553020.81560719,-360017672.45897341,-396065892.58479309]
[]
[]
[null,null,"Scénář s projektem (CZK)",{"$f":"D7","v":7267224347.9481134}]
[null,null,"Scénář bez projektu (CZK)",{"$f":"D22","v":17318697002.566719}]
[null,null,"Přírůstkové cash-flow (CZK)",{"$f":"D37","v":-10051472654.618605}]
[]
[]
[null,"3.4.","Náklady na řízení provozu","Celk. náklady","Hrubá mzda"]
[null,null,"CÚ",2012,2012]
[null,null,"Měrné ohodnocení","CZK/rok","CZK/rok"]
[null,13167,"Dozorčí provozu",700935,515444]
[null,31606,"Výpravčí",469759,343235]
[null,31608,"Dozorčí provozu - vedoucí směny",537552,394011]
[null,41333,"Operátor železniční dopravy",335996,243243]
[null,83135,"Signalista",371990,270199]
[null,83137,"Výhybkář",308844,222345]
[null,83141,"Staniční dozorce",352233,254766]
[null,83142,"Dozorce výhybek",328384,237467]
[null,83143,"Závorář",288974,207450]
[null,83144,"Závorář s prodejem jízdenek",312352,225554]
[null,83145,"Hradlář - hláskař",305523,220391]
[null,83146,"Hradlář - hláskař s prodejem jízdenek",300697,216798]
[null,93398,"Dělník v dopravě - staniční dělník",226581,162461]
[]
[null,"3.5.","Růst nákladů na řízení provozu",null,{"$f":"E32","v":2009},{"$f":"F32","v":2010},2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023]
[null,"a",null,"Elasticita"]
[null,null,"Růst reálné mzdy v dopravě",1,0,2.4271844660194174E-2,-1.99004975124381E-3,{"$f":"$D$71*HLOOKUP(H$69,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":-8.0000000000000002E-3},{"$f":"$D$71*HLOOKUP(I$69,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":-1.4999999999999999E-2},{"$f":"$D$71*HLOOKUP(J$69,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":1.9E-2},{"$f":"$D$71*HLOOKUP(K$69,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":2.8000000000000001E-2},{"$f":"$D$71*HLOOKUP(L$69,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":0.03},{"$f":"$D$71*HLOOKUP(M$69,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":2.5000000000000001E-2},{"$f":"$D$71*HLOOKUP(N$69,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":0.03},{"$f":"$D$71*HLOOKUP(O$69,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":0.03},{"$f":"$D$71*HLOOKUP(P$69,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":2.5000000000000001E-2},{"$f":"$D$71*HLOOKUP(Q$69,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":2.5000000000000001E-2},{"$f":"$D$71*HLOOKUP(R$69,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":2.5000000000000001E-2},{"$f":"$D$71*HLOOKUP(S$69,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":2.5000000000000001E-2}]
[null,{"$f":"B55","v":13167},"Dozorčí provozu",null,{"$f":"F72/(1+F$71)","v":712869.35005542298},730172.00418298179,{"$f":"H72/(1+H$71)","v":728718.92556769226},{"$f":"D55*(1+'0 Úvod'!$K$52)*(1+'0 Úvod'!$L$52)*(1+'0 Úvod'!$M$52)*(1+'0 Úvod'!$N$52)","v":722889.17416315072},{"$f":"H72*(1+I$71)","v":712045.83655070351},725574.70744516677,745890.7992536315,768267.52323124046,787474.21131202136,811098.43765138206,835431.39078092354,856317.1755504465,877725.10493920755,899668.23256268771,922159.93837675487]
[null,31606,"Výpravčí",null,{"$f":"F73/(1+F$71)","v":477757.27137706848},489353.32165321091,{"$f":"H73/(1+H$71)","v":488379.48419718456},{"$f":"D56*(1+'0 Úvod'!$K$52)*(1+'0 Úvod'!$L$52)*(1+'0 Úvod'!$M$52)*(1+'0 Úvod'!$N$52)","v":484472.4483236071},{"$f":"H73*(1+I$71)","v":477205.36159875296},486272.26346912922,499887.88684626482,514884.52345165279,527756.63653794408,543589.33563408244,559897.0157031049,573894.44109568244,588241.80212307442,602947.84717615123,618021.54335555492]
[null,31608,"Dozorčí provozu - vedoucí směny",null,{"$f":"F74/(1+F$71)","v":546704.53731229389},559974.06491696124,558859.68866837025,{"$f":"D57*(1+'0 Úvod'!$K$52)*(1+'0 Úvod'!$L$52)*(1+'0 Úvod'!$M$52)*(1+'0 Úvod'!$N$52)","v":554388.81115902332},{"$f":"H74*(1+I$71)","v":546072.97899163794},556448.36559247901,572028.91982906847,589189.78742394049,603919.53210953891,622037.11807282513,640698.23161500995,656715.68740538519,673133.57959051977,689961.91908028268,707210.96705728967]
[null,41333,"Operátor železniční dopravy",null,{"$f":"F75/(1+F$71)","v":341716.77850474289},350010.87507039198,349314.33601552551,{"$f":"D58*(1+'0 Úvod'!$K$52)*(1+'0 Úvod'!$L$52)*(1+'0 Úvod'!$M$52)*(1+'0 Úvod'!$N$52)","v":346519.82132740133},{"$f":"H75*(1+I$71)","v":341322.02400749031},347807.14246363257,357545.7424526143,368272.11472619273,377478.9175943475,388803.28512217791,400467.38367584324,410479.06826773926,420741.04497443273,431259.57109879353,442041.06037626334]
[null,83135,"Signalista",null,{"$f":"F76/(1+F$71)","v":378323.62419784546},387506.23643565725,386735.07974623301,{"$f":"D59*(1+'0 Úvod'!$K$52)*(1+'0 Úvod'!$L$52)*(1+'0 Úvod'!$M$52)*(1+'0 Úvod'!$N$52)","v":383641.19910826313},{"$f":"H76*(1+I$71)","v":377886.58112163917},385066.42616295029,395848.28609551291,407723.73467837833,417916.82804533775,430454.3328866979,443367.96287329885,454452.16194513126,465813.46599375951,477458.80264360347,489395.27270969353]
[null,83137,"Výhybkář",null,{"$f":"F77/(1+F$71)","v":314102.4796143967},321726.32620697911,321086.07481154229,{"$f":"D60*(1+'0 Úvod'!$K$52)*(1+'0 Úvod'!$L$52)*(1+'0 Úvod'!$M$52)*(1+'0 Úvod'!$N$52)","v":318517.38621304993},{"$f":"H77*(1+I$71)","v":313739.62541985419},319700.67830283137,328652.29729531065,338511.86621417,346974.66286952421,357383.90275560995,368105.41983827826,377308.05533423519,386740.75671759102,396409.27563553076,406319.50752641901]
[null,83141,"Staniční dozorce",null,{"$f":"F78/(1+F$71)","v":358230.23501190811},366925.14362870198,366194.94433789857,{"$f":"D61*(1+'0 Úvod'!$K$52)*(1+'0 Úvod'!$L$52)*(1+'0 Úvod'!$M$52)*(1+'0 Úvod'!$N$52)","v":363265.38478319539},{"$f":"H78*(1+I$71)","v":357816.40401144745},364614.91568766494,374824.13332691957,386068.85732672719,395720.57875989535,407592.1961226922,419819.96200637298,430315.46105653228,441073.34758294554,452100.18127251917,463402.68580433208]
[null,83142,"Dozorce výhybek",null,{"$f":"F79/(1+F$71)","v":333975.17408689827},342081.36763269675,341400.60869213415,{"$f":"D62*(1+'0 Úvod'!$K$52)*(1+'0 Úvod'!$L$52)*(1+'0 Úvod'!$M$52)*(1+'0 Úvod'!$N$52)","v":338669.40382259706},{"$f":"H79*(1+I$71)","v":333589.36276525812},339927.56065779802,349445.5323562164,359928.89832690288,368927.12078507541,379994.93440862768,391394.78244088654,401179.65200190869,411209.14330195636,421489.37188450521,432026.60618161783]
[null,83143,"Závorář",null,{"$f":"F80/(1+F$71)","v":293894.16645326},301027.52000795078,300428.4602666414,{"$f":"D63*(1+'0 Úvod'!$K$52)*(1+'0 Úvod'!$L$52)*(1+'0 Úvod'!$M$52)*(1+'0 Úvod'!$N$52)","v":298025.03258450824},{"$f":"H80*(1+I$71)","v":293554.65709574061},299132.19558055967,307507.89705681533,316733.1339685198,324651.46231773274,334391.00618726475,344422.73637288267,353033.30478220474,361859.1374017598,370905.61583680374,380178.25623272383]
[null,83144,"Závorář s prodejem jízdenek",null,{"$f":"F81/(1+F$71)","v":317670.20797721826},325380.64991841285,324733.12623698317,{"$f":"D64*(1+'0 Úvod'!$K$52)*(1+'0 Úvod'!$L$52)*(1+'0 Úvod'!$M$52)*(1+'0 Úvod'!$N$52)","v":322135.26122708729},{"$f":"H81*(1+I$71)","v":317303.23230868101},323331.99372254591,332385.2895467772,342356.84823318053,350915.76943901001,361443.24252218031,372286.5397978457,381593.70329279179,391133.54587511154,400911.88452198927,410934.68163503899]
[null,83145,"Hradlář - hláskař",null,{"$f":"F82/(1+F$71)","v":310724.93517513468},318266.80253375444,317633.43576254294,{"$f":"D65*(1+'0 Úvod'!$K$52)*(1+'0 Úvod'!$L$52)*(1+'0 Úvod'!$M$52)*(1+'0 Úvod'!$N$52)","v":315092.36827644258},{"$f":"H82*(1+I$71)","v":310365.98275229591},316262.93642458948,325118.29864447803,334871.84760381235,343243.6437939076,353540.95310772484,364147.1817009566,373250.86124348047,382582.13277456746,392146.68609393161,401950.35324627988]
[null,83146,"Hradlář - hláskař s prodejem jízdenek",null,{"$f":"F83/(1+F$71)","v":305816.76611043181},313239.50315194717,312616.14095661987,{"$f":"D66*(1+'0 Úvod'!$K$52)*(1+'0 Úvod'!$L$52)*(1+'0 Úvod'!$M$52)*(1+'0 Úvod'!$N$52)","v":310115.21182896692},{"$f":"H83*(1+I$71)","v":305463.48365153238},311267.28984091146,319982.77395645698,329582.25717515068,337821.81360452942,347956.46801266534,358395.16205304529,367355.04110437137,376538.91713198065,385952.39006028016,395601.19981178711]
[null,93398,"Dělník v dopravě - staniční dělník",null,{"$f":"F84/(1+F$71)","v":230438.84269569619},236032.01848928104,235562.30302960085,{"$f":"D67*(1+'0 Úvod'!$K$52)*(1+'0 Úvod'!$L$52)*(1+'0 Úvod'!$M$52)*(1+'0 Úvod'!$N$52)","v":233677.80460536404},{"$f":"H84*(1+I$71)","v":230172.63753628358},234545.91764947295,241113.20334365818,248346.59944396795,254555.26443006712,262191.92236296914,270057.68003385823,276809.12203470466,283729.35008557228,290822.58383771154,298093.14843365428]
[]
[null,{"$f":"B69","v":"3.5."},{"$f":"C69","v":"Růst nákladů na řízení provozu"},null,{"$f":"E39","v":2024},2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038]
[null,"b",null,"Elasticita"]
[null,null,{"$f":"C71","v":"Růst reálné mzdy v dopravě"},{"$f":"D71","v":1},{"$f":"$D$71*HLOOKUP(E$86,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":2.5000000000000001E-2},{"$f":"$D$71*HLOOKUP(F$86,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":2.5000000000000001E-2},{"$f":"$D$71*HLOOKUP(G$86,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":2.5000000000000001E-2},{"$f":"$D$71*HLOOKUP(H$86,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":2.5000000000000001E-2},{"$f":"$D$71*HLOOKUP(I$86,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":2.5000000000000001E-2},{"$f":"$D$71*HLOOKUP(J$86,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":2.5000000000000001E-2},{"$f":"$D$71*HLOOKUP(K$86,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":0.02},{"$f":"$D$71*HLOOKUP(L$86,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":0.02},{"$f":"$D$71*HLOOKUP(M$86,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":0.02},{"$f":"$D$71*HLOOKUP(N$86,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":0.02},{"$f":"$D$71*HLOOKUP(O$86,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":0.02},{"$f":"$D$71*HLOOKUP(P$86,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":0.02},{"$f":"$D$71*HLOOKUP(Q$86,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":0.02},{"$f":"$D$71*HLOOKUP(R$86,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":0.02},{"$f":"$D$71*HLOOKUP(S$86,'0 Úvod'!$D$79:$N$81,2,TRUE)","v":0.02}]
[null,{"$f":"B72","v":13167},"Dozorčí provozu",null,{"$f":"S72*(1+E$88)","v":945213.93683617364},{"$f":"E89*(1+F$88)","v":968844.28525707789},{"$f":"F89*(1+G$88)","v":993065.3923885047},1017892.0271982172,1043339.3278781725,1069422.8110751268,1090811.2672966293,1112627.4926425619,1134880.0424954132,1157577.6433453215,1180729.1962122279,1204343.7801364725,1228430.6557392019,1252999.2688539859,1278059.2542310657]
[null,31606,"Výpravčí",null,{"$f":"S73*(1+E$88)","v":633472.08193944371},{"$f":"E90*(1+F$88)","v":649308.88398792979},{"$f":"F90*(1+G$88)","v":665541.60608762794},682180.14623981854,699234.6498958139,716715.51614320918,731049.8264660734,745670.82299539493,760584.23945530283,775795.92424440884,791311.842729297,807138.07958388294,823280.84117556061,839746.4579990718,856541.38715905324]
[null,31608,"Dozorčí provozu - vedoucí směny",null,724891.24123372184,743013.52226456488,{"$f":"F91*(1+G$88)","v":761588.86032117892},780628.5818292083,800144.29637493845,820147.90378431184,836550.86185999808,853281.87909719802,870347.51667914202,887754.46701272484,905509.55635297939,923619.74748003902,942092.14242963982,960933.98527823261,980152.66498379724]
[null,41333,"Operátor železniční dopravy",null,453092.08688566991,464419.38905781164,{"$f":"F92*(1+G$88)","v":476029.87378425687},487930.62062886322,500128.88614458474,512632.10829819931,522884.75046416331,533342.44547344663,544009.2943829156,554889.48027057387,565987.26987598534,577307.01527350501,588853.1555789751,600630.21869055461,612642.82306436566]
[null,83135,"Signalista",null,501630.15452743584,514170.90839062171,{"$f":"F93*(1+G$88)","v":527025.18110038724},540200.81062789692,553705.83089359431,567548.47666593408,578899.44619925274,590477.43512323778,602286.98382570257,614332.72350221663,626619.37797226093,639151.76553170616,651934.80084234034,664973.49685918714,678272.96679637092]
[null,83137,"Výhybkář",null,416477.49521457945,426889.43259494391,{"$f":"F94*(1+G$88)","v":437561.66840981744},448500.71012006287,459713.2278730644,471206.05856989097,480630.17974128883,490242.7833361146,500047.63900283689,510048.59178289364,520249.56361855153,530654.55489092262,541267.64598874107,552092.9989085159,563134.85888668627]
[null,83141,"Staniční dozorce",null,474987.75294944033,486862.44677317631,{"$f":"F95*(1+G$88)","v":499034.0079425057},511509.85814106831,524297.60459459492,537405.04470945976,548153.14560364897,559116.20851572196,570298.53268603643,581704.50333975721,593338.59340655233,605205.36527468334,617309.47258017701,629655.66203178058,642248.77527241618]
[null,83142,"Dozorce výhybek",null,442827.27133615821,453897.95311956212,{"$f":"F96*(1+G$88)","v":465245.40194755112},476876.53699623985,488798.45042114583,501018.41168167442,511038.77991530794,521259.55551361409,531684.7466238864,542318.44155636418,553164.81038749148,564228.10659524135,575512.66872714623,587022.92210168915,598763.380543723]
[null,83143,"Závorář",null,389682.71263854188,399424.78045450541,{"$f":"F97*(1+G$88)","v":409410.39996586798},419645.65996501467,430136.80146414001,440890.22150074347,449708.02593075833,458702.18644937349,467876.23017836094,477233.75478192815,486778.4298775667,496513.99847511802,506444.27844462037,516573.16401351278,526904.62729378301]
[null,83144,"Závorář s prodejem jízdenek",null,421208.04867591494,431738.24989281275,{"$f":"F98*(1+G$88)","v":442531.70614013303},453594.99879363633,464934.8737634772,476558.24560756411,486089.4105197154,495811.19873010973,505727.42270471191,515841.97115880618,526158.81058198225,536681.98679362191,547415.6265294943,558363.93906008417,569531.21784128586]
[null,83145,"Hradlář - hláskař",null,411999.11207743682,422299.08987937268,{"$f":"F99*(1+G$88)","v":432856.56712635694},443677.98130451585,454769.93083712872,466139.17910805688,475461.962690218,484971.20194402238,494670.62598290283,504564.03850256087,514655.31927261211,524948.42565806431,535447.39417122561,546156.34205465007,557079.46889574314]
[null,83146,"Hradlář - hláskař s prodejem jízdenek",null,405491.22980708175,415628.51055225875,{"$f":"F100*(1+G$88)","v":426019.22331606521},436669.70389896678,447586.44649644091,458776.10765885189,467951.62981202896,477310.66240826953,486856.87565643492,496594.01316956361,506525.89343295491,516656.41130161402,526989.53952764627,537529.33031819924,548279.91692456324]
[null,93398,"Dělník v dopravě - staniční dělník",null,305545.47714449558,313184.11407310795,{"$f":"F101*(1+G$88)","v":321013.71692493564},329039.05984805903,337265.0363442605,345696.66225286701,352610.59549792437,359662.80740788288,366856.06355604052,374193.18482716131,381677.04852370452,389310.5894941786,397096.80128406215,405038.73730974342,413139.51205593831]
[]
[]
[null,"3.6.","Počty zaměstnanců",null,{"$f":"E69","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023]
[null,"a","Scénář s projektem"]
[null,{"$f":"B89","v":13167},"Dozorčí provozu"]
[null,31606,"Výpravčí",null,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,72.98,72.98,72.98,72.98,72.98]
[null,31608,"Dozorčí provozu - vedoucí směny"]
[null,41333,"Operátor železniční dopravy"]
[null,83135,"Signalista",null,105.95,105.95,105.95,105.95,105.95,105.95,105.95,105.95,105.95,105.95,42.550000000000004,42.550000000000004,42.550000000000004,42.550000000000004,42.550000000000004]
[null,83137,"Výhybkář"]
[null,83141,"Staniční dozorce",null,null,null,null,null,null,null,null,null,null,null,14.05,14.05,14.05,14.05,14.05]
[null,83142,"Dozorce výhybek"]
[null,83143,"Závorář"]
[null,83144,"Závorář s prodejem jízdenek"]
[null,83145,"Hradlář - hláskař",null,36.4,36.4,36.4,36.4,36.4,36.4,36.4,36.4,36.4,36.4,36.4,36.4,36.4,36.4,36.4]
[null,83146,"Hradlář - hláskař s prodejem jízdenek"]
[null,93398,"Dělník v dopravě - staniční dělník"]
[null,null,"Celkem",null,{"$f":"SUM(E106:E118)","v":245.65},245.65,245.65,245.65,245.65,245.65,245.65,245.65,245.65,245.65,165.98000000000002,165.98000000000002,165.98000000000002,165.98000000000002,165.98000000000002]
[null,null,"Odstupné",null,{"$f":"SUMPRODUCT($E$55:$E$67*(E$72/$D$55)/4,E106:E118-F106:F118)","v":0},{"$f":"SUMPRODUCT($E$55:$E$67*(F$72/$D$55)/4,F106:F118-G106:G118)","v":0},0,0,0,0,0,0,0,6930859.640209185,{"$f":"SUMPRODUCT($E$55:$E$67*(O$72/$D$55)/4,O106:O118-P106:P118)","v":0},0,0,0,{"$f":"SUMPRODUCT($E$55:$E$67*(S$72/$D$55)/4,S106:S118-E124:E136)","v":7035635.6489746589}]
[]
[null,{"$f":"B104","v":"3.6."},{"$f":"C104","v":"Počty zaměstnanců"},null,{"$f":"E86","v":2024},2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038]
[null,"b","Scénář s projektem"]
[null,{"$f":"B106","v":13167},"Dozorčí provozu"]
[null,31606,"Výpravčí",null,62.360000000000014,62.360000000000014,62.360000000000014,62.360000000000014,62.360000000000014,62.360000000000014,62.360000000000014,62.360000000000014,62.360000000000014,62.360000000000014,62.360000000000014,62.360000000000014,62.360000000000014,62.360000000000014,62.360000000000014]
[null,31608,"Dozorčí provozu - vedoucí směny"]
[null,41333,"Operátor železniční dopravy"]
[null,83135,"Signalista"]
[null,83137,"Výhybkář"]
[null,83141,"Staniční dozorce",null,21.01,21.01,21.01,21.01,21.01,21.01,21.01,21.01,21.01,21.01,21.01,21.01,21.01,21.01,21.01]
[null,83142,"Dozorce výhybek"]
[null,83143,"Závorář"]
[null,83144,"Závorář s prodejem jízdenek"]
[null,83145,"Hradlář - hláskař"]
[null,83146,"Hradlář - hláskař s prodejem jízdenek"]
[null,93398,"Dělník v dopravě - staniční dělník"]
[null,null,"Celkem",null,{"$f":"SUM(E124:E136)","v":83.370000000000019},{"$f":"SUM(F124:F136)","v":83.370000000000019},83.370000000000019,83.370000000000019,83.370000000000019,83.370000000000019,83.370000000000019,83.370000000000019,83.370000000000019,83.370000000000019,83.370000000000019,83.370000000000019,83.370000000000019,83.370000000000019,83.370000000000019]
[null,null,"Odstupné",null,{"$f":"SUMPRODUCT($E$55:$E$67*(E$89/$D$55)/4,E124:E136-F124:F136)","v":0},{"$f":"SUMPRODUCT($E$55:$E$67*(F$89/$D$55)/4,F124:F136-G124:G136)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"3.7.",{"$f":"C122","v":"Počty zaměstnanců"},null,{"$f":"E104","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023]
[null,"a","Scénář bez projektu"]
[null,{"$f":"B124","v":13167},"Dozorčí provozu"]
[null,31606,"Výpravčí",null,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001]
[null,31608,"Dozorčí provozu - vedoucí směny"]
[null,41333,"Operátor železniční dopravy"]
[null,83135,"Signalista",null,105.95,105.95,105.95,105.95,105.95,105.95,105.95,105.95,105.95,105.95,105.95,105.95,105.95,105.95,105.95]
[null,83137,"Výhybkář"]
[null,83141,"Staniční dozorce"]
[null,83142,"Dozorce výhybek"]
[null,83143,"Závorář"]
[null,83144,"Závorář s prodejem jízdenek"]
[null,83145,"Hradlář - hláskař",null,36.4,36.4,36.4,36.4,36.4,36.4,36.4,36.4,36.4,36.4,36.4,36.4,36.4,36.4,0]
[null,83146,"Hradlář - hláskař s prodejem jízdenek"]
[null,93398,"Dělník v dopravě - staniční dělník"]
[null,null,"Celkem",null,{"$f":"SUM(E142:E154)","v":245.65},{"$f":"SUM(F142:F154)","v":245.65},245.65,245.65,245.65,245.65,245.65,245.65,245.65,245.65,245.65,245.65,245.65,245.65,209.25]
[null,null,"Odstupné",null,{"$f":"SUMPRODUCT($E$55:$E$67*(E$72/$D$55)/4,E142:E154-F142:F154)","v":0},{"$f":"SUMPRODUCT($E$55:$E$67*(F$72/$D$55)/4,F142:F154-G142:G154)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT($E$55:$E$67*(O$72/$D$55)/4,O142:O154-P142:P154)","v":0},0,0,2574185.7820322597,{"$f":"SUMPRODUCT($E$55:$E$67*(S$72/$D$55)/4,S142:S154-E160:E172)","v":0}]
[]
[null,{"$f":"B140","v":"3.7."},{"$f":"C122","v":"Počty zaměstnanců"},null,{"$f":"E122","v":2024},2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038]
[null,"b","Scénář bez projektu",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,{"$f":"B142","v":13167},"Dozorčí provozu"]
[null,31606,"Výpravčí",null,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001,103.30000000000001]
[null,31608,"Dozorčí provozu - vedoucí směny"]
[null,41333,"Operátor železniční dopravy"]
[null,83135,"Signalista",null,105.95,105.95,105.95,105.95,105.95,105.95,105.95,105.95,105.95,105.95,105.95,105.95,105.95,105.95,105.95]
[null,83137,"Výhybkář",null,null,null,null,85.67,85.67,85.67,85.67,85.67,85.67,85.67,85.67,85.67,85.67,85.67,85.67]
[null,83141,"Staniční dozorce"]
[null,83142,"Dozorce výhybek"]
[null,83143,"Závorář"]
[null,83144,"Závorář s prodejem jízdenek"]
[null,83145,"Hradlář - hláskař",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,83146,"Hradlář - hláskař s prodejem jízdenek"]
[null,93398,"Dělník v dopravě - staniční dělník"]
[null,null,"Celkem",null,{"$f":"SUM(E160:E172)","v":209.25},{"$f":"SUM(F160:F172)","v":209.25},209.25,294.92,294.92,294.92,294.92,294.92,294.92,294.92,294.92,294.92,294.92,294.92,294.92]
[null,null,"Odstupné",null,{"$f":"SUMPRODUCT($E$55:$E$67*(E$89/$D$55)/4,E160:E172-F160:F172)","v":0},{"$f":"SUMPRODUCT($E$55:$E$67*(F$89/$D$55)/4,F160:F172-G160:G172)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Komentáře"]
[]
[null,"V tabulkách 3.1 a 3.2 zpracovatel přímo dopočítává a vyplňuje pouze provozní náklady na údržbu a opravy infrastruktury."]
[null,"Pro vyčíslení provozních nákladů na řízení dopravy se využije přednastavených vzorců v tabulkách 3.1, 3.2 a 3.5. Zpracovatel vyplňuje pouze tabulky 3.6 a 3.7 a ověřuje správnost výpočtu odstupného."]

{"sheet":"4 Tržby","index":4,"n_rows":133,"n_cols":19,"rows_kept":133,"cut":false,"hidden":false,"merged":[[91,8,92,8],[91,10,92,10],[91,16,92,16],[91,17,92,17],[91,18,92,18],[123,1,124,15],[107,15,108,15],[107,4,108,4],[107,5,108,5],[107,6,108,6],[107,7,108,7],[107,13,108,13],[107,14,108,14],[91,9,92,9],[91,13,92,13],[107,12,108,12],[91,4,92,4],[91,5,92,5],[91,6,92,6],[91,7,92,7],[107,8,108,8],[107,9,108,9],[107,10,108,10],[74,13,75,13],[58,15,59,15],[58,16,59,16],[58,12,59,12],[74,11,75,11],[74,12,75,12],[58,14,59,14],[107,16,108,16],[107,18,108,18],[107,11,108,11],[91,14,92,14],[91,15,92,15],[91,11,92,11],[91,12,92,12],[74,14,75,14],[74,15,75,15],[74,4,75,4],[74,5,75,5],[74,6,75,6],[74,7,75,7],[74,8,75,8],[58,9,59,9],[58,8,59,8],[58,10,59,10],[58,11,59,11],[74,9,75,9],[74,10,75,10],[38,10,39,10],[31,13,32,13],[31,12,32,12],[31,8,32,8],[31,9,32,9],[38,9,39,9],[31,10,32,10],[31,11,32,11],[58,13,59,13],[51,7,51,9],[38,4,39,4],[38,5,39,5],[38,6,39,6],[38,7,39,7],[38,8,39,8],[58,4,59,4],[58,5,59,5],[58,6,59,6],[58,7,59,7],[51,4,51,6],[31,15,32,15],[31,16,32,16],[31,14,32,14],[38,17,39,17],[38,18,39,18],[38,11,39,11],[38,12,39,12],[38,13,39,13],[38,14,39,14],[38,15,39,15],[38,16,39,16],[31,4,32,4],[31,5,32,5],[31,6,32,6],[31,7,32,7],[23,4,24,4],[23,5,24,5],[16,18,17,18],[23,16,24,16],[23,17,24,17],[23,18,24,18],[23,12,24,12],[16,16,17,16],[23,14,24,14],[16,17,17,17],[16,14,17,14],[23,9,24,9],[23,6,24,6],[23,7,24,7],[23,10,24,10],[23,11,24,11],[23,8,24,8],[31,18,32,18],[23,13,24,13],[23,15,24,15],[16,4,17,4],[16,5,17,5],[16,6,17,6],[16,7,17,7],[8,11,9,11],[8,12,9,12],[16,15,17,15],[16,11,17,11],[16,8,17,8],[16,9,17,9],[16,12,17,12],[16,13,17,13],[16,10,17,10],[8,15,9,15],[8,4,9,4],[8,5,9,5],[8,6,9,6],[8,7,9,7],[1,15,2,15],[8,17,9,17],[8,14,9,14],[8,8,9,8],[8,9,9,9],[1,12,2,12],[1,13,2,13],[8,10,9,10],[8,13,9,13],[1,10,2,10],[1,11,2,11],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,14,2,14],[58,28,59,28],[74,19,75,19],[74,20,75,20],[74,21,75,21],[74,22,75,22],[74,23,75,23],[74,24,75,24],[74,25,75,25],[74,26,75,26],[58,19,59,19],[58,20,59,20],[58,21,59,21],[58,22,59,22],[58,23,59,23],[58,24,59,24],[58,25,59,25],[58,26,59,26],[58,27,59,27],[8,18,9,18],[1,18,2,18],[8,16,9,16],[1,16,2,16],[1,17,2,17],[107,19,108,19],[107,20,108,20],[107,21,108,21],[107,22,108,22],[74,27,75,27],[31,17,32,17],[74,16,75,16],[58,18,59,18],[74,17,75,17],[107,17,108,17],[74,18,75,18],[58,17,59,17],[74,28,75,28],[91,19,92,19],[91,20,92,20],[91,21,92,21],[91,22,92,22],[91,23,92,23],[91,24,92,24],[107,27,108,27],[107,28,108,28],[91,25,92,25],[91,26,92,26],[91,27,92,27],[91,28,92,28],[107,23,108,23],[107,24,108,24],[107,25,108,25],[107,26,108,26]]}
[]
[null,"4.1.","Celkové provozní příjmy (CZK)",null,{"$f":"'0 Úvod'!G19","v":2009},{"$f":"E2+1","v":2010},2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023]
[null,"a","Scénář s projektem","Celkem"]
[null,null,"Příjmy z poplatků za dopravní cestu - osobní doprava",{"$f":"SUM(E4:S4,E11:S11)","v":3106277986.4671259},45137387.141399994,43176209.536579996,55974439.326897293,56049586.623214647,62460681.232341997,72688782.419303,72617481.452301994,{"$f":"L61*$E$54+L62*$F$54+L63*$G$54+(L64*$E$55+L65*$F$55+L66*$G$55)/1000","v":87958955.536191925},90232654.408769459,90232654.408769459,95483984.809433401,95483984.809433401,95483984.809433401,95483984.809433401,95483984.809433401]
[null,null,"Příjmy z poplatků za dopravní cestu - nákladní doprava",{"$f":"SUM(E5:S5,E12:S12)","v":1819199990.2007511},47777455.647499993,48719871.06476,47357681.280762717,36401624.183648571,42023133.415534005,35836044.850239001,32357796.229984999,{"$f":"$H$54*L67+$I$54*L68+$J$54*L69+($H$55*L70+$I$55*L71+$J$55*L72)/1000","v":61520894.627901301},62490466.728396267,63460038.828891233,60995395.461455882,61908597.882718101,62821800.303980336,63735002.72524257,64648205.146504775]
[null,null,"Ostatní příjmy",{"$f":"SUM(E6:S6,E13:S13)","v":0}]
[null,null,"Celkové provozní příjmy (CZK)",{"$f":"SUM(E7:S7,E14:S14)","v":4925477976.6678762},{"$f":"SUM(E4:E6)","v":92914842.788899988},{"$f":"SUM(F4:F6)","v":91896080.601339996},103332120.60766001,{"$f":"SUM(H4:H6)","v":92451210.806863219},104483814.64787599,108524827.26954201,104975277.68228699,149479850.16409323,152723121.13716573,153692693.23766071,156479380.27088928,157392582.69215149,158305785.11341375,159218987.53467596,160132189.95593816]
[]
[null,"4.1.","Celkové provozní příjmy (CZK)",null,{"$f":"S2+1","v":2024},{"$f":"E9+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038]
[null,"b","Scénář s projektem"]
[null,null,"Příjmy z poplatků za dopravní cestu - osobní doprava",null,{"$f":"E77*$E$54+E78*$F$54+E79*$G$54+(E80*$E$55+E81*$F$55+E82*$G$55)/1000","v":130155282.02227923},{"$f":"F77*$E$54+F78*$F$54+F79*$G$54+(F80*$E$55+F81*$F$55+F82*$G$55)/1000","v":130155282.02227923},130155282.02227923,130155282.02227923,130155282.02227923,130155282.02227923,130155282.02227923,130155282.02227923,130155282.02227923,130155282.02227923,130155282.02227923,130155282.02227923,130155282.02227923,130155282.02227923,130155282.02227923]
[null,null,"Příjmy z poplatků za dopravní cestu - nákladní doprava",null,{"$f":"$H$54*E83+$I$54*E84+$J$54*E85+($H$55*E86+$I$55*E87+$J$55*E88)/1000","v":65561407.567766987},{"$f":"$H$54*F83+$I$54*F84+$J$54*F85+($H$55*F86+$I$55*F87+$J$55*F88)/1000","v":65977834.884973899},66394262.20218081,66810689.519387722,67227116.836594656,67643544.15380159,68059971.471008494,68476398.788215414,68892826.105422333,69309253.422629252,69725680.739836186,70142108.05704309,70558535.374250025,70974962.691456914,71391390.008663848]
[null,null,"Ostatní příjmy"]
[null,null,"Celkové provozní příjmy (CZK)",null,{"$f":"SUM(E11:E13)","v":195716689.59004623},196133116.90725315,196549544.22446004,196965971.54166695,197382398.8588739,197798826.17608082,198215253.49328774,198631680.81049466,199048108.12770158,199464535.4449085,199880962.76211542,200297390.07932234,200713817.39652926,201130244.71373615,201546672.0309431]
[]
[]
[null,"4.2.","Celkové provozní příjmy (CZK)",null,{"$f":"E2","v":2009},{"$f":"E17+1","v":2010},2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023]
[null,"a","Scénář bez projektu","Celkem"]
[null,null,"Příjmy z poplatků za dopravní cestu - osobní doprava",{"$f":"SUM(E19:S19,E26:S26)","v":2651107976.2216759},{"$f":"E94*$E$54+E95*$F$54+E96*$G$54+(E97*$E$55+E98*$F$55+E99*$G$55)/1000","v":90460730.706183702},{"$f":"F94*$E$54+F95*$F$54+F96*$G$54+(F97*$E$55+F98*$F$55+F99*$G$55)/1000","v":88253290.04520461},87197869.564217165,85687081.925684154,85687081.925684154,87703741.826462388,87901353.740494519,88362448.206569478,95814655.906863868,95814655.906863868,95814655.906863868,95814655.906863868,95814655.906863868,95814655.906863868,95814655.906863868]
[null,null,"Příjmy z poplatků za dopravní cestu - nákladní doprava",{"$f":"SUM(E20:S20,E27:S27)","v":1785372755.1753478},{"$f":"$H$54*E100+$I$54*E101+$J$54*E102+($H$55*E103+$I$55*E104+$J$55*E105)/1000","v":60937026.629393004},{"$f":"$H$54*F100+$I$54*F101+$J$54*F102+($H$55*F103+$I$55*F104+$J$55*F105)/1000","v":60937026.629393004},60937026.629393004,60937026.629393004,60937026.629393004,60937026.629393004,60937026.629393004,61450628.283181995,61964229.936970949,62477831.590759918,62991433.244548872,63505034.898337841,64018636.552126795,64532238.205915757,65045839.859704725]
[null,null,"Ostatní příjmy",{"$f":"SUM(E21:S21,E28:S28)","v":0}]
[null,null,"Celkové provozní příjmy (CZK)",{"$f":"SUM(E22:S22,E29:S29)","v":4436480731.3970232},{"$f":"SUM(E19:E21)","v":151397757.33557671},149190316.67459762,148134896.19361016,146624108.55507717,146624108.55507717,148640768.4558554,148838380.36988753,149813076.48975146,157778885.84383482,158292487.4976238,158806089.15141273,159319690.80520171,159833292.45899066,160346894.11277962,160860495.7665686]
[]
[null,"4.2.","Celkové provozní příjmy (CZK)",null,{"$f":"S17+1","v":2024},{"$f":"E24+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038]
[null,"b","Scénář bez projektu"]
[null,null,"Příjmy z poplatků za dopravní cestu - osobní doprava",null,{"$f":"E110*$E$54+E111*$F$54+E112*$G$54+(E113*$E$55+E114*$F$55+E115*$G$55)/1000","v":86823313.818401992},{"$f":"F110*$E$54+F111*$F$54+F112*$G$54+(F113*$E$55+F114*$F$55+F115*$G$55)/1000","v":86823313.818401992},86823313.818401992,84890153.78982681,84890153.78982681,84890153.78982681,84890153.78982681,84890153.78982681,84890153.78982681,84890153.78982681,84890153.78982681,84890153.78982681,84890153.78982681,84890153.78982681,84890153.78982681]
[null,null,"Příjmy z poplatků za dopravní cestu - nákladní doprava",null,{"$f":"$H$54*E116+$I$54*E117+$J$54*E118+($H$55*E119+$I$55*E120+$J$55*E121)/1000","v":56036163.717066795},{"$f":"$H$54*F116+$I$54*F117+$J$54*F118+($H$55*F119+$I$55*F120+$J$55*F121)/1000","v":56153166.006991059},56270168.29691533,56387170.586839601,56504172.87676388,56621175.166688144,56738177.456612416,56855179.746536687,56972182.036460966,57089184.32638523,57206186.616309494,57323188.906233773,57440191.196158051,57557193.486082301,57674195.776006579]
[null,null,"Ostatní příjmy"]
[null,null,"Celkové provozní příjmy (CZK)",null,{"$f":"SUM(E26:E28)","v":142859477.53546879},142976479.82539305,143093482.11531731,141277324.37666643,141394326.66659069,141511328.95651495,141628331.24643922,141745333.53636348,141862335.82628778,141979338.11621204,142096340.4061363,142213342.6960606,142330344.98598486,142447347.27590913,142564349.56583339]
[]
[]
[null,"4.3.","Celkové přírůstkové provozní příjmy (CZK)",null,{"$f":"E2","v":2009},{"$f":"E32+1","v":2010},2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023]
[null,"a","Přírůstek cash-flow","Celkem"]
[null,null,"Příjmy z poplatků za dopravní cestu - osobní doprava",{"$f":"SUM(E34:S34,E41:S41)","v":455170010.24545026},{"$f":"E4-E19","v":-45323343.564783707},{"$f":"F4-F19","v":-45077080.508624613},-31223430.237319872,-29637495.302469507,-23226400.693342157,-15014959.407159388,-15283872.288192526,-403492.67037755251,-5582001.4980944097,-5582001.4980944097,-330671.09743046761,-330671.09743046761,-330671.09743046761,-330671.09743046761,-330671.09743046761]
[null,null,"Příjmy z poplatků za dopravní cestu - nákladní doprava",{"$f":"SUM(E35:S35,E42:S42)","v":33827235.025402784},{"$f":"E5-E20","v":-13159570.98189301},{"$f":"F5-F20","v":-12217155.564633004},-13579345.348630287,-24535402.445744433,-18913893.213858999,-25100981.779154003,-28579230.399408005,70266.344719305634,526236.79142531753,982207.23813131452,-1996037.7830929905,-1596437.0156197399,-1196836.2481464595,-797235.48067318648,-397634.71319995075]
[null,null,"Ostatní příjmy",{"$f":"SUM(E36:S36,E43:S43)","v":0},{"$f":"E6-E21","v":0},{"$f":"F6-F21","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Celkové přírůstkové provozní příjmy (CZK)",{"$f":"SUM(E37:S37,E44:S44)","v":488997245.27085304},{"$f":"E7-E22","v":-58482914.546676725},{"$f":"F7-F22","v":-57294236.073257625},-44802775.585950151,-54172897.748213947,-42140293.907201171,-40115941.186313391,-43863102.687600538,-333226.32565823197,-5055764.7066690922,-4599794.2599630952,-2326708.8805234432,-1927108.1130502224,-1527507.3455769122,-1127906.5781036615,-728305.81063044071]
[]
[null,"4.3.","Celkové přírůstkové provozní příjmy (CZK)",null,{"$f":"S32+1","v":2024},{"$f":"E39+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038]
[null,"b","Přírůstek cash-flow"]
[null,null,"Příjmy z poplatků za dopravní cestu - osobní doprava",null,{"$f":"E11-E26","v":43331968.20387724},43331968.20387724,43331968.20387724,45265128.232452422,45265128.232452422,45265128.232452422,45265128.232452422,45265128.232452422,45265128.232452422,45265128.232452422,45265128.232452422,45265128.232452422,45265128.232452422,45265128.232452422,{"$f":"S11-S26","v":45265128.232452422}]
[null,null,"Příjmy z poplatků za dopravní cestu - nákladní doprava",null,9525243.8507001922,9824668.8779828399,10124093.90526548,10423518.932548121,10722943.959830776,11022368.987113446,11321794.014396079,11621219.041678727,11920644.068961367,12220069.096244022,12519494.123526692,12818919.150809318,13118344.178091973,13417769.205374613,13717194.232657269]
[null,null,"Ostatní příjmy",null,{"$f":"E13-E28","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"S13-S28","v":0}]
[null,null,"Celkové přírůstkové provozní příjmy (CZK)",null,{"$f":"E14-E29","v":52857212.05457744},53156637.081860095,53456062.109142721,55688647.165000528,55988072.192283213,56287497.219565868,56586922.246848524,56886347.274131179,57185772.301413804,57485197.32869646,57784622.355979115,58084047.38326174,58383472.410544395,58682897.437827021,{"$f":"S14-S29","v":58982322.465109706}]
[]
[]
[null,null,"Scénář s projektem (CZK)",{"$f":"D7","v":4925477976.6678762}]
[null,null,"Scénář bez projektu (CZK)",{"$f":"D22","v":4436480731.3970232}]
[null,null,"Přírůstek cash-flow (CZK)",{"$f":"D37","v":488997245.27085304}]
[]
[]
[null,null,null,null,"Osobní",null,null,"Nákladní"]
[null,"4.4.","Příjmy z poplatků za dopravní cestu",null,"TEN-T","celostátní","regionální","TEN-T","celostátní","regionální"]
[null,null,"Poplatek za provozování dopravní cesty ","Kč/vlkm",7.81,6.49,5.5,36.1,35.33,33.19]
[null,null,"Poplatek za zajištění provozuschopnosti DC","Kč/1000 hrtkm",44.77,35.590000000000003,30.16,49.23,43.88,33.6]
[null,null,"Zdroj: „Prohlášení o dráze celostátní a regionální platné pro jízdní řád 2016 a 2017“ (příloha C, část C)"]
[]
[]
[null,"4.5.","Celkové výkony",null,{"$f":"E2","v":2009},{"$f":"E59+1","v":2010},2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023]
[null,"a","Scénář s projektem","Celkem"]
[null,"S1E","vlkm - osobní doprava - dráhy TEN-T",{"$f":"SUM(E61:S61,E77:S77)","v":144239933.5},3945321.5,3861700,3836807,3781181,3781181,3842501,3835712,3859218,3937401,3937401,4238307,4238307,4238307,4238307,4238307]
[null,"S1C","vlkm - osobní doprava - celostátní",{"$f":"SUM(E62:S62,E78:S78)","v":0}]
[null,"S1R","vlkm - osobní doprava - regionální",0]
[null,"S2E","hrtkm - osobní doprava - dráhy TEN-T",48785954772.473518,1332315608.4695935,1297596896.2520573,1278365130.5386901,1254323393.2473564,1254323393.2473564,1288671186.4298053,1285256876.2590342,1291455504.9406281,1328602917.1045222,1328602917.1045222,1393406458.3299842,1393406458.3299842,1393406458.3299842,1393406458.3299842,1393406458.3299842]
[null,"S2C","hrtkm - osobní doprava - celostátní",0]
[null,"S2R","hrtkm - osobní doprava - regionální",0]
[null,"S1E","vlkm - nákladní doprava - dráhy TEN-T",22672715.729993388,706740.99801587302,706740.99801587302,706740.99801587302,706740.99801587302,706740.99801587302,706740.99801587302,702267.64384920627,713512.63547178137,724757.62709435634,736002.61871693132,707417.95337301609,718009.17559523834,728600.39781746059,739191.62003968284,749782.84226190497]
[null,"S1C","vlkm - nákladní doprava - celostátní",0]
[null,"S1R","vlkm - nákladní doprava - regionální",0]
[null,"S2E","hrtkm - nákladní doprava - dráhy TEN-T",23083786877.499996,719554673.99999988,719554673.99999988,719554673.99999988,719554673.99999988,719554673.99999988,719554673.99999988,715000214.99999988,726449085.66666663,737897956.33333337,749346827.00000012,720243903.00000012,731027151.00000012,741810399.00000012,752593647.00000024,763376895.00000012]
[null,"S2C","hrtkm - nákladní doprava - celostátní",0]
[null,"S2R","hrtkm - nákladní doprava - regionální",0]
[]
[]
[null,{"$f":"B59","v":"4.5."},{"$f":"C59","v":"Celkové výkony"},null,{"$f":"S59+1","v":2024},{"$f":"E75+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038]
[null,"b","Scénář s projektem"]
[null,{"$f":"B61","v":"S1E"},"vlkm - osobní doprava - dráhy TEN-T",null,5628665,5628665,5628665,5628665,5628665,5628665,5628665,5628665,5628665,5628665,5628665,5628665,5628665,5628665,5628665]
[null,"S1C","vlkm - osobní doprava - celostátní"]
[null,"S1R","vlkm - osobní doprava - regionální"]
[null,"S2E","hrtkm - osobní doprava - dráhy TEN-T",null,1925293910.4820018,1925293910.4820018,1925293910.4820018,1925293910.4820018,1925293910.4820018,1925293910.4820018,1925293910.4820018,1925293910.4820018,1925293910.4820018,1925293910.4820018,1925293910.4820018,1925293910.4820018,1925293910.4820018,1925293910.4820018,1925293910.4820018]
[null,"S2C","hrtkm - osobní doprava - celostátní"]
[null,"S2R","hrtkm - osobní doprava - regionální"]
[null,"S1E","vlkm - nákladní doprava - dráhy TEN-T",null,760374.0644841271,765203.74315476185,770033.42182539671,774863.10049603158,779692.77916666656,784522.45783730154,789352.1365079364,794181.81517857139,799011.49384920625,803841.17251984123,808670.85119047621,813500.52986111096,818330.20853174606,823159.88720238069,827989.56587301567]
[null,"S1C","vlkm - nákladní doprava - celostátní"]
[null,"S1R","vlkm - nákladní doprava - regionální"]
[null,"S2E","hrtkm - nákladní doprava - dráhy TEN-T",null,774160143,779077386.89999986,783994630.79999983,788911874.69999981,793829118.59999979,798746362.5,803663606.39999986,808580850.29999983,813498094.19999981,818415338.09999979,823332582,828249825.89999974,833167069.79999995,838084313.69999957,843001557.59999967]
[null,"S2C","hrtkm - nákladní doprava - celostátní"]
[null,"S2R","hrtkm - nákladní doprava - regionální"]
[]
[]
[]
[null,"4.6.","Celkové výkony",null,{"$f":"E59","v":2009},{"$f":"E92+1","v":2010},2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023]
[null,"a","Scénář bez projektu","Celkem"]
[null,{"$f":"B77","v":"S1E"},"vlkm - osobní doprava - dráhy TEN-T",{"$f":"SUM(E94:S94,E110:S110)","v":113972162.5},3945321.5,3861700,3836807,3781181,3781181,3842501,3852575,3876081,4147860,4147860,4147860,4147860,4147860,4147860,4147860]
[null,"S1C","vlkm - osobní doprava - celostátní",{"$f":"SUM(E95:S95,E111:S111)","v":0}]
[null,"S1R","vlkm - osobní doprava - regionální",0]
[null,"S2E","hrtkm - osobní doprava - dráhy TEN-T",39334049298.563194,1332315608.4695935,1297596896.2520573,1278365130.5386901,1254323393.2473564,1254323393.2473564,1288671186.4298053,1291327741.5790598,1297526370.260654,1416570679.1794477,1416570679.1794477,1416570679.1794477,1416570679.1794477,1416570679.1794477,1416570679.1794477,1416570679.1794477]
[null,"S2C","hrtkm - osobní doprava - celostátní",0]
[null,"S2R","hrtkm - osobní doprava - regionální",0]
[null,"S1E","vlkm - nákladní doprava - dráhy TEN-T",20706558.764295638,706740.99801587302,706740.99801587302,706740.99801587302,706740.99801587302,706740.99801587302,706740.99801587302,706740.99801587302,712697.69405864226,718654.39010141115,724611.08614418015,730567.78218694916,736524.47822971817,742481.17427248717,748437.87031525618,754394.5663580253]
[null,"S1C","vlkm - nákladní doprava - celostátní",0]
[null,"S1R","vlkm - nákladní doprava - regionální",0]
[null,"S2E","hrtkm - nákladní doprava - dráhy TEN-T",21081982201.590004,719554673.99999988,719554673.99999988,719554673.99999988,719554673.99999988,719554673.99999988,719554673.99999988,719554673.99999988,725619368.83333361,731684063.66666675,737748758.50000024,743813453.33333349,749878148.16666687,755942843.00000024,762007537.83333361,768072232.6666671]
[null,"S2C","hrtkm - nákladní doprava - celostátní",0]
[null,"S2R","hrtkm - nákladní doprava - regionální",0]
[]
[]
[null,{"$f":"B92","v":"4.6."},{"$f":"C92","v":"Celkové výkony"},null,{"$f":"S92+1","v":2024},{"$f":"E108+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038]
[null,"b","Scénář bez projektu"]
[null,{"$f":"B94","v":"S1E"},"vlkm - osobní doprava - dráhy TEN-T",null,3689493,3689493,3689493,3590943,3590943,3590943,3590943,3590943,3590943,3590943,3590943,3590943,3590943,3590943,3590943]
[null,"S1C","vlkm - osobní doprava - celostátní"]
[null,"S1R","vlkm - osobní doprava - regionální"]
[null,"S2E","hrtkm - osobní doprava - dráhy TEN-T",null,1295697419.8883624,1295697419.8883624,1295697419.8883624,1269709380.3847845,1269709380.3847845,1269709380.3847845,1269709380.3847845,1269709380.3847845,1269709380.3847845,1269709380.3847845,1269709380.3847845,1269709380.3847845,1269709380.3847845,1269709380.3847845,1269709380.3847845]
[null,"S2C","hrtkm - osobní doprava - celostátní"]
[null,"S2R","hrtkm - osobní doprava - regionální"]
[null,"S1E","vlkm - nákladní doprava - dráhy TEN-T",null,649901.32372619049,651258.3035416666,652615.28335714282,653972.26317261904,655329.24298809539,656686.22280357149,658043.2026190476,659400.18243452371,660757.16225000005,662114.14206547616,663471.12188095227,664828.10169642861,666185.08151190483,667542.06132738083,668899.04114285717]
[null,"S1C","vlkm - nákladní doprava - celostátní"]
[null,"S1R","vlkm - nákladní doprava - regionální"]
[null,"S2E","hrtkm - nákladní doprava - dráhy TEN-T",null,661684459.28399992,663066042.02999997,664447624.7759999,665829207.52199996,667210790.26800001,668592373.01399994,669973955.75999999,671355538.50599992,672737121.25199997,674118703.99800003,675500286.74399996,676881869.49000001,678263452.23600006,679645034.98199975,681026617.72800004]
[null,"S2C","hrtkm - nákladní doprava - celostátní"]
[null,"S2R","hrtkm - nákladní doprava - regionální"]
[]
[]
[null,"Komentáře"]
[]
[null,"Zpracovatel uvede konkrétní hodnoty výstupů z dopravního prognózování použité při výpočtu příjmů z poplatku za dopravní cestu. Tabulky 4.5. a 4.6. je možné přizpůsobit konkrétnímu projektu."]
[]
[]
[null,null,"Průměrná hrubá hmotnost vlaků:"]
[null,null,"osobní příměstská",263.70410455177898,"hrt/vlak"]
[null,null,"osobní dálková",422.6104651162791,"hrt/vlak"]
[null,null,"nákladní místní",361.79999999999995,"hrt/vlak"]
[null,null,"nákladní dálková",1125.5999999999999,"hrt/vlak"]

{"sheet":"5 Finanční analýza (FRR_C)","index":5,"n_rows":28,"n_cols":19,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[13,4,14,4],[13,5,14,5],[13,6,14,6],[13,7,14,7],[27,1,27,3],[25,1,25,3],[26,1,26,3],[13,18,14,18],[13,9,14,9],[13,10,14,10],[13,16,14,16],[13,17,14,17],[13,13,14,13],[13,14,14,14],[13,15,14,15],[13,11,14,11],[13,12,14,12],[13,8,14,8],[1,18,2,18],[1,8,2,8],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,13,2,13],[1,16,2,16],[1,17,2,17],[1,14,2,14],[1,15,2,15],[1,12,2,12]]}
[]
[null,"5.1.","Kalkulace finančního vnitřního výnosového procenta",null,{"$f":"'0 Úvod'!G19","v":2009},{"$f":"E2+1","v":2010},2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023]
[null,"a",null,"Celkem"]
[null,null,"Celkové přírůstkové provozní příjmy",{"$f":"SUM(E4:S4,E16:S16)","v":488997245.27085304},{"$f":"IF(E2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!E37,0)","v":-58482914.546676725},{"$f":"IF(F2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!F37,0)","v":-57294236.073257625},{"$f":"IF(G2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!G37,0)","v":-44802775.585950151},{"$f":"IF(H2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!H37,0)","v":-54172897.748213947},{"$f":"IF(I2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!I37,0)","v":-42140293.907201171},{"$f":"IF(J2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!J37,0)","v":-40115941.186313391},{"$f":"IF(K2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!K37,0)","v":-43863102.687600538},{"$f":"IF(L2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!L37,0)","v":-333226.32565823197},{"$f":"IF(M2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!M37,0)","v":-5055764.7066690922},{"$f":"IF(N2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!N37,0)","v":-4599794.2599630952},{"$f":"IF(O2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!O37,0)","v":-2326708.8805234432},{"$f":"IF(P2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!P37,0)","v":-1927108.1130502224},{"$f":"IF(Q2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!Q37,0)","v":-1527507.3455769122},{"$f":"IF(R2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!R37,0)","v":-1127906.5781036615},{"$f":"IF(S2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!S37,0)","v":-728305.81063044071}]
[null,null,"Celkové výnosy",{"$f":"SUM(D4)","v":488997245.27085304},{"$f":"SUM(E4)","v":-58482914.546676725},{"$f":"SUM(F4)","v":-57294236.073257625},-44802775.585950151,-54172897.748213947,-42140293.907201171,-40115941.186313391,-43863102.687600538,-333226.32565823197,-5055764.7066690922,-4599794.2599630952,-2326708.8805234432,-1927108.1130502224,-1527507.3455769122,-1127906.5781036615,-728305.81063044071]
[null,null,"Celkové přírůstkové provozní náklady",{"$f":"SUM(E6:S6,E18:S18)","v":-10051472654.618605},{"$f":"IF(E2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!E37,0)","v":-253338588.96752474},{"$f":"IF(F2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!F37,0)","v":-90124768.027700603},{"$f":"IF(G2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!G37,0)","v":-110348658.14919025},{"$f":"IF(H2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!H37,0)","v":-1223053159.5212038},{"$f":"IF(I2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!I37,0)","v":-227160999.67569423},{"$f":"IF(J2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!J37,0)","v":-252464393.16667694},{"$f":"IF(K2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!K37,0)","v":-110615251.81754988},{"$f":"IF(L2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!L37,0)","v":-178038906.15635085},{"$f":"IF(M2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!M37,0)","v":-216670438.2025125},{"$f":"IF(N2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!N37,0)","v":-264802830.32565701},{"$f":"IF(O2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!O37,0)","v":-395516417.27667946},{"$f":"IF(P2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!P37,0)","v":-303289289.83043301},{"$f":"IF(Q2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!Q37,0)","v":-354192294.09431905},{"$f":"IF(R2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!R37,0)","v":-413745062.07696706},{"$f":"IF(S2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!S37,0)","v":-129870112.10264981}]
[null,null,"Celkové invest. náklady bez rezervy",{"$f":"SUM(E7:S7,E19:S19)","v":26380458669.080444},{"$f":"'1 Celkové investiční náklady'!G11","v":1821800582.6248858},{"$f":"'1 Celkové investiční náklady'!H11","v":2911281210.0714498},{"$f":"'1 Celkové investiční náklady'!I11","v":2610955271.669632},{"$f":"'1 Celkové investiční náklady'!J11","v":1502053609.8226175},{"$f":"'1 Celkové investiční náklady'!K11","v":655394015.64399409},{"$f":"'1 Celkové investiční náklady'!L11","v":695322644.91248941},{"$f":"'1 Celkové investiční náklady'!M11","v":1345771891.5811446},{"$f":"'1 Celkové investiční náklady'!N11","v":1248507208.6304123},{"$f":"'1 Celkové investiční náklady'!O11","v":2711011165.5283809},{"$f":"'1 Celkové investiční náklady'!P11","v":2128055475.9538043},{"$f":"'1 Celkové investiční náklady'!Q11","v":2873078837.9745307},{"$f":"'1 Celkové investiční náklady'!R11","v":2144223129.0170994},{"$f":"'1 Celkové investiční náklady'!S11","v":1284358017.5},{"$f":"'1 Celkové investiční náklady'!T11","v":1361400948.6250002},{"$f":"'1 Celkové investiční náklady'!U11","v":1087244659.5250001}]
[null,null,"Zůstatková hodnota (záporná)",-7218913427.9942722,{"$f":"IF(E2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(F2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(G2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(H2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(I2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(J2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(K2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(L2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(M2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(N2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(O2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(P2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(Q2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(R2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(S2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0}]
[null,null,"Celkové náklady",{"$f":"SUM(D6:D8)","v":9110072586.4675674},{"$f":"SUM(E6:E8)","v":1568461993.657361},{"$f":"SUM(F6:F8)","v":2821156442.0437493},2500606613.5204415,279000450.30141377,428233015.96829987,442858251.74581248,1235156639.7635946,1070468302.4740615,2494340727.3258686,1863252645.6281471,2477562420.6978512,1840933839.1866665,930165723.40568089,947655886.54803324,957374547.42235029]
[null,null,"Cash Flow ",null,{"$f":"E5-E9","v":-1626944908.2040377},-2878450678.1170068,-2545409389.1063919,-333173348.04962772,-470373309.87550104,-482974192.93212587,-1279019742.4511952,-1070801528.7997197,-2499396492.0325375,-1867852439.8881102,-2479889129.5783749,-1842860947.2997167,-931693230.75125778,-948783793.1261369,-958102853.23298073]
[null,null,"Diskontní sazba",{"$f":"'0 Úvod'!D21","v":0.04},1,{"$f":"E11/(1+$D$11)","v":0.96153846153846145},{"$f":"F11/(1+$D$11)","v":0.92455621301775137},{"$f":"G11*1/(1+$D$11)","v":0.88899635867091475},{"$f":"H11*1/(1+$D$11)","v":0.85480419102972571},{"$f":"I11*1/(1+$D$11)","v":0.82192710675935166},0.79031452573014582,0.75991781320206331,0.73069020500198389,0.70258673557883067,0.67556416882579873,0.64958093156326802,0.62459704958006534,0.60057408613467822,0.57747508282180593]
[null,null,"Diskontované cash flow",{"$f":"SUM(E12:S12,E24:S24)","v":-12241582954.141825},{"$f":"E10*E11","v":-1626944908.2040377},{"$f":"F10*F11","v":-2767741036.6509676},-2353374065.3720336,-296189893.22231638,-402077076.63010216,-396969581.03613514,-1010827881.1548096,-813721156.13890922,-1826284535.1444943,-1312328348.2839413,-1675324238.6037483,-1197087330.8885167,-581932843.04095459,-569814959.49612331,-553280524.52252412]
[null,null,null,null,{"$f":"IF(E2>='0 Úvod'!$G$21,E4-E6,0)","v":0},{"$f":"IF(F2>='0 Úvod'!$G$21,F4-F6,0)","v":0},{"$f":"IF(G2>='0 Úvod'!$G$21,G4-G6,0)","v":0},{"$f":"IF(H2>='0 Úvod'!$G$21,H4-H6,0)","v":0},{"$f":"IF(I2>='0 Úvod'!$G$21,I4-I6,0)","v":0},{"$f":"IF(J2>='0 Úvod'!$G$21,J4-J6,0)","v":0},{"$f":"IF(K2>='0 Úvod'!$G$21,K4-K6,0)","v":0},{"$f":"IF(L2>='0 Úvod'!$G$21,L4-L6,0)","v":0},{"$f":"IF(M2>='0 Úvod'!$G$21,M4-M6,0)","v":0},{"$f":"IF(N2>='0 Úvod'!$G$21,N4-N6,0)","v":0},{"$f":"IF(O2>='0 Úvod'!$G$21,O4-O6,0)","v":0},{"$f":"IF(P2>='0 Úvod'!$G$21,P4-P6,0)","v":0},{"$f":"IF(Q2>='0 Úvod'!$G$21,Q4-Q6,0)","v":0},{"$f":"IF(R2>='0 Úvod'!$G$21,R4-R6,0)","v":0},{"$f":"IF(S2>='0 Úvod'!$G$21,S4-S6,0)","v":0}]
[null,"5.1.","Kalkulace finančního vnitřního výnosového procenta",null,{"$f":"S2+1","v":2024},{"$f":"E14+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038]
[null,"b"]
[null,null,{"$f":"C4","v":"Celkové přírůstkové provozní příjmy"},null,{"$f":"IF(E14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!E44,0)","v":52857212.05457744},{"$f":"IF(F14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!F44,0)","v":53156637.081860095},{"$f":"IF(G14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!G44,0)","v":53456062.109142721},{"$f":"IF(H14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!H44,0)","v":55688647.165000528},{"$f":"IF(I14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!I44,0)","v":55988072.192283213},{"$f":"IF(J14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!J44,0)","v":56287497.219565868},{"$f":"IF(K14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!K44,0)","v":56586922.246848524},{"$f":"IF(L14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!L44,0)","v":56886347.274131179},{"$f":"IF(M14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!M44,0)","v":57185772.301413804},{"$f":"IF(N14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!N44,0)","v":57485197.32869646},{"$f":"IF(O14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!O44,0)","v":57784622.355979115},{"$f":"IF(P14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!P44,0)","v":58084047.38326174},{"$f":"IF(Q14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!Q44,0)","v":58383472.410544395},{"$f":"IF(R14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!R44,0)","v":58682897.437827021},{"$f":"IF(S14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'4 Tržby'!S44,0)","v":58982322.465109706}]
[null,null,"Celkové výnosy",null,{"$f":"SUM(E16)","v":52857212.05457744},{"$f":"SUM(F16)","v":53156637.081860095},53456062.109142721,55688647.165000528,55988072.192283213,56287497.219565868,56586922.246848524,56886347.274131179,57185772.301413804,57485197.32869646,57784622.355979115,58084047.38326174,58383472.410544395,58682897.437827021,58982322.465109706]
[null,null,"Celkové přírůstkové provozní náklady",null,{"$f":"IF(E14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!E44,0)","v":-1006667224.8187716},{"$f":"IF(F14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!F44,0)","v":-707793278.071365},{"$f":"IF(G14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!G44,0)","v":-164067642.90501136},{"$f":"IF(H14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!H44,0)","v":-218735367.17977315},{"$f":"IF(I14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!I44,0)","v":-206256654.42587796},{"$f":"IF(J14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!J44,0)","v":-395493786.50570649},{"$f":"IF(K14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!K44,0)","v":-241790227.27980602},{"$f":"IF(L14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!L44,0)","v":-292456331.21596521},{"$f":"IF(M14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!M44,0)","v":-394881314.23946863},{"$f":"IF(N14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!N44,0)","v":-317964337.07530069},{"$f":"IF(O14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!O44,0)","v":-301313653.55973232},{"$f":"IF(P14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!P44,0)","v":-253185082.09134543},{"$f":"IF(Q14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!Q44,0)","v":-271553020.81560719},{"$f":"IF(R14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!R44,0)","v":-360017672.45897341},{"$f":"IF(S14<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),'3 Provozní náklady'!S44,0)","v":-396065892.58479309}]
[null,null,"Celkové invest. náklady bez rezervy",null,{"$f":"'1 Celkové investiční náklady'!G26","v":0},{"$f":"'1 Celkové investiční náklady'!H26","v":0},{"$f":"'1 Celkové investiční náklady'!I26","v":0},{"$f":"'1 Celkové investiční náklady'!J26","v":0},{"$f":"'1 Celkové investiční náklady'!K26","v":0},{"$f":"'1 Celkové investiční náklady'!L26","v":0},{"$f":"'1 Celkové investiční náklady'!M26","v":0},{"$f":"'1 Celkové investiční náklady'!N26","v":0},{"$f":"'1 Celkové investiční náklady'!O26","v":0},{"$f":"'1 Celkové investiční náklady'!P26","v":0},{"$f":"'1 Celkové investiční náklady'!Q26","v":0},{"$f":"'1 Celkové investiční náklady'!R26","v":0},{"$f":"'1 Celkové investiční náklady'!S26","v":0},{"$f":"'1 Celkové investiční náklady'!T26","v":0},{"$f":"'1 Celkové investiční náklady'!U26","v":0}]
[null,null,"Zůstatková hodnota (záporná)",null,{"$f":"IF(E14='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(F14='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(G14='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(H14='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(I14='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(J14='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(K14='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(L14='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(M14='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(N14='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(O14='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(P14='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(Q14='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(R14='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(S14='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":-7218913427.9942722}]
[null,null,"Celkové náklady",null,{"$f":"SUM(E18:E20)","v":-1006667224.8187716},{"$f":"SUM(F18:F20)","v":-707793278.071365},-164067642.90501136,-218735367.17977315,-206256654.42587796,-395493786.50570649,-241790227.27980602,-292456331.21596521,-394881314.23946863,-317964337.07530069,-301313653.55973232,-253185082.09134543,-271553020.81560719,-360017672.45897341,-7614979320.5790653]
[null,null,"Cash Flow ",null,{"$f":"E17-E21","v":1059524436.8733491},760949915.15322506,217523705.01415408,274424014.34477365,262244726.61816117,451781283.72527236,298377149.52665454,349342678.49009639,452067086.54088247,375449534.40399718,359098275.9157114,311269129.47460717,329936493.22615159,418700569.8968004,7673961643.0441751]
[null,null,"Diskontní sazba",{"$f":"D11","v":0.04},{"$f":"S11*1/(1+$D$11)","v":0.55526450271327488},{"$f":"E23*1/(1+$D$11)","v":0.53390817568584126},{"$f":"F23*1/(1+$D$11)","v":0.51337324585177047},0.49362812101131776,0.47464242404934398,0.45638694620129228,0.4388336021166272,0.42195538665060306,0.40572633331788754,0.39012147434412264,0.37511680225396404,0.3606892329365039,0.34681657013125372,0.33347747128005162,0.32065141469235731]
[null,null,"Diskontované cash flow",null,{"$f":"E22*E23","v":588316309.55304277},406277380.98775411,111670850.49281932,135463410.56139353,124472472.73620154,206187080.43027663,130937919.3160733,147407024.97584593,183415521.4359324,146470925.90350178,134703796.95641333,112271423.54700938,114427442.94182752,139627207.2727015,2460666657.1370015]
[null,null,null,null,{"$f":"IF(E14>='0 Úvod'!$G$21,E16-E18,0)","v":1059524436.8733491},{"$f":"IF(F14>='0 Úvod'!$G$21,F16-F18,0)","v":760949915.15322506},{"$f":"IF(G14>='0 Úvod'!$G$21,G16-G18,0)","v":217523705.01415408},{"$f":"IF(H14>='0 Úvod'!$G$21,H16-H18,0)","v":274424014.34477365},{"$f":"IF(I14>='0 Úvod'!$G$21,I16-I18,0)","v":262244726.61816117},{"$f":"IF(J14>='0 Úvod'!$G$21,J16-J18,0)","v":451781283.72527236},{"$f":"IF(K14>='0 Úvod'!$G$21,K16-K18,0)","v":298377149.52665454},{"$f":"IF(L14>='0 Úvod'!$G$21,L16-L18,0)","v":349342678.49009639},{"$f":"IF(M14>='0 Úvod'!$G$21,M16-M18,0)","v":452067086.54088247},{"$f":"IF(N14>='0 Úvod'!$G$21,N16-N18,0)","v":375449534.40399718},{"$f":"IF(O14>='0 Úvod'!$G$21,O16-O18,0)","v":359098275.9157114},{"$f":"IF(P14>='0 Úvod'!$G$21,P16-P18,0)","v":311269129.47460717},{"$f":"IF(Q14>='0 Úvod'!$G$21,Q16-Q18,0)","v":329936493.22615159},{"$f":"IF(R14>='0 Úvod'!$G$21,R16-R18,0)","v":418700569.8968004},{"$f":"IF(S14>='0 Úvod'!$G$21,S16-S18,0)","v":455048215.0499028}]
[null,"Finanční vnitřní výnosové procento investice FRR/C",null,null,{"$f":"ROUND(IRR((E10:S10,E22:S22),0.05),4)","v":-2.58E-2}]
[null,"Finanční čistá současná hodnota investice FNPV/C (CZK)",null,null,{"$f":"E10+NPV('0 Úvod'!D21,(F10:S10,E22:S22))","v":-12241582954.141827}]
[null,"Finanční čistá současná hodnota investice FNPV/C (EUR)",null,null,{"$f":"E27/'0 Úvod'!N19","v":-477068704.37029719}]

{"sheet":"6 Kontrola dotací","index":6,"n_rows":51,"n_cols":19,"rows_kept":51,"cut":false,"hidden":false,"merged":[[23,8,24,8],[38,7,39,7],[38,8,39,8],[38,4,39,4],[38,5,39,5],[31,7,32,7],[31,8,32,8],[23,18,24,18],[23,13,24,13],[23,17,24,17],[23,12,24,12],[38,17,39,17],[38,18,39,18],[31,17,32,17],[31,18,32,18],[23,10,24,10],[23,11,24,11],[23,9,24,9],[38,16,39,16],[31,11,32,11],[31,12,32,12],[31,13,32,13],[38,15,39,15],[38,10,39,10],[38,9,39,9],[38,13,39,13],[38,14,39,14],[31,14,32,14],[38,11,39,11],[38,12,39,12],[46,1,47,15],[31,4,32,4],[31,5,32,5],[31,6,32,6],[23,16,24,16],[23,4,24,4],[23,5,24,5],[23,6,24,6],[23,7,24,7],[38,6,39,6],[31,15,32,15],[31,16,32,16],[23,14,24,14],[23,15,24,15],[31,9,32,9],[31,10,32,10],[8,12,9,12],[16,13,17,13],[16,14,17,14],[16,17,17,17],[16,11,17,11],[16,12,17,12],[16,15,17,15],[16,16,17,16],[16,18,17,18],[16,10,17,10],[8,7,9,7],[8,8,9,8],[16,7,17,7],[16,8,17,8],[16,9,17,9],[8,9,9,9],[8,10,9,10],[8,18,9,18],[8,13,9,13],[8,14,9,14],[8,15,9,15],[8,16,9,16],[8,17,9,17],[8,11,9,11],[1,17,2,17],[1,18,2,18],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,12,2,12],[1,13,2,13],[1,14,2,14],[1,15,2,15],[1,16,2,16],[16,4,17,4],[16,5,17,5],[8,5,9,5],[16,6,17,6],[1,6,2,6],[8,4,9,4],[8,6,9,6],[1,4,2,4],[1,5,2,5]]}
[]
[null,"6.1.","S projektem",null,{"$f":"'0 Úvod'!G19","v":2009},{"$f":"E2+1","v":2010},2011,2012,2013,2014,2015,2016,2017,2018,2019,{"$f":"O2+1","v":2020},2021,2022,2023]
[null,"a",null,"Celkem"]
[null,"A","Náklady na údržbu a opravy",{"$f":"SUM(E4:S4,E11:S11)","v":4975016440.6351357},{"$f":"'3 Provozní náklady'!E4+'3 Provozní náklady'!E5","v":154438210.22098094},{"$f":"'3 Provozní náklady'!F4+'3 Provozní náklady'!F5","v":160580374.14310643},{"$f":"'3 Provozní náklady'!G4+'3 Provozní náklady'!G5","v":194821024.94473922},{"$f":"'3 Provozní náklady'!H4+'3 Provozní náklady'!H5","v":136047405.63453296},{"$f":"'3 Provozní náklady'!I4+'3 Provozní náklady'!I5","v":126146188.04292861},{"$f":"'3 Provozní náklady'!J4+'3 Provozní náklady'!J5","v":164309269.20918572},{"$f":"'3 Provozní náklady'!K4+'3 Provozní náklady'!K5","v":159701253.10580003},{"$f":"'3 Provozní náklady'!L4+'3 Provozní náklady'!L5","v":156577675.04303914},{"$f":"'3 Provozní náklady'!M4+'3 Provozní náklady'!M5","v":156577675.04303914},{"$f":"'3 Provozní náklady'!N4+'3 Provozní náklady'!N5","v":156577675.04303914},{"$f":"'3 Provozní náklady'!O4+'3 Provozní náklady'!O5","v":167443295.11050403},{"$f":"'3 Provozní náklady'!P4+'3 Provozní náklady'!P5","v":167497623.21084136},{"$f":"'3 Provozní náklady'!Q4+'3 Provozní náklady'!Q5","v":167552222.95168036},{"$f":"'3 Provozní náklady'!R4+'3 Provozní náklady'!R5","v":167607095.69122356},{"$f":"'3 Provozní náklady'!S4+'3 Provozní náklady'!S5","v":167662242.7944645}]
[null,"B","Náklady na řízení provozu",{"$f":"SUM(E5:S5,E12:S12)","v":2292207907.3129764},{"$f":"'3 Provozní náklady'!E6","v":104197296.99429622},{"$f":"'3 Provozní náklady'!F6","v":104394240.51490632},{"$f":"'3 Provozní náklady'!G6","v":114276447.90391849},{"$f":"'3 Provozní náklady'!H6","v":92856289.384952843},{"$f":"'3 Provozní náklady'!I6","v":90865527.883156449},{"$f":"'3 Provozní náklady'!J6","v":92310934.4196897},{"$f":"'3 Provozní náklady'!K6","v":99301727.470499992},{"$f":"'3 Provozní náklady'!L6","v":99743209.224488571},{"$f":"'3 Provozní náklady'!M6","v":99743209.224488571},{"$f":"'3 Provozní náklady'!N6","v":99743209.224488571},{"$f":"'3 Provozní náklady'!O6","v":78880018.906375825},{"$f":"'3 Provozní náklady'!P6","v":80852019.379035205},{"$f":"'3 Provozní náklady'!Q6","v":82873319.863511071},{"$f":"'3 Provozní náklady'!R6","v":84945152.860098854},{"$f":"'3 Provozní náklady'!S6","v":94104417.330575973}]
[null,"C","Příjmy z poplatků za dopravní cestu*",4925477976.6678762,{"$f":"'4 Tržby'!E4+'4 Tržby'!E5","v":92914842.788899988},{"$f":"'4 Tržby'!F4+'4 Tržby'!F5","v":91896080.601339996},{"$f":"'4 Tržby'!G4+'4 Tržby'!G5","v":103332120.60766001},{"$f":"'4 Tržby'!H4+'4 Tržby'!H5","v":92451210.806863219},{"$f":"'4 Tržby'!I4+'4 Tržby'!I5","v":104483814.64787599},{"$f":"'4 Tržby'!J4+'4 Tržby'!J5","v":108524827.26954201},{"$f":"'4 Tržby'!K4+'4 Tržby'!K5","v":104975277.68228699},{"$f":"'4 Tržby'!L4+'4 Tržby'!L5","v":149479850.16409323},{"$f":"'4 Tržby'!M4+'4 Tržby'!M5","v":152723121.13716573},{"$f":"'4 Tržby'!N4+'4 Tržby'!N5","v":153692693.23766071},{"$f":"'4 Tržby'!O4+'4 Tržby'!O5","v":156479380.27088928},{"$f":"'4 Tržby'!P4+'4 Tržby'!P5","v":157392582.69215149},{"$f":"'4 Tržby'!Q4+'4 Tržby'!Q5","v":158305785.11341375},{"$f":"'4 Tržby'!R4+'4 Tržby'!R5","v":159218987.53467596},{"$f":"'4 Tržby'!S4+'4 Tržby'!S5","v":160132189.95593816}]
[null,"D","Provozní dotace",2341746371.2802372,{"$f":"IF((E4+E5-E6)>0,E4+E5-E6,0)","v":165720664.42637718},{"$f":"IF((F4+F5-F6)>0,F4+F5-F6,0)","v":173078534.05667275},205765352.24099773,136452484.21262258,112527901.27820906,148095376.35933343,154027702.89401305,106841034.10343447,103597763.13036197,102628191.02986699,89843933.745990574,90957059.897725075,92119757.701777697,93333261.016646445,101634470.16910231]
[]
[null,"6.1.","S projektem",null,{"$f":"S2+1","v":2024},{"$f":"E9+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,{"$f":"O9+1","v":2035},2036,2037,2038]
[null,"b"]
[null,"A","Náklady na údržbu a opravy",null,{"$f":"'3 Provozní náklady'!E11+'3 Provozní náklady'!E12","v":165171195.47535428},{"$f":"'3 Provozní náklady'!F11+'3 Provozní náklady'!F12","v":165997051.45273104},{"$f":"'3 Provozní náklady'!G11+'3 Provozní náklady'!G12","v":166827036.7099947},{"$f":"'3 Provozní náklady'!H11+'3 Provozní náklady'!H12","v":167661171.89354461},{"$f":"'3 Provozní náklady'!I11+'3 Provozní náklady'!I12","v":168499477.75301233},{"$f":"'3 Provozní náklady'!J11+'3 Provozní náklady'!J12","v":169341975.14177737},{"$f":"'3 Provozní náklady'!K11+'3 Provozní náklady'!K12","v":170188685.01748624},{"$f":"'3 Provozní náklady'!L11+'3 Provozní náklady'!L12","v":171039628.44257367},{"$f":"'3 Provozní náklady'!M11+'3 Provozní náklady'!M12","v":171894826.58478653},{"$f":"'3 Provozní náklady'!N11+'3 Provozní náklady'!N12","v":172754300.71771044},{"$f":"'3 Provozní náklady'!O11+'3 Provozní náklady'!O12","v":173618072.22129893},{"$f":"'3 Provozní náklady'!P11+'3 Provozní náklady'!P12","v":174486162.58240542},{"$f":"'3 Provozní náklady'!Q11+'3 Provozní náklady'!Q12","v":176231024.20822948},{"$f":"'3 Provozní náklady'!R11+'3 Provozní náklady'!R12","v":177993334.45031178},{"$f":"'3 Provozní náklady'!S11+'3 Provozní náklady'!S12","v":179773267.79481491}]
[null,"B","Náklady na řízení provozu",null,{"$f":"'3 Provozní náklady'!E13","v":49482811.719211459},{"$f":"'3 Provozní náklady'!F13","v":50719882.012191743},{"$f":"'3 Provozní náklady'!G13","v":51987879.062496528},{"$f":"'3 Provozní náklady'!H13","v":53287576.039058939},{"$f":"'3 Provozní náklady'!I13","v":54619765.440035403},{"$f":"'3 Provozní náklady'!J13","v":55985259.576036289},{"$f":"'3 Provozní náklady'!K13","v":57104964.76755701},{"$f":"'3 Provozní náklady'!L13","v":58247064.062908158},{"$f":"'3 Provozní náklady'!M13","v":59412005.344166324},{"$f":"'3 Provozní náklady'!N13","v":60600245.451049641},{"$f":"'3 Provozní náklady'!O13","v":61812250.360070631},{"$f":"'3 Provozní náklady'!P13","v":63048495.367272049},{"$f":"'3 Provozní náklady'!Q13","v":64309465.274617493},{"$f":"'3 Provozní náklady'!R13","v":65595654.580109842},{"$f":"'3 Provozní náklady'!S13","v":66907567.671712041}]
[null,"C","Příjmy z poplatků za dopravní cestu*",null,{"$f":"'4 Tržby'!E11+'4 Tržby'!E12","v":195716689.59004623},{"$f":"'4 Tržby'!F11+'4 Tržby'!F12","v":196133116.90725315},{"$f":"'4 Tržby'!G11+'4 Tržby'!G12","v":196549544.22446004},{"$f":"'4 Tržby'!H11+'4 Tržby'!H12","v":196965971.54166695},{"$f":"'4 Tržby'!I11+'4 Tržby'!I12","v":197382398.8588739},{"$f":"'4 Tržby'!J11+'4 Tržby'!J12","v":197798826.17608082},{"$f":"'4 Tržby'!K11+'4 Tržby'!K12","v":198215253.49328774},{"$f":"'4 Tržby'!L11+'4 Tržby'!L12","v":198631680.81049466},{"$f":"'4 Tržby'!M11+'4 Tržby'!M12","v":199048108.12770158},{"$f":"'4 Tržby'!N11+'4 Tržby'!N12","v":199464535.4449085},{"$f":"'4 Tržby'!O11+'4 Tržby'!O12","v":199880962.76211542},{"$f":"'4 Tržby'!P11+'4 Tržby'!P12","v":200297390.07932234},{"$f":"'4 Tržby'!Q11+'4 Tržby'!Q12","v":200713817.39652926},{"$f":"'4 Tržby'!R11+'4 Tržby'!R12","v":201130244.71373615},{"$f":"'4 Tržby'!S11+'4 Tržby'!S12","v":201546672.0309431}]
[null,"D","Provozní dotace",null,{"$f":"IF((E11+E12-E13)>0,E11+E12-E13,0)","v":18937317.604519516},{"$f":"IF((F11+F12-F13)>0,F11+F12-F13,0)","v":20583816.55766964},22265371.548031181,23982776.390936583,25736844.334173828,27528408.541732848,29078396.291755497,30655011.694987178,32258723.801251292,33890010.723851562,35549359.81925416,37237267.870355129,39826672.086317718,42458744.316685468,45134163.43558386]
[]
[]
[null,"6.2.","Bez projektu",null,{"$f":"E2","v":2009},{"$f":"E17+1","v":2010},2011,2012,2013,2014,2015,2016,2017,2018,2019,{"$f":"O17+1","v":2020},2021,2022,2023]
[null,"a",null,"Celkem"]
[null,"E","Náklady na údržbu a opravy",{"$f":"SUM(E19:S19,E26:S26)","v":13045732413.770178},{"$f":"'3 Provozní náklady'!E19+'3 Provozní náklady'!E20","v":411227994.42541409},{"$f":"'3 Provozní náklady'!F19+'3 Provozní náklady'!F20","v":251907987.1963501},{"$f":"'3 Provozní náklady'!G19+'3 Provozní náklady'!G20","v":316460091.51940882},{"$f":"'3 Provozní náklady'!H19+'3 Provozní náklady'!H20","v":1349794703.378078},{"$f":"'3 Provozní náklady'!I19+'3 Provozní náklady'!I20","v":343542996.70660686},{"$f":"'3 Provozní náklady'!J19+'3 Provozní náklady'!J20","v":406542913.24137169},{"$f":"'3 Provozní náklady'!K19+'3 Provozní náklady'!K20","v":264205381.70015216},{"$f":"'3 Provozní náklady'!L19+'3 Provozní náklady'!L20","v":325784554.2093699},{"$f":"'3 Provozní náklady'!M19+'3 Provozní náklady'!M20","v":361701705.35016882},{"$f":"'3 Provozní náklady'!N19+'3 Provozní náklady'!N20","v":406495408.95971715},{"$f":"'3 Provozní náklady'!O19+'3 Provozní náklady'!O20","v":523772576.49108779},{"$f":"'3 Provozní náklady'!P19+'3 Provozní náklady'!P20","v":430620098.74777627},{"$f":"'3 Provozní náklady'!Q19+'3 Provozní náklady'!Q20","v":480573532.39516377},{"$f":"'3 Provozní náklady'!R19+'3 Provozní náklady'!R20","v":536577712.71905184},{"$f":"'3 Provozní náklady'!S19+'3 Provozní náklady'!S20","v":275943717.65546942}]
[null,"F","Náklady na řízení provozu",{"$f":"SUM(E20:S20,E27:S27)","v":4272964588.7965412},{"$f":"'3 Provozní náklady'!E21","v":100746101.75738782},{"$f":"'3 Provozní náklady'!F21","v":103191395.48936325},{"$f":"'3 Provozní náklady'!G21","v":102986039.47843914},{"$f":"'3 Provozní náklady'!H21","v":102162151.1626116},{"$f":"'3 Provozní náklady'!I21","v":100629718.89517242},{"$f":"'3 Provozní náklady'!J21","v":102541683.55418068},{"$f":"'3 Provozní náklady'!K21","v":105412850.69369775},{"$f":"'3 Provozní náklady'!L21","v":108575236.21450868},{"$f":"'3 Provozní náklady'!M21","v":111289617.11987139},{"$f":"'3 Provozní náklady'!N21","v":114628305.63346754},{"$f":"'3 Provozní náklady'!O21","v":118067154.80247158},{"$f":"'3 Provozní náklady'!P21","v":121018833.67253333},{"$f":"'3 Provozní náklady'!Q21","v":124044304.51434667},{"$f":"'3 Provozní náklady'!R21","v":129719597.90923759},{"$f":"'3 Provozní náklady'!S21","v":115693054.57222086}]
[null,"G","Příjmy z poplatků za dopravní cestu*",4436480731.3970232,{"$f":"'4 Tržby'!E19+'4 Tržby'!E20","v":151397757.33557671},{"$f":"'4 Tržby'!F19+'4 Tržby'!F20","v":149190316.67459762},{"$f":"'4 Tržby'!G19+'4 Tržby'!G20","v":148134896.19361016},{"$f":"'4 Tržby'!H19+'4 Tržby'!H20","v":146624108.55507717},{"$f":"'4 Tržby'!I19+'4 Tržby'!I20","v":146624108.55507717},{"$f":"'4 Tržby'!J19+'4 Tržby'!J20","v":148640768.4558554},{"$f":"'4 Tržby'!K19+'4 Tržby'!K20","v":148838380.36988753},{"$f":"'4 Tržby'!L19+'4 Tržby'!L20","v":149813076.48975146},{"$f":"'4 Tržby'!M19+'4 Tržby'!M20","v":157778885.84383482},{"$f":"'4 Tržby'!N19+'4 Tržby'!N20","v":158292487.4976238},{"$f":"'4 Tržby'!O19+'4 Tržby'!O20","v":158806089.15141273},{"$f":"'4 Tržby'!P19+'4 Tržby'!P20","v":159319690.80520171},{"$f":"'4 Tržby'!Q19+'4 Tržby'!Q20","v":159833292.45899066},{"$f":"'4 Tržby'!R19+'4 Tržby'!R20","v":160346894.11277962},{"$f":"'4 Tržby'!S19+'4 Tržby'!S20","v":160860495.7665686}]
[null,"H","Provozní dotace",12882216271.169699,{"$f":"IF((E19+E20-E21)>0,E19+E20-E21,0)","v":360576338.84722519},{"$f":"IF((F19+F20-F21)>0,F19+F20-F21,0)","v":205909066.01111573},271311234.80423784,1305332745.9856124,297548607.04670215,360443828.339697,220779852.02396238,284546713.93412709,315212436.62620538,362831227.09556091,483033642.14214659,392319241.61510783,444784544.4505198,505950416.51550984,230776276.46112168]
[]
[null,"6.2.","Bez projektu",null,{"$f":"S17+1","v":2024},{"$f":"E24+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,{"$f":"O24+1","v":2035},2036,2037,2038]
[null,"b"]
[null,"E","Náklady na údržbu a opravy",null,{"$f":"'3 Provozní náklady'!E26+'3 Provozní náklady'!E27","v":1102735851.0768111},{"$f":"'3 Provozní náklady'!F26+'3 Provozní náklady'!F27","v":802960196.0763483},{"$f":"'3 Provozní náklady'!G26+'3 Provozní náklady'!G27","v":258293792.83106458},{"$f":"'3 Provozní náklady'!H26+'3 Provozní náklady'!H27","v":273557574.28379196},{"$f":"'3 Provozní náklady'!I26+'3 Provozní náklady'!I27","v":259096193.26962635},{"$f":"'3 Provozní náklady'!J26+'3 Provozní náklady'!J27","v":446284324.26548839},{"$f":"'3 Provozní náklady'!K26+'3 Provozní náklady'!K27","v":291056446.16765684},{"$f":"'3 Provozní náklady'!L26+'3 Provozní náklady'!L27","v":340155044.20631075},{"$f":"'3 Provozní náklady'!M26+'3 Provozní náklady'!M27","v":440968407.0629825},{"$f":"'3 Provozní náklady'!N26+'3 Provozní náklady'!N27","v":362394749.35651302},{"$f":"'3 Provozní náklady'!O26+'3 Provozní náklady'!O27","v":344041359.57580316},{"$f":"'3 Provozní náklady'!P26+'3 Provozní náklady'!P27","v":294163071.14441818},{"$f":"'3 Provozní náklady'!Q26+'3 Provozní náklady'!Q27","v":311605708.02391732},{"$f":"'3 Provozní náklady'!R26+'3 Provozní náklady'!R27","v":399109103.16936749},{"$f":"'3 Provozní náklady'!S26+'3 Provozní náklady'!S27","v":434159218.56489193}]
[null,"F","Náklady na řízení provozu",null,{"$f":"'3 Provozní náklady'!E28","v":118585380.93652636},{"$f":"'3 Provozní náklady'!F28","v":121550015.45993954},{"$f":"'3 Provozní náklady'!G28","v":124588765.84643799},{"$f":"'3 Provozní náklady'!H28","v":166126540.82858473},{"$f":"'3 Provozní náklady'!I28","v":170279704.34929934},{"$f":"'3 Provozní náklady'!J28","v":174536696.9580318},{"$f":"'3 Provozní náklady'!K28","v":178027430.89719242},{"$f":"'3 Provozní náklady'!L28","v":181587979.5151363},{"$f":"'3 Provozní náklady'!M28","v":185219739.10543904},{"$f":"'3 Provozní náklady'!N28","v":188924133.88754779},{"$f":"'3 Provozní náklady'!O28","v":192702616.56529874},{"$f":"'3 Provozní náklady'!P28","v":196556668.89660472},{"$f":"'3 Provozní náklady'!Q28","v":200487802.27453685},{"$f":"'3 Provozní náklady'!R28","v":204497558.32002756},{"$f":"'3 Provozní náklady'!S28","v":208587509.48642811}]
[null,"G","Příjmy z poplatků za dopravní cestu*",null,{"$f":"'4 Tržby'!E26+'4 Tržby'!E27","v":142859477.53546879},{"$f":"'4 Tržby'!F26+'4 Tržby'!F27","v":142976479.82539305},{"$f":"'4 Tržby'!G26+'4 Tržby'!G27","v":143093482.11531731},{"$f":"'4 Tržby'!H26+'4 Tržby'!H27","v":141277324.37666643},{"$f":"'4 Tržby'!I26+'4 Tržby'!I27","v":141394326.66659069},{"$f":"'4 Tržby'!J26+'4 Tržby'!J27","v":141511328.95651495},{"$f":"'4 Tržby'!K26+'4 Tržby'!K27","v":141628331.24643922},{"$f":"'4 Tržby'!L26+'4 Tržby'!L27","v":141745333.53636348},{"$f":"'4 Tržby'!M26+'4 Tržby'!M27","v":141862335.82628778},{"$f":"'4 Tržby'!N26+'4 Tržby'!N27","v":141979338.11621204},{"$f":"'4 Tržby'!O26+'4 Tržby'!O27","v":142096340.4061363},{"$f":"'4 Tržby'!P26+'4 Tržby'!P27","v":142213342.6960606},{"$f":"'4 Tržby'!Q26+'4 Tržby'!Q27","v":142330344.98598486},{"$f":"'4 Tržby'!R26+'4 Tržby'!R27","v":142447347.27590913},{"$f":"'4 Tržby'!S26+'4 Tržby'!S27","v":142564349.56583339}]
[null,"H","Provozní dotace",null,{"$f":"IF((E26+E27-E28)>0,E26+E27-E28,0)","v":1078461754.4778686},{"$f":"IF((F26+F27-F28)>0,F26+F27-F28,0)","v":781533731.7108947},239789076.56218526,298406790.73571026,287981570.952335,479309692.26700521,327455545.81841004,379997690.18508357,484325810.34213376,409339545.12784874,394647635.73496556,348506397.3449623,369763165.3124693,461159314.2134859,500182378.48548669]
[]
[]
[null,"6.3.","Redukce dotací",null,{"$f":"E2","v":2009},{"$f":"E32+1","v":2010},2011,2012,2013,2014,2015,2016,2017,2018,2019,{"$f":"O32+1","v":2020},2021,2022,2023]
[null,"a",null,"Celkem"]
[null,"I","Redukce přírůstkových provozních nákladů",{"$f":"SUM(E34:S34,E41:S41)","v":10051472654.618605},{"$f":"IF(E32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(E19+E20)-(E4+E5),0)","v":253338588.96752474},{"$f":"IF(F32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(F19+F20)-(F4+F5),0)","v":90124768.027700603},{"$f":"IF(G32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(G19+G20)-(G4+G5),0)","v":110348658.14919025},{"$f":"IF(H32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(H19+H20)-(H4+H5),0)","v":1223053159.5212038},{"$f":"IF(I32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(I19+I20)-(I4+I5),0)","v":227160999.67569423},{"$f":"IF(J32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(J19+J20)-(J4+J5),0)","v":252464393.16667694},{"$f":"IF(K32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(K19+K20)-(K4+K5),0)","v":110615251.81754988},{"$f":"IF(L32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(L19+L20)-(L4+L5),0)","v":178038906.15635085},{"$f":"IF(M32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(M19+M20)-(M4+M5),0)","v":216670438.2025125},{"$f":"IF(N32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(N19+N20)-(N4+N5),0)","v":264802830.32565701},{"$f":"IF(O32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(O19+O20)-(O4+O5),0)","v":395516417.27667946},{"$f":"IF(P32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(P19+P20)-(P4+P5),0)","v":303289289.83043301},{"$f":"IF(Q32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(Q19+Q20)-(Q4+Q5),0)","v":354192294.09431905},{"$f":"IF(R32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(R19+R20)-(R4+R5),0)","v":413745062.07696706},{"$f":"IF(S32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(S19+S20)-(S4+S5),0)","v":129870112.10264981}]
[null,"J","Redukce provozních dotací",{"$f":"SUM(E35:S35,E42:S42)","v":10540469899.88946},{"$f":"IF(E32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,E22-E7,0)","v":194855674.42084801},{"$f":"IF(F32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,F22-F7,0)","v":32830531.954442978},{"$f":"IF(G32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,G22-G7,0)","v":65545882.563240111},{"$f":"IF(H32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,H22-H7,0)","v":1168880261.7729897},{"$f":"IF(I32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,I22-I7,0)","v":185020705.76849309},{"$f":"IF(J32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,J22-J7,0)","v":212348451.98036358},{"$f":"IF(K32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,K22-K7,0)","v":66752149.129949331},{"$f":"IF(L32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,L22-L7,0)","v":177705679.83069262},{"$f":"IF(M32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,M22-M7,0)","v":211614673.49584341},{"$f":"IF(N32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,N22-N7,0)","v":260203036.06569391},{"$f":"IF(O32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,O22-O7,0)","v":393189708.39615601},{"$f":"IF(P32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,P22-P7,0)","v":301362181.71738279},{"$f":"IF(Q32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,Q22-Q7,0)","v":352664786.7487421},{"$f":"IF(R32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,R22-R7,0)","v":412617155.4988634},{"$f":"IF(S32<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,S22-S7,0)","v":129141806.29201937}]
[null,null,"Je snížení prov. nákladů plně kompenzováno snížením dotací",{"$f":"IF(D35>=D34,\"ANO\",\"NE\")","v":"ANO"},{"$f":"IF(E35>=E34,\"ANO\",\"NE\")","v":"NE"},{"$f":"IF(F35>=F34,\"ANO\",\"NE\")","v":"NE"},{"$f":"IF(G35>=G34,\"ANO\",\"NE\")","v":"NE"},"NE","NE","NE","NE","NE","NE","NE","NE","NE","NE","NE","NE"]
[null,"K","Čistá úspora provozních nákladů**",{"$f":"SUM(E44:S44,E37:S37)","v":488997245.27085304},{"$f":"E35-E34","v":-58482914.546676725},-57294236.073257625,-44802775.585950136,-54172897.748214006,-42140293.907201141,-40115941.186313361,-43863102.687600553,-333226.32565823197,-5055764.7066690922,-4599794.2599630952,-2326708.8805234432,-1927108.1130502224,-1527507.345576942,-1127906.5781036615,-728305.81063044071]
[]
[null,"6.3.","Redukce dotací",null,{"$f":"S32+1","v":2024},{"$f":"E39+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,{"$f":"O39+1","v":2035},2036,2037,2038]
[null,"b"]
[null,"I","Redukce přírůstkových provozních nákladů",null,{"$f":"IF(E39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(E26+E27)-(E11+E12),0)","v":1006667224.8187716},{"$f":"IF(F39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(F26+F27)-(F11+F12),0)","v":707793278.071365},{"$f":"IF(G39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(G26+G27)-(G11+G12),0)","v":164067642.90501136},{"$f":"IF(H39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(H26+H27)-(H11+H12),0)","v":218735367.17977315},{"$f":"IF(I39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(I26+I27)-(I11+I12),0)","v":206256654.42587796},{"$f":"IF(J39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(J26+J27)-(J11+J12),0)","v":395493786.50570649},{"$f":"IF(K39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(K26+K27)-(K11+K12),0)","v":241790227.27980602},{"$f":"IF(L39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(L26+L27)-(L11+L12),0)","v":292456331.21596521},{"$f":"IF(M39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(M26+M27)-(M11+M12),0)","v":394881314.23946863},{"$f":"IF(N39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(N26+N27)-(N11+N12),0)","v":317964337.07530069},{"$f":"IF(O39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(O26+O27)-(O11+O12),0)","v":301313653.55973232},{"$f":"IF(P39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(P26+P27)-(P11+P12),0)","v":253185082.09134543},{"$f":"IF(Q39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(Q26+Q27)-(Q11+Q12),0)","v":271553020.81560719},{"$f":"IF(R39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(R26+R27)-(R11+R12),0)","v":360017672.45897341},{"$f":"IF(S39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,(S26+S27)-(S11+S12),0)","v":396065892.58479309}]
[null,"J","Redukce provozních dotací - koridory",null,{"$f":"IF(E39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,E29-E14,0)","v":1059524436.8733491},{"$f":"IF(F39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,F29-F14,0)","v":760949915.15322506},{"$f":"IF(G39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,G29-G14,0)","v":217523705.01415408},{"$f":"IF(H39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,H29-H14,0)","v":274424014.34477365},{"$f":"IF(I39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,I29-I14,0)","v":262244726.61816117},{"$f":"IF(J39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,J29-J14,0)","v":451781283.72527236},{"$f":"IF(K39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,K29-K14,0)","v":298377149.52665454},{"$f":"IF(L39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,L29-L14,0)","v":349342678.49009639},{"$f":"IF(M39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,M29-M14,0)","v":452067086.54088247},{"$f":"IF(N39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,N29-N14,0)","v":375449534.40399718},{"$f":"IF(O39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,O29-O14,0)","v":359098275.9157114},{"$f":"IF(P39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,P29-P14,0)","v":311269129.47460717},{"$f":"IF(Q39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,Q29-Q14,0)","v":329936493.22615159},{"$f":"IF(R39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,R29-R14,0)","v":418700569.8968004},{"$f":"IF(S39<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,S29-S14,0)","v":455048215.0499028}]
[null,null,"Je snížení prov. nákladů plně kompenzováno snížením dotací",null,{"$f":"IF(E42>=E41,\"ANO\",\"NE\")","v":"ANO"},{"$f":"IF(F42>=F41,\"ANO\",\"NE\")","v":"ANO"},"ANO","ANO","ANO","ANO","ANO","ANO","ANO","ANO","ANO","ANO","ANO","ANO","ANO"]
[null,"K","Čistá úspora provozních nákladů**",null,{"$f":"E42-E41","v":52857212.05457747},53156637.081860065,53456062.109142721,55688647.165000498,55988072.192283213,56287497.219565868,56586922.246848524,56886347.274131179,57185772.301413834,57485197.328696489,57784622.355979085,58084047.38326174,58383472.410544395,58682897.437826991,58982322.465109706]
[]
[]
[null,"Komentáře"]
[]
[null,"* tržby hrazené přímo uživateli, v souladu s čl. 61 (Operace, které po dokončení vytvářejí čistý příjem) Nařízení (EU) č. 1303/2013 a přílohou V Nařízení (EU) č. 1303/2013 a oddílem III Nařízení Komise v přenesené pravomoci (EU) č. 480/2014,"]
[null,"   v němž jsou stanovena pravidla pro výpočet diskontovaného čistého příjmu z operací vytvářejících čistý příjem"]
[null,"**rozdíl mezi poklesem provozních nákladů a poklesem provozních dotací"]

{"sheet":"7 Mezera ve financování","index":7,"n_rows":35,"n_cols":19,"rows_kept":35,"cut":false,"hidden":false,"merged":[[11,4,12,4],[11,5,12,5],[11,6,12,6],[11,7,12,7],[11,8,12,8],[11,13,12,13],[11,14,12,14],[11,15,12,15],[11,10,12,10],[11,11,12,11],[27,9,28,18],[25,9,26,18],[1,18,2,18],[1,11,2,11],[1,12,2,12],[1,13,2,13],[1,14,2,14],[1,15,2,15],[1,16,2,16],[23,9,24,18],[22,9,22,18],[11,12,12,12],[11,17,12,17],[11,18,12,18],[11,9,12,9],[11,16,12,16],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,17,2,17],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,10,2,10]]}
[null," "]
[null,"7.1.","Kalkulace finanční mezery a přidělení",null,{"$f":"'0 Úvod'!G19","v":2009},{"$f":"E2+1","v":2010},2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023]
[null,"a","grantu EU (CZK)","Celkem (disk.)"]
[null,"A","Investiční náklady (DIC) (z FA)",{"$f":"E4+NPV(D9,F4:S4,E14:S14)","v":20572022057.370487},{"$f":"'5 Finanční analýza (FRR_C)'!E7","v":1821800582.6248858},{"$f":"'5 Finanční analýza (FRR_C)'!F7","v":2911281210.0714498},{"$f":"'5 Finanční analýza (FRR_C)'!G7","v":2610955271.669632},{"$f":"'5 Finanční analýza (FRR_C)'!H7","v":1502053609.8226175},{"$f":"'5 Finanční analýza (FRR_C)'!I7","v":655394015.64399409},{"$f":"'5 Finanční analýza (FRR_C)'!J7","v":695322644.91248941},{"$f":"'5 Finanční analýza (FRR_C)'!K7","v":1345771891.5811446},{"$f":"'5 Finanční analýza (FRR_C)'!L7","v":1248507208.6304123},{"$f":"'5 Finanční analýza (FRR_C)'!M7","v":2711011165.5283809},{"$f":"'5 Finanční analýza (FRR_C)'!N7","v":2128055475.9538043},{"$f":"'5 Finanční analýza (FRR_C)'!O7","v":2873078837.9745307},{"$f":"'5 Finanční analýza (FRR_C)'!P7","v":2144223129.0170994},{"$f":"'5 Finanční analýza (FRR_C)'!Q7","v":1284358017.5},{"$f":"'5 Finanční analýza (FRR_C)'!R7","v":1361400948.6250002},{"$f":"'5 Finanční analýza (FRR_C)'!S7","v":1087244659.5250001}]
[null,"B","Přírůstkové celkové provozní příjmy**",{"$f":"E5+NPV(D9,F5:S5,E15:S15)","v":41876306.689175732},{"$f":"IF(E2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!E34+'4 Tržby'!E35),0)","v":-58482914.546676718},{"$f":"IF(F2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!F34+'4 Tržby'!F35),0)","v":-57294236.073257618},{"$f":"IF(G2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!G34+'4 Tržby'!G35),0)","v":-44802775.585950159},{"$f":"IF(H2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!H34+'4 Tržby'!H35),0)","v":-54172897.748213939},{"$f":"IF(I2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!I34+'4 Tržby'!I35),0)","v":-42140293.907201156},{"$f":"IF(J2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!J34+'4 Tržby'!J35),0)","v":-40115941.186313391},{"$f":"IF(K2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!K34+'4 Tržby'!K35),0)","v":-43863102.687600531},{"$f":"IF(L2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!L34+'4 Tržby'!L35),0)","v":-333226.32565824687},{"$f":"IF(M2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!M34+'4 Tržby'!M35),0)","v":-5055764.7066690922},{"$f":"IF(N2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!N34+'4 Tržby'!N35),0)","v":-4599794.2599630952},{"$f":"IF(O2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!O34+'4 Tržby'!O35),0)","v":-2326708.8805234581},{"$f":"IF(P2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!P34+'4 Tržby'!P35),0)","v":-1927108.1130502075},{"$f":"IF(Q2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!Q34+'4 Tržby'!Q35),0)","v":-1527507.3455769271},{"$f":"IF(R2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!R34+'4 Tržby'!R35),0)","v":-1127906.5781036541},{"$f":"IF(S2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!S34+'4 Tržby'!S35),0)","v":-728305.81063041836}]
[null,"C","Přírůstkové celkové provozní náklady*",{"$f":"E6+NPV(D9,F6:S6,E16:S16)","v":-5973807993.3114777},{"$f":"'5 Finanční analýza (FRR_C)'!E6","v":-253338588.96752474},{"$f":"'5 Finanční analýza (FRR_C)'!F6","v":-90124768.027700603},{"$f":"'5 Finanční analýza (FRR_C)'!G6","v":-110348658.14919025},{"$f":"'5 Finanční analýza (FRR_C)'!H6","v":-1223053159.5212038},{"$f":"'5 Finanční analýza (FRR_C)'!I6","v":-227160999.67569423},{"$f":"'5 Finanční analýza (FRR_C)'!J6","v":-252464393.16667694},{"$f":"'5 Finanční analýza (FRR_C)'!K6","v":-110615251.81754988},{"$f":"'5 Finanční analýza (FRR_C)'!L6","v":-178038906.15635085},{"$f":"'5 Finanční analýza (FRR_C)'!M6","v":-216670438.2025125},{"$f":"'5 Finanční analýza (FRR_C)'!N6","v":-264802830.32565701},{"$f":"'5 Finanční analýza (FRR_C)'!O6","v":-395516417.27667946},{"$f":"'5 Finanční analýza (FRR_C)'!P6","v":-303289289.83043301},{"$f":"'5 Finanční analýza (FRR_C)'!Q6","v":-354192294.09431905},{"$f":"'5 Finanční analýza (FRR_C)'!R6","v":-413745062.07696706},{"$f":"'5 Finanční analýza (FRR_C)'!S6","v":-129870112.10264981}]
[null,"D","Čisté provozní příjmy",{"$f":"E7+NPV(D9,F7:S7,E17:S17)","v":6015684300.0006552},{"$f":"E5-E6","v":194855674.42084801},{"$f":"F5-F6","v":32830531.954442985},65545882.563240089,1168880261.7729897,185020705.76849306,212348451.98036355,66752149.129949354,177705679.83069259,211614673.49584341,260203036.06569391,393189708.39615601,301362181.71738279,352664786.7487421,412617155.4988634,129141806.2920194]
[null,"E","Zůstatková hodnota investice",{"$f":"E8+NPV(D9,F8:S8,E18:S18)","v":-2314754803.2280169},{"$f":"IF(E2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(F2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(G2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(H2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(I2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(J2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(K2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(L2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(M2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(N2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(O2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(P2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(Q2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(R2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(S2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0}]
[null,null,"Diskontní faktor",{"$f":"'0 Úvod'!D21","v":0.04},1,{"$f":"1/(1+$D$9)","v":0.96153846153846145},{"$f":"F9/(1+$D$9)","v":0.92455621301775137},{"$f":"G9/(1+$D$9)","v":0.88899635867091475},0.85480419102972571,0.82192710675935166,0.79031452573014582,0.75991781320206331,0.73069020500198389,0.70258673557883067,0.67556416882579873,0.64958093156326802,0.62459704958006534,0.60057408613467822,0.57747508282180593]
[null,"F","Úspora provozních nákladů*",{"$f":"IF((E10+NPV(D9,F10:S10,E20:S20))<=0,0,IF(('6 Kontrola dotací'!E35+NPV(D9,'6 Kontrola dotací'!F35:AC35,'6 Kontrola dotací'!E42:AC42))>=(E10+NPV(D9,F10:S10,E20:S20)),0,-(E10+NPV(D9,F10:S10,E20:S20))+('6 Kontrola dotací'!E38+NPV(D9,'6 Kontrola dotací'!F38:AC38,'6 Kontrola dotací'!E45:AC45))))","v":0},{"$f":"IF(E2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!E34,0)","v":253338588.96752474},{"$f":"IF(F2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!F34,0)","v":90124768.027700603},{"$f":"IF(G2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!G34,0)","v":110348658.14919025},{"$f":"IF(H2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!H34,0)","v":1223053159.5212038},{"$f":"IF(I2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!I34,0)","v":227160999.67569423},{"$f":"IF(J2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!J34,0)","v":252464393.16667694},{"$f":"IF(K2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!K34,0)","v":110615251.81754988},{"$f":"IF(L2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!L34,0)","v":178038906.15635085},{"$f":"IF(M2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!M34,0)","v":216670438.2025125},{"$f":"IF(N2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!N34,0)","v":264802830.32565701},{"$f":"IF(O2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!O34,0)","v":395516417.27667946},{"$f":"IF(P2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!P34,0)","v":303289289.83043301},{"$f":"IF(Q2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!Q34,0)","v":354192294.09431905},{"$f":"IF(R2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!R34,0)","v":413745062.07696706},{"$f":"IF(S2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!S34,0)","v":129870112.10264981}]
[]
[null,"7.1.","Kalkulace finanční mezery a přidělení",null,{"$f":"S2+1","v":2024},{"$f":"E12+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038]
[null,"b","grantu EU (CZK)"]
[null,"A","Investiční náklady (DIC) (z FA)",null,{"$f":"'5 Finanční analýza (FRR_C)'!E19","v":0},{"$f":"'5 Finanční analýza (FRR_C)'!F19","v":0},{"$f":"'5 Finanční analýza (FRR_C)'!G19","v":0},{"$f":"'5 Finanční analýza (FRR_C)'!H19","v":0},{"$f":"'5 Finanční analýza (FRR_C)'!I19","v":0},{"$f":"'5 Finanční analýza (FRR_C)'!J19","v":0},{"$f":"'5 Finanční analýza (FRR_C)'!K19","v":0},{"$f":"'5 Finanční analýza (FRR_C)'!L19","v":0},{"$f":"'5 Finanční analýza (FRR_C)'!M19","v":0},{"$f":"'5 Finanční analýza (FRR_C)'!N19","v":0},{"$f":"'5 Finanční analýza (FRR_C)'!O19","v":0},{"$f":"'5 Finanční analýza (FRR_C)'!P19","v":0},{"$f":"'5 Finanční analýza (FRR_C)'!Q19","v":0},{"$f":"'5 Finanční analýza (FRR_C)'!R19","v":0},{"$f":"'5 Finanční analýza (FRR_C)'!S19","v":0}]
[null,"B","Přírůstkové celkové provozní příjmy**",null,{"$f":"IF(E12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!E41+'4 Tržby'!E42),0)","v":52857212.054577433},{"$f":"IF(F12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!F41+'4 Tržby'!F42),0)","v":53156637.08186008},{"$f":"IF(G12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!G41+'4 Tržby'!G42),0)","v":53456062.109142721},{"$f":"IF(H12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!H41+'4 Tržby'!H42),0)","v":55688647.165000543},{"$f":"IF(I12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!I41+'4 Tržby'!I42),0)","v":55988072.192283198},{"$f":"IF(J12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!J41+'4 Tržby'!J42),0)","v":56287497.219565868},{"$f":"IF(K12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!K41+'4 Tržby'!K42),0)","v":56586922.246848501},{"$f":"IF(L12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!L41+'4 Tržby'!L42),0)","v":56886347.274131149},{"$f":"IF(M12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!M41+'4 Tržby'!M42),0)","v":57185772.301413789},{"$f":"IF(N12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!N41+'4 Tržby'!N42),0)","v":57485197.328696445},{"$f":"IF(O12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!O41+'4 Tržby'!O42),0)","v":57784622.355979115},{"$f":"IF(P12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!P41+'4 Tržby'!P42),0)","v":58084047.38326174},{"$f":"IF(Q12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!Q41+'4 Tržby'!Q42),0)","v":58383472.410544395},{"$f":"IF(R12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!R41+'4 Tržby'!R42),0)","v":58682897.437827036},{"$f":"IF(S12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,('4 Tržby'!S41+'4 Tržby'!S42),0)","v":58982322.465109691}]
[null,"C","Přírůstkové celkové provozní náklady*",null,{"$f":"'5 Finanční analýza (FRR_C)'!E18","v":-1006667224.8187716},{"$f":"'5 Finanční analýza (FRR_C)'!F18","v":-707793278.071365},{"$f":"'5 Finanční analýza (FRR_C)'!G18","v":-164067642.90501136},{"$f":"'5 Finanční analýza (FRR_C)'!H18","v":-218735367.17977315},{"$f":"'5 Finanční analýza (FRR_C)'!I18","v":-206256654.42587796},{"$f":"'5 Finanční analýza (FRR_C)'!J18","v":-395493786.50570649},{"$f":"'5 Finanční analýza (FRR_C)'!K18","v":-241790227.27980602},{"$f":"'5 Finanční analýza (FRR_C)'!L18","v":-292456331.21596521},{"$f":"'5 Finanční analýza (FRR_C)'!M18","v":-394881314.23946863},{"$f":"'5 Finanční analýza (FRR_C)'!N18","v":-317964337.07530069},{"$f":"'5 Finanční analýza (FRR_C)'!O18","v":-301313653.55973232},{"$f":"'5 Finanční analýza (FRR_C)'!P18","v":-253185082.09134543},{"$f":"'5 Finanční analýza (FRR_C)'!Q18","v":-271553020.81560719},{"$f":"'5 Finanční analýza (FRR_C)'!R18","v":-360017672.45897341},{"$f":"'5 Finanční analýza (FRR_C)'!S18","v":-396065892.58479309}]
[null,"D","Čisté provozní příjmy",null,{"$f":"E15-E16","v":1059524436.8733491},{"$f":"F15-F16","v":760949915.15322506},217523705.01415408,274424014.34477371,262244726.61816114,451781283.72527236,298377149.52665454,349342678.49009633,452067086.54088241,375449534.40399712,359098275.9157114,311269129.47460717,329936493.22615159,418700569.89680046,455048215.0499028]
[null,"E","Zůstatková hodnota investice",null,{"$f":"IF(E12='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(F12='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(G12='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(H12='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(I12='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(J12='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(K12='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(L12='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(M12='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(N12='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(O12='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(P12='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(Q12='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(R12='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":0},{"$f":"IF(S12='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$7,0)","v":-7218913427.9942722}]
[null,null,"Diskontní faktor",{"$f":"D9","v":0.04},{"$f":"S9/(1+$D$9)","v":0.55526450271327488},{"$f":"E19/(1+$D$9)","v":0.53390817568584126},{"$f":"F19/(1+$D$9)","v":0.51337324585177047},0.49362812101131776,0.47464242404934398,0.45638694620129228,0.4388336021166272,0.42195538665060306,0.40572633331788754,0.39012147434412264,0.37511680225396404,0.3606892329365039,0.34681657013125372,0.33347747128005162,0.32065141469235731]
[null,"F","Úspora provozních nákladů*",null,{"$f":"IF(E12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!E41,0)","v":1006667224.8187716},{"$f":"IF(F12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!F41,0)","v":707793278.071365},{"$f":"IF(G12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!G41,0)","v":164067642.90501136},{"$f":"IF(H12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!H41,0)","v":218735367.17977315},{"$f":"IF(I12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!I41,0)","v":206256654.42587796},{"$f":"IF(J12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!J41,0)","v":395493786.50570649},{"$f":"IF(K12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!K41,0)","v":241790227.27980602},{"$f":"IF(L12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!L41,0)","v":292456331.21596521},{"$f":"IF(M12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!M41,0)","v":394881314.23946863},{"$f":"IF(N12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!N41,0)","v":317964337.07530069},{"$f":"IF(O12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!O41,0)","v":301313653.55973232},{"$f":"IF(P12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!P41,0)","v":253185082.09134543},{"$f":"IF(Q12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!Q41,0)","v":271553020.81560719},{"$f":"IF(R12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!R41,0)","v":360017672.45897341},{"$f":"IF(S12<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Kontrola dotací'!S41,0)","v":396065892.58479309}]
[]
[]
[null,"7.2.","Kalkulace veřejného příspěvku (CZK) - stálé ceny",null,null,null,"CZK","EUR",null,"Komentáře"]
[null,null,"Způsobilé náklady***",null,null,null,{"$f":"'1 Celkové investiční náklady'!F11*('1 Celkové investiční náklady'!E45/'1 Celkové investiční náklady'!F45)","v":{"$error":"#DIV/0!"}},{"$f":"G24/'0 Úvod'!N19","v":{"$error":"#DIV/0!"}},null,"* v případě vynechání dle čl. 61 Nařízení (EU) č. 1303/2013, musí být poskytnuta ukázka úměrného snížení dotací na základě shody s hodnotami cash-flow z tabulky \"Provozní náklady\""]
[null,null,"Míra finanční mezery ((DIC bez rezervy- čisté příjmy)/DIC bez rezervy)",null,null,null,{"$f":"IF(D6>D5,1,IF(D6>0,ROUND((D4-(D5-D6)*('1 Celkové investiční náklady'!$E$45/'1 Celkové investiční náklady'!$F$45)+D8*('1 Celkové investiční náklady'!$E$45/'1 Celkové investiční náklady'!$F$45))/D4,4),IF(ROUND((D4-(D5-D10)*('1 Celkové investiční náklady'!$E$45/'1 Celkové investiční náklady'!$F$45)+D8)*('1 Celkové investiční náklady'!$E$45/'1 Celkové investiční náklady'!$F$45)/D4,4)>1,1,ROUND((D4-(D5-D10)*('1 Celkové investiční náklady'!$E$45/'1 Celkové investiční náklady'!$F$45)+D8*('1 Celkové investiční náklady'!$E$45/'1 Celkové investiční náklady'!$F$45))/D4,4))))","v":{"$error":"#DIV/0!"}}]
[null,null,"Rozhodná částka (způsobilé náklady*R)",null,null,null,{"$f":"ROUND(G24*G25,0)","v":{"$error":"#DIV/0!"}},{"$f":"G26/'0 Úvod'!N19","v":{"$error":"#DIV/0!"}},null,"** tržby hrazené přímo uživateli,  čl. 61 Nařízení (EU) č. 1303/2013 a příloha V Nařízení (EU) č. 1303/2013 a oddíl III Nařízení Komise v přenesené pravomoci (EU) č. 480/2014; příjmy jsou sníženy v poměru způsobilých nákladů"]
[null,null,"Míra spolufinancování prioritních os (%)",null,null,null,0.85]
[null,null,"Příspěvek Společenství",null,null,null,{"$f":"FLOOR(G26*G27,1)","v":{"$error":"#DIV/0!"}},{"$f":"G28/'0 Úvod'!N19","v":{"$error":"#DIV/0!"}},null,"*** jedná se o procentuální odhad způsobilých nákladů ve stálých cenách, který vychází ze skutečného poměru způsobilých a nezpůsobilých nákladů v běžných cenách z tabulky způsobilosti nákladů (list \"1 Celkové investiční náklady\" tabulka 1.2)"]
[]
[null,"7.3.","Kalkulace veřejného příspěvku (CZK) - běžné ceny",null,null,null,"CZK","EUR"]
[null,null,"Způsobilé náklady",null,null,null,{"$f":"'1 Celkové investiční náklady'!E45","v":0},{"$f":"G31/'0 Úvod'!N19","v":0}]
[null,null,"Míra finanční mezery ((DIC bez rezervy- čisté příjmy)/DIC bez rezervy)",null,null,null,{"$f":"G25","v":{"$error":"#DIV/0!"}}]
[null,null,"Rozhodná částka (způsobilé náklady*R)",null,null,null,{"$f":"ROUND(G31*G32,0)","v":{"$error":"#DIV/0!"}},{"$f":"G33/'0 Úvod'!N19","v":{"$error":"#DIV/0!"}}]
[null,null,"Míra spolufinancování prioritních os (%)",null,null,null,{"$f":"G27","v":0.85}]
[null,null,"Příspěvek Společenství",null,null,null,{"$f":"FLOOR(G33*G34,2)","v":{"$error":"#DIV/0!"}},{"$f":"G35/'0 Úvod'!N19","v":{"$error":"#DIV/0!"}}]

{"sheet":"8 Finanční struktura","index":8,"n_rows":65,"n_cols":20,"rows_kept":65,"cut":false,"hidden":false,"merged":[[1,19,2,19],[32,19,33,19],[47,18,48,18],[16,18,17,18],[62,1,63,3],[47,4,48,4],[47,5,48,5],[47,6,48,6],[47,7,48,7],[47,8,48,8],[47,9,48,9],[47,10,48,10],[47,11,48,11],[16,4,17,4],[16,5,17,5],[16,6,17,6],[1,18,2,18],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,10,2,10],[1,11,2,11],[1,12,2,12],[1,13,2,13],[1,17,2,17],[16,14,17,14],[16,15,17,15],[16,16,17,16],[16,17,17,17],[1,14,2,14],[1,15,2,15],[1,16,2,16],[16,13,17,13],[1,8,2,8],[1,9,2,9],[32,4,33,4],[32,5,33,5],[32,6,33,6],[32,7,33,7],[16,7,17,7],[16,8,17,8],[16,9,17,9],[16,10,17,10],[16,11,17,11],[16,12,17,12],[32,18,33,18],[32,8,33,8],[32,9,33,9],[32,10,33,10],[32,11,33,11],[32,13,33,13],[32,12,33,12],[47,17,48,17],[32,14,33,14],[32,15,33,15],[32,16,33,16],[32,17,33,17],[47,13,48,13],[47,12,48,12],[47,14,48,14],[47,15,48,15],[47,16,48,16]]}
[]
[null,"8.1.","Zdroje financování investičních nákladů (CZK)",{"$f":"'0 Úvod'!D19","v":2016},{"$f":"'0 Úvod'!G19","v":2009},{"$f":"E2+1","v":2010},2011,2012,{"$f":"H2+1","v":2013},2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,"Kontrolní suma*"]
[null,"a","Konstantní ceny","Celkem"]
[null,null,"Vlastní zdroje",{"$f":"SUM(E4:S4,E19:S19)","v":0}]
[null,null,"Ostatní zdroje",{"$f":"SUM(E5:S5,E20:S20)","v":0}]
[null,null,"Celkové zdroje žadatele",0,{"$f":"E5+E4","v":0},0,0,0,0,0,0,0,0,0,{"$f":"O5+O4","v":0},0,0,0,{"$f":"S5+S4","v":0}]
[null,null,"Úvěr (poskytnutý státní správou)",0]
[null,null,"Zdroje státního rozpočtu",0]
[null,null,"Národní zdroje",0,{"$f":"E8+E7","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"S8+S7","v":0}]
[null,null,"Granty EU",0]
[null,null,"Celkové finanční zdroje (bez rezervy) ",0,{"$f":"E6+E9+E10","v":0},{"$f":"F6+F9+F10","v":0},{"$f":"G6+G9+G10","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"S6+S9+S10","v":0},{"$f":"IF(D11='1 Celkové investiční náklady'!F11,\"OK\",\"CHYBA!\")","v":"CHYBA!"}]
[null,null,"Rezerva - vlastní zdroje",0]
[null,null,"Rezerva - EU granty",0]
[null,null,"Rezerva celkem",0,{"$f":"E12+E13","v":0},{"$f":"F12+F13","v":0},{"$f":"G12+G13","v":0},{"$f":"H12+H13","v":0},{"$f":"I12+I13","v":0},0,0,0,0,0,0,0,0,0,{"$f":"S12+S13","v":0}]
[null,null,"Celkové finanční zdroje",0,{"$f":"E11+E14","v":0},{"$f":"F11+F14","v":0},{"$f":"G11+G14","v":0},{"$f":"H11+H14","v":0},{"$f":"I11+I14","v":0},0,0,0,0,0,0,0,0,0,{"$f":"S11+S14","v":0},{"$f":"IF(D15='1 Celkové investiční náklady'!F13,\"OK\",\"CHYBA!\")","v":"CHYBA!"}]
[]
[null,"8.1.","Zdroje financování investičních nákladů  (CZK)",{"$f":"D2","v":2016},{"$f":"S2+1","v":2024},{"$f":"E17+1","v":2025},2026,2027,{"$f":"H17+1","v":2028},2029,2030,2031,2032,2033,2034,2035,2036,2037,2038]
[null,"b","Konstantní ceny"]
[null,null,"Vlastní zdroje"]
[null,null,"Ostatní zdroje"]
[null,null,"Celkové zdroje žadatele",null,{"$f":"E20+E19","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"S20+S19","v":0}]
[null,null,"Úvěr (poskytnutý státní správou)"]
[null,null,"Zdroje státního rozpočtu"]
[null,null,"Národní zdroje",null,{"$f":"E23+E22","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"S23+S22","v":0}]
[null,null,"Granty EU"]
[null,null,"Celkové finanční zdroje (bez rezervy) ",null,{"$f":"E21+E24+E25","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"S21+S24+S25","v":0}]
[null,null,"Rezerva - vlastní zdroje"]
[null,null,"Rezerva - EU granty"]
[null,null,"Rezerva celkem",null,{"$f":"E27+E28","v":0},{"$f":"F27+F28","v":0},{"$f":"G27+G28","v":0},{"$f":"H27+H28","v":0},{"$f":"I27+I28","v":0},0,0,0,0,0,0,0,0,0,{"$f":"S27+S28","v":0}]
[null,null,"Celkové finanční zdroje",null,{"$f":"E26+E29","v":0},{"$f":"F26+F29","v":0},{"$f":"G26+G29","v":0},{"$f":"H26+H29","v":0},{"$f":"I26+I29","v":0},0,0,0,0,0,0,0,0,0,{"$f":"S26+S29","v":0}]
[]
[]
[null,"8.2.","Zdroje financování investičních nákladů  (CZK)",null,{"$f":"E2","v":2009},{"$f":"E33+1","v":2010},2011,2012,{"$f":"H33+1","v":2013},2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,"Kontrolní suma*"]
[null,"a","Běžné ceny","Celkem"]
[null,null,"Vlastní zdroje",{"$f":"SUM(E35:S35,E50:S50)","v":0}]
[null,null,"Ostatní zdroje",{"$f":"SUM(E36:S36,E51:S51)","v":0}]
[null,null,"Celkové zdroje žadatele",0,{"$f":"E36+E35","v":0},{"$f":"F36+F35","v":0},{"$f":"G36+G35","v":0},{"$f":"H36+H35","v":0},{"$f":"I36+I35","v":0},0,0,0,0,0,0,0,0,0,{"$f":"S36+S35","v":0}]
[null,null,"Úvěr (poskytnutý státní správou)",0]
[null,null,"Zdroje státního rozpočtu",0]
[null,null,"Národní zdroje",0,{"$f":"E39+E38","v":0},{"$f":"F39+F38","v":0},{"$f":"G39+G38","v":0},{"$f":"H39+H38","v":0},{"$f":"I39+I38","v":0},0,0,0,0,0,0,0,0,0,{"$f":"S39+S38","v":0}]
[null,null,"Granty EU",0]
[null,null,"Celkové finanční zdroje (bez rezervy) ",0,{"$f":"E37+E40+E41","v":0},{"$f":"F37+F40+F41","v":0},{"$f":"G37+G40+G41","v":0},{"$f":"H37+H40+H41","v":0},{"$f":"I37+I40+I41","v":0},0,0,0,0,0,0,0,0,0,{"$f":"S37+S40+S41","v":0},{"$f":"IF(D42=('1 Celkové investiční náklady'!F45-'1 Celkové investiční náklady'!F40),\"OK\",\"CHYBA!\")","v":"OK"}]
[null,null,"Rezerva - vlastní zdroje",0]
[null,null,"Rezerva - EU granty",0]
[null,null,"Rezerva celkem",0,{"$f":"E43+E44","v":0},{"$f":"F43+F44","v":0},{"$f":"G43+G44","v":0},{"$f":"H43+H44","v":0},{"$f":"I43+I44","v":0},0,0,0,0,0,0,0,0,0,{"$f":"S43+S44","v":0}]
[null,null,"Celkové finanční zdroje",0,{"$f":"E42+E45","v":0},{"$f":"F42+F45","v":0},{"$f":"G42+G45","v":0},{"$f":"H42+H45","v":0},{"$f":"I42+I45","v":0},0,0,0,0,0,0,0,0,0,{"$f":"S42+S45","v":0},{"$f":"IF(D46='1 Celkové investiční náklady'!F45,\"OK\",\"CHYBA!\")","v":"OK"}]
[]
[null,"8.2.","Zdroje financování investičních nákladů  (CZK)",null,{"$f":"E17","v":2024},{"$f":"E48+1","v":2025},2026,2027,{"$f":"H48+1","v":2028},2029,2030,2031,2032,2033,2034,2035,2036,2037,2038]
[null,"b","Běžné ceny"]
[null,null,"Vlastní zdroje"]
[null,null,"Ostatní zdroje"]
[null,null,"Celkové zdroje žadatele",null,{"$f":"E51+E50","v":0},{"$f":"F51+F50","v":0},{"$f":"G51+G50","v":0},{"$f":"H51+H50","v":0},{"$f":"I51+I50","v":0},0,0,0,0,0,0,0,0,0,{"$f":"S51+S50","v":0}]
[null,null,"Úvěr (poskytnutý státní správou)"]
[null,null,"Zdroje státního rozpočtu"]
[null,null,"Národní zdroje",null,{"$f":"E54+E53","v":0},{"$f":"F54+F53","v":0},{"$f":"G54+G53","v":0},{"$f":"H54+H53","v":0},{"$f":"I54+I53","v":0},0,0,0,0,0,0,0,0,0,{"$f":"S54+S53","v":0}]
[null,null,"Granty EU"]
[null,null,"Celkové finanční zdroje (bez rezervy) ",null,{"$f":"E52+E55+E56","v":0},{"$f":"F52+F55+F56","v":0},{"$f":"G52+G55+G56","v":0},{"$f":"H52+H55+H56","v":0},{"$f":"I52+I55+I56","v":0},0,0,0,0,0,0,0,0,0,{"$f":"S52+S55+S56","v":0}]
[null,null,"Rezerva - vlastní zdroje"]
[null,null,"Rezerva - EU granty"]
[null,null,"Rezerva celkem",null,{"$f":"E58+E59","v":0},{"$f":"F58+F59","v":0},{"$f":"G58+G59","v":0},{"$f":"H58+H59","v":0},{"$f":"I58+I59","v":0},0,0,0,0,0,0,0,0,0,{"$f":"S58+S59","v":0}]
[null,null,"Celkové finanční zdroje",null,{"$f":"E57+E60","v":0},{"$f":"F57+F60","v":0},{"$f":"G57+G60","v":0},{"$f":"H57+H60","v":0},{"$f":"I57+I60","v":0},0,0,0,0,0,0,0,0,0,{"$f":"S57+S60","v":0}]
[]
[null,"Komentáře"]
[]
[null,"* kontrola souladu celk. finančních zdrojů s celk. investičními náklady"]

{"sheet":"9 Udržitelnost","index":9,"n_rows":34,"n_cols":19,"rows_kept":34,"cut":false,"hidden":false,"merged":[[18,18,19,18],[18,13,19,13],[18,14,19,14],[18,15,19,15],[18,16,19,16],[18,9,19,9],[18,10,19,10],[18,11,19,11],[18,12,19,12],[18,17,19,17],[18,4,19,4],[18,5,19,5],[18,6,19,6],[18,7,19,7],[18,8,19,8],[1,16,2,16],[1,17,2,17],[1,14,2,14],[1,15,2,15],[1,18,2,18],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,12,2,12],[1,13,2,13],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8]]}
[" "]
[null,"9.1.","Udržitelnost projektu (CZK)",null,{"$f":"'0 Úvod'!G19","v":2009},{"$f":"E2+1","v":2010},2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023]
[null,"a","Stálé ceny","Total"]
[null,null,"Provozní příjmy",{"$f":"SUM(E4:S4,E21:S21)","v":4925477976.6678762},{"$f":"'4 Tržby'!E7","v":92914842.788899988},{"$f":"'4 Tržby'!F7","v":91896080.601339996},{"$f":"'4 Tržby'!G7","v":103332120.60766001},{"$f":"'4 Tržby'!H7","v":92451210.806863219},{"$f":"'4 Tržby'!I7","v":104483814.64787599},{"$f":"'4 Tržby'!J7","v":108524827.26954201},{"$f":"'4 Tržby'!K7","v":104975277.68228699},{"$f":"'4 Tržby'!L7","v":149479850.16409323},{"$f":"'4 Tržby'!M7","v":152723121.13716573},{"$f":"'4 Tržby'!N7","v":153692693.23766071},{"$f":"'4 Tržby'!O7","v":156479380.27088928},{"$f":"'4 Tržby'!P7","v":157392582.69215149},{"$f":"'4 Tržby'!Q7","v":158305785.11341375},{"$f":"'4 Tržby'!R7","v":159218987.53467596},{"$f":"'4 Tržby'!S7","v":160132189.95593816}]
[null,null,"Úvěry",{"$f":"SUM(E5:S5,E22:S22)","v":0},{"$f":"'8 Finanční struktura'!E7","v":0},{"$f":"'8 Finanční struktura'!F7","v":0},{"$f":"'8 Finanční struktura'!G7","v":0},{"$f":"'8 Finanční struktura'!H7","v":0},{"$f":"'8 Finanční struktura'!I7","v":0},{"$f":"'8 Finanční struktura'!J7","v":0},{"$f":"'8 Finanční struktura'!K7","v":0},{"$f":"'8 Finanční struktura'!L7","v":0},{"$f":"'8 Finanční struktura'!M7","v":0},{"$f":"'8 Finanční struktura'!N7","v":0},{"$f":"'8 Finanční struktura'!O7","v":0},{"$f":"'8 Finanční struktura'!P7","v":0},{"$f":"'8 Finanční struktura'!Q7","v":0},{"$f":"'8 Finanční struktura'!R7","v":0},{"$f":"'8 Finanční struktura'!S7","v":0}]
[" ",null,"Celkové zdroje žadatele",0,{"$f":"'8 Finanční struktura'!E6","v":0},{"$f":"'8 Finanční struktura'!F6","v":0},{"$f":"'8 Finanční struktura'!G6","v":0},{"$f":"'8 Finanční struktura'!H6","v":0},{"$f":"'8 Finanční struktura'!I6","v":0},{"$f":"'8 Finanční struktura'!J6","v":0},{"$f":"'8 Finanční struktura'!K6","v":0},{"$f":"'8 Finanční struktura'!L6","v":0},{"$f":"'8 Finanční struktura'!M6","v":0},{"$f":"'8 Finanční struktura'!N6","v":0},{"$f":"'8 Finanční struktura'!O6","v":0},{"$f":"'8 Finanční struktura'!P6","v":0},{"$f":"'8 Finanční struktura'!Q6","v":0},{"$f":"'8 Finanční struktura'!R6","v":0},{"$f":"'8 Finanční struktura'!S6","v":0}]
[" ",null,"Zdroje státního rozpočtu",0,{"$f":"'8 Finanční struktura'!E8","v":0},{"$f":"'8 Finanční struktura'!F8","v":0},{"$f":"'8 Finanční struktura'!G8","v":0},{"$f":"'8 Finanční struktura'!H8","v":0},{"$f":"'8 Finanční struktura'!I8","v":0},{"$f":"'8 Finanční struktura'!J8","v":0},{"$f":"'8 Finanční struktura'!K8","v":0},{"$f":"'8 Finanční struktura'!L8","v":0},{"$f":"'8 Finanční struktura'!M8","v":0},{"$f":"'8 Finanční struktura'!N8","v":0},{"$f":"'8 Finanční struktura'!O8","v":0},{"$f":"'8 Finanční struktura'!P8","v":0},{"$f":"'8 Finanční struktura'!Q8","v":0},{"$f":"'8 Finanční struktura'!R8","v":0},{"$f":"'8 Finanční struktura'!S8","v":0}]
[" ",null,"Granty EU",0,{"$f":"'8 Finanční struktura'!E10","v":0},{"$f":"'8 Finanční struktura'!F10","v":0},{"$f":"'8 Finanční struktura'!G10","v":0},{"$f":"'8 Finanční struktura'!H10","v":0},{"$f":"'8 Finanční struktura'!I10","v":0},{"$f":"'8 Finanční struktura'!J10","v":0},{"$f":"'8 Finanční struktura'!K10","v":0},{"$f":"'8 Finanční struktura'!L10","v":0},{"$f":"'8 Finanční struktura'!M10","v":0},{"$f":"'8 Finanční struktura'!N10","v":0},{"$f":"'8 Finanční struktura'!O10","v":0},{"$f":"'8 Finanční struktura'!P10","v":0},{"$f":"'8 Finanční struktura'!Q10","v":0},{"$f":"'8 Finanční struktura'!R10","v":0},{"$f":"'8 Finanční struktura'!S10","v":0}]
[null,null,"Dotace",2341746371.2802372,{"$f":"'6 Kontrola dotací'!E7","v":165720664.42637718},{"$f":"'6 Kontrola dotací'!F7","v":173078534.05667275},{"$f":"'6 Kontrola dotací'!G7","v":205765352.24099773},{"$f":"'6 Kontrola dotací'!H7","v":136452484.21262258},{"$f":"'6 Kontrola dotací'!I7","v":112527901.27820906},{"$f":"'6 Kontrola dotací'!J7","v":148095376.35933343},{"$f":"'6 Kontrola dotací'!K7","v":154027702.89401305},{"$f":"'6 Kontrola dotací'!L7","v":106841034.10343447},{"$f":"'6 Kontrola dotací'!M7","v":103597763.13036197},{"$f":"'6 Kontrola dotací'!N7","v":102628191.02986699},{"$f":"'6 Kontrola dotací'!O7","v":89843933.745990574},{"$f":"'6 Kontrola dotací'!P7","v":90957059.897725075},{"$f":"'6 Kontrola dotací'!Q7","v":92119757.701777697},{"$f":"'6 Kontrola dotací'!R7","v":93333261.016646445},{"$f":"'6 Kontrola dotací'!S7","v":101634470.16910231}]
[null,null,"Celkové příjmy",7267224347.9481134,{"$f":"SUM(E4:E9)","v":258635507.21527717},{"$f":"SUM(F4:F9)","v":264974614.65801275},309097472.84865773,228903695.0194858,217011715.92608505,256620203.62887543,259002980.57630002,256320884.2675277,256320884.2675277,256320884.2675277,246323314.01687986,248349642.58987656,250425542.81519145,252552248.5513224,261766660.12504047]
[null,null,"Celkové provozní náklady",7267224347.9481134,{"$f":"'3 Provozní náklady'!E7","v":258635507.21527717},{"$f":"'3 Provozní náklady'!F7","v":264974614.65801275},{"$f":"'3 Provozní náklady'!G7","v":309097472.84865773},{"$f":"'3 Provozní náklady'!H7","v":228903695.0194858},{"$f":"'3 Provozní náklady'!I7","v":217011715.92608505},{"$f":"'3 Provozní náklady'!J7","v":256620203.62887543},{"$f":"'3 Provozní náklady'!K7","v":259002980.57630002},{"$f":"'3 Provozní náklady'!L7","v":256320884.2675277},{"$f":"'3 Provozní náklady'!M7","v":256320884.2675277},{"$f":"'3 Provozní náklady'!N7","v":256320884.2675277},{"$f":"'3 Provozní náklady'!O7","v":246323314.01687986},{"$f":"'3 Provozní náklady'!P7","v":248349642.58987656},{"$f":"'3 Provozní náklady'!Q7","v":250425542.81519145},{"$f":"'3 Provozní náklady'!R7","v":252552248.5513224},{"$f":"'3 Provozní náklady'!S7","v":261766660.12504047}]
[null,null,"Celkové investiční náklady",26380458669.080444,{"$f":"'1 Celkové investiční náklady'!G11","v":1821800582.6248858},{"$f":"'1 Celkové investiční náklady'!H11","v":2911281210.0714498},{"$f":"'1 Celkové investiční náklady'!I11","v":2610955271.669632},{"$f":"'1 Celkové investiční náklady'!J11","v":1502053609.8226175},{"$f":"'1 Celkové investiční náklady'!K11","v":655394015.64399409},{"$f":"'1 Celkové investiční náklady'!L11","v":695322644.91248941},{"$f":"'1 Celkové investiční náklady'!M11","v":1345771891.5811446},{"$f":"'1 Celkové investiční náklady'!N11","v":1248507208.6304123},{"$f":"'1 Celkové investiční náklady'!O11","v":2711011165.5283809},{"$f":"'1 Celkové investiční náklady'!P11","v":2128055475.9538043},{"$f":"'1 Celkové investiční náklady'!Q11","v":2873078837.9745307},{"$f":"'1 Celkové investiční náklady'!R11","v":2144223129.0170994},{"$f":"'1 Celkové investiční náklady'!S11","v":1284358017.5},{"$f":"'1 Celkové investiční náklady'!T11","v":1361400948.6250002},{"$f":"'1 Celkové investiční náklady'!U11","v":1087244659.5250001}]
[null,null,"Splácení jistiny úvěru",0]
[null,null,"Splácení úroků z úvěru",0]
[null,null,"Celkové výdaje",33647683017.028549,{"$f":"SUM(E11:E14)","v":2080436089.840163},{"$f":"SUM(F11:F14)","v":3176255824.7294626},2920052744.5182896,1730957304.8421032,872405731.57007909,951942848.54136491,1604774872.1574445,1504828092.8979402,2967332049.7959085,2384376360.2213321,3119402151.9914107,2392572771.606976,1534783560.3151915,1613953197.1763227,1349011319.6500406]
[null,null,"Cash Flow pro příslušný rok",-26380458669.080444,{"$f":"E10-E15","v":-1821800582.6248858},-2911281210.0714498,-2610955271.669632,-1502053609.8226175,-655394015.64399409,-695322644.91248941,-1345771891.5811443,-1248507208.6304126,-2711011165.5283809,-2128055475.9538045,-2873078837.9745307,-2144223129.0170994,-1284358017.5,-1361400948.6250002,-1087244659.5250001]
[null,null,"Kumulované Cash Flow ",null,{"$f":"E16","v":-1821800582.6248858},{"$f":"F16+E17","v":-4733081792.6963358},{"$f":"G16+F17","v":-7344037064.3659678},-8846090674.1885853,-9501484689.8325787,-10196807334.745068,-11542579226.326212,-12791086434.956625,-15502097600.485006,-17630153076.438812,-20503231914.413342,-22647455043.430443,-23931813060.930443,-25293214009.555443,-26380458669.080444]
[]
[null,"9.1.","Udržitelnost projektu (CZK)",null,{"$f":"S2+1","v":2024},{"$f":"E19+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038]
[null,"b","Stálé ceny"]
[null,null,"Provozní příjmy",null,{"$f":"'4 Tržby'!E14","v":195716689.59004623},{"$f":"'4 Tržby'!F14","v":196133116.90725315},{"$f":"'4 Tržby'!G14","v":196549544.22446004},{"$f":"'4 Tržby'!H14","v":196965971.54166695},{"$f":"'4 Tržby'!I14","v":197382398.8588739},{"$f":"'4 Tržby'!J14","v":197798826.17608082},{"$f":"'4 Tržby'!K14","v":198215253.49328774},{"$f":"'4 Tržby'!L14","v":198631680.81049466},{"$f":"'4 Tržby'!M14","v":199048108.12770158},{"$f":"'4 Tržby'!N14","v":199464535.4449085},{"$f":"'4 Tržby'!O14","v":199880962.76211542},{"$f":"'4 Tržby'!P14","v":200297390.07932234},{"$f":"'4 Tržby'!Q14","v":200713817.39652926},{"$f":"'4 Tržby'!R14","v":201130244.71373615},{"$f":"'4 Tržby'!S14","v":201546672.0309431}]
[null,null,"Úvěry",null,{"$f":"'8 Finanční struktura'!E22","v":0},{"$f":"'8 Finanční struktura'!F22","v":0},{"$f":"'8 Finanční struktura'!G22","v":0},{"$f":"'8 Finanční struktura'!H22","v":0},{"$f":"'8 Finanční struktura'!I22","v":0},{"$f":"'8 Finanční struktura'!J22","v":0},{"$f":"'8 Finanční struktura'!K22","v":0},{"$f":"'8 Finanční struktura'!L22","v":0},{"$f":"'8 Finanční struktura'!M22","v":0},{"$f":"'8 Finanční struktura'!N22","v":0},{"$f":"'8 Finanční struktura'!O22","v":0},{"$f":"'8 Finanční struktura'!P22","v":0},{"$f":"'8 Finanční struktura'!Q22","v":0},{"$f":"'8 Finanční struktura'!R22","v":0},{"$f":"'8 Finanční struktura'!S22","v":0}]
[null,null,"Celkové zdroje žadatele",null,{"$f":"'8 Finanční struktura'!E21","v":0},{"$f":"'8 Finanční struktura'!F21","v":0},{"$f":"'8 Finanční struktura'!G21","v":0},{"$f":"'8 Finanční struktura'!H21","v":0},{"$f":"'8 Finanční struktura'!S21","v":0},{"$f":"'8 Finanční struktura'!T21","v":0},{"$f":"'8 Finanční struktura'!U21","v":0},{"$f":"'8 Finanční struktura'!V21","v":0},{"$f":"'8 Finanční struktura'!W21","v":0},{"$f":"'8 Finanční struktura'!X21","v":0},{"$f":"'8 Finanční struktura'!Y21","v":0},{"$f":"'8 Finanční struktura'!Z21","v":0},{"$f":"'8 Finanční struktura'!AA21","v":0},{"$f":"'8 Finanční struktura'!AB21","v":0},{"$f":"'8 Finanční struktura'!AC21","v":0}]
[null,null,"Zdroje státního rozpočtu",null,{"$f":"'8 Finanční struktura'!E23","v":0},{"$f":"'8 Finanční struktura'!F23","v":0},{"$f":"'8 Finanční struktura'!G23","v":0},{"$f":"'8 Finanční struktura'!H23","v":0},{"$f":"'8 Finanční struktura'!S23","v":0},{"$f":"'8 Finanční struktura'!T23","v":0},{"$f":"'8 Finanční struktura'!U23","v":0},{"$f":"'8 Finanční struktura'!V23","v":0},{"$f":"'8 Finanční struktura'!W23","v":0},{"$f":"'8 Finanční struktura'!X23","v":0},{"$f":"'8 Finanční struktura'!Y23","v":0},{"$f":"'8 Finanční struktura'!Z23","v":0},{"$f":"'8 Finanční struktura'!AA23","v":0},{"$f":"'8 Finanční struktura'!AB23","v":0},{"$f":"'8 Finanční struktura'!AC23","v":0}]
[" ",null,"Granty EU",null,{"$f":"'8 Finanční struktura'!E25","v":0},{"$f":"'8 Finanční struktura'!F25","v":0},{"$f":"'8 Finanční struktura'!G25","v":0},{"$f":"'8 Finanční struktura'!H25","v":0},{"$f":"'8 Finanční struktura'!S25","v":0},{"$f":"'8 Finanční struktura'!T25","v":0},{"$f":"'8 Finanční struktura'!U25","v":0},{"$f":"'8 Finanční struktura'!V25","v":0},{"$f":"'8 Finanční struktura'!W25","v":0},{"$f":"'8 Finanční struktura'!X25","v":0},{"$f":"'8 Finanční struktura'!Y25","v":0},{"$f":"'8 Finanční struktura'!Z25","v":0},{"$f":"'8 Finanční struktura'!AA25","v":0},{"$f":"'8 Finanční struktura'!AB25","v":0},{"$f":"'8 Finanční struktura'!AC25","v":0}]
[null,null,"Dotace",null,{"$f":"'6 Kontrola dotací'!E14","v":18937317.604519516},{"$f":"'6 Kontrola dotací'!F14","v":20583816.55766964},{"$f":"'6 Kontrola dotací'!G14","v":22265371.548031181},{"$f":"'6 Kontrola dotací'!H14","v":23982776.390936583},{"$f":"'6 Kontrola dotací'!I14","v":25736844.334173828},{"$f":"'6 Kontrola dotací'!J14","v":27528408.541732848},{"$f":"'6 Kontrola dotací'!K14","v":29078396.291755497},{"$f":"'6 Kontrola dotací'!L14","v":30655011.694987178},{"$f":"'6 Kontrola dotací'!M14","v":32258723.801251292},{"$f":"'6 Kontrola dotací'!N14","v":33890010.723851562},{"$f":"'6 Kontrola dotací'!O14","v":35549359.81925416},{"$f":"'6 Kontrola dotací'!P14","v":37237267.870355129},{"$f":"'6 Kontrola dotací'!Q14","v":39826672.086317718},{"$f":"'6 Kontrola dotací'!R14","v":42458744.316685468},{"$f":"'6 Kontrola dotací'!S14","v":45134163.43558386}]
[null,null,"Celkové příjmy",null,{"$f":"SUM(E21:E26)","v":214654007.19456574},{"$f":"SUM(F21:F26)","v":216716933.46492279},218814915.77249122,220948747.93260354,223119243.19304773,225327234.71781367,227293649.78504324,229286692.50548184,231306831.92895287,233354546.16876006,235430322.58136958,237534657.94967747,240540489.48284698,243588989.03042161,246680835.46652696]
[null,null,"Celkové provozní náklady",null,{"$f":"'3 Provozní náklady'!E14","v":214654007.19456574},{"$f":"'3 Provozní náklady'!F14","v":216716933.46492279},{"$f":"'3 Provozní náklady'!G14","v":218814915.77249122},{"$f":"'3 Provozní náklady'!H14","v":220948747.93260354},{"$f":"'3 Provozní náklady'!I14","v":223119243.19304773},{"$f":"'3 Provozní náklady'!J14","v":225327234.71781367},{"$f":"'3 Provozní náklady'!K14","v":227293649.78504324},{"$f":"'3 Provozní náklady'!L14","v":229286692.50548184},{"$f":"'3 Provozní náklady'!M14","v":231306831.92895287},{"$f":"'3 Provozní náklady'!N14","v":233354546.16876006},{"$f":"'3 Provozní náklady'!O14","v":235430322.58136958},{"$f":"'3 Provozní náklady'!P14","v":237534657.94967747},{"$f":"'3 Provozní náklady'!Q14","v":240540489.48284698},{"$f":"'3 Provozní náklady'!R14","v":243588989.03042161},{"$f":"'3 Provozní náklady'!S14","v":246680835.46652696}]
[null,null,"Celkové investiční náklady",null,{"$f":"'1 Celkové investiční náklady'!G26","v":0},{"$f":"'1 Celkové investiční náklady'!H26","v":0},{"$f":"'1 Celkové investiční náklady'!I26","v":0},{"$f":"'1 Celkové investiční náklady'!J26","v":0},{"$f":"'1 Celkové investiční náklady'!K26","v":0},{"$f":"'1 Celkové investiční náklady'!L26","v":0},{"$f":"'1 Celkové investiční náklady'!M26","v":0},{"$f":"'1 Celkové investiční náklady'!N26","v":0},{"$f":"'1 Celkové investiční náklady'!O26","v":0},{"$f":"'1 Celkové investiční náklady'!P26","v":0},{"$f":"'1 Celkové investiční náklady'!Q26","v":0},{"$f":"'1 Celkové investiční náklady'!R26","v":0},{"$f":"'1 Celkové investiční náklady'!S26","v":0},{"$f":"'1 Celkové investiční náklady'!T26","v":0},{"$f":"'1 Celkové investiční náklady'!U26","v":0}]
[null,null,"Splácení jistiny úvěru"]
[null,null,"Splácení úroků z úvěru"]
[null,null,"Celkové výdaje",null,{"$f":"SUM(E28:E31)","v":214654007.19456574},{"$f":"SUM(F28:F31)","v":216716933.46492279},218814915.77249122,220948747.93260354,223119243.19304773,225327234.71781367,227293649.78504324,229286692.50548184,231306831.92895287,233354546.16876006,235430322.58136958,237534657.94967747,240540489.48284698,243588989.03042161,246680835.46652696]
[null,null,"Cash Flow pro příslušný rok",null,{"$f":"E27-E32","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Kumulované Cash Flow ",null,{"$f":"E33+S17","v":-26380458669.080444},{"$f":"F33+E34","v":-26380458669.080444},{"$f":"G33+F34","v":-26380458669.080444},-26380458669.080444,-26380458669.080444,-26380458669.080444,-26380458669.080444,-26380458669.080444,-26380458669.080444,-26380458669.080444,-26380458669.080444,-26380458669.080444,-26380458669.080444,-26380458669.080444,-26380458669.080444]

{"sheet":"10 FRR_K","index":10,"n_rows":33,"n_cols":19,"rows_kept":33,"cut":false,"hidden":false,"merged":[[29,1,30,3],[13,15,14,15],[13,4,14,4],[13,5,14,5],[13,6,14,6],[13,7,14,7],[13,8,14,8],[1,8,2,8],[1,10,2,10],[1,14,2,14],[13,11,14,11],[13,12,14,12],[13,13,14,13],[1,12,2,12],[13,14,14,14],[1,4,2,4],[1,18,2,18],[13,9,14,9],[13,10,14,10],[13,18,14,18],[1,5,2,5],[1,13,2,13],[1,15,2,15],[1,16,2,16],[1,17,2,17],[13,16,14,16],[13,17,14,17],[1,6,2,6],[1,7,2,7],[1,9,2,9],[1,11,2,11]]}
[]
[null,"10.1.","Kalkulace finančního vnitřního výnosového procenta",null,{"$f":"'0 Úvod'!G19","v":2009},{"$f":"E2+1","v":2010},2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023]
[null,"a","kapitálu - FRR/K (CZK)","Celkem"]
[null,null,"Zůstatková hodnota",{"$f":"SUM(E4:S4,E16:S16)","v":7218913427.9942722},{"$f":"-1*'5 Finanční analýza (FRR_C)'!E8","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!F8","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!G8","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!H8","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!I8","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!J8","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!K8","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!L8","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!M8","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!N8","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!O8","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!P8","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!Q8","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!R8","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!S8","v":0}]
[null,null,"Přírůstek celkových provozních příjmů",{"$f":"SUM(E5:S5,E17:S17)","v":488997245.27085298},{"$f":"'7 Mezera ve financování'!E5","v":-58482914.546676718},{"$f":"'7 Mezera ve financování'!F5","v":-57294236.073257618},{"$f":"'7 Mezera ve financování'!G5","v":-44802775.585950159},{"$f":"'7 Mezera ve financování'!H5","v":-54172897.748213939},{"$f":"'7 Mezera ve financování'!I5","v":-42140293.907201156},{"$f":"'7 Mezera ve financování'!J5","v":-40115941.186313391},{"$f":"'7 Mezera ve financování'!K5","v":-43863102.687600531},{"$f":"'7 Mezera ve financování'!L5","v":-333226.32565824687},{"$f":"'7 Mezera ve financování'!M5","v":-5055764.7066690922},{"$f":"'7 Mezera ve financování'!N5","v":-4599794.2599630952},{"$f":"'7 Mezera ve financování'!O5","v":-2326708.8805234581},{"$f":"'7 Mezera ve financování'!P5","v":-1927108.1130502075},{"$f":"'7 Mezera ve financování'!Q5","v":-1527507.3455769271},{"$f":"'7 Mezera ve financování'!R5","v":-1127906.5781036541},{"$f":"'7 Mezera ve financování'!S5","v":-728305.81063041836}]
[null,null,"Celkové příjmy",{"$f":"SUM(D4:D5)","v":7707910673.2651253},{"$f":"SUM(E4:E5)","v":-58482914.546676718},{"$f":"SUM(F4:F5)","v":-57294236.073257618},-44802775.585950159,-54172897.748213939,-42140293.907201156,-40115941.186313391,-43863102.687600531,-333226.32565824687,-5055764.7066690922,-4599794.2599630952,-2326708.8805234581,-1927108.1130502075,-1527507.3455769271,-1127906.5781036541,-728305.81063041836]
[null,null,"Přírůstkové celkové provozní náklady*",{"$f":"SUM(E7:S7,E19:S19)","v":488997245.27085304},{"$f":"'6 Kontrola dotací'!E37","v":-58482914.546676725},{"$f":"'6 Kontrola dotací'!F37","v":-57294236.073257625},{"$f":"'6 Kontrola dotací'!G37","v":-44802775.585950136},{"$f":"'6 Kontrola dotací'!H37","v":-54172897.748214006},{"$f":"'6 Kontrola dotací'!I37","v":-42140293.907201141},{"$f":"'6 Kontrola dotací'!J37","v":-40115941.186313361},{"$f":"'6 Kontrola dotací'!K37","v":-43863102.687600553},{"$f":"'6 Kontrola dotací'!L37","v":-333226.32565823197},{"$f":"'6 Kontrola dotací'!M37","v":-5055764.7066690922},{"$f":"'6 Kontrola dotací'!N37","v":-4599794.2599630952},{"$f":"'6 Kontrola dotací'!O37","v":-2326708.8805234432},{"$f":"'6 Kontrola dotací'!P37","v":-1927108.1130502224},{"$f":"'6 Kontrola dotací'!Q37","v":-1527507.345576942},{"$f":"'6 Kontrola dotací'!R37","v":-1127906.5781036615},{"$f":"'6 Kontrola dotací'!S37","v":-728305.81063044071}]
[null,null,"Příspěvky žadatele + národní zdroje",{"$f":"SUM(E8:S8,E20:S20)","v":0},{"$f":"'8 Finanční struktura'!E6+'8 Finanční struktura'!E9","v":0},{"$f":"'8 Finanční struktura'!F6+'8 Finanční struktura'!F9","v":0},{"$f":"'8 Finanční struktura'!G6+'8 Finanční struktura'!G9","v":0},{"$f":"'8 Finanční struktura'!H6+'8 Finanční struktura'!H9","v":0},{"$f":"'8 Finanční struktura'!I6+'8 Finanční struktura'!I9","v":0},{"$f":"'8 Finanční struktura'!J6+'8 Finanční struktura'!J9","v":0},{"$f":"'8 Finanční struktura'!K6+'8 Finanční struktura'!K9","v":0},{"$f":"'8 Finanční struktura'!L6+'8 Finanční struktura'!L9","v":0},{"$f":"'8 Finanční struktura'!M6+'8 Finanční struktura'!M9","v":0},{"$f":"'8 Finanční struktura'!N6+'8 Finanční struktura'!N9","v":0},{"$f":"'8 Finanční struktura'!O6+'8 Finanční struktura'!O9","v":0},{"$f":"'8 Finanční struktura'!P6+'8 Finanční struktura'!P9","v":0},{"$f":"'8 Finanční struktura'!Q6+'8 Finanční struktura'!Q9","v":0},{"$f":"'8 Finanční struktura'!R6+'8 Finanční struktura'!R9","v":0},{"$f":"'8 Finanční struktura'!S6+'8 Finanční struktura'!S9","v":0}]
[null,null,"Celkové náklady",{"$f":"SUM(D7:D8)","v":488997245.27085304},{"$f":"SUM(E7:E8)","v":-58482914.546676725},-57294236.073257625,-44802775.585950136,-54172897.748214006,-42140293.907201141,-40115941.186313361,-43863102.687600553,-333226.32565823197,-5055764.7066690922,-4599794.2599630952,-2326708.8805234432,-1927108.1130502224,-1527507.345576942,-1127906.5781036615,-728305.81063044071]
[null,null,"Cash Flow ",null,{"$f":"E6-E9","v":0},0,0,6.7055225372314453E-8,0,0,0,-1.4901161193847656E-8,0,0,-1.4901161193847656E-8,1.4901161193847656E-8,1.4901161193847656E-8,7.4505805969238281E-9,2.2351741790771484E-8]
[null,null,"Diskontní sazba",{"$f":"'0 Úvod'!D21","v":0.04},1,{"$f":"E11/(1+$D$11)","v":0.96153846153846145},{"$f":"F11/(1+$D$11)","v":0.92455621301775137},0.88899635867091475,0.85480419102972571,0.82192710675935166,0.79031452573014582,0.75991781320206331,0.73069020500198389,0.70258673557883067,0.67556416882579873,0.64958093156326802,0.62459704958006534,0.60057408613467822,0.57747508282180593]
[null,null,"Diskontované cash flow",{"$f":"SUM(E12:S12,E24:S24)","v":2314754803.2280178},{"$f":"E10*E11","v":0},{"$f":"F10*F11","v":0},0,5.9611851185845084E-8,0,0,0,-1.1323657828600158E-8,0,0,-1.0066690576460939E-8,9.6795101696739795E-9,9.3072213169942102E-9,4.4746256331702934E-9,1.2907573941837383E-8]
[]
[null,"10.1.",{"$f":"C2","v":"Kalkulace finančního vnitřního výnosového procenta"},null,{"$f":"S2+1","v":2024},{"$f":"E14+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038]
[null,"b",{"$f":"C3","v":"kapitálu - FRR/K (CZK)"}]
[null,null,{"$f":"C4","v":"Zůstatková hodnota"},null,{"$f":"-1*'5 Finanční analýza (FRR_C)'!E20","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!F20","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!G20","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!H20","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!I20","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!J20","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!K20","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!L20","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!M20","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!N20","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!O20","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!P20","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!Q20","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!R20","v":0},{"$f":"-1*'5 Finanční analýza (FRR_C)'!S20","v":7218913427.9942722}]
[null,null,"Přírůstek celkových provozních příjmů",null,{"$f":"'7 Mezera ve financování'!E15","v":52857212.054577433},{"$f":"'7 Mezera ve financování'!F15","v":53156637.08186008},{"$f":"'7 Mezera ve financování'!G15","v":53456062.109142721},{"$f":"'7 Mezera ve financování'!H15","v":55688647.165000543},{"$f":"'7 Mezera ve financování'!I15","v":55988072.192283198},{"$f":"'7 Mezera ve financování'!J15","v":56287497.219565868},{"$f":"'7 Mezera ve financování'!K15","v":56586922.246848501},{"$f":"'7 Mezera ve financování'!L15","v":56886347.274131149},{"$f":"'7 Mezera ve financování'!M15","v":57185772.301413789},{"$f":"'7 Mezera ve financování'!N15","v":57485197.328696445},{"$f":"'7 Mezera ve financování'!O15","v":57784622.355979115},{"$f":"'7 Mezera ve financování'!P15","v":58084047.38326174},{"$f":"'7 Mezera ve financování'!Q15","v":58383472.410544395},{"$f":"'7 Mezera ve financování'!R15","v":58682897.437827036},{"$f":"'7 Mezera ve financování'!S15","v":58982322.465109691}]
[null,null,"Celkové příjmy",null,{"$f":"SUM(E16:E17)","v":52857212.054577433},{"$f":"SUM(F16:F17)","v":53156637.08186008},53456062.109142721,55688647.165000543,55988072.192283198,56287497.219565868,56586922.246848501,56886347.274131149,57185772.301413789,57485197.328696445,57784622.355979115,58084047.38326174,58383472.410544395,58682897.437827036,7277895750.4593821]
[null,null,"Přírůstkové celkové provozní náklady*",null,{"$f":"'6 Kontrola dotací'!E44","v":52857212.05457747},{"$f":"'6 Kontrola dotací'!F44","v":53156637.081860065},{"$f":"'6 Kontrola dotací'!G44","v":53456062.109142721},{"$f":"'6 Kontrola dotací'!H44","v":55688647.165000498},{"$f":"'6 Kontrola dotací'!I44","v":55988072.192283213},{"$f":"'6 Kontrola dotací'!J44","v":56287497.219565868},{"$f":"'6 Kontrola dotací'!K44","v":56586922.246848524},{"$f":"'6 Kontrola dotací'!L44","v":56886347.274131179},{"$f":"'6 Kontrola dotací'!M44","v":57185772.301413834},{"$f":"'6 Kontrola dotací'!N44","v":57485197.328696489},{"$f":"'6 Kontrola dotací'!O44","v":57784622.355979085},{"$f":"'6 Kontrola dotací'!P44","v":58084047.38326174},{"$f":"'6 Kontrola dotací'!Q44","v":58383472.410544395},{"$f":"'6 Kontrola dotací'!R44","v":58682897.437826991},{"$f":"'6 Kontrola dotací'!S44","v":58982322.465109706}]
[null,null,"Příspěvky žadatele + národní zdroje",null,{"$f":"'8 Finanční struktura'!E21+'8 Finanční struktura'!E24","v":0},{"$f":"'8 Finanční struktura'!F21+'8 Finanční struktura'!F24","v":0},{"$f":"'8 Finanční struktura'!G21+'8 Finanční struktura'!G24","v":0},{"$f":"'8 Finanční struktura'!H21+'8 Finanční struktura'!H24","v":0},{"$f":"'8 Finanční struktura'!I21+'8 Finanční struktura'!I24","v":0},{"$f":"'8 Finanční struktura'!J21+'8 Finanční struktura'!J24","v":0},{"$f":"'8 Finanční struktura'!K21+'8 Finanční struktura'!K24","v":0},{"$f":"'8 Finanční struktura'!L21+'8 Finanční struktura'!L24","v":0},{"$f":"'8 Finanční struktura'!M21+'8 Finanční struktura'!M24","v":0},{"$f":"'8 Finanční struktura'!N21+'8 Finanční struktura'!N24","v":0},{"$f":"'8 Finanční struktura'!O21+'8 Finanční struktura'!O24","v":0},{"$f":"'8 Finanční struktura'!P21+'8 Finanční struktura'!P24","v":0},{"$f":"'8 Finanční struktura'!Q21+'8 Finanční struktura'!Q24","v":0},{"$f":"'8 Finanční struktura'!R21+'8 Finanční struktura'!R24","v":0},{"$f":"'8 Finanční struktura'!S21+'8 Finanční struktura'!S24","v":0}]
[null,null,"Celkové náklady",null,{"$f":"SUM(E19:E20)","v":52857212.05457747},53156637.081860065,53456062.109142721,55688647.165000498,55988072.192283213,56287497.219565868,56586922.246848524,56886347.274131179,57185772.301413834,57485197.328696489,57784622.355979085,58084047.38326174,58383472.410544395,58682897.437826991,58982322.465109706]
[null,null,"Cash Flow ",null,{"$f":"E18-E21","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,7218913427.9942722]
[null,null,"Diskontní sazba",{"$f":"D11","v":0.04},{"$f":"S11*1/(1+$D$11)","v":0.55526450271327488},{"$f":"E23*1/(1+$D$11)","v":0.53390817568584126},{"$f":"F23*1/(1+$D$11)","v":0.51337324585177047},0.49362812101131776,0.47464242404934398,0.45638694620129228,0.4388336021166272,0.42195538665060306,0.40572633331788754,0.39012147434412264,0.37511680225396404,0.3606892329365039,0.34681657013125372,0.33347747128005162,0.32065141469235731]
[null,null,"Diskontované cash flow",null,{"$f":"E22*E23","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,2314754803.2280178]
[]
[null,"Finanční vniřní výnosové procento kapitálu FRR/K**",null,null,{"$f":"ROUND(IRR((E10:S10,E22:S22),0.05),4)","v":15.679500000000001},null,{"$f":"IF('8 Finanční struktura'!T11=\"OK\",\"\",\"CHYBA!\")","v":"CHYBA!"}]
[null,"Finanční čistá současná hodnota kapitálu FNPV/K (CZK)",null,null,{"$f":"SUM(E12:S12,E24:S24)","v":2314754803.2280178}]
[null,"Finanční čistá současná hodnota kapitálu FNPV/K (EUR)",null,null,{"$f":"E27/'0 Úvod'!N19","v":90208682.900546283}]
[]
[null,"Komentáře"]
[]
[null,"* čistá úspora prov. nákladů po odečtení úspory dotace (dle listu 6)"]
[null,"** pokud se zobrazí \"CHYBA\", zkonrolujte list 8 Finanční struktura"]