Author Archives: dougaj4

The Pentangle in Europe

Two recent You Tube uploads of Pentangle performances in Europe.  The first is from Norwegian TV in 1968, singing the Anne Briggs song The Time has Come: The second from French TV in 1972, with 6 songs, mostly from their Reflection LP:

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

Non-linear frame analysis; moment curvature and self-weight

The Python/Fortran/Excel frame analysis program (previous version here) now has several new features added to the 2D-solver routines: The beam bending behaviour may now be specified with moment-curvature tables, rather than the linear-plastic behaviour required in the previous version. Beam … Continue reading

Posted in Arch structures, Beam Bending, Concrete, Excel, Finite Element Analysis, Fortran, Frame Analysis, Link to dll, Link to Python, NumPy and SciPy, Strand7, VBA | Tagged , , , , , , , , , , , , , | 1 Comment

Fergus Laing (and a rolling stone)

A song by Richard Thompson. Any resemblance to any living person is, I’m sure, entirely coincidental. Fergus Laing is a beast of a man He stitches up and fleeces He wants to manicure the world And sell it off in … Continue reading

Posted in Bach | Tagged , , | Leave a comment

xlwSciPy 1.09 – update for xlwings 0.10 and Scipy 0.18.1

The xlwSciPy spreadsheet (last presented here) has been updated for the latest version of xlwings and Scipy. The new spreadsheet can be downloaded from: xlScipy-xlw.zip including full open source code. The spreadsheet requires Python, including xlwings, Numpy, Scipy and Pandas … Continue reading

Posted in Arrays, Curve fitting, Excel, Link to Python, Maths, NumPy and SciPy, Python Pandas, UDFs, VBA | Tagged , , , , , , , , | 2 Comments

VBA routines for splitting and joining text

As mentioned in the previous post, I have written two short VBA routines to aid the process of splitting a column of text strings into separate columns, using either a space or any other chosen character as the delimiter.  These … Continue reading

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