Excel宏在求取储层参数中的应用

摘要

Based on the results of the stratigraphic division and correlation,a large amount of data processing work to face,this article calculated reservoir parameters of each small layer by using the Visual Basic editor in Excel subroutine to fast calculating reservoir parameters and improve the work efficiency. The program can solve the repeating tedious work of the reservoir parameters statistics in each small layer, It can quickly implement the data batch processing in each small layer of single well,and output the date with the fixed format. This method is rapid,simple and easy to use,the calculation results are accurate,portability and other characteristics,which have certain reference value for stratified in calculating reservoir parameters.%在地层划分对比结果的基础上，求取各个小层的储层参数时需要面对大量的数据处理工作。为了快速、准确的求取储层参数并提高工作效率，本文提出了利用EXCEL宏中的Visual Basic编辑器进行编程，该程序可以快速实现单井各小层数据批量处理，并按照一定的格式输出，解决了实际工作中面临的单井小层储层参数统计这项重复繁琐的工作。该方法具有快速，简单易用，计算结果准确，可移植性等特点，对分层求取储层参数具有一定的参考价值。