{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Úvodní list","Strom kritérií","Kriteriální matice","Saatyho metoda","Transformované matice","Metoda TOPSIS"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Úvodní list","index":0,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,1,4,10],[6,1,8,10],[10,1,16,10],[26,1,26,3]]}
[]
[null,"Navrhování a rozhodování o typu protihlukových stěn u dopravních staveb"]
[]
[]
[]
[]
[null,"Příloha č.4 - Tabulky pro vyhodnocování příkladové situace - \"Návrh protihlukové stěny v České Lípě\""]
[]
[]
[]
[null,"V této elektronické příloze mé bakalářské práce prezentuji tabulkové nástroje použité pro řešení příkladové úlohy použití vícekriteriálního rozhodování v kapitole 6. Jsou tedy předvyplněné zadanými daty pro možnost vhledu do provedených rozhodnutí a výpočtů. Podrobné popisy použitých metod a fungování těchto tabulek lze nalézt v kapitole 4 hlavní práce nebo v přílohách č.1 a 2. V tomto sešitu jsou použité stejné mustrové tabulky jako v předchozích přílohách. Tabulky také velmi dobře fungují jako podklad pro vypočítání libovolné jiné podobné úlohy s využitím kritérií a metod prezentovaných v hlavní práci."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Obsah:"]
[null,"Strom kritérií"]
[null,"Kritériální matice"]
[null,"Saatyho metoda"]
[null,"Transformované matice"]
[null,"Metoda TOPSIS"]

{"sheet":"Strom kritérií","index":1,"n_rows":53,"n_cols":14,"rows_kept":53,"cut":false,"hidden":false,"merged":[[14,1,14,4],[14,7,14,10],[1,1,3,10],[7,1,8,4],[7,7,8,10],[11,1,12,4],[11,7,12,10],[32,1,32,4],[16,1,16,4],[16,7,16,10],[19,1,20,4],[19,7,20,10],[22,1,22,4],[22,7,22,10],[24,1,24,4],[25,7,26,10],[26,1,26,4],[28,7,28,10],[29,1,30,4],[37,7,38,10],[41,1,42,4],[41,7,42,10],[44,1,44,4],[44,7,44,10],[46,1,46,4],[49,1,50,4],[52,1,52,4],[34,1,34,4],[37,1,38,4]]}
[]
[null,"Kritéria pro rozhodování o typu protihlukové stěny",null,null,null,null,null,null,null,null,null,null,null,"<- zpět na Úvodní list"]
[]
[]
[]
[]
[]
[null,"Kritéria technická",null,null,null,null,null,"Kritéria ekonomická"]
[]
[]
[]
[null,"Akustická kritéria",null,null,null,null,null,"Montážní kritéria"]
[]
[]
[null,"Zvuková pohltivost",null,null,null,null,null,"Hmotnost dílce"]
[]
[null,"Vzduchová neprůzvučnost",null,null,null,null,null,"Obtížnost montáže"]
[]
[]
[null,"Bezpečnostní kritéria",null,null,null,null,null,"Záruková kritéria"]
[]
[]
[null,"Max. kolmé zatížení",null,null,null,null,null,"Délka záruky"]
[]
[null,"Max. dynamické zatížení"]
[null,null,null,null,null,null,null,"Cenová kritéria"]
[null,"Ostatní bezpečnostní hlediska"]
[]
[null,null,null,null,null,null,null,"Náklady na výstavbu"]
[null,"Rozměrová kritéria"]
[]
[]
[null,"Mezní rozměry stěny"]
[]
[null,"Počet rozměrových variant"]
[]
[]
[null,"Kritéria udržitelnosti",null,null,null,null,null,"Kritéria estetiky"]
[]
[]
[]
[null,"Trvanlivostní kritéria",null,null,null,null,null,"Estetická kritéria"]
[]
[]
[null,"Akustická trvanlivost",null,null,null,null,null,"Vhodnost do prostředí"]
[]
[null,"Celková životnost"]
[]
[]
[null," Kritéria životního prostředí"]
[]
[]
[null,"Hlediska životního prostředí"]

{"sheet":"Kriteriální matice","index":2,"n_rows":38,"n_cols":17,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,1,2,6],[1,8,1,10],[22,2,22,5],[22,6,22,7],[22,8,22,9],[23,2,23,5],[23,6,23,7],[23,8,23,9],[24,2,24,5],[24,6,24,7],[24,8,24,9],[25,2,25,5],[25,6,25,7],[25,8,25,9],[26,2,26,5],[26,6,26,7],[26,8,26,9],[27,2,27,5],[27,6,27,7],[27,8,27,9],[28,2,28,5],[28,6,28,7],[28,8,28,9],[29,2,29,5],[29,6,29,7],[29,8,29,9],[30,2,30,5],[30,6,30,7],[30,8,30,9],[31,2,31,5],[31,6,31,7],[31,8,31,9],[32,2,32,5],[32,6,32,7],[32,8,32,9],[33,2,33,5],[33,6,33,7],[33,8,33,9],[34,2,34,5],[34,6,34,7],[34,8,34,9],[37,2,37,5],[37,6,37,7],[37,8,37,9],[35,2,35,5],[35,6,35,7],[35,8,35,9],[36,2,36,5],[36,6,36,7],[36,8,36,9],[27,12,27,17],[37,12,37,17],[36,12,36,17],[35,12,35,17],[34,12,34,17],[33,12,33,17],[32,12,32,17],[31,12,31,17],[30,12,30,17],[29,12,29,17],[28,12,28,17],[26,12,26,17],[25,12,25,17],[24,12,24,17],[23,12,23,17],[22,12,22,17]]}
[]
[null,"Kriteriální matice",null,null,null,null,null,null,"<- zpět na úvodní list"]
[]
[]
[null,"---","K1","K2","K3","K4","K5","K6","K7","K8","K9","K10","K11","K12","K13","K14","K15"]
[null,"V1",0,26,1.96,3.5,2.5,3,5,20,2.5,5,3300,35,35,2.5,4]
[null,"V2",0,30,{"$f":"E6*0.8","v":1.5680000000000001},{"$f":"F6*0.8","v":2.8000000000000003},3.5,3.5,2,25,4,5,2950,25,25,4,4]
[null,"V3",12,27,1.68,7.8,3,5,10,54,4,10,4000,25,25,4,4.5]
[null,"V4",9,25,1.85,5.3,4,4,10,36,2.5,5,5300,25,25,3.5,3]
[null,"V5",9,45,3.9,20,4.5,5,10,200,2,5,3500,35,35,4,2]
[null,"V6",0,21,3.16,15,3,5,6,25,3,5,2200,30,30,3.5,2.5]
[null,"V7",5,28,{"$f":"3.9*0.8","v":3.12},{"$f":"20*0.8","v":16},3,8,1,200,4,5,{"$f":"2700*0.75","v":2025},50,50,4,4]
[null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[]
[null,"Tabulka kritérií:",null,null,null,null,null,null,null,null,null,"Tabulka variant:"]
[null,"Ozn.","Popis",null,null,null,"Charakteristika",null,"Měrná jednotka",null,null,"Ozn.","Popis"]
[null,"K1","Zvuková pohltivost",null,null,null,"max",null,"dB",null,null,"V1","Transparentní stěna na hliníkovém soklu"]
[null,"K2","Vzduchová neprůzvučnost",null,null,null,"max",null,"dB",null,null,"V2","Transparentní stěna na železobetonovém soklu"]
[null,"K3","Maximální kolmé zatížení",null,null,null,"max",null,"kN/m2",null,null,"V3","Stěna z recyklovaného plastu"]
[null,"K4","Maximální dynamické zatížení",null,null,null,"max",null,"kNm",null,null,"V4","Stěna z dřevocementu na železobetonovém soklu"]
[null,"K5","Ostatní bezpečnostní hlediska",null,null,null,"max",null,"stupnice 1-5",null,null,"V5","Stěna z betonových panelů na železobetonovém soklu"]
[null,"K6","Mezní rozměry stěny",null,null,null,"max",null,"stupnice 0-10",null,null,"V6","Stěna z hliníkových panelů na železobetonovém soklu"]
[null,"K7","Počet rozměrových variant",null,null,null,"max",null,"počet typů",null,null,"V7","Stěna z gabionů"]
[null,"K8","Hmotnost dílce",null,null,null,"min",null,"kg/m2"]
[null,"K9","Obtížnost montáže",null,null,null,"min",null,"stupnice 1-5"]
[null,"K10","Délka záruky",null,null,null,"max",null,"roky"]
[null,"K11","Náklady na výstavbu",null,null,null,"min",null,"Kč/m2"]
[null,"K12","Akustická trvanlivost",null,null,null,"max",null,"roky"]
[null,"K13","Celková životnost",null,null,null,"max",null,"roky"]
[null,"K14","Hlediska životního prostředí",null,null,null,"max",null,"stupnice 1-5"]
[null,"K15","Vhodnost do prostředí",null,null,null,"max",null,"stupnice 1-5"]

{"sheet":"Saatyho metoda","index":3,"n_rows":41,"n_cols":17,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,1,2,7],[4,1,4,2],[24,1,24,3],[1,9,1,10]]}
[]
[null,"Saatyho matice + geometrický průměr",null,null,null,null,null,null,null,"<- zpět na Úvodní list"]
[]
[]
[null,"Saatyho matice"]
[null,"---","K1","K2","K3","K4","K5","K6","K7","K8","K9","K10","K11","K12","K13","K14","K15"]
[null,"K1",1,{"$f":"1/7","v":0.14285714285714285},1,1,{"$f":"1/3","v":0.33333333333333331},{"$f":"1/4","v":0.25},{"$f":"1/3","v":0.33333333333333331},{"$f":"1","v":1},{"$f":"1/2","v":0.5},3,{"$f":"1/3","v":0.33333333333333331},{"$f":"1/4","v":0.25},{"$f":"1/5","v":0.2},{"$f":"1/5","v":0.2},{"$f":"1/8","v":0.125}]
[null,"K2",{"$f":"1/D7","v":7},1,5,4,3,2,3,7,6,8,4,2,2,1,1]
[null,"K3",{"$f":"1/E7","v":1},{"$f":"1/E8","v":0.2},1,1,{"$f":"1/2","v":0.5},{"$f":"1/3","v":0.33333333333333331},{"$f":"1/3","v":0.33333333333333331},3,2,6,{"$f":"1/2","v":0.5},{"$f":"1/2","v":0.5},{"$f":"1/3","v":0.33333333333333331},{"$f":"1/3","v":0.33333333333333331},{"$f":"1/4","v":0.25}]
[null,"K4",{"$f":"1/F7","v":1},{"$f":"1/F8","v":0.25},{"$f":"1/F9","v":1},1,1,{"$f":"1/3","v":0.33333333333333331},{"$f":"1/2","v":0.5},3,2,5,{"$f":"1/3","v":0.33333333333333331},{"$f":"1/2","v":0.5},{"$f":"1/3","v":0.33333333333333331},{"$f":"1/3","v":0.33333333333333331},{"$f":"1/5","v":0.2}]
[null,"K5",{"$f":"1/G7","v":3},{"$f":"1/G8","v":0.33333333333333331},{"$f":"1/G9","v":2},{"$f":"1/G10","v":1},1,{"$f":"1","v":1},{"$f":"1/2","v":0.5},4,4,7,2,2,{"$f":"1/2","v":0.5},{"$f":"1","v":1},{"$f":"2","v":2}]
[null,"K6",{"$f":"1/H7","v":4},{"$f":"1/H8","v":0.5},{"$f":"1/H9","v":3},{"$f":"1/H10","v":3},{"$f":"1/H11","v":1},1,1,{"$f":"4","v":4},{"$f":"2","v":2},{"$f":"7","v":7},{"$f":"1","v":1},{"$f":"1/2","v":0.5},{"$f":"1/3","v":0.33333333333333331},{"$f":"1/4","v":0.25},{"$f":"1/5","v":0.2}]
[null,"K7",{"$f":"1/I7","v":3},{"$f":"1/I8","v":0.33333333333333331},{"$f":"1/I9","v":3},{"$f":"1/I10","v":2},{"$f":"1/I11","v":2},{"$f":"1/I12","v":1},1,{"$f":"1","v":1},{"$f":"1","v":1},5,{"$f":"1/3","v":0.33333333333333331},{"$f":"1/4","v":0.25},{"$f":"1/5","v":0.2},{"$f":"1/6","v":0.16666666666666666},{"$f":"1/7","v":0.14285714285714285}]
[null,"K8",{"$f":"1/J7","v":1},{"$f":"1/J8","v":0.14285714285714285},{"$f":"1/J9","v":0.33333333333333331},{"$f":"1/J10","v":0.33333333333333331},{"$f":"1/J11","v":0.25},{"$f":"1/J12","v":0.25},{"$f":"1/J13","v":1},1,{"$f":"1/2","v":0.5},{"$f":"3","v":3},{"$f":"1/2","v":0.5},{"$f":"1/4","v":0.25},{"$f":"1/4","v":0.25},{"$f":"1/3","v":0.33333333333333331},{"$f":"1/6","v":0.16666666666666666}]
[null,"K9",{"$f":"1/K7","v":2},{"$f":"1/K8","v":0.16666666666666666},{"$f":"1/K9","v":0.5},{"$f":"1/K10","v":0.5},{"$f":"1/K11","v":0.25},{"$f":"1/K12","v":0.5},{"$f":"1/K13","v":1},{"$f":"1/K14","v":2},1,{"$f":"5","v":5},1,{"$f":"1/3","v":0.33333333333333331},{"$f":"1/5","v":0.2},{"$f":"1/3","v":0.33333333333333331},{"$f":"1/3","v":0.33333333333333331}]
[null,"K10",{"$f":"1/L7","v":0.33333333333333331},{"$f":"1/L8","v":0.125},{"$f":"1/L9","v":0.16666666666666666},{"$f":"1/L10","v":0.2},{"$f":"1/L11","v":0.14285714285714285},{"$f":"1/L12","v":0.14285714285714285},{"$f":"1/L13","v":0.2},{"$f":"1/L14","v":0.33333333333333331},{"$f":"1/L15","v":0.2},1,{"$f":"1/3","v":0.33333333333333331},{"$f":"1/5","v":0.2},{"$f":"1/5","v":0.2},{"$f":"1/7","v":0.14285714285714285},{"$f":"1/8","v":0.125}]
[null,"K11",{"$f":"1/M7","v":3},{"$f":"1/M8","v":0.25},{"$f":"1/M9","v":2},{"$f":"1/M10","v":3},{"$f":"1/M11","v":0.5},{"$f":"1/M12","v":1},{"$f":"1/M13","v":3},{"$f":"1/M14","v":2},{"$f":"1/M15","v":1},{"$f":"1/M16","v":3},1,{"$f":"1","v":1},{"$f":"1/2","v":0.5},{"$f":"1/3","v":0.33333333333333331},{"$f":"1/5","v":0.2}]
[null,"K12",{"$f":"1/N7","v":4},{"$f":"1/N8","v":0.5},{"$f":"1/N9","v":2},{"$f":"1/N10","v":2},{"$f":"1/N11","v":0.5},{"$f":"1/N12","v":2},{"$f":"1/N13","v":4},{"$f":"1/N14","v":4},{"$f":"1/N15","v":3},{"$f":"1/N16","v":5},{"$f":"1/N17","v":1},1,{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1/2","v":0.5}]
[null,"K13",{"$f":"1/O7","v":5},{"$f":"1/O8","v":0.5},{"$f":"1/O9","v":3},{"$f":"1/O10","v":3},{"$f":"1/O11","v":2},{"$f":"1/O12","v":3},{"$f":"1/O13","v":5},{"$f":"1/O14","v":4},{"$f":"1/O15","v":5},{"$f":"1/O16","v":5},{"$f":"1/O17","v":2},{"$f":"1/O18","v":1},1,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,"K14",{"$f":"1/P7","v":5},{"$f":"1/P8","v":1},{"$f":"1/P9","v":3},{"$f":"1/P10","v":3},{"$f":"1/P11","v":1},{"$f":"1/P12","v":4},{"$f":"1/P13","v":6},{"$f":"1/P14","v":3},{"$f":"1/P15","v":3},{"$f":"1/P16","v":7},{"$f":"1/P17","v":3},{"$f":"1/P18","v":1},{"$f":"1/P19","v":1},1,{"$f":"3","v":3}]
[null,"K15",{"$f":"1/Q7","v":8},{"$f":"1/Q8","v":1},{"$f":"1/Q9","v":4},{"$f":"1/Q10","v":5},{"$f":"1/Q11","v":0.5},{"$f":"1/Q12","v":5},{"$f":"1/Q13","v":7},{"$f":"1/Q14","v":6},{"$f":"1/Q15","v":3},{"$f":"1/Q16","v":8},{"$f":"1/Q17","v":5},{"$f":"1/Q18","v":2},{"$f":"1/Q19","v":1},{"$f":"1/Q20","v":0.33333333333333331},1]
[]
[]
[]
[null,"Výpočet vah pomocí geometrického průměru",null,null,null,"Počet kritérií:",null,{"$f":"COUNTIF($C$7:$Q$7,\"<10\")","v":15}]
[null,"Kritérium","Geom. průměr","Normovaná váha"]
[null,"K1",{"$f":"PRODUCT(7:7)^(1/$H$25)","v":0.4229593517461957},{"$f":"Tabulka1434[[#This Row],[Geom. průměr]]/SUM($C$27:$C$41)","v":2.1949293645643648E-2}]
[null,"K2",{"$f":"PRODUCT(8:8)^(1/$H$25)","v":2.9885279373210922},{"$f":"Tabulka1434[[#This Row],[Geom. průměr]]/SUM($C$27:$C$41)","v":0.15508837195266098}]
[null,"K3",0.67542920195596279,{"$f":"Tabulka1434[[#This Row],[Geom. průměr]]/SUM($C$27:$C$41)","v":3.5051107935947227E-2}]
[null,"K4",0.69882711877157921,{"$f":"Tabulka1434[[#This Row],[Geom. průměr]]/SUM($C$27:$C$41)","v":3.6265332765737686E-2}]
[null,"K5",1.5022833972852192,{"$f":"Tabulka1434[[#This Row],[Geom. průměr]]/SUM($C$27:$C$41)","v":7.7960350775681836E-2}]
[null,"K6",1.1524407835757444,{"$f":"Tabulka1434[[#This Row],[Geom. průměr]]/SUM($C$27:$C$41)","v":5.9805418803219997E-2}]
[null,"K7",0.77944124033385653,{"$f":"Tabulka1434[[#This Row],[Geom. průměr]]/SUM($C$27:$C$41)","v":4.0448767932381814E-2}]
[null,"K8",0.42411198908925168,{"$f":"Tabulka1434[[#This Row],[Geom. průměr]]/SUM($C$27:$C$41)","v":2.2009109264816556E-2}]
[null,"K9",0.62014464787639112,{"$f":"Tabulka1434[[#This Row],[Geom. průměr]]/SUM($C$27:$C$41)","v":3.2182139779666476E-2}]
[null,"K10",0.21393280786648775,{"$f":"Tabulka1434[[#This Row],[Geom. průměr]]/SUM($C$27:$C$41)","v":1.1101951052535955E-2}]
[null,"K11",1.0202084537420899,{"$f":"Tabulka1434[[#This Row],[Geom. průměr]]/SUM($C$27:$C$41)","v":5.2943278919129838E-2}]
[null,"K12",1.5805858228856651,{"$f":"Tabulka1434[[#This Row],[Geom. průměr]]/SUM($C$27:$C$41)","v":8.202382147463845E-2}]
[null,"K13",2.1979724838057471,{"$f":"Tabulka1434[[#This Row],[Geom. průměr]]/SUM($C$27:$C$41)","v":0.11406283670740708}]
[null,"K14",2.4310867386284474,{"$f":"Tabulka1434[[#This Row],[Geom. průměr]]/SUM($C$27:$C$41)","v":0.12616020069986755}]
[null,"K15",2.5618868898462965,{"$f":"Tabulka1434[[#This Row],[Geom. průměr]]/SUM($C$27:$C$41)","v":0.1329480182906651}]

{"sheet":"Transformované matice","index":4,"n_rows":65,"n_cols":17,"rows_kept":65,"cut":false,"hidden":false,"merged":[[1,1,2,6],[1,8,1,10],[4,1,4,3],[26,1,26,3],[47,1,47,3]]}
[]
[null,"Transformované matice",null,null,null,null,null,null,"<- zpět na úvodní list"]
[]
[]
[null,"Maximalizační matice"]
[null,"---","K1","K2","K3","K4","K5","K6","K7","K8","K9","K10","K11","K12","K13","K14","K15"]
[null,"V1",{"$f":"'Kriteriální matice'!C6","v":0},{"$f":"'Kriteriální matice'!D6","v":26},{"$f":"'Kriteriální matice'!E6","v":1.96},{"$f":"'Kriteriální matice'!F6","v":3.5},{"$f":"'Kriteriální matice'!G6","v":2.5},{"$f":"'Kriteriální matice'!H6","v":3},{"$f":"'Kriteriální matice'!I6","v":5},{"$f":"$J$22-'Kriteriální matice'!J6","v":180},{"$f":"'Kriteriální matice'!K6","v":2.5},{"$f":"'Kriteriální matice'!L6","v":5},{"$f":"$M$22-'Kriteriální matice'!M6","v":2000},{"$f":"'Kriteriální matice'!N6","v":35},{"$f":"'Kriteriální matice'!O6","v":35},{"$f":"'Kriteriální matice'!P6","v":2.5},{"$f":"'Kriteriální matice'!Q6","v":4}]
[null,"V2",{"$f":"'Kriteriální matice'!C7","v":0},{"$f":"'Kriteriální matice'!D7","v":30},{"$f":"'Kriteriální matice'!E7","v":1.5680000000000001},{"$f":"'Kriteriální matice'!F7","v":2.8000000000000003},{"$f":"'Kriteriální matice'!G7","v":3.5},{"$f":"'Kriteriální matice'!H7","v":3.5},{"$f":"'Kriteriální matice'!I7","v":2},{"$f":"$J$22-'Kriteriální matice'!J7","v":175},{"$f":"'Kriteriální matice'!K7","v":4},{"$f":"'Kriteriální matice'!L7","v":5},{"$f":"$M$22-'Kriteriální matice'!M7","v":2350},{"$f":"'Kriteriální matice'!N7","v":25},{"$f":"'Kriteriální matice'!O7","v":25},{"$f":"'Kriteriální matice'!P7","v":4},{"$f":"'Kriteriální matice'!Q7","v":4}]
[null,"V3",{"$f":"'Kriteriální matice'!C8","v":12},{"$f":"'Kriteriální matice'!D8","v":27},{"$f":"'Kriteriální matice'!E8","v":1.68},{"$f":"'Kriteriální matice'!F8","v":7.8},{"$f":"'Kriteriální matice'!G8","v":3},{"$f":"'Kriteriální matice'!H8","v":5},{"$f":"'Kriteriální matice'!I8","v":10},{"$f":"$J$22-'Kriteriální matice'!J8","v":146},{"$f":"'Kriteriální matice'!K8","v":4},{"$f":"'Kriteriální matice'!L8","v":10},{"$f":"$M$22-'Kriteriální matice'!M8","v":1300},{"$f":"'Kriteriální matice'!N8","v":25},{"$f":"'Kriteriální matice'!O8","v":25},{"$f":"'Kriteriální matice'!P8","v":4},{"$f":"'Kriteriální matice'!Q8","v":4.5}]
[null,"V4",{"$f":"'Kriteriální matice'!C9","v":9},{"$f":"'Kriteriální matice'!D9","v":25},{"$f":"'Kriteriální matice'!E9","v":1.85},{"$f":"'Kriteriální matice'!F9","v":5.3},{"$f":"'Kriteriální matice'!G9","v":4},{"$f":"'Kriteriální matice'!H9","v":4},{"$f":"'Kriteriální matice'!I9","v":10},{"$f":"$J$22-'Kriteriální matice'!J9","v":164},{"$f":"'Kriteriální matice'!K9","v":2.5},{"$f":"'Kriteriální matice'!L9","v":5},{"$f":"$M$22-'Kriteriální matice'!M9","v":0},{"$f":"'Kriteriální matice'!N9","v":25},{"$f":"'Kriteriální matice'!O9","v":25},{"$f":"'Kriteriální matice'!P9","v":3.5},{"$f":"'Kriteriální matice'!Q9","v":3}]
[null,"V5",{"$f":"'Kriteriální matice'!C10","v":9},{"$f":"'Kriteriální matice'!D10","v":45},{"$f":"'Kriteriální matice'!E10","v":3.9},{"$f":"'Kriteriální matice'!F10","v":20},{"$f":"'Kriteriální matice'!G10","v":4.5},{"$f":"'Kriteriální matice'!H10","v":5},{"$f":"'Kriteriální matice'!I10","v":10},{"$f":"$J$22-'Kriteriální matice'!J10","v":0},{"$f":"'Kriteriální matice'!K10","v":2},{"$f":"'Kriteriální matice'!L10","v":5},{"$f":"$M$22-'Kriteriální matice'!M10","v":1800},{"$f":"'Kriteriální matice'!N10","v":35},{"$f":"'Kriteriální matice'!O10","v":35},{"$f":"'Kriteriální matice'!P10","v":4},{"$f":"'Kriteriální matice'!Q10","v":2}]
[null,"V6",{"$f":"'Kriteriální matice'!C11","v":0},{"$f":"'Kriteriální matice'!D11","v":21},{"$f":"'Kriteriální matice'!E11","v":3.16},{"$f":"'Kriteriální matice'!F11","v":15},{"$f":"'Kriteriální matice'!G11","v":3},{"$f":"'Kriteriální matice'!H11","v":5},{"$f":"'Kriteriální matice'!I11","v":6},{"$f":"$J$22-'Kriteriální matice'!J11","v":175},{"$f":"'Kriteriální matice'!K11","v":3},{"$f":"'Kriteriální matice'!L11","v":5},{"$f":"$M$22-'Kriteriální matice'!M11","v":3100},{"$f":"'Kriteriální matice'!N11","v":30},{"$f":"'Kriteriální matice'!O11","v":30},{"$f":"'Kriteriální matice'!P11","v":3.5},{"$f":"'Kriteriální matice'!Q11","v":2.5}]
[null,"V7",{"$f":"'Kriteriální matice'!C12","v":5},{"$f":"'Kriteriální matice'!D12","v":28},{"$f":"'Kriteriální matice'!E12","v":3.12},{"$f":"'Kriteriální matice'!F12","v":16},{"$f":"'Kriteriální matice'!G12","v":3},{"$f":"'Kriteriální matice'!H12","v":8},{"$f":"'Kriteriální matice'!I12","v":1},{"$f":"$J$22-'Kriteriální matice'!J12","v":0},{"$f":"'Kriteriální matice'!K12","v":4},{"$f":"'Kriteriální matice'!L12","v":5},{"$f":"$M$22-'Kriteriální matice'!M12","v":3275},{"$f":"'Kriteriální matice'!N12","v":50},{"$f":"'Kriteriální matice'!O12","v":50},{"$f":"'Kriteriální matice'!P12","v":4},{"$f":"'Kriteriální matice'!Q12","v":4}]
[null,null,{"$f":"'Kriteriální matice'!C13","v":"x"},{"$f":"'Kriteriální matice'!D13","v":"x"},{"$f":"'Kriteriální matice'!E13","v":"x"},{"$f":"'Kriteriální matice'!F13","v":"x"},{"$f":"'Kriteriální matice'!G13","v":"x"},{"$f":"'Kriteriální matice'!H13","v":"x"},{"$f":"'Kriteriální matice'!I13","v":"x"},{"$f":"'Kriteriální matice'!J13","v":"x"},{"$f":"'Kriteriální matice'!K13","v":"x"},{"$f":"'Kriteriální matice'!L13","v":"x"},{"$f":"'Kriteriální matice'!M13","v":"x"},{"$f":"'Kriteriální matice'!N13","v":"x"},{"$f":"'Kriteriální matice'!O13","v":"x"},{"$f":"'Kriteriální matice'!P13","v":"x"},{"$f":"'Kriteriální matice'!Q13","v":"x"}]
[null,null,{"$f":"'Kriteriální matice'!C14","v":"x"},{"$f":"'Kriteriální matice'!D14","v":"x"},{"$f":"'Kriteriální matice'!E14","v":"x"},{"$f":"'Kriteriální matice'!F14","v":"x"},{"$f":"'Kriteriální matice'!G14","v":"x"},{"$f":"'Kriteriální matice'!H14","v":"x"},{"$f":"'Kriteriální matice'!I14","v":"x"},{"$f":"'Kriteriální matice'!J14","v":"x"},{"$f":"'Kriteriální matice'!K14","v":"x"},{"$f":"'Kriteriální matice'!L14","v":"x"},{"$f":"'Kriteriální matice'!M14","v":"x"},{"$f":"'Kriteriální matice'!N14","v":"x"},{"$f":"'Kriteriální matice'!O14","v":"x"},{"$f":"'Kriteriální matice'!P14","v":"x"},{"$f":"'Kriteriální matice'!Q14","v":"x"}]
[null,null,{"$f":"'Kriteriální matice'!C15","v":"x"},{"$f":"'Kriteriální matice'!D15","v":"x"},{"$f":"'Kriteriální matice'!E15","v":"x"},{"$f":"'Kriteriální matice'!F15","v":"x"},{"$f":"'Kriteriální matice'!G15","v":"x"},{"$f":"'Kriteriální matice'!H15","v":"x"},{"$f":"'Kriteriální matice'!I15","v":"x"},{"$f":"'Kriteriální matice'!J15","v":"x"},{"$f":"'Kriteriální matice'!K15","v":"x"},{"$f":"'Kriteriální matice'!L15","v":"x"},{"$f":"'Kriteriální matice'!M15","v":"x"},{"$f":"'Kriteriální matice'!N15","v":"x"},{"$f":"'Kriteriální matice'!O15","v":"x"},{"$f":"'Kriteriální matice'!P15","v":"x"},{"$f":"'Kriteriální matice'!Q15","v":"x"}]
[null,null,{"$f":"'Kriteriální matice'!C16","v":"x"},{"$f":"'Kriteriální matice'!D16","v":"x"},{"$f":"'Kriteriální matice'!E16","v":"x"},{"$f":"'Kriteriální matice'!F16","v":"x"},{"$f":"'Kriteriální matice'!G16","v":"x"},{"$f":"'Kriteriální matice'!H16","v":"x"},{"$f":"'Kriteriální matice'!I16","v":"x"},{"$f":"'Kriteriální matice'!J16","v":"x"},{"$f":"'Kriteriální matice'!K16","v":"x"},{"$f":"'Kriteriální matice'!L16","v":"x"},{"$f":"'Kriteriální matice'!M16","v":"x"},{"$f":"'Kriteriální matice'!N16","v":"x"},{"$f":"'Kriteriální matice'!O16","v":"x"},{"$f":"'Kriteriální matice'!P16","v":"x"},{"$f":"'Kriteriální matice'!Q16","v":"x"}]
[null,null,{"$f":"'Kriteriální matice'!C17","v":"x"},{"$f":"'Kriteriální matice'!D17","v":"x"},{"$f":"'Kriteriální matice'!E17","v":"x"},{"$f":"'Kriteriální matice'!F17","v":"x"},{"$f":"'Kriteriální matice'!G17","v":"x"},{"$f":"'Kriteriální matice'!H17","v":"x"},{"$f":"'Kriteriální matice'!I17","v":"x"},{"$f":"'Kriteriální matice'!J17","v":"x"},{"$f":"'Kriteriální matice'!K17","v":"x"},{"$f":"'Kriteriální matice'!L17","v":"x"},{"$f":"'Kriteriální matice'!M17","v":"x"},{"$f":"'Kriteriální matice'!N17","v":"x"},{"$f":"'Kriteriální matice'!O17","v":"x"},{"$f":"'Kriteriální matice'!P17","v":"x"},{"$f":"'Kriteriální matice'!Q17","v":"x"}]
[null,null,{"$f":"'Kriteriální matice'!C18","v":"x"},{"$f":"'Kriteriální matice'!D18","v":"x"},{"$f":"'Kriteriální matice'!E18","v":"x"},{"$f":"'Kriteriální matice'!F18","v":"x"},{"$f":"'Kriteriální matice'!G18","v":"x"},{"$f":"'Kriteriální matice'!H18","v":"x"},{"$f":"'Kriteriální matice'!I18","v":"x"},{"$f":"'Kriteriální matice'!J18","v":"x"},{"$f":"'Kriteriální matice'!K18","v":"x"},{"$f":"'Kriteriální matice'!L18","v":"x"},{"$f":"'Kriteriální matice'!M18","v":"x"},{"$f":"'Kriteriální matice'!N18","v":"x"},{"$f":"'Kriteriální matice'!O18","v":"x"},{"$f":"'Kriteriální matice'!P18","v":"x"},{"$f":"'Kriteriální matice'!Q18","v":"x"}]
[null,null,{"$f":"'Kriteriální matice'!C19","v":"x"},{"$f":"'Kriteriální matice'!D19","v":"x"},{"$f":"'Kriteriální matice'!E19","v":"x"},{"$f":"'Kriteriální matice'!F19","v":"x"},{"$f":"'Kriteriální matice'!G19","v":"x"},{"$f":"'Kriteriální matice'!H19","v":"x"},{"$f":"'Kriteriální matice'!I19","v":"x"},{"$f":"'Kriteriální matice'!J19","v":"x"},{"$f":"'Kriteriální matice'!K19","v":"x"},{"$f":"'Kriteriální matice'!L19","v":"x"},{"$f":"'Kriteriální matice'!M19","v":"x"},{"$f":"'Kriteriální matice'!N19","v":"x"},{"$f":"'Kriteriální matice'!O19","v":"x"},{"$f":"'Kriteriální matice'!P19","v":"x"},{"$f":"'Kriteriální matice'!Q19","v":"x"}]
[null,null,{"$f":"'Kriteriální matice'!C20","v":"x"},{"$f":"'Kriteriální matice'!D20","v":"x"},{"$f":"'Kriteriální matice'!E20","v":"x"},{"$f":"'Kriteriální matice'!F20","v":"x"},{"$f":"'Kriteriální matice'!G20","v":"x"},{"$f":"'Kriteriální matice'!H20","v":"x"},{"$f":"'Kriteriální matice'!I20","v":"x"},{"$f":"'Kriteriální matice'!J20","v":"x"},{"$f":"'Kriteriální matice'!K20","v":"x"},{"$f":"'Kriteriální matice'!L20","v":"x"},{"$f":"'Kriteriální matice'!M20","v":"x"},{"$f":"'Kriteriální matice'!N20","v":"x"},{"$f":"'Kriteriální matice'!O20","v":"x"},{"$f":"'Kriteriální matice'!P20","v":"x"},{"$f":"'Kriteriální matice'!Q20","v":"x"}]
[null,"Nejvyšší hodnota",null,null,null,null,null,null,null,200,null,null,5300]
[null,"Transformace"]
[null,"Detransformace"]
[]
[]
[null,"Normalizovaná matice pro váž. součet"]
[null,"Nejvyšší hodnota",{"$f":"MAX(C7:C21)","v":12},{"$f":"MAX(D7:D21)","v":45},3.9,20,4.5,8,10,180,4,10,3275,50,50,4,4.5]
[null,"Nejnižší hodnota",{"$f":"MIN(C7:C21)","v":0},{"$f":"MIN(D7:D21)","v":21},1.5680000000000001,2.8000000000000003,2.5,3,1,0,2,5,0,25,25,2.5,2]
[null,"---","k1","k2","k3","k4","k5","k6"]
[null,"v1",{"$f":"(C7-C$29)/(C$28-C$29)","v":0},{"$f":"(D7-D$29)/(D$28-D$29)","v":0.20833333333333334},0.16809605488850768,4.069767441860464E-2,0,0,0.44444444444444442,1,0.25,0,0.61068702290076338,0.4,0.4,0,0.8]
[null,"v2",{"$f":"(C8-C$29)/(C$28-C$29)","v":0},0.375,0,0,0.5,0.1,0.1111111111111111,0.97222222222222221,1,0,0.71755725190839692,0,0,1,0.8]
[null,"v3",1,0.25,4.8027444253859297E-2,0.29069767441860467,0.25,0.4,1,0.81111111111111112,1,1,0.39694656488549618,0,0,1,1]
[null,"v4",0.75,0.16666666666666666,0.12092624356775303,0.14534883720930231,0.75,0.2,1,0.91111111111111109,0.25,0,0,0,0,0.66666666666666663,0.4]
[null,"v5",0.75,1,1,1,1,0.4,1,0,0,0,0.54961832061068705,0.4,0.4,1,0]
[null,"v6",0,0,0.68267581475128658,0.70930232558139539,0.25,0.4,0.55555555555555558,0.97222222222222221,0.5,0,0.94656488549618323,0.2,0.2,0.66666666666666663,0.2]
[null,null,0.41666666666666669,0.29166666666666669,0.66552315608919388,0.76744186046511631,0.25,1,0,0,1,0,1,1,1,1,0.8]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[]
[null,"Normalizovaná matice pro TOPSIS"]
[null,"Jmenovatel",{"$f":"((SUM(C7:C21))^2)^(1/2)","v":35},{"$f":"((SUM(D7:D21))^2)^(1/2)","v":202},17.238,70.400000000000006,23.5,33.5,44,840,22,40,13825,225,225,25.5,24]
[null,"---","k1","k2","k3","k4","k5","k6"]
[null,"v1",{"$f":"(C7/C$49)","v":0},{"$f":"(D7/D$49)","v":0.12871287128712872},0.11370228564798701,4.9715909090909088E-2,0.10638297872340426,8.9552238805970144E-2,0.11363636363636363,0.21428571428571427,0.11363636363636363,0.125,0.14466546112115733,0.15555555555555556,0.15555555555555556,9.8039215686274508E-2,0.16666666666666666]
[null,"v2",{"$f":"(C8/C$49)","v":0},0.14851485148514851,9.0961828518389604E-2,3.9772727272727272E-2,0.14893617021276595,0.1044776119402985,4.5454545454545456E-2,0.20833333333333334,0.18181818181818182,0.125,0.16998191681735986,0.1111111111111111,0.1111111111111111,0.15686274509803921,0.16666666666666666]
[null,"v3",0.34285714285714286,0.13366336633663367,9.7459101983988855E-2,0.11079545454545453,0.1276595744680851,0.14925373134328357,0.22727272727272727,0.1738095238095238,0.18181818181818182,0.25,9.403254972875226E-2,0.1111111111111111,0.1111111111111111,0.15686274509803921,0.1875]
[null,"v4",0.25714285714285712,0.12376237623762376,0.10732103492284488,7.5284090909090898E-2,0.1702127659574468,0.11940298507462686,0.22727272727272727,0.19523809523809524,0.11363636363636363,0.125,0,0.1111111111111111,0.1111111111111111,0.13725490196078433,0.125]
[null,"v5",0.25714285714285712,0.22277227722772278,0.22624434389140272,0.28409090909090906,0.19148936170212766,0.14925373134328357,0.22727272727272727,0,9.0909090909090912E-2,0.125,0.1301989150090416,0.15555555555555556,0.15555555555555556,0.15686274509803921,8.3333333333333329E-2]
[null,"v6",0,0.10396039603960396,0.18331592992226478,0.2130681818181818,0.1276595744680851,0.14925373134328357,0.13636363636363635,0.20833333333333334,0.13636363636363635,0.125,0.22423146473779385,0.13333333333333333,0.13333333333333333,0.13725490196078433,0.10416666666666667]
[null,null,0.14285714285714285,0.13861386138613863,0.1809954751131222,0.22727272727272727,0.1276595744680851,0.23880597014925373,2.2727272727272728E-2,0,0.18181818181818182,0.125,0.23688969258589512,0.22222222222222221,0.22222222222222221,0.15686274509803921,0.16666666666666666]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]

{"sheet":"Metoda TOPSIS","index":5,"n_rows":81,"n_cols":17,"rows_kept":81,"cut":false,"hidden":false,"merged":[[64,1,64,3],[1,1,2,6],[1,8,1,10],[4,1,4,3],[26,1,26,3],[45,1,45,3],[65,2,65,5],[65,6,65,9],[65,10,65,12],[66,2,66,5],[66,6,66,9],[66,10,66,12],[67,2,67,5],[67,6,67,9],[67,10,67,12],[68,2,68,5],[68,6,68,9],[68,10,68,12],[69,2,69,5],[69,6,69,9],[69,10,69,12],[70,2,70,5],[70,6,70,9],[70,10,70,12],[71,2,71,5],[71,6,71,9],[71,10,71,12],[72,2,72,5],[72,6,72,9],[72,10,72,12],[73,2,73,5],[73,6,73,9],[73,10,73,12],[74,2,74,5],[74,6,74,9],[74,10,74,12],[75,2,75,5],[75,6,75,9],[75,10,75,12],[76,2,76,5],[76,6,76,9],[76,10,76,12],[77,2,77,5],[77,6,77,9],[77,10,77,12],[78,2,78,5],[78,6,78,9],[78,10,78,12],[79,2,79,5],[79,6,79,9],[79,10,79,12],[80,2,80,5],[80,6,80,9],[80,10,80,12]]}
[]
[null,"Metoda TOPSIS",null,null,null,null,null,null,"<- zpět na úvodní list"]
[]
[]
[null,"Vážená normalizovaná matice"]
[null,"Váha kritéria",2.1999999999999999E-2,0.155,3.5000000000000003E-2,3.5999999999999997E-2,7.8E-2,0.06,0.04,2.1999999999999999E-2,3.2000000000000001E-2,1.0999999999999999E-2,5.2999999999999999E-2,8.2000000000000003E-2,0.114,0.126,0.13300000000000001]
[null,"---","k1","k2","k3","k4","k5","k6"]
[null,"V1",{"$f":"'Transformované matice'!C51*C$6","v":0},{"$f":"'Transformované matice'!D51*D$6","v":1.9950495049504951E-2},{"$f":"'Transformované matice'!E51*E$6","v":3.9795799976795462E-3},{"$f":"'Transformované matice'!F51*F$6","v":1.7897727272727271E-3},{"$f":"'Transformované matice'!G51*G$6","v":8.2978723404255328E-3},{"$f":"'Transformované matice'!H51*H$6","v":5.3731343283582086E-3},{"$f":"'Transformované matice'!I51*I$6","v":4.5454545454545452E-3},{"$f":"'Transformované matice'!J51*J$6","v":4.7142857142857134E-3},{"$f":"'Transformované matice'!K51*K$6","v":3.6363636363636364E-3},{"$f":"'Transformované matice'!L51*L$6","v":1.3749999999999999E-3},{"$f":"'Transformované matice'!M51*M$6","v":7.6672694394213379E-3},{"$f":"'Transformované matice'!N51*N$6","v":1.2755555555555556E-2},{"$f":"'Transformované matice'!O51*O$6","v":1.7733333333333334E-2},{"$f":"'Transformované matice'!P51*P$6","v":1.2352941176470587E-2},{"$f":"'Transformované matice'!Q51*Q$6","v":2.2166666666666668E-2}]
[null,"V2",{"$f":"'Transformované matice'!C52*C$6","v":0},{"$f":"'Transformované matice'!D52*D$6","v":2.3019801980198019E-2},{"$f":"'Transformované matice'!E52*E$6","v":3.1836639981436365E-3},{"$f":"'Transformované matice'!F52*F$6","v":1.4318181818181817E-3},{"$f":"'Transformované matice'!G52*G$6","v":1.1617021276595745E-2},{"$f":"'Transformované matice'!H52*H$6","v":6.2686567164179103E-3},{"$f":"'Transformované matice'!I52*I$6","v":1.8181818181818182E-3},{"$f":"'Transformované matice'!J52*J$6","v":4.5833333333333334E-3},{"$f":"'Transformované matice'!K52*K$6","v":5.8181818181818187E-3},{"$f":"'Transformované matice'!L52*L$6","v":1.3749999999999999E-3},{"$f":"'Transformované matice'!M52*M$6","v":9.0090415913200717E-3},{"$f":"'Transformované matice'!N52*N$6","v":9.1111111111111115E-3},{"$f":"'Transformované matice'!O52*O$6","v":1.2666666666666666E-2},{"$f":"'Transformované matice'!P52*P$6","v":1.9764705882352941E-2},{"$f":"'Transformované matice'!Q52*Q$6","v":2.2166666666666668E-2}]
[null,"V3",{"$f":"'Transformované matice'!C53*C$6","v":7.5428571428571428E-3},{"$f":"'Transformované matice'!D53*D$6","v":2.0717821782178219E-2},{"$f":"'Transformované matice'!E53*E$6","v":3.4110685694396102E-3},{"$f":"'Transformované matice'!F53*F$6","v":3.9886363636363626E-3},{"$f":"'Transformované matice'!G53*G$6","v":9.9574468085106369E-3},{"$f":"'Transformované matice'!H53*H$6","v":8.9552238805970137E-3},{"$f":"'Transformované matice'!I53*I$6","v":9.0909090909090905E-3},{"$f":"'Transformované matice'!J53*J$6","v":3.8238095238095236E-3},{"$f":"'Transformované matice'!K53*K$6","v":5.8181818181818187E-3},{"$f":"'Transformované matice'!L53*L$6","v":2.7499999999999998E-3},{"$f":"'Transformované matice'!M53*M$6","v":4.9837251356238694E-3},{"$f":"'Transformované matice'!N53*N$6","v":9.1111111111111115E-3},{"$f":"'Transformované matice'!O53*O$6","v":1.2666666666666666E-2},{"$f":"'Transformované matice'!P53*P$6","v":1.9764705882352941E-2},{"$f":"'Transformované matice'!Q53*Q$6","v":2.4937500000000001E-2}]
[null,"V4",{"$f":"'Transformované matice'!C54*C$6","v":5.6571428571428562E-3},{"$f":"'Transformované matice'!D54*D$6","v":1.9183168316831683E-2},{"$f":"'Transformované matice'!E54*E$6","v":3.7562362222995711E-3},{"$f":"'Transformované matice'!F54*F$6","v":2.7102272727272721E-3},{"$f":"'Transformované matice'!G54*G$6","v":1.327659574468085E-2},{"$f":"'Transformované matice'!H54*H$6","v":7.1641791044776111E-3},{"$f":"'Transformované matice'!I54*I$6","v":9.0909090909090905E-3},{"$f":"'Transformované matice'!J54*J$6","v":4.295238095238095E-3},{"$f":"'Transformované matice'!K54*K$6","v":3.6363636363636364E-3},{"$f":"'Transformované matice'!L54*L$6","v":1.3749999999999999E-3},{"$f":"'Transformované matice'!M54*M$6","v":0},{"$f":"'Transformované matice'!N54*N$6","v":9.1111111111111115E-3},{"$f":"'Transformované matice'!O54*O$6","v":1.2666666666666666E-2},{"$f":"'Transformované matice'!P54*P$6","v":1.7294117647058824E-2},{"$f":"'Transformované matice'!Q54*Q$6","v":1.6625000000000001E-2}]
[null,"V5",{"$f":"'Transformované matice'!C55*C$6","v":5.6571428571428562E-3},{"$f":"'Transformované matice'!D55*D$6","v":3.4529702970297033E-2},{"$f":"'Transformované matice'!E55*E$6","v":7.9185520361990964E-3},{"$f":"'Transformované matice'!F55*F$6","v":1.0227272727272725E-2},{"$f":"'Transformované matice'!G55*G$6","v":1.4936170212765958E-2},{"$f":"'Transformované matice'!H55*H$6","v":8.9552238805970137E-3},{"$f":"'Transformované matice'!I55*I$6","v":9.0909090909090905E-3},{"$f":"'Transformované matice'!J55*J$6","v":0},{"$f":"'Transformované matice'!K55*K$6","v":2.9090909090909093E-3},{"$f":"'Transformované matice'!L55*L$6","v":1.3749999999999999E-3},{"$f":"'Transformované matice'!M55*M$6","v":6.9005424954792045E-3},{"$f":"'Transformované matice'!N55*N$6","v":1.2755555555555556E-2},{"$f":"'Transformované matice'!O55*O$6","v":1.7733333333333334E-2},{"$f":"'Transformované matice'!P55*P$6","v":1.9764705882352941E-2},{"$f":"'Transformované matice'!Q55*Q$6","v":1.1083333333333334E-2}]
[null,"V6",{"$f":"'Transformované matice'!C56*C$6","v":0},{"$f":"'Transformované matice'!D56*D$6","v":1.6113861386138614E-2},{"$f":"'Transformované matice'!E56*E$6","v":6.4160575472792681E-3},{"$f":"'Transformované matice'!F56*F$6","v":7.6704545454545437E-3},{"$f":"'Transformované matice'!G56*G$6","v":9.9574468085106369E-3},{"$f":"'Transformované matice'!H56*H$6","v":8.9552238805970137E-3},{"$f":"'Transformované matice'!I56*I$6","v":5.4545454545454541E-3},{"$f":"'Transformované matice'!J56*J$6","v":4.5833333333333334E-3},{"$f":"'Transformované matice'!K56*K$6","v":4.3636363636363638E-3},{"$f":"'Transformované matice'!L56*L$6","v":1.3749999999999999E-3},{"$f":"'Transformované matice'!M56*M$6","v":1.1884267631103073E-2},{"$f":"'Transformované matice'!N56*N$6","v":1.0933333333333333E-2},{"$f":"'Transformované matice'!O56*O$6","v":1.52E-2},{"$f":"'Transformované matice'!P56*P$6","v":1.7294117647058824E-2},{"$f":"'Transformované matice'!Q56*Q$6","v":1.3854166666666667E-2}]
[null,"V7",{"$f":"'Transformované matice'!C57*C$6","v":3.1428571428571426E-3},{"$f":"'Transformované matice'!D57*D$6","v":2.1485148514851487E-2},{"$f":"'Transformované matice'!E57*E$6","v":6.3348416289592778E-3},{"$f":"'Transformované matice'!F57*F$6","v":8.1818181818181807E-3},{"$f":"'Transformované matice'!G57*G$6","v":9.9574468085106369E-3},{"$f":"'Transformované matice'!H57*H$6","v":1.4328358208955222E-2},{"$f":"'Transformované matice'!I57*I$6","v":9.0909090909090909E-4},{"$f":"'Transformované matice'!J57*J$6","v":0},{"$f":"'Transformované matice'!K57*K$6","v":5.8181818181818187E-3},{"$f":"'Transformované matice'!L57*L$6","v":1.3749999999999999E-3},{"$f":"'Transformované matice'!M57*M$6","v":1.255515370705244E-2},{"$f":"'Transformované matice'!N57*N$6","v":1.8222222222222223E-2},{"$f":"'Transformované matice'!O57*O$6","v":2.5333333333333333E-2},{"$f":"'Transformované matice'!P57*P$6","v":1.9764705882352941E-2},{"$f":"'Transformované matice'!Q57*Q$6","v":2.2166666666666668E-2}]
[null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"Ideální varianta",{"$f":"MAX(C8:C22)","v":7.5428571428571428E-3},{"$f":"MAX(D8:D22)","v":3.4529702970297033E-2},7.9185520361990964E-3,1.0227272727272725E-2,1.4936170212765958E-2,1.4328358208955222E-2,9.0909090909090905E-3,4.7142857142857134E-3,5.8181818181818187E-3,2.7499999999999998E-3,1.255515370705244E-2,1.8222222222222223E-2,2.5333333333333333E-2,1.9764705882352941E-2,2.4937500000000001E-2]
[null,"Bazální varianta",{"$f":"MIN(C8:C22)","v":0},{"$f":"MIN(D8:D22)","v":1.6113861386138614E-2},3.1836639981436365E-3,1.4318181818181817E-3,8.2978723404255328E-3,5.3731343283582086E-3,9.0909090909090909E-4,0,2.9090909090909093E-3,1.3749999999999999E-3,0,9.1111111111111115E-3,1.2666666666666666E-2,1.2352941176470587E-2,1.1083333333333334E-2]
[]
[]
[null,"Dílčí vzdálenost od ideální varianty"]
[null,"---","k1","k2","k3","k4","k5","k6"]
[null,"V1",{"$f":"(C8-C$23)^2","v":5.6894693877551019E-5},{"$f":"(D8-D$23)^2","v":2.1255330359768658E-4},1.5515500720238862E-5,7.1191406249999979E-5,4.4066998641919418E-5,8.019603475161504E-5,2.0661157024793387E-5,0,4.7603305785123988E-6,1.8906249999999998E-6,2.3891412613755638E-5,2.9884444444444444E-5,5.7759999999999989E-5,5.4934256055363334E-5,7.6775173611111116E-6]
[null,"V2",{"$f":"(C9-C$23)^2","v":5.6894693877551019E-5},1.3247782080188223E-4,2.2419164732920677E-5,7.7360020661156994E-5,1.1016749660479859E-5,6.4958788148808177E-5,5.2892561983471072E-5,1.7148526077097264E-8,0,1.8906249999999998E-6,1.2574911137343896E-5,8.3012345679012349E-5,1.6044444444444445E-4,0,7.6775173611111116E-6]
[null,"V3",0,1.9076806195471036E-4,2.0317407203110121E-5,3.8920583677685943E-5,2.4787686736079693E-5,2.8870572510581416E-5,0,7.9294784580498748E-7,0,0,5.732653061224489E-5,8.3012345679012349E-5,1.6044444444444445E-4,0,0]
[null,"V4",3.5559183673469421E-6,2.3551612587001283E-4,1.7324872934638069E-5,5.6505972365702464E-5,{"$f":"(G11-G$23)^2","v":2.7541874151199678E-6},5.1325462241033625E-5,0,1.756009070294779E-7,4.7603305785123988E-6,1.8906249999999998E-6,1.5763188460771264E-4,8.3012345679012349E-5,1.6044444444444445E-4,6.1038062283736983E-6,6.9097656250000013E-5]
[null,"V5",3.5559183673469421E-6,0,0,0,0,2.8870572510581416E-5,0,2.2224489795918358E-5,8.4628099173553735E-6,1.8906249999999998E-6,3.1974627954049737E-5,2.9884444444444444E-5,5.7759999999999989E-5,0,1.919379340277778E-4]
[null,"V6",5.6894693877551019E-5,3.3914322125281845E-4,2.2574896892344559E-6,6.5373192148760333E-6,2.4787686736079693E-5,2.8870572510581416E-5,1.3223140495867768E-5,1.7148526077097264E-8,2.1157024793388438E-6,1.8906249999999998E-6,4.500881269027403E-7,5.3127901234567919E-5,1.0268444444444443E-4,6.1038062283736983E-6,1.2284027777777779E-4]
[null,"V7",1.9360000000000001E-5,1.7016040094108424E-4,2.508138653999712E-6,4.1838842975206584E-6,2.4787686736079693E-5,0,6.6942148760330562E-5,2.2224489795918358E-5,0,1.8906249999999998E-6,0,0,0,0,7.6775173611111116E-6]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[]
[null,"Dílčí vzdálenost od bazální varianty"]
[null,"---","k1","k2","k3","k4","k5","k6"]
[null,"V1",{"$f":"(C8-C$24)^2","v":0},{"$f":"(D8-D$24)^2","v":1.4719757866875797E-5},6.3348227831724617E-7,1.2813145661157021E-7,0,0,1.3223140495867768E-5,2.2224489795918358E-5,5.2892561983471031E-7,0,5.8787020656684396E-5,1.328197530864198E-5,2.5671111111111118E-5,0,1.2284027777777779E-4]
[null,"V2",{"$f":"(C9-C$24)^2","v":0},4.7692015488677571E-5,0,0,1.1016749660479848E-5,8.0196034751615102E-7,8.264462809917355E-7,2.1006944444444446E-5,8.4628099173553735E-6,0,8.116283039413489E-5,0,0,5.4934256055363334E-5,1.2284027777777779E-4]
[null,"V3",5.6894693877551019E-5,2.1196451328301153E-5,5.1712839046305583E-8,6.5373192148760283E-6,2.7541874151199564E-6,1.2831365560258403E-5,6.6942148760330562E-5,1.4621519274376415E-5,8.4628099173553735E-6,1.8906249999999998E-6,2.4837516227449154E-5,0,0,5.4934256055363334E-5,1.919379340277778E-4]
[null,"V4",3.200326530612244E-5,9.4206450348005052E-6,3.2783895187487387E-7,1.6343298037190071E-6,2.4787686736079659E-5,3.2078413900646007E-6,6.6942148760330562E-5,1.844907029478458E-5,5.2892561983471031E-7,0,0,0,0,2.4415224913494827E-5,3.0710069444444446E-5]
[null,"V5",3.200326530612244E-5,3.3914322125281845E-4,2.2419164732920677E-5,7.7360020661156994E-5,4.4066998641919418E-5,1.2831365560258403E-5,6.6942148760330562E-5,0,0,0,4.7617486731914364E-5,1.328197530864198E-5,2.5671111111111118E-5,5.4934256055363334E-5,0]
[null,"V6",0,0,1.0448368056493644E-5,3.8920583677685929E-5,2.7541874151199564E-6,1.2831365560258403E-5,2.0661157024793387E-5,2.1006944444444446E-5,2.1157024793388425E-6,0,1.4123581712768425E-4,3.3204938271604915E-6,6.4177777777777795E-6,2.4415224913494827E-5,7.6775173611111116E-6]
[null,"V7",9.8775510204081622E-6,2.8850725419076574E-5,9.9299204609528779E-6,4.5562499999999989E-5,2.7541874151199564E-6,8.019603475161504E-5,0,0,8.4628099173553735E-6,0,1.5763188460771264E-4,8.3012345679012349E-5,1.6044444444444445E-4,5.4934256055363334E-5,1.2284027777777779E-4]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[]
[null,"Vzdálenost variant"]
[null,"Varianta","Vzdálenost od ideálního bodu",null,null,null,"Vzdálenost od bazálního bodu",null,null,null,"Relativní vzdálenost"]
[null,"V1",{"$f":"(SUM(C29:H29))^(1/2)","v":2.1918438307484658E-2},null,null,null,{"$f":"(SUM(C48:H48))^(1/2)","v":3.9346374168155078E-3},null,null,null,{"$f":"G67/(C67+G67)","v":0.15219223657466843}]
[null,"V2",{"$f":"(SUM(C30:H30))^(1/2)","v":1.9108302851975081E-2},null,null,null,{"$f":"(SUM(C49:H49))^(1/2)","v":7.7143195096310065E-3},null,null,null,{"$f":"G68/(C68+G68)","v":0.28760497037281807}]
[null,"V3",1.7425966603955362E-2,null,null,null,1.00132776968959E-2,null,null,null,0.3649254180292878]
[null,"V4",1.9156788331916547E-2,null,null,null,8.4487636505385273E-3,null,null,null,0.30605305975798658]
[null,"V5",5.694426299279705E-3,null,null,null,2.2974421345383141E-2,null,null,null,0.80137233383568485]
[null,"V6",2.1412402557423139E-2,null,null,null,8.0594357562771071E-3,null,null,null,0.27346226830141801]
[null,"V7",1.4866072468163348E-2,null,null,null,1.3310556677583872E-2,null,null,null,0.47239705674987997]
[null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"},null,null,null,{"$error":"#VALUE!"}]