闭合导线平差计算表-电子表格自动计算

闭合导线平差计算表,,,,,,,,,,,,,,,,,,,,,,,,,,

工程名称：,,隧道,,,,,,,,,,,,,,,,,,测量项目：,,导线测量,,,,

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

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

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

A,,,,,,,,,,,,236.4428,236,0.733333333,0.007777778,236.7411111,131.322,-72.020,9860,-109.812,-35963,-62.160,-145.775,3534882.218,6418699.987,A

B,205.3648,205,0.6,0.013333333,205.6133333,"82742""",228.5972222,228,35,50.00,"228°35'50""",,,,,,,,,,,,,3534820.058,6418554.212,B

,,,,,,,,,,,,"285°20'18""",18,20,285,285.3383333,247.203,65.390,18561,-238.398,-67698,83.951,-306.096,,,

1,290.4054,290,0.666666667,0.015,290.6816667,"82742""",313.6655556,313,39,56.00,"313°39'56""",,,,,,,,,,,,,3534904.009,6418248.117,1

,,,,,,,,,,,,"419°0'14""",14,0,419,419.0038889,223.058,114.870,16748,191.206,-61085,131.618,130.121,,,

2,202.4708,202,0.783333333,0.002222222,202.7855556,"82742""",225.7694444,225,46,10.00,"225°46'10""",,,,,,,,,,,,,3535035.627,6418378.237,2

,,,,,,,,,,,,"464°46'24""",24,46,464,464.7733333,188.983,-48.190,14190,182.736,-51754,-34.000,130.982,,,

3,167.2156,167,0.35,0.015555556,167.3655556,"82742""",190.3494444,190,20,58.00,"190°20'58""",,,,,,,,,,,,,3535001.627,6418509.219,3

,,,,,,,,,,,,"475°7'22""",22,7,475,475.1227778,85.074,-36.119,6388,77.026,-23298,-29.731,53.728,,,

4,175.3125,175,0.516666667,0.006944444,175.5236111,"82742""",198.5075,198,30,27.00,"198°30'27""",,,,,,,,,,,,,3534971.896,6418562.947,4

,,,,,,,,,,,,"493°37'49""",49,37,493,493.6302778,247.202,-170.570,18561,178.927,-67697,-152.009,111.230,,,

C,214.0933,214,0.15,0.009166667,214.1591667,"82742""",237.1430556,237,8,35.00,"237°8'35""",,,,,,,,,,,,,3534819.887,6418674.177,C

,,,,,,,,,,,,60.3801,60,0.633333333,0.000277778,60.63361111,95.163,46.667,7145,82.935,-26061,53.812,56.874,,,

D,,,,,,,,,,,,,,,,,,,,,,,,3534873.700,6418731.050,D

,,,,,,,,,,,,,,,,,113.429,,,,,,,,,

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

∑,"1256°7'44""",44,7,1256,1256.128889,"661936""",1394.032222,1394,1,56.00,"1394°1'56""",,,,,,1331.434,-99.971,,364.619,,-8.518,31.063,,,

角度闭合差改正计算：n=,,,,,,10,,,,,,坐标增量闭合差计算：,,,,,,,,,,,导线相对闭合差计算：,,,

∑β理=180(n-2)=,,,8,1440,,1080°,,,,,,∑△x理=0∑△y理=0,,,,,,,,,,,ƒD=√(ƒx2+ƒy2),,,

ƒβ=∑β测-∑β理=,,-183.8711111,,,,"-661936""",,,,,,ƒx=-99.971,,,,,ƒy=+364.619,,,,,,=378.076,,,

ƒ容=±40√n=,,113.137085,,,,"±113""",,,,,,,,,,,,,,,,,K=ƒD/∑D,,,

改正数Vi=ƒβ/n=,,22.98388889,,,,"82742""",,,,,,,,,,,,,,,,,=1/4,<1/2000