Anahi  Kirlin

Anahi Kirlin

1625451737

How to Translate Languages with Google Sheets

In this video you’ll learn how to use the GOOGLETRANSLATE function in Google Sheets to translate your text to any language.

Join My Google Sheets Comprehensive Masterclass: https://courses.xelplus.com/p/google-sheets

★★★ My Online Excel Courses ► https://www.xelplus.com/courses/

★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

GEAR I use: https://www.xelplus.com/resources/#gear

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#googlesheets #shorts

#google #google-sheets

What is GEEK

Buddha Community

How to Translate Languages with Google Sheets

Google's TPU's being primed for the Quantum Jump

The liquid-cooled Tensor Processing Units, built to slot into server racks, can deliver up to 100 petaflops of compute.

The liquid-cooled Tensor Processing Units, built to slot into server racks, can deliver up to 100 petaflops of compute.

As the world is gearing towards more automation and AI, the need for quantum computing has also grown exponentially. Quantum computing lies at the intersection of quantum physics and high-end computer technology, and in more than one way, hold the key to our AI-driven future.

Quantum computing requires state-of-the-art tools to perform high-end computing. This is where TPUs come in handy. TPUs or Tensor Processing Units are custom-built ASICs (Application Specific Integrated Circuits) to execute machine learning tasks efficiently. TPUs are specific hardware developed by Google for neural network machine learning, specially customised to Google’s Machine Learning software, Tensorflow.

The liquid-cooled Tensor Processing units, built to slot into server racks, can deliver up to 100 petaflops of compute. It powers Google products like Google Search, Gmail, Google Photos and Google Cloud AI APIs.

#opinions #alphabet #asics #floq #google #google alphabet #google quantum computing #google tensorflow #google tensorflow quantum #google tpu #google tpus #machine learning #quantum computer #quantum computing #quantum computing programming #quantum leap #sandbox #secret development #tensorflow #tpu #tpus

Virgil  Hagenes

Virgil Hagenes

1603047600

How to translate text with python

Introduction

In this tutorial, we will explore different possibilities to translate a text or word using python. From my experience, this is very helpful if you want to automate the translation of many paragraphs, sentences or words.

Furthermore, you can have a backend worker, which receives new data constantly and can either return a request with the translation or store different translations in a database (this is very useful in NLP tasks).

One of the reasons to choose Python apart from the clear syntax and the extensive library is the great community that works extensively on the development of the language itself or extending the functionality with third party modules.

Precisely, one of the modules that makes it straightforward to translate texts is the deep_translator, which provides support for multiple famous translators.

#python #google-translate #translation #translators #translate

Anahi  Kirlin

Anahi Kirlin

1625451737

How to Translate Languages with Google Sheets

In this video you’ll learn how to use the GOOGLETRANSLATE function in Google Sheets to translate your text to any language.

Join My Google Sheets Comprehensive Masterclass: https://courses.xelplus.com/p/google-sheets

★★★ My Online Excel Courses ► https://www.xelplus.com/courses/

★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

GEAR I use: https://www.xelplus.com/resources/#gear

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#googlesheets #shorts

#google #google-sheets

Manage i18n translations from Google Sheet

Managing translations of an app, a web site… can be very painful.

Indeed, we have to think about how new translations are added into the app, what about the updated ones and all that with the lowest cost as possible. Yes, the lowest cost, the less time to waste by the developer and by the product owner !

That takes a lot of time !

Just imagine that case i’m sure you already know. The product owner wants to add a new functionality to the app and brings with it new translations in 10 different languages. At the moment to develop the functionality, you have to think about the keys that will be used inside the i18n library you use, and copy-paste each message. That takes a lot of time and it’s not really funny to do that !

A simple tool to manage translations ?

And what about a simple tool that centralizes the translations accessible for both product owners and developers ? Build it by your own ? No, very costly.

What do we need for that tool ? An access for users with permissions, a user interface that allow to easily add, edit and remove messages and a little button to export all theses messages in a JSON file.

Google Sheet, seriously ?

Well, there is a solution. Google Sheet. Seriously ? Yes, as simple as that. Google Sheet can centralize all the translated messages and handle the permissions to access or to edit the file. But where is the little button that generates the JSON file ? Did you that you can use add-ons with Google Sheet ? Me, I didn’t know until I found an add-on in the market place of GSuite. Export Sheet Data : https://gsuite.google.com/marketplace/app/export_sheet_data/903838927001


How to use the power of Google Sheet and Export Sheet Data it’s add-on ?

Organize the translation in the Google Sheets

First of all, the translations will handle 3 languages : English (en), French (fr), Spanish (es).

Let’s assume that there are 2 kinds of translations :

generic : simple words that can be used several times with no context (Edit, Save, Add, Delete, Hello, Good Bye, Houses, Cars….)

contextual: from simple word to long sentence that can appear often once within a special context (page, functionality, section…)

Well, I suggest to group the translations according to these kinds (generic or contextual).

Each context will be represented by a sheet in the Google Sheet Document.

About generic case, I suggetst to split into several sheets (action, state (Loading, Saving…), greetings, Country…).

Let’s create named tabs. “actions”, “state”, “greetings” and “shop-list”.

The name of the sheet (or tab) will be in lowercase as it will be used as a key for the translations.

Then, in each sheet, the first column is named “key”. It will be used to build the translations keys :

{tab_name}.{key}

The following columns are the language ones. “en”, “fr” and “es”.

Image for post

The tab “actions”

Image for post

The tab “state”

Image for post

The tab “greetings”

Image for post

The tab “shop’list”

#google-sheet-add-ons #productivity #vue-i18n #google-sheets #vuejs #vue

What Are Google Compute Engine ? - Explained

What Are Google Compute Engine ? - Explained

The Google computer engine exchanges a large number of scalable virtual machines to serve as clusters used for that purpose. GCE can be managed through a RESTful API, command line interface, or web console. The computing engine is serviced for a minimum of 10-minutes per use. There is no up or front fee or time commitment. GCE competes with Amazon’s Elastic Compute Cloud (EC2) and Microsoft Azure.

https://www.mrdeluofficial.com/2020/08/what-are-google-compute-engine-explained.html

#google compute engine #google compute engine tutorial #google app engine #google cloud console #google cloud storage #google compute engine documentation