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