附合导线平差计算表Excel自动计算表[共1页]

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