My rules for making great spreadsheets (in Google Sheets or Excel)

1) Round numbers: use "decrease decimal point" or "format" to automatically round numbers to the greatest number of decimal points that are truly useful (so 0.15, not 0.15121215 and 32%, not 32.42%). 2) Set units: use the "format" feature to make percentages into actual percentages (ending in %), to make dollar figures into actual dollar figures (starting with $), and so on. This makes it easier to interpret figures at a glance. 3) Use formulas: anything that can be calcul...
More

Seven reasons why you could be defining a concept ineffectively

Photo by icon0.com via Pexels
Note (December 16, 2022): This piece is cross-posted from the Clearer Thinking blog, where it appeared on March 2, 2021. Can a chosen definition be "wrong"? No. If you choose a definition, then you can define a sound or series of characters to mean whatever you want them to mean. For instance, if you wanted, you could declare that whenever you say "phloop," you mean one of those little paper umbrellas that are sometimes found in PiƱa coladas. That would be weird, but it wouldn't be ...
More