利用Excel实现快速整理CG-5型重力仪静态试验数据和计算漂移常量DRIFT

doi:10.11720/wtyht.2019.1209

摘要
图/表
参考文献
相关文章
Metrics

全文: PDF(951 KB) HTML
输出: BibTeX | EndNote (RIS)

摘要

重力仪静态试验是重力勘探工作开始之前对仪器性能检查的必要环节,由于原理简单,其数据整理常不被人们重视,没有系统的方法,但整理的计算过程却又繁琐复杂,初学者在面对大量数据和多重目标时或顾此失彼,或重复计算,往往要耗费较多的工作时间。Excel电子表格具有强大的数学计算、图形显示功能,且应用广泛,易于操作,可系统整理CG-5型重力仪静态试验的原始观测记录,快速获取静态试验数据表、零点位移曲线及其拟合直线图等直观要素,同时计算得到静态零点位移曲线与直线偏差、平均零点位移率等结果参数,Excel的散点图趋势线功能也改进了静态零点位移校正参数漂移常量DRIFT的计算方法与准确度。这种静态试验数据的整理方法具有快速、准确和直观的优点。

	服务

	把本文推荐给朋友
	加入引用管理器
	E-mail Alert
	RSS
	作者相关文章
	高鹏
	李增涛
	于峰丹
	张旭
	刘生荣

关键词 ： CG-5型重力仪, Excel, 静态试验, 数据整理, DRIFT

Abstract：

The static test of gravimeter is a necessary step for the performance inspection of gravity before the beginning of gravity exploration. Because the principle of data processing in static test is too simple that no one attaches importance to it. So there is no standard and systematic way to deal with it. Nevertheless, its computing process is very complex. When a beginner faces a large number of data and multiple goals, he is prone to neglect one of them or to repeat the calculation. This causes the waste of time. Excel has powerful functions of mathematical calculation and graphic display, and is widely used and easy to operate. Excel can process original observation records of static test of CG-5 gravimeter, quickly get a static test data table and zero point drift curve and its fitting line diagram. At the same time, parameters such as the deviation of zero point drift curve and the straight line as well as the average zero point drift rate are calculated. The scatter plot trend line function of Excel also improves the calculation method and accuracy of static zero shift correction parameter DRIFT. This static test data processing method is quick, accurate and intuitive.

Key words： CG-5gravimeter Excel static test data processing DRIFT

收稿日期: 2018-05-25 出版日期: 2019-02-20

P631.1

基金资助:中国地质调查局“东昆仑铜镍多金属资源基地调查”项目(DD20160013);国家重点研发计划“典型覆盖区航空地球物理技术示范与处理解释软件平台开发”所属课题“北秦岭华阳川地区隐伏铀矿空—地—井协同勘查技术示范研究”(2017YFC0602205)

作者简介: 高鹏(1982-),男,高级工程师,主要从事地球物理勘探工作。Email: gaomou24@163.com

引用本文:

高鹏, 李增涛, 于峰丹, 张旭, 刘生荣. 利用Excel实现快速整理CG-5型重力仪静态试验数据和计算漂移常量DRIFT[J]. 物探与化探, 2019, 43(1): 209-214.
Peng GAO, Zeng-Tao LI, Feng-Dan YU, Xu ZHANG, Sheng-Rong LIU. Quick processing of static test data of CG-5 gravimeter and calculation of the parameter DRIFT using Excel. Geophysical and Geochemical Exploration, 2019, 43(1): 209-214.

链接本文:

https://www.wutanyuhuatan.com/CN/10.11720/wtyht.2019.1209 或 https://www.wutanyuhuatan.com/CN/Y2019/V43/I1/209

Table 1 静态试验数据

Fig.1 零点位移曲线及其拟合直线

Fig.2 零改后零点位移曲线及其拟合直线

[1]	曹金国, 王来鹏, 翟广卿 , 等. CG-5重力仪及应用[M]. 北京: 解放军出版社, 2007.
[1]	Cao J G, Wang L P, Zhai G Q , et al. CG-5 Gravity meter and its application[M]. Beijing: The People’s Liberation Army Press, 2007.
[2]	Scintrex L . CG-5 scintrex autograv system operation manual V5.0[Z]. 2009.
[3]	耿启立 . 重力仪器国外代表产品及国内研发最新进展[J]. 地质装备, 2016,17(1):27-30. doi: 10.3969/j.issn.1009-282X.2016.01.006
[3]	Geng Q L . The latest development of gravity instruments of foreign products and domestic RD[J]. Equipment for Geotechnical Engineering, 2016,17(1):27-30.
[4]	郝洪涛, 李辉, 孙和平 , 等. CG-5重力仪零漂改正及格值系数检测应用研究[J]. 武汉大学学报:信息科学版, 2016,41(9):1265-1271. doi: 10.13203/j.whugis20140919
[4]	Hao H T, Li H, Sun H P , et al. Application of zero drift correct and detection of scale parameters of CG-5 gravimeter[J]. Ucomatics and information Scicncc of Wuhan University, 2016,41(9):1265-1271.
[5]	邢乐林, 李辉, 夏正超 , 等. CG-5重力仪零漂特性研究[J]. 地震学报, 2010,32(3):369-373. doi: 10.3969/j.issn.0253-3782.2010.03.013
[5]	Xing L L, Li H, Xia Z C , et al. Study on zero drift characteristics of CG-5 gravimete[J]. Acta Seismological Sinia, 2010,32(3):369-s373.
[6]	沈博, 袁尚武, 马玄龙 , 等. CG-5重力仪的漂移与寿命[J]. 物探与化探, 2015,39(2):383-386. doi: 10.11720/wtyht.2015.2.29
[6]	Shen B, Yuan S W, Ma X L , et al. Zero drift of CG 5 gravimeter and its service lifetime[J]. Geophysical and Geochemical Exploration, 2015,39(2):383-386.
[7]	邱雪峰, 王应建, 朱命琪 . 求定CG-5型重力仪静态漂移常数的方法研究[J].北京测绘, 2013(6):65-67. doi: 10.3969/j.issn.1007-3000.2013.06.018
[7]	Qiu X F, Wang Y J, Zhu M Y . Study on the method of getting zero drift of CG-5 gravimeter[J].Beijing Surveying and Mapping, 2013(6):65-67.
[8]	汪健, 孙少安, 邢乐林 , 等. CG-5重力仪的漂移特征[J]. 大地测量与地球动力学, 2016,36(6):556-560. doi: 10.14075/j.jgg.2016.06.020
[8]	Wang J, Sun S A, Xing L L , et al. Drift characteristics of CG-5 gravimeter[J]. Journal of Geodesy and Geodynamics, 2016,36(6):556-560.
[9]	于红娟, 郭金运, 李九龙 , 等. 基于主成分分析的相对重力观测零漂和固体潮提取[J]. 大地测量与地球动力学, 2015,35(5):906-909. doi: 10.14075/j.jgg.2015.05.040
[9]	YU H J, Guo J Y, Li J L , et al. Zero drift and solid earth tide extracted from relative gravimetric datawith principal component analysis[J]. Journal of Geodesy and Geodynamics, 2015,35(5):906-909.
[10]	于红娟, 郭金运, 刘扬 , 等. CG-5相对重力仪野外实验精度分析[J]. 测绘科学, 2017,42(3):155-160. doi: 10.16251/j.cnki.1009-2307.2017.03.028
[10]	YU H J, Guo J Y, Liu Y , et al. Precision analysis on CG-5 relative gravimeter through field experiments[J]. Science of Surveying and Mapping, 2017,42(3):155-160.
[11]	刘少明, 孙少安, 卢红艳 , 等. LCR重力仪与CG-5重力仪的长基线混合标定[J]. 大地测量与地球动力学, 2012,32(1):56-59. doi: 10.3969/j.issn.1671-5942.2012.01.013
[11]	Liu S M, Sun S A, Lu H Y , et al. Mixed calibration on long baseline for LCR and CG-5 gravimeters[J]. Journal of Geodesy and Geodynamics, 2012,32(1):56-59.
[12]	肖凡, 张宏伟 . 利用CG-5重力仪标定动态检定场[J]. 地理空间信息, 2012,10(4):126-128.
[12]	Xiao F, Zhang H W . Calibrating dynamic verification field Based on CG-5 gravimeters[J]. Geospatial Information, 2012,10(4):126-128.
[13]	刘代芹, 李杰, 朱治国 , 等. 利用观测资料对CG-5型与LCR-G型相对重力仪精度初步评定[J]. 内陆地震, 2012,26(1):45-51. doi: 10.3969/j.issn.1001-8956.2012.01.006
[13]	Liu D Q, Li J, Zhu Z G , et al. Primary evaluation of measuring accuracy of LCR-G and CG-5 relative gravimeter using observation data[J]. Inland Earthquake, 2012,26(1):45-51.
[14]	肖凡, 张宏伟, 王应建 . 影响相对重力测量精度因素的探讨[J]. 测绘信息与工程, 2012,37(2):38-40,44.
[14]	Xiao F, Zhang H W, Wang Y J . Discussion onrelative gravity measurementaccuracy factors[J]. Journalof Geomatics, 2012,37(2):38-40,44.
[15]	胡金桥, 李盛, 张帆 . CG-5重力仪在海南岛陆流动观测的零漂特征[J]. 华南地震, 2017,37(s1):53-57.
[15]	Hu J Q, Li S, Zhang F . The drift characteristics of CG-5 Gravimeter in the flow observation of Hainan island[J]. South China Journal of Seismology, 2017,37(S1):53-57.
[16]	尚立志, 张宝松, 黄宁 . LCR-G、CG-5型重力仪仪器性能试验比较[J].绿色科技, 2017(4):137-139.
[16]	Shang L Z, Zhang B S, Huang N . Comparative analysis of instrument performance test of LCR-G and CG-5 gravimeter[J].Journal of Green Science and Technology, 2017(4):137-139.
[17]	马玄龙, 肖毅, 刘磊 . CG-5重力仪静态观测残差分析[J]. 资源环境与工程, 2010,24(6):698-700. doi: 10.3969/j.issn.1671-1211.2010.06.015
[17]	Ma X L, Xiao Y, Liu L . Analysis on residua1 errors by CG-5 gravimeter’s static observation[J]. Resources Environment&Engineering, 2010,24(6):698-700.
[18]	DZ/T 0082-2006. 区域重力调查规范 0082-2006.区域重力调查规范[S]. 中华人民共和国国土资源部, 2006.
[18]	DZ/T 0082-2006. The standard for regional gravity survey 0082-2006.The standard for regional gravity survey[S]. Ministry of Land and Resources of the People’s Republic of China, 2006.
[19]	DZ/T 0004-2015. 重力调查技术规范(1∶50000)Z/T 0004-2015.重力调查技术规范(1∶50000)[S]. 中华人民共和国国土资源部, 2015.
[19]	DZ/T 0004-2015. The technical specification for gravity survey(1∶50000)Z/T 0004-2015.The technical specification for gravity survey(1∶50000)[S]. Ministry of Land and Resources of the People’s Republic of China, 2015.
[20]	DZ/T 0171-2017. 大比例尺重力勘查规范Z/T 0171-2017.大比例尺重力勘查规范[S]. 中华人民共和国国土资源部, 2017.
[20]	DZ/T 0171-2017. Large-scale gravity survey specificationZ/T 0171-2017.Large-scale gravity survey specification[S]. Ministry of Land and Resources of the People’s Republic of China, 2017.
[21]	王礼祥, 蔡书, 刘一 . Excel图表功能在数学、物理中应用的研究[J]. 西南民族大学学报:自然科学版, 2012,38(1):150-155. doi: 10.3969/j.issn.1003-2483.2012.01.32
[21]	Wang L X, Cai S, Liu Y . The application of Excel chart function in mathematics and physics[J]. Journal of Southwest University for Nationalities: Natural Science Edition, 2012,38(1):150-155.
[22]	唐世雄 . Excel统计功能的应用研究[J]. 成都信息工程学院院报, 2002,17(4):255-260. doi: 10.3969/j.issn.1671-1742.2002.04.006
[22]	Tang S X . Research of applications of Excel statistical function[J]. Journal of Chengdu University of Information Technology, 2002,17(4):255-260.

[1]	龚晶晶, 李方林, 杨刚刚, 欧智德, 张爽. 基于Excel VBA实现箱图剔除法确定化探异常下限[J]. 物探与化探, 2013, 37(5): 926-933.
[2]	张爽, 李方林, 鲍征宇. Excel下地质数据三层套合方差分析的实现[J]. 物探与化探, 2010, 34(3): 403-406.
[3]	王高成, 郭玲, 陈兴炳, 许磊, 唐磊. 基于VBA的储层评价数据处理方法[J]. 物探与化探, 2009, 33(6): 718-722.
[4]	赵豫, 张慧利, 武秀江. 多种软件联合实现等值线快速绘制的制图模式[J]. 物探与化探, 2009, 33(4): 472-476.
[5]	春乃芽. 利用Excel实现R型聚类分析[J]. 物探与化探, 2007, 31(4): 374-376.

Viewed

Full text

Abstract

Cited

Shared

Discussed