Recent Comments
debamita on Deflections and Moments in Rec… A Numpy trap –… on Using Numba with Excel and pyx… 
dougaj4 on ULS Design Functions upda… dougaj4 on ULS Design Functions upda… 
Benata on ULS Design Functions upda… Benata on ULS Design Functions upda… Benata on ULS Design Functions upda… dougaj4 on ULS Design Functions upda… Ata on ULS Design Functions upda… dougaj4 on ULS Design Functions upda… 
SHAMIL NURI on ULS Design Functions upda… dougaj4 on ULS Design Functions upda… SHAMIL NURI on ULS Design Functions upda… dougaj4 on ULS Design Functions upda… SHAMIL NURI on ULS Design Functions upda…
Tag Archives: VBA
On long and short formulas and VBA
A recent thread at Eng-Tips asked the following apparently simple question: Starting with a string consisting of numbers with a single central group of letters, how can this string be truncated at the end of the letters, so that for … Continue reading
Posted in Excel, UDFs, VBA
Tagged Creating a VBA module, Declaring integers, Excel, Extracting text, UDF, VBA
Leave a comment
ULS Design Functions 2.13
I have uploaded another update to the ULS Design Functions spreadsheet with some new features and fixes. The new version can be downloaded from: ULS Design Functions.zip The changes in the new version are: Stress block type 3 will now … Continue reading
Posted in Concrete, Excel, Newton, UDFs, VBA
Tagged AS 3600, AS 5100, Excel, Newton, non-rectangular concrete sections, Parabolic stress block, UDF, ULS design of concrete, VBA
Leave a comment
Using Numba with Excel and pyxll …
… and a Numpy trap. I last looked at using the just-in-time compiler Numba with Python some time ago (Two Timers), but I was prompted to take another look by an article in Medium that claimed Python Can Be Faster … Continue reading
Posted in Arrays, Excel, Link to Python, NumPy and SciPy, PyXLL, UDFs, VBA
Tagged Excel, Just-in-time, Numba, Numpy, Numpy bug, Python, timers, VBA
2 Comments
ULS Design Functions update
The ULS Design Functions spreadsheet has been updated with further changes related to the new Australian Standard for concrete structures; AS 3600-2018, and with some other fixes. The new version can be downloaded from: ULS Design Functions.zip The changes in … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged AS 3600, Eurocode 2, Excel, Non-rectangular sections, Reinforced Concrete, Section Analysis, UDF, VBA
13 Comments
3D Frame Update
Following a comment here I have updated the code for the 3DFrame spreadsheet to calculate shear deflections correctly for sections with a different shear area for each transverse principal axis. The updated files can be downloaded from: 3DFrame.zip A note … Continue reading
Posted in Excel, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged 3DFrame, Excel, section property definitions, Shear area, shear deflections, VBA
Leave a comment
