Tension in Lifting Slings

Rating:
7

Description


This spreadsheet calculates the tension in each leg of a four leg, single point lifting sling set. User inputs the weight of the object that is being lifted and the locations of the lifting points on the body of the object relative to the apex of the sling set. Excel solver is used to find the sling tensions necessary for equilibrium. All the user needs to do is open (or activate and open) solver and press "solve". The lift points are assumed to lie in a horizontal plane. 

General Notes
Enter weight of object in the blue box labeled "weight".
Enter the lift point locations in their blue boxes.
The vertex of the sling set is considered to be the origin point.
Lift point locations are measured relative to the origin.
Lift points are assumed to lie in a horizontal plane.
All the user needs to do is open the solver and hit run!
Sling tension results are displayed in the "solver results" box.

Solver Notes
The solver routine finds the sling tensions necessary for equilibrium.
Target cell is the "total summation" of all force and moment sums.
Goal is for total sum to equal zero.
Variable cells are the sling tension cells.
Extra constraints added that all force and moment summations must equal zero.
Evolutionary solver tends to work best.
Be patient as the solver frequently runs several thousand subproblems.
 
Calculation Reference
Lifting Sling
Sling Tension Calculation
Safe Working Load

 

Calculation Preview

Uploaded
25 Jul 2014
Last Modified
03 Aug 2014
File Size:
353.50 Kb
Downloads:
194
File Version:
1.0
File Author:
Roland Cranford
Rating:
7

 
Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
Comments: 2
gregseipel 6 years ago
three green cells do not calculate-no formula in these cells.
JohnDoyle[Admin] 9 years ago
Another great calculation to add to your collection. Enjoy your free lifetime XLC Pro subscription. We are very pleased to have your support.