maximedb

Hi HN,

With the following function, you can compare the semantic of two strings in Google Sheet. It is essentially a wrapper around the Universal Sentence Encoder [1].

It will encode two sentences and return the cosine similarity between the two embeddings. It works with English, and 15 other languages. It can compare two sentences even if they are in different languages.

For example: SIMILARITY("Hacker News is a social news website focusing on computer science and entrepreneurship", "Hacker News est un site d'actualités sociales axé sur l'informatique et l'entrepreneuriat") returns 0.88 While SIMILARITY("Hacker News is a social news website focusing on computer science and entrepreneurship", "The site was created by Paul Graham in February 2007") returns 0.17.

I initially built it to align instructions in two different languages, and figured it could be useful for other people as well.

To load it into Google Sheets, you can open a Sheet, click on "Tools", "Script Editor" and copy paste the function. It should now be available within the Sheet.

Let me know what you do with it :-)

Maxime.

  /**
   * Multilingual semantic similarity between two string based on Google's Universal Sentence Encoder and cosine similarity.
   *
   * @param {string} str_1 The first text.
   * @param {string} str_2 The second text.
   * @return {float} Number between -1 and 1, where a number of 1 means the two texts are semantically similar.
   * @customfunction
   */
  function SIMILARITY(str_1, str_2) {
    var data = {'str_1': str_1, 'str_2': str_2};
    var options = {
      'method' : 'post',
      'contentType': 'application/json',
      'payload' : JSON.stringify(data)
    };
    response = UrlFetchApp.fetch('https://neuralyst.io/string_similarity', options);
    sim = JSON.parse(response.getContentText())
    return sim["similarity"]
  }

[1]: https://tfhub.dev/google/universal-sentence-encoder-multilingual-large/3

Do you know of an app that computes the CO2 impact of food? Like MyFitnesspal but for CO2 instead of calories/nutrients.

Thanks.

Hi HN,

How do you monitor financial markets?

I used to have a Bloomberg Terminal license at my previous job. Now that is gone, I lack a good tool to monitor markets (like WEI<Go>/WB<Go>/GMM<Go>). Or something similar to the launchpad?

Which app/website do you guys use?

Thank you,

Maxime.

Hi HN,

What is the cheapest service available that proposes CO2 capture ?

Ideally I would like to buy CO2 from that service and get a certificate in return.

Thank you!

Maxime.