应用Excel VBA编制煤田钻孔综合成果整理程序  

Program compiling for coal field drilling comprehensive results by Excel VBA

作　　者：王乔[1] 窦延宝 石立华 陈龙[1] 张博[1] 

机构地区：[1]贵州省煤田地质局地质勘察研究院,贵州贵阳550008 [2]陕西延长石油(集团)有限责任公司研究院,陕西西安710075

出　　处：《煤田地质与勘探》2016年第1期27-30,共4页Coal Geology & Exploration

摘　　要：煤田钻孔综合成果的整理、统计计算,是柱状图绘制、煤层对比和储量计算的重要基础工作。传统的整理工作虽然已经借助于Excel,但是手动处理耗时耗力。为了提高工作效率和准确率,应用VBA语言开发了一个钻孔综合成果整理程序,并把它应用于贵州省赫章县结构勘查区煤炭勘探项目中。应用证明,该程序比传统的手动处理省时省力,准确度高。Coal drilling comprehensive results analysis and statistical calculations are important foundation works of correlation of histogram drawing, coal seams and coal reserves calculation. Although the traditional analyses work has used Excel, manual processing is demanding. VBA language is embedded in the EXCEL and easy to grasp, and development of the related calculation program can greatly improve the efficiency of the technical staff. A comprehensive results analysis program has been developed with VBA and has been applied in the project of coal exploration area design in Jiegou of Hezhang County, Guizhou Province. Practice has proved that the program is efficient and has high accuracy.

关 键 词：EXCEL VBA 综合成果整理 可采煤层 

分 类 号：P618.110.2[天文地球—矿床学]