利用Excel函数快速计算环境空气监测数据

Application of Excel Function in Analysis and Processing of Environmental Air Monitoring Data

针对环境空气监测数据多、计算量大、评价费时等困难,利用Excel函数编辑自定义IF函数,分析环境空气监测数据,实现环境空气质量快速评价。本文以可吸入颗粒物(PM10)数据处理为例,说明IF函数建立的过程,在环境空气监测数据分析与处理中的应用。

In view of the difficulties in environmental air monitoring data, computation and evaluation, Edit custom IF function with Excel function, Analyze environmental air monitoring data to evaluate environmental air quality. This paper takes the data processing of particulate matter (PM10), as examples to illustrate the application of IF function in the analysis and processing of environmental air monitoring data.