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

附合导线平差计算工程名称：道路测量项目：导线贯通测量测站观测角改正数改正后角值方位角方位角边长坐标增量调整后坐标增量值坐标测站β′左V′左β左a度D(m)△x△y△x△yXY8K+174172°33'21"172.003321.50172.56172.5612391.80723352.5738K+1748K+102164.21071640.350.0019444444164.3519444444+4"164.35293633541642110.57164°21'11"156°54'32"12209.76823376.3588K+102156.005432.07156.91156.91210.641-193.7651382.61210-193.75282.622K102-195.1229950.20.008055555695.2080555556+4"95.2090474465951232.5795°12'33"72°7.'5"12016.01623458.980K102-172.007.4.6472.1272.12205.80963.19512195.8671063.207195.877K102-11177.32261770.53333333330.0072222222177.5405555556+4"177.54154744651773229.57177°32'30"69°39'34"12016.01623458.980K102-1169.003934.2169.6669.66235.03781.69914220.3811181.713220.392K102-2270.10272700.16666666670.0075270.1741666667+4"270.17515855762701030.57270°10'31"159°50'5"12079.22323654.857K102-2159.00504.78159.83159.83223.822-210.1021377.15811-210.08977.169K102-21183.41111830.68333333330.0030555556183.6863888889+4"183.68738077981834114.57183°41'15"163°31'19"12097.72923679.372K102-21163.003119.35163.52163.52226.525-217.2211364.25311-217.20864.264K102-3174.20451740.33333333330.0125174.3458333333+4"174.34682522431742048.57174°20'49"157°52'8"11869.13423732.026K102-3157.00527.92157.87157.87391.253-362.42723147.39619-362.404147.415K102-31182.03501820.050.0138888889182.0638888889+4"182.06488077981823.53.57182°3.'54"159°56'1"11880.52023743.636K102-31159.00561.49159.93159.93260.296-244.4951589.30913-244.48089.322K102-4182.34211820.56666666670.0058333333182.5725+4"182.57349189091823424.57182°34'25"162°30'26"11506.73023879.441K102-4162.003026.06162.51162.51313.165-298.6831994.13315-298.66494.148K102-41177.24081770.40.0022222222177.4022222222+4"177.40321411321772411.57177°24'12"159°54'38"11636.04023832.958K102-41159.005437.63159.91159.91359.309-337.44821123.41817-337.427123.4355K83107.46071070.76666666670.0019444444107.7686111111+4"107.76960300211074610.57107°46'11"87°40'48"11208.06723973.5895K8387.004048.2087.6887.68182.1307.37311181.98197.384181.990K127-1248.49492480.81666666670.0136111111248.8302777778+4"248.83126966872484952.57248°49'53"156°30'41"11215.45024155.578K127-1156.003040.77156.51156.51197.900-181.5021278.87710-181.49078.887K127-286.5455860.90.015277777886.9152777778+4"86.9162696687865458.5786°54'59"63°25'39"11033.96024234.465K127-263.002539.3563.4363.43230.611103.15914206.25211103.173206.263K127-3140.42101400.70.0027777778140.7027777778+4"140.70376966871404213.57140°42'14"24°7.'53"11137.13324440.727K127-324.007.52.9224.1324.13200.381182.8701281.92210182.88281.932K127-4205.59472050.98333333330.0130555556205.9963888889+4"205.99738077982055950.57205°59'51"50°7.'43"11320.01524522.659K127-450.007.43.4950.1350.13119.99776.926792.096676.93392.102K127-5273.56592730.93333333330.0163888889273.9497222222+4"273.9507141132273572.57273°57'3"144°4.'46"11396.94824614.761K127-5144.004.46.06144.08144.08155.928-126.275991.4778-126.26691.485K127-6184.54521840.90.0144444444184.9144444444+4"184.91543633541845455.57184°54'56"148°59'42"11270.68124706.246K127-6148.005941.63148.99148.9968.630-58.824435.3523-58.82035.355K127-7113.16171130.26666666670.0047222222113.2713888889+4"113.27238077981131620.57113°16'21"82°16'2"11211.86124741.602K127-782.00162.2082.2782.27196.55326.44712194.766926.459194.775K127-8104.28011040.46666666670.0002777778104.4669444444+4"104.4679363354104284.57104°28'5"6°44'7"11238.32024936.376K127-86.00446.776.746.7499.86399.174611.712599.18011.717K127-9316.07573160.11666666670.0158333333316.1325+4"316.13349189093168.0.57316°8.'1"142°52'7"11208.06723973.589K127-9142.00527.34142.87142.8793.461-74.512656.4175-74.50656.422K127-1072.4627720.76666666670.007572.7741666667+4"72.7751585576724630.5772°46'31"35°38'38"11133.56024030.011K127-1035.003837.9135.6435.64113.92392.580766.388592.58766.393K127-11206.04322060.06666666670.0088888889206.0755555556+4"206.07654744652064.35.57206°4.'36"61°43'13"11226.14724096.404K127-1161.004313.4861.7261.72143.78068.1199126.619768.128126.626K126-2186.43021860.71666666670.0005555556186.7172222222+4"186.7182141132186435.57186°43'6"68°26'19"11294.27624223.030K126-268.002619.0568.4468.44419.320154.09925389.97820154.124389.9988K+026272.46152720.76666666670.0041666667272.7708333333+4"272.77182522432724618.57272°46'19"161°12'38"10860.42926084.9458K+026161.001237.62161.21161.218K+02710604.53626172.0068K+027∑4128°37'54"53.99999999833741284128.631666666782"4128.654480158341283916.12856986854128°39'16"4,648.334-1349.6152772708.363225-1,349.3382,708.588角度闭合差改正计算：23坐标增量闭合差计算：导线相对闭合差计算：∑β测-n*180=11.368333333311226.000000001711°22'6"∑△x=-1349.615ƒD=√(ƒx2+ƒy2)aAB-aCD=11.3455198417112043.871430133211°20'44"-）xC-xB=-1349.339=0.355ƒB=∑β-n*180+aAB-aCD起算边方位角172.555971019172.555971019ƒx=-0.276=-0.0228134916-82"止算边方位角161.2104511773161.2104511773∑△y=2708.363K=ƒD/∑Dƒβ容=±40√n=191.8332609325±192"偏角11.345519841711.3455198417-）yC-yB=2708.587=1/13077<1/2000改正数Vi=-ƒβ/n=0.0009918909+4"ƒy=-0.224测量：计算：监理：日期：年月日