Recent Comments
Category Archives: Newton
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
ConBeamU 4.13
The continuous beam analysis spreadsheet, ConBeamU, is now up to version 4.13 with some minor bug-fixes, and the addition of a non-linear option for the BeamAct functions. See ConBeamU for more details of the functions available in the spreadsheet. Download … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged BeamAct functions, continuous beams, Excel, non-linear analysis, Strand7, UDF, VBA
7 Comments
Newton Excel Bach, not (just) an Excel Blog 