施工坐标与大地坐标转换EXCEL表格

x

y

x-x0x0

y0

°

′

″

68852.3329368.2168852.3329368.2168852.3329368.2168852.3329368.2168852.3329368.2168852.3329368.2168852.3329368.2168852.3329368.2168852.3329368.2168852.3329368.2168852.3329368.2168852.3329368.2168852.3329368.2168852.3329368.2168852.3329368.2168852.3329368.2168852.33

29368.21

备注：角度输入格式： 度：分：秒

角度（已知

30°00′00″

大地坐标转化为施工坐标

待转点（大地坐标）施工坐标原点（已知）

角度弧度

N E

N

E

0.5236-48.16-16.1250.7800480.44459260.5236-49.81-12.9450.7800480.44459260.5236-48.16-16.1251.369672-3.085470.5236-52.68 5.2150.7800480.44459260.5236-52.23 2.3948.487739-21.235160.5236-51.88-1.0748.938039-18.415210.5236-51.37-4.0649.668401-15.015290.5236-50.07-8.9050.108721-12.015340.5236-49.81-12.9450.369253-7.0153640.5236-48.16-16.1251.369672-3.085470.5236-57.9410.0550.7800480.44459260.5236-57.50 5.5651.997076-27.465540.5236-56.850.3852.967544-23.065640.5236-56.17-3.7353.94809-17.935740.5236-55.29-8.3554.568529-13.815810.5236-53.54-17.2555.169026-9.1458750.5236

-51.15

-25.08

56.249985-0.1459956.400857

8.0439941

（已知）

施工

施工坐标（结果）施工坐标（待转换）

角度（已知）x0

y0

角度弧度

x

y

68852.3329368.21 3.979468818.6829330.1768852.3329368.21 3.979468818.6829330.1768852.3329368.21 3.979468815.6729332.1068852.3329368.21 3.979468818.6829330.1768852.3329368.21 3.979468804.1129346.3868852.3329368.21 3.979468805.9029344.1668852.3329368.21 3.979468807.9429341.3468852.3329368.21 3.979468809.8729339.0168852.3329368.21 3.979468813.4229335.4768852.3329368.21 3.979468815.6729332.1068852.3329368.21 3.979468818.6829330.1768852.3329368.21 3.979468797.1329347.9468852.3329368.21 3.979468799.7529344.2868852.3329368.21 3.979468802.9029340.1268852.3329368.21 3.979468805.5529336.9068852.3329368.21 3.979468808.6229333.3368852.3329368.21 3.979468814.5929326.5068852.33

29368.21

3.9794

68820.57

29320.91

600.0028

0.16810.08

大地坐标（结果） 施工坐标转化为大地坐标

施工坐标原点(已知）