Category Archives: Maths

Pi day of the Century

Posted on 14/03/2015 by dougaj4

In North America, where today is 3-14-15, it is Pi day, and since there are not 31 days in April, the rest of us have to go along with that as well. Not only is it Pi day, it’s the … Continue reading →

Posted in Charts, Excel, Maths, Newton | Tagged , , , , , | 6 Comments

Numerical Integration; Tanh-Sinh Quadrature v. 4.3

Posted on 29/12/2014 by dougaj4

A new version (4.3) of the numerical integration spreadsheet by Graeme Dennes is now available for download from Tanh_Sinh Quadrature. The Tanh-Sinh Quadrature Version 4.3 workbook now provides a feature for the integration of integrands contained in independent (external) UDFs. … Continue reading →

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

Numpy and Scipy for Excel

Posted on 14/12/2014 by dougaj4

The Python Numpy and Scipy libraries contain a huge number of maths and science related functions.  Most of these are not directly available from Excel, but using the free ExcelPython package it is fairly easy to make the link, vastly increasing … Continue reading →

Posted in Excel, Link to Python, Maths, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , | 11 Comments

Section Properties Update

Posted on 02/11/2014 by dougaj4

The Section Properties spreadsheet provides formulas for the section properties of 35 different defined shapes, calculation of section properties from coordinates, and interactive calculation and plotting of any chosen shape with defined dimensions: The latest version added the function to … Continue reading →

Posted in Excel, Maths, Newton, VBA | Tagged , , , | 2 Comments

Assorted links

Posted on 26/10/2014 by dougaj4

A collection of useful Excel and science/engineering related links that I have discovered/rediscovered recently: Craig Hatmaker’s Beyond Excel: Everyone knows Microsoft Excel is a powerful data mani-pulation engine, but data lives in databases and only a few Excel experts know … Continue reading →

Posted in Excel, Link to Python, Maths, Newton | Tagged , , , , , | 1 Comment