Project data report fields
The project data report is an *.xlsx file consisting of several tabs: Dashboard, Projects, Languages, Files, Costs, Attributes, Reviewers, CostBands. This topic provides definitions for all the available tabs and their fields.
Dashboard
The Dashboard tab presents an overview of the work done, during the selected period.
- Words = number of translated words from all the projects in the selected period
- Projects = number of projects completed in the selected period
- Files = number of translated files from all the projects in the selected period
- Total Spend = cost of all the projects in the selected period
- Total Savings = savings from all the projects in the selected period as a result of using RWS technology and TM leverage
- Currency = most common currency across all the projects in the selected period
Projects
The Projects tab presents aggregated information about projects, for the selected period.
- Project Name = name of the project as entered by project creator
- Project Group Name = name of the project group where the project resides; if project is not associated with a project group, the column is empty
- Project Description = description of the project as provided by the project creator in the Project Description field during project creation; if no description is provided, the column is populated with the project name
- Project Template = name of the project template based on which the project was created
- Provider Project ID = project internal ID generated automatically by the system
- Authorized Date = project approval date
- Translation Vendor = name of the vendor contracted to perform the translation
- Connector = name of the connector used to submit the project for translation
- Location = name of the folder (customer folder) where the project is saved
- Created By = name of the user who created the project or empty value if project is created via a connector integration
- Created Date = date when the project was created
- Requested Delivery Date = initial delivery date of the project, as specified by project creator
- Actual Delivery Date = actual date when the project was delivered
- Estimated Duration = estimated project duration in days
- Estimated Delivery Date = estimated delivery date of the project, as specified by project manager
- Project Status = status of the project
- Percentage of Project Delivered = [(number of completed target files) / (number of total target files)]
- Total Words = [(number of source words) x (target languages)]
- TM Leverage = [100 - (new words * 100 / word count)] at project level
- Project Cost = project quote
- Cost Savings = [(total words cost) x (new words cost) - (actual cost)] per project
- Currency = currency used to calculate the project quote
- Project Type = project created by a human (Manual) or project created via an integration connector (Automatic)
- Source Language Code = ISO code of source language
- Source Language = full name of source language
- Languages = Number of target languages in a project
- Number of Files = number of source files
- Source Words = number of words from all the translatable files in a project
- Repeated Words = number of repeated words from all the translatable files in a project
- Perfectly Matched Words = number of words which are perfectly matched against previous translations in the TM
- Fully Matched Words = number of words which are perfectly matched against previous translations and which are also fully matched in terms of the surrounding context in the TM
- Fuzzy Matched Words = number of words which have various degrees of translation accuracy in the TM
- New Words = number of words which have no translation in the TM
- Locked Words = number of words which must not be translated
- Project ID = project internal ID generated automatically by the system
- Project Group ID = project group internal ID generated automatically by the system
Languages
The Languages tab presents aggregated information about the translation work across all target languages, for the selected period.
- Project Name = name of the project as entered by project creator
- Source Language Name = full name of source language
- Source Language Code = ISO code of source language
- Language Name = full name of target language
- Language Code = ISO code of target language
- Number of Files = number of source files
- Total Words = [(number of source words) x (target languages)]
- Repeated Words = number of repeated words from all the translatable files in a project
- Perfectly Matched Words = number of words which are perfectly matched against previous translations in the TM
- Fully Matched Words = number of words which are perfectly matched against previous translations and which are also fully matched in terms of the surrounding context in the TM
- Fuzzy Matched Words = number of words which have various degrees of translation accuracy in the TM
- New Words = number of words which have no translation in the TM
- Locked Words = number of words which must not be translated
- TM Leverage = [100 - (new words * 100 / word count)] at language level
- Cost Savings = [(total words cost) x (new words cost) - (actual cost)] per language
- Language Cost = translation cost for a language pair
- Currency = currency used to calculate the project quote
- Percentage Complete = value of 1 (if all target files from a target language are ready for download) or 0 (otherwise)
- Project ID = project internal ID generated automatically by the system
Files
The Files tab presents aggregated information about all the files that are in translation, during the selected period.
- Project Name = name of the project as entered by project creator
- Provider Task ID = target file ID generated automatically by the system
- Language Name = full name of target language
- Language Code = ISO code of target language
- File Name = name of file formatted as follows:
[directory]/[folder]/[file_name].[extension] - File Format = BCM value (if file is currently being processed or translated) or Native (if file translated)
- Status = status of the file (Preparing, For Approval, In Progress, In Finalization, For Download)
- Workflow Step = name of the workflow task processing the file at the time of the report download
- Reviewers = Customer Reviewers
- Review Deadline = deadline date of the Customer Review task
- Review Started = start date of the Customer Review task
- Review Ended = end date of the Customer Review task
- Signoff User = column always empty for Trados Team integrations
- Signoff Deadline = column always empty for Trados Team integrations
- Signoff Started = column always empty for Trados Team integrations
- Signoff Ended = column always empty for Trados Team integrations
- Total Words = [(number of source words) x (target languages)]
- Repeated Words = number of repeated words from all the translatable files in a project
- Perfectly Matched Words = number of words which are perfectly matched against previous translations in the TM
- Fully Matched Words = number of words which are perfectly matched against previous translations and which are also fully matched in terms of the surrounding context in the TM
- Fuzzy Matched Words = number of words which have various degrees of translation accuracy in the TM
- New Words = number of words which have no translation in the TM
- Locked Words = number of words which must not be translated
- TM Leverage = [100 - (new words * 100 / word count)] at file level
- Cost Savings = [(total words cost) x (new words cost) - (actual cost)] per language
- File Cost = total cost of a file consisting of language cost and any other additional cost
- Cost Model Name = column always empty for Trados Team integrations
- Currency = currency used to calculate the project quote
- Project ID = project internal ID generated automatically by the system
Costs
The Costs tab presents aggregated information about project costs, for the selected period.
- Project Name = name of the project as entered by project creator
- Language Name = full name of the target language
- Language Code = ISO code of target language
- Line Item = cost name (e.g. Translation, Project Management)
- Detail = column always empty for Trados Team integrations
- Language Cost = cost for each translation line item for the specified language
- Project ID = project internal ID generated automatically by the system
Attributes
The Attributes tab presents aggregated information about the custom fields used in projects, for the selected period.
- Project Name = name of the project as entered by project creator
- Language Name = full name of the target language
- Language Code = ISO code of target language
- Attribute Name = name of custom field
- Attribute Description = description of custom field
- Attribute Value = value of custom field
- Project ID = project internal ID generated automatically by the system
Reviewers
The Reviewers tab presents aggregated information about the Customer Reviewers who worked on their assigned tasks, during the selected period.
- Task ID = task ID generated automatically by the system
- Reviewers = Customer Reviewers
- Review Deadline = deadline date of the Customer Review task
- Review Started = start date of the Customer Review task
- Review Ended = end date of the Customer Review task
- Signoff User = column always empty for Trados Team integrations
- Signoff Deadline = column always empty for Trados Team integrations
- Signoff Started = column always empty for Trados Team integrations
- Signoff Ended = column always empty for Trados Team integrations
CostBands
The CostBands tab presents aggregated information about all cost band details, for the selected period.
- Provider Task ID = target file internal ID generated automatically by the system
- Band ID = fuzzy band internal ID (starting at 0) generated automatically by the system
- Minimum Value = minimum value of fuzzy match band
- Repeated Cost per Word = cost of a repeated word per fuzzy band
- Word Cost = cost of a word or of a character unit per fuzzy band
- Word Count = number of words per fuzzy band
- Project ID = project internal ID generated automatically by the system