| 春乃芽,岳德臣,梁义.利用Excel计算矿产资源综合利用率[J].矿产勘查,2022,13(11):1676-1680 |
| 利用Excel计算矿产资源综合利用率 |
| Calculating the total recovery of mineral resources by means of excel |
| 投稿时间：2021-07-14 |
| DOI：10.20008/j.kckc.202211010 |
| 中文关键词: 价值法 矿产综合利用率 当量品位 Excel模板设计 |
| 英文关键词: value-based total recovery of mineral resources equivalent grade Excel template |
| 基金项目: |
|
| 摘要点击次数: 1088 |
| 全文下载次数: 1048 |
| 中文摘要: |
| 年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. |
|
查看全文
查看/发表评论 下载PDF阅读器 |
| 关闭 |
|
|
|