Recent Comments
Category Archives: Newton
Elastic Biaxial Bending
Spreadsheets performing Ultimate Limit State analysis with biaxial moments have been presented previously, most recently here: Biaxial bending update I have now modified the Beam Design Functions spreadsheet to carry out a biaxial moment analysis with linear elastic material properties. … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged biaxial bending, elastic analysis, Excel, Reinforced Concrete, UDFs, VBA
9 Comments
Floating Point Precision Problems
A question on Quora : prompted me to look at how these numbers are handled in Excel, in VBA called from Excel, and in Python called from Excel via pyxll. The results are shown in the screenshot below: Column A … Continue reading
Eval and Let examples
Final example updated 28th Feb 2021, following comment from Craig: There are many examples of the use of the new Let function on the web (see my previous post on this topic for links). This post compares use of Let … Continue reading
Posted in Excel, Maths, UDFs, VBA
Tagged Eval UDF, Excel, Let function, nested functions, UDFs, VBA
9 Comments
Ebony Buckle, New Scientist, and the 52 Hz Whale
We last heard from Ebony Buckle here nearly 8 years ago, but I noticed her name in an article on the back page of last week’s New Scientist, which noted that her latest work was inspired by the World’s loneliest … Continue reading
Posted in Bach, Newton
Tagged 52 Hz Whale, Ebony Buckle, Feedback, New Scientist, Wonder
Leave a comment
Python callable arguments from Excel
Many Scipy functions have “callable” arguments, i.e. functions that can be called, with the returned data used as input by the calling function. Types of callable arguments include: Functions in the active Python module Functions in any active loaded library … Continue reading
Posted in Excel, Link to Python, NumPy and SciPy, PyXLL, UDFs
Tagged Eval, Excel, getattr, globals, lambda functions, Python, PyXLL, UDFs
1 Comment
Newton Excel Bach, not (just) an Excel Blog 