Apr 8

In-depth, intelligible EDL-like spreadsheets for FCP7

  1. Duplicate your sequence.
  2. Collapse all archival media (NB: This is important because we only want what is used in the cut, nothing more)
  3. Delete all archival audio that is synced/equal length to its video. If there’s an audio only section, keep one mono or stereo track of it.
  4. If all archival has ARC in its clip name, you can double check your work by going to the head of the sequence and do “search next” for “ARC”.
  5. Use Sequence Clip Reporter to generate the excel spreadsheet.
  6. Add filter to all columns. Filter the Source File path column to “contains” arch (assuming all your archival is in a file apth contains “arch”)
  7. Select all → Copy → New sheet → Paste
  8. Sort by Source (far right). Delete everything that isn’t archival
  9. Optional: You’ll notice some Column headers letters are in blue – that means there are some hidden columns. To make them visible and to delete unnecessary ones, select the first blue column to the last one. Resize one of them to about an inch. All columns will resize themselves and you can delete the unnecessary ones.
  10. Add (or replace) a column labeled “Type”. Since you’re still organized by Source path, you can easily select all stills and type in Stills, then select all video assets and type in Video.
  11. Sort by Sequence in. Done.
  12. Note 1: If for example you’re working in a 23.98 sequence with 29.97 footage, there will be discrepancies between the sequence duration and source duration. Same thing if there are any speed changes applied to the video.

    Note 2: Sequence Clip Reporter allows you to generate a sheet with all text elements. This is useful if there are placeholders. You can filter out in excel all placeholders contains the words “archival” and/or “Temp” to incorporate in the master archival spreadsheet. Additionally, if the text is an overlay, it will have the same TC in and out as a bit of archive. By doing conditional formatting, you can ask excel to highlight duplicate values in the Sequence IN column.

Tags: , ,


Comments are closed.