Excel在不同椭球地理坐标到大地坐标转换中的应用

Application of Excel in Transformation Between Different Ellipsoidal Geographic Coordinates and Geodetic Coordinates

文章给出了高斯—克吕格投影正算及参数间相互关系转换公式,利用其转换公式,对中国现有3种地理坐标系(1954北京坐标系、1980西安坐标系和2000国家大地坐标系)坐标在Excel单元格中编制相应的语句进行换算,并给出具体的换算公式和与之对应的Excel语句及已编制好的换算表格。实践证明,这种方式表格能实现地理坐标系到大地坐标系坐标的自动转换,大地坐标3°和6°的互换带,使烦琐换算变得程序化、自动化。

The formulas of Gauss-Kruger projection directly-calculation and the transformation relationships of all theparameters are presented in this paper. The transformation formulas are used to convert the coordinates between threekinds of geographic coordinates in China （1954 Beijing coordinate system, 1980 Xi＇an coordinate system and 2000 na-tional geodetic coordinate system） through the preparation of the corresponding statement in Excel cell address. The spe-cific transformation formulas and corresponding Excel statements, and transfommtion table are given. All the facts provesthat the method can achieve the automatic transformation of coordinates from the geographic coordinates system to the geo-detic coordinates system, and realize the exchange between 3° belt and 6° belt, and making the cumbersome transforma-tion process become automatic.