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

Quick processing of static test data of CG-5 gravimeter and calculation of the parameter DRIFT using Excel

重力仪静态试验是重力勘探工作开始之前对仪器性能检查的必要环节,由于原理简单,其数据整理常不被人们重视,没有系统的方法,但整理的计算过程却又繁琐复杂,初学者在面对大量数据和多重目标时或顾此失彼,或重复计算,往往要耗费较多的工作时间。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.