That said, the hardest (read; most boring, tedious, time-consuming) part of my job is updating the spreadsheets. When I had an assistant it was easier but now that I’m a one woman operation I have to actually update all of the spreadsheets myself. And as I update the spreadsheets, I get crazy ideas about new spreadsheets to keep track of more specific pieces of information and it all just snowballs until I look at the clock and realize I haven’t even started to cut today’s video.
The strangest part? I have no idea how to properly use Excel. Our HR/Accounting super-hero has to set everything up for me. And then I ask her to do crazy impossible things like “Count all the videos that have an embed code and no edited on date” and she can actually show me how to do it. I am starting to suspect that Excel runs on some sort of magic.
That’s the glamorous life of a repair video producer. My mornings are spent emailing, meeting, thinking, reviewing, spread-sheeting (it’s a verb now) and occasionally script-writing. My afternoons are spent in the glorious realm of editing where time does not exist (video editors know exactly what I mean). None of this would be possible without my spreadsheets. I would be completely lost and have no way of finding myself without them.
One of these days I will actually learn how to use them.