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

Calculating the total recovery of mineral resources by means of excel

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.