Recent Comments
Author Archives: dougaj4
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
Python Traps
When converting existing VBA code to Python there are a number of obvious changes to the syntax that need to be made for the code to run at all, but there are also a number of not so obvious traps … Continue reading
Posted in Arrays, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs, VBA
Tagged Excel, for loop counters |, Numpy, Passing variables, Python, python traps, PyXLL, UDF, VBA
1 Comment
Newton Excel Bach, not (just) an Excel Blog 