An automatic checking method for electrical secondary cable inventory based on cable characteristic number

Abstract

The present invention discloses an automatic checking method for electrical secondary cable inventory based on cable characteristic number. It comprises the following steps: firstly, the table equipment data in the cable inventory is read and stored as a cell array, the cable number, cable model, and cable core number are extracted from the cell array and combined into a cable characteristic number; then, the cable characteristic number of the problematic cable and the corresponding cable number, cable model, and cable core number are obtained by cross-comparing the cable characteristic numbers of each equipment form; finally, the error type of the problematic cable is determined by cross-comparing the problematic cable number, model, and core number of each equipment form. The present invention solves the problem that the existing manual checking method for electrical secondary inventory is not only too time-consuming, but also has low checking accuracy; it has the advantages of being able to quickly obtain the problematic cable number and problem type in the cable inventory, reducing the cable inventory checking time of secondary designers, and reducing errors in the cable inventory, thereby improving the quality of the cable inventory.

Description

Technical Field

[0001] The invention relates to the field of electrical engineering, and more specifically to an automatic checking method for an electrical secondary cable inventory based on cable characteristic numbers. Background Art

[0002] Cable inventory is a commonly used form in the electrical secondary field. It is used as a basis for laying out cables and guiding construction. The cable inventory mainly consists of cable number, cable model, number of cores used, cable starting point, cable end point, and length. The cable number is a mark to identify the cable.

[0003] At present, the method for designers to compile cable lists is to manually copy, paste, edit, input or modify the cable model, cable number, cable starting point, cable end point, length and other contents in Excel, and then manually check the cable number, cable model, and cable core number 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 cable core number on both sides are consistent. If both sides are consistent, the cable is considered to be matched. However, according to project design experience, this method has many problems: First, the workload is huge and the checking efficiency is low. For a large 220kV booster station or substation project, the number of equipment reaches nearly 100 and the number of cables used reaches nearly thousands, which brings great pressure to the electrical secondary designer to check the cable list; the other is that the checking quality is not high and the error is large. After manual checking, there are still some problems in the cable list 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 side.

[0004] Therefore, it is urgent to develop an automatic verification method for electrical secondary cable lists that can quickly and accurately identify problem cables and the corresponding problem types to reduce the workload of secondary designers, reduce the time for checking secondary cable lists, and improve the accuracy and quality of electrical secondary cable lists. Summary of the invention

[0005] The purpose of the present invention is to provide an automatic checking method for an electrical secondary cable list based on cable characteristic numbers, which can automatically check the problematic cable numbers and the types of corresponding problems in each device in the cable list, reduce the cable list checking time of electrical secondary designers, reduce errors in the cable list, greatly improve the accuracy and quality of the electrical secondary cable list, and at the same time, through the accurate checking of the secondary cable list, it can also improve the quality and accuracy of the drawings, and has good application prospects and application value; it solves the problem that the existing manual checking method of the electrical secondary list is not only too time-consuming, but also has low checking accuracy, and the list after checking still has the problem of mismatching cable numbers, cable models, and cable core numbers between devices, and is not suitable for the "short, flat and fast" requirements of electrical secondary cable wiring and debugging of large-scale new energy projects (the reserved time for new energy electrical secondary cable wiring is only a dozen days, and the debugging time is only 3 days, therefore, the quality of the electrical secondary cable list affects the commissioning of the project).

[0006] In order to achieve the above object, the technical solution of the present invention is: a method for automatically checking the electrical secondary cable inventory based on the cable characteristic number, the electrical secondary cable inventory includes the cable number of the equipment, the cable model, the number of cable cores, the cable starting point and the cable end point and other information, characterized in that it includes the following steps,

[0007] Step 1: Read the electrical secondary cable inventory table data in the computer;

[0008] Step 2: Store the electrical secondary inventory table data as a cell array type;

[0009] Step 3: Combine the cable number, cable model, and cable core number in the cell array in the cable list into a cable characteristic number to determine whether the cables of the devices on both sides are consistent; if the cable characteristic numbers of the devices on both sides are inconsistent, it is determined that there is a problem with the cable;

[0010] Step 4: Circularly cross-compare the cable characteristic numbers, filter out the problematic cable characteristic number set, and obtain the corresponding problematic cable number, cable model, and cable core number;

[0011] Step 5: Obtain the opposite-side device list where the problematic cable number is located and its location in the opposite-side device list, and compare the cable models and core numbers of the devices on both sides to determine the type of problematic cable;

[0012] Step 6: Store and output the problem cable number and problem type.

[0013] In the above technical solution, in step 4, the method of cyclically cross-comparing the cable characteristic numbers includes the following steps:

[0014] Starting from the first device, the cable characteristic number in the device form is cross-compared with the cable characteristic number in the subsequent device form. If the cable characteristic numbers on both sides are consistent, the consistent cable characteristic numbers and the corresponding cable numbers, cable models and cable core counts in the device forms on both sides are removed at the same time, thereby filtering out the problematic cable characteristic numbers and the corresponding cable numbers, cable models and cable core counts in the first device form;

[0015] Repeat the above steps to obtain the problematic cable characteristic numbers and the corresponding cable numbers, cable models, and cable core counts in all device tables.

[0016] In the above technical solution, in step five, the problem types include missing equipment on the opposite side of the cable number, inconsistency between the cable models on both sides, inconsistency between the number of cable cores on both sides, and duplication of cable numbers.

[0017] In the above technical solution, in step 5, the method for determining the type of question includes the following steps:

[0018] Starting from the first device, cross the problematic cable number in the first device form with the problematic cable numbers in the remaining device forms. If there is no consistent cable number after crossing, cross the cable number with the cable numbers in the initial remaining device forms; if there is still no consistent cable number, it is determined that the opposite device of the cable number is missing; if there are two consistent cable numbers, it is determined that the cable number is repeated; if a consistent cable number is obtained after crossing, obtain the device form where the cable number is located and its position in the device form, and compare the cable models of the two. If the cable models are consistent, it is determined that the number of cable cores of the devices on both sides is inconsistent; if the cable models are inconsistent, it is determined that the cable models of the devices on both sides are inconsistent;

[0019] After comparison, the cable numbers of the equipment on the opposite side will be eliminated to avoid repeated comparison.

[0020] In the above technical solution, in step six, the method for storing the problem cable number and the problem cable type is: combining the problematic cable number and the problem type, and storing the problem type and the cable number in the corresponding device form in the form of a table.

[0021] The beneficial effects of the present invention are:

[0022] The present invention identifies the problematic cable number by comparing the cable characteristic number, and further quickly obtains the type of problem by comparing the problematic cable number, model and number of cores. The method can quickly identify the problematic cable and the problem type from the electrical secondary cable inventory form, which can not only reduce the electrical secondary cable inventory verification time, improve the verification efficiency, and reduce the pressure on electrical secondary designers, but also improve the quality of the electrical secondary cable inventory, which is particularly effective for large-scale new energy booster stations and substations. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] Figure 1 The present invention provides a flow chart of a method for automatically checking an electrical secondary cable inventory based on cable characteristic numbers.

[0024] Figure 2 This is a cable inventory table in an embodiment of the present invention.

[0025] Figure 3 This is a table of cable characteristic numbers for cable inventory problems in an embodiment of the present invention.

[0026] Figure 4 This is a table of cable inventory problem cables and problem types in an embodiment of the present invention. DETAILED DESCRIPTION

[0027] The following is a detailed description of the implementation of the present invention in conjunction with the accompanying drawings, but they do not constitute a limitation of the present invention and are only given as examples. At the same time, the advantages of the present invention are made clearer and easier to understand through the description.

[0028] Referring to the attached drawings, it can be seen that: a method for automatically checking the electrical secondary cable inventory based on the cable characteristic number, the cable inventory includes multiple equipment forms, each equipment form contains the equipment cable number, cable model, number of cable cores, cable starting point, cable end point, length and other information.

[0029] The method for automatically checking the electrical secondary cable inventory based on the cable characteristic number first reads the equipment table data in the electrical secondary cable inventory and stores it as a cell array, extracts the cable number, cable model, and cable core number in the cell array, and combines them into a cable characteristic number for judging whether the equipment cables on both sides are consistent; then cyclically cross-compares the cable characteristic numbers, screens out the problematic cable characteristic numbers, and stores the corresponding cable numbers, cable models, and cable core numbers; determines the problematic cable type by obtaining the equipment form where the problematic cable number is located and its position in the equipment form, and comparing the models and core numbers of the equipment cables on both sides; finally, outputs and stores the problematic cable number and the corresponding problem type.

[0030] Among them, there are four types of errors in the problematic cables: the device on the opposite side of the cable number is missing, the cable model is inconsistent on both sides, the number of cable cores on both sides is inconsistent, and the cable number is repeated.

[0031] Among them, the method of cyclic cross-matching of cable characteristic numbers is specifically as follows: starting from the first device, the cable characteristic number of the device is cross-matched with the cable characteristic numbers of the remaining subsequent devices in sequence. If the cable characteristic numbers on both sides are cross-matched, the cable characteristic numbers that are cross-matched in the device forms on both sides, as well as the corresponding cable numbers, cable models, and the number of cable cores are eliminated at the same time, thereby filtering out the problematic cable characteristic numbers in the first device form and the corresponding cable numbers, cable models, and the number of cable cores. Repeat this step to obtain the problematic cable characteristic numbers in all device forms and the corresponding cable numbers, cable models, and the number of cable cores.

[0032] Among them, the method for distinguishing the type of problem cable is specifically as follows: the method starts from the first device, crosses the problem cable number of the first device with the problem cable numbers in the remaining device forms, if there is no consistent cable number after crossing, crosses the cable number with the cable numbers in the initial remaining device forms, if there is still no consistent cable number, it is determined that the opposite device of the cable number is missing, if there are two cable numbers consistent with it, it is determined that the cable number is repeated; if there is a cable number consistent with it after crossing, obtain the device form where the cable number is located and the position in the device form, and compare the cable models of the two, if the cable models are consistent, it is determined that the number of cable cores of the devices on both sides is inconsistent; if the cable models are inconsistent, it is determined that the cable models of the devices on both sides are inconsistent, and after comparison, the cable number of the opposite device is eliminated to avoid repeated comparison.

[0033] The method for storing the problematic cable number and the problematic cable type is as follows: the method combines the problematic cable number and the problematic type, and stores the cable number and the problematic type in a table in a corresponding device form.

[0034] Example

[0035] The present invention is now described in detail by taking the application of the present invention to a certain 110kV booster station project for automatic checking of electrical secondary cable inventories as an example, which also has a guiding role in the application of the present invention to other electrical secondary cable inventories for automatic checking.

[0036] like Figure 1 As shown, this embodiment adopts an automatic checking method for electrical secondary cable inventory according to the present invention, and the cable inventory table data is as follows Figure 2As shown in the figure, it includes cable number, cable model, number of cores used, starting point, end point and length. The cable inventory contains N devices. Use the xlswrite function of matlab in the computer to read the equipment table inventory data of the electrical secondary cable inventory, and use the xlsfinfo function of matlab to obtain the device name. Define an N-dimensional cell array to store the cable data in the inventory table, where N is the number of devices. Extract the cable number, cable model, and number of cable cores from the cell array, and use the strcat function of matlab in the computer to combine them into a cable characteristic number to check whether the equipment cables on both sides are consistent.

[0037] This embodiment adopts Figure 1 The cable characteristic number circular cross-comparison method shown in the figure starts from the first equipment form and uses the intersect function of MATLAB to cross-compare the cable characteristic number of the first equipment form with the cable characteristic numbers of the remaining equipment forms. If the cable characteristic numbers on both sides are cross-consistent, the cable characteristic numbers that are cross-consistent in the equipment forms on both sides, as well as the corresponding cable numbers, cable models and the number of cable cores are eliminated at the same time, thereby screening out the problematic cable characteristic numbers in the first equipment form and the corresponding cable numbers, cable models and the number of cable cores, and repeating this step until the problematic cable characteristic numbers and the corresponding cable numbers, cable models and the number of cable cores in all equipment forms are obtained.

[0038] This embodiment adopts Figure 1 The cable problem type identification method shown in the figure is based on the obtained set of problematic cable numbers. Starting from the first device, the intersect function of matlab is used to cross the problematic cable number of the device with the problematic cable numbers in the remaining device forms. If there is no consistent cable number after the crossover, the cable number is crossed with the cable numbers in the initial remaining device forms. If there is still no consistent cable number, it is determined that the opposite device of the cable number is missing. If two cable numbers are obtained that are consistent with it, it is determined that the cable number is repeated. If there is a cable number that is consistent with it after the crossover, the opposite device form where the consistent cable number is located and the position in the opposite device form are obtained, and the cable models of the two are compared. If the cable models are consistent, it is determined that the cable core numbers of the devices on both sides are inconsistent; if the cable models are inconsistent, it is determined that the cable models of the devices on both sides are inconsistent. After the comparison, the cable number of the opposite device is eliminated to avoid repeated comparison.

[0039] The problematic cable number and the problem type are combined, and the problem type and the cable number are stored in a corresponding device form in a table.

[0040] Figure 3The cable characteristic number of the cable inventory problem screened out by the method of the present invention in this embodiment, wherein the part marked with shading is the device name, and the corresponding problem cable characteristic number is below the device name, such as TCP / 03ZCKVVP-22-7×1.5mm 2 3 means the cable number is TCP / 03 and the cable model is ZC-KVVP-22-7×1.5mm 2 , the number of cable cores is 3.

[0041] Figure 4 To screen out the problem cable numbers and corresponding problem types, for device 4GP, its cable number 4GP / 01 uses a 13-core cable, and the cable model used by 4GP / 02 is ZCKVVP-22-14×1.5mm 2 The 4GP / 01 of the public measurement and control panel uses a 12-core cable, and the 4GP / 02 of the public measurement and control panel uses a ZCKVVP-22-7×1.5mm 2 The present embodiment adopts the method of the present invention to identify the device form where the problem cable number is located and its position in the opposite device form, and compares the cable models and the number of cable cores of the two. It is found that the problem type is the inconsistent number of cable cores on both sides and the inconsistent cable models on both sides. After the comparison, the 4GP / 01 and 4GP / 02 cable numbers of the opposite device CP are deleted to avoid repeated comparison.

[0042] like Figure 4 As shown, this embodiment uses the method of the present invention to determine that the problem type of the 400V cabinet and the CP cabinet is the missing cable number of the opposite side equipment. The end points of this part of the cable are respectively to the public measurement and control panel and the 400V cabinet. After verification, it was because the CP cabinet was not numbered in sequence, and the 400V cabinet and the CP cabinet were both numbered with cables, which caused such problems. The problem type of FGP is the missing cable number of the opposite side equipment. After verification, the opposite side cable number was omitted in the CAD drawing.

[0043] Conclusion: The method of the invention adopted in this embodiment can reduce the time of checking the secondary cable inventory and improve the accuracy; for large-scale new energy 220kV booster stations (large-scale new energy booster stations, i.e. new energy booster stations with installed capacity exceeding 200MW and voltage level of 220kV or 500kV), manual checking of the secondary cable inventory generally requires 2 people to spend more than 12 working hours at the same time and has low accuracy; while the automatic mapping method of the electrical secondary cable inventory of the present invention is implemented by programming on the matlab platform of the computer, and only one person is needed, and it only takes about 10 minutes to accurately obtain the problem cable number and problem type (the method of the present invention can basically find all inconsistencies, such as Figure 2 , Figure 3 , Figure 4As shown in the figure, compared with manual checking of secondary cable lists, it saves about 22 hours, greatly reduces the pressure on secondary designers and improves the quality of cable lists. At the same time, accurate checking of cable lists can also improve the quality of drawings, providing a strong guiding basis for on-site secondary cable construction and laying out.

[0044] Other parts not described belong to the prior art.

Claims

1. A method for automatically checking the inventory of electrical secondary cables based on cable characteristic numbers, characterized in that: The following steps are included: Step 1: Read the data in the electrical secondary cable inventory table; Step 2: Store the electrical secondary inventory table data as a cell array type; Step 3: Combine the cable number, cable model, and number of cable cores in the cell array in the cable list into a cable characteristic number to determine whether the cables of the devices on both sides are consistent; When the cable characteristic numbers between the devices on both sides are inconsistent, it is determined that there is a problem with the cable; step 4. Circularly cross-compare the cable characteristic numbers, filter out the problematic cable characteristic number set, and obtain the corresponding problematic cable number, cable model, and number of cable cores; Step 5: Obtain the opposite-side device form where the problematic cable number is located and its location in the opposite-side device form, and compare the cable model and number of cores of the devices on both sides to determine the type of problematic cable; The method for determining the type of the problematic cable comprises the following steps: Starting from the first device, cross the problematic cable number in the first device form with the problematic cable numbers in the remaining device forms. If there is no consistent cable number after crossing, cross the cable number with the cable numbers in the initial remaining device forms; if there is still no consistent cable number, it is determined that the opposite device of the cable number is missing; if there are two consistent cable numbers, it is determined that the cable number is repeated; if a consistent cable number is obtained after crossing, obtain the device form where the cable number is located and its position in the device form, and compare the cable models of the two. If the cable models are consistent, it is determined that the number of cable cores of the devices on both sides is inconsistent; if the cable models are inconsistent, it is determined that the cable models of the devices on both sides are inconsistent; After comparison, the cable numbers of the opposite side equipment will be removed to avoid repeated comparison; Step 6: Store and output the problem cable number and problem type.

2. The method for automatically checking the inventory of electrical secondary cables based on cable characteristic numbers according to claim 1 is characterized in that: In step 4, the method of cyclically cross-checking the cable characteristic number includes the following steps: Starting from the first device, the cable characteristic number in the device form is cross-compared with the cable characteristic number in the subsequent device form. If the cable characteristic numbers on both sides are consistent, the consistent cable characteristic numbers and the corresponding cable numbers, cable models and cable core counts in the device forms on both sides are removed at the same time, thereby filtering out the problematic cable characteristic numbers and the corresponding cable numbers, cable models and cable core counts in the first device form; Repeat the above steps to obtain the problematic cable characteristic numbers and the corresponding cable numbers, cable models, and cable core counts in all device tables.

3. The method for automatically checking the electrical secondary cable inventory based on the cable characteristic number according to claim 1 or 2, characterized in that: In step five, the types of problems include missing equipment on the opposite side of the cable number, inconsistent cable models on both sides, inconsistent cable core numbers on both sides, and duplicate cable numbers.

4. The method for automatically checking the inventory of electrical secondary cables based on cable characteristic numbers according to claim 1 is characterized in that: In step six, the method for storing the problematic cable number and the problematic cable type is as follows: the problematic cable number and the problematic type are combined, and the problematic type and the cable number are stored in a corresponding device form in a table.

Images