Excel宏在井中三分量磁测数据处理中的应用
|
摘要
论文首先了解井中三分量的工作方法原理,然后研究了井中三分量磁测数据处理公式和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.
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.
引文
[1]张丽霞.井中磁测技术发展述评[J].工程地球物理学报,2007,4(4):375-380.
[2]陕西省地质局第二物探队.井中三分量磁测[M].北京:地质出版社,1974.
[3]地质矿产部第一综合物探大队.井中磁测[M].北京:地质出版社,1985.
[4]地质部第一综合物探大队.井中磁测在普查勘探磁铁矿中的应用[J].物探与化探,1979,3(6):50-60,49.
[5]蔡柏林.钻孔地球物理勘探[M].北京:地质出版社,1986.
[6]蔡柏林.测井与井中物探的回顾与展望[J].物探与化探,1989,13(5):370-380.
[7]蔡柏林.井中物探的发展现状和展望[J].物探化探译从,1992(4):101-104.
[8]刘天成.井中磁场强度测量的资料整理[J].物探与化探,1981,5(4):233-239.
[9]刘天佑,吴招才,詹应林,等.磁异常小波多尺度分解及危及矿山的深部找矿:以大冶铁矿为例[J].地球科学:中国地质大学学报,2007,32(1):135-140.
[10]刘天佑,刘大为,詹应林,等.磁测资料处理新方法及在危及矿山挖潜中的应用[J].物探与化探,2006,30(5):377-381.
[11]张恒磊,刘天佑.给予小波分析的磁测数据处理流程及解释方法[J].物探与化探,2009,33(6):686-690.
[12]潘和平,牛一雄,王文先,等.中国大陆科学钻探主孔井中磁测[J].地球科学,2004,29(S):1-5.
[13]熊选文,邹长春.井中三分量磁测数据转换及绘图软件的设计和实现[J].物探与化探,2008,32(6):685-689.
[14]张豆娟,陈存元.Excel宏在统计储量参数中的应用[J].测井技术,2006,30(6):541-543.
[15]张豆娟,陈存元.Excel宏语句在测井解释夹层处理中的应用[J].石油天然气学报,2006,28(4):72-74.
[16]胡建平,孙阳.Excel宏在地质样品分析数据快速处理中的应用[J].岩矿测试,2008,27(6):463-466.
[17]陈天振,李卫花,徐遂勤,等.井中三分量磁测方法与效果初探[J].地球物理学进展,2008,23(3):892-897.
[18]中华人民共和国地质矿产行业标准.井中磁测技术规程[S].北京:地质出版社,2016:3.
[19]杨坤彪,陶德益,范新省.利用井中磁方位异常判断磁性体位置的方法[J].物探与化探,2010,34(6):717-721.
[20]JOHN WALKENBACH.Excel2002公式与函数应用宝典[M].路小村,李双庆,等译.北京:电子工业出版社,2002.
[2]陕西省地质局第二物探队.井中三分量磁测[M].北京:地质出版社,1974.
[3]地质矿产部第一综合物探大队.井中磁测[M].北京:地质出版社,1985.
[4]地质部第一综合物探大队.井中磁测在普查勘探磁铁矿中的应用[J].物探与化探,1979,3(6):50-60,49.
[5]蔡柏林.钻孔地球物理勘探[M].北京:地质出版社,1986.
[6]蔡柏林.测井与井中物探的回顾与展望[J].物探与化探,1989,13(5):370-380.
[7]蔡柏林.井中物探的发展现状和展望[J].物探化探译从,1992(4):101-104.
[8]刘天成.井中磁场强度测量的资料整理[J].物探与化探,1981,5(4):233-239.
[9]刘天佑,吴招才,詹应林,等.磁异常小波多尺度分解及危及矿山的深部找矿:以大冶铁矿为例[J].地球科学:中国地质大学学报,2007,32(1):135-140.
[10]刘天佑,刘大为,詹应林,等.磁测资料处理新方法及在危及矿山挖潜中的应用[J].物探与化探,2006,30(5):377-381.
[11]张恒磊,刘天佑.给予小波分析的磁测数据处理流程及解释方法[J].物探与化探,2009,33(6):686-690.
[12]潘和平,牛一雄,王文先,等.中国大陆科学钻探主孔井中磁测[J].地球科学,2004,29(S):1-5.
[13]熊选文,邹长春.井中三分量磁测数据转换及绘图软件的设计和实现[J].物探与化探,2008,32(6):685-689.
[14]张豆娟,陈存元.Excel宏在统计储量参数中的应用[J].测井技术,2006,30(6):541-543.
[15]张豆娟,陈存元.Excel宏语句在测井解释夹层处理中的应用[J].石油天然气学报,2006,28(4):72-74.
[16]胡建平,孙阳.Excel宏在地质样品分析数据快速处理中的应用[J].岩矿测试,2008,27(6):463-466.
[17]陈天振,李卫花,徐遂勤,等.井中三分量磁测方法与效果初探[J].地球物理学进展,2008,23(3):892-897.
[18]中华人民共和国地质矿产行业标准.井中磁测技术规程[S].北京:地质出版社,2016:3.
[19]杨坤彪,陶德益,范新省.利用井中磁方位异常判断磁性体位置的方法[J].物探与化探,2010,34(6):717-721.
[20]JOHN WALKENBACH.Excel2002公式与函数应用宝典[M].路小村,李双庆,等译.北京:电子工业出版社,2002.