利用Excel及辅助插件建立银山勘探项目资源储量估算系统

Establishment of resource reserve estimation system for Yinshan exploration project by using Excel and auxiliary plug-in

《固体矿产勘查工作规范》中认证的资源储量估算软件在地质特征不同的矿山使用时具有一定的局限性,为达到更普适性进行资源储量估算的目的,本文以银山勘探项目为例,使用EXCEL软件强大的函数功能和辅助插件"Excel精灵"的批处理功能,不仅创建了几何法估算资源储量的完整系统,更完善了勘探报告所需的各类附表样式,达到了近乎全自动化数据生成和资源储量估算的目的。该系统经银山勘探项目实战检验证实,可极大地节省地质技术人员报告附表的编制时间和精力。

The software of resource and reserve estimation certified in the work specification for solid mineral exploration has certain limitations when it is used in mines with different geological characteristics. In order to achieve the purpose of more universal resource and reserve estimation, this paper takes Yinshan exploration project as an example, using the powerful function of Excel software and the batch processing function of the auxiliary plug-in "excel Wizard", not only creates the geometry method The complete system for estimating resource reserves has improved the forms of various schedules required for exploration reports, and achieved the goal of nearly full-automatic data generation and resource reserves estimation. The system has been proved by the practical test of Yinshan exploration project, which can greatly save the time and energy for the preparation of the attached report form of the geologists.