|
|||||
|
|
| Execl宏在井斜数据计算中的应用 | |
| 引用本文： | 王高成,林承焰,郭玲,许磊,戴鹤伟.Execl宏在井斜数据计算中的应用[J].物探化探计算技术,2008,30(6). |
| 作者姓名： | 王高成 林承焰 郭玲 许磊 戴鹤伟 |
| 作者单位： | 1. 中国石油大学,山东,东营,257061;中石油浙江油田分公司,浙江,杭州,310001 2. 中国石油大学,山东,东营,257061 3. 四川石油管理局物探公司,四川,成都,610213 4. 中国石油勘探开发研究院,北京,100083 |
| 摘 要： | 为改进在大斜度井及井斜方位角变化大的情况下,采用目前地质研究中常用的直线法进行测斜计算所造成的计算结果误差较大,以及地下构造形态严重歪曲的情况,利用MicrosoftExcel内嵌的宏语言编写了Devprocess宏程序。该程序以我国钻井行业标准规定的校正平均法为原理,并在考虑了二相邻测点间的方位角变化绝对值大于180°及统一第0测点的情况下,实现了自动计算多井的井斜数据。经与Petrel等商业化软件的计算结果相比,该程序具有计算精度高、数据输入输出方便、运行简单、兼容性和可移植性强等特点,在井斜校正工作中有一定的参考价值。 |
| 关 键 词： | 校正平均法 直线法 井斜校正 Excel宏 |
Application of excel subroutine in computation of hole deviation |
|
| WANG Gao-cheng,LIN Cheng-yan,GUO Ling,et al..Application of excel subroutine in computation of hole deviation[J].Computing Techniques For Geophysical and Geochemical Exploration,2008,30(6). | |
| Authors: | WANG Gao-cheng LIN Cheng-yan GUO Ling |
| Institution: | WANG Gao-cheng1,LIN Cheng-yan1,GUO Ling2,et al. |
| Abstract: | 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. |
| Keywords: | corrected averaging method straight-line method hole deviation correction excel subroutine |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ | |