Login    Register

Up-To-Date Tally of Songs Performed

2018 - Now with opening act Emo Philips!

Moderators: Moderators, ConcertTracker

  • Author
    Message

Re: Up-To-Date Tally of Songs Performed

Postby hungerfan » Fri Mar 30, 2018 4:53 pm

I just thought of an addition to the spreadsheet that would be nice. A script that will auto sort them for you from most played down to least played. I have one setup in my sheet for this poker group I am in that keeps track of points earned each game. As soon as a new game is played and data is entered the script kicks in and will resort the leader board. Just makes it easier to see the tunes that have been played the most.

The only problem I would see is that you would need to tweak it so it only sorted certain rows and then you would not lose your grouping at the end.
User avatar
hungerfan
Occasional
 
Posts: 61
Joined: Wed Nov 08, 2017 8:02 pm
Likes: 0 post
Liked in: 0 post

Re: Up-To-Date Tally of Songs Performed

Postby ergalthema » Fri Mar 30, 2018 5:02 pm

hungerfan wrote:I just thought of an addition to the spreadsheet that would be nice. A script that will auto sort them for you from most played down to least played. I have one setup in my sheet for this poker group I am in that keeps track of points earned each game. As soon as a new game is played and data is entered the script kicks in and will resort the leader board. Just makes it easier to see the tunes that have been played the most.

The only problem I would see is that you would need to tweak it so it only sorted certain rows and then you would not lose your grouping at the end.


Have you checked out the "Charts and Graphs" tab? It (as well as the "Songs" tab) has the originals listed that way.

Also, you can sort by column C to get a similar list.

If you're asking for a different functionality, I'm sorry if I'm misunderstanding.
User avatar
ergalthema
Occasional
 
Posts: 142
Joined: Mon Dec 04, 2017 6:23 pm
Likes: 0 post
Liked in: 0 post

Re: Up-To-Date Tally of Songs Performed

Postby hungerfan » Fri Mar 30, 2018 5:46 pm

I didn't even notice you had more data in tabs! :)
User avatar
hungerfan
Occasional
 
Posts: 61
Joined: Wed Nov 08, 2017 8:02 pm
Likes: 0 post
Liked in: 0 post

Re: Up-To-Date Tally of Songs Performed

Postby drtrogg » Fri Apr 13, 2018 9:32 pm

Somewhere I saw an interview with Jim that said they had a "library of about 50 songs to choose from".

Sounded like a lot, but you've got 48 listed for the originals!
May 28, 1996 Toad's Place New Haven, CT
Oct 19, 2012 NSMT Beverly MA https://goo.gl/photos/36ueybxbyHf49avb8
Jun 6, 2015 Foxwoods https://goo.gl/photos/XUbVdnBkaL56sdtM6
Sep 14, 2016 PPAC Providence, RI
Mar 2, 2018 Foxwoods
User avatar
drtrogg
Newbie
 
Posts: 20
Joined: Thu Jul 10, 2014 12:09 am
Likes: 0 post
Liked in: 0 post

Previous

Return to The Ridiculously Self-Indulgent, Ill-Advised Vanity Tour

Who is online

Users browsing this forum: No registered users and 7 guests