Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- About Newton Excel Bach
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Solving non-linear equations with two or more unknowns – 3
- XLDennis, the MSDN Library, and VBA rant
- Taming Symbols in Excel
- Downloads
- Beam actions and deflections by Macaulay's Method
- Filling Blanks with Go To-Special (and local help rant)
Recent Comments
Category Archives: Newton
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
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
Using the AlgLib ODE (Runge-Kutta) Solver with Excel
Or to be more correct, the AlgLib Cash-Karp Solver, Cash-Karp being a refinement of the Runge-Kutta method of solving ordinary differential equations. Solution of differential equations is an iterative process requiring the repeated application of the solver routine followed by evaluation of … Continue reading
Posted in AlgLib, Beam Bending, Differential Equations, Excel, Maths, Newton, UDFs, VBA
Tagged AlgLib, buckling, Cash-Karp, differential equations, Excel. VBA, hole through the middle of the earth, Runge-Kutta, SHM, UDF
8 Comments
Elegant solutions, Simple Harmonic Motion, and the hole through the middle of the Earth
No, not the hole (beloved of conspiracy theorists everywhere) where our alien overlords keep their UFO’s, but rather the equally imaginary hole from Pole to Pole (beloved of physics teachers everywhere) where we can drop in objects and watch them travel … Continue reading