{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Vzor","Ukázka","Prac"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Vzor","index":0,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[[11,0,11,3],[12,0,12,3],[1,5,1,16],[2,5,2,16],[3,5,3,16],[5,0,5,3],[6,0,6,3],[7,0,7,3],[8,0,8,3],[9,0,9,3],[10,0,10,3],[1,1,1,3]]}
[]
[null,null,null,null,null,"Tato služba poskytuje křížovou tabulku pro výsledky jednokolové soutěže, hrané systémem každý s každým."]
[null,null,null,null,null,"Výsledky se do tabulky zanášejí v podobě skóre, a to jen jednou, do horní poloviny tabulky (nad diagonálu)."]
[null,null,null,null,null,"Výsledky pod diagonálou se doplňují automaticky, stejně jako se vyhodnocují průběžné výsledky skupiny."]
[]
["Pseudoformát Skóre je textový řetězec,",null,null,null,null,"Tabulku je nutné znovu generovat, jen když se mění počet účastníků v tabulce.",null,null,null,null,null,null,null,null,"Varianta tabulky pro pool:"]
["složený ze dvou celočíselných položek,",null,null,null,null,"Všechny vzorce jsou vytvořeny tak, aby vzniklá tabulka byla v sešitu přenosná.",null,null,null,null,null,null,null,null,"- nepracuje s remízami,"]
["oddělených znakem dvojtečka  ':'  .",null,null,null,null,"Skóre ve všech vzorcích vyhodnocují uživatelské funkce listu, napsané ve VBA.",null,null,null,null,null,null,null,null,"- Neúplná tabulka používá"]
["Standardně takový zápis znamená",null,null,null,null,"Vygenerované tabulky přenes na nový list pro potřeby konkrétního turnaje.",null,null,null,null,null,null,null,null,"  pořadí podle počtu výher."]
["vložení času \"h:m\", případně \"m:s\".",null,null,null,null,"Tam naplň první sloupec tabulky jmény a přizpůsob jim i šířky ostatních sloupců.",null,null,null,null,null,null,null,null,"- Kompletní tabulka spočítá"]
["V buňce s formátem Text ho ale umí",null,null,null,null,"Úvodní list Vzor a skrytý list Prac nesmějí být smazány ani přejmenovány !!!",null,null,null,null,null,null,null,null,"  standardní poolové pořadí"]
["vlastní UDF, obsažené v tomto sešitě,",null,null,null,null,"Počet a jména přidaných listů pro nové turnaje není prakticky nijak limitován.",null,null,null,null,null,null,null,null,"  s důrazem na vzájemné"]
["vyhodnotit jako klasický zápis skóre.",null,null,null,null,"Buňky nejsou zamčené, ale vzorce ve výběru signalizuje zabudovaná výstraha.",null,null,null,null,null,null,null,null,"  zápasy sousedů v tabulce."]
[]
[null,"TABULKA SOUTĚŽE",{"$f":"B16","v":0},{"$f":"B17","v":0},{"$f":"B18","v":0},{"$f":"B19","v":0},{"$f":"B20","v":0},"Zápasy","Výhry","Skóre","Prac. pořadí"]
[null,null,">XXX<",null,null,null,null,{"$f":"Hry(C16:G16)","v":0},{"$f":"Vyhry(C16:G16)","v":0},{"$f":"SkoreCelkem(C16:G16)","v":"0 : 0"}]
[null,null,{"$f":"SkoreRevers(INDEX(C16:G20,COLUMN()-COLUMN(B15),ROW()-ROW(B15)))","v":""},">XXX<",null,null,null,{"$f":"Hry(C17:G17)","v":0},{"$f":"Vyhry(C17:G17)","v":0},{"$f":"SkoreCelkem(C17:G17)","v":"0 : 0"}]
[null,null,{"$f":"SkoreRevers(INDEX(C16:G20,COLUMN()-COLUMN(B15),ROW()-ROW(B15)))","v":""},{"$f":"SkoreRevers(INDEX(C16:G20,COLUMN()-COLUMN(B15),ROW()-ROW(B15)))","v":""},">XXX<",null,null,0,0,"0 : 0"]
[null,null,{"$f":"SkoreRevers(INDEX(C16:G20,COLUMN()-COLUMN(B15),ROW()-ROW(B15)))","v":""},{"$f":"SkoreRevers(INDEX(C16:G20,COLUMN()-COLUMN(B15),ROW()-ROW(B15)))","v":""},{"$f":"SkoreRevers(INDEX(C16:G20,COLUMN()-COLUMN(B15),ROW()-ROW(B15)))","v":""},">XXX<",null,0,0,"0 : 0"]
[null,null,{"$f":"SkoreRevers(INDEX(C16:G20,COLUMN()-COLUMN(B15),ROW()-ROW(B15)))","v":""},{"$f":"SkoreRevers(INDEX(C16:G20,COLUMN()-COLUMN(B15),ROW()-ROW(B15)))","v":""},{"$f":"SkoreRevers(INDEX(C16:G20,COLUMN()-COLUMN(B15),ROW()-ROW(B15)))","v":""},{"$f":"SkoreRevers(INDEX(C16:G20,COLUMN()-COLUMN(B15),ROW()-ROW(B15)))","v":""},">XXX<",0,0,"0 : 0"]

{"sheet":"Ukázka","index":1,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TABULKA SOUTĚŽE SKUPINA 1",{"$f":"B3","v":"Halamka Dominik"},{"$f":"B4","v":"Čáp Jan"},{"$f":"B5","v":"Sedláček Jan"},{"$f":"B6","v":"Nováková Helena"},{"$f":"B7","v":"Walach Kristián"},{"$f":"B8","v":"Nohynek Dušan"},"Zápasy","Výhry","Skóre","Def. pořadí"]
[null,"Halamka Dominik",">XXX<","5:3","5:1","0:5","3:5","5:2",{"$f":"Hry(C3:H3)","v":5},{"$f":"Vyhry(C3:H3)","v":3},{"$f":"SkoreCelkem(C3:H3)","v":"18 : 16"},1]
[null,"Čáp Jan",{"$f":"SkoreRevers(INDEX(C3:H8,COLUMN()-COLUMN(B2),ROW()-ROW(B2)))","v":"3:5"},">XXX<","1:5","5:2","5:1","5:1",{"$f":"Hry(C4:H4)","v":5},{"$f":"Vyhry(C4:H4)","v":3},{"$f":"SkoreCelkem(C4:H4)","v":"19 : 14"},3]
[null,"Sedláček Jan",{"$f":"SkoreRevers(INDEX(C3:H8,COLUMN()-COLUMN(B2),ROW()-ROW(B2)))","v":"1:5"},{"$f":"SkoreRevers(INDEX(C3:H8,COLUMN()-COLUMN(B2),ROW()-ROW(B2)))","v":"5:1"},">XXX<","5:4","5:3","1:5",5,3,"17 : 18",2]
[null,"Nováková Helena",{"$f":"SkoreRevers(INDEX(C3:H8,COLUMN()-COLUMN(B2),ROW()-ROW(B2)))","v":"5:0"},{"$f":"SkoreRevers(INDEX(C3:H8,COLUMN()-COLUMN(B2),ROW()-ROW(B2)))","v":"2:5"},{"$f":"SkoreRevers(INDEX(C3:H8,COLUMN()-COLUMN(B2),ROW()-ROW(B2)))","v":"4:5"},">XXX<","5:2","5:4",5,3,"21 : 16",4]
[null,"Walach Kristián",{"$f":"SkoreRevers(INDEX(C3:H8,COLUMN()-COLUMN(B2),ROW()-ROW(B2)))","v":"5:3"},{"$f":"SkoreRevers(INDEX(C3:H8,COLUMN()-COLUMN(B2),ROW()-ROW(B2)))","v":"1:5"},{"$f":"SkoreRevers(INDEX(C3:H8,COLUMN()-COLUMN(B2),ROW()-ROW(B2)))","v":"3:5"},{"$f":"SkoreRevers(INDEX(C3:H8,COLUMN()-COLUMN(B2),ROW()-ROW(B2)))","v":"2:5"},">XXX<","5:1",5,2,"16 : 19",5]
[null,"Nohynek Dušan",{"$f":"SkoreRevers(INDEX(C3:H8,COLUMN()-COLUMN(B2),ROW()-ROW(B2)))","v":"2:5"},{"$f":"SkoreRevers(INDEX(C3:H8,COLUMN()-COLUMN(B2),ROW()-ROW(B2)))","v":"1:5"},{"$f":"SkoreRevers(INDEX(C3:H8,COLUMN()-COLUMN(B2),ROW()-ROW(B2)))","v":"5:1"},{"$f":"SkoreRevers(INDEX(C3:H8,COLUMN()-COLUMN(B2),ROW()-ROW(B2)))","v":"4:5"},{"$f":"SkoreRevers(INDEX(C3:H8,COLUMN()-COLUMN(B2),ROW()-ROW(B2)))","v":"1:5"},">XXX<",5,1,"13 : 21",6]
[]
[]
[null,"TABULKA SOUTĚŽE SKUPINA 2",{"$f":"B12","v":0},{"$f":"B13","v":0},{"$f":"B14","v":0},{"$f":"B15","v":0},{"$f":"B16","v":0},{"$f":"B17","v":0},"Zápasy","Výhry","Skóre","Prac. pořadí"]
[null,null,">XXX<",null,null,null,null,null,{"$f":"Hry(C12:H12)","v":0},{"$f":"Vyhry(C12:H12)","v":0},{"$f":"SkoreCelkem(C12:H12)","v":"0 : 0"}]
[null,null,{"$f":"SkoreRevers(INDEX(C12:H17,COLUMN()-COLUMN(B11),ROW()-ROW(B11)))","v":""},">XXX<",null,null,null,null,{"$f":"Hry(C13:H13)","v":0},{"$f":"Vyhry(C13:H13)","v":0},{"$f":"SkoreCelkem(C13:H13)","v":"0 : 0"}]
[null,null,{"$f":"SkoreRevers(INDEX(C12:H17,COLUMN()-COLUMN(B11),ROW()-ROW(B11)))","v":""},{"$f":"SkoreRevers(INDEX(C12:H17,COLUMN()-COLUMN(B11),ROW()-ROW(B11)))","v":""},">XXX<",null,null,null,0,0,"0 : 0"]
[null,null,{"$f":"SkoreRevers(INDEX(C12:H17,COLUMN()-COLUMN(B11),ROW()-ROW(B11)))","v":""},{"$f":"SkoreRevers(INDEX(C12:H17,COLUMN()-COLUMN(B11),ROW()-ROW(B11)))","v":""},{"$f":"SkoreRevers(INDEX(C12:H17,COLUMN()-COLUMN(B11),ROW()-ROW(B11)))","v":""},">XXX<",null,null,0,0,"0 : 0"]
[null,null,{"$f":"SkoreRevers(INDEX(C12:H17,COLUMN()-COLUMN(B11),ROW()-ROW(B11)))","v":""},{"$f":"SkoreRevers(INDEX(C12:H17,COLUMN()-COLUMN(B11),ROW()-ROW(B11)))","v":""},{"$f":"SkoreRevers(INDEX(C12:H17,COLUMN()-COLUMN(B11),ROW()-ROW(B11)))","v":""},{"$f":"SkoreRevers(INDEX(C12:H17,COLUMN()-COLUMN(B11),ROW()-ROW(B11)))","v":""},">XXX<",null,0,0,"0 : 0"]
[null,null,{"$f":"SkoreRevers(INDEX(C12:H17,COLUMN()-COLUMN(B11),ROW()-ROW(B11)))","v":""},{"$f":"SkoreRevers(INDEX(C12:H17,COLUMN()-COLUMN(B11),ROW()-ROW(B11)))","v":""},{"$f":"SkoreRevers(INDEX(C12:H17,COLUMN()-COLUMN(B11),ROW()-ROW(B11)))","v":""},{"$f":"SkoreRevers(INDEX(C12:H17,COLUMN()-COLUMN(B11),ROW()-ROW(B11)))","v":""},{"$f":"SkoreRevers(INDEX(C12:H17,COLUMN()-COLUMN(B11),ROW()-ROW(B11)))","v":""},">XXX<",0,0,"0 : 0"]
[]
[]
[null,"TABULKA SOUTĚŽE SKUPINA 3",{"$f":"B21","v":0},{"$f":"B22","v":0},{"$f":"B23","v":0},{"$f":"B24","v":0},{"$f":"B25","v":0},{"$f":"B26","v":0},"Zápasy","Výhry","Skóre","Prac. pořadí"]
[null,null,">XXX<",null,null,null,null,null,{"$f":"Hry(C21:H21)","v":0},{"$f":"Vyhry(C21:H21)","v":0},{"$f":"SkoreCelkem(C21:H21)","v":"0 : 0"},2]
[null,null,{"$f":"SkoreRevers(INDEX(C21:H26,COLUMN()-COLUMN(B20),ROW()-ROW(B20)))","v":""},">XXX<",null,null,null,null,{"$f":"Hry(C22:H22)","v":0},{"$f":"Vyhry(C22:H22)","v":0},{"$f":"SkoreCelkem(C22:H22)","v":"0 : 0"},1]
[null,null,{"$f":"SkoreRevers(INDEX(C21:H26,COLUMN()-COLUMN(B20),ROW()-ROW(B20)))","v":""},{"$f":"SkoreRevers(INDEX(C21:H26,COLUMN()-COLUMN(B20),ROW()-ROW(B20)))","v":""},">XXX<",null,null,null,0,0,"0 : 0",2]
[null,null,{"$f":"SkoreRevers(INDEX(C21:H26,COLUMN()-COLUMN(B20),ROW()-ROW(B20)))","v":""},{"$f":"SkoreRevers(INDEX(C21:H26,COLUMN()-COLUMN(B20),ROW()-ROW(B20)))","v":""},{"$f":"SkoreRevers(INDEX(C21:H26,COLUMN()-COLUMN(B20),ROW()-ROW(B20)))","v":""},">XXX<",null,null,0,0,"0 : 0",2]
[null,null,{"$f":"SkoreRevers(INDEX(C21:H26,COLUMN()-COLUMN(B20),ROW()-ROW(B20)))","v":""},{"$f":"SkoreRevers(INDEX(C21:H26,COLUMN()-COLUMN(B20),ROW()-ROW(B20)))","v":""},{"$f":"SkoreRevers(INDEX(C21:H26,COLUMN()-COLUMN(B20),ROW()-ROW(B20)))","v":""},{"$f":"SkoreRevers(INDEX(C21:H26,COLUMN()-COLUMN(B20),ROW()-ROW(B20)))","v":""},">XXX<",null,0,0,"0 : 0",2]
[null,null,{"$f":"SkoreRevers(INDEX(C21:H26,COLUMN()-COLUMN(B20),ROW()-ROW(B20)))","v":""},{"$f":"SkoreRevers(INDEX(C21:H26,COLUMN()-COLUMN(B20),ROW()-ROW(B20)))","v":""},{"$f":"SkoreRevers(INDEX(C21:H26,COLUMN()-COLUMN(B20),ROW()-ROW(B20)))","v":""},{"$f":"SkoreRevers(INDEX(C21:H26,COLUMN()-COLUMN(B20),ROW()-ROW(B20)))","v":""},{"$f":"SkoreRevers(INDEX(C21:H26,COLUMN()-COLUMN(B20),ROW()-ROW(B20)))","v":""},">XXX<",0,0,"0 : 0",2]
[]
[]
[null,"TABULKA SOUTĚŽE",{"$f":"B30","v":"h-1"},{"$f":"B31","v":"h-2"},{"$f":"B32","v":"h-3"},{"$f":"B33","v":"h-4"},"Zápasy","Výhry","Skóre","Def. pořadí"]
[null,"h-1",">XXX<","1:0","1:0","1:0",{"$f":"Hry(C30:F30)","v":3},{"$f":"Vyhry(C30:F30)","v":3},{"$f":"SkoreCelkem(C30:F30)","v":"3 : 0"},1]
[null,"h-2",{"$f":"SkoreRevers(INDEX(C30:F33,COLUMN()-COLUMN(B29),ROW()-ROW(B29)))","v":"0:1"},">XXX<","1:0","0:1",{"$f":"Hry(C31:F31)","v":3},{"$f":"Vyhry(C31:F31)","v":1},{"$f":"SkoreCelkem(C31:F31)","v":"1 : 2"},"2÷4"]
[null,"h-3",{"$f":"SkoreRevers(INDEX(C30:F33,COLUMN()-COLUMN(B29),ROW()-ROW(B29)))","v":"0:1"},{"$f":"SkoreRevers(INDEX(C30:F33,COLUMN()-COLUMN(B29),ROW()-ROW(B29)))","v":"0:1"},">XXX<","1:0",3,1,"1 : 2","2÷4"]
[null,"h-4",{"$f":"SkoreRevers(INDEX(C30:F33,COLUMN()-COLUMN(B29),ROW()-ROW(B29)))","v":"0:1"},{"$f":"SkoreRevers(INDEX(C30:F33,COLUMN()-COLUMN(B29),ROW()-ROW(B29)))","v":"1:0"},{"$f":"SkoreRevers(INDEX(C30:F33,COLUMN()-COLUMN(B29),ROW()-ROW(B29)))","v":"0:1"},">XXX<",3,1,"1 : 2","2÷4"]
[]
[]
[null,"TABULKA SOUTĚŽE",{"$f":"B37","v":"h-1"},{"$f":"B38","v":"h-2"},{"$f":"B39","v":"h-3"},{"$f":"B40","v":"h-4"},{"$f":"B41","v":"h-5"},"Zápasy","Výhry","Skóre","Def. pořadí"]
[null,"h-1",">XXX<","3:1","3:0","1:3","0:3",{"$f":"Hry(C37:G37)","v":4},{"$f":"Vyhry(C37:G37)","v":2},{"$f":"SkoreCelkem(C37:G37)","v":"7 : 7"},"2÷4"]
[null,"h-2",{"$f":"SkoreRevers(INDEX(C37:G41,COLUMN()-COLUMN(B36),ROW()-ROW(B36)))","v":"1:3"},">XXX<","1:3","1:3","1:3",{"$f":"Hry(C38:G38)","v":4},{"$f":"Vyhry(C38:G38)","v":0},{"$f":"SkoreCelkem(C38:G38)","v":"4 : 12"},5]
[null,"h-3",{"$f":"SkoreRevers(INDEX(C37:G41,COLUMN()-COLUMN(B36),ROW()-ROW(B36)))","v":"0:3"},{"$f":"SkoreRevers(INDEX(C37:G41,COLUMN()-COLUMN(B36),ROW()-ROW(B36)))","v":"3:1"},">XXX<","1:3","3:0",4,2,"7 : 7","2÷4"]
[null,"h-4",{"$f":"SkoreRevers(INDEX(C37:G41,COLUMN()-COLUMN(B36),ROW()-ROW(B36)))","v":"3:1"},{"$f":"SkoreRevers(INDEX(C37:G41,COLUMN()-COLUMN(B36),ROW()-ROW(B36)))","v":"3:1"},{"$f":"SkoreRevers(INDEX(C37:G41,COLUMN()-COLUMN(B36),ROW()-ROW(B36)))","v":"3:1"},">XXX<","3:1",4,4,"12 : 4",1]
[null,"h-5",{"$f":"SkoreRevers(INDEX(C37:G41,COLUMN()-COLUMN(B36),ROW()-ROW(B36)))","v":"3:0"},{"$f":"SkoreRevers(INDEX(C37:G41,COLUMN()-COLUMN(B36),ROW()-ROW(B36)))","v":"3:1"},{"$f":"SkoreRevers(INDEX(C37:G41,COLUMN()-COLUMN(B36),ROW()-ROW(B36)))","v":"0:3"},{"$f":"SkoreRevers(INDEX(C37:G41,COLUMN()-COLUMN(B36),ROW()-ROW(B36)))","v":"1:3"},">XXX<",4,2,"7 : 7","2÷4"]

{"sheet":"Prac","index":2,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[null,"TABULKA SOUTĚŽE","h-4","h-1","h-3","h-5","h-2","KRIT."]
[null,"h-4",">XXX<",2,2,2,2,5,1,1,{"$f":"IF(I3=J3,I3,\"!\")","v":1}]
[null,"h-1",-2,">XXX<",3,-3,2,4,2,4,"2÷4"]
[null,"h-3",-2,-3,">XXX<",3,2,4,2,4,"2÷4"]
[null,"h-5",-2,3,-3,">XXX<",2,4,2,4,"2÷4"]
[null,"h-2",-2,-2,-2,-2,">XXX<",1,5,5,5]
[null,"KRIT.",5,4,4,4,1]
[]
[]
[null,null,"h-1","h-3","h-5","K-4","Pořadí"]
[null,"h-1",">XXX<",3,-3,0,2]
[null,"h-3",-3,">XXX<",3,0,2]
[null,"h-5",3,-3,">XXX<",0,2]