Category Archives: Numerical integration

Installing Python and pyxll from scratch

Posted on September 26, 2022 by dougaj4

Updated 28th September 2022. Matplotlib latest version OK. I recently installed Python and pyxll (plus the required additional libraries) on a new computer, which raised a few problems with incompatible versions, so here is a summary of what worked (as … Continue reading →

Posted in Animation, Arrays, Charts, Coordinate Geometry, Differential Equations, Excel, Finite Element Analysis, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, Python Pandas, PyXLL, UDFs | Tagged , , , , , , , , , , , , , , | Leave a comment

SectionProperties update

Posted on January 16, 2022 by dougaj4

In late 2017 I posted Section Properties with MeshPY, including torsion and warping which looked at an Excel front end for Robbie van Leeuwen’s SectionProperties program, which provides facilities for calculation of section properties of complex shapes, including torsion and warping constants. … Continue reading →

Posted in Charts, Excel, Finite Element Analysis, Link to Python, Newton, Numerical integration, NumPy and SciPy, PyXLL, Strand7 | Tagged , , , , | 1 Comment

Tanh-Sinh Quadrature v. 5.03

Posted on November 22, 2021 by dougaj4

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

Tanh-Sinh Quadrature update

Posted on November 26, 2020 by dougaj4

Following some comments here Graeme Dennes and I have modified the start-up code for the Tanh-Sinh Quadrature spreadsheet to avoid problems opening the file when first downloaded, or copied to a new computer. The new file is located (as before) … Continue reading →

Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , | Leave a comment

Numerical Integration With Tanh-Sinh Quadrature v 5.0

Posted on October 29, 2020 by dougaj4

Graeme Dennes has updated his Tanh-Sinh Quadrature spreadsheet to V 5.0. The new version (including full open source code) may be downloaded from: Tanh-Sinh Quadrature Graeme’s summary of the new features in the spreadsheet: The Tanh-Sinh quadrature workbook has been … Continue reading →

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