Do some Google Sheet work

I'm carrying out a series of language learning exercises to explain the importance of the linguistic distance between the source language (your mother tongue) and the target language (the language you want to learn).

For example: "I study English at university" would be "Estudio matemáticas en la universidad" in Spanish and "나는 대학에서 수학을 공부한다." in Korean.

This example shows that the linguistic distance (the differences) between English and Korean is larger than between English and Spanish. Let's say that the English-Korean distance is 100% and the English-Spanish distance is 20%.

I need a Google Sheet master slide where I insert some text in the "source" and "target" language cells (around 2 or 3 sentences), and a macro formula on the "Distance" cell that calculates the linguistic distance/differences between the source and target languages (e.g. using Levenshtein distance).

Then, I need a graph on the right (for example: 6 column x 15 row width) that shows this distance in a user-friendly way for people to see it.

Here's my idea:

[url removed, login to view]

This may be of help: [url removed, login to view]

Thanks.

Zadávání dat Zpracování dat Excel Nástroje Google Webmaster

Identifikační číslo projektu: #14464044

O projektu