矿区地表沉陷监测数据处理系统设计

System Design of Surface Movement Observation Data Processing in Mining Area

结合Excel和VBA等功能编制一套适合矿区开采沉陷地表移动观测数据的处理系统。该系统可自动化处理地表移动观测数据,改进了Excel绘制带平滑线散点图坐标轴标注的功能,并完成相应的移动变形曲线图的绘制,最后利用实测数据进行角值参数求取及概率积分法参数求取。实践证明,该处理系统兼容性高、操作简单、自动化程度高,完全能够满足矿区开采沉陷监测数据处理的需要。

Combined with Excel and VBA, a set of programsuitable formining subsidence ground movement observation datahandler is designed in this paper. The program can automate the process to handleground movement observation data, improved movement and deformation corresponding Excel draw a graph draw a smooth line with axes labeled scatterplot function, and complete. Finally, the parameterof angle valueand probability integral method areaccounted with measured data. Practice has proved that, the system has high compatibility, simple operation, high degree of automation, fully able to meet the needs of mining subsidence monitoring of data processing.