Tag Archives: ConBeamU

ConBeamU update

Posted on 20/09/2025 by dougaj4

Following a comment at https://newtonexcelbach.com/2023/01/20/using-conbeamu/ I have updated the ConBeamU-Template file so that the function to select the input range works the same as in the main spreadsheet. For more details of how the spreadsheet works, see the link above, … Continue reading →

Posted in Beam Bending, Excel, Newton, UDFs, VBA | Tagged , , , , , , , | Leave a comment

Continuous beam analysis from first principles

Posted on 22/09/2024 by dougaj4

This post was prompted by an Eng-Tips question: Statically Indeterminant Beam Problem, asking for reactions due to a triangular distributed load on the middle span of a continuous beam with 3 equal simply supported spans. This could be simply solved … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, UDFs, VBA | Tagged , , , | 3 Comments

Using ConbeamU

Posted on 20/01/2023 by dougaj4

This post was prompted by a thread at Eng-Tips: https://www.eng-tips.com/threads/deflection-equations.501339/#post-8860838 The beam analysis functions in the ConbeamU spreadsheet allow for the use of any SI units, or any non-SI units found in the long list included with the spreadsheet. I … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , , , , | 12 Comments

ConbeamU update

Posted on 28/09/2021 by dougaj4

I recently discovered that the continuous beam function from the ConbeamU spreadsheet was giving incorrect results for cantilevers at the left hand end, if the cantilever had more than one segment and no point loads. The corrected version (Rel 4.16) … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , , , , | 4 Comments

Setting up UDF Applications

Posted on 09/09/2017 by dougaj4

Following a recent comment, this post looks at setting up a user defined function (UDF) on a blank worksheet, using the ConBeamU function as an example. To use a UDF, the VBA code for the function must either be included … Continue reading →

Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Newton, UDFs, VBA | Tagged , , , , | 2 Comments