CN101877020A - Method for drawing drilling track graph in AutoCAD by using VBA module - Google Patents
Method for drawing drilling track graph in AutoCAD by using VBA module Download PDFInfo
- Publication number
- CN101877020A CN101877020A CN2009102193440A CN200910219344A CN101877020A CN 101877020 A CN101877020 A CN 101877020A CN 2009102193440 A CN2009102193440 A CN 2009102193440A CN 200910219344 A CN200910219344 A CN 200910219344A CN 101877020 A CN101877020 A CN 101877020A
- Authority
- CN
- China
- Prior art keywords
- drilling
- autocad
- track
- graph
- excel
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Landscapes
- Earth Drilling (AREA)
Abstract
The invention relates to a method for drawing a drilling track graph in an AutoCAD by using a VBA module. At present, directional drilling under a coal mine mainly adopts gas drainage drilling, the initial design of the drilling is finished generally by combining a coal mine digging plane graph or a stratum section graph, the digging plane graph or the stratum section graph is drawn generally by adopting AutoCAD software, and an actually measured track and an actual track of the drilling are often compared and analyzed on site. The method comprises the following steps of: processing drilling track parameters by using Excel, then calling a calculation result of the Excel through a VBA module, finishing initial parameter and linear settings, and automatically finishing the drawing of the drilling track graph in the AutoCAD. The method quickly finishes the drawing of the actually measured drilling track graph in the AutoCAD by using the drilling track parameters obtained by measurement while drilling, can draw the actually measured track and the designed track in the same graph, and provides convenience for analyzing the control effect of the drilling track.
Description
Technical field
The present invention relates to a kind of VBA of utilization module and in AutoCAD, carry out the method for drawing drilling track graph, the processing of design and measured data can be used for holing, can be used as the submodule of drilling track data processing software, be used for carrying out the drafting of drilling track graph with synthetic at Auto CAD.
Technical background
Drilling measuring technology is with its unique technique advantage, not only obtained wideling popularize and using at petroleum drilling and non-excavation field, also progressively be generalized to the mine safety field in recent years, in coal field ground and the construction of down-hole coal bed gas (gas) extraction borehole, play more and more important effect, the drilling track graph that the drilling trajectory parameters that utilizes measurement while drilling to obtain is drawn, it is the important evidence of carrying out the drilling track analysis and instructing TRAJECTORY CONTROL, because directional drilling is compared with the directional drilling in non-excavation field with petroleum drilling under the coal mine, all different aspect construction characteristic and directional hole track statement custom, the drilling track data processing method of some petroleum drillings and non-excavation field maturation, and be not suitable for the processing of directional drilling track data under the coal mine, therefore, need the drilling track data processing method be studied in conjunction with directional drilling construction characteristics under the coal mine and drilling track describing method.
At present, directional drilling is many based on firedamp taking-out discharging drilling under the coal mine, the initial designs of boring is generally all finished in conjunction with colliery digging planimetric map or stratigraphic section, and digging planimetric map or stratigraphic section generally all adopt Auto CAD software to draw, the scene often need be analyzed the actual measurement track and the actual path of boring, the drilling trajectory parameters that needs a kind of method can utilize measurement while drilling to obtain is finished the drafting of boring actual measurement track figure apace in AutoCAD, can be with among same figure of being plotted in of actual measurement track and planned course, for the control effect of analyzing drilling track is provided convenience.
Summary of the invention
Technical matters solved by the invention provides a kind of method of can be used for holing design and measured data processing, carries out drawing drilling track graph by utilizing the VBA module in AutoCAD.
For solving above-mentioned technical matters, the technical scheme that the present invention takes:
Special character of the present invention is: the drilling trajectory parameters that at first utilizes Excel to finish is handled, and by the result of calculation of VBA module invokes Excel, finishes initial parameter and line style setting again, finishes the drafting of drilling track graph in AutoCAD automatically.
Above-mentioned method realizes by following steps:
(1), the foundation of drilling track coordinate parameters: set up the Excel worksheet, as the initial parameter name, calculating is distinguished the drift angle, is looked translation, upper and lower displacement, left and right displacement as the calculating parameter name with the degree of depth, inclination angle, position angle in the input field;
(2), the processing of coordinate parameters: the drilling track coordinate Calculation formula that will meet the formula substantive requirements of form that existing Excel instrument comprised inputs to the Excel worksheet that step (1) is set up, and Excel finishes the processing of coordinate parameters;
(3), the conversion of coordinate parameters and drafting: after opening AutoCAD, coordinate parameters after unlatching VBA module invokes is handled through step (2) converts the drawing command of AutoCAD to, and carry out initial parameter and line style setting, in AutoCAD, finish the drafting of drilling track graph automatically.
Compared with prior art, beneficial effect of the present invention:
The drilling trajectory parameters that the present invention utilizes measurement while drilling to obtain is finished the drafting of boring actual measurement track figure apace in AutoCAD, can be with among same figure of being plotted in of actual measurement track and planned course, for the control effect of analyzing drilling track is provided convenience.
Description of drawings
Fig. 1 is a workflow diagram of the present invention.
Embodiment
The present invention is described in detail below in conjunction with the drawings and specific embodiments.
The drilling trajectory parameters that the present invention at first utilizes Excel to finish is handled, and by the result of calculation of VBA module invokes Excel, finishes initial parameter and line style setting again, finishes the drafting of drilling track graph in AutoCAD automatically.
Referring to Fig. 1, realize by following steps:
(1), the foundation of drilling track coordinate parameters: set up the Excel worksheet, as the initial parameter name, calculating is distinguished the drift angle, is looked translation, upper and lower displacement, left and right displacement as the calculating parameter name with the degree of depth, inclination angle, position angle in the input field;
Set up Excel drilling track coordinate parameters calculation procedure worksheet.At first set up a new sheet, fill in gauge outfit (as: horizontal orientation boring calculation of parameter program), boring essential information (information such as unit in charge of construction, boring numbering, date), the relevant coordinate parameters information such as (initial parameter and calculating parameters) of drilling track, the initial parameter column is made as " input field ", and the row at calculating parameter place are made as " calculating the district ".The degree of depth, inclination angle, position angle are the initial parameter name, the drift angle, look translation, upper and lower displacement and left and right displacement as the calculating parameter name.
(2), the processing of coordinate parameters: the drilling track coordinate Calculation formula that will meet the formula substantive requirements of form that existing Excel instrument comprised inputs to the Excel worksheet that step (1) is set up, and Excel finishes the processing of coordinate parameters;
With the balanced tangential is the design that example is carried out horizontal orientation boring calculation of parameter program.At first at first row of " calculating the district ", promptly import among D8, E8, F8, the G8 " 0 ", acquiescence boring tapping point coordinate is (0,0,0); Begin to import the corresponding calculated formula from next line, formula at first should be imported equal sign (=), imports the formula content again, generally import formula after, that show in the cell is result after formula calculates, formula only is presented in the formula bar.
The drift angle: being meant and measuring the relative and clockwise differential seat angle in design position angle in position angle, is to be a convenient parameter of setting, that is: the drift angle=measurement position angle-design position angle specially of calculating;
Look translation: be meant the projection of drilling track horizontal shift on the vertical plane of design position line place, refer generally to coordinate X value;
Left and right displacement: being meant that measuring point arrives the distance of design position line place vertical guide, referring generally to coordinate Y value, is benchmark with the design position line, and right avertence is for just, and left avertence is to bear;
Upper and lower displacement: being meant the distance of measuring point to the surface level of tapping point place, referring generally to coordinate Z value, is benchmark with the surface level, goes up partially for just, down partially for bearing.
More than the corresponding basic information region parameter of each parameter and input field CALCULATION OF PARAMETERS formula as follows:
Drift angle: D9=B9-G2, wherein " G2 " representative design orientation values.
Look translation: E9=(A9-A8)/2* (COS (C9*PI ()/180) * COS (D9*PI ()/180)+COS (C8*PI ()/180) * COS (D8*PI ()/180))+E8;
Left and right displacement: F9=(A9-A8)/2* (COS (C9*PI ()/180) * SIN (D9*PI ()/180)+COS (C8*PI ()/180) * SIN (D8*PI ()/180))+F8;
Upper and lower displacement: G9=(A9-A8)/2* (SIN (C9*PI ()/180)+SIN (C8*PI ()/180))+G8.
After the 9th row formula input is finished, utilize Excel " recursion copy function " that computing formula is copied to following each row.
After the computing formula of all calculating parameters is all set up, the measurement data that will be kept in other texts (as word or txt document) copies in the corresponding ordered series of numbers of the Excel drilling trajectory parameters calculation procedure of having set up, just can directly obtain the result of calculation of correlation parameter.
(3), the conversion of coordinate parameters and drafting: after opening AutoCAD, coordinate parameters after unlatching VBA module invokes is handled through step (2) converts the drawing command of AutoCAD to, and carry out initial parameter and line style setting, in AutoCAD, finish the drafting of drilling track graph automatically.
Claims (2)
1. method of utilizing the VBA module in AutoCAD, to carry out drawing drilling track graph, it is characterized in that: the drilling trajectory parameters that at first utilizes Excel to finish is handled, pass through the result of calculation of VBA module invokes Excel again, finish initial parameter and line style setting, in AutoCAD, finish the drafting of drilling track graph automatically.
2. a kind of VBA of utilization module according to claim 1 is carried out the method for drawing drilling track graph in AutoCAD, it is characterized in that: realize by following steps:
(1), the foundation of drilling track coordinate parameters: set up the Excel worksheet, as the initial parameter name, calculating is distinguished the drift angle, is looked translation, upper and lower displacement, left and right displacement as the calculating parameter name with the degree of depth, inclination angle, position angle in the input field;
(2), the processing of coordinate parameters: the drilling track coordinate Calculation formula that will meet the formula substantive requirements of form that existing Excel instrument comprised inputs to the Excel worksheet that step (1) is set up, and Excel finishes the processing of coordinate parameters;
(3), the conversion of coordinate parameters and drafting: after opening AutoCAD, coordinate parameters after unlatching VBA module invokes is handled through step (2) converts the drawing command of AutoCAD to, and carry out initial parameter and line style setting, in AutoCAD, finish the drafting of drilling track graph automatically.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2009102193440A CN101877020A (en) | 2009-12-04 | 2009-12-04 | Method for drawing drilling track graph in AutoCAD by using VBA module |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2009102193440A CN101877020A (en) | 2009-12-04 | 2009-12-04 | Method for drawing drilling track graph in AutoCAD by using VBA module |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101877020A true CN101877020A (en) | 2010-11-03 |
Family
ID=43019575
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2009102193440A Pending CN101877020A (en) | 2009-12-04 | 2009-12-04 | Method for drawing drilling track graph in AutoCAD by using VBA module |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101877020A (en) |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102831278A (en) * | 2012-09-06 | 2012-12-19 | 深圳市常兴技术股份有限公司 | Interactive automatic mapping system based on CAD (computer-aided design), mapping method and construction method of system |
| CN103678743A (en) * | 2012-09-17 | 2014-03-26 | 南车青岛四方机车车辆股份有限公司 | Subway limit drawing method |
| CN103838900A (en) * | 2012-11-26 | 2014-06-04 | 北京华大九天软件有限公司 | Automatic generation method for sub-pixel hole graph |
| CN104156285A (en) * | 2014-08-28 | 2014-11-19 | 同济大学 | Partition fuel cell experimental data processing method and system based on VBA module |
| CN105156097A (en) * | 2015-07-06 | 2015-12-16 | 中煤科工集团西安研究院有限公司 | Method for processing hole drilling track measurement data |
| CN106599477A (en) * | 2016-12-15 | 2017-04-26 | 广州华森建筑与工程设计顾问有限公司 | revit three-dimensional platform-based pile foundation automatic generation and three-dimensional calculation method |
| CN107391477A (en) * | 2017-07-29 | 2017-11-24 | 奥士康科技股份有限公司 | MI drilling table automated production methods |
| CN107679028A (en) * | 2017-10-17 | 2018-02-09 | 中铁西北科学研究院有限公司 | GPR layer data file process and the method for drawing |
| CN107748814A (en) * | 2017-10-13 | 2018-03-02 | 中国煤炭地质总局七三勘探队 | The boring method on plan |
| CN111241798A (en) * | 2020-01-08 | 2020-06-05 | 山西晋城无烟煤矿业集团有限责任公司 | Chart analysis method for outburst prevention prediction exploration hole |
| CN111488328A (en) * | 2019-12-17 | 2020-08-04 | 核工业二四三大队 | Automatic drawing method for uranium ore geological drilling rock core geophysical prospecting recording curve |
| CN112307733A (en) * | 2020-10-15 | 2021-02-02 | 平和县鑫泰德远矿业有限公司 | Pyrophyllite ore stacking method convenient for ore blending |
| CN112668067A (en) * | 2020-12-11 | 2021-04-16 | 武汉航空仪表有限责任公司 | Manufacturing system and manufacturing method of non-linear dial of pressure gauge |
| CN113515791A (en) * | 2021-08-03 | 2021-10-19 | 贵州盘江精煤股份有限公司 | Method for efficiently and quickly loading picture in drilling |
| CN114970935A (en) * | 2022-03-01 | 2022-08-30 | 山西蓝焰煤层气工程研究有限责任公司 | Resform-based coal bed gas horizontal well fracturing layer section optimization method |
-
2009
- 2009-12-04 CN CN2009102193440A patent/CN101877020A/en active Pending
Cited By (19)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102831278A (en) * | 2012-09-06 | 2012-12-19 | 深圳市常兴技术股份有限公司 | Interactive automatic mapping system based on CAD (computer-aided design), mapping method and construction method of system |
| CN103678743A (en) * | 2012-09-17 | 2014-03-26 | 南车青岛四方机车车辆股份有限公司 | Subway limit drawing method |
| CN103838900A (en) * | 2012-11-26 | 2014-06-04 | 北京华大九天软件有限公司 | Automatic generation method for sub-pixel hole graph |
| CN104156285B (en) * | 2014-08-28 | 2018-07-06 | 同济大学 | Section fuel cell Processing for Data Analysis in Physics and system based on VBA modules |
| CN104156285A (en) * | 2014-08-28 | 2014-11-19 | 同济大学 | Partition fuel cell experimental data processing method and system based on VBA module |
| CN105156097A (en) * | 2015-07-06 | 2015-12-16 | 中煤科工集团西安研究院有限公司 | Method for processing hole drilling track measurement data |
| CN106599477A (en) * | 2016-12-15 | 2017-04-26 | 广州华森建筑与工程设计顾问有限公司 | revit three-dimensional platform-based pile foundation automatic generation and three-dimensional calculation method |
| CN106599477B (en) * | 2016-12-15 | 2022-05-27 | 广州华森建筑与工程设计顾问有限公司 | Method for automatically generating and three-dimensionally calculating pile foundation based on revit three-dimensional platform |
| CN107391477A (en) * | 2017-07-29 | 2017-11-24 | 奥士康科技股份有限公司 | MI drilling table automated production methods |
| CN107748814A (en) * | 2017-10-13 | 2018-03-02 | 中国煤炭地质总局七三勘探队 | The boring method on plan |
| CN107679028A (en) * | 2017-10-17 | 2018-02-09 | 中铁西北科学研究院有限公司 | GPR layer data file process and the method for drawing |
| CN111488328A (en) * | 2019-12-17 | 2020-08-04 | 核工业二四三大队 | Automatic drawing method for uranium ore geological drilling rock core geophysical prospecting recording curve |
| CN111488328B (en) * | 2019-12-17 | 2023-06-13 | 核工业二四三大队 | Automatic drawing method for uranium ore geological drilling core geophysical prospecting and recording curve |
| CN111241798A (en) * | 2020-01-08 | 2020-06-05 | 山西晋城无烟煤矿业集团有限责任公司 | Chart analysis method for outburst prevention prediction exploration hole |
| CN112307733A (en) * | 2020-10-15 | 2021-02-02 | 平和县鑫泰德远矿业有限公司 | Pyrophyllite ore stacking method convenient for ore blending |
| CN112668067A (en) * | 2020-12-11 | 2021-04-16 | 武汉航空仪表有限责任公司 | Manufacturing system and manufacturing method of non-linear dial of pressure gauge |
| CN112668067B (en) * | 2020-12-11 | 2024-05-24 | 武汉航空仪表有限责任公司 | System and method for manufacturing nonlinear dial of pressure gauge |
| CN113515791A (en) * | 2021-08-03 | 2021-10-19 | 贵州盘江精煤股份有限公司 | Method for efficiently and quickly loading picture in drilling |
| CN114970935A (en) * | 2022-03-01 | 2022-08-30 | 山西蓝焰煤层气工程研究有限责任公司 | Resform-based coal bed gas horizontal well fracturing layer section optimization method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101877020A (en) | Method for drawing drilling track graph in AutoCAD by using VBA module | |
| Zhou et al. | Mechanism of mining subsidence in coal mining area with thick alluvium soil in China | |
| CN111750822A (en) | Coal mining induced overlying strata and surface subsidence collaborative dynamic prediction method | |
| CN101387198A (en) | Monitoring method for drilled wellbore trajectories | |
| CN109933867A (en) | A kind of geotechnical engineering investigation scheme dynamic optimization method | |
| CN103150421A (en) | Method for simultaneously determining pile position and critical depth of anti-slide pile by using displacement monitoring | |
| CN104809266A (en) | Spline based accurate predicating method for face coal seam occurrence condition | |
| CN101719176A (en) | Method for processing drilling trajectory parameters and drawing graphs by utilizing Excel | |
| CN102953679B (en) | Borehole design method | |
| CN108197421B (en) | Quantitative evaluation method for beneficial zone of joint development of dense gas and coal bed gas | |
| CN102346917A (en) | Method and system for automatically drawing engineering geologic histogram | |
| CN106709988A (en) | Construction method of engineering geological section map | |
| CN108121009A (en) | Development late stage complex fault block velocity-variant depth mapping method | |
| CN104989330A (en) | Coalbed gas recovery method | |
| CN113375753A (en) | Method for monitoring and analyzing influence of coal mine fully mechanized mining face mining on underground water | |
| CN105808934B (en) | Earth's surface damage range and disturbance number determine method under mutil-coal seam mining | |
| Ma et al. | Study on feature storage and storage capacity of underground reservoir based on GMS in MHS area of Beijing, China | |
| CN102465699A (en) | Carbonate rock reservoir prediction method | |
| CN111666913A (en) | Method for delineating coal resource coverage under three times by using high-definition satellite remote sensing image | |
| Wang et al. | Numerical simulation research on well pattern optimization in high–dip angle coal seams: a case of Baiyanghe Block | |
| CN104251135A (en) | Highly-deviated well space in-place method | |
| Xu et al. | CMM emission laws and the sub-source drainage methods in coal mining: a case study in Yuwu coal mine, Northeastern Qinshui basin, China | |
| CN103267984B (en) | A kind of method of discrimination of ultra-close coal seam/group | |
| CN103206216B (en) | Underground working face mining sequence optimization method for prolonging service time of surface land | |
| CN113658335A (en) | Method for creating complex geological model of karst development area |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Open date: 20101103 |