Tag Archives: Excel

SectionProperties Release 3

Posted on 21/10/2023 by dougaj4

Robbie van Leeuwen’s SectionProperties program, (last featured here) has recently been updated to Release 3 with some major changes to the code, including: Full documentation can be found at: SectionProperties docs Changes to the code have required updates to my Excel … Continue reading →

Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Link to Python, Newton, PyXLL, UDFs | Tagged , , , | Leave a comment

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

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