
Creating a Excel sheet to select time based data
- or -
Post a project like this17
€100(approx. $115)
- Posted:
- Proposals: 28
- Remote
- #4515141
- Awarded
⭐ TOP CERT Graphic Designer ⭐| Expert 2D/3D Render | Video Animator | Web Developer |Logo Designer |Graphic Animations | Video Editor ||Illustration.




Freelance Technology Consultant & Software Developer – Web, Mobile & Cloud Solutions

Video Editor | Graphic Designer | Motion Graphics & Animation Expert | Adobe Premiere Pro, After Effects & Illustrator Specialist

10936431948732413343348117423313421694115751601172949141195010548737260836906247811668267
Description
Experience Level: Entry
In attachment you find 2 files: script of original recording.xlsx and used video.edl
In script of original recording.xlsx the first colum "name" is not relevant and can be removed.
Colum "Start time" and "End time" refer to the "time of day" timecode of the originale footage. This format is hour:minutes:seconds:frames. The frame can be deleted so the time data is easier to work with in Exel and is irrelevant. The same goes for the time data of the file used video.edl.
The file used video.edl gives the time code of the used video in the final edit.
In the file script of original recording.xlsx and used video.edl in colum "text" you find the spoken text of the recording. What I need is a Exel sheet of only the used text blocks with the original time of day time code. The file "edit script with worng time code.xlsx" is generated by Adobe premiere but the original time of day timecode is lost. The time info shown is of the new timeline, no use to me. So I sugest you create a Exel sheet with on page 1 I can paste the original script, on page 2 I paste the edl and on page 3 I find the used text blocks with the the original time of day code. Keep in mind that not all text blocks may be used complete. This is no problem if ther is some overspill.
In script of original recording.xlsx the first colum "name" is not relevant and can be removed.
Colum "Start time" and "End time" refer to the "time of day" timecode of the originale footage. This format is hour:minutes:seconds:frames. The frame can be deleted so the time data is easier to work with in Exel and is irrelevant. The same goes for the time data of the file used video.edl.
The file used video.edl gives the time code of the used video in the final edit.
In the file script of original recording.xlsx and used video.edl in colum "text" you find the spoken text of the recording. What I need is a Exel sheet of only the used text blocks with the original time of day time code. The file "edit script with worng time code.xlsx" is generated by Adobe premiere but the original time of day timecode is lost. The time info shown is of the new timeline, no use to me. So I sugest you create a Exel sheet with on page 1 I can paste the original script, on page 2 I paste the edl and on page 3 I find the used text blocks with the the original time of day code. Keep in mind that not all text blocks may be used complete. This is no problem if ther is some overspill.
Bart S.
100% (77)Projects Completed
88
Freelancers worked with
81
Projects awarded
74%
Last project
15 Aug 2026
Belgium
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-

Could you upload the two source files so I can confirm the exact column structure and EDL format before building the Excel template?
1160447
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies