Friday, September 12, 2014

Re: [Avid-L2] sum of clip times in bin/project

 

I ended up exporting a tab delimited file. I had many duplicate clips for some reason. Then used Excel to get rid of the dupes. Then used Text wrangler to move the frames (final :xx) in each cell, to another cell, since Excel can't add frames properly. Then summed the time column as a duration. That gave me about 60 hours. and then added the frame column as straight numeric, dividing by 24 to get seconds and by 60 to get minutes. 


I then double checked with some rough math:
30 days of shooting at approximately 6 RED cards per day would be about 180 cards.
I added up the cards as well and got 185. Our biggest day we shot 10 cards, our shortest days we shot 4. Usually running 2 cameras. Sometimes 3. Sometimes only 1.

I'm not sure the size of the cards - thinking they were 64s. We shot 4K most of the time but also some 5K. Did very little shooting at 48fps or 36fps. Mostly 24fps. So does about 20 minutes per card sound right? If so, the MAXIMUM time we could have gotten out of 185 cards would be about 61hours and 40 minutes.

The spread sheet summed up to just under 59 hours. So that tells me that the math is correct.

Steve


On Sep 12, 2014, at 10:59 PM, Jay Mahavier jay_mahavier@earthlink.net [Avid-L2] <Avid-L2@yahoogroups.com> wrote:

 

Note, the last time I used that it will not calculate over 24 hours and rolls back to 00:.  So while you may have 50 hours of material it will display as 02:xx:xx:xx.  The footage rolls over at 100000.  So you do a few chunks of clips to get the proper count.


Jay

On Sep 12, 2014, at 9:19 PM, Benjamin Hershleder Ben@ContactBen.com [Avid-L2] <Avid-L2@yahoogroups.com> wrote:






Hi Steve,
Is this what you're looking for:

Select clips in bin.
Right-Click.
Get Bin Info.
Console opens:
<from-Avid-Media-Composer-Cookbook.png>

Cheers,
Benjamin
----
Benjamin Hershleder



On Sep 12, 2014, at 6:44 PM, Steve Hullfish steve4lists@veralith.com [Avid-L2] <Avid-L2@yahoogroups.com> wrote:

So, I'm interested in knowing how much footage I have in a project I'm working on.

Of course, I have subclips and audio files that are in addition to the video files (dual system sound)

I went to the Media Tool and created a master clip list of JUST the video master clips.

Is there a way to sum the DURATION?

I tried exporting that as a TAB DELIMITED file and taking it to Excel.

But then you've got a column for FRAMES that Excel doesn't know how to convert to 24 fps/seconds.

Is there a Console command I can run on a bin or a some other way to come up with a footage number?

You used to be able to do a get info on a bin and it would sum up the time.

Steve Hullfish

__._,_.








__._,_.___

Posted by: Steve Hullfish <steve4lists@veralith.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)

Check out the automatic photo album with 1 photo(s) from this topic.
from-Avid-Media-Composer-Cookbook.png


.

__,_._,___

No comments:

Post a Comment