Recent Comments
Author Archives: dougaj4
Counting words in a list and dictionary links
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 Count words, Countif function, Excel, Extract unique words, scripting dictionaries, UDF, Unique function, VBA
Leave a comment
3DFrame-py update
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 3DFrame-py, Excel, Frame Analysis, global axes, local axes, MASTAN2, principal axes, Torsional warping
1 Comment
Python in Excel – two views
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 Excel, link Excel to Python, Python, Python in Excel, PyXLL
2 Comments
Mastan2
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 3DFrame, Excel, Frame Analysis, global axes, local axes, MASTAN2, principal axes, Torsional warping
1 Comment
Concrete 2023
The Concrete Institute of Australia’s biennial conference is almost upon us. This year it is being held in Sydney from 10-13 September. CONCRETE 2023 Look below at what’s in store at Concrete 2023. Keynote and Invited Speakers We have … Continue reading
Posted in Concrete, Newton
Tagged Concrete 2023, conference registration, Conference speakers
Leave a comment
