Pad-eye Design as per Eurocode 3

Description

What does this Excel Sheet do?

This Excel sheet helps you design a pad-eye to be used for lifting or lashing during transport
It can be used for the design of a standard pad-eye with
1. No brackets
2. Single cheek plate on either side

It makes the following checks
1. Geometry check: Main plate radius, Shackle clearances
2. Stress Check for Pin Hole (Tensile, Bearing, Shear, Hertz stress)
3. Stress check for Base Plate (Tensile, Bending, Shear, Von Mises, and Combined)
4. Stress Check for Base Weld (Tensile, Bending, Shear, Total Stress)
5. Shear Stress Check for Cheek Plate Weld

How to use this Excel Sheet
The user is asked for some inputs for the pad-eye geometry and Load on the pad-eye. The Input cells are highlighted in blue.
The user has to provide all the inputs highlighted in blue.
For some inputs, Tables are required to be referred. These Tables are provided along with for the user to enter these inputs.
Once all inputs are provided, the spreadsheet will evaluate the pad-eye design for all the checks mentioned above
*Note: If the load on the pad-eye is exactly in-plane, then simply enter the out-of-plane angle as zero. The spreadsheet will still consider 5% of the Load in the out-of-plane direction

References
1. Eurocode 3: Design of steel structure; Part 1-8: Design of joints
2. 0027/ND Rev 10, June 2013 (Nobledenton Guidelines for Marine Lifting and Lowering operations)