Author Archives: dougaj4

If Not Now

Posted on 30/09/2023 by dougaj4

“This country is my home. This beautiful country, unique in all the world,” Kelly wrote in his statement on why he’s voting Yes earlier this week. “Our First Australians looked after it and shaped it for over 60,000 years and, in doing … Continue reading →

Posted in Bach | Tagged , , | Leave a comment

Counting words in a list and dictionary links

Posted on 26/09/2023 by dougaj4

This post presents two methods for extracting all the different words from a list and counting the number of occurrences of each word. The spreadsheet, including full open-source VBA code, can be downloaded from: CountWords.zip As an example, I have … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , , , , | Leave a comment

3DFrame-py update

Posted on 03/09/2023 by dougaj4

The Python 3DFrame spreadsheet has been updated to allow for analysis including torsional warping effects. The new spreadsheet and associated Python files can be downloaded from: 3DFrame-py.zip The download file includes four sample spreadsheets comparing analysis results with output from … Continue reading →

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

Python in Excel – two views

Posted on 02/09/2023 by dougaj4

Microsoft recently announced that it is now possible to access Python from within Excel worksheets. This functionality is currently only available to Excel 365 users on the Insiders – Beta channel, who can access it at no cost. When it … Continue reading →

Posted in Excel, Link to Python, Python Pandas, PyXLL | Tagged , , , , | 2 Comments

Mastan2

Posted on 26/08/2023 by dougaj4

Mastan2 is a free frame analysis program based on Matlab. The linked site provides alternative downloads for those with or without Matlab installed. The site also provides a link to the book Matrix Structural Analysis, 2nd Edition, by McGuire, Gallagher, … Continue reading →

Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, Strand7 | Tagged , , , , , , , | 1 Comment