Continuous Beams with Shear Deflections

The Macaulay Spreadsheet has now been modified to optionally include shear deflections, as well as a new option to output support reactions, and fixes to minor bugs.

The revised spreadsheet (including full open source code) can be downloaded from:

The screenshots below show an example (included in the download file) of a three span beam with spring supports and shear deflections included, compared with output from the Strand7 FEA program.  It can be seen that there is near exact agreement for both beam actions and deflections.

Conbeam function input, including shear stiffness

Part of Conbeam function output, compared with Strand7 (click for full size view)

Graphical output comparing ConBeam and Strand7 results

This entry was posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA and tagged , , , , , , . Bookmark the permalink.

10 Responses to Continuous Beams with Shear Deflections

  1. Viet says:

    Wish you and your family a very Happy New Year.


  2. Ankit says:

    I have been following your work for quite a while now. Really appreciate your effort.
    Unfortunately I am completely new to excel and hence the UDF’s.
    I request for a tutorial on how to use this one.



  3. Pingback: Using UDFs – Continuous Beam Example | Newton Excel Bach, not (just) an Excel Blog

  4. tibia says:

    So is it tricky to add shear deflections to the cantilever analysis?


  5. dougaj4 says:

    tibia – not too tricky – it should appear in a day or two.


  6. Pingback: Cantilevers with shear deflections | Newton Excel Bach, not (just) an Excel Blog

  7. kimberly says:

    amazing! I’ve been searching for this, Thank you so much God Bless 🙂


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.