《闭合导线平差计算表-Excel自动计算.xls》由会员分享,可在线阅读,更多相关《闭合导线平差计算表-Excel自动计算.xls(1页珍藏版)》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、闭闭 合合 导导 线线 平平 差差 计计 算算 表表工程名称:隧道测量项目:导线测量测站观测角改正数改正后角值方 位 角边 长坐 标 增 量调整后坐标增量值坐 标测站左V左左aD(m)xyxyXYGPS19170.4754131.322-129.632-221.0005-129.63421.0053534882.2186418699.987GPS19GPS20216.4245021642453534752.5846418720.992GPS202073039247.203-219.250-4-114.1879-219.254-114.178SJL1226.2731022627313534533
2、.3306418606.813SJL12535810223.058-61.597-3-214.3848-61.600-214.376SJL221.531202153123534471.7306418392.437SJL2955123188.983-19.283-3187.9977-19.286188.004SJL3102.1218010212183534452.4446418580.441SJL31834185.07480.882-126.376380.88126.379SJL1189.2634018926343534533.3256418606.820SJL1273015247.202219
3、.262-4114.1619219.258114.170GPS2085.483608548363534752.5846418720.990GPS20293185195.16337.663-1-87.393337.662-87.390SJL4282.3023028230233534790.2466418633.600SJL43954915113.42991.974-266.384491.97266.388GPS19314.5839031458393534882.2186418699.989GPS1914395958214408640051840001331.4340.020-0.0460.0000.002角度闭合差改正计算:n=10坐标增量闭合差计算:导线相对闭合差计算:理=180(n-2)=1080 x理=0 y理=0D=(x2+y2)=测-理=-2x=0.02y=-0.046 =0.05容=40n=113K=D/D改正数Vi=/n=0=1/26544 1/2000测量:计算:监理:日期:年 月 日