An automated design method and system for engineering design drawing catalog
Through automated design methods, Excel spreadsheet data is used to automatically create and edit engineering design drawing catalogs in CAD model space, solving the time-consuming problem of manual drawing and achieving efficient drawing catalog design.
Patent Information
- Application Number
- CN202411243350.0
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-09-05
- Publication Date
- 2025-09-16
- Estimated Expiration
- 2044-09-05
AI Technical Summary
In existing engineering design, manually drawing engineering design drawing catalogs takes a long time, resulting in wasted productivity and low production efficiency.
Through automated design methods, Excel spreadsheet data is used to input drawing catalog information, automatically arrange drawing frames and tables, and quickly create and edit catalog content in CAD model space.
It has greatly improved the production efficiency of engineering design drawing catalogs and reduced manual operation time, shortening the drawing production time from 0.5 working days to 0.5 hours.
Smart Images

Figure CN119294371B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of engineering automation design, and in particular to an engineering design drawing catalog automation design method and system. Background Art
[0002] Currently, when engineering designers produce a catalog of engineering design drawings, they first need to manually draw the catalog table in the CAD model space. They then create single-line text in the corresponding rows and columns of the table, edit the text content, and manually adjust the font style, height, and color. Finally, they manually create and arrange the design drawing catalog frame. This method involves numerous manual steps, including text creation, editing, typesetting, table drawing, and frame drawing. All of these steps must be completed manually within the CAD model space, which is time-consuming and requires designers to perform a large amount of repetitive work, wasting productivity and reducing production efficiency. Summary of the Invention
[0003] The purpose of the present invention is to solve the problems of wasted productivity and reduced production efficiency caused by manual work in existing engineering design. To solve the above problems, the present invention provides the following technical solutions:
[0004] An automated design method for an engineering design drawing catalog comprises the following steps:
[0005] S1. Input engineering design drawing catalog information;
[0006] S2. Read engineering design drawing catalog data;
[0007] S3. Select the insertion point of the engineering design drawing catalog frame and automatically arrange the engineering design drawing catalog frame and catalog table;
[0008] The S3 step specifically includes:
[0009] S31, the engineering design drawing catalog frame insertion point is obtained by inputting coordinates or manually selecting in the model space, and the engineering design drawing catalog frame insertion point is defined as P M ;
[0010] S32. Select the insertion point P of the engineering design drawing catalog frame M Then, insert the engineering design drawing catalog frame and catalog table into the model space in the form of a block, with the insertion base point being the lower left corner of the engineering design drawing catalog library; the engineering design drawing catalog frame and catalog table are stored in dwg file format, and the design drawing catalog frame and catalog table dwg format file corresponding to the engineering project is obtained by selecting a file or entering a file path;
[0011] S4. Obtaining the planar position of the catalog table in the engineering design drawing catalog frame; the planar position is represented by the relative planar relationship between the center point of the first row and first column cell in the catalog table and the insertion point in step S3;
[0012] In the S4 step:
[0013] Define the center point of the first row and first column cell in the directory table Definition With the P described in step S3 M The X-axis distance is X M ,definition With P M The Y-axis distance is Y M ;
[0014] S5. Set the row and column spacing of the directory table;
[0015] S6. Automatically fill in the engineering design drawing catalog content in the catalog form to complete the engineering design drawing catalog design;
[0016] The S6 step specifically includes:
[0017] S61, the directory content in the i-th row and j-th column of the directory table is read from the i-th row and j-th column of the two-dimensional text array in step S2;
[0018] S62. Define the single-line text insertion point as The middle point of a single line of text is used as the insertion base point;
[0019] S63. Set the font style of single-line text, including font, size, and color.
[0020] Further preferably, in step S1, inputting engineering design drawing catalog information refers to filling in the catalog information of the specified engineering project in the engineering design drawing catalog template file; the engineering design drawing catalog template file is an Excel document in xlsx format or xls format.
[0021] Further preferably, in step S2, the engineering design drawing catalog data is read from the specified row and specified column of the engineering design drawing catalog template file in step S1 and stored in the form of a two-dimensional text array.
[0022] Further preferably, in step S5, the row spacing is the vertical distance between the center points of two adjacent rows in the directory table, and the column spacing is the horizontal distance between the center points of two adjacent columns in the directory table.
[0023] Further preferably, the line spacing from row i to row i+1 of the directory table is defined as The distance between column j and column j+1 in the table of contents is Wj M , i and j are both positive integers.
[0024] Further preferably, the single-line text insertion point coordinate Calculated as follows:
[0025]
[0026]
[0027] In the above formula, are respectively the engineering design drawing catalog frame insertion point P in step S3 M The X-axis and Y-axis coordinates, k is the mathematical summation symbol variable, X M 、Y M Respectively as described in step S4 With P M The distance in the X-axis direction and the distance in the Y-axis direction.
[0028] Further preferably, the X-axis, Y-axis and corresponding coordinate calculations all adopt a Cartesian plane rectangular coordinate system.
[0029] The present invention also provides an automated design system for an engineering design drawing catalog, which uses an automated design method for an engineering design drawing catalog. The system includes:
[0030] Engineering design drawing catalog data input module, used to input engineering design drawing catalog information and read engineering design drawing catalog data;
[0031] The module for automatically arranging the drawing frame and table of contents of engineering design drawings can obtain the insertion point of the drawing frame of engineering design drawings by inputting coordinates or manually selecting in the CAD model space, and automatically arrange the drawing frame and table of contents of engineering design drawings;
[0032] The module for automatically generating the catalog content of engineering design drawings automatically calculates the insertion point and fills in and formats the catalog content of engineering design drawings in the catalog form according to the plane position, row spacing and column spacing parameters of the catalog form.
[0033] The present invention provides an automated design method for an engineering drawing catalog, enabling automated design and rendering of an engineering drawing catalog, significantly improving production efficiency. The present invention provides a method and system for automated design of an engineering drawing catalog. Based on Excel spreadsheet data, the method enables automated and rapid creation, editing, layout, and continuous layout of drawing frames for an engineering drawing catalog within a CAD model space. Designers simply enter the corresponding drawing catalog information into an Excel spreadsheet to automatically design and render the engineering drawing catalog. This eliminates the need for extensive manual work within the CAD model space.
[0034] By programming the method of the present invention into an AutoCAD secondary development program, a large number of steps that require manual operation can be converted to computer-automated calculations, thereby improving production efficiency. Using existing production methods, manually creating and editing text, drawing catalog tables, and drawing frames in the CAD model space for any professional design drawing catalog in an engineering project would require approximately 0.5 working days. However, using the method and embodiments of the present invention, automatic drawing can be completed in just 0.5 hours, significantly improving production efficiency. BRIEF DESCRIPTION OF THE DRAWINGS
[0035] Figure 1 is a flow chart of the method of the present invention;
[0036] Figure 2 The present invention is a schematic diagram of the principle of generating an engineering design drawing catalog according to an embodiment of the present invention. DETAILED DESCRIPTION
[0037] The following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative efforts are within the scope of protection of the present invention.
[0038] The preferred embodiments of the present invention are described in further detail below with reference to the accompanying drawings.
[0039] Example 1:
[0040] The present invention provides an automated design method for an engineering design drawing catalog. Figure 1 ,The automated design method for the engineering design drawing catalog includes the following steps:
[0041] S1. Input engineering design drawing catalog information. In step S1, inputting engineering design drawing catalog information refers to filling in the catalog information of a specified engineering project in an engineering design drawing catalog template file; the engineering design drawing catalog template file is an Excel document in xlsx format or xls format.
[0042] S2. Reading engineering design drawing catalog data. In step S2, the engineering design drawing catalog data is read from the engineering design drawing catalog template file in step S1 in a specified row and column and stored in a two-dimensional text array.
[0043] Combine Figure 2 A schematic diagram of the principle of generating an engineering design drawing catalogue in an embodiment of the present invention is shown. In the figure, the catalogue is in table form. The header content and specific content in the table can be ignored. S3, selecting the insertion point of the engineering design drawing catalogue frame, and automatically arranging the engineering design drawing catalogue frame and the catalogue table. The S3 step specifically includes: obtaining the insertion point of the engineering design drawing catalogue frame by inputting coordinates or manually selecting in the model space, defining the insertion point of the engineering design drawing catalogue frame as P M The engineering design drawing catalog frame and catalog table are stored in dwg file format. You can obtain the design drawing catalog frame and catalog table dwg format file corresponding to the engineering project by selecting the file or entering the file path. M Then, insert the engineering design drawing catalog frame and catalog table into the model space in the form of blocks, with the insertion point being P M ,like Figure 2 Insertion point in the label.
[0044] S4. Get the plane position of the catalog table in the engineering design drawing catalog frame; the plane position is represented by the relative plane relationship between the center point of the first row and first column cell in the catalog table and the insertion point in step S3. In step S4: define the center point of the first row and first column cell in the catalog table definition With step S3 P M The distance in the X-axis direction is X M ,definition With P M The Y-axis distance is Y M ,like Figure 2 The X and Y axes and the corresponding coordinate calculations mentioned in the present invention all adopt the Cartesian plane rectangular coordinate system.
[0045] S5, set the row spacing and column spacing of the catalog table; in step S5, the row spacing is the vertical distance between the center points of two adjacent rows in the catalog table, and the column spacing is the horizontal distance between the center points of two adjacent columns in the catalog table. Define the row spacing from row i to row i+1 of the catalog table as like Figure 2 The row spacing of the serial number column in the generation principle diagram is shown in the figure. The column spacing from column j to column j+1 in the catalog table is W. j M ,like Figure 2 The column spacing in the serial number column is indicated by the markings, i and j are both positive integers.
[0046] S6. Automatically fill in the engineering design drawing catalog content in the catalog table to complete the engineering design drawing catalog design. The catalog content is all single-line text, and the text rotation angle is 0°. Step S6 specifically includes:
[0047] The content of the directory in row i and column j in the directory table is read from row i and column j of the two-dimensional text array in step S2; the insertion point of the single-line text is defined as Figure 2 Take the first row and first column as an example, and use the middle point of the single-line text as the insertion base point. i and j are both positive integers. Finally, set the single-line text font style, including font, size, and color. coordinate Calculated as follows:
[0048]
[0049]
[0050] In the above formula, are respectively the engineering design drawing catalog frame insertion point P in step S3 M The X-axis and Y-axis coordinates, k is the mathematical summation symbol variable, X M 、Y M Respectively as described in step S4 With P M The distance in the X-axis direction and the distance in the Y-axis direction.
[0051] The present invention also provides an automated design system for an engineering design drawing catalog, which uses an automated design method for an engineering design drawing catalog. The system includes:
[0052] Engineering design drawing catalog data input module, used to input engineering design drawing catalog information and read engineering design drawing catalog data;
[0053] The module for automatically arranging the drawing frame and table of contents of engineering design drawings can obtain the insertion point of the drawing frame of engineering design drawings by inputting coordinates or manually selecting in the CAD model space, and automatically arrange the drawing frame and table of contents of engineering design drawings;
[0054] The module for automatically generating the catalog content of engineering design drawings automatically calculates the insertion point and fills in and formats the catalog content of engineering design drawings in the catalog form according to the plane position, row spacing and column spacing parameters of the catalog form.
[0055] The present invention also provides an automated design device for an engineering design drawing catalog, which includes a processor, a memory, and a computer storage medium.
[0056] The processor is used to run one or more program instructions to execute any method step in the method for automated design of an engineering design drawing catalog of the present invention.
[0057] The memory is used to store one or more program instructions.
[0058] The computer storage medium includes one or more program instructions, and the one or more program instructions are used to execute any method step in a method for automated design of an engineering design drawing catalog.
[0059] The present invention provides an automated design method for an engineering drawing catalog, enabling automated design and rendering of an engineering drawing catalog, significantly improving production efficiency. The present invention provides a method and system for automated design of an engineering drawing catalog. Based on Excel spreadsheet data, the method enables automated and rapid creation, editing, layout, and continuous layout of drawing frames for an engineering drawing catalog within a CAD model space. Designers simply enter the corresponding drawing catalog information into an Excel spreadsheet to automatically design and render the engineering drawing catalog. This eliminates the need for extensive manual work within the CAD model space.
[0060] By programming the method of the present invention into an AutoCAD secondary development program, a large number of steps that require manual operation can be converted to computer-automated calculations, thereby improving production efficiency. Using existing production methods, manually creating and editing text, drawing catalog tables, and drawing frames in the CAD model space for any professional design drawing catalog in an engineering project would require approximately 0.5 working days. However, using the method and embodiments of the present invention, automatic drawing can be completed in just 0.5 hours, significantly improving production efficiency.
[0061] The above is a further detailed description of the present invention in conjunction with specific preferred embodiments, and the specific implementation of the present invention should not be considered to be limited to these descriptions. For those skilled in the art to which the present invention belongs, several simple deductions or substitutions can be made without departing from the concept of the present invention, and all of these should be considered to fall within the scope of protection of the present invention.
Claims
1. A method for automated design of an engineering design drawing catalogue, characterized in that: The steps include: S1. Input engineering design drawing catalog information; S2. Read engineering design drawing catalog data; S3. Select the insertion point of the engineering design drawing catalog frame and automatically arrange the engineering design drawing catalog frame and catalog table; The S3 step specifically includes: S31, the engineering design drawing catalog frame insertion point is obtained by inputting coordinates or manually selecting in the model space, and the engineering design drawing catalog frame insertion point is defined as P M ; S32. Select the insertion point P of the engineering design drawing catalog frame M Then, insert the engineering design drawing catalog frame and catalog table into the model space in the form of a block, with the insertion base point being the lower left corner of the engineering design drawing catalog library; the engineering design drawing catalog frame and catalog table are stored in dwg file format, and the design drawing catalog frame and catalog table dwg format file corresponding to the engineering project is obtained by selecting a file or entering a file path; S4. Obtaining the planar position of the catalog table in the engineering design drawing catalog frame; the planar position is represented by the relative planar relationship between the center point of the first row and first column cell in the catalog table and the insertion point in step S3; In the S4 step: Define the center point of the cell in the first row and first column of the directory table Definition With the P described in step S3 M The X-axis distance is X M ,definition With P M The Y-axis distance is Y M ; S5. Set the row and column spacing of the directory table; S6. Automatically fill in the engineering design drawing catalog content in the catalog form to complete the engineering design drawing catalog design; The S6 step specifically includes: S61, the directory content in the i-th row and j-th column of the directory table is read from the i-th row and j-th column of the two-dimensional text array in step S2; S62. Define the single-line text insertion point as The middle point of a single line of text is used as the insertion base point; S63. Set the font style of single-line text, including font, size, and color.
2. The method for automated design of an engineering design drawing catalogue according to claim 1, characterized in that: In step S1, inputting engineering design drawing catalog information refers to filling in the catalog information of the specified engineering project in the engineering design drawing catalog template file; the engineering design drawing catalog template file is an Excel document in xlsx format or xls format.
3. The method for automated design of an engineering design drawing catalogue according to claim 1, characterized in that: In step S2, the engineering design drawing catalog data is read from the specified row and specified column of the engineering design drawing catalog template file in step S1 and stored in the form of a two-dimensional text array.
4. The method for automated design of an engineering design drawing catalogue according to claim 1, characterized in that: In step S5, the row spacing is the vertical distance between the center points of two adjacent rows in the directory table, and the column spacing is the horizontal distance between the center points of two adjacent columns in the directory table.
5. The method for automated design of an engineering design drawing catalogue according to claim 4, characterized in that: Define the row spacing from row i to row i+1 of the directory table as The column distance from column j to column j+1 in the catalog table is i and j are both positive integers.
6. The method for automated design of an engineering design drawing catalogue according to claim 5, characterized in that: The single-line text insertion point coordinate Calculated as follows: In the above formula, are respectively the engineering design drawing catalog frame insertion point P in step S3 M The X-axis and Y-axis coordinates, k is the mathematical summation symbol variable, X M 、Y M Respectively as described in step S4 With P M The distance in the X-axis direction and the distance in the Y-axis direction.
7. The method for automated design of an engineering design drawing catalogue according to claim 1, characterized in that: The X-axis, Y-axis and corresponding coordinate calculations all adopt the Cartesian plane rectangular coordinate system.
8. An automated design system for an engineering design drawing catalog, applying an automated design method for an engineering design drawing catalog according to any one of claims 1 to 6, characterized in that: The system comprises: Engineering design drawing catalog data input module, used to input engineering design drawing catalog information and read engineering design drawing catalog data; The module for automatically arranging the drawing frame and table of contents of engineering design drawings can obtain the insertion point of the drawing frame of engineering design drawings by inputting coordinates or manually selecting in the CAD model space, and automatically arrange the drawing frame and table of contents of engineering design drawings; The module for automatically generating the catalog content of engineering design drawings automatically calculates the insertion point and fills in and formats the catalog content of engineering design drawings in the catalog form according to the plane position, row spacing and column spacing parameters of the catalog form.
Citation Information
Patent Citations
Directory typesetting method and device based on table and storage medium
CN111144069A
Method for self-generating construction drawing plane directory based on BIM drawing tree
CN116778026A