TEDx talks translation/transcription tracking spreadsheet - Self-updating

From TED Translators Wiki
Revision as of 10:14, 6 January 2016 by Snai (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Why track translation/transcription progress on Amara?

There tens of thousands of TEDx talks available for transcription and translation, alongside TED-Ed and TED talks. A 15-minute talk means about 20 hours of work in total, with 6 steps to complete on the way. There are no tools to monitor the process except for the slow "search" option in Amara and looking at each talk individually. To encourage volunteers to get things done we need more control of the pipeline and clear priorities.

Our tool to track the progress:

The spreadsheet self-updates on your request after you have input all the relevant data.

I want one for my team!


Here is the link to the TEMPLATE which you can copy for your team.

Please follow the instructions from the spreadsheet or continue reading.


What to do to make it work for my language combination and change it?

If the spreadsheet does not work go to:

Tools -> Script editor

in the menu and then:

search (CTRL + R) for instances of "pl" and replace them with the short code for your language. (DO NOT REPLACE ALL, PL is a common letter combination and the script will stop working if you click replace all)

You should see something like this, where you have to replace the language codes:


// orgLang <- column OL (pl/en)
    var orgLang = row[6].toLowerCase();
    //Set targetLang
    var targetLang;
    if (orgLang=="pl") {
      targetLang = "en";
    } else {
      targetLang = "es";


// orgLang <- column OL (ru/en)
    var orgLang = row[6].toLowerCase();
    //Set targetLang
    var targetLang;
    if (orgLang=="ru") {
      targetLang = "en";
    } else {
      targetLang = "es";

Remember to save with the floppy icon :))

How to add your events and talks:

1. Add your event as a sheet ONLY if it had live speakers. Do it by duplicating the Template sheet. Rename it to YEAR EVENT_NAME

2. List the talks providing the name & title as well as a short description in the appropriate columns (as a note) length in minutes and the language the talk was given in

3. Do not change the status of tasks! Having uploaded the videos to YouTube does not necessarily mean that the first task is open (unassigned) on Amara

4. One member of your team will have to sign up to Amara and join the TED team - HOW to HERE

5. You will have to find the talk on Amara and copy the link to the talk and the video ID (eg eRXCUzl1f2Dt) from the link to the appropriate columns

6. Make sure the talk is on Amara is part of the TED team there! If it is not, add it here.