用电子表格Excel实现层次分析法AHP的简捷计算_精品文档表格文件下载.xls

用电子表格Excel实现层次分析法AHP的简捷计算_精品文档表格文件下载.xls

《用电子表格Excel实现层次分析法AHP的简捷计算_精品文档表格文件下载.xls》由会员分享，可在线阅读，更多相关《用电子表格Excel实现层次分析法AHP的简捷计算_精品文档表格文件下载.xls（17页珍藏版）》请在冰豆网上搜索。

用电子表格（Excel）实现层次分析法（AHP）的简捷计算准则层对目标层判断树种选择经济效益社会效益生态效益技术要求按行相乘开N次方权重W1经济效益1342242.2133638390.482052062社会效益1/311/21/20.0833330.5372849660.117016155生态效益1/4212110.217791604技术要求1/221/211/20.8408964150.1831401794.591545221方案层对经济效益判断经济效益松树杉木桉树按行相乘开N次方权重W1AW1松树121/70.2857140.6586340.1569961360.498765457杉木1/211/40.1250.50.1191831830.378636421桉树741283.0365890.7238206812.2995263644.195223方案层对社会效益判断社会效益松树杉木桉树按行相乘开N次方权重W1AW1松树11/21/50.10.4641590.1220201920.366511392杉木211/30.6666670.873580.2296507940.68980085桉树531152.4662120.6483290141.9473823573.803951方案层对生态效益判断生态效益松树杉木桉树按行相乘开N次方权重W1AW1松树12361.8171210.5278361331.611811805杉木1/2131.51.1447140.3325159281.015377811桉树1/31/310.1111110.480750.1396479390.4264319593.442585方案层对技术要求判断技术要求松树杉木桉树按行相乘开N次方权重W1AW1松树11/2631.442250.3806482281.193564712杉木214820.5278534811.6551431桉树1/61/410.0416670.3466810.0914982910.2869030323.78893层次总排序计算四准则ai经济效益社会效益生态效益技术要求aibin三方案bin0.4820520.1170160.2177920.18314松树0.1569960.122020.5278360.3806480.075680.0142783340.114958278杉木0.1191830.3325160.3325160.5278530.0574520.0389097350.072419177桉树0.7238210.6483290.1396480.0914980.3489190.0758649680.030414149层次总排序一致性检验CIi0.0884640.0018470.0268110.067805CI=aiCIiRI=aiRIiRIi0.51490.51490.51490.51490.0611175370.5149CRi0.1718080.0035880.052070.131687AW1AW1/W1CI=（入-n）/（n-1）CR=CI/RI2.0705474.2952770.073322510.89310.0820990.4781664.0863250.9386174.3097040.7670944.1885644.219968AW1/W1CI=（入-n）/（n-1）CR=CI/RI3.1769280.0884640.51490.1718083533.1769283.1769283.176928AW1/W1CI=（入-n）/（n-1）CR=CI/RI3.0036950.0018470.51490.0035876853.0036953.0036953.003695AW1/W1CI=（入-n）/（n-1）CR=CI/RI3.0536220.0268110.51490.0520698933.0536223.0536223.053622AW1/W1CI=（入-n）/（n-1）CR=CI/RI3.1356110.0678050.51490.1316865843.1356113.1356113.135611总排序aibin0.0697120.2654530.0966710.2654530.0167570.471955CR=CI/RI0.118698用电子表格（Excel）实现层次分析法（AHP）的简捷计算准则层对目标层判断树种选择经济效益社会效益生态效益技术要求按行相乘开N次方权重WiAWi经济效益1342.0024.00002.21340.48212.0705社会效益1/311/20.500.08330.53730.11700.4782生态效益1/4212.001.00001.00000.21780.9386技术要求1/221/21.000.50000.84090.18310.76714.5915max=判断矩阵A-B权重向量WimaxAB1B2B3aij开N次方权重Wi（AW）i（AW）i/WiB111/31/30.110.48070.14290.42863.0000B23113.001.44220.42861.28573.0000B33113.001.44220.42861.28573.00003.3652max=3.0000方案层对社会效益判断社会效益松松树树杉木桉树按行相乘开N次方权重WiAWiAWi/Wi松树11/21/50.100.46420.12200.36653.0037杉木211/30.670.87360.22970.68983.0037桉树53115.002.46620.64831.94743.00373.80403.0037方案层对生态效益判断生态效益松树杉木桉树按行相乘开N次方权重W1AW1AW1/W1松树12361.8171210.5278361331.6118118053.0536216杉木1/2131.51.1447140.3325159281.0153778113.0536216桉树1/31/310.11110.480750.1396479390.4264319593.05362163.4425853.0536216方案层对技术要求判断技术要求松树杉木桉树按行相乘开N次方权重W1AW1AW1/W1松树11/231.51.1447140.3196182640.9647021143.0182947杉木214820.5584245431.6854898433.0182947桉树1/31/410.08330.436790.1219571930.368102753.01829473.5815043.0182947层次总排序计算四准则ai经济效益社会效益生态效益技术要求aibin三方案bin0.48210.1170.21780.1831松树0.14290.1220.52780.31960.0688650.0142783340.1149582780.0585349杉木0.42860.33250.33250.55840.2065940.0389097350.0724191770.10227桉树0.42860.64830.13960.1220.2065940.0758649680.0304141490.0223353层次总排序一致性检验CIi00.00180.02680.0091CI=aiCIiRI=aiRIiCR=CI/RIRIi0.51490.51490.51490.51490.0077305760.51490.0150137CRi00.00360.05210.0178AWi/WiCI=（入-n）/（n-1）CR=CI/RI4.29530.07330.89310.08214.08634.30974.18864.2200一致性检验C.I.R.I.C.R.0.00000.51490.00000.0000CI=（入-n）/（n-1）CR=CI/RI0.00180.51490.0036CI=（入-n）/（n-1）CR=CI/RI0.0268110.51490.052069893CI=（入-n）/（n-1）CR=CI/RI0.0091470.51490.017765301总排序aibin0.4201930.4201930.335208判断矩阵A-B权重向量Wimax一致性检验C6D1D2aij开N次方权重Wi（AW）i（AW）i/WiC.I.R.I.D111/30.330.57740.2500#D2313.001.73210.7500#2.3094max=#AAB1B1B2B2B3B3B1B111/31/3B2B211B3B31B1B1C1C1C2C2B2B2C1C111C3C3C2C21C4C4C1C1D1D1D2D2C2C2D1D115D1D1D2D21D2D2C4C4D1D1D2D2C5C5D1D117D1D1D2D21D2D2C.R.#AAB1B1B10.1429C10.5000B2B20.42860.4286C20.5000B3B30.42860.4286CR0.0000CR0C1C2D10.8333D10.7500D20.1667D20.2500CR0CR0.0000C3C3C4C4B3B3C5C5C6C613C5C5131C6C61C5C6D10.1667D10.2500D1D1D2D2C3C3D1D1D2D2D20.8333D20.750013D1D111/5CR0CR0.00001D2D21D1D1D2D2C6C6D1D1D2D211/5D1D111/31D2D21B层次总排序（CR=0.0000）B1B2B30.14290.40.4286C层次总排序（CR=0.0000）C1C2C3C40.07140.10.32140.1071D层次总排序（CR=0.0000）D1D20.34080.7iWiWiWiWiWiW一致性检验B2B3C30.7500C50.75C40.2500C60.25CR0.0000CR0C3C4D10.1667D10.875D20.8333D20.125CR0.0000CR0C5C60.30.1071iWiWiWiWAAB1B1B2B2B3B3B1B111/31/3B2B211B3B31B1B1C1C1C2C2B2B2C3C3C4C4C1C111C3C313C2C21C4C41C1C1D1D1D2D2C2C2D1D1D2D2D1D115D1D113D2D21D2D21C4C4D1D1D2D2C5C5D1D1D2D2D1D117D1D111/5D2D21D2D21计算判断矩阵权重向量WiAB1B2B3aij开N次方B111/31/30.110.4807B23113.001.4422B33113.001.44223.3652判断矩阵权重向量WiB1C1C2aij开N次方权重WiC1111.001.00000.5000C2111.001.00000.50002.0000判断矩阵权重向量WiB2C3C4aij开N次方权重WiC3133.001.73210.7500C41/310.330.57740.25002.3094判断矩阵权重向量WiB3C5C6aij开N次方权重WiC5133.001.73210.7500C61/310.330.57740.25002.3094判断矩阵权重向