Author Archives: dougaj4

Longitudinal force due to shear – update

Posted on 09/10/2023 by dougaj4

In the post RC Design Functions 9.03; compression strut angle adjustment I recommended that when finding the longitudinal force due to shear according to AS 5100.5 (Amendment 1), the effect of increased vertical shear reinforcement should be limited in accordance … Continue reading →

Posted in Concrete, Excel, Link to Python, Newton, PyXLL, UDFs, VBA | Tagged , , , , , , , , | 1 Comment

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