TOPSIS法的EXCEL实现过程

X11X12X21X22X23X31X32X33

权重0.07250.33690.33690.33690.33690.33690.33690.3369对象10.54320.7882 1.07110.2606 1.09810.15170.51310.3471对象20.54320.6093 4.7026 1.2145 1.5860 1.3447 3.1271 2.1812对象30.54320.5230 5.1913 1.0670 2.14520.8913 2.5879 2.1570对象40.54320.33860.33860.33860.33860.33860.33860.3386对象50.54320.8439 4.1639 3.6740 2.2695 1.7815 3.0862 2.0513对象60.54320.9913 4.5125 1.8167 2.3471 2.4390 3.2758 2.6001

0.0295840.1514210.0384610.0198320.0846570.0148370.0283780.025757

0.0295840.1170490.1688630.0924320.1222720.1315350.1729410.161853

0.0295840.1004660.186410.0812110.1653810.0871850.1431240.160057

0.0295840.0650480.0121580.025770.0261040.033120.0187260.025125

0.0295840.1621280.1495180.279620.1749610.1742610.1706790.152211

0.0295840.1904280.1620360.1382680.1809440.2385680.1811670.192936

0.0295840.1904280.186410.279620.1809440.2385680.1811670.192936

0.0295840.0650480.0121580.0198320.0261040.0148370.0187260.025125

D+D-Ci

0.448910.1080470.1939965

0.2380410.3128490.5678973

0.2704560.3061030.5309134

0.480890.0192230.0384386

0.0900090.4273130.826011

0.1434380.4251930.7477482