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
- Cubic Splines
- Downloads
- Writing Arrays to the worksheet - VBA function
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Automatic download of csv files
- Linking Excel to C
Recent Comments
Author Archives: dougaj4
Microsoft Present Lectures on Gravity …
… which seems fairly appropriate material for a blog called Newton Excel Bach. Link here Feynman Lectures on Physics Warning – requires Silverlight Here’s a screen shot:
More on cubic splines
Link to Cubic Spline Update The previous two posts used cubic splines with the “natural” end condition, that is with an end curvature of zero. To apply the cubic spline to analysis of continuous beams with different end conditions we … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Maths, Newton, UDFs, VBA
Tagged continuous beam analysis, Cubic spline, Excel, UDF, VBA
10 Comments
Continuous beam analysis with cubic splines
The last example in the previous post illustrated the use of cubic splines to find the bending moments in a continuous beam subject to prescribed lateral displacements. A similar technique can be used to find bending moments, shear forces, reactions, … Continue reading
Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Maths, Newton, UDFs, VBA
Tagged bending moments, continuous beam analysis, Cubic spline, deflections, Excel, shear forces, UDF, VBA
9 Comments
Cubic Splines
Cubic splines are used to fit a smooth curve to a series of points with a piecewise series of cubic polynomial curves. In addition to their use in interpolation, they are of particular interest to engineers because the spline is … Continue reading
Posted in Beam Bending, Excel, Newton, UDFs, VBA
Tagged continuous beam, Cubic spline, Excel, UDF, VBA
73 Comments
Long Hair in Newquay
Talking of 1960’s UK folkies, I think this is hilarious. Wizz Jones stars in the battle of the long-haired beatnicks v Newquay Town Council:
Posted in Bach
Leave a comment