Category Archives: Maths

A mystery curve links to Jupyter

Posted on 16/07/2015 by dougaj4

Reviewing some of my less visited links recently, I was intrigued by a post at The Math Less Travelled: The previous post at the site provides more details of the source of the curve, and some links to an interactive … Continue reading →

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

Section Properties – Lunes and Groups

Posted on 08/07/2015 by dougaj4

Following a discussion at Eng-Tips and resulting comments I have updated my Section Properties spreadsheet to include calculation of the area and centroid of a “Lune” (the shape of a crescent moon).  I have also added a “Re-draw Shape” button because … Continue reading →

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

xlSciPy 1.01

Posted on 05/05/2015 by dougaj4

The xlSciPy spreadsheet, introduced here, has been updated with many new functions.  The new version, including full open source code (VBA and Python) can be downloaded from: xlSciPy.zip The spreadsheet requires Python to be installed, including NumPy and SciPy.  It … Continue reading →

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

Falling Faster

Posted on 26/03/2015 by dougaj4

A recent paper by  Alexander Klotz of McGill University, Montreal, has stirred a bit of interest in the pop-science press.  The paper looks at the old question of the time taken to fall through a hole passing through the centre … Continue reading →

Posted in Excel, Maths, Newton | Tagged , , | 4 Comments

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