AHP Analytic Hierarchy Process X4 X X4 X4 X4
a b c d AHP 00 ad4 6 2
a b c a b c a b c d 5.5 2 d d a b 5 a c.5 ad 2 6 3
a b a b c d 5.5 2 0.25 c.5 d a a b c d 5.5 2 a a b c d 5.5 2 b c 0.25.5 b c 0.2 2/3 0.25 4.5 d d 2 2/3 a a x/x ab5 ba0.2 4
a b c d 4 2 4 4 5 6 00! a 5.5 2 5 =.968 4.683 00 = b 0.2 0.25 0.025 = 0.398 4.683 00 = c 2/3 4.5 = 4.44 4.683 00 = d 2 2/3 0.666 = 0.904 4.683 00 = 4.683 a b 3 c d a42 b8.5 C30.2 d9.3 a40 b 5
a 42.0 40 8.5 0 30.2 30 9.3 20 b c d 6
a b c d a b c d 0.2 2/3 5.5 2 = 0.25 = 4.5 = 2 2/3 = 2 4 5 4 00 5 0.025 4 0.666 3.968 0.398.44 0.904 4.683 4.683 4.683 4.683 00 = 00 = 4.683 00 = 6! 00 = 42.0 8.5 30.2 9.3 4 a 5.5 2 a 4 a ad a b c d 2 4 a 5.5 2 = 5.968 a ( )4 5.5 2 4 ( ) 4 ( ) 5.5 2 4.968 a(d) 7
a b c d a b c d 0.2 2/3 5.5 2 = 0.25 = 4.5 = 2 2/3 = 2 4 5 4 00 5 0.025 4 0.666 3.968 0.398.44 0.904 4.683 4.683 4.683 4.683 00 = 00 = 4.683 00 = 6! 00 = 42.0 8.5 30.2 9.3 ad.968 0.398.44 0.904 (00 ) 42.0 8.5 20.2 9.3 8
a40 b 6 ad 6 ( ) a b c d a b c d 9
4 AHP J-pop 4 X 77 4 2 sqrt / A B C a TUBE b c d B z 2 4 5 4 00 6! a b TUBE 2 = 3 2 = 0 5 00 c = 0. 0.25 0.0083 0.333 3.36 3.62 0.302 5.575 5.575 5.575 00 = 00 = 00 = % % % B z d 0.2 4 = 0.4000 0.795 5.575 00 = % 3 5.575 00 0
8 999628or7 AHP 4 2 sqrt / A B C a b c d 2 4 5 4 00 6! a = 00 = % b = 00 = % c = 00 = % d = 00 = % 3 00
2 AHP AHP2 A -D 4 AHP A B AHP 5 AHP 4 A B C D A B C D A B C D 2 2 2 2 2 A B C D 2 0.33 3 0.33 3 3 4 0.33 0.25 A B C D 2 0.33 0.33 0.25 3 4 3 2 A B C D A B C D 3 5 2 0.33 2 0.33 3 4 0.2 0.25 A B C D A B C D X
X AHP 4 AHP A-D (A-D ) A-D X X X4 X X4 X4 X4 3
X AHP 4
X B X X C X (C ) X B B X 5
X C D B X4 X X4 X4 B X4 C X C 6
7 B X X X X X X A CD B B ( P4) B Yes =+IF(MAX(O4:O7)=+O5,"Yes","No")
B ( ) OK B X B 8
4 AHP AHP 2 Excel AHP AHP 9
AHP Microsoft Excel 20
Ctrl 2
22
6 2 2 OK 23
6 DELETE 4 (A H6 ) A8 A5A22A29 AHP 5 24
5 AHP 25
X OK A-D 26
J2 B 27
J3 N7 28
( ) 29
B X D C X C 30
( ) (A -D ) AHP :.2 0.9 3 5 OK 3