CN109543164A - The method of Autocad combination Excel generation log sheet - Google Patents
The method of Autocad combination Excel generation log sheet Download PDFInfo
- Publication number
- CN109543164A CN109543164A CN201811345303.1A CN201811345303A CN109543164A CN 109543164 A CN109543164 A CN 109543164A CN 201811345303 A CN201811345303 A CN 201811345303A CN 109543164 A CN109543164 A CN 109543164A
- Authority
- CN
- China
- Prior art keywords
- data
- excel
- log sheet
- autocad
- cad
- 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.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
- G06T11/00—2D [Two Dimensional] image generation
- G06T11/20—Drawing from basic elements, e.g. lines or circles
- G06T11/206—Drawing of charts or graphs
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02A—TECHNOLOGIES FOR ADAPTATION TO CLIMATE CHANGE
- Y02A90/00—Technologies having an indirect contribution to adaptation to climate change
- Y02A90/30—Assessment of water resources
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- General Engineering & Computer Science (AREA)
- Earth Drilling (AREA)
- Investigation Of Foundation Soil And Reinforcement Of Foundation Soil By Compacting Or Drainage (AREA)
Abstract
The present invention provides the methods that Autocad combination Excel generates log sheet, specifically comprise the following steps: to copy to the pattern in geologic legend library in the Support file of CAD installation directory；The initial data of drilling is inputted in the Input table of Excel；Data in previous step are transformed into Output table；Data in previous step are copied in CAD command bar；Cheng Tu.The invention has the advantages that: the corresponding positions for the Input table that water level, consumption, geological record achievement, strata division, hole deviation data etc. need to only be inputted to Excel template, and it is transformed into Output table, column data each in Output table duplication is pasted onto CAD command bar, CAD will automatically generate log sheet, figure head, title block, hole structure and well logging achievement are improved, log sheet is finally completed；The log sheet accuracy generated using this method is high, can preferably meet national standard specification.
Description
Technical field
The invention belongs to software draughtsmanship fields, generate drilling column more particularly, to a kind of Autocad combination Excel
The method of figure.
Background technique
Log sheet is most basic geological map, traditional geological map mainly by manual drawing, it is time-consuming, laborious,
Precision is low.And with the development of industrial technology, system higher and higher to geological map required precision, Autocad etc. powerful
Figure software is widely used, and also develops the columnar software of some generations drillings, plug-in unit etc. on this basis, but all has one
Fixed problem, it is easy to so that the figure generated does not meet China's professional standard.
Summary of the invention
In view of this, the present invention is directed to propose a kind of Autocad combination Excel generate log sheet method, with solution
The certainly shortcoming of the above problem.
In order to achieve the above objectives, the technical scheme of the present invention is realized as follows:
The method that Autocad combination Excel generates log sheet, specifically comprises the following steps:
A. the pattern in geologic legend library is copied in the Support file of CAD installation directory；
B. the initial data of drilling is inputted in the Input table of Excel；
C. the data in step B are transformed into Output table；
D. the data of step C are copied in CAD command bar；
E. at figure.
Further, in the step B, the input data in Excel template Input table, including consumption, water level,
Matter edits and records achievement, strata division, hole deviation data, in Input table MAX disappear (consumption maximum value) and MAX water (and water level is maximum
Value) at find out the value of its neighbouring 3 multiple, for example, water level is 17.5, then 3 multiple is 18；Consumption is 3.1, then 3 times
Number is 3.3, then corresponding input MAX disappear in the cell of MAX water.
Further, in the step C, the data in Input table are by Data1, Data2, Data3, Data4, Data5 tune
With Output table recalls the data automatically generated in Data1, Data2, Data3, Data4, Data5, table, figure head and column
The picture order of shape；
Wherein, the data of water level and consumption in Input table are called automatically in Data1 table, and generate water level picture order；
Automatically geological record achievement information in Input table, including sequence number, lithology, petrographic description, hole depth, layer are called in Data2 table
Thickness adopts long, taking rate and inclination angle；Legend library call instruction in Data6 carries out very thick and very thick accumulative calculating automatically, and raw
It draws and orders at data, table, figure head and pseudo- thick small column；Automatically strata division information in Input table is called in Data3 table,
Including ground layer name, symbol and depth, and generate stratum picture order；It is called automatically in Data4 table very thick, true in Data2
Thick cumulative data, the legend library call instruction in Data6, and generate very thick small column and draw order；It is called automatically in Data5 table
The data of hole deviation data in Input table, including hole depth, zenith angle and azimuth, and generate the picture life of hole deviation data and table
It enables；Data6 table is the call instruction of legend library；
Output table calls the data automatically generated in Data1, Data2, Data3, Data4, Data5, table, figure automatically
Head and the order of columnar picture.
Further, in the step D, each column data duplication in Excel in Output table is pasted onto CAD order
In column, CAD will automatically generate geotechnical boring column corresponding to each single item.
Further, figure head, title block, water level, consumption scale bar, drilling are worked out according to drilling situation in the step E
Structure, and well logging achievement is scaled to same ratio duplication and pastes log sheet corresponding position, complete log sheet.
Compared with the existing technology, the method that Autocad combination Excel of the present invention generates log sheet have with
Lower advantage:
Only water level, consumption, geological record achievement, strata division, hole deviation data etc. need to be inputted Excel template
The corresponding position of Input table, and be transformed into Output table, column data each in Output table duplication is pasted onto CAD order
In column, CAD will automatically generate log sheet, improve figure head, title block, hole structure and well logging achievement, be finally completed drilling
Histogram.The log sheet accuracy generated using this method is high, can preferably meet national standard specification.
Detailed description of the invention
The attached drawing for constituting a part of the invention is used to provide further understanding of the present invention, schematic reality of the invention
It applies example and its explanation is used to explain the present invention, do not constitute improper limitations of the present invention.In the accompanying drawings:
Fig. 1 is the flow chart for the method that Autocad combination Excel described in the embodiment of the present invention generates log sheet；
Fig. 2 is the data content that Input table described in the embodiment of the present invention need to input；
Fig. 3 is the partial data content of Output table described in the embodiment of the present invention；
Fig. 4 is that CAD generates geotechnical boring histogram corresponding to each item data；
Fig. 5 is that CAD generates final log sheet；
Fig. 6 is the enlarged drawing of part A in Fig. 5；
Fig. 7 is the enlarged drawing of part B in Fig. 5.
Specific embodiment
It should be noted that in the absence of conflict, the feature in embodiment and embodiment in the present invention can phase
Mutually combination.
The present invention will be described in detail below with reference to the accompanying drawings and embodiments.
As shown in Figure 1, the method that Autocad combination Excel generates log sheet, specifically comprises the following steps:
A. the pattern in geologic legend library is copied in the Support file of CAD installation directory, this is to generate drilling
Columnar necessary file；
B. the initial data of drilling is inputted in the Input table of Excel；
C. the data in step B are transformed into Output table；
D. the data of step C are copied in CAD command bar；
E. at figure.
In the step B, the input data in Excel template Input table, as shown in Fig. 2, include consumption, water level,
Matter edits and records achievement, strata division, hole deviation data, and MAX disappears and value that 3 multiple near its is found out at MAX water in Input table,
For example, water level is 17.5, then 3 multiple is 18；Consumption is 3.1, then 3 multiple is 3.3, then corresponding input MAX disappear and
In the cell of MAX water.
In the step C, the data in Input table are called by Data1, Data2, Data3, Data4, Data5, Output
Table recalls the data automatically generated in Data1, Data2, Data3, Data4, Data5, table, figure head and columnar picture life
It enables；
Wherein, the data of water level and consumption in Input table are called automatically in Data1 table, and generate water level picture order；
Automatically geological record achievement information in Input table, including sequence number, lithology, petrographic description, hole depth, layer are called in Data2 table
Thickness adopts long, taking rate and inclination angle；Legend library call instruction in Data6 carries out very thick and very thick accumulative calculating automatically, and raw
It draws and orders at data, table, figure head and pseudo- thick small column；Automatically strata division information in Input table is called in Data3 table,
Including ground layer name, symbol and depth, and generate stratum picture order；It is called automatically in Data4 table very thick, true in Data2
Thick cumulative data, the legend library call instruction in Data6, and generate very thick small column and draw order；It is called automatically in Data5 table
The data of hole deviation data in Input table, including hole depth, zenith angle and azimuth, and generate the picture life of hole deviation data and table
It enables；Data6 table is the call instruction of legend library；
Output table calls the data automatically generated in Data1, Data2, Data3, Data4, Data5, table, figure automatically
Head and columnar pictures order, the every column data finally generated in Output table be respectively figure head, consumption, water level, serial number,
Rock title, rock description, tired thickness, thickness, adopt length, taking rate, inclination angle, it is very thick, very thickness add up, pillar serial number, pillar, stratum
Title, hole deviation data, the information of very thick pillar, the partial table content being illustrated in figure 3 in Output table.
In the step D, each column data duplication in Excel in Output table is pasted onto CAD command bar, CAD
Geotechnical boring column corresponding to each single item will be automatically generated, as shown in Figure 4.
Figure head, title block, water level, consumption scale bar, hole structure are worked out according to drilling situation in the step E, and will
Well logging achievement is scaled to same ratio duplication and pastes log sheet corresponding position, log sheet is completed, such as Fig. 5 to Fig. 7
It is shown.
Water level, consumption, geological record achievement, strata division, hole deviation data etc. need to only be inputted Excel template by the present invention
Input table corresponding position, and be transformed into Output table, column data each in Output table duplication be pasted onto CAD life
It enables in column, CAD will automatically generate log sheet, improve figure head, title block, hole structure and well logging achievement, be finally completed brill
Hole histogram.
The foregoing is merely illustrative of the preferred embodiments of the present invention, is not intended to limit the invention, all in essence of the invention
Within mind and principle, any modification, equivalent replacement, improvement and so on be should all be included in the protection scope of the present invention.
Claims (6)
- The method of 1.Autocad combination Excel generation log sheet, which is characterized in that specifically comprise the following steps:A. the pattern in geologic legend library is copied in the Support file of CAD installation directory；B. the initial data of drilling is inputted in the Input table of Excel；C. the data in step B are transformed into Output table；D. the data of step C are copied in CAD command bar；E. at figure.
- 2. the method that Autocad combination Excel according to claim 1 generates log sheet, it is characterised in that: described In step B, the input data in the Input table of Excel template, including consumption, water level, geological record achievement, strata division, Hole deviation data inputs the value of 3 multiple near its in Input table at consumption maximum value and water level maximum value.
- 3. the method that Autocad combination Excel according to claim 2 generates log sheet, it is characterised in that: described In step C, the data in Input table are called by Data1, Data2, Data3, Data4, Data5, and Output table recalls Data, table, figure head and the order of columnar picture automatically generated in Data1, Data2, Data3, Data4, Data5.
- 4. the method that Autocad combination Excel according to claim 3 generates log sheet, it is characterised in that: Automatically the data of water level and consumption in Input table are called in Data1 table, and generate water level picture order；It is automatic in Data2 table It calls geological record achievement information in Input table, including sequence number, lithology, petrographic description, hole depth, thickness, adopts long, taking rate The inclination angle and；Legend library call instruction in Data6 carries out very thick and very thick accumulative calculating automatically, and generates data, table, figure Head and pseudo- thick small column are drawn and are ordered；Automatically strata division information in Input table, including ground layer name, symbol are called in Data3 table Number and depth, and generate stratum draw order；Automatically very thick, the very thick cumulative data in Data2, Data6 are called in Data4 table In the call instruction of legend library, and generate very thick small column and draw order；Call hole deviation in Input table to provide in Data5 table automatically The data of material, including hole depth, zenith angle and azimuth, and generate the picture order of hole deviation data and table；Data6 table is legend Library call instruction.
- 5. the method that Autocad combination Excel according to claim 1 generates log sheet, it is characterised in that: described In step D, each column data duplication in Excel in Output table is pasted onto CAD command bar, CAD will be automatically generated Geotechnical boring column corresponding to each single item.
- 6. the method that Autocad combination Excel according to claim 1 generates log sheet, it is characterised in that: described Figure head, title block, water level, consumption scale bar, hole structure are worked out according to drilling situation in step E, and will well logging achievement scaling Log sheet corresponding position is pasted at same ratio duplication, completes log sheet.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811345303.1A CN109543164B (en) | 2018-11-13 | 2018-11-13 | Method for generating drilling histogram by combining Autocad with Excel |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811345303.1A CN109543164B (en) | 2018-11-13 | 2018-11-13 | Method for generating drilling histogram by combining Autocad with Excel |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109543164A true CN109543164A (en) | 2019-03-29 |
| CN109543164B CN109543164B (en) | 2023-07-18 |
Family
ID=65846956
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811345303.1A Active CN109543164B (en) | 2018-11-13 | 2018-11-13 | Method for generating drilling histogram by combining Autocad with Excel |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109543164B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111159862A (en) * | 2019-12-17 | 2020-05-15 | 核工业二四三大队 | Electronic design and compiling method for uranium ore drilling design instruction |
| CN112287650A (en) * | 2020-10-23 | 2021-01-29 | 中国石油天然气集团有限公司 | Intelligent generation method, system and device for well logging interpretation report |
| CN112861508A (en) * | 2021-01-12 | 2021-05-28 | 中国石油天然气集团有限公司 | Standardization method and system for logging discrete data |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070156340A1 (en) * | 2005-12-29 | 2007-07-05 | Schlumberger Technology Corporation | Method to visualize three dimensional log data on two dimensional media |
| CN107748814A (en) * | 2017-10-13 | 2018-03-02 | 中国煤炭地质总局七三勘探队 | The boring method on plan |
| CN107808406A (en) * | 2017-10-11 | 2018-03-16 | 中国煤炭地质总局二九勘探队 | Profile drilling column generation method |
-
2018
- 2018-11-13 CN CN201811345303.1A patent/CN109543164B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070156340A1 (en) * | 2005-12-29 | 2007-07-05 | Schlumberger Technology Corporation | Method to visualize three dimensional log data on two dimensional media |
| CN107808406A (en) * | 2017-10-11 | 2018-03-16 | 中国煤炭地质总局二九勘探队 | Profile drilling column generation method |
| CN107748814A (en) * | 2017-10-13 | 2018-03-02 | 中国煤炭地质总局七三勘探队 | The boring method on plan |
Non-Patent Citations (2)
| Title |
|---|
| 张文哲: "浅析钻孔柱状图信息获取软件在钻孔信息化中的应用", 《科技与创新》 * |
| 才向军: "巧借EXCEL用AutoCAD绘制地质柱状图", 《矿山测量》 * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111159862A (en) * | 2019-12-17 | 2020-05-15 | 核工业二四三大队 | Electronic design and compiling method for uranium ore drilling design instruction |
| CN111159862B (en) * | 2019-12-17 | 2023-09-08 | 核工业二四三大队 | Electronic design and programming method for uranium mine drilling design instruction book |
| CN112287650A (en) * | 2020-10-23 | 2021-01-29 | 中国石油天然气集团有限公司 | Intelligent generation method, system and device for well logging interpretation report |
| CN112287650B (en) * | 2020-10-23 | 2024-05-28 | 中国石油天然气集团有限公司 | Intelligent generation method, system and device for logging interpretation report |
| CN112861508A (en) * | 2021-01-12 | 2021-05-28 | 中国石油天然气集团有限公司 | Standardization method and system for logging discrete data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109543164B (en) | 2023-07-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102360404B (en) | Method for compiling geological display map of chamber | |
| CN109543164A (en) | The method of Autocad combination Excel generation log sheet | |
| CN104732359A (en) | Oil field geographic information and exploration development collaboration work platform system | |
| CN104834518A (en) | Oilfield exploitation and development working platform system | |
| Newell et al. | Stratigraphic and spatial distribution of oil and gas production in Kansas | |
| CN100423003C (en) | Geological inspection column-like image drawing and compositing using CIS image document | |
| CN105719097A (en) | Dynamic analysis and waterflooding management system of fractured-vuggy type reservoir | |
| CN108898670B (en) | Three-dimensional geological modeling method based on entity and profile | |
| Davies et al. | Flow unit characterization of a shallow shelf carbonate reservoir: North Robertson unit, West Texas | |
| CN114549774A (en) | Three-dimensional stratum modeling method based on drilling data | |
| Ahmadpour et al. | Numerical simulation of two-phase mass transport in three-dimensional naturally fractured reservoirs using discrete streamlines | |
| Rian et al. | Automatic optimization of well locations in a north sea fractured chalk reservoir using a front tracking reservoir simulator | |
| CN107013207A (en) | A kind of method for obtaining Complex Fault Block Oil Reservoir sand body underground well location information | |
| Johnson | Bravo dome carbon dioxide area, northeast New Mexico | |
| Kiselyov et al. | Aspects of the Development of Low-Permeability Gas Reservoirs of Turonian Age | |
| Guerrero-Lee et al. | Effective Well Rate Management Using a Streamline-Based Model in Belridge Diatomite Waterflood | |
| Powley et al. | Simulation of a North Sea chalk reservoir with dynamic rock and natural fracture properties: Case study of the Valhall Field | |
| CN111159862B (en) | Electronic design and programming method for uranium mine drilling design instruction book | |
| CN113012257B (en) | Variable scale drilling histogram drawing method for manganese ore | |
| Yu et al. | Development of Drawing Program of Borehole Histogram Based on Delphi | |
| Lee et al. | Computer Design and Fieldwide Optimization for Gas-Lifted Wells | |
| Sabaev et al. | Vertically fractured well performance in rectangular drainage area | |
| Zetik | Reservoir Simulation for the El Dorado Micellar-Polymer Project | |
| Donohue | Can aerial photography improve oil recovery | |
| McDonald | CO2 Capture from Biofuels Production and Storage into the Mt Simon Sandstone |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |