基于VBA的岩土试验数据快捷处理方法研究

通过Excel与VBA语言相互通信机制，结合公路工程岩土试验数据特点，对试验数据进行自动化整理统计分析。首先对原始试验数据按照钻孔桩号、取样深度进行自动排序并删除重复项数据；其次依据构造物勘探点获取桥梁、隧道、边坡等工点试验数据；最后采用最不利原则对同类地质条件和相同层位试验数据进行统计分析，剔除异常值，获取试验参数及评价结果。避免手工处理的繁琐、工作量大、花费时间长的缺点，达到界面友好，处理数据迅速、准确，极大地缩短工期的效果，从而能更加有效地保证工程质量及进度。

Study on VBA-based Method Processing Geotechnical Test Data Fast

Depending on the communication mechanism between Excel and VBA language, and the characteristics of geotechnical test data from highway engineering, the automatic data reduction and statistical analysis was carried out. First, the original test data was sorted automatically according to the drilling pile No. and the sampling depth with the duplicates deleted; second, the test data at bridge, tunnel, slope and other points were obtained from the structures sites; finally, by use of the most unfavorable principle, statistical analysis was conducted on the similar geological conditions and the test data from the same horizon in order to reject the abnormal data and get the test parameters and then the evaluation result. This method bypasses manual processing that is cumbersome and needs a lot of time for heavy workload, and may get friendly interface, fast and accurate data processing, and greatly shortened construction period. As a result, the quality and progress of the works can be guaranteed with high efficiency.