23 June 2020

Antitrust case against Facebook’s ‘super profiling’ back on track after German federal court ruling


A landmark regulatory intervention that seeks to apply structural antitrust remedies to cut big (ad)tech’s rights-hostile surveillance business models down to size has been revived after Germany’s federal court overturned an earlier ruling that had suspended enforcement of a ban on Facebook combining user data.

The upshot is the tech giant could be forced to stop combining the personal data of users of its various social services with other personal data it harvests on Internet users via its various social plug-ins and tracking pixels. Which in turn would amount to a structural separation of Facebook’s social empire.

That said, there’s still some mileage left in the legal process — which will likely delay any enforcement for months more at least. But the federal court has put the train back on the tracks.

As we’ve reported previously, the intervention by Germany’s antitrust regulator is seen as highly innovative as it joins the dots of EU privacy rights and competition law. So this case is being closely watched by regulators around the world.

Quick recap: Last year Germany’s Federal Cartel Office ordered Facebook to stop combining data on users across its different services after determining that its zero opt-out T&Cs combined with Facebook’s dominant market position in the social network space to make its pervasive people-profiling an “exploitative abuse”.

The order originated with an investigation by the Bundeskartellamt (FCO) into Facebook’s data-gathering practices, which kicked off in March 2016. Almost exactly three years later the regulator concluded it had identified abuse — and issued the order banning Facebook from combining data on users across its own suite of social platforms without first obtaining their consent.

Instead of agreeing to offer users a choice over how they’re tracked, Facebook appealed — and, last August, the Higher Regional Court in Dusseldorf granted it a suspension, delaying application of the order — and seemingly derailing the chance for an innovative regulatory intervention against a rights hostile ‘track and target’ adtech business model. 

All was not lost though, as the FCO appealed the suspension — leading to today’s fresh legal twist.

In today’s decision, the Germany Federal Court of Justice provisionally confirms the FCO’s allegation of an abuse of a dominate position by Facebook — opening the door to the regulator being able to enforce the ban.

So it’s game (back) on for the antitrust case against platform giants whose dominance stems from mass surveillance of Internet users.

In a statement, FCO president Andreas Mundt welcomed the decision.

“I am pleased about the decision by the Federal Court of Justice,” he said. “Data are an essential factor for economic strength and a decisive criterion in assessing online market power. The court’s decision provides important information on how we should deal with the issue of data and competition in the future. Whenever data are collected and used in an unlawful way, it must be possible to intervene under antitrust law to avoid an abuse of market power.”

We’ve also reached out to Facebook for comment.

The Dusseldorf Higher Regional Court has still not issued a ruling on Facebook’s original appeal against the FCO order — though it granted the company’s request for a suspension, saying it had doubts about its legality.

But the Federal Court of Justice has overturned that earlier decision. And not just overturned it — it’s blasted it with a legal equivalent of a blowtorch.

In a press release today (in German, which we’ve translated using Google Translate) the court writes [emphasis ours]: “There are no serious doubts about Facebook’s dominant position in the German market for social networks or that Facebook is abusing this dominant position with the terms of use prohibited by the Cartel Office.”

The court takes issue with Facebook’s terms and condition — finding them “abusive” because it says users are not offered a choice over the extent of the company’s tracking and targeting of them; with the court pointing out there’s no option for users to have Facebook’s content “personalization” based only on the data they reveal on Facebook.com. Instead Facebook forces users to accept what it calls “a more intensive personalization of the user experience”, which the court further notes is “associated with a potentially unlimited access to characteristics of their ‘off-Facebook’ Internet use by Facebook”.

Which doesn’t sound, y’know, proportionate.

In additional remarks, the court writes that Facebook’s super profiling of Internet users has negative impacts on people’s personal autonomy — infringing their rights, not only under EU data protection law, but it asserts this also represents an antitrust abuse as a consequence of how Facebook is exploiting its dominant position in the market for social networks.

Or, as it put it in the press release: “The lack of choice for Facebook users not only affects their personal autonomy and the protection of their right to informational self-determination, which is also protected by the GDPR [General Data Protection Regulation]. Against the background of the high hurdles to change that exist for the users of the network (“lock-in effects”), it also represents an exploitation of the users that is relevant under antitrust law, because competition is no longer effective due to Facebook’s dominant position.”

The court also points to findings by the FCO that significant numbers of Facebook users want to be able to hand over less personal information to use its service — noting that if thriving competition existed in the social network market there may well be a more privacy-friendly offer from Facebook. Instead, you get none.

In another interesting observation, the court said Facebook’s access to “a significantly larger database” — i.e. via its super profiling of users — reinforces what are already “pronounced” network effects keeping a lid on competition in the social media market. So a double negative.

Additionally, it suggests Facebook’s super profiling helps the company amass larger ad revenues — which it notes “also depend on the scope and quality of the data available”. “Finally, due to the negative effects on competition for advertising contracts, an impairment of the market for online advertising cannot be ruled out,” it adds in another shot across Zuckerberg’s bow.

Commenting on the decision, Rupprecht Podszun, a chair for civil law, German and European competition law at Heinrich Heine University, called it “a spectacular success” for the FCO and an “important step forward” in regulating Internet giants whose empires are based on this type of rights-hostile profiling. 

“The decision is a spectacular success for the competition watchdog, and an important signal for competition on the internet. The proceedings against Facebook are regarded worldwide as a pioneering case: The FCO is attempting to tame the tech giants and to stop the build-up of economic power through integration of data to ‘super profiles’. This is something new in terms of antitrust law. Exploitation of users through data aggregation, as the FCO has accused Facebook of doing, has so far been uncharted territory,” he told TechCrunch. 

“The Federal Supreme Court said it has ‘no serious doubts’ that Facebook is market-dominant and abuses its market power. The court is even stricter than the competition authority: It does not require a protection of privacy laws (as in the General Data Protection Regulation), but it says that freedom of choice and autonomy of users is key in such cases. This is an important step forward –– making the users’ self-determination a benchmark for competition on the internet.”

“The FCO can now demand from Facebook to submit a plan within four months how to stop the merging of data into so-called ‘super profiles’,” Podszun added. “Facebook merges data from the group’s own services such as Facebook, WhatsApp and Instagram with other data collected on the net via so-called Facebook Business Tools. This was the Bundeskartellamt’s central point of attack.”

The professor remains critical of the pace of regulatory progress — dubbing it “almost a bad joke” for this latest twist of the legal process to be couched an ‘interim proceeding’.

He also cautions against expecting any swift break-up of Facebook’s data mining and mingling to follow, noting there are other legal avenues for the lawyered-up company to pursue — meaning it could be months or even years more before there’s any enforcement of the FCO order.

“This is particularly problematic because economic power in digital markets consolidates extremely quickly,” Podszun also said, calling for reform of competition law so it can effectively respond to digital gatekeepers.

“The proceedings therefore show that there must be changes in the way dominance of gatekeeper companies on the Internet is dealt with. The competition authorities must be able to act more effectively and more quickly in such cases. This is where the German and European legislators are called upon to act. Plans are being developed on the national and the European level. The reasoning in the Facebook case will be a boost to competition commissioner Margrethe Vestager in her fight against these companies, too.”

The sedate pace of regional competition law vs the blistering speed of digital business has long led to calls for competition law reform — a topic that’s now front of mind for EU lawmakers.

After Facebook’s first successful appeal of the FCO order, Podszun suggested a number of changes were needed to update EU competition law for the platform era. One of which — to evolve traditional market definitions to allow for interventions in digital markets to prevent tipping — is being actively consulted on by the Commission which is now considering whether regulators need a new tool to combat tipping in digital markets. 

It is also looking at applying ex ante regulation to so called ‘gatekeepers’ — aka platforms which have gained significant market power — as another step to try to ensure ‘fair functioning’ of digital markets.

Speaking during an Atlantic Council discussion today, Commission EVP Margrethe Vestager — who both leads digital policy for the bloc and heads up its antitrust division — signalled, in her usual roundabout way, that digitally driven competition reform is indeed coming.

“We have an intense debate about competition enforcement in the digital era [and] we need to change for the times we’re in because the market dynamics are different, they are faster, you have marginal prices approaching zero, you have network effects, you have the data-driven economy. So of course we need to change with the times that we’re in,” she said. “But we will not negotiate and we will not compromise on this being build on the rule of law and the responsibility for the courts in order to make sure that we have equal treatment between businesses.”

Asked whether she’d like the power to rescind merger approvals — with the moderator citing the case of Facebook reversing a prior commitment to regulators who approved its acquisition of WhatsApp that it would never combine user data between its eponymous service and the messaging app (before going on to do just that) — she responded that it’s “a very specific situation”, saying EU regulators performed a competition analysis at the time — looking at whether, if Facebook did merge data between the services, would it be a “competition problem” or not?

“Back then they found that no that would not be the case. So in that respect… on substance this would not be a case for unscrambling ‘the eggs’. And it is indeed very difficult to unscramble the eggs,” she said.

Vestager also conceded that the third component of antitrust decisions — “how to make competition come back?” — remains a “work in progress”.

“Of course we haven’t seen the effect of the Android preference menu because very few Android phones have been shipped due to the COVID crisis,” she said on that. “But it remains to be seen if, when Google is preinstalled after the untying and other services can be chosen, will that work? Will that sort of open the market for others — search and browsers — than the Google choices?”


Read Full Article

Google’s grammar suggestions in Docs are now available in Spanish


If you regularly write in Spanish, you’ll be happy to hear that Google today announced that its neural network-powered grammar suggestions in its Docs online text editor are now available in Spanish, too. Just like with grammar suggestions for English, though, this feature will only be available for G Suite customers for now — but if you are a G Suite customer, it should be available now. Google says it plans to extend this feature to consumers and educational organizations in the future.

In addition, Google also today announced that Smart Compose, which tries to finish sentences for you, and spelling autocorrect will also come to Docs in Spanish later this year. Google also tells me that grammar suggestions for Spanish will soon come to Gmail as well, where support for English is already available today.

Google introduced its grammar suggestions for English last February (and it first announced it at Google Cloud Next in the middle of 2018). And while Docs had a grammar checker before, this new tool now uses an interesting machine learning approach based on the company’s experience in doing machine translations. That also means Google has to train a new neural network for every new language it supports.

We’ll likely see the company introduce additional languages in the not too distant future, but for now, English and Spanish are the only ones currently supported in Docs.

One nice feature here is that Google’s tool automatically knows what language you are writing in, so there’s no need to manually switch back and forth.

With Google, Microsoft and Grammarly now offering next-generation spell-checking and grammar tools, we’re seeing a lot more competition in this space than even a few months ago. Microsoft and Grammarly are taking a bit of a different approach, though, with extensions that work across applications (though Microsoft Editor only supports text fields across a select number of web apps so far). Microsoft Editor, it’s worth noting, also supports more than 20 languages in Word. All of them, though, only make their most advanced tools available to paying customers for the time being. Those neural networks don’t run themselves, after all.


Read Full Article

Wyze launches its $50 wire-free outdoor camera


In recent years, Seattle-based Wyze made a name for itself thanks to making a lot of smart home gadgets affordable. These days, the company sells everything from smart plugs and locks to scales and fitness bands, but what started it all was the $20 Wyze indoor security camera. Today, the company is following that up with its newest camera, the Wyze Cam Outdoor, which is launching in early access today.

It’ll cost $50 for the starter bundle with a base station and once the camera is out of early access, you’ll be able to add additional cameras for $40 each. As usual, Wyze is undercutting many of its direct competitors in this space for basic outdoor security cameras on price.

For the most part, that name tells you everything you need. It’s a 20 fps 1080p camera for live streaming and recording and features IP65 water resistance that keeps the overall blocky aesthetics of the original Wyze camera. It also offers a night vision mode and two-way audio through the Wyze app, which also offers a rolling 14 days of free cloud storage, in addition to on-device storage. And, of course, it also uses some onboard smarts to do motion detection, using a standard PIR sensor.

Image Credits: Wyze /

Like similar products, it runs purely on battery power, so you don’t have to string any cables across your yard. The company says the battery should last three to six months.

It mounts to its base with magnets, but you still need to do a bit of DIY to screw that base into your walls, ceilings or garden fences.

The base station itself is obviously cabled (and that includes the option to plug in an ethernet cable, in addition to WiFi support). One nice feature here is that the base station also includes an SD card slot, so you can store videos on there, too.

Given that it’s pretty small, at 2.3×2.3×2.8 inches, Wyze also built another nifty feature into the software: offline travel mode. With this, the company says, you can watch your hotel room or campsite while you’re away from home.

Image Credits: Wyze

Based on the samples, this looks to be a pretty capable outdoor camera, but hardware is only one piece of the puzzle here. A lot depends on how well the app and on-camera motion detection work, too. We’ll take a closer look at those once we get a review sample in the next couple of weeks.

If you don’t want to wait until then, the starter pack is now available in Wyze’s shop and in the Wyze app.


Read Full Article

Fandango adds new features to highlight health precautions and distancing in movie theaters


As movie theaters reopen across the United States and the world, there are lingering questions about what kinds of measures those theaters will be taking to keep staff and moviegoers safe in the midst of the ongoing COVID-19 pandemic.

These concerns were illustrated last week, when AMC CEO Adam Aron said in an interview that the theater chain would not be requiring that patrons wear masks except in locations where they’re legally required to do so — because the company “did not want to be drawn into a political controversy.” Naturally, those comments prompted a controversy of their own, leading AMC to reverse its decision.

So it makes sense for NBCUniversal-owned movie ticketing app Fandango to highlight the different safety measures that theaters are taking.

It’s useful from an informational perspective, so that moviegoers understand and prepare for the experience in theaters, and perhaps choose theaters based on how serious they seem about safety. But it’s also a savvy marketing move, as those theaters will need to convince moviegoers that it’s safe to return.

Fandango social distance seating

Image Credits: Fandango

The new features include what Fandango is pitching as a “one-stop shop” to view the safety measures announced by more than 100 theater chains, with information about auditorium occupancy, social distance seating, mask/protective equipment policies, enhanced cleaning measures and special concession arrangements. There will also be instructional videos, social distance seating maps and a way to search for reopened theaters by location.

Since movie theaters have been closed for the past few months, Fandango also says it will be extending expired rewards from its Fandango VIP+ loyalty programs for another 60 days.

“We are working closely with our friends in exhibition to help get their ticketing back online and film fans back in seats with peace of mind,” said Melissa Heller, Fandango’s vice president of domestic ticketing, in a statement. “In addition to our new product features, Fandango’s mobile ticketing will be an added benefit, helping moviegoers and cinema employees reduce the number of contact points at the box office and throughout the theater.”


Read Full Article

Why colonialist stereotypes persist -- and how to stop romanticizing history | Farish Ahmad-Noor

Why colonialist stereotypes persist -- and how to stop romanticizing history | Farish Ahmad-Noor

Colonialism remains as an inescapable blight on the present, lingering in the toxic, internalized mythologies and stereotypes that outlive the regimes that created them, says historian Farish Ahmad-Noor. Examining why these prejudices and narratives persist (and sometimes thrive), he suggests a multidisciplinary approach to reject cultural obsessions with romanticized history and prevent this malignant nostalgia from perpetuating past oppressions.

Click the above link to download the TED talk.

Facebook tests Forecast, an app for making predictions about world events, like COVID-19


Forecast, a new project from Facebook’s internal R&D group, NPE Team, is launching today to build a community around predictions. The iOS app will allow users to ask questions and then use in-app points to make predictions about what might happen in the future. Users can also create, discuss and view these crowdsourced predictions.

At launch, only invited participants in the U.S. and Canada will be allowed to make predictions and engage in conversations, while the app is in beta testing. But these predictions and related discussions will be publicly accessible on the Forecast website and made shareable.

Before today, Facebook tested the product internally with a small set of employees. Their initial forecasts will form the initial core content in the app at launch.

Starting now, Facebook will invite members of the health, research and academic communities to make predictions about the COVID-19 pandemic and its impact on the world.

At a time when Facebook and other major tech platforms are under fire for their role in aiding the spread of misinformation, fake news, propaganda, conspiracy theories, and other non-factual content presented as truth, an app focused on making “guesses” about the future seems ill-advised — however educated those guesses may be. This is particularly concerning because much of the app’s content will focus on guesses about COVID-19.

Forecast’s predictions may help show what people are thinking, but COVID-19 isn’t a game. To understand the world, scientists form a hypothesis, which is essentially an expanded form of an educated guess. But they don’t then crowdsource voting to determine if a hypothesis is true — they test, experiment, gather supporting data, try to prove and disprove the hypothesis, and ultimately aim to publish their findings and have them peer-reviewed.

The Forecast app turns the hypothesis into the end result, in a way. The app lets users make a forecast and explain their reasoning — in other words, form a hypothesis. But instead of doing the work to test the forecast, through the application of the scientific method, Forecast will track the votes a given question receives.

E.g. “When will the first COVID-19 vaccine candidate begin phase 3 trials?” or “When will most U.S. residents be treated with a COVID-19 vaccine?” In non-COVID questions, you may come across something like “Will the US Presidential Election be fully or partially postponed?” 

Questions will be reviewed by the Forecast team and edited for clarity, if needed. Users will be notified if their question is published.

At some point, the question will be determined as “settled,” based on an elapsed time period or because an event has occurred. For instance, if users were guessing when a vaccine would be released, and then it’s actually released, the questions around that topics would be “settled.”

Forecast’s polls are given aesthetically pleasing charts and graphs which can be shared outside the app. That means users could start posting these guesses and the crowdsourced responses to sites like Facebook, where the line between fact and fiction has already blurred. That could further complicate people’s understanding of what is already a complex topic: the COVID-19 pandemic.

Facebook users who see these shared “forecasts” may believe they have some basis in science and research, when instead, they are the result of a social polling app.

Of course, there is some fun in betting on world events and seeing if they turn out to be true, and there is even some value in organizing a wider community’s collective “best guesses” about a future event to gain an understanding of what people are thinking at a given time. Crowdsourced predictions have their place, as well. But spreading out specific, COVID-19 predictions to Facebook seems like an idea that’s fraught with potential problems and complications.

And Facebook’s goal here is only to test its own hypothesis — that a standalone, community-based predictions app that rewards a participatory audience with social credit will surface insightful voices and thoughtful discussions.

In the end, however, it seems like Facebook is looking for some angle that could prompt thought leaders to engage in meaningful discussions about subjects they know best on a Facebook platform. These sorts of discussions are difficult to have in Facebook’s comments section around a post — as comments, more often than not, are a place people go to troll, argue, threaten and otherwise derail a conversation. Forecast organizes these experts around a topic and allows them to debate. As a self-contained space with a vetted crowd of participants, that could be interesting. Making the data broadly shareable is an issue, however.

Facebook says the questions in Forecast will be moderated for clarity using Forecast’s own moderation guidelines and Facebook’s Community Standards. That means questions can’t mention death, sexual or violent assault of any individual, including public figures. (This isn’t meant to be some sort of new internet Death Clock, for example.) Hate speech isn’t allowed. Questions around illegal content or those involving personal information also aren’t permitted, along with other guidelines detailed here.

The Forecast app is live on the iOS App Store here.

 

 


Read Full Article

Facebook tests Forecast, an app for making predictions about world events, like COVID-19


Forecast, a new project from Facebook’s internal R&D group, NPE Team, is launching today to build a community around predictions. The iOS app will allow users to ask questions and then use in-app points to make predictions about what might happen in the future. Users can also create, discuss and view these crowdsourced predictions.

At launch, only invited participants in the U.S. and Canada will be allowed to make predictions and engage in conversations, while the app is in beta testing. But these predictions and related discussions will be publicly accessible on the Forecast website and made shareable.

Before today, Facebook tested the product internally with a small set of employees. Their initial forecasts will form the initial core content in the app at launch.

Starting now, Facebook will invite members of the health, research and academic communities to make predictions about the COVID-19 pandemic and its impact on the world.

At a time when Facebook and other major tech platforms are under fire for their role in aiding the spread of misinformation, fake news, propaganda, conspiracy theories, and other non-factual content presented as truth, an app focused on making “guesses” about the future seems ill-advised — however educated those guesses may be. This is particularly concerning because much of the app’s content will focus on guesses about COVID-19.

Forecast’s predictions may help show what people are thinking, but COVID-19 isn’t a game. To understand the world, scientists form a hypothesis, which is essentially an expanded form of an educated guess. But they don’t then crowdsource voting to determine if a hypothesis is true — they test, experiment, gather supporting data, try to prove and disprove the hypothesis, and ultimately aim to publish their findings and have them peer-reviewed.

The Forecast app turns the hypothesis into the end result, in a way. The app lets users make a forecast and explain their reasoning — in other words, form a hypothesis. But instead of doing the work to test the forecast, through the application of the scientific method, Forecast will track the votes a given question receives.

E.g. “When will the first COVID-19 vaccine candidate begin phase 3 trials?” or “When will most U.S. residents be treated with a COVID-19 vaccine?” In non-COVID questions, you may come across something like “Will the US Presidential Election be fully or partially postponed?” 

Questions will be reviewed by the Forecast team and edited for clarity, if needed. Users will be notified if their question is published.

At some point, the question will be determined as “settled,” based on an elapsed time period or because an event has occurred. For instance, if users were guessing when a vaccine would be released, and then it’s actually released, the questions around that topics would be “settled.”

Forecast’s polls are given aesthetically pleasing charts and graphs which can be shared outside the app. That means users could start posting these guesses and the crowdsourced responses to sites like Facebook, where the line between fact and fiction has already blurred. That could further complicate people’s understanding of what is already a complex topic: the COVID-19 pandemic.

Facebook users who see these shared “forecasts” may believe they have some basis in science and research, when instead, they are the result of a social polling app.

Of course, there is some fun in betting on world events and seeing if they turn out to be true, and there is even some value in organizing a wider community’s collective “best guesses” about a future event to gain an understanding of what people are thinking at a given time. Crowdsourced predictions have their place, as well. But spreading out specific, COVID-19 predictions to Facebook seems like an idea that’s fraught with potential problems and complications.

And Facebook’s goal here is only to test its own hypothesis — that a standalone, community-based predictions app that rewards a participatory audience with social credit will surface insightful voices and thoughtful discussions.

In the end, however, it seems like Facebook is looking for some angle that could prompt thought leaders to engage in meaningful discussions about subjects they know best on a Facebook platform. These sorts of discussions are difficult to have in Facebook’s comments section around a post — as comments, more often than not, are a place people go to troll, argue, threaten and otherwise derail a conversation. Forecast organizes these experts around a topic and allows them to debate. As a self-contained space with a vetted crowd of participants, that could be interesting. Making the data broadly shareable is an issue, however.

Facebook says the questions in Forecast will be moderated for clarity using Forecast’s own moderation guidelines and Facebook’s Community Standards. That means questions can’t mention death, sexual or violent assault of any individual, including public figures. (This isn’t meant to be some sort of new internet Death Clock, for example.) Hate speech isn’t allowed. Questions around illegal content or those involving personal information also aren’t permitted, along with other guidelines detailed here.

The Forecast app is live on the iOS App Store here.

 

 


Read Full Article

How to Use Hyperlinks in Google Sheets


This guide explains how you can easily create and manage hyperlinks in Google Sheets. An entire cell in the sheet, or specific text inside the cell, can be linked to external web pages. A cell can also contain multiple hyperlinks.

If you type a web page address in a Google Sheet cell, it is automatically converted into a clickable hyperlink.

Text converted into hyperlink

You can add anchor text to plain hyperlinks for more accessible URLs. Hover your mouse over the hyperlink and click the Edit icon. Now add the anchor text in the Text input box and click the green Apply button.

Alternatively, you may use the built-in HYPERLINK function in Google Sheet to create web links with (optional) anchor text.

 =HYPERLINK("https://www.labnol.org", "Digital Inspiration")

Add anchor text to hyperlink

It is also possible to include multiple hyperlinks inside a single cell of the Google Sheet.

Just type any text, include URLs in plain text and when you move the cursor out of the cell, the URLs are converted into hyperlinks.

Bonus Tip: While a cell with multiple links is selected, press Alt+Enter and all the links with open at once in new tabs.

Multiple hyperlinks in Google Sheet Cell

You can use the previous technique to edit multiple hyperlinks contained in a single cell and add anchor text.

Hover your mouse over a link in the cell, click the edit icon and change the Anchor text. Repeat this for all other links in the same cell.

Format Muliple URLs

Also see Secret Google Drive URLs.

Here are some snippets that will help you manage your hyperlinks in Google Sheets using Google Script macros.

const createHyperLinkWithFormula = () => {
  const link = 'https://www.labnol.org';
  const text = 'Digital Inspiration';
  const value = `=HYPERLINK("${link}", "${text}")`;
  const sheet = SpreadsheetApp.getActiveSheet();
  const range = sheet.getRange('A1');
  range.setValue(value);
};
const createHyperLinkWithRichTextValue = () => {
  const link = 'https://www.labnol.org';
  const text = 'Digital Inspiration';
  const value = SpreadsheetApp.newRichTextValue()
    .setText(text)
    .setLinkUrl(link)
    .build();
  SpreadsheetApp.getActiveSheet().getRange('A1').setRichTextValue(value);
};
const createMultipleHyperLinks = () => {
  const value = SpreadsheetApp.newRichTextValue()
    .setText('Google acquired YouTube in 2006')
    .setLinkUrl(0, 6, 'https://www.google.com')
    .setLinkUrl(16, 23, 'https://www.youtube.com')
    .build();
  SpreadsheetApp.getActiveSheet().getRange('A1').setRichTextValue(value);
};
const extractLinkFromFormula = () => {
  const sheet = SpreadsheetApp.getActiveSheet();
  const range = sheet.getRange('A1');
  const formula = range.getFormula();
  const [, url, , text] =
    formula.match(/=HYPERLINK\("(.+?)"([;,]"(.+?)")?\)/) || [];
  Logger.log({ url, text: text || url });
};
const extractMultipleLinks = () => {
  const urls = SpreadsheetApp.getActiveSheet()
    .getRange('A1')
    .getRichTextValue()
    .getRuns()
    .map((run) => {
      return {
        url: run.getLinkUrl(),
        text: run.getText(),
      };
    })
    .filter(({ url }) => url);
  Logger.log(urls);
};

6 Awesome Free Twitter Tools to Discover Insights, Analytics, and Shortcuts


Twitter tools

How do you find any user’s most retweeted or most liked tweets? How do you shut out the incessant noise on Twitter? These awesome, free Twitter tools are full of insights and shortcuts to make Twitter better.

Twitter is all about an avalanche of the latest and greatest posts, but you can’t easily find the top posts by a user, nor easily spot viral threads worth reading. These free Twitter web apps reduce the noise on the social network and help you find better content that’s worth your time.

1. FollowFly (Web): Find Most Retweeted or Most Liked Tweets for Any Account

FollowFly finds any Twitter user's tweets with the most retweets or most likes in the past year

Twitter has no built-in option to find which tweets of a user got the most retweets or most likes. You’ll need to use third-party apps for that, and FollowFly is the simplest among them.

Search for any user handle (with the @) in FollowFly. Now you can see their timeline and sort it by recent, top posts, most retweets, or most likes. Because of Twitter’s limited API, you don’t get a user’s full history. You can go back one week, one month, or one year at max.

You can also sign into your own account with FollowFly for a new way to browse your timeline. You can sort your own timeline’s tweets by most retweets or most likes, instead of relying on Twitter’s algorithm or the “most recent” option.

2. Affinitweet (Web): Discover Cool Twitter Insights About Yourself

Discover new insights into your Twitter profile with Affinitweet

Use your Twitter account to sign into Affinitweet to find insights you wanted to know about, and discover things you didn’t even know you wanted to find out. The website is completely free and doesn’t make you jump through any hoops. Here’s what you can test:

  1. Famous Followers: Amongst people who follow you, who have the most followers?
  2. Friendships: Check how connected you and a Twitter friend are.
  3. Top friends: Who are your best friends on Twitter lately?
  4. Valentine: Who’s the one person you’re most connected to on Twitter?
  5. Secret Crush: Who’s the one person most connected to you on Twitter?
  6. Hidden Twin: Who’s the most like you on Twitter?
  7. Stolen Kiss: Who wants to steal a kiss from you on a street corner?
  8. First to Follow: Compare yourself to another account, and find out who followed whom first, and when.
  9. Common Friends: Who do you and a Twitter friend follow in common?
  10. Tweet Rate: Compare how often you tweet with another user’s frequency.
  11. May Day: Who’s your best bouquet for this year?
  12. Halloween Duo: Who will you be most afraid of this year?
  13. Emoji Mood: Which emojis do you tweet the most?

By default, when you take any test, Affinitweet will try to tweet out the result. Make sure you disable that option, and tweet the results manually if you want to.

3. ThreadCache (Web): Discover the Best Twitter Threads Worth Reading

Discover Twitter threads worth reading at ThreadCache

Twitter’s 280 character limit doesn’t stop people from sharing longer posts, especially with Twitter threads to string together longer thoughts and deliver a narrative. ThreadCache is all about finding the best Twitter threads worth reading.

The default view shows the latest threads going viral on Twitter, based on how many people are talking about it. You can further filter categories like animals, arts and entertainment, business, design, life, health, politics, science, technology, news, and more. ThreadCache also has a search bar for keywords. And if you make or find an interesting thread, submit it to the directory.

Click the “read” button on any thread to open it in Twitter, where you can read the whole thing. For a better thread reading experience, you might want to pair it with Thread Reader or Threader, some of the best Twitter tools to discover tweets.

4. Less Noise (Web): Find the Most Frequently Posting Twitter Users You Follow

Find the Most Frequent Tweeters and block or mute them with LessNoise

Is Twitter getting too overwhelming for you? It might be because you’re following a few users who tweet too often. While Twitter encourages putting every small thought out there, you can cull a few people from your feed who post most frequently.

Log into Less Noise to find the most frequent posters on Twitter among the users you follow. You’ll get the username and their average tweets per day, in a list going from “noisiest” to least noisy. Open that username on Twitter and mute or unfollow them.

5. Secateur (Web): Block or Mute Twitter Accounts and Their Followers Too

Secateur lets you block or mute Twitter accounts and their followers too, to ensure you never see their tweets

Like other social media, Twitter can quickly become a negative and hateful place full of things you don’t want to read. It can even affect your mental equilibrium. Secateur lets you block or mute certain accounts, and also all of its followers, so you don’t have to see any of them in your mentions, timeline, or direct messages.

You can block or mute any account for a chosen period: three weeks, six weeks, three months, six months, one year, or forever. Choose whether you want to also block or mute its followers, so they aren’t bombarding your timeline and mentions.

By default, Secateur will also block or mute people you are already following. But you can whitelist those people by giving Secateur access to your follower list so that it only blocks people whose voice you aren’t expressly interested in hearing.

6. @this_vid (Web, Twitter): Easiest Way to Download Videos on Twitter

@This_Vid is the easiest way to download videos on Twitter

People are increasingly sharing great videos on Twitter, but they can just as easily be taken down by the user or the social network itself. If you want to download a video to preserve it, there’s nothing easier than ThisVid.

First, follow the account. When you want to download a video, simply reply to the tweet and mention @this_vid in the reply. In a minute, the account replies with a link to download the video.

All the videos you wanted to download are saved under your username on the ThisVid website. All videos are in the MP4 file format.

Follow the Unwritten Rules of Twitter

These tools will make Twitter a better experience, but so will simply knowing how to use the social network. You see, Twitter has a code of conduct that isn’t expressly clear. Transgressions don’t go down well within the community, so it’s best you understand the unwritten Twitter rules you’re probably breaking.

Read the full article: 6 Awesome Free Twitter Tools to Discover Insights, Analytics, and Shortcuts


How Google Uses Your Phone to Predict Traffic and Plan Trips


google-predict-traffic

Phones work diligently to help us with our daily life, so much so that sometimes we don’t even know what data it’s sending back to servers around the world. For example, did you know that your phone can be used by Google Maps to help predict traffic jams on the road?

Let’s explore how you’re helping Google without realizing it, and how to turn it off if you don’t like this feature.

How Google Knows Where You Are

You may have noticed that Google seems to know where you are, even though you don’t have Google Maps open. This is because Google Maps has a background service running that keeps tabs on your location.

What this does is beam your location back to Google which then records where you are and uses Google Maps to give you services related to your location.

The Google Maps Timeline is the best way to see this service in action. If you’ve kept all the location tracking settings enabled on your phone, you should see your past travels when you visit the timeline page. You can view individual days and see where you went during that time.

This is but one of the many technologies that explains how Google Maps works, and it’s through this that Google can predict traffic.

How Google Uses This Information for Traffic

This is all well and good, but how does this relate to traffic jams? How can Google predict where a jam is just by where your phone is?

Identifying User Location Via Google Maps

Let’s imagine everyone has Google Maps on their phone and has location tracking turned on. You’re at Google Maps HQ, and you can see a giant map which displays every phone’s location.

As long as someone hasn’t left their phone on the bus by accident, it’s safe to assume that every phone is being carried by someone. As such, the vast majority of the dots on the map represents a person.

From this information, you could tell which areas are congested via the number of dots within that space. If the map shows a huge congregation of location dots within a concert hall, it’s safe to assume an event is on. Likewise, you could watch a supermarket and see when it’s near-empty and when it’s packed by counting the dots inside the store.

Using This Location Data to Predict Traffic

With this in mind, you’d be able to spot traffic jams by the number of dots on the roads. People use phones in the car all the time, from GPS assistants to bored kids watching YouTube in the back. As a result, you’d be able to see the movement of cars on the road. Similarly, you could see when they’re not moving at all.

When a jam occurs, you’ll be able to roughly see how long the queue. You could also measure how slow the traffic jam is going by watching one dot and measuring how far it travels in a set amount of time.

This is a rough explanation of how Google can use the location data it receives to generate a traffic prediction. It looks for the location congestion from cars on the road and uses this to direct other Google Maps users away from the jam and onto faster routes.

Can People Abuse This Technology?

If you wanted to take advantage of this service, you could. You’d just need a lot of money and a strange motive.

Google Maps location tracking hit the news when an artist put 99 phones into a cart and pulled it down some roads. Each phone had Google Maps open with the navigation turned on, while meant they were all telling Google of their location.

While the roads were empty in real life, Google saw a massive fleet of “cars” moving down the street. As a result, Google Maps shows a red congestion warning wherever the cart went.

It’s funny to see how easy it is to trip up Google Maps like this, but there’s not much a cybercriminal can do with this. Not only does it need a lot of phones and setup, but the end result is that people simply avoid that road more often.

How to Turn Off This Feature

Not a fan of Google knowing where you are at all times? Don’t worry; you can turn this feature off and stop Google from tracking you.

To start, you want to log into your Google account’s activity controls page. This is a useful website that lets you see and control what Google stores about you, so be sure to keep it around.

Disabling Google Location History

If you take a look on this page, you’ll quickly find the setting for Location History. This keeps tabs on where you are using your phone’s GPS. As such, if you’re not a fan of Google tracking you, disabling this is a no-brainer!

Click the switch next to the setting’s name to disable this option.

Disabling the location tracking in Google Activities

Disabling Google Web & App Activity

However, we’re not out of the woods yet. You have only deactivated Google’s general tracking service, which stops features such as Google Maps Timeline from working. However, Google will still grab your location in order to improve their products; for example, when it recommends restaurants near you.

To turn this off, we need to disable Web & App Activity. If you look at the Google page describing this service, you can see why (emphasis ours):

What’s saved as Web & App Activity

Info about your searches and other activity on Google sites, apps, and services
When Web & App Activity is on, Google saves information like:

Searches and other things you do on Google products and services, like Maps and Play

Your location, language, IP address, referrer, and whether you use a browser or an app

Ads you click, or things you buy on an advertiser’s site

Information on your device like recent apps or contact names you searched for

Note: Activity could be saved even when you’re offline.

As such, we need to disable this service as well to take us fully off the grid. Click the switch next to its name to do so.

Disabling the web app trackingin Google Activities

Protecting Your Privacy From Google

Google uses location data from smartphones to pinpoint where people are, which can help others avoid crowded areas. Now you know how your phone helps others avoid traffic, and how to disable it if you’re not a fan.

Now that you know how to secure your phone’s privacy, how about enabling the essential privacy settings for Chrome and Chrome OS?

Read the full article: How Google Uses Your Phone to Predict Traffic and Plan Trips


Read Full Article

The Best Blue Light Blocking Glasses for 2020


blue-light-blocking-glasses

Digital displays are everywhere. Whether you watch TV, work on a laptop, or browse on your smartphone, you’re exposed to artificial light. Some research suggests that the blue light emitted from these devices could be disruptive to our health.

While you could set these displays to a softer night mode, there’s a growing number of people who opt for blue light filtering glasses instead. While the jury is still out on whether these are effective, if you’re interested in using a set, you have options.

We’ve rounded up some of the best blue light filtering glasses available today.

1. FEIYOLD Blue Light Blocking Glasses

FEIYOLD Blue Light Blocking Glasses FEIYOLD Blue Light Blocking Glasses Buy Now On Amazon $22.98 ($11.49 / Count)

If you’re after the best affordable blue light blocking glasses, opt for this two-pack of FEIYOLD Blue Light Blocking Glasses. The lightweight frame encloses two transparent lenses that block 99 percent of blue light (with wavelengths between 400nm and 440nm). Despite this, the lenses can pass through 93 percent of available light for an uninterrupted viewing experience.

The manufacturer claims that these glasses can reduce eye strain and make you sleep better. However, these are not medically prescribed glasses and aren’t a treatment for any underlying health issues. That said, two sets of glasses at this price make the FEIYOLD Blue Light Blocking Glasses a great value option. The frames come in two colors: black and a transparent white effect.

2. ANRRI AR0103 Blue Light Blocking Glasses

ANRRI Blue Light Blocking Glasses ANRRI Blue Light Blocking Glasses Buy Now On Amazon $25.95 ($25.95 / Count)

The ANRRI Blue Light Blocking Glasses are a stylish set of blue light blocking glasses for men. The lenses can prevent 90 percent of blue light and have an 18mm bridge. Interestingly, the glasses also come with a blue light for testing the effectiveness of the filter. There are no adjustable nose pads, so the fit is dependent on the bridge alone.

However, most reviewers find that the frames fit well and are comfortable to wear throughout the day. Although this set is designed for male wearers, the company also produces blue light blocking glasses for women, like the ANRRI 0208 Blue Light Blocking Glasses. To give you peace of mind, ANRRI offers a lifetime warranty on all of its glasses.

3. PROSPEK Blue Light Blocking Glasses

PROSPEK Blue Light Blocking Glasses PROSPEK Blue Light Blocking Glasses Buy Now On Amazon $30.07

Most blue light blocking glasses use non-magnifying plastic lenses with filters. That’s not the case with the PROSPEK Blue Light Blocking Glasses. The frame can be fitted with blue light blocking and magnifying lenses. You can order the glasses in varying editions of +0.5 steps up to +3.0 magnification.

Unlike some other options, the PROSPEK Blue Light Blocking Glasses don’t have a yellow tint to the lenses. This set looks like a designer pair of glasses, too, thanks to their well-designed frame. The glasses come with a lifetime warranty and gift box, making them ideal as a present as well.

4. AmazonBasics Blue Light Blocking Safety Glasses

AmazonBasics Blue Light Blocking Safety Glasses AmazonBasics Blue Light Blocking Safety Glasses Buy Now On Amazon $31.87 ($2.66 / Eyewears)

If you regularly undertake physical labor either at home or at work, consider the AmazonBasics Blue Light Blocking Safety Glasses. Even if you don’t have use for safety glasses, this 12-pack is incredible value. So, it might be the ideal choice for those prone to losing or damaging glasses as well.

These glasses are designed with practicality rather than style in mind, although they are suitable for both men and women. The orange lenses have an anti-fog coating so that you can use them in humid environments as well. The curved arms ensure they say tightly secured around your head.

5. Gudzws Kids Anti Blue Light Glasses

Gudzws Kids Anti Blue Light Glasses Gudzws Kids Anti Blue Light Glasses Buy Now On Amazon $14.99

The Gudzws Anti Blue Light Glasses are the best blue light blocking glasses for kids. The retro-style frames are available in four different colors, so there’s a choice to suit a range of styles. The frame is made from soft plastic, so they are comfortable to wear for long stretches.

While suitable for children between three and 12, they are ideal for kids up to nine years old. The lenses are coated in blue light blocking film, rather than integrated into the lens themselves. The Gudzws Kids Anti Blue Light Glasses come with a cleaning cloth and case for secure storage.

6. AIEYEZO Kids Blue Light Blocking Glasses

AIEYEZO Kids Blue Light Blocking Glasses AIEYEZO Kids Blue Light Blocking Glasses Buy Now On Amazon $19.99

If you’re after an alternative set of blue light blocking glasses for kids, try the AIEYEZO Kids Blue Light Blocking Glasses. While they are stylistically similar to the Gudzws option, the bridge is slightly curved, offering a better fit across the nose. The frame is made of flexible silicone, so they should be less likely to snap.

The frames include a non-polarized anti-blue light lens with a width of 45mm. The edition we’ve included here is for a single set of glasses, although AIEYEZO also offers them as a two-pack at a reduced price. Each set comes with a glasses rope to secure them when not in use.

7. Gamma Ray Optics Blue Light Blocking Glasses

Gamma Ray Optics Blue Light Blocking Glasses Gamma Ray Optics Blue Light Blocking Glasses Buy Now On Amazon $17.99

Many people prefer untinted lenses, especially for use throughout the day. However, if you are after a warmer light from the glasses, check out the Gamma Ray Optics Blue Light Blocking Glasses. These are designed specifically for helping you wind down before bed. The orange and amber-tinted lenses reduce blue light by 97 percent.

Depending on your preference, you may also appreciate that this set of glasses come with adjustable nose pads for a better fit. The frames are equipped with spring hinges, too, so they maintain a good fit around your ears. The Gamma Ray Optics Blue Light Blocking Glasses come with a cleaning cloth and case as well. Gamma Ray Optics also offers a 90-day money back guarantee and a lifetime breakage warranty.

The Best Blue Light Glasses for Your Eyes

In the pre-smartphone era, you’d shut down your computer for the day and have some screen-free downtime before bed. That’s not practical these days, so its best to make investments that can help you wind down, like these blue light filter glasses.

That said, glasses aren’t the perfect choice for everyone. Thankfully, there are software options if you find that spectacles aren’t working for you. To explore your choices, check out our comparison of blue light filter apps.

Read the full article: The Best Blue Light Blocking Glasses for 2020


Read Full Article