基于Visual Lisp和VBA的爆破辅助设计系统研究与应用  

Research and Application of Blasting Auxiliary Design System Based on Visual Lisp and VBA

作　　者：刘超 莫东旭 薛小蒙 罗佳 赖伟 LIU Chao;MO Dongxu;XUE Xiaomeng;LUO Jia;LAI Wei(Changsha Institute of Mining Research Co.,Ltd,Changsha,Hunan 410012,China;State Key Laboratory for Metal Mine Safety Technology,Changsha,Hunan 410012,China)

机构地区：[1]长沙矿山研究院有限责任公司,湖南长沙410012 [2]金属矿山安全技术国家重点实验室,湖南长沙410012

出　　处：《矿业研究与开发》2020年第9期149-153,共5页Mining Research and Development

基　　金：“十三五”国家重点研发计划课题(2017YFC0602903)。

摘　　要：针对竖向深孔阶段矿房嗣后充填采矿法的爆破设计工作量大、工作繁琐,受设计者主观因素影响较大,容易出差错等问题,基于Visual Lisp和VBA语言编程,建立爆破辅助设计系统,实现当次爆破设计自动生成,装药单、爆破器材领料单自动统计。设计过程和结果易于操控,施工管理简单,提高了爆破可控程度。相比于传统的爆破设计方法,采用该设计系统所需设计时间仅为原来的30%;为矿山排产创造有利条件,并且爆破设计精度高、差错率低,有效保障了竖向深孔爆破的效果。Blasting design of vertical deep-hole stage stoping method with backfill has the problems of heavy workload,tedious work,great influences of subjective factor by the designer,as well as error prone.Aiming at the problems,based on Visual Lisp and VBA language programming,the blasting auxiliary design system was established to realize the automatic generation of the current blasting design and the automatic statistics of charge list and blasting material requisition list.The blasting design process and results was easy to control,and the blasting construction were easy to manage.The control degree of blasting was improved.Compared with the traditional blasting design method,the design time required by this design system was only 30%of the original time,creating favorable conditions for mine production scheduling.The blasting design accuracy is high,the error rate is low,which effectively ensures the effect of vertical deep-hole blasting.

关 键 词：深孔阶段矿房嗣后充填采矿法 Visual Lisp VBA 爆破设计 辅助设计 

分 类 号：TD853[矿业工程—金属矿开采]