Recent Comments
vgmendes on LinEstGap with non-linear… 
dougaj4 on LinEstGap with non-linear… vgmendes on LinEstGap with non-linear… 
Stan on ALGLIB linear and polynomial f… dougaj4 on ALGLIB linear and polynomial f… S Rijdt on ALGLIB linear and polynomial f… dougaj4 on Fast Search Reminder 
Larry on Fast Search Reminder Fast Search Reminder… on Opening and searching pdf file… dougaj4 on Opening and searching pdf file… dougaj4 on Weighted Least Squares Regress… 
GP on Weighted Least Squares Regress… 
Kamran khan on Opening and searching pdf file… dougaj4 on 3D Frame Update 
angelgalvanc on 3D Frame Update
Category Archives: VBA
Fast Search Reminder
A recent comment at Opening and searching pdf files from Excel reminded of the linked spreadsheet, which allows pdf files to be opened at a specified page from Excel, and also fast searches of the local hard drive: PdfLink.zip (free download … Continue reading
Posted in Computing - general, Excel, VBA
Tagged Excel, Open pdf from Excel, pdf, search from Excel, VBA, Windows search
2 Comments
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
