{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Úvodní list","Bodovací metoda","Metfesselova alokace","Fullerův trojúhelník","Saatyho metoda"],"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":27,"n_cols":2,"rows_kept":27,"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],[18,1,20,10],[23,1,23,3]]}
[]
[null,"Navrhování a rozhodování o typu protihlukových stěn u dopravních staveb"]
[]
[]
[]
[]
[null,"Příloha č.1 - Tabulky pro stanovení vah kritérií"]
[]
[]
[]
[null,"V této elektronické příloze mé bakalářské práce uvádím doplnění postupů uvedených v kapitole 4.3 - Stanovení vah kritérií o praktické tabulky, které jsem použil pro výpočet a grafické podání výsledků jednotlivých metod určování vah pro kritéria výběru variant. Tabulky jsou zároveň upraveny tak, aby bylo umožněno jejich jednoduché opětovné použití na jakékoli jiné úlohy vícekriteriálního hodnocení variant a jsou doplněny o popisy objasňující jejich fungování a poskytující návod na jejich použití pro jiné výpočty."]
[]
[]
[]
[]
[]
[]
[]
[null,"Metody určování vah mají v tomto sešitu každý svůj list, mezi kterými lze navigovat buďto přes překlikávání listů na spodní ovládací liště, nebo za pomoci odkazů v obsahu."]
[]
[]
[]
[null,"Obsah:"]
[null,"Bodovací metoda"]
[null,"Metfesselova alokace"]
[null,"Fullerův trojúhelník"]
[null,"Saatyho metoda"]

{"sheet":"Bodovací metoda","index":1,"n_rows":53,"n_cols":11,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,1,2,7],[52,10,52,12]]}
[]
[null,"Bodovací metoda"]
[]
[]
[]
[null,null,null,"Kritérium","Bodové hodnocení","Normovaná váha"]
[null,null,null,"k1",8,{"$f":"Tabulka21617[[#This Row],[Bodové hodnocení]]/SUM(E:E)","v":0.21052631578947367}]
[null,null,null,"k2",4,{"$f":"Tabulka21617[[#This Row],[Bodové hodnocení]]/SUM(E:E)","v":0.10526315789473684}]
[null,null,null,"k3",9,{"$f":"Tabulka21617[[#This Row],[Bodové hodnocení]]/SUM(E:E)","v":0.23684210526315788}]
[null,null,null,"k4",2,{"$f":"Tabulka21617[[#This Row],[Bodové hodnocení]]/SUM(E:E)","v":5.2631578947368418E-2}]
[null,null,null,"k5",6,{"$f":"Tabulka21617[[#This Row],[Bodové hodnocení]]/SUM(E:E)","v":0.15789473684210525}]
[null,null,null,"k6",9,{"$f":"Tabulka21617[[#This Row],[Bodové hodnocení]]/SUM(E:E)","v":0.23684210526315788}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"<- zpět na Úvodní list"]

{"sheet":"Metfesselova alokace","index":2,"n_rows":54,"n_cols":8,"rows_kept":54,"cut":false,"hidden":false,"merged":[[1,1,2,6],[35,1,41,1],[25,1,31,1],[15,1,21,1]]}
[]
[null,"Metfesselova alokace"]
[]
[]
[]
[null,"Skupina","Bodové hodnocení","Normovaná váha"]
[null,"S1",6,{"$f":"Tabulka242125[[#This Row],[Bodové hodnocení]]/SUM(C:C)","v":0.2608695652173913}]
[null,"S2",9,{"$f":"Tabulka242125[[#This Row],[Bodové hodnocení]]/SUM(C:C)","v":0.39130434782608697}]
[null,"S3",8,{"$f":"Tabulka242125[[#This Row],[Bodové hodnocení]]/SUM(C:C)","v":0.34782608695652173}]
[]
[]
[]
[]
[]
[]
[null,"S1","Kritérium","Pořadí","Normovaná váha","Výsledková váha"]
[null,null,"k1",2,{"$f":"Tabulka2492226[[#This Row],[Pořadí]]/SUM($D$17:$D$22)","v":0.66666666666666663},{"$f":"Tabulka2492226[[#This Row],[Normovaná váha]]*$D$7","v":0.17391304347826086}]
[null,null,"k2",1,{"$f":"Tabulka2492226[[#This Row],[Pořadí]]/SUM($D$17:$D$22)","v":0.33333333333333331},{"$f":"Tabulka2492226[[#This Row],[Normovaná váha]]*$D$7","v":8.6956521739130432E-2}]
[]
[]
[]
[]
[]
[]
[]
[null,"S2","Kritérium","Pořadí","Normovaná váha","Výsledková váha"]
[null,null,"k1",3,{"$f":"Tabulka249102327[[#This Row],[Pořadí]]/SUM($D$27:$D$32)","v":0.5},{"$f":"Tabulka249102327[[#This Row],[Normovaná váha]]*$D$8","v":0.19565217391304349}]
[null,null,"k2",1,{"$f":"Tabulka249102327[[#This Row],[Pořadí]]/SUM($D$27:$D$32)","v":0.16666666666666666},{"$f":"Tabulka249102327[[#This Row],[Normovaná váha]]*$D$8","v":6.5217391304347824E-2}]
[null,null,"k3",2,{"$f":"Tabulka249102327[[#This Row],[Pořadí]]/SUM($D$27:$D$32)","v":0.33333333333333331},{"$f":"Tabulka249102327[[#This Row],[Normovaná váha]]*$D$8","v":0.13043478260869565}]
[]
[]
[]
[]
[]
[]
[null,"S3","Kritérium","Pořadí","Normovaná váha","Výsledková váha"]
[null,null,"k1",1,{"$f":"Tabulka249112428[[#This Row],[Pořadí]]/SUM($D$37:$D$42)","v":1},{"$f":"Tabulka249112428[[#This Row],[Normovaná váha]]*$D$9","v":0.34782608695652173}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"<- zpět na Úvodní list"]

{"sheet":"Fullerův trojúhelník","index":3,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[14,1,14,2],[1,1,2,7],[4,2,4,6],[1,9,1,10],[1,13,1,15]]}
[]
[null,"Fullerova metoda",null,null,null,null,null,null,null,"Barevné vyznačení:",null,null,null,"<- zpět na Úvodní list"]
[]
[]
[null,null,"Fullerův trojúhelník"]
[null,"x","x","x","x","x","x","x"]
[null,"y",1,2,3,4,5,6]
[null,null,"y","y","y","y","y","y"]
[null,null,1,2,3,4,5,6]
[null,null,null,1,1,1,1,1]
[null,null,null,2,3,4,5,6]
[null,null,null,null,2,2,2,2]
[null,null,null,null,3,4,5,6]
[null,null,null,null,null,3,3,3]
[null,"Počet vyznačení (N):",null,{"$f":"[1]!ColorSummer(B6:H19,[1]!ColorPicker(L2))","v":{"$error":"#NAME?"}},null,4,5,6]
[null,null,null,null,null,null,4,4]
[null,"Kritérium","Vyznač.","Váha",null,null,5,6]
[null,"k1",3,{"$f":"Tabulka12[[#This Row],[Vyznač.]]/$D$15","v":{"$error":"#NAME?"}},null,null,null,5]
[null,"k2",1,{"$f":"Tabulka12[[#This Row],[Vyznač.]]/$D$15","v":{"$error":"#NAME?"}},null,null,null,6]
[null,"k3",5,{"$f":"Tabulka12[[#This Row],[Vyznač.]]/$D$15","v":{"$error":"#NAME?"}}]
[null,"k4",1,{"$f":"Tabulka12[[#This Row],[Vyznač.]]/$D$15","v":{"$error":"#NAME?"}}]
[null,"k5",3,{"$f":"Tabulka12[[#This Row],[Vyznač.]]/$D$15","v":{"$error":"#NAME?"}}]
[null,"k6",5,{"$f":"Tabulka12[[#This Row],[Vyznač.]]/$D$15","v":{"$error":"#NAME?"}}]

{"sheet":"Saatyho metoda","index":4,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[18,1,18,3],[1,1,2,7],[4,1,4,2],[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"]
[null,"k1",1,5,{"$f":"1/3","v":0.33333333333333331},4,3,{"$f":"1/3","v":0.33333333333333331}]
[null,"k2",{"$f":"1/D7","v":0.2},1,{"$f":"1/7","v":0.14285714285714285},3,1,{"$f":"1/7","v":0.14285714285714285}]
[null,"k3",{"$f":"1/E7","v":3},{"$f":"1/E8","v":7},1,6,4,{"$f":"1/2","v":0.5}]
[null,"k4",{"$f":"1/F7","v":0.25},{"$f":"1/F8","v":0.33333333333333331},{"$f":"1/F9","v":0.16666666666666666},1,{"$f":"1/3","v":0.33333333333333331},{"$f":"1/7","v":0.14285714285714285}]
[null,"k5",{"$f":"1/G7","v":0.33333333333333331},{"$f":"1/G8","v":1},{"$f":"1/G9","v":0.25},{"$f":"1/G10","v":3},1,{"$f":"1/6","v":0.16666666666666666}]
[null,"k6",{"$f":"1/H7","v":3},{"$f":"1/H8","v":7},{"$f":"1/H9","v":2},{"$f":"1/H10","v":7},{"$f":"1/H11","v":6},1]
[null,null,{"$f":"1/I7","v":{"$error":"#DIV/0!"}},{"$f":"1/I8","v":{"$error":"#DIV/0!"}},{"$f":"1/I9","v":{"$error":"#DIV/0!"}},{"$f":"1/I10","v":{"$error":"#DIV/0!"}},{"$f":"1/I11","v":{"$error":"#DIV/0!"}},{"$f":"1/I12","v":{"$error":"#DIV/0!"}},1]
[null,null,{"$f":"1/J7","v":{"$error":"#DIV/0!"}},{"$f":"1/J8","v":{"$error":"#DIV/0!"}},{"$f":"1/J9","v":{"$error":"#DIV/0!"}},{"$f":"1/J10","v":{"$error":"#DIV/0!"}},{"$f":"1/J11","v":{"$error":"#DIV/0!"}},{"$f":"1/J12","v":{"$error":"#DIV/0!"}},{"$f":"1/J13","v":{"$error":"#DIV/0!"}},1]
[null,null,{"$f":"1/K7","v":{"$error":"#DIV/0!"}},{"$f":"1/K8","v":{"$error":"#DIV/0!"}},{"$f":"1/K9","v":{"$error":"#DIV/0!"}},{"$f":"1/K10","v":{"$error":"#DIV/0!"}},{"$f":"1/K11","v":{"$error":"#DIV/0!"}},{"$f":"1/K12","v":{"$error":"#DIV/0!"}},{"$f":"1/K13","v":{"$error":"#DIV/0!"}},{"$f":"1/K14","v":{"$error":"#DIV/0!"}},1]
[null,null,{"$f":"1/L7","v":{"$error":"#DIV/0!"}},{"$f":"1/L8","v":{"$error":"#DIV/0!"}},{"$f":"1/L9","v":{"$error":"#DIV/0!"}},{"$f":"1/L10","v":{"$error":"#DIV/0!"}},{"$f":"1/L11","v":{"$error":"#DIV/0!"}},{"$f":"1/L12","v":{"$error":"#DIV/0!"}},{"$f":"1/L13","v":{"$error":"#DIV/0!"}},{"$f":"1/L14","v":{"$error":"#DIV/0!"}},{"$f":"1/L15","v":{"$error":"#DIV/0!"}},1]
[]
[]
[null,"Výpočet vah pomocí geometrického průměru",null,null,null,"Počet kritérií:",null,{"$f":"COUNTIF(C7:L7,\"<10\")","v":6}]
[null,"Kritérium","Geom. průměr","Normovaná váha"]
[null,"k1",{"$f":"PRODUCT(7:7)^(1/$H$19)","v":1.3718863137162849},{"$f":"Tabulka14[[#This Row],[Geom. průměr]]/SUM($C$21:$C$30)","v":0.15723245156459004}]
[null,"k2",{"$f":"PRODUCT(8:8)^(1/$H$19)","v":0.48009353940137001},{"$f":"Tabulka14[[#This Row],[Geom. průměr]]/SUM($C$21:$C$30)","v":5.5023716925868806E-2}]
[null,"k3",2.5132368765511099,{"$f":"Tabulka14[[#This Row],[Geom. průměr]]/SUM($C$21:$C$30)","v":0.28804310642345698}]
[null,"k4",0.29517168974872637,{"$f":"Tabulka14[[#This Row],[Geom. průměr]]/SUM($C$21:$C$30)","v":3.3829748097664036E-2}]
[null,"k5",0.58879592150024052,{"$f":"Tabulka14[[#This Row],[Geom. průměr]]/SUM($C$21:$C$30)","v":6.7482141401303042E-2}]
[null,"k6",3.4760266448864496,{"$f":"Tabulka14[[#This Row],[Geom. průměr]]/SUM($C$21:$C$30)","v":0.39838883558711702}]