Excel VBA在安全监测数据处理中的应用

Application of Execl BVA in datum treatment of safety supervision in hydroengineering

针对水电工程安全监测仪器种类繁多、测值数据量大、参数各异的情况，本文通过总结以往监测数据分析中的整编和实测值计算比较复杂的问题，基于目前大部分水电安全监测的数据均以Excel为平台，提出应用编程简单、通用性强、针对性突出的Excel VBA，对监测数据进行整编和计算。通过东风水电站监测数据整编及应力应变计算应用，较好地解决了监测数据经常会遇到的重复、繁琐的人工处理和Excel表格中无法简单处理的计算，提出了Excel VBA在水电监测工程数据处理的进一步推广应用思路。

For the numerous types of safety supervision datum in hy ficult to reorganize these datum and hard to calculate the actual val droengineering,large amount and indisorder, it is difue in supervision datum analysis. This paper summarizes the problems and proposed the Excel VBA method with simple programming,strong universality and outstanding pertinence to reorganize and calculate the supervision datum base on conditions of using Excel to store safety supervision datum of most Hydropower Stations. The practical effect of datum reorganization and the stress and strain calculation in Dongfeng Hydropower Station indicates that the method has better ability to solve problems of baldness, repetition and nitty- gritty of manual treatment encountered in supervision Excel, at the same time puts forward applied ideas of other engineering. datum calculation and incapability of simple calculation in aspects in datum treatment of supervision projects in hydroengineering.