Monthly Archives: January 2014

New Links: Scientific Python and Engineering Excel

The previous post had a link to Cyrille Rossant which is worth a closer look.  The blog has many detailed posts on scientific applications of Python, as well as links to Galry: a high performance interactive visualization package in Python and his … Continue reading

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

The speed of loops in Python

This post is based on exercises published by Cyrille Rossant in his book “Learning IPython for Interactive Computing and Data Visualization”.  Cyril also has a blog well worth looking at: http://cyrille.rossant.net/blog/ (Thanks to Alfred Vachris and Boris Vishnevsky for the links). … Continue reading

Posted in Arrays, Link to Python, NumPy and SciPy | Tagged , , , , | Leave a comment

Jack Orion

This is what Wikipedia says of the music played by The Pentangle: Pentangle are usually characterised as a folk-rock band. Danny Thompson preferred to describe the group as a “folk-jazz band.”[25] John Renbourn also rejected the “folk-rock” categorisation, saying, “One … Continue reading

Posted in Bach | Tagged , | Leave a comment

Frame Analysis with Excel

Starting from 2009 I have posted a series on frame analysis using Excel, starting from a simple “on-sheet” solution and working through to applications able to solve large 2D or 3D problems. To follow the analysis process it is best … Continue reading

Posted in Excel, Frame Analysis, VBA | Tagged , , , | 1 Comment

Two MaxAbs functions

Excel does not have a built-in function to find the maximum absolute value of a range, perhaps because the Max() and Abs() functions can be combined in an array function: =Max(Abs(datarange)) This solution has a number of drawbacks however: The … Continue reading

Posted in Arrays, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | 9 Comments