Compensating for information asymmetry

Photo by krakenimages on Unsplash

Everybody makes mistakes. However, we see 24/7 footage of only our life, which creates an information asymmetry: we know of 100% of our mistakes and much less of others’, giving rise to feelings of “I am constantly making mistakes, I am not worthy” on the one hand, and infallibility of others on the other. This is exacerbated by the fact that people often try to hide, deny, or excuse away their mistakes.

Feeling especially “prone to mistakes” is not a good place to be, regardless of whether it is true or not. …

Color cells based on the group their content belongs to or whether it is above a given threshold

We, humans, are a visual species: we get most of the information from sight, compared to any other sense. It is especially true for cases when we deal with large quantities of information: we are not computers and need to differentiate and stratify data to make sense of it.

Here formatting data helps a lot. You can change the appearance of data based on its content: value, date, etc. However, out of the box, conditional formatting is static. You always have to change the rule itself to change a threshold or other condition. It is relatively easy if there is…

How to build spreadsheets faster, with fewer bugs, and change them later with ease

Spreadsheets are used for both personal and business needs with unrivaled success to accumulate, analyze and visualize all kinds of data. However, as with any powerful tool, it is important to use spreadsheets right. With great power comes g̶r̶e̶a̶t̶ ̶r̶e̶s̶p̶o̶n̶s̶i̶b̶i̶l̶i̶t̶y an opportunity to make a great mess.

Broadly speaking, apart from creating a functioning spreadsheet, every spreadsheet builder has three additional goals:

  1. Build spreadsheets fast. With pressing business needs, it goes without saying. If you can spend less time with the same or even better result, you should.
  2. Minimize the number of bugs in a given spreadsheet. Unfortunately, spreadsheet errors…

Stan T

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store