Excel宏在井中三分量磁测数据处理中的应用  

Application of Excel Macro in Date Processing of Three-Component Magnetic Measurement in Well

作　　者：孙双振[1] 杨超[1] 贾磊[1] 易凯[1] 刘立安 SUN Shuang-zhen;YANG Chao;JIA Lei;YI Kai;LIU Li-an(The Fifth Geology Company of Hebei Geology and Minerals Bureau,Tangshan 063000,China)

机构地区：[1]河北省地矿局第五地质大队,河北唐山063000

出　　处：《河北地质大学学报》2019年第1期74-78,共5页Journal of Hebei Geo University

摘　　要：论文首先了解井中三分量的工作方法原理,然后研究了井中三分量磁测数据处理公式和MapGIS成图原理,通过编辑Excel的宏来处理井斜数据,获得与三分量深度一致的新井斜数据。根据编辑的Excel公式计算出ΔH_⊥和ΔH_∥,与ΔZ矢量合成ΔT_⊥和ΔT_∥。按编辑的宏代码处理得出矢量线成图数据,再通过Mapgis(投影变换)形成图件。运用Excel宏可以快捷地得到成图数据,用此方法可以准确得到完整的ΔZ、ΔHˊ、ΔH_⊥、ΔH_∥、ΔT_⊥和ΔT_∥六个参数,然后根据需要进行参数组合成图件。通过找矿实例验证和多年的应用改进,成功实现了井中三分量磁测数据处理成图应用。这样就为以后井中三分量磁测数据处理成图工作提供了新的参考方法,具有一定的应用前景。First,the working principle of the three-component in the well is analyzed,then the processing formulas of three-component magnetic data in well and the principle of MapGIS are studied;by editing the Excel macro to handle the well skew data,and the new well skew data consistent with the three-component depth is obtqined.According to the edited Excel formula,the ΔH⊥ and ΔH∥are calculated,and coming with ΔZ vector ΔT⊥and ΔT∥are synthesised.According to the edited the macro code processing vector line data,maps are formed by MapGIS(projection transformation).By use of Excel macro graph data can be quickly obtained,using this method a complete ΔZ、ΔHˊ、ΔH⊥、ΔH∥、ΔT⊥ and ΔT∥six parameters can be got,and then according to the need,parameter combined into a datum.The application of three-component magnetic survey data in well is successfully realized through the verification of ore prospecting and application improvement over many years.This provides a new plan for the processing and mapping of three-component magnetic measurement data in the well,having certain application prospect.

关 键 词：EXCEL宏 井斜数据处理 矢量线 

分 类 号：P318.4[天文地球—固体地球物理学]