A spreadsheet for keeping track of “a tune a day” type progress.
If you’ve ever considered attempting the "learn a tune a day" thing, this might - MIGHT - be useful to you. I built it for myself, but it occurred to me others could find it useful.
The idea: you have a list of tunes and you assign them to days on which you want them to be "tune of the day", starting about a month from now.
You decide on a practice schedule for how often you want to practice the tune in the leadup to the day; I’ve split it into "practicing" and "memorising" days as I tend to tackle them as different things: this is obviously not compulsory.
The sheet then crunches all this and spits out a handy little list of the things you should be practicing today.
If you’d like to try using it, note that:
- it can’t be exported to Excel; there’s a function I use which Excel can’t (easily) duplicate. If this is really important to anyone I can fix it.
- the first date on the tunes tab is actually a formula - this is so that the sheet always "wakes up" with a current, working example. Change this if you use it for yourself.
- You should only need to edit the bits in yellow.
- You can change the day you’re looking at by editing the yellow box on the "Today" tab to be +1, -1, etc.
It’s pretty user unfriendly at the moment - any comments in this regard will be gratefully received and may or may not be fixed!
Have at it.