Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Downloads
- Cubic Splines
- Writing Arrays to the worksheet - VBA function
- XLDennis, the MSDN Library, and VBA rant
- Linking Excel to C
- Automatic download of csv files
- Filling Blanks with Go To-Special (and local help rant)
Recent Comments
Author Archives: dougaj4
The hole through the middle of the Earth – acceleration
In my first go at modelling a ball falling through a hole through the middle of the Earth I assumed constant density, and hence the acceleration at any point was proportional to the distance from the centre. That is of course … 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
Elegant solutions, Column buckling, and the hole through the middle of the Earth
The previous post presented some examples of solution of differential equations using an iterative process, including the simple harmonic motion problem of a ball falling through an evacuated hole through the middle of the Earth. The final example was concerned … Continue reading
Posted in Beam Bending, Differential Equations, Newton
Tagged column deflections, differential equations, Euler buckling
5 Comments