Method for automatically calculating load of hoisting sling through spreadsheet

Abstract

The invention belongs to the technical field of hoisting, and particularly relates to a method for automatically calculating the load of a hoisting sling through a spreadsheet, which comprehensively considers the three-dimensional space arrangement of a hoisting object and the sling, and greatly improves the calculation accuracy and reliability through automatic calculation. And 2, compared with a traditional manual calculation mode, the method has the advantages that the calculation time is remarkably shortened, and the labor cost is reduced. And 3, by repeatedly adjusting the three-dimensional space data of the sling, the configuration of the sling can be optimized, and the safety and efficiency of lifting operation are ensured. And 4, potential safety hazards can be found in time, safety accidents in the lifting operation are avoided, and the safety of personnel and equipment is guaranteed.

Description

Technical Field

[0001] The invention belongs to the technical field of lifting, and in particular relates to a method for automatically calculating the load of a lifting sling using an electronic spreadsheet. Background Art

[0002] In lifting operations, it is crucial to accurately assess the load capacity and safety of slings. Traditional lifting requires designers to have high professional skills and spend a long time to calculate the load and configure the slings. The sling load calculation mainly relies on estimation methods and manual calculations. The estimation results are inaccurate and incomplete, which poses a great safety hazard to lifting operations. This method is not only time-consuming and labor-intensive, but also prone to errors, especially when dealing with lifting objects of complex shapes and weights, its accuracy is even more difficult to guarantee. Summary of the invention

[0003] The purpose of the present invention is to provide a method for automatically calculating the load of a lifting sling using an electronic spreadsheet, aiming to solve the technical problem of inaccurate estimation results of the safety factor of the sling in the prior art.

[0004] To achieve the above object, an embodiment of the present invention provides a method for automatically calculating the load of a lifting sling using an electronic spreadsheet, comprising the following steps:

[0005] S200: Collect the parameters of the size, weight, center of gravity, lifting point, lifting height and the arrangement of the lifting sling type of the lifting object;

[0006] S210: Based on the above parameters, a schematic diagram of a three-dimensional space model of lifting and hoisting combined with a lifting object and a lifting sling is drawn;

[0007] S220: Based on the schematic diagram of the three-dimensional space model, according to the Pythagorean theorem and the geometric properties of the ellipse, a calculation formula is compiled, a first electronic spreadsheet is set, and the size, weight, center of gravity position, lifting point position, lifting height, and sling length of the lifting object and calculation condition data collected in S200 are input to automatically calculate the sling length;

[0008] S230: Based on the schematic diagram of the three-dimensional space model and according to trigonometric functions, a calculation formula is compiled, a second electronic spreadsheet is set, and the result data and calculation condition data of the above S220 are called to automatically calculate the load, force angle and three-dimensional direction component of the sling;

[0009] S240: Based on the schematic diagram of the three-dimensional space model, a calculation formula is compiled, a third electronic spreadsheet is set, and the result data and calculation condition data of the above S230 are called to automatically calculate the actual safety factor of the sling;

[0010] S250: Compare whether the actual safety factor of the sling meets the rated safety factor. When the actual safety factor is greater than the rated safety factor, it is determined that the configuration of the sling and the lifting object meets the requirements. When the actual safety factor is less than the rated safety factor, it is determined that the configuration of the sling and the lifting object does not meet the requirements. Return to the first spreadsheet of S220, readjust the sling parameters, and automatically update the calculation results.

[0011] Further, the basic arrangement of the sling includes a single-machine sling, a multi-machine sling, a single-hook sling or a multi-hook sling.

[0012] Furthermore, the sling comprises a lifting eye, a shackle and a lifting rope, the crane is connected to the lifting eye, the lifting eye is connected to one end of the lifting rope, and the other end is connected to the shackle.

[0013] Furthermore, the lifting ropes are provided with L1, L2, L3, and L4 respectively, and the dimensions Xa, Ya, Za, weight, center of gravity position, lifting point position, and lifting height of the lifted object are collected to construct a three-dimensional space model.

[0014] Furthermore, based on the trigonometric function a 2 +b 2 =c 2 , calculate the length of the sling according to the length, width and height dimensions of the lift object Xa, Ya, Za, the position of the lifting point and the center of gravity.

[0015] Furthermore, based on the geometric properties of the ellipse x 2 / a 2 +y2 / b 2 =1, and the positioning coordinates of the four groups of suspension ropes L1, L2, L3, and L4 are obtained.

[0016] Furthermore, based on the force analysis, the suspension rope L1 is divided into the load F1 along the suspension rope direction, the vertical component F1Z of F1 on the Z axis, the horizontal components F1X and F1Y of F1 on the XY axis, and the combined component F1XY; based on the trigonometric function (sina)2+(cosa)2=1, the load F1, the components F1Z, F1X, F1Y, F1XY and the load angle are calculated.

[0017] Furthermore, in the third electronic spreadsheet, an "IF" instruction is used to determine whether the actual safety factor is greater than the rated safety factor.

[0018] Furthermore, the first electronic form, the second electronic form and the third electronic form are all Excel forms.

[0019] The above one or more technical solutions in the method for automatically calculating the load of a lifting sling using an electronic spreadsheet provided in an embodiment of the present invention have at least one of the following technical effects:

[0020] Parameter collection: Use professional tools to measure various parameters of the lifting object and the working environment.

[0021] Three-dimensional space model: Based on the collected parameters, use drawing software to construct a three-dimensional space model plane diagram of the lifting operation scene.

[0022] Automatic calculation: By setting up a spreadsheet, inputting the parameters of the hoisted object and slings and calculation conditions, key indicators such as the sling length, load, force angle, safety factor, etc. can be automatically calculated.

[0023] Safety judgment and adjustment: judge whether the sling and lifting object configuration meet the requirements based on the calculation results. If not, return to adjust the input data of the first table and recalculate.

[0024] 1. By comprehensively considering the three-dimensional spatial layout of the lifting object and the sling, the calculation is automated, which greatly improves the accuracy and reliability of the calculation. 2. Compared with the traditional manual calculation method, this method significantly shortens the calculation time and reduces the labor cost. 3. By repeatedly adjusting the sling parameters, the configuration of the sling can be optimized to ensure the safety and efficiency of the lifting operation. 4. This method can timely discover potential safety hazards, avoid safety accidents in lifting operations, and ensure the safety of personnel and equipment. BRIEF DESCRIPTION OF THE DRAWINGS

[0025] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.

[0026] Figure 1 A schematic diagram of the flow structure of a method for automatically calculating the load of a lifting sling using an electronic spreadsheet provided in an embodiment of the present invention;

[0027] Figure 2 A schematic diagram of the three-dimensional structure of a lifting three-dimensional space model of a method for automatically calculating the load of a lifting sling using an electronic spreadsheet provided in an embodiment of the present invention;

[0028] Figure 3 A calculation data diagram of the length of the lifting rope of the lifting sling load method automatically calculated by the electronic form provided by the embodiment of the present invention;

[0029] Figure 4 A calculation data diagram of the load, force angle and three-dimensional force components of a sling provided by an electronic spreadsheet in an embodiment of the present invention for automatically calculating the load of a lifting sling;

[0030] Figure 5 A calculation data diagram of a determination formula for automatically calculating a load method for a lifting sling using an electronic spreadsheet provided in an embodiment of the present invention. DETAILED DESCRIPTION

[0031] The embodiments of the present invention are described in detail below. Examples of the embodiments are shown in the accompanying drawings 1-5, wherein the same or similar reference numerals throughout represent the same or similar elements or elements having the same or similar functions. Figure 1-5 The described embodiments are exemplary and are intended to be used to explain the embodiments of the present invention, but should not be construed as limiting the present invention.

[0032] In the description of the embodiments of the present invention, it should be understood that the terms "length", "width", "up", "down", "front", "back", "left", "right", "vertical", "horizontal", "top", "bottom", "inside" and "outside" etc., indicating orientations or positional relationships, are based on the orientations or positional relationships shown in the accompanying drawings, and are only for the convenience of describing the embodiments of the present invention and simplifying the description, and do not indicate or imply that the referred device or element must have a specific orientation, be constructed and operated in a specific orientation, and therefore should not be understood as a limitation on the present invention.

[0033] In addition, the terms "first" and "second" are used for descriptive purposes only and should not be understood as indicating or implying relative importance or implicitly indicating the number of the indicated technical features. Thus, a feature defined as "first" or "second" may explicitly or implicitly include one or more of the features. In the description of the embodiments of the present invention, the meaning of "plurality" is two or more, unless otherwise clearly and specifically defined.

[0034] In the embodiments of the present invention, unless otherwise clearly specified and limited, the terms "installed", "connected", "connected", "fixed" and the like should be understood in a broad sense, for example, it can be a fixed connection, a detachable connection, or an integral connection; it can be a mechanical connection or an electrical connection; it can be a direct connection or an indirect connection through an intermediate medium, it can be the internal connection of two elements or the interaction relationship between two elements. For ordinary technicians in this field, the specific meanings of the above terms in the embodiments of the present invention can be understood according to specific circumstances.

[0035] In one embodiment of the present invention, Figure 1-5 As shown, a method for automatically calculating the load of a lifting sling using an electronic spreadsheet is provided, comprising the following steps:

[0036] S200: Collect the parameters of the size, weight, center of gravity, lifting point, lifting height and the arrangement of the lifting sling type of the lifting object;

[0037] S210: Based on the above parameters, a schematic diagram of a three-dimensional space model of lifting and hoisting combined with a lifting object and a lifting sling is drawn;

[0038] S220: Based on the schematic diagram of the three-dimensional space model, according to the Pythagorean theorem and the geometric properties of the ellipse, a calculation formula is compiled, a first electronic spreadsheet is set, and the size, weight, center of gravity position, lifting point position, lifting height, and sling length of the lifting object and calculation condition data collected in S200 are input to automatically calculate the sling length;

[0039] S230: Based on the schematic diagram of the three-dimensional space model and according to trigonometric functions, a calculation formula is compiled, a second electronic spreadsheet is set, and the result data and calculation condition data of the above S220 are called to automatically calculate the load, force angle and three-dimensional direction component of the sling;

[0040] S240: Based on the schematic diagram of the three-dimensional space model, a calculation formula is compiled, a third electronic spreadsheet is set, and the result data and calculation condition data of the above S230 are called to automatically calculate the actual safety factor of the sling;

[0041] S250: Compare whether the actual safety factor of the sling meets the rated safety factor. When the actual safety factor is greater than the rated safety factor, it is determined that the configuration of the sling and the lifting object meets the requirements. When the actual safety factor is less than the rated safety factor, it is determined that the configuration of the sling and the lifting object does not meet the requirements. Return to the first spreadsheet of S220, readjust the sling parameters, and automatically update the calculation results.

[0042] Specifically, 1. Use professional tools to measure various parameters of the lifting object and the working environment. 2. Based on the collected parameters, use drawing software to construct a three-dimensional spatial model plane diagram of the lifting operation scene. 3. By setting up a spreadsheet, input the parameters and calculation conditions of the lifting object and slings, and automatically calculate key indicators such as the sling length, load, force angle, safety factor, etc. 4. Safety judgment and adjustment: Determine whether the sling and lifting object configuration meets the requirements based on the calculation results. If not, return to the first spreadsheet, readjust the sling parameters and recalculate.

[0043] 1. By comprehensively considering the three-dimensional spatial layout of the lifting object and the sling, the calculation is automated, which greatly improves the accuracy and reliability of the calculation. 2. Compared with the traditional manual calculation method, this method significantly shortens the calculation time and reduces the labor cost. 3. By repeatedly adjusting the sling parameters, the configuration of the sling can be optimized to ensure the safety and efficiency of the lifting operation. 4. This method can timely discover potential safety hazards, avoid safety accidents in lifting operations, and ensure the safety of personnel and equipment.

[0044] Further, if Figure 2As shown, the basic arrangement of slings includes single-machine slings, multi-machine slings, single-hook slings or multi-hook slings. The slings include a lifting lug, a shackle, and a lifting rope. The crane is connected to the lifting lug, and the lifting lug is connected to one end of the lifting rope, and the other end is connected to the shackle. Specifically, by providing a variety of types of sling arrangements, different lifting requirements can be flexibly responded to, thereby improving lifting efficiency. For example, for objects with large weight and volume, multi-machine slings can be used to ensure safety and stability; while for simple lifting tasks, single-hook slings can be used to simplify the operation.

[0045] Further, if Figure 2-5 As shown, the lifting ropes are respectively provided with L1, L2, L3, and L4, and the dimensions Xa, Ya, Za, weight, center of gravity position, lifting point position, and lifting height of the lifting object are collected to construct a schematic diagram of the three-dimensional space model. 2 +b 2 =c 2 , according to the length, width and height dimensions of the lifting object Xa, Ya, Za, the lifting point position and the center of gravity position, calculate the length of the sling. Based on the geometric properties of the ellipse x 2 / a 2 +y2 / b 2 =1, the positioning coordinates of the four groups of suspension ropes L1, L2, L3, and L4 are obtained. Based on the force analysis, the suspension rope L1 is divided into the load F1 along the suspension rope direction, the vertical component F1Z of F1 on the Z axis, the horizontal components F1X and F1Y of F1 on the XY axis, and the combined component F1XY; based on the trigonometric function (sina)2+(cosa)2=1, the load F1, the components F1Z, F1X, F1Y, F1XY and the load angle are calculated. In the third spreadsheet, the "IF" instruction is used to determine whether the actual safety factor is greater than the rated safety factor.

[0046] Specifically, Figure 1-5 As shown in the figure, 1. First, collect the size (Xa, Ya, Za), weight, center of gravity position, lifting point position and lifting height of the lifting object, and then construct a three-dimensional space model schematic diagram. This three-dimensional space model schematic diagram can be used to simulate the lifting process and help determine the length and positioning coordinates of the lifting rope. Based on trigonometric function a 2 +b 2 =c 2 According to the length, width and height of the lifting object, the position of the lifting point and the center of gravity, the length of the lifting rope can be calculated and recorded in the first spreadsheet. The first spreadsheet calls the data and formulas and can update the data synchronously. Based on the geometric properties of the ellipse x 2 / a 2 +y2 / b 2=1, the positioning coordinates of the four groups of lifting ropes L1, L2, L3, and L4 are obtained, ensuring the correct position of the lifting ropes during the lifting process, thereby ensuring the stability and safety of the lifting. 2. Perform a force analysis on the lifting rope L1, and decompose its load F1 into the load along the lifting rope direction, the vertical component F1Z on the Z axis, the horizontal components F1X and F1Y on the XY axis, and the combined component F1XY. Based on the trigonometric function (sina)2+(cosa)2=1, the load F1 and each component and load angle can be calculated and recorded in the second spreadsheet. The data and formula can be called to update the data synchronously. This analysis helps to understand the stress of the lifting rope during the lifting process, so as to take corresponding measures to ensure safety. 3. In the third spreadsheet, the load and load angle of a single lifting point are called to obtain the actual safety factor, and the "IF" instruction is used to determine whether the actual safety factor is greater than the rated safety factor. This is to ensure the safety of the lifting process and prevent safety accidents caused by overloading or improper use of the lifting sling.

[0047] The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the protection scope of the present invention.

Claims

1. A method for automatically calculating the load of a lifting sling using an electronic spreadsheet, characterized in that: The following steps are involved: S200: Collect the parameters of the size, weight, center of gravity, lifting point, lifting height and the arrangement of the lifting sling type of the lifting object; S210: Based on the above parameters, a schematic diagram of a three-dimensional space model of lifting and hoisting of the lifting object and the lifting sling is drawn; S220: Based on the schematic diagram of the three-dimensional space model, according to the Pythagorean theorem and the geometric properties of the ellipse, a calculation formula is compiled, a first electronic spreadsheet is set, and the size, weight, center of gravity position, lifting point position, lifting height, and sling length of the lifting object and calculation condition data collected in S200 are input to automatically calculate the sling length; S230: Based on the schematic diagram of the three-dimensional space model and according to trigonometric functions, a calculation formula is compiled, a second electronic spreadsheet is set, and the result data and calculation condition data of the above S220 are called to automatically calculate the load, force angle and three-dimensional direction component of the sling; S240: Based on the schematic diagram of the three-dimensional space model, a calculation formula is compiled, a third electronic spreadsheet is set, and the result data and calculation condition data of the above S230 are called to automatically calculate the actual safety factor of the sling; S250: Compare whether the actual safety factor of the sling meets the rated safety factor. When the actual safety factor is greater than the rated safety factor, it is determined that the configuration of the sling and the lifting object meets the requirements. When the actual safety factor is less than the rated safety factor, it is determined that the configuration of the sling and the lifting object does not meet the requirements. Return to the first spreadsheet of S220, readjust the sling parameters, and automatically update the calculation results.

2. The method for automatically calculating the load of lifting slings by using an electronic spreadsheet according to claim 1, characterized in that: The basic arrangement of slings includes single-machine slings, multi-machine slings, single-hook slings or multi-hook slings.

3. The method for automatically calculating the load of lifting slings by using an electronic spreadsheet according to claim 2, characterized in that: The sling comprises a lifting lug, a shackle and a lifting rope. The crane is connected to the lifting lug, the lifting lug is connected to one end of the lifting rope, and the other end is connected to the shackle.

4. The method for automatically calculating the load of lifting slings by using an electronic spreadsheet according to claim 3, characterized in that: The lifting ropes are respectively provided with L1, L2, L3, and L4, and the dimensions Xa, Ya, Za, weight, center of gravity position, lifting point position, and lifting height of the lifting object are collected to construct a three-dimensional space model.

5. The method for automatically calculating the load of lifting slings by using an electronic spreadsheet according to claim 3, characterized in that: Based on trigonometric functions 2 +b 2 =c 2 , calculate the length of the sling according to the length, width and height dimensions Xa, Ya, Za of the lifting object, the position of the lifting point and the center of gravity.

6. The method for automatically calculating the load of lifting slings by using an electronic spreadsheet according to claim 4, characterized in that: Based on the geometric properties of ellipse x 2 / a 2 +y2 / b 2 =1, and the positioning coordinates of the four groups of suspension ropes L1, L2, L3, and L4 are obtained.

7. The method for automatically calculating the load of lifting slings by using an electronic spreadsheet according to claim 3, characterized in that: Based on the force analysis, the suspension rope L1 is divided into the load F1 along the suspension rope direction, the vertical component F1Z of F1 on the Z axis, the horizontal components F1X and F1Y of F1 on the XY axis, and the combined component F1XY; based on the trigonometric function (sina)2+(cosa)2=1, the load F1, the components F1Z, F1X, F1Y, F1XY and the load angle are calculated.

8. The method for automatically calculating the load of lifting slings by using an electronic spreadsheet according to claim 1, characterized in that: In the third electronic spreadsheet, an "IF" instruction is used to determine whether the actual safety factor is greater than the rated safety factor.

9. The method for automatically calculating the load of lifting slings by using an electronic spreadsheet according to claim 1, characterized in that: The first electronic form, the second electronic form and the third electronic form are all Excel forms.

Images