There's a bunch of excel timecode to frame calcs on the web - create three new fields and convert the in and out time to frames, in the third field subtract the in from the out to get a duration.
Now create two new fields for in and out field counts. In the first row enter 1 in the record in field. Make the out field = record in plus the duration calculation from earlier.
In the next row make record in = record out. Now extend those two calculations down the whole list.
Lastly create two fields for record in and out timecode and use the web calcs to convert frames to timecode.
Simply reference these last two columns into your supplied excel doc.
Done.
Best regards
Mike
On 27 Jun 2015, at 1:46 am, Jay Mahavier jay_mahavier@earthlink.net [Avid-L2] <Avid-L2@yahoogroups.com> wrote:
I was sent a pull list in a Excel sheet. Typical sort of thing. First column is the file name of the camera master, followed by a second column in an in-point TC, and then a third column with the out-point TC. There is no Record side in/out, just source side. So I usually just go through by hand and pull the clips. No big deal because there is usual a dozen or so clips to pull. Well, this pull list is 300 events long. Ugh. Is there an easy (less painful than what I'm already doing) way to convert this Excel pull list to an EDL that I can import and link to my camera masters? This would make it so much easier. Thank you for any help you can provide.
Thank you again,
Jay
__._,_.___
Posted by: "Mikeparsons.tv" <mikeparsons.tv@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
this is the Avid-L2
.
__,_._,___
No comments:
Post a Comment