Author Archives: dougaj4

ConBeamU 4.05 and ConBeampy 1.02

Posted on 15/07/2015 by dougaj4

The latest update of the two continuous beam spreadsheets can be downloaded from: ConBeamU.zip ConBeampy.zip The main changes are: A problem with point loads applied exactly at a support position has been corrected A function has been added to evaluate … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, UDFs, VBA | Tagged , , , , , | 1 Comment

New and updated links

Posted on 12/07/2015 by dougaj4

I have just updated my Blogroll, with 9 new links, and a couple of updates: Colin Caprani’s site is now back on-line I have updated the link to Jon Peltier’s blog dataprose.org was the source of many of the new links, … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , | Leave a comment

Google, artificial intelligence and the Daily Mail

Posted on 08/07/2015 by dougaj4

The New Scientist tells me that the people at Google Labs are training their bots in natural language processing by feeding them text from the Daily Mail. This raises two puzzling questions: How is it that those behind the Internet’s … Continue reading →

Posted in Bach | Tagged , , , | Leave a comment

Section Properties – Lunes and Groups

Posted on 08/07/2015 by dougaj4

Following a discussion at Eng-Tips and resulting comments I have updated my Section Properties spreadsheet to include calculation of the area and centroid of a “Lune” (the shape of a crescent moon).  I have also added a “Re-draw Shape” button because … Continue reading →

Posted in Drawing, Excel, Maths, Newton, VBA | Tagged , , , , | 2 Comments

Using Linest for non-linear curve fitting, examples, hints and warnings

Posted on 28/06/2015 by dougaj4

Since I wrote Using LINEST for non-linear curve fitting in 2011 it has been by far the most popular post on this blog.  This post (in response to a recent question) provides some more detailed guidance on how to apply the function … Continue reading →

Posted in Curve fitting, Excel | Tagged , , , , , , | 3 Comments