用EXCEL批量计算坐标转换

1、xyx-x0x0y0 -33.64568852.3329368.21-36.66368852.3329368.21-33.64568852.3329368.21-48.22468852.3329368.21-46.42968852.3329368.21-44.39168852.3329368.21-42.45668852.3329368.21 -38.91568852.3329368.21-36.66368852.3329368.21-33.64568852.3329368.21-55.20268852.3329368.21-52.58268852.3329368.21-49.42568852

2、.3329368.21-46.77868852.3329368.21-43.71068852.3329368.21-37.74468852.3329368.21-31.75868852.3329368.21备注:角度需输入的是弧度,度分秒应转化为弧度大地坐标转化为施工坐标待转点(大地坐标施工坐标原点(已知50.7800476350.7800476351.36967173 50.7800476348.48773948.938039349.6684013550.1087208150.3692532451.3696717350.7800476351.9970755752.9675441153.948

3、0903854.568529155.169026456.2499847756.4008569 -33.97662338 -33.97662338 -34.37113731 -33.97662338 -32.44285352 -32.74414672 -33.23282757 -33.52744266 -33.70176334 -34.37113731 -33.97662338 -34.79092943 -35.44026407 -36.09634167 -36.51147347 -36.91326259 -37.63652531 -37.73747294角度(已知角度弧度N E N E x03

4、.979450.780.4450.780050.44459368852.333.979451.37-3.0950.780050.44459368852.333.979450.780.4451.36967-3.0854768852.333.979448.49-21.2450.780050.44459368852.333.979448.94-18.4248.48774-21.235268852.333.979449.67-15.0248.93804-18.415268852.333.979450.11-12.0249.6684-15.015368852.333.979450.37-7.0250.1

5、0872-12.015368852.333.979451.37-3.0950.36925-7.0153668852.333.979450.780.4451.36967-3.0854768852.333.979452.00-27.4750.780050.44459368852.333.979452.97-23.0751.99708-27.465568852.333.979453.95-17.9452.96754-23.065668852.333.979454.57-13.8253.94809-17.935768852.333.979455.17-9.1554.56853-13.815868852

6、.333.979456.25-0.1555.16903-9.1458768852.333.979456.408.0456.24998-0.1459968852.3356.400868.0439*.33 x-x0y-y0x0y0角度弧度-33.645-38.03768852.3329368.21 3.979422.51195492-36.663-36.11368852.3329368.21 3.979424.53129241-33.645-38.03768852.3329368.21 3.979422.51195492-48.224-21.82868852.3329368.21 3.979432

7、.26632566-46.429-24.04968852.3329368.21 3.979431.06565111-44.391-26.86768852.3329368.21 3.979429.70195478-42.456-29.20168852.3329368.21 3.979428.40730383-38.915-32.74068852.3329368.21 3.979426.03762695-36.663-36.11368852.3329368.21 3.979424.53129241-33.645-38.03768852.3329368.21 3.979422.51195492-55

8、.202-20.26768852.3329368.21 3.979436.93551994-52.582-23.93268852.3329368.21 3.979435.18206137-49.425-28.09368852.3329368.21 3.979433.07011147-46.778-31.31168852.3329368.21 3.979431.29916844-43.710-34.88268852.3329368.21 3.979429.2458013-37.744-41.70768852.3329368.21 3.979425.25439336-31.758-47.29968

9、852.3329368.21 3.979421.24934303施工坐标原点(已施工坐标转化为大地坐施工坐标(结果施工坐标(待转换N E x0y0角度弧度50.780047630.44459258468852.3329368.21 3.9794-37.7386049150.780047630.44459258468852.3329368.21 3.9794-37.7386049151.36967173-3.0854702268852.3329368.21 3.9794-38.17680046 50.780047630.44459258468852.3329368.21 3.9794-37.73

10、86049148.487739-21.235163468852.3329368.21 3.9794-36.0350119948.9380393-18.415211468852.3329368.21 3.9794-36.3696651849.66840135-15.015289168852.3329368.21 3.9794-36.9124540650.10872081-12.01533668852.3329368.21 3.9794-37.2396897150.36925324-7.0153637168852.3329368.21 3.9794-37.4333116351.36967173-3

11、.0854702268852.3329368.21 3.9794-38.1768004650.780047630.44459258468852.3329368.21 3.9794-37.7386049151.99707557-27.465537268852.3329368.21 3.9794-38.6430730852.96754411-23.065640568852.3329368.21 3.9794-39.3643037753.94809038-17.935744968852.3329368.21 3.9794-40.0930240154.5685291-13.815810968852.3

12、329368.21 3.9794-40.554120355.1690264-9.1458748468852.3329368.21 3.9794-41.0003965756.24998477-0.145989968852.3329368.21 3.9794-41.80374085 56.40085698.04399408468852.3329368.21 3.9794-41.91586567 -33.97662338-0.3304113568818.6838-33.97662338-0.3304113568818.6838-34.37113731 2.29305302368815.6658-33

13、.97662338-0.3304113568818.6838-32.4428535215.7815023968804.1056-32.7441467213.6857765868805.9001-33.2328275711.1590297968807.9381-33.527442668.9295311768809.873-33.70176334 5.21366268668813.4146-34.37113731 2.29305302368815.6658-33.97662338-0.3304113568818.6838-34.7909294320.4117779468797.1273-35.44

14、02640717.1418723368799.7479-36.0963416713.3294477168802.9042-36.5114734710.2676041968805.5509-36.91326259 6.79701129268808.6197-37.636525310.10849645268814.585-37.73747294-5.9781179668820.5706角度(已知y0角度弧度xy29368.21 3.979468818.6829330.1729368.21 3.979468818.6829330.1729368.21 3.979468815.6729332.1029

15、368.21 3.979468818.6829330.1729368.21 3.979468804.1129346.3829368.21 3.979468805.9029344.1629368.21 3.979468807.9429341.3429368.21 3.979468809.8729339.0129368.21 3.979468813.4229335.4729368.21 3.979468815.6729332.1029368.21 3.979468818.6829330.1729368.21 3.979468797.1329347.9429368.21 3.979468799.75

16、29344.2829368.21 3.979468802.9029340.1229368.21 3.979468805.5529336.9029368.21 3.979468808.6229333.3329368.21 3.979468814.5929326.5029368.213.979468820.5729320.9128.2680850.7800384925.0045380625.45017315-0.4456350826.8384451.3697350627.2474619324.16304631 3.08441561928.2680850.7800384925.0045380625.

17、45017315-0.4456350816.2218548.4881749535.838938514.6047705121.2341679917.8727748.9384173434.505322116.0911154118.4142066919.9667549.668709632.9906337117.9763642615.0142694521.7016650.1089674731.5526355819.538328312.0143072824.3317750.3693972528.9205818221.906252177.01432964726.8384451.3697350627.247

18、4619324.16304631 3.08441561928.2680850.7800384925.0045380625.45017315-0.4456350815.0621251.9976394241.025*.5606486327.4644696817.7859652.9680176339.0775121816.0129591123.0645530820.8783553.9484585936.731721618.7970842717.9346373323.2696454.5688127334.7646950820.9500044413.8146906425.9234155.1692141532.483973723.3392314799955956.2499877628.0506265327.9057914301513556.4006917523.6021264431.6