Category Archives: PyXLL

Scipy-statistics with distributions

Posted on 01/05/2026 by dougaj4

The Scipy statistics functions last presented here have now been updated with the addition of links to the numerous distribution functions. The py_Stats spreadsheet, with associated Python code in PythonStatsFuncs3.py and pyScipy3.py, and also minor updates to the pyNumpy.py code, … Continue reading →

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

The Ultimate Python Guide for VBA Developers

Posted on 15/04/2026 by dougaj4

I recently discovered “The Ultimate Python Guide for VBA Developers” which is a free book available from the pyxll site at https://www.pyxll.com/learn-python.html. The pyxll site says: This book has been written specifically for VBA and Excel users like you. Fast … Continue reading →

Posted in Computing - general, Excel, Link to Python, Python Pandas, PyXLL, UDFs, VBA | Tagged , , | Leave a comment

… and finally py_xlCBA 0.6 with trapezoidal loads

Posted on 11/04/2026 by dougaj4

The latest version of the Python continuous beam analysis program pyCBA is 0.7, allowing for specification of trapezoidal distributed loads, and this is now available with pip. I have updated the py-xlCBA spreadsheet and associated code to use the latest … Continue reading →

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

… and then py_xlCBA 0.5

Posted on 05/04/2026 by dougaj4

Following the previous post, more detailed checking found that the code was returning an error for beams with a support at X = 0. This has now been fixed, and the revised code and spreadsheets can be downloaded from: py_xlCBA.zip … Continue reading →

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

py_xlCBA 0.04

Posted on 03/04/2026 by dougaj4

The pyCBA code has now been updated to allow for supports with specified displacements (release 0.6 or later). My py_xlCBA spreadsheet and associated functions have been updated to call the pyCBA code for displacement analysis, rather than using my add-on … Continue reading →

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