Author Archives: dougaj4

Using Excel Solver from VBA

Posted on January 28, 2020

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

Posted on January 20, 2020

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

Posted on January 9, 2020

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

Posted on January 1, 2020

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

Excel Dynamic Arrays

Posted on December 8, 2019

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

Clive James and Pete Atkin

Posted on November 30, 2019

Following The Barrow Poets, more poetic music from the early 70’s: Clive James finally succumbed to a long illness this week.  He was mainly known for his humorous work on TV and in writing, but he was also a prolific … Continue reading →

Posted in Bach | Tagged , , | Leave a comment

Biaxial bending update

Posted on November 21, 2019

The reinforced concrete biaxial bending spreadsheet has now been updated: Stress block and capacity reduction factors updated for AS 3600-2018 ACI factors for US customary units used when stress is entered in ksi or psi units Example data updated The … Continue reading →

Posted in Beam Bending, Concrete, Newton | Tagged , , , , , , , , | 10 Comments