矿区地表观测站辅助设计与数据处理程序实现

为了提高矿区地表移动观测站设计的自动化程度、数据处理速度以及绘制移动变形曲线图的效率，基于Visual Basic（VB）及Visual Basic for Application （VBA）编程语言，并融合Access数据库、AutoCAD、Excel软件技术，实现了地表移动观测站设计中的参数查询、观测线长度计算、观测线布设、数据输出、后期观测数据处理及绘制曲线等一系列功能。首先在AutoCAD软件中快速进行工作面上方地表、线状路线观测站的布设；然后采用Excel软件自动化处理观测数据并绘制变形曲线图，并改进了Excel软件中绘制带平滑线散点图坐标轴的标注功能；最后将上述2个功能模块集成到同一程序中，从而克服以往程序功能单一、自动化程度差、修改不便等缺陷。结果表明，该程序能够适应多样化的布站需求，满足绘制地表移动变形曲线图的特殊要求，有助于提高矿区地表观测站设计的自动化程度，为建立地表移动观测系统提供参考。

Realization of Aided Design of Surface Movement Observation Station and Data Processing in Mining Area

In order to improve the automation of the surface movement observation station in design and the efficiency of data processing and mapping of movement and deformation curve，based on the programming language of Visual Basic(VB) and Visual Basic for Application （VBA)，the functions such as query of parameters，computation of observation line，observation station design，output of data，data processing and automatic mapping of surface movement observation station are realized by adopting the technology of Access，AutoCAD and Excel.Firstly，the surface and linear route movement observation stations at working face are arranged quickly by using the AutoCAD software；then the observation data are processed automatically and the deformation and movement graphs are mapped based on the Excel software.In addition，the function of axis label of scatter chart with a smooth line is optimized；Finally，both of the functions are integrated into one program to realize the function module integration so as to overcome the insufficiency of single function，low degree of automation and difficulty in modification.The research results show that，the program written in this paper can satisfy the needs for variable observation station design and the special requirement of mapping the movement and deformation curve.Besides that，this program is conducive to improve the automation degree of mining surface movement observation and it can also provide some reference for establishing the surface movement observation system.