As the concerts mount, and the post-production stuff builds I thought I’d take a minute and show the production spread sheet that I’ve been using to keep on track. It is pretty simple, but allows me to see exactly where I am in the process as I move from recording (step 1) to mixing/basic editing (step 2) to album editing* (step 3) to mastering (step 4) and then steps 5, 6, and 7 are export, upload to server, and backing up all files.
I’ve simplified it a little bit where mixing basically includes the album editing and mastering steps. Using conditional formatting in Google Sheets (or excel) allows me to have different colored cells depending on the information in them. Useful as the amount of data grows. So here’s the Production Spreadsheet:
For example on the CO1: Piano Quartet and Quintet concert I am currently (as I write this) uploading the files. Once that is done I’ll manually back up everything to a second hard drive. Then type “complete” into those two cells.
*album edit: This is the term I use to set up all the in and out fades for each track. It is the little details like how long a fade out is and what the slope of that curve is, or how I deal with clapping that is overwhelming the levels of the actual performance. It’s sort of a combination of mixing and editing, and my feeling is that the nose and tail of every export/track are important to making the listening experience feel good.