Category Archives: Maths

A Loopy Link (and three more)

For some reason Doug Glancy’s Excel Blog has escaped my attention up till now, but having a browse today, I discovered this loopy animation: which would not have been out of place in Douglas Hofstadter’s “I am a Strange Loop” I really … Continue reading

Posted in Animation, Computing - general, Excel, Maths, Newton, VBA | Tagged , , , , , | 2 Comments

A mystery curve links to Jupyter

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

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

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

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