CN109543164B - Method for generating drilling histogram by combining Autocad with Excel - Google Patents

Method for generating drilling histogram by combining Autocad with Excel Download PDF

Info

Publication number
CN109543164B
CN109543164B CN201811345303.1A CN201811345303A CN109543164B CN 109543164 B CN109543164 B CN 109543164B CN 201811345303 A CN201811345303 A CN 201811345303A CN 109543164 B CN109543164 B CN 109543164B
Authority
CN
China
Prior art keywords
data
input
drilling
command
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.)
Active
Application number
CN201811345303.1A
Other languages
Chinese (zh)
Other versions
CN109543164A (en
Inventor
左明星
王涛
周金龙
车显萌
李辉
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Ccce First Exploration Bureau Co ltd
Original Assignee
Ccce First Exploration Bureau Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Ccce First Exploration Bureau Co ltd filed Critical Ccce First Exploration Bureau Co ltd
Priority to CN201811345303.1A priority Critical patent/CN109543164B/en
Publication of CN109543164A publication Critical patent/CN109543164A/en
Application granted granted Critical
Publication of CN109543164B publication Critical patent/CN109543164B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

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 invention provides a method for generating a drilling histogram by combining Autocad with Excel, which specifically comprises the following steps: copying the patterns in the geological legend library into a Support folder of the CAD installation catalog; inputting the original data of the drill hole into an Input table of Excel; converting the data in the last step into an Output table; copying the data in the last step into a CAD command bar; and (5) drawing. The invention has the beneficial effects that: only the corresponding positions of an Input table of an Excel template are Input by water level, consumption, geological record results, stratum layering, hole inclination data and the like, the Input table is converted into an Output table, each column of data in the Output table is copied and stuck in a CAD command bar, a drilling histogram is automatically generated by CAD, and the picture head, the picture label, the drilling structure and the logging results are perfected, so that the drilling histogram is finally completed; the drilling histogram generated by the method has high accuracy and can better accord with national standard specifications.

Description

Method for generating drilling histogram by combining Autocad with Excel
Technical Field
The invention belongs to the technical field of software drawing, and particularly relates to a method for generating a drilling histogram by combining Autocad with Excel.
Background
The drilling histogram is the most basic geological map, and the traditional geological map is mainly drawn manually, so that the time consumption, the labor consumption and the precision are low. Along with the development of industrial technology, the requirements on the precision of geological map pieces are higher and higher, powerful drawing software such as Autocad and the like are widely utilized, and on the basis, some software, plug-ins and the like for generating drilling columns are developed, but certain problems exist, so that the generated map is easy to be inconsistent with the industrial standard of China.
Disclosure of Invention
In view of the above, the present invention is directed to a method for generating a borehole histogram by combining Autocad with Excel, so as to solve the above-mentioned drawbacks.
In order to achieve the above purpose, the technical scheme of the invention is realized as follows:
the method for generating the drilling histogram by combining Autocad with Excel specifically comprises the following steps:
A. copying the patterns in the geological legend library into a Support folder of the CAD installation catalog;
B. inputting the original data of the drill hole into an Input table of Excel;
C. converting the data in the step B into an Output table;
D. copying the data in the step C into a CAD command bar;
E. and (5) drawing.
Further, in the step B, data including consumption, water level, geological record result, stratum stratification and pore inclination are Input in an Excel template Input table, and a multiple of 3 is found at MAX (maximum consumption) and MAX water (and maximum water level) in the Input table, for example, the water level is 17.5, and the multiple of 3 is 18; the consumption is 3.1, the multiple of 3 is 3.3, and then the MAX and MAX water are correspondingly input into the cell.
Further, in the step C, the Data in the Input table is called by Data1, data2, data3, data4, data5, and the Output table calls the drawing command of the Data, table, header and column automatically generated in Data1, data2, data3, data4, data 5;
the Data1 table automatically invokes the Data of the water level and consumption in the Input table, and generates a water level drawing command; automatically calling geological record result information in an Input table in a Data2 table, wherein the geological record result information comprises a serial number, lithology description, hole depth, layer thickness, sampling length, sampling rate and inclination angle; calling a command by a legend library in Data6 to automatically calculate true thickness and true thickness accumulation, and generating a Data, a table, a drawing head and a pseudo-thickness small histogram command; automatically calling stratum layering information in the Input table in the Data3 table, including stratum names, symbols and depths, and generating stratum drawing commands; automatically calling true thickness and true thickness accumulated Data in Data2 in a Data4 table, calling a command in a legend library in Data6, and generating a true thickness small histogram command; automatically calling the Data of the hole inclination Data in the Input table in the Data5 table, wherein the Data comprises the hole depth, zenith angle and azimuth angle, and generating hole inclination Data and a drawing command of the table; the Data6 table is a legend library call command;
the Output table automatically invokes drawing commands for automatically generated Data, tables, headers and columns in Data1, data2, data3, data4, data 5.
Further, in the step D, each column of data in the Output table in Excel is copied and pasted in the CAD command bar, and the CAD will automatically generate the geological drilling column corresponding to each item.
And E, according to the drilling condition, the drawing head, the drawing tag, the water level, the consumption scale and the drilling structure are coded, and the logging result is scaled to be the same proportion and copied and stuck to the corresponding position of the drilling histogram, so that the drilling histogram is completed.
Compared with the prior art, the method for generating the drilling histogram by combining Autocad with Excel has the following advantages:
the water level, consumption, geological record result, stratum layering, hole inclination data and the like are only required to be Input into the corresponding position of the Input table of the Excel template and converted into the Output table, each column of data in the Output table is copied and pasted in a CAD command bar, the CAD automatically generates a drilling histogram, the figure head, the figure label, the drilling structure and the logging result are perfected, and finally the drilling histogram is completed. The drilling histogram generated by the method has high accuracy and can better accord with national standard specifications.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the invention. In the drawings:
FIG. 1 is a flow chart of a method for generating a borehole histogram by combining Autocad with Excel according to an embodiment of the present invention;
FIG. 2 is a diagram showing the data content to be Input in an Input table according to an embodiment of the present invention;
FIG. 3 is a partial data content of an Output table according to an embodiment of the present invention;
FIG. 4 is a histogram of geological drilling corresponding to each item of CAD generated data;
FIG. 5 is a CAD generated final borehole histogram;
FIG. 6 is an enlarged view of portion A of FIG. 5;
fig. 7 is an enlarged view of a portion B in fig. 5.
Detailed Description
It should be noted that, without conflict, the embodiments of the present invention and features of the embodiments may be combined with each other.
The invention will be described in detail below with reference to the drawings in connection with embodiments.
As shown in fig. 1, the method for generating a borehole histogram by combining Autocad with Excel specifically includes the following steps:
A. copying the patterns in the geologic legend library into a Support folder of the CAD installation catalog, which is a necessary file for generating a drilling column;
B. inputting the original data of the drill hole into an Input table of Excel;
C. converting the data in the step B into an Output table;
D. copying the data in the step C into a CAD command bar;
E. and (5) drawing.
In the step B, data is Input into an Excel template Input table, as shown in fig. 2, including consumption, water level, geological logging result, stratum layering and hole inclination data, and a value of a multiple of 3 nearby the MAX elimination and MAX water in the Input table is found, for example, the water level is 17.5, and the multiple of 3 is 18; the consumption is 3.1, the multiple of 3 is 3.3, and then the MAX and MAX water are correspondingly input into the cell.
In the step C, the Data in the Input table is called by Data1, data2, data3, data4, data5, and the Output table calls the automatically generated Data, table, header and column drawing command in Data1, data2, data3, data4, data 5;
the Data1 table automatically invokes the Data of the water level and consumption in the Input table, and generates a water level drawing command; automatically calling geological record result information in an Input table in a Data2 table, wherein the geological record result information comprises a serial number, lithology description, hole depth, layer thickness, sampling length, sampling rate and inclination angle; calling a command by a legend library in Data6 to automatically calculate true thickness and true thickness accumulation, and generating a Data, a table, a drawing head and a pseudo-thickness small histogram command; automatically calling stratum layering information in the Input table in the Data3 table, including stratum names, symbols and depths, and generating stratum drawing commands; automatically calling true thickness and true thickness accumulated Data in Data2 in a Data4 table, calling a command in a legend library in Data6, and generating a true thickness small histogram command; automatically calling the Data of the hole inclination Data in the Input table in the Data5 table, wherein the Data comprises the hole depth, zenith angle and azimuth angle, and generating hole inclination Data and a drawing command of the table; the Data6 table is a legend library call command;
the Output table automatically calls the automatically generated Data, table, drawing head and column drawing command in Data1, data2, data3, data4 and Data5, and each column of Data finally generated in the Output table is the information of the drawing head, consumption, water level, sequence number, rock name, rock description, accumulation thickness, layer thickness, length, sampling rate, inclination angle, true thickness accumulation, column sequence number, column, stratum name, hole inclination Data and true thickness column respectively, and the partial table contents in the Output table are shown in fig. 3.
In the step D, each column of data in the Output table in Excel is copied and pasted in the CAD command bar, and the CAD will automatically generate the geological drilling column corresponding to each item, as shown in fig. 4.
In the step E, the drawing head, the drawing tag, the water level, the consumption scale and the drilling structure are organized according to the drilling condition, and the logging result is scaled to be the same scale and copied and stuck to the corresponding position of the drilling histogram, so that the drilling histogram is completed, as shown in fig. 5 to 7.
The invention only needs to Input water level, consumption, geological record result, stratum layering, hole inclination data and the like into the corresponding position of the Input table of the Excel template, and convert the data into the Output table, copy and paste each column of data in the Output table into a CAD command bar, and the CAD automatically generates a drilling histogram, perfects the drawing head, the drawing label, the drilling structure and the logging result, and finally completes the drilling histogram.
The foregoing description of the preferred embodiments of the invention is not intended to be limiting, but rather is intended to cover all modifications, equivalents, alternatives, and improvements that fall within the spirit and scope of the invention.

Claims (1)

  1. The method for generating the drilling histogram by combining Autocad with Excel is characterized by comprising the following steps:
    A. copying the patterns in the geological legend library into a Support folder of the CAD installation catalog;
    B. inputting the original data of the drill hole into an Input table of Excel;
    in the step B, data including consumption, water level, geological record result, stratum layering and hole inclination data are Input into an Input table of an Excel template, and values of multiples of 3 nearby the consumption maximum value and the water level maximum value are Input into the Input table;
    C. converting the data in the step B into an Output table;
    in the step C, the Data in the Input table is called by Data1, data2, data3, data4, data5, and the Output table calls the automatically generated Data, table, header and column drawing command in Data1, data2, data3, data4, data 5;
    automatically calling the Data of the water level and consumption in the Input table in the Data1 table, and generating a water level drawing command; automatically calling geological record result information in an Input table in a Data2 table, wherein the geological record result information comprises a serial number, lithology description, hole depth, layer thickness, sampling length, sampling rate and inclination angle; calling a command by a legend library in Data6 to automatically calculate true thickness and true thickness accumulation, and generating a Data, a table, a drawing head and a pseudo-thickness small histogram command; automatically calling stratum layering information in the Input table in the Data3 table, including stratum names, symbols and depths, and generating stratum drawing commands; automatically calling true thickness and true thickness accumulated Data in Data2 in a Data4 table, calling a command in a legend library in Data6, and generating a true thickness small histogram command; automatically calling the Data of the hole inclination Data in the Input table in the Data5 table, wherein the Data comprises the hole depth, zenith angle and azimuth angle, and generating hole inclination Data and a drawing command of the table; the Data6 table is a legend library call command;
    D. copying the data in the step C into a CAD command bar;
    in the step D, copying and pasting each column of data in an Output table in Excel into a CAD command bar, and automatically generating geological drilling columns corresponding to each item by CAD;
    E. drawing;
    and E, according to the drilling condition, the drawing head, the drawing tag, the water level, the consumption scale and the drilling structure are organized, the logging result is scaled to be the same proportion and copied and stuck to the corresponding position of the drilling histogram, and the drilling histogram is completed.
CN201811345303.1A 2018-11-13 2018-11-13 Method for generating drilling histogram by combining Autocad with Excel Active CN109543164B (en)

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 CN109543164A (en) 2019-03-29
CN109543164B true 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)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111159862B (en) * 2019-12-17 2023-09-08 核工业二四三大队 Electronic design and programming method for uranium mine drilling design instruction book
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

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
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

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7340347B2 (en) * 2005-12-29 2008-03-04 Schlumberger Technology Corporation Method to visualize three dimensional log data on two dimensional media

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
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)

* Cited by examiner, † Cited by third party
Title
巧借EXCEL用AutoCAD绘制地质柱状图;才向军;《矿山测量》;20080331(第01期);第45-47页 *
浅析钻孔柱状图信息获取软件在钻孔信息化中的应用;张文哲;《科技与创新》;20170125(第02期);全文 *

Also Published As

Publication number Publication date
CN109543164A (en) 2019-03-29

Similar Documents

Publication Publication Date Title
CN109543164B (en) Method for generating drilling histogram by combining Autocad with Excel
CN101430714B (en) Content structuring process method and system based on model
CN103970737B (en) A kind of data configuration method and apparatus
CN104346466B (en) The method and apparatus for the data that Added New Attribute in database
CN107122173A (en) A kind of adaptation activiti, the list generation method that can be pulled
CN104298595A (en) Automatic testing method and testing system
CN107168695B (en) Excel data analysis method and system
CN100423003C (en) Geological inspection column-like image drawing and compositing using CIS image document
CN108509199A (en) Method, device, equipment and storage medium for automatically generating Chinese annotations
CN105005666A (en) Conversion method of architectural structure model
CN104699758B (en) The commanding document intelligent generating system and method for a kind of graphics and text library association
CN105404472A (en) Method and apparatus for compressing storage space of log time data
US9323795B2 (en) System and method for providing structured data to a structured or unstructured grid
CN103246753A (en) Method for generating entity metadata model according to database structure
CN107748814A (en) The boring method on plan
CN105069162A (en) Informatized exploratory adit catalog data acquisition system and method
CN102819434A (en) Method and device for showing power information communication scheduling report
CN106383734A (en) Method for extracting detailed design from codes
CN102710833A (en) Mobile phone test case and automatic generation method thereof
CN108074282B (en) Thickness correction method of physical property parameters based on three-dimensional geological modeling software
CN101295245B (en) Intelligent extracting method based on model information
CN104462463A (en) JavaScript data access method based on SQL template
CN103077284B (en) Generic text template is utilized automatically to generate the method and system of auxiliary code file
CN112908145A (en) Equal-thickness map mapping method for sandstone-type uranium ore sand bodies
CN102184166A (en) Method for converting Excel form into InfoPath form based on office software

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