综合应用VB和VBA语言的开采沉陷预计及治理系统开发

发布时间：2018-05-30 13:17

本文选题：开采沉陷 + 概率积分法　；参考：《金属矿山》2017年05期

【摘要】：矿区沉陷预计和采空区综合治理是开采沉陷研究的重要内容。现有的开采沉陷预计软件程序功能单一,数据综合处理能力较低,为此,综合应用采用VB(Visual basic)、VBA(Visual basic for application)语言,并结合SUFER、EXCEL和CAD软件,开发了融合地表移动观测站设计、资料整理、数据提取、拟合计算、残余变形预计以及塌陷区综合治理等功能为一体的软件系统。首先通过加载VBA程序提高观测站设计的自动化程度,增加了程序的可移植性;其次调用MATLAB拟合程序实现对概率积分法预计参数的精确求取,并利用求取的概率积分法预计参数以及采矿地质资料进行开采沉陷预计;然后通过调用SUFER、CAD软件程序实现开采沉陷预计的可视化。系统理论和实例分析表明,该系统一体化的设计提高了观测数据的处理效率,有助于提高开采沉陷预计的针对性和精确性,此外,该系统特别增加了适用于条带式、充填式采煤法的矿区地表沉陷预计模块,可为"三下"采煤方案优化设计、矿区生态环境保护以及矿区土地复垦等提供科学依据,为实现绿色开采提供参考。
[Abstract]:The prediction of mining subsidence and the comprehensive control of goaf are the important contents of mining subsidence research. The existing software for prediction of mining subsidence has a single function and low comprehensive data processing capacity. Therefore, the integrated application of VB(Visual basic software and Visual basic for application) language, combined with the software of SUFER-EXCEL and CAD, is used to develop the design and data arrangement of the ground movement observation station. The software system is composed of data extraction, fitting calculation, residual deformation prediction and comprehensive treatment of subsidence area. Firstly, the automation degree of the station design is improved by loading the VBA program, and the portability of the program is increased. Secondly, the accurate calculation of the predicted parameters of the probabilistic integral method is realized by using the MATLAB fitting program. The mining subsidence prediction is carried out by using the probabilistic integration method and the mining geological data, and the visualization of mining subsidence prediction is realized by using SUFER-CAD software program. The system theory and example analysis show that the integrated design of the system improves the processing efficiency of observation data and helps to improve the pertinence and accuracy of the prediction of mining subsidence. In addition, the system is especially suitable for strip type. The ground subsidence prediction module of backfill mining method can provide scientific basis for the optimization design of "three down" coal mining scheme, the protection of ecological environment in mining area and land reclamation in mining area, and provide a reference for the realization of green mining.
【作者单位】：山东科技大学矿业与安全工程学院;矿山灾害预防控制教育部重点实验室;
【分类号】：TD327

【相似文献】