Recent Comments
Tag Archives: UDF
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
Adding Function Categories and Descriptions
User defined functions (UDF’s) are by default added to the “User Defined” category in the function list, and when a UDF is selected the words “no help available” appear, rather than a description of the function and it’s parameters. A rather … Continue reading
Some string functions
It was pointed out in a comment to this post at Daily Dose of Excel that VBA has a StrReverse function that will (logically enough) reverse a string. That’s not awfully useful to me (except maybe for Project Euler), but it … Continue reading
Newton Excel Bach, not (just) an Excel Blog 