坐标经纬度转换

西安80坐标转经纬度中央经线序号XY输出纬度(B)输出经度(L)11712848670.000485326.00025°44′44.48″116°51′13.49″234567891011121314151617使用说明（1）工具－宏－安全选项中把“中”或“低”打勾；（2）运行电子表格，有安全警告时，要点启用宏，否则不能运行；（3）输出经纬度的格式是：DD°FF′MM.MM″,例输出是116°49′13.64″表示116度49分13.64秒；（4）Y坐标不要输入带号，有带号的Y坐标是8位数，如39473456.01,39是带号，不要输入，输入473456.01，又如20473456.01,20是带号，不要输入，输入473456.01。（5）仅对39度带测试，其他带号未测试。图形转换结果表格计算结果39481951.015862822946.31235481951.015859999116.8204625.51345116°49′13.66″25°30′48.42″25.304843116.49136425°30′48.43″116°49′13.64″39482951.152792822946.91097482951.152790003116.830425.51347116°49′49.44″25°30′48.49″25.304849116.49494625°30′48.49″116°49′49.45″39482951.665482823945.9571482951.665480003116.830425.52249116°49′49.44″25°31′20.96″25.312096116.49494325°31′20.95″116°49′49.42″39481951.642472823946.35363481951.642470002116.8204525.52248116°49′13.62″25°31′20.93″25.312093116.49136125°31′20.92″116°49′13.61″39482951.124542824947.03625482951.124540001116.8303825.53153116°49′49.37″25°31′53.51″25.315349116.49493625°31′53.49″116°49′49.36″39482516.262442825460.97982482516.262440003116.8260525.53616116°49′33.78″25°32′10.18″25.321017116.49337725°32′10.17″116°49′33.76″0°00′00.00″0°00′00.00″0°′.″0°′.″0°00′00.00″0°00′00.00″0°′.″0°′.″0°00′00.00″0°00′00.00″0°′.″0°′.″039464867.632400000002841917.72909000000464867.63239999900116.65002125.684393116°39′00.07″25°41′03.82″25.410382116.39000725°41′03.82″116°39′00.07″139464827.055700000002842380.57128000000464827.05569999700116.64960425.688570116°38′58.58″25°41′18.85″25.411885116.38585825°41′18.85″116°38′58.58″239464802.537300000002842437.64120000000464802.53729999800116.64935925.689085116°38′57.69″25°41′20.70″25.412070116.38576925°41′20.7″116°38′57.69″339463340.641400000002842421.00512000000463340.64140000200116.63479625.688899116°38′05.26″25°41′20.04″25.412004116.38052625°41′20.04″116°38′05.26″439463462.591900000002842802.63413000000463462.59189999800116.63600025.692347116°38′09.60″25°41′32.45″25.413245116.38096025°41′32.45″116°38′09.6″539463573.378100000002842866.97189000000463573.37810000000116.63710225.692930116°38′13.57″25°41′34.55″25.413455116.38135725°41′34.55″116°38′13.57″639463591.396200000002842868.07257000000463591.39620000100116.63728125.692940116°38′14.21″25°41′34.59″25.413459116.38142125°41′34.59″116°38′14.21″739463588.160300000002842870.95383000000463588.16030000200116.63724925.692966116°38′14.10″25°41′34.68″25.413468116.38141025°41′34.68″116°38′14.1″839463574.101500000002842871.71087000000463574.10149999700116.63710925.692973116°38′13.59″25°41′34.70″25.413470116.38135925°41′34.7″116°38′13.59″939463803.730700000002842884.73096000000463803.73070000100116.63939625.693096116°38′21.83″25°41′35.15″25.413515116.38218325°41′35.15″116°38′21.83″1039464502.368900000002842876.81818000000464502.36890000100116.64635725.693042116°38′46.88″25°41′34.95″25.413495116.38468825°41′34.95″116°38′46.88″1139463572.783300000002842902.88073000000463572.78329999700116.63709525.693254116°38′13.54″25°41′35.72″25.413572116.38135425°41′35.72″116°38′13.54″1239463876.139800000002842939.67567000000463876.13979999700116.64011625.693594116°38′24.42″25°41′36.94″25.413694116.38244225°41′36.94″116°38′24.42″1339464606.352800000002842600.08210000000464606.35279999700116.64740025.690546116°38′50.64″25°41′25.97″25.412597116.38506425°41′25.97″116°38′50.64″1439463847.598600000002842965.46286000000463847.59860000000116.63983125.693826116°38′23.39″25°41′37.77″25.413777116.38233925°41′37.77″116°38′23.39″