Recent Comments
Author Archives: dougaj4
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 Anais Mitchell, Bach, Christy Moore, Kate Rusby, Sheila Chandra, Willoughby Symphony Choir
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
Passing variable argument lists from Excel to Python via xlwings
When calling a Python function it is sometimes necessary to pass a variable number of arguments. Examples from the xlw_Scipy spreadsheet include: Curve fitting functions, for which the functions to be fitted may have any number of arguments. The Scipy … Continue reading
Posted in Arrays, Excel, Link to Python, NumPy and SciPy, UDFs, VBA, xlwings
Tagged dictionaries, Excel, ParamArray, Passing arrays, Passing named arguments, Python, UDFs, VBA, xlwings
2 Comments
Two songs = 2/3 Wikipedia
It is said that a picture is worth a 1000 words. On the same basis, a poem is worth 1000 pictures, and a song is worth 1000 poems. So two songs are worth 2 billion words, which is about 2/3 … Continue reading
New Links – 2018
Some new links to active Excel related blogs: David Hagar has been active in the Excel community for many years, and has published the Excel For You blog since 2013. I was led to it by a recent post on a UDF … Continue reading
Posted in Computing - general, Excel
Tagged Excel, Excel for You, Excel Matters, links, My Spreadsheet Lab
Leave a comment
Newton Excel Bach, not (just) an Excel Blog 