| 水质灰色预测模型在VBA中的实现 |
| |
| 引用本文： | 吴良忠,韩波,韦华.水质灰色预测模型在VBA中的实现[J].中国环境管理干部学院学报,2013(4):45-47. |
| |
| 作者姓名： | 吴良忠 韩波 韦华 |
| |
| 作者单位： | [1]北海市环境信息中心,广西北海536000 [2]北海市环境监测中心站,广西北海536000 |
| |
| 摘 要： | 灰色预测是环境污染预测应用相当广泛的方法。根据文献报道,基于Matlab和Excel实现灰色预测中存在着占用内存、单元格填埋计算公式等等的不足,因此提出了一种基于VBA在Excel下编写宏程序轻松实现灰色预测的方法,并将其运用到北海市地表水污染物预测。结果表明,本程序简短,操作方便,计算结果准确可靠,彻底把用户从繁琐的手工操作中解放出来。
|
| 关 键 词： | 灰色预测 VBA Excel 环境污染 水质预测 |
Realizing Water Quality Grey Forecasting Model in VBA |
| |
| Wu Liangzhong;Han Bo;Wei Hua.Realizing Water Quality Grey Forecasting Model in VBA[J].Journal of Environmental Management College of China,2013(4):45-47. |
| |
| Authors: | Wu Liangzhong;Han Bo;Wei Hua |
| |
| Institution: | Wu Liangzhong,Han Bo, Wei nua(1. Beihai Environmental Information Center, Beihai Guangxi 536000, China; 2. Beihai Environmental Monitoring Center, Beihai Guangxi 536000, China) |
| |
| Abstract: | Grey Prediction model is widely used for environmental pollution forecast. According to current reports, the Grey Prediction model based on Matlab and Excel exists the shortcomings such as taking lot of memory and leaving off the formula in the cell. In this paper, the macro-program based on VBA in Excel was built to achieve the Grey Prediction model easily, and it was used to forecast the contaminants in surface water in BeiHai. It showed that the program was short and easy to operate, and the calculation results were accurate and reliable. The program would relieve the users from their tedious manual operation. |
| |
| Keywords: | Grey Prediction VBA Excel Environment Pollution Water Quality Prediction |
| 本文献已被 CNKI 维普 等数据库收录！ |
|
