Song Setlist and Frequency Chart

**Greendad** · 09-13-2013, 04:21 PM

Hello,
I have used Excel before, but mainly for basic money calculation purposes, and it was years ago.
I have the desire to create a spreadsheet that will, in the end, allow me to see the frequency of certain songs I've seen by a certain band (the same band).
I racked my brain all last night trying to figure out the best approach in creating such a spread sheet.

What I want to do is provide the date of a concert, and all of the songs played at that specific concert. I have that info. There are 78 concerts that I need to input. However, it seems redundant for me to list, for example, "Song A" if it was played on "date X", and then list "song A" again if was played on "date Y". This is where I'm not sure what makes the most sense.

Would it be better to use the A-Z axis and provide the 78 dates of concerts, and use the numbered axis to list all of the songs that were seen/heard. Then I could put some sort of check mark in the cell that corresponds to the song and date? (I'm confusing myself just typing this). This way seems like more work than is necessary.

If anyone out there has any insight, I would be grateful!

Greendad

**Greendad** · 09-13-2013, 07:12 PM

No it's NOT Phish.

**FDibbins** · 09-13-2013, 07:21 PM

Hi and welcome to the forum

If your list has no gaps in it, then as you type, excel will try to "auto-complete" for you, based on what has already been entered above

**Greendad** · 09-13-2013, 07:55 PM

Hello FDibbins. Thanks for the reply. The "auto-complete" I understand.

I guess my main question is what is the best way to input the data into Excel?

One variable is the concert which I would distinguish by a date, and the other is the content of said show. If I list all shows, with all of the content I will eventually be including multiple "Song A's", "Song B's", etc. into my list. What I thought might work better is to list the first concerts content in column A, and have the date of that concert in column B. Then when I enter that data from concert #2, if there is a duplicate song, I would NOT re-enter the song again in column A, but list the date in column C that corresponds to hearing that song.

I just am unsure of what makes the most sense to do, using Excel, when the main end result is to have it calculate the number of times each song was heard, and possibly list what "shows" or "dates".

Thanks again!
Greendad

**FDibbins** · 09-13-2013, 10:38 PM

A different approach might be to have all the songs listed in A, and then in row 1 have the dates, creating a table. You could then just put a check mark (or any indicator really) when song A was played on a certain date.

You could use column B to run a total for you for each song =counta(C2:GR2) This will give you 200 dates - you can extend if you feel you need to.

My reason for putting the names in a column instead of a row, is you can have column A 100 characters wide if you want, and keep the date columns smaller - and using "Freeze Panes" will keep the titles and songs visible all the time.

**Greendad** · 09-14-2013, 02:48 PM

Thanks FDibbins. I also conferred with a friend who has some excel experience, and my thoughts, your thoughts, and his thoughts all align. I will try it that way!

Thanks!