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
Newton Excel Bach, not (just) an Excel Blog 
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