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.Name to 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:
  1. In your *.xlsx file, enter a smart marker which expresses cost, in a cell of your choice.
  2. Right-click the cell, and go to Number > Category. Select Currency.
  3. 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 text option 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.