Category Archives: Newton

Scipy functions with Excel and pyxll

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

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

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

Python code updates – 3DFrame-py

Recent changes to how Python treats comparing a Numpy array to an empty list have resulted in some of my functions returning errors and I am in the process of updating them. Specifically, when an optional argument to a function … Continue reading

Posted in Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , , | 2 Comments

SectionProperties Release 3

Robbie van Leeuwen’s SectionProperties program, (last featured here) has recently been updated to Release 3 with some major changes to the code, including: Full documentation can be found at: SectionProperties docs Changes to the code have required updates to my Excel … Continue reading

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