The problem with VLOOKUP and HLOOKUP is that they do not check if the x and y value exist in your table. The only way to find the matching pair and the value is using INDEX(array,row_num,colum_num) in conjunction with match(lookup-_value,lookup_array,match_type).
match_type values are: -1, 0, or...
One of the basic references for the subject matter is:
Rings used for shear web hole reinforcement by K. M. KING (King's paper called very often). AERO DIGEST - August 1955 - page 24 through 29. This paper was used as basis by Niu and US aircraft companies.
Another ref. is Stress Analysis...
Found reference to the AS4100 rule 5.10.7 (hole size dimensions in beam webs) in an engineering lecture. I have no access to AS4100, therefore I am looking for detailed information about rule 5.10.7. Thanks Gunther
Hi CDR
I am not aware of any fatigue allowable for dimpled fastener installations. I would not approve as a DER this method of joints in primary aircraft structure, subject to fatigue loads, at all. I know only of dimpling of very thin sheets where countersunking is impossible and the second...
Hi K. Choi,
there is no simple answer to your question.
First you have to determine the type of fasterner in the joint and the type of loading on your joint. Is it a bolt, a HILOK, a lokbolt, a rivet or even a srew (only used in non flight critical structure with no threads in bearing !). Is...
Are you looking for historical references ? If so, here are some papers:
Most published charts are based on the idea of R.A. Needham:
The ultimate strength of aluminum-alloy formed structural shapes in compression -
R.A. Needham - Journal of the Aeronautical Sciences - Vol 21 - April 1954 -...
Hi bredford:
the answer to your question is not that simple. Without knowing more detail of the connection, an answer is not possible. What is the loading of the joint ? Is it tension or shear or both ? Is it fatigue critical ? You find simple equations in text books but the detail analysis of...
wktaylor:
Only FAA approved fastener allowables can be used in certification of US A/C.
All material and fastener test data must be referred to FAA for approval as specified in FAA Order 8110.49 (DER Handbook) but FAA may issue authorization letter to find compliance !
Therefore it is important...
A further short remark:
All joint allowables used in the analysis of aircraft structure in the USA have to be FAA approved data. The only official publicly published data are in Mil-HDBK-5. Allowable data used within the various aircraft companies have to be of the same or lower value and be...
HI Yakov,
found this web site when I searched for +bolts +eccentric +connection.
I have used the same method of finding the ultimate joint capability using LOTUS 123 many years ago.
The input to the program was more complicated. Not only did we had to use various fastener sizes, also the...
