{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Úvodní list","Informace o programech","Temp","Vícekriteriální analýza hor.","Vícekriteriální analýza"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":3,"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":[[29,1,29,7],[31,1,31,7],[24,1,24,7],[26,1,26,7],[3,1,3,7],[7,1,7,7],[22,1,22,7],[5,1,5,7]]}
[]
[]
[]
[null,"ČESKÉ VYSOKÉ UČENÍ TECHNICKÉ"]
[]
[null,"FAKULTA STAVEBNÍ"]
[]
[null,"KATEDRA TECHNOLOGIE STAVEB"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"DIPLOMOVÁ PRÁCE"]
[]
[null,"DIGITALIZACE KONTROLY KVALITY VE STAVEBNICTVÍ"]
[]
[null,"VÍCEKRITERIÁLNÍ ANALÝZA"]
[]
[]
[null,"Bc. Milan Červený"]
[]
[null,2020]

{"sheet":"Informace o programech","index":1,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Požadavky",null,"Dalux","PlanRadar basic","PlanRadar pro","Fieldwire","Construction Manager","Mobile Field Manager","Plan Grid","Vím o všem"]
["1.","Cena [Kč]","-",{"$f":"29*26.4","v":765.59999999999991},{"$f":"99*26.4","v":2613.6},{"$f":"49*26.4","v":1293.5999999999999},{"$f":"15*22.3","v":334.5},"-",{"$f":"59*22.3","v":1315.7},2490]
["2.","Návod","Ano","Ano","Ano","Ano","Ano","Ano","Ano","Ano"]
["3.","Podpora [Dny]","7+",3,3,1,"7+",1,"7+","7+"]
["4.","KZP","Ano","Ano","Ano","Ano","Ano","Ne","Ano","Ne"]
["5.","3D","Ano","Ne","Ano","Ano","Ne","Ano","Ano","Ne"]
["6.","Úkoly","Ano","Ano","Ano","Ano","Ano","Ano","Ano","Ano"]
["7.","Intuitivnost",3,5,5,2,1,1,4,2]
["8.","Reakce Podpory","Ano","Ano","Ano","Ano","Ne","Ne","Ne","Ne"]
["9.","Aplikace","Ano","Ano","Ano","Ano","Ano","Ne","Ano","Ano"]
["10.","Offline","Ano","Ano","Ano","Ano","Ano","Ne","Ano","Ano"]

{"sheet":"Temp","index":2,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Povaha",null,"Hledisko"]
[null,"Min",null,"Kvant"]
[null,"Max",null,"Kvalit"]

{"sheet":"Vícekriteriální analýza hor.","index":3,"n_rows":11,"n_cols":26,"rows_kept":11,"cut":false,"hidden":true,"merged":[[0,23,0,25],[0,5,0,7],[0,14,0,16],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[0,20,0,22],[0,11,0,13],[0,17,0,19],[0,8,0,10]]}
["Kritérium","Pořadí dle důležitosti","Povaha","Hledisko","Váha","Varianta A: Dalux",null,null,"Varianta B: PlanRadar",null,null,"Varianta C: Fieldwire",null,null,"Varianta D: Construction Manager",null,null,"Varianta E: Mobile Field Manager",null,null,"Varianta F: PlanGrid",null,null,"Varianta G: Vím o všem"]
[null,null,null,null,null,"Hodnota","Pořadí","Body","Hodnota","Pořadí","Body","Hodnota","Pořadí","Body","Hodnota","Pořadí","Body","Hodnota","Pořadí","Body","Hodnota","Pořadí","Body","Hodnota","Pořadí","Body"]
["Cena [Kč]",8,"Min","Kvant",{"$f":"(MAX($B$3:$B$10)+1-B3)/$B$11","v":2.7777777777777776E-2},0,{"$f":"IF($C3=\"Min\",_xlfn.RANK.EQ(F3,($F3,$I3,$L3,$O3,$R3,$U3,$X3),0),_xlfn.RANK.EQ(F3,($F3,$I3,$L3,$O3,$R3,$U3,$X3),1))","v":6},{"$f":"$E3*G3","v":0.16666666666666666},2614,{"$f":"IF($C3=\"Min\",_xlfn.RANK.EQ(I3,($F3,$I3,$L3,$O3,$R3,$U3,$X3),0),_xlfn.RANK.EQ(I3,($F3,$I3,$L3,$O3,$R3,$U3,$X3),1))","v":1},{"$f":"$E3*J3","v":2.7777777777777776E-2},1294,{"$f":"IF($C3=\"Min\",_xlfn.RANK.EQ(L3,($F3,$I3,$L3,$O3,$R3,$U3,$X3),0),_xlfn.RANK.EQ(L3,($F3,$I3,$L3,$O3,$R3,$U3,$X3),1))","v":4},{"$f":"$E3*M3","v":0.1111111111111111},335,{"$f":"IF($C3=\"Min\",_xlfn.RANK.EQ(O3,($F3,$I3,$L3,$O3,$R3,$U3,$X3),0),_xlfn.RANK.EQ(O3,($F3,$I3,$L3,$O3,$R3,$U3,$X3),1))","v":5},{"$f":"$E3*P3","v":0.1388888888888889},0,{"$f":"IF($C3=\"Min\",_xlfn.RANK.EQ(R3,($F3,$I3,$L3,$O3,$R3,$U3,$X3),0),_xlfn.RANK.EQ(R3,($F3,$I3,$L3,$O3,$R3,$U3,$X3),1))","v":6},{"$f":"$E3*S3","v":0.16666666666666666},1316,{"$f":"IF($C3=\"Min\",_xlfn.RANK.EQ(U3,($F3,$I3,$L3,$O3,$R3,$U3,$X3),0),_xlfn.RANK.EQ(U3,($F3,$I3,$L3,$O3,$R3,$U3,$X3),1))","v":3},{"$f":"$E3*V3","v":8.3333333333333329E-2},2490,{"$f":"IF($C3=\"Min\",_xlfn.RANK.EQ(X3,($F3,$I3,$L3,$O3,$R3,$U3,$X3),0),_xlfn.RANK.EQ(X3,($F3,$I3,$L3,$O3,$R3,$U3,$X3),1))","v":2},{"$f":"$E3*Y3","v":5.5555555555555552E-2}]
["Reakce podpory [Den]",6,"Min","Kvalit",{"$f":"(MAX($B$3:$B$10)+1-B4)/$B$11","v":8.3333333333333329E-2},5,{"$f":"IF($C4=\"Min\",_xlfn.RANK.EQ(F4,($F4,$I4,$L4,$O4,$R4,$U4,$X4),0),_xlfn.RANK.EQ(F4,($F4,$I4,$L4,$O4,$R4,$U4,$X4),1))","v":4},0.33333333333333331,1.83,{"$f":"IF($C4=\"Min\",_xlfn.RANK.EQ(I4,($F4,$I4,$L4,$O4,$R4,$U4,$X4),0),_xlfn.RANK.EQ(I4,($F4,$I4,$L4,$O4,$R4,$U4,$X4),1))","v":5},0.41666666666666663,0.25,{"$f":"IF($C4=\"Min\",_xlfn.RANK.EQ(L4,($F4,$I4,$L4,$O4,$R4,$U4,$X4),0),_xlfn.RANK.EQ(L4,($F4,$I4,$L4,$O4,$R4,$U4,$X4),1))","v":6},0.5,7,{"$f":"IF($C4=\"Min\",_xlfn.RANK.EQ(O4,($F4,$I4,$L4,$O4,$R4,$U4,$X4),0),_xlfn.RANK.EQ(O4,($F4,$I4,$L4,$O4,$R4,$U4,$X4),1))","v":1},8.3333333333333329E-2,8.3000000000000004E-2,{"$f":"IF($C4=\"Min\",_xlfn.RANK.EQ(R4,($F4,$I4,$L4,$O4,$R4,$U4,$X4),0),_xlfn.RANK.EQ(R4,($F4,$I4,$L4,$O4,$R4,$U4,$X4),1))","v":7},0.58333333333333326,6,{"$f":"IF($C4=\"Min\",_xlfn.RANK.EQ(U4,($F4,$I4,$L4,$O4,$R4,$U4,$X4),0),_xlfn.RANK.EQ(U4,($F4,$I4,$L4,$O4,$R4,$U4,$X4),1))","v":3},0.25,7,{"$f":"IF($C4=\"Min\",_xlfn.RANK.EQ(X4,($F4,$I4,$L4,$O4,$R4,$U4,$X4),0),_xlfn.RANK.EQ(X4,($F4,$I4,$L4,$O4,$R4,$U4,$X4),1))","v":1},8.3333333333333329E-2]
["Počet stažení v mobilu [tis]",7,"Max","Kvant",5.5555555555555552E-2,50,{"$f":"IF($C5=\"Min\",_xlfn.RANK.EQ(F5,($F5,$I5,$L5,$O5,$R5,$U5,$X5),0),_xlfn.RANK.EQ(F5,($F5,$I5,$L5,$O5,$R5,$U5,$X5),1))","v":2},0.1111111111111111,100,{"$f":"IF($C5=\"Min\",_xlfn.RANK.EQ(I5,($F5,$I5,$L5,$O5,$R5,$U5,$X5),0),_xlfn.RANK.EQ(I5,($F5,$I5,$L5,$O5,$R5,$U5,$X5),1))","v":5},0.27777777777777779,500,{"$f":"IF($C5=\"Min\",_xlfn.RANK.EQ(L5,($F5,$I5,$L5,$O5,$R5,$U5,$X5),0),_xlfn.RANK.EQ(L5,($F5,$I5,$L5,$O5,$R5,$U5,$X5),1))","v":6},0.33333333333333331,50,{"$f":"IF($C5=\"Min\",_xlfn.RANK.EQ(O5,($F5,$I5,$L5,$O5,$R5,$U5,$X5),0),_xlfn.RANK.EQ(O5,($F5,$I5,$L5,$O5,$R5,$U5,$X5),1))","v":2},0.1111111111111111,50,{"$f":"IF($C5=\"Min\",_xlfn.RANK.EQ(R5,($F5,$I5,$L5,$O5,$R5,$U5,$X5),0),_xlfn.RANK.EQ(R5,($F5,$I5,$L5,$O5,$R5,$U5,$X5),1))","v":2},0.1111111111111111,500,{"$f":"IF($C5=\"Min\",_xlfn.RANK.EQ(U5,($F5,$I5,$L5,$O5,$R5,$U5,$X5),0),_xlfn.RANK.EQ(U5,($F5,$I5,$L5,$O5,$R5,$U5,$X5),1))","v":6},0.33333333333333331,1,{"$f":"IF($C5=\"Min\",_xlfn.RANK.EQ(X5,($F5,$I5,$L5,$O5,$R5,$U5,$X5),0),_xlfn.RANK.EQ(X5,($F5,$I5,$L5,$O5,$R5,$U5,$X5),1))","v":1},5.5555555555555552E-2]
["3D model [ano/ne]",2,"Max","Kvant",0.19444444444444445,1,{"$f":"IF($C6=\"Min\",_xlfn.RANK.EQ(F6,($F6,$I6,$L6,$O6,$R6,$U6,$X6),0),_xlfn.RANK.EQ(F6,($F6,$I6,$L6,$O6,$R6,$U6,$X6),1))","v":3},0.58333333333333337,1,{"$f":"IF($C6=\"Min\",_xlfn.RANK.EQ(I6,($F6,$I6,$L6,$O6,$R6,$U6,$X6),0),_xlfn.RANK.EQ(I6,($F6,$I6,$L6,$O6,$R6,$U6,$X6),1))","v":3},0.58333333333333337,1,{"$f":"IF($C6=\"Min\",_xlfn.RANK.EQ(L6,($F6,$I6,$L6,$O6,$R6,$U6,$X6),0),_xlfn.RANK.EQ(L6,($F6,$I6,$L6,$O6,$R6,$U6,$X6),1))","v":3},0.58333333333333337,0,{"$f":"IF($C6=\"Min\",_xlfn.RANK.EQ(O6,($F6,$I6,$L6,$O6,$R6,$U6,$X6),0),_xlfn.RANK.EQ(O6,($F6,$I6,$L6,$O6,$R6,$U6,$X6),1))","v":1},0.19444444444444445,1,{"$f":"IF($C6=\"Min\",_xlfn.RANK.EQ(R6,($F6,$I6,$L6,$O6,$R6,$U6,$X6),0),_xlfn.RANK.EQ(R6,($F6,$I6,$L6,$O6,$R6,$U6,$X6),1))","v":3},0.58333333333333337,1,{"$f":"IF($C6=\"Min\",_xlfn.RANK.EQ(U6,($F6,$I6,$L6,$O6,$R6,$U6,$X6),0),_xlfn.RANK.EQ(U6,($F6,$I6,$L6,$O6,$R6,$U6,$X6),1))","v":3},0.58333333333333337,0,{"$f":"IF($C6=\"Min\",_xlfn.RANK.EQ(X6,($F6,$I6,$L6,$O6,$R6,$U6,$X6),0),_xlfn.RANK.EQ(X6,($F6,$I6,$L6,$O6,$R6,$U6,$X6),1))","v":1},0.19444444444444445]
["Intuitivnost ",3,"Max","Kvalit",0.16666666666666666,4,{"$f":"IF($C7=\"Min\",_xlfn.RANK.EQ(F7,($F7,$I7,$L7,$O7,$R7,$U7,$X7),0),_xlfn.RANK.EQ(F7,($F7,$I7,$L7,$O7,$R7,$U7,$X7),1))","v":5},0.83333333333333326,5,{"$f":"IF($C7=\"Min\",_xlfn.RANK.EQ(I7,($F7,$I7,$L7,$O7,$R7,$U7,$X7),0),_xlfn.RANK.EQ(I7,($F7,$I7,$L7,$O7,$R7,$U7,$X7),1))","v":7},1.1666666666666665,2,{"$f":"IF($C7=\"Min\",_xlfn.RANK.EQ(L7,($F7,$I7,$L7,$O7,$R7,$U7,$X7),0),_xlfn.RANK.EQ(L7,($F7,$I7,$L7,$O7,$R7,$U7,$X7),1))","v":3},0.5,1,{"$f":"IF($C7=\"Min\",_xlfn.RANK.EQ(O7,($F7,$I7,$L7,$O7,$R7,$U7,$X7),0),_xlfn.RANK.EQ(O7,($F7,$I7,$L7,$O7,$R7,$U7,$X7),1))","v":1},0.16666666666666666,1,{"$f":"IF($C7=\"Min\",_xlfn.RANK.EQ(R7,($F7,$I7,$L7,$O7,$R7,$U7,$X7),0),_xlfn.RANK.EQ(R7,($F7,$I7,$L7,$O7,$R7,$U7,$X7),1))","v":1},0.16666666666666666,4,{"$f":"IF($C7=\"Min\",_xlfn.RANK.EQ(U7,($F7,$I7,$L7,$O7,$R7,$U7,$X7),0),_xlfn.RANK.EQ(U7,($F7,$I7,$L7,$O7,$R7,$U7,$X7),1))","v":5},0.83333333333333326,2,{"$f":"IF($C7=\"Min\",_xlfn.RANK.EQ(X7,($F7,$I7,$L7,$O7,$R7,$U7,$X7),0),_xlfn.RANK.EQ(X7,($F7,$I7,$L7,$O7,$R7,$U7,$X7),1))","v":3},0.5]
["Dostupnost informací web",5,"Max","Kvalit",0.1111111111111111,5,{"$f":"IF($C8=\"Min\",_xlfn.RANK.EQ(F8,($F8,$I8,$L8,$O8,$R8,$U8,$X8),0),_xlfn.RANK.EQ(F8,($F8,$I8,$L8,$O8,$R8,$U8,$X8),1))","v":7},0.77777777777777768,4,{"$f":"IF($C8=\"Min\",_xlfn.RANK.EQ(I8,($F8,$I8,$L8,$O8,$R8,$U8,$X8),0),_xlfn.RANK.EQ(I8,($F8,$I8,$L8,$O8,$R8,$U8,$X8),1))","v":5},0.55555555555555558,3,{"$f":"IF($C8=\"Min\",_xlfn.RANK.EQ(L8,($F8,$I8,$L8,$O8,$R8,$U8,$X8),0),_xlfn.RANK.EQ(L8,($F8,$I8,$L8,$O8,$R8,$U8,$X8),1))","v":4},0.44444444444444442,1,{"$f":"IF($C8=\"Min\",_xlfn.RANK.EQ(O8,($F8,$I8,$L8,$O8,$R8,$U8,$X8),0),_xlfn.RANK.EQ(O8,($F8,$I8,$L8,$O8,$R8,$U8,$X8),1))","v":1},0.1111111111111111,2,{"$f":"IF($C8=\"Min\",_xlfn.RANK.EQ(R8,($F8,$I8,$L8,$O8,$R8,$U8,$X8),0),_xlfn.RANK.EQ(R8,($F8,$I8,$L8,$O8,$R8,$U8,$X8),1))","v":2},0.22222222222222221,2,{"$f":"IF($C8=\"Min\",_xlfn.RANK.EQ(U8,($F8,$I8,$L8,$O8,$R8,$U8,$X8),0),_xlfn.RANK.EQ(U8,($F8,$I8,$L8,$O8,$R8,$U8,$X8),1))","v":2},0.22222222222222221,4,{"$f":"IF($C8=\"Min\",_xlfn.RANK.EQ(X8,($F8,$I8,$L8,$O8,$R8,$U8,$X8),0),_xlfn.RANK.EQ(X8,($F8,$I8,$L8,$O8,$R8,$U8,$X8),1))","v":5},0.55555555555555558]
["Kontrolní a zkušební plán",1,"Max","Kvalit",0.22222222222222221,1,{"$f":"IF($C9=\"Min\",_xlfn.RANK.EQ(F9,($F9,$I9,$L9,$O9,$R9,$U9,$X9),0),_xlfn.RANK.EQ(F9,($F9,$I9,$L9,$O9,$R9,$U9,$X9),1))","v":3},0.66666666666666663,1,{"$f":"IF($C9=\"Min\",_xlfn.RANK.EQ(I9,($F9,$I9,$L9,$O9,$R9,$U9,$X9),0),_xlfn.RANK.EQ(I9,($F9,$I9,$L9,$O9,$R9,$U9,$X9),1))","v":3},0.66666666666666663,1,{"$f":"IF($C9=\"Min\",_xlfn.RANK.EQ(L9,($F9,$I9,$L9,$O9,$R9,$U9,$X9),0),_xlfn.RANK.EQ(L9,($F9,$I9,$L9,$O9,$R9,$U9,$X9),1))","v":3},0.66666666666666663,1,{"$f":"IF($C9=\"Min\",_xlfn.RANK.EQ(O9,($F9,$I9,$L9,$O9,$R9,$U9,$X9),0),_xlfn.RANK.EQ(O9,($F9,$I9,$L9,$O9,$R9,$U9,$X9),1))","v":3},0.66666666666666663,0,{"$f":"IF($C9=\"Min\",_xlfn.RANK.EQ(R9,($F9,$I9,$L9,$O9,$R9,$U9,$X9),0),_xlfn.RANK.EQ(R9,($F9,$I9,$L9,$O9,$R9,$U9,$X9),1))","v":1},0.22222222222222221,1,{"$f":"IF($C9=\"Min\",_xlfn.RANK.EQ(U9,($F9,$I9,$L9,$O9,$R9,$U9,$X9),0),_xlfn.RANK.EQ(U9,($F9,$I9,$L9,$O9,$R9,$U9,$X9),1))","v":3},0.66666666666666663,0,{"$f":"IF($C9=\"Min\",_xlfn.RANK.EQ(X9,($F9,$I9,$L9,$O9,$R9,$U9,$X9),0),_xlfn.RANK.EQ(X9,($F9,$I9,$L9,$O9,$R9,$U9,$X9),1))","v":1},0.22222222222222221]
["Návod",4,"Max","Kvalit",0.1388888888888889,3,{"$f":"IF($C10=\"Min\",_xlfn.RANK.EQ(F10,($F10,$I10,$L10,$O10,$R10,$U10,$X10),0),_xlfn.RANK.EQ(F10,($F10,$I10,$L10,$O10,$R10,$U10,$X10),1))","v":6},0.83333333333333337,2,{"$f":"IF($C10=\"Min\",_xlfn.RANK.EQ(I10,($F10,$I10,$L10,$O10,$R10,$U10,$X10),0),_xlfn.RANK.EQ(I10,($F10,$I10,$L10,$O10,$R10,$U10,$X10),1))","v":4},0.55555555555555558,1,{"$f":"IF($C10=\"Min\",_xlfn.RANK.EQ(L10,($F10,$I10,$L10,$O10,$R10,$U10,$X10),0),_xlfn.RANK.EQ(L10,($F10,$I10,$L10,$O10,$R10,$U10,$X10),1))","v":2},0.27777777777777779,0,{"$f":"IF($C10=\"Min\",_xlfn.RANK.EQ(O10,($F10,$I10,$L10,$O10,$R10,$U10,$X10),0),_xlfn.RANK.EQ(O10,($F10,$I10,$L10,$O10,$R10,$U10,$X10),1))","v":1},0.1388888888888889,1,{"$f":"IF($C10=\"Min\",_xlfn.RANK.EQ(R10,($F10,$I10,$L10,$O10,$R10,$U10,$X10),0),_xlfn.RANK.EQ(R10,($F10,$I10,$L10,$O10,$R10,$U10,$X10),1))","v":2},0.27777777777777779,2,{"$f":"IF($C10=\"Min\",_xlfn.RANK.EQ(U10,($F10,$I10,$L10,$O10,$R10,$U10,$X10),0),_xlfn.RANK.EQ(U10,($F10,$I10,$L10,$O10,$R10,$U10,$X10),1))","v":4},0.55555555555555558,3,{"$f":"IF($C10=\"Min\",_xlfn.RANK.EQ(X10,($F10,$I10,$L10,$O10,$R10,$U10,$X10),0),_xlfn.RANK.EQ(X10,($F10,$I10,$L10,$O10,$R10,$U10,$X10),1))","v":6},0.83333333333333337]
[null,{"$f":"SUM(B3:B10)","v":36},null,null,{"$f":"SUM(E3:E10)","v":1},null,null,{"$f":"SUM(H3:H10)","v":4.3055555555555554},null,null,{"$f":"SUM(K3:K10)","v":4.25},null,null,{"$f":"SUM(N3:N10)","v":3.4166666666666665},null,null,{"$f":"SUM(Q3:Q10)","v":1.6111111111111112},null,null,{"$f":"SUM(T3:T10)","v":2.333333333333333},null,null,{"$f":"SUM(W3:W10)","v":3.5277777777777777},null,null,{"$f":"SUM(Z3:Z10)","v":2.5}]

{"sheet":"Vícekriteriální analýza","index":4,"n_rows":67,"n_cols":8,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[56,0,57,0],[56,1,57,1],[56,2,56,4],[13,5,13,7],[26,0,27,0],[26,1,27,1],[26,2,26,4],[26,5,26,7],[43,0,44,0],[43,1,44,1],[43,2,43,4],[43,5,43,7],[13,0,14,0],[13,1,14,1],[13,2,13,4]]}
["Kritérium","Pořadí dle důležitosti","Povaha","Hledisko","Váha"]
[]
["Cena [Kč]",1,"Min","Kvant",{"$f":"(MAX($B$3:$B$10)+1-B3)/$B$11","v":0.22222222222222221}]
["Reakce podpory [Den]",2,"Min","Kvalit",{"$f":"(MAX($B$3:$B$10)+1-B4)/$B$11","v":0.19444444444444445}]
["Počet stažení v mobilu [tis]",3,"Max","Kvant",{"$f":"(MAX($B$3:$B$10)+1-B5)/$B$11","v":0.16666666666666666}]
["3D model [ano/ne]",4,"Max","Kvant",0.1388888888888889]
["Intuitivnost ",5,"Max","Kvalit",0.1111111111111111]
["Dostupnost informací web",6,"Max","Kvalit",8.3333333333333329E-2]
["Kontrolní a zkušební plán",7,"Max","Kvalit",5.5555555555555552E-2]
["Návod",8,"Max","Kvalit",2.7777777777777776E-2]
[null,{"$f":"SUM(B3:B10)","v":36},null,null,{"$f":"SUM(E3:E10)","v":1}]
[]
[]
["Kritérium","Pořadí dle důležitosti","Varianta A: Dalux",null,null,"Varianta B: PlanRadar"]
[null,null,"Hodnota","Pořadí","Body","Hodnota","Pořadí","Body"]
["Cena [Kč]",{"$f":"B3","v":1},0,{"$f":"IF($C3=\"Min\",_xlfn.RANK.EQ(C16,($C16,$F16,$C29,$F29,$C46,$F46,$C59),0),_xlfn.RANK.EQ(C16,($C16,$F16,$C29,$F29,$C46,$F46,$C59),1))","v":6},{"$f":"$E3*D16","v":1.3333333333333333},2614,{"$f":"IF($C3=\"Min\",_xlfn.RANK.EQ(F16,($C16,$F16,$C29,$F29,$C46,$F46,$C59),0),_xlfn.RANK.EQ(F16,($C16,$F16,$C29,$F29,$C46,$F46,$C59),1))","v":1},{"$f":"$E3*G16","v":0.22222222222222221}]
["Reakce podpory [Den]",{"$f":"B4","v":2},5,{"$f":"IF($C4=\"Min\",_xlfn.RANK.EQ(C17,($C17,$F17,$C30,$F30,$C47,$F47,$C60),0),_xlfn.RANK.EQ(C17,($C17,$F17,$C30,$F30,$C47,$F47,$C60),1))","v":4},0.77777777777777779,1.83,{"$f":"IF($C4=\"Min\",_xlfn.RANK.EQ(F17,($C17,$F17,$C30,$F30,$C47,$F47,$C60),0),_xlfn.RANK.EQ(F17,($C17,$F17,$C30,$F30,$C47,$F47,$C60),1))","v":5},{"$f":"$E4*G17","v":0.97222222222222221}]
["Počet stažení v mobilu [tis]",3,50,{"$f":"IF($C5=\"Min\",_xlfn.RANK.EQ(C18,($C18,$F18,$C31,$F31,$C48,$F48,$C61),0),_xlfn.RANK.EQ(C18,($C18,$F18,$C31,$F31,$C48,$F48,$C61),1))","v":2},0.33333333333333331,100,{"$f":"IF($C5=\"Min\",_xlfn.RANK.EQ(F18,($C18,$F18,$C31,$F31,$C48,$F48,$C61),0),_xlfn.RANK.EQ(F18,($C18,$F18,$C31,$F31,$C48,$F48,$C61),1))","v":5},0.83333333333333326]
["3D model [ano/ne]",4,1,{"$f":"IF($C6=\"Min\",_xlfn.RANK.EQ(C19,($C19,$F19,$C32,$F32,$C49,$F49,$C62),0),_xlfn.RANK.EQ(C19,($C19,$F19,$C32,$F32,$C49,$F49,$C62),1))","v":3},0.41666666666666669,1,{"$f":"IF($C6=\"Min\",_xlfn.RANK.EQ(F19,($C19,$F19,$C32,$F32,$C49,$F49,$C62),0),_xlfn.RANK.EQ(F19,($C19,$F19,$C32,$F32,$C49,$F49,$C62),1))","v":3},0.41666666666666669]
["Intuitivnost ",5,4,{"$f":"IF($C7=\"Min\",_xlfn.RANK.EQ(C20,($C20,$F20,$C33,$F33,$C50,$F50,$C63),0),_xlfn.RANK.EQ(C20,($C20,$F20,$C33,$F33,$C50,$F50,$C63),1))","v":5},0.55555555555555558,5,{"$f":"IF($C7=\"Min\",_xlfn.RANK.EQ(F20,($C20,$F20,$C33,$F33,$C50,$F50,$C63),0),_xlfn.RANK.EQ(F20,($C20,$F20,$C33,$F33,$C50,$F50,$C63),1))","v":7},0.77777777777777768]
["Dostupnost informací web",6,5,{"$f":"IF($C8=\"Min\",_xlfn.RANK.EQ(C21,($C21,$F21,$C34,$F34,$C51,$F51,$C64),0),_xlfn.RANK.EQ(C21,($C21,$F21,$C34,$F34,$C51,$F51,$C64),1))","v":7},0.58333333333333326,4,{"$f":"IF($C8=\"Min\",_xlfn.RANK.EQ(F21,($C21,$F21,$C34,$F34,$C51,$F51,$C64),0),_xlfn.RANK.EQ(F21,($C21,$F21,$C34,$F34,$C51,$F51,$C64),1))","v":5},0.41666666666666663]
["Kontrolní a zkušební plán",7,1,{"$f":"IF($C9=\"Min\",_xlfn.RANK.EQ(C22,($C22,$F22,$C35,$F35,$C52,$F52,$C65),0),_xlfn.RANK.EQ(C22,($C22,$F22,$C35,$F35,$C52,$F52,$C65),1))","v":3},0.16666666666666666,1,{"$f":"IF($C9=\"Min\",_xlfn.RANK.EQ(F22,($C22,$F22,$C35,$F35,$C52,$F52,$C65),0),_xlfn.RANK.EQ(F22,($C22,$F22,$C35,$F35,$C52,$F52,$C65),1))","v":3},0.16666666666666666]
["Návod",8,3,{"$f":"IF($C10=\"Min\",_xlfn.RANK.EQ(C23,($C23,$F23,$C36,$F36,$C53,$F53,$C66),0),_xlfn.RANK.EQ(C23,($C23,$F23,$C36,$F36,$C53,$F53,$C66),1))","v":6},0.16666666666666666,2,{"$f":"IF($C10=\"Min\",_xlfn.RANK.EQ(F23,($C23,$F23,$C36,$F36,$C53,$F53,$C66),0),_xlfn.RANK.EQ(F23,($C23,$F23,$C36,$F36,$C53,$F53,$C66),1))","v":4},0.1111111111111111]
[null,{"$f":"SUM(B16:B23)","v":36},null,null,{"$f":"SUM(E16:E23)","v":4.3333333333333339},null,null,{"$f":"SUM(H16:H23)","v":3.9166666666666661}]
[]
[]
["Kritérium","Pořadí dle důležitosti","Varianta C: Fieldwire",null,null,"Varianta D: Construction Manager"]
[null,null,"Hodnota","Pořadí","Body","Hodnota","Pořadí","Body"]
["Cena [Kč]",{"$f":"B3","v":1},1294,{"$f":"IF($C3=\"Min\",_xlfn.RANK.EQ(C29,($C16,$F16,$C29,$F29,$C46,$F46,$C59),0),_xlfn.RANK.EQ(C29,($C16,$F16,$C29,$F29,$C46,$F46,$C59),1))","v":4},{"$f":"$E3*D29","v":0.88888888888888884},335,{"$f":"IF($C3=\"Min\",_xlfn.RANK.EQ(F29,($C16,$F16,$C29,$F29,$C46,$F46,$C59),0),_xlfn.RANK.EQ(F29,($C16,$F16,$C29,$F29,$C46,$F46,$C59),1))","v":5},{"$f":"$E3*G29","v":1.1111111111111112}]
["Reakce podpory [Den]",{"$f":"B4","v":2},0.25,{"$f":"IF($C4=\"Min\",_xlfn.RANK.EQ(C30,($C17,$F17,$C30,$F30,$C47,$F47,$C60),0),_xlfn.RANK.EQ(C30,($C17,$F17,$C30,$F30,$C47,$F47,$C60),1))","v":6},1.1666666666666667,7,{"$f":"IF($C4=\"Min\",_xlfn.RANK.EQ(F30,($C17,$F17,$C30,$F30,$C47,$F47,$C60),0),_xlfn.RANK.EQ(F30,($C17,$F17,$C30,$F30,$C47,$F47,$C60),1))","v":1},0.19444444444444445]
["Počet stažení v mobilu [tis]",3,500,{"$f":"IF($C5=\"Min\",_xlfn.RANK.EQ(C31,($C18,$F18,$C31,$F31,$C48,$F48,$C61),0),_xlfn.RANK.EQ(C31,($C18,$F18,$C31,$F31,$C48,$F48,$C61),1))","v":6},1,50,{"$f":"IF($C5=\"Min\",_xlfn.RANK.EQ(F31,($C18,$F18,$C31,$F31,$C48,$F48,$C61),0),_xlfn.RANK.EQ(F31,($C18,$F18,$C31,$F31,$C48,$F48,$C61),1))","v":2},0.33333333333333331]
["3D model [ano/ne]",4,1,{"$f":"IF($C6=\"Min\",_xlfn.RANK.EQ(C32,($C19,$F19,$C32,$F32,$C49,$F49,$C62),0),_xlfn.RANK.EQ(C32,($C19,$F19,$C32,$F32,$C49,$F49,$C62),1))","v":3},0.41666666666666669,0,{"$f":"IF($C6=\"Min\",_xlfn.RANK.EQ(F32,($C19,$F19,$C32,$F32,$C49,$F49,$C62),0),_xlfn.RANK.EQ(F32,($C19,$F19,$C32,$F32,$C49,$F49,$C62),1))","v":1},0.1388888888888889]
["Intuitivnost ",5,2,{"$f":"IF($C7=\"Min\",_xlfn.RANK.EQ(C33,($C20,$F20,$C33,$F33,$C50,$F50,$C63),0),_xlfn.RANK.EQ(C33,($C20,$F20,$C33,$F33,$C50,$F50,$C63),1))","v":3},0.33333333333333331,1,{"$f":"IF($C7=\"Min\",_xlfn.RANK.EQ(F33,($C20,$F20,$C33,$F33,$C50,$F50,$C63),0),_xlfn.RANK.EQ(F33,($C20,$F20,$C33,$F33,$C50,$F50,$C63),1))","v":1},0.1111111111111111]
["Dostupnost informací web",6,3,{"$f":"IF($C8=\"Min\",_xlfn.RANK.EQ(C34,($C21,$F21,$C34,$F34,$C51,$F51,$C64),0),_xlfn.RANK.EQ(C34,($C21,$F21,$C34,$F34,$C51,$F51,$C64),1))","v":4},0.33333333333333331,1,{"$f":"IF($C8=\"Min\",_xlfn.RANK.EQ(F34,($C21,$F21,$C34,$F34,$C51,$F51,$C64),0),_xlfn.RANK.EQ(F34,($C21,$F21,$C34,$F34,$C51,$F51,$C64),1))","v":1},8.3333333333333329E-2]
["Kontrolní a zkušební plán",7,1,{"$f":"IF($C9=\"Min\",_xlfn.RANK.EQ(C35,($C22,$F22,$C35,$F35,$C52,$F52,$C65),0),_xlfn.RANK.EQ(C35,($C22,$F22,$C35,$F35,$C52,$F52,$C65),1))","v":3},0.16666666666666666,1,{"$f":"IF($C9=\"Min\",_xlfn.RANK.EQ(F35,($C22,$F22,$C35,$F35,$C52,$F52,$C65),0),_xlfn.RANK.EQ(F35,($C22,$F22,$C35,$F35,$C52,$F52,$C65),1))","v":3},0.16666666666666666]
["Návod",8,1,{"$f":"IF($C10=\"Min\",_xlfn.RANK.EQ(C36,($C23,$F23,$C36,$F36,$C53,$F53,$C66),0),_xlfn.RANK.EQ(C36,($C23,$F23,$C36,$F36,$C53,$F53,$C66),1))","v":2},5.5555555555555552E-2,0,{"$f":"IF($C10=\"Min\",_xlfn.RANK.EQ(F36,($C23,$F23,$C36,$F36,$C53,$F53,$C66),0),_xlfn.RANK.EQ(F36,($C23,$F23,$C36,$F36,$C53,$F53,$C66),1))","v":1},2.7777777777777776E-2]
[null,{"$f":"SUM(B29:B36)","v":36},null,null,{"$f":"SUM(E29:E36)","v":4.3611111111111107},null,null,{"$f":"SUM(H29:H36)","v":2.1666666666666665}]
[]
[]
[]
[]
[]
[]
["Kritérium","Pořadí dle důležitosti","Varianta E: Mobile Field Manager",null,null,"Varianta F: PlanGrid"]
[null,null,"Hodnota","Pořadí","Body","Hodnota","Pořadí","Body"]
["Cena [Kč]",{"$f":"B3","v":1},0,{"$f":"IF($C3=\"Min\",_xlfn.RANK.EQ(C46,($C16,$F16,$C29,$F29,$C46,$F46,$C59),0),_xlfn.RANK.EQ(C46,($C16,$F16,$C29,$F29,$C46,$F46,$C59),1))","v":6},{"$f":"$E3*D46","v":1.3333333333333333},1316,{"$f":"IF($C3=\"Min\",_xlfn.RANK.EQ(F46,($C16,$F16,$C29,$F29,$C46,$F46,$C59),0),_xlfn.RANK.EQ(F46,($C16,$F16,$C29,$F29,$C46,$F46,$C59),1))","v":3},{"$f":"$E3*G46","v":0.66666666666666663}]
["Reakce podpory [Den]",{"$f":"B4","v":2},8.3000000000000004E-2,{"$f":"IF($C4=\"Min\",_xlfn.RANK.EQ(C47,($C17,$F17,$C30,$F30,$C47,$F47,$C60),0),_xlfn.RANK.EQ(C47,($C17,$F17,$C30,$F30,$C47,$F47,$C60),1))","v":7},1.3611111111111112,6,{"$f":"IF($C4=\"Min\",_xlfn.RANK.EQ(F47,($C17,$F17,$C30,$F30,$C47,$F47,$C60),0),_xlfn.RANK.EQ(F47,($C17,$F17,$C30,$F30,$C47,$F47,$C60),1))","v":3},0.58333333333333337]
["Počet stažení v mobilu [tis]",3,50,{"$f":"IF($C5=\"Min\",_xlfn.RANK.EQ(C48,($C18,$F18,$C31,$F31,$C48,$F48,$C61),0),_xlfn.RANK.EQ(C48,($C18,$F18,$C31,$F31,$C48,$F48,$C61),1))","v":2},0.33333333333333331,500,{"$f":"IF($C5=\"Min\",_xlfn.RANK.EQ(F48,($C18,$F18,$C31,$F31,$C48,$F48,$C61),0),_xlfn.RANK.EQ(F48,($C18,$F18,$C31,$F31,$C48,$F48,$C61),1))","v":6},1]
["3D model [ano/ne]",4,1,{"$f":"IF($C6=\"Min\",_xlfn.RANK.EQ(C49,($C19,$F19,$C32,$F32,$C49,$F49,$C62),0),_xlfn.RANK.EQ(C49,($C19,$F19,$C32,$F32,$C49,$F49,$C62),1))","v":3},0.41666666666666669,1,{"$f":"IF($C6=\"Min\",_xlfn.RANK.EQ(F49,($C19,$F19,$C32,$F32,$C49,$F49,$C62),0),_xlfn.RANK.EQ(F49,($C19,$F19,$C32,$F32,$C49,$F49,$C62),1))","v":3},0.41666666666666669]
["Intuitivnost ",5,1,{"$f":"IF($C7=\"Min\",_xlfn.RANK.EQ(C50,($C20,$F20,$C33,$F33,$C50,$F50,$C63),0),_xlfn.RANK.EQ(C50,($C20,$F20,$C33,$F33,$C50,$F50,$C63),1))","v":1},0.1111111111111111,4,{"$f":"IF($C7=\"Min\",_xlfn.RANK.EQ(F50,($C20,$F20,$C33,$F33,$C50,$F50,$C63),0),_xlfn.RANK.EQ(F50,($C20,$F20,$C33,$F33,$C50,$F50,$C63),1))","v":5},0.55555555555555558]
["Dostupnost informací web",6,2,{"$f":"IF($C8=\"Min\",_xlfn.RANK.EQ(C51,($C21,$F21,$C34,$F34,$C51,$F51,$C64),0),_xlfn.RANK.EQ(C51,($C21,$F21,$C34,$F34,$C51,$F51,$C64),1))","v":2},0.16666666666666666,2,{"$f":"IF($C8=\"Min\",_xlfn.RANK.EQ(F51,($C21,$F21,$C34,$F34,$C51,$F51,$C64),0),_xlfn.RANK.EQ(F51,($C21,$F21,$C34,$F34,$C51,$F51,$C64),1))","v":2},0.16666666666666666]
["Kontrolní a zkušební plán",7,0,{"$f":"IF($C9=\"Min\",_xlfn.RANK.EQ(C52,($C22,$F22,$C35,$F35,$C52,$F52,$C65),0),_xlfn.RANK.EQ(C52,($C22,$F22,$C35,$F35,$C52,$F52,$C65),1))","v":1},5.5555555555555552E-2,1,{"$f":"IF($C9=\"Min\",_xlfn.RANK.EQ(F52,($C22,$F22,$C35,$F35,$C52,$F52,$C65),0),_xlfn.RANK.EQ(F52,($C22,$F22,$C35,$F35,$C52,$F52,$C65),1))","v":3},0.16666666666666666]
["Návod",{"$f":"B10","v":8},1,{"$f":"IF($C10=\"Min\",_xlfn.RANK.EQ(C53,($C23,$F23,$C36,$F36,$C53,$F53,$C66),0),_xlfn.RANK.EQ(C53,($C23,$F23,$C36,$F36,$C53,$F53,$C66),1))","v":2},5.5555555555555552E-2,2,{"$f":"IF($C10=\"Min\",_xlfn.RANK.EQ(F53,($C23,$F23,$C36,$F36,$C53,$F53,$C66),0),_xlfn.RANK.EQ(F53,($C23,$F23,$C36,$F36,$C53,$F53,$C66),1))","v":4},0.1111111111111111]
[null,{"$f":"SUM(B46:B53)","v":36},null,null,{"$f":"SUM(E46:E53)","v":3.833333333333333},null,null,{"$f":"SUM(H46:H53)","v":3.6666666666666665}]
[]
[]
["Kritérium","Pořadí dle důležitosti","Varianta G: Vím o všem"]
[null,null,"Hodnota","Pořadí","Body"]
["Cena [Kč]",{"$f":"B3","v":1},2490,{"$f":"IF($C3=\"Min\",_xlfn.RANK.EQ(C59,($C16,$F16,$C29,$F29,$C46,$F46,$C59),0),_xlfn.RANK.EQ(C59,($C16,$F16,$C29,$F29,$C46,$F46,$C59),1))","v":2},{"$f":"$E3*D59","v":0.44444444444444442}]
["Reakce podpory [Den]",{"$f":"B4","v":2},7,{"$f":"IF($C4=\"Min\",_xlfn.RANK.EQ(C60,($C17,$F17,$C30,$F30,$C47,$F47,$C60),0),_xlfn.RANK.EQ(C60,($C17,$F17,$C30,$F30,$C47,$F47,$C60),1))","v":1},0.19444444444444445]
["Počet stažení v mobilu [tis]",3,1,{"$f":"IF($C5=\"Min\",_xlfn.RANK.EQ(C61,($C18,$F18,$C31,$F31,$C48,$F48,$C61),0),_xlfn.RANK.EQ(C61,($C18,$F18,$C31,$F31,$C48,$F48,$C61),1))","v":1},0.16666666666666666]
["3D model [ano/ne]",4,0,{"$f":"IF($C6=\"Min\",_xlfn.RANK.EQ(C62,($C19,$F19,$C32,$F32,$C49,$F49,$C62),0),_xlfn.RANK.EQ(C62,($C19,$F19,$C32,$F32,$C49,$F49,$C62),1))","v":1},0.1388888888888889]
["Intuitivnost ",5,2,{"$f":"IF($C7=\"Min\",_xlfn.RANK.EQ(C63,($C20,$F20,$C33,$F33,$C50,$F50,$C63),0),_xlfn.RANK.EQ(C63,($C20,$F20,$C33,$F33,$C50,$F50,$C63),1))","v":3},0.33333333333333331]
["Dostupnost informací web",6,4,{"$f":"IF($C8=\"Min\",_xlfn.RANK.EQ(C64,($C21,$F21,$C34,$F34,$C51,$F51,$C64),0),_xlfn.RANK.EQ(C64,($C21,$F21,$C34,$F34,$C51,$F51,$C64),1))","v":5},0.41666666666666663]
["Kontrolní a zkušební plán",7,0,{"$f":"IF($C9=\"Min\",_xlfn.RANK.EQ(C65,($C22,$F22,$C35,$F35,$C52,$F52,$C65),0),_xlfn.RANK.EQ(C65,($C22,$F22,$C35,$F35,$C52,$F52,$C65),1))","v":1},5.5555555555555552E-2]
["Návod",8,3,{"$f":"IF($C10=\"Min\",_xlfn.RANK.EQ(C66,($C23,$F23,$C36,$F36,$C53,$F53,$C66),0),_xlfn.RANK.EQ(C66,($C23,$F23,$C36,$F36,$C53,$F53,$C66),1))","v":6},0.16666666666666666]
[null,{"$f":"SUM(B59:B66)","v":36},null,null,{"$f":"SUM(E59:E66)","v":1.9166666666666665}]