Execl宏在井斜数据计算中的应用  

APPLICATION OF EXCEL SUBROUTINE IN COMPUTATION OF HOLE DEVIATION

作　　者：王高成[1,2] 林承焰[1] 郭玲[3] 许磊[4] 戴鹤伟[1] 

机构地区：[1]中国石油大学,山东东营257061 [2]中石油浙江油田分公司,浙江杭州310001 [3]四川石油管理局物探公司,四川成都610213 [4]中国石油勘探开发研究院,北京100083

出　　处：《物探化探计算技术》2008年第6期494-499,共6页Computing Techniques For Geophysical and Geochemical Exploration

摘　　要：为改进在大斜度井及井斜方位角变化大的情况下,采用目前地质研究中常用的直线法进行测斜计算所造成的计算结果误差较大,以及地下构造形态严重歪曲的情况,利用MicrosoftExcel内嵌的宏语言编写了Devprocess宏程序。该程序以我国钻井行业标准规定的校正平均法为原理,并在考虑了二相邻测点间的方位角变化绝对值大于180°及统一第0测点的情况下,实现了自动计算多井的井斜数据。经与Petrel等商业化软件的计算结果相比,该程序具有计算精度高、数据输入输出方便、运行简单、兼容性和可移植性强等特点,在井斜校正工作中有一定的参考价值。For the Hole deviation correction purpose in multi-well survey computation,an Excel macro software,Devprocess,was written in VBA language in order to fetch up the deficiencies brought by the two following situations: one is the poor accuracy in the deviation survey computation when the straight line method is applied for wells of high deviation or wells with tremendous change of drift azimuth,and the other is serious distorts of the structural form of subsurface.Based on the corrected average principle,this software can help achieve auto multi-well survey computation through the consideration of the situation when the absolute azimuth change between the two adjacent survey points exceeds 180 degree and the situation of unification of zero survey point.The comparison between computation results from preprocess and these from other commercialized software such as Petrel has shown the advantages of the former.Devprocess executes efficient computation with higher accuracy by easier method of data input/output with I/O operations easy to be programmed,and it is also highly compatible,transplantable to be integrated with other software.These qualities promise Devprocess a wide range of application in hole deviation correction.

关 键 词：校正平均法 直线法 井斜校正 EXCEL宏 

分 类 号：TE122.35[石油与天然气工程—油气勘探]