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

工程名称：

观测角β′左GPS14GPS13167.7042+521817\"313°7.'39\"灵关经双石至宝盛（玉溪）公路灾后恢复重建工程（芦山境）LB1标段

改正数V′左改正后角值β左方 位 角a198°56'4\"332°3.'43\"1031.795911.544###205.809-159.076###235.037-34.760###223.822-49.501###226.525-140.488###391.253-374.909###260.296-246.944###313.165-186.356###359.309-9.200359.191251.682###82.297###-111.904###-177.698###218.280###-232.452###130.584###边 长D(m)△x坐 标 增 量△y测量项目：导线贯通测量

坐 标X3353243.4153352267.514Y506524.142506189.361测站调整后坐标增量值△x△y###-483.414###1197.758###-101.986161.028-330.7891203.3583+521817\"348°33'21\"500°37'4\"3353465.272505858.5722155.5542+521817\"300°52'39\"621°29'43\"3353465.27230.438-197.6853353363.28612.586251.3883353495.710-77.651-144.1903353375.872-266.378-54.0293353418.059-174.739120.8013353109.495-99.486298.0063353243.32090.470412.341505858.5723235.7958+521817\"381°16'56\"822°46'38\"506019.6014163.5597+521817\"308°53'35\"951°40'13\"505660.88750.0000+521817\"144°56'57\"916°37'10\"506270.98860.0000+521817\"144°56'57\"881°34'7\"505516.69770.0000+521817\"144°56'57\"846°31'5\"506216.96080.0000+521817\"144°56'57\"811°28'2\"505637.498附合导线平差计算

工程名称：

观测角β′左90.0000灵关经双石至宝盛（玉溪）公路灾后恢复重建工程（芦山境）LB1标段

改正数V′左+521817\"改正后角值β左144°56'57\"方 位 角a776°24'59\"182.130100.746###197.900184.299###230.611224.064###200.381132.158###119.99712.988###155.928-75.208###68.630-61.625###196.553-194.166###99.863-71.848###93.461-17.76991.75669.358###30.540###-30.206###-136.592###-119.292###-150.622###-54.559###72.099###边 长D(m)359.309△x-9.200坐 标 增 量###△y359.191###测量项目：导线贯通测量

坐 标X3353010.008Y506514.965测站调整后坐标增量值△x90.470△y412.341###151.729###151.268###239.195101.373178.670100.0000+521817\"144°56'57\"741°21'56\"3353161.276506693.635110.0000+521817\"144°56'57\"706°18'54\"3353400.471288.034-20.4473353688.505187.743-120.9813353876.24846.274-101.5423353922.521-31.954-113.5273353890.568-42.587-20.0543353847.980-139.64359.6153353708.337-44.14784.1303353010.0088.157105.581506795.008120.0000+521817\"144°56'57\"671°15'51\"506774.561130.0000+521817\"144°56'57\"636°12'48\"506653.580140.0000+521817\"144°56'57\"601°9.'46\"506552.038150.0000+521817\"144°56'57\"566°6.'43\"506438.511160.0000+521817\"144°56'57\"531°3.'40\"506418.457170.0000+521817\"144°56'57\"496°0.'37\"506478.073180.0000+521817\"144°56'57\"460°57'35\"506514.965附合导线平差计算

工程名称：

观测角β′左190.0000灵关经双石至宝盛（玉溪）公路灾后恢复重建工程（芦山境）LB1标段

改正数V′左+521817\"改正后角值β左144°56'57\"方 位 角a425°54'32\"113.92346.502###143.780123.426###419.320418.198###420.320325.524###421.320421.320###422.320422.320###423.320423.320###424.320424.320###425.320425.320###426.320426.3200.0000.000###0.000###0.000###0.000###0.000###-265.901###-30.656###73.747###边 长D(m)93.461△x-17.769坐 标 增 量###△y91.756###测量项目：导线贯通测量

坐 标X3353018.166Y506620.547测站调整后坐标增量值△x8.157△y105.581###104.000###78.104###163.31095.015120.852200.0000+521817\"144°56'57\"390°51'29\"3353096.270506741.399210.0000+521817\"144°56'57\"355°48'27\"3353259.580534.51531.3713349864.943442.118-203.7263350307.061538.19262.3233349864.943539.46962.4703350404.412540.74762.6183349864.943542.02462.7663350406.967543.30162.9143350950.268544.57963.062506836.413220.0000+521817\"144°56'57\"320°45'24\"504732.312230.0000+521817\"144°56'57\"504528.586240.0000+521817\"144°56'57\"504732.312250.0000+521817\"144°56'57\"504794.782260.0000+521817\"144°56'57\"504732.312270.0000+521817\"144°56'57\"504795.078280.0000+521817\"144°56'57\"504857.992附合导线平差计算

工程名称：

观测角β′左290.0000灵关经双石至宝盛（玉溪）公路灾后恢复重建工程（芦山境）LB1标段

改正数V′左+521817\"改正后角值β左144°56'57\"427.320427.320###428.320428.320###429.320429.320###430.320430.320###431.320431.3200.0000.000###0.000###0.000###方 位 角a边 长D(m)426.320△x426.320坐 标 增 量###△y0.000###测量项目：导线贯通测量

坐 标X3351494.847Y504921.054测站调整后坐标增量值△x544.579△y63.062###0.000###545.856###547.13463.35863.210300.0000+521817\"144°56'57\"3352040.703504984.264310.0000+521817\"144°56'57\"3352587.837548.41163.5063353136.248549.68863.6543353685.936550.96663.802505047.622320.0000+521817\"144°56'57\"505111.128330.0000+521817\"144°56'57\"505174.782340.0000+521817\"144°56'57\"GPS11∑927°59'22\"18263605\"6001°12'48\"10,579.328坐标增量闭合差计算：∑△x=532.075532.075###107.868###8,481.7661,406.8843349847.827504633.758角度闭合差改正计算：∑β测-n*180=5372°0.'38\"导线相对闭合差计算：ƒD=√(ƒx2+ƒy2)附合导线平差计算

工程名称：

观测角β′左灵关经双石至宝盛（玉溪）公路灾后恢复重建工程（芦山境）LB1标段

改正数V′左改正后角值β左方 位 角a边 长D(m)△x坐 标 增 量△y测量项目：导线贯通测量

坐 标XY测站调整后坐标增量值△x△y =3325.825aAB-aCD=298°47'12\"ƒB=∑β-n*180+aAB-aCD=-18263605\"ƒβ容=± 40√n =±237\"改正数Vi=-ƒβ/n=+521817\"测 量：

-）xC-xB=-2402.571ƒx=2934.646∑△y=107.868-）yC-yB=-1457.049ƒy=1564.917计 算：

监 理：

K=ƒD/∑D =1/3<1/2000日期： 年 月 日

测站GPS14GPS13167203135155163323520241631945422119330473533301530151545450353012678测站9101112131415161718测站19202122232425262728测站293031323334GPS11测站