I’ve been working on several long-term, multi-song recording projects over the last year, a couple of which are my own and one of which is with a band I play in. I have multiple songs on my main recording drive from the various projects, and have been somewhat frustrated by my scattershot approach to trying to finish them up. Some of the songs are in the arranging stage, some in the tracking stage, and some in the mixing stage.
I finally realized that the problem is that I don’t have a simple way to check the status of the various songs at a glance. Until now, I’ve mainly relied on my memory to decide which song to work on and it hasn’t been a very efficient way to go. I did try making a master list of the songs in a notepad program, but it didn’t seem to help all that much. Since these are all long-term projects without fixed deadlines, I’ve been kind of chipping away haphazardly at the various projects, and haven’t felt like I’ve been using the limited time I have to spend in my studio very efficiently.
It occurred to me that a spreadsheet would be a good way to track the progress and status of the various projects and songs, and really keep on top of it, so I designed a simple one. Okay, this is definitely not rocket science, and I probably should have thought of this a long time ago (duh), but I can see already that it’s going to be enormously helpful.
Using Excel, I set up columns for Project Name, Song Title, Last Opened, Status, Drive/File Name, Notes (I made that column really wide) and Backup. For my purposes, I think that should suffice. Of course, the great thing about a spreadsheet is it’s totally flexible, and you can easily change the format if you find that it’s not totally working for you.
Anyway, I thought I’d throw the idea of this status form out there, in case it’s useful to anybody. If anyone can think of other generic columns that might be useful, feel free to add a comment. If you click on this image, it will open up larger and you can see how I set up the sheet.





















You need to be a member of Home Recording to add comments!