BTH pinned plate

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
Padeye.xls
Aerospace_lug_analysis.xls
Pin and Lug.xls
Pin and Lug - Static and Fatigue.xls

Calculation Reference
Design of pinned connections
Steel Structures