Production Clip Reporter creates an Excel spreadsheet report about the video clips, audio clips and markers you’ve used in your edited sequence or bins. The report includes sheets for:
- Clips
- Sequence Markers
- Clip Markers
- Graphics & Titles
- Transitions
- Video & Audio Effects
- Speed Change Effects
- Files Summary
You can choose which tracks of clips to include in the report, and Settings lets you choose whether times are reported as seconds (for easier spreadsheet calculations), frames, HH:MM:SS or HH:MM:SS:FF timecode format.
The app works with XML or OTIO exported from Adobe Premiere, Avid Media Composer or Blackmagic DaVinci Resolve.
Please use Email Support under the Help menu for bug reports, feature requests or support.
Loading your sequence into Production Clip Reporter
- Open your sequence/timeline if it isn’t already open.
- Export an XML or OTIO file of your sequence:
- In Premiere, choose the File menu and select Export > Final Cut Pro XML… or Export > OpenTimelineIO…
- In DaVinci Resolve, choose the File menu and select Export > Timeline…, then select to save either FCP 7 XML V5 Files (*.xml) or OTIO Files (*.otio) from the popup menu.
- In Media Composer, choose the Tools menu and select List Tool. Select Default OTIO as the Active Setting, and click the Load button. Click the Preview button, and once the OTIO is generated, click the Save List button.
- In Production Clip Reporter, click the Open file… button to open the exported file.
Analyzing your Sequence/Timeline
- In Production Clip Reporter the sequence or timeline is probably automatically analyzed for you. If not, choose the sequence you want to analyze from the Report popup menu, then click the Analyze button.
- Click the checkboxes ‘on’ for each video and audio track you want to include in the report.
- To leave out audio in clips that also contain video, click the Ignore audio in clips with video switch ‘on’.
- To add optional report sheets for markers, graphics & titles, transitions, effects or files summary, click appropriate switches ‘on’.
- Click the Save spreadsheet… button. Name and save the spreadsheet.
Clips Report
Lists the video and/or audio clips for the chosen tracks in order of their appearance (regardless of which track the clip is in). The report includes columns for: Thumbnail; Track; Clip Name; Enabled; Sequence In timecode; Sequence Out timecode; Clip Duration timecode; Source In timecode; Source Out timecode; Source Duration timecode; Description, Scene, Take; Frame Rate/Sample Rate; Source File Name; Source File Path.
Sequence Markers Report
Lists the sequence markers in order of their appearance. The report includes columns for: Marker Name; Color; Comment; Start timecode; End timecode; Duration.
Clip Markers Report
Lists the clip markers in order of their appearance (regardless of which track the clip is in). The report includes columns for: Marker Name; Color; Comment; Start timecode; End timecode; Duration; Track; Clip Name; Source Position timecode.
Graphics & Titles Report
Lists the generators in the chosen video tracks. The report includes columns for: Track; Clip Name; Generator; Sequence In timecode; Sequence Out timecode; Duration; Font; and the Title Text entered for the title.
Transitions Report
Lists a summary of the transitions in the chosen tracks. The report includes columns for: Track; Transition name; Sequence In timecode; Sequence Out timecode; and Duration.
Video & Audio Effects, Speed Change Effects Report
Lists the effects applied to video and audio clips for the chosen tracks. The report includes columns for: Effect name; Settings; Enabled; Clip Name; Track; Sequence In timecode; Sequence Out timecode.
Files Summary Report
Lists all the media files used in the sequence, the estimated total duration of material used from each file, and the percentage of total material used from each file. The report includes columns for File Name; Estimated Total; and % of Total; and File Path.
Filtering reports in Excel
Excel has powerful features for filtering a spreadsheet.
- In Excel, choose the Data menu, and from the Filter sub-menu select AutoFilter. A popup menu indicator is added to the headings of the frontmost sheet.
- To show only those rows where, say, Master Comment 1 is “Algonquin Hotel”, click the Master Comment 1 popup menu indicator and select Algonquin Hotel from the menu. The spreadsheet changes to show only those rows with Algonquin Hotel in the Master Comment 1 column.
- For more powerful filtering, choose Custom Filter… from the popup menu. The Custom AutoFilter dialog opens. (See Excel’s help topic “Filter a list of data” for more information.)
Settings
Choose the Production Clip Reporter menu and select Settings to open the Settings window.
Layouts
You can create Layouts for clip reports that include only the columns you have selected.
Click the “plus” button to name the new layout and add it to the popup menu, then turn on the checkboxes for the columns you want to include in the reports.
Click the “pencil” button to rename the layout; click the “minus” button to remove the layout.
The default layout is Standard, which cannot be renamed or removed.
You can choose to Add thumbnails at pre-set width or a custom width. The thumbnail image is created from the clip’s in point. Thumbnail images can only be created from AV Foundation-compatible media that is online. If the media is offline or incompatible, the thumbnail will be a “Missing” or “Unknown” graphic. Layouts that include a column for thumbnails will be significantly slower to create.
Tip: Production Clip Reporter supports more media types (via AV Foundation) if the free “Pro Video Formats” are installed from this search page. You can check if you have Pro Video Formats installed by choosing Help > Check for Pro Video Formats.
Time Display
You can choose whether times are reported as Frames, Feet+Frames (4-perf at 24 fps), HH:MM:SS, Seconds, or HH:MM:SS:FF timecode format (drop frame or non-drop frame timecode will be used depending on the clip or timeline setting), or a combination of these.
One or more time columns can be added to the report, and sequence times can be reported differently than source times.
For Sequence In and Sequence Out you can apply frame offsets to the reported times.
Text Colors
You can choose to have spreadsheet rows display as Colors or Black and White.
Updates
Use the Check at Launch checkbox to choose whether to automatically check for software updates. You can manually check for software updates by clicking the Check now button, or by choosing the Production Clip Reporter menu and selecting Check for Updates… Checking for software updates occurs only when you are connected to the internet.
The latest version of Production Clip Reporter can also be downloaded from any internet-connected computer by visiting www.IntelligentAssistance.com/downloads.