基于ExcelVBA的模糊综合评判地表水水质评价

地表水水质是地质环境质量评价主因素之一，对永安市小陶镇10组地表水水质数据选用模糊综合评价法，基于Micro Soft office Excel VBA编程进行了综合快速评价。评价结果表明：下游各项污染指标均略高于上游；盆地外围支流的地表水水质均较好，除西学溪锌偏高微超标外，其它均在Ⅱ类水质范围内。实验证明利用VBA完成模糊综合评判方法有效性，并具有可移值性，只须修改少量代码即可完成其它区域的水质评价。

Fuzzy Comprehensive Evaluation of Surface Water Quality Base on Excel VBA

Affecting surface water quality evaluation of the geological environment is one of the main factors.This article on the city of Yongan small Tao Zhen in 10 groups of surface water quality data using fuzzy comprehensive evaluation method,based on the MicroSoft office ExcelVBA programming in the comprehensive evaluation.The evaluation results indicate that: the pollution indices were slightly higher than the downstream upstream tributaries;in the periphery of the surface water quality are good,except the Western Creek(Zn) high zinc micro over standard,others are in class II water range.The experiment has proved that the use of VBA to complete the comprehensive fuzzy evaluation method can effectively be sex,and has portability,only modification of a small amount of code can be completed other regional water quality evaluation.