闭合导线计算(工程测量EXCEL表格计算)

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

,闭合导线坐标计算表（左角）,,,,,,,,,,,,,,,,,,,,,

,点名,观测值β,,,vi,改正后角值,,,坐标方位角,,,边长,坐标增量及改正数,,,,,,改正后坐标增量,,坐标,

,,°,′,″,,°,′,″,°,′,″,（m）,Δx,vx,,Δy,vy,,Δx,Δy,x,y

,公2,,,,,,,,,,,,,,,,,,,,34236.691,43047.468

,公1,,,,,,,,33,0,30,,,,,,,,,,34281.172,43076.364

,H2,,,,,90,41,12,303,41,42,38.420,21.314,1,0,-31.966,-2,-2,21.314,-31.968,34302.486,43044.396

,H3,85,18,58,0,85,18,58,209,0,40,62.142,-54.345,1,1,-30.138,-3,-3,-54.344,-30.141,34248.142,43014.255

,H4,152,38,12,0,152,38,12,181,38,52,41.458,-41.441,1,0,-1.193,-2,-2,-41.441,-1.195,34206.701,43013.06

,H5,139,48,32,0,139,48,32,141,27,24,44.720,-34.978,1,1,27.865,-2,-2,-34.977,27.863,34171.724,43040.923

,H6,64,4,21,0,64,4,21,25,31,45,43.130,38.919,1,1,18.587,-2,-2,38.92,18.585,34210.644,43059.508

,H7,260,5,25,0,260,5,25,105,37,10,31.060,-8.363,0,0,29.912,-1,-1,-8.363,29.911,34202.281,43089.419

,H8,119,34,35,0,119,34,35,45,11,45,54.749,38.58,1,1,38.845,-3,-3,38.581,38.842,34240.862,43128.261

,公１,82,37,4,0,82,37,4,307,48,49,65.715,40.289,1,1,-51.916,-3,-3,40.29,-51.919,34281.152,43076.342

,Ｈ２,175,52,53,0,175,52,53,303,41,42,,,,,,,,,,,

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

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

,∑,1080,0,0,0,1080,0,0,,,,381.394,-0.025,7,5,-0.004,-18,-15,,,,

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

,导线点数=,,,8,,,,,,,,,,,,坐标闭合差f=,,,0.025,,,

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

,闭合差fβ=Σ测-Σ理=,,,,,0,,,,,,,,,,导线全长容许相对闭合差=,,,,1/4000,,

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

,闭合差容许误差f容=,,,,,113,,,,,,,,,,导线全长相对闭合差=1/,,,,15200,,

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

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

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

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

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

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