Set 1:
The Landlady (7/10/16 - 122, 1/17/16 - 13, 9/6/15 - 7 ave 47.3) Olivia's Pool (11/17/97- 694, 7/29/97 - 17, 7/10/97 - 7 ave 239.3) The Man Who Stepped (8/21/15 - 147, 8/21/15 - 0, 7/4/12 - 124 ave 90.3) Avenu Malkenu (8/21/15 - 147, 7/4/12 - 124, 6/21/09 - 136 ave 135.7) The Man Who Stepped (7/14/19 - 0, 8/21/15 - 147, 8/21/15 - 0 ave 49.0) Meatstick (6/25/19 - 13, 10/31/18- 20, 10/19/18- 8 ave 13.7) Vultures (10/27/18- 35, 8/5/18 - 17, 7/29/17 - 26 ave 26.0) Spock's Brain (2/21/19 - 25, 7/30/03 - 429, 10/6/00 - 35 ave 163.0) Pebbles and Marbles (6/30/19 - 9, 7/26/17 - 71, 8/3/14 - 106 ave 62.0) Glide (7/23/17 - 82, 8/15/15 - 67, 7/9/14 - 53 ave 67.3) About to Run (7/6/19 - 5, 6/28/19 - 6, 6/19/19 - 6 ave 5.7) Strange Design (7/8/16 - 124, 10/29/14- 50, 10/17/14- 8 ave 60.7) Timber (Jerry the Mu (6/28/19 - 11, 10/21/18- 28, 8/10/18 - 10 ave 16.3) I Didn't Know (6/19/19 - 17, 10/17/18- 25, 7/31/18 - 13 ave 18.3) Good Times Bad Times (11/2/18 - 31, 7/21/17 - 53, 12/28/16- 12 ave 32.0)
Set 2:
Mercury (7/5/19 - 6, 6/28/19 - 5, 6/21/19 - 5 ave 5.3) Ruby Waves (7/10/19 - 3, 7/10/19 - 0, 6/29/19 - 7 ave 3.3) Twist (7/2/19 - 8, 6/23/19 - 6, 6/16/19 - 5 ave 6.3) Swept Away (12/28/18- 29, 8/1/17 - 47, 7/8/12 - 192 ave 89.3) Steep (12/28/18- 29, 8/1/17 - 47, 7/8/12 - 192 ave 89.3) Death Don't Hurt Ver (7/6/19 - 5, 6/29/19 - 5, 6/22/19 - 5 ave 5.0) Icculus (12/31/13- 210, 8/30/13 - 18, 6/17/11 - 82 ave 103.3) Buffalo Bill (9/3/17 - 69, 10/24/16- 33, 8/23/15 - 43 ave 48.3) Icculus (7/14/19 - 0, 12/31/13- 210, 8/30/13 - 18 ave 76.0) You Enjoy Myself (6/29/19 - 10, 6/18/19 - 8, 2/22/19 - 6 ave 8.0) Catapult (7/27/14 - 191, 8/14/09 - 206, 8/12/04 - 30 ave 142.3) Contact (7/9/19 - 4, 11/1/18 - 28, 7/17/18 - 32 ave 21.3) You Enjoy Myself (7/14/19 - 0, 6/29/19 - 10, 6/18/19 - 8 ave 6.0) Enc: More (7/9/19 - 4, 7/3/19 - 3, 6/21/19 - 9 ave 5.3) Tweezer Reprise (7/3/19 - 7, 7/2/19 - 1, 6/21/19 - 8 ave 5.3) The last three times played score for this show is 54.7
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.