Category Archives: Newton

py_Numpy update 2: Polynomial functions

Posted on 04/10/2025 by dougaj4

Continuing from the previous post, this post looks at the polynomial functions in the revised py_Numpy spreadsheet. The updated code and spreadsheet can be downloaded from:  py_SciPy.zip The available functions call the Numpy functions for solution and evaluation of polynomials, … Continue reading →

Posted in Curve fitting, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , | Leave a comment

py_RC Elastic 1.05 with elastic biaxial bending

Posted on 24/09/2025 by dougaj4

The py_RC Elastic spreadsheet (last discussed here) has been updated with a new function py_Biax, providing elastic analysis of reinforced concrete sections under combined axial load and biaxial bending. The new spreadsheet and associated Python code can be downloaded from: py_RC … Continue reading →

Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, PyXLL, UDFs | Tagged , , , , , , | Leave a comment

ConBeamU update

Posted on 20/09/2025 by dougaj4

Following a comment at https://newtonexcelbach.com/2023/01/20/using-conbeamu/ I have updated the ConBeamU-Template file so that the function to select the input range works the same as in the main spreadsheet. For more details of how the spreadsheet works, see the link above, … Continue reading →

Posted in Beam Bending, Excel, Newton, UDFs, VBA | Tagged , , , , , , , | Leave a comment

Long integers in Python and Excel and py_Fact

Posted on 27/08/2025 by dougaj4

I have added a new py_Fact function to the py_Scipy module, that returns the factorial of an integer as a float if it is up to 15 digits long, or a string for longer numbers. The revised code, and the … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , | Leave a comment

Python functions for rotation

Posted on 22/08/2025 by dougaj4

I have recently needed code to rotate 2D coordinates, either about the origin, or some specified other point, using pyxll to call the code from Excel. My first attempt was a direct translation of some VBA code, that also worked … Continue reading →

Posted in Coordinate Geometry, Excel, Link to Python, Maths, Newton, PyXLL | Tagged , , , , , , | Leave a comment