基于Excel软件流程化输出环境空气质量指数(AQI)功能实现的研究

随着环境空气质量标准的全面实施,数据的有效性和准确性得到了极大关注.空气质量指数以数值的形式表述空气质量状况、便于公众简明、清楚地了解空气质量的优劣程度,及时、准确的向公众提供易于理解的当地空气质量状况.基于EXCEL软件计算环境空气质量指数(AQI)的方法有助于AQI算法在基础应用层面的实现,也有助于验证开发技术软件平台中涉及的数据统计算法的准确性.本文以苏州市环境空气监测数据为例,实现了基于EXCEL软件的AQI计算,供相关从业人员参考.

Research on Process-Oriented Calculation of Air Quality Index with Excel

With the full implementation of environmental air quality standards, the effectiveness and accuracy of the data has been a great concern. Air quality index( AQI) was expressed in numerical form of air quality status;concise and accessible to the public clearly understand the level of the extent of the air quality, publishing immediately, accurate and easy to understand infor-mation of local air quality conditions to the public. AQI calculation based on Microsoft EXCEL has universal significance, and contribute to the realization of the algorithm is the basis of the application level, and it also can verify the accuracy of software da-tabase system calculation. For instance, using ambient air monitoring data which observed in Suzhou city, explained how AQI cal-culated in EXCEL, it may give some useful information for relevant practitioners.