This spreadsheet template was used for a project that had 300 hours of originally shot footage and a team of interns and Assistants were to log them. So this was used to organize their work and create priorities and keep organized outside of our editing software. We were using Avid. I’m not sure this is always useful, as usually you can see in Avid, but when you can’t keep up with what’s shot and priorities change, it can be useful to have something like this to sort through in a big documentary project.

There are 5 Tabs

Avid Bin Progress

This tab is to make sure shoot footage is processed and synched.

Shoot Day Log

This contains a description of what was shot for each shoot day.

Scene List

This is a list of possible scenes that could be cut from the footage

Log Process

This is a list of sequences that have been logged
It also shows how much footage has been shot in the project.

Transcriptions

This is a list to show the process of Transcriptions and Translations.