I have updated the Macaulay spreadsheet (described here) to allow the analysis of continuous beams with cantilevers at one or both ends. The updated spreadsheet (including full open-source code) can be downloaded from Macaulay.zip.
My first attempt was to write a Cantilever user defined function (UDF), then apply the end moment and reaction from this function to a continuous beam with simple supports at the beam ends. I ended up with a different approach, but the Cantilever UDF was completed, and is included in the download spreadsheet.
It turned out to be simpler to just amend the code to allow the input of the position of the end supports, with some fairly minor adjustments to the Macaulay analysis code. Input and results for a three span beam with cantilevers both ends are shown in the screenshots below (click on any image for full size view). As before, the results have been compared with an analysis in Strand7, and show near exact agreement. See earlier posts in this series for more details of the background to Macauley’s method, and details of how to use the functions.