{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Úvodní list","Datová základna","Seznam zdrojů","Graf1","Graf2","Graf3","Graf4","Graf5","Graf6","Graf7","Graf8","Graf9","Tabulka13","Tabulka14"],"not_rendered":{"charts":9,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":6},"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":"Úvodní list","index":0,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[24,1,24,3],[25,1,25,3],[26,1,26,3],[22,1,22,3],[1,1,4,10],[6,1,8,10],[10,1,16,10],[23,1,23,3]]}
[]
[null,"PPP projekty k kontextu Stavebnictví 4.0"]
[]
[]
[]
[]
[null,"Příloha č.1 - Datová základna pro analýzu rizik"]
[]
[]
[]
[null,"V této elektronické příloze mé diplomové práce uvádím kompletní datovou základnu, že které jsem vycházel při analýze rizik PPP projektů v kapitole 4 hlavní práce. Veškeré předpoklady, ze kterých jsem vycházel, jsou podrobně popsány v kapitole 4.2 hlavní práce (str. 58)."]

{"sheet":"Datová základna","index":1,"n_rows":82,"n_cols":69,"rows_kept":82,"cut":false,"hidden":false,"merged":[[65,1,65,3],[1,43,62,43],[75,1,75,3],[80,1,80,2]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vážená rizika"]
[null,"Číslo","Zdroj","Jméno","Zákl. kategorie","Kategorie","Forma","Koncesionář","Země původu","Region původu","Rok zahájení","Rok zprovoznění","Velikost","Předpokládaná cena","Reálná cena","Úspěšnost","Důvod","Příčinná fáze","Inovativní prvky","Ztráta na realizaci projektu","Fin - financování","Fin - makroekon","Fin - záruky","Kons - náklady","Kons - zdržení","Kons - kvalita","Oper - výpadky","Oper - údržba","Příjm - výnosy","Příjm - poptávka","Příjm - splácení","Pol - legislativa","Pol - vypovězení","Pol - korupce","Pol - geopol","Příp - smlouva","Příp - partner","Příp - konkurence","Příp - povolení","Příp - pozemky","Příp - pomalá","Ost - vyš. moc",null,"Pomocné výpočty","Regionální váha","Úspěšnost*váha","Hodnoty rozdílu nákladů","Fin - financování","Fin - makroekon","Fin - záruky","Kons - náklady","Kons - zdržení","Kons - kvalita","Oper - výpadky","Oper - údržba","Příjm - výnosy","Příjm - poptávka","Příjm - splácení","Pol - legislativa","Pol - vypovězení","Pol - korupce","Pol - geopol","Příp - smlouva","Příp - partner","Příp - konkurence","Příp - povolení","Příp - pozemky","Příp - pomalá","Ost - vyš. moc"]
[null,1,"str. 12 hlavní práce","Dálnice D47 Brno - Ostrava","Doprava","Silniční infrastruktura ","DBFO","Housing & Construction (IL)","ČR","V4",2002,"Nezprovozněno","Velmi velký",125000000000,125000000000,4,"Pol - vypovězení","Příprava","-",650000000,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0.5,1,0,1,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.25},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS3","v":5},{"$f":"(Tabulka3[[#This Row],[Ztráta na realizaci projektu]]+Tabulka3[[#This Row],[Reálná cena]])/Tabulka3[[#This Row],[Reálná cena]]","v":1.0052000000000001},{"$f":"U3*$AS3","v":0},{"$f":"V3*$AS3","v":0},0,0,0,0,0,0,0,0,0,0,1.25,1.25,0.625,1.25,{"$f":"AK3*$AS3","v":0},{"$f":"AL3*$AS3","v":1.25},{"$f":"AM3*$AS3","v":0},{"$f":"AN3*$AS3","v":0},0,0]
[null,2,"str. 12 hlavní práce","Ubytovna ÚVN","Obecní služba","Zdravotnictví","DBFO","Metrostav Development (CZ)","ČR","V4",2011,"Nezprovozněno","Střední",500000000,5500000000,4,"Pol - vypovězení","Příprava","-",217000000,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.25},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS4","v":5},{"$f":"(Tabulka3[[#This Row],[Ztráta na realizaci projektu]]+Tabulka3[[#This Row],[Reálná cena]])/Tabulka3[[#This Row],[Reálná cena]]","v":1.0394545454545454},{"$f":"U4*$AS4","v":0},{"$f":"V4*$AS4","v":0},{"$f":"W4*$AS4","v":0},{"$f":"X4*$AS4","v":0},{"$f":"Y4*$AS4","v":0},{"$f":"Z4*$AS4","v":0},{"$f":"AA4*$AS4","v":0},{"$f":"AB4*$AS4","v":0},{"$f":"AC4*$AS4","v":0},{"$f":"AD4*$AS4","v":0},{"$f":"AE4*$AS4","v":0},{"$f":"AF4*$AS4","v":0},{"$f":"AG4*$AS4","v":1.25},{"$f":"AH4*$AS4","v":1.25},{"$f":"AI4*$AS4","v":0},{"$f":"AJ4*$AS4","v":0},{"$f":"AK4*$AS4","v":0},{"$f":"AL4*$AS4","v":0},{"$f":"AM4*$AS4","v":0},{"$f":"AN4*$AS4","v":0},{"$f":"AO4*$AS4","v":0},{"$f":"AP4*$AS4","v":0}]
[null,3,"str. 14 hlavní práce","Parkovací dům Rychtářka","Doprava","Parkovací infrasturktura","DBFO","Equity Capital (CZ)","ČR","V4",2010,2011,"Malý",250000000,351000000,2,"Příjm - poptávka","Provoz","-","-",0,0,0,1,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.25},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS5","v":2.5},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1.4039999999999999},0,0,0,1.25,0,0,0,0,1.25,1.25,0,0,0,0,0,0,0,0,0,0,0,0]
[null,4,"str. 14 hlavní práce","Depo MHD Plzeň","Doprava","Hromadná doprava ","DBFO","Škoda Transportation (CZ)","ČR","V4",2013,2014,"Velký",16000000000,14000000000,1,"-","-","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.25},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS6","v":1.25},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":0.875},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,5,"str. 16 hlavní práce, [D1]","Eurotunel","Doprava","Železniční infrastruktura ","DBFO","Eurotunnel (GB)","Velká Británie","Západ",1988,1994,"Velmi velký",162000000000,266000000000,3,"Fin - financování","Provoz","-","-",1,0.5,0,1,1,1,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0.5,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS7","v":3},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1.6419753086419753},1,0.5,0,1,1,1,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0.5]
[null,6,"str. 17 hlavní práce, [D2]","Metro Londýn","Doprava","Hromadná doprava ","FO","Metronet (GB)","Velká Británie","Západ",1998,1998,"Velmi velký",206000000000,{"$f":"N8+74000000000","v":280000000000},4,"Pol - vypovězení","Provoz","-",null,1,0,0.5,1,0,0,0.5,0.5,1,0,0,0,1,0,0,0,1,1,1,0,1,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS8","v":4},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1.3592233009708738},1,0,0.5,1,0,0,0.5,0.5,1,0,0,0,1,0,0,0,1,1,1,0,1,0]
[null,7,"str. 18 hlavní práce, [D3]","Dálnice D1 Martin - Prešov","Doprava","Silniční infrastruktura ","DBFO","Bouygues (F)","Slovensko","V4",2010,"Nezprovozněno","Velmi velký",48000000000,82000000000,4,"Pol - vypovězení","Příprava","-",2000000000,1,1,0.5,1,0,0,0,0,0,0,0,1,1,1,0,0,0.5,0,1,0,1,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.25},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS9","v":5},{"$f":"(Tabulka3[[#This Row],[Ztráta na realizaci projektu]]+Tabulka3[[#This Row],[Reálná cena]])/Tabulka3[[#This Row],[Reálná cena]]","v":1.024390243902439},1.25,1.25,0.625,1.25,0,0,0,0,0,0,0,1.25,1.25,1.25,0,0,0.625,0,1.25,0,1.25,0]
[null,8,"str. 18 hlavní práce","Rychl. silnice R1 Nitra - B. Bystrica","Doprava","Silniční infrastruktura ","DBFO","Vinci (F)","Slovensko","V4",2009,2012,"Velmi velký",40000000000,40000000000,1,"-","-","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.25},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS10","v":1.25},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,9,"str. 19 hlavní práce","Obchvat Bratislavy (D4R7)","Doprava","Silniční infrastruktura ","DBFO","Cintra (E)","Slovensko","V4",2017,"Ve výstavbě","Velmi velký",51000000000,51000000000,2,"Příp - pomalá","Příprava","-","-",0,0,0,0,0.5,0.5,0,0,0,0,0,0,0,0,0,0,0,0,0.5,0,1,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.25},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS11","v":2.5},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0.625,0.625,0,0,0,0,0,0,0,0,0,0,0,0,0.625,0,1.25,0]
[null,10,"str. 19 hlavní práce","Nákladní nádraží Žilina","Doprava","Železniční infrastruktura ","FO","METRANS (CZ)","Slovensko","V4",2018,2018,"Malý",96000000,96000000,1,"-","-","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.25},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS12","v":1.25},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,11,"str. 20 hlavní práce","Dálnice Podgorica - Mateševo","Doprava","Silniční infrastruktura ","DBFO","CRBC (CN)","Černá Hora","Balkán",2006,2022,"Velmi velký",25000000000,25000000000,4,"Příp - smlouva","Příprava","-","-",1,0.5,1,1,1,1,0,0,0,0,1,0.5,0,0,1,1,1,1,0,0,0.5,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":0.9},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS13","v":3.6},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0.9,0.45,0.9,0.9,0.9,0.9,0,0,0,0,0.9,0.45,0,0,0.9,0.9,0.9,0.9,0,0,0.45,0]
[null,12,"str. 20 hlavní práce, [D4]","Provoz přístavu Bar","Doprava","Námořní infrastruktura ","FO","Global Ports Holding (GB)","Černá Hora","Balkán",2013,2013,"Velký","N/A","N/A",2,"Oper - údržba","Provoz","-","-",0,0,0,0,0,0,0,0.5,0,0,0,0.5,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":0.9},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS14","v":1.8},1,0,0,0,0,0,0,0,0.45,0,0,0,0.45,0,0,0,0,0,0,0,0,0,0]
[null,13,"[D5,D6]","Dálnice A1 Gdaňsk - Toruň","Doprava","Silniční infrastruktura ","DBFO","Skanska (S)","Polsko","V4",2004,2011,"Velmi velký",34000000000,34000000000,1,"-","-","-","-",0,0.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.25},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS15","v":1.25},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0.625,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,14,"[D7]","Parkovací dům Wroclaw","Doprava","Parkovací infrasturktura","DBFO","Budimex (PL)","Polsko","V4",2012,2014,"Malý",240000000,240000000,1,"-","-","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.25},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS16","v":1.25},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,15,"[D8,D9]","Tramvajové tratě Krakow","Doprava","Hromadná doprava ","DBFO","Gulermak (TR)","Polsko","V4",2020,"Ve výstavbě","Velký",3800000000,3800000000,3,"Kons - zdržení","Realizace","-",730000000,0,0,0,1,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0.5,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.25},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS17","v":3.75},{"$f":"(Tabulka3[[#This Row],[Ztráta na realizaci projektu]]+Tabulka3[[#This Row],[Reálná cena]])/Tabulka3[[#This Row],[Reálná cena]]","v":1.1921052631578948},0,0,0,1.25,1.25,0,0,0,0,0,0,1.25,0,0,0,0,0,0,0,0,0.625,0]
[null,16,"[D8,D10]","Elektrárna a teplárna v Olsztyně","Obecní služba","Energetika","DBFO","Meridiam (FR)","Polsko","V4",2018,"Ve výstavbě","Velký",4800000000,4800000000,1,"-","-","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.25},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS18","v":1.25},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,17,"[D8,D11]","Odpadní hospodářství v Poznani","Obecní služba","Odpadní hospodářství","DBFO","SUEZ (FR)","Polsko","V4",2013,2016,"Velký",4200000000,4200000000,1,"-","-","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.25},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS19","v":1.25},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,18,"[D8,D12]","Podzemní parkoviště Varšava","Doprava","Parkovací infrasturktura","DBFO","Mota-Engil (PR)","Polsko","V4",2012,"Ve výstavbě","Malý",460000000,460000000,2,"Pol - legislativa","Příprava","-","-",0,0,0,0,0,0,0,0,0,0.5,0,1,0,0,0,0,0,0,0,0,1,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.25},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS20","v":2.5},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0.625,0,1.25,0,0,0,0,0,0,0,0,1.25,0]
[null,19,"[D8]","Kongresové centrum Katovice","Obecní služba","Kultura","FO","PTWP (PL)","Polsko","V4",2016,2016,"Střední",1300000000,1300000000,1,"-","-","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.25},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS21","v":1.25},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,20,"[D8,D13]","Muzeum mazovského venkova","Obecní služba","Kultura","FO","Centrum Urszula Tomaszewska (PL)","Polsko","V4",2015,2015,"Malý",360000000,360000000,1,"-","-","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.25},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS22","v":1.25},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,21,"[D8]","Komunální komunikace Słupsk","Doprava","Silniční infrastruktura ","DBFO","BDB Partnerstwo (PL)","Polsko","V4",2019,"Ve výstavbě","Malý",240000000,240000000,1,"-","-","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.25},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS23","v":1.25},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,22,"[D8,D14]","Půjčovna elektroaut Wroclaw","Doprava","Ostatní dopr. infrstr. ","DBFO","ENIGMA SOI (PL)","Polsko","V4",2017,2020,"Malý",108000000,108000000,4,"Příjm - výnosy","Příprava","-","-",0,0,0,0,0,0,0,0,1,0.5,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.25},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS24","v":5},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,1.25,0.625,0,0,0,0,0,0,0,0,0,0,0,0]
[null,23,"[D15,D16]","Dálnice N17/18 Gort - Tuam","Doprava","Silniční infrastruktura ","DBFO","Strabag (A)","Irsko","Západ",2014,2017,"Velmi velký",23500000000,23500000000,2,"Příp - pozemky","Příprava","-","-",0.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0.5,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS25","v":2},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0.5,0]
[null,24,"[D17]","Tunel Limerick","Doprava","Silniční infrastruktura ","DBFO","Strabag (A)","Irsko","Západ",2006,2010,"Velký",16000000000,16000000000,1,"-","-","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS26","v":1},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,25,"[D18]","Rozšíření silnice M50","Doprava","Silniční infrastruktura ","DBFO","Globalvia Inversiones (E)","Irsko","Západ",2007,2015,"Velmi velký",23500000000,23500000000,1,"-","-","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS27","v":1},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,26,"[D19,D20]","Sociální bydlení Dublin","Obecní služba","Ubytování","DBFO","Macquarie Capital (AUS)","Irsko","Západ",2019,2021,"Velký",7500000000,7500000000,2,"Příp - smlouva","Příprava","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS28","v":2},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0]
[null,27,"[D21]","Námořní vysoká škola v Dublinu","Obecní služba","Školství","DBFO","Bovis Lend Lease (GB)","Irsko","Západ",2001,2004,"Střední",4700000000,4700000000,1,"-","-","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS29","v":1},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,28,"[35]","Královská nemocnice Calderdale","Obecní služba","Zdravotnictví","DBFO","Bovis Lend Lease (GB)","Velká Británie","Západ",1998,2001,"Velký",8600000000,21300000000,3,"Příp - smlouva","Příprava","-","-",0,0,0,1,0,0,0,0.5,0,0,0,0,0,0,0,1,0.5,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS30","v":3},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":2.4767441860465116},0,0,0,1,0,0,0,0.5,0,0,0,0,0,0,0,1,0.5,0,0,0,0,0]
[null,29,"[D22,D23]","Nemocnice Barts and the Royal London","Obecní služba","Zdravotnictví","DBFO","Skanska (S)","Velká Británie","Západ",2006,2014,"Velmi velký",41000000000,43000000000,2,"Kons - náklady","Realizace","-","-",0,0,0,0.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.5,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS31","v":2},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1.0487804878048781},0,0,0,0.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.5,0]
[null,30,"[D24,D25]","Školy v East Dunbartonshire","Obecní služba","Školství","DBFO","Semperian (GB)","Velká Británie","Západ",2007,2009,"Střední",4000000000,4000000000,2,"Kons - zdržení","Realizace","-","-",0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0.5,0.5,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS32","v":2},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0.5,0.5,0,0,0,0,0]
[null,31,"[D26]","Dálnice A19 Dishforth - Tyne Tunnel","Doprava","Silniční infrastruktura ","DBFO","Sir Robert McAlpine (GB)","Velká Británie","Západ",1996,1998,"Velmi velký",19800000000,28100000000,3,"Oper - údržba","Provoz","-","-",0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0.5,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS33","v":3},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1.4191919191919191},0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0.5,0,0,0,0,0,0]
[null,32,"[D27]","Komunikační satelity Skynet 5","Doprava","Vesmírná infrastruktura","DBFO","Airbus (NL)","Velká Británie","Západ",2003,2008,"Velmi velký",107000000000,107000000000,1,"-","-","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS34","v":1},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,33,"[D28,D29,D30]","Vys. rychl. železnice Nîmes - Montpellier","Doprava","Železniční infrastruktura ","DBFO","Bouygues (FR)","Francie","Západ",2012,2017,"Velmi velký",45000000000,45000000000,1,"-","-","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS35","v":1},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,34,"[D30,D31,D32,D33]","Dálnice L2 - Obchvat Marseille","Doprava","Silniční infrastruktura ","DBFO","Bouygues (FR)","Francie","Západ",2013,2018,"Velký",15400000000,15400000000,2,"Kons - zdržení","Realizace","-","-",0,0,0,0,1,1,0,0.5,0,0,0,0,0,0,0,1,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS36","v":2},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,1,1,0,0.5,0,0,0,0,0,0,0,1,0,0,0,0,0,0]
[null,35,"[D34]","Rekonstr. dálnice A12 Utrecht - Veenendaal","Doprava","Silniční infrastruktura ","DBFO","BAM PPP (NL)","Nizozemí","Západ",2010,2011,"Velký",9300000000,9300000000,1,"-","-","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS37","v":1},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,36,"[D35]","Tramvajové depo Antverpy","Doprava","Hromadná doprava ","DBFO","Heijmans (NL)","Belgie","Západ",2011,2012,"Střední",3100000000,3100000000,1,"-","-","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS38","v":1},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,37,"[D15,D36,D37]","Dálnice A1 Burgos - Armiñón","Doprava","Silniční infrastruktura ","DBFO","Europistas Concesionaria Española (E)","Španělsko","Jih",2010,2012,"Velký",11800000000,15800000000,3,"Příjm - poptávka","Provoz","-","-",0,0.5,0,1,1,0,0,0,0.5,1,0,0,0.5,0,0,0.5,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS39","v":3},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1.3389830508474576},0,0.5,0,1,1,0,0,0,0.5,1,0,0,0.5,0,0,0.5,0,0,0,0,0,0]
[null,38,"[D15,D38]","Rekonstrukce dálnice C25 v Katalánsku","Doprava","Silniční infrastruktura ","DBFO","N/A","Španělsko","Jih",2010,2013,"Velký",17300000000,20700000000,3,"Fin - makroekon","Provoz","-","-",0,1,0,1,1,0,0,0,0,0,0,0,0.5,0,0,0.5,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS40","v":3},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1.1965317919075145},0,1,0,1,1,0,0,0,0,0,0,0,0.5,0,0,0.5,0,0,0,0,0,0]
[null,39,"[D39,D40]","Dálnice \"Pedemontana Veneta\" na Benátsku","Doprava","Silniční infrastruktura ","DBFO","Finninc (I)","Itálie","Jih",2011,"Ve výstavbě","Velmi velký",69000000000,69000000000,3,"Příp - povolení","Příprava","-","-",0,0,0,0,0,0,0,0,0,0,0,0.5,0,0,0,0,0,0,1,0,1,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS41","v":3},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0,0,0.5,0,0,0,0,0,0,1,0,1,0]
[null,40,"[D15,D41]","Dálnice Moreas","Doprava","Silniční infrastruktura ","DBFO","Ellaktor (GB)","Řecko","Jih",2008,2016,"Velmi velký",38500000000,44723000000,3,"Příjm - poptávka","Příprava","-","-",0,1,0,1,1,0,0,0,0.5,1,0,0.5,0.5,0,0,0.5,0,0.5,0,0,0.5,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS42","v":3},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1.1616363636363636},0,1,0,1,1,0,0,0,0.5,1,0,0.5,0.5,0,0,0.5,0,0.5,0,0,0.5,0]
[null,41,"[D15,D42]","Dálnice Olympia","Doprava","Silniční infrastruktura ","DBFO","Vinci (F)","Řecko","Jih",2008,2017,"Velmi velký",70600000000,79900000000,3,"Příjm - poptávka","Příprava","-","-",0,1,0,1,1,0,0,0,0.5,1,0,0.5,0.5,0,0,0.5,0,0.5,0,0,0.5,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS43","v":3},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1.131728045325779},0,1,0,1,1,0,0,0,0.5,1,0,0.5,0.5,0,0,0.5,0,0.5,0,0,0.5,0]
[null,42,"[D43]","Nové hasičské stanice ","Obecní služba","Bezpečnost","DBFO","Ellaktor (GB)","Řecko","Jih",2007,2013,"Střední",650000000,650000000,2,"Kons - zdržení","Realizace","-","-",0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS44","v":2},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,43,"[D44]","Sportovní hala Varadín","Obecní služba","Sport","DBFO","T.P.N. DRAVA (HR)","Chorvatsko","Balkán",2007,2008,"Střední",590000000,590000000,1,"-","-","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":0.9},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS45","v":0.9},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,44,"[D44,D45]","Nový terminál letiště Záhřeb","Doprava","Letecká infrastruktura","DBFO","Bouygues (FR)","Chorvatsko","Balkán",2013,2017,"Velký",8300000000,8300000000,1,"-","-","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":0.9},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS46","v":0.9},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,45,"[D46,D47]","Fotbalový stadion Stožice","Obecní služba","Sport","DBFO","Grep (SLO)","Slovinsko","Balkán",2006,2010,"Střední",3300000000,3300000000,3,"Příjm - poptávka","Příprava","-","-",0,0,0,0,0,0,0,0,0.5,1,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":0.9},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS47","v":2.7},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0.45,0.9,0,0,0,0,0,0,0,0,0,0,0,0]
[null,46,"[D48,D49]","Spalovna odpadů Bělehrad","Obecní služba","Odpadní hospodářství","DBFO","SUEZ (FR)","Srbsko","Balkán",2017,"Ve výstavbě","Velký",8100000000,8100000000,4,"Příp - pozemky","Příprava","-","-",0,0,0,0,0,0,0,0,0,1,0,0.5,0,0,0,0,0,1,0,1,1,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":0.9},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS48","v":3.6},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0.9,0,0.45,0,0,0,0,0,0.9,0,0.9,0.9,0]
[null,47,"[D51,D52]","Dálnice M1/M15 Gyor - Bratislava - Rakousko","Doprava","Silniční infrastruktura ","DBFO","N/A","Maďarsko","V4",1993,1998,"Velký",7000000000,7000000000,4,"Fin - financování","Příprava","-","-",1,0,0,0,0,0,0,0.5,1,1,0,1,0,0,0,0,1,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.25},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS49","v":5},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},1.25,0,0,0,0,0,0,0.625,1.25,1.25,0,1.25,0,0,0,0,1.25,0,0,0,0,0]
[null,48,"[D53,D54]","Dálnice M6 Budapest - Dunaujvarös","Doprava","Silniční infrastruktura ","DBFO","Aberdeen Asset Management (GB)","Maďarsko","V4",2006,2010,"Velký",13000000000,13000000000,3,"Příjm - poptávka","Příprava",null,null,0,0,0,1,0,0,0,0,0.5,1,1,0,0,0,0,0.5,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.25},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS50","v":3.75},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,1.25,0,0,0,0,0.625,1.25,1.25,0,0,0,0,0.625,0,0,0,0,0,0]
[null,49,"[D55,D56]","Palác kultury Budapešť","Obecní služba","Kultura","DBFO","TriGránit (H)","Maďarsko","V4",2000,2003,"Velký",4350000000,20600000000,4,"Příp - smlouva","Příprava","-","-",0,0,0,1,1,0.5,0,0,0,0,0,0,0,0.5,0,1,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.25},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS51","v":5},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":4.735632183908046},0,0,0,1.25,1.25,0.625,0,0,0,0,0,0,0,0.625,0,1.25,0,0,0,0,0,0]
[null,50,"[D57,D58]","Technická univerzita Budapešť","Obecní služba","Školství","DBFO","Hérosz (H)","Maďarsko","V4",2007,2010,"Střední",670000000,880000000,3,"Fin - makroekon","Provoz","-","-",1,1,0,0,0.5,0,0,0,0,0,0,0,0,0,0,0.5,0,0.5,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.25},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS52","v":3.75},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1.3134328358208955},1.25,1.25,0,0,0.625,0,0,0,0,0,0,0,0,0,0,0.625,0,0.625,0,0,0,0]
[null,51,"[D59]","Dálnice A1 Hamburk - Brémy","Doprava","Silniční infrastruktura ","DBFO","Bunte (D)","Německo","Německé",2008,2012,"Velký",16200000000,19400000000,3,"Příjm - poptávka","Příprava","-","-",1,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.1000000000000001},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS53","v":3.3000000000000003},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1.1975308641975309},1.1000000000000001,1.1000000000000001,0,0,0,0,0,0,0,1.1000000000000001,0,0,0,0,0,0,0,0,0,0,0,0]
[null,52,"[D60,D61]","Základní školy v Offenbachu","Obecní služba","Školství","DBFO","Hochtief (D)","Německo","Německé",2010,2013,"Střední",1500000000,1500000000,2,"Oper - údržba","Provoz","-","-",0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.1000000000000001},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS54","v":2.2000000000000002},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,1.1000000000000001,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,53,"[D62]","Parkovací dům Villingen-Schwenningen","Doprava","Parkovací infrasturktura","DBFO","PARK SERVICE HÜFNER (D)","Německo","Německé",2010,2011,"Malý",110000000,110000000,1,"-","-","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.1000000000000001},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS55","v":1.1000000000000001},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,54,"[D63]","Rozšíření dálnice A6 Wiesloch - Rauenberg","Doprava","Silniční infrastruktura ","DBFO","Hochtief (D)","Německo","Německé",2017,"Ve výstavbě","Velmi velký",32000000000,32000000000,1,"-","-","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.1000000000000001},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS56","v":1.1000000000000001},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,55,"[D64,D65]","Obchvat Ebelsbergu (čtvrť města Linz)","Doprava","Silniční infrastruktura ","DBFO","Raiffeisen (A)","Rakousko","Německé",1997,2000,"Střední",2500000000,2300000000,2,"Příp - smlouva","Příprava","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.1000000000000001},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS57","v":2.2000000000000002},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":0.92},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.1000000000000001,0,0,0,0,0,0]
[null,56,"[D64]","Logistické centrum Graz","Doprava","Ostatní dopr. infrstr. ","DBFO","Andradit Vermögensverwaltung (A)","Rakousko","Německé",2000,2001,"Střední",2000000000,1600000000,1,"-","-","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":1.1000000000000001},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS58","v":1.1000000000000001},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":0.8},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,57,"[D66,D67]","Silnice Rv.3 a Rv.25 Løten - Elverum","Doprava","Silniční infrastruktura ","DBFO","Skanska (S)","Norsko","Sever",2018,2020,"Velký",13600000000,10900000000,1,"-","-","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":0.9},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS59","v":0.9},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":0.80147058823529416},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,58,"[D68]","Policejní stanice Trondheim","Obecní služba","Bezpečnost","DBFO","N/A","Norsko","Sever",2004,2004,"Střední",650000000,650000000,1,"-","-","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":0.9},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS60","v":0.9},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,59,"[D69,D70]","Letištní železnice Stockholm","Doprava","Železniční infrastruktura ","DBFO","Macquarie Capital (AUS)","Švédsko","Sever",1995,1999,"Velký",10000000000,10000000000,2,"Příjm - výnosy","Příprava","-","-",0.5,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0.5,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":0.9},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS61","v":1.8},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0.45,0,0,0,0,0,0,0,0.9,0,0,0,0,0,0,0.45,0,0,0,0,0,0]
[null,60,"[D71]","Dálnice 4 Järvenpää - Lahti","Doprava","Silniční infrastruktura ","DBFO","Skanska (S)","Finsko","Sever",1997,1999,"Velký",6000000000,6000000000,1,"-","-","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":0.9},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS62","v":0.9},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,61,"[D72,73]","Obchvat města Ķekava","Doprava","Silniční infrastruktura ","DBFO","TIIC (P)","Lotyšsko","Sever",2021,"Ve výstavbě","Střední",1500000000,1500000000,2,"Příp - pomalá","Příprava","-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,null,null,{"$f":"IF(Tabulka3[[#This Row],[Region původu]]=\"V4\", 1.25, IF(Tabulka3[[#This Row],[Region původu]]=\"Německé\", 1.1, IF(Tabulka3[[#This Row],[Region původu]]=\"Balkán\", 0.9, IF(Tabulka3[[#This Row],[Region původu]]=\"Sever\", 0.9, 1))))","v":0.9},{"$f":"Tabulka3[[#This Row],[Úspěšnost]]*AS63","v":1.8},{"$f":"Tabulka3[[#This Row],[Reálná cena]]/Tabulka3[[#This Row],[Předpokládaná cena]]","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.9,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AV3:AV63)/SUM($AS$3:$AS$63)","v":0.13181818181818178},{"$f":"SUM(AW3:AW63)/SUM($AS$3:$AS$63)","v":0.13143939393939391},3.0681818181818175E-2,0.22196969696969693,0.19166666666666662,6.2878787878787867E-2,2.2727272727272721E-2,7.0833333333333331E-2,0.13977272727272724,0.18030303030303027,3.257575757575757E-2,0.11893939393939393,0.10227272727272725,6.6287878787878771E-2,2.3106060606060599E-2,0.18484848484848479,7.2348484848484843E-2,8.5984848484848483E-2,5.8712121212121202E-2,2.8787878787878779E-2,0.16098484848484845,7.5757575757575742E-3]
[]
[null,"Číselné výsledky analýzy"]
[]
[null,"Vážený průměr úspěšností",null,{"$f":"SUMPRODUCT(Tabulka3[Úspěšnost],$AS$3:$AS$63)/SUM(AS3:AS63)","v":2.1068181818181819}]
[]
[null,"Vážený průměr úspěšností dle velikostí"]
[null,"Malý",null,{"$f":"(AT5+AT12+AT16+AT20+AT22+AT23+AT24+AT55)/(AS5+AS12+AS16+AS20+AS22+AS23+AS24+AS55)","v":1.6345177664974622}]
[null,"Střední",null,{"$f":"(AT4+AT21+AT29+AT32+AT38+AT44+AT45+AT47+AT52+AT54+AT57+AT58+AT60+AT63)/(AS4+AS21+AS29+AS32+AS38+AS44+AS45+AS47+AS52+AS54+AS57+AS58+AS60+AS63)","v":1.8976109215017065}]
[null,"Velký",null,{"$f":"(AT6+AT14+AT17+AT18+AT19+AT28+AT26+AT30+AT36+AT37+AT39+AT40+AT46+AT48+AT49+AT50+AT51+AT53+AT59+AT61+AT62)/(AS6+AS14+AS17+AS18+AS19+AS26+AS28+AS30+AS36+AS37+AS39+AS40+AS46+AS48+AS49+AS50+AS51+AS53+AS59+AS61+AS62)","v":2.2224719101123589}]
[null,"Velmi velký",null,{"$f":"(AT3+AT7+AT8+AT9+AT10+AT11+AT13+AT15+AT25+AT27+AT31+AT33+AT34+AT35+AT41+AT42+AT43+AT56)/(AS3+AS7+AS8+AS9+AS10+AS11+AS13+AS15+AS25+AS27+AS31+AS33+AS34+AS35+AS41+AS42+AS43+AS56)","v":2.3740259740259742}]
[]
[null,"Průměr úspěšností dle regionů"]
[null,"Severní Evropa",null,1.4]
[null,"Německy mluvící země",null,1.66]
[null,"Západní Evropa",null,1.88]
[null,"Země Visegrádské čtyřky",null,2.23]
[null,"Balkán",null,2.5]
[null,"Jižní Evropa",null,2.83]

{"sheet":"Seznam zdrojů","index":2,"n_rows":74,"n_cols":3,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[]
[null,"[D1]","https://www.ejrcf.or.jp/jrtr/jrtr11/f46_gra.html"]
[null,"[D2]","https://www.centreforpublicimpact.org/case-study/london-undergrounds-failed-ppp"]
[null,"[D3]","https://www.finance.cz/zpravy/finance/278818-slovensko-upustilo-od-stavby-casti-d1-v-ramci-projektu-ppp/"]
[null,"[D4]","https://www.portseurope.com/port-of-adria-accused-of-violating-bar-port-concession-contract/"]
[null,"[D5]","http://www.epppc.hu/documents/cikkek712a1motorwaypoland.pdf"]
[null,"[D6]","https://www.roadtraffic-technology.com/projects/gdansktoturan/"]
[null,"[D7]","https://parkinghalastulecia.pl/en/wiadomosci/first-ppp-car-park-in-wroclaw-now-open/"]
[null,"[D8]","https://www.ppp.gov.pl/baza-zawartych-umow-ppp/"]
[null,"[D9]","https://inwestycje.pl/biznes/gulermak-spodziewa-sie-poczatku-robot-w-projekcie-ppp-w-krakowie-w-ii-kw-2022/"]
[null,"[D10]","https://inzynierbudownictwa.pl/w-olsztynie-powstanie-nowoczesna-elektrocieplownia/"]
[null,"[D11]","https://pie.grupainfomax.eu/wp-content/uploads/2020/09/materialy_pokonferencyjne_16092020.pdf?_x_tr_sl=pl&_x_tr_tl=cs&_x_tr_hl=cs"]
[null,"[D12]","https://gazetazoliborza.pl/2019/02/miasto-stawia-na-partnerstwo-publiczno-prawne-w-sprawie-parkingow-podziemnych-nie-ma-w-warszawie-deficytu-parkingowego/"]
[null,"[D13]","https://www.sierpc.pl/index.php?option=com_content&view=article&id=2477&catid=4&Itemid=60"]
[null,"[D14]","https://gazetawroclawska.pl/vozilla-znika-z-wroclawia-miejska-wypozyczalnia-aut-konczy-dzialalnosc-co-z-samochodami/ar/c1-14720892"]
[null,"[D15]","https://op.europa.eu/webpub/eca/special-reports/ppp-9-2018/cs/"]
[null,"[D16]","https://www.worldhighways.com/wh8/wh10/news/strabag-refinances-irelands-n17n18-project-between-gort-and-tuam"]
[null,"[D17]","https://www.tii.ie/roads-tolling/projects-and-improvements/ppp/n7-limerick-southern-ring/index.xml"]
[null,"[D18]","https://www.m50concession.com/"]
[null,"[D19]","https://www.ndfa.ie/project/social-housing-ppp-bundle-1"]
[null,"[D20]","https://www.sinnfein.ie/contents/53356"]
[null,"[D21]","https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=&ved=2ahUKEwinrIbJ5Yf1AhULRfEDHZ4ODtAQFnoECAcQAQ&url=https%3A%2F%2Fwww.transnav.eu%2Ffiles%2FThe%2520Public%2520Private%2520Partnership%2520Model%2520on%2520Which%2520the%2520National%2520Maritime%2520College%2520of%2520Ireland%2520Was%2520Conceived%2520and%2520Delivered%2C63.pdf&usg=AOvVaw1Dwxf9eRLv4k402-knAG-x"]
[null,"[D22]","https://ijglobal.com/articles/32241/barts-and-the-royal-london-hospitals-pfi"]
[null,"[D23]","https://www.skanska.se/49f1f8/siteassets/om-skanska/press/nks-i-media/barts-white-paper-single-pages-brochure-format.pdf"]
[null,"[D24]","https://www.pppforum.com/case-studies/east-dunbartonshire"]
[null,"[D25]","https://www.heraldscotland.com/default_content/12752964.delay-fears-six-schools-built-ppp-project/"]
[null,"[D26]","https://www.sunderlandecho.com/news/transport/pfi-anger-cost-maintaining-a19-north-east-rises-almost-ps280m-814975"]
[null,"[D27]","https://www.pfie.com/story/1267054/skynet-5-takes-pfi-into-space-3b9pxkx1gk"]
[null,"[D28]","https://www.bouygues-tp.com/en/projects/nimes-montpellier-railway-bypass"]
[null,"[D29]","https://www.actu-transport-logistique.fr/ferroviaire/ferroviaire-le-contournement-de-nimes-et-de-montpellier-redonne-des-capacites-de-developpement-au-fret-454463.php"]
[null,"[D30]","https://library.pppknowledgelab.org/documents/2851/download"]
[null,"[D31]","http://l2-marseille.com/"]
[null,"[D32]","https://marsactu.fr/rocade-l2-24-000-euros-dastreinte-journaliere-pour-la-filiale-de-bouygues/"]
[null,"[D33]","https://www.tpbm-presse.com/marseille-eurovia-en-charge-des-amenagements-de-surface-de-la-l2-nord-2915.html"]
[null,"[D34]","https://ijglobal.com/articles/65033/the-netherlands-a12-highway-ppp"]
[null,"[D35]","https://www.frateurdepourcq.be/en/portfolio/brabo/"]
[null,"[D36]","https://www.ap1europistas.es/"]
[null,"[D37]","https://www.ap1europistas.es/"]
[null,"[D38]","https://es.wikipedia.org/wiki/C-25"]
[null,"[D39]","https://www.superstradapedemontanaveneta.it/superstrada-pedemontana-veneta/"]
[null,"[D40]","https://angelidelsuolo.wordpress.com/2021/11/01/la-superstrada-pedemontana-veneta-una-cesura-di-94-5-km-tra-treviso-e-vicenza/"]
[null,"[D41]","https://en.wikipedia.org/wiki/Olympia_Odos"]
[null,"[D42]","https://en.wikipedia.org/wiki/Moreas_Motorway"]
[null,"[D43]","http://sdit.gov.gr/en/Approved-projects/construction-and-maintenance-7-new-fire-stations"]
[null,"[D44]","https://www.aik-invest.hr/en/ppp/registry/"]
[null,"[D45]","https://ppp-ebrd.com/review.php?country=Croatia"]
[null,"[D46]","http://stadiumdb.com/news/2015/08/slovenia_shockingly_empty_national_stadium_in_ljubljana"]
[null,"[D47]","http://www.ier.si/files/Working%20paper-68.pdf"]
[null,"[D48]","https://bankwatch.org/public-private-partnerships/case-studies/belgrade-incinerator-ppp-belgrade-serbia"]
[null,"[D49]","https://balkangreenenergynews.com/public-private-partnership-misses-deadline-to-shut-belgrades-vinca-landfill/"]
[null,"[D50]","https://bankwatch.org/public-private-partnerships/case-studies/palace-arts-budapest-hungary"]
[null,"[D51]","https://ppiaf.org/sites/ppiaf.org/files/documents/toolkits/highwaystoolkit/6/pdf-version/hungary.pdf"]
[null,"[D52]","https://bankwatch.org/public-private-partnerships/case-studies/m1m15-and-m5-motorways-hungary"]
[null,"[D53]","https://demnet.hu/en/7-percent-gdp-wasted-on-ppp-in-hungary/"]
[null,"[D54]","https://ijglobal.com/articles/50197/hungarys-m6-phase-ii"]
[null,"[D55]","https://bankwatch.org/public-private-partnerships/case-studies/palace-arts-budapest-hungary"]
[null,"[D56]","https://demnet.hu/en/billionaire-made-superprofit-on-art-ppp-in-budapest/"]
[null,"[D57]","https://www.origo.hu/gazdasag/20090809-muegyetem-lagymanyosi-ppp-beruhazas-q-epulet-finanszirozasa.html"]
[null,"[D58]","https://hvg.hu/karrier/200945_EGYETEMI_PPPGoNDoK_A_fele_sem_igaz"]
[null,"[D59]","https://second.wiki/wiki/a1_mobil"]
[null,"[D60]","https://www.ppp-projektdatenbank.de/index.php?id=27&tx_ppp_controller_searchmap%5BprojectId%5D=270&tx_ppp_controller_searchmap%5Baction%5D=showProject"]
[null,"[D61]","https://www.iz.de/projekte/news/-ppp-war-dem-kreis-offenbach-zu-teuer-155752?crefresh=1"]
[null,"[D62]","https://www.ppp-projektdatenbank.de/index.php?id=27&tx_ppp_controller_searchmap%5BprojectId%5D=272&tx_ppp_controller_searchmap%5Baction%5D=showProject"]
[null,"[D63]","https://www.hochtief-pppsolutions.com/projekte/details/a6-highway"]
[null,"[D64]","http://www.bestufs.net/download/Workshops/BESTUFS_I/Malaga_Sep02/BESTUFS_Malaga_Sep02_Dorner_Econsult_2.pdf"]
[null,"[D65]","https://ooe.kpoe.at/article.php/20110210095843119"]
[null,"[D66]","https://www.infrapppworld.com/news/megaproject-1272-norway-s-first-ppp-project-in-over-a-decade-reaches-financial-close"]
[null,"[D67]","https://www.veier24.no/artikler/ops-prosjektet-rv-3-rv-25-karet-til-arets-anlegg-2020/512992"]
[null,"[D68]","https://iglcstorage.blob.core.windows.net/papers/attachment-0c3b09b3-06ad-4dd7-ac6f-099456fcc2f2.pdf"]
[null,"[D69]","https://en.wikipedia.org/wiki/Arlanda_Line"]
[null,"[D70]","https://www.oecd.org/mena/competitiveness/39303611.pdf"]
[null,"[D71]","https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=&cad=rja&uact=8&ved=2ahUKEwjNuILPxJH1AhUBKuwKHYDKDLYQFnoECAcQAQ&url=https%3A%2F%2Fwiki.unece.org%2Fdownload%2Fattachments%2F25265810%2FBrussels-seppo-maekinen-ppp-experiences-in-finland.pdf%3Fversion%3D1%26modificationDate%3D1454319973707%26api%3Dv2&usg=AOvVaw26S25EqQNhBrVCqfXJmb-7"]
[null,"[D72]","https://www.nib.int/cases/connecting-the-region-through-public-private-partnerships"]
[null,"[D73]","https://lvportals.lv/norises/278623-kekavas-apvedcels-bus-pirmais-ppp-projekts-latvija-2016"]

{"sheet":"Graf1","index":3,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Zákl. kategorie","Počet z Zákl. kategorie"]
["Doprava",43]
["Obecní služba",18]

{"sheet":"Graf2","index":4,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Forma","Počet z Forma"]
["DBMO",56]
["MO",5]

{"sheet":"Graf3","index":5,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Region původu","Počet z Region původu"]
["Balkán",6]
["Jih",6]
["Německé",6]
["Sever",5]
["V4",22]
["Západ",16]

{"sheet":"Graf4","index":6,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Velikost","Počet z Velikost"]
["Malý",8]
["Střední",14]
["Velký",21]
["Velmi velký",18]

{"sheet":"Graf5","index":7,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Úspěšnost","Počet z Úspěšnost"]
[1,25]
[2,14]
[3,13]
[4,9]

{"sheet":"Graf6","index":8,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Popisky řádků","Počet z Úspěšnost"]
["Malý",8]
[1,5]
[2,2]
[4,1]
["Střední",14]
[1,6]
[2,5]
[3,2]
[4,1]
["Velký",21]
[1,8]
[2,4]
[3,6]
[4,3]
["Velmi velký",18]
[1,6]
[2,3]
[3,5]
[4,4]
["Celkový součet",61]

{"sheet":"Graf7","index":9,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Vážený průměr úspěšností dle velikostí"]
[null,"Malý",null,1.63]
[null,"Střední",null,1.99]
[null,"Velký",null,2.2200000000000002]
[null,"Velmi velký",null,2.37]

{"sheet":"Graf8","index":10,"n_rows":63,"n_cols":3,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Rok zahájení","Úspěšnost"]
[null,1988,3]
[null,1993,4]
[null,1995,2]
[null,1996,3]
[null,1997,2]
[null,1997,1]
[null,1998,4]
[null,1998,3]
[null,2000,4]
[null,2000,1]
[null,2001,1]
[null,2002,4]
[null,2003,1]
[null,2004,1]
[null,2004,1]
[null,2006,4]
[null,2006,1]
[null,2006,2]
[null,2006,3]
[null,2006,3]
[null,2007,1]
[null,2007,2]
[null,2007,2]
[null,2007,1]
[null,2007,3]
[null,2008,3]
[null,2008,3]
[null,2008,3]
[null,2009,1]
[null,2010,2]
[null,2010,4]
[null,2010,1]
[null,2010,3]
[null,2010,3]
[null,2010,2]
[null,2010,1]
[null,2011,4]
[null,2011,1]
[null,2011,3]
[null,2012,1]
[null,2012,2]
[null,2012,1]
[null,2013,1]
[null,2013,2]
[null,2013,1]
[null,2013,2]
[null,2013,1]
[null,2014,2]
[null,2015,1]
[null,2016,1]
[null,2017,2]
[null,2017,4]
[null,2017,4]
[null,2017,1]
[null,2018,1]
[null,2018,1]
[null,2018,1]
[null,2019,1]
[null,2019,2]
[null,2020,3]
[null,2021,2]

{"sheet":"Graf9","index":11,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Provoz",9]
[null,"Příprava",22]
[null,"Realizace",5]

{"sheet":"Tabulka13","index":12,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Kategorie","Riziko","Stupeň pravděpod.","% předpoklad ","% reálné","Změna"]
[null,"Finanční rizika","Problémy s financováním projektu",1,0.01,0.13,"Značné zvýšení "]
[null,null,"Inflace, změna úrokových sazeb",2,0.03,0.13,"Značné zvýšení"]
[null,null,"Neposkytnutí bankovních záruk",2,0.03,0.03,"Cca odpovídá"]
[null,"Konstrukční rizika","Překročení nákladů z technických důvodů ",4,0.1,0.22,"Značné zvýšení"]
[null,null,"Zdržení projektu z technických důvodů",5,0.15,0.19,"Cca odpovídá"]
[null,null,"Nesplnění požadavků na kvalitu",2,0.03,0.06,"Zvýšení"]
[null,"Operační rizika","Neplnění podmínek poskytování služby",2,0.03,0.02,"Cca odpovídá"]
[null,null,"Neplnění podmínek údržby",3,0.05,7.0000000000000007E-2,"Cca odpovídá"]
[null,"Příjmová rizika","Nižší výnosy oproti předpokladu",4,0.1,0.14000000000000001,"Zvýšení"]
[null,null,"Nižší poptávka oproti předpokladu",5,0.15,0.18,"Cca odpovídá"]
[null,null,"Neschopnost splácet ze strany veřeného sektoru",1,0.01,0.03,"Cca odpovídá"]
[null,"Politická rizika","Změna přístupu státu k PPP projektům, legislativní změny",2,0.03,0.12,"Značné zvýšení"]
[null,null,"Vypovězení smlouvy",3,0.05,0.1,"Značné zvýšení"]
[null,null,"Korupční prostředí (předražení zakázky)",4,0.1,7.0000000000000007E-2,"Cca odpovídá"]
[null,null,"Geopolitická rizika",2,0.03,0.02,"Cca odpovídá"]
[null,"Přípravová rizika","Nevýhodně nastavená smlouva",3,0.05,0.18,"Značné zvýšení"]
[null,null,"Špatný výběr partnera",2,0.03,7.0000000000000007E-2,"Zvýšení"]
[null,null,"Nedostatečná konkurence",3,0.05,0.09,"Zvýšení"]
[null,null,"Neobdržení povolení (stavebního, územního, EIA…)",4,0.1,0.06,"Snížení"]
[null,null,"Nedostatečná příprava plochy (odkup pozemků…)",4,0.1,0.03,"Snížení"]
[null,null,"Značně pomalá příprava",4,0.1,0.16,"Značné zvýšení"]
[null,"Ostatní rizika","Vyšší moc",1,0.01,0.01,"Cca odpovídá"]

{"sheet":"Tabulka14","index":13,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Kategorie","Riziko","Předpokl. stupeň dopadu","Aktualizovaný stupeň dopadu","Poznámky"]
[null,"Finanční rizika","Problémy s financováním projektu",4,"3 - 5","Riziko často důvodem neúspěchu"]
[null,null,"Inflace, změna úrokových sazeb",2,"2 - 4","Riziko často důvodem neúspěchu"]
[null,null,"Neposkytnutí bankovních záruk",5,"4 - 5","Riziko překonatelné -> pomalejší příprava"]
[null,"Konstrukční rizika","Překročení nákladů z technických důvodů ","1 - 4","1 - 2","Náklady nebývají v poměru k těm vzniklým v přípavě tak veliké"]
[null,null,"Zdržení projektu z technických důvodů","3 - 4","3 - 4","Dopad odpovídá"]
[null,null,"Nesplnění požadavků na kvalitu","3 - 4","3 - 4","Dopad odpovídá"]
[null,"Operační rizika","Neplnění podmínek poskytování služby","3 - 5","3 - 5","Dopad odpovídá"]
[null,null,"Neplnění podmínek údržby","2 - 3","2 - 4","Riziko často důvodem neúspěchu"]
[null,"Příjmová rizika","Nižší výnosy oproti předpokladu","2 - 4","3 - 4","Riziko často důvodem neúspěchu"]
[null,null,"Nižší poptávka oproti předpokladu","3 - 4","3 - 5","Riziko často důvodem neúspěchu"]
[null,null,"Neschopnost splácet ze strany veřeného sektoru","5","5","Dopad odpovídá"]
[null,"Politická rizika","Změna přístupu státu k PPP projektům, legislativní změny","3","3 - 4","Mnoho příkladů přepisování smluv a změn v pohledu státní správy"]
[null,null,"Vypovězení smlouvy","5","5","Dopad odpovídá"]
[null,null,"Korupční prostředí (předražení zakázky)","3 - 5","3 - 5","Dopad odpovídá"]
[null,null,"Geopolitická rizika","4","4","Dopad odpovídá"]
[null,"Přípravová rizika","Nevýhodně nastavená smlouva","2 - 5","2 - 5","Dopad odpovídá"]
[null,null,"Špatný výběr partnera","3 - 5","3 - 5","Dopad odpovídá"]
[null,null,"Nedostatečná konkurence","4","4 - 5 ","Konkurence není obecně tak vysoká, jaký byl předpoklad"]
[null,null,"Neobdržení povolení (stavebního, územního, EIA…)","4","3","Riziko překonatelné -> pomalejší příprava"]
[null,null,"Nedostatečná příprava plochy (odkup pozemků…)","2","3","Minimálně v jednom případě hlavní důvod neúspěchu"]
[null,null,"Značně pomalá příprava","3","3","Dopad odpovídá"]
[null,"Ostatní rizika","Vyšší moc","1 - 5","1 - 5","Dopad odpovídá"]