Templates for Continuous Process Improvement

 

Video: Language Translations

Translation Tables

for languages and user substitutions

Your Systems2win Excel templates have special features
to easily switch between:

  1. Languages

    (such as Spanish, Portuguese, Chinese, French, or German)

  2. Substitute phrases

    (such as different audit criteria for Office 5S vs. Supply Room 5S)


 

Contents

 

 

 

Search

Use CTRL+F
to find keywords

 

Language Translation

<<<<< Select Language

Language Icons

Learn...

how to switch between translations

Features for multiple languages

Your Systems2win Excel templates have many useful features
to support multiple languages for your global teams.

Here is a partial list...

  Multi-language Features
  Translation Tables

With the click of a button, you can switch to your selected language.
(Language translation is for Excel templates only. Not Word or PowerPoint templates.)

  International versions of Microsoft Excel

Microsoft Word and Excel have excellent foundational support for almost every popular language.

Your Systems2win templates work with most international versions of Microsoft Windows and Office,
so if you're running the Hungarian version of Office on the German version of Windows
while currently switched to the Spanish Language Pack
your Systems2win templates will work.

All of your Windows, Word, and Excel help files will be in your chosen language.

  Pop-up help for row or column labels

Systems2win's English-language pop-up help appears whenever you click any row or column header label,
and you can supplement (not replace) Systems2win's help by inserting Cell Comments
that will appear when your users hover their mouse over that row or column header label cell.

Your personalized Cell Comments can be in any language.

  Dropdown Lists

Many Systems2win templates have dropdown lists for faster, more accurate data entry.

You can personalize your dropdown menus on the DV worksheet,
and your dropdown lists can be in any language.

  User Defined Training

The Help worksheet of every Systems2win template has a User-Defined Training section,
and your User-Defined Training can be in any language.

  User Help Text Boxes

Use Systems2win menu > Copy Shapes to copy the green-bordered User Help Text Box to any worksheet
to provide extra help for your users — in any language.

  Pictures and Shapes

When trying to communicate with people speaking multiple languages,
a picture can be worth a thousand words.

In addition to the many pre-defined shapes that come with the many Systems2win drawing templates,
it's easy to add your own custom shapes.

  Links to your own training materials

In addition to the extensive English language training & videos that come with your Systems2win templates,
Link Icons make it easy to add links to your own training materials,
which might be any web page or video on the Internet,
and might be your own PDF's, Word documents, PowerPoints, intranet pages, videos, etc.
which can be in any language.

There are even special Link Icons for international flags.
When a user sees the flag for their language — they know that it will lead to something they can understand.

  Online Training

Online training for how to use multi-language templates
is found in the Help worksheet of each template that supports multiple languages.

  Technical Support

All technical support is in English.

We do have the resources to install, test, and troubleshoot international versions of Word and Excel,
but do not have staff capable of deciphering languages that require double-byte characters
(such as Japanese, Chinese, or Korean)

  Personalization Upgrade Utility

When you upgrade your templates,
the Systems2win Personalization Upgrade Utility will automatically find and transfer
the most common personalizations that you might add to your templates.

  Other Personalization

You have all the power of Excel
to personalize your templates any way you want them, in any language.

 

Why reinvent?

Why Reinvent?

Why would you to try to reinvent inferior multi-language templates
when it's this easy to do it right?

Order Now

You can add Language translations to your templates
any time that you purchase or upgrade


Bookmark = translations

What Translations are available?

for your Systems2win Excel templates

Popular Languages Less Popular Languages

A "popular" language is purchased by a sufficient number of customers to spread the costs of maintaining that language translation over time as the Systems2win application continues to evolve.

Any customer can sponsor initial translation of any language.

A language becomes "popular" if and when a sufficient number of customers purchase that translation.

Popular languages that have already been translated, and that are available for immediate delivery, include:

Spanish, Portuguese, Chinese, French, and German

Add To Cart

Arabic is available now as a less popular language.

Contact us to get a quote for the language that you want most.

Popular language translations are updated on a periodic cycle, and can be delivered immediately.

Any new changes since the most recent translation date are English only.

Less popular languages are updated only when either:

  1. a new customer purchases that language, or
  2. an existing customer pays a negotiated Translation Update cost

Any new changes since the most recent translation date are English only. Translation updates have 3-4 week delivery.


Bookmark = WhatIs

What is translated

What is human translated

by a professional human translator, and then reviewed by a bilingual expert for industry-specific terminology

Switch languages

Easily switch between
languages

What is machine translated

What is English only

In order to keep translation prices affordable, some things are English only.

  1. Technical support, and instructor-led live training webinars

    Systems2win templates are designed for teams that have an IT Department and at least one Continuous Improvement Leader that speaks fluent English.

  2. Some things associated with installation, activation, and system setup.
  3. Any new changes since the most recent translation update

    Recent changes will be English only — until the next translation cycle.

  4. PowerPoint templates
  5. Some help and training, including:

 

Purchase translations now


Bookmark = data

Data Translation

By "data", we mean the content of your working document —
not the row & column headers, or help instructions, etc.

Usually, the data for any given worksheet is in a single language.

FMEA

If you need the same data in multiple languages, then it is often easiest to
simply duplicate the data in another worksheet or workbook.

You also have the option of linking cells to the User-Defined section of your TT worksheet, so that those data cells switch language (along with headers and help).

The FMEA is the one template that has a special button for translating data
(in addition translating headers, buttons, and help).


Bookmark = UserSubstitutions

User Substitute Phrases

Systems2win menu > Translations

In the Systems2win menu,
select 'Translations & Substitutions' >
Select Translations and Substitute Phrases for THIS Template'

to easily switch between:

  1. Any Language Translations
    that you purchased

    such as Spanish, Portuguese,
    Chinese, French, or German

  2. Screen shot: User Substitutions Your own user-defined
    Substitute Phrases

    such as your own audit criteria
    for Office 5S vs. Production 5S

    See the training for
    how to switch between User Substitute Phrases


Bookmark = personalize

How to personalize your templates

for language translations and User Substitute Phrases

Your Systems2win Leaders can optionally personalize any Systems2win master Excel template using any of the...

Many ways to personalize translations

  1. User Substitutions easily replace standard translations with your own
    (see training below)
  2. Animation: Pop-up HelpThe User-Defined Training section
    at the bottom of each Help worksheet
    can be used to provide additional help and training
    in any language
  3. Cell Comments can supplement the English pop-up help for any row or column header (see animated image) >>>>>
  4. User Help Text Boxes
  5. Links to your own training materials (in any language)
  6. User Interfaces from your portal
  7. Dropdown Lists (see training below)

All of the above types of personalizations are automatically found and transferred to your new templates each time you upgrade — using the Systems2win Personalization Upgrade Utility.

There are also additional optional ways to personalize your templates in ways that are not completely automatically found and transferred each time you upgrade:
(so you will want to use your Customization Log to remind you to make those same changes each time that you upgrade)

How to edit User Substitute Phrases

Video Help

Video: How to personalize text

  1. Select the cell that contains the phrase you want to change.
  2. In the Formula Bar, copy the ID number from the VLOOKUP formula,

    then use the Esc key, so that you are no longer editing the formula.

  3. In the TT sheet, (which you might need to unhide first)...

    use CTRL+F to find your copied ID number.

  4. In the row for that ID number...

    Enter your desired substitute phrase —
    in one or more User Substitution columns.

    Note: If the User Substitution column is blank for any row,
    then the original phrase will be used.

  5. When you're done, rehide the TT sheet

    and finish cleaning up your workbook,
    following the usual instructions for how to personalize any Systems2win workbook.

  6. Test: Use the Select Translation button to select (or refresh) your User Substitutions

    which will replace the default text with your own.

  7. Optional: Perhaps save the document with your User Substitution pre-selected

    so that your users don't need to do anything. Your substitute phrases become the default.

    (And if you use the Systems2win Personalization Upgrade Utility, your default user substitutions will remain the default — even when you receive your new upgraded templates every time you upgrade)

How to add more User Substitution columns

  1. Copy the first User Substitution column.

    Tip: You should not edit that first User Substitution column.
    Leave it blank of everything except the Example data — so that it is always in a clean state ready to be copied.

  2. Use Insert Copied Cells to paste your new column anywhere between the first User Substitution column and the thin gold line after the last User Substitution column.

    Tip: To use Insert Copied Cells, you might need to unhide the top rows.

 

Bookmark = DDLists

Dropdown Lists

There are three different approaches for dropdown lists in multiple languages:

Drop-down List

OPTION 1) Simply add items to the list —
in different languages

For example...

your Gantt Chart might have the English status codes
"done, soon, now" and also the Spanish equivalent codes
"hecho, pronto, ahora".

This approach is the easiest to understand and maintain

and allows the user to choose any item from the list (in any language)
no matter which language is currently selected for headers and help.

Gantt Chart

Training Matrix

OEE

Standard Work

Tip: If a list item starts with a symbol, (such as ▲∆▼■□♥)

then you should copy that symbol
as the first character for your translated line item

so that conditional formatting will work the same as the English list item.

OPTION 2) Leave codes alone,
and simply add multi-language descriptions

For example a Training Matrix dropdown list
might contain rating scale codes of 1 – 5.

The codes wouldn't change,
but your description of each code might be in 2 languages.

Another example:

The OEE Lost Time Category codes cannot be changed;
they need to remain in English for programming reasons.

But you could edit the descriptions on the DV sheet so that someone who speaks a different language can know what each code means.

OPTION 3) Link to translated list items

You dropdown lists can contain list items that are linked to translations on the Translation Tables sheet. (the TT sheet), using either User Substitutions and/or translations that you create and maintain in the User-Defined section of the TT sheet. Follow the instructions for how to personalize text.

This approach is best when you don't want to confuse users with list items that are not in their chosen language.

This approach might be a popular choice for a potentially long list —
like Work Elements for Standard Work Instructions.


Bookmark = feedback

Help us improve translations

Use our Translation Feedback form


 
 

 

 

If your Continuous Improvement team includes people that speak different languages,

then owning Systems2win templates should be an easy decision

 

Own yours now

 

 

 

 

 

 

 

 

 

Add language translations
to your Excel templates

 

 

 

 

You can easily add translations to your existing Systems2win templates when you upgrade

 

 

 

Request Conference