TIL: Conditional sum product in Google Sheets

=SUMPRODUCT(D5:D1009="",C5:C1009,B5:B1009)

Just learnt an easy way to do conditional SumProduct1 calculations in Google Sheets2.

In above example, I wanted the SumProduct of values in columns B and C, when the respective cell in column D was empty.

The solution is to simply introduce the conditional column as another input, with the condition stated in the input.

Sheets does the SumProduct calculations, with each true as 1, and false as 0, thus making it a Conditional SumProduct :)

Continue reading TIL: Conditional sum product in Google Sheets

Biometrics – to identify, not authorise

Biometrics are your username, not your password.

This tweet by Koushik made a lot of sense on first reading. But I couldn’t place my finger on why I agreed with it. Until I read the paragraph below:

All ‘passwords’ should be replaceable. If your credit card gets stolen, you can block it and get a new card. If your Aadhaar number and fingerprint are leaked, you can’t change it, you can’t block it.

Pranesh Prakash in HT

That clinches it for me.

If my password gets stolen, I can reset it to something new, something stronger.

What do I do if my fingerprint is my password? Can’t get a new fingerprint.

Can’t get a new retina, or DNA either. And they’re all a fair bit easier to steal than a strong password.

Sure, use biometrics to identify if you want. But follow the identification with authentication (with a password, or more), before giving that identity any authority.

Some feedback: WordPress reader on desktop

Navigation in reader

  • There are no visible cues hinting at ability to navigate from one expanded post to the next (or previous).
  • Navigating back to the post list (using back button), and then to next post makes it slow, and click heavy.
  • Keyboard shortcuts work, but there are again no visible cues indicating even their presence.

Keyboard shortcuts

  • No visible hints that any keyboard shortcuts exist
    • Keyboard shortcut discoverability is solely by trial and error, or ‘Google’
    • Traditionally, pressing ‘?’ (in, say, GMail or Pocket) brings up relevant shortcuts modal. Doesn’t work in reader.
    • One suggested hint could be to place a keyboard icon next to the help (?) icon, at the bottom, in the left navigation bar.
  • Navigation shortcuts
    • j/k navigate to next/previous post as expected. However, the more ‘lay’ user-friendly left-arrow/right-arrow versions don’t.
    • esc key works the same as browser’s back button – navigating back through history stack (i.e. going back to last viewed post).
      • A better (expected) implementation would be to jump out of expanded-post view to the posts list view, ideally scrolled to the last viewed post.
  • Like keyboard shortcut, l, works as expected. Adding f as an additional activator would be useful – a lot of platforms use favourite as an alternative to like, and some users may be more behaviourally trained to press f instead of l

Mind the gap

I’ve been helping my neighbour, David, with his visa application1. Spending time with him over a couple of evenings gave me a chance to get to know him better. It’s been quite a learning experience for both of us. Their life2 is quite a contrast to ours, in areas we wouldn’t even think twice about3.

  • We live around our smartphones – are probably too addicted to them.
    He keeps his mobile phone in his car, doesn’t even get it to the house.
  • He provides his landline as the only contact number.
    We didn’t even bother with getting a landline when we moved to this house 4 years ago.
  • He doesn’t know how to use a computer. His wife got a new computer as present last year. They’re still to ‘open it’, because she hasn’t gotten up to it yet.
    We spend many days solely with them ‘computers’.
  • Continue reading Mind the gap

Android Keyboards in India

Why don’t Android phones sold in India come with Google’s Indic keyboard set up as default?

Specially for phones that don’t ship with proprietary/3rd-party keyboards, doesn’t it make a lot of sense to pre-install Indic keyboard over the default English keyboard?

It’s such a small step, yet can be quite a big enabler for the users (and, even, possibly a differentiator) – using the power of defaults to deliver a better user experience!

Why tweetstorms, not blog posts

The other day my wife complained, like many of us Twitter users have often done:

Why do people write these long tweetstorms, instead of writing a blogpost?

I blog. And I write tweetstorms. And the answer to that question, for me, is in three factors – reach, effort, and ephemerality. Continue reading Why tweetstorms, not blog posts