关键词: 开采沉陷, 概率积分法, 绿色开采, VB, VBA, 观测站设计, 塌陷治理

Abstract: Mining subsidence prediction and comprehensive treatment of mined-out area are the two important research directions of mining subsidence.In view of the problems of single function of program and low capacity of data processing existed in the existing mining subsidence prediction softwares.Based on VB (Visual basic) and VBA (Visual basic for application) language and the softwares of SUFER,EXCEL and CAD,the software system with the functions of surface movement observation station design,data compilation,data extraction,fitting calculation,residual deformation prediction and comprehensive treatment of collapse area is developed.Firstly,the automation degree of observation station design is improved by loading VBA program,and the portability of the program is also improved;secondly,the prediction parameters of probability integral method is calculated accurately by calling the MATLAB fitting procedure,and the mining subsidence is predicted by using the prediction parameters of probability integral method and mining and geological data;finally,the subsidence prediction visualization is realized by calling the Surfer and CAD software functions.The theoretical analysis and example analysis results show that the processing efficiency of observation data is improved by using the software system based on the integration design idea,which is help for improving the pertinence and accuracy of mining subsidence prediction,besides that,the software system can also be used to predict the mining subsidence of the mining area that the strip and filling mining method is adopted,therefore,it can provide technical basis for the "under three" mining optimization design,ecological environment protection of mining area and land reclamation of mining area,besides that,it can also provide some reference for the realization of green mining.

Key words: Mining subsidence, Probability integral method, Green mining, VB, VBA, Design of observation station, Collapse treatment