Creating Film Dialogue List for Subtitles

I've finally finished the dialog list for MindFlesh. Not that it should have taken very long to do but it's just a dull job so I kept doing other things in between! :)

I thought other filmmakers might be interested to see how my spotting list is formated. I can't remember how I got hold of the format but it's one we've used for London Voodoo (and sold successfully around the world and now on Amazon Unboxed!) so I'm hoping it's still good for MindFlesh. Click the thumbnail below for a snapshot of the sample output.

If you right-click and "save as" on this link. You can download the Excel spreadsheet I used to create it. The idea is you can quickly and easily enter the timecode & dialog on the INPUT sheet ( it's quick because you don't have to worry about formatting) and then the OUTPUT sheet is what you print.

One small thing to note is that I've made the formulas as simple as possible so when a timecode flips over a minute (e.g. start 1:59 and end 2:01) you'll get a negative duration - just do the math yourself and over type the formula. It's much quicker this way than having to code (end_hour*3600+end_mins*60+end_secs)-(start_hour*3600+start_mins*60+start_secs).