新《组织施工设计》符合导线严密平差计算8.xls

附合导线严密平差计算表一(闭合差)9测角中误差m=7.0711测边中误差mD=0.50序号点号或点名已知点坐标(m)观测右角观测边长D(m)方位角概值三角函数值坐标增量(m)坐标概值(m)Y终-YiXi-X终XYcossinXYXY206.265206.2651C89-1-22973977.206495773.1042114655.82S42973503.137495479.373923747.52973503.137000495479.373000-7.4006020.750966135.3102990908.30.48713286-0.8733278865.913947-118.1699953D12353800.52973569.050947495361.203005-6.8276991.070526285.8362433107.8-0.44590361-0.89508099-127.455304-255.8463694D21450801.02973441.595643495105.356636-5.5873220.452606151.4952782306.80.14582789-0.9893099822.092196-149.8755155D32361236.02973463.687839494955.481121-4.8607050.559712162.5932221030.8-0.74109500-0.67140018-120.496860-109.1649696D41254800.52973343.190979494846.316153-4.331459-0.024473168.7652762230.30.11103677-0.9938163018.739120-167.7214087D52223455.52973361.930100494678.594745-3.5183230.066377277.0752334734.8-0.59070424-0.80688816-163.669376-223.5685388D61283312.52973198.260724494455.026207-2.434434-0.727114152.4712851422.30.26285490-0.9648353840.077749-147.1094159D71780222.02973238.338472494307.916793-1.721228-0.532812371.6502871200.30.29570947-0.95527792109.900425-355.02904010C88-5-32973348.276493952.915482547.02973348.238897493952.887753584613.311SD122973692.340494520.2941213141516171819202122232425262728闭合差始边:(1_2)=arctgY(2)-Y(1)=2114655.8(10_11)=584613.3X(10)=2973348.238897Wx=X(10)-X(10)=-37.10mmX(2)-X(1)终边:(10_11)=arctgY(11)-Y(10)=584601.1W=(10_11)-(10_11)=+12.2Y(10)=493952.887753Wy=Y(10)-Y(10)=-27.25mmX(11)-X(10)测量:记录:计算:复核:日期:)()(mmmD附合导线严密平差计算表二(坐标项系数)9点 位 序 号34567891011序号点号或点名坐标概值(m)Y3-YiXi-X3Y4-YiXi-X4Y5-YiXi-X5Y6-YiXi-X6Y7-YiXi-X7Y8-YiXi-X8Y9-YiXi-X9XY206.265206.265206.265206.265206.265206.265206.265206.265206.265206.265206.265206.265206.265206.2651C89-1-2#2S42973503.137000495479.373000-0.57290-0.31956-1.813280.29836-2.539900.19125-3.069140.77544-3.882280.68459-4.966171.47808-5.679371.283783D12973569.050947495361.203005-1.240380.61792-1.966990.51081-2.496241.09500-3.309381.00415-4.393261.79764-5.106471.603344D22973441.595643495105.356636-0.72662-0.10711-1.255860.47708-2.069000.38623-3.152891.17972-3.866090.985425D32973463.687839494955.481121-0.529250.58418-1.342380.49333-2.426271.28683-3.139481.092526D42973343.190979494846.316153-0.81314-0.09085-1.897030.70264-2.610230.508347D52973361.930100494678.594745-1.083890.79349-1.797100.599198D62973198.260724494455.026207-0.71321-0.194309D72973238.338472494307.91679310C88-5-32973348.238897493952.88775311SD121213141516171819202122232425262728计算:复核:日期:附合导线严密平差计算表二(坐标项系数)121314151617181920计算:复核:日期:9点 位 序 号序号点号或点名坐标概值(m)XY1C89-1-22S42973503.137000495479.3730003D12973569.050947495361.2030054D22973441.595643495105.3566365D32973463.687839494955.4811216D42973343.190979494846.3161537D52973361.930100494678.5947458D62973198.260724494455.0262079D72973238.338472494307.91679310C88-5-32973348.238897493952.88775311SD121213141516171819202122232425262728附合导线严密平差计算表二(坐标项系数)2122232425260.000000.00000计算:复核:日期:9点 位 序 号序号点号或点名坐标概值(m)XY1C89-1-22S42973503.137000495479.3730003D12973569.050947495361.2030054D22973441.595643495105.3566365D32973463.687839494955.4811216D42973343.190979494846.3161537D52973361.930100494678.5947458D62973198.260724494455.0262079D72973238.338472494307.91679310C88-5-32973348.238897493952.88775311SD121213141516171819202122232425262728符合导线严密平差计算表三(条件方程系数)序号编号abc1/P改正数v3456789-11.33711 2.66772024 4.95119137fx3fy3fx4fy4fx5fy5fx6fy6fx7fy7fx8fy8fx9fy91V2-1-7.4006024 0.750966491-4.6874473-0.5729038-0.3195595-1.8132808 0.29836064-2.5398971 0.19125475-3.0691433 0.77543946-3.8822789 0.68458973-4.9661687 1.47808051-5.6793746 1.283778282V3-1-6.8276986 1.070526021-1.576899900-1.240377 0.61792017-1.9669934 0.51081428-2.49623961.094999-3.3093751 1.00414926-4.393265 1.79764004-5.1064709 1.603337823V4-1-5.5873216 0.452605851-1.3273620000-0.7266163-0.1071059-1.2558625 0.47707883-2.0689981 0.38622909-3.1528879 1.17971987-3.8660938 0.985417654V5-1-4.8607053 0.559711741 1.14134881000000-0.5292462 0.58418471-1.3423818 0.49333498-2.4262716 1.28682576-3.1394775 1.092523535V6-1-4.331459-0.0244731-0.339180700000000-0.8131356-0.0908497-1.8970254 0.70264105-2.6102313 0.508338826V7-1-3.5183235 0.066376761 2.279851940000000000-1.0838898 0.79349078-1.7970957 0.599188557V8-1-2.4344336-0.7271141 1.24264209000000000000-0.7132059-0.19430228V9-1-1.7212277-0.53281181 4.10730341000000000000009V10-1001 11.33711060000000000000010VD2_30 0.48713286-0.87332790.67655-2.0462114 0.48713286-0.8733279 0.48713286-0.8733279 0.48713286-0.8733279 0.48713286-0.8733279 0.48713286-0.8733279 0.48713286-0.8733279 0.48713286-0.873327911VD3_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.89508112VD4_50 0.14582789-0.989310.757475-3.41563280000 0.14582789-0.98931 0.14582789-0.98931 0.14582789-0.98931 0.14582789-0.98931 0.14582789-0.9893113VD5_60-0.741095-0.67140020.812965-4.3097428000000-0.741095-0.6714002-0.741095-0.6714002-0.741095-0.6714002-0.741095-0.671400214VD6_70 0.11103677-0.99381630.843825-3.902150300000000 0.11103677-0.9938163 0.11103677-0.9938163 0.11103677-0.993816315VD7_80-0.5907042-0.80688821.385375-7.71777360000000000-0.5907042-0.8068882-0.5907042-0.806888216VD8_900.2628549-0.96483540.762355-3.10725320000000000000.2628549-0.964835417VD9_100 0.29570947-0.95527791.85825-7.323165600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 计算：复核：日期：000000000000000000 计算：复核：日期：符合导线严密平差计算表三(条件方程系数)10111213141516171819序号编号1V22V33V44V55V66V77V88V99V1010VD2_311VD3_412VD4_513VD5_614VD6_715VD7_816VD8_917VD9_10 计算：复核：日期：计算：复核：日期：符合导线严密平差计算表三(条件方程系数)202122232425262719序号编号1V22V33V44V55V66V77V88V99V1010VD2_311VD3_412VD4_513VD5_614VD6_715VD7_816VD8_917VD9_10 计算：复核：日期：计算：复核：日期：附合导线严密平差计算表四(解法方程)9组成法方程式系数点 位 序 号345678910项号系数项a/Pb/Pc/Pfx3/Pfy3/Pfx4/Pfy4/Pfx5/Pfy5/Pfx6/Pfy6/Pfx7/Pfy7/Pfx8/Pfy8/Pfx9/Pfy9/Pa行a936.68177169-1.61578808 0.5729038 0.3195595 3.0536578-0.916281 5.2335068-0.594963 7.3504916-2.931702 11.416169-2.477453 17.919508-7.23839822.91195-5.878282b行b197.8765164-15.12986325 4.4003772 2.0771106 22.332999-6.144429 36.747462-4.13134 50.253813-18.1423773.85148-15.60013109.5896-40.74899 134.57634-34.14942c行c9.955383624-0.718054 0.2760273-2.406977 2.5465803-4.168654 3.0443777-5.26393 5.0663131-7.6414185.644507-10.09806 8.8283335-11.8238 9.1205376fx(y)行fx(y)0.4887630.618124 5.2712306 2.1318663 11.308928 2.7113698 18.415459 5.1380606 33.685703 5.4800616 65.965747 14.091474 95.139657 12.252556解法方程式点 位 序 号345678910行符号 a Ka b Kb c KcWfx3fy3fx4fy4fx5fy5fx6fy6fx7fy7fx8fy8fx9fy9a936.68177169-1.6157880812.17736704 0.5729038 0.3195595 3.0536578-0.916281 5.2335068-0.594963 7.3504916-2.931702 11.416169-2.477453 17.919508-7.23839822.91195-5.878282EKa=-11.33711-4.075752410.179532009-1.353040782-0.063656-0.035507-0.3392950.101809-0.5815010.066107-0.816721 0.3257447-1.268463 0.2752726-1.991056 0.8042664-2.545772 0.6531425b197.8765164-15.12986325-37.10303502 4.4003772 2.0771106 22.332999-6.144429 36.747462-4.13134 50.253813-18.1423773.85148-15.60013109.5896-40.74899 134.57634-34.14942b148.370697-8.544311086-86.73496807 2.0653633 0.7746651 9.8870456-2.409896 15.416984-1.706417 20.295029-6.19347427.322-5.502645 36.554121-11.24707 41.192906-10.19099E1Kb=2.667720.1766422981.793130417-0.042699-0.016015-0.204402 0.0498214-0.318726 0.0352779-0.419573 0.1280419-0.564846 0.1137599-0.755708 0.2325182-0.851609 0.2106853c-11.337110649.955383624-27.24713529-0.718054 0.2760273-2.406977 2.5465803-4.168654 3.0443777-5.26393 5.0663131-7.6414185.644507-10.09806 8.8283335-11.8238 9.1205376c22.6677202398.156011197-40.38197222-0.2503690.470237-0.112278 1.9563891-0.505781 2.6361373-0.359321 3.4459494-0.765629 4.2277249-0.423931 5.5421014-0.433959 6.2650373E24.951191367Kc=4.951194.951191367 0.0306975-0.057655 0.0137662-0.239871 0.0620133-0.323214 0.0440559-0.4225040.093873-0.518357 0.0519778-0.679511 0.0532072-0.76815Ww00.4887630.618124 5.2712306 2.1318663 11.308928 2.7113698 18.415459 5.1380606 33.685703 5.4800616 65.965747 14.091474 95.139657 12.252556Ww3-371.9424559 0.3564203 0.5672595 2.2126657 1.4492356 3.3204857 1.7598032 3.8810841 1.9341222 3.7001143 1.9806358 2.6407174 1.8888051 1.7077258 1.4536214计算:复核:日期:附合导线严密平差计算表四(解法方程)组成法方程式系数1112131415161718解法方程式1112131415161718复核:日期:9点 位 序 号项号系数项a/Pb/Pc/Pa行a936.68177169-1.61578808b行b197.8765164-15.12986325c行c9.955383624fx(y)行fx(y)点 位 序 号行符号 a Ka b Kb c KcWa936.68177169-1.6157880812.17736704EKa=-11.33711-4.075752410.179532009-1.353040782b197.8765164-15.12986325-37.10303502b148.370697-8.544311086-86.73496807E1Kb=2.667720.1766422981.793130417c-11.337110649.955383624-27.24713529c22.6677202398.156011197-40.38197222E24.951191367Kc=4.951194.951191367Ww0Ww3-371.9424559计算:附合导线严密平差计算表四(解法方程)组成法方程式系数1920212223242526解法方程式1920212223242526复核:日期:9点 位 序 号项号系数项a/Pb/Pc/Pa行a936.68177169-1.61578808b行b197.8765164-15.12986325c行c9.955383624fx(y)行fx(y)点 位 序 号行符号 a Ka b Kb c KcWa936.68177169-1.6157880812.17736704EKa=-11.33711-4.075752410.179532009-1.353040782b197.8765164-15.12986325-37.10303502b148.370697-8.544311086-86.73496807E1Kb=2.667720.1766422981.793130417c-11.337110649.955383624-27.24713529c22.6677202398.156011197-40.38197222E24.951191367Kc=4.951194.951191367Ww0Ww3-371.9424559计算:附合导线严密平差计算表五(平差成果)9序号点号或点名右角观测值角度改正值角度平差值边长观测值D(m)边长改正数(mm)平差后边长(m)坐标方位角坐标增量(m)平差后坐标值(m)坐标权倒数中误差评定XYXY1/Px1/Py测角mmx(mm)my(mm)点位M(mm)1C89-1-22114655.82S4923747.5-4.69923742.82973503.137495479.37311.135135.310-2.05135.307952990913.065.91564-118.166713D12353800.5-1.582353758.92973569.053495361.2060.35640.5673 11.1356.6488.38610.701285.836-8.03285.827972433114.1-127.44395-255.843054D21450801.0-1.331450759.72973441.609495105.3632.21271.4492 11.135 16.563 13.40421.307151.495-3.42151.491582782314.422.09721-149.871325D32361236.0+1.142361237.12973463.706494955.4923.32051.7598 11.135 20.290 14.77125.097162.593-4.31162.588692221037.3-120.49025-109.165846D41254800.5-0.341254800.22973343.216494846.3263.88111.9341 11.135 21.936 15.48526.851168.765-3.90168.761102762237.118.74421-167.716917D52223455.5+2.282223457.82973361.960494678.6093.70011.9806 11.135 21.418 15.67026.539277.075-7.72277.067282334739.3-163.65993-223.565898D61283312.5+1.241283313.72973198.300494455.0432.64071.8888 11.135 18.094 15.30323.698152.471-3.11152.467892851425.640.07926-147.105789D71780222.0+4.111780226.12973238.379494307.9371.70771.4536 11.135 14.551 13.42519.798371.650-7.32371.642682871159.5109.89681-355.0224910C88-5-3482547.0+11.34482558.32973348.276493952.91511.135584601.111SD121213141516171819202122232425262728多余观测数r=3Pvv=371.9424558886 m=371.9424558886=11.134673计算:复核:日期:rpvv Pxi1m xi Pyi1m yi mm2yi2xiMi符合导线测量成果平面展示图X(m)比例:1:7500坐标原点:X=Y=坐标标注:是角度标注:是距离标注:是转置:否坐标极值:Xmin=2973198.3Ymin=493952.9最大间距:DX=778.9DY=1820.229743502974275297420029741252974050297397529739002973825297375029736752973600297352529734502973375297330029732252973150297307529730002972925297285029727752972700坐标原点493500493575493650493725493800493875493950494025494100494175494250494325494400494475494550494625494700494775494850494925495000495075495150495225495300495375495450495525495600495675495750495825495900495975496050496125Y(m)C89-1-2S4D1D2D3D4D5D6D7C88-5-3SD121213141516171819202122232425262728S=135.308S=285.828S=151.492S=162.589S=168.761S=277.067S=152.468S=371.643S S S S S S S S S S S S S S S S S92-37-42.8235-37-58.9145-07-59.7236-12-37.1125-48-00.2222-34-57.8128-33-13.7178-02-26.148-25-58.3A11A12A13A14A15A16A17A18A19A20A21A22A23A24A25A26A27X:2973503.137X:2973569.053X:2973441.609X:2973463.706X:2973343.216X:2973361.960X:2973198.300X:2973238.379X:2973348.276X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340Y:495479.373Y:495361.206Y:495105.363Y:494955.492Y:494846.326Y:494678.609Y:494455.043Y:494307.937Y:493952.915Y:494520.294Y:494520.294Y:494520.294Y:494520.294Y:494520.294Y:494520.294Y:494520.294Y:494520.294Y:494520.294Y:494520.294Y:494520.294Y:494520.294Y:494520.294Y:494520.294Y:494520.294Y:494520.294始边:(C89-1-2_S4)=211-46-55.8终边:(C88-5-3_SD12)=58-46-01.1注:角度标注均为右角 测量:制图:日期:符合导线测量成果平面展示图X(m)比例:1:7500坐标原点:X=Y=坐标标注:是角度标注:是距离标注:是转置:否坐标极值:Xmin=2973198.3Ymin=493952.9最大间距:DX=778.9DY=1820.229743502974275297420029741252974050297397529739002973825297375029736752973600297352529734502973375297330029732252973150297307529730002972925297285029727752972700坐标原点493500493575493650493725493800493875493950494025494100494175494250494325494400494475494550494625494700494775494850494925495000495075495150495225495300495375495450495525495600495675495750495825495900495975496050496125Y(m)C89-1-2S4D1D2D3D4D5D6D7C88-5-3SD121213141516171819202122232425262728S=135.308S=285.828S=151.492S=162.589S=168.761S=277.067S=152.468S=371.643S S S S S S S S S S S S S S S S S92-37-42.8235-37-58.9145-07-59.7236-12-37.1125-48-00.2222-34-57.8128-33-13.7178-02-26.148-25-58.3A11A12A13A14A15A16A17A18A19A20A21A22A23A24A25A26A27X:2973503.137X:2973569.053X:2973441.609X:2973463.706X:2973343.216X:2973361.960X:2973198.300X:2973238.379X:2973348.276X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340X:2973692.340Y:495479.373Y:495361.206Y:495105.363Y:494955.492Y:494846.326Y:494678.609Y:494455.043Y:494307.937Y:493952.915Y:494520.294Y:494520.294Y:494520.294Y:494520.294Y:494520.294Y:494520.294Y:494520.294Y:494520.294Y:494520.294Y:494520.294Y:494520.294Y:494520.294Y:494520.294Y:494520.294Y:494520.294Y:494520.294始边:(C89-1-2_S4)=211-46-55.8终边:(C88-5-3_SD12)=58-46-01.1注:角度标注均为右角 测量:制图:日期: