Author Archives: dougaj4

Scipy Statistics Functions – coding and getting help

The Python Scipy library currently has 84 statistics functions.  I have now updated the xlwSciPy3 spreadsheet to access all of them directly from Excel.  The new version can be downloaded from: xlwSciPy3.zip As usual, the download includes full open-source code.  … Continue reading

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

Using Hyperlinks

Hyperlinks are useful to link to other locations in a spreadsheet, or any location with an accessible address, but they can do more than that. A recent post at Daily Dose of Excel looks at using hyperlinks as a general … Continue reading

Posted in Excel | Tagged , , | Leave a comment

On Rythym

“Foli” is the word used for rhythm by the Malinke tribe in West Africa. But Foli is not only found in Malinke music, but in all parts of their daily lives. Directed by Thomas Roebers, this short film portrays the people of Baro, … Continue reading

Posted in Bach | Tagged , , , | Leave a comment

Some multi-cultural songs

The latest concert of the excellent Willoughby Symphony Choir featured a collection of popular and folk songs, rather than their usual classical performances.  I was struck by the mixture of cultural influences in many of the songs, and have collected  a … Continue reading

Posted in Bach | Tagged , , , , , | Leave a comment

Using Section Properties- Group

Following a recent comment I have updated the documentation for finding the section properties of groups of shapes in the Section-Properties-Group spreadsheet.  The revised file can be downloaded from: Section Properties07-Group.zip The screenshots below illustrate use of the Group function to … Continue reading

Posted in Coordinate Geometry, Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , , | 8 Comments