两井定向无定向附和导线

1、两井定向-无定向附合导线计算任务名称：当矿区有两个立井，且两井之间在定向水平上有巷道相通并能进行测量时，就要采用两井定向。任务描述：两井定向就是在两井筒中各挂一根垂球线（见图），通过地面和井下 导线将它们连接起来，从而把地面坐标系统中的平面坐标和方向传递 到井下。两井定向的外业测量与一井定向类似。也包括投点、地面和井 下连接测量，只是两井定向时每 个井筒只悬挂一根钢丝，这使投 点工作更为方便且缩短了占用井筒的时间。 同时，两井定向与一井定 向相比，两钢丝间的距离大大增加，使投向误差明显减小。这是两井 定向的最大优点。由于两井定向时，两根钢丝间不能直接通视，而是通过导线连接起来。 因此，在连接测

2、量时必须测出井上、井下导线各边的边长及其连接水 平角，在内业计算时必须采用假定坐标系。两井定向的数学公式及计算方法两井定向是在两个井筒内各投下一个点，它们的坐标是通过地面连接 导线测设后计算出来的。而到了井下，它们之间是不能通视的，这样 井下连接导线 A 1 234B'就形成一条定向符合导线。具 体计算如下：1）根据地面连接测量的成果，按照导线的计算方法，计算出地面两钢丝点A、B的平面坐标（Xa, ya）、（Xb, yB）°2）计算两钢丝点A、B的连线在地面坐标系统中的方位角和边长：tan生二二 Dab - . ：x2 一 y2xE_x査3）以井下导线起始边A 1为x轴，A点

3、为坐标原点建立假定坐标系，计算井下导线各连接点在此假定坐标系中的平面坐标，设B'点的假定坐标为（Xb，b'）。4） 计算AB连线在假定坐标系中的方位角a ab ' 'ab二arcta二x'bx'a X'b5） 计算井下起始边在地面坐标系统系统中的方位角:月八AB - 'AB6）然后根据A1和A点的地面坐标计算出井下导线各点在地面坐标系统中的坐标和方位角，最后算得悬线垂线B的坐标。两井定向的EXCE编程思路1napQrsruVhxifz123j1宦向&<fc<360ViVvXifC n115-333IX 0M7展

4、L 473-0. 005W9924, 7792B0eM4.0266s45h507993.5563A205. 3122765203 18 443.屈呂脯g15. S(312-14.5310.0006-5. 3050OT6&18& 2& 20- 2EjJ9953. 127SIMM 1如图:N6输入已知观测左角度分秒数值，S5:输入起始点到1号点的导线边长，X3 Y3为已知终点坐标，X4、Y4为已知起始点坐标。黄色区域为输出1号点坐标结果。A列-L列为假定坐标系下的计算过程，如图kCDGHIJKL1假罡生标支导线廿秆2点玄一观鶴左垢假方悅甬边长ATXTUflL33e寸&

5、;D, 0000. OTO0(30 00 0015.931215. 9310.00D1朋曲2d- 2S6.4722777815, 931CLOW两井定向EXCE编程EKQP4艮3TXY1丸定向2方垃 販cCMX 販方益站AXXY3E113.3384L 982Z4250.爪HK005nw5O&044- 0255qA609967. 757&期磁555E首5203.3122765203 18 443.吕4關&31&. 9312-14. &刘0.000&-6. 3050006§1畸阕也2SM953.127O79S7. 252171D9.7845

6、543lKi. 7345543血47的LS1610EJ7. 9229-1&.S360.001335. 6S4-0. 0015E2馬5 03：閒应Z9250B022L 9342§81 93322QMS4Le03220M84験阖1.船幻別13.8807L22&° 000513. S2«-0. 00C410311 & 08 55,2SOQil. 51950BOS&. 760辛112L 0TSS32121,0716332121 M 3SCi. 36785117. 213116-02&. 190-0. 000712E328 11 54

7、.3609957. 53150&34Z. 9504131A3.269193-2i&'Ei. 2&91932啖 1& 092. B5430&19.6337-1SLEB9山 00075.6-56-0. 0008145201 31 M.S309953. £925GH4&. 5C-LbIF190.301S654190.3016654190 48 鄭3.33011T13,7574-1514山 000&-2. 57B-0. 00C41&&60-J3Z4. T巧17Xatju =ISO 2B OS130. fll759

8、6-0. OddZ-0. 00假口JT =23? OB 1ELE-1M. &3772SS130. QI 7222222?&20&DOS2S7.1tW9aE?N列绿色区域为输入观测左角度分秒数值N17: =TEXT(P1/24,"h mm ss ”)N18: =P18-B1807: =IF(P5-180+C6>=360,P5-180+C6-360,P5-180+C6)09: =IF(P7-180+C8>=360,P7-180+C8-360,P7-180+C8)O11: =IF(P9-180+C10>=360,P9-180+C10-360,P9-

9、180+C10)O13: =IF(P11-180+C12>=360,P11-180+C12-360,P11-180+C12)O15: =IF(P13-180+C14>=360,P13-180+C14-360,P13-180+C14)P5: =IF(N18<0,N18+360,N18)P7: =IF(O7<0,O7+360,O7)P9: =IF(O9<0,O9+360,O9)P11: =IF(O11<0,O11+360,O11)P13: =IF(O13<0,O13+360,O13)P15: =IF(O15<0,O15+360,O15)P17: =I

10、F(R18*180/PI()<0,R18*180/PI()+360,R18*180/PI()P18: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(N17," ",":")," ",":")," ",)*24Q5: =TEXT(P/24,"h mm ss ")Q7: =TEXT(P/24,"h mm ss ")Q9: =TEXT(P924,"h mm ss ")Q11： =TEXT(P11/24,"

11、h mm ss ")Q13： =TEXT(P1/324,"h mm ss ")Q15： =TEXT(P15/24,"h mm ss ")R5： =P5*PI()/180R7： =P7*PI()/180R9： =P9*PI()/180R11：=P11*PI()/180R13：=P13*PI()/180R15：=P15*PI()/180 R18：=ATAN2(X3-X4,Y3-Y4)S3： =SUM(S4:S16)S列中绿色区域为已测边长T3： =SUM(T4:T16)T5：=S5*COS(R5) T7：=S7*COS(R7) T9： =S9*CO

12、S(R9)T11：=S11*COS(R11) T13：=S13*COS(R13) T15：=S15*COS(R15) T17：=T3-X3+X4 T18：=V3-Y3+Y4U3：=SUM(U4:U16)U5：=-$T$17/$S$3*S5U7：=-$T$17/$S$3*S7U9：=-$T$17/$S$3*S9U11：=-$T$17/$S$3*S11U13：=-$T$17/$S$3*S13U15：=-$T$17/$S$3*S15V3：=SUM(V4:V16)V5：=S5*SIN(R5)V7：=S7*SIN(R7)V9：=S9*SIN(R9)V11：=S11*SIN(R11)V13：=S13*SI

13、N(R13)V15：=S15*SIN(R15)V17: =(T17A2+T18A2)A0.5V18： =S3/V17W3 : =SUM(W5:W15)W5: =-$T$18/$S$3*S5W7: =-$T$18/$S$3*S7W9 : =-$T$18/$S$3*S9W11 : =-$T$18/$S$3*S11W13: =-$T$18/$S$3*S13W15: =-$T$18/$S$3*S15X3、Y3,为输入已知终点坐标；X4、Y4,为输入已知起点坐标。X6: =X4+T5+U5X8: =X6+T7+U7X10: =X8+T9+U9X12: =X10+T11+U11X14: =X12+T13+

14、U13X16: =X14+T15+U15X17: =IF(B18<0,TEXT(B18+360)/4,"h mm ss ”),TEXT(B18/24,"h mm ss ")X18: =IF(D17*180/PI()<0,D17*180/PI()+360,D17*180/PI()Y6: =Y4+V5+W5Y8: =Y6+V7+W7Y10: =Y8+V9+W9Y12: =Y10+V11+W11Y14: =Y12+V13+W13Y16: =Y14+V15+W15表二AB-|cIDFQIJK1 L12总若驚度边长AXYXy3118. 3384冉0. «

15、;NO.QOQSD0000 0001&.9312IE.如 1OLMD魅1S6 23 2D. 286. 722777815. 931O.OODT2&B. 7227702E 204. &50S1&37. §229-2. 333-騎-S518z155 OB 55. Z155.1867IX 598-37.匪 1g241.魄舶4狎24.L 20442413T 1515.3307-6.699-11213103116 OB 35. 211&.W11L17. 000-50.。開117?., 7640556ITT4B 513, KJ25&617,2131

16、0,67212432S 11 34.3328.1211-m 200T 虫 3 9013325.痂91阴S2S5T 256.融QE116.痂-ia蒯1G5ZQ1 31 56. 9SQL 53Z4792民刚-W. S©15紂亿43859347.鸵 938S929 226. 9H呂34IX T5T413.431-2. 9801&B1* 499=3.3631?愠曲方拉28? 06 IS-1.釘盟強TQ6IB28L 1042i457B6:=N6;B8: =N8;B10:=N10; B12=N12;B14:=N14;B17: =IF(B18<0,TEXT(B18+36024,&qu

17、ot;h mm ss ”),TEXT(B1824,"h mm ss ")B18: =IF(D17*180/PI()<0,D17*180/PI()+360,D17*180/PI()C6: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(N6," ",":")," ",":")," ",)*24C8: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(N8," ",":")," &quo

18、t;,":")," ",)*24C10: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(N10," ",":")," ",":")," ",)*24C12: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(N12," ",":")," ",":")," ",)*24C14: =SUBSTITUTE(SUBSTITUT

19、E(SUBSTITUTE(N14," ",":")," ",":")," ",)*24D5: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(F5," ",":")," ",":")," ",)*24D7: =IF(D5-180+C6<0,D5-180+C6+360,D5-180+C6)D9: =IF(D7-180+C8<0,D7-180+C8+360,D7-180

20、+C8)D11: =IF(D9-180+C10<0,D9-180+C10+360,D9-180+C10)D13: =IF(D11-180+C12<0,D11-180+C12+360,D11-180+C12)D15: =IF(D13-180+C14<0,D13-180+C14+360,D13-180+C14)D17: =ATAN2(K16-0,L16-0)E5: =IF(D5>=360,D5-360,D5)E7: =IF(D7>=360,D7-360,D7)E9: =IF(D9>=360,D9-360,D9)E11: =IF(D11>=360,D11-3

21、60,D11)E13: =IF(D13>=360,D13-360,D13)E15: =IF(D15>=360,D15-360,D15)F5: 0 00 00F7: =TEXT(D/24,"h mm ss ")F9: =TEXT(D924,"h mm ss ")F11: =TEXT(D1124,"h mm ss ")F13: =TEXT(D1/24,"h mm ss ")F15: =TEXT(D1/24,"h mm ss ")G5: =D5*PI()/180G7: =E7*PI()/1

22、80G9: =E9*PI()/180G11: =E11*PI()/180G13: =E13*PI()/180G15: =E15*PI()/180H3: =S3; H5: =S5; H7: =S7; H9: =S9; H11 : =S11; H13: =S13; H15: =S15I5: =S5*COS(G5)I7: =S7*COS(G7)I9: =S9*COS(G9)I11 : =S11*COS(G11)I13 : =S13*COS(G13)I15 : =S15*COS(G15)J5: =S5*SIN(G5)J7: =S7*SIN(G7)J9: =S9*SIN(G9)J11: =S11*SIN

23、(G11)J13: =S13*SIN(G13)J15: =S15*SIN(G15)K4:0.000;K6:=K4+I5;K8:=K6+I7;K10: =K8+I9;K12: =K10+I11; K14: =K12+I13; K16: =K14+I15L4:=0.000;L6:=L4+J5;L8:=L6+J7;L10: =L8+J9L12: =L10+J11; L14: =L12+J13; L16: =L14+J15最终完成两井定向 EXCEL编程1N0PQRs7uV*聲YZ:5定fhl奥计口2戊古視雷左鱼<360«-fe<360方firn边£XVxYVyKY占r3匸113. 338-41SKCL 00 宜250. 4?3删皤札T7S2SO航HQ. 0255B4 I A6M&6T.7E7560fT99X 556B%520