Recent Comments
Author Archives: dougaj4
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
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
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
Newton Excel Bach, not (just) an Excel Blog 