Excel宏在储层分类评价中的应用

THE APPLICATION OF EXCEL SUBROUTINE IN RESERVOIR CLASSIFICATION AND EVALUATION

在储层分类评价中,需要统计多个区块大量的单井数据,如有效厚度、有效孔隙度、渗透率、粒度中值等,各种参数的算法并不相同,而每个区块又需要重复同样的统计工作。由于数据量大,工作具有重复性,计算繁琐,易出问题。笔者利用EXCEL中的VBA宏工具,实现了数据的计算和统计工作,并将结果以EXCEL表格形式输出。统计方法具有效率高、不易出错、操作流程简单等优点,对其它油田储层分类评价具有一定的参考价值。

In reservoir classification and evaluation,it is necessary to calculate a large number of single well data of several blocks,such as effective thickness,effective porosity,permeability and grain midvalue,etc.The algorithms of the various parameters are not the same and the same statistical work need to repeat for each block.Due to the large amount of data,repetitive work and tedious calculation,it is easy to make mistake.The writers use VBA macro tool in EXCEL to realize data calculations and statistical work,and the results are output in EXCEL spreadsheet form.The statistical method has the advantages of high efficiency,less error-prone and simple operation process.It has a certain reference value to other oilfields.