附合导线平差计算表Excel自动计算表

附合导线平差计算,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,工程名称：,,,,,灵关经双石至宝盛（玉溪）公路灾后恢复重建工程（芦山境）LB1标段,,,,,,,,,,,,,,,,,测量项目：,导线贯通测量,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

测站,观测角,,,,,改正数,,,,,改正后角值,方位角,,,,,方位角,边长,坐标增量,,,,调整后坐标增量值,,坐标,,测站,,,

,β′左,,,,,V′左,,,,,β左,a,,,,,度,D(m),△x,,△y,,△x,△y,X,Y,,,,

GPS14,,,,,,,,,,,,"198°56'4""",198.00,56,3.97,198.93,198.93,,,,,,,,3353243.415,506524.142,GPS14,,,

GPS13,167.7042,167,1.166666667,0.011574074,168.1782407,"+521817""",313.1274892,313,7.,38.96,"313°7.'39""","332°3.'43""",,,,,,,,,,,,,3352267.514,506189.361,GPS13,167,42,15

,,,,,,,,,,,,,332.00,3.,42.93,332.06,332.06,1031.795,911.544,286214,-483.414,152625,1197.758,-330.789,,,,,,

1,203.3583,203,0.583333333,0.023148148,203.6064815,"+521817""",348.55573,348,33,20.63,"348°33'21""","500°37'4""",,,,,,,,,,,,,3353465.272,505858.572,1,203,21,30

,,,,,,,,,,,,,500.00,37,3.55,500.62,140.62,205.809,-159.076,57090,130.584,30444,-101.986,161.028,,,,135,19,15

2,155.5542,155,0.916666667,0.011574074,155.9282407,"+521817""",300.8774892,300,52,38.96,"300°52'39""","621°29'43""",,,,,,,,,,,,,3353465.272,505858.572,2,155,33,15

,,,,,,,,,,,,,621.00,29,42.52,621.50,261.50,235.037,-34.760,65198,-232.452,34767,30.438,-197.685,,,,163,0,45

3,235.7958,235,1.316666667,0.016203704,236.3328704,"+521817""",381.2821189,381,16,55.63,"381°16'56""","822°46'38""",,,,,,,,,,,,,3353363.286,506019.601,3,235,47,45

,,,,,,,,,,,,,822.00,46,38.14,822.78,462.78,223.822,-49.501,62087,218.280,33108,12.586,251.388,,,,202,35,0

4,163.5597,163,0.916666667,0.027006173,163.9436728,"+521817""",308.8929213,308,53,34.52,"308°53'35""","951°40'13""",,,,,,,,,,,,,3353495.710,505660.887,4,163,33,35

,,,,,,,,,,,,,951.00,40,12.66,951.67,591.67,226.525,-140.488,62837,-177.698,33508,-77.651,-144.190,,,,194,30,30

5,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""","916°37'10""",,,,,,,,,,,,,3353375.872,506270.988,5,,,

,,,,,,,,,,,,,916.00,37,9.96,916.62,556.62,391.253,-374.909,108531,-111.904,57875,-266.378,-54.029,,,,,,

6,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""","881°34'7""",,,,,,,,,,,,,3353418.059,505516.697,6,,,

,,,,,,,,,,,,,881.00,34,7.25,881.57,521.57,260.296,-246.944,72205,82.297,38504,-174.739,120.801,,,,,,

7,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""","846°31'5""",,,,,,,,,,,,,3353109.495,506216.960,7,,,

,,,,,,,,,,,,,846.00,31,4.54,846.52,486.52,313.165,-186.356,86870,251.682,46324,-99.486,298.006,,,,,,

8,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""","811°28'2""",,,,,,,,,,,,,3353243.320,505637.498,8,,,

,,,,,,,,,,,,,811.00,28,1.84,811.47,451.47,359.309,-9.200,99670,359.191,53150,90.470,412.341,,,,,,

9,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""","776°24'59""",,,,,,,,,,,,,3353010.008,506514.965,9,,,

,,,,,,,,,,,,,776.00,24,59.13,776.42,416.42,182.130,100.746,50522,151.729,26941,151.268,178.670,,,,,,

10,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""","741°21'56""",,,,,,,,,,,,,3353161.276,506693.635,10,,,

,,,,,,,,,,,,,741.00,21,56.43,741.37,381.37,197.900,184.299,54896,72.099,29274,239.195,101.373,,,,,,

11,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""","706°18'54""",,,,,,,,,,,,,3353400.471,506795.008,11,,,

,,,,,,,,,,,,,706.00,18,53.72,706.31,346.31,230.611,224.064,63970,-54.559,34112,288.034,-20.447,,,,,,

12,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""","671°15'51""",,,,,,,,,,,,,3353688.505,506774.561,12,,,

,,,,,,,,,,,,,671.00,15,51.02,671.26,311.26,200.381,132.158,55585,-150.622,29641,187.743,-120.981,,,,,,

13,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""","636°12'48""",,,,,,,,,,,,,3353876.248,506653.580,13,,,

,,,,,,,,,,,,,636.00,12,48.31,636.21,276.21,119.997,12.988,33286,-119.292,17750,46.274,-101.542,,,,,,

14,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""","601°9.'46""",,,,,,,,,,,,,3353922.521,506552.038,14,,,

,,,,,,,,,,,,,601.00,9.,45.61,601.16,241.16,155.928,-75.208,43254,-136.592,23065,-31.954,-113.527,,,,,,

15,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""","566°6.'43""",,,,,,,,,,,,,3353890.568,506438.511,15,,,

,,,,,,,,,,,,,566.00,6.,42.90,566.11,206.11,68.630,-61.625,19038,-30.206,10152,-42.587,-20.054,,,,,,

16,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""","531°3.'40""",,,,,,,,,,,,,3353847.980,506418.457,16,,,

,,,,,,,,,,,,,531.00,3.,40.20,531.06,171.06,196.553,-194.166,54523,30.540,29075,-139.643,59.615,,,,,,

17,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""","496°0.'37""",,,,,,,,,,,,,3353708.337,506478.073,17,,,

,,,,,,,,,,,,,496.00,0.,37.49,496.01,136.01,99.863,-71.848,27701,69.358,14772,-44.147,84.130,,,,,,

18,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""","460°57'35""",,,,,,,,,,,,,3353010.008,506514.965,18,,,

,,,,,,,,,,,,,460.00,57,34.79,460.96,100.96,93.461,-17.769,25926,91.756,13825,8.157,105.581,,,,,,

19,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""","425°54'32""",,,,,,,,,,,,,3353018.166,506620.547,19,,,

,,,,,,,,,,,,,425.00,54,32.08,425.91,65.91,113.923,46.502,31602,104.000,16852,78.104,120.852,,,,,,

20,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""","390°51'29""",,,,,,,,,,,,,3353096.270,506741.399,20,,,

,,,,,,,,,,,,,390.00,51,29.37,390.86,30.86,143.780,123.426,39884,73.747,21268,163.310,95.015,,,,,,

21,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""","355°48'27""",,,,,,,,,,,,,3353259.580,506836.413,21,,,

,,,,,,,,,,,,,355.00,48,26.67,355.81,355.81,419.320,418.198,"116,317",-30.656,62027,534.515,31.371,,,,,,

22,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""","320°45'24""",,,,,,,,,,,,,3349864.943,504732.312,22,,,

,,,,,,,,,,,,,320.00,45,23.96,320.76,320.76,420.320,325.524,"116,594",-265.901,62175,442.118,-203.726,,,,,,

23,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""",,,,,,,,,,,,,,3350307.061,504528.586,23,,,

,,,,,,,,,,,,,,,,,,421.320,421.320,"116,872",0.000,62323,538.192,62.323,,,,,,

24,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""",,,,,,,,,,,,,,3349864.943,504732.312,24,,,

,,,,,,,,,,,,,,,,,,422.320,422.320,"117,149",0.000,62470,539.469,62.470,,,,,,

25,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""",,,,,,,,,,,,,,3350404.412,504794.782,25,,,

,,,,,,,,,,,,,,,,,,423.320,423.320,"117,427",0.000,62618,540.747,62.618,,,,,,

26,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""",,,,,,,,,,,,,,3349864.943,504732.312,26,,,

,,,,,,,,,,,,,,,,,,424.320,424.320,"117,704",0.000,62766,542.024,62.766,,,,,,

27,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""",,,,,,,,,,,,,,3350406.967,504795.078,27,,,

,,,,,,,,,,,,,,,,,,425.320,425.320,"117,981",0.000,62914,543.301,62.914,,,,,,

28,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""",,,,,,,,,,,,,,3350950.268,504857.992,28,,,

,,,,,,,,,,,,,,,,,,426.320,426.320,"118,259",0.000,63062,544.579,63.062,,,,,,

29,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""",,,,,,,,,,,,,,3351494.847,504921.054,29,,,

,,,,,,,,,,,,,,,,,,427.320,427.320,"118,536",0.000,63210,545.856,63.210,,,,,,

30,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""",,,,,,,,,,,,,,3352040.703,504984.264,30,,,

,,,,,,,,,,,,,,,,,,428.320,428.320,"118,814",0.000,63358,547.134,63.358,,,,,,

31,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""",,,,,,,,,,,,,,3352587.837,505047.622,31,,,

,,,,,,,,,,,,,,,,,,429.320,429.320,"119,091",0.000,63506,548.411,63.506,,,,,,

32,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""",,,,,,,,,,,,,,3353136.248,505111.128,32,,,

,,,,,,,,,,,,,,,,,,430.320,430.320,"119,368",0.000,63654,549.688,63.654,,,,,,

33,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""",,,,,,,,,,,,,,3353685.936,505174.782,33,,,

,,,,,,,,,,,,,,,,,,431.320,431.320,"119,646",0.000,63802,550.966,63.802,,,,,,

34,0.0000,0,0,0,0,"+521817""",144.9492485,144,56,57.29,"144°56'57""",,,,,,,,,,,,,,,,34,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

GPS11,,,,,,,,,,,,,,,,,,,,,,,,,3349847.827,504633.758,GP