{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Projekty a příjemci"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Projekty a příjemci","index":0,"n_rows":26,"n_cols":32,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,20,4,20],[5,20,10,20],[12,20,14,20],[15,20,17,20],[18,20,20,20],[0,21,0,22],[0,23,0,24],[18,26,20,26],[0,27,0,28],[0,29,0,30],[2,26,4,26],[5,26,10,26],[12,26,14,26],[15,26,17,26]]}
["ČÍSLO PROJEKTU","PROGRAM","VEŘEJNÁ SOUTĚŽ","NÁZEV PROJEKTU","IČ","NÁZEV","KRAJ","MĚSTO","PRÁVNÍ FORMA","Skupiny PF","Hlavní obor","HLAVNÍ OBOR 2 OBOR","VEDLEJŠÍ OBOR 2 OBOR","DALŠÍ VEDLEJŠÍ OBOR 2 OBOR","NÁKLADY CELKEM (tis. Kč)","DOTACE CELKEM (tis. Kč)","Spolupráce","Hlavní příjemce",null,null,"Projekt","Kombinace (města)",null,"Kombinace (kraj)",null,null,"Projekt (jen pro přehlednost, ve výsledku být nemusí)","Kombinace (města)",null,"Kombinace (kraj)"]
["TA01010078","ALFA","STA02011TA01","Struktury SOI pro pokročilé polovodičové aplikace","IC26821532","ON SEMICONDUCTOR CZECH REPUBLIC, s.r.o.","ZLK","Rožnov pod Radhoštěm","POO",{"$f":"IF(I2=\"POO\",\"PF\",IF(I2=\"FOI\",\"PF\",IF(I2=\"ZSP\",\"PF\",IF(I2=\"VVS\",\"VS\",IF(I2=\"VVI\",\"VI\",\"OS\")))))","v":"PF"},{"$f":"MID([1]!Tabulka1[[#This Row],[HLAVNÍ OBOR 2 OBOR]],1,1)","v":{"$error":"#REF!"}},"JJ","JA","BM",35136,15801,"ano","ano",null,null,"TA01010078","Rožnov pod Radhoštěm","Brno","ZLK","JHM",null,"TA01010078","Rožnov","Brno","ZLK","JHM"]
["TA01010078","ALFA","STA02011TA01","Struktury SOI pro pokročilé polovodičové aplikace","IC00216224","Masarykova univerzita","JHM","Brno","VVS","VS",{"$f":"MID([1]!Tabulka1[[#This Row],[HLAVNÍ OBOR 2 OBOR]],1,1)","v":{"$error":"#REF!"}},"JJ","JA","BM",5111,5111,"ano",{"$f":"IF([1]!Tabulka1[[#This Row],[ČÍSLO PROJEKTU]]=A2,\"ne\",\"ano\")","v":{"$error":"#REF!"}},null,null,"TA01010088","Brno","Brno","JHM","JHM",null,"TA01010088","Brno","Brno","JHM","JHM"]
["TA01010088","ALFA","STA02011TA01","Vývoj a inovace nových nanomateriálů pro cílenou modifikaci cévních náhrad","IC00216305","Vysoké učení technické v Brně","JHM","Brno","VVS","VS",{"$f":"MID([1]!Tabulka1[[#This Row],[HLAVNÍ OBOR 2 OBOR]],1,1)","v":{"$error":"#REF!"}},"JJ","CE","CB",5623,5623,"ano",{"$f":"IF([1]!Tabulka1[[#This Row],[ČÍSLO PROJEKTU]]=A3,\"ne\",\"ano\")","v":{"$error":"#REF!"}},null,null,null,"Brno","Brno","JHM","JHM",null,null,"Brno","Brno","JHM","JHM"]
["TA01010088","ALFA","STA02011TA01","Vývoj a inovace nových nanomateriálů pro cílenou modifikaci cévních náhrad","IC62156489","Mendelova univerzita v Brně","JHM","Brno","VVS","VS",{"$f":"MID([1]!Tabulka1[[#This Row],[HLAVNÍ OBOR 2 OBOR]],1,1)","v":{"$error":"#REF!"}},"JJ","CE","CB",6243,6243,"ano",{"$f":"IF([1]!Tabulka1[[#This Row],[ČÍSLO PROJEKTU]]=A4,\"ne\",\"ano\")","v":{"$error":"#REF!"}},null,null,null,"Brno","Brno","JHM","JHM",null,null,"Brno","Brno","JHM","JHM"]
["TA01010088","ALFA","STA02011TA01","Vývoj a inovace nových nanomateriálů pro cílenou modifikaci cévních náhrad","IC15546578","VUP Medical, a.s.","JHM","Brno","POO","PF",{"$f":"MID([1]!Tabulka1[[#This Row],[HLAVNÍ OBOR 2 OBOR]],1,1)","v":{"$error":"#REF!"}},"JJ","CE","CB",6044,1567,"ano",{"$f":"IF([1]!Tabulka1[[#This Row],[ČÍSLO PROJEKTU]]=A5,\"ne\",\"ano\")","v":{"$error":"#REF!"}},null,null,"TA01010103","Rybitví","Karlovy Vary","PAK","KVK",null,"TA01010103","Rybitví","Karlovy Vary","PAK","KVK"]
["TA01010103","ALFA","STA02011TA01","Nové vodivé polymery na bázi PEDOT pro elektronické aplikace a ochranu materiálů","IC28778758","Centrum organické chemie s.r.o.","PAK","Rybitví","POO","PF",{"$f":"MID([1]!Tabulka1[[#This Row],[HLAVNÍ OBOR 2 OBOR]],1,1)","v":{"$error":"#REF!"}},"CD","CC","CG",6500,6375,"ano",{"$f":"IF([1]!Tabulka1[[#This Row],[ČÍSLO PROJEKTU]]=A6,\"ne\",\"ano\")","v":{"$error":"#REF!"}},null,null,null,"Rybitví","Pardubice","PAK","PAK",null,null,"Rybitví","Pardubice","PAK","PAK"]
["TA01010103","ALFA","STA02011TA01","Nové vodivé polymery na bázi PEDOT pro elektronické aplikace a ochranu materiálů","IC25248294","DCH - Sincolor, a.s.","KVK","Karlovy Vary","POO","PF",{"$f":"MID([1]!Tabulka1[[#This Row],[HLAVNÍ OBOR 2 OBOR]],1,1)","v":{"$error":"#REF!"}},"CD","CC","CG",6260,3600,"ano",{"$f":"IF([1]!Tabulka1[[#This Row],[ČÍSLO PROJEKTU]]=A7,\"ne\",\"ano\")","v":{"$error":"#REF!"}},null,null,null,"Rybitví","Plzeň","PAK","PLK",null,null,"Rybitví","Plzeň","PAK","PLK"]
["TA01010103","ALFA","STA02011TA01","Nové vodivé polymery na bázi PEDOT pro elektronické aplikace a ochranu materiálů","IC46504711","SYNPO, akciová společnost","PAK","Pardubice","POO","PF",{"$f":"MID([1]!Tabulka1[[#This Row],[HLAVNÍ OBOR 2 OBOR]],1,1)","v":{"$error":"#REF!"}},"CD","CC","CG",4000,2437,"ano",{"$f":"IF([1]!Tabulka1[[#This Row],[ČÍSLO PROJEKTU]]=A8,\"ne\",\"ano\")","v":{"$error":"#REF!"}},null,null,null,"Karlovy Vary","Pardubice","KVK","PAK",null,null,"Karlovy Vary","Pardubice","KVK","PAK"]
["TA01010103","ALFA","STA02011TA01","Nové vodivé polymery na bázi PEDOT pro elektronické aplikace a ochranu materiálů","IC49777513","Západočeská univerzita v Plzni","PLK","Plzeň","VVS","VS",{"$f":"MID([1]!Tabulka1[[#This Row],[HLAVNÍ OBOR 2 OBOR]],1,1)","v":{"$error":"#REF!"}},"CD","CC","CG",3200,3200,"ano",{"$f":"IF([1]!Tabulka1[[#This Row],[ČÍSLO PROJEKTU]]=A9,\"ne\",\"ano\")","v":{"$error":"#REF!"}},null,null,null,"Karlovy Vary","Plzeň","KVK","PLK",null,null,"Karlovy Vary","Plzeň","KVK","PLK"]
["TA01010128","ALFA","STA02011TA01","Výzkum lyofilizovaných tablet pro alergenové vakcíny","IC25107305","SEVAPHARMA a.s.","PHA","Praha","POO","PF",{"$f":"MID([1]!Tabulka1[[#This Row],[HLAVNÍ OBOR 2 OBOR]],1,1)","v":{"$error":"#REF!"}},"FR","FN",null,6800,4440,"ano",{"$f":"IF([1]!Tabulka1[[#This Row],[ČÍSLO PROJEKTU]]=A10,\"ne\",\"ano\")","v":{"$error":"#REF!"}},null,null,null,"Pardubice","Plzeň","PAK","PLK",null,null,"Pardubice","Plzeň","PAK","PLK"]
["TA01010128","ALFA","STA02011TA01","Výzkum lyofilizovaných tablet pro alergenové vakcíny","IC00216208","Univerzita Karlova v Praze","HKK","Praha","VVS","VS",{"$f":"MID([1]!Tabulka1[[#This Row],[HLAVNÍ OBOR 2 OBOR]],1,1)","v":{"$error":"#REF!"}},"FR","FN",null,5000,5000,"ano",{"$f":"IF([1]!Tabulka1[[#This Row],[ČÍSLO PROJEKTU]]=A11,\"ne\",\"ano\")","v":{"$error":"#REF!"}},null,null,"TA01010128","Praha","Praha","PHA","HKK",null,"TA01010128","Praha","Praha","PHA","PHA","V týchto 2 prípadoch ste sa pomýlil"]
["TA01010153","ALFA","STA02011TA01","Technologie pro rutinní měření kvalitativních parametrů výsekového masa a pro kontrolovaný proces jeho zrání za účelem zvýšení přidané hodnoty výrobků a definice nových produktů v masném průmyslu.","IC26788462","Agrovýzkum Rapotín s.r.o.","OLK","Rapotín","POO","PF",{"$f":"MID([1]!Tabulka1[[#This Row],[HLAVNÍ OBOR 2 OBOR]],1,1)","v":{"$error":"#REF!"}},"GM","JB","JD",5482,5482,"ano",{"$f":"IF([1]!Tabulka1[[#This Row],[ČÍSLO PROJEKTU]]=A12,\"ne\",\"ano\")","v":{"$error":"#REF!"}},null,null,"TA01010153","Rapotín","Brno","OLK","JHM",null,"TA01010153","Rapotín","Brno","OLK","JHM","Tieto Vaše stĺpce AA:AF zmažte"]
["TA01010153","ALFA","STA02011TA01","Technologie pro rutinní měření kvalitativních parametrů výsekového masa a pro kontrolovaný proces jeho zrání za účelem zvýšení přidané hodnoty výrobků a definice nových produktů v masném průmyslu.","IC46344942","GEOtest, a.s","JHM","Brno","POO","PF",{"$f":"MID([1]!Tabulka1[[#This Row],[HLAVNÍ OBOR 2 OBOR]],1,1)","v":{"$error":"#REF!"}},"GM","JB","JD",300,0,"ano",{"$f":"IF([1]!Tabulka1[[#This Row],[ČÍSLO PROJEKTU]]=A13,\"ne\",\"ano\")","v":{"$error":"#REF!"}},null,null,null,"Rapotín","Kravaře","OLK","MSK",null,null,"Rapotín ","Kravaře","OLK","JHM"]
["TA01010153","ALFA","STA02011TA01","Technologie pro rutinní měření kvalitativních parametrů výsekového masa a pro kontrolovaný proces jeho zrání za účelem zvýšení přidané hodnoty výrobků a definice nových produktů v masném průmyslu.","IC45199981","Jaroslava Klemensová - MASOMA","MSK","Kravaře","FOI","PF",{"$f":"MID([1]!Tabulka1[[#This Row],[HLAVNÍ OBOR 2 OBOR]],1,1)","v":{"$error":"#REF!"}},"GM","JB","JD",3713,1813,"ano",{"$f":"IF([1]!Tabulka1[[#This Row],[ČÍSLO PROJEKTU]]=A14,\"ne\",\"ano\")","v":{"$error":"#REF!"}},null,null,null,"Brno","Kravaře","JHM","MSK",null,null,"Brno","Kravaře","JHM","MSK","Dôležité:"]
["TA01010160","ALFA","STA02011TA01","Nízkoviskózní anorganická pojiva a jejich aplikace","IC26423367","České lupkové závody, a.s.","STC","Nové Strašecí","POO","PF",{"$f":"MID([1]!Tabulka1[[#This Row],[HLAVNÍ OBOR 2 OBOR]],1,1)","v":{"$error":"#REF!"}},"CA","JH","JI",10800,2000,"ano",{"$f":"IF([1]!Tabulka1[[#This Row],[ČÍSLO PROJEKTU]]=A15,\"ne\",\"ano\")","v":{"$error":"#REF!"}},null,null,"TA01010160","Nové Strašecí","Pardubice","STC","PAK",null,"TA01010160","Nové Strašecí","Pardubice","STC","PAK","Ak budete používať iba tento súbor a tento list, a do neho vkladať a upravovať dáta"]
["TA01010160","ALFA","STA02011TA01","Nízkoviskózní anorganická pojiva a jejich aplikace","IC00216275","UNIVERZITA PARDUBICE","PAK","Pardubice","VVS","VS",{"$f":"MID([1]!Tabulka1[[#This Row],[HLAVNÍ OBOR 2 OBOR]],1,1)","v":{"$error":"#REF!"}},"CA","JH","JI",4600,4600,"ano",{"$f":"IF([1]!Tabulka1[[#This Row],[ČÍSLO PROJEKTU]]=A16,\"ne\",\"ano\")","v":{"$error":"#REF!"}},null,null,null,"Nové Strašecí","Ústí nad Labem","STC","ULK",null,null,"Nové Strašecí","Ústí nad Labem","STC","ULK","tak použite v makre v module modKombinuj takýto 7. riadok"]
["TA01010160","ALFA","STA02011TA01","Nízkoviskózní anorganická pojiva a jejich aplikace","IC62243136","Výzkumný ústav anorganické chemie, a.s.","ULK","Ústí nad Labem","POO","PF",{"$f":"MID([1]!Tabulka1[[#This Row],[HLAVNÍ OBOR 2 OBOR]],1,1)","v":{"$error":"#REF!"}},"CA","JH","JI",12200,11400,"ano",{"$f":"IF([1]!Tabulka1[[#This Row],[ČÍSLO PROJEKTU]]=A17,\"ne\",\"ano\")","v":{"$error":"#REF!"}},null,null,null,"Pardubice","Ústí nad Labem","PAK","ULK",null,null,"Pardubice","Ústí nad Labem","PAK","ULK","With wsData"]
["TA01010162","ALFA","STA02011TA01","Výzkum a vývoj nové generace digitálního senzoru pro provozní měření kvality příze","IC60112301","Rieter CZ s.r.o.","PAK","Ústí nad Orlicí","POO","PF",{"$f":"MID([1]!Tabulka1[[#This Row],[HLAVNÍ OBOR 2 OBOR]],1,1)","v":{"$error":"#REF!"}},"JB","JA","JC",9457,4157,"ano",{"$f":"IF([1]!Tabulka1[[#This Row],[ČÍSLO PROJEKTU]]=A18,\"ne\",\"ano\")","v":{"$error":"#REF!"}},null,null,"TA01010162","Ústí nad Orlicí","Praha","PAK","PHA",null,"TA01010162","Ústí nad Orlicí","Praha","PAK","PHA","a bude to fungovať s akýmkoľvek názvom tohto listu"]
["TA01010162","ALFA","STA02011TA01","Výzkum a vývoj nové generace digitálního senzoru pro provozní měření kvality příze","IC48024791","ASICentrum spol. s r.o.","PHA","Praha","POO","PF",{"$f":"MID([1]!Tabulka1[[#This Row],[HLAVNÍ OBOR 2 OBOR]],1,1)","v":{"$error":"#REF!"}},"JB","JA","JC",5970,2658,"ano",{"$f":"IF([1]!Tabulka1[[#This Row],[ČÍSLO PROJEKTU]]=A19,\"ne\",\"ano\")","v":{"$error":"#REF!"}},null,null,null,"Ústí nad Orlicí","Liberec","PAK","LBK",null,null,"Ústí nad Orlicí","Liberec","PAK","LBK"]
["TA01010162","ALFA","STA02011TA01","Výzkum a vývoj nové generace digitálního senzoru pro provozní měření kvality příze","IC46709002","VÚTS, a.s.","LBK","Liberec","POO","PF",{"$f":"MID([1]!Tabulka1[[#This Row],[HLAVNÍ OBOR 2 OBOR]],1,1)","v":{"$error":"#REF!"}},"JB","JA","JC",1743,1743,"ano",{"$f":"IF([1]!Tabulka1[[#This Row],[ČÍSLO PROJEKTU]]=A20,\"ne\",\"ano\")","v":{"$error":"#REF!"}},null,null,null,"Praha","Liberec","PHA","LBK",null,null,"Praha","Liberec","PHA","LBK","Ak budete makro používať na viacerých identicky rozložených listoch v tomto zošite, použite tam"]
[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,"With ThisWorkbook.ActiveSheet"]
[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,"a bude sa to týkať práve toho listu, na ktorom ste a stlačíte tlačítko"]
[]
[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,"Ak budete chcieť natvrdo napísať meno listu do makra, použite tam"]
[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,"With ThisWorkbook.Worksheets(\"Projekty a příjemci\")"]