Tag Archives: Excel

Using Goal Seek on Multiple Cells

Posted on 25/07/2009 by dougaj4

The Excel “goal seek” function is useful and powerful, but the procedure for using it on multiple cells is painfully slow. The spreadsheet GSeek.xls provides a simple macro to allow Goal Seek to be automatically applied to a range of … Continue reading →

Posted in Excel, Maths, VBA | Tagged , , , | 17 Comments

Should undergraduates be taught Fortran? …

Posted on 20/07/2009 by dougaj4

… is an interesting question being discused at the Eng-Tips Forum. I particulary liked this response: “I can think of about 10 things that undergrad engineers should learn instead of Fortran. 1) How to spell 2) How to make an … Continue reading →

Posted in Computing - general | Tagged , , | Leave a comment

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

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