基于Excel VBA的开发技术在重型动力触探试验中的应用*

(云南省地震局,昆明 650224)

系统分析; 数据流程; 模块设计; 关键技术; 工作表设计

Application of the Development Technique Based on Excel VBA to Heavy Dynamic Sounding Test
YANG Cang-sheng

(Earthquake Administration of Yunnan Province, Kunming 650224, Yunnan, China)

system analysis; data flow; module design; key technique; worksheet design-

备注

通过Excel VBA宏语言程序来解决重型动力触探试验的成果分析和自动化出图的问题,在工程实践中得到验证。将Excel强大的电子表格计算能力与Excel VBA增加的自动功能相结合,可方便地将试验结果输出为模版式图表,使试验成果管理得到规范和系统化,有利于开发程序所应用专业的技术推广或前沿拓展。从系统分析、软件工程的开发界面、数据流程设计、模块设计、关键技术、工作表设计原则与技巧等方面介绍了开发应用程序的特点和注意事项。

The problem that using the Excel VBA macro-language to analyze the results and the automatic mapping of the heavy dynamic sounding test has been solved and validated in the engineering practice. It is expedient to transfer the test results to the stencil chart and standardize and systemize the management of the test achievements by the help of the powerful table-calculation function of Excel and automatic function of Excel VBA. Thus, It is favorable to popularizing and broadening the techniques of the related fields.The features of the soft we developed, such as system analysis, interface development software, data-flow design, module design, key technique, principle and technique in the design of the worksheet are introduced.