摘要
传统手工废气在线比对验收数据计算过程存在流程繁琐、数据安全性差、计算方法不统一等缺陷,同时在报告生成过程中,Excel计算与Word展示功能不能有机结合,脱节现象凸显,故其已经不符合环境监测信息化进程。针对上述问题,该文通过Visual Basic(VB)实现了废气在线比对验收数据的快速计算,并利用Word"邮件合并"功能生成监测结果表。通过该研究,实现了在线比对监测数据计算的便捷化,缩减了报告生成时间,并规范了数据管理方式。
Data calculation involved in exhaust On-line comparison in check and acceptance contains complicated processes,poor security,discrepant calculative methods and so on defects,which restrict data calculation efficiency.In addition,it presents obviously that the function relate to Excel data calculation is disconnected with Word’s presentation function in data processing.Aiming at the former problem,this paper realized data fast calculation on exhaust on-Line comparison in check and acceptance by using Visual Basic(VB),and these acquired data were transferred to monitoring table directly through the utilization of Word Mail-merge.As a result,data processing and report execution period were shortened and data management was regulated.
作者
王涛
亚力坤.阿布都米提
Wang Tao;Yalikun·Abudumiti(Urumqi Environmental Monitoring Centre, Urumqi 830000, China)
出处
《环境科学与管理》
CAS
2018年第11期107-110,共4页
Environmental Science and Management