Member Login

Contact Us
post/email Email (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.

Who's Online

We have 12 guests and 45 members online

Total Downloads


Enter Amount:

BTH pinned plate

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


This is an example of how to produce design calculations for a pinned connection using Excel with the XLC add-in.
Design a Plate Lifting Beam and rigging plates to lift a 98 ft, 30" square PSC pile from the pile head using an embedded 2" ID PVC sleeve thru the pile width. The lifter will be capable of crane hook access and transfer the pile load from the lifting pin to the hook by means of independent eyebars from the pin to the plate spreader beam, shackles and a plate lifting beam connected to the hook.
The strength of a pin-connected plate in the region of the pinhole shall be taken as the least value of the tensile strength of the effective area on a plane through the center of the pinhole perpendicular to the line of action of the applied load (Pt), the fracture strength beyond the pinhole on a single plane parallel to the line of action of the applied load (Pb), and the double plan shear strength beyond the pinhole parallel to the line of action of the applied load (Pv).

Related Calculations at ExcelCalcs
Clevis and lug design V0001.xls
S-hook design V0001.xls
Pin and Lug.xls
Pin and Lug - Static and Fatigue.xls

Calculation Reference
Design of pinned connections
| Find on | Find on | Find on | Find on | Find on |
Steel Structures
| Find on | Find on | Find on | Find on | Find on |


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:
18 Jun 2012
Submitted By:
File Date:
04 Sep 2009
File Author:
Martin Grem
File Version:
File Size:
236.00 Kb
File Type:
This download requires the XLC Add-in for Excel to be installed.
stars/4.gifTotal Votes:5
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.


#7 Boss Ed 2012-01-23 09:10
Thanks John,
I have double checked and the issue is applicable to the BTH pinned download as well as the sample xls file supplied and the Trajectories download file....

The freezing issue assocaited with the toggle switch etc

So guess you are right I will uninstall and reinstall....
#6 JohnDoyle 2012-01-23 08:04
It sounds like the XLC addin is not installed correctly (see FAQ's). I should try to uninstall and re-install. I am happy to help via the forum should you have any further difficulties.
#5 Boss Ed 2012-01-23 07:58
guys why on the downloads am I getting #name in fields in the downloads... also the addin refresh tool is freezing the spreadsheet... I am using excel 2010... windows 7.. Have already addin the xlc.dll
#4 bhushankulkar 2011-12-26 15:17
nice one
#3 awenn 2011-06-23 13:45
good thankyou!

Please sign in or register to add a comment.