Smart markers for quote templates
Get familiar with the definition of each smart marker and user a simple copy-paste operation to transfer it as a placeholder in the .xlsx file of your quote template.
Smart markers are ordered alphabetically and are grouped into six main categories: costs, generation date, custom fields, languages, project details, and files.
The values are displayed vertically by default or horizontally if you add (horizontal) after each smart marker. For example:
- Use
&=AdditionalCost.Nameto display the information vertically.Value 1
Value 2
Value 3
- Use
&=AdditionalCost.Name(horizontal)to display the information horizontally.Value 1 Value 2 Value 3
To express costs in the currency of the project:
- In your
*.xlsxfile, enter a smart marker which expresses cost, in a cell of your choice. - Right-click the cell, and go to Number > Category. Select Currency.
- Under Symbol, select £. When your custom quote is generated, the cost in the cell will be expressed in the project currency. For example, if your project quote is in Euro, the cell will express the cost in Euro. Note that the £ symbol is merely a placeholder for the actual project currency.
Smart markers for costs
Translation costs and words per target language
- &=TranslationCost.ContextMatch.Count
- The number of Context Match words.
- &=TranslationCost.ContextMatch.Rate
- The cost per word for Context Match words.
- &=TranslationCost.ContextMatch.Total
- The total cost of Context Match words.
- &=TranslationCost.ExactMatch.Count
- The number of Exact Match words.
- &=TranslationCost.ExactMatch.Rate
- The cost per word for Exact Match words.
- &=TranslationCost.ExactMatch.Total
- The total cost of Exact Match words.
- &=TranslationCost.FuzzyMatch.Count
- The number of Fuzzy Match (all bands) in terms of words/language.
- &=TranslationCost.FuzzyMatch.Rate
- The cost per word for Fuzzy Match words.
- &=TranslationCost.FuzzyMatch.Total
- The total cost for Fuzzy Match words (all bands) in terms of words/language.
- &=TranslationCost.FuzzyMatch1.Count
- The number of Fuzzy Match words for custom band 1.
- &=TranslationCost.FuzzyMatch1.Rate
- The cost per word for Fuzzy Match words in custom band 1.
- &=TranslationCost.FuzzyMatch1.Total
- The total cost for Fuzzy Match words in custom band 1.
- &=TranslationCost.FuzzyMatch2.Count
- The number of Fuzzy Match words for custom band 2.
- &=TranslationCost.FuzzyMatch2.Rate
- The cost per word for Fuzzy Match words in custom band 2.
- &=TranslationCost.FuzzyMatch2.Total
- The total cost for Fuzzy Match words in custom band 2.
- &=TranslationCost.FuzzyMatch3.Count
- The number of Fuzzy Match words for custom band 3.
- &=TranslationCost.FuzzyMatch3.Rate
- The cost per word for Fuzzy Match words in custom band 3.
- &=TranslationCost.FuzzyMatch3.Total
- The total cost for Fuzzy Match words in custom band 3.
- &=TranslationCost.FuzzyMatch4.Count
- The number of Fuzzy Match words for custom band 4.
- &=TranslationCost.FuzzyMatch4.Rate
- The cost per word for Fuzzy Match words in custom band 4.
- &=TranslationCost.FuzzyMatch4.Total
- The total cost for Fuzzy Match words in custom band 4.
- &=TranslationCost.Locked.Count
- The number of locked words.
- &=TranslationCost.Locked.Rate
- The cost per word for locked words.
- &=TranslationCost.Locked.Total
- The total cost of locked words.
- &=TranslationCost.MachineTranslation.Count
- The number of MT words.
- &=TranslationCost.MachineTranslation.Rate
- The cost per word for MT words.
- &=TranslationCost.MachineTranslation.Total
- The total cost of MT words.
- &=TranslationCost.New.Count
- The number of new words.
- &=TranslationCost.New.Rate
- The cost per word for new words.
- &=TranslationCost.New.Total
- The total cost of new words.
- &=TranslationCost.PerfectMatch.Count
- The number of Perfect Match words.
- &=TranslationCost.PerfectMatch.Rate
- The cost per word for Perfect Match words.
- &=TranslationCost.PerfectMatch.Total
- The total cost of Perfect Match words.
- &=TranslationCost.Repetition.Count
- The number of repetitions.
- &=TranslationCost.Repetition.Rate
- The cost per word for repetitions.
- &=TranslationCost.Repetition.Total
- The total cost of repetitions.
- &=TranslationCost.TargetLanguage.Code
- The ISO code of the target language for this translation cost.
- &=TranslationCost.TargetLanguage.Name
- The localized language name of the target language for this translation cost.
- &=TranslationCost.TmLeverage
- The percentage value of the units retrieved from TMs as translated strings.
- &=TranslationCost.Total
- The total cost (sum of all costs).
- &=TranslationCost.TotalWords
- The total number of words (sum of all counts).
- &=Project.TotalTranslationCosts
- The total translation costs for all languages in a project (excluding any additional target language costs).
- &=TotalTranslationCost.ContextMatch.Count
- The total number of Context Match words across all languages.
- &=TotalTranslationCost.ExactMatch.Count
- The total number of Exact Match words across all languages.
- &=TotalTranslationCost.FuzzyMatch.Count
- The total number of Fuzzy Match words (all bands) across all languages.
- &=TotalTranslationCost.FuzzyMatch1.Count
- The total number of Fuzzy Match words across all languages for custom band 1.
- &=TotalTranslationCost.FuzzyMatch2.Count
- The total number of Fuzzy Match words across all languages for custom band 2.
- &=TotalTranslationCost.FuzzyMatch3.Count
- The total number of Fuzzy Match words across all languages for custom band 3.
- &=TotalTranslationCost.FuzzyMatch4.Count
- The total number of Fuzzy Match words across all languages for custom band 4.
- &=TotalTranslationCost.MachineTranslation.Count
- The total number of MT words across all languages.
- &=TotalTranslationCost.Locked.Count
- The total number of locked words across all languages.
- &=TotalTranslationCost.New.Count
- The total number of new words across all languages.
- &=TotalTranslationCost.PerfectMatch.Count
- The total number of Perfect Match words across all languages.
- &=TotalTranslationCost.Repetition.Count
- The total number of repetitions across all languages.
- &=TotalTranslationCost.ContextMatch.Total
- The total cost of Context Match words across all languages.
- &=TotalTranslationCost.ExactMatch.Total
- The total cost of Exact Match words across all languages.
- &=TotalTranslationCost.FuzzyMatch.Total
- The total cost of Fuzzy Match words across all languages.
- &=TotalTranslationCost.FuzzyMatch1.Total
- The total cost of Fuzzy Match words across all languages for custom band 1.
- &=TotalTranslationCost.FuzzyMatch2.Total
- The total cost of Fuzzy Match words across all languages for custom band 2.
- &=TotalTranslationCost.FuzzyMatch3.Total
- The total cost of Fuzzy Match words across all languages for custom band 3.
- &=TotalTranslationCost.FuzzyMatch4.Total
- The total cost of Fuzzy Match words across all languages for custom band 4.
- &=TotalTranslationCost.MachineTranslation.Total
- The total cost of MT words across all languages.
- &=TotalTranslationCost.Locked.Total
- The total cost of locked words across all languages.
- &=TotalTranslationCost.New.Total
- The total cost of new words across all languages.
- &=TotalTranslationCost.PerfectMatch.Total
- The total cost of Perfect Match words across all languages.
- &=TotalTranslationCost.Repetition.Total
- The total cost of repetitions across all languages.
Additional costs per target language
- &=LanguageCost.CostType
- Conditional cost or regular cost (volume, per page, hourly, percentage).
- &=LanguageCost.Count
- The number of additional counts.
- &=LanguageCost.Description
- Information about the additional cost.
- &=LanguageCost.Id
- The cost ID generated automatically by the system.
- &=LanguageCost.Index
- The order of the cost.
- &=LanguageCost.Name
- The name of the additional cost.
- &=LanguageCost.Operand
- The value against which the operator determines how to apply the additional cost. For example, in "greater than 30", the operand is 30.
- &=LanguageCost.RunningTotal
- The sum of all the additional costs for a target language.
- &=LanguageCost.Total
- The value of an individual additional cost associated with a target language.
- &=LanguageCost.VolumeUnitType
- The criterion used to calculate volume (words or characters).
- &=LanguageCost.TargetLanguage.Code
- The target language ISO code for the additional target language cost.
- &=LanguageCost.TargetLanguage.Name
- The localized name of the target language for the additional target language cost.
- &=Project.TotalAdditionalLanguageCosts
- The total for all additional target language costs in a project.
Total costs per target language
- &=TotalLanguageCost.TargetLanguage.Code
- The ISO code for the target language for which all costs are calculated.
- &=TotalLanguageCost.TargetLanguage.Name
- The localized name for the target language for which all costs are calculated.
- &=TotalLanguageCost.TranslationCostTotal
- The total translation costs for a target language.
- &=TotalLanguageCost.LanguageCostTotal
- The total costs for a target language.
- &=TotalLanguageCost.TotalCost
-
The total costs for a target language, namely
TotalLanguageCost.TranslationCostTotal+TotalLanguageCost.LanguageCostTotal.
Additional costs per project
- &=AdditionalCost.Cost
- The value of the additional cost.
- &=AdditionalCost.CostId
- The cost ID generated automatically by the system.
- &=AdditionalCost.CostOperand
- The value against which the operator determines how to apply the additional cost. For example, in "greater than 30", the operand is "30".
- &=AdditionalCost.CostOperator
- A rule which governs how the cost is calculated. For example, in "greater than 30", the operator is "greater than".
- &=AdditionalCost.CostVariable
- The criterion for which the additional cost is applied. The available criteria are Word Count and Running Total.
- &=AdditionalCost.RunningTotal
- The sum of all additional costs set at project level.
- &=AdditionalCost.Total
- The value of an individual additional cost set at project level.
- &=AdditionalCost.CostType
- Conditional cost or regular cost (volume, per page, hourly, percentage).
- &=AdditionalCost.Count
- The number of additional costs.
- &=AdditionalCost.Description
- Information about the additional cost.
- &=AdditionalCost.Index
- The order of the cost.
- &=AdditionalCost.Name
- The name of the additional cost.
- &=AdditionalCost.VolumeUnitType
- The criterion used to calculate volume (words or characters).
- &=Project.TotalAdditionalProjectCosts
- The total for all additional project costs.
Total costs per project
- &=Project.TotalTranslationCosts
- The total translation costs for all languages (excluding any additional target language costs).
- &=Project.TotalAdditionalLanguageCosts
- The total for all additional language costs.
- &=Project.TotalAdditionalProjectCosts
- The total for all additional project costs.
- &=Project.TotalCost
-
The total value of the project, namely
Project.TotalTranslationCosts+Project.TotalAdditionalLanguageCosts+Project.TotalAdditionalProjectCosts.
Smart markers for generation date
- GenerationDate
-
The date when the quote was downloaded. Do not use
&=in front of this marker.
Smart markers for custom fields
- &=CustomProperty.Name
- The name of the custom field.
- &=CustomProperty.Value
- The value of the custom field.
Smart markers for languages
- &=Project.SourceLanguages
- The source language of the project.
- &=Project.TargetLanguages
- A comma-separated list of all the target languages in a project.
- &=Project.QuoteTargetLanguages
- A comma-separated list of all the target languages in a quote.
- &=SourceLanguages.Code
- The ISO code of the source language. Use this smart marker to display the source language code for the project.
- &=SourceLanguages.Name
- The localized language name of the source language. Use this smart marker to display the source language name for the project.
- &=TargetLanguages.Code
- The ISO code of the target languages. Use this smart marker to display the target language code for the project.
- &=TargetLanguages.Name
- The localized name of the target languages. Use this smart marker to display the target language name for the project.
- &=TranslationCost.TargetLanguage.Code
- The ISO code of the target language for this translation cost. Use this smart marker in conjunction with translation costs.
- &=TranslationCost.TargetLanguage.Name
- The localized name of the target language for this translation cost. Use this smart marker in conjunction with translation costs.
- &=LanguageCost.TargetLanguage.Code
- The target language ISO code for the additional target language cost. Use this marker in conjunction with additional costs set at target language level.
- &=LanguageCost.TargetLanguage.Name
- The localized name of the target language for the additional target language cost. Use this marker in conjunction with additional costs set at target language level.
- &=TotalLanguageCost.TargetLanguage.Code
- The ISO code for the target language for which all costs are calculated. Use this marker in conjunction with additional costs set at target language level.
- &=TotalLanguageCost.TargetLanguage.Name
- The localized name for the target language for which all costs are calculated. Use this marker in conjunction with additional costs set at target language level.
Smart markers for project details
- &=Project.ShortProjectId
- The shorthand and human readable format of the project ID.
- &=Project.CreatedAt
- The date and time when the project was created.
- &=Project.CreatedBy
- The name of the user who created the project.
- &=Project.Description
- The description of the project as specified during project creation.
- &=Project.DueBy
- The date specified in the Customer Quote Review task.
- &=Project.EstimatedDate
- The date and time of project delivery as specified by the project manager.
- &=Project.Id
- The unique project ID generated automatically by the system.
- &=Project.FolderPath
- The full path of the project folder.
- &=Project.Folder
- The project folder/customer/location.
- &=Project.Name
- The name of the project.
- &=Project.Notes
-
The notes associated with the project quote.
- &=Project.QuoteDate
- The date and time when the project quote is generated automatically by the system, based on the pricing model.
- &=Project.QuoteCurrencyCode
- The currency code associated with the project quote.
- &=Project.QuoteLanguageCode
- The language code associated with the project quote.
- &=Project.QuoteNote
-
The notes entered manually when reviewing the quote. Quote notes may consist in lengthier text, which requires you to adjust the cell width, by merging the required cells, and also enabling the
Wrap textoption for that cell. The cell height of the cell will be adjusted automatically to fit all the text. - &=Project.RequestedDate
- The date and time of project delivery as specified by the project creator.
- &=Project.ReferenceFileCount
-
The number of reference files in a project.
- &=Project.SourceFileCount
-
The number of source files in a project.
- &=Project.TargetFileCount
-
The number of target files in a project.
- &=Project.QuoteTargetFileCount
- The number of target files in a selected quote.
- &=Project.SourceLanguages
- The source language of the project.
- &=Project.TargetLanguages
- A comma-separated list of all the project target languages.
- &=Project.TemplateName
- The project template name.
Smart markers for files
- &=ReferenceFiles.CreatedAt
-
The date and time when the reference file was added to the project.
- &=ReferenceFiles.Name
-
The name of the reference file.
- &=SourceFiles.CreatedAt
-
The date and time when the source file was added to the project.
- &=SourceFiles.Name
-
The name of the source file.
- &=Project.SourceFileCount
- The number of source files in a project.
- &=Project.ReferenceFileCount
-
The number of reference files in a project.
- &=Project.TargetFileCount
-
The number of target files in a project.