关键词: 灌浆成果表 , Excel , VBA语言

Abstract: Heavy workload and low efficiency are problems in organizing the grouting result tables of water conservancy grouting projects. In this paper, taking visualization window as the operation interface, a program for automatically organizing the grouting result tables using VBA language, the secondary development tool of Excel, is presented. Having inputted original borehole data and the grouting data in the Excel worksheets, users then select tables to be organized in the visualization window, and then click on “generate table” button to achieve automatic organization. The program has been applied to an engineering project and proved to be capable of automatic, accurate, and efficient organization. This paper lays foundation for applying Excel VBA language to organizing data of grouting projects, and serve as a reference for organizing data of other engineering projects.

Key words: grouting result table , excel , VBA language