Recent Comments
Tag Archives: Excel
Beam on Elastic Foundations Analysis
A previous post on laterally loaded piles used a finite difference analysis to analyse the deflections and forces in a vertical pile subject to a lateral load at the top. An alternative approach to the same problem is presented in “Programming the Finite … Continue reading
Posted in Excel, Finite Element Analysis, Geotechnical Engineering, Newton, UDFs, VBA
Tagged Beam on elastic foundations, Excel, laterally loaded piles, UDF, VBA
6 Comments
AlgLib Spline function update
Following a question at the AlgLib Forum I have added the Hermite spline fit function to the AL-Spline-Matrix collection. The revised spreadsheet, with full open source code is available for download in 2007/20010 version and pre-2007 version. Typical output of the … Continue reading
More on buckling columns
Coincidentally, at about the same time as I wrote about column buckling for a column with a point load on the end, Autar Kaw at The Numerical Methods Guy was writing about buckling of columns under self weight, using the theory of … Continue reading
Posted in AlgLib, Beam Bending, Excel, Maths, Newton, UDFs, VBA
Tagged AlgLib, column buckling, Excel, Runge-Kutta, Timoshenko, UDF, VBA
1 Comment
Keyboard shortcuts
Having been born and raised using a different spreadsheet I’m sometimes a bit set in my ways and don’t use keyboard shortcuts as much as I could. The trouble is there are so many of them. I’ve just discovered a list … Continue reading
SplineBeam update
Previous SplineBeam post I have modified the SplineBeam spreadsheet to allow input of a single span (simply supported or with end constraints), and to optionally allow input of the position of intermediate nodes, rather than dividing each span into equal segment lengths. This … Continue reading
Posted in Arrays, Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged continuous beam, Cubic spline, Excel, UDF, VBA
1 Comment
