income (USD)	housing expediture (%)	employment rate (%)	life expectancy	homicide rate		
Czech Republik	21103	24	72	78.7	0.8		
Austria	32544	21	72	81.3	0.4		
Germany	33652	20	75	80.7	0.4		
Poland	18906	23	65	76.7	0.8		
Slovak Republic	20256	24	65	77.6	1.3		
							
							
							
	income (USD)	housing expediture (%)	employment rate (%)	life expectancy	homicide rate	total	weights
income (USD)	1	1	0	1	1	4	0.266666667
housing expediture (%)		1	1	1	1	4	0.266666667
employment rate (%)	1		1	1	1	4	0.266666667
life expectancy				1	1	2	0.133333333
homicide rate					1	1	0.066666667
					total	15	
							
							
0.266666667							
0.266666667							
0.266666667							
0.133333333							
0.066666667							
	mAX	MIN	MAX	MAX	MIN		
	income (USD)	housing expediture (%)	employment rate (%)	life expectancy	homicide rate		
Czech Republik	21103	24	72	78.7	0.8		
Austria	32544	21	72	81.3	0.4		
Germany	33652	20	75	80.7	0.4		
Poland	18906	23	65	76.7	0.8		
Slovak Republic	20256	24	65	77.6	1.3		
weights	0.266666667	0.266666667	0.266666667	0.133333333	0.066666667		
min 	18906	20	65	76.7	0.4		
max	33652	24	75	81.3	1.3		ideal
							
utility							
							
	mAX	MIN	MAX	MAX	MIN	total utility	ranking
	income (USD)	housing expediture (%)	employment rate (%)	life expectancy	homicide rate		
Czech Republik	0.148989556	0	0.7	0.434782609	0.555555556	0.321405267	3
Austria	0.924860979	0.75	0.7	1	1	0.833296261	2
Germany	1	1	1	0.869565217	1	0.982608696	1
Poland	0	0.25	0	0	0.555555556	0.103703704	4
Slovak Republic	0.091550251	0	0	0.195652174	0	0.050500357	5
weights	0.266666667	0.266666667	0.266666667	0.133333333	0.066666667		
##### Sheet/List 2 #####
	income (USD)	housing expediture (%)	employment rate (%)	life expectancy	homicide rate		
Czech Republik	21103	24	72	78.7	0.8		
Austria	32544	21	72	81.3	0.4		
Germany	33652	20	75	80.7	0.4		
Poland	18906	23	65	76.7	0.8		
Slovak Republic	20256	24	65	77.6	1.3		
sumsqrs	=SUMA.ČTVERCŮ(B2:B6)	=SUMA.ČTVERCŮ(C2:C6)	=SUMA.ČTVERCŮ(D2:D6)	=SUMA.ČTVERCŮ(E2:E6)	=SUMA.ČTVERCŮ(F2:F6)		
norm	=ODMOCNINA(B7)	=ODMOCNINA(C7)	=ODMOCNINA(D7)	=ODMOCNINA(E7)	=ODMOCNINA(F7)		
							
normalized values							
							
	income (USD)	housing expediture (%)	employment rate (%)	life expectancy	homicide rate		
Czech Republik	=B2/B$8	=C2/C$8	=D2/D$8	=E2/E$8	=F2/F$8		
Austria	=B3/B$8	=C3/C$8	=D3/D$8	=E3/E$8	=F3/F$8		
Germany	=B4/B$8	=C4/C$8	=D4/D$8	=E4/E$8	=F4/F$8		
Poland	=B5/B$8	=C5/C$8	=D5/D$8	=E5/E$8	=F5/F$8		
Slovak Republic	=B6/B$8	=C6/C$8	=D6/D$8	=E6/E$8	=F6/F$8		
sumsqrs	=SUMA.ČTVERCŮ(B13:B17)	=SUMA.ČTVERCŮ(C13:C17)	=SUMA.ČTVERCŮ(D13:D17)	=SUMA.ČTVERCŮ(E13:E17)	=SUMA.ČTVERCŮ(F13:F17)		
norm	=ODMOCNINA(B18)	=ODMOCNINA(C18)	=ODMOCNINA(D18)	=ODMOCNINA(E18)	=ODMOCNINA(F18)		
weights	0.266666666666667	0.266666666666667	0.266666666666667	0.133333333333333	0.0666666666666667		
							
							
weighted values							
	income (USD)	housing expediture (%)	employment rate (%)	life expectancy	homicide rate		
Czech Republik	=B13*B$20	=C13*C$20	=D13*D$20	=E13*E$20	=F13*F$20		
Austria	=B14*B$20	=C14*C$20	=D14*D$20	=E14*E$20	=F14*F$20		
Germany	=B15*B$20	=C15*C$20	=D15*D$20	=E15*E$20	=F15*F$20		
Poland	=B16*B$20	=C16*C$20	=D16*D$20	=E16*E$20	=F16*F$20		
Slovak Republic	=B17*B$20	=C17*C$20	=D17*D$20	=E17*E$20	=F17*F$20		
best	=MAX(B25:B29)	=MIN(C25:C29)	=MAX(D25:D29)	=MAX(E25:E29)	=MIN(F25:F29)		
worst	=MIN(B25:B29)	=MAX(C25:C29)	=MIN(D25:D29)	=MIN(E25:E29)	=MAX(F25:F29)		
distance to the best		d+		distance to the worst	d-	index ci	
Czech Republik	"=SUMXMY2(B25:F25,B$30:F$30)"	=ODMOCNINA(B33)		"=SUMXMY2(B25:F25,B$31:F$31)"	=ODMOCNINA(E33)	=F33/(C33+F33)	3
Austria	"=SUMXMY2(B26:F26,B$30:F$30)"	=ODMOCNINA(B34)		"=SUMXMY2(B26:F26,B$31:F$31)"	=ODMOCNINA(E34)	=F34/(C34+F34)	2
Germany	"=SUMXMY2(B27:F27,B$30:F$30)"	=ODMOCNINA(B35)		"=SUMXMY2(B27:F27,B$31:F$31)"	=ODMOCNINA(E35)	=F35/(C35+F35)	1
Poland	"=SUMXMY2(B28:F28,B$30:F$30)"	=ODMOCNINA(B36)		"=SUMXMY2(B28:F28,B$31:F$31)"	=ODMOCNINA(E36)	=F36/(C36+F36)	4
Slovak Republic	"=SUMXMY2(B29:F29,B$30:F$30)"	=ODMOCNINA(B37)		"=SUMXMY2(B29:F29,B$31:F$31)"	=ODMOCNINA(E37)	=F37/(C37+F37)	5