Author Archives: dougaj4

Can you spare a dime

Posted on 23/11/2016 by dougaj4

I enjoyed this rendition of a classic song by Martin Simpson: I also enjoyed this comment: daniel gorney1 year ago Bravo. A very fine rendition. My daddy, Jay Gorney, who wrote the music, would have enjoyed it as much as … Continue reading →

Posted in Bach | Tagged , | Leave a comment

More on Lookups

Posted on 22/11/2016 by dougaj4

Following my recent post on nearest lookups, I came across a post from Charles Williams on the opposite problem; how to do an exact VLookup  on a large amount of data without taking all day, but still retaining the ability to return … Continue reading →

Posted in Excel | Tagged , , | Leave a comment

Installing C# dll files, reminder

Posted on 04/11/2016 by dougaj4

Installing the Frame4 spreadsheet on a new computer I had some problems registering the dll files required for the compiled solver routines, so here is a reminder of the procedure: Copy the alglibnet2.dll and ALMatrixLib.dll files to the appropriate folder (see … Continue reading →

Posted in Excel, Frame Analysis, Link to dll, VBA | Tagged , , | 5 Comments

Nearest Lookup Function

Posted on 21/10/2016 by dougaj4

The Excel Lookup functions (including VLookup, HLookup and Match) all allow for an “exact” or “closest” match on numerical data, but the closest option has a number of problems: The data must be sorted For VLookup and HLookup the data … Continue reading →

Posted in Coordinate Geometry, Excel, Maths, UDFs, VBA | Tagged , , , , , , , , | 2 Comments

The Pentangle in Europe

Posted on 19/10/2016 by dougaj4

Two recent You Tube uploads of Pentangle performances in Europe.  The first is from Norwegian TV in 1968, singing the Anne Briggs song The Time has Come: The second from French TV in 1972, with 6 songs, mostly from their Reflection LP:

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