All Simple Beam Analysis Spreadsheets Uploaded!

As we work towards the second edition of our textbook we are completing and uploading the accompanying spreadsheets. We have finally completed the simple beam analysis section of the book and the 33 spreadsheets that will accompany that chapter in the book are now written and uploaded (We will leave multi-span beams and curved beams to the third edition).

These spreadsheets all plot the shear force, bending moment and deflection. All the spreadsheets use the XL-Viking add-in to display the math but the answers are correct with or without the add-in.

Cantilever – Point Load at End

Cantilever – Point Load Mid-Span

Cantilever – Distributed Load Whole Span

Cantilever – Distributed Load Part Span

Cantilever – Triangular load Whole Span, Peak at Support

Cantilever – Triangular load Part Span Peak at Support

Cantilever – Triangular load Whole Span Peak at Free End

Cantilever – Triangular load Part Span Peak at Free End

Cantilever – Moment at Free End

Cantilever – Moment Anywhere

Simply Supported Both Ends – Point Load Mid Span

Simply Supported Both Ends – Point Load Anywhere

Simply Supported Both Ends – UDL along Entire Length

Simply Supported Both Ends – UDL Part Span

Simply Supported Both Ends – Triangle Load Whole Span

Simply Supported Both Ends – Triangle Load Peak at Center

Simply Supported Both Ends – Triangle Load Zero at Center

Simply Supported Both Ends – Moment at End

Simply Supported Both Ends – Moment Anywhere

Simply Supported With Overhang – Load at free end

Fixed and Simply Supported Ends Point Load Anywhere

Fixed and Simply Supported Ends UDL Along Entire Length

Fixed and Simply Supported Ends UDL Part Span

Fixed and Simply Supported Ends Triangle Load Whole Span – Peak at Fixed Beam

Fixed and Simply Supported Ends Moment Anywhere

Fixed and Simply Supported Ends Triangle Load Whole Span – Peak at SS Beam

Fixed and Simply Supported Ends Moment at SS

Fixed Both Ends – Point Load Mid Span

Fixed Both Ends – Point Load Anywhere

Fixed Both Ends – UDL along Entire Length

Fixed Both Ends – UDL Part Span

Fixed Both Ends – Triangle Load Whole Span

Fixed Both Ends – Moment Anywhere

Technical Library FAQs

Who are you? We are the engineers from Abbott Aerospace UK Ltd.

Why do You do this for free? A lot of the library material does not originate with us so, with good conscience, we cannot charge for that part of the library. There are issues with commercializing the material that we create, copy protection, customer support and pricing at the right level. By making everything available free of charge it lets us concentrate on content.

How is the library funded? The library is funded using revenue from the engineering service side of Abbott Aerospace UK Ltd., and by the donations of the people who find the library useful.

What should I do if I think I see a copyright violation in any of the library materials? Please contact us immediately and give us specific information about your concern

What should I do if I think I find an error in any of the library materials? Please let us know immediately

I would like to help the library by volunteering my time. How do I do that? At the present time we are unable to accept any offers of help. In the future we would like to work with a group of volunteer engineers. At this time we have not developed the digital infrastructure to make this possible. You can help by making a donation of any size.

I would like to help by donating materials I have collected or created. How do I do that? Let us know what you have and if it meets our criteria we will gladly accept it and give you a name credit if you choose.

What is the acceptance criteria for the library? For any material to be added to the library it must me the following criteria

It must not already be in the library
Where the material is not authored by the contributor it must be the demonstrated to be in the public domain or where the material is created by the contributor it must reference an available public domain source.
It must be either a Adobe PDF document, a Microsoft Excel spreadsheet or a Microsoft Excel add-in file. Other types of files can be considered.

Aerospace News Abbott Aerospace UK Ltd

Aerospace News