利用Excel计算矿产资源综合利用率  

Calculating the total recovery of mineral resources by means of excel

作　　者：春乃芽 岳德臣 梁义 CHUN Naiya;YUE Dechen;LIANG Yi(Inner Mongolia KeRi Asset Assessment Co.,Ltd.,Hohhot 015002,InnerMongolia,China;Bayannaoer Western Copper Industry Co.,Ltd.,Bayannur 015500,InnerMongolia,China)

机构地区：[1]内蒙古科瑞房地产土地资产评估有限公司,内蒙古呼和浩特015002 [2]巴彦淖尔西部铜业有限公司,内蒙古临河015500

出　　处：《矿产勘查》2022年第11期1676-1680,共5页Mineral Exploration

摘　　要：2015年4月1日国家开始实行行业标准《矿产资源综合利用技术指标及其计算方法》(DT/T 0272—2015),为矿产资源综合开发利用和有效监管提供了更精准的依据,在建设绿色矿山的大背景下,矿山企业动态计算各项综合利用技术指标必将是一项重要的日常工作。本文以价值法计算矿山矿产综合利用率为例,运用Excel的内嵌函数功能,设计Excel计算模板来计算该指标,使用过程既准确又方便,其他指标的计算也可以借鉴设计。On April 1,2015,China began to implement the geological industry standard,Codes for the Comprehensive Utilization of Mineral Resources(DT/T 0272—2015),which provides a more accurate basis and an effective supervision for the comprehensive development and utilization of mineral resources.Under the macroscopic background of building green mines.It must be an important daily work to calculate dynamically the technical indexes of comprehensive utilization in mining enterprises.In this paper,taking the total recovery of mineral resources as an example,by means of Excel’s built-in function,the calculation template of Excel is designed,which is accurate and convenient in the practical process,and the calculation of other indexes can also be used for reference.

关 键 词：价值法 矿产综合利用率 当量品位 Excel模板设计 

分 类 号：P621[天文地球—地质矿产勘探]