ISSN 2096-4498

   CN 44-1745/U

二维码

Tunnel Construction ›› 2011, Vol. 31 ›› Issue (S1): 442-447.

• wenzhang • Previous Articles    

Application of EXCEL VBA in Tunnel Inspection and Maintenance Management Information Database

Huang TzyyMin1, 2, Wang TaiTien2 , Lin ChihChuan1, Chou YungChuan1   

  1. (1. CECI Engineering Consultants, Inc., Taipei; 2. Taipei University of Technology, Taipei)
  • Received:2011-06-15 Online:2011-08-05 Published:2011-11-04

Abstract: Section measurement is the most direct method for acquiring monitoring data of an operating tunnel in tunnel maintenance tasks. Longterm and regular monitoring over tunnel sectional displacement not only provides good control over stability variations of the operating tunnel, it also generates key information for the safety assessment and structural reinforcement of the tunnel. Based on EXCEL, part of 2003 Microsoft Office, accompanied with VBA (Visual Basic for Application), the study developed a model of standard operation procedures for processing the tunnel section measurement data, handling a large amount of the original sectional measurement data of the shield tunnel, and transforming the original data into modular information which can be queried. Sectional profiles automatically plotted by the program provided cross comparison of geographic displacements of localities, and study and analysis of impact degrees of the stress. Via this logic model, it enabled a breakthrough over format inconsistency limitations in the system measurement data attained by different section scanning systems; all the multiple section survey data processed by the program, in any format, can be automatically plotted, overlapped, and compared for sectional differences between prior and posterior inspections. Subsequent importation of sectional data processed by the system into the database can further be used as the major source of system information for the maintenance and management authorities, for developing a value-added Decision Support System.

Key words: tunnel inspection, safety evaluation, application of information, EXCEL, database