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

1、附合导线平差计算 工程名称： 道路测量项目： 导线贯通测量 测站 观测角改正数改正后角值方 位 角边 长坐 标 增 量调整后坐标增量值坐 标 测站 左v左左ad(m)xyxyxy 8k+174172332112391.80723352.5738k+174 8k+102164.2107+41642111156543212209.76823376.3588k+102 210.641-193.765 13 82.612 10 -193.75282.622 k102-195.1229+4951233727.512016.01623458.980k102-1 205.80963.195 12 195.8

2、67 10 63.207195.877 k102-11177.3226+4177323069393412016.01623458.980k102-11 235.03781.699 14 220.381 11 81.713220.392 k102-2270.1027+4270103115950512079.22323654.857k102-2 223.822-210.102 13 77.158 11 -210.08977.169 k102-21183.4111+41834115163311912097.72923679.372k102-21 226.525-217.221 13 64.253 1

3、1 -217.20864.264 k102-3174.2045+4174204915752811869.13423732.026k102-3 391.253-362.427 23 147.396 19 -362.404147.415 k102-31182.0350+41823.5415956111880.52023743.636k102-31 260.296-244.495 15 89.309 13 -244.48089.322 k102-4182.3421+41823425162302611506.73023879.441k102-4 313.165-298.683 19 94.133 15

4、 -298.66494.148 k102-41177.2408+41772412159543811636.04023832.958k102-41 359.309-337.448 21 123.418 17 -337.427123.435 5k83107.4607+4107461187404811208.06723973.5895k83 附合导线平差计算 工程名称： 道路测量项目： 导线贯通测量 测站 观测角改正数改正后角值方 位 角边 长坐 标 增 量调整后坐标增量值坐 标 测站 左v左左ad(m)xyxyxy 182.1307.373 11 181.981 9 7.384181.990 k1

5、27-1248.4949+42484953156304111215.45024155.578k127-1 197.900-181.502 12 78.877 10 -181.49078.887 k127-286.5455+486545963253911033.96024234.465k127-2 230.611103.159 14 206.252 11 103.173206.263 k127-3140.4210+41404214247.5311137.13324440.727k127-3 200.381182.870 12 81.922 10 182.88281.932 k127-4205.5

6、947+42055951507.4311320.01524522.659k127-4 119.99776.926 7 92.096 6 76.93392.102 k127-5273.5659+42735731444.4611396.94824614.761k127-5 155.928-126.275 9 91.477 8 -126.26691.485 k127-6184.5452+41845456148594211270.68124706.246k127-6 68.630-58.824 4 35.352 3 -58.82035.355 k127-7113.1617+41131621821621

7、1211.86124741.602k127-7 196.55326.447 12 194.766 9 26.459194.775 k127-8104.2801+4104285644711238.32024936.376k127-8 99.86399.174 6 11.712 5 99.18011.717 k127-9316.0757+43168.114252711208.06723973.589k127-9 93.461-74.512 6 56.417 5 -74.50656.422 k127-1072.4627+472463135383811133.56024030.011k127-10 5

8、k83107.4607+4107461187404811208.06723973.5895k83 附合导线平差计算 工程名称： 道路测量项目： 导线贯通测量 测站 观测角改正数改正后角值方 位 角边 长坐 标 增 量调整后坐标增量值坐 标 测站 左v左左ad(m)xyxyxy 113.92392.580 7 66.388 5 92.58766.393 k127-11206.0432+42064.3661431311226.14724096.404k127-11 143.78068.119 9 126.619 7 68.128126.626 k126-2186.4302+418643668261

9、911294.27624223.030k126-2 419.320154.099 25 389.978 20 154.124389.998 8k+026272.4615+42724619161123810860.42926084.9458k+026 8k+02710604.53626172.0068k+027 4128375482412839164,648.334 -1349.615 277 2708.363 225 -1,349.3382,708.588 角度闭合差改正计算：坐标增量闭合差计算：导线相对闭合差计算： 测-n*180= 11226x= -1349.615 d=(x2+y2) aab-acd= 112044-）xc-xb= -1349.339 =0.355 b=-n*180+aab-acdx= -0.276 = -82 y= 2708.363 k=d/d