空气质量指数计算方法在Excel中VBA的实现

The Realization of Air Quality Index Calculation Method based on VBA in Excel

空气质量指数计算方法是目前全国各城市空气质量重要信息发布的基础,广泛应用于城市空气自动监测的空气质量评价。依据《HJ 633-2012环境空气质量指数(AQI)技术规定(试行)》发布环境空气质量指数(AQI)计算方法,利用VBA在Excel下编写宏程序,可以轻松实现空气质量日报信息的发布,使用户从手工重复性的填充和插入函数操作方式中彻底解放出来。

Air quality index calculation method is the basis of the release of important urban air quality information, which is widely used in air quality assessment in urban air automatic monitor-ing. According to the calculation method of air quality index （AQI） from the Technical Regulation on Ambient Air Quality Index （on trial, HJ 633-2012）, the macro-program based on VBA in Ex-cellwas built to achieve the easy release of important daily urban air quality information, which can relieve the users from their repeated filling and inserting function.