摘要
针对瓦斯地质参量岩层厚度效应系数计算复杂、工作量大且易出错的特点,提出了基于Excel-VBA强大数据处理功能和VBA二次开发的编程思路,设计了程序计算界面,实现了岩层厚度效应系数(RTE)和砂岩比自动计算功能。程序具有自动判识、自动计算、自动保存特点,减少了瓦斯地质工作人员的工作量,提高了计算精度,在陶二矿瓦斯地质分析应用中取得了良好效果。
In view of the characteristics of strata thickness effective coefficient as a gas geology parameter such as the complexity and large workload of its calculation and being easy to make mistake,a computation program to achieve the automatic calculation of rock thickness efficient(RTE) coefficient and the thickness ratio of sandstone was developed based on the powerful data processing function of Excel-VBA and the secondary development function of VBA.The computation program can calculate and judge RTE coefficient and the thickness ratio of sandstone and save the calculated results automatically,so can reduce the workload of the parameters calculation,improve the precision of the calculation.It has been applied to gas geology analysis in Tao-er coal mine with good effect.
出处
《矿业研究与开发》
CAS
北大核心
2011年第3期65-67,107,共4页
Mining Research and Development
基金
国家自然科学基金资助项目(41072114)
关键词
瓦斯地质参数
VBA二次开发
砂岩比
岩层厚度效应系数
Gas geology parameters
Secondary development of VBA
Sandrock ratio
Rock thickness effective coefficient