Application of Excel VBA in the Design of Largediameter Longhole Blasting
HUANG Xuan-dong,SHI Xiu-zhi,WU Yong-meng,GUO Qi-lin,SUN Peng-wei,BAI Yong-hong
DOI: https://doi.org/10.3963/j.issn.1001-487X.2012.01.014
2012-01-01
Abstract:Focusing on the features of underground large-diameter longhole for interval charge millisecond blasting design process that is complex,cumbersome,inefficient and error-prone,with the use of the Excel of powerful calculate statistics function and VBA of automation function,the blasting design table system was developed,which consists of parametric input,dynamic calculation,automatically generate material statements,the blasting design optimization,automatic error-detection function,by calling functions,writing the macro code and setting the control to build modules.In practical application of large-diameter longhole mining in Fankou lead-zinc mine,the table system can make the blasting design drawing to become design table quickly and accurately,which is used to guide the blasting working for the fine construction,and automatically made classification statistics of Explosive Materials and Period of blasting explosive etc.It has replaced manual calculation,and obviously improved efficiency and accuracy,reduced the working intensity and achieved good effect,and also can provide reference for other interval charging millisecond blasting design.