Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Downloads
- Daily Download 4: Continuous Beam Analysis
- Finding Prime Numbers with Excel, and using Array Formulas
- Linking Excel to C - 2
Recent Comments
Tag Archives: ConBeamU
Conbeam – Python version
I have converted the continuous beam analysis spreadsheet (last presented here) to Python code, linked to Excel VBA User Defined Functions (UDFs) with ExcelPython. To run the Python version you will need an installed copy of Python, including Numpy and … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, UDFs, VBA
Tagged Conbeampy, ConBeamU, continuous beam analysis, Excel, ExcelPython, Python, UDF, VBA
Leave a comment
ConbeamU Update Update
Following some comments from 4Step on the last ConbeamU update, and a thorough check of results against Strand7 results, I have posted a new version that fixes a number of issues with the previous one. The new version number is … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged ConBeamU, continuous beam analysis, Excel, Strand7, UDF, VBA
4 Comments
ConbeamU Update; defined support deflections
As promised in a recent post, I have updated the ConBeamU spreadsheet to allow defined deflections to be specified at any support. The new spreadsheet (including full open-source code), can be downloaded from ConBeamU.zip In addition to the support deflections the … Continue reading
Posted in Arrays, Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged array entry, Array function entry, ConBeamU, continuous beam, defined support deflections, deflections, Excel, Macaulay's Method, UDF, VBA
12 Comments
Continuous Beams with Specified Deflections
A few weeks ago there was some discussion in a previous continuous beam post about how to analyse a continuous beam with specified deflections at the supports. In this post I will look at three different ways of doing this … Continue reading
Posted in Excel
Tagged ConBeamU, continuous beam analysis, Excel, specified displacements, UDF, VBA
1 Comment
Beams may kiss, but do not hug …
… not full length anyway. This post was inspired by a now very long discussion at Eng-Tips on the apparently simple question of what happens when you place one short beam on top of a longer one, and apply a … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA
Tagged ConBeamU, Excel, Simply supported beams, Solver, stacked beams, Strand7, UDF, VBA
Leave a comment