Excel VBA在GPS坐标转换计算中的应用

Application of Excel VBA For GPS Coordinate Transformation Calculation

为了使GPS的观测成果在实际中得到更好的应用,必须把GPS观测得到的WGS-84坐标转换成实际需要的国家大地坐标或地方独立坐标。本文利用Excel软件的宏程序VBA进行编程,实现不同坐标系之间坐标的相互转换。并且例举了坐标转换的算例,实验表明:所编程序可以快捷、准确、可靠地解决不同坐标间的转换问题,能够满足实际工作的需要。

In order to make better use of GPS in engineering ,WGS-84 coordinates ob-tained from GPS observations must be converted to the actual needs of the national geodetic coordinates or local independent coordinates .ExcellVBA macro software for programming is realized conversion between different coordinate system ,and examples are given .The pro-gram can be fast ,accurate and reliable to solution for conversion between different coordi-nate systems .