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

工程名称：道路

观测角β′左8K+1748K+1021.2107+4\"1°21'11\"改正数V′左改正后角值β左方 位 角a172°33'21\"156°'32\"210.1K102-195.1229+4\"95°12'33\"72°7.'5\"205.809K102-11177.3226+4\"177°32'30\"69°39'34\"235.037K102-2270.1027+4\"270°10'31\"159°50'5\"223.822K102-21183.4111+4\"183°41'15\"163°31'19\"226.525K102-3174.2045+4\"174°20'49\"157°52'8\"391.253K102-31182.0350+4\"182°3.'\"159°56'1\"260.296K102-4182.3421+4\"182°34'25\"162°30'26\"313.165K102-41177.2408+4\"177°24'12\"159°'38\"359.309-337.448-298.68321123.418-244.4951994.13317-337.427123.435-362.42715.30915-298.694.14811636.04023832.958K102-41-217.22123147.39613-244.480.32211506.73023879.441K102-4-210.10213.25319-362.404147.41511880.52023743.636K102-3181.6991377.15811-217.208.211869.13423732.026K102-363.19514220.38111-210.077.16912097.72923679.372K102-21-193.76512195.8671181.713220.39212079.223236.857K102-2边 长D(m)△x测量项目：导线贯通测量

坐 标 增 量△y调整后坐标增量值△x△yX12391.80712209.768-193.7521063.207195.87712016.01623458.980K102-1182.62212016.01623458.980K102-1坐 标Y23352.57323376.3588K+1748K+102测站测站1382.61210附合导线平差计算

工程名称：道路

观测角β′左5K83107.4607改正数V′左+4\"改正后角值β左107°46'11\"方 位 角a87°40'48\"182.130K127-1248.4949+4\"248°49'53\"156°30'41\"197.900K127-286.55+4\"86°'59\"63°25'39\"230.611K127-3140.4210+4\"140°42'14\"24°7.'53\"200.381K127-4205.5947+4\"205°59'51\"50°7.'43\"119.997K127-5273.5659+4\"273°57'3\"144°4.'46\"155.928K127-6184.52+4\"184°'56\"148°59'42\"68.630K127-7113.1617+4\"113°16'21\"82°16'2\"196.553K127-8104.2801+4\"104°28'5\"6°44'7\"99.863K127-9316.0757+4\"316°8.'1\"142°52'7\"93.461-74.51299.174656.41726.447611.7125-74.50656.422-58.82412194.766599.18011.71711208.06723973.5K127-9-126.2735.352926.459194.77511238.32024936.376K127-876.926991.4773-58.82035.35511211.86124741.602K127-7182.870792.0968-126.26691.48511270.68124706.246K127-6103.1591281.922676.93392.10211396.94824614.761K127-5-181.50214206.25210182.88281.93211320.01524522.659K127-47.3731278.87711103.173206.26311137.13324440.727K127-3边 长D(m)359.309测量项目：导线贯通测量

坐 标 增 量△x-337.44821△y123.41817调整后坐标增量值△x-337.427△y123.435X11208.0677.38410-181.49078.88711033.96024234.465K127-2181.99011215.45024155.578K127-1坐 标Y23973.55K83测站测站11181.9819附合导线平差计算

工程名称：道路

观测角β′左K127-1072.4627改正数V′左+4\"改正后角值β左72°46'31\"方 位 角a35°38'38\"113.923K127-11206.0432+4\"206°4.'36\"61°43'13\"143.780K126-2186.4302+4\"186°43'6\"68°26'19\"419.3208K+0268K+027∑4128°37'\"82\"4128°39'16\"4,8.334-1349.6152772708.363225-1,349.338坐标增量闭合差计算：∑△x=-1349.615-）xC-xB=-1349.339ƒx=-0.276∑△y=2708.363-）yC-yB=2708.587ƒy=-0.224计 算：

监 理：

日期： 年 月 日

K=ƒD/∑D =1/13077<1/20002,708.588导线相对闭合差计算：ƒD=√(ƒx2+ƒy2) =0.355272.4615+4\"272°46'19\"161°12'38\"1.09968.119253.972.5809126.619201.1243.99810860.42910604.53626084.94526172.0068K+0268K+027边 长D(m)93.461△x-74.512测量项目：导线贯通测量

坐 标 增 量6△y56.4175调整后坐标增量值△x-74.506△y56.422X11133.56092.587768.128126.62611294.27624223.030K126-266.39311226.14724096.404K127-11坐 标Y24030.011K127-10测站测站766.3885角度闭合差改正计算：∑β测-n*180=11°22'6\"aAB-aCD=11°20'44\"ƒB=∑β-n*180+aAB-aCD=-82\"ƒβ容=± 40√n =±192\"改正数Vi=-ƒβ/n=+4\"测 量：