Unintended consequences often catch us off guard despite their predictability. The moment they occur, we gasp in shock, shake our heads, and look at each other in wide-eyed horror at this thing that just happened that we could never ever ever have anticipated.
Yet, when (if) we do an After-Action Review, we often realize that these consequences were not entirely unforeseeable. In fact, had we anticipated them, we might have made different decisions.
The Unintended Consequences of Spreadsheets
In 1800 BCE, ancient Babylonians started recording data by scratching grids and columns onto clay tablets, and the spreadsheet was born. Over the millennia, we went from clay tablets to papyrus to parchment and then paper.
Fast forward to 1963 when R. Brian Walsh of Marquette University ported the Business Computer Language (BCL) program to an IBM 7040, and electronic spreadsheets became a reality. The introduction of VisiCalc by Apple in 1979 revolutionized spreadsheet capabilities, followed by Lotus 123 and Microsoft Excel. Today, spreadsheets are ubiquitous in education, business operations, financial markets, budgeting, and even personal inventories.
Unintended yet predictable consequences
While spreadsheets have undoubtedly enhanced efficiency and accuracy compared to traditional methods like clay tablets or hand-drawn tables on parchment, their ease of use has inadvertently led to complacency.
We stopped engaging in a multi-millennial habit of discussing, debating, and deciding before making a spreadsheet. We started flippantly asking people to create spreadsheets and providing little, if any, guidance because “it’s easy to make changes and run scenarios.”
This shift resulted in a reliance on automated models and a lack of shared assumptions or analytical rigor in decision-making processes.
Of course, these behaviors were never intended. They were, however, very predictable.
93% of Human Behavior is predictable.
Research spanning disciplines as varied as network scientists, anthropology, neuropsychology, and paleontology shines a light on how truly predictable we are.
Emotions before Reason: Ask someone if they make decisions based on their motivations, aspirations, and fears and use data to justify the decisions, and they’ll tell you no. Ask them the last time someone else made a decision that “made no sense,” and you’ll listen to a long list of examples.
Small gains now are better than big gains later: Thoughtfully planning before using solutions like spreadsheets, word processing, email, and instant messaging could save us time at work and help us get home 30 minutes earlier or work a few hours less on the weekend. But saving a few seconds now by brain-dumping into Word, setting up a “flexible” spreadsheet, and firing off a text feels much better.
Confidence > Realism: We’ve all been in meetings where the loudest voice or the most senior person’s opinion carried the day. As we follow their lead, we ignore signs that we’re wrong and explain away unexpected and foreboding outcomes until we either wake up to our mistakes or adjust to our new circumstances.
Predict the 93%. Create for the 7%
Acknowledging the predictability of human behavior is not an endorsement of stereotypes but a recognition of our innate cognitive processes. By incorporating this understanding into design, innovation, and decision-making processes, we better anticipate potential outcomes and mitigate unintended consequences.
While 93% of human behavior may follow predictable patterns rooted in evolutionary instincts, focusing on the remaining 7% allows for the exploration of unique behaviors and novel solutions. By embracing both aspects of human nature, we can navigate challenges more effectively and anticipate a broader range of outcomes in our endeavors, leading to informed decision-making and value creation.
Now, if I could only get Excel to stop auto-converting numbers into date/time format.