坐標(biāo)經(jīng)緯度轉(zhuǎn)換

1、西安80坐標(biāo)轉(zhuǎn)經(jīng)緯度序號XY輸出緯度(B)12848670.000485326.000254444.48254444.48234567891011121314151617中央經(jīng)線輸出經(jīng)度(L)1171165113.491165113.49坐標(biāo)轉(zhuǎn)經(jīng)緯度使使 用用 說說 明明（1 1）工工具具宏宏安安全全選選項(xiàng)項(xiàng)中中把把“中中”或或“低低”打打勾勾；（2 2）運(yùn)運(yùn)行行電電子子表表格格，有有安安全全警警告告時時，要要點(diǎn)點(diǎn)啟啟用用宏宏，否否則則不不能能運(yùn)運(yùn)行行；（3 3）輸輸出出經(jīng)經(jīng)緯緯度度的的格格式式是是：DDFFMM.MM,DDFFMM.MM,例例輸輸出出是是1164913.641164913.6

2、4表表示示116116度度4949分分13.6413.64秒秒；（4 4）Y Y坐坐標(biāo)標(biāo)不不要要輸輸入入帶帶號號，有有帶帶號號的的Y Y坐坐標(biāo)標(biāo)是是8 8位位數(shù)數(shù)，如如39473456.01,3939473456.01,39是是帶帶號號，不不要要輸輸入入，輸輸入入 473456.01473456.01，又又如如20473456.01,2020473456.01,20是是帶帶號號，不不要要輸輸入入，輸輸入入473456.01473456.01。（5 5）僅僅對對3939度度帶帶測測試試，其其他他帶帶號號未未測測試試。使使 用用 說說 明明（1 1）工工具具宏宏安安全全選選項(xiàng)項(xiàng)中中把把“中中”或或

3、“低低”打打勾勾；（2 2）運(yùn)運(yùn)行行電電子子表表格格，有有安安全全警警告告時時，要要點(diǎn)點(diǎn)啟啟用用宏宏，否否則則不不能能運(yùn)運(yùn)行行；（3 3）輸輸出出經(jīng)經(jīng)緯緯度度的的格格式式是是：DDFFMM.MM,DDFFMM.MM,例例輸輸出出是是1164913.641164913.64表表示示116116度度4949分分13.6413.64秒秒；（4 4）Y Y坐坐標(biāo)標(biāo)不不要要輸輸入入帶帶號號，有有帶帶號號的的Y Y坐坐標(biāo)標(biāo)是是8 8位位數(shù)數(shù)，如如39473456.01,3939473456.01,39是是帶帶號號，不不要要輸輸入入，輸輸入入 473456.01473456.01，又又如如20473456.

4、01,2020473456.01,20是是帶帶號號，不不要要輸輸入入，輸輸入入473456.01473456.01。（5 5）僅僅對對3939度度帶帶測測試試，其其他他帶帶號號未未測測試試。39481951.022822946.31239482951.152822946.91139482951.672823945.95739481951.642823946.35439482951.122824947.03639482516.262825460.98039464867.632400000002841917.72909000000464867.63239999900139464827.055700

5、000002842380.57128000000464827.05569999700239464802.537300000002842437.64120000000464802.53729999800339463340.641400000002842421.00512000000463340.64140000200439463462.591900000002842802.63413000000463462.59189999800539463573.378100000002842866.97189000000463573.37810000000639463591.3962000000028428

6、68.07257000000463591.39620000100739463588.160300000002842870.95383000000463588.16030000200839463574.101500000002842871.71087000000463574.10149999700939463803.730700000002842884.73096000000463803.730700001001039464502.368900000002842876.81818000000464502.368900001001139463572.783300000002842902.88073

7、000000463572.783299997001239463876.139800000002842939.67567000000463876.139799997001339464606.352800000002842600.08210000000464606.352799997001439463847.598600000002842965.46286000000463847.59860000000圖形轉(zhuǎn)換結(jié)果481951.016116.8204625.513451164913.66253048.42482951.153116.830425.513471164949.44253048.4948

8、2951.665116.830425.522491164949.44253120.96481951.642116.8204525.522481164913.62253120.93482951.125116.8303825.531531164949.37253153.51482516.262116.8260525.536161164933.78253210.1800000.0000000.0000000.0000000.0000000.0000000.00116.65002125.6843931163900.07254103.82116.64960425.6885701163858.582541

9、18.85116.64935925.6890851163857.69254120.70116.63479625.6888991163805.26254120.04116.63600025.6923471163809.60254132.45116.63710225.6929301163813.57254134.55116.63728125.6929401163814.21254134.59116.63724925.6929661163814.10254134.68116.63710925.6929731163813.59254134.70116.63939625.6930961163821.83

10、254135.15116.64635725.6930421163846.88254134.95116.63709525.6932541163813.54254135.72116.64011625.6935941163824.42254136.94116.64740025.6905461163850.64254125.97116.63983125.6938261163823.39254137.77表格計算結(jié)果25.304843116.491364253048.43 1164913.6425.304849116.494946253048.49 1164949.4525.312096116.4949

11、43253120.95 1164949.4225.312093116.491361253120.92 1164913.6125.315349116.494936253153.49 1164949.3625.321017116.493377253210.17 1164933.760.0.0.0.0.0.25.410382116.390007254103.82 1163900.0725.411885116.385858254118.85 1163858.5825.412070116.385769254120.71163857.6925.412004116.380526254120.04 1163805.2625.413245116.380960254132.45 1163809.625.413455116.381357254134.55 1163813.5725.413459116.381421254134.59 1163814.2125.413468116.381410254134.68 1163814.125.413470116.381359254134.71163813.5925.413515116.382183254135.15 1163821.8325.413495