Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Downloads
- XLDennis, the MSDN Library, and VBA rant
- Daily Download 4: Continuous Beam Analysis
- Numerical Integration With Tanh-Sinh Quadrature v 6.0
- Writing Arrays to the worksheet - VBA function
- Drawing in Excel 7 - Creating drawings from coordinates
Recent Comments
Category Archives: Newton
RCInteract and RC Design Functions 7.03
Since the previous post, I have updated the notes in the RC Design Functions spreadsheet to reflect the fact that with the recent update to the Bridge Design Code (AS 5100) the reinforced concrete strength design requirements for beam bending … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged ACI318, AS3600, AS5100, Combined bending and axial load, Eurocode2, Excel, Interaction Diagram, RC Design Functions, Reinforced Concrete, UDF, VBA
16 Comments
RC Design Functions 7.03
The latest update to my RC Design Functions spreadsheet has just been uploaded, and is available for free download (including full open-source code) from: RC Design Functions7.zip The main new feature in the latest version is a new RCInteract function, which generates an … Continue reading
Indexing NumPy arrays with floats …
… now you can’t. I recently updated to the latest version of NumPy (1.12.1), and today I discovered that some of my spreadsheets using NumPy arrays (via xlwings) were returning errors like: IndexError: only integers, slices (`:`), ellipsis (`…`), numpy.newaxis … Continue reading
Posted in Arrays, Excel, Link to Python, NumPy and SciPy, UDFs, VBA
Tagged Float index, IndexError, Numpy, Python, VBA, xlwings
2 Comments
Year 9 Report
Last years’ statistics for this blog are now uploaded to Onedrive. The link to each post is preserved in the spreadsheet, so it makes a convenient index to what has been posted over the year, and what people are looking … Continue reading
The meaning of = in Python
In VBA, if you have an array named a and a variant named b, then the statement “b = a” creates a new array b with the same size and values as a. If the values of either a or b are subsequently changed, the values of the … Continue reading