Recent Comments
Author Archives: dougaj4
Paul Kelly and Joni Mitchell
Leading Australian singer-songwriter Paul Kelly is about to release a powerful new single that tackles Australia’s lack of action on climate change and environmental destruction. Entitled Sleep, Australia, Sleep, Kelly says the song is both “a lament in the form … Continue reading
Posted in Bach, Climate
Tagged Big Yellow Taxi, Joni Mitchell, Paul Kelly, Sleep Australia Sleep
Leave a comment
Asymmetric Catenary Function
Back in 2009, I posted a user defined function (UDF) to generate a catenary curve, that could be used together with the Excel Solver to generate a curve of a specified span and sag: A catenary function Following a discussion … Continue reading
Using Excel Solver from VBA
Using the “record macro” icon in Excel to record the solver process, I had a couple of problems: When I tried to run the recorded macro, I got the message “Compile Error – Sub or Function not defined”. When that … Continue reading
Column buckling under multiple loads
Following another buckling discussion at Eng-tips I have modified my Frame4-buckle spreadsheet to allow input of multiple axial loads at any point along the column, along with any number of sections with different section properties. Background on the method used … Continue reading
Posted in AlgLib, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA
Tagged AlgLib, column buckling, Euler buckling, Excel, Frame Analysis, multiple load buckling, stepped column, tapered column, VBA, Vianello
Leave a comment
Trinity Bridge and Bridge of the Month
Bill Harvey has been doing a monthly report on historical bridges for many years, but recent issues have the added interest of interactive 3D models of the selected bridges. The Trinity Bridge at Crowland in South Lincolnshire is an excellent … Continue reading
Posted in Arch structures, Historic Bridges, Newton
Tagged 3D Model, Bill Harvey, stone arch bridge, Trinity Bridge
1 Comment
Newton Excel Bach, not (just) an Excel Blog 