This report shows in-depth information about the translations, revisions and comments performed within a project or a job.
Create from Translation Editor
This report is created in the Translation Editor from the "Export" menu option. Make sure to open the editor from a project or a job. The report cannot be generated for translation memories or term bases.
A manager-level user can then select this report template and any customized versions you may have added.
A user who is not given the right to access all projects will not be able to create such reports.
Create from business Reports page
When creating a report from My Company > Reports, it will select a random document. Therefore, we advise you to test your report directly from the Translation Editor.
Template
Screenshot of sample template:
The template uses multiple named regions. You can view and edit them by clicking the Name Manager button on the ribbon:
The regions are:
-
__Segments__ : Row(s) containing a segment with source text, translation, identifier, status etc.
-
__Revisions__ : Optional for printing all past revisions of a segment. This range must be included within the __Segments__ range.
-
__Comments__ : Optional for printing all comments attached to translations of a segment. This range must be included within the __Segments__ range.
-
__DocumentComments__ : Optional for printing all document-level comments. This range must not be included in any other range.
Click here for more details on table ranges.
Global placeholders
Placeholders can be placed in any location in the Excel file and their properties apply to the whole report.
|
Placeholder name |
Description |
|---|---|
|
<#GeneratedDate> |
The date when the report was generated. |
|
<#ProjectReference> |
The project reference |
|
<#ProjectManager> |
The project manager name, if any |
|
<#DocumentName> |
The document name/reference |
|
<#SourceLocale> |
The source locale code |
|
<#SourceLocaleName> |
The source language name |
|
<#TargetLocale> |
The target locale code |
|
<#TargetLocaleName> |
The target language name |
Segments properties
The report must contain a __Segments__ named range. It will be cloned for each segment printed. See dotted lines below.
|
Placeholder name |
Description |
|---|---|
|
<#Segments.SegmentNumber> |
The segment's number such as: 1, 2, 3-1, 3-2 as shown in the translation editor. |
|
<#Segments.SequentialId> |
A sequential number of the segments starting at 1. |
|
<#Segments.SourceText> |
The text of the source language. |
|
<#Segments.SourceTextWithoutTags> |
The source text without tags. |
|
<#Segments.Repetition> |
Prints "*" if segment is a repetition, otherwise prints nothing/blank. |
|
<#Segments.TargetText> |
The translation. |
|
<#Segments.TargetTextWithoutTags> |
The translation Without Tags. |
|
<#Segments.Date> |
Date of last change of translation. When using this field make sure to set the Excel cell format to "Date" |
|
<#Segments.DateTitle> |
String version of the date of the target text. The Excel cell format can be set to "Text". |
|
<#Segments.Editor> |
A numeric value. Identifies the origin of last edit for the text of the target language, such as pre-translation, human edit... Use this numeric value with conditional formatting in Excel. For example, color a translation green if it is a pre-translation. |
|
<#Segments.EditorTitle> |
A friendly title of the Editor field above. It may for example contain "Fuzzy pre-translation" or "Machine translation". |
|
<#Segments.TaskCode> |
If the translation was last edited in the context of a job then the task code was saved. This field may contain codes such as "TR" or "PROOF". |
|
<#Segments.TaskName> |
A friendly title of the task code: "Translation", "Revision"... for the target text. |
|
<#Segments.CompanyName> |
If the translation was last edited by a human then this field contains the person's company name. |
|
<#Segments.PersonName> |
If the translation was last edited by a human then this field contains the person's first and last name. |
|
<#Segments.TargetLocale> |
The target locale. |
|
<#Segments.TargetLocaleAbbr> |
The target locale abbreviated for example: "en-US" |
|
<#Segments.SourceDate> |
Date of last change of the text of the source language. When using this field make sure to set the Excel cell format to "Date" |
|
<#Segments.SourceDateTitle> |
String version of the date of the source text. The Excel cell format can be set to "Text". |
|
<#Segments.SourceTaskCode> |
If the text of the source language was last edited in the context of a job then the task code was saved. This field may contain codes such as "TR" or "PROOF". |
|
<#Segments.SourceTaskName> |
A friendly title of the task code: "Translation", "Revision"... for the source text. |
|
<#Segments.SourceCompanyName> |
If the text of the source language was last edited by a human then this field contains the person's company name. |
|
<#Segments.SourcePersonName> |
If the text of the source language was last edited by a human then this field contains the person's first and last name. |
|
<#Segments.SourceEditor> |
A numeric value. Identifies the origin of last edit for the text of the source language, such as pre-translation, human edit... Use this numeric value with conditional formatting in Excel. For example, color a translation green if it is a pre-translation. |
|
<#Segments.SourceEditorTitle> |
A friendly title of the Editor field above. It may for example contain "Fuzzy pre-translation" or "Machine translation". |
|
<#Segments.SourceLocaleAbbr> |
The source locale abbreviated for example: "fr" |
|
<#Segments.EditsChars> |
Edit distance of the current translation in characters — how much the final text changed from the previous version. Blank if not recorded. |
|
<#Segments.EditsPercent> |
Edit distance of the current translation as a percentage of its length. Effort rate — can exceed 100%. |
|
<#Segments.EditsMTChars> |
Distance of the current translation from its machine-translation seed, in characters. Blank if the segment was not MT-seeded. |
|
<#Segments.EditsMTPercent> |
Distance from the MT seed as a percentage. Bounded 0–100%. Blank if not MT-seeded. |
|
<#Segments.MTSystemId> |
MT engine id for this segment's MT seed — a stable numeric key. Blank if not MT-seeded. |
|
<#Segments.MTSystemName> |
MT engine name for this segment's MT seed. Shows "(Deleted)" if the engine no longer exists. Blank if not MT-seeded. |
Revisions properties
The report may optionally contain a __Revisions__ named range to print the revision history. This range must be contained inside the __Segments__ range.
You can customize the report to add __SRevisions__ named range to show you revisions done in the source text. This range must be contained inside the __Segments__ range.
The place holders in __SRevisions__ are same as __Revisions__
|
Placeholder name |
Description |
|---|---|
|
<#Revisions.TargetText> |
The translation text of this revision. |
|
<#Revisions.TargetTextWithoutTags> |
The translation text of this revision without tags. |
|
<#Revisions.Date> |
Revision date. The Excel cell format can be set to "Text". |
|
<#Revisions.DateTitle> |
String version of the date. The Excel cell format can be set to "Text". |
|
<#Revisions.Editor> |
A numeric value. Identifies the origin of the revision, such as pre-translation, human edit... Use this numeric value with conditional formatting in Excel. For example, color a translation green if it is a pre-translation. |
|
<#Revisions.EditorTitle> |
A friendly title of the Editor field above. It may for example contain "Fuzzy pre-translation" or "Machine translation". |
|
<#Revisions.TaskCode> |
If this translation was edited in the context of a job then the task code was saved. This field may contain codes such as "TR" or "PROOF". |
|
<#Revisions.TaskName> |
A friendly title of the task code: "Translation", "Revision"... |
|
<#Revisions.CompanyName> |
If the translation was edited by a human then this field contains the person's company name. |
|
<#Revisions.PersonName> |
If the translation was edited by a human then this field contains the person's first and last name. |
|
<#Revisions.Locale> |
The locale of the text was revised. |
|
<#Revisions.LocaleAbbr> |
The locale abbreviated. |
|
<#Revisions.EditsChars> |
Edit distance this revision contributed, in characters. |
|
<#Revisions.EditsMTChars> |
Distance from the MT seed at this revision, in characters. Blank if the revision was not MT. |
|
<#Revisions.MTSystemId> |
MT engine id if this revision was machine translation — a stable numeric key. Blank otherwise. |
|
<#Revisions.MTSystemName> |
MT engine name if this revision was machine translation. Shows "(Deleted)" if the engine no longer exists. Blank otherwise. |
Comments properties
The report may optionally contain a __Comments__ named range to print all comments attached to a translation. This range must be contained inside the __Segments__ range.
You can customize the report to add __SComments__ named range to show you comments added in the source text. This range must be contained inside the __Segments__ range.
The place holders in __SComments__ are same as __Comments__
|
Placeholder name |
Description |
|---|---|
|
<#Comments.Text> |
The comment. |
|
<#Comments.Date> |
Date of comment. The Excel cell format can be set to "Text". |
|
<#Comments.DateTitle> |
String version of the date. The Excel cell format can be set to "Text". |
|
<#Comments.CompanyName> |
Company name of the person who last edited this comment. |
|
<#Comments.PersonName> |
First and last name of the person who last edited this comment. |
|
<#Comments.Locale> |
The locale of the text that had the comment. |
|
<#Comments.LocaleAbbr> |
The locale abbreviated. |
Document Comments properties
The report may optionally contain a __DocumentComments__ named range to print all comments attached to a translation. This range is not contained in any other range.
|
Placeholder name |
Description |
|---|---|
|
<#DocumentComments.Text> |
The comment. |
|
<#DocumentComments.Date> |
Date of comment. The Excel cell format can be set to "Text". |
|
<#DocumentComments.DateTitle> |
String version of the date. The Excel cell format can be set to "Text". |
|
<#DocumentComments.CompanyName> |
Company name of the person who last edited this comment. |
|
<#DocumentComments.PersonName> |
First and last name of the person who last edited this comment. |
|
<#DocumentComments.TaskCode> |
If this comment was added in the context of a job then the task code was saved. This field may contain codes such as "TR" or "PROOF". |
|
<#DocumentComments.TaskName> |
A friendly title of the task code: "Translation", "Revision"... |
|
<#DocumentComments.DocumentName> |
The name of the document. |