planet-earth-calculation-universe-life-everything

The other day I made the coolest spreadsheet.

Have you ever heard someone say that sentence before?

Spreadsheets represent everything businesslike, efficient, exact, un-abstract and uninteresting. To most people anyway. There is something cool about how the cells all link together and update automatically en masse, but in most cases, spreadsheets are regarded as a non-addictive alternative to sleeping tablets.

But the other day I made one that was like actually really cool.

My spreadsheet isn’t the usual kind of ‘cool’ spreadsheet either—it wasnt the shady accounting for some mafia crime syndicate nor the results of a secret government experiment, it’s called everything-calc.xlsx and it’s a calculation of my life, the universe and everything.

(‘my’ refers to not dLook but the author who technically isn’t allowed to use the personal pronoun for good reason.)

It started off as an attempt to plan out the rest of my life (age 20 onwards)—with a focus on money and time. How much would I have to work to live comfortably, and how much time would that leave me? Then, out of that time left over, how much would I actually have to spend on recreation and my hobby (which is writing)? This depends on several time-consuming factors. After completing this first stage of the spreadsheet you can imagine that there were already numerous rows of data exploring the various branching possibilities–

  • Cost of living per possible city ($)
  • Yearly income per possible job and position ($)
  • Neccessities (hr):
  • Exercise and stretching
  • Morning routine
  • Sleeping
  • Family
  • Hangovers
  • Other
  • Education (hr)
  • Etc.

In one or two hours I had managed to map out my entire life. More or less…

Some anxieties about entering the real world were assuaged. Some were not…

Some interesting/alarming results were (for a 20yo Aus Male):

  • Life expectancy:

 

Life expectancy (days) 350640
Life expectancy (hours) 8415360
Life expectancy (waking hours) 5259600

 

  • Free time (left in life depending on occupation):

 

Occupation Left in waking life (hours)
None 5070572.979
Private tutor 4160424.536
Copywriter 3648246.403
English teacher in China 4569638.435

 

The strange effect of looking at a stat that says you have millions of hours of life left is whether to rejoice at how much time it is when all added up like that, or whether to anguish at how finite it is, when you can view it all in one figure. Don’t read on if you’re prone to existential crises.

I was now analysing figures with massive implications on my life and my way of thinking and I realised the power of spreadsheets. So I decided to take it to the next level…

I added a new section called ‘Humanity’, and I started putting my own stats in the context of humanity as a whole. Humanity currently and throughout all of history…

Humanity:
World population 7300000000
Humans who have ever lived 1.07E+11
World population/ humans who have ever lived 0.068224299
Thoughts per day 70000
Thoughts per year 25567500
Thoughts per lifetime 2045400000
Global life expectancy 71
Thoughts per World population per lifetime 1.32516E+19
My thoughts per lifetime/ World population thoughts per lifetime 1.54351E-10
Thoughts per Humans who have ever lived 9.57503E+19
My thoughts per lifetime/ Thoughts per Humans who have ever lived   2.13618E-11
Global wealth 2.41E+14
My wealth (5/1/16) XXXXX
My wealth/ Global wealth 1.34855E-10

 

[Note: referencing is scant to nonexistent because this was originally intended as a personal document]

The perspective is mindboggling. Humans today versus humans who have ever lived, my thoughts per lifetime, my total thoughts versus those of all humans ever and global wealth versus my meagre (but still very First World) slice. It makes you think:

  • Out of 1.32516E+19 thoughts, all the things we know have been created. But only the smallest fraction of those thoughts must have been truly original and even less would have been actualised. How many times was a lightbulb imagined before Thomas Edison invented it?
  • Imagine if all the world’s wealth was actually spent rather than stored in banks. The price of a cucumber would skyrocket to thousands of dollars and only the world’s richest people would survive unless drastic change was precipitated.
  • But most of all: I really aren’t as significant as I think I am…

Lone_person_in_Millennium

There’s also some interesting calculations of the time and proportion of time spent at each stage in life e.g. childhood, each decade, adulthood, old age.

Then the next logical step was to extend my spreadsheet from one of existential despair into one of abject doom. The next section is called ‘The Universe’—a comparison of myself to the unfathomable proportions of the universe yielding stats that are so large that if they were comprehended, they would have you screaming into the void…

The Universe:
Size of the (observable) universe (km) 8.8E+23
Mass of the (observable) universe (kg) 1E+53
My mass (5/1/15) (kg) 58
My mass/ Mass of the universe 5.8E-52
Age of the universe 13820000000
My age/ Age of the universe 1.44718E-09
My Life Expectancy/ Age of the universe   5.78871E-09

 

That’s the feeling you get floating out in space abandoned by your vessel with nothing but infinite darkness on all sides.

To understand the scientific notation:

Size of the observable universe = 8.8E+23 = 8.8*10^23 = 880000000000000000000000km

Versus you who aren’t a measly kilometer in length.

But then, just when all hope of mental stability was lost, I added a final section: ‘Chance of having this life’. Irrespective of how many other people have lived, are living; how much matter in the universe and how much emptiness, how fortunate am I to be living this life?

overpopulation

Chance of having this life: 7.54561E-28
Vs Global: 0.0001106
1st World Country 0.1644
Income 0.015
Good health 0.897
Intelligence XXX
Vs Humanity: 0.068224299
Era 0.068224299
Vs All Species: 1E-22
Animals that have ever existed   1E-22

 

If you got all the animals to ever exist, including humans and put them down a filter that removed all the non-humans, all the less intelligent, less healthy, lower income and non-First World, only 7.54561E-28 of the total would come out the other side. A lot of readers of this article will be at or near or well above my degree or fortune so reflect on that number next time you get down about some First World, non-health-related, human problem. If you’re a regular Australian like me, this is the chance that you were born into these circumstances:

0.000000000000000000000000000755

You are the 0.0000000000000000000000000754561429906542%.

The chance of winning the lottery twice in a row (at 292 million to one odds) is:

0.0000000000000000117

If you would like a head start on creating your own everything-calc.xlsx, here’s a version of mine stripped of personal information. It requires stating that the spreadsheet could be improved immensely by using a database structure, even using straight code, but it saved me more time just to put up with some redundancy:

https://app.box.com/s/3wbz9x6vpdnh1bqvt4nfz25ou0u0eqeh

Leave a comment