摘要
为了提高矿区地表移动观测站设计的自动化程度、数据处理速度以及绘制移动变形曲线图的效率,基于Visual Basic(VB)及Visual Basic for Application(VBA)编程语言,并融合Access数据库、Auto CAD、Excel软件技术,实现了地表移动观测站设计中的参数查询、观测线长度计算、观测线布设、数据输出、后期观测数据处理及绘制曲线等一系列功能。首先在Auto CAD软件中快速进行工作面上方地表、线状路线观测站的布设;然后采用Excel软件自动化处理观测数据并绘制变形曲线图,并改进了Excel软件中绘制带平滑线散点图坐标轴的标注功能;最后将上述2个功能模块集成到同一程序中,从而克服以往程序功能单一、自动化程度差、修改不便等缺陷。结果表明,该程序能够适应多样化的布站需求,满足绘制地表移动变形曲线图的特殊要求,有助于提高矿区地表观测站设计的自动化程度,为建立地表移动观测系统提供参考。
In order to improve the automation of the surface movement observation station in design and the efficiency ofdata 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 qfiery of parameters, computation of observation line, observa-tion station design, output of data, data processing and automatic mapping of surface movement observation station are realizedby adopting the technology of Access,AutoCAD and Excel. Firstly, the surface and linear route movement observation stationsat working face are arranged quickly by using the AutoCAD software;then the observation data are processed automatically andthe deformation and movement graphs are mapped based on the Excel software. In addition, the function of axis label of scatterchart with a smooth line is optimized ; Finally, both of the functions are integrated into one program to realize the function mod-ule 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 designand the special requirement of mapping the movement and deformation curve. Besides that, this program is conducive to im-prove the automation degree of mining surface movement observation and it can also provide some reference for establishing thesurface movement observation system.
出处
《金属矿山》
CAS
北大核心
2015年第5期129-134,共6页
Metal Mine
基金
"十二五"国家科技支撑计划项目(编号:2012BAB13B03)
国家自然科学基金青年基金项目(编号:41104011)
江苏高校优势学科建设工程项目(编号:SZBF2011-6-B35)
江苏省资源环境信息工程重点实验室基金项目(编号:JS201309)
关键词
地表移动观测站
数据处理
移动变形曲线
VB
VBA
地表移动观测系统
Surface movement observation station, Data processing, Movement deformation curve, VB, VBA, Surfacemovement observation system
