Rapid matching method and system for electrical connection fitting and iron tower type
By judging the tower type and using the mapping table to extract the matching electrical connection tools, the problem of cumbersome matching of electrical connection tools and towers is solved, and a fast and accurate matching operation is achieved.
Patent Information
- Application Number
- CN202411607349.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-11-12
- Publication Date
- 2025-02-14
AI Technical Summary
The lack of specific steps in the prior art to match the electrical connection between the metal tools and the tower, resulting in cumbersome matching and unfavorable for engineering construction.
By judging the tower shape, obtaining the corresponding hanging hole size, and using a preset mapping table to extract the matching electrical connection tools, and completing the matching operation based on actual comparison.
The data volume is optimized, the data processing rate is improved, manual judgment is effectively avoided, and matching accuracy is ensured.
Smart Images

Figure CN119441279A_ABST
Abstract
Description
Technical Field
[0001] The invention relates to the technical field of iron towers, and in particular to a method and a system for quickly matching electrical connection hardware with an iron tower type. Background Art
[0002] With the rapid development of the power system, overhead transmission lines have been built on a large scale. Line fittings are the general term for metal parts (except poles and towers) used in transmission lines. There are many types of line fittings with different uses; commonly used ones include wire clamps, splicing fittings, connecting fittings, protective fittings, and wire pulling fittings. Line fittings usually bear large loads and need to have sufficient strength. The fittings connected to the conductors must also have good electrical properties. The quality of the fittings, and whether they are used and installed correctly, have a great impact on safe power transmission. When designing lines, standard fittings should be selected as much as possible.
[0003] In the current overhead line design, there are no specific steps for the correspondence between electrical connection fittings and towers, which makes the matching complicated and is not conducive to engineering construction. Summary of the invention
[0004] In view of this, an object of the present invention is to provide a method and system for quickly matching electrical connection fittings with tower types.
[0005] In order to achieve the above object, the technical solution adopted by the present invention is: A method for quickly matching electrical connection fittings with a tower type, comprising the following steps: S1. Determine whether the tower type to be matched is a straight tower. If so, obtain the diameter of the ground wire hanging hole Ø1 of the straight tower and the diameter of the conductor hanging hole Ø2 of the straight tower and enter step S2. If not, enter step S3. S2. According to the acquired diameter Ø1 of the ground wire hanging hole of the straight tower and the diameter Ø2 of the wire hanging hole of the straight tower, a matching ZBS hanging plate connecting tower fitting with a first bolt diameter M1 is extracted from a preset mapping table, and the extracted ZBS hanging plate connecting tower fitting is actually compared with the ground wire hanging hole and the wire hanging hole of the straight tower. If the first bolt diameter M1 of the extracted ZBS hanging plate connecting tower fitting is not larger than the diameter Ø1 of the ground wire hanging hole and the diameter Ø2 of the wire hanging hole of the straight tower, the matching operation is completed; the mapping table stores the hanging hole sizes of commonly used tower types and the tower bolt sizes of commonly used electrical connection fittings; S3, determine whether the tower type to be matched is a tension tower, if so, obtain the ground wire hanging hole diameter Ø3, the conductor hanging hole diameter Ø4 and the jumper hanging hole diameter Ø5 of the tension tower and enter step S4; S4. According to the acquired ground wire hanging hole diameter Ø3, conductor hanging hole diameter Ø4 and jumper hanging hole diameter Ø5 of the tension tower, the matching U-shaped hanging ring tower fitting with a first bolt diameter M2 and the UB hanging plate tower fitting with a first bolt diameter M3 are extracted from the preset mapping table. The extracted U-shaped hanging ring tower fitting and the UB hanging plate tower fitting are actually compared with the ground wire hanging hole, conductor hanging hole and jumper hanging hole of the tension tower. If the extracted first bolt diameter M2 of the U-shaped hanging ring tower fitting and the first bolt diameter M3 of the UB hanging plate tower fitting are not larger than the ground wire hanging hole diameter Ø3, the conductor hanging hole diameter Ø4 and the jumper hanging hole diameter Ø5 of the tension tower, the matching operation is completed.
[0006] Furthermore, step S3 also includes: If the tower type to be matched is not a tension tower, an abnormal prompt message will be output.
[0007] Furthermore, step S2 is specifically as follows: Enter the hanging hole sizes of common tower types and the tower bolt sizes of common electrical connection fittings into an Excel table to form a mapping table; Use the if function in the Excel table to extract the matching ZBS plate-tower fittings with the first bolt diameter M1 from the preset mapping table according to the acquired ground wire hanging hole diameter Ø1 and the wire hanging hole diameter Ø2 of the straight tower, and compare the extracted ZBS plate-tower fittings with the ground wire hanging holes and the wire hanging holes of the straight tower. If the first bolt diameter M1 of the extracted ZBS plate-tower fittings is not greater than the ground wire hanging hole diameter Ø1 and the wire hanging hole diameter Ø2 of the straight tower, the matching operation is completed.
[0008] Furthermore, step S4 is specifically as follows: Use the if function in the Excel table to extract the matching U-shaped hanging ring tower fittings with a first bolt diameter M2 and UB hanging plate tower fittings with a first bolt diameter M3 from the preset mapping table according to the obtained ground wire hanging hole diameter Ø3, wire hanging hole diameter Ø4 and jumper hanging hole diameter Ø5 of the tension tower. The extracted U-shaped hanging ring tower fittings and UB hanging plate tower fittings are actually compared with the ground wire hanging holes, wire hanging holes and jumper hanging holes of the tension tower. If the extracted first bolt diameter M2 of the U-shaped hanging ring tower fitting and the first bolt diameter M3 of the UB hanging plate tower fitting are not larger than the ground wire hanging hole diameter Ø3, wire hanging hole diameter Ø4 and jumper hanging hole diameter Ø5 of the tension tower, the matching operation is completed.
[0009] A fast matching system for electrical connection fittings and towers, comprising a processor and a memory, wherein the memory stores a program or instruction, and when the program or instruction is executed by the processor, the following steps are implemented: S1. Determine whether the tower type to be matched is a straight tower. If so, obtain the diameter of the ground wire hanging hole Ø1 of the straight tower and the diameter of the conductor hanging hole Ø2 of the straight tower and enter step S2. If not, enter step S3. S2. According to the acquired diameter Ø1 of the ground wire hanging hole of the straight tower and the diameter Ø2 of the wire hanging hole of the straight tower, a matching ZBS hanging plate connecting tower fitting with a first bolt diameter M1 is extracted from a preset mapping table, and the extracted ZBS hanging plate connecting tower fitting is actually compared with the ground wire hanging hole and the wire hanging hole of the straight tower. If the first bolt diameter M1 of the extracted ZBS hanging plate connecting tower fitting is not larger than the diameter Ø1 of the ground wire hanging hole and the diameter Ø2 of the wire hanging hole of the straight tower, the matching operation is completed; the mapping table stores the hanging hole sizes of commonly used tower types and the tower bolt sizes of commonly used electrical connection fittings; S3, determine whether the tower type to be matched is a tension tower, if so, obtain the ground wire hanging hole diameter Ø3, the conductor hanging hole diameter Ø4 and the jumper hanging hole diameter Ø5 of the tension tower and enter step S4; S4. According to the acquired ground wire hanging hole diameter Ø3, conductor hanging hole diameter Ø4 and jumper hanging hole diameter Ø5 of the tension tower, the matching U-shaped hanging ring tower fitting with a first bolt diameter M2 and the UB hanging plate tower fitting with a first bolt diameter M3 are extracted from the preset mapping table. The extracted U-shaped hanging ring tower fitting and the UB hanging plate tower fitting are actually compared with the ground wire hanging hole, conductor hanging hole and jumper hanging hole of the tension tower. If the extracted first bolt diameter M2 of the U-shaped hanging ring tower fitting and the first bolt diameter M3 of the UB hanging plate tower fitting are not larger than the ground wire hanging hole diameter Ø3, the conductor hanging hole diameter Ø4 and the jumper hanging hole diameter Ø5 of the tension tower, the matching operation is completed.
[0010] Furthermore, when the program or instruction is executed by the processor, the following steps are implemented: If the tower type to be matched is not a tension tower, an abnormal prompt message will be output.
[0011] Furthermore, when the program or instruction is executed by the processor, the following steps are implemented: Enter the hanging hole sizes of common tower types and the tower bolt sizes of common electrical connection fittings into an Excel table to form a mapping table; Use the if function in the Excel table to extract the matching ZBS plate-tower fittings with the first bolt diameter M1 from the preset mapping table according to the acquired ground wire hanging hole diameter Ø1 and the wire hanging hole diameter Ø2 of the straight tower, and compare the extracted ZBS plate-tower fittings with the ground wire hanging holes and the wire hanging holes of the straight tower. If the first bolt diameter M1 of the extracted ZBS plate-tower fittings is not greater than the ground wire hanging hole diameter Ø1 and the wire hanging hole diameter Ø2 of the straight tower, the matching operation is completed.
[0012] Furthermore, when the program or instruction is executed by the processor, the following steps are implemented: Use the if function in the Excel table to extract the matching U-shaped hanging ring tower fittings with a first bolt diameter M2 and UB hanging plate tower fittings with a first bolt diameter M3 from the preset mapping table according to the obtained ground wire hanging hole diameter Ø3, wire hanging hole diameter Ø4 and jumper hanging hole diameter Ø5 of the tension tower. The extracted U-shaped hanging ring tower fittings and UB hanging plate tower fittings are actually compared with the ground wire hanging holes, wire hanging holes and jumper hanging holes of the tension tower. If the extracted first bolt diameter M2 of the U-shaped hanging ring tower fitting and the first bolt diameter M3 of the UB hanging plate tower fitting are not larger than the ground wire hanging hole diameter Ø3, wire hanging hole diameter Ø4 and jumper hanging hole diameter Ø5 of the tension tower, the matching operation is completed.
[0013] The beneficial effects of the present invention are: The present invention provides a method and system for quickly matching electrical connection hardware with the tower type. The tower type is first determined, and the corresponding hanging hole size is obtained according to the determined tower type. The electrical connection hardware that matches the corresponding hanging hole size is extracted through a preset mapping table, and then combined with further actual comparison, a conclusion of whether the final match is obtained. Once a match is found, the matching operation is completed. The entire operation process greatly optimizes the data volume, improves the data processing rate, and effectively avoids manual judgment to ensure matching accuracy. BRIEF DESCRIPTION OF THE DRAWINGS
[0014] Figure 1 The figure is a flowchart of the steps of a method for quickly matching an electrical connection fitting with an iron tower type of the present invention; Figure 2 The figure shows a structural block diagram of a quick matching system of an electrical connection fitting and an iron tower of the present invention; Figure 3 Shown is a schematic diagram of the parameters of the ZBS hanging board; Figure 4 Shown is a parameter diagram of a U-shaped hanging ring; Figure 5 The figure shows the parameters of the UB hanging board; Figure 6 Shown is a schematic diagram of the matching results; Description of Figure Numbers: 1-Processor; 2-Memory. DETAILED DESCRIPTION
[0015] The present invention is further described below in conjunction with the accompanying drawings and specific embodiments: like Figure 1 As shown, the present invention provides a method for quickly matching an electrical connection fitting with a tower type, comprising the following steps: S1. Determine whether the tower type to be matched is a straight tower. If so, obtain the diameter of the ground wire hanging hole Ø1 of the straight tower and the diameter of the conductor hanging hole Ø2 of the straight tower and enter step S2. If not, enter step S3. S2. According to the acquired diameter Ø1 of the ground wire hanging hole of the straight tower and the diameter Ø2 of the wire hanging hole of the straight tower, a matching ZBS hanging plate connecting tower fitting with a first bolt diameter M1 is extracted from a preset mapping table, and the extracted ZBS hanging plate connecting tower fitting is actually compared with the ground wire hanging hole and the wire hanging hole of the straight tower. If the first bolt diameter M1 of the extracted ZBS hanging plate connecting tower fitting is not larger than the diameter Ø1 of the ground wire hanging hole and the diameter Ø2 of the wire hanging hole of the straight tower, the matching operation is completed; the mapping table stores the hanging hole sizes of commonly used tower types and the tower bolt sizes of commonly used electrical connection fittings; S3, determine whether the tower type to be matched is a tension tower, if so, obtain the ground wire hanging hole diameter Ø3, the conductor hanging hole diameter Ø4 and the jumper hanging hole diameter Ø5 of the tension tower and enter step S4; S4. According to the acquired ground wire hanging hole diameter Ø3, conductor hanging hole diameter Ø4 and jumper hanging hole diameter Ø5 of the tension tower, the matching U-shaped hanging ring tower fitting with a first bolt diameter M2 and the UB hanging plate tower fitting with a first bolt diameter M3 are extracted from the preset mapping table. The extracted U-shaped hanging ring tower fitting and the UB hanging plate tower fitting are actually compared with the ground wire hanging hole, conductor hanging hole and jumper hanging hole of the tension tower. If the extracted first bolt diameter M2 of the U-shaped hanging ring tower fitting and the first bolt diameter M3 of the UB hanging plate tower fitting are not larger than the ground wire hanging hole diameter Ø3, the conductor hanging hole diameter Ø4 and the jumper hanging hole diameter Ø5 of the tension tower, the matching operation is completed.
[0016] From the above description, it can be seen that the present invention has the following beneficial effects: The present invention provides a method for quickly matching electrical connection hardware with the tower type. The tower type is first determined, and the corresponding hanging hole size is obtained according to the determined tower type. The electrical connection hardware that matches the corresponding hanging hole size is extracted through a preset mapping table, and then combined with further actual comparison, a conclusion of whether the final match is obtained. Once the match is found, the matching operation is completed. The entire operation process greatly optimizes the data volume, improves the data processing rate, and effectively avoids manual judgment to ensure matching accuracy.
[0017] Furthermore, step S3 also includes: If the tower type to be matched is not a tension tower, an abnormal prompt message will be output.
[0018] From the above description, it can be seen that, through the above method, if it is neither a straight tower nor a tension tower, it does not belong to the target object of this solution, and therefore subsequent data processing is not performed.
[0019] Furthermore, step S2 is specifically as follows: Enter the hanging hole sizes of common tower types and the tower bolt sizes of common electrical connection fittings into an Excel table to form a mapping table; Use the if function in the Excel table to extract the matching ZBS plate-tower fittings with the first bolt diameter M1 from the preset mapping table according to the acquired ground wire hanging hole diameter Ø1 and the wire hanging hole diameter Ø2 of the straight tower, and compare the extracted ZBS plate-tower fittings with the ground wire hanging holes and the wire hanging holes of the straight tower. If the first bolt diameter M1 of the extracted ZBS plate-tower fittings is not greater than the ground wire hanging hole diameter Ø1 and the wire hanging hole diameter Ø2 of the straight tower, the matching operation is completed.
[0020] From the above description, it can be seen that through the above method, using Excel tables and the if function in Excel tables to perform data analysis and screening, the operation is convenient.
[0021] Furthermore, step S4 is specifically as follows: Use the if function in the Excel table to extract the matching U-shaped hanging ring tower fittings with a first bolt diameter M2 and UB hanging plate tower fittings with a first bolt diameter M3 from the preset mapping table according to the obtained ground wire hanging hole diameter Ø3, wire hanging hole diameter Ø4 and jumper hanging hole diameter Ø5 of the tension tower. The extracted U-shaped hanging ring tower fittings and UB hanging plate tower fittings are actually compared with the ground wire hanging holes, wire hanging holes and jumper hanging holes of the tension tower. If the extracted first bolt diameter M2 of the U-shaped hanging ring tower fitting and the first bolt diameter M3 of the UB hanging plate tower fitting are not larger than the ground wire hanging hole diameter Ø3, wire hanging hole diameter Ø4 and jumper hanging hole diameter Ø5 of the tension tower, the matching operation is completed.
[0022] From the above description, it can be seen that through the above method, using Excel tables and the if function in Excel tables to perform data analysis and screening, the operation is convenient.
[0023] like Figure 2 As shown, the present invention also provides a fast matching system for electrical connection fittings and towers, including a processor 1 and a memory 2, wherein the memory 2 stores a program or instruction, and when the program or instruction is executed by the processor 1, the following steps are implemented: S1. Determine whether the tower type to be matched is a straight tower. If so, obtain the diameter of the ground wire hanging hole Ø1 of the straight tower and the diameter of the conductor hanging hole Ø2 of the straight tower and enter step S2. If not, enter step S3. S2. According to the acquired diameter Ø1 of the ground wire hanging hole of the straight tower and the diameter Ø2 of the wire hanging hole of the straight tower, a matching ZBS hanging plate connecting tower fitting with a first bolt diameter M1 is extracted from a preset mapping table, and the extracted ZBS hanging plate connecting tower fitting is actually compared with the ground wire hanging hole and the wire hanging hole of the straight tower. If the first bolt diameter M1 of the extracted ZBS hanging plate connecting tower fitting is not larger than the diameter Ø1 of the ground wire hanging hole and the diameter Ø2 of the wire hanging hole of the straight tower, the matching operation is completed; the mapping table stores the hanging hole sizes of commonly used tower types and the tower bolt sizes of commonly used electrical connection fittings; S3, determine whether the tower type to be matched is a tension tower, if so, obtain the ground wire hanging hole diameter Ø3, the conductor hanging hole diameter Ø4 and the jumper hanging hole diameter Ø5 of the tension tower and enter step S4; S4. According to the acquired ground wire hanging hole diameter Ø3, conductor hanging hole diameter Ø4 and jumper hanging hole diameter Ø5 of the tension tower, the matching U-shaped hanging ring tower fitting with a first bolt diameter M2 and the UB hanging plate tower fitting with a first bolt diameter M3 are extracted from the preset mapping table. The extracted U-shaped hanging ring tower fitting and the UB hanging plate tower fitting are actually compared with the ground wire hanging hole, conductor hanging hole and jumper hanging hole of the tension tower. If the extracted first bolt diameter M2 of the U-shaped hanging ring tower fitting and the first bolt diameter M3 of the UB hanging plate tower fitting are not larger than the ground wire hanging hole diameter Ø3, the conductor hanging hole diameter Ø4 and the jumper hanging hole diameter Ø5 of the tension tower, the matching operation is completed.
[0024] From the above description, it can be seen that the present invention has the following beneficial effects: The present invention provides a fast matching system for electrical connection hardware and tower type, which first determines the tower type, thereby obtaining the corresponding hanging hole size according to the determined tower type, and extracts the electrical connection hardware that matches the corresponding hanging hole size through a preset mapping table, and then combines further actual comparison to obtain a final conclusion on whether it matches. Once it matches, the matching operation is completed. The entire operation process greatly optimizes the data volume, improves the data processing rate, and effectively avoids manual judgment to ensure matching accuracy.
[0025] Furthermore, when the program or instruction is executed by the processor, the following steps are implemented: If the tower type to be matched is not a tension tower, an abnormal prompt message will be output.
[0026] From the above description, it can be seen that, through the above method, if it is neither a straight tower nor a tension tower, it does not belong to the target object of this solution, and therefore subsequent data processing is not performed.
[0027] Furthermore, when the program or instruction is executed by the processor, the following steps are implemented: Enter the hanging hole sizes of common tower types and the tower bolt sizes of common electrical connection fittings into an Excel table to form a mapping table; Use the if function in the Excel table to extract the matching ZBS plate-tower fittings with the first bolt diameter M1 from the preset mapping table according to the acquired ground wire hanging hole diameter Ø1 and the wire hanging hole diameter Ø2 of the straight tower, and compare the extracted ZBS plate-tower fittings with the ground wire hanging holes and the wire hanging holes of the straight tower. If the first bolt diameter M1 of the extracted ZBS plate-tower fittings is not greater than the ground wire hanging hole diameter Ø1 and the wire hanging hole diameter Ø2 of the straight tower, the matching operation is completed.
[0028] From the above description, it can be seen that through the above method, using Excel tables and the if function in Excel tables to perform data analysis and screening, the operation is convenient.
[0029] Furthermore, when the program or instruction is executed by the processor, the following steps are implemented: Use the if function in the Excel table to extract the matching U-shaped hanging ring tower fittings with a first bolt diameter M2 and UB hanging plate tower fittings with a first bolt diameter M3 from the preset mapping table according to the obtained ground wire hanging hole diameter Ø3, wire hanging hole diameter Ø4 and jumper hanging hole diameter Ø5 of the tension tower. The extracted U-shaped hanging ring tower fittings and UB hanging plate tower fittings are actually compared with the ground wire hanging holes, wire hanging holes and jumper hanging holes of the tension tower. If the extracted first bolt diameter M2 of the U-shaped hanging ring tower fitting and the first bolt diameter M3 of the UB hanging plate tower fitting are not larger than the ground wire hanging hole diameter Ø3, wire hanging hole diameter Ø4 and jumper hanging hole diameter Ø5 of the tension tower, the matching operation is completed.
[0030] From the above description, it can be seen that through the above method, using Excel tables and the if function in Excel tables to perform data analysis and screening, the operation is convenient.
[0031] Several preferred embodiments or application examples are listed below to help those skilled in the art better understand the technical content of the present invention and the technical contribution made by the present invention relative to the prior art: Preferred embodiment one: like Figure 1 , Figures 3 to 6 As shown, the present invention provides a method for quickly matching an electrical connection fitting with a tower type, comprising the following steps: S1. Determine whether the tower type to be matched is a straight tower. If so, obtain the diameter of the ground wire hanging hole Ø1 of the straight tower and the diameter of the conductor hanging hole Ø2 of the straight tower and enter step S2. If not, enter step S3. S2. According to the acquired diameter Ø1 of the ground wire hanging hole of the straight tower and the diameter Ø2 of the wire hanging hole of the straight tower, a matching ZBS hanging plate connecting tower fitting with a first bolt diameter M1 is extracted from a preset mapping table, and the extracted ZBS hanging plate connecting tower fitting is actually compared with the ground wire hanging hole and the wire hanging hole of the straight tower. If the first bolt diameter M1 of the extracted ZBS hanging plate connecting tower fitting is not larger than the diameter Ø1 of the ground wire hanging hole and the diameter Ø2 of the wire hanging hole of the straight tower, the matching operation is completed; the mapping table stores the hanging hole sizes of commonly used tower types and the tower bolt sizes of commonly used electrical connection fittings; Specifically: the hanging hole sizes of commonly used tower types and the tower bolt sizes of commonly used electrical connection hardware are entered into an Excel table to form a mapping table; the if function in the Excel table is used to extract the matching ZBS hanging plate tower fittings with a first bolt diameter M1 from the preset mapping table according to the obtained ground wire hanging hole diameter Ø1 of the straight tower and the wire hanging hole diameter Ø2 of the straight tower, and the extracted ZBS hanging plate tower fittings are actually compared with the ground wire hanging holes and wire hanging holes of the straight tower. If the first bolt diameter M1 of the extracted ZBS hanging plate tower fittings is not greater than the ground wire hanging hole diameter Ø1 and the wire hanging hole diameter Ø2 of the straight tower, the matching operation is completed.
[0032] S3. Determine whether the tower type to be matched is a tension tower. If so, obtain the ground wire hanging hole diameter Ø3, the conductor hanging hole diameter Ø4 and the jumper hanging hole diameter Ø5 of the tension tower and enter step S4; if the tower type to be matched is not a tension tower, output an abnormal prompt message.
[0033] S4. According to the acquired ground wire hanging hole diameter Ø3, conductor hanging hole diameter Ø4 and jumper hanging hole diameter Ø5 of the tension tower, the matching U-shaped hanging ring tower fitting with a first bolt diameter M2 and the UB hanging plate tower fitting with a first bolt diameter M3 are extracted from the preset mapping table. The extracted U-shaped hanging ring tower fitting and the UB hanging plate tower fitting are actually compared with the ground wire hanging hole, conductor hanging hole and jumper hanging hole of the tension tower. If the extracted first bolt diameter M2 of the U-shaped hanging ring tower fitting and the first bolt diameter M3 of the UB hanging plate tower fitting are not larger than the ground wire hanging hole diameter Ø3, the conductor hanging hole diameter Ø4 and the jumper hanging hole diameter Ø5 of the tension tower, the matching operation is completed.
[0034] Specifically: Use the if function in the Excel table to extract the matching U-shaped hanging ring tower fittings with a first bolt diameter M2 and UB hanging plate tower fittings with a first bolt diameter M3 from the preset mapping table according to the obtained ground wire hanging hole diameter Ø3, wire hanging hole diameter Ø4 and jumper hanging hole diameter Ø5 of the tension tower. The extracted U-shaped hanging ring tower fittings and UB hanging plate tower fittings are actually compared with the ground wire hanging holes, wire hanging holes and jumper hanging holes of the tension tower. If the extracted first bolt diameter M2 of the U-shaped hanging ring tower fitting and the first bolt diameter M3 of the UB hanging plate tower fitting are not larger than the ground wire hanging hole diameter Ø3, wire hanging hole diameter Ø4 and jumper hanging hole diameter Ø5 of the tension tower, the matching operation is completed.
[0035] In this embodiment, the hanging hole sizes of common tower types and the tower bolt sizes of common electrical fittings are entered in an Excel table, and the tower hanging hole sizes are entered in the order of ground wire hanging hole - conductor hanging hole - jumper hanging hole.
[0036] In the electrical fittings table, enter the diameter of the first bolt of the ZBS plate tower fitting and the diameter of the first bolt of the U-shaped ring tower fitting. Use the if function in Excel to compare the size relationship between the tower bolt size of the fitting and the tower hanging hole diameter. If the tower bolt size of the fitting is smaller than the corresponding hanging hole diameter, select the fitting to match the tower type; if the tower bolt size of the fitting is larger than the corresponding hanging hole diameter, reselect the fitting.
[0037] According to the tower type determined by the designer during the design process, select the corresponding screening table. This table lists the common ZBS hanging plate type, U-shaped hanging ring type and UB hanging plate type. Figures 3 to 5 As shown, all have been entered.
[0038] like Figure 6 As shown, the designer can select the corresponding hardware type. If the hardware is suitable for the tower type, the table will prompt that it is satisfied. If it is not suitable for the tower type, the table will prompt that it is not satisfied, and you need to reselect it.
[0039] Preferred embodiment 2: like Figure 2 As shown, the present invention also provides a fast matching system for electrical connection fittings and towers, including a processor 1 and a memory 2, wherein the memory 2 stores a program or instruction, and when the program or instruction is executed by the processor 1, the following steps are implemented: S1. Determine whether the tower type to be matched is a straight tower. If so, obtain the diameter of the ground wire hanging hole Ø1 of the straight tower and the diameter of the conductor hanging hole Ø2 of the straight tower and enter step S2. If not, enter step S3. S2. According to the acquired diameter Ø1 of the ground wire hanging hole of the straight tower and the diameter Ø2 of the wire hanging hole of the straight tower, a matching ZBS hanging plate connecting tower fitting with a first bolt diameter M1 is extracted from a preset mapping table, and the extracted ZBS hanging plate connecting tower fitting is actually compared with the ground wire hanging hole and the wire hanging hole of the straight tower. If the first bolt diameter M1 of the extracted ZBS hanging plate connecting tower fitting is not larger than the diameter Ø1 of the ground wire hanging hole and the diameter Ø2 of the wire hanging hole of the straight tower, the matching operation is completed; the mapping table stores the hanging hole sizes of commonly used tower types and the tower bolt sizes of commonly used electrical connection fittings; S3, determine whether the tower type to be matched is a tension tower, if so, obtain the ground wire hanging hole diameter Ø3, the conductor hanging hole diameter Ø4 and the jumper hanging hole diameter Ø5 of the tension tower and enter step S4; S4. According to the acquired ground wire hanging hole diameter Ø3, conductor hanging hole diameter Ø4 and jumper hanging hole diameter Ø5 of the tension tower, the matching U-shaped hanging ring tower fitting with a first bolt diameter M2 and the UB hanging plate tower fitting with a first bolt diameter M3 are extracted from the preset mapping table. The extracted U-shaped hanging ring tower fitting and the UB hanging plate tower fitting are actually compared with the ground wire hanging hole, conductor hanging hole and jumper hanging hole of the tension tower. If the extracted first bolt diameter M2 of the U-shaped hanging ring tower fitting and the first bolt diameter M3 of the UB hanging plate tower fitting are not larger than the ground wire hanging hole diameter Ø3, the conductor hanging hole diameter Ø4 and the jumper hanging hole diameter Ø5 of the tension tower, the matching operation is completed.
[0040] Furthermore, when the program or instruction is executed by the processor, the following steps are implemented: If the tower type to be matched is not a tension tower, an abnormal prompt message will be output.
[0041] Furthermore, when the program or instruction is executed by the processor, the following steps are implemented: Enter the hanging hole sizes of common tower types and the tower bolt sizes of common electrical connection fittings into an Excel table to form a mapping table; Use the if function in the Excel table to extract the matching ZBS plate-tower fittings with the first bolt diameter M1 from the preset mapping table according to the acquired ground wire hanging hole diameter Ø1 and the wire hanging hole diameter Ø2 of the straight tower, and compare the extracted ZBS plate-tower fittings with the ground wire hanging holes and the wire hanging holes of the straight tower. If the first bolt diameter M1 of the extracted ZBS plate-tower fittings is not greater than the ground wire hanging hole diameter Ø1 and the wire hanging hole diameter Ø2 of the straight tower, the matching operation is completed.
[0042] Furthermore, when the program or instruction is executed by the processor, the following steps are implemented: Use the if function in the Excel table to extract the matching U-shaped hanging ring tower fittings with a first bolt diameter M2 and UB hanging plate tower fittings with a first bolt diameter M3 from the preset mapping table according to the obtained ground wire hanging hole diameter Ø3, wire hanging hole diameter Ø4 and jumper hanging hole diameter Ø5 of the tension tower. The extracted U-shaped hanging ring tower fittings and UB hanging plate tower fittings are actually compared with the ground wire hanging holes, wire hanging holes and jumper hanging holes of the tension tower. If the extracted first bolt diameter M2 of the U-shaped hanging ring tower fitting and the first bolt diameter M3 of the UB hanging plate tower fitting are not larger than the ground wire hanging hole diameter Ø3, wire hanging hole diameter Ø4 and jumper hanging hole diameter Ø5 of the tension tower, the matching operation is completed.
[0043] The present invention has been described by the above-mentioned relevant embodiments and drawings, but the above-mentioned embodiments are only examples for implementing the present invention. It must be pointed out that the disclosed embodiments do not limit the scope of the present invention. On the contrary, modifications and equivalent settings included in the spirit and scope of the claims are all included in the scope of the present invention.
Claims
1. A method for quickly matching electrical connection fittings with tower types, characterized in that: The following steps are involved: S1. Determine whether the tower type to be matched is a straight tower. If so, obtain the diameter of the ground wire hanging hole Ø1 of the straight tower and the diameter of the conductor hanging hole Ø2 of the straight tower and enter step S2. If not, enter step S3. S2. According to the acquired diameter Ø1 of the ground wire hanging hole of the straight tower and the diameter Ø2 of the wire hanging hole of the straight tower, a matching ZBS hanging plate connecting tower fitting with a first bolt diameter M1 is extracted from a preset mapping table, and the extracted ZBS hanging plate connecting tower fitting is actually compared with the ground wire hanging hole and the wire hanging hole of the straight tower. If the first bolt diameter M1 of the extracted ZBS hanging plate connecting tower fitting is not larger than the diameter Ø1 of the ground wire hanging hole and the diameter Ø2 of the wire hanging hole of the straight tower, the matching operation is completed; the mapping table stores the hanging hole sizes of commonly used tower types and the tower bolt sizes of commonly used electrical connection fittings; S3, determine whether the tower type to be matched is a tension tower, if so, obtain the ground wire hanging hole diameter Ø3, the conductor hanging hole diameter Ø4 and the jumper hanging hole diameter Ø5 of the tension tower and enter step S4; S4. According to the acquired ground wire hanging hole diameter Ø3, conductor hanging hole diameter Ø4 and jumper hanging hole diameter Ø5 of the tension tower, the matching U-shaped hanging ring tower fitting with a first bolt diameter M2 and the UB hanging plate tower fitting with a first bolt diameter M3 are extracted from the preset mapping table. The extracted U-shaped hanging ring tower fitting and the UB hanging plate tower fitting are actually compared with the ground wire hanging hole, conductor hanging hole and jumper hanging hole of the tension tower. If the extracted first bolt diameter M2 of the U-shaped hanging ring tower fitting and the first bolt diameter M3 of the UB hanging plate tower fitting are not larger than the ground wire hanging hole diameter Ø3, the conductor hanging hole diameter Ø4 and the jumper hanging hole diameter Ø5 of the tension tower, the matching operation is completed.
2. A method for quickly matching electrical connection fittings with towers according to claim 1, characterized in that: Step S3 also includes: If the tower type to be matched is not a tension tower, an abnormal prompt message will be output.
3. The method for quickly matching electrical connection fittings with towers according to claim 1, characterized in that: Step S2 is specifically as follows: Enter the hanging hole sizes of common tower types and the tower bolt sizes of common electrical connection fittings into an Excel table to form a mapping table; Use the if function in the Excel table to extract the matching ZBS plate-tower fittings with the first bolt diameter M1 from the preset mapping table according to the acquired ground wire hanging hole diameter Ø1 and the wire hanging hole diameter Ø2 of the straight tower, and compare the extracted ZBS plate-tower fittings with the ground wire hanging holes and the wire hanging holes of the straight tower. If the first bolt diameter M1 of the extracted ZBS plate-tower fittings is not greater than the ground wire hanging hole diameter Ø1 and the wire hanging hole diameter Ø2 of the straight tower, the matching operation is completed.
4. A method for quickly matching electrical connection fittings with towers according to claim 3, characterized in that: Step S4 is specifically as follows: Use the if function in the Excel table to extract the matching U-shaped hanging ring tower fittings with a first bolt diameter M2 and UB hanging plate tower fittings with a first bolt diameter M3 from the preset mapping table according to the obtained ground wire hanging hole diameter Ø3, wire hanging hole diameter Ø4 and jumper hanging hole diameter Ø5 of the tension tower. The extracted U-shaped hanging ring tower fittings and UB hanging plate tower fittings are actually compared with the ground wire hanging holes, wire hanging holes and jumper hanging holes of the tension tower. If the extracted first bolt diameter M2 of the U-shaped hanging ring tower fitting and the first bolt diameter M3 of the UB hanging plate tower fitting are not larger than the ground wire hanging hole diameter Ø3, wire hanging hole diameter Ø4 and jumper hanging hole diameter Ø5 of the tension tower, the matching operation is completed.
5. A quick matching system between electrical connection fittings and towers, characterized in that: The system comprises a processor and a memory, wherein the memory stores a program or an instruction, and when the program or the instruction is executed by the processor, the following steps are implemented: S1. Determine whether the tower type to be matched is a straight tower. If so, obtain the diameter of the ground wire hanging hole Ø1 of the straight tower and the diameter of the conductor hanging hole Ø2 of the straight tower and enter step S2. If not, enter step S3. S2. According to the acquired diameter Ø1 of the ground wire hanging hole of the straight tower and the diameter Ø2 of the wire hanging hole of the straight tower, a matching ZBS hanging plate connecting tower fitting with a first bolt diameter M1 is extracted from a preset mapping table, and the extracted ZBS hanging plate connecting tower fitting is actually compared with the ground wire hanging hole and the wire hanging hole of the straight tower. If the first bolt diameter M1 of the extracted ZBS hanging plate connecting tower fitting is not larger than the diameter Ø1 of the ground wire hanging hole and the diameter Ø2 of the wire hanging hole of the straight tower, the matching operation is completed; the mapping table stores the hanging hole sizes of commonly used tower types and the tower bolt sizes of commonly used electrical connection fittings; S3, determine whether the tower type to be matched is a tension tower, if so, obtain the ground wire hanging hole diameter Ø3, the conductor hanging hole diameter Ø4 and the jumper hanging hole diameter Ø5 of the tension tower and enter step S4; S4. According to the acquired ground wire hanging hole diameter Ø3, conductor hanging hole diameter Ø4 and jumper hanging hole diameter Ø5 of the tension tower, the matching U-shaped hanging ring tower fitting with a first bolt diameter M2 and the UB hanging plate tower fitting with a first bolt diameter M3 are extracted from the preset mapping table. The extracted U-shaped hanging ring tower fitting and the UB hanging plate tower fitting are actually compared with the ground wire hanging hole, conductor hanging hole and jumper hanging hole of the tension tower. If the extracted first bolt diameter M2 of the U-shaped hanging ring tower fitting and the first bolt diameter M3 of the UB hanging plate tower fitting are not larger than the ground wire hanging hole diameter Ø3, the conductor hanging hole diameter Ø4 and the jumper hanging hole diameter Ø5 of the tension tower, the matching operation is completed.
6. A quick matching system between electrical connection fittings and towers according to claim 5, characterized in that: When the program or instruction is executed by the processor, the following steps are implemented: If the tower type to be matched is not a tension tower, an abnormal prompt message will be output.
7. A quick matching system between electrical connection fittings and towers according to claim 5, characterized in that: When the program or instruction is executed by the processor, the following steps are implemented: Enter the hanging hole sizes of common tower types and the tower bolt sizes of common electrical connection fittings into an Excel table to form a mapping table; Use the if function in the Excel table to extract the matching ZBS plate-tower fittings with the first bolt diameter M1 from the preset mapping table according to the acquired ground wire hanging hole diameter Ø1 and the wire hanging hole diameter Ø2 of the straight tower, and compare the extracted ZBS plate-tower fittings with the ground wire hanging holes and the wire hanging holes of the straight tower. If the first bolt diameter M1 of the extracted ZBS plate-tower fittings is not greater than the ground wire hanging hole diameter Ø1 and the wire hanging hole diameter Ø2 of the straight tower, the matching operation is completed.
8. A quick matching system between electrical connection fittings and towers according to claim 7, characterized in that: When the program or instruction is executed by the processor, the following steps are implemented: Use the if function in the Excel table to extract the matching U-shaped hanging ring tower fittings with a first bolt diameter M2 and UB hanging plate tower fittings with a first bolt diameter M3 from the preset mapping table according to the obtained ground wire hanging hole diameter Ø3, wire hanging hole diameter Ø4 and jumper hanging hole diameter Ø5 of the tension tower. The extracted U-shaped hanging ring tower fittings and UB hanging plate tower fittings are actually compared with the ground wire hanging holes, wire hanging holes and jumper hanging holes of the tension tower. If the extracted first bolt diameter M2 of the U-shaped hanging ring tower fitting and the first bolt diameter M3 of the UB hanging plate tower fitting are not larger than the ground wire hanging hole diameter Ø3, wire hanging hole diameter Ø4 and jumper hanging hole diameter Ø5 of the tension tower, the matching operation is completed.