{"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 železnice","4 Úspory v silniční dopravě","5 Úspory z cestovních dob","6 Externality","7 Emise ze železniční dopravy","8 Bezpečnost železniční dopravy","9 Ostatní příjmy či náklady","10 Ekonomická analýza"],"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":85,"n_cols":15,"rows_kept":85,"cut":false,"hidden":false,"merged":[[39,2,39,3],[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]]}
[]
[]
[]
[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"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Základní informace"]
[]
[null,null,"Zdroj dat: ","Modernizace trati …"]
[]
[null,null,"Cenová úroveň (CÚ) ",2016,null,"Začátek stavebních prací ",2016,null,"Doba hodnocení",30,null,null,"Směnný kurz (CZK/EUR) ",25.66]
[]
[null,null,"Diskontní sazba ",0.05,null,"Začátek provozu ",2018,null,null,null,null,null,"DPH ",0.21]
[]
[]
[]
[null,null,"Hodnocené scénáře"]
[null,"BEZ PROJEKTU"]
[]
[]
[]
[]
[null,"S PROJEKTEM"]
[]
[]
[]
[]
[]
[]
[null,null,"Seznam tabulek"]
[]
[null,null,"List / tabulka",null,"Celk. investiční náklady","Zůstatková hodnota","Prov. náklady železnice","Úspory v sil. dopravě","Úspory z cestovních dob","Externality","Emise ze žel. dopravy","Bezpečnost žel. dopravy"," Ostatní příjmy/náklady","Ekonomická analýza"]
[null,null,"V konstantních cenách",null,"1.1.","2.1., 2.2","3.1., 3.2., 3.3","4.1., 4.2.","5.1., 5.2., 5.3., 5.4.","6.1., 6.2., 6.3.","7.1., 7.2, 7.3.","8.1., 8.2.","9.1., 9.2.","10.1."]
[]
[]
[]
[]
[]
[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":"J51*(1+K50)","v":1.014},{"$f":"K51*(1+L50)","v":1.0180560000000001},{"$f":"L51*(1+M50)","v":1.0211101679999999},{"$f":"M51*(1+N50)","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":"K58*(1+L57)","v":1.0049999999999999},{"$f":"L58*(1+M57)","v":1.0049999999999999},{"$f":"M58*(1+N57)","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,null,null,null,null,null,null,null,null,1,{"$f":"K67*(1+L66)","v":0.995},{"$f":"L67*(1+M66)","v":1.01291},{"$f":"M67*(1+N66)","v":1.06051677}]
[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,null,{"$f":"N67*(1+D69)","v":1.0902112395600001},{"$f":"D70*(1+E69)","v":1.1218273655072399},{"$f":"E70*(1+F69)","v":1.1554821864724572},{"$f":"F70*(1+G69)","v":1.1901466520666308},{"$f":"G70*(1+H69)","v":1.2139495851079636},{"$f":"H70*(1+I69)^(I68-H68)","v":1.3409555708440088},{"$f":"I70*(1+J69)^(J68-I68)","v":1.6362206315566001}]
[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":"D79*(1+E78*'3 Provozní náklady železnice'!$D$130)","v":0.98499999999999999},{"$f":"E79*(1+F78*'3 Provozní náklady železnice'!$D$130)","v":1.0037149999999999},{"$f":"F79*(1+G78*'3 Provozní náklady železnice'!$D$130)","v":1.0318190199999999},{"$f":"G79*(1+H78*'3 Provozní náklady železnice'!$D$130)","v":1.0627735906},{"$f":"H79*(1+I78*'3 Provozní náklady železnice'!$D$130)","v":1.089342930365},{"$f":"I79*(1+J78*'3 Provozní náklady železnice'!$D$130)","v":1.12202321827595},{"$f":"J79*(1+K78*'3 Provozní náklady železnice'!$D$130)","v":1.1556839148242286},{"$f":"K79*(1+L78*'3 Provozní náklady železnice'!$D$130)","v":1.1845760126948341},{"$f":"L79*(1+M78*'3 Provozní náklady železnice'!$D$130)^(M77-L77)","v":1.4439915495346414},{"$f":"M79*(1+N78*'3 Provozní náklady železnice'!$D$130)^(N77-M77)","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":30,"n_cols":21,"rows_kept":30,"cut":false,"hidden":false,"merged":[[2,5,3,5],[2,4,3,4],[2,3,3,3],[17,3,18,3],[17,4,18,4],[17,5,18,5]]}
[]
[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":2016},{"$f":"G3+1","v":2017},{"$f":"H3+1","v":2018},2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,{"$f":"T3+1","v":2030}]
[null,null,{"$f":"'0 Úvod'!D19","v":2016}]
[null,null,"Přípravná a projektová dokumentace",null,null,{"$f":"SUM(G5:U5,G20:U20)","v":0}]
[null,null,"Zábory a nákupy pozemků",null,null,{"$f":"SUM(G6:U6,G21:U21)","v":0}]
[null,null,"Stavby a konstrukce (stavební náklady)",null,null,0]
[null,null,"Stroje a zařízení",null,null,0]
[null,null,"Technická asistence, propagace",null,null,0]
[null,null,"Technický dozor",null,null,0]
[null,null,"Celkové investiční náklady bez rezervy  (konstantní ceny)",null,null,0,{"$f":"SUM(G5:G10)","v":0},0,{"$f":"SUM(I5:I10)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(U5:U10)","v":0}]
[null,null,"Rezerva",null,null,0]
[null,null,"Celkové investiční náklady včetně rezervy (konstantní ceny)",null,null,0,{"$f":"SUM(G11:G12)","v":0},{"$f":"SUM(H11:H12)","v":0},{"$f":"SUM(I11:I12)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(U11:U12)","v":0}]
[null,null,{"$f":"'0 Úvod'!$N$21*1000","v":210},null,null,0,{"$f":"G13*$C14/1000","v":0},{"$f":"H13*$C14/1000","v":0},{"$f":"I13*$C14/1000","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"U13*$C14/1000","v":0}]
[null,null,"Celkové investiční náklady včetně DPH (konstantní ceny)",null,null,0,{"$f":"G14+G13","v":0},{"$f":"H14+H13","v":0},{"$f":"I14+I13","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"U14+U13","v":0}]
[]
[null,"1.1.","Celkové investiční náklady (CZK)"]
[null,"b","(konstatní ceny)",null,null,null,{"$f":"U3+1","v":2031},{"$f":"G18+1","v":2032},{"$f":"H18+1","v":2033},2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,{"$f":"T18+1","v":2045}]
[null,null,{"$f":"'0 Úvod'!D19","v":2016}]
[null,null,"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,{"$f":"SUM(U20:U25)","v":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,{"$f":"SUM(U26:U27)","v":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,{"$f":"U29+U28","v":0}]

{"sheet":"2 Zůstatková hodnota","index":2,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[18,8,18,9],[19,8,19,9],[15,1,15,3]]}
[]
[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í",null,{"$f":"D3*D20","v":0},null,null,"Celková životnost investice",{"$f":"$E$16","v":{"$error":"#DIV/0!"}}]
[null,null,"Sdělovací zařízení",null,{"$f":"D4*D21","v":0},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":28}]
[null,null,"Silnoproudé rozvody a zařízení",null,0,null,null,"Životnost investice po skončení hodnotícího období",{"$f":"I3-I4","v":{"$error":"#DIV/0!"}}]
[null,null,"Železniční svršek",null,0,null,null,"Průměrný nákladový peněžní tok (nediskontovaný)",{"$f":"SUM('10 Ekonomická analýza'!F18:T18,'10 Ekonomická analýza'!F35:T35)/('0 Úvod'!J19-('0 Úvod'!$G$21-'0 Úvod'!G19))","v":0}]
[null,null,"Železniční spodek",null,0,null,null,"Ekonomický přínos v posledním roce (nediskontovaný)",{"$f":"IF(HLOOKUP(('0 Úvod'!G19+'0 Úvod'!J19-1),'10 Ekonomická analýza'!F19:T26,1,FALSE)=('0 Úvod'!G19+'0 Úvod'!J19-1),(HLOOKUP(('0 Úvod'!G19+'0 Úvod'!J19-1),'10 Ekonomická analýza'!F19:T26,4,FALSE)+HLOOKUP(('0 Úvod'!G19+'0 Úvod'!J19-1),'10 Ekonomická analýza'!F19:T26,5,FALSE)+HLOOKUP(('0 Úvod'!G19+'0 Úvod'!J19-1),'10 Ekonomická analýza'!F19:T26,6,FALSE)+HLOOKUP(('0 Úvod'!G19+'0 Úvod'!J19-1),'10 Ekonomická analýza'!F19:T26,7,FALSE)+HLOOKUP(('0 Úvod'!G19+'0 Úvod'!J19-1),'10 Ekonomická analýza'!F19:T26,8,FALSE)),0)","v":0}]
[null,null,"Mosty, propustky, zdi",null,0,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,IF(I7*(1/(1+'0 Úvod'!D21))*(((1/(1+'0 Úvod'!D21))^I5-1)/((1/(1+'0 Úvod'!D21))-1))<0,0,I7*(1/(1+'0 Úvod'!D21))*(((1/(1+'0 Úvod'!D21))^I5-1)/((1/(1+'0 Úvod'!D21))-1))),(I6+I7)*(1/(1+'0 Úvod'!D21))*(((1/(1+'0 Úvod'!D21))^I5-1)/((1/(1+'0 Úvod'!D21))-1)))","v":{"$error":"#DIV/0!"}}]
[null,null,"Tunely",null,0]
[null,null,"Komunikace a zpevněné plochy",null,0]
[null,null,"Trakce",null,0]
[null,null,"Inženýrské sítě (trubní vedení, kabelovody)",null,0]
[null,null,"Pozemní stavby, nástupiště a přístřešky",null,0]
[null,null,"Objekty ochrany životního prostředí",null,0]
[null,null,"CELKEM",{"$f":"SUM(D3:D14)","v":0},{"$f":"SUM(E3:E14)","v":0}]
[null,"Celková životnost investice (roky)",null,null,{"$f":"ROUND(E15/D15,0)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"2.2.","Životnost jednotlivých prvků","roky",null,null,"2.4.","Diskont. zůstatková hodnota investic pro FA",{"$f":"I8*(1/(1+'0 Úvod'!D21)^('0 Úvod'!J19-1))","v":{"$error":"#DIV/0!"}}]
[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":{"$error":"#DIV/0!"}}]
[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 železnice","index":3,"n_rows":239,"n_cols":19,"rows_kept":239,"cut":false,"hidden":false,"merged":[[29,7,30,7],[29,8,30,8],[29,6,30,6],[29,5,30,5],[39,7,40,7],[39,8,40,8],[102,12,103,12],[162,12,163,12],[144,10,145,10],[144,11,145,11],[144,12,145,12],[102,10,103,10],[144,5,145,5],[144,6,145,6],[144,7,145,7],[144,8,145,8],[144,9,145,9],[85,7,86,7],[85,8,86,8],[85,9,86,9],[77,17,78,17],[20,4,21,4],[20,6,21,6],[48,12,49,12],[48,13,49,13],[48,4,49,4],[48,5,49,5],[20,12,21,12],[29,9,30,9],[29,10,30,10],[29,4,30,4],[39,4,40,4],[39,5,40,5],[20,11,21,11],[20,9,21,9],[20,5,21,5],[20,10,21,10],[20,8,21,8],[20,7,21,7],[20,15,21,15],[77,6,78,6],[77,7,78,7],[77,8,78,8],[77,9,78,9],[20,18,21,18],[39,13,40,13],[39,14,40,14],[20,16,21,16],[20,17,21,17],[20,13,21,13],[20,14,21,14],[235,1,236,15],[48,8,49,8],[48,9,49,9],[48,10,49,10],[48,11,49,11],[39,17,40,17],[39,15,40,15],[39,16,40,16],[39,10,40,10],[39,6,40,6],[48,6,49,6],[48,7,49,7],[39,9,40,9],[180,9,181,9],[180,10,181,10],[180,11,181,11],[180,12,181,12],[48,18,49,18],[48,14,49,14],[48,15,49,15],[48,16,49,16],[48,17,49,17],[39,18,40,18],[29,17,30,17],[29,12,30,12],[29,13,30,13],[29,14,30,14],[29,16,30,16],[29,15,30,15],[29,18,30,18],[39,12,40,12],[1,18,2,18],[10,16,11,16],[1,16,2,16],[1,17,2,17],[10,18,11,18],[10,17,11,17],[1,15,2,15],[10,15,11,15],[10,14,11,14],[1,14,2,14],[10,9,11,9],[10,10,11,10],[1,10,2,10],[1,11,2,11],[1,9,2,9],[1,12,2,12],[1,13,2,13],[29,11,30,11],[39,11,40,11],[10,11,11,11],[10,12,11,12],[10,13,11,13],[10,8,11,8],[10,4,11,4],[10,5,11,5],[10,6,11,6],[10,7,11,7],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[110,1,112,1],[94,10,95,10],[94,11,95,11],[94,12,95,12],[94,13,95,13],[94,14,95,14],[94,15,95,15],[94,4,95,4],[94,5,95,5],[94,6,95,6],[94,7,95,7],[94,8,95,8],[94,9,95,9],[102,6,103,6],[102,7,103,7],[102,8,103,8],[102,9,103,9],[102,15,103,15],[102,11,103,11],[85,15,86,15],[85,16,86,16],[85,17,86,17],[66,1,69,1],[70,1,73,1],[102,13,103,13],[102,14,103,14],[127,27,128,27],[127,28,128,28],[77,12,78,12],[77,13,78,13],[77,18,78,18],[77,14,78,14],[77,15,78,15],[77,16,78,16],[77,10,78,10],[77,11,78,11],[85,12,86,12],[85,13,86,13],[85,14,86,14],[85,10,86,10],[85,11,86,11],[77,4,78,4],[77,5,78,5],[144,28,145,28],[144,25,145,25],[144,26,145,26],[127,26,128,26],[144,16,145,16],[144,17,145,17],[144,18,145,18],[127,25,128,25],[144,21,145,21],[144,22,145,22],[144,23,145,23],[144,19,145,19],[144,20,145,20],[127,22,128,22],[127,23,128,23],[127,24,128,24],[94,17,95,17],[127,18,128,18],[127,19,128,19],[127,20,128,20],[127,21,128,21],[127,17,128,17],[102,17,103,17],[102,18,103,18],[144,27,145,27],[144,24,145,24],[94,18,95,18],[216,16,217,16],[216,17,217,17],[216,18,217,18],[216,13,217,13],[216,14,217,14],[198,16,199,16],[144,15,145,15],[198,17,199,17],[198,13,199,13],[198,14,199,14],[198,15,199,15],[216,15,217,15],[180,17,181,17],[162,17,163,17],[162,18,163,18],[180,18,181,18],[198,18,199,18],[144,4,145,4],[85,18,86,18],[127,8,128,8],[127,9,128,9],[127,10,128,10],[127,11,128,11],[127,12,128,12],[127,13,128,13],[127,15,128,15],[127,16,128,16],[94,16,95,16],[127,14,128,14],[144,13,145,13],[144,14,145,14],[102,16,103,16],[102,4,103,4],[102,5,103,5],[127,4,128,4],[127,5,128,5],[127,6,128,6],[127,7,128,7],[85,4,86,4],[85,5,86,5],[85,6,86,6],[180,8,181,8],[180,13,181,13],[180,14,181,14],[180,15,181,15],[180,16,181,16],[162,11,163,11],[162,16,163,16],[162,4,163,4],[162,5,163,5],[162,6,163,6],[162,7,163,7],[162,8,163,8],[162,9,163,9],[162,10,163,10],[180,4,181,4],[180,5,181,5],[180,6,181,6],[180,7,181,7],[162,13,163,13],[162,14,163,14],[162,15,163,15],[198,4,199,4],[198,5,199,5],[198,6,199,6],[198,7,199,7],[198,8,199,8],[198,9,199,9],[198,10,199,10],[198,11,199,11],[198,12,199,12],[216,4,217,4],[216,5,217,5],[216,6,217,6],[216,7,217,7],[216,8,217,8],[216,9,217,9],[216,10,217,10],[216,11,217,11],[216,12,217,12]]}
[]
[null,"3.1.","Celkové provozní náklady (CZK)",null,{"$f":"'1 Celkové investiční náklady'!G3","v":2016},{"$f":"E2+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a","Scénář s projektem","Celkem"]
[null,null,"Náklady na údržbu a provoz infrastr.",{"$f":"SUM(E4:S4,E13:S13)","v":0}]
[null,null,"Periodické provozní náklady",{"$f":"SUM(E5:S5,E14:S14)","v":0}]
[null,null,"Náklady na řízení provozu",0,{"$f":"IF(E2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(E131:E143,E165:E177)+E179,0)","v":0},{"$f":"IF(F2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(F131:F143,F165:F177)+F179,0)","v":0},{"$f":"IF(G2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(G131:G143,G165:G177)+G179,0)","v":0},{"$f":"IF(H2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(H131:H143,H165:H177)+H179,0)","v":0},{"$f":"IF(I2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(I131:I143,I165:I177)+I179,0)","v":0},{"$f":"IF(J2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(J131:J143,J165:J177)+J179,0)","v":0},{"$f":"IF(K2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(K131:K143,K165:K177)+K179,0)","v":0},{"$f":"IF(L2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(L131:L143,L165:L177)+L179,0)","v":0},{"$f":"IF(M2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(M131:M143,M165:M177)+M179,0)","v":0},{"$f":"IF(N2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(N131:N143,N165:N177)+N179,0)","v":0},{"$f":"IF(O2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(O131:O143,O165:O177)+O179,0)","v":0},{"$f":"IF(P2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(P131:P143,P165:P177)+P179,0)","v":0},{"$f":"IF(Q2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(Q131:Q143,Q165:Q177)+Q179,0)","v":0},{"$f":"IF(R2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(R131:R143,R165:R177)+R179,0)","v":0},{"$f":"IF(S2<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(S131:S143,S165:S177)+S179,0)","v":0}]
[null,null,"Náklady na provoz vlaků - osobní ",0]
[null,null,"Náklady na provoz vlaků - nákladní",0]
[null,null,"Celkové provozní náklady",0,{"$f":"SUM(E4:E8)","v":0},{"$f":"SUM(F4:F8)","v":0},{"$f":"SUM(G4:G8)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(S4:S8)","v":0}]
[]
[null,"3.1.","Celkové provozní náklady (CZK)",null,{"$f":"S2+1","v":2031},{"$f":"E11+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b","Scenář s projektem"]
[null,null,"Náklady na údržbu a provoz infrastr."]
[null,null,"Periodické provozní náklady"]
[null,null,"Náklady na řízení provozu",null,{"$f":"IF(E11<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(E148:E160,E183:E195)+E197,0)","v":0},{"$f":"IF(F11<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(F148:F160,F183:F195)+F197,0)","v":0},{"$f":"IF(G11<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(G148:G160,G183:G195)+G197,0)","v":0},{"$f":"IF(H11<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(H148:H160,H183:H195)+H197,0)","v":0},{"$f":"IF(I11<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(I148:I160,I183:I195)+I197,0)","v":0},{"$f":"IF(J11<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(J148:J160,J183:J195)+J197,0)","v":0},{"$f":"IF(K11<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(K148:K160,K183:K195)+K197,0)","v":0},{"$f":"IF(L11<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(L148:L160,L183:L195)+L197,0)","v":0},{"$f":"IF(M11<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(M148:M160,M183:M195)+M197,0)","v":0},{"$f":"IF(N11<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(N148:N160,N183:N195)+N197,0)","v":0},{"$f":"IF(O11<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(O148:O160,O183:O195)+O197,0)","v":0},{"$f":"IF(P11<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(P148:P160,P183:P195)+P197,0)","v":0},{"$f":"IF(Q11<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(Q148:Q160,Q183:Q195)+Q197,0)","v":0},{"$f":"IF(R11<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(R148:R160,R183:R195)+R197,0)","v":0},{"$f":"IF(S11<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(S148:S160,S183:S195)+S197,0)","v":0}]
[null,null,"Náklady na provoz vlaků - osobní "]
[null,null,"Náklady na provoz vlaků - nákladní"]
[null,null,"Celkové provozní náklady",null,{"$f":"SUM(E13:E17)","v":0},{"$f":"SUM(F13:F17)","v":0},{"$f":"SUM(G13:G17)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(S13:S17)","v":0}]
[]
[]
[null,"3.2.","Celkové provozní náklady (CZK)",null,{"$f":"E2","v":2016},{"$f":"E21+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a","Scénář bez projektu","Celkem"]
[null,null,"Náklady na údržbu a provoz infrastr.",{"$f":"SUM(E23:S23,E32:S32)","v":0}]
[null,null,"Periodické provozní náklady",{"$f":"SUM(E24:S24,E33:S33)","v":0}]
[null,null,"Náklady na řízení provozu",0,{"$f":"IF(E21<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(E131:E143,E201:E213)+E215,0)","v":0},{"$f":"IF(F21<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(F131:F143,F201:F213)+F215,0)","v":0},{"$f":"IF(G21<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(G131:G143,G201:G213)+G215,0)","v":0},{"$f":"IF(H21<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(H131:H143,H201:H213)+H215,0)","v":0},{"$f":"IF(I21<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(I131:I143,I201:I213)+I215,0)","v":0},{"$f":"IF(J21<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(J131:J143,J201:J213)+J215,0)","v":0},{"$f":"IF(K21<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(K131:K143,K201:K213)+K215,0)","v":0},{"$f":"IF(L21<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(L131:L143,L201:L213)+L215,0)","v":0},{"$f":"IF(M21<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(M131:M143,M201:M213)+M215,0)","v":0},{"$f":"IF(N21<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(N131:N143,N201:N213)+N215,0)","v":0},{"$f":"IF(O21<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(O131:O143,O201:O213)+O215,0)","v":0},{"$f":"IF(P21<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(P131:P143,P201:P213)+P215,0)","v":0},{"$f":"IF(Q21<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(Q131:Q143,Q201:Q213)+Q215,0)","v":0},{"$f":"IF(R21<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(R131:R143,R201:R213)+R215,0)","v":0},{"$f":"IF(S21<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(S131:S143,S201:S213)+S215,0)","v":0}]
[null,null,"Náklady na provoz vlaků - osobní ",0]
[null,null,"Náklady na provoz vlaků - nákladní",0]
[null,null,"Celkové provozní náklady",0,{"$f":"SUM(E23:E27)","v":0},{"$f":"SUM(F23:F27)","v":0},{"$f":"SUM(G23:G27)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(S23:S27)","v":0}]
[]
[null,"3.2.","Celkové provozní náklady (CZK)",null,{"$f":"S21+1","v":2031},{"$f":"E30+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b","Scénář bez projektu",null,{"$f":"S22+1","v":1}]
[null,null,"Náklady na údržbu a provoz infrastr."]
[null,null,"Periodické provozní náklady"]
[null,null,"Náklady na řízení provozu",null,{"$f":"IF(E30<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(E148:E160,E219:E231)+E233,0)","v":0},{"$f":"IF(F30<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(F148:F160,F219:F231)+F233,0)","v":0},{"$f":"IF(G30<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(G148:G160,G219:G231)+G233,0)","v":0},{"$f":"IF(H30<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(H148:H160,H219:H231)+H233,0)","v":0},{"$f":"IF(I30<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(I148:I160,I219:I231)+I233,0)","v":0},{"$f":"IF(J30<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(J148:J160,J219:J231)+J233,0)","v":0},{"$f":"IF(K30<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(K148:K160,K219:K231)+K233,0)","v":0},{"$f":"IF(L30<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(L148:L160,L219:L231)+L233,0)","v":0},{"$f":"IF(M30<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(M148:M160,M219:M231)+M233,0)","v":0},{"$f":"IF(N30<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(N148:N160,N219:N231)+N233,0)","v":0},{"$f":"IF(O30<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(O148:O160,O219:O231)+O233,0)","v":0},{"$f":"IF(P30<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(P148:P160,P219:P231)+P233,0)","v":0},{"$f":"IF(Q30<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(Q148:Q160,Q219:Q231)+Q233,0)","v":0},{"$f":"IF(R30<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(R148:R160,R219:R231)+R233,0)","v":0},{"$f":"IF(S30<=('0 Úvod'!$G$19+'0 Úvod'!$J$19-1),SUMPRODUCT(S148:S160,S219:S231)+S233,0)","v":0}]
[null,null,"Náklady na provoz vlaků - osobní "]
[null,null,"Náklady na provoz vlaků - nákladní"]
[null,null,"Celkové provozní náklady",null,{"$f":"SUM(E32:E36)","v":0},{"$f":"SUM(F32:F36)","v":0},{"$f":"SUM(G32:G36)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(S32:S36)","v":0}]
[]
[]
[null,"3.3.a","Přírůstkové celkové provozní náklady (CZK)",null,{"$f":"E2","v":2016},{"$f":"E40+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"KF","s aplikací fiskální korekce","Celkem"]
[null,0.93,"Náklady na údržbu a provoz infrastr.",{"$f":"SUM(E42:S42,E51:S51)","v":0},{"$f":"(E4-E23)*$B$42","v":0},{"$f":"(F4-F23)*$B$42","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0.93,"Periodické provozní náklady",{"$f":"SUM(E43:S43,E52:S52)","v":0},{"$f":"(E5-E24)*$B$43","v":0},{"$f":"(F5-F24)*$B$43","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0.82,"Náklady na řízení provozu",0,{"$f":"(E6-E25)*$B$44","v":0},{"$f":"(F6-F25)*$B$44","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0.93,"Náklady na provoz vlaků - osobní ",0,{"$f":"(E7-E26)*$B$45","v":0},{"$f":"(F7-F26)*$B$45","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0.93,"Náklady na provoz vlaků - nákladní",0,{"$f":"(E8-E27)*$B$46","v":0},{"$f":"(F8-F27)*$B$46","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Přírůstkové celkové provozní náklady",0,{"$f":"SUM(E42:E46)","v":0},{"$f":"SUM(F42:F46)","v":0},{"$f":"SUM(G42:G46)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"3.3.b","Přírůstkové celkové provozní náklady (CZK)",null,{"$f":"S40+1","v":2031},{"$f":"E49+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"KF",{"$f":"C41","v":"s aplikací fiskální korekce"},null,{"$f":"S41+1","v":1}]
[null,{"$f":"B42","v":0.93},"Náklady na údržbu a provoz infrastr.",null,{"$f":"(E13-E32)*$B$42","v":0},{"$f":"(F13-F32)*$B$42","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"B43","v":0.93},"Periodické provozní náklady",null,{"$f":"(E14-E33)*$B$43","v":0},{"$f":"(F14-F33)*$B$43","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"B44","v":0.82},"Náklady na řízení provozu",null,{"$f":"(E15-E34)*$B$44","v":0},{"$f":"(F15-F34)*$B$44","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"B45","v":0.93},"Náklady na provoz vlaků - osobní ",null,{"$f":"(E16-E35)*$B$45","v":0},{"$f":"(F16-F35)*$B$45","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"B46","v":0.93},"Náklady na provoz vlaků - nákladní",null,{"$f":"(E17-E36)*$B$46","v":0},{"$f":"(F17-F36)*$B$46","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Přírůstkové celkové provozní náklady",null,{"$f":"SUM(E51:E55)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,"Scénář s projektem (CZK)",{"$f":"D9","v":0}]
[null,null,"Scénář bez projektu (CZK)",{"$f":"D28","v":0}]
[null,null,"Přírůstkové cash-flow (CZK)",{"$f":"D47","v":0}]
[]
[]
[null,"3.4.","Náklady na provoz vlaků"]
[null,null,"CÚ",{"$f":"'0 Úvod'!D19","v":2016}]
[null,null,"Měrné ohodnocení","Kč/vlhod"]
[null,"PROJEKT","osobní příměstská doprava"]
[null,null,"osobní dálková doprava"]
[null,null,"nákladní regionální doprava"]
[null,null,"nákladní dálková doprava"]
[null,"BEZ\nPROJ.","osobní příměstská doprava"]
[null,null,"osobní dálková doprava"]
[null,null,"nákladní regionální doprava"]
[null,null,"nákladní dálková doprava"]
[]
[null,null,"Pozn. Měrné ohodnocení - konkrétní hodnoty uvede zpracovatel."]
[]
[null,"3.5.","Celkové vlakohodiny",null,{"$f":"E40","v":2016},{"$f":"E78+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a","Scénář s projektem","Celkem"]
[null,null,"osobní příměstská doprava",{"$f":"SUM(E80:S80,E88:S88)","v":0}]
[null,null,"osobní dálková doprava",{"$f":"SUM(E81:S81,E89:S89)","v":0}]
[null,null,"nákladní regionální doprava",0]
[null,null,"nákladní dálková doprava",0]
[null,null,"Celkem",0,{"$f":"SUM(E80:E83)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"B78","v":"3.5."},{"$f":"C78","v":"Celkové vlakohodiny"},null,{"$f":"S78+1","v":2031},{"$f":"E86+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b","Scénář s projektem"]
[null,null,{"$f":"C80","v":"osobní příměstská doprava"}]
[null,null,{"$f":"C81","v":"osobní dálková doprava"}]
[null,null,{"$f":"C82","v":"nákladní regionální doprava"}]
[null,null,{"$f":"C83","v":"nákladní dálková doprava"}]
[null,null,{"$f":"C84","v":"Celkem"},null,{"$f":"SUM(E88:E91)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"3.6.",{"$f":"C78","v":"Celkové vlakohodiny"},null,{"$f":"E78","v":2016},{"$f":"E95+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a","Scénář bez projektu","Celkem"]
[null,null,"osobní příměstská doprava",{"$f":"SUM(E97:S97,E105:S105)","v":0}]
[null,null,"osobní dálková doprava",{"$f":"SUM(E98:S98,E106:S106)","v":0}]
[null,null,"nákladní regionální doprava",0]
[null,null,"nákladní dálková doprava",0]
[null,null,"Celkem",0,{"$f":"SUM(E97:E100)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"B95","v":"3.6."},{"$f":"C95","v":"Celkové vlakohodiny"},null,{"$f":"S95+1","v":2031},{"$f":"E103+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b","Scénář bez projektu",null,{"$f":"S96+1","v":1}]
[null,null,{"$f":"C97","v":"osobní příměstská doprava"}]
[null,null,{"$f":"C98","v":"osobní dálková doprava"}]
[null,null,{"$f":"C99","v":"nákladní regionální doprava"}]
[null,null,{"$f":"C100","v":"nákladní dálková doprava"}]
[null,null,{"$f":"C101","v":"Celkem"},null,{"$f":"SUM(E105:E108)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"3.7.","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.8. ","Růst nákladů na řízení provozu",null,{"$f":"E40","v":2016},{"$f":"F40","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a",null,"Elasticita"]
[null,null,"Růst reálné mzdy v dopravě",1,0,{"$f":"$D$130*HLOOKUP(F$128,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":2.5000000000000001E-2},{"$f":"$D$130*HLOOKUP(G$128,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":0.03},{"$f":"$D$130*HLOOKUP(H$128,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":0.03},{"$f":"$D$130*HLOOKUP(I$128,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":2.5000000000000001E-2},{"$f":"$D$130*HLOOKUP(J$128,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":2.5000000000000001E-2},{"$f":"$D$130*HLOOKUP(K$128,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":2.5000000000000001E-2},{"$f":"$D$130*HLOOKUP(L$128,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":2.5000000000000001E-2},{"$f":"$D$130*HLOOKUP(M$128,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":2.5000000000000001E-2},{"$f":"$D$130*HLOOKUP(N$128,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":2.5000000000000001E-2},{"$f":"$D$130*HLOOKUP(O$128,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":2.5000000000000001E-2},{"$f":"$D$130*HLOOKUP(P$128,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":2.5000000000000001E-2},{"$f":"$D$130*HLOOKUP(Q$128,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":2.5000000000000001E-2},{"$f":"$D$130*HLOOKUP(R$128,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":2.5000000000000001E-2},{"$f":"$D$130*HLOOKUP(S$128,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":0.02}]
[null,{"$f":"B114","v":13167},"Dozorčí provozu",null,{"$f":"D114*IF('0 Úvod'!$D$19>HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,1,TRUE),'0 Úvod'!$N$51*(1+0.02)^('0 Úvod'!$D$19-'0 Úvod'!$N$49),HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,3,TRUE))*IF(E$128>HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE)*(1+HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,2,TRUE)*$D$130)^(E$128-HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE)),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE))","v":768267.52323124046},{"$f":"E131*(1+F$130)","v":787474.21131202136},{"$f":"F131*(1+G$130)","v":811098.43765138206},835431.39078092354,856317.1755504465,877725.10493920755,899668.23256268771,922159.93837675487,945213.93683617364,968844.28525707789,993065.3923885047,1017892.0271982172,1043339.3278781725,1069422.8110751268,1090811.2672966293]
[null,31606,"Výpravčí",null,{"$f":"D115*IF('0 Úvod'!$D$19>HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,1,TRUE),'0 Úvod'!$N$51*(1+0.02)^('0 Úvod'!$D$19-'0 Úvod'!$N$49),HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,3,TRUE))*IF(E$128>HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE)*(1+HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,2,TRUE)*$D$130)^(E$128-HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE)),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE))","v":514884.52345165279},527756.63653794408,{"$f":"F132*(1+G$130)","v":543589.33563408244},559897.0157031049,573894.44109568244,588241.80212307442,602947.84717615123,618021.54335555492,633472.08193944371,649308.88398792979,665541.60608762794,682180.14623981854,699234.6498958139,716715.51614320918,731049.8264660734]
[null,31608,"Dozorčí provozu - vedoucí směny",null,{"$f":"D116*IF('0 Úvod'!$D$19>HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,1,TRUE),'0 Úvod'!$N$51*(1+0.02)^('0 Úvod'!$D$19-'0 Úvod'!$N$49),HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,3,TRUE))*IF(E$128>HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE)*(1+HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,2,TRUE)*$D$130)^(E$128-HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE)),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE))","v":589189.78742394049},603919.53210953891,{"$f":"F133*(1+G$130)","v":622037.11807282513},640698.23161500995,656715.68740538519,673133.57959051977,689961.91908028268,707210.96705728967,724891.24123372184,743013.52226456488,761588.86032117892,780628.5818292083,800144.29637493845,820147.90378431184,836550.86185999808]
[null,41333,"Operátor železniční dopravy",null,{"$f":"D117*IF('0 Úvod'!$D$19>HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,1,TRUE),'0 Úvod'!$N$51*(1+0.02)^('0 Úvod'!$D$19-'0 Úvod'!$N$49),HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,3,TRUE))*IF(E$128>HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE)*(1+HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,2,TRUE)*$D$130)^(E$128-HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE)),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE))","v":368272.11472619261},377478.91759434738,{"$f":"F134*(1+G$130)","v":388803.2851221778},400467.38367584313,410479.06826773915,420741.04497443256,431259.57109879336,442041.06037626317,453092.08688566973,464419.38905781147,476029.87378425669,487930.62062886305,500128.88614458457,512632.10829819913,522884.75046416314]
[null,83135,"Signalista",null,{"$f":"D118*IF('0 Úvod'!$D$19>HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,1,TRUE),'0 Úvod'!$N$51*(1+0.02)^('0 Úvod'!$D$19-'0 Úvod'!$N$49),HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,3,TRUE))*IF(E$128>HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE)*(1+HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,2,TRUE)*$D$130)^(E$128-HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE)),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE))","v":407723.73467837833},417916.82804533775,{"$f":"F135*(1+G$130)","v":430454.3328866979},443367.96287329885,454452.16194513126,465813.46599375951,477458.80264360347,489395.27270969353,501630.15452743584,514170.90839062171,527025.18110038724,540200.81062789692,553705.83089359431,567548.47666593408,578899.44619925274]
[null,83137,"Výhybkář",null,{"$f":"D119*IF('0 Úvod'!$D$19>HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,1,TRUE),'0 Úvod'!$N$51*(1+0.02)^('0 Úvod'!$D$19-'0 Úvod'!$N$49),HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,3,TRUE))*IF(E$128>HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE)*(1+HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,2,TRUE)*$D$130)^(E$128-HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE)),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE))","v":338511.86621416995},346974.66286952415,{"$f":"F136*(1+G$130)","v":357383.90275560989},368105.41983827821,377308.05533423513,386740.75671759096,396409.27563553071,406319.50752641895,416477.49521457939,426889.43259494385,437561.66840981739,448500.71012006281,459713.22787306434,471206.05856989091,480630.17974128877]
[null,83141,"Staniční dozorce",null,{"$f":"D120*IF('0 Úvod'!$D$19>HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,1,TRUE),'0 Úvod'!$N$51*(1+0.02)^('0 Úvod'!$D$19-'0 Úvod'!$N$49),HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,3,TRUE))*IF(E$128>HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE)*(1+HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,2,TRUE)*$D$130)^(E$128-HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE)),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE))","v":386068.85732672719},395720.57875989535,{"$f":"F137*(1+G$130)","v":407592.1961226922},419819.96200637298,430315.46105653228,441073.34758294554,452100.18127251917,463402.68580433208,474987.75294944033,486862.44677317631,499034.0079425057,511509.85814106831,524297.60459459492,537405.04470945976,548153.14560364897]
[null,83142,"Dozorce výhybek",null,{"$f":"D121*IF('0 Úvod'!$D$19>HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,1,TRUE),'0 Úvod'!$N$51*(1+0.02)^('0 Úvod'!$D$19-'0 Úvod'!$N$49),HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,3,TRUE))*IF(E$128>HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE)*(1+HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,2,TRUE)*$D$130)^(E$128-HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE)),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE))","v":359928.89832690282},368927.12078507536,{"$f":"F138*(1+G$130)","v":379994.93440862763},391394.78244088648,401179.65200190863,411209.1433019563,421489.37188450515,432026.60618161777,442827.27133615816,453897.95311956207,465245.40194755106,476876.5369962398,488798.45042114577,501018.41168167436,511038.77991530788]
[null,83143,"Závorář",null,{"$f":"D122*IF('0 Úvod'!$D$19>HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,1,TRUE),'0 Úvod'!$N$51*(1+0.02)^('0 Úvod'!$D$19-'0 Úvod'!$N$49),HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,3,TRUE))*IF(E$128>HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE)*(1+HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,2,TRUE)*$D$130)^(E$128-HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE)),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE))","v":316733.1339685198},324651.46231773274,{"$f":"F139*(1+G$130)","v":334391.00618726475},344422.73637288267,353033.30478220474,361859.1374017598,370905.61583680374,380178.25623272383,389682.71263854188,399424.78045450541,409410.39996586798,419645.65996501467,430136.80146414001,440890.22150074347,449708.02593075833]
[null,83144,"Závorář s prodejem jízdenek",null,{"$f":"D123*IF('0 Úvod'!$D$19>HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,1,TRUE),'0 Úvod'!$N$51*(1+0.02)^('0 Úvod'!$D$19-'0 Úvod'!$N$49),HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,3,TRUE))*IF(E$128>HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE)*(1+HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,2,TRUE)*$D$130)^(E$128-HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE)),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE))","v":342356.84823318053},350915.76943901001,{"$f":"F140*(1+G$130)","v":361443.24252218031},372286.5397978457,381593.70329279179,391133.54587511154,400911.88452198927,410934.68163503899,421208.04867591494,431738.24989281275,442531.70614013303,453594.99879363633,464934.8737634772,476558.24560756411,486089.4105197154]
[null,83145,"Hradlář - hláskař",null,{"$f":"D124*IF('0 Úvod'!$D$19>HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,1,TRUE),'0 Úvod'!$N$51*(1+0.02)^('0 Úvod'!$D$19-'0 Úvod'!$N$49),HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,3,TRUE))*IF(E$128>HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE)*(1+HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,2,TRUE)*$D$130)^(E$128-HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE)),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE))","v":334871.84760381241},343243.64379390772,{"$f":"F141*(1+G$130)","v":353540.95310772496},364147.18170095672,373250.86124348058,382582.13277456758,392146.68609393173,401950.35324627999,411999.11207743693,422299.0898793728,432856.56712635705,443677.98130451597,454769.93083712884,466139.179108057,475461.96269021812]
[null,83146,"Hradlář - hláskař s prodejem jízdenek",null,{"$f":"D125*IF('0 Úvod'!$D$19>HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,1,TRUE),'0 Úvod'!$N$51*(1+0.02)^('0 Úvod'!$D$19-'0 Úvod'!$N$49),HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,3,TRUE))*IF(E$128>HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE)*(1+HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,2,TRUE)*$D$130)^(E$128-HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE)),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE))","v":329582.25717515073},337821.81360452948,{"$f":"F142*(1+G$130)","v":347956.4680126654},358395.16205304535,367355.04110437143,376538.91713198071,385952.39006028022,395601.19981178717,405491.22980708181,415628.51055225881,426019.22331606527,436669.70389896684,447586.44649644097,458776.10765885195,467951.62981202902]
[null,93398,"Dělník v dopravě - staniční dělník",null,{"$f":"D126*IF('0 Úvod'!$D$19>HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,1,TRUE),'0 Úvod'!$N$51*(1+0.02)^('0 Úvod'!$D$19-'0 Úvod'!$N$49),HLOOKUP('0 Úvod'!$D$19,'0 Úvod'!$J$49:$N$51,3,TRUE))*IF(E$128>HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE)*(1+HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,2,TRUE)*$D$130)^(E$128-HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,1,TRUE)),HLOOKUP(E$128,'0 Úvod'!$D$77:$N$79,3,TRUE))","v":248346.59944396795},254555.26443006712,{"$f":"F143*(1+G$130)","v":262191.92236296914},270057.68003385823,276809.12203470466,283729.35008557228,290822.58383771154,298093.14843365428,305545.47714449558,313184.11407310795,321013.71692493564,329039.05984805903,337265.0363442605,345696.66225286701,352610.59549792437]
[]
[null,{"$f":"B128","v":"3.8. "},{"$f":"C128","v":"Růst nákladů na řízení provozu"},null,{"$f":"E49","v":2031},{"$f":"F49","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b",null,"Elasticita"]
[null,null,{"$f":"C130","v":"Růst reálné mzdy v dopravě"},{"$f":"D130","v":1},{"$f":"$D$130*HLOOKUP(E$145,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":0.02},{"$f":"$D$130*HLOOKUP(F$145,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":0.02},{"$f":"$D$130*HLOOKUP(G$145,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":0.02},{"$f":"$D$130*HLOOKUP(H$145,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":0.02},{"$f":"$D$130*HLOOKUP(I$145,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":0.02},{"$f":"$D$130*HLOOKUP(J$145,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":0.02},{"$f":"$D$130*HLOOKUP(K$145,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":0.02},{"$f":"$D$130*HLOOKUP(L$145,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":0.02},{"$f":"$D$130*HLOOKUP(M$145,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":0.02},{"$f":"$D$130*HLOOKUP(N$145,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":0.02},{"$f":"$D$130*HLOOKUP(O$145,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":0.02},{"$f":"$D$130*HLOOKUP(P$145,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":0.02},{"$f":"$D$130*HLOOKUP(Q$145,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":0.02},{"$f":"$D$130*HLOOKUP(R$145,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":0.02},{"$f":"$D$130*HLOOKUP(S$145,'0 Úvod'!$D$77:$N$79,2,TRUE)","v":0.02}]
[null,{"$f":"B131","v":13167},"Dozorčí provozu",null,{"$f":"S131*(1+E$147)","v":1112627.4926425619},{"$f":"E148*(1+F$147)","v":1134880.0424954132},{"$f":"F148*(1+G$147)","v":1157577.6433453215},1180729.1962122279,1204343.7801364725,1228430.6557392019,1252999.2688539859,1278059.2542310657,1303620.4393156872,1329692.848102001,1356286.7050640411,1383412.4391653219,1411080.6879486283,1439302.3017076009,1468088.3477417531]
[null,31606,"Výpravčí",null,{"$f":"S132*(1+E$147)","v":745670.82299539493},760584.23945530283,{"$f":"F149*(1+G$147)","v":775795.92424440884},791311.842729297,807138.07958388294,823280.84117556061,839746.4579990718,856541.38715905324,873672.21490223426,891145.65920027893,908968.57238428458,927147.94383197033,945690.9027086097,964604.72076278192,983896.81517803762]
[null,31608,"Dozorčí provozu - vedoucí směny",null,853281.87909719802,870347.51667914202,{"$f":"F150*(1+G$147)","v":887754.46701272484},905509.55635297939,923619.74748003902,942092.14242963982,960933.98527823261,980152.66498379724,999755.71828347316,1019750.8326491426,1040145.8493021255,1060948.766288168,1082167.7416139315,1103811.0964462101,1125887.3183751344]
[null,41333,"Operátor železniční dopravy",null,533342.44547344639,544009.29438291537,{"$f":"F151*(1+G$147)","v":554889.48027057364},565987.2698759851,577307.01527350477,588853.15557897487,600630.21869055438,612642.82306436542,624895.67952565278,637393.59311616584,650141.46497848921,663144.29427805904,676407.18016362027,689935.32376689266,703734.03024223051]
[null,83135,"Signalista",null,590477.43512323778,602286.98382570257,{"$f":"F152*(1+G$147)","v":614332.72350221663},626619.37797226093,639151.76553170616,651934.80084234034,664973.49685918714,678272.96679637092,691838.42613229831,705675.19465494424,719788.69854804315,734184.47251900402,748868.16196938406,763845.52520877181,779122.43571294728]
[null,83137,"Výhybkář",null,490242.78333611455,500047.63900283683,{"$f":"F153*(1+G$147)","v":510048.59178289358},520249.56361855147,530654.5548909225,541267.64598874096,552092.99890851579,563134.85888668615,574397.55606441991,585885.50718570827,597603.21732942248,609555.28167601093,621746.3873095311,634181.31505572179,646864.94135683624]
[null,83141,"Staniční dozorce",null,559116.20851572196,570298.53268603643,{"$f":"F154*(1+G$147)","v":581704.50333975721},593338.59340655233,605205.36527468334,617309.47258017701,629655.66203178058,642248.77527241618,655093.75077786448,668195.62579342176,681559.53830929019,695190.72907547606,709094.54365698562,723276.43453012535,737741.96322072786]
[null,83142,"Dozorce výhybek",null,521259.55551361403,531684.74662388628,{"$f":"F155*(1+G$147)","v":542318.44155636407},553164.81038749136,564228.10659524123,575512.66872714611,587022.92210168904,598763.38054372277,610738.64815459726,622953.42111768923,635412.48954004305,648120.73933084391,661083.15411746083,674304.81719981006,687790.91354380629]
[null,83143,"Závorář",null,458702.18644937349,467876.23017836094,{"$f":"F156*(1+G$147)","v":477233.75478192815},486778.4298775667,496513.99847511802,506444.27844462037,516573.16401351278,526904.62729378301,537442.7198396587,548191.57423645188,559155.40572118096,570338.51383560454,581745.28411231667,593380.18979456299,605247.79359045427]
[null,83144,"Závorář s prodejem jízdenek",null,495811.19873010973,505727.42270471191,{"$f":"F157*(1+G$147)","v":515841.97115880618},526158.81058198225,536681.98679362191,547415.6265294943,558363.93906008417,569531.21784128586,580921.84219811158,592540.27904207387,604391.08462291537,616478.90631537372,628808.48444168118,641384.65413051483,654212.34721312509]
[null,83145,"Hradlář - hláskař",null,484971.2019440225,494670.62598290294,{"$f":"F158*(1+G$147)","v":504564.03850256099},514655.31927261222,524948.42565806443,535447.39417122572,546156.3420546503,557079.46889574337,568221.05827365827,579585.47943913145,591177.18902791408,603000.73280847236,615060.74746464181,627361.96241393464,639909.20166221331]
[null,83146,"Hradlář - hláskař s prodejem jízdenek",null,477310.66240826959,486856.87565643498,{"$f":"F159*(1+G$147)","v":496594.01316956367},506525.89343295497,516656.41130161408,526989.53952764638,537529.33031819935,548279.91692456335,559245.51526305464,570430.42556831578,581839.03407968208,593475.81476127577,605345.33105650125,617452.23767763132,629801.28243118396]
[null,93398,"Dělník v dopravě - staniční dělník",null,359662.80740788288,366856.06355604052,{"$f":"F160*(1+G$147)","v":374193.18482716131},381677.04852370452,389310.5894941786,397096.80128406215,405038.73730974342,413139.51205593831,421402.30229705706,429830.34834299819,438426.95530985814,447195.49441605533,456139.40430437645,465262.19239046401,474567.43623827328]
[]
[]
[null,"3.9.","Počty zaměstnanců",null,{"$f":"E128","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a","Scénář s projektem"]
[null,{"$f":"B148","v":13167},"Dozorčí provozu"]
[null,31606,"Výpravčí"]
[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,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(E165:E177)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Odstupné",null,{"$f":"SUMPRODUCT($E$114:$E$126*(E$131/$D$114)/4,E165:E177-F165:F177)","v":0},{"$f":"SUMPRODUCT($E$114:$E$126*(F$131/$D$114)/4,F165:F177-G165:G177)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT($E$114:$E$126*(S$131/$D$114)/4,S165:S177-E183:E195)","v":0}]
[]
[null,{"$f":"B163","v":"3.9."},{"$f":"C163","v":"Počty zaměstnanců"},null,{"$f":"E145","v":2031},2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b","Scénář s projektem"]
[null,{"$f":"B165","v":13167},"Dozorčí provozu"]
[null,31606,"Výpravčí"]
[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,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(E183:E195)","v":0},{"$f":"SUM(F183:F195)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Odstupné",null,{"$f":"SUMPRODUCT($E$114:$E$126*(E$148/$D$114)/4,E183:E195-F183:F195)","v":0},{"$f":"SUMPRODUCT($E$114:$E$126*(F$148/$D$114)/4,F183:F195-G183:G195)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"3.10.",{"$f":"C181","v":"Počty zaměstnanců"},null,{"$f":"E163","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a","Scénář bez projektu"]
[null,{"$f":"B183","v":13167},"Dozorčí provozu"]
[null,31606,"Výpravčí"]
[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,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(E201:E213)","v":0},{"$f":"SUM(F201:F213)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Odstupné",null,{"$f":"SUMPRODUCT($E$114:$E$126*(E$131/$D$114)/4,E201:E213-F201:F213)","v":0},{"$f":"SUMPRODUCT($E$114:$E$126*(F$131/$D$114)/4,F201:F213-G201:G213)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT($E$114:$E$126*(S$131/$D$114)/4,S201:S213-E219:E231)","v":0}]
[]
[null,{"$f":"B199","v":"3.10."},{"$f":"C181","v":"Počty zaměstnanců"},null,{"$f":"E181","v":2031},2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b","Scénář bez projektu",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,{"$f":"B201","v":13167},"Dozorčí provozu"]
[null,31606,"Výpravčí"]
[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,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(E219:E231)","v":0},{"$f":"SUM(F219:F231)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Odstupné",null,{"$f":"SUMPRODUCT($E$114:$E$126*(E$148/$D$114)/4,E219:E231-F219:F231)","v":0},{"$f":"SUMPRODUCT($E$114:$E$126*(F$148/$D$114)/4,F219:F231-G219:G231)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Komentáře"]
[]
[null,"Zpracovatel uvede konkrétní hodnoty výstupů z dopravního prognózování použité při výpočtu nákladů na provoz vlaků. Tabulky 3.5. a 3.6. je možné přizpůsobit konkrétnímu projektu."]
[null,"V tabulce 3.1. a  3.2. uvede zpracovatel konkrétní výpočet pomocí vzorců u položky náklady na provoz vlaků, s odkazem na tabulky výkonů (tabulka 3.5. a 3.6.) a měrného ohodnocení (tab. 3.4.)."]

{"sheet":"4 Úspory v silniční dopravě","index":4,"n_rows":97,"n_cols":19,"rows_kept":97,"cut":false,"hidden":false,"merged":[[22,8,23,8],[22,6,23,6],[22,7,23,7],[22,4,23,4],[22,5,23,5],[32,4,33,4],[32,5,33,5],[32,6,33,6],[32,7,33,7],[22,14,23,14],[22,15,23,15],[22,12,23,12],[22,11,23,11],[22,13,23,13],[32,9,33,9],[22,10,23,10],[32,12,33,12],[32,13,33,13],[32,14,33,14],[32,15,33,15],[32,10,33,10],[1,9,2,9],[1,12,2,12],[32,16,33,16],[93,1,94,15],[32,8,33,8],[11,18,12,18],[22,17,23,17],[22,18,23,18],[22,16,23,16],[32,17,33,17],[32,18,33,18],[11,5,12,5],[11,6,12,6],[11,7,12,7],[67,4,68,4],[67,5,68,5],[67,6,68,6],[67,7,68,7],[67,8,68,8],[67,9,68,9],[22,9,23,9],[67,12,68,12],[67,13,68,13],[67,14,68,14],[1,18,2,18],[1,15,2,15],[1,16,2,16],[11,10,12,10],[11,11,12,11],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[11,4,12,4],[1,10,2,10],[1,11,2,11],[1,8,2,8],[1,14,2,14],[11,16,12,16],[11,17,12,17],[11,14,12,14],[11,15,12,15],[1,17,2,17],[11,13,12,13],[1,13,2,13],[11,8,12,8],[11,9,12,9],[11,12,12,12],[45,1,46,15],[67,15,68,15],[32,11,33,11],[67,16,68,16],[67,17,68,17],[67,18,68,18],[73,4,74,4],[73,5,74,5],[73,6,74,6],[73,7,74,7],[73,8,74,8],[73,9,74,9],[73,10,74,10],[73,11,74,11],[73,12,74,12],[73,13,74,13],[73,14,74,14],[73,15,74,15],[73,16,74,16],[67,10,68,10],[67,11,68,11],[73,17,74,17],[73,18,74,18],[80,4,81,4],[80,5,81,5],[80,6,81,6],[80,7,81,7],[80,8,81,8],[80,9,81,9],[80,10,81,10],[80,11,81,11],[80,18,81,18],[86,4,87,4],[86,5,87,5],[86,6,87,6],[86,7,87,7],[86,8,87,8],[86,9,87,9],[86,10,87,10],[86,15,87,15],[86,16,87,16],[86,17,87,17],[86,18,87,18],[86,11,87,11],[86,12,87,12],[86,13,87,13],[86,14,87,14],[80,12,81,12],[80,13,81,13],[80,14,81,14],[80,15,81,15],[80,16,81,16],[80,17,81,17]]}
[]
[null,"4.1.","Provozní náklady silniční dopravy - úspory (CZK)",null,{"$f":"'0 Úvod'!G19","v":2016},{"$f":"E2+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a",null,"Celkem"]
[null,"*","Náklady na údržbu a provoz - osobní doprava",{"$f":"SUM(E4:S4,E14:S14)","v":0}]
[null,"*","Náklady na údržbu a provoz - nákladní doprava",{"$f":"SUM(E5:S5,E15:S15)","v":0}]
[null,"**","Provozní náklady vozidel - IAD",0]
[null,"**","Provozní náklady vozidel - BUS",0]
[null,"**","Provozní náklady vozidel - LUV",0]
[null,"**","Provozní náklady vozidel - TUV",0]
[null,null,"Provozní náklady silniční dopravy - úspory ",0,{"$f":"SUM(E4:E9)","v":0},{"$f":"SUM(F4:F9)","v":0},{"$f":"SUM(G4:G9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"4.1.","Provozní náklady silniční dopravy - úspory (CZK)",null,{"$f":"S2+1","v":2031},{"$f":"E12+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b"]
[null,"*","Náklady na údržbu a provoz - osobní doprava"]
[null,"*","Náklady na údržbu a provoz - nákladní doprava"]
[null,"**","Provozní náklady vozidel - IAD"]
[null,"**","Provozní náklady vozidel - BUS"]
[null,"**","Provozní náklady vozidel - LUV"]
[null,"**","Provozní náklady vozidel - TUV"]
[null,null,"Provozní náklady silniční dopravy - úspory ",null,{"$f":"SUM(E14:E19)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"4.2.","Úspory z provozních nákladů silniční dopravy (CZK)",null,{"$f":"E2","v":2016},{"$f":"E23+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a",null,"Celkem"]
[null,"*","Náklady na údržbu a provoz - osobní doprava",{"$f":"SUM(E25:S25,E35:S35)","v":0},{"$f":"E4","v":0},{"$f":"F4","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"*","Náklady na údržbu a provoz - nákladní doprava",{"$f":"SUM(E26:S26,E36:S36)","v":0},{"$f":"E5","v":0},{"$f":"F5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"**","Provozní náklady vozidel - IAD",0,{"$f":"E6","v":0},{"$f":"F6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"**","Provozní náklady vozidel - BUS",0,{"$f":"E7","v":0},{"$f":"F7","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"**","Provozní náklady vozidel - LUV",0,{"$f":"E8","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"**","Provozní náklady vozidel - TUV",0,{"$f":"E9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Provozní náklady silniční dopravy - úspory ",0,{"$f":"SUM(E25:E30)","v":0},{"$f":"SUM(F25:F30)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"4.2.","Úspory z provozních nákladů silniční dopravy (CZK)",null,{"$f":"S23+1","v":2031},{"$f":"E33+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b"]
[null,"*","Náklady na údržbu a provoz - osobní doprava",null,{"$f":"E14","v":0},{"$f":"F14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"*","Náklady na údržbu a provoz - nákladní doprava",null,{"$f":"E15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"**","Provozní náklady vozidel - IAD",null,{"$f":"E16","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"**","Provozní náklady vozidel - BUS",null,{"$f":"E17","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"**","Provozní náklady vozidel - LUV",null,{"$f":"E18","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"**","Provozní náklady vozidel - TUV",null,{"$f":"E19","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Provozní náklady silniční dopravy - úspory ",null,{"$f":"SUM(E35:E40)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,"Úspory (CZK)",{"$f":"D31","v":0}]
[]
[null,"Komentáře"]
[]
[null,"*","Úspory z nákladů na údržbu a provoz silniční infrastruktury"]
[null,"**","Úspory z nákladů na údržbu a provoz silničních vozidel"]
[]
[]
[null,"4.3.","Údržba a opravy silniční infrastruktury","CÚ","Osobní             [CZK/1000 oskm]","Nákladní                      [CZK/ 1000 čisté tkm]"]
[null,null,"Měrná hodnota",2012,4.3899999999999997,143.77000000000001]
[null,null,"Měrná hodnota",{"$f":"'0 Úvod'!D19","v":2016}]
[]
[null,"4.4.","Provoz vozidel","CÚ","IAD                          [CZK/vozkm]","BUS                      [CZK/vozkm]","Lehká užitková vozidla [CZK/vozkm]","Těžká užitková vozidla [CZK/vozkm]"]
[null,null,"Měrná hodnota",2012,5.68,19.309999999999999,8.0500000000000007,25.14]
[null,null,"Měrná hodnota",{"$f":"'0 Úvod'!D19","v":2016}]
[null,null,"Zdroj: „Metodika hodnocení efektivnosti investic - železniční infrastruktura\" MD ČR 2013"]
[]
[null,null,"Obsazenost","osob/vozidlo"]
[null,null,"IAD"]
[null,null,"BUS"]
[null,null,null,"č.tun/vozidlo"]
[null,null,"LUV"]
[null,null,"TUV"]
[]
[null,"4.5.","Celkové oskm",null,{"$f":"E2","v":2016},{"$f":"E68+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a",null,"Celkem"]
[null,null,"IAD",{"$f":"SUM(E70:S70,E76:S76)","v":0}]
[null,null,"BUS",{"$f":"SUM(E71:S71,E77:S77)","v":0}]
[null,null,"celkové oskm",{"$f":"SUM(E72:S72,E78:S78)","v":0},{"$f":"SUM(E70:E71)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"B68","v":"4.5."},{"$f":"C68","v":"Celkové oskm"},null,{"$f":"S68+1","v":2031},{"$f":"E74+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b"]
[null,null,{"$f":"C70","v":"IAD"}]
[null,null,{"$f":"C71","v":"BUS"}]
[null,null,{"$f":"C72","v":"celkové oskm"},null,{"$f":"SUM(E76:E77)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"4.6.","Total č.tkm",null,{"$f":"E68","v":2016},{"$f":"E81+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a",null,"Celkem"]
[null,null,"LUV",{"$f":"SUM(E83:S83,E89:S89)","v":0}]
[null,null,"TUV",{"$f":"SUM(E84:S84,E90:S90)","v":0}]
[null,null,"celkové č.tkm",0,{"$f":"SUM(E83:E84)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"B81","v":"4.6."},{"$f":"C81","v":"Total č.tkm"},null,{"$f":"S81+1","v":2031},{"$f":"E87+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b"]
[null,null,{"$f":"C83","v":"LUV"}]
[null,null,{"$f":"C84","v":"TUV"}]
[null,null,{"$f":"C85","v":"celkové č.tkm"},null,{"$f":"SUM(E89:E90)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Komentáře"]
[]
[null,"Zpracovatel uvede konkrétní hodnoty výstupů z dopravního prognózování použité při výpočtu úspor silniční dopravy. Tabulky 4.5. a 4.6. je možné přizpůsobit konkrétnímu projektu."]
[null,"V tabulce 4.1. uvede zpracovatel konkrétní výpočet pomocí vzorců, s odkazem na tabulky výkonů (tabulka 4.5. a 4.6.) a měrného ohodnocení (tabulka 4.3. a 4.4.)."]

{"sheet":"5 Úspory z cestovních dob","index":5,"n_rows":150,"n_cols":19,"rows_kept":150,"cut":false,"hidden":false,"merged":[[35,7,36,7],[35,8,36,8],[35,9,36,9],[43,7,44,7],[145,1,146,15],[59,8,60,8],[59,9,60,9],[59,10,60,10],[75,1,76,2],[59,4,60,4],[59,13,60,13],[59,14,60,14],[59,15,60,15],[59,6,60,6],[92,4,93,4],[92,5,93,5],[92,6,93,6],[92,11,93,11],[92,12,93,12],[92,13,93,13],[92,14,93,14],[92,7,93,7],[92,8,93,8],[92,9,93,9],[52,9,53,9],[52,10,53,10],[35,18,36,18],[35,13,36,13],[35,14,36,14],[43,18,44,18],[35,15,36,15],[43,16,44,16],[35,16,36,16],[43,14,44,14],[43,15,44,15],[35,17,36,17],[43,17,44,17],[35,10,36,10],[35,11,36,11],[43,12,44,12],[43,13,44,13],[43,11,44,11],[43,10,44,10],[43,9,44,9],[35,12,36,12],[18,17,19,17],[26,18,27,18],[26,15,27,15],[26,16,27,16],[26,13,27,13],[18,16,19,16],[26,14,27,14],[18,18,19,18],[18,8,19,8],[18,14,19,14],[26,9,27,9],[18,11,19,11],[18,12,19,12],[18,9,19,9],[26,8,27,8],[26,17,27,17],[26,10,27,10],[26,11,27,11],[26,12,27,12],[18,10,19,10],[18,15,19,15],[18,13,19,13],[1,10,2,10],[1,11,2,11],[1,18,2,18],[1,15,2,15],[1,16,2,16],[1,17,2,17],[9,10,10,10],[9,11,10,11],[9,12,10,12],[9,17,10,17],[9,14,10,14],[9,15,10,15],[9,16,10,16],[9,18,10,18],[9,13,10,13],[77,1,84,1],[35,4,36,4],[77,2,78,2],[79,2,80,2],[81,2,82,2],[83,2,84,2],[18,4,19,4],[26,4,27,4],[26,5,27,5],[52,4,53,4],[52,5,53,5],[43,4,44,4],[43,5,44,5],[72,4,72,8],[26,7,27,7],[18,5,19,5],[18,6,19,6],[18,7,19,7],[59,7,60,7],[52,7,53,7],[52,8,53,8],[35,5,36,5],[43,6,44,6],[43,8,44,8],[123,17,124,17],[123,12,124,12],[123,10,124,10],[102,16,103,16],[102,7,103,7],[9,4,10,4],[1,5,2,5],[52,6,53,6],[59,5,60,5],[1,4,2,4],[26,6,27,6],[35,6,36,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[9,7,10,7],[9,8,10,8],[9,9,10,9],[9,5,10,5],[1,6,2,6],[9,6,10,6],[1,12,2,12],[1,14,2,14],[1,13,2,13],[113,17,114,17],[113,15,114,15],[104,1,105,1],[106,1,107,1],[102,13,103,13],[102,14,103,14],[102,9,103,9],[102,10,103,10],[102,11,103,11],[102,12,103,12],[102,17,103,17],[102,5,103,5],[102,6,103,6],[108,1,109,1],[113,4,114,4],[113,5,114,5],[113,6,114,6],[113,7,114,7],[113,8,114,8],[113,16,114,16],[92,16,93,16],[123,4,124,4],[96,1,97,1],[98,1,99,1],[102,4,103,4],[123,14,124,14],[123,15,124,15],[123,9,124,9],[123,11,124,11],[92,10,93,10],[94,1,95,1],[92,17,93,17],[92,18,93,18],[129,1,130,1],[115,1,116,1],[117,1,118,1],[119,1,120,1],[127,1,128,1],[125,1,126,1],[123,5,124,5],[123,6,124,6],[123,7,124,7],[123,8,124,8],[123,13,124,13],[123,18,124,18],[123,16,124,16],[113,9,114,9],[113,10,114,10],[113,18,114,18],[113,11,114,11],[113,12,114,12],[113,13,114,13],[113,14,114,14],[102,18,103,18],[102,8,103,8],[134,5,135,5],[134,6,135,6],[134,7,135,7],[134,8,135,8],[134,9,135,9],[134,10,135,10],[134,12,135,12],[134,13,135,13],[92,15,93,15],[102,15,103,15],[139,13,140,13],[139,14,140,14],[139,15,140,15],[139,16,140,16],[139,17,140,17],[139,18,140,18],[134,11,135,11],[74,1,74,3],[85,1,87,2],[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,10,140,10],[139,11,140,11],[139,12,140,12],[134,14,135,14],[134,15,135,15],[134,16,135,16],[134,17,135,17],[134,18,135,18],[134,4,135,4],[72,10,73,13],[59,18,60,18],[59,11,60,11],[59,12,60,12],[52,18,53,18],[52,17,53,17],[52,13,53,13],[52,11,53,11],[59,16,60,16],[59,17,60,17],[52,14,53,14],[52,12,53,12],[52,15,53,15],[52,16,53,16]]}
[]
[null,"5.1.","Úspory z cestovních dob v železniční dopravě (CZK)",null,{"$f":"'0 Úvod'!G19","v":2016},{"$f":"E2+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a",null,"Celkem"]
[null,null,"Osobní - příměstská",{"$f":"SUM(E4:S4,E12:S12)","v":0}]
[null,null,"Osobní - dálková",{"$f":"SUM(E5:S5,E13:S13)","v":0}]
[null,null,"Nákladní - místní",0]
[null,null,"Nákladní - dálková",0]
[null,null,"Celkové úspory z cestovních dob v železniční dopravě",0,{"$f":"SUM(E4:E7)","v":0},{"$f":"SUM(F4:F7)","v":0},{"$f":"SUM(G4:G7)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"5.1.","Úspory z cestovních dob v železniční dopravě (CZK)",null,{"$f":"S2+1","v":2031},{"$f":"E10+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b"]
[null,null,"Osobní - příměstská"]
[null,null,"Osobní - dálková"]
[null,null,"Nákladní - místní"]
[null,null,"Nákladní - dálková"]
[null,null,"Celkové úspory z cestovních dob v železniční dopravě",null,{"$f":"SUM(E12:E15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"5.2.","Úspory z cestovních dob indukované dopravy (CZK)",null,{"$f":"E2","v":2016},{"$f":"E19+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a",null,"Celkem"]
[null,null,"Osobní - příměstská",{"$f":"SUM(E21:S21,E29:S29)","v":0}]
[null,null,"Osobní - dálková",{"$f":"SUM(E22:S22,E30:S30)","v":0}]
[null,null,"Nákladní - místní",0]
[null,null,"Nákladní - dálková",0]
[null,null,"Celkové úspory z cestovních dob indukované dopravy",0,{"$f":"SUM(E21:E24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"5.2.","Úspory z cestovních dob indukované dopravy (CZK)",null,{"$f":"S19+1","v":2031},{"$f":"E27+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b"]
[null,null,"Osobní - příměstská"]
[null,null,"Osobní - dálková"]
[null,null,"Nákladní - místní"]
[null,null,"Nákladní - dálková"]
[null,null,"Celkové úspory z cestovních dob indukované dopravy",null,{"$f":"SUM(E29:E32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"5.3.","Úspory z cestovních dob převedené dopravy (CZK)",null,{"$f":"E19","v":2016},{"$f":"E36+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a",null,"Celkem"]
[null,null,{"$f":"C99","v":"BUS"},{"$f":"SUM(E38:S38,E46:S46)","v":0}]
[null,null,{"$f":"C100","v":"IAD"},{"$f":"SUM(E39:S39,E47:S47)","v":0}]
[null,null,{"$f":"C120","v":"LUV"},0]
[null,null,{"$f":"C121","v":"TUV"},0]
[null,null,"Celkové úspory z cestovních dob převedené dopravy",0,{"$f":"SUM(E38:E41)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"5.3.","Úspory z cestovních dob převedené dopravy (CZK)",null,{"$f":"S36+1","v":2031},{"$f":"E44+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b"]
[null,null,{"$f":"C38","v":"BUS"}]
[null,null,{"$f":"C39","v":"IAD"}]
[null,null,{"$f":"C40","v":"LUV"}]
[null,null,{"$f":"C41","v":"TUV"}]
[null,null,"Celkové úspory z cestovních dob převedené dopravy",null,{"$f":"SUM(E46:E49)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"5.4.","Celkové úspory z cestovních dob (CZK)",null,{"$f":"E2","v":2016},{"$f":"E53+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a",null,"Celkem"]
[null,null,"Celkové úspory z cestovních dob v železniční dopravě",{"$f":"SUM(E55:S55,E62:S62)","v":0},{"$f":"E8","v":0},{"$f":"F8","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Celkové úspory z cestovních dob indukované dopravy",{"$f":"SUM(E56:S56,E63:S63)","v":0},{"$f":"E25","v":0},{"$f":"F25","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Celkové úspory z cestovních dob převedené dopravy",0,{"$f":"E42","v":0},{"$f":"F42","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Celkové úspory z cestovních dob",0,{"$f":"SUM(E55:E57)","v":0},{"$f":"SUM(F55:F57)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"5.4.","Celkové úspory z cestovních dob (CZK)",null,{"$f":"S53+1","v":2031},{"$f":"E60+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b",null,"Celkem"]
[null,null,"Celkové úspory z cestovních dob v železniční dopravě",null,{"$f":"E16","v":0},{"$f":"F16","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Celkové úspory z cestovních dob indukované dopravy",null,{"$f":"E33","v":0},{"$f":"F33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Celkové úspory z cestovních dob převedené dopravy",null,{"$f":"E50","v":0},{"$f":"F50","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Celkové úspory z cestovních dob",null,{"$f":"SUM(E62:E64)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,"Úspory z cestovních dob v železniční dopravě (CZK)",{"$f":"D8","v":0}]
[null,null,"Úspory z cestovních dob indukované dopravy (CZK)",{"$f":"D25","v":0}]
[null,null,"Úspory z cestovních dob převedené dopravy (CZK)",{"$f":"D42","v":0}]
[null,null,"Celkové úspory z cestovních dob (CZK)",{"$f":"D58","v":0}]
[]
[null,null,null,null,"CÚ",null,null,null,null,null,"Poměr cest"]
[null,"5.5.",null,null,2002,2002,2012,2012,{"$f":"'0 Úvod'!D19","v":2016}]
[null,"Osobní doprava",null,null,"EUR/oshod","CZK/oshod","EUR/oshod","CZK/oshod","CZK/oshod",null,"krátké","dlouhé","BUS","IAD"]
[null,"Pracovní čas",null,"Bus",11.45,352.8,21.24,524.1,null,null,null,null,0.05]
[null,null,null,"Auto, vlak",14.27,439.7,26.47,653.20000000000005,null,null,0.05,0.05,null,0.05]
[null,"Nepracovní čas","Krátká dojížďka","Bus",4.13,127.2,7.66,189.1,null,null,null,null,{"$f":"95%/4","v":0.23749999999999999}]
[null,null,null,"Auto, vlak",5.75,177.2,10.67,263.2,null,null,{"$f":"95%/2","v":0.47499999999999998},null,null,{"$f":"95%/4","v":0.23749999999999999}]
[null,null,"Dlouhá dojížďka","Bus",5.31,163.6,9.85,243.1,null,null,null,null,{"$f":"95%/4","v":0.23749999999999999}]
[null,null,null,"Auto, vlak",7.38,227.4,13.69,337.8,null,null,null,{"$f":"95%/2","v":0.47499999999999998},null,{"$f":"95%/4","v":0.23749999999999999}]
[null,null,"Ostatní - krátká vzdálenost","Bus",3.46,106.6,6.42,158.4,null,null,null,null,{"$f":"95%/4","v":0.23749999999999999}]
[null,null,null,"Auto, vlak",4.82,148.5,8.94,220.6,null,null,{"$f":"95%/2","v":0.47499999999999998},null,null,{"$f":"95%/4","v":0.23749999999999999}]
[null,null,"Ostatní - dlouhá vzdálenost","Bus",4.45,137.1,8.26,203.7,null,null,null,null,{"$f":"95%/4","v":0.23749999999999999}]
[null,null,null,"Auto, vlak",6.18,190.4,11.46,282.89999999999998,null,null,null,{"$f":"95%/2","v":0.47499999999999998},null,{"$f":"95%/4","v":0.23749999999999999}]
[null,"Nákladní doprava",null,null,"EUR/thod","CZK/thod","EUR/thod","CZK/thod","CZK/thod",null,{"$f":"SUMPRODUCT($I$76:$I$85,K76:K85)","v":0},{"$f":"SUMPRODUCT($I$76:$I$85,L76:L85)","v":0},{"$f":"SUMPRODUCT($I$76:$I$85,M76:M85)","v":0},{"$f":"SUMPRODUCT($I$76:$I$85,N76:N85)","v":0}]
[null,null,null,"Silnice",2.06,63.47,3.82,94.3]
[null,null,null,"Železnice",0.84,25.88,1.56,38.450000000000003]
[null,"Zdroj: „HEATCO - Developing Harmonized European Approaches for Transport Costing and Project Assessment“, 2004 – 2006"]
[null,"Pozn. Zpracovatel může použít i jiné ohodnocení času. Hodnota času ale musí být v souladu s materiálem „Metodika hodnocení efektivnosti investic - železniční infrastruktura“ 2013"]
[]
[]
[null,"5.6.","Celkové oshod",null,{"$f":"E2","v":2016},{"$f":"E93+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a",null,"Celkem"]
[null,"Želez. doprava","Osobní - příměstská",{"$f":"SUM(E95:S95,E105:S105)","v":0}]
[null,null,"Osobní - dálková",{"$f":"SUM(E96:S96,E106:S106)","v":0}]
[null,"Indukov. doprava","Osobní - příměstská",0]
[null,null,"Osobní - dálková",0]
[null,"Převed. doprava","BUS",0]
[null,null,"IAD",0]
[null,null,"Celkové oshod",0,{"$f":"SUM(E95:E100)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"B93","v":"5.6."},{"$f":"C93","v":"Celkové oshod"},null,{"$f":"S93+1","v":2031},{"$f":"E103+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b"]
[null,{"$f":"B95","v":"Želez. doprava"},{"$f":"C95","v":"Osobní - příměstská"}]
[null,null,{"$f":"C96","v":"Osobní - dálková"}]
[null,{"$f":"B97","v":"Indukov. doprava"},"Osobní - příměstská"]
[null,null,"Osobní - dálková"]
[null,{"$f":"B99","v":"Převed. doprava"},"BUS"]
[null,null,"IAD"]
[null,null,"Celkové oshod",null,{"$f":"SUM(E105:E110)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"5.7.","Celkové thod",null,{"$f":"E2","v":2016},{"$f":"E114+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a",null,"Celkem"]
[null,"Želez. doprava","Nákladní - regionální",{"$f":"SUM(E116:S116,E126:S126)","v":0}]
[null,null,"Nákladní - dálková",{"$f":"SUM(E117:S117,E127:S127)","v":0}]
[null,"Indukov. doprava","Nákladní - regionální",0]
[null,null,"Nákladní - dálková",0]
[null,"Převed. doprava","LUV",0]
[null,null,"TUV",0]
[null,null,"Celkové thod",0,{"$f":"SUM(E116:E121)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"B114","v":"5.7."},{"$f":"C114","v":"Celkové thod"},null,{"$f":"S114+1","v":2031},{"$f":"E124+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b"]
[null,{"$f":"B116","v":"Želez. doprava"},{"$f":"C116","v":"Nákladní - regionální"}]
[null,null,{"$f":"C117","v":"Nákladní - dálková"}]
[null,{"$f":"B118","v":"Indukov. doprava"},"Nákladní - regionální"]
[null,null,"Nákladní - dálková"]
[null,{"$f":"B120","v":"Převed. doprava"},"LUV"]
[null,null,"TUV"]
[null,null,"Celkové thod",null,{"$f":"SUM(E126:E131)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"5.8.","Změna měrných hodnot času",null,{"$f":"E2","v":2016},{"$f":"E135+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a",null,"Elasticita"]
[null,null,"Hodnota růstu HDP na hlavu (resp. prognóza)",0.7,0,{"$f":"$D$137*IF(HLOOKUP(F$135,'0 Úvod'!$K$65:$N$66,1,TRUE)=F$135,HLOOKUP(F$135,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(F$135,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":2.0299999999999999E-2},{"$f":"$D$137*IF(HLOOKUP(G$135,'0 Úvod'!$K$65:$N$66,1,TRUE)=G$135,HLOOKUP(G$135,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(G$135,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":2.0999999999999998E-2},{"$f":"$D$137*IF(HLOOKUP(H$135,'0 Úvod'!$K$65:$N$66,1,TRUE)=H$135,HLOOKUP(H$135,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(H$135,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":2.0999999999999998E-2},{"$f":"$D$137*IF(HLOOKUP(I$135,'0 Úvod'!$K$65:$N$66,1,TRUE)=I$135,HLOOKUP(I$135,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(I$135,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":1.3999999999999999E-2},{"$f":"$D$137*IF(HLOOKUP(J$135,'0 Úvod'!$K$65:$N$66,1,TRUE)=J$135,HLOOKUP(J$135,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(J$135,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":1.3999999999999999E-2},{"$f":"$D$137*IF(HLOOKUP(K$135,'0 Úvod'!$K$65:$N$66,1,TRUE)=K$135,HLOOKUP(K$135,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(K$135,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":1.3999999999999999E-2},{"$f":"$D$137*IF(HLOOKUP(L$135,'0 Úvod'!$K$65:$N$66,1,TRUE)=L$135,HLOOKUP(L$135,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(L$135,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":1.3999999999999999E-2},{"$f":"$D$137*IF(HLOOKUP(M$135,'0 Úvod'!$K$65:$N$66,1,TRUE)=M$135,HLOOKUP(M$135,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(M$135,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":1.3999999999999999E-2},{"$f":"$D$137*IF(HLOOKUP(N$135,'0 Úvod'!$K$65:$N$66,1,TRUE)=N$135,HLOOKUP(N$135,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(N$135,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":1.3999999999999999E-2},{"$f":"$D$137*IF(HLOOKUP(O$135,'0 Úvod'!$K$65:$N$66,1,TRUE)=O$135,HLOOKUP(O$135,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(O$135,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":1.3999999999999999E-2},{"$f":"$D$137*IF(HLOOKUP(P$135,'0 Úvod'!$K$65:$N$66,1,TRUE)=P$135,HLOOKUP(P$135,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(P$135,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":1.3999999999999999E-2},{"$f":"$D$137*IF(HLOOKUP(Q$135,'0 Úvod'!$K$65:$N$66,1,TRUE)=Q$135,HLOOKUP(Q$135,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(Q$135,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":1.3999999999999999E-2},{"$f":"$D$137*IF(HLOOKUP(R$135,'0 Úvod'!$K$65:$N$66,1,TRUE)=R$135,HLOOKUP(R$135,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(R$135,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":1.3999999999999999E-2},{"$f":"$D$137*IF(HLOOKUP(S$135,'0 Úvod'!$K$65:$N$66,1,TRUE)=S$135,HLOOKUP(S$135,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(S$135,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":6.9999999999999993E-3}]
[null,null,"Výsledný růstový koeficient hodnoty času",null,1,{"$f":"E138*(1+F137)","v":1.0203},{"$f":"F138*(1+G137)","v":1.0417262999999999},1.0636025522999999,1.0784929880321998,1.0935918898646506,1.1089021763227558,1.1244268067912744,1.1401687820863522,1.1561311450355611,1.172316981066059,1.1887294188009838,1.2053716306641975,1.2222468334934964,1.2308025613279507]
[]
[null,{"$f":"B135","v":"5.8."},{"$f":"C135","v":"Změna měrných hodnot času"},null,{"$f":"S135+1","v":2031},{"$f":"E140+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b",null,"Elasticita"]
[null,null,{"$f":"C137","v":"Hodnota růstu HDP na hlavu (resp. prognóza)"},{"$f":"D137","v":0.7},{"$f":"$D$142*IF(HLOOKUP(E$140,'0 Úvod'!$K$65:$N$66,1,TRUE)=E$140,HLOOKUP(E$140,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(E$140,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":6.9999999999999993E-3},{"$f":"$D$142*IF(HLOOKUP(F$140,'0 Úvod'!$K$65:$N$66,1,TRUE)=F$140,HLOOKUP(F$140,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(F$140,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":6.9999999999999993E-3},{"$f":"$D$142*IF(HLOOKUP(G$140,'0 Úvod'!$K$65:$N$66,1,TRUE)=G$140,HLOOKUP(G$140,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(G$140,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":6.9999999999999993E-3},{"$f":"$D$142*IF(HLOOKUP(H$140,'0 Úvod'!$K$65:$N$66,1,TRUE)=H$140,HLOOKUP(H$140,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(H$140,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":6.9999999999999993E-3},{"$f":"$D$142*IF(HLOOKUP(I$140,'0 Úvod'!$K$65:$N$66,1,TRUE)=I$140,HLOOKUP(I$140,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(I$140,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":6.9999999999999993E-3},{"$f":"$D$142*IF(HLOOKUP(J$140,'0 Úvod'!$K$65:$N$66,1,TRUE)=J$140,HLOOKUP(J$140,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(J$140,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":6.9999999999999993E-3},{"$f":"$D$142*IF(HLOOKUP(K$140,'0 Úvod'!$K$65:$N$66,1,TRUE)=K$140,HLOOKUP(K$140,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(K$140,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":6.9999999999999993E-3},{"$f":"$D$142*IF(HLOOKUP(L$140,'0 Úvod'!$K$65:$N$66,1,TRUE)=L$140,HLOOKUP(L$140,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(L$140,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":6.9999999999999993E-3},{"$f":"$D$142*IF(HLOOKUP(M$140,'0 Úvod'!$K$65:$N$66,1,TRUE)=M$140,HLOOKUP(M$140,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(M$140,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":6.9999999999999993E-3},{"$f":"$D$142*IF(HLOOKUP(N$140,'0 Úvod'!$K$65:$N$66,1,TRUE)=N$140,HLOOKUP(N$140,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(N$140,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":6.9999999999999993E-3},{"$f":"$D$142*IF(HLOOKUP(O$140,'0 Úvod'!$K$65:$N$66,1,TRUE)=O$140,HLOOKUP(O$140,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(O$140,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":6.9999999999999993E-3},{"$f":"$D$142*IF(HLOOKUP(P$140,'0 Úvod'!$K$65:$N$66,1,TRUE)=P$140,HLOOKUP(P$140,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(P$140,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":6.9999999999999993E-3},{"$f":"$D$142*IF(HLOOKUP(Q$140,'0 Úvod'!$K$65:$N$66,1,TRUE)=Q$140,HLOOKUP(Q$140,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(Q$140,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":6.9999999999999993E-3},{"$f":"$D$142*IF(HLOOKUP(R$140,'0 Úvod'!$K$65:$N$66,1,TRUE)=R$140,HLOOKUP(R$140,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(R$140,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":6.9999999999999993E-3},{"$f":"$D$142*IF(HLOOKUP(S$140,'0 Úvod'!$K$65:$N$66,1,TRUE)=S$140,HLOOKUP(S$140,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(S$140,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":6.9999999999999993E-3}]
[null,null,{"$f":"C138","v":"Výsledný růstový koeficient hodnoty času"},null,{"$f":"S138*(1+E142)","v":1.2394181792572463},{"$f":"E143*(1+F142)","v":1.2480941065120468},{"$f":"F143*(1+G142)","v":1.2568307652576309},1.2656285806144343,1.2744879806787353,1.2834093965434863,1.2923932623192906,1.3014400151555254,1.310550095261614,1.3197239459284451,1.328962013549944,1.3382647476447935,1.3476326008783071,1.357066029084455,1.3665654912880461]
[]
[]
[null,"Komentáře"]
[]
[null,"Zpracovatel uvede konkrétní hodnoty výstupů z dopravního prognózování použité při výpočtu úspor času. Tabulky 5.6. a 5.7. je možné přizpůsobit konkrétnímu projektu."]
[null,"V tabulce 5.1., 5.2. a  5.3. uvede zpracovatel konkrétní výpočet pomocí vzorců, s odkazem na tabulky výkonů (tabulka 5.6. a 5.7.) a měrného ohodnocení (tabulka 5.5.)."]
[null,"a vynásobí hodnoty v tabulce 5.1, 5.2 a 5.3 hodnotou z tabulky 5.8"]

{"sheet":"6 Externality","index":6,"n_rows":300,"n_cols":19,"rows_kept":300,"cut":false,"hidden":false,"merged":[[276,1,278,1],[265,13,266,13],[265,14,266,14],[265,15,266,15],[265,16,266,16],[265,17,266,17],[265,18,266,18],[270,4,271,4],[270,5,271,5],[270,6,271,6],[270,7,271,7],[270,8,271,8],[270,9,271,9],[270,10,271,10],[270,11,271,11],[270,12,271,12],[270,13,271,13],[270,14,271,14],[270,15,271,15],[270,16,271,16],[270,17,271,17],[270,18,271,18],[265,4,266,4],[265,5,266,5],[265,6,266,6],[265,7,266,7],[265,8,266,8],[265,9,266,9],[265,10,266,10],[265,11,266,11],[265,12,266,12],[246,13,247,13],[246,14,247,14],[246,9,247,9],[246,10,247,10],[246,11,247,11],[246,12,247,12],[246,15,247,15],[246,16,247,16],[246,17,247,17],[246,18,247,18],[255,4,256,4],[255,5,256,5],[255,6,256,6],[255,7,256,7],[255,8,256,8],[255,9,256,9],[255,10,256,10],[255,11,256,11],[255,12,256,12],[255,13,256,13],[255,14,256,14],[255,15,256,15],[255,16,256,16],[255,17,256,17],[255,18,256,18],[246,4,247,4],[246,5,247,5],[246,6,247,6],[246,7,247,7],[246,8,247,8],[235,16,236,16],[235,17,236,17],[235,18,236,18],[240,4,241,4],[240,5,241,5],[240,6,241,6],[240,7,241,7],[240,8,241,8],[240,9,241,9],[240,10,241,10],[240,11,241,11],[240,12,241,12],[240,13,241,13],[240,14,241,14],[240,15,241,15],[240,16,241,16],[240,17,241,17],[240,18,241,18],[235,4,236,4],[235,5,236,5],[235,6,236,6],[235,7,236,7],[235,8,236,8],[235,9,236,9],[235,10,236,10],[235,11,236,11],[235,12,236,12],[216,13,217,13],[216,14,217,14],[216,15,217,15],[216,10,217,10],[216,11,217,11],[216,12,217,12],[235,13,236,13],[235,14,236,14],[235,15,236,15],[216,16,217,16],[216,17,217,17],[216,18,217,18],[225,4,226,4],[225,5,226,5],[225,6,226,6],[225,7,226,7],[225,8,226,8],[225,9,226,9],[225,10,226,10],[225,11,226,11],[225,12,226,12],[225,13,226,13],[225,14,226,14],[225,15,226,15],[225,16,226,16],[225,17,226,17],[225,18,226,18],[216,4,217,4],[216,5,217,5],[216,6,217,6],[216,7,217,7],[216,8,217,8],[216,9,217,9],[205,16,206,16],[205,17,206,17],[205,18,206,18],[210,4,211,4],[210,5,211,5],[210,6,211,6],[210,7,211,7],[210,8,211,8],[210,9,211,9],[210,10,211,10],[210,11,211,11],[210,12,211,12],[210,13,211,13],[210,14,211,14],[210,15,211,15],[210,16,211,16],[210,17,211,17],[210,18,211,18],[205,4,206,4],[205,5,206,5],[205,6,206,6],[205,7,206,7],[205,8,206,8],[205,9,206,9],[205,10,206,10],[205,11,206,11],[205,12,206,12],[186,13,187,13],[186,14,187,14],[186,15,187,15],[186,10,187,10],[186,11,187,11],[186,12,187,12],[205,13,206,13],[205,14,206,14],[205,15,206,15],[186,16,187,16],[186,17,187,17],[186,18,187,18],[195,4,196,4],[195,5,196,5],[195,6,196,6],[195,7,196,7],[195,8,196,8],[195,9,196,9],[195,10,196,10],[195,11,196,11],[195,12,196,12],[195,13,196,13],[195,14,196,14],[195,15,196,15],[195,16,196,16],[195,17,196,17],[195,18,196,18],[186,4,187,4],[186,5,187,5],[186,6,187,6],[186,7,187,7],[186,8,187,8],[186,9,187,9],[175,16,176,16],[175,17,176,17],[175,18,176,18],[180,4,181,4],[180,5,181,5],[180,6,181,6],[180,7,181,7],[180,8,181,8],[180,9,181,9],[180,10,181,10],[180,11,181,11],[180,12,181,12],[180,13,181,13],[180,14,181,14],[180,15,181,15],[180,16,181,16],[180,17,181,17],[180,18,181,18],[175,4,176,4],[175,5,176,5],[175,6,176,6],[175,7,176,7],[175,8,176,8],[175,9,176,9],[175,10,176,10],[175,11,176,11],[175,12,176,12],[156,13,157,13],[156,14,157,14],[156,15,157,15],[156,10,157,10],[156,11,157,11],[156,12,157,12],[175,13,176,13],[175,14,176,14],[175,15,176,15],[156,16,157,16],[156,17,157,17],[156,18,157,18],[165,4,166,4],[165,5,166,5],[165,6,166,6],[165,7,166,7],[165,8,166,8],[165,9,166,9],[165,10,166,10],[165,11,166,11],[165,12,166,12],[165,13,166,13],[165,14,166,14],[165,15,166,15],[165,16,166,16],[165,17,166,17],[165,18,166,18],[156,4,157,4],[156,5,157,5],[156,6,157,6],[156,7,157,7],[156,8,157,8],[156,9,157,9],[292,1,293,15],[110,9,110,12],[81,1,84,1],[85,1,88,1],[111,2,111,6],[117,2,117,6],[111,8,111,12],[117,8,117,12],[126,4,127,4],[126,5,127,5],[97,2,97,6],[126,9,127,9],[126,10,127,10],[126,11,127,11],[126,12,127,12],[103,2,103,6],[126,6,127,6],[126,7,127,7],[126,8,127,8],[110,2,110,6],[145,14,146,14],[145,15,146,15],[145,9,146,9],[145,10,146,10],[69,1,72,1],[73,1,76,1],[44,1,47,1],[48,1,51,1],[23,1,26,1],[27,1,30,1],[56,1,59,1],[60,1,63,1],[31,1,34,1],[35,1,38,1],[21,18,22,18],[21,12,22,12],[21,13,22,13],[21,14,22,14],[21,16,22,16],[21,17,22,17],[1,11,2,11],[11,1,14,1],[15,1,18,1],[3,1,6,1],[7,1,10,1],[1,4,2,4],[1,5,2,5],[21,4,22,4],[21,5,22,5],[21,6,22,6],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,18,2,18],[1,12,2,12],[1,13,2,13],[1,14,2,14],[42,4,43,4],[42,5,43,5],[42,6,43,6],[42,9,43,9],[42,10,43,10],[42,11,43,11],[1,15,2,15],[1,16,2,16],[1,17,2,17],[1,10,2,10],[21,9,22,9],[21,11,22,11],[42,16,43,16],[42,7,43,7],[21,15,22,15],[21,10,22,10],[42,12,43,12],[42,13,43,13],[42,14,43,14],[42,15,43,15],[42,8,43,8],[21,8,22,8],[21,7,22,7],[54,4,55,4],[54,5,55,5],[54,6,55,6],[54,7,55,7],[54,8,55,8],[54,9,55,9],[54,10,55,10],[54,18,55,18],[54,15,55,15],[54,16,55,16],[54,17,55,17],[54,11,55,11],[54,12,55,12],[54,13,55,13],[54,14,55,14],[67,9,68,9],[67,10,68,10],[67,11,68,11],[67,12,68,12],[67,13,68,13],[67,16,68,16],[67,17,68,17],[42,17,43,17],[42,18,43,18],[135,17,136,17],[67,18,68,18],[79,4,80,4],[79,5,80,5],[79,6,80,6],[79,7,80,7],[79,8,80,8],[79,10,80,10],[67,14,68,14],[79,17,80,17],[79,18,80,18],[79,13,80,13],[79,14,80,14],[79,15,80,15],[79,16,80,16],[79,12,80,12],[79,11,80,11],[79,9,80,9],[67,7,68,7],[67,4,68,4],[67,5,68,5],[67,6,68,6],[67,15,68,15],[67,8,68,8],[145,12,146,12],[145,13,146,13],[145,4,146,4],[145,5,146,5],[145,6,146,6],[145,7,146,7],[145,8,146,8],[126,18,127,18],[135,4,136,4],[135,5,136,5],[135,6,136,6],[135,7,136,7],[135,8,136,8],[135,9,136,9],[135,10,136,10],[135,11,136,11],[126,13,127,13],[135,12,136,12],[135,14,136,14],[135,15,136,15],[126,17,127,17],[126,14,127,14],[126,15,127,15],[126,16,127,16],[286,16,287,16],[286,17,287,17],[286,18,287,18],[286,4,287,4],[286,5,287,5],[286,6,287,6],[286,7,287,7],[286,8,287,8],[286,9,287,9],[286,10,287,10],[286,11,287,11],[286,12,287,12],[286,13,287,13],[286,14,287,14],[286,15,287,15],[281,4,282,4],[281,5,282,5],[281,6,282,6],[281,7,282,7],[281,8,282,8],[281,17,282,17],[281,18,282,18],[281,9,282,9],[281,10,282,10],[281,11,282,11],[281,12,282,12],[281,13,282,13],[281,14,282,14],[281,15,282,15],[281,16,282,16],[97,1,108,1],[110,1,122,1],[135,18,136,18],[145,16,146,16],[145,17,146,17],[145,18,146,18],[135,16,136,16],[150,18,151,18],[150,11,151,11],[150,12,151,12],[150,13,151,13],[150,14,151,14],[145,11,146,11],[135,13,136,13],[150,4,151,4],[150,5,151,5],[150,6,151,6],[150,7,151,7],[150,9,151,9],[150,10,151,10],[150,15,151,15],[150,16,151,16],[150,17,151,17],[150,8,151,8]]}
[]
[null,"6.1.","Externí náklady (CZK)",null,{"$f":"'1 Celkové investiční náklady'!G3","v":2016},{"$f":"E2+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a","Scénář s projektem","Celkem"]
[null,"Železniční osobní doprava","Nehody",{"$f":"SUM(E4:S4,E24:S24)","v":0}]
[null,null,"Hluk",{"$f":"SUM(E5:S5,E25:S25)","v":0}]
[null,null,"Znečištění ovzduší",0]
[null,null,"Klimatické změny",0]
[null,"Železniční nákladní doprava","Nehody",0]
[null,null,"Hluk",0]
[null,null,"Znečištění ovzduší",0]
[null,null,"Klimatické změny",0]
[null,"Převedená osobní doprava","Nehody",0]
[null,null,"Hluk",0]
[null,null,"Znečištění ovzduší",0]
[null,null,"Klimatické změny",0]
[null,"Převedená nákladní doprava","Nehody",0]
[null,null,"Hluk",0]
[null,null,"Znečištění ovzduší",0]
[null,null,"Klimatické změny",0]
[null,null,"Celkové externí náklady",0,{"$f":"SUM(E4:E11)-SUM(E12:E19)","v":0},{"$f":"SUM(F4:F11)-SUM(F12:F19)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"6.1.","Externí náklady (CZK)",null,{"$f":"S2+1","v":2031},{"$f":"E22+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b","Scénář s projektem"]
[null,"Železniční osobní doprava","Nehody"]
[null,null,"Hluk"]
[null,null,"Znečištění ovzduší"]
[null,null,"Klimatické změny"]
[null,"Železniční nákladní doprava","Nehody"]
[null,null,"Hluk"]
[null,null,"Znečištění ovzduší"]
[null,null,"Klimatické změny"]
[null,"Převedená osobní doprava","Nehody"]
[null,null,"Hluk"]
[null,null,"Znečištění ovzduší"]
[null,null,"Klimatické změny"]
[null,"Převedená nákladní doprava","Nehody"]
[null,null,"Hluk"]
[null,null,"Znečištění ovzduší"]
[null,null,"Klimatické změny"]
[null,null,"Celkové externí náklady",null,{"$f":"SUM(E24:E31)-SUM(E32:E39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"6.2.","Externí náklady (CZK)",null,{"$f":"E2","v":2016},{"$f":"E43+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a","Scénář bez projektu","Celkem"]
[null,"Železniční osobní doprava","Nehody",{"$f":"SUM(E45:S45,E57:S57)","v":0}]
[null,null,"Hluk",{"$f":"SUM(E46:S46,E58:S58)","v":0}]
[null,null,"Znečištění ovzduší",0]
[null,null,"Klimatické změny",0]
[null,"Železniční nákladní doprava","Nehody",0]
[null,null,"Hluk",0]
[null,null,"Znečištění ovzduší",0]
[null,null,"Klimatické změny",0]
[null,null,"Celkové externí náklady",0,{"$f":"SUM(E45:E52)","v":0},{"$f":"SUM(F45:F52)","v":0},{"$f":"SUM(G45:G52)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(S45:S52)","v":0}]
[]
[null,"6.2.","Externí náklady (CZK)",null,{"$f":"S43+1","v":2031},{"$f":"E55+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b","Scénář bez projektu",null,{"$f":"S44+1","v":1}]
[null,"Železniční osobní doprava","Nehody"]
[null,null,"Hluk"]
[null,null,"Znečištění ovzduší"]
[null,null,"Klimatické změny"]
[null,"Železniční nákladní doprava","Nehody"]
[null,null,"Hluk"]
[null,null,"Znečištění ovzduší"]
[null,null,"Klimatické změny"]
[null,null,"Celkové externí náklady",null,{"$f":"SUM(E57:E64)","v":0},{"$f":"SUM(F57:F64)","v":0},{"$f":"SUM(G57:G64)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(S57:S64)","v":0}]
[]
[]
[null,"6.3.","Celkem externí efekty - úspory (CZK)",null,{"$f":"E2","v":2016},{"$f":"E68+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a",null,"Celkem"]
[null,"Osobní","Nehody",{"$f":"SUM(E70:S70,E82:S82)","v":0},{"$f":"E45-(E4-E12)","v":0},{"$f":"F45-(F4-F12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Hluk",{"$f":"SUM(E71:S71,E83:S83)","v":0},0,{"$f":"F46-(F5-F13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Znečištění ovzduší",0,0,{"$f":"F47-(F6-F14)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Klimatické změny",0,0,{"$f":"F48-(F7-F15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Nákladní","Nehody",0,0,{"$f":"F49-(F8-F16)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Hluk",0,0,{"$f":"F50-(F9-F17)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Znečištění ovzduší",0,{"$f":"E51-(E10-E18)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Klimatické změny",0,{"$f":"E52-(E11-E19)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Celkem externí efekty - úspory",0,{"$f":"E53-E20","v":0},{"$f":"F53-F20","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"6.3.","Celkem externí efekty - úspory (CZK)",null,{"$f":"S68+1","v":2031},{"$f":"E80+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b",null,null,{"$f":"S69+1","v":1}]
[null,"Osobní","Nehody",null,{"$f":"E57-(E24-E32)","v":0},{"$f":"F57-(F24-F32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Hluk",null,0,{"$f":"F58-(F25-F33)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Znečištění ovzduší",null,0,{"$f":"F59-(F26-F34)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Klimatické změny",null,0,{"$f":"F60-(F27-F35)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Nákladní","Nehody",null,0,{"$f":"F61-(F28-F36)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Hluk",null,0,{"$f":"F62-(F29-F37)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Znečištění ovzduší",null,{"$f":"E63-(E30-E38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Klimatické změny",null,{"$f":"E64-(E31-E39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Celkem externí efekty - úspory",null,{"$f":"E65-E40","v":0},{"$f":"F65-F40","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,"Externí náklady -  scénář s projektem (CZK)",{"$f":"D20","v":0}]
[null,null,"Externí náklady - scénář bez projektu (CZK)",{"$f":"D53","v":0}]
[null,null,"Celkem externí efekty - úspory (CZK)",{"$f":"D78","v":0}]
[]
[]
[null,"6.4.\na","Osobní doprava [EUR/1000 oskm] - výchozí hodnoty"]
[null,null,null,"Automobil","Motocykl","Autobus","Železnice"]
[null,null,"Nehody",36,250,3.1,0.9]
[null,null,"Hluk",5.7,17,1.3,3.9]
[null,null,"Znečištění ovzduší",17.3,7.9,19.600000000000001,4.9000000000000004]
[null,null,"Klimatické změny",15.9,13.8,8.9,5.3]
[null,null,"Nákladní doprava [EUR/1000 čistých tkm] - výchozí hodnoty"]
[null,null,null,"Lehká užitková vozidla","Těžká užitková vozidla","Železnice","Vodní"]
[null,null,"Nehody",100,6.8,11.5,null,null,null," "]
[null,null,"Hluk",35.700000000000003,5.0999999999999996,3.5]
[null,null,"Znečištění ovzduší",131,32.4,4,9.6999999999999993]
[null,null,"Klimatické změny",134,15.1,4.7,4.2]
[]
[null,"6.4.\nb","Metodika hodnocení efektivnosti investic - železniční infrastruktura",null,null,null,null,null,"CÚ",{"$f":"'0 Úvod'!D19","v":2016}]
[null,null,"Osobní doprava [CZK/1000 oskm] CÚ 2012",null,null,null,null,null,"Osobní doprava [CZK/1000 oskm]"]
[null,null,null,"Automobil","Motocykl","Autobus","Železnice",null,null,"Automobil","Motocykl","Autobus","Železnice"]
[null,null,"Nehody",1697,11787,146,42,null,"Nehody"]
[null,null,"Hluk",269,801,61,184,null,"Hluk"]
[null,null,"Znečištění ovzduší",816,372,924,231,null,"Znečištění ovzduší"]
[null,null,"Klimatické změny",750,654,420,250,null,"Klimatické změny"]
[null,null,"Nákladní doprava [CZK/1000 čistých tkm] CÚ 2012",null,null,null,null,null,"Nákladní doprava [CZK/1000 čistých tkm]"]
[null,null,null,"Lehká užitková vozidla","Těžká užitková vozidla","Železnice","Vodní",null,null,"Lehká užitková vozidla","Těžká užitková vozidla","Železnice","Vodní"]
[null,null,"Nehody",4715,321,542,null,null,"Nehody"]
[null,null,"Hluk",1683,240,165,null,null,"Hluk"]
[null,null,"Znečištění ovzduší",6176,1528,189,457,null,"Znečištění ovzduší"]
[null,null,"Klimatické změny",6318,712,222,198,null,"Klimatické změny"]
[null,null,"Zdroj: \"INFRAS-IWW\" 2004"]
[]
[]
[null,"6.5.","Celkové oskm / č.tkm",null,{"$f":"E2","v":2016},{"$f":"E127+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a","Scénář s projektem","Celkem"]
[null,null,"Železniční osobní doprava",{"$f":"SUM(E129:S129,E138:S138)","v":0}]
[null,null,"Železniční nákladní doprava",{"$f":"SUM(E130:S130,E139:S139)","v":0}]
[null,null,"Převedená osobní doprava - IAD",0]
[null,null,"Převedená osobní doprava - BUS",0]
[null,null,"Převedená nákladní doprava - LUV",0]
[null,null,"Převedená nákladní doprava - TUV",0]
[]
[null,{"$f":"B127","v":"6.5."},{"$f":"C127","v":"Celkové oskm / č.tkm"},null,{"$f":"S127+1","v":2031},{"$f":"E136+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b","Scénář s projektem"]
[null,null,{"$f":"C129","v":"Železniční osobní doprava"}]
[null,null,"Železniční nákladní doprava"]
[null,null,"Převedená osobní doprava - IAD"]
[null,null,"Převedená osobní doprava - BUS"]
[null,null,"Převedená nákladní doprava - LUV"]
[null,null,"Převedená nákladní doprava - TUV"]
[]
[]
[null,"6.6.","Celkové oskm / č.tkm",null,{"$f":"E127","v":2016},{"$f":"E146+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a","Scénář bez projektu","Celkem"]
[null,null,"Železniční osobní doprava",{"$f":"SUM(E148:S148,E153:S153)","v":0}]
[null,null,"Železniční nákladní doprava",{"$f":"SUM(E149:S149,E154:S154)","v":0}]
[]
[null,{"$f":"B146","v":"6.6."},{"$f":"C146","v":"Celkové oskm / č.tkm"},null,{"$f":"S146+1","v":2031},{"$f":"E151+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b","Scénář bez projektu",null,{"$f":"S147+1","v":1}]
[null,null,{"$f":"C148","v":"Železniční osobní doprava"}]
[null,null,{"$f":"C149","v":"Železniční nákladní doprava"}]
[]
[]
[null,"6.7.","Zmírnění změny klimatu - t CO2 / rok",null,{"$f":"E127","v":2016},{"$f":"E157+1","v":2017},{"$f":"F157+1","v":2018},{"$f":"G157+1","v":2019},{"$f":"H157+1","v":2020},{"$f":"I157+1","v":2021},{"$f":"J157+1","v":2022},{"$f":"K157+1","v":2023},{"$f":"L157+1","v":2024},{"$f":"M157+1","v":2025},{"$f":"N157+1","v":2026},{"$f":"O157+1","v":2027},{"$f":"P157+1","v":2028},{"$f":"Q157+1","v":2029},{"$f":"R157+1","v":2030}]
[null,"a","Scénář s projektem","Celkem"]
[null,null,"Železniční osobní doprava",{"$f":"SUM(E159:S159,E168:S168)","v":0}]
[null,null,"Železniční nákladní doprava",{"$f":"SUM(E160:S160,E169:S169)","v":0}]
[null,null,"Převedená osobní doprava - IAD",0]
[null,null,"Převedená osobní doprava - BUS",0]
[null,null,"Převedená nákladní doprava - LUV",0]
[null,null,"Převedená nákladní doprava - TUV",0]
[]
[null,{"$f":"B157","v":"6.7."},"Zmírnění změny klimatu - t CO2 / rok",null,{"$f":"S157+1","v":2031},{"$f":"E166+1","v":2032},{"$f":"F166+1","v":2033},{"$f":"G166+1","v":2034},{"$f":"H166+1","v":2035},{"$f":"I166+1","v":2036},{"$f":"J166+1","v":2037},{"$f":"K166+1","v":2038},{"$f":"L166+1","v":2039},{"$f":"M166+1","v":2040},{"$f":"N166+1","v":2041},{"$f":"O166+1","v":2042},{"$f":"P166+1","v":2043},{"$f":"Q166+1","v":2044},{"$f":"R166+1","v":2045}]
[null,"b","Scénář s projektem"]
[null,null,{"$f":"C159","v":"Železniční osobní doprava"}]
[null,null,"Železniční nákladní doprava"]
[null,null,"Převedená osobní doprava - IAD"]
[null,null,"Převedená osobní doprava - BUS"]
[null,null,"Převedená nákladní doprava - LUV"]
[null,null,"Převedená nákladní doprava - TUV"]
[]
[]
[null,"6.8.","Zmírnění změny klimatu - t CO2 / rok",null,{"$f":"E157","v":2016},{"$f":"E176+1","v":2017},{"$f":"F176+1","v":2018},{"$f":"G176+1","v":2019},{"$f":"H176+1","v":2020},{"$f":"I176+1","v":2021},{"$f":"J176+1","v":2022},{"$f":"K176+1","v":2023},{"$f":"L176+1","v":2024},{"$f":"M176+1","v":2025},{"$f":"N176+1","v":2026},{"$f":"O176+1","v":2027},{"$f":"P176+1","v":2028},{"$f":"Q176+1","v":2029},{"$f":"R176+1","v":2030}]
[null,"a","Scénář bez projektu","Celkem"]
[null,null,"Železniční osobní doprava",{"$f":"SUM(E178:S178,E183:S183)","v":0}]
[null,null,"Železniční nákladní doprava",{"$f":"SUM(E179:S179,E184:S184)","v":0}]
[]
[null,{"$f":"B176","v":"6.8."},"Zmírnění změny klimatu - t CO2 / rok",null,{"$f":"S176+1","v":2031},{"$f":"E181+1","v":2032},{"$f":"F181+1","v":2033},{"$f":"G181+1","v":2034},{"$f":"H181+1","v":2035},{"$f":"I181+1","v":2036},{"$f":"J181+1","v":2037},{"$f":"K181+1","v":2038},{"$f":"L181+1","v":2039},{"$f":"M181+1","v":2040},{"$f":"N181+1","v":2041},{"$f":"O181+1","v":2042},{"$f":"P181+1","v":2043},{"$f":"Q181+1","v":2044},{"$f":"R181+1","v":2045}]
[null,"b","Scénář bez projektu",null,{"$f":"S177+1","v":1}]
[null,null,{"$f":"C178","v":"Železniční osobní doprava"}]
[null,null,{"$f":"C179","v":"Železniční nákladní doprava"}]
[]
[]
[null,"6.9.","Zmírnění změny klimatu - t CH4 / rok","GWP = 25",{"$f":"E157","v":2016},{"$f":"E187+1","v":2017},{"$f":"F187+1","v":2018},{"$f":"G187+1","v":2019},{"$f":"H187+1","v":2020},{"$f":"I187+1","v":2021},{"$f":"J187+1","v":2022},{"$f":"K187+1","v":2023},{"$f":"L187+1","v":2024},{"$f":"M187+1","v":2025},{"$f":"N187+1","v":2026},{"$f":"O187+1","v":2027},{"$f":"P187+1","v":2028},{"$f":"Q187+1","v":2029},{"$f":"R187+1","v":2030}]
[null,"a","Scénář s projektem","Celkem"]
[null,null,"Železniční osobní doprava",{"$f":"SUM(E189:S189,E198:S198)","v":0}]
[null,null,"Železniční nákladní doprava",{"$f":"SUM(E190:S190,E199:S199)","v":0}]
[null,null,"Převedená osobní doprava - IAD",0]
[null,null,"Převedená osobní doprava - BUS",0]
[null,null,"Převedená nákladní doprava - LUV",0]
[null,null,"Převedená nákladní doprava - TUV",0]
[]
[null,{"$f":"B187","v":"6.9."},"Zmírnění změny klimatu - t CH4 / rok","GWP = 25",{"$f":"S187+1","v":2031},{"$f":"E196+1","v":2032},{"$f":"F196+1","v":2033},{"$f":"G196+1","v":2034},{"$f":"H196+1","v":2035},{"$f":"I196+1","v":2036},{"$f":"J196+1","v":2037},{"$f":"K196+1","v":2038},{"$f":"L196+1","v":2039},{"$f":"M196+1","v":2040},{"$f":"N196+1","v":2041},{"$f":"O196+1","v":2042},{"$f":"P196+1","v":2043},{"$f":"Q196+1","v":2044},{"$f":"R196+1","v":2045}]
[null,"b","Scénář s projektem"]
[null,null,{"$f":"C189","v":"Železniční osobní doprava"}]
[null,null,"Železniční nákladní doprava"]
[null,null,"Převedená osobní doprava - IAD"]
[null,null,"Převedená osobní doprava - BUS"]
[null,null,"Převedená nákladní doprava - LUV"]
[null,null,"Převedená nákladní doprava - TUV"]
[]
[]
[null,"6.10.","Zmírnění změny klimatu - t CH4 / rok","GWP = 25",{"$f":"E187","v":2016},{"$f":"E206+1","v":2017},{"$f":"F206+1","v":2018},{"$f":"G206+1","v":2019},{"$f":"H206+1","v":2020},{"$f":"I206+1","v":2021},{"$f":"J206+1","v":2022},{"$f":"K206+1","v":2023},{"$f":"L206+1","v":2024},{"$f":"M206+1","v":2025},{"$f":"N206+1","v":2026},{"$f":"O206+1","v":2027},{"$f":"P206+1","v":2028},{"$f":"Q206+1","v":2029},{"$f":"R206+1","v":2030}]
[null,"a","Scénář bez projektu","Celkem"]
[null,null,"Železniční osobní doprava",{"$f":"SUM(E208:S208,E213:S213)","v":0}]
[null,null,"Železniční nákladní doprava",{"$f":"SUM(E209:S209,E214:S214)","v":0}]
[]
[null,{"$f":"B206","v":"6.10."},"Zmírnění změny klimatu - t CH4 / rok","GWP = 25",{"$f":"S206+1","v":2031},{"$f":"E211+1","v":2032},{"$f":"F211+1","v":2033},{"$f":"G211+1","v":2034},{"$f":"H211+1","v":2035},{"$f":"I211+1","v":2036},{"$f":"J211+1","v":2037},{"$f":"K211+1","v":2038},{"$f":"L211+1","v":2039},{"$f":"M211+1","v":2040},{"$f":"N211+1","v":2041},{"$f":"O211+1","v":2042},{"$f":"P211+1","v":2043},{"$f":"Q211+1","v":2044},{"$f":"R211+1","v":2045}]
[null,"b","Scénář bez projektu",null,{"$f":"S207+1","v":1}]
[null,null,{"$f":"C208","v":"Železniční osobní doprava"}]
[null,null,{"$f":"C209","v":"Železniční nákladní doprava"}]
[]
[]
[null,"6.11.","Zmírnění změny klimatu - t N2O / rok","GWP = 298",{"$f":"E187","v":2016},{"$f":"E217+1","v":2017},{"$f":"F217+1","v":2018},{"$f":"G217+1","v":2019},{"$f":"H217+1","v":2020},{"$f":"I217+1","v":2021},{"$f":"J217+1","v":2022},{"$f":"K217+1","v":2023},{"$f":"L217+1","v":2024},{"$f":"M217+1","v":2025},{"$f":"N217+1","v":2026},{"$f":"O217+1","v":2027},{"$f":"P217+1","v":2028},{"$f":"Q217+1","v":2029},{"$f":"R217+1","v":2030}]
[null,"a","Scénář s projektem","Celkem"]
[null,null,"Železniční osobní doprava",{"$f":"SUM(E219:S219,E228:S228)","v":0}]
[null,null,"Železniční nákladní doprava",{"$f":"SUM(E220:S220,E229:S229)","v":0}]
[null,null,"Převedená osobní doprava - IAD",0]
[null,null,"Převedená osobní doprava - BUS",0]
[null,null,"Převedená nákladní doprava - LUV",0]
[null,null,"Převedená nákladní doprava - TUV",0]
[]
[null,{"$f":"B217","v":"6.11."},"Zmírnění změny klimatu - t N2O / rok","GWP = 298",{"$f":"S217+1","v":2031},{"$f":"E226+1","v":2032},{"$f":"F226+1","v":2033},{"$f":"G226+1","v":2034},{"$f":"H226+1","v":2035},{"$f":"I226+1","v":2036},{"$f":"J226+1","v":2037},{"$f":"K226+1","v":2038},{"$f":"L226+1","v":2039},{"$f":"M226+1","v":2040},{"$f":"N226+1","v":2041},{"$f":"O226+1","v":2042},{"$f":"P226+1","v":2043},{"$f":"Q226+1","v":2044},{"$f":"R226+1","v":2045}]
[null,"b","Scénář s projektem"]
[null,null,{"$f":"C219","v":"Železniční osobní doprava"}]
[null,null,"Železniční nákladní doprava"]
[null,null,"Převedená osobní doprava - IAD"]
[null,null,"Převedená osobní doprava - BUS"]
[null,null,"Převedená nákladní doprava - LUV"]
[null,null,"Převedená nákladní doprava - TUV"]
[]
[]
[null,"6.12.","Zmírnění změny klimatu - t N2O / rok","GWP = 298",{"$f":"E217","v":2016},{"$f":"E236+1","v":2017},{"$f":"F236+1","v":2018},{"$f":"G236+1","v":2019},{"$f":"H236+1","v":2020},{"$f":"I236+1","v":2021},{"$f":"J236+1","v":2022},{"$f":"K236+1","v":2023},{"$f":"L236+1","v":2024},{"$f":"M236+1","v":2025},{"$f":"N236+1","v":2026},{"$f":"O236+1","v":2027},{"$f":"P236+1","v":2028},{"$f":"Q236+1","v":2029},{"$f":"R236+1","v":2030}]
[null,"a","Scénář bez projektu","Celkem"]
[null,null,"Železniční osobní doprava",{"$f":"SUM(E238:S238,E243:S243)","v":0}]
[null,null,"Železniční nákladní doprava",{"$f":"SUM(E239:S239,E244:S244)","v":0}]
[]
[null,{"$f":"B236","v":"6.12."},"Zmírnění změny klimatu - t N2O / rok","GWP = 298",{"$f":"S236+1","v":2031},{"$f":"E241+1","v":2032},{"$f":"F241+1","v":2033},{"$f":"G241+1","v":2034},{"$f":"H241+1","v":2035},{"$f":"I241+1","v":2036},{"$f":"J241+1","v":2037},{"$f":"K241+1","v":2038},{"$f":"L241+1","v":2039},{"$f":"M241+1","v":2040},{"$f":"N241+1","v":2041},{"$f":"O241+1","v":2042},{"$f":"P241+1","v":2043},{"$f":"Q241+1","v":2044},{"$f":"R241+1","v":2045}]
[null,"b","Scénář bez projektu",null,{"$f":"S237+1","v":1}]
[null,null,{"$f":"C238","v":"Železniční osobní doprava"}]
[null,null,{"$f":"C239","v":"Železniční nákladní doprava"}]
[]
[]
[null,"6.13.","Zmírnění změny klimatu - t CO2e / rok",null,{"$f":"E217","v":2016},{"$f":"E247+1","v":2017},{"$f":"F247+1","v":2018},{"$f":"G247+1","v":2019},{"$f":"H247+1","v":2020},{"$f":"I247+1","v":2021},{"$f":"J247+1","v":2022},{"$f":"K247+1","v":2023},{"$f":"L247+1","v":2024},{"$f":"M247+1","v":2025},{"$f":"N247+1","v":2026},{"$f":"O247+1","v":2027},{"$f":"P247+1","v":2028},{"$f":"Q247+1","v":2029},{"$f":"R247+1","v":2030}]
[null,"a","Scénář s projektem","Celkem"]
[null,null,"Železniční osobní doprava",{"$f":"SUM(E249:S249,E258:S258)","v":0},{"$f":"E159+E189*25+E219*298","v":0},{"$f":"F159+F189*25+F219*298","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Železniční nákladní doprava",{"$f":"SUM(E250:S250,E259:S259)","v":0},{"$f":"E160+E190*25+E220*298","v":0},{"$f":"F160+F190*25+F220*298","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Převedená osobní doprava - IAD",0,0,{"$f":"F161+F191*25+F221*298","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Převedená osobní doprava - BUS",0,0,{"$f":"F162+F192*25+F222*298","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Převedená nákladní doprava - LUV",0,0,{"$f":"F163+F193*25+F223*298","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Převedená nákladní doprava - TUV",0,0,{"$f":"F164+F194*25+F224*298","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"B247","v":"6.13."},"Zmírnění změny klimatu - t CO2e / rok",null,{"$f":"S247+1","v":2031},{"$f":"E256+1","v":2032},{"$f":"F256+1","v":2033},{"$f":"G256+1","v":2034},{"$f":"H256+1","v":2035},{"$f":"I256+1","v":2036},{"$f":"J256+1","v":2037},{"$f":"K256+1","v":2038},{"$f":"L256+1","v":2039},{"$f":"M256+1","v":2040},{"$f":"N256+1","v":2041},{"$f":"O256+1","v":2042},{"$f":"P256+1","v":2043},{"$f":"Q256+1","v":2044},{"$f":"R256+1","v":2045}]
[null,"b","Scénář s projektem"]
[null,null,{"$f":"C249","v":"Železniční osobní doprava"},null,{"$f":"E168+E198*25+E228*298","v":0},{"$f":"F168+F198*25+F228*298","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Železniční nákladní doprava",null,{"$f":"E169+E199*25+E229*298","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Převedená osobní doprava - IAD",null,{"$f":"E170+E200*25+E230*298","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Převedená osobní doprava - BUS",null,{"$f":"E171+E201*25+E231*298","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Převedená nákladní doprava - LUV",null,{"$f":"E172+E202*25+E232*298","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Převedená nákladní doprava - TUV",null,{"$f":"E173+E203*25+E233*298","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"6.14.","Zmírnění změny klimatu - t CO2e / rok",null,{"$f":"E247","v":2016},{"$f":"E266+1","v":2017},{"$f":"F266+1","v":2018},{"$f":"G266+1","v":2019},{"$f":"H266+1","v":2020},{"$f":"I266+1","v":2021},{"$f":"J266+1","v":2022},{"$f":"K266+1","v":2023},{"$f":"L266+1","v":2024},{"$f":"M266+1","v":2025},{"$f":"N266+1","v":2026},{"$f":"O266+1","v":2027},{"$f":"P266+1","v":2028},{"$f":"Q266+1","v":2029},{"$f":"R266+1","v":2030}]
[null,"a","Scénář bez projektu","Celkem"]
[null,null,"Železniční osobní doprava",{"$f":"SUM(E268:S268,E273:S273)","v":0},{"$f":"E178+E208*25+E238*298","v":0},{"$f":"F178+F208*25+F238*298","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Železniční nákladní doprava",{"$f":"SUM(E269:S269,E274:S274)","v":0},{"$f":"E179+E209*25+E239*298","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"B266","v":"6.14."},"Zmírnění změny klimatu - t CO2e / rok",null,{"$f":"S266+1","v":2031},{"$f":"E271+1","v":2032},{"$f":"F271+1","v":2033},{"$f":"G271+1","v":2034},{"$f":"H271+1","v":2035},{"$f":"I271+1","v":2036},{"$f":"J271+1","v":2037},{"$f":"K271+1","v":2038},{"$f":"L271+1","v":2039},{"$f":"M271+1","v":2040},{"$f":"N271+1","v":2041},{"$f":"O271+1","v":2042},{"$f":"P271+1","v":2043},{"$f":"Q271+1","v":2044},{"$f":"R271+1","v":2045}]
[null,"b","Scénář bez projektu",null,{"$f":"S267+1","v":1}]
[null,null,{"$f":"C268","v":"Železniční osobní doprava"},null,{"$f":"E183+E213*25+E243*298","v":0},{"$f":"F183+F213*25+F243*298","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C269","v":"Železniční nákladní doprava"},null,{"$f":"E184+E214*25+E244*298","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"2015-06-01","Jednotkové náklady na emise skleníkových plynů","CÚ","EUR/t CO2e","CZK/t CO2e"]
[null,null,"Měrná hodnota",2010,25,{"$f":"E278*25.29","v":632.25}]
[null,null,"Měrná hodnota",{"$f":"'0 Úvod'!D19","v":2016},{"$f":"E278+1*(D279-D278)","v":31}]
[]
[]
[null,"6.16.","Změna měrných hodnot externalit",null,{"$f":"E2","v":2016},{"$f":"E282+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a",null,"Elasticita"]
[null,null,"Hodnota růstu HDP na hlavu (resp. prognóza)",1,0,{"$f":"$D$284*IF(HLOOKUP(F$282,'0 Úvod'!$K$65:$N$66,1,TRUE)=F$282,HLOOKUP(F$282,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(F$282,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":2.9000000000000001E-2},{"$f":"$D$284*IF(HLOOKUP(G$282,'0 Úvod'!$K$65:$N$66,1,TRUE)=G$282,HLOOKUP(G$282,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(G$282,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.03},{"$f":"$D$284*IF(HLOOKUP(H$282,'0 Úvod'!$K$65:$N$66,1,TRUE)=H$282,HLOOKUP(H$282,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(H$282,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.03},{"$f":"$D$284*IF(HLOOKUP(I$282,'0 Úvod'!$K$65:$N$66,1,TRUE)=I$282,HLOOKUP(I$282,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(I$282,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.02},{"$f":"$D$284*IF(HLOOKUP(J$282,'0 Úvod'!$K$65:$N$66,1,TRUE)=J$282,HLOOKUP(J$282,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(J$282,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.02},{"$f":"$D$284*IF(HLOOKUP(K$282,'0 Úvod'!$K$65:$N$66,1,TRUE)=K$282,HLOOKUP(K$282,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(K$282,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.02},{"$f":"$D$284*IF(HLOOKUP(L$282,'0 Úvod'!$K$65:$N$66,1,TRUE)=L$282,HLOOKUP(L$282,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(L$282,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.02},{"$f":"$D$284*IF(HLOOKUP(M$282,'0 Úvod'!$K$65:$N$66,1,TRUE)=M$282,HLOOKUP(M$282,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(M$282,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.02},{"$f":"$D$284*IF(HLOOKUP(N$282,'0 Úvod'!$K$65:$N$66,1,TRUE)=N$282,HLOOKUP(N$282,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(N$282,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.02},{"$f":"$D$284*IF(HLOOKUP(O$282,'0 Úvod'!$K$65:$N$66,1,TRUE)=O$282,HLOOKUP(O$282,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(O$282,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.02},{"$f":"$D$284*IF(HLOOKUP(P$282,'0 Úvod'!$K$65:$N$66,1,TRUE)=P$282,HLOOKUP(P$282,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(P$282,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.02},{"$f":"$D$284*IF(HLOOKUP(Q$282,'0 Úvod'!$K$65:$N$66,1,TRUE)=Q$282,HLOOKUP(Q$282,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(Q$282,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.02},{"$f":"$D$284*IF(HLOOKUP(R$282,'0 Úvod'!$K$65:$N$66,1,TRUE)=R$282,HLOOKUP(R$282,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(R$282,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.02},{"$f":"$D$284*IF(HLOOKUP(S$282,'0 Úvod'!$K$65:$N$66,1,TRUE)=S$282,HLOOKUP(S$282,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(S$282,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.01}]
[null,null,"Výsledný růstový koeficient externalit",null,1,{"$f":"E285*(1+F284)","v":1.0289999999999999},{"$f":"F285*(1+G284)","v":1.0598699999999999},{"$f":"G285*(1+H284)","v":1.0916660999999999},1.1134994219999998,1.1357694104399998,1.1584847986487998,1.1816544946217757,1.2052875845142113,1.2293933362044955,1.2539812029285855,1.2790608269871573,1.3046420435269004,1.3307348843974385,1.3440422332414128]
[]
[null,{"$f":"B282","v":"6.16."},{"$f":"C282","v":"Změna měrných hodnot externalit"},null,{"$f":"S282+1","v":2031},{"$f":"E287+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b",null,"Elasticita"]
[null,null,{"$f":"C284","v":"Hodnota růstu HDP na hlavu (resp. prognóza)"},{"$f":"D284","v":1},{"$f":"$D$289*IF(HLOOKUP(E$287,'0 Úvod'!$K$65:$N$66,1,TRUE)=E$287,HLOOKUP(E$287,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(E$287,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.01},{"$f":"$D$289*IF(HLOOKUP(F$287,'0 Úvod'!$K$65:$N$66,1,TRUE)=F$287,HLOOKUP(F$287,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(F$287,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.01},{"$f":"$D$289*IF(HLOOKUP(G$287,'0 Úvod'!$K$65:$N$66,1,TRUE)=G$287,HLOOKUP(G$287,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(G$287,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.01},{"$f":"$D$289*IF(HLOOKUP(H$287,'0 Úvod'!$K$65:$N$66,1,TRUE)=H$287,HLOOKUP(H$287,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(H$287,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.01},{"$f":"$D$289*IF(HLOOKUP(I$287,'0 Úvod'!$K$65:$N$66,1,TRUE)=I$287,HLOOKUP(I$287,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(I$287,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.01},{"$f":"$D$289*IF(HLOOKUP(J$287,'0 Úvod'!$K$65:$N$66,1,TRUE)=J$287,HLOOKUP(J$287,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(J$287,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.01},{"$f":"$D$289*IF(HLOOKUP(K$287,'0 Úvod'!$K$65:$N$66,1,TRUE)=K$287,HLOOKUP(K$287,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(K$287,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.01},{"$f":"$D$289*IF(HLOOKUP(L$287,'0 Úvod'!$K$65:$N$66,1,TRUE)=L$287,HLOOKUP(L$287,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(L$287,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.01},{"$f":"$D$289*IF(HLOOKUP(M$287,'0 Úvod'!$K$65:$N$66,1,TRUE)=M$287,HLOOKUP(M$287,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(M$287,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.01},{"$f":"$D$289*IF(HLOOKUP(N$287,'0 Úvod'!$K$65:$N$66,1,TRUE)=N$287,HLOOKUP(N$287,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(N$287,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.01},{"$f":"$D$289*IF(HLOOKUP(O$287,'0 Úvod'!$K$65:$N$66,1,TRUE)=O$287,HLOOKUP(O$287,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(O$287,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.01},{"$f":"$D$289*IF(HLOOKUP(P$287,'0 Úvod'!$K$65:$N$66,1,TRUE)=P$287,HLOOKUP(P$287,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(P$287,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.01},{"$f":"$D$289*IF(HLOOKUP(Q$287,'0 Úvod'!$K$65:$N$66,1,TRUE)=Q$287,HLOOKUP(Q$287,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(Q$287,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.01},{"$f":"$D$289*IF(HLOOKUP(R$287,'0 Úvod'!$K$65:$N$66,1,TRUE)=R$287,HLOOKUP(R$287,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(R$287,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.01},{"$f":"$D$289*IF(HLOOKUP(S$287,'0 Úvod'!$K$65:$N$66,1,TRUE)=S$287,HLOOKUP(S$287,'0 Úvod'!$K$65:$N$66,2,TRUE),HLOOKUP(S$287,'0 Úvod'!$D$68:$J$69,2,TRUE))","v":0.01}]
[null,null,{"$f":"C285","v":"Výsledný růstový koeficient externalit"},null,{"$f":"S285*(1+E289)","v":1.3574826555738269},{"$f":"E290*(1+F289)","v":1.3710574821295651},1.3847680569508607,1.3986157375203694,1.4126018948955732,1.426727913844529,1.4409951929829743,1.455405144912804,1.4699591963619321,1.4846587883255513,1.4995053762088069,1.5145004299708948,1.5296454342706038,1.5449418886133099,1.5603913074994431]
[]
[]
[null,"Komentáře"]
[]
[null,"Zpracovatel uvede konkrétní hodnoty výstupů z dopravního prognózování použité při výpočtu externích efektů. Tabulky 6.5. a 6.6. je možné přizpůsobit konkrétnímu projektu."]
[null,"V tabulce 6.1. a  6.2. uvede zpracovatel konkrétní výpočet pomocí vzorců, s odkazem na tabulky výkonů (tabulka 6.5. a 6.6.) a měrného ohodnocení (tabulka 6.4.)."]
[null,"a vynásobí hodnoty v tabulce 6.1 a 6.2 hodnotou z tabulky 6.16."]
[null,"V případě využití výpočtu vlivu projektu na zmírnění změny klimatu pomocí CO2e je možné v tabulce 6.1., resp. 6.2. použít pro řádek \"Změna klimatu\" hodnoty vypočtené na základě souhrnů"]
[null,"v tabulkách 6.13. resp. 6.14. a měrného ohodnocení dle tabulky 6.15., které se v průběhu hodnocení navyšuje ročně o 1 EUR/t až do konce hodnotícího období, při použití převodního kurzu CZK/EUR"]
[null," dle ČNB platného v roce, ve kterém je prováděn výpočet (CÚ)"]

{"sheet":"7 Emise ze železniční dopravy","index":7,"n_rows":116,"n_cols":19,"rows_kept":116,"cut":false,"hidden":false,"merged":[[111,1,112,15],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[18,12,19,12],[1,14,2,14],[1,15,2,15],[18,15,19,15],[26,10,27,10],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,12,2,12],[18,11,19,11],[26,11,27,11],[18,14,19,14],[45,1,46,1],[43,5,44,5],[43,7,44,7],[43,15,44,15],[18,10,19,10],[35,6,36,6],[35,12,36,12],[1,18,2,18],[9,5,10,5],[9,6,10,6],[9,7,10,7],[9,8,10,8],[9,9,10,9],[9,10,10,10],[9,11,10,11],[1,13,2,13],[1,16,2,16],[9,16,10,16],[9,12,10,12],[9,13,10,13],[9,14,10,14],[9,15,10,15],[9,18,10,18],[1,4,2,4],[9,4,10,4],[18,4,19,4],[26,4,27,4],[26,16,27,16],[18,16,19,16],[18,9,19,9],[9,17,10,17],[18,17,19,17],[1,17,2,17],[18,13,19,13],[18,5,19,5],[18,6,19,6],[26,13,27,13],[26,14,27,14],[26,15,27,15],[26,17,27,17],[3,1,4,1],[5,1,6,1],[11,1,12,1],[13,1,14,1],[20,1,21,1],[22,1,23,1],[28,1,29,1],[30,1,31,1],[35,18,36,18],[35,5,36,5],[35,17,36,17],[35,8,36,8],[35,14,36,14],[35,13,36,13],[35,7,36,7],[35,9,36,9],[35,10,36,10],[35,11,36,11],[35,16,36,16],[35,15,36,15],[47,1,48,1],[66,15,67,15],[66,16,67,16],[66,17,67,17],[66,18,67,18],[18,18,19,18],[26,5,27,5],[26,6,27,6],[26,7,27,7],[26,8,27,8],[26,9,27,9],[18,7,19,7],[18,8,19,8],[26,18,27,18],[26,12,27,12],[35,4,36,4],[43,4,44,4],[43,18,44,18],[37,1,38,1],[39,1,40,1],[43,12,44,12],[43,13,44,13],[43,14,44,14],[43,16,44,16],[43,17,44,17],[43,6,44,6],[43,8,44,8],[43,9,44,9],[43,10,44,10],[43,11,44,11],[74,18,75,18],[66,7,67,7],[66,8,67,8],[66,9,67,9],[66,10,67,10],[74,17,75,17],[59,3,59,4],[59,7,59,8],[66,4,67,4],[66,5,67,5],[66,6,67,6],[59,5,59,6],[74,14,75,14],[74,15,75,15],[74,16,75,16],[74,10,75,10],[74,11,75,11],[74,12,75,12],[74,13,75,13],[66,11,67,11],[66,12,67,12],[66,13,67,13],[66,14,67,14],[83,4,84,4],[83,5,84,5],[83,6,84,6],[83,7,84,7],[83,8,84,8],[83,9,84,9],[83,10,84,10],[68,1,69,1],[70,1,71,1],[74,4,75,4],[74,5,75,5],[74,6,75,6],[74,7,75,7],[74,8,75,8],[74,9,75,9],[91,18,92,18],[83,15,84,15],[83,16,84,16],[83,17,84,17],[83,18,84,18],[83,11,84,11],[83,12,84,12],[83,13,84,13],[83,14,84,14],[91,13,92,13],[91,14,92,14],[91,15,92,15],[91,16,92,16],[91,17,92,17],[91,10,92,10],[91,11,92,11],[91,12,92,12],[91,6,92,6],[91,7,92,7],[91,8,92,8],[91,9,92,9],[100,14,101,14],[100,15,101,15],[100,16,101,16],[100,17,101,17],[100,18,101,18],[105,11,106,11],[105,12,106,12],[105,13,106,13],[105,14,106,14],[105,15,106,15],[105,16,106,16],[105,17,106,17],[105,18,106,18],[100,11,101,11],[100,12,101,12],[59,1,62,1],[105,4,106,4],[105,5,106,5],[105,6,106,6],[105,7,106,7],[105,8,106,8],[105,9,106,9],[105,10,106,10],[100,13,101,13],[100,4,101,4],[100,5,101,5],[100,6,101,6],[100,7,101,7],[100,8,101,8],[100,9,101,9],[100,10,101,10],[93,1,94,1],[95,1,96,1],[85,1,86,1],[87,1,88,1],[91,4,92,4],[91,5,92,5],[76,1,77,1],[78,1,79,1]]}
[null," "]
[null,"7.1.","Emise ze železniční dopravy (CZK)",null,{"$f":"'1 Celkové investiční náklady'!G3","v":2016},{"$f":"E2+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a","Scénář se projektem","Celkem"]
[null,"Osobní","Dieselová trakce",{"$f":"SUM(E4:S4,E12:S12)","v":0}]
[null,null,"Elektrická trakce",{"$f":"SUM(E5:S5,E13:S13)","v":0}]
[null,"Nákladní","Dieselová trakce",0]
[null,null,"Elektrická trakce",0]
[null,null,"Celkem emise ze železniční dopravy",0,{"$f":"SUM(E4:E7)","v":0},{"$f":"SUM(F4:F7)","v":0},{"$f":"SUM(G4:G7)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(S4:S7)","v":0}]
[]
[null,"7.1.","Emise ze železniční dopravy (CZK)",null,{"$f":"S2+1","v":2031},{"$f":"E10+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b","Scénář s projektem"]
[null,"Osobní","Dieselová trakce"]
[null,null,"Elektrická trakce"]
[null,"Nákladní","Dieselová trakce"]
[null,null,"Elektrická trakce"]
[null,null,"Celkem emise ze železniční dopravy",null,{"$f":"SUM(E12:E15)","v":0},{"$f":"SUM(F12:F15)","v":0},{"$f":"SUM(G12:G15)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(S12:S15)","v":0}]
[]
[]
[null,"7.2.","Emise ze železniční dopravy (CZK)",null,{"$f":"E2","v":2016},{"$f":"E19+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a","Scénář bez projektu","Celkem"]
[null,"Osobní","Dieselová trakce",{"$f":"SUM(E21:S21,E29:S29)","v":0}]
[null,null,"Elektrická trakce",{"$f":"SUM(E22:S22,E30:S30)","v":0}]
[null,"Nákladní","Dieselová trakce",0]
[null,null,"Elektrická trakce",0]
[null,null,"Celkem emise ze železniční dopravy",0,{"$f":"SUM(E21:E24)","v":0},{"$f":"SUM(F21:F24)","v":0},{"$f":"SUM(G21:G24)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(S21:S24)","v":0}]
[]
[null,"7.2.","Emise ze železniční dopravy (CZK)",null,{"$f":"S19+1","v":2031},{"$f":"E27+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b","Scénář bez projektu",null,{"$f":"S20+1","v":1}]
[null,"Osobní","Dieselová trakce"]
[null,null,"Elektrická trakce"]
[null,"Nákladní","Dieselová trakce"]
[null,null,"Elektrická trakce"]
[null,null,"Celkem emise ze železniční dopravy",null,{"$f":"SUM(E29:E32)","v":0},{"$f":"SUM(F29:F32)","v":0},{"$f":"SUM(G29:G32)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(S29:S32)","v":0}]
[]
[]
[null,"7.3.","Redukce emisí ze železniční nákladní dopravy (CZK)",null,{"$f":"E2","v":2016},{"$f":"E36+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a",null,"Celkem"]
[null,"Osobní","Dieselová trakce",{"$f":"SUM(E38:S38,E46:S46)","v":0},{"$f":"E21-E4","v":0},{"$f":"F21-F4","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Elektrická trakce",{"$f":"SUM(E39:S39,E47:S47)","v":0},{"$f":"E22-E5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Nákladní","Dieselová trakce",0,{"$f":"E23-E6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Elektrická trakce",0,{"$f":"E24-E7","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Celkem redukce emisí ze železniční dopravy",0,{"$f":"E25-E8","v":0},{"$f":"F25-F8","v":0},{"$f":"G25-G8","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"7.3.","Redukce emisí ze železniční nákladní dopravy (CZK)",null,{"$f":"S36+1","v":2031},{"$f":"E44+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b",null,null,{"$f":"S37+1","v":1}]
[null,"Osobní","Dieselová trakce",null,{"$f":"E29-E12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Elektrická trakce",null,{"$f":"E30-E13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Nákladní","Dieselová trakce",null,{"$f":"E31-E14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Elektrická trakce",null,{"$f":"E32-E15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Celkem redukce emisí ze železniční dopravy",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,"Scenář s projektem (CZK)",{"$f":"D8","v":0}]
[null,null,"Scenář bez projektu (CZK)",{"$f":"D25","v":0}]
[null,null,"Přírůstkové cash-flow (CZK)",{"$f":"D42","v":0}]
[]
[]
[]
[]
[null,"7.4.","CÚ",2007,null,2012,null,{"$f":"'0 Úvod'!D19","v":2016}]
[null,null,null,"Dieselová                trakce","Elektrická trakce","Dieselová                trakce","Elektrická trakce","Dieselová trakce","Elektrická trakce"]
[null,null,"CZK/1000 oskm",{"$f":"40.832","v":40.832000000000001},{"$f":"3.273","v":3.2730000000000001},50.56,4.0529999999999999]
[null,null,"CZK/1000 č. tkm",68.564999999999998,0.77500000000000002,84.9,0.96]
[null,null,"Zdroj: \"INFRAS-IWW\" 2004"]
[]
[]
[null,"7.5.","Celkové oskm / č.tkm",null,{"$f":"E2","v":2016},{"$f":"E67+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a","Scénář s projektem","Celkem"]
[null,"Osobní","Dieselová trakce",{"$f":"SUM(E69:S69,E77:S77)","v":0}]
[null,null,"Elektrická trakce",{"$f":"SUM(E70:S70,E78:S78)","v":0}]
[null,"Nákladní","Dieselová trakce",0]
[null,null,"Elektrická trakce",0]
[null,null,"Celkové oskm / č.tkm",0,{"$f":"SUM(E69:E72)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"B67","v":"7.5."},{"$f":"C67","v":"Celkové oskm / č.tkm"},null,{"$f":"S67+1","v":2031},{"$f":"E75+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b","Scénář s projektem"]
[null,{"$f":"B69","v":"Osobní"},{"$f":"C69","v":"Dieselová trakce"}]
[null,null,{"$f":"C70","v":"Elektrická trakce"}]
[null,{"$f":"B71","v":"Nákladní"},{"$f":"C71","v":"Dieselová trakce"}]
[null,null,{"$f":"C72","v":"Elektrická trakce"}]
[null,null,{"$f":"C73","v":"Celkové oskm / č.tkm"},null,{"$f":"SUM(E77:E80)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"7.6.","Celkové oskm / č.tkm",null,{"$f":"E67","v":2016},{"$f":"E84+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a","Scénář bez projektu","Celkem"]
[null,"Osobní","Dieselová trakce",{"$f":"SUM(E86:S86,E94:S94)","v":0}]
[null,null,"Elektrická trakce",{"$f":"SUM(E87:S87,E95:S95)","v":0}]
[null,"Nákladní","Dieselová trakce",0]
[null,null,"Elektrická trakce",0]
[null,null,"Celkové oskm / č.tkm",0,{"$f":"SUM(E86:E89)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"B84","v":"7.6."},{"$f":"C84","v":"Celkové oskm / č.tkm"},null,{"$f":"S84+1","v":2031},{"$f":"E92+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b","Scénář bez projektu",null,{"$f":"S85+1","v":1}]
[null,{"$f":"B86","v":"Osobní"},{"$f":"C86","v":"Dieselová trakce"}]
[null,null,{"$f":"C87","v":"Elektrická trakce"}]
[null,{"$f":"B88","v":"Nákladní"},{"$f":"C88","v":"Dieselová trakce"}]
[null,null,{"$f":"C89","v":"Elektrická trakce"}]
[null,null,{"$f":"C90","v":"Celkové oskm / č.tkm"},null,{"$f":"SUM(E94:E97)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"7.7.","Změna měrných hodnot emisí",null,{"$f":"E2","v":2016},{"$f":"E101+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a",null,"Elasticita"]
[null,null,"Hodnota růstu HDP na hlavu (resp. prognóza)",1,0,{"$f":"'6 Externality'!F284","v":2.9000000000000001E-2},{"$f":"'6 Externality'!G284","v":0.03},{"$f":"'6 Externality'!H284","v":0.03},{"$f":"'6 Externality'!I284","v":0.02},{"$f":"'6 Externality'!J284","v":0.02},{"$f":"'6 Externality'!K284","v":0.02},{"$f":"'6 Externality'!L284","v":0.02},{"$f":"'6 Externality'!M284","v":0.02},{"$f":"'6 Externality'!N284","v":0.02},{"$f":"'6 Externality'!O284","v":0.02},{"$f":"'6 Externality'!P284","v":0.02},{"$f":"'6 Externality'!Q284","v":0.02},{"$f":"'6 Externality'!R284","v":0.02},{"$f":"'6 Externality'!S284","v":0.01}]
[null,null,"Výsledný růstový koeficient ohodnocení emisí",null,{"$f":"'6 Externality'!E285","v":1},{"$f":"E104*(1+F103)","v":1.0289999999999999},1.0598699999999999,1.0916660999999999,1.1134994219999998,1.1357694104399998,1.1584847986487998,1.1816544946217757,1.2052875845142113,1.2293933362044955,1.2539812029285855,1.2790608269871573,1.3046420435269004,1.3307348843974385,1.3440422332414128]
[]
[null,{"$f":"B101","v":"7.7."},{"$f":"C101","v":"Změna měrných hodnot emisí"},null,{"$f":"S101+1","v":2031},{"$f":"E106+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b",null,"Elasticita"]
[null,null,{"$f":"C103","v":"Hodnota růstu HDP na hlavu (resp. prognóza)"},{"$f":"D103","v":1},{"$f":"'6 Externality'!E289","v":0.01},{"$f":"'6 Externality'!F289","v":0.01},{"$f":"'6 Externality'!G289","v":0.01},{"$f":"'6 Externality'!H289","v":0.01},{"$f":"'6 Externality'!I289","v":0.01},{"$f":"'6 Externality'!J289","v":0.01},{"$f":"'6 Externality'!K289","v":0.01},{"$f":"'6 Externality'!L289","v":0.01},{"$f":"'6 Externality'!M289","v":0.01},{"$f":"'6 Externality'!N289","v":0.01},{"$f":"'6 Externality'!O289","v":0.01},{"$f":"'6 Externality'!P289","v":0.01},{"$f":"'6 Externality'!Q289","v":0.01},{"$f":"'6 Externality'!R289","v":0.01},{"$f":"'6 Externality'!S289","v":0.01}]
[null,null,{"$f":"C104","v":"Výsledný růstový koeficient ohodnocení emisí"},null,{"$f":"S104*(1+E108)","v":1.3574826555738269},{"$f":"E109*(1+F108)","v":1.3710574821295651},1.3847680569508607,1.3986157375203694,1.4126018948955732,1.426727913844529,1.4409951929829743,1.455405144912804,1.4699591963619321,1.4846587883255513,1.4995053762088069,1.5145004299708948,1.5296454342706038,1.5449418886133099,1.5603913074994431]
[]
[]
[null,"Komentáře"]
[]
[null,"Zpracovatel uvede konkrétní hodnoty výstupů z dopravního prognózování použité při výpočtu emisí železniční dopravy. Tabulky 7.5. a 7.6. je možné přizpůsobit konkrétnímu projektu."]
[null,"V tabulce 7.1. a  7.2. uvede zpracovatel konkrétní výpočet pomocí vzorců, s odkazem na tabulky výkonů (tabulka 7.5. a 7.6.) a měrného ohodnocení (tabulka 7.4.)."]
[null,"a vynásobí hodnoty v tabulce 7.1 a 7.2 hodnotou z tabulky 7.7"]

{"sheet":"8 Bezpečnost železniční dopravy","index":8,"n_rows":55,"n_cols":19,"rows_kept":55,"cut":false,"hidden":false,"merged":[[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],[9,9,10,9],[9,10,10,10],[9,17,10,17],[9,18,10,18],[1,12,2,12],[1,13,2,13],[1,16,2,16],[1,17,2,17],[1,14,2,14],[1,15,2,15],[9,11,10,11],[9,12,10,12],[9,13,10,13],[9,14,10,14],[1,18,2,18],[9,15,10,15],[9,4,10,4],[9,5,10,5],[9,6,10,6],[9,7,10,7],[9,8,10,8],[9,16,10,16],[18,12,19,12],[18,13,19,13],[18,14,19,14],[18,15,19,15],[18,4,19,4],[18,5,19,5],[18,6,19,6],[18,7,19,7],[18,11,19,11],[18,8,19,8],[18,9,19,9],[18,10,19,10],[26,11,27,11],[26,18,27,18],[18,16,19,16],[18,17,19,17],[18,18,19,18],[26,12,27,12],[26,13,27,13],[26,14,27,14],[26,15,27,15],[26,16,27,16],[26,17,27,17],[26,4,27,4],[26,5,27,5],[26,6,27,6],[26,7,27,7],[26,10,27,10],[26,8,27,8],[26,9,27,9]]}
[]
[null,"8.1.","Celkové zvýšení bezpečnosti železniční dopravy (CZK)",null,{"$f":"'0 Úvod'!G19","v":2016},{"$f":"E2+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a",null,"Celkem"]
[null,null,"Zamezení úmrtí",{"$f":"SUM(E4:S4,E12:S12)","v":0}]
[null,null,"Zamezení zranění",{"$f":"SUM(E5:S5,E13:S13)","v":0}]
[null,null,"Škody na infrastruktuře",0]
[null,null,"Škody na vozidlech",0]
[null,null,"CELKEM",0,{"$f":"SUM(E4:E7)","v":0},{"$f":"SUM(F4:F7)","v":0},{"$f":"SUM(G4:G7)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"8.1.","Celkové zvýšení bezpečnosti železniční dopravy (CZK)",null,{"$f":"S2+1","v":2031},{"$f":"E10+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b"]
[null,null,{"$f":"IF(C4=\"\",\"\",C4)","v":"Zamezení úmrtí"}]
[null,null,{"$f":"IF(C5=\"\",\"\",C5)","v":"Zamezení zranění"}]
[null,null,{"$f":"IF(C6=\"\",\"\",C6)","v":"Škody na infrastruktuře"}]
[null,null,{"$f":"IF(C7=\"\",\"\",C7)","v":"Škody na vozidlech"}]
[null,null,{"$f":"IF(C8=\"\",\"\",C8)","v":"CELKEM"},null,{"$f":"SUM(E12:E15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"8.2.","Celkové zvýšení bezpečnosti železniční dopravy (CZK)",null,{"$f":"E2","v":2016},{"$f":"E19+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a",null,"Celkem"]
[null,null,{"$f":"IF(C4=\"\",\"\",C4)","v":"Zamezení úmrtí"},{"$f":"SUM(E21:S21,E29:S29)","v":0},{"$f":"E4","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(C5=\"\",\"\",C5)","v":"Zamezení zranění"},{"$f":"SUM(E22:S22,E30:S30)","v":0},{"$f":"E5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(C6=\"\",\"\",C6)","v":"Škody na infrastruktuře"},0,{"$f":"E6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(C7=\"\",\"\",C7)","v":"Škody na vozidlech"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(C8=\"\",\"\",C8)","v":"CELKEM"},0,{"$f":"SUM(E21:E24)","v":0},{"$f":"SUM(F21:F24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"8.2.","Celkové zvýšení bezpečnosti železniční dopravy (CZK)",null,{"$f":"S19+1","v":2031},{"$f":"E27+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b"]
[null,null,{"$f":"IF(C12=\"\",\"\",C12)","v":"Zamezení úmrtí"},null,{"$f":"E12","v":0},{"$f":"F12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(C13=\"\",\"\",C13)","v":"Zamezení zranění"},null,{"$f":"E13","v":0},{"$f":"F13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(C14=\"\",\"\",C14)","v":"Škody na infrastruktuře"},null,{"$f":"E14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(C15=\"\",\"\",C15)","v":"Škody na vozidlech"},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(C16=\"\",\"\",C16)","v":"CELKEM"},null,{"$f":"SUM(E29:E32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,"Úspory (CZK)",{"$f":"D25","v":0}]
[]
[null,"8.3.","Hodnota zamezení úmrtí a zranění","CÚ","úmrtí","vážné zranění","lehké zranění"]
[null,null,"Měrná hodnota",2012,23337530,3163532,226303]
[null,null,"Měrná hodnota",{"$f":"'0 Úvod'!D19","v":2016}]
[null,null,"Zdroj: Metodiky hodnocení efektivnosti investice - železniční infrastruktura (příloha C7), MD ČR 2013"]
[]
[]
[null,"Příklad:"]
[null,null,"Zdroj: Drážní úřad - výskyty mimořádných událostí"]
[null,null,"Datum","Druh mimořádné události","Popis","Místo","Místo MU","upřesnění","Usmrcených","Zraněných","Škoda - Drážní vozidla","Škoda - Infrastruktura","Škoda - Ost. účastníci","Škoda - 3. strany","Škoda - Neurčeno"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Mimořádná událost","Výskyt za 1 ROK","Hodnota výskytu","pst."]

{"sheet":"9 Ostatní příjmy či náklady","index":9,"n_rows":41,"n_cols":19,"rows_kept":41,"cut":false,"hidden":false,"merged":[[38,1,39,15],[18,12,19,12],[1,18,2,18],[18,4,19,4],[18,5,19,5],[18,6,19,6],[18,7,19,7],[18,8,19,8],[1,8,2,8],[1,16,2,16],[1,10,2,10],[1,11,2,11],[1,15,2,15],[1,4,2,4],[1,5,2,5],[1,6,2,6],[9,4,10,4],[9,5,10,5],[9,6,10,6],[9,7,10,7],[26,4,27,4],[26,5,27,5],[26,6,27,6],[26,7,27,7],[18,10,19,10],[18,11,19,11],[1,7,2,7],[1,9,2,9],[26,8,27,8],[9,11,10,11],[9,8,10,8],[9,9,10,9],[9,10,10,10],[18,9,19,9],[9,15,10,15],[18,15,19,15],[18,16,19,16],[18,13,19,13],[18,14,19,14],[9,16,10,16],[1,13,2,13],[1,12,2,12],[1,14,2,14],[9,12,10,12],[9,13,10,13],[9,14,10,14],[26,18,27,18],[26,11,27,11],[26,9,27,9],[26,10,27,10],[26,16,27,16],[26,12,27,12],[26,13,27,13],[26,14,27,14],[26,15,27,15],[26,17,27,17],[9,17,10,17],[9,18,10,18],[18,18,19,18],[1,17,2,17],[18,17,19,17]]}
[" "]
[null,"9.1.",null,null,{"$f":"'0 Úvod'!G19","v":2016},{"$f":"E2+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a",null,"Celkem"]
[null,null,null,{"$f":"SUM(E4:S4,E12:S12)","v":0}]
[null,null,null,{"$f":"SUM(E5:S5,E13:S13)","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0,{"$f":"SUM(E4:E7)","v":0},{"$f":"SUM(F4:F7)","v":0},{"$f":"SUM(G4:G7)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"9.1.",null,null,{"$f":"S2+1","v":2031},{"$f":"E10+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b"]
[null,null,{"$f":"IF(C4=\"\",\"\",C4)","v":""}]
[null,null,{"$f":"IF(C5=\"\",\"\",C5)","v":""}]
[null,null,{"$f":"IF(C6=\"\",\"\",C6)","v":""}]
[null,null,{"$f":"IF(C7=\"\",\"\",C7)","v":""}]
[null,null,{"$f":"IF(C8=\"\",\"\",C8)","v":""},null,{"$f":"SUM(E12:E15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"9.2.",null,null,{"$f":"E2","v":2016},{"$f":"E19+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a",null,"Celkem"]
[null,null,{"$f":"IF(C4=\"\",\"\",C4)","v":""},{"$f":"SUM(E21:S21,E29:S29)","v":0},{"$f":"E4","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(C5=\"\",\"\",C5)","v":""},{"$f":"SUM(E22:S22,E30:S30)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(C6=\"\",\"\",C6)","v":""},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(C7=\"\",\"\",C7)","v":""},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(C8=\"\",\"\",C8)","v":""},0,{"$f":"SUM(E21:E24)","v":0},{"$f":"SUM(F21:F24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"9.2.",null,null,{"$f":"S19+1","v":2031},{"$f":"E27+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b"]
[null,null,{"$f":"IF(C12=\"\",\"\",C12)","v":""},null,{"$f":"E12","v":0},{"$f":"F12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(C13=\"\",\"\",C13)","v":""},null,{"$f":"E13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(C14=\"\",\"\",C14)","v":""},null,{"$f":"E14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(C15=\"\",\"\",C15)","v":""},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(C16=\"\",\"\",C16)","v":""},null,{"$f":"SUM(E29:E32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,"Výnosy/náklady (CZK)",{"$f":"D25","v":0}]
[]
[]
[null,"Komentáře"]
[]
[null,"Mohou být zahrnuty i jiné přínosy a náklady dle konkrétního projektu. Zpracovatel uvede konkrétní vstupní hodnoty použité při výpočtu."]

{"sheet":"10 Ekonomická analýza","index":10,"n_rows":44,"n_cols":20,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,4,2,4],[18,4,19,4],[1,9,2,9],[1,10,2,10],[1,15,2,15],[18,12,19,12],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,14,2,14],[41,1,42,15],[18,17,19,17],[18,13,19,13],[18,14,19,14],[18,15,19,15],[18,11,19,11],[18,16,19,16],[1,19,2,19],[18,5,19,5],[18,6,19,6],[18,7,19,7],[18,8,19,8],[18,9,19,9],[18,10,19,10],[18,19,19,19],[1,17,2,17],[1,18,2,18],[18,18,19,18],[1,8,2,8],[1,11,2,11],[1,12,2,12],[1,16,2,16],[1,13,2,13]]}
[]
[null,"10.1. ","Ekonomická analýza (CZK)",null,"KF",{"$f":"'0 Úvod'!G19","v":2016},{"$f":"F2+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"a",null,"Celkem"]
[null,null,"Celkem provozní náklady železnice - úspora",{"$f":"SUM(F4:T4,F21:T21)","v":0},"T3.3.",{"$f":"IF(F2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!E47,0)","v":0},{"$f":"IF(G2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!F47,0)","v":0},{"$f":"IF(H2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!G47,0)","v":0},{"$f":"IF(I2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!H47,0)","v":0},{"$f":"IF(J2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!I47,0)","v":0},{"$f":"IF(K2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!J47,0)","v":0},{"$f":"IF(L2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!K47,0)","v":0},{"$f":"IF(M2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!L47,0)","v":0},{"$f":"IF(N2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!M47,0)","v":0},{"$f":"IF(O2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!N47,0)","v":0},{"$f":"IF(P2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!O47,0)","v":0},{"$f":"IF(Q2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!P47,0)","v":0},{"$f":"IF(R2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!Q47,0)","v":0},{"$f":"IF(S2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!R47,0)","v":0},{"$f":"IF(T2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!S47,0)","v":0}]
[null,null,"Celkem úspory v silniční dopravě",{"$f":"SUM(F5:T5,F22:T22)","v":0},null,{"$f":"IF(F2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!E31,0)","v":0},{"$f":"IF(G2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!F31,0)","v":0},{"$f":"IF(H2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!G31,0)","v":0},{"$f":"IF(I2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!H31,0)","v":0},{"$f":"IF(J2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!I31,0)","v":0},{"$f":"IF(K2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!J31,0)","v":0},{"$f":"IF(L2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!K31,0)","v":0},{"$f":"IF(M2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!L31,0)","v":0},{"$f":"IF(N2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!M31,0)","v":0},{"$f":"IF(O2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!N31,0)","v":0},{"$f":"IF(P2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!O31,0)","v":0},{"$f":"IF(Q2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!P31,0)","v":0},{"$f":"IF(R2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!Q31,0)","v":0},{"$f":"IF(S2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!R31,0)","v":0},{"$f":"IF(T2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!S31,0)","v":0}]
[null,null,"Celkem úspory z cestovních dob",0,null,{"$f":"IF(F2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!E58,0)","v":0},{"$f":"IF(G2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!F58,0)","v":0},{"$f":"IF(H2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!G58,0)","v":0},{"$f":"IF(I2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!H58,0)","v":0},{"$f":"IF(J2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!I58,0)","v":0},{"$f":"IF(K2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!J58,0)","v":0},{"$f":"IF(L2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!K58,0)","v":0},{"$f":"IF(M2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!L58,0)","v":0},{"$f":"IF(N2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!M58,0)","v":0},{"$f":"IF(O2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!N58,0)","v":0},{"$f":"IF(P2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!O58,0)","v":0},{"$f":"IF(Q2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!P58,0)","v":0},{"$f":"IF(R2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!Q58,0)","v":0},{"$f":"IF(S2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!R58,0)","v":0},{"$f":"IF(T2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!S58,0)","v":0}]
[null,null,"Celkem externality (vč. emisí ze železniční dopravy)",0,null,{"$f":"IF(F2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!E78+'7 Emise ze železniční dopravy'!E42,0)","v":0},{"$f":"IF(G2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!F78+'7 Emise ze železniční dopravy'!F42,0)","v":0},{"$f":"IF(H2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!G78+'7 Emise ze železniční dopravy'!G42,0)","v":0},{"$f":"IF(I2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!H78+'7 Emise ze železniční dopravy'!H42,0)","v":0},{"$f":"IF(J2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!I78+'7 Emise ze železniční dopravy'!I42,0)","v":0},{"$f":"IF(K2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!J78+'7 Emise ze železniční dopravy'!J42,0)","v":0},{"$f":"IF(L2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!K78+'7 Emise ze železniční dopravy'!K42,0)","v":0},{"$f":"IF(M2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!L78+'7 Emise ze železniční dopravy'!L42,0)","v":0},{"$f":"IF(N2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!M78+'7 Emise ze železniční dopravy'!M42,0)","v":0},{"$f":"IF(O2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!N78+'7 Emise ze železniční dopravy'!N42,0)","v":0},{"$f":"IF(P2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!O78+'7 Emise ze železniční dopravy'!O42,0)","v":0},{"$f":"IF(Q2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!P78+'7 Emise ze železniční dopravy'!P42,0)","v":0},{"$f":"IF(R2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!Q78+'7 Emise ze železniční dopravy'!Q42,0)","v":0},{"$f":"IF(S2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!R78+'7 Emise ze železniční dopravy'!R42,0)","v":0},{"$f":"IF(T2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!S78+'7 Emise ze železniční dopravy'!S42,0)","v":0}]
[null,null,"Celkem zvýšení bezpečnosti železniční dopravy",0,null,{"$f":"IF(F2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!E25,0)","v":0},{"$f":"IF(G2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!F25,0)","v":0},{"$f":"IF(H2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!G25,0)","v":0},{"$f":"IF(I2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!H25,0)","v":0},{"$f":"IF(J2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!I25,0)","v":0},{"$f":"IF(K2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!J25,0)","v":0},{"$f":"IF(L2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!K25,0)","v":0},{"$f":"IF(M2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!L25,0)","v":0},{"$f":"IF(N2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!M25,0)","v":0},{"$f":"IF(O2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!N25,0)","v":0},{"$f":"IF(P2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!O25,0)","v":0},{"$f":"IF(Q2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!P25,0)","v":0},{"$f":"IF(R2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!Q25,0)","v":0},{"$f":"IF(S2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!R25,0)","v":0},{"$f":"IF(T2<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!S25,0)","v":0}]
[null,null,"Ostatní přínosy",0]
[null,null,"Celkové příjmy",{"$f":"SUM(D4:D9)","v":0},null,{"$f":"SUM(F4:F9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Ostatní náklady",{"$f":"SUM(F11:T11,F28:T28)","v":0}]
[null,null,"Celkem investiční náklady bez rezervy",{"$f":"SUM(F12:T12,F29:T29)","v":0},0.93,{"$f":"'1 Celkové investiční náklady'!G11*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!H11*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!I11*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!J11*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!K11*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!L11*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!M11*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!N11*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!O11*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!P11*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!Q11*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!R11*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!S11*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!T11*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!U11*$E$12","v":0}]
[null,null,"Zůstatková hodnota (záporná)",{"$error":"#DIV/0!"},null,{"$f":"IF(F2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(G2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(H2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(I2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(J2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(K2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(L2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(M2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(N2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(O2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(P2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(Q2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(R2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(S2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(T2='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0}]
[null,null,"Celkové náklady",{"$f":"SUM(D11:D13)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(F11:F13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Cash Flow ",{"$f":"SUM(F15:T15,F32:T32)","v":{"$error":"#DIV/0!"}},null,{"$f":"F10-F14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Diskontní sazba",{"$f":"'0 Úvod'!D21","v":0.05},null,1,{"$f":"F16/(1+$D$16)","v":0.95238095238095233},{"$f":"G16/(1+$D$16)","v":0.90702947845804982},0.86383759853147601,0.82270247479188185,0.78352616646845885,0.74621539663662739,0.71068133013012125,0.67683936202868689,0.64460891621779703,0.6139132535407591,0.58467928908643718,0.55683741817755916,0.5303213506452944,0.50506795299551843]
[null,null,"Diskontní cash flow",{"$f":"SUM(F17:T17,F34:T34)","v":{"$error":"#DIV/0!"}},null,{"$f":"F15*F16","v":0},{"$f":"G15*G16","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(F2>='0 Úvod'!$G$21,F4,0)","v":0},{"$f":"IF(G2>='0 Úvod'!$G$21,G4,0)","v":0},{"$f":"IF(H2>='0 Úvod'!$G$21,H4,0)","v":0},{"$f":"IF(I2>='0 Úvod'!$G$21,I4,0)","v":0},{"$f":"IF(J2>='0 Úvod'!$G$21,J4,0)","v":0},{"$f":"IF(K2>='0 Úvod'!$G$21,K4,0)","v":0},{"$f":"IF(L2>='0 Úvod'!$G$21,L4,0)","v":0},{"$f":"IF(M2>='0 Úvod'!$G$21,M4,0)","v":0},{"$f":"IF(N2>='0 Úvod'!$G$21,N4,0)","v":0},{"$f":"IF(O2>='0 Úvod'!$G$21,O4,0)","v":0},{"$f":"IF(P2>='0 Úvod'!$G$21,P4,0)","v":0},{"$f":"IF(Q2>='0 Úvod'!$G$21,Q4,0)","v":0},{"$f":"IF(R2>='0 Úvod'!$G$21,R4,0)","v":0},{"$f":"IF(S2>='0 Úvod'!$G$21,S4,0)","v":0},{"$f":"IF(T2>='0 Úvod'!$G$21,T4,0)","v":0}]
[null,{"$f":"B2","v":"10.1. "},{"$f":"C2","v":"Ekonomická analýza (CZK)"},null,"KF",{"$f":"T2+1","v":2031},{"$f":"F19+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"b"]
[null,null,{"$f":"C4","v":"Celkem provozní náklady železnice - úspora"},null,null,{"$f":"IF(F19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!E56,0)","v":0},{"$f":"IF(G19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!F56,0)","v":0},{"$f":"IF(H19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!G56,0)","v":0},{"$f":"IF(I19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!H56,0)","v":0},{"$f":"IF(J19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!I56,0)","v":0},{"$f":"IF(K19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!J56,0)","v":0},{"$f":"IF(L19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!K56,0)","v":0},{"$f":"IF(M19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!L56,0)","v":0},{"$f":"IF(N19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!M56,0)","v":0},{"$f":"IF(O19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!N56,0)","v":0},{"$f":"IF(P19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!O56,0)","v":0},{"$f":"IF(Q19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!P56,0)","v":0},{"$f":"IF(R19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!Q56,0)","v":0},{"$f":"IF(S19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!R56,0)","v":0},{"$f":"IF(T19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-'3 Provozní náklady železnice'!S56,0)","v":0}]
[null,null,"Celkem úspory v silniční dopravě",null,null,{"$f":"IF(F19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!E41,0)","v":0},{"$f":"IF(G19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!F41,0)","v":0},{"$f":"IF(H19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!G41,0)","v":0},{"$f":"IF(I19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!H41,0)","v":0},{"$f":"IF(J19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!I41,0)","v":0},{"$f":"IF(K19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!J41,0)","v":0},{"$f":"IF(L19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!K41,0)","v":0},{"$f":"IF(M19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!L41,0)","v":0},{"$f":"IF(N19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!M41,0)","v":0},{"$f":"IF(O19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!N41,0)","v":0},{"$f":"IF(P19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!O41,0)","v":0},{"$f":"IF(Q19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!P41,0)","v":0},{"$f":"IF(R19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!Q41,0)","v":0},{"$f":"IF(S19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!R41,0)","v":0},{"$f":"IF(T19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'4 Úspory v silniční dopravě'!S41,0)","v":0}]
[null,null,"Celkem úspory z cestovních dob",null,null,{"$f":"IF(F19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!E65,0)","v":0},{"$f":"IF(G19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!F65,0)","v":0},{"$f":"IF(H19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!G65,0)","v":0},{"$f":"IF(I19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!H65,0)","v":0},{"$f":"IF(J19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!I65,0)","v":0},{"$f":"IF(K19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!J65,0)","v":0},{"$f":"IF(L19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!K65,0)","v":0},{"$f":"IF(M19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!L65,0)","v":0},{"$f":"IF(N19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!M65,0)","v":0},{"$f":"IF(O19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!N65,0)","v":0},{"$f":"IF(P19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!O65,0)","v":0},{"$f":"IF(Q19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!P65,0)","v":0},{"$f":"IF(R19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!Q65,0)","v":0},{"$f":"IF(S19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!R65,0)","v":0},{"$f":"IF(T19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'5 Úspory z cestovních dob'!S65,0)","v":0}]
[null,null,"Celkem externality (vč. emisí ze železniční dopravy)",null,null,{"$f":"IF(F19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!E90+'7 Emise ze železniční dopravy'!E50,0)","v":0},{"$f":"IF(G19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!F90+'7 Emise ze železniční dopravy'!F50,0)","v":0},{"$f":"IF(H19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!G90+'7 Emise ze železniční dopravy'!G50,0)","v":0},{"$f":"IF(I19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!H90+'7 Emise ze železniční dopravy'!H50,0)","v":0},{"$f":"IF(J19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!I90+'7 Emise ze železniční dopravy'!I50,0)","v":0},{"$f":"IF(K19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!J90+'7 Emise ze železniční dopravy'!J50,0)","v":0},{"$f":"IF(L19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!K90+'7 Emise ze železniční dopravy'!K50,0)","v":0},{"$f":"IF(M19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!L90+'7 Emise ze železniční dopravy'!L50,0)","v":0},{"$f":"IF(N19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!M90+'7 Emise ze železniční dopravy'!M50,0)","v":0},{"$f":"IF(O19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!N90+'7 Emise ze železniční dopravy'!N50,0)","v":0},{"$f":"IF(P19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!O90+'7 Emise ze železniční dopravy'!O50,0)","v":0},{"$f":"IF(Q19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!P90+'7 Emise ze železniční dopravy'!P50,0)","v":0},{"$f":"IF(R19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!Q90+'7 Emise ze železniční dopravy'!Q50,0)","v":0},{"$f":"IF(S19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!R90+'7 Emise ze železniční dopravy'!R50,0)","v":0},{"$f":"IF(T19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'6 Externality'!S90+'7 Emise ze železniční dopravy'!S50,0)","v":0}]
[null,null,"Celkem zvýšení bezpečnosti železniční dopravy",null,null,{"$f":"IF(F19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!E33,0)","v":0},{"$f":"IF(G19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!F33,0)","v":0},{"$f":"IF(H19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!G33,0)","v":0},{"$f":"IF(I19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!H33,0)","v":0},{"$f":"IF(J19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!I33,0)","v":0},{"$f":"IF(K19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!J33,0)","v":0},{"$f":"IF(L19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!K33,0)","v":0},{"$f":"IF(M19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!L33,0)","v":0},{"$f":"IF(N19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!M33,0)","v":0},{"$f":"IF(O19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!N33,0)","v":0},{"$f":"IF(P19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!O33,0)","v":0},{"$f":"IF(Q19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!P33,0)","v":0},{"$f":"IF(R19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!Q33,0)","v":0},{"$f":"IF(S19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!R33,0)","v":0},{"$f":"IF(T19<='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,'8 Bezpečnost železniční dopravy'!S33,0)","v":0}]
[null,null,"Ostatní přínosy"]
[null,null,"Celkové příjmy",null,null,{"$f":"SUM(F21:F26)","v":0},{"$f":"SUM(G21:G26)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C11","v":"Ostatní náklady"}]
[null,null,"Celkem investiční náklady bez rezervy",null,null,{"$f":"'1 Celkové investiční náklady'!G26*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!H26*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!I26*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!J26*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!K26*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!L26*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!M26*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!N26*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!O26*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!P26*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!Q26*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!R26*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!S26*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!T26*$E$12","v":0},{"$f":"'1 Celkové investiční náklady'!U26*$E$12","v":0}]
[null,null,"Zůstatková hodnota (záporná)",null,null,{"$f":"IF(F19='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(G19='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(H19='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(I19='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(J19='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(K19='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(L19='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(M19='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(N19='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(O19='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(P19='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(Q19='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(R19='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(S19='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":0},{"$f":"IF(T19='0 Úvod'!$G$19+'0 Úvod'!$J$19-1,-1*'2 Zůstatková hodnota'!$I$8,0)","v":{"$error":"#DIV/0!"}}]
[null,null,"Celkové náklady",null,null,{"$f":"SUM(F28:F30)","v":0},{"$f":"SUM(G28:G30)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,null,"Cash Flow ",null,null,{"$f":"F27-F31","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,null,"Diskontní sazba",null,null,{"$f":"T16*1/(1+$D$16)","v":0.48101709809096993},{"$f":"F33*1/(1+$D$16)","v":0.45811152199139993},{"$f":"G33*1/(1+$D$16)","v":0.43629668761085705},0.41552065486748291,0.39573395701665037,0.37688948287300034,0.35894236464095269,0.34184987108662163,0.32557130579678251,0.31006791028265002,0.29530277169776192,0.28124073495024943,0.26784831900023753,0.25509363714308336,0.2429463210886508]
[null,null,"Diskontní cash flow",null,null,{"$f":"F32*F33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$f":"IF(F19>='0 Úvod'!$G$21,F21,0)","v":0},{"$f":"IF(G19>='0 Úvod'!$G$21,G21,0)","v":0},{"$f":"IF(H19>='0 Úvod'!$G$21,H21,0)","v":0},{"$f":"IF(I19>='0 Úvod'!$G$21,I21,0)","v":0},{"$f":"IF(J19>='0 Úvod'!$G$21,J21,0)","v":0},{"$f":"IF(K19>='0 Úvod'!$G$21,K21,0)","v":0},{"$f":"IF(L19>='0 Úvod'!$G$21,L21,0)","v":0},{"$f":"IF(M19>='0 Úvod'!$G$21,M21,0)","v":0},{"$f":"IF(N19>='0 Úvod'!$G$21,N21,0)","v":0},{"$f":"IF(O19>='0 Úvod'!$G$21,O21,0)","v":0},{"$f":"IF(P19>='0 Úvod'!$G$21,P21,0)","v":0},{"$f":"IF(Q19>='0 Úvod'!$G$21,Q21,0)","v":0},{"$f":"IF(R19>='0 Úvod'!$G$21,R21,0)","v":0},{"$f":"IF(S19>='0 Úvod'!$G$21,S21,0)","v":0},{"$f":"IF(T19>='0 Úvod'!$G$21,T21,0)","v":0}]
[null,"Ekonomické vnitřní výnosové procento ERR",null,null,null,{"$f":"ROUND(IRR((F15:T15,F32:T32),0.05),4)","v":{"$error":"#VALUE!"}}]
[null,"Ekonomická čistá současná hodnota ENPV (CZK)",null,null,null,{"$f":"SUM(F17:T17,F34:T34)","v":{"$error":"#DIV/0!"}}]
[null,"Rentabilita nákladů",null,null,null,{"$f":"(SUMPRODUCT(F10:T10,F16:T16)+SUMPRODUCT(F27:T27,F33:T33)-SUMPRODUCT(F30:T30,F33:T33))/((SUMPRODUCT(F14:T14,F16:T16)+SUMPRODUCT(F31:S31,F33:S33)))","v":{"$error":"#DIV/0!"}}]
[null,"Ekonomická čistá současná hodnota ENPV (EUR)",null,null,null,{"$f":"F37/'0 Úvod'!N19","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"Komentáře"]
[]
[null,"Mohou být zahrnuty i jiné přínosy a náklady dle konkrétního projektu. "]