Programming of Organizing Grouting Result Tables Using VBALanguage Based on Excel Software

LIU Hui-xia,XIANG Hong-li

Journal of Changjiang River Scientific Research Institute ›› 2011, Vol. 28 ›› Issue (5) : 71-74.

PDF(1622 KB)
PDF(1622 KB)
Journal of Changjiang River Scientific Research Institute ›› 2011, Vol. 28 ›› Issue (5) : 71-74.
HEALTHY CHANGJIANG RIVER

Programming of Organizing Grouting Result Tables Using VBALanguage Based on Excel Software

  • LIU Hui-xia,XIANG Hong-li
Author information +
History +

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

Cite this article

Download Citations
LIU Hui-xia,XIANG Hong-li. Programming of Organizing Grouting Result Tables Using VBALanguage Based on Excel Software [J]. Journal of Changjiang River Scientific Research Institute. 2011, 28(5): 71-74
PDF(1622 KB)

Accesses

Citation

Detail

Sections
Recommended

/