: Often used for allowable stress design (ASD) in conjunction with ASME standards. 2. Essential Excel Input Parameters
| Check | Formula | Value | Allowable | Status | |-------|---------|-------|-----------|--------| | Bearing stress | =F/(t Dp) | 125 MPa | 138 MPa | OK | | Tearout capacity | =2 min(...) t 0.6 Fu/FOS | 245 kN | 200 kN | OK | | Net tension | =(W-Dh) t Fu/FOS | 310 kN | 200 kN | OK | | Block shear | =0.6 Fu Anv + Fy Ant | 260 kN | 200 kN | OK | | Weld leg required | ... | 6.2 mm | → use 8 mm | OK |
Lifting lug design calculation is a critical aspect of ensuring safe and efficient lifting operations. Using Excel for lifting lug design calculations offers a convenient and efficient way to analyze various design scenarios and ensure compliance with design criteria. By following the step-by-step guide outlined in this article, you can create a comprehensive lifting lug design calculation Excel template that meets your specific needs. Lifting Lug Design Calculation Excel
To ensure the design is "solid," the Excel formulas must calculate and verify several stress types:
If cheek plates exist, total bearing thickness = t_main + 2×t_cheek. But tearout and net section consider only main plate, unless cheeks are groove welded and fully effective. The sheet should have a toggle. : Often used for allowable stress design (ASD)
Example first row of your calculation sheet:
At the hole cross section, the remaining steel must resist tension. To ensure the design is "solid," the Excel
If the shackle can move sideways, bending stress develops.