Each week, Frame.io Insider asks one among our knowledgeable contributors to share a tip, device, or approach that they use on a regular basis and couldn’t stay with out. This week, Chris Tennant exhibits us a fast and environment friendly strategy to create a timecode checklist spreadsheet in AVID Media Composer.
Generate a Spreadsheet with the Marker Device in Media Composer
In my position as an assistant editor, one among my main obligations is to create timecode spreadsheets from the timeline. That is performed primarily based on a wide range of wants, akin to ADR recognizing sheets, VFX conform notes, or editorial changelogs.
Fortuitously, there’s a fast and environment friendly strategy to accomplish this job by using markers in your timeline together with Media Composer’s Marker Device. By following the steps beneath, you may rapidly and simply generate a spreadsheet that incorporates all the required timecode and marker data, with out having to manually enter all the pieces.
- Open your timeline and ensure all locators are enabled and visual. If wanted, add descriptions to every marker. As an example, ADR markers ought to have every line of dialogue of their description fields, whereas VFX markers ought to include shot IDs and shot descriptions.
- Open the Marker Device by deciding on Instruments > Marker Device.
- Spotlight all markers within the timeline. Proper click on and choose Export Markers > Textual content.
- Save the output as a .txt file in an applicable listing.
Tidy your Timecode Record
When you ‘ve generated the spreadsheet, it’s time to tidy it up. Open the .txt file in your most well-liked spreadsheet editor, akin to Microsoft Excel or Google Sheets. It should possible include extra data than you want, so eradicate any irrelevant columns.
Usually, you’ll solely want the timecode and outline columns. Lastly, add any vital labels to the spreadsheet, such because the identify of your manufacturing and the date, and your timecode checklist is completed.
Insider Suggestions are useful weekly posts delivered to you by Body.io’s superior writers and trade specialists. Come again for a brand new Insider Tip each Wednesday, or subscribe to our newsletter to get a reminder every week.
In case you’re seeking to get extra out of your Body.io account, try Shawn McDaniel’s playlist on our YouTube channel.
