Author Archives: dougaj4

Copy and Paste as Picture

Posted on 18/10/2009 by dougaj4

If in Excel 2007 you copy a range to the clipboard and paste into Word as a picture you get the worksheet gridlines displayed, which may well not be what you want. This issue was raised at Smurf on Spreadsheets and … Continue reading →

Posted in Excel | Tagged , , | 10 Comments

Bend-it Like Euler

Posted on 10/10/2009 by dougaj4

I just found the Bend-it blog, which looks like it should be worth a good look: Note 13 Oct 09:  See comment below.  This blog is temporarily closed whilst being reorganised, but contact the authors if interested.

Posted in Newton | Tagged | 3 Comments

Three UDFs

Posted on 05/10/2009 by dougaj4

This post is in response to recent discussions at Daily-Dose-of-Excel where many and various worksheet formulas have been suggested to carry out tasks that are (it seems to me) better done with a simple User Defined Function (UDF): Adding Every … Continue reading →

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

Update to Publications

Posted on 02/10/2009 by dougaj4

I have (at long last) updated my list of publications (all downloadable). Click on the link below to visit the site, or download direct from the list here. My Publications Here is the current list:     Predicting the Deflection … Continue reading →

Posted in Arch structures, Concrete, Geotechnical Engineering, Newton | Tagged , , , , | Leave a comment

Geometric Tools

Posted on 30/09/2009 by dougaj4

I was recently sent a link to: Geometric Tools Documentation Which has a host of pdf files with detailed instructions on all manner of geometric calculations.  The focus of the site is animation for games programs, but there is plenty … Continue reading →

Posted in Coordinate Geometry, Maths, Newton | Tagged , | Leave a comment