CN110321542A - Method for batch drawing of survey drawings by using excel editing CAD (computer-aided design) commands - Google Patents

Method for batch drawing of survey drawings by using excel editing CAD (computer-aided design) commands Download PDF

Info

Publication number
CN110321542A
CN110321542A CN201910575180.9A CN201910575180A CN110321542A CN 110321542 A CN110321542 A CN 110321542A CN 201910575180 A CN201910575180 A CN 201910575180A CN 110321542 A CN110321542 A CN 110321542A
Authority
CN
China
Prior art keywords
coordinate
cad
batch
excel
text
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
Application number
CN201910575180.9A
Other languages
Chinese (zh)
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.)
China Hydropower Consulting Group Guiyang Survey And Design Institute Of Geotechnical Engineering Co ltd
PowerChina Guiyang Engineering Corp Ltd
Original Assignee
China Hydropower Consulting Group Guiyang Survey And Design Institute Of Geotechnical Engineering Co ltd
PowerChina Guiyang Engineering Corp 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 China Hydropower Consulting Group Guiyang Survey And Design Institute Of Geotechnical Engineering Co ltd, PowerChina Guiyang Engineering Corp Ltd filed Critical China Hydropower Consulting Group Guiyang Survey And Design Institute Of Geotechnical Engineering Co ltd
Priority to CN201910575180.9A priority Critical patent/CN110321542A/en
Publication of CN110321542A publication Critical patent/CN110321542A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/186Templates

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Processing Or Creating Images (AREA)

Abstract

The invention provides a method for batch drawing of survey pictures by using excel editing CAD commands, which can accurately position the data of each picture by using real survey hole data and combining CAD drawing coordinates, write CAD commands of the picture elements such as characters, multi-segment lines and the like needing to be added in batch by using an excel function by using the calculated picture element coordinates on a drawing according to the corresponding command format of drawing CAD picture elements by excel, pull down and fill, realize the rapid editing of the commands, copy the edited CAD commands to CAD command lines according to columns, and automatically generate the needed picture elements in batch. Belongs to the technical research field of building engineering software.

Description

A method of CAD order batch, which is edited, using excel draws prospecting graph
Technical field
The method that CAD order batch draws prospecting graph is edited using excel the present invention relates to a kind of, belongs to architectural engineering Software technology research field.
Background technique
CAD diagram paper is the main tool of construction industry drawing interaction, and existing engineering investigation is drawn mostly using CAD as basic tool Schemed out, the overwhelming majority prospecting softwares also using CAD be basic platform establish, CAD occur also can engineering investigation map volume System brings huge change.Existing prospecting graph is mostly drawn with pure CAD or is modified again with reconnoitring Software Create map, can Since engineering investigation drilling hole amount is generally more, the engineering geological profile and log sheet and drilling hole amount of generation are at just Than reconnoitring the modification of graph then therefore being related to large batch of, repeated modification operation.Although also there is many works currently on the market Batch duplicating, incremental modification etc. may be implemented in tool case, but can only carry out simple batch processing, cannot still handle prospecting graph and exist The requirement of certain high-volume modifications.
Summary of the invention
The present invention provides a kind of method for editing CAD order batch drafting prospecting graph using excel, puts forth effort on utilization Excel batch editor's CAD order, the method for then drawing pel in batches in CAD software carry out the batch modification of prospecting graph And drafting, improve the efficiency of prospecting graph later period modification.
To solve the above problems, proposed adoption is such a to edit the side that CAD order batch draws prospecting graph using excel Method, specific as follows:
1) pixel coordinates on drawing are calculated
The data of each graph are accurately positioned, example using true exploration hole data in conjunction with CAD diagram paper coordinate Such as:
For plan view: determining the drawing coordinate of each exploratory hole graphics primitive object using exploratory hole actual coordinate;
For sectional view, using the aperture coordinate of exploratory hole first on sectional view, in conjunction with actual exploratory hole coordinate and Elevation, then converted by scale bar, determine the aperture coordinate of other exploratory holes on sectional view and the coordinate of demixing point;It is specific to calculate It is as follows:
1. accurately calculating exploratory hole profile spacing using exploratory hole coordinate;
2. using profile spacing, aperture elevation and cuing open first exploratory hole aperture coordinate on figure, other are each on reference section figure The drawing coordinate of exploratory hole;
3. utilizing the drawing coordinate and depth of seam division of each exploratory hole, the coordinate of each demixing point of reference section figure exploratory hole;
For histogram, the certain point of first log sheet is reference point, using the horizontal spacing of histogram arrangement, is indulged To spacing, list widths and exploratory hole depth of seam division and, calculate the coordinate of all pels on histogram;
After determining coordinate relationship, the coordinate calculated with the pel of required batch modification is write using exploration hole data, For the coordinate for needing to modify pel that converts;
2) the CAD order for writing addition pel is drawn
The corresponding command format that CAD diagram member is drawn according to excel, is fixed with the pixel coordinates on calculated drawing Position writes the CAD order for needing the pels such as text to be added, multi-section-line using excel function batch, and then drop-down is filled, i.e., The quick editor of order can be achieved, finally copy the CAD order editted to CAD order line by column, automatic batch generates institute The pel needed.
The format that CAD order batch draws CAD diagram part is edited using excel:
It according to CAD command stream editor's CAD order, pastes CAD and is drawn, edit, carry out by vertical batch in excel Batch is drawn, and the most common CAD order edited in excel is as follows:
1. justifying: the center of circle=" C " & the center of circle x& ", " & y& " " & radius r;
2. straight line :=" l " & point x& ", " & point y;
3. multi-section-line :=" pl " & point x& ", " & point y;
4. text, single line text:
Text style is standard in CAD
="-text " coordinate x& ", " coordinate y& " word height " " rotation angle " " text "
Other text styles are specified in CAD
="-text " coordinate x& ", " coordinate y& " rotates angle " " text "
Format expression does not need specified word height.
Compared with prior art, the present invention on the elevation machine plotting, sectional view and histogram of plan view taking rate, RQD, with There is very high efficiency in the drafting of the texts such as pipe drilling and line segment, one unified template of editable is used for multiple times, it is only necessary to Exploratory hole initial data is replaced, it is very efficiently convenient.
This method has been resolved the batch Drawing Figures problem of the plan view of multiple projects, sectional view and histogram." all In the map compilation of even economic development zone dream all cultural tour Creative Industry Parks (phase)-Qin Hancheng construction project ", using this Method depicts the core recovery curve of about 4500 drillings and the velocity of wave of multiple drillings and dynamic spy curve in two days, " in permanent big tea prefecture prospecting project ", realizes the elevation machine plotting of thousands of drillings with the method and drilling is numbered, and realize more The batch addition of the drilling RQD and permeability rate of sectional view in a project.This method is based on realizing to reconnoitre initial data High-volume prospecting graph modification and drafting on truly have very high efficiency.
Specific embodiment
To make the object, technical solutions and advantages of the present invention clearer, the present invention will be made below further detailed Explanation, it should be understood that described herein specific examples are only used to explain the present invention, is not intended to limit the present invention.
Embodiment
The method that CAD order batch draws prospecting graph is edited using excel the present embodiment provides a kind of, specific method is such as Under:
1) research and utilization excel edits the format that CAD order batch draws CAD diagram part
As long as after study according to CAD command stream editor's CAD order, so that it may paste CAD and be drawn, in excel By vertical batch editor, batch drafting can be carried out, the most common CAD order edited in excel is as follows:
1. justifying: the center of circle=" C " & the center of circle x& ", " & y& " " & radius r;
2. straight line :=" l " & point x& ", " & point y
3. multi-section-line :=" pl " & point x& ", " & point y.
4. text
Single line text:
Text style is standard in CAD
="-text " coordinate x& ", " coordinate y& " word height " " rotation angle " " text "
Other text styles are specified in CAD
="-text " coordinate x& ", " coordinate y& " rotates angle " " text "
Format expression does not need specified word height
2) regularity of survey data and the systematicness of arrangement are analyzed
The drafting for reconnoitring graph is to build basic graphics frame using the coordinate and elevation of exploratory hole, then in frame Store survey data such as exploratory hole number, coordinate, elevation, hole depth, layer bottom depth, depth to water, layering boundary, filling symbol in face Deng.Thus, the coordinate and elevation of exploratory hole are the data to form the most critical of graph, utilize the actual coordinate and elevation of exploratory hole Relationship each exploratory hole information in figure can be accurately positioned in conjunction with drawing coordinate of the graph in CAD diagram shape.
It is generally more to reconnoitre graph, especially engineering geological profile and log sheet, generally multi-purpose system when at figure One picture frame, and arranged according to unified spacing.Unified picture frame and unified figure spacing are to calculate each same position of graph The coordinate for the figure set provides good solution.
3) pixel coordinates on drawing are calculated
The data of each graph can be accurately positioned using true exploration hole data in conjunction with CAD diagram paper coordinate Such as:
For plan view: can determine the drawing coordinate of each exploratory hole graphics primitive object using exploratory hole actual coordinate.
For sectional view, using the aperture coordinate of exploratory hole first on sectional view, in conjunction with the coordinate of actual exploratory hole And elevation, then converted by scale bar, it may be determined that the aperture coordinate of other exploratory holes and the coordinate of demixing point on sectional view.Specifically It calculates as follows:
1. can accurately calculate exploratory hole profile spacing using exploratory hole coordinate;
2. using profile spacing, aperture elevation and cut open first exploratory hole aperture coordinate on figure, can on reference section figure its The drawing coordinate of his each exploratory hole;
3. the drawing coordinate and depth of seam division of each exploratory hole are utilized, it can be with the seat of each demixing point of reference section figure exploratory hole Mark.
It, can be using the certain point of first log sheet as reference point, between the transverse direction using histogram arrangement for histogram And, the coordinate of all pels on histogram can be calculated away from, the depth of seam division of longitudinal pitch, list widths and exploratory hole.
After determining coordinate relationship, the seat calculated with the pel of required batch modification is write using exploration hole data Mark, for the coordinate for needing to modify pel that converts.
4) the CAD order for writing addition pel is drawn
The corresponding command format that CAD diagram member is drawn according to excel, is fixed with the pixel coordinates on calculated drawing Position writes the CAD order for needing the pels such as text to be added, multi-section-line using excel function batch, and then drop-down is filled, i.e., The quick editor of order can be achieved, finally copy the CAD order editted to CAD order line by column, automatic batch generates institute The pel needed.
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 Made any modifications, equivalent replacements, and improvements etc., should all be included in the protection scope of the present invention within mind and principle.

Claims (3)

1. a kind of edit the method that CAD order batch draws prospecting graph using excel, which is characterized in that specific as follows:
1) pixel coordinates on drawing are calculated
The data of each graph are accurately positioned in conjunction with CAD diagram paper coordinate using true exploration hole data;
2) the CAD order for writing addition pel is drawn
The corresponding command format of CAD diagram member is drawn according to excel, is positioning, benefit with the pixel coordinates on calculated drawing The CAD order of the pels such as need text to be added, multi-section-line is write with excel function batch, then drop-down filling, can be realized The quick editor of order finally copies the CAD order editted to CAD order line by column, required for automatic batch generates Pel.
2. a kind of according to claim 1 edit the method that CAD order batch draws prospecting graph, feature using excel It is, in step 1), pinpoint to the data progress of each graph the specific method is as follows:
For plan view: determining the drawing coordinate of each exploratory hole graphics primitive object using exploratory hole actual coordinate;
For sectional view, using the aperture coordinate of exploratory hole first on sectional view, in conjunction with the coordinate and elevation of actual exploratory hole, It is converted again by scale bar, determines the aperture coordinate of other exploratory holes on sectional view and the coordinate of demixing point;Specific calculating is as follows:
1. accurately calculating exploratory hole profile spacing using exploratory hole coordinate;
2. using profile spacing, aperture elevation and cuing open first exploratory hole aperture coordinate on figure, other each explorations on reference section figure The drawing coordinate in hole;
3. utilizing the drawing coordinate and depth of seam division of each exploratory hole, the coordinate of each demixing point of reference section figure exploratory hole;
For histogram, the certain point of first log sheet is reference point, using between the horizontal spacing of histogram arrangement, longitudinal direction Depth of seam division away from, list widths and exploratory hole and, calculate the coordinate of all pels on histogram;
After determining coordinate relationship, the coordinate calculated with the pel of required batch modification is write using exploration hole data, for Conversion needs to modify the coordinate of pel.
3. a kind of according to claim 1 edit the method that CAD order batch draws prospecting graph, feature using excel It is, edits the format that CAD order batch draws CAD diagram part using excel:
It according to CAD command stream editor's CAD order, pastes CAD and is drawn, edited in excel by vertical batch, carry out batch It draws, the most common CAD order edited in excel is as follows:
1. justifying: the center of circle=" C " & the center of circle x& ", " & y& " " & radius r;
2. straight line :=" l " & point x& ", " & point y;
3. multi-section-line :=" pl " & point x& ", " & point y;
4. text, single line text:
Text style is standard in CAD
="-text " coordinate x& ", " coordinate y& " word height " " rotation angle " " text "
Other text styles are specified in CAD
="-text " coordinate x& ", " coordinate y& " rotates angle " " text ".
CN201910575180.9A 2019-06-28 2019-06-28 Method for batch drawing of survey drawings by using excel editing CAD (computer-aided design) commands Pending CN110321542A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910575180.9A CN110321542A (en) 2019-06-28 2019-06-28 Method for batch drawing of survey drawings by using excel editing CAD (computer-aided design) commands

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910575180.9A CN110321542A (en) 2019-06-28 2019-06-28 Method for batch drawing of survey drawings by using excel editing CAD (computer-aided design) commands

Publications (1)

Publication Number Publication Date
CN110321542A true CN110321542A (en) 2019-10-11

Family

ID=68121334

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910575180.9A Pending CN110321542A (en) 2019-06-28 2019-06-28 Method for batch drawing of survey drawings by using excel editing CAD (computer-aided design) commands

Country Status (1)

Country Link
CN (1) CN110321542A (en)

Cited By (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110738028A (en) * 2019-10-15 2020-01-31 中国煤炭地质总局一七三勘探队 method for drawing gas pipeline system diagram by EXCEL
CN110852034A (en) * 2019-11-05 2020-02-28 广东博力威科技股份有限公司 Method for editing coordinate position of battery cell loading bracket automatically
CN110908336A (en) * 2019-12-13 2020-03-24 上海维宏电子科技股份有限公司 Method for realizing high-precision manual filling processing supported by circular holes in figure in laser numerical control system
CN110990906A (en) * 2019-12-03 2020-04-10 中山市华盛家具制造有限公司 CAD auxiliary drawing method for drawing core material graph
CN111581685A (en) * 2020-04-15 2020-08-25 湖北省水利水电规划勘测设计院 Siphon type runner molded line design and drawing method based on excel
CN111667551A (en) * 2020-06-01 2020-09-15 山东省地质矿产勘查开发局八〇一水文地质工程地质大队 Method and system for drawing electrical sounding curve type graph
CN112820184A (en) * 2019-11-18 2021-05-18 核工业二一六大队 Sandstone-type uranium ore exploration line design profile map forming method
CN113282983A (en) * 2021-05-13 2021-08-20 中铁大桥勘测设计院集团有限公司 Method, device and equipment for drawing cross section and readable storage medium
CN115526015A (en) * 2022-11-03 2022-12-27 北京国科恒通科技股份有限公司 Command interaction-based power grid diagram generation method, device, medium and equipment

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102722616A (en) * 2012-06-04 2012-10-10 化学工业岩土工程有限公司 Method for drawing exploration point plan based on Excel
CN107808406A (en) * 2017-10-11 2018-03-16 中国煤炭地质总局二九勘探队 Profile drilling column generation method
CN108305304A (en) * 2018-02-28 2018-07-20 灵宝金源矿业股份有限公司 A kind of batch record point methods for drawing engineering sectional view
CN109063036A (en) * 2018-07-16 2018-12-21 中国电建集团贵阳勘测设计研究院有限公司 method for rapidly manufacturing standard interface data file for research by using EXCE L

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102722616A (en) * 2012-06-04 2012-10-10 化学工业岩土工程有限公司 Method for drawing exploration point plan based on Excel
CN107808406A (en) * 2017-10-11 2018-03-16 中国煤炭地质总局二九勘探队 Profile drilling column generation method
CN108305304A (en) * 2018-02-28 2018-07-20 灵宝金源矿业股份有限公司 A kind of batch record point methods for drawing engineering sectional view
CN109063036A (en) * 2018-07-16 2018-12-21 中国电建集团贵阳勘测设计研究院有限公司 method for rapidly manufacturing standard interface data file for research by using EXCE L

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
尤苏南: "利用Excel表格在CAD中按类别快速展绘勘探点技术", 《计算机与现代化》 *
邱章云: "应用excel编制AutoCAD脚本文件实现批量展点绘图", 《矿山测量》 *

Cited By (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110738028A (en) * 2019-10-15 2020-01-31 中国煤炭地质总局一七三勘探队 method for drawing gas pipeline system diagram by EXCEL
CN110852034A (en) * 2019-11-05 2020-02-28 广东博力威科技股份有限公司 Method for editing coordinate position of battery cell loading bracket automatically
CN112820184A (en) * 2019-11-18 2021-05-18 核工业二一六大队 Sandstone-type uranium ore exploration line design profile map forming method
CN110990906A (en) * 2019-12-03 2020-04-10 中山市华盛家具制造有限公司 CAD auxiliary drawing method for drawing core material graph
CN110990906B (en) * 2019-12-03 2023-03-10 广东华盛家具集团有限公司 CAD auxiliary drawing method for drawing core material graph
CN110908336A (en) * 2019-12-13 2020-03-24 上海维宏电子科技股份有限公司 Method for realizing high-precision manual filling processing supported by circular holes in figure in laser numerical control system
CN110908336B (en) * 2019-12-13 2022-08-02 上海维宏电子科技股份有限公司 Method for realizing high-precision manual filling processing supported by circular holes in figure in laser numerical control system
CN111581685A (en) * 2020-04-15 2020-08-25 湖北省水利水电规划勘测设计院 Siphon type runner molded line design and drawing method based on excel
CN111667551A (en) * 2020-06-01 2020-09-15 山东省地质矿产勘查开发局八〇一水文地质工程地质大队 Method and system for drawing electrical sounding curve type graph
CN113282983A (en) * 2021-05-13 2021-08-20 中铁大桥勘测设计院集团有限公司 Method, device and equipment for drawing cross section and readable storage medium
CN115526015A (en) * 2022-11-03 2022-12-27 北京国科恒通科技股份有限公司 Command interaction-based power grid diagram generation method, device, medium and equipment
CN115526015B (en) * 2022-11-03 2023-02-03 北京国科恒通科技股份有限公司 Command interaction-based power grid diagram generation method, device, medium and equipment

Similar Documents

Publication Publication Date Title
CN110321542A (en) Method for batch drawing of survey drawings by using excel editing CAD (computer-aided design) commands
CN104915521B (en) Log sheet compilation method based on field catalog data and automated cartographic generalization
CN102360404B (en) Method for compiling geological display map of chamber
CN105760536A (en) Geological map database establishing device and geological map database establishing device method based on geological database
CN105184865A (en) Geological map compilation method based on geological three-dimensional modeling process
CN106991258A (en) A kind of method for setting up Tunnel Engineering geology skiagraph
CN102799702A (en) Quick topographic map making method based on database driving
CN103279986A (en) Three-dimensional horizontal geological section map manufacturing method and applications thereof
CN103714203A (en) Drilling histogram automatic mapping method based on CAD template binding technology
CN113689559B (en) Grid-shaped graph cut geological section wiring method for improving content expression precision of geological three-dimensional model
CN105652341B (en) Rapid quantitative ancient landform restoration method considering ancient structure influence
CN109102564A (en) A kind of coupling modeling method of complex geologic body numerical model
CN108268256A (en) A kind of log sheet standardizes dynamic web page generation method
CN106875485A (en) Towards the live three-dimensional coordinate Establishing method that Hydroelectric Engineering Geology construction is edited and recorded
CN106709988A (en) Construction method of engineering geological section map
US20150294050A1 (en) Method, Apparatus and System for Improved Groundwater Modeling
CN114549774A (en) Three-dimensional stratum modeling method based on drilling data
CN115661290A (en) Method and system for drawing ground settlement histogram
CN101788686A (en) Point-by-point excitation well depth designing method based on uniform near-surface model
CN107564101A (en) A kind of method that visualization of 3 d geological model is established based on AutoCAD
CN109543164A (en) The method of Autocad combination Excel generation log sheet
Ozkaya FRACOR-software toolbox for deterministic mapping of fracture corridors in oil fields on AutoCAD platform
CN113420348A (en) Method for rapidly drawing uranium mine exploration line profile map
CN1595455A (en) Real-time three-dimensional geology modeling method based on GIS and virtual reality
CN116894915A (en) Artificial intelligence semi-automatic three-dimensional geological modeling data processing method

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
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20191011