Author Archives: dougaj4

Microsoft Python Resources

In addition to the documentation of their software products, Microsoft now have a huge amount of on-line resources of more general content, including: YouTube: Python for Beginners Probably the largest hurdle when learning any new programming language is simply knowing … Continue reading

Posted in Computing - general, Excel, Link to Python | Tagged , , , | Leave a comment

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 , , , | 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

Posted in Coordinate Geometry, Curve fitting, Excel, Maths, Newton, UDFs, xlwings | Tagged , , , , | Leave a comment

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

Posted in Excel, VBA | Tagged , , , , | 1 Comment

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 , , , , , , , , , | 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 , , , | 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 , , , , , , , , | Leave a comment