{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["linear","non-linear","Intro"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"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":"linear","index":0,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":false,"merged":[[22,10,24,10],[22,11,24,11],[22,12,24,12],[22,13,24,13]]}
[null,"Váha","Firma 1","Firma 2","Firma 3","Firma 4","Body 1","Body 2","Body 3","Body 4","RESULTS 1","RESULTS 2","RESULTS 3","RESULTS 4","Prokázání","Zdůvodnění"]
["Cena přístroje",null,500000,600000,550000,260000,{"$f":"(IF(1-((C2-MIN($C2:$F2))/MIN($C2:$F2))<0,0,1-((C2-MIN($C2:$F2))/MIN($C2:$F2))))*100","v":7.6923076923076872},0,0,100,{"$f":"IF($B2=\"\",\"\",$B2*G2)","v":""},{"$f":"IF($B2=\"\",\"\",$B2*H2)","v":""},{"$f":"IF($B2=\"\",\"\",$B2*I2)","v":""},{"$f":"IF($B2=\"\",\"\",$B2*J2)","v":""}]
["Cena 1 ks příslušenství",null,300,330,390,420,100,90,70,60,"","","",""]
["Cena PBTK",null,0,0,0,10000,100,100,100,0,"","","",""]
["Jednoduchost použití",null,"ANO","ANO","NE","ANO",{"$f":"(IF(C5=\"ANO\",100%,0%))*100","v":100},{"$f":"(IF(D5=\"ANO\",100%,0%))*100","v":100},{"$f":"(IF(E5=\"ANO\",100%,0%))*100","v":0},{"$f":"(IF(F5=\"ANO\",100%,0%))*100","v":100},"","","",""]
["Vědecká evidence – délka evidence v letech",null,10,12,2,4,{"$f":"(C6/MAX($C6:$F6))*100","v":83.333333333333343},{"$f":"(D6/MAX($C$6:$F$6))*100","v":100},{"$f":"(E6/MAX($C$6:$F$6))*100","v":16.666666666666664},{"$f":"(F6/MAX($C$6:$F$6))*100","v":33.333333333333329},"","","",""]
["Zkrácení doby léčby pacienta ve dnech",null,1,2,0,1,{"$f":"(C7/MAX($C7:$F7))*100","v":50},{"$f":"(D7/MAX($C7:$F7))*100","v":100},0,50,"","","",""]
["Vědecká evidence – survival rate",null,0.95,0.98,0.98,0.95,{"$f":"(C8/MAX($C8:$F8))*100","v":96.938775510204081},100,100,96.938775510204081,"","","",""]
["Doba použití u výkonu (min)",null,30,25,30,60,{"$f":"(IF(1-((C9-MIN($C9:$F9))/MIN($C9:$F9))<0,0,1-((C9-MIN($C9:$F9))/MIN($C9:$F9))))*100","v":80},100,80,0,"","","",""]
["Trénink lékařů",null,0,0,10000,10000,{"$f":"IF(MIN($C10:$F10)=0,IF(C10=0,100,0),(C10-MIN($C10:$F10))/MIN($C10:$F10))","v":100},{"$f":"IF(MIN($C10:$F10)=0,IF(D10=0,100,0),(D10-MIN($C10:$F10))/MIN($C10:$F10))","v":100},{"$f":"IF(MIN($C10:$F10)=0,IF(E10=0,100,0),(E10-MIN($C10:$F10))/MIN($C10:$F10))","v":0},{"$f":"IF(MIN($C10:$F10)=0,IF(F10=0,100,0),(F10-MIN($C10:$F10))/MIN($C10:$F10))","v":0},"","","",""]
["Společensky prospěšné aktivity",null,"ANO","ANO","NE ","NE",{"$f":"(IF(C11=\"ANO\",100%,0%))*100","v":100},{"$f":"(IF(D11=\"ANO\",100%,0%))*100","v":100},{"$f":"(IF(E11=\"ANO\",100%,0%))*100","v":0},{"$f":"(IF(F11=\"ANO\",100%,0%))*100","v":0},"","","",""]
["Náhradní díly",null,2000,2000,10000,50000,{"$f":"(IF(1-((C12-MIN($C12:$F12))/MIN($C12:$F12))<0,0,1-((C12-MIN($C12:$F12))/MIN($C12:$F12))))*100","v":100},100,0,0,"","","",""]
["Dodací doba (dny)",null,2,1,2,1,0,100,0,100,"","","",""]
["Etické chování firmy",null,"ANO","ANO","NE","ANO",{"$f":"(IF(C14=\"ANO\",100%,0%))*100","v":100},100,0,100,"","","",""]
["Ekologické zaměření firmy",null,"ANO","ANO","NE ","NE",100,100,0,0,"","","",""]
["Upgrady zdarma",null,"ANO","ANO","ANO","ANO",100,100,100,100,"","","",""]
["Náročnost obsluhy",null,"malá","malá","střední","velká",100,100,50,0,"","","",""]
["Spotřeba el. energie (kWh)",null,6,5,12,20,{"$f":"(IF(1-((C18-MIN($C18:$F18))/MIN($C18:$F18))<0,0,1-((C18-MIN($C18:$F18))/MIN($C18:$F18))))*100","v":80},{"$f":"(IF(1-((D18-MIN($C18:$F18))/MIN($C18:$F18))<0,0,1-((D18-MIN($C18:$F18))/MIN($C18:$F18))))*100","v":100},{"$f":"(IF(1-((E18-MIN($C18:$F18))/MIN($C18:$F18))<0,0,1-((E18-MIN($C18:$F18))/MIN($C18:$F18))))*100","v":0},{"$f":"(IF(1-((F18-MIN($C18:$F18))/MIN($C18:$F18))<0,0,1-((F18-MIN($C18:$F18))/MIN($C18:$F18))))*100","v":0},"","","",""]
["Bezpečné použití",null,"ANO","ANO","ANO","ANO",{"$f":"(IF(C19=\"ANO\",100%,0%))*100","v":100},100,100,100,"","","",""]
["Zařazení příslušenství v číselníku VZP",null,"ANO","ANO","NE","NE",100,100,0,0,"","","",""]
["Rehospitalizace pacienta do 1 roku",null,0.03,0.01,0.01,0.05,{"$f":"(IF(1-((C21-MIN($C21:$F21))/MIN($C21:$F21))<0,0,1-((C21-MIN($C21:$F21))/MIN($C21:$F21))))*100","v":0},{"$f":"(IF(1-((D21-MIN($C21:$F21))/MIN($C21:$F21))<0,0,1-((D21-MIN($C21:$F21))/MIN($C21:$F21))))*100","v":100},{"$f":"(IF(1-((E21-MIN($C21:$F21))/MIN($C21:$F21))<0,0,1-((E21-MIN($C21:$F21))/MIN($C21:$F21))))*100","v":100},{"$f":"(IF(1-((F21-MIN($C21:$F21))/MIN($C21:$F21))<0,0,1-((F21-MIN($C21:$F21))/MIN($C21:$F21))))*100","v":0},"","","",""]
["CELKEM",{"$f":"SUM(B2:B21)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(K2:K21)","v":0},{"$f":"SUM(L2:L21)","v":0},{"$f":"SUM(M2:M21)","v":0},{"$f":"SUM(N2:N21)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"RANK(K22,$K$22:$N$22)","v":1},{"$f":"RANK(L22,$K$22:$N$22)","v":1},{"$f":"RANK(M22,$K$22:$N$22)","v":1},{"$f":"RANK(N22,$K$22:$N$22)","v":1}]
[]
["Celkové náklady",null,{"$f":"400*5*C3+C2","v":1100000},{"$f":"400*5*D3+D2","v":1260000},{"$f":"400*5*E3+E2","v":1330000},{"$f":"400*5*F3+F2","v":1100000}]

{"sheet":"non-linear","index":1,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":false,"merged":[[22,10,24,10],[22,11,24,11],[22,12,24,12],[22,13,24,13]]}
[null,"Váha","Firma 1","Firma 2","Firma 3","Firma 4","Body 1","Body 2","Body 3","Body 4","RESULTS 1","RESULTS 2","RESULTS 3","RESULTS 4","Prokázání","Zdůvodnění"]
["Cena přístroje",null,500000,600000,550000,260000,{"$f":"MIN($C2:$F2)/C2*100","v":52},43.333333333333336,47.272727272727273,100,{"$f":"IF($B2=\"\",\"\",$B2*G2)","v":""},{"$f":"IF($B2=\"\",\"\",$B2*H2)","v":""},{"$f":"IF($B2=\"\",\"\",$B2*I2)","v":""},{"$f":"IF($B2=\"\",\"\",$B2*J2)","v":""}]
["Cena 1 ks příslušenství",null,300,330,390,420,100,90.909090909090907,76.923076923076934,71.428571428571431,"","","",""]
["Cena PBTK",null,0,0,0,10000,{"$f":"IF(MIN($C4:$F4)=0,IF(C4=0,100,0),(MIN($C4:$F4))/C4)","v":100},{"$f":"IF(MIN($C4:$F4)=0,IF(D4=0,100,0),(MIN($C4:$F4))/D4)","v":100},{"$f":"IF(MIN($C4:$F4)=0,IF(E4=0,100,0),(MIN($C4:$F4))/E4)","v":100},{"$f":"IF(MIN($C4:$F4)=0,IF(F4=0,100,0),(MIN($C4:$F4))/F4)","v":0},"","","",""]
["Jednoduchost použití",null,"ANO","ANO","NE","ANO",{"$f":"(IF(C5=\"ANO\",100%,0%))*100","v":100},{"$f":"(IF(D5=\"ANO\",100%,0%))*100","v":100},{"$f":"(IF(E5=\"ANO\",100%,0%))*100","v":0},{"$f":"(IF(F5=\"ANO\",100%,0%))*100","v":100},"","","",""]
["Vědecká evidence – délka evidence v letech",null,10,12,2,4,{"$f":"(C6/MAX($C6:$F6))*100","v":83.333333333333343},{"$f":"(D6/MAX($C$6:$F$6))*100","v":100},{"$f":"(E6/MAX($C$6:$F$6))*100","v":16.666666666666664},{"$f":"(F6/MAX($C$6:$F$6))*100","v":33.333333333333329},"","","",""]
["Zkrácení doby léčby pacienta ve dnech",null,1,2,0,1,{"$f":"(C7/MAX($C7:$F7))*100","v":50},{"$f":"(D7/MAX($C7:$F7))*100","v":100},0,50,"","","",""]
["Vědecká evidence – survival rate",null,0.95,0.98,0.98,0.95,{"$f":"(C8/MAX($C8:$F8))*100","v":96.938775510204081},100,100,96.938775510204081,"","","",""]
["Doba použití u výkonu (min)",null,30,25,30,60,{"$f":"MIN($C9:$F9)/C9*100","v":83.333333333333343},{"$f":"MIN($C9:$F9)/D9*100","v":100},{"$f":"MIN($C9:$F9)/E9*100","v":83.333333333333343},{"$f":"MIN($C9:$F9)/F9*100","v":41.666666666666671},"","","",""]
["Trénink lékařů",null,0,0,10000,10000,{"$f":"IF(MIN($C10:$F10)=0,IF(C10=0,100,0),(MIN($C10:$F10))/C10)","v":100},{"$f":"IF(MIN($C10:$F10)=0,IF(D10=0,100,0),(MIN($C10:$F10))/D10)","v":100},{"$f":"IF(MIN($C10:$F10)=0,IF(E10=0,100,0),(MIN($C10:$F10))/E10)","v":0},{"$f":"IF(MIN($C10:$F10)=0,IF(F10=0,100,0),(MIN($C10:$F10))/F10)","v":0},"","","",""]
["Společensky prospěšné aktivity",null,"ANO","ANO","NE ","NE",{"$f":"(IF(C11=\"ANO\",100%,0%))*100","v":100},{"$f":"(IF(D11=\"ANO\",100%,0%))*100","v":100},{"$f":"(IF(E11=\"ANO\",100%,0%))*100","v":0},{"$f":"(IF(F11=\"ANO\",100%,0%))*100","v":0},"","","",""]
["Náhradní díly",null,2000,2000,10000,50000,{"$f":"MIN($C12:$F12)/C12*100","v":100},{"$f":"MIN($C12:$F12)/D12*100","v":100},{"$f":"MIN($C12:$F12)/E12*100","v":20},{"$f":"MIN($C12:$F12)/F12*100","v":4},"","","",""]
["Dodací doba (dny)",null,2,1,2,1,{"$f":"IF(MIN($C13:$F13)=0,IF(C13=0,100,0),(MIN($C13:$F13))/C13*100)","v":50},{"$f":"IF(MIN($C13:$F13)=0,IF(D13=0,100,0),(MIN($C13:$F13))/D13*100)","v":100},{"$f":"IF(MIN($C13:$F13)=0,IF(E13=0,100,0),(MIN($C13:$F13))/E13*100)","v":50},{"$f":"IF(MIN($C13:$F13)=0,IF(F13=0,100,0),(MIN($C13:$F13))/F13*100)","v":100},"","","",""]
["Etické chování firmy",null,"ANO","ANO","NE","ANO",{"$f":"(IF(C14=\"ANO\",100%,0%))*100","v":100},100,0,100,"","","",""]
["Ekologické zaměření firmy",null,"ANO","ANO","NE ","NE",100,100,0,0,"","","",""]
["Upgrady zdarma",null,"ANO","ANO","ANO","ANO",100,100,100,100,"","","",""]
["Náročnost obsluhy",null,"malá","malá","střední","velká",100,100,50,0,"","","",""]
["Spotřeba el. energie (kWh)",null,6,5,12,20,{"$f":"(MIN($C18:$F18)/C18)*100","v":83.333333333333343},{"$f":"(MIN($C18:$F18)/D18)*100","v":100},{"$f":"(MIN($C18:$F18)/E18)*100","v":41.666666666666671},{"$f":"(MIN($C18:$F18)/F18)*100","v":25},"","","",""]
["Bezpečné použití",null,"ANO","ANO","ANO","ANO",{"$f":"(IF(C19=\"ANO\",100%,0%))*100","v":100},100,100,100,"","","",""]
["Zařazení příslušenství v číselníku VZP",null,"ANO","ANO","NE","NE",100,100,0,0,"","","",""]
["Rehospitalizace pacienta do 1 roku",null,0.03,0.01,0.01,0.05,{"$f":"MIN($C21:$F21)/C21*100","v":33.333333333333336},{"$f":"MIN($C21:$F21)/D21*100","v":100},{"$f":"MIN($C21:$F21)/E21*100","v":100},{"$f":"MIN($C21:$F21)/F21*100","v":20},"","","",""]
["CELKEM",{"$f":"SUM(B2:B21)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(K2:K21)","v":0},{"$f":"SUM(L2:L21)","v":0},{"$f":"SUM(M2:M21)","v":0},{"$f":"SUM(N2:N21)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"RANK(K22,$K$22:$N$22)","v":1},{"$f":"RANK(L22,$K$22:$N$22)","v":1},{"$f":"RANK(M22,$K$22:$N$22)","v":1},{"$f":"RANK(N22,$K$22:$N$22)","v":1}]
[]
["Celkové náklady",null,{"$f":"400*5*C3+C2","v":1100000},{"$f":"400*5*D3+D2","v":1260000},{"$f":"400*5*E3+E2","v":1330000},{"$f":"400*5*F3+F2","v":1100000}]

{"sheet":"Intro","index":2,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
["Pouze pro studijní účely!!!"]
[]
["Tento příklad je pouze teoretický a má informativní charakter. Při jeho sestavování byly brány v úvahu metody prezentované na semináři \"Jak může zavedení kvalitativních kritérií MEAT zvýšit výkonnost nemocnic\" konaném dne 7. června 2016 v Praze. Organizátoři neručí za jakékoliv škody či újmu způsobenou v důsledku použití závěrů tohoto teoretického příkladu."]