经纬度转高斯坐标Excell版.xls

经纬度转高斯坐标Excell版.xls

《经纬度转高斯坐标Excell版.xls》由会员分享，可在线阅读，更多相关《经纬度转高斯坐标Excell版.xls（90页珍藏版）》请在冰豆网上搜索。

坐标系统abeea2/bf北京54637824563568630.08181330.08263996990.00335233西安80637814063567550.08181920.08263995970.003352813WGS84637813763567520.08181920.08263995940.0033528112637814063568630.08181330.08263996990.00335233编号北纬B（度分秒）东经L（度分秒）纵坐标XN1274641.111453213074170.496227465311453423074541.003327463211453303073892.1434274716.611453263075264.3325274632.51145246.23073898.8966243701033602724317.604西安80西安80a*（1-e2）6335552.7176335442.2756335439.3276335552.717横坐标YE（YE,XN）38587642.09238587642.092,3074170.49638588214.42238588214.422,3074541.00338587890.55138587890.551,3073892.14338587771.07838587771.078,3075264.33238586691.13338586691.133,3073898.89635358222.87435358222.874,2724317.604坐标系统编号纵坐标XN横坐标YE北纬B（度分秒）东经L（度分秒）12724362.441635358222.874024370.00103360.0023236001.216137363883.594029140.00109360.0033209487.427636439099.01332900.001072230.0043204838.486536445167.2544285730.001072615.0053236001.216137363883.594029140.00109360.0063236001.216137363883.594029140.00109360.0073236001.216137363883.594029140.00109360.0083236001.216137363883.594029140.00109360.0093236001.216137363883.594029140.00109360.00103236001.216137363883.594029140.00109360.00北京54北京54北京54北纬B东经L24370.00103360.0029140.00109360.002900.001072230.00285730.001072615.0029140.00109360.0029140.00109360.0029140.00109360.0029140.00109360.0029140.00109360.0029140.00109360.00说明：

1、本程序采用高斯克吕格投影公式编制；2、本程序适用于贵州省范围内万分之一地形图坐标经纬度相互转换；3、本程序计算数据最大为1000行,如要计算更多,可把隐藏的计算过程所在列取消隐藏,然后拖出更多的公式即可；4、对于不在本区域的坐标经纬度相互转换，需要对某些参数作适当调整方可使用；5、本程序可任意使用、复制和分发，但必须保证程序的完整性。

图例：

公式计算中间参数区域输入输出错误提示区域参数设置区域标题行区域计算结果输出区域计算数据输入区域3、本程序计算数据最大为1000行,如要计算更多,可把隐藏的计算过程所在列取消隐藏,然后拖出更多的公式即可；4、对于不在本区域的坐标经纬度相互转换，需要对某些参数作适当调整方可使用；