Category Archives: Excel

Two new functions for IP.xls

Posted on 18/07/2009 by dougaj4

Edit 8 Feb 2012: The functions described below have been superseded by new versions which are described at https://newtonexcelbach.wordpress.com/2009/08/18/finding-circle-centres-in-3d/.  That link also gives a description (with diagrams!) of how the functions work.  The download file for the new versions is … Continue reading →

Posted in Excel, Maths, UDFs, VBA | Tagged , , , , , , | 8 Comments

Microsoft Office 2010 Engineering Blog

Posted on 17/07/2009 by dougaj4

It seems that Microsoft are ramping up their efforts to get us really really excited about the impending release of the next version of Office. Read all about it here For me, the main thing I’d like to see in the … Continue reading →

Posted in Computing - general, Excel | Tagged , | 1 Comment

More on cubic splines

Posted on 12/07/2009 by dougaj4

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 , , , , | 10 Comments

Continuous beam analysis with cubic splines

Posted on 05/07/2009 by dougaj4

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 , , , , , , , | 9 Comments

Cubic Splines

Posted on 02/07/2009 by dougaj4

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 , , , , | 73 Comments