CoCoSo_upload.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	S	T
1	Material for a cryogenic storage tank for transportation of liquid nitrogen
2
3			Beneficial			Non-Beneficial					Step 2 Normalization of input decision matrix
4			Toughness Index	Yield Strength	Young's Modulus	Density	Thermal Expansion	Thermal Conductivity	Specific Heat
5	1	Al 2024-T6	75.5	420	74.2	2.8	21.4	0.37	0.16		0	0.2582417582	0.02857142857	0.9794871795	0.05511811024	0	0
6	2	Al 5052-O	95	91	70	2.68	22.1	0.33	0.16		0.02807775378	0	0	1	0	0.1129943503	0
7	3	SS 301 FH	770	1365	189	7.9	16.9	0.04	0.08		1	1	0.8095238095	0.1076923077	0.4094488189	0.9322033898	0.8
8	4	SS 310-3AH	187	1120	210	7.9	14.4	0.03	0.08		0.1605471562	0.8076923077	0.9523809524	0.1076923077	0.6062992126	0.9604519774	0.8
9	5	Ti–6Al–4V	179	875	112	4.43	9.4	0.016	0.09		0.1490280778	0.6153846154	0.2857142857	0.7008547009	1	1	0.7
10	6	Inconel 718	239	1190	217	8.51	11.5	0.31	0.07		0.2354211663	0.8626373626	1	0.003418803419	0.8346456693	0.1694915254	0.9
11	7	70Cu–30Zn	273	200	112	8.53	19.9	0.29	0.06		0.2843772498	0.08555729984	0.2857142857	0	0.1732283465	0.2259887006	1
12
13		Weights	0.28	0.14	0.05	0.24	0.19	0.05	0.05
14		Min	75.5	91	70	2.68	9.4	0.016	0.06		Step 3 Sum of the weighted comparibility matrix							Si
15		Max	770	1365	217	8.53	22.1	0.37	0.16
16											0	0.03615384615	0.001428571429	0.2350769231	0.01047244094	0	0	0.2831317816
17											0.007861771058	0	0	0.24	0	0.005649717514	0	0.2535114886
18											0.28	0.14	0.04047619048	0.02584615385	0.07779527559	0.04661016949	0.04	0.6507277894
19											0.04495320374	0.1130769231	0.04761904762	0.02584615385	0.1151968504	0.04802259887	0.04	0.4347147775
20											0.04172786177	0.08615384615	0.01428571429	0.1682051282	0.19	0.05	0.035	0.5853725504
21											0.06591792657	0.1207692308	0.05	0.0008205128205	0.1585826772	0.008474576271	0.045	0.4495649236
22											0.07962562995	0.01197802198	0.01428571429	0	0.03291338583	0.01129943503	0.05	0.2001021871
23
24											Step 4 Power of the weighted comparibility matrix
25																		Pi
26											0	0.8273393977	0.8371371164	0.9950380799	0.576561874	0	0	3.236076468
27											0.3677404991	0	0	1	0	0.8967117003	0	2.264452199
28											1	1	0.9894901637	0.5857662212	0.8439523529	0.9964959407	0.9889048329	6.404609511
29											0.5991957618	0.9705422199	0.997563465	0.5857662212	0.9093069925	0.9979844691	0.9889048329	6.049263962
30											0.5868337296	0.9342874795	0.9392832933	0.9182283932	1	1	0.982324333	6.360957229
31											0.6669860365	0.9795259749	1	0.2559350647	0.9662408792	0.9150764937	0.9947458259	5.778510275
32											0.703218938	0.708787402	0.9392832933	0	0.7167003266	0.9283341701	1	4.99632413
33										Step 5 Aggregation of Appraisal score strategies								Step 6 Final ranking of the alternatives
34
35									Ka		Rank		Kb	Rank		Kc	Rank	K	Rank
36									Pi+Si
37									3.519208249	0.09273931115	6		2.844012928	6		0.498800851	6	1.653781846	6
38									2.517963688	0.06635419145	7		2.266910134	7		0.3568877831	7	1.273951908	7
39									7.055337301	0.1859245247	1		6.080303609	1		1	1	3.463803191	1
40									6.48397874	0.1708678996	3		4.843866706	3		0.9190175414	3	2.890752113	3
41									6.946329779	0.1830519234	2		5.734417097	2		0.9845496371	2	3.311709919	2
42									6.228075198	0.1641242469	4		4.798512549	4		0.8827466261	4	2.834334856	4
43									5.196426317	0.1369379028	5		3.20641625	5		0.7365241512	5	2.046358771	5
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100