Has anyone developed some o the typical aeronautical analysis calculations in XLC? Typical things include Lug Analysis (Melcon & Hoblit/Bruh/Niu methods), pin bending, interference fits, Mohr's Circle, Columns, etc.... I see a possible fit within my team and would like to find out more.

Randy

Randy there are a couple of calculations that you will find interesting:

Clevis-and-lug-design-V0001.xls - Calculation of stress concentration effects at a pin and clevis joint. It is not the Melcon & Hoblit/Bruh/Niu method and does not cover pin bending but it uses the method outlined in Peterson's "Stress Concentration Factors"

also

Biaxial Stress Assessment.xls - Combination of stresses in a biaxial stress system. Calculation of principle stresses, maximum shear stress and stress intensity. Plot Mohr's circle on chart. Mohr's Circle is used to visualize relationships between normal and shear stresses. Assess against various failure criteria.

I used the Melcon & Hoblit method years ago but I am afraid I have loast the papers covering the method. I would be keen to see it encoded in a spreadsheet.

I have some spreadsheet lug methods based on Bruhn and are laid out in a final report format - I will see if I can dig them out and post them up tonight.

Richard I would be very interested in this calculation - your are in danger of earning two subscriptions (maybe you could give one to amuse your Dad in his retirement).

Here is the lug analysis - I am not familiar with the formal process of submitting sheets so I have attached to this post for your delectation. (actually I tried to formally submit this morning and it would not let me as I didn't have the right kind of membership - is this correct or a site glitch?)

I have about 30-40 spreadsheets of this type covering all the 'useful' parts of Bruhn, UF Air force Stress Manual, Mil-Hndbk part 23 composite stuff, etc etc - they are all in 'Abbott Aerospace' report format and what has mostly been stopping me posting them is the time it takes to strip out my company headers and that sort of information....

Anyway - I stripped this one down as there was a special need. If you don't mind my shameless self promotion I can post up many more.....

Apologies that it is not in the preferred format - it is just a matter of time that I do not have right now to convert it - also as it is a lengthy analysis sheet it may not work in the format the you prefer.

I shall post up the composite one shortly......

All the best - if you find any problem with the sheet be sure to let me know.
-----------------------
The moderator software stripped the attachment as it was too large (about 1800K......

Is there a way around this?

No problem with the shameless self promotion I often include links to the authors website. Please send me a short description about Abbott Aerospace and a logo if you have one and I weave it into all your repository contributions. We get a large amount of traffic so I hope it brings a lot of custom to you.
We always take the attitude that something is better than nothing and I understand your comments about the work involved. So please upload the document as it stands.
Regarding uploading I have increased the forum file size limit from a meagre 1.2Mb limit to 20Mb but the best way to upload directly into the repository is to use the 'Upload a Calculation' link on the site User Menu.
Thanks for your support.