Cable inventory generation method applied to secondary terminal wiring diagram information extraction

Abstract

The invention relates to the technical field of cable inventory, in particular to a cable inventory generation method applied to secondary terminal wiring diagram information extraction, which comprises the following steps of: 1, configuring a cable model; 2, extracting and identifying cable information; and step 3, generating and exporting the cable inventory, so that automatic generation of the cable inventory is realized, verification is performed, abnormal data is reminded and marked, the working pressure of secondary designers is reduced, the checking time of the secondary cable inventory is shortened, and the accuracy and quality of the electrical secondary cable inventory are improved.

Description

Technical Field

[0001] The invention relates to the technical field of cable inventories, and in particular to a cable inventory generation method for extracting secondary terminal wiring diagram information. Background Art

[0002] The preparation of the secondary cable inventory of a substation is an important design task. It is used as a basis for laying out cables (i.e. laying cables) and guiding construction, and is also important equipment data for the operation and maintenance of substation equipment. The cable inventory mainly consists of cable number, cable model and cross-section, number of spare cores, cable starting point, cable end point, length, etc.

[0003] At present, in the electrical secondary professional design technology, it is usually adopted to manually compile and proofread the cable list under AUTOCAD drawing software. Now the method for designers to compile the cable list is to manually edit it in Excel, looking at the CAD drawings and typing in the numbers, cable models and cross-sections, number of spare cores, cable starting points, cable end points, lengths and other contents of thousands of cables one by one. Then, through the manual verification method, one person reports the cable number, cable model, and number of cable cores of the equipment on this side, and the other person goes to the equipment on the opposite side to find the corresponding cable number and judge whether the cable model and number of cable cores on both sides are consistent. If both sides are consistent, the cable is considered to match.

[0004] However, according to project design experience, this method has many problems: first, the workload is huge and the verification efficiency is low. For a 220kV substation project, the number of equipment reaches nearly 100 and the number of cables used reaches several thousand, which brings huge pressure to the cable inventory verification of electrical secondary designers; although the automatic generation method of the cable inventory of an automatic control system disclosed in the publication number CN113268966A realizes the automatic generation of the cable inventory, the verification quality is not high and the error is large. After manual verification, there are still some problems in the cable inventory where the cable models on both sides do not match, the number of cable cores does not match, and the cable numbers are missing and repeated on the opposite sides.

[0005] Therefore, there is an urgent need for a set of tools that can quickly and accurately identify problematic cables and the corresponding problem types. Summary of the invention

[0006] The technical problem to be solved by the present invention is to overcome the deficiencies of the prior art and provide a cable inventory generation method for extracting secondary terminal wiring diagram information.

[0007] The technical solution adopted by the present invention to solve the technical problem is: a cable inventory generation method applied to secondary terminal wiring diagram information extraction comprises the following steps:

[0008] Step 1: Configure the cable model;

[0009] Step 2: Extract and identify cable information;

[0010] Step 3: Generate and export the cable inventory.

[0011] The cable model configured in step 1 includes pre-configured common cable model information, including the abbreviation and full name of the cable model;

[0012] Cable model information can be added and modified.

[0013] In the step 2, the terminal block cable diagram in the CAD file is automatically identified, and relevant cable information is extracted.

[0014] The cable information extracted in step 2 includes the number of cores, core length, cable length, flipping status, cable extension, model, starting point, end point, etc.;

[0015] The extracted cable information is stored in the database of the engineering project.

[0016] In the step 2, for the terminal block cable diagram with multiple cables, custom attributes are added to the cable block through dynamic block technology, and the drawing expansion table is identified, so as to split the cables.

[0017] The dynamic block technology includes the following sub-steps:

[0018] 2-1: Add custom attributes to the drawing frame to identify the drawing frame information;

[0019] 2-2: After identifying the frame, calculate the inner frame range of the frame;

[0020] 2-3: Find the expanded table text in the lower right corner of the rectangle, find the line segment and text below the y-axis of the text, splice the line segments into a table, and match the text with the spliced ​​table according to the center position to form an expanded relationship.

[0021] The drawing frame information in 2-1 includes project name, design stage, drawing name, drawing number, etc.

[0022] The step three includes the following sub-steps:

[0023] 3-1: Sort the cables according to the extracted cable information;

[0024] 3-2: Match the cables of the same loop and generate a cable list;

[0025] 3-3: Verify the cable inventory, filter out abnormal data and mark them;

[0026] 3-4: Export the cable inventory.

[0027] During the generation of the cable inventory in 3-3, the model, chip and other data of the cables of the equipment on both sides are compared, and the type of problematic cables is determined by the circular cross method, and abnormal data is reminded and marked. Specifically, starting from the first device, that is, the starting point to the end point are AB and BA respectively, the cable characteristics of the device are cross-compared with other subsequent devices, and the problematic cable numbers are screened out according to the comparison results. Repeat this step to obtain all problematic cables, and remind and mark abnormal data. In the case where the number of cores at the starting point and the end point of the cable are inconsistent, it will also be marked in the final exported Excel.

[0028] Compared with the prior art, the present invention has the following beneficial effects:

[0029] 1. High reliability: Automatically identify and extract information, prompt and mark abnormal information, effectively improve the quality of electrical secondary design; strong versatility: just draw the cable according to the specification, it can be applied to all secondary design terminal drawings; compliance with the specification: cable model specifications and the generated cable list, symbol design institute's electrical secondary design specifications; one-click operation: based on this method, users only need to export the cable with one click to generate the cable list corresponding to the CAD file;

[0030] 2. Reduce production costs: It can accurately and efficiently generate cable lists, provide strong guidance for on-site secondary cable construction and layout, and reduce construction costs caused by design errors; Reduce design time: It can quickly and accurately obtain the problem cable number and generate a cable list, greatly saving design time;

[0031] 3. It can prevent and control the quality of electrical secondary design results, reduce errors in the design process, and ensure the smooth progress of substation construction. BRIEF DESCRIPTION OF THE DRAWINGS

[0032] Figure 1 A schematic diagram of a cable inventory generated for the present invention;

[0033] Figure 2 This is a schematic diagram of the cable model configuration interface of the present invention;

[0034] Figure 3 This is a schematic diagram of abnormal data prompting of the present invention. DETAILED DESCRIPTION

[0035] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. 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 creative work are within the scope of protection of the present invention.

[0036] Reference Figure 1-Figure 3 This application adopts the form of CAD secondary development as a whole, and consists of three parts: cable model configuration, automatic information identification and extraction, and export list. Specifically,

[0037] The cable inventory generation method for extracting secondary terminal wiring diagram information includes the following steps:

[0038] Step 1: configure the cable model; the cable model configured in step 1 includes pre-configured common cable model information, including the abbreviation and full name of the cable model;

[0039] Cable model information can be added and modified.

[0040] Step 2: Extract and identify cable information; in the step 2, the terminal block cable diagram in the CAD file is automatically identified and the relevant cable information is extracted.

[0041] The cable information extracted in step 2 includes the number of cores, core length, cable length, flipping status, cable extension, model, starting point, end point, etc.;

[0042] The extracted cable information is stored in the database of the engineering project.

[0043] In the step 2, for the terminal block cable diagram with multiple cables, custom attributes are added to the cable block through dynamic block technology, and the drawing expansion table is identified, so as to split the cables.

[0044] The dynamic block technology includes the following sub-steps:

[0045] 2-1: Add custom attributes to the drawing frame to identify the drawing frame information in the drawing; the drawing frame information in 2-1 includes the project name, design stage, drawing name, drawing number, etc.

[0046] 2-2: After identifying the frame, calculate the inner frame range of the frame;

[0047] 2-3: Find the expanded table text in the lower right corner of the rectangle, find the line segment and text below the y-axis of the text, splice the line segments into a table, and match the text with the spliced ​​table according to the center position to form an expanded relationship.

[0048] Step 3: Generate and export the cable inventory.

[0049] The step three includes the following sub-steps:

[0050] 3-1: Sort the cables according to the extracted cable information;

[0051] 3-2: Match the cables of the same loop and generate a cable list;

[0052] 3-3: Verify the cable inventory, filter out abnormal data and mark them;

[0053] During the generation of the cable inventory in 3-3, the model, chip and other data of the cables of the equipment on both sides are compared, and the type of problematic cables is determined by the circular cross method, and abnormal data is reminded and marked. Specifically, starting from the first device, that is, the starting point to the end point are AB and BA respectively, the cable characteristics of the device are cross-compared with other subsequent devices, and the problematic cable numbers are screened out according to the comparison results. Repeat this step to obtain all problematic cables, and remind and mark abnormal data. In the case where the number of cores at the starting point and the end point of the cable are inconsistent, it will also be marked in the final exported Excel.

[0054] 3-4: Export the cable inventory.

[0055] This application not only realizes the automatic generation of cable lists, but also performs verification, reminds and marks abnormal data, reduces the work pressure of secondary designers, reduces the time for checking secondary cable lists, and improves the accuracy and quality of electrical secondary cable lists.

[0056] The above descriptions are only optional embodiments of the present invention, and are not intended to limit the patent scope of the present invention. All equivalent structural changes made using the contents of the present invention's specification and drawings, or directly / indirectly applied in other related technical fields, are included in the patent protection scope of the present invention.

Claims

1. A cable inventory generation method for extracting secondary terminal wiring diagram information, characterized in that: The steps include: Step 1: Configure the cable model; Step 2: Extract and identify cable information; Step 3: Generate and export the cable inventory.

2. The cable inventory generation method for secondary terminal wiring diagram information extraction according to claim 1 is characterized in that: The cable model configured in step 1 includes pre-configured common cable model information, including the abbreviation and full name of the cable model; Cable model information can be added and modified.

3. The cable inventory generation method for extracting secondary terminal wiring diagram information according to claim 1 is characterized in that: In the step 2, the terminal block cable diagram in the CAD file is automatically identified, and relevant cable information is extracted.

4. The cable inventory generation method for secondary terminal wiring diagram information extraction according to claim 3 is characterized in that: The cable information extracted in step 2 includes the number of cores, core length, cable length, flipping status, cable extension, model, starting point, and end point; The extracted cable information is stored in the database of the engineering project.

5. The cable inventory generation method for secondary terminal wiring diagram information extraction according to claim 3 is characterized in that: In the step 2, for the terminal block cable diagram with multiple cables, custom attributes are added to the cable block through dynamic block technology, and the drawing expansion table is identified, so as to split the cables.

6. The cable inventory generation method for extracting secondary terminal wiring diagram information according to claim 5 is characterized in that: The dynamic block technology includes the following sub-steps: 2-1: Add custom attributes to the drawing frame to identify the drawing frame information; 2-2: After identifying the frame, calculate the inner frame range of the frame; 2-3: Expand the table text, find the line segments and text below the y-axis of the text, splice the line segments into a table, match the spliced ​​table according to the center position, and form an expansion relationship.

7. The cable inventory generation method for secondary terminal wiring diagram information extraction according to claim 6 is characterized in that: The drawing frame information in 2-1 includes the project name, design stage, drawing name, and drawing number.

8. The cable inventory generation method for extracting secondary terminal wiring diagram information according to claim 6, characterized in that: The step three includes the following sub-steps: 3-1: Sort the cables according to the extracted cable information; 3-2: Match the cables of the same loop and generate a cable list; 3-3: Verify the cable inventory, filter out abnormal data and mark them; 3-4: Export the cable inventory.

9. The cable inventory generation method for extracting secondary terminal wiring diagram information according to claim 8, characterized in that: During the generation of the cable inventory in 3-3, the models and chip data of the cables of the equipment on both sides are compared, and the circular cross method is used to determine the type of problematic cables, and abnormal data is reminded and marked.

Images