用EXCEL批量计算坐标转换

1、大地坐标转化为施工坐标待转点（大地坐标）施工坐标原点（已知）xyx-x0 x0y068818.68529330.173-33.64568852.3329368.2168815.66729332.097-36.66368852.3329368.2168818.68529330.173-33.64568852.3329368.2168804.10629346.382-48.22468852.3329368.2168805.90129344.161-46.42968852.3329368.2168807.93929341.343-44.39168852.3329368.2168809.8742933

2、9.009-42.45668852.3329368.2168813.41529335.470-38.91568852.3329368.2168815.66729332.097-36.66368852.3329368.2168818.68529330.173-33.64568852.3329368.2168797.12829347.943-55.20268852.3329368.2168799.74829344.278-52.58268852.3329368.2168802.90529340.117-49.42568852.3329368.2168805.55229336.899-46.7786

3、8852.3329368.2168808.62029333.328-43.71068852.3329368.2168814.58629326.503-37.74468852.3329368.2168820.57229320.911-31.75868852.3329368.21备注：角度需输入的是弧度，度分秒应转化为弧度x68818.68568815.66768818.68568804.10668805.90168807.93968809.87468813.41568815.66768818.68568797.12868799.74868802.90568805.55268808.6206881

4、4.58668820.572 施工坐标转化为大地坐标角度（已知）施工坐标（结果）施工坐标（待转换）施工坐标原点(已知）角度弧度NENEx03.979450.780.4450.78005 0.44459368852.333.979451.37-3.0950.78005 0.44459368852.333.979450.780.4451.36967 -3.0854768852.333.979448.49-21.2450.78005 0.44459368852.333.979448.94-18.4248.48774 -21.235268852.333.979449.67-15.0248.93804

5、-18.415268852.333.979450.11-12.0249.6684 -15.015368852.333.979450.37-7.0250.10872 -12.015368852.333.979451.37-3.0950.36925 -7.0153668852.333.979450.780.4451.36967 -3.0854768852.333.979452.00-27.4750.78005 0.44459368852.333.979452.97-23.0751.99708 -27.465568852.333.979453.95-17.9452.96754 -23.0656688

6、52.333.979454.57-13.8253.94809 -17.935768852.333.979455.17-9.1554.56853 -13.815868852.333.979456.25-0.1555.16903 -9.1458768852.333.979456.408.0456.24998 -0.1459968852.3356.40086 8.04399468852.33yx-x0y-y0 x0y0角度弧度29330.173-33.645-38.03768852.33 29368.213.979422.5119549229332.097-36.663-36.11368852.33

7、 29368.213.979424.5312924129330.173-33.645-38.03768852.33 29368.213.979422.5119549229346.382-48.224-21.82868852.33 29368.213.979432.2663256629344.161-46.429-24.04968852.33 29368.213.979431.0656511129341.343-44.391-26.86768852.33 29368.213.979429.7019547829339.009-42.456-29.20168852.33 29368.213.9794

8、28.4073038329335.470-38.915-32.74068852.33 29368.213.979426.0376269529332.097-36.663-36.11368852.33 29368.213.979424.5312924129330.173-33.645-38.03768852.33 29368.213.979422.5119549229347.943-55.202-20.26768852.33 29368.213.979436.9355199429344.278-52.582-23.93268852.33 29368.213.979435.182061372934

9、0.117-49.425-28.09368852.33 29368.213.979433.0701114729336.899-46.778-31.31168852.33 29368.213.979431.2991684429333.328-43.710-34.88268852.33 29368.213.979429.245801329326.503-37.744-41.70768852.33 29368.213.979425.2543933629320.911-31.758-47.29968852.33 29368.213.979421.24934303大地坐标转化为施工坐标NEx0y0角度弧

10、度50.78004763 0.44459258468852.3329368.213.9794-37.7386049150.78004763 0.44459258468852.3329368.213.9794-37.7386049151.36967173 -3.08547022368852.3329368.213.9794-38.1768004650.78004763 0.44459258468852.3329368.213.9794-37.7386049148.487739 -21.2351634468852.3329368.213.9794-36.0350119948.9380393 -18

11、.4152113768852.3329368.213.9794-36.3696651849.66840135 -15.0152891368852.3329368.213.9794-36.9124540650.10872081-12.01533668852.3329368.213.9794-37.2396897150.36925324 -7.01536371468852.3329368.213.9794-37.4333116351.36967173 -3.08547022368852.3329368.213.9794-38.1768004650.78004763 0.44459258468852

12、.3329368.213.9794-37.7386049151.99707557 -27.4655371768852.3329368.213.9794-38.6430730852.96754411 -23.0656404968852.3329368.213.9794-39.3643037753.94809038 -17.9357448868852.3329368.213.9794-40.0930240154.5685291 -13.8158109268852.3329368.213.9794-40.554120355.1690264 -9.14587483968852.3329368.213.

13、9794-41.0003965756.24998477 -0.14598989668852.3329368.213.9794-41.8037408556.4008569 8.04399408468852.3329368.213.9794-41.91586567-33.97662338 -0.330411346 68818.68379-33.97662338 -0.330411346 68818.68379-34.37113731 2.293053023 68815.66581-33.97662338 -0.330411346 68818.68379-32.44285352 15.7815023

14、9 68804.10564-32.74414672 13.68577658 68805.90008-33.23282757 11.15902979 68807.93814-33.527442668.92953117 68809.87303-33.70176334 5.213662686 68813.41457-34.37113731 2.293053023 68815.66581-33.97662338 -0.330411346 68818.68379-34.79092943 20.41177794 68797.12729-35.44026407 17.14187233 68799.74786

15、-36.09634167 13.32944771 68802.90421-36.51147347 10.26760419 68805.55092-36.91326259 6.797011292 68808.61973-37.63652531 0.108496452 68814.58498-37.73747294 -5.978117958 68820.57065角度（已知）大地坐标（结果）y0角度弧度xy29368.213.979468818.6829330.1729368.213.979468818.6829330.1729368.213.979468815.6729332.1029368.2

16、13.979468818.6829330.1729368.213.979468804.1129346.3829368.213.979468805.9029344.1629368.213.979468807.9429341.3429368.213.979468809.8729339.0129368.213.979468813.4229335.4729368.213.979468815.6729332.1029368.213.979468818.6829330.1729368.213.979468797.1329347.9429368.213.979468799.7529344.2829368.2

17、13.979468802.9029340.1229368.213.979468805.5529336.9029368.213.979468808.6229333.3329368.213.979468814.5929326.5029368.213.979468820.5729320.9128.2680850.7800384925.0045380625.45017315 -0.44563508326.8384451.3697350627.2474619324.16304631 3.08441561928.2680850.7800384925.0045380625.45017315 -0.44563

18、508316.2218548.4881749535.838938514.60477051 21.2341679917.8727748.9384173434.505322116.09111541 18.4142066919.9667549.668709632.9906337117.97636426 15.0142694521.7016650.1089674731.5526355819.5383283 12.0143072824.3317750.3693972528.9205818221.90625217 7.01432964726.8384451.3697350627.2474619324.16

19、304631 3.08441561928.2680850.7800384925.0045380625.45017315 -0.44563508315.0621251.9976394241.0251183113.56064863 27.4644696817.7859652.9680176339.0775121816.01295911 23.0645530820.8783553.9484585936.731721618.79708427 17.9346373323.2696454.5688127334.7646950820.95000444 13.8146906425.9234155.1692141532.483973723.33923147 99955956.249987