[1]YANG Cang-sheng.Application of the Development Technique Based on Excel VBA to Heavy Dynamic Sounding Test[J].Journal of Seismological Research,2011,34(01):0-.
Copy
Journal of Seismological Research[ISSN 1000-0666/CN 53-1062/P] Volume:
34
Number of periods:
2011 01
Page number:
0-
Column:
Public date:
2011-03-09
- Title:
-
Application of the Development Technique Based on Excel VBA to Heavy Dynamic Sounding Test
- Author(s):
-
YANG Cang-sheng
-
(Earthquake Administration of Yunnan Province, Kunming 650224, Yunnan, China)
-
- Keywords:
-
system analysis; data flow; module design; key technique; worksheet design-
- CLC:
-
TP311.52
- DOI:
-
-
- Abstract:
-
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.