Cable list automatic error checking method

Abstract

The present application relates to a kind of cable list automatic error checking method, it includes step 1, cable information is input into excel, forms cable list table, cable calculation process table and summary table;Step 2, by VBA array reading cable length list table, cable calculation process table, cable data in summary table, check whether there is abnormality in cabinet cable length, whether the stripping length of the two sides of inter-cabinet cable is abnormal, whether there is abnormality in three-position cable, whether there is omission in cable length list table, whether there is omission in bellows and gland, whether the same mechanism size cable is abnormal, whether there is abnormality in summary data.The present application reads the parameter in cable table by VBA, by data processing and comparison, automatically check the common error in cable list, improve the efficiency of cable checking and reduce the occurrence of error.

Description

Technical Field

[0001] This invention relates to the field of cable data management technology, and more specifically to an automatic error-checking method for cable lists. Background Technology

[0002] Each bay of a high-voltage switchgear unit has cables running from the primary equipment body to the control cabinet. After the cable list for the control cabinet is exported from the design software, the cable length to the cable tray, cable tray height, cable tray to the cabinet, and internal cabinet length must be measured according to the project's 3D model. Parameters such as the stripping length inside the cabinet, the direction of the aviation connector core, the side-out and top-out of the aviation connector, and the number of modules must be manually entered. Because this is done manually, errors frequently occur in actual projects, such as incorrect aviation connector core direction leading to inability to insert the aviation connector, significant discrepancies in the lengths of large and small cables within the same unit resulting in cables being too long or too short, incorrect internal cabinet lengths leading to cables being too long or too short, incorrect number of aviation connector cores, omission of cable corrugated tubes and glands, and missing cables in the length list. Summary of the Invention

[0003] To address the problems existing in the prior art, the purpose of this invention is to provide an automatic error checking method for cable lists. This method reads parameters from the cable table using VBA, processes and compares the data, and automatically checks for common errors in the cable list, thereby improving the efficiency of cable verification and reducing the occurrence of errors.

[0004] To achieve the above objectives, the technical solution adopted by the present invention is as follows: A method for automatically checking cable lists, the method comprising the following steps: Step 1: Input the cable information into Excel to generate a cable list table, a cable calculation process table, and a summary table; There are two types of cable lists: those with aviation connectors and those without. For cables with aviation connectors, the cable list header must include at least: cable number, cable model, start point, end point, aviation connector manufacturing instructions, aviation connector shell type on the mechanical side, aviation connector core direction on the mechanical side, length, metal hose model, and metal hose length on the mechanical side. For cables without aviation connectors, the cable list header must include at least: cable number, cable model, start point, end point, stripped length on the mechanical side, stripped length on the LCP side, length, metal hose model, and metal hose length on the mechanical side. Cable numbers include two types: cabinet cable numbers and inter-cabinet cable numbers. Cabinet cable numbers include the cabinet number plus "-" plus the cable number, while inter-cabinet cable numbers do not include the cabinet number. The cable type includes the cable model, number of cores, and wire diameter. Cables with 46 or 64 cores are considered large cables, while the rest are small cables. The housing forms of the mechanical side aviation plug include the following: 24-72 core side outlet hole, 24-72 core top outlet hole, and housing shared with the double-hole large aviation plug, only the mechanical aviation plug M20 hole is machined. The orientation of the aviation ferrule on the mechanism side includes the following: the pin is close to the outlet hole, the pin is far from the outlet hole, and there are no requirements. The header of the cable calculation process table should include at least the cable number, the length from the bottom of the cabinet to the aviation connector, and the length of the cable inside the cabinet (1). The length from the bottom of the cabinet to the aviation connector is the length of the cable with the aviation connector inside the cabinet; the length of the cable without the aviation connector is the length of the cable inside the cabinet. The summary table should at least include a summary of the quantity and length of each type of cable, and a summary of the quantity of each type of aviation connector shell, core, and pins. Step 2: Use VBA arrays to read cable data from the cable length list, cable calculation process table, and summary table. Check for any abnormalities in the cable length inside the cabinet, the stripping length on both sides of the cable between cabinets, the three-station cables, any omissions in the cable length list, any omissions in corrugated pipes and glands, any abnormalities in cables of the same size within the same facility, and any abnormalities in the summary data.

[0005] Check the cable lengths inside the cabinet in the cable calculation process table for any abnormalities, specifically as follows: The VBA array is used to read the data from the "Cabinet Bottom to Aviation Insertion Board" and "Cabinet 1" columns of the cable calculation process table. Then, the two columns of data are compared and judged. If each cable has a value in exactly one of the two columns, it means there is no abnormality. If a cable has no value in either column or has a value in both columns, it means there is an abnormality and an error is reported.

[0006] Check the stripping lengths on both sides of the cables between cabinets for any abnormalities, specifically as follows: The VBA array is used to read the "Cable Number", "Mechanical Side Stripping Length", and "LCP Side Stripping Length" from the cable length list table. Then, the text of the read cable number is filtered to find the corresponding data of the cable number without the cabinet number. Next, the "Mechanical Side Stripping Length" and "LCP Side Stripping Length" of the cable between cabinets are compared to see if they are consistent. If the lengths are inconsistent, it is judged as abnormal and an error is reported.

[0007] The determination of whether a three-position cable is used is based on the data in the cable list, and the specific determination is as follows: Step 3.1: Traverse the cable numbers. If the cable number contains TES and is a 64-core or 46-core cable, proceed to step 3.2. Otherwise, skip to the next cable number. Step 3.2: Determine whether the previous cable number contains TDS. If yes, proceed to step 3.3; otherwise, skip to the next cable number. Step 3.3: Determine whether the cable mechanism side aviation plug housing is top-out. If so, skip to the next cable number; otherwise, proceed to step 3.4. Step 3.4: Compare the lengths of the TES cable and the TDS cable. If the length of the TES cable is greater than the length of the TDS cable, proceed to step 3.5; otherwise, skip to step 3.6. Step 3.5: If the direction of the aviation connector core on the mechanism side of the TDS cable is away from the pin, it is determined that the aviation connector of the TDS cable is incorrect and the cable number of the TDS cable is recorded; if the direction of the aviation connector core on the mechanism side of the TES cable is close to the pin, it is determined that the aviation connector of the TES cable is incorrect and the cable number of the TES cable is recorded. Step 3.6: If the direction of the aviation connector core on the mechanism side of the TDS cable is closer to the pin, it is determined that the aviation connector of the TDS cable is incorrect and the cable number of the TDS cable is recorded; if the direction of the aviation connector core on the mechanism side of the TES cable is closer to the pin and farther away, it is determined that the aviation connector of the TES cable is incorrect and the cable number of the TES cable is recorded. Step 3.7: Re-traverse the cable numbers. If the mechanical side aviation plug shell type corresponding to the cable number is top-out and it is a 46-core or 64-core cable, proceed to step 3.8. Otherwise, jump to the next cable number. Step 3.8: Determine whether the orientation of the aviation connector on the mechanism side of the cable is closer to or further away from the pin. If so, determine that the aviation connector of this cable is incorrect and record the cable number. Step 3.9: Re-traverse the cable numbers and determine whether the direction of the aviation core on the mechanical side of the cable is "no requirement" and whether the cable is 46 cores or 64 cores. If yes, proceed to step 3.10; otherwise, jump to the next cable number. Step 3.10: Determine if the cable's aviation connector housing is side-exit. If so, determine that the cable's aviation connector is incorrect and record the cable number. After completing the above steps, if any errors are recorded in the direction of the aviation insert, an error report will be output.

[0008] Check the cable length list for any omissions, as follows: The cable numbers in the cable length list table and the cable calculation process table are read from the VBA array. By comparing the cable numbers in the cable length list table and the cable calculation process table, if any cable is missing from the cable list, an omission cable is reported.

[0009] The specific steps for checking whether the bellows and glands are missing are as follows: The VBA array is used to read the data in the "Metal Hose Model" and "Mechanical Side Metal Hose Length" columns of the cable length list table. If the metal hose model is empty or the mechanical side metal hose length is empty or "0", an error message will be displayed indicating that the corrugated pipe and gland are missing.

[0010] The following are specific steps to check for abnormalities in cables of the same size within the same organization: Step 6.1: Traverse the cable numbers. If the cable number contains DS, ES, FES, or CB and is a 46-core or 64-core cable, proceed to step 6.2. Otherwise, jump to the next cable number. Step 6.2: Iterate through the cable numbers again to determine if the cable is a small cable. If it is, proceed to step 6.3. If not, jump to the next cable number. Step 6.3: Extract the cabinet number from Step 6.1 and Step 6.2 by cable number. If the cabinet numbers are the same and the starting point of the cable is the same institution, proceed to Step 6.4. Otherwise, skip to the next cable number. Step 6.4: Compare the lengths of the large and small cables from the same organization selected in Steps 6.1-6.3. If the difference is too large, determine that the difference between the large and small cables from the same organization is too large and record the cable number, then jump to the next cable number. If any errors are recorded in the above steps where the size of the cable differs too much, an error report will be output.

[0011] The specific steps to check for anomalies in the summary data are as follows: Step 7.1: Traverse the cable numbers and use the "7-core IP68 shell" field to summarize the number of 7-core aviation connectors; Step 7.2: Traverse the cable numbers and use the fields "CB", "46 cores", and "64 cores" to summarize the quantity of CB large-diameter aviation cables; Step 7.3: Traverse the cable numbers and use the fields "TDS", "46 cores", and "64 cores" to summarize the number of three-station TDS large aviation plug cables; Step 7.4: Traverse the cable numbers and use the fields "TES", "46 cores", and "64 cores" to summarize the number of three-station TES large-capacity connector cables. Step 7.5: Traverse the cable numbers and use the fields "-ES", "46 cores", and "64 cores" to summarize the quantity of slow-blade ES large-diameter aviation plug cables. Step 7.6: Traverse the cable numbers and use the fields "-FES", "46 cores", and "64 cores" to summarize the quantity of Fast Knife FES large-capacity connector cables; Step 7.7: Traverse the cable numbers and use the "top out" field to summarize the number of top out connectors.

[0012] Step 7.8: Traverse the cable numbers and use the fields "Shares housing with dual-hole large aviation connector" and "Only process mechanical aviation connector M20 hole" to summarize the number of dual-hole aviation connectors; Step 7.9: Calculate the quantity of each type of aviation connector based on the data summarized above.

[0013] Step 7.10: Compare the calculated quantity of each type of aviation plug with the quantity in the summary table. If the quantities are inconsistent, report an error.

[0014] By adopting the above solution, this invention reads the parameters in the cable table through VBA, processes and compares the data, and automatically checks for common errors in the cable list, which can effectively improve the efficiency of cable verification and reduce the occurrence of errors. Attached Figure Description

[0015] Figure 1 This is the overall flowchart of the present invention; Figure 2 This is intended to represent the purpose of the cable length list; Figure 3 To indicate the intent of the calculation process; Figure 4 To summarize the intended meaning; Figure 5 Flowchart for cable length anomaly inspection; Figure 6 This is a schematic diagram illustrating the results of abnormal cable length. Figure 7 Flowchart for detecting abnormal stripping lengths on both sides of cables between cabinets; Figure 8 This is a schematic diagram showing the abnormal stripping lengths on both sides of the cable between cabinets. Figure 9 A schematic diagram showing the installation direction of the aviation-grade insert core of the three-station mechanism; Figure 10 Flowchart for three-station cable anomaly detection; Figure 11 This is a schematic diagram of the abnormal cable results at three workstations; Figure 12 Flowchart for detecting omissions in the cable length list; Figure 13 This is a diagram illustrating the omissions in the cable length list. Figure 14 Flowchart for detecting missing parts in bellows and glands; Figure 15 A schematic diagram showing the omissions of bellows and glands; Figure 16 This is a schematic diagram illustrating the abnormal detection of cables of different sizes within the same organization. Figure 17This is a schematic diagram illustrating abnormal results of cables of different sizes belonging to the same organization. Figure 18 Here is a flowchart summarizing the data anomaly detection process; Figure 19 This is a diagram illustrating the summary of abnormal data results. Detailed Implementation

[0016] like Figure 1 As shown, this invention discloses an automatic error-checking method for cable lists, which includes the following steps: Step 1: Input the cable information into Excel to generate a cable list table, a cable calculation process table, and a summary table.

[0017] like Figures 2 to 4 As shown, there are two types of cable lists: those with aviation connectors and those without. The cable list header for cables with aviation connectors must include at least the following: cable number, cable model, start point, end point, aviation connector manufacturing instructions, aviation connector shell type on the mechanical side, aviation connector core direction on the mechanical side, length, metal hose model, and metal hose length on the mechanical side. The cable list header for cables without aviation connectors must include at least the following: cable number, cable model, start point, end point, stripped length on the mechanical side, stripped length on the LCP side, length, metal hose model, and metal hose length on the mechanical side.

[0018] Cable numbering includes two types: cabinet-internal cable numbering and inter-cabinet cable numbering. Cabinet-internal cable numbering includes the cabinet number followed by a "-" and the cable number, such as E02-TDS01. Inter-cabinet cable numbering does not include the cabinet number, such as AC01. Cable model includes the cable type, number of cores, and wire diameter. For example, KVVRP_46X1.5 indicates that the cable type is KVVRP, 46 cores, and 1.5 mm². 46-core and 64-core cables are large cables, and the rest are small cables. The housing type for the mechanism-side aviation connector includes the following: 24-72 core side outlet, 24-72 core top outlet, and a housing shared with the double-hole large aviation connector, only processing the mechanism aviation connector M20 hole. The orientation of the mechanism-side aviation connector core includes the following: pin 1 near the outlet hole, pin 1 away from the outlet hole, no specific requirements.

[0019] The header of the cable calculation process table should include at least the cable number, the length from the bottom of the cabinet to the aviation connector, and "cabinet 1". The cable number here uses the same naming convention as the cable number in the cable list. "Cabinet bottom to aviation connector" refers to the length of the cable with aviation connector inside the cabinet, and "cabinet 1" refers to the length of the cable without aviation connector inside the cabinet.

[0020] The summary table should include at least the quantity and length of each type of cable, and the quantity of each type of aviation connector housing, core, and pin.

[0021] Step 2: Use VBA (Visual Basic for Applications) arrays to read cable data from the cable length list, cable calculation process table, and summary table. Check for any abnormalities in cable length, stripping length on both sides of the cable between cabinets, three-station cables, omissions in the cable length list, omissions in corrugated pipes and glands, abnormalities in cables of the same size within the same facility, and abnormalities in the summary data.

[0022] (1) Check if there are any abnormalities in the length of the cable inside the cabinet in the cable calculation process table.

[0023] The length of the cable inside the control cabinet is divided into two types: one is a large cable with a prefabricated aviation connector, the length of which is filled in the "from bottom of cabinet to aviation connector" column in the calculation process table; the other is a regular small cable without an aviation connector, the length of which is filled in the "cabinet 1" column in the calculation process table.

[0024] Therefore, as Figure 5 As shown, the VBA (Visual Basic for Applications) array is used to read the data from the "Cabinet Bottom to Aviation Board" and "Cabinet 1" columns in the cable calculation process table. Then, the two columns are compared. If each cable has exactly one value in both columns (i.e., exactly one value in both columns of the same row), it indicates no abnormality, and "Completed, no errors found" is output. If a cable has no values ​​in either column or has values ​​in both columns, it indicates an abnormality, and an error is reported: the cable number with the abnormality is retrieved, and "The following cable's cabinet length or cabinet bottom to aviation board length is abnormal: XXX" is output (e.g., ...). Figure 6 (as shown), where XXX is the abnormal cable number.

[0025] (2) Check whether the stripping length of the cable on both sides of the cabinet is abnormal.

[0026] The inter-cabinet cables installed on-site connect one cabinet to another. Therefore, both ends of the inter-cabinet cables need to be stripped to the same length. Because some other cables (non-inter-cabinet cables) only require stripping on the cabinet side, some engineers may miss stripping one side or the stripping lengths on both sides may be inconsistent when calculating cable lengths. Therefore, it is necessary to inspect the stripping lengths on both sides of the inter-cabinet cables. In this embodiment, inter-cabinet cables are identified by their cable numbers; those not containing the cabinet number are considered inter-cabinet cables.

[0027] like Figure 7As shown, the VBA array reads the "Cable Number," "Mechanism Side Stripping Length," and "LCP Side Stripping Length" from the cable length list table. Then, it filters the text of the read cable numbers to find the corresponding data for cable numbers without cabinet numbers (i.e., inter-cabinet cables). Next, it compares the "Mechanism Side Stripping Length" and "LCP Side Stripping Length" of the inter-cabinet cables. If the lengths are inconsistent, it is considered abnormal and an error is reported. The error message can output "The following inter-cabinet cables have inconsistent stripping lengths on both sides: XXX," where XXX is the abnormal cable number, such as... Figure 8 As shown.

[0028] (3) Check whether there are any abnormalities in the three-position cable.

[0029] The orientation of the pins on the aviation-grade connector core of the three-station mechanism is defined on both sides of the mechanism. If the corresponding three-station cable runs towards the pin, it is closer to the pin; otherwise, it is farther away from the pin. For example... Figure 9 As shown, 1 represents the pin position, 64 represents a 64-core cable, and 46 represents a 46-core cable. The TDS and TES cables at the same three-position have the same routing. Therefore, if the TDS cable is closer to the pin, the TES cable is farther from pin 1, and the cable farther from the pin will be longer than the cable closer to pin 1. However, for top-mounted aviation connectors, the core orientation is not required. Based on the above, by comparing the length of the large aviation connector cable, the housing type of the aviation connector on the mechanism side, and the core orientation of the aviation connector on the mechanism side, the system can automatically determine whether the aviation connector is side-mounted or top-mounted, and whether the orientation (closer or farther) is correct.

[0030] Specifically, such as Figure 10 As shown, the determination of the three-position cable is based on the data in the cable list table, and the specific determination is as follows: Step 3.1: Traverse the cable numbers. If the cable number contains TES and is a 64-core or 46-core cable, proceed to step 3.2. Otherwise, skip to the next cable number.

[0031] Step 3.2: Determine whether the previous cable number contains TDS. If yes, proceed to step 3.3; otherwise, skip to the next cable number.

[0032] Step 3.3: Determine whether the TDS cable mechanism side aviation plug housing is top-out. If so, skip to the next cable number; otherwise, proceed to step 3.4.

[0033] Step 3.4: Compare the lengths of the TES cable and the TDS cable. If the length of the TES cable is greater than the length of the TDS cable, proceed to step 3.5; otherwise, skip to step 3.6.

[0034] Step 3.5: If the direction of the aviation connector core on the mechanism side of the TDS cable is away from pin 1, then the aviation connector core of the TDS cable is determined to be faulty and the cable number of the TDS cable is recorded; if the direction of the aviation connector core on the mechanism side of the TES cable is close to pin 1, then the aviation connector core of the TES cable is determined to be faulty and the cable number of the TES cable is recorded.

[0035] Step 3.6: If the orientation of the TDS cable's mechanical side aviation connector is closer to pin 1, then the TDS cable's aviation connector is incorrect, and the cable number of the TDS cable is recorded. If the orientation of the TES cable's mechanical side aviation connector is closer to and farther from pin 1, then the TES cable's aviation connector is incorrect, and the cable number of the TES cable is recorded.

[0036] Step 3.7: Re-traverse the cable numbers. If the cable number corresponds to a mechanical side aviation plug shell type that is top-out and is a 46-core or 64-core cable, proceed to step 3.8. Otherwise, jump to the next cable number.

[0037] Step 3.8: Determine whether the direction of the aviation connector core on the mechanism side of the cable is closer to or farther from pin 1. If so, determine that the aviation connector core of this cable is incorrect and record the cable number. Step 3.19: Re-traverse the cable numbers and determine whether the direction of the aviation core on the mechanical side of the cable is "no requirement" and whether the cable is 46 cores or 64 cores. If yes, proceed to step 3.10; otherwise, jump to the next cable number.

[0038] Step 3.10: Determine if the cable's aviation connector housing is side-exit. If so, determine that the cable's aviation connector is incorrect and record the cable number.

[0039] After completing the above steps, if any errors are recorded regarding the orientation of the aviation connector core, the output will be "The following cable is incorrect due to being too close to, too far from, or protruding from the top or side: xxx (cable number)". Figure 11 As shown, if there are no errors, the output will be "Completed, no errors found".

[0040] (4) Check if there are any omissions in the cable length list.

[0041] If additional cables are added during cable calculations, there's a possibility that they might not be included in the length list, resulting in some cables being omitted. Therefore, it's necessary to check the cable length list for any omissions.

[0042] Specifically, such as Figure 12-13As shown, the VBA array is used to read the cable numbers from the cable length list table and the cable calculation process table respectively. By comparing the cable numbers in the cable length list table and the cable calculation process table, if any cable is missing from the cable list, an omission cable is reported. If an omission cable is found, the output will be "The following cable length list table contains omissions: XXX".

[0043] (5) Check if any bellows or glands are missing.

[0044] The cable list specifies that all cables, except those running in cable trenches between cabinets, require corrugated pipes and cable glands. However, in actual projects, there have been instances where corrugated pipes and cable glands were omitted. Therefore, it is necessary to check for any missing corrugated pipes and cable glands.

[0045] Specifically, such as Figure 14-15 As shown, the VBA array reads the "Metal Hose Model" and "Mechanism-Side Metal Hose Length" columns from the cable length list table. If the metal hose model is empty, or the mechanism-side metal hose length is empty or "0", an error message indicating a missing corrugated pipe and gland will be displayed, outputting "The following cable is missing a corrugated pipe and gland: XXX (cable number)". (6) Check whether the cables of the same size in the same organization are abnormal.

[0046] For large and small cables from the same organization, since they all run from the same organization to the same cable tray and the same cabinet, the corrugated pipe lengths of the cables should be roughly the same, and the total cable length minus the length inside the cabinet should also be roughly the same. Compare the lengths of the large and small cables and the corrugated pipe lengths from the same organization; if the difference is too large, report it as an excessive difference in cable length between the same organization and the same size cables.

[0047] like Figure 16 As shown, the specific steps are as follows: Step 6.1: Traverse the cable numbers. If the cable number contains DS, ES, FES, or CB and is a 46-core or 64-core cable, proceed to step 6.2. Otherwise, jump to the next cable number.

[0048] Traverse the cable numbers. The cable number and cable model are stored in the same array. Traversing the cable number can read the corresponding cable model at the same time. In the power industry, DS is normally the default for disconnector, ES is the grounding switch, FES is the fast grounding switch, and CB is the circuit breaker.

[0049] Step 6.2: Iterate through the cable numbers again to determine if the cable is a small cable (not 46-core or 64-core). If it is, proceed to step 6.3. If not, jump to the next cable number.

[0050] Step 6.3: Extract the cabinet number from Step 6.1 and Step 6.2 by cable number. If the cabinet number is the same and the cable starts from the same institution, proceed to Step 6.4. Otherwise, skip to the next cable number.

[0051] Step 6.4: Compare the lengths of the large and small cables from the same organization selected in Steps 6.1-6.3. If the difference is too large, determine that the difference between the large and small cables from the same organization is too large and record the cable number, then move on to the next cable number.

[0052] If any of the above steps record an error indicating excessive difference in cable size, the output should be "The following cables from the same organization have excessive differences in size: xxx (cable number)". Figure 17 As shown, if there are no errors, the output will be "Completed, no errors found".

[0053] (7) Check if there are any abnormalities in the summary data.

[0054] By summarizing the data, the number of airline entries corresponding to the table is calculated and compared with the total number in the summary. Any discrepancies are reported as errors. For example... Figure 18 As shown, the specific steps are as follows: Step 7.1: Traverse the cable numbers and use the "7-core IP68 shell" field to summarize the number of 7-core aviation connectors.

[0055] Step 7.2: Traverse the cable numbers and use the fields "CB", "46 cores", and "64 cores" to summarize the quantity of CB large-diameter aviation cables.

[0056] Step 7.3: Traverse the cable numbers and use the fields "TDS", "46 cores", and "64 cores" to summarize the quantity of three-station TDS large-diameter aviation plug cables.

[0057] Step 7.4: Traverse the cable numbers and use the fields “TES”, “46 cores”, and “64 cores” to summarize the quantity of three-station TES large-capacity connector cables.

[0058] Step 7.5: Traverse the cable numbers and use the fields "-ES", "46 cores", and "64 cores" to summarize the quantity of slow-blade ES large-diameter aviation plug cables.

[0059] Step 7.6: Traverse the cable numbers and use the fields "-FES", "46 cores", and "64 cores" to summarize the quantity of Fast Knife FES large-capacity connector cables.

[0060] Step 7.7: Traverse the cable numbers and use the "top out" field to summarize the number of top out connectors.

[0061] Step 7.8: Traverse the cable numbers and use the fields "Shares housing with double-hole aviation connector" and "Only process aviation connector M20 hole" to summarize the number of double-hole aviation connectors.

[0062] Step 7.9: Calculate the quantity of each type of aviation connector based on the data summarized above.

[0063] Step 7.10: Compare the calculated quantities of each type of aviation connector with the quantities in the summary table. If the quantities do not match, report an error. The error message may display something like "The quantity of aviation connector of type XXX is incorrect; the quantity should be: XX". Figure 19 As shown.

[0064] In summary, this invention uses VBA to read parameters from the cable table, processes and compares the data, and automatically checks for common errors in the cable list, which can effectively improve the efficiency of cable verification and reduce the occurrence of errors.

[0065] The above description is merely an embodiment of the present invention and does not constitute any limitation on the technical scope of the present invention. Therefore, any minor modifications, equivalent changes and alterations made to the above embodiments based on the technical essence of the present invention shall still fall within the scope of the technical solution of the present invention.

Claims

1. A method for automatically checking cable lists, characterized in that, The method includes the following steps: Step 1: Input the cable information into Excel to generate a cable list table, a cable calculation process table, and a summary table; There are two types of cable lists: those with aviation connectors and those without. For cables with aviation connectors, the cable list header must include at least: cable number, cable model, start point, end point, aviation connector manufacturing instructions, aviation connector shell type on the mechanical side, aviation connector core direction on the mechanical side, length, metal hose model, and metal hose length on the mechanical side. For cables without aviation connectors, the cable list header must include at least: cable number, cable model, start point, end point, stripped length on the mechanical side, stripped length on the LCP side, length, metal hose model, and metal hose length on the mechanical side. Cable numbers include two types: internal cabinet cable numbers and inter-cabinet cable numbers. Internal cabinet cable numbers include the cabinet number plus "-" plus the cable number, while inter-cabinet cable numbers do not include the cabinet number. The cable type includes the cable model, number of cores, and wire diameter. Cables with 46 or 64 cores are considered large cables, while the rest are small cables. The housing forms of the mechanical side aviation plug include the following: 24-72 core side outlet hole, 24-72 core top outlet hole, and housing shared with the double-hole large aviation plug, only the mechanical aviation plug M20 hole is machined. The orientation of the aviation ferrule on the mechanism side includes the following: the pin is close to the outlet hole, the pin is far from the outlet hole, and there are no requirements. The header of the cable calculation process table should include at least the cable number, the length from the bottom of the cabinet to the aviation connector, and the length of the cable inside the cabinet (1). The length from the bottom of the cabinet to the aviation connector is the length of the cable with the aviation connector inside the cabinet; the length of the cable without the aviation connector is the length of the cable inside the cabinet. The summary table should at least include a summary of the quantity and length of each type of cable, and a summary of the quantity of each type of aviation connector shell, core, and pins. Step 2: Use VBA arrays to read cable data from the cable length list, cable calculation process table, and summary table. Check for any abnormalities in the cable cabinet length, the stripping length of cables between cabinets, the three-position cables, any omissions in the cable length list, any omissions in corrugated pipes and glands, any abnormalities in cables of the same size within the same facility, and any abnormalities in the summary data.

2. The automatic error-checking method for cable lists according to claim 1, characterized in that, Check the cable lengths inside the cabinet in the cable calculation process table for any abnormalities, specifically as follows: The VBA array is used to read the data from the "Cabinet Bottom to Aviation Insertion Board" and "Cabinet 1" columns in the cable calculation process table. Then, the two columns of data are compared and judged. If each cable has a value in exactly one of the two columns, it means there is no abnormality. If a cable has no value in either column or has a value in both columns, it means there is an abnormality and an error is reported.

3. The automatic error-checking method for cable lists according to claim 1, characterized in that, Check the stripping lengths on both sides of the cables between cabinets for any abnormalities, specifically as follows: The VBA array is used to read the "Cable Number", "Mechanical Side Stripping Length", and "LCP Side Stripping Length" from the cable length list table. Then, the text of the read cable number is filtered to find the corresponding data of the cable number without the cabinet number. Next, the "Mechanical Side Stripping Length" and "LCP Side Stripping Length" of the inter-cabinet cable are compared to see if they are consistent. If the lengths are inconsistent, it is judged as abnormal and an error is reported.

4. The automatic error-checking method for cable lists according to claim 1, characterized in that, The determination of whether a three-position cable is used is based on the data in the cable list, and the specific determination is as follows: Step 3.1: Traverse the cable numbers. If the cable number contains TES and is a 64-core or 46-core cable, proceed to step 3.

2. Otherwise, skip to the next cable number. Step 3.2: Determine whether the previous cable number contains TDS. If yes, proceed to step 3.3; otherwise, skip to the next cable number. Step 3.3: Determine whether the cable mechanism side aviation plug housing is top-out. If so, skip to the next cable number; otherwise, proceed to step 3.

4. Step 3.4: Compare the lengths of the TES cable and the TDS cable. If the length of the TES cable is greater than the length of the TDS cable, proceed to step 3.5; otherwise, skip to step 3.

6. Step 3.5: If the direction of the aviation connector core on the mechanism side of the TDS cable is away from the pin, it is determined that the aviation connector of the TDS cable is incorrect and the cable number of the TDS cable is recorded; if the direction of the aviation connector core on the mechanism side of the TES cable is close to the pin, it is determined that the aviation connector of the TES cable is incorrect and the cable number of the TES cable is recorded. Step 3.6: If the direction of the aviation connector core on the mechanism side of the TDS cable is closer to the pin, it is determined that the aviation connector of the TDS cable is incorrect and the cable number of the TDS cable is recorded; if the direction of the aviation connector core on the mechanism side of the TES cable is closer to the pin and farther away, it is determined that the aviation connector of the TES cable is incorrect and the cable number of the TES cable is recorded. Step 3.7: Re-traverse the cable numbers. If the mechanical side aviation plug shell type corresponding to the cable number is top-out and it is a 46-core or 64-core cable, proceed to step 3.

8. Otherwise, jump to the next cable number. Step 3.8: Determine whether the orientation of the aviation connector on the mechanism side of the cable is closer to or further away from the pin. If so, determine that the aviation connector of this cable is incorrect and record the cable number. Step 3.9: Re-traverse the cable numbers and determine whether the direction of the aviation core on the mechanical side of the cable is "no requirement" and whether the cable is 46 cores or 64 cores. If yes, proceed to step 3.10; otherwise, jump to the next cable number. Step 3.10: Determine if the cable's aviation connector housing is side-exit. If so, determine that the cable's aviation connector is incorrect and record the cable number. After completing the above steps, if any errors are recorded in the direction of the aviation insert, an error report will be output.

5. The automatic error-checking method for cable lists according to claim 1, characterized in that, Check the cable length list for any omissions, as follows: The cable numbers in the cable length list table and the cable calculation process table are read from the VBA array. By comparing the cable numbers in the cable length list table and the cable calculation process table, if any cable is missing from the cable list, an omission cable is reported.

6. The automatic error-checking method for cable lists according to claim 1, characterized in that, The specific steps for checking whether the bellows and glands are missing are as follows: The VBA array is used to read the data in the "Metal Hose Model" and "Mechanical Side Metal Hose Length" columns of the cable length list table. If the metal hose model is empty or the mechanical side metal hose length is empty or "0", an error message will be displayed indicating that the corrugated pipe and gland are missing.

7. The automatic error-checking method for cable lists according to claim 1, characterized in that, The following are specific steps to check for abnormalities in cables of the same size within the same organization: Step 6.1: Traverse the cable numbers. If the cable number contains DS, ES, FES, or CB and is a 46-core or 64-core cable, proceed to step 6.

2. Otherwise, jump to the next cable number. Step 6.2: Iterate through the cable numbers again to determine if the cable is a small cable. If it is, proceed to step 6.

3. If not, jump to the next cable number. Step 6.3: Extract the cabinet number from Step 6.1 and Step 6.2 by cable number. If the cabinet numbers are the same and the starting point of the cable is the same institution, proceed to Step 6.

4. Otherwise, skip to the next cable number. Step 6.4: Compare the lengths of the large and small cables from the same organization selected in Steps 6.1-6.

3. If the difference is too large, determine that the difference between the large and small cables from the same organization is too large and record the cable number, then move on to the next cable number. If any errors are recorded in the above steps where the size of the cable differs too much, an error report will be output.

8. The automatic error-checking method for cable lists according to claim 1, characterized in that, The specific steps to check for anomalies in the summary data are as follows: Step 7.1: Traverse the cable numbers and use the "7-core IP68 shell" field to summarize the number of 7-core aviation connectors; Step 7.2: Traverse the cable numbers and use the fields "CB", "46 cores", and "64 cores" to summarize the quantity of CB large-diameter aviation cables; Step 7.3: Traverse the cable numbers and use the "TDS", "46 cores", and "64 cores" fields to summarize the number of TDS large aviation plug cables for the three workstations; Step 7.4: Traverse the cable numbers and use the fields "TES", "46 cores", and "64 cores" to summarize the number of three-position TES large-capacity connector cables. Step 7.5: Traverse the cable numbers and use the fields "-ES", "46 cores", and "64 cores" to summarize the quantity of slow-blade ES large-diameter aviation plug cables; Step 7.6: Traverse the cable numbers and use the fields "-FES", "46 cores", and "64 cores" to summarize the quantity of Fast Knife FES large-capacity connector cables; Step 7.7: Traverse the cable numbers and use the "top out" field to summarize the number of top out connectors; Step 7.8: Traverse the cable numbers and use the fields "Shares housing with dual-hole large aviation connector" and "Only process mechanical aviation connector M20 hole" to summarize the number of dual-hole aviation connectors; Step 7.9: Based on the data summarized above, calculate the quantity of each type of aviation connector; Step 7.10: Compare the calculated quantity of each type of aviation plug with the quantity in the summary table. If the quantities are inconsistent, report an error.

Images