煤矿采空区地基稳定性评价的VBA程序设计

Development of VBA Program for Stability Evaluation of Building Foundation over Mined-out Areas

大面积的采空区给城市的建设带来极大的不利影响,大多数建筑物在建设前需要对采空区进行回填、灌浆等人工地基处理,造价非常高,因此需对采空区场地的稳定性做出正确的评价。基于Excel的VBA程序,根据相关规范公式编制了针对煤矿采空区地基稳定性评价的计算程序,该程序能对拟建场地的多点、多区域进行快速计算,得到最大残余沉降、曲率、倾斜、水平变形、水平移动等参数,根据这些参数进而能够准确地绘制出各种等值线,实现地基稳定性的正确评价。

Mined-out area bring enormous harmful effect for construction of city,in most cases the mined-out area must be treated with backfill,grouting and so on before the construction of buildings,which usually has large cost,so it is very necessary to exactly evaluate the stability of the building foundation over mined-out area.Based on Excel VBA program and relevant specification formulas,a calculation program for the stability evaluation of foundation over mined-out area in coal mine was developed.By the developed program,fast multi-points and multi-area calculation can be made on a proposed building site,resulting in the maximum residual settlement and curvature,the tilt,horizontal deformation and horizontal movement.Based on the obtained parameters,the various isotropic lines can be drew,and the correct evaluation of foundation stability can be realized.