Excel宏在统计储量参数中的应用

Application of Excel Subroutine in Statistics of Reserves Parameters

储量计算中需要分层位统计一些储量参数,用厚度权重法计算单井不同层位的孔隙度,用孔隙体积权重法计算单井不同层位的含水饱和度值,以及计算其他相关特征参数。当计算单元很多时这种计算方法容易出错。考虑到Excel宏语句编写简单,省去了对文件的输入输出操作,结果显示在Excel表中,易于控制。基于此做出了用Excel宏语句来统计并计算这些数据,其中,孔隙度是以厚度权重计算,饱和度是以孔隙体积权重计算,其他相关特征参数如渗透率、次生孔隙度、深侧向电阻率、补偿中子、密度、自然伽马、声波时差、泥质含量暂以厚度权重计算。该宏语句解决了储量计算中分层位统计的工作,具有一定的参考价值。

Usually the zoning statistics of reserve parameters are processed in Excel table with formulae. However, the method is often easy to make mistakes when too many calculation units have to be dealt with. Excel subroutine is easy to be programmed, its outcome is displaying in Excel table, and its I/O operation of files is laborsaving, so that it can effectively decrease the mistakes in boresome manual operations. Our reserve parameter statistics method with Excel subroutine calculates porosity weighted by bed thickness, calculates water saturation weighted by pore volume, while other parameters, such as permeability, secondary porosity, deep lateral resistivity, compensated neutron, density, natural gamma, acoustic slowness and shale content, are temporarily weighted by bed thickness. The source program and its notes are presented in detail. The program has been tested and validated, it can be copied and used directly.