Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Fastener load transfer

Fastener load transfer

Fastener load transfer

Dear Engineers,?
how to calculate fastener load transfer on a plate and how to analyse in excel worksheet.

RE: Fastener load transfer

build a compliance model, using Niu (pp230, Airframe Structural Design) ... it's easy to do in excel.

Quando Omni Flunkus Moritati

RE: Fastener load transfer

can u explain how load distribution taken place on fasteners on lap joint ? Is there any link that can do it in a excel ???

RE: Fastener load transfer

compliance model means defining the different deflections that sum to the same. it accounts for the different load in the skin and dblr and the shear deflections of the fasteners. you end up with a bunch of simultaneous equations, easy to solve in excel. Niu's book has a good explanation.

Quando Omni Flunkus Moritati

RE: Fastener load transfer

Thanks ... for the file. really its awesome macro in excel . Waiting for the book to be release as soon... but 1 problem occurs in that macro .
when i clicked on e-distribution show link , its coming up an error indicates that "error in dll" even though i enabled macros . please make sure of that. Really like to buy that pro version .


RE: Fastener load transfer

can any1 suggests how to do load distribution among fasteners in lap joints? Please really its urgent to do a mini project.

RE: Fastener load transfer

there are many references for this ... Niu (I've given you the page number), Bruhn, Swift. The basic problem is easy to solve, equating deflections along different paths in the joint; just long and tedious to write down. google compliance models

Quando Omni Flunkus Moritati

RE: Fastener load transfer


Sorry that it is giving you trouble. It is usually not problematic, but about 10-20% of users have issues. This seems to due to various versions of Excel, non US Language version, and other things difficult to control on the user end.

In the future, I plan on stripping out some of the more complex VBA code to make things go smoother. That will limit functionality on some modules, but increase compatibility.

Rb1957 gave some good thoughts on how to solve this problem manually. You will just have set up a NxN matrix and solve for the matrix. You will also need to determine "fastener flexibility" values. They are a function of plate thickness and choice of method (they vary greatly). Excel can invert a matrix as well.


RE: Fastener load transfer


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close