Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- About Newton Excel Bach
- Filling Blanks with Go To-Special (and local help rant)
- XLDennis, the MSDN Library, and VBA rant
- Downloads
- Frame Analysis with Excel - 3, Continuous beam or frame
- Writing Arrays to the worksheet - VBA function
- Daily Download 5: Frame Analysis
Recent Comments
Author Archives: dougaj4
A Numpy trap – correction
In my post of 30th May this year (here) I said that: As a check that the functions were working correctly, the Python functions were modified to return the sum of the largest array in the first row, revealing that … Continue reading
Posted in Arrays, Excel, Link to Python, NumPy and SciPy, PyXLL, UDFs
Tagged arange data limit, int32, int64, Numpy, Numpy bug, Python
Leave a comment
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
Update 17 May 2022: Following discussion on 10-11 May 22 the download file has been updated to version 2.15, fixing problems with the interaction diagram with a rectangular stress block under high axial loads. I have uploaded another update to … 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
25 Comments
… and something a bit more recent
Castlereagh Connection A young band from Coonamble aged 11-13, they’ve been performing together for over 4 years 11 July 21: For some reason the Facebook video link isn’t working any more, so here is another one from Youtube: