基于VBA的小层内单砂体原始数据合并方法  

THE METHOD OF MERGERING ORIGINAL SINGLE SAND BODY DATA IN SUBLAYERS BASED ON VBA

作　　者：于浩洋 谢传礼[1] 王强[1] 张慧[1] 

机构地区：[1]中国石油大学(北京)油气资源与勘探国家重点实验室

出　　处：《石油工业计算机应用》2014年第2期28-31,4,共4页Computer Applications Of Petroleum

基　　金：国家科技重大专项(2011ZX05024-001);中石油冀东油田"柳赞油田沙三5油藏地震资料精细处理解释;地质建模与剩余油分布研究"(2010-5s-103)联合资助

摘　　要：目前储集层单砂体是地质开发工作的基本处理单位,小层平面图是油藏描述、储量计算、油田开发及动态分析等油田开发核心业务中的一种不可缺少的基础地质图件。小层平面图以小层为研究单位,为满足后续研究需要,小层内若干单砂体需要合并。以合并处理小层内单砂体厚度及物性参数为例,介绍以Excel VBA为基础的数据处理方法。利用VBA进行编程,通过"单砂体合并"函数批量处理原始文件,合并小层内若干单砂体,完成数据准备工作。该方法极大的降低了重复性数据操作,减少了人工参与和人为错误的发生,提高了工作效率,对从事地球物理和地质开发研究的人有重要意义。Reservoir single sand body is the basic processing unit of geological development work at present.Small floor plan is an indispensable basic geological map of reservoir description,calculation of reserves,oilfield development and dynamic analysis.Sublayer floor plan is based on sublayer.To meet the needs of the following research,a number of single sand bodies in sublayers need to merge.Taking mergering single sand body thickness in a sublayer and physical property parameters as an example,the paper introduces a data processing method based on ExcelVBA.VBA is used to programme. 'Single sand body mergering' functions are used to process the original files in a batch to merger the single sand bodies in a sublayer and complete data preparation job.This method greatly reduces the repetitive data operation,the artificial participation and the occurrence of human error.It improves work efficiency and has important significance to the people engaged in geophysical and geological development research.

关 键 词：单砂体合并 小层 EXCEL VBA 批量处理 

分 类 号：TP391.72[自动化与计算机技术—计算机应用技术]