Originally Posted by Matt Finley
That looks good, Steve.

The advantage of a database is that you can query by more than one column if you want.

Example: Do I have any songs where Adele is singing reggae at a tempo less than 100?
No doubt, relational databases have advantages over spreadsheets (and vice versa).

This screen shot shows how I would do this if I were gigging on stage.
The spreadsheet would have 6 individual tabs, one for each sort parameter; Index, Song Name . . . Genre and the sorting would be done at home. I wouldn't want to fiddle with sorting or programming inbetween songs on stage; too many things can go wrong.

Then I'd have a backup of the spreadsheet on a thumbdrive in my pocket.

Finally, for belts and suspenders, I'd print each of the spreadsheet tabs, punch them and place them in a 3-ring binder with the 6 [physical] tabs labeled from above. If required additional hard copies could be made for the venue manager and band mates so everyone has the same info. And no worries if a B&W printer is used because the sort parameters are all bold.

Icing on the cake is Excel is relatively easy to use and because of it's popularity, there are tons of people available to help if problems happen. Plus it's a snap to communicate online what your spreadsheet looks like as I have done here . . . just my 2 cents plus a nickel.

Attached Files (Click to download or enlarge) (Only available when you are logged in)
Screenshot 14.jpg (292.61 KB, 78 downloads)
https://soundcloud.com/user-646279677
BiaB 2025 Windows
For me there’s no better place in the band than to have one leg in the harmony world and the other in the percussive. Thank you Paul Tutmarc and Leo Fender.