|
|
|
| Practice of rapid extraction and unified reform of reserves database by using Excel |
| Xue Yakun |
| Tangshan Kailuan Linxi Mining Corporation Ltd., Tangshan 063100, China |
|
|
|
|
Abstract in the calculation of mine reserves, the formula is edited by Microsoft Excel, then the reserves are calculated, and the reserves calculation results are filled in AutoCAD. After the implementation of GB / T 17766-2020 solid mineral resources reserve classification in May 2020, the original reserve classification needs to be modified on a large scale. In this paper, through the flexible use of office software such as AutoCAD, Microsoft Excel and word, the work efficiency was improved and the error probability in the process of data conversion was reduced.
|
|
|
|
|
|
| [ 1 ] 才向军. 巧借EXCEL用AutoCAD绘制地质柱状图[ J ]. 矿山测量，2008（ 1 ）：45 - 47.
[ 2 ] 才向军. 储量数据库关联储量块段图元初探[ J ]. 矿山测量，2012（ 6 ）：93 - 94.
[ 3 ] 何秀珍，孟继红. AutoCAD矿山三维立体图制作方法及应用浅议[ J ]. 矿山测量，2011（ 1 ）：23 - 26.
[ 4 ] 王德利. 面向国际化的固体矿产资源/储量分类标准修订研
究[ J ]. 中国矿业，2017，26（ 10 ）：42 - 47.
[ 5 ] 戴绍杰，吕向志，陈志文. 固体矿产资源/储量分类与三轴配套关系的探讨[ J ]. 资源环境与工程，2010，24（ 1 ）：94 - 97.
[ 6 ] 凡家杰，欧阳陵. 固体矿产资源/储量分类的探讨[ J ]. 工程建设，2014，46（ 6 ）：42 - 47. |
|
|
|
