期刊文献+

应用Excel VBA编制煤田钻孔综合成果整理程序 被引量:4

Program compiling for coal field drilling comprehensive results by Excel VBA
下载PDF
导出
摘要 煤田钻孔综合成果的整理、统计计算,是柱状图绘制、煤层对比和储量计算的重要基础工作。传统的整理工作虽然已经借助于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.
出处 《煤田地质与勘探》 CAS CSCD 北大核心 2016年第1期27-30,共4页 Coal Geology & Exploration
关键词 EXCEL VBA 综合成果整理 可采煤层 Excel VBA comprehensive results analysis minable coal seam
  • 相关文献

参考文献12

二级参考文献46

共引文献43

同被引文献34

引证文献4

二级引证文献8

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

内容加载中请稍等...
;
使用帮助 返回顶部