用WPS或EXCEL软件实现水质自动判断和超标污染物遴选

按照国家水质标准中水质评价的有关规定，在环境水体的常规监测中，需要对数十项监测项目逐项进行达标类别的判断，实际工作中在水质类别判断时容易出现误判的情况。本文介绍了使用日常办公软件WPS表格或EXCEL表格实现对各个监测项目达标类别进行自动判断、自动遴选超标污染物并直接生成简单格式的监测报告的方法，可以简化水质达标类别的判断工作并且避免出现错误，同时，该方法对其他常规监测数据自动判别的简单实现也有一定参考价值。

Automatic Judgement of Water Quality and Selection of Over Polluting Contaminants by Using WPS or EXCEL

According to the national regulations concerning the water quality, the regular monitoring of the environmental water needs to judge the standard quality of every one from dozens of monitored indicators, However it is subject to wrong judgment in practical cases. This paper introduces the way to automatically accomplish the work to judge the standard quality and to select over polluting contaminants by using spreadsheet such as WPS or EXCEL until a brief monitoring report. It can simplify the process of judgement of the water quality and avoid any mistakes. Meanwhile, it is reference for automatic judgments of other regluar monitoring data else.