Category Archives: Link to Python

Excel Uservoice and Python for Excel

Posted on 18/12/2017 by dougaj4

The Excel Uservoice site is a forum for users to post suggestions for improvements to Excel.  A suggestion to add native Python support to Excel, as a replacement to VBA, has had by far the most votes since the start, and … Continue reading →

Posted in Computing - general, Excel, Link to Python, VBA | Tagged , , , , | 1 Comment

Section Properties with MeshPY, including torsion and warping

Posted on 09/12/2017 by dougaj4

I recently discovered robbie van leeuwen’s structural engineering blog, which has an open-source set of Python routines for calculation of section properties, including torsion and warping constants.  The program uses the MeshPY Library for generating the finite element meshes required … Continue reading →

Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, Strand7, UDFs, VBA, xlwings | Tagged , , , , , , , , | 11 Comments

Using Alglib least-squares solvers

Posted on 23/09/2017 by dougaj4

Following the last post on using the Python version of Alglib from Excel, via xlwings, this post looks in more detail at alternatives for fitting a non-linear function to a set of data, using the Levenberg-Marquardt method.  The spreadsheet with … Continue reading →

Posted in AlgLib, Curve fitting, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings | Tagged , , , , , , , , , , | 2 Comments

Evaluating text and calling Python functions from Excel with xlwings

Posted on 23/08/2017 by dougaj4

The Alglib spreadsheet presented here includes functions to evaluate formulas entered as text on the spreadsheet, or to call specified Python functions.  I have now added a user defined function (UDF) that will perform either of these operations (xl_CallFuncD), and added … Continue reading →

Posted in AlgLib, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings | Tagged , , , , , , , , , | 1 Comment

Excel to Alglib via xlwings

Posted on 11/08/2017 by dougaj4

The Alglib library provides many valuable numerical analysis routines, but the VBA version is no longer actively maintained.  The latest versions are available in C++, C#, and Python, of which the Python version (in conjunction with xlwings) provides the easiest interface … Continue reading →

Posted in AlgLib, Curve fitting, Excel, Link to Python, Maths, Newton, Numerical integration, UDFs, VBA, xlwings | Tagged , , , , , , , , , | 12 Comments