Category Archives: Excel

Continuous beam animations with VBA and Python

Posted on 20/12/2025 by dougaj4

Following a lengthy discussion at Eng-Tips I have developed several functions to generate animations of the effects of applied moving loads. The Python code and examples have been added to the py_ConBeamU.zip file which can be downloaded from: py_ConBeamU.zip Starting … Continue reading →

Posted in Animation, Beam Bending, Charts, Excel, Frame Analysis, Link to Python, Newton, PyXLL, UDFs, VBA | Tagged , , , , , , , , , , | 1 Comment

py_ConBeamU and Strand7 check updates

Posted on 11/12/2025 by dougaj4

Following the previous post, I have updated the py_ConBeamU spreadsheet, and the associated check against Strand7 results. The new files can be downloaded from: py_ConBeamU.zip The download file now includes: For more details of the spreadsheet and included functions see … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Link to Python, Newton, PyXLL, UDFs | Tagged , , , , , , , | 1 Comment

ConBeamU and Strand7 check update

Posted on 05/12/2025 by dougaj4

Results of the continuous beam spreadsheet were last checked against Strand7 results 10 years ago. I have now updated this check with the latest version (4.19), which can be downloaded from: ConBeamU.zip The download file now includes: The Strand7 check … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , , , , , | 1 Comment

More on TrimRange and the Drop Function

Posted on 20/11/2025 by dougaj4

A comment on my previous post links to a helpful YouTube video on using TrimRange and the Dot operator: It also looks at using the Drop Function to exclude a specified number of rows and/or columns from the top or … Continue reading →

Posted in Arrays, Excel | Tagged , , , , | Leave a comment

The TrimRange Function

Posted on 05/11/2025 by dougaj4

I have just discovered the TRIMRANGE function, and its very useful shortcut version, which were introduced to Excel 365 about a year ago. The function excludes all empty rows and/or columns from the outer edges of a range or array, … Continue reading →

Posted in Arrays, Excel | Tagged , , , | 2 Comments