Tag Archives: SciPy

Alternative iterative solvers

Posted on 03/03/2026 by dougaj4

This post looks at alternative solutions to a problem posted on Quora: How can 2^x = 10x be solved? One of the alternatives requires a new function linking to Scipy that has been added to the pyScipy module, that can be downloaded … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, 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

Evaluate and display definite integrals in Excel with Latex and Matplotlib

Posted on 09/08/2025 by dougaj4

The py_Evalu spreadsheet was last presented at Scipy Functions with Excel and pyxll 5 – Evaluate with Units and included the Plot_Math function, which converts a text string to Latex format, then uses Matplotlib to convert this to a graphic image, … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, Numerical integration, PyXLL, UDFs | Tagged , , , , , , , , , , , , | Leave a comment

3DFrame-py-comb

Posted on 01/02/2025 by dougaj4

The 3DFrame-py spreadsheet has now been updated with provisions for saving multiple load cases and the associated results, and analysis with factored combinations of multiple load cases. The new files can be downloaded from: 3DFrame-py.zip See Installing 3DFrame-py for installation details, and … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, Strand7, UDFs | Tagged , , , , , , , , , , | 1 Comment

3DFrame-py rel. 0.40

Posted on 01/01/2025 by dougaj4

A new version of 3DFrame-py has been released and can be downloaded from: 3DFrame-py.zip See Installing 3DFrame-py for installation details, and details of other Python modules required. Also see Python and pyxll for details of the required pyxll package, including a coupon code for … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, Strand7, UDFs | Tagged , , , , , , , , , | 5 Comments