Recent Comments
Tag Archives: VBA
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
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
Excel Dynamic Arrays
Previews of dynamic arrays in Excel have been available for some time through the “Insider” programme. They are now being published to general subscribers through Office 365 monthly updates: Further information is given at: Easier array formulas and Dynamic array … Continue reading
Posted in Arrays, Excel, UDFs
Tagged array functions, CSE array functions, dynamic arrays, Excel, UDFs, VBA
Leave a comment
Newton Excel Bach, not (just) an Excel Blog 