Fastened Joint Calculations in Excel

Solving for the strength (max force) of fastened (bolted) joints using Microsoft Excel! Even better, using Excel solver utility to help! This is one of my best Engineering Tutorials yet!

First, what is stress? What types of stress are there? And what types of stress can cause fasted joints to fail? Sheet stress, tensile stress, and compression (bearing) stress. If the stress in the joint exceeds the ultimate strength of any of these, the joint will fail.

This Excel spreadsheet will solve find the strength (maximum force) of multiple joint configurations including single shear (single lap joint), double shear (double lap joint), multiple fasteners, etc.

I also throw in some other cool tips like Excel's convert function to help us convert units in cases when we are working in multiple units.

Excels solver utility is so cool! It helps us solve for the optimal joint configuration to maximize strength given some parameters.

Welcome to The Engineer Toolbox Channel, where I give you the tools you need to solve real world engineering problems.

Channel Link:    / theengineeringtoolboxchannel  

Check out my Channel for more videos and tutorials for engineers!

Like, share, comment and follow for more weekly engineering tutorials. Also, don't be afraid to drop me a comment/message with feedback, questions, or video suggestions!

Credit for fastened join clips:
   • Bolted Connection - Bolt Shear  
   • Bolt Shear  

Thanks for watching!

#EngineeringToolbox
#EngineeringTutorials
#ExcelForEngineers
#Engineer
#MechanicalEngineer
#Stress