Author Archives: dougaj4

ConBeamU 4.13

The continuous beam analysis spreadsheet, ConBeamU, is now up to version 4.13 with some minor bug-fixes, and the addition of a non-linear option for the BeamAct functions. See ConBeamU for more details of the functions available in the spreadsheet. Download … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , , | 7 Comments

February Links

Two new links with valuable free resources: .net and office automation follies : including many advanced VBA resources.  Thanks to Alfred Vachris for the link. AET VBE Tools : Tools for the Visual Basic editor from Andrew Engwirda (via Daily Dose of … Continue reading →

Posted in Excel, Link to dll, VBA | Tagged , , , | Leave a comment

ACO, Pekka Kuusisto, Sam Amidon, Pentangle and Wedding Dress

Murder and Redemption, the current ACO concert series, led by guest musical director Pekka Kuusisto and folk musician Sam Amidon, combines American and British folk songs with the works of Janáček and John Adams. Here Pekka Kuusisto talks of performing the … Continue reading →

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

Christy Moore sings Beeswing

Back in 2011 I posted a link to Richard Thompson’s song Beeswing, sung by The Little Unsaid.   That post still brings a trickle of visitors to his site, which led me to this version by Christy Moore: and Christy Moore’s … Continue reading →

Posted in Bach | Tagged , , | Leave a comment

Weighted Least Squares Regression, using Excel, VBA, Alglib and Python

Least squares linear regression in Excel is easy.  That’s what the Linest and Trend functions do.  That is, they find the coefficients of a straight line (or higher dimension shape) so that the sum of the squares of the distances of … Continue reading →

Posted in AlgLib, Curve fitting, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , | 9 Comments