Cable tray loading calculation system

Abstract

The invention provides a cable loading calculation system, which adopts a client-server architecture, a client is used for a user to input data and display a calculation result, and a server is responsible for loading calculation and data storage. And the client adopts a Python-based graphical user interface, so that the user operation is convenient. The server side uses a relational database to store specification data of the cable and the cable reel and intermediate data and results in the calculation process; according to the cable loading calculation system, loading lists are exported in batches by importing a cable information table, and an optimal loading plan is automatically generated; the efficiency and accuracy of cable loading calculation are remarkably improved, the calculation time is greatly shortened, the working efficiency of a user is improved, and errors in the traditional manual table calculation process are avoided.

Description

Technical Field

[0001] The present invention relates to the technical field of cable computing software, and in particular to a cable reeling computing system. Background Art

[0002] In the wire and cable manufacturing industry, providing a cable reel list is an important task. Traditional cable reel calculations are performed using Excel spreadsheets and then pasted into the reel list form. This calculation method is acceptable for a small number of reels, but when the amount of cable reel information required is too large, not only is the efficiency low, but it is also prone to copying and pasting errors during actual operation, resulting in unreasonable cable reeling and failing to meet users' requirements for reeling calculation efficiency and accuracy. Summary of the invention

[0003] The purpose of the present invention is to propose a system for calculating cable reels based on cable specifications and cable reel specifications, thereby obtaining an optimal cable reeling plan, saving the use of cable reels, and improving the rationality of cable reels.

[0004] To achieve the above object, the present invention provides a cable tray computing system, including a client and a server;

[0005] The client inputs data and displays calculation results, and the server performs disk calculation and data storage;

[0006] The loading calculation includes the following steps:

[0007] S1: Analyze the existing cable reel information in the system;

[0008] S2: Determine how many reels are needed for the incoming cable object;

[0009] S3: When the user chooses not to limit the maximum number of trays and the tray weight:

[0010] S31: Call the PD function in the cable reel object to pass in the cable object and return the number of cable reels

[0011] S4: When the user chooses not to limit the maximum number of trays but to limit the tray weight:

[0012] S41: Obtain weight distribution;

[0013] S42: Obtaining the length of the tray when the weight is divided into trays;

[0014] S43: calling the PD function in the cable reel object and passing in the cable object, and returning the number of cable reels under the weight-limited reel condition;

[0015] S5: When the maximum number of pallets is limited but the pallet weight is not limited:

[0016] S51: Divide the cable reel length required by the cable limit length to obtain the number of cable reels;

[0017] S52: Obtaining the loading length when the length limit is reached;

[0018] S53: calling the function of returning the number of cable drums, and returning the number of cable drums in the case of weight-limited drums;

[0019] S6: The maximum number of trays and the weight of trays are limited:

[0020] S61: Divide the cable reel length required by the cable limit length to obtain the number of cable reels;

[0021] S62: Obtaining the loading length when the length limit is reached;

[0022] S63: Obtain the number of weight-limited divided disks under the condition of length limit;

[0023] S64: Obtaining the loading length of the tray when the weight is divided into trays under the condition of length limit;

[0024] S65: Obtain the number of weight-limited divided disks under the condition of limited length;

[0025] S7: In order to avoid waste caused by excessive use of the tray, the actual use of the tray is circulated conditionally;

[0026] S8: Output results.

[0027] Compared with the prior art, the advantages of the present invention are:

[0028] 1. The cable loading calculation system of the present invention batch-exports loading lists by importing cable information tables, and automatically generates the optimal loading plan; it significantly improves the efficiency and accuracy of cable loading calculations, greatly shortens the calculation time, improves the user's work efficiency, and avoids errors in the traditional manual calculation process through tables.

[0029] 2. The cable reel calculation system of the present invention can flexibly adjust the cable information and reel information according to actual needs and optimize the reeling plan. The user can choose at least four reeling requirements, thereby improving the user's selectivity and the flexibility of adjusting the reeling plan.

[0030] 3. The cable reel calculation system of the present invention finally verifies the system generated plan, effectively preventing the waste of reels, thereby fully improving the accuracy and rationality of the system generated plan. BRIEF DESCRIPTION OF THE DRAWINGS

[0031] Figure 1 Schematic diagram of the client interface in an embodiment of the present invention. DETAILED DESCRIPTION

[0032] In order to make the purpose, technical solution and advantages of the present invention clearer, the technical solution of the present invention will be further described below.

[0033] The present invention provides a cable tray calculation system, comprising the following structure:

[0034] 1. Software Architecture This software adopts a client-server architecture. The client is used for user input of data and display of calculation results, and the server is responsible for disk loading calculation and data storage. The client uses a Python-based graphical user interface (GUI) to facilitate user operation. The server uses a relational database to store the specification data of cables and cable reels, as well as the intermediate data and results in the calculation process.

[0035] 2. Data input: Users can provide data such as cable length, diameter, type, etc. by importing Excel spreadsheets or manually inputting. The cable reel information can be maintained in the reel information.xlsx file in the reel folder in the same path as the software.

[0036] 3. Core algorithm: Based on the reeling formula (A.1) to (A.2) provided in JB / T8137.1-2013, combined with the object-oriented method, a cable class and a cable reel class are established to encapsulate the cable information imported or owned by the user and each reel information in the reel information data table. By calling the judgment function in the reel information, the suitability of the reel, the required number of reels, and the loading length of each reel are improved. Then, by calling the encapsulated most suitable reel function, the most suitable reel object required is returned, and the reel information is exported or displayed. Considering the bending radius of the cable, the reeling margin, the height limit of the reel, the weight limit of the reel, and the maximum reeling length, the reeling scheme is optimized.

[0037] The operating steps of the system of the present invention are as follows:

[0038] S1: Analyze the existing cable reel information in the system, including the cable reel side plate diameter, cable reel barrel diameter, cable reel inner width, cable reel outer width, the number of corresponding wires installed in the cable reel, cable reel weight and reel margin;

[0039] S2: Determine how many reels are needed for the incoming cable object;

[0040] S3: When the user chooses not to limit the maximum number of trays and the tray weight:

[0041] S31: Call and return the PD function in the cable reel object to pass in the cable object and return the number of cable reels

[0042] S4: When the user chooses not to limit the maximum number of trays but to limit the tray weight:

[0043] S41: Obtain weight distribution;

[0044] S42: Obtaining the length of the tray when the weight is divided into trays;

[0045] S43: calling and returning the PD function in the cable reel object to pass in the cable object, and returning the number of cable reel sub-reels under the weight-limited sub-reels;

[0046] S5: When the maximum number of pallets is limited but the pallet weight is not limited:

[0047] S51: Divide the cable reel length required by the cable limit length to obtain the number of cable reels;

[0048] S52: Obtaining the loading length when the length limit is reached;

[0049] S53: calling the PD function in the cable reel object and passing in the cable object, and returning the number of cable reel sub-reels under the weight-limited sub-reels;

[0050] S6: The maximum number of trays and the weight of trays are limited:

[0051] S61: Divide the cable reel length required by the cable limit length to obtain the number of cable reels;

[0052] S62: Obtaining the loading length when the length limit is reached;

[0053] S63: Obtain the number of weight-limited divided disks under the condition of limited length;

[0054] S64: Obtaining the loading length of the tray when the weight is divided into trays under the condition of length limit;

[0055] S65: Obtain the number of weight-limited divided disks under the condition of limited length;

[0056] S7: In order to avoid waste caused by excessive use of the tray, the actual use of the tray is circulated;

[0057] S71: define a cable object and obtain information for packaging the cable;

[0058] S72: By passing in the cable object, the most suitable reel is selected based on the reel object list in the database; the cable object, the cable reel object and the PD function encapsulated by them are shown as follows:

[0059]

[0060]

[0061]

[0062]

[0063]

[0064]

[0065] S73: Based on the conditional loop calculation in the PD function, the cable drum usage is further accurately calculated.

[0066] S8: Output results.

[0067] Steps:

[0068] like Figure 1 As shown:

[0069] 1. Start the software and enter the main interface.

[0070] 2. Click the "Select Import Data" button and select the cable data file to be processed.

[0071] 3. Click the "Batch calculate and export data table" button to export a turntable list based on the imported data table information.

[0072] 4. Manually enter cable information and select the reel type.

[0073] 5. Click the "Calculate" button and the software will start the loading calculation.

[0074] 6. After the calculation is completed, the loading information is displayed on the client interface.

[0075] 7. If necessary, you can adjust the calculation parameters and recalculate.

[0076] By inputting cable information and selecting the required reel type in the client's GUI interface, the length of each cable reel, the number of reels required, the type of reel, the total weight, volume and other information can be displayed on the client interface. This software is suitable for wire and cable manufacturers, electrical equipment manufacturers, communication engineering companies and other units that need to calculate cable reels.

[0077] The above is only a preferred embodiment of the present invention and does not limit the present invention in any way. Any technician in the relevant technical field, without departing from the scope of the technical solution of the present invention, makes any form of equivalent replacement or modification to the technical solution and technical content disclosed in the present invention, which does not depart from the content of the technical solution of the present invention and still falls within the protection scope of the present invention.

Claims

1. A cable tray calculation system, characterized in that: Including client and server; The client inputs data and displays calculation results, and the server performs disk loading calculation and data storage; The loading calculation comprises the following steps: S1: Analyze the existing cable reel information in the system; S2: Determine how many reels are needed for the incoming cable object; S3: When the user chooses not to limit the maximum number of trays and the tray weight: S31: Call the PD function in the cable reel object to pass in the cable object and return the number of cable reels S4: When the user chooses not to limit the maximum number of trays but to limit the tray weight: S41: Obtain weight distribution; S42: Obtaining the length of the tray when the weight is divided into trays; S43: calling the PD function encapsulated in the cable tray object and passing in the cable object, and returning the number of cable trays in the case of weight-limited trays; S5: When the maximum number of pallets is limited but the pallet weight is not limited: S51: Divide the cable reel length required by the cable limit length to obtain the number of cable reels; S52: Obtaining the loading length when the length limit is reached; S53: calling the function of returning the number of cable drums, and returning the number of cable drums in the case of weight-limited drums; S6: The maximum number of trays and the weight of trays are limited: S61: Divide the cable reel length required by the cable limit length to obtain the number of cable reels; S62: Obtaining the loading length when the length limit is reached; S63: Obtain the number of weight-limited divided disks under the condition of limited length; S64: Obtaining the loading length of the tray when the weight is divided into trays under the condition of length limit; S65: Obtain the number of weight-limited divided disks under the condition of limited length; S7: In order to avoid waste caused by excessive use of trays, the actual use of trays is calculated by conditional loop; S8: Output results.

2. The cable tray calculation system according to claim 1, characterized in that: The cable reel information includes the diameter of the cable reel side plate, the diameter of the cable reel barrel, the inner width of the cable reel, the outer width of the cable reel, the number of corresponding wires installed in the cable reel, the weight of the cable reel and the remaining amount of the reel.

3. The cable tray calculation system according to claim 1, characterized in that: The S7 comprises the following steps: S71: define a cable object and obtain information for packaging the cable; S72: Select the most suitable reel based on the reel object list in the database by inputting the cable object S73: Based on the conditional loop calculation in the PD function, the cable drum usage is further accurately calculated.

4. The cable tray calculation system according to claim 3, characterized in that: The cable object, cable tray object and the PD function encapsulated by them are shown as follows:

5. The cable tray calculation system according to claim 1, characterized in that: The client uses a Python-based graphical user interface.

6. The cable tray calculation system according to claim 1, characterized in that: The server uses a relational database to store specification data of cables and cable reels, as well as intermediate data and results in the calculation process.

Images