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

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

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

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

工程名称：,,,,,,道路,,,,,,,,,,,,,,测量项目：,,导线贯通测量,,,,,

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

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

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

8K+174,,,,,,,,,,,,"172°33'21""",172.00,33,21.50,172.56,172.56,,,,,,,,12391.807,23352.573,8K+174

8K+102,164.2107,164,0.35,0.001944444,164.3519444,"+4""",164.3529363,164,21,10.57,"164°21'11""","156°54'32""",,,,,,,,,,,,,12209.768,23376.358,8K+102

,,,,,,,,,,,,,156.00,54,32.07,156.91,156.91,210.641,-193.765,13,82.612,10,-193.752,82.622,,,

K102-1,95.1229,95,0.2,0.008055556,95.20805556,"+4""",95.20904745,95,12,32.57,"95°12'33""","72°7.'5""",,,,,,,,,,,,,12016.016,23458.980,K102-1

,,,,,,,,,,,,,72.00,7.,4.64,72.12,72.12,205.809,63.195,12,195.867,10,63.207,195.877,,,

K102-11,177.3226,177,0.533333333,0.007222222,177.5405556,"+4""",177.5415474,177,32,29.57,"177°32'30""","69°39'34""",,,,,,,,,,,,,12016.016,23458.980,K102-11

,,,,,,,,,,,,,69.00,39,34.21,69.66,69.66,235.037,81.699,14,220.381,11,81.713,220.392,,,

K102-2,270.1027,270,0.166666667,0.0075,270.1741667,"+4""",270.1751586,270,10,30.57,"270°10'31""","159°50'5""",,,,,,,,,,,,,12079.223,23654.857,K102-2

,,,,,,,,,,,,,159.00,50,4.78,159.83,159.83,223.822,-210.102,13,77.158,11,-210.089,77.169,,,

K102-21,183.4111,183,0.683333333,0.003055556,183.6863889,"+4""",183.6873808,183,41,14.57,"183°41'15""","163°31'19""",,,,,,,,,,,,,12097.729,23679.372,K102-21

,,,,,,,,,,,,,163.00,31,19.35,163.52,163.52,226.525,-217.221,13,64.253,11,-217.208,64.264,,,

K102-3,174.2045,174,0.333333333,0.0125,174.3458333,"+4""",174.3468252,174,20,48.57,"174°20'49""","157°52'8""",,,,,,,,,,,,,11869.134,23732.026,K102-3

,,,,,,,,,,,,,157.00,52,7.92,157.87,157.87,391.253,-362.427,23,147.396,19,-362.404,147.415,,,

K102-31,182.0350,182,0.05,0.013888889,182.0638889,"+4""",182.0648808,182,3.,53.57,"182°3.'54""","159°56'1""",,,,,,,,,,,,,11880.520,23743.636,K102-31

,,,,,,,,,,,,,159.00,56,1.49,159.93,159.93,260.296,-244.495,15,89.309,13,-244.480,89.322,,,

K102-4,182.3421,182,0.566666667,0.005833333,182.5725,"+4""",182.5734919,182,34,24.57,"182°34'25""","162°30'26""",,,,,,,,,,,,,11506.730,23879.441,K102-4

,,,,,,,,,,,,,162.00,30,26.06,162.51,162.51,313.165,-298.683,19,94.133,15,-298.664,94.148,,,

K102-41,177.2408,177,0.4,0.002222222,177.4022222,"+4""",177.4032141,177,24,11.57,"177°24'12""","159°54'38""",,,,,,,,,,,,,11636.040,23832.958,K102-41

,,,,,,,,,,,,,159.00,54,37.63,159.91,159.91,359.309,-337.448,21,123.418,17,-337.427,123.435,,,

5K83,107.4607,107,0.766666667,0.001944444,107.7686111,"+4""",107.769603,107,46,10.57,"107°46'11""","87°40'48""",,,,,,,,,,,,,11208.067,23973.589,5K83

,,,,,,,,,,,,,87.00,40,48.20,87.68,87.68,182.130,7.373,11,181.981,9,7.384,181.990,,,

K127-1,248.4949,248,0.816666667,0.013611111,248.8302778,"+4""",248.8312697,248,49,52.57,"248°49'53""","156°30'41""",,,,,,,,,,,,,11215.450,24155.578,K127-1

,,,,,,,,,,,,,156.00,30,40.77,156.51,156.51,197.900,-181.502,12,78.877,10,-181.490,78.887,,,

K127-2,86.5455,86,0.9,0.015277778,86.91527778,"+4""",86.91626967,86,54,58.57,"86°54'59""","63°25'39""",,,,,,,,,,,,,11033.960,24234.465,K127-2

,,,,,,,,,,,,,63.00,25,39.35,63.43,63.43,230.611,103.159,14,206.252,11,103.173,206.263,,,

K127-3,140.4210,140,0.7,0.002777778,140.7027778,"+4""",140.7037697,140,42,13.57,"140°42'14""","24°7.'53""",,,,,,,,,,,,,11137.133,24440.727,K127-3

,,,,,,,,,,,,,24.00,7.,52.92,24.13,24.13,200.381,182.870,12,81.922,10,182.882,81.932,,,

K127-4,205.5947,205,0.983333333,0.013055556,205.9963889,"+4""",205.9973808,205,59,50.57,"205°59'51""","50°7.'43""",,,,,,,,,,,,,11320.015,24522.659,K127-4

,,,,,,,,,,,,,50.00,7.,43.49,50.13,50.13,119.997,76.926,7,92.096,6,76.933,92.102,,,

K127-5,273.5659,273,0.933333333,0.016388889,273.9497222,"+4""",273.9507141,273,57,2.57,"273°57'3""","144°4.'46""",,,,,,,,,,,,,11396.948,24614.761,K127-5

,,,,,,,,,,,,,144.00,4.,46.06,144.08,144.08,155.928,-126.275,9,91.477,8,-126.266,91.485,,,

K127-6,184.5452,184,0.9,0.014444444,184.9144444,"+4""",184.9154363,184,54,55.57,"184°54'56""","148°59'42""",,,,,,,,,,,,,11270.681,24706.246,K127-6

,,,,,,,,,,,,,148.00,59,41.63,148.99,148.99,68.630,-58.824,4,35.352,3,-58.820,35.355,,,

K127-7,113.1617,113,0.266666667,0.004722222,113.2713889,"+4""",113.2723808,113,16,20.57,"113°16'21""","82°16'2""",,,,,,,,,,,,,11211.861,24741.602,K127-7

,,,,,,,,,,,,,82.00,16,2.20,82.27,82.27,196.553,26.447,12,194.766,9,26.459,194.775,,,

K127-8,104.2801,104,0.466666667,0.000277778,104.4669444,"+4""",104.4679363,104,28,4.57,"104°28'5""","6°44'7""",,,,,,,,,,,,,11238.320,24936.376,K127-8

,,,,,,,,,,,,,6.00,44,6.77,6.74,6.74,99.863,99.174,6,11.712,5,99.180,11.717,,,

K127-9,316.0757,316,0.116666667,0.015833333,316.1325,"+4""",316.1334919,316,8.,0.57,"316°8.'1""","142°52'7""",,,,,,,,,,,,,11208.067,23973.589,K127-9

,,,,,,,,,,,,,142.00,52,7.34,142.87,142.87,93.461,-74.512,6,56.417,5,-74.506,56.422,,,

K127-10,72.4627,72,0.766666667,0.0075,72.77416667,"+4""",72.77515856,72,46,30.57,"72°46'31""","35°38'38""",,,,,,,,,,,,,11133.560,24030.011,K127-10

,,,,,,,,,,,,,35.00,38,37.91,35.64,35.64,113.923,92.580,7,66.388,5,92.587,66.393,,,

K127-11,206.0432,206,0.066666667,0.008888889,206.0755556,"+4""",206.0765474,206,4.,35.57,"206°4.'36""","61°43'13""",,,,,,,,,,,,,11226.147,24096.404,K127-11

,,,,,,,,,,,,,61.00,43,13.48,61.72,61.72,143.780,68.119,9,126.619,7,68.128,126.626,,,

K126-2,186.4302,186,0.716666667,0.000555556,186.7172222,"+4""",186.7182141,186,43,5.57,"186°43'6""","68°26'19""",,,,,,,,,,,,,11294.276,24223.030,K126-2

,,,,,,,,,,,,,68.00,26,19.05,68.44,68.44,419.320,154.099,25,389.978,20,154.124,389.998,,,

8K+026,272.4615,272,0.766666667,0.004166667,272.7708333,"+4""",272.7718252,272,46,18.57,"272°46'19""","161°12'38""",,,,,,,,,,,,,10860.429,26084.945,8K+026

,,,,,,,,,,,,,161.00,12,37.62,161.21,161.21,,,,,,,,,,

8K+027,,,,,,,,,,,,,,,,,,,,,,,,,10604.536,26172.006,8K+027

∑,"4128°37'54""",54,37,4128,4128.631667,"82""",4128.65448,4128,39,16.12856987,"4128°39'16""",,,,,,,"4,648.334",-1349.615,277,2708.363,225,"-1,349.338","2,708.588",,,