| ExcelVBA和Access数据库对道路噪声自动监测数据统计的改进 |
| |
| 引用本文： | 亓靓,张韬,赵璐,盖冬君.ExcelVBA和Access数据库对道路噪声自动监测数据统计的改进[J].环境科学导刊,2013(5):134-136. |
| |
| 作者姓名： | 亓靓 张韬 赵璐 盖冬君 |
| |
| 作者单位： | 青岛市环境监测中心站,山东青岛266003 |
| |
| 摘 要： | 阐述了青岛市噪声自动监测现状，针对自动噪声数据量大，噪声监测系统统计软件存在部分瑕疵的问题，利用ExcelVBA编程和Access数据库查询功能对道路自动噪声数据进行处理，实现了对自动噪声数据的快速筛选、审核，大大提高了工作效率及数据审核质量，在实际应用中取得了较好的效果。
|
| 关 键 词： | Excel VBA Access 噪声 自动监测 数据统计 |
Improvement of Automatic Road Noise Monitoring Data by Excel VBA and Access Database |
| |
| QI Liang,ZHANG Tao,ZHAO Lu,GAI Dong-jun.Improvement of Automatic Road Noise Monitoring Data by Excel VBA and Access Database[J].Yunnan Environmental Science,2013(5):134-136. |
| |
| Authors: | QI Liang ZHANG Tao ZHAO Lu GAI Dong-jun |
| |
| Affiliation: | (Qingdao Environmental Monitoring Center, Qingdao Shandong 266003 China) |
| |
| Abstract: | The present situation of the automatic noise monitoring in Qingdao is discussed in this article. For the massive amount of data, and some intrinsic flaws of the automatic noise monitoring software, the automatic monito- ring data was process by using the Excel VBA programming software and the retrieval function of the Access data- base. The data could be screened and checked quickly with good quality. The application of the method was satis- factory. |
| |
| Keywords: | Excel VBA Access noise automatic monitoring data processing |
| 本文献已被 维普 等数据库收录！ |
