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

用电子 表格 关于规范使用各类表格的通知入职表格免费下载关于主播时间做一个表格详细英语字母大小写表格下载简历表格模板下载 （Excel）实现层次分析法（AHP）的简捷计算准则层对目标层判断树种选择经济效益社会效益生态效益技术要求按行相乘开N次方权重W1AW1AW1/W1CI=(入-n)/(n-1)CR=CI/RI经济效益1342242.21336383940.48205206162.07054730184.29527735040.07332250810.89310.0820988781社会效益1/311/21/20.08333333330.53728496590.11701615470.47816606714.0863252451生态效益1/4212110.21779160430.93861728794.3097037222技术要求1/221/211/20.84089641530.18314017940.76709432184.18856377894.59154522064.2199675242 方案 气瓶 现场处置方案 .pdf气瓶 现场处置方案 .doc见习基地管理方案.doc关于群访事件的化解方案建筑工地扬尘治理专项方案下载 层对经济效益判断经济效益松树杉木桉树按行相乘开N次方权重W1AW1AW1/W1CI=(入-n)/(n-1)CR=CI/RI松树121/70.28571428570.6586337560.15699613550.49876545693.17692824190.0884641210.51490.171808353杉木1/211/40.1250.50.11918318350.37863642153.1769282419桉树741283.03658897190.7238206812.29952636363.17692824194.19522272793.1769282419方案层对社会效益判断社会效益松树杉木桉树按行相乘开N次方权重W1AW1AW1/W1CI=(入-n)/(n-1)CR=CI/RI松树11/21/50.10.46415888340.12202019210.36651139193.00369459810.0018472990.51490.003587685杉木211/30.66666666670.87358046470.22965079410.68980084963.0036945981桉树531152.46621207430.64832901381.94738235663.00369459813.80395142243.0036945981方案层对生态效益判断生态效益松树杉木桉树按行相乘开N次方权重W1AW1AW1/W1CI=(入-n)/(n-1)CR=CI/RI松树12361.81712059280.52783613341.61181180553.05362157590.02681078790.51490.0520698931杉木1/2131.51.14471424260.33251592771.01537781113.0536215759桉树1/31/310.11111111110.48074985680.13964793890.42643195933.05362157593.44258469223.0536215759方案层对技术要求判断技术要求松树杉木桉树按行相乘开N次方权重W1AW1AW1/W1CI=(入-n)/(n-1)CR=CI/RI松树11/2631.44224957030.38064822821.19356471243.13561084470.06780542230.51490.1316865844杉木214820.52785348121.65514313.1356108447桉树1/61/410.04166666670.34668063720.09149829060.28690303233.13561084473.78893020753.1356108447层次总排序计算四准则ai经济效益社会效益生态效益技术要求aibin总排序三方案bin0.48205206160.11701615470.21779160430.1831401794Σaibin松树0.15699613550.12202019210.52783613340.38064822820.07568031080.01427833370.11495827830.06971198480.2654525931杉木0.11918318350.33251592770.33251592770.52785348120.05745249930.03890973520.07241917740.09667118120.2654525931桉树0.7238206810.64832901380.13964793890.09149829060.34891925150.07586496820.03041414870.01675701340.4719553817层次总排序一致性检验CIi0.0884641210.0018472990.02681078790.0678054223CI=∑aiCIiRI=∑aiRIiCR=CI/RIRIi0.51490.51490.51490.51490.06111753740.51490.1186978781CRi0.1718083530.0035876850.05206989310.1316865844用电子表格（Excel）实现层次分析法（AHP）的简捷计算准则层对目标层判断树种选择经济效益社会效益生态效益技术要求按行相乘开N次方权重WiAWiAWi/WiCI=(入-n)/(n-1)CR=CI/RI经济效益1342.0024.00002.21340.48212.07054.29530.07330.89310.0821社会效益1/311/20.500.08330.53730.11700.47824.0863生态效益1/4212.001.00001.00000.21780.93864.3097技术要求1/221/21.000.50000.84090.18310.76714.18864.5915λmax=4.2200判断矩阵A-B权重向量Wiλmax一致性检验AB1B2B3∏aij开N次方权重Wi(AW)i(AW)i/WiC.I.R.I.C.R.B111/31/30.110.48070.14290.42863.00000.00000.51490.0000B23113.001.44220.42861.28573.0000B33113.001.44220.42861.28573.00003.3652λmax=3.0000方案层对社会效益判断社会效益松树杉木桉树按行相乘开N次方权重WiAWiAWi/WiCI=(入-n)/(n-1)CR=CI/RI松树11/21/50.100.46420.12200.36653.00370.00180.51490.0036杉木211/30.670.87360.22970.68983.0037桉树53115.002.46620.64831.94743.00373.8040λ3.0037方案层对生态效益判断生态效益松树杉木桉树按行相乘开N次方权重W1AW1AW1/W1CI=(入-n)/(n-1)CR=CI/RI松树12361.81712059280.52783613341.61181180553.05362157590.02681078790.51490.0520698931杉木1/2131.51.14471424260.33251592771.01537781113.0536215759桉树1/31/310.11111111110.48074985680.13964793890.42643195933.05362157593.44258469223.0536215759方案层对技术要求判断技术要求松树杉木桉树按行相乘开N次方权重W1AW1AW1/W1CI=(入-n)/(n-1)CR=CI/RI松树11/231.51.14471424260.31961826390.96470211443.01829470730.00914735360.51490.0177653013杉木214820.55842454311.68548984283.0182947073桉树1/31/410.08333333330.43679023240.1219571930.36810275013.01829470733.58150447493.0182947073层次总排序计算四准则ai经济效益社会效益生态效益技术要求aibin总排序三方案bin0.48205206160.11701615470.21779160430.1831401794Σaibin松树0.14285714290.12202019210.52783613340.31961826390.06886458020.01427833370.11495827830.05853494620.4201926243杉木0.42857142860.33251592770.33251592770.55842454310.20659374070.03890973520.07241917740.1022699710.4201926243桉树0.42857142860.64832901380.13964793890.1219571930.20659374070.07586496820.03041414870.02233526220.3352081197层次总排序一致性检验CIi00.0018472990.02681078790.0091473536CI=∑aiCIiRI=∑aiRIiCR=CI/RIRIi0.51490.51490.51490.51490.00773057630.51490.0150137431CRi00.0035876850.05206989310.0177653013判断矩阵A-B权重向量Wiλmax一致性检验C6D1D2∏aij开N次方权重Wi(AW)i(AW)i/WiC.I.R.I.C.R.D111/30.330.57740.25000.50002.0000-0.83330.00000.0000AB1B2B3D2313.001.73210.75001.50002.0000B10.1429C10.5000C30.7500C50.752.3094λmax=1.3333B20.4286C20.5000C40.2500C60.25B30.4286CR0.0000CR0.0000CR0CR0AB1B2B3C1C2C3C4B111/31/3D10.8333D10.7500D10.1667D10.875B211D20.1667D20.2500D20.8333D20.125B31CR0CR0.0000CR0.0000CR0B1C1C2B2C3C4B3C5C6C111C313C513C21C41C61C5C6D10.1667D10.2500C1D1D2C2D1D2C3D1D2D20.8333D20.7500D115D113D111/5CR0CR0.0000D21D21D21C4D1D2C5D1D2C6D1D2D117D111/5D111/3D21D21D21B层次总排序(CR=0.0000)B1B2B30.14290.42860.4286C层次总排序(CR=0.0000)C1C2C3C4C5C60.07140.07140.32140.10710.32140.1071D层次总排序(CR=0.0000)D1D20.34080.6592AB1B2B3B111/31/3B211B31B1C1C2B2C3C4B3C5C6C111C313C513C21C41C61C1D1D2C2D1D2C3D1D2D115D113D111/5D21D21D21C4D1D2C5D1D2C6D1D2D117D111/5D111/3D21D21D21计算判断矩阵权重向量Wiλmax一致性检验AB1B2B3∏aij开N次方权重Wi(AW)i(AW)i/WiC.I.R.I.C.R.B111/31/30.110.48070.14290.42863.00000.00000.51490.0000B23113.001.44220.42861.28573.0000B33113.001.44220.42861.28573.00003.3652λmax=3.0000判断矩阵权重向量Wiλmax一致性检验B1C1C2∏aij开N次方权重Wi(AW)i(AW)i/WiC.I.R.I.C.R.C1111.001.00000.50001.00002.0000-0.83330.00000.0000C2111.001.00000.50001.00002.00002.0000λmax=1.3333判断矩阵权重向量Wiλmax一致性检验B2C3C4∏aij开N次方权重Wi(AW)i(AW)i/WiC.I.R.I.C.R.C3133.001.73210.75001.50002.0000-0.83330.00000.0000C41/310.330.57740.25000.50002.00002.3094λmax=1.3333判断矩阵权重向量Wiλmax一致性检验B3C5C6∏aij开N次方权重Wi(AW)i(AW)i/WiC.I.R.I.C.R.C5133.001.73210.75001.50002.0000-0.83330.00000.0000C61/310.330.57740.25000.50002.00002.3094λmax=1.3333判断矩阵权重向量Wiλmax一致性检验C1D1D2∏aij开N次方权重Wi(AW)i(AW)i/WiC.I.R.I.C.R.D1155.002.23610.83331.66672.0000-0.83330.00000.0000D21/510.200.44720.16670.33332.00002.6833λmax=1.3333判断矩阵权重向量Wiλmax一致性检验C2D1D2∏aij开N次方权重Wi(AW)i(AW)i/WiC.I.R.I.C.R.D1133.001.73210.75001.50002.0000-0.83330.00000.0000D21/310.330.57740.25000.50002.00002.3094λmax=1.3333判断矩阵权重向量Wiλmax一致性检验C3D1D2∏aij开N次方权重Wi(AW)i(AW)i/WiC.I.R.I.C.R.D111/50.200.44720.16670.33332.0000-0.83330.00000.0000D2515.002.23610.83331.66672.00002.6833λmax=1.3333判断矩阵权重向量Wiλmax一致性检验C4D1D2∏aij开N次方权重Wi(AW)i(AW)i/WiC.I.R.I.C.R.D1177.002.64580.87501.75002.0000-0.83330.00000.0000D21/710.140.37800.12500.25002.00003.0237λmax=1.3333判断矩阵权重向量Wiλmax一致性检验C5D1D2∏aij开N次方权重Wi(AW)i(AW)i/WiC.I.R.I.C.R.D111/50.200.44720.16670.33332.0000-0.83330.00000.0000D2515.002.23610.83331.66672.00002.6833λmax=1.3333判断矩阵权重向量Wiλmax一致性检验C6D1D2∏aij开N次方权重Wi(AW)i(AW)i/WiC.I.R.I.C.R.D111/30.330.57740.25000.50002.0000-0.83330.00000.0000D2313.001.73210.75001.50002.00002.3094λmax=1.3333单排序AB1B2B3B10.1429C10.5000C30.7500C50.75B20.4286C20.5000C40.2500C60.25B30.4286CR0.0000CR0.0000CR0CR0C1C2C3C4D10.8333D10.7500D10.1667D10.875D20.1667D20.2500D20.8333D20.125CR0CR0.0000CR0.0000CR0C5C6D10.1667D10.2500D20.8333D20.7500CR0CR0.0000总排序B层次总排序(CR=0.0000)B1B2B30.14290.42860.4286C层次总排序(CR=0.0000)C1C2C3C4C5C60.07140.07140.32140.10710.32140.1071D层次总排序(CR=0.0000)D1D20.34080.6592