Kenny Roy asked me to contribute some anecdotes for a presentation he’s putting on, and I thought it would be a good idea to share them here. Tracking Production I’m a keen addict of a good Excel spreadsheet that tracks the progress of each project. My short film was no different and over time I was able to show the progress of each department across the duration of the film. I let Excel save out an image of two charts that were then synced to a public folder on Dropbox. The first just showed the progress level in the main categories  It was published to our development website and quickly allowed anyone to see how far we were. It was also embedded into the beginning of the animatic edit. The image simply overwrote each time I saved so it was always up to date and showed up in each export of the animatic that I published about once every two weeks. The second graph showed the progress over time. This was very useful as we could aim for a date and see roughly when departments were getting behind. It allowed me to respond by changing assignments, recruiting more or less in each skill […]