APPLICATION OF EXCEL SUBROUTINE IN COMPUTATION OF HOLE DEVIATION

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.