I gang

Write some Software

We need an excel template or Word macro that can calculate using timecode. We are building Post Production scripts that list in a word doc the IN timecode and the OUT timecode in separate columns, and we are required to enter the DURATION of the shot in a separate column. As you can imagine, manually entering this information into a timecode calculator and then typing the resulting duration back into the Word doc is too time consuming. We also have to do offsets, where, for example, if there is an increase of length in ad breaks between an International and Local version of a TV program, we need to add, say 37 seconds to the timecodes after the first ad break, and so on.

Perhaps easiest is a page in excel that we can cut and paste the timecode IN column into and then the timecode OUT column from our Word post production script, the excel page does the duration calculation and then we can cut and paste the duration back into the Word doc. It would have to be the whole timecode (eg 10:00:10:01) including frames in the one cell, or it will take too long to enter the information. In the case of the offset, we would just duplicate 'add 37 seconds' and cut and paste the new timecodes into our Word doc. But if there is a way working directly into Word eg using a calculation macro, AND YOU CAN EXPLAIN to us how to use it clearly (as we are not geeks!) that would be great too.

We are using PAL 25 frames for Australian television. Whatever supplied would have to work the same on pc and Mac. We need quotes on this job asap because there is a tight deadline to finish these post production scripts. Please only quote if you have an understanding of PAL timecode. Thank you.

Færdigheder: PHP, Software Arkitektur

Se mere: television script, excel frames, calculator architecture, calculate write, architecture calculator, ad international, php calculator scripts, write typing, increase page software, excel timecode script, excel macro add, software increase page, write macro, timecode, excel mac add, write shot, excel 2014 macro, excel add mac, mac excel macro, mac excel add, timecode excel, excel calculation macro, add excel macro, software typing job, software increase

Om arbejdsgiveren:
( 1 bedømmelse ) Leederville, Australia

Projekt-ID: #6055255

Tildelt til:

petrovp

Good day, I can write an Excel macro which would calculate the duration based on 2 columns which you copy from Word. Could you provide an example data?

$30 AUD in 3 dage
(8 bedømmelser)
2.8

6 freelancere byder i gennemsnit $128 for dette job

prashushinde9

Hi, I (Myself a senior PHP, [url removed, login to view] programmer using C# and VB) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bu Mere

$257 AUD in 10 dage
(13 bedømmelser)
5.0
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 210 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Mere

$150 AUD in 8 dage
(36 bedømmelser)
4.8
Time2win

Hello, We have excellent team of programmers and designers to work on your project efficiently and complete job in time. We have read your deepest requirement at our best and will surely give better results. thanks

$263 AUD in 10 dage
(11 bedømmelser)
4.2
xcodejok

please check our company freelancer profile [url removed, login to view] we already developed this type of project so we can take your project. why you hire us ? have 5*** with 100% complete rate with we Mere

$140 AUD in 7 dage
(10 bedømmelser)
3.3
Nasatya

A proposal has not yet been provided

$122 AUD in 3 dage
(0 bedømmelser)
0.0
aleksamarkoni

Hello there, can you pls send some example word doc so I can test the data and see is it best to do it directly into the word or is it better to do excel thing you mentioned. P.S. This is not php related, so pl Mere

$100 AUD in 3 dage
(0 bedømmelser)
0.0
bubydragos

Dear Sir/Madam, First of all, thank you for the opportunity offered to us, freelancers, and for the time taken to review my application. I am computer science graduate, with more than 3 years experience in programmi Mere

$106 AUD in 4 dage
(0 bedømmelser)
0.0