基于EXCEL和VB的邻带换算方法  

The neighboring zone conversionv based on EXCEL and VB

作　　者：曾绍炳[1] 

机构地区：[1]东华理工学院测量系,江西抚州344000

出　　处：《测绘科学》2008年第2期155-157,共3页Science of Surveying and Mapping

基　　金：国家自然科学基金项目(40574008);江西省教育厅科技项目(GJJ08300)

摘　　要：坐标邻带换算是高斯分带投影的必然结果,是实现不同带(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.

关 键 词：EXCEL VISUAL Basic 高斯投影 坐标 邻带换算 

分 类 号：P22[天文地球—大地测量学与测量工程]