The Mudcat Café TM
Thread #24777   Message #287407
Posted By: Tiger
29-Aug-00 - 06:23 PM
Thread Name: Managing a repertoire held in memory
Subject: RE: Managing a repertoire held in memory
Naturally, as a computer geek, my list is automated. My basic songlist (750 songs) looks like this:

yodel11 bluey11 rod x Blue Yodel No. 11 Jimmie Rodgers
X T bobbitt bob pax Cm (A3) x Bobbitt Tom Paxton
XI boldthad bol clancyb C x Bold Thady Quill Clancy Brothers
bootleg boo garn x The Bootlegger's Lament Bill Garneau
X TG bottle bot pax A x Bottle Of Wine Tom Paxton
X TG boxer box sim C x The Boxer Simon & Garfunkel
boysue boy cash x A Boy Named Sue Johnny Cash

X = on my short list
ITG = on various gig sheets
followed by:
word file name
song name alpha sort key
performer alpha sort key
preferred key (capo position)
x = I have the lyrics
song name
performer

The X column generates a one-page five-column shortlist (about 250 songs) - all the songs I should be able to do on demand (like the 1-list, from above). I can put this on the table or floor in front of me, like a cue card.It looks like this:

A abdul A guns D ilullaby D clock D(C2) london
C adelita C dontthin C irover A myheroes G sugarbab
C dream C=>A dreamlit A island C hometown B(G4) wages

The other tags generate one-column gig sheets (20 or so songs) I can stick on my guitar, songs I've picked for the family Thanksgiving (T), St. Patrick's Party (I), etc. Just mnemonic clues and keys.

F(D3) darcy
A guns
C=>A dreamlit
D elpaso
A fourwall
A(G2) frankmil
C grace

The whole mess is in one Excel workbook with macros to generate the various formats. I'll be happy to share it with anyone who'd like one.