基于VBA的石油地质数据处理

Processing petroleum geological data with VBA

海量数据处理是石油地质项目开展过程中的重要工作,若依靠纯手工处理工作量巨大。文章提出了基于VBA数据批量处理方法,以气藏数值模拟工艺改造数据的处理为例,在EXCEL中运用VBA进行编程,实现海量射孔数据的提取与标准化处理。首先从井史数据出发,借助文件对象打开对应井单的射孔数据文件,然后循环提取射孔数据中的相关数据信息,进行标准化处理后写入工艺改造数据表格中,生成气藏数值模拟的基础数据体。针对示范工区数据处理表明,该方法不但极大地提高了气藏数值模拟基础数据的整理效率,同时也能克服人工处理因疲劳导致的错误,提高了数据处理的质量。

Massive data processing is often faced in the process of petroleum geological projects,and it is hard by manual process.This paper proposes a data batch processing method via VBA.Taking the data processing of numerical simulation process for gas reservoir as an example,the Excel spreadsheet is used with VBA programming to realize the massive perforation data extraction and standardized processing.Firstly,from well history data,opening the perforation data file of the corresponding well sheet with the help of the file object,then circularly extracting relevant data information from perforation data and writing into the data form of process modification after standardized processing,at last generating the basic data volume for numerical simulation of gas reservoir.Data processing for demonstration area shows that this method not only greatly improves the efficiency of sorting out the basic data of gas reservoir numerical simulation but also overcomes the errors caused by fatigue and improves the quality of data processing.