用电子表格(Excel)实现层次分析法(AHP)的简捷计算

树种选择经济效益社会效益生态效益技术要求按行相乘开n次方权重WiAwi经济效益1342242.21340.482052062.0705473社会效益1/311/21/20.0833330.53730.117016150.4781661生态效益1/4212110.21779160.9386173技术要求1/221/210.50.84090.183140180.76709434.5915经济效益松树杉木桉树按行相乘开n次方权重WiAwiAWi/Wi松树121/70.285710.6586340.1570.49876553.1769282杉木1/211/40.1250.50.11920.37863643.1769282桉树741283.0365890.72382.29952643.17692824.1952233.1769282社会效益松树杉木桉树按行相乘开n次方权重WiAwiAWi/Wi松树11/21/50.10.4641590.1220.36651143.0036946杉木211/30.666670.873580.22970.68980083.0036946桉树531152.4662120.64831.94738243.00369463.8039513.0036946生态效益松树杉木桉树按行相乘开n次方权重WiAwiAWi/Wi松树12361.8171210.52781.61181183.0536216杉木1/2131.51.1447140.33251.01537783.0536216桉树1/31/310.111110.480750.13960.42643203.05362163.4425853.0536216技术要求松树杉木桉树按行相乘开n次方权重WiAwiAWi/Wi松树11/2631.442250.38061.19356473.1356108杉木214820.52791.65514313.1356108桉树1/61/410.041670.3466810.09150.28690303.13561083.788933.1356108四准则ai经济效益社会效益生态效益技术要求三方案bin0.48210.1170160.2177920.18314松树0.1570.122020.5278360.38065杉木0.11920.2296510.3325160.52785准则层对于目标层的判断矩阵及单排序和一致性检验方案层对于经济效益准则的判断矩阵及单排序和一致性检验方案层对于生态效益准则的判断矩阵及单排序和一致性检验方案层对于社会效益准则的判断矩阵及单排序和一致性检验层次总排序计算aibin方案层对于技术要求准则的判断矩阵及单排序和一致性检验桉树0.72380.6483290.1396480.0915CIi0.08850.0018470.0268110.06781CI=∑aiCIiRI=∑aiRIiCR=CI/RIRIi0.51490.51490.51490.5149#DIV/0!Cri0.17010.0035880.052070.131690.117885599层次总排序一致性检验AWi/Wi4.29527744.08632524.30970374.18856380.073320.0820994.21996750.0884641210.170120.0018472990.003590.0268107880.052070.0678054220.13169总排序Σaibin准则层对于目标层的判断矩阵及单排序和一致性检验方案层对于经济效益准则的判断矩阵及单排序和一致性检验CI=(入-n）/(n-1)CR=CI/RI方案层对于生态效益准则的判断矩阵及单排序和一致性检验方案层对于社会效益准则的判断矩阵及单排序和一致性检验CI=(入-n）/(n-1)CR=CI/RICI=(入-n）/(n-1)CR=CI/RI层次总排序计算CI=(入-n）/(n-1)CR=CI/RI方案层对于技术要求准则的判断矩阵及单排序和一致性检验CI=(入-n）/(n-1)CR=CI/RI层次总排序一致性检验