Submitted by TravellingTabby t3_10p4xat in dataisbeautiful
TravellingTabby OP t1_j6i9p1q wrote
All of the data was collected in Excel. I then used Excel to create the tables (with conditional formatting), and used Photoshop to compile everything together into one graphic (inspired by this recent post)!
The 'Fun Facts' were just a quick little analysis I did to give some extra context. I collected the same data in 2021 but never did anything with it, so it was neat to compare 2022 to 2021 in some areas. Also, my flight stats came from myFlightradar24.
The sleep/step data was tracked by Apple Health, but everything else I just entered manually. I had a row in my spreadsheet for each day, and I'd try to fill it in every night (but normally I'd do it once every two or three days, relying on memory).
I actually have over 30 different metrics in the spreadsheet! I didn't include them all in the graphic, but here are some more fun facts from those missing ones:
- I had 222 showers in 2022 (every 1.6 days), which is double what I had in 2021
- I had 193 poops in 2022 (every 1.9 days), which is up 38% from 2021
- I spoke to around 403 people all year (up from 110 in 2021), 333 of which were strangers
- I watched 30 movies, 5 TV shows, and 6 documentaries
- I played 15 games (9 Xbox One, 1 Xbox 360, 3 PC, 2 Oculus Quest)
- I gained 4.6lb all year. My max weight was 212.6lb, and my min weight was 198.8lb
And just some context for myself, I'm 27/M in the West of Scotland. I have a lot of friends/family in the USA and like to visit as much as I can. I couldn't visit at all in 2020/2021, so I was catching up on visits this year, which explains some of the wild differences compared to 2021 (I wasn't away from home at all in 2021). I was studying (from home) up until May, but haven't been doing much since. I'm going to spend most of 2023 travelling around different places before starting work.
tdriser t1_j6kodmo wrote
Wow, that’s so few poops!
Expert-Passage162 t1_j6kybx9 wrote
I'm super curious what all of the metrics are!
The_Ismand t1_j6mgwuw wrote
I was about to ask where the hell you get that many rainy days evenly distributed across the year and outside a rainforest.
TravellingTabby OP t1_j6n43vy wrote
Yeah, I got most of my sun away from home this year. From the tropical paradises of Oregon, Alaska, New Jersey, and Virginia. Don't need to bother with Spain or Portugal, just going nearly anywhere else will be a sunny break.
StevenTM t1_j6nehsk wrote
How did you get away with showering on average every three days for a whole year? I mean, i don't shower daily, but why did you shower so rarely in 2021 compared to 2022?
TravellingTabby OP t1_j6oacxl wrote
In 2021 I was volunteering less, studying more (from home), and didn't go on any holidays. As a result, I only went outside on 129 days. I only really shower before going out somewhere (or having people visit me), so it was linked to that.
updownsidewayz t1_j6no2ds wrote
cool thank you was wondering how you collected this data and made the graphics
Viewing a single comment thread. View all comments