THE METHOD OF ORIGINAL LOGGING DATA PROCESSING BASED ON VBA

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

The current mainstream well logging file format （ASCII, LAS, WIS） cannot be loaded in some log interpretation software, just like Carbon BendlinkEx, directly. This paper talks about how to transform LAS file format into TXT file format which Carbon can identify. First, delete redundant information in the LAS file and transform it into TXT file format by using function ＂formatting format＂ in VBA. Sec- ond, transform all LAS files together by using function ＂process all＂. This method can decrease research- ers＇ duplication of work and human errors which will improve work efficiency greatly.