Method for compiling pipeline characteristic table

Abstract

The invention relates to the technical field of engineering design, in particular to a method for compiling a pipeline characteristic table. The method comprises the following steps: S1, drawing a PIN diagram by using AutoCAD software; s2, establishing a corresponding block attribute for each pipeline, including inserting the block attribute near each pipeline in the PIN diagram, the block attribute having an explicit attribute and a plurality of implicit attributes, the explicit attribute being a pipeline label number, and the plurality of implicit attributes including pipeline parameters and pipeline properties; editing a corresponding block attribute according to the attribute value of each pipeline; and S3, selecting block attributes corresponding to pipelines needing to be exported in the PIN diagram, exporting the selected block attributes, and forming a pipeline characteristic table in Excel software. By adopting the method provided by the invention, the consistency and correctness of the data are ensured, a large amount of time cost is saved, and the technical problem in the field of engineering design is solved.

Description

Technical Field

[0001] The present invention relates to the technical field of engineering design, and particularly to a method for compiling a pipeline characteristic table. Background Art

[0002] In the field of engineering design, a Piping & Instrument Diagram (PID) includes all equipment, pipelines, valves, instruments, etc. The PID diagram is usually drawn using AutoCAD drawing software, and the pipeline is a line segment used to represent the pipeline in the PID drawing.

[0003] The pipeline characteristic table is a table representing various parameters and properties of pipelines. Each pipeline includes dozens of data such as medium physical properties, pipeline start and end points, operating parameters, and design parameters. The pipeline characteristic table is usually compiled using software such as Excel, and is usually used as technical data for providing information to other specialties together with the PID Figure 1 diagram.

[0004] Most of the existing technologies form the pipeline characteristic table by manually inputting pipeline data by engineering designers. This method requires staff to count the pipelines by visually comparing with the PID diagram and input the parameters and properties of the corresponding pipelines into the table. The whole process is not only time-consuming and laborious, but also very error-prone. In addition, the PID diagram often needs to be modified and updated, and pipelines in the diagram need to be added or deleted. In the face of this situation, engineering designers can only create a new pipeline characteristic table from scratch, which not only further increases the labor intensity, but also it is difficult to ensure data consistency between charts. Summary of the Invention

[0005] The purpose of the present invention is to provide a method for compiling a pipeline characteristic table to solve the technical problems such as time-consuming, laborious, error-prone, and difficult to ensure data consistency between charts in the method of forming a pipeline characteristic table by manually inputting pipeline data in the existing technology.

[0006] To achieve the above purpose, the present invention adopts the following technical solutions:

[0007] A method for compiling a pipeline characteristic table includes the following steps:

[0008] S1: Draw a PIN diagram using AutoCAD software;

[0009] S2: Establish corresponding block attributes for each pipeline, including:

[0010] Insert block attributes near each pipeline in the PIN diagram. The block attributes have an explicit attribute and several implicit attributes. The explicit attribute is the pipeline marking number, and the several implicit attributes include pipeline parameters and pipeline properties;

[0011] Edit the corresponding block attributes according to the attribute values of each pipeline;

[0012] S3: Select the block attributes corresponding to the pipelines to be exported in the PIN diagram, export the selected block attributes, and form a pipeline characteristic table in Excel software.

[0013] Furthermore, the step S2 further includes the steps before inserting block attributes near each pipeline in the PIN diagram:

[0014] Judge whether there are defined block attributes in the PIN diagram;

[0015] If so, insert internal block attributes near each pipeline;

[0016] If not, insert external block attributes near each pipeline, or define block attributes in the diagram.

[0017] Furthermore, the step of defining block attributes in the diagram includes:

[0018] Define an explicit attribute and several implicit attributes in the diagram;

[0019] Select the explicit attribute and all the implicit attributes and convert them into a block.

[0020] Furthermore, the step S2 further includes the steps after inserting block attributes near each pipeline in the PIN diagram:

[0021] Create a group for each pipeline and its corresponding block attributes.

[0022] Furthermore, the step of editing the corresponding block attributes according to the attribute values of each pipeline includes:

[0023] Select the block attributes to be edited, and the property panel synchronously displays the property tables of the selected block attributes;

[0024] Input the attribute values of the corresponding pipeline into the property tables displayed in the property panel.

[0025] Furthermore, in the step S3, the step of exporting the selected block attributes includes:

[0026] Start Excel software and create a new workbook based on a specified template;

[0027] Execute the export command and traverse the selected block attributes in the PIN diagram;

[0028] Import all the attributes in the selected block attributes into the newly created workbook, edit and save.

[0029] Further, the pipeline marking number includes the pipe section number, pipe diameter, pipeline grade, and heat insulation and sound insulation code.

[0030] Further, the pipeline parameters include pipeline specifications, pipeline material grades, pressure pipeline levels, flow chart tail numbers, medium names, medium states, pipeline starting points, pipeline ending points, working pressures, working temperatures, design pressures, and design temperatures.

[0031] Further, the pipeline properties include heat insulation codes, heat insulation materials, heat insulation thicknesses, anti-corrosion, inspection grades, weld requirements, pressure test media, pressure test pressures, leak test media, leak test pressures, and cleaning media.

[0032] Advantages of the present invention:

[0033] The method for compiling the pipeline characteristic table provided by the present invention includes the following steps:

[0034] S1: Use AutoCAD software to draw the PIN diagram;

[0035] S2: Establish corresponding block attributes for each pipeline, including:

[0036] Insert block attributes near each pipeline in the PIN diagram. The block attributes have one explicit attribute and several implicit attributes. The explicit attribute is the pipeline marking number, and several of the implicit attributes include pipeline parameters and pipeline properties;

[0037] Edit the corresponding block attributes according to the attribute values of each pipeline;

[0038] S3: Select the block attributes corresponding to the pipelines to be exported in the PIN diagram, export the selected block attributes, and form a pipeline characteristic table in Excel software.

[0039] When using the method provided by the present invention to draw a PID diagram, a block attribute is inserted near each pipeline in the diagram, and the user can edit all the attribute values within the block attribute through the "Properties Palette". The block attribute has one explicit attribute and dozens of implicit attributes. Therefore, only the explicit attribute is displayed in the PID diagram, while the implicit attributes are not displayed, thus avoiding the phenomenon of block attributes obscuring the lines and ensuring the cleanliness and tidiness of the PID diagram. When it is necessary to create a pipeline characteristics table, the user only needs to click on the menu command to automatically export all the attribute values of the selected block attributes in the PID diagram into an Excel-formatted table. Since this method is a one-way output from the CAD software to the Excel software and is completely executed by a computer program, it ensures the consistency and correctness of the data, eliminates the human errors of the original method, saves a large amount of time costs, and solves the technical problems in the field of engineering design. In addition, due to the use of block attributes, the insertion and modification of pipeline number markings in the PID diagram are more convenient, further improving the work efficiency and accuracy. BRIEF DESCRIPTION OF THE DRAWINGS

[0040] In order to more clearly illustrate the specific embodiments of the present invention or the technical solutions in the prior art, the following will briefly introduce the drawings required for the description of the specific embodiments or the prior art. Obviously, the following-described drawings are some embodiments of the present invention. For those of ordinary skill in the art, without creative efforts, other drawings can be obtained based on these drawings.

[0041] Figure 1 The specific flowchart for establishing corresponding block attributes for each pipeline in the method provided by the embodiment of the present invention;

[0042] Figure 2 The specific flowchart for exporting the pipeline characteristics table in the method provided by the embodiment of the present invention;

[0043] Figure 3 The content of the pipeline number marking in the method provided by the embodiment of the present invention;

[0044] Figure 4 The display diagram of the Properties Palette after selecting the block attribute in the method provided by the embodiment of the present invention.

[0045] Figure 5 The first program code for exporting the block attribute in the method provided by the embodiment of the present invention;

[0046] Figure 6 The second program code for exporting the block attribute in the method provided by the embodiment of the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0047] The technical solution of the present invention will be clearly and completely described below in conjunction with the embodiments. Obviously, the described embodiments are part of the embodiments of the present invention, rather than all of the embodiments. All other embodiments obtained by those of ordinary skill in the art based on the embodiments of the present invention without creative efforts shall fall within the protection scope of the present invention.

[0048] An embodiment of the present invention provides a method for compiling a pipeline characteristic table. Refer to Figures 1 to 6 , the method includes the following steps:

[0049] S1: Use AutoCAD software to draw a PIN diagram.

[0050] The PIN diagram is the process pipeline and instrumentation diagram, which contains all the equipment, pipelines, valves, instruments, etc.

[0051] S2: Establish corresponding block attributes for each pipeline, including:

[0052] Insert block attributes near each pipeline in the PIN diagram. The block attributes have an explicit attribute and several implicit attributes. The explicit attribute is the pipeline label number, and several of the implicit attributes include pipeline parameters and pipeline properties;

[0053] Edit the corresponding block attributes according to the attribute values of each pipeline.

[0054] Refer to Figure 1 , the step S2 further includes the steps before inserting block attributes near each pipeline in the PIN diagram:

[0055] Judge whether there are already defined block attributes in the PIN diagram;

[0056] If so, insert internal block attributes near each pipeline;

[0057] If not, insert external block attributes near each pipeline, or define block attributes in the drawing.

[0058] Among them, the step of defining block attributes in the drawing includes:

[0059] Define an explicit attribute and several implicit attributes in the drawing. The explicit attribute is the pipeline label number, and several of the implicit attributes include pipeline parameters and pipeline properties;

[0060] Select the explicit attribute and all the implicit attributes and convert them into a block.

[0061] The specific operation process is as follows: using the "Block Definition - Define Attributes" function of CAD software, define an explicit attribute (i.e., visible attribute) and several implicit attributes (i.e., invisible attributes); then, using the "Block Definition - Create Block" function of CAD software, convert the explicit attribute and all implicit attributes into a block. The defined block attributes only display the attribute values of the pipeline marking numbers in the drawing (such as Figure 3 shown), and other attribute values are not displayed.

[0062] Among them, the pipeline marking number includes the pipe section number, pipe diameter, pipeline grade, and adiabatic and sound insulation code (such as Figure 3 shown).

[0063] Among them, the pipeline parameters include pipeline specifications, pipeline material grades, pressure pipeline levels, flowchart tail numbers, medium names, medium states, pipeline starting points, pipeline ending points, working pressures, working temperatures, design pressures, and design temperatures.

[0064] Among them, the pipeline properties include adiabatic code, adiabatic material, adiabatic thickness, anti-corrosion, inspection grade, weld requirements, pressure test medium, pressure test pressure, leak test medium, leak test pressure, and cleaning medium.

[0065] Furthermore, the step of editing the corresponding block attributes according to the attribute values of each pipeline includes:

[0066] Select the block attribute to be edited, and the property panel synchronously displays the property tables of the selected block attribute (such as Figure 4 shown);

[0067] Input the attribute values of the corresponding pipeline into the property table displayed in the property panel.

[0068] Furthermore, the step S2 also includes the step after inserting the block attributes near each pipeline in the PIN drawing: creating a group for each pipeline and its corresponding block attribute. In this way, when adding, deleting, or modifying pipelines, it is not easy to miss the corresponding block attributes, and when editing the block attributes corresponding to one pipeline, it is not easy to select the wrong ones; in addition, the pipelines and block attributes can be modified independently.

[0069] S3: Select the block attributes corresponding to the pipelines to be exported in the PIN drawing, export the selected block attributes, and form a pipeline characteristic table in Excel software.

[0070] Referring to Figure 2 , in the step S3, the step of exporting the selected block attributes includes:

[0071] Start Excel software and create a new workbook based on a specified template;

[0072] Execute the export command and traverse the selected block attributes in the PIN diagram;

[0073] Import all the attributes within the selected block attributes into a newly created workbook, edit and save it.

[0074] Among them, after importing all the attributes within the selected block attributes into the newly created workbook, merge cells and add cell border lines as needed to form a qualified pipeline characteristics table. The prepared pipeline characteristics table is shown in Table 1.

[0075] Table 1 Pipeline Characteristics Table

[0076]

[0077] Since the COM interface is supported between AutoCAD software and Excel software, edit the program code for exporting block attributes and edit the code segment for automatically starting Excel software in the code. Then, when it is necessary to compile the pipeline characteristics table, execute the export command to achieve seamless data transfer between AutoCAD software and Excel software.

[0078] The program code for exporting block attributes is as Figure 5 and Figure 6 shown. Among them: The variables FilterType and FilterData in the program code are used to construct the filtering conditions for all selected block references in the diagram (each block attribute is a block reference); the variable SS is the set of all selected block attributes. Therefore, next, traverse SS in the For loop, the variable E is one of the block attributes, and the variable ATs is all the attributes of E, that is, ATs includes all the attributes of a pipeline; CreateObject("Excel.Application") in the code is used to automatically start Excel software.

[0079] The method provided by the present invention will be further described below with specific embodiments.

[0080] For a certain engineering project, the process specialty needs to draw two PID diagrams, and each PID diagram involves about 20 pipelines; correspondingly, two pipeline characteristics tables also need to be made. Arrange a designer to complete the above tasks using the traditional method (i.e., the method of manually filling in the pipeline characteristics table) and the method proposed by the present invention respectively. The time used is shown in Table 2.

[0081] Table 2 Comparison Table of Time Used by the Traditional Method and the Method Proposed by the Present Invention

[0082] Comparison items Traditional method Method of the present invention · Drawing pipelines and inserting pipeline number markings 2 working days 2 working days ● Time taken for editing block attributes 0 1 working day ● Time taken for making pipeline characteristic tables 3 working days 0

[0083] According to the comparison results, it can be seen that in the method proposed by the present invention, the work of designers mainly focuses on CAD software and does not need to be operated in Excel, which improves work efficiency and accuracy.

[0084] In summary, when using the method provided by the present invention to draw a PID diagram, a block attribute is inserted near each pipeline in the diagram, and the user can edit all the attribute values in the block attribute through the "Properties Palette". The block attribute has one explicit attribute and dozens of implicit attributes. Therefore, only the explicit attribute is displayed in the PID diagram, while the implicit attributes are not displayed, thus avoiding the phenomenon of block attributes covering the lines and ensuring the cleanliness and tidiness of the PID diagram. When it is necessary to make a pipeline characteristic table, the user only needs to click the menu command to automatically export all the attributes of the selected block attributes in the PID diagram into a table in Excel format. Since this method is a one-way output from CAD software to Excel software and is completely executed by a computer program, it ensures the consistency and correctness of the data, eliminates the human error of the original method, saves a large amount of time cost, and solves the technical problems in the field of engineering design. In addition, due to the use of block attributes, the insertion and modification of pipeline number markings in the PID diagram are more convenient, further improving work efficiency and accuracy.

[0085] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and are not intended to limit them. Although the present invention has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that they can still modify the technical solutions described in the foregoing embodiments, or perform equivalent replacements for some or all of the technical features; and these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present invention.

Claims

1. A method for compiling a pipeline characteristic table, characterized in that: The following steps are involved: S1: Draw the PIN diagram using AutoCAD software; S2: Establish corresponding block attributes for each pipeline, including: Inserting a block attribute near each pipeline in the PIN diagram, wherein the block attribute has an explicit attribute and a plurality of implicit attributes, wherein the explicit attribute is a pipeline label number, and the plurality of implicit attributes include pipeline parameters and pipeline properties; Edit the corresponding block attributes according to the attribute values ​​of each pipeline; S3: Select the block attributes corresponding to the pipelines to be exported in the PIN map, export the selected block attributes, and form a pipeline characteristic table in Excel software.

2. The method for compiling a pipeline characteristic table according to claim 1, characterized in that: The step S2 also includes the steps before inserting the block attributes near each pipeline in the PIN map: Determine whether there are defined block attributes in the PIN map; If so, insert the internal block attributes near each pipeline; If not, insert external block attributes near each pipeline, or define block attributes within the diagram.

3. The method for compiling a pipeline characteristic table according to claim 2, characterized in that: The steps for defining block attributes within a diagram include: Define an explicit attribute and several implicit attributes in the graph; The explicit attributes and all the implicit attributes are selected and converted into blocks.

4. The method for compiling a pipeline characteristic table according to claim 1, characterized in that: The step S2 also includes the steps of inserting block attributes near each pipeline in the PIN map: Create each pipeline and its corresponding block attributes as a group.

5. The method for compiling a pipeline characteristic table according to claim 1, characterized in that: The steps of editing the corresponding block attributes according to the attribute values ​​of each pipeline include: Select the block attribute to be edited, and the property panel will display the attribute tables of the selected block attribute synchronously; Enter the corresponding pipeline attribute values ​​into the attribute table displayed in the property panel.

6. The method for compiling a pipeline characteristic table according to claim 1, characterized in that: In step S3, the step of exporting the selected block attributes includes: Start Excel software and create a new workbook based on the specified template; Execute the export command to traverse the selected block attributes in the PIN map; Import all properties in the selected block property into the newly created workbook, edit and save.

7. The method for compiling a pipeline characteristic table according to any one of claims 1 to 6, characterized in that: The pipeline marking number includes the pipe section number, pipe diameter, pipeline grade and insulation and sound insulation code.

8. The method for compiling a pipeline characteristic table according to any one of claims 1 to 6, characterized in that: The pipeline parameters include pipeline specifications, pipeline material grade, pressure pipeline level, flow chart tail number, medium name, medium state, pipeline starting point, pipeline end point, working pressure, working temperature, design pressure and design temperature.

9. The method for compiling a pipeline characteristic table according to any one of claims 1 to 6, characterized in that: The pipeline properties include insulation code, insulation material, insulation thickness, corrosion resistance, inspection level, weld requirements, pressure test medium, pressure test pressure, leakage test medium, leakage test pressure and cleaning medium.

Images