论文部分内容阅读
针对瓦斯地质参量岩层厚度效应系数计算复杂、工作量大且易出错的特点,提出了基于Excel-VBA强大数据处理功能和VBA二次开发的编程思路,设计了程序计算界面,实现了岩层厚度效应系数(RTE)和砂岩比自动计算功能。程序具有自动判识、自动计算、自动保存特点,减少了瓦斯地质工作人员的工作量,提高了计算精度,在陶二矿瓦斯地质分析应用中取得了良好效果。
Aiming at the characteristics of complexity calculation, heavy workload and error-prone effect of formation geological parameters, a programming idea based on powerful data processing function of Excel-VBA and secondary development of VBA is proposed. The program calculation interface is designed and the thickness effect of rock formation is realized Coefficient (RTE) and sandstone ratio automatic calculation function. The program has the characteristics of automatic identification, automatic calculation and automatic saving, which reduces the workload of gas geologic staff and improves the calculation precision. The program has achieved good results in gas geological analysis of Tao 2 Mine.