Youtube demo: https://youtu.be/Bcq4eSh43Sg
What does this Excel Sheet do?
This Excel sheet helps you evaluate the strength of a Shear Key
Shear Keys are structural elements which can be used in a variety of scenarios
The spreadsheet is based on API RP2A WSD 2005 Sec 7.4
How to use this Excel Sheet
The user is asked for inputs of pile, sleeve and shear key geometry. The loading condition also has to be specified
The user has to provide all the inputs. The Input cells are highlighted in blue.
Once all inputs are provided, the spreadsheet will evaluate the allowable stresses, perform geometry check and strength check for the shear key
1. API RP2A WSD 2005 Sec 7.4