Tag Archives: Excel

Dynamic charts

Posted on 23/07/2023 by dougaj4

A frequently asked question is how to get Excel charts to automatically update when new data is added outside the original selected ranges. The most frequent recommendation (such as here) is to convert the data to a table, then insert … Continue reading →

Posted in Charts, Charts, Concrete, Excel, UDFs | Tagged , , , , , | Leave a comment

3DFrame-py

Posted on 05/07/2023 by dougaj4

My 3DFrame spreadsheet has now been converted to Python code and can be downloaded from: 3DFrame-py.zip The frame analysis uses the Scipy linear algebra functions called from pyLinalgfuncs3, which must be available on the Python path: pyLinAlgfuncs3.zip The 3DFrame-py download … Continue reading →

Posted in Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, Strand7, VBA | Tagged , , , , , , , | 3 Comments

Calculating and plotting rotations

Posted on 19/06/2023 by dougaj4

This post was prompted by a recent post at Eng-Tips. The original problem seemed simple enough: Im trying to wirte a formula where I imput vessel heading and datum bore heading and it tells me FWD, STBD, AFT or PORT … Continue reading →

Posted in Coordinate Geometry, Drawing, Excel, Maths, Newton, VBA | Tagged , , , , , , | Leave a comment

Speed of Scipy Linear Algebra Solvers

Posted on 14/06/2023 by dougaj4

The files presented in the recent post on Scipy Linear Algebra Solvers include a wide range of different solver types, with in some cases numerous sub-options, allowing the functions to be called from Excel, and greatly extending and speeding up … Continue reading →

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

Scipy linear algebra functions in Excel

Posted on 30/05/2023 by dougaj4

The file pyLinAlgfuncs3.zip has open source Python code allowing the Scipy linear algebra functions to be called from Excel using the pyxll add-in. It also includes all the Python code to perform LU decomposition, as discussed in the previous post., … Continue reading →

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