基于Excel VBA开发技术在钻孔波速测试成果表中的应用

The Application of Development Technique Based on Excel VBA in Borehole Wave Velocity Test Results Table

运用Excel的电子表格计算能力和Excel VBA宏语言增加的自动功能,来解决钻孔波速测试成果分析的问题,使整理成果资料快速便捷,在工程实践中得到验证。从软件工程的工作表设计、数据流程设计、模块设计、操作命令、系统运行环境、成果图表设计原则与技巧等,多个方面介绍开发应用程序的特点和注意事项。

Using the Excel computation ability and Excel VBA macro language increase automatic function in spreadshe- et, in order to solve the problem of borehole wave velocity test results analysis, and make the achievement information quick and easy, verified in engineering practice. We introduced the characteristics and attentions of the developing series through man- y aspect, the working table of software engineering design, data flow design, module design, the operation command design, system running environment results of graphic design principles and skills and so on.