基于VBA开发的矿体自动圈定及资源储量估算智能化  

The realization of automatic orebody determination based on VBA and the intelligent estimation of resource reserves

作　　者：史国伟 SHI Guowei(The Geological Team No.217 of Hunan Provincial Nonferrous metals Geological Exploration Bureau,Hengyang 421001,Hunan,China)

机构地区：[1]湖南省有色地质勘查局217队

出　　处：《矿产与地质》2019年第5期933-936,940,共5页Mineral Resources and Geology

基　　金：中国地质调查局发展研究中心“老矿山深部和外围找矿项目”（编号：12120113083300）资助

摘　　要：资源储量估算是地质工作主要任务之一,特别是三维软件运用,给矿山生产带了很大变革。在信息技术的推动下,利用三维软件资料收集,编写核实报告、年报,数据成图难度大。前人利用Excel表格自带函数进行估算,减轻了劳动强度,现阶段储量快速动态估算与管理,传统方法短时间内无法完成任务。利用VBA编写程序实现矿体自动圈定,通过验证符合矿体圈定要求,且显著提高了速度。同时用VBA编写程序,通过填写少量数据,结合Excel自带函数,实现资源储量估算智能化。Resource reserve estimation is one of the main tasks of geological work.The application of three-dimensional software has brought great changes to mine production.In the application of information technology,it is difficult to draw data map in the collection and compiling verification reports,annual reports by using three-dimensional software.The function of Excel software is used to estimate resource reserves,and the labor intensity is reduced.At present,the traditional methods cannot accomplish the task of fast dynamic estimation and management of resource reserves in a short time.This paper introduces how to use VBA program to realize the automatic determination of orebodies,which meets the requirements of orebody determination by verification,and improves the speed significantly.For the application of VBA program,the intelligent estimation of resource reserves is realized by filling in a small amount of data with the combination of Excel's own function.

关 键 词：VBA EXCEL 矿体圈定 储量估算 自动 

分 类 号：P628[天文地球—地质矿产勘探] P624.7[天文地球—地质学]