Category Archives: Newton

Extracting text from an Internet table

Posted on 11/12/2020 by dougaj4

For use in my Units spreadsheet (Units4Excel) I want to extract the unit conversion values from the comprehensive Wikipedia unit conversion table. On Wikipedia the table looks like this: and when copied and pasted as Unicode text into Excel, like … Continue reading →

Posted in Excel, Newton, UDFs, VBA | Tagged , , , , , , , | 3 Comments

Tanh-Sinh Quadrature update

Posted on 26/11/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

Newton-Raphson and Brent’s Method – Solver examples

Posted on 08/11/2020 by dougaj4

I recently discovered the Computing Skillset site (via open-struct-engineer), which has good information on the basis and use of the Newton-Raphson method: The Newton Raphson method explained, details, pictures, python code Highly instructive examples for the Newton Raphson method I … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | 1 Comment

Numerical Integration With Tanh-Sinh Quadrature v 5.0

Posted on 29/10/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

Open Source FEA Code Links

Posted on 25/10/2020 by dougaj4

There have been many posts here based on code from the book Programming The Finite Element Method, with the Fortran code either translated to VBA, or with VBA links to compiled Fortran Code. I recently discovered: The “Programming the Finite … Continue reading →

Posted in Computing - general, Excel, Finite Element Analysis, Fortran, Frame Analysis, Link to Python | Tagged , , , , | 1 Comment