论文详情

基于VBA的测井原始数据处理方法

断块油气田

2014年 21卷第02期

阅读：116

查看详情

Title

Method of original logging data processing based on VBA

作者

谢传礼张航王强

单位

中国石油大学（北京）油气资源与勘探国家重点实验室，北京 102249

Organization

State Key Laboratory of Petroleum Resource and Prospecting, China University of Petroleum, Beijing 102249, China

摘要

目前主流测井仪器生成的ASCII，LAS，WIS文件格式，在卡奔BendlinkEx等测井解释软件中无法直接加载。以处理LAS文件适应卡奔导入要求为例，介绍以ExcelVBA为基础的测井数据处理方法。利用VBA进行编程，首先通过“格式化格式”函数处理单个文件，删除卡奔软件加载时多余的信息，保留测井作业范围内各种曲线每个采点上的数值，并生成目的格式TXT文件；然后利用“批量处理”函数，对工区所有测井LAS文件进行批量处理，一次性进行所有LAS文件向BendlinkEx可识别的TXT文件的转换，完成测井解释数据准备工作。该方法极大地降低了重复性数据操作，减少了人工参与和人为错误的发生，提高了工作效率，对地球物理和地质开发研究具有重要意义。

Abstract

At present, the file format (ASCII, LAS, WIS) generated by mainstream well logging tools cannot be directly loaded in some log interpretation software, just like Carbon BendlinkEx. This paper talks about how to transform LAS file format into TXT file format which Carbon can identify. First, deleting the redundant information in the LAS file and transforming it into TXT file format by using function "formatting format" in VBA. Second, using the function "batch processing", transforming all LAS files into TXT files identified by BendlinkEx. This method can decrease the duplication of researchers work and human errors significantly and improve work efficiency greatly, having an important signification for geophysical and geological development study.

关键词：

LAS格式; 测井数据; ExcelVBA; 批量处理

;

Keywords:

LAS format; logging data; Excel VBA; batch processing

;

基金项目

DOI

10.6056/dkyqt201402014