Aluminum Material Data, Free Spreadsheet – Full range Curves and Plastic Buckling

May 10, 2016

One of the basic building blocks of any stress analysis is material data. It is one of the 3 basic parameters of material, geometry and loads that are required for a stress analysis. I wrote the first version of the spreadsheet 15 years ago and it has been updated and improved over time. It automatically calculates the following from built in aluminum material data that can be accessed from a drop-down box.

AA-SM-000-001 Aluminum Material Data Basic Full Curves and Data

  • Shear Yield stress
  • Shape factor for Shear
  • Intercept stress for Cozzone plastic bending allowable
  • Plastic bending allowable stresses for rectangular and circular sections
  • Full range stress-strain curves for longitudinal and longitudinal-transverse direction
  • Plastic Correction for Shear Buckling
  • Plastic Correction for Plate Compression Buckling
  • Plastic Correction for Flange Compression Buckling
  • Plastic Correction for Inter-rivet and Column Buckling

It can be down loaded here


AA SEZC Banner #6

To try our free Stress Analysis Engineering Spreadsheets click below


To try our Add-in for Microsoft Excel for Windows click below

XL-Viking 2

Have A Comment On This Article? Post It Here.

Comments are moderated and will not be published until approved. Your email address will be kept confidential. Please review our Comment Policy before posting your comment.


Microsoft Excel Spreadsheets

FREE ANALYSIS SPREADSHEETS 3 Over the last 10 years we have developed hundreds of spreadsheet tools to help us with our structural analysis work. We have made these available through the Abbott Aerospace web site and the XL Viking project. We have now brought them into the technical library. They have been updated, improved and the collection has been expanded to cover more analysis methods than ever before.

The XL-Viking Add-In for Excel

XL-Viking 2 We created the XL-Viking Excel add-in to satisfy our own need to make Excel a better engineering tool. XL-Viking shows your Excel Formula in a way that makes sense and brings essential new functionality to Microsoft Excel by providing an additional user interface and easy to use functions.

The Indispensable Tool For Engineers, Mathematicians, Scientists, Accountants and Teaching Professionals!


Technical Papers & Reports

This is our collection of public domain references. All of the material we make available has been placed in the public domain by the authors/owners. If you believe this is not the case and any of the library material is not in the public domain please let us know. If you have any reference material that you would like to see included in the library we would love to hear from you.

Market Analysis and Market Information

Our newest addition to the library is an on-going series of articles on the aircraft and aerospace market. These are part quantitative and part qualitative and introduce a new aspect to the competencies within Abbott Aerospace.