AHPSoftware.xlsx

	C	D	G	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU
1								Initial Comparisons Matrix (K=1)																		K=2
2		Number of Criteria						Initial Comparisons Matrix (K=1)												SUM	Weights of Criteria					K=2												SUM	Weights of Criteria
3		Number of Criteria	4		A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	SUM	Weights of Criteria		A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	SUM	Weights of Criteria
4				A	1	2.5	4	2												9.50000	0.4546113689	A	4.0000	8.0545	17.5417	10.1250												39.72121	0.4659653014
5				B	0.4000	1	2.75	1.25												5.40000	0.2584106729	B	2.1125	4.0000	8.7667	5.3625												20.24167	0.2374528320
6				C	0.2500	0.3636	1	0.75												2.36364	0.1131090487	C	1.0205	1.9523	4.0000	2.4545												9.42727	0.1105903305
7				D	0.5000	0.8000	1.3333	1												3.63333	0.1738689095	D	1.6533	3.3348	6.8667	4.0000												15.85485	0.1859915360
8				E	0.0000	0.0000	0.0000	0.0000												0.00000	0.0000000000	E																0.00000	0.0000000000
9				F	0.0000	0.0000	0.0000	0.0000	0.0000											0.00000	0.0000000000	F																0.00000	0.0000000000
10				G	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000										0.00000	0.0000000000	G																0.00000	0.0000000000
11				H	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000									0.00000	0.0000000000	H																0.00000	0.0000000000
12				I	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000								0.00000	0.0000000000	I																0.00000	0.0000000000
13				J	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000							0.00000	0.0000000000	J																0.00000	0.0000000000
14				K	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000						0.00000	0.0000000000	K																0.00000	0.0000000000
15				L	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000					0.00000	0.0000000000	L																0.00000	0.0000000000
16	Notice that we use MMULT function in this file. The formula must be entered as an array formula. For this formula, you should press CTRL+SHIFT+ENTER with together.			M	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000				0.00000	0.0000000000	M																0.00000	0.0000000000
17				N	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000			0.00000	0.0000000000	N																0.00000	0.0000000000
18				O	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000		0.00000	0.0000000000	O																0.00000	0.0000000000
19
20																			SUM	20.89697	1.0000000																SUM	85.24500	1.0000000
21
22
23				Criteria	Weights of Criteria										ABS(K100-K1)
24				Criteria	K=1	K=2	K=3	K=4	K=5	K=10	K=20	K=50	K=100		ABS(K100-K1)
25				A	0.4546113689	0.4659653014	0.4634219135	0.4632689067	0.4633047890	0.4633063878	0.4633063877	0.4633063877	0.4633063877		0.0086950188
26				B	0.2584106729	0.2374528320	0.2375177331	0.2378086041	0.2378075227	0.2378035120	0.2378035121	0.2378035121	0.2378035121		0.0206071608
27				C	0.1131090487	0.1105903305	0.1120066196	0.1120419891	0.1120219965	0.1120217967	0.1120217968	0.1120217968	0.1120217968		0.0010872519
28				D	0.1738689095	0.1859915360	0.1870537338	0.1868805001	0.1868656918	0.1868683035	0.1868683035	0.1868683035	0.1868683035		0.0129993940
29				E	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000		0.0000000000
30				F	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000		0.0000000000					COMPARE WITH 0.1; IT SHOULD BE LESS THAN 0.1.
31				G	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000		0.0000000000		Consistency Ratio (K=100)		0.0211151
32				H	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000		0.0000000000
33				I	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000		0.0000000000
34				J	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000		0.0000000000
35				K	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000		0.0000000000
36				L	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000		0.0000000000
37				M	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000		0.0000000000
38				N	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000		0.0000000000
39				O	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000	0.0000000000		0.0000000000
40
41
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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132