利用Excel实现快速整理CG-5型重力仪静态试验数据和计算漂移常量DRIFT
|
摘要
重力仪静态试验是重力勘探工作开始之前对仪器性能检查的必要环节,由于原理简单,其数据整理常不被人们重视,没有系统的方法,但整理的计算过程却又繁琐复杂,初学者在面对大量数据和多重目标时或顾此失彼,或重复计算,往往要耗费较多的工作时间。Excel电子表格具有强大的数学计算、图形显示功能,且应用广泛,易于操作,可系统整理CG-5型重力仪静态试验的原始观测记录,快速获取静态试验数据表、零点位移曲线及其拟合直线图等直观要素,同时计算得到静态零点位移曲线与直线偏差、平均零点位移率等结果参数,Excel的散点图趋势线功能也改进了静态零点位移校正参数漂移常量DRIFT的计算方法与准确度。这种静态试验数据的整理方法具有快速、准确和直观的优点。
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.
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.
引文
[1]曹金国,王来鹏,翟广卿,等.CG-5重力仪及应用[M].北京:解放军出版社,2007.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.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.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.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-373.
[6]沈博,袁尚武,马玄龙,等.CG-5重力仪的漂移与寿命[J].物探与化探,2015,39(2):383-386.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.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.Wang J,Sun S A,Xing L L,et al. Drift characteristics of CG-5gravimeter[J]. Journal of Geodesy and Geodynamics,2016,36(6):556-560.
[9]于红娟,郭金运,李九龙,等.基于主成分分析的相对重力观测零漂和固体潮提取[J].大地测量与地球动力学,2015,35(5):906-909.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.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.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.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.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.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.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.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.Ma X L,Xiao Y,Liu L. Analysis on residua1 errors by CG-5gravimeter's static observation[J]. Resources Environment&Engineering,2010,24(6):698-700.
[18] DZ/T 0082-2006.区域重力调查规范[S].中华人民共和国国土资源部,2006.DZ/T 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)[S].中华人民共和国国土资源部,2015.DZ/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.大比例尺重力勘查规范[S].中华人民共和国国土资源部,2017.DZ/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.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.Tang S X. Research of applications of Excel statistical function[J].Journal of Chengdu University of Information Technology,2002,17(4):255-260.
[2] Scintrex L. CG-5 scintrex autograv system operation manual V5.0[Z].2009.
[3]耿启立.重力仪器国外代表产品及国内研发最新进展[J].地质装备,2016,17(1):27-30.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.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.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-373.
[6]沈博,袁尚武,马玄龙,等.CG-5重力仪的漂移与寿命[J].物探与化探,2015,39(2):383-386.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.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.Wang J,Sun S A,Xing L L,et al. Drift characteristics of CG-5gravimeter[J]. Journal of Geodesy and Geodynamics,2016,36(6):556-560.
[9]于红娟,郭金运,李九龙,等.基于主成分分析的相对重力观测零漂和固体潮提取[J].大地测量与地球动力学,2015,35(5):906-909.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.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.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.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.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.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.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.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.Ma X L,Xiao Y,Liu L. Analysis on residua1 errors by CG-5gravimeter's static observation[J]. Resources Environment&Engineering,2010,24(6):698-700.
[18] DZ/T 0082-2006.区域重力调查规范[S].中华人民共和国国土资源部,2006.DZ/T 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)[S].中华人民共和国国土资源部,2015.DZ/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.大比例尺重力勘查规范[S].中华人民共和国国土资源部,2017.DZ/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.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.Tang S X. Research of applications of Excel statistical function[J].Journal of Chengdu University of Information Technology,2002,17(4):255-260.
© 2004-2018 中国地质图书馆版权所有 京ICP备05064691号 京公网安备11010802017129号 地址：北京市海淀区学院路29号 邮编：100083 电话：办公室：(+86 10)66554848；文献借阅、咨询服务、科技查新：66554700 |