摘要
针对公路工程构造物多、场地环境复杂多变、水质试验涉及的化学指标及数据较多等特点,该文通过Excel与VBA语言相互通信机制,结合《公路工程地质勘察规范》(JTG C20-2011)附录K,形成一款界面友好、操作简便、计算快捷的水质分析试验数据处理软件。该软件能够快速处理大批量水质分析试验数据,并获得可靠的腐蚀性评价结论及各工点构造物的水质分析评价试验报告。避免了手工处理数据的繁琐、工作量大、花费时间长的缺点,从而能更加有效地提高工作效率。
The highway engineering has the characteristics of many structures, complex and changeable site environment, many chemical indexes and datas of water quality tests. For these, in this paper, through the communication mechanism between Excel and VBA language, combined with appendix K of Code for Highway Engineering Geological Investigation(JTG C20-2011), a data processing software for water quality analysis and test with friendly interface, simple operation and fast calculation is formed. The software can quickly process a large number of water quality analysis test data, and obtain the reliable corrosivity evaluation conclusions, and the water quality analysis and evaluation test reports of structures in each construction site. The disadvantages of manual processing data, such as tedious, heavy workload and long time are avoided, thus can improve the work efficiency more effectively.
作者
王朋伟
王伟锋
赵天宇
Wang Pengwei;Wang Weifeng;Zhao Tianyu(Gansu Province Transportation Planning,Survey&Design Institute Co.,Ltd.)
出处
《勘察科学技术》
2020年第2期10-13,共4页
Site Investigation Science and Technology
基金
甘肃省科技重大专项项目“甘肃省湿陷性黄土地区公路修筑成套技术研究”(1302GKDA009)
关键词
公路工程
VBA
水质分析
腐蚀性评价
highway engineering
VBA
water quality analysis
corrosion evaluation
