Excel宏在石油储量计算中的应用

在石油地质储量计算中,需要统计大量的单井数据,如有效厚度、有效孔隙度、含油饱和度等,而各种参数所要求的统计方法并不相同,单井有效厚度采用各油层的有效厚度之和,单井的孔隙度采用有效厚度权重法计算,单井的含油饱和度采用孔隙体积权重法计算。由于数据量巨大,容易出错。笔者利用EXCEL中的VBA宏工具,实现了对以上数据批量统计的工作,并将结果以EXCEL表格形式输出。统计方法具有效率高、误差小、不易出错等优点,对储量计算具有一定的参考价值。

Application of Excel Macro in Oil Reserves Calculation

In petroleum geological reserves calculation,statistics is needed to large numbers of individual well data,such as effective thickness,effective porosity and oil saturation,etc.Statistical methods for each parameter are not the same.Effective thickness of a single well uses the sum of effective thickness of each oil layer,porosity calculation uses the method of effective thickness weighting and oil saturation calculation uses the method of pore volume weighting.It is easy to make mistakes because of large numbers of data.The writer uses VBA macro tool in EXCEL to realize batch statistic of the above data and output in EXCEL list form.The statistical method has advantages of high efficiency and small error.It has reference value in calculation of reserves.