《导线计算表(自编程序)(2).xls》由会员分享，可在线阅读，更多相关《导线计算表(自编程序)(2).xls（21页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、附附 合合 导导 线线 计计 算算 表表工工程程名名称称：北北卦卦地地隧隧道道贯贯通通测测量量点 号观测左角观测左角()角度改正数()方位角()平距(M)坐标增量改正后坐标增量度分秒X(M)改正数(M)Y(M)改正数(M)X(M)Y(M)DBM01324.636722SX3009-233113033.191667-0.9975177.828112264.605-264.4149-0.006810.0279-0.0122-264.421710.0157DK340+760172531172.091944-0.9975169.91977988.894-87.5218-0.002315.5588-0.
2、0041-87.524115.5547DK340+8501903947190.663056-0.9975180.582558152.176-152.1681-0.0039-1.5472-0.0070-152.1720-1.5542DK341+001182641182.111389-0.9975182.693669127.768-127.6268-0.0033-6.0046-0.0059-127.6301-6.0105DK341+1291815315181.887500-0.9975184.580892134.944-134.5129-0.0034-10.7775-0.0062-134.5164
3、-10.7837DK341+264176150176.030556-0.9975180.611171136.956-136.9482-0.0035-1.4609-0.0063-136.9517-1.4672DK341+401184173184.284167-0.9975184.895060107.718-107.3251-0.0028-9.1917-0.0050-107.3279-9.1966DK341+509176819176.138611-0.9975181.033394163.965-163.9383-0.0042-2.9571-0.0076-163.9425-2.9647DK341+6
4、721812921181.489167-0.9975182.522284116.086-115.9735-0.0030-5.1087-0.0053-115.9765-5.1141DK341+788181496181.818333-0.9975184.340340121.396-121.0478-0.0031-9.1873-0.0056-121.0510-9.1929ZD153185153.301389-0.9975157.641452184.634-170.7535-0.004770.2350-0.0085-170.758270.2265SX3010-346485146.814167-0.99
5、7524.455342SX3009-318552843191859.821944-1582.231149.5867185518552842843193191859.8219441859.821944-11.9700-11.9700 1599.1421599.1420.04090.04090.07370.0737已已知知始始=3243812.2324.636722坐坐标标增增量量闭闭合合差差fx (m)=0.041坐坐标标增增量量闭闭合合差差fx (m)=0.0737已已知知终终=242719.2324.455342已已知知边边数数n=n=12角角度度闭闭合合差差f fb b()=()=11.9
6、700 导导线线全全长长闭闭合合差差f (m)=0.084角角度度闭闭合合差差限限差差（）=34.6410导导线线全全长长相相对对闭闭合合差差K=K=1/1/18983.7873f=f测-f理K=f/D=1/1898315000备 注f=11.97 fx=40.09mm fy=73.37mm fs=84.24mmf允=34.64 D=1599.142m 1/K=1/18983 1/15000计算：校核：日期：平差后坐标备 注X(M)Y(M)4003786.490479767.296已知点4003919.965479672.569已知点4003655.543479682.5854003568.0
7、19479698.1394003415.847479696.5854003288.217479690.5754003153.701479679.7914003016.749479678.3244002909.421479669.1274002745.479479666.1624002629.502479661.0484002508.451479651.8554002337.693479722.082已知点4002575.016479830.013已知点闭闭 合合 导导 线线 计计 算算 表表点 号观测左角观测左角()角度改正数()改正后左角方位角()平距(M)坐标增量改正后坐标增量度分秒X(M
8、)改正数(M)Y(M)改正数(M)X(M)Y(M)A54154054.261111161.610531B89381089.636111-12.500143.893750431.4104125.504281105.223-61.1097-0.014485.65910.0189-61.124185.678011074830107.808333-12.500107.80486153.30914280.18247.9085-0.011064.29560.014447.897664.310027302073.005556-12.50073.002083306.311225129.34176.5920-0
9、.0177-104.22460.023276.5743-104.2013389335089.563889-12.50089.560417215.87164278.162-63.3372-0.0107-45.80070.0140-63.3478-45.7867B54154054.26111154.261111A358119110358119110360.013889-50.000414.261111392.9080.0537-0.0705已知1=1613637.9161.610531坐标增量闭合差fx(m)=0.0537坐标增量闭合差fx(m)=-0.0705已知边数n=4角度闭合差fb()=5
10、0.000导线全长闭合差f(m)=0.088621角度闭合差限差（）=32.000导线全长相对闭合差K=1/4433.5691f=f测-f理K=f/D=1/18056315000f=18符合精度要求f允=16n=28.284ff允，符合精度要求符符合合导导线线测测量量成成果果平平面面展展示示图图 比例：1:7500 坐标原点:X=Y=坐标标注:是 角度标注：是 转置：否 坐标极值：Xmin=Ymin=最大间距：DX=Dy=2538506.3210505215.6520 2538445.1969505301.3300 2538493.0945505365.6400 2538569.6688505
11、261.4387 2538506.3210505215.6520 2538811.4090505114.2250 400264540026154002585400255540025254002495400246540024354002405400237540023454002315400228540022554002225400219540021654002135400210540020754002045400201540019854001955400192540018954001865400183540018054001775400174540017154001685400165540016
12、25487725487775487825487875487925487975488025488075488125488175488225488275488325488375488425488475488525488575平差后坐标X(M)Y(M)2538506.3210505215.65202538445.1969505301.33002538493.0945505365.64002538569.6688505261.43872538506.3210505215.65202538811.4090505114.22502538506.3210505215.6520 2538445.1969505
13、301.3300 2538493.0945505365.6400 2538569.6688505261.4387 2538506.3210505215.6520 2538811.4090505114.2250 400264540026154002585400255540025254002495400246540024354002405400237540023454002315400228540022554002225400219540021654002135400210540020754002045400201540019854001955400192540018954001865400183
14、54001805400177540017454001715400168540016554001625487725487775487825487875487925487975488025488075488125488175488225488275488325488375488425488475488525488575附附(闭闭)合合路路线线水水准准测测量量平平差差计计算算表表工程名称：北卦地隧道贯通测量点名路线长度L（Km）往返测高差平均值改正数改正后高差高程（H/m）备注V（hi/mm）（hi/m）SX3009-2264.5-8.852-0.000166-8.852000606.433已知点D
15、K340+760597.581890.436-0.0000560.436000DK340+850598.0171520.811-0.0000950.811000DK341+001598.8281270.651-0.0000790.651000DK341+129599.4791350.695-0.0000850.695000DK341+264600.1741370.788-0.0000860.788000DK341+401600.9621080.553-0.0000680.553000DK341+509601.5151640.943-0.0001030.943000DK341+672602.45
16、81160.65-0.0000730.650000DK341+788603.1081210.526-0.0000760.526000ZD603.63418456.825-0.00011556.825000SX3010-3660.458已知点1597.554.026-0.00100054.025999测量结果：1、闭合差：fn=0.00102、允许误差：f容=15.16713、其他备注计算：校核：日期：符合导线测量成果平面展示图X(m)比例:1:7500坐标原点:X=Y=坐标标注:是337805033779753377900337782533777503377675337760033775253
17、37745033773753377300337722533771503377075337700033769253376850337677533767003376625337655033764753376400坐标原点454900454975455050455125455200455275455350455425455500455575455650455725455800455875角度标注:是距离标注:是转置:否坐标极值:Xmin=3377095.4Ymin=455956.5符合导线测量成果平面展示图45595045602545610045617545625045632545640045647
18、54565504566254567004567754568504569254570004570756实际坐标导线点绘制坐标最大间距:DX=386.1DY=612.2点序号XYXY13377095.44 456568.755 222.500667 92.725333323377481.53 456242.099 178.946533 144.20333333377407.96 455956.512 140.868283 134.39495343377338.03 456342.767 192.368933 125.0706853377181.66 456464.986 208.664773 10
19、4.22168663377234.96 456326.432 190.190935 111.32781873377095.44 456568.755 222.500667 92.725333383377481.53 456242.099 178.946533 144.20333393377481.53 456242.099 178.946533 144.203333103377481.53 456242.099 178.946533 144.203333113377481.53 456242.099 178.946533 144.203333123377481.53 456242.099 17
20、8.946533 144.203333133377481.53 456242.099 178.946533 144.203333143377481.53 456242.099 178.946533 144.203333153377481.53 456242.099 178.946533 144.203333163377481.53 456242.099 178.946533 144.203333173377481.53 456242.099 178.946533 144.203333183377481.53 456242.099 178.946533 144.203333193377481.5
21、3 456242.099 178.946533 144.203333203377481.53 456242.099 178.946533 144.203333213377481.53 456242.099 178.946533 144.203333223377481.53 456242.099 178.946533 144.203333233377481.53 456242.099 178.946533 144.203333457150457225457300457375457450457525Y(m)243377481.53 456242.099 178.946533 144.2033332
22、53377481.53 456242.099 178.946533 144.203333距离标注坐标点名标注坐标角度标注坐标点号标注名称距离标注名称角度XYXYXY222.500667 92.7253333CPII-12178.946533 144.203333 178.946533 144.203333CPII-1110.175453159.907408 139.299143 140.868283 134.394953 140.868283 134.394953JM-7S=294.909 13.9705481166.618608 129.732817 192.368933 125.07068
23、 192.368933 125.07068JM-8S=392.534 5.76141505200.516853 114.646183 208.664773 104.221686 208.664773 104.221686JM-9S=198.465 1.28952759199.427854 107.774752 190.190935 111.327818 190.190935 111.327818JM-10S=148.451 14.6295127206.345801 102.026576 222.500667 92.7253333 222.500667 92.7253333CPII-12S=27
24、9.617 14.1735435-50-50178.946533 144.203333-50-50CPII-11SA8-50-50-50-50-50-509SA9-50-50-50-50-50-5010SA10-50-50-50-50-50-5011SA11-50-50-50-50-50-5012SA12-50-50-50-50-50-5013SA13-50-50-50-50-50-5014SA14-50-50-50-50-50-5015SA15-50-50-50-50-50-5016SA16-50-50-50-50-50-5017SA17-50-50-50-50-50-5018SA18-50
25、-50-50-50-50-5019SA19-50-50-50-50-50-5020SA20-50-50-50-50-50-5021SA21-50-50-50-50-50-5022SA22-50-50-50-50-50-5023SA23-50-50-50-50-50-5024SA24-50-50-50-50-50-5025SA25角度标注名称角度圈方位角角度圈X坐标第1点第2点第3点第4点第5点第6点第1点第2点244-12-39.14.46028449 5.31274125 6.16519801 7.01765477 7.87011153 8.72256829 176.525559 176.8
26、83692335-17-35.41.74990765 2.92030155 4.09069545 5.26108934 6.43148324 7.60187714 143.328289 141.417006138-16-26.32.47816441 2.96083159 3.44349877 3.92616595 4.40883312 4.8915003 193.908487 192.81837930-56-55.2 5.07960101 5.18763222 5.29566343 5.40369464 5.51172585 5.61975706 206.331444 206.44182351
27、-06-29.92.09319771 3.3187969 4.54439609 5.76999528 6.99559447 8.22119366 192.357494 189.750239340-09-54.25.58097563 6.76837564 7.95577565 9.14317566 10.3305757 11.5179757 220.885901 223.666609A8000000-50-50A9000000-50-50A10000000-50-50A11000000-50-50A12000000-50-50A13000000-50-50A14000000-50-50A1500
28、0000-50-50A16000000-50-50A17000000-50-50A18000000-50-50A19000000-50-50A20000000-50-50A21000000-50-50A22000000-50-50A23000000-50-50A24000000-50-50A25000000-50-50第3点第4点第5点第6点178.652249 180.622017 181.446208 180.561299138.836049 138.735275 141.23767 143.289257191.625581 190.602625 189.983234 189.908927
29、206.578114 206.738738 206.921818 207.12522187.726129 188.963538 191.825082 192.524265224.987725 223.195405 220.533373 220.334108-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50角度圈X坐标-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50-50