Category Archives: Newton

Scipy Functions with Excel and pyxll 3 – Solvers 1

Posted on 17/12/2023 by dougaj4

Following the the first post in this series I will move on to the py_Solvers spreadsheet included in the download file: py_SciPy.zip Details of the required pyxll package (including download, free trial, and full documentation) can be found at: pyxll For those … Continue reading →

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

Scipy Functions with Excel and pyxll 2 – Interpolation

Posted on 13/12/2023 by dougaj4

Following the previous post I will now look in more detail at the functions in the py_Interpolate spreadsheet included in the download file: py_SciPy.zip Details of the required pyxll package (including download, free trial, and full documentation) can be found … Continue reading →

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

Scipy functions with Excel and pyxll

Posted on 10/12/2023 by dougaj4

Over the years, I have posted a large number of user defined functions (UDF’s) allowing Python Scipy functions (and related libraries) to be accessed from Excel. These have now been consolidated in a uniform format, using the pyxll add-in and … Continue reading →

Posted in Arrays, Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , | 7 Comments

Early Analog Computers

Posted on 05/12/2023 by dougaj4

We tend to think of computers as having been developed starting in the years after the second world war, but in the late 19th and early 20th centuries the focus was on analog computers, which were seen as being the … Continue reading →

Posted in Computing - general, Newton | Tagged , , , | Leave a comment

Python Code Updates – py_UMom

Posted on 18/11/2023 by dougaj4

Further to the previous post the py_UMom spreadsheet has now been updated for the latest Python and Numpy versions. The latest version can be downloaded from: py_UMom.zip In addition to the Python code changes, the example of the OptShearCap3600 function … Continue reading →

Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , , | 1 Comment