坐标邻带换算是高斯分带投影的必然结果,是实现不同带(6°带、3°带、任意带)坐标转换的桥梁,在测量实践中具有非常重要的作用。本文探讨在Excel环境中,利用Visual Basic(VB)语言编制程序,创建用户自定义函数,再调用自定义函数解决坐标邻带换算的方法。通过实例验证,该方法能适用于不同椭球参数的不同带的批量坐标转换。
The coordinate neighbouring zone conversion is the inevitable result of the Gauss projection, and is the bridge of the realization between different zone (6°zone, 3° zone, any zone) coordinate transformation. It plays an important role in the survey practice. Based on the Excel environment and with the help of Visual Basic (VB) language programming, this article discusses the foundation of user definition function, and the solution method of the coordinate neighbouring zone conversion by using this definition function. Through the example confirmation, this method can be suitable for batch coordinate transformation of the different zone and ellipsoidal parameter.