Excel中地学矢量数据处理方法探讨

Discussion of geo vector data processing method in Excel

地学矢量要素监测仪器均采用地理坐标系,但Excel等数据处理软件的坐标系为数学坐标系,二者存在较大的差别,直接使用Excel的函数处理地学矢量数据,会产生错误的结果。通过分析地理和数学坐标系之间的关系,结合对实测数据的计算,探讨Excel中利用矢量的分量获取地理坐标角度,以及通过矢量的大小和方向获得地理意义上的各方向分量的方法。将这种方法应用到实际数据处理中,能得到正确的结果。

The geographic vector coordinate system is used in many geological vector monitoring instruments, but the coordinate system of some data processing software such as Excel is mathematical coordinate system. And the difference between them is obvious. If geological vector data are directly handled by using Excel’s functions, the results will be error. By analyzing the relationship between geographic coordinates system and mathematical coordinate system, and combined with the calculation of the measured data, the article discusses the method on how to obtain geographic coordinates by using the components of the vector Excel, and how to obtain the component of each direction by using the size and direction of vector. The method can be applied to the actual data processing to get correct results.