投影转换Excell工具(经纬度转高斯坐标)

1、坐标系统abeea2/bf北京5463782456356863 0.0818133 0.08263996990.00335233西安8063781406356755 0.0818192 0.08263995970.003352813WGS8463781376356752 0.0818192 0.08263995940.003352811263781406356863 0.0818133 0.08263996990.00335233编号北纬B(度分秒)东经L(度分秒)纵坐标XN1274641.111453213074170.496227465311453423074541.00332746321

2、1453303073892.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,307389207838587771.078

3、,3075264.33238586691133,3073898.89635358222.87435358222.874,2724317.604坐标系统编号纵坐标XN横坐标YE北纬B(度分秒)东经L(度分秒)12724362.441635358222.874024370.00103360.0023236001.216137363883.594029140.00109360.0033209487.427636439099.01332900.001072230.0043204838.486536445167.25442857 30.001072615.0053236001.

4、216137363883.594029140.00109360.0063236001.216137363883.594029140.00109360.0073236001.216137363883.594029140.00109360.0083236001.216137363883.594029140.00109360.0093236001.216137363883.594029140.00109360.00103236001.216137363883.594029140.00109360.00113856100375772883449 47.121115041.521238560023757

5、74443449 43.901115047.63133855910375773953449 40.931115045.67143856010375772283449 44.221115039.13153856226375772763449 51.211115041.09163856286375773153449 53.151115042.64173856203375774413449 50.421115047.57183856144375774043449 48.521115046.10193856178375773373449 49.641115043.4720385608037577495

6、3449 46.411115049.66213856008375774503449 44.091115047.86223856108375772903449 47.381115041.60北京54北京54北京54北纬B东经L24370.00103360.0029140.00109360.002900.001072230.00285730.001072615.0029140.00109360.0029140.00109360.0029140.00109360.0029140.00109360.0029140.00109360.0029140.00109360.00344947.121115041

7、.52344943.901115047.63344940.931115045.67344944.221115039.13344951.211115041.09344953.151115042.64344950.421115047.57344948.521115046.10344949.641115043.47344946.411115049.66344944.091115047.86344947.381115041.60说明：1、本程序采用高斯克吕格投影公式编制；2、本程序适用于贵州省范围内万分之一地形图坐标经纬度相互转换；3、本程序计算数据最大为1000行,如要计算更多,可把隐藏的计算过程所在列取消隐藏,然后拖出更多的公式即可；4、对于不在本区域的坐标经纬度相互转换，需要对某些参数作适当调整方可使用；5、本程序可任意使用、复制和分发，但必须保证程序的完整性。图例：公式计算中间参数区域输入输出错误提示区域参数设置区域标题行区域计算结果输出区域计算数据输入区域使用过程中发现有什么bug，请与联系。