Category Archives: Excel

Update to Frame4.xls

Posted on 19/07/2009 by dougaj4

It was recently pointed out to me that the non-uniform load calculation in Frame4.xls gave incorrect results. The code for the non-uniform load has now been fixed, and the spreadsheet can be downloaded from Frame4.zip

Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA | Tagged , , | 1 Comment

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