Excel条件语句在水质达标分析中的运用研究

APPLICATION OF EXCEL CONDITIONAL STATEMENT IN WATER QUALITY STANDARD ANALYSIS

本文以计算滇池入湖河流的水质达标情况为目标,利用excel条件语句,优化水质达标情况的人工干预过程,提高准确率,建立数字化自动计算表格,为保障精准识别滇池入湖河流水质提供重要的基础数据支撑,并为后期与软件结合,实现数字化水质目标考核管控奠定基础。

This paper aims at calculating water quality standards of the Dian Lake rivers into the lake.Excel conditional statements are used to optimize water quality standards in the process of manual intervention,improve accuracy,and establish digital automatic calculation tables,which provide important data support basis for ensuring accurate identification of water quality of the Dian Lake rivers.Combined with software,It lays a foundation for realizing the digital evaluation and control of water quality.