符合导线严密平差.xls
附合导线严密平差计算表一闭合差 9测角中误差mβ 7.0711″测边中误差mD0.50 序 号 点号或 点名 已知点坐标m 观测右角 β 观测边长 Dm 方位角概值 α 三角函数值 坐标增量m坐标概值m Y终-YiXi-X终 XYcosαsinα△X△YXY 206.265206.265 1C89-1-22973977.206495773.104 21146′55.8″ 2S42973503.137495479.3739237′47.5″2973503.137000495479.373000-7.4006020.750966 135.31029909′08.3″0.48713286 -0.8733278865.913947-118.169995 3D123538′00.5″2973569.050947495361.203005-6.8276991.070526 285.83624331′07.8″ -0.44590361 -0.89508099-127.455304-255.846369 4D214508′01.0″2973441.595643495105.356636-5.5873220.452606 151.49527823′06.8″0.14582789 -0.9893099822.092196-149.875515 5D323612′36.0″2973463.687839494955.481121-4.8607050.559712 162.59322210′30.8″ -0.74109500 -0.67140018-120.496860-109.164969 6D412548′00.5″2973343.190979494846.316153-4.331459-0.024473 168.76527622′30.3″0.11103677 -0.9938163018.739120-167.721408 7D522234′55.5″2973361.930100494678.594745-3.5183230.066377 277.07523347′34.8″ -0.59070424 -0.80688816-163.669376-223.568538 8D612833′12.5″2973198.260724494455.026207-2.434434-0.727114 152.47128514′22.3″0.26285490 -0.9648353840.077749-147.109415 9D717802′22.0″2973238.338472494307.916793-1.721228-0.532812 371.65028712′00.3″0.29570947 -0.95527792109.900425-355.029040 10C88-5-32973348.276493952.9154825′47.0″2973348.238897493952.887753 5846′13.3″ 11SD122973692.340494520.294 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 闭 合 差 始边α1_2arctg Y2-Y1 21146′55.8″α10_11 5846′13.3″X10 2973348.238897WxX10-X10 -37.10mm X2-X1 终边α10_11arctg Y11-Y10 5846′01.1″Wαα10_11-α10_11 12.2″Y10 493952.887753WyY10-Y10 -27.25mm X11-X10 测量记录计算复核日期 m mmD 附合导线严密平差计算表二坐标项系数 9 点 位 序 号3456789101112 序 号 点号或 点名 坐标概值m Y3-YiXi-X3Y4-YiXi-X4Y5-YiXi-X5Y6-YiXi-X6Y7-YiXi-X7Y8-YiXi-X8Y9-YiXi-X9 XY 206.265206.265206.265206.265206.265206.265206.265206.265206.265206.265206.265206.265206.265206.265 1C89-1-2495361.203012973569.05095495105.356642973441.59564494955.481122973463.68784494846.316152973343.19098494678.594752973361.93010494455.026212973198.26072494307.916792973238.33847493952.887752973348.23890 2S42973503.137000495479.373000 -0.57290 -0.31956 -1.813280.29836 -2.539900.19125 -3.069140.77544 -3.882280.68459 -4.966171.47808 -5.679371.28378 3D12973569.050947495361.203005-1.240380.61792 -1.966990.51081 -2.496241.09500 -3.309381.00415 -4.393261.79764 -5.106471.60334 4D22973441.595643495105.356636-0.72662 -0.10711 -1.255860.47708 -2.069000.38623 -3.152891.17972 -3.866090.98542 5D32973463.687839494955.481121-0.529250.58418 -1.342380.49333 -2.426271.28683 -3.139481.09252 6D42973343.190979494846.316153-0.81314 -0.09085 -1.897030.70264 -2.610230.50834 7D52973361.930100494678.594745-1.083890.79349 -1.797100.59919 8D62973198.260724494455.026207-0.71321 -0.19430 9D72973238.338472494307.916793 10C88-5-32973348.238897493952.887753 11SD12 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 计算复核日期计算 9 点 位 序 号 序 号 点号或 点名 坐标概值m XY 1C89-1-2 2S42973503.137000495479.373000 3D12973569.050947495361.203005 4D22973441.595643495105.356636 5D32973463.687839494955.481121 6D42973343.190979494846.316153 7D52973361.930100494678.594745 8D62973198.260724494455.026207 9D72973238.338472494307.916793 10C88-5-32973348.238897493952.887753 11SD12 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 附合导线严密平差计算表二坐标项系数 13141516171819202122 复核日期计算 9 点 位 序 号 序 号 点号或 点名 坐标概值m XY 1C89-1-2 2S42973503.137000495479.373000 3D12973569.050947495361.203005 4D22973441.595643495105.356636 5D32973463.687839494955.481121 6D42973343.190979494846.316153 7D52973361.930100494678.594745 8D62973198.260724494455.026207 9D72973238.338472494307.916793 10C88-5-32973348.238897493952.887753 11SD12 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 附合导线严密平差计算表二坐标项系数 23242526 0.000000.00000 复核日期 计算复核日期 符合导线严密平差计算表三条件方程系数 序号编号 abc 1/P 改正数 v 345678910 -11.33711 2.667720244.95119137fx3fy3fx4fy4fx5fy5fx6fy6fx7fy7fx8fy8fx9fy9 1Vβ2-1-7.40060240.750966491-4.6874473-0.5729038-0.3195595-1.81328080.29836064-2.53989710.19125475-3.06914330.77543946-3.88227890.68458973-4.96616871.47808051-5.67937461.28377828 2Vβ3-1-6.82769861.070526021-1.576899900 -1.2403770.61792017-1.96699340.51081428-2.49623961.094999-3.30937511.00414926 -4.3932651.79764004-5.10647091.60333782 3Vβ4-1-5.58732160.452605851 -1.3273620000-0.7266163-0.1071059-1.25586250.47707883-2.06899810.38622909-3.15288791.17971987-3.86609380.98541765 4Vβ5-1-4.86070530.5597117411.14134881000000-0.52924620.58418471-1.34238180.49333498-2.42627161.28682576-3.13947751.09252353 5Vβ6-1 -4.331459 -0.0244731-0.339180700000000-0.8131356-0.0908497-1.89702540.70264105-2.61023130.50833882 6Vβ7-1-3.51832350.0663767612.279851940000000000-1.08388980.79349078-1.79709570.59918855 7Vβ8-1-2.4344336 -0.72711411.24264209000000000000-0.7132059-0.1943022 8Vβ9-1-1.7212277-0.532811814.1073034100000000000000 9Vβ10-100111.337110600000000000000 10VD2_300.48713286-0.87332790.67655-2.04621140.48713286-0.87332790.48713286-0.87332790.48713286-0.87332790.48713286-0.87332790.48713286-0.87332790.48713286-0.87332790.48713286-0.8733279 11VD3_40-0.4459036 -0.8950811.42918-8.033797100-0.4459036 -0.895081-0.4459036 -0.895081-0.4459036 -0.895081-0.4459036 -0.895081-0.4459036 -0.895081-0.4459036 -0.895081 12VD4_500.14582789-0.989310.757475-3.415632800000.14582789-0.989310.14582789-0.989310.14582789-0.989310.14582789-0.989310.14582789-0.98931 13VD5_60 -0.741095-0.67140020.812965-4.3097428000000 -0.741095-0.6714002 -0.741095-0.6714002 -0.741095-0.6714002 -0.741095-0.6714002 14VD6_700.11103677-0.99381630.843825-3.9021503000000000.11103677-0.99381630.11103677-0.99381630.11103677-0.9938163 15VD7_80-0.5907042-0.80688821.385375-7.71777360000000000-0.5907042-0.8068882-0.5907042-0.8068882 16VD8_90 0.2628549-0.96483540.762355-3.1072532000000000000 0.2628549-0.9648354 17VD9_1000.29570947-0.95527791.85825-7.323165600000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 000000000000000000 计算复核日期 序号编号 1Vβ2 2Vβ3 3Vβ4 4Vβ5 5Vβ6 6Vβ7 7Vβ8 8Vβ9 9Vβ10 10VD2_3 11VD3_4 12VD4_5 13VD5_6 14VD6_7 15VD7_8 16VD8_9 17VD9_10 符合导线严密平差计算表三条件方程系数 1112131415161718192010 计算复核日期 序号编号 1Vβ2 2Vβ3 3Vβ4 4Vβ5 5Vβ6 6Vβ7 7Vβ8 8Vβ9 9Vβ10 10VD2_3 11VD3_4 12VD4_5 13VD5_6 14VD6_7 15VD7_8 16VD8_9 17VD9_10 符合导线严密平差计算表三条件方程系数 2122232425262720 附合导线严密平差计算表四解法方程 9组成法方程式系数 点 位 序 号34567891011 项号系数项a/P]b/P]c/P]fx3/P]fy3/P]fx4/P]fy4/P]fx5/P]fy5/P]fx6/P]fy6/P]fx7/P]fy7/P]fx8/P]fy8/P]fx9/P]fy9/P] a行[a936.68177169 -1.615788080.57290380.31955953.0536578-0.9162815.2335068-0.5949637.3504916-2.93170211.416169-2.47745317.919508-7.238398 22.91195-5.878282 b行[b197.8765164 -15.12986324.40037722.077110622.332999-6.14442936.747462 -4.1313450.253813-18.14237 73.85148-15.60013 109.5896-40.74899134.57634-34.14942 c行[c9.955383624-0.7180540.2760273-2.4069772.5465803-4.1686543.0443777 -5.263935.0663131-7.641418 5.644507-10.098068.8283335 -11.82389.1205376 fxy行[fxy0.488763 0.6181245.27123062.131866311.3089282.711369818.4154595.138060633.6857035.480061665.96574714.09147495.13965712.252556 解法方程式 点 位 序 号34567891011 行符号 a Ka b Kb c Kc Wfx3fy3fx4fy4fx5fy5fx6fy6fx7fy7fx8fy8fx9fy9 a936.68177169-1.61578808 12.177367040.57290380.31955953.0536578-0.9162815.2335068-0.5949637.3504916-2.93170211.416169-2.47745317.919508-7.238398 22.91195-5.878282 EKa-11.33711-4.075752410.179532009 -1.35304078-0.063656-0.035507-0.339295 0.101809-0.581501 0.066107-0.8167210.3257447-1.2684630.2752726-1.9910560.8042664-2.5457720.6531425 b197.8765164 -15.12986325-37.1030354.40037722.077110622.332999-6.14442936.747462 -4.1313450.253813-18.14237 73.85148-15.60013 109.5896-40.74899134.57634-34.14942 b148.370697 -8.544311086 -86.73496812.06536330.77466519.8870456-2.40989615.416984-1.70641720.295029-6.19347427.322-5.50264536.554121-11.2470741.192906-10.19099 E1Kb2.667720.176642298 1.793130417-0.042699-0.016015-0.2044020.0498214-0.3187260.0352779-0.4195730.1280419-0.5648460.1137599-0.7557080.2325182-0.8516090.2106853 c-11.337110649.955383624 -27.2471353-0.7180540.2760273-2.4069772.5465803-4.1686543.0443777 -5.263935.0663131-7.641418 5.644507-10.098068.8283335 -11.82389.1205376 c22.6677202398.156011197 -40.3819722-0.250369 0.470237-0.1122781.9563891-0.5057812.6361373-0.3593213.4459494-0.7656294.2277249-0.4239315.5421014-0.4339596.2650373 E24.951191367Kc4.951194.9511913670.0306975-0.0576550.0137662-0.2398710.0620133-0.3232140.0440559-0.422504 0.093873-0.5183570.0519778-0.6795110.0532072 -0.76815 Ww0 0.488763 0.6181245.27123062.131866311.3089282.711369818.4154595.138060633.6857035.480061665.96574714.09147495.13965712.252556 Ww3-371.9424560.35642030.56725952.21266571.44923563.32048571.75980323.88108411.93412223.70011431.98063582.64071741.88880511.70772581.4536214 计算复核日期 9 点 位 序 号 项号系数项a/P]b/P]c/P] a行[a936.68177169 -1.61578808 b行[b197.8765164 -15.1298632 c行[c9.955383624 fxy行[fxy 点 位 序 号 行符号 a Ka b Kb c Kc W a936.68177169-1.61578808 12.17736704 EKa-11.33711-4.075752410.179532009 -1.35304078 b197.8765164 -15.12986325-37.103035 b148.370697 -8.544311086 -86.7349681 E1Kb2.667720.176642298 1.793130417 c-11.337110649.955383624 -27.2471353 c22.6677202398.156011197 -40.3819722 E24.951191367Kc4.951194.951191367 Ww0 Ww3-371.942456 计算 附合导线严密平差计算表四解法方程 组成法方程式系数 121314151617181920 解法方程式 121314151617181920 复核日期复核 9 点 位 序 号 项号系数项a/P]b/P]c/P] a行[a936.68177169 -1.61578808 b行[b197.8765164 -15.1298632 c行[c9.955383624 fxy行[fxy 点 位 序 号 行符号 a Ka b Kb c Kc W a936.68177169-1.61578808 12.17736704 EKa-11.33711-4.075752410.179532009 -1.35304078 b197.8765164 -15.12986325-37.103035 b148.370697 -8.544311086 -86.7349681 E1Kb2.667720.176642298 1.793130417 c-11.337110649.955383624 -27.2471353 c22.6677202398.156011197 -40.3819722 E24.951191367Kc4.951194.951191367 Ww0 Ww3-371.942456 计算 附合导线严密平差计算表四解法方程 组成法方程式系数 212223242526 解法方程式 212223242526 日期 附合导线严密平差计算表五平差成果 9 序 号 点号或 点名 右角观测值 β 角度改 正值″ 角度平差值 边长观测 值Dm 边长改正 数mm 平差后 边长m 坐标方位角 坐标增量m平差后坐标值m坐标权倒数中误差评定 △X△YXY1/Px1/Py测角mβmxmmmymm点位Mmm 1C89-1-2 21146′55.8″ 2S49237′47.5″-4.699237′42.8″2973503.137495479.37311.135″ 135.310-2.05 135.3079529909′13.0″65.91564-118.16671 3D123538′00.5″-1.5823537′58.9″2973569.053495361.2060.35640.5673 11.135″6.6488.38610.701 285.836-8.03 285.8279724331′14.1″-127.44395-255.84305 4D214508′01.0″-1.3314507′59.7″2973441.609495105.3632.21271.4492 11.135″ 16.563 13.40421.307 151.495-3.42 151.4915827823′14.4″22.09721-149.87132 5D323612′36.0″1.1423612′37.1″2973463.706494955.4923.32051.7598 11.135″ 20.290 14.77125.097 162.593-4.31 162.5886922210′37.3″-120.49025-109.16584 6D412548′00.5″-0.3412548′00.2″2973343.216494846.3263.88111.9341 11.135″ 21.936 15.48526.851 168.765-3.90 168.7611027622′37.1″18.74421-167.71691 7D522234′55.5″2.2822234′57.8″2973361.960494678.6093.70011.9806 11.135″ 21.418 15.67026.539 277.075-7.72 277.0672823347′39.3″-163.65993-223.56589 8D612833′12.5″1.2412833′13.7″2973198.300494455.0432.64071.8888 11.135″ 18.094 15.30323.698 152.471-3.11 152.4678928514′25.6″40.07926-147.10578 9D717802′22.0″4.1117802′26.1″2973238.379494307.9371.70771.4536 11.135″ 14.551 13.42519.798 371.650-7.32 371.6426828711′59.5″109.89681-355.02249 10C88-5-34825′47.0″11.344825′58.3″2973348.276493952.91511.135″ 5846′01.1″ 11SD12 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 多余观测数r 3[Pvv] 371.9424558886 mβμ 371.9424558886 11.13467 3 计算复核日期 r ]p v v[ P x i 1 μm x i P y i 1 μm y i mm 2 yi 2 xi Mi 测量制图日期 符合导线测量成果平面展示图 Xm 比例 17500坐标原点XY坐标标注 是角度标注 是距离标注 是转置 否坐标极值Xmin2973198.3Ymin493952.9最大间距DX778.9DY1820.2 2974350 2974275 2974200 2974125 2974050 2973975 2973900 2973825 2973750 2973675 2973600 2973525 2973450 2973375 2973300 2973225 2973150 2973075 2973000 2972925 2972850 2972775 2972700 坐标 原点 493500 493575 493650 493725 493800 493875 493950 494025 494100 494175 494250 494325 494400 494475 494550 494625 494700 494775 494850 494925 495000 495075 495150 495225 495300 495375 495450 495525 495600 495675 495750 495825 495900 495975 496050 496125 Ym C89-1-2 S4 D1 D2 D3 D4 D5 D6 D7 C88-5-3 SD12 1213141516171819202122232425262728 S135.308 S285.828 S151.492 S162.589 S168.761 S277.067 S152.468 S371.643 S S S S S S S S S S S S S S S S S 92-37-42.8 235-37-58.9 145-07-59.7 236-12-37.1 125-48-00.2 222-34-57.8 128-33-13.7 178-02-26.1 48-25-58.3 A11A12A13A14A15A16A17A18A19A20A21A22A23A24A25A26A27 X2973503.137 X2973569.053 X2973441.609 X2973463.706 X2973343.216 X2973361.960 X2973198.300 X2973238.379 X2973348.276 X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340 Y495479.373 Y495361.206 Y495105.363 Y494955.492 Y494846.326 Y494678.609 Y494455.043 Y494307.937 Y493952.915 Y494520.294Y494520.294Y494520.294Y494520.294Y494520.294Y494520.294Y494520.294Y494520.294Y494520.294Y494520.294Y494520.294Y494520.294Y494520.294Y494520.294Y494520.294Y494520.294 始边αC89-1-2_S4211-46-55.8 终边αC88-5-3_SD1258-46-01.1 注角度标注均为右角 测量制图日期 符合导线测量成果平面展示图 Xm 比例 17500坐标原点XY坐标标注 是角度标注 是距离标注 是转置 否坐标极值Xmin2973198.3Ymin493952.9最大间距DX778.9DY1820.2 2974350 2974275 2974200 2974125 2974050 2973975 2973900 2973825 2973750 2973675 2973600 2973525 2973450 2973375 2973300 2973225 2973150 2973075 2973000 2972925 2972850 2972775 2972700 坐标 原点 493500 493575 493650 493725 493800 493875 493950 494025 494100 494175 494250 494325 494400 494475 494550 494625 494700 494775 494850 494925 495000 495075 495150 495225 495300 495375 495450 495525 495600 495675 495750 495825 495900 495975 496050 496125 Ym C89-1-2 S4 D1 D2 D3 D4 D5 D6 D7 C88-5-3 SD12 1213141516171819202122232425262728 S135.308 S285.828 S151.492 S162.589 S168.761 S277.067 S152.468 S371.643 S S S S S S S S S S S S S S S S S 92-37-42.8 235-37-58.9 145-07-59.7 236-12-37.1 125-48-00.2 222-34-57.8 128-33-13.7 178-02-26.1 48-25-58.3 A11A12A13A14A15A16A17A18A19A20A21A22A23A24A25A26A27 X2973503.137 X2973569.053 X2973441.609 X2973463.706 X2973343.216 X2973361.960 X2973198.300 X2973238.379 X2973348.276 X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340X2973692.340 Y4954
矿业文库