Tension in Lifting Slings
 

This Excel calculation can be downloaded by ExcelCalcs subscribers.Please login or Subscribe.

Description:
Calculation Preview


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
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Sling Tension Calculation
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Safe Working Load
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |

 

Version History
Subscribe to this topic and get notified by mail about new posts Favorite to this topic Discuss this item in the forum. Check the version history to see how this calculation has changed over time. Use the Subscribe button to receive an automatic email should this calculation be updated to a higher version. Use the Favourite button so you can easily find this calculation in the future.

Submitted On:
03 Aug 2014
Submitted By:
sonicboomman2008
File Date:
25 Jul 2014
File Author:
Roland Cranford
File Version:
1.0
File Size:
353.50 Kb
File Type:
xlsx
Downloads:
137
Rating:
stars/0.gifTotal Votes:0
HTML Link:
Copy code below to your web page to create link to this page:
HTML Window:
Copy code below to your web page to create a dynamic window to this download:
Like This?:
View the profile of the person who submitted this calculation and see all their other calculations hosted at ExcelCalcs.
Need Help?:
Use the comment feature below to raise any questions relating to this download. The question will be automatically emailed the author and all users subscribing to this comment thread.

Comments  

 
#2 gregseipel 2017-11-10 16:43
three green cells do not calculate-no formula in these cells.
 
 
#1 JohnDoyle[Admin] 2014-07-29 08:39
Another great calculation to add to your collection. Enjoy your free lifetime XLC Pro subscription. We are very pleased to have your support.
 

Please sign in or register to add a comment.

We have 9 guests and 40 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.

 

 

Google Analytics Alternative