{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Standardised comments","General Guidelines","TAVF"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Standardised comments","index":0,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Sub-categories (ROUTING)","Intervention categories","Standardised comments","REVIEW? "]
["All OK","OK",null,"NO"]
["Informational","OK","Note: ... ","YES"]
["Guideline validation","OK","T&A guideline followed. ","NO"]
["Required adaptation","Adaptation issue","\"...\" requires an adaptation. Implemented by Ver ","YES"]
["Wrong adaptation","Adaptation issue","\"…\" was incorrectly adapted as \"…\" in target. Corrected by Ver. ","YES"]
["Added information","Added information","\"…\" added vs. source. Corrected by Ver. ","YES"]
["Item specific guideline not followed","Guideline not followed","\"…\" translated as \"…\". Corrected by Ver. ","YES"]
["Grammar issue (any)","Grammar, Syntax","Grammar/Syntax issue corrected by Ver. ","NO"]
["Inconsistent within/across QQ","Inconsistency","\"…\" translated inconsistently. Harmonised by Ver. ","NO"]
["Inconsistent with Trend","Inconsistency","\"…\" translated inconsistently with Trend items. Corrected by Ver. ","YES"]
["Inconsistent form of address","Inconsistency","Inconsistent form of address. Corrected by Ver. ","NO"]
["Formatting (bold, italics, tags, etc.)","Layout/Format issue","Formatting not as in source. Corrected by Ver. ","NO"]
["Untranslated text","Left in source language","\"…\" was left in source language.  Translated by Ver.","YES"]
["Mismatch Question/Response","Matches & Patterns","Mismatch between the question stem and the response options. ","YES"]
["Broken pattern","Matches & Patterns","Pattern in response options was not kept.","NO"]
["Typo, spelling, punctuation","Minor linguistic issue","Typo/Spelling/Punctuation corrected by Ver. ","NO"]
["Missing information","Missing information","\"…\" missing vs. source. Corrected by Ver. ","YES"]
["Mistranslation","Mistranslation","\"…\" translated as \"…\". Corrected by Ver. ","YES"]
["Register level","Register/Wording issue","Translation of \"...\" is of higher/lower register than  source.","NO"]
["Comprehension","Register/Wording issue","Unclear translation of \"…\". Changed by Ver. ","NO"]
["Fluency","Register/Wording issue","Unnatural  translation of \"…\". Changed by Ver. ","NO"]

{"sheet":"General Guidelines","index":1,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["GENERAL GUIDELINES"]
["\"TAVF\" tab","The segments that need to be translated are in \"TAVF\" tab of this document. That's where you will find Translation & Adaptation notes and where you will enter your comments."]
["Intervention category column","1) If the translation is fine and 2) there are no T&A notes in column D, you do not have to select any category. You can leave this column empty. Leave one comment in the cell G3 \"T&A guidelines are followed throughout.\""]
["Mode of administration","The survey data will be collected through Computer Assisted Telephone Interview."]
["Form of address","Target audience is adult population (see below). Make sure to use the most appropriate form of address."]
["Register","Target population is public at large (all people age 15+), living in European Union member states countries."]
["Gender","If needed, include both gender forms by following the typographic conventions (slashes, brackets, etc) of your language. Apply the approach consistently throughout the survey whenever needed."]
["Formatting","Make sure the formatting in terms of bold, underline, italics and ALL CAPS is reflected in the target. \nMake sure to run the QA checks in OmegaT to make sure all tags are correctly reproduced in the target. "]
["Match between question stem and response options and categories","In inflected languages repetitive response options and categories may need to be conjugated and/or declined differently depending on the questions stem they refer to. \nTranslation of response options and categories should match the questions stem grammatically. Even if the translation is retrieved from a previous question or auto-propagated, make sure that the responses / categories match grammatically with each question stem. If needed, use the \"alternative translation\" feature. "]
["Consistency","In so far as possible, make sure scales are consistently translated throughout.\nSame responses and qualifiers in English should have same translation if possible.\nSame or similar patterns of question stems in English should be observed as far as possible in translation.\nAll the above aspects need to be observed as far as they do not affect fluency, syntax or grammatical agreements in translation."]

{"sheet":"TAVF","index":2,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Eurobarometer Flash - Translation Adaptation Verification Form"]
["Seg #","ITEM ID","SOURCE VERSION (ENG)","Translation & Adaptation guidelines","TRANSLATOR COMMENT","INTERVENTION CATEGORY","VERIFIER COMMENT","Final target  version","MT BT of final version"]
["1","Q1","Do you think that, in your local area, people using or dealing drugs are a very serious problem, somewhat serious, not too serious, or not a problem at all?","\"a very serious problem, somewhat serious, not too serious, or not a problem at all\"-> should match with the response options.",null,"OK"]
["2","Q1","(ONE ANSWER ONLY)"]
["3","Q1._1","A very serious problem"]
["4","Q1._2","A somewhat serious problem"]
["5","Q1._3","Not too serious a problem"]
["6","Q1._4","Not a problem at all",null,"Translator added an alternative translation. \"are not a problem at all\", since it reffers to people (in plural).","OK"]
["7","Q1._998","Don't know (DO NOT READ OUT)"]
["8","Q2","Which of the following would you say are a problem in your local area associated with people using or dealing drugs?","\"which\" is plural.",null,"Mistranslation","\"dealing drugs\" translated as \"buying drudgs\". Corrected by Ver. "]
["9","Q2","(READ OUT; ONE ANSWER PER LINE)"]
["10","Q2.Q2_1","Drugs being too easily available",null,null,"Register/Wording issue","Unnatural  translation of \"available\". Changed by Ver. "]
["11","Q2.Q2_2","People taking hard drugs (e.g. crack, heroin, cocaine)"]
["12","Q2.Q2_3","People smoking cannabis in public places",null,null,"Minor linguistic issue","Punctuation corrected by Ver. "]
["13","Q2.Q2_4","Children and teenagers taking drugs"]