Tag Archives: Excel

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

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

Conbeam – Python version

Posted on 24/06/2015 by dougaj4

I have converted the continuous beam analysis spreadsheet (last presented here) to Python code, linked to Excel VBA User Defined Functions (UDFs) with ExcelPython.  To run the Python version you will need an installed copy of Python, including Numpy and … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, UDFs, VBA | Tagged , , , , , , , | Leave a comment

Dealing with dates 3: opening and saving csv files without data corruption

Posted on 11/06/2015 by dougaj4

This post makes use of a spreadsheet for reading data from text files, including comma separated value (csv) files.  The latest version includes a routine for saving the imported data in csv format.  It can be downloaded (including full open-source … Continue reading →

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