Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Fastener load transfer 2
- Thread starter Nidhi143
- Start date
- Thread starter
- #3
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
Quando Omni Flunkus Moritati
ESPcomposites
Aerospace
You can download this file and look at the "eDistribution" module.
Brian
- Thread starter
- #6
Brian,
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 .
Regards,
Nidhish
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 .
Regards,
Nidhish
- Thread starter
- #7
-
1
- #8
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
Quando Omni Flunkus Moritati
-
1
- #9
ESPcomposites
Aerospace
Nidhish,
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.
Brian
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.
Brian
- Thread starter
- #10
- Status
Similar threads
- Locked
- Question