Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- Continuous Beams With Spring Supports by Macaulay’s Method
- ULS Design Functions 2.13
- About Newton Excel Bach
- Intersections, interpolations, and rotations
- Buckling of columns with varying cross section
- Fitting high order polynomials
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
Recent Comments
Tag Archives: continuous beam analysis
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
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
ConBeamU Update
Recently a comment pointed out that if the ConBeam, or ConBeamU, user defined functions were used with a single span then the “Out” argument was ignored, so it was not possible to return support reactions. This has now been fixed … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged continuous beam analysis, Excel, UDF, VBA
18 Comments
Unit aware continuous beam spreadsheet update
The ConbeamU spreadsheet provides Excel user defined functions (UDFs) for the analysis of continuous and simply supported beams and cantilevers using Macaulay’s method. It allows complex combinations of any number of partial distributed loads, point loads and moments, with changes … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged continuous beam analysis, Excel, Macaulay's Method, moment restraint, spring supports, UDF, unit aware, VBA
1 Comment