| EXCEL单键实现Borda法组合评价 |
| |
| 引用本文： | 柯健,李超.EXCEL单键实现Borda法组合评价[J].统计与信息论坛,2005,20(1):103-105. |
| |
| 作者姓名： | 柯健 李超 |
| |
| 作者单位： | 安徽财经大学,统计学系,安徽,蚌埠,233041 |
| |
| 摘 要： | 组合评价是将几种评价结果进行组合的一种科学合理的评价方法,Borda法是一种对几种单一评价法的评价排序结果进行组合的有效方法,但在实践中还没有可用的计算机软件,因而操作起来相当繁琐。利用VBA(VisualBasicforApplication)在EXCEL下编写宏程序,单键即可轻松实现Borda法组合评价。
|
| 关 键 词： | Borda法 VBA EXCEL 组合评价 |
| 文章编号： | 1007-3116(2005)01-0103-03 |
| 修稿时间： | 2004年3月22日 |
A Single Key to Implement Borda Combinational Evaluation by Microsoft EXCEL |
| |
| KE Jian,LI Chao.A Single Key to Implement Borda Combinational Evaluation by Microsoft EXCEL[J].Statistics & Information Tribune,2005,20(1):103-105. |
| |
| Authors: | KE Jian LI Chao |
| |
| Abstract: | Combination Evaluation is a scientific method with the combination of several kinds of appraising results. The Borda method is an efficient method to combine orderly appraising results from several separated evaluating methods. However, it is quite tedious for users because currently there is no computational software available in practice. Here we provide an easy-to-implement solution to automate the Combinational Appraisal by VBA in Microsoft EXCEL, so the only thing that users need to do is just to press one single key. |
| |
| Keywords: | Borda method VBA EXCEL Combination Evaluation |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
