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:

Macaulay.zip

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

### Like this:

Like Loading...

*Related*

Wish you and your family a very Happy New Year.

LikeLike

Hey

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.

Regards

LikeLike

See: https://newtonexcelbach.wordpress.com/2012/05/03/using-udfs-continuous-beam-example-3/

LikeLike

Thanks

LikeLike

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

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

LikeLike

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

LikeLike

dougaj4 – thank you so much. this is amazing.

LikeLike

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

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

LikeLike