摘要
目前地质工作中岩层真厚度的计算一般都是采用列昂托夫斯基的传统公式,但公式中有一个正负号的判断经常困扰着广大的地质技术人员。文章里介绍了通过基于excel的vba开发程序来实现岩层真厚度的自动化计算的方法,以方便广大的地质技术人员进行岩层真厚度批量自动计算,提高工作效率,减少运算错误。
At present,the calculation of the true thickness of the rock stratum in the geological work is generally based on the traditional formula of leontovsky,but the judgment of a sign in the formula often troubles the vast number of geological technicians.This paper introduces the method of realizing the automatic calculation of the true thickness of the rock stratum by VBA development program based on Excel,so as to facilitate the vast number of geological technicians to carry out the automatic calculation of the true thickness of the rock stratum in batches,improve the working efficiency and reduce the calculation errors.
作者
郭俊珠
GUO Jun-zhu(Xi'an Huadi Mining Management Co.,Ltd,Xi’an 710000,China)
出处
《世界有色金属》
2019年第21期278-278,280,共2页
World Nonferrous Metals
关键词
岩层
真厚度
计算
rock stratum
true thickness
calculation
