Set 1:
Alumni Blues (8/10/87 - 2, 8/10/87 - 0, 5/20/87 - 2 ave 1.3) Letter to Jimmy Page (8/10/87 - 2, 5/11/87 - 3, 4/29/87 - 1 ave 2.0) Alumni Blues (8/29/87 - 0, 8/10/87 - 2, 8/10/87 - 0 ave 0.7) The Ballad of Curtis (4/29/87 - 6, *** - 31, *** - 0 ave 18.5) Sneakin' Sally Throu (8/9/87 - 3, 5/11/87 - 2, 3/6/87 - 4 ave 3.0) Makisupa Policeman (5/11/87 - 5, 4/29/87 - 1, 1/21/87 - 6 ave 4.0) Big Black Furry Crea (8/21/87 - 1, *** - 36, *** - 0 ave 18.5) Flat Fee (8/21/87 - 1, 8/9/87 - 2, *** - 34 ave 12.3) Lushington (8/9/87 - 3, 5/20/87 - 1, 5/11/87 - 1 ave 1.7) Suzy Greenberg (8/9/87 - 3, 2/21/87 - 7, 2/13/87 - 1 ave 3.7) Hold Your Head Up (8/21/87 - 1, *** - 36, *** - 0 ave 18.5) Suzy Greenberg (8/29/87 - 0, 8/9/87 - 3, 2/21/87 - 7 ave 3.3) Mustang Sally (8/10/87 - 2, 10/31/86- 12, 10/15/86- 1 ave 5.0) Ya Mar (8/9/87 - 3, 5/11/87 - 2, 2/21/87 - 5 ave 3.3) The Man Who Stepped (5/11/87 - 5, 5/11/87 - 0, *** - 32 ave 12.3) Avenu Malkenu (5/11/87 - 5, *** - 32, *** - 0 ave 18.5) The Man Who Stepped (8/29/87 - 0, 5/11/87 - 5, 5/11/87 - 0 ave 1.7)
Set 2:
Clod (8/21/87 - 1, 5/11/87 - 4, 2/21/87 - 5 ave 3.3) Slave to the Traffic (8/9/87 - 3, 5/11/87 - 2, 4/29/87 - 1 ave 2.0) Swing Low, Sweet Cha (8/21/87 - 1, 4/29/87 - 5, 3/23/87 - 2 ave 2.7) The Curtain With (8/21/87 - 1, 8/10/87 - 1, 8/9/87 - 1 ave 1.0) McGrupp and the Watc (8/21/87 - 1, 8/9/87 - 2, 4/29/87 - 3 ave 2.0) Possum (8/10/87 - 2, 8/9/87 - 1, 5/20/87 - 1 ave 1.3) Harry Hood (8/21/87 - 1, 8/9/87 - 2, 5/20/87 - 1 ave 1.3) Timber (Jerry the Mu (8/9/87 - 3, 4/29/87 - 3, *** - 31 ave 12.3) AC/DC Bag (8/10/87 - 2, 8/9/87 - 1, 4/29/87 - 3 ave 2.0) Divided Sky (8/21/87 - 1, 8/10/87 - 1, 8/9/87 - 1 ave 1.0) Harpua (8/21/87 - 1, 8/21/87 - 0, 8/9/87 - 2 ave 1.0) Bundle of Joy (8/21/87 - 1, 5/11/87 - 4, *** - 32 ave 12.3) Harpua (8/29/87 - 0, 8/21/87 - 1, 8/21/87 - 0 ave 0.3)
Set 3:
La Grange (8/10/87 - 2, 8/9/87 - 1, *** - 34 ave 12.3) Corinna (8/9/87 - 3, 5/11/87 - 2, 3/23/87 - 3 ave 2.7) Mike's Song (8/21/87 - 1, 3/23/87 - 7, 12/6/86 - 5 ave 4.3) I Am Hydrogen (4/29/87 - 6, 4/24/87 - 1, 1/21/87 - 5 ave 4.0) Who Do? We Do! (4/29/87 - 6, 4/24/87 - 1, *** - 30 ave 12.3) Shaggy Dog (8/21/87 - 1, 8/9/87 - 2, 12/6/86 - 10 ave 4.3) David Bowie (8/21/87 - 1, 8/10/87 - 1, 8/9/87 - 1 ave 1.0) Jesus Just Left Chic (8/10/87 - 2, *** - 35, *** - 0 ave 18.5) The last three times played score for this show is 6.1
Explanation:
This report produces the last 3 times each song has been played and how many shows it had been between each time it was performed. So
Energy (8/4/13 - 226, 7/21/13 - 8, 7/17/13 - 3 ave 79.0)means that Energy was last played on 8/4/13 which was 226 shows ago. Before that it was played on 7/21/13 which was 8 shows prior. Before that it was played on 7/17/13 which was 3 shows prior. The average of 3, 8, and 226 is 79. The score at the end is the average of all of those averages.
If you're wondering, the example is from 7/9/19, the show that finally inspired me to add an explanation to help people out.