Tag Archives: UDFs

Tanh-Sinh Quadrature v. 5.03

Following some recent comments Graeme Dennes has released the latest version the Tanh-Sinh Quadrature spreadsheet with some corrections to the test function documentation. The new file is located (as before) at: Tanh-Sinh Quadrature For more information on the last major release … Continue reading

Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , | 4 Comments

Using Matplotlib from Excel with pyxll

The pyxll documentation has many examples of plotting in Excel using Matplotlib and other packages, but I find the multiple options confusing and hard to follow, so this post works through the examples in the Matplotlib Users Guide tutorial. The … Continue reading

Posted in Charts, Charts, Drawing, Excel, Link to Python, PyXLL, UDFs | Tagged , , , , , , | Leave a comment

Installing PyPardiso

The PyPardiso package provides an interface to the Intel MKL Pardiso library to solve large sparse linear systems of equations. Trying to install this package with Conda raises the message: To search for alternate channels that may provide the conda package you’relooking … Continue reading

Posted in Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , | Leave a comment

More on Numba

Following my recent post Making Finite Element Analysis go faster … I have been having a closer look at the options in the Numba just-in-time compiler for improving the performance of Python code. The Numba docs include a series of short … Continue reading

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

Elastic Biaxial Bending

Spreadsheets performing Ultimate Limit State analysis with biaxial moments have been presented previously, most recently here: Biaxial bending update I have now modified the Beam Design Functions spreadsheet to carry out a biaxial moment analysis with linear elastic material properties. … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , | Leave a comment