EXCEL宏在测井建模中的应用

APPLICATION OF EXCEL MACRO IN WELL LOGGING MODELING

应用岩心分析资料刻度测井资料建立解释模型时，通常要将离散的非等距的岩心分析资料与连续的等间距的测井资料进行匹配；而EXCEL作为一款普及率非常高的办公软件，简单易用，尤其是其扩展的宏语句；本文介绍了一种用EXCEL宏来直接进行数据匹配的方法，匹配后可直接在EXCEL中分析，省去了借助其他的解释软件，为油田进行岩心分析数据刻度测并资料时提供了一种简单可行的方法。

When calibrating logging data to establish interpretation model with core analysis data,the discrete non-isometric core analysis data usually need to match with the consecutive equispaced logging data.Microsoft EXCEL as a popular office software is simple and easy to use,especially the extended macrostatement.This paper introduces a method by which data can be matched directly with EXCEL and analysed in EXCEL without any help of other interpretation software.It has provided a simple and feasible method for logging data calibration with core analysis data.