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

doi:10.11720/wtyht.2019.1209

Abstract
Figure/Table
References
Related Citation (15)

Download: PDF (951 KB) HTML (0 KB)
Export: BibTeX | EndNote (RIS)

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

Received: 25 May 2018 Published: 20 February 2019

P631.1

	Service

	E-mail this article
	Add to my bookshelf
	Add to citation manager
	E-mail Alert
	RSS
	Articles by authors
	Peng GAO
	Zeng-Tao LI
	Feng-Dan YU
	Xu ZHANG
	Sheng-Rong LIU

Cite this article:

Peng GAO,Zeng-Tao LI,Feng-Dan YU, et al. Quick processing of static test data of CG-5 gravimeter and calculation of the parameter DRIFT using Excel[J]. Geophysical and Geochemical Exploration, 2019, 43(1): 209-214.

URL:

https://www.wutanyuhuatan.com/EN/10.11720/wtyht.2019.1209 OR https://www.wutanyuhuatan.com/EN/Y2019/V43/I1/209

[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.
[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.
[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.
[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.
[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.
[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.
[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.
[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.
[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.
[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.
[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.
[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.
[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.
[22]	Tang S X . Research of applications of Excel statistical function[J]. Journal of Chengdu University of Information Technology, 2002,17(4):255-260.