附合导线平差自动计算表 修改版

附合导线平差 附合导线平差计算 名称： 道路 测量项目： 导线贯通测量 测站 观测角 改正数 改正后角值 方位角 方位角 边长 坐标增量 调整后坐标增量值 坐标 测站 β′左 V′左 β左 a 度 D(m) △x △y △x △y X Y GPS1 88°16'6" 88.00 16 5.62 88.268 88.268 88.27 996459.323 334173.426 1 GPS2 52.0300 52 0.05 0 52.05 -1" 52.0497725301 52 2. 59.18 52°2.'59" 320°19'5" 207.396 996467.821 334454.497 2 320.00 19 4.80 320.318 320.318 320.32 269.473 207.386 10 -172.066 -9 207.396 -172.075 GPS3 284.0601 284 0.1 0.0001388889 284.1001388889 -1" 284.099911419 284 5. 59.68 284°5.'60" 64°25'4" 996675.217 334282.422 3 64.00 25 4.48 424.418 64.418 64.42 445.427 192.337 16 401.761 -15 192.353 401.746 GPS4 133.2803 133 0.4666666667 0.0006944444 133.4673611111 -1" 133.4671336412 133 28 1.68 133°28'2" 17°53'6" 996867.571 334684.168 4 17.00 53 6.16 377.885 17.885 17.89 389.135 370.330 14 119.507 -13 370.344 119.494 GPS5 218.0449 218 0.0666666667 0.0136111111 218.0802777778 -1" 218.0800503079 218 4. 48.18 218°4.'48" 55°57'54" 997237.914 334803.662 5 55.00 57 54.34 415.965 55.965 55.97 416.830 233.299 15 345.426 -14 233.314 345.412 GPS6 141.5749 141 0.95 0.0136111111 141.9636111111 -1" 141.9633836412 141 57 48.18 141°57'48" 17°55'43" 997471.228 335149.073 6 17.00 55 42.52 377.928 17.928 17.93 407.167 387.396 14 125.338 -14 387.410 125.324 GPS7 222.2004 222 0.3333333333 0.0009722222 222.3343055556 -1" 222.3340780857 222 20 2.68 222°20'3" 60°15'45" 997858.638 335274.397 7 60.00 15 45.20 420.263 60.263 60.26 178.203 88.393 6 154.735 -6 88.399 154.729 GPS8 133.4732 133 0.7833333333 0.0088888889 133.7922222222 -1" 133.7919947524 133 47 31.18 133°47'31" 14°3.'16" 997947.037 335429.126 8 14.00 3. 16.38 374.055 14.055 14.05 410.457 398.170 15 99.678 -14 398.185 99.664 GPS9 193.1252 193 0.2 0.0144444444 193.2144444444 -1" 193.2142169746 193 12 51.18 193°12'51" 27°16'8" 998345.222 335528.790 9 27.00 16 7.56 387.269 27.269 27.27 386.378 343.439 14 177.025 -13 343.453 177.012 GPS10 141.1346 141 0.2166666667 0.0126388889 141.2293055556 -1" 141.2290780857 141 13 44.68 141°13'45" 348°29'52" 998688.675 335705.802 10 348.00 29 52.25 348.498 348.498 348.50 200.006 195.989 7 -39.882 -7 195.996 -39.889 GPS11 231.1836 231 0.3 0.0098611111 231.3098611111 -1" 231.3096336412 231 18 34.68 231°18'35" 39°48'27" 998884.671 335665.913 11 39.00 48 26.93 399.807 39.807 39.81 375.991 288.836 13 240.713 -13 288.849 240.700 GPS12 157.0208 157 0.0333333333 0.0020833333 157.0354166667 -1" 157.0351891968 157 2. 6.68 157°2.'7" 16°50'34" 999173.520 335906.613 12 16.00 50 33.61 376.843 16.843 16.84 334.476 320.128 12 96.913 -11 320.140 96.902 GPS13 216.2921 216 0.4833333333 0.0056944444 216.4890277778 -1" 216.4888003079 216 29 19.68 216°29'20" 53°19'53" 999493.661 336003.515 13 53.00 19 53.29 413.331 53.331 53.33 511.081 305.210 18 409.940 -18 305.228 409.922 GPS14 118.2128 118 0.35 0.0077777778 118.3577777778 -1" 118.3575503079 118 21 27.18 118°21'27" 351°41'20" 999798.889 336413.437 14 351.00 41 20.47 351.689 351.689 351.69 269.811 266.977 10 -39.000 -9 266.987 -39.009 GPS15 300.3739 300 0.6166666667 0.0108333333 300.6275 -1" 300.6272725301 300 37 38.18 300°37'38" 112°18'59" 1000065.876 336374.428 15 112.00 18 58.65 472.316 112.316 112.32 219.259 -83.257 8 202.837 -8 -83.249 202.829 GPS16 81.5907 81 0.9833333333 0.0018055556 81.9851388889 -1" 81.984911419 81 59 5.68 81°59'6" 14°18'4" 999982.627 336577.257 16 14.00 18 4.33 374.301 14.301 14.30 131.462 127.388 5 32.474 -5 127.393 32.469 GPS17 245.3833 245 0.6333333333 0.0091666667 245.6425 -1" 245.6422725301 245 38 32.18 245°38'32" 79°56'37" 1000110.020 336609.725 17 79.00 56 36.51 439.943 79.943 79.94 158.986 27.762 6 156.543 -5 27.768 156.538 GPS18 130.2457 130 0.4 0.0158333333 130.4158333333 -1" 130.4156058635 130 24 56.18 130°24'56" 30°21'33" 1000137.788 336766.264 18 30.00 21 32.69 390.359 30.359 30.36 322.374 278.168 11 162.934 -11 278.179 162.923 GPS19 234.3715 234 0.6166666667 0.0041666667 234.6208333333 -1" 234.6206058635 234 37 14.18 234°37'14" 84°58'47" 1000415.968 336929.186 19 84.00 58 46.88 444.980 84.980 84.98 242.041 21.181 9 241.112 -8 21.190 241.104 GPS20 159.2438 159 0.4 0.0105555556 159.4105555556 -1" 159.4103280857 159 24 37.18 159°24'37" 64°23'24" 1000437.157 337170.291 20 64.00 23 24.06 424.390 64.390 64.39 412.681 178.378 15 372.138 -14 178.393 372.124 GPS21 105.2126 105 0.35 0.0072222222 105.3572222222 -1" 105.3569947524 105 21 25.18 105°21'25" 349°44'49" 1000615.551 337542.415 21 349.00 44 49.24 349.747 349.747 349.75 219.463 215.958 8 -39.063 -8 215.966 -39.071 GPS22 250.2553 250 0.4166666667 0.0145833333 250.43125 -1" 250.4310225301 250 25 51.68 250°25'52" 60°10'41" 1000831.517 337503.343 22 60.00 10 40.92 420.178 60.178 60.18 103.147 51.296 4 89.488 -4 51.300 89.484 GPS23 164.0246 164 0.0333333333 0.0126388889 164.0459722222 -1" 164.0457447524 164 2. 44.68 164°2.'45" 44°13'26" 1000882.817 337592.827 23 44.00 13 25.60 404.224 44.224 44.22 309.760 221.981 11 216.046 -11 221.992 216.035 GPS24 132.3117 132 0.5166666667 0.0047222222 132.5213888889 -1" 132.521161419 132 31 16.18 132°31'16" 356°44'42" 1001104.809 337808.862 24 356.00 44 41.78 356.745 356.745 356.74 144.002 143.770 5 -8.177 -5 143.775 -8.182 GPS25 192.2029 192 0.3333333333 0.0080555556 192.3413888889 -1" 192.341161419 192 20 28.18 192°20'28" 9°5.'10" 1001248.583 337800.680 25 9.00 5. 9.96 369.086 9.086 9.09 165.164 163.092 6 26.082 -6 163.098 26.076 GPS26 247.5555 247 0.9166666667 0.0152777778 247.9319444444 -1" 247.9317169746 247 55 54.18 247°55'54" 77°1.'4" 1001411.681 337826.757 26 77.00 1. 4.14 437.018 77.018 77.02 101.439 22.788 4 98.846 -3 22.792 98.843 GPS27 74.4755 74 0.7833333333 0.0151388889 74.7984722222 -1" 74.7982447524 74 47 53.68 74°47'54" 331°48'58" 1001434.473 337925.600 27 331.00 48 57.82 331.816 331.816 331.82 149.565 131.832 5 -70.640 -5 131.837 -70.645 GPS28 259.0556 259 0.0833333333 0.0155555556 259.0988888889 -1" 259.098661419 259 5. 55.18 259°5.'55" 50°54'53" 1001566.306 337854.954 28 50.00 54 53.01 410.915 50.915 50.91 0.000 0.000 GPS29 1001670.223 337982.891 29 4822°39'9" 9.4999999995 39 4822 4822.6526388889 -22" 4822.6464972026 4822 38 47.3899294014 4822°38'47" 7,273.778 5098.228 261 3400.707 -249 5,305.885 3,400.458 角度闭合差改正计算： 27 坐标增量闭合差计算： 导线相对闭合差计算： ∑β测-n*180= 37.3473611111 37 20 50.5000000005 37°20'51" ∑△x= 5098.228 ƒD=√(ƒx2+ƒy2) aAB-aCD= 37.3535027974 37 21 12.610070598 37°21'13" -）xC-xB= 5098.485 =0.359 ƒB=∑β-n*180+aAB-aCD 起算边方位角 88.2682266946 88.2682266946 ƒx= -0.257 = 0.0061416863 22" 止算边方位角 50.9147238972 50.9147238972 ∑△y= 3400.707 K=ƒD/∑D ƒβ容=±40√n= 207.8460969083 ±208" 偏角 37.3535027974 37.3535027974 -）yC-yB= 3400.457 =1/20287 <1/2000 改正数Vi=-ƒβ/n= -0.0002274699 -1" ƒy= 0.250 测量： 计算： 监理： 日期：年月日微检查这一列的数据是正是负。如果（xC-xB）小于ΣΔx为负，反之为正。微检查这一列的数据是正是负。如果（xC-xB）小于ΣΔx为负，反之为正。微软用户:有背景颜色的为输入项，其它为自动计算项。微软用户:如果行数不够，可以插入行，公式由上面一行直接拖下来即可（注意有隐藏单元格）微软用户:注意这里的正负，如果为负，说明实测的X坐标小于理论上的，如果为正，说明实测的大于理论的。微软用户:微软用户:注意这里的正负，如果为负，说明实测的Y坐标小于理论上的，如果为正，说明实测的大于理论的。