Author Archives: dougaj4

Changing Environment Variables

Posted on 21/07/2009 by dougaj4

I’m occasionally using a beta program that requires me to change the search path.  The procedure for doing this in Vista seems to be something that Microsoft do not wish to talk about, and I have to search the web … Continue reading →

Posted in Computing - general | Tagged , | 2 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

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