煤田地质与勘探2017，Vol.45Issue(1)：41-44,4.DOI:10.3969/j.issn.1001-1986.2017.01.008
应用Excel VBA编制煤田钻孔孔斜批量处理程序
Application of Excel VBA in compiling batch processing program for borehole de-viation in coalfield
王乔 1万单静 2张博 1陈龙 1石立华3
作者信息
- 1. 贵州省煤田地质局地质勘察研究院,贵州贵阳 550008
- 2. 中原油田分公司内蒙采油厂,河南濮阳 457001
- 3. 陕西延长石油(集团)有限责任公司研究院,陕西西安 710075
- 折叠
摘要
Abstract
Correction computation of borehole deviation in coalfield is an important basic work for determination of stratigraphic boundaries and coal seam coordinates, plan drawing of exploration line section and reserves, affect directly the calculation of reserves. The traditional hole deviation correction has been made with the aid of Excel, manual input is time and efforts demanding and error–prone. Based on geological practice, the authors developed a batch processing program for borehole deviation by applying VBA embedded in Excel from the basic heoretical knowledges of calculation method for borehole deviation correction and applied it well in the coal exploration pro-ject of Qingshan coal mine in Jiangzhou, Duyun City, Guizhou Province.关键词
Excel/VBA/孔斜/计算法/测斜点/煤层Key words
Excel/VBA/hole deviation/calculation method/deviation measurement point/coal seam分类
天文与地球科学引用本文复制引用
王乔,万单静,张博,陈龙,石立华..应用Excel VBA编制煤田钻孔孔斜批量处理程序[J].煤田地质与勘探,2017,45(1):41-44,4.
