TravellingTabby

TravellingTabby OP t1_j6kjt1l wrote

I just collect it in a spreadsheet. There is a column for each metric, and a row for each day of the year. I try to fill it in every night before bed, but normally I'll do it once every two or three days. It only takes a couple of minutes to fill in!

Some of the columns I'll only fill in once a week. That is stuff like hours slept and steps taken, where all I do is enter the values on the health app on my phone.

3

TravellingTabby OP t1_j6ivp01 wrote

Nothing major, just lots of little things! Like I probably shouldn't nap so much, and I shouldn't see flossing as something you only do on weekdays. I drink more than I thought I did, and some of the health issues (like dry eyes) bother me a lot more often than I thought they did.

Comparing 2021 to 2022 was the most interesting part though. It is a bit skewed as in 2021 I was at home all year, and in 2022 I spent a third of the year away from home. But I'm hoping in the future I'll be able to compare one year to the next and spot any big changes.

Although for the most part it is useless information. I just love seeing different stats about myself, so it is fun to keep track of it all.

17

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.

65