| 基于VBA技术实现模糊综合评判法在EXCEL中的应用 |
| |
| 引用本文： | 曹久立,高传昌. 基于VBA技术实现模糊综合评判法在EXCEL中的应用[J]. 华北水利水电学院学报, 2007, 28(6): 48-50 |
| |
| 作者姓名： | 曹久立 高传昌 |
| |
| 作者单位： | 华北水利水电学院,河南,郑州,450011 |
| |
| 摘 要： | 基于模糊综合评判数学模型的VBA程序,利用EXCEL强大的数据处理能力并结合EXCEL VBA功能实现了模糊数学模型在地下水水质评价应用中的快速求解.将该模型程序应用到铜锣山岩溶地下水水质评价中,并将2结果进行比较,结果表明该程序正确有效,为模糊综合评判的应用提供了一种简便、有效的技术支撑.
|
| 关 键 词： | VBA技术 EXCEL 模糊综合评判法 地下水水质评价 |
| 文章编号： | 1002-5634（2007）06-0048-03 |
| 收稿时间： | 2007-06-16 |
| 修稿时间： | 2007-08-16 |
Application of Fuzzy Comprehensive Evaluation Based on VBA in EXCEL |
| |
| CAO Jiu-li,GAO Chuan-chang. Application of Fuzzy Comprehensive Evaluation Based on VBA in EXCEL[J]. Journal of North China Institute of Water Conservancy and Hydroelectric Power, 2007, 28(6): 48-50 |
| |
| Authors: | CAO Jiu-li GAO Chuan-chang |
| |
| Abstract: | Using EXCEL's powerful data processing capabilities,and based on fuzzy math model to design a VBA macro program,a kind of fast computing on the fuzzy comprehensive evaluation is got.The procedures of this model are applied to Tongluo hill karst groundwater quality evaluation,the results show the procedure is correct and effective.The procedure really provides a simple and effective way for the application of fuzzy comprehensive evaluation. |
| |
| Keywords: | VBA macro program EXCEL fuzzy comprehensive evaluation groundwater quality evaluation |
| 本文献已被 维普 万方数据 等数据库收录！ |
