单一附合导线近似平差EXCEL程序

1、单单一一附附合合导导线线近近似似平平差差计计算算准准备备数数据据已已知知条条件件：图为单一附合导线, 测角中误差m=52, 测边中误差mD=0.5Dmm, 其它已知数据和观测值列于表中，求各导线点平差值。注：一般规定：1、观测角数n不超过12个，超过时分段平差; 2、角度平分有余数时，边长短的多分; 3、边长改正数值按边长比例分配。已已知知数数据据点号已知座标起终方位角观测角个数n=6X（米）Y（米）度.分秒备注A4079.62410470.038237.5931237.5931表示2375931.07B13702.4379866.601C63020.34810950.19946.4459D3

2、381.35211333.954测测得得数数据据点号观测角观测边长观测角属性值k右=1，k左=-11度.分秒（米）备注1260.5901451.6922192.1425278.0593236.4837345.1534170.3922200.1305180.0042204.9526230.3237789101112测量：你记录：我计算：他复核：我们日期：2002年6月24日单单一一附附合合导导线线近近似似平平差差计计算算第1页共2页已已知知数数据据角角度度闭闭合合差差W及及改改正正数数Vi计计算算:点号座标方位角i备注W= CD - (AB +kn180- ki ) (公式)X（米）Y（米）度.

3、分秒= 12(秒) =5.81776E-05A4079.62410470.038237.5931Vi= -kW/n (公式)B13702.4379866.601测角属性k=1= -2.00(秒) =-9.69627E-06C63020.34810950.19946.4459测角个数n=6导导线线边边相相对对误误差差K计计算算:fx=-0.021fx=-0.021fy=-0.034fy=-0.034D3381.35211333.954K= 1(Di(fx2+fy2 )0.5 ) =1/37034角角度度平平差差值值i及及座座标标改改正正值值、平平差差值值、边边长长平平差差值值Di计计算算点号观测

4、角i改正数Vi平差后i平差后i观测边长Di座标增量初算座标初算i+Vii-1-kxi+180kDixCOSiDixSINixi-1+xiyi-1+yi度.分秒秒度.分秒度.分秒（米）xi（米）yi（米）xi, fx（米）yi, fy（米）1260.5901-2.00260.585900157.0032451.6923702.4373702.4379866.6019866.6012192.1425-2.00192.142300144.4609278.059-415.812176.4263286.62510043.0273236.4837-2.00236.48350087.5734345.153-

5、227.128160.4043059.49710203.4314170.3922-2.00170.39200097.1814200.1312.290344.9343071.78710548.3655180.0042-2.00180.00400097.1734204.952-25.443198.5063046.34410746.8716230.3237-2.00230.32350046.4459-26.017203.2943020.32710950.165789101112C646.445946.44593020.3483020.34810950.19910950.199差值0 -0.021-0

6、.034合计1271.14441271.14321479.986测量：你记录：我计算：他复核：我们日期：2002年6月24日单单一一附附合合导导线线近近似似平平差差计计算算第2页共2页点号座标改正值平差后座标平差后边长Di 边长改正VDi备注 -fxxDj/Di -fyxDj/Dixi+Vxiyi+Vyi(xi2+yi2)0.5Di-Di Vxi（米）Vyi（米）xi（米）yi（米）（米）（米）13702.4373702.4379866.6019866.601451.690-0.00220.0060.0103286.63110043.037278.05930.0100.0173059.50710203.448345.1610.00840.0150.0253071.80210548.390200.1330.00350.0180.0293046.36210746.900204.9570.00560.0210.0343020.348109