Recent Comments
Category Archives: Newton
… and finally py_xlCBA 0.6 with trapezoidal loads
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
… and then py_xlCBA 0.5
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
py_xlCBA 0.04
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
2DFrame-py
… and 3DFrame-py update. I have added code to the 3DFrame-py module to allow simplified input for 2D frame analysis. The revised code and example spreadsheets can be downloaded from: 3DFrame-py.zip There are also miscellaneous minor revisions to the 3DFrame … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, Strand7, UDFs
Tagged 2D Frame analysis, compare to Strand7, Excel, Frame Analysis, MatPlotlib, Numba, PyPardiso, Python, PyXLL
Leave a comment
Alternative iterative solvers
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 Brent's method, Excel, Goal Seek, Iterative solvers, Lambert W function, PyXLL, SciPy, UDF, VBA
Leave a comment
Newton Excel Bach, not (just) an Excel Blog 