Excel宏在水平井测井解释中的应用  

The Application of Excel Subroutine in Horizontal Well Logging Interpretation

作　　者：迟洪岩[1] Chi Hongyan

机构地区：[1]大庆油田有限责任公司勘探开发研究院

出　　处：《国外测井技术》2021年第5期15-17,2,共4页World Well Logging Technology

摘　　要：新完钻的水平井常需要立即对水平井段进行初步测井解释,同时对水平井段的砂岩钻遇率、有效钻遇率、油层长度等数据进行统计。笔者利用EXCEL中VBA宏工具,实现了测井曲线解释及统计工作,同时将成果直接输入EXCEL表格中。方法具有实效高、统计误差小的优点,对测井解释工作具有一定的参考价值。The well logging of the horizontal section needs interpreting when the horizontal well drilling was just finished at Well site,and the ratio of drilling sandstone and effective of the horizontal section will be statistical.Thewriters useVBAmacro tool in EXCEL to realize data calculations and statistical work,and the results are output in EXCEL spreadsheet form.The statistical method has the advantages of high efficiency and less error.It has a certain reference value to other blocks in horizontal well logging interpretation.

关 键 词：钻遇率 测井解释 有效厚度 VBA宏 

分 类 号：TP3[自动化与计算机技术—计算机科学与技术]